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 |
---|---|---|---|---|---|---|---|
636632 | 636632 | 2020-10-16 | Scotts Bluff | Nebraska | 31157 | 510 | 8 |
633386 | 633386 | 2020-10-15 | Scotts Bluff | Nebraska | 31157 | 498 | 8 |
630141 | 630141 | 2020-10-14 | Scotts Bluff | Nebraska | 31157 | 488 | 8 |
626897 | 626897 | 2020-10-13 | Scotts Bluff | Nebraska | 31157 | 480 | 8 |
623655 | 623655 | 2020-10-12 | Scotts Bluff | Nebraska | 31157 | 472 | 8 |
620412 | 620412 | 2020-10-11 | Scotts Bluff | Nebraska | 31157 | 470 | 8 |
617170 | 617170 | 2020-10-10 | Scotts Bluff | Nebraska | 31157 | 467 | 8 |
613929 | 613929 | 2020-10-09 | Scotts Bluff | Nebraska | 31157 | 455 | 8 |
610687 | 610687 | 2020-10-08 | Scotts Bluff | Nebraska | 31157 | 455 | 8 |
607445 | 607445 | 2020-10-07 | Scotts Bluff | Nebraska | 31157 | 454 | 8 |
604202 | 604202 | 2020-10-06 | Scotts Bluff | Nebraska | 31157 | 450 | 8 |
600960 | 600960 | 2020-10-05 | Scotts Bluff | Nebraska | 31157 | 442 | 8 |
597716 | 597716 | 2020-10-04 | Scotts Bluff | Nebraska | 31157 | 440 | 8 |
594474 | 594474 | 2020-10-03 | Scotts Bluff | Nebraska | 31157 | 439 | 8 |
591233 | 591233 | 2020-10-02 | Scotts Bluff | Nebraska | 31157 | 435 | 8 |
587992 | 587992 | 2020-10-01 | Scotts Bluff | Nebraska | 31157 | 427 | 8 |
584752 | 584752 | 2020-09-30 | Scotts Bluff | Nebraska | 31157 | 424 | 8 |
581511 | 581511 | 2020-09-29 | Scotts Bluff | Nebraska | 31157 | 423 | 8 |
578270 | 578270 | 2020-09-28 | Scotts Bluff | Nebraska | 31157 | 419 | 8 |
575029 | 575029 | 2020-09-27 | Scotts Bluff | Nebraska | 31157 | 414 | 8 |
571786 | 571786 | 2020-09-26 | Scotts Bluff | Nebraska | 31157 | 414 | 8 |
568544 | 568544 | 2020-09-25 | Scotts Bluff | Nebraska | 31157 | 411 | 8 |
565303 | 565303 | 2020-09-24 | Scotts Bluff | Nebraska | 31157 | 407 | 8 |
562062 | 562062 | 2020-09-23 | Scotts Bluff | Nebraska | 31157 | 407 | 8 |
558825 | 558825 | 2020-09-22 | Scotts Bluff | Nebraska | 31157 | 406 | 7 |
555588 | 555588 | 2020-09-21 | Scotts Bluff | Nebraska | 31157 | 405 | 7 |
552350 | 552350 | 2020-09-20 | Scotts Bluff | Nebraska | 31157 | 405 | 7 |
549111 | 549111 | 2020-09-19 | Scotts Bluff | Nebraska | 31157 | 405 | 7 |
545873 | 545873 | 2020-09-18 | Scotts Bluff | Nebraska | 31157 | 404 | 7 |
542636 | 542636 | 2020-09-17 | Scotts Bluff | Nebraska | 31157 | 398 | 7 |
539400 | 539400 | 2020-09-16 | Scotts Bluff | Nebraska | 31157 | 393 | 7 |
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 |
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);