ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
756 rows where county = "Marion" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175757 | 2175757 | 2022-02-02 | Marion | Missouri | 29127 | 7683 | 111 |
2172504 | 2172504 | 2022-02-01 | Marion | Missouri | 29127 | 7610 | 111 |
2169251 | 2169251 | 2022-01-31 | Marion | Missouri | 29127 | 7591 | 110 |
2165996 | 2165996 | 2022-01-30 | Marion | Missouri | 29127 | 7567 | 110 |
2162741 | 2162741 | 2022-01-29 | Marion | Missouri | 29127 | 7547 | 110 |
2159486 | 2159486 | 2022-01-28 | Marion | Missouri | 29127 | 7477 | 110 |
2156232 | 2156232 | 2022-01-27 | Marion | Missouri | 29127 | 7431 | 110 |
2152979 | 2152979 | 2022-01-26 | Marion | Missouri | 29127 | 7388 | 110 |
2149727 | 2149727 | 2022-01-25 | Marion | Missouri | 29127 | 7334 | 110 |
2146475 | 2146475 | 2022-01-24 | Marion | Missouri | 29127 | 7211 | 110 |
2143220 | 2143220 | 2022-01-23 | Marion | Missouri | 29127 | 7187 | 110 |
2139965 | 2139965 | 2022-01-22 | Marion | Missouri | 29127 | 7167 | 110 |
2136709 | 2136709 | 2022-01-21 | Marion | Missouri | 29127 | 7131 | 110 |
2133457 | 2133457 | 2022-01-20 | Marion | Missouri | 29127 | 7078 | 110 |
2130204 | 2130204 | 2022-01-19 | Marion | Missouri | 29127 | 6944 | 110 |
2126950 | 2126950 | 2022-01-18 | Marion | Missouri | 29127 | 6882 | 109 |
2123698 | 2123698 | 2022-01-17 | Marion | Missouri | 29127 | 6790 | 109 |
2120446 | 2120446 | 2022-01-16 | Marion | Missouri | 29127 | 6790 | 109 |
2117194 | 2117194 | 2022-01-15 | Marion | Missouri | 29127 | 6790 | 109 |
2113943 | 2113943 | 2022-01-14 | Marion | Missouri | 29127 | 6713 | 109 |
2110691 | 2110691 | 2022-01-13 | Marion | Missouri | 29127 | 6666 | 109 |
2107440 | 2107440 | 2022-01-12 | Marion | Missouri | 29127 | 6616 | 109 |
2104189 | 2104189 | 2022-01-11 | Marion | Missouri | 29127 | 6527 | 109 |
2100938 | 2100938 | 2022-01-10 | Marion | Missouri | 29127 | 6457 | 105 |
2097687 | 2097687 | 2022-01-09 | Marion | Missouri | 29127 | 6451 | 105 |
2094435 | 2094435 | 2022-01-08 | Marion | Missouri | 29127 | 6450 | 105 |
2091183 | 2091183 | 2022-01-07 | Marion | Missouri | 29127 | 6410 | 105 |
2087932 | 2087932 | 2022-01-06 | Marion | Missouri | 29127 | 6352 | 105 |
2084680 | 2084680 | 2022-01-05 | Marion | Missouri | 29127 | 6328 | 105 |
2081428 | 2081428 | 2022-01-04 | Marion | Missouri | 29127 | 6255 | 104 |
2078176 | 2078176 | 2022-01-03 | Marion | Missouri | 29127 | 6233 | 102 |
2074925 | 2074925 | 2022-01-02 | Marion | Missouri | 29127 | 6160 | 102 |
2071674 | 2071674 | 2022-01-01 | Marion | Missouri | 29127 | 6160 | 102 |
2068423 | 2068423 | 2021-12-31 | Marion | Missouri | 29127 | 6160 | 102 |
2065172 | 2065172 | 2021-12-30 | Marion | Missouri | 29127 | 6160 | 102 |
2061922 | 2061922 | 2021-12-29 | Marion | Missouri | 29127 | 6130 | 102 |
2058673 | 2058673 | 2021-12-28 | Marion | Missouri | 29127 | 6096 | 102 |
2055424 | 2055424 | 2021-12-27 | Marion | Missouri | 29127 | 6052 | 100 |
2052174 | 2052174 | 2021-12-26 | Marion | Missouri | 29127 | 6040 | 100 |
2048924 | 2048924 | 2021-12-25 | Marion | Missouri | 29127 | 6040 | 100 |
2045674 | 2045674 | 2021-12-24 | Marion | Missouri | 29127 | 6040 | 100 |
2042424 | 2042424 | 2021-12-23 | Marion | Missouri | 29127 | 6040 | 100 |
2039175 | 2039175 | 2021-12-22 | Marion | Missouri | 29127 | 6016 | 100 |
2035925 | 2035925 | 2021-12-21 | Marion | Missouri | 29127 | 5966 | 100 |
2032675 | 2032675 | 2021-12-20 | Marion | Missouri | 29127 | 5941 | 100 |
2029424 | 2029424 | 2021-12-19 | Marion | Missouri | 29127 | 5939 | 100 |
2026173 | 2026173 | 2021-12-18 | Marion | Missouri | 29127 | 5939 | 100 |
2022922 | 2022922 | 2021-12-17 | Marion | Missouri | 29127 | 5890 | 100 |
2019671 | 2019671 | 2021-12-16 | Marion | Missouri | 29127 | 5877 | 100 |
2016421 | 2016421 | 2021-12-15 | Marion | Missouri | 29127 | 5836 | 100 |
2013170 | 2013170 | 2021-12-14 | Marion | Missouri | 29127 | 5774 | 100 |
2009919 | 2009919 | 2021-12-13 | Marion | Missouri | 29127 | 5736 | 100 |
2006668 | 2006668 | 2021-12-12 | Marion | Missouri | 29127 | 5735 | 100 |
2003417 | 2003417 | 2021-12-11 | Marion | Missouri | 29127 | 5728 | 100 |
2000167 | 2000167 | 2021-12-10 | Marion | Missouri | 29127 | 5723 | 100 |
1996916 | 1996916 | 2021-12-09 | Marion | Missouri | 29127 | 5701 | 100 |
1993665 | 1993665 | 2021-12-08 | Marion | Missouri | 29127 | 5687 | 100 |
1990414 | 1990414 | 2021-12-07 | Marion | Missouri | 29127 | 5642 | 100 |
1987164 | 1987164 | 2021-12-06 | Marion | Missouri | 29127 | 5619 | 99 |
1983914 | 1983914 | 2021-12-05 | Marion | Missouri | 29127 | 5611 | 99 |
1980664 | 1980664 | 2021-12-04 | Marion | Missouri | 29127 | 5602 | 99 |
1977414 | 1977414 | 2021-12-03 | Marion | Missouri | 29127 | 5554 | 99 |
1974164 | 1974164 | 2021-12-02 | Marion | Missouri | 29127 | 5554 | 99 |
1970915 | 1970915 | 2021-12-01 | Marion | Missouri | 29127 | 5522 | 99 |
1967665 | 1967665 | 2021-11-30 | Marion | Missouri | 29127 | 5498 | 99 |
1964413 | 1964413 | 2021-11-29 | Marion | Missouri | 29127 | 5475 | 99 |
1961162 | 1961162 | 2021-11-28 | Marion | Missouri | 29127 | 5460 | 99 |
1957911 | 1957911 | 2021-11-27 | Marion | Missouri | 29127 | 5460 | 99 |
1954660 | 1954660 | 2021-11-26 | Marion | Missouri | 29127 | 5460 | 99 |
1951409 | 1951409 | 2021-11-25 | Marion | Missouri | 29127 | 5460 | 99 |
1948158 | 1948158 | 2021-11-24 | Marion | Missouri | 29127 | 5460 | 99 |
1944907 | 1944907 | 2021-11-23 | Marion | Missouri | 29127 | 5447 | 99 |
1941656 | 1941656 | 2021-11-22 | Marion | Missouri | 29127 | 5427 | 99 |
1938406 | 1938406 | 2021-11-21 | Marion | Missouri | 29127 | 5426 | 99 |
1935156 | 1935156 | 2021-11-20 | Marion | Missouri | 29127 | 5423 | 99 |
1931906 | 1931906 | 2021-11-19 | Marion | Missouri | 29127 | 5406 | 99 |
1928655 | 1928655 | 2021-11-18 | Marion | Missouri | 29127 | 5395 | 99 |
1925405 | 1925405 | 2021-11-17 | Marion | Missouri | 29127 | 5320 | 65 |
1922156 | 1922156 | 2021-11-16 | Marion | Missouri | 29127 | 5318 | 65 |
1918906 | 1918906 | 2021-11-15 | Marion | Missouri | 29127 | 5304 | 64 |
1915656 | 1915656 | 2021-11-14 | Marion | Missouri | 29127 | 5303 | 64 |
1912406 | 1912406 | 2021-11-13 | Marion | Missouri | 29127 | 5301 | 64 |
1909156 | 1909156 | 2021-11-12 | Marion | Missouri | 29127 | 5297 | 64 |
1905907 | 1905907 | 2021-11-11 | Marion | Missouri | 29127 | 5282 | 64 |
1902658 | 1902658 | 2021-11-10 | Marion | Missouri | 29127 | 5282 | 64 |
1899408 | 1899408 | 2021-11-09 | Marion | Missouri | 29127 | 5269 | 64 |
1896158 | 1896158 | 2021-11-08 | Marion | Missouri | 29127 | 5250 | 63 |
1892908 | 1892908 | 2021-11-07 | Marion | Missouri | 29127 | 5250 | 63 |
1889658 | 1889658 | 2021-11-06 | Marion | Missouri | 29127 | 5250 | 63 |
1886408 | 1886408 | 2021-11-05 | Marion | Missouri | 29127 | 5238 | 63 |
1883159 | 1883159 | 2021-11-04 | Marion | Missouri | 29127 | 5231 | 63 |
1879910 | 1879910 | 2021-11-03 | Marion | Missouri | 29127 | 5224 | 63 |
1876661 | 1876661 | 2021-11-02 | Marion | Missouri | 29127 | 5212 | 63 |
1873412 | 1873412 | 2021-11-01 | Marion | Missouri | 29127 | 5194 | 63 |
1870163 | 1870163 | 2021-10-31 | Marion | Missouri | 29127 | 5196 | 63 |
1866914 | 1866914 | 2021-10-30 | Marion | Missouri | 29127 | 5195 | 63 |
1863665 | 1863665 | 2021-10-29 | Marion | Missouri | 29127 | 5189 | 63 |
1860416 | 1860416 | 2021-10-28 | Marion | Missouri | 29127 | 5177 | 63 |
1857167 | 1857167 | 2021-10-27 | Marion | Missouri | 29127 | 5168 | 63 |
1853918 | 1853918 | 2021-10-26 | Marion | Missouri | 29127 | 5162 | 63 |
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);