Skip to content

Instantly share code, notes, and snippets.

View waldoj's full-sized avatar

Waldo Jaquith waldoj

269 followers · 20 following
View GitHub Profile
@waldoj
waldoj / va_scc_lp_address.csv
Created September 3, 2014 16:12
Sample messy address data for https://github.com/datamade/us-address-parser/issues/16
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 6 columns, instead of 5. in line 1.
,street-1,street-2,city,state,zip
Suite 300,11350 Random Hills Road,Fairfax,VA,22030
3625 CORNELL ROAD,,FAIRFAX,VA,22030
3625 CORNELL ROAD,,FAIRFAX,VA,22030
1330 Mercer Lane,,McLean,VA,22101
Suite 225,333 South Glebe Road,Arlington,VA,22204
71 WEST FIRST AVENUE,POST OFFICE BOX 430,ALBERTA,VA,23821
5221 INDIAN RIVER RD,,VIRGINIA BEACH,VA,23464
1045 COFFEE RD,,LYNCHBURG,VA,24503
1919 GABLES LANE,,VIENNA,VA,22182
@waldoj
waldoj / virginia-tmsm.csv
Created October 24, 2014 15:04
Every trademark and service mark registered with the Virginia State Corporation Commission, as of October 23, 2014.
type file_number term
SM 6185 "Joe D. Roofer" (& design)
SM 8482 "The Original Home of Brunswick Stew"
SM 5322 "Warren-ty" Services
SM 8935 $3.00 Car Wash Free Vacuums TLC (& design)
SM 10584 & Live It Now (& design in color)
SM 7482 1-800-STARNES
SM 11064 1-888-LOCK-U-UP
SM 7888 1st Choice women's health center (& design)
SM 3070 1st Step Financial
@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 / va-transportation-feeds.txt
Created February 28, 2013 03:28
GeoJSON files for real-time Virginia transportation data.
These are the data sources that drive the 511virginia.org mapping site.
http://www.511virginia.org/data/icons.cameras_inactive.geojson
http://www.511virginia.org/data/geojson/icons.inactive_construction.geojson
http://www.511virginia.org/data/icons.cameras.geojson
http://www.511virginia.org/data/geojson/icons.ord_dms_active.geojson
http://www.511virginia.org/data/geojson/icons.scheduled_bridge_opening.geojson
http://www.511virginia.org/data/geojson/icons.construction.geojson
http://www.511virginia.org/data/geojson/icons.incident.geojson
http://www.511virginia.org/data/geojson/icons.weather.geojson
@waldoj
waldoj / rs_architecture.svg
Created February 16, 2018 03:59
A diagram of Richmond Sunlight's architecture.
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 / scc_subscribers.md
Last active April 19, 2016 06:27
Virginia State Corporation Commission database subscribers.

The Virginia State Corporation Commission (SCC) charges for bulk data of corporate registrations—$150/month for weekly updates, with a minimum three-month contract. I asked them for a list of their customers for this service. They are as follows:

Dun & Bradstreet
899 Eaton Ave.
Bethlehem, PA 18025

Seisint, Inc. (LexisNexis)
6601 Park of Commerce Blvd.
Boca Raton, FL 33487

@waldoj
waldoj / spam_template.txt
Created January 10, 2014 20:28
A blog spammer failed to parse her variables, and sent me the raw content. I thought it was interesting.
{
{I have|I’ve} been {surfing|browsing} online more than {three|3|2|4} hours
today, yet I never found any interesting article like yours.
{It’s|It is} pretty worth enough for me. {In my opinion|Personally|In
my view}, if all {webmasters|site owners|website owners|web owners} and bloggers made good content as you did, the
{internet|net|web} will be {much more|a lot more} useful
than ever before.|
I {couldn’t|could not} {resist|refrain from} commenting.
{Very well|Perfectly|Well|Exceptionally well} written!|
{I will|I’ll} {right away|immediately} {take hold of|grab|clutch|grasp|seize|snatch} your {rss|rss feed} as I {can not|can’t} {in finding|find|to find} your
@waldoj
waldoj / blog-entry-changes.md
Created November 22, 2013 19:52
Changes to @benbalter's recent blog entry.

The internet has a particular way of doing things. It's an ethos driven by a desire for resilience, for interoperability, for speed and efficiency — for preferring pragmatism over perfection. There's an unspoken set of rules born out of the hacker ethic. It's about elegant solutions, not over engineered ones, and it's what makes the internet what it is. Put another way, the internet forces us to not simply to press upload, but to reimagine desktop technologies as potential vehicles for collaboration.

There's been some talk recently, about the promise of using GitHub for data, with the excitement for the platform's disruptive potential being counterbalanced by criticism that there are use cases for which it's not ideal. That's going to be true for any technology, and like any technology, you don't solve for scale on

@waldoj
waldoj / sbe_changelog.csv
Created November 8, 2013 14:54
Virginia State Board of Election Changelog. A look at how the SBE shares news of the changes that they make to vote tallies after elections, as they continue to refine their data.
We can't make this file beautiful and searchable because it's too large.
"ElectionName","ResultsTypeSortOrder","ResultsType","LocalityCode","LocalityName","CAPName","PrecinctCodeValue","PrecinctCodeName","CongressionalDistrictCodeValue","CongressionalDistrictCodeName","OfficeName","BallotName","TotalVotes","EffectiveDate","ExpirationDate","ChangeReason","ChangeComments","CreateDate","CreateUser","LastChangeDate","LastChangeUser"
"2013 November General","20","Provisional Votes Counted","001","ACCOMACK COUNTY"," "," "," "," "," ","Mayor - Special","Jack J. Pierson","0","2013-11-06 18:24:54.887000000","","Reported wrong from precinct","","2013-11-06 18:24:54.887000000","pwhite","2013-11-06 18:24:54.887000000","pwhite"
"2013 November General","20","Provisional Votes Counted","001","ACCOMACK COUNTY"," "," "," "," "," ","Mayor - Special","WriteIn","0","2013-11-06 18:24:54.903000000","","Reported wrong from precinct","","2013-11-06 18:24:54.903000000","pwhite","2013-11-06 18:24:54.903000000","pwhite"
"2013 November General","20","Provisional Votes Counted","001","ACCOMACK COUNTY"," "," "