ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
221 rows where deaths = 78 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2301070 | 2301070 | 2022-03-13 | Monroe | Alabama | 1099 | 5261 | 78 |
2297818 | 2297818 | 2022-03-12 | Monroe | Alabama | 1099 | 5261 | 78 |
2294566 | 2294566 | 2022-03-11 | Monroe | Alabama | 1099 | 5261 | 78 |
2291278 | 2291278 | 2022-03-10 | Clay | Alabama | 1027 | 4084 | 78 |
2291308 | 2291308 | 2022-03-10 | Macon | Alabama | 1087 | 3841 | 78 |
2291314 | 2291314 | 2022-03-10 | Monroe | Alabama | 1099 | 5261 | 78 |
2288026 | 2288026 | 2022-03-09 | Clay | Alabama | 1027 | 4082 | 78 |
2288056 | 2288056 | 2022-03-09 | Macon | Alabama | 1087 | 3840 | 78 |
2288062 | 2288062 | 2022-03-09 | Monroe | Alabama | 1099 | 5261 | 78 |
2284774 | 2284774 | 2022-03-08 | Clay | Alabama | 1027 | 4080 | 78 |
2284804 | 2284804 | 2022-03-08 | Macon | Alabama | 1087 | 3840 | 78 |
2284810 | 2284810 | 2022-03-08 | Monroe | Alabama | 1099 | 5259 | 78 |
2281522 | 2281522 | 2022-03-07 | Clay | Alabama | 1027 | 4078 | 78 |
2281558 | 2281558 | 2022-03-07 | Monroe | Alabama | 1099 | 5258 | 78 |
2278269 | 2278269 | 2022-03-06 | Clay | Alabama | 1027 | 4078 | 78 |
2278305 | 2278305 | 2022-03-06 | Monroe | Alabama | 1099 | 5256 | 78 |
2275016 | 2275016 | 2022-03-05 | Clay | Alabama | 1027 | 4078 | 78 |
2275052 | 2275052 | 2022-03-05 | Monroe | Alabama | 1099 | 5256 | 78 |
2271763 | 2271763 | 2022-03-04 | Clay | Alabama | 1027 | 4078 | 78 |
2271799 | 2271799 | 2022-03-04 | Monroe | Alabama | 1099 | 5256 | 78 |
2268511 | 2268511 | 2022-03-03 | Clay | Alabama | 1027 | 4077 | 78 |
2262004 | 2262004 | 2022-03-01 | Cherokee | Alabama | 1019 | 5086 | 78 |
2258753 | 2258753 | 2022-02-28 | Cherokee | Alabama | 1019 | 5074 | 78 |
2255502 | 2255502 | 2022-02-27 | Cherokee | Alabama | 1019 | 5074 | 78 |
2252251 | 2252251 | 2022-02-26 | Cherokee | Alabama | 1019 | 5073 | 78 |
2249000 | 2249000 | 2022-02-25 | Cherokee | Alabama | 1019 | 5071 | 78 |
2249047 | 2249047 | 2022-02-25 | Russell | Alabama | 1113 | 9978 | 78 |
2245796 | 2245796 | 2022-02-24 | Russell | Alabama | 1113 | 9973 | 78 |
2242545 | 2242545 | 2022-02-23 | Russell | Alabama | 1113 | 9969 | 78 |
2239294 | 2239294 | 2022-02-22 | Russell | Alabama | 1113 | 9959 | 78 |
2236043 | 2236043 | 2022-02-21 | Russell | Alabama | 1113 | 9954 | 78 |
2232792 | 2232792 | 2022-02-20 | Russell | Alabama | 1113 | 9952 | 78 |
2229541 | 2229541 | 2022-02-19 | Russell | Alabama | 1113 | 9949 | 78 |
2226290 | 2226290 | 2022-02-18 | Russell | Alabama | 1113 | 9941 | 78 |
1995374 | 1995374 | 2021-12-09 | Crenshaw | Alabama | 1041 | 2626 | 78 |
1992123 | 1992123 | 2021-12-08 | Crenshaw | Alabama | 1041 | 2624 | 78 |
1988872 | 1988872 | 2021-12-07 | Crenshaw | Alabama | 1041 | 2622 | 78 |
1985622 | 1985622 | 2021-12-06 | Crenshaw | Alabama | 1041 | 2618 | 78 |
1982372 | 1982372 | 2021-12-05 | Crenshaw | Alabama | 1041 | 2617 | 78 |
1979122 | 1979122 | 2021-12-04 | Crenshaw | Alabama | 1041 | 2616 | 78 |
1975872 | 1975872 | 2021-12-03 | Crenshaw | Alabama | 1041 | 2616 | 78 |
1810170 | 1810170 | 2021-10-13 | Pickens | Alabama | 1107 | 3129 | 78 |
1806896 | 1806896 | 2021-10-12 | Fayette | Alabama | 1057 | 2877 | 78 |
1803645 | 1803645 | 2021-10-11 | Fayette | Alabama | 1057 | 2877 | 78 |
1800396 | 1800396 | 2021-10-10 | Fayette | Alabama | 1057 | 2873 | 78 |
1797147 | 1797147 | 2021-10-09 | Fayette | Alabama | 1057 | 2862 | 78 |
1748397 | 1748397 | 2021-09-24 | Clarke | Alabama | 1025 | 4598 | 78 |
1722434 | 1722434 | 2021-09-16 | Marengo | Alabama | 1091 | 3188 | 78 |
1719147 | 1719147 | 2021-09-15 | Butler | Alabama | 1013 | 3058 | 78 |
1719186 | 1719186 | 2021-09-15 | Marengo | Alabama | 1091 | 3177 | 78 |
1715899 | 1715899 | 2021-09-14 | Butler | Alabama | 1013 | 3037 | 78 |
1579490 | 1579490 | 2021-08-03 | Hale | Alabama | 1065 | 2367 | 78 |
1576242 | 1576242 | 2021-08-02 | Hale | Alabama | 1065 | 2359 | 78 |
1572994 | 1572994 | 2021-08-01 | Hale | Alabama | 1065 | 2355 | 78 |
1569746 | 1569746 | 2021-07-31 | Hale | Alabama | 1065 | 2351 | 78 |
1566498 | 1566498 | 2021-07-30 | Hale | Alabama | 1065 | 2340 | 78 |
1563250 | 1563250 | 2021-07-29 | Hale | Alabama | 1065 | 2340 | 78 |
1560002 | 1560002 | 2021-07-28 | Hale | Alabama | 1065 | 2327 | 78 |
1556755 | 1556755 | 2021-07-27 | Hale | Alabama | 1065 | 2323 | 78 |
1553508 | 1553508 | 2021-07-26 | Hale | Alabama | 1065 | 2320 | 78 |
1550261 | 1550261 | 2021-07-25 | Hale | Alabama | 1065 | 2318 | 78 |
1547014 | 1547014 | 2021-07-24 | Hale | Alabama | 1065 | 2316 | 78 |
1543767 | 1543767 | 2021-07-23 | Hale | Alabama | 1065 | 2312 | 78 |
1540519 | 1540519 | 2021-07-22 | Hale | Alabama | 1065 | 2305 | 78 |
1537272 | 1537272 | 2021-07-21 | Hale | Alabama | 1065 | 2302 | 78 |
1534024 | 1534024 | 2021-07-20 | Hale | Alabama | 1065 | 2300 | 78 |
1530777 | 1530777 | 2021-07-19 | Hale | Alabama | 1065 | 2298 | 78 |
1530799 | 1530799 | 2021-07-19 | Pike | Alabama | 1109 | 3210 | 78 |
1527530 | 1527530 | 2021-07-18 | Hale | Alabama | 1065 | 2295 | 78 |
1527552 | 1527552 | 2021-07-18 | Pike | Alabama | 1109 | 3208 | 78 |
1524283 | 1524283 | 2021-07-17 | Hale | Alabama | 1065 | 2295 | 78 |
1524305 | 1524305 | 2021-07-17 | Pike | Alabama | 1109 | 3205 | 78 |
1521035 | 1521035 | 2021-07-16 | Hale | Alabama | 1065 | 2292 | 78 |
1521057 | 1521057 | 2021-07-16 | Pike | Alabama | 1109 | 3200 | 78 |
1517787 | 1517787 | 2021-07-15 | Hale | Alabama | 1065 | 2292 | 78 |
1517809 | 1517809 | 2021-07-15 | Pike | Alabama | 1109 | 3194 | 78 |
1514540 | 1514540 | 2021-07-14 | Hale | Alabama | 1065 | 2291 | 78 |
1514562 | 1514562 | 2021-07-14 | Pike | Alabama | 1109 | 3186 | 78 |
1511316 | 1511316 | 2021-07-13 | Pike | Alabama | 1109 | 3177 | 78 |
1508069 | 1508069 | 2021-07-12 | Pike | Alabama | 1109 | 3177 | 78 |
1504823 | 1504823 | 2021-07-11 | Pike | Alabama | 1109 | 3173 | 78 |
1501577 | 1501577 | 2021-07-10 | Pike | Alabama | 1109 | 3173 | 78 |
1498331 | 1498331 | 2021-07-09 | Pike | Alabama | 1109 | 3169 | 78 |
1495084 | 1495084 | 2021-07-08 | Pike | Alabama | 1109 | 3159 | 78 |
1491837 | 1491837 | 2021-07-07 | Pike | Alabama | 1109 | 3159 | 78 |
1488590 | 1488590 | 2021-07-06 | Pike | Alabama | 1109 | 3151 | 78 |
1485343 | 1485343 | 2021-07-05 | Pike | Alabama | 1109 | 3151 | 78 |
1482097 | 1482097 | 2021-07-04 | Pike | Alabama | 1109 | 3151 | 78 |
1478850 | 1478850 | 2021-07-03 | Pike | Alabama | 1109 | 3151 | 78 |
1475604 | 1475604 | 2021-07-02 | Pike | Alabama | 1109 | 3151 | 78 |
1472336 | 1472336 | 2021-07-01 | Hale | Alabama | 1065 | 2274 | 78 |
1472358 | 1472358 | 2021-07-01 | Pike | Alabama | 1109 | 3150 | 78 |
1469091 | 1469091 | 2021-06-30 | Hale | Alabama | 1065 | 2274 | 78 |
1469113 | 1469113 | 2021-06-30 | Pike | Alabama | 1109 | 3150 | 78 |
1465846 | 1465846 | 2021-06-29 | Hale | Alabama | 1065 | 2272 | 78 |
1465868 | 1465868 | 2021-06-29 | Pike | Alabama | 1109 | 3150 | 78 |
1462601 | 1462601 | 2021-06-28 | Hale | Alabama | 1065 | 2272 | 78 |
1462623 | 1462623 | 2021-06-28 | Pike | Alabama | 1109 | 3150 | 78 |
1459356 | 1459356 | 2021-06-27 | Hale | Alabama | 1065 | 2272 | 78 |
1459378 | 1459378 | 2021-06-27 | Pike | Alabama | 1109 | 3148 | 78 |
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);