ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 152 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
- Scott 8
- Cape Girardeau 7
- Laclede 7
- Camden 5
- St. Francois 5
- Boone 4
- Joplin 3
- Jackson 1
- Phelps 1
state 1
- Missouri · 41 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2283104 | 2283104 | 2022-03-07 | Scott | Missouri | 29201 | 11063 | 152 |
2279851 | 2279851 | 2022-03-06 | Scott | Missouri | 29201 | 11022 | 152 |
2276598 | 2276598 | 2022-03-05 | Scott | Missouri | 29201 | 11022 | 152 |
2273345 | 2273345 | 2022-03-04 | Scott | Missouri | 29201 | 11022 | 152 |
2270093 | 2270093 | 2022-03-03 | Scott | Missouri | 29201 | 11021 | 152 |
2266840 | 2266840 | 2022-03-02 | Scott | Missouri | 29201 | 11019 | 152 |
2263589 | 2263589 | 2022-03-01 | Scott | Missouri | 29201 | 11018 | 152 |
2260338 | 2260338 | 2022-02-28 | Scott | Missouri | 29201 | 11020 | 152 |
2100888 | 2100888 | 2022-01-10 | Camden | Missouri | 29029 | 7405 | 152 |
2097637 | 2097637 | 2022-01-09 | Camden | Missouri | 29029 | 7373 | 152 |
2094385 | 2094385 | 2022-01-08 | Camden | Missouri | 29029 | 7363 | 152 |
2091133 | 2091133 | 2022-01-07 | Camden | Missouri | 29029 | 7298 | 152 |
2087882 | 2087882 | 2022-01-06 | Camden | Missouri | 29029 | 7260 | 152 |
2055414 | 2055414 | 2021-12-27 | Laclede | Missouri | 29105 | 5984 | 152 |
2052164 | 2052164 | 2021-12-26 | Laclede | Missouri | 29105 | 5939 | 152 |
2048914 | 2048914 | 2021-12-25 | Laclede | Missouri | 29105 | 5939 | 152 |
2045664 | 2045664 | 2021-12-24 | Laclede | Missouri | 29105 | 5939 | 152 |
2042414 | 2042414 | 2021-12-23 | Laclede | Missouri | 29105 | 5939 | 152 |
2039165 | 2039165 | 2021-12-22 | Laclede | Missouri | 29105 | 5913 | 152 |
2035915 | 2035915 | 2021-12-21 | Laclede | Missouri | 29105 | 5895 | 152 |
1883146 | 1883146 | 2021-11-04 | Joplin | Missouri | 8777 | 152 | |
1879897 | 1879897 | 2021-11-03 | Joplin | Missouri | 8769 | 152 | |
1876648 | 1876648 | 2021-11-02 | Joplin | Missouri | 8763 | 152 | |
1782388 | 1782388 | 2021-10-04 | Cape Girardeau | Missouri | 29031 | 12529 | 152 |
1782474 | 1782474 | 2021-10-04 | St. Francois | Missouri | 29187 | 11730 | 152 |
1779138 | 1779138 | 2021-10-03 | Cape Girardeau | Missouri | 29031 | 12529 | 152 |
1779224 | 1779224 | 2021-10-03 | St. Francois | Missouri | 29187 | 11725 | 152 |
1775888 | 1775888 | 2021-10-02 | Cape Girardeau | Missouri | 29031 | 12529 | 152 |
1775974 | 1775974 | 2021-10-02 | St. Francois | Missouri | 29187 | 11714 | 152 |
1772638 | 1772638 | 2021-10-01 | Cape Girardeau | Missouri | 29031 | 12529 | 152 |
1772724 | 1772724 | 2021-10-01 | St. Francois | Missouri | 29187 | 11699 | 152 |
1769389 | 1769389 | 2021-09-30 | Cape Girardeau | Missouri | 29031 | 12476 | 152 |
1769475 | 1769475 | 2021-09-30 | St. Francois | Missouri | 29187 | 11663 | 152 |
1766140 | 1766140 | 2021-09-29 | Cape Girardeau | Missouri | 29031 | 12476 | 152 |
1762891 | 1762891 | 2021-09-28 | Cape Girardeau | Missouri | 29031 | 12421 | 152 |
1746642 | 1746642 | 2021-09-23 | Boone | Missouri | 29019 | 24343 | 152 |
1743393 | 1743393 | 2021-09-22 | Boone | Missouri | 29019 | 24297 | 152 |
1740144 | 1740144 | 2021-09-21 | Boone | Missouri | 29019 | 24248 | 152 |
1736895 | 1736895 | 2021-09-20 | Boone | Missouri | 29019 | 24200 | 152 |
1603781 | 1603781 | 2021-08-10 | Phelps | Missouri | 29161 | 5087 | 152 |
724015 | 724015 | 2020-11-12 | Jackson | Missouri | 29095 | 12890 | 152 |
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);