ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-11-23" 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 |
---|---|---|---|---|---|---|---|
1943345 | 1943345 | 2021-11-23 | Autauga | Alabama | 1001 | 10495 | 156 |
1943346 | 1943346 | 2021-11-23 | Baldwin | Alabama | 1003 | 38014 | 588 |
1943347 | 1943347 | 2021-11-23 | Barbour | Alabama | 1005 | 3690 | 80 |
1943348 | 1943348 | 2021-11-23 | Bibb | Alabama | 1007 | 4338 | 94 |
1943349 | 1943349 | 2021-11-23 | Blount | Alabama | 1009 | 10659 | 191 |
1943350 | 1943350 | 2021-11-23 | Bullock | Alabama | 1011 | 1527 | 45 |
1943351 | 1943351 | 2021-11-23 | Butler | Alabama | 1013 | 3430 | 100 |
1943352 | 1943352 | 2021-11-23 | Calhoun | Alabama | 1015 | 22589 | 518 |
1943353 | 1943353 | 2021-11-23 | Chambers | Alabama | 1017 | 5778 | 142 |
1943354 | 1943354 | 2021-11-23 | Cherokee | Alabama | 1019 | 3148 | 62 |
1943355 | 1943355 | 2021-11-23 | Chilton | Alabama | 1021 | 6991 | 170 |
1943356 | 1943356 | 2021-11-23 | Choctaw | Alabama | 1023 | 931 | 28 |
1943357 | 1943357 | 2021-11-23 | Clarke | Alabama | 1025 | 4842 | 86 |
1943358 | 1943358 | 2021-11-23 | Clay | Alabama | 1027 | 2509 | 69 |
1943359 | 1943359 | 2021-11-23 | Cleburne | Alabama | 1029 | 2542 | 60 |
1943360 | 1943360 | 2021-11-23 | Coffee | Alabama | 1031 | 9411 | 192 |
1943361 | 1943361 | 2021-11-23 | Colbert | Alabama | 1033 | 9305 | 207 |
1943362 | 1943362 | 2021-11-23 | Conecuh | Alabama | 1035 | 1925 | 62 |
1943363 | 1943363 | 2021-11-23 | Coosa | Alabama | 1037 | 1841 | 47 |
1943364 | 1943364 | 2021-11-23 | Covington | Alabama | 1039 | 6918 | 194 |
1943365 | 1943365 | 2021-11-23 | Crenshaw | Alabama | 1041 | 2597 | 76 |
1943366 | 1943366 | 2021-11-23 | Cullman | Alabama | 1043 | 16009 | 302 |
1943367 | 1943367 | 2021-11-23 | Dale | Alabama | 1045 | 9011 | 191 |
1943368 | 1943368 | 2021-11-23 | Dallas | Alabama | 1047 | 5280 | 209 |
1943369 | 1943369 | 2021-11-23 | DeKalb | Alabama | 1049 | 12901 | 269 |
1943370 | 1943370 | 2021-11-23 | Elmore | Alabama | 1051 | 15902 | 294 |
1943371 | 1943371 | 2021-11-23 | Escambia | Alabama | 1053 | 6947 | 141 |
1943372 | 1943372 | 2021-11-23 | Etowah | Alabama | 1055 | 20006 | 517 |
1943373 | 1943373 | 2021-11-23 | Fayette | Alabama | 1057 | 3289 | 85 |
1943374 | 1943374 | 2021-11-23 | Franklin | Alabama | 1059 | 6298 | 108 |
1943375 | 1943375 | 2021-11-23 | Geneva | Alabama | 1061 | 4639 | 136 |
1943376 | 1943376 | 2021-11-23 | Greene | Alabama | 1063 | 1301 | 45 |
1943377 | 1943377 | 2021-11-23 | Hale | Alabama | 1065 | 3171 | 89 |
1943378 | 1943378 | 2021-11-23 | Henry | Alabama | 1067 | 3204 | 66 |
1943379 | 1943379 | 2021-11-23 | Houston | Alabama | 1069 | 17700 | 424 |
1943380 | 1943380 | 2021-11-23 | Jackson | Alabama | 1071 | 10162 | 194 |
1943381 | 1943381 | 2021-11-23 | Jefferson | Alabama | 1073 | 116087 | 2006 |
1943382 | 1943382 | 2021-11-23 | Lamar | Alabama | 1075 | 2503 | 53 |
1943383 | 1943383 | 2021-11-23 | Lauderdale | Alabama | 1077 | 14919 | 306 |
1943384 | 1943384 | 2021-11-23 | Lawrence | Alabama | 1079 | 4806 | 127 |
1943385 | 1943385 | 2021-11-23 | Lee | Alabama | 1081 | 25527 | 261 |
1943386 | 1943386 | 2021-11-23 | Limestone | Alabama | 1083 | 16099 | 218 |
1943387 | 1943387 | 2021-11-23 | Lowndes | Alabama | 1085 | 1780 | 68 |
1943388 | 1943388 | 2021-11-23 | Macon | Alabama | 1087 | 2443 | 64 |
1943389 | 1943389 | 2021-11-23 | Madison | Alabama | 1089 | 53214 | 729 |
1943390 | 1943390 | 2021-11-23 | Marengo | Alabama | 1091 | 3426 | 93 |
1943391 | 1943391 | 2021-11-23 | Marion | Alabama | 1093 | 5392 | 129 |
1943392 | 1943392 | 2021-11-23 | Marshall | Alabama | 1095 | 18760 | 316 |
1943393 | 1943393 | 2021-11-23 | Mobile | Alabama | 1097 | 74117 | 1379 |
1943394 | 1943394 | 2021-11-23 | Monroe | Alabama | 1099 | 3364 | 66 |
1943395 | 1943395 | 2021-11-23 | Montgomery | Alabama | 1101 | 34462 | 781 |
1943396 | 1943396 | 2021-11-23 | Morgan | Alabama | 1103 | 22397 | 405 |
1943397 | 1943397 | 2021-11-23 | Perry | Alabama | 1105 | 1419 | 40 |
1943398 | 1943398 | 2021-11-23 | Pickens | Alabama | 1107 | 3323 | 88 |
1943399 | 1943399 | 2021-11-23 | Pike | Alabama | 1109 | 5110 | 109 |
1943400 | 1943400 | 2021-11-23 | Randolph | Alabama | 1111 | 3343 | 67 |
1943401 | 1943401 | 2021-11-23 | Russell | Alabama | 1113 | 7063 | 65 |
1943402 | 1943402 | 2021-11-23 | Shelby | Alabama | 1117 | 38281 | 368 |
1943403 | 1943403 | 2021-11-23 | St. Clair | Alabama | 1115 | 16851 | 357 |
1943404 | 1943404 | 2021-11-23 | Sumter | Alabama | 1119 | 1377 | 41 |
1943405 | 1943405 | 2021-11-23 | Talladega | Alabama | 1121 | 14186 | 297 |
1943406 | 1943406 | 2021-11-23 | Tallapoosa | Alabama | 1123 | 7227 | 201 |
1943407 | 1943407 | 2021-11-23 | Tuscaloosa | Alabama | 1125 | 35915 | 638 |
1943408 | 1943408 | 2021-11-23 | Walker | Alabama | 1127 | 11978 | 379 |
1943409 | 1943409 | 2021-11-23 | Washington | Alabama | 1129 | 2563 | 52 |
1943410 | 1943410 | 2021-11-23 | Wilcox | Alabama | 1131 | 1771 | 38 |
1943411 | 1943411 | 2021-11-23 | Winston | Alabama | 1133 | 4777 | 108 |
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);