ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
370 rows where cases = 1372 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 24
- Oklahoma 19
- Puerto Rico 19
- Arkansas 18
- Kansas 18
- Kentucky 17
- Georgia 16
- Virginia 16
- Indiana 15
- West Virginia 15
- South Dakota 13
- Alabama 12
- Iowa 12
- Minnesota 12
- Wisconsin 11
- Missouri 10
- Tennessee 10
- Nebraska 9
- South Carolina 9
- Illinois 8
- Michigan 8
- North Carolina 8
- California 7
- Pennsylvania 7
- Washington 6
- Mississippi 5
- Utah 5
- Colorado 4
- Florida 4
- Montana 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492896 | 2492896 | 2022-05-10 | San Juan | Washington | 53055 | 1372 | 2 |
2489638 | 2489638 | 2022-05-09 | San Juan | Washington | 53055 | 1372 | 2 |
2391216 | 2391216 | 2022-04-09 | Ceiba | Puerto Rico | 72037 | 1372 | |
2376672 | 2376672 | 2022-04-05 | Fremont | Iowa | 19071 | 1372 | 25 |
2373420 | 2373420 | 2022-04-04 | Fremont | Iowa | 19071 | 1372 | 25 |
2370167 | 2370167 | 2022-04-03 | Fremont | Iowa | 19071 | 1372 | 25 |
2366914 | 2366914 | 2022-04-02 | Fremont | Iowa | 19071 | 1372 | 25 |
2363661 | 2363661 | 2022-04-01 | Fremont | Iowa | 19071 | 1372 | 25 |
2360407 | 2360407 | 2022-03-31 | Fremont | Iowa | 19071 | 1372 | 25 |
2357153 | 2357153 | 2022-03-30 | Fremont | Iowa | 19071 | 1372 | 25 |
2265065 | 2265065 | 2022-03-01 | Ferry | Washington | 53019 | 1372 | 27 |
2260993 | 2260993 | 2022-02-28 | Lake | Oregon | 41037 | 1372 | 24 |
2261815 | 2261815 | 2022-02-28 | Ferry | Washington | 53019 | 1372 | 27 |
2258018 | 2258018 | 2022-02-27 | Tripp | South Dakota | 46123 | 1372 | 23 |
2254767 | 2254767 | 2022-02-26 | Tripp | South Dakota | 46123 | 1372 | 23 |
2251516 | 2251516 | 2022-02-25 | Tripp | South Dakota | 46123 | 1372 | 23 |
2248265 | 2248265 | 2022-02-24 | Tripp | South Dakota | 46123 | 1372 | 23 |
2233820 | 2233820 | 2022-02-20 | Menifee | Kentucky | 21165 | 1372 | 30 |
2230569 | 2230569 | 2022-02-19 | Menifee | Kentucky | 21165 | 1372 | 30 |
2227318 | 2227318 | 2022-02-18 | Menifee | Kentucky | 21165 | 1372 | 30 |
2213503 | 2213503 | 2022-02-14 | Huerfano | Colorado | 8055 | 1372 | 28 |
2210522 | 2210522 | 2022-02-13 | Wheeler | Georgia | 13309 | 1372 | 38 |
2207269 | 2207269 | 2022-02-12 | Wheeler | Georgia | 13309 | 1372 | 38 |
2204016 | 2204016 | 2022-02-11 | Wheeler | Georgia | 13309 | 1372 | 38 |
2149827 | 2149827 | 2022-01-25 | Stillwater | Montana | 30095 | 1372 | 29 |
2134386 | 2134386 | 2022-01-20 | Hamlin | South Dakota | 46057 | 1372 | 40 |
2128898 | 2128898 | 2022-01-19 | Conejos | Colorado | 8021 | 1372 | 48 |
2110873 | 2110873 | 2022-01-13 | Richardson | Nebraska | 31147 | 1372 | 24 |
2107622 | 2107622 | 2022-01-12 | Richardson | Nebraska | 31147 | 1372 | 24 |
2107820 | 2107820 | 2022-01-12 | Gates | North Carolina | 37073 | 1372 | 18 |
2089516 | 2089516 | 2022-01-06 | Tucker | West Virginia | 54093 | 1372 | 32 |
2051898 | 2051898 | 2021-12-26 | Lake | Michigan | 26085 | 1372 | 31 |
2048648 | 2048648 | 2021-12-25 | Lake | Michigan | 26085 | 1372 | 31 |
2045398 | 2045398 | 2021-12-24 | Lake | Michigan | 26085 | 1372 | 31 |
2042148 | 2042148 | 2021-12-23 | Lake | Michigan | 26085 | 1372 | 31 |
2038899 | 2038899 | 2021-12-22 | Lake | Michigan | 26085 | 1372 | 31 |
1989892 | 1989892 | 2021-12-07 | Gallatin | Kentucky | 21077 | 1372 | 44 |
1986715 | 1986715 | 2021-12-06 | Trimble | Kentucky | 21223 | 1372 | 25 |
1973575 | 1973575 | 2021-12-02 | Pratt | Kansas | 20151 | 1372 | 27 |
1969454 | 1969454 | 2021-12-01 | Greenlee | Arizona | 4011 | 1372 | 22 |
1970325 | 1970325 | 2021-12-01 | Pratt | Kansas | 20151 | 1372 | 27 |
1930402 | 1930402 | 2021-11-19 | Sumter | Alabama | 1119 | 1372 | 40 |
1922984 | 1922984 | 2021-11-16 | Quebradillas | Puerto Rico | 72115 | 1372 | |
1919735 | 1919735 | 2021-11-15 | Quebradillas | Puerto Rico | 72115 | 1372 | |
1916485 | 1916485 | 2021-11-14 | Quebradillas | Puerto Rico | 72115 | 1372 | |
1916546 | 1916546 | 2021-11-14 | McCormick | South Carolina | 45065 | 1372 | 30 |
1913235 | 1913235 | 2021-11-13 | Quebradillas | Puerto Rico | 72115 | 1372 | |
1913296 | 1913296 | 2021-11-13 | McCormick | South Carolina | 45065 | 1372 | 30 |
1910046 | 1910046 | 2021-11-12 | McCormick | South Carolina | 45065 | 1372 | 30 |
1887251 | 1887251 | 2021-11-05 | Utuado | Puerto Rico | 72141 | 1372 | |
1887993 | 1887993 | 2021-11-05 | Tyler | West Virginia | 54095 | 1372 | 23 |
1884001 | 1884001 | 2021-11-04 | Utuado | Puerto Rico | 72141 | 1372 | |
1879130 | 1879130 | 2021-11-03 | Switzerland | Indiana | 18155 | 1372 | 11 |
1880752 | 1880752 | 2021-11-03 | Utuado | Puerto Rico | 72141 | 1372 | |
1881455 | 1881455 | 2021-11-03 | Doddridge | West Virginia | 54017 | 1372 | 10 |
1876092 | 1876092 | 2021-11-02 | Thomas | Kansas | 20193 | 1372 | 22 |
1876485 | 1876485 | 2021-11-02 | Pipestone | Minnesota | 27117 | 1372 | 27 |
1876838 | 1876838 | 2021-11-02 | Phelps | Nebraska | 31137 | 1372 | 10 |
1877503 | 1877503 | 2021-11-02 | Utuado | Puerto Rico | 72141 | 1372 | |
1872843 | 1872843 | 2021-11-01 | Thomas | Kansas | 20193 | 1372 | 22 |
1873589 | 1873589 | 2021-11-01 | Phelps | Nebraska | 31137 | 1372 | 10 |
1874254 | 1874254 | 2021-11-01 | Utuado | Puerto Rico | 72141 | 1372 | |
1871005 | 1871005 | 2021-10-31 | Utuado | Puerto Rico | 72141 | 1372 | |
1867756 | 1867756 | 2021-10-30 | Utuado | Puerto Rico | 72141 | 1372 | |
1865212 | 1865212 | 2021-10-29 | Gilmer | West Virginia | 54021 | 1372 | 12 |
1834373 | 1834373 | 2021-10-20 | Carroll | Missouri | 29033 | 1372 | 27 |
1824475 | 1824475 | 2021-10-17 | Koochiching | Minnesota | 27071 | 1372 | 19 |
1826043 | 1826043 | 2021-10-17 | Amelia | Virginia | 51007 | 1372 | 39 |
1821226 | 1821226 | 2021-10-16 | Koochiching | Minnesota | 27071 | 1372 | 19 |
1822794 | 1822794 | 2021-10-16 | Amelia | Virginia | 51007 | 1372 | 39 |
1823006 | 1823006 | 2021-10-16 | Summers | West Virginia | 54089 | 1372 | 30 |
1817977 | 1817977 | 2021-10-15 | Koochiching | Minnesota | 27071 | 1372 | 19 |
1819545 | 1819545 | 2021-10-15 | Amelia | Virginia | 51007 | 1372 | 39 |
1819749 | 1819749 | 2021-10-15 | Pleasants | West Virginia | 54073 | 1372 | 30 |
1807833 | 1807833 | 2021-10-12 | Norton | Kansas | 20137 | 1372 | 30 |
1804582 | 1804582 | 2021-10-11 | Norton | Kansas | 20137 | 1372 | 30 |
1793922 | 1793922 | 2021-10-08 | Perry | Alabama | 1105 | 1372 | 39 |
1781535 | 1781535 | 2021-10-04 | Marshall | Illinois | 17123 | 1372 | 23 |
1767801 | 1767801 | 2021-09-29 | Forest | Wisconsin | 55041 | 1372 | 31 |
1746134 | 1746134 | 2021-09-23 | Wilson | Kansas | 20205 | 1372 | 29 |
1742885 | 1742885 | 2021-09-22 | Wilson | Kansas | 20205 | 1372 | 29 |
1739591 | 1739591 | 2021-09-21 | Marshall | Kansas | 20117 | 1372 | 28 |
1736342 | 1736342 | 2021-09-20 | Marshall | Kansas | 20117 | 1372 | 28 |
1737014 | 1737014 | 2021-09-20 | Deer Lodge | Montana | 30023 | 1372 | 24 |
1716600 | 1716600 | 2021-09-14 | Benton | Indiana | 18007 | 1372 | 16 |
1717421 | 1717421 | 2021-09-14 | DeKalb | Missouri | 29063 | 1372 | 33 |
1699507 | 1699507 | 2021-09-08 | Braxton | West Virginia | 54007 | 1372 | 10 |
1670069 | 1670069 | 2021-08-30 | Unknown | Utah | 1372 | 28 | |
1664364 | 1664364 | 2021-08-29 | Evans | Georgia | 13109 | 1372 | 37 |
1661116 | 1661116 | 2021-08-28 | Evans | Georgia | 13109 | 1372 | 37 |
1657442 | 1657442 | 2021-08-27 | Coosa | Alabama | 1037 | 1372 | 31 |
1657868 | 1657868 | 2021-08-27 | Evans | Georgia | 13109 | 1372 | 37 |
1659456 | 1659456 | 2021-08-27 | McLean | North Dakota | 38055 | 1372 | 32 |
1656584 | 1656584 | 2021-08-26 | Yauco | Puerto Rico | 72153 | 1372 | |
1652513 | 1652513 | 2021-08-25 | Ralls | Missouri | 29173 | 1372 | 14 |
1649216 | 1649216 | 2021-08-24 | Grundy | Missouri | 29079 | 1372 | 38 |
1649883 | 1649883 | 2021-08-24 | Nowata | Oklahoma | 40105 | 1372 | 21 |
1646634 | 1646634 | 2021-08-23 | Nowata | Oklahoma | 40105 | 1372 | 21 |
1643385 | 1643385 | 2021-08-22 | Nowata | Oklahoma | 40105 | 1372 | 21 |
1644293 | 1644293 | 2021-08-22 | Grant | West Virginia | 54023 | 1372 | 29 |
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);