ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 1121 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050319 | 1050319 | 2021-02-21 | Talladega | Alabama | 1121 | 7400 | 161 |
1047072 | 1047072 | 2021-02-20 | Talladega | Alabama | 1121 | 7391 | 161 |
1043827 | 1043827 | 2021-02-19 | Talladega | Alabama | 1121 | 7373 | 161 |
1040582 | 1040582 | 2021-02-18 | Talladega | Alabama | 1121 | 7364 | 159 |
1037337 | 1037337 | 2021-02-17 | Talladega | Alabama | 1121 | 7326 | 153 |
1034092 | 1034092 | 2021-02-16 | Talladega | Alabama | 1121 | 7309 | 150 |
1030846 | 1030846 | 2021-02-15 | Talladega | Alabama | 1121 | 7284 | 150 |
1027599 | 1027599 | 2021-02-14 | Talladega | Alabama | 1121 | 7276 | 150 |
1024354 | 1024354 | 2021-02-13 | Talladega | Alabama | 1121 | 7257 | 150 |
1021109 | 1021109 | 2021-02-12 | Talladega | Alabama | 1121 | 7238 | 149 |
1017864 | 1017864 | 2021-02-11 | Talladega | Alabama | 1121 | 7213 | 143 |
1014619 | 1014619 | 2021-02-10 | Talladega | Alabama | 1121 | 7193 | 141 |
1011374 | 1011374 | 2021-02-09 | Talladega | Alabama | 1121 | 7189 | 133 |
1008128 | 1008128 | 2021-02-08 | Talladega | Alabama | 1121 | 7160 | 133 |
1004882 | 1004882 | 2021-02-07 | Talladega | Alabama | 1121 | 7155 | 133 |
1001636 | 1001636 | 2021-02-06 | Talladega | Alabama | 1121 | 7139 | 133 |
998390 | 998390 | 2021-02-05 | Talladega | Alabama | 1121 | 7111 | 130 |
995144 | 995144 | 2021-02-04 | Talladega | Alabama | 1121 | 7103 | 128 |
991898 | 991898 | 2021-02-03 | Talladega | Alabama | 1121 | 6908 | 125 |
988652 | 988652 | 2021-02-02 | Talladega | Alabama | 1121 | 6883 | 119 |
985405 | 985405 | 2021-02-01 | Talladega | Alabama | 1121 | 6852 | 117 |
982158 | 982158 | 2021-01-31 | Talladega | Alabama | 1121 | 6837 | 117 |
978912 | 978912 | 2021-01-30 | Talladega | Alabama | 1121 | 6762 | 116 |
975667 | 975667 | 2021-01-29 | Talladega | Alabama | 1121 | 6762 | 116 |
972422 | 972422 | 2021-01-28 | Talladega | Alabama | 1121 | 6711 | 114 |
969177 | 969177 | 2021-01-27 | Talladega | Alabama | 1121 | 6637 | 114 |
965933 | 965933 | 2021-01-26 | Talladega | Alabama | 1121 | 6552 | 112 |
962688 | 962688 | 2021-01-25 | Talladega | Alabama | 1121 | 6523 | 112 |
959443 | 959443 | 2021-01-24 | Talladega | Alabama | 1121 | 6481 | 112 |
956197 | 956197 | 2021-01-23 | Talladega | Alabama | 1121 | 6445 | 112 |
952952 | 952952 | 2021-01-22 | Talladega | Alabama | 1121 | 6394 | 111 |
949707 | 949707 | 2021-01-21 | Talladega | Alabama | 1121 | 6347 | 109 |
946461 | 946461 | 2021-01-20 | Talladega | Alabama | 1121 | 6309 | 108 |
943214 | 943214 | 2021-01-19 | Talladega | Alabama | 1121 | 6224 | 108 |
939969 | 939969 | 2021-01-18 | Talladega | Alabama | 1121 | 6180 | 108 |
936724 | 936724 | 2021-01-17 | Talladega | Alabama | 1121 | 6166 | 108 |
933479 | 933479 | 2021-01-16 | Talladega | Alabama | 1121 | 6145 | 108 |
930234 | 930234 | 2021-01-15 | Talladega | Alabama | 1121 | 6102 | 108 |
926989 | 926989 | 2021-01-14 | Talladega | Alabama | 1121 | 6036 | 108 |
923743 | 923743 | 2021-01-13 | Talladega | Alabama | 1121 | 5984 | 108 |
920498 | 920498 | 2021-01-12 | Talladega | Alabama | 1121 | 5892 | 108 |
917253 | 917253 | 2021-01-11 | Talladega | Alabama | 1121 | 5825 | 109 |
914008 | 914008 | 2021-01-10 | Talladega | Alabama | 1121 | 5796 | 109 |
910763 | 910763 | 2021-01-09 | Talladega | Alabama | 1121 | 5766 | 109 |
907518 | 907518 | 2021-01-08 | Talladega | Alabama | 1121 | 5689 | 84 |
904272 | 904272 | 2021-01-07 | Talladega | Alabama | 1121 | 5617 | 76 |
901027 | 901027 | 2021-01-06 | Talladega | Alabama | 1121 | 5528 | 76 |
897782 | 897782 | 2021-01-05 | Talladega | Alabama | 1121 | 5466 | 77 |
894536 | 894536 | 2021-01-04 | Talladega | Alabama | 1121 | 5300 | 76 |
891290 | 891290 | 2021-01-03 | Talladega | Alabama | 1121 | 5274 | 76 |
888043 | 888043 | 2021-01-02 | Talladega | Alabama | 1121 | 5254 | 76 |
884798 | 884798 | 2021-01-01 | Talladega | Alabama | 1121 | 5211 | 76 |
881553 | 881553 | 2020-12-31 | Talladega | Alabama | 1121 | 5165 | 75 |
878308 | 878308 | 2020-12-30 | Talladega | Alabama | 1121 | 5111 | 74 |
875063 | 875063 | 2020-12-29 | Talladega | Alabama | 1121 | 5053 | 74 |
871818 | 871818 | 2020-12-28 | Talladega | Alabama | 1121 | 4953 | 74 |
868573 | 868573 | 2020-12-27 | Talladega | Alabama | 1121 | 4932 | 74 |
865328 | 865328 | 2020-12-26 | Talladega | Alabama | 1121 | 4917 | 74 |
862083 | 862083 | 2020-12-25 | Talladega | Alabama | 1121 | 4907 | 74 |
858838 | 858838 | 2020-12-24 | Talladega | Alabama | 1121 | 4852 | 74 |
855593 | 855593 | 2020-12-23 | Talladega | Alabama | 1121 | 4818 | 72 |
852348 | 852348 | 2020-12-22 | Talladega | Alabama | 1121 | 4767 | 71 |
849103 | 849103 | 2020-12-21 | Talladega | Alabama | 1121 | 4688 | 69 |
845858 | 845858 | 2020-12-20 | Talladega | Alabama | 1121 | 4655 | 69 |
842612 | 842612 | 2020-12-19 | Talladega | Alabama | 1121 | 4626 | 69 |
839367 | 839367 | 2020-12-18 | Talladega | Alabama | 1121 | 4582 | 68 |
836122 | 836122 | 2020-12-17 | Talladega | Alabama | 1121 | 4546 | 67 |
832876 | 832876 | 2020-12-16 | Talladega | Alabama | 1121 | 4476 | 64 |
829629 | 829629 | 2020-12-15 | Talladega | Alabama | 1121 | 4448 | 64 |
826383 | 826383 | 2020-12-14 | Talladega | Alabama | 1121 | 4371 | 63 |
823136 | 823136 | 2020-12-13 | Talladega | Alabama | 1121 | 4335 | 63 |
819890 | 819890 | 2020-12-12 | Talladega | Alabama | 1121 | 4298 | 63 |
816644 | 816644 | 2020-12-11 | Talladega | Alabama | 1121 | 4241 | 62 |
813398 | 813398 | 2020-12-10 | Talladega | Alabama | 1121 | 4180 | 61 |
810154 | 810154 | 2020-12-09 | Talladega | Alabama | 1121 | 4110 | 61 |
806909 | 806909 | 2020-12-08 | Talladega | Alabama | 1121 | 4082 | 62 |
803664 | 803664 | 2020-12-07 | Talladega | Alabama | 1121 | 3976 | 60 |
800419 | 800419 | 2020-12-06 | Talladega | Alabama | 1121 | 3944 | 60 |
797174 | 797174 | 2020-12-05 | Talladega | Alabama | 1121 | 3911 | 60 |
793929 | 793929 | 2020-12-04 | Talladega | Alabama | 1121 | 3861 | 57 |
790684 | 790684 | 2020-12-03 | Talladega | Alabama | 1121 | 3811 | 57 |
787439 | 787439 | 2020-12-02 | Talladega | Alabama | 1121 | 3744 | 57 |
784195 | 784195 | 2020-12-01 | Talladega | Alabama | 1121 | 3701 | 57 |
780950 | 780950 | 2020-11-30 | Talladega | Alabama | 1121 | 3593 | 54 |
777704 | 777704 | 2020-11-29 | Talladega | Alabama | 1121 | 3535 | 54 |
774459 | 774459 | 2020-11-28 | Talladega | Alabama | 1121 | 3514 | 54 |
771214 | 771214 | 2020-11-27 | Talladega | Alabama | 1121 | 3490 | 54 |
767968 | 767968 | 2020-11-26 | Talladega | Alabama | 1121 | 3479 | 54 |
764723 | 764723 | 2020-11-25 | Talladega | Alabama | 1121 | 3434 | 53 |
761478 | 761478 | 2020-11-24 | Talladega | Alabama | 1121 | 3390 | 44 |
758233 | 758233 | 2020-11-23 | Talladega | Alabama | 1121 | 3359 | 42 |
754986 | 754986 | 2020-11-22 | Talladega | Alabama | 1121 | 3340 | 42 |
751740 | 751740 | 2020-11-21 | Talladega | Alabama | 1121 | 3318 | 42 |
748494 | 748494 | 2020-11-20 | Talladega | Alabama | 1121 | 3292 | 42 |
745248 | 745248 | 2020-11-19 | Talladega | Alabama | 1121 | 3263 | 41 |
742001 | 742001 | 2020-11-18 | Talladega | Alabama | 1121 | 3227 | 41 |
738754 | 738754 | 2020-11-17 | Talladega | Alabama | 1121 | 3188 | 41 |
735510 | 735510 | 2020-11-16 | Talladega | Alabama | 1121 | 3180 | 41 |
732264 | 732264 | 2020-11-15 | Talladega | Alabama | 1121 | 3171 | 41 |
729019 | 729019 | 2020-11-14 | Talladega | Alabama | 1121 | 3120 | 41 |
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);