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 |
---|---|---|---|---|---|---|---|
917197 | 917197 | 2021-01-11 | Blount | Alabama | 1009 | 5080 | 77 |
913952 | 913952 | 2021-01-10 | Blount | Alabama | 1009 | 5066 | 77 |
910707 | 910707 | 2021-01-09 | Blount | Alabama | 1009 | 5047 | 77 |
907462 | 907462 | 2021-01-08 | Blount | Alabama | 1009 | 5018 | 75 |
904216 | 904216 | 2021-01-07 | Blount | Alabama | 1009 | 4957 | 72 |
900971 | 900971 | 2021-01-06 | Blount | Alabama | 1009 | 4898 | 67 |
897726 | 897726 | 2021-01-05 | Blount | Alabama | 1009 | 4849 | 63 |
894480 | 894480 | 2021-01-04 | Blount | Alabama | 1009 | 4771 | 63 |
891234 | 891234 | 2021-01-03 | Blount | Alabama | 1009 | 4746 | 63 |
887987 | 887987 | 2021-01-02 | Blount | Alabama | 1009 | 4729 | 63 |
884742 | 884742 | 2021-01-01 | Blount | Alabama | 1009 | 4693 | 63 |
881497 | 881497 | 2020-12-31 | Blount | Alabama | 1009 | 4641 | 63 |
878252 | 878252 | 2020-12-30 | Blount | Alabama | 1009 | 4584 | 63 |
875007 | 875007 | 2020-12-29 | Blount | Alabama | 1009 | 4535 | 58 |
871762 | 871762 | 2020-12-28 | Blount | Alabama | 1009 | 4483 | 58 |
868517 | 868517 | 2020-12-27 | Blount | Alabama | 1009 | 4465 | 58 |
865272 | 865272 | 2020-12-26 | Blount | Alabama | 1009 | 4446 | 58 |
862027 | 862027 | 2020-12-25 | Blount | Alabama | 1009 | 4441 | 58 |
858782 | 858782 | 2020-12-24 | Blount | Alabama | 1009 | 4405 | 58 |
855537 | 855537 | 2020-12-23 | Blount | Alabama | 1009 | 4367 | 57 |
852292 | 852292 | 2020-12-22 | Blount | Alabama | 1009 | 4313 | 54 |
849047 | 849047 | 2020-12-21 | Blount | Alabama | 1009 | 4234 | 54 |
845802 | 845802 | 2020-12-20 | Blount | Alabama | 1009 | 4218 | 54 |
842556 | 842556 | 2020-12-19 | Blount | Alabama | 1009 | 4191 | 54 |
839311 | 839311 | 2020-12-18 | Blount | Alabama | 1009 | 4118 | 52 |
836066 | 836066 | 2020-12-17 | Blount | Alabama | 1009 | 4036 | 52 |
832820 | 832820 | 2020-12-16 | Blount | Alabama | 1009 | 3950 | 50 |
829573 | 829573 | 2020-12-15 | Blount | Alabama | 1009 | 3881 | 49 |
826327 | 826327 | 2020-12-14 | Blount | Alabama | 1009 | 3803 | 47 |
823080 | 823080 | 2020-12-13 | Blount | Alabama | 1009 | 3776 | 47 |
819834 | 819834 | 2020-12-12 | Blount | Alabama | 1009 | 3744 | 47 |
816588 | 816588 | 2020-12-11 | Blount | Alabama | 1009 | 3663 | 47 |
813342 | 813342 | 2020-12-10 | Blount | Alabama | 1009 | 3600 | 47 |
810098 | 810098 | 2020-12-09 | Blount | Alabama | 1009 | 3496 | 47 |
806853 | 806853 | 2020-12-08 | Blount | Alabama | 1009 | 3426 | 46 |
803608 | 803608 | 2020-12-07 | Blount | Alabama | 1009 | 3324 | 46 |
800363 | 800363 | 2020-12-06 | Blount | Alabama | 1009 | 3299 | 46 |
797118 | 797118 | 2020-12-05 | Blount | Alabama | 1009 | 3281 | 46 |
793873 | 793873 | 2020-12-04 | Blount | Alabama | 1009 | 3231 | 46 |
790628 | 790628 | 2020-12-03 | Blount | Alabama | 1009 | 3158 | 45 |
787383 | 787383 | 2020-12-02 | Blount | Alabama | 1009 | 3100 | 43 |
784139 | 784139 | 2020-12-01 | Blount | Alabama | 1009 | 3061 | 40 |
780894 | 780894 | 2020-11-30 | Blount | Alabama | 1009 | 2997 | 40 |
777648 | 777648 | 2020-11-29 | Blount | Alabama | 1009 | 2946 | 40 |
774403 | 774403 | 2020-11-28 | Blount | Alabama | 1009 | 2922 | 40 |
771158 | 771158 | 2020-11-27 | Blount | Alabama | 1009 | 2888 | 40 |
767912 | 767912 | 2020-11-26 | Blount | Alabama | 1009 | 2879 | 40 |
764667 | 764667 | 2020-11-25 | Blount | Alabama | 1009 | 2855 | 39 |
761422 | 761422 | 2020-11-24 | Blount | Alabama | 1009 | 2822 | 36 |
758177 | 758177 | 2020-11-23 | Blount | Alabama | 1009 | 2763 | 36 |
754930 | 754930 | 2020-11-22 | Blount | Alabama | 1009 | 2754 | 36 |
751684 | 751684 | 2020-11-21 | Blount | Alabama | 1009 | 2735 | 36 |
748438 | 748438 | 2020-11-20 | Blount | Alabama | 1009 | 2704 | 35 |
745192 | 745192 | 2020-11-19 | Blount | Alabama | 1009 | 2683 | 35 |
741945 | 741945 | 2020-11-18 | Blount | Alabama | 1009 | 2648 | 35 |
738698 | 738698 | 2020-11-17 | Blount | Alabama | 1009 | 2594 | 34 |
735454 | 735454 | 2020-11-16 | Blount | Alabama | 1009 | 2574 | 34 |
732208 | 732208 | 2020-11-15 | Blount | Alabama | 1009 | 2549 | 34 |
728963 | 728963 | 2020-11-14 | Blount | Alabama | 1009 | 2518 | 34 |
725720 | 725720 | 2020-11-13 | Blount | Alabama | 1009 | 2488 | 34 |
722477 | 722477 | 2020-11-12 | Blount | Alabama | 1009 | 2429 | 34 |
719234 | 719234 | 2020-11-11 | Blount | Alabama | 1009 | 2400 | 34 |
715991 | 715991 | 2020-11-10 | Blount | Alabama | 1009 | 2378 | 26 |
712747 | 712747 | 2020-11-09 | Blount | Alabama | 1009 | 2335 | 26 |
709503 | 709503 | 2020-11-08 | Blount | Alabama | 1009 | 2297 | 26 |
706259 | 706259 | 2020-11-07 | Blount | Alabama | 1009 | 2286 | 26 |
703016 | 703016 | 2020-11-06 | Blount | Alabama | 1009 | 2253 | 26 |
699773 | 699773 | 2020-11-05 | Blount | Alabama | 1009 | 2222 | 25 |
696529 | 696529 | 2020-11-04 | Blount | Alabama | 1009 | 2188 | 25 |
693287 | 693287 | 2020-11-03 | Blount | Alabama | 1009 | 2162 | 25 |
690044 | 690044 | 2020-11-02 | Blount | Alabama | 1009 | 2108 | 25 |
686799 | 686799 | 2020-11-01 | Blount | Alabama | 1009 | 2095 | 25 |
683555 | 683555 | 2020-10-31 | Blount | Alabama | 1009 | 2074 | 25 |
680312 | 680312 | 2020-10-30 | Blount | Alabama | 1009 | 2039 | 25 |
677069 | 677069 | 2020-10-29 | Blount | Alabama | 1009 | 2009 | 25 |
673826 | 673826 | 2020-10-28 | Blount | Alabama | 1009 | 1988 | 25 |
670584 | 670584 | 2020-10-27 | Blount | Alabama | 1009 | 1972 | 25 |
667341 | 667341 | 2020-10-26 | Blount | Alabama | 1009 | 1942 | 25 |
664096 | 664096 | 2020-10-25 | Blount | Alabama | 1009 | 1932 | 25 |
660852 | 660852 | 2020-10-24 | Blount | Alabama | 1009 | 1925 | 25 |
657608 | 657608 | 2020-10-23 | Blount | Alabama | 1009 | 1911 | 25 |
654363 | 654363 | 2020-10-22 | Blount | Alabama | 1009 | 1893 | 25 |
651118 | 651118 | 2020-10-21 | Blount | Alabama | 1009 | 1873 | 25 |
647874 | 647874 | 2020-10-20 | Blount | Alabama | 1009 | 1848 | 24 |
644629 | 644629 | 2020-10-19 | Blount | Alabama | 1009 | 1838 | 23 |
641381 | 641381 | 2020-10-18 | Blount | Alabama | 1009 | 1827 | 23 |
638134 | 638134 | 2020-10-17 | Blount | Alabama | 1009 | 1807 | 23 |
634889 | 634889 | 2020-10-16 | Blount | Alabama | 1009 | 1783 | 23 |
631644 | 631644 | 2020-10-15 | Blount | Alabama | 1009 | 1768 | 23 |
628400 | 628400 | 2020-10-14 | Blount | Alabama | 1009 | 1750 | 23 |
625157 | 625157 | 2020-10-13 | Blount | Alabama | 1009 | 1742 | 16 |
621914 | 621914 | 2020-10-12 | Blount | Alabama | 1009 | 1722 | 16 |
618671 | 618671 | 2020-10-11 | Blount | Alabama | 1009 | 1713 | 16 |
615429 | 615429 | 2020-10-10 | Blount | Alabama | 1009 | 1704 | 16 |
612188 | 612188 | 2020-10-09 | Blount | Alabama | 1009 | 1689 | 16 |
608946 | 608946 | 2020-10-08 | Blount | Alabama | 1009 | 1681 | 16 |
605703 | 605703 | 2020-10-07 | Blount | Alabama | 1009 | 1673 | 16 |
602461 | 602461 | 2020-10-06 | Blount | Alabama | 1009 | 1665 | 15 |
599218 | 599218 | 2020-10-05 | Blount | Alabama | 1009 | 1662 | 15 |
595975 | 595975 | 2020-10-04 | Blount | Alabama | 1009 | 1656 | 15 |
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);