ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
249 rows where cases = 2175 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 24
- Kentucky 19
- Texas 12
- Georgia 11
- Minnesota 11
- Tennessee 11
- Oregon 10
- West Virginia 10
- Arkansas 9
- Nebraska 9
- Florida 8
- Indiana 8
- Iowa 8
- Missouri 8
- North Carolina 8
- Washington 8
- Alabama 7
- Illinois 6
- Mississippi 6
- Ohio 6
- South Carolina 6
- New York 4
- Puerto Rico 4
- Idaho 3
- Louisiana 3
- Montana 3
- Pennsylvania 3
- Vermont 3
- California 2
- Kansas 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500919 | 2500919 | 2022-05-13 | Clearwater | Minnesota | 27029 | 2175 | 30 |
2497661 | 2497661 | 2022-05-12 | Clearwater | Minnesota | 27029 | 2175 | 30 |
2494403 | 2494403 | 2022-05-11 | Clearwater | Minnesota | 27029 | 2175 | 30 |
2475083 | 2475083 | 2022-05-05 | Monroe | Missouri | 29137 | 2175 | 43 |
2450485 | 2450485 | 2022-04-27 | Northumberland | Virginia | 51133 | 2175 | 46 |
2446843 | 2446843 | 2022-04-26 | Archer | Texas | 48009 | 2175 | 28 |
2404278 | 2404278 | 2022-04-13 | Rincon | Puerto Rico | 72117 | 2175 | |
2376474 | 2376474 | 2022-04-05 | Hamilton | Illinois | 17065 | 2175 | 34 |
2373222 | 2373222 | 2022-04-04 | Hamilton | Illinois | 17065 | 2175 | 34 |
2324831 | 2324831 | 2022-03-20 | Gallatin | Kentucky | 21077 | 2175 | 46 |
2321577 | 2321577 | 2022-03-19 | Gallatin | Kentucky | 21077 | 2175 | 46 |
2318323 | 2318323 | 2022-03-18 | Gallatin | Kentucky | 21077 | 2175 | 46 |
2315070 | 2315070 | 2022-03-17 | Gallatin | Kentucky | 21077 | 2175 | 46 |
2311817 | 2311817 | 2022-03-16 | Gallatin | Kentucky | 21077 | 2175 | 46 |
2312307 | 2312307 | 2022-03-16 | DeKalb | Missouri | 29063 | 2175 | 45 |
2308564 | 2308564 | 2022-03-15 | Gallatin | Kentucky | 21077 | 2175 | 46 |
2305313 | 2305313 | 2022-03-14 | Gallatin | Kentucky | 21077 | 2175 | 46 |
2292810 | 2292810 | 2022-03-10 | Iron | Missouri | 29093 | 2175 | 40 |
2271582 | 2271582 | 2022-03-03 | Lincoln | Washington | 53043 | 2175 | 27 |
2268330 | 2268330 | 2022-03-02 | Lincoln | Washington | 53043 | 2175 | 27 |
2244446 | 2244446 | 2022-02-23 | Jones | North Carolina | 37103 | 2175 | 38 |
2237730 | 2237730 | 2022-02-21 | Red Willow | Nebraska | 31145 | 2175 | 19 |
2234479 | 2234479 | 2022-02-20 | Red Willow | Nebraska | 31145 | 2175 | 19 |
2231228 | 2231228 | 2022-02-19 | Red Willow | Nebraska | 31145 | 2175 | 19 |
2227977 | 2227977 | 2022-02-18 | Red Willow | Nebraska | 31145 | 2175 | 19 |
2223084 | 2223084 | 2022-02-17 | Greenlee | Arizona | 4011 | 2175 | 31 |
2224660 | 2224660 | 2022-02-17 | Box Butte | Nebraska | 31013 | 2175 | 16 |
2220307 | 2220307 | 2022-02-16 | Clearwater | Idaho | 16035 | 2175 | 31 |
2217056 | 2217056 | 2022-02-15 | Clearwater | Idaho | 16035 | 2175 | 31 |
2217601 | 2217601 | 2022-02-15 | Wolfe | Kentucky | 21237 | 2175 | 18 |
2218158 | 2218158 | 2022-02-15 | Box Butte | Nebraska | 31013 | 2175 | 16 |
2215683 | 2215683 | 2022-02-14 | McCormick | South Carolina | 45065 | 2175 | 36 |
2209491 | 2209491 | 2022-02-12 | La Salle | Texas | 48283 | 2175 | 42 |
2206238 | 2206238 | 2022-02-11 | La Salle | Texas | 48283 | 2175 | 42 |
2202615 | 2202615 | 2022-02-10 | Sabana Grande | Puerto Rico | 72121 | 2175 | |
2199259 | 2199259 | 2022-02-09 | Forest | Pennsylvania | 42053 | 2175 | 34 |
2165216 | 2165216 | 2022-01-30 | Switzerland | Indiana | 18155 | 2175 | 15 |
2167462 | 2167462 | 2022-01-30 | Poquoson city | Virginia | 51735 | 2175 | 24 |
2161961 | 2161961 | 2022-01-29 | Switzerland | Indiana | 18155 | 2175 | 15 |
2164207 | 2164207 | 2022-01-29 | Poquoson city | Virginia | 51735 | 2175 | 24 |
2158706 | 2158706 | 2022-01-28 | Switzerland | Indiana | 18155 | 2175 | 15 |
2160952 | 2160952 | 2022-01-28 | Poquoson city | Virginia | 51735 | 2175 | 24 |
2144301 | 2144301 | 2022-01-23 | Blanco | Texas | 48031 | 2175 | 29 |
2144807 | 2144807 | 2022-01-23 | Summers | West Virginia | 54089 | 2175 | 43 |
2133258 | 2133258 | 2022-01-20 | Koochiching | Minnesota | 27071 | 2175 | 32 |
2110202 | 2110202 | 2022-01-13 | Lyon | Kentucky | 21143 | 2175 | 31 |
2102644 | 2102644 | 2022-01-11 | Coosa | Alabama | 1037 | 2175 | 48 |
2100036 | 2100036 | 2022-01-10 | Marshall | Illinois | 17123 | 2175 | 26 |
2102031 | 2102031 | 2022-01-10 | Callahan | Texas | 48059 | 2175 | 61 |
2061778 | 2061778 | 2021-12-29 | Amite | Mississippi | 28005 | 2175 | 58 |
2040504 | 2040504 | 2021-12-22 | Juab | Utah | 49023 | 2175 | 20 |
2035219 | 2035219 | 2021-12-21 | Lyon | Iowa | 19119 | 2175 | 42 |
2031969 | 2031969 | 2021-12-20 | Lyon | Iowa | 19119 | 2175 | 42 |
2028718 | 2028718 | 2021-12-19 | Lyon | Iowa | 19119 | 2175 | 42 |
2025467 | 2025467 | 2021-12-18 | Lyon | Iowa | 19119 | 2175 | 42 |
2022216 | 2022216 | 2021-12-17 | Lyon | Iowa | 19119 | 2175 | 42 |
2018965 | 2018965 | 2021-12-16 | Lyon | Iowa | 19119 | 2175 | 42 |
2015715 | 2015715 | 2021-12-15 | Lyon | Iowa | 19119 | 2175 | 42 |
2005725 | 2005725 | 2021-12-12 | Cumberland | Illinois | 17035 | 2175 | 40 |
2002474 | 2002474 | 2021-12-11 | Cumberland | Illinois | 17035 | 2175 | 40 |
1999224 | 1999224 | 2021-12-10 | Cumberland | Illinois | 17035 | 2175 | 40 |
1973797 | 1973797 | 2021-12-02 | Lincoln | Maine | 23015 | 2175 | 10 |
1969639 | 1969639 | 2021-12-01 | Moffat | Colorado | 8081 | 2175 | 47 |
1961830 | 1961830 | 2021-11-28 | Baker | Oregon | 41001 | 2175 | 31 |
1958579 | 1958579 | 2021-11-27 | Baker | Oregon | 41001 | 2175 | 31 |
1955328 | 1955328 | 2021-11-26 | Baker | Oregon | 41001 | 2175 | 31 |
1952077 | 1952077 | 2021-11-25 | Baker | Oregon | 41001 | 2175 | 31 |
1948826 | 1948826 | 2021-11-24 | Baker | Oregon | 41001 | 2175 | 31 |
1944799 | 1944799 | 2021-11-23 | Lawrence | Mississippi | 28077 | 2175 | 40 |
1939454 | 1939454 | 2021-11-21 | Stewart | Tennessee | 47161 | 2175 | 35 |
1936204 | 1936204 | 2021-11-20 | Stewart | Tennessee | 47161 | 2175 | 35 |
1932954 | 1932954 | 2021-11-19 | Stewart | Tennessee | 47161 | 2175 | 35 |
1927173 | 1927173 | 2021-11-18 | Kusilvak Census Area | Alaska | 2158 | 2175 | 9 |
1929515 | 1929515 | 2021-11-18 | Bamberg | South Carolina | 45009 | 2175 | 63 |
1926265 | 1926265 | 2021-11-17 | Bamberg | South Carolina | 45009 | 2175 | 63 |
1923015 | 1923015 | 2021-11-16 | Bamberg | South Carolina | 45009 | 2175 | 63 |
1919766 | 1919766 | 2021-11-15 | Bamberg | South Carolina | 45009 | 2175 | 63 |
1915751 | 1915751 | 2021-11-14 | Roosevelt | Montana | 30085 | 2175 | 60 |
1912501 | 1912501 | 2021-11-13 | Roosevelt | Montana | 30085 | 2175 | 60 |
1909251 | 1909251 | 2021-11-12 | Roosevelt | Montana | 30085 | 2175 | 60 |
1884288 | 1884288 | 2021-11-04 | Eastland | Texas | 48133 | 2175 | 78 |
1881039 | 1881039 | 2021-11-03 | Eastland | Texas | 48133 | 2175 | 78 |
1850491 | 1850491 | 2021-10-25 | Pennington | Minnesota | 27113 | 2175 | 27 |
1836290 | 1836290 | 2021-10-21 | Van Buren | Arkansas | 5141 | 2175 | 40 |
1834418 | 1834418 | 2021-10-20 | Macon | Missouri | 29121 | 2175 | 20 |
1832818 | 1832818 | 2021-10-19 | Rusk | Wisconsin | 55107 | 2175 | 33 |
1829283 | 1829283 | 2021-10-18 | Windham | Vermont | 50025 | 2175 | 24 |
1813721 | 1813721 | 2021-10-14 | Lafayette | Florida | 12067 | 2175 | 32 |
1810472 | 1810472 | 2021-10-13 | Lafayette | Florida | 12067 | 2175 | 32 |
1807223 | 1807223 | 2021-10-12 | Lafayette | Florida | 12067 | 2175 | 32 |
1803972 | 1803972 | 2021-10-11 | Lafayette | Florida | 12067 | 2175 | 32 |
1800723 | 1800723 | 2021-10-10 | Lafayette | Florida | 12067 | 2175 | 32 |
1797474 | 1797474 | 2021-10-09 | Lafayette | Florida | 12067 | 2175 | 32 |
1794225 | 1794225 | 2021-10-08 | Lafayette | Florida | 12067 | 2175 | 32 |
1796788 | 1796788 | 2021-10-08 | Orleans | Vermont | 50019 | 2175 | 13 |
1772629 | 1772629 | 2021-10-01 | Bates | Missouri | 29013 | 2175 | 39 |
1762439 | 1762439 | 2021-09-28 | Knott | Kentucky | 21119 | 2175 | 32 |
1757113 | 1757113 | 2021-09-26 | Clatsop | Oregon | 41007 | 2175 | 26 |
1753865 | 1753865 | 2021-09-25 | Clatsop | Oregon | 41007 | 2175 | 26 |
1750617 | 1750617 | 2021-09-24 | Clatsop | Oregon | 41007 | 2175 | 26 |
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);