ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
412 rows where cases = 1358 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 46
- Kansas 32
- Texas 26
- Illinois 24
- Kentucky 19
- Wisconsin 17
- Georgia 16
- Missouri 15
- Minnesota 14
- Oklahoma 13
- Alabama 12
- Virginia 12
- Mississippi 11
- Ohio 11
- Puerto Rico 11
- South Dakota 11
- Michigan 10
- Indiana 9
- Louisiana 8
- Nebraska 8
- Colorado 7
- North Dakota 7
- West Virginia 7
- Arkansas 6
- Florida 6
- North Carolina 6
- Tennessee 6
- Oregon 5
- South Carolina 5
- Pennsylvania 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500546 | 2500546 | 2022-05-13 | Phillips | Kansas | 20147 | 1358 | 30 |
2497288 | 2497288 | 2022-05-12 | Phillips | Kansas | 20147 | 1358 | 30 |
2494030 | 2494030 | 2022-05-11 | Phillips | Kansas | 20147 | 1358 | 30 |
2496025 | 2496025 | 2022-05-11 | Cumberland | Virginia | 51049 | 1358 | 27 |
2490772 | 2490772 | 2022-05-10 | Phillips | Kansas | 20147 | 1358 | 30 |
2487515 | 2487515 | 2022-05-09 | Phillips | Kansas | 20147 | 1358 | 30 |
2484257 | 2484257 | 2022-05-08 | Phillips | Kansas | 20147 | 1358 | 30 |
2480999 | 2480999 | 2022-05-07 | Phillips | Kansas | 20147 | 1358 | 30 |
2477741 | 2477741 | 2022-05-06 | Phillips | Kansas | 20147 | 1358 | 30 |
2428899 | 2428899 | 2022-04-21 | Phillips | Kansas | 20147 | 1358 | 30 |
2425643 | 2425643 | 2022-04-20 | Phillips | Kansas | 20147 | 1358 | 30 |
2422387 | 2422387 | 2022-04-19 | Phillips | Kansas | 20147 | 1358 | 30 |
2419131 | 2419131 | 2022-04-18 | Phillips | Kansas | 20147 | 1358 | 30 |
2415875 | 2415875 | 2022-04-17 | Phillips | Kansas | 20147 | 1358 | 30 |
2412619 | 2412619 | 2022-04-16 | Phillips | Kansas | 20147 | 1358 | 30 |
2409363 | 2409363 | 2022-04-15 | Phillips | Kansas | 20147 | 1358 | 30 |
2287564 | 2287564 | 2022-03-08 | Newton | Texas | 48351 | 1358 | 59 |
2221232 | 2221232 | 2022-02-16 | Atchison | Missouri | 29005 | 1358 | 19 |
2199480 | 2199480 | 2022-02-09 | Moody | South Dakota | 46101 | 1358 | 27 |
2185477 | 2185477 | 2022-02-05 | Dade | Missouri | 29057 | 1358 | 38 |
2172630 | 2172630 | 2022-02-01 | Clay | Nebraska | 31035 | 1358 | 20 |
2173413 | 2173413 | 2022-02-01 | Brule | South Dakota | 46015 | 1358 | 18 |
2169377 | 2169377 | 2022-01-31 | Clay | Nebraska | 31035 | 1358 | 17 |
2166798 | 2166798 | 2022-01-30 | Guanica | Puerto Rico | 72055 | 1358 | |
2163222 | 2163222 | 2022-01-29 | Ransom | North Dakota | 38073 | 1358 | 24 |
2153660 | 2153660 | 2022-01-26 | Harney | Oregon | 41025 | 1358 | 35 |
2149156 | 2149156 | 2022-01-25 | Stevens | Kansas | 20189 | 1358 | 17 |
2145904 | 2145904 | 2022-01-24 | Stevens | Kansas | 20189 | 1358 | 17 |
2147706 | 2147706 | 2022-01-24 | Mills | Texas | 48333 | 1358 | 29 |
2144452 | 2144452 | 2022-01-23 | Mills | Texas | 48333 | 1358 | 29 |
2109807 | 2109807 | 2022-01-13 | Pulaski | Illinois | 17153 | 1358 | 15 |
2106155 | 2106155 | 2022-01-12 | Kit Carson | Colorado | 8063 | 1358 | 28 |
2100904 | 2100904 | 2022-01-10 | Daviess | Missouri | 29061 | 1358 | 18 |
2101120 | 2101120 | 2022-01-10 | Richardson | Nebraska | 31147 | 1358 | 24 |
2081033 | 2081033 | 2022-01-04 | St. Helena | Louisiana | 22091 | 1358 | 19 |
2074873 | 2074873 | 2022-01-02 | Caldwell | Missouri | 29025 | 1358 | 26 |
2075723 | 2075723 | 2022-01-02 | Florida | Puerto Rico | 72054 | 1358 | |
2071622 | 2071622 | 2022-01-01 | Caldwell | Missouri | 29025 | 1358 | 26 |
2068371 | 2068371 | 2021-12-31 | Caldwell | Missouri | 29025 | 1358 | 26 |
2065120 | 2065120 | 2021-12-30 | Caldwell | Missouri | 29025 | 1358 | 26 |
2040176 | 2040176 | 2021-12-22 | Hancock | Tennessee | 47067 | 1358 | 21 |
2006016 | 2006016 | 2021-12-12 | Clay | Kansas | 20027 | 1358 | 31 |
2002765 | 2002765 | 2021-12-11 | Clay | Kansas | 20027 | 1358 | 31 |
1999515 | 1999515 | 2021-12-10 | Clay | Kansas | 20027 | 1358 | 31 |
1989832 | 1989832 | 2021-12-07 | Russell | Kansas | 20167 | 1358 | 34 |
1990096 | 1990096 | 2021-12-07 | Alcona | Michigan | 26001 | 1358 | 51 |
1986582 | 1986582 | 2021-12-06 | Russell | Kansas | 20167 | 1358 | 34 |
1986846 | 1986846 | 2021-12-06 | Alcona | Michigan | 26001 | 1358 | 51 |
1972589 | 1972589 | 2021-12-01 | Johnson | Wyoming | 56019 | 1358 | 16 |
1945012 | 1945012 | 2021-11-23 | Valley | Montana | 30105 | 1358 | 29 |
1939264 | 1939264 | 2021-11-21 | Allendale | South Carolina | 45005 | 1358 | 21 |
1936014 | 1936014 | 2021-11-20 | Allendale | South Carolina | 45005 | 1358 | 21 |
1936702 | 1936702 | 2021-11-20 | Clay | West Virginia | 54015 | 1358 | 21 |
1932764 | 1932764 | 2021-11-19 | Allendale | South Carolina | 45005 | 1358 | 21 |
1929513 | 1929513 | 2021-11-18 | Allendale | South Carolina | 45005 | 1358 | 21 |
1929753 | 1929753 | 2021-11-18 | Castro | Texas | 48069 | 1358 | 38 |
1925268 | 1925268 | 2021-11-17 | Choctaw | Mississippi | 28019 | 1358 | 27 |
1926263 | 1926263 | 2021-11-17 | Allendale | South Carolina | 45005 | 1358 | 21 |
1926503 | 1926503 | 2021-11-17 | Castro | Texas | 48069 | 1358 | 38 |
1922162 | 1922162 | 2021-11-16 | Monroe | Missouri | 29137 | 1358 | 13 |
1915785 | 1915785 | 2021-11-14 | Custer | Nebraska | 31041 | 1358 | 21 |
1917117 | 1917117 | 2021-11-14 | Poquoson city | Virginia | 51735 | 1358 | 22 |
1912535 | 1912535 | 2021-11-13 | Custer | Nebraska | 31041 | 1358 | 21 |
1913867 | 1913867 | 2021-11-13 | Poquoson city | Virginia | 51735 | 1358 | 22 |
1909285 | 1909285 | 2021-11-12 | Custer | Nebraska | 31041 | 1358 | 21 |
1910617 | 1910617 | 2021-11-12 | Poquoson city | Virginia | 51735 | 1358 | 22 |
1897905 | 1897905 | 2021-11-09 | Sumter | Alabama | 1119 | 1358 | 40 |
1894655 | 1894655 | 2021-11-08 | Sumter | Alabama | 1119 | 1358 | 40 |
1896283 | 1896283 | 2021-11-08 | Cheyenne | Nebraska | 31033 | 1358 | 19 |
1891405 | 1891405 | 2021-11-07 | Sumter | Alabama | 1119 | 1358 | 40 |
1888155 | 1888155 | 2021-11-06 | Sumter | Alabama | 1119 | 1358 | 40 |
1882794 | 1882794 | 2021-11-04 | Piscataquis | Maine | 23021 | 1358 | 12 |
1872166 | 1872166 | 2021-11-01 | Unknown | Connecticut | 1358 | 5 | |
1871079 | 1871079 | 2021-10-31 | Custer | South Dakota | 46033 | 1358 | 15 |
1867830 | 1867830 | 2021-10-30 | Custer | South Dakota | 46033 | 1358 | 15 |
1864581 | 1864581 | 2021-10-29 | Custer | South Dakota | 46033 | 1358 | 15 |
1861961 | 1861961 | 2021-10-28 | Doddridge | West Virginia | 54017 | 1358 | 10 |
1857258 | 1857258 | 2021-10-27 | Powell | Montana | 30077 | 1358 | 18 |
1858751 | 1858751 | 2021-10-27 | Tyler | West Virginia | 54095 | 1358 | 18 |
1853900 | 1853900 | 2021-10-26 | Iron | Missouri | 29093 | 1358 | 14 |
1834201 | 1834201 | 2021-10-20 | Clearwater | Minnesota | 27029 | 1358 | 18 |
1814289 | 1814289 | 2021-10-14 | Ellsworth | Kansas | 20053 | 1358 | 28 |
1811040 | 1811040 | 2021-10-13 | Ellsworth | Kansas | 20053 | 1358 | 28 |
1801333 | 1801333 | 2021-10-10 | Norton | Kansas | 20137 | 1358 | 30 |
1801882 | 1801882 | 2021-10-10 | Carroll | Missouri | 29033 | 1358 | 26 |
1798084 | 1798084 | 2021-10-09 | Norton | Kansas | 20137 | 1358 | 30 |
1794835 | 1794835 | 2021-10-08 | Norton | Kansas | 20137 | 1358 | 30 |
1791222 | 1791222 | 2021-10-07 | Valley | Idaho | 16085 | 1358 | 9 |
1784342 | 1784342 | 2021-10-05 | Plumas | California | 6063 | 1358 | 6 |
1758790 | 1758790 | 2021-09-27 | Marshall | Illinois | 17123 | 1358 | 23 |
1761303 | 1761303 | 2021-09-27 | Forest | Wisconsin | 55041 | 1358 | 31 |
1755593 | 1755593 | 2021-09-26 | Brown | Indiana | 18013 | 1358 | 46 |
1752345 | 1752345 | 2021-09-25 | Brown | Indiana | 18013 | 1358 | 46 |
1749096 | 1749096 | 2021-09-24 | Brown | Indiana | 18013 | 1358 | 46 |
1751228 | 1751228 | 2021-09-24 | Swisher | Texas | 48437 | 1358 | 22 |
1746494 | 1746494 | 2021-09-23 | Jackson | Minnesota | 27063 | 1358 | 12 |
1738348 | 1738348 | 2021-09-20 | Dickenson | Virginia | 51051 | 1358 | 21 |
1714094 | 1714094 | 2021-09-13 | Kemper | Mississippi | 28069 | 1358 | 37 |
1699401 | 1699401 | 2021-09-08 | Lexington city | Virginia | 51678 | 1358 | 33 |
1694041 | 1694041 | 2021-09-07 | Union | Iowa | 19175 | 1358 | 37 |
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);