ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 1083 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193150 | 1193150 | 2021-04-06 | Limestone | Alabama | 1083 | 9776 | 146 |
1189900 | 1189900 | 2021-04-05 | Limestone | Alabama | 1083 | 9771 | 146 |
1186653 | 1186653 | 2021-04-04 | Limestone | Alabama | 1083 | 9769 | 146 |
1183406 | 1183406 | 2021-04-03 | Limestone | Alabama | 1083 | 9768 | 146 |
1180159 | 1180159 | 2021-04-02 | Limestone | Alabama | 1083 | 9761 | 146 |
1176912 | 1176912 | 2021-04-01 | Limestone | Alabama | 1083 | 9753 | 145 |
1173665 | 1173665 | 2021-03-31 | Limestone | Alabama | 1083 | 9744 | 145 |
1170418 | 1170418 | 2021-03-30 | Limestone | Alabama | 1083 | 9738 | 145 |
1167170 | 1167170 | 2021-03-29 | Limestone | Alabama | 1083 | 9728 | 145 |
1163922 | 1163922 | 2021-03-28 | Limestone | Alabama | 1083 | 9721 | 145 |
1160674 | 1160674 | 2021-03-27 | Limestone | Alabama | 1083 | 9713 | 145 |
1157426 | 1157426 | 2021-03-26 | Limestone | Alabama | 1083 | 9709 | 145 |
1154179 | 1154179 | 2021-03-25 | Limestone | Alabama | 1083 | 9699 | 145 |
1150932 | 1150932 | 2021-03-24 | Limestone | Alabama | 1083 | 9692 | 145 |
1147685 | 1147685 | 2021-03-23 | Limestone | Alabama | 1083 | 9676 | 142 |
1144438 | 1144438 | 2021-03-22 | Limestone | Alabama | 1083 | 9674 | 142 |
1141191 | 1141191 | 2021-03-21 | Limestone | Alabama | 1083 | 9670 | 142 |
1137945 | 1137945 | 2021-03-20 | Limestone | Alabama | 1083 | 9667 | 142 |
1134699 | 1134699 | 2021-03-19 | Limestone | Alabama | 1083 | 9661 | 142 |
1131451 | 1131451 | 2021-03-18 | Limestone | Alabama | 1083 | 9657 | 142 |
1128204 | 1128204 | 2021-03-17 | Limestone | Alabama | 1083 | 9648 | 142 |
1124958 | 1124958 | 2021-03-16 | Limestone | Alabama | 1083 | 9641 | 142 |
1121712 | 1121712 | 2021-03-15 | Limestone | Alabama | 1083 | 9632 | 142 |
1118465 | 1118465 | 2021-03-14 | Limestone | Alabama | 1083 | 9486 | 142 |
1115218 | 1115218 | 2021-03-13 | Limestone | Alabama | 1083 | 9483 | 142 |
1111972 | 1111972 | 2021-03-12 | Limestone | Alabama | 1083 | 9476 | 142 |
1108726 | 1108726 | 2021-03-11 | Limestone | Alabama | 1083 | 9471 | 142 |
1105480 | 1105480 | 2021-03-10 | Limestone | Alabama | 1083 | 9454 | 142 |
1102234 | 1102234 | 2021-03-09 | Limestone | Alabama | 1083 | 9454 | 140 |
1098988 | 1098988 | 2021-03-08 | Limestone | Alabama | 1083 | 9443 | 139 |
1095740 | 1095740 | 2021-03-07 | Limestone | Alabama | 1083 | 9440 | 139 |
1092494 | 1092494 | 2021-03-06 | Limestone | Alabama | 1083 | 9435 | 139 |
1089248 | 1089248 | 2021-03-05 | Limestone | Alabama | 1083 | 9429 | 138 |
1086003 | 1086003 | 2021-03-04 | Limestone | Alabama | 1083 | 9420 | 138 |
1082757 | 1082757 | 2021-03-03 | Limestone | Alabama | 1083 | 9413 | 136 |
1079511 | 1079511 | 2021-03-02 | Limestone | Alabama | 1083 | 9376 | 134 |
1076266 | 1076266 | 2021-03-01 | Limestone | Alabama | 1083 | 9363 | 134 |
1073020 | 1073020 | 2021-02-28 | Limestone | Alabama | 1083 | 9359 | 134 |
1069774 | 1069774 | 2021-02-27 | Limestone | Alabama | 1083 | 9353 | 134 |
1066529 | 1066529 | 2021-02-26 | Limestone | Alabama | 1083 | 9348 | 134 |
1063284 | 1063284 | 2021-02-25 | Limestone | Alabama | 1083 | 9335 | 134 |
1060039 | 1060039 | 2021-02-24 | Limestone | Alabama | 1083 | 9321 | 133 |
1056793 | 1056793 | 2021-02-23 | Limestone | Alabama | 1083 | 9303 | 130 |
1053547 | 1053547 | 2021-02-22 | Limestone | Alabama | 1083 | 9275 | 130 |
1050300 | 1050300 | 2021-02-21 | Limestone | Alabama | 1083 | 9264 | 130 |
1047053 | 1047053 | 2021-02-20 | Limestone | Alabama | 1083 | 9253 | 130 |
1043808 | 1043808 | 2021-02-19 | Limestone | Alabama | 1083 | 9241 | 130 |
1040563 | 1040563 | 2021-02-18 | Limestone | Alabama | 1083 | 9223 | 127 |
1037318 | 1037318 | 2021-02-17 | Limestone | Alabama | 1083 | 9201 | 127 |
1034073 | 1034073 | 2021-02-16 | Limestone | Alabama | 1083 | 9198 | 125 |
1030827 | 1030827 | 2021-02-15 | Limestone | Alabama | 1083 | 9190 | 125 |
1027580 | 1027580 | 2021-02-14 | Limestone | Alabama | 1083 | 9173 | 125 |
1024335 | 1024335 | 2021-02-13 | Limestone | Alabama | 1083 | 9152 | 125 |
1021090 | 1021090 | 2021-02-12 | Limestone | Alabama | 1083 | 9119 | 125 |
1017845 | 1017845 | 2021-02-11 | Limestone | Alabama | 1083 | 9097 | 125 |
1014600 | 1014600 | 2021-02-10 | Limestone | Alabama | 1083 | 9040 | 123 |
1011355 | 1011355 | 2021-02-09 | Limestone | Alabama | 1083 | 9008 | 118 |
1008109 | 1008109 | 2021-02-08 | Limestone | Alabama | 1083 | 8958 | 117 |
1004863 | 1004863 | 2021-02-07 | Limestone | Alabama | 1083 | 8939 | 117 |
1001617 | 1001617 | 2021-02-06 | Limestone | Alabama | 1083 | 8914 | 117 |
998371 | 998371 | 2021-02-05 | Limestone | Alabama | 1083 | 8866 | 117 |
995125 | 995125 | 2021-02-04 | Limestone | Alabama | 1083 | 8836 | 116 |
991879 | 991879 | 2021-02-03 | Limestone | Alabama | 1083 | 8793 | 113 |
988633 | 988633 | 2021-02-02 | Limestone | Alabama | 1083 | 8753 | 107 |
985386 | 985386 | 2021-02-01 | Limestone | Alabama | 1083 | 8706 | 106 |
982139 | 982139 | 2021-01-31 | Limestone | Alabama | 1083 | 8676 | 106 |
978893 | 978893 | 2021-01-30 | Limestone | Alabama | 1083 | 8618 | 105 |
975648 | 975648 | 2021-01-29 | Limestone | Alabama | 1083 | 8618 | 105 |
972403 | 972403 | 2021-01-28 | Limestone | Alabama | 1083 | 8564 | 89 |
969158 | 969158 | 2021-01-27 | Limestone | Alabama | 1083 | 8494 | 85 |
965914 | 965914 | 2021-01-26 | Limestone | Alabama | 1083 | 8424 | 81 |
962669 | 962669 | 2021-01-25 | Limestone | Alabama | 1083 | 8381 | 81 |
959424 | 959424 | 2021-01-24 | Limestone | Alabama | 1083 | 8349 | 81 |
956178 | 956178 | 2021-01-23 | Limestone | Alabama | 1083 | 8320 | 81 |
952933 | 952933 | 2021-01-22 | Limestone | Alabama | 1083 | 8278 | 76 |
949688 | 949688 | 2021-01-21 | Limestone | Alabama | 1083 | 8231 | 76 |
946442 | 946442 | 2021-01-20 | Limestone | Alabama | 1083 | 8132 | 76 |
943195 | 943195 | 2021-01-19 | Limestone | Alabama | 1083 | 8074 | 74 |
939950 | 939950 | 2021-01-18 | Limestone | Alabama | 1083 | 8028 | 74 |
936705 | 936705 | 2021-01-17 | Limestone | Alabama | 1083 | 8002 | 74 |
933460 | 933460 | 2021-01-16 | Limestone | Alabama | 1083 | 7962 | 74 |
930215 | 930215 | 2021-01-15 | Limestone | Alabama | 1083 | 7901 | 74 |
926970 | 926970 | 2021-01-14 | Limestone | Alabama | 1083 | 7850 | 73 |
923724 | 923724 | 2021-01-13 | Limestone | Alabama | 1083 | 7785 | 74 |
920479 | 920479 | 2021-01-12 | Limestone | Alabama | 1083 | 7722 | 64 |
917234 | 917234 | 2021-01-11 | Limestone | Alabama | 1083 | 7638 | 60 |
913989 | 913989 | 2021-01-10 | Limestone | Alabama | 1083 | 7599 | 60 |
910744 | 910744 | 2021-01-09 | Limestone | Alabama | 1083 | 7548 | 60 |
907499 | 907499 | 2021-01-08 | Limestone | Alabama | 1083 | 7426 | 60 |
904253 | 904253 | 2021-01-07 | Limestone | Alabama | 1083 | 7337 | 60 |
901008 | 901008 | 2021-01-06 | Limestone | Alabama | 1083 | 7240 | 59 |
897763 | 897763 | 2021-01-05 | Limestone | Alabama | 1083 | 7132 | 58 |
894517 | 894517 | 2021-01-04 | Limestone | Alabama | 1083 | 7085 | 58 |
891271 | 891271 | 2021-01-03 | Limestone | Alabama | 1083 | 7037 | 58 |
888024 | 888024 | 2021-01-02 | Limestone | Alabama | 1083 | 6992 | 58 |
884779 | 884779 | 2021-01-01 | Limestone | Alabama | 1083 | 6879 | 58 |
881534 | 881534 | 2020-12-31 | Limestone | Alabama | 1083 | 6822 | 58 |
878289 | 878289 | 2020-12-30 | Limestone | Alabama | 1083 | 6724 | 56 |
875044 | 875044 | 2020-12-29 | Limestone | Alabama | 1083 | 6628 | 55 |
871799 | 871799 | 2020-12-28 | Limestone | Alabama | 1083 | 6561 | 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);