ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
592 rows where cases = 471 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 62
- North Dakota 47
- Colorado 33
- South Dakota 33
- Illinois 27
- Georgia 26
- Kentucky 26
- Virginia 23
- Kansas 22
- Puerto Rico 21
- Minnesota 20
- Missouri 20
- Indiana 19
- Michigan 17
- Nebraska 17
- Idaho 13
- Arkansas 11
- Iowa 11
- Tennessee 10
- North Carolina 9
- Wisconsin 9
- New York 8
- Ohio 8
- Oregon 8
- West Virginia 8
- Oklahoma 7
- Pennsylvania 7
- South Carolina 7
- Alabama 6
- California 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2278560 | 2278560 | 2022-03-06 | Sedgwick | Colorado | 8115 | 471 | 8 |
2275307 | 2275307 | 2022-03-05 | Sedgwick | Colorado | 8115 | 471 | 8 |
2272054 | 2272054 | 2022-03-04 | Sedgwick | Colorado | 8115 | 471 | 8 |
2268802 | 2268802 | 2022-03-03 | Sedgwick | Colorado | 8115 | 471 | 8 |
2265549 | 2265549 | 2022-03-02 | Sedgwick | Colorado | 8115 | 471 | 8 |
2262298 | 2262298 | 2022-03-01 | Sedgwick | Colorado | 8115 | 471 | 8 |
2259047 | 2259047 | 2022-02-28 | Sedgwick | Colorado | 8115 | 471 | 8 |
2255796 | 2255796 | 2022-02-27 | Sedgwick | Colorado | 8115 | 471 | 8 |
2257515 | 2257515 | 2022-02-27 | Golden Valley | North Dakota | 38033 | 471 | 4 |
2252545 | 2252545 | 2022-02-26 | Sedgwick | Colorado | 8115 | 471 | 8 |
2254264 | 2254264 | 2022-02-26 | Golden Valley | North Dakota | 38033 | 471 | 4 |
2249294 | 2249294 | 2022-02-25 | Sedgwick | Colorado | 8115 | 471 | 8 |
2251013 | 2251013 | 2022-02-25 | Golden Valley | North Dakota | 38033 | 471 | 4 |
2246043 | 2246043 | 2022-02-24 | Sedgwick | Colorado | 8115 | 471 | 8 |
2210547 | 2210547 | 2022-02-13 | Butte | Idaho | 16023 | 471 | 7 |
2207294 | 2207294 | 2022-02-12 | Butte | Idaho | 16023 | 471 | 7 |
2204041 | 2204041 | 2022-02-11 | Butte | Idaho | 16023 | 471 | 7 |
2196549 | 2196549 | 2022-02-08 | Sherman | Texas | 48421 | 471 | 16 |
2166462 | 2166462 | 2022-01-30 | Kidder | North Dakota | 38043 | 471 | 13 |
2163207 | 2163207 | 2022-01-29 | Kidder | North Dakota | 38043 | 471 | 13 |
2148741 | 2148741 | 2022-01-25 | Custer | Idaho | 16037 | 471 | 7 |
2146627 | 2146627 | 2022-01-24 | Hitchcock | Nebraska | 31087 | 471 | 6 |
2133633 | 2133633 | 2022-01-20 | Perkins | Nebraska | 31135 | 471 | 12 |
2095799 | 2095799 | 2022-01-08 | St. John | Virgin Islands | 78020 | 471 | 5 |
2092380 | 2092380 | 2022-01-07 | Kimble | Texas | 48267 | 471 | 11 |
2092547 | 2092547 | 2022-01-07 | St. John | Virgin Islands | 78020 | 471 | 5 |
2089295 | 2089295 | 2022-01-06 | St. John | Virgin Islands | 78020 | 471 | 5 |
2080811 | 2080811 | 2022-01-04 | Kiowa | Kansas | 20097 | 471 | 7 |
2077559 | 2077559 | 2022-01-03 | Kiowa | Kansas | 20097 | 471 | 7 |
2059581 | 2059581 | 2021-12-28 | Buffalo | South Dakota | 46017 | 471 | 16 |
2055915 | 2055915 | 2021-12-27 | Towner | North Dakota | 38095 | 471 | 11 |
2052665 | 2052665 | 2021-12-26 | Towner | North Dakota | 38095 | 471 | 11 |
2049415 | 2049415 | 2021-12-25 | Towner | North Dakota | 38095 | 471 | 11 |
1985861 | 1985861 | 2021-12-06 | Custer | Colorado | 8027 | 471 | 13 |
1975095 | 1975095 | 2021-12-02 | Hanson | South Dakota | 46061 | 471 | 5 |
1915045 | 1915045 | 2021-11-14 | Logan | Kansas | 20109 | 471 | 9 |
1911795 | 1911795 | 2021-11-13 | Logan | Kansas | 20109 | 471 | 9 |
1908546 | 1908546 | 2021-11-12 | Logan | Kansas | 20109 | 471 | 9 |
1898787 | 1898787 | 2021-11-09 | Jewell | Kansas | 20089 | 471 | 10 |
1895537 | 1895537 | 2021-11-08 | Jewell | Kansas | 20089 | 471 | 10 |
1878639 | 1878639 | 2021-11-03 | Ouray | Colorado | 8091 | 471 | 5 |
1854821 | 1854821 | 2021-10-26 | Bennett | South Dakota | 46007 | 471 | 9 |
1837474 | 1837474 | 2021-10-21 | Lake of the Woods | Minnesota | 27077 | 471 | 4 |
1829274 | 1829274 | 2021-10-18 | Essex | Vermont | 50009 | 471 | 2 |
1811879 | 1811879 | 2021-10-13 | Webster | Nebraska | 31181 | 471 | 8 |
1794429 | 1794429 | 2021-10-08 | Adams | Idaho | 16003 | 471 | 8 |
1791528 | 1791528 | 2021-10-07 | Chautauqua | Kansas | 20019 | 471 | 8 |
1791616 | 1791616 | 2021-10-07 | Trego | Kansas | 20195 | 471 | 8 |
1788279 | 1788279 | 2021-10-06 | Chautauqua | Kansas | 20019 | 471 | 8 |
1788367 | 1788367 | 2021-10-06 | Trego | Kansas | 20195 | 471 | 8 |
1784717 | 1784717 | 2021-10-05 | Oneida | Idaho | 16071 | 471 | 6 |
1785118 | 1785118 | 2021-10-05 | Trego | Kansas | 20195 | 471 | 8 |
1781869 | 1781869 | 2021-10-04 | Trego | Kansas | 20195 | 471 | 8 |
1777918 | 1777918 | 2021-10-03 | Phillips | Colorado | 8095 | 471 | 14 |
1774668 | 1774668 | 2021-10-02 | Phillips | Colorado | 8095 | 471 | 14 |
1771418 | 1771418 | 2021-10-01 | Phillips | Colorado | 8095 | 471 | 14 |
1768169 | 1768169 | 2021-09-30 | Phillips | Colorado | 8095 | 471 | 14 |
1764920 | 1764920 | 2021-09-29 | Phillips | Colorado | 8095 | 471 | 14 |
1767583 | 1767583 | 2021-09-29 | Craig | Virginia | 51045 | 471 | 6 |
1762342 | 1762342 | 2021-09-28 | Ness | Kansas | 20135 | 471 | 17 |
1759094 | 1759094 | 2021-09-27 | Ness | Kansas | 20135 | 471 | 17 |
1746795 | 1746795 | 2021-09-23 | Sheridan | Montana | 30091 | 471 | 5 |
1723066 | 1723066 | 2021-09-16 | Pope | Illinois | 17151 | 471 | 5 |
1707702 | 1707702 | 2021-09-11 | Knox | Missouri | 29103 | 471 | 3 |
1704455 | 1704455 | 2021-09-10 | Knox | Missouri | 29103 | 471 | 3 |
1705593 | 1705593 | 2021-09-10 | Donley | Texas | 48129 | 471 | 16 |
1701205 | 1701205 | 2021-09-09 | Knox | Missouri | 29103 | 471 | 3 |
1697956 | 1697956 | 2021-09-08 | Knox | Missouri | 29103 | 471 | 3 |
1698879 | 1698879 | 2021-09-08 | Clark | South Dakota | 46025 | 471 | 5 |
1695631 | 1695631 | 2021-09-07 | Clark | South Dakota | 46025 | 471 | 5 |
1695938 | 1695938 | 2021-09-07 | Mason | Texas | 48319 | 471 | 6 |
1692383 | 1692383 | 2021-09-06 | Clark | South Dakota | 46025 | 471 | 5 |
1689134 | 1689134 | 2021-09-05 | Clark | South Dakota | 46025 | 471 | 5 |
1685884 | 1685884 | 2021-09-04 | Clark | South Dakota | 46025 | 471 | 5 |
1682633 | 1682633 | 2021-09-03 | Clark | South Dakota | 46025 | 471 | 5 |
1679383 | 1679383 | 2021-09-02 | Clark | South Dakota | 46025 | 471 | 5 |
1676135 | 1676135 | 2021-09-01 | Clark | South Dakota | 46025 | 471 | 5 |
1672888 | 1672888 | 2021-08-31 | Clark | South Dakota | 46025 | 471 | 5 |
1670159 | 1670159 | 2021-08-30 | King and Queen | Virginia | 51097 | 471 | 7 |
1646449 | 1646449 | 2021-08-23 | Eddy | North Dakota | 38027 | 471 | 6 |
1643200 | 1643200 | 2021-08-22 | Eddy | North Dakota | 38027 | 471 | 6 |
1639950 | 1639950 | 2021-08-21 | Eddy | North Dakota | 38027 | 471 | 6 |
1636700 | 1636700 | 2021-08-20 | Eddy | North Dakota | 38027 | 471 | 6 |
1621965 | 1621965 | 2021-08-16 | Huerfano | Colorado | 8055 | 471 | 18 |
1572052 | 1572052 | 2021-07-31 | Arroyo | Puerto Rico | 72015 | 471 | |
1561468 | 1561468 | 2021-07-28 | Atchison | Missouri | 29005 | 471 | 6 |
1546398 | 1546398 | 2021-07-23 | Coke | Texas | 48081 | 471 | 13 |
1528052 | 1528052 | 2021-07-18 | Kauai | Hawaii | 15007 | 471 | 2 |
1528127 | 1528127 | 2021-07-18 | Gallatin | Illinois | 17059 | 471 | 5 |
1524880 | 1524880 | 2021-07-17 | Gallatin | Illinois | 17059 | 471 | 5 |
1521632 | 1521632 | 2021-07-16 | Gallatin | Illinois | 17059 | 471 | 5 |
1517962 | 1517962 | 2021-07-15 | Mariposa | California | 6043 | 471 | 7 |
1518384 | 1518384 | 2021-07-15 | Gallatin | Illinois | 17059 | 471 | 5 |
1515137 | 1515137 | 2021-07-14 | Gallatin | Illinois | 17059 | 471 | 5 |
1511891 | 1511891 | 2021-07-13 | Gallatin | Illinois | 17059 | 471 | 5 |
1505398 | 1505398 | 2021-07-11 | Gallatin | Illinois | 17059 | 471 | 5 |
1507653 | 1507653 | 2021-07-11 | Garfield | Utah | 49017 | 471 | 10 |
1502152 | 1502152 | 2021-07-10 | Gallatin | Illinois | 17059 | 471 | 5 |
1504407 | 1504407 | 2021-07-10 | Garfield | Utah | 49017 | 471 | 10 |
1498906 | 1498906 | 2021-07-09 | Gallatin | Illinois | 17059 | 471 | 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);