ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,517 rows where cases = 104 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Kansas 194
- Texas 174
- Kentucky 60
- Virginia 53
- Georgia 50
- Iowa 50
- Puerto Rico 48
- South Dakota 47
- Nebraska 45
- Illinois 44
- Missouri 44
- Montana 41
- Ohio 39
- North Carolina 38
- Indiana 36
- Minnesota 35
- Michigan 31
- New York 31
- Colorado 30
- Oklahoma 29
- North Dakota 27
- Utah 27
- Arkansas 26
- West Virginia 26
- Mississippi 25
- Pennsylvania 25
- Tennessee 21
- Louisiana 19
- New Mexico 18
- Nevada 16
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491512 | 2491512 | 2022-05-10 | Grant | Nebraska | 31075 | 104 | 5 |
2488254 | 2488254 | 2022-05-09 | Grant | Nebraska | 31075 | 104 | 5 |
2484997 | 2484997 | 2022-05-08 | Grant | Nebraska | 31075 | 104 | 5 |
2481739 | 2481739 | 2022-05-07 | Grant | Nebraska | 31075 | 104 | 5 |
2478481 | 2478481 | 2022-05-06 | Grant | Nebraska | 31075 | 104 | 5 |
2475223 | 2475223 | 2022-05-05 | Grant | Nebraska | 31075 | 104 | 5 |
2471966 | 2471966 | 2022-05-04 | Grant | Nebraska | 31075 | 104 | 5 |
2286475 | 2286475 | 2022-03-08 | Hayes | Nebraska | 31085 | 104 | 0 |
2283223 | 2283223 | 2022-03-07 | Hayes | Nebraska | 31085 | 104 | 0 |
2279970 | 2279970 | 2022-03-06 | Hayes | Nebraska | 31085 | 104 | 0 |
2276717 | 2276717 | 2022-03-05 | Hayes | Nebraska | 31085 | 104 | 0 |
2273464 | 2273464 | 2022-03-04 | Hayes | Nebraska | 31085 | 104 | 0 |
2218189 | 2218189 | 2022-02-15 | Grant | Nebraska | 31075 | 104 | 5 |
2171030 | 2171030 | 2022-02-01 | Skagway Municipality | Alaska | 2230 | 104 | 0 |
2171516 | 2171516 | 2022-02-01 | Clark | Idaho | 16033 | 104 | 0 |
2167777 | 2167777 | 2022-01-31 | Skagway Municipality | Alaska | 2230 | 104 | 0 |
2168263 | 2168263 | 2022-01-31 | Clark | Idaho | 16033 | 104 | 0 |
2149887 | 2149887 | 2022-01-25 | Keya Paha | Nebraska | 31103 | 104 | 0 |
2125660 | 2125660 | 2022-01-18 | Hinsdale | Colorado | 8053 | 104 | 0 |
2122408 | 2122408 | 2022-01-17 | Hinsdale | Colorado | 8053 | 104 | 0 |
2110892 | 2110892 | 2022-01-13 | Wheeler | Nebraska | 31183 | 104 | 0 |
1972904 | 1972904 | 2021-12-02 | San Juan | Colorado | 8111 | 104 | 0 |
1940396 | 1940396 | 2021-11-22 | San Juan | Colorado | 8111 | 104 | 0 |
1937146 | 1937146 | 2021-11-21 | San Juan | Colorado | 8111 | 104 | 0 |
1933896 | 1933896 | 2021-11-20 | San Juan | Colorado | 8111 | 104 | 0 |
1930644 | 1930644 | 2021-11-19 | San Juan | Colorado | 8111 | 104 | 0 |
1927394 | 1927394 | 2021-11-18 | San Juan | Colorado | 8111 | 104 | 0 |
1901397 | 1901397 | 2021-11-10 | San Juan | Colorado | 8111 | 104 | 0 |
1898147 | 1898147 | 2021-11-09 | San Juan | Colorado | 8111 | 104 | 0 |
1873483 | 1873483 | 2021-11-01 | Golden Valley | Montana | 30037 | 104 | 4 |
1851990 | 1851990 | 2021-10-25 | Daggett | Utah | 49009 | 104 | 0 |
1848740 | 1848740 | 2021-10-24 | Daggett | Utah | 49009 | 104 | 0 |
1845490 | 1845490 | 2021-10-23 | Daggett | Utah | 49009 | 104 | 0 |
1842240 | 1842240 | 2021-10-22 | Daggett | Utah | 49009 | 104 | 0 |
1838991 | 1838991 | 2021-10-21 | Daggett | Utah | 49009 | 104 | 0 |
1835742 | 1835742 | 2021-10-20 | Daggett | Utah | 49009 | 104 | 0 |
1763009 | 1763009 | 2021-09-28 | Garfield | Montana | 30033 | 104 | 3 |
1759760 | 1759760 | 2021-09-27 | Garfield | Montana | 30033 | 104 | 3 |
1756512 | 1756512 | 2021-09-26 | Garfield | Montana | 30033 | 104 | 3 |
1753264 | 1753264 | 2021-09-25 | Garfield | Montana | 30033 | 104 | 3 |
1750016 | 1750016 | 2021-09-24 | Garfield | Montana | 30033 | 104 | 3 |
1743517 | 1743517 | 2021-09-22 | Garfield | Montana | 30033 | 104 | 3 |
1744734 | 1744734 | 2021-09-22 | Throckmorton | Texas | 48447 | 104 | 5 |
1740268 | 1740268 | 2021-09-21 | Garfield | Montana | 30033 | 104 | 3 |
1737019 | 1737019 | 2021-09-20 | Garfield | Montana | 30033 | 104 | 3 |
1733769 | 1733769 | 2021-09-19 | Garfield | Montana | 30033 | 104 | 3 |
1730519 | 1730519 | 2021-09-18 | Garfield | Montana | 30033 | 104 | 3 |
1727269 | 1727269 | 2021-09-17 | Garfield | Montana | 30033 | 104 | 3 |
1724020 | 1724020 | 2021-09-16 | Garfield | Montana | 30033 | 104 | 3 |
1720911 | 1720911 | 2021-09-15 | Eureka | Nevada | 32011 | 104 | 0 |
1717663 | 1717663 | 2021-09-14 | Eureka | Nevada | 32011 | 104 | 0 |
1712931 | 1712931 | 2021-09-13 | Mineral | Colorado | 8079 | 104 | 1 |
1677003 | 1677003 | 2021-09-02 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 104 | 2 |
1666175 | 1666175 | 2021-08-29 | Sherman | Oregon | 41055 | 104 | 2 |
1662927 | 1662927 | 2021-08-28 | Sherman | Oregon | 41055 | 104 | 2 |
1659679 | 1659679 | 2021-08-27 | Sherman | Oregon | 41055 | 104 | 2 |
1655811 | 1655811 | 2021-08-26 | Judith Basin | Montana | 30045 | 104 | 1 |
1656430 | 1656430 | 2021-08-26 | Sherman | Oregon | 41055 | 104 | 2 |
1656667 | 1656667 | 2021-08-26 | Harding | South Dakota | 46063 | 104 | 1 |
1651161 | 1651161 | 2021-08-25 | Sierra | California | 6091 | 104 | 0 |
1647912 | 1647912 | 2021-08-24 | Sierra | California | 6091 | 104 | 0 |
1628262 | 1628262 | 2021-08-18 | Haines Borough | Alaska | 2100 | 104 | 0 |
1627832 | 1627832 | 2021-08-17 | Piute | Utah | 49031 | 104 | 2 |
1597520 | 1597520 | 2021-08-08 | Catron | New Mexico | 35003 | 104 | 6 |
1594271 | 1594271 | 2021-08-07 | Catron | New Mexico | 35003 | 104 | 6 |
1591022 | 1591022 | 2021-08-06 | Catron | New Mexico | 35003 | 104 | 6 |
1580389 | 1580389 | 2021-08-03 | Greeley | Kansas | 20071 | 104 | 1 |
1577140 | 1577140 | 2021-08-02 | Greeley | Kansas | 20071 | 104 | 1 |
1573892 | 1573892 | 2021-08-01 | Greeley | Kansas | 20071 | 104 | 1 |
1570644 | 1570644 | 2021-07-31 | Greeley | Kansas | 20071 | 104 | 1 |
1567396 | 1567396 | 2021-07-30 | Greeley | Kansas | 20071 | 104 | 1 |
1564148 | 1564148 | 2021-07-29 | Greeley | Kansas | 20071 | 104 | 1 |
1560900 | 1560900 | 2021-07-28 | Greeley | Kansas | 20071 | 104 | 1 |
1557653 | 1557653 | 2021-07-27 | Greeley | Kansas | 20071 | 104 | 1 |
1554406 | 1554406 | 2021-07-26 | Greeley | Kansas | 20071 | 104 | 1 |
1551159 | 1551159 | 2021-07-25 | Greeley | Kansas | 20071 | 104 | 1 |
1547912 | 1547912 | 2021-07-24 | Greeley | Kansas | 20071 | 104 | 1 |
1544665 | 1544665 | 2021-07-23 | Greeley | Kansas | 20071 | 104 | 1 |
1541417 | 1541417 | 2021-07-22 | Greeley | Kansas | 20071 | 104 | 1 |
1538170 | 1538170 | 2021-07-21 | Greeley | Kansas | 20071 | 104 | 1 |
1534922 | 1534922 | 2021-07-20 | Greeley | Kansas | 20071 | 104 | 1 |
1531675 | 1531675 | 2021-07-19 | Greeley | Kansas | 20071 | 104 | 1 |
1528428 | 1528428 | 2021-07-18 | Greeley | Kansas | 20071 | 104 | 1 |
1525181 | 1525181 | 2021-07-17 | Greeley | Kansas | 20071 | 104 | 1 |
1521933 | 1521933 | 2021-07-16 | Greeley | Kansas | 20071 | 104 | 1 |
1518685 | 1518685 | 2021-07-15 | Greeley | Kansas | 20071 | 104 | 1 |
1515438 | 1515438 | 2021-07-14 | Greeley | Kansas | 20071 | 104 | 1 |
1512192 | 1512192 | 2021-07-13 | Greeley | Kansas | 20071 | 104 | 1 |
1513970 | 1513970 | 2021-07-13 | Glasscock | Texas | 48173 | 104 | 2 |
1508945 | 1508945 | 2021-07-12 | Greeley | Kansas | 20071 | 104 | 1 |
1510724 | 1510724 | 2021-07-12 | Glasscock | Texas | 48173 | 104 | 2 |
1505699 | 1505699 | 2021-07-11 | Greeley | Kansas | 20071 | 104 | 1 |
1507477 | 1507477 | 2021-07-11 | Glasscock | Texas | 48173 | 104 | 2 |
1502453 | 1502453 | 2021-07-10 | Greeley | Kansas | 20071 | 104 | 1 |
1504231 | 1504231 | 2021-07-10 | Glasscock | Texas | 48173 | 104 | 2 |
1499207 | 1499207 | 2021-07-09 | Greeley | Kansas | 20071 | 104 | 1 |
1500985 | 1500985 | 2021-07-09 | Glasscock | Texas | 48173 | 104 | 2 |
1495960 | 1495960 | 2021-07-08 | Greeley | Kansas | 20071 | 104 | 1 |
1497739 | 1497739 | 2021-07-08 | Glasscock | Texas | 48173 | 104 | 2 |
1492714 | 1492714 | 2021-07-07 | Greeley | Kansas | 20071 | 104 | 1 |
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);