ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1019 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382731 | 382731 | 2020-07-30 | Cherokee | Alabama | 1019 | 234 | 8 |
379514 | 379514 | 2020-07-29 | Cherokee | Alabama | 1019 | 227 | 8 |
376298 | 376298 | 2020-07-28 | Cherokee | Alabama | 1019 | 221 | 8 |
373084 | 373084 | 2020-07-27 | Cherokee | Alabama | 1019 | 220 | 8 |
369872 | 369872 | 2020-07-26 | Cherokee | Alabama | 1019 | 209 | 8 |
366662 | 366662 | 2020-07-25 | Cherokee | Alabama | 1019 | 207 | 8 |
363455 | 363455 | 2020-07-24 | Cherokee | Alabama | 1019 | 205 | 8 |
360249 | 360249 | 2020-07-23 | Cherokee | Alabama | 1019 | 193 | 7 |
357044 | 357044 | 2020-07-22 | Cherokee | Alabama | 1019 | 184 | 7 |
353841 | 353841 | 2020-07-21 | Cherokee | Alabama | 1019 | 182 | 7 |
350639 | 350639 | 2020-07-20 | Cherokee | Alabama | 1019 | 179 | 7 |
347438 | 347438 | 2020-07-19 | Cherokee | Alabama | 1019 | 173 | 7 |
344238 | 344238 | 2020-07-18 | Cherokee | Alabama | 1019 | 165 | 7 |
341039 | 341039 | 2020-07-17 | Cherokee | Alabama | 1019 | 157 | 7 |
337843 | 337843 | 2020-07-16 | Cherokee | Alabama | 1019 | 152 | 7 |
334648 | 334648 | 2020-07-15 | Cherokee | Alabama | 1019 | 145 | 7 |
331455 | 331455 | 2020-07-14 | Cherokee | Alabama | 1019 | 140 | 7 |
328269 | 328269 | 2020-07-13 | Cherokee | Alabama | 1019 | 136 | 7 |
325083 | 325083 | 2020-07-12 | Cherokee | Alabama | 1019 | 129 | 7 |
321902 | 321902 | 2020-07-11 | Cherokee | Alabama | 1019 | 128 | 7 |
318723 | 318723 | 2020-07-10 | Cherokee | Alabama | 1019 | 118 | 7 |
315550 | 315550 | 2020-07-09 | Cherokee | Alabama | 1019 | 115 | 7 |
312375 | 312375 | 2020-07-08 | Cherokee | Alabama | 1019 | 114 | 7 |
309206 | 309206 | 2020-07-07 | Cherokee | Alabama | 1019 | 106 | 7 |
306037 | 306037 | 2020-07-06 | Cherokee | Alabama | 1019 | 105 | 7 |
302873 | 302873 | 2020-07-05 | Cherokee | Alabama | 1019 | 100 | 7 |
299709 | 299709 | 2020-07-04 | Cherokee | Alabama | 1019 | 88 | 7 |
296547 | 296547 | 2020-07-03 | Cherokee | Alabama | 1019 | 88 | 7 |
293392 | 293392 | 2020-07-02 | Cherokee | Alabama | 1019 | 82 | 7 |
290239 | 290239 | 2020-07-01 | Cherokee | Alabama | 1019 | 77 | 7 |
287089 | 287089 | 2020-06-30 | Cherokee | Alabama | 1019 | 74 | 7 |
283943 | 283943 | 2020-06-29 | Cherokee | Alabama | 1019 | 73 | 7 |
280797 | 280797 | 2020-06-28 | Cherokee | Alabama | 1019 | 70 | 7 |
277649 | 277649 | 2020-06-27 | Cherokee | Alabama | 1019 | 69 | 7 |
274501 | 274501 | 2020-06-26 | Cherokee | Alabama | 1019 | 68 | 7 |
271361 | 271361 | 2020-06-25 | Cherokee | Alabama | 1019 | 64 | 7 |
268227 | 268227 | 2020-06-24 | Cherokee | Alabama | 1019 | 58 | 7 |
265098 | 265098 | 2020-06-23 | Cherokee | Alabama | 1019 | 58 | 7 |
261969 | 261969 | 2020-06-22 | Cherokee | Alabama | 1019 | 58 | 6 |
258842 | 258842 | 2020-06-21 | Cherokee | Alabama | 1019 | 58 | 6 |
255715 | 255715 | 2020-06-20 | Cherokee | Alabama | 1019 | 58 | 6 |
252596 | 252596 | 2020-06-19 | Cherokee | Alabama | 1019 | 58 | 6 |
249481 | 249481 | 2020-06-18 | Cherokee | Alabama | 1019 | 55 | 5 |
246369 | 246369 | 2020-06-17 | Cherokee | Alabama | 1019 | 53 | 5 |
243256 | 243256 | 2020-06-16 | Cherokee | Alabama | 1019 | 53 | 5 |
240145 | 240145 | 2020-06-15 | Cherokee | Alabama | 1019 | 53 | 5 |
237037 | 237037 | 2020-06-14 | Cherokee | Alabama | 1019 | 53 | 5 |
233930 | 233930 | 2020-06-13 | Cherokee | Alabama | 1019 | 49 | 5 |
230825 | 230825 | 2020-06-12 | Cherokee | Alabama | 1019 | 48 | 5 |
227721 | 227721 | 2020-06-11 | Cherokee | Alabama | 1019 | 44 | 4 |
224620 | 224620 | 2020-06-10 | Cherokee | Alabama | 1019 | 44 | 4 |
221524 | 221524 | 2020-06-09 | Cherokee | Alabama | 1019 | 43 | 4 |
218432 | 218432 | 2020-06-08 | Cherokee | Alabama | 1019 | 43 | 4 |
215342 | 215342 | 2020-06-07 | Cherokee | Alabama | 1019 | 43 | 4 |
212255 | 212255 | 2020-06-06 | Cherokee | Alabama | 1019 | 41 | 4 |
209170 | 209170 | 2020-06-05 | Cherokee | Alabama | 1019 | 39 | 3 |
206088 | 206088 | 2020-06-04 | Cherokee | Alabama | 1019 | 39 | 3 |
203009 | 203009 | 2020-06-03 | Cherokee | Alabama | 1019 | 39 | 3 |
199933 | 199933 | 2020-06-02 | Cherokee | Alabama | 1019 | 39 | 3 |
196860 | 196860 | 2020-06-01 | Cherokee | Alabama | 1019 | 39 | 3 |
193790 | 193790 | 2020-05-31 | Cherokee | Alabama | 1019 | 37 | 3 |
190724 | 190724 | 2020-05-30 | Cherokee | Alabama | 1019 | 37 | 3 |
187660 | 187660 | 2020-05-29 | Cherokee | Alabama | 1019 | 36 | 3 |
184603 | 184603 | 2020-05-28 | Cherokee | Alabama | 1019 | 34 | 2 |
181551 | 181551 | 2020-05-27 | Cherokee | Alabama | 1019 | 33 | 2 |
178507 | 178507 | 2020-05-26 | Cherokee | Alabama | 1019 | 33 | 2 |
175462 | 175462 | 2020-05-25 | Cherokee | Alabama | 1019 | 33 | 2 |
172419 | 172419 | 2020-05-24 | Cherokee | Alabama | 1019 | 33 | 2 |
169378 | 169378 | 2020-05-23 | Cherokee | Alabama | 1019 | 33 | 2 |
166342 | 166342 | 2020-05-22 | Cherokee | Alabama | 1019 | 33 | 2 |
163310 | 163310 | 2020-05-21 | Cherokee | Alabama | 1019 | 31 | 0 |
160282 | 160282 | 2020-05-20 | Cherokee | Alabama | 1019 | 30 | 0 |
157258 | 157258 | 2020-05-19 | Cherokee | Alabama | 1019 | 29 | 0 |
154242 | 154242 | 2020-05-18 | Cherokee | Alabama | 1019 | 28 | 0 |
151230 | 151230 | 2020-05-17 | Cherokee | Alabama | 1019 | 27 | 0 |
148221 | 148221 | 2020-05-16 | Cherokee | Alabama | 1019 | 27 | 0 |
145218 | 145218 | 2020-05-15 | Cherokee | Alabama | 1019 | 26 | 0 |
142219 | 142219 | 2020-05-14 | Cherokee | Alabama | 1019 | 25 | 0 |
139223 | 139223 | 2020-05-13 | Cherokee | Alabama | 1019 | 24 | 0 |
136232 | 136232 | 2020-05-12 | Cherokee | Alabama | 1019 | 24 | 0 |
133242 | 133242 | 2020-05-11 | Cherokee | Alabama | 1019 | 24 | 0 |
130252 | 130252 | 2020-05-10 | Cherokee | Alabama | 1019 | 22 | 0 |
127262 | 127262 | 2020-05-09 | Cherokee | Alabama | 1019 | 22 | 0 |
124277 | 124277 | 2020-05-08 | Cherokee | Alabama | 1019 | 21 | 0 |
121297 | 121297 | 2020-05-07 | Cherokee | Alabama | 1019 | 18 | 0 |
118331 | 118331 | 2020-05-06 | Cherokee | Alabama | 1019 | 18 | 0 |
115372 | 115372 | 2020-05-05 | Cherokee | Alabama | 1019 | 17 | 0 |
112489 | 112489 | 2020-05-04 | Cherokee | Alabama | 1019 | 16 | 0 |
109614 | 109614 | 2020-05-03 | Cherokee | Alabama | 1019 | 16 | 0 |
106745 | 106745 | 2020-05-02 | Cherokee | Alabama | 1019 | 15 | 0 |
103880 | 103880 | 2020-05-01 | Cherokee | Alabama | 1019 | 15 | 0 |
101025 | 101025 | 2020-04-30 | Cherokee | Alabama | 1019 | 15 | 0 |
98175 | 98175 | 2020-04-29 | Cherokee | Alabama | 1019 | 15 | 0 |
95330 | 95330 | 2020-04-28 | Cherokee | Alabama | 1019 | 15 | 0 |
92500 | 92500 | 2020-04-27 | Cherokee | Alabama | 1019 | 14 | 0 |
89682 | 89682 | 2020-04-26 | Cherokee | Alabama | 1019 | 14 | 0 |
86866 | 86866 | 2020-04-25 | Cherokee | Alabama | 1019 | 12 | 0 |
84058 | 84058 | 2020-04-24 | Cherokee | Alabama | 1019 | 12 | 0 |
81257 | 81257 | 2020-04-23 | Cherokee | Alabama | 1019 | 12 | 0 |
78464 | 78464 | 2020-04-22 | Cherokee | Alabama | 1019 | 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);