ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
186 rows where deaths = 70 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2305800 | 2305800 | 2022-03-14 | Dallas | Missouri | 29059 | 3783 | 70 |
2302549 | 2302549 | 2022-03-13 | Dallas | Missouri | 29059 | 3781 | 70 |
2299297 | 2299297 | 2022-03-12 | Dallas | Missouri | 29059 | 3781 | 70 |
2296045 | 2296045 | 2022-03-11 | Dallas | Missouri | 29059 | 3781 | 70 |
2292793 | 2292793 | 2022-03-10 | Dallas | Missouri | 29059 | 3781 | 70 |
2289541 | 2289541 | 2022-03-09 | Dallas | Missouri | 29059 | 3780 | 70 |
2286289 | 2286289 | 2022-03-08 | Dallas | Missouri | 29059 | 3780 | 70 |
2283037 | 2283037 | 2022-03-07 | Dallas | Missouri | 29059 | 3779 | 70 |
2279784 | 2279784 | 2022-03-06 | Dallas | Missouri | 29059 | 3779 | 70 |
2276531 | 2276531 | 2022-03-05 | Dallas | Missouri | 29059 | 3779 | 70 |
2273278 | 2273278 | 2022-03-04 | Dallas | Missouri | 29059 | 3779 | 70 |
2270026 | 2270026 | 2022-03-03 | Dallas | Missouri | 29059 | 3774 | 70 |
2266773 | 2266773 | 2022-03-02 | Dallas | Missouri | 29059 | 3771 | 70 |
2263522 | 2263522 | 2022-03-01 | Dallas | Missouri | 29059 | 3771 | 70 |
2260271 | 2260271 | 2022-02-28 | Dallas | Missouri | 29059 | 3770 | 70 |
2257020 | 2257020 | 2022-02-27 | Dallas | Missouri | 29059 | 3770 | 70 |
2253769 | 2253769 | 2022-02-26 | Dallas | Missouri | 29059 | 3770 | 70 |
2250518 | 2250518 | 2022-02-25 | Dallas | Missouri | 29059 | 3770 | 70 |
2247267 | 2247267 | 2022-02-24 | Dallas | Missouri | 29059 | 3770 | 70 |
2214761 | 2214761 | 2022-02-14 | Douglas | Missouri | 29067 | 2485 | 70 |
2211509 | 2211509 | 2022-02-13 | Douglas | Missouri | 29067 | 2457 | 70 |
2208256 | 2208256 | 2022-02-12 | Douglas | Missouri | 29067 | 2457 | 70 |
2205003 | 2205003 | 2022-02-11 | Douglas | Missouri | 29067 | 2457 | 70 |
2201750 | 2201750 | 2022-02-10 | Douglas | Missouri | 29067 | 2457 | 70 |
2198496 | 2198496 | 2022-02-09 | Douglas | Missouri | 29067 | 2448 | 70 |
2195242 | 2195242 | 2022-02-08 | Douglas | Missouri | 29067 | 2439 | 70 |
2169193 | 2169193 | 2022-01-31 | Bates | Missouri | 29013 | 3565 | 70 |
2165938 | 2165938 | 2022-01-30 | Bates | Missouri | 29013 | 3557 | 70 |
2162683 | 2162683 | 2022-01-29 | Bates | Missouri | 29013 | 3549 | 70 |
2159428 | 2159428 | 2022-01-28 | Bates | Missouri | 29013 | 3513 | 70 |
2156174 | 2156174 | 2022-01-27 | Bates | Missouri | 29013 | 3489 | 70 |
2152921 | 2152921 | 2022-01-26 | Bates | Missouri | 29013 | 3454 | 70 |
2149669 | 2149669 | 2022-01-25 | Bates | Missouri | 29013 | 3430 | 70 |
2146417 | 2146417 | 2022-01-24 | Bates | Missouri | 29013 | 3418 | 70 |
2143162 | 2143162 | 2022-01-23 | Bates | Missouri | 29013 | 3402 | 70 |
2143182 | 2143182 | 2022-01-23 | Cooper | Missouri | 29053 | 3784 | 70 |
2139907 | 2139907 | 2022-01-22 | Bates | Missouri | 29013 | 3370 | 70 |
2139927 | 2139927 | 2022-01-22 | Cooper | Missouri | 29053 | 3759 | 70 |
2136651 | 2136651 | 2022-01-21 | Bates | Missouri | 29013 | 3341 | 70 |
2136671 | 2136671 | 2022-01-21 | Cooper | Missouri | 29053 | 3723 | 70 |
2136761 | 2136761 | 2022-01-21 | Wright | Missouri | 29229 | 3339 | 70 |
2087958 | 2087958 | 2022-01-06 | Ray | Missouri | 29177 | 3929 | 70 |
2039220 | 2039220 | 2021-12-22 | Texas | Missouri | 29215 | 3473 | 70 |
2035970 | 2035970 | 2021-12-21 | Texas | Missouri | 29215 | 3463 | 70 |
2032618 | 2032618 | 2021-12-20 | Benton | Missouri | 29015 | 2944 | 70 |
2029367 | 2029367 | 2021-12-19 | Benton | Missouri | 29015 | 2938 | 70 |
2026116 | 2026116 | 2021-12-18 | Benton | Missouri | 29015 | 2937 | 70 |
2022865 | 2022865 | 2021-12-17 | Benton | Missouri | 29015 | 2917 | 70 |
2019614 | 2019614 | 2021-12-16 | Benton | Missouri | 29015 | 2898 | 70 |
2016364 | 2016364 | 2021-12-15 | Benton | Missouri | 29015 | 2873 | 70 |
2013113 | 2013113 | 2021-12-14 | Benton | Missouri | 29015 | 2868 | 70 |
2009862 | 2009862 | 2021-12-13 | Benton | Missouri | 29015 | 2848 | 70 |
2009928 | 2009928 | 2021-12-13 | New Madrid | Missouri | 29143 | 3492 | 70 |
2006611 | 2006611 | 2021-12-12 | Benton | Missouri | 29015 | 2845 | 70 |
2006677 | 2006677 | 2021-12-12 | New Madrid | Missouri | 29143 | 3492 | 70 |
2003360 | 2003360 | 2021-12-11 | Benton | Missouri | 29015 | 2844 | 70 |
2003426 | 2003426 | 2021-12-11 | New Madrid | Missouri | 29143 | 3492 | 70 |
2000110 | 2000110 | 2021-12-10 | Benton | Missouri | 29015 | 2822 | 70 |
2000176 | 2000176 | 2021-12-10 | New Madrid | Missouri | 29143 | 3490 | 70 |
1996859 | 1996859 | 2021-12-09 | Benton | Missouri | 29015 | 2818 | 70 |
1996925 | 1996925 | 2021-12-09 | New Madrid | Missouri | 29143 | 3483 | 70 |
1993608 | 1993608 | 2021-12-08 | Benton | Missouri | 29015 | 2814 | 70 |
1993674 | 1993674 | 2021-12-08 | New Madrid | Missouri | 29143 | 3475 | 70 |
1990357 | 1990357 | 2021-12-07 | Benton | Missouri | 29015 | 2798 | 70 |
1990423 | 1990423 | 2021-12-07 | New Madrid | Missouri | 29143 | 3470 | 70 |
1987107 | 1987107 | 2021-12-06 | Benton | Missouri | 29015 | 2796 | 70 |
1987173 | 1987173 | 2021-12-06 | New Madrid | Missouri | 29143 | 3467 | 70 |
1983857 | 1983857 | 2021-12-05 | Benton | Missouri | 29015 | 2788 | 70 |
1983923 | 1983923 | 2021-12-05 | New Madrid | Missouri | 29143 | 3464 | 70 |
1980607 | 1980607 | 2021-12-04 | Benton | Missouri | 29015 | 2783 | 70 |
1980673 | 1980673 | 2021-12-04 | New Madrid | Missouri | 29143 | 3460 | 70 |
1977357 | 1977357 | 2021-12-03 | Benton | Missouri | 29015 | 2771 | 70 |
1977423 | 1977423 | 2021-12-03 | New Madrid | Missouri | 29143 | 3454 | 70 |
1974107 | 1974107 | 2021-12-02 | Benton | Missouri | 29015 | 2771 | 70 |
1974173 | 1974173 | 2021-12-02 | New Madrid | Missouri | 29143 | 3454 | 70 |
1970858 | 1970858 | 2021-12-01 | Benton | Missouri | 29015 | 2758 | 70 |
1970924 | 1970924 | 2021-12-01 | New Madrid | Missouri | 29143 | 3449 | 70 |
1967608 | 1967608 | 2021-11-30 | Benton | Missouri | 29015 | 2752 | 70 |
1967674 | 1967674 | 2021-11-30 | New Madrid | Missouri | 29143 | 3445 | 70 |
1964356 | 1964356 | 2021-11-29 | Benton | Missouri | 29015 | 2746 | 70 |
1964422 | 1964422 | 2021-11-29 | New Madrid | Missouri | 29143 | 3436 | 70 |
1964433 | 1964433 | 2021-11-29 | Platte | Missouri | 29165 | 6512 | 70 |
1961105 | 1961105 | 2021-11-28 | Benton | Missouri | 29015 | 2739 | 70 |
1961171 | 1961171 | 2021-11-28 | New Madrid | Missouri | 29143 | 3433 | 70 |
1961182 | 1961182 | 2021-11-28 | Platte | Missouri | 29165 | 6434 | 70 |
1957854 | 1957854 | 2021-11-27 | Benton | Missouri | 29015 | 2739 | 70 |
1957920 | 1957920 | 2021-11-27 | New Madrid | Missouri | 29143 | 3433 | 70 |
1957931 | 1957931 | 2021-11-27 | Platte | Missouri | 29165 | 6434 | 70 |
1954603 | 1954603 | 2021-11-26 | Benton | Missouri | 29015 | 2739 | 70 |
1954669 | 1954669 | 2021-11-26 | New Madrid | Missouri | 29143 | 3433 | 70 |
1954680 | 1954680 | 2021-11-26 | Platte | Missouri | 29165 | 6434 | 70 |
1951352 | 1951352 | 2021-11-25 | Benton | Missouri | 29015 | 2739 | 70 |
1951418 | 1951418 | 2021-11-25 | New Madrid | Missouri | 29143 | 3433 | 70 |
1951429 | 1951429 | 2021-11-25 | Platte | Missouri | 29165 | 6434 | 70 |
1948101 | 1948101 | 2021-11-24 | Benton | Missouri | 29015 | 2739 | 70 |
1948167 | 1948167 | 2021-11-24 | New Madrid | Missouri | 29143 | 3433 | 70 |
1948178 | 1948178 | 2021-11-24 | Platte | Missouri | 29165 | 6434 | 70 |
1944850 | 1944850 | 2021-11-23 | Benton | Missouri | 29015 | 2732 | 70 |
1944916 | 1944916 | 2021-11-23 | New Madrid | Missouri | 29143 | 3430 | 70 |
1944927 | 1944927 | 2021-11-23 | Platte | Missouri | 29165 | 6403 | 70 |
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);