ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where deaths = 135 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
- Cape Girardeau 17
- Butler 10
- Washington 10
- Webster 9
- Pettis 8
- Phelps 6
- Buchanan 5
- Jasper 4
- St. Louis city 3
- Boone 1
- Scott 1
state 1
- Missouri · 74 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338415 | 2338415 | 2022-03-24 | Washington | Missouri | 29221 | 5946 | 135 |
2335161 | 2335161 | 2022-03-23 | Washington | Missouri | 29221 | 5941 | 135 |
2331907 | 2331907 | 2022-03-22 | Washington | Missouri | 29221 | 5941 | 135 |
2328654 | 2328654 | 2022-03-21 | Washington | Missouri | 29221 | 5940 | 135 |
2325402 | 2325402 | 2022-03-20 | Washington | Missouri | 29221 | 5938 | 135 |
2322148 | 2322148 | 2022-03-19 | Washington | Missouri | 29221 | 5938 | 135 |
2318894 | 2318894 | 2022-03-18 | Washington | Missouri | 29221 | 5938 | 135 |
2315641 | 2315641 | 2022-03-17 | Washington | Missouri | 29221 | 5935 | 135 |
2312388 | 2312388 | 2022-03-16 | Washington | Missouri | 29221 | 5938 | 135 |
2309135 | 2309135 | 2022-03-15 | Washington | Missouri | 29221 | 5936 | 135 |
2244101 | 2244101 | 2022-02-23 | Webster | Missouri | 29225 | 8940 | 135 |
2240850 | 2240850 | 2022-02-22 | Webster | Missouri | 29225 | 8938 | 135 |
2237599 | 2237599 | 2022-02-21 | Webster | Missouri | 29225 | 8908 | 135 |
2234348 | 2234348 | 2022-02-20 | Webster | Missouri | 29225 | 8908 | 135 |
2231097 | 2231097 | 2022-02-19 | Webster | Missouri | 29225 | 8908 | 135 |
2227846 | 2227846 | 2022-02-18 | Webster | Missouri | 29225 | 8908 | 135 |
2224595 | 2224595 | 2022-02-17 | Webster | Missouri | 29225 | 8901 | 135 |
2221344 | 2221344 | 2022-02-16 | Webster | Missouri | 29225 | 8881 | 135 |
2218093 | 2218093 | 2022-02-15 | Webster | Missouri | 29225 | 8864 | 135 |
2169268 | 2169268 | 2022-01-31 | Pettis | Missouri | 29159 | 11157 | 135 |
2166013 | 2166013 | 2022-01-30 | Pettis | Missouri | 29159 | 11142 | 135 |
2162758 | 2162758 | 2022-01-29 | Pettis | Missouri | 29159 | 11114 | 135 |
2159503 | 2159503 | 2022-01-28 | Pettis | Missouri | 29159 | 11018 | 135 |
2156249 | 2156249 | 2022-01-27 | Pettis | Missouri | 29159 | 10900 | 135 |
2152996 | 2152996 | 2022-01-26 | Pettis | Missouri | 29159 | 10753 | 135 |
2149744 | 2149744 | 2022-01-25 | Pettis | Missouri | 29159 | 10604 | 135 |
2146492 | 2146492 | 2022-01-24 | Pettis | Missouri | 29159 | 10511 | 135 |
2133404 | 2133404 | 2022-01-20 | Butler | Missouri | 29023 | 8625 | 135 |
2130151 | 2130151 | 2022-01-19 | Butler | Missouri | 29023 | 8521 | 135 |
2126897 | 2126897 | 2022-01-18 | Butler | Missouri | 29023 | 8403 | 135 |
2123645 | 2123645 | 2022-01-17 | Butler | Missouri | 29023 | 8233 | 135 |
2120393 | 2120393 | 2022-01-16 | Butler | Missouri | 29023 | 8233 | 135 |
2117141 | 2117141 | 2022-01-15 | Butler | Missouri | 29023 | 8231 | 135 |
2113890 | 2113890 | 2022-01-14 | Butler | Missouri | 29023 | 8081 | 135 |
2110638 | 2110638 | 2022-01-13 | Butler | Missouri | 29023 | 8003 | 135 |
2107387 | 2107387 | 2022-01-12 | Butler | Missouri | 29023 | 7906 | 135 |
2104136 | 2104136 | 2022-01-11 | Butler | Missouri | 29023 | 7815 | 135 |
2081460 | 2081460 | 2022-01-04 | Scott | Missouri | 29201 | 8130 | 135 |
1649186 | 1649186 | 2021-08-24 | Boone | Missouri | 29019 | 22623 | 135 |
1509592 | 1509592 | 2021-07-12 | Phelps | Missouri | 29161 | 4167 | 135 |
1506346 | 1506346 | 2021-07-11 | Phelps | Missouri | 29161 | 4166 | 135 |
1503100 | 1503100 | 2021-07-10 | Phelps | Missouri | 29161 | 4156 | 135 |
1499854 | 1499854 | 2021-07-09 | Phelps | Missouri | 29161 | 4132 | 135 |
1496608 | 1496608 | 2021-07-08 | Phelps | Missouri | 29161 | 4106 | 135 |
1493361 | 1493361 | 2021-07-07 | Phelps | Missouri | 29161 | 4078 | 135 |
1490080 | 1490080 | 2021-07-06 | Jasper | Missouri | 29097 | 10319 | 135 |
1486833 | 1486833 | 2021-07-05 | Jasper | Missouri | 29097 | 10305 | 135 |
1483587 | 1483587 | 2021-07-04 | Jasper | Missouri | 29097 | 10291 | 135 |
1480341 | 1480341 | 2021-07-03 | Jasper | Missouri | 29097 | 10263 | 135 |
1395922 | 1395922 | 2021-06-07 | Cape Girardeau | Missouri | 29031 | 9566 | 135 |
1392676 | 1392676 | 2021-06-06 | Cape Girardeau | Missouri | 29031 | 9566 | 135 |
1389431 | 1389431 | 2021-06-05 | Cape Girardeau | Missouri | 29031 | 9566 | 135 |
1386186 | 1386186 | 2021-06-04 | Cape Girardeau | Missouri | 29031 | 9566 | 135 |
1382941 | 1382941 | 2021-06-03 | Cape Girardeau | Missouri | 29031 | 9566 | 135 |
1379695 | 1379695 | 2021-06-02 | Cape Girardeau | Missouri | 29031 | 9566 | 135 |
1363467 | 1363467 | 2021-05-28 | Cape Girardeau | Missouri | 29031 | 9560 | 135 |
1360220 | 1360220 | 2021-05-27 | Cape Girardeau | Missouri | 29031 | 9553 | 135 |
1356974 | 1356974 | 2021-05-26 | Cape Girardeau | Missouri | 29031 | 9553 | 135 |
1353728 | 1353728 | 2021-05-25 | Cape Girardeau | Missouri | 29031 | 9544 | 135 |
1350482 | 1350482 | 2021-05-24 | Cape Girardeau | Missouri | 29031 | 9544 | 135 |
1347236 | 1347236 | 2021-05-23 | Cape Girardeau | Missouri | 29031 | 9539 | 135 |
1343988 | 1343988 | 2021-05-22 | Cape Girardeau | Missouri | 29031 | 9539 | 135 |
1340739 | 1340739 | 2021-05-21 | Cape Girardeau | Missouri | 29031 | 9539 | 135 |
1337492 | 1337492 | 2021-05-20 | Cape Girardeau | Missouri | 29031 | 9536 | 135 |
1334245 | 1334245 | 2021-05-19 | Cape Girardeau | Missouri | 29031 | 9536 | 135 |
1330998 | 1330998 | 2021-05-18 | Cape Girardeau | Missouri | 29031 | 9526 | 135 |
915454 | 915454 | 2021-01-10 | Buchanan | Missouri | 29021 | 8864 | 135 |
912209 | 912209 | 2021-01-09 | Buchanan | Missouri | 29021 | 8864 | 135 |
908964 | 908964 | 2021-01-08 | Buchanan | Missouri | 29021 | 8864 | 135 |
905718 | 905718 | 2021-01-07 | Buchanan | Missouri | 29021 | 8791 | 135 |
902473 | 902473 | 2021-01-06 | Buchanan | Missouri | 29021 | 8733 | 135 |
219969 | 219969 | 2020-06-08 | St. Louis city | Missouri | 29510 | 2071 | 135 |
216877 | 216877 | 2020-06-07 | St. Louis city | Missouri | 29510 | 2071 | 135 |
213788 | 213788 | 2020-06-06 | St. Louis city | Missouri | 29510 | 2068 | 135 |
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);