Skip to content

Instantly share code, notes, and snippets.

View waldoj's full-sized avatar

Waldo Jaquith waldoj

290 followers · 21 following
View GitHub Profile
@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 / keybase.md
Created March 11, 2014 18:12

Keybase proof

I hereby claim:

  • I am waldoj on github.
  • I am waldo (https://keybase.io/waldo) on keybase.
  • I have a public key whose fingerprint is 8CC4 1FF2 95C7 5E3B D30A 2CF2 E148 6A8B FA29 F947

To claim this, I am signing this object:

@waldoj
waldoj / virginia-servers.csv
Created April 11, 2014 04:04
The HTTP-header-reported server for every subdomain of virginia.gov, every agency website, and every college/university website. Where no "Server" header exists, the string "Unknown" is used.
http://abc.virginia.gov Apache
http://agencies.virginia.gov/ Microsoft-HTTPAPI/2.0
http://apa.virginia.gov/ Unknown
http://boa.virginia.gov/ Microsoft-IIS/6.0
http://bos.virginia.gov/ Microsoft-IIS/7.5
http://chr.vipnet.org/ Unknown
http://commonhelp.virginia.gov/ Unknown
http://commonwealth.virginia.gov/ Unknown
http://www.dbhds.virginia.gov/ Microsoft-IIS/5.0
http://dcjs.virginia.gov/ Microsoft-IIS/7.5
@waldoj
waldoj / rates.json
Created June 18, 2014 02:04
An imagined JSON response from a utility's API, specifying the rate per kWh for power now and over the next 24 hours. This provision of data would allow households to automatically adjust energy use in response to demand-based pricing.
[
{
"provider": "Dominion",
"url": "http://www.dom.com/",
"api_url": "http://api.dom.com/",
"documentation": "http://api.dom.com/docs/",
"state": "Virginia",
"rate": "12.3",
"units": "kWh",
"rate_units": "cents",
@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 / legislative_tags.csv
Last active November 13, 2015 14:26
A collection of 11,000 sets of crowdsourced, moderated tags, applied to legislation by hundreds of people over the course of eight years. Sourced from richmondsunlight.com.
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 3 columns, instead of 8 in line 1.
art,blacksburg,home rule
business,electricity,energy,regulation,results,scc,ssc,utility
business,electricity,energy,regulation,results,scc,ssc,utility
amendment,business,clean air,freedom,loss,marshall,newman,regulation,restaurant,sb,smoking
amendment,business,clean air,freedom,loss,marshall,newman,regulation,restaurant,sb,smoking
alcohol,bar,business,firearm,gun,regulation,restaurant,weapon
alcohol,bar,business,firearm,gun,regulation,restaurant,weapon
court,judge,supreme court,term limits
court,judge,supreme court,term limits
deed,foreclosure,hb,house,mortgage
@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 / industry_codes.txt
Created November 2, 2014 19:04
Every possible type of business, according to the Virginia State Corporation Commission.
GENERAL
ELECTRIC
TELEPHONE
GAS
WATER
WATER-SEWER
SEWER
RADIO COMMON CARRIER
BANKS AND CREDIT UNIONS
FEDERAL BANKS
@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
@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" : {