ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
621 rows where cases = 474 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 58
- Nebraska 37
- Colorado 35
- Missouri 32
- Georgia 30
- Illinois 29
- Oklahoma 28
- Kansas 25
- North Dakota 22
- Kentucky 19
- Virginia 19
- South Dakota 17
- Alabama 16
- Wisconsin 16
- Idaho 15
- Iowa 15
- Tennessee 15
- Indiana 14
- California 13
- New York 12
- Michigan 10
- North Carolina 10
- Oregon 10
- Pennsylvania 10
- Puerto Rico 10
- Louisiana 9
- Mississippi 9
- Washington 8
- West Virginia 8
- Alaska 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2284854 | 2284854 | 2022-03-08 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 474 | 5 |
2285065 | 2285065 | 2022-03-08 | Sedgwick | Colorado | 8115 | 474 | 8 |
2281602 | 2281602 | 2022-03-07 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 474 | 5 |
2281813 | 2281813 | 2022-03-07 | Sedgwick | Colorado | 8115 | 474 | 8 |
2280280 | 2280280 | 2022-03-06 | Golden Valley | North Dakota | 38033 | 474 | 4 |
2277027 | 2277027 | 2022-03-05 | Golden Valley | North Dakota | 38033 | 474 | 4 |
2273774 | 2273774 | 2022-03-04 | Golden Valley | North Dakota | 38033 | 474 | 4 |
2270521 | 2270521 | 2022-03-03 | Golden Valley | North Dakota | 38033 | 474 | 4 |
2267269 | 2267269 | 2022-03-02 | Golden Valley | North Dakota | 38033 | 474 | 4 |
2236556 | 2236556 | 2022-02-21 | Butte | Idaho | 16023 | 474 | 8 |
2233305 | 2233305 | 2022-02-20 | Butte | Idaho | 16023 | 474 | 8 |
2230054 | 2230054 | 2022-02-19 | Butte | Idaho | 16023 | 474 | 8 |
2226803 | 2226803 | 2022-02-18 | Butte | Idaho | 16023 | 474 | 8 |
2183489 | 2183489 | 2022-02-04 | Menard | Texas | 48327 | 474 | 12 |
2180237 | 2180237 | 2022-02-03 | Menard | Texas | 48327 | 474 | 12 |
2172970 | 2172970 | 2022-02-01 | Kidder | North Dakota | 38043 | 474 | 13 |
2173706 | 2173706 | 2022-02-01 | Knox | Texas | 48275 | 474 | 22 |
2170454 | 2170454 | 2022-01-31 | Knox | Texas | 48275 | 474 | 22 |
2167200 | 2167200 | 2022-01-30 | Knox | Texas | 48275 | 474 | 22 |
2163945 | 2163945 | 2022-01-29 | Knox | Texas | 48275 | 474 | 22 |
2151234 | 2151234 | 2022-01-25 | Columbia | Washington | 53013 | 474 | 10 |
2147982 | 2147982 | 2022-01-24 | Columbia | Washington | 53013 | 474 | 10 |
2133597 | 2133597 | 2022-01-20 | Frontier | Nebraska | 31063 | 474 | 2 |
2102693 | 2102693 | 2022-01-11 | Aleutians East Borough | Alaska | 2013 | 474 | 3 |
2099442 | 2099442 | 2022-01-10 | Aleutians East Borough | Alaska | 2013 | 474 | 3 |
2098849 | 2098849 | 2022-01-09 | Hardeman | Texas | 48197 | 474 | 14 |
2091646 | 2091646 | 2022-01-07 | Griggs | North Dakota | 38039 | 474 | 2 |
2088122 | 2088122 | 2022-01-06 | Sherman | Nebraska | 31163 | 474 | 4 |
2081872 | 2081872 | 2022-01-04 | Adams | North Dakota | 38001 | 474 | 8 |
2076032 | 2076032 | 2022-01-02 | Collingsworth | Texas | 48087 | 474 | 11 |
2072781 | 2072781 | 2022-01-01 | Collingsworth | Texas | 48087 | 474 | 11 |
2069530 | 2069530 | 2021-12-31 | Collingsworth | Texas | 48087 | 474 | 11 |
2066279 | 2066279 | 2021-12-30 | Collingsworth | Texas | 48087 | 474 | 11 |
2051532 | 2051532 | 2021-12-26 | Edwards | Kansas | 20047 | 474 | 13 |
2048282 | 2048282 | 2021-12-25 | Edwards | Kansas | 20047 | 474 | 13 |
2045032 | 2045032 | 2021-12-24 | Edwards | Kansas | 20047 | 474 | 13 |
2041783 | 2041783 | 2021-12-23 | Edwards | Kansas | 20047 | 474 | 13 |
2038533 | 2038533 | 2021-12-22 | Edwards | Kansas | 20047 | 474 | 13 |
2028823 | 2028823 | 2021-12-19 | Morton | Kansas | 20129 | 474 | 10 |
2025572 | 2025572 | 2021-12-18 | Morton | Kansas | 20129 | 474 | 10 |
2022321 | 2022321 | 2021-12-17 | Morton | Kansas | 20129 | 474 | 10 |
2008023 | 2008023 | 2021-12-12 | Grand Isle | Vermont | 50013 | 474 | 2 |
1992362 | 1992362 | 2021-12-08 | Custer | Colorado | 8027 | 474 | 12 |
1980666 | 1980666 | 2021-12-04 | Mercer | Missouri | 29129 | 474 | 9 |
1970945 | 1970945 | 2021-12-01 | Schuyler | Missouri | 29197 | 474 | 22 |
1971870 | 1971870 | 2021-12-01 | Potter | South Dakota | 46107 | 474 | 5 |
1945866 | 1945866 | 2021-11-23 | Stanley | South Dakota | 46117 | 474 | 3 |
1920009 | 1920009 | 2021-11-15 | Cochran | Texas | 48079 | 474 | 18 |
1916759 | 1916759 | 2021-11-14 | Cochran | Texas | 48079 | 474 | 18 |
1913509 | 1913509 | 2021-11-13 | Cochran | Texas | 48079 | 474 | 18 |
1902963 | 1902963 | 2021-11-10 | Hamilton | New York | 36041 | 474 | 3 |
1900352 | 1900352 | 2021-11-09 | Marshall | South Dakota | 46091 | 474 | 8 |
1893105 | 1893105 | 2021-11-07 | Valley | Nebraska | 31175 | 474 | 4 |
1889855 | 1889855 | 2021-11-06 | Valley | Nebraska | 31175 | 474 | 4 |
1886605 | 1886605 | 2021-11-05 | Valley | Nebraska | 31175 | 474 | 4 |
1881888 | 1881888 | 2021-11-04 | Ouray | Colorado | 8091 | 474 | 5 |
1883356 | 1883356 | 2021-11-04 | Valley | Nebraska | 31175 | 474 | 4 |
1883628 | 1883628 | 2021-11-04 | McIntosh | North Dakota | 38051 | 474 | 8 |
1884430 | 1884430 | 2021-11-04 | Shackelford | Texas | 48417 | 474 | 5 |
1880107 | 1880107 | 2021-11-03 | Valley | Nebraska | 31175 | 474 | 4 |
1880379 | 1880379 | 2021-11-03 | McIntosh | North Dakota | 38051 | 474 | 8 |
1859782 | 1859782 | 2021-10-28 | Gove | Kansas | 20063 | 474 | 22 |
1856533 | 1856533 | 2021-10-27 | Gove | Kansas | 20063 | 474 | 22 |
1854110 | 1854110 | 2021-10-26 | Stanton | Nebraska | 31167 | 474 | 11 |
1849177 | 1849177 | 2021-10-25 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 474 | 0 |
1850861 | 1850861 | 2021-10-25 | Stanton | Nebraska | 31167 | 474 | 11 |
1847611 | 1847611 | 2021-10-24 | Stanton | Nebraska | 31167 | 474 | 11 |
1844361 | 1844361 | 2021-10-23 | Stanton | Nebraska | 31167 | 474 | 11 |
1841111 | 1841111 | 2021-10-22 | Stanton | Nebraska | 31167 | 474 | 11 |
1837862 | 1837862 | 2021-10-21 | Stanton | Nebraska | 31167 | 474 | 11 |
1828115 | 1828115 | 2021-10-18 | Stanton | Nebraska | 31167 | 474 | 11 |
1822139 | 1822139 | 2021-10-16 | Cameron | Pennsylvania | 42023 | 474 | 10 |
1814360 | 1814360 | 2021-10-14 | Trego | Kansas | 20195 | 474 | 8 |
1811111 | 1811111 | 2021-10-13 | Trego | Kansas | 20195 | 474 | 8 |
1785088 | 1785088 | 2021-10-05 | Ness | Kansas | 20135 | 474 | 17 |
1781839 | 1781839 | 2021-10-04 | Ness | Kansas | 20135 | 474 | 17 |
1778589 | 1778589 | 2021-10-03 | Ness | Kansas | 20135 | 474 | 17 |
1775339 | 1775339 | 2021-10-02 | Ness | Kansas | 20135 | 474 | 17 |
1772089 | 1772089 | 2021-10-01 | Ness | Kansas | 20135 | 474 | 17 |
1768840 | 1768840 | 2021-09-30 | Ness | Kansas | 20135 | 474 | 17 |
1765591 | 1765591 | 2021-09-29 | Ness | Kansas | 20135 | 474 | 17 |
1759776 | 1759776 | 2021-09-27 | Musselshell | Montana | 30065 | 474 | 15 |
1759789 | 1759789 | 2021-09-27 | Sheridan | Montana | 30091 | 474 | 5 |
1756541 | 1756541 | 2021-09-26 | Sheridan | Montana | 30091 | 474 | 5 |
1753293 | 1753293 | 2021-09-25 | Sheridan | Montana | 30091 | 474 | 5 |
1750045 | 1750045 | 2021-09-24 | Sheridan | Montana | 30091 | 474 | 5 |
1743619 | 1743619 | 2021-09-22 | Nance | Nebraska | 31125 | 474 | 10 |
1727649 | 1727649 | 2021-09-17 | Bowman | North Dakota | 38011 | 474 | 6 |
1720691 | 1720691 | 2021-09-15 | Knox | Missouri | 29103 | 474 | 3 |
1717443 | 1717443 | 2021-09-14 | Knox | Missouri | 29103 | 474 | 3 |
1718528 | 1718528 | 2021-09-14 | Baylor | Texas | 48023 | 474 | 14 |
1715674 | 1715674 | 2021-09-13 | Rappahannock | Virginia | 51157 | 474 | 3 |
1700633 | 1700633 | 2021-09-09 | Rush | Kansas | 20165 | 474 | 15 |
1702435 | 1702435 | 2021-09-09 | Mason | Texas | 48319 | 474 | 7 |
1702509 | 1702509 | 2021-09-09 | Upton | Texas | 48461 | 474 | 11 |
1697384 | 1697384 | 2021-09-08 | Rush | Kansas | 20165 | 474 | 15 |
1699260 | 1699260 | 2021-09-08 | Upton | Texas | 48461 | 474 | 11 |
1678967 | 1678967 | 2021-09-02 | Wells | North Dakota | 38103 | 474 | 8 |
1670974 | 1670974 | 2021-08-31 | Bear Lake | Idaho | 16007 | 474 | 6 |
1647159 | 1647159 | 2021-08-23 | Haskell | Texas | 48207 | 474 | 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);