ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 1115 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1079528 | 1079528 | 2021-03-02 | St. Clair | Alabama | 1115 | 8839 | 224 |
1076283 | 1076283 | 2021-03-01 | St. Clair | Alabama | 1115 | 8827 | 223 |
1073037 | 1073037 | 2021-02-28 | St. Clair | Alabama | 1115 | 8822 | 223 |
1069791 | 1069791 | 2021-02-27 | St. Clair | Alabama | 1115 | 8813 | 223 |
1066546 | 1066546 | 2021-02-26 | St. Clair | Alabama | 1115 | 8799 | 221 |
1063301 | 1063301 | 2021-02-25 | St. Clair | Alabama | 1115 | 8783 | 220 |
1060056 | 1060056 | 2021-02-24 | St. Clair | Alabama | 1115 | 8771 | 220 |
1056810 | 1056810 | 2021-02-23 | St. Clair | Alabama | 1115 | 8747 | 214 |
1053564 | 1053564 | 2021-02-22 | St. Clair | Alabama | 1115 | 8731 | 213 |
1050317 | 1050317 | 2021-02-21 | St. Clair | Alabama | 1115 | 8718 | 213 |
1047070 | 1047070 | 2021-02-20 | St. Clair | Alabama | 1115 | 8705 | 213 |
1043825 | 1043825 | 2021-02-19 | St. Clair | Alabama | 1115 | 8682 | 213 |
1040580 | 1040580 | 2021-02-18 | St. Clair | Alabama | 1115 | 8670 | 212 |
1037335 | 1037335 | 2021-02-17 | St. Clair | Alabama | 1115 | 8647 | 211 |
1034090 | 1034090 | 2021-02-16 | St. Clair | Alabama | 1115 | 8635 | 210 |
1030844 | 1030844 | 2021-02-15 | St. Clair | Alabama | 1115 | 8608 | 210 |
1027597 | 1027597 | 2021-02-14 | St. Clair | Alabama | 1115 | 8598 | 210 |
1024352 | 1024352 | 2021-02-13 | St. Clair | Alabama | 1115 | 8575 | 210 |
1021107 | 1021107 | 2021-02-12 | St. Clair | Alabama | 1115 | 8555 | 209 |
1017862 | 1017862 | 2021-02-11 | St. Clair | Alabama | 1115 | 8524 | 206 |
1014617 | 1014617 | 2021-02-10 | St. Clair | Alabama | 1115 | 8509 | 204 |
1011372 | 1011372 | 2021-02-09 | St. Clair | Alabama | 1115 | 8489 | 190 |
1008126 | 1008126 | 2021-02-08 | St. Clair | Alabama | 1115 | 8458 | 186 |
1004880 | 1004880 | 2021-02-07 | St. Clair | Alabama | 1115 | 8439 | 186 |
1001634 | 1001634 | 2021-02-06 | St. Clair | Alabama | 1115 | 8419 | 186 |
998388 | 998388 | 2021-02-05 | St. Clair | Alabama | 1115 | 8375 | 178 |
995142 | 995142 | 2021-02-04 | St. Clair | Alabama | 1115 | 8341 | 179 |
991896 | 991896 | 2021-02-03 | St. Clair | Alabama | 1115 | 8263 | 175 |
988650 | 988650 | 2021-02-02 | St. Clair | Alabama | 1115 | 8222 | 166 |
985403 | 985403 | 2021-02-01 | St. Clair | Alabama | 1115 | 8179 | 155 |
982156 | 982156 | 2021-01-31 | St. Clair | Alabama | 1115 | 8159 | 155 |
978910 | 978910 | 2021-01-30 | St. Clair | Alabama | 1115 | 8091 | 149 |
975665 | 975665 | 2021-01-29 | St. Clair | Alabama | 1115 | 8091 | 149 |
972420 | 972420 | 2021-01-28 | St. Clair | Alabama | 1115 | 8047 | 147 |
969175 | 969175 | 2021-01-27 | St. Clair | Alabama | 1115 | 7985 | 144 |
965931 | 965931 | 2021-01-26 | St. Clair | Alabama | 1115 | 7915 | 139 |
962686 | 962686 | 2021-01-25 | St. Clair | Alabama | 1115 | 7876 | 130 |
959441 | 959441 | 2021-01-24 | St. Clair | Alabama | 1115 | 7854 | 130 |
956195 | 956195 | 2021-01-23 | St. Clair | Alabama | 1115 | 7808 | 130 |
952950 | 952950 | 2021-01-22 | St. Clair | Alabama | 1115 | 7763 | 125 |
949705 | 949705 | 2021-01-21 | St. Clair | Alabama | 1115 | 7705 | 122 |
946459 | 946459 | 2021-01-20 | St. Clair | Alabama | 1115 | 7651 | 121 |
943212 | 943212 | 2021-01-19 | St. Clair | Alabama | 1115 | 7599 | 120 |
939967 | 939967 | 2021-01-18 | St. Clair | Alabama | 1115 | 7555 | 120 |
936722 | 936722 | 2021-01-17 | St. Clair | Alabama | 1115 | 7535 | 120 |
933477 | 933477 | 2021-01-16 | St. Clair | Alabama | 1115 | 7502 | 120 |
930232 | 930232 | 2021-01-15 | St. Clair | Alabama | 1115 | 7460 | 120 |
926987 | 926987 | 2021-01-14 | St. Clair | Alabama | 1115 | 7417 | 120 |
923741 | 923741 | 2021-01-13 | St. Clair | Alabama | 1115 | 7339 | 116 |
920496 | 920496 | 2021-01-12 | St. Clair | Alabama | 1115 | 7305 | 116 |
917251 | 917251 | 2021-01-11 | St. Clair | Alabama | 1115 | 7250 | 115 |
914006 | 914006 | 2021-01-10 | St. Clair | Alabama | 1115 | 7213 | 115 |
910761 | 910761 | 2021-01-09 | St. Clair | Alabama | 1115 | 7167 | 115 |
907516 | 907516 | 2021-01-08 | St. Clair | Alabama | 1115 | 7055 | 74 |
904270 | 904270 | 2021-01-07 | St. Clair | Alabama | 1115 | 6991 | 74 |
901025 | 901025 | 2021-01-06 | St. Clair | Alabama | 1115 | 6922 | 73 |
897780 | 897780 | 2021-01-05 | St. Clair | Alabama | 1115 | 6873 | 73 |
894534 | 894534 | 2021-01-04 | St. Clair | Alabama | 1115 | 6799 | 73 |
891288 | 891288 | 2021-01-03 | St. Clair | Alabama | 1115 | 6752 | 73 |
888041 | 888041 | 2021-01-02 | St. Clair | Alabama | 1115 | 6709 | 73 |
884796 | 884796 | 2021-01-01 | St. Clair | Alabama | 1115 | 6577 | 73 |
881551 | 881551 | 2020-12-31 | St. Clair | Alabama | 1115 | 6467 | 73 |
878306 | 878306 | 2020-12-30 | St. Clair | Alabama | 1115 | 6416 | 72 |
875061 | 875061 | 2020-12-29 | St. Clair | Alabama | 1115 | 6351 | 71 |
871816 | 871816 | 2020-12-28 | St. Clair | Alabama | 1115 | 6280 | 71 |
868571 | 868571 | 2020-12-27 | St. Clair | Alabama | 1115 | 6232 | 71 |
865326 | 865326 | 2020-12-26 | St. Clair | Alabama | 1115 | 6193 | 71 |
862081 | 862081 | 2020-12-25 | St. Clair | Alabama | 1115 | 6172 | 71 |
858836 | 858836 | 2020-12-24 | St. Clair | Alabama | 1115 | 6077 | 71 |
855591 | 855591 | 2020-12-23 | St. Clair | Alabama | 1115 | 6015 | 69 |
852346 | 852346 | 2020-12-22 | St. Clair | Alabama | 1115 | 5960 | 64 |
849101 | 849101 | 2020-12-21 | St. Clair | Alabama | 1115 | 5814 | 63 |
845856 | 845856 | 2020-12-20 | St. Clair | Alabama | 1115 | 5770 | 63 |
842610 | 842610 | 2020-12-19 | St. Clair | Alabama | 1115 | 5722 | 63 |
839365 | 839365 | 2020-12-18 | St. Clair | Alabama | 1115 | 5648 | 63 |
836120 | 836120 | 2020-12-17 | St. Clair | Alabama | 1115 | 5567 | 63 |
832874 | 832874 | 2020-12-16 | St. Clair | Alabama | 1115 | 5465 | 62 |
829627 | 829627 | 2020-12-15 | St. Clair | Alabama | 1115 | 5391 | 62 |
826381 | 826381 | 2020-12-14 | St. Clair | Alabama | 1115 | 5323 | 62 |
823134 | 823134 | 2020-12-13 | St. Clair | Alabama | 1115 | 5261 | 62 |
819888 | 819888 | 2020-12-12 | St. Clair | Alabama | 1115 | 5210 | 62 |
816642 | 816642 | 2020-12-11 | St. Clair | Alabama | 1115 | 5107 | 62 |
813396 | 813396 | 2020-12-10 | St. Clair | Alabama | 1115 | 5058 | 60 |
810152 | 810152 | 2020-12-09 | St. Clair | Alabama | 1115 | 4995 | 60 |
806907 | 806907 | 2020-12-08 | St. Clair | Alabama | 1115 | 4938 | 57 |
803662 | 803662 | 2020-12-07 | St. Clair | Alabama | 1115 | 4815 | 57 |
800417 | 800417 | 2020-12-06 | St. Clair | Alabama | 1115 | 4768 | 57 |
797172 | 797172 | 2020-12-05 | St. Clair | Alabama | 1115 | 4733 | 57 |
793927 | 793927 | 2020-12-04 | St. Clair | Alabama | 1115 | 4665 | 57 |
790682 | 790682 | 2020-12-03 | St. Clair | Alabama | 1115 | 4603 | 57 |
787437 | 787437 | 2020-12-02 | St. Clair | Alabama | 1115 | 4518 | 57 |
784193 | 784193 | 2020-12-01 | St. Clair | Alabama | 1115 | 4419 | 56 |
780948 | 780948 | 2020-11-30 | St. Clair | Alabama | 1115 | 4325 | 55 |
777702 | 777702 | 2020-11-29 | St. Clair | Alabama | 1115 | 4257 | 55 |
774457 | 774457 | 2020-11-28 | St. Clair | Alabama | 1115 | 4195 | 55 |
771212 | 771212 | 2020-11-27 | St. Clair | Alabama | 1115 | 4158 | 55 |
767966 | 767966 | 2020-11-26 | St. Clair | Alabama | 1115 | 4136 | 55 |
764721 | 764721 | 2020-11-25 | St. Clair | Alabama | 1115 | 4090 | 55 |
761476 | 761476 | 2020-11-24 | St. Clair | Alabama | 1115 | 4039 | 55 |
758231 | 758231 | 2020-11-23 | St. Clair | Alabama | 1115 | 3984 | 55 |
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);