ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
226 rows where cases = 2254 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: state, county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467472 | 2467472 | 2022-05-03 | Johnson | Georgia | 13167 | 2254 | 72 |
2464217 | 2464217 | 2022-05-02 | Johnson | Georgia | 13167 | 2254 | 72 |
2388003 | 2388003 | 2022-04-08 | Sabana Grande | Puerto Rico | 72121 | 2254 | |
2375963 | 2375963 | 2022-04-05 | Cleveland | Arkansas | 5025 | 2254 | 36 |
2372711 | 2372711 | 2022-04-04 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2369458 | 2369458 | 2022-04-03 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2366205 | 2366205 | 2022-04-02 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2362952 | 2362952 | 2022-04-01 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2359698 | 2359698 | 2022-03-31 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2356444 | 2356444 | 2022-03-30 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2356794 | 2356794 | 2022-03-30 | Johnson | Georgia | 13167 | 2254 | 72 |
2353191 | 2353191 | 2022-03-29 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2354780 | 2354780 | 2022-03-29 | Hamilton | Nebraska | 31081 | 2254 | 24 |
2349939 | 2349939 | 2022-03-28 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2346686 | 2346686 | 2022-03-27 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2349568 | 2349568 | 2022-03-27 | Madison | Virginia | 51113 | 2254 | 37 |
2343433 | 2343433 | 2022-03-26 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2346315 | 2346315 | 2022-03-26 | Madison | Virginia | 51113 | 2254 | 37 |
2340180 | 2340180 | 2022-03-25 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2343062 | 2343062 | 2022-03-25 | Madison | Virginia | 51113 | 2254 | 37 |
2336927 | 2336927 | 2022-03-24 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2333673 | 2333673 | 2022-03-23 | Cleveland | Arkansas | 5025 | 2254 | 35 |
2302054 | 2302054 | 2022-03-13 | Elliott | Kentucky | 21063 | 2254 | 16 |
2298802 | 2298802 | 2022-03-12 | Elliott | Kentucky | 21063 | 2254 | 16 |
2295550 | 2295550 | 2022-03-11 | Elliott | Kentucky | 21063 | 2254 | 16 |
2292298 | 2292298 | 2022-03-10 | Elliott | Kentucky | 21063 | 2254 | 16 |
2289046 | 2289046 | 2022-03-09 | Elliott | Kentucky | 21063 | 2254 | 16 |
2285795 | 2285795 | 2022-03-08 | Elliott | Kentucky | 21063 | 2254 | 16 |
2281986 | 2281986 | 2022-03-07 | Lanier | Georgia | 13173 | 2254 | 21 |
2282543 | 2282543 | 2022-03-07 | Elliott | Kentucky | 21063 | 2254 | 16 |
2196561 | 2196561 | 2022-02-08 | Terry | Texas | 48445 | 2254 | 81 |
2193307 | 2193307 | 2022-02-07 | Terry | Texas | 48445 | 2254 | 81 |
2180703 | 2180703 | 2022-02-04 | Bullock | Alabama | 1011 | 2254 | 49 |
2178645 | 2178645 | 2022-02-03 | Piscataquis | Maine | 23021 | 2254 | 25 |
2171542 | 2171542 | 2022-02-01 | Valley | Idaho | 16085 | 2254 | 14 |
2168289 | 2168289 | 2022-01-31 | Valley | Idaho | 16085 | 2254 | 14 |
2165427 | 2165427 | 2022-01-30 | Thomas | Kansas | 20193 | 2254 | 26 |
2162172 | 2162172 | 2022-01-29 | Thomas | Kansas | 20193 | 2254 | 26 |
2158917 | 2158917 | 2022-01-28 | Thomas | Kansas | 20193 | 2254 | 26 |
2149751 | 2149751 | 2022-01-25 | Ralls | Missouri | 29173 | 2254 | 19 |
2144659 | 2144659 | 2022-01-23 | Lexington city | Virginia | 51678 | 2254 | 38 |
2141404 | 2141404 | 2022-01-22 | Lexington city | Virginia | 51678 | 2254 | 38 |
2138148 | 2138148 | 2022-01-21 | Lexington city | Virginia | 51678 | 2254 | 38 |
2133029 | 2133029 | 2022-01-20 | Catahoula | Louisiana | 22025 | 2254 | 49 |
2123247 | 2123247 | 2022-01-17 | Todd | Kentucky | 21219 | 2254 | 39 |
2119995 | 2119995 | 2022-01-16 | Todd | Kentucky | 21219 | 2254 | 39 |
2121828 | 2121828 | 2022-01-16 | Brunswick | Virginia | 51025 | 2254 | 37 |
2116743 | 2116743 | 2022-01-15 | Todd | Kentucky | 21219 | 2254 | 39 |
2118576 | 2118576 | 2022-01-15 | Brunswick | Virginia | 51025 | 2254 | 37 |
2113492 | 2113492 | 2022-01-14 | Todd | Kentucky | 21219 | 2254 | 39 |
2115324 | 2115324 | 2022-01-14 | Brunswick | Virginia | 51025 | 2254 | 37 |
2103224 | 2103224 | 2022-01-11 | Shoshone | Idaho | 16079 | 2254 | 69 |
2086080 | 2086080 | 2022-01-05 | Dickenson | Virginia | 51051 | 2254 | 38 |
2050761 | 2050761 | 2021-12-26 | Lee | Arkansas | 5077 | 2254 | 54 |
2053490 | 2053490 | 2021-12-26 | Zapata | Texas | 48505 | 2254 | 46 |
2050240 | 2050240 | 2021-12-25 | Zapata | Texas | 48505 | 2254 | 46 |
2046990 | 2046990 | 2021-12-24 | Zapata | Texas | 48505 | 2254 | 46 |
2043740 | 2043740 | 2021-12-23 | Zapata | Texas | 48505 | 2254 | 46 |
2040491 | 2040491 | 2021-12-22 | Zapata | Texas | 48505 | 2254 | 46 |
2031732 | 2031732 | 2021-12-20 | Cumberland | Illinois | 17035 | 2254 | 41 |
2013839 | 2013839 | 2021-12-14 | Baker | Oregon | 41001 | 2254 | 36 |
1987038 | 1987038 | 2021-12-06 | Greene | Mississippi | 28041 | 2254 | 49 |
1944189 | 1944189 | 2021-11-23 | Iowa | Iowa | 19095 | 2254 | 34 |
1940939 | 1940939 | 2021-11-22 | Iowa | Iowa | 19095 | 2254 | 34 |
1937689 | 1937689 | 2021-11-21 | Iowa | Iowa | 19095 | 2254 | 34 |
1934439 | 1934439 | 2021-11-20 | Iowa | Iowa | 19095 | 2254 | 34 |
1931188 | 1931188 | 2021-11-19 | Iowa | Iowa | 19095 | 2254 | 34 |
1927363 | 1927363 | 2021-11-18 | Grand | Colorado | 8049 | 2254 | 16 |
1927937 | 1927937 | 2021-11-18 | Iowa | Iowa | 19095 | 2254 | 34 |
1924025 | 1924025 | 2021-11-17 | Van Buren | Arkansas | 5141 | 2254 | 44 |
1924687 | 1924687 | 2021-11-17 | Iowa | Iowa | 19095 | 2254 | 34 |
1918006 | 1918006 | 2021-11-15 | Massac | Illinois | 17127 | 2254 | 57 |
1915248 | 1915248 | 2021-11-14 | Madison | Louisiana | 22065 | 2254 | 53 |
1911998 | 1911998 | 2021-11-13 | Madison | Louisiana | 22065 | 2254 | 53 |
1908749 | 1908749 | 2021-11-12 | Madison | Louisiana | 22065 | 2254 | 53 |
1884805 | 1884805 | 2021-11-04 | Rusk | Wisconsin | 55107 | 2254 | 35 |
1871807 | 1871807 | 2021-10-31 | Richland | Wisconsin | 55103 | 2254 | 26 |
1868558 | 1868558 | 2021-10-30 | Richland | Wisconsin | 55103 | 2254 | 26 |
1865309 | 1865309 | 2021-10-29 | Richland | Wisconsin | 55103 | 2254 | 26 |
1846944 | 1846944 | 2021-10-24 | Monroe | Kentucky | 21171 | 2254 | 59 |
1843694 | 1843694 | 2021-10-23 | Monroe | Kentucky | 21171 | 2254 | 59 |
1840444 | 1840444 | 2021-10-22 | Monroe | Kentucky | 21171 | 2254 | 59 |
1840884 | 1840884 | 2021-10-22 | Dallas | Missouri | 29059 | 2254 | 42 |
1837635 | 1837635 | 2021-10-21 | Dallas | Missouri | 29059 | 2254 | 42 |
1818504 | 1818504 | 2021-10-15 | Schoharie | New York | 36095 | 2254 | 21 |
1814150 | 1814150 | 2021-10-14 | Tipton | Indiana | 18159 | 2254 | 61 |
1808848 | 1808848 | 2021-10-12 | Polk | North Carolina | 37149 | 2254 | 43 |
1784167 | 1784167 | 2021-10-05 | Macon | Alabama | 1087 | 2254 | 58 |
1785968 | 1785968 | 2021-10-05 | Taos | New Mexico | 35055 | 2254 | 62 |
1767837 | 1767837 | 2021-09-29 | Sawyer | Wisconsin | 55113 | 2254 | 31 |
1742495 | 1742495 | 2021-09-22 | Carroll | Illinois | 17015 | 2254 | 38 |
1720254 | 1720254 | 2021-09-15 | Union | Kentucky | 21225 | 2254 | 21 |
1716033 | 1716033 | 2021-09-14 | Howard | Arkansas | 5061 | 2254 | 29 |
1696985 | 1696985 | 2021-09-08 | Gem | Idaho | 16045 | 2254 | 47 |
1695604 | 1695604 | 2021-09-07 | Lee | South Carolina | 45061 | 2254 | 67 |
1671330 | 1671330 | 2021-08-31 | Dickinson | Kansas | 20041 | 2254 | 50 |
1671918 | 1671918 | 2021-08-31 | Benton | Missouri | 29015 | 2254 | 40 |
1667563 | 1667563 | 2021-08-30 | Banks | Georgia | 13011 | 2254 | 46 |
1668083 | 1668083 | 2021-08-30 | Dickinson | Kansas | 20041 | 2254 | 50 |
1643796 | 1643796 | 2021-08-22 | Unicoi | Tennessee | 47171 | 2254 | 52 |
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);