ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Clark" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175715 | 2175715 | 2022-02-02 | Clark | Missouri | 29045 | 1521 | 28 |
2172462 | 2172462 | 2022-02-01 | Clark | Missouri | 29045 | 1511 | 28 |
2169209 | 2169209 | 2022-01-31 | Clark | Missouri | 29045 | 1507 | 28 |
2165954 | 2165954 | 2022-01-30 | Clark | Missouri | 29045 | 1506 | 28 |
2162699 | 2162699 | 2022-01-29 | Clark | Missouri | 29045 | 1505 | 28 |
2159444 | 2159444 | 2022-01-28 | Clark | Missouri | 29045 | 1494 | 28 |
2156190 | 2156190 | 2022-01-27 | Clark | Missouri | 29045 | 1469 | 28 |
2152937 | 2152937 | 2022-01-26 | Clark | Missouri | 29045 | 1458 | 28 |
2149685 | 2149685 | 2022-01-25 | Clark | Missouri | 29045 | 1447 | 28 |
2146433 | 2146433 | 2022-01-24 | Clark | Missouri | 29045 | 1436 | 28 |
2143178 | 2143178 | 2022-01-23 | Clark | Missouri | 29045 | 1432 | 28 |
2139923 | 2139923 | 2022-01-22 | Clark | Missouri | 29045 | 1430 | 28 |
2136667 | 2136667 | 2022-01-21 | Clark | Missouri | 29045 | 1412 | 28 |
2133415 | 2133415 | 2022-01-20 | Clark | Missouri | 29045 | 1409 | 28 |
2130162 | 2130162 | 2022-01-19 | Clark | Missouri | 29045 | 1390 | 28 |
2126908 | 2126908 | 2022-01-18 | Clark | Missouri | 29045 | 1381 | 28 |
2123656 | 2123656 | 2022-01-17 | Clark | Missouri | 29045 | 1371 | 28 |
2120404 | 2120404 | 2022-01-16 | Clark | Missouri | 29045 | 1371 | 28 |
2117152 | 2117152 | 2022-01-15 | Clark | Missouri | 29045 | 1371 | 28 |
2113901 | 2113901 | 2022-01-14 | Clark | Missouri | 29045 | 1359 | 28 |
2110649 | 2110649 | 2022-01-13 | Clark | Missouri | 29045 | 1354 | 28 |
2107398 | 2107398 | 2022-01-12 | Clark | Missouri | 29045 | 1338 | 28 |
2104147 | 2104147 | 2022-01-11 | Clark | Missouri | 29045 | 1335 | 28 |
2100896 | 2100896 | 2022-01-10 | Clark | Missouri | 29045 | 1325 | 28 |
2097645 | 2097645 | 2022-01-09 | Clark | Missouri | 29045 | 1325 | 28 |
2094393 | 2094393 | 2022-01-08 | Clark | Missouri | 29045 | 1324 | 28 |
2091141 | 2091141 | 2022-01-07 | Clark | Missouri | 29045 | 1314 | 28 |
2087890 | 2087890 | 2022-01-06 | Clark | Missouri | 29045 | 1307 | 28 |
2084638 | 2084638 | 2022-01-05 | Clark | Missouri | 29045 | 1298 | 28 |
2081386 | 2081386 | 2022-01-04 | Clark | Missouri | 29045 | 1291 | 28 |
2078134 | 2078134 | 2022-01-03 | Clark | Missouri | 29045 | 1283 | 28 |
2074883 | 2074883 | 2022-01-02 | Clark | Missouri | 29045 | 1279 | 28 |
2071632 | 2071632 | 2022-01-01 | Clark | Missouri | 29045 | 1279 | 28 |
2068381 | 2068381 | 2021-12-31 | Clark | Missouri | 29045 | 1279 | 28 |
2065130 | 2065130 | 2021-12-30 | Clark | Missouri | 29045 | 1279 | 28 |
2061880 | 2061880 | 2021-12-29 | Clark | Missouri | 29045 | 1271 | 28 |
2058631 | 2058631 | 2021-12-28 | Clark | Missouri | 29045 | 1267 | 28 |
2055382 | 2055382 | 2021-12-27 | Clark | Missouri | 29045 | 1263 | 28 |
2052132 | 2052132 | 2021-12-26 | Clark | Missouri | 29045 | 1256 | 28 |
2048882 | 2048882 | 2021-12-25 | Clark | Missouri | 29045 | 1256 | 28 |
2045632 | 2045632 | 2021-12-24 | Clark | Missouri | 29045 | 1256 | 28 |
2042382 | 2042382 | 2021-12-23 | Clark | Missouri | 29045 | 1256 | 28 |
2039133 | 2039133 | 2021-12-22 | Clark | Missouri | 29045 | 1246 | 28 |
2035883 | 2035883 | 2021-12-21 | Clark | Missouri | 29045 | 1243 | 28 |
2032633 | 2032633 | 2021-12-20 | Clark | Missouri | 29045 | 1230 | 28 |
2029382 | 2029382 | 2021-12-19 | Clark | Missouri | 29045 | 1228 | 28 |
2026131 | 2026131 | 2021-12-18 | Clark | Missouri | 29045 | 1228 | 28 |
2022880 | 2022880 | 2021-12-17 | Clark | Missouri | 29045 | 1214 | 28 |
2019629 | 2019629 | 2021-12-16 | Clark | Missouri | 29045 | 1211 | 28 |
2016379 | 2016379 | 2021-12-15 | Clark | Missouri | 29045 | 1207 | 28 |
2013128 | 2013128 | 2021-12-14 | Clark | Missouri | 29045 | 1203 | 28 |
2009877 | 2009877 | 2021-12-13 | Clark | Missouri | 29045 | 1202 | 27 |
2006626 | 2006626 | 2021-12-12 | Clark | Missouri | 29045 | 1202 | 27 |
2003375 | 2003375 | 2021-12-11 | Clark | Missouri | 29045 | 1200 | 27 |
2000125 | 2000125 | 2021-12-10 | Clark | Missouri | 29045 | 1200 | 27 |
1996874 | 1996874 | 2021-12-09 | Clark | Missouri | 29045 | 1187 | 27 |
1993623 | 1993623 | 2021-12-08 | Clark | Missouri | 29045 | 1185 | 27 |
1990372 | 1990372 | 2021-12-07 | Clark | Missouri | 29045 | 1166 | 27 |
1987122 | 1987122 | 2021-12-06 | Clark | Missouri | 29045 | 1161 | 27 |
1983872 | 1983872 | 2021-12-05 | Clark | Missouri | 29045 | 1158 | 27 |
1980622 | 1980622 | 2021-12-04 | Clark | Missouri | 29045 | 1158 | 27 |
1977372 | 1977372 | 2021-12-03 | Clark | Missouri | 29045 | 1144 | 27 |
1974122 | 1974122 | 2021-12-02 | Clark | Missouri | 29045 | 1144 | 27 |
1970873 | 1970873 | 2021-12-01 | Clark | Missouri | 29045 | 1141 | 27 |
1967623 | 1967623 | 2021-11-30 | Clark | Missouri | 29045 | 1118 | 27 |
1964371 | 1964371 | 2021-11-29 | Clark | Missouri | 29045 | 1116 | 27 |
1961120 | 1961120 | 2021-11-28 | Clark | Missouri | 29045 | 1098 | 27 |
1957869 | 1957869 | 2021-11-27 | Clark | Missouri | 29045 | 1098 | 27 |
1954618 | 1954618 | 2021-11-26 | Clark | Missouri | 29045 | 1098 | 27 |
1951367 | 1951367 | 2021-11-25 | Clark | Missouri | 29045 | 1098 | 27 |
1948116 | 1948116 | 2021-11-24 | Clark | Missouri | 29045 | 1098 | 27 |
1944865 | 1944865 | 2021-11-23 | Clark | Missouri | 29045 | 1096 | 27 |
1941614 | 1941614 | 2021-11-22 | Clark | Missouri | 29045 | 1085 | 27 |
1938364 | 1938364 | 2021-11-21 | Clark | Missouri | 29045 | 1084 | 27 |
1935114 | 1935114 | 2021-11-20 | Clark | Missouri | 29045 | 1082 | 27 |
1931864 | 1931864 | 2021-11-19 | Clark | Missouri | 29045 | 1074 | 27 |
1928613 | 1928613 | 2021-11-18 | Clark | Missouri | 29045 | 1072 | 27 |
1925363 | 1925363 | 2021-11-17 | Clark | Missouri | 29045 | 1054 | 12 |
1922114 | 1922114 | 2021-11-16 | Clark | Missouri | 29045 | 1051 | 12 |
1918864 | 1918864 | 2021-11-15 | Clark | Missouri | 29045 | 1035 | 12 |
1915614 | 1915614 | 2021-11-14 | Clark | Missouri | 29045 | 1035 | 12 |
1912364 | 1912364 | 2021-11-13 | Clark | Missouri | 29045 | 1034 | 12 |
1909114 | 1909114 | 2021-11-12 | Clark | Missouri | 29045 | 1027 | 12 |
1905865 | 1905865 | 2021-11-11 | Clark | Missouri | 29045 | 1023 | 12 |
1902616 | 1902616 | 2021-11-10 | Clark | Missouri | 29045 | 1023 | 12 |
1899366 | 1899366 | 2021-11-09 | Clark | Missouri | 29045 | 1016 | 12 |
1896116 | 1896116 | 2021-11-08 | Clark | Missouri | 29045 | 1012 | 12 |
1892866 | 1892866 | 2021-11-07 | Clark | Missouri | 29045 | 1011 | 12 |
1889616 | 1889616 | 2021-11-06 | Clark | Missouri | 29045 | 1006 | 12 |
1886366 | 1886366 | 2021-11-05 | Clark | Missouri | 29045 | 1003 | 12 |
1883117 | 1883117 | 2021-11-04 | Clark | Missouri | 29045 | 1002 | 12 |
1879868 | 1879868 | 2021-11-03 | Clark | Missouri | 29045 | 1002 | 12 |
1876619 | 1876619 | 2021-11-02 | Clark | Missouri | 29045 | 1002 | 12 |
1873370 | 1873370 | 2021-11-01 | Clark | Missouri | 29045 | 996 | 12 |
1870121 | 1870121 | 2021-10-31 | Clark | Missouri | 29045 | 996 | 12 |
1866872 | 1866872 | 2021-10-30 | Clark | Missouri | 29045 | 996 | 12 |
1863623 | 1863623 | 2021-10-29 | Clark | Missouri | 29045 | 994 | 12 |
1860374 | 1860374 | 2021-10-28 | Clark | Missouri | 29045 | 993 | 12 |
1857125 | 1857125 | 2021-10-27 | Clark | Missouri | 29045 | 993 | 12 |
1853876 | 1853876 | 2021-10-26 | Clark | Missouri | 29045 | 990 | 12 |
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);