ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where "date" is on date 2020-07-08 and state = "Nebraska" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 79
- 31001 1
- 31003 1
- 31007 1
- 31011 1
- 31013 1
- 31015 1
- 31019 1
- 31021 1
- 31023 1
- 31025 1
- 31027 1
- 31029 1
- 31031 1
- 31033 1
- 31035 1
- 31037 1
- 31039 1
- 31041 1
- 31043 1
- 31045 1
- 31047 1
- 31051 1
- 31053 1
- 31055 1
- 31059 1
- 31061 1
- 31063 1
- 31065 1
- 31067 1
- 31069 1
- 31071 1
- 31073 1
- 31077 1
- 31079 1
- 31081 1
- 31083 1
- 31087 1
- 31089 1
- 31091 1
- 31093 1
- 31095 1
- 31097 1
- 31099 1
- 31101 1
- 31105 1
- 31107 1
- 31109 1
- 31111 1
- 31119 1
- 31121 1
- 31123 1
- 31125 1
- 31127 1
- 31129 1
- 31131 1
- 31137 1
- 31139 1
- 31141 1
- 31143 1
- 31145 1
- 31147 1
- 31149 1
- 31151 1
- 31153 1
- 31155 1
- 31157 1
- 31159 1
- 31161 1
- 31163 1
- 31165 1
- 31167 1
- 31169 1
- 31171 1
- 31173 1
- 31175 1
- 31177 1
- 31179 1
- 31181 1
- 31185 1
county 79
- Adams 1
- Antelope 1
- Banner 1
- Boone 1
- Box Butte 1
- Boyd 1
- Buffalo 1
- Burt 1
- Butler 1
- Cass 1
- Cedar 1
- Chase 1
- Cherry 1
- Cheyenne 1
- Clay 1
- Colfax 1
- Cuming 1
- Custer 1
- Dakota 1
- Dawes 1
- Dawson 1
- Dixon 1
- Dodge 1
- Douglas 1
- Fillmore 1
- Franklin 1
- Frontier 1
- Furnas 1
- Gage 1
- Garden 1
- Garfield 1
- Gosper 1
- Greeley 1
- Hall 1
- Hamilton 1
- Harlan 1
- Hitchcock 1
- Holt 1
- Hooker 1
- Howard 1
- Jefferson 1
- Johnson 1
- Kearney 1
- Keith 1
- Kimball 1
- Knox 1
- Lancaster 1
- Lincoln 1
- Madison 1
- Merrick 1
- Morrill 1
- Nance 1
- Nemaha 1
- Nuckolls 1
- Otoe 1
- Phelps 1
- Pierce 1
- Platte 1
- Polk 1
- Red Willow 1
- Richardson 1
- Rock 1
- Saline 1
- Sarpy 1
- Saunders 1
- Scotts Bluff 1
- Seward 1
- Sheridan 1
- Sherman 1
- Sioux 1
- Stanton 1
- Thayer 1
- Thomas 1
- Thurston 1
- Valley 1
- Washington 1
- Wayne 1
- Webster 1
- York 1
state 1
- Nebraska · 79 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
314006 | 314006 | 2020-07-08 | Boyd | Nebraska | 31015 | 1 | 0 |
314012 | 314012 | 2020-07-08 | Chase | Nebraska | 31029 | 1 | 0 |
314027 | 314027 | 2020-07-08 | Frontier | Nebraska | 31063 | 1 | 0 |
314031 | 314031 | 2020-07-08 | Garfield | Nebraska | 31071 | 1 | 0 |
314036 | 314036 | 2020-07-08 | Harlan | Nebraska | 31083 | 1 | 0 |
314037 | 314037 | 2020-07-08 | Hitchcock | Nebraska | 31087 | 1 | 0 |
314054 | 314054 | 2020-07-08 | Nuckolls | Nebraska | 31129 | 1 | 0 |
314073 | 314073 | 2020-07-08 | Thomas | Nebraska | 31171 | 1 | 0 |
314003 | 314003 | 2020-07-08 | Banner | Nebraska | 31007 | 2 | 0 |
314013 | 314013 | 2020-07-08 | Cherry | Nebraska | 31031 | 2 | 0 |
314039 | 314039 | 2020-07-08 | Hooker | Nebraska | 31091 | 2 | 0 |
314062 | 314062 | 2020-07-08 | Rock | Nebraska | 31149 | 2 | 0 |
314005 | 314005 | 2020-07-08 | Box Butte | Nebraska | 31013 | 3 | 0 |
314020 | 314020 | 2020-07-08 | Dawes | Nebraska | 31045 | 4 | 0 |
314030 | 314030 | 2020-07-08 | Garden | Nebraska | 31069 | 4 | 0 |
314038 | 314038 | 2020-07-08 | Holt | Nebraska | 31089 | 4 | 0 |
314044 | 314044 | 2020-07-08 | Keith | Nebraska | 31101 | 4 | 0 |
314052 | 314052 | 2020-07-08 | Nance | Nebraska | 31125 | 4 | 0 |
314072 | 314072 | 2020-07-08 | Thayer | Nebraska | 31169 | 4 | 0 |
314033 | 314033 | 2020-07-08 | Greeley | Nebraska | 31077 | 5 | 0 |
314053 | 314053 | 2020-07-08 | Nemaha | Nebraska | 31127 | 5 | 0 |
314061 | 314061 | 2020-07-08 | Richardson | Nebraska | 31147 | 5 | 1 |
314069 | 314069 | 2020-07-08 | Sherman | Nebraska | 31163 | 5 | 0 |
314070 | 314070 | 2020-07-08 | Sioux | Nebraska | 31165 | 6 | 0 |
314004 | 314004 | 2020-07-08 | Boone | Nebraska | 31011 | 7 | 0 |
314042 | 314042 | 2020-07-08 | Johnson | Nebraska | 31097 | 7 | 0 |
314078 | 314078 | 2020-07-08 | Webster | Nebraska | 31181 | 7 | 0 |
314026 | 314026 | 2020-07-08 | Franklin | Nebraska | 31061 | 8 | 0 |
314060 | 314060 | 2020-07-08 | Red Willow | Nebraska | 31145 | 8 | 0 |
314068 | 314068 | 2020-07-08 | Sheridan | Nebraska | 31161 | 8 | 0 |
314075 | 314075 | 2020-07-08 | Valley | Nebraska | 31175 | 8 | 0 |
314002 | 314002 | 2020-07-08 | Antelope | Nebraska | 31003 | 9 | 1 |
314028 | 314028 | 2020-07-08 | Furnas | Nebraska | 31065 | 10 | 1 |
314041 | 314041 | 2020-07-08 | Jefferson | Nebraska | 31095 | 10 | 0 |
314057 | 314057 | 2020-07-08 | Pierce | Nebraska | 31139 | 10 | 0 |
314045 | 314045 | 2020-07-08 | Kimball | Nebraska | 31105 | 11 | 0 |
314032 | 314032 | 2020-07-08 | Gosper | Nebraska | 31073 | 13 | 0 |
314059 | 314059 | 2020-07-08 | Polk | Nebraska | 31143 | 13 | 0 |
314008 | 314008 | 2020-07-08 | Burt | Nebraska | 31021 | 14 | 0 |
314025 | 314025 | 2020-07-08 | Fillmore | Nebraska | 31059 | 17 | 1 |
314043 | 314043 | 2020-07-08 | Kearney | Nebraska | 31099 | 17 | 0 |
314011 | 314011 | 2020-07-08 | Cedar | Nebraska | 31027 | 18 | 0 |
314014 | 314014 | 2020-07-08 | Cheyenne | Nebraska | 31033 | 20 | 0 |
314071 | 314071 | 2020-07-08 | Stanton | Nebraska | 31167 | 21 | 0 |
314046 | 314046 | 2020-07-08 | Knox | Nebraska | 31107 | 24 | 0 |
314055 | 314055 | 2020-07-08 | Otoe | Nebraska | 31131 | 25 | 0 |
314056 | 314056 | 2020-07-08 | Phelps | Nebraska | 31137 | 27 | 0 |
314015 | 314015 | 2020-07-08 | Clay | Nebraska | 31035 | 28 | 0 |
314077 | 314077 | 2020-07-08 | Wayne | Nebraska | 31179 | 28 | 0 |
314017 | 314017 | 2020-07-08 | Cuming | Nebraska | 31039 | 38 | 0 |
314050 | 314050 | 2020-07-08 | Merrick | Nebraska | 31121 | 39 | 0 |
314018 | 314018 | 2020-07-08 | Custer | Nebraska | 31041 | 40 | 4 |
314040 | 314040 | 2020-07-08 | Howard | Nebraska | 31093 | 44 | 4 |
314067 | 314067 | 2020-07-08 | Seward | Nebraska | 31159 | 46 | 1 |
314079 | 314079 | 2020-07-08 | York | Nebraska | 31185 | 49 | 0 |
314051 | 314051 | 2020-07-08 | Morrill | Nebraska | 31123 | 51 | 0 |
314009 | 314009 | 2020-07-08 | Butler | Nebraska | 31023 | 52 | 0 |
314022 | 314022 | 2020-07-08 | Dixon | Nebraska | 31051 | 52 | 2 |
314076 | 314076 | 2020-07-08 | Washington | Nebraska | 31177 | 53 | 1 |
314029 | 314029 | 2020-07-08 | Gage | Nebraska | 31067 | 59 | 4 |
314048 | 314048 | 2020-07-08 | Lincoln | Nebraska | 31111 | 63 | 2 |
314035 | 314035 | 2020-07-08 | Hamilton | Nebraska | 31081 | 70 | 13 |
314010 | 314010 | 2020-07-08 | Cass | Nebraska | 31025 | 76 | 1 |
314065 | 314065 | 2020-07-08 | Saunders | Nebraska | 31155 | 83 | 2 |
314074 | 314074 | 2020-07-08 | Thurston | Nebraska | 31173 | 167 | 1 |
314007 | 314007 | 2020-07-08 | Buffalo | Nebraska | 31019 | 198 | 1 |
314066 | 314066 | 2020-07-08 | Scotts Bluff | Nebraska | 31157 | 231 | 5 |
314001 | 314001 | 2020-07-08 | Adams | Nebraska | 31001 | 304 | 11 |
314049 | 314049 | 2020-07-08 | Madison | Nebraska | 31119 | 379 | 4 |
314063 | 314063 | 2020-07-08 | Saline | Nebraska | 31151 | 544 | 2 |
314016 | 314016 | 2020-07-08 | Colfax | Nebraska | 31037 | 671 | 4 |
314058 | 314058 | 2020-07-08 | Platte | Nebraska | 31141 | 681 | 3 |
314023 | 314023 | 2020-07-08 | Dodge | Nebraska | 31053 | 699 | 8 |
314021 | 314021 | 2020-07-08 | Dawson | Nebraska | 31047 | 867 | 8 |
314064 | 314064 | 2020-07-08 | Sarpy | Nebraska | 31153 | 1272 | 8 |
314034 | 314034 | 2020-07-08 | Hall | Nebraska | 31079 | 1620 | 47 |
314019 | 314019 | 2020-07-08 | Dakota | Nebraska | 31043 | 1800 | 38 |
314047 | 314047 | 2020-07-08 | Lancaster | Nebraska | 31109 | 1963 | 13 |
314024 | 314024 | 2020-07-08 | Douglas | Nebraska | 31055 | 7789 | 100 |
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);