ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
942 rows where cases = 217 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 90
- Texas 74
- Vermont 64
- Georgia 54
- Kentucky 43
- North Dakota 39
- Virginia 38
- Missouri 28
- Oregon 28
- Nebraska 27
- Michigan 26
- Illinois 25
- North Carolina 25
- Iowa 24
- Puerto Rico 23
- Minnesota 22
- Indiana 21
- Montana 20
- Arkansas 18
- Colorado 18
- Nevada 18
- Ohio 18
- South Dakota 17
- Tennessee 17
- New Mexico 16
- New York 15
- West Virginia 15
- Mississippi 13
- California 12
- Louisiana 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2221369 | 2221369 | 2022-02-16 | Judith Basin | Montana | 30045 | 217 | 1 |
2197250 | 2197250 | 2022-02-09 | Mineral | Colorado | 8079 | 217 | 1 |
2198596 | 2198596 | 2022-02-09 | Garfield | Montana | 30033 | 217 | 3 |
2193996 | 2193996 | 2022-02-08 | Mineral | Colorado | 8079 | 217 | 1 |
2195977 | 2195977 | 2022-02-08 | Wheeler | Oregon | 41069 | 217 | 3 |
2196460 | 2196460 | 2022-02-08 | Jeff Davis | Texas | 48243 | 217 | 8 |
2190742 | 2190742 | 2022-02-07 | Mineral | Colorado | 8079 | 217 | 1 |
2193206 | 2193206 | 2022-02-07 | Jeff Davis | Texas | 48243 | 217 | 8 |
2187489 | 2187489 | 2022-02-06 | Mineral | Colorado | 8079 | 217 | 1 |
2189952 | 2189952 | 2022-02-06 | Jeff Davis | Texas | 48243 | 217 | 8 |
2184236 | 2184236 | 2022-02-05 | Mineral | Colorado | 8079 | 217 | 1 |
2186699 | 2186699 | 2022-02-05 | Jeff Davis | Texas | 48243 | 217 | 8 |
2180984 | 2180984 | 2022-02-04 | Mineral | Colorado | 8079 | 217 | 1 |
2183447 | 2183447 | 2022-02-04 | Jeff Davis | Texas | 48243 | 217 | 8 |
2177733 | 2177733 | 2022-02-03 | Mineral | Colorado | 8079 | 217 | 1 |
2142179 | 2142179 | 2022-01-23 | Taliaferro | Georgia | 13265 | 217 | 3 |
2138924 | 2138924 | 2022-01-22 | Taliaferro | Georgia | 13265 | 217 | 3 |
2135668 | 2135668 | 2022-01-21 | Taliaferro | Georgia | 13265 | 217 | 3 |
2127042 | 2127042 | 2022-01-18 | Prairie | Montana | 30079 | 217 | 3 |
2104247 | 2104247 | 2022-01-11 | Carter | Montana | 30011 | 217 | 5 |
2105149 | 2105149 | 2022-01-11 | Sully | South Dakota | 46119 | 217 | 3 |
2100996 | 2100996 | 2022-01-10 | Carter | Montana | 30011 | 217 | 5 |
2097745 | 2097745 | 2022-01-09 | Carter | Montana | 30011 | 217 | 5 |
2098598 | 2098598 | 2022-01-09 | Campbell | South Dakota | 46021 | 217 | 6 |
2098966 | 2098966 | 2022-01-09 | Sterling | Texas | 48431 | 217 | 5 |
2094493 | 2094493 | 2022-01-08 | Carter | Montana | 30011 | 217 | 5 |
2095346 | 2095346 | 2022-01-08 | Campbell | South Dakota | 46021 | 217 | 6 |
2091241 | 2091241 | 2022-01-07 | Carter | Montana | 30011 | 217 | 5 |
2092094 | 2092094 | 2022-01-07 | Campbell | South Dakota | 46021 | 217 | 6 |
2092368 | 2092368 | 2022-01-07 | Jeff Davis | Texas | 48243 | 217 | 6 |
2087990 | 2087990 | 2022-01-06 | Carter | Montana | 30011 | 217 | 5 |
2088842 | 2088842 | 2022-01-06 | Campbell | South Dakota | 46021 | 217 | 6 |
2084738 | 2084738 | 2022-01-05 | Carter | Montana | 30011 | 217 | 5 |
2081486 | 2081486 | 2022-01-04 | Carter | Montana | 30011 | 217 | 5 |
2078234 | 2078234 | 2022-01-03 | Carter | Montana | 30011 | 217 | 5 |
2012555 | 2012555 | 2021-12-14 | Lane | Kansas | 20101 | 217 | 9 |
2009304 | 2009304 | 2021-12-13 | Lane | Kansas | 20101 | 217 | 9 |
1996301 | 1996301 | 2021-12-09 | Lane | Kansas | 20101 | 217 | 8 |
1993050 | 1993050 | 2021-12-08 | Lane | Kansas | 20101 | 217 | 8 |
1981149 | 1981149 | 2021-12-04 | Sheridan | North Dakota | 38083 | 217 | 4 |
1977899 | 1977899 | 2021-12-03 | Sheridan | North Dakota | 38083 | 217 | 4 |
1975099 | 1975099 | 2021-12-02 | Hyde | South Dakota | 46069 | 217 | 5 |
1966195 | 1966195 | 2021-11-30 | Wrangell City and Borough | Alaska | 2275 | 217 | 1 |
1959832 | 1959832 | 2021-11-28 | Sierra | California | 6091 | 217 | 0 |
1956581 | 1956581 | 2021-11-27 | Sierra | California | 6091 | 217 | 0 |
1953330 | 1953330 | 2021-11-26 | Sierra | California | 6091 | 217 | 0 |
1950079 | 1950079 | 2021-11-25 | Sierra | California | 6091 | 217 | 0 |
1946828 | 1946828 | 2021-11-24 | Sierra | California | 6091 | 217 | 0 |
1927347 | 1927347 | 2021-11-18 | Cheyenne | Colorado | 8017 | 217 | 7 |
1922632 | 1922632 | 2021-11-16 | Oliver | North Dakota | 38065 | 217 | 3 |
1906124 | 1906124 | 2021-11-11 | Storey | Nevada | 32029 | 217 | 5 |
1902791 | 1902791 | 2021-11-10 | Deuel | Nebraska | 31049 | 217 | 2 |
1902875 | 1902875 | 2021-11-10 | Storey | Nevada | 32029 | 217 | 5 |
1899625 | 1899625 | 2021-11-09 | Storey | Nevada | 32029 | 217 | 5 |
1896375 | 1896375 | 2021-11-08 | Storey | Nevada | 32029 | 217 | 5 |
1893117 | 1893117 | 2021-11-07 | Eureka | Nevada | 32011 | 217 | 1 |
1893125 | 1893125 | 2021-11-07 | Storey | Nevada | 32029 | 217 | 5 |
1889867 | 1889867 | 2021-11-06 | Eureka | Nevada | 32011 | 217 | 1 |
1889875 | 1889875 | 2021-11-06 | Storey | Nevada | 32029 | 217 | 5 |
1886617 | 1886617 | 2021-11-05 | Eureka | Nevada | 32011 | 217 | 1 |
1886625 | 1886625 | 2021-11-05 | Storey | Nevada | 32029 | 217 | 5 |
1883368 | 1883368 | 2021-11-04 | Eureka | Nevada | 32011 | 217 | 1 |
1883376 | 1883376 | 2021-11-04 | Storey | Nevada | 32029 | 217 | 5 |
1880119 | 1880119 | 2021-11-03 | Eureka | Nevada | 32011 | 217 | 1 |
1880127 | 1880127 | 2021-11-03 | Storey | Nevada | 32029 | 217 | 5 |
1876870 | 1876870 | 2021-11-02 | Eureka | Nevada | 32011 | 217 | 1 |
1829202 | 1829202 | 2021-10-18 | Stonewall | Texas | 48433 | 217 | 6 |
1825953 | 1825953 | 2021-10-17 | Stonewall | Texas | 48433 | 217 | 6 |
1822704 | 1822704 | 2021-10-16 | Stonewall | Texas | 48433 | 217 | 6 |
1783550 | 1783550 | 2021-10-04 | Cottle | Texas | 48101 | 217 | 9 |
1778910 | 1778910 | 2021-10-03 | Keweenaw | Michigan | 26083 | 217 | 4 |
1780301 | 1780301 | 2021-10-03 | Cottle | Texas | 48101 | 217 | 9 |
1775660 | 1775660 | 2021-10-02 | Keweenaw | Michigan | 26083 | 217 | 4 |
1777051 | 1777051 | 2021-10-02 | Cottle | Texas | 48101 | 217 | 9 |
1772410 | 1772410 | 2021-10-01 | Keweenaw | Michigan | 26083 | 217 | 4 |
1773801 | 1773801 | 2021-10-01 | Cottle | Texas | 48101 | 217 | 9 |
1770551 | 1770551 | 2021-09-30 | Cottle | Texas | 48101 | 217 | 9 |
1762721 | 1762721 | 2021-09-28 | Cook | Minnesota | 27031 | 217 | 0 |
1759836 | 1759836 | 2021-09-27 | Gosper | Nebraska | 31073 | 217 | 5 |
1756588 | 1756588 | 2021-09-26 | Gosper | Nebraska | 31073 | 217 | 5 |
1753340 | 1753340 | 2021-09-25 | Gosper | Nebraska | 31073 | 217 | 5 |
1750092 | 1750092 | 2021-09-24 | Gosper | Nebraska | 31073 | 217 | 5 |
1746813 | 1746813 | 2021-09-23 | Boyd | Nebraska | 31015 | 217 | 3 |
1746842 | 1746842 | 2021-09-23 | Gosper | Nebraska | 31073 | 217 | 5 |
1743593 | 1743593 | 2021-09-22 | Gosper | Nebraska | 31073 | 217 | 5 |
1743937 | 1743937 | 2021-09-22 | Steele | North Dakota | 38091 | 217 | 2 |
1740458 | 1740458 | 2021-09-21 | De Baca | New Mexico | 35011 | 217 | 3 |
1737209 | 1737209 | 2021-09-20 | De Baca | New Mexico | 35011 | 217 | 3 |
1733959 | 1733959 | 2021-09-19 | De Baca | New Mexico | 35011 | 217 | 3 |
1730709 | 1730709 | 2021-09-18 | De Baca | New Mexico | 35011 | 217 | 3 |
1727459 | 1727459 | 2021-09-17 | De Baca | New Mexico | 35011 | 217 | 3 |
1724210 | 1724210 | 2021-09-16 | De Baca | New Mexico | 35011 | 217 | 3 |
1720961 | 1720961 | 2021-09-15 | De Baca | New Mexico | 35011 | 217 | 3 |
1717713 | 1717713 | 2021-09-14 | De Baca | New Mexico | 35011 | 217 | 3 |
1713189 | 1713189 | 2021-09-13 | Webster | Georgia | 13307 | 217 | 4 |
1714465 | 1714465 | 2021-09-13 | De Baca | New Mexico | 35011 | 217 | 3 |
1678742 | 1678742 | 2021-09-02 | Mora | New Mexico | 35033 | 217 | 8 |
1675494 | 1675494 | 2021-09-01 | Mora | New Mexico | 35033 | 217 | 8 |
1672246 | 1672246 | 2021-08-31 | Mora | New Mexico | 35033 | 217 | 8 |
1646454 | 1646454 | 2021-08-23 | Grant | North Dakota | 38037 | 217 | 7 |
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);