ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
717 rows where county = "Monroe" and fips = 29137 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175763 | 2175763 | 2022-02-02 | Monroe | Missouri | 29137 | 2061 | 38 |
2172510 | 2172510 | 2022-02-01 | Monroe | Missouri | 29137 | 2050 | 38 |
2169257 | 2169257 | 2022-01-31 | Monroe | Missouri | 29137 | 2043 | 38 |
2166002 | 2166002 | 2022-01-30 | Monroe | Missouri | 29137 | 2042 | 38 |
2162747 | 2162747 | 2022-01-29 | Monroe | Missouri | 29137 | 2040 | 38 |
2159492 | 2159492 | 2022-01-28 | Monroe | Missouri | 29137 | 2029 | 38 |
2156238 | 2156238 | 2022-01-27 | Monroe | Missouri | 29137 | 2021 | 38 |
2152985 | 2152985 | 2022-01-26 | Monroe | Missouri | 29137 | 2007 | 38 |
2149733 | 2149733 | 2022-01-25 | Monroe | Missouri | 29137 | 1988 | 38 |
2146481 | 2146481 | 2022-01-24 | Monroe | Missouri | 29137 | 1964 | 38 |
2143226 | 2143226 | 2022-01-23 | Monroe | Missouri | 29137 | 1958 | 38 |
2139971 | 2139971 | 2022-01-22 | Monroe | Missouri | 29137 | 1953 | 38 |
2136715 | 2136715 | 2022-01-21 | Monroe | Missouri | 29137 | 1940 | 38 |
2133463 | 2133463 | 2022-01-20 | Monroe | Missouri | 29137 | 1927 | 37 |
2130210 | 2130210 | 2022-01-19 | Monroe | Missouri | 29137 | 1888 | 37 |
2126956 | 2126956 | 2022-01-18 | Monroe | Missouri | 29137 | 1858 | 37 |
2123704 | 2123704 | 2022-01-17 | Monroe | Missouri | 29137 | 1839 | 37 |
2120452 | 2120452 | 2022-01-16 | Monroe | Missouri | 29137 | 1839 | 37 |
2117200 | 2117200 | 2022-01-15 | Monroe | Missouri | 29137 | 1839 | 37 |
2113949 | 2113949 | 2022-01-14 | Monroe | Missouri | 29137 | 1816 | 37 |
2110697 | 2110697 | 2022-01-13 | Monroe | Missouri | 29137 | 1794 | 37 |
2107446 | 2107446 | 2022-01-12 | Monroe | Missouri | 29137 | 1773 | 37 |
2104195 | 2104195 | 2022-01-11 | Monroe | Missouri | 29137 | 1758 | 37 |
2100944 | 2100944 | 2022-01-10 | Monroe | Missouri | 29137 | 1730 | 35 |
2097693 | 2097693 | 2022-01-09 | Monroe | Missouri | 29137 | 1730 | 35 |
2094441 | 2094441 | 2022-01-08 | Monroe | Missouri | 29137 | 1727 | 35 |
2091189 | 2091189 | 2022-01-07 | Monroe | Missouri | 29137 | 1704 | 35 |
2087938 | 2087938 | 2022-01-06 | Monroe | Missouri | 29137 | 1688 | 35 |
2084686 | 2084686 | 2022-01-05 | Monroe | Missouri | 29137 | 1677 | 35 |
2081434 | 2081434 | 2022-01-04 | Monroe | Missouri | 29137 | 1667 | 34 |
2078182 | 2078182 | 2022-01-03 | Monroe | Missouri | 29137 | 1659 | 34 |
2074931 | 2074931 | 2022-01-02 | Monroe | Missouri | 29137 | 1648 | 34 |
2071680 | 2071680 | 2022-01-01 | Monroe | Missouri | 29137 | 1648 | 34 |
2068429 | 2068429 | 2021-12-31 | Monroe | Missouri | 29137 | 1648 | 34 |
2065178 | 2065178 | 2021-12-30 | Monroe | Missouri | 29137 | 1648 | 34 |
2061928 | 2061928 | 2021-12-29 | Monroe | Missouri | 29137 | 1643 | 34 |
2058679 | 2058679 | 2021-12-28 | Monroe | Missouri | 29137 | 1632 | 34 |
2055430 | 2055430 | 2021-12-27 | Monroe | Missouri | 29137 | 1625 | 34 |
2052180 | 2052180 | 2021-12-26 | Monroe | Missouri | 29137 | 1615 | 34 |
2048930 | 2048930 | 2021-12-25 | Monroe | Missouri | 29137 | 1615 | 34 |
2045680 | 2045680 | 2021-12-24 | Monroe | Missouri | 29137 | 1615 | 34 |
2042430 | 2042430 | 2021-12-23 | Monroe | Missouri | 29137 | 1615 | 34 |
2039181 | 2039181 | 2021-12-22 | Monroe | Missouri | 29137 | 1605 | 34 |
2035931 | 2035931 | 2021-12-21 | Monroe | Missouri | 29137 | 1578 | 34 |
2032681 | 2032681 | 2021-12-20 | Monroe | Missouri | 29137 | 1569 | 34 |
2029430 | 2029430 | 2021-12-19 | Monroe | Missouri | 29137 | 1569 | 34 |
2026179 | 2026179 | 2021-12-18 | Monroe | Missouri | 29137 | 1569 | 34 |
2022928 | 2022928 | 2021-12-17 | Monroe | Missouri | 29137 | 1565 | 34 |
2019677 | 2019677 | 2021-12-16 | Monroe | Missouri | 29137 | 1554 | 34 |
2016427 | 2016427 | 2021-12-15 | Monroe | Missouri | 29137 | 1544 | 33 |
2013176 | 2013176 | 2021-12-14 | Monroe | Missouri | 29137 | 1532 | 33 |
2009925 | 2009925 | 2021-12-13 | Monroe | Missouri | 29137 | 1516 | 32 |
2006674 | 2006674 | 2021-12-12 | Monroe | Missouri | 29137 | 1516 | 32 |
2003423 | 2003423 | 2021-12-11 | Monroe | Missouri | 29137 | 1516 | 32 |
2000173 | 2000173 | 2021-12-10 | Monroe | Missouri | 29137 | 1513 | 32 |
1996922 | 1996922 | 2021-12-09 | Monroe | Missouri | 29137 | 1502 | 32 |
1993671 | 1993671 | 2021-12-08 | Monroe | Missouri | 29137 | 1496 | 32 |
1990420 | 1990420 | 2021-12-07 | Monroe | Missouri | 29137 | 1481 | 32 |
1987170 | 1987170 | 2021-12-06 | Monroe | Missouri | 29137 | 1475 | 32 |
1983920 | 1983920 | 2021-12-05 | Monroe | Missouri | 29137 | 1470 | 32 |
1980670 | 1980670 | 2021-12-04 | Monroe | Missouri | 29137 | 1462 | 32 |
1977420 | 1977420 | 2021-12-03 | Monroe | Missouri | 29137 | 1448 | 32 |
1974170 | 1974170 | 2021-12-02 | Monroe | Missouri | 29137 | 1448 | 32 |
1970921 | 1970921 | 2021-12-01 | Monroe | Missouri | 29137 | 1437 | 32 |
1967671 | 1967671 | 2021-11-30 | Monroe | Missouri | 29137 | 1430 | 32 |
1964419 | 1964419 | 2021-11-29 | Monroe | Missouri | 29137 | 1414 | 32 |
1961168 | 1961168 | 2021-11-28 | Monroe | Missouri | 29137 | 1404 | 32 |
1957917 | 1957917 | 2021-11-27 | Monroe | Missouri | 29137 | 1404 | 32 |
1954666 | 1954666 | 2021-11-26 | Monroe | Missouri | 29137 | 1404 | 32 |
1951415 | 1951415 | 2021-11-25 | Monroe | Missouri | 29137 | 1404 | 32 |
1948164 | 1948164 | 2021-11-24 | Monroe | Missouri | 29137 | 1404 | 32 |
1944913 | 1944913 | 2021-11-23 | Monroe | Missouri | 29137 | 1396 | 32 |
1941662 | 1941662 | 2021-11-22 | Monroe | Missouri | 29137 | 1396 | 32 |
1938412 | 1938412 | 2021-11-21 | Monroe | Missouri | 29137 | 1395 | 32 |
1935162 | 1935162 | 2021-11-20 | Monroe | Missouri | 29137 | 1395 | 32 |
1931912 | 1931912 | 2021-11-19 | Monroe | Missouri | 29137 | 1395 | 32 |
1928661 | 1928661 | 2021-11-18 | Monroe | Missouri | 29137 | 1392 | 32 |
1925411 | 1925411 | 2021-11-17 | Monroe | Missouri | 29137 | 1359 | 13 |
1922162 | 1922162 | 2021-11-16 | Monroe | Missouri | 29137 | 1358 | 13 |
1918912 | 1918912 | 2021-11-15 | Monroe | Missouri | 29137 | 1351 | 13 |
1915662 | 1915662 | 2021-11-14 | Monroe | Missouri | 29137 | 1350 | 13 |
1912412 | 1912412 | 2021-11-13 | Monroe | Missouri | 29137 | 1350 | 13 |
1909162 | 1909162 | 2021-11-12 | Monroe | Missouri | 29137 | 1348 | 13 |
1905913 | 1905913 | 2021-11-11 | Monroe | Missouri | 29137 | 1346 | 13 |
1902664 | 1902664 | 2021-11-10 | Monroe | Missouri | 29137 | 1346 | 13 |
1899414 | 1899414 | 2021-11-09 | Monroe | Missouri | 29137 | 1343 | 13 |
1896164 | 1896164 | 2021-11-08 | Monroe | Missouri | 29137 | 1341 | 13 |
1892914 | 1892914 | 2021-11-07 | Monroe | Missouri | 29137 | 1341 | 13 |
1889664 | 1889664 | 2021-11-06 | Monroe | Missouri | 29137 | 1340 | 13 |
1886414 | 1886414 | 2021-11-05 | Monroe | Missouri | 29137 | 1338 | 13 |
1883165 | 1883165 | 2021-11-04 | Monroe | Missouri | 29137 | 1333 | 13 |
1879916 | 1879916 | 2021-11-03 | Monroe | Missouri | 29137 | 1328 | 13 |
1876667 | 1876667 | 2021-11-02 | Monroe | Missouri | 29137 | 1328 | 13 |
1873418 | 1873418 | 2021-11-01 | Monroe | Missouri | 29137 | 1328 | 13 |
1870169 | 1870169 | 2021-10-31 | Monroe | Missouri | 29137 | 1328 | 13 |
1866920 | 1866920 | 2021-10-30 | Monroe | Missouri | 29137 | 1328 | 13 |
1863671 | 1863671 | 2021-10-29 | Monroe | Missouri | 29137 | 1327 | 13 |
1860422 | 1860422 | 2021-10-28 | Monroe | Missouri | 29137 | 1327 | 13 |
1857173 | 1857173 | 2021-10-27 | Monroe | Missouri | 29137 | 1326 | 13 |
1853924 | 1853924 | 2021-10-26 | Monroe | Missouri | 29137 | 1323 | 13 |
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);