ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,895 rows where cases = 24 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 310
- Nebraska 275
- Kansas 154
- Kentucky 148
- South Dakota 147
- Iowa 137
- Illinois 130
- Virginia 129
- Georgia 127
- Missouri 126
- Michigan 125
- Tennessee 123
- Oklahoma 121
- North Dakota 105
- Alaska 104
- Indiana 102
- Colorado 98
- Ohio 98
- Minnesota 95
- Puerto Rico 87
- Wisconsin 86
- North Carolina 82
- Oregon 80
- Arkansas 68
- Montana 62
- Wyoming 62
- West Virginia 60
- Mississippi 55
- New Mexico 53
- Pennsylvania 52
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426523 | 2426523 | 2022-04-20 | Unknown | New Mexico | 24 | 0 | |
2257555 | 2257555 | 2022-02-27 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2254304 | 2254304 | 2022-02-26 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2251053 | 2251053 | 2022-02-25 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2247802 | 2247802 | 2022-02-24 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2244551 | 2244551 | 2022-02-23 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2241300 | 2241300 | 2022-02-22 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2238049 | 2238049 | 2022-02-21 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2234798 | 2234798 | 2022-02-20 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2231547 | 2231547 | 2022-02-19 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2228296 | 2228296 | 2022-02-18 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2225045 | 2225045 | 2022-02-17 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2221794 | 2221794 | 2022-02-16 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2218543 | 2218543 | 2022-02-15 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2214430 | 2214430 | 2022-02-14 | Unknown | Maine | 24 | 0 | |
2215292 | 2215292 | 2022-02-14 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2211178 | 2211178 | 2022-02-13 | Unknown | Maine | 24 | 0 | |
2212041 | 2212041 | 2022-02-13 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2207925 | 2207925 | 2022-02-12 | Unknown | Maine | 24 | 0 | |
2208788 | 2208788 | 2022-02-12 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2205535 | 2205535 | 2022-02-11 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2202282 | 2202282 | 2022-02-10 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2199028 | 2199028 | 2022-02-09 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2195774 | 2195774 | 2022-02-08 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2192520 | 2192520 | 2022-02-07 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2189266 | 2189266 | 2022-02-06 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2186013 | 2186013 | 2022-02-05 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2182761 | 2182761 | 2022-02-04 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2179509 | 2179509 | 2022-02-03 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2176258 | 2176258 | 2022-02-02 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2173005 | 2173005 | 2022-02-01 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
1988362 | 1988362 | 2021-12-06 | King | Texas | 48269 | 24 | 0 |
1985112 | 1985112 | 2021-12-05 | King | Texas | 48269 | 24 | 0 |
1981862 | 1981862 | 2021-12-04 | King | Texas | 48269 | 24 | 0 |
1971002 | 1971002 | 2021-12-01 | Petroleum | Montana | 30069 | 24 | 1 |
1967752 | 1967752 | 2021-11-30 | Petroleum | Montana | 30069 | 24 | 1 |
1831283 | 1831283 | 2021-10-19 | Arthur | Nebraska | 31005 | 24 | 1 |
1828034 | 1828034 | 2021-10-18 | Arthur | Nebraska | 31005 | 24 | 1 |
1824785 | 1824785 | 2021-10-17 | Arthur | Nebraska | 31005 | 24 | 1 |
1821536 | 1821536 | 2021-10-16 | Arthur | Nebraska | 31005 | 24 | 1 |
1818287 | 1818287 | 2021-10-15 | Arthur | Nebraska | 31005 | 24 | 1 |
1815038 | 1815038 | 2021-10-14 | Arthur | Nebraska | 31005 | 24 | 1 |
1811790 | 1811790 | 2021-10-13 | Arthur | Nebraska | 31005 | 24 | 1 |
1808541 | 1808541 | 2021-10-12 | Arthur | Nebraska | 31005 | 24 | 1 |
1805290 | 1805290 | 2021-10-11 | Arthur | Nebraska | 31005 | 24 | 1 |
1802041 | 1802041 | 2021-10-10 | Arthur | Nebraska | 31005 | 24 | 1 |
1798792 | 1798792 | 2021-10-09 | Arthur | Nebraska | 31005 | 24 | 1 |
1795543 | 1795543 | 2021-10-08 | Arthur | Nebraska | 31005 | 24 | 1 |
1792294 | 1792294 | 2021-10-07 | Arthur | Nebraska | 31005 | 24 | 1 |
1789045 | 1789045 | 2021-10-06 | Arthur | Nebraska | 31005 | 24 | 1 |
1785797 | 1785797 | 2021-10-05 | Arthur | Nebraska | 31005 | 24 | 1 |
1787044 | 1787044 | 2021-10-05 | Unknown | Vermont | 24 | 0 | |
1782548 | 1782548 | 2021-10-04 | Arthur | Nebraska | 31005 | 24 | 1 |
1779298 | 1779298 | 2021-10-03 | Arthur | Nebraska | 31005 | 24 | 1 |
1776048 | 1776048 | 2021-10-02 | Arthur | Nebraska | 31005 | 24 | 1 |
1772798 | 1772798 | 2021-10-01 | Arthur | Nebraska | 31005 | 24 | 1 |
1769549 | 1769549 | 2021-09-30 | Arthur | Nebraska | 31005 | 24 | 1 |
1766300 | 1766300 | 2021-09-29 | Arthur | Nebraska | 31005 | 24 | 1 |
1763051 | 1763051 | 2021-09-28 | Arthur | Nebraska | 31005 | 24 | 1 |
1759802 | 1759802 | 2021-09-27 | Arthur | Nebraska | 31005 | 24 | 1 |
1756554 | 1756554 | 2021-09-26 | Arthur | Nebraska | 31005 | 24 | 1 |
1753306 | 1753306 | 2021-09-25 | Arthur | Nebraska | 31005 | 24 | 1 |
1750058 | 1750058 | 2021-09-24 | Arthur | Nebraska | 31005 | 24 | 1 |
1746808 | 1746808 | 2021-09-23 | Arthur | Nebraska | 31005 | 24 | 1 |
1743559 | 1743559 | 2021-09-22 | Arthur | Nebraska | 31005 | 24 | 1 |
1733338 | 1733338 | 2021-09-19 | Unknown | Maine | 24 | 0 | |
1733811 | 1733811 | 2021-09-19 | Arthur | Nebraska | 31005 | 24 | 1 |
1730561 | 1730561 | 2021-09-18 | Arthur | Nebraska | 31005 | 24 | 1 |
1727311 | 1727311 | 2021-09-17 | Arthur | Nebraska | 31005 | 24 | 1 |
1724062 | 1724062 | 2021-09-16 | Arthur | Nebraska | 31005 | 24 | 1 |
1720813 | 1720813 | 2021-09-15 | Arthur | Nebraska | 31005 | 24 | 1 |
1717565 | 1717565 | 2021-09-14 | Arthur | Nebraska | 31005 | 24 | 1 |
1714317 | 1714317 | 2021-09-13 | Arthur | Nebraska | 31005 | 24 | 1 |
1711071 | 1711071 | 2021-09-12 | Arthur | Nebraska | 31005 | 24 | 1 |
1707824 | 1707824 | 2021-09-11 | Arthur | Nebraska | 31005 | 24 | 1 |
1704577 | 1704577 | 2021-09-10 | Arthur | Nebraska | 31005 | 24 | 1 |
1701327 | 1701327 | 2021-09-09 | Arthur | Nebraska | 31005 | 24 | 1 |
1698078 | 1698078 | 2021-09-08 | Arthur | Nebraska | 31005 | 24 | 1 |
1694830 | 1694830 | 2021-09-07 | Arthur | Nebraska | 31005 | 24 | 1 |
1691581 | 1691581 | 2021-09-06 | Arthur | Nebraska | 31005 | 24 | 1 |
1688331 | 1688331 | 2021-09-05 | Arthur | Nebraska | 31005 | 24 | 1 |
1685081 | 1685081 | 2021-09-04 | Arthur | Nebraska | 31005 | 24 | 1 |
1681830 | 1681830 | 2021-09-03 | Arthur | Nebraska | 31005 | 24 | 1 |
1678582 | 1678582 | 2021-09-02 | Arthur | Nebraska | 31005 | 24 | 1 |
1675334 | 1675334 | 2021-09-01 | Arthur | Nebraska | 31005 | 24 | 1 |
1672086 | 1672086 | 2021-08-31 | Arthur | Nebraska | 31005 | 24 | 1 |
1668839 | 1668839 | 2021-08-30 | Arthur | Nebraska | 31005 | 24 | 1 |
1665592 | 1665592 | 2021-08-29 | Arthur | Nebraska | 31005 | 24 | 1 |
1662344 | 1662344 | 2021-08-28 | Arthur | Nebraska | 31005 | 24 | 1 |
1659096 | 1659096 | 2021-08-27 | Arthur | Nebraska | 31005 | 24 | 1 |
1655847 | 1655847 | 2021-08-26 | Arthur | Nebraska | 31005 | 24 | 1 |
1652600 | 1652600 | 2021-08-25 | Arthur | Nebraska | 31005 | 24 | 1 |
1649352 | 1649352 | 2021-08-24 | Arthur | Nebraska | 31005 | 24 | 1 |
1646103 | 1646103 | 2021-08-23 | Arthur | Nebraska | 31005 | 24 | 1 |
1642854 | 1642854 | 2021-08-22 | Arthur | Nebraska | 31005 | 24 | 1 |
1639604 | 1639604 | 2021-08-21 | Arthur | Nebraska | 31005 | 24 | 1 |
1636354 | 1636354 | 2021-08-20 | Arthur | Nebraska | 31005 | 24 | 1 |
1633104 | 1633104 | 2021-08-19 | Arthur | Nebraska | 31005 | 24 | 1 |
1629857 | 1629857 | 2021-08-18 | Arthur | Nebraska | 31005 | 24 | 1 |
1626610 | 1626610 | 2021-08-17 | Arthur | Nebraska | 31005 | 24 | 1 |
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);