Skip to content

Instantly share code, notes, and snippets.

View the-observables's full-sized avatar

the-observables

View GitHub Profile
@the-observables
the-observables / piano-keys.csv
Last active December 10, 2018 20:25
id key set frequency
1 C 1 32.7
2 C# 1 34.6
3 D 1 36.7
4 E♭ 1 38.9
5 E 1 41.2
6 F 1 43.6
7 F# 1 46.2
8 G 1 48.9
9 G# 1 51.9
@the-observables
the-observables / vocal-ranges-all.csv
Last active December 10, 2018 19:20
name range low low-song high high-song gender data-low data-high
Axl Rose F1 - B♭6 F1 There Was a Time B♭6 Ain't It Fun male-artist 6 71
David Bowie G1 - G♯5 G1 I Took a Trip on a Gemini Spacecraft G#5 Lady Grinning Soul male-artist 8 57
Paul McCartney B1 - B5 B1 Nothing Too Much Just Out of Sight B5 Money (That's What I Want) male-artist 12 60
Freddie Mercury F2 - E6 F2 All Dead All Dead E6 It's Late male-artist 18 65
John Lennon B1 - A5 B1 You Know My Name (Look Up The Number) A5 Dizzy Miss Lizzy male-artist 12 58
Elton John E2 - D6 E2 Mona Lisas and Mad Hatters D6 Social Disease male-artist 17 63
George Michael C♯2 - A5 C♯2 December Song (I Dream of Christmas) A5 Nikita male-artist 14 58
Tina Turner B2 - G6 B2 There'll Always Be Music G6 River Deep Mountain High female-artist 24 68
Whitney Houston C♯3 - C6 C♯3 I Learned From The Best (Acapella) C6 I Wanna Dance with Somebody female-artist 26 61
@the-observables
the-observables / cleaned-mta-accident-stationsCSV.csv
Last active October 29, 2018 21:39
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 30 columns, instead of 28 in line 3.
Station_ID,Borough,Complex ID,Daytime Routes,Division,fatalities,passenger_fatality,patron_fatality,public_fatality,worker_fatality,injuries,passenger_injury,patron_injury,public_injury,worker_injury,accident_date,GTFS Latitude,GTFS Longitude,GTFS Stop ID,ID,Line,Number of Records,Stop Name,Structure,accident_time,city,criteria,primary_location,property,secondary_location
1,Q,1,N W,BMT,0,0,0,0,0,1,0,1,0,0,2/4/2013,40.775036,-73.912034,R01,1,Astoria,1,Astoria - Ditmars Blvd,Elevated,0001-01-01T05:28:00+00:00,New York,Collision with Individual,Astoria Line,MTA New York City Transit,Ditmars Blvd Station
1,Q,1,N W,BMT,1,0,0,1,0,0,0,0,0,0,4/1/2012,40.775036,-73.912034,R01,1,Astoria,1,Astoria - Ditmars Blvd,Elevated,0001-01-01T05:15:00+00:00,New York,Fatality-Non Passenger (Rail Operation),Astoria Line,MTA New York City Transit,Ditmars Blvd Station
1,Q,1,N W,BMT,0,0,0,0,0,0,0,0,0,0,11/1/2011,40.775036,-73.912034,R01,1,Astoria,1,Astoria - Ditmars Blvd,Elevated,0001-01-01T07:45:00+00:00,New York,Collision,Astoria Lin
@the-observables
the-observables / subway-stations-with-incidents.geojson
Last active October 28, 2018 05:01
MTA Subway Stations
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@the-observables
the-observables / subway-lines.geojson
Last active October 23, 2018 03:28
subway-lines
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@the-observables
the-observables / MTA_accident_2017.csv
Last active October 9, 2018 02:22
Accidents in 2017
accident_type count
Collision with Individual 69
Fatality-Non Passenger (Rail Operation) 40
Collision with Individual (No Injury) 16
Derailment 11
Fatality (Non Rail Operation) 9
Grade Crossing 9
Multiple Injury (Non Rail Operation) 4
Evacuation 3
Collision 1
@the-observables
the-observables / MTA_accident_types.csv
Created October 9, 2018 01:41
Accident Types
accident_type number
Fatality-Non Passenger (Rail Operation) 737
Collision with Individual 717
Collision with Individual (No Injury) 110
Grade Crossing 105
Derailment 48
Collision 38
Fatality (Non Rail Operation) 35
Multiple Injury (Rail Operation) 34
Evacuation 33
@the-observables
the-observables / mta.csv
Last active October 9, 2018 02:33
MTA Simplified
criteria fatalities accident_date
Fatality (Non Rail Operation) 1 2015-11-09T00:00:00
Collision with Individual 0 2015-11-11T00:00:00
Fatality-Non Passenger (Rail Operation) 1 2015-11-14T00:00:00
Collision with Individual 0 2015-11-15T00:00:00
Multiple Injury (Non Rail Operation) 0 2015-11-17T00:00:00
Collision with Individual 0 2015-11-19T00:00:00
Collision with Individual 0 2015-11-23T00:00:00
Fatality-Non Passenger (Rail Operation) 1 2015-11-24T00:00:00
Collision with Individual (No Injury) 0 2015-12-01T00:00:00
@the-observables
the-observables / MTA_incidents.csv
Last active October 9, 2018 02:22
New York State Department of Transportation - Accident Reports (https://public.enigma.com/datasets/94fe9c6a-93d4-4be6-ac13-dd247146bd82)
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 18 columns, instead of 4 in line 5.
property,accident_date,accident_time,criteria,city,primary_location,secondary_location,dot_crossing_number,fatalities,passenger_fatality,patron_fatality,public_fatality,worker_fatality,injuries,passenger_injury,patron_injury,public_injury,worker_injury
MTA New York City Transit,2015-11-09T00:00:00,0001-01-01T06:18:00+00:00,Fatality (Non Rail Operation),New York,35th Street,8th Avenue Station,,1,0,1,0,0,2,0,2,0,0
MTA New York City Transit,2015-11-11T00:00:00,0001-01-01T17:40:00+00:00,Collision with Individual,New York,Lexington Avenue Line,86th Street Station,,0,0,0,0,0,1,0,1,0,0
MTA New York City Transit,2015-11-14T00:00:00,0001-01-01T03:08:00+00:00,Fatality-Non Passenger (Rail Operation),New York,Queens Blvd Line,Continental Ave Station,,1,0,0,1,0,0,0,0,0,0
MTA Long Island Rail Road,2015-11-14T00:00:00,0001-01-01T18:17:00+00:00,Collision,Wyandanch,Main Line Branch,West of Little East Neck Road,338160B,0,0,0,0,0,0,0,0,0,0
MTA New York City Transit,2015-11-15T00:00:00,0001-01-01T08:43:00+00:00,Collision with