ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Clay" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175716 | 2175716 | 2022-02-02 | Clay | Missouri | 29047 | 25075 | 325 |
2172463 | 2172463 | 2022-02-01 | Clay | Missouri | 29047 | 24882 | 321 |
2169210 | 2169210 | 2022-01-31 | Clay | Missouri | 29047 | 24758 | 306 |
2165955 | 2165955 | 2022-01-30 | Clay | Missouri | 29047 | 24715 | 306 |
2162700 | 2162700 | 2022-01-29 | Clay | Missouri | 29047 | 24652 | 306 |
2159445 | 2159445 | 2022-01-28 | Clay | Missouri | 29047 | 24487 | 306 |
2156191 | 2156191 | 2022-01-27 | Clay | Missouri | 29047 | 24228 | 306 |
2152938 | 2152938 | 2022-01-26 | Clay | Missouri | 29047 | 24067 | 306 |
2149686 | 2149686 | 2022-01-25 | Clay | Missouri | 29047 | 23910 | 306 |
2146434 | 2146434 | 2022-01-24 | Clay | Missouri | 29047 | 23794 | 306 |
2143179 | 2143179 | 2022-01-23 | Clay | Missouri | 29047 | 23691 | 306 |
2139924 | 2139924 | 2022-01-22 | Clay | Missouri | 29047 | 23545 | 306 |
2136668 | 2136668 | 2022-01-21 | Clay | Missouri | 29047 | 23377 | 306 |
2133416 | 2133416 | 2022-01-20 | Clay | Missouri | 29047 | 23052 | 298 |
2130163 | 2130163 | 2022-01-19 | Clay | Missouri | 29047 | 22791 | 296 |
2126909 | 2126909 | 2022-01-18 | Clay | Missouri | 29047 | 22478 | 290 |
2123657 | 2123657 | 2022-01-17 | Clay | Missouri | 29047 | 22138 | 290 |
2120405 | 2120405 | 2022-01-16 | Clay | Missouri | 29047 | 22138 | 290 |
2117153 | 2117153 | 2022-01-15 | Clay | Missouri | 29047 | 22138 | 290 |
2113902 | 2113902 | 2022-01-14 | Clay | Missouri | 29047 | 21688 | 291 |
2110650 | 2110650 | 2022-01-13 | Clay | Missouri | 29047 | 21459 | 290 |
2107399 | 2107399 | 2022-01-12 | Clay | Missouri | 29047 | 21162 | 290 |
2104148 | 2104148 | 2022-01-11 | Clay | Missouri | 29047 | 20936 | 289 |
2100897 | 2100897 | 2022-01-10 | Clay | Missouri | 29047 | 20705 | 281 |
2097646 | 2097646 | 2022-01-09 | Clay | Missouri | 29047 | 20559 | 281 |
2094394 | 2094394 | 2022-01-08 | Clay | Missouri | 29047 | 20491 | 281 |
2091142 | 2091142 | 2022-01-07 | Clay | Missouri | 29047 | 20212 | 281 |
2087891 | 2087891 | 2022-01-06 | Clay | Missouri | 29047 | 19984 | 281 |
2084639 | 2084639 | 2022-01-05 | Clay | Missouri | 29047 | 19726 | 280 |
2081387 | 2081387 | 2022-01-04 | Clay | Missouri | 29047 | 19549 | 280 |
2078135 | 2078135 | 2022-01-03 | Clay | Missouri | 29047 | 19373 | 274 |
2074884 | 2074884 | 2022-01-02 | Clay | Missouri | 29047 | 18853 | 274 |
2071633 | 2071633 | 2022-01-01 | Clay | Missouri | 29047 | 18853 | 274 |
2068382 | 2068382 | 2021-12-31 | Clay | Missouri | 29047 | 18853 | 274 |
2065131 | 2065131 | 2021-12-30 | Clay | Missouri | 29047 | 18853 | 274 |
2061881 | 2061881 | 2021-12-29 | Clay | Missouri | 29047 | 18659 | 273 |
2058632 | 2058632 | 2021-12-28 | Clay | Missouri | 29047 | 18517 | 273 |
2055383 | 2055383 | 2021-12-27 | Clay | Missouri | 29047 | 18426 | 266 |
2052133 | 2052133 | 2021-12-26 | Clay | Missouri | 29047 | 18233 | 266 |
2048883 | 2048883 | 2021-12-25 | Clay | Missouri | 29047 | 18233 | 266 |
2045633 | 2045633 | 2021-12-24 | Clay | Missouri | 29047 | 18233 | 266 |
2042383 | 2042383 | 2021-12-23 | Clay | Missouri | 29047 | 18233 | 266 |
2039134 | 2039134 | 2021-12-22 | Clay | Missouri | 29047 | 18078 | 268 |
2035884 | 2035884 | 2021-12-21 | Clay | Missouri | 29047 | 17975 | 268 |
2032634 | 2032634 | 2021-12-20 | Clay | Missouri | 29047 | 17882 | 265 |
2029383 | 2029383 | 2021-12-19 | Clay | Missouri | 29047 | 17849 | 265 |
2026132 | 2026132 | 2021-12-18 | Clay | Missouri | 29047 | 17819 | 265 |
2022881 | 2022881 | 2021-12-17 | Clay | Missouri | 29047 | 17730 | 265 |
2019630 | 2019630 | 2021-12-16 | Clay | Missouri | 29047 | 17636 | 265 |
2016380 | 2016380 | 2021-12-15 | Clay | Missouri | 29047 | 17506 | 265 |
2013129 | 2013129 | 2021-12-14 | Clay | Missouri | 29047 | 17410 | 264 |
2009878 | 2009878 | 2021-12-13 | Clay | Missouri | 29047 | 17338 | 262 |
2006627 | 2006627 | 2021-12-12 | Clay | Missouri | 29047 | 17309 | 262 |
2003376 | 2003376 | 2021-12-11 | Clay | Missouri | 29047 | 17250 | 262 |
2000126 | 2000126 | 2021-12-10 | Clay | Missouri | 29047 | 17175 | 262 |
1996875 | 1996875 | 2021-12-09 | Clay | Missouri | 29047 | 17104 | 262 |
1993624 | 1993624 | 2021-12-08 | Clay | Missouri | 29047 | 17016 | 262 |
1990373 | 1990373 | 2021-12-07 | Clay | Missouri | 29047 | 16903 | 261 |
1987123 | 1987123 | 2021-12-06 | Clay | Missouri | 29047 | 16839 | 258 |
1983873 | 1983873 | 2021-12-05 | Clay | Missouri | 29047 | 16750 | 258 |
1980623 | 1980623 | 2021-12-04 | Clay | Missouri | 29047 | 16676 | 258 |
1977373 | 1977373 | 2021-12-03 | Clay | Missouri | 29047 | 16536 | 259 |
1974123 | 1974123 | 2021-12-02 | Clay | Missouri | 29047 | 16536 | 259 |
1970874 | 1970874 | 2021-12-01 | Clay | Missouri | 29047 | 16452 | 259 |
1967624 | 1967624 | 2021-11-30 | Clay | Missouri | 29047 | 16361 | 259 |
1964372 | 1964372 | 2021-11-29 | Clay | Missouri | 29047 | 16275 | 258 |
1961121 | 1961121 | 2021-11-28 | Clay | Missouri | 29047 | 16078 | 258 |
1957870 | 1957870 | 2021-11-27 | Clay | Missouri | 29047 | 16078 | 258 |
1954619 | 1954619 | 2021-11-26 | Clay | Missouri | 29047 | 16078 | 258 |
1951368 | 1951368 | 2021-11-25 | Clay | Missouri | 29047 | 16078 | 258 |
1948117 | 1948117 | 2021-11-24 | Clay | Missouri | 29047 | 16078 | 258 |
1944866 | 1944866 | 2021-11-23 | Clay | Missouri | 29047 | 16007 | 258 |
1941615 | 1941615 | 2021-11-22 | Clay | Missouri | 29047 | 15947 | 256 |
1938365 | 1938365 | 2021-11-21 | Clay | Missouri | 29047 | 15927 | 258 |
1935115 | 1935115 | 2021-11-20 | Clay | Missouri | 29047 | 15894 | 258 |
1931865 | 1931865 | 2021-11-19 | Clay | Missouri | 29047 | 15845 | 258 |
1928614 | 1928614 | 2021-11-18 | Clay | Missouri | 29047 | 15806 | 256 |
1925364 | 1925364 | 2021-11-17 | Clay | Missouri | 29047 | 15535 | 225 |
1922115 | 1922115 | 2021-11-16 | Clay | Missouri | 29047 | 15494 | 225 |
1918865 | 1918865 | 2021-11-15 | Clay | Missouri | 29047 | 15464 | 224 |
1915615 | 1915615 | 2021-11-14 | Clay | Missouri | 29047 | 15442 | 224 |
1912365 | 1912365 | 2021-11-13 | Clay | Missouri | 29047 | 15409 | 224 |
1909115 | 1909115 | 2021-11-12 | Clay | Missouri | 29047 | 15356 | 224 |
1905866 | 1905866 | 2021-11-11 | Clay | Missouri | 29047 | 15274 | 224 |
1902617 | 1902617 | 2021-11-10 | Clay | Missouri | 29047 | 15274 | 224 |
1899367 | 1899367 | 2021-11-09 | Clay | Missouri | 29047 | 15247 | 224 |
1896117 | 1896117 | 2021-11-08 | Clay | Missouri | 29047 | 15212 | 223 |
1892867 | 1892867 | 2021-11-07 | Clay | Missouri | 29047 | 15191 | 223 |
1889617 | 1889617 | 2021-11-06 | Clay | Missouri | 29047 | 15181 | 223 |
1886367 | 1886367 | 2021-11-05 | Clay | Missouri | 29047 | 15151 | 223 |
1883118 | 1883118 | 2021-11-04 | Clay | Missouri | 29047 | 15130 | 223 |
1879869 | 1879869 | 2021-11-03 | Clay | Missouri | 29047 | 15115 | 223 |
1876620 | 1876620 | 2021-11-02 | Clay | Missouri | 29047 | 15081 | 223 |
1873371 | 1873371 | 2021-11-01 | Clay | Missouri | 29047 | 15056 | 217 |
1870122 | 1870122 | 2021-10-31 | Clay | Missouri | 29047 | 15048 | 217 |
1866873 | 1866873 | 2021-10-30 | Clay | Missouri | 29047 | 15034 | 217 |
1863624 | 1863624 | 2021-10-29 | Clay | Missouri | 29047 | 15018 | 217 |
1860375 | 1860375 | 2021-10-28 | Clay | Missouri | 29047 | 14988 | 216 |
1857126 | 1857126 | 2021-10-27 | Clay | Missouri | 29047 | 14953 | 216 |
1853877 | 1853877 | 2021-10-26 | Clay | Missouri | 29047 | 14917 | 215 |
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);