ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2021-12-01 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1969353 | 1969353 | 2021-12-01 | Autauga | Alabama | 1001 | 10527 | 157 |
1969354 | 1969354 | 2021-12-01 | Baldwin | Alabama | 1003 | 38123 | 589 |
1969355 | 1969355 | 2021-12-01 | Barbour | Alabama | 1005 | 3700 | 80 |
1969356 | 1969356 | 2021-12-01 | Bibb | Alabama | 1007 | 4348 | 94 |
1969357 | 1969357 | 2021-12-01 | Blount | Alabama | 1009 | 10739 | 193 |
1969358 | 1969358 | 2021-12-01 | Bullock | Alabama | 1011 | 1525 | 45 |
1969359 | 1969359 | 2021-12-01 | Butler | Alabama | 1013 | 3442 | 101 |
1969360 | 1969360 | 2021-12-01 | Calhoun | Alabama | 1015 | 22610 | 519 |
1969361 | 1969361 | 2021-12-01 | Chambers | Alabama | 1017 | 5790 | 142 |
1969362 | 1969362 | 2021-12-01 | Cherokee | Alabama | 1019 | 3186 | 63 |
1969363 | 1969363 | 2021-12-01 | Chilton | Alabama | 1021 | 7061 | 170 |
1969364 | 1969364 | 2021-12-01 | Choctaw | Alabama | 1023 | 932 | 28 |
1969365 | 1969365 | 2021-12-01 | Clarke | Alabama | 1025 | 4853 | 86 |
1969366 | 1969366 | 2021-12-01 | Clay | Alabama | 1027 | 2511 | 69 |
1969367 | 1969367 | 2021-12-01 | Cleburne | Alabama | 1029 | 2547 | 60 |
1969368 | 1969368 | 2021-12-01 | Coffee | Alabama | 1031 | 9428 | 192 |
1969369 | 1969369 | 2021-12-01 | Colbert | Alabama | 1033 | 9347 | 210 |
1969370 | 1969370 | 2021-12-01 | Conecuh | Alabama | 1035 | 1931 | 62 |
1969371 | 1969371 | 2021-12-01 | Coosa | Alabama | 1037 | 1855 | 47 |
1969372 | 1969372 | 2021-12-01 | Covington | Alabama | 1039 | 6947 | 195 |
1969373 | 1969373 | 2021-12-01 | Crenshaw | Alabama | 1041 | 2613 | 77 |
1969374 | 1969374 | 2021-12-01 | Cullman | Alabama | 1043 | 16081 | 304 |
1969375 | 1969375 | 2021-12-01 | Dale | Alabama | 1045 | 9030 | 192 |
1969376 | 1969376 | 2021-12-01 | Dallas | Alabama | 1047 | 5296 | 210 |
1969377 | 1969377 | 2021-12-01 | DeKalb | Alabama | 1049 | 13008 | 269 |
1969378 | 1969378 | 2021-12-01 | Elmore | Alabama | 1051 | 15917 | 295 |
1969379 | 1969379 | 2021-12-01 | Escambia | Alabama | 1053 | 6958 | 143 |
1969380 | 1969380 | 2021-12-01 | Etowah | Alabama | 1055 | 20034 | 518 |
1969381 | 1969381 | 2021-12-01 | Fayette | Alabama | 1057 | 3308 | 85 |
1969382 | 1969382 | 2021-12-01 | Franklin | Alabama | 1059 | 6347 | 108 |
1969383 | 1969383 | 2021-12-01 | Geneva | Alabama | 1061 | 4648 | 136 |
1969384 | 1969384 | 2021-12-01 | Greene | Alabama | 1063 | 1302 | 45 |
1969385 | 1969385 | 2021-12-01 | Hale | Alabama | 1065 | 3186 | 89 |
1969386 | 1969386 | 2021-12-01 | Henry | Alabama | 1067 | 3204 | 66 |
1969387 | 1969387 | 2021-12-01 | Houston | Alabama | 1069 | 17742 | 425 |
1969388 | 1969388 | 2021-12-01 | Jackson | Alabama | 1071 | 10177 | 194 |
1969389 | 1969389 | 2021-12-01 | Jefferson | Alabama | 1073 | 116268 | 2006 |
1969390 | 1969390 | 2021-12-01 | Lamar | Alabama | 1075 | 2531 | 54 |
1969391 | 1969391 | 2021-12-01 | Lauderdale | Alabama | 1077 | 15018 | 306 |
1969392 | 1969392 | 2021-12-01 | Lawrence | Alabama | 1079 | 4836 | 130 |
1969393 | 1969393 | 2021-12-01 | Lee | Alabama | 1081 | 25623 | 263 |
1969394 | 1969394 | 2021-12-01 | Limestone | Alabama | 1083 | 16165 | 220 |
1969395 | 1969395 | 2021-12-01 | Lowndes | Alabama | 1085 | 1782 | 68 |
1969396 | 1969396 | 2021-12-01 | Macon | Alabama | 1087 | 2451 | 65 |
1969397 | 1969397 | 2021-12-01 | Madison | Alabama | 1089 | 53322 | 735 |
1969398 | 1969398 | 2021-12-01 | Marengo | Alabama | 1091 | 3424 | 93 |
1969399 | 1969399 | 2021-12-01 | Marion | Alabama | 1093 | 5416 | 130 |
1969400 | 1969400 | 2021-12-01 | Marshall | Alabama | 1095 | 18787 | 317 |
1969401 | 1969401 | 2021-12-01 | Mobile | Alabama | 1097 | 74271 | 1381 |
1969402 | 1969402 | 2021-12-01 | Monroe | Alabama | 1099 | 3376 | 66 |
1969403 | 1969403 | 2021-12-01 | Montgomery | Alabama | 1101 | 34509 | 781 |
1969404 | 1969404 | 2021-12-01 | Morgan | Alabama | 1103 | 22477 | 407 |
1969405 | 1969405 | 2021-12-01 | Perry | Alabama | 1105 | 1418 | 40 |
1969406 | 1969406 | 2021-12-01 | Pickens | Alabama | 1107 | 3343 | 89 |
1969407 | 1969407 | 2021-12-01 | Pike | Alabama | 1109 | 5120 | 109 |
1969408 | 1969408 | 2021-12-01 | Randolph | Alabama | 1111 | 3351 | 67 |
1969409 | 1969409 | 2021-12-01 | Russell | Alabama | 1113 | 7092 | 65 |
1969410 | 1969410 | 2021-12-01 | Shelby | Alabama | 1117 | 38372 | 371 |
1969411 | 1969411 | 2021-12-01 | St. Clair | Alabama | 1115 | 16918 | 358 |
1969412 | 1969412 | 2021-12-01 | Sumter | Alabama | 1119 | 1393 | 41 |
1969413 | 1969413 | 2021-12-01 | Talladega | Alabama | 1121 | 14221 | 301 |
1969414 | 1969414 | 2021-12-01 | Tallapoosa | Alabama | 1123 | 7278 | 201 |
1969415 | 1969415 | 2021-12-01 | Tuscaloosa | Alabama | 1125 | 36077 | 641 |
1969416 | 1969416 | 2021-12-01 | Walker | Alabama | 1127 | 12081 | 380 |
1969417 | 1969417 | 2021-12-01 | Washington | Alabama | 1129 | 2569 | 52 |
1969418 | 1969418 | 2021-12-01 | Wilcox | Alabama | 1131 | 1776 | 38 |
1969419 | 1969419 | 2021-12-01 | Winston | Alabama | 1133 | 4779 | 110 |
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);