ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
115 rows where cases = 4230 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 11
- Kentucky 7
- Minnesota 7
- Illinois 6
- Ohio 6
- South Dakota 6
- Texas 6
- Virginia 6
- Wisconsin 6
- Louisiana 5
- Tennessee 5
- Alabama 4
- Georgia 4
- New York 4
- Colorado 3
- Idaho 3
- Indiana 3
- Puerto Rico 3
- Wyoming 3
- Alaska 2
- Michigan 2
- New Mexico 2
- Utah 2
- West Virginia 2
- Arizona 1
- California 1
- Iowa 1
- Missouri 1
- North Carolina 1
- Pennsylvania 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461079 | 2461079 | 2022-05-01 | Minidoka | Idaho | 16067 | 4230 | 63 |
2457823 | 2457823 | 2022-04-30 | Minidoka | Idaho | 16067 | 4230 | 63 |
2454567 | 2454567 | 2022-04-29 | Minidoka | Idaho | 16067 | 4230 | 63 |
2445618 | 2445618 | 2022-04-26 | Wadena | Minnesota | 27159 | 4230 | 55 |
2416333 | 2416333 | 2022-04-17 | Clarke | Mississippi | 28023 | 4230 | 108 |
2413077 | 2413077 | 2022-04-16 | Clarke | Mississippi | 28023 | 4230 | 108 |
2409821 | 2409821 | 2022-04-15 | Clarke | Mississippi | 28023 | 4230 | 108 |
2406565 | 2406565 | 2022-04-14 | Clarke | Mississippi | 28023 | 4230 | 108 |
2403309 | 2403309 | 2022-04-13 | Clarke | Mississippi | 28023 | 4230 | 108 |
2400055 | 2400055 | 2022-04-12 | Clarke | Mississippi | 28023 | 4230 | 108 |
2395287 | 2395287 | 2022-04-10 | Crawford | Wisconsin | 55023 | 4230 | 28 |
2392031 | 2392031 | 2022-04-09 | Crawford | Wisconsin | 55023 | 4230 | 28 |
2388775 | 2388775 | 2022-04-08 | Crawford | Wisconsin | 55023 | 4230 | 28 |
2385520 | 2385520 | 2022-04-07 | Crawford | Wisconsin | 55023 | 4230 | 28 |
2371749 | 2371749 | 2022-04-03 | Yauco | Puerto Rico | 72153 | 4230 | |
2356203 | 2356203 | 2022-03-29 | Morgan | West Virginia | 54065 | 4230 | 69 |
2333068 | 2333068 | 2022-03-22 | Lee | Texas | 48287 | 4230 | 60 |
2329815 | 2329815 | 2022-03-21 | Lee | Texas | 48287 | 4230 | 60 |
2326563 | 2326563 | 2022-03-20 | Lee | Texas | 48287 | 4230 | 60 |
2323310 | 2323310 | 2022-03-19 | Lee | Texas | 48287 | 4230 | 60 |
2311386 | 2311386 | 2022-03-16 | Carroll | Illinois | 17015 | 4230 | 48 |
2245823 | 2245823 | 2022-02-24 | North Slope Borough | Alaska | 2185 | 4230 | 11 |
2242572 | 2242572 | 2022-02-23 | North Slope Borough | Alaska | 2185 | 4230 | 11 |
2237101 | 2237101 | 2022-02-21 | Union | Kentucky | 21225 | 4230 | 54 |
2191156 | 2191156 | 2022-02-07 | White | Illinois | 17193 | 4230 | 50 |
2183054 | 2183054 | 2022-02-04 | Coamo | Puerto Rico | 72043 | 4230 | |
2123394 | 2123394 | 2022-01-17 | Charlevoix | Michigan | 26029 | 4230 | 54 |
2010838 | 2010838 | 2021-12-13 | Davison | South Dakota | 46035 | 4230 | 71 |
1996458 | 1996458 | 2021-12-09 | Rowan | Kentucky | 21205 | 4230 | 43 |
1962548 | 1962548 | 2021-11-28 | Caroline | Virginia | 51033 | 4230 | 54 |
1959297 | 1959297 | 2021-11-27 | Caroline | Virginia | 51033 | 4230 | 54 |
1956046 | 1956046 | 2021-11-26 | Caroline | Virginia | 51033 | 4230 | 54 |
1939453 | 1939453 | 2021-11-21 | Smith | Tennessee | 47159 | 4230 | 53 |
1936203 | 1936203 | 2021-11-20 | Smith | Tennessee | 47159 | 4230 | 53 |
1932953 | 1932953 | 2021-11-19 | Smith | Tennessee | 47159 | 4230 | 53 |
1857693 | 1857693 | 2021-10-27 | Gallia | Ohio | 39053 | 4230 | 68 |
1824182 | 1824182 | 2021-10-17 | Lincoln | Kentucky | 21137 | 4230 | 80 |
1824491 | 1824491 | 2021-10-17 | Nicollet | Minnesota | 27103 | 4230 | 51 |
1820933 | 1820933 | 2021-10-16 | Lincoln | Kentucky | 21137 | 4230 | 80 |
1821242 | 1821242 | 2021-10-16 | Nicollet | Minnesota | 27103 | 4230 | 51 |
1817684 | 1817684 | 2021-10-15 | Lincoln | Kentucky | 21137 | 4230 | 80 |
1817993 | 1817993 | 2021-10-15 | Nicollet | Minnesota | 27103 | 4230 | 51 |
1779746 | 1779746 | 2021-10-03 | Morrow | Ohio | 39117 | 4230 | 54 |
1777503 | 1777503 | 2021-10-02 | Mineral | West Virginia | 54057 | 4230 | 104 |
1766921 | 1766921 | 2021-09-29 | Greene | Pennsylvania | 42059 | 4230 | 48 |
1746632 | 1746632 | 2021-09-23 | Yazoo | Mississippi | 28163 | 4230 | 86 |
1732745 | 1732745 | 2021-09-19 | Bureau | Illinois | 17011 | 4230 | 100 |
1729495 | 1729495 | 2021-09-18 | Bureau | Illinois | 17011 | 4230 | 100 |
1726245 | 1726245 | 2021-09-17 | Bureau | Illinois | 17011 | 4230 | 100 |
1722303 | 1722303 | 2021-09-15 | Clark | Wisconsin | 55019 | 4230 | 69 |
1689955 | 1689955 | 2021-09-06 | Marion | Alabama | 1093 | 4230 | 111 |
1682497 | 1682497 | 2021-09-03 | Arecibo | Puerto Rico | 72013 | 4230 | |
1675561 | 1675561 | 2021-09-01 | Warren | New York | 36113 | 4230 | 72 |
1668178 | 1668178 | 2021-08-30 | Boyle | Kentucky | 21021 | 4230 | 80 |
1631135 | 1631135 | 2021-08-18 | Charlottesville city | Virginia | 51540 | 4230 | 58 |
1599358 | 1599358 | 2021-08-09 | Bryan | Georgia | 13029 | 4230 | 42 |
1536526 | 1536526 | 2021-07-20 | Campbell | Tennessee | 47013 | 4230 | 62 |
1527775 | 1527775 | 2021-07-18 | La Plata | Colorado | 8067 | 4230 | 41 |
1528652 | 1528652 | 2021-07-18 | Natchitoches | Louisiana | 22069 | 4230 | 95 |
1524528 | 1524528 | 2021-07-17 | La Plata | Colorado | 8067 | 4230 | 41 |
1525405 | 1525405 | 2021-07-17 | Natchitoches | Louisiana | 22069 | 4230 | 95 |
1521280 | 1521280 | 2021-07-16 | La Plata | Colorado | 8067 | 4230 | 41 |
1522157 | 1522157 | 2021-07-16 | Natchitoches | Louisiana | 22069 | 4230 | 95 |
1488136 | 1488136 | 2021-07-05 | Titus | Texas | 48449 | 4230 | 84 |
1382804 | 1382804 | 2021-06-03 | Morrison | Minnesota | 27097 | 4230 | 60 |
1379558 | 1379558 | 2021-06-02 | Morrison | Minnesota | 27097 | 4230 | 60 |
1376313 | 1376313 | 2021-06-01 | Morrison | Minnesota | 27097 | 4230 | 60 |
1369919 | 1369919 | 2021-05-30 | Pontotoc | Mississippi | 28115 | 4230 | 73 |
1370912 | 1370912 | 2021-05-30 | Brookings | South Dakota | 46011 | 4230 | 37 |
1366673 | 1366673 | 2021-05-29 | Pontotoc | Mississippi | 28115 | 4230 | 73 |
1367666 | 1367666 | 2021-05-29 | Brookings | South Dakota | 46011 | 4230 | 37 |
1363427 | 1363427 | 2021-05-28 | Pontotoc | Mississippi | 28115 | 4230 | 73 |
1364420 | 1364420 | 2021-05-28 | Brookings | South Dakota | 46011 | 4230 | 37 |
1353532 | 1353532 | 2021-05-25 | Sanilac | Michigan | 26151 | 4230 | 118 |
1341655 | 1341655 | 2021-05-21 | Chester | South Carolina | 45023 | 4230 | 76 |
1318398 | 1318398 | 2021-05-14 | Tompkins | New York | 36109 | 4230 | 51 |
1312087 | 1312087 | 2021-05-12 | Defiance | Ohio | 39039 | 4230 | 97 |
1285906 | 1285906 | 2021-05-04 | Livingston | New York | 36051 | 4230 | 58 |
1281547 | 1281547 | 2021-05-03 | Montgomery | Indiana | 18107 | 4230 | 90 |
1278261 | 1278261 | 2021-05-02 | DeKalb | Indiana | 18033 | 4230 | 87 |
1280786 | 1280786 | 2021-05-02 | Sweetwater | Wyoming | 56037 | 4230 | 37 |
1277539 | 1277539 | 2021-05-01 | Sweetwater | Wyoming | 56037 | 4230 | 37 |
1274292 | 1274292 | 2021-04-30 | Sweetwater | Wyoming | 56037 | 4230 | 37 |
1267832 | 1267832 | 2021-04-29 | Franklin | Alabama | 1059 | 4230 | 82 |
1193994 | 1193994 | 2021-04-06 | Wapello | Iowa | 19179 | 4230 | 120 |
1190592 | 1190592 | 2021-04-05 | Harrison | Indiana | 18061 | 4230 | 72 |
1189086 | 1189086 | 2021-04-04 | Codington | South Dakota | 46029 | 4230 | 80 |
1185839 | 1185839 | 2021-04-03 | Codington | South Dakota | 46029 | 4230 | 80 |
1181972 | 1181972 | 2021-04-02 | Clinton | New York | 36019 | 4230 | 30 |
1173680 | 1173680 | 2021-03-31 | Russell | Alabama | 1113 | 4230 | 36 |
1092190 | 1092190 | 2021-03-05 | Henry | Virginia | 51089 | 4230 | 115 |
1077376 | 1077376 | 2021-03-01 | Lincoln | Louisiana | 22061 | 4230 | 89 |
1074130 | 1074130 | 2021-02-28 | Lincoln | Louisiana | 22061 | 4230 | 89 |
1053900 | 1053900 | 2021-02-22 | Baldwin | Georgia | 13009 | 4230 | 107 |
1025345 | 1025345 | 2021-02-13 | Henderson | Kentucky | 21101 | 4230 | 57 |
1010132 | 1010132 | 2021-02-08 | Athens | Ohio | 39009 | 4230 | 12 |
961447 | 961447 | 2021-01-24 | Auglaize | Ohio | 39011 | 4230 | 64 |
955777 | 955777 | 2021-01-22 | Iron | Utah | 49021 | 4230 | 20 |
952532 | 952532 | 2021-01-21 | Iron | Utah | 49021 | 4230 | 20 |
902966 | 902966 | 2021-01-06 | Wilkes | North Carolina | 37193 | 4230 | 75 |
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);