ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 11617 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 |
---|---|---|---|---|---|---|---|
2492351 | 2492351 | 2022-05-10 | Cocke | Tennessee | 47029 | 11617 | 217 |
2489093 | 2489093 | 2022-05-09 | Cocke | Tennessee | 47029 | 11617 | 217 |
2485836 | 2485836 | 2022-05-08 | Cocke | Tennessee | 47029 | 11617 | 217 |
2482578 | 2482578 | 2022-05-07 | Cocke | Tennessee | 47029 | 11617 | 217 |
2479320 | 2479320 | 2022-05-06 | Cocke | Tennessee | 47029 | 11617 | 217 |
2476062 | 2476062 | 2022-05-05 | Cocke | Tennessee | 47029 | 11617 | 217 |
2472805 | 2472805 | 2022-05-04 | Cocke | Tennessee | 47029 | 11617 | 217 |
2374461 | 2374461 | 2022-04-04 | Livingston | New York | 36051 | 11617 | 115 |
2308254 | 2308254 | 2022-03-15 | Gibson | Indiana | 18051 | 11617 | 143 |
2310739 | 2310739 | 2022-03-15 | Shawano | Wisconsin | 55115 | 11617 | 144 |
2305003 | 2305003 | 2022-03-14 | Gibson | Indiana | 18051 | 11617 | 143 |
2291978 | 2291978 | 2022-03-10 | Cass | Indiana | 18017 | 11617 | 161 |
2165472 | 2165472 | 2022-01-30 | Franklin | Kentucky | 21073 | 11617 | 122 |
2162217 | 2162217 | 2022-01-29 | Franklin | Kentucky | 21073 | 11617 | 122 |
2158962 | 2158962 | 2022-01-28 | Franklin | Kentucky | 21073 | 11617 | 122 |
2074122 | 2074122 | 2022-01-02 | Morgan | Indiana | 18109 | 11617 | 219 |
2070871 | 2070871 | 2022-01-01 | Morgan | Indiana | 18109 | 11617 | 219 |
2067620 | 2067620 | 2021-12-31 | Morgan | Indiana | 18109 | 11617 | 219 |
2064369 | 2064369 | 2021-12-30 | Morgan | Indiana | 18109 | 11617 | 219 |
1740713 | 1740713 | 2021-09-21 | Columbiana | Ohio | 39029 | 11617 | 241 |
1654869 | 1654869 | 2021-08-26 | Vermilion | Illinois | 17183 | 11617 | 179 |
1643141 | 1643141 | 2021-08-22 | Lincoln | North Carolina | 37109 | 11617 | 86 |
1639891 | 1639891 | 2021-08-21 | Lincoln | North Carolina | 37109 | 11617 | 86 |
1636641 | 1636641 | 2021-08-20 | Lincoln | North Carolina | 37109 | 11617 | 86 |
1618503 | 1618503 | 2021-08-15 | St. Clair | Alabama | 1115 | 11617 | 253 |
1619689 | 1619689 | 2021-08-15 | Allegan | Michigan | 26005 | 11617 | 163 |
1616441 | 1616441 | 2021-08-14 | Allegan | Michigan | 26005 | 11617 | 163 |
1613193 | 1613193 | 2021-08-13 | Allegan | Michigan | 26005 | 11617 | 163 |
1534087 | 1534087 | 2021-07-20 | Apache | Arizona | 4001 | 11617 | 437 |
1516506 | 1516506 | 2021-07-14 | Wayne | North Carolina | 37191 | 11617 | 243 |
1472716 | 1472716 | 2021-07-01 | Carroll | Georgia | 13045 | 11617 | 246 |
1464696 | 1464696 | 2021-06-28 | Richland | Ohio | 39139 | 11617 | 211 |
1194232 | 1194232 | 2021-04-06 | Ascension | Louisiana | 22005 | 11617 | 160 |
720763 | 720763 | 2020-11-11 | Greene | Missouri | 29077 | 11617 | 173 |
717520 | 717520 | 2020-11-10 | Greene | Missouri | 29077 | 11617 | 173 |
634077 | 634077 | 2020-10-15 | Horry | South Carolina | 45051 | 11617 | 207 |
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);