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 |
---|---|---|---|---|---|---|---|
592733 | 592733 | 2020-10-03 | Blount | Alabama | 1009 | 1655 | 15 |
589493 | 589493 | 2020-10-02 | Blount | Alabama | 1009 | 1642 | 15 |
586252 | 586252 | 2020-10-01 | Blount | Alabama | 1009 | 1634 | 15 |
583012 | 583012 | 2020-09-30 | Blount | Alabama | 1009 | 1629 | 15 |
579773 | 579773 | 2020-09-29 | Blount | Alabama | 1009 | 1621 | 15 |
576532 | 576532 | 2020-09-28 | Blount | Alabama | 1009 | 1618 | 15 |
573288 | 573288 | 2020-09-27 | Blount | Alabama | 1009 | 1617 | 15 |
570046 | 570046 | 2020-09-26 | Blount | Alabama | 1009 | 1611 | 15 |
566805 | 566805 | 2020-09-25 | Blount | Alabama | 1009 | 1608 | 15 |
563564 | 563564 | 2020-09-24 | Blount | Alabama | 1009 | 1594 | 15 |
560325 | 560325 | 2020-09-23 | Blount | Alabama | 1009 | 1580 | 15 |
557089 | 557089 | 2020-09-22 | Blount | Alabama | 1009 | 1573 | 14 |
553852 | 553852 | 2020-09-21 | Blount | Alabama | 1009 | 1560 | 14 |
550613 | 550613 | 2020-09-20 | Blount | Alabama | 1009 | 1551 | 14 |
547374 | 547374 | 2020-09-19 | Blount | Alabama | 1009 | 1542 | 14 |
544137 | 544137 | 2020-09-18 | Blount | Alabama | 1009 | 1527 | 14 |
540901 | 540901 | 2020-09-17 | Blount | Alabama | 1009 | 1504 | 13 |
537664 | 537664 | 2020-09-16 | Blount | Alabama | 1009 | 1487 | 13 |
534428 | 534428 | 2020-09-15 | Blount | Alabama | 1009 | 1475 | 13 |
531193 | 531193 | 2020-09-14 | Blount | Alabama | 1009 | 1464 | 13 |
527956 | 527956 | 2020-09-13 | Blount | Alabama | 1009 | 1453 | 13 |
524720 | 524720 | 2020-09-12 | Blount | Alabama | 1009 | 1446 | 13 |
521484 | 521484 | 2020-09-11 | Blount | Alabama | 1009 | 1441 | 12 |
518247 | 518247 | 2020-09-10 | Blount | Alabama | 1009 | 1430 | 12 |
515012 | 515012 | 2020-09-09 | Blount | Alabama | 1009 | 1401 | 12 |
511779 | 511779 | 2020-09-08 | Blount | Alabama | 1009 | 1390 | 12 |
508546 | 508546 | 2020-09-07 | Blount | Alabama | 1009 | 1384 | 12 |
505314 | 505314 | 2020-09-06 | Blount | Alabama | 1009 | 1379 | 12 |
502080 | 502080 | 2020-09-05 | Blount | Alabama | 1009 | 1376 | 12 |
498846 | 498846 | 2020-09-04 | Blount | Alabama | 1009 | 1361 | 12 |
495613 | 495613 | 2020-09-03 | Blount | Alabama | 1009 | 1336 | 11 |
492379 | 492379 | 2020-09-02 | Blount | Alabama | 1009 | 1308 | 11 |
489146 | 489146 | 2020-09-01 | Blount | Alabama | 1009 | 1303 | 11 |
485913 | 485913 | 2020-08-31 | Blount | Alabama | 1009 | 1287 | 11 |
482678 | 482678 | 2020-08-30 | Blount | Alabama | 1009 | 1277 | 10 |
479444 | 479444 | 2020-08-29 | Blount | Alabama | 1009 | 1248 | 9 |
476211 | 476211 | 2020-08-28 | Blount | Alabama | 1009 | 1219 | 9 |
472978 | 472978 | 2020-08-27 | Blount | Alabama | 1009 | 1213 | 7 |
469746 | 469746 | 2020-08-26 | Blount | Alabama | 1009 | 1195 | 7 |
466517 | 466517 | 2020-08-25 | Blount | Alabama | 1009 | 1160 | 6 |
463288 | 463288 | 2020-08-24 | Blount | Alabama | 1009 | 1135 | 6 |
460059 | 460059 | 2020-08-23 | Blount | Alabama | 1009 | 1099 | 6 |
456832 | 456832 | 2020-08-22 | Blount | Alabama | 1009 | 1096 | 6 |
453604 | 453604 | 2020-08-21 | Blount | Alabama | 1009 | 1095 | 6 |
450376 | 450376 | 2020-08-20 | Blount | Alabama | 1009 | 1077 | 5 |
447148 | 447148 | 2020-08-19 | Blount | Alabama | 1009 | 1049 | 5 |
443921 | 443921 | 2020-08-18 | Blount | Alabama | 1009 | 1034 | 5 |
440695 | 440695 | 2020-08-17 | Blount | Alabama | 1009 | 1008 | 5 |
437469 | 437469 | 2020-08-16 | Blount | Alabama | 1009 | 1005 | 5 |
434243 | 434243 | 2020-08-15 | Blount | Alabama | 1009 | 996 | 5 |
431018 | 431018 | 2020-08-14 | Blount | Alabama | 1009 | 989 | 5 |
427790 | 427790 | 2020-08-13 | Blount | Alabama | 1009 | 977 | 5 |
424566 | 424566 | 2020-08-12 | Blount | Alabama | 1009 | 967 | 5 |
421345 | 421345 | 2020-08-11 | Blount | Alabama | 1009 | 958 | 5 |
418124 | 418124 | 2020-08-10 | Blount | Alabama | 1009 | 947 | 4 |
414903 | 414903 | 2020-08-09 | Blount | Alabama | 1009 | 934 | 4 |
411683 | 411683 | 2020-08-08 | Blount | Alabama | 1009 | 923 | 4 |
408464 | 408464 | 2020-08-07 | Blount | Alabama | 1009 | 909 | 3 |
405244 | 405244 | 2020-08-06 | Blount | Alabama | 1009 | 874 | 3 |
402026 | 402026 | 2020-08-05 | Blount | Alabama | 1009 | 839 | 3 |
398810 | 398810 | 2020-08-04 | Blount | Alabama | 1009 | 836 | 3 |
395594 | 395594 | 2020-08-03 | Blount | Alabama | 1009 | 830 | 3 |
392378 | 392378 | 2020-08-02 | Blount | Alabama | 1009 | 813 | 3 |
389161 | 389161 | 2020-08-01 | Blount | Alabama | 1009 | 792 | 3 |
385944 | 385944 | 2020-07-31 | Blount | Alabama | 1009 | 767 | 3 |
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 |
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);