ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
275 rows where deaths = 59 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 |
---|---|---|---|---|---|---|---|
2501144 | 2501144 | 2022-05-13 | Mississippi | Missouri | 29133 | 3521 | 59 |
2497886 | 2497886 | 2022-05-12 | Mississippi | Missouri | 29133 | 3514 | 59 |
2494628 | 2494628 | 2022-05-11 | Mississippi | Missouri | 29133 | 3514 | 59 |
2491370 | 2491370 | 2022-05-10 | Mississippi | Missouri | 29133 | 3514 | 59 |
2488112 | 2488112 | 2022-05-09 | Mississippi | Missouri | 29133 | 3514 | 59 |
2484855 | 2484855 | 2022-05-08 | Mississippi | Missouri | 29133 | 3514 | 59 |
2481597 | 2481597 | 2022-05-07 | Mississippi | Missouri | 29133 | 3514 | 59 |
2478339 | 2478339 | 2022-05-06 | Mississippi | Missouri | 29133 | 3514 | 59 |
2475081 | 2475081 | 2022-05-05 | Mississippi | Missouri | 29133 | 3501 | 59 |
2243987 | 2243987 | 2022-02-23 | Adair | Missouri | 29001 | 6003 | 59 |
2240736 | 2240736 | 2022-02-22 | Adair | Missouri | 29001 | 5997 | 59 |
2237485 | 2237485 | 2022-02-21 | Adair | Missouri | 29001 | 5963 | 59 |
2234234 | 2234234 | 2022-02-20 | Adair | Missouri | 29001 | 5963 | 59 |
2230983 | 2230983 | 2022-02-19 | Adair | Missouri | 29001 | 5963 | 59 |
2227732 | 2227732 | 2022-02-18 | Adair | Missouri | 29001 | 5963 | 59 |
2224481 | 2224481 | 2022-02-17 | Adair | Missouri | 29001 | 5963 | 59 |
2221230 | 2221230 | 2022-02-16 | Adair | Missouri | 29001 | 5954 | 59 |
2217979 | 2217979 | 2022-02-15 | Adair | Missouri | 29001 | 5954 | 59 |
2214728 | 2214728 | 2022-02-14 | Adair | Missouri | 29001 | 5902 | 59 |
2211476 | 2211476 | 2022-02-13 | Adair | Missouri | 29001 | 5902 | 59 |
2208223 | 2208223 | 2022-02-12 | Adair | Missouri | 29001 | 5902 | 59 |
2204970 | 2204970 | 2022-02-11 | Adair | Missouri | 29001 | 5902 | 59 |
2201717 | 2201717 | 2022-02-10 | Adair | Missouri | 29001 | 5902 | 59 |
2198463 | 2198463 | 2022-02-09 | Adair | Missouri | 29001 | 5881 | 59 |
2172499 | 2172499 | 2022-02-01 | Linn | Missouri | 29115 | 2269 | 59 |
2169246 | 2169246 | 2022-01-31 | Linn | Missouri | 29115 | 2241 | 59 |
2165991 | 2165991 | 2022-01-30 | Linn | Missouri | 29115 | 2241 | 59 |
2162736 | 2162736 | 2022-01-29 | Linn | Missouri | 29115 | 2236 | 59 |
2159481 | 2159481 | 2022-01-28 | Linn | Missouri | 29115 | 2216 | 59 |
2156227 | 2156227 | 2022-01-27 | Linn | Missouri | 29115 | 2203 | 59 |
2152974 | 2152974 | 2022-01-26 | Linn | Missouri | 29115 | 2192 | 59 |
2149722 | 2149722 | 2022-01-25 | Linn | Missouri | 29115 | 2193 | 59 |
2146470 | 2146470 | 2022-01-24 | Linn | Missouri | 29115 | 2183 | 59 |
2143215 | 2143215 | 2022-01-23 | Linn | Missouri | 29115 | 2178 | 59 |
2139960 | 2139960 | 2022-01-22 | Linn | Missouri | 29115 | 2168 | 59 |
2136704 | 2136704 | 2022-01-21 | Linn | Missouri | 29115 | 2166 | 59 |
2133452 | 2133452 | 2022-01-20 | Linn | Missouri | 29115 | 2157 | 59 |
2130199 | 2130199 | 2022-01-19 | Linn | Missouri | 29115 | 2151 | 59 |
2126945 | 2126945 | 2022-01-18 | Linn | Missouri | 29115 | 2141 | 59 |
2123693 | 2123693 | 2022-01-17 | Linn | Missouri | 29115 | 2128 | 59 |
2120441 | 2120441 | 2022-01-16 | Linn | Missouri | 29115 | 2128 | 59 |
2117189 | 2117189 | 2022-01-15 | Linn | Missouri | 29115 | 2128 | 59 |
2113938 | 2113938 | 2022-01-14 | Linn | Missouri | 29115 | 2116 | 59 |
2110686 | 2110686 | 2022-01-13 | Linn | Missouri | 29115 | 2101 | 59 |
2107435 | 2107435 | 2022-01-12 | Linn | Missouri | 29115 | 2095 | 59 |
2104184 | 2104184 | 2022-01-11 | Linn | Missouri | 29115 | 2087 | 59 |
2104204 | 2104204 | 2022-01-11 | Pemiscot | Missouri | 29155 | 2403 | 59 |
2100953 | 2100953 | 2022-01-10 | Pemiscot | Missouri | 29155 | 2372 | 59 |
2097702 | 2097702 | 2022-01-09 | Pemiscot | Missouri | 29155 | 2358 | 59 |
2094450 | 2094450 | 2022-01-08 | Pemiscot | Missouri | 29155 | 2350 | 59 |
2091198 | 2091198 | 2022-01-07 | Pemiscot | Missouri | 29155 | 2309 | 59 |
2087947 | 2087947 | 2022-01-06 | Pemiscot | Missouri | 29155 | 2289 | 59 |
2084695 | 2084695 | 2022-01-05 | Pemiscot | Missouri | 29155 | 2266 | 59 |
2081443 | 2081443 | 2022-01-04 | Pemiscot | Missouri | 29155 | 2237 | 59 |
2078141 | 2078141 | 2022-01-03 | Dallas | Missouri | 29059 | 2725 | 59 |
2078191 | 2078191 | 2022-01-03 | Pemiscot | Missouri | 29155 | 2221 | 59 |
2074890 | 2074890 | 2022-01-02 | Dallas | Missouri | 29059 | 2700 | 59 |
2074940 | 2074940 | 2022-01-02 | Pemiscot | Missouri | 29155 | 2201 | 59 |
2071639 | 2071639 | 2022-01-01 | Dallas | Missouri | 29059 | 2700 | 59 |
2071689 | 2071689 | 2022-01-01 | Pemiscot | Missouri | 29155 | 2201 | 59 |
2068388 | 2068388 | 2021-12-31 | Dallas | Missouri | 29059 | 2700 | 59 |
2068438 | 2068438 | 2021-12-31 | Pemiscot | Missouri | 29155 | 2201 | 59 |
2065137 | 2065137 | 2021-12-30 | Dallas | Missouri | 29059 | 2700 | 59 |
2065187 | 2065187 | 2021-12-30 | Pemiscot | Missouri | 29155 | 2201 | 59 |
2061887 | 2061887 | 2021-12-29 | Dallas | Missouri | 29059 | 2681 | 59 |
2061937 | 2061937 | 2021-12-29 | Pemiscot | Missouri | 29155 | 2188 | 59 |
2058638 | 2058638 | 2021-12-28 | Dallas | Missouri | 29059 | 2662 | 59 |
2058688 | 2058688 | 2021-12-28 | Pemiscot | Missouri | 29155 | 2179 | 59 |
2055439 | 2055439 | 2021-12-27 | Pemiscot | Missouri | 29155 | 2171 | 59 |
2052189 | 2052189 | 2021-12-26 | Pemiscot | Missouri | 29155 | 2167 | 59 |
2048939 | 2048939 | 2021-12-25 | Pemiscot | Missouri | 29155 | 2167 | 59 |
2045689 | 2045689 | 2021-12-24 | Pemiscot | Missouri | 29155 | 2167 | 59 |
2042439 | 2042439 | 2021-12-23 | Pemiscot | Missouri | 29155 | 2167 | 59 |
2039190 | 2039190 | 2021-12-22 | Pemiscot | Missouri | 29155 | 2159 | 59 |
2035940 | 2035940 | 2021-12-21 | Pemiscot | Missouri | 29155 | 2156 | 59 |
2032690 | 2032690 | 2021-12-20 | Pemiscot | Missouri | 29155 | 2155 | 59 |
2029439 | 2029439 | 2021-12-19 | Pemiscot | Missouri | 29155 | 2155 | 59 |
2026188 | 2026188 | 2021-12-18 | Pemiscot | Missouri | 29155 | 2155 | 59 |
2022937 | 2022937 | 2021-12-17 | Pemiscot | Missouri | 29155 | 2151 | 59 |
2019613 | 2019613 | 2021-12-16 | Bates | Missouri | 29013 | 2604 | 59 |
2019686 | 2019686 | 2021-12-16 | Pemiscot | Missouri | 29155 | 2151 | 59 |
2016363 | 2016363 | 2021-12-15 | Bates | Missouri | 29013 | 2600 | 59 |
2016436 | 2016436 | 2021-12-15 | Pemiscot | Missouri | 29155 | 2148 | 59 |
2013112 | 2013112 | 2021-12-14 | Bates | Missouri | 29013 | 2592 | 59 |
2013185 | 2013185 | 2021-12-14 | Pemiscot | Missouri | 29155 | 2146 | 59 |
2009861 | 2009861 | 2021-12-13 | Bates | Missouri | 29013 | 2575 | 59 |
2009934 | 2009934 | 2021-12-13 | Pemiscot | Missouri | 29155 | 2144 | 59 |
2006610 | 2006610 | 2021-12-12 | Bates | Missouri | 29013 | 2575 | 59 |
2006683 | 2006683 | 2021-12-12 | Pemiscot | Missouri | 29155 | 2144 | 59 |
2003359 | 2003359 | 2021-12-11 | Bates | Missouri | 29013 | 2574 | 59 |
2003432 | 2003432 | 2021-12-11 | Pemiscot | Missouri | 29155 | 2143 | 59 |
2000109 | 2000109 | 2021-12-10 | Bates | Missouri | 29013 | 2568 | 59 |
2000182 | 2000182 | 2021-12-10 | Pemiscot | Missouri | 29155 | 2138 | 59 |
1996858 | 1996858 | 2021-12-09 | Bates | Missouri | 29013 | 2561 | 59 |
1996931 | 1996931 | 2021-12-09 | Pemiscot | Missouri | 29155 | 2138 | 59 |
1993607 | 1993607 | 2021-12-08 | Bates | Missouri | 29013 | 2558 | 59 |
1993680 | 1993680 | 2021-12-08 | Pemiscot | Missouri | 29155 | 2136 | 59 |
1990356 | 1990356 | 2021-12-07 | Bates | Missouri | 29013 | 2555 | 59 |
1990429 | 1990429 | 2021-12-07 | Pemiscot | Missouri | 29155 | 2134 | 59 |
1925413 | 1925413 | 2021-11-17 | Morgan | Missouri | 29141 | 2699 | 59 |
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);