ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Washington" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110539 | 2110539 | 2022-01-13 | Washington | Minnesota | 27163 | 51479 | 421 |
2107288 | 2107288 | 2022-01-12 | Washington | Minnesota | 27163 | 50725 | 419 |
2104037 | 2104037 | 2022-01-11 | Washington | Minnesota | 27163 | 50325 | 417 |
2100786 | 2100786 | 2022-01-10 | Washington | Minnesota | 27163 | 48954 | 417 |
2097535 | 2097535 | 2022-01-09 | Washington | Minnesota | 27163 | 48188 | 416 |
2094283 | 2094283 | 2022-01-08 | Washington | Minnesota | 27163 | 48188 | 416 |
2091031 | 2091031 | 2022-01-07 | Washington | Minnesota | 27163 | 48188 | 416 |
2087780 | 2087780 | 2022-01-06 | Washington | Minnesota | 27163 | 47807 | 416 |
2084528 | 2084528 | 2022-01-05 | Washington | Minnesota | 27163 | 47412 | 412 |
2081276 | 2081276 | 2022-01-04 | Washington | Minnesota | 27163 | 47244 | 409 |
2078024 | 2078024 | 2022-01-03 | Washington | Minnesota | 27163 | 46308 | 409 |
2074773 | 2074773 | 2022-01-02 | Washington | Minnesota | 27163 | 45954 | 406 |
2071522 | 2071522 | 2022-01-01 | Washington | Minnesota | 27163 | 45954 | 406 |
2068271 | 2068271 | 2021-12-31 | Washington | Minnesota | 27163 | 45954 | 406 |
2065020 | 2065020 | 2021-12-30 | Washington | Minnesota | 27163 | 45954 | 406 |
2061770 | 2061770 | 2021-12-29 | Washington | Minnesota | 27163 | 45573 | 405 |
2058521 | 2058521 | 2021-12-28 | Washington | Minnesota | 27163 | 45403 | 400 |
2055272 | 2055272 | 2021-12-27 | Washington | Minnesota | 27163 | 44853 | 397 |
2052022 | 2052022 | 2021-12-26 | Washington | Minnesota | 27163 | 44647 | 394 |
2048772 | 2048772 | 2021-12-25 | Washington | Minnesota | 27163 | 44647 | 394 |
2045522 | 2045522 | 2021-12-24 | Washington | Minnesota | 27163 | 44647 | 394 |
2042272 | 2042272 | 2021-12-23 | Washington | Minnesota | 27163 | 44647 | 394 |
2039023 | 2039023 | 2021-12-22 | Washington | Minnesota | 27163 | 44497 | 393 |
2035773 | 2035773 | 2021-12-21 | Washington | Minnesota | 27163 | 44363 | 392 |
2032523 | 2032523 | 2021-12-20 | Washington | Minnesota | 27163 | 44025 | 387 |
2029272 | 2029272 | 2021-12-19 | Washington | Minnesota | 27163 | 43838 | 386 |
2026021 | 2026021 | 2021-12-18 | Washington | Minnesota | 27163 | 43838 | 386 |
2022770 | 2022770 | 2021-12-17 | Washington | Minnesota | 27163 | 43838 | 386 |
2019519 | 2019519 | 2021-12-16 | Washington | Minnesota | 27163 | 43689 | 383 |
2016269 | 2016269 | 2021-12-15 | Washington | Minnesota | 27163 | 43534 | 382 |
2013018 | 2013018 | 2021-12-14 | Washington | Minnesota | 27163 | 43447 | 381 |
2009767 | 2009767 | 2021-12-13 | Washington | Minnesota | 27163 | 42983 | 380 |
2006516 | 2006516 | 2021-12-12 | Washington | Minnesota | 27163 | 42781 | 378 |
2003265 | 2003265 | 2021-12-11 | Washington | Minnesota | 27163 | 42781 | 378 |
2000015 | 2000015 | 2021-12-10 | Washington | Minnesota | 27163 | 42781 | 378 |
1996764 | 1996764 | 2021-12-09 | Washington | Minnesota | 27163 | 42541 | 375 |
1993513 | 1993513 | 2021-12-08 | Washington | Minnesota | 27163 | 42327 | 372 |
1990262 | 1990262 | 2021-12-07 | Washington | Minnesota | 27163 | 42195 | 370 |
1987012 | 1987012 | 2021-12-06 | Washington | Minnesota | 27163 | 41511 | 368 |
1983762 | 1983762 | 2021-12-05 | Washington | Minnesota | 27163 | 41119 | 367 |
1980512 | 1980512 | 2021-12-04 | Washington | Minnesota | 27163 | 41119 | 367 |
1977262 | 1977262 | 2021-12-03 | Washington | Minnesota | 27163 | 41119 | 367 |
1974012 | 1974012 | 2021-12-02 | Washington | Minnesota | 27163 | 40846 | 364 |
1970763 | 1970763 | 2021-12-01 | Washington | Minnesota | 27163 | 40545 | 359 |
1967513 | 1967513 | 2021-11-30 | Washington | Minnesota | 27163 | 40349 | 356 |
1964261 | 1964261 | 2021-11-29 | Washington | Minnesota | 27163 | 39581 | 356 |
1961010 | 1961010 | 2021-11-28 | Washington | Minnesota | 27163 | 39357 | 355 |
1957759 | 1957759 | 2021-11-27 | Washington | Minnesota | 27163 | 39357 | 355 |
1954508 | 1954508 | 2021-11-26 | Washington | Minnesota | 27163 | 39357 | 355 |
1951257 | 1951257 | 2021-11-25 | Washington | Minnesota | 27163 | 39195 | 354 |
1948006 | 1948006 | 2021-11-24 | Washington | Minnesota | 27163 | 39195 | 354 |
1944755 | 1944755 | 2021-11-23 | Washington | Minnesota | 27163 | 39032 | 350 |
1941504 | 1941504 | 2021-11-22 | Washington | Minnesota | 27163 | 38455 | 348 |
1938254 | 1938254 | 2021-11-21 | Washington | Minnesota | 27163 | 38160 | 348 |
1935004 | 1935004 | 2021-11-20 | Washington | Minnesota | 27163 | 38160 | 348 |
1931754 | 1931754 | 2021-11-19 | Washington | Minnesota | 27163 | 38160 | 348 |
1928503 | 1928503 | 2021-11-18 | Washington | Minnesota | 27163 | 37966 | 348 |
1925253 | 1925253 | 2021-11-17 | Washington | Minnesota | 27163 | 37764 | 345 |
1922004 | 1922004 | 2021-11-16 | Washington | Minnesota | 27163 | 37628 | 343 |
1918754 | 1918754 | 2021-11-15 | Washington | Minnesota | 27163 | 37109 | 342 |
1915504 | 1915504 | 2021-11-14 | Washington | Minnesota | 27163 | 36843 | 342 |
1912254 | 1912254 | 2021-11-13 | Washington | Minnesota | 27163 | 36843 | 342 |
1909004 | 1909004 | 2021-11-12 | Washington | Minnesota | 27163 | 36843 | 342 |
1905755 | 1905755 | 2021-11-11 | Washington | Minnesota | 27163 | 36589 | 342 |
1902506 | 1902506 | 2021-11-10 | Washington | Minnesota | 27163 | 36378 | 341 |
1899256 | 1899256 | 2021-11-09 | Washington | Minnesota | 27163 | 36146 | 341 |
1896006 | 1896006 | 2021-11-08 | Washington | Minnesota | 27163 | 35760 | 341 |
1892756 | 1892756 | 2021-11-07 | Washington | Minnesota | 27163 | 35500 | 341 |
1889506 | 1889506 | 2021-11-06 | Washington | Minnesota | 27163 | 35500 | 341 |
1886256 | 1886256 | 2021-11-05 | Washington | Minnesota | 27163 | 35500 | 341 |
1883007 | 1883007 | 2021-11-04 | Washington | Minnesota | 27163 | 35339 | 341 |
1879758 | 1879758 | 2021-11-03 | Washington | Minnesota | 27163 | 35188 | 340 |
1876509 | 1876509 | 2021-11-02 | Washington | Minnesota | 27163 | 35071 | 337 |
1873260 | 1873260 | 2021-11-01 | Washington | Minnesota | 27163 | 34756 | 334 |
1870011 | 1870011 | 2021-10-31 | Washington | Minnesota | 27163 | 34287 | 333 |
1866762 | 1866762 | 2021-10-30 | Washington | Minnesota | 27163 | 34287 | 333 |
1863513 | 1863513 | 2021-10-29 | Washington | Minnesota | 27163 | 34287 | 333 |
1860264 | 1860264 | 2021-10-28 | Washington | Minnesota | 27163 | 34166 | 333 |
1857015 | 1857015 | 2021-10-27 | Washington | Minnesota | 27163 | 34081 | 332 |
1853766 | 1853766 | 2021-10-26 | Washington | Minnesota | 27163 | 34014 | 332 |
1850517 | 1850517 | 2021-10-25 | Washington | Minnesota | 27163 | 33796 | 332 |
1847267 | 1847267 | 2021-10-24 | Washington | Minnesota | 27163 | 33690 | 331 |
1844017 | 1844017 | 2021-10-23 | Washington | Minnesota | 27163 | 33690 | 331 |
1840767 | 1840767 | 2021-10-22 | Washington | Minnesota | 27163 | 33690 | 331 |
1837518 | 1837518 | 2021-10-21 | Washington | Minnesota | 27163 | 33598 | 331 |
1834269 | 1834269 | 2021-10-20 | Washington | Minnesota | 27163 | 33492 | 329 |
1831020 | 1831020 | 2021-10-19 | Washington | Minnesota | 27163 | 33431 | 329 |
1827771 | 1827771 | 2021-10-18 | Washington | Minnesota | 27163 | 33236 | 329 |
1824522 | 1824522 | 2021-10-17 | Washington | Minnesota | 27163 | 33145 | 327 |
1821273 | 1821273 | 2021-10-16 | Washington | Minnesota | 27163 | 33145 | 327 |
1818024 | 1818024 | 2021-10-15 | Washington | Minnesota | 27163 | 33145 | 327 |
1814775 | 1814775 | 2021-10-14 | Washington | Minnesota | 27163 | 33051 | 325 |
1811527 | 1811527 | 2021-10-13 | Washington | Minnesota | 27163 | 32937 | 325 |
1808278 | 1808278 | 2021-10-12 | Washington | Minnesota | 27163 | 32870 | 325 |
1805027 | 1805027 | 2021-10-11 | Washington | Minnesota | 27163 | 32576 | 325 |
1801778 | 1801778 | 2021-10-10 | Washington | Minnesota | 27163 | 32495 | 323 |
1798529 | 1798529 | 2021-10-09 | Washington | Minnesota | 27163 | 32495 | 323 |
1795280 | 1795280 | 2021-10-08 | Washington | Minnesota | 27163 | 32495 | 323 |
1792031 | 1792031 | 2021-10-07 | Washington | Minnesota | 27163 | 32393 | 322 |
1788782 | 1788782 | 2021-10-06 | Washington | Minnesota | 27163 | 32321 | 322 |
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);