ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 1017 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382730 | 382730 | 2020-07-30 | Chambers | Alabama | 1017 | 848 | 38 |
379513 | 379513 | 2020-07-29 | Chambers | Alabama | 1017 | 844 | 38 |
376297 | 376297 | 2020-07-28 | Chambers | Alabama | 1017 | 836 | 38 |
373083 | 373083 | 2020-07-27 | Chambers | Alabama | 1017 | 825 | 38 |
369871 | 369871 | 2020-07-26 | Chambers | Alabama | 1017 | 821 | 37 |
366661 | 366661 | 2020-07-25 | Chambers | Alabama | 1017 | 810 | 37 |
363454 | 363454 | 2020-07-24 | Chambers | Alabama | 1017 | 797 | 37 |
360248 | 360248 | 2020-07-23 | Chambers | Alabama | 1017 | 789 | 34 |
357043 | 357043 | 2020-07-22 | Chambers | Alabama | 1017 | 782 | 34 |
353840 | 353840 | 2020-07-21 | Chambers | Alabama | 1017 | 774 | 33 |
350638 | 350638 | 2020-07-20 | Chambers | Alabama | 1017 | 767 | 33 |
347437 | 347437 | 2020-07-19 | Chambers | Alabama | 1017 | 762 | 33 |
344237 | 344237 | 2020-07-18 | Chambers | Alabama | 1017 | 756 | 33 |
341038 | 341038 | 2020-07-17 | Chambers | Alabama | 1017 | 742 | 32 |
337842 | 337842 | 2020-07-16 | Chambers | Alabama | 1017 | 731 | 32 |
334647 | 334647 | 2020-07-15 | Chambers | Alabama | 1017 | 718 | 32 |
331454 | 331454 | 2020-07-14 | Chambers | Alabama | 1017 | 712 | 32 |
328268 | 328268 | 2020-07-13 | Chambers | Alabama | 1017 | 702 | 30 |
325082 | 325082 | 2020-07-12 | Chambers | Alabama | 1017 | 693 | 30 |
321901 | 321901 | 2020-07-11 | Chambers | Alabama | 1017 | 690 | 27 |
318722 | 318722 | 2020-07-10 | Chambers | Alabama | 1017 | 679 | 27 |
315549 | 315549 | 2020-07-09 | Chambers | Alabama | 1017 | 672 | 27 |
312374 | 312374 | 2020-07-08 | Chambers | Alabama | 1017 | 660 | 27 |
309205 | 309205 | 2020-07-07 | Chambers | Alabama | 1017 | 656 | 27 |
306036 | 306036 | 2020-07-06 | Chambers | Alabama | 1017 | 655 | 27 |
302872 | 302872 | 2020-07-05 | Chambers | Alabama | 1017 | 642 | 27 |
299708 | 299708 | 2020-07-04 | Chambers | Alabama | 1017 | 637 | 27 |
296546 | 296546 | 2020-07-03 | Chambers | Alabama | 1017 | 625 | 27 |
293391 | 293391 | 2020-07-02 | Chambers | Alabama | 1017 | 611 | 27 |
290238 | 290238 | 2020-07-01 | Chambers | Alabama | 1017 | 595 | 27 |
287088 | 287088 | 2020-06-30 | Chambers | Alabama | 1017 | 590 | 27 |
283942 | 283942 | 2020-06-29 | Chambers | Alabama | 1017 | 585 | 27 |
280796 | 280796 | 2020-06-28 | Chambers | Alabama | 1017 | 561 | 27 |
277648 | 277648 | 2020-06-27 | Chambers | Alabama | 1017 | 561 | 27 |
274500 | 274500 | 2020-06-26 | Chambers | Alabama | 1017 | 559 | 27 |
271360 | 271360 | 2020-06-25 | Chambers | Alabama | 1017 | 549 | 27 |
268226 | 268226 | 2020-06-24 | Chambers | Alabama | 1017 | 543 | 27 |
265097 | 265097 | 2020-06-23 | Chambers | Alabama | 1017 | 534 | 27 |
261968 | 261968 | 2020-06-22 | Chambers | Alabama | 1017 | 528 | 27 |
258841 | 258841 | 2020-06-21 | Chambers | Alabama | 1017 | 521 | 27 |
255714 | 255714 | 2020-06-20 | Chambers | Alabama | 1017 | 516 | 27 |
252595 | 252595 | 2020-06-19 | Chambers | Alabama | 1017 | 507 | 28 |
249480 | 249480 | 2020-06-18 | Chambers | Alabama | 1017 | 501 | 26 |
246368 | 246368 | 2020-06-17 | Chambers | Alabama | 1017 | 486 | 26 |
243255 | 243255 | 2020-06-16 | Chambers | Alabama | 1017 | 485 | 26 |
240144 | 240144 | 2020-06-15 | Chambers | Alabama | 1017 | 475 | 26 |
237036 | 237036 | 2020-06-14 | Chambers | Alabama | 1017 | 467 | 26 |
233929 | 233929 | 2020-06-13 | Chambers | Alabama | 1017 | 452 | 26 |
230824 | 230824 | 2020-06-12 | Chambers | Alabama | 1017 | 441 | 26 |
227720 | 227720 | 2020-06-11 | Chambers | Alabama | 1017 | 431 | 26 |
224619 | 224619 | 2020-06-10 | Chambers | Alabama | 1017 | 415 | 26 |
221523 | 221523 | 2020-06-09 | Chambers | Alabama | 1017 | 404 | 26 |
218431 | 218431 | 2020-06-08 | Chambers | Alabama | 1017 | 395 | 26 |
215341 | 215341 | 2020-06-07 | Chambers | Alabama | 1017 | 390 | 26 |
212254 | 212254 | 2020-06-06 | Chambers | Alabama | 1017 | 385 | 26 |
209169 | 209169 | 2020-06-05 | Chambers | Alabama | 1017 | 375 | 26 |
206087 | 206087 | 2020-06-04 | Chambers | Alabama | 1017 | 372 | 26 |
203008 | 203008 | 2020-06-03 | Chambers | Alabama | 1017 | 371 | 26 |
199932 | 199932 | 2020-06-02 | Chambers | Alabama | 1017 | 370 | 26 |
196859 | 196859 | 2020-06-01 | Chambers | Alabama | 1017 | 370 | 25 |
193789 | 193789 | 2020-05-31 | Chambers | Alabama | 1017 | 355 | 25 |
190723 | 190723 | 2020-05-30 | Chambers | Alabama | 1017 | 353 | 25 |
187659 | 187659 | 2020-05-29 | Chambers | Alabama | 1017 | 352 | 24 |
184602 | 184602 | 2020-05-28 | Chambers | Alabama | 1017 | 349 | 24 |
181550 | 181550 | 2020-05-27 | Chambers | Alabama | 1017 | 340 | 24 |
178506 | 178506 | 2020-05-26 | Chambers | Alabama | 1017 | 338 | 24 |
175461 | 175461 | 2020-05-25 | Chambers | Alabama | 1017 | 337 | 24 |
172418 | 172418 | 2020-05-24 | Chambers | Alabama | 1017 | 336 | 23 |
169377 | 169377 | 2020-05-23 | Chambers | Alabama | 1017 | 330 | 23 |
166341 | 166341 | 2020-05-22 | Chambers | Alabama | 1017 | 330 | 23 |
163309 | 163309 | 2020-05-21 | Chambers | Alabama | 1017 | 330 | 23 |
160281 | 160281 | 2020-05-20 | Chambers | Alabama | 1017 | 331 | 23 |
157257 | 157257 | 2020-05-19 | Chambers | Alabama | 1017 | 329 | 22 |
154241 | 154241 | 2020-05-18 | Chambers | Alabama | 1017 | 329 | 22 |
151229 | 151229 | 2020-05-17 | Chambers | Alabama | 1017 | 328 | 22 |
148220 | 148220 | 2020-05-16 | Chambers | Alabama | 1017 | 328 | 22 |
145217 | 145217 | 2020-05-15 | Chambers | Alabama | 1017 | 326 | 22 |
142218 | 142218 | 2020-05-14 | Chambers | Alabama | 1017 | 326 | 22 |
139222 | 139222 | 2020-05-13 | Chambers | Alabama | 1017 | 324 | 22 |
136231 | 136231 | 2020-05-12 | Chambers | Alabama | 1017 | 324 | 21 |
133241 | 133241 | 2020-05-11 | Chambers | Alabama | 1017 | 319 | 21 |
130251 | 130251 | 2020-05-10 | Chambers | Alabama | 1017 | 316 | 21 |
127261 | 127261 | 2020-05-09 | Chambers | Alabama | 1017 | 314 | 21 |
124276 | 124276 | 2020-05-08 | Chambers | Alabama | 1017 | 311 | 21 |
121296 | 121296 | 2020-05-07 | Chambers | Alabama | 1017 | 308 | 21 |
118330 | 118330 | 2020-05-06 | Chambers | Alabama | 1017 | 306 | 22 |
115371 | 115371 | 2020-05-05 | Chambers | Alabama | 1017 | 304 | 21 |
112488 | 112488 | 2020-05-04 | Chambers | Alabama | 1017 | 302 | 21 |
109613 | 109613 | 2020-05-03 | Chambers | Alabama | 1017 | 300 | 21 |
106744 | 106744 | 2020-05-02 | Chambers | Alabama | 1017 | 294 | 21 |
103879 | 103879 | 2020-05-01 | Chambers | Alabama | 1017 | 290 | 21 |
101024 | 101024 | 2020-04-30 | Chambers | Alabama | 1017 | 291 | 21 |
98174 | 98174 | 2020-04-29 | Chambers | Alabama | 1017 | 293 | 21 |
95329 | 95329 | 2020-04-28 | Chambers | Alabama | 1017 | 291 | 19 |
92499 | 92499 | 2020-04-27 | Chambers | Alabama | 1017 | 289 | 18 |
89681 | 89681 | 2020-04-26 | Chambers | Alabama | 1017 | 285 | 18 |
86865 | 86865 | 2020-04-25 | Chambers | Alabama | 1017 | 284 | 18 |
84057 | 84057 | 2020-04-24 | Chambers | Alabama | 1017 | 282 | 17 |
81256 | 81256 | 2020-04-23 | Chambers | Alabama | 1017 | 275 | 16 |
78463 | 78463 | 2020-04-22 | Chambers | Alabama | 1017 | 270 | 16 |
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);