ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
857 rows where cases = 246 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 85
- Virginia 54
- Georgia 52
- South Dakota 42
- Kansas 41
- Michigan 39
- Nebraska 28
- New York 28
- North Dakota 28
- Kentucky 27
- Illinois 23
- Iowa 23
- Oklahoma 23
- Colorado 22
- Ohio 22
- Alaska 21
- Indiana 20
- Idaho 19
- Minnesota 19
- North Carolina 19
- Puerto Rico 19
- Arkansas 18
- Mississippi 17
- Missouri 14
- Alabama 13
- South Carolina 12
- Tennessee 12
- Washington 12
- California 11
- West Virginia 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501845 | 2501845 | 2022-05-13 | Wheeler | Oregon | 41069 | 246 | 3 |
2498587 | 2498587 | 2022-05-12 | Wheeler | Oregon | 41069 | 246 | 3 |
2164955 | 2164955 | 2022-01-30 | Taliaferro | Georgia | 13265 | 246 | 3 |
2161700 | 2161700 | 2022-01-29 | Taliaferro | Georgia | 13265 | 246 | 3 |
2158444 | 2158444 | 2022-01-28 | Taliaferro | Georgia | 13265 | 246 | 3 |
2150406 | 2150406 | 2022-01-25 | Gilliam | Oregon | 41021 | 246 | 4 |
2137947 | 2137947 | 2022-01-21 | Motley | Texas | 48345 | 246 | 9 |
2134693 | 2134693 | 2022-01-20 | Motley | Texas | 48345 | 246 | 9 |
2126335 | 2126335 | 2022-01-18 | Lane | Kansas | 20101 | 246 | 10 |
2123083 | 2123083 | 2022-01-17 | Lane | Kansas | 20101 | 246 | 10 |
2124184 | 2124184 | 2022-01-17 | Sheridan | North Dakota | 38083 | 246 | 6 |
2119831 | 2119831 | 2022-01-16 | Lane | Kansas | 20101 | 246 | 10 |
2120932 | 2120932 | 2022-01-16 | Sheridan | North Dakota | 38083 | 246 | 6 |
2116579 | 2116579 | 2022-01-15 | Lane | Kansas | 20101 | 246 | 10 |
2113328 | 2113328 | 2022-01-14 | Lane | Kansas | 20101 | 246 | 10 |
2102859 | 2102859 | 2022-01-11 | Sierra | California | 6091 | 246 | 0 |
2099608 | 2099608 | 2022-01-10 | Sierra | California | 6091 | 246 | 0 |
2096216 | 2096216 | 2022-01-09 | Wrangell City and Borough | Alaska | 2275 | 246 | 1 |
2092964 | 2092964 | 2022-01-08 | Wrangell City and Borough | Alaska | 2275 | 246 | 1 |
2089712 | 2089712 | 2022-01-07 | Wrangell City and Borough | Alaska | 2275 | 246 | 1 |
1998031 | 1998031 | 2021-12-09 | Cottle | Texas | 48101 | 246 | 9 |
1994780 | 1994780 | 2021-12-08 | Cottle | Texas | 48101 | 246 | 9 |
1991529 | 1991529 | 2021-12-07 | Cottle | Texas | 48101 | 246 | 9 |
1981140 | 1981140 | 2021-12-04 | Oliver | North Dakota | 38065 | 246 | 3 |
1978500 | 1978500 | 2021-12-03 | Briscoe | Texas | 48045 | 246 | 7 |
1975250 | 1975250 | 2021-12-02 | Briscoe | Texas | 48045 | 246 | 7 |
1972001 | 1972001 | 2021-12-01 | Briscoe | Texas | 48045 | 246 | 7 |
1968751 | 1968751 | 2021-11-30 | Briscoe | Texas | 48045 | 246 | 7 |
1904622 | 1904622 | 2021-11-11 | Kiowa | Colorado | 8061 | 246 | 4 |
1901372 | 1901372 | 2021-11-10 | Kiowa | Colorado | 8061 | 246 | 4 |
1870308 | 1870308 | 2021-10-31 | Gosper | Nebraska | 31073 | 246 | 5 |
1867030 | 1867030 | 2021-10-30 | Boyd | Nebraska | 31015 | 246 | 4 |
1867059 | 1867059 | 2021-10-30 | Gosper | Nebraska | 31073 | 246 | 5 |
1863781 | 1863781 | 2021-10-29 | Boyd | Nebraska | 31015 | 246 | 4 |
1863810 | 1863810 | 2021-10-29 | Gosper | Nebraska | 31073 | 246 | 5 |
1861749 | 1861749 | 2021-10-28 | Rich | Utah | 49033 | 246 | 0 |
1858500 | 1858500 | 2021-10-27 | Rich | Utah | 49033 | 246 | 0 |
1853699 | 1853699 | 2021-10-26 | Cook | Minnesota | 27031 | 246 | 0 |
1854000 | 1854000 | 2021-10-26 | Meagher | Montana | 30059 | 246 | 8 |
1849199 | 1849199 | 2021-10-25 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 246 | 2 |
1845949 | 1845949 | 2021-10-24 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 246 | 2 |
1847142 | 1847142 | 2021-10-24 | Keweenaw | Michigan | 26083 | 246 | 4 |
1847200 | 1847200 | 2021-10-24 | Cook | Minnesota | 27031 | 246 | 0 |
1842699 | 1842699 | 2021-10-23 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 246 | 2 |
1843892 | 1843892 | 2021-10-23 | Keweenaw | Michigan | 26083 | 246 | 4 |
1843950 | 1843950 | 2021-10-23 | Cook | Minnesota | 27031 | 246 | 0 |
1839450 | 1839450 | 2021-10-22 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 246 | 2 |
1840642 | 1840642 | 2021-10-22 | Keweenaw | Michigan | 26083 | 246 | 4 |
1840700 | 1840700 | 2021-10-22 | Cook | Minnesota | 27031 | 246 | 0 |
1837451 | 1837451 | 2021-10-21 | Cook | Minnesota | 27031 | 246 | 0 |
1834202 | 1834202 | 2021-10-20 | Cook | Minnesota | 27031 | 246 | 0 |
1830953 | 1830953 | 2021-10-19 | Cook | Minnesota | 27031 | 246 | 0 |
1828412 | 1828412 | 2021-10-18 | Steele | North Dakota | 38091 | 246 | 2 |
1825163 | 1825163 | 2021-10-17 | Steele | North Dakota | 38091 | 246 | 2 |
1821914 | 1821914 | 2021-10-16 | Steele | North Dakota | 38091 | 246 | 2 |
1805285 | 1805285 | 2021-10-11 | Wheatland | Montana | 30107 | 246 | 12 |
1802036 | 1802036 | 2021-10-10 | Wheatland | Montana | 30107 | 246 | 12 |
1798787 | 1798787 | 2021-10-09 | Wheatland | Montana | 30107 | 246 | 12 |
1795538 | 1795538 | 2021-10-08 | Wheatland | Montana | 30107 | 246 | 12 |
1790693 | 1790693 | 2021-10-07 | Denali Borough | Alaska | 2068 | 246 | 1 |
1792289 | 1792289 | 2021-10-07 | Wheatland | Montana | 30107 | 246 | 12 |
1789040 | 1789040 | 2021-10-06 | Wheatland | Montana | 30107 | 246 | 12 |
1769582 | 1769582 | 2021-09-30 | Garfield | Nebraska | 31071 | 246 | 1 |
1766644 | 1766644 | 2021-09-29 | Divide | North Dakota | 38023 | 246 | 2 |
1755816 | 1755816 | 2021-09-26 | Hamilton | Kansas | 20075 | 246 | 1 |
1752568 | 1752568 | 2021-09-25 | Hamilton | Kansas | 20075 | 246 | 1 |
1749319 | 1749319 | 2021-09-24 | Hamilton | Kansas | 20075 | 246 | 1 |
1739558 | 1739558 | 2021-09-21 | Elk | Kansas | 20049 | 246 | 6 |
1736309 | 1736309 | 2021-09-20 | Elk | Kansas | 20049 | 246 | 6 |
1714477 | 1714477 | 2021-09-13 | Mora | New Mexico | 35033 | 246 | 9 |
1714668 | 1714668 | 2021-09-13 | Grant | North Dakota | 38037 | 246 | 7 |
1714704 | 1714704 | 2021-09-13 | Saipan | Northern Mariana Islands | 69110 | 246 | 2 |
1711422 | 1711422 | 2021-09-12 | Grant | North Dakota | 38037 | 246 | 7 |
1667006 | 1667006 | 2021-08-29 | San Juan | Washington | 53055 | 246 | 0 |
1663758 | 1663758 | 2021-08-28 | San Juan | Washington | 53055 | 246 | 0 |
1660510 | 1660510 | 2021-08-27 | San Juan | Washington | 53055 | 246 | 0 |
1657089 | 1657089 | 2021-08-26 | Grand Isle | Vermont | 50013 | 246 | 2 |
1646064 | 1646064 | 2021-08-23 | Granite | Montana | 30039 | 246 | 2 |
1625242 | 1625242 | 2021-08-17 | Sedgwick | Colorado | 8115 | 246 | 3 |
1606552 | 1606552 | 2021-08-11 | Robertson | Kentucky | 21201 | 246 | 14 |
1603303 | 1603303 | 2021-08-10 | Robertson | Kentucky | 21201 | 246 | 14 |
1600054 | 1600054 | 2021-08-09 | Robertson | Kentucky | 21201 | 246 | 14 |
1601788 | 1601788 | 2021-08-09 | Sherman | Texas | 48421 | 246 | 12 |
1595778 | 1595778 | 2021-08-08 | Dillingham Census Area | Alaska | 2070 | 246 | 2 |
1598540 | 1598540 | 2021-08-08 | Sherman | Texas | 48421 | 246 | 12 |
1592529 | 1592529 | 2021-08-07 | Dillingham Census Area | Alaska | 2070 | 246 | 2 |
1595291 | 1595291 | 2021-08-07 | Sherman | Texas | 48421 | 246 | 12 |
1589280 | 1589280 | 2021-08-06 | Dillingham Census Area | Alaska | 2070 | 246 | 2 |
1586031 | 1586031 | 2021-08-05 | Dillingham Census Area | Alaska | 2070 | 246 | 2 |
1586957 | 1586957 | 2021-08-05 | Woodson | Kansas | 20207 | 246 | 5 |
1587658 | 1587658 | 2021-08-05 | Franklin | Nebraska | 31061 | 246 | 4 |
1582781 | 1582781 | 2021-08-04 | Dillingham Census Area | Alaska | 2070 | 246 | 2 |
1583707 | 1583707 | 2021-08-04 | Woodson | Kansas | 20207 | 246 | 5 |
1584407 | 1584407 | 2021-08-04 | Franklin | Nebraska | 31061 | 246 | 4 |
1579531 | 1579531 | 2021-08-03 | Dillingham Census Area | Alaska | 2070 | 246 | 2 |
1581158 | 1581158 | 2021-08-03 | Franklin | Nebraska | 31061 | 246 | 4 |
1576283 | 1576283 | 2021-08-02 | Dillingham Census Area | Alaska | 2070 | 246 | 2 |
1576629 | 1576629 | 2021-08-02 | Clay | Georgia | 13061 | 246 | 3 |
1577909 | 1577909 | 2021-08-02 | Franklin | Nebraska | 31061 | 246 | 4 |
1574661 | 1574661 | 2021-08-01 | Franklin | Nebraska | 31061 | 246 | 4 |
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);