ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 31157 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387667 | 387667 | 2020-07-31 | Scotts Bluff | Nebraska | 31157 | 284 | 6 |
384449 | 384449 | 2020-07-30 | Scotts Bluff | Nebraska | 31157 | 278 | 6 |
381233 | 381233 | 2020-07-29 | Scotts Bluff | Nebraska | 31157 | 273 | 6 |
378015 | 378015 | 2020-07-28 | Scotts Bluff | Nebraska | 31157 | 273 | 6 |
374799 | 374799 | 2020-07-27 | Scotts Bluff | Nebraska | 31157 | 274 | 6 |
371587 | 371587 | 2020-07-26 | Scotts Bluff | Nebraska | 31157 | 274 | 6 |
368376 | 368376 | 2020-07-25 | Scotts Bluff | Nebraska | 31157 | 274 | 6 |
365167 | 365167 | 2020-07-24 | Scotts Bluff | Nebraska | 31157 | 272 | 6 |
361961 | 361961 | 2020-07-23 | Scotts Bluff | Nebraska | 31157 | 269 | 6 |
358755 | 358755 | 2020-07-22 | Scotts Bluff | Nebraska | 31157 | 265 | 5 |
355551 | 355551 | 2020-07-21 | Scotts Bluff | Nebraska | 31157 | 258 | 5 |
352348 | 352348 | 2020-07-20 | Scotts Bluff | Nebraska | 31157 | 258 | 5 |
349146 | 349146 | 2020-07-19 | Scotts Bluff | Nebraska | 31157 | 250 | 5 |
345945 | 345945 | 2020-07-18 | Scotts Bluff | Nebraska | 31157 | 249 | 5 |
342745 | 342745 | 2020-07-17 | Scotts Bluff | Nebraska | 31157 | 249 | 5 |
339548 | 339548 | 2020-07-16 | Scotts Bluff | Nebraska | 31157 | 248 | 5 |
336351 | 336351 | 2020-07-15 | Scotts Bluff | Nebraska | 31157 | 245 | 5 |
333157 | 333157 | 2020-07-14 | Scotts Bluff | Nebraska | 31157 | 244 | 5 |
329967 | 329967 | 2020-07-13 | Scotts Bluff | Nebraska | 31157 | 243 | 5 |
326780 | 326780 | 2020-07-12 | Scotts Bluff | Nebraska | 31157 | 241 | 5 |
323596 | 323596 | 2020-07-11 | Scotts Bluff | Nebraska | 31157 | 241 | 5 |
320416 | 320416 | 2020-07-10 | Scotts Bluff | Nebraska | 31157 | 235 | 5 |
317240 | 317240 | 2020-07-09 | Scotts Bluff | Nebraska | 31157 | 233 | 5 |
314066 | 314066 | 2020-07-08 | Scotts Bluff | Nebraska | 31157 | 231 | 5 |
310895 | 310895 | 2020-07-07 | Scotts Bluff | Nebraska | 31157 | 229 | 3 |
307727 | 307727 | 2020-07-06 | Scotts Bluff | Nebraska | 31157 | 227 | 3 |
304560 | 304560 | 2020-07-05 | Scotts Bluff | Nebraska | 31157 | 224 | 3 |
301396 | 301396 | 2020-07-04 | Scotts Bluff | Nebraska | 31157 | 224 | 3 |
298233 | 298233 | 2020-07-03 | Scotts Bluff | Nebraska | 31157 | 224 | 3 |
295074 | 295074 | 2020-07-02 | Scotts Bluff | Nebraska | 31157 | 216 | 3 |
291919 | 291919 | 2020-07-01 | Scotts Bluff | Nebraska | 31157 | 216 | 3 |
288767 | 288767 | 2020-06-30 | Scotts Bluff | Nebraska | 31157 | 215 | 3 |
285617 | 285617 | 2020-06-29 | Scotts Bluff | Nebraska | 31157 | 213 | 3 |
282472 | 282472 | 2020-06-28 | Scotts Bluff | Nebraska | 31157 | 209 | 3 |
279324 | 279324 | 2020-06-27 | Scotts Bluff | Nebraska | 31157 | 209 | 3 |
276176 | 276176 | 2020-06-26 | Scotts Bluff | Nebraska | 31157 | 208 | 3 |
273033 | 273033 | 2020-06-25 | Scotts Bluff | Nebraska | 31157 | 205 | 3 |
269894 | 269894 | 2020-06-24 | Scotts Bluff | Nebraska | 31157 | 202 | 3 |
266759 | 266759 | 2020-06-23 | Scotts Bluff | Nebraska | 31157 | 199 | 3 |
263632 | 263632 | 2020-06-22 | Scotts Bluff | Nebraska | 31157 | 193 | 3 |
260503 | 260503 | 2020-06-21 | Scotts Bluff | Nebraska | 31157 | 190 | 2 |
257377 | 257377 | 2020-06-20 | Scotts Bluff | Nebraska | 31157 | 188 | 2 |
254254 | 254254 | 2020-06-19 | Scotts Bluff | Nebraska | 31157 | 187 | 2 |
251139 | 251139 | 2020-06-18 | Scotts Bluff | Nebraska | 31157 | 187 | 2 |
248024 | 248024 | 2020-06-17 | Scotts Bluff | Nebraska | 31157 | 184 | 2 |
244911 | 244911 | 2020-06-16 | Scotts Bluff | Nebraska | 31157 | 178 | 2 |
241800 | 241800 | 2020-06-15 | Scotts Bluff | Nebraska | 31157 | 177 | 2 |
238690 | 238690 | 2020-06-14 | Scotts Bluff | Nebraska | 31157 | 172 | 2 |
235583 | 235583 | 2020-06-13 | Scotts Bluff | Nebraska | 31157 | 172 | 2 |
232477 | 232477 | 2020-06-12 | Scotts Bluff | Nebraska | 31157 | 170 | 2 |
229372 | 229372 | 2020-06-11 | Scotts Bluff | Nebraska | 31157 | 162 | 2 |
226269 | 226269 | 2020-06-10 | Scotts Bluff | Nebraska | 31157 | 149 | 1 |
223170 | 223170 | 2020-06-09 | Scotts Bluff | Nebraska | 31157 | 149 | 1 |
220074 | 220074 | 2020-06-08 | Scotts Bluff | Nebraska | 31157 | 145 | 0 |
216982 | 216982 | 2020-06-07 | Scotts Bluff | Nebraska | 31157 | 143 | 0 |
213893 | 213893 | 2020-06-06 | Scotts Bluff | Nebraska | 31157 | 140 | 0 |
210809 | 210809 | 2020-06-05 | Scotts Bluff | Nebraska | 31157 | 137 | 0 |
207727 | 207727 | 2020-06-04 | Scotts Bluff | Nebraska | 31157 | 124 | 0 |
204646 | 204646 | 2020-06-03 | Scotts Bluff | Nebraska | 31157 | 120 | 0 |
201569 | 201569 | 2020-06-02 | Scotts Bluff | Nebraska | 31157 | 112 | 0 |
198495 | 198495 | 2020-06-01 | Scotts Bluff | Nebraska | 31157 | 107 | 0 |
195422 | 195422 | 2020-05-31 | Scotts Bluff | Nebraska | 31157 | 102 | 0 |
192352 | 192352 | 2020-05-30 | Scotts Bluff | Nebraska | 31157 | 102 | 0 |
189288 | 189288 | 2020-05-29 | Scotts Bluff | Nebraska | 31157 | 88 | 0 |
186229 | 186229 | 2020-05-28 | Scotts Bluff | Nebraska | 31157 | 84 | 0 |
183173 | 183173 | 2020-05-27 | Scotts Bluff | Nebraska | 31157 | 75 | 0 |
180125 | 180125 | 2020-05-26 | Scotts Bluff | Nebraska | 31157 | 72 | 0 |
177081 | 177081 | 2020-05-25 | Scotts Bluff | Nebraska | 31157 | 67 | 0 |
174038 | 174038 | 2020-05-24 | Scotts Bluff | Nebraska | 31157 | 67 | 0 |
170995 | 170995 | 2020-05-23 | Scotts Bluff | Nebraska | 31157 | 62 | 0 |
167956 | 167956 | 2020-05-22 | Scotts Bluff | Nebraska | 31157 | 58 | 0 |
164920 | 164920 | 2020-05-21 | Scotts Bluff | Nebraska | 31157 | 58 | 0 |
161891 | 161891 | 2020-05-20 | Scotts Bluff | Nebraska | 31157 | 55 | 0 |
158865 | 158865 | 2020-05-19 | Scotts Bluff | Nebraska | 31157 | 54 | 0 |
155847 | 155847 | 2020-05-18 | Scotts Bluff | Nebraska | 31157 | 54 | 0 |
152833 | 152833 | 2020-05-17 | Scotts Bluff | Nebraska | 31157 | 54 | 0 |
149822 | 149822 | 2020-05-16 | Scotts Bluff | Nebraska | 31157 | 51 | 0 |
146815 | 146815 | 2020-05-15 | Scotts Bluff | Nebraska | 31157 | 51 | 0 |
143814 | 143814 | 2020-05-14 | Scotts Bluff | Nebraska | 31157 | 48 | 0 |
140819 | 140819 | 2020-05-13 | Scotts Bluff | Nebraska | 31157 | 47 | 0 |
137824 | 137824 | 2020-05-12 | Scotts Bluff | Nebraska | 31157 | 46 | 0 |
134834 | 134834 | 2020-05-11 | Scotts Bluff | Nebraska | 31157 | 44 | 0 |
131843 | 131843 | 2020-05-10 | Scotts Bluff | Nebraska | 31157 | 44 | 0 |
128853 | 128853 | 2020-05-09 | Scotts Bluff | Nebraska | 31157 | 44 | 0 |
125864 | 125864 | 2020-05-08 | Scotts Bluff | Nebraska | 31157 | 42 | 0 |
122882 | 122882 | 2020-05-07 | Scotts Bluff | Nebraska | 31157 | 36 | 0 |
119908 | 119908 | 2020-05-06 | Scotts Bluff | Nebraska | 31157 | 36 | 0 |
116948 | 116948 | 2020-05-05 | Scotts Bluff | Nebraska | 31157 | 34 | 0 |
114066 | 114066 | 2020-05-04 | Scotts Bluff | Nebraska | 31157 | 34 | 0 |
111186 | 111186 | 2020-05-03 | Scotts Bluff | Nebraska | 31157 | 34 | 0 |
108313 | 108313 | 2020-05-02 | Scotts Bluff | Nebraska | 31157 | 31 | 0 |
105446 | 105446 | 2020-05-01 | Scotts Bluff | Nebraska | 31157 | 29 | 0 |
102585 | 102585 | 2020-04-30 | Scotts Bluff | Nebraska | 31157 | 29 | 0 |
99732 | 99732 | 2020-04-29 | Scotts Bluff | Nebraska | 31157 | 29 | 0 |
96885 | 96885 | 2020-04-28 | Scotts Bluff | Nebraska | 31157 | 29 | 0 |
94049 | 94049 | 2020-04-27 | Scotts Bluff | Nebraska | 31157 | 27 | 0 |
91227 | 91227 | 2020-04-26 | Scotts Bluff | Nebraska | 31157 | 27 | 0 |
88411 | 88411 | 2020-04-25 | Scotts Bluff | Nebraska | 31157 | 26 | 0 |
85601 | 85601 | 2020-04-24 | Scotts Bluff | Nebraska | 31157 | 23 | 0 |
82796 | 82796 | 2020-04-23 | Scotts Bluff | Nebraska | 31157 | 23 | 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);