Skip to content

Instantly share code, notes, and snippets.

View dwillis's full-sized avatar

Derek Willis dwillis

View GitHub Profile
@dwillis
dwillis / president.csv
Last active December 17, 2015 20:19
OpenElections Results Spec Version 2
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
election_id division office_name office_district given_name additional_name family_name suffix name other_names party winner write-in votes pct
md-2012-11-06-general ocd-division/country:us/state:md President Barack Obama Barack Obama DEM TRUE 1218709 59.19
md-2012-11-06-general ocd-division/country:us/state:md President Mitt Romney Mitt Romney REP 792564 38.49
md-2012-11-06-general ocd-division/country:us/state:md President Gary Johnson Gary Johnson LIB 25303 1.23
md-2012-11-06-general ocd-division/country:us/state:md President Jill Stein Jill Stein GRN 13817 0.67
md-2012-11-06-general ocd-division/country:us/state:md President Tiffany Renee Briscoe Tiffany Renee Briscoe DEM TRUE 13 0
md-2012-11-06-general ocd-division/country:us/state:md President Dennis Knill Dennis Knill DEM TRUE 2 0
md-2012-11-06-general ocd-division/country:us/state:md President Matthew Lydick Matthew Lydick REP TRUE 17 0
md-2012-11-06-general ocd-division/country:us/state:md President Barbara A. Pr
@dwillis
dwillis / president.json
Last active December 17, 2015 20:19
OpenElections Results spec example version 2
{
"election_id": "md-2012-11-06-general",
"division": "ocd-division/country:us/state:md",
"office_name": "President",
"office_district": "",
"results": [{"given_name": "Barack", "additional_name": "", "last_name": "Obama", "suffix": "", "name": "Barack Obama", "other_names": [], "party": "DEM", "votes": 1677844, "percent": 61.97, "winner": true},
{"given_name": "Mitt", "additional_name": "", "last_name": "Romney", "suffix": "", "name": "Mitt Romney", "other_names": [], "party": "REP", "votes":971869, "percent": 35.9, "winner": false },
{"given_name": "Gary", "additional_name": "", "last_name": "Johnson", "suffix": "", "name": "Gary Johnson", "other_names": [], "party": "LIB", "votes":30195, "percent": 1.12, "winner": false },
{"given_name": "Jill", "additional_name": "", "last_name": "Stein", "suffix": "", "name": "Jill Stein", "other_names": [], "party": "GRE", "votes":17110, "percent": 0.63, "winner": false },
{"given_name": "", "additional_name": "", "last_name": "Other Write-Ins", "suff
recip type date amount
Ayotte candidate 9/30/2011 2500
Schilling candidate 4/25/2012 2500
Lugar candidate 9/2/2011 2500
Prosperity Action pac 12/14/2011 5000
IL GOP pac 2/11/2011 10000
WI GOP pac 3/19/2012 10000
Gardner candidate 12/31/2011 5000
Rehberg candidate 11/18/2011 5000
Biggert candidate 11/7/2011 2400
<html>
<table>
<tbody>
<tr>
<h4>There are 10 R members who voted Yes on the following roll calls:</h4>
<ul>
<li><a href="http://politics.nytimes.com/congress/votes/113/senate/1/167">Approves Ending Debate on Immigration Overhaul</a></li>
<li><a href="http://politics.nytimes.com/congress/votes/113/senate/1/164">S.744: On the Cloture Motion S. 744</a></li>
<li><a href="http://politics.nytimes.com/congress/votes/113/senate/1/160">Advances Border Security Proposal</a></li>
<li><a href="http://politics.nytimes.com/congress/votes/113/senate/1/146">Clears Way for Debate on Immigration Overhaul</a></li>
{"division": "ocd-division/country:us/state:md", "state": "MD", "elections": [{"absentee_provisional": true, "end_date": "2012-11-06", "source_url": "http://www.elections.state.md.us/elections/2012/election_data/index.html", "id": "md-2012-11-06-general", "special": false, "portal_url": "http://www.elections.state.md.us/elections/2012/results/general/index.html", "result_type": "certified", "note": "", "offices": [{"State Legislature": true}, {"Senate": true}, {"House": true}, {"President": true}, {"State Officers": false}, {"Governor": false}], "start_date": "2012-11-06", "reporting_levels": [{"County": true}, {"State Legislative": true}, {"Precinct": true}, {"Congressional District": false}, {"Race-wide": true}], "election_type": "general"}, {"absentee_provisional": true, "end_date": "2012-04-03", "source_url": "http://www.elections.state.md.us/elections/2012/election_data/index.html", "id": "md-2012-04-03-primary", "special": false, "portal_url": "http://www.elections.state.md.us/elections/2012/results/pri
Thursday 6245
Wednesday 6109
Tuesday 4985
Friday 4700
Monday 3406
Sunday 348
Saturday 308
@dwillis
dwillis / gist:7565184
Last active December 28, 2015 21:29
GOP Yes Votes on Motions to Recommit when GOP Held House Majority
bioguide last_name state votes earliest latest
J000255 Jones N.C. 111 8/4/1995 10/30/2013
M000941 Morella Md. 55 2/10/1995 9/25/2002
S001144 Shays Conn. 48 2/10/1995 9/27/2006
L000169 Leach Iowa 46 2/16/1995 9/27/2006
D000533 Duncan Jr. Tenn. 36 1/26/1995 11/14/2013
J000163 Johnson Conn. 31 7/31/1995 7/26/2006
C000243 Castle Del. 28 7/31/1995 5/25/2006
P000583 Paul Tex. 26 10/30/1997 9/13/2012
B000586 Boehlert N.Y. 25 2/24/1995 5/25/2006
"You should talk to me after I've failed," he said, one day after making a century.
"There's no point talking to me after I've got runs. You won't learn anything that way.
I don't think anything when I'm scoring runs. It's when I'm not scoring them that
you could learn something."
Dear FEC Data Users,
The FEC is in the process of migrating the imaging, electronic filing downloads, HTML presentation of filings and other applications that currently use the nictusa.com domain to FEC.GOV. We anticipate this migration to be completed by 12/31/2013. The table below includes one update to the set of the links sent on 11/22/2013. My original e-mail failed to include the new RSS URL.
Old URL New URL Full Application URL If Applicable Current Status of New URL
fecapps.nictusa.com/rss efilingapps.fec.gov/rss http://efilingapps.fec.gov/rss/display?input working
images.nictusa.com docquery.fec.gov multiple working
query.nictusa.com docquery.fec.gov multiple working
eqs.nictusa.com eqs.fec.gov http://eqs.fec.gov/eqs/searcheqs working
saos.nictusa.com saos.fec.gov http://saos.fec.gov/saos/searchao working
@dwillis
dwillis / gist:8210841
Created January 1, 2014 19:40
Austin American-Statesman newsroom databases, 1997.
APD -- Austin Police Department crime statistics, citywide and by census
tract.
AUTOSALE -- Records on all new vehicles bought and sold in the
five-county Austin area. Based on vehicle registrations, updated monthly by
Cross-Sell Marketing Inc.
BBPAY -- Major league baseball players' salaries in 1995 and 1996.
BEVTAX -- Mixed beverage taxes paid by each Texas bar and restaurant.
Based on monthly data from the state comptroller's office.
CENSUS -- Text, spreadsheet and database files from the U.S. Census
Bureau. Includes historic data (population numbers dating to 1900);