ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,270 rows where cases = 34 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 266
- Texas 247
- Georgia 166
- Kentucky 143
- Iowa 125
- Kansas 113
- Illinois 100
- Virginia 96
- North Dakota 95
- Tennessee 92
- Arkansas 83
- Colorado 82
- Missouri 81
- Montana 81
- Minnesota 76
- Michigan 75
- Wisconsin 75
- South Dakota 74
- Indiana 70
- Oklahoma 69
- Pennsylvania 68
- Puerto Rico 68
- Ohio 66
- Maine 64
- North Carolina 62
- Oregon 62
- New Mexico 59
- Alaska 53
- Idaho 53
- West Virginia 49
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2195360 | 2195360 | 2022-02-08 | Petroleum | Montana | 30069 | 34 | 1 |
2192106 | 2192106 | 2022-02-07 | Petroleum | Montana | 30069 | 34 | 1 |
2188853 | 2188853 | 2022-02-06 | Petroleum | Montana | 30069 | 34 | 1 |
2185600 | 2185600 | 2022-02-05 | Petroleum | Montana | 30069 | 34 | 1 |
2182348 | 2182348 | 2022-02-04 | Petroleum | Montana | 30069 | 34 | 1 |
2179096 | 2179096 | 2022-02-03 | Petroleum | Montana | 30069 | 34 | 1 |
2175844 | 2175844 | 2022-02-02 | Petroleum | Montana | 30069 | 34 | 1 |
2176259 | 2176259 | 2022-02-02 | Unknown | Northern Mariana Islands | 34 | 0 | |
2172591 | 2172591 | 2022-02-01 | Petroleum | Montana | 30069 | 34 | 1 |
2169338 | 2169338 | 2022-01-31 | Petroleum | Montana | 30069 | 34 | 1 |
1926764 | 1926764 | 2021-11-17 | Unknown | Vermont | 34 | 0 | |
1918544 | 1918544 | 2021-11-15 | Unknown | Maine | 34 | 0 | |
1915294 | 1915294 | 2021-11-14 | Unknown | Maine | 34 | 0 | |
1912044 | 1912044 | 2021-11-13 | Unknown | Maine | 34 | 0 | |
1865023 | 1865023 | 2021-10-29 | Unknown | Vermont | 34 | 0 | |
1838163 | 1838163 | 2021-10-21 | Unknown | North Dakota | 34 | 34 | |
1834914 | 1834914 | 2021-10-20 | Unknown | North Dakota | 34 | 34 | |
1831665 | 1831665 | 2021-10-19 | Unknown | North Dakota | 34 | 34 | |
1828416 | 1828416 | 2021-10-18 | Unknown | North Dakota | 34 | 34 | |
1825167 | 1825167 | 2021-10-17 | Unknown | North Dakota | 34 | 34 | |
1821918 | 1821918 | 2021-10-16 | Unknown | North Dakota | 34 | 34 | |
1818669 | 1818669 | 2021-10-15 | Unknown | North Dakota | 34 | 34 | |
1815420 | 1815420 | 2021-10-14 | Unknown | North Dakota | 34 | 34 | |
1812172 | 1812172 | 2021-10-13 | Unknown | North Dakota | 34 | 34 | |
1808923 | 1808923 | 2021-10-12 | Unknown | North Dakota | 34 | 34 | |
1805443 | 1805443 | 2021-10-11 | Harding | New Mexico | 35021 | 34 | 2 |
1805672 | 1805672 | 2021-10-11 | Unknown | North Dakota | 34 | 34 | |
1802194 | 1802194 | 2021-10-10 | Harding | New Mexico | 35021 | 34 | 2 |
1802423 | 1802423 | 2021-10-10 | Unknown | North Dakota | 34 | 34 | |
1798945 | 1798945 | 2021-10-09 | Harding | New Mexico | 35021 | 34 | 2 |
1799174 | 1799174 | 2021-10-09 | Unknown | North Dakota | 34 | 34 | |
1795696 | 1795696 | 2021-10-08 | Harding | New Mexico | 35021 | 34 | 2 |
1795925 | 1795925 | 2021-10-08 | Unknown | North Dakota | 34 | 34 | |
1792676 | 1792676 | 2021-10-07 | Unknown | North Dakota | 34 | 34 | |
1779681 | 1779681 | 2021-10-03 | Unknown | North Dakota | 34 | 34 | |
1776431 | 1776431 | 2021-10-02 | Unknown | North Dakota | 34 | 34 | |
1773181 | 1773181 | 2021-10-01 | Unknown | North Dakota | 34 | 34 | |
1769931 | 1769931 | 2021-09-30 | Unknown | North Dakota | 34 | 34 | |
1766682 | 1766682 | 2021-09-29 | Unknown | North Dakota | 34 | 34 | |
1763433 | 1763433 | 2021-09-28 | Unknown | North Dakota | 34 | 34 | |
1760184 | 1760184 | 2021-09-27 | Unknown | North Dakota | 34 | 34 | |
1756936 | 1756936 | 2021-09-26 | Unknown | North Dakota | 34 | 34 | |
1753688 | 1753688 | 2021-09-25 | Unknown | North Dakota | 34 | 34 | |
1750440 | 1750440 | 2021-09-24 | Unknown | North Dakota | 34 | 34 | |
1737437 | 1737437 | 2021-09-20 | Slope | North Dakota | 38087 | 34 | 0 |
1733866 | 1733866 | 2021-09-19 | Loup | Nebraska | 31115 | 34 | 0 |
1734187 | 1734187 | 2021-09-19 | Slope | North Dakota | 38087 | 34 | 0 |
1730616 | 1730616 | 2021-09-18 | Loup | Nebraska | 31115 | 34 | 0 |
1730937 | 1730937 | 2021-09-18 | Slope | North Dakota | 38087 | 34 | 0 |
1727366 | 1727366 | 2021-09-17 | Loup | Nebraska | 31115 | 34 | 0 |
1724117 | 1724117 | 2021-09-16 | Loup | Nebraska | 31115 | 34 | 0 |
1720868 | 1720868 | 2021-09-15 | Loup | Nebraska | 31115 | 34 | 0 |
1717620 | 1717620 | 2021-09-14 | Loup | Nebraska | 31115 | 34 | 0 |
1714372 | 1714372 | 2021-09-13 | Loup | Nebraska | 31115 | 34 | 0 |
1711126 | 1711126 | 2021-09-12 | Loup | Nebraska | 31115 | 34 | 0 |
1707879 | 1707879 | 2021-09-11 | Loup | Nebraska | 31115 | 34 | 0 |
1704632 | 1704632 | 2021-09-10 | Loup | Nebraska | 31115 | 34 | 0 |
1705545 | 1705545 | 2021-09-10 | Borden | Texas | 48033 | 34 | 2 |
1701382 | 1701382 | 2021-09-09 | Loup | Nebraska | 31115 | 34 | 0 |
1702295 | 1702295 | 2021-09-09 | Borden | Texas | 48033 | 34 | 2 |
1698133 | 1698133 | 2021-09-08 | Loup | Nebraska | 31115 | 34 | 0 |
1699046 | 1699046 | 2021-09-08 | Borden | Texas | 48033 | 34 | 2 |
1694885 | 1694885 | 2021-09-07 | Loup | Nebraska | 31115 | 34 | 0 |
1691636 | 1691636 | 2021-09-06 | Loup | Nebraska | 31115 | 34 | 0 |
1688386 | 1688386 | 2021-09-05 | Loup | Nebraska | 31115 | 34 | 0 |
1685136 | 1685136 | 2021-09-04 | Loup | Nebraska | 31115 | 34 | 0 |
1681885 | 1681885 | 2021-09-03 | Loup | Nebraska | 31115 | 34 | 0 |
1678637 | 1678637 | 2021-09-02 | Loup | Nebraska | 31115 | 34 | 0 |
1675389 | 1675389 | 2021-09-01 | Loup | Nebraska | 31115 | 34 | 0 |
1672141 | 1672141 | 2021-08-31 | Loup | Nebraska | 31115 | 34 | 0 |
1668894 | 1668894 | 2021-08-30 | Loup | Nebraska | 31115 | 34 | 0 |
1665647 | 1665647 | 2021-08-29 | Loup | Nebraska | 31115 | 34 | 0 |
1662399 | 1662399 | 2021-08-28 | Loup | Nebraska | 31115 | 34 | 0 |
1659151 | 1659151 | 2021-08-27 | Loup | Nebraska | 31115 | 34 | 0 |
1655902 | 1655902 | 2021-08-26 | Loup | Nebraska | 31115 | 34 | 0 |
1652655 | 1652655 | 2021-08-25 | Loup | Nebraska | 31115 | 34 | 0 |
1649407 | 1649407 | 2021-08-24 | Loup | Nebraska | 31115 | 34 | 0 |
1646158 | 1646158 | 2021-08-23 | Loup | Nebraska | 31115 | 34 | 0 |
1642909 | 1642909 | 2021-08-22 | Loup | Nebraska | 31115 | 34 | 0 |
1639659 | 1639659 | 2021-08-21 | Loup | Nebraska | 31115 | 34 | 0 |
1636409 | 1636409 | 2021-08-20 | Loup | Nebraska | 31115 | 34 | 0 |
1633159 | 1633159 | 2021-08-19 | Loup | Nebraska | 31115 | 34 | 0 |
1629912 | 1629912 | 2021-08-18 | Loup | Nebraska | 31115 | 34 | 0 |
1626665 | 1626665 | 2021-08-17 | Loup | Nebraska | 31115 | 34 | 0 |
1623418 | 1623418 | 2021-08-16 | Loup | Nebraska | 31115 | 34 | 0 |
1620171 | 1620171 | 2021-08-15 | Loup | Nebraska | 31115 | 34 | 0 |
1616923 | 1616923 | 2021-08-14 | Loup | Nebraska | 31115 | 34 | 0 |
1613675 | 1613675 | 2021-08-13 | Loup | Nebraska | 31115 | 34 | 0 |
1610426 | 1610426 | 2021-08-12 | Loup | Nebraska | 31115 | 34 | 0 |
1605527 | 1605527 | 2021-08-11 | Haines Borough | Alaska | 2100 | 34 | 0 |
1607178 | 1607178 | 2021-08-11 | Loup | Nebraska | 31115 | 34 | 0 |
1602277 | 1602277 | 2021-08-10 | Haines Borough | Alaska | 2100 | 34 | 0 |
1602290 | 1602290 | 2021-08-10 | Skagway Municipality | Alaska | 2230 | 34 | 0 |
1603929 | 1603929 | 2021-08-10 | Loup | Nebraska | 31115 | 34 | 0 |
1599042 | 1599042 | 2021-08-09 | Skagway Municipality | Alaska | 2230 | 34 | 0 |
1600680 | 1600680 | 2021-08-09 | Loup | Nebraska | 31115 | 34 | 0 |
1595793 | 1595793 | 2021-08-08 | Skagway Municipality | Alaska | 2230 | 34 | 0 |
1595976 | 1595976 | 2021-08-08 | Hinsdale | Colorado | 8053 | 34 | 0 |
1597432 | 1597432 | 2021-08-08 | Loup | Nebraska | 31115 | 34 | 0 |
1592544 | 1592544 | 2021-08-07 | Skagway Municipality | Alaska | 2230 | 34 | 0 |
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);