ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13 rows where cases = 20778 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- Indiana 5
- Florida 1
- Idaho 1
- Michigan 1
- New York 1
- North Carolina 1
- Ohio 1
- Pennsylvania 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484020 | 2484020 | 2022-05-08 | Hancock | Indiana | 18059 | 20778 | 258 |
2480762 | 2480762 | 2022-05-07 | Hancock | Indiana | 18059 | 20778 | 258 |
2477504 | 2477504 | 2022-05-06 | Hancock | Indiana | 18059 | 20778 | 258 |
2474246 | 2474246 | 2022-05-05 | Hancock | Indiana | 18059 | 20778 | 258 |
2470989 | 2470989 | 2022-05-04 | Hancock | Indiana | 18059 | 20778 | 258 |
2350376 | 2350376 | 2022-03-28 | Bannock | Idaho | 16005 | 20778 | 247 |
2228088 | 2228088 | 2022-02-18 | Chemung | New York | 36015 | 20778 | 224 |
2107955 | 2107955 | 2022-01-12 | Columbiana | Ohio | 39029 | 20778 | 395 |
2014795 | 2014795 | 2021-12-14 | La Crosse | Wisconsin | 55063 | 20778 | 134 |
1789353 | 1789353 | 2021-10-06 | Randolph | North Carolina | 37151 | 20778 | 294 |
1552512 | 1552512 | 2021-07-25 | Cumberland | Pennsylvania | 42041 | 20778 | 528 |
1155462 | 1155462 | 2021-03-25 | Washtenaw | Michigan | 26161 | 20778 | 257 |
878574 | 878574 | 2020-12-30 | Brevard | Florida | 12009 | 20778 | 515 |
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);