ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
759 rows where county = "Daviess" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175723 | 2175723 | 2022-02-02 | Daviess | Missouri | 29061 | 1552 | 25 |
2172470 | 2172470 | 2022-02-01 | Daviess | Missouri | 29061 | 1538 | 25 |
2169217 | 2169217 | 2022-01-31 | Daviess | Missouri | 29061 | 1530 | 24 |
2165962 | 2165962 | 2022-01-30 | Daviess | Missouri | 29061 | 1526 | 24 |
2162707 | 2162707 | 2022-01-29 | Daviess | Missouri | 29061 | 1522 | 24 |
2159452 | 2159452 | 2022-01-28 | Daviess | Missouri | 29061 | 1516 | 24 |
2156198 | 2156198 | 2022-01-27 | Daviess | Missouri | 29061 | 1513 | 24 |
2152945 | 2152945 | 2022-01-26 | Daviess | Missouri | 29061 | 1506 | 24 |
2149693 | 2149693 | 2022-01-25 | Daviess | Missouri | 29061 | 1501 | 24 |
2146441 | 2146441 | 2022-01-24 | Daviess | Missouri | 29061 | 1490 | 24 |
2143186 | 2143186 | 2022-01-23 | Daviess | Missouri | 29061 | 1487 | 24 |
2139931 | 2139931 | 2022-01-22 | Daviess | Missouri | 29061 | 1481 | 24 |
2136675 | 2136675 | 2022-01-21 | Daviess | Missouri | 29061 | 1467 | 24 |
2133423 | 2133423 | 2022-01-20 | Daviess | Missouri | 29061 | 1454 | 21 |
2130170 | 2130170 | 2022-01-19 | Daviess | Missouri | 29061 | 1442 | 21 |
2126916 | 2126916 | 2022-01-18 | Daviess | Missouri | 29061 | 1426 | 21 |
2123664 | 2123664 | 2022-01-17 | Daviess | Missouri | 29061 | 1407 | 21 |
2120412 | 2120412 | 2022-01-16 | Daviess | Missouri | 29061 | 1407 | 21 |
2117160 | 2117160 | 2022-01-15 | Daviess | Missouri | 29061 | 1407 | 21 |
2113909 | 2113909 | 2022-01-14 | Daviess | Missouri | 29061 | 1393 | 21 |
2110657 | 2110657 | 2022-01-13 | Daviess | Missouri | 29061 | 1373 | 21 |
2107406 | 2107406 | 2022-01-12 | Daviess | Missouri | 29061 | 1367 | 21 |
2104155 | 2104155 | 2022-01-11 | Daviess | Missouri | 29061 | 1362 | 21 |
2100904 | 2100904 | 2022-01-10 | Daviess | Missouri | 29061 | 1358 | 18 |
2097653 | 2097653 | 2022-01-09 | Daviess | Missouri | 29061 | 1356 | 18 |
2094401 | 2094401 | 2022-01-08 | Daviess | Missouri | 29061 | 1355 | 18 |
2091149 | 2091149 | 2022-01-07 | Daviess | Missouri | 29061 | 1339 | 18 |
2087898 | 2087898 | 2022-01-06 | Daviess | Missouri | 29061 | 1333 | 18 |
2084646 | 2084646 | 2022-01-05 | Daviess | Missouri | 29061 | 1323 | 18 |
2081394 | 2081394 | 2022-01-04 | Daviess | Missouri | 29061 | 1319 | 18 |
2078142 | 2078142 | 2022-01-03 | Daviess | Missouri | 29061 | 1310 | 17 |
2074891 | 2074891 | 2022-01-02 | Daviess | Missouri | 29061 | 1301 | 17 |
2071640 | 2071640 | 2022-01-01 | Daviess | Missouri | 29061 | 1301 | 17 |
2068389 | 2068389 | 2021-12-31 | Daviess | Missouri | 29061 | 1301 | 17 |
2065138 | 2065138 | 2021-12-30 | Daviess | Missouri | 29061 | 1301 | 17 |
2061888 | 2061888 | 2021-12-29 | Daviess | Missouri | 29061 | 1295 | 17 |
2058639 | 2058639 | 2021-12-28 | Daviess | Missouri | 29061 | 1282 | 17 |
2055390 | 2055390 | 2021-12-27 | Daviess | Missouri | 29061 | 1279 | 17 |
2052140 | 2052140 | 2021-12-26 | Daviess | Missouri | 29061 | 1269 | 17 |
2048890 | 2048890 | 2021-12-25 | Daviess | Missouri | 29061 | 1269 | 17 |
2045640 | 2045640 | 2021-12-24 | Daviess | Missouri | 29061 | 1269 | 17 |
2042390 | 2042390 | 2021-12-23 | Daviess | Missouri | 29061 | 1269 | 17 |
2039141 | 2039141 | 2021-12-22 | Daviess | Missouri | 29061 | 1261 | 17 |
2035891 | 2035891 | 2021-12-21 | Daviess | Missouri | 29061 | 1254 | 17 |
2032641 | 2032641 | 2021-12-20 | Daviess | Missouri | 29061 | 1252 | 17 |
2029390 | 2029390 | 2021-12-19 | Daviess | Missouri | 29061 | 1252 | 17 |
2026139 | 2026139 | 2021-12-18 | Daviess | Missouri | 29061 | 1252 | 17 |
2022888 | 2022888 | 2021-12-17 | Daviess | Missouri | 29061 | 1246 | 17 |
2019637 | 2019637 | 2021-12-16 | Daviess | Missouri | 29061 | 1240 | 17 |
2016387 | 2016387 | 2021-12-15 | Daviess | Missouri | 29061 | 1227 | 17 |
2013136 | 2013136 | 2021-12-14 | Daviess | Missouri | 29061 | 1217 | 17 |
2009885 | 2009885 | 2021-12-13 | Daviess | Missouri | 29061 | 1209 | 17 |
2006634 | 2006634 | 2021-12-12 | Daviess | Missouri | 29061 | 1209 | 17 |
2003383 | 2003383 | 2021-12-11 | Daviess | Missouri | 29061 | 1205 | 17 |
2000133 | 2000133 | 2021-12-10 | Daviess | Missouri | 29061 | 1202 | 17 |
1996882 | 1996882 | 2021-12-09 | Daviess | Missouri | 29061 | 1193 | 17 |
1993631 | 1993631 | 2021-12-08 | Daviess | Missouri | 29061 | 1188 | 17 |
1990380 | 1990380 | 2021-12-07 | Daviess | Missouri | 29061 | 1173 | 17 |
1987130 | 1987130 | 2021-12-06 | Daviess | Missouri | 29061 | 1171 | 17 |
1983880 | 1983880 | 2021-12-05 | Daviess | Missouri | 29061 | 1166 | 17 |
1980630 | 1980630 | 2021-12-04 | Daviess | Missouri | 29061 | 1161 | 17 |
1977380 | 1977380 | 2021-12-03 | Daviess | Missouri | 29061 | 1146 | 17 |
1974130 | 1974130 | 2021-12-02 | Daviess | Missouri | 29061 | 1146 | 17 |
1970881 | 1970881 | 2021-12-01 | Daviess | Missouri | 29061 | 1141 | 17 |
1967631 | 1967631 | 2021-11-30 | Daviess | Missouri | 29061 | 1128 | 17 |
1964379 | 1964379 | 2021-11-29 | Daviess | Missouri | 29061 | 1120 | 17 |
1961128 | 1961128 | 2021-11-28 | Daviess | Missouri | 29061 | 1106 | 17 |
1957877 | 1957877 | 2021-11-27 | Daviess | Missouri | 29061 | 1106 | 17 |
1954626 | 1954626 | 2021-11-26 | Daviess | Missouri | 29061 | 1106 | 17 |
1951375 | 1951375 | 2021-11-25 | Daviess | Missouri | 29061 | 1106 | 17 |
1948124 | 1948124 | 2021-11-24 | Daviess | Missouri | 29061 | 1106 | 17 |
1944873 | 1944873 | 2021-11-23 | Daviess | Missouri | 29061 | 1100 | 17 |
1941622 | 1941622 | 2021-11-22 | Daviess | Missouri | 29061 | 1096 | 16 |
1938372 | 1938372 | 2021-11-21 | Daviess | Missouri | 29061 | 1096 | 16 |
1935122 | 1935122 | 2021-11-20 | Daviess | Missouri | 29061 | 1096 | 16 |
1931872 | 1931872 | 2021-11-19 | Daviess | Missouri | 29061 | 1095 | 16 |
1928621 | 1928621 | 2021-11-18 | Daviess | Missouri | 29061 | 1092 | 16 |
1925371 | 1925371 | 2021-11-17 | Daviess | Missouri | 29061 | 1072 | 14 |
1922122 | 1922122 | 2021-11-16 | Daviess | Missouri | 29061 | 1070 | 14 |
1918872 | 1918872 | 2021-11-15 | Daviess | Missouri | 29061 | 1061 | 14 |
1915622 | 1915622 | 2021-11-14 | Daviess | Missouri | 29061 | 1061 | 14 |
1912372 | 1912372 | 2021-11-13 | Daviess | Missouri | 29061 | 1061 | 14 |
1909122 | 1909122 | 2021-11-12 | Daviess | Missouri | 29061 | 1059 | 14 |
1905873 | 1905873 | 2021-11-11 | Daviess | Missouri | 29061 | 1055 | 14 |
1902624 | 1902624 | 2021-11-10 | Daviess | Missouri | 29061 | 1055 | 14 |
1899374 | 1899374 | 2021-11-09 | Daviess | Missouri | 29061 | 1054 | 14 |
1896124 | 1896124 | 2021-11-08 | Daviess | Missouri | 29061 | 1046 | 14 |
1892874 | 1892874 | 2021-11-07 | Daviess | Missouri | 29061 | 1045 | 14 |
1889624 | 1889624 | 2021-11-06 | Daviess | Missouri | 29061 | 1045 | 14 |
1886374 | 1886374 | 2021-11-05 | Daviess | Missouri | 29061 | 1044 | 14 |
1883125 | 1883125 | 2021-11-04 | Daviess | Missouri | 29061 | 1044 | 14 |
1879876 | 1879876 | 2021-11-03 | Daviess | Missouri | 29061 | 1042 | 14 |
1876627 | 1876627 | 2021-11-02 | Daviess | Missouri | 29061 | 1039 | 14 |
1873378 | 1873378 | 2021-11-01 | Daviess | Missouri | 29061 | 1036 | 14 |
1870129 | 1870129 | 2021-10-31 | Daviess | Missouri | 29061 | 1035 | 14 |
1866880 | 1866880 | 2021-10-30 | Daviess | Missouri | 29061 | 1034 | 14 |
1863631 | 1863631 | 2021-10-29 | Daviess | Missouri | 29061 | 1033 | 14 |
1860382 | 1860382 | 2021-10-28 | Daviess | Missouri | 29061 | 1030 | 14 |
1857133 | 1857133 | 2021-10-27 | Daviess | Missouri | 29061 | 1030 | 14 |
1853884 | 1853884 | 2021-10-26 | Daviess | Missouri | 29061 | 1030 | 14 |
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);