ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Polk" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175778 | 2175778 | 2022-02-02 | Polk | Missouri | 29167 | 7590 | 84 |
2172525 | 2172525 | 2022-02-01 | Polk | Missouri | 29167 | 7532 | 84 |
2169272 | 2169272 | 2022-01-31 | Polk | Missouri | 29167 | 7450 | 84 |
2166017 | 2166017 | 2022-01-30 | Polk | Missouri | 29167 | 7447 | 84 |
2162762 | 2162762 | 2022-01-29 | Polk | Missouri | 29167 | 7432 | 84 |
2159507 | 2159507 | 2022-01-28 | Polk | Missouri | 29167 | 7375 | 84 |
2156253 | 2156253 | 2022-01-27 | Polk | Missouri | 29167 | 7306 | 84 |
2153000 | 2153000 | 2022-01-26 | Polk | Missouri | 29167 | 7226 | 84 |
2149748 | 2149748 | 2022-01-25 | Polk | Missouri | 29167 | 7142 | 84 |
2146496 | 2146496 | 2022-01-24 | Polk | Missouri | 29167 | 7050 | 84 |
2143241 | 2143241 | 2022-01-23 | Polk | Missouri | 29167 | 7022 | 84 |
2139986 | 2139986 | 2022-01-22 | Polk | Missouri | 29167 | 7001 | 84 |
2136730 | 2136730 | 2022-01-21 | Polk | Missouri | 29167 | 6975 | 84 |
2133478 | 2133478 | 2022-01-20 | Polk | Missouri | 29167 | 6867 | 83 |
2130225 | 2130225 | 2022-01-19 | Polk | Missouri | 29167 | 6739 | 83 |
2126971 | 2126971 | 2022-01-18 | Polk | Missouri | 29167 | 6633 | 83 |
2123719 | 2123719 | 2022-01-17 | Polk | Missouri | 29167 | 6464 | 83 |
2120467 | 2120467 | 2022-01-16 | Polk | Missouri | 29167 | 6464 | 83 |
2117215 | 2117215 | 2022-01-15 | Polk | Missouri | 29167 | 6464 | 83 |
2113964 | 2113964 | 2022-01-14 | Polk | Missouri | 29167 | 6393 | 83 |
2110712 | 2110712 | 2022-01-13 | Polk | Missouri | 29167 | 6338 | 83 |
2107461 | 2107461 | 2022-01-12 | Polk | Missouri | 29167 | 6284 | 83 |
2104210 | 2104210 | 2022-01-11 | Polk | Missouri | 29167 | 6230 | 83 |
2100959 | 2100959 | 2022-01-10 | Polk | Missouri | 29167 | 6155 | 83 |
2097708 | 2097708 | 2022-01-09 | Polk | Missouri | 29167 | 6147 | 83 |
2094456 | 2094456 | 2022-01-08 | Polk | Missouri | 29167 | 6139 | 83 |
2091204 | 2091204 | 2022-01-07 | Polk | Missouri | 29167 | 6105 | 83 |
2087953 | 2087953 | 2022-01-06 | Polk | Missouri | 29167 | 6071 | 83 |
2084701 | 2084701 | 2022-01-05 | Polk | Missouri | 29167 | 6021 | 83 |
2081449 | 2081449 | 2022-01-04 | Polk | Missouri | 29167 | 5950 | 83 |
2078197 | 2078197 | 2022-01-03 | Polk | Missouri | 29167 | 5926 | 82 |
2074946 | 2074946 | 2022-01-02 | Polk | Missouri | 29167 | 5869 | 82 |
2071695 | 2071695 | 2022-01-01 | Polk | Missouri | 29167 | 5869 | 82 |
2068444 | 2068444 | 2021-12-31 | Polk | Missouri | 29167 | 5869 | 82 |
2065193 | 2065193 | 2021-12-30 | Polk | Missouri | 29167 | 5869 | 82 |
2061943 | 2061943 | 2021-12-29 | Polk | Missouri | 29167 | 5844 | 82 |
2058694 | 2058694 | 2021-12-28 | Polk | Missouri | 29167 | 5819 | 82 |
2055445 | 2055445 | 2021-12-27 | Polk | Missouri | 29167 | 5809 | 81 |
2052195 | 2052195 | 2021-12-26 | Polk | Missouri | 29167 | 5754 | 81 |
2048945 | 2048945 | 2021-12-25 | Polk | Missouri | 29167 | 5754 | 81 |
2045695 | 2045695 | 2021-12-24 | Polk | Missouri | 29167 | 5754 | 81 |
2042445 | 2042445 | 2021-12-23 | Polk | Missouri | 29167 | 5754 | 81 |
2039196 | 2039196 | 2021-12-22 | Polk | Missouri | 29167 | 5731 | 81 |
2035946 | 2035946 | 2021-12-21 | Polk | Missouri | 29167 | 5707 | 81 |
2032696 | 2032696 | 2021-12-20 | Polk | Missouri | 29167 | 5682 | 81 |
2029445 | 2029445 | 2021-12-19 | Polk | Missouri | 29167 | 5679 | 81 |
2026194 | 2026194 | 2021-12-18 | Polk | Missouri | 29167 | 5677 | 81 |
2022943 | 2022943 | 2021-12-17 | Polk | Missouri | 29167 | 5658 | 80 |
2019692 | 2019692 | 2021-12-16 | Polk | Missouri | 29167 | 5635 | 80 |
2016442 | 2016442 | 2021-12-15 | Polk | Missouri | 29167 | 5601 | 80 |
2013191 | 2013191 | 2021-12-14 | Polk | Missouri | 29167 | 5573 | 80 |
2009940 | 2009940 | 2021-12-13 | Polk | Missouri | 29167 | 5552 | 80 |
2006689 | 2006689 | 2021-12-12 | Polk | Missouri | 29167 | 5547 | 80 |
2003438 | 2003438 | 2021-12-11 | Polk | Missouri | 29167 | 5542 | 80 |
2000188 | 2000188 | 2021-12-10 | Polk | Missouri | 29167 | 5525 | 80 |
1996937 | 1996937 | 2021-12-09 | Polk | Missouri | 29167 | 5487 | 80 |
1993686 | 1993686 | 2021-12-08 | Polk | Missouri | 29167 | 5473 | 80 |
1990435 | 1990435 | 2021-12-07 | Polk | Missouri | 29167 | 5453 | 80 |
1987185 | 1987185 | 2021-12-06 | Polk | Missouri | 29167 | 5440 | 80 |
1983935 | 1983935 | 2021-12-05 | Polk | Missouri | 29167 | 5431 | 80 |
1980685 | 1980685 | 2021-12-04 | Polk | Missouri | 29167 | 5416 | 80 |
1977435 | 1977435 | 2021-12-03 | Polk | Missouri | 29167 | 5383 | 80 |
1974185 | 1974185 | 2021-12-02 | Polk | Missouri | 29167 | 5383 | 80 |
1970936 | 1970936 | 2021-12-01 | Polk | Missouri | 29167 | 5360 | 80 |
1967686 | 1967686 | 2021-11-30 | Polk | Missouri | 29167 | 5325 | 80 |
1964434 | 1964434 | 2021-11-29 | Polk | Missouri | 29167 | 5319 | 80 |
1961183 | 1961183 | 2021-11-28 | Polk | Missouri | 29167 | 5300 | 80 |
1957932 | 1957932 | 2021-11-27 | Polk | Missouri | 29167 | 5300 | 80 |
1954681 | 1954681 | 2021-11-26 | Polk | Missouri | 29167 | 5300 | 80 |
1951430 | 1951430 | 2021-11-25 | Polk | Missouri | 29167 | 5300 | 80 |
1948179 | 1948179 | 2021-11-24 | Polk | Missouri | 29167 | 5300 | 80 |
1944928 | 1944928 | 2021-11-23 | Polk | Missouri | 29167 | 5275 | 80 |
1941677 | 1941677 | 2021-11-22 | Polk | Missouri | 29167 | 5273 | 80 |
1938427 | 1938427 | 2021-11-21 | Polk | Missouri | 29167 | 5272 | 80 |
1935177 | 1935177 | 2021-11-20 | Polk | Missouri | 29167 | 5269 | 80 |
1931927 | 1931927 | 2021-11-19 | Polk | Missouri | 29167 | 5264 | 80 |
1928676 | 1928676 | 2021-11-18 | Polk | Missouri | 29167 | 5254 | 80 |
1925426 | 1925426 | 2021-11-17 | Polk | Missouri | 29167 | 5209 | 53 |
1922177 | 1922177 | 2021-11-16 | Polk | Missouri | 29167 | 5205 | 53 |
1918927 | 1918927 | 2021-11-15 | Polk | Missouri | 29167 | 5190 | 53 |
1915677 | 1915677 | 2021-11-14 | Polk | Missouri | 29167 | 5189 | 53 |
1912427 | 1912427 | 2021-11-13 | Polk | Missouri | 29167 | 5187 | 53 |
1909177 | 1909177 | 2021-11-12 | Polk | Missouri | 29167 | 5182 | 53 |
1905928 | 1905928 | 2021-11-11 | Polk | Missouri | 29167 | 5168 | 53 |
1902679 | 1902679 | 2021-11-10 | Polk | Missouri | 29167 | 5168 | 53 |
1899429 | 1899429 | 2021-11-09 | Polk | Missouri | 29167 | 5163 | 53 |
1896179 | 1896179 | 2021-11-08 | Polk | Missouri | 29167 | 5157 | 53 |
1892929 | 1892929 | 2021-11-07 | Polk | Missouri | 29167 | 5156 | 53 |
1889679 | 1889679 | 2021-11-06 | Polk | Missouri | 29167 | 5151 | 53 |
1886429 | 1886429 | 2021-11-05 | Polk | Missouri | 29167 | 5145 | 53 |
1883180 | 1883180 | 2021-11-04 | Polk | Missouri | 29167 | 5141 | 53 |
1879931 | 1879931 | 2021-11-03 | Polk | Missouri | 29167 | 5140 | 53 |
1876682 | 1876682 | 2021-11-02 | Polk | Missouri | 29167 | 5135 | 53 |
1873433 | 1873433 | 2021-11-01 | Polk | Missouri | 29167 | 5127 | 53 |
1870184 | 1870184 | 2021-10-31 | Polk | Missouri | 29167 | 5126 | 53 |
1866935 | 1866935 | 2021-10-30 | Polk | Missouri | 29167 | 5125 | 53 |
1863686 | 1863686 | 2021-10-29 | Polk | Missouri | 29167 | 5123 | 53 |
1860437 | 1860437 | 2021-10-28 | Polk | Missouri | 29167 | 5118 | 52 |
1857188 | 1857188 | 2021-10-27 | Polk | Missouri | 29167 | 5112 | 52 |
1853939 | 1853939 | 2021-10-26 | Polk | Missouri | 29167 | 5106 | 52 |
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);