ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-11-03" 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 |
---|---|---|---|---|---|---|---|
693283 | 693283 | 2020-11-03 | Autauga | Alabama | 1001 | 2197 | 31 |
693284 | 693284 | 2020-11-03 | Baldwin | Alabama | 1003 | 6995 | 74 |
693285 | 693285 | 2020-11-03 | Barbour | Alabama | 1005 | 1074 | 9 |
693286 | 693286 | 2020-11-03 | Bibb | Alabama | 1007 | 890 | 15 |
693287 | 693287 | 2020-11-03 | Blount | Alabama | 1009 | 2162 | 25 |
693288 | 693288 | 2020-11-03 | Bullock | Alabama | 1011 | 657 | 17 |
693289 | 693289 | 2020-11-03 | Butler | Alabama | 1013 | 1029 | 41 |
693290 | 693290 | 2020-11-03 | Calhoun | Alabama | 1015 | 4951 | 65 |
693291 | 693291 | 2020-11-03 | Chambers | Alabama | 1017 | 1428 | 47 |
693292 | 693292 | 2020-11-03 | Cherokee | Alabama | 1019 | 808 | 15 |
693293 | 693293 | 2020-11-03 | Chilton | Alabama | 1021 | 1962 | 33 |
693294 | 693294 | 2020-11-03 | Choctaw | Alabama | 1023 | 396 | 12 |
693295 | 693295 | 2020-11-03 | Clarke | Alabama | 1025 | 1409 | 17 |
693296 | 693296 | 2020-11-03 | Clay | Alabama | 1027 | 785 | 13 |
693297 | 693297 | 2020-11-03 | Cleburne | Alabama | 1029 | 590 | 9 |
693298 | 693298 | 2020-11-03 | Coffee | Alabama | 1031 | 1893 | 11 |
693299 | 693299 | 2020-11-03 | Colbert | Alabama | 1033 | 2336 | 32 |
693300 | 693300 | 2020-11-03 | Conecuh | Alabama | 1035 | 584 | 13 |
693301 | 693301 | 2020-11-03 | Coosa | Alabama | 1037 | 228 | 3 |
693302 | 693302 | 2020-11-03 | Covington | Alabama | 1039 | 1895 | 30 |
693303 | 693303 | 2020-11-03 | Crenshaw | Alabama | 1041 | 626 | 30 |
693304 | 693304 | 2020-11-03 | Cullman | Alabama | 1043 | 2915 | 25 |
693305 | 693305 | 2020-11-03 | Dale | Alabama | 1045 | 1955 | 52 |
693306 | 693306 | 2020-11-03 | Dallas | Alabama | 1047 | 1924 | 27 |
693307 | 693307 | 2020-11-03 | DeKalb | Alabama | 1049 | 3721 | 30 |
693308 | 693308 | 2020-11-03 | Elmore | Alabama | 1051 | 3342 | 59 |
693309 | 693309 | 2020-11-03 | Escambia | Alabama | 1053 | 1785 | 31 |
693310 | 693310 | 2020-11-03 | Etowah | Alabama | 1055 | 4578 | 54 |
693311 | 693311 | 2020-11-03 | Fayette | Alabama | 1057 | 616 | 15 |
693312 | 693312 | 2020-11-03 | Franklin | Alabama | 1059 | 2192 | 32 |
693313 | 693313 | 2020-11-03 | Geneva | Alabama | 1061 | 985 | 7 |
693314 | 693314 | 2020-11-03 | Greene | Alabama | 1063 | 351 | 17 |
693315 | 693315 | 2020-11-03 | Hale | Alabama | 1065 | 801 | 30 |
693316 | 693316 | 2020-11-03 | Henry | Alabama | 1067 | 757 | 6 |
693317 | 693317 | 2020-11-03 | Houston | Alabama | 1069 | 4341 | 35 |
693318 | 693318 | 2020-11-03 | Jackson | Alabama | 1071 | 2363 | 19 |
693319 | 693319 | 2020-11-03 | Jefferson | Alabama | 1073 | 24754 | 388 |
693320 | 693320 | 2020-11-03 | Lamar | Alabama | 1075 | 533 | 7 |
693321 | 693321 | 2020-11-03 | Lauderdale | Alabama | 1077 | 2798 | 43 |
693322 | 693322 | 2020-11-03 | Lawrence | Alabama | 1079 | 958 | 33 |
693323 | 693323 | 2020-11-03 | Lee | Alabama | 1081 | 6749 | 65 |
693324 | 693324 | 2020-11-03 | Limestone | Alabama | 1083 | 3166 | 34 |
693325 | 693325 | 2020-11-03 | Lowndes | Alabama | 1085 | 733 | 29 |
693326 | 693326 | 2020-11-03 | Macon | Alabama | 1087 | 572 | 21 |
693327 | 693327 | 2020-11-03 | Madison | Alabama | 1089 | 9893 | 101 |
693328 | 693328 | 2020-11-03 | Marengo | Alabama | 1091 | 1069 | 24 |
693329 | 693329 | 2020-11-03 | Marion | Alabama | 1093 | 1150 | 31 |
693330 | 693330 | 2020-11-03 | Marshall | Alabama | 1095 | 4618 | 53 |
693331 | 693331 | 2020-11-03 | Mobile | Alabama | 1097 | 17406 | 323 |
693332 | 693332 | 2020-11-03 | Monroe | Alabama | 1099 | 674 | 10 |
693333 | 693333 | 2020-11-03 | Montgomery | Alabama | 1101 | 10814 | 211 |
693334 | 693334 | 2020-11-03 | Morgan | Alabama | 1103 | 4594 | 37 |
693335 | 693335 | 2020-11-03 | Perry | Alabama | 1105 | 606 | 6 |
693336 | 693336 | 2020-11-03 | Pickens | Alabama | 1107 | 944 | 18 |
693337 | 693337 | 2020-11-03 | Pike | Alabama | 1109 | 1399 | 14 |
693338 | 693338 | 2020-11-03 | Randolph | Alabama | 1111 | 871 | 16 |
693339 | 693339 | 2020-11-03 | Russell | Alabama | 1113 | 2006 | 3 |
693340 | 693340 | 2020-11-03 | Shelby | Alabama | 1117 | 7870 | 70 |
693341 | 693341 | 2020-11-03 | St. Clair | Alabama | 1115 | 3298 | 46 |
693342 | 693342 | 2020-11-03 | Sumter | Alabama | 1119 | 489 | 21 |
693343 | 693343 | 2020-11-03 | Talladega | Alabama | 1121 | 2843 | 38 |
693344 | 693344 | 2020-11-03 | Tallapoosa | Alabama | 1123 | 1419 | 87 |
693345 | 693345 | 2020-11-03 | Tuscaloosa | Alabama | 1125 | 10844 | 145 |
693346 | 693346 | 2020-11-03 | Walker | Alabama | 1127 | 2992 | 95 |
693347 | 693347 | 2020-11-03 | Washington | Alabama | 1129 | 779 | 12 |
693348 | 693348 | 2020-11-03 | Wilcox | Alabama | 1131 | 579 | 12 |
693349 | 693349 | 2020-11-03 | Winston | Alabama | 1133 | 988 | 13 |
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);