ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where "date" is on date 2020-04-07 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
39466 | 39466 | 2020-04-07 | Adams | Nebraska | 31001 | 19 | 0 |
39467 | 39467 | 2020-04-07 | Antelope | Nebraska | 31003 | 1 | 0 |
39468 | 39468 | 2020-04-07 | Buffalo | Nebraska | 31019 | 23 | 1 |
39469 | 39469 | 2020-04-07 | Cass | Nebraska | 31025 | 2 | 0 |
39470 | 39470 | 2020-04-07 | Cherry | Nebraska | 31031 | 1 | 0 |
39471 | 39471 | 2020-04-07 | Cheyenne | Nebraska | 31033 | 1 | 0 |
39472 | 39472 | 2020-04-07 | Colfax | Nebraska | 31037 | 3 | 0 |
39473 | 39473 | 2020-04-07 | Cuming | Nebraska | 31039 | 2 | 0 |
39474 | 39474 | 2020-04-07 | Custer | Nebraska | 31041 | 2 | 1 |
39475 | 39475 | 2020-04-07 | Dawson | Nebraska | 31047 | 1 | 0 |
39476 | 39476 | 2020-04-07 | Dodge | Nebraska | 31053 | 7 | 0 |
39477 | 39477 | 2020-04-07 | Douglas | Nebraska | 31055 | 189 | 5 |
39478 | 39478 | 2020-04-07 | Gage | Nebraska | 31067 | 23 | 1 |
39479 | 39479 | 2020-04-07 | Gosper | Nebraska | 31073 | 1 | 0 |
39480 | 39480 | 2020-04-07 | Hall | Nebraska | 31079 | 60 | 2 |
39481 | 39481 | 2020-04-07 | Hamilton | Nebraska | 31081 | 7 | 0 |
39482 | 39482 | 2020-04-07 | Johnson | Nebraska | 31097 | 1 | 0 |
39483 | 39483 | 2020-04-07 | Kearney | Nebraska | 31099 | 2 | 0 |
39484 | 39484 | 2020-04-07 | Kimball | Nebraska | 31105 | 9 | 0 |
39485 | 39485 | 2020-04-07 | Knox | Nebraska | 31107 | 2 | 0 |
39486 | 39486 | 2020-04-07 | Lancaster | Nebraska | 31109 | 34 | 0 |
39487 | 39487 | 2020-04-07 | Lincoln | Nebraska | 31111 | 16 | 1 |
39488 | 39488 | 2020-04-07 | Madison | Nebraska | 31119 | 5 | 1 |
39489 | 39489 | 2020-04-07 | Merrick | Nebraska | 31121 | 2 | 0 |
39490 | 39490 | 2020-04-07 | Nemaha | Nebraska | 31127 | 1 | 0 |
39491 | 39491 | 2020-04-07 | Otoe | Nebraska | 31131 | 1 | 0 |
39492 | 39492 | 2020-04-07 | Phelps | Nebraska | 31137 | 1 | 0 |
39493 | 39493 | 2020-04-07 | Platte | Nebraska | 31141 | 5 | 0 |
39494 | 39494 | 2020-04-07 | Sarpy | Nebraska | 31153 | 36 | 0 |
39495 | 39495 | 2020-04-07 | Saunders | Nebraska | 31155 | 4 | 0 |
39496 | 39496 | 2020-04-07 | Scotts Bluff | Nebraska | 31157 | 6 | 0 |
39497 | 39497 | 2020-04-07 | Seward | Nebraska | 31159 | 1 | 0 |
39498 | 39498 | 2020-04-07 | Stanton | Nebraska | 31167 | 1 | 0 |
39499 | 39499 | 2020-04-07 | Washington | Nebraska | 31177 | 20 | 0 |
39500 | 39500 | 2020-04-07 | York | Nebraska | 31185 | 2 | 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);