ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Caldwell" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175705 | 2175705 | 2022-02-02 | Caldwell | Missouri | 29025 | 1564 | 30 |
2172452 | 2172452 | 2022-02-01 | Caldwell | Missouri | 29025 | 1555 | 30 |
2169199 | 2169199 | 2022-01-31 | Caldwell | Missouri | 29025 | 1543 | 29 |
2165944 | 2165944 | 2022-01-30 | Caldwell | Missouri | 29025 | 1540 | 29 |
2162689 | 2162689 | 2022-01-29 | Caldwell | Missouri | 29025 | 1538 | 29 |
2159434 | 2159434 | 2022-01-28 | Caldwell | Missouri | 29025 | 1531 | 29 |
2156180 | 2156180 | 2022-01-27 | Caldwell | Missouri | 29025 | 1523 | 29 |
2152927 | 2152927 | 2022-01-26 | Caldwell | Missouri | 29025 | 1513 | 29 |
2149675 | 2149675 | 2022-01-25 | Caldwell | Missouri | 29025 | 1504 | 29 |
2146423 | 2146423 | 2022-01-24 | Caldwell | Missouri | 29025 | 1492 | 29 |
2143168 | 2143168 | 2022-01-23 | Caldwell | Missouri | 29025 | 1487 | 29 |
2139913 | 2139913 | 2022-01-22 | Caldwell | Missouri | 29025 | 1478 | 29 |
2136657 | 2136657 | 2022-01-21 | Caldwell | Missouri | 29025 | 1467 | 29 |
2133405 | 2133405 | 2022-01-20 | Caldwell | Missouri | 29025 | 1459 | 29 |
2130152 | 2130152 | 2022-01-19 | Caldwell | Missouri | 29025 | 1457 | 29 |
2126898 | 2126898 | 2022-01-18 | Caldwell | Missouri | 29025 | 1451 | 29 |
2123646 | 2123646 | 2022-01-17 | Caldwell | Missouri | 29025 | 1446 | 28 |
2120394 | 2120394 | 2022-01-16 | Caldwell | Missouri | 29025 | 1446 | 28 |
2117142 | 2117142 | 2022-01-15 | Caldwell | Missouri | 29025 | 1446 | 28 |
2113891 | 2113891 | 2022-01-14 | Caldwell | Missouri | 29025 | 1430 | 28 |
2110639 | 2110639 | 2022-01-13 | Caldwell | Missouri | 29025 | 1418 | 28 |
2107388 | 2107388 | 2022-01-12 | Caldwell | Missouri | 29025 | 1409 | 28 |
2104137 | 2104137 | 2022-01-11 | Caldwell | Missouri | 29025 | 1405 | 28 |
2100886 | 2100886 | 2022-01-10 | Caldwell | Missouri | 29025 | 1411 | 27 |
2097635 | 2097635 | 2022-01-09 | Caldwell | Missouri | 29025 | 1410 | 27 |
2094383 | 2094383 | 2022-01-08 | Caldwell | Missouri | 29025 | 1409 | 27 |
2091131 | 2091131 | 2022-01-07 | Caldwell | Missouri | 29025 | 1393 | 27 |
2087880 | 2087880 | 2022-01-06 | Caldwell | Missouri | 29025 | 1389 | 27 |
2084628 | 2084628 | 2022-01-05 | Caldwell | Missouri | 29025 | 1381 | 27 |
2081376 | 2081376 | 2022-01-04 | Caldwell | Missouri | 29025 | 1379 | 27 |
2078124 | 2078124 | 2022-01-03 | Caldwell | Missouri | 29025 | 1367 | 26 |
2074873 | 2074873 | 2022-01-02 | Caldwell | Missouri | 29025 | 1358 | 26 |
2071622 | 2071622 | 2022-01-01 | Caldwell | Missouri | 29025 | 1358 | 26 |
2068371 | 2068371 | 2021-12-31 | Caldwell | Missouri | 29025 | 1358 | 26 |
2065120 | 2065120 | 2021-12-30 | Caldwell | Missouri | 29025 | 1358 | 26 |
2061870 | 2061870 | 2021-12-29 | Caldwell | Missouri | 29025 | 1347 | 26 |
2058621 | 2058621 | 2021-12-28 | Caldwell | Missouri | 29025 | 1339 | 26 |
2055372 | 2055372 | 2021-12-27 | Caldwell | Missouri | 29025 | 1337 | 26 |
2052122 | 2052122 | 2021-12-26 | Caldwell | Missouri | 29025 | 1329 | 26 |
2048872 | 2048872 | 2021-12-25 | Caldwell | Missouri | 29025 | 1329 | 26 |
2045622 | 2045622 | 2021-12-24 | Caldwell | Missouri | 29025 | 1329 | 26 |
2042372 | 2042372 | 2021-12-23 | Caldwell | Missouri | 29025 | 1329 | 26 |
2039123 | 2039123 | 2021-12-22 | Caldwell | Missouri | 29025 | 1320 | 26 |
2035873 | 2035873 | 2021-12-21 | Caldwell | Missouri | 29025 | 1313 | 26 |
2032623 | 2032623 | 2021-12-20 | Caldwell | Missouri | 29025 | 1309 | 26 |
2029372 | 2029372 | 2021-12-19 | Caldwell | Missouri | 29025 | 1305 | 26 |
2026121 | 2026121 | 2021-12-18 | Caldwell | Missouri | 29025 | 1305 | 26 |
2022870 | 2022870 | 2021-12-17 | Caldwell | Missouri | 29025 | 1301 | 26 |
2019619 | 2019619 | 2021-12-16 | Caldwell | Missouri | 29025 | 1298 | 26 |
2016369 | 2016369 | 2021-12-15 | Caldwell | Missouri | 29025 | 1289 | 26 |
2013118 | 2013118 | 2021-12-14 | Caldwell | Missouri | 29025 | 1286 | 26 |
2009867 | 2009867 | 2021-12-13 | Caldwell | Missouri | 29025 | 1285 | 26 |
2006616 | 2006616 | 2021-12-12 | Caldwell | Missouri | 29025 | 1284 | 26 |
2003365 | 2003365 | 2021-12-11 | Caldwell | Missouri | 29025 | 1283 | 26 |
2000115 | 2000115 | 2021-12-10 | Caldwell | Missouri | 29025 | 1282 | 26 |
1996864 | 1996864 | 2021-12-09 | Caldwell | Missouri | 29025 | 1277 | 26 |
1993613 | 1993613 | 2021-12-08 | Caldwell | Missouri | 29025 | 1271 | 26 |
1990362 | 1990362 | 2021-12-07 | Caldwell | Missouri | 29025 | 1263 | 26 |
1987112 | 1987112 | 2021-12-06 | Caldwell | Missouri | 29025 | 1262 | 26 |
1983862 | 1983862 | 2021-12-05 | Caldwell | Missouri | 29025 | 1260 | 26 |
1980612 | 1980612 | 2021-12-04 | Caldwell | Missouri | 29025 | 1256 | 26 |
1977362 | 1977362 | 2021-12-03 | Caldwell | Missouri | 29025 | 1248 | 26 |
1974112 | 1974112 | 2021-12-02 | Caldwell | Missouri | 29025 | 1248 | 26 |
1970863 | 1970863 | 2021-12-01 | Caldwell | Missouri | 29025 | 1232 | 26 |
1967613 | 1967613 | 2021-11-30 | Caldwell | Missouri | 29025 | 1220 | 26 |
1964361 | 1964361 | 2021-11-29 | Caldwell | Missouri | 29025 | 1213 | 25 |
1961110 | 1961110 | 2021-11-28 | Caldwell | Missouri | 29025 | 1201 | 25 |
1957859 | 1957859 | 2021-11-27 | Caldwell | Missouri | 29025 | 1201 | 25 |
1954608 | 1954608 | 2021-11-26 | Caldwell | Missouri | 29025 | 1201 | 25 |
1951357 | 1951357 | 2021-11-25 | Caldwell | Missouri | 29025 | 1201 | 25 |
1948106 | 1948106 | 2021-11-24 | Caldwell | Missouri | 29025 | 1201 | 25 |
1944855 | 1944855 | 2021-11-23 | Caldwell | Missouri | 29025 | 1201 | 25 |
1941604 | 1941604 | 2021-11-22 | Caldwell | Missouri | 29025 | 1200 | 25 |
1938354 | 1938354 | 2021-11-21 | Caldwell | Missouri | 29025 | 1200 | 25 |
1935104 | 1935104 | 2021-11-20 | Caldwell | Missouri | 29025 | 1200 | 25 |
1931854 | 1931854 | 2021-11-19 | Caldwell | Missouri | 29025 | 1194 | 25 |
1928603 | 1928603 | 2021-11-18 | Caldwell | Missouri | 29025 | 1192 | 25 |
1925353 | 1925353 | 2021-11-17 | Caldwell | Missouri | 29025 | 1179 | 20 |
1922104 | 1922104 | 2021-11-16 | Caldwell | Missouri | 29025 | 1172 | 20 |
1918854 | 1918854 | 2021-11-15 | Caldwell | Missouri | 29025 | 1168 | 20 |
1915604 | 1915604 | 2021-11-14 | Caldwell | Missouri | 29025 | 1167 | 20 |
1912354 | 1912354 | 2021-11-13 | Caldwell | Missouri | 29025 | 1166 | 20 |
1909104 | 1909104 | 2021-11-12 | Caldwell | Missouri | 29025 | 1157 | 20 |
1905855 | 1905855 | 2021-11-11 | Caldwell | Missouri | 29025 | 1151 | 20 |
1902606 | 1902606 | 2021-11-10 | Caldwell | Missouri | 29025 | 1151 | 20 |
1899356 | 1899356 | 2021-11-09 | Caldwell | Missouri | 29025 | 1149 | 20 |
1896106 | 1896106 | 2021-11-08 | Caldwell | Missouri | 29025 | 1147 | 20 |
1892856 | 1892856 | 2021-11-07 | Caldwell | Missouri | 29025 | 1147 | 20 |
1889606 | 1889606 | 2021-11-06 | Caldwell | Missouri | 29025 | 1146 | 20 |
1886356 | 1886356 | 2021-11-05 | Caldwell | Missouri | 29025 | 1146 | 20 |
1883107 | 1883107 | 2021-11-04 | Caldwell | Missouri | 29025 | 1145 | 20 |
1879858 | 1879858 | 2021-11-03 | Caldwell | Missouri | 29025 | 1143 | 20 |
1876609 | 1876609 | 2021-11-02 | Caldwell | Missouri | 29025 | 1142 | 20 |
1873360 | 1873360 | 2021-11-01 | Caldwell | Missouri | 29025 | 1143 | 20 |
1870111 | 1870111 | 2021-10-31 | Caldwell | Missouri | 29025 | 1140 | 20 |
1866862 | 1866862 | 2021-10-30 | Caldwell | Missouri | 29025 | 1138 | 20 |
1863613 | 1863613 | 2021-10-29 | Caldwell | Missouri | 29025 | 1135 | 20 |
1860364 | 1860364 | 2021-10-28 | Caldwell | Missouri | 29025 | 1134 | 20 |
1857115 | 1857115 | 2021-10-27 | Caldwell | Missouri | 29025 | 1135 | 20 |
1853866 | 1853866 | 2021-10-26 | Caldwell | Missouri | 29025 | 1133 | 20 |
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);