ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
184 rows where deaths = 70 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499592 | 2499592 | 2022-05-13 | Conecuh | Alabama | 1035 | 2869 | 70 |
2496334 | 2496334 | 2022-05-12 | Conecuh | Alabama | 1035 | 2869 | 70 |
2493076 | 2493076 | 2022-05-11 | Conecuh | Alabama | 1035 | 2868 | 70 |
2489818 | 2489818 | 2022-05-10 | Conecuh | Alabama | 1035 | 2868 | 70 |
2486561 | 2486561 | 2022-05-09 | Conecuh | Alabama | 1035 | 2868 | 70 |
2483303 | 2483303 | 2022-05-08 | Conecuh | Alabama | 1035 | 2868 | 70 |
2480045 | 2480045 | 2022-05-07 | Conecuh | Alabama | 1035 | 2868 | 70 |
2476787 | 2476787 | 2022-05-06 | Conecuh | Alabama | 1035 | 2868 | 70 |
2473529 | 2473529 | 2022-05-05 | Conecuh | Alabama | 1035 | 2868 | 70 |
2470272 | 2470272 | 2022-05-04 | Conecuh | Alabama | 1035 | 2868 | 70 |
2467016 | 2467016 | 2022-05-03 | Conecuh | Alabama | 1035 | 2861 | 70 |
2463761 | 2463761 | 2022-05-02 | Conecuh | Alabama | 1035 | 2861 | 70 |
2460505 | 2460505 | 2022-05-01 | Conecuh | Alabama | 1035 | 2861 | 70 |
2457249 | 2457249 | 2022-04-30 | Conecuh | Alabama | 1035 | 2861 | 70 |
2453993 | 2453993 | 2022-04-29 | Conecuh | Alabama | 1035 | 2861 | 70 |
2450737 | 2450737 | 2022-04-28 | Conecuh | Alabama | 1035 | 2861 | 70 |
2281542 | 2281542 | 2022-03-07 | Henry | Alabama | 1067 | 4446 | 70 |
2278289 | 2278289 | 2022-03-06 | Henry | Alabama | 1067 | 4445 | 70 |
2275036 | 2275036 | 2022-03-05 | Henry | Alabama | 1067 | 4445 | 70 |
2271783 | 2271783 | 2022-03-04 | Henry | Alabama | 1067 | 4445 | 70 |
2268531 | 2268531 | 2022-03-03 | Henry | Alabama | 1067 | 4444 | 70 |
2265278 | 2265278 | 2022-03-02 | Henry | Alabama | 1067 | 4440 | 70 |
2262028 | 2262028 | 2022-03-01 | Henry | Alabama | 1067 | 4439 | 70 |
2242531 | 2242531 | 2022-02-23 | Lowndes | Alabama | 1085 | 2595 | 70 |
2239280 | 2239280 | 2022-02-22 | Lowndes | Alabama | 1085 | 2596 | 70 |
2236029 | 2236029 | 2022-02-21 | Lowndes | Alabama | 1085 | 2596 | 70 |
2232778 | 2232778 | 2022-02-20 | Lowndes | Alabama | 1085 | 2595 | 70 |
2229527 | 2229527 | 2022-02-19 | Lowndes | Alabama | 1085 | 2594 | 70 |
2196973 | 2196973 | 2022-02-09 | Cherokee | Alabama | 1019 | 4969 | 70 |
2193718 | 2193718 | 2022-02-08 | Cherokee | Alabama | 1019 | 4951 | 70 |
2190465 | 2190465 | 2022-02-07 | Cherokee | Alabama | 1019 | 4930 | 70 |
2177496 | 2177496 | 2022-02-03 | Monroe | Alabama | 1099 | 5064 | 70 |
2177502 | 2177502 | 2022-02-03 | Randolph | Alabama | 1111 | 4865 | 70 |
2174243 | 2174243 | 2022-02-02 | Monroe | Alabama | 1099 | 5064 | 70 |
2174249 | 2174249 | 2022-02-02 | Randolph | Alabama | 1111 | 4865 | 70 |
2170991 | 2170991 | 2022-02-01 | Monroe | Alabama | 1099 | 5039 | 70 |
2167732 | 2167732 | 2022-01-31 | Macon | Alabama | 1087 | 3667 | 70 |
2164477 | 2164477 | 2022-01-30 | Macon | Alabama | 1087 | 3652 | 70 |
2161222 | 2161222 | 2022-01-29 | Macon | Alabama | 1087 | 3635 | 70 |
2131908 | 2131908 | 2022-01-20 | Clay | Alabama | 1027 | 3442 | 70 |
2128654 | 2128654 | 2022-01-19 | Clay | Alabama | 1027 | 3358 | 70 |
2125401 | 2125401 | 2022-01-18 | Clay | Alabama | 1027 | 3258 | 70 |
2122149 | 2122149 | 2022-01-17 | Clay | Alabama | 1027 | 3207 | 70 |
2118897 | 2118897 | 2022-01-16 | Clay | Alabama | 1027 | 3193 | 70 |
2115645 | 2115645 | 2022-01-15 | Clay | Alabama | 1027 | 3002 | 70 |
2112393 | 2112393 | 2022-01-14 | Clay | Alabama | 1027 | 3002 | 70 |
2109141 | 2109141 | 2022-01-13 | Clay | Alabama | 1027 | 3002 | 70 |
2105890 | 2105890 | 2022-01-12 | Clay | Alabama | 1027 | 3002 | 70 |
2102639 | 2102639 | 2022-01-11 | Clay | Alabama | 1027 | 2950 | 70 |
2099388 | 2099388 | 2022-01-10 | Clay | Alabama | 1027 | 2910 | 70 |
2096137 | 2096137 | 2022-01-09 | Clay | Alabama | 1027 | 2901 | 70 |
2092885 | 2092885 | 2022-01-08 | Clay | Alabama | 1027 | 2846 | 70 |
1917357 | 1917357 | 2021-11-15 | Clay | Alabama | 1027 | 2497 | 70 |
1914107 | 1914107 | 2021-11-14 | Clay | Alabama | 1027 | 2495 | 70 |
1910857 | 1910857 | 2021-11-13 | Clay | Alabama | 1027 | 2495 | 70 |
1907608 | 1907608 | 2021-11-12 | Clay | Alabama | 1027 | 2488 | 70 |
1904359 | 1904359 | 2021-11-11 | Clay | Alabama | 1027 | 2487 | 70 |
1901109 | 1901109 | 2021-11-10 | Clay | Alabama | 1027 | 2484 | 70 |
1897859 | 1897859 | 2021-11-09 | Clay | Alabama | 1027 | 2484 | 70 |
1894609 | 1894609 | 2021-11-08 | Clay | Alabama | 1027 | 2480 | 70 |
1891359 | 1891359 | 2021-11-07 | Clay | Alabama | 1027 | 2480 | 70 |
1888109 | 1888109 | 2021-11-06 | Clay | Alabama | 1027 | 2479 | 70 |
1764629 | 1764629 | 2021-09-29 | Barbour | Alabama | 1005 | 3483 | 70 |
1761380 | 1761380 | 2021-09-28 | Barbour | Alabama | 1005 | 3481 | 70 |
1758132 | 1758132 | 2021-09-27 | Barbour | Alabama | 1005 | 3474 | 70 |
1758150 | 1758150 | 2021-09-27 | Crenshaw | Alabama | 1041 | 2387 | 70 |
1754884 | 1754884 | 2021-09-26 | Barbour | Alabama | 1005 | 3472 | 70 |
1754902 | 1754902 | 2021-09-26 | Crenshaw | Alabama | 1041 | 2384 | 70 |
1751636 | 1751636 | 2021-09-25 | Barbour | Alabama | 1005 | 3465 | 70 |
1751654 | 1751654 | 2021-09-25 | Crenshaw | Alabama | 1041 | 2379 | 70 |
1748387 | 1748387 | 2021-09-24 | Barbour | Alabama | 1005 | 3432 | 70 |
1741939 | 1741939 | 2021-09-22 | Pickens | Alabama | 1107 | 3004 | 70 |
1738690 | 1738690 | 2021-09-21 | Pickens | Alabama | 1107 | 2997 | 70 |
1719153 | 1719153 | 2021-09-15 | Clarke | Alabama | 1025 | 4470 | 70 |
1673708 | 1673708 | 2021-09-01 | Marengo | Alabama | 1091 | 3010 | 70 |
1670460 | 1670460 | 2021-08-31 | Marengo | Alabama | 1091 | 2997 | 70 |
1355470 | 1355470 | 2021-05-26 | Butler | Alabama | 1013 | 2216 | 70 |
1352224 | 1352224 | 2021-05-25 | Butler | Alabama | 1013 | 2210 | 70 |
1348978 | 1348978 | 2021-05-24 | Butler | Alabama | 1013 | 2202 | 70 |
1345730 | 1345730 | 2021-05-23 | Butler | Alabama | 1013 | 2202 | 70 |
1342482 | 1342482 | 2021-05-22 | Butler | Alabama | 1013 | 2201 | 70 |
1128229 | 1128229 | 2021-03-17 | Winston | Alabama | 1133 | 2689 | 70 |
1102223 | 1102223 | 2021-03-09 | Geneva | Alabama | 1061 | 2409 | 70 |
1102225 | 1102225 | 2021-03-09 | Hale | Alabama | 1065 | 2130 | 70 |
1098977 | 1098977 | 2021-03-08 | Geneva | Alabama | 1061 | 2406 | 70 |
1095729 | 1095729 | 2021-03-07 | Geneva | Alabama | 1061 | 2406 | 70 |
1092483 | 1092483 | 2021-03-06 | Geneva | Alabama | 1061 | 2402 | 70 |
1089237 | 1089237 | 2021-03-05 | Geneva | Alabama | 1061 | 2405 | 70 |
1085992 | 1085992 | 2021-03-04 | Geneva | Alabama | 1061 | 2403 | 70 |
1082746 | 1082746 | 2021-03-03 | Geneva | Alabama | 1061 | 2402 | 70 |
1079500 | 1079500 | 2021-03-02 | Geneva | Alabama | 1061 | 2402 | 70 |
1076255 | 1076255 | 2021-03-01 | Geneva | Alabama | 1061 | 2399 | 70 |
1073009 | 1073009 | 2021-02-28 | Geneva | Alabama | 1061 | 2396 | 70 |
1069763 | 1069763 | 2021-02-27 | Geneva | Alabama | 1061 | 2390 | 70 |
1066518 | 1066518 | 2021-02-26 | Geneva | Alabama | 1061 | 2388 | 70 |
1063273 | 1063273 | 2021-02-25 | Geneva | Alabama | 1061 | 2386 | 70 |
1060024 | 1060024 | 2021-02-24 | Escambia | Alabama | 1053 | 3766 | 70 |
1056778 | 1056778 | 2021-02-23 | Escambia | Alabama | 1053 | 3759 | 70 |
1053560 | 1053560 | 2021-02-22 | Pike | Alabama | 1109 | 2913 | 70 |
1050313 | 1050313 | 2021-02-21 | Pike | Alabama | 1109 | 2912 | 70 |
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);