ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where deaths = 72 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501105 | 2501105 | 2022-05-13 | Dallas | Missouri | 29059 | 3826 | 72 |
2497847 | 2497847 | 2022-05-12 | Dallas | Missouri | 29059 | 3819 | 72 |
2494589 | 2494589 | 2022-05-11 | Dallas | Missouri | 29059 | 3819 | 72 |
2491331 | 2491331 | 2022-05-10 | Dallas | Missouri | 29059 | 3819 | 72 |
2488073 | 2488073 | 2022-05-09 | Dallas | Missouri | 29059 | 3819 | 72 |
2484816 | 2484816 | 2022-05-08 | Dallas | Missouri | 29059 | 3819 | 72 |
2481558 | 2481558 | 2022-05-07 | Dallas | Missouri | 29059 | 3819 | 72 |
2478300 | 2478300 | 2022-05-06 | Dallas | Missouri | 29059 | 3819 | 72 |
2475042 | 2475042 | 2022-05-05 | Dallas | Missouri | 29059 | 3815 | 72 |
2260321 | 2260321 | 2022-02-28 | Pemiscot | Missouri | 29155 | 2946 | 72 |
2257070 | 2257070 | 2022-02-27 | Pemiscot | Missouri | 29155 | 2943 | 72 |
2253819 | 2253819 | 2022-02-26 | Pemiscot | Missouri | 29155 | 2943 | 72 |
2250568 | 2250568 | 2022-02-25 | Pemiscot | Missouri | 29155 | 2943 | 72 |
2247317 | 2247317 | 2022-02-24 | Pemiscot | Missouri | 29155 | 2942 | 72 |
2244020 | 2244020 | 2022-02-23 | Douglas | Missouri | 29067 | 2525 | 72 |
2240769 | 2240769 | 2022-02-22 | Douglas | Missouri | 29067 | 2520 | 72 |
2237518 | 2237518 | 2022-02-21 | Douglas | Missouri | 29067 | 2508 | 72 |
2234267 | 2234267 | 2022-02-20 | Douglas | Missouri | 29067 | 2508 | 72 |
2231016 | 2231016 | 2022-02-19 | Douglas | Missouri | 29067 | 2508 | 72 |
2227765 | 2227765 | 2022-02-18 | Douglas | Missouri | 29067 | 2508 | 72 |
2224514 | 2224514 | 2022-02-17 | Douglas | Missouri | 29067 | 2504 | 72 |
2221263 | 2221263 | 2022-02-16 | Douglas | Missouri | 29067 | 2498 | 72 |
2218012 | 2218012 | 2022-02-15 | Douglas | Missouri | 29067 | 2490 | 72 |
2192071 | 2192071 | 2022-02-07 | Wright | Missouri | 29229 | 3690 | 72 |
2188818 | 2188818 | 2022-02-06 | Wright | Missouri | 29229 | 3688 | 72 |
2185565 | 2185565 | 2022-02-05 | Wright | Missouri | 29229 | 3682 | 72 |
2182223 | 2182223 | 2022-02-04 | Cooper | Missouri | 29053 | 4010 | 72 |
2182313 | 2182313 | 2022-02-04 | Wright | Missouri | 29229 | 3678 | 72 |
2178971 | 2178971 | 2022-02-03 | Cooper | Missouri | 29053 | 4003 | 72 |
2179061 | 2179061 | 2022-02-03 | Wright | Missouri | 29229 | 3675 | 72 |
2175719 | 2175719 | 2022-02-02 | Cooper | Missouri | 29053 | 3993 | 72 |
2175809 | 2175809 | 2022-02-02 | Wright | Missouri | 29229 | 3669 | 72 |
2172466 | 2172466 | 2022-02-01 | Cooper | Missouri | 29053 | 3970 | 72 |
2172556 | 2172556 | 2022-02-01 | Wright | Missouri | 29229 | 3624 | 72 |
2133466 | 2133466 | 2022-01-20 | New Madrid | Missouri | 29143 | 4103 | 72 |
2130213 | 2130213 | 2022-01-19 | New Madrid | Missouri | 29143 | 4050 | 72 |
2126959 | 2126959 | 2022-01-18 | New Madrid | Missouri | 29143 | 4001 | 72 |
2123707 | 2123707 | 2022-01-17 | New Madrid | Missouri | 29143 | 3959 | 72 |
2120455 | 2120455 | 2022-01-16 | New Madrid | Missouri | 29143 | 3959 | 72 |
2117203 | 2117203 | 2022-01-15 | New Madrid | Missouri | 29143 | 3959 | 72 |
2113952 | 2113952 | 2022-01-14 | New Madrid | Missouri | 29143 | 3887 | 72 |
2110700 | 2110700 | 2022-01-13 | New Madrid | Missouri | 29143 | 3857 | 72 |
2107449 | 2107449 | 2022-01-12 | New Madrid | Missouri | 29143 | 3817 | 72 |
2104198 | 2104198 | 2022-01-11 | New Madrid | Missouri | 29143 | 3779 | 72 |
2100964 | 2100964 | 2022-01-10 | Ray | Missouri | 29177 | 4020 | 72 |
2097713 | 2097713 | 2022-01-09 | Ray | Missouri | 29177 | 3998 | 72 |
2094461 | 2094461 | 2022-01-08 | Ray | Missouri | 29177 | 3990 | 72 |
2091209 | 2091209 | 2022-01-07 | Ray | Missouri | 29177 | 3941 | 72 |
2078119 | 2078119 | 2022-01-03 | Benton | Missouri | 29015 | 3070 | 72 |
2074868 | 2074868 | 2022-01-02 | Benton | Missouri | 29015 | 3044 | 72 |
2071617 | 2071617 | 2022-01-01 | Benton | Missouri | 29015 | 3044 | 72 |
2068366 | 2068366 | 2021-12-31 | Benton | Missouri | 29015 | 3044 | 72 |
2065115 | 2065115 | 2021-12-30 | Benton | Missouri | 29015 | 3044 | 72 |
2061865 | 2061865 | 2021-12-29 | Benton | Missouri | 29015 | 3028 | 72 |
2061967 | 2061967 | 2021-12-29 | Texas | Missouri | 29215 | 3523 | 72 |
2058616 | 2058616 | 2021-12-28 | Benton | Missouri | 29015 | 3021 | 72 |
2058718 | 2058718 | 2021-12-28 | Texas | Missouri | 29215 | 3515 | 72 |
2055367 | 2055367 | 2021-12-27 | Benton | Missouri | 29015 | 2997 | 72 |
2052117 | 2052117 | 2021-12-26 | Benton | Missouri | 29015 | 2972 | 72 |
2048867 | 2048867 | 2021-12-25 | Benton | Missouri | 29015 | 2972 | 72 |
2045617 | 2045617 | 2021-12-24 | Benton | Missouri | 29015 | 2972 | 72 |
2042367 | 2042367 | 2021-12-23 | Benton | Missouri | 29015 | 2972 | 72 |
2039118 | 2039118 | 2021-12-22 | Benton | Missouri | 29015 | 2963 | 72 |
2032695 | 2032695 | 2021-12-20 | Platte | Missouri | 29165 | 7024 | 72 |
2029444 | 2029444 | 2021-12-19 | Platte | Missouri | 29165 | 7007 | 72 |
2026193 | 2026193 | 2021-12-18 | Platte | Missouri | 29165 | 6989 | 72 |
1964421 | 1964421 | 2021-11-29 | Morgan | Missouri | 29141 | 2766 | 72 |
1961170 | 1961170 | 2021-11-28 | Morgan | Missouri | 29141 | 2744 | 72 |
1957919 | 1957919 | 2021-11-27 | Morgan | Missouri | 29141 | 2744 | 72 |
1954668 | 1954668 | 2021-11-26 | Morgan | Missouri | 29141 | 2744 | 72 |
1951417 | 1951417 | 2021-11-25 | Morgan | Missouri | 29141 | 2744 | 72 |
1948166 | 1948166 | 2021-11-24 | Morgan | Missouri | 29141 | 2744 | 72 |
1944915 | 1944915 | 2021-11-23 | Morgan | Missouri | 29141 | 2741 | 72 |
1925352 | 1925352 | 2021-11-17 | Butler | Missouri | 29023 | 6872 | 72 |
1922103 | 1922103 | 2021-11-16 | Butler | Missouri | 29023 | 6866 | 72 |
1918853 | 1918853 | 2021-11-15 | Butler | Missouri | 29023 | 6849 | 72 |
1918855 | 1918855 | 2021-11-15 | Callaway | Missouri | 29027 | 7691 | 72 |
1915603 | 1915603 | 2021-11-14 | Butler | Missouri | 29023 | 6842 | 72 |
1915605 | 1915605 | 2021-11-14 | Callaway | Missouri | 29027 | 7681 | 72 |
1912353 | 1912353 | 2021-11-13 | Butler | Missouri | 29023 | 6841 | 72 |
1912355 | 1912355 | 2021-11-13 | Callaway | Missouri | 29027 | 7673 | 72 |
1909103 | 1909103 | 2021-11-12 | Butler | Missouri | 29023 | 6835 | 72 |
1909105 | 1909105 | 2021-11-12 | Callaway | Missouri | 29027 | 7648 | 72 |
1905854 | 1905854 | 2021-11-11 | Butler | Missouri | 29023 | 6829 | 72 |
1905856 | 1905856 | 2021-11-11 | Callaway | Missouri | 29027 | 7618 | 72 |
1902605 | 1902605 | 2021-11-10 | Butler | Missouri | 29023 | 6829 | 72 |
1902607 | 1902607 | 2021-11-10 | Callaway | Missouri | 29027 | 7618 | 72 |
1899355 | 1899355 | 2021-11-09 | Butler | Missouri | 29023 | 6820 | 72 |
1899357 | 1899357 | 2021-11-09 | Callaway | Missouri | 29027 | 7591 | 72 |
1827909 | 1827909 | 2021-10-18 | Johnson | Missouri | 29101 | 7062 | 72 |
1824660 | 1824660 | 2021-10-17 | Johnson | Missouri | 29101 | 7055 | 72 |
1821411 | 1821411 | 2021-10-16 | Johnson | Missouri | 29101 | 7054 | 72 |
1818162 | 1818162 | 2021-10-15 | Johnson | Missouri | 29101 | 7035 | 72 |
1814908 | 1814908 | 2021-10-14 | Howell | Missouri | 29091 | 5653 | 72 |
1814913 | 1814913 | 2021-10-14 | Johnson | Missouri | 29101 | 6979 | 72 |
1811660 | 1811660 | 2021-10-13 | Howell | Missouri | 29091 | 5643 | 72 |
1811665 | 1811665 | 2021-10-13 | Johnson | Missouri | 29101 | 6970 | 72 |
1811670 | 1811670 | 2021-10-13 | Lafayette | Missouri | 29107 | 4534 | 72 |
1769460 | 1769460 | 2021-09-30 | Pulaski | Missouri | 29169 | 4964 | 72 |
1766211 | 1766211 | 2021-09-29 | Pulaski | Missouri | 29169 | 4950 | 72 |
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);