ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where cases = 17382 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- Washington 3
- Colorado 2
- Tennessee 2
- Louisiana 1
- Maryland 1
- Mississippi 1
- New Jersey 1
- North Carolina 1
- Ohio 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2326875 | 2326875 | 2022-03-20 | Lewis | Washington | 53041 | 17382 | 242 |
2323622 | 2323622 | 2022-03-19 | Lewis | Washington | 53041 | 17382 | 242 |
2320368 | 2320368 | 2022-03-18 | Lewis | Washington | 53041 | 17382 | 242 |
2254370 | 2254370 | 2022-02-26 | Pickaway | Ohio | 39129 | 17382 | 215 |
2174060 | 2174060 | 2022-02-01 | Harrison | West Virginia | 54033 | 17382 | 215 |
2136374 | 2136374 | 2022-01-21 | Wicomico | Maryland | 24045 | 17382 | 273 |
1863914 | 1863914 | 2021-10-29 | Sussex | New Jersey | 34037 | 17382 | 334 |
1812700 | 1812700 | 2021-10-13 | Madison | Tennessee | 47113 | 17382 | 297 |
1542468 | 1542468 | 2021-07-22 | Robeson | North Carolina | 37155 | 17382 | 277 |
1497638 | 1497638 | 2021-07-08 | Sullivan | Tennessee | 47163 | 17382 | 311 |
1258357 | 1258357 | 2021-04-26 | Pueblo | Colorado | 8101 | 17382 | 369 |
1255110 | 1255110 | 2021-04-25 | Pueblo | Colorado | 8101 | 17382 | 369 |
1178309 | 1178309 | 2021-04-01 | Harrison | Mississippi | 28047 | 17382 | 299 |
1009225 | 1009225 | 2021-02-08 | Ouachita | Louisiana | 22073 | 17382 | 390 |
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);