ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
266 rows where cases = 1668 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 28
- Missouri 26
- Georgia 23
- Minnesota 14
- Texas 12
- Illinois 11
- Iowa 10
- Tennessee 10
- Montana 9
- Oklahoma 9
- Kentucky 8
- Michigan 8
- Mississippi 7
- Alabama 6
- Louisiana 6
- Puerto Rico 6
- Virginia 6
- Ohio 5
- South Carolina 5
- California 4
- Colorado 4
- Oregon 4
- Wisconsin 4
- Alaska 3
- Florida 3
- Idaho 3
- Indiana 3
- New Mexico 3
- New York 3
- North Carolina 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2266913 | 2266913 | 2022-03-02 | Valley | Montana | 30105 | 1668 | 36 |
2255561 | 2255561 | 2022-02-27 | Aleutians West Census Area | Alaska | 2016 | 1668 | 1 |
2252310 | 2252310 | 2022-02-26 | Aleutians West Census Area | Alaska | 2016 | 1668 | 1 |
2249059 | 2249059 | 2022-02-25 | Aleutians West Census Area | Alaska | 2016 | 1668 | 1 |
2243859 | 2243859 | 2022-02-23 | Mahnomen | Minnesota | 27087 | 1668 | 17 |
2239494 | 2239494 | 2022-02-22 | Conejos | Colorado | 8021 | 1668 | 50 |
2211583 | 2211583 | 2022-02-13 | Sullivan | Missouri | 29211 | 1668 | 19 |
2208330 | 2208330 | 2022-02-12 | Sullivan | Missouri | 29211 | 1668 | 19 |
2205077 | 2205077 | 2022-02-11 | Sullivan | Missouri | 29211 | 1668 | 19 |
2200404 | 2200404 | 2022-02-10 | Woodruff | Arkansas | 5147 | 1668 | 24 |
2201824 | 2201824 | 2022-02-10 | Sullivan | Missouri | 29211 | 1668 | 19 |
2180860 | 2180860 | 2022-02-04 | Newton | Arkansas | 5101 | 1668 | 45 |
2154566 | 2154566 | 2022-01-26 | Tucker | West Virginia | 54093 | 1668 | 33 |
2149703 | 2149703 | 2022-01-25 | Harrison | Missouri | 29081 | 1668 | 27 |
2122418 | 2122418 | 2022-01-17 | Lincoln | Colorado | 8073 | 1668 | 9 |
2124557 | 2124557 | 2022-01-17 | Allendale | South Carolina | 45005 | 1668 | 22 |
2121305 | 2121305 | 2022-01-16 | Allendale | South Carolina | 45005 | 1668 | 22 |
2118053 | 2118053 | 2022-01-15 | Allendale | South Carolina | 45005 | 1668 | 22 |
2114802 | 2114802 | 2022-01-14 | Allendale | South Carolina | 45005 | 1668 | 22 |
2080648 | 2080648 | 2022-01-04 | Switzerland | Indiana | 18155 | 1668 | 14 |
2075417 | 2075417 | 2022-01-02 | Traill | North Dakota | 38097 | 1668 | 21 |
2072166 | 2072166 | 2022-01-01 | Traill | North Dakota | 38097 | 1668 | 21 |
2040610 | 2040610 | 2021-12-22 | Lexington city | Virginia | 51678 | 1668 | 37 |
2035228 | 2035228 | 2021-12-21 | Montgomery | Iowa | 19137 | 1668 | 48 |
2036520 | 2036520 | 2021-12-21 | Blaine | Oklahoma | 40011 | 1668 | 32 |
2031557 | 2031557 | 2021-12-20 | Evans | Georgia | 13109 | 1668 | 54 |
2031978 | 2031978 | 2021-12-20 | Montgomery | Iowa | 19137 | 1668 | 48 |
2033270 | 2033270 | 2021-12-20 | Blaine | Oklahoma | 40011 | 1668 | 32 |
2028727 | 2028727 | 2021-12-19 | Montgomery | Iowa | 19137 | 1668 | 48 |
2030020 | 2030020 | 2021-12-19 | Blaine | Oklahoma | 40011 | 1668 | 32 |
2025476 | 2025476 | 2021-12-18 | Montgomery | Iowa | 19137 | 1668 | 48 |
2026769 | 2026769 | 2021-12-18 | Blaine | Oklahoma | 40011 | 1668 | 32 |
2022225 | 2022225 | 2021-12-17 | Montgomery | Iowa | 19137 | 1668 | 48 |
2023518 | 2023518 | 2021-12-17 | Blaine | Oklahoma | 40011 | 1668 | 32 |
2018974 | 2018974 | 2021-12-16 | Montgomery | Iowa | 19137 | 1668 | 48 |
2019638 | 2019638 | 2021-12-16 | DeKalb | Missouri | 29063 | 1668 | 37 |
2020267 | 2020267 | 2021-12-16 | Blaine | Oklahoma | 40011 | 1668 | 32 |
2020707 | 2020707 | 2021-12-16 | Perry | Tennessee | 47135 | 1668 | 35 |
2015724 | 2015724 | 2021-12-15 | Montgomery | Iowa | 19137 | 1668 | 48 |
2017016 | 2017016 | 2021-12-15 | Blaine | Oklahoma | 40011 | 1668 | 32 |
2001458 | 2001458 | 2021-12-10 | Trinity | Texas | 48455 | 1668 | 62 |
1990478 | 1990478 | 2021-12-07 | Deer Lodge | Montana | 30023 | 1668 | 27 |
1986741 | 1986741 | 2021-12-06 | East Carroll | Louisiana | 22035 | 1668 | 32 |
1982788 | 1982788 | 2021-12-05 | Dooly | Georgia | 13093 | 1668 | 62 |
1979538 | 1979538 | 2021-12-04 | Dooly | Georgia | 13093 | 1668 | 62 |
1976288 | 1976288 | 2021-12-03 | Dooly | Georgia | 13093 | 1668 | 62 |
1973039 | 1973039 | 2021-12-02 | Dooly | Georgia | 13093 | 1668 | 62 |
1969789 | 1969789 | 2021-12-01 | Dooly | Georgia | 13093 | 1668 | 62 |
1966539 | 1966539 | 2021-11-30 | Dooly | Georgia | 13093 | 1668 | 62 |
1965649 | 1965649 | 2021-11-29 | Morris | Texas | 48343 | 1668 | 56 |
1950422 | 1950422 | 2021-11-25 | Clearwater | Idaho | 16035 | 1668 | 27 |
1946888 | 1946888 | 2021-11-24 | Park | Colorado | 8093 | 1668 | 11 |
1947171 | 1947171 | 2021-11-24 | Clearwater | Idaho | 16035 | 1668 | 27 |
1928384 | 1928384 | 2021-11-18 | Luce | Michigan | 26095 | 1668 | 6 |
1925134 | 1925134 | 2021-11-17 | Luce | Michigan | 26095 | 1668 | 6 |
1873508 | 1873508 | 2021-11-01 | Rosebud | Montana | 30087 | 1668 | 56 |
1868987 | 1868987 | 2021-10-31 | Unknown | Florida | 1668 | 22 | |
1869989 | 1869989 | 2021-10-31 | Pope | Minnesota | 27121 | 1668 | 9 |
1865738 | 1865738 | 2021-10-30 | Unknown | Florida | 1668 | 867 | |
1866740 | 1866740 | 2021-10-30 | Pope | Minnesota | 27121 | 1668 | 9 |
1863491 | 1863491 | 2021-10-29 | Pope | Minnesota | 27121 | 1668 | 9 |
1840912 | 1840912 | 2021-10-22 | Lewis | Missouri | 29111 | 1668 | 22 |
1837625 | 1837625 | 2021-10-21 | Cedar | Missouri | 29039 | 1668 | 30 |
1834376 | 1834376 | 2021-10-20 | Cedar | Missouri | 29039 | 1668 | 30 |
1831127 | 1831127 | 2021-10-19 | Cedar | Missouri | 29039 | 1668 | 30 |
1803752 | 1803752 | 2021-10-11 | Fulton | Arkansas | 5049 | 1668 | 62 |
1800503 | 1800503 | 2021-10-10 | Fulton | Arkansas | 5049 | 1668 | 62 |
1796187 | 1796187 | 2021-10-08 | Potter | Pennsylvania | 42105 | 1668 | 32 |
1791891 | 1791891 | 2021-10-07 | Gogebic | Michigan | 26053 | 1668 | 53 |
1788642 | 1788642 | 2021-10-06 | Gogebic | Michigan | 26053 | 1668 | 53 |
1784405 | 1784405 | 2021-10-05 | Las Animas | Colorado | 8071 | 1668 | 20 |
1785452 | 1785452 | 2021-10-05 | Aitkin | Minnesota | 27001 | 1668 | 40 |
1781048 | 1781048 | 2021-10-04 | Scott | Arkansas | 5127 | 1668 | 25 |
1756504 | 1756504 | 2021-09-26 | Custer | Montana | 30017 | 1668 | 23 |
1753256 | 1753256 | 2021-09-25 | Custer | Montana | 30017 | 1668 | 23 |
1750008 | 1750008 | 2021-09-24 | Custer | Montana | 30017 | 1668 | 23 |
1742964 | 1742964 | 2021-09-22 | Martin | Kentucky | 21159 | 1668 | 29 |
1737624 | 1737624 | 2021-09-20 | Curry | Oregon | 41015 | 1668 | 17 |
1717026 | 1717026 | 2021-09-14 | Catahoula | Louisiana | 22025 | 1668 | 45 |
1713660 | 1713660 | 2021-09-13 | Breathitt | Kentucky | 21025 | 1668 | 14 |
1701184 | 1701184 | 2021-09-09 | Dent | Missouri | 29065 | 1668 | 29 |
1673391 | 1673391 | 2021-08-31 | Goochland | Virginia | 51075 | 1668 | 25 |
1667298 | 1667298 | 2021-08-30 | Desha | Arkansas | 5041 | 1668 | 24 |
1664051 | 1664051 | 2021-08-29 | Desha | Arkansas | 5041 | 1668 | 24 |
1654146 | 1654146 | 2021-08-25 | Washburn | Wisconsin | 55129 | 1668 | 24 |
1646666 | 1646666 | 2021-08-23 | Crook | Oregon | 41013 | 1668 | 29 |
1632127 | 1632127 | 2021-08-19 | Wabash | Illinois | 17185 | 1668 | 15 |
1634625 | 1634625 | 2021-08-19 | Marquette | Wisconsin | 55077 | 1668 | 29 |
1630537 | 1630537 | 2021-08-18 | Cidra | Puerto Rico | 72041 | 1668 | |
1622826 | 1622826 | 2021-08-16 | Claiborne | Louisiana | 22027 | 1668 | 56 |
1614582 | 1614582 | 2021-08-13 | Bandera | Texas | 48019 | 1668 | 34 |
1611120 | 1611120 | 2021-08-12 | Bamberg | South Carolina | 45009 | 1668 | 54 |
1607312 | 1607312 | 2021-08-11 | Essex | New York | 36031 | 1668 | 26 |
1579576 | 1579576 | 2021-08-03 | Chicot | Arkansas | 5017 | 1668 | 41 |
1573155 | 1573155 | 2021-08-01 | Del Norte | California | 6015 | 1668 | 8 |
1569907 | 1569907 | 2021-07-31 | Del Norte | California | 6015 | 1668 | 8 |
1571269 | 1571269 | 2021-07-31 | Linn | Missouri | 29115 | 1668 | 20 |
1562893 | 1562893 | 2021-07-28 | St. Croix | Virgin Islands | 78010 | 1668 | 12 |
1558254 | 1558254 | 2021-07-27 | Gasconade | Missouri | 29073 | 1668 | 47 |
1559645 | 1559645 | 2021-07-27 | St. Croix | Virgin Islands | 78010 | 1668 | 12 |
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);