ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Wright" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175609 | 2175609 | 2022-02-02 | Wright | Minnesota | 27171 | 34719 | 288 |
2172356 | 2172356 | 2022-02-01 | Wright | Minnesota | 27171 | 34514 | 287 |
2169103 | 2169103 | 2022-01-31 | Wright | Minnesota | 27171 | 34108 | 287 |
2165848 | 2165848 | 2022-01-30 | Wright | Minnesota | 27171 | 33788 | 285 |
2162593 | 2162593 | 2022-01-29 | Wright | Minnesota | 27171 | 33788 | 285 |
2159338 | 2159338 | 2022-01-28 | Wright | Minnesota | 27171 | 33788 | 285 |
2156084 | 2156084 | 2022-01-27 | Wright | Minnesota | 27171 | 33515 | 284 |
2152831 | 2152831 | 2022-01-26 | Wright | Minnesota | 27171 | 33080 | 282 |
2149579 | 2149579 | 2022-01-25 | Wright | Minnesota | 27171 | 32830 | 280 |
2146327 | 2146327 | 2022-01-24 | Wright | Minnesota | 27171 | 32321 | 278 |
2143072 | 2143072 | 2022-01-23 | Wright | Minnesota | 27171 | 32068 | 278 |
2139817 | 2139817 | 2022-01-22 | Wright | Minnesota | 27171 | 32068 | 278 |
2136561 | 2136561 | 2022-01-21 | Wright | Minnesota | 27171 | 32068 | 278 |
2133309 | 2133309 | 2022-01-20 | Wright | Minnesota | 27171 | 31668 | 278 |
2130056 | 2130056 | 2022-01-19 | Wright | Minnesota | 27171 | 31497 | 274 |
2126802 | 2126802 | 2022-01-18 | Wright | Minnesota | 27171 | 30895 | 273 |
2123550 | 2123550 | 2022-01-17 | Wright | Minnesota | 27171 | 30709 | 271 |
2120298 | 2120298 | 2022-01-16 | Wright | Minnesota | 27171 | 30709 | 271 |
2117046 | 2117046 | 2022-01-15 | Wright | Minnesota | 27171 | 30709 | 271 |
2113795 | 2113795 | 2022-01-14 | Wright | Minnesota | 27171 | 30709 | 271 |
2110543 | 2110543 | 2022-01-13 | Wright | Minnesota | 27171 | 30531 | 270 |
2107292 | 2107292 | 2022-01-12 | Wright | Minnesota | 27171 | 30288 | 269 |
2104041 | 2104041 | 2022-01-11 | Wright | Minnesota | 27171 | 30147 | 267 |
2100790 | 2100790 | 2022-01-10 | Wright | Minnesota | 27171 | 29649 | 266 |
2097539 | 2097539 | 2022-01-09 | Wright | Minnesota | 27171 | 29446 | 263 |
2094287 | 2094287 | 2022-01-08 | Wright | Minnesota | 27171 | 29446 | 263 |
2091035 | 2091035 | 2022-01-07 | Wright | Minnesota | 27171 | 29446 | 263 |
2087784 | 2087784 | 2022-01-06 | Wright | Minnesota | 27171 | 29295 | 262 |
2084532 | 2084532 | 2022-01-05 | Wright | Minnesota | 27171 | 29177 | 262 |
2081280 | 2081280 | 2022-01-04 | Wright | Minnesota | 27171 | 29037 | 260 |
2078028 | 2078028 | 2022-01-03 | Wright | Minnesota | 27171 | 28816 | 260 |
2074777 | 2074777 | 2022-01-02 | Wright | Minnesota | 27171 | 28702 | 259 |
2071526 | 2071526 | 2022-01-01 | Wright | Minnesota | 27171 | 28702 | 259 |
2068275 | 2068275 | 2021-12-31 | Wright | Minnesota | 27171 | 28702 | 259 |
2065024 | 2065024 | 2021-12-30 | Wright | Minnesota | 27171 | 28702 | 259 |
2061774 | 2061774 | 2021-12-29 | Wright | Minnesota | 27171 | 28553 | 257 |
2058525 | 2058525 | 2021-12-28 | Wright | Minnesota | 27171 | 28470 | 254 |
2055276 | 2055276 | 2021-12-27 | Wright | Minnesota | 27171 | 28265 | 254 |
2052026 | 2052026 | 2021-12-26 | Wright | Minnesota | 27171 | 28126 | 251 |
2048776 | 2048776 | 2021-12-25 | Wright | Minnesota | 27171 | 28126 | 251 |
2045526 | 2045526 | 2021-12-24 | Wright | Minnesota | 27171 | 28126 | 251 |
2042276 | 2042276 | 2021-12-23 | Wright | Minnesota | 27171 | 28126 | 251 |
2039027 | 2039027 | 2021-12-22 | Wright | Minnesota | 27171 | 28034 | 250 |
2035777 | 2035777 | 2021-12-21 | Wright | Minnesota | 27171 | 27949 | 248 |
2032527 | 2032527 | 2021-12-20 | Wright | Minnesota | 27171 | 27749 | 247 |
2029276 | 2029276 | 2021-12-19 | Wright | Minnesota | 27171 | 27671 | 245 |
2026025 | 2026025 | 2021-12-18 | Wright | Minnesota | 27171 | 27671 | 245 |
2022774 | 2022774 | 2021-12-17 | Wright | Minnesota | 27171 | 27671 | 245 |
2019523 | 2019523 | 2021-12-16 | Wright | Minnesota | 27171 | 27582 | 242 |
2016273 | 2016273 | 2021-12-15 | Wright | Minnesota | 27171 | 27488 | 241 |
2013022 | 2013022 | 2021-12-14 | Wright | Minnesota | 27171 | 27435 | 240 |
2009771 | 2009771 | 2021-12-13 | Wright | Minnesota | 27171 | 27219 | 238 |
2006520 | 2006520 | 2021-12-12 | Wright | Minnesota | 27171 | 27122 | 237 |
2003269 | 2003269 | 2021-12-11 | Wright | Minnesota | 27171 | 27122 | 237 |
2000019 | 2000019 | 2021-12-10 | Wright | Minnesota | 27171 | 27122 | 237 |
1996768 | 1996768 | 2021-12-09 | Wright | Minnesota | 27171 | 27009 | 235 |
1993517 | 1993517 | 2021-12-08 | Wright | Minnesota | 27171 | 26881 | 235 |
1990266 | 1990266 | 2021-12-07 | Wright | Minnesota | 27171 | 26779 | 230 |
1987016 | 1987016 | 2021-12-06 | Wright | Minnesota | 27171 | 26415 | 229 |
1983766 | 1983766 | 2021-12-05 | Wright | Minnesota | 27171 | 26260 | 226 |
1980516 | 1980516 | 2021-12-04 | Wright | Minnesota | 27171 | 26260 | 226 |
1977266 | 1977266 | 2021-12-03 | Wright | Minnesota | 27171 | 26260 | 226 |
1974016 | 1974016 | 2021-12-02 | Wright | Minnesota | 27171 | 26105 | 223 |
1970767 | 1970767 | 2021-12-01 | Wright | Minnesota | 27171 | 25957 | 217 |
1967517 | 1967517 | 2021-11-30 | Wright | Minnesota | 27171 | 25830 | 216 |
1964265 | 1964265 | 2021-11-29 | Wright | Minnesota | 27171 | 25490 | 216 |
1961014 | 1961014 | 2021-11-28 | Wright | Minnesota | 27171 | 25354 | 211 |
1957763 | 1957763 | 2021-11-27 | Wright | Minnesota | 27171 | 25354 | 211 |
1954512 | 1954512 | 2021-11-26 | Wright | Minnesota | 27171 | 25354 | 211 |
1951261 | 1951261 | 2021-11-25 | Wright | Minnesota | 27171 | 25235 | 206 |
1948010 | 1948010 | 2021-11-24 | Wright | Minnesota | 27171 | 25235 | 206 |
1944759 | 1944759 | 2021-11-23 | Wright | Minnesota | 27171 | 25108 | 201 |
1941508 | 1941508 | 2021-11-22 | Wright | Minnesota | 27171 | 24789 | 198 |
1938258 | 1938258 | 2021-11-21 | Wright | Minnesota | 27171 | 24642 | 197 |
1935008 | 1935008 | 2021-11-20 | Wright | Minnesota | 27171 | 24642 | 197 |
1931758 | 1931758 | 2021-11-19 | Wright | Minnesota | 27171 | 24642 | 197 |
1928507 | 1928507 | 2021-11-18 | Wright | Minnesota | 27171 | 24458 | 195 |
1925257 | 1925257 | 2021-11-17 | Wright | Minnesota | 27171 | 24272 | 193 |
1922008 | 1922008 | 2021-11-16 | Wright | Minnesota | 27171 | 24115 | 192 |
1918758 | 1918758 | 2021-11-15 | Wright | Minnesota | 27171 | 23780 | 191 |
1915508 | 1915508 | 2021-11-14 | Wright | Minnesota | 27171 | 23626 | 191 |
1912258 | 1912258 | 2021-11-13 | Wright | Minnesota | 27171 | 23626 | 191 |
1909008 | 1909008 | 2021-11-12 | Wright | Minnesota | 27171 | 23626 | 191 |
1905759 | 1905759 | 2021-11-11 | Wright | Minnesota | 27171 | 23472 | 191 |
1902510 | 1902510 | 2021-11-10 | Wright | Minnesota | 27171 | 23304 | 187 |
1899260 | 1899260 | 2021-11-09 | Wright | Minnesota | 27171 | 23066 | 184 |
1896010 | 1896010 | 2021-11-08 | Wright | Minnesota | 27171 | 22856 | 182 |
1892760 | 1892760 | 2021-11-07 | Wright | Minnesota | 27171 | 22740 | 181 |
1889510 | 1889510 | 2021-11-06 | Wright | Minnesota | 27171 | 22740 | 181 |
1886260 | 1886260 | 2021-11-05 | Wright | Minnesota | 27171 | 22740 | 181 |
1883011 | 1883011 | 2021-11-04 | Wright | Minnesota | 27171 | 22653 | 180 |
1879762 | 1879762 | 2021-11-03 | Wright | Minnesota | 27171 | 22556 | 179 |
1876513 | 1876513 | 2021-11-02 | Wright | Minnesota | 27171 | 22421 | 179 |
1873264 | 1873264 | 2021-11-01 | Wright | Minnesota | 27171 | 22188 | 176 |
1870015 | 1870015 | 2021-10-31 | Wright | Minnesota | 27171 | 21913 | 174 |
1866766 | 1866766 | 2021-10-30 | Wright | Minnesota | 27171 | 21913 | 174 |
1863517 | 1863517 | 2021-10-29 | Wright | Minnesota | 27171 | 21913 | 174 |
1860268 | 1860268 | 2021-10-28 | Wright | Minnesota | 27171 | 21810 | 173 |
1857019 | 1857019 | 2021-10-27 | Wright | Minnesota | 27171 | 21731 | 172 |
1853770 | 1853770 | 2021-10-26 | Wright | Minnesota | 27171 | 21662 | 171 |
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);