ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
390 rows where cases = 1328 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 26
- Texas 25
- Kentucky 22
- Mississippi 22
- Kansas 21
- Georgia 17
- Virginia 16
- Minnesota 13
- North Carolina 13
- Puerto Rico 13
- Tennessee 13
- Alabama 11
- Iowa 11
- Michigan 11
- Indiana 10
- South Dakota 10
- West Virginia 10
- Illinois 8
- Ohio 8
- Colorado 7
- Montana 7
- New Mexico 7
- Wisconsin 7
- Alaska 5
- Florida 5
- Nebraska 5
- Oregon 5
- South Carolina 5
- Wyoming 5
- Louisiana 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2329938 | 2329938 | 2022-03-21 | Kane | Utah | 49025 | 1328 | 13 |
2278350 | 2278350 | 2022-03-06 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1328 | 9 |
2275097 | 2275097 | 2022-03-05 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1328 | 9 |
2271844 | 2271844 | 2022-03-04 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1328 | 9 |
2251373 | 2251373 | 2022-02-25 | Maunabo | Puerto Rico | 72095 | 1328 | |
2222240 | 2222240 | 2022-02-16 | McCook | South Dakota | 46087 | 1328 | 30 |
2217459 | 2217459 | 2022-02-15 | Rooks | Kansas | 20163 | 1328 | 20 |
2214208 | 2214208 | 2022-02-14 | Rooks | Kansas | 20163 | 1328 | 20 |
2212781 | 2212781 | 2022-02-13 | Newton | Texas | 48351 | 1328 | 57 |
2193984 | 2193984 | 2022-02-08 | Huerfano | Colorado | 8055 | 1328 | 28 |
2194681 | 2194681 | 2022-02-08 | Phillips | Kansas | 20147 | 1328 | 28 |
2191427 | 2191427 | 2022-02-07 | Phillips | Kansas | 20147 | 1328 | 28 |
2178445 | 2178445 | 2022-02-03 | Washington | Kansas | 20201 | 1328 | 20 |
2175192 | 2175192 | 2022-02-02 | Washington | Kansas | 20201 | 1328 | 20 |
2145509 | 2145509 | 2022-01-24 | Power | Idaho | 16077 | 1328 | 17 |
2142649 | 2142649 | 2022-01-23 | Stevens | Kansas | 20189 | 1328 | 17 |
2139394 | 2139394 | 2022-01-22 | Stevens | Kansas | 20189 | 1328 | 17 |
2136138 | 2136138 | 2022-01-21 | Stevens | Kansas | 20189 | 1328 | 17 |
2133557 | 2133557 | 2022-01-20 | Stillwater | Montana | 30095 | 1328 | 29 |
2119417 | 2119417 | 2022-01-16 | Twiggs | Georgia | 13289 | 1328 | 62 |
2116165 | 2116165 | 2022-01-15 | Twiggs | Georgia | 13289 | 1328 | 62 |
2112914 | 2112914 | 2022-01-14 | Twiggs | Georgia | 13289 | 1328 | 62 |
2097619 | 2097619 | 2022-01-09 | Wilkinson | Mississippi | 28157 | 1328 | 39 |
2099120 | 2099120 | 2022-01-09 | Lancaster | Virginia | 51103 | 1328 | 24 |
2094367 | 2094367 | 2022-01-08 | Wilkinson | Mississippi | 28157 | 1328 | 39 |
2095261 | 2095261 | 2022-01-08 | Patillas | Puerto Rico | 72109 | 1328 | |
2095869 | 2095869 | 2022-01-08 | Lancaster | Virginia | 51103 | 1328 | 24 |
2091115 | 2091115 | 2022-01-07 | Wilkinson | Mississippi | 28157 | 1328 | 39 |
2092617 | 2092617 | 2022-01-07 | Lancaster | Virginia | 51103 | 1328 | 24 |
2088758 | 2088758 | 2022-01-06 | Penuelas | Puerto Rico | 72111 | 1328 | |
2088855 | 2088855 | 2022-01-06 | Fall River | South Dakota | 46047 | 1328 | 31 |
2057272 | 2057272 | 2021-12-28 | Newton | Arkansas | 5101 | 1328 | 43 |
2057658 | 2057658 | 2021-12-28 | Wilcox | Georgia | 13315 | 1328 | 62 |
2059606 | 2059606 | 2021-12-28 | Hutchinson | South Dakota | 46067 | 1328 | 29 |
2053893 | 2053893 | 2021-12-27 | Greene | Alabama | 1063 | 1328 | 45 |
2050643 | 2050643 | 2021-12-26 | Greene | Alabama | 1063 | 1328 | 45 |
2047393 | 2047393 | 2021-12-25 | Greene | Alabama | 1063 | 1328 | 45 |
2041032 | 2041032 | 2021-12-23 | Prairie | Arkansas | 5117 | 1328 | 30 |
2035666 | 2035666 | 2021-12-21 | Montmorency | Michigan | 26119 | 1328 | 39 |
2032416 | 2032416 | 2021-12-20 | Montmorency | Michigan | 26119 | 1328 | 39 |
2020728 | 2020728 | 2021-12-16 | Van Buren | Tennessee | 47175 | 1328 | 33 |
1996796 | 1996796 | 2021-12-09 | Humphreys | Mississippi | 28053 | 1328 | 39 |
1997985 | 1997985 | 2021-12-09 | Archer | Texas | 48009 | 1328 | 24 |
1993545 | 1993545 | 2021-12-08 | Humphreys | Mississippi | 28053 | 1328 | 39 |
1977450 | 1977450 | 2021-12-03 | St. Clair | Missouri | 29185 | 1328 | 27 |
1973583 | 1973583 | 2021-12-02 | Russell | Kansas | 20167 | 1328 | 34 |
1974200 | 1974200 | 2021-12-02 | St. Clair | Missouri | 29185 | 1328 | 27 |
1970333 | 1970333 | 2021-12-01 | Russell | Kansas | 20167 | 1328 | 34 |
1965725 | 1965725 | 2021-11-29 | Winkler | Texas | 48495 | 1328 | 32 |
1960629 | 1960629 | 2021-11-28 | Crittenden | Kentucky | 21055 | 1328 | 36 |
1957378 | 1957378 | 2021-11-27 | Crittenden | Kentucky | 21055 | 1328 | 36 |
1954127 | 1954127 | 2021-11-26 | Crittenden | Kentucky | 21055 | 1328 | 36 |
1950876 | 1950876 | 2021-11-25 | Crittenden | Kentucky | 21055 | 1328 | 36 |
1947625 | 1947625 | 2021-11-24 | Crittenden | Kentucky | 21055 | 1328 | 36 |
1936946 | 1936946 | 2021-11-21 | Greenlee | Arizona | 4011 | 1328 | 18 |
1906060 | 1906060 | 2021-11-11 | Holt | Nebraska | 31089 | 1328 | 16 |
1879916 | 1879916 | 2021-11-03 | Monroe | Missouri | 29137 | 1328 | 13 |
1876667 | 1876667 | 2021-11-02 | Monroe | Missouri | 29137 | 1328 | 13 |
1876786 | 1876786 | 2021-11-02 | Cheyenne | Nebraska | 31033 | 1328 | 19 |
1872334 | 1872334 | 2021-11-01 | Macon | Georgia | 13193 | 1328 | 43 |
1873418 | 1873418 | 2021-11-01 | Monroe | Missouri | 29137 | 1328 | 13 |
1873537 | 1873537 | 2021-11-01 | Cheyenne | Nebraska | 31033 | 1328 | 19 |
1870169 | 1870169 | 2021-10-31 | Monroe | Missouri | 29137 | 1328 | 13 |
1870655 | 1870655 | 2021-10-31 | Traill | North Dakota | 38097 | 1328 | 20 |
1866920 | 1866920 | 2021-10-30 | Monroe | Missouri | 29137 | 1328 | 13 |
1857386 | 1857386 | 2021-10-27 | White Pine | Nevada | 32033 | 1328 | 11 |
1853782 | 1853782 | 2021-10-26 | Claiborne | Mississippi | 28021 | 1328 | 38 |
1854299 | 1854299 | 2021-10-26 | Graham | North Carolina | 37075 | 1328 | 28 |
1850533 | 1850533 | 2021-10-25 | Claiborne | Mississippi | 28021 | 1328 | 37 |
1837682 | 1837682 | 2021-10-21 | Oregon | Missouri | 29149 | 1328 | 11 |
1833067 | 1833067 | 2021-10-20 | Mariposa | California | 6043 | 1328 | 15 |
1834433 | 1834433 | 2021-10-20 | Oregon | Missouri | 29149 | 1328 | 11 |
1830924 | 1830924 | 2021-10-19 | Presque Isle | Michigan | 26141 | 1328 | 36 |
1832851 | 1832851 | 2021-10-19 | Platte | Wyoming | 56031 | 1328 | 24 |
1827675 | 1827675 | 2021-10-18 | Presque Isle | Michigan | 26141 | 1328 | 36 |
1827764 | 1827764 | 2021-10-18 | Swift | Minnesota | 27151 | 1328 | 19 |
1829314 | 1829314 | 2021-10-18 | Clarke | Virginia | 51043 | 1328 | 22 |
1810751 | 1810751 | 2021-10-13 | Hamilton | Illinois | 17065 | 1328 | 25 |
1808293 | 1808293 | 2021-10-12 | Choctaw | Mississippi | 28019 | 1328 | 26 |
1804399 | 1804399 | 2021-10-11 | Switzerland | Indiana | 18155 | 1328 | 11 |
1788987 | 1788987 | 2021-10-06 | Beaverhead | Montana | 30001 | 1328 | 15 |
1785739 | 1785739 | 2021-10-05 | Beaverhead | Montana | 30001 | 1328 | 15 |
1785943 | 1785943 | 2021-10-05 | Colfax | New Mexico | 35007 | 1328 | 47 |
1781922 | 1781922 | 2021-10-04 | Hancock | Kentucky | 21091 | 1328 | 16 |
1768631 | 1768631 | 2021-09-30 | Martin | Indiana | 18101 | 1328 | 19 |
1768794 | 1768794 | 2021-09-30 | Doniphan | Kansas | 20043 | 1328 | 27 |
1764943 | 1764943 | 2021-09-29 | Unknown | Connecticut | 1328 | 10 | |
1765545 | 1765545 | 2021-09-29 | Doniphan | Kansas | 20043 | 1328 | 27 |
1753147 | 1753147 | 2021-09-25 | Carroll | Missouri | 29033 | 1328 | 26 |
1744549 | 1744549 | 2021-09-22 | Clay | Texas | 48077 | 1328 | 21 |
1737422 | 1737422 | 2021-09-20 | Mercer | North Dakota | 38057 | 1328 | 11 |
1733774 | 1733774 | 2021-09-19 | Jefferson | Montana | 30043 | 1328 | 9 |
1730524 | 1730524 | 2021-09-18 | Jefferson | Montana | 30043 | 1328 | 9 |
1727274 | 1727274 | 2021-09-17 | Jefferson | Montana | 30043 | 1328 | 9 |
1718434 | 1718434 | 2021-09-14 | Clay | Tennessee | 47027 | 1328 | 33 |
1714272 | 1714272 | 2021-09-13 | Fergus | Montana | 30027 | 1328 | 31 |
1708056 | 1708056 | 2021-09-11 | Yates | New York | 36123 | 1328 | 26 |
1696953 | 1696953 | 2021-09-08 | Wilkes | Georgia | 13317 | 1328 | 32 |
1694768 | 1694768 | 2021-09-07 | Wayne | Missouri | 29223 | 1328 | 17 |
1695679 | 1695679 | 2021-09-07 | Todd | South Dakota | 46121 | 1328 | 33 |
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);