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 |
---|---|---|---|---|---|---|---|
1050259 | 1050259 | 2021-02-21 | Autauga | Alabama | 1001 | 6117 | 85 |
1047012 | 1047012 | 2021-02-20 | Autauga | Alabama | 1001 | 6092 | 85 |
1043767 | 1043767 | 2021-02-19 | Autauga | Alabama | 1001 | 6079 | 85 |
1040522 | 1040522 | 2021-02-18 | Autauga | Alabama | 1001 | 6071 | 84 |
1037277 | 1037277 | 2021-02-17 | Autauga | Alabama | 1001 | 6050 | 84 |
1034032 | 1034032 | 2021-02-16 | Autauga | Alabama | 1001 | 6038 | 84 |
1030786 | 1030786 | 2021-02-15 | Autauga | Alabama | 1001 | 6024 | 84 |
1027539 | 1027539 | 2021-02-14 | Autauga | Alabama | 1001 | 6023 | 84 |
1024294 | 1024294 | 2021-02-13 | Autauga | Alabama | 1001 | 6002 | 84 |
1021049 | 1021049 | 2021-02-12 | Autauga | Alabama | 1001 | 5984 | 84 |
1017804 | 1017804 | 2021-02-11 | Autauga | Alabama | 1001 | 5970 | 81 |
1014559 | 1014559 | 2021-02-10 | Autauga | Alabama | 1001 | 5930 | 79 |
1011314 | 1011314 | 2021-02-09 | Autauga | Alabama | 1001 | 5910 | 77 |
1008068 | 1008068 | 2021-02-08 | Autauga | Alabama | 1001 | 5881 | 77 |
1004822 | 1004822 | 2021-02-07 | Autauga | Alabama | 1001 | 5869 | 77 |
1001576 | 1001576 | 2021-02-06 | Autauga | Alabama | 1001 | 5856 | 77 |
998330 | 998330 | 2021-02-05 | Autauga | Alabama | 1001 | 5824 | 76 |
995084 | 995084 | 2021-02-04 | Autauga | Alabama | 1001 | 5811 | 74 |
991838 | 991838 | 2021-02-03 | Autauga | Alabama | 1001 | 5753 | 71 |
988592 | 988592 | 2021-02-02 | Autauga | Alabama | 1001 | 5723 | 70 |
985345 | 985345 | 2021-02-01 | Autauga | Alabama | 1001 | 5683 | 69 |
982098 | 982098 | 2021-01-31 | Autauga | Alabama | 1001 | 5669 | 69 |
978852 | 978852 | 2021-01-30 | Autauga | Alabama | 1001 | 5596 | 69 |
975607 | 975607 | 2021-01-29 | Autauga | Alabama | 1001 | 5596 | 69 |
972362 | 972362 | 2021-01-28 | Autauga | Alabama | 1001 | 5554 | 69 |
969117 | 969117 | 2021-01-27 | Autauga | Alabama | 1001 | 5499 | 67 |
965873 | 965873 | 2021-01-26 | Autauga | Alabama | 1001 | 5440 | 65 |
962628 | 962628 | 2021-01-25 | Autauga | Alabama | 1001 | 5407 | 62 |
959383 | 959383 | 2021-01-24 | Autauga | Alabama | 1001 | 5376 | 62 |
956137 | 956137 | 2021-01-23 | Autauga | Alabama | 1001 | 5358 | 62 |
952892 | 952892 | 2021-01-22 | Autauga | Alabama | 1001 | 5327 | 61 |
949647 | 949647 | 2021-01-21 | Autauga | Alabama | 1001 | 5270 | 61 |
946401 | 946401 | 2021-01-20 | Autauga | Alabama | 1001 | 5257 | 55 |
943154 | 943154 | 2021-01-19 | Autauga | Alabama | 1001 | 5227 | 55 |
939909 | 939909 | 2021-01-18 | Autauga | Alabama | 1001 | 5198 | 55 |
936664 | 936664 | 2021-01-17 | Autauga | Alabama | 1001 | 5184 | 55 |
933419 | 933419 | 2021-01-16 | Autauga | Alabama | 1001 | 5154 | 55 |
930174 | 930174 | 2021-01-15 | Autauga | Alabama | 1001 | 5103 | 55 |
926929 | 926929 | 2021-01-14 | Autauga | Alabama | 1001 | 5075 | 55 |
923683 | 923683 | 2021-01-13 | Autauga | Alabama | 1001 | 4998 | 55 |
920438 | 920438 | 2021-01-12 | Autauga | Alabama | 1001 | 4970 | 55 |
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 |
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);