ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
153 rows where deaths = 701 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 30
- Texas 21
- Louisiana 10
- Missouri 10
- Georgia 8
- Michigan 7
- Illinois 6
- Pennsylvania 6
- Colorado 5
- New Jersey 5
- New York 5
- Washington 5
- Alabama 4
- Indiana 4
- Massachusetts 3
- North Carolina 3
- Arizona 2
- California 2
- District of Columbia 2
- Maryland 2
- Virginia 2
- Arkansas 1
- Connecticut 1
- Hawaii 1
- Kansas 1
- Minnesota 1
- Nebraska 1
- Nevada 1
- New Hampshire 1
- Ohio 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430627 | 2430627 | 2022-04-21 | Ector | Texas | 48135 | 37485 | 701 |
2397629 | 2397629 | 2022-04-11 | Marion | Oregon | 41047 | 68952 | 701 |
2350947 | 2350947 | 2022-03-28 | Calcasieu | Louisiana | 22019 | 54590 | 701 |
2347694 | 2347694 | 2022-03-27 | Calcasieu | Louisiana | 22019 | 54588 | 701 |
2344441 | 2344441 | 2022-03-26 | Calcasieu | Louisiana | 22019 | 54588 | 701 |
2341188 | 2341188 | 2022-03-25 | Calcasieu | Louisiana | 22019 | 54588 | 701 |
2337935 | 2337935 | 2022-03-24 | Calcasieu | Louisiana | 22019 | 54584 | 701 |
2339620 | 2339620 | 2022-03-24 | Potter | Texas | 48375 | 35653 | 701 |
2334681 | 2334681 | 2022-03-23 | Calcasieu | Louisiana | 22019 | 54579 | 701 |
2336366 | 2336366 | 2022-03-23 | Potter | Texas | 48375 | 35651 | 701 |
2331427 | 2331427 | 2022-03-22 | Calcasieu | Louisiana | 22019 | 54577 | 701 |
2267523 | 2267523 | 2022-03-02 | Butler | Pennsylvania | 42019 | 44063 | 701 |
2248017 | 2248017 | 2022-02-24 | Cambria | Pennsylvania | 42021 | 34196 | 701 |
2230761 | 2230761 | 2022-02-19 | Ingham | Michigan | 26065 | 62394 | 701 |
2227510 | 2227510 | 2022-02-18 | Ingham | Michigan | 26065 | 62394 | 701 |
2224259 | 2224259 | 2022-02-17 | Ingham | Michigan | 26065 | 62394 | 701 |
2221008 | 2221008 | 2022-02-16 | Ingham | Michigan | 26065 | 62394 | 701 |
2213293 | 2213293 | 2022-02-14 | Tuscaloosa | Alabama | 1125 | 53376 | 701 |
2210040 | 2210040 | 2022-02-13 | Tuscaloosa | Alabama | 1125 | 53361 | 701 |
2206787 | 2206787 | 2022-02-12 | Tuscaloosa | Alabama | 1125 | 53329 | 701 |
2190272 | 2190272 | 2022-02-06 | Clark | Washington | 53011 | 78248 | 701 |
2187019 | 2187019 | 2022-02-05 | Clark | Washington | 53011 | 78248 | 701 |
2183766 | 2183766 | 2022-02-04 | Clark | Washington | 53011 | 78248 | 701 |
2146259 | 2146259 | 2022-01-24 | Dakota | Minnesota | 27037 | 94165 | 701 |
2122824 | 2122824 | 2022-01-17 | St. Clair | Illinois | 17163 | 58573 | 701 |
2119572 | 2119572 | 2022-01-16 | St. Clair | Illinois | 17163 | 58573 | 701 |
2116320 | 2116320 | 2022-01-15 | St. Clair | Illinois | 17163 | 58573 | 701 |
2113069 | 2113069 | 2022-01-14 | St. Clair | Illinois | 17163 | 58573 | 701 |
2096584 | 2096584 | 2022-01-09 | Hall | Georgia | 13139 | 43439 | 701 |
2093332 | 2093332 | 2022-01-08 | Hall | Georgia | 13139 | 43439 | 701 |
2090080 | 2090080 | 2022-01-07 | Hall | Georgia | 13139 | 43439 | 701 |
2086829 | 2086829 | 2022-01-06 | Hall | Georgia | 13139 | 43439 | 701 |
2083577 | 2083577 | 2022-01-05 | Hall | Georgia | 13139 | 43439 | 701 |
2080325 | 2080325 | 2022-01-04 | Hall | Georgia | 13139 | 43042 | 701 |
2080569 | 2080569 | 2022-01-04 | Winnebago | Illinois | 17201 | 56056 | 701 |
2076824 | 2076824 | 2022-01-03 | Merced | California | 6047 | 47982 | 701 |
2077317 | 2077317 | 2022-01-03 | Winnebago | Illinois | 17201 | 55393 | 701 |
2068739 | 2068739 | 2021-12-31 | Oneida | New York | 36065 | 39190 | 701 |
2035141 | 2035141 | 2021-12-21 | St. Joseph | Indiana | 18141 | 53560 | 701 |
1998710 | 1998710 | 2021-12-10 | Navajo | Arizona | 4017 | 25526 | 701 |
1989184 | 1989184 | 2021-12-07 | Clay | Florida | 12019 | 34113 | 701 |
1985934 | 1985934 | 2021-12-06 | Clay | Florida | 12019 | 34113 | 701 |
1982684 | 1982684 | 2021-12-05 | Clay | Florida | 12019 | 34113 | 701 |
1979434 | 1979434 | 2021-12-04 | Clay | Florida | 12019 | 34113 | 701 |
1976184 | 1976184 | 2021-12-03 | Clay | Florida | 12019 | 34113 | 701 |
1972935 | 1972935 | 2021-12-02 | Clay | Florida | 12019 | 34033 | 701 |
1969685 | 1969685 | 2021-12-01 | Clay | Florida | 12019 | 34033 | 701 |
1966435 | 1966435 | 2021-11-30 | Clay | Florida | 12019 | 34033 | 701 |
1963183 | 1963183 | 2021-11-29 | Clay | Florida | 12019 | 33974 | 701 |
1959932 | 1959932 | 2021-11-28 | Clay | Florida | 12019 | 33974 | 701 |
1956681 | 1956681 | 2021-11-27 | Clay | Florida | 12019 | 33974 | 701 |
1953430 | 1953430 | 2021-11-26 | Clay | Florida | 12019 | 33974 | 701 |
1950179 | 1950179 | 2021-11-25 | Clay | Florida | 12019 | 33974 | 701 |
1946928 | 1946928 | 2021-11-24 | Clay | Florida | 12019 | 33974 | 701 |
1943677 | 1943677 | 2021-11-23 | Clay | Florida | 12019 | 33974 | 701 |
1940427 | 1940427 | 2021-11-22 | Clay | Florida | 12019 | 33974 | 701 |
1937177 | 1937177 | 2021-11-21 | Clay | Florida | 12019 | 33974 | 701 |
1933927 | 1933927 | 2021-11-20 | Clay | Florida | 12019 | 33974 | 701 |
1930675 | 1930675 | 2021-11-19 | Clay | Florida | 12019 | 33974 | 701 |
1927425 | 1927425 | 2021-11-18 | Clay | Florida | 12019 | 33925 | 701 |
1928409 | 1928409 | 2021-11-18 | Saginaw | Michigan | 26145 | 31060 | 701 |
1924175 | 1924175 | 2021-11-17 | Clay | Florida | 12019 | 33925 | 701 |
1925159 | 1925159 | 2021-11-17 | Saginaw | Michigan | 26145 | 31060 | 701 |
1925440 | 1925440 | 2021-11-17 | St. Charles | Missouri | 29183 | 63569 | 701 |
1925630 | 1925630 | 2021-11-17 | Hillsborough | New Hampshire | 33011 | 50485 | 701 |
1920926 | 1920926 | 2021-11-16 | Clay | Florida | 12019 | 33925 | 701 |
1922191 | 1922191 | 2021-11-16 | St. Charles | Missouri | 29183 | 63431 | 701 |
1917676 | 1917676 | 2021-11-15 | Clay | Florida | 12019 | 33925 | 701 |
1918941 | 1918941 | 2021-11-15 | St. Charles | Missouri | 29183 | 63312 | 701 |
1915691 | 1915691 | 2021-11-14 | St. Charles | Missouri | 29183 | 63056 | 701 |
1912441 | 1912441 | 2021-11-13 | St. Charles | Missouri | 29183 | 63056 | 701 |
1909191 | 1909191 | 2021-11-12 | St. Charles | Missouri | 29183 | 63046 | 701 |
1905942 | 1905942 | 2021-11-11 | St. Charles | Missouri | 29183 | 62953 | 701 |
1902693 | 1902693 | 2021-11-10 | St. Charles | Missouri | 29183 | 62854 | 701 |
1903805 | 1903805 | 2021-11-10 | Galveston | Texas | 48167 | 64546 | 701 |
1898261 | 1898261 | 2021-11-09 | Chatham | Georgia | 13051 | 38864 | 701 |
1899443 | 1899443 | 2021-11-09 | St. Charles | Missouri | 29183 | 62752 | 701 |
1900555 | 1900555 | 2021-11-09 | Galveston | Texas | 48167 | 64546 | 701 |
1897305 | 1897305 | 2021-11-08 | Galveston | Texas | 48167 | 64428 | 701 |
1894055 | 1894055 | 2021-11-07 | Galveston | Texas | 48167 | 64428 | 701 |
1882150 | 1882150 | 2021-11-04 | Honolulu | Hawaii | 15003 | 58115 | 701 |
1874597 | 1874597 | 2021-11-01 | Jefferson | Texas | 48245 | 31688 | 701 |
1871471 | 1871471 | 2021-10-31 | Williamson | Texas | 48491 | 76468 | 701 |
1868222 | 1868222 | 2021-10-30 | Williamson | Texas | 48491 | 76468 | 701 |
1864973 | 1864973 | 2021-10-29 | Williamson | Texas | 48491 | 76468 | 701 |
1858898 | 1858898 | 2021-10-28 | Madison | Alabama | 1089 | 52744 | 701 |
1861724 | 1861724 | 2021-10-28 | Williamson | Texas | 48491 | 76389 | 701 |
1858475 | 1858475 | 2021-10-27 | Williamson | Texas | 48491 | 76254 | 701 |
1845245 | 1845245 | 2021-10-23 | Bell | Texas | 48027 | 38344 | 701 |
1835644 | 1835644 | 2021-10-20 | McLennan | Texas | 48309 | 41883 | 701 |
1816350 | 1816350 | 2021-10-14 | Henrico | Virginia | 51087 | 33604 | 701 |
1813102 | 1813102 | 2021-10-13 | Henrico | Virginia | 51087 | 33522 | 701 |
1791795 | 1791795 | 2021-10-07 | St. Tammany | Louisiana | 22103 | 42958 | 701 |
1728282 | 1728282 | 2021-09-17 | Brazoria | Texas | 48039 | 54552 | 701 |
1721019 | 1721019 | 2021-09-15 | Onondaga | New York | 36067 | 44596 | 701 |
1623470 | 1623470 | 2021-08-16 | Washoe | Nevada | 32031 | 50167 | 701 |
1623483 | 1623483 | 2021-08-16 | Atlantic | New Jersey | 34001 | 33013 | 701 |
1620236 | 1620236 | 2021-08-15 | Atlantic | New Jersey | 34001 | 32968 | 701 |
1616988 | 1616988 | 2021-08-14 | Atlantic | New Jersey | 34001 | 32865 | 701 |
1613740 | 1613740 | 2021-08-13 | Atlantic | New Jersey | 34001 | 32789 | 701 |
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);