ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jefferson" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175742 | 2175742 | 2022-02-02 | Jefferson | Missouri | 29099 | 51988 | 533 |
2172489 | 2172489 | 2022-02-01 | Jefferson | Missouri | 29099 | 51429 | 530 |
2169236 | 2169236 | 2022-01-31 | Jefferson | Missouri | 29099 | 51238 | 505 |
2165981 | 2165981 | 2022-01-30 | Jefferson | Missouri | 29099 | 51163 | 505 |
2162726 | 2162726 | 2022-01-29 | Jefferson | Missouri | 29099 | 51054 | 505 |
2159471 | 2159471 | 2022-01-28 | Jefferson | Missouri | 29099 | 50758 | 505 |
2156217 | 2156217 | 2022-01-27 | Jefferson | Missouri | 29099 | 50402 | 504 |
2152964 | 2152964 | 2022-01-26 | Jefferson | Missouri | 29099 | 50107 | 504 |
2149712 | 2149712 | 2022-01-25 | Jefferson | Missouri | 29099 | 49714 | 504 |
2146460 | 2146460 | 2022-01-24 | Jefferson | Missouri | 29099 | 49445 | 503 |
2143205 | 2143205 | 2022-01-23 | Jefferson | Missouri | 29099 | 49223 | 503 |
2139950 | 2139950 | 2022-01-22 | Jefferson | Missouri | 29099 | 48967 | 503 |
2136694 | 2136694 | 2022-01-21 | Jefferson | Missouri | 29099 | 48654 | 503 |
2133442 | 2133442 | 2022-01-20 | Jefferson | Missouri | 29099 | 48074 | 490 |
2130189 | 2130189 | 2022-01-19 | Jefferson | Missouri | 29099 | 47611 | 490 |
2126935 | 2126935 | 2022-01-18 | Jefferson | Missouri | 29099 | 47064 | 480 |
2123683 | 2123683 | 2022-01-17 | Jefferson | Missouri | 29099 | 46185 | 480 |
2120431 | 2120431 | 2022-01-16 | Jefferson | Missouri | 29099 | 46185 | 480 |
2117179 | 2117179 | 2022-01-15 | Jefferson | Missouri | 29099 | 46184 | 480 |
2113928 | 2113928 | 2022-01-14 | Jefferson | Missouri | 29099 | 45422 | 480 |
2110676 | 2110676 | 2022-01-13 | Jefferson | Missouri | 29099 | 45153 | 480 |
2107425 | 2107425 | 2022-01-12 | Jefferson | Missouri | 29099 | 44608 | 480 |
2104174 | 2104174 | 2022-01-11 | Jefferson | Missouri | 29099 | 44088 | 481 |
2100923 | 2100923 | 2022-01-10 | Jefferson | Missouri | 29099 | 43452 | 470 |
2097672 | 2097672 | 2022-01-09 | Jefferson | Missouri | 29099 | 43121 | 470 |
2094420 | 2094420 | 2022-01-08 | Jefferson | Missouri | 29099 | 43012 | 470 |
2091168 | 2091168 | 2022-01-07 | Jefferson | Missouri | 29099 | 42349 | 470 |
2087917 | 2087917 | 2022-01-06 | Jefferson | Missouri | 29099 | 41811 | 470 |
2084665 | 2084665 | 2022-01-05 | Jefferson | Missouri | 29099 | 41279 | 470 |
2081413 | 2081413 | 2022-01-04 | Jefferson | Missouri | 29099 | 40736 | 470 |
2078161 | 2078161 | 2022-01-03 | Jefferson | Missouri | 29099 | 40503 | 459 |
2074910 | 2074910 | 2022-01-02 | Jefferson | Missouri | 29099 | 39372 | 459 |
2071659 | 2071659 | 2022-01-01 | Jefferson | Missouri | 29099 | 39372 | 459 |
2068408 | 2068408 | 2021-12-31 | Jefferson | Missouri | 29099 | 39372 | 459 |
2065157 | 2065157 | 2021-12-30 | Jefferson | Missouri | 29099 | 39372 | 459 |
2061907 | 2061907 | 2021-12-29 | Jefferson | Missouri | 29099 | 39035 | 459 |
2058658 | 2058658 | 2021-12-28 | Jefferson | Missouri | 29099 | 38778 | 459 |
2055409 | 2055409 | 2021-12-27 | Jefferson | Missouri | 29099 | 38582 | 450 |
2052159 | 2052159 | 2021-12-26 | Jefferson | Missouri | 29099 | 38157 | 450 |
2048909 | 2048909 | 2021-12-25 | Jefferson | Missouri | 29099 | 38157 | 450 |
2045659 | 2045659 | 2021-12-24 | Jefferson | Missouri | 29099 | 38157 | 450 |
2042409 | 2042409 | 2021-12-23 | Jefferson | Missouri | 29099 | 38157 | 450 |
2039160 | 2039160 | 2021-12-22 | Jefferson | Missouri | 29099 | 37887 | 450 |
2035910 | 2035910 | 2021-12-21 | Jefferson | Missouri | 29099 | 37712 | 450 |
2032660 | 2032660 | 2021-12-20 | Jefferson | Missouri | 29099 | 37605 | 442 |
2029409 | 2029409 | 2021-12-19 | Jefferson | Missouri | 29099 | 37531 | 442 |
2026158 | 2026158 | 2021-12-18 | Jefferson | Missouri | 29099 | 37443 | 442 |
2022907 | 2022907 | 2021-12-17 | Jefferson | Missouri | 29099 | 37270 | 442 |
2019656 | 2019656 | 2021-12-16 | Jefferson | Missouri | 29099 | 37126 | 442 |
2016406 | 2016406 | 2021-12-15 | Jefferson | Missouri | 29099 | 36932 | 442 |
2013155 | 2013155 | 2021-12-14 | Jefferson | Missouri | 29099 | 36752 | 441 |
2009904 | 2009904 | 2021-12-13 | Jefferson | Missouri | 29099 | 36658 | 435 |
2006653 | 2006653 | 2021-12-12 | Jefferson | Missouri | 29099 | 36591 | 435 |
2003402 | 2003402 | 2021-12-11 | Jefferson | Missouri | 29099 | 36477 | 435 |
2000152 | 2000152 | 2021-12-10 | Jefferson | Missouri | 29099 | 36359 | 435 |
1996901 | 1996901 | 2021-12-09 | Jefferson | Missouri | 29099 | 36102 | 435 |
1993650 | 1993650 | 2021-12-08 | Jefferson | Missouri | 29099 | 35923 | 435 |
1990399 | 1990399 | 2021-12-07 | Jefferson | Missouri | 29099 | 35733 | 435 |
1987149 | 1987149 | 2021-12-06 | Jefferson | Missouri | 29099 | 35662 | 428 |
1983899 | 1983899 | 2021-12-05 | Jefferson | Missouri | 29099 | 35478 | 428 |
1980649 | 1980649 | 2021-12-04 | Jefferson | Missouri | 29099 | 35425 | 428 |
1977399 | 1977399 | 2021-12-03 | Jefferson | Missouri | 29099 | 35165 | 428 |
1974149 | 1974149 | 2021-12-02 | Jefferson | Missouri | 29099 | 35165 | 428 |
1970900 | 1970900 | 2021-12-01 | Jefferson | Missouri | 29099 | 35010 | 428 |
1967650 | 1967650 | 2021-11-30 | Jefferson | Missouri | 29099 | 34847 | 428 |
1964398 | 1964398 | 2021-11-29 | Jefferson | Missouri | 29099 | 34752 | 425 |
1961147 | 1961147 | 2021-11-28 | Jefferson | Missouri | 29099 | 34420 | 425 |
1957896 | 1957896 | 2021-11-27 | Jefferson | Missouri | 29099 | 34420 | 425 |
1954645 | 1954645 | 2021-11-26 | Jefferson | Missouri | 29099 | 34420 | 425 |
1951394 | 1951394 | 2021-11-25 | Jefferson | Missouri | 29099 | 34420 | 425 |
1948143 | 1948143 | 2021-11-24 | Jefferson | Missouri | 29099 | 34420 | 425 |
1944892 | 1944892 | 2021-11-23 | Jefferson | Missouri | 29099 | 34314 | 424 |
1941641 | 1941641 | 2021-11-22 | Jefferson | Missouri | 29099 | 34225 | 417 |
1938391 | 1938391 | 2021-11-21 | Jefferson | Missouri | 29099 | 34186 | 421 |
1935141 | 1935141 | 2021-11-20 | Jefferson | Missouri | 29099 | 34132 | 421 |
1931891 | 1931891 | 2021-11-19 | Jefferson | Missouri | 29099 | 34045 | 421 |
1928640 | 1928640 | 2021-11-18 | Jefferson | Missouri | 29099 | 33964 | 417 |
1925390 | 1925390 | 2021-11-17 | Jefferson | Missouri | 29099 | 33482 | 350 |
1922141 | 1922141 | 2021-11-16 | Jefferson | Missouri | 29099 | 33407 | 350 |
1918891 | 1918891 | 2021-11-15 | Jefferson | Missouri | 29099 | 33342 | 346 |
1915641 | 1915641 | 2021-11-14 | Jefferson | Missouri | 29099 | 33293 | 346 |
1912391 | 1912391 | 2021-11-13 | Jefferson | Missouri | 29099 | 33248 | 346 |
1909141 | 1909141 | 2021-11-12 | Jefferson | Missouri | 29099 | 33179 | 346 |
1905892 | 1905892 | 2021-11-11 | Jefferson | Missouri | 29099 | 33015 | 346 |
1902643 | 1902643 | 2021-11-10 | Jefferson | Missouri | 29099 | 33015 | 346 |
1899393 | 1899393 | 2021-11-09 | Jefferson | Missouri | 29099 | 32947 | 345 |
1896143 | 1896143 | 2021-11-08 | Jefferson | Missouri | 29099 | 32888 | 335 |
1892893 | 1892893 | 2021-11-07 | Jefferson | Missouri | 29099 | 32854 | 335 |
1889643 | 1889643 | 2021-11-06 | Jefferson | Missouri | 29099 | 32809 | 335 |
1886393 | 1886393 | 2021-11-05 | Jefferson | Missouri | 29099 | 32747 | 335 |
1883144 | 1883144 | 2021-11-04 | Jefferson | Missouri | 29099 | 32688 | 335 |
1879895 | 1879895 | 2021-11-03 | Jefferson | Missouri | 29099 | 32639 | 335 |
1876646 | 1876646 | 2021-11-02 | Jefferson | Missouri | 29099 | 32565 | 335 |
1873397 | 1873397 | 2021-11-01 | Jefferson | Missouri | 29099 | 32520 | 331 |
1870148 | 1870148 | 2021-10-31 | Jefferson | Missouri | 29099 | 32491 | 331 |
1866899 | 1866899 | 2021-10-30 | Jefferson | Missouri | 29099 | 32440 | 331 |
1863650 | 1863650 | 2021-10-29 | Jefferson | Missouri | 29099 | 32376 | 330 |
1860401 | 1860401 | 2021-10-28 | Jefferson | Missouri | 29099 | 32332 | 330 |
1857152 | 1857152 | 2021-10-27 | Jefferson | Missouri | 29099 | 32284 | 329 |
1853903 | 1853903 | 2021-10-26 | Jefferson | Missouri | 29099 | 32227 | 328 |
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);