ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
185 rows where cases = 2813 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 21
- Kansas 13
- Tennessee 12
- Arkansas 11
- Virginia 10
- Illinois 8
- Oklahoma 7
- Mississippi 6
- Missouri 6
- New York 6
- Colorado 5
- Georgia 5
- Indiana 5
- Kentucky 5
- North Carolina 5
- West Virginia 5
- Alabama 4
- Iowa 4
- Minnesota 4
- Washington 4
- Louisiana 3
- Montana 3
- Nebraska 3
- New Hampshire 3
- South Dakota 3
- Wisconsin 3
- California 2
- Michigan 2
- North Dakota 2
- Ohio 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444506 | 2444506 | 2022-04-26 | Rio Grande | Colorado | 8105 | 2813 | 46 |
2441250 | 2441250 | 2022-04-25 | Rio Grande | Colorado | 8105 | 2813 | 46 |
2360574 | 2360574 | 2022-03-31 | Wilson | Kansas | 20205 | 2813 | 42 |
2357320 | 2357320 | 2022-03-30 | Wilson | Kansas | 20205 | 2813 | 42 |
2315534 | 2315534 | 2022-03-17 | Barton | Missouri | 29011 | 2813 | 51 |
2301971 | 2301971 | 2022-03-13 | Linn | Kansas | 20107 | 2813 | 27 |
2298719 | 2298719 | 2022-03-12 | Linn | Kansas | 20107 | 2813 | 27 |
2295467 | 2295467 | 2022-03-11 | Linn | Kansas | 20107 | 2813 | 27 |
2269572 | 2269572 | 2022-03-03 | Lyon | Kentucky | 21143 | 2813 | 33 |
2257881 | 2257881 | 2022-02-27 | Orocovis | Puerto Rico | 72107 | 2813 | |
2239486 | 2239486 | 2022-02-22 | Archuleta | Colorado | 8007 | 2813 | 13 |
2206790 | 2206790 | 2022-02-12 | Wilcox | Alabama | 1131 | 2813 | 40 |
2203489 | 2203489 | 2022-02-11 | Conecuh | Alabama | 1035 | 2813 | 63 |
2202744 | 2202744 | 2022-02-10 | Todd | South Dakota | 46121 | 2813 | 44 |
2196607 | 2196607 | 2022-02-08 | Morgan | Utah | 49029 | 2813 | 13 |
2187353 | 2187353 | 2022-02-06 | Lee | Arkansas | 5077 | 2813 | 54 |
2184100 | 2184100 | 2022-02-05 | Lee | Arkansas | 5077 | 2813 | 54 |
2180848 | 2180848 | 2022-02-04 | Lee | Arkansas | 5077 | 2813 | 54 |
2179070 | 2179070 | 2022-02-03 | Custer | Montana | 30017 | 2813 | 44 |
2151247 | 2151247 | 2022-01-25 | Klickitat | Washington | 53039 | 2813 | 37 |
2147995 | 2147995 | 2022-01-24 | Klickitat | Washington | 53039 | 2813 | 37 |
2127485 | 2127485 | 2022-01-18 | Harrison | Ohio | 39067 | 2813 | 61 |
2107438 | 2107438 | 2022-01-12 | Madison | Missouri | 29123 | 2813 | 45 |
2102507 | 2102507 | 2022-01-10 | Monroe | West Virginia | 54063 | 2813 | 32 |
2058759 | 2058759 | 2021-12-28 | Park | Montana | 30067 | 2813 | 31 |
2013772 | 2013772 | 2021-12-14 | Choctaw | Oklahoma | 40023 | 2813 | 52 |
2010521 | 2010521 | 2021-12-13 | Choctaw | Oklahoma | 40023 | 2813 | 52 |
2007270 | 2007270 | 2021-12-12 | Choctaw | Oklahoma | 40023 | 2813 | 52 |
2004019 | 2004019 | 2021-12-11 | Choctaw | Oklahoma | 40023 | 2813 | 52 |
2000768 | 2000768 | 2021-12-10 | Choctaw | Oklahoma | 40023 | 2813 | 52 |
1997518 | 1997518 | 2021-12-09 | Choctaw | Oklahoma | 40023 | 2813 | 52 |
1994267 | 1994267 | 2021-12-08 | Choctaw | Oklahoma | 40023 | 2813 | 52 |
1948908 | 1948908 | 2021-11-24 | Montour | Pennsylvania | 42093 | 2813 | 75 |
1937808 | 1937808 | 2021-11-21 | Neosho | Kansas | 20133 | 2813 | 53 |
1934558 | 1934558 | 2021-11-20 | Neosho | Kansas | 20133 | 2813 | 53 |
1931307 | 1931307 | 2021-11-19 | Neosho | Kansas | 20133 | 2813 | 53 |
1928955 | 1928955 | 2021-11-18 | Essex | New York | 36031 | 2813 | 37 |
1907445 | 1907445 | 2021-11-11 | Barbour | West Virginia | 54001 | 2813 | 46 |
1893308 | 1893308 | 2021-11-07 | Madison | North Carolina | 37115 | 2813 | 60 |
1890058 | 1890058 | 2021-11-06 | Madison | North Carolina | 37115 | 2813 | 60 |
1886808 | 1886808 | 2021-11-05 | Madison | North Carolina | 37115 | 2813 | 60 |
1876521 | 1876521 | 2021-11-02 | Calhoun | Mississippi | 28013 | 2813 | 49 |
1876859 | 1876859 | 2021-11-02 | Washington | Nebraska | 31177 | 2813 | 29 |
1878336 | 1878336 | 2021-11-02 | Lincoln | Wyoming | 56023 | 2813 | 22 |
1873610 | 1873610 | 2021-11-01 | Washington | Nebraska | 31177 | 2813 | 29 |
1875028 | 1875028 | 2021-11-01 | Iowa | Wisconsin | 55049 | 2813 | 17 |
1871625 | 1871625 | 2021-10-31 | Powhatan | Virginia | 51145 | 2813 | 28 |
1868376 | 1868376 | 2021-10-30 | Powhatan | Virginia | 51145 | 2813 | 28 |
1865127 | 1865127 | 2021-10-29 | Powhatan | Virginia | 51145 | 2813 | 28 |
1853037 | 1853037 | 2021-10-26 | Richland | Illinois | 17159 | 2813 | 66 |
1840581 | 1840581 | 2021-10-22 | Talbot | Maryland | 24041 | 2813 | 53 |
1838667 | 1838667 | 2021-10-21 | Grundy | Tennessee | 47061 | 2813 | 37 |
1802159 | 1802159 | 2021-10-10 | Sullivan | New Hampshire | 33019 | 2813 | 32 |
1798910 | 1798910 | 2021-10-09 | Sullivan | New Hampshire | 33019 | 2813 | 32 |
1795661 | 1795661 | 2021-10-08 | Sullivan | New Hampshire | 33019 | 2813 | 32 |
1796780 | 1796780 | 2021-10-08 | Bennington | Vermont | 50003 | 2813 | 24 |
1770800 | 1770800 | 2021-09-30 | St. Croix | Virgin Islands | 78010 | 2813 | 24 |
1767551 | 1767551 | 2021-09-29 | St. Croix | Virgin Islands | 78010 | 2813 | 24 |
1758269 | 1758269 | 2021-09-27 | Hempstead | Arkansas | 5057 | 2813 | 25 |
1753221 | 1753221 | 2021-09-25 | Ray | Missouri | 29177 | 2813 | 46 |
1742989 | 1742989 | 2021-09-22 | Rockcastle | Kentucky | 21203 | 2813 | 25 |
1735555 | 1735555 | 2021-09-20 | Polk | Arkansas | 5113 | 2813 | 96 |
1717320 | 1717320 | 2021-09-14 | Clay | Mississippi | 28025 | 2813 | 72 |
1715409 | 1715409 | 2021-09-13 | Lamb | Texas | 48279 | 2813 | 86 |
1712163 | 1712163 | 2021-09-12 | Lamb | Texas | 48279 | 2813 | 86 |
1706208 | 1706208 | 2021-09-11 | Randolph | Alabama | 1111 | 2813 | 55 |
1708916 | 1708916 | 2021-09-11 | Lamb | Texas | 48279 | 2813 | 86 |
1704763 | 1704763 | 2021-09-10 | Delaware | New York | 36025 | 2813 | 40 |
1692522 | 1692522 | 2021-09-06 | Trousdale | Tennessee | 47169 | 2813 | 22 |
1689273 | 1689273 | 2021-09-05 | Trousdale | Tennessee | 47169 | 2813 | 22 |
1686023 | 1686023 | 2021-09-04 | Trousdale | Tennessee | 47169 | 2813 | 22 |
1682772 | 1682772 | 2021-09-03 | Trousdale | Tennessee | 47169 | 2813 | 22 |
1667461 | 1667461 | 2021-08-30 | Pitkin | Colorado | 8097 | 2813 | 4 |
1631888 | 1631888 | 2021-08-19 | Grady | Georgia | 13131 | 2813 | 67 |
1634025 | 1634025 | 2021-08-19 | Morgan | Tennessee | 47129 | 2813 | 41 |
1629353 | 1629353 | 2021-08-18 | St. James | Louisiana | 22093 | 2813 | 57 |
1621981 | 1621981 | 2021-08-16 | Morgan | Colorado | 8087 | 2813 | 96 |
1624875 | 1624875 | 2021-08-16 | Kewaunee | Wisconsin | 55061 | 2813 | 37 |
1612070 | 1612070 | 2021-08-13 | Cleburne | Arkansas | 5023 | 2813 | 76 |
1610005 | 1610005 | 2021-08-12 | Oceana | Michigan | 26127 | 2813 | 60 |
1606543 | 1606543 | 2021-08-11 | Ohio | Kentucky | 21183 | 2813 | 56 |
1606757 | 1606757 | 2021-08-11 | Oceana | Michigan | 26127 | 2813 | 60 |
1543281 | 1543281 | 2021-07-22 | Moore | Texas | 48341 | 2813 | 73 |
1511739 | 1511739 | 2021-07-13 | Lee | Georgia | 13177 | 2813 | 59 |
1512869 | 1512869 | 2021-07-13 | Washington | Missouri | 29221 | 2813 | 52 |
1513867 | 1513867 | 2021-07-13 | Smith | Tennessee | 47159 | 2813 | 40 |
1510621 | 1510621 | 2021-07-12 | Smith | Tennessee | 47159 | 2813 | 40 |
1494864 | 1494864 | 2021-07-07 | Okanogan | Washington | 53047 | 2813 | 43 |
1489492 | 1489492 | 2021-07-06 | Miami | Kansas | 20121 | 2813 | 42 |
1486245 | 1486245 | 2021-07-05 | Miami | Kansas | 20121 | 2813 | 42 |
1482999 | 1482999 | 2021-07-04 | Miami | Kansas | 20121 | 2813 | 42 |
1479752 | 1479752 | 2021-07-03 | Miami | Kansas | 20121 | 2813 | 42 |
1476506 | 1476506 | 2021-07-02 | Miami | Kansas | 20121 | 2813 | 42 |
1451455 | 1451455 | 2021-06-24 | Lewis | New York | 36049 | 2813 | 36 |
1429472 | 1429472 | 2021-06-17 | Smith | Tennessee | 47159 | 2813 | 40 |
1426227 | 1426227 | 2021-06-16 | Smith | Tennessee | 47159 | 2813 | 40 |
1356799 | 1356799 | 2021-05-26 | Cass | Minnesota | 27021 | 2813 | 32 |
1358701 | 1358701 | 2021-05-26 | Park | Wyoming | 56029 | 2813 | 30 |
1349089 | 1349089 | 2021-05-24 | Carroll | Arkansas | 5015 | 2813 | 46 |
1345842 | 1345842 | 2021-05-23 | Carroll | Arkansas | 5015 | 2813 | 46 |
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);