ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where deaths = 1, fips = 31037 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
158820 | 158820 | 2020-05-19 | Colfax | Nebraska | 31037 | 532 | 1 |
155802 | 155802 | 2020-05-18 | Colfax | Nebraska | 31037 | 528 | 1 |
152788 | 152788 | 2020-05-17 | Colfax | Nebraska | 31037 | 516 | 1 |
149777 | 149777 | 2020-05-16 | Colfax | Nebraska | 31037 | 508 | 1 |
146771 | 146771 | 2020-05-15 | Colfax | Nebraska | 31037 | 481 | 1 |
143770 | 143770 | 2020-05-14 | Colfax | Nebraska | 31037 | 467 | 1 |
140775 | 140775 | 2020-05-13 | Colfax | Nebraska | 31037 | 446 | 1 |
137781 | 137781 | 2020-05-12 | Colfax | Nebraska | 31037 | 431 | 1 |
134791 | 134791 | 2020-05-11 | Colfax | Nebraska | 31037 | 419 | 1 |
131800 | 131800 | 2020-05-10 | Colfax | Nebraska | 31037 | 411 | 1 |
128810 | 128810 | 2020-05-09 | Colfax | Nebraska | 31037 | 413 | 1 |
125822 | 125822 | 2020-05-08 | Colfax | Nebraska | 31037 | 391 | 1 |
122840 | 122840 | 2020-05-07 | Colfax | Nebraska | 31037 | 338 | 1 |
119866 | 119866 | 2020-05-06 | Colfax | Nebraska | 31037 | 292 | 1 |
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);