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 2021-06-04 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1384842 | 1384842 | 2021-06-04 | Polk | Arkansas | 5113 | 2012 | 74 |
1385050 | 1385050 | 2021-06-04 | Polk | Florida | 12105 | 70882 | 1387 |
1385180 | 1385180 | 2021-06-04 | Polk | Georgia | 13233 | 5735 | 97 |
1385547 | 1385547 | 2021-06-04 | Polk | Iowa | 19153 | 58071 | 636 |
1386060 | 1386060 | 2021-06-04 | Polk | Minnesota | 27119 | 3881 | 71 |
1386256 | 1386256 | 2021-06-04 | Polk | Missouri | 29167 | 3517 | 40 |
1386415 | 1386415 | 2021-06-04 | Polk | Nebraska | 31143 | 585 | 18 |
1386652 | 1386652 | 2021-06-04 | Polk | North Carolina | 37149 | 1496 | 30 |
1386927 | 1386927 | 2021-06-04 | Polk | Oregon | 41053 | 3898 | 55 |
1387270 | 1387270 | 2021-06-04 | Polk | Tennessee | 47139 | 2108 | 25 |
1387483 | 1387483 | 2021-06-04 | Polk | Texas | 48373 | 3388 | 120 |
1387874 | 1387874 | 2021-06-04 | Polk | Wisconsin | 55095 | 4812 | 61 |
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);