ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where deaths = 134 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
- Cape Girardeau 38
- Butler 7
- Scott 6
- Cole 5
- Jefferson 5
- Phelps 4
- Pettis 3
- St. Charles 2
- Boone 1
- Lafayette 1
- St. Louis city 1
state 1
- Missouri · 73 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501131 | 2501131 | 2022-05-13 | Lafayette | Missouri | 29107 | 7832 | 134 |
2143237 | 2143237 | 2022-01-23 | Pettis | Missouri | 29159 | 10455 | 134 |
2139982 | 2139982 | 2022-01-22 | Pettis | Missouri | 29159 | 10348 | 134 |
2136726 | 2136726 | 2022-01-21 | Pettis | Missouri | 29159 | 10125 | 134 |
2100885 | 2100885 | 2022-01-10 | Butler | Missouri | 29023 | 7721 | 134 |
2097634 | 2097634 | 2022-01-09 | Butler | Missouri | 29023 | 7686 | 134 |
2094382 | 2094382 | 2022-01-08 | Butler | Missouri | 29023 | 7671 | 134 |
2091130 | 2091130 | 2022-01-07 | Butler | Missouri | 29023 | 7625 | 134 |
2087879 | 2087879 | 2022-01-06 | Butler | Missouri | 29023 | 7585 | 134 |
2084627 | 2084627 | 2022-01-05 | Butler | Missouri | 29023 | 7535 | 134 |
2081375 | 2081375 | 2022-01-04 | Butler | Missouri | 29023 | 7498 | 134 |
2078208 | 2078208 | 2022-01-03 | Scott | Missouri | 29201 | 8098 | 134 |
2074957 | 2074957 | 2022-01-02 | Scott | Missouri | 29201 | 8036 | 134 |
2071706 | 2071706 | 2022-01-01 | Scott | Missouri | 29201 | 8036 | 134 |
2068455 | 2068455 | 2021-12-31 | Scott | Missouri | 29201 | 8036 | 134 |
2065204 | 2065204 | 2021-12-30 | Scott | Missouri | 29201 | 8036 | 134 |
2061954 | 2061954 | 2021-12-29 | Scott | Missouri | 29201 | 8023 | 134 |
1645937 | 1645937 | 2021-08-23 | Boone | Missouri | 29019 | 22549 | 134 |
1600475 | 1600475 | 2021-08-09 | Cole | Missouri | 29051 | 11196 | 134 |
1597227 | 1597227 | 2021-08-08 | Cole | Missouri | 29051 | 11184 | 134 |
1593978 | 1593978 | 2021-08-07 | Cole | Missouri | 29051 | 11165 | 134 |
1590729 | 1590729 | 2021-08-06 | Cole | Missouri | 29051 | 11116 | 134 |
1587480 | 1587480 | 2021-08-05 | Cole | Missouri | 29051 | 11064 | 134 |
1490114 | 1490114 | 2021-07-06 | Phelps | Missouri | 29161 | 4068 | 134 |
1486867 | 1486867 | 2021-07-05 | Phelps | Missouri | 29161 | 4062 | 134 |
1483621 | 1483621 | 2021-07-04 | Phelps | Missouri | 29161 | 4048 | 134 |
1480375 | 1480375 | 2021-07-03 | Phelps | Missouri | 29161 | 4039 | 134 |
1376450 | 1376450 | 2021-06-01 | Cape Girardeau | Missouri | 29031 | 9560 | 134 |
1373204 | 1373204 | 2021-05-31 | Cape Girardeau | Missouri | 29031 | 9560 | 134 |
1369959 | 1369959 | 2021-05-30 | Cape Girardeau | Missouri | 29031 | 9560 | 134 |
1366713 | 1366713 | 2021-05-29 | Cape Girardeau | Missouri | 29031 | 9560 | 134 |
1327751 | 1327751 | 2021-05-17 | Cape Girardeau | Missouri | 29031 | 9526 | 134 |
1324505 | 1324505 | 2021-05-16 | Cape Girardeau | Missouri | 29031 | 9519 | 134 |
1321259 | 1321259 | 2021-05-15 | Cape Girardeau | Missouri | 29031 | 9519 | 134 |
1318013 | 1318013 | 2021-05-14 | Cape Girardeau | Missouri | 29031 | 9519 | 134 |
1314765 | 1314765 | 2021-05-13 | Cape Girardeau | Missouri | 29031 | 9511 | 134 |
1311519 | 1311519 | 2021-05-12 | Cape Girardeau | Missouri | 29031 | 9511 | 134 |
1308272 | 1308272 | 2021-05-11 | Cape Girardeau | Missouri | 29031 | 9491 | 134 |
1305026 | 1305026 | 2021-05-10 | Cape Girardeau | Missouri | 29031 | 9491 | 134 |
1301780 | 1301780 | 2021-05-09 | Cape Girardeau | Missouri | 29031 | 9483 | 134 |
1298532 | 1298532 | 2021-05-08 | Cape Girardeau | Missouri | 29031 | 9483 | 134 |
1295286 | 1295286 | 2021-05-07 | Cape Girardeau | Missouri | 29031 | 9483 | 134 |
1292040 | 1292040 | 2021-05-06 | Cape Girardeau | Missouri | 29031 | 9471 | 134 |
1288794 | 1288794 | 2021-05-05 | Cape Girardeau | Missouri | 29031 | 9471 | 134 |
1285548 | 1285548 | 2021-05-04 | Cape Girardeau | Missouri | 29031 | 9451 | 134 |
1282302 | 1282302 | 2021-05-03 | Cape Girardeau | Missouri | 29031 | 9451 | 134 |
1279055 | 1279055 | 2021-05-02 | Cape Girardeau | Missouri | 29031 | 9446 | 134 |
1275808 | 1275808 | 2021-05-01 | Cape Girardeau | Missouri | 29031 | 9446 | 134 |
1272561 | 1272561 | 2021-04-30 | Cape Girardeau | Missouri | 29031 | 9446 | 134 |
1269314 | 1269314 | 2021-04-29 | Cape Girardeau | Missouri | 29031 | 9435 | 134 |
1266067 | 1266067 | 2021-04-28 | Cape Girardeau | Missouri | 29031 | 9435 | 134 |
1262820 | 1262820 | 2021-04-27 | Cape Girardeau | Missouri | 29031 | 9427 | 134 |
1259573 | 1259573 | 2021-04-26 | Cape Girardeau | Missouri | 29031 | 9427 | 134 |
1256326 | 1256326 | 2021-04-25 | Cape Girardeau | Missouri | 29031 | 9423 | 134 |
1253079 | 1253079 | 2021-04-24 | Cape Girardeau | Missouri | 29031 | 9423 | 134 |
1249832 | 1249832 | 2021-04-23 | Cape Girardeau | Missouri | 29031 | 9423 | 134 |
1246585 | 1246585 | 2021-04-22 | Cape Girardeau | Missouri | 29031 | 9420 | 134 |
1243338 | 1243338 | 2021-04-21 | Cape Girardeau | Missouri | 29031 | 9420 | 134 |
1240091 | 1240091 | 2021-04-20 | Cape Girardeau | Missouri | 29031 | 9410 | 134 |
1236844 | 1236844 | 2021-04-19 | Cape Girardeau | Missouri | 29031 | 9410 | 134 |
1233597 | 1233597 | 2021-04-18 | Cape Girardeau | Missouri | 29031 | 9407 | 134 |
1230349 | 1230349 | 2021-04-17 | Cape Girardeau | Missouri | 29031 | 9407 | 134 |
1227101 | 1227101 | 2021-04-16 | Cape Girardeau | Missouri | 29031 | 9407 | 134 |
1223853 | 1223853 | 2021-04-15 | Cape Girardeau | Missouri | 29031 | 9401 | 134 |
1220606 | 1220606 | 2021-04-14 | Cape Girardeau | Missouri | 29031 | 9401 | 134 |
896022 | 896022 | 2021-01-04 | Jefferson | Missouri | 29099 | 17360 | 134 |
892775 | 892775 | 2021-01-03 | Jefferson | Missouri | 29099 | 16795 | 134 |
889529 | 889529 | 2021-01-02 | Jefferson | Missouri | 29099 | 16795 | 134 |
886283 | 886283 | 2021-01-01 | Jefferson | Missouri | 29099 | 16795 | 134 |
883038 | 883038 | 2020-12-31 | Jefferson | Missouri | 29099 | 16795 | 134 |
607293 | 607293 | 2020-10-07 | St. Charles | Missouri | 29183 | 8660 | 134 |
604050 | 604050 | 2020-10-06 | St. Charles | Missouri | 29183 | 8554 | 134 |
210704 | 210704 | 2020-06-05 | St. Louis city | Missouri | 29510 | 2053 | 134 |
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);