ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Covington" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917212 | 917212 | 2021-01-11 | Covington | Alabama | 1039 | 3177 | 52 |
913967 | 913967 | 2021-01-10 | Covington | Alabama | 1039 | 3156 | 50 |
910722 | 910722 | 2021-01-09 | Covington | Alabama | 1039 | 3145 | 43 |
907477 | 907477 | 2021-01-08 | Covington | Alabama | 1039 | 3110 | 43 |
904231 | 904231 | 2021-01-07 | Covington | Alabama | 1039 | 3073 | 43 |
900986 | 900986 | 2021-01-06 | Covington | Alabama | 1039 | 3044 | 43 |
897741 | 897741 | 2021-01-05 | Covington | Alabama | 1039 | 3007 | 40 |
894495 | 894495 | 2021-01-04 | Covington | Alabama | 1039 | 2962 | 40 |
891249 | 891249 | 2021-01-03 | Covington | Alabama | 1039 | 2955 | 40 |
888002 | 888002 | 2021-01-02 | Covington | Alabama | 1039 | 2948 | 40 |
884757 | 884757 | 2021-01-01 | Covington | Alabama | 1039 | 2931 | 40 |
881512 | 881512 | 2020-12-31 | Covington | Alabama | 1039 | 2913 | 40 |
878267 | 878267 | 2020-12-30 | Covington | Alabama | 1039 | 2868 | 38 |
875022 | 875022 | 2020-12-29 | Covington | Alabama | 1039 | 2856 | 38 |
871777 | 871777 | 2020-12-28 | Covington | Alabama | 1039 | 2796 | 38 |
868532 | 868532 | 2020-12-27 | Covington | Alabama | 1039 | 2798 | 38 |
865287 | 865287 | 2020-12-26 | Covington | Alabama | 1039 | 2792 | 38 |
862042 | 862042 | 2020-12-25 | Covington | Alabama | 1039 | 2793 | 38 |
858797 | 858797 | 2020-12-24 | Covington | Alabama | 1039 | 2781 | 38 |
855552 | 855552 | 2020-12-23 | Covington | Alabama | 1039 | 2778 | 38 |
852307 | 852307 | 2020-12-22 | Covington | Alabama | 1039 | 2748 | 38 |
849062 | 849062 | 2020-12-21 | Covington | Alabama | 1039 | 2725 | 38 |
845817 | 845817 | 2020-12-20 | Covington | Alabama | 1039 | 2701 | 38 |
842571 | 842571 | 2020-12-19 | Covington | Alabama | 1039 | 2699 | 38 |
839326 | 839326 | 2020-12-18 | Covington | Alabama | 1039 | 2683 | 38 |
836081 | 836081 | 2020-12-17 | Covington | Alabama | 1039 | 2633 | 38 |
832835 | 832835 | 2020-12-16 | Covington | Alabama | 1039 | 2612 | 38 |
829588 | 829588 | 2020-12-15 | Covington | Alabama | 1039 | 2563 | 38 |
826342 | 826342 | 2020-12-14 | Covington | Alabama | 1039 | 2529 | 38 |
823095 | 823095 | 2020-12-13 | Covington | Alabama | 1039 | 2525 | 38 |
819849 | 819849 | 2020-12-12 | Covington | Alabama | 1039 | 2517 | 38 |
816603 | 816603 | 2020-12-11 | Covington | Alabama | 1039 | 2487 | 38 |
813357 | 813357 | 2020-12-10 | Covington | Alabama | 1039 | 2465 | 38 |
810113 | 810113 | 2020-12-09 | Covington | Alabama | 1039 | 2426 | 38 |
806868 | 806868 | 2020-12-08 | Covington | Alabama | 1039 | 2415 | 38 |
803623 | 803623 | 2020-12-07 | Covington | Alabama | 1039 | 2374 | 38 |
800378 | 800378 | 2020-12-06 | Covington | Alabama | 1039 | 2370 | 38 |
797133 | 797133 | 2020-12-05 | Covington | Alabama | 1039 | 2358 | 38 |
793888 | 793888 | 2020-12-04 | Covington | Alabama | 1039 | 2348 | 34 |
790643 | 790643 | 2020-12-03 | Covington | Alabama | 1039 | 2324 | 34 |
787398 | 787398 | 2020-12-02 | Covington | Alabama | 1039 | 2279 | 34 |
784154 | 784154 | 2020-12-01 | Covington | Alabama | 1039 | 2250 | 34 |
780909 | 780909 | 2020-11-30 | Covington | Alabama | 1039 | 2204 | 34 |
777663 | 777663 | 2020-11-29 | Covington | Alabama | 1039 | 2203 | 34 |
774418 | 774418 | 2020-11-28 | Covington | Alabama | 1039 | 2189 | 34 |
771173 | 771173 | 2020-11-27 | Covington | Alabama | 1039 | 2185 | 34 |
767927 | 767927 | 2020-11-26 | Covington | Alabama | 1039 | 2180 | 34 |
764682 | 764682 | 2020-11-25 | Covington | Alabama | 1039 | 2168 | 33 |
761437 | 761437 | 2020-11-24 | Covington | Alabama | 1039 | 2159 | 33 |
758192 | 758192 | 2020-11-23 | Covington | Alabama | 1039 | 2125 | 33 |
754945 | 754945 | 2020-11-22 | Covington | Alabama | 1039 | 2123 | 33 |
751699 | 751699 | 2020-11-21 | Covington | Alabama | 1039 | 2116 | 33 |
748453 | 748453 | 2020-11-20 | Covington | Alabama | 1039 | 2104 | 33 |
745207 | 745207 | 2020-11-19 | Covington | Alabama | 1039 | 2081 | 32 |
741960 | 741960 | 2020-11-18 | Covington | Alabama | 1039 | 2057 | 32 |
738713 | 738713 | 2020-11-17 | Covington | Alabama | 1039 | 2047 | 32 |
735469 | 735469 | 2020-11-16 | Covington | Alabama | 1039 | 2043 | 32 |
732223 | 732223 | 2020-11-15 | Covington | Alabama | 1039 | 2039 | 32 |
728978 | 728978 | 2020-11-14 | Covington | Alabama | 1039 | 2022 | 32 |
725735 | 725735 | 2020-11-13 | Covington | Alabama | 1039 | 2008 | 32 |
722492 | 722492 | 2020-11-12 | Covington | Alabama | 1039 | 1991 | 32 |
719249 | 719249 | 2020-11-11 | Covington | Alabama | 1039 | 1982 | 32 |
716006 | 716006 | 2020-11-10 | Covington | Alabama | 1039 | 1967 | 32 |
712762 | 712762 | 2020-11-09 | Covington | Alabama | 1039 | 1944 | 32 |
709518 | 709518 | 2020-11-08 | Covington | Alabama | 1039 | 1941 | 32 |
706274 | 706274 | 2020-11-07 | Covington | Alabama | 1039 | 1941 | 32 |
703031 | 703031 | 2020-11-06 | Covington | Alabama | 1039 | 1934 | 32 |
699788 | 699788 | 2020-11-05 | Covington | Alabama | 1039 | 1912 | 32 |
696544 | 696544 | 2020-11-04 | Covington | Alabama | 1039 | 1902 | 30 |
693302 | 693302 | 2020-11-03 | Covington | Alabama | 1039 | 1895 | 30 |
690059 | 690059 | 2020-11-02 | Covington | Alabama | 1039 | 1894 | 30 |
686814 | 686814 | 2020-11-01 | Covington | Alabama | 1039 | 1892 | 30 |
683570 | 683570 | 2020-10-31 | Covington | Alabama | 1039 | 1886 | 30 |
680327 | 680327 | 2020-10-30 | Covington | Alabama | 1039 | 1787 | 29 |
677084 | 677084 | 2020-10-29 | Covington | Alabama | 1039 | 1773 | 29 |
673841 | 673841 | 2020-10-28 | Covington | Alabama | 1039 | 1767 | 29 |
670599 | 670599 | 2020-10-27 | Covington | Alabama | 1039 | 1759 | 29 |
667356 | 667356 | 2020-10-26 | Covington | Alabama | 1039 | 1755 | 29 |
664111 | 664111 | 2020-10-25 | Covington | Alabama | 1039 | 1747 | 29 |
660867 | 660867 | 2020-10-24 | Covington | Alabama | 1039 | 1740 | 29 |
657623 | 657623 | 2020-10-23 | Covington | Alabama | 1039 | 1714 | 29 |
654378 | 654378 | 2020-10-22 | Covington | Alabama | 1039 | 1699 | 29 |
651133 | 651133 | 2020-10-21 | Covington | Alabama | 1039 | 1666 | 29 |
647889 | 647889 | 2020-10-20 | Covington | Alabama | 1039 | 1660 | 29 |
644644 | 644644 | 2020-10-19 | Covington | Alabama | 1039 | 1647 | 29 |
641396 | 641396 | 2020-10-18 | Covington | Alabama | 1039 | 1644 | 29 |
638149 | 638149 | 2020-10-17 | Covington | Alabama | 1039 | 1640 | 29 |
634904 | 634904 | 2020-10-16 | Covington | Alabama | 1039 | 1612 | 29 |
631659 | 631659 | 2020-10-15 | Covington | Alabama | 1039 | 1604 | 29 |
628415 | 628415 | 2020-10-14 | Covington | Alabama | 1039 | 1585 | 29 |
625172 | 625172 | 2020-10-13 | Covington | Alabama | 1039 | 1584 | 29 |
621929 | 621929 | 2020-10-12 | Covington | Alabama | 1039 | 1570 | 29 |
618686 | 618686 | 2020-10-11 | Covington | Alabama | 1039 | 1561 | 29 |
615444 | 615444 | 2020-10-10 | Covington | Alabama | 1039 | 1541 | 29 |
612203 | 612203 | 2020-10-09 | Covington | Alabama | 1039 | 1533 | 29 |
608961 | 608961 | 2020-10-08 | Covington | Alabama | 1039 | 1514 | 28 |
605718 | 605718 | 2020-10-07 | Covington | Alabama | 1039 | 1495 | 28 |
602476 | 602476 | 2020-10-06 | Covington | Alabama | 1039 | 1486 | 28 |
599233 | 599233 | 2020-10-05 | Covington | Alabama | 1039 | 1480 | 28 |
595990 | 595990 | 2020-10-04 | Covington | Alabama | 1039 | 1478 | 28 |
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);