ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
167 rows where cases = 2702 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 14
- Missouri 12
- Illinois 9
- Virginia 9
- Kentucky 8
- Ohio 8
- Tennessee 8
- Alabama 7
- Colorado 7
- Mississippi 6
- New Mexico 6
- Minnesota 5
- Pennsylvania 5
- Texas 5
- West Virginia 5
- Indiana 4
- South Dakota 4
- Arkansas 3
- Idaho 3
- Kansas 3
- Louisiana 3
- Michigan 3
- Montana 3
- New York 3
- Puerto Rico 3
- Wisconsin 3
- Iowa 2
- Maine 2
- Nevada 2
- North Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2462311 | 2462311 | 2022-05-01 | Colfax | New Mexico | 35007 | 2702 | 65 |
2459055 | 2459055 | 2022-04-30 | Colfax | New Mexico | 35007 | 2702 | 65 |
2455799 | 2455799 | 2022-04-29 | Colfax | New Mexico | 35007 | 2702 | 65 |
2452543 | 2452543 | 2022-04-28 | Colfax | New Mexico | 35007 | 2702 | 65 |
2357684 | 2357684 | 2022-03-30 | Koochiching | Minnesota | 27071 | 2702 | 37 |
2337402 | 2337402 | 2022-03-24 | Teton | Idaho | 16081 | 2702 | 8 |
2334148 | 2334148 | 2022-03-23 | Teton | Idaho | 16081 | 2702 | 8 |
2332128 | 2332128 | 2022-03-22 | Los Alamos | New Mexico | 35028 | 2702 | 14 |
2328875 | 2328875 | 2022-03-21 | Los Alamos | New Mexico | 35028 | 2702 | 14 |
2242787 | 2242787 | 2022-02-23 | Rio Grande | Colorado | 8105 | 2702 | 44 |
2238460 | 2238460 | 2022-02-21 | Butte | South Dakota | 46019 | 2702 | 44 |
2235209 | 2235209 | 2022-02-20 | Butte | South Dakota | 46019 | 2702 | 44 |
2231958 | 2231958 | 2022-02-19 | Butte | South Dakota | 46019 | 2702 | 44 |
2228267 | 2228267 | 2022-02-18 | McLean | North Dakota | 38055 | 2702 | 49 |
2228707 | 2228707 | 2022-02-18 | Butte | South Dakota | 46019 | 2702 | 44 |
2221199 | 2221199 | 2022-02-16 | Noxubee | Mississippi | 28103 | 2702 | 48 |
2193151 | 2193151 | 2022-02-07 | Eastland | Texas | 48133 | 2702 | 98 |
2188203 | 2188203 | 2022-02-06 | Wilson | Kansas | 20205 | 2702 | 36 |
2184950 | 2184950 | 2022-02-05 | Wilson | Kansas | 20205 | 2702 | 36 |
2181698 | 2181698 | 2022-02-04 | Wilson | Kansas | 20205 | 2702 | 36 |
2177764 | 2177764 | 2022-02-03 | Unknown | Connecticut | 2702 | 0 | |
2163326 | 2163326 | 2022-01-29 | Vinton | Ohio | 39163 | 2702 | 47 |
2130984 | 2130984 | 2022-01-19 | Barceloneta | Puerto Rico | 72017 | 2702 | |
2126918 | 2126918 | 2022-01-18 | Dent | Missouri | 29065 | 2702 | 64 |
2109284 | 2109284 | 2022-01-13 | Marion | Arkansas | 5089 | 2702 | 75 |
2111448 | 2111448 | 2022-01-13 | Potter | Pennsylvania | 42105 | 2702 | 80 |
2081250 | 2081250 | 2022-01-04 | Pennington | Minnesota | 27113 | 2702 | 32 |
2081425 | 2081425 | 2022-01-04 | Macon | Missouri | 29121 | 2702 | 37 |
2079312 | 2079312 | 2022-01-03 | Falls | Texas | 48145 | 2702 | 52 |
2066544 | 2066544 | 2021-12-30 | Appomattox | Virginia | 51011 | 2702 | 38 |
2061144 | 2061144 | 2021-12-29 | Tipton | Indiana | 18159 | 2702 | 72 |
2028537 | 2028537 | 2021-12-19 | Piatt | Illinois | 17147 | 2702 | 21 |
2025286 | 2025286 | 2021-12-18 | Piatt | Illinois | 17147 | 2702 | 21 |
2022035 | 2022035 | 2021-12-17 | Piatt | Illinois | 17147 | 2702 | 21 |
2016219 | 2016219 | 2021-12-15 | Kanabec | Minnesota | 27065 | 2702 | 41 |
2012806 | 2012806 | 2021-12-14 | Sagadahoc | Maine | 23023 | 2702 | 16 |
2013006 | 2013006 | 2021-12-14 | Sibley | Minnesota | 27143 | 2702 | 19 |
1988377 | 1988377 | 2021-12-06 | Llano | Texas | 48299 | 2702 | 79 |
1959743 | 1959743 | 2021-11-28 | Izard | Arkansas | 5065 | 2702 | 55 |
1939788 | 1939788 | 2021-11-21 | Buchanan | Virginia | 51027 | 2702 | 71 |
1936538 | 1936538 | 2021-11-20 | Buchanan | Virginia | 51027 | 2702 | 71 |
1933288 | 1933288 | 2021-11-19 | Buchanan | Virginia | 51027 | 2702 | 71 |
1921647 | 1921647 | 2021-11-16 | Henry | Kentucky | 21103 | 2702 | 32 |
1918785 | 1918785 | 2021-11-15 | Holmes | Mississippi | 28051 | 2702 | 89 |
1898522 | 1898522 | 2021-11-09 | Pike | Illinois | 17149 | 2702 | 61 |
1898911 | 1898911 | 2021-11-09 | Lawrence | Kentucky | 21127 | 2702 | 41 |
1838438 | 1838438 | 2021-10-21 | Wyoming | Pennsylvania | 42131 | 2702 | 62 |
1835979 | 1835979 | 2021-10-20 | Lincoln | West Virginia | 54043 | 2702 | 42 |
1829515 | 1829515 | 2021-10-18 | Adams | Wisconsin | 55001 | 2702 | 33 |
1816748 | 1816748 | 2021-10-15 | Franklin | Arkansas | 5047 | 2702 | 51 |
1815600 | 1815600 | 2021-10-14 | Crook | Oregon | 41013 | 2702 | 45 |
1808367 | 1808367 | 2021-10-12 | Andrew | Missouri | 29003 | 2702 | 24 |
1767163 | 1767163 | 2021-09-29 | Cannon | Tennessee | 47015 | 2702 | 38 |
1762077 | 1762077 | 2021-09-28 | White | Illinois | 17193 | 2702 | 42 |
1756516 | 1756516 | 2021-09-26 | Hill | Montana | 30041 | 2702 | 51 |
1753268 | 1753268 | 2021-09-25 | Hill | Montana | 30041 | 2702 | 51 |
1750020 | 1750020 | 2021-09-24 | Hill | Montana | 30041 | 2702 | 51 |
1700143 | 1700143 | 2021-09-09 | Meriwether | Georgia | 13199 | 2702 | 93 |
1677208 | 1677208 | 2021-09-02 | Routt | Colorado | 8107 | 2702 | 21 |
1657006 | 1657006 | 2021-08-26 | Scurry | Texas | 48415 | 2702 | 65 |
1653501 | 1653501 | 2021-08-25 | Johnson | Tennessee | 47091 | 2702 | 40 |
1649218 | 1649218 | 2021-08-24 | Henry | Missouri | 29083 | 2702 | 41 |
1650254 | 1650254 | 2021-08-24 | Johnson | Tennessee | 47091 | 2702 | 40 |
1636770 | 1636770 | 2021-08-20 | Gallia | Ohio | 39053 | 2702 | 51 |
1631860 | 1631860 | 2021-08-19 | Cook | Georgia | 13075 | 2702 | 45 |
1632508 | 1632508 | 2021-08-19 | Marion | Kentucky | 21155 | 2702 | 39 |
1634146 | 1634146 | 2021-08-19 | Gray | Texas | 48179 | 2702 | 59 |
1625443 | 1625443 | 2021-08-17 | Pike | Georgia | 13231 | 2702 | 46 |
1627264 | 1627264 | 2021-08-17 | Warren | Pennsylvania | 42123 | 2702 | 107 |
1620815 | 1620815 | 2021-08-15 | Juncos | Puerto Rico | 72077 | 2702 | |
1601345 | 1601345 | 2021-08-09 | Rio Grande | Puerto Rico | 72119 | 2702 | |
1591529 | 1591529 | 2021-08-06 | Susquehanna | Pennsylvania | 42115 | 2702 | 62 |
1579751 | 1579751 | 2021-08-03 | Pitkin | Colorado | 8097 | 2702 | 4 |
1557305 | 1557305 | 2021-07-27 | Jerome | Idaho | 16053 | 2702 | 25 |
1557806 | 1557806 | 2021-07-27 | Mercer | Kentucky | 21167 | 2702 | 54 |
1559660 | 1559660 | 2021-07-27 | Botetourt | Virginia | 51023 | 2702 | 38 |
1531206 | 1531206 | 2021-07-19 | Harris | Georgia | 13145 | 2702 | 63 |
1504772 | 1504772 | 2021-07-11 | Bibb | Alabama | 1007 | 2702 | 65 |
1501526 | 1501526 | 2021-07-10 | Bibb | Alabama | 1007 | 2702 | 65 |
1493212 | 1493212 | 2021-07-07 | Covington | Mississippi | 28031 | 2702 | 83 |
1487364 | 1487364 | 2021-07-05 | Coshocton | Ohio | 39031 | 2702 | 60 |
1478493 | 1478493 | 2021-07-02 | Caroline | Virginia | 51033 | 2702 | 40 |
1469519 | 1469519 | 2021-06-30 | Haralson | Georgia | 13143 | 2702 | 90 |
1470621 | 1470621 | 2021-06-30 | Miller | Missouri | 29131 | 2702 | 57 |
1468798 | 1468798 | 2021-06-29 | Hopewell city | Virginia | 51670 | 2702 | 79 |
1438703 | 1438703 | 2021-06-20 | Holmes | Ohio | 39075 | 2702 | 101 |
1424648 | 1424648 | 2021-06-16 | Clay | Kentucky | 21051 | 2702 | 46 |
1426647 | 1426647 | 2021-06-16 | Pulaski | Virginia | 51155 | 2702 | 62 |
1394290 | 1394290 | 2021-06-06 | Mingo | West Virginia | 54059 | 2702 | 42 |
1391045 | 1391045 | 2021-06-05 | Mingo | West Virginia | 54059 | 2702 | 42 |
1387800 | 1387800 | 2021-06-04 | Mingo | West Virginia | 54059 | 2702 | 42 |
1381921 | 1381921 | 2021-06-03 | Monroe | Georgia | 13207 | 2702 | 99 |
1355752 | 1355752 | 2021-05-26 | Morgan | Colorado | 8087 | 2702 | 94 |
1350430 | 1350430 | 2021-05-24 | Marion | Mississippi | 28091 | 2702 | 80 |
1346366 | 1346366 | 2021-05-23 | Jersey | Illinois | 17083 | 2702 | 69 |
1343118 | 1343118 | 2021-05-22 | Jersey | Illinois | 17083 | 2702 | 69 |
1325088 | 1325088 | 2021-05-16 | Henry | Ohio | 39069 | 2702 | 66 |
1321842 | 1321842 | 2021-05-15 | Henry | Ohio | 39069 | 2702 | 66 |
1318596 | 1318596 | 2021-05-14 | Henry | Ohio | 39069 | 2702 | 66 |
1319680 | 1319680 | 2021-05-14 | Jackson | Wisconsin | 55053 | 2702 | 28 |
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);