ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
224 rows where deaths = 1, fips = 33019 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
717773 | 717773 | 2020-11-10 | Sullivan | New Hampshire | 33019 | 141 | 1 |
714530 | 714530 | 2020-11-09 | Sullivan | New Hampshire | 33019 | 136 | 1 |
711286 | 711286 | 2020-11-08 | Sullivan | New Hampshire | 33019 | 133 | 1 |
708042 | 708042 | 2020-11-07 | Sullivan | New Hampshire | 33019 | 118 | 1 |
704799 | 704799 | 2020-11-06 | Sullivan | New Hampshire | 33019 | 109 | 1 |
701556 | 701556 | 2020-11-05 | Sullivan | New Hampshire | 33019 | 103 | 1 |
698312 | 698312 | 2020-11-04 | Sullivan | New Hampshire | 33019 | 99 | 1 |
695069 | 695069 | 2020-11-03 | Sullivan | New Hampshire | 33019 | 99 | 1 |
691827 | 691827 | 2020-11-02 | Sullivan | New Hampshire | 33019 | 95 | 1 |
688583 | 688583 | 2020-11-01 | Sullivan | New Hampshire | 33019 | 93 | 1 |
685338 | 685338 | 2020-10-31 | Sullivan | New Hampshire | 33019 | 91 | 1 |
682095 | 682095 | 2020-10-30 | Sullivan | New Hampshire | 33019 | 86 | 1 |
678852 | 678852 | 2020-10-29 | Sullivan | New Hampshire | 33019 | 84 | 1 |
675609 | 675609 | 2020-10-28 | Sullivan | New Hampshire | 33019 | 81 | 1 |
672366 | 672366 | 2020-10-27 | Sullivan | New Hampshire | 33019 | 79 | 1 |
669124 | 669124 | 2020-10-26 | Sullivan | New Hampshire | 33019 | 77 | 1 |
665880 | 665880 | 2020-10-25 | Sullivan | New Hampshire | 33019 | 76 | 1 |
662635 | 662635 | 2020-10-24 | Sullivan | New Hampshire | 33019 | 75 | 1 |
659391 | 659391 | 2020-10-23 | Sullivan | New Hampshire | 33019 | 74 | 1 |
656147 | 656147 | 2020-10-22 | Sullivan | New Hampshire | 33019 | 72 | 1 |
652902 | 652902 | 2020-10-21 | Sullivan | New Hampshire | 33019 | 70 | 1 |
649657 | 649657 | 2020-10-20 | Sullivan | New Hampshire | 33019 | 68 | 1 |
646413 | 646413 | 2020-10-19 | Sullivan | New Hampshire | 33019 | 68 | 1 |
643167 | 643167 | 2020-10-18 | Sullivan | New Hampshire | 33019 | 69 | 1 |
639919 | 639919 | 2020-10-17 | Sullivan | New Hampshire | 33019 | 68 | 1 |
636673 | 636673 | 2020-10-16 | Sullivan | New Hampshire | 33019 | 67 | 1 |
633427 | 633427 | 2020-10-15 | Sullivan | New Hampshire | 33019 | 66 | 1 |
630182 | 630182 | 2020-10-14 | Sullivan | New Hampshire | 33019 | 65 | 1 |
626938 | 626938 | 2020-10-13 | Sullivan | New Hampshire | 33019 | 65 | 1 |
623696 | 623696 | 2020-10-12 | Sullivan | New Hampshire | 33019 | 65 | 1 |
620453 | 620453 | 2020-10-11 | Sullivan | New Hampshire | 33019 | 65 | 1 |
617211 | 617211 | 2020-10-10 | Sullivan | New Hampshire | 33019 | 65 | 1 |
613969 | 613969 | 2020-10-09 | Sullivan | New Hampshire | 33019 | 64 | 1 |
610728 | 610728 | 2020-10-08 | Sullivan | New Hampshire | 33019 | 63 | 1 |
607486 | 607486 | 2020-10-07 | Sullivan | New Hampshire | 33019 | 62 | 1 |
604243 | 604243 | 2020-10-06 | Sullivan | New Hampshire | 33019 | 62 | 1 |
601001 | 601001 | 2020-10-05 | Sullivan | New Hampshire | 33019 | 61 | 1 |
597757 | 597757 | 2020-10-04 | Sullivan | New Hampshire | 33019 | 59 | 1 |
594515 | 594515 | 2020-10-03 | Sullivan | New Hampshire | 33019 | 59 | 1 |
591274 | 591274 | 2020-10-02 | Sullivan | New Hampshire | 33019 | 59 | 1 |
588033 | 588033 | 2020-10-01 | Sullivan | New Hampshire | 33019 | 58 | 1 |
584793 | 584793 | 2020-09-30 | Sullivan | New Hampshire | 33019 | 58 | 1 |
581552 | 581552 | 2020-09-29 | Sullivan | New Hampshire | 33019 | 58 | 1 |
578311 | 578311 | 2020-09-28 | Sullivan | New Hampshire | 33019 | 57 | 1 |
575070 | 575070 | 2020-09-27 | Sullivan | New Hampshire | 33019 | 55 | 1 |
571827 | 571827 | 2020-09-26 | Sullivan | New Hampshire | 33019 | 54 | 1 |
568585 | 568585 | 2020-09-25 | Sullivan | New Hampshire | 33019 | 53 | 1 |
565344 | 565344 | 2020-09-24 | Sullivan | New Hampshire | 33019 | 53 | 1 |
562103 | 562103 | 2020-09-23 | Sullivan | New Hampshire | 33019 | 52 | 1 |
558866 | 558866 | 2020-09-22 | Sullivan | New Hampshire | 33019 | 52 | 1 |
555629 | 555629 | 2020-09-21 | Sullivan | New Hampshire | 33019 | 51 | 1 |
552391 | 552391 | 2020-09-20 | Sullivan | New Hampshire | 33019 | 51 | 1 |
549152 | 549152 | 2020-09-19 | Sullivan | New Hampshire | 33019 | 50 | 1 |
545914 | 545914 | 2020-09-18 | Sullivan | New Hampshire | 33019 | 50 | 1 |
542677 | 542677 | 2020-09-17 | Sullivan | New Hampshire | 33019 | 49 | 1 |
539441 | 539441 | 2020-09-16 | Sullivan | New Hampshire | 33019 | 49 | 1 |
536203 | 536203 | 2020-09-15 | Sullivan | New Hampshire | 33019 | 49 | 1 |
532968 | 532968 | 2020-09-14 | Sullivan | New Hampshire | 33019 | 49 | 1 |
529732 | 529732 | 2020-09-13 | Sullivan | New Hampshire | 33019 | 49 | 1 |
526496 | 526496 | 2020-09-12 | Sullivan | New Hampshire | 33019 | 49 | 1 |
523260 | 523260 | 2020-09-11 | Sullivan | New Hampshire | 33019 | 49 | 1 |
520023 | 520023 | 2020-09-10 | Sullivan | New Hampshire | 33019 | 49 | 1 |
516788 | 516788 | 2020-09-09 | Sullivan | New Hampshire | 33019 | 49 | 1 |
513554 | 513554 | 2020-09-08 | Sullivan | New Hampshire | 33019 | 48 | 1 |
510321 | 510321 | 2020-09-07 | Sullivan | New Hampshire | 33019 | 48 | 1 |
507088 | 507088 | 2020-09-06 | Sullivan | New Hampshire | 33019 | 48 | 1 |
503856 | 503856 | 2020-09-05 | Sullivan | New Hampshire | 33019 | 48 | 1 |
500622 | 500622 | 2020-09-04 | Sullivan | New Hampshire | 33019 | 48 | 1 |
497388 | 497388 | 2020-09-03 | Sullivan | New Hampshire | 33019 | 48 | 1 |
494155 | 494155 | 2020-09-02 | Sullivan | New Hampshire | 33019 | 48 | 1 |
490921 | 490921 | 2020-09-01 | Sullivan | New Hampshire | 33019 | 48 | 1 |
487688 | 487688 | 2020-08-31 | Sullivan | New Hampshire | 33019 | 48 | 1 |
484454 | 484454 | 2020-08-30 | Sullivan | New Hampshire | 33019 | 47 | 1 |
481219 | 481219 | 2020-08-29 | Sullivan | New Hampshire | 33019 | 47 | 1 |
477987 | 477987 | 2020-08-28 | Sullivan | New Hampshire | 33019 | 47 | 1 |
474754 | 474754 | 2020-08-27 | Sullivan | New Hampshire | 33019 | 47 | 1 |
471521 | 471521 | 2020-08-26 | Sullivan | New Hampshire | 33019 | 46 | 1 |
468289 | 468289 | 2020-08-25 | Sullivan | New Hampshire | 33019 | 46 | 1 |
465061 | 465061 | 2020-08-24 | Sullivan | New Hampshire | 33019 | 44 | 1 |
461830 | 461830 | 2020-08-23 | Sullivan | New Hampshire | 33019 | 44 | 1 |
458603 | 458603 | 2020-08-22 | Sullivan | New Hampshire | 33019 | 44 | 1 |
455375 | 455375 | 2020-08-21 | Sullivan | New Hampshire | 33019 | 44 | 1 |
452147 | 452147 | 2020-08-20 | Sullivan | New Hampshire | 33019 | 44 | 1 |
448919 | 448919 | 2020-08-19 | Sullivan | New Hampshire | 33019 | 44 | 1 |
445692 | 445692 | 2020-08-18 | Sullivan | New Hampshire | 33019 | 44 | 1 |
442466 | 442466 | 2020-08-17 | Sullivan | New Hampshire | 33019 | 44 | 1 |
439239 | 439239 | 2020-08-16 | Sullivan | New Hampshire | 33019 | 44 | 1 |
436014 | 436014 | 2020-08-15 | Sullivan | New Hampshire | 33019 | 43 | 1 |
432788 | 432788 | 2020-08-14 | Sullivan | New Hampshire | 33019 | 44 | 1 |
429561 | 429561 | 2020-08-13 | Sullivan | New Hampshire | 33019 | 44 | 1 |
426336 | 426336 | 2020-08-12 | Sullivan | New Hampshire | 33019 | 44 | 1 |
423114 | 423114 | 2020-08-11 | Sullivan | New Hampshire | 33019 | 41 | 1 |
419891 | 419891 | 2020-08-10 | Sullivan | New Hampshire | 33019 | 40 | 1 |
416670 | 416670 | 2020-08-09 | Sullivan | New Hampshire | 33019 | 40 | 1 |
413449 | 413449 | 2020-08-08 | Sullivan | New Hampshire | 33019 | 40 | 1 |
410229 | 410229 | 2020-08-07 | Sullivan | New Hampshire | 33019 | 40 | 1 |
407009 | 407009 | 2020-08-06 | Sullivan | New Hampshire | 33019 | 40 | 1 |
403790 | 403790 | 2020-08-05 | Sullivan | New Hampshire | 33019 | 40 | 1 |
400572 | 400572 | 2020-08-04 | Sullivan | New Hampshire | 33019 | 40 | 1 |
397357 | 397357 | 2020-08-03 | Sullivan | New Hampshire | 33019 | 40 | 1 |
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);