ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
319 rows where cases = 1397 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 21
- Iowa 18
- Minnesota 15
- Virginia 14
- Oklahoma 13
- Puerto Rico 13
- Wisconsin 13
- Georgia 11
- South Dakota 11
- Tennessee 11
- Illinois 10
- Kentucky 10
- Alabama 9
- Louisiana 9
- Maine 9
- Michigan 9
- Missouri 9
- Texas 9
- Montana 8
- Arkansas 7
- Vermont 7
- Oregon 6
- South Carolina 6
- West Virginia 6
- Colorado 5
- Florida 5
- Indiana 5
- Mississippi 5
- New Mexico 5
- Pennsylvania 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442287 | 2442287 | 2022-04-25 | Big Stone | Minnesota | 27011 | 1397 | 8 |
2302427 | 2302427 | 2022-03-13 | Unknown | Minnesota | 1397 | 200 | |
2299175 | 2299175 | 2022-03-12 | Unknown | Minnesota | 1397 | 200 | |
2295923 | 2295923 | 2022-03-11 | Unknown | Minnesota | 1397 | 200 | |
2237071 | 2237071 | 2022-02-21 | Menifee | Kentucky | 21165 | 1397 | 30 |
2216720 | 2216720 | 2022-02-15 | Trinity | California | 6105 | 1397 | 20 |
2215701 | 2215701 | 2022-02-14 | Brule | South Dakota | 46015 | 1397 | 18 |
2209880 | 2209880 | 2022-02-12 | Wirt | West Virginia | 54105 | 1397 | 20 |
2195064 | 2195064 | 2022-02-08 | Grant | Minnesota | 27051 | 1397 | 12 |
2196804 | 2196804 | 2022-02-08 | Skamania | Washington | 53059 | 1397 | 10 |
2193549 | 2193549 | 2022-02-07 | Skamania | Washington | 53059 | 1397 | 10 |
2167619 | 2167619 | 2022-01-30 | Iron | Wisconsin | 55051 | 1397 | 45 |
2164364 | 2164364 | 2022-01-29 | Iron | Wisconsin | 55051 | 1397 | 45 |
2161109 | 2161109 | 2022-01-28 | Iron | Wisconsin | 55051 | 1397 | 45 |
2119344 | 2119344 | 2022-01-16 | Hancock | Georgia | 13141 | 1397 | 83 |
2116092 | 2116092 | 2022-01-15 | Hancock | Georgia | 13141 | 1397 | 83 |
2112841 | 2112841 | 2022-01-14 | Hancock | Georgia | 13141 | 1397 | 83 |
2109558 | 2109558 | 2022-01-13 | Crawford | Georgia | 13079 | 1397 | 48 |
2110062 | 2110062 | 2022-01-13 | Greenwood | Kansas | 20073 | 1397 | 18 |
2106811 | 2106811 | 2022-01-12 | Greenwood | Kansas | 20073 | 1397 | 18 |
2104997 | 2104997 | 2022-01-11 | Jayuya | Puerto Rico | 72073 | 1397 | |
2100952 | 2100952 | 2022-01-10 | Ozark | Missouri | 29153 | 1397 | 48 |
2101746 | 2101746 | 2022-01-10 | Jayuya | Puerto Rico | 72073 | 1397 | |
2098827 | 2098827 | 2022-01-09 | Floyd | Texas | 48153 | 1397 | 41 |
2079752 | 2079752 | 2022-01-03 | Pocahontas | West Virginia | 54075 | 1397 | 22 |
2066019 | 2066019 | 2021-12-30 | Villalba | Puerto Rico | 72149 | 1397 | |
2058778 | 2058778 | 2021-12-28 | Valley | Montana | 30105 | 1397 | 32 |
2059447 | 2059447 | 2021-12-28 | Aibonito | Puerto Rico | 72009 | 1397 | |
2055529 | 2055529 | 2021-12-27 | Valley | Montana | 30105 | 1397 | 32 |
2052279 | 2052279 | 2021-12-26 | Valley | Montana | 30105 | 1397 | 32 |
2049029 | 2049029 | 2021-12-25 | Valley | Montana | 30105 | 1397 | 32 |
2045779 | 2045779 | 2021-12-24 | Valley | Montana | 30105 | 1397 | 32 |
2041037 | 2041037 | 2021-12-23 | Searcy | Arkansas | 5129 | 1397 | 28 |
2042529 | 2042529 | 2021-12-23 | Valley | Montana | 30105 | 1397 | 32 |
2028806 | 2028806 | 2021-12-19 | Kingman | Kansas | 20095 | 1397 | 24 |
2025555 | 2025555 | 2021-12-18 | Kingman | Kansas | 20095 | 1397 | 24 |
2022304 | 2022304 | 2021-12-17 | Kingman | Kansas | 20095 | 1397 | 24 |
1989824 | 1989824 | 2021-12-07 | Pratt | Kansas | 20151 | 1397 | 27 |
1986574 | 1986574 | 2021-12-06 | Pratt | Kansas | 20151 | 1397 | 27 |
1975911 | 1975911 | 2021-12-03 | Sumter | Alabama | 1119 | 1397 | 41 |
1972662 | 1972662 | 2021-12-02 | Sumter | Alabama | 1119 | 1397 | 41 |
1968298 | 1968298 | 2021-11-30 | Major | Oklahoma | 40093 | 1397 | 32 |
1965047 | 1965047 | 2021-11-29 | Major | Oklahoma | 40093 | 1397 | 32 |
1961795 | 1961795 | 2021-11-28 | Major | Oklahoma | 40093 | 1397 | 32 |
1958544 | 1958544 | 2021-11-27 | Major | Oklahoma | 40093 | 1397 | 32 |
1955293 | 1955293 | 2021-11-26 | Major | Oklahoma | 40093 | 1397 | 32 |
1952042 | 1952042 | 2021-11-25 | Major | Oklahoma | 40093 | 1397 | 32 |
1948791 | 1948791 | 2021-11-24 | Major | Oklahoma | 40093 | 1397 | 32 |
1936703 | 1936703 | 2021-11-20 | Doddridge | West Virginia | 54017 | 1397 | 11 |
1930240 | 1930240 | 2021-11-18 | Tyler | West Virginia | 54095 | 1397 | 24 |
1924003 | 1924003 | 2021-11-17 | Nevada | Arkansas | 5099 | 1397 | 40 |
1882968 | 1882968 | 2021-11-04 | Marshall | Minnesota | 27089 | 1397 | 21 |
1869943 | 1869943 | 2021-10-31 | Clearwater | Minnesota | 27029 | 1397 | 18 |
1866694 | 1866694 | 2021-10-30 | Clearwater | Minnesota | 27029 | 1397 | 18 |
1863445 | 1863445 | 2021-10-29 | Clearwater | Minnesota | 27029 | 1397 | 18 |
1859901 | 1859901 | 2021-10-28 | Hancock | Kentucky | 21091 | 1397 | 17 |
1853206 | 1853206 | 2021-10-26 | Keokuk | Iowa | 19107 | 1397 | 35 |
1853427 | 1853427 | 2021-10-26 | Livingston | Kentucky | 21139 | 1397 | 42 |
1849957 | 1849957 | 2021-10-25 | Keokuk | Iowa | 19107 | 1397 | 35 |
1846707 | 1846707 | 2021-10-24 | Keokuk | Iowa | 19107 | 1397 | 35 |
1843457 | 1843457 | 2021-10-23 | Keokuk | Iowa | 19107 | 1397 | 35 |
1840207 | 1840207 | 2021-10-22 | Keokuk | Iowa | 19107 | 1397 | 35 |
1836958 | 1836958 | 2021-10-21 | Keokuk | Iowa | 19107 | 1397 | 35 |
1833709 | 1833709 | 2021-10-20 | Keokuk | Iowa | 19107 | 1397 | 35 |
1824274 | 1824274 | 2021-10-17 | Red River | Louisiana | 22081 | 1397 | 48 |
1821025 | 1821025 | 2021-10-16 | Red River | Louisiana | 22081 | 1397 | 48 |
1821405 | 1821405 | 2021-10-16 | Howard | Missouri | 29089 | 1397 | 12 |
1816737 | 1816737 | 2021-10-15 | Cleveland | Arkansas | 5025 | 1397 | 32 |
1817776 | 1817776 | 2021-10-15 | Red River | Louisiana | 22081 | 1397 | 48 |
1803865 | 1803865 | 2021-10-11 | Archuleta | Colorado | 8007 | 1397 | 4 |
1804277 | 1804277 | 2021-10-11 | Marshall | Illinois | 17123 | 1397 | 23 |
1801028 | 1801028 | 2021-10-10 | Marshall | Illinois | 17123 | 1397 | 23 |
1797779 | 1797779 | 2021-10-09 | Marshall | Illinois | 17123 | 1397 | 23 |
1794530 | 1794530 | 2021-10-08 | Marshall | Illinois | 17123 | 1397 | 23 |
1779999 | 1779999 | 2021-10-03 | Lares | Puerto Rico | 72081 | 1397 | |
1780218 | 1780218 | 2021-10-03 | Moore | Tennessee | 47127 | 1397 | 19 |
1780873 | 1780873 | 2021-10-03 | Washakie | Wyoming | 56043 | 1397 | 27 |
1776968 | 1776968 | 2021-10-02 | Moore | Tennessee | 47127 | 1397 | 19 |
1777623 | 1777623 | 2021-10-02 | Washakie | Wyoming | 56043 | 1397 | 27 |
1773718 | 1773718 | 2021-10-01 | Moore | Tennessee | 47127 | 1397 | 19 |
1774373 | 1774373 | 2021-10-01 | Washakie | Wyoming | 56043 | 1397 | 27 |
1770713 | 1770713 | 2021-09-30 | Somervell | Texas | 48425 | 1397 | 20 |
1761972 | 1761972 | 2021-09-28 | Owyhee | Idaho | 16073 | 1397 | 36 |
1750738 | 1750738 | 2021-09-24 | Coamo | Puerto Rico | 72043 | 1397 | |
1746771 | 1746771 | 2021-09-23 | Jefferson | Montana | 30043 | 1397 | 9 |
1747489 | 1747489 | 2021-09-23 | Coamo | Puerto Rico | 72043 | 1397 | |
1744239 | 1744239 | 2021-09-22 | Coamo | Puerto Rico | 72043 | 1397 | |
1744860 | 1744860 | 2021-09-22 | Galax city | Virginia | 51640 | 1397 | 56 |
1718229 | 1718229 | 2021-09-14 | Anasco | Puerto Rico | 72011 | 1397 | |
1714981 | 1714981 | 2021-09-13 | Anasco | Puerto Rico | 72011 | 1397 | |
1700252 | 1700252 | 2021-09-09 | Teton | Idaho | 16081 | 1397 | 4 |
1693732 | 1693732 | 2021-09-07 | Clearwater | Idaho | 16035 | 1397 | 17 |
1676915 | 1676915 | 2021-09-02 | Bullock | Alabama | 1011 | 1397 | 41 |
1676323 | 1676323 | 2021-09-01 | Childress | Texas | 48075 | 1397 | 18 |
1671316 | 1671316 | 2021-08-31 | Brown | Kansas | 20013 | 1397 | 39 |
1667640 | 1667640 | 2021-08-30 | Johnson | Georgia | 13167 | 1397 | 50 |
1668069 | 1668069 | 2021-08-30 | Brown | Kansas | 20013 | 1397 | 39 |
1668756 | 1668756 | 2021-08-30 | Ripley | Missouri | 29181 | 1397 | 19 |
1666155 | 1666155 | 2021-08-29 | Curry | Oregon | 41015 | 1397 | 14 |
1662907 | 1662907 | 2021-08-28 | Curry | Oregon | 41015 | 1397 | 14 |
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);