ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where county = "Chariton", deaths = 32 and state = "Missouri" 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 |
---|---|---|---|---|---|---|---|
2146431 | 2146431 | 2022-01-24 | Chariton | Missouri | 29041 | 1481 | 32 |
2143176 | 2143176 | 2022-01-23 | Chariton | Missouri | 29041 | 1475 | 32 |
2139921 | 2139921 | 2022-01-22 | Chariton | Missouri | 29041 | 1468 | 32 |
2136665 | 2136665 | 2022-01-21 | Chariton | Missouri | 29041 | 1453 | 32 |
2133413 | 2133413 | 2022-01-20 | Chariton | Missouri | 29041 | 1439 | 32 |
2130160 | 2130160 | 2022-01-19 | Chariton | Missouri | 29041 | 1416 | 32 |
2126906 | 2126906 | 2022-01-18 | Chariton | Missouri | 29041 | 1406 | 32 |
2123654 | 2123654 | 2022-01-17 | Chariton | Missouri | 29041 | 1399 | 32 |
2120402 | 2120402 | 2022-01-16 | Chariton | Missouri | 29041 | 1399 | 32 |
2117150 | 2117150 | 2022-01-15 | Chariton | Missouri | 29041 | 1399 | 32 |
2113899 | 2113899 | 2022-01-14 | Chariton | Missouri | 29041 | 1370 | 32 |
2110647 | 2110647 | 2022-01-13 | Chariton | Missouri | 29041 | 1365 | 32 |
2107396 | 2107396 | 2022-01-12 | Chariton | Missouri | 29041 | 1356 | 32 |
2104145 | 2104145 | 2022-01-11 | Chariton | Missouri | 29041 | 1346 | 32 |
2100894 | 2100894 | 2022-01-10 | Chariton | Missouri | 29041 | 1342 | 32 |
2097643 | 2097643 | 2022-01-09 | Chariton | Missouri | 29041 | 1339 | 32 |
2094391 | 2094391 | 2022-01-08 | Chariton | Missouri | 29041 | 1337 | 32 |
2091139 | 2091139 | 2022-01-07 | Chariton | Missouri | 29041 | 1318 | 32 |
2087888 | 2087888 | 2022-01-06 | Chariton | Missouri | 29041 | 1308 | 32 |
2084636 | 2084636 | 2022-01-05 | Chariton | Missouri | 29041 | 1306 | 32 |
2081384 | 2081384 | 2022-01-04 | Chariton | Missouri | 29041 | 1297 | 32 |
2078132 | 2078132 | 2022-01-03 | Chariton | Missouri | 29041 | 1295 | 32 |
2074881 | 2074881 | 2022-01-02 | Chariton | Missouri | 29041 | 1289 | 32 |
2071630 | 2071630 | 2022-01-01 | Chariton | Missouri | 29041 | 1289 | 32 |
2068379 | 2068379 | 2021-12-31 | Chariton | Missouri | 29041 | 1289 | 32 |
2065128 | 2065128 | 2021-12-30 | Chariton | Missouri | 29041 | 1289 | 32 |
2061878 | 2061878 | 2021-12-29 | Chariton | Missouri | 29041 | 1287 | 32 |
2058629 | 2058629 | 2021-12-28 | Chariton | Missouri | 29041 | 1284 | 32 |
2055380 | 2055380 | 2021-12-27 | Chariton | Missouri | 29041 | 1283 | 32 |
2052130 | 2052130 | 2021-12-26 | Chariton | Missouri | 29041 | 1280 | 32 |
2048880 | 2048880 | 2021-12-25 | Chariton | Missouri | 29041 | 1280 | 32 |
2045630 | 2045630 | 2021-12-24 | Chariton | Missouri | 29041 | 1280 | 32 |
2042380 | 2042380 | 2021-12-23 | Chariton | Missouri | 29041 | 1280 | 32 |
2039131 | 2039131 | 2021-12-22 | Chariton | Missouri | 29041 | 1270 | 32 |
2035881 | 2035881 | 2021-12-21 | Chariton | Missouri | 29041 | 1265 | 32 |
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);