ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Autauga" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917193 | 917193 | 2021-01-11 | Autauga | Alabama | 1001 | 4902 | 55 |
913948 | 913948 | 2021-01-10 | Autauga | Alabama | 1001 | 4879 | 54 |
910703 | 910703 | 2021-01-09 | Autauga | Alabama | 1001 | 4847 | 53 |
907458 | 907458 | 2021-01-08 | Autauga | Alabama | 1001 | 4770 | 50 |
904212 | 904212 | 2021-01-07 | Autauga | Alabama | 1001 | 4705 | 50 |
900967 | 900967 | 2021-01-06 | Autauga | Alabama | 1001 | 4645 | 50 |
897722 | 897722 | 2021-01-05 | Autauga | Alabama | 1001 | 4546 | 50 |
894476 | 894476 | 2021-01-04 | Autauga | Alabama | 1001 | 4336 | 50 |
891230 | 891230 | 2021-01-03 | Autauga | Alabama | 1001 | 4305 | 50 |
887983 | 887983 | 2021-01-02 | Autauga | Alabama | 1001 | 4268 | 50 |
884738 | 884738 | 2021-01-01 | Autauga | Alabama | 1001 | 4239 | 50 |
881493 | 881493 | 2020-12-31 | Autauga | Alabama | 1001 | 4190 | 48 |
878248 | 878248 | 2020-12-30 | Autauga | Alabama | 1001 | 4164 | 48 |
875003 | 875003 | 2020-12-29 | Autauga | Alabama | 1001 | 4105 | 47 |
871758 | 871758 | 2020-12-28 | Autauga | Alabama | 1001 | 4065 | 47 |
868513 | 868513 | 2020-12-27 | Autauga | Alabama | 1001 | 4029 | 47 |
865268 | 865268 | 2020-12-26 | Autauga | Alabama | 1001 | 3999 | 46 |
862023 | 862023 | 2020-12-25 | Autauga | Alabama | 1001 | 3990 | 46 |
858778 | 858778 | 2020-12-24 | Autauga | Alabama | 1001 | 3942 | 46 |
855533 | 855533 | 2020-12-23 | Autauga | Alabama | 1001 | 3889 | 46 |
852288 | 852288 | 2020-12-22 | Autauga | Alabama | 1001 | 3841 | 44 |
849043 | 849043 | 2020-12-21 | Autauga | Alabama | 1001 | 3780 | 44 |
845798 | 845798 | 2020-12-20 | Autauga | Alabama | 1001 | 3741 | 44 |
842552 | 842552 | 2020-12-19 | Autauga | Alabama | 1001 | 3698 | 44 |
839307 | 839307 | 2020-12-18 | Autauga | Alabama | 1001 | 3647 | 44 |
836062 | 836062 | 2020-12-17 | Autauga | Alabama | 1001 | 3570 | 43 |
832816 | 832816 | 2020-12-16 | Autauga | Alabama | 1001 | 3510 | 43 |
829569 | 829569 | 2020-12-15 | Autauga | Alabama | 1001 | 3426 | 43 |
826323 | 826323 | 2020-12-14 | Autauga | Alabama | 1001 | 3329 | 41 |
823076 | 823076 | 2020-12-13 | Autauga | Alabama | 1001 | 3300 | 41 |
819830 | 819830 | 2020-12-12 | Autauga | Alabama | 1001 | 3258 | 41 |
816584 | 816584 | 2020-12-11 | Autauga | Alabama | 1001 | 3233 | 42 |
813338 | 813338 | 2020-12-10 | Autauga | Alabama | 1001 | 3186 | 42 |
810094 | 810094 | 2020-12-09 | Autauga | Alabama | 1001 | 3117 | 42 |
806849 | 806849 | 2020-12-08 | Autauga | Alabama | 1001 | 3087 | 42 |
803604 | 803604 | 2020-12-07 | Autauga | Alabama | 1001 | 3043 | 42 |
800359 | 800359 | 2020-12-06 | Autauga | Alabama | 1001 | 3005 | 42 |
797114 | 797114 | 2020-12-05 | Autauga | Alabama | 1001 | 2979 | 42 |
793869 | 793869 | 2020-12-04 | Autauga | Alabama | 1001 | 2945 | 42 |
790624 | 790624 | 2020-12-03 | Autauga | Alabama | 1001 | 2893 | 42 |
787379 | 787379 | 2020-12-02 | Autauga | Alabama | 1001 | 2873 | 42 |
784135 | 784135 | 2020-12-01 | Autauga | Alabama | 1001 | 2818 | 42 |
780890 | 780890 | 2020-11-30 | Autauga | Alabama | 1001 | 2780 | 42 |
777644 | 777644 | 2020-11-29 | Autauga | Alabama | 1001 | 2751 | 42 |
774399 | 774399 | 2020-11-28 | Autauga | Alabama | 1001 | 2735 | 42 |
771154 | 771154 | 2020-11-27 | Autauga | Alabama | 1001 | 2716 | 42 |
767908 | 767908 | 2020-11-26 | Autauga | Alabama | 1001 | 2704 | 42 |
764663 | 764663 | 2020-11-25 | Autauga | Alabama | 1001 | 2686 | 41 |
761418 | 761418 | 2020-11-24 | Autauga | Alabama | 1001 | 2661 | 39 |
758173 | 758173 | 2020-11-23 | Autauga | Alabama | 1001 | 2634 | 39 |
754926 | 754926 | 2020-11-22 | Autauga | Alabama | 1001 | 2617 | 39 |
751680 | 751680 | 2020-11-21 | Autauga | Alabama | 1001 | 2597 | 39 |
748434 | 748434 | 2020-11-20 | Autauga | Alabama | 1001 | 2580 | 39 |
745188 | 745188 | 2020-11-19 | Autauga | Alabama | 1001 | 2554 | 39 |
741941 | 741941 | 2020-11-18 | Autauga | Alabama | 1001 | 2529 | 37 |
738694 | 738694 | 2020-11-17 | Autauga | Alabama | 1001 | 2506 | 37 |
735450 | 735450 | 2020-11-16 | Autauga | Alabama | 1001 | 2481 | 36 |
732204 | 732204 | 2020-11-15 | Autauga | Alabama | 1001 | 2456 | 36 |
728959 | 728959 | 2020-11-14 | Autauga | Alabama | 1001 | 2435 | 36 |
725716 | 725716 | 2020-11-13 | Autauga | Alabama | 1001 | 2417 | 36 |
722473 | 722473 | 2020-11-12 | Autauga | Alabama | 1001 | 2385 | 32 |
719230 | 719230 | 2020-11-11 | Autauga | Alabama | 1001 | 2351 | 32 |
715987 | 715987 | 2020-11-10 | Autauga | Alabama | 1001 | 2328 | 30 |
712743 | 712743 | 2020-11-09 | Autauga | Alabama | 1001 | 2304 | 30 |
709499 | 709499 | 2020-11-08 | Autauga | Alabama | 1001 | 2283 | 30 |
706255 | 706255 | 2020-11-07 | Autauga | Alabama | 1001 | 2267 | 30 |
703012 | 703012 | 2020-11-06 | Autauga | Alabama | 1001 | 2242 | 30 |
699769 | 699769 | 2020-11-05 | Autauga | Alabama | 1001 | 2230 | 31 |
696525 | 696525 | 2020-11-04 | Autauga | Alabama | 1001 | 2212 | 31 |
693283 | 693283 | 2020-11-03 | Autauga | Alabama | 1001 | 2197 | 31 |
690040 | 690040 | 2020-11-02 | Autauga | Alabama | 1001 | 2186 | 31 |
686795 | 686795 | 2020-11-01 | Autauga | Alabama | 1001 | 2173 | 31 |
683551 | 683551 | 2020-10-31 | Autauga | Alabama | 1001 | 2159 | 31 |
680308 | 680308 | 2020-10-30 | Autauga | Alabama | 1001 | 2141 | 31 |
677065 | 677065 | 2020-10-29 | Autauga | Alabama | 1001 | 2126 | 31 |
673822 | 673822 | 2020-10-28 | Autauga | Alabama | 1001 | 2103 | 31 |
670580 | 670580 | 2020-10-27 | Autauga | Alabama | 1001 | 2082 | 31 |
667337 | 667337 | 2020-10-26 | Autauga | Alabama | 1001 | 2074 | 31 |
664092 | 664092 | 2020-10-25 | Autauga | Alabama | 1001 | 2059 | 31 |
660848 | 660848 | 2020-10-24 | Autauga | Alabama | 1001 | 2048 | 31 |
657604 | 657604 | 2020-10-23 | Autauga | Alabama | 1001 | 2030 | 30 |
654359 | 654359 | 2020-10-22 | Autauga | Alabama | 1001 | 2023 | 30 |
651114 | 651114 | 2020-10-21 | Autauga | Alabama | 1001 | 2021 | 30 |
647870 | 647870 | 2020-10-20 | Autauga | Alabama | 1001 | 2010 | 29 |
644625 | 644625 | 2020-10-19 | Autauga | Alabama | 1001 | 1999 | 28 |
641377 | 641377 | 2020-10-18 | Autauga | Alabama | 1001 | 1989 | 28 |
638130 | 638130 | 2020-10-17 | Autauga | Alabama | 1001 | 1983 | 28 |
634885 | 634885 | 2020-10-16 | Autauga | Alabama | 1001 | 1966 | 28 |
631640 | 631640 | 2020-10-15 | Autauga | Alabama | 1001 | 1949 | 28 |
628396 | 628396 | 2020-10-14 | Autauga | Alabama | 1001 | 1928 | 28 |
625153 | 625153 | 2020-10-13 | Autauga | Alabama | 1001 | 1924 | 28 |
621910 | 621910 | 2020-10-12 | Autauga | Alabama | 1001 | 1911 | 28 |
618667 | 618667 | 2020-10-11 | Autauga | Alabama | 1001 | 1905 | 28 |
615425 | 615425 | 2020-10-10 | Autauga | Alabama | 1001 | 1898 | 28 |
612184 | 612184 | 2020-10-09 | Autauga | Alabama | 1001 | 1882 | 28 |
608942 | 608942 | 2020-10-08 | Autauga | Alabama | 1001 | 1863 | 28 |
605699 | 605699 | 2020-10-07 | Autauga | Alabama | 1001 | 1852 | 27 |
602457 | 602457 | 2020-10-06 | Autauga | Alabama | 1001 | 1839 | 27 |
599214 | 599214 | 2020-10-05 | Autauga | Alabama | 1001 | 1831 | 27 |
595971 | 595971 | 2020-10-04 | Autauga | Alabama | 1001 | 1828 | 27 |
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);