ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
393 rows where deaths = 58 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501077 | 2501077 | 2022-05-13 | Andrew | Missouri | 29003 | 4828 | 58 |
2501137 | 2501137 | 2022-05-13 | Macon | Missouri | 29121 | 3652 | 58 |
2501154 | 2501154 | 2022-05-13 | Ozark | Missouri | 29153 | 1735 | 58 |
2497819 | 2497819 | 2022-05-12 | Andrew | Missouri | 29003 | 4810 | 58 |
2497879 | 2497879 | 2022-05-12 | Macon | Missouri | 29121 | 3645 | 58 |
2494561 | 2494561 | 2022-05-11 | Andrew | Missouri | 29003 | 4810 | 58 |
2494621 | 2494621 | 2022-05-11 | Macon | Missouri | 29121 | 3645 | 58 |
2491303 | 2491303 | 2022-05-10 | Andrew | Missouri | 29003 | 4810 | 58 |
2491363 | 2491363 | 2022-05-10 | Macon | Missouri | 29121 | 3645 | 58 |
2488045 | 2488045 | 2022-05-09 | Andrew | Missouri | 29003 | 4810 | 58 |
2488105 | 2488105 | 2022-05-09 | Macon | Missouri | 29121 | 3645 | 58 |
2484788 | 2484788 | 2022-05-08 | Andrew | Missouri | 29003 | 4810 | 58 |
2484848 | 2484848 | 2022-05-08 | Macon | Missouri | 29121 | 3645 | 58 |
2481530 | 2481530 | 2022-05-07 | Andrew | Missouri | 29003 | 4810 | 58 |
2481590 | 2481590 | 2022-05-07 | Macon | Missouri | 29121 | 3645 | 58 |
2478272 | 2478272 | 2022-05-06 | Andrew | Missouri | 29003 | 4810 | 58 |
2478332 | 2478332 | 2022-05-06 | Macon | Missouri | 29121 | 3645 | 58 |
2475014 | 2475014 | 2022-05-05 | Andrew | Missouri | 29003 | 4775 | 58 |
2475074 | 2475074 | 2022-05-05 | Macon | Missouri | 29121 | 3641 | 58 |
2270089 | 2270089 | 2022-03-03 | Ripley | Missouri | 29181 | 2670 | 58 |
2266836 | 2266836 | 2022-03-02 | Ripley | Missouri | 29181 | 2669 | 58 |
2263585 | 2263585 | 2022-03-01 | Ripley | Missouri | 29181 | 2668 | 58 |
2260334 | 2260334 | 2022-02-28 | Ripley | Missouri | 29181 | 2668 | 58 |
2257083 | 2257083 | 2022-02-27 | Ripley | Missouri | 29181 | 2665 | 58 |
2253832 | 2253832 | 2022-02-26 | Ripley | Missouri | 29181 | 2665 | 58 |
2250581 | 2250581 | 2022-02-25 | Ripley | Missouri | 29181 | 2665 | 58 |
2247330 | 2247330 | 2022-02-24 | Ripley | Missouri | 29181 | 2664 | 58 |
2195209 | 2195209 | 2022-02-08 | Adair | Missouri | 29001 | 5865 | 58 |
2191955 | 2191955 | 2022-02-07 | Adair | Missouri | 29001 | 5838 | 58 |
2188702 | 2188702 | 2022-02-06 | Adair | Missouri | 29001 | 5800 | 58 |
2185449 | 2185449 | 2022-02-05 | Adair | Missouri | 29001 | 5800 | 58 |
2182197 | 2182197 | 2022-02-04 | Adair | Missouri | 29001 | 5800 | 58 |
2178945 | 2178945 | 2022-02-03 | Adair | Missouri | 29001 | 5770 | 58 |
2175693 | 2175693 | 2022-02-02 | Adair | Missouri | 29001 | 5746 | 58 |
2172440 | 2172440 | 2022-02-01 | Adair | Missouri | 29001 | 5669 | 58 |
2100913 | 2100913 | 2022-01-10 | Grundy | Missouri | 29079 | 1941 | 58 |
2100933 | 2100933 | 2022-01-10 | Linn | Missouri | 29115 | 2079 | 58 |
2097662 | 2097662 | 2022-01-09 | Grundy | Missouri | 29079 | 1940 | 58 |
2097682 | 2097682 | 2022-01-09 | Linn | Missouri | 29115 | 2077 | 58 |
2094410 | 2094410 | 2022-01-08 | Grundy | Missouri | 29079 | 1937 | 58 |
2094430 | 2094430 | 2022-01-08 | Linn | Missouri | 29115 | 2073 | 58 |
2091158 | 2091158 | 2022-01-07 | Grundy | Missouri | 29079 | 1928 | 58 |
2091178 | 2091178 | 2022-01-07 | Linn | Missouri | 29115 | 2064 | 58 |
2087907 | 2087907 | 2022-01-06 | Grundy | Missouri | 29079 | 1920 | 58 |
2087927 | 2087927 | 2022-01-06 | Linn | Missouri | 29115 | 2062 | 58 |
2084655 | 2084655 | 2022-01-05 | Grundy | Missouri | 29079 | 1909 | 58 |
2084675 | 2084675 | 2022-01-05 | Linn | Missouri | 29115 | 2060 | 58 |
2081403 | 2081403 | 2022-01-04 | Grundy | Missouri | 29079 | 1904 | 58 |
2081423 | 2081423 | 2022-01-04 | Linn | Missouri | 29115 | 2046 | 58 |
2078138 | 2078138 | 2022-01-03 | Cooper | Missouri | 29053 | 3279 | 58 |
2078151 | 2078151 | 2022-01-03 | Grundy | Missouri | 29079 | 1896 | 58 |
2078171 | 2078171 | 2022-01-03 | Linn | Missouri | 29115 | 2040 | 58 |
2074887 | 2074887 | 2022-01-02 | Cooper | Missouri | 29053 | 3252 | 58 |
2074900 | 2074900 | 2022-01-02 | Grundy | Missouri | 29079 | 1890 | 58 |
2074920 | 2074920 | 2022-01-02 | Linn | Missouri | 29115 | 2033 | 58 |
2071636 | 2071636 | 2022-01-01 | Cooper | Missouri | 29053 | 3252 | 58 |
2071649 | 2071649 | 2022-01-01 | Grundy | Missouri | 29079 | 1890 | 58 |
2071669 | 2071669 | 2022-01-01 | Linn | Missouri | 29115 | 2033 | 58 |
2068385 | 2068385 | 2021-12-31 | Cooper | Missouri | 29053 | 3252 | 58 |
2068398 | 2068398 | 2021-12-31 | Grundy | Missouri | 29079 | 1890 | 58 |
2068418 | 2068418 | 2021-12-31 | Linn | Missouri | 29115 | 2033 | 58 |
2065134 | 2065134 | 2021-12-30 | Cooper | Missouri | 29053 | 3252 | 58 |
2065147 | 2065147 | 2021-12-30 | Grundy | Missouri | 29079 | 1890 | 58 |
2065167 | 2065167 | 2021-12-30 | Linn | Missouri | 29115 | 2033 | 58 |
2061884 | 2061884 | 2021-12-29 | Cooper | Missouri | 29053 | 3228 | 58 |
2061897 | 2061897 | 2021-12-29 | Grundy | Missouri | 29079 | 1882 | 58 |
2061917 | 2061917 | 2021-12-29 | Linn | Missouri | 29115 | 2006 | 58 |
2058635 | 2058635 | 2021-12-28 | Cooper | Missouri | 29053 | 3220 | 58 |
2058668 | 2058668 | 2021-12-28 | Linn | Missouri | 29115 | 2006 | 58 |
2055389 | 2055389 | 2021-12-27 | Dallas | Missouri | 29059 | 2654 | 58 |
2055419 | 2055419 | 2021-12-27 | Linn | Missouri | 29115 | 2002 | 58 |
2052139 | 2052139 | 2021-12-26 | Dallas | Missouri | 29059 | 2613 | 58 |
2052169 | 2052169 | 2021-12-26 | Linn | Missouri | 29115 | 1985 | 58 |
2048889 | 2048889 | 2021-12-25 | Dallas | Missouri | 29059 | 2613 | 58 |
2048919 | 2048919 | 2021-12-25 | Linn | Missouri | 29115 | 1985 | 58 |
2045639 | 2045639 | 2021-12-24 | Dallas | Missouri | 29059 | 2613 | 58 |
2045669 | 2045669 | 2021-12-24 | Linn | Missouri | 29115 | 1985 | 58 |
2042389 | 2042389 | 2021-12-23 | Dallas | Missouri | 29059 | 2613 | 58 |
2042419 | 2042419 | 2021-12-23 | Linn | Missouri | 29115 | 1985 | 58 |
2039140 | 2039140 | 2021-12-22 | Dallas | Missouri | 29059 | 2600 | 58 |
2039170 | 2039170 | 2021-12-22 | Linn | Missouri | 29115 | 1978 | 58 |
2035890 | 2035890 | 2021-12-21 | Dallas | Missouri | 29059 | 2589 | 58 |
2035920 | 2035920 | 2021-12-21 | Linn | Missouri | 29115 | 1978 | 58 |
2032670 | 2032670 | 2021-12-20 | Linn | Missouri | 29115 | 1973 | 58 |
2029419 | 2029419 | 2021-12-19 | Linn | Missouri | 29115 | 1973 | 58 |
2026168 | 2026168 | 2021-12-18 | Linn | Missouri | 29115 | 1973 | 58 |
2022917 | 2022917 | 2021-12-17 | Linn | Missouri | 29115 | 1972 | 58 |
2019666 | 2019666 | 2021-12-16 | Linn | Missouri | 29115 | 1967 | 58 |
2016416 | 2016416 | 2021-12-15 | Linn | Missouri | 29115 | 1962 | 58 |
2013165 | 2013165 | 2021-12-14 | Linn | Missouri | 29115 | 1952 | 58 |
1987106 | 1987106 | 2021-12-06 | Bates | Missouri | 29013 | 2545 | 58 |
1983856 | 1983856 | 2021-12-05 | Bates | Missouri | 29013 | 2538 | 58 |
1980606 | 1980606 | 2021-12-04 | Bates | Missouri | 29013 | 2535 | 58 |
1977356 | 1977356 | 2021-12-03 | Bates | Missouri | 29013 | 2511 | 58 |
1974106 | 1974106 | 2021-12-02 | Bates | Missouri | 29013 | 2511 | 58 |
1970857 | 1970857 | 2021-12-01 | Bates | Missouri | 29013 | 2508 | 58 |
1896159 | 1896159 | 2021-11-08 | McDonald | Missouri | 29119 | 4034 | 58 |
1892909 | 1892909 | 2021-11-07 | McDonald | Missouri | 29119 | 4027 | 58 |
1889659 | 1889659 | 2021-11-06 | McDonald | Missouri | 29119 | 4027 | 58 |
1886409 | 1886409 | 2021-11-05 | McDonald | Missouri | 29119 | 4027 | 58 |
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);