ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
297 rows where cases = 1560 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- Georgia 22
- Minnesota 20
- Missouri 20
- Kentucky 17
- Virginia 15
- Illinois 12
- Mississippi 12
- North Carolina 11
- Louisiana 9
- Oklahoma 9
- Kansas 8
- Arkansas 7
- South Dakota 7
- Maine 6
- Montana 6
- Puerto Rico 6
- Tennessee 6
- Nebraska 5
- Pennsylvania 5
- South Carolina 5
- Wisconsin 5
- Alabama 4
- Colorado 4
- Connecticut 4
- Florida 4
- Indiana 4
- Iowa 4
- Michigan 4
- New York 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2325266 | 2325266 | 2022-03-20 | Quitman | Mississippi | 28119 | 1560 | 31 |
2322012 | 2322012 | 2022-03-19 | Quitman | Mississippi | 28119 | 1560 | 31 |
2318758 | 2318758 | 2022-03-18 | Quitman | Mississippi | 28119 | 1560 | 31 |
2315505 | 2315505 | 2022-03-17 | Quitman | Mississippi | 28119 | 1560 | 31 |
2312252 | 2312252 | 2022-03-16 | Quitman | Mississippi | 28119 | 1560 | 31 |
2308999 | 2308999 | 2022-03-15 | Quitman | Mississippi | 28119 | 1560 | 31 |
2305748 | 2305748 | 2022-03-14 | Quitman | Mississippi | 28119 | 1560 | 31 |
2246200 | 2246200 | 2022-02-24 | Hancock | Georgia | 13141 | 1560 | 87 |
2241481 | 2241481 | 2022-02-22 | Harney | Oregon | 41025 | 1560 | 36 |
2215880 | 2215880 | 2022-02-14 | Brooks | Texas | 48047 | 1560 | 50 |
2167160 | 2167160 | 2022-01-30 | Hansford | Texas | 48195 | 1560 | 27 |
2131517 | 2131517 | 2022-01-19 | Winkler | Texas | 48495 | 1560 | 33 |
2128528 | 2128528 | 2022-01-18 | Pocahontas | West Virginia | 54075 | 1560 | 25 |
2119431 | 2119431 | 2022-01-16 | Wilcox | Georgia | 13315 | 1560 | 61 |
2116179 | 2116179 | 2022-01-15 | Wilcox | Georgia | 13315 | 1560 | 61 |
2112928 | 2112928 | 2022-01-14 | Wilcox | Georgia | 13315 | 1560 | 61 |
2099899 | 2099899 | 2022-01-10 | Taylor | Georgia | 13269 | 1560 | 42 |
2089517 | 2089517 | 2022-01-06 | Tyler | West Virginia | 54095 | 1560 | 26 |
2082345 | 2082345 | 2022-01-04 | Custer | South Dakota | 46033 | 1560 | 20 |
2009735 | 2009735 | 2021-12-13 | Murray | Minnesota | 27101 | 1560 | 11 |
1989367 | 1989367 | 2021-12-07 | Seminole | Georgia | 13253 | 1560 | 26 |
1986117 | 1986117 | 2021-12-06 | Seminole | Georgia | 13253 | 1560 | 26 |
1974221 | 1974221 | 2021-12-02 | Carbon | Montana | 30009 | 1560 | 22 |
1975571 | 1975571 | 2021-12-02 | Floyd | Virginia | 51063 | 1560 | 32 |
1965785 | 1965785 | 2021-11-29 | Amelia | Virginia | 51007 | 1560 | 42 |
1951462 | 1951462 | 2021-11-25 | Beaverhead | Montana | 30001 | 1560 | 22 |
1948211 | 1948211 | 2021-11-24 | Beaverhead | Montana | 30001 | 1560 | 22 |
1942904 | 1942904 | 2021-11-22 | Parmer | Texas | 48369 | 1560 | 41 |
1939654 | 1939654 | 2021-11-21 | Parmer | Texas | 48369 | 1560 | 41 |
1936404 | 1936404 | 2021-11-20 | Parmer | Texas | 48369 | 1560 | 41 |
1921957 | 1921957 | 2021-11-16 | Koochiching | Minnesota | 27071 | 1560 | 21 |
1915497 | 1915497 | 2021-11-14 | Swift | Minnesota | 27151 | 1560 | 20 |
1912247 | 1912247 | 2021-11-13 | Swift | Minnesota | 27151 | 1560 | 20 |
1908997 | 1908997 | 2021-11-12 | Swift | Minnesota | 27151 | 1560 | 20 |
1905931 | 1905931 | 2021-11-11 | Ralls | Missouri | 29173 | 1560 | 14 |
1902682 | 1902682 | 2021-11-10 | Ralls | Missouri | 29173 | 1560 | 14 |
1900756 | 1900756 | 2021-11-09 | Addison | Vermont | 50001 | 1560 | 8 |
1882070 | 1882070 | 2021-11-04 | Johnson | Georgia | 13167 | 1560 | 62 |
1884645 | 1884645 | 2021-11-04 | Sussex | Virginia | 51183 | 1560 | 28 |
1878821 | 1878821 | 2021-11-03 | Johnson | Georgia | 13167 | 1560 | 62 |
1879380 | 1879380 | 2021-11-03 | Edmonson | Kentucky | 21061 | 1560 | 29 |
1881396 | 1881396 | 2021-11-03 | Sussex | Virginia | 51183 | 1560 | 28 |
1875572 | 1875572 | 2021-11-02 | Johnson | Georgia | 13167 | 1560 | 62 |
1878241 | 1878241 | 2021-11-02 | Roane | West Virginia | 54087 | 1560 | 21 |
1871118 | 1871118 | 2021-10-31 | Roberts | South Dakota | 46109 | 1560 | 43 |
1867869 | 1867869 | 2021-10-30 | Roberts | South Dakota | 46109 | 1560 | 43 |
1864620 | 1864620 | 2021-10-29 | Roberts | South Dakota | 46109 | 1560 | 43 |
1854247 | 1854247 | 2021-10-26 | Schuyler | New York | 36097 | 1560 | 17 |
1825111 | 1825111 | 2021-10-17 | Washington | North Carolina | 37187 | 1560 | 37 |
1821400 | 1821400 | 2021-10-16 | Grundy | Missouri | 29079 | 1560 | 47 |
1821862 | 1821862 | 2021-10-16 | Washington | North Carolina | 37187 | 1560 | 37 |
1818613 | 1818613 | 2021-10-15 | Washington | North Carolina | 37187 | 1560 | 37 |
1813661 | 1813661 | 2021-10-14 | Prowers | Colorado | 8099 | 1560 | 29 |
1802512 | 1802512 | 2021-10-10 | Vinton | Ohio | 39163 | 1560 | 21 |
1788859 | 1788859 | 2021-10-06 | Tunica | Mississippi | 28143 | 1560 | 36 |
1786051 | 1786051 | 2021-10-05 | Clay | North Carolina | 37043 | 1560 | 34 |
1766158 | 1766158 | 2021-09-29 | Douglas | Missouri | 29067 | 1560 | 42 |
1738816 | 1738816 | 2021-09-21 | Stone | Arkansas | 5137 | 1560 | 38 |
1740143 | 1740143 | 2021-09-21 | Bollinger | Missouri | 29017 | 1560 | 17 |
1724232 | 1724232 | 2021-09-16 | Socorro | New Mexico | 35053 | 1560 | 62 |
1722295 | 1722295 | 2021-09-15 | Ashland | Wisconsin | 55003 | 1560 | 16 |
1718106 | 1718106 | 2021-09-14 | Pushmataha | Oklahoma | 40127 | 1560 | 31 |
1714858 | 1714858 | 2021-09-13 | Pushmataha | Oklahoma | 40127 | 1560 | 31 |
1711612 | 1711612 | 2021-09-12 | Pushmataha | Oklahoma | 40127 | 1560 | 31 |
1708365 | 1708365 | 2021-09-11 | Pushmataha | Oklahoma | 40127 | 1560 | 31 |
1705118 | 1705118 | 2021-09-10 | Pushmataha | Oklahoma | 40127 | 1560 | 31 |
1701868 | 1701868 | 2021-09-09 | Pushmataha | Oklahoma | 40127 | 1560 | 31 |
1698619 | 1698619 | 2021-09-08 | Pushmataha | Oklahoma | 40127 | 1560 | 31 |
1695149 | 1695149 | 2021-09-07 | Swain | North Carolina | 37173 | 1560 | 21 |
1685703 | 1685703 | 2021-09-04 | Fulton | Pennsylvania | 42057 | 1560 | 19 |
1670685 | 1670685 | 2021-08-31 | Gunnison | Colorado | 8051 | 1560 | 7 |
1667417 | 1667417 | 2021-08-30 | Bent | Colorado | 8011 | 1560 | 22 |
1668364 | 1668364 | 2021-08-30 | Sagadahoc | Maine | 23023 | 1560 | 12 |
1668526 | 1668526 | 2021-08-30 | Kanabec | Minnesota | 27065 | 1560 | 29 |
1665117 | 1665117 | 2021-08-29 | Sagadahoc | Maine | 23023 | 1560 | 12 |
1661869 | 1661869 | 2021-08-28 | Sagadahoc | Maine | 23023 | 1560 | 12 |
1662188 | 1662188 | 2021-08-28 | Cedar | Missouri | 29039 | 1560 | 24 |
1655236 | 1655236 | 2021-08-26 | Knott | Kentucky | 21119 | 1560 | 25 |
1655704 | 1655704 | 2021-08-26 | Dent | Missouri | 29065 | 1560 | 25 |
1657383 | 1657383 | 2021-08-26 | Rusk | Wisconsin | 55107 | 1560 | 25 |
1630651 | 1630651 | 2021-08-18 | Bon Homme | South Dakota | 46009 | 1560 | 29 |
1625877 | 1625877 | 2021-08-17 | Jackson | Kansas | 20085 | 1560 | 17 |
1622630 | 1622630 | 2021-08-16 | Jackson | Kansas | 20085 | 1560 | 17 |
1623926 | 1623926 | 2021-08-16 | Crook | Oregon | 41013 | 1560 | 28 |
1610037 | 1610037 | 2021-08-12 | Chippewa | Minnesota | 27023 | 1560 | 39 |
1608429 | 1608429 | 2021-08-11 | Goochland | Virginia | 51075 | 1560 | 24 |
1603257 | 1603257 | 2021-08-10 | Jackson | Kentucky | 21109 | 1560 | 32 |
1601067 | 1601067 | 2021-08-09 | Meigs | Ohio | 39105 | 1560 | 40 |
1583821 | 1583821 | 2021-08-04 | Union | Kentucky | 21225 | 1560 | 18 |
1577774 | 1577774 | 2021-08-02 | Mississippi | Missouri | 29133 | 1560 | 28 |
1557683 | 1557683 | 2021-07-27 | Nemaha | Kansas | 20131 | 1560 | 55 |
1554436 | 1554436 | 2021-07-26 | Nemaha | Kansas | 20131 | 1560 | 55 |
1556535 | 1556535 | 2021-07-26 | Asotin | Washington | 53003 | 1560 | 31 |
1549328 | 1549328 | 2021-07-24 | Catano | Puerto Rico | 72033 | 1560 | |
1531816 | 1531816 | 2021-07-19 | Lyon | Kentucky | 21143 | 1560 | 22 |
1528569 | 1528569 | 2021-07-18 | Lyon | Kentucky | 21143 | 1560 | 22 |
1525322 | 1525322 | 2021-07-17 | Lyon | Kentucky | 21143 | 1560 | 22 |
1522074 | 1522074 | 2021-07-16 | Lyon | Kentucky | 21143 | 1560 | 22 |
1518826 | 1518826 | 2021-07-15 | Lyon | Kentucky | 21143 | 1560 | 22 |
1520555 | 1520555 | 2021-07-15 | Nolan | Texas | 48353 | 1560 | 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);