ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where deaths = 134 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499629 | 2499629 | 2022-05-13 | Pike | Alabama | 1109 | 7590 | 134 |
2496371 | 2496371 | 2022-05-12 | Pike | Alabama | 1109 | 7587 | 134 |
2493113 | 2493113 | 2022-05-11 | Pike | Alabama | 1109 | 7583 | 134 |
2489855 | 2489855 | 2022-05-10 | Pike | Alabama | 1109 | 7582 | 134 |
2486598 | 2486598 | 2022-05-09 | Pike | Alabama | 1109 | 7580 | 134 |
2483340 | 2483340 | 2022-05-08 | Pike | Alabama | 1109 | 7580 | 134 |
2480082 | 2480082 | 2022-05-07 | Pike | Alabama | 1109 | 7580 | 134 |
2476824 | 2476824 | 2022-05-06 | Pike | Alabama | 1109 | 7580 | 134 |
2473566 | 2473566 | 2022-05-05 | Pike | Alabama | 1109 | 7580 | 134 |
2470309 | 2470309 | 2022-05-04 | Pike | Alabama | 1109 | 7580 | 134 |
2467053 | 2467053 | 2022-05-03 | Pike | Alabama | 1109 | 7579 | 134 |
2463798 | 2463798 | 2022-05-02 | Pike | Alabama | 1109 | 7579 | 134 |
2460542 | 2460542 | 2022-05-01 | Pike | Alabama | 1109 | 7576 | 134 |
2457286 | 2457286 | 2022-04-30 | Pike | Alabama | 1109 | 7576 | 134 |
2454030 | 2454030 | 2022-04-29 | Pike | Alabama | 1109 | 7576 | 134 |
2450774 | 2450774 | 2022-04-28 | Pike | Alabama | 1109 | 7566 | 134 |
2447518 | 2447518 | 2022-04-27 | Pike | Alabama | 1109 | 7561 | 134 |
2444262 | 2444262 | 2022-04-26 | Pike | Alabama | 1109 | 7556 | 134 |
2441006 | 2441006 | 2022-04-25 | Pike | Alabama | 1109 | 7550 | 134 |
2437750 | 2437750 | 2022-04-24 | Pike | Alabama | 1109 | 7529 | 134 |
2434494 | 2434494 | 2022-04-23 | Pike | Alabama | 1109 | 7529 | 134 |
2431238 | 2431238 | 2022-04-22 | Pike | Alabama | 1109 | 7529 | 134 |
2427982 | 2427982 | 2022-04-21 | Pike | Alabama | 1109 | 7523 | 134 |
2424726 | 2424726 | 2022-04-20 | Pike | Alabama | 1109 | 7505 | 134 |
2421470 | 2421470 | 2022-04-19 | Pike | Alabama | 1109 | 7495 | 134 |
2418214 | 2418214 | 2022-04-18 | Pike | Alabama | 1109 | 7472 | 134 |
2414958 | 2414958 | 2022-04-17 | Pike | Alabama | 1109 | 7472 | 134 |
2411702 | 2411702 | 2022-04-16 | Pike | Alabama | 1109 | 7472 | 134 |
2408446 | 2408446 | 2022-04-15 | Pike | Alabama | 1109 | 7472 | 134 |
2405190 | 2405190 | 2022-04-14 | Pike | Alabama | 1109 | 7465 | 134 |
2401935 | 2401935 | 2022-04-13 | Pike | Alabama | 1109 | 7465 | 134 |
2157969 | 2157969 | 2022-01-28 | Marion | Alabama | 1093 | 7124 | 134 |
2154716 | 2154716 | 2022-01-27 | Marion | Alabama | 1093 | 7124 | 134 |
2151463 | 2151463 | 2022-01-26 | Marion | Alabama | 1093 | 7124 | 134 |
2148211 | 2148211 | 2022-01-25 | Marion | Alabama | 1093 | 7124 | 134 |
2144959 | 2144959 | 2022-01-24 | Marion | Alabama | 1093 | 7124 | 134 |
2141704 | 2141704 | 2022-01-23 | Marion | Alabama | 1093 | 7101 | 134 |
2138448 | 2138448 | 2022-01-22 | Marion | Alabama | 1093 | 7034 | 134 |
2135193 | 2135193 | 2022-01-21 | Marion | Alabama | 1093 | 6872 | 134 |
2131941 | 2131941 | 2022-01-20 | Marion | Alabama | 1093 | 6757 | 134 |
2128687 | 2128687 | 2022-01-19 | Marion | Alabama | 1093 | 6615 | 134 |
2125434 | 2125434 | 2022-01-18 | Marion | Alabama | 1093 | 6420 | 134 |
2122182 | 2122182 | 2022-01-17 | Marion | Alabama | 1093 | 6359 | 134 |
2118930 | 2118930 | 2022-01-16 | Marion | Alabama | 1093 | 6324 | 134 |
2040902 | 2040902 | 2021-12-23 | Lawrence | Alabama | 1079 | 4934 | 134 |
2037652 | 2037652 | 2021-12-22 | Lawrence | Alabama | 1079 | 4930 | 134 |
1936875 | 1936875 | 2021-11-21 | Geneva | Alabama | 1061 | 4632 | 134 |
1933625 | 1933625 | 2021-11-20 | Geneva | Alabama | 1061 | 4631 | 134 |
1930373 | 1930373 | 2021-11-19 | Geneva | Alabama | 1061 | 4623 | 134 |
1927123 | 1927123 | 2021-11-18 | Geneva | Alabama | 1061 | 4621 | 134 |
1923873 | 1923873 | 2021-11-17 | Geneva | Alabama | 1061 | 4622 | 134 |
1920624 | 1920624 | 2021-11-16 | Geneva | Alabama | 1061 | 4621 | 134 |
1855631 | 1855631 | 2021-10-27 | Escambia | Alabama | 1053 | 6832 | 134 |
1852382 | 1852382 | 2021-10-26 | Escambia | Alabama | 1053 | 6782 | 134 |
1849132 | 1849132 | 2021-10-25 | Escambia | Alabama | 1053 | 6778 | 134 |
1845882 | 1845882 | 2021-10-24 | Escambia | Alabama | 1053 | 6775 | 134 |
1842632 | 1842632 | 2021-10-23 | Escambia | Alabama | 1053 | 6772 | 134 |
1758138 | 1758138 | 2021-09-27 | Chambers | Alabama | 1017 | 5425 | 134 |
1754890 | 1754890 | 2021-09-26 | Chambers | Alabama | 1017 | 5416 | 134 |
1751642 | 1751642 | 2021-09-25 | Chambers | Alabama | 1017 | 5398 | 134 |
1316517 | 1316517 | 2021-05-14 | Colbert | Alabama | 1033 | 6317 | 134 |
1313271 | 1313271 | 2021-05-13 | Colbert | Alabama | 1033 | 6310 | 134 |
1310024 | 1310024 | 2021-05-12 | Colbert | Alabama | 1033 | 6307 | 134 |
1306778 | 1306778 | 2021-05-11 | Colbert | Alabama | 1033 | 6306 | 134 |
1303532 | 1303532 | 2021-05-10 | Colbert | Alabama | 1033 | 6301 | 134 |
1300285 | 1300285 | 2021-05-09 | Colbert | Alabama | 1033 | 6298 | 134 |
1297038 | 1297038 | 2021-05-08 | Colbert | Alabama | 1033 | 6296 | 134 |
1293792 | 1293792 | 2021-05-07 | Colbert | Alabama | 1033 | 6292 | 134 |
1290546 | 1290546 | 2021-05-06 | Colbert | Alabama | 1033 | 6291 | 134 |
1287300 | 1287300 | 2021-05-05 | Colbert | Alabama | 1033 | 6288 | 134 |
1284054 | 1284054 | 2021-05-04 | Colbert | Alabama | 1033 | 6282 | 134 |
1280807 | 1280807 | 2021-05-03 | Colbert | Alabama | 1033 | 6282 | 134 |
1277560 | 1277560 | 2021-05-02 | Colbert | Alabama | 1033 | 6279 | 134 |
1274313 | 1274313 | 2021-05-01 | Colbert | Alabama | 1033 | 6279 | 134 |
1271066 | 1271066 | 2021-04-30 | Colbert | Alabama | 1033 | 6278 | 134 |
1267819 | 1267819 | 2021-04-29 | Colbert | Alabama | 1033 | 6274 | 134 |
1264560 | 1264560 | 2021-04-28 | Blount | Alabama | 1009 | 6595 | 134 |
1264572 | 1264572 | 2021-04-28 | Colbert | Alabama | 1033 | 6271 | 134 |
1261313 | 1261313 | 2021-04-27 | Blount | Alabama | 1009 | 6581 | 134 |
1261325 | 1261325 | 2021-04-27 | Colbert | Alabama | 1033 | 6273 | 134 |
1258066 | 1258066 | 2021-04-26 | Blount | Alabama | 1009 | 6574 | 134 |
1258078 | 1258078 | 2021-04-26 | Colbert | Alabama | 1033 | 6258 | 134 |
1254819 | 1254819 | 2021-04-25 | Blount | Alabama | 1009 | 6571 | 134 |
1254831 | 1254831 | 2021-04-25 | Colbert | Alabama | 1033 | 6252 | 134 |
1251572 | 1251572 | 2021-04-24 | Blount | Alabama | 1009 | 6570 | 134 |
1251584 | 1251584 | 2021-04-24 | Colbert | Alabama | 1033 | 6250 | 134 |
1248325 | 1248325 | 2021-04-23 | Blount | Alabama | 1009 | 6570 | 134 |
1225593 | 1225593 | 2021-04-16 | Blount | Alabama | 1009 | 6519 | 134 |
1222346 | 1222346 | 2021-04-15 | Blount | Alabama | 1009 | 6511 | 134 |
1202858 | 1202858 | 2021-04-09 | Blount | Alabama | 1009 | 6475 | 134 |
1199610 | 1199610 | 2021-04-08 | Blount | Alabama | 1009 | 6472 | 134 |
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 |
1040545 | 1040545 | 2021-02-18 | Dallas | Alabama | 1047 | 3328 | 134 |
1034093 | 1034093 | 2021-02-16 | Tallapoosa | Alabama | 1123 | 3446 | 134 |
1030847 | 1030847 | 2021-02-15 | Tallapoosa | Alabama | 1123 | 3428 | 134 |
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);