ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
312 rows where cases = 1813 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 25
- Missouri 25
- Texas 23
- Virginia 18
- South Carolina 16
- Tennessee 14
- Mississippi 12
- Kansas 11
- Michigan 11
- Georgia 10
- Louisiana 10
- Ohio 10
- Puerto Rico 10
- Indiana 9
- Kentucky 9
- Wisconsin 9
- Arkansas 8
- North Carolina 8
- Alabama 7
- Colorado 7
- Minnesota 7
- Oklahoma 7
- Illinois 6
- South Dakota 5
- Montana 4
- Pennsylvania 4
- West Virginia 4
- Rhode Island 3
- Wyoming 3
- Nebraska 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2417596 | 2417596 | 2022-04-17 | Delta | Texas | 48119 | 1813 | 25 |
2414340 | 2414340 | 2022-04-16 | Delta | Texas | 48119 | 1813 | 25 |
2411084 | 2411084 | 2022-04-15 | Delta | Texas | 48119 | 1813 | 25 |
2407828 | 2407828 | 2022-04-14 | Delta | Texas | 48119 | 1813 | 25 |
2404572 | 2404572 | 2022-04-13 | Delta | Texas | 48119 | 1813 | 25 |
2359333 | 2359333 | 2022-03-30 | Middlesex | Virginia | 51119 | 1813 | 45 |
2356079 | 2356079 | 2022-03-29 | Middlesex | Virginia | 51119 | 1813 | 45 |
2352826 | 2352826 | 2022-03-28 | Middlesex | Virginia | 51119 | 1813 | 45 |
2328582 | 2328582 | 2022-03-21 | Harrison | Missouri | 29081 | 1813 | 32 |
2325330 | 2325330 | 2022-03-20 | Harrison | Missouri | 29081 | 1813 | 32 |
2322076 | 2322076 | 2022-03-19 | Harrison | Missouri | 29081 | 1813 | 32 |
2318822 | 2318822 | 2022-03-18 | Harrison | Missouri | 29081 | 1813 | 32 |
2315569 | 2315569 | 2022-03-17 | Harrison | Missouri | 29081 | 1813 | 32 |
2312316 | 2312316 | 2022-03-16 | Harrison | Missouri | 29081 | 1813 | 32 |
2309063 | 2309063 | 2022-03-15 | Harrison | Missouri | 29081 | 1813 | 32 |
2287103 | 2287103 | 2022-03-08 | Arroyo | Puerto Rico | 72015 | 1813 | |
2247026 | 2247026 | 2022-02-24 | Lake | Michigan | 26085 | 1813 | 35 |
2243775 | 2243775 | 2022-02-23 | Lake | Michigan | 26085 | 1813 | 35 |
2241857 | 2241857 | 2022-02-22 | Van Buren | Tennessee | 47175 | 1813 | 46 |
2238606 | 2238606 | 2022-02-21 | Van Buren | Tennessee | 47175 | 1813 | 46 |
2235355 | 2235355 | 2022-02-20 | Van Buren | Tennessee | 47175 | 1813 | 46 |
2235552 | 2235552 | 2022-02-20 | Rains | Texas | 48379 | 1813 | 56 |
2232104 | 2232104 | 2022-02-19 | Van Buren | Tennessee | 47175 | 1813 | 46 |
2228853 | 2228853 | 2022-02-18 | Van Buren | Tennessee | 47175 | 1813 | 46 |
2225602 | 2225602 | 2022-02-17 | Van Buren | Tennessee | 47175 | 1813 | 46 |
2222351 | 2222351 | 2022-02-16 | Van Buren | Tennessee | 47175 | 1813 | 46 |
2202900 | 2202900 | 2022-02-10 | Crosby | Texas | 48107 | 1813 | 44 |
2198582 | 2198582 | 2022-02-09 | Blaine | Montana | 30005 | 1813 | 29 |
2190173 | 2190173 | 2022-02-06 | Falls Church city | Virginia | 51610 | 1813 | 14 |
2186920 | 2186920 | 2022-02-05 | Falls Church city | Virginia | 51610 | 1813 | 14 |
2183667 | 2183667 | 2022-02-04 | Falls Church city | Virginia | 51610 | 1813 | 14 |
2168856 | 2168856 | 2022-01-31 | St. Helena | Louisiana | 22091 | 1813 | 21 |
2153781 | 2153781 | 2022-01-26 | Guayanilla | Puerto Rico | 72059 | 1813 | |
2143036 | 2143036 | 2022-01-23 | Murray | Minnesota | 27101 | 1813 | 15 |
2139781 | 2139781 | 2022-01-22 | Murray | Minnesota | 27101 | 1813 | 15 |
2136525 | 2136525 | 2022-01-21 | Murray | Minnesota | 27101 | 1813 | 15 |
2130472 | 2130472 | 2022-01-19 | Los Alamos | New Mexico | 35028 | 1813 | 12 |
2127546 | 2127546 | 2022-01-18 | Blaine | Oklahoma | 40011 | 1813 | 32 |
2127877 | 2127877 | 2022-01-18 | Grant | South Dakota | 46051 | 1813 | 47 |
2124294 | 2124294 | 2022-01-17 | Blaine | Oklahoma | 40011 | 1813 | 32 |
2121042 | 2121042 | 2022-01-16 | Blaine | Oklahoma | 40011 | 1813 | 32 |
2117790 | 2117790 | 2022-01-15 | Blaine | Oklahoma | 40011 | 1813 | 32 |
2114539 | 2114539 | 2022-01-14 | Blaine | Oklahoma | 40011 | 1813 | 32 |
2111287 | 2111287 | 2022-01-13 | Blaine | Oklahoma | 40011 | 1813 | 32 |
2108035 | 2108035 | 2022-01-12 | Blaine | Oklahoma | 40011 | 1813 | 32 |
2103941 | 2103941 | 2022-01-11 | Presque Isle | Michigan | 26141 | 1813 | 52 |
2100690 | 2100690 | 2022-01-10 | Presque Isle | Michigan | 26141 | 1813 | 52 |
2092766 | 2092766 | 2022-01-07 | Summers | West Virginia | 54089 | 1813 | 39 |
2082663 | 2082663 | 2022-01-04 | Morris | Texas | 48343 | 1813 | 58 |
2077646 | 2077646 | 2022-01-03 | Edmonson | Kentucky | 21061 | 1813 | 34 |
2074339 | 2074339 | 2022-01-02 | Rice | Kansas | 20159 | 1813 | 16 |
2071088 | 2071088 | 2022-01-01 | Rice | Kansas | 20159 | 1813 | 16 |
2067837 | 2067837 | 2021-12-31 | Rice | Kansas | 20159 | 1813 | 16 |
2064586 | 2064586 | 2021-12-30 | Rice | Kansas | 20159 | 1813 | 16 |
2061336 | 2061336 | 2021-12-29 | Rice | Kansas | 20159 | 1813 | 16 |
2053114 | 2053114 | 2021-12-26 | Lake | South Dakota | 46079 | 1813 | 22 |
2047527 | 2047527 | 2021-12-25 | Pike | Arkansas | 5109 | 1813 | 39 |
2049864 | 2049864 | 2021-12-25 | Lake | South Dakota | 46079 | 1813 | 22 |
2046614 | 2046614 | 2021-12-24 | Lake | South Dakota | 46079 | 1813 | 22 |
2043364 | 2043364 | 2021-12-23 | Lake | South Dakota | 46079 | 1813 | 22 |
2035362 | 2035362 | 2021-12-21 | Wilson | Kansas | 20205 | 1813 | 34 |
2032112 | 2032112 | 2021-12-20 | Wilson | Kansas | 20205 | 1813 | 34 |
2000136 | 2000136 | 2021-12-10 | Douglas | Missouri | 29067 | 1813 | 63 |
1991199 | 1991199 | 2021-12-07 | Camuy | Puerto Rico | 72027 | 1813 | |
1987948 | 1987948 | 2021-12-06 | Camuy | Puerto Rico | 72027 | 1813 | |
1983486 | 1983486 | 2021-12-05 | Catahoula | Louisiana | 22025 | 1813 | 48 |
1984698 | 1984698 | 2021-12-05 | Camuy | Puerto Rico | 72027 | 1813 | |
1980236 | 1980236 | 2021-12-04 | Catahoula | Louisiana | 22025 | 1813 | 48 |
1976986 | 1976986 | 2021-12-03 | Catahoula | Louisiana | 22025 | 1813 | 48 |
1973737 | 1973737 | 2021-12-02 | Catahoula | Louisiana | 22025 | 1813 | 48 |
1963149 | 1963149 | 2021-11-29 | Rio Grande | Colorado | 8105 | 1813 | 29 |
1964594 | 1964594 | 2021-11-29 | Red Willow | Nebraska | 31145 | 1813 | 16 |
1951992 | 1951992 | 2021-11-25 | Vinton | Ohio | 39163 | 1813 | 34 |
1948741 | 1948741 | 2021-11-24 | Vinton | Ohio | 39163 | 1813 | 34 |
1925471 | 1925471 | 2021-11-17 | Fergus | Montana | 30027 | 1813 | 46 |
1883253 | 1883253 | 2021-11-04 | Richland | Montana | 30083 | 1813 | 21 |
1858872 | 1858872 | 2021-10-28 | Coosa | Alabama | 1037 | 1813 | 40 |
1857638 | 1857638 | 2021-10-27 | McLean | North Dakota | 38055 | 1813 | 39 |
1851343 | 1851343 | 2021-10-25 | Curry | Oregon | 41015 | 1813 | 25 |
1849061 | 1849061 | 2021-10-24 | Price | Wisconsin | 55099 | 1813 | 11 |
1845811 | 1845811 | 2021-10-23 | Price | Wisconsin | 55099 | 1813 | 11 |
1842561 | 1842561 | 2021-10-22 | Price | Wisconsin | 55099 | 1813 | 11 |
1839263 | 1839263 | 2021-10-21 | Ashland | Wisconsin | 55003 | 1813 | 16 |
1828678 | 1828678 | 2021-10-18 | Potter | Pennsylvania | 42105 | 1813 | 40 |
1823882 | 1823882 | 2021-10-17 | Pulaski | Indiana | 18131 | 1813 | 55 |
1820633 | 1820633 | 2021-10-16 | Pulaski | Indiana | 18131 | 1813 | 55 |
1817384 | 1817384 | 2021-10-15 | Pulaski | Indiana | 18131 | 1813 | 55 |
1810714 | 1810714 | 2021-10-13 | Shoshone | Idaho | 16079 | 1813 | 56 |
1807705 | 1807705 | 2021-10-12 | Hancock | Iowa | 19081 | 1813 | 39 |
1804454 | 1804454 | 2021-10-11 | Hancock | Iowa | 19081 | 1813 | 39 |
1801205 | 1801205 | 2021-10-10 | Hancock | Iowa | 19081 | 1813 | 39 |
1797956 | 1797956 | 2021-10-09 | Hancock | Iowa | 19081 | 1813 | 39 |
1794707 | 1794707 | 2021-10-08 | Hancock | Iowa | 19081 | 1813 | 39 |
1791459 | 1791459 | 2021-10-07 | Hancock | Iowa | 19081 | 1813 | 39 |
1788210 | 1788210 | 2021-10-06 | Hancock | Iowa | 19081 | 1813 | 39 |
1788929 | 1788929 | 2021-10-06 | Linn | Missouri | 29115 | 1813 | 25 |
1780606 | 1780606 | 2021-10-03 | Greensville | Virginia | 51081 | 1813 | 26 |
1777356 | 1777356 | 2021-10-02 | Greensville | Virginia | 51081 | 1813 | 26 |
1774106 | 1774106 | 2021-10-01 | Greensville | Virginia | 51081 | 1813 | 26 |
1771082 | 1771082 | 2021-09-30 | Richland | Wisconsin | 55103 | 1813 | 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);