ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where "date" is on date 2020-04-02 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
27350 | 27350 | 2020-04-02 | Adams | Nebraska | 31001 | 6 | 0 |
27351 | 27351 | 2020-04-02 | Antelope | Nebraska | 31003 | 1 | 0 |
27352 | 27352 | 2020-04-02 | Buffalo | Nebraska | 31019 | 8 | 1 |
27353 | 27353 | 2020-04-02 | Cass | Nebraska | 31025 | 2 | 0 |
27354 | 27354 | 2020-04-02 | Colfax | Nebraska | 31037 | 1 | 0 |
27355 | 27355 | 2020-04-02 | Cuming | Nebraska | 31039 | 1 | 0 |
27356 | 27356 | 2020-04-02 | Dawson | Nebraska | 31047 | 1 | 0 |
27357 | 27357 | 2020-04-02 | Dodge | Nebraska | 31053 | 4 | 0 |
27358 | 27358 | 2020-04-02 | Douglas | Nebraska | 31055 | 130 | 1 |
27359 | 27359 | 2020-04-02 | Gage | Nebraska | 31067 | 1 | 1 |
27360 | 27360 | 2020-04-02 | Gosper | Nebraska | 31073 | 1 | 0 |
27361 | 27361 | 2020-04-02 | Hall | Nebraska | 31079 | 19 | 1 |
27362 | 27362 | 2020-04-02 | Hamilton | Nebraska | 31081 | 2 | 0 |
27363 | 27363 | 2020-04-02 | Kearney | Nebraska | 31099 | 2 | 0 |
27364 | 27364 | 2020-04-02 | Kimball | Nebraska | 31105 | 3 | 0 |
27365 | 27365 | 2020-04-02 | Knox | Nebraska | 31107 | 2 | 0 |
27366 | 27366 | 2020-04-02 | Lancaster | Nebraska | 31109 | 12 | 0 |
27367 | 27367 | 2020-04-02 | Lincoln | Nebraska | 31111 | 13 | 1 |
27368 | 27368 | 2020-04-02 | Madison | Nebraska | 31119 | 5 | 1 |
27369 | 27369 | 2020-04-02 | Nemaha | Nebraska | 31127 | 1 | 0 |
27370 | 27370 | 2020-04-02 | Otoe | Nebraska | 31131 | 1 | 0 |
27371 | 27371 | 2020-04-02 | Platte | Nebraska | 31141 | 3 | 0 |
27372 | 27372 | 2020-04-02 | Sarpy | Nebraska | 31153 | 23 | 0 |
27373 | 27373 | 2020-04-02 | Saunders | Nebraska | 31155 | 3 | 0 |
27374 | 27374 | 2020-04-02 | Scotts Bluff | Nebraska | 31157 | 3 | 0 |
27375 | 27375 | 2020-04-02 | Unknown | Nebraska | 5 | 0 | |
27376 | 27376 | 2020-04-02 | Washington | Nebraska | 31177 | 19 | 0 |
27377 | 27377 | 2020-04-02 | York | Nebraska | 31185 | 1 | 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);