ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
196 rows where deaths = 1, fips = 33009 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 |
---|---|---|---|---|---|---|---|
724254 | 724254 | 2020-11-12 | Grafton | New Hampshire | 33009 | 351 | 1 |
721011 | 721011 | 2020-11-11 | Grafton | New Hampshire | 33009 | 342 | 1 |
717768 | 717768 | 2020-11-10 | Grafton | New Hampshire | 33009 | 333 | 1 |
714525 | 714525 | 2020-11-09 | Grafton | New Hampshire | 33009 | 324 | 1 |
711281 | 711281 | 2020-11-08 | Grafton | New Hampshire | 33009 | 316 | 1 |
708037 | 708037 | 2020-11-07 | Grafton | New Hampshire | 33009 | 302 | 1 |
704794 | 704794 | 2020-11-06 | Grafton | New Hampshire | 33009 | 294 | 1 |
701551 | 701551 | 2020-11-05 | Grafton | New Hampshire | 33009 | 282 | 1 |
698307 | 698307 | 2020-11-04 | Grafton | New Hampshire | 33009 | 277 | 1 |
695064 | 695064 | 2020-11-03 | Grafton | New Hampshire | 33009 | 269 | 1 |
691822 | 691822 | 2020-11-02 | Grafton | New Hampshire | 33009 | 264 | 1 |
688578 | 688578 | 2020-11-01 | Grafton | New Hampshire | 33009 | 255 | 1 |
685333 | 685333 | 2020-10-31 | Grafton | New Hampshire | 33009 | 245 | 1 |
682090 | 682090 | 2020-10-30 | Grafton | New Hampshire | 33009 | 236 | 1 |
678847 | 678847 | 2020-10-29 | Grafton | New Hampshire | 33009 | 230 | 1 |
675604 | 675604 | 2020-10-28 | Grafton | New Hampshire | 33009 | 212 | 1 |
672361 | 672361 | 2020-10-27 | Grafton | New Hampshire | 33009 | 207 | 1 |
669119 | 669119 | 2020-10-26 | Grafton | New Hampshire | 33009 | 199 | 1 |
665875 | 665875 | 2020-10-25 | Grafton | New Hampshire | 33009 | 196 | 1 |
662630 | 662630 | 2020-10-24 | Grafton | New Hampshire | 33009 | 194 | 1 |
659386 | 659386 | 2020-10-23 | Grafton | New Hampshire | 33009 | 191 | 1 |
656142 | 656142 | 2020-10-22 | Grafton | New Hampshire | 33009 | 189 | 1 |
652897 | 652897 | 2020-10-21 | Grafton | New Hampshire | 33009 | 187 | 1 |
649652 | 649652 | 2020-10-20 | Grafton | New Hampshire | 33009 | 185 | 1 |
646408 | 646408 | 2020-10-19 | Grafton | New Hampshire | 33009 | 183 | 1 |
643162 | 643162 | 2020-10-18 | Grafton | New Hampshire | 33009 | 181 | 1 |
639914 | 639914 | 2020-10-17 | Grafton | New Hampshire | 33009 | 180 | 1 |
636668 | 636668 | 2020-10-16 | Grafton | New Hampshire | 33009 | 176 | 1 |
633422 | 633422 | 2020-10-15 | Grafton | New Hampshire | 33009 | 174 | 1 |
630177 | 630177 | 2020-10-14 | Grafton | New Hampshire | 33009 | 172 | 1 |
626933 | 626933 | 2020-10-13 | Grafton | New Hampshire | 33009 | 170 | 1 |
623691 | 623691 | 2020-10-12 | Grafton | New Hampshire | 33009 | 169 | 1 |
620448 | 620448 | 2020-10-11 | Grafton | New Hampshire | 33009 | 165 | 1 |
617206 | 617206 | 2020-10-10 | Grafton | New Hampshire | 33009 | 164 | 1 |
613964 | 613964 | 2020-10-09 | Grafton | New Hampshire | 33009 | 159 | 1 |
610723 | 610723 | 2020-10-08 | Grafton | New Hampshire | 33009 | 157 | 1 |
607481 | 607481 | 2020-10-07 | Grafton | New Hampshire | 33009 | 156 | 1 |
604238 | 604238 | 2020-10-06 | Grafton | New Hampshire | 33009 | 156 | 1 |
600996 | 600996 | 2020-10-05 | Grafton | New Hampshire | 33009 | 155 | 1 |
597752 | 597752 | 2020-10-04 | Grafton | New Hampshire | 33009 | 155 | 1 |
594510 | 594510 | 2020-10-03 | Grafton | New Hampshire | 33009 | 154 | 1 |
591269 | 591269 | 2020-10-02 | Grafton | New Hampshire | 33009 | 152 | 1 |
588028 | 588028 | 2020-10-01 | Grafton | New Hampshire | 33009 | 145 | 1 |
584788 | 584788 | 2020-09-30 | Grafton | New Hampshire | 33009 | 144 | 1 |
581547 | 581547 | 2020-09-29 | Grafton | New Hampshire | 33009 | 142 | 1 |
578306 | 578306 | 2020-09-28 | Grafton | New Hampshire | 33009 | 142 | 1 |
575065 | 575065 | 2020-09-27 | Grafton | New Hampshire | 33009 | 141 | 1 |
571822 | 571822 | 2020-09-26 | Grafton | New Hampshire | 33009 | 138 | 1 |
568580 | 568580 | 2020-09-25 | Grafton | New Hampshire | 33009 | 138 | 1 |
565339 | 565339 | 2020-09-24 | Grafton | New Hampshire | 33009 | 138 | 1 |
562098 | 562098 | 2020-09-23 | Grafton | New Hampshire | 33009 | 137 | 1 |
558861 | 558861 | 2020-09-22 | Grafton | New Hampshire | 33009 | 137 | 1 |
555624 | 555624 | 2020-09-21 | Grafton | New Hampshire | 33009 | 134 | 1 |
552386 | 552386 | 2020-09-20 | Grafton | New Hampshire | 33009 | 134 | 1 |
549147 | 549147 | 2020-09-19 | Grafton | New Hampshire | 33009 | 132 | 1 |
545909 | 545909 | 2020-09-18 | Grafton | New Hampshire | 33009 | 131 | 1 |
542672 | 542672 | 2020-09-17 | Grafton | New Hampshire | 33009 | 130 | 1 |
539436 | 539436 | 2020-09-16 | Grafton | New Hampshire | 33009 | 130 | 1 |
536198 | 536198 | 2020-09-15 | Grafton | New Hampshire | 33009 | 129 | 1 |
532963 | 532963 | 2020-09-14 | Grafton | New Hampshire | 33009 | 128 | 1 |
529727 | 529727 | 2020-09-13 | Grafton | New Hampshire | 33009 | 127 | 1 |
526491 | 526491 | 2020-09-12 | Grafton | New Hampshire | 33009 | 126 | 1 |
523255 | 523255 | 2020-09-11 | Grafton | New Hampshire | 33009 | 126 | 1 |
520018 | 520018 | 2020-09-10 | Grafton | New Hampshire | 33009 | 125 | 1 |
516783 | 516783 | 2020-09-09 | Grafton | New Hampshire | 33009 | 123 | 1 |
513549 | 513549 | 2020-09-08 | Grafton | New Hampshire | 33009 | 122 | 1 |
510316 | 510316 | 2020-09-07 | Grafton | New Hampshire | 33009 | 120 | 1 |
507083 | 507083 | 2020-09-06 | Grafton | New Hampshire | 33009 | 118 | 1 |
503851 | 503851 | 2020-09-05 | Grafton | New Hampshire | 33009 | 118 | 1 |
500617 | 500617 | 2020-09-04 | Grafton | New Hampshire | 33009 | 115 | 1 |
497383 | 497383 | 2020-09-03 | Grafton | New Hampshire | 33009 | 114 | 1 |
494150 | 494150 | 2020-09-02 | Grafton | New Hampshire | 33009 | 114 | 1 |
490916 | 490916 | 2020-09-01 | Grafton | New Hampshire | 33009 | 114 | 1 |
487683 | 487683 | 2020-08-31 | Grafton | New Hampshire | 33009 | 114 | 1 |
484449 | 484449 | 2020-08-30 | Grafton | New Hampshire | 33009 | 113 | 1 |
481214 | 481214 | 2020-08-29 | Grafton | New Hampshire | 33009 | 113 | 1 |
477982 | 477982 | 2020-08-28 | Grafton | New Hampshire | 33009 | 113 | 1 |
474749 | 474749 | 2020-08-27 | Grafton | New Hampshire | 33009 | 112 | 1 |
471516 | 471516 | 2020-08-26 | Grafton | New Hampshire | 33009 | 110 | 1 |
468284 | 468284 | 2020-08-25 | Grafton | New Hampshire | 33009 | 109 | 1 |
465056 | 465056 | 2020-08-24 | Grafton | New Hampshire | 33009 | 109 | 1 |
461825 | 461825 | 2020-08-23 | Grafton | New Hampshire | 33009 | 109 | 1 |
458598 | 458598 | 2020-08-22 | Grafton | New Hampshire | 33009 | 109 | 1 |
455370 | 455370 | 2020-08-21 | Grafton | New Hampshire | 33009 | 107 | 1 |
452142 | 452142 | 2020-08-20 | Grafton | New Hampshire | 33009 | 107 | 1 |
448914 | 448914 | 2020-08-19 | Grafton | New Hampshire | 33009 | 107 | 1 |
445687 | 445687 | 2020-08-18 | Grafton | New Hampshire | 33009 | 107 | 1 |
442461 | 442461 | 2020-08-17 | Grafton | New Hampshire | 33009 | 107 | 1 |
439234 | 439234 | 2020-08-16 | Grafton | New Hampshire | 33009 | 107 | 1 |
436009 | 436009 | 2020-08-15 | Grafton | New Hampshire | 33009 | 107 | 1 |
432783 | 432783 | 2020-08-14 | Grafton | New Hampshire | 33009 | 106 | 1 |
429556 | 429556 | 2020-08-13 | Grafton | New Hampshire | 33009 | 105 | 1 |
426331 | 426331 | 2020-08-12 | Grafton | New Hampshire | 33009 | 105 | 1 |
423109 | 423109 | 2020-08-11 | Grafton | New Hampshire | 33009 | 104 | 1 |
419886 | 419886 | 2020-08-10 | Grafton | New Hampshire | 33009 | 103 | 1 |
416665 | 416665 | 2020-08-09 | Grafton | New Hampshire | 33009 | 103 | 1 |
413444 | 413444 | 2020-08-08 | Grafton | New Hampshire | 33009 | 103 | 1 |
410224 | 410224 | 2020-08-07 | Grafton | New Hampshire | 33009 | 103 | 1 |
407004 | 407004 | 2020-08-06 | Grafton | New Hampshire | 33009 | 103 | 1 |
403785 | 403785 | 2020-08-05 | Grafton | New Hampshire | 33009 | 103 | 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);