ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where deaths = 82 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2351355 | 2351355 | 2022-03-28 | Henry | Missouri | 29083 | 5730 | 82 |
2348103 | 2348103 | 2022-03-27 | Henry | Missouri | 29083 | 5730 | 82 |
2344850 | 2344850 | 2022-03-26 | Henry | Missouri | 29083 | 5730 | 82 |
2341597 | 2341597 | 2022-03-25 | Henry | Missouri | 29083 | 5730 | 82 |
2338344 | 2338344 | 2022-03-24 | Henry | Missouri | 29083 | 5730 | 82 |
2335090 | 2335090 | 2022-03-23 | Henry | Missouri | 29083 | 5730 | 82 |
2331836 | 2331836 | 2022-03-22 | Henry | Missouri | 29083 | 5730 | 82 |
2283081 | 2283081 | 2022-03-07 | New Madrid | Missouri | 29143 | 5007 | 82 |
2279828 | 2279828 | 2022-03-06 | New Madrid | Missouri | 29143 | 5005 | 82 |
2276575 | 2276575 | 2022-03-05 | New Madrid | Missouri | 29143 | 5005 | 82 |
2273322 | 2273322 | 2022-03-04 | New Madrid | Missouri | 29143 | 5005 | 82 |
2260248 | 2260248 | 2022-02-28 | Bates | Missouri | 29013 | 3717 | 82 |
2256997 | 2256997 | 2022-02-27 | Bates | Missouri | 29013 | 3716 | 82 |
2253746 | 2253746 | 2022-02-26 | Bates | Missouri | 29013 | 3716 | 82 |
2250495 | 2250495 | 2022-02-25 | Bates | Missouri | 29013 | 3716 | 82 |
2247244 | 2247244 | 2022-02-24 | Bates | Missouri | 29013 | 3712 | 82 |
2136652 | 2136652 | 2022-01-21 | Benton | Missouri | 29015 | 3523 | 82 |
2113963 | 2113963 | 2022-01-14 | Platte | Missouri | 29165 | 8331 | 82 |
2110711 | 2110711 | 2022-01-13 | Platte | Missouri | 29165 | 8246 | 82 |
2107460 | 2107460 | 2022-01-12 | Platte | Missouri | 29165 | 8123 | 82 |
2104152 | 2104152 | 2022-01-11 | Crawford | Missouri | 29055 | 4443 | 82 |
2104236 | 2104236 | 2022-01-11 | Warren | Missouri | 29219 | 6752 | 82 |
2078197 | 2078197 | 2022-01-03 | Polk | Missouri | 29167 | 5926 | 82 |
2074946 | 2074946 | 2022-01-02 | Polk | Missouri | 29167 | 5869 | 82 |
2071695 | 2071695 | 2022-01-01 | Polk | Missouri | 29167 | 5869 | 82 |
2068444 | 2068444 | 2021-12-31 | Polk | Missouri | 29167 | 5869 | 82 |
2065193 | 2065193 | 2021-12-30 | Polk | Missouri | 29167 | 5869 | 82 |
2061943 | 2061943 | 2021-12-29 | Polk | Missouri | 29167 | 5844 | 82 |
2058694 | 2058694 | 2021-12-28 | Polk | Missouri | 29167 | 5819 | 82 |
2055363 | 2055363 | 2021-12-27 | Audrain | Missouri | 29007 | 4414 | 82 |
2052113 | 2052113 | 2021-12-26 | Audrain | Missouri | 29007 | 4389 | 82 |
2048863 | 2048863 | 2021-12-25 | Audrain | Missouri | 29007 | 4389 | 82 |
2045613 | 2045613 | 2021-12-24 | Audrain | Missouri | 29007 | 4389 | 82 |
2042363 | 2042363 | 2021-12-23 | Audrain | Missouri | 29007 | 4389 | 82 |
2039114 | 2039114 | 2021-12-22 | Audrain | Missouri | 29007 | 4372 | 82 |
2039200 | 2039200 | 2021-12-22 | Randolph | Missouri | 29175 | 4190 | 82 |
2035864 | 2035864 | 2021-12-21 | Audrain | Missouri | 29007 | 4361 | 82 |
2035950 | 2035950 | 2021-12-21 | Randolph | Missouri | 29175 | 4172 | 82 |
2032700 | 2032700 | 2021-12-20 | Randolph | Missouri | 29175 | 4161 | 82 |
2029449 | 2029449 | 2021-12-19 | Randolph | Missouri | 29175 | 4156 | 82 |
2026198 | 2026198 | 2021-12-18 | Randolph | Missouri | 29175 | 4155 | 82 |
2022947 | 2022947 | 2021-12-17 | Randolph | Missouri | 29175 | 4132 | 82 |
2019696 | 2019696 | 2021-12-16 | Randolph | Missouri | 29175 | 4111 | 82 |
2016446 | 2016446 | 2021-12-15 | Randolph | Missouri | 29175 | 4088 | 82 |
2009965 | 2009965 | 2021-12-13 | Vernon | Missouri | 29217 | 3404 | 82 |
2006714 | 2006714 | 2021-12-12 | Vernon | Missouri | 29217 | 3403 | 82 |
2003463 | 2003463 | 2021-12-11 | Vernon | Missouri | 29217 | 3399 | 82 |
2000213 | 2000213 | 2021-12-10 | Vernon | Missouri | 29217 | 3393 | 82 |
1996962 | 1996962 | 2021-12-09 | Vernon | Missouri | 29217 | 3385 | 82 |
1993711 | 1993711 | 2021-12-08 | Vernon | Missouri | 29217 | 3369 | 82 |
1990460 | 1990460 | 2021-12-07 | Vernon | Missouri | 29217 | 3355 | 82 |
1987210 | 1987210 | 2021-12-06 | Vernon | Missouri | 29217 | 3348 | 82 |
1983960 | 1983960 | 2021-12-05 | Vernon | Missouri | 29217 | 3343 | 82 |
1980710 | 1980710 | 2021-12-04 | Vernon | Missouri | 29217 | 3333 | 82 |
1977460 | 1977460 | 2021-12-03 | Vernon | Missouri | 29217 | 3310 | 82 |
1974210 | 1974210 | 2021-12-02 | Vernon | Missouri | 29217 | 3310 | 82 |
1970961 | 1970961 | 2021-12-01 | Vernon | Missouri | 29217 | 3308 | 82 |
1967711 | 1967711 | 2021-11-30 | Vernon | Missouri | 29217 | 3293 | 82 |
1964459 | 1964459 | 2021-11-29 | Vernon | Missouri | 29217 | 3291 | 82 |
1925427 | 1925427 | 2021-11-17 | Pulaski | Missouri | 29169 | 5453 | 82 |
1922178 | 1922178 | 2021-11-16 | Pulaski | Missouri | 29169 | 5446 | 82 |
1714256 | 1714256 | 2021-09-13 | Webster | Missouri | 29225 | 5374 | 82 |
1711010 | 1711010 | 2021-09-12 | Webster | Missouri | 29225 | 5365 | 82 |
1707763 | 1707763 | 2021-09-11 | Webster | Missouri | 29225 | 5356 | 82 |
1704516 | 1704516 | 2021-09-10 | Webster | Missouri | 29225 | 5342 | 82 |
1701266 | 1701266 | 2021-09-09 | Webster | Missouri | 29225 | 5320 | 82 |
1698017 | 1698017 | 2021-09-08 | Webster | Missouri | 29225 | 5308 | 82 |
1694769 | 1694769 | 2021-09-07 | Webster | Missouri | 29225 | 5291 | 82 |
1691520 | 1691520 | 2021-09-06 | Webster | Missouri | 29225 | 5282 | 82 |
1688270 | 1688270 | 2021-09-05 | Webster | Missouri | 29225 | 5265 | 82 |
1685020 | 1685020 | 2021-09-04 | Webster | Missouri | 29225 | 5258 | 82 |
1681769 | 1681769 | 2021-09-03 | Webster | Missouri | 29225 | 5252 | 82 |
1678521 | 1678521 | 2021-09-02 | Webster | Missouri | 29225 | 5236 | 82 |
1675273 | 1675273 | 2021-09-01 | Webster | Missouri | 29225 | 5223 | 82 |
1672025 | 1672025 | 2021-08-31 | Webster | Missouri | 29225 | 5199 | 82 |
1623269 | 1623269 | 2021-08-16 | Pettis | Missouri | 29159 | 6221 | 82 |
1620022 | 1620022 | 2021-08-15 | Pettis | Missouri | 29159 | 6215 | 82 |
1616774 | 1616774 | 2021-08-14 | Pettis | Missouri | 29159 | 6213 | 82 |
1613526 | 1613526 | 2021-08-13 | Pettis | Missouri | 29159 | 6168 | 82 |
1610277 | 1610277 | 2021-08-12 | Pettis | Missouri | 29159 | 6124 | 82 |
1327792 | 1327792 | 2021-05-17 | Lawrence | Missouri | 29109 | 3415 | 82 |
1324546 | 1324546 | 2021-05-16 | Lawrence | Missouri | 29109 | 3414 | 82 |
1321300 | 1321300 | 2021-05-15 | Lawrence | Missouri | 29109 | 3414 | 82 |
1318054 | 1318054 | 2021-05-14 | Lawrence | Missouri | 29109 | 3407 | 82 |
1314806 | 1314806 | 2021-05-13 | Lawrence | Missouri | 29109 | 3405 | 82 |
1311560 | 1311560 | 2021-05-12 | Lawrence | Missouri | 29109 | 3406 | 82 |
1308313 | 1308313 | 2021-05-11 | Lawrence | Missouri | 29109 | 3404 | 82 |
1305067 | 1305067 | 2021-05-10 | Lawrence | Missouri | 29109 | 3401 | 82 |
1301821 | 1301821 | 2021-05-09 | Lawrence | Missouri | 29109 | 3400 | 82 |
1298573 | 1298573 | 2021-05-08 | Lawrence | Missouri | 29109 | 3398 | 82 |
1295327 | 1295327 | 2021-05-07 | Lawrence | Missouri | 29109 | 3396 | 82 |
1292081 | 1292081 | 2021-05-06 | Lawrence | Missouri | 29109 | 3392 | 82 |
1288835 | 1288835 | 2021-05-05 | Lawrence | Missouri | 29109 | 3388 | 82 |
1285589 | 1285589 | 2021-05-04 | Lawrence | Missouri | 29109 | 3385 | 82 |
1123181 | 1123181 | 2021-03-15 | Camden | Missouri | 29029 | 3977 | 82 |
1119934 | 1119934 | 2021-03-14 | Camden | Missouri | 29029 | 3977 | 82 |
1116687 | 1116687 | 2021-03-13 | Camden | Missouri | 29029 | 3977 | 82 |
1113441 | 1113441 | 2021-03-12 | Camden | Missouri | 29029 | 3972 | 82 |
1110195 | 1110195 | 2021-03-11 | Camden | Missouri | 29029 | 3965 | 82 |
1106949 | 1106949 | 2021-03-10 | Camden | Missouri | 29029 | 3964 | 82 |
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);