ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 7186 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2402520 | 2402520 | 2022-04-13 | Iroquois | Illinois | 17075 | 7186 | 117 |
2402544 | 2402544 | 2022-04-13 | McDonough | Illinois | 17109 | 7186 | 103 |
2334033 | 2334033 | 2022-03-23 | Lumpkin | Georgia | 13187 | 7186 | 131 |
2316278 | 2316278 | 2022-03-17 | Jefferson | Oregon | 41031 | 7186 | 86 |
2311968 | 2311968 | 2022-03-16 | Hancock | Maine | 23009 | 7186 | 81 |
2301753 | 2301753 | 2022-03-13 | Greene | Indiana | 18055 | 7186 | 138 |
2298501 | 2298501 | 2022-03-12 | Greene | Indiana | 18055 | 7186 | 138 |
2295249 | 2295249 | 2022-03-11 | Greene | Indiana | 18055 | 7186 | 138 |
2297256 | 2297256 | 2022-03-11 | Hopkins | Texas | 48223 | 7186 | 177 |
2284185 | 2284185 | 2022-03-07 | Cooke | Texas | 48097 | 7186 | 130 |
2280933 | 2280933 | 2022-03-06 | Cooke | Texas | 48097 | 7186 | 130 |
2277680 | 2277680 | 2022-03-05 | Cooke | Texas | 48097 | 7186 | 130 |
2167363 | 2167363 | 2022-01-30 | St. Croix | Virgin Islands | 78010 | 7186 | 41 |
2164108 | 2164108 | 2022-01-29 | St. Croix | Virgin Islands | 78010 | 7186 | 41 |
2160853 | 2160853 | 2022-01-28 | St. Croix | Virgin Islands | 78010 | 7186 | 41 |
2113609 | 2113609 | 2022-01-14 | Worcester | Maryland | 24047 | 7186 | 136 |
2115248 | 2115248 | 2022-01-14 | Wharton | Texas | 48481 | 7186 | 194 |
2076269 | 2076269 | 2022-01-02 | Wasatch | Utah | 49051 | 7186 | 31 |
2073018 | 2073018 | 2022-01-01 | Wasatch | Utah | 49051 | 7186 | 31 |
2069767 | 2069767 | 2021-12-31 | Wasatch | Utah | 49051 | 7186 | 31 |
2066516 | 2066516 | 2021-12-30 | Wasatch | Utah | 49051 | 7186 | 31 |
2029760 | 2029760 | 2021-12-19 | Tioga | New York | 36107 | 7186 | 76 |
1997279 | 1997279 | 2021-12-09 | Chatham | North Carolina | 37037 | 7186 | 99 |
1985182 | 1985182 | 2021-12-05 | San Patricio | Texas | 48409 | 7186 | 298 |
1981932 | 1981932 | 2021-12-04 | San Patricio | Texas | 48409 | 7186 | 298 |
1961682 | 1961682 | 2021-11-28 | Defiance | Ohio | 39039 | 7186 | 114 |
1944722 | 1944722 | 2021-11-23 | Mower | Minnesota | 27099 | 7186 | 46 |
1938742 | 1938742 | 2021-11-21 | Tompkins | New York | 36109 | 7186 | 61 |
1930404 | 1930404 | 2021-11-19 | Tallapoosa | Alabama | 1123 | 7186 | 202 |
1901157 | 1901157 | 2021-11-10 | Tallapoosa | Alabama | 1123 | 7186 | 202 |
1848286 | 1848286 | 2021-10-24 | Chesterfield | South Carolina | 45025 | 7186 | 144 |
1845036 | 1845036 | 2021-10-23 | Chesterfield | South Carolina | 45025 | 7186 | 144 |
1841786 | 1841786 | 2021-10-22 | Chesterfield | South Carolina | 45025 | 7186 | 144 |
1811797 | 1811797 | 2021-10-13 | Buffalo | Nebraska | 31019 | 7186 | 62 |
1645036 | 1645036 | 2021-08-23 | Boone | Illinois | 17007 | 7186 | 93 |
1646323 | 1646323 | 2021-08-23 | St. Lawrence | New York | 36089 | 7186 | 97 |
1626109 | 1626109 | 2021-08-17 | St. Martin | Louisiana | 22099 | 7186 | 126 |
1423749 | 1423749 | 2021-06-16 | Crawford | Arkansas | 5033 | 7186 | 120 |
1391166 | 1391166 | 2021-06-06 | Autauga | Alabama | 1001 | 7186 | 112 |
1387921 | 1387921 | 2021-06-05 | Autauga | Alabama | 1001 | 7186 | 112 |
1384676 | 1384676 | 2021-06-04 | Autauga | Alabama | 1001 | 7186 | 112 |
1285915 | 1285915 | 2021-05-04 | Ontario | New York | 36069 | 7186 | 92 |
1235485 | 1235485 | 2021-04-19 | Lonoke | Arkansas | 5085 | 7186 | 118 |
1226318 | 1226318 | 2021-04-16 | Grant | Indiana | 18053 | 7186 | 177 |
1223071 | 1223071 | 2021-04-15 | Grant | Indiana | 18053 | 7186 | 176 |
1196893 | 1196893 | 2021-04-07 | Walker | Georgia | 13295 | 7186 | 85 |
1192732 | 1192732 | 2021-04-05 | Wise | Texas | 48497 | 7186 | 116 |
1189483 | 1189483 | 2021-04-04 | Wise | Texas | 48497 | 7186 | 116 |
1186236 | 1186236 | 2021-04-03 | Wise | Texas | 48497 | 7186 | 116 |
1062259 | 1062259 | 2021-02-24 | Adams | Pennsylvania | 42001 | 7186 | 148 |
1033341 | 1033341 | 2021-02-15 | Greene | Tennessee | 47059 | 7186 | 140 |
971260 | 971260 | 2021-01-27 | Wayne | Ohio | 39169 | 7186 | 172 |
868684 | 868684 | 2020-12-27 | Saline | Arkansas | 5125 | 7186 | 93 |
830728 | 830728 | 2020-12-15 | Rapides | Louisiana | 22079 | 7186 | 202 |
804775 | 804775 | 2020-12-07 | Tangipahoa | Louisiana | 22105 | 7186 | 147 |
742620 | 742620 | 2020-11-18 | Rock Island | Illinois | 17161 | 7186 | 120 |
744358 | 744358 | 2020-11-18 | Anderson | South Carolina | 45007 | 7186 | 215 |
585270 | 585270 | 2020-09-30 | Berks | Pennsylvania | 42011 | 7186 | 395 |
210824 | 210824 | 2020-06-05 | Clark | Nevada | 32003 | 7186 | 357 |
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);