ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Cole" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175718 | 2175718 | 2022-02-02 | Cole | Missouri | 29051 | 19305 | 255 |
2172465 | 2172465 | 2022-02-01 | Cole | Missouri | 29051 | 19206 | 253 |
2169212 | 2169212 | 2022-01-31 | Cole | Missouri | 29051 | 19135 | 250 |
2165957 | 2165957 | 2022-01-30 | Cole | Missouri | 29051 | 19111 | 250 |
2162702 | 2162702 | 2022-01-29 | Cole | Missouri | 29051 | 19081 | 250 |
2159447 | 2159447 | 2022-01-28 | Cole | Missouri | 29051 | 18975 | 250 |
2156193 | 2156193 | 2022-01-27 | Cole | Missouri | 29051 | 18870 | 250 |
2152940 | 2152940 | 2022-01-26 | Cole | Missouri | 29051 | 18745 | 250 |
2149688 | 2149688 | 2022-01-25 | Cole | Missouri | 29051 | 18592 | 250 |
2146436 | 2146436 | 2022-01-24 | Cole | Missouri | 29051 | 18304 | 250 |
2143181 | 2143181 | 2022-01-23 | Cole | Missouri | 29051 | 18272 | 250 |
2139926 | 2139926 | 2022-01-22 | Cole | Missouri | 29051 | 18211 | 250 |
2136670 | 2136670 | 2022-01-21 | Cole | Missouri | 29051 | 18031 | 250 |
2133418 | 2133418 | 2022-01-20 | Cole | Missouri | 29051 | 17845 | 245 |
2130165 | 2130165 | 2022-01-19 | Cole | Missouri | 29051 | 17540 | 245 |
2126911 | 2126911 | 2022-01-18 | Cole | Missouri | 29051 | 17410 | 244 |
2123659 | 2123659 | 2022-01-17 | Cole | Missouri | 29051 | 16665 | 244 |
2120407 | 2120407 | 2022-01-16 | Cole | Missouri | 29051 | 16665 | 244 |
2117155 | 2117155 | 2022-01-15 | Cole | Missouri | 29051 | 16665 | 244 |
2113904 | 2113904 | 2022-01-14 | Cole | Missouri | 29051 | 16345 | 244 |
2110652 | 2110652 | 2022-01-13 | Cole | Missouri | 29051 | 16241 | 244 |
2107401 | 2107401 | 2022-01-12 | Cole | Missouri | 29051 | 16073 | 244 |
2104150 | 2104150 | 2022-01-11 | Cole | Missouri | 29051 | 15852 | 244 |
2100899 | 2100899 | 2022-01-10 | Cole | Missouri | 29051 | 15599 | 242 |
2097648 | 2097648 | 2022-01-09 | Cole | Missouri | 29051 | 15545 | 242 |
2094396 | 2094396 | 2022-01-08 | Cole | Missouri | 29051 | 15517 | 242 |
2091144 | 2091144 | 2022-01-07 | Cole | Missouri | 29051 | 15387 | 242 |
2087893 | 2087893 | 2022-01-06 | Cole | Missouri | 29051 | 15232 | 242 |
2084641 | 2084641 | 2022-01-05 | Cole | Missouri | 29051 | 15106 | 242 |
2081389 | 2081389 | 2022-01-04 | Cole | Missouri | 29051 | 14987 | 242 |
2078137 | 2078137 | 2022-01-03 | Cole | Missouri | 29051 | 14912 | 235 |
2074886 | 2074886 | 2022-01-02 | Cole | Missouri | 29051 | 14748 | 235 |
2071635 | 2071635 | 2022-01-01 | Cole | Missouri | 29051 | 14748 | 235 |
2068384 | 2068384 | 2021-12-31 | Cole | Missouri | 29051 | 14748 | 235 |
2065133 | 2065133 | 2021-12-30 | Cole | Missouri | 29051 | 14748 | 235 |
2061883 | 2061883 | 2021-12-29 | Cole | Missouri | 29051 | 14664 | 236 |
2058634 | 2058634 | 2021-12-28 | Cole | Missouri | 29051 | 14601 | 236 |
2055385 | 2055385 | 2021-12-27 | Cole | Missouri | 29051 | 14545 | 234 |
2052135 | 2052135 | 2021-12-26 | Cole | Missouri | 29051 | 14478 | 234 |
2048885 | 2048885 | 2021-12-25 | Cole | Missouri | 29051 | 14478 | 234 |
2045635 | 2045635 | 2021-12-24 | Cole | Missouri | 29051 | 14478 | 234 |
2042385 | 2042385 | 2021-12-23 | Cole | Missouri | 29051 | 14478 | 234 |
2039136 | 2039136 | 2021-12-22 | Cole | Missouri | 29051 | 14435 | 234 |
2035886 | 2035886 | 2021-12-21 | Cole | Missouri | 29051 | 14403 | 234 |
2032636 | 2032636 | 2021-12-20 | Cole | Missouri | 29051 | 14374 | 233 |
2029385 | 2029385 | 2021-12-19 | Cole | Missouri | 29051 | 14365 | 233 |
2026134 | 2026134 | 2021-12-18 | Cole | Missouri | 29051 | 14354 | 233 |
2022883 | 2022883 | 2021-12-17 | Cole | Missouri | 29051 | 14330 | 233 |
2019632 | 2019632 | 2021-12-16 | Cole | Missouri | 29051 | 14304 | 234 |
2016382 | 2016382 | 2021-12-15 | Cole | Missouri | 29051 | 14233 | 234 |
2013131 | 2013131 | 2021-12-14 | Cole | Missouri | 29051 | 14182 | 235 |
2009880 | 2009880 | 2021-12-13 | Cole | Missouri | 29051 | 14139 | 233 |
2006629 | 2006629 | 2021-12-12 | Cole | Missouri | 29051 | 14134 | 233 |
2003378 | 2003378 | 2021-12-11 | Cole | Missouri | 29051 | 14125 | 233 |
2000128 | 2000128 | 2021-12-10 | Cole | Missouri | 29051 | 14108 | 233 |
1996877 | 1996877 | 2021-12-09 | Cole | Missouri | 29051 | 14080 | 233 |
1993626 | 1993626 | 2021-12-08 | Cole | Missouri | 29051 | 14043 | 233 |
1990375 | 1990375 | 2021-12-07 | Cole | Missouri | 29051 | 14010 | 233 |
1987125 | 1987125 | 2021-12-06 | Cole | Missouri | 29051 | 13978 | 232 |
1983875 | 1983875 | 2021-12-05 | Cole | Missouri | 29051 | 13927 | 232 |
1980625 | 1980625 | 2021-12-04 | Cole | Missouri | 29051 | 13906 | 232 |
1977375 | 1977375 | 2021-12-03 | Cole | Missouri | 29051 | 13863 | 232 |
1974125 | 1974125 | 2021-12-02 | Cole | Missouri | 29051 | 13863 | 232 |
1970876 | 1970876 | 2021-12-01 | Cole | Missouri | 29051 | 13811 | 232 |
1967626 | 1967626 | 2021-11-30 | Cole | Missouri | 29051 | 13765 | 232 |
1964374 | 1964374 | 2021-11-29 | Cole | Missouri | 29051 | 13737 | 231 |
1961123 | 1961123 | 2021-11-28 | Cole | Missouri | 29051 | 13656 | 231 |
1957872 | 1957872 | 2021-11-27 | Cole | Missouri | 29051 | 13656 | 231 |
1954621 | 1954621 | 2021-11-26 | Cole | Missouri | 29051 | 13656 | 231 |
1951370 | 1951370 | 2021-11-25 | Cole | Missouri | 29051 | 13656 | 231 |
1948119 | 1948119 | 2021-11-24 | Cole | Missouri | 29051 | 13656 | 231 |
1944868 | 1944868 | 2021-11-23 | Cole | Missouri | 29051 | 13636 | 231 |
1941617 | 1941617 | 2021-11-22 | Cole | Missouri | 29051 | 13610 | 231 |
1938367 | 1938367 | 2021-11-21 | Cole | Missouri | 29051 | 13592 | 232 |
1935117 | 1935117 | 2021-11-20 | Cole | Missouri | 29051 | 13585 | 232 |
1931867 | 1931867 | 2021-11-19 | Cole | Missouri | 29051 | 13572 | 232 |
1928616 | 1928616 | 2021-11-18 | Cole | Missouri | 29051 | 13546 | 231 |
1925366 | 1925366 | 2021-11-17 | Cole | Missouri | 29051 | 13352 | 175 |
1922117 | 1922117 | 2021-11-16 | Cole | Missouri | 29051 | 13315 | 175 |
1918867 | 1918867 | 2021-11-15 | Cole | Missouri | 29051 | 13284 | 173 |
1915617 | 1915617 | 2021-11-14 | Cole | Missouri | 29051 | 13283 | 173 |
1912367 | 1912367 | 2021-11-13 | Cole | Missouri | 29051 | 13279 | 173 |
1909117 | 1909117 | 2021-11-12 | Cole | Missouri | 29051 | 13262 | 173 |
1905868 | 1905868 | 2021-11-11 | Cole | Missouri | 29051 | 13212 | 173 |
1902619 | 1902619 | 2021-11-10 | Cole | Missouri | 29051 | 13212 | 173 |
1899369 | 1899369 | 2021-11-09 | Cole | Missouri | 29051 | 13196 | 173 |
1896119 | 1896119 | 2021-11-08 | Cole | Missouri | 29051 | 13165 | 173 |
1892869 | 1892869 | 2021-11-07 | Cole | Missouri | 29051 | 13158 | 173 |
1889619 | 1889619 | 2021-11-06 | Cole | Missouri | 29051 | 13149 | 173 |
1886369 | 1886369 | 2021-11-05 | Cole | Missouri | 29051 | 13135 | 173 |
1883120 | 1883120 | 2021-11-04 | Cole | Missouri | 29051 | 13122 | 173 |
1879871 | 1879871 | 2021-11-03 | Cole | Missouri | 29051 | 13099 | 173 |
1876622 | 1876622 | 2021-11-02 | Cole | Missouri | 29051 | 13080 | 173 |
1873373 | 1873373 | 2021-11-01 | Cole | Missouri | 29051 | 12956 | 172 |
1870124 | 1870124 | 2021-10-31 | Cole | Missouri | 29051 | 12950 | 172 |
1866875 | 1866875 | 2021-10-30 | Cole | Missouri | 29051 | 12946 | 172 |
1863626 | 1863626 | 2021-10-29 | Cole | Missouri | 29051 | 12927 | 172 |
1860377 | 1860377 | 2021-10-28 | Cole | Missouri | 29051 | 12909 | 172 |
1857128 | 1857128 | 2021-10-27 | Cole | Missouri | 29051 | 12898 | 172 |
1853879 | 1853879 | 2021-10-26 | Cole | Missouri | 29051 | 12880 | 172 |
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);