ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where deaths = 212 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 5
- Cape Girardeau 11
- Buchanan 10
- St. Francois 7
- Phelps 4
- Cass 1
state 1
- Missouri · 33 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2169202 | 2169202 | 2022-01-31 | Cape Girardeau | Missouri | 29031 | 17469 | 212 |
2165947 | 2165947 | 2022-01-30 | Cape Girardeau | Missouri | 29031 | 17439 | 212 |
2162692 | 2162692 | 2022-01-29 | Cape Girardeau | Missouri | 29031 | 17389 | 212 |
2159437 | 2159437 | 2022-01-28 | Cape Girardeau | Missouri | 29031 | 17262 | 212 |
2156183 | 2156183 | 2022-01-27 | Cape Girardeau | Missouri | 29031 | 17094 | 212 |
2152930 | 2152930 | 2022-01-26 | Cape Girardeau | Missouri | 29031 | 16914 | 212 |
2149678 | 2149678 | 2022-01-25 | Cape Girardeau | Missouri | 29031 | 16724 | 212 |
2146426 | 2146426 | 2022-01-24 | Cape Girardeau | Missouri | 29031 | 16607 | 212 |
2146493 | 2146493 | 2022-01-24 | Phelps | Missouri | 29161 | 9046 | 212 |
2143171 | 2143171 | 2022-01-23 | Cape Girardeau | Missouri | 29031 | 16488 | 212 |
2143238 | 2143238 | 2022-01-23 | Phelps | Missouri | 29161 | 9010 | 212 |
2139916 | 2139916 | 2022-01-22 | Cape Girardeau | Missouri | 29031 | 16403 | 212 |
2139983 | 2139983 | 2022-01-22 | Phelps | Missouri | 29161 | 8980 | 212 |
2136660 | 2136660 | 2022-01-21 | Cape Girardeau | Missouri | 29031 | 16291 | 212 |
2136727 | 2136727 | 2022-01-21 | Phelps | Missouri | 29161 | 8938 | 212 |
2000121 | 2000121 | 2021-12-10 | Cass | Missouri | 29037 | 16113 | 212 |
1987201 | 1987201 | 2021-12-06 | St. Francois | Missouri | 29187 | 12867 | 212 |
1983951 | 1983951 | 2021-12-05 | St. Francois | Missouri | 29187 | 12814 | 212 |
1980701 | 1980701 | 2021-12-04 | St. Francois | Missouri | 29187 | 12803 | 212 |
1977451 | 1977451 | 2021-12-03 | St. Francois | Missouri | 29187 | 12761 | 212 |
1974201 | 1974201 | 2021-12-02 | St. Francois | Missouri | 29187 | 12761 | 212 |
1970952 | 1970952 | 2021-12-01 | St. Francois | Missouri | 29187 | 12728 | 212 |
1967702 | 1967702 | 2021-11-30 | St. Francois | Missouri | 29187 | 12694 | 212 |
1723897 | 1723897 | 2021-09-16 | Buchanan | Missouri | 29021 | 14470 | 212 |
1720648 | 1720648 | 2021-09-15 | Buchanan | Missouri | 29021 | 14470 | 212 |
1717400 | 1717400 | 2021-09-14 | Buchanan | Missouri | 29021 | 14470 | 212 |
1714152 | 1714152 | 2021-09-13 | Buchanan | Missouri | 29021 | 14470 | 212 |
1710906 | 1710906 | 2021-09-12 | Buchanan | Missouri | 29021 | 14367 | 212 |
1707659 | 1707659 | 2021-09-11 | Buchanan | Missouri | 29021 | 14367 | 212 |
1704412 | 1704412 | 2021-09-10 | Buchanan | Missouri | 29021 | 14367 | 212 |
1701162 | 1701162 | 2021-09-09 | Buchanan | Missouri | 29021 | 14367 | 212 |
1697913 | 1697913 | 2021-09-08 | Buchanan | Missouri | 29021 | 14315 | 212 |
1694665 | 1694665 | 2021-09-07 | Buchanan | Missouri | 29021 | 14315 | 212 |
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);