Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am CaptainStabs on github.
  • I am stabs (https://keybase.io/stabs) on keybase.
  • I have a public key whose fingerprint is 6757 E141 87BC F648 5428 31B8 94F7 0B16 A19B 0CF9

To claim this, I am signing this object:

'''
Police code is based on the request that is sent when you press download on cityprotect.com
set start_year and start_month to the earliest year and month of data that is available
'''
import requests
from datetime import date
police_code = 780
This file has been truncated, but you can view the full file.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="/2013/DXR.axd?r=1_17,1_29,1_33,1_18,1_16,1_3,10_4-zcV_i" />
<!--[if lt IE 7]>
<script type="text/javascript">
window.location = "/MinRequirements.aspx"
</script>
<![endif]-->
<script src="https://maps.googleapis.com/maps/api/js?v=3&client=gme-sunridgesystemsinc&channel=CITRIMS&libraries=visualization" type="text/javascript"></script>
This file has been truncated, but you can view the full file.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="/2013/DXR.axd?r=1_17,1_29,1_33,1_18,1_16,1_3,10_4-zcV_i" />
<!--[if lt IE 7]>
<script type="text/javascript">
window.location = "/MinRequirements.aspx"
</script>
<![endif]-->
<script src="https://maps.googleapis.com/maps/api/js?v=3&client=gme-sunridgesystemsinc&channel=CITRIMS&libraries=visualization" type="text/javascript"></script>
@CaptainStabs
CaptainStabs / mess.py
Created July 14, 2021 02:42
scraper nightmare
import requests
from bs4 import BeautifulSoup, NavigableString, Tag
from urllib.parse import urlparse
import os
import pandas as pd
import csv
import sys
import doltcli as dolt
from doltpy.cli.write import write_pandas
import json
@CaptainStabs
CaptainStabs / blacklist.txt
Created August 27, 2021 19:12
Blacklist for Dolthub bounty
twitter.com, linkedin.com, instagram.com, youtube.com, tiktok, pinterest.com, reddit.com, www.wicz.com, www.krtv.com, www.foxnews.com, www.wsbtv.com, www.cnbc.com, www.cbs.com, www.nytimes.com, www.yelp.com, www.sacbee.com, www.ed-data.org, www.high-schools.com, www.publiccharters.org, www.publicschoolreview.com, http://elementaryschools.org, www.greatschools.org, www.thearcofil.org, usnews.com, www.guardianangelstaffing.com, www.wikipedia.com, www.mapquest.com, maps.google, www.countyoffice.org, nces.ed.gov, www.schooldigger.com, www.niche.com, http://patch.com, www.point2homes.com, www.zillow.com, ancestors.familysearch.org, www.timeanddate.com, www.neighborhoodscout.com, www.trulia.com, www.ancestry.com, www.wikitravel.com, www.wikiwand.com, handwiki.org, commons.wikimedia.org, www.wric.com, www.wifr,com, www.paec803.org, www.mcsd11.net, www.wnep.com, wwww.whas11.com, www.whsv.com, www.wymt.com, www.waze.com, www.wwrc.com, www.nola.com, www.southbendtribune.com, www.bdtonline.com, newsadvance.com, www.indy
@CaptainStabs
CaptainStabs / bruteforce.py
Created December 1, 2021 02:16
bruteforce for epal rooms
import hashlib
import requests
import json
from tqdm import tqdm
url = "https://chatroom.epal.gg/mobile/room/check_room_passwd"
headers = {
'sec-ch-ua': '" Not A;Brand";v="99", "Chromium";v="96", "Google Chrome";v="96"',
@CaptainStabs
CaptainStabs / fields2.txt
Created August 11, 2022 16:28
potential fields
BATHS_#_PERHAPS_SPLIT_INTO_HALF_AND_FULL
BEDROOMS
SQFT
UNITOFMEAS
SQFT_UNFINISHED
SQFT_FINISHED_BASEMENT
SQFT_FINISHED
SQFT_BUILDING_FOOTPRINT
SQFT_BASEMENT
SQFT_ATTIC
@CaptainStabs
CaptainStabs / combined.csv
Created September 10, 2022 20:12
sale price data for LA and Riverside CA
We can't make this file beautiful and searchable because it's too large.
property_county,sale_datetime,sale_price
LOS ANGELES,2020-02-21 00:00:00,9
LOS ANGELES,2020-03-31 00:00:00,550005
LOS ANGELES,2020-02-28 00:00:00,750007
LOS ANGELES,2020-04-16 00:00:00,949009
LOS ANGELES,2020-12-03 00:00:00,1500015
LOS ANGELES,2020-08-24 00:00:00,2900029
LOS ANGELES,2020-11-17 00:00:00,3213032
LOS ANGELES,2020-04-14 00:00:00,2700027
LOS ANGELES,2020-08-24 00:00:00,331003
@CaptainStabs
CaptainStabs / install.bat
Created February 8, 2023 15:07
invokeai_conda_installer.bat
@echo OFF
rem How to run a Python script in a given conda environment from a batch file.
rem from https://gist.github.com/maximlt/531419545b039fa33f8845e5bc92edd6
rem It doesn't require:
rem - conda to be in the PATH
rem - cmd.exe to be initialized with conda init
rem CREATE THE ENV PRIOR TO RUNNING THIS SCRIPT
rem Define here the path to your conda installation