ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where deaths = 232, fips = 1039 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
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 |
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);