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 2021-09-26 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1754882 | 1754882 | 2021-09-26 | Autauga | Alabama | 1001 | 9667 | 137 |
1754883 | 1754883 | 2021-09-26 | Baldwin | Alabama | 1003 | 36242 | 495 |
1754884 | 1754884 | 2021-09-26 | Barbour | Alabama | 1005 | 3472 | 70 |
1754885 | 1754885 | 2021-09-26 | Bibb | Alabama | 1007 | 4093 | 81 |
1754886 | 1754886 | 2021-09-26 | Blount | Alabama | 1009 | 9720 | 157 |
1754887 | 1754887 | 2021-09-26 | Bullock | Alabama | 1011 | 1492 | 43 |
1754888 | 1754888 | 2021-09-26 | Butler | Alabama | 1013 | 3182 | 90 |
1754889 | 1754889 | 2021-09-26 | Calhoun | Alabama | 1015 | 21211 | 410 |
1754890 | 1754890 | 2021-09-26 | Chambers | Alabama | 1017 | 5416 | 134 |
1754891 | 1754891 | 2021-09-26 | Cherokee | Alabama | 1019 | 2898 | 55 |
1754892 | 1754892 | 2021-09-26 | Chilton | Alabama | 1021 | 6385 | 144 |
1754893 | 1754893 | 2021-09-26 | Choctaw | Alabama | 1023 | 734 | 27 |
1754894 | 1754894 | 2021-09-26 | Clarke | Alabama | 1025 | 4632 | 79 |
1754895 | 1754895 | 2021-09-26 | Clay | Alabama | 1027 | 2285 | 65 |
1754896 | 1754896 | 2021-09-26 | Cleburne | Alabama | 1029 | 2358 | 51 |
1754897 | 1754897 | 2021-09-26 | Coffee | Alabama | 1031 | 8882 | 175 |
1754898 | 1754898 | 2021-09-26 | Colbert | Alabama | 1033 | 8534 | 184 |
1754899 | 1754899 | 2021-09-26 | Conecuh | Alabama | 1035 | 1820 | 46 |
1754900 | 1754900 | 2021-09-26 | Coosa | Alabama | 1037 | 1702 | 35 |
1754901 | 1754901 | 2021-09-26 | Covington | Alabama | 1039 | 6452 | 167 |
1754902 | 1754902 | 2021-09-26 | Crenshaw | Alabama | 1041 | 2384 | 70 |
1754903 | 1754903 | 2021-09-26 | Cullman | Alabama | 1043 | 14602 | 258 |
1754904 | 1754904 | 2021-09-26 | Dale | Alabama | 1045 | 8609 | 173 |
1754905 | 1754905 | 2021-09-26 | Dallas | Alabama | 1047 | 4705 | 189 |
1754906 | 1754906 | 2021-09-26 | DeKalb | Alabama | 1049 | 12199 | 237 |
1754907 | 1754907 | 2021-09-26 | Elmore | Alabama | 1051 | 14480 | 264 |
1754908 | 1754908 | 2021-09-26 | Escambia | Alabama | 1053 | 6591 | 121 |
1754909 | 1754909 | 2021-09-26 | Etowah | Alabama | 1055 | 19300 | 462 |
1754910 | 1754910 | 2021-09-26 | Fayette | Alabama | 1057 | 2796 | 73 |
1754911 | 1754911 | 2021-09-26 | Franklin | Alabama | 1059 | 5795 | 101 |
1754912 | 1754912 | 2021-09-26 | Geneva | Alabama | 1061 | 4413 | 117 |
1754913 | 1754913 | 2021-09-26 | Greene | Alabama | 1063 | 1214 | 43 |
1754914 | 1754914 | 2021-09-26 | Hale | Alabama | 1065 | 2926 | 85 |
1754915 | 1754915 | 2021-09-26 | Henry | Alabama | 1067 | 3018 | 58 |
1754916 | 1754916 | 2021-09-26 | Houston | Alabama | 1069 | 16823 | 386 |
1754917 | 1754917 | 2021-09-26 | Jackson | Alabama | 1071 | 9385 | 158 |
1754918 | 1754918 | 2021-09-26 | Jefferson | Alabama | 1073 | 111599 | 1765 |
1754919 | 1754919 | 2021-09-26 | Lamar | Alabama | 1075 | 1977 | 43 |
1754920 | 1754920 | 2021-09-26 | Lauderdale | Alabama | 1077 | 13520 | 281 |
1754921 | 1754921 | 2021-09-26 | Lawrence | Alabama | 1079 | 4117 | 108 |
1754922 | 1754922 | 2021-09-26 | Lee | Alabama | 1081 | 22680 | 220 |
1754923 | 1754923 | 2021-09-26 | Limestone | Alabama | 1083 | 14581 | 188 |
1754924 | 1754924 | 2021-09-26 | Lowndes | Alabama | 1085 | 1707 | 58 |
1754925 | 1754925 | 2021-09-26 | Macon | Alabama | 1087 | 2201 | 58 |
1754926 | 1754926 | 2021-09-26 | Madison | Alabama | 1089 | 49865 | 633 |
1754927 | 1754927 | 2021-09-26 | Marengo | Alabama | 1091 | 3262 | 85 |
1754928 | 1754928 | 2021-09-26 | Marion | Alabama | 1093 | 4800 | 120 |
1754929 | 1754929 | 2021-09-26 | Marshall | Alabama | 1095 | 17680 | 274 |
1754930 | 1754930 | 2021-09-26 | Mobile | Alabama | 1097 | 70851 | 1234 |
1754931 | 1754931 | 2021-09-26 | Monroe | Alabama | 1099 | 3200 | 53 |
1754932 | 1754932 | 2021-09-26 | Montgomery | Alabama | 1101 | 33190 | 678 |
1754933 | 1754933 | 2021-09-26 | Morgan | Alabama | 1103 | 19816 | 335 |
1754934 | 1754934 | 2021-09-26 | Perry | Alabama | 1105 | 1365 | 37 |
1754935 | 1754935 | 2021-09-26 | Pickens | Alabama | 1107 | 3052 | 74 |
1754936 | 1754936 | 2021-09-26 | Pike | Alabama | 1109 | 4623 | 97 |
1754937 | 1754937 | 2021-09-26 | Randolph | Alabama | 1111 | 3059 | 56 |
1754938 | 1754938 | 2021-09-26 | Russell | Alabama | 1113 | 6072 | 55 |
1754939 | 1754939 | 2021-09-26 | Shelby | Alabama | 1117 | 36274 | 315 |
1754940 | 1754940 | 2021-09-26 | St. Clair | Alabama | 1115 | 15442 | 305 |
1754941 | 1754941 | 2021-09-26 | Sumter | Alabama | 1119 | 1245 | 36 |
1754942 | 1754942 | 2021-09-26 | Talladega | Alabama | 1121 | 12958 | 236 |
1754943 | 1754943 | 2021-09-26 | Tallapoosa | Alabama | 1123 | 6673 | 181 |
1754944 | 1754944 | 2021-09-26 | Tuscaloosa | Alabama | 1125 | 33931 | 548 |
1754945 | 1754945 | 2021-09-26 | Walker | Alabama | 1127 | 10588 | 330 |
1754946 | 1754946 | 2021-09-26 | Washington | Alabama | 1129 | 2454 | 48 |
1754947 | 1754947 | 2021-09-26 | Wilcox | Alabama | 1131 | 1597 | 36 |
1754948 | 1754948 | 2021-09-26 | Winston | Alabama | 1133 | 4258 | 95 |
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);