ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where cases = 13 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 |
---|---|---|---|---|---|---|---|
187679 | 187679 | 2020-05-29 | Fayette | Alabama | 1057 | 13 | 0 |
184608 | 184608 | 2020-05-28 | Cleburne | Alabama | 1029 | 13 | 1 |
184622 | 184622 | 2020-05-28 | Fayette | Alabama | 1057 | 13 | 0 |
181556 | 181556 | 2020-05-27 | Cleburne | Alabama | 1029 | 13 | 1 |
181570 | 181570 | 2020-05-27 | Fayette | Alabama | 1057 | 13 | 0 |
178512 | 178512 | 2020-05-26 | Cleburne | Alabama | 1029 | 13 | 1 |
178526 | 178526 | 2020-05-26 | Fayette | Alabama | 1057 | 13 | 0 |
175467 | 175467 | 2020-05-25 | Cleburne | Alabama | 1029 | 13 | 1 |
172424 | 172424 | 2020-05-24 | Cleburne | Alabama | 1029 | 13 | 1 |
169383 | 169383 | 2020-05-23 | Cleburne | Alabama | 1029 | 13 | 1 |
166347 | 166347 | 2020-05-22 | Cleburne | Alabama | 1029 | 13 | 1 |
163315 | 163315 | 2020-05-21 | Cleburne | Alabama | 1029 | 13 | 1 |
160287 | 160287 | 2020-05-20 | Cleburne | Alabama | 1029 | 13 | 1 |
157263 | 157263 | 2020-05-19 | Cleburne | Alabama | 1029 | 13 | 1 |
154247 | 154247 | 2020-05-18 | Cleburne | Alabama | 1029 | 13 | 1 |
151235 | 151235 | 2020-05-17 | Cleburne | Alabama | 1029 | 13 | 1 |
148226 | 148226 | 2020-05-16 | Cleburne | Alabama | 1029 | 13 | 1 |
145223 | 145223 | 2020-05-15 | Cleburne | Alabama | 1029 | 13 | 1 |
142224 | 142224 | 2020-05-14 | Cleburne | Alabama | 1029 | 13 | 1 |
139228 | 139228 | 2020-05-13 | Cleburne | Alabama | 1029 | 13 | 1 |
136237 | 136237 | 2020-05-12 | Cleburne | Alabama | 1029 | 13 | 1 |
136260 | 136260 | 2020-05-12 | Lamar | Alabama | 1075 | 13 | 0 |
133247 | 133247 | 2020-05-11 | Cleburne | Alabama | 1029 | 13 | 1 |
133270 | 133270 | 2020-05-11 | Lamar | Alabama | 1075 | 13 | 0 |
130257 | 130257 | 2020-05-10 | Cleburne | Alabama | 1029 | 13 | 1 |
130260 | 130260 | 2020-05-10 | Conecuh | Alabama | 1035 | 13 | 0 |
130273 | 130273 | 2020-05-10 | Geneva | Alabama | 1061 | 13 | 0 |
130280 | 130280 | 2020-05-10 | Lamar | Alabama | 1075 | 13 | 0 |
127267 | 127267 | 2020-05-09 | Cleburne | Alabama | 1029 | 13 | 1 |
127270 | 127270 | 2020-05-09 | Conecuh | Alabama | 1035 | 13 | 0 |
127283 | 127283 | 2020-05-09 | Geneva | Alabama | 1061 | 13 | 0 |
127290 | 127290 | 2020-05-09 | Lamar | Alabama | 1075 | 13 | 0 |
124282 | 124282 | 2020-05-08 | Cleburne | Alabama | 1029 | 13 | 1 |
124305 | 124305 | 2020-05-08 | Lamar | Alabama | 1075 | 13 | 0 |
121302 | 121302 | 2020-05-07 | Cleburne | Alabama | 1029 | 13 | 1 |
121325 | 121325 | 2020-05-07 | Lamar | Alabama | 1075 | 13 | 0 |
118336 | 118336 | 2020-05-06 | Cleburne | Alabama | 1029 | 13 | 1 |
118359 | 118359 | 2020-05-06 | Lamar | Alabama | 1075 | 13 | 0 |
115377 | 115377 | 2020-05-05 | Cleburne | Alabama | 1029 | 13 | 1 |
115400 | 115400 | 2020-05-05 | Lamar | Alabama | 1075 | 13 | 0 |
115412 | 115412 | 2020-05-05 | Monroe | Alabama | 1099 | 13 | 1 |
112529 | 112529 | 2020-05-04 | Monroe | Alabama | 1099 | 13 | 1 |
109654 | 109654 | 2020-05-03 | Monroe | Alabama | 1099 | 13 | 1 |
106775 | 106775 | 2020-05-02 | Lawrence | Alabama | 1079 | 13 | 0 |
106785 | 106785 | 2020-05-02 | Monroe | Alabama | 1099 | 13 | 1 |
103910 | 103910 | 2020-05-01 | Lawrence | Alabama | 1079 | 13 | 0 |
103920 | 103920 | 2020-05-01 | Monroe | Alabama | 1099 | 13 | 1 |
101021 | 101021 | 2020-04-30 | Bullock | Alabama | 1011 | 13 | 0 |
101065 | 101065 | 2020-04-30 | Monroe | Alabama | 1099 | 13 | 1 |
98232 | 98232 | 2020-04-29 | Winston | Alabama | 1133 | 13 | 0 |
95387 | 95387 | 2020-04-28 | Winston | Alabama | 1133 | 13 | 0 |
78464 | 78464 | 2020-04-22 | Cherokee | Alabama | 1019 | 13 | 0 |
75681 | 75681 | 2020-04-21 | Cherokee | Alabama | 1019 | 13 | 0 |
67371 | 67371 | 2020-04-18 | Butler | Alabama | 1013 | 13 | 0 |
64628 | 64628 | 2020-04-17 | Choctaw | Alabama | 1023 | 13 | 0 |
64633 | 64633 | 2020-04-17 | Colbert | Alabama | 1033 | 13 | 1 |
61895 | 61895 | 2020-04-16 | Choctaw | Alabama | 1023 | 13 | 0 |
61900 | 61900 | 2020-04-16 | Colbert | Alabama | 1033 | 13 | 1 |
61948 | 61948 | 2020-04-16 | Washington | Alabama | 1129 | 13 | 1 |
59168 | 59168 | 2020-04-15 | Barbour | Alabama | 1005 | 13 | 0 |
59177 | 59177 | 2020-04-15 | Choctaw | Alabama | 1023 | 13 | 0 |
59188 | 59188 | 2020-04-15 | Dale | Alabama | 1045 | 13 | 0 |
53785 | 53785 | 2020-04-13 | Covington | Alabama | 1039 | 13 | 0 |
53799 | 53799 | 2020-04-13 | Henry | Alabama | 1067 | 13 | 0 |
51092 | 51092 | 2020-04-12 | Blount | Alabama | 1009 | 13 | 0 |
51107 | 51107 | 2020-04-12 | Covington | Alabama | 1039 | 13 | 0 |
48430 | 48430 | 2020-04-11 | Bibb | Alabama | 1007 | 13 | 0 |
45810 | 45810 | 2020-04-10 | Clarke | Alabama | 1025 | 13 | 0 |
45828 | 45828 | 2020-04-10 | Greene | Alabama | 1063 | 13 | 0 |
43212 | 43212 | 2020-04-09 | Clarke | Alabama | 1025 | 13 | 0 |
43230 | 43230 | 2020-04-09 | Greene | Alabama | 1063 | 13 | 0 |
40690 | 40690 | 2020-04-08 | Wilcox | Alabama | 1131 | 13 | 0 |
38138 | 38138 | 2020-04-07 | Randolph | Alabama | 1111 | 13 | 2 |
38148 | 38148 | 2020-04-07 | Wilcox | Alabama | 1131 | 13 | 0 |
35641 | 35641 | 2020-04-06 | Marengo | Alabama | 1091 | 13 | 0 |
35648 | 35648 | 2020-04-06 | Pickens | Alabama | 1107 | 13 | 0 |
35660 | 35660 | 2020-04-06 | Wilcox | Alabama | 1131 | 13 | 0 |
33202 | 33202 | 2020-04-05 | Marengo | Alabama | 1091 | 13 | 0 |
30778 | 30778 | 2020-04-04 | DeKalb | Alabama | 1049 | 13 | 0 |
30788 | 30788 | 2020-04-04 | Jackson | Alabama | 1071 | 13 | 1 |
26128 | 26128 | 2020-04-02 | Etowah | Alabama | 1055 | 13 | 1 |
23890 | 23890 | 2020-04-01 | Chilton | Alabama | 1021 | 13 | 0 |
21781 | 21781 | 2020-03-31 | Tallapoosa | Alabama | 1123 | 13 | 1 |
19676 | 19676 | 2020-03-30 | Elmore | Alabama | 1051 | 13 | 0 |
17706 | 17706 | 2020-03-29 | Elmore | Alabama | 1051 | 13 | 0 |
17734 | 17734 | 2020-03-29 | St. Clair | Alabama | 1115 | 13 | 0 |
15823 | 15823 | 2020-03-28 | Elmore | Alabama | 1051 | 13 | 0 |
15832 | 15832 | 2020-03-28 | Lauderdale | Alabama | 1077 | 13 | 1 |
14065 | 14065 | 2020-03-27 | Morgan | Alabama | 1103 | 13 | 0 |
12374 | 12374 | 2020-03-26 | Chambers | Alabama | 1017 | 13 | 0 |
12396 | 12396 | 2020-03-26 | Limestone | Alabama | 1083 | 13 | 0 |
10864 | 10864 | 2020-03-25 | Montgomery | Alabama | 1101 | 13 | 0 |
2312 | 2312 | 2020-03-15 | Jefferson | Alabama | 1073 | 13 | 0 |
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);