ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where deaths = 232 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 12
state 1
- Alabama · 74 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499594 | 2499594 | 2022-05-13 | Covington | Alabama | 1039 | 9355 | 232 |
2496336 | 2496336 | 2022-05-12 | Covington | Alabama | 1039 | 9354 | 232 |
2493078 | 2493078 | 2022-05-11 | Covington | Alabama | 1039 | 9355 | 232 |
2489820 | 2489820 | 2022-05-10 | Covington | Alabama | 1039 | 9350 | 232 |
2486563 | 2486563 | 2022-05-09 | Covington | Alabama | 1039 | 9348 | 232 |
2483305 | 2483305 | 2022-05-08 | Covington | Alabama | 1039 | 9343 | 232 |
2480047 | 2480047 | 2022-05-07 | Covington | Alabama | 1039 | 9343 | 232 |
2476789 | 2476789 | 2022-05-06 | Covington | Alabama | 1039 | 9343 | 232 |
2473531 | 2473531 | 2022-05-05 | Covington | Alabama | 1039 | 9343 | 232 |
2470274 | 2470274 | 2022-05-04 | Covington | Alabama | 1039 | 9341 | 232 |
2467018 | 2467018 | 2022-05-03 | Covington | Alabama | 1039 | 9340 | 232 |
2463763 | 2463763 | 2022-05-02 | Covington | Alabama | 1039 | 9337 | 232 |
2460507 | 2460507 | 2022-05-01 | Covington | Alabama | 1039 | 9333 | 232 |
2457251 | 2457251 | 2022-04-30 | Covington | Alabama | 1039 | 9333 | 232 |
2453995 | 2453995 | 2022-04-29 | Covington | Alabama | 1039 | 9333 | 232 |
2450739 | 2450739 | 2022-04-28 | Covington | Alabama | 1039 | 9333 | 232 |
2447483 | 2447483 | 2022-04-27 | Covington | Alabama | 1039 | 9333 | 232 |
2444227 | 2444227 | 2022-04-26 | Covington | Alabama | 1039 | 9333 | 232 |
2440971 | 2440971 | 2022-04-25 | Covington | Alabama | 1039 | 9328 | 232 |
2437715 | 2437715 | 2022-04-24 | Covington | Alabama | 1039 | 9327 | 232 |
2434459 | 2434459 | 2022-04-23 | Covington | Alabama | 1039 | 9327 | 232 |
2431203 | 2431203 | 2022-04-22 | Covington | Alabama | 1039 | 9327 | 232 |
2395432 | 2395432 | 2022-04-11 | Tallapoosa | Alabama | 1123 | 11388 | 232 |
2392176 | 2392176 | 2022-04-10 | Tallapoosa | Alabama | 1123 | 11382 | 232 |
2388920 | 2388920 | 2022-04-09 | Tallapoosa | Alabama | 1123 | 11382 | 232 |
2385665 | 2385665 | 2022-04-08 | Tallapoosa | Alabama | 1123 | 11382 | 232 |
2382410 | 2382410 | 2022-04-07 | Tallapoosa | Alabama | 1123 | 11380 | 232 |
2379155 | 2379155 | 2022-04-06 | Tallapoosa | Alabama | 1123 | 11379 | 232 |
2375901 | 2375901 | 2022-04-05 | Tallapoosa | Alabama | 1123 | 11378 | 232 |
2372649 | 2372649 | 2022-04-04 | Tallapoosa | Alabama | 1123 | 11378 | 232 |
2369396 | 2369396 | 2022-04-03 | Tallapoosa | Alabama | 1123 | 11376 | 232 |
2366143 | 2366143 | 2022-04-02 | Tallapoosa | Alabama | 1123 | 11376 | 232 |
2362890 | 2362890 | 2022-04-01 | Tallapoosa | Alabama | 1123 | 11376 | 232 |
2359636 | 2359636 | 2022-03-31 | Tallapoosa | Alabama | 1123 | 11375 | 232 |
2356382 | 2356382 | 2022-03-30 | Tallapoosa | Alabama | 1123 | 11374 | 232 |
2353129 | 2353129 | 2022-03-29 | Tallapoosa | Alabama | 1123 | 11373 | 232 |
2349877 | 2349877 | 2022-03-28 | Tallapoosa | Alabama | 1123 | 11373 | 232 |
2346624 | 2346624 | 2022-03-27 | Tallapoosa | Alabama | 1123 | 11370 | 232 |
2343371 | 2343371 | 2022-03-26 | Tallapoosa | Alabama | 1123 | 11370 | 232 |
2340118 | 2340118 | 2022-03-25 | Tallapoosa | Alabama | 1123 | 11370 | 232 |
2336865 | 2336865 | 2022-03-24 | Tallapoosa | Alabama | 1123 | 11369 | 232 |
2333611 | 2333611 | 2022-03-23 | Tallapoosa | Alabama | 1123 | 11366 | 232 |
2281532 | 2281532 | 2022-03-07 | Dallas | Alabama | 1047 | 8337 | 232 |
1738661 | 1738661 | 2021-09-21 | DeKalb | Alabama | 1049 | 11984 | 232 |
1495077 | 1495077 | 2021-07-08 | Marshall | Alabama | 1095 | 12527 | 232 |
1491830 | 1491830 | 2021-07-07 | Marshall | Alabama | 1095 | 12527 | 232 |
1176928 | 1176928 | 2021-04-01 | Shelby | Alabama | 1117 | 23077 | 232 |
1176929 | 1176929 | 2021-04-01 | St. Clair | Alabama | 1115 | 9360 | 232 |
1173681 | 1173681 | 2021-03-31 | Shelby | Alabama | 1117 | 23048 | 232 |
1173682 | 1173682 | 2021-03-31 | St. Clair | Alabama | 1115 | 9350 | 232 |
1170434 | 1170434 | 2021-03-30 | Shelby | Alabama | 1117 | 23025 | 232 |
1170435 | 1170435 | 2021-03-30 | St. Clair | Alabama | 1115 | 9348 | 232 |
1167186 | 1167186 | 2021-03-29 | Shelby | Alabama | 1117 | 22994 | 232 |
1167187 | 1167187 | 2021-03-29 | St. Clair | Alabama | 1115 | 9331 | 232 |
1163938 | 1163938 | 2021-03-28 | Shelby | Alabama | 1117 | 22976 | 232 |
1163939 | 1163939 | 2021-03-28 | St. Clair | Alabama | 1115 | 9327 | 232 |
1160690 | 1160690 | 2021-03-27 | Shelby | Alabama | 1117 | 22958 | 232 |
1160691 | 1160691 | 2021-03-27 | St. Clair | Alabama | 1115 | 9323 | 232 |
1157442 | 1157442 | 2021-03-26 | Shelby | Alabama | 1117 | 22930 | 232 |
1157443 | 1157443 | 2021-03-26 | St. Clair | Alabama | 1115 | 9314 | 232 |
1154195 | 1154195 | 2021-03-25 | Shelby | Alabama | 1117 | 22906 | 232 |
1154196 | 1154196 | 2021-03-25 | St. Clair | Alabama | 1115 | 9308 | 232 |
1150949 | 1150949 | 2021-03-24 | St. Clair | Alabama | 1115 | 9301 | 232 |
1011348 | 1011348 | 2021-02-09 | Houston | Alabama | 1069 | 9753 | 232 |
985352 | 985352 | 2021-02-01 | Calhoun | Alabama | 1015 | 12062 | 232 |
982105 | 982105 | 2021-01-31 | Calhoun | Alabama | 1015 | 12011 | 232 |
978859 | 978859 | 2021-01-30 | Calhoun | Alabama | 1015 | 11918 | 232 |
975614 | 975614 | 2021-01-29 | Calhoun | Alabama | 1015 | 11918 | 232 |
758223 | 758223 | 2020-11-23 | Montgomery | Alabama | 1101 | 12040 | 232 |
754976 | 754976 | 2020-11-22 | Montgomery | Alabama | 1101 | 12000 | 232 |
751730 | 751730 | 2020-11-21 | Montgomery | Alabama | 1101 | 11952 | 232 |
748484 | 748484 | 2020-11-20 | Montgomery | Alabama | 1101 | 11903 | 232 |
437513 | 437513 | 2020-08-16 | Mobile | Alabama | 1097 | 11125 | 232 |
402058 | 402058 | 2020-08-05 | Jefferson | Alabama | 1073 | 12408 | 232 |
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);