ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
218 rows where cases = 2100 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 20
- Tennessee 17
- Illinois 15
- Texas 15
- Iowa 14
- Missouri 11
- Wisconsin 11
- Kentucky 9
- Arkansas 8
- Virginia 8
- Minnesota 7
- Oregon 7
- Puerto Rico 7
- Michigan 6
- Indiana 5
- North Carolina 5
- Ohio 5
- West Virginia 5
- Mississippi 4
- New Hampshire 4
- Arizona 3
- Kansas 3
- Maryland 3
- South Dakota 3
- Florida 2
- Idaho 2
- Louisiana 2
- Nevada 2
- New Mexico 2
- New York 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2452093 | 2452093 | 2022-04-28 | Marshall | Minnesota | 27089 | 2100 | 23 |
2338403 | 2338403 | 2022-03-24 | St. Clair | Missouri | 29185 | 2100 | 33 |
2327218 | 2327218 | 2022-03-21 | Searcy | Arkansas | 5129 | 2100 | 46 |
2323965 | 2323965 | 2022-03-20 | Searcy | Arkansas | 5129 | 2100 | 45 |
2320711 | 2320711 | 2022-03-19 | Searcy | Arkansas | 5129 | 2100 | 44 |
2317457 | 2317457 | 2022-03-18 | Searcy | Arkansas | 5129 | 2100 | 44 |
2291687 | 2291687 | 2022-03-10 | Clinch | Georgia | 13065 | 2100 | 40 |
2256391 | 2256391 | 2022-02-27 | Anderson | Kansas | 20003 | 2100 | 27 |
2253140 | 2253140 | 2022-02-26 | Anderson | Kansas | 20003 | 2100 | 27 |
2249889 | 2249889 | 2022-02-25 | Anderson | Kansas | 20003 | 2100 | 27 |
2240580 | 2240580 | 2022-02-22 | Clearwater | Minnesota | 27029 | 2100 | 29 |
2222125 | 2222125 | 2022-02-16 | Rincon | Puerto Rico | 72117 | 2100 | |
2205807 | 2205807 | 2022-02-11 | Adjuntas | Puerto Rico | 72001 | 2100 | |
2195253 | 2195253 | 2022-02-08 | Howard | Missouri | 29089 | 2100 | 23 |
2180799 | 2180799 | 2022-02-04 | Greenlee | Arizona | 4011 | 2100 | 30 |
2177548 | 2177548 | 2022-02-03 | Greenlee | Arizona | 4011 | 2100 | 30 |
2172345 | 2172345 | 2022-02-01 | Swift | Minnesota | 27151 | 2100 | 31 |
2149793 | 2149793 | 2022-01-25 | Fergus | Montana | 30027 | 2100 | 52 |
2136758 | 2136758 | 2022-01-21 | Wayne | Missouri | 29223 | 2100 | 41 |
2105204 | 2105204 | 2022-01-11 | Lake | Tennessee | 47095 | 2100 | 34 |
2101953 | 2101953 | 2022-01-10 | Lake | Tennessee | 47095 | 2100 | 34 |
2098702 | 2098702 | 2022-01-09 | Lake | Tennessee | 47095 | 2100 | 34 |
2095450 | 2095450 | 2022-01-08 | Lake | Tennessee | 47095 | 2100 | 34 |
2092198 | 2092198 | 2022-01-07 | Lake | Tennessee | 47095 | 2100 | 34 |
2088946 | 2088946 | 2022-01-06 | Lake | Tennessee | 47095 | 2100 | 34 |
2085372 | 2085372 | 2022-01-05 | Morrow | Oregon | 41049 | 2100 | 26 |
2085695 | 2085695 | 2022-01-05 | Lake | Tennessee | 47095 | 2100 | 34 |
2082443 | 2082443 | 2022-01-04 | Lake | Tennessee | 47095 | 2100 | 34 |
2058184 | 2058184 | 2021-12-28 | Lyon | Kentucky | 21143 | 2100 | 29 |
2035247 | 2035247 | 2021-12-21 | Union | Iowa | 19175 | 2100 | 42 |
2031997 | 2031997 | 2021-12-20 | Union | Iowa | 19175 | 2100 | 42 |
2033587 | 2033587 | 2021-12-20 | Charles Mix | South Dakota | 46023 | 2100 | 30 |
2028746 | 2028746 | 2021-12-19 | Union | Iowa | 19175 | 2100 | 42 |
2025495 | 2025495 | 2021-12-18 | Union | Iowa | 19175 | 2100 | 42 |
2022244 | 2022244 | 2021-12-17 | Union | Iowa | 19175 | 2100 | 42 |
2018993 | 2018993 | 2021-12-16 | Union | Iowa | 19175 | 2100 | 42 |
2015743 | 2015743 | 2021-12-15 | Union | Iowa | 19175 | 2100 | 42 |
2017820 | 2017820 | 2021-12-15 | Dickenson | Virginia | 51051 | 2100 | 32 |
1982971 | 1982971 | 2021-12-05 | Cumberland | Illinois | 17035 | 2100 | 39 |
1979721 | 1979721 | 2021-12-04 | Cumberland | Illinois | 17035 | 2100 | 39 |
1976471 | 1976471 | 2021-12-03 | Cumberland | Illinois | 17035 | 2100 | 39 |
1970771 | 1970771 | 2021-12-01 | Amite | Mississippi | 28005 | 2100 | 57 |
1917976 | 1917976 | 2021-11-15 | Greene | Illinois | 17061 | 2100 | 53 |
1916352 | 1916352 | 2021-11-14 | Tillamook | Oregon | 41057 | 2100 | 42 |
1913102 | 1913102 | 2021-11-13 | Tillamook | Oregon | 41057 | 2100 | 42 |
1909852 | 1909852 | 2021-11-12 | Tillamook | Oregon | 41057 | 2100 | 42 |
1871731 | 1871731 | 2021-10-31 | Monroe | West Virginia | 54063 | 2100 | 26 |
1813835 | 1813835 | 2021-10-14 | Jasper | Georgia | 13159 | 2100 | 57 |
1791319 | 1791319 | 2021-10-07 | Washington | Illinois | 17189 | 2100 | 34 |
1792196 | 1792196 | 2021-10-07 | Osage | Missouri | 29151 | 2100 | 22 |
1790290 | 1790290 | 2021-10-06 | Orleans | Vermont | 50019 | 2100 | 13 |
1787099 | 1787099 | 2021-10-05 | Giles | Virginia | 51071 | 2100 | 28 |
1781306 | 1781306 | 2021-10-04 | Dade | Georgia | 13083 | 2100 | 17 |
1769442 | 1769442 | 2021-09-30 | Mississippi | Missouri | 29133 | 2100 | 37 |
1756415 | 1756415 | 2021-09-26 | Gasconade | Missouri | 29073 | 2100 | 48 |
1738256 | 1738256 | 2021-09-20 | Wilbarger | Texas | 48487 | 2100 | 56 |
1738502 | 1738502 | 2021-09-20 | Hardy | West Virginia | 54031 | 2100 | 26 |
1735006 | 1735006 | 2021-09-19 | Wilbarger | Texas | 48487 | 2100 | 56 |
1731756 | 1731756 | 2021-09-18 | Wilbarger | Texas | 48487 | 2100 | 56 |
1682470 | 1682470 | 2021-09-03 | Montour | Pennsylvania | 42093 | 2100 | 67 |
1667321 | 1667321 | 2021-08-30 | Madison | Arkansas | 5087 | 2100 | 32 |
1665521 | 1665521 | 2021-08-29 | Ste. Genevieve | Missouri | 29186 | 2100 | 19 |
1650349 | 1650349 | 2021-08-24 | Colorado | Texas | 48089 | 2100 | 34 |
1647355 | 1647355 | 2021-08-23 | St. Croix | Virgin Islands | 78010 | 2100 | 17 |
1630560 | 1630560 | 2021-08-18 | Las Piedras | Puerto Rico | 72085 | 2100 | |
1616776 | 1616776 | 2021-08-14 | Pike | Missouri | 29163 | 2100 | 28 |
1609913 | 1609913 | 2021-08-12 | Garrett | Maryland | 24023 | 2100 | 66 |
1591604 | 1591604 | 2021-08-06 | San Lorenzo | Puerto Rico | 72129 | 2100 | |
1575575 | 1575575 | 2021-08-01 | Unicoi | Tennessee | 47171 | 2100 | 50 |
1572327 | 1572327 | 2021-07-31 | Unicoi | Tennessee | 47171 | 2100 | 50 |
1569079 | 1569079 | 2021-07-30 | Unicoi | Tennessee | 47171 | 2100 | 50 |
1559076 | 1559076 | 2021-07-27 | Corozal | Puerto Rico | 72047 | 2100 | |
1555829 | 1555829 | 2021-07-26 | Corozal | Puerto Rico | 72047 | 2100 | |
1537713 | 1537713 | 2021-07-21 | Jones | Georgia | 13169 | 2100 | 60 |
1534103 | 1534103 | 2021-07-20 | Ashley | Arkansas | 5003 | 2100 | 37 |
1532527 | 1532527 | 2021-07-19 | Coos | New Hampshire | 33007 | 2100 | 45 |
1529280 | 1529280 | 2021-07-18 | Coos | New Hampshire | 33007 | 2100 | 45 |
1526033 | 1526033 | 2021-07-17 | Coos | New Hampshire | 33007 | 2100 | 45 |
1522786 | 1522786 | 2021-07-16 | Coos | New Hampshire | 33007 | 2100 | 45 |
1511864 | 1511864 | 2021-07-13 | Bond | Illinois | 17005 | 2100 | 30 |
1508617 | 1508617 | 2021-07-12 | Bond | Illinois | 17005 | 2100 | 30 |
1494478 | 1494478 | 2021-07-07 | Falls | Texas | 48145 | 2100 | 33 |
1481491 | 1481491 | 2021-07-03 | Falls | Texas | 48145 | 2100 | 33 |
1425385 | 1425385 | 2021-06-16 | Churchill | Nevada | 32001 | 2100 | 49 |
1422137 | 1422137 | 2021-06-15 | Churchill | Nevada | 32001 | 2100 | 49 |
1401478 | 1401478 | 2021-06-09 | Elmore | Idaho | 16039 | 2100 | 19 |
1401960 | 1401960 | 2021-06-09 | Johnson | Kentucky | 21115 | 2100 | 35 |
1398715 | 1398715 | 2021-06-08 | Johnson | Kentucky | 21115 | 2100 | 35 |
1375429 | 1375429 | 2021-06-01 | Mitchell | Georgia | 13205 | 2100 | 82 |
1377633 | 1377633 | 2021-06-01 | Falls | Texas | 48145 | 2100 | 32 |
1372184 | 1372184 | 2021-05-31 | Mitchell | Georgia | 13205 | 2100 | 82 |
1374387 | 1374387 | 2021-05-31 | Falls | Texas | 48145 | 2100 | 32 |
1368939 | 1368939 | 2021-05-30 | Mitchell | Georgia | 13205 | 2100 | 82 |
1371142 | 1371142 | 2021-05-30 | Falls | Texas | 48145 | 2100 | 32 |
1365693 | 1365693 | 2021-05-29 | Mitchell | Georgia | 13205 | 2100 | 82 |
1367896 | 1367896 | 2021-05-29 | Falls | Texas | 48145 | 2100 | 32 |
1346154 | 1346154 | 2021-05-23 | Crisp | Georgia | 13081 | 2100 | 82 |
1348321 | 1348321 | 2021-05-23 | Polk | Tennessee | 47139 | 2100 | 25 |
1342906 | 1342906 | 2021-05-22 | Crisp | Georgia | 13081 | 2100 | 82 |
1345073 | 1345073 | 2021-05-22 | Polk | Tennessee | 47139 | 2100 | 25 |
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);