ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where deaths = 202 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
- Christian 15
- Taney 9
- Cape Girardeau 7
- Newton 7
- Cass 6
- Jasper 3
- Joplin 1
- Kansas City 1
- Phelps 1
state 1
- Missouri · 50 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2351388 | 2351388 | 2022-03-28 | Newton | Missouri | 29145 | 11722 | 202 |
2348136 | 2348136 | 2022-03-27 | Newton | Missouri | 29145 | 11721 | 202 |
2344883 | 2344883 | 2022-03-26 | Newton | Missouri | 29145 | 11721 | 202 |
2341630 | 2341630 | 2022-03-25 | Newton | Missouri | 29145 | 11721 | 202 |
2338377 | 2338377 | 2022-03-24 | Newton | Missouri | 29145 | 11721 | 202 |
2335123 | 2335123 | 2022-03-23 | Newton | Missouri | 29145 | 11718 | 202 |
2331869 | 2331869 | 2022-03-22 | Newton | Missouri | 29145 | 11710 | 202 |
2244095 | 2244095 | 2022-02-23 | Taney | Missouri | 29213 | 13158 | 202 |
2240844 | 2240844 | 2022-02-22 | Taney | Missouri | 29213 | 13154 | 202 |
2237593 | 2237593 | 2022-02-21 | Taney | Missouri | 29213 | 13124 | 202 |
2234342 | 2234342 | 2022-02-20 | Taney | Missouri | 29213 | 13124 | 202 |
2231091 | 2231091 | 2022-02-19 | Taney | Missouri | 29213 | 13124 | 202 |
2227840 | 2227840 | 2022-02-18 | Taney | Missouri | 29213 | 13124 | 202 |
2224589 | 2224589 | 2022-02-17 | Taney | Missouri | 29213 | 13119 | 202 |
2221338 | 2221338 | 2022-02-16 | Taney | Missouri | 29213 | 13105 | 202 |
2218087 | 2218087 | 2022-02-15 | Taney | Missouri | 29213 | 13087 | 202 |
2195260 | 2195260 | 2022-02-08 | Joplin | Missouri | 12868 | 202 | |
2081446 | 2081446 | 2022-01-04 | Phelps | Missouri | 29161 | 7639 | 202 |
2032626 | 2032626 | 2021-12-20 | Cape Girardeau | Missouri | 29031 | 13689 | 202 |
2029375 | 2029375 | 2021-12-19 | Cape Girardeau | Missouri | 29031 | 13680 | 202 |
2026124 | 2026124 | 2021-12-18 | Cape Girardeau | Missouri | 29031 | 13672 | 202 |
2022873 | 2022873 | 2021-12-17 | Cape Girardeau | Missouri | 29031 | 13661 | 202 |
2019622 | 2019622 | 2021-12-16 | Cape Girardeau | Missouri | 29031 | 13643 | 202 |
2016372 | 2016372 | 2021-12-15 | Cape Girardeau | Missouri | 29031 | 13621 | 202 |
2013121 | 2013121 | 2021-12-14 | Cape Girardeau | Missouri | 29031 | 13899 | 202 |
2009876 | 2009876 | 2021-12-13 | Christian | Missouri | 29043 | 14285 | 202 |
2006625 | 2006625 | 2021-12-12 | Christian | Missouri | 29043 | 14263 | 202 |
2003374 | 2003374 | 2021-12-11 | Christian | Missouri | 29043 | 14224 | 202 |
2000124 | 2000124 | 2021-12-10 | Christian | Missouri | 29043 | 14189 | 202 |
1996873 | 1996873 | 2021-12-09 | Christian | Missouri | 29043 | 14134 | 202 |
1987121 | 1987121 | 2021-12-06 | Christian | Missouri | 29043 | 14037 | 202 |
1983871 | 1983871 | 2021-12-05 | Christian | Missouri | 29043 | 13986 | 202 |
1980621 | 1980621 | 2021-12-04 | Christian | Missouri | 29043 | 13966 | 202 |
1977371 | 1977371 | 2021-12-03 | Christian | Missouri | 29043 | 13899 | 202 |
1974121 | 1974121 | 2021-12-02 | Christian | Missouri | 29043 | 13899 | 202 |
1970872 | 1970872 | 2021-12-01 | Christian | Missouri | 29043 | 13859 | 202 |
1967622 | 1967622 | 2021-11-30 | Christian | Missouri | 29043 | 13828 | 202 |
1961116 | 1961116 | 2021-11-28 | Cass | Missouri | 29037 | 15229 | 202 |
1957865 | 1957865 | 2021-11-27 | Cass | Missouri | 29037 | 15229 | 202 |
1954614 | 1954614 | 2021-11-26 | Cass | Missouri | 29037 | 15229 | 202 |
1951363 | 1951363 | 2021-11-25 | Cass | Missouri | 29037 | 15229 | 202 |
1948112 | 1948112 | 2021-11-24 | Cass | Missouri | 29037 | 15229 | 202 |
1944861 | 1944861 | 2021-11-23 | Cass | Missouri | 29037 | 15193 | 202 |
1938363 | 1938363 | 2021-11-21 | Christian | Missouri | 29043 | 13620 | 202 |
1935113 | 1935113 | 2021-11-20 | Christian | Missouri | 29043 | 13600 | 202 |
1931863 | 1931863 | 2021-11-19 | Christian | Missouri | 29043 | 13574 | 202 |
1883143 | 1883143 | 2021-11-04 | Jasper | Missouri | 29097 | 13784 | 202 |
1879894 | 1879894 | 2021-11-03 | Jasper | Missouri | 29097 | 13768 | 202 |
1876645 | 1876645 | 2021-11-02 | Jasper | Missouri | 29097 | 13757 | 202 |
678612 | 678612 | 2020-10-29 | Kansas City | Missouri | 14777 | 202 |
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);