Skip to content

Instantly share code, notes, and snippets.

@rlvaugh
rlvaugh / brazil_china_trade_1997_2024.csv
Created May 14, 2025 03:32
Brazil Trade Balances from COMEX STAT
Year Country Export Import
2024 China 94.37203659 -63.63634557
2023 China 104.3248118 -53.17575715
2022 China 89.42776128 -60.74396488
2021 China 87.90788786 -47.65094551
2020 China 67.78807521 -34.77844139
2019 China 63.35752315 -36.028297
2018 China 63.92956324 -35.15723689
2017 China 47.48844997 -27.55397818
2016 China 35.13331487 -23.34992586
@rlvaugh
rlvaugh / states_square_tile_template.csv
Created April 28, 2025 15:39
Square Tile Grid Map Template
State Abbr X Y
Alabama AL 7 1
Alaska AK 0 7
Arizona AZ 2 2
Arkansas AR 5 2
California CA 1 3
Colorado CO 3 3
Connecticut CT 10 4
Delaware DE 10 3
Florida FL 9 0
@rlvaugh
rlvaugh / georgia_county_seat_loc_data.csv
Created March 30, 2025 02:33
Georgia County Seats Location Data
County Seat Lat Lon
Appling Baxley 31.7644 -82.3556
Atkinson Pearson 31.2983 -82.8347
Bacon Alma 31.5367 -82.4669
Baker Newton 31.31667 -84.3394
Baldwin Milledgeville 33.0808 -83.2422
Banks Homer 34.33388 -83.4997
Barrow Winder 33.9511 -83.725
Bartow Cartersville 34.1658 -84.8094
Ben Hill Fitzgerald 31.7167 -83.25
@rlvaugh
rlvaugh / measles_tycho.csv
Created March 5, 2025 21:22
Project Tycho US weekly measles data 1928-2003
We can't make this file beautiful and searchable because it's too large.
YEAR,WEEK,ALABAMA,ALASKA,ARIZONA,ARKANSAS,CALIFORNIA,COLORADO,CONNECTICUT,DELAWARE,DISTRICT OF COLUMBIA,FLORIDA,GEORGIA,HAWAII,IDAHO,ILLINOIS,INDIANA,IOWA,KANSAS,KENTUCKY,LOUISIANA,MAINE,MARYLAND,MASSACHUSETTS,MICHIGAN,MINNESOTA,MISSISSIPPI,MISSOURI,MONTANA,NEBRASKA,NEVADA,NEW HAMPSHIRE,NEW JERSEY,NEW MEXICO,NEW YORK,NORTH CAROLINA,NORTH DAKOTA,OHIO,OKLAHOMA,OREGON,PENNSYLVANIA,RHODE ISLAND,SOUTH CAROLINA,SOUTH DAKOTA,TENNESSEE,TEXAS,UTAH,VERMONT,VIRGINIA,WASHINGTON,WEST VIRGINIA,WISCONSIN,WYOMING
1928,1,3.67,-,1.9,4.11,1.38,8.38,4.5,8.58,-,0.21,1.17,-,-,0.5,1.34,0.16,0.81,3.08,1.89,4.52,10.87,25.66,5.68,0.31,-,1.19,0.18,1.6,-,-,3.55,14.9,7.6,47.86,-,2.51,4.86,4.91,6.97,1.18,42.04,5.69,22.03,1.18,0.4,0.28,-,14.83,3.36,1.54,0.91
1928,2,6.25,-,6.4,9.91,1.8,6.02,9,7.3,-,0.49,5.96,-,0.45,0.77,2.71,-,1.35,1.99,3,7.4,15.47,28.5,7.59,0.23,-,0.83,0.18,0.29,-,-,4.74,11.06,9.65,119.7,0.15,-,2.56,4.91,8.74,0.74,83.9,6.57,16.96,0.63,-,0.56,-,17.34,4.19,0.96,-
1928,3,7.95,-,4.5,11.15,1.31,2.86,8.81,15.88,-,0.42,-,-,0.45,0
@rlvaugh
rlvaugh / 1950-2023_actual_tornadoes.csv
Created January 16, 2025 17:21
NOAA tornadoes 1950-2023
We can't make this file beautiful and searchable because it's too large.
om,yr,mo,dy,date,time,tz,st,stf,stn,mag,inj,fat,loss,closs,slat,slon,elat,elon,len,wid,ns,sn,sg,f1,f2,f3,f4,fc
192,1950,10,1,10/1/1950,21:00:00,3,OK,40,23,1,0,0,4,0,36.73,-102.52,36.88,-102.3,15.8,10,1,1,1,25,0,0,0,0
193,1950,10,9,10/9/1950,2:15:00,3,NC,37,9,3,3,0,5,0,34.17,-78.6,0,0,2,880,1,1,1,47,0,0,0,0
195,1950,11,20,11/20/1950,2:20:00,3,KY,21,1,2,0,0,5,0,37.37,-87.2,0,0,0.1,10,1,1,1,177,0,0,0,0
196,1950,11,20,11/20/1950,4:00:00,3,KY,21,2,1,0,0,5,0,38.2,-84.5,0,0,0.1,10,1,1,1,209,0,0,0,0
197,1950,11,20,11/20/1950,7:30:00,3,MS,28,14,1,3,0,4,0,32.42,-89.13,0,0,2,37,1,1,1,101,0,0,0,0
194,1950,11,4,11/4/1950,17:00:00,3,PA,42,5,3,1,0,5,0,40.2,-76.12,40.4,-75.93,15.9,100,1,1,1,71,11,0,0,0
198,1950,12,2,12/2/1950,15:00:00,3,IL,17,7,2,3,1,4,0,38.97,-90.05,39.07,-89.72,18.8,50,1,1,1,119,117,0,0,0
199,1950,12,2,12/2/1950,16:00:00,3,IL,17,8,3,25,2,6,0,38.75,-89.67,38.9,-89.38,18,200,1,1,1,119,5,0,0,0
200,1950,12,2,12/2/1950,16:25:00,3,AR,5,12,3,0,0,1,0,36.12,-91.83,36.18,-91.72,7.8,10,1,1,1,65,0,0,0,0
@rlvaugh
rlvaugh / mass_shootings.csv
Created November 25, 2024 23:36
Mother Jones Mass Shooting data distilled
Year Mass Shootings Mass Shootings 4 plus Assault Weapon Ban Fatalities Fatalities 4 plus US Population Global FB Users Assault Weapons AW 4 plus
1982 1 1 8 8 228001418 0 0 0
1983 0 0 0 0 230389964 0 0 0
1984 2 2 28 28 232766280 0 1 1
1985 0 0 0 0 235146182 0 0 0
1986 1 1 15 15 237512783 0 0 0
1987 1 1 6 6 239853168 0 0 0
1988 1 1 7 7 242287814 0 0 0
1989 2 2 15 15 244954094 0 2 2
1990 1 1 10 10 248083732 0 0 0
@rlvaugh
rlvaugh / gray_wolf_populations.csv
Created October 18, 2024 19:17
US Wolf Populations 2024
state abbrev popl log_popl year
Alaska AK 9000 3.954242509 2022
Minnesota MN 2919 3.465234095 2023
Idaho ID 1337 3.126131407 2022
Montana MT 1087 3.036229544 2022
Wisconsin WS 1007 3.003029471 2023
Michigan MI 762 2.881954971 2024
Wyoming WY 352 2.546542663 2023
Washington WA 216 2.334453751 2022
Oregon OR 178 2.250420002 2023
@rlvaugh
rlvaugh / albany_tx_temps_1950_2023.csv
Created August 23, 2024 19:47
Temperature, population, and location data for 6 Texas cities.
Year High Low City
1950 79.1 49.8 Albany
1951 80.6 49.6 Albany
1952 81.4 49 Albany
1953 80.5 50 Albany
1954 82.4 52.2 Albany
1955 81 51.3 Albany
1956 82.7 51.5 Albany
1957 76.7 50 Albany
1958 76.2 49.4 Albany
@rlvaugh
rlvaugh / top_25_countries_U_input_v3.csv
Created August 18, 2024 02:50
2024 Olympics Medal and Population Data
Country N Ni s T S U
USA 126 341810000
China 91 1425180000
Great Britain 65 67960000
France 64 64880000
Australia 53 26700000
Japan 45 122630000
Italy 40 58700000
Netherlands 34 17670000
Germany 33 83250000
@rlvaugh
rlvaugh / 2021_BLS_Table_1300.csv
Created June 15, 2024 14:42
2021 Bureau of Labor Statistics Consumer Expenditure Table 1300 abridged
Expenditure Percent
Expenditure Type 25-34 35-44 45-54 55-64 65-74 75+
Food 12.74 12.13 12.75 11.86 12.28 12.3
Housing 35.28 33.17 31.63 32.59 35.58 37.28
Transportation 18.18 18 16.5 15.54 14.93 11.9
Healthcare 5.27 6.47 6.73 8.65 12.38 15.56
Insurance 13.06 13.91 13.87 13.34 6.98 2.85
Cash Contr. 1.45 2.78 3 4.07 5.08 8.88
Entertainment 5.03 5.33 5.6 5.25 6.04 4.59
Education 1.59 1.38 3.07 2.07 0.45 0.71