ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
262 rows where cases = 1988 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- Iowa 19
- Missouri 16
- North Carolina 15
- Oklahoma 14
- Virginia 14
- Georgia 12
- Arkansas 10
- Kentucky 8
- Michigan 8
- New Mexico 8
- Wisconsin 8
- Colorado 7
- Idaho 7
- Illinois 7
- Oregon 7
- Indiana 6
- Mississippi 6
- Nebraska 6
- Minnesota 5
- Puerto Rico 5
- Utah 5
- West Virginia 5
- Alabama 4
- Montana 4
- North Dakota 4
- Ohio 4
- Alaska 3
- Pennsylvania 3
- South Carolina 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495970 | 2495970 | 2022-05-11 | Unknown | Utah | 1988 | 90 | |
2426902 | 2426902 | 2022-04-20 | Unknown | Oklahoma | 1988 | 7 | |
2423646 | 2423646 | 2022-04-19 | Unknown | Oklahoma | 1988 | 7 | |
2400014 | 2400014 | 2022-04-12 | Pipestone | Minnesota | 27117 | 1988 | 34 |
2396758 | 2396758 | 2022-04-11 | Pipestone | Minnesota | 27117 | 1988 | 34 |
2365220 | 2365220 | 2022-04-01 | Patillas | Puerto Rico | 72109 | 1988 | |
2356217 | 2356217 | 2022-03-29 | Tucker | West Virginia | 54093 | 1988 | 37 |
2352964 | 2352964 | 2022-03-28 | Tucker | West Virginia | 54093 | 1988 | 36 |
2332133 | 2332133 | 2022-03-22 | Quay | New Mexico | 35037 | 1988 | 49 |
2328880 | 2328880 | 2022-03-21 | Quay | New Mexico | 35037 | 1988 | 49 |
2329754 | 2329754 | 2022-03-21 | Gaines | Texas | 48165 | 1988 | 83 |
2326502 | 2326502 | 2022-03-20 | Gaines | Texas | 48165 | 1988 | 83 |
2323249 | 2323249 | 2022-03-19 | Gaines | Texas | 48165 | 1988 | 83 |
2284456 | 2284456 | 2022-03-07 | Buena Vista city | Virginia | 51530 | 1988 | 39 |
2278345 | 2278345 | 2022-03-06 | Southeast Fairbanks Census Area | Alaska | 2240 | 1988 | 17 |
2275092 | 2275092 | 2022-03-05 | Southeast Fairbanks Census Area | Alaska | 2240 | 1988 | 17 |
2271839 | 2271839 | 2022-03-04 | Southeast Fairbanks Census Area | Alaska | 2240 | 1988 | 17 |
2270863 | 2270863 | 2022-03-03 | Guayanilla | Puerto Rico | 72059 | 1988 | |
2260361 | 2260361 | 2022-02-28 | Blaine | Montana | 30005 | 1988 | 31 |
2243051 | 2243051 | 2022-02-23 | Benewah | Idaho | 16009 | 1988 | 40 |
2239785 | 2239785 | 2022-02-22 | Wilcox | Georgia | 13315 | 1988 | 66 |
2237016 | 2237016 | 2022-02-21 | Crittenden | Kentucky | 21055 | 1988 | 42 |
2224825 | 2224825 | 2022-02-17 | Sierra | New Mexico | 35051 | 1988 | 69 |
2225463 | 2225463 | 2022-02-17 | Custer | South Dakota | 46033 | 1988 | 22 |
2191242 | 2191242 | 2022-02-07 | Union | Indiana | 18161 | 1988 | 21 |
2174985 | 2174985 | 2022-02-02 | Warren | Indiana | 18171 | 1988 | 24 |
2176861 | 2176861 | 2022-02-02 | Clay | Texas | 48077 | 1988 | 27 |
2168283 | 2168283 | 2022-01-31 | Owyhee | Idaho | 16073 | 1988 | 47 |
2170111 | 2170111 | 2022-01-31 | Allendale | South Carolina | 45005 | 1988 | 23 |
2167067 | 2167067 | 2022-01-30 | Archer | Texas | 48009 | 1988 | 24 |
2167439 | 2167439 | 2022-01-30 | Lunenburg | Virginia | 51111 | 1988 | 23 |
2164184 | 2164184 | 2022-01-29 | Lunenburg | Virginia | 51111 | 1988 | 23 |
2160929 | 2160929 | 2022-01-28 | Lunenburg | Virginia | 51111 | 1988 | 23 |
2152843 | 2152843 | 2022-01-26 | Claiborne | Mississippi | 28021 | 1988 | 42 |
2153751 | 2153751 | 2022-01-26 | Adjuntas | Puerto Rico | 72001 | 1988 | |
2148920 | 2148920 | 2022-01-25 | Martin | Indiana | 18101 | 1988 | 23 |
2149733 | 2149733 | 2022-01-25 | Monroe | Missouri | 29137 | 1988 | 38 |
2135270 | 2135270 | 2022-01-21 | Cleveland | Arkansas | 5025 | 1988 | 33 |
2122737 | 2122737 | 2022-01-17 | Washington | Idaho | 16087 | 1988 | 51 |
2123673 | 2123673 | 2022-01-17 | Grundy | Missouri | 29079 | 1988 | 60 |
2119372 | 2119372 | 2022-01-16 | McIntosh | Georgia | 13191 | 1988 | 33 |
2119485 | 2119485 | 2022-01-16 | Washington | Idaho | 16087 | 1988 | 51 |
2120421 | 2120421 | 2022-01-16 | Grundy | Missouri | 29079 | 1988 | 60 |
2116120 | 2116120 | 2022-01-15 | McIntosh | Georgia | 13191 | 1988 | 33 |
2116233 | 2116233 | 2022-01-15 | Washington | Idaho | 16087 | 1988 | 51 |
2117169 | 2117169 | 2022-01-15 | Grundy | Missouri | 29079 | 1988 | 60 |
2112869 | 2112869 | 2022-01-14 | McIntosh | Georgia | 13191 | 1988 | 33 |
2104370 | 2104370 | 2022-01-11 | Red Willow | Nebraska | 31145 | 1988 | 17 |
2076631 | 2076631 | 2022-01-03 | Coosa | Alabama | 1037 | 1988 | 48 |
2075397 | 2075397 | 2022-01-02 | Mercer | North Dakota | 38057 | 1988 | 22 |
2072146 | 2072146 | 2022-01-01 | Mercer | North Dakota | 38057 | 1988 | 22 |
2058474 | 2058474 | 2021-12-28 | Koochiching | Minnesota | 27071 | 1988 | 29 |
2055417 | 2055417 | 2021-12-27 | Lewis | Missouri | 29111 | 1988 | 30 |
2056516 | 2056516 | 2021-12-27 | Callahan | Texas | 48059 | 1988 | 59 |
2031325 | 2031325 | 2021-12-20 | Mono | California | 6051 | 1988 | 4 |
2030008 | 2030008 | 2021-12-19 | Vinton | Ohio | 39163 | 1988 | 41 |
1995649 | 1995649 | 2021-12-09 | Prowers | Colorado | 8099 | 1988 | 39 |
1988293 | 1988293 | 2021-12-06 | Duval | Texas | 48131 | 1988 | 60 |
1961445 | 1961445 | 2021-11-28 | Torrance | New Mexico | 35057 | 1988 | 21 |
1962494 | 1962494 | 2021-11-28 | Morgan | Utah | 49029 | 1988 | 13 |
1958194 | 1958194 | 2021-11-27 | Torrance | New Mexico | 35057 | 1988 | 21 |
1959243 | 1959243 | 2021-11-27 | Morgan | Utah | 49029 | 1988 | 13 |
1954943 | 1954943 | 2021-11-26 | Torrance | New Mexico | 35057 | 1988 | 21 |
1955992 | 1955992 | 2021-11-26 | Morgan | Utah | 49029 | 1988 | 13 |
1951692 | 1951692 | 2021-11-25 | Torrance | New Mexico | 35057 | 1988 | 21 |
1952751 | 1952751 | 2021-11-25 | Unknown | Utah | 1988 | 38 | |
1948441 | 1948441 | 2021-11-24 | Torrance | New Mexico | 35057 | 1988 | 21 |
1938114 | 1938114 | 2021-11-21 | Gogebic | Michigan | 26053 | 1988 | 55 |
1934864 | 1934864 | 2021-11-20 | Gogebic | Michigan | 26053 | 1988 | 55 |
1931614 | 1931614 | 2021-11-19 | Gogebic | Michigan | 26053 | 1988 | 55 |
1929126 | 1929126 | 2021-11-18 | McLean | North Dakota | 38055 | 1988 | 42 |
1921672 | 1921672 | 2021-11-16 | Martin | Kentucky | 21159 | 1988 | 36 |
1922184 | 1922184 | 2021-11-16 | Ripley | Missouri | 29181 | 1988 | 25 |
1912374 | 1912374 | 2021-11-13 | Dent | Missouri | 29065 | 1988 | 42 |
1898702 | 1898702 | 2021-11-09 | Lyon | Iowa | 19119 | 1988 | 42 |
1898743 | 1898743 | 2021-11-09 | Allen | Kansas | 20001 | 1988 | 27 |
1895452 | 1895452 | 2021-11-08 | Lyon | Iowa | 19119 | 1988 | 42 |
1895493 | 1895493 | 2021-11-08 | Allen | Kansas | 20001 | 1988 | 27 |
1896588 | 1896588 | 2021-11-08 | Swain | North Carolina | 37173 | 1988 | 24 |
1892202 | 1892202 | 2021-11-07 | Lyon | Iowa | 19119 | 1988 | 42 |
1893338 | 1893338 | 2021-11-07 | Swain | North Carolina | 37173 | 1988 | 24 |
1888952 | 1888952 | 2021-11-06 | Lyon | Iowa | 19119 | 1988 | 42 |
1890088 | 1890088 | 2021-11-06 | Swain | North Carolina | 37173 | 1988 | 24 |
1885702 | 1885702 | 2021-11-05 | Lyon | Iowa | 19119 | 1988 | 42 |
1886838 | 1886838 | 2021-11-05 | Swain | North Carolina | 37173 | 1988 | 24 |
1882453 | 1882453 | 2021-11-04 | Lyon | Iowa | 19119 | 1988 | 42 |
1883589 | 1883589 | 2021-11-04 | Swain | North Carolina | 37173 | 1988 | 24 |
1879204 | 1879204 | 2021-11-03 | Lyon | Iowa | 19119 | 1988 | 42 |
1810268 | 1810268 | 2021-10-13 | Little River | Arkansas | 5081 | 1988 | 71 |
1809846 | 1809846 | 2021-10-12 | Grayson | Virginia | 51077 | 1988 | 45 |
1800249 | 1800249 | 2021-10-09 | Monroe | West Virginia | 54063 | 1988 | 25 |
1791204 | 1791204 | 2021-10-07 | Idaho | Idaho | 16049 | 1988 | 29 |
1783910 | 1783910 | 2021-10-04 | Rockbridge | Virginia | 51163 | 1988 | 53 |
1780834 | 1780834 | 2021-10-03 | Rusk | Wisconsin | 55107 | 1988 | 31 |
1777584 | 1777584 | 2021-10-02 | Rusk | Wisconsin | 55107 | 1988 | 31 |
1774334 | 1774334 | 2021-10-01 | Rusk | Wisconsin | 55107 | 1988 | 31 |
1767995 | 1767995 | 2021-09-30 | Chicot | Arkansas | 5017 | 1988 | 44 |
1765247 | 1765247 | 2021-09-29 | De Witt | Illinois | 17039 | 1988 | 37 |
1760976 | 1760976 | 2021-09-27 | Terry | Texas | 48445 | 1988 | 61 |
1757728 | 1757728 | 2021-09-26 | Terry | Texas | 48445 | 1988 | 61 |
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);