ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where cases = 7752 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Tennessee 11
- North Carolina 9
- Iowa 7
- Ohio 5
- Texas 5
- California 4
- Michigan 3
- Oklahoma 2
- Virginia 2
- Arkansas 1
- Florida 1
- Georgia 1
- Idaho 1
- Indiana 1
- Massachusetts 1
- Missouri 1
- New Jersey 1
- New York 1
- Pennsylvania 1
- Puerto Rico 1
- South Dakota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492385 | 2492385 | 2022-05-10 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2489127 | 2489127 | 2022-05-09 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2485870 | 2485870 | 2022-05-08 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2482612 | 2482612 | 2022-05-07 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2479354 | 2479354 | 2022-05-06 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2476096 | 2476096 | 2022-05-05 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2472839 | 2472839 | 2022-05-04 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2371299 | 2371299 | 2022-04-03 | Macon | North Carolina | 37113 | 7752 | 113 |
2368046 | 2368046 | 2022-04-02 | Macon | North Carolina | 37113 | 7752 | 113 |
2364793 | 2364793 | 2022-04-01 | Macon | North Carolina | 37113 | 7752 | 113 |
2362434 | 2362434 | 2022-03-31 | Upshur | Texas | 48459 | 7752 | 181 |
2270586 | 2270586 | 2022-03-03 | Fayette | Ohio | 39047 | 7752 | 111 |
2186030 | 2186030 | 2022-02-05 | Coshocton | Ohio | 39031 | 7752 | 139 |
2186614 | 2186614 | 2022-02-05 | Cherokee | Texas | 48073 | 7752 | 236 |
2173581 | 2173581 | 2022-02-01 | Bee | Texas | 48025 | 7752 | 142 |
2157139 | 2157139 | 2022-01-27 | Brookings | South Dakota | 46011 | 7752 | 41 |
2130767 | 2130767 | 2022-01-19 | Ottawa | Ohio | 39123 | 7752 | 121 |
2108666 | 2108666 | 2022-01-12 | Medina | Texas | 48325 | 7752 | 174 |
2098532 | 2098532 | 2022-01-09 | Vega Baja | Puerto Rico | 72145 | 7752 | |
2030407 | 2030407 | 2021-12-19 | Cocke | Tennessee | 47029 | 7752 | 125 |
2027156 | 2027156 | 2021-12-18 | Cocke | Tennessee | 47029 | 7752 | 125 |
2023905 | 2023905 | 2021-12-17 | Cocke | Tennessee | 47029 | 7752 | 125 |
2020646 | 2020646 | 2021-12-16 | Campbell | Tennessee | 47013 | 7752 | 95 |
1966922 | 1966922 | 2021-11-30 | Clinton | Iowa | 19045 | 7752 | 114 |
1963670 | 1963670 | 2021-11-29 | Clinton | Iowa | 19045 | 7752 | 114 |
1960419 | 1960419 | 2021-11-28 | Clinton | Iowa | 19045 | 7752 | 114 |
1957168 | 1957168 | 2021-11-27 | Clinton | Iowa | 19045 | 7752 | 114 |
1953917 | 1953917 | 2021-11-26 | Clinton | Iowa | 19045 | 7752 | 114 |
1955163 | 1955163 | 2021-11-26 | Ashland | Ohio | 39005 | 7752 | 147 |
1950666 | 1950666 | 2021-11-25 | Clinton | Iowa | 19045 | 7752 | 114 |
1947415 | 1947415 | 2021-11-24 | Clinton | Iowa | 19045 | 7752 | 114 |
1942043 | 1942043 | 2021-11-22 | Haywood | North Carolina | 37087 | 7752 | 152 |
1937086 | 1937086 | 2021-11-21 | Tuolumne | California | 6109 | 7752 | 138 |
1933836 | 1933836 | 2021-11-20 | Tuolumne | California | 6109 | 7752 | 138 |
1930584 | 1930584 | 2021-11-19 | Tuolumne | California | 6109 | 7752 | 138 |
1857177 | 1857177 | 2021-10-27 | Newton | Missouri | 29145 | 7752 | 125 |
1841208 | 1841208 | 2021-10-22 | Cattaraugus | New York | 36009 | 7752 | 115 |
1667756 | 1667756 | 2021-08-30 | Madison | Idaho | 16065 | 7752 | 28 |
1643121 | 1643121 | 2021-08-22 | Franklin | North Carolina | 37069 | 7752 | 55 |
1639871 | 1639871 | 2021-08-21 | Franklin | North Carolina | 37069 | 7752 | 55 |
1636621 | 1636621 | 2021-08-20 | Franklin | North Carolina | 37069 | 7752 | 55 |
1539539 | 1539539 | 2021-07-21 | Lawrence | Pennsylvania | 42073 | 7752 | 216 |
1484683 | 1484683 | 2021-07-04 | Bowie | Texas | 48037 | 7752 | 225 |
1362493 | 1362493 | 2021-05-28 | Walker | Georgia | 13295 | 7752 | 87 |
1289270 | 1289270 | 2021-05-05 | Stanly | North Carolina | 37167 | 7752 | 131 |
1170161 | 1170161 | 2021-03-29 | Roanoke | Virginia | 51161 | 7752 | 125 |
1147827 | 1147827 | 2021-03-23 | White | Arkansas | 5145 | 7752 | 115 |
1142395 | 1142395 | 2021-03-21 | Allegan | Michigan | 26005 | 7752 | 118 |
1142950 | 1142950 | 2021-03-21 | Hunterdon | New Jersey | 34019 | 7752 | 167 |
1139148 | 1139148 | 2021-03-20 | Allegan | Michigan | 26005 | 7752 | 118 |
1097922 | 1097922 | 2021-03-07 | Wagoner | Oklahoma | 40145 | 7752 | 83 |
1048926 | 1048926 | 2021-02-20 | Brunswick | North Carolina | 37019 | 7752 | 130 |
1045910 | 1045910 | 2021-02-19 | Wayne | Ohio | 39169 | 7752 | 209 |
1011047 | 1011047 | 2021-02-08 | Hampton city | Virginia | 51650 | 7752 | 76 |
977813 | 977813 | 2021-01-29 | Payne | Oklahoma | 40119 | 7752 | 42 |
888703 | 888703 | 2021-01-02 | Delaware | Indiana | 18035 | 7752 | 128 |
589722 | 589722 | 2020-10-02 | Sonoma | California | 6097 | 7752 | 122 |
541272 | 541272 | 2020-09-17 | Sarasota | Florida | 12115 | 7752 | 245 |
448371 | 448371 | 2020-08-19 | Hampden | Massachusetts | 25013 | 7752 | 729 |
134462 | 134462 | 2020-05-11 | Oakland | Michigan | 26125 | 7752 | 849 |
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);