ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where "date" is on date 2021-07-26 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 94
- 31001 1
- 31003 1
- 31005 1
- 31007 1
- 31009 1
- 31011 1
- 31013 1
- 31015 1
- 31017 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
- 31049 1
- 31051 1
- 31053 1
- 31055 1
- 31057 1
- 31059 1
- 31061 1
- 31063 1
- 31065 1
- 31067 1
- 31069 1
- 31071 1
- 31073 1
- 31075 1
- 31077 1
- 31079 1
- 31081 1
- 31083 1
- 31085 1
- 31087 1
- 31089 1
- 31091 1
- 31093 1
- 31095 1
- 31097 1
- 31099 1
- 31101 1
- 31103 1
- 31105 1
- 31107 1
- 31109 1
- 31111 1
- 31113 1
- 31115 1
- 31117 1
- 31119 1
- 31121 1
- 31123 1
- 31125 1
- 31127 1
- 31129 1
- 31131 1
- 31133 1
- 31135 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
- 31183 1
- 31185 1
- - 1
county 94
- Adams 1
- Antelope 1
- Arthur 1
- Banner 1
- Blaine 1
- Boone 1
- Box Butte 1
- Boyd 1
- Brown 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
- Deuel 1
- Dixon 1
- Dodge 1
- Douglas 1
- Dundy 1
- Fillmore 1
- Franklin 1
- Frontier 1
- Furnas 1
- Gage 1
- Garden 1
- Garfield 1
- Gosper 1
- Grant 1
- Greeley 1
- Hall 1
- Hamilton 1
- Harlan 1
- Hayes 1
- Hitchcock 1
- Holt 1
- Hooker 1
- Howard 1
- Jefferson 1
- Johnson 1
- Kearney 1
- Keith 1
- Keya Paha 1
- Kimball 1
- Knox 1
- Lancaster 1
- Lincoln 1
- Logan 1
- Loup 1
- Madison 1
- McPherson 1
- Merrick 1
- Morrill 1
- Nance 1
- Nemaha 1
- Nuckolls 1
- Otoe 1
- Pawnee 1
- Perkins 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
- Unknown 1
- Valley 1
- Washington 1
- Wayne 1
- Webster 1
- Wheeler 1
- York 1
state 1
- Nebraska · 94 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1555144 | 1555144 | 2021-07-26 | Adams | Nebraska | 31001 | 3197 | 55 |
1555145 | 1555145 | 2021-07-26 | Antelope | Nebraska | 31003 | 622 | 8 |
1555146 | 1555146 | 2021-07-26 | Arthur | Nebraska | 31005 | 24 | 1 |
1555147 | 1555147 | 2021-07-26 | Banner | Nebraska | 31007 | 30 | 0 |
1555148 | 1555148 | 2021-07-26 | Blaine | Nebraska | 31009 | 26 | 0 |
1555149 | 1555149 | 2021-07-26 | Boone | Nebraska | 31011 | 585 | 4 |
1555150 | 1555150 | 2021-07-26 | Box Butte | Nebraska | 31013 | 974 | 11 |
1555151 | 1555151 | 2021-07-26 | Boyd | Nebraska | 31015 | 207 | 3 |
1555152 | 1555152 | 2021-07-26 | Brown | Nebraska | 31017 | 282 | 4 |
1555153 | 1555153 | 2021-07-26 | Buffalo | Nebraska | 31019 | 5557 | 57 |
1555154 | 1555154 | 2021-07-26 | Burt | Nebraska | 31021 | 671 | 12 |
1555155 | 1555155 | 2021-07-26 | Butler | Nebraska | 31023 | 864 | 12 |
1555156 | 1555156 | 2021-07-26 | Cass | Nebraska | 31025 | 2687 | 17 |
1555157 | 1555157 | 2021-07-26 | Cedar | Nebraska | 31027 | 956 | 11 |
1555158 | 1555158 | 2021-07-26 | Chase | Nebraska | 31029 | 477 | 5 |
1555159 | 1555159 | 2021-07-26 | Cherry | Nebraska | 31031 | 439 | 8 |
1555160 | 1555160 | 2021-07-26 | Cheyenne | Nebraska | 31033 | 978 | 19 |
1555161 | 1555161 | 2021-07-26 | Clay | Nebraska | 31035 | 783 | 17 |
1555162 | 1555162 | 2021-07-26 | Colfax | Nebraska | 31037 | 1594 | 21 |
1555163 | 1555163 | 2021-07-26 | Cuming | Nebraska | 31039 | 1056 | 15 |
1555164 | 1555164 | 2021-07-26 | Custer | Nebraska | 31041 | 907 | 19 |
1555165 | 1555165 | 2021-07-26 | Dakota | Nebraska | 31043 | 4171 | 82 |
1555166 | 1555166 | 2021-07-26 | Dawes | Nebraska | 31045 | 773 | 20 |
1555167 | 1555167 | 2021-07-26 | Dawson | Nebraska | 31047 | 2861 | 31 |
1555168 | 1555168 | 2021-07-26 | Deuel | Nebraska | 31049 | 117 | 2 |
1555169 | 1555169 | 2021-07-26 | Dixon | Nebraska | 31051 | 698 | 9 |
1555170 | 1555170 | 2021-07-26 | Dodge | Nebraska | 31053 | 5017 | 83 |
1555171 | 1555171 | 2021-07-26 | Douglas | Nebraska | 31055 | 73091 | 737 |
1555172 | 1555172 | 2021-07-26 | Dundy | Nebraska | 31057 | 187 | 4 |
1555173 | 1555173 | 2021-07-26 | Fillmore | Nebraska | 31059 | 507 | 13 |
1555174 | 1555174 | 2021-07-26 | Franklin | Nebraska | 31061 | 239 | 4 |
1555175 | 1555175 | 2021-07-26 | Frontier | Nebraska | 31063 | 157 | 1 |
1555176 | 1555176 | 2021-07-26 | Furnas | Nebraska | 31065 | 482 | 5 |
1555177 | 1555177 | 2021-07-26 | Gage | Nebraska | 31067 | 2155 | 20 |
1555178 | 1555178 | 2021-07-26 | Garden | Nebraska | 31069 | 118 | 1 |
1555179 | 1555179 | 2021-07-26 | Garfield | Nebraska | 31071 | 156 | 1 |
1555180 | 1555180 | 2021-07-26 | Gosper | Nebraska | 31073 | 180 | 5 |
1555181 | 1555181 | 2021-07-26 | Grant | Nebraska | 31075 | 36 | 4 |
1555182 | 1555182 | 2021-07-26 | Greeley | Nebraska | 31077 | 226 | 1 |
1555183 | 1555183 | 2021-07-26 | Hall | Nebraska | 31079 | 7892 | 120 |
1555184 | 1555184 | 2021-07-26 | Hamilton | Nebraska | 31081 | 978 | 18 |
1555185 | 1555185 | 2021-07-26 | Harlan | Nebraska | 31083 | 234 | 0 |
1555186 | 1555186 | 2021-07-26 | Hayes | Nebraska | 31085 | 59 | 0 |
1555187 | 1555187 | 2021-07-26 | Hitchcock | Nebraska | 31087 | 259 | 5 |
1555188 | 1555188 | 2021-07-26 | Holt | Nebraska | 31089 | 916 | 15 |
1555189 | 1555189 | 2021-07-26 | Hooker | Nebraska | 31091 | 47 | 3 |
1555190 | 1555190 | 2021-07-26 | Howard | Nebraska | 31093 | 594 | 10 |
1555191 | 1555191 | 2021-07-26 | Jefferson | Nebraska | 31095 | 662 | 3 |
1555192 | 1555192 | 2021-07-26 | Johnson | Nebraska | 31097 | 656 | 10 |
1555193 | 1555193 | 2021-07-26 | Kearney | Nebraska | 31099 | 624 | 5 |
1555194 | 1555194 | 2021-07-26 | Keith | Nebraska | 31101 | 713 | 10 |
1555195 | 1555195 | 2021-07-26 | Keya Paha | Nebraska | 31103 | 56 | 0 |
1555196 | 1555196 | 2021-07-26 | Kimball | Nebraska | 31105 | 442 | 7 |
1555197 | 1555197 | 2021-07-26 | Knox | Nebraska | 31107 | 1159 | 13 |
1555198 | 1555198 | 2021-07-26 | Lancaster | Nebraska | 31109 | 32049 | 242 |
1555199 | 1555199 | 2021-07-26 | Lincoln | Nebraska | 31111 | 4176 | 80 |
1555200 | 1555200 | 2021-07-26 | Logan | Nebraska | 31113 | 81 | 0 |
1555201 | 1555201 | 2021-07-26 | Loup | Nebraska | 31115 | 34 | 0 |
1555202 | 1555202 | 2021-07-26 | Madison | Nebraska | 31119 | 4303 | 44 |
1555203 | 1555203 | 2021-07-26 | McPherson | Nebraska | 31117 | 28 | 1 |
1555204 | 1555204 | 2021-07-26 | Merrick | Nebraska | 31121 | 780 | 15 |
1555205 | 1555205 | 2021-07-26 | Morrill | Nebraska | 31123 | 513 | 15 |
1555206 | 1555206 | 2021-07-26 | Nance | Nebraska | 31125 | 414 | 10 |
1555207 | 1555207 | 2021-07-26 | Nemaha | Nebraska | 31127 | 804 | 13 |
1555208 | 1555208 | 2021-07-26 | Nuckolls | Nebraska | 31129 | 548 | 12 |
1555209 | 1555209 | 2021-07-26 | Otoe | Nebraska | 31131 | 1479 | 13 |
1555210 | 1555210 | 2021-07-26 | Pawnee | Nebraska | 31133 | 241 | 4 |
1555211 | 1555211 | 2021-07-26 | Perkins | Nebraska | 31135 | 284 | 11 |
1555212 | 1555212 | 2021-07-26 | Phelps | Nebraska | 31137 | 1014 | 10 |
1555213 | 1555213 | 2021-07-26 | Pierce | Nebraska | 31139 | 734 | 21 |
1555214 | 1555214 | 2021-07-26 | Platte | Nebraska | 31141 | 4150 | 50 |
1555215 | 1555215 | 2021-07-26 | Polk | Nebraska | 31143 | 591 | 18 |
1555216 | 1555216 | 2021-07-26 | Red Willow | Nebraska | 31145 | 1282 | 15 |
1555217 | 1555217 | 2021-07-26 | Richardson | Nebraska | 31147 | 816 | 24 |
1555218 | 1555218 | 2021-07-26 | Rock | Nebraska | 31149 | 154 | 2 |
1555219 | 1555219 | 2021-07-26 | Saline | Nebraska | 31151 | 2037 | 3 |
1555220 | 1555220 | 2021-07-26 | Sarpy | Nebraska | 31153 | 22610 | 134 |
1555221 | 1555221 | 2021-07-26 | Saunders | Nebraska | 31155 | 2570 | 20 |
1555222 | 1555222 | 2021-07-26 | Scotts Bluff | Nebraska | 31157 | 4731 | 96 |
1555223 | 1555223 | 2021-07-26 | Seward | Nebraska | 31159 | 2051 | 34 |
1555224 | 1555224 | 2021-07-26 | Sheridan | Nebraska | 31161 | 542 | 21 |
1555225 | 1555225 | 2021-07-26 | Sherman | Nebraska | 31163 | 213 | 4 |
1555226 | 1555226 | 2021-07-26 | Sioux | Nebraska | 31165 | 31 | 1 |
1555227 | 1555227 | 2021-07-26 | Stanton | Nebraska | 31167 | 372 | 11 |
1555228 | 1555228 | 2021-07-26 | Thayer | Nebraska | 31169 | 490 | 7 |
1555229 | 1555229 | 2021-07-26 | Thomas | Nebraska | 31171 | 55 | 1 |
1555230 | 1555230 | 2021-07-26 | Thurston | Nebraska | 31173 | 1206 | 11 |
1555231 | 1555231 | 2021-07-26 | Unknown | Nebraska | 412 | 0 | |
1555232 | 1555232 | 2021-07-26 | Valley | Nebraska | 31175 | 344 | 2 |
1555233 | 1555233 | 2021-07-26 | Washington | Nebraska | 31177 | 2227 | 29 |
1555234 | 1555234 | 2021-07-26 | Wayne | Nebraska | 31179 | 1178 | 7 |
1555235 | 1555235 | 2021-07-26 | Webster | Nebraska | 31181 | 419 | 8 |
1555236 | 1555236 | 2021-07-26 | Wheeler | Nebraska | 31183 | 39 | 0 |
1555237 | 1555237 | 2021-07-26 | York | Nebraska | 31185 | 1848 | 16 |
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);