ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
817 rows where county = "Douglas" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5661 | 5661 | 2020-03-20 | Douglas | Nebraska | 31055 | 40 | 0 |
4821 | 4821 | 2020-03-19 | Douglas | Nebraska | 31055 | 37 | 0 |
4098 | 4098 | 2020-03-18 | Douglas | Nebraska | 31055 | 37 | 0 |
3506 | 3506 | 2020-03-17 | Douglas | Nebraska | 31055 | 33 | 0 |
2996 | 2996 | 2020-03-16 | Douglas | Nebraska | 31055 | 32 | 0 |
2541 | 2541 | 2020-03-15 | Douglas | Nebraska | 31055 | 30 | 0 |
2134 | 2134 | 2020-03-14 | Douglas | Nebraska | 31055 | 28 | 0 |
1788 | 1788 | 2020-03-13 | Douglas | Nebraska | 31055 | 26 | 0 |
1496 | 1496 | 2020-03-12 | Douglas | Nebraska | 31055 | 23 | 0 |
1268 | 1268 | 2020-03-11 | Douglas | Nebraska | 31055 | 23 | 0 |
1086 | 1086 | 2020-03-10 | Douglas | Nebraska | 31055 | 17 | 0 |
936 | 936 | 2020-03-09 | Douglas | Nebraska | 31055 | 16 | 0 |
812 | 812 | 2020-03-08 | Douglas | Nebraska | 31055 | 16 | 0 |
708 | 708 | 2020-03-07 | Douglas | Nebraska | 31055 | 14 | 0 |
621 | 621 | 2020-03-06 | Douglas | Nebraska | 31055 | 14 | 0 |
560 | 560 | 2020-03-05 | Douglas | Nebraska | 31055 | 13 | 0 |
516 | 516 | 2020-03-04 | Douglas | Nebraska | 31055 | 13 | 0 |
481 | 481 | 2020-03-03 | Douglas | Nebraska | 31055 | 13 | 0 |
447 | 447 | 2020-03-02 | Douglas | Nebraska | 31055 | 13 | 0 |
416 | 416 | 2020-03-01 | Douglas | Nebraska | 31055 | 13 | 0 |
391 | 391 | 2020-02-29 | Douglas | Nebraska | 31055 | 13 | 0 |
369 | 369 | 2020-02-28 | Douglas | Nebraska | 31055 | 13 | 0 |
349 | 349 | 2020-02-27 | Douglas | Nebraska | 31055 | 13 | 0 |
329 | 329 | 2020-02-26 | Douglas | Nebraska | 31055 | 13 | 0 |
309 | 309 | 2020-02-25 | Douglas | Nebraska | 31055 | 13 | 0 |
293 | 293 | 2020-02-24 | Douglas | Nebraska | 31055 | 12 | 0 |
278 | 278 | 2020-02-23 | Douglas | Nebraska | 31055 | 11 | 0 |
264 | 264 | 2020-02-22 | Douglas | Nebraska | 31055 | 11 | 0 |
250 | 250 | 2020-02-21 | Douglas | Nebraska | 31055 | 11 | 0 |
236 | 236 | 2020-02-20 | Douglas | Nebraska | 31055 | 11 | 0 |
223 | 223 | 2020-02-19 | Douglas | Nebraska | 31055 | 10 | 0 |
211 | 211 | 2020-02-18 | Douglas | Nebraska | 31055 | 10 | 0 |
199 | 199 | 2020-02-17 | Douglas | Nebraska | 31055 | 10 | 0 |
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);