ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-07-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 |
---|---|---|---|---|---|---|---|
382722 | 382722 | 2020-07-30 | Autauga | Alabama | 1001 | 1002 | 21 |
382723 | 382723 | 2020-07-30 | Baldwin | Alabama | 1003 | 3028 | 21 |
382724 | 382724 | 2020-07-30 | Barbour | Alabama | 1005 | 585 | 5 |
382725 | 382725 | 2020-07-30 | Bibb | Alabama | 1007 | 352 | 2 |
382726 | 382726 | 2020-07-30 | Blount | Alabama | 1009 | 731 | 3 |
382727 | 382727 | 2020-07-30 | Bullock | Alabama | 1011 | 435 | 12 |
382728 | 382728 | 2020-07-30 | Butler | Alabama | 1013 | 747 | 36 |
382729 | 382729 | 2020-07-30 | Calhoun | Alabama | 1015 | 1336 | 8 |
382730 | 382730 | 2020-07-30 | Chambers | Alabama | 1017 | 848 | 38 |
382731 | 382731 | 2020-07-30 | Cherokee | Alabama | 1019 | 234 | 8 |
382732 | 382732 | 2020-07-30 | Chilton | Alabama | 1021 | 686 | 6 |
382733 | 382733 | 2020-07-30 | Choctaw | Alabama | 1023 | 270 | 12 |
382734 | 382734 | 2020-07-30 | Clarke | Alabama | 1025 | 487 | 9 |
382735 | 382735 | 2020-07-30 | Clay | Alabama | 1027 | 193 | 5 |
382736 | 382736 | 2020-07-30 | Cleburne | Alabama | 1029 | 110 | 1 |
382737 | 382737 | 2020-07-30 | Coffee | Alabama | 1031 | 697 | 5 |
382738 | 382738 | 2020-07-30 | Colbert | Alabama | 1033 | 1023 | 11 |
382739 | 382739 | 2020-07-30 | Conecuh | Alabama | 1035 | 365 | 10 |
382740 | 382740 | 2020-07-30 | Coosa | Alabama | 1037 | 94 | 2 |
382741 | 382741 | 2020-07-30 | Covington | Alabama | 1039 | 749 | 21 |
382742 | 382742 | 2020-07-30 | Crenshaw | Alabama | 1041 | 279 | 4 |
382743 | 382743 | 2020-07-30 | Cullman | Alabama | 1043 | 1099 | 11 |
382744 | 382744 | 2020-07-30 | Dale | Alabama | 1045 | 751 | 18 |
382745 | 382745 | 2020-07-30 | Dallas | Alabama | 1047 | 1301 | 23 |
382746 | 382746 | 2020-07-30 | DeKalb | Alabama | 1049 | 1622 | 11 |
382747 | 382747 | 2020-07-30 | Elmore | Alabama | 1051 | 1568 | 35 |
382748 | 382748 | 2020-07-30 | Escambia | Alabama | 1053 | 972 | 15 |
382749 | 382749 | 2020-07-30 | Etowah | Alabama | 1055 | 1846 | 19 |
382750 | 382750 | 2020-07-30 | Fayette | Alabama | 1057 | 170 | 5 |
382751 | 382751 | 2020-07-30 | Franklin | Alabama | 1059 | 1156 | 20 |
382752 | 382752 | 2020-07-30 | Geneva | Alabama | 1061 | 210 | 1 |
382753 | 382753 | 2020-07-30 | Greene | Alabama | 1063 | 241 | 11 |
382754 | 382754 | 2020-07-30 | Hale | Alabama | 1065 | 447 | 25 |
382755 | 382755 | 2020-07-30 | Henry | Alabama | 1067 | 242 | 4 |
382756 | 382756 | 2020-07-30 | Houston | Alabama | 1069 | 1251 | 14 |
382757 | 382757 | 2020-07-30 | Jackson | Alabama | 1071 | 730 | 5 |
382758 | 382758 | 2020-07-30 | Jefferson | Alabama | 1073 | 11111 | 222 |
382759 | 382759 | 2020-07-30 | Lamar | Alabama | 1075 | 194 | 2 |
382760 | 382760 | 2020-07-30 | Lauderdale | Alabama | 1077 | 996 | 10 |
382761 | 382761 | 2020-07-30 | Lawrence | Alabama | 1079 | 286 | 0 |
382762 | 382762 | 2020-07-30 | Lee | Alabama | 1081 | 2520 | 43 |
382763 | 382763 | 2020-07-30 | Limestone | Alabama | 1083 | 1134 | 12 |
382764 | 382764 | 2020-07-30 | Lowndes | Alabama | 1085 | 559 | 26 |
382765 | 382765 | 2020-07-30 | Macon | Alabama | 1087 | 308 | 12 |
382766 | 382766 | 2020-07-30 | Madison | Alabama | 1089 | 4744 | 30 |
382767 | 382767 | 2020-07-30 | Marengo | Alabama | 1091 | 509 | 14 |
382768 | 382768 | 2020-07-30 | Marion | Alabama | 1093 | 537 | 24 |
382769 | 382769 | 2020-07-30 | Marshall | Alabama | 1095 | 2843 | 29 |
382770 | 382770 | 2020-07-30 | Mobile | Alabama | 1097 | 7915 | 186 |
382771 | 382771 | 2020-07-30 | Monroe | Alabama | 1099 | 420 | 4 |
382772 | 382772 | 2020-07-30 | Montgomery | Alabama | 1101 | 6045 | 142 |
382773 | 382773 | 2020-07-30 | Morgan | Alabama | 1103 | 2125 | 15 |
382774 | 382774 | 2020-07-30 | Perry | Alabama | 1105 | 432 | 3 |
382775 | 382775 | 2020-07-30 | Pickens | Alabama | 1107 | 353 | 10 |
382776 | 382776 | 2020-07-30 | Pike | Alabama | 1109 | 641 | 7 |
382777 | 382777 | 2020-07-30 | Randolph | Alabama | 1111 | 388 | 11 |
382778 | 382778 | 2020-07-30 | Russell | Alabama | 1113 | 1168 | 1 |
382779 | 382779 | 2020-07-30 | Shelby | Alabama | 1117 | 2979 | 32 |
382780 | 382780 | 2020-07-30 | St. Clair | Alabama | 1115 | 1179 | 9 |
382781 | 382781 | 2020-07-30 | Sumter | Alabama | 1119 | 357 | 17 |
382782 | 382782 | 2020-07-30 | Talladega | Alabama | 1121 | 944 | 13 |
382783 | 382783 | 2020-07-30 | Tallapoosa | Alabama | 1123 | 824 | 79 |
382784 | 382784 | 2020-07-30 | Tuscaloosa | Alabama | 1125 | 3822 | 63 |
382785 | 382785 | 2020-07-30 | Walker | Alabama | 1127 | 1445 | 63 |
382786 | 382786 | 2020-07-30 | Washington | Alabama | 1129 | 301 | 10 |
382787 | 382787 | 2020-07-30 | Wilcox | Alabama | 1131 | 404 | 9 |
382788 | 382788 | 2020-07-30 | Winston | Alabama | 1133 | 422 | 10 |
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);