ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
195 rows where deaths = 69 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Newton 18
- Laclede 15
- Pulaski 10
- Wright 10
- Dent 9
- Grundy 8
- Butler 7
- Callaway 7
- Cass 7
- Douglas 7
- Johnson 7
- Lincoln 7
- Pettis 7
- St. Francois 7
- Stoddard 7
- Camden 6
- Dallas 6
- Jefferson 6
- Kansas City 6
- Miller 6
- Boone 5
- New Madrid 5
- Platte 5
- Cape Girardeau 3
- Texas 3
- Bates 2
- Christian 2
- Clay 2
- Howell 2
- Clinton 1
- …
state 1
- Missouri · 195 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501115 | 2501115 | 2022-05-13 | Grundy | Missouri | 29079 | 2543 | 69 |
2497857 | 2497857 | 2022-05-12 | Grundy | Missouri | 29079 | 2533 | 69 |
2494599 | 2494599 | 2022-05-11 | Grundy | Missouri | 29079 | 2533 | 69 |
2491341 | 2491341 | 2022-05-10 | Grundy | Missouri | 29079 | 2533 | 69 |
2488083 | 2488083 | 2022-05-09 | Grundy | Missouri | 29079 | 2533 | 69 |
2484826 | 2484826 | 2022-05-08 | Grundy | Missouri | 29079 | 2533 | 69 |
2481568 | 2481568 | 2022-05-07 | Grundy | Missouri | 29079 | 2533 | 69 |
2478310 | 2478310 | 2022-05-06 | Grundy | Missouri | 29079 | 2533 | 69 |
2244016 | 2244016 | 2022-02-23 | Dallas | Missouri | 29059 | 3761 | 69 |
2244019 | 2244019 | 2022-02-23 | Dent | Missouri | 29065 | 3218 | 69 |
2240765 | 2240765 | 2022-02-22 | Dallas | Missouri | 29059 | 3761 | 69 |
2240768 | 2240768 | 2022-02-22 | Dent | Missouri | 29065 | 3210 | 69 |
2237514 | 2237514 | 2022-02-21 | Dallas | Missouri | 29059 | 3751 | 69 |
2237517 | 2237517 | 2022-02-21 | Dent | Missouri | 29065 | 3195 | 69 |
2234263 | 2234263 | 2022-02-20 | Dallas | Missouri | 29059 | 3751 | 69 |
2234266 | 2234266 | 2022-02-20 | Dent | Missouri | 29065 | 3195 | 69 |
2231012 | 2231012 | 2022-02-19 | Dallas | Missouri | 29059 | 3751 | 69 |
2231015 | 2231015 | 2022-02-19 | Dent | Missouri | 29065 | 3195 | 69 |
2227761 | 2227761 | 2022-02-18 | Dallas | Missouri | 29059 | 3751 | 69 |
2227764 | 2227764 | 2022-02-18 | Dent | Missouri | 29065 | 3195 | 69 |
2224513 | 2224513 | 2022-02-17 | Dent | Missouri | 29065 | 3194 | 69 |
2221262 | 2221262 | 2022-02-16 | Dent | Missouri | 29065 | 3192 | 69 |
2218011 | 2218011 | 2022-02-15 | Dent | Missouri | 29065 | 3187 | 69 |
2191988 | 2191988 | 2022-02-07 | Douglas | Missouri | 29067 | 2438 | 69 |
2188735 | 2188735 | 2022-02-06 | Douglas | Missouri | 29067 | 2437 | 69 |
2185482 | 2185482 | 2022-02-05 | Douglas | Missouri | 29067 | 2434 | 69 |
2182230 | 2182230 | 2022-02-04 | Douglas | Missouri | 29067 | 2427 | 69 |
2178978 | 2178978 | 2022-02-03 | Douglas | Missouri | 29067 | 2419 | 69 |
2175726 | 2175726 | 2022-02-02 | Douglas | Missouri | 29067 | 2404 | 69 |
2172473 | 2172473 | 2022-02-01 | Douglas | Missouri | 29067 | 2376 | 69 |
2133399 | 2133399 | 2022-01-20 | Bates | Missouri | 29013 | 3295 | 69 |
2133509 | 2133509 | 2022-01-20 | Wright | Missouri | 29229 | 3289 | 69 |
2130146 | 2130146 | 2022-01-19 | Bates | Missouri | 29013 | 3244 | 69 |
2130256 | 2130256 | 2022-01-19 | Wright | Missouri | 29229 | 3228 | 69 |
2127002 | 2127002 | 2022-01-18 | Wright | Missouri | 29229 | 3180 | 69 |
2123750 | 2123750 | 2022-01-17 | Wright | Missouri | 29229 | 3132 | 69 |
2120498 | 2120498 | 2022-01-16 | Wright | Missouri | 29229 | 3132 | 69 |
2117246 | 2117246 | 2022-01-15 | Wright | Missouri | 29229 | 3132 | 69 |
2113995 | 2113995 | 2022-01-14 | Wright | Missouri | 29229 | 3080 | 69 |
2110743 | 2110743 | 2022-01-13 | Wright | Missouri | 29229 | 3055 | 69 |
2107492 | 2107492 | 2022-01-12 | Wright | Missouri | 29229 | 3032 | 69 |
2104241 | 2104241 | 2022-01-11 | Wright | Missouri | 29229 | 3009 | 69 |
2084706 | 2084706 | 2022-01-05 | Ray | Missouri | 29177 | 3893 | 69 |
2032720 | 2032720 | 2021-12-20 | Texas | Missouri | 29215 | 3456 | 69 |
2029469 | 2029469 | 2021-12-19 | Texas | Missouri | 29215 | 3456 | 69 |
2026218 | 2026218 | 2021-12-18 | Texas | Missouri | 29215 | 3454 | 69 |
1941665 | 1941665 | 2021-11-22 | New Madrid | Missouri | 29143 | 3425 | 69 |
1941676 | 1941676 | 2021-11-22 | Platte | Missouri | 29165 | 6367 | 69 |
1938415 | 1938415 | 2021-11-21 | New Madrid | Missouri | 29143 | 3425 | 69 |
1938426 | 1938426 | 2021-11-21 | Platte | Missouri | 29165 | 6361 | 69 |
1935165 | 1935165 | 2021-11-20 | New Madrid | Missouri | 29143 | 3424 | 69 |
1935176 | 1935176 | 2021-11-20 | Platte | Missouri | 29165 | 6342 | 69 |
1931915 | 1931915 | 2021-11-19 | New Madrid | Missouri | 29143 | 3421 | 69 |
1931926 | 1931926 | 2021-11-19 | Platte | Missouri | 29165 | 6319 | 69 |
1928664 | 1928664 | 2021-11-18 | New Madrid | Missouri | 29143 | 3415 | 69 |
1928675 | 1928675 | 2021-11-18 | Platte | Missouri | 29165 | 6303 | 69 |
1873406 | 1873406 | 2021-11-01 | Lincoln | Missouri | 29113 | 9361 | 69 |
1870157 | 1870157 | 2021-10-31 | Lincoln | Missouri | 29113 | 9353 | 69 |
1866908 | 1866908 | 2021-10-30 | Lincoln | Missouri | 29113 | 9336 | 69 |
1863659 | 1863659 | 2021-10-29 | Lincoln | Missouri | 29113 | 9317 | 69 |
1860410 | 1860410 | 2021-10-28 | Lincoln | Missouri | 29113 | 9297 | 69 |
1857161 | 1857161 | 2021-10-27 | Lincoln | Missouri | 29113 | 9280 | 69 |
1853912 | 1853912 | 2021-10-26 | Lincoln | Missouri | 29113 | 9261 | 69 |
1850618 | 1850618 | 2021-10-25 | Callaway | Missouri | 29027 | 7414 | 69 |
1850710 | 1850710 | 2021-10-25 | Stoddard | Missouri | 29207 | 4376 | 69 |
1847368 | 1847368 | 2021-10-24 | Callaway | Missouri | 29027 | 7411 | 69 |
1847460 | 1847460 | 2021-10-24 | Stoddard | Missouri | 29207 | 4376 | 69 |
1844118 | 1844118 | 2021-10-23 | Callaway | Missouri | 29027 | 7409 | 69 |
1844210 | 1844210 | 2021-10-23 | Stoddard | Missouri | 29207 | 4373 | 69 |
1840868 | 1840868 | 2021-10-22 | Callaway | Missouri | 29027 | 7403 | 69 |
1840960 | 1840960 | 2021-10-22 | Stoddard | Missouri | 29207 | 4365 | 69 |
1837619 | 1837619 | 2021-10-21 | Callaway | Missouri | 29027 | 7397 | 69 |
1837711 | 1837711 | 2021-10-21 | Stoddard | Missouri | 29207 | 4352 | 69 |
1834370 | 1834370 | 2021-10-20 | Callaway | Missouri | 29027 | 7391 | 69 |
1834462 | 1834462 | 2021-10-20 | Stoddard | Missouri | 29207 | 4340 | 69 |
1831121 | 1831121 | 2021-10-19 | Callaway | Missouri | 29027 | 7384 | 69 |
1831213 | 1831213 | 2021-10-19 | Stoddard | Missouri | 29207 | 4320 | 69 |
1788915 | 1788915 | 2021-10-06 | Howell | Missouri | 29091 | 5574 | 69 |
1785667 | 1785667 | 2021-10-05 | Howell | Missouri | 29091 | 5558 | 69 |
1782384 | 1782384 | 2021-10-04 | Butler | Missouri | 29023 | 6404 | 69 |
1782423 | 1782423 | 2021-10-04 | Johnson | Missouri | 29101 | 6881 | 69 |
1779134 | 1779134 | 2021-10-03 | Butler | Missouri | 29023 | 6396 | 69 |
1779173 | 1779173 | 2021-10-03 | Johnson | Missouri | 29101 | 6871 | 69 |
1775884 | 1775884 | 2021-10-02 | Butler | Missouri | 29023 | 6382 | 69 |
1775923 | 1775923 | 2021-10-02 | Johnson | Missouri | 29101 | 6871 | 69 |
1772634 | 1772634 | 2021-10-01 | Butler | Missouri | 29023 | 6365 | 69 |
1772673 | 1772673 | 2021-10-01 | Johnson | Missouri | 29101 | 6843 | 69 |
1769385 | 1769385 | 2021-09-30 | Butler | Missouri | 29023 | 6343 | 69 |
1769424 | 1769424 | 2021-09-30 | Johnson | Missouri | 29101 | 6816 | 69 |
1766136 | 1766136 | 2021-09-29 | Butler | Missouri | 29023 | 6300 | 69 |
1766175 | 1766175 | 2021-09-29 | Johnson | Missouri | 29101 | 6790 | 69 |
1762887 | 1762887 | 2021-09-28 | Butler | Missouri | 29023 | 6276 | 69 |
1762926 | 1762926 | 2021-09-28 | Johnson | Missouri | 29101 | 6767 | 69 |
1759713 | 1759713 | 2021-09-27 | Pulaski | Missouri | 29169 | 4899 | 69 |
1756465 | 1756465 | 2021-09-26 | Pulaski | Missouri | 29169 | 4891 | 69 |
1753217 | 1753217 | 2021-09-25 | Pulaski | Missouri | 29169 | 4884 | 69 |
1749969 | 1749969 | 2021-09-24 | Pulaski | Missouri | 29169 | 4863 | 69 |
1746719 | 1746719 | 2021-09-23 | Pulaski | Missouri | 29169 | 4848 | 69 |
1743470 | 1743470 | 2021-09-22 | Pulaski | Missouri | 29169 | 4837 | 69 |
1740221 | 1740221 | 2021-09-21 | Pulaski | Missouri | 29169 | 4822 | 69 |
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);