ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
12 rows where county = "Polk" and "date" is on date 2020-09-10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
518408 | 518408 | 2020-09-10 | Polk | Arkansas | 5113 | 241 | 4 |
518615 | 518615 | 2020-09-10 | Polk | Florida | 12105 | 18121 | 483 |
518745 | 518745 | 2020-09-10 | Polk | Georgia | 13233 | 1302 | 17 |
519111 | 519111 | 2020-09-10 | Polk | Iowa | 19153 | 14343 | 248 |
519625 | 519625 | 2020-09-10 | Polk | Minnesota | 27119 | 227 | 4 |
519821 | 519821 | 2020-09-10 | Polk | Missouri | 29167 | 447 | 1 |
519975 | 519975 | 2020-09-10 | Polk | Nebraska | 31143 | 38 | 1 |
520213 | 520213 | 2020-09-10 | Polk | North Carolina | 37149 | 248 | 7 |
520488 | 520488 | 2020-09-10 | Polk | Oregon | 41053 | 464 | 15 |
520830 | 520830 | 2020-09-10 | Polk | Tennessee | 47139 | 359 | 11 |
521040 | 521040 | 2020-09-10 | Polk | Texas | 48373 | 909 | 20 |
521432 | 521432 | 2020-09-10 | Polk | Wisconsin | 55095 | 194 | 2 |
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);