ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 1069 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193143 | 1193143 | 2021-04-06 | Houston | Alabama | 1069 | 10363 | 275 |
1189893 | 1189893 | 2021-04-05 | Houston | Alabama | 1069 | 10359 | 276 |
1186646 | 1186646 | 2021-04-04 | Houston | Alabama | 1069 | 10357 | 276 |
1183399 | 1183399 | 2021-04-03 | Houston | Alabama | 1069 | 10354 | 276 |
1180152 | 1180152 | 2021-04-02 | Houston | Alabama | 1069 | 10347 | 275 |
1176905 | 1176905 | 2021-04-01 | Houston | Alabama | 1069 | 10342 | 272 |
1173658 | 1173658 | 2021-03-31 | Houston | Alabama | 1069 | 10332 | 272 |
1170411 | 1170411 | 2021-03-30 | Houston | Alabama | 1069 | 10318 | 271 |
1167163 | 1167163 | 2021-03-29 | Houston | Alabama | 1069 | 10315 | 271 |
1163915 | 1163915 | 2021-03-28 | Houston | Alabama | 1069 | 10311 | 271 |
1160667 | 1160667 | 2021-03-27 | Houston | Alabama | 1069 | 10301 | 271 |
1157419 | 1157419 | 2021-03-26 | Houston | Alabama | 1069 | 10299 | 271 |
1154172 | 1154172 | 2021-03-25 | Houston | Alabama | 1069 | 10280 | 269 |
1150925 | 1150925 | 2021-03-24 | Houston | Alabama | 1069 | 10266 | 269 |
1147678 | 1147678 | 2021-03-23 | Houston | Alabama | 1069 | 10257 | 269 |
1144431 | 1144431 | 2021-03-22 | Houston | Alabama | 1069 | 10259 | 269 |
1141184 | 1141184 | 2021-03-21 | Houston | Alabama | 1069 | 10255 | 269 |
1137938 | 1137938 | 2021-03-20 | Houston | Alabama | 1069 | 10252 | 269 |
1134692 | 1134692 | 2021-03-19 | Houston | Alabama | 1069 | 10244 | 269 |
1131444 | 1131444 | 2021-03-18 | Houston | Alabama | 1069 | 10242 | 269 |
1128197 | 1128197 | 2021-03-17 | Houston | Alabama | 1069 | 10236 | 268 |
1124951 | 1124951 | 2021-03-16 | Houston | Alabama | 1069 | 10231 | 267 |
1121705 | 1121705 | 2021-03-15 | Houston | Alabama | 1069 | 10227 | 267 |
1118458 | 1118458 | 2021-03-14 | Houston | Alabama | 1069 | 10200 | 267 |
1115211 | 1115211 | 2021-03-13 | Houston | Alabama | 1069 | 10198 | 267 |
1111965 | 1111965 | 2021-03-12 | Houston | Alabama | 1069 | 10189 | 266 |
1108719 | 1108719 | 2021-03-11 | Houston | Alabama | 1069 | 10180 | 266 |
1105473 | 1105473 | 2021-03-10 | Houston | Alabama | 1069 | 10165 | 265 |
1102227 | 1102227 | 2021-03-09 | Houston | Alabama | 1069 | 10155 | 264 |
1098981 | 1098981 | 2021-03-08 | Houston | Alabama | 1069 | 10140 | 264 |
1095733 | 1095733 | 2021-03-07 | Houston | Alabama | 1069 | 10130 | 264 |
1092487 | 1092487 | 2021-03-06 | Houston | Alabama | 1069 | 10121 | 264 |
1089241 | 1089241 | 2021-03-05 | Houston | Alabama | 1069 | 10130 | 264 |
1085996 | 1085996 | 2021-03-04 | Houston | Alabama | 1069 | 10124 | 264 |
1082750 | 1082750 | 2021-03-03 | Houston | Alabama | 1069 | 10110 | 262 |
1079504 | 1079504 | 2021-03-02 | Houston | Alabama | 1069 | 10102 | 261 |
1076259 | 1076259 | 2021-03-01 | Houston | Alabama | 1069 | 10104 | 261 |
1073013 | 1073013 | 2021-02-28 | Houston | Alabama | 1069 | 10086 | 261 |
1069767 | 1069767 | 2021-02-27 | Houston | Alabama | 1069 | 10073 | 261 |
1066522 | 1066522 | 2021-02-26 | Houston | Alabama | 1069 | 10058 | 259 |
1063277 | 1063277 | 2021-02-25 | Houston | Alabama | 1069 | 10048 | 259 |
1060032 | 1060032 | 2021-02-24 | Houston | Alabama | 1069 | 10036 | 257 |
1056786 | 1056786 | 2021-02-23 | Houston | Alabama | 1069 | 10019 | 255 |
1053540 | 1053540 | 2021-02-22 | Houston | Alabama | 1069 | 10019 | 255 |
1050293 | 1050293 | 2021-02-21 | Houston | Alabama | 1069 | 10002 | 255 |
1047046 | 1047046 | 2021-02-20 | Houston | Alabama | 1069 | 9991 | 255 |
1043801 | 1043801 | 2021-02-19 | Houston | Alabama | 1069 | 9979 | 255 |
1040556 | 1040556 | 2021-02-18 | Houston | Alabama | 1069 | 9969 | 251 |
1037311 | 1037311 | 2021-02-17 | Houston | Alabama | 1069 | 9947 | 251 |
1034066 | 1034066 | 2021-02-16 | Houston | Alabama | 1069 | 9930 | 247 |
1030820 | 1030820 | 2021-02-15 | Houston | Alabama | 1069 | 9919 | 247 |
1027573 | 1027573 | 2021-02-14 | Houston | Alabama | 1069 | 9892 | 247 |
1024328 | 1024328 | 2021-02-13 | Houston | Alabama | 1069 | 9873 | 247 |
1021083 | 1021083 | 2021-02-12 | Houston | Alabama | 1069 | 9842 | 246 |
1017838 | 1017838 | 2021-02-11 | Houston | Alabama | 1069 | 9821 | 244 |
1014593 | 1014593 | 2021-02-10 | Houston | Alabama | 1069 | 9788 | 242 |
1011348 | 1011348 | 2021-02-09 | Houston | Alabama | 1069 | 9753 | 232 |
1008102 | 1008102 | 2021-02-08 | Houston | Alabama | 1069 | 9740 | 230 |
1004856 | 1004856 | 2021-02-07 | Houston | Alabama | 1069 | 9720 | 230 |
1001610 | 1001610 | 2021-02-06 | Houston | Alabama | 1069 | 9700 | 230 |
998364 | 998364 | 2021-02-05 | Houston | Alabama | 1069 | 9658 | 230 |
995118 | 995118 | 2021-02-04 | Houston | Alabama | 1069 | 9625 | 227 |
991872 | 991872 | 2021-02-03 | Houston | Alabama | 1069 | 9578 | 220 |
988626 | 988626 | 2021-02-02 | Houston | Alabama | 1069 | 9536 | 210 |
985379 | 985379 | 2021-02-01 | Houston | Alabama | 1069 | 9499 | 209 |
982132 | 982132 | 2021-01-31 | Houston | Alabama | 1069 | 9471 | 209 |
978886 | 978886 | 2021-01-30 | Houston | Alabama | 1069 | 9369 | 200 |
975641 | 975641 | 2021-01-29 | Houston | Alabama | 1069 | 9369 | 200 |
972396 | 972396 | 2021-01-28 | Houston | Alabama | 1069 | 9301 | 190 |
969151 | 969151 | 2021-01-27 | Houston | Alabama | 1069 | 9221 | 182 |
965907 | 965907 | 2021-01-26 | Houston | Alabama | 1069 | 9097 | 168 |
962662 | 962662 | 2021-01-25 | Houston | Alabama | 1069 | 9031 | 164 |
959417 | 959417 | 2021-01-24 | Houston | Alabama | 1069 | 9009 | 164 |
956171 | 956171 | 2021-01-23 | Houston | Alabama | 1069 | 8988 | 164 |
952926 | 952926 | 2021-01-22 | Houston | Alabama | 1069 | 8886 | 158 |
949681 | 949681 | 2021-01-21 | Houston | Alabama | 1069 | 8813 | 156 |
946435 | 946435 | 2021-01-20 | Houston | Alabama | 1069 | 8746 | 156 |
943188 | 943188 | 2021-01-19 | Houston | Alabama | 1069 | 8681 | 148 |
939943 | 939943 | 2021-01-18 | Houston | Alabama | 1069 | 8630 | 148 |
936698 | 936698 | 2021-01-17 | Houston | Alabama | 1069 | 8598 | 148 |
933453 | 933453 | 2021-01-16 | Houston | Alabama | 1069 | 8556 | 148 |
930208 | 930208 | 2021-01-15 | Houston | Alabama | 1069 | 8474 | 129 |
926963 | 926963 | 2021-01-14 | Houston | Alabama | 1069 | 8405 | 123 |
923717 | 923717 | 2021-01-13 | Houston | Alabama | 1069 | 8348 | 111 |
920472 | 920472 | 2021-01-12 | Houston | Alabama | 1069 | 8266 | 83 |
917227 | 917227 | 2021-01-11 | Houston | Alabama | 1069 | 8203 | 72 |
913982 | 913982 | 2021-01-10 | Houston | Alabama | 1069 | 8167 | 72 |
910737 | 910737 | 2021-01-09 | Houston | Alabama | 1069 | 8112 | 72 |
907492 | 907492 | 2021-01-08 | Houston | Alabama | 1069 | 8013 | 72 |
904246 | 904246 | 2021-01-07 | Houston | Alabama | 1069 | 7906 | 70 |
901001 | 901001 | 2021-01-06 | Houston | Alabama | 1069 | 7801 | 70 |
897756 | 897756 | 2021-01-05 | Houston | Alabama | 1069 | 7698 | 64 |
894510 | 894510 | 2021-01-04 | Houston | Alabama | 1069 | 7584 | 64 |
891264 | 891264 | 2021-01-03 | Houston | Alabama | 1069 | 7525 | 64 |
888017 | 888017 | 2021-01-02 | Houston | Alabama | 1069 | 7454 | 64 |
884772 | 884772 | 2021-01-01 | Houston | Alabama | 1069 | 7371 | 64 |
881527 | 881527 | 2020-12-31 | Houston | Alabama | 1069 | 7279 | 64 |
878282 | 878282 | 2020-12-30 | Houston | Alabama | 1069 | 7157 | 63 |
875037 | 875037 | 2020-12-29 | Houston | Alabama | 1069 | 7035 | 63 |
871792 | 871792 | 2020-12-28 | Houston | Alabama | 1069 | 6949 | 63 |
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);