ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
429 rows where cases = 932 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 47
- Puerto Rico 34
- Texas 34
- Kentucky 26
- Virginia 23
- Alabama 19
- Iowa 15
- Kansas 13
- North Carolina 12
- Indiana 11
- Mississippi 11
- Missouri 11
- Arkansas 10
- Colorado 10
- Minnesota 10
- Montana 10
- South Dakota 10
- Wisconsin 9
- Nebraska 8
- Tennessee 8
- Illinois 7
- Michigan 7
- Ohio 7
- Oklahoma 7
- South Carolina 7
- Alaska 6
- West Virginia 6
- Wyoming 6
- Louisiana 5
- North Dakota 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2380485 | 2380485 | 2022-04-06 | Red Lake | Minnesota | 27125 | 932 | 13 |
2349597 | 2349597 | 2022-03-27 | Rappahannock | Virginia | 51157 | 932 | 9 |
2346344 | 2346344 | 2022-03-26 | Rappahannock | Virginia | 51157 | 932 | 9 |
2343091 | 2343091 | 2022-03-25 | Rappahannock | Virginia | 51157 | 932 | 9 |
2311046 | 2311046 | 2022-03-16 | Gilpin | Colorado | 8047 | 932 | 4 |
2262112 | 2262112 | 2022-03-01 | Calhoun | Arkansas | 5013 | 932 | 9 |
2264480 | 2264480 | 2022-03-01 | Edmunds | South Dakota | 46045 | 932 | 16 |
2258861 | 2258861 | 2022-02-28 | Calhoun | Arkansas | 5013 | 932 | 9 |
2261230 | 2261230 | 2022-02-28 | Edmunds | South Dakota | 46045 | 932 | 16 |
2255610 | 2255610 | 2022-02-27 | Calhoun | Arkansas | 5013 | 932 | 9 |
2201841 | 2201841 | 2022-02-10 | Chouteau | Montana | 30015 | 932 | 14 |
2196434 | 2196434 | 2022-02-08 | Hall | Texas | 48191 | 932 | 20 |
2192042 | 2192042 | 2022-02-07 | Putnam | Missouri | 29171 | 932 | 21 |
2192452 | 2192452 | 2022-02-07 | Tyrrell | North Carolina | 37177 | 932 | 7 |
2188789 | 2188789 | 2022-02-06 | Putnam | Missouri | 29171 | 932 | 21 |
2185536 | 2185536 | 2022-02-05 | Putnam | Missouri | 29171 | 932 | 21 |
2171879 | 2171879 | 2022-02-01 | Haskell | Kansas | 20081 | 932 | 11 |
2168626 | 2168626 | 2022-01-31 | Haskell | Kansas | 20081 | 932 | 11 |
2169718 | 2169718 | 2022-01-31 | LaMoure | North Dakota | 38045 | 932 | 19 |
2149527 | 2149527 | 2022-01-25 | Kittson | Minnesota | 27069 | 932 | 26 |
2147872 | 2147872 | 2022-01-24 | Craig | Virginia | 51045 | 932 | 12 |
2131471 | 2131471 | 2022-01-19 | San Augustine | Texas | 48405 | 932 | 38 |
2125482 | 2125482 | 2022-01-18 | Yukon-Koyukuk Census Area | Alaska | 2290 | 932 | 8 |
2127161 | 2127161 | 2022-01-18 | Lander | Nevada | 32015 | 932 | 16 |
2122230 | 2122230 | 2022-01-17 | Yukon-Koyukuk Census Area | Alaska | 2290 | 932 | 8 |
2118978 | 2118978 | 2022-01-16 | Yukon-Koyukuk Census Area | Alaska | 2290 | 932 | 8 |
2115726 | 2115726 | 2022-01-15 | Yukon-Koyukuk Census Area | Alaska | 2290 | 932 | 8 |
2112474 | 2112474 | 2022-01-14 | Yukon-Koyukuk Census Area | Alaska | 2290 | 932 | 8 |
2100013 | 2100013 | 2022-01-10 | Henderson | Illinois | 17071 | 932 | 24 |
2102335 | 2102335 | 2022-01-10 | Cumberland | Virginia | 51049 | 932 | 19 |
2079705 | 2079705 | 2022-01-03 | Skamania | Washington | 53059 | 932 | 9 |
2076021 | 2076021 | 2022-01-02 | Carson | Texas | 48065 | 932 | 29 |
2072770 | 2072770 | 2022-01-01 | Carson | Texas | 48065 | 932 | 29 |
2069519 | 2069519 | 2021-12-31 | Carson | Texas | 48065 | 932 | 29 |
2066268 | 2066268 | 2021-12-30 | Carson | Texas | 48065 | 932 | 29 |
2059504 | 2059504 | 2021-12-28 | Sabana Grande | Puerto Rico | 72121 | 932 | |
2055526 | 2055526 | 2021-12-27 | Teton | Montana | 30099 | 932 | 19 |
2056675 | 2056675 | 2021-12-27 | Presidio | Texas | 48377 | 932 | 29 |
2035863 | 2035863 | 2021-12-21 | Atchison | Missouri | 29005 | 932 | 18 |
2013289 | 2013289 | 2021-12-14 | Burt | Nebraska | 31021 | 932 | 13 |
1996880 | 1996880 | 2021-12-09 | Dade | Missouri | 29057 | 932 | 38 |
1998104 | 1998104 | 2021-12-09 | Jim Hogg | Texas | 48247 | 932 | 20 |
1991859 | 1991859 | 2021-12-07 | Mathews | Virginia | 51115 | 932 | 24 |
1988126 | 1988126 | 2021-12-06 | Tripp | South Dakota | 46123 | 932 | 21 |
1984876 | 1984876 | 2021-12-05 | Tripp | South Dakota | 46123 | 932 | 21 |
1981626 | 1981626 | 2021-12-04 | Tripp | South Dakota | 46123 | 932 | 21 |
1978376 | 1978376 | 2021-12-03 | Tripp | South Dakota | 46123 | 932 | 21 |
1969364 | 1969364 | 2021-12-01 | Choctaw | Alabama | 1023 | 932 | 28 |
1966114 | 1966114 | 2021-11-30 | Choctaw | Alabama | 1023 | 932 | 28 |
1962862 | 1962862 | 2021-11-29 | Choctaw | Alabama | 1023 | 932 | 28 |
1959611 | 1959611 | 2021-11-28 | Choctaw | Alabama | 1023 | 932 | 28 |
1956360 | 1956360 | 2021-11-27 | Choctaw | Alabama | 1023 | 932 | 28 |
1953109 | 1953109 | 2021-11-26 | Choctaw | Alabama | 1023 | 932 | 28 |
1949858 | 1949858 | 2021-11-25 | Choctaw | Alabama | 1023 | 932 | 28 |
1948988 | 1948988 | 2021-11-24 | Rincon | Puerto Rico | 72117 | 932 | |
1945737 | 1945737 | 2021-11-23 | Rincon | Puerto Rico | 72117 | 932 | |
1945815 | 1945815 | 2021-11-23 | Brule | South Dakota | 46015 | 932 | 12 |
1942486 | 1942486 | 2021-11-22 | Rincon | Puerto Rico | 72117 | 932 | |
1937776 | 1937776 | 2021-11-21 | Gray | Kansas | 20069 | 932 | 23 |
1939236 | 1939236 | 2021-11-21 | Rincon | Puerto Rico | 72117 | 932 | |
1934526 | 1934526 | 2021-11-20 | Gray | Kansas | 20069 | 932 | 23 |
1935986 | 1935986 | 2021-11-20 | Rincon | Puerto Rico | 72117 | 932 | |
1931275 | 1931275 | 2021-11-19 | Gray | Kansas | 20069 | 932 | 23 |
1919392 | 1919392 | 2021-11-15 | Sioux | North Dakota | 38085 | 932 | 17 |
1897097 | 1897097 | 2021-11-08 | Kingsbury | South Dakota | 46077 | 932 | 18 |
1892281 | 1892281 | 2021-11-07 | Harper | Kansas | 20077 | 932 | 23 |
1889031 | 1889031 | 2021-11-06 | Harper | Kansas | 20077 | 932 | 23 |
1885781 | 1885781 | 2021-11-05 | Harper | Kansas | 20077 | 932 | 23 |
1880378 | 1880378 | 2021-11-03 | McHenry | North Dakota | 38049 | 932 | 23 |
1868136 | 1868136 | 2021-10-30 | McCulloch | Texas | 48307 | 932 | 37 |
1823389 | 1823389 | 2021-10-17 | Kit Carson | Colorado | 8063 | 932 | 14 |
1820140 | 1820140 | 2021-10-16 | Kit Carson | Colorado | 8063 | 932 | 14 |
1816891 | 1816891 | 2021-10-15 | Kit Carson | Colorado | 8063 | 932 | 14 |
1808533 | 1808533 | 2021-10-12 | Toole | Montana | 30101 | 932 | 12 |
1804981 | 1804981 | 2021-10-11 | Lac qui Parle | Minnesota | 27073 | 932 | 24 |
1790172 | 1790172 | 2021-10-06 | Newton | Texas | 48351 | 932 | 49 |
1768362 | 1768362 | 2021-09-30 | Marion | Georgia | 13197 | 932 | 33 |
1763619 | 1763619 | 2021-09-28 | Harney | Oregon | 41025 | 932 | 21 |
1746500 | 1746500 | 2021-09-23 | Lake | Minnesota | 27075 | 932 | 21 |
1740299 | 1740299 | 2021-09-21 | Stillwater | Montana | 30095 | 932 | 17 |
1716517 | 1716517 | 2021-09-14 | Edwards | Illinois | 17047 | 932 | 16 |
1709678 | 1709678 | 2021-09-12 | Lake | Colorado | 8065 | 932 | 1 |
1706431 | 1706431 | 2021-09-11 | Lake | Colorado | 8065 | 932 | 1 |
1706714 | 1706714 | 2021-09-11 | Benewah | Idaho | 16009 | 932 | 11 |
1703183 | 1703183 | 2021-09-10 | Lake | Colorado | 8065 | 932 | 1 |
1703466 | 1703466 | 2021-09-10 | Benewah | Idaho | 16009 | 932 | 11 |
1701271 | 1701271 | 2021-09-09 | Blaine | Montana | 30005 | 932 | 24 |
1695719 | 1695719 | 2021-09-07 | Hancock | Tennessee | 47067 | 932 | 15 |
1691436 | 1691436 | 2021-09-06 | Daviess | Missouri | 29061 | 932 | 12 |
1688186 | 1688186 | 2021-09-05 | Daviess | Missouri | 29061 | 932 | 12 |
1675179 | 1675179 | 2021-09-01 | Chariton | Missouri | 29041 | 932 | 8 |
1671907 | 1671907 | 2021-08-31 | Wilkinson | Mississippi | 28157 | 932 | 33 |
1673657 | 1673657 | 2021-08-31 | Sublette | Wyoming | 56035 | 932 | 11 |
1652594 | 1652594 | 2021-08-25 | Valley | Montana | 30105 | 932 | 18 |
1641400 | 1641400 | 2021-08-22 | Plumas | California | 6063 | 932 | 6 |
1631512 | 1631512 | 2021-08-19 | Ketchikan Gateway Borough | Alaska | 2130 | 932 | 2 |
1624412 | 1624412 | 2021-08-16 | Hamilton | Texas | 48193 | 932 | 29 |
1624891 | 1624891 | 2021-08-16 | Pepin | Wisconsin | 55091 | 932 | 7 |
1614762 | 1614762 | 2021-08-13 | Rains | Texas | 48379 | 932 | 30 |
1611513 | 1611513 | 2021-08-12 | Rains | Texas | 48379 | 932 | 30 |
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);