ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-09-02" 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 |
---|---|---|---|---|---|---|---|
492375 | 492375 | 2020-09-02 | Autauga | Alabama | 1001 | 1452 | 24 |
492376 | 492376 | 2020-09-02 | Baldwin | Alabama | 1003 | 4583 | 42 |
492377 | 492377 | 2020-09-02 | Barbour | Alabama | 1005 | 768 | 7 |
492378 | 492378 | 2020-09-02 | Bibb | Alabama | 1007 | 562 | 8 |
492379 | 492379 | 2020-09-02 | Blount | Alabama | 1009 | 1308 | 11 |
492380 | 492380 | 2020-09-02 | Bullock | Alabama | 1011 | 561 | 14 |
492381 | 492381 | 2020-09-02 | Butler | Alabama | 1013 | 872 | 37 |
492382 | 492382 | 2020-09-02 | Calhoun | Alabama | 1015 | 2633 | 38 |
492383 | 492383 | 2020-09-02 | Chambers | Alabama | 1017 | 1045 | 40 |
492384 | 492384 | 2020-09-02 | Cherokee | Alabama | 1019 | 420 | 12 |
492385 | 492385 | 2020-09-02 | Chilton | Alabama | 1021 | 1217 | 14 |
492386 | 492386 | 2020-09-02 | Choctaw | Alabama | 1023 | 326 | 12 |
492387 | 492387 | 2020-09-02 | Clarke | Alabama | 1025 | 997 | 14 |
492388 | 492388 | 2020-09-02 | Clay | Alabama | 1027 | 385 | 6 |
492389 | 492389 | 2020-09-02 | Cleburne | Alabama | 1029 | 213 | 5 |
492390 | 492390 | 2020-09-02 | Coffee | Alabama | 1031 | 1105 | 7 |
492391 | 492391 | 2020-09-02 | Colbert | Alabama | 1033 | 1479 | 22 |
492392 | 492392 | 2020-09-02 | Conecuh | Alabama | 1035 | 489 | 11 |
492393 | 492393 | 2020-09-02 | Coosa | Alabama | 1037 | 137 | 3 |
492394 | 492394 | 2020-09-02 | Covington | Alabama | 1039 | 1114 | 27 |
492395 | 492395 | 2020-09-02 | Crenshaw | Alabama | 1041 | 476 | 29 |
492396 | 492396 | 2020-09-02 | Cullman | Alabama | 1043 | 1666 | 15 |
492397 | 492397 | 2020-09-02 | Dale | Alabama | 1045 | 1132 | 39 |
492398 | 492398 | 2020-09-02 | Dallas | Alabama | 1047 | 1646 | 25 |
492399 | 492399 | 2020-09-02 | DeKalb | Alabama | 1049 | 2173 | 17 |
492400 | 492400 | 2020-09-02 | Elmore | Alabama | 1051 | 2234 | 46 |
492401 | 492401 | 2020-09-02 | Escambia | Alabama | 1053 | 1435 | 22 |
492402 | 492402 | 2020-09-02 | Etowah | Alabama | 1055 | 2846 | 42 |
492403 | 492403 | 2020-09-02 | Fayette | Alabama | 1057 | 327 | 6 |
492404 | 492404 | 2020-09-02 | Franklin | Alabama | 1059 | 1580 | 27 |
492405 | 492405 | 2020-09-02 | Geneva | Alabama | 1061 | 453 | 4 |
492406 | 492406 | 2020-09-02 | Greene | Alabama | 1063 | 286 | 15 |
492407 | 492407 | 2020-09-02 | Hale | Alabama | 1065 | 564 | 28 |
492408 | 492408 | 2020-09-02 | Henry | Alabama | 1067 | 392 | 4 |
492409 | 492409 | 2020-09-02 | Houston | Alabama | 1069 | 2157 | 19 |
492410 | 492410 | 2020-09-02 | Jackson | Alabama | 1071 | 1335 | 9 |
492411 | 492411 | 2020-09-02 | Jefferson | Alabama | 1073 | 16801 | 303 |
492412 | 492412 | 2020-09-02 | Lamar | Alabama | 1075 | 296 | 2 |
492413 | 492413 | 2020-09-02 | Lauderdale | Alabama | 1077 | 1466 | 25 |
492414 | 492414 | 2020-09-02 | Lawrence | Alabama | 1079 | 483 | 5 |
492415 | 492415 | 2020-09-02 | Lee | Alabama | 1081 | 4814 | 56 |
492416 | 492416 | 2020-09-02 | Limestone | Alabama | 1083 | 1713 | 16 |
492417 | 492417 | 2020-09-02 | Lowndes | Alabama | 1085 | 624 | 26 |
492418 | 492418 | 2020-09-02 | Macon | Alabama | 1087 | 442 | 19 |
492419 | 492419 | 2020-09-02 | Madison | Alabama | 1089 | 6595 | 61 |
492420 | 492420 | 2020-09-02 | Marengo | Alabama | 1091 | 651 | 18 |
492421 | 492421 | 2020-09-02 | Marion | Alabama | 1093 | 799 | 28 |
492422 | 492422 | 2020-09-02 | Marshall | Alabama | 1095 | 3641 | 42 |
492423 | 492423 | 2020-09-02 | Mobile | Alabama | 1097 | 12346 | 267 |
492424 | 492424 | 2020-09-02 | Monroe | Alabama | 1099 | 547 | 7 |
492425 | 492425 | 2020-09-02 | Montgomery | Alabama | 1101 | 8069 | 164 |
492426 | 492426 | 2020-09-02 | Morgan | Alabama | 1103 | 2935 | 24 |
492427 | 492427 | 2020-09-02 | Perry | Alabama | 1105 | 521 | 5 |
492428 | 492428 | 2020-09-02 | Pickens | Alabama | 1107 | 567 | 12 |
492429 | 492429 | 2020-09-02 | Pike | Alabama | 1109 | 997 | 9 |
492430 | 492430 | 2020-09-02 | Randolph | Alabama | 1111 | 524 | 12 |
492431 | 492431 | 2020-09-02 | Russell | Alabama | 1113 | 1641 | 2 |
492432 | 492432 | 2020-09-02 | Shelby | Alabama | 1117 | 4700 | 47 |
492433 | 492433 | 2020-09-02 | St. Clair | Alabama | 1115 | 1888 | 30 |
492434 | 492434 | 2020-09-02 | Sumter | Alabama | 1119 | 406 | 19 |
492435 | 492435 | 2020-09-02 | Talladega | Alabama | 1121 | 1791 | 22 |
492436 | 492436 | 2020-09-02 | Tallapoosa | Alabama | 1123 | 1066 | 83 |
492437 | 492437 | 2020-09-02 | Tuscaloosa | Alabama | 1125 | 5970 | 100 |
492438 | 492438 | 2020-09-02 | Walker | Alabama | 1127 | 1945 | 77 |
492439 | 492439 | 2020-09-02 | Washington | Alabama | 1129 | 524 | 13 |
492440 | 492440 | 2020-09-02 | Wilcox | Alabama | 1131 | 519 | 11 |
492441 | 492441 | 2020-09-02 | Winston | Alabama | 1133 | 590 | 11 |
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);