ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
464 rows where cases = 1207 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 49
- Texas 43
- Kansas 23
- North Carolina 23
- Kentucky 22
- Iowa 21
- Georgia 20
- Michigan 19
- Oklahoma 17
- Mississippi 16
- Missouri 16
- Arkansas 13
- Louisiana 13
- Nebraska 12
- Puerto Rico 12
- Minnesota 11
- West Virginia 11
- Indiana 10
- Montana 10
- Wyoming 9
- California 8
- Idaho 8
- Colorado 7
- Nevada 7
- Utah 7
- Wisconsin 6
- Alabama 5
- Tennessee 5
- Florida 4
- Illinois 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501274 | 2501274 | 2022-05-13 | Dixon | Nebraska | 31051 | 1207 | 11 |
2502362 | 2502362 | 2022-05-13 | Martin | Texas | 48317 | 1207 | 26 |
2499104 | 2499104 | 2022-05-12 | Martin | Texas | 48317 | 1207 | 26 |
2495846 | 2495846 | 2022-05-11 | Martin | Texas | 48317 | 1207 | 26 |
2492588 | 2492588 | 2022-05-10 | Martin | Texas | 48317 | 1207 | 26 |
2489330 | 2489330 | 2022-05-09 | Martin | Texas | 48317 | 1207 | 26 |
2486073 | 2486073 | 2022-05-08 | Martin | Texas | 48317 | 1207 | 26 |
2482815 | 2482815 | 2022-05-07 | Martin | Texas | 48317 | 1207 | 26 |
2479557 | 2479557 | 2022-05-06 | Martin | Texas | 48317 | 1207 | 26 |
2476231 | 2476231 | 2022-05-05 | Goliad | Texas | 48175 | 1207 | 32 |
2472974 | 2472974 | 2022-05-04 | Goliad | Texas | 48175 | 1207 | 32 |
2469718 | 2469718 | 2022-05-03 | Goliad | Texas | 48175 | 1207 | 32 |
2428897 | 2428897 | 2022-04-21 | Ottawa | Kansas | 20143 | 1207 | 17 |
2425641 | 2425641 | 2022-04-20 | Ottawa | Kansas | 20143 | 1207 | 17 |
2422385 | 2422385 | 2022-04-19 | Ottawa | Kansas | 20143 | 1207 | 17 |
2419129 | 2419129 | 2022-04-18 | Ottawa | Kansas | 20143 | 1207 | 17 |
2415873 | 2415873 | 2022-04-17 | Ottawa | Kansas | 20143 | 1207 | 17 |
2415945 | 2415945 | 2022-04-17 | Fulton | Kentucky | 21075 | 1207 | 28 |
2412617 | 2412617 | 2022-04-16 | Ottawa | Kansas | 20143 | 1207 | 17 |
2412689 | 2412689 | 2022-04-16 | Fulton | Kentucky | 21075 | 1207 | 28 |
2409361 | 2409361 | 2022-04-15 | Ottawa | Kansas | 20143 | 1207 | 17 |
2409433 | 2409433 | 2022-04-15 | Fulton | Kentucky | 21075 | 1207 | 28 |
2406177 | 2406177 | 2022-04-14 | Fulton | Kentucky | 21075 | 1207 | 28 |
2402921 | 2402921 | 2022-04-13 | Fulton | Kentucky | 21075 | 1207 | 28 |
2399667 | 2399667 | 2022-04-12 | Fulton | Kentucky | 21075 | 1207 | 28 |
2396411 | 2396411 | 2022-04-11 | Fulton | Kentucky | 21075 | 1207 | 28 |
2378932 | 2378932 | 2022-04-05 | San Juan | Washington | 53055 | 1207 | 2 |
2375678 | 2375678 | 2022-04-04 | San Juan | Washington | 53055 | 1207 | 2 |
2313511 | 2313511 | 2022-03-16 | Hemphill | Texas | 48211 | 1207 | 7 |
2194716 | 2194716 | 2022-02-08 | Ballard | Kentucky | 21007 | 1207 | 27 |
2179111 | 2179111 | 2022-02-03 | Teton | Montana | 30099 | 1207 | 18 |
2171529 | 2171529 | 2022-02-01 | Lemhi | Idaho | 16059 | 1207 | 25 |
2167222 | 2167222 | 2022-01-30 | McCulloch | Texas | 48307 | 1207 | 42 |
2088380 | 2088380 | 2022-01-06 | Bottineau | North Dakota | 38009 | 1207 | 24 |
2088739 | 2088739 | 2022-01-06 | Jayuya | Puerto Rico | 72073 | 1207 | |
2084593 | 2084593 | 2022-01-05 | Quitman | Mississippi | 28119 | 1207 | 28 |
2052390 | 2052390 | 2021-12-26 | Pershing | Nevada | 32027 | 1207 | 29 |
2049140 | 2049140 | 2021-12-25 | Pershing | Nevada | 32027 | 1207 | 29 |
2045890 | 2045890 | 2021-12-24 | Pershing | Nevada | 32027 | 1207 | 29 |
2042640 | 2042640 | 2021-12-23 | Pershing | Nevada | 32027 | 1207 | 29 |
2039391 | 2039391 | 2021-12-22 | Pershing | Nevada | 32027 | 1207 | 29 |
2040434 | 2040434 | 2021-12-22 | Refugio | Texas | 48391 | 1207 | 31 |
2036141 | 2036141 | 2021-12-21 | Pershing | Nevada | 32027 | 1207 | 29 |
2037184 | 2037184 | 2021-12-21 | Refugio | Texas | 48391 | 1207 | 31 |
2032891 | 2032891 | 2021-12-20 | Pershing | Nevada | 32027 | 1207 | 29 |
2033934 | 2033934 | 2021-12-20 | Refugio | Texas | 48391 | 1207 | 31 |
2030684 | 2030684 | 2021-12-19 | Refugio | Texas | 48391 | 1207 | 31 |
2027433 | 2027433 | 2021-12-18 | Refugio | Texas | 48391 | 1207 | 31 |
2016379 | 2016379 | 2021-12-15 | Clark | Missouri | 29045 | 1207 | 28 |
2014276 | 2014276 | 2021-12-14 | Coleman | Texas | 48083 | 1207 | 57 |
2011025 | 2011025 | 2021-12-13 | Coleman | Texas | 48083 | 1207 | 57 |
1992261 | 1992261 | 2021-12-08 | Monroe | Arkansas | 5095 | 1207 | 25 |
1989010 | 1989010 | 2021-12-07 | Monroe | Arkansas | 5095 | 1207 | 25 |
1985760 | 1985760 | 2021-12-06 | Monroe | Arkansas | 5095 | 1207 | 25 |
1982510 | 1982510 | 2021-12-05 | Monroe | Arkansas | 5095 | 1207 | 25 |
1979260 | 1979260 | 2021-12-04 | Monroe | Arkansas | 5095 | 1207 | 25 |
1976010 | 1976010 | 2021-12-03 | Monroe | Arkansas | 5095 | 1207 | 25 |
1972761 | 1972761 | 2021-12-02 | Monroe | Arkansas | 5095 | 1207 | 25 |
1969650 | 1969650 | 2021-12-01 | Rio Blanco | Colorado | 8103 | 1207 | 10 |
1963636 | 1963636 | 2021-11-29 | Union | Indiana | 18161 | 1207 | 17 |
1962657 | 1962657 | 2021-11-28 | Williamsburg city | Virginia | 51830 | 1207 | 13 |
1959406 | 1959406 | 2021-11-27 | Williamsburg city | Virginia | 51830 | 1207 | 13 |
1956155 | 1956155 | 2021-11-26 | Williamsburg city | Virginia | 51830 | 1207 | 13 |
1943432 | 1943432 | 2021-11-23 | Sitka City and Borough | Alaska | 2220 | 1207 | 4 |
1944208 | 1944208 | 2021-11-23 | Monona | Iowa | 19133 | 1207 | 39 |
1940958 | 1940958 | 2021-11-22 | Monona | Iowa | 19133 | 1207 | 39 |
1942796 | 1942796 | 2021-11-22 | Floyd | Texas | 48153 | 1207 | 40 |
1937325 | 1937325 | 2021-11-21 | Lincoln | Georgia | 13181 | 1207 | 33 |
1937708 | 1937708 | 2021-11-21 | Monona | Iowa | 19133 | 1207 | 39 |
1938679 | 1938679 | 2021-11-21 | Quay | New Mexico | 35037 | 1207 | 25 |
1939546 | 1939546 | 2021-11-21 | Floyd | Texas | 48153 | 1207 | 40 |
1934075 | 1934075 | 2021-11-20 | Lincoln | Georgia | 13181 | 1207 | 33 |
1934458 | 1934458 | 2021-11-20 | Monona | Iowa | 19133 | 1207 | 39 |
1935429 | 1935429 | 2021-11-20 | Quay | New Mexico | 35037 | 1207 | 25 |
1936296 | 1936296 | 2021-11-20 | Floyd | Texas | 48153 | 1207 | 40 |
1930823 | 1930823 | 2021-11-19 | Lincoln | Georgia | 13181 | 1207 | 33 |
1931207 | 1931207 | 2021-11-19 | Monona | Iowa | 19133 | 1207 | 39 |
1932179 | 1932179 | 2021-11-19 | Quay | New Mexico | 35037 | 1207 | 25 |
1927956 | 1927956 | 2021-11-18 | Monona | Iowa | 19133 | 1207 | 39 |
1924706 | 1924706 | 2021-11-17 | Monona | Iowa | 19133 | 1207 | 39 |
1898148 | 1898148 | 2021-11-09 | San Miguel | Colorado | 8113 | 1207 | 5 |
1898826 | 1898826 | 2021-11-09 | Russell | Kansas | 20167 | 1207 | 33 |
1895576 | 1895576 | 2021-11-08 | Russell | Kansas | 20167 | 1207 | 33 |
1853790 | 1853790 | 2021-10-26 | Franklin | Mississippi | 28037 | 1207 | 28 |
1855463 | 1855463 | 2021-10-26 | Doddridge | West Virginia | 54017 | 1207 | 10 |
1837080 | 1837080 | 2021-10-21 | Pratt | Kansas | 20151 | 1207 | 26 |
1833831 | 1833831 | 2021-10-20 | Pratt | Kansas | 20151 | 1207 | 26 |
1830520 | 1830520 | 2021-10-19 | Clay | Kansas | 20027 | 1207 | 31 |
1832373 | 1832373 | 2021-10-19 | La Salle | Texas | 48283 | 1207 | 37 |
1827271 | 1827271 | 2021-10-18 | Clay | Kansas | 20027 | 1207 | 31 |
1828003 | 1828003 | 2021-10-18 | Madison | Montana | 30057 | 1207 | 11 |
1824152 | 1824152 | 2021-10-17 | Gallatin | Kentucky | 21077 | 1207 | 38 |
1820903 | 1820903 | 2021-10-16 | Gallatin | Kentucky | 21077 | 1207 | 38 |
1817654 | 1817654 | 2021-10-15 | Gallatin | Kentucky | 21077 | 1207 | 38 |
1813856 | 1813856 | 2021-10-14 | Miller | Georgia | 13201 | 1207 | 20 |
1815994 | 1815994 | 2021-10-14 | Archer | Texas | 48009 | 1207 | 18 |
1809485 | 1809485 | 2021-10-12 | Van Buren | Tennessee | 47175 | 1207 | 27 |
1806562 | 1806562 | 2021-10-11 | Buena Vista city | Virginia | 51530 | 1207 | 22 |
1803312 | 1803312 | 2021-10-10 | Buena Vista city | Virginia | 51530 | 1207 | 22 |
1800063 | 1800063 | 2021-10-09 | Buena Vista city | Virginia | 51530 | 1207 | 22 |
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);