ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
305 rows where cases = 1617 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 27
- Texas 27
- Missouri 17
- Arkansas 16
- Georgia 15
- Idaho 15
- Illinois 14
- Wisconsin 14
- Minnesota 12
- Kentucky 11
- Mississippi 11
- Puerto Rico 10
- Oklahoma 9
- Tennessee 9
- Virginia 9
- Louisiana 7
- Florida 6
- Montana 6
- North Carolina 6
- Colorado 5
- Kansas 5
- Michigan 5
- Ohio 5
- Washington 5
- Alabama 4
- Oregon 4
- Utah 4
- West Virginia 4
- California 3
- Indiana 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501823 | 2501823 | 2022-05-13 | Harney | Oregon | 41025 | 1617 | 38 |
2459599 | 2459599 | 2022-04-30 | Guanica | Puerto Rico | 72055 | 1617 | |
2316700 | 2316700 | 2022-03-17 | Coleman | Texas | 48083 | 1617 | 69 |
2313447 | 2313447 | 2022-03-16 | Coleman | Texas | 48083 | 1617 | 69 |
2310194 | 2310194 | 2022-03-15 | Coleman | Texas | 48083 | 1617 | 69 |
2306941 | 2306941 | 2022-03-14 | Coleman | Texas | 48083 | 1617 | 69 |
2303690 | 2303690 | 2022-03-13 | Coleman | Texas | 48083 | 1617 | 69 |
2300438 | 2300438 | 2022-03-12 | Coleman | Texas | 48083 | 1617 | 69 |
2297186 | 2297186 | 2022-03-11 | Coleman | Texas | 48083 | 1617 | 69 |
2293934 | 2293934 | 2022-03-10 | Coleman | Texas | 48083 | 1617 | 69 |
2290682 | 2290682 | 2022-03-09 | Coleman | Texas | 48083 | 1617 | 69 |
2287430 | 2287430 | 2022-03-08 | Coleman | Texas | 48083 | 1617 | 69 |
2260156 | 2260156 | 2022-02-28 | Wilkin | Minnesota | 27167 | 1617 | 22 |
2223280 | 2223280 | 2022-02-17 | Rio Blanco | Colorado | 8103 | 1617 | 13 |
2218205 | 2218205 | 2022-02-15 | Knox | Nebraska | 31107 | 1617 | 13 |
2218401 | 2218401 | 2022-02-15 | Camden | North Carolina | 37029 | 1617 | 9 |
2215150 | 2215150 | 2022-02-14 | Camden | North Carolina | 37029 | 1617 | 9 |
2201886 | 2201886 | 2022-02-10 | Valley | Montana | 30105 | 1617 | 35 |
2179023 | 2179023 | 2022-02-03 | Ozark | Missouri | 29153 | 1617 | 48 |
2172547 | 2172547 | 2022-02-01 | Sullivan | Missouri | 29211 | 1617 | 19 |
2152042 | 2152042 | 2022-01-26 | Edwards | Illinois | 17047 | 1617 | 25 |
2149098 | 2149098 | 2022-01-25 | Greenwood | Kansas | 20073 | 1617 | 20 |
2149926 | 2149926 | 2022-01-25 | Wayne | Nebraska | 31179 | 1617 | 11 |
2145846 | 2145846 | 2022-01-24 | Greenwood | Kansas | 20073 | 1617 | 20 |
2147600 | 2147600 | 2022-01-24 | Delta | Texas | 48119 | 1617 | 22 |
2134864 | 2134864 | 2022-01-20 | Falls Church city | Virginia | 51610 | 1617 | 14 |
2130007 | 2130007 | 2022-01-19 | Lake | Minnesota | 27075 | 1617 | 26 |
2130651 | 2130651 | 2022-01-19 | Benson | North Dakota | 38005 | 1617 | 22 |
2125667 | 2125667 | 2022-01-18 | Lake | Colorado | 8065 | 1617 | 2 |
2126926 | 2126926 | 2022-01-18 | Harrison | Missouri | 29081 | 1617 | 27 |
2128391 | 2128391 | 2022-01-18 | Lunenburg | Virginia | 51111 | 1617 | 24 |
2112280 | 2112280 | 2022-01-13 | Webster | West Virginia | 54101 | 1617 | 27 |
2095265 | 2095265 | 2022-01-08 | Rincon | Puerto Rico | 72117 | 1617 | |
2086069 | 2086069 | 2022-01-05 | Charlotte | Virginia | 51037 | 1617 | 31 |
2086229 | 2086229 | 2022-01-05 | Gilmer | West Virginia | 54021 | 1617 | 15 |
2057961 | 2057961 | 2021-12-28 | Keokuk | Iowa | 19107 | 1617 | 41 |
2054712 | 2054712 | 2021-12-27 | Keokuk | Iowa | 19107 | 1617 | 41 |
2051462 | 2051462 | 2021-12-26 | Keokuk | Iowa | 19107 | 1617 | 41 |
2048212 | 2048212 | 2021-12-25 | Keokuk | Iowa | 19107 | 1617 | 41 |
2044962 | 2044962 | 2021-12-24 | Keokuk | Iowa | 19107 | 1617 | 41 |
2041713 | 2041713 | 2021-12-23 | Keokuk | Iowa | 19107 | 1617 | 41 |
2038463 | 2038463 | 2021-12-22 | Keokuk | Iowa | 19107 | 1617 | 41 |
2036906 | 2036906 | 2021-12-21 | Clay | Tennessee | 47027 | 1617 | 37 |
1978656 | 1978656 | 2021-12-03 | Ochiltree | Texas | 48357 | 1617 | 38 |
1972811 | 1972811 | 2021-12-02 | Mariposa | California | 6043 | 1617 | 18 |
1973961 | 1973961 | 2021-12-02 | Jackson | Minnesota | 27063 | 1617 | 16 |
1965828 | 1965828 | 2021-11-29 | Galax city | Virginia | 51640 | 1617 | 64 |
1960179 | 1960179 | 2021-11-28 | Fremont | Idaho | 16043 | 1617 | 18 |
1956928 | 1956928 | 2021-11-27 | Fremont | Idaho | 16043 | 1617 | 18 |
1953677 | 1953677 | 2021-11-26 | Fremont | Idaho | 16043 | 1617 | 18 |
1950426 | 1950426 | 2021-11-25 | Fremont | Idaho | 16043 | 1617 | 18 |
1947175 | 1947175 | 2021-11-24 | Fremont | Idaho | 16043 | 1617 | 18 |
1920430 | 1920430 | 2021-11-15 | Pend Oreille | Washington | 53051 | 1617 | 24 |
1908163 | 1908163 | 2021-11-12 | Boundary | Idaho | 16021 | 1617 | 37 |
1904914 | 1904914 | 2021-11-11 | Boundary | Idaho | 16021 | 1617 | 37 |
1901664 | 1901664 | 2021-11-10 | Boundary | Idaho | 16021 | 1617 | 37 |
1887699 | 1887699 | 2021-11-05 | Trinity | Texas | 48455 | 1617 | 60 |
1872425 | 1872425 | 2021-11-01 | Clearwater | Idaho | 16035 | 1617 | 26 |
1869045 | 1869045 | 2021-10-31 | Evans | Georgia | 13109 | 1617 | 53 |
1870226 | 1870226 | 2021-10-31 | Dawson | Montana | 30021 | 1617 | 45 |
1865796 | 1865796 | 2021-10-30 | Evans | Georgia | 13109 | 1617 | 53 |
1866977 | 1866977 | 2021-10-30 | Dawson | Montana | 30021 | 1617 | 45 |
1862547 | 1862547 | 2021-10-29 | Evans | Georgia | 13109 | 1617 | 53 |
1863728 | 1863728 | 2021-10-29 | Dawson | Montana | 30021 | 1617 | 45 |
1859298 | 1859298 | 2021-10-28 | Evans | Georgia | 13109 | 1617 | 52 |
1853309 | 1853309 | 2021-10-26 | Marion | Kansas | 20115 | 1617 | 30 |
1849551 | 1849551 | 2021-10-25 | Evans | Georgia | 13109 | 1617 | 52 |
1850060 | 1850060 | 2021-10-25 | Marion | Kansas | 20115 | 1617 | 30 |
1846451 | 1846451 | 2021-10-24 | Owyhee | Idaho | 16073 | 1617 | 39 |
1822007 | 1822007 | 2021-10-16 | Vinton | Ohio | 39163 | 1617 | 24 |
1791066 | 1791066 | 2021-10-07 | Evans | Georgia | 13109 | 1617 | 50 |
1781054 | 1781054 | 2021-10-04 | Stone | Arkansas | 5137 | 1617 | 40 |
1781986 | 1781986 | 2021-10-04 | Todd | Kentucky | 21219 | 1617 | 30 |
1779036 | 1779036 | 2021-10-03 | Watonwan | Minnesota | 27165 | 1617 | 11 |
1780830 | 1780830 | 2021-10-03 | Price | Wisconsin | 55099 | 1617 | 8 |
1775786 | 1775786 | 2021-10-02 | Watonwan | Minnesota | 27165 | 1617 | 11 |
1777580 | 1777580 | 2021-10-02 | Price | Wisconsin | 55099 | 1617 | 8 |
1772536 | 1772536 | 2021-10-01 | Watonwan | Minnesota | 27165 | 1617 | 11 |
1774330 | 1774330 | 2021-10-01 | Price | Wisconsin | 55099 | 1617 | 8 |
1769721 | 1769721 | 2021-09-30 | Torrance | New Mexico | 35057 | 1617 | 18 |
1767658 | 1767658 | 2021-09-29 | Richmond | Virginia | 51159 | 1617 | 12 |
1762212 | 1762212 | 2021-09-28 | Grundy | Iowa | 19075 | 1617 | 35 |
1762706 | 1762706 | 2021-09-28 | Aitkin | Minnesota | 27001 | 1617 | 39 |
1758964 | 1758964 | 2021-09-27 | Grundy | Iowa | 19075 | 1617 | 35 |
1755716 | 1755716 | 2021-09-26 | Grundy | Iowa | 19075 | 1617 | 35 |
1756976 | 1756976 | 2021-09-26 | Harrison | Ohio | 39067 | 1617 | 41 |
1752468 | 1752468 | 2021-09-25 | Grundy | Iowa | 19075 | 1617 | 35 |
1749219 | 1749219 | 2021-09-24 | Grundy | Iowa | 19075 | 1617 | 35 |
1745969 | 1745969 | 2021-09-23 | Grundy | Iowa | 19075 | 1617 | 35 |
1742720 | 1742720 | 2021-09-22 | Grundy | Iowa | 19075 | 1617 | 35 |
1740972 | 1740972 | 2021-09-21 | Aguas Buenas | Puerto Rico | 72007 | 1617 | |
1741291 | 1741291 | 2021-09-21 | Callahan | Texas | 48059 | 1617 | 50 |
1737723 | 1737723 | 2021-09-20 | Aguas Buenas | Puerto Rico | 72007 | 1617 | |
1733160 | 1733160 | 2021-09-19 | Carroll | Kentucky | 21041 | 1617 | 21 |
1729910 | 1729910 | 2021-09-18 | Carroll | Kentucky | 21041 | 1617 | 21 |
1726660 | 1726660 | 2021-09-17 | Carroll | Kentucky | 21041 | 1617 | 21 |
1728462 | 1728462 | 2021-09-17 | Runnels | Texas | 48399 | 1617 | 49 |
1719023 | 1719023 | 2021-09-14 | Morgan | West Virginia | 54065 | 1617 | 26 |
1715214 | 1715214 | 2021-09-13 | Houston | Tennessee | 47083 | 1617 | 38 |
1712288 | 1712288 | 2021-09-12 | Juab | Utah | 49023 | 1617 | 15 |
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);