Skip to content

Instantly share code, notes, and snippets.

Ryan Shackleton Ryshackleton

Block or report user

Report or block Ryshackleton

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
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.