ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
910 rows where deaths = 30 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501119 | 2501119 | 2022-05-13 | Holt | Missouri | 29087 | 1060 | 30 |
2501120 | 2501120 | 2022-05-13 | Howard | Missouri | 29089 | 2515 | 30 |
2497861 | 2497861 | 2022-05-12 | Holt | Missouri | 29087 | 1058 | 30 |
2497862 | 2497862 | 2022-05-12 | Howard | Missouri | 29089 | 2505 | 30 |
2494603 | 2494603 | 2022-05-11 | Holt | Missouri | 29087 | 1058 | 30 |
2494604 | 2494604 | 2022-05-11 | Howard | Missouri | 29089 | 2505 | 30 |
2491345 | 2491345 | 2022-05-10 | Holt | Missouri | 29087 | 1058 | 30 |
2491346 | 2491346 | 2022-05-10 | Howard | Missouri | 29089 | 2505 | 30 |
2488087 | 2488087 | 2022-05-09 | Holt | Missouri | 29087 | 1058 | 30 |
2488088 | 2488088 | 2022-05-09 | Howard | Missouri | 29089 | 2505 | 30 |
2484830 | 2484830 | 2022-05-08 | Holt | Missouri | 29087 | 1058 | 30 |
2484831 | 2484831 | 2022-05-08 | Howard | Missouri | 29089 | 2505 | 30 |
2481572 | 2481572 | 2022-05-07 | Holt | Missouri | 29087 | 1058 | 30 |
2481573 | 2481573 | 2022-05-07 | Howard | Missouri | 29089 | 2505 | 30 |
2478314 | 2478314 | 2022-05-06 | Holt | Missouri | 29087 | 1058 | 30 |
2478315 | 2478315 | 2022-05-06 | Howard | Missouri | 29089 | 2505 | 30 |
2475056 | 2475056 | 2022-05-05 | Holt | Missouri | 29087 | 1055 | 30 |
2475057 | 2475057 | 2022-05-05 | Howard | Missouri | 29089 | 2496 | 30 |
2305808 | 2305808 | 2022-03-14 | Gentry | Missouri | 29075 | 2146 | 30 |
2305811 | 2305811 | 2022-03-14 | Harrison | Missouri | 29081 | 1810 | 30 |
2302557 | 2302557 | 2022-03-13 | Gentry | Missouri | 29075 | 2138 | 30 |
2302560 | 2302560 | 2022-03-13 | Harrison | Missouri | 29081 | 1803 | 30 |
2299305 | 2299305 | 2022-03-12 | Gentry | Missouri | 29075 | 2138 | 30 |
2299308 | 2299308 | 2022-03-12 | Harrison | Missouri | 29081 | 1803 | 30 |
2296053 | 2296053 | 2022-03-11 | Gentry | Missouri | 29075 | 2138 | 30 |
2296056 | 2296056 | 2022-03-11 | Harrison | Missouri | 29081 | 1803 | 30 |
2292801 | 2292801 | 2022-03-10 | Gentry | Missouri | 29075 | 2137 | 30 |
2292804 | 2292804 | 2022-03-10 | Harrison | Missouri | 29081 | 1803 | 30 |
2289549 | 2289549 | 2022-03-09 | Gentry | Missouri | 29075 | 2137 | 30 |
2289552 | 2289552 | 2022-03-09 | Harrison | Missouri | 29081 | 1802 | 30 |
2286297 | 2286297 | 2022-03-08 | Gentry | Missouri | 29075 | 2133 | 30 |
2286300 | 2286300 | 2022-03-08 | Harrison | Missouri | 29081 | 1802 | 30 |
2283045 | 2283045 | 2022-03-07 | Gentry | Missouri | 29075 | 2133 | 30 |
2283048 | 2283048 | 2022-03-07 | Harrison | Missouri | 29081 | 1801 | 30 |
2279792 | 2279792 | 2022-03-06 | Gentry | Missouri | 29075 | 2130 | 30 |
2279795 | 2279795 | 2022-03-06 | Harrison | Missouri | 29081 | 1800 | 30 |
2276539 | 2276539 | 2022-03-05 | Gentry | Missouri | 29075 | 2130 | 30 |
2276542 | 2276542 | 2022-03-05 | Harrison | Missouri | 29081 | 1800 | 30 |
2273286 | 2273286 | 2022-03-04 | Gentry | Missouri | 29075 | 2130 | 30 |
2273289 | 2273289 | 2022-03-04 | Harrison | Missouri | 29081 | 1800 | 30 |
2270034 | 2270034 | 2022-03-03 | Gentry | Missouri | 29075 | 2126 | 30 |
2270037 | 2270037 | 2022-03-03 | Harrison | Missouri | 29081 | 1799 | 30 |
2266781 | 2266781 | 2022-03-02 | Gentry | Missouri | 29075 | 2123 | 30 |
2266784 | 2266784 | 2022-03-02 | Harrison | Missouri | 29081 | 1798 | 30 |
2263530 | 2263530 | 2022-03-01 | Gentry | Missouri | 29075 | 2121 | 30 |
2263533 | 2263533 | 2022-03-01 | Harrison | Missouri | 29081 | 1798 | 30 |
2260282 | 2260282 | 2022-02-28 | Harrison | Missouri | 29081 | 1795 | 30 |
2257031 | 2257031 | 2022-02-27 | Harrison | Missouri | 29081 | 1790 | 30 |
2253780 | 2253780 | 2022-02-26 | Harrison | Missouri | 29081 | 1790 | 30 |
2250529 | 2250529 | 2022-02-25 | Harrison | Missouri | 29081 | 1790 | 30 |
2247278 | 2247278 | 2022-02-24 | Harrison | Missouri | 29081 | 1791 | 30 |
2214791 | 2214791 | 2022-02-14 | Maries | Missouri | 29125 | 1552 | 30 |
2191967 | 2191967 | 2022-02-07 | Caldwell | Missouri | 29025 | 1597 | 30 |
2192055 | 2192055 | 2022-02-07 | St. Clair | Missouri | 29185 | 2026 | 30 |
2188714 | 2188714 | 2022-02-06 | Caldwell | Missouri | 29025 | 1593 | 30 |
2188802 | 2188802 | 2022-02-06 | St. Clair | Missouri | 29185 | 2024 | 30 |
2185461 | 2185461 | 2022-02-05 | Caldwell | Missouri | 29025 | 1592 | 30 |
2185549 | 2185549 | 2022-02-05 | St. Clair | Missouri | 29185 | 2020 | 30 |
2182209 | 2182209 | 2022-02-04 | Caldwell | Missouri | 29025 | 1585 | 30 |
2182297 | 2182297 | 2022-02-04 | St. Clair | Missouri | 29185 | 2015 | 30 |
2178957 | 2178957 | 2022-02-03 | Caldwell | Missouri | 29025 | 1571 | 30 |
2179045 | 2179045 | 2022-02-03 | St. Clair | Missouri | 29185 | 2007 | 30 |
2175705 | 2175705 | 2022-02-02 | Caldwell | Missouri | 29025 | 1564 | 30 |
2175793 | 2175793 | 2022-02-02 | St. Clair | Missouri | 29185 | 1997 | 30 |
2172452 | 2172452 | 2022-02-01 | Caldwell | Missouri | 29025 | 1555 | 30 |
2126983 | 2126983 | 2022-01-18 | Shannon | Missouri | 29203 | 1271 | 30 |
2123731 | 2123731 | 2022-01-17 | Shannon | Missouri | 29203 | 1259 | 30 |
2120479 | 2120479 | 2022-01-16 | Shannon | Missouri | 29203 | 1259 | 30 |
2117227 | 2117227 | 2022-01-15 | Shannon | Missouri | 29203 | 1259 | 30 |
2113976 | 2113976 | 2022-01-14 | Shannon | Missouri | 29203 | 1247 | 30 |
2110724 | 2110724 | 2022-01-13 | Shannon | Missouri | 29203 | 1246 | 30 |
2107473 | 2107473 | 2022-01-12 | Shannon | Missouri | 29203 | 1238 | 30 |
2104222 | 2104222 | 2022-01-11 | Shannon | Missouri | 29203 | 1229 | 30 |
2100971 | 2100971 | 2022-01-10 | Shannon | Missouri | 29203 | 1225 | 30 |
2097720 | 2097720 | 2022-01-09 | Shannon | Missouri | 29203 | 1223 | 30 |
2094468 | 2094468 | 2022-01-08 | Shannon | Missouri | 29203 | 1223 | 30 |
2091216 | 2091216 | 2022-01-07 | Shannon | Missouri | 29203 | 1214 | 30 |
2087965 | 2087965 | 2022-01-06 | Shannon | Missouri | 29203 | 1211 | 30 |
2084713 | 2084713 | 2022-01-05 | Shannon | Missouri | 29203 | 1209 | 30 |
2081461 | 2081461 | 2022-01-04 | Shannon | Missouri | 29203 | 1203 | 30 |
2078169 | 2078169 | 2022-01-03 | Lewis | Missouri | 29111 | 2009 | 30 |
2074918 | 2074918 | 2022-01-02 | Lewis | Missouri | 29111 | 2000 | 30 |
2071667 | 2071667 | 2022-01-01 | Lewis | Missouri | 29111 | 2000 | 30 |
2068416 | 2068416 | 2021-12-31 | Lewis | Missouri | 29111 | 2000 | 30 |
2065165 | 2065165 | 2021-12-30 | Lewis | Missouri | 29111 | 2000 | 30 |
2061915 | 2061915 | 2021-12-29 | Lewis | Missouri | 29111 | 1995 | 30 |
2058666 | 2058666 | 2021-12-28 | Lewis | Missouri | 29111 | 1993 | 30 |
2055417 | 2055417 | 2021-12-27 | Lewis | Missouri | 29111 | 1988 | 30 |
2052167 | 2052167 | 2021-12-26 | Lewis | Missouri | 29111 | 1971 | 30 |
2048917 | 2048917 | 2021-12-25 | Lewis | Missouri | 29111 | 1971 | 30 |
2045667 | 2045667 | 2021-12-24 | Lewis | Missouri | 29111 | 1971 | 30 |
2042417 | 2042417 | 2021-12-23 | Lewis | Missouri | 29111 | 1971 | 30 |
2039168 | 2039168 | 2021-12-22 | Lewis | Missouri | 29111 | 1969 | 30 |
2035918 | 2035918 | 2021-12-21 | Lewis | Missouri | 29111 | 1957 | 30 |
2032668 | 2032668 | 2021-12-20 | Lewis | Missouri | 29111 | 1951 | 30 |
2029417 | 2029417 | 2021-12-19 | Lewis | Missouri | 29111 | 1951 | 30 |
2026166 | 2026166 | 2021-12-18 | Lewis | Missouri | 29111 | 1950 | 30 |
2022915 | 2022915 | 2021-12-17 | Lewis | Missouri | 29111 | 1932 | 30 |
2019664 | 2019664 | 2021-12-16 | Lewis | Missouri | 29111 | 1930 | 30 |
2016414 | 2016414 | 2021-12-15 | Lewis | Missouri | 29111 | 1922 | 30 |
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);