ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where county = "Amite", deaths = 59 and state = "Mississippi" 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 |
---|---|---|---|---|---|---|---|
2165852 | 2165852 | 2022-01-30 | Amite | Mississippi | 28005 | 2869 | 59 |
2162597 | 2162597 | 2022-01-29 | Amite | Mississippi | 28005 | 2869 | 59 |
2159342 | 2159342 | 2022-01-28 | Amite | Mississippi | 28005 | 2869 | 59 |
2156088 | 2156088 | 2022-01-27 | Amite | Mississippi | 28005 | 2838 | 59 |
2152835 | 2152835 | 2022-01-26 | Amite | Mississippi | 28005 | 2822 | 59 |
2149583 | 2149583 | 2022-01-25 | Amite | Mississippi | 28005 | 2801 | 59 |
2146331 | 2146331 | 2022-01-24 | Amite | Mississippi | 28005 | 2791 | 59 |
2143076 | 2143076 | 2022-01-23 | Amite | Mississippi | 28005 | 2724 | 59 |
2139821 | 2139821 | 2022-01-22 | Amite | Mississippi | 28005 | 2724 | 59 |
2136565 | 2136565 | 2022-01-21 | Amite | Mississippi | 28005 | 2724 | 59 |
2133313 | 2133313 | 2022-01-20 | Amite | Mississippi | 28005 | 2704 | 59 |
2130060 | 2130060 | 2022-01-19 | Amite | Mississippi | 28005 | 2673 | 59 |
2126806 | 2126806 | 2022-01-18 | Amite | Mississippi | 28005 | 2636 | 59 |
2123554 | 2123554 | 2022-01-17 | Amite | Mississippi | 28005 | 2534 | 59 |
2120302 | 2120302 | 2022-01-16 | Amite | Mississippi | 28005 | 2534 | 59 |
2117050 | 2117050 | 2022-01-15 | Amite | Mississippi | 28005 | 2534 | 59 |
2113799 | 2113799 | 2022-01-14 | Amite | Mississippi | 28005 | 2534 | 59 |
2110547 | 2110547 | 2022-01-13 | Amite | Mississippi | 28005 | 2472 | 59 |
2107296 | 2107296 | 2022-01-12 | Amite | Mississippi | 28005 | 2430 | 59 |
2104045 | 2104045 | 2022-01-11 | Amite | Mississippi | 28005 | 2410 | 59 |
2100794 | 2100794 | 2022-01-10 | Amite | Mississippi | 28005 | 2387 | 59 |
2097543 | 2097543 | 2022-01-09 | Amite | Mississippi | 28005 | 2360 | 59 |
2094291 | 2094291 | 2022-01-08 | Amite | Mississippi | 28005 | 2360 | 59 |
2091039 | 2091039 | 2022-01-07 | Amite | Mississippi | 28005 | 2360 | 59 |
2087788 | 2087788 | 2022-01-06 | Amite | Mississippi | 28005 | 2328 | 59 |
2084536 | 2084536 | 2022-01-05 | Amite | Mississippi | 28005 | 2317 | 59 |
2081284 | 2081284 | 2022-01-04 | Amite | Mississippi | 28005 | 2298 | 59 |
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);