ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
520 rows where cases = 835 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 30
- Oklahoma 29
- Texas 28
- Minnesota 26
- Colorado 24
- Virginia 19
- Illinois 18
- Montana 18
- South Dakota 17
- Kansas 16
- Michigan 16
- Wisconsin 16
- Nebraska 15
- Puerto Rico 15
- Idaho 14
- Florida 13
- Missouri 13
- North Carolina 13
- Indiana 12
- Kentucky 12
- Arkansas 11
- Mississippi 11
- Virgin Islands 11
- Iowa 10
- South Carolina 10
- West Virginia 10
- Louisiana 9
- North Dakota 9
- Ohio 9
- Vermont 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2262901 | 2262901 | 2022-03-01 | Chautauqua | Kansas | 20019 | 835 | 17 |
2259650 | 2259650 | 2022-02-28 | Chautauqua | Kansas | 20019 | 835 | 17 |
2246031 | 2246031 | 2022-02-24 | Ouray | Colorado | 8091 | 835 | 6 |
2242780 | 2242780 | 2022-02-23 | Ouray | Colorado | 8091 | 835 | 6 |
2235580 | 2235580 | 2022-02-20 | Sutton | Texas | 48435 | 835 | 12 |
2232329 | 2232329 | 2022-02-19 | Sutton | Texas | 48435 | 835 | 12 |
2219299 | 2219299 | 2022-02-15 | Reagan | Texas | 48383 | 835 | 14 |
2196651 | 2196651 | 2022-02-08 | Bath | Virginia | 51017 | 835 | 17 |
2177113 | 2177113 | 2022-02-02 | Grand Isle | Vermont | 50013 | 835 | 4 |
2147399 | 2147399 | 2022-01-24 | Edmunds | South Dakota | 46045 | 835 | 15 |
2115953 | 2115953 | 2022-01-15 | Unknown | Delaware | 835 | 0 | |
2115122 | 2115122 | 2022-01-14 | Hudspeth | Texas | 48229 | 835 | 15 |
2106514 | 2106514 | 2022-01-12 | Hardin | Illinois | 17069 | 835 | 18 |
2105675 | 2105675 | 2022-01-11 | Surry | Virginia | 51181 | 835 | 13 |
2100601 | 2100601 | 2022-01-10 | Unknown | Maryland | 835 | 282 | |
2099119 | 2099119 | 2022-01-09 | King and Queen | Virginia | 51097 | 835 | 9 |
2095868 | 2095868 | 2022-01-08 | King and Queen | Virginia | 51097 | 835 | 9 |
2092616 | 2092616 | 2022-01-07 | King and Queen | Virginia | 51097 | 835 | 9 |
2079292 | 2079292 | 2022-01-03 | Crockett | Texas | 48105 | 835 | 17 |
2050912 | 2050912 | 2021-12-26 | Saguache | Colorado | 8109 | 835 | 9 |
2051177 | 2051177 | 2021-12-26 | Boise | Idaho | 16015 | 835 | 11 |
2047662 | 2047662 | 2021-12-25 | Saguache | Colorado | 8109 | 835 | 9 |
2047927 | 2047927 | 2021-12-25 | Boise | Idaho | 16015 | 835 | 11 |
2044412 | 2044412 | 2021-12-24 | Saguache | Colorado | 8109 | 835 | 9 |
2044677 | 2044677 | 2021-12-24 | Boise | Idaho | 16015 | 835 | 11 |
2041163 | 2041163 | 2021-12-23 | Saguache | Colorado | 8109 | 835 | 9 |
2041428 | 2041428 | 2021-12-23 | Boise | Idaho | 16015 | 835 | 11 |
2037913 | 2037913 | 2021-12-22 | Saguache | Colorado | 8109 | 835 | 9 |
2039289 | 2039289 | 2021-12-22 | Boone | Nebraska | 31011 | 835 | 4 |
2032764 | 2032764 | 2021-12-20 | Pondera | Montana | 30073 | 835 | 6 |
2033602 | 2033602 | 2021-12-20 | Gregory | South Dakota | 46053 | 835 | 31 |
2029224 | 2029224 | 2021-12-19 | Kittson | Minnesota | 27069 | 835 | 23 |
2029513 | 2029513 | 2021-12-19 | Pondera | Montana | 30073 | 835 | 6 |
2030352 | 2030352 | 2021-12-19 | Gregory | South Dakota | 46053 | 835 | 31 |
2025973 | 2025973 | 2021-12-18 | Kittson | Minnesota | 27069 | 835 | 23 |
2026262 | 2026262 | 2021-12-18 | Pondera | Montana | 30073 | 835 | 6 |
2027101 | 2027101 | 2021-12-18 | Gregory | South Dakota | 46053 | 835 | 31 |
2027479 | 2027479 | 2021-12-18 | Wheeler | Texas | 48483 | 835 | 15 |
2022722 | 2022722 | 2021-12-17 | Kittson | Minnesota | 27069 | 835 | 23 |
2023011 | 2023011 | 2021-12-17 | Pondera | Montana | 30073 | 835 | 6 |
2023850 | 2023850 | 2021-12-17 | Gregory | South Dakota | 46053 | 835 | 31 |
2019760 | 2019760 | 2021-12-16 | Pondera | Montana | 30073 | 835 | 6 |
2020599 | 2020599 | 2021-12-16 | Gregory | South Dakota | 46053 | 835 | 31 |
2021024 | 2021024 | 2021-12-16 | Essex | Vermont | 50009 | 835 | 2 |
2015462 | 2015462 | 2021-12-15 | Alexander | Illinois | 17003 | 835 | 13 |
1989483 | 1989483 | 2021-12-07 | Gallatin | Illinois | 17059 | 835 | 11 |
1986210 | 1986210 | 2021-12-06 | Calhoun | Illinois | 17013 | 835 | 5 |
1976440 | 1976440 | 2021-12-03 | Lewis | Idaho | 16061 | 835 | 23 |
1973191 | 1973191 | 2021-12-02 | Lewis | Idaho | 16061 | 835 | 23 |
1966376 | 1966376 | 2021-11-30 | Huerfano | Colorado | 8055 | 835 | 21 |
1945041 | 1945041 | 2021-11-23 | Dixon | Nebraska | 31051 | 835 | 11 |
1906298 | 1906298 | 2021-11-11 | Hyde | North Carolina | 37095 | 835 | 12 |
1906826 | 1906826 | 2021-11-11 | Day | South Dakota | 46037 | 835 | 30 |
1903049 | 1903049 | 2021-11-10 | Hyde | North Carolina | 37095 | 835 | 12 |
1903577 | 1903577 | 2021-11-10 | Day | South Dakota | 46037 | 835 | 30 |
1895285 | 1895285 | 2021-11-08 | Stark | Illinois | 17175 | 835 | 29 |
1892035 | 1892035 | 2021-11-07 | Stark | Illinois | 17175 | 835 | 29 |
1888785 | 1888785 | 2021-11-06 | Stark | Illinois | 17175 | 835 | 29 |
1885535 | 1885535 | 2021-11-05 | Stark | Illinois | 17175 | 835 | 29 |
1882286 | 1882286 | 2021-11-04 | Stark | Illinois | 17175 | 835 | 29 |
1849008 | 1849008 | 2021-10-24 | Wirt | West Virginia | 54105 | 835 | 13 |
1845758 | 1845758 | 2021-10-23 | Wirt | West Virginia | 54105 | 835 | 13 |
1823521 | 1823521 | 2021-10-17 | Calhoun | Georgia | 13037 | 835 | 20 |
1820272 | 1820272 | 2021-10-16 | Calhoun | Georgia | 13037 | 835 | 20 |
1817023 | 1817023 | 2021-10-15 | Calhoun | Georgia | 13037 | 835 | 20 |
1814746 | 1814746 | 2021-10-14 | Norman | Minnesota | 27107 | 835 | 9 |
1816596 | 1816596 | 2021-10-14 | Crook | Wyoming | 56011 | 835 | 18 |
1808171 | 1808171 | 2021-10-12 | Montmorency | Michigan | 26119 | 835 | 24 |
1804920 | 1804920 | 2021-10-11 | Montmorency | Michigan | 26119 | 835 | 24 |
1802416 | 1802416 | 2021-10-10 | Sioux | North Dakota | 38085 | 835 | 14 |
1790606 | 1790606 | 2021-10-06 | Hot Springs | Wyoming | 56017 | 835 | 8 |
1765036 | 1765036 | 2021-09-29 | Calhoun | Georgia | 13037 | 835 | 21 |
1767153 | 1767153 | 2021-09-29 | Walworth | South Dakota | 46129 | 835 | 16 |
1759954 | 1759954 | 2021-09-27 | Guadalupe | New Mexico | 35019 | 835 | 15 |
1755179 | 1755179 | 2021-09-26 | Rio Blanco | Colorado | 8103 | 835 | 8 |
1755857 | 1755857 | 2021-09-26 | Republic | Kansas | 20157 | 835 | 15 |
1756015 | 1756015 | 2021-09-26 | Cameron | Louisiana | 22023 | 835 | 8 |
1756569 | 1756569 | 2021-09-26 | Clay | Nebraska | 31035 | 835 | 17 |
1751931 | 1751931 | 2021-09-25 | Rio Blanco | Colorado | 8103 | 835 | 8 |
1752609 | 1752609 | 2021-09-25 | Republic | Kansas | 20157 | 835 | 15 |
1752767 | 1752767 | 2021-09-25 | Cameron | Louisiana | 22023 | 835 | 8 |
1753321 | 1753321 | 2021-09-25 | Clay | Nebraska | 31035 | 835 | 17 |
1748682 | 1748682 | 2021-09-24 | Rio Blanco | Colorado | 8103 | 835 | 8 |
1749360 | 1749360 | 2021-09-24 | Republic | Kansas | 20157 | 835 | 15 |
1749518 | 1749518 | 2021-09-24 | Cameron | Louisiana | 22023 | 835 | 8 |
1750073 | 1750073 | 2021-09-24 | Clay | Nebraska | 31035 | 835 | 17 |
1746268 | 1746268 | 2021-09-23 | Cameron | Louisiana | 22023 | 835 | 8 |
1743019 | 1743019 | 2021-09-22 | Cameron | Louisiana | 22023 | 835 | 8 |
1743896 | 1743896 | 2021-09-22 | Bottineau | North Dakota | 38009 | 835 | 20 |
1738893 | 1738893 | 2021-09-21 | Conejos | Colorado | 8021 | 835 | 29 |
1734537 | 1734537 | 2021-09-19 | Santa Isabel | Puerto Rico | 72133 | 835 | |
1728784 | 1728784 | 2021-09-17 | Tucker | West Virginia | 54093 | 835 | 14 |
1717557 | 1717557 | 2021-09-14 | Toole | Montana | 30101 | 835 | 11 |
1719041 | 1719041 | 2021-09-14 | Webster | West Virginia | 54101 | 835 | 12 |
1693226 | 1693226 | 2021-09-07 | Aleutians West Census Area | Alaska | 2016 | 835 | 0 |
1691925 | 1691925 | 2021-09-06 | Dickey | North Dakota | 38021 | 835 | 33 |
1692415 | 1692415 | 2021-09-06 | McCook | South Dakota | 46087 | 835 | 25 |
1688675 | 1688675 | 2021-09-05 | Dickey | North Dakota | 38021 | 835 | 33 |
1689166 | 1689166 | 2021-09-05 | McCook | South Dakota | 46087 | 835 | 25 |
1685425 | 1685425 | 2021-09-04 | Dickey | North Dakota | 38021 | 835 | 33 |
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);