ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-08-30" 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 |
---|---|---|---|---|---|---|---|
482674 | 482674 | 2020-08-30 | Autauga | Alabama | 1001 | 1438 | 23 |
482675 | 482675 | 2020-08-30 | Baldwin | Alabama | 1003 | 4525 | 40 |
482676 | 482676 | 2020-08-30 | Barbour | Alabama | 1005 | 757 | 7 |
482677 | 482677 | 2020-08-30 | Bibb | Alabama | 1007 | 550 | 7 |
482678 | 482678 | 2020-08-30 | Blount | Alabama | 1009 | 1277 | 10 |
482679 | 482679 | 2020-08-30 | Bullock | Alabama | 1011 | 550 | 14 |
482680 | 482680 | 2020-08-30 | Butler | Alabama | 1013 | 864 | 37 |
482681 | 482681 | 2020-08-30 | Calhoun | Alabama | 1015 | 2533 | 35 |
482682 | 482682 | 2020-08-30 | Chambers | Alabama | 1017 | 1027 | 40 |
482683 | 482683 | 2020-08-30 | Cherokee | Alabama | 1019 | 404 | 12 |
482684 | 482684 | 2020-08-30 | Chilton | Alabama | 1021 | 1178 | 13 |
482685 | 482685 | 2020-08-30 | Choctaw | Alabama | 1023 | 326 | 12 |
482686 | 482686 | 2020-08-30 | Clarke | Alabama | 1025 | 988 | 14 |
482687 | 482687 | 2020-08-30 | Clay | Alabama | 1027 | 370 | 6 |
482688 | 482688 | 2020-08-30 | Cleburne | Alabama | 1029 | 204 | 5 |
482689 | 482689 | 2020-08-30 | Coffee | Alabama | 1031 | 1079 | 7 |
482690 | 482690 | 2020-08-30 | Colbert | Alabama | 1033 | 1456 | 22 |
482691 | 482691 | 2020-08-30 | Conecuh | Alabama | 1035 | 484 | 11 |
482692 | 482692 | 2020-08-30 | Coosa | Alabama | 1037 | 135 | 3 |
482693 | 482693 | 2020-08-30 | Covington | Alabama | 1039 | 1091 | 26 |
482694 | 482694 | 2020-08-30 | Crenshaw | Alabama | 1041 | 466 | 27 |
482695 | 482695 | 2020-08-30 | Cullman | Alabama | 1043 | 1627 | 14 |
482696 | 482696 | 2020-08-30 | Dale | Alabama | 1045 | 1093 | 37 |
482697 | 482697 | 2020-08-30 | Dallas | Alabama | 1047 | 1614 | 25 |
482698 | 482698 | 2020-08-30 | DeKalb | Alabama | 1049 | 2144 | 16 |
482699 | 482699 | 2020-08-30 | Elmore | Alabama | 1051 | 2183 | 44 |
482700 | 482700 | 2020-08-30 | Escambia | Alabama | 1053 | 1402 | 22 |
482701 | 482701 | 2020-08-30 | Etowah | Alabama | 1055 | 2790 | 39 |
482702 | 482702 | 2020-08-30 | Fayette | Alabama | 1057 | 313 | 6 |
482703 | 482703 | 2020-08-30 | Franklin | Alabama | 1059 | 1562 | 27 |
482704 | 482704 | 2020-08-30 | Geneva | Alabama | 1061 | 430 | 4 |
482705 | 482705 | 2020-08-30 | Greene | Alabama | 1063 | 284 | 15 |
482706 | 482706 | 2020-08-30 | Hale | Alabama | 1065 | 558 | 28 |
482707 | 482707 | 2020-08-30 | Henry | Alabama | 1067 | 365 | 4 |
482708 | 482708 | 2020-08-30 | Houston | Alabama | 1069 | 2039 | 18 |
482709 | 482709 | 2020-08-30 | Jackson | Alabama | 1071 | 1317 | 9 |
482710 | 482710 | 2020-08-30 | Jefferson | Alabama | 1073 | 16278 | 303 |
482711 | 482711 | 2020-08-30 | Lamar | Alabama | 1075 | 289 | 2 |
482712 | 482712 | 2020-08-30 | Lauderdale | Alabama | 1077 | 1429 | 23 |
482713 | 482713 | 2020-08-30 | Lawrence | Alabama | 1079 | 472 | 5 |
482714 | 482714 | 2020-08-30 | Lee | Alabama | 1081 | 4451 | 54 |
482715 | 482715 | 2020-08-30 | Limestone | Alabama | 1083 | 1678 | 16 |
482716 | 482716 | 2020-08-30 | Lowndes | Alabama | 1085 | 619 | 26 |
482717 | 482717 | 2020-08-30 | Macon | Alabama | 1087 | 432 | 19 |
482718 | 482718 | 2020-08-30 | Madison | Alabama | 1089 | 6428 | 52 |
482719 | 482719 | 2020-08-30 | Marengo | Alabama | 1091 | 638 | 18 |
482720 | 482720 | 2020-08-30 | Marion | Alabama | 1093 | 786 | 28 |
482721 | 482721 | 2020-08-30 | Marshall | Alabama | 1095 | 3616 | 42 |
482722 | 482722 | 2020-08-30 | Mobile | Alabama | 1097 | 12197 | 260 |
482723 | 482723 | 2020-08-30 | Monroe | Alabama | 1099 | 544 | 7 |
482724 | 482724 | 2020-08-30 | Montgomery | Alabama | 1101 | 7976 | 163 |
482725 | 482725 | 2020-08-30 | Morgan | Alabama | 1103 | 2902 | 24 |
482726 | 482726 | 2020-08-30 | Perry | Alabama | 1105 | 516 | 5 |
482727 | 482727 | 2020-08-30 | Pickens | Alabama | 1107 | 560 | 11 |
482728 | 482728 | 2020-08-30 | Pike | Alabama | 1109 | 958 | 8 |
482729 | 482729 | 2020-08-30 | Randolph | Alabama | 1111 | 510 | 12 |
482730 | 482730 | 2020-08-30 | Russell | Alabama | 1113 | 1614 | 2 |
482731 | 482731 | 2020-08-30 | Shelby | Alabama | 1117 | 4527 | 47 |
482732 | 482732 | 2020-08-30 | St. Clair | Alabama | 1115 | 1833 | 28 |
482733 | 482733 | 2020-08-30 | Sumter | Alabama | 1119 | 403 | 19 |
482734 | 482734 | 2020-08-30 | Talladega | Alabama | 1121 | 1752 | 20 |
482735 | 482735 | 2020-08-30 | Tallapoosa | Alabama | 1123 | 1044 | 82 |
482736 | 482736 | 2020-08-30 | Tuscaloosa | Alabama | 1125 | 5848 | 97 |
482737 | 482737 | 2020-08-30 | Walker | Alabama | 1127 | 1907 | 75 |
482738 | 482738 | 2020-08-30 | Washington | Alabama | 1129 | 518 | 13 |
482739 | 482739 | 2020-08-30 | Wilcox | Alabama | 1131 | 514 | 11 |
482740 | 482740 | 2020-08-30 | Winston | Alabama | 1133 | 573 | 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);