Skip to content

Instantly share code, notes, and snippets.

@waldoj
waldoj / charlottesville_ppp.csv
Created July 6, 2020 17:26
Charlottesville businesses that took PPP loans
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 16 columns, instead of 1 in line 5.
LoanRange,BusinessName,Address,City,State,Zip,NAICSCode,BusinessType,RaceEthnicity,Gender,Veteran,NonProfit,JobsRetained,DateApproved,Lender,CD
b $2-5 million,"ACCOUNTING RESEARCH & ANALYTICS, LLC DBA CFRA",d/b/a CFRA 675 PETER JEFFERSON PKWY STE 100,CHARLOTTESVILLE,VA,22911,,Limited Liability Company(LLC),Unanswered,Unanswered,Unanswered,,25,05/01/2020,"JPMorgan Chase Bank, National Association",VA - 05
b $2-5 million,APEX CLEAN ENERGY INC,"310 4th Street NE, suite 300",CHARLOTTESVILLE,VA,22902,541620,Subchapter S Corporation,White,Male Owned,Unanswered,,0,04/08/2020,Virginia National Bank,VA - 05
b $2-5 million,COMMONWEALTH COMPUTER RESEARCH INC,1422 Sachem Pl Unit 1,CHARLOTTESVILLE,VA,22901,541511,Corporation,Unanswered,Male Owned,Unanswered,,135,04/09/2020,"Bank of America, National Association",VA - 05
b $2-5 million,DESIGN ELECTRIC INC,1307 Carlton Avenue,CHARLOTTESVILLE,VA,22902,238210,Employee Stock Ownership Plan(ESOP),White,Male Owned,Unanswered,,0,04/07/2020,Virginia National Bank,VA - 05
b $2
@waldoj
waldoj / rs_architecture.svg
Created February 16, 2018 03:59
A diagram of Richmond Sunlight's architecture.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@waldoj
waldoj / virginia_dres.csv
Created September 8, 2017 19:08
Virginia DREs
name gnis
Frederick County, Virginia 1480124
Madison County, Virginia 1494590
Culpeper County, Virginia 1497831
Augusta County, Virginia 1480098
Bath County, Virginia 1673638
Rockbridge County, Virginia 1480166
Alleghany County, Virginia 1673675
Amherst County, Virginia 1480095
Lee County, Virginia 1496538
@waldoj
waldoj / mdb2sqlite.sh
Last active August 29, 2015 14:27
A modified version of the "Converting MS Access mdb files to sqlite" script posted at: https://gist.github.com/umrysh/4291298
#!/bin/bash
# Inspired by:
# http://nialldonegan.me/2007/03/10/converting-microsoft-access-mdb-into-csv-or-mysql-in-linux/
# http://cltb.ojuba.org/en/articles/mdb2sqlite.html
# https://gist.github.com/umrysh/4291298
# Dave's Modifications:
# Line 29: Added code to remove COMMENT and SET statements.
# Lines 32 to 41: Added code to handle primary keys.
@waldoj
waldoj / phacking.txt
Created May 17, 2015 01:28
I wrote this maybe 20 years ago. It was published in "2600."
Phacking: A Brief History of Hacking the US Postal System
By Alien Time Agent, Seraf and Waldo
Phacking (postal hacking, pronounced PAH-king) has enjoyed a glorious but
obscure history in the United States, beginning with the godfather of phacking,
Samuel Osgood. It wasn't until the summer of 1969 that Zip C0de brought
phacking into the public eye. While he was only 20 years of age at the time, he
had already caught the attention of authorities. For Zip C0de, C-Note, PhedEx and the
other brave pioneers, here is a brief history of hacking the US postal system.
@waldoj
waldoj / va_subdomains.csv
Created April 3, 2015 19:12
Every subdomain of Virginia.gov, as of April 3, 2015, as FOIAed from the Virginia Information Technology Agency (VITA).
name type value
1920160443.gosappsa CNAME domains.live.com
23bn-vdf CNAME 23bn-vdf.vhost.vipnet.org
23bn.vdf CNAME 23bn-vdf.vhost.vipnet.org
abcweb.abc CNAME gin.abc.virginia.gov
admanage-t.dmv CNAME dmv-pwr01-t.dmv.virginia.gov
admanage.dmv CNAME dmv-pwr01-p.dmv.virginia.gov
adms.vdot CNAME www27.vdot.virginia.gov
applyonline.abc CNAME gin.abc.virginia.gov
autodiscover.house CNAME autodiscover.outlook.com
@waldoj
waldoj / categories.csv
Last active August 29, 2015 14:16
Every Virginia State Corporation Commission industry category, with the number of businesses that self-report as a member of that industry.
Industry # of Businesses
Agricultural Cooperatives 137
Animal and Children's Welfare 66
Architects 563
Arts and Sciences 23
Audiologist 4
Bank & Insurance Agent 73
Banks and Credit Unions 474
Bank w/Limited Certificate 32
Benefit Corporations 48
@waldoj
waldoj / scc_data.txt
Last active August 29, 2015 14:11
A random sample of the Virginia State Corporation Commission's corporate registration bulk data
020369964COLONIAL POINT CIVIC LEAGUE, INC. 00200903200000000019910117VA001420 FLINTFIELD CRESCENT CHESAPEAKE VA23321000000000000CLARINE B. ROBERTS 1420 Flintfield Crescent Chesapeake VA233210000199101171236N00000000000 0 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
020712928BARGER INC 10201101030000000020090819VA00 00000000000000000BARBARA J IFKO
@waldoj
waldoj / elasticsearch.sh
Last active August 29, 2015 14:10
A demonstration of the Elasticsearch query that yields the error "Failed to find geo_shape field [location]]." This is a search of a collection of documents—each of which contain a pair of coordinates—against a pre-indexed collection of shapes. For simplicity's sake, I've included just one shape and just one document. This is with Elasticsearch …
# Remove old data
curl -XDELETE "http://localhost:9200/shapes"
curl -XDELETE "http://localhost:9200/businesses"
# Create shapes index, with mapping
curl -XPOST "http://localhost:9200/shapes/" -d '
{
"shapes" : {
"mappings" : {
"municipalities" : {
@waldoj
waldoj / Business Registrations.csv
Created November 11, 2014 20:01
Every business registered in Charlottesville in 2014.
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 15 columns, instead of 1 in line 6.
id,name,incorporation_date,street_1,street_2,city,state,zip,agent_name,agent_street_1,agent_street_2,agent_city,agent_state,agent_zip,agent_status
0773356,"WHITE SPOT INCORPORATED",2014-01-14,"1407 UNIVERSITY AVENUE",,CHARLOTTESVILLE,VA,22903,"DIMITRIOS WHITE SP TAVAMPIS","1407 UNIVERSITY AVENUE",,CHARLOTTESVILLE,VA,22903,DIRECTOR
F197333,"Mission Secure, Inc.",2014-08-29,"250 W MAIN ST STE 300",,CHARLOTTESVILLE,VA,22902,"DANIEL PARK","941 GLENWOOD STATION LANE","SUITE 302",ARLINGTON,VA,22901,OFFICER
F195959,"EXPEDITION TRUST COMPANY",2014-04-14,"310 4TH ST NE STE 102",,CHARLOTTESVILLE,VA,22902,"JACOB A LUTZ III","1001 HAXALL POINT 15TH FL","PO BOX 1122",RICHMOND,VA,23219,ATTORNEY
0780498,"NJW Properties, Inc.",2014-07-23,"120 BOLLINGWOOD ROAD",,CHARLOTTESVILLE,VA,22903,"NORMAN JEFFREY WOOLWORTH","120 BOLLINGWOOD ROAD",,CHARLOTTESVILLE,VA,22903,DIRECTOR
0774667,"Nitor, Inc.",2014-02-18,"1111 LOCUST AVENUE",,CHARLOTTESVILLE,VA,22901,"CRAIG W. MOORE","1111 LOCUST AVENUE",,CHARLOTTESVILLE,VA,22901,DIRECTOR
S4850