ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 1043 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
631661 | 631661 | 2020-10-15 | Cullman | Alabama | 1043 | 2168 | 23 |
628417 | 628417 | 2020-10-14 | Cullman | Alabama | 1043 | 2132 | 21 |
625174 | 625174 | 2020-10-13 | Cullman | Alabama | 1043 | 2110 | 21 |
621931 | 621931 | 2020-10-12 | Cullman | Alabama | 1043 | 2073 | 21 |
618688 | 618688 | 2020-10-11 | Cullman | Alabama | 1043 | 2047 | 21 |
615446 | 615446 | 2020-10-10 | Cullman | Alabama | 1043 | 2036 | 21 |
612205 | 612205 | 2020-10-09 | Cullman | Alabama | 1043 | 2025 | 21 |
608963 | 608963 | 2020-10-08 | Cullman | Alabama | 1043 | 2001 | 21 |
605720 | 605720 | 2020-10-07 | Cullman | Alabama | 1043 | 1997 | 21 |
602478 | 602478 | 2020-10-06 | Cullman | Alabama | 1043 | 1978 | 20 |
599235 | 599235 | 2020-10-05 | Cullman | Alabama | 1043 | 1971 | 20 |
595992 | 595992 | 2020-10-04 | Cullman | Alabama | 1043 | 1959 | 20 |
592750 | 592750 | 2020-10-03 | Cullman | Alabama | 1043 | 1946 | 20 |
589510 | 589510 | 2020-10-02 | Cullman | Alabama | 1043 | 1932 | 20 |
586269 | 586269 | 2020-10-01 | Cullman | Alabama | 1043 | 1923 | 20 |
583029 | 583029 | 2020-09-30 | Cullman | Alabama | 1043 | 1922 | 20 |
579790 | 579790 | 2020-09-29 | Cullman | Alabama | 1043 | 1919 | 20 |
576549 | 576549 | 2020-09-28 | Cullman | Alabama | 1043 | 1911 | 20 |
573305 | 573305 | 2020-09-27 | Cullman | Alabama | 1043 | 1907 | 20 |
570063 | 570063 | 2020-09-26 | Cullman | Alabama | 1043 | 1899 | 20 |
566822 | 566822 | 2020-09-25 | Cullman | Alabama | 1043 | 1890 | 20 |
563581 | 563581 | 2020-09-24 | Cullman | Alabama | 1043 | 1885 | 19 |
560342 | 560342 | 2020-09-23 | Cullman | Alabama | 1043 | 1868 | 18 |
557106 | 557106 | 2020-09-22 | Cullman | Alabama | 1043 | 1868 | 19 |
553869 | 553869 | 2020-09-21 | Cullman | Alabama | 1043 | 1862 | 18 |
550630 | 550630 | 2020-09-20 | Cullman | Alabama | 1043 | 1845 | 17 |
547391 | 547391 | 2020-09-19 | Cullman | Alabama | 1043 | 1830 | 17 |
544154 | 544154 | 2020-09-18 | Cullman | Alabama | 1043 | 1808 | 17 |
540918 | 540918 | 2020-09-17 | Cullman | Alabama | 1043 | 1800 | 17 |
537681 | 537681 | 2020-09-16 | Cullman | Alabama | 1043 | 1797 | 17 |
534445 | 534445 | 2020-09-15 | Cullman | Alabama | 1043 | 1785 | 17 |
531210 | 531210 | 2020-09-14 | Cullman | Alabama | 1043 | 1775 | 17 |
527973 | 527973 | 2020-09-13 | Cullman | Alabama | 1043 | 1768 | 17 |
524737 | 524737 | 2020-09-12 | Cullman | Alabama | 1043 | 1750 | 17 |
521501 | 521501 | 2020-09-11 | Cullman | Alabama | 1043 | 1742 | 17 |
518264 | 518264 | 2020-09-10 | Cullman | Alabama | 1043 | 1736 | 17 |
515029 | 515029 | 2020-09-09 | Cullman | Alabama | 1043 | 1732 | 17 |
511796 | 511796 | 2020-09-08 | Cullman | Alabama | 1043 | 1721 | 17 |
508563 | 508563 | 2020-09-07 | Cullman | Alabama | 1043 | 1716 | 17 |
505331 | 505331 | 2020-09-06 | Cullman | Alabama | 1043 | 1692 | 17 |
502097 | 502097 | 2020-09-05 | Cullman | Alabama | 1043 | 1689 | 17 |
498863 | 498863 | 2020-09-04 | Cullman | Alabama | 1043 | 1683 | 17 |
495630 | 495630 | 2020-09-03 | Cullman | Alabama | 1043 | 1680 | 16 |
492396 | 492396 | 2020-09-02 | Cullman | Alabama | 1043 | 1666 | 15 |
489163 | 489163 | 2020-09-01 | Cullman | Alabama | 1043 | 1664 | 15 |
485930 | 485930 | 2020-08-31 | Cullman | Alabama | 1043 | 1644 | 14 |
482695 | 482695 | 2020-08-30 | Cullman | Alabama | 1043 | 1627 | 14 |
479461 | 479461 | 2020-08-29 | Cullman | Alabama | 1043 | 1612 | 13 |
476228 | 476228 | 2020-08-28 | Cullman | Alabama | 1043 | 1583 | 12 |
472995 | 472995 | 2020-08-27 | Cullman | Alabama | 1043 | 1572 | 12 |
469763 | 469763 | 2020-08-26 | Cullman | Alabama | 1043 | 1567 | 12 |
466534 | 466534 | 2020-08-25 | Cullman | Alabama | 1043 | 1546 | 12 |
463305 | 463305 | 2020-08-24 | Cullman | Alabama | 1043 | 1543 | 12 |
460076 | 460076 | 2020-08-23 | Cullman | Alabama | 1043 | 1480 | 12 |
456849 | 456849 | 2020-08-22 | Cullman | Alabama | 1043 | 1476 | 12 |
453621 | 453621 | 2020-08-21 | Cullman | Alabama | 1043 | 1461 | 12 |
450393 | 450393 | 2020-08-20 | Cullman | Alabama | 1043 | 1441 | 11 |
447165 | 447165 | 2020-08-19 | Cullman | Alabama | 1043 | 1429 | 12 |
443938 | 443938 | 2020-08-18 | Cullman | Alabama | 1043 | 1415 | 12 |
440712 | 440712 | 2020-08-17 | Cullman | Alabama | 1043 | 1395 | 12 |
437486 | 437486 | 2020-08-16 | Cullman | Alabama | 1043 | 1382 | 12 |
434260 | 434260 | 2020-08-15 | Cullman | Alabama | 1043 | 1365 | 12 |
431035 | 431035 | 2020-08-14 | Cullman | Alabama | 1043 | 1347 | 12 |
427807 | 427807 | 2020-08-13 | Cullman | Alabama | 1043 | 1340 | 12 |
424583 | 424583 | 2020-08-12 | Cullman | Alabama | 1043 | 1331 | 12 |
421362 | 421362 | 2020-08-11 | Cullman | Alabama | 1043 | 1322 | 12 |
418141 | 418141 | 2020-08-10 | Cullman | Alabama | 1043 | 1312 | 12 |
414920 | 414920 | 2020-08-09 | Cullman | Alabama | 1043 | 1309 | 12 |
411700 | 411700 | 2020-08-08 | Cullman | Alabama | 1043 | 1302 | 12 |
408481 | 408481 | 2020-08-07 | Cullman | Alabama | 1043 | 1279 | 12 |
405261 | 405261 | 2020-08-06 | Cullman | Alabama | 1043 | 1263 | 12 |
402043 | 402043 | 2020-08-05 | Cullman | Alabama | 1043 | 1243 | 12 |
398827 | 398827 | 2020-08-04 | Cullman | Alabama | 1043 | 1225 | 11 |
395611 | 395611 | 2020-08-03 | Cullman | Alabama | 1043 | 1207 | 11 |
392395 | 392395 | 2020-08-02 | Cullman | Alabama | 1043 | 1178 | 11 |
389178 | 389178 | 2020-08-01 | Cullman | Alabama | 1043 | 1154 | 11 |
385961 | 385961 | 2020-07-31 | Cullman | Alabama | 1043 | 1131 | 11 |
382743 | 382743 | 2020-07-30 | Cullman | Alabama | 1043 | 1099 | 11 |
379526 | 379526 | 2020-07-29 | Cullman | Alabama | 1043 | 1066 | 10 |
376310 | 376310 | 2020-07-28 | Cullman | Alabama | 1043 | 1047 | 10 |
373096 | 373096 | 2020-07-27 | Cullman | Alabama | 1043 | 1015 | 9 |
369884 | 369884 | 2020-07-26 | Cullman | Alabama | 1043 | 976 | 9 |
366674 | 366674 | 2020-07-25 | Cullman | Alabama | 1043 | 962 | 8 |
363467 | 363467 | 2020-07-24 | Cullman | Alabama | 1043 | 937 | 8 |
360261 | 360261 | 2020-07-23 | Cullman | Alabama | 1043 | 910 | 7 |
357056 | 357056 | 2020-07-22 | Cullman | Alabama | 1043 | 879 | 7 |
353853 | 353853 | 2020-07-21 | Cullman | Alabama | 1043 | 856 | 7 |
350651 | 350651 | 2020-07-20 | Cullman | Alabama | 1043 | 841 | 7 |
347450 | 347450 | 2020-07-19 | Cullman | Alabama | 1043 | 822 | 7 |
344250 | 344250 | 2020-07-18 | Cullman | Alabama | 1043 | 785 | 7 |
341051 | 341051 | 2020-07-17 | Cullman | Alabama | 1043 | 772 | 7 |
337855 | 337855 | 2020-07-16 | Cullman | Alabama | 1043 | 740 | 6 |
334660 | 334660 | 2020-07-15 | Cullman | Alabama | 1043 | 723 | 6 |
331467 | 331467 | 2020-07-14 | Cullman | Alabama | 1043 | 699 | 6 |
328281 | 328281 | 2020-07-13 | Cullman | Alabama | 1043 | 678 | 6 |
325095 | 325095 | 2020-07-12 | Cullman | Alabama | 1043 | 625 | 6 |
321914 | 321914 | 2020-07-11 | Cullman | Alabama | 1043 | 581 | 6 |
318735 | 318735 | 2020-07-10 | Cullman | Alabama | 1043 | 564 | 6 |
315562 | 315562 | 2020-07-09 | Cullman | Alabama | 1043 | 549 | 5 |
312387 | 312387 | 2020-07-08 | Cullman | Alabama | 1043 | 500 | 5 |
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);