ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

424,607 rows sorted by date descending

View and edit SQL

state

fips

county

Link rowid date ▲ county state fips cases deaths
421387 2020-08-11 Autauga Alabama 1001 1215 23
421388 2020-08-11 Baldwin Alabama 1003 3736 32
421389 2020-08-11 Barbour Alabama 1005 643 6
421390 2020-08-11 Bibb Alabama 1007 455 6
421391 2020-08-11 Blount Alabama 1009 958 5
421392 2020-08-11 Bullock Alabama 1011 489 12
421393 2020-08-11 Butler Alabama 1013 785 37
421394 2020-08-11 Calhoun Alabama 1015 1914 19
421395 2020-08-11 Chambers Alabama 1017 916 38
421396 2020-08-11 Cherokee Alabama 1019 307 9
421397 2020-08-11 Chilton Alabama 1021 870 12
421398 2020-08-11 Choctaw Alabama 1023 294 12
421399 2020-08-11 Clarke Alabama 1025 856 10
421400 2020-08-11 Clay Alabama 1027 274 5
421401 2020-08-11 Cleburne Alabama 1029 134 1
421402 2020-08-11 Coffee Alabama 1031 815 6
421403 2020-08-11 Colbert Alabama 1033 1242 17
421404 2020-08-11 Conecuh Alabama 1035 421 10
421405 2020-08-11 Coosa Alabama 1037 120 3
421406 2020-08-11 Covington Alabama 1039 889 22
421407 2020-08-11 Crenshaw Alabama 1041 359 7
421408 2020-08-11 Cullman Alabama 1043 1322 12
421409 2020-08-11 Dale Alabama 1045 869 29
421410 2020-08-11 Dallas Alabama 1047 1444 24
421411 2020-08-11 DeKalb Alabama 1049 1896 17
421412 2020-08-11 Elmore Alabama 1051 1843 41
421413 2020-08-11 Escambia Alabama 1053 1221 17
421414 2020-08-11 Etowah Alabama 1055 2258 35
421415 2020-08-11 Fayette Alabama 1057 237 5
421416 2020-08-11 Franklin Alabama 1059 1314 22
421417 2020-08-11 Geneva Alabama 1061 285 3
421418 2020-08-11 Greene Alabama 1063 257 11
421419 2020-08-11 Hale Alabama 1065 506 26
421420 2020-08-11 Henry Alabama 1067 280 4
421421 2020-08-11 Houston Alabama 1069 1486 15
421422 2020-08-11 Jackson Alabama 1071 1057 6
421423 2020-08-11 Jefferson Alabama 1073 13653 248
421424 2020-08-11 Lamar Alabama 1075 238 2
421425 2020-08-11 Lauderdale Alabama 1077 1204 20
421426 2020-08-11 Lawrence Alabama 1079 364 2
421427 2020-08-11 Lee Alabama 1081 2905 51
421428 2020-08-11 Limestone Alabama 1083 1387 14
421429 2020-08-11 Lowndes Alabama 1085 584 26
421430 2020-08-11 Macon Alabama 1087 352 14
421431 2020-08-11 Madison Alabama 1089 5585 39
421432 2020-08-11 Marengo Alabama 1091 576 17
421433 2020-08-11 Marion Alabama 1093 619 26
421434 2020-08-11 Marshall Alabama 1095 3287 39
421435 2020-08-11 Mobile Alabama 1097 10673 217
421436 2020-08-11 Monroe Alabama 1099 487 7
421437 2020-08-11 Montgomery Alabama 1101 6969 154
421438 2020-08-11 Morgan Alabama 1103 2460 21
421439 2020-08-11 Perry Alabama 1105 475 4
421440 2020-08-11 Pickens Alabama 1107 419 10
421441 2020-08-11 Pike Alabama 1109 764 8
421442 2020-08-11 Randolph Alabama 1111 415 12
421443 2020-08-11 Russell Alabama 1113 1423 2
421444 2020-08-11 Shelby Alabama 1117 3560 39
421445 2020-08-11 St. Clair Alabama 1115 1474 21
421446 2020-08-11 Sumter Alabama 1119 372 18
421447 2020-08-11 Talladega Alabama 1121 1324 15
421448 2020-08-11 Tallapoosa Alabama 1123 951 80
421449 2020-08-11 Tuscaloosa Alabama 1125 4402 81
421450 2020-08-11 Walker Alabama 1127 1584 68
421451 2020-08-11 Washington Alabama 1129 453 12
421452 2020-08-11 Wilcox Alabama 1131 451 10
421453 2020-08-11 Winston Alabama 1133 474 11
421454 2020-08-11 Aleutians East Borough Alaska 2013 4 0
421455 2020-08-11 Aleutians West Census Area Alaska 2016 88 0
421456 2020-08-11 Anchorage Alaska 2020 2353 14
421457 2020-08-11 Bethel Census Area Alaska 2050 25 0
421458 2020-08-11 Bristol Bay Borough Alaska 2060 68 0
421459 2020-08-11 Denali Borough Alaska 2068 4 0
421460 2020-08-11 Dillingham Census Area Alaska 2070 24 0
421461 2020-08-11 Fairbanks North Star Borough Alaska 2090 482 5
421462 2020-08-11 Haines Borough Alaska 2100 8 0
421463 2020-08-11 Juneau City and Borough Alaska 2110 186 1
421464 2020-08-11 Kenai Peninsula Borough Alaska 2122 495 1
421465 2020-08-11 Ketchikan Gateway Borough Alaska 2130 52 0
421466 2020-08-11 Kodiak Island Borough Alaska 2150 35 0
421467 2020-08-11 Kusilvak Census Area Alaska 2158 7 0
421468 2020-08-11 Lake and Peninsula Borough Alaska 2164 5 0
421469 2020-08-11 Matanuska-Susitna Borough Alaska 2170 367 2
421470 2020-08-11 Nome Census Area Alaska 2180 22 0
421471 2020-08-11 North Slope Borough Alaska 2185 22 0
421472 2020-08-11 Northwest Arctic Borough Alaska 2188 41 0
421473 2020-08-11 Petersburg Borough Alaska 2195 9 0
421474 2020-08-11 Prince of Wales-Hyder Census Area Alaska 2198 8 0
421475 2020-08-11 Sitka City and Borough Alaska 2220 37 0
421476 2020-08-11 Southeast Fairbanks Census Area Alaska 2240 29 0
421477 2020-08-11 Unknown Alaska   47 0
421478 2020-08-11 Valdez-Cordova Census Area Alaska 2261 101 0
421479 2020-08-11 Wrangell City and Borough Alaska 2275 14 0
421480 2020-08-11 Yukon-Koyukuk Census Area Alaska 2290 54 1
421481 2020-08-11 Apache Arizona 4001 3197 139
421482 2020-08-11 Cochise Arizona 4003 1730 55
421483 2020-08-11 Coconino Arizona 4005 3128 117
421484 2020-08-11 Gila Arizona 4007 950 40
421485 2020-08-11 Graham Arizona 4009 555 17
421486 2020-08-11 Greenlee Arizona 4011 57 2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 3276.476ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette