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 2020-04-28 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
95321 | 95321 | 2020-04-28 | Autauga | Alabama | 1001 | 40 | 4 |
95322 | 95322 | 2020-04-28 | Baldwin | Alabama | 1003 | 171 | 3 |
95323 | 95323 | 2020-04-28 | Barbour | Alabama | 1005 | 37 | 0 |
95324 | 95324 | 2020-04-28 | Bibb | Alabama | 1007 | 42 | 0 |
95325 | 95325 | 2020-04-28 | Blount | Alabama | 1009 | 34 | 0 |
95326 | 95326 | 2020-04-28 | Bullock | Alabama | 1011 | 12 | 0 |
95327 | 95327 | 2020-04-28 | Butler | Alabama | 1013 | 45 | 1 |
95328 | 95328 | 2020-04-28 | Calhoun | Alabama | 1015 | 92 | 3 |
95329 | 95329 | 2020-04-28 | Chambers | Alabama | 1017 | 291 | 19 |
95330 | 95330 | 2020-04-28 | Cherokee | Alabama | 1019 | 15 | 0 |
95331 | 95331 | 2020-04-28 | Chilton | Alabama | 1021 | 52 | 1 |
95332 | 95332 | 2020-04-28 | Choctaw | Alabama | 1023 | 39 | 0 |
95333 | 95333 | 2020-04-28 | Clarke | Alabama | 1025 | 28 | 1 |
95334 | 95334 | 2020-04-28 | Clay | Alabama | 1027 | 19 | 1 |
95335 | 95335 | 2020-04-28 | Cleburne | Alabama | 1029 | 12 | 1 |
95336 | 95336 | 2020-04-28 | Coffee | Alabama | 1031 | 105 | 0 |
95337 | 95337 | 2020-04-28 | Colbert | Alabama | 1033 | 27 | 2 |
95338 | 95338 | 2020-04-28 | Conecuh | Alabama | 1035 | 9 | 0 |
95339 | 95339 | 2020-04-28 | Coosa | Alabama | 1037 | 31 | 1 |
95340 | 95340 | 2020-04-28 | Covington | Alabama | 1039 | 35 | 1 |
95341 | 95341 | 2020-04-28 | Crenshaw | Alabama | 1041 | 16 | 0 |
95342 | 95342 | 2020-04-28 | Cullman | Alabama | 1043 | 52 | 0 |
95343 | 95343 | 2020-04-28 | Dale | Alabama | 1045 | 25 | 0 |
95344 | 95344 | 2020-04-28 | Dallas | Alabama | 1047 | 37 | 3 |
95345 | 95345 | 2020-04-28 | DeKalb | Alabama | 1049 | 76 | 2 |
95346 | 95346 | 2020-04-28 | Elmore | Alabama | 1051 | 82 | 1 |
95347 | 95347 | 2020-04-28 | Escambia | Alabama | 1053 | 27 | 1 |
95348 | 95348 | 2020-04-28 | Etowah | Alabama | 1055 | 130 | 8 |
95349 | 95349 | 2020-04-28 | Fayette | Alabama | 1057 | 5 | 0 |
95350 | 95350 | 2020-04-28 | Franklin | Alabama | 1059 | 44 | 0 |
95351 | 95351 | 2020-04-28 | Geneva | Alabama | 1061 | 8 | 0 |
95352 | 95352 | 2020-04-28 | Greene | Alabama | 1063 | 47 | 1 |
95353 | 95353 | 2020-04-28 | Hale | Alabama | 1065 | 41 | 2 |
95354 | 95354 | 2020-04-28 | Henry | Alabama | 1067 | 22 | 1 |
95355 | 95355 | 2020-04-28 | Houston | Alabama | 1069 | 84 | 3 |
95356 | 95356 | 2020-04-28 | Jackson | Alabama | 1071 | 46 | 2 |
95357 | 95357 | 2020-04-28 | Jefferson | Alabama | 1073 | 861 | 41 |
95358 | 95358 | 2020-04-28 | Lamar | Alabama | 1075 | 10 | 0 |
95359 | 95359 | 2020-04-28 | Lauderdale | Alabama | 1077 | 30 | 2 |
95360 | 95360 | 2020-04-28 | Lawrence | Alabama | 1079 | 12 | 0 |
95361 | 95361 | 2020-04-28 | Lee | Alabama | 1081 | 377 | 25 |
95362 | 95362 | 2020-04-28 | Limestone | Alabama | 1083 | 44 | 0 |
95363 | 95363 | 2020-04-28 | Lowndes | Alabama | 1085 | 53 | 1 |
95364 | 95364 | 2020-04-28 | Macon | Alabama | 1087 | 35 | 2 |
95365 | 95365 | 2020-04-28 | Madison | Alabama | 1089 | 222 | 4 |
95366 | 95366 | 2020-04-28 | Marengo | Alabama | 1091 | 44 | 3 |
95367 | 95367 | 2020-04-28 | Marion | Alabama | 1093 | 76 | 6 |
95368 | 95368 | 2020-04-28 | Marshall | Alabama | 1095 | 313 | 6 |
95369 | 95369 | 2020-04-28 | Mobile | Alabama | 1097 | 994 | 46 |
95370 | 95370 | 2020-04-28 | Monroe | Alabama | 1099 | 12 | 1 |
95371 | 95371 | 2020-04-28 | Montgomery | Alabama | 1101 | 302 | 5 |
95372 | 95372 | 2020-04-28 | Morgan | Alabama | 1103 | 68 | 0 |
95373 | 95373 | 2020-04-28 | Perry | Alabama | 1105 | 9 | 0 |
95374 | 95374 | 2020-04-28 | Pickens | Alabama | 1107 | 47 | 1 |
95375 | 95375 | 2020-04-28 | Pike | Alabama | 1109 | 65 | 0 |
95376 | 95376 | 2020-04-28 | Randolph | Alabama | 1111 | 62 | 4 |
95377 | 95377 | 2020-04-28 | Russell | Alabama | 1113 | 55 | 0 |
95378 | 95378 | 2020-04-28 | Shelby | Alabama | 1117 | 319 | 10 |
95379 | 95379 | 2020-04-28 | St. Clair | Alabama | 1115 | 70 | 0 |
95380 | 95380 | 2020-04-28 | Sumter | Alabama | 1119 | 55 | 2 |
95381 | 95381 | 2020-04-28 | Talladega | Alabama | 1121 | 59 | 2 |
95382 | 95382 | 2020-04-28 | Tallapoosa | Alabama | 1123 | 279 | 17 |
95383 | 95383 | 2020-04-28 | Tuscaloosa | Alabama | 1125 | 199 | 0 |
95384 | 95384 | 2020-04-28 | Walker | Alabama | 1127 | 94 | 0 |
95385 | 95385 | 2020-04-28 | Washington | Alabama | 1129 | 33 | 1 |
95386 | 95386 | 2020-04-28 | Wilcox | Alabama | 1131 | 60 | 1 |
95387 | 95387 | 2020-04-28 | Winston | Alabama | 1133 | 13 | 0 |
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);