ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where cases = 3270 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 14
- Montana 13
- Michigan 11
- Mississippi 11
- Tennessee 10
- Puerto Rico 8
- Missouri 6
- Wisconsin 6
- Minnesota 5
- North Carolina 5
- Virginia 5
- Alabama 4
- Kentucky 4
- Louisiana 4
- South Carolina 4
- Illinois 3
- Indiana 3
- Nevada 3
- New Hampshire 3
- North Dakota 3
- Pennsylvania 3
- Texas 3
- Washington 3
- Arkansas 2
- Colorado 2
- Idaho 2
- New York 2
- Ohio 2
- Wyoming 2
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468271 | 2468271 | 2022-05-03 | Gogebic | Michigan | 26053 | 3270 | 69 |
2465016 | 2465016 | 2022-05-02 | Gogebic | Michigan | 26053 | 3270 | 69 |
2461760 | 2461760 | 2022-05-01 | Gogebic | Michigan | 26053 | 3270 | 69 |
2458504 | 2458504 | 2022-04-30 | Gogebic | Michigan | 26053 | 3270 | 69 |
2455248 | 2455248 | 2022-04-29 | Gogebic | Michigan | 26053 | 3270 | 69 |
2451992 | 2451992 | 2022-04-28 | Gogebic | Michigan | 26053 | 3270 | 69 |
2448736 | 2448736 | 2022-04-27 | Gogebic | Michigan | 26053 | 3270 | 69 |
2427714 | 2427714 | 2022-04-20 | Rockbridge | Virginia | 51163 | 3270 | 80 |
2424458 | 2424458 | 2022-04-19 | Rockbridge | Virginia | 51163 | 3270 | 79 |
2380753 | 2380753 | 2022-04-06 | Roosevelt | Montana | 30085 | 3270 | 72 |
2377498 | 2377498 | 2022-04-05 | Roosevelt | Montana | 30085 | 3270 | 72 |
2374245 | 2374245 | 2022-04-04 | Roosevelt | Montana | 30085 | 3270 | 72 |
2370993 | 2370993 | 2022-04-03 | Roosevelt | Montana | 30085 | 3270 | 72 |
2367740 | 2367740 | 2022-04-02 | Roosevelt | Montana | 30085 | 3270 | 72 |
2364487 | 2364487 | 2022-04-01 | Roosevelt | Montana | 30085 | 3270 | 72 |
2361233 | 2361233 | 2022-03-31 | Roosevelt | Montana | 30085 | 3270 | 72 |
2357979 | 2357979 | 2022-03-30 | Roosevelt | Montana | 30085 | 3270 | 72 |
2359483 | 2359483 | 2022-03-30 | Bayfield | Wisconsin | 55007 | 3270 | 39 |
2354726 | 2354726 | 2022-03-29 | Roosevelt | Montana | 30085 | 3270 | 72 |
2355476 | 2355476 | 2022-03-29 | Utuado | Puerto Rico | 72141 | 3270 | |
2356229 | 2356229 | 2022-03-29 | Bayfield | Wisconsin | 55007 | 3270 | 39 |
2352223 | 2352223 | 2022-03-28 | Utuado | Puerto Rico | 72141 | 3270 | |
2352976 | 2352976 | 2022-03-28 | Bayfield | Wisconsin | 55007 | 3270 | 39 |
2348221 | 2348221 | 2022-03-27 | Roosevelt | Montana | 30085 | 3270 | 72 |
2348971 | 2348971 | 2022-03-27 | Utuado | Puerto Rico | 72141 | 3270 | |
2344968 | 2344968 | 2022-03-26 | Roosevelt | Montana | 30085 | 3270 | 72 |
2345718 | 2345718 | 2022-03-26 | Utuado | Puerto Rico | 72141 | 3270 | |
2341715 | 2341715 | 2022-03-25 | Roosevelt | Montana | 30085 | 3270 | 72 |
2338462 | 2338462 | 2022-03-24 | Roosevelt | Montana | 30085 | 3270 | 72 |
2262266 | 2262266 | 2022-03-01 | Gunnison | Colorado | 8051 | 3270 | 14 |
2208782 | 2208782 | 2022-02-12 | Walsh | North Dakota | 38099 | 3270 | 34 |
2199362 | 2199362 | 2022-02-09 | Salinas | Puerto Rico | 72123 | 3270 | |
2107448 | 2107448 | 2022-01-12 | Morgan | Missouri | 29141 | 3270 | 79 |
2100445 | 2100445 | 2022-01-10 | Lewis | Kentucky | 21135 | 3270 | 71 |
2051153 | 2051153 | 2021-12-26 | Washington | Georgia | 13303 | 3270 | 124 |
2047903 | 2047903 | 2021-12-25 | Washington | Georgia | 13303 | 3270 | 124 |
2044653 | 2044653 | 2021-12-24 | Washington | Georgia | 13303 | 3270 | 124 |
2041404 | 2041404 | 2021-12-23 | Washington | Georgia | 13303 | 3270 | 124 |
2031677 | 2031677 | 2021-12-20 | Blaine | Idaho | 16013 | 3270 | 27 |
2017473 | 2017473 | 2021-12-15 | Trousdale | Tennessee | 47169 | 3270 | 28 |
1982751 | 1982751 | 2021-12-05 | Ben Hill | Georgia | 13017 | 3270 | 109 |
1979501 | 1979501 | 2021-12-04 | Ben Hill | Georgia | 13017 | 3270 | 109 |
1976251 | 1976251 | 2021-12-03 | Ben Hill | Georgia | 13017 | 3270 | 109 |
1938766 | 1938766 | 2021-11-21 | Caswell | North Carolina | 37033 | 3270 | 37 |
1935516 | 1935516 | 2021-11-20 | Caswell | North Carolina | 37033 | 3270 | 37 |
1932266 | 1932266 | 2021-11-19 | Caswell | North Carolina | 37033 | 3270 | 37 |
1884521 | 1884521 | 2021-11-04 | St. Croix | Virgin Islands | 78010 | 3270 | 34 |
1871037 | 1871037 | 2021-10-31 | Fairfield | South Carolina | 45039 | 3270 | 93 |
1867788 | 1867788 | 2021-10-30 | Fairfield | South Carolina | 45039 | 3270 | 93 |
1864539 | 1864539 | 2021-10-29 | Fairfield | South Carolina | 45039 | 3270 | 93 |
1861246 | 1861246 | 2021-10-28 | Rio Grande | Puerto Rico | 72119 | 3270 | |
1855107 | 1855107 | 2021-10-26 | Jones | Texas | 48253 | 3270 | 73 |
1847648 | 1847648 | 2021-10-24 | Sullivan | New Hampshire | 33019 | 3270 | 36 |
1844398 | 1844398 | 2021-10-23 | Sullivan | New Hampshire | 33019 | 3270 | 36 |
1841148 | 1841148 | 2021-10-22 | Sullivan | New Hampshire | 33019 | 3270 | 36 |
1819918 | 1819918 | 2021-10-16 | Randolph | Alabama | 1111 | 3270 | 63 |
1807486 | 1807486 | 2021-10-12 | Crawford | Illinois | 17033 | 3270 | 46 |
1779044 | 1779044 | 2021-10-03 | Attala | Mississippi | 28007 | 3270 | 88 |
1775794 | 1775794 | 2021-10-02 | Attala | Mississippi | 28007 | 3270 | 88 |
1772544 | 1772544 | 2021-10-01 | Attala | Mississippi | 28007 | 3270 | 88 |
1769295 | 1769295 | 2021-09-30 | Attala | Mississippi | 28007 | 3270 | 88 |
1764672 | 1764672 | 2021-09-29 | Marengo | Alabama | 1091 | 3270 | 85 |
1744418 | 1744418 | 2021-09-22 | Bledsoe | Tennessee | 47007 | 3270 | 13 |
1741576 | 1741576 | 2021-09-21 | Botetourt | Virginia | 51023 | 3270 | 39 |
1723448 | 1723448 | 2021-09-16 | Johnson | Kentucky | 21115 | 3270 | 40 |
1714507 | 1714507 | 2021-09-13 | Franklin | New York | 36033 | 3270 | 13 |
1715171 | 1715171 | 2021-09-13 | Yankton | South Dakota | 46135 | 3270 | 34 |
1694655 | 1694655 | 2021-09-07 | Adair | Missouri | 29001 | 3270 | 29 |
1690168 | 1690168 | 2021-09-06 | Delta | Colorado | 8029 | 3270 | 76 |
1692266 | 1692266 | 2021-09-06 | Dorado | Puerto Rico | 72051 | 3270 | |
1677336 | 1677336 | 2021-09-02 | Cook | Georgia | 13075 | 3270 | 48 |
1674123 | 1674123 | 2021-09-01 | Haralson | Georgia | 13143 | 3270 | 93 |
1626429 | 1626429 | 2021-08-17 | Wayne | Mississippi | 28153 | 3270 | 53 |
1613538 | 1613538 | 2021-08-13 | Saline | Missouri | 29195 | 3270 | 40 |
1609995 | 1609995 | 2021-08-12 | Mecosta | Michigan | 26107 | 3270 | 38 |
1610127 | 1610127 | 2021-08-12 | Coahoma | Mississippi | 28027 | 3270 | 86 |
1610979 | 1610979 | 2021-08-12 | Clarion | Pennsylvania | 42031 | 3270 | 96 |
1606747 | 1606747 | 2021-08-11 | Mecosta | Michigan | 26107 | 3270 | 38 |
1597481 | 1597481 | 2021-08-08 | Nye | Nevada | 32023 | 3270 | 111 |
1594232 | 1594232 | 2021-08-07 | Nye | Nevada | 32023 | 3270 | 111 |
1590983 | 1590983 | 2021-08-06 | Nye | Nevada | 32023 | 3270 | 111 |
1563802 | 1563802 | 2021-07-29 | Latah | Idaho | 16057 | 3270 | 12 |
1563843 | 1563843 | 2021-07-29 | Fayette | Illinois | 17051 | 3270 | 59 |
1553883 | 1553883 | 2021-07-26 | Butts | Georgia | 13035 | 3270 | 90 |
1507343 | 1507343 | 2021-07-11 | Lauderdale | Tennessee | 47097 | 3270 | 50 |
1504097 | 1504097 | 2021-07-10 | Lauderdale | Tennessee | 47097 | 3270 | 50 |
1500851 | 1500851 | 2021-07-09 | Lauderdale | Tennessee | 47097 | 3270 | 50 |
1497605 | 1497605 | 2021-07-08 | Lauderdale | Tennessee | 47097 | 3270 | 50 |
1494358 | 1494358 | 2021-07-07 | Lauderdale | Tennessee | 47097 | 3270 | 50 |
1491118 | 1491118 | 2021-07-06 | Marion | Tennessee | 47115 | 3270 | 49 |
1475543 | 1475543 | 2021-07-01 | Sheridan | Wyoming | 56033 | 3270 | 31 |
1472297 | 1472297 | 2021-06-30 | Sheridan | Wyoming | 56033 | 3270 | 31 |
1463690 | 1463690 | 2021-06-28 | Allen | Louisiana | 22003 | 3270 | 92 |
1429921 | 1429921 | 2021-06-17 | Wise | Virginia | 51195 | 3270 | 102 |
1426196 | 1426196 | 2021-06-16 | Lauderdale | Tennessee | 47097 | 3270 | 48 |
1398451 | 1398451 | 2021-06-08 | White | Indiana | 18181 | 3270 | 54 |
1333219 | 1333219 | 2021-05-19 | Madison | Georgia | 13195 | 3270 | 57 |
1311391 | 1311391 | 2021-05-12 | Pine | Minnesota | 27115 | 3270 | 22 |
1296961 | 1296961 | 2021-05-07 | Lincoln | Wisconsin | 55069 | 3270 | 92 |
1240062 | 1240062 | 2021-04-20 | Tate | Mississippi | 28137 | 3270 | 84 |
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);