ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 15987 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 |
---|---|---|---|---|---|---|---|
2502132 | 2502132 | 2022-05-13 | Dickson | Tennessee | 47043 | 15987 | 245 |
2498874 | 2498874 | 2022-05-12 | Dickson | Tennessee | 47043 | 15987 | 245 |
2495616 | 2495616 | 2022-05-11 | Dickson | Tennessee | 47043 | 15987 | 245 |
2269524 | 2269524 | 2022-03-03 | Christian | Kentucky | 21047 | 15987 | 196 |
2106390 | 2106390 | 2022-01-12 | Rockdale | Georgia | 13247 | 15987 | 268 |
1932687 | 1932687 | 2021-11-19 | Bayamon | Puerto Rico | 72021 | 15987 | |
1930332 | 1930332 | 2021-11-18 | Natrona | Wyoming | 56025 | 15987 | 202 |
1865488 | 1865488 | 2021-10-30 | Garland | Arkansas | 5051 | 15987 | 396 |
1710654 | 1710654 | 2021-09-12 | Calhoun | Michigan | 26025 | 15987 | 331 |
1707407 | 1707407 | 2021-09-11 | Calhoun | Michigan | 26025 | 15987 | 331 |
1704160 | 1704160 | 2021-09-10 | Calhoun | Michigan | 26025 | 15987 | 331 |
1634444 | 1634444 | 2021-08-19 | Newport News city | Virginia | 51700 | 15987 | 244 |
1319789 | 1319789 | 2021-05-15 | Lee | Alabama | 1081 | 15987 | 172 |
1237314 | 1237314 | 2021-04-19 | Robeson | North Carolina | 37155 | 15987 | 227 |
1206206 | 1206206 | 2021-04-10 | Navajo | Arizona | 4017 | 15987 | 522 |
1170582 | 1170582 | 2021-03-30 | Madera | California | 6039 | 15987 | 234 |
1173595 | 1173595 | 2021-03-30 | Washington | Wisconsin | 55131 | 15987 | 149 |
1133259 | 1133259 | 2021-03-18 | Broome | New York | 36007 | 15987 | 341 |
962995 | 962995 | 2021-01-25 | Okaloosa | Florida | 12091 | 15987 | 277 |
719494 | 719494 | 2020-11-11 | El Paso | Colorado | 8041 | 15987 | 216 |
401735 | 401735 | 2020-08-04 | Fairfax | Virginia | 51059 | 15987 | 528 |
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);