ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13 rows where cases = 17882 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- North Carolina 2
- South Carolina 2
- Arizona 1
- Colorado 1
- Florida 1
- Georgia 1
- Missouri 1
- New Jersey 1
- Pennsylvania 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2032634 | 2032634 | 2021-12-20 | Clay | Missouri | 29047 | 17882 | 265 |
1990854 | 1990854 | 2021-12-07 | Wayne | North Carolina | 37191 | 17882 | 314 |
1864393 | 1864393 | 2021-10-29 | Fayette | Pennsylvania | 42051 | 17882 | 407 |
1822963 | 1822963 | 2021-10-16 | Berkeley | West Virginia | 54003 | 17882 | 173 |
1579953 | 1579953 | 2021-08-03 | Muscogee | Georgia | 13215 | 17882 | 507 |
1377373 | 1377373 | 2021-06-01 | Florence | South Carolina | 45041 | 17882 | 420 |
1374127 | 1374127 | 2021-05-31 | Florence | South Carolina | 45041 | 17882 | 420 |
1326338 | 1326338 | 2021-05-17 | Coconino | Arizona | 4005 | 17882 | 330 |
1300227 | 1300227 | 2021-05-08 | Rock | Wisconsin | 55105 | 17882 | 193 |
1198326 | 1198326 | 2021-04-07 | New Hanover | North Carolina | 37129 | 17882 | 161 |
943534 | 943534 | 2021-01-19 | St. Lucie | Florida | 12111 | 17882 | 459 |
925473 | 925473 | 2021-01-13 | Atlantic | New Jersey | 34001 | 17882 | 400 |
667597 | 667597 | 2020-10-26 | Denver | Colorado | 8031 | 17882 | 459 |
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);