ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where deaths = 151 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Missouri · 65 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2260323 | 2260323 | 2022-02-28 | Pettis | Missouri | 29159 | 11804 | 151 |
2257072 | 2257072 | 2022-02-27 | Pettis | Missouri | 29159 | 11791 | 151 |
2253821 | 2253821 | 2022-02-26 | Pettis | Missouri | 29159 | 11791 | 151 |
2250570 | 2250570 | 2022-02-25 | Pettis | Missouri | 29159 | 11791 | 151 |
2247319 | 2247319 | 2022-02-24 | Pettis | Missouri | 29159 | 11783 | 151 |
2084630 | 2084630 | 2022-01-05 | Camden | Missouri | 29029 | 7204 | 151 |
2081378 | 2081378 | 2022-01-04 | Camden | Missouri | 29029 | 7138 | 151 |
2078126 | 2078126 | 2022-01-03 | Camden | Missouri | 29029 | 7086 | 151 |
2074875 | 2074875 | 2022-01-02 | Camden | Missouri | 29029 | 7054 | 151 |
2071624 | 2071624 | 2022-01-01 | Camden | Missouri | 29029 | 7054 | 151 |
2068373 | 2068373 | 2021-12-31 | Camden | Missouri | 29029 | 7054 | 151 |
2065122 | 2065122 | 2021-12-30 | Camden | Missouri | 29029 | 7054 | 151 |
2061872 | 2061872 | 2021-12-29 | Camden | Missouri | 29029 | 7023 | 151 |
2058623 | 2058623 | 2021-12-28 | Camden | Missouri | 29029 | 7005 | 151 |
2032665 | 2032665 | 2021-12-20 | Laclede | Missouri | 29105 | 5894 | 151 |
2029414 | 2029414 | 2021-12-19 | Laclede | Missouri | 29105 | 5877 | 151 |
2026163 | 2026163 | 2021-12-18 | Laclede | Missouri | 29105 | 5872 | 151 |
2022912 | 2022912 | 2021-12-17 | Laclede | Missouri | 29105 | 5846 | 151 |
2019661 | 2019661 | 2021-12-16 | Laclede | Missouri | 29105 | 5833 | 151 |
1873456 | 1873456 | 2021-11-01 | Taney | Missouri | 29213 | 9023 | 151 |
1870207 | 1870207 | 2021-10-31 | Taney | Missouri | 29213 | 9017 | 151 |
1866958 | 1866958 | 2021-10-30 | Taney | Missouri | 29213 | 9012 | 151 |
1863709 | 1863709 | 2021-10-29 | Taney | Missouri | 29213 | 9007 | 151 |
1860460 | 1860460 | 2021-10-28 | Taney | Missouri | 29213 | 8998 | 151 |
1857211 | 1857211 | 2021-10-27 | Taney | Missouri | 29213 | 8994 | 151 |
1853962 | 1853962 | 2021-10-26 | Taney | Missouri | 29213 | 8987 | 151 |
1850713 | 1850713 | 2021-10-25 | Taney | Missouri | 29213 | 8983 | 151 |
1847463 | 1847463 | 2021-10-24 | Taney | Missouri | 29213 | 8980 | 151 |
1844213 | 1844213 | 2021-10-23 | Taney | Missouri | 29213 | 8976 | 151 |
1840963 | 1840963 | 2021-10-22 | Taney | Missouri | 29213 | 8965 | 151 |
1837714 | 1837714 | 2021-10-21 | Taney | Missouri | 29213 | 8961 | 151 |
1834465 | 1834465 | 2021-10-20 | Taney | Missouri | 29213 | 8952 | 151 |
1831216 | 1831216 | 2021-10-19 | Taney | Missouri | 29213 | 8950 | 151 |
1827967 | 1827967 | 2021-10-18 | Taney | Missouri | 29213 | 8942 | 151 |
1824718 | 1824718 | 2021-10-17 | Taney | Missouri | 29213 | 8940 | 151 |
1821469 | 1821469 | 2021-10-16 | Taney | Missouri | 29213 | 8933 | 151 |
1818220 | 1818220 | 2021-10-15 | Taney | Missouri | 29213 | 8928 | 151 |
1814914 | 1814914 | 2021-10-14 | Joplin | Missouri | 8628 | 151 | |
1811666 | 1811666 | 2021-10-13 | Joplin | Missouri | 8626 | 151 | |
1766226 | 1766226 | 2021-09-29 | St. Francois | Missouri | 29187 | 11632 | 151 |
1762977 | 1762977 | 2021-09-28 | St. Francois | Missouri | 29187 | 11606 | 151 |
1759642 | 1759642 | 2021-09-27 | Cape Girardeau | Missouri | 29031 | 12421 | 151 |
1756394 | 1756394 | 2021-09-26 | Cape Girardeau | Missouri | 29031 | 12366 | 151 |
1753146 | 1753146 | 2021-09-25 | Cape Girardeau | Missouri | 29031 | 12366 | 151 |
1749898 | 1749898 | 2021-09-24 | Cape Girardeau | Missouri | 29031 | 12366 | 151 |
1746648 | 1746648 | 2021-09-23 | Cape Girardeau | Missouri | 29031 | 12300 | 151 |
1743399 | 1743399 | 2021-09-22 | Cape Girardeau | Missouri | 29031 | 12300 | 151 |
1740150 | 1740150 | 2021-09-21 | Cape Girardeau | Missouri | 29031 | 12168 | 151 |
1733645 | 1733645 | 2021-09-19 | Boone | Missouri | 29019 | 24088 | 151 |
1730395 | 1730395 | 2021-09-18 | Boone | Missouri | 29019 | 24088 | 151 |
1727145 | 1727145 | 2021-09-17 | Boone | Missouri | 29019 | 24088 | 151 |
1723896 | 1723896 | 2021-09-16 | Boone | Missouri | 29019 | 24028 | 151 |
1100466 | 1100466 | 2021-03-08 | Clay | Missouri | 29047 | 9668 | 151 |
1097219 | 1097219 | 2021-03-07 | Clay | Missouri | 29047 | 9634 | 151 |
1093972 | 1093972 | 2021-03-06 | Clay | Missouri | 29047 | 9634 | 151 |
1090726 | 1090726 | 2021-03-05 | Clay | Missouri | 29047 | 9634 | 151 |
1087481 | 1087481 | 2021-03-04 | Clay | Missouri | 29047 | 9623 | 151 |
1084236 | 1084236 | 2021-03-03 | Clay | Missouri | 29047 | 9550 | 151 |
960889 | 960889 | 2021-01-24 | Buchanan | Missouri | 29021 | 9509 | 151 |
957643 | 957643 | 2021-01-23 | Buchanan | Missouri | 29021 | 9509 | 151 |
954398 | 954398 | 2021-01-22 | Buchanan | Missouri | 29021 | 9509 | 151 |
951153 | 951153 | 2021-01-21 | Buchanan | Missouri | 29021 | 9467 | 151 |
947907 | 947907 | 2021-01-20 | Buchanan | Missouri | 29021 | 9425 | 151 |
944660 | 944660 | 2021-01-19 | Buchanan | Missouri | 29021 | 9362 | 151 |
720772 | 720772 | 2020-11-11 | Jackson | Missouri | 29095 | 12717 | 151 |
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);