ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where deaths = 216 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
county 7
- St. Francois 14
- Joplin 6
- Cass 4
- Phelps 4
- Clay 2
- St. Louis city 2
- Greene 1
state 1
- Missouri · 33 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2351365 | 2351365 | 2022-03-28 | Joplin | Missouri | 13729 | 216 | |
2348113 | 2348113 | 2022-03-27 | Joplin | Missouri | 13729 | 216 | |
2344860 | 2344860 | 2022-03-26 | Joplin | Missouri | 13729 | 216 | |
2341607 | 2341607 | 2022-03-25 | Joplin | Missouri | 13729 | 216 | |
2338354 | 2338354 | 2022-03-24 | Joplin | Missouri | 13727 | 216 | |
2335100 | 2335100 | 2022-03-23 | Joplin | Missouri | 13726 | 216 | |
2185531 | 2185531 | 2022-02-05 | Phelps | Missouri | 29161 | 9621 | 216 |
2182279 | 2182279 | 2022-02-04 | Phelps | Missouri | 29161 | 9596 | 216 |
2179027 | 2179027 | 2022-02-03 | Phelps | Missouri | 29161 | 9584 | 216 |
2175775 | 2175775 | 2022-02-02 | Phelps | Missouri | 29161 | 9549 | 216 |
2032629 | 2032629 | 2021-12-20 | Cass | Missouri | 29037 | 16703 | 216 |
2032712 | 2032712 | 2021-12-20 | St. Francois | Missouri | 29187 | 13371 | 216 |
2029378 | 2029378 | 2021-12-19 | Cass | Missouri | 29037 | 16682 | 216 |
2029461 | 2029461 | 2021-12-19 | St. Francois | Missouri | 29187 | 13345 | 216 |
2026127 | 2026127 | 2021-12-18 | Cass | Missouri | 29037 | 16644 | 216 |
2026210 | 2026210 | 2021-12-18 | St. Francois | Missouri | 29187 | 13327 | 216 |
2022876 | 2022876 | 2021-12-17 | Cass | Missouri | 29037 | 16559 | 216 |
2022959 | 2022959 | 2021-12-17 | St. Francois | Missouri | 29187 | 13232 | 216 |
2019708 | 2019708 | 2021-12-16 | St. Francois | Missouri | 29187 | 13199 | 216 |
2016458 | 2016458 | 2021-12-15 | St. Francois | Missouri | 29187 | 13141 | 216 |
2013207 | 2013207 | 2021-12-14 | St. Francois | Missouri | 29187 | 13078 | 216 |
2009956 | 2009956 | 2021-12-13 | St. Francois | Missouri | 29187 | 13056 | 216 |
2006705 | 2006705 | 2021-12-12 | St. Francois | Missouri | 29187 | 13047 | 216 |
2003454 | 2003454 | 2021-12-11 | St. Francois | Missouri | 29187 | 13026 | 216 |
2000204 | 2000204 | 2021-12-10 | St. Francois | Missouri | 29187 | 13000 | 216 |
1996953 | 1996953 | 2021-12-09 | St. Francois | Missouri | 29187 | 12962 | 216 |
1993702 | 1993702 | 2021-12-08 | St. Francois | Missouri | 29187 | 12930 | 216 |
1990451 | 1990451 | 2021-12-07 | St. Francois | Missouri | 29187 | 12878 | 216 |
1860375 | 1860375 | 2021-10-28 | Clay | Missouri | 29047 | 14988 | 216 |
1857126 | 1857126 | 2021-10-27 | Clay | Missouri | 29047 | 14953 | 216 |
792157 | 792157 | 2020-12-03 | Greene | Missouri | 29077 | 15672 | 216 |
636484 | 636484 | 2020-10-16 | St. Louis city | Missouri | 29510 | 7803 | 216 |
633238 | 633238 | 2020-10-15 | St. Louis city | Missouri | 29510 | 7750 | 216 |
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);