ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
685 rows where deaths = 22 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Schuyler 54
- Texas 51
- Lewis 42
- Andrew 39
- Cedar 29
- Dunklin 28
- Nodaway 28
- Putnam 28
- Perry 25
- Maries 22
- Dallas 21
- Howard 18
- Osage 17
- Clay 15
- Jackson 14
- Linn 14
- Pike 14
- Warren 14
- Barton 13
- Ray 12
- Taney 12
- Franklin 11
- Washington 11
- Newton 10
- Sullivan 9
- Mississippi 8
- Pettis 8
- Dent 7
- Laclede 7
- New Madrid 7
- …
state 1
- Missouri · 685 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501183 | 2501183 | 2022-05-13 | Sullivan | Missouri | 29211 | 1715 | 22 |
2497925 | 2497925 | 2022-05-12 | Sullivan | Missouri | 29211 | 1715 | 22 |
2494667 | 2494667 | 2022-05-11 | Sullivan | Missouri | 29211 | 1715 | 22 |
2491409 | 2491409 | 2022-05-10 | Sullivan | Missouri | 29211 | 1715 | 22 |
2488151 | 2488151 | 2022-05-09 | Sullivan | Missouri | 29211 | 1715 | 22 |
2484894 | 2484894 | 2022-05-08 | Sullivan | Missouri | 29211 | 1715 | 22 |
2481636 | 2481636 | 2022-05-07 | Sullivan | Missouri | 29211 | 1715 | 22 |
2478378 | 2478378 | 2022-05-06 | Sullivan | Missouri | 29211 | 1715 | 22 |
2475120 | 2475120 | 2022-05-05 | Sullivan | Missouri | 29211 | 1710 | 22 |
2328629 | 2328629 | 2022-03-21 | Putnam | Missouri | 29171 | 991 | 22 |
2325377 | 2325377 | 2022-03-20 | Putnam | Missouri | 29171 | 991 | 22 |
2322123 | 2322123 | 2022-03-19 | Putnam | Missouri | 29171 | 991 | 22 |
2318869 | 2318869 | 2022-03-18 | Putnam | Missouri | 29171 | 991 | 22 |
2315616 | 2315616 | 2022-03-17 | Putnam | Missouri | 29171 | 991 | 22 |
2312363 | 2312363 | 2022-03-16 | Putnam | Missouri | 29171 | 991 | 22 |
2309110 | 2309110 | 2022-03-15 | Putnam | Missouri | 29171 | 991 | 22 |
2283095 | 2283095 | 2022-03-07 | Putnam | Missouri | 29171 | 988 | 22 |
2279842 | 2279842 | 2022-03-06 | Putnam | Missouri | 29171 | 988 | 22 |
2276589 | 2276589 | 2022-03-05 | Putnam | Missouri | 29171 | 988 | 22 |
2273336 | 2273336 | 2022-03-04 | Putnam | Missouri | 29171 | 988 | 22 |
2270084 | 2270084 | 2022-03-03 | Putnam | Missouri | 29171 | 984 | 22 |
2266831 | 2266831 | 2022-03-02 | Putnam | Missouri | 29171 | 983 | 22 |
2263580 | 2263580 | 2022-03-01 | Putnam | Missouri | 29171 | 976 | 22 |
2260329 | 2260329 | 2022-02-28 | Putnam | Missouri | 29171 | 975 | 22 |
2257078 | 2257078 | 2022-02-27 | Putnam | Missouri | 29171 | 975 | 22 |
2253827 | 2253827 | 2022-02-26 | Putnam | Missouri | 29171 | 975 | 22 |
2250576 | 2250576 | 2022-02-25 | Putnam | Missouri | 29171 | 975 | 22 |
2247325 | 2247325 | 2022-02-24 | Putnam | Missouri | 29171 | 976 | 22 |
2244074 | 2244074 | 2022-02-23 | Putnam | Missouri | 29171 | 975 | 22 |
2240823 | 2240823 | 2022-02-22 | Putnam | Missouri | 29171 | 974 | 22 |
2237572 | 2237572 | 2022-02-21 | Putnam | Missouri | 29171 | 972 | 22 |
2234321 | 2234321 | 2022-02-20 | Putnam | Missouri | 29171 | 972 | 22 |
2231070 | 2231070 | 2022-02-19 | Putnam | Missouri | 29171 | 972 | 22 |
2227819 | 2227819 | 2022-02-18 | Putnam | Missouri | 29171 | 972 | 22 |
2224568 | 2224568 | 2022-02-17 | Putnam | Missouri | 29171 | 967 | 22 |
2221317 | 2221317 | 2022-02-16 | Putnam | Missouri | 29171 | 965 | 22 |
2218066 | 2218066 | 2022-02-15 | Putnam | Missouri | 29171 | 960 | 22 |
2191999 | 2191999 | 2022-02-07 | Howard | Missouri | 29089 | 2093 | 22 |
2188746 | 2188746 | 2022-02-06 | Howard | Missouri | 29089 | 2093 | 22 |
2185493 | 2185493 | 2022-02-05 | Howard | Missouri | 29089 | 2091 | 22 |
2182241 | 2182241 | 2022-02-04 | Howard | Missouri | 29089 | 2091 | 22 |
2178989 | 2178989 | 2022-02-03 | Howard | Missouri | 29089 | 2090 | 22 |
2175737 | 2175737 | 2022-02-02 | Howard | Missouri | 29089 | 2072 | 22 |
2172484 | 2172484 | 2022-02-01 | Howard | Missouri | 29089 | 2064 | 22 |
2169231 | 2169231 | 2022-01-31 | Howard | Missouri | 29089 | 2061 | 22 |
2165976 | 2165976 | 2022-01-30 | Howard | Missouri | 29089 | 2057 | 22 |
2162721 | 2162721 | 2022-01-29 | Howard | Missouri | 29089 | 2057 | 22 |
2159466 | 2159466 | 2022-01-28 | Howard | Missouri | 29089 | 2035 | 22 |
2156212 | 2156212 | 2022-01-27 | Howard | Missouri | 29089 | 2018 | 22 |
2152959 | 2152959 | 2022-01-26 | Howard | Missouri | 29089 | 1993 | 22 |
2149707 | 2149707 | 2022-01-25 | Howard | Missouri | 29089 | 1974 | 22 |
2146455 | 2146455 | 2022-01-24 | Howard | Missouri | 29089 | 1964 | 22 |
2143200 | 2143200 | 2022-01-23 | Howard | Missouri | 29089 | 1953 | 22 |
2139945 | 2139945 | 2022-01-22 | Howard | Missouri | 29089 | 1940 | 22 |
2136689 | 2136689 | 2022-01-21 | Howard | Missouri | 29089 | 1919 | 22 |
2100968 | 2100968 | 2022-01-10 | Schuyler | Missouri | 29197 | 577 | 22 |
2097717 | 2097717 | 2022-01-09 | Schuyler | Missouri | 29197 | 577 | 22 |
2094465 | 2094465 | 2022-01-08 | Schuyler | Missouri | 29197 | 576 | 22 |
2091213 | 2091213 | 2022-01-07 | Schuyler | Missouri | 29197 | 571 | 22 |
2087962 | 2087962 | 2022-01-06 | Schuyler | Missouri | 29197 | 570 | 22 |
2084710 | 2084710 | 2022-01-05 | Schuyler | Missouri | 29197 | 562 | 22 |
2081427 | 2081427 | 2022-01-04 | Maries | Missouri | 29125 | 1189 | 22 |
2081458 | 2081458 | 2022-01-04 | Schuyler | Missouri | 29197 | 559 | 22 |
2078175 | 2078175 | 2022-01-03 | Maries | Missouri | 29125 | 1187 | 22 |
2078206 | 2078206 | 2022-01-03 | Schuyler | Missouri | 29197 | 557 | 22 |
2074924 | 2074924 | 2022-01-02 | Maries | Missouri | 29125 | 1178 | 22 |
2074955 | 2074955 | 2022-01-02 | Schuyler | Missouri | 29197 | 552 | 22 |
2071673 | 2071673 | 2022-01-01 | Maries | Missouri | 29125 | 1178 | 22 |
2071704 | 2071704 | 2022-01-01 | Schuyler | Missouri | 29197 | 552 | 22 |
2068422 | 2068422 | 2021-12-31 | Maries | Missouri | 29125 | 1178 | 22 |
2068453 | 2068453 | 2021-12-31 | Schuyler | Missouri | 29197 | 552 | 22 |
2065171 | 2065171 | 2021-12-30 | Maries | Missouri | 29125 | 1178 | 22 |
2065202 | 2065202 | 2021-12-30 | Schuyler | Missouri | 29197 | 552 | 22 |
2061921 | 2061921 | 2021-12-29 | Maries | Missouri | 29125 | 1171 | 22 |
2061952 | 2061952 | 2021-12-29 | Schuyler | Missouri | 29197 | 547 | 22 |
2058672 | 2058672 | 2021-12-28 | Maries | Missouri | 29125 | 1163 | 22 |
2058703 | 2058703 | 2021-12-28 | Schuyler | Missouri | 29197 | 545 | 22 |
2055423 | 2055423 | 2021-12-27 | Maries | Missouri | 29125 | 1159 | 22 |
2055454 | 2055454 | 2021-12-27 | Schuyler | Missouri | 29197 | 539 | 22 |
2052173 | 2052173 | 2021-12-26 | Maries | Missouri | 29125 | 1157 | 22 |
2052204 | 2052204 | 2021-12-26 | Schuyler | Missouri | 29197 | 534 | 22 |
2048923 | 2048923 | 2021-12-25 | Maries | Missouri | 29125 | 1157 | 22 |
2048954 | 2048954 | 2021-12-25 | Schuyler | Missouri | 29197 | 534 | 22 |
2045673 | 2045673 | 2021-12-24 | Maries | Missouri | 29125 | 1157 | 22 |
2045704 | 2045704 | 2021-12-24 | Schuyler | Missouri | 29197 | 534 | 22 |
2042423 | 2042423 | 2021-12-23 | Maries | Missouri | 29125 | 1157 | 22 |
2042454 | 2042454 | 2021-12-23 | Schuyler | Missouri | 29197 | 534 | 22 |
2039174 | 2039174 | 2021-12-22 | Maries | Missouri | 29125 | 1154 | 22 |
2039205 | 2039205 | 2021-12-22 | Schuyler | Missouri | 29197 | 527 | 22 |
2035924 | 2035924 | 2021-12-21 | Maries | Missouri | 29125 | 1151 | 22 |
2035955 | 2035955 | 2021-12-21 | Schuyler | Missouri | 29197 | 524 | 22 |
2032674 | 2032674 | 2021-12-20 | Maries | Missouri | 29125 | 1142 | 22 |
2032705 | 2032705 | 2021-12-20 | Schuyler | Missouri | 29197 | 523 | 22 |
2029423 | 2029423 | 2021-12-19 | Maries | Missouri | 29125 | 1142 | 22 |
2029454 | 2029454 | 2021-12-19 | Schuyler | Missouri | 29197 | 522 | 22 |
2026172 | 2026172 | 2021-12-18 | Maries | Missouri | 29125 | 1140 | 22 |
2026203 | 2026203 | 2021-12-18 | Schuyler | Missouri | 29197 | 522 | 22 |
2022921 | 2022921 | 2021-12-17 | Maries | Missouri | 29125 | 1138 | 22 |
2022952 | 2022952 | 2021-12-17 | Schuyler | Missouri | 29197 | 520 | 22 |
2019670 | 2019670 | 2021-12-16 | Maries | Missouri | 29125 | 1134 | 22 |
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);