ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,651 rows where cases = 85 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 206
- Alaska 101
- Mississippi 62
- Missouri 61
- Iowa 60
- Kentucky 58
- Kansas 56
- Minnesota 56
- Virginia 56
- Georgia 55
- Colorado 48
- South Dakota 47
- Montana 43
- Nebraska 43
- Indiana 41
- Puerto Rico 41
- Michigan 37
- Pennsylvania 36
- Oklahoma 35
- New Mexico 34
- Idaho 33
- Ohio 32
- Illinois 28
- New York 27
- Wisconsin 27
- Arkansas 26
- Tennessee 26
- Oregon 23
- Alabama 22
- North Carolina 21
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501405 | 2501405 | 2022-05-13 | Harding | New Mexico | 35021 | 85 | 4 |
2498147 | 2498147 | 2022-05-12 | Harding | New Mexico | 35021 | 85 | 4 |
2494889 | 2494889 | 2022-05-11 | Harding | New Mexico | 35021 | 85 | 4 |
2491631 | 2491631 | 2022-05-10 | Harding | New Mexico | 35021 | 85 | 4 |
2488373 | 2488373 | 2022-05-09 | Harding | New Mexico | 35021 | 85 | 4 |
2485116 | 2485116 | 2022-05-08 | Harding | New Mexico | 35021 | 85 | 4 |
2481858 | 2481858 | 2022-05-07 | Harding | New Mexico | 35021 | 85 | 4 |
2478600 | 2478600 | 2022-05-06 | Harding | New Mexico | 35021 | 85 | 4 |
2475342 | 2475342 | 2022-05-05 | Harding | New Mexico | 35021 | 85 | 4 |
2472085 | 2472085 | 2022-05-04 | Harding | New Mexico | 35021 | 85 | 4 |
2473017 | 2473017 | 2022-05-04 | Kenedy | Texas | 48261 | 85 | 2 |
2468829 | 2468829 | 2022-05-03 | Harding | New Mexico | 35021 | 85 | 4 |
2469761 | 2469761 | 2022-05-03 | Kenedy | Texas | 48261 | 85 | 2 |
2465573 | 2465573 | 2022-05-02 | Harding | New Mexico | 35021 | 85 | 4 |
2466505 | 2466505 | 2022-05-02 | Kenedy | Texas | 48261 | 85 | 2 |
2462318 | 2462318 | 2022-05-01 | Harding | New Mexico | 35021 | 85 | 4 |
2463250 | 2463250 | 2022-05-01 | Kenedy | Texas | 48261 | 85 | 2 |
2459062 | 2459062 | 2022-04-30 | Harding | New Mexico | 35021 | 85 | 4 |
2459994 | 2459994 | 2022-04-30 | Kenedy | Texas | 48261 | 85 | 2 |
2455806 | 2455806 | 2022-04-29 | Harding | New Mexico | 35021 | 85 | 4 |
2456738 | 2456738 | 2022-04-29 | Kenedy | Texas | 48261 | 85 | 2 |
2452550 | 2452550 | 2022-04-28 | Harding | New Mexico | 35021 | 85 | 4 |
2453482 | 2453482 | 2022-04-28 | Kenedy | Texas | 48261 | 85 | 2 |
2450226 | 2450226 | 2022-04-27 | Kenedy | Texas | 48261 | 85 | 2 |
2446969 | 2446969 | 2022-04-26 | Kenedy | Texas | 48261 | 85 | 2 |
2443714 | 2443714 | 2022-04-25 | Kenedy | Texas | 48261 | 85 | 2 |
2440458 | 2440458 | 2022-04-24 | Kenedy | Texas | 48261 | 85 | 2 |
2437202 | 2437202 | 2022-04-23 | Kenedy | Texas | 48261 | 85 | 2 |
2433946 | 2433946 | 2022-04-22 | Kenedy | Texas | 48261 | 85 | 2 |
2430690 | 2430690 | 2022-04-21 | Kenedy | Texas | 48261 | 85 | 2 |
2427434 | 2427434 | 2022-04-20 | Kenedy | Texas | 48261 | 85 | 2 |
2424178 | 2424178 | 2022-04-19 | Kenedy | Texas | 48261 | 85 | 2 |
2258839 | 2258839 | 2022-02-28 | Unknown | American Samoa | 85 | 0 | |
2195558 | 2195558 | 2022-02-08 | Unknown | New Mexico | 85 | 0 | |
2166162 | 2166162 | 2022-01-30 | Loup | Nebraska | 31115 | 85 | 0 |
2166204 | 2166204 | 2022-01-30 | Esmeralda | Nevada | 32009 | 85 | 2 |
2162907 | 2162907 | 2022-01-29 | Loup | Nebraska | 31115 | 85 | 0 |
2162949 | 2162949 | 2022-01-29 | Esmeralda | Nevada | 32009 | 85 | 2 |
2159652 | 2159652 | 2022-01-28 | Loup | Nebraska | 31115 | 85 | 0 |
2159694 | 2159694 | 2022-01-28 | Esmeralda | Nevada | 32009 | 85 | 2 |
2156398 | 2156398 | 2022-01-27 | Loup | Nebraska | 31115 | 85 | 0 |
2156440 | 2156440 | 2022-01-27 | Esmeralda | Nevada | 32009 | 85 | 2 |
2144436 | 2144436 | 2022-01-23 | Loving | Texas | 48301 | 85 | 0 |
2128031 | 2128031 | 2022-01-18 | Borden | Texas | 48033 | 85 | 2 |
2084874 | 2084874 | 2022-01-05 | Thomas | Nebraska | 31171 | 85 | 1 |
1969441 | 1969441 | 2021-12-01 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1966191 | 1966191 | 2021-11-30 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1962939 | 1962939 | 2021-11-29 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1959688 | 1959688 | 2021-11-28 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1956437 | 1956437 | 2021-11-27 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1953186 | 1953186 | 2021-11-26 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1949935 | 1949935 | 2021-11-25 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1946684 | 1946684 | 2021-11-24 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1943433 | 1943433 | 2021-11-23 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1940183 | 1940183 | 2021-11-22 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1936933 | 1936933 | 2021-11-21 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1933683 | 1933683 | 2021-11-20 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1930431 | 1930431 | 2021-11-19 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1927181 | 1927181 | 2021-11-18 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1914668 | 1914668 | 2021-11-14 | Clark | Idaho | 16033 | 85 | 0 |
1911418 | 1911418 | 2021-11-13 | Clark | Idaho | 16033 | 85 | 0 |
1908169 | 1908169 | 2021-11-12 | Clark | Idaho | 16033 | 85 | 0 |
1904920 | 1904920 | 2021-11-11 | Clark | Idaho | 16033 | 85 | 0 |
1901670 | 1901670 | 2021-11-10 | Clark | Idaho | 16033 | 85 | 0 |
1898420 | 1898420 | 2021-11-09 | Clark | Idaho | 16033 | 85 | 0 |
1895170 | 1895170 | 2021-11-08 | Clark | Idaho | 16033 | 85 | 0 |
1891920 | 1891920 | 2021-11-07 | Clark | Idaho | 16033 | 85 | 0 |
1888670 | 1888670 | 2021-11-06 | Clark | Idaho | 16033 | 85 | 0 |
1885420 | 1885420 | 2021-11-05 | Clark | Idaho | 16033 | 85 | 0 |
1881685 | 1881685 | 2021-11-04 | Skagway Municipality | Alaska | 2230 | 85 | 0 |
1882171 | 1882171 | 2021-11-04 | Clark | Idaho | 16033 | 85 | 0 |
1884517 | 1884517 | 2021-11-04 | Unknown | Vermont | 85 | 0 | |
1850773 | 1850773 | 2021-10-25 | Treasure | Montana | 30103 | 85 | 1 |
1795879 | 1795879 | 2021-10-08 | Billings | North Dakota | 38007 | 85 | 0 |
1758404 | 1758404 | 2021-09-27 | Jackson | Colorado | 8057 | 85 | 0 |
1741458 | 1741458 | 2021-09-21 | Roberts | Texas | 48393 | 85 | 1 |
1741520 | 1741520 | 2021-09-21 | Daggett | Utah | 49009 | 85 | 0 |
1738209 | 1738209 | 2021-09-20 | Roberts | Texas | 48393 | 85 | 1 |
1734959 | 1734959 | 2021-09-19 | Roberts | Texas | 48393 | 85 | 1 |
1731709 | 1731709 | 2021-09-18 | Roberts | Texas | 48393 | 85 | 1 |
1728459 | 1728459 | 2021-09-17 | Roberts | Texas | 48393 | 85 | 1 |
1698176 | 1698176 | 2021-09-08 | Eureka | Nevada | 32011 | 85 | 0 |
1686256 | 1686256 | 2021-09-04 | Terrell | Texas | 48443 | 85 | 3 |
1683005 | 1683005 | 2021-09-03 | Terrell | Texas | 48443 | 85 | 3 |
1654477 | 1654477 | 2021-08-26 | San Juan | Colorado | 8111 | 85 | 0 |
1651230 | 1651230 | 2021-08-25 | San Juan | Colorado | 8111 | 85 | 0 |
1647981 | 1647981 | 2021-08-24 | San Juan | Colorado | 8111 | 85 | 0 |
1644733 | 1644733 | 2021-08-23 | San Juan | Colorado | 8111 | 85 | 0 |
1579689 | 1579689 | 2021-08-03 | Sierra | California | 6091 | 85 | 0 |
1576303 | 1576303 | 2021-08-02 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 85 | 2 |
1576441 | 1576441 | 2021-08-02 | Sierra | California | 6091 | 85 | 0 |
1573055 | 1573055 | 2021-08-01 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 85 | 2 |
1569807 | 1569807 | 2021-07-31 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 85 | 2 |
1566559 | 1566559 | 2021-07-30 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 85 | 2 |
1562208 | 1562208 | 2021-07-28 | Gilliam | Oregon | 41021 | 85 | 1 |
1558960 | 1558960 | 2021-07-27 | Gilliam | Oregon | 41021 | 85 | 1 |
1543272 | 1543272 | 2021-07-22 | McMullen | Texas | 48311 | 85 | 5 |
1540024 | 1540024 | 2021-07-21 | McMullen | Texas | 48311 | 85 | 5 |
1536777 | 1536777 | 2021-07-20 | McMullen | Texas | 48311 | 85 | 5 |
1533529 | 1533529 | 2021-07-19 | McMullen | Texas | 48311 | 85 | 5 |
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);