ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
855 rows where cases = 235 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 51
- Texas 120
- Georgia 49
- Colorado 42
- Virginia 39
- Kentucky 38
- Nebraska 29
- Kansas 27
- North Carolina 26
- Illinois 25
- Ohio 25
- Indiana 23
- Iowa 22
- Missouri 22
- Oregon 22
- Michigan 20
- Oklahoma 20
- Mississippi 19
- Montana 19
- Puerto Rico 19
- Pennsylvania 18
- Minnesota 17
- New York 16
- South Dakota 16
- Idaho 15
- North Dakota 14
- Tennessee 13
- Louisiana 12
- Utah 11
- West Virginia 11
- New Mexico 10
- Alabama 9
- Alaska 9
- California 8
- Florida 8
- Wisconsin 8
- Arkansas 7
- Northern Mariana Islands 7
- Vermont 7
- Washington 6
- Wyoming 6
- Nevada 5
- South Carolina 5
- Arizona 2
- Maryland 2
- Connecticut 1
- Delaware 1
- Hawaii 1
- Maine 1
- Massachusetts 1
- New Hampshire 1
- Rhode Island 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2335039 | 2335039 | 2022-03-23 | Unknown | Mississippi | 235 | 33 | |
2247360 | 2247360 | 2022-02-24 | Carter | Montana | 30011 | 235 | 5 |
2244109 | 2244109 | 2022-02-23 | Carter | Montana | 30011 | 235 | 5 |
2240858 | 2240858 | 2022-02-22 | Carter | Montana | 30011 | 235 | 5 |
2156324 | 2156324 | 2022-01-27 | Prairie | Montana | 30079 | 235 | 3 |
2149608 | 2149608 | 2022-01-25 | Issaquena | Mississippi | 28055 | 235 | 7 |
2074295 | 2074295 | 2022-01-02 | Greeley | Kansas | 20071 | 235 | 3 |
2071044 | 2071044 | 2022-01-01 | Greeley | Kansas | 20071 | 235 | 3 |
2067793 | 2067793 | 2021-12-31 | Greeley | Kansas | 20071 | 235 | 3 |
2064542 | 2064542 | 2021-12-30 | Greeley | Kansas | 20071 | 235 | 3 |
2061292 | 2061292 | 2021-12-29 | Greeley | Kansas | 20071 | 235 | 3 |
1971048 | 1971048 | 2021-12-01 | Deuel | Nebraska | 31049 | 235 | 2 |
1955136 | 1955136 | 2021-11-26 | Oliver | North Dakota | 38065 | 235 | 3 |
1920020 | 1920020 | 2021-11-15 | Cottle | Texas | 48101 | 235 | 9 |
1916770 | 1916770 | 2021-11-14 | Cottle | Texas | 48101 | 235 | 9 |
1913520 | 1913520 | 2021-11-13 | Cottle | Texas | 48101 | 235 | 9 |
1910270 | 1910270 | 2021-11-12 | Cottle | Texas | 48101 | 235 | 9 |
1907021 | 1907021 | 2021-11-11 | Cottle | Texas | 48101 | 235 | 9 |
1903772 | 1903772 | 2021-11-10 | Cottle | Texas | 48101 | 235 | 9 |
1900522 | 1900522 | 2021-11-09 | Cottle | Texas | 48101 | 235 | 9 |
1896412 | 1896412 | 2021-11-08 | Catron | New Mexico | 35003 | 235 | 7 |
1897272 | 1897272 | 2021-11-08 | Cottle | Texas | 48101 | 235 | 9 |
1894022 | 1894022 | 2021-11-07 | Cottle | Texas | 48101 | 235 | 9 |
1890772 | 1890772 | 2021-11-06 | Cottle | Texas | 48101 | 235 | 9 |
1846119 | 1846119 | 2021-10-24 | Dolores | Colorado | 8033 | 235 | 2 |
1842869 | 1842869 | 2021-10-23 | Dolores | Colorado | 8033 | 235 | 2 |
1839619 | 1839619 | 2021-10-22 | Dolores | Colorado | 8033 | 235 | 2 |
1837929 | 1837929 | 2021-10-21 | De Baca | New Mexico | 35011 | 235 | 3 |
1834680 | 1834680 | 2021-10-20 | De Baca | New Mexico | 35011 | 235 | 3 |
1831431 | 1831431 | 2021-10-19 | De Baca | New Mexico | 35011 | 235 | 3 |
1829268 | 1829268 | 2021-10-18 | Wayne | Utah | 49055 | 235 | 0 |
1824397 | 1824397 | 2021-10-17 | Keweenaw | Michigan | 26083 | 235 | 4 |
1824819 | 1824819 | 2021-10-17 | Gosper | Nebraska | 31073 | 235 | 5 |
1826019 | 1826019 | 2021-10-17 | Wayne | Utah | 49055 | 235 | 0 |
1821148 | 1821148 | 2021-10-16 | Keweenaw | Michigan | 26083 | 235 | 4 |
1821570 | 1821570 | 2021-10-16 | Gosper | Nebraska | 31073 | 235 | 5 |
1822770 | 1822770 | 2021-10-16 | Wayne | Utah | 49055 | 235 | 0 |
1817899 | 1817899 | 2021-10-15 | Keweenaw | Michigan | 26083 | 235 | 4 |
1818321 | 1818321 | 2021-10-15 | Gosper | Nebraska | 31073 | 235 | 5 |
1819521 | 1819521 | 2021-10-15 | Wayne | Utah | 49055 | 235 | 0 |
1816272 | 1816272 | 2021-10-14 | Wayne | Utah | 49055 | 235 | 0 |
1789016 | 1789016 | 2021-10-06 | Meagher | Montana | 30059 | 235 | 8 |
1784196 | 1784196 | 2021-10-05 | Denali Borough | Alaska | 2068 | 235 | 1 |
1785748 | 1785748 | 2021-10-05 | Daniels | Montana | 30019 | 235 | 9 |
1778168 | 1778168 | 2021-10-03 | Webster | Georgia | 13307 | 235 | 6 |
1774918 | 1774918 | 2021-10-02 | Webster | Georgia | 13307 | 235 | 6 |
1771668 | 1771668 | 2021-10-01 | Webster | Georgia | 13307 | 235 | 6 |
1768419 | 1768419 | 2021-09-30 | Webster | Georgia | 13307 | 235 | 6 |
1760816 | 1760816 | 2021-09-27 | Dickens | Texas | 48125 | 235 | 10 |
1757568 | 1757568 | 2021-09-26 | Dickens | Texas | 48125 | 235 | 10 |
1754320 | 1754320 | 2021-09-25 | Dickens | Texas | 48125 | 235 | 10 |
1751072 | 1751072 | 2021-09-24 | Dickens | Texas | 48125 | 235 | 10 |
1747823 | 1747823 | 2021-09-23 | Dickens | Texas | 48125 | 235 | 10 |
1744980 | 1744980 | 2021-09-22 | Wahkiakum | Washington | 53069 | 235 | 5 |
1713154 | 1713154 | 2021-09-13 | Quitman | Georgia | 13239 | 235 | 3 |
1704928 | 1704928 | 2021-09-10 | Grant | North Dakota | 38037 | 235 | 7 |
1688719 | 1688719 | 2021-09-05 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1685469 | 1685469 | 2021-09-04 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1682218 | 1682218 | 2021-09-03 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1678969 | 1678969 | 2021-09-02 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1675721 | 1675721 | 2021-09-01 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1672474 | 1672474 | 2021-08-31 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1673044 | 1673044 | 2021-08-31 | Armstrong | Texas | 48011 | 235 | 7 |
1669226 | 1669226 | 2021-08-30 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1669796 | 1669796 | 2021-08-30 | Armstrong | Texas | 48011 | 235 | 7 |
1666549 | 1666549 | 2021-08-29 | Armstrong | Texas | 48011 | 235 | 7 |
1663301 | 1663301 | 2021-08-28 | Armstrong | Texas | 48011 | 235 | 7 |
1657745 | 1657745 | 2021-08-27 | Unknown | Delaware | 235 | 0 | |
1632430 | 1632430 | 2021-08-19 | Wichita | Kansas | 20203 | 235 | 6 |
1629183 | 1629183 | 2021-08-18 | Wichita | Kansas | 20203 | 235 | 6 |
1557025 | 1557025 | 2021-07-27 | Sedgwick | Colorado | 8115 | 235 | 3 |
1553778 | 1553778 | 2021-07-26 | Sedgwick | Colorado | 8115 | 235 | 3 |
1550531 | 1550531 | 2021-07-25 | Sedgwick | Colorado | 8115 | 235 | 3 |
1551227 | 1551227 | 2021-07-25 | Woodson | Kansas | 20207 | 235 | 5 |
1547284 | 1547284 | 2021-07-24 | Sedgwick | Colorado | 8115 | 235 | 3 |
1547980 | 1547980 | 2021-07-24 | Woodson | Kansas | 20207 | 235 | 5 |
1544037 | 1544037 | 2021-07-23 | Sedgwick | Colorado | 8115 | 235 | 3 |
1544733 | 1544733 | 2021-07-23 | Woodson | Kansas | 20207 | 235 | 5 |
1540789 | 1540789 | 2021-07-22 | Sedgwick | Colorado | 8115 | 235 | 3 |
1537542 | 1537542 | 2021-07-21 | Sedgwick | Colorado | 8115 | 235 | 3 |
1534250 | 1534250 | 2021-07-20 | Custer | Colorado | 8027 | 235 | 2 |
1534294 | 1534294 | 2021-07-20 | Sedgwick | Colorado | 8115 | 235 | 3 |
1531003 | 1531003 | 2021-07-19 | Custer | Colorado | 8027 | 235 | 2 |
1531047 | 1531047 | 2021-07-19 | Sedgwick | Colorado | 8115 | 235 | 3 |
1527756 | 1527756 | 2021-07-18 | Custer | Colorado | 8027 | 235 | 2 |
1527800 | 1527800 | 2021-07-18 | Sedgwick | Colorado | 8115 | 235 | 3 |
1524509 | 1524509 | 2021-07-17 | Custer | Colorado | 8027 | 235 | 2 |
1524553 | 1524553 | 2021-07-17 | Sedgwick | Colorado | 8115 | 235 | 3 |
1521261 | 1521261 | 2021-07-16 | Custer | Colorado | 8027 | 235 | 2 |
1521305 | 1521305 | 2021-07-16 | Sedgwick | Colorado | 8115 | 235 | 3 |
1518057 | 1518057 | 2021-07-15 | Sedgwick | Colorado | 8115 | 235 | 3 |
1514810 | 1514810 | 2021-07-14 | Sedgwick | Colorado | 8115 | 235 | 3 |
1511520 | 1511520 | 2021-07-13 | Custer | Colorado | 8027 | 235 | 2 |
1511564 | 1511564 | 2021-07-13 | Sedgwick | Colorado | 8115 | 235 | 3 |
1491369 | 1491369 | 2021-07-06 | Sherman | Texas | 48421 | 235 | 12 |
1488122 | 1488122 | 2021-07-05 | Sherman | Texas | 48421 | 235 | 12 |
1484875 | 1484875 | 2021-07-04 | Sherman | Texas | 48421 | 235 | 12 |
1481629 | 1481629 | 2021-07-03 | Sherman | Texas | 48421 | 235 | 12 |
1478382 | 1478382 | 2021-07-02 | Sherman | Texas | 48421 | 235 | 12 |
1475136 | 1475136 | 2021-07-01 | Sherman | Texas | 48421 | 235 | 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);