ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Callaway" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175706 | 2175706 | 2022-02-02 | Callaway | Missouri | 29027 | 11369 | 105 |
2172453 | 2172453 | 2022-02-01 | Callaway | Missouri | 29027 | 11304 | 105 |
2169200 | 2169200 | 2022-01-31 | Callaway | Missouri | 29027 | 11256 | 102 |
2165945 | 2165945 | 2022-01-30 | Callaway | Missouri | 29027 | 11238 | 102 |
2162690 | 2162690 | 2022-01-29 | Callaway | Missouri | 29027 | 11222 | 102 |
2159435 | 2159435 | 2022-01-28 | Callaway | Missouri | 29027 | 11132 | 102 |
2156181 | 2156181 | 2022-01-27 | Callaway | Missouri | 29027 | 11023 | 102 |
2152928 | 2152928 | 2022-01-26 | Callaway | Missouri | 29027 | 10943 | 102 |
2149676 | 2149676 | 2022-01-25 | Callaway | Missouri | 29027 | 10855 | 102 |
2146424 | 2146424 | 2022-01-24 | Callaway | Missouri | 29027 | 10665 | 102 |
2143169 | 2143169 | 2022-01-23 | Callaway | Missouri | 29027 | 10627 | 101 |
2139914 | 2139914 | 2022-01-22 | Callaway | Missouri | 29027 | 10543 | 101 |
2136658 | 2136658 | 2022-01-21 | Callaway | Missouri | 29027 | 10435 | 101 |
2133406 | 2133406 | 2022-01-20 | Callaway | Missouri | 29027 | 10273 | 100 |
2130153 | 2130153 | 2022-01-19 | Callaway | Missouri | 29027 | 10111 | 100 |
2126899 | 2126899 | 2022-01-18 | Callaway | Missouri | 29027 | 9995 | 100 |
2123647 | 2123647 | 2022-01-17 | Callaway | Missouri | 29027 | 9688 | 100 |
2120395 | 2120395 | 2022-01-16 | Callaway | Missouri | 29027 | 9688 | 100 |
2117143 | 2117143 | 2022-01-15 | Callaway | Missouri | 29027 | 9688 | 100 |
2113892 | 2113892 | 2022-01-14 | Callaway | Missouri | 29027 | 9547 | 100 |
2110640 | 2110640 | 2022-01-13 | Callaway | Missouri | 29027 | 9456 | 100 |
2107389 | 2107389 | 2022-01-12 | Callaway | Missouri | 29027 | 9322 | 100 |
2104138 | 2104138 | 2022-01-11 | Callaway | Missouri | 29027 | 9224 | 100 |
2100887 | 2100887 | 2022-01-10 | Callaway | Missouri | 29027 | 9115 | 98 |
2097636 | 2097636 | 2022-01-09 | Callaway | Missouri | 29027 | 9089 | 98 |
2094384 | 2094384 | 2022-01-08 | Callaway | Missouri | 29027 | 9053 | 98 |
2091132 | 2091132 | 2022-01-07 | Callaway | Missouri | 29027 | 8967 | 98 |
2087881 | 2087881 | 2022-01-06 | Callaway | Missouri | 29027 | 8893 | 98 |
2084629 | 2084629 | 2022-01-05 | Callaway | Missouri | 29027 | 8851 | 98 |
2081377 | 2081377 | 2022-01-04 | Callaway | Missouri | 29027 | 8803 | 98 |
2078125 | 2078125 | 2022-01-03 | Callaway | Missouri | 29027 | 8749 | 98 |
2074874 | 2074874 | 2022-01-02 | Callaway | Missouri | 29027 | 8665 | 98 |
2071623 | 2071623 | 2022-01-01 | Callaway | Missouri | 29027 | 8665 | 98 |
2068372 | 2068372 | 2021-12-31 | Callaway | Missouri | 29027 | 8665 | 98 |
2065121 | 2065121 | 2021-12-30 | Callaway | Missouri | 29027 | 8665 | 98 |
2061871 | 2061871 | 2021-12-29 | Callaway | Missouri | 29027 | 8632 | 98 |
2058622 | 2058622 | 2021-12-28 | Callaway | Missouri | 29027 | 8603 | 98 |
2055373 | 2055373 | 2021-12-27 | Callaway | Missouri | 29027 | 8582 | 98 |
2052123 | 2052123 | 2021-12-26 | Callaway | Missouri | 29027 | 8531 | 98 |
2048873 | 2048873 | 2021-12-25 | Callaway | Missouri | 29027 | 8531 | 98 |
2045623 | 2045623 | 2021-12-24 | Callaway | Missouri | 29027 | 8531 | 98 |
2042373 | 2042373 | 2021-12-23 | Callaway | Missouri | 29027 | 8531 | 98 |
2039124 | 2039124 | 2021-12-22 | Callaway | Missouri | 29027 | 8506 | 98 |
2035874 | 2035874 | 2021-12-21 | Callaway | Missouri | 29027 | 8485 | 98 |
2032624 | 2032624 | 2021-12-20 | Callaway | Missouri | 29027 | 8466 | 97 |
2029373 | 2029373 | 2021-12-19 | Callaway | Missouri | 29027 | 8462 | 97 |
2026122 | 2026122 | 2021-12-18 | Callaway | Missouri | 29027 | 8455 | 97 |
2022871 | 2022871 | 2021-12-17 | Callaway | Missouri | 29027 | 8433 | 97 |
2019620 | 2019620 | 2021-12-16 | Callaway | Missouri | 29027 | 8396 | 97 |
2016370 | 2016370 | 2021-12-15 | Callaway | Missouri | 29027 | 8362 | 97 |
2013119 | 2013119 | 2021-12-14 | Callaway | Missouri | 29027 | 8337 | 97 |
2009868 | 2009868 | 2021-12-13 | Callaway | Missouri | 29027 | 8309 | 96 |
2006617 | 2006617 | 2021-12-12 | Callaway | Missouri | 29027 | 8303 | 96 |
2003366 | 2003366 | 2021-12-11 | Callaway | Missouri | 29027 | 8289 | 96 |
2000116 | 2000116 | 2021-12-10 | Callaway | Missouri | 29027 | 8271 | 96 |
1996865 | 1996865 | 2021-12-09 | Callaway | Missouri | 29027 | 8248 | 96 |
1993614 | 1993614 | 2021-12-08 | Callaway | Missouri | 29027 | 8215 | 96 |
1990363 | 1990363 | 2021-12-07 | Callaway | Missouri | 29027 | 8184 | 96 |
1987113 | 1987113 | 2021-12-06 | Callaway | Missouri | 29027 | 8171 | 94 |
1983863 | 1983863 | 2021-12-05 | Callaway | Missouri | 29027 | 8154 | 94 |
1980613 | 1980613 | 2021-12-04 | Callaway | Missouri | 29027 | 8138 | 94 |
1977363 | 1977363 | 2021-12-03 | Callaway | Missouri | 29027 | 8096 | 93 |
1974113 | 1974113 | 2021-12-02 | Callaway | Missouri | 29027 | 8096 | 93 |
1970864 | 1970864 | 2021-12-01 | Callaway | Missouri | 29027 | 8060 | 93 |
1967614 | 1967614 | 2021-11-30 | Callaway | Missouri | 29027 | 8037 | 93 |
1964362 | 1964362 | 2021-11-29 | Callaway | Missouri | 29027 | 8013 | 92 |
1961111 | 1961111 | 2021-11-28 | Callaway | Missouri | 29027 | 7958 | 92 |
1957860 | 1957860 | 2021-11-27 | Callaway | Missouri | 29027 | 7958 | 92 |
1954609 | 1954609 | 2021-11-26 | Callaway | Missouri | 29027 | 7958 | 92 |
1951358 | 1951358 | 2021-11-25 | Callaway | Missouri | 29027 | 7958 | 92 |
1948107 | 1948107 | 2021-11-24 | Callaway | Missouri | 29027 | 7958 | 92 |
1944856 | 1944856 | 2021-11-23 | Callaway | Missouri | 29027 | 7936 | 92 |
1941605 | 1941605 | 2021-11-22 | Callaway | Missouri | 29027 | 7924 | 91 |
1938355 | 1938355 | 2021-11-21 | Callaway | Missouri | 29027 | 7911 | 91 |
1935105 | 1935105 | 2021-11-20 | Callaway | Missouri | 29027 | 7898 | 91 |
1931855 | 1931855 | 2021-11-19 | Callaway | Missouri | 29027 | 7883 | 91 |
1928604 | 1928604 | 2021-11-18 | Callaway | Missouri | 29027 | 7856 | 91 |
1925354 | 1925354 | 2021-11-17 | Callaway | Missouri | 29027 | 7743 | 73 |
1922105 | 1922105 | 2021-11-16 | Callaway | Missouri | 29027 | 7706 | 73 |
1918855 | 1918855 | 2021-11-15 | Callaway | Missouri | 29027 | 7691 | 72 |
1915605 | 1915605 | 2021-11-14 | Callaway | Missouri | 29027 | 7681 | 72 |
1912355 | 1912355 | 2021-11-13 | Callaway | Missouri | 29027 | 7673 | 72 |
1909105 | 1909105 | 2021-11-12 | Callaway | Missouri | 29027 | 7648 | 72 |
1905856 | 1905856 | 2021-11-11 | Callaway | Missouri | 29027 | 7618 | 72 |
1902607 | 1902607 | 2021-11-10 | Callaway | Missouri | 29027 | 7618 | 72 |
1899357 | 1899357 | 2021-11-09 | Callaway | Missouri | 29027 | 7591 | 72 |
1896107 | 1896107 | 2021-11-08 | Callaway | Missouri | 29027 | 7578 | 71 |
1892857 | 1892857 | 2021-11-07 | Callaway | Missouri | 29027 | 7574 | 71 |
1889607 | 1889607 | 2021-11-06 | Callaway | Missouri | 29027 | 7569 | 71 |
1886357 | 1886357 | 2021-11-05 | Callaway | Missouri | 29027 | 7547 | 71 |
1883108 | 1883108 | 2021-11-04 | Callaway | Missouri | 29027 | 7537 | 71 |
1879859 | 1879859 | 2021-11-03 | Callaway | Missouri | 29027 | 7514 | 71 |
1876610 | 1876610 | 2021-11-02 | Callaway | Missouri | 29027 | 7503 | 71 |
1873361 | 1873361 | 2021-11-01 | Callaway | Missouri | 29027 | 7470 | 70 |
1870112 | 1870112 | 2021-10-31 | Callaway | Missouri | 29027 | 7468 | 70 |
1866863 | 1866863 | 2021-10-30 | Callaway | Missouri | 29027 | 7463 | 70 |
1863614 | 1863614 | 2021-10-29 | Callaway | Missouri | 29027 | 7451 | 70 |
1860365 | 1860365 | 2021-10-28 | Callaway | Missouri | 29027 | 7440 | 70 |
1857116 | 1857116 | 2021-10-27 | Callaway | Missouri | 29027 | 7431 | 70 |
1853867 | 1853867 | 2021-10-26 | Callaway | Missouri | 29027 | 7420 | 70 |
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);