Skip to content

Instantly share code, notes, and snippets.

View brentajones's full-sized avatar

Brent Jones brentajones

50 followers · 52 following
View GitHub Profile
@brentajones
brentajones / amtrak.csv
Created September 10, 2016 00:18
Amtrak stations, dumped from National Transportation Atlas Database (2015)
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 12 columns, instead of 2. in line 8.
X,Y,OBJECTID,STNCODE,STNNAME,ADDRESS1,ADDRESS2,CITY,STATE,ZIP,STNTYPE,STFIPS
-82.44084200005824,38.415404999740986,1,HUN,"Huntington, West Virginia",1050 8th Avenue,,Huntington,WV,25701,RAIL,54
-97.930060999815225,38.055858999992893,2,HUT,"Hutchinson, Kansas",North Walnut St & East 3rd Ave,,Hutchinson,KS,67501,RAIL,20
-85.469924999738907,43.395728999693631,3,HWC,"Howard City, Michigan",130 North Ensley St.,Sunoco Station,Howard City,MI,49323,BUS,26
-116.233170000495079,33.714751999705072,4,IDO,"Indio, California",NE Corner Hywy-111 and Monroe Street,Sunline Bus Stop,Indio,CA,92201-3917,BUS,06
-94.429297999503035,39.086975000296093,5,IDP,"Independence, Missouri",600 South Grand Ave.,,Independence,MO,64050-3564,RAIL,29
-86.160309000060295,39.762154000007172,6,IND,"Indianapolis, Indiana",350 South Illinois Street,,Indianapolis,IN,46225-1198,RAIL,18
-117.759192999657159,33.674767000296868,7,IRV,"Irvine, California",15215 Barranca Parkway,Irvine Transportation Center,Irvine,CA,92618,RAIL,06
-90.190598000297427,32.
@brentajones
brentajones / nicar15-solo-panel-tipsheet.md
Last active July 13, 2023 16:40

Want to team up?

We're gauging interest in forming some kind of an informal group of lone data journalists to help us better connect and collaborate. If you're interested, please fill out our form and we'll go from there. Thanks!

Solo data journalist tips and tools

Get to work

@brentajones
brentajones / US_State_Bounding_Boxes.csv
Created March 7, 2021 05:25 — forked from a8dx/US_State_Bounding_Boxes.csv
Bounding boxes for all US states and territories [NAD83]
STATEFP STUSPS NAME xmin ymin xmax ymax
1 01 AL Alabama -88.473227 30.223334 -84.88908 35.008028
2 02 AK Alaska -179.148909 51.214183 179.77847 71.365162
3 60 AS American Samoa -171.089874 -14.548699 -168.1433 -11.046934
4 04 AZ Arizona -114.81651 31.332177 -109.045223 37.00426
5 05 AR Arkansas -94.617919 33.004106 -89.644395 36.4996
6 06 CA California -124.409591 32.534156 -114.131211 42.009518
7 08 CO Colorado -109.060253 36.992426 -102.041524 41.003444
8 69 MP Commonwealth of the Northern Mariana Islands 144.886331 14.110472 146.064818 20.553802
9 09 CT Connecticut -73.727775 40.980144 -71.786994 42.050587
@brentajones
brentajones / blinkt-weather.py
Last active February 4, 2021 12:24
A weather status script for the Raspberry Pi and Blinkt module
import json, time, os.path
import blinkt, requests
status_colors = {'current':[1,1,1],'high':[1,0,0],'low':[0,0,1],'precip':[0,1,0]}
blinkt.set_clear_on_exit()
blinkt.set_brightness(.1)
def getForecast(key,lat,lng):
url = 'https://api.darksky.net/forecast/' + key + '/' + str(lat) + ',' + str(lng)
@brentajones
brentajones / doc-schema.txt
Created October 23, 2020 16:37
Working with Missouri Department of Corrections data
column,start,length
doc_id,1,8
last_name,9,18
first_name,27,12
middle_name,39,12
suffix_name,51,3
race,54,30
sex,84,30
birth_date,114,8
offender_assigned_place,122,8
@brentajones
brentajones / illinois_university_salaries_2018.csv
Created April 14, 2019 14:24
university total_salary
Chicago State University 26643267.07
Eastern Illinois University 39104962.4
Governors State University 27282001.7
Illinois State University 92108974.46
Northeastern Illinois University 38303671.72
Northern Illinois University 93582392.05
Southern Illinois University Carbondale 74338384.24
Southern Illinois University Edwardsville 64287003.19
Southern Illinois University School of Medicine 72072277.63
@brentajones
brentajones / 2017-06-23-stl-breweries.csv
Last active June 26, 2017 19:23
St. Louis Breweries, retrieved from https://stlbeer.org/breweries/ on 23 June 2017, addresses geocoded with geocodio
brewery street city state latitude longitude
2nd Shift Brewing 1601 Sublette Ave. St. Louis MO 38.621869 -90.280405
4 Hands Brewing Co. 1220 S 8th St. St. Louis MO 38.615315 -90.197549
4204 Main St. Brewing Co. 4204 W Main St Belleville IL 38.537825 -90.020468
Alpha Brewing Co. 1409 Washington Ave St. Louis MO 38.632528 -90.199615
Anheuser-Busch 12th and Lynch St St. Louis MO 38.631501 -90.19231
Augusta Brewing Co. 109 Main St Washington MO 38.560019 -91.011468
Bastard Brothers Brewing Company 2114 Penta Drive High Ridge MO 38.482386 -90.503135
Bat Creek Brewery 4 W Main St Bowling Green MO 39.341814 -91.193146
Big Muddy Brewing 1430 N 7th St Murphysboro IL 37.782423 -89.33199
@brentajones
brentajones / dailygraphics.applescript
Created June 7, 2016 15:13
NPR Dailygraphics Launcher for iTerm 2 3.0
tell application "iTerm"
activate
tell current session of current tab of current window
set newSession to (split vertically with same profile)
write text "cd ~/dailygraphics"
write text "workon dailygraphics"
write text "git pull"
write text "fab -l"
end tell
@brentajones
brentajones / keybase.md
Created October 9, 2015 16:12

Keybase proof

I hereby claim:

  • I am brentajones on github.
  • I am brentajones (https://keybase.io/brentajones) on keybase.
  • I have a public key whose fingerprint is E19A 112C 46B6 753E 7AD6 30AE 731E E79C C630 A7B6

To claim this, I am signing this object:

@brentajones
brentajones / Safari log - auto-reload
Created September 3, 2015 17:08
[Error] XMLHttpRequest cannot load safari-extension://com.evernote.safari.clipper-Q79WDW8YH9/31c567e4/_locales/en_us/messages.json. Cross origin requests are only supported for HTTP.
a (port.js, line 2)
_getL10nData (port.js, line 2)
getMessage (port.js, line 2)
ContentVeil (ContentVeil.js, line 2)
(anonymous function)
execCb (require.js, line 6)
check (require.js, line 6)
(anonymous function) (require.js, line 6)
(anonymous function) (require.js, line 6)