ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Adams" and fips = 31001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636554 | 636554 | 2020-10-16 | Adams | Nebraska | 31001 | 698 | 13 |
633308 | 633308 | 2020-10-15 | Adams | Nebraska | 31001 | 691 | 12 |
630063 | 630063 | 2020-10-14 | Adams | Nebraska | 31001 | 681 | 12 |
626819 | 626819 | 2020-10-13 | Adams | Nebraska | 31001 | 662 | 12 |
623577 | 623577 | 2020-10-12 | Adams | Nebraska | 31001 | 655 | 12 |
620334 | 620334 | 2020-10-11 | Adams | Nebraska | 31001 | 650 | 12 |
617092 | 617092 | 2020-10-10 | Adams | Nebraska | 31001 | 649 | 12 |
613851 | 613851 | 2020-10-09 | Adams | Nebraska | 31001 | 625 | 12 |
610609 | 610609 | 2020-10-08 | Adams | Nebraska | 31001 | 625 | 12 |
607367 | 607367 | 2020-10-07 | Adams | Nebraska | 31001 | 617 | 12 |
604124 | 604124 | 2020-10-06 | Adams | Nebraska | 31001 | 613 | 12 |
600882 | 600882 | 2020-10-05 | Adams | Nebraska | 31001 | 607 | 12 |
597638 | 597638 | 2020-10-04 | Adams | Nebraska | 31001 | 596 | 12 |
594397 | 594397 | 2020-10-03 | Adams | Nebraska | 31001 | 596 | 12 |
591156 | 591156 | 2020-10-02 | Adams | Nebraska | 31001 | 586 | 12 |
587915 | 587915 | 2020-10-01 | Adams | Nebraska | 31001 | 580 | 12 |
584675 | 584675 | 2020-09-30 | Adams | Nebraska | 31001 | 574 | 12 |
581434 | 581434 | 2020-09-29 | Adams | Nebraska | 31001 | 570 | 12 |
578193 | 578193 | 2020-09-28 | Adams | Nebraska | 31001 | 558 | 12 |
574952 | 574952 | 2020-09-27 | Adams | Nebraska | 31001 | 548 | 12 |
571709 | 571709 | 2020-09-26 | Adams | Nebraska | 31001 | 543 | 12 |
568467 | 568467 | 2020-09-25 | Adams | Nebraska | 31001 | 542 | 12 |
565227 | 565227 | 2020-09-24 | Adams | Nebraska | 31001 | 534 | 12 |
561986 | 561986 | 2020-09-23 | Adams | Nebraska | 31001 | 520 | 12 |
558749 | 558749 | 2020-09-22 | Adams | Nebraska | 31001 | 514 | 12 |
555512 | 555512 | 2020-09-21 | Adams | Nebraska | 31001 | 510 | 12 |
552274 | 552274 | 2020-09-20 | Adams | Nebraska | 31001 | 508 | 12 |
549035 | 549035 | 2020-09-19 | Adams | Nebraska | 31001 | 506 | 12 |
545797 | 545797 | 2020-09-18 | Adams | Nebraska | 31001 | 499 | 12 |
542560 | 542560 | 2020-09-17 | Adams | Nebraska | 31001 | 491 | 12 |
539324 | 539324 | 2020-09-16 | Adams | Nebraska | 31001 | 482 | 12 |
536087 | 536087 | 2020-09-15 | Adams | Nebraska | 31001 | 480 | 12 |
532852 | 532852 | 2020-09-14 | Adams | Nebraska | 31001 | 469 | 11 |
529616 | 529616 | 2020-09-13 | Adams | Nebraska | 31001 | 458 | 11 |
526380 | 526380 | 2020-09-12 | Adams | Nebraska | 31001 | 458 | 11 |
523144 | 523144 | 2020-09-11 | Adams | Nebraska | 31001 | 453 | 11 |
519907 | 519907 | 2020-09-10 | Adams | Nebraska | 31001 | 448 | 11 |
516672 | 516672 | 2020-09-09 | Adams | Nebraska | 31001 | 441 | 11 |
513438 | 513438 | 2020-09-08 | Adams | Nebraska | 31001 | 436 | 11 |
510206 | 510206 | 2020-09-07 | Adams | Nebraska | 31001 | 430 | 11 |
506973 | 506973 | 2020-09-06 | Adams | Nebraska | 31001 | 430 | 11 |
503740 | 503740 | 2020-09-05 | Adams | Nebraska | 31001 | 429 | 11 |
500506 | 500506 | 2020-09-04 | Adams | Nebraska | 31001 | 429 | 11 |
497272 | 497272 | 2020-09-03 | Adams | Nebraska | 31001 | 428 | 11 |
494039 | 494039 | 2020-09-02 | Adams | Nebraska | 31001 | 419 | 11 |
490805 | 490805 | 2020-09-01 | Adams | Nebraska | 31001 | 416 | 11 |
487572 | 487572 | 2020-08-31 | Adams | Nebraska | 31001 | 410 | 11 |
484338 | 484338 | 2020-08-30 | Adams | Nebraska | 31001 | 403 | 11 |
481103 | 481103 | 2020-08-29 | Adams | Nebraska | 31001 | 401 | 11 |
477871 | 477871 | 2020-08-28 | Adams | Nebraska | 31001 | 399 | 11 |
474638 | 474638 | 2020-08-27 | Adams | Nebraska | 31001 | 396 | 11 |
471406 | 471406 | 2020-08-26 | Adams | Nebraska | 31001 | 392 | 11 |
468176 | 468176 | 2020-08-25 | Adams | Nebraska | 31001 | 387 | 11 |
464947 | 464947 | 2020-08-24 | Adams | Nebraska | 31001 | 384 | 11 |
461716 | 461716 | 2020-08-23 | Adams | Nebraska | 31001 | 381 | 11 |
458489 | 458489 | 2020-08-22 | Adams | Nebraska | 31001 | 381 | 11 |
455261 | 455261 | 2020-08-21 | Adams | Nebraska | 31001 | 381 | 11 |
452033 | 452033 | 2020-08-20 | Adams | Nebraska | 31001 | 379 | 11 |
448805 | 448805 | 2020-08-19 | Adams | Nebraska | 31001 | 375 | 11 |
445579 | 445579 | 2020-08-18 | Adams | Nebraska | 31001 | 360 | 11 |
442353 | 442353 | 2020-08-17 | Adams | Nebraska | 31001 | 370 | 11 |
439126 | 439126 | 2020-08-16 | Adams | Nebraska | 31001 | 365 | 11 |
435901 | 435901 | 2020-08-15 | Adams | Nebraska | 31001 | 364 | 11 |
432675 | 432675 | 2020-08-14 | Adams | Nebraska | 31001 | 364 | 11 |
429448 | 429448 | 2020-08-13 | Adams | Nebraska | 31001 | 363 | 11 |
426224 | 426224 | 2020-08-12 | Adams | Nebraska | 31001 | 362 | 11 |
423002 | 423002 | 2020-08-11 | Adams | Nebraska | 31001 | 361 | 11 |
419779 | 419779 | 2020-08-10 | Adams | Nebraska | 31001 | 358 | 11 |
416558 | 416558 | 2020-08-09 | Adams | Nebraska | 31001 | 353 | 11 |
413338 | 413338 | 2020-08-08 | Adams | Nebraska | 31001 | 353 | 11 |
410118 | 410118 | 2020-08-07 | Adams | Nebraska | 31001 | 353 | 11 |
406898 | 406898 | 2020-08-06 | Adams | Nebraska | 31001 | 350 | 11 |
403680 | 403680 | 2020-08-05 | Adams | Nebraska | 31001 | 346 | 11 |
400462 | 400462 | 2020-08-04 | Adams | Nebraska | 31001 | 346 | 11 |
397247 | 397247 | 2020-08-03 | Adams | Nebraska | 31001 | 344 | 11 |
394031 | 394031 | 2020-08-02 | Adams | Nebraska | 31001 | 341 | 11 |
390814 | 390814 | 2020-08-01 | Adams | Nebraska | 31001 | 340 | 11 |
387597 | 387597 | 2020-07-31 | Adams | Nebraska | 31001 | 339 | 11 |
384379 | 384379 | 2020-07-30 | Adams | Nebraska | 31001 | 336 | 11 |
381163 | 381163 | 2020-07-29 | Adams | Nebraska | 31001 | 331 | 11 |
377945 | 377945 | 2020-07-28 | Adams | Nebraska | 31001 | 329 | 11 |
374730 | 374730 | 2020-07-27 | Adams | Nebraska | 31001 | 328 | 11 |
371518 | 371518 | 2020-07-26 | Adams | Nebraska | 31001 | 326 | 11 |
368307 | 368307 | 2020-07-25 | Adams | Nebraska | 31001 | 324 | 11 |
365098 | 365098 | 2020-07-24 | Adams | Nebraska | 31001 | 323 | 11 |
361891 | 361891 | 2020-07-23 | Adams | Nebraska | 31001 | 320 | 11 |
358685 | 358685 | 2020-07-22 | Adams | Nebraska | 31001 | 320 | 11 |
355481 | 355481 | 2020-07-21 | Adams | Nebraska | 31001 | 320 | 11 |
352278 | 352278 | 2020-07-20 | Adams | Nebraska | 31001 | 320 | 10 |
349077 | 349077 | 2020-07-19 | Adams | Nebraska | 31001 | 316 | 11 |
345876 | 345876 | 2020-07-18 | Adams | Nebraska | 31001 | 316 | 11 |
342676 | 342676 | 2020-07-17 | Adams | Nebraska | 31001 | 316 | 11 |
339480 | 339480 | 2020-07-16 | Adams | Nebraska | 31001 | 315 | 11 |
336283 | 336283 | 2020-07-15 | Adams | Nebraska | 31001 | 315 | 11 |
333089 | 333089 | 2020-07-14 | Adams | Nebraska | 31001 | 315 | 11 |
329900 | 329900 | 2020-07-13 | Adams | Nebraska | 31001 | 314 | 11 |
326713 | 326713 | 2020-07-12 | Adams | Nebraska | 31001 | 312 | 11 |
323529 | 323529 | 2020-07-11 | Adams | Nebraska | 31001 | 312 | 11 |
320350 | 320350 | 2020-07-10 | Adams | Nebraska | 31001 | 309 | 11 |
317175 | 317175 | 2020-07-09 | Adams | Nebraska | 31001 | 309 | 11 |
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);