Skip to content

Instantly share code, notes, and snippets.

@kcsluis
kcsluis / uscities.csv
Created August 9, 2019 18:00
US Cities
We can't make this file beautiful and searchable because it's too large.
"city","city_ascii","state_id","state_name","county_fips","county_name","lat","lng","population","population_proper","density","source","incorporated","timezone","zips","id"
"Prairie Ridge","Prairie Ridge","WA","Washington","53053","Pierce","47.1443","-122.1408","","","1349.8","polygon","False","America/Los_Angeles","98360 98391","1840037882"
"Edison","Edison","WA","Washington","53057","Skagit","48.5602","-122.4311","","","127.4","polygon","False","America/Los_Angeles","98232","1840017314"
"Packwood","Packwood","WA","Washington","53041","Lewis","46.6085","-121.6702","","","213.9","polygon","False","America/Los_Angeles","98361","1840025265"
"Wautauga Beach","Wautauga Beach","WA","Washington","53035","Kitsap","47.5862","-122.5482","","","261.7","point","False","America/Los_Angeles","98366","1840037725"
"Harper","Harper","WA","Washington","53035","Kitsap","47.5207","-122.5196","","","342.1","point","False","America/Los_Angeles","98366","1840037659"
@kcsluis
kcsluis / query.csv
Last active August 27, 2020 22:34
1000 US Cities
population gps city cityLabel
8398748 Point(-73.94 40.67) http://www.wikidata.org/entity/Q60 New York City
3976322 Point(-118.24368 34.05223) http://www.wikidata.org/entity/Q65 Los Angeles
2722389 Point(-87.627777777 41.881944444) http://www.wikidata.org/entity/Q1297 Chicago
2195914 Point(-95.383055555 29.762777777) http://www.wikidata.org/entity/Q16555 Houston
1626078 Point(-112.076388888 33.528333333) http://www.wikidata.org/entity/Q16556 Phoenix
1580863 Point(-75.163611111 39.952777777) http://www.wikidata.org/entity/Q1345 Philadelphia
1445632 Point(-112.076388888 33.528333333) http://www.wikidata.org/entity/Q16556 Phoenix
1436697 Point(-98.493888888 29.425) http://www.wikidata.org/entity/Q975 San Antonio
1394928 Point(-117.1625 32.715) http://www.wikidata.org/entity/Q16552 San Diego
name Latitude Longitude city state state_short pop_2010 change_2010 pop_2000 change_2000 pop_1990 change_1990 pop_1980 change_1980 pop_1970 change_1970 pop_1960 change_1960 pop_1950 change_1950 pop_1940 change_1940 pop_1930 change_1930 pop_1920 change_1920 pop_1910 change_1910 pop_1900 change_1900 pop_1890 change_1890 pop_1880 change_1880 pop_1870
Allegheny, Pennsylvania 40.4450813 -80.0087746 Allegheny Pennsylvania PA #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 129896 24609 105287 26605 78682 25502 53180
Brooklyn, New York 40.6781784 -73.9441579 Brooklyn New York NY #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 806343 239680 566663 170564 396099
Charlestown, Massachusetts 42.3782065 -71.0602131 Charlestown Massachusetts MA #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 2
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 36 columns, instead of 3. in line 4.
name,Latitude,Longitude,city,state,state_short,pop_2010,rank_2010,pop_2000,rank_2000,pop_1990,rank_1990,pop_1980,rank_1980,pop_1970,rank_1970,pop_1960,rank_1960,pop_1950,rank_1950,pop_1940,rank_1940,pop_1930,rank_1930,pop_1920,rank_1920,pop_1910,rank_1910,pop_1900,rank_1900,pop_1890,rank_1890,pop_1880,rank_1880,pop_1870,rank_1870
"New York, New York",40.7127753,-74.0059728,New York, New York,NY,8175133,1,8008278,1,7322564,1,7071639,1,7894862,1,7781984,1,7891957,1,7454995,1,6930446,1,5620048,1,4766883,1,3437202,1,1515301,1,1206299,1,942292,1
"Los Angeles, California",34.0522342,-118.2436849,Los Angeles, California,CA,3792621,2,3694820,2,3485398,2,2966850,3,2816061,3,2479015,3,1970358,4,1504277,5,1238048,5,576673,10,319198,17,102479,36,50395,57,11183,#N/A,5728,#N/A
"Chicago, Illinois",41.8781136,-87.6297982,Chicago, Illinois,IL,2695598,3,2896016,3,2783726,3,3005072,2,3366957,2,3550404,2,3620962,2,3396808,2,3376438,2,2701705,2,2185283,2,1698575,2,1099850,2,503185,4,298977,5
"Houston, Texas",29.7604267,-95.369802
@kcsluis
kcsluis / states_pop.csv
Last active August 18, 2020 22:38
States Population
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 24 columns, instead of 7. in line 7.
Name,1790,1800,1810,1820,1830,1840,1850,1860,1870,1880,1890,1900,1910,1920,1930,1940,1950,1960,1970,1980,1990,2000,2010
Alabama,,1250,9046,127901,309527,590756,771623,964201,996992,1262505,1513017,1828697,2138093,2348174,2646248,2832961,3061743,3266740,3444165,3893888,4040587,4447100,4779736
Alaska,,,,,,,,,,,33426,32052,64356,55036,59278,72524,128643,226167,300382,401851,550043,626932,710231
Arizona,,,,,,,,,9658,40440,88243,122931,204354,334162,435573,499261,749587,1302161,1770900,2718215,3665228,5130632,6392017
Arkansas,,,1062,14273,30388,97574,209897,435450,484471,802525,1128211,1311564,1574449,1752204,1854482,1949387,1909511,1786272,1923295,2286435,2350725,2673400,2915918
California,,,,,,,92597,379994,560247,864694,1213398,1485053,2377549,3426861,5677251,6907387,10586223,15717204,19953134,23667902,29760021,33871648,37253956
Colorado,,,,,,,,34277,39864,194327,413249,539700,799024,939629,1035791,1123296,1325089,1753947,2207259,2889964,3294394,4301261,5029196
Connecticut,237946,251002,262042,275202,297675,309
@kcsluis
kcsluis / states_pop.csv
Created August 18, 2020 22:38
States Population
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 24 columns, instead of 7. in line 7.
Name,1790,1800,1810,1820,1830,1840,1850,1860,1870,1880,1890,1900,1910,1920,1930,1940,1950,1960,1970,1980,1990,2000,2010
Alabama,,1250,9046,127901,309527,590756,771623,964201,996992,1262505,1513017,1828697,2138093,2348174,2646248,2832961,3061743,3266740,3444165,3893888,4040587,4447100,4779736
Alaska,,,,,,,,,,,33426,32052,64356,55036,59278,72524,128643,226167,300382,401851,550043,626932,710231
Arizona,,,,,,,,,9658,40440,88243,122931,204354,334162,435573,499261,749587,1302161,1770900,2718215,3665228,5130632,6392017
Arkansas,,,1062,14273,30388,97574,209897,435450,484471,802525,1128211,1311564,1574449,1752204,1854482,1949387,1909511,1786272,1923295,2286435,2350725,2673400,2915918
California,,,,,,,92597,379994,560247,864694,1213398,1485053,2377549,3426861,5677251,6907387,10586223,15717204,19953134,23667902,29760021,33871648,37253956
Colorado,,,,,,,,34277,39864,194327,413249,539700,799024,939629,1035791,1123296,1325089,1753947,2207259,2889964,3294394,4301261,5029196
Connecticut,237946,251002,262042,275202,297675,309
@kcsluis
kcsluis / all_stars.txt
Created March 30, 2020 20:50
All Stars
Alpha Centauri 14 39.6 -60 50 315.7 -0.7 G2V+K1V+M5.5V -0.29 4.06 742.12 4.39 Gl 559 Rigil Kentaurus
Alpha Canis Majoris 06 45.1 -16 42 227.2 -8.9 A1V+DA2 -1.46 1.43 379.21 8.60 Gl 244 Sirius
Epsilon Eridani 03 32.9 -09 27 195.8 -48.1 K2V 3.72 6.18 310.75 10.50 Gl 144 Has a planet
Alpha Canis Minoris 07 39.3 +05 13 213.7 +13.0 F5IV-V+DA 0.36 2.64 285.93 11.41 Gl 280 Procyon
61 Cygni 21 06.9 +38 44 82.3 -5.8 K5V+K7V 4.79 7.07 285.42 11.43 Gl 820
Epsilon Indi 22 03.4 -56 47 336.2 -48.0 K4V+T1+T6 4.69 6.89 275.76 11.83 Gl 845
Tau Ceti 01 44.1 -15 56 173.1 -73.4 G8V 3.49 5.68 274.17 11.90 Gl 71
Omicron² Eridani 04 15.3 -07 39 200.8 -38.1 K1V+DA4+M4.5V 4.43 5.92 198.24 16.45 Gl 166 Keid
70 Ophiuchi 18 05.5 +02 30 29.9 +11.4 K0V+K5V 4.03 5.50 196.62 16.59 Gl
@kcsluis
kcsluis / prius4.json
Created February 25, 2020 13:13
prius try again
This file has been truncated, but you can view the full file.
{
"listings": [
{
"bodyType": "Hatchback",
"fleet": false,
"serviceProviderId": 438672,
"estInterestRateApr": 4.4,
"saved": false,
"highwayFuelEconomy": 45,
@kcsluis
kcsluis / prius3.json
Created February 25, 2020 13:08
Prius try again
This file has been truncated, but you can view the full file.
@kcsluis
kcsluis / cgToyota_Prius_2004-2009.json
Created February 25, 2020 13:02
Toyota Prius CG data
This file has been truncated, but you can view the full file.