ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Chilton" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917203 | 917203 | 2021-01-11 | Chilton | Alabama | 1021 | 3277 | 54 |
913958 | 913958 | 2021-01-10 | Chilton | Alabama | 1021 | 3253 | 54 |
910713 | 910713 | 2021-01-09 | Chilton | Alabama | 1021 | 3237 | 54 |
907468 | 907468 | 2021-01-08 | Chilton | Alabama | 1021 | 3218 | 54 |
904222 | 904222 | 2021-01-07 | Chilton | Alabama | 1021 | 3159 | 54 |
900977 | 900977 | 2021-01-06 | Chilton | Alabama | 1021 | 3127 | 54 |
897732 | 897732 | 2021-01-05 | Chilton | Alabama | 1021 | 3085 | 54 |
894486 | 894486 | 2021-01-04 | Chilton | Alabama | 1021 | 3054 | 54 |
891240 | 891240 | 2021-01-03 | Chilton | Alabama | 1021 | 3032 | 54 |
887993 | 887993 | 2021-01-02 | Chilton | Alabama | 1021 | 3019 | 54 |
884748 | 884748 | 2021-01-01 | Chilton | Alabama | 1021 | 3004 | 54 |
881503 | 881503 | 2020-12-31 | Chilton | Alabama | 1021 | 2970 | 54 |
878258 | 878258 | 2020-12-30 | Chilton | Alabama | 1021 | 2913 | 54 |
875013 | 875013 | 2020-12-29 | Chilton | Alabama | 1021 | 2865 | 54 |
871768 | 871768 | 2020-12-28 | Chilton | Alabama | 1021 | 2845 | 54 |
868523 | 868523 | 2020-12-27 | Chilton | Alabama | 1021 | 2822 | 54 |
865278 | 865278 | 2020-12-26 | Chilton | Alabama | 1021 | 2812 | 54 |
862033 | 862033 | 2020-12-25 | Chilton | Alabama | 1021 | 2801 | 54 |
858788 | 858788 | 2020-12-24 | Chilton | Alabama | 1021 | 2790 | 53 |
855543 | 855543 | 2020-12-23 | Chilton | Alabama | 1021 | 2773 | 51 |
852298 | 852298 | 2020-12-22 | Chilton | Alabama | 1021 | 2743 | 50 |
849053 | 849053 | 2020-12-21 | Chilton | Alabama | 1021 | 2719 | 49 |
845808 | 845808 | 2020-12-20 | Chilton | Alabama | 1021 | 2696 | 49 |
842562 | 842562 | 2020-12-19 | Chilton | Alabama | 1021 | 2676 | 49 |
839317 | 839317 | 2020-12-18 | Chilton | Alabama | 1021 | 2649 | 47 |
836072 | 836072 | 2020-12-17 | Chilton | Alabama | 1021 | 2631 | 47 |
832826 | 832826 | 2020-12-16 | Chilton | Alabama | 1021 | 2604 | 46 |
829579 | 829579 | 2020-12-15 | Chilton | Alabama | 1021 | 2585 | 46 |
826333 | 826333 | 2020-12-14 | Chilton | Alabama | 1021 | 2553 | 46 |
823086 | 823086 | 2020-12-13 | Chilton | Alabama | 1021 | 2547 | 46 |
819840 | 819840 | 2020-12-12 | Chilton | Alabama | 1021 | 2527 | 46 |
816594 | 816594 | 2020-12-11 | Chilton | Alabama | 1021 | 2514 | 47 |
813348 | 813348 | 2020-12-10 | Chilton | Alabama | 1021 | 2507 | 47 |
810104 | 810104 | 2020-12-09 | Chilton | Alabama | 1021 | 2457 | 47 |
806859 | 806859 | 2020-12-08 | Chilton | Alabama | 1021 | 2441 | 46 |
803614 | 803614 | 2020-12-07 | Chilton | Alabama | 1021 | 2409 | 45 |
800369 | 800369 | 2020-12-06 | Chilton | Alabama | 1021 | 2391 | 45 |
797124 | 797124 | 2020-12-05 | Chilton | Alabama | 1021 | 2372 | 45 |
793879 | 793879 | 2020-12-04 | Chilton | Alabama | 1021 | 2354 | 45 |
790634 | 790634 | 2020-12-03 | Chilton | Alabama | 1021 | 2336 | 41 |
787389 | 787389 | 2020-12-02 | Chilton | Alabama | 1021 | 2308 | 41 |
784145 | 784145 | 2020-12-01 | Chilton | Alabama | 1021 | 2289 | 39 |
780900 | 780900 | 2020-11-30 | Chilton | Alabama | 1021 | 2274 | 38 |
777654 | 777654 | 2020-11-29 | Chilton | Alabama | 1021 | 2250 | 38 |
774409 | 774409 | 2020-11-28 | Chilton | Alabama | 1021 | 2234 | 38 |
771164 | 771164 | 2020-11-27 | Chilton | Alabama | 1021 | 2219 | 38 |
767918 | 767918 | 2020-11-26 | Chilton | Alabama | 1021 | 2206 | 38 |
764673 | 764673 | 2020-11-25 | Chilton | Alabama | 1021 | 2196 | 38 |
761428 | 761428 | 2020-11-24 | Chilton | Alabama | 1021 | 2185 | 37 |
758183 | 758183 | 2020-11-23 | Chilton | Alabama | 1021 | 2169 | 37 |
754936 | 754936 | 2020-11-22 | Chilton | Alabama | 1021 | 2161 | 37 |
751690 | 751690 | 2020-11-21 | Chilton | Alabama | 1021 | 2144 | 37 |
748444 | 748444 | 2020-11-20 | Chilton | Alabama | 1021 | 2125 | 36 |
745198 | 745198 | 2020-11-19 | Chilton | Alabama | 1021 | 2122 | 36 |
741951 | 741951 | 2020-11-18 | Chilton | Alabama | 1021 | 2104 | 36 |
738704 | 738704 | 2020-11-17 | Chilton | Alabama | 1021 | 2093 | 37 |
735460 | 735460 | 2020-11-16 | Chilton | Alabama | 1021 | 2084 | 36 |
732214 | 732214 | 2020-11-15 | Chilton | Alabama | 1021 | 2078 | 36 |
728969 | 728969 | 2020-11-14 | Chilton | Alabama | 1021 | 2068 | 36 |
725726 | 725726 | 2020-11-13 | Chilton | Alabama | 1021 | 2053 | 36 |
722483 | 722483 | 2020-11-12 | Chilton | Alabama | 1021 | 2048 | 36 |
719240 | 719240 | 2020-11-11 | Chilton | Alabama | 1021 | 2037 | 36 |
715997 | 715997 | 2020-11-10 | Chilton | Alabama | 1021 | 2027 | 35 |
712753 | 712753 | 2020-11-09 | Chilton | Alabama | 1021 | 2018 | 35 |
709509 | 709509 | 2020-11-08 | Chilton | Alabama | 1021 | 2011 | 35 |
706265 | 706265 | 2020-11-07 | Chilton | Alabama | 1021 | 2001 | 35 |
703022 | 703022 | 2020-11-06 | Chilton | Alabama | 1021 | 1992 | 35 |
699779 | 699779 | 2020-11-05 | Chilton | Alabama | 1021 | 1983 | 33 |
696535 | 696535 | 2020-11-04 | Chilton | Alabama | 1021 | 1970 | 33 |
693293 | 693293 | 2020-11-03 | Chilton | Alabama | 1021 | 1962 | 33 |
690050 | 690050 | 2020-11-02 | Chilton | Alabama | 1021 | 1958 | 33 |
686805 | 686805 | 2020-11-01 | Chilton | Alabama | 1021 | 1946 | 33 |
683561 | 683561 | 2020-10-31 | Chilton | Alabama | 1021 | 1938 | 33 |
680318 | 680318 | 2020-10-30 | Chilton | Alabama | 1021 | 1926 | 32 |
677075 | 677075 | 2020-10-29 | Chilton | Alabama | 1021 | 1923 | 32 |
673832 | 673832 | 2020-10-28 | Chilton | Alabama | 1021 | 1909 | 32 |
670590 | 670590 | 2020-10-27 | Chilton | Alabama | 1021 | 1904 | 32 |
667347 | 667347 | 2020-10-26 | Chilton | Alabama | 1021 | 1893 | 32 |
664102 | 664102 | 2020-10-25 | Chilton | Alabama | 1021 | 1884 | 32 |
660858 | 660858 | 2020-10-24 | Chilton | Alabama | 1021 | 1869 | 32 |
657614 | 657614 | 2020-10-23 | Chilton | Alabama | 1021 | 1858 | 32 |
654369 | 654369 | 2020-10-22 | Chilton | Alabama | 1021 | 1841 | 32 |
651124 | 651124 | 2020-10-21 | Chilton | Alabama | 1021 | 1826 | 32 |
647880 | 647880 | 2020-10-20 | Chilton | Alabama | 1021 | 1817 | 31 |
644635 | 644635 | 2020-10-19 | Chilton | Alabama | 1021 | 1805 | 31 |
641387 | 641387 | 2020-10-18 | Chilton | Alabama | 1021 | 1787 | 31 |
638140 | 638140 | 2020-10-17 | Chilton | Alabama | 1021 | 1779 | 31 |
634895 | 634895 | 2020-10-16 | Chilton | Alabama | 1021 | 1767 | 31 |
631650 | 631650 | 2020-10-15 | Chilton | Alabama | 1021 | 1756 | 31 |
628406 | 628406 | 2020-10-14 | Chilton | Alabama | 1021 | 1740 | 31 |
625163 | 625163 | 2020-10-13 | Chilton | Alabama | 1021 | 1738 | 30 |
621920 | 621920 | 2020-10-12 | Chilton | Alabama | 1021 | 1733 | 30 |
618677 | 618677 | 2020-10-11 | Chilton | Alabama | 1021 | 1722 | 30 |
615435 | 615435 | 2020-10-10 | Chilton | Alabama | 1021 | 1713 | 30 |
612194 | 612194 | 2020-10-09 | Chilton | Alabama | 1021 | 1701 | 30 |
608952 | 608952 | 2020-10-08 | Chilton | Alabama | 1021 | 1684 | 30 |
605709 | 605709 | 2020-10-07 | Chilton | Alabama | 1021 | 1679 | 30 |
602467 | 602467 | 2020-10-06 | Chilton | Alabama | 1021 | 1672 | 30 |
599224 | 599224 | 2020-10-05 | Chilton | Alabama | 1021 | 1661 | 30 |
595981 | 595981 | 2020-10-04 | Chilton | Alabama | 1021 | 1648 | 30 |
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);