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-06 and state = "Nebraska" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 35
county 35
- Adams 1
- Antelope 1
- Buffalo 1
- Cass 1
- Cherry 1
- Cheyenne 1
- Colfax 1
- Cuming 1
- Custer 1
- Dawson 1
- Dodge 1
- Douglas 1
- Gage 1
- Gosper 1
- Hall 1
- Hamilton 1
- Johnson 1
- Kearney 1
- Kimball 1
- Knox 1
- Lancaster 1
- Lincoln 1
- Madison 1
- Merrick 1
- Nemaha 1
- Otoe 1
- Phelps 1
- Platte 1
- Sarpy 1
- Saunders 1
- Scotts Bluff 1
- Seward 1
- Stanton 1
- Washington 1
- York 1
state 1
- Nebraska · 35 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
36951 | 36951 | 2020-04-06 | Antelope | Nebraska | 31003 | 1 | 0 |
36954 | 36954 | 2020-04-06 | Cherry | Nebraska | 31031 | 1 | 0 |
36955 | 36955 | 2020-04-06 | Cheyenne | Nebraska | 31033 | 1 | 0 |
36958 | 36958 | 2020-04-06 | Custer | Nebraska | 31041 | 1 | 1 |
36959 | 36959 | 2020-04-06 | Dawson | Nebraska | 31047 | 1 | 0 |
36963 | 36963 | 2020-04-06 | Gosper | Nebraska | 31073 | 1 | 0 |
36966 | 36966 | 2020-04-06 | Johnson | Nebraska | 31097 | 1 | 0 |
36974 | 36974 | 2020-04-06 | Nemaha | Nebraska | 31127 | 1 | 0 |
36975 | 36975 | 2020-04-06 | Otoe | Nebraska | 31131 | 1 | 0 |
36976 | 36976 | 2020-04-06 | Phelps | Nebraska | 31137 | 1 | 0 |
36981 | 36981 | 2020-04-06 | Seward | Nebraska | 31159 | 1 | 0 |
36982 | 36982 | 2020-04-06 | Stanton | Nebraska | 31167 | 1 | 0 |
36984 | 36984 | 2020-04-06 | York | Nebraska | 31185 | 1 | 0 |
36953 | 36953 | 2020-04-06 | Cass | Nebraska | 31025 | 2 | 0 |
36957 | 36957 | 2020-04-06 | Cuming | Nebraska | 31039 | 2 | 0 |
36967 | 36967 | 2020-04-06 | Kearney | Nebraska | 31099 | 2 | 0 |
36969 | 36969 | 2020-04-06 | Knox | Nebraska | 31107 | 2 | 0 |
36973 | 36973 | 2020-04-06 | Merrick | Nebraska | 31121 | 2 | 0 |
36956 | 36956 | 2020-04-06 | Colfax | Nebraska | 31037 | 3 | 0 |
36979 | 36979 | 2020-04-06 | Saunders | Nebraska | 31155 | 4 | 0 |
36972 | 36972 | 2020-04-06 | Madison | Nebraska | 31119 | 5 | 1 |
36977 | 36977 | 2020-04-06 | Platte | Nebraska | 31141 | 5 | 0 |
36965 | 36965 | 2020-04-06 | Hamilton | Nebraska | 31081 | 6 | 0 |
36980 | 36980 | 2020-04-06 | Scotts Bluff | Nebraska | 31157 | 6 | 0 |
36960 | 36960 | 2020-04-06 | Dodge | Nebraska | 31053 | 7 | 0 |
36962 | 36962 | 2020-04-06 | Gage | Nebraska | 31067 | 9 | 1 |
36968 | 36968 | 2020-04-06 | Kimball | Nebraska | 31105 | 9 | 0 |
36950 | 36950 | 2020-04-06 | Adams | Nebraska | 31001 | 15 | 0 |
36971 | 36971 | 2020-04-06 | Lincoln | Nebraska | 31111 | 16 | 1 |
36952 | 36952 | 2020-04-06 | Buffalo | Nebraska | 31019 | 18 | 1 |
36983 | 36983 | 2020-04-06 | Washington | Nebraska | 31177 | 20 | 0 |
36970 | 36970 | 2020-04-06 | Lancaster | Nebraska | 31109 | 31 | 0 |
36978 | 36978 | 2020-04-06 | Sarpy | Nebraska | 31153 | 33 | 0 |
36964 | 36964 | 2020-04-06 | Hall | Nebraska | 31079 | 55 | 1 |
36961 | 36961 | 2020-04-06 | Douglas | Nebraska | 31055 | 173 | 4 |
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);