ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
250 rows where cases = 1980 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 22
- Kentucky 18
- Arkansas 17
- Texas 16
- Virginia 12
- West Virginia 11
- Puerto Rico 10
- Indiana 8
- Ohio 8
- Oklahoma 8
- Illinois 7
- Louisiana 7
- Wisconsin 7
- Georgia 6
- Idaho 6
- Massachusetts 6
- Minnesota 6
- New York 6
- Tennessee 6
- Nebraska 5
- North Carolina 5
- South Dakota 5
- Washington 5
- Colorado 4
- Florida 4
- Iowa 4
- Michigan 4
- Mississippi 4
- Oregon 4
- North Dakota 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501588 | 2501588 | 2022-05-13 | Benson | North Dakota | 38005 | 1980 | 23 |
2499519 | 2499519 | 2022-05-12 | Menominee | Wisconsin | 55078 | 1980 | 14 |
2404852 | 2404852 | 2022-04-13 | Fairfax city | Virginia | 51600 | 1980 | 42 |
2401597 | 2401597 | 2022-04-12 | Fairfax city | Virginia | 51600 | 1980 | 42 |
2398342 | 2398342 | 2022-04-11 | Fairfax city | Virginia | 51600 | 1980 | 42 |
2373111 | 2373111 | 2022-04-04 | Taylor | Georgia | 13269 | 1980 | 53 |
2362546 | 2362546 | 2022-03-31 | Falls Church city | Virginia | 51610 | 1980 | 16 |
2330192 | 2330192 | 2022-03-21 | Tucker | West Virginia | 54093 | 1980 | 34 |
2265808 | 2265808 | 2022-03-02 | Benewah | Idaho | 16009 | 1980 | 40 |
2268385 | 2268385 | 2022-03-02 | Pocahontas | West Virginia | 54075 | 1980 | 27 |
2265132 | 2265132 | 2022-03-01 | Pocahontas | West Virginia | 54075 | 1980 | 27 |
2238351 | 2238351 | 2022-02-21 | Guayanilla | Puerto Rico | 72059 | 1980 | |
2235100 | 2235100 | 2022-02-20 | Guayanilla | Puerto Rico | 72059 | 1980 | |
2224348 | 2224348 | 2022-02-17 | Lake | Minnesota | 27075 | 1980 | 27 |
2217049 | 2217049 | 2022-02-15 | Boundary | Idaho | 16021 | 1980 | 56 |
2196850 | 2196850 | 2022-02-08 | Pleasants | West Virginia | 54073 | 1980 | 34 |
2196864 | 2196864 | 2022-02-08 | Webster | West Virginia | 54101 | 1980 | 28 |
2187989 | 2187989 | 2022-02-06 | Union | Indiana | 18161 | 1980 | 21 |
2184736 | 2184736 | 2022-02-05 | Union | Indiana | 18161 | 1980 | 21 |
2181484 | 2181484 | 2022-02-04 | Union | Indiana | 18161 | 1980 | 21 |
2173607 | 2173607 | 2022-02-01 | Clay | Texas | 48077 | 1980 | 27 |
2161076 | 2161076 | 2022-01-28 | Tyler | West Virginia | 54095 | 1980 | 27 |
2128815 | 2128815 | 2022-01-19 | Scott | Arkansas | 5127 | 1980 | 35 |
2113918 | 2113918 | 2022-01-14 | Grundy | Missouri | 29079 | 1980 | 60 |
2111530 | 2111530 | 2022-01-13 | Santa Isabel | Puerto Rico | 72133 | 1980 | |
2108810 | 2108810 | 2022-01-12 | Amelia | Virginia | 51007 | 1980 | 44 |
2102877 | 2102877 | 2022-01-11 | Bent | Colorado | 8011 | 1980 | 44 |
2091207 | 2091207 | 2022-01-07 | Ralls | Missouri | 29173 | 1980 | 19 |
2079137 | 2079137 | 2022-01-03 | Todd | South Dakota | 46121 | 1980 | 39 |
2052115 | 2052115 | 2021-12-26 | Barton | Missouri | 29011 | 1980 | 40 |
2053267 | 2053267 | 2021-12-26 | Callahan | Texas | 48059 | 1980 | 58 |
2048865 | 2048865 | 2021-12-25 | Barton | Missouri | 29011 | 1980 | 40 |
2050017 | 2050017 | 2021-12-25 | Callahan | Texas | 48059 | 1980 | 58 |
2045615 | 2045615 | 2021-12-24 | Barton | Missouri | 29011 | 1980 | 40 |
2046767 | 2046767 | 2021-12-24 | Callahan | Texas | 48059 | 1980 | 58 |
2042365 | 2042365 | 2021-12-23 | Barton | Missouri | 29011 | 1980 | 40 |
2043517 | 2043517 | 2021-12-23 | Callahan | Texas | 48059 | 1980 | 58 |
2036121 | 2036121 | 2021-12-21 | Unknown | Nebraska | 1980 | 275 | |
2034198 | 2034198 | 2021-12-20 | Pacific | Washington | 53049 | 1980 | 38 |
2018244 | 2018244 | 2021-12-16 | Fulton | Arkansas | 5049 | 1980 | 71 |
2016376 | 2016376 | 2021-12-15 | Cedar | Missouri | 29039 | 1980 | 42 |
1995572 | 1995572 | 2021-12-09 | Plumas | California | 6063 | 1980 | 12 |
1970764 | 1970764 | 2021-12-01 | Watonwan | Minnesota | 27165 | 1980 | 20 |
1964089 | 1964089 | 2021-11-29 | Nantucket | Massachusetts | 25019 | 1980 | 0 |
1960686 | 1960686 | 2021-11-28 | Metcalfe | Kentucky | 21169 | 1980 | 45 |
1960838 | 1960838 | 2021-11-28 | Nantucket | Massachusetts | 25019 | 1980 | 0 |
1957435 | 1957435 | 2021-11-27 | Metcalfe | Kentucky | 21169 | 1980 | 45 |
1957587 | 1957587 | 2021-11-27 | Nantucket | Massachusetts | 25019 | 1980 | 0 |
1954184 | 1954184 | 2021-11-26 | Metcalfe | Kentucky | 21169 | 1980 | 45 |
1954336 | 1954336 | 2021-11-26 | Nantucket | Massachusetts | 25019 | 1980 | 0 |
1949925 | 1949925 | 2021-11-25 | Ketchikan Gateway Borough | Alaska | 2130 | 1980 | 11 |
1950933 | 1950933 | 2021-11-25 | Metcalfe | Kentucky | 21169 | 1980 | 45 |
1951085 | 1951085 | 2021-11-25 | Nantucket | Massachusetts | 25019 | 1980 | 0 |
1946674 | 1946674 | 2021-11-24 | Ketchikan Gateway Borough | Alaska | 2130 | 1980 | 11 |
1947682 | 1947682 | 2021-11-24 | Metcalfe | Kentucky | 21169 | 1980 | 45 |
1947834 | 1947834 | 2021-11-24 | Nantucket | Massachusetts | 25019 | 1980 | 0 |
1944431 | 1944431 | 2021-11-23 | Metcalfe | Kentucky | 21169 | 1980 | 44 |
1942577 | 1942577 | 2021-11-22 | Dewey | South Dakota | 46041 | 1980 | 32 |
1939327 | 1939327 | 2021-11-21 | Dewey | South Dakota | 46041 | 1980 | 32 |
1936077 | 1936077 | 2021-11-20 | Dewey | South Dakota | 46041 | 1980 | 32 |
1932440 | 1932440 | 2021-11-19 | Harrison | Ohio | 39067 | 1980 | 50 |
1932827 | 1932827 | 2021-11-19 | Dewey | South Dakota | 46041 | 1980 | 32 |
1926999 | 1926999 | 2021-11-17 | Ashland | Wisconsin | 55003 | 1980 | 19 |
1921213 | 1921213 | 2021-11-16 | Cumberland | Illinois | 17035 | 1980 | 39 |
1905419 | 1905419 | 2021-11-11 | Lyon | Kentucky | 21143 | 1980 | 26 |
1905875 | 1905875 | 2021-11-11 | Dent | Missouri | 29065 | 1980 | 42 |
1902169 | 1902169 | 2021-11-10 | Lyon | Kentucky | 21143 | 1980 | 26 |
1902626 | 1902626 | 2021-11-10 | Dent | Missouri | 29065 | 1980 | 42 |
1900839 | 1900839 | 2021-11-09 | King William | Virginia | 51101 | 1980 | 24 |
1864486 | 1864486 | 2021-10-29 | Morovis | Puerto Rico | 72101 | 1980 | |
1859140 | 1859140 | 2021-10-28 | Moffat | Colorado | 8081 | 1980 | 44 |
1859451 | 1859451 | 2021-10-28 | Shoshone | Idaho | 16079 | 1980 | 59 |
1861237 | 1861237 | 2021-10-28 | Morovis | Puerto Rico | 72101 | 1980 | |
1857988 | 1857988 | 2021-10-27 | Morovis | Puerto Rico | 72101 | 1980 | |
1854613 | 1854613 | 2021-10-26 | Tillamook | Oregon | 41057 | 1980 | 33 |
1852186 | 1852186 | 2021-10-25 | Klickitat | Washington | 53039 | 1980 | 18 |
1829380 | 1829380 | 2021-10-18 | Patrick | Virginia | 51141 | 1980 | 55 |
1825341 | 1825341 | 2021-10-17 | Baker | Oregon | 41001 | 1980 | 28 |
1822092 | 1822092 | 2021-10-16 | Baker | Oregon | 41001 | 1980 | 28 |
1818843 | 1818843 | 2021-10-15 | Baker | Oregon | 41001 | 1980 | 28 |
1814463 | 1814463 | 2021-10-14 | Pendleton | Kentucky | 21191 | 1980 | 14 |
1803768 | 1803768 | 2021-10-11 | Little River | Arkansas | 5081 | 1980 | 71 |
1800519 | 1800519 | 2021-10-10 | Little River | Arkansas | 5081 | 1980 | 71 |
1791297 | 1791297 | 2021-10-07 | Piatt | Illinois | 17147 | 1980 | 20 |
1790602 | 1790602 | 2021-10-06 | Converse | Wyoming | 56009 | 1980 | 30 |
1786700 | 1786700 | 2021-10-05 | Lake | Tennessee | 47095 | 1980 | 31 |
1782647 | 1782647 | 2021-10-04 | Humboldt | Nevada | 32013 | 1980 | 19 |
1763419 | 1763419 | 2021-09-28 | Ramsey | North Dakota | 38071 | 1980 | 33 |
1719289 | 1719289 | 2021-09-15 | Lee | Arkansas | 5077 | 1980 | 41 |
1657051 | 1657051 | 2021-08-26 | Zapata | Texas | 48505 | 1980 | 38 |
1642261 | 1642261 | 2021-08-22 | Mason | Kentucky | 21161 | 1980 | 41 |
1639011 | 1639011 | 2021-08-21 | Mason | Kentucky | 21161 | 1980 | 41 |
1635761 | 1635761 | 2021-08-20 | Mason | Kentucky | 21161 | 1980 | 41 |
1596402 | 1596402 | 2021-08-08 | Wayne | Illinois | 17191 | 1980 | 54 |
1593153 | 1593153 | 2021-08-07 | Wayne | Illinois | 17191 | 1980 | 54 |
1589904 | 1589904 | 2021-08-06 | Wayne | Illinois | 17191 | 1980 | 54 |
1590311 | 1590311 | 2021-08-06 | Russell | Kentucky | 21207 | 1980 | 48 |
1587062 | 1587062 | 2021-08-05 | Russell | Kentucky | 21207 | 1980 | 48 |
1588879 | 1588879 | 2021-08-05 | Washington | Vermont | 50023 | 1980 | 15 |
1579233 | 1579233 | 2021-08-02 | Powhatan | Virginia | 51145 | 1980 | 17 |
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);