ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 1077 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277582 | 1277582 | 2021-05-02 | Lauderdale | Alabama | 1077 | 9393 | 238 |
1274335 | 1274335 | 2021-05-01 | Lauderdale | Alabama | 1077 | 9386 | 238 |
1271088 | 1271088 | 2021-04-30 | Lauderdale | Alabama | 1077 | 9376 | 237 |
1267841 | 1267841 | 2021-04-29 | Lauderdale | Alabama | 1077 | 9367 | 236 |
1264594 | 1264594 | 2021-04-28 | Lauderdale | Alabama | 1077 | 9358 | 236 |
1261347 | 1261347 | 2021-04-27 | Lauderdale | Alabama | 1077 | 9350 | 236 |
1258100 | 1258100 | 2021-04-26 | Lauderdale | Alabama | 1077 | 9337 | 236 |
1254853 | 1254853 | 2021-04-25 | Lauderdale | Alabama | 1077 | 9322 | 236 |
1251606 | 1251606 | 2021-04-24 | Lauderdale | Alabama | 1077 | 9317 | 236 |
1248359 | 1248359 | 2021-04-23 | Lauderdale | Alabama | 1077 | 9310 | 236 |
1245112 | 1245112 | 2021-04-22 | Lauderdale | Alabama | 1077 | 9301 | 235 |
1241865 | 1241865 | 2021-04-21 | Lauderdale | Alabama | 1077 | 9293 | 234 |
1238618 | 1238618 | 2021-04-20 | Lauderdale | Alabama | 1077 | 9286 | 233 |
1235371 | 1235371 | 2021-04-19 | Lauderdale | Alabama | 1077 | 9280 | 233 |
1232123 | 1232123 | 2021-04-18 | Lauderdale | Alabama | 1077 | 9276 | 233 |
1228875 | 1228875 | 2021-04-17 | Lauderdale | Alabama | 1077 | 9271 | 233 |
1225627 | 1225627 | 2021-04-16 | Lauderdale | Alabama | 1077 | 9265 | 228 |
1222380 | 1222380 | 2021-04-15 | Lauderdale | Alabama | 1077 | 9254 | 228 |
1219132 | 1219132 | 2021-04-14 | Lauderdale | Alabama | 1077 | 9247 | 227 |
1215884 | 1215884 | 2021-04-13 | Lauderdale | Alabama | 1077 | 9223 | 227 |
1212637 | 1212637 | 2021-04-12 | Lauderdale | Alabama | 1077 | 9218 | 227 |
1209388 | 1209388 | 2021-04-11 | Lauderdale | Alabama | 1077 | 9215 | 227 |
1206140 | 1206140 | 2021-04-10 | Lauderdale | Alabama | 1077 | 9208 | 227 |
1202892 | 1202892 | 2021-04-09 | Lauderdale | Alabama | 1077 | 9196 | 227 |
1199644 | 1199644 | 2021-04-08 | Lauderdale | Alabama | 1077 | 9188 | 227 |
1196395 | 1196395 | 2021-04-07 | Lauderdale | Alabama | 1077 | 9178 | 227 |
1193147 | 1193147 | 2021-04-06 | Lauderdale | Alabama | 1077 | 9165 | 227 |
1189897 | 1189897 | 2021-04-05 | Lauderdale | Alabama | 1077 | 9162 | 227 |
1186650 | 1186650 | 2021-04-04 | Lauderdale | Alabama | 1077 | 9159 | 227 |
1183403 | 1183403 | 2021-04-03 | Lauderdale | Alabama | 1077 | 9156 | 227 |
1180156 | 1180156 | 2021-04-02 | Lauderdale | Alabama | 1077 | 9148 | 223 |
1176909 | 1176909 | 2021-04-01 | Lauderdale | Alabama | 1077 | 9144 | 219 |
1173662 | 1173662 | 2021-03-31 | Lauderdale | Alabama | 1077 | 9140 | 219 |
1170415 | 1170415 | 2021-03-30 | Lauderdale | Alabama | 1077 | 9116 | 218 |
1167167 | 1167167 | 2021-03-29 | Lauderdale | Alabama | 1077 | 9102 | 218 |
1163919 | 1163919 | 2021-03-28 | Lauderdale | Alabama | 1077 | 9100 | 218 |
1160671 | 1160671 | 2021-03-27 | Lauderdale | Alabama | 1077 | 9089 | 218 |
1157423 | 1157423 | 2021-03-26 | Lauderdale | Alabama | 1077 | 9076 | 218 |
1154176 | 1154176 | 2021-03-25 | Lauderdale | Alabama | 1077 | 9070 | 218 |
1150929 | 1150929 | 2021-03-24 | Lauderdale | Alabama | 1077 | 9065 | 217 |
1147682 | 1147682 | 2021-03-23 | Lauderdale | Alabama | 1077 | 9034 | 217 |
1144435 | 1144435 | 2021-03-22 | Lauderdale | Alabama | 1077 | 9034 | 217 |
1141188 | 1141188 | 2021-03-21 | Lauderdale | Alabama | 1077 | 9024 | 217 |
1137942 | 1137942 | 2021-03-20 | Lauderdale | Alabama | 1077 | 9019 | 217 |
1134696 | 1134696 | 2021-03-19 | Lauderdale | Alabama | 1077 | 9007 | 217 |
1131448 | 1131448 | 2021-03-18 | Lauderdale | Alabama | 1077 | 9000 | 216 |
1128201 | 1128201 | 2021-03-17 | Lauderdale | Alabama | 1077 | 8993 | 216 |
1124955 | 1124955 | 2021-03-16 | Lauderdale | Alabama | 1077 | 8973 | 216 |
1121709 | 1121709 | 2021-03-15 | Lauderdale | Alabama | 1077 | 8962 | 216 |
1118462 | 1118462 | 2021-03-14 | Lauderdale | Alabama | 1077 | 8692 | 216 |
1115215 | 1115215 | 2021-03-13 | Lauderdale | Alabama | 1077 | 8683 | 216 |
1111969 | 1111969 | 2021-03-12 | Lauderdale | Alabama | 1077 | 8670 | 215 |
1108723 | 1108723 | 2021-03-11 | Lauderdale | Alabama | 1077 | 8662 | 214 |
1105477 | 1105477 | 2021-03-10 | Lauderdale | Alabama | 1077 | 8651 | 215 |
1102231 | 1102231 | 2021-03-09 | Lauderdale | Alabama | 1077 | 8636 | 214 |
1098985 | 1098985 | 2021-03-08 | Lauderdale | Alabama | 1077 | 8631 | 214 |
1095737 | 1095737 | 2021-03-07 | Lauderdale | Alabama | 1077 | 8630 | 214 |
1092491 | 1092491 | 2021-03-06 | Lauderdale | Alabama | 1077 | 8628 | 214 |
1089245 | 1089245 | 2021-03-05 | Lauderdale | Alabama | 1077 | 8618 | 214 |
1086000 | 1086000 | 2021-03-04 | Lauderdale | Alabama | 1077 | 8612 | 214 |
1082754 | 1082754 | 2021-03-03 | Lauderdale | Alabama | 1077 | 8610 | 212 |
1079508 | 1079508 | 2021-03-02 | Lauderdale | Alabama | 1077 | 8601 | 212 |
1076263 | 1076263 | 2021-03-01 | Lauderdale | Alabama | 1077 | 8607 | 211 |
1073017 | 1073017 | 2021-02-28 | Lauderdale | Alabama | 1077 | 8603 | 211 |
1069771 | 1069771 | 2021-02-27 | Lauderdale | Alabama | 1077 | 8594 | 211 |
1066526 | 1066526 | 2021-02-26 | Lauderdale | Alabama | 1077 | 8588 | 210 |
1063281 | 1063281 | 2021-02-25 | Lauderdale | Alabama | 1077 | 8581 | 210 |
1060036 | 1060036 | 2021-02-24 | Lauderdale | Alabama | 1077 | 8570 | 210 |
1056790 | 1056790 | 2021-02-23 | Lauderdale | Alabama | 1077 | 8541 | 209 |
1053544 | 1053544 | 2021-02-22 | Lauderdale | Alabama | 1077 | 8525 | 208 |
1050297 | 1050297 | 2021-02-21 | Lauderdale | Alabama | 1077 | 8523 | 208 |
1047050 | 1047050 | 2021-02-20 | Lauderdale | Alabama | 1077 | 8515 | 208 |
1043805 | 1043805 | 2021-02-19 | Lauderdale | Alabama | 1077 | 8513 | 207 |
1040560 | 1040560 | 2021-02-18 | Lauderdale | Alabama | 1077 | 8508 | 205 |
1037315 | 1037315 | 2021-02-17 | Lauderdale | Alabama | 1077 | 8480 | 205 |
1034070 | 1034070 | 2021-02-16 | Lauderdale | Alabama | 1077 | 8479 | 201 |
1030824 | 1030824 | 2021-02-15 | Lauderdale | Alabama | 1077 | 8476 | 201 |
1027577 | 1027577 | 2021-02-14 | Lauderdale | Alabama | 1077 | 8471 | 201 |
1024332 | 1024332 | 2021-02-13 | Lauderdale | Alabama | 1077 | 8460 | 201 |
1021087 | 1021087 | 2021-02-12 | Lauderdale | Alabama | 1077 | 8442 | 201 |
1017842 | 1017842 | 2021-02-11 | Lauderdale | Alabama | 1077 | 8432 | 196 |
1014597 | 1014597 | 2021-02-10 | Lauderdale | Alabama | 1077 | 8411 | 193 |
1011352 | 1011352 | 2021-02-09 | Lauderdale | Alabama | 1077 | 8399 | 182 |
1008106 | 1008106 | 2021-02-08 | Lauderdale | Alabama | 1077 | 8380 | 179 |
1004860 | 1004860 | 2021-02-07 | Lauderdale | Alabama | 1077 | 8366 | 179 |
1001614 | 1001614 | 2021-02-06 | Lauderdale | Alabama | 1077 | 8350 | 179 |
998368 | 998368 | 2021-02-05 | Lauderdale | Alabama | 1077 | 8332 | 179 |
995122 | 995122 | 2021-02-04 | Lauderdale | Alabama | 1077 | 8298 | 176 |
991876 | 991876 | 2021-02-03 | Lauderdale | Alabama | 1077 | 8255 | 174 |
988630 | 988630 | 2021-02-02 | Lauderdale | Alabama | 1077 | 8216 | 160 |
985383 | 985383 | 2021-02-01 | Lauderdale | Alabama | 1077 | 8191 | 156 |
982136 | 982136 | 2021-01-31 | Lauderdale | Alabama | 1077 | 8180 | 156 |
978890 | 978890 | 2021-01-30 | Lauderdale | Alabama | 1077 | 8134 | 151 |
975645 | 975645 | 2021-01-29 | Lauderdale | Alabama | 1077 | 8134 | 151 |
972400 | 972400 | 2021-01-28 | Lauderdale | Alabama | 1077 | 8088 | 127 |
969155 | 969155 | 2021-01-27 | Lauderdale | Alabama | 1077 | 8049 | 121 |
965911 | 965911 | 2021-01-26 | Lauderdale | Alabama | 1077 | 7986 | 112 |
962666 | 962666 | 2021-01-25 | Lauderdale | Alabama | 1077 | 7946 | 107 |
959421 | 959421 | 2021-01-24 | Lauderdale | Alabama | 1077 | 7871 | 107 |
956175 | 956175 | 2021-01-23 | Lauderdale | Alabama | 1077 | 7847 | 107 |
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);