ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 1043 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1076246 | 1076246 | 2021-03-01 | Cullman | Alabama | 1043 | 8897 | 181 |
1073000 | 1073000 | 2021-02-28 | Cullman | Alabama | 1043 | 8891 | 181 |
1069754 | 1069754 | 2021-02-27 | Cullman | Alabama | 1043 | 8891 | 181 |
1066509 | 1066509 | 2021-02-26 | Cullman | Alabama | 1043 | 8879 | 179 |
1063264 | 1063264 | 2021-02-25 | Cullman | Alabama | 1043 | 8869 | 179 |
1060019 | 1060019 | 2021-02-24 | Cullman | Alabama | 1043 | 8864 | 177 |
1056773 | 1056773 | 2021-02-23 | Cullman | Alabama | 1043 | 8856 | 176 |
1053527 | 1053527 | 2021-02-22 | Cullman | Alabama | 1043 | 8841 | 175 |
1050280 | 1050280 | 2021-02-21 | Cullman | Alabama | 1043 | 8829 | 175 |
1047033 | 1047033 | 2021-02-20 | Cullman | Alabama | 1043 | 8822 | 175 |
1043788 | 1043788 | 2021-02-19 | Cullman | Alabama | 1043 | 8816 | 175 |
1040543 | 1040543 | 2021-02-18 | Cullman | Alabama | 1043 | 8813 | 171 |
1037298 | 1037298 | 2021-02-17 | Cullman | Alabama | 1043 | 8805 | 171 |
1034053 | 1034053 | 2021-02-16 | Cullman | Alabama | 1043 | 8806 | 171 |
1030807 | 1030807 | 2021-02-15 | Cullman | Alabama | 1043 | 8802 | 171 |
1027560 | 1027560 | 2021-02-14 | Cullman | Alabama | 1043 | 8797 | 171 |
1024315 | 1024315 | 2021-02-13 | Cullman | Alabama | 1043 | 8788 | 171 |
1021070 | 1021070 | 2021-02-12 | Cullman | Alabama | 1043 | 8782 | 170 |
1017825 | 1017825 | 2021-02-11 | Cullman | Alabama | 1043 | 8773 | 169 |
1014580 | 1014580 | 2021-02-10 | Cullman | Alabama | 1043 | 8763 | 168 |
1011335 | 1011335 | 2021-02-09 | Cullman | Alabama | 1043 | 8756 | 166 |
1008089 | 1008089 | 2021-02-08 | Cullman | Alabama | 1043 | 8740 | 163 |
1004843 | 1004843 | 2021-02-07 | Cullman | Alabama | 1043 | 8731 | 163 |
1001597 | 1001597 | 2021-02-06 | Cullman | Alabama | 1043 | 8723 | 163 |
998351 | 998351 | 2021-02-05 | Cullman | Alabama | 1043 | 8698 | 163 |
995105 | 995105 | 2021-02-04 | Cullman | Alabama | 1043 | 8670 | 161 |
991859 | 991859 | 2021-02-03 | Cullman | Alabama | 1043 | 8622 | 160 |
988613 | 988613 | 2021-02-02 | Cullman | Alabama | 1043 | 8592 | 150 |
985366 | 985366 | 2021-02-01 | Cullman | Alabama | 1043 | 8574 | 149 |
982119 | 982119 | 2021-01-31 | Cullman | Alabama | 1043 | 8551 | 149 |
978873 | 978873 | 2021-01-30 | Cullman | Alabama | 1043 | 8504 | 147 |
975628 | 975628 | 2021-01-29 | Cullman | Alabama | 1043 | 8504 | 147 |
972383 | 972383 | 2021-01-28 | Cullman | Alabama | 1043 | 8466 | 145 |
969138 | 969138 | 2021-01-27 | Cullman | Alabama | 1043 | 8412 | 143 |
965894 | 965894 | 2021-01-26 | Cullman | Alabama | 1043 | 8363 | 125 |
962649 | 962649 | 2021-01-25 | Cullman | Alabama | 1043 | 8296 | 124 |
959404 | 959404 | 2021-01-24 | Cullman | Alabama | 1043 | 8274 | 124 |
956158 | 956158 | 2021-01-23 | Cullman | Alabama | 1043 | 8257 | 124 |
952913 | 952913 | 2021-01-22 | Cullman | Alabama | 1043 | 8203 | 108 |
949668 | 949668 | 2021-01-21 | Cullman | Alabama | 1043 | 8159 | 106 |
946422 | 946422 | 2021-01-20 | Cullman | Alabama | 1043 | 8125 | 106 |
943175 | 943175 | 2021-01-19 | Cullman | Alabama | 1043 | 8094 | 105 |
939930 | 939930 | 2021-01-18 | Cullman | Alabama | 1043 | 8036 | 105 |
936685 | 936685 | 2021-01-17 | Cullman | Alabama | 1043 | 8023 | 105 |
933440 | 933440 | 2021-01-16 | Cullman | Alabama | 1043 | 7999 | 105 |
930195 | 930195 | 2021-01-15 | Cullman | Alabama | 1043 | 7960 | 104 |
926950 | 926950 | 2021-01-14 | Cullman | Alabama | 1043 | 7922 | 94 |
923704 | 923704 | 2021-01-13 | Cullman | Alabama | 1043 | 7847 | 84 |
920459 | 920459 | 2021-01-12 | Cullman | Alabama | 1043 | 7796 | 81 |
917214 | 917214 | 2021-01-11 | Cullman | Alabama | 1043 | 7719 | 80 |
913969 | 913969 | 2021-01-10 | Cullman | Alabama | 1043 | 7702 | 79 |
910724 | 910724 | 2021-01-09 | Cullman | Alabama | 1043 | 7666 | 78 |
907479 | 907479 | 2021-01-08 | Cullman | Alabama | 1043 | 7613 | 78 |
904233 | 904233 | 2021-01-07 | Cullman | Alabama | 1043 | 7538 | 78 |
900988 | 900988 | 2021-01-06 | Cullman | Alabama | 1043 | 7446 | 78 |
897743 | 897743 | 2021-01-05 | Cullman | Alabama | 1043 | 7370 | 78 |
894497 | 894497 | 2021-01-04 | Cullman | Alabama | 1043 | 7291 | 78 |
891251 | 891251 | 2021-01-03 | Cullman | Alabama | 1043 | 7258 | 78 |
888004 | 888004 | 2021-01-02 | Cullman | Alabama | 1043 | 7242 | 78 |
884759 | 884759 | 2021-01-01 | Cullman | Alabama | 1043 | 7194 | 78 |
881514 | 881514 | 2020-12-31 | Cullman | Alabama | 1043 | 7079 | 78 |
878269 | 878269 | 2020-12-30 | Cullman | Alabama | 1043 | 6989 | 76 |
875024 | 875024 | 2020-12-29 | Cullman | Alabama | 1043 | 6862 | 76 |
871779 | 871779 | 2020-12-28 | Cullman | Alabama | 1043 | 6774 | 76 |
868534 | 868534 | 2020-12-27 | Cullman | Alabama | 1043 | 6752 | 74 |
865289 | 865289 | 2020-12-26 | Cullman | Alabama | 1043 | 6725 | 70 |
862044 | 862044 | 2020-12-25 | Cullman | Alabama | 1043 | 6707 | 70 |
858799 | 858799 | 2020-12-24 | Cullman | Alabama | 1043 | 6650 | 70 |
855554 | 855554 | 2020-12-23 | Cullman | Alabama | 1043 | 6591 | 70 |
852309 | 852309 | 2020-12-22 | Cullman | Alabama | 1043 | 6455 | 69 |
849064 | 849064 | 2020-12-21 | Cullman | Alabama | 1043 | 6294 | 69 |
845819 | 845819 | 2020-12-20 | Cullman | Alabama | 1043 | 6269 | 69 |
842573 | 842573 | 2020-12-19 | Cullman | Alabama | 1043 | 6241 | 69 |
839328 | 839328 | 2020-12-18 | Cullman | Alabama | 1043 | 6161 | 67 |
836083 | 836083 | 2020-12-17 | Cullman | Alabama | 1043 | 6064 | 64 |
832837 | 832837 | 2020-12-16 | Cullman | Alabama | 1043 | 5935 | 64 |
829590 | 829590 | 2020-12-15 | Cullman | Alabama | 1043 | 5831 | 61 |
826344 | 826344 | 2020-12-14 | Cullman | Alabama | 1043 | 5734 | 59 |
823097 | 823097 | 2020-12-13 | Cullman | Alabama | 1043 | 5700 | 59 |
819851 | 819851 | 2020-12-12 | Cullman | Alabama | 1043 | 5633 | 59 |
816605 | 816605 | 2020-12-11 | Cullman | Alabama | 1043 | 5541 | 57 |
813359 | 813359 | 2020-12-10 | Cullman | Alabama | 1043 | 5474 | 57 |
810115 | 810115 | 2020-12-09 | Cullman | Alabama | 1043 | 5377 | 56 |
806870 | 806870 | 2020-12-08 | Cullman | Alabama | 1043 | 5299 | 56 |
803625 | 803625 | 2020-12-07 | Cullman | Alabama | 1043 | 5070 | 54 |
800380 | 800380 | 2020-12-06 | Cullman | Alabama | 1043 | 5032 | 54 |
797135 | 797135 | 2020-12-05 | Cullman | Alabama | 1043 | 4985 | 53 |
793890 | 793890 | 2020-12-04 | Cullman | Alabama | 1043 | 4906 | 50 |
790645 | 790645 | 2020-12-03 | Cullman | Alabama | 1043 | 4802 | 46 |
787400 | 787400 | 2020-12-02 | Cullman | Alabama | 1043 | 4720 | 43 |
784156 | 784156 | 2020-12-01 | Cullman | Alabama | 1043 | 4624 | 43 |
780911 | 780911 | 2020-11-30 | Cullman | Alabama | 1043 | 4515 | 42 |
777665 | 777665 | 2020-11-29 | Cullman | Alabama | 1043 | 4474 | 42 |
774420 | 774420 | 2020-11-28 | Cullman | Alabama | 1043 | 4394 | 42 |
771175 | 771175 | 2020-11-27 | Cullman | Alabama | 1043 | 4354 | 42 |
767929 | 767929 | 2020-11-26 | Cullman | Alabama | 1043 | 4334 | 42 |
764684 | 764684 | 2020-11-25 | Cullman | Alabama | 1043 | 4280 | 38 |
761439 | 761439 | 2020-11-24 | Cullman | Alabama | 1043 | 4211 | 36 |
758194 | 758194 | 2020-11-23 | Cullman | Alabama | 1043 | 4126 | 36 |
754947 | 754947 | 2020-11-22 | Cullman | Alabama | 1043 | 4096 | 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);