ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 29031 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175708 | 2175708 | 2022-02-02 | Cape Girardeau | Missouri | 29031 | 17646 | 215 |
2172455 | 2172455 | 2022-02-01 | Cape Girardeau | Missouri | 29031 | 17550 | 214 |
2169202 | 2169202 | 2022-01-31 | Cape Girardeau | Missouri | 29031 | 17469 | 212 |
2165947 | 2165947 | 2022-01-30 | Cape Girardeau | Missouri | 29031 | 17439 | 212 |
2162692 | 2162692 | 2022-01-29 | Cape Girardeau | Missouri | 29031 | 17389 | 212 |
2159437 | 2159437 | 2022-01-28 | Cape Girardeau | Missouri | 29031 | 17262 | 212 |
2156183 | 2156183 | 2022-01-27 | Cape Girardeau | Missouri | 29031 | 17094 | 212 |
2152930 | 2152930 | 2022-01-26 | Cape Girardeau | Missouri | 29031 | 16914 | 212 |
2149678 | 2149678 | 2022-01-25 | Cape Girardeau | Missouri | 29031 | 16724 | 212 |
2146426 | 2146426 | 2022-01-24 | Cape Girardeau | Missouri | 29031 | 16607 | 212 |
2143171 | 2143171 | 2022-01-23 | Cape Girardeau | Missouri | 29031 | 16488 | 212 |
2139916 | 2139916 | 2022-01-22 | Cape Girardeau | Missouri | 29031 | 16403 | 212 |
2136660 | 2136660 | 2022-01-21 | Cape Girardeau | Missouri | 29031 | 16291 | 212 |
2133408 | 2133408 | 2022-01-20 | Cape Girardeau | Missouri | 29031 | 16044 | 210 |
2130155 | 2130155 | 2022-01-19 | Cape Girardeau | Missouri | 29031 | 15857 | 210 |
2126901 | 2126901 | 2022-01-18 | Cape Girardeau | Missouri | 29031 | 15542 | 209 |
2123649 | 2123649 | 2022-01-17 | Cape Girardeau | Missouri | 29031 | 15229 | 209 |
2120397 | 2120397 | 2022-01-16 | Cape Girardeau | Missouri | 29031 | 15229 | 209 |
2117145 | 2117145 | 2022-01-15 | Cape Girardeau | Missouri | 29031 | 15228 | 209 |
2113894 | 2113894 | 2022-01-14 | Cape Girardeau | Missouri | 29031 | 14993 | 209 |
2110642 | 2110642 | 2022-01-13 | Cape Girardeau | Missouri | 29031 | 14885 | 209 |
2107391 | 2107391 | 2022-01-12 | Cape Girardeau | Missouri | 29031 | 14743 | 209 |
2104140 | 2104140 | 2022-01-11 | Cape Girardeau | Missouri | 29031 | 14645 | 209 |
2100889 | 2100889 | 2022-01-10 | Cape Girardeau | Missouri | 29031 | 14514 | 205 |
2097638 | 2097638 | 2022-01-09 | Cape Girardeau | Missouri | 29031 | 14440 | 205 |
2094386 | 2094386 | 2022-01-08 | Cape Girardeau | Missouri | 29031 | 14423 | 205 |
2091134 | 2091134 | 2022-01-07 | Cape Girardeau | Missouri | 29031 | 14325 | 205 |
2087883 | 2087883 | 2022-01-06 | Cape Girardeau | Missouri | 29031 | 14252 | 205 |
2084631 | 2084631 | 2022-01-05 | Cape Girardeau | Missouri | 29031 | 14171 | 205 |
2081379 | 2081379 | 2022-01-04 | Cape Girardeau | Missouri | 29031 | 14113 | 206 |
2078127 | 2078127 | 2022-01-03 | Cape Girardeau | Missouri | 29031 | 14037 | 205 |
2074876 | 2074876 | 2022-01-02 | Cape Girardeau | Missouri | 29031 | 13920 | 205 |
2071625 | 2071625 | 2022-01-01 | Cape Girardeau | Missouri | 29031 | 13920 | 205 |
2068374 | 2068374 | 2021-12-31 | Cape Girardeau | Missouri | 29031 | 13920 | 205 |
2065123 | 2065123 | 2021-12-30 | Cape Girardeau | Missouri | 29031 | 13920 | 205 |
2061873 | 2061873 | 2021-12-29 | Cape Girardeau | Missouri | 29031 | 13870 | 205 |
2058624 | 2058624 | 2021-12-28 | Cape Girardeau | Missouri | 29031 | 13839 | 205 |
2055375 | 2055375 | 2021-12-27 | Cape Girardeau | Missouri | 29031 | 13809 | 204 |
2052125 | 2052125 | 2021-12-26 | Cape Girardeau | Missouri | 29031 | 13753 | 204 |
2048875 | 2048875 | 2021-12-25 | Cape Girardeau | Missouri | 29031 | 13753 | 204 |
2045625 | 2045625 | 2021-12-24 | Cape Girardeau | Missouri | 29031 | 13753 | 204 |
2042375 | 2042375 | 2021-12-23 | Cape Girardeau | Missouri | 29031 | 13752 | 204 |
2039126 | 2039126 | 2021-12-22 | Cape Girardeau | Missouri | 29031 | 13724 | 204 |
2035876 | 2035876 | 2021-12-21 | Cape Girardeau | Missouri | 29031 | 13707 | 204 |
2032626 | 2032626 | 2021-12-20 | Cape Girardeau | Missouri | 29031 | 13689 | 202 |
2029375 | 2029375 | 2021-12-19 | Cape Girardeau | Missouri | 29031 | 13680 | 202 |
2026124 | 2026124 | 2021-12-18 | Cape Girardeau | Missouri | 29031 | 13672 | 202 |
2022873 | 2022873 | 2021-12-17 | Cape Girardeau | Missouri | 29031 | 13661 | 202 |
2019622 | 2019622 | 2021-12-16 | Cape Girardeau | Missouri | 29031 | 13643 | 202 |
2016372 | 2016372 | 2021-12-15 | Cape Girardeau | Missouri | 29031 | 13621 | 202 |
2013121 | 2013121 | 2021-12-14 | Cape Girardeau | Missouri | 29031 | 13899 | 202 |
2009870 | 2009870 | 2021-12-13 | Cape Girardeau | Missouri | 29031 | 13899 | 201 |
2006619 | 2006619 | 2021-12-12 | Cape Girardeau | Missouri | 29031 | 13899 | 201 |
2003368 | 2003368 | 2021-12-11 | Cape Girardeau | Missouri | 29031 | 13899 | 201 |
2000118 | 2000118 | 2021-12-10 | Cape Girardeau | Missouri | 29031 | 13899 | 201 |
1996867 | 1996867 | 2021-12-09 | Cape Girardeau | Missouri | 29031 | 13899 | 201 |
1993616 | 1993616 | 2021-12-08 | Cape Girardeau | Missouri | 29031 | 13899 | 201 |
1990365 | 1990365 | 2021-12-07 | Cape Girardeau | Missouri | 29031 | 13815 | 201 |
1987115 | 1987115 | 2021-12-06 | Cape Girardeau | Missouri | 29031 | 13815 | 201 |
1983865 | 1983865 | 2021-12-05 | Cape Girardeau | Missouri | 29031 | 13815 | 201 |
1980615 | 1980615 | 2021-12-04 | Cape Girardeau | Missouri | 29031 | 13815 | 201 |
1977365 | 1977365 | 2021-12-03 | Cape Girardeau | Missouri | 29031 | 13815 | 201 |
1974115 | 1974115 | 2021-12-02 | Cape Girardeau | Missouri | 29031 | 13815 | 201 |
1970866 | 1970866 | 2021-12-01 | Cape Girardeau | Missouri | 29031 | 13815 | 201 |
1967616 | 1967616 | 2021-11-30 | Cape Girardeau | Missouri | 29031 | 13717 | 201 |
1964364 | 1964364 | 2021-11-29 | Cape Girardeau | Missouri | 29031 | 13717 | 197 |
1961113 | 1961113 | 2021-11-28 | Cape Girardeau | Missouri | 29031 | 13717 | 197 |
1957862 | 1957862 | 2021-11-27 | Cape Girardeau | Missouri | 29031 | 13717 | 197 |
1954611 | 1954611 | 2021-11-26 | Cape Girardeau | Missouri | 29031 | 13717 | 197 |
1951360 | 1951360 | 2021-11-25 | Cape Girardeau | Missouri | 29031 | 13717 | 197 |
1948109 | 1948109 | 2021-11-24 | Cape Girardeau | Missouri | 29031 | 13717 | 197 |
1944858 | 1944858 | 2021-11-23 | Cape Girardeau | Missouri | 29031 | 13616 | 197 |
1941607 | 1941607 | 2021-11-22 | Cape Girardeau | Missouri | 29031 | 13616 | 194 |
1938357 | 1938357 | 2021-11-21 | Cape Girardeau | Missouri | 29031 | 13616 | 194 |
1935107 | 1935107 | 2021-11-20 | Cape Girardeau | Missouri | 29031 | 13616 | 194 |
1931857 | 1931857 | 2021-11-19 | Cape Girardeau | Missouri | 29031 | 13616 | 194 |
1928606 | 1928606 | 2021-11-18 | Cape Girardeau | Missouri | 29031 | 13616 | 194 |
1925356 | 1925356 | 2021-11-17 | Cape Girardeau | Missouri | 29031 | 13616 | 164 |
1922107 | 1922107 | 2021-11-16 | Cape Girardeau | Missouri | 29031 | 13468 | 164 |
1918857 | 1918857 | 2021-11-15 | Cape Girardeau | Missouri | 29031 | 13468 | 163 |
1915607 | 1915607 | 2021-11-14 | Cape Girardeau | Missouri | 29031 | 13468 | 163 |
1912357 | 1912357 | 2021-11-13 | Cape Girardeau | Missouri | 29031 | 13468 | 163 |
1909107 | 1909107 | 2021-11-12 | Cape Girardeau | Missouri | 29031 | 13468 | 163 |
1905858 | 1905858 | 2021-11-11 | Cape Girardeau | Missouri | 29031 | 13468 | 163 |
1902609 | 1902609 | 2021-11-10 | Cape Girardeau | Missouri | 29031 | 13468 | 163 |
1899359 | 1899359 | 2021-11-09 | Cape Girardeau | Missouri | 29031 | 13338 | 163 |
1896109 | 1896109 | 2021-11-08 | Cape Girardeau | Missouri | 29031 | 13338 | 160 |
1892859 | 1892859 | 2021-11-07 | Cape Girardeau | Missouri | 29031 | 13338 | 160 |
1889609 | 1889609 | 2021-11-06 | Cape Girardeau | Missouri | 29031 | 13338 | 160 |
1886359 | 1886359 | 2021-11-05 | Cape Girardeau | Missouri | 29031 | 13338 | 159 |
1883110 | 1883110 | 2021-11-04 | Cape Girardeau | Missouri | 29031 | 13338 | 159 |
1879861 | 1879861 | 2021-11-03 | Cape Girardeau | Missouri | 29031 | 13338 | 159 |
1876612 | 1876612 | 2021-11-02 | Cape Girardeau | Missouri | 29031 | 13205 | 159 |
1873363 | 1873363 | 2021-11-01 | Cape Girardeau | Missouri | 29031 | 13205 | 156 |
1870114 | 1870114 | 2021-10-31 | Cape Girardeau | Missouri | 29031 | 13205 | 156 |
1866865 | 1866865 | 2021-10-30 | Cape Girardeau | Missouri | 29031 | 13205 | 156 |
1863616 | 1863616 | 2021-10-29 | Cape Girardeau | Missouri | 29031 | 13205 | 156 |
1860367 | 1860367 | 2021-10-28 | Cape Girardeau | Missouri | 29031 | 13205 | 156 |
1857118 | 1857118 | 2021-10-27 | Cape Girardeau | Missouri | 29031 | 13205 | 156 |
1853869 | 1853869 | 2021-10-26 | Cape Girardeau | Missouri | 29031 | 13041 | 156 |
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);