Skip to content

Instantly share code, notes, and snippets.

Avatar

Waldo Jaquith waldoj

View GitHub Profile
@waldoj
waldoj / virginia-tmsm.csv
Created Oct 24, 2014
Every trademark and service mark registered with the Virginia State Corporation Commission, as of October 23, 2014.
View virginia-tmsm.csv
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 Jul 6, 2020
Charlottesville businesses that took PPP loans
View charlottesville_ppp.csv
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 Feb 28, 2013
GeoJSON files for real-time Virginia transportation data.
View va-transportation-feeds.txt
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 Feb 16, 2018
A diagram of Richmond Sunlight's architecture.
View rs_architecture.svg
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View virginia_dres.csv
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 Apr 19, 2016
Virginia State Corporation Commission database subscribers.
View scc_subscribers.md

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 Jan 10, 2014
A blog spammer failed to parse her variables, and sent me the raw content. I thought it was interesting.
View spam_template.txt
{
{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 Nov 22, 2013
Changes to @benbalter's recent blog entry.
View blog-entry-changes.md

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 Nov 8, 2013
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.
View sbe_changelog.csv
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"
@waldoj
waldoj / vagrant-output.txt
Last active Dec 25, 2015
The output from Vagrant while firing up a State Decoded instance.
View vagrant-output.txt
# vagrant up
Bringing machine 'default' up with 'virtualbox' provider...
[default] Importing base box 'precise64'...
[default] Matching MAC address for NAT networking...
[default] Setting the name of the VM...
[default] Clearing any previously set forwarded ports...
[default] Creating shared folders metadata...
[default] Clearing any previously set network interfaces...
[default] Preparing network interfaces based on configuration...
[default] Forwarding ports...