ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
166 rows where cases = 2851 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Wisconsin 19
- Georgia 15
- Colorado 13
- Florida 9
- Kentucky 8
- Indiana 7
- Oklahoma 7
- California 6
- Maryland 6
- Minnesota 6
- Alabama 5
- Arkansas 5
- Missouri 5
- North Carolina 5
- Texas 5
- Virginia 5
- Illinois 4
- Mississippi 4
- Ohio 4
- Puerto Rico 4
- South Carolina 3
- Tennessee 3
- West Virginia 3
- Pennsylvania 2
- Idaho 1
- Iowa 1
- Louisiana 1
- Maine 1
- Montana 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2437988 | 2437988 | 2022-04-24 | Park | Colorado | 8093 | 2851 | 20 |
2434732 | 2434732 | 2022-04-23 | Park | Colorado | 8093 | 2851 | 20 |
2431476 | 2431476 | 2022-04-22 | Park | Colorado | 8093 | 2851 | 20 |
2339194 | 2339194 | 2022-03-24 | Orocovis | Puerto Rico | 72107 | 2851 | |
2324039 | 2324039 | 2022-03-20 | Archuleta | Colorado | 8007 | 2851 | 15 |
2320785 | 2320785 | 2022-03-19 | Archuleta | Colorado | 8007 | 2851 | 15 |
2317531 | 2317531 | 2022-03-18 | Archuleta | Colorado | 8007 | 2851 | 15 |
2314278 | 2314278 | 2022-03-17 | Archuleta | Colorado | 8007 | 2851 | 15 |
2311025 | 2311025 | 2022-03-16 | Archuleta | Colorado | 8007 | 2851 | 15 |
2239819 | 2239819 | 2022-02-22 | Gooding | Idaho | 16047 | 2851 | 52 |
2224891 | 2224891 | 2022-02-17 | Alleghany | North Carolina | 37005 | 2851 | 11 |
2215376 | 2215376 | 2022-02-14 | Vinton | Ohio | 39163 | 2851 | 52 |
2154456 | 2154456 | 2022-01-26 | Rockbridge | Virginia | 51163 | 2851 | 72 |
2146545 | 2146545 | 2022-01-24 | Glacier | Montana | 30035 | 2851 | 65 |
2127784 | 2127784 | 2022-01-18 | Salinas | Puerto Rico | 72123 | 2851 | |
2089577 | 2089577 | 2022-01-06 | Richland | Wisconsin | 55103 | 2851 | 38 |
2083763 | 2083763 | 2022-01-05 | Johnson | Illinois | 17087 | 2851 | 40 |
2084622 | 2084622 | 2022-01-05 | Bates | Missouri | 29013 | 2851 | 65 |
2081612 | 2081612 | 2022-01-04 | Saline | Nebraska | 31151 | 2851 | 6 |
2059273 | 2059273 | 2021-12-28 | Choctaw | Oklahoma | 40023 | 2851 | 52 |
2056024 | 2056024 | 2021-12-27 | Choctaw | Oklahoma | 40023 | 2851 | 52 |
2052775 | 2052775 | 2021-12-26 | Choctaw | Oklahoma | 40023 | 2851 | 52 |
2049525 | 2049525 | 2021-12-25 | Choctaw | Oklahoma | 40023 | 2851 | 52 |
2044266 | 2044266 | 2021-12-24 | Madison | Arkansas | 5087 | 2851 | 44 |
2046275 | 2046275 | 2021-12-24 | Choctaw | Oklahoma | 40023 | 2851 | 52 |
2043025 | 2043025 | 2021-12-23 | Choctaw | Oklahoma | 40023 | 2851 | 52 |
2039776 | 2039776 | 2021-12-22 | Choctaw | Oklahoma | 40023 | 2851 | 52 |
2032227 | 2032227 | 2021-12-20 | Union | Kentucky | 21225 | 2851 | 44 |
1982748 | 1982748 | 2021-12-05 | Banks | Georgia | 13011 | 2851 | 66 |
1979498 | 1979498 | 2021-12-04 | Banks | Georgia | 13011 | 2851 | 66 |
1981146 | 1981146 | 2021-12-04 | Richland | North Dakota | 38077 | 2851 | 21 |
1976248 | 1976248 | 2021-12-03 | Banks | Georgia | 13011 | 2851 | 66 |
1964695 | 1964695 | 2021-11-29 | Taos | New Mexico | 35055 | 2851 | 70 |
1918043 | 1918043 | 2021-11-15 | White | Illinois | 17193 | 2851 | 43 |
1915135 | 1915135 | 2021-11-14 | Garrard | Kentucky | 21079 | 2851 | 51 |
1911885 | 1911885 | 2021-11-13 | Garrard | Kentucky | 21079 | 2851 | 51 |
1908636 | 1908636 | 2021-11-12 | Garrard | Kentucky | 21079 | 2851 | 51 |
1901362 | 1901362 | 2021-11-10 | Elbert | Colorado | 8039 | 2851 | 23 |
1863294 | 1863294 | 2021-10-29 | Hancock | Maine | 23009 | 2851 | 50 |
1857127 | 1857127 | 2021-10-27 | Clinton | Missouri | 29049 | 2851 | 77 |
1855184 | 1855184 | 2021-10-26 | San Jacinto | Texas | 48407 | 2851 | 75 |
1850196 | 1850196 | 2021-10-25 | Morgan | Kentucky | 21175 | 2851 | 9 |
1810254 | 1810254 | 2021-10-13 | Grant | Arkansas | 5053 | 2851 | 47 |
1809987 | 1809987 | 2021-10-12 | Lewis | West Virginia | 54041 | 2851 | 43 |
1803904 | 1803904 | 2021-10-11 | Montezuma | Colorado | 8083 | 2851 | 34 |
1790649 | 1790649 | 2021-10-07 | Fayette | Alabama | 1057 | 2851 | 75 |
1791385 | 1791385 | 2021-10-07 | Orange | Indiana | 18117 | 2851 | 64 |
1768212 | 1768212 | 2021-09-30 | Dixie | Florida | 12029 | 2851 | 30 |
1769303 | 1769303 | 2021-09-30 | Clarke | Mississippi | 28023 | 2851 | 91 |
1764963 | 1764963 | 2021-09-29 | Dixie | Florida | 12029 | 2851 | 30 |
1761714 | 1761714 | 2021-09-28 | Dixie | Florida | 12029 | 2851 | 30 |
1758466 | 1758466 | 2021-09-27 | Dixie | Florida | 12029 | 2851 | 30 |
1755218 | 1755218 | 2021-09-26 | Dixie | Florida | 12029 | 2851 | 30 |
1751970 | 1751970 | 2021-09-25 | Dixie | Florida | 12029 | 2851 | 30 |
1748721 | 1748721 | 2021-09-24 | Dixie | Florida | 12029 | 2851 | 29 |
1745899 | 1745899 | 2021-09-23 | Owen | Indiana | 18119 | 2851 | 65 |
1709591 | 1709591 | 2021-09-12 | Colusa | California | 6011 | 2851 | 18 |
1709829 | 1709829 | 2021-09-12 | Crisp | Georgia | 13081 | 2851 | 96 |
1706582 | 1706582 | 2021-09-11 | Crisp | Georgia | 13081 | 2851 | 96 |
1703334 | 1703334 | 2021-09-10 | Crisp | Georgia | 13081 | 2851 | 96 |
1696517 | 1696517 | 2021-09-08 | Ashley | Arkansas | 5003 | 2851 | 39 |
1697509 | 1697509 | 2021-09-08 | Rowan | Kentucky | 21205 | 2851 | 22 |
1699411 | 1699411 | 2021-09-08 | Mecklenburg | Virginia | 51117 | 2851 | 71 |
1679142 | 1679142 | 2021-09-02 | Columbia | Oregon | 41009 | 2851 | 35 |
1659787 | 1659787 | 2021-08-27 | Gurabo | Puerto Rico | 72063 | 2851 | |
1637934 | 1637934 | 2021-08-21 | Barbour | Alabama | 1005 | 2851 | 65 |
1586418 | 1586418 | 2021-08-05 | Haralson | Georgia | 13143 | 2851 | 91 |
1576983 | 1576983 | 2021-08-02 | Scott | Indiana | 18143 | 2851 | 60 |
1517821 | 1517821 | 2021-07-15 | Winston | Alabama | 1133 | 2851 | 72 |
1514574 | 1514574 | 2021-07-14 | Winston | Alabama | 1133 | 2851 | 72 |
1512863 | 1512863 | 2021-07-13 | Stone | Missouri | 29209 | 2851 | 50 |
1463779 | 1463779 | 2021-06-28 | Dorchester | Maryland | 24019 | 2851 | 65 |
1465733 | 1465733 | 2021-06-28 | Door | Wisconsin | 55029 | 2851 | 31 |
1460534 | 1460534 | 2021-06-27 | Dorchester | Maryland | 24019 | 2851 | 65 |
1462488 | 1462488 | 2021-06-27 | Door | Wisconsin | 55029 | 2851 | 31 |
1457289 | 1457289 | 2021-06-26 | Dorchester | Maryland | 24019 | 2851 | 65 |
1459243 | 1459243 | 2021-06-26 | Door | Wisconsin | 55029 | 2851 | 31 |
1454044 | 1454044 | 2021-06-25 | Dorchester | Maryland | 24019 | 2851 | 65 |
1455998 | 1455998 | 2021-06-25 | Door | Wisconsin | 55029 | 2851 | 31 |
1450799 | 1450799 | 2021-06-24 | Dorchester | Maryland | 24019 | 2851 | 65 |
1451060 | 1451060 | 2021-06-24 | Prentiss | Mississippi | 28117 | 2851 | 61 |
1452753 | 1452753 | 2021-06-24 | Door | Wisconsin | 55029 | 2851 | 31 |
1449479 | 1449479 | 2021-06-23 | Randolph | West Virginia | 54083 | 2851 | 15 |
1449507 | 1449507 | 2021-06-23 | Door | Wisconsin | 55029 | 2851 | 31 |
1446262 | 1446262 | 2021-06-22 | Door | Wisconsin | 55029 | 2851 | 31 |
1440939 | 1440939 | 2021-06-21 | Montgomery | Kentucky | 21173 | 2851 | 30 |
1443017 | 1443017 | 2021-06-21 | Door | Wisconsin | 55029 | 2851 | 31 |
1439772 | 1439772 | 2021-06-20 | Door | Wisconsin | 55029 | 2851 | 31 |
1436525 | 1436525 | 2021-06-19 | Door | Wisconsin | 55029 | 2851 | 31 |
1433278 | 1433278 | 2021-06-18 | Door | Wisconsin | 55029 | 2851 | 31 |
1430032 | 1430032 | 2021-06-17 | Door | Wisconsin | 55029 | 2851 | 31 |
1426787 | 1426787 | 2021-06-16 | Door | Wisconsin | 55029 | 2851 | 31 |
1421963 | 1421963 | 2021-06-15 | Saline | Missouri | 29195 | 2851 | 38 |
1423541 | 1423541 | 2021-06-15 | Door | Wisconsin | 55029 | 2851 | 31 |
1420294 | 1420294 | 2021-06-14 | Door | Wisconsin | 55029 | 2851 | 30 |
1417049 | 1417049 | 2021-06-13 | Door | Wisconsin | 55029 | 2851 | 30 |
1413803 | 1413803 | 2021-06-12 | Door | Wisconsin | 55029 | 2851 | 30 |
1410558 | 1410558 | 2021-06-11 | Door | Wisconsin | 55029 | 2851 | 30 |
1402238 | 1402238 | 2021-06-09 | Cass | Minnesota | 27021 | 2851 | 32 |
1392567 | 1392567 | 2021-06-06 | Todd | Minnesota | 27153 | 2851 | 32 |
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);