ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where deaths = 295 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 4
- Franklin 11
- St. Francois 8
- Jasper 1
- Jefferson 1
state 1
- Missouri · 21 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497919 | 2497919 | 2022-05-12 | St. Francois | Missouri | 29187 | 19092 | 295 |
2494661 | 2494661 | 2022-05-11 | St. Francois | Missouri | 29187 | 19092 | 295 |
2491403 | 2491403 | 2022-05-10 | St. Francois | Missouri | 29187 | 19092 | 295 |
2488145 | 2488145 | 2022-05-09 | St. Francois | Missouri | 29187 | 19092 | 295 |
2484888 | 2484888 | 2022-05-08 | St. Francois | Missouri | 29187 | 19092 | 295 |
2481630 | 2481630 | 2022-05-07 | St. Francois | Missouri | 29187 | 19092 | 295 |
2478372 | 2478372 | 2022-05-06 | St. Francois | Missouri | 29187 | 19092 | 295 |
2475114 | 2475114 | 2022-05-05 | St. Francois | Missouri | 29187 | 19070 | 295 |
2247286 | 2247286 | 2022-02-24 | Jasper | Missouri | 29097 | 20710 | 295 |
2169222 | 2169222 | 2022-01-31 | Franklin | Missouri | 29071 | 21554 | 295 |
2165967 | 2165967 | 2022-01-30 | Franklin | Missouri | 29071 | 21533 | 295 |
2162712 | 2162712 | 2022-01-29 | Franklin | Missouri | 29071 | 21490 | 295 |
2159457 | 2159457 | 2022-01-28 | Franklin | Missouri | 29071 | 21383 | 295 |
2156203 | 2156203 | 2022-01-27 | Franklin | Missouri | 29071 | 21281 | 295 |
2152950 | 2152950 | 2022-01-26 | Franklin | Missouri | 29071 | 21162 | 295 |
2149698 | 2149698 | 2022-01-25 | Franklin | Missouri | 29071 | 21012 | 295 |
2146446 | 2146446 | 2022-01-24 | Franklin | Missouri | 29071 | 20893 | 295 |
2143191 | 2143191 | 2022-01-23 | Franklin | Missouri | 29071 | 20818 | 295 |
2139936 | 2139936 | 2022-01-22 | Franklin | Missouri | 29071 | 20659 | 295 |
2136680 | 2136680 | 2022-01-21 | Franklin | Missouri | 29071 | 20546 | 295 |
1740184 | 1740184 | 2021-09-21 | Jefferson | Missouri | 29099 | 29729 | 295 |
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);