ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Scotts Bluff" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536162 | 536162 | 2020-09-15 | Scotts Bluff | Nebraska | 31157 | 392 | 7 |
532927 | 532927 | 2020-09-14 | Scotts Bluff | Nebraska | 31157 | 389 | 7 |
529691 | 529691 | 2020-09-13 | Scotts Bluff | Nebraska | 31157 | 387 | 7 |
526455 | 526455 | 2020-09-12 | Scotts Bluff | Nebraska | 31157 | 387 | 7 |
523219 | 523219 | 2020-09-11 | Scotts Bluff | Nebraska | 31157 | 387 | 7 |
519982 | 519982 | 2020-09-10 | Scotts Bluff | Nebraska | 31157 | 387 | 6 |
516747 | 516747 | 2020-09-09 | Scotts Bluff | Nebraska | 31157 | 384 | 6 |
513513 | 513513 | 2020-09-08 | Scotts Bluff | Nebraska | 31157 | 378 | 6 |
510281 | 510281 | 2020-09-07 | Scotts Bluff | Nebraska | 31157 | 374 | 6 |
507048 | 507048 | 2020-09-06 | Scotts Bluff | Nebraska | 31157 | 371 | 6 |
503815 | 503815 | 2020-09-05 | Scotts Bluff | Nebraska | 31157 | 371 | 6 |
500581 | 500581 | 2020-09-04 | Scotts Bluff | Nebraska | 31157 | 371 | 6 |
497347 | 497347 | 2020-09-03 | Scotts Bluff | Nebraska | 31157 | 369 | 6 |
494114 | 494114 | 2020-09-02 | Scotts Bluff | Nebraska | 31157 | 368 | 6 |
490880 | 490880 | 2020-09-01 | Scotts Bluff | Nebraska | 31157 | 363 | 6 |
487647 | 487647 | 2020-08-31 | Scotts Bluff | Nebraska | 31157 | 358 | 6 |
484413 | 484413 | 2020-08-30 | Scotts Bluff | Nebraska | 31157 | 357 | 6 |
481178 | 481178 | 2020-08-29 | Scotts Bluff | Nebraska | 31157 | 355 | 6 |
477946 | 477946 | 2020-08-28 | Scotts Bluff | Nebraska | 31157 | 354 | 6 |
474713 | 474713 | 2020-08-27 | Scotts Bluff | Nebraska | 31157 | 351 | 6 |
471480 | 471480 | 2020-08-26 | Scotts Bluff | Nebraska | 31157 | 348 | 6 |
468249 | 468249 | 2020-08-25 | Scotts Bluff | Nebraska | 31157 | 342 | 6 |
465020 | 465020 | 2020-08-24 | Scotts Bluff | Nebraska | 31157 | 331 | 6 |
461789 | 461789 | 2020-08-23 | Scotts Bluff | Nebraska | 31157 | 331 | 6 |
458562 | 458562 | 2020-08-22 | Scotts Bluff | Nebraska | 31157 | 327 | 6 |
455334 | 455334 | 2020-08-21 | Scotts Bluff | Nebraska | 31157 | 323 | 6 |
452106 | 452106 | 2020-08-20 | Scotts Bluff | Nebraska | 31157 | 322 | 6 |
448878 | 448878 | 2020-08-19 | Scotts Bluff | Nebraska | 31157 | 320 | 6 |
445652 | 445652 | 2020-08-18 | Scotts Bluff | Nebraska | 31157 | 319 | 6 |
442425 | 442425 | 2020-08-17 | Scotts Bluff | Nebraska | 31157 | 315 | 6 |
439198 | 439198 | 2020-08-16 | Scotts Bluff | Nebraska | 31157 | 313 | 6 |
435973 | 435973 | 2020-08-15 | Scotts Bluff | Nebraska | 31157 | 312 | 6 |
432747 | 432747 | 2020-08-14 | Scotts Bluff | Nebraska | 31157 | 311 | 6 |
429520 | 429520 | 2020-08-13 | Scotts Bluff | Nebraska | 31157 | 309 | 6 |
426295 | 426295 | 2020-08-12 | Scotts Bluff | Nebraska | 31157 | 305 | 6 |
423073 | 423073 | 2020-08-11 | Scotts Bluff | Nebraska | 31157 | 304 | 6 |
419850 | 419850 | 2020-08-10 | Scotts Bluff | Nebraska | 31157 | 301 | 6 |
416629 | 416629 | 2020-08-09 | Scotts Bluff | Nebraska | 31157 | 301 | 6 |
413409 | 413409 | 2020-08-08 | Scotts Bluff | Nebraska | 31157 | 301 | 6 |
410189 | 410189 | 2020-08-07 | Scotts Bluff | Nebraska | 31157 | 298 | 6 |
406969 | 406969 | 2020-08-06 | Scotts Bluff | Nebraska | 31157 | 297 | 6 |
403750 | 403750 | 2020-08-05 | Scotts Bluff | Nebraska | 31157 | 297 | 6 |
400532 | 400532 | 2020-08-04 | Scotts Bluff | Nebraska | 31157 | 291 | 6 |
397317 | 397317 | 2020-08-03 | Scotts Bluff | Nebraska | 31157 | 289 | 6 |
394101 | 394101 | 2020-08-02 | Scotts Bluff | Nebraska | 31157 | 289 | 6 |
390884 | 390884 | 2020-08-01 | Scotts Bluff | Nebraska | 31157 | 287 | 6 |
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 |
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);