Skip to content

Instantly share code, notes, and snippets.

Ryan Shackleton Ryshackleton

View GitHub Profile
View admin0s.csv
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 6.
"location_id","location_level","location_parent_id","path_to_top_parent","location_name","location_ascii_name","location_name_short","location_name_medium","location_type_id","location_description","map_id","start_date","end_date","date_inserted","last_updated","last_updated_by","last_updated_action"
6,1,1,"1,6","China","China","China","China",2,"admin0","CHN","1949-01-01 00:00:00",NULL,"2013-05-06 12:35:34","2017-08-15 17:36:26","elissat","UPDATE"
7,1,1,"1,7","North Korea","North Korea","N Korea","North Korea",2,"admin0","PRK","1945-01-01 00:00:00",NULL,"2013-05-06 12:35:34","2017-08-15 17:36:26","elissat","UPDATE"
8,1,1,"1,8","Taiwan","Taiwan","Taiwan","Taiwan",2,"admin0",71000000,"0001-01-01 00:00:00",NULL,"2013-05-06 12:35:34","2017-08-15 17:36:26","elissat","UPDATE"
10,1,1,"1,10","Cambodia","Cambodia","Cambodia","Cambodia",2,"admin0","KHM","1953-01-01 00:00:00",NULL,"2013-05-06 12:35:34","2017-08-15 17:36:26","elissat","UPDATE"
11,1,1,"1,11","Indonesia","Indonesia","Indonesia","Indonesia",2,"admin0","IDN
View admin1sAndAdmin2s.csv
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 6.
"location_id","location_level","location_parent_id","path_to_top_parent","location_name","location_ascii_name","location_name_short","location_name_medium","location_type_id","location_description","map_id","start_date","end_date","date_inserted","last_updated","last_updated_by","last_updated_action"
6,1,1,"1,6","China","China","China","China",2,"admin0","CHN","1949-01-01 00:00:00",NULL,"2013-05-06 12:35:34","2017-08-15 17:36:26","elissat","UPDATE"
7,1,1,"1,7","North Korea","North Korea","N Korea","North Korea",2,"admin0","PRK","1945-01-01 00:00:00",NULL,"2013-05-06 12:35:34","2017-08-15 17:36:26","elissat","UPDATE"
8,1,1,"1,8","Taiwan","Taiwan","Taiwan","Taiwan",2,"admin0",71000000,"0001-01-01 00:00:00",NULL,"2013-05-06 12:35:34","2017-08-15 17:36:26","elissat","UPDATE"
10,1,1,"1,10","Cambodia","Cambodia","Cambodia","Cambodia",2,"admin0","KHM","1953-01-01 00:00:00",NULL,"2013-05-06 12:35:34","2017-08-15 17:36:26","elissat","UPDATE"
11,1,1,"1,11","Indonesia","Indonesia","Indonesia","Indonesia",2,"admin0","IDN
@Ryshackleton
Ryshackleton / IHME-GBD_2016_DATA-4fe45551-1.csv
Created Apr 13, 2018
US Subnational Life Expectancy, All Ages, both sexes, 1990-2016
View IHME-GBD_2016_DATA-4fe45551-1.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 14 columns, instead of 12. in line 9.
measure_id,measure_name,location_id,location_name,sex_id,sex_name,age_id,age_name,metric_id,metric_name,year,val,upper,lower
26,Life expectancy,530,Delaware,3,Both,22,All Ages,5,Years,1999,76.2793505408,76.6376240018,75.8878822704
26,Life expectancy,532,Florida,3,Both,22,All Ages,5,Years,1999,77.385808956,77.7841910508,76.9595108863
26,Life expectancy,533,Georgia,3,Both,22,All Ages,5,Years,1999,75.2402637263,75.6741137857,74.7852899626
26,Life expectancy,534,Hawaii,3,Both,22,All Ages,5,Years,1999,79.4283102358,79.7878043629,79.0822906007
26,Life expectancy,535,Idaho,3,Both,22,All Ages,5,Years,1999,77.9222345593,78.3642224282,77.4196541273
26,Life expectancy,536,Illinois,3,Both,22,All Ages,5,Years,1999,76.516752219,76.8681442261,76.1694431903
26,Life expectancy,537,Indiana,3,Both,22,All Ages,5,Years,1999,76.1647538571,76.6109903857,75.7306548493
26,Life expectancy,538,Iowa,3,Both,22,All Ages,5,Years,1999,78.3360721141,78.7289256481,77.9500619067
26,Life expectancy,539,Kansas,3,Both,22,All Ages,5,Years,1999,77.
View usa-topo-fips-downsample.json
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View usa-topo-fips.json
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View fips-geocodes-v2015.csv
We can't make this file beautiful and searchable because it's too large.
level,state_fips,county_fips,location_name
010,00,000,United States
040,01,000,Alabama
050,01,001,Autauga County
050,01,003,Baldwin County
050,01,005,Barbour County
050,01,007,Bibb County
050,01,009,Blount County
050,01,011,Bullock County
@Ryshackleton
Ryshackleton / ihme-us-location-ids.csv
Created Mar 17, 2018
US State and County names - IHME location_id to FIPS code mapping
View ihme-us-location-ids.csv
location_id location_name FIPS
102 United States 0
523 Alabama 1
524 Alaska 2
525 Arizona 4
526 Arkansas 5
527 California 6
528 Colorado 8
529 Connecticut 9
530 Delaware 10
View data.json
[{"sex":1,"year":1990,"location":102,"mean":0.0000188511631791},{"sex":1,"year":1990,"location":523,"mean":0.00000857296392606},{"sex":1,"year":1990,"location":524,"mean":0.000018008041589},{"sex":1,"year":1990,"location":525,"mean":0.0000268181301928},{"sex":1,"year":1990,"location":526,"mean":0.0000079867264729},{"sex":1,"year":1990,"location":527,"mean":0.0000402513580668},{"sex":1,"year":1990,"location":528,"mean":0.0000150980908926},{"sex":1,"year":1990,"location":529,"mean":0.0000161126196958},{"sex":1,"year":1990,"location":530,"mean":0.0000209933327999},{"sex":1,"year":1990,"location":532,"mean":0.0000139423567836},{"sex":1,"year":1990,"location":533,"mean":0.0000117223809133},{"sex":1,"year":1990,"location":534,"mean":0.0000129325963938},{"sex":1,"year":1990,"location":535,"mean":0.00000985742362283},{"sex":1,"year":1990,"location":536,"mean":0.0000265749460896},{"sex":1,"year":1990,"location":537,"mean":0.00000735575942933},{"sex":1,"year":1990,"location":538,"mean":0.00000649343875164},{"sex":1,"ye
View usa-topo.json
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@Ryshackleton
Ryshackleton / index.html
Last active Mar 30, 2017
Maptime Seattle Earthquake Map
View index.html
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<!-- using D3 version 4-->
<script src="https://d3js.org/d3.v4.min.js"></script>
<script src="https://d3js.org/topojson.v2.min.js"></script>
You can’t perform that action at this time.