ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
338 rows where cases = 1571 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 34
- Georgia 32
- Texas 29
- Missouri 20
- Illinois 18
- Arkansas 13
- Michigan 13
- Minnesota 13
- Colorado 12
- Mississippi 11
- Virginia 11
- Kentucky 10
- Tennessee 10
- Kansas 9
- Louisiana 8
- Montana 8
- Nebraska 8
- Puerto Rico 8
- Alabama 7
- New York 6
- West Virginia 6
- South Carolina 5
- Washington 5
- Florida 4
- New Mexico 4
- North Dakota 4
- Pennsylvania 4
- Wisconsin 4
- Idaho 3
- Indiana 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2460743 | 2460743 | 2022-05-01 | Clear Creek | Colorado | 8019 | 1571 | 12 |
2457487 | 2457487 | 2022-04-30 | Clear Creek | Colorado | 8019 | 1571 | 12 |
2454231 | 2454231 | 2022-04-29 | Clear Creek | Colorado | 8019 | 1571 | 12 |
2285222 | 2285222 | 2022-03-08 | Hancock | Georgia | 13141 | 1571 | 87 |
2281970 | 2281970 | 2022-03-07 | Hancock | Georgia | 13141 | 1571 | 87 |
2278534 | 2278534 | 2022-03-06 | Kit Carson | Colorado | 8063 | 1571 | 30 |
2275281 | 2275281 | 2022-03-05 | Kit Carson | Colorado | 8063 | 1571 | 30 |
2272028 | 2272028 | 2022-03-04 | Kit Carson | Colorado | 8063 | 1571 | 30 |
2268776 | 2268776 | 2022-03-03 | Kit Carson | Colorado | 8063 | 1571 | 30 |
2265523 | 2265523 | 2022-03-02 | Kit Carson | Colorado | 8063 | 1571 | 30 |
2262792 | 2262792 | 2022-03-01 | Adair | Iowa | 19001 | 1571 | 50 |
2262867 | 2262867 | 2022-03-01 | Pocahontas | Iowa | 19151 | 1571 | 27 |
2259541 | 2259541 | 2022-02-28 | Adair | Iowa | 19001 | 1571 | 50 |
2259616 | 2259616 | 2022-02-28 | Pocahontas | Iowa | 19151 | 1571 | 27 |
2255770 | 2255770 | 2022-02-27 | Kit Carson | Colorado | 8063 | 1571 | 30 |
2256290 | 2256290 | 2022-02-27 | Adair | Iowa | 19001 | 1571 | 50 |
2256365 | 2256365 | 2022-02-27 | Pocahontas | Iowa | 19151 | 1571 | 27 |
2252519 | 2252519 | 2022-02-26 | Kit Carson | Colorado | 8063 | 1571 | 30 |
2253039 | 2253039 | 2022-02-26 | Adair | Iowa | 19001 | 1571 | 50 |
2253114 | 2253114 | 2022-02-26 | Pocahontas | Iowa | 19151 | 1571 | 27 |
2249268 | 2249268 | 2022-02-25 | Kit Carson | Colorado | 8063 | 1571 | 30 |
2249788 | 2249788 | 2022-02-25 | Adair | Iowa | 19001 | 1571 | 50 |
2249863 | 2249863 | 2022-02-25 | Pocahontas | Iowa | 19151 | 1571 | 27 |
2246537 | 2246537 | 2022-02-24 | Adair | Iowa | 19001 | 1571 | 50 |
2246612 | 2246612 | 2022-02-24 | Pocahontas | Iowa | 19151 | 1571 | 27 |
2243286 | 2243286 | 2022-02-23 | Adair | Iowa | 19001 | 1571 | 50 |
2243361 | 2243361 | 2022-02-23 | Pocahontas | Iowa | 19151 | 1571 | 27 |
2237997 | 2237997 | 2022-02-21 | Bottineau | North Dakota | 38009 | 1571 | 25 |
2224578 | 2224578 | 2022-02-17 | Shannon | Missouri | 29203 | 1571 | 34 |
2221327 | 2221327 | 2022-02-16 | Shannon | Missouri | 29203 | 1571 | 34 |
2211348 | 2211348 | 2022-02-13 | Mahnomen | Minnesota | 27087 | 1571 | 17 |
2208095 | 2208095 | 2022-02-12 | Mahnomen | Minnesota | 27087 | 1571 | 17 |
2204842 | 2204842 | 2022-02-11 | Mahnomen | Minnesota | 27087 | 1571 | 17 |
2178957 | 2178957 | 2022-02-03 | Caldwell | Missouri | 29025 | 1571 | 30 |
2167545 | 2167545 | 2022-01-30 | Calhoun | West Virginia | 54013 | 1571 | 10 |
2142944 | 2142944 | 2022-01-23 | Lake | Michigan | 26085 | 1571 | 33 |
2139689 | 2139689 | 2022-01-22 | Lake | Michigan | 26085 | 1571 | 33 |
2136433 | 2136433 | 2022-01-21 | Lake | Michigan | 26085 | 1571 | 33 |
2132928 | 2132928 | 2022-01-20 | Elliott | Kentucky | 21063 | 1571 | 14 |
2134769 | 2134769 | 2022-01-20 | Winkler | Texas | 48495 | 1571 | 33 |
2130403 | 2130403 | 2022-01-19 | Wayne | Nebraska | 31179 | 1571 | 11 |
2122683 | 2122683 | 2022-01-17 | Wilcox | Georgia | 13315 | 1571 | 61 |
2119409 | 2119409 | 2022-01-16 | Terrell | Georgia | 13273 | 1571 | 58 |
2116157 | 2116157 | 2022-01-15 | Terrell | Georgia | 13273 | 1571 | 58 |
2112550 | 2112550 | 2022-01-14 | Prairie | Arkansas | 5117 | 1571 | 32 |
2112906 | 2112906 | 2022-01-14 | Terrell | Georgia | 13273 | 1571 | 58 |
2114390 | 2114390 | 2022-01-14 | Benson | North Dakota | 38005 | 1571 | 22 |
2110667 | 2110667 | 2022-01-13 | Harrison | Missouri | 29081 | 1571 | 26 |
2082890 | 2082890 | 2022-01-04 | Poquoson city | Virginia | 51735 | 1571 | 23 |
2060909 | 2060909 | 2021-12-29 | Wilkinson | Georgia | 13319 | 1571 | 46 |
2017869 | 2017869 | 2021-12-15 | Nelson | Virginia | 51125 | 1571 | 23 |
2009404 | 2009404 | 2021-12-13 | Hancock | Kentucky | 21091 | 1571 | 18 |
1996725 | 1996725 | 2021-12-09 | Marshall | Minnesota | 27089 | 1571 | 22 |
1997898 | 1997898 | 2021-12-09 | Clay | Tennessee | 47027 | 1571 | 37 |
1992576 | 1992576 | 2021-12-08 | Johnson | Georgia | 13167 | 1571 | 64 |
1994647 | 1994647 | 2021-12-08 | Clay | Tennessee | 47027 | 1571 | 37 |
1989325 | 1989325 | 2021-12-07 | Johnson | Georgia | 13167 | 1571 | 64 |
1990471 | 1990471 | 2021-12-07 | Carbon | Montana | 30009 | 1571 | 22 |
1986075 | 1986075 | 2021-12-06 | Johnson | Georgia | 13167 | 1571 | 64 |
1982825 | 1982825 | 2021-12-05 | Johnson | Georgia | 13167 | 1571 | 64 |
1983012 | 1983012 | 2021-12-05 | Marshall | Illinois | 17123 | 1571 | 25 |
1979575 | 1979575 | 2021-12-04 | Johnson | Georgia | 13167 | 1571 | 64 |
1979762 | 1979762 | 2021-12-04 | Marshall | Illinois | 17123 | 1571 | 25 |
1976325 | 1976325 | 2021-12-03 | Johnson | Georgia | 13167 | 1571 | 64 |
1976512 | 1976512 | 2021-12-03 | Marshall | Illinois | 17123 | 1571 | 25 |
1972402 | 1972402 | 2021-12-01 | Sussex | Virginia | 51183 | 1571 | 29 |
1967632 | 1967632 | 2021-11-30 | DeKalb | Missouri | 29063 | 1571 | 36 |
1969152 | 1969152 | 2021-11-30 | Sussex | Virginia | 51183 | 1571 | 29 |
1965902 | 1965902 | 2021-11-29 | Sussex | Virginia | 51183 | 1571 | 29 |
1955152 | 1955152 | 2021-11-26 | Traill | North Dakota | 38097 | 1571 | 21 |
1940258 | 1940258 | 2021-11-22 | Perry | Arkansas | 5105 | 1571 | 22 |
1937393 | 1937393 | 2021-11-21 | Wilkes | Georgia | 13317 | 1571 | 38 |
1934143 | 1934143 | 2021-11-20 | Wilkes | Georgia | 13317 | 1571 | 38 |
1930891 | 1930891 | 2021-11-19 | Wilkes | Georgia | 13317 | 1571 | 38 |
1920148 | 1920148 | 2021-11-15 | Ochiltree | Texas | 48357 | 1571 | 37 |
1915680 | 1915680 | 2021-11-14 | Ralls | Missouri | 29173 | 1571 | 14 |
1916898 | 1916898 | 2021-11-14 | Ochiltree | Texas | 48357 | 1571 | 37 |
1913648 | 1913648 | 2021-11-13 | Ochiltree | Texas | 48357 | 1571 | 37 |
1895007 | 1895007 | 2021-11-08 | Candler | Georgia | 13043 | 1571 | 87 |
1891757 | 1891757 | 2021-11-07 | Candler | Georgia | 13043 | 1571 | 87 |
1892345 | 1892345 | 2021-11-07 | Wilson | Kansas | 20205 | 1571 | 33 |
1894432 | 1894432 | 2021-11-07 | Pend Oreille | Washington | 53051 | 1571 | 22 |
1888507 | 1888507 | 2021-11-06 | Candler | Georgia | 13043 | 1571 | 87 |
1889095 | 1889095 | 2021-11-06 | Wilson | Kansas | 20205 | 1571 | 33 |
1891182 | 1891182 | 2021-11-06 | Pend Oreille | Washington | 53051 | 1571 | 22 |
1885257 | 1885257 | 2021-11-05 | Candler | Georgia | 13043 | 1571 | 87 |
1885845 | 1885845 | 2021-11-05 | Wilson | Kansas | 20205 | 1571 | 33 |
1887932 | 1887932 | 2021-11-05 | Pend Oreille | Washington | 53051 | 1571 | 22 |
1882008 | 1882008 | 2021-11-04 | Candler | Georgia | 13043 | 1571 | 87 |
1878646 | 1878646 | 2021-11-03 | Rio Grande | Colorado | 8105 | 1571 | 23 |
1880865 | 1880865 | 2021-11-03 | Roberts | South Dakota | 46109 | 1571 | 43 |
1875934 | 1875934 | 2021-11-02 | Guthrie | Iowa | 19077 | 1571 | 34 |
1872685 | 1872685 | 2021-11-01 | Guthrie | Iowa | 19077 | 1571 | 34 |
1869436 | 1869436 | 2021-10-31 | Guthrie | Iowa | 19077 | 1571 | 34 |
1866187 | 1866187 | 2021-10-30 | Guthrie | Iowa | 19077 | 1571 | 34 |
1862938 | 1862938 | 2021-10-29 | Guthrie | Iowa | 19077 | 1571 | 34 |
1859689 | 1859689 | 2021-10-28 | Guthrie | Iowa | 19077 | 1571 | 34 |
1856016 | 1856016 | 2021-10-27 | Candler | Georgia | 13043 | 1571 | 87 |
1856440 | 1856440 | 2021-10-27 | Guthrie | Iowa | 19077 | 1571 | 34 |
1852767 | 1852767 | 2021-10-26 | Candler | Georgia | 13043 | 1571 | 87 |
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);