ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 29097 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175741 | 2175741 | 2022-02-02 | Jasper | Missouri | 29097 | 19400 | 274 |
2172488 | 2172488 | 2022-02-01 | Jasper | Missouri | 29097 | 19204 | 274 |
2169235 | 2169235 | 2022-01-31 | Jasper | Missouri | 29097 | 19127 | 274 |
2165980 | 2165980 | 2022-01-30 | Jasper | Missouri | 29097 | 19098 | 274 |
2162725 | 2162725 | 2022-01-29 | Jasper | Missouri | 29097 | 19084 | 274 |
2159470 | 2159470 | 2022-01-28 | Jasper | Missouri | 29097 | 18983 | 274 |
2156216 | 2156216 | 2022-01-27 | Jasper | Missouri | 29097 | 18863 | 272 |
2152963 | 2152963 | 2022-01-26 | Jasper | Missouri | 29097 | 18726 | 270 |
2149711 | 2149711 | 2022-01-25 | Jasper | Missouri | 29097 | 18507 | 270 |
2146459 | 2146459 | 2022-01-24 | Jasper | Missouri | 29097 | 18202 | 269 |
2143204 | 2143204 | 2022-01-23 | Jasper | Missouri | 29097 | 18148 | 269 |
2139949 | 2139949 | 2022-01-22 | Jasper | Missouri | 29097 | 18107 | 269 |
2136693 | 2136693 | 2022-01-21 | Jasper | Missouri | 29097 | 17879 | 269 |
2133441 | 2133441 | 2022-01-20 | Jasper | Missouri | 29097 | 17664 | 267 |
2130188 | 2130188 | 2022-01-19 | Jasper | Missouri | 29097 | 17465 | 267 |
2126934 | 2126934 | 2022-01-18 | Jasper | Missouri | 29097 | 17130 | 267 |
2123682 | 2123682 | 2022-01-17 | Jasper | Missouri | 29097 | 16880 | 267 |
2120430 | 2120430 | 2022-01-16 | Jasper | Missouri | 29097 | 16880 | 267 |
2117178 | 2117178 | 2022-01-15 | Jasper | Missouri | 29097 | 16879 | 267 |
2113927 | 2113927 | 2022-01-14 | Jasper | Missouri | 29097 | 16703 | 266 |
2110675 | 2110675 | 2022-01-13 | Jasper | Missouri | 29097 | 16550 | 266 |
2107424 | 2107424 | 2022-01-12 | Jasper | Missouri | 29097 | 16395 | 266 |
2104173 | 2104173 | 2022-01-11 | Jasper | Missouri | 29097 | 16235 | 266 |
2100922 | 2100922 | 2022-01-10 | Jasper | Missouri | 29097 | 16038 | 265 |
2097671 | 2097671 | 2022-01-09 | Jasper | Missouri | 29097 | 15994 | 265 |
2094419 | 2094419 | 2022-01-08 | Jasper | Missouri | 29097 | 15980 | 265 |
2091167 | 2091167 | 2022-01-07 | Jasper | Missouri | 29097 | 15861 | 265 |
2087916 | 2087916 | 2022-01-06 | Jasper | Missouri | 29097 | 15731 | 265 |
2084664 | 2084664 | 2022-01-05 | Jasper | Missouri | 29097 | 15597 | 265 |
2081412 | 2081412 | 2022-01-04 | Jasper | Missouri | 29097 | 15484 | 265 |
2078160 | 2078160 | 2022-01-03 | Jasper | Missouri | 29097 | 15366 | 263 |
2074909 | 2074909 | 2022-01-02 | Jasper | Missouri | 29097 | 15229 | 263 |
2071658 | 2071658 | 2022-01-01 | Jasper | Missouri | 29097 | 15229 | 263 |
2068407 | 2068407 | 2021-12-31 | Jasper | Missouri | 29097 | 15229 | 263 |
2065156 | 2065156 | 2021-12-30 | Jasper | Missouri | 29097 | 15229 | 263 |
2061906 | 2061906 | 2021-12-29 | Jasper | Missouri | 29097 | 15170 | 261 |
2058657 | 2058657 | 2021-12-28 | Jasper | Missouri | 29097 | 15090 | 261 |
2055408 | 2055408 | 2021-12-27 | Jasper | Missouri | 29097 | 15042 | 260 |
2052158 | 2052158 | 2021-12-26 | Jasper | Missouri | 29097 | 14971 | 260 |
2048908 | 2048908 | 2021-12-25 | Jasper | Missouri | 29097 | 14971 | 260 |
2045658 | 2045658 | 2021-12-24 | Jasper | Missouri | 29097 | 14971 | 260 |
2042408 | 2042408 | 2021-12-23 | Jasper | Missouri | 29097 | 14971 | 260 |
2039159 | 2039159 | 2021-12-22 | Jasper | Missouri | 29097 | 14930 | 260 |
2035909 | 2035909 | 2021-12-21 | Jasper | Missouri | 29097 | 14900 | 260 |
2032659 | 2032659 | 2021-12-20 | Jasper | Missouri | 29097 | 14875 | 260 |
2029408 | 2029408 | 2021-12-19 | Jasper | Missouri | 29097 | 14853 | 260 |
2026157 | 2026157 | 2021-12-18 | Jasper | Missouri | 29097 | 14846 | 260 |
2022906 | 2022906 | 2021-12-17 | Jasper | Missouri | 29097 | 14814 | 260 |
2019655 | 2019655 | 2021-12-16 | Jasper | Missouri | 29097 | 14768 | 260 |
2016405 | 2016405 | 2021-12-15 | Jasper | Missouri | 29097 | 14728 | 260 |
2013154 | 2013154 | 2021-12-14 | Jasper | Missouri | 29097 | 14695 | 260 |
2009903 | 2009903 | 2021-12-13 | Jasper | Missouri | 29097 | 14654 | 259 |
2006652 | 2006652 | 2021-12-12 | Jasper | Missouri | 29097 | 14650 | 259 |
2003401 | 2003401 | 2021-12-11 | Jasper | Missouri | 29097 | 14637 | 259 |
2000151 | 2000151 | 2021-12-10 | Jasper | Missouri | 29097 | 14609 | 259 |
1996900 | 1996900 | 2021-12-09 | Jasper | Missouri | 29097 | 14577 | 259 |
1993649 | 1993649 | 2021-12-08 | Jasper | Missouri | 29097 | 14534 | 255 |
1990398 | 1990398 | 2021-12-07 | Jasper | Missouri | 29097 | 14482 | 255 |
1987148 | 1987148 | 2021-12-06 | Jasper | Missouri | 29097 | 14446 | 255 |
1983898 | 1983898 | 2021-12-05 | Jasper | Missouri | 29097 | 14430 | 255 |
1980648 | 1980648 | 2021-12-04 | Jasper | Missouri | 29097 | 14412 | 255 |
1977398 | 1977398 | 2021-12-03 | Jasper | Missouri | 29097 | 14365 | 255 |
1974148 | 1974148 | 2021-12-02 | Jasper | Missouri | 29097 | 14365 | 255 |
1970899 | 1970899 | 2021-12-01 | Jasper | Missouri | 29097 | 14312 | 255 |
1967649 | 1967649 | 2021-11-30 | Jasper | Missouri | 29097 | 14278 | 255 |
1964397 | 1964397 | 2021-11-29 | Jasper | Missouri | 29097 | 14229 | 254 |
1961146 | 1961146 | 2021-11-28 | Jasper | Missouri | 29097 | 14175 | 254 |
1957895 | 1957895 | 2021-11-27 | Jasper | Missouri | 29097 | 14175 | 254 |
1954644 | 1954644 | 2021-11-26 | Jasper | Missouri | 29097 | 14175 | 254 |
1951393 | 1951393 | 2021-11-25 | Jasper | Missouri | 29097 | 14175 | 254 |
1948142 | 1948142 | 2021-11-24 | Jasper | Missouri | 29097 | 14175 | 254 |
1944891 | 1944891 | 2021-11-23 | Jasper | Missouri | 29097 | 14150 | 252 |
1941640 | 1941640 | 2021-11-22 | Jasper | Missouri | 29097 | 14124 | 252 |
1938390 | 1938390 | 2021-11-21 | Jasper | Missouri | 29097 | 14120 | 253 |
1935140 | 1935140 | 2021-11-20 | Jasper | Missouri | 29097 | 14111 | 253 |
1931890 | 1931890 | 2021-11-19 | Jasper | Missouri | 29097 | 14084 | 253 |
1928639 | 1928639 | 2021-11-18 | Jasper | Missouri | 29097 | 14074 | 252 |
1925389 | 1925389 | 2021-11-17 | Jasper | Missouri | 29097 | 13941 | 205 |
1922140 | 1922140 | 2021-11-16 | Jasper | Missouri | 29097 | 13924 | 205 |
1918890 | 1918890 | 2021-11-15 | Jasper | Missouri | 29097 | 13905 | 204 |
1915640 | 1915640 | 2021-11-14 | Jasper | Missouri | 29097 | 13902 | 204 |
1912390 | 1912390 | 2021-11-13 | Jasper | Missouri | 29097 | 13898 | 204 |
1909140 | 1909140 | 2021-11-12 | Jasper | Missouri | 29097 | 13882 | 203 |
1905891 | 1905891 | 2021-11-11 | Jasper | Missouri | 29097 | 13851 | 203 |
1902642 | 1902642 | 2021-11-10 | Jasper | Missouri | 29097 | 13851 | 203 |
1899392 | 1899392 | 2021-11-09 | Jasper | Missouri | 29097 | 13841 | 203 |
1896142 | 1896142 | 2021-11-08 | Jasper | Missouri | 29097 | 13822 | 203 |
1892892 | 1892892 | 2021-11-07 | Jasper | Missouri | 29097 | 13817 | 203 |
1889642 | 1889642 | 2021-11-06 | Jasper | Missouri | 29097 | 13815 | 203 |
1886392 | 1886392 | 2021-11-05 | Jasper | Missouri | 29097 | 13799 | 203 |
1883143 | 1883143 | 2021-11-04 | Jasper | Missouri | 29097 | 13784 | 202 |
1879894 | 1879894 | 2021-11-03 | Jasper | Missouri | 29097 | 13768 | 202 |
1876645 | 1876645 | 2021-11-02 | Jasper | Missouri | 29097 | 13757 | 202 |
1873396 | 1873396 | 2021-11-01 | Jasper | Missouri | 29097 | 13748 | 199 |
1870147 | 1870147 | 2021-10-31 | Jasper | Missouri | 29097 | 13746 | 199 |
1866898 | 1866898 | 2021-10-30 | Jasper | Missouri | 29097 | 13745 | 199 |
1863649 | 1863649 | 2021-10-29 | Jasper | Missouri | 29097 | 13731 | 199 |
1860400 | 1860400 | 2021-10-28 | Jasper | Missouri | 29097 | 13718 | 197 |
1857151 | 1857151 | 2021-10-27 | Jasper | Missouri | 29097 | 13706 | 197 |
1853902 | 1853902 | 2021-10-26 | Jasper | Missouri | 29097 | 13690 | 197 |
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);