ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where deaths = 132 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 15
county 15
- Cape Girardeau 41
- Scott 33
- Pettis 10
- Taney 8
- Buchanan 6
- Webster 6
- Jasper 4
- Joplin 3
- St. Francois 3
- Phelps 2
- St. Louis city 2
- Barry 1
- Christian 1
- Jefferson 1
- St. Charles 1
state 1
- Missouri · 122 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501080 | 2501080 | 2022-05-13 | Barry | Missouri | 29009 | 6648 | 132 |
2211590 | 2211590 | 2022-02-13 | Webster | Missouri | 29225 | 8774 | 132 |
2208337 | 2208337 | 2022-02-12 | Webster | Missouri | 29225 | 8774 | 132 |
2205084 | 2205084 | 2022-02-11 | Webster | Missouri | 29225 | 8774 | 132 |
2201831 | 2201831 | 2022-02-10 | Webster | Missouri | 29225 | 8774 | 132 |
2198577 | 2198577 | 2022-02-09 | Webster | Missouri | 29225 | 8727 | 132 |
2195323 | 2195323 | 2022-02-08 | Webster | Missouri | 29225 | 8687 | 132 |
2133474 | 2133474 | 2022-01-20 | Pettis | Missouri | 29159 | 10065 | 132 |
2130221 | 2130221 | 2022-01-19 | Pettis | Missouri | 29159 | 9947 | 132 |
2126967 | 2126967 | 2022-01-18 | Pettis | Missouri | 29159 | 9746 | 132 |
2123715 | 2123715 | 2022-01-17 | Pettis | Missouri | 29159 | 9518 | 132 |
2120463 | 2120463 | 2022-01-16 | Pettis | Missouri | 29159 | 9518 | 132 |
2117211 | 2117211 | 2022-01-15 | Pettis | Missouri | 29159 | 9518 | 132 |
2113960 | 2113960 | 2022-01-14 | Pettis | Missouri | 29159 | 9216 | 132 |
2110708 | 2110708 | 2022-01-13 | Pettis | Missouri | 29159 | 9199 | 132 |
2107457 | 2107457 | 2022-01-12 | Pettis | Missouri | 29159 | 9131 | 132 |
2104206 | 2104206 | 2022-01-11 | Pettis | Missouri | 29159 | 9032 | 132 |
2032707 | 2032707 | 2021-12-20 | Scott | Missouri | 29201 | 7902 | 132 |
2029456 | 2029456 | 2021-12-19 | Scott | Missouri | 29201 | 7901 | 132 |
2026205 | 2026205 | 2021-12-18 | Scott | Missouri | 29201 | 7896 | 132 |
2022954 | 2022954 | 2021-12-17 | Scott | Missouri | 29201 | 7873 | 132 |
2019703 | 2019703 | 2021-12-16 | Scott | Missouri | 29201 | 7837 | 132 |
2016453 | 2016453 | 2021-12-15 | Scott | Missouri | 29201 | 7819 | 132 |
2013202 | 2013202 | 2021-12-14 | Scott | Missouri | 29201 | 7811 | 132 |
2009951 | 2009951 | 2021-12-13 | Scott | Missouri | 29201 | 7796 | 132 |
2006700 | 2006700 | 2021-12-12 | Scott | Missouri | 29201 | 7789 | 132 |
2003449 | 2003449 | 2021-12-11 | Scott | Missouri | 29201 | 7783 | 132 |
2000199 | 2000199 | 2021-12-10 | Scott | Missouri | 29201 | 7776 | 132 |
1996948 | 1996948 | 2021-12-09 | Scott | Missouri | 29201 | 7759 | 132 |
1993697 | 1993697 | 2021-12-08 | Scott | Missouri | 29201 | 7742 | 132 |
1990446 | 1990446 | 2021-12-07 | Scott | Missouri | 29201 | 7719 | 132 |
1987196 | 1987196 | 2021-12-06 | Scott | Missouri | 29201 | 7685 | 132 |
1983946 | 1983946 | 2021-12-05 | Scott | Missouri | 29201 | 7668 | 132 |
1980696 | 1980696 | 2021-12-04 | Scott | Missouri | 29201 | 7650 | 132 |
1977446 | 1977446 | 2021-12-03 | Scott | Missouri | 29201 | 7619 | 132 |
1974196 | 1974196 | 2021-12-02 | Scott | Missouri | 29201 | 7619 | 132 |
1970947 | 1970947 | 2021-12-01 | Scott | Missouri | 29201 | 7600 | 132 |
1967697 | 1967697 | 2021-11-30 | Scott | Missouri | 29201 | 7590 | 132 |
1964445 | 1964445 | 2021-11-29 | Scott | Missouri | 29201 | 7569 | 132 |
1961194 | 1961194 | 2021-11-28 | Scott | Missouri | 29201 | 7539 | 132 |
1957943 | 1957943 | 2021-11-27 | Scott | Missouri | 29201 | 7539 | 132 |
1954692 | 1954692 | 2021-11-26 | Scott | Missouri | 29201 | 7539 | 132 |
1951441 | 1951441 | 2021-11-25 | Scott | Missouri | 29201 | 7539 | 132 |
1948190 | 1948190 | 2021-11-24 | Scott | Missouri | 29201 | 7539 | 132 |
1944939 | 1944939 | 2021-11-23 | Scott | Missouri | 29201 | 7495 | 132 |
1941688 | 1941688 | 2021-11-22 | Scott | Missouri | 29201 | 7483 | 132 |
1938438 | 1938438 | 2021-11-21 | Scott | Missouri | 29201 | 7481 | 132 |
1935188 | 1935188 | 2021-11-20 | Scott | Missouri | 29201 | 7481 | 132 |
1931938 | 1931938 | 2021-11-19 | Scott | Missouri | 29201 | 7467 | 132 |
1928687 | 1928687 | 2021-11-18 | Scott | Missouri | 29201 | 7439 | 132 |
1714243 | 1714243 | 2021-09-13 | St. Francois | Missouri | 29187 | 11062 | 132 |
1710997 | 1710997 | 2021-09-12 | St. Francois | Missouri | 29187 | 11053 | 132 |
1707750 | 1707750 | 2021-09-11 | St. Francois | Missouri | 29187 | 11007 | 132 |
1694763 | 1694763 | 2021-09-07 | Taney | Missouri | 29213 | 8522 | 132 |
1691514 | 1691514 | 2021-09-06 | Taney | Missouri | 29213 | 8513 | 132 |
1688264 | 1688264 | 2021-09-05 | Taney | Missouri | 29213 | 8495 | 132 |
1685014 | 1685014 | 2021-09-04 | Taney | Missouri | 29213 | 8476 | 132 |
1681763 | 1681763 | 2021-09-03 | Taney | Missouri | 29213 | 8466 | 132 |
1678515 | 1678515 | 2021-09-02 | Taney | Missouri | 29213 | 8448 | 132 |
1675267 | 1675267 | 2021-09-01 | Taney | Missouri | 29213 | 8431 | 132 |
1672019 | 1672019 | 2021-08-31 | Taney | Missouri | 29213 | 8416 | 132 |
1632980 | 1632980 | 2021-08-19 | Joplin | Missouri | 8012 | 132 | |
1629733 | 1629733 | 2021-08-18 | Joplin | Missouri | 7969 | 132 | |
1626456 | 1626456 | 2021-08-17 | Christian | Missouri | 29043 | 12020 | 132 |
1626486 | 1626486 | 2021-08-17 | Joplin | Missouri | 7938 | 132 | |
1477094 | 1477094 | 2021-07-02 | Jasper | Missouri | 29097 | 10255 | 132 |
1477128 | 1477128 | 2021-07-02 | Phelps | Missouri | 29161 | 4038 | 132 |
1473848 | 1473848 | 2021-07-01 | Jasper | Missouri | 29097 | 10217 | 132 |
1473882 | 1473882 | 2021-07-01 | Phelps | Missouri | 29161 | 4029 | 132 |
1470602 | 1470602 | 2021-06-30 | Jasper | Missouri | 29097 | 10155 | 132 |
1467357 | 1467357 | 2021-06-29 | Jasper | Missouri | 29097 | 10113 | 132 |
1103704 | 1103704 | 2021-03-09 | Cape Girardeau | Missouri | 29031 | 9318 | 132 |
1100458 | 1100458 | 2021-03-08 | Cape Girardeau | Missouri | 29031 | 9318 | 132 |
1097211 | 1097211 | 2021-03-07 | Cape Girardeau | Missouri | 29031 | 9315 | 132 |
1093964 | 1093964 | 2021-03-06 | Cape Girardeau | Missouri | 29031 | 9315 | 132 |
1090718 | 1090718 | 2021-03-05 | Cape Girardeau | Missouri | 29031 | 9315 | 132 |
1087473 | 1087473 | 2021-03-04 | Cape Girardeau | Missouri | 29031 | 9312 | 132 |
1084228 | 1084228 | 2021-03-03 | Cape Girardeau | Missouri | 29031 | 9312 | 132 |
1080982 | 1080982 | 2021-03-02 | Cape Girardeau | Missouri | 29031 | 9308 | 132 |
1077736 | 1077736 | 2021-03-01 | Cape Girardeau | Missouri | 29031 | 9308 | 132 |
1074490 | 1074490 | 2021-02-28 | Cape Girardeau | Missouri | 29031 | 9293 | 132 |
1071244 | 1071244 | 2021-02-27 | Cape Girardeau | Missouri | 29031 | 9293 | 132 |
1067999 | 1067999 | 2021-02-26 | Cape Girardeau | Missouri | 29031 | 9293 | 132 |
1064754 | 1064754 | 2021-02-25 | Cape Girardeau | Missouri | 29031 | 9281 | 132 |
1061510 | 1061510 | 2021-02-24 | Cape Girardeau | Missouri | 29031 | 9261 | 132 |
1058264 | 1058264 | 2021-02-23 | Cape Girardeau | Missouri | 29031 | 9261 | 132 |
1055018 | 1055018 | 2021-02-22 | Cape Girardeau | Missouri | 29031 | 9261 | 132 |
1051771 | 1051771 | 2021-02-21 | Cape Girardeau | Missouri | 29031 | 9250 | 132 |
1048524 | 1048524 | 2021-02-20 | Cape Girardeau | Missouri | 29031 | 9250 | 132 |
1045278 | 1045278 | 2021-02-19 | Cape Girardeau | Missouri | 29031 | 9250 | 132 |
1042033 | 1042033 | 2021-02-18 | Cape Girardeau | Missouri | 29031 | 9233 | 132 |
1038788 | 1038788 | 2021-02-17 | Cape Girardeau | Missouri | 29031 | 9233 | 132 |
1035543 | 1035543 | 2021-02-16 | Cape Girardeau | Missouri | 29031 | 9181 | 132 |
1032298 | 1032298 | 2021-02-15 | Cape Girardeau | Missouri | 29031 | 9181 | 132 |
1029051 | 1029051 | 2021-02-14 | Cape Girardeau | Missouri | 29031 | 9161 | 132 |
1025805 | 1025805 | 2021-02-13 | Cape Girardeau | Missouri | 29031 | 9161 | 132 |
1022560 | 1022560 | 2021-02-12 | Cape Girardeau | Missouri | 29031 | 9161 | 132 |
1019315 | 1019315 | 2021-02-11 | Cape Girardeau | Missouri | 29031 | 9161 | 132 |
1016070 | 1016070 | 2021-02-10 | Cape Girardeau | Missouri | 29031 | 9161 | 132 |
1012825 | 1012825 | 2021-02-09 | Cape Girardeau | Missouri | 29031 | 9118 | 132 |
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);