ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where cases = 4209 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 20
- Texas 18
- Nebraska 16
- Ohio 9
- Georgia 8
- Illinois 8
- Virginia 8
- North Carolina 7
- Missouri 6
- Kansas 5
- Michigan 5
- Puerto Rico 5
- Alabama 4
- Arkansas 4
- New York 4
- Idaho 3
- Minnesota 3
- Pennsylvania 3
- West Virginia 3
- Indiana 2
- Iowa 2
- Louisiana 2
- Montana 2
- South Dakota 2
- Utah 2
- Colorado 1
- Kentucky 1
- Maine 1
- Maryland 1
- New Hampshire 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378450 | 2378450 | 2022-04-05 | Sequatchie | Tennessee | 47153 | 4209 | 66 |
2375196 | 2375196 | 2022-04-04 | Sequatchie | Tennessee | 47153 | 4209 | 66 |
2371944 | 2371944 | 2022-04-03 | Sequatchie | Tennessee | 47153 | 4209 | 66 |
2368691 | 2368691 | 2022-04-02 | Sequatchie | Tennessee | 47153 | 4209 | 66 |
2365438 | 2365438 | 2022-04-01 | Sequatchie | Tennessee | 47153 | 4209 | 66 |
2362185 | 2362185 | 2022-03-31 | Sequatchie | Tennessee | 47153 | 4209 | 66 |
2358931 | 2358931 | 2022-03-30 | Sequatchie | Tennessee | 47153 | 4209 | 66 |
2355482 | 2355482 | 2022-03-29 | Yauco | Puerto Rico | 72153 | 4209 | |
2355685 | 2355685 | 2022-03-29 | Trousdale | Tennessee | 47169 | 4209 | 45 |
2352229 | 2352229 | 2022-03-28 | Yauco | Puerto Rico | 72153 | 4209 | |
2352432 | 2352432 | 2022-03-28 | Trousdale | Tennessee | 47169 | 4209 | 45 |
2348977 | 2348977 | 2022-03-27 | Yauco | Puerto Rico | 72153 | 4209 | |
2349180 | 2349180 | 2022-03-27 | Trousdale | Tennessee | 47169 | 4209 | 45 |
2345927 | 2345927 | 2022-03-26 | Trousdale | Tennessee | 47169 | 4209 | 45 |
2342674 | 2342674 | 2022-03-25 | Trousdale | Tennessee | 47169 | 4209 | 45 |
2339421 | 2339421 | 2022-03-24 | Trousdale | Tennessee | 47169 | 4209 | 45 |
2336167 | 2336167 | 2022-03-23 | Trousdale | Tennessee | 47169 | 4209 | 45 |
2289927 | 2289927 | 2022-03-09 | Bertie | North Carolina | 37015 | 4209 | 66 |
2287895 | 2287895 | 2022-03-08 | Morgan | West Virginia | 54065 | 4209 | 68 |
2269211 | 2269211 | 2022-03-03 | Carroll | Indiana | 18015 | 4209 | 64 |
2257904 | 2257904 | 2022-02-27 | Yabucoa | Puerto Rico | 72151 | 4209 | |
2245641 | 2245641 | 2022-02-23 | Wetzel | West Virginia | 54103 | 4209 | 76 |
2203125 | 2203125 | 2022-02-10 | Unknown | Utah | 4209 | 68 | |
2198111 | 2198111 | 2022-02-09 | Jackson | Louisiana | 22049 | 4209 | 68 |
2190594 | 2190594 | 2022-02-07 | Grant | Arkansas | 5053 | 4209 | 55 |
2143664 | 2143664 | 2022-01-23 | Yancey | North Carolina | 37199 | 4209 | 44 |
2140409 | 2140409 | 2022-01-22 | Yancey | North Carolina | 37199 | 4209 | 44 |
2137153 | 2137153 | 2022-01-21 | Yancey | North Carolina | 37199 | 4209 | 44 |
2129751 | 2129751 | 2022-01-19 | Spencer | Kentucky | 21215 | 4209 | 44 |
2088768 | 2088768 | 2022-01-06 | San Sebastian | Puerto Rico | 72131 | 4209 | |
2078406 | 2078406 | 2022-01-03 | Unknown | New Hampshire | 4209 | 23 | |
2076362 | 2076362 | 2022-01-02 | Louisa | Virginia | 51109 | 4209 | 54 |
2073111 | 2073111 | 2022-01-01 | Louisa | Virginia | 51109 | 4209 | 54 |
2069860 | 2069860 | 2021-12-31 | Louisa | Virginia | 51109 | 4209 | 54 |
2058483 | 2058483 | 2021-12-28 | Martin | Minnesota | 27091 | 4209 | 51 |
2039022 | 2039022 | 2021-12-22 | Waseca | Minnesota | 27161 | 4209 | 34 |
2039713 | 2039713 | 2021-12-22 | Holmes | Ohio | 39075 | 4209 | 147 |
2017877 | 2017877 | 2021-12-15 | Orange | Virginia | 51137 | 4209 | 65 |
2005607 | 2005607 | 2021-12-12 | Peach | Georgia | 13225 | 4209 | 115 |
2002356 | 2002356 | 2021-12-11 | Peach | Georgia | 13225 | 4209 | 115 |
1999106 | 1999106 | 2021-12-10 | Peach | Georgia | 13225 | 4209 | 115 |
1998279 | 1998279 | 2021-12-09 | Windsor | Vermont | 50027 | 4209 | 34 |
1917939 | 1917939 | 2021-11-15 | Payette | Idaho | 16075 | 4209 | 68 |
1795372 | 1795372 | 2021-10-08 | Barry | Missouri | 29009 | 4209 | 60 |
1787491 | 1787491 | 2021-10-06 | Carroll | Arkansas | 5015 | 4209 | 67 |
1779527 | 1779527 | 2021-10-03 | Washington | New York | 36115 | 4209 | 65 |
1746330 | 1746330 | 2021-09-23 | Oxford | Maine | 23017 | 4209 | 71 |
1748247 | 1748247 | 2021-09-23 | Greenbrier | West Virginia | 54025 | 4209 | 78 |
1722197 | 1722197 | 2021-09-15 | Wise | Virginia | 51195 | 4209 | 115 |
1719107 | 1719107 | 2021-09-14 | Trempealeau | Wisconsin | 55121 | 4209 | 51 |
1714767 | 1714767 | 2021-09-13 | Ottawa | Ohio | 39123 | 4209 | 83 |
1697588 | 1697588 | 2021-09-08 | West Baton Rouge | Louisiana | 22121 | 4209 | 71 |
1683594 | 1683594 | 2021-09-04 | Yell | Arkansas | 5149 | 4209 | 71 |
1676415 | 1676415 | 2021-09-01 | Kendall | Texas | 48259 | 4209 | 78 |
1664846 | 1664846 | 2021-08-29 | Geary | Kansas | 20061 | 4209 | 48 |
1661598 | 1661598 | 2021-08-28 | Geary | Kansas | 20061 | 4209 | 48 |
1658350 | 1658350 | 2021-08-27 | Geary | Kansas | 20061 | 4209 | 48 |
1646122 | 1646122 | 2021-08-23 | Dakota | Nebraska | 31043 | 4209 | 82 |
1642456 | 1642456 | 2021-08-22 | Huron | Michigan | 26063 | 4209 | 84 |
1642873 | 1642873 | 2021-08-22 | Dakota | Nebraska | 31043 | 4209 | 82 |
1643749 | 1643749 | 2021-08-22 | Henderson | Tennessee | 47077 | 4209 | 80 |
1639206 | 1639206 | 2021-08-21 | Huron | Michigan | 26063 | 4209 | 84 |
1639623 | 1639623 | 2021-08-21 | Dakota | Nebraska | 31043 | 4209 | 82 |
1640499 | 1640499 | 2021-08-21 | Henderson | Tennessee | 47077 | 4209 | 80 |
1635956 | 1635956 | 2021-08-20 | Huron | Michigan | 26063 | 4209 | 84 |
1636373 | 1636373 | 2021-08-20 | Dakota | Nebraska | 31043 | 4209 | 82 |
1637249 | 1637249 | 2021-08-20 | Henderson | Tennessee | 47077 | 4209 | 80 |
1633123 | 1633123 | 2021-08-19 | Dakota | Nebraska | 31043 | 4209 | 82 |
1629876 | 1629876 | 2021-08-18 | Dakota | Nebraska | 31043 | 4209 | 82 |
1625481 | 1625481 | 2021-08-17 | Wayne | Georgia | 13305 | 4209 | 93 |
1626629 | 1626629 | 2021-08-17 | Dakota | Nebraska | 31043 | 4209 | 82 |
1623382 | 1623382 | 2021-08-16 | Dakota | Nebraska | 31043 | 4209 | 82 |
1620135 | 1620135 | 2021-08-15 | Dakota | Nebraska | 31043 | 4209 | 82 |
1616887 | 1616887 | 2021-08-14 | Dakota | Nebraska | 31043 | 4209 | 82 |
1613639 | 1613639 | 2021-08-13 | Dakota | Nebraska | 31043 | 4209 | 82 |
1608709 | 1608709 | 2021-08-12 | Chambers | Alabama | 1017 | 4209 | 125 |
1610390 | 1610390 | 2021-08-12 | Dakota | Nebraska | 31043 | 4209 | 82 |
1607142 | 1607142 | 2021-08-11 | Dakota | Nebraska | 31043 | 4209 | 82 |
1603893 | 1603893 | 2021-08-10 | Dakota | Nebraska | 31043 | 4209 | 82 |
1604280 | 1604280 | 2021-08-10 | Crawford | Ohio | 39033 | 4209 | 112 |
1600644 | 1600644 | 2021-08-09 | Dakota | Nebraska | 31043 | 4209 | 82 |
1584367 | 1584367 | 2021-08-04 | Silver Bow | Montana | 30093 | 4209 | 86 |
1528149 | 1528149 | 2021-07-18 | Lee | Illinois | 17103 | 4209 | 93 |
1524902 | 1524902 | 2021-07-17 | Lee | Illinois | 17103 | 4209 | 93 |
1521654 | 1521654 | 2021-07-16 | Lee | Illinois | 17103 | 4209 | 93 |
1511539 | 1511539 | 2021-07-13 | La Plata | Colorado | 8067 | 4209 | 41 |
1513193 | 1513193 | 2021-07-13 | Davie | North Carolina | 37059 | 4209 | 40 |
1505178 | 1505178 | 2021-07-11 | Camden | Georgia | 13039 | 4209 | 39 |
1501932 | 1501932 | 2021-07-10 | Camden | Georgia | 13039 | 4209 | 39 |
1498686 | 1498686 | 2021-07-09 | Camden | Georgia | 13039 | 4209 | 39 |
1495508 | 1495508 | 2021-07-08 | Liberty | Georgia | 13179 | 4209 | 68 |
1421219 | 1421219 | 2021-06-15 | Jasper | Iowa | 19099 | 4209 | 72 |
1392745 | 1392745 | 2021-06-06 | Platte | Missouri | 29165 | 4209 | 47 |
1389500 | 1389500 | 2021-06-05 | Platte | Missouri | 29165 | 4209 | 47 |
1384292 | 1384292 | 2021-06-03 | Wharton | Texas | 48481 | 4209 | 116 |
1350177 | 1350177 | 2021-05-24 | Calvert | Maryland | 24009 | 4209 | 78 |
1340735 | 1340735 | 2021-05-21 | Butler | Missouri | 29023 | 4209 | 48 |
1332070 | 1332070 | 2021-05-18 | Marshall | Tennessee | 47117 | 4209 | 58 |
1332146 | 1332146 | 2021-05-18 | Cherokee | Texas | 48073 | 4209 | 140 |
1332181 | 1332181 | 2021-05-18 | Erath | Texas | 48143 | 4209 | 69 |
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);