ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1009 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382726 | 382726 | 2020-07-30 | Blount | Alabama | 1009 | 731 | 3 |
379509 | 379509 | 2020-07-29 | Blount | Alabama | 1009 | 694 | 3 |
376293 | 376293 | 2020-07-28 | Blount | Alabama | 1009 | 675 | 1 |
373079 | 373079 | 2020-07-27 | Blount | Alabama | 1009 | 669 | 1 |
369867 | 369867 | 2020-07-26 | Blount | Alabama | 1009 | 646 | 1 |
366657 | 366657 | 2020-07-25 | Blount | Alabama | 1009 | 637 | 1 |
363450 | 363450 | 2020-07-24 | Blount | Alabama | 1009 | 615 | 1 |
360244 | 360244 | 2020-07-23 | Blount | Alabama | 1009 | 585 | 1 |
357039 | 357039 | 2020-07-22 | Blount | Alabama | 1009 | 547 | 1 |
353836 | 353836 | 2020-07-21 | Blount | Alabama | 1009 | 524 | 1 |
350634 | 350634 | 2020-07-20 | Blount | Alabama | 1009 | 507 | 1 |
347433 | 347433 | 2020-07-19 | Blount | Alabama | 1009 | 482 | 1 |
344233 | 344233 | 2020-07-18 | Blount | Alabama | 1009 | 458 | 1 |
341034 | 341034 | 2020-07-17 | Blount | Alabama | 1009 | 440 | 1 |
337838 | 337838 | 2020-07-16 | Blount | Alabama | 1009 | 424 | 1 |
334643 | 334643 | 2020-07-15 | Blount | Alabama | 1009 | 389 | 1 |
331450 | 331450 | 2020-07-14 | Blount | Alabama | 1009 | 366 | 1 |
328264 | 328264 | 2020-07-13 | Blount | Alabama | 1009 | 350 | 1 |
325078 | 325078 | 2020-07-12 | Blount | Alabama | 1009 | 331 | 1 |
321897 | 321897 | 2020-07-11 | Blount | Alabama | 1009 | 307 | 1 |
318718 | 318718 | 2020-07-10 | Blount | Alabama | 1009 | 292 | 1 |
315545 | 315545 | 2020-07-09 | Blount | Alabama | 1009 | 282 | 1 |
312370 | 312370 | 2020-07-08 | Blount | Alabama | 1009 | 262 | 1 |
309201 | 309201 | 2020-07-07 | Blount | Alabama | 1009 | 255 | 1 |
306032 | 306032 | 2020-07-06 | Blount | Alabama | 1009 | 247 | 1 |
302868 | 302868 | 2020-07-05 | Blount | Alabama | 1009 | 239 | 1 |
299704 | 299704 | 2020-07-04 | Blount | Alabama | 1009 | 234 | 1 |
296542 | 296542 | 2020-07-03 | Blount | Alabama | 1009 | 230 | 1 |
293387 | 293387 | 2020-07-02 | Blount | Alabama | 1009 | 222 | 1 |
290234 | 290234 | 2020-07-01 | Blount | Alabama | 1009 | 218 | 1 |
287084 | 287084 | 2020-06-30 | Blount | Alabama | 1009 | 208 | 1 |
283938 | 283938 | 2020-06-29 | Blount | Alabama | 1009 | 199 | 1 |
280792 | 280792 | 2020-06-28 | Blount | Alabama | 1009 | 189 | 1 |
277644 | 277644 | 2020-06-27 | Blount | Alabama | 1009 | 188 | 1 |
274496 | 274496 | 2020-06-26 | Blount | Alabama | 1009 | 184 | 1 |
271356 | 271356 | 2020-06-25 | Blount | Alabama | 1009 | 176 | 1 |
268222 | 268222 | 2020-06-24 | Blount | Alabama | 1009 | 168 | 1 |
265093 | 265093 | 2020-06-23 | Blount | Alabama | 1009 | 159 | 1 |
261964 | 261964 | 2020-06-22 | Blount | Alabama | 1009 | 153 | 1 |
258837 | 258837 | 2020-06-21 | Blount | Alabama | 1009 | 149 | 1 |
255710 | 255710 | 2020-06-20 | Blount | Alabama | 1009 | 143 | 1 |
252591 | 252591 | 2020-06-19 | Blount | Alabama | 1009 | 139 | 1 |
249476 | 249476 | 2020-06-18 | Blount | Alabama | 1009 | 130 | 1 |
246364 | 246364 | 2020-06-17 | Blount | Alabama | 1009 | 123 | 1 |
243251 | 243251 | 2020-06-16 | Blount | Alabama | 1009 | 121 | 1 |
240140 | 240140 | 2020-06-15 | Blount | Alabama | 1009 | 116 | 1 |
237032 | 237032 | 2020-06-14 | Blount | Alabama | 1009 | 112 | 1 |
233925 | 233925 | 2020-06-13 | Blount | Alabama | 1009 | 104 | 1 |
230820 | 230820 | 2020-06-12 | Blount | Alabama | 1009 | 97 | 1 |
227716 | 227716 | 2020-06-11 | Blount | Alabama | 1009 | 89 | 1 |
224615 | 224615 | 2020-06-10 | Blount | Alabama | 1009 | 81 | 1 |
221519 | 221519 | 2020-06-09 | Blount | Alabama | 1009 | 77 | 1 |
218427 | 218427 | 2020-06-08 | Blount | Alabama | 1009 | 75 | 1 |
215337 | 215337 | 2020-06-07 | Blount | Alabama | 1009 | 74 | 1 |
212250 | 212250 | 2020-06-06 | Blount | Alabama | 1009 | 72 | 1 |
209165 | 209165 | 2020-06-05 | Blount | Alabama | 1009 | 66 | 1 |
206083 | 206083 | 2020-06-04 | Blount | Alabama | 1009 | 65 | 1 |
203004 | 203004 | 2020-06-03 | Blount | Alabama | 1009 | 65 | 1 |
199928 | 199928 | 2020-06-02 | Blount | Alabama | 1009 | 65 | 1 |
196855 | 196855 | 2020-06-01 | Blount | Alabama | 1009 | 65 | 1 |
193785 | 193785 | 2020-05-31 | Blount | Alabama | 1009 | 62 | 1 |
190719 | 190719 | 2020-05-30 | Blount | Alabama | 1009 | 61 | 1 |
187655 | 187655 | 2020-05-29 | Blount | Alabama | 1009 | 60 | 1 |
184598 | 184598 | 2020-05-28 | Blount | Alabama | 1009 | 58 | 1 |
181546 | 181546 | 2020-05-27 | Blount | Alabama | 1009 | 53 | 1 |
178502 | 178502 | 2020-05-26 | Blount | Alabama | 1009 | 51 | 1 |
175457 | 175457 | 2020-05-25 | Blount | Alabama | 1009 | 49 | 1 |
172414 | 172414 | 2020-05-24 | Blount | Alabama | 1009 | 49 | 1 |
169373 | 169373 | 2020-05-23 | Blount | Alabama | 1009 | 49 | 1 |
166337 | 166337 | 2020-05-22 | Blount | Alabama | 1009 | 49 | 1 |
163305 | 163305 | 2020-05-21 | Blount | Alabama | 1009 | 48 | 1 |
160277 | 160277 | 2020-05-20 | Blount | Alabama | 1009 | 47 | 1 |
157253 | 157253 | 2020-05-19 | Blount | Alabama | 1009 | 47 | 1 |
154237 | 154237 | 2020-05-18 | Blount | Alabama | 1009 | 47 | 1 |
151225 | 151225 | 2020-05-17 | Blount | Alabama | 1009 | 46 | 1 |
148216 | 148216 | 2020-05-16 | Blount | Alabama | 1009 | 45 | 0 |
145213 | 145213 | 2020-05-15 | Blount | Alabama | 1009 | 45 | 0 |
142214 | 142214 | 2020-05-14 | Blount | Alabama | 1009 | 45 | 0 |
139218 | 139218 | 2020-05-13 | Blount | Alabama | 1009 | 45 | 0 |
136227 | 136227 | 2020-05-12 | Blount | Alabama | 1009 | 45 | 0 |
133237 | 133237 | 2020-05-11 | Blount | Alabama | 1009 | 45 | 0 |
130247 | 130247 | 2020-05-10 | Blount | Alabama | 1009 | 44 | 0 |
127257 | 127257 | 2020-05-09 | Blount | Alabama | 1009 | 44 | 0 |
124272 | 124272 | 2020-05-08 | Blount | Alabama | 1009 | 44 | 0 |
121292 | 121292 | 2020-05-07 | Blount | Alabama | 1009 | 44 | 0 |
118326 | 118326 | 2020-05-06 | Blount | Alabama | 1009 | 42 | 0 |
115367 | 115367 | 2020-05-05 | Blount | Alabama | 1009 | 40 | 0 |
112484 | 112484 | 2020-05-04 | Blount | Alabama | 1009 | 40 | 0 |
109609 | 109609 | 2020-05-03 | Blount | Alabama | 1009 | 40 | 0 |
106740 | 106740 | 2020-05-02 | Blount | Alabama | 1009 | 40 | 0 |
103875 | 103875 | 2020-05-01 | Blount | Alabama | 1009 | 39 | 0 |
101020 | 101020 | 2020-04-30 | Blount | Alabama | 1009 | 37 | 0 |
98170 | 98170 | 2020-04-29 | Blount | Alabama | 1009 | 36 | 0 |
95325 | 95325 | 2020-04-28 | Blount | Alabama | 1009 | 34 | 0 |
92495 | 92495 | 2020-04-27 | Blount | Alabama | 1009 | 34 | 0 |
89677 | 89677 | 2020-04-26 | Blount | Alabama | 1009 | 34 | 0 |
86861 | 86861 | 2020-04-25 | Blount | Alabama | 1009 | 31 | 0 |
84053 | 84053 | 2020-04-24 | Blount | Alabama | 1009 | 31 | 0 |
81252 | 81252 | 2020-04-23 | Blount | Alabama | 1009 | 31 | 0 |
78459 | 78459 | 2020-04-22 | Blount | Alabama | 1009 | 29 | 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);