ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
679 rows where deaths = 40 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501173 | 2501173 | 2022-05-13 | Shannon | Missouri | 29203 | 1609 | 40 |
2497915 | 2497915 | 2022-05-12 | Shannon | Missouri | 29203 | 1609 | 40 |
2494657 | 2494657 | 2022-05-11 | Shannon | Missouri | 29203 | 1609 | 40 |
2491399 | 2491399 | 2022-05-10 | Shannon | Missouri | 29203 | 1609 | 40 |
2488141 | 2488141 | 2022-05-09 | Shannon | Missouri | 29203 | 1609 | 40 |
2484884 | 2484884 | 2022-05-08 | Shannon | Missouri | 29203 | 1609 | 40 |
2481626 | 2481626 | 2022-05-07 | Shannon | Missouri | 29203 | 1609 | 40 |
2478368 | 2478368 | 2022-05-06 | Shannon | Missouri | 29203 | 1609 | 40 |
2305799 | 2305799 | 2022-03-14 | Dade | Missouri | 29057 | 1424 | 40 |
2305841 | 2305841 | 2022-03-14 | Monroe | Missouri | 29137 | 2164 | 40 |
2302548 | 2302548 | 2022-03-13 | Dade | Missouri | 29057 | 1421 | 40 |
2302590 | 2302590 | 2022-03-13 | Monroe | Missouri | 29137 | 2163 | 40 |
2299296 | 2299296 | 2022-03-12 | Dade | Missouri | 29057 | 1421 | 40 |
2299338 | 2299338 | 2022-03-12 | Monroe | Missouri | 29137 | 2163 | 40 |
2296044 | 2296044 | 2022-03-11 | Dade | Missouri | 29057 | 1421 | 40 |
2296086 | 2296086 | 2022-03-11 | Monroe | Missouri | 29137 | 2163 | 40 |
2292792 | 2292792 | 2022-03-10 | Dade | Missouri | 29057 | 1417 | 40 |
2292810 | 2292810 | 2022-03-10 | Iron | Missouri | 29093 | 2175 | 40 |
2292834 | 2292834 | 2022-03-10 | Monroe | Missouri | 29137 | 2162 | 40 |
2289540 | 2289540 | 2022-03-09 | Dade | Missouri | 29057 | 1417 | 40 |
2289558 | 2289558 | 2022-03-09 | Iron | Missouri | 29093 | 2172 | 40 |
2289582 | 2289582 | 2022-03-09 | Monroe | Missouri | 29137 | 2162 | 40 |
2286288 | 2286288 | 2022-03-08 | Dade | Missouri | 29057 | 1417 | 40 |
2286306 | 2286306 | 2022-03-08 | Iron | Missouri | 29093 | 2170 | 40 |
2286330 | 2286330 | 2022-03-08 | Monroe | Missouri | 29137 | 2161 | 40 |
2283036 | 2283036 | 2022-03-07 | Dade | Missouri | 29057 | 1417 | 40 |
2283078 | 2283078 | 2022-03-07 | Monroe | Missouri | 29137 | 2159 | 40 |
2283085 | 2283085 | 2022-03-07 | Osage | Missouri | 29151 | 3196 | 40 |
2279783 | 2279783 | 2022-03-06 | Dade | Missouri | 29057 | 1416 | 40 |
2279825 | 2279825 | 2022-03-06 | Monroe | Missouri | 29137 | 2157 | 40 |
2279832 | 2279832 | 2022-03-06 | Osage | Missouri | 29151 | 3194 | 40 |
2276530 | 2276530 | 2022-03-05 | Dade | Missouri | 29057 | 1416 | 40 |
2276572 | 2276572 | 2022-03-05 | Monroe | Missouri | 29137 | 2157 | 40 |
2276579 | 2276579 | 2022-03-05 | Osage | Missouri | 29151 | 3194 | 40 |
2273277 | 2273277 | 2022-03-04 | Dade | Missouri | 29057 | 1416 | 40 |
2273319 | 2273319 | 2022-03-04 | Monroe | Missouri | 29137 | 2157 | 40 |
2273326 | 2273326 | 2022-03-04 | Osage | Missouri | 29151 | 3194 | 40 |
2270025 | 2270025 | 2022-03-03 | Dade | Missouri | 29057 | 1417 | 40 |
2270067 | 2270067 | 2022-03-03 | Monroe | Missouri | 29137 | 2156 | 40 |
2270074 | 2270074 | 2022-03-03 | Osage | Missouri | 29151 | 3191 | 40 |
2266772 | 2266772 | 2022-03-02 | Dade | Missouri | 29057 | 1415 | 40 |
2266814 | 2266814 | 2022-03-02 | Monroe | Missouri | 29137 | 2154 | 40 |
2266821 | 2266821 | 2022-03-02 | Osage | Missouri | 29151 | 3189 | 40 |
2263521 | 2263521 | 2022-03-01 | Dade | Missouri | 29057 | 1415 | 40 |
2263563 | 2263563 | 2022-03-01 | Monroe | Missouri | 29137 | 2154 | 40 |
2263570 | 2263570 | 2022-03-01 | Osage | Missouri | 29151 | 3188 | 40 |
2260270 | 2260270 | 2022-02-28 | Dade | Missouri | 29057 | 1415 | 40 |
2260312 | 2260312 | 2022-02-28 | Monroe | Missouri | 29137 | 2151 | 40 |
2257019 | 2257019 | 2022-02-27 | Dade | Missouri | 29057 | 1413 | 40 |
2257061 | 2257061 | 2022-02-27 | Monroe | Missouri | 29137 | 2149 | 40 |
2253768 | 2253768 | 2022-02-26 | Dade | Missouri | 29057 | 1413 | 40 |
2253810 | 2253810 | 2022-02-26 | Monroe | Missouri | 29137 | 2149 | 40 |
2250517 | 2250517 | 2022-02-25 | Dade | Missouri | 29057 | 1413 | 40 |
2250559 | 2250559 | 2022-02-25 | Monroe | Missouri | 29137 | 2149 | 40 |
2247266 | 2247266 | 2022-02-24 | Dade | Missouri | 29057 | 1412 | 40 |
2247308 | 2247308 | 2022-02-24 | Monroe | Missouri | 29137 | 2148 | 40 |
2244057 | 2244057 | 2022-02-23 | Monroe | Missouri | 29137 | 2145 | 40 |
2240806 | 2240806 | 2022-02-22 | Monroe | Missouri | 29137 | 2146 | 40 |
2237555 | 2237555 | 2022-02-21 | Monroe | Missouri | 29137 | 2140 | 40 |
2234304 | 2234304 | 2022-02-20 | Monroe | Missouri | 29137 | 2140 | 40 |
2231053 | 2231053 | 2022-02-19 | Monroe | Missouri | 29137 | 2140 | 40 |
2227802 | 2227802 | 2022-02-18 | Monroe | Missouri | 29137 | 2140 | 40 |
2224551 | 2224551 | 2022-02-17 | Monroe | Missouri | 29137 | 2137 | 40 |
2221300 | 2221300 | 2022-02-16 | Monroe | Missouri | 29137 | 2135 | 40 |
2218049 | 2218049 | 2022-02-15 | Monroe | Missouri | 29137 | 2131 | 40 |
2169218 | 2169218 | 2022-01-31 | DeKalb | Missouri | 29063 | 2024 | 40 |
2169248 | 2169248 | 2022-01-31 | Macon | Missouri | 29121 | 3404 | 40 |
2165963 | 2165963 | 2022-01-30 | DeKalb | Missouri | 29063 | 2022 | 40 |
2165993 | 2165993 | 2022-01-30 | Macon | Missouri | 29121 | 3403 | 40 |
2162708 | 2162708 | 2022-01-29 | DeKalb | Missouri | 29063 | 2020 | 40 |
2162738 | 2162738 | 2022-01-29 | Macon | Missouri | 29121 | 3397 | 40 |
2159453 | 2159453 | 2022-01-28 | DeKalb | Missouri | 29063 | 2009 | 40 |
2159483 | 2159483 | 2022-01-28 | Macon | Missouri | 29121 | 3362 | 40 |
2156199 | 2156199 | 2022-01-27 | DeKalb | Missouri | 29063 | 1995 | 40 |
2156229 | 2156229 | 2022-01-27 | Macon | Missouri | 29121 | 3319 | 40 |
2152946 | 2152946 | 2022-01-26 | DeKalb | Missouri | 29063 | 1984 | 40 |
2152976 | 2152976 | 2022-01-26 | Macon | Missouri | 29121 | 3292 | 40 |
2149694 | 2149694 | 2022-01-25 | DeKalb | Missouri | 29063 | 1983 | 40 |
2149724 | 2149724 | 2022-01-25 | Macon | Missouri | 29121 | 3273 | 40 |
2146442 | 2146442 | 2022-01-24 | DeKalb | Missouri | 29063 | 1972 | 40 |
2146472 | 2146472 | 2022-01-24 | Macon | Missouri | 29121 | 3238 | 40 |
2143187 | 2143187 | 2022-01-23 | DeKalb | Missouri | 29063 | 1970 | 40 |
2143217 | 2143217 | 2022-01-23 | Macon | Missouri | 29121 | 3222 | 40 |
2139932 | 2139932 | 2022-01-22 | DeKalb | Missouri | 29063 | 1957 | 40 |
2139962 | 2139962 | 2022-01-22 | Macon | Missouri | 29121 | 3217 | 40 |
2136676 | 2136676 | 2022-01-21 | DeKalb | Missouri | 29063 | 1945 | 40 |
2136706 | 2136706 | 2022-01-21 | Macon | Missouri | 29121 | 3189 | 40 |
2133424 | 2133424 | 2022-01-20 | DeKalb | Missouri | 29063 | 1935 | 40 |
2133454 | 2133454 | 2022-01-20 | Macon | Missouri | 29121 | 3141 | 40 |
2130171 | 2130171 | 2022-01-19 | DeKalb | Missouri | 29063 | 1907 | 40 |
2126902 | 2126902 | 2022-01-18 | Carroll | Missouri | 29033 | 1904 | 40 |
2126917 | 2126917 | 2022-01-18 | DeKalb | Missouri | 29063 | 1885 | 40 |
2126961 | 2126961 | 2022-01-18 | Nodaway | Missouri | 29147 | 5006 | 40 |
2123650 | 2123650 | 2022-01-17 | Carroll | Missouri | 29033 | 1875 | 40 |
2123665 | 2123665 | 2022-01-17 | DeKalb | Missouri | 29063 | 1874 | 40 |
2123709 | 2123709 | 2022-01-17 | Nodaway | Missouri | 29147 | 4774 | 40 |
2120398 | 2120398 | 2022-01-16 | Carroll | Missouri | 29033 | 1875 | 40 |
2120413 | 2120413 | 2022-01-16 | DeKalb | Missouri | 29063 | 1874 | 40 |
2120457 | 2120457 | 2022-01-16 | Nodaway | Missouri | 29147 | 4774 | 40 |
2117146 | 2117146 | 2022-01-15 | Carroll | Missouri | 29033 | 1875 | 40 |
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);