ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 7445 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Oklahoma 8
- New Hampshire 5
- Virginia 5
- Minnesota 4
- Wisconsin 4
- Connecticut 3
- North Carolina 3
- Indiana 2
- Pennsylvania 2
- Arizona 1
- Arkansas 1
- Colorado 1
- Georgia 1
- Idaho 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Mississippi 1
- Missouri 1
- Ohio 1
- Puerto Rico 1
- South Carolina 1
- Tennessee 1
- Texas 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2409585 | 2409585 | 2022-04-15 | Hancock | Maine | 23009 | 7445 | 84 |
2189940 | 2189940 | 2022-02-06 | Hockley | Texas | 48219 | 7445 | 154 |
2062750 | 2062750 | 2021-12-29 | Ponce | Puerto Rico | 72113 | 7445 | |
2059046 | 2059046 | 2021-12-28 | Davie | North Carolina | 37059 | 7445 | 82 |
2052013 | 2052013 | 2021-12-26 | Steele | Minnesota | 27147 | 7445 | 40 |
2048763 | 2048763 | 2021-12-25 | Steele | Minnesota | 27147 | 7445 | 40 |
2045513 | 2045513 | 2021-12-24 | Steele | Minnesota | 27147 | 7445 | 40 |
2042263 | 2042263 | 2021-12-23 | Steele | Minnesota | 27147 | 7445 | 40 |
1961382 | 1961382 | 2021-11-28 | Belknap | New Hampshire | 33001 | 7445 | 133 |
1962569 | 1962569 | 2021-11-28 | Fauquier | Virginia | 51061 | 7445 | 88 |
1958131 | 1958131 | 2021-11-27 | Belknap | New Hampshire | 33001 | 7445 | 133 |
1959318 | 1959318 | 2021-11-27 | Fauquier | Virginia | 51061 | 7445 | 88 |
1954880 | 1954880 | 2021-11-26 | Belknap | New Hampshire | 33001 | 7445 | 133 |
1956067 | 1956067 | 2021-11-26 | Fauquier | Virginia | 51061 | 7445 | 88 |
1951629 | 1951629 | 2021-11-25 | Belknap | New Hampshire | 33001 | 7445 | 133 |
1948378 | 1948378 | 2021-11-24 | Belknap | New Hampshire | 33001 | 7445 | 133 |
1922765 | 1922765 | 2021-11-16 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1919516 | 1919516 | 2021-11-15 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1916266 | 1916266 | 2021-11-14 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1913016 | 1913016 | 2021-11-13 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1909766 | 1909766 | 2021-11-12 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1906517 | 1906517 | 2021-11-11 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1903268 | 1903268 | 2021-11-10 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1901043 | 1901043 | 2021-11-09 | Oconto | Wisconsin | 55083 | 7445 | 77 |
1896175 | 1896175 | 2021-11-08 | Pettis | Missouri | 29159 | 7445 | 104 |
1893655 | 1893655 | 2021-11-07 | Mifflin | Pennsylvania | 42087 | 7445 | 204 |
1838560 | 1838560 | 2021-10-21 | Newberry | South Carolina | 45071 | 7445 | 144 |
1835911 | 1835911 | 2021-10-20 | Washington | Virginia | 51191 | 7445 | 143 |
1740558 | 1740558 | 2021-09-21 | Carteret | North Carolina | 37031 | 7445 | 58 |
1693421 | 1693421 | 2021-09-07 | Eagle | Colorado | 8037 | 7445 | 29 |
1613048 | 1613048 | 2021-08-13 | Pulaski | Kentucky | 21199 | 7445 | 132 |
1560558 | 1560558 | 2021-07-28 | Madison | Idaho | 16065 | 7445 | 28 |
1535443 | 1535443 | 2021-07-20 | Lauderdale | Mississippi | 28075 | 7445 | 243 |
1485243 | 1485243 | 2021-07-04 | Portage | Wisconsin | 55097 | 7445 | 74 |
1481997 | 1481997 | 2021-07-03 | Portage | Wisconsin | 55097 | 7445 | 74 |
1478750 | 1478750 | 2021-07-02 | Portage | Wisconsin | 55097 | 7445 | 74 |
1467796 | 1467796 | 2021-06-29 | Rutherford | North Carolina | 37161 | 7445 | 216 |
1361319 | 1361319 | 2021-05-27 | Tipton | Tennessee | 47167 | 7445 | 104 |
1297751 | 1297751 | 2021-05-08 | Grant | Indiana | 18053 | 7445 | 181 |
1268333 | 1268333 | 2021-04-29 | Troup | Georgia | 13285 | 7445 | 224 |
1198637 | 1198637 | 2021-04-07 | Clearfield | Pennsylvania | 42033 | 7445 | 130 |
1067193 | 1067193 | 2021-02-26 | Bartholomew | Indiana | 18005 | 7445 | 153 |
1045937 | 1045937 | 2021-02-19 | Garfield | Oklahoma | 40047 | 7445 | 69 |
1027853 | 1027853 | 2021-02-14 | Tolland | Connecticut | 9013 | 7445 | 151 |
1024608 | 1024608 | 2021-02-13 | Tolland | Connecticut | 9013 | 7445 | 151 |
1021363 | 1021363 | 2021-02-12 | Tolland | Connecticut | 9013 | 7445 | 151 |
818671 | 818671 | 2020-12-11 | Greene | Ohio | 39057 | 7445 | 87 |
813158 | 813158 | 2020-12-09 | Franklin | Washington | 53021 | 7445 | 77 |
702714 | 702714 | 2020-11-05 | Chesterfield | Virginia | 51041 | 7445 | 120 |
631752 | 631752 | 2020-10-15 | Benton | Arkansas | 5007 | 7445 | 102 |
490268 | 490268 | 2020-09-01 | Calcasieu | Louisiana | 22019 | 7445 | 190 |
306135 | 306135 | 2020-07-06 | Yuma | Arizona | 4027 | 7445 | 117 |
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);