ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-04-15" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1222342 | 1222342 | 2021-04-15 | Autauga | Alabama | 1001 | 6748 | 103 |
1222343 | 1222343 | 2021-04-15 | Baldwin | Alabama | 1003 | 20674 | 302 |
1222344 | 1222344 | 2021-04-15 | Barbour | Alabama | 1005 | 2262 | 55 |
1222345 | 1222345 | 2021-04-15 | Bibb | Alabama | 1007 | 2560 | 59 |
1222346 | 1222346 | 2021-04-15 | Blount | Alabama | 1009 | 6511 | 134 |
1222347 | 1222347 | 2021-04-15 | Bullock | Alabama | 1011 | 1215 | 40 |
1222348 | 1222348 | 2021-04-15 | Butler | Alabama | 1013 | 2128 | 67 |
1222349 | 1222349 | 2021-04-15 | Calhoun | Alabama | 1015 | 14330 | 311 |
1222350 | 1222350 | 2021-04-15 | Chambers | Alabama | 1017 | 3513 | 122 |
1222351 | 1222351 | 2021-04-15 | Cherokee | Alabama | 1019 | 1825 | 44 |
1222352 | 1222352 | 2021-04-15 | Chilton | Alabama | 1021 | 4100 | 109 |
1222353 | 1222353 | 2021-04-15 | Choctaw | Alabama | 1023 | 587 | 24 |
1222354 | 1222354 | 2021-04-15 | Clarke | Alabama | 1025 | 3467 | 60 |
1222355 | 1222355 | 2021-04-15 | Clay | Alabama | 1027 | 1500 | 55 |
1222356 | 1222356 | 2021-04-15 | Cleburne | Alabama | 1029 | 1463 | 41 |
1222357 | 1222357 | 2021-04-15 | Coffee | Alabama | 1031 | 5418 | 113 |
1222358 | 1222358 | 2021-04-15 | Colbert | Alabama | 1033 | 6225 | 130 |
1222359 | 1222359 | 2021-04-15 | Conecuh | Alabama | 1035 | 1094 | 28 |
1222360 | 1222360 | 2021-04-15 | Coosa | Alabama | 1037 | 994 | 28 |
1222361 | 1222361 | 2021-04-15 | Covington | Alabama | 1039 | 4059 | 114 |
1222362 | 1222362 | 2021-04-15 | Crenshaw | Alabama | 1041 | 1494 | 57 |
1222363 | 1222363 | 2021-04-15 | Cullman | Alabama | 1043 | 9501 | 189 |
1222364 | 1222364 | 2021-04-15 | Dale | Alabama | 1045 | 4771 | 111 |
1222365 | 1222365 | 2021-04-15 | Dallas | Alabama | 1047 | 3522 | 149 |
1222366 | 1222366 | 2021-04-15 | DeKalb | Alabama | 1049 | 8756 | 181 |
1222367 | 1222367 | 2021-04-15 | Elmore | Alabama | 1051 | 10008 | 200 |
1222368 | 1222368 | 2021-04-15 | Escambia | Alabama | 1053 | 3895 | 74 |
1222369 | 1222369 | 2021-04-15 | Etowah | Alabama | 1055 | 13677 | 346 |
1222370 | 1222370 | 2021-04-15 | Fayette | Alabama | 1057 | 2094 | 60 |
1222371 | 1222371 | 2021-04-15 | Franklin | Alabama | 1059 | 4205 | 82 |
1222372 | 1222372 | 2021-04-15 | Geneva | Alabama | 1061 | 2459 | 75 |
1222373 | 1222373 | 2021-04-15 | Greene | Alabama | 1063 | 913 | 34 |
1222374 | 1222374 | 2021-04-15 | Hale | Alabama | 1065 | 2186 | 75 |
1222375 | 1222375 | 2021-04-15 | Henry | Alabama | 1067 | 1880 | 44 |
1222376 | 1222376 | 2021-04-15 | Houston | Alabama | 1069 | 10402 | 278 |
1222377 | 1222377 | 2021-04-15 | Jackson | Alabama | 1071 | 6751 | 110 |
1222378 | 1222378 | 2021-04-15 | Jefferson | Alabama | 1073 | 75398 | 1490 |
1222379 | 1222379 | 2021-04-15 | Lamar | Alabama | 1075 | 1396 | 34 |
1222380 | 1222380 | 2021-04-15 | Lauderdale | Alabama | 1077 | 9254 | 228 |
1222381 | 1222381 | 2021-04-15 | Lawrence | Alabama | 1079 | 2953 | 95 |
1222382 | 1222382 | 2021-04-15 | Lee | Alabama | 1081 | 15567 | 165 |
1222383 | 1222383 | 2021-04-15 | Limestone | Alabama | 1083 | 9843 | 147 |
1222384 | 1222384 | 2021-04-15 | Lowndes | Alabama | 1085 | 1365 | 53 |
1222385 | 1222385 | 2021-04-15 | Macon | Alabama | 1087 | 1555 | 48 |
1222386 | 1222386 | 2021-04-15 | Madison | Alabama | 1089 | 34002 | 496 |
1222387 | 1222387 | 2021-04-15 | Marengo | Alabama | 1091 | 2482 | 61 |
1222388 | 1222388 | 2021-04-15 | Marion | Alabama | 1093 | 3072 | 100 |
1222389 | 1222389 | 2021-04-15 | Marshall | Alabama | 1095 | 11988 | 220 |
1222390 | 1222390 | 2021-04-15 | Mobile | Alabama | 1097 | 39011 | 799 |
1222391 | 1222391 | 2021-04-15 | Monroe | Alabama | 1099 | 1724 | 40 |
1222392 | 1222392 | 2021-04-15 | Montgomery | Alabama | 1101 | 23996 | 567 |
1222393 | 1222393 | 2021-04-15 | Morgan | Alabama | 1103 | 14152 | 271 |
1222394 | 1222394 | 2021-04-15 | Perry | Alabama | 1105 | 1076 | 26 |
1222395 | 1222395 | 2021-04-15 | Pickens | Alabama | 1107 | 2330 | 59 |
1222396 | 1222396 | 2021-04-15 | Pike | Alabama | 1109 | 3061 | 76 |
1222397 | 1222397 | 2021-04-15 | Randolph | Alabama | 1111 | 1770 | 41 |
1222398 | 1222398 | 2021-04-15 | Russell | Alabama | 1113 | 4293 | 38 |
1222399 | 1222399 | 2021-04-15 | Shelby | Alabama | 1117 | 23160 | 239 |
1222400 | 1222400 | 2021-04-15 | St. Clair | Alabama | 1115 | 9449 | 234 |
1222401 | 1222401 | 2021-04-15 | Sumter | Alabama | 1119 | 1032 | 32 |
1222402 | 1222402 | 2021-04-15 | Talladega | Alabama | 1121 | 8104 | 171 |
1222403 | 1222403 | 2021-04-15 | Tallapoosa | Alabama | 1123 | 3904 | 146 |
1222404 | 1222404 | 2021-04-15 | Tuscaloosa | Alabama | 1125 | 25329 | 444 |
1222405 | 1222405 | 2021-04-15 | Walker | Alabama | 1127 | 7126 | 275 |
1222406 | 1222406 | 2021-04-15 | Washington | Alabama | 1129 | 1647 | 38 |
1222407 | 1222407 | 2021-04-15 | Wilcox | Alabama | 1131 | 1245 | 27 |
1222408 | 1222408 | 2021-04-15 | Winston | Alabama | 1133 | 2730 | 72 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);