ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
169 rows where deaths = 3 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 10
- Cheshire 119
- Merrimack 16
- Carroll 12
- Belknap 9
- Rockingham 4
- Coos 3
- Sullivan 3
- Grafton 1
- Hillsborough 1
- Strafford 1
state 1
- New Hampshire · 169 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
880028 | 880028 | 2020-12-30 | Carroll | New Hampshire | 33003 | 884 | 3 |
876783 | 876783 | 2020-12-29 | Carroll | New Hampshire | 33003 | 858 | 3 |
873538 | 873538 | 2020-12-28 | Carroll | New Hampshire | 33003 | 836 | 3 |
870293 | 870293 | 2020-12-27 | Carroll | New Hampshire | 33003 | 819 | 3 |
867048 | 867048 | 2020-12-26 | Carroll | New Hampshire | 33003 | 806 | 3 |
863803 | 863803 | 2020-12-25 | Carroll | New Hampshire | 33003 | 784 | 3 |
860558 | 860558 | 2020-12-24 | Carroll | New Hampshire | 33003 | 784 | 3 |
857313 | 857313 | 2020-12-23 | Carroll | New Hampshire | 33003 | 775 | 3 |
854068 | 854068 | 2020-12-22 | Carroll | New Hampshire | 33003 | 754 | 3 |
850823 | 850823 | 2020-12-21 | Carroll | New Hampshire | 33003 | 735 | 3 |
847578 | 847578 | 2020-12-20 | Carroll | New Hampshire | 33003 | 722 | 3 |
844332 | 844332 | 2020-12-19 | Carroll | New Hampshire | 33003 | 714 | 3 |
821613 | 821613 | 2020-12-12 | Grafton | New Hampshire | 33009 | 813 | 3 |
782670 | 782670 | 2020-11-30 | Cheshire | New Hampshire | 33005 | 559 | 3 |
779424 | 779424 | 2020-11-29 | Cheshire | New Hampshire | 33005 | 539 | 3 |
776179 | 776179 | 2020-11-28 | Cheshire | New Hampshire | 33005 | 517 | 3 |
772934 | 772934 | 2020-11-27 | Cheshire | New Hampshire | 33005 | 469 | 3 |
769689 | 769689 | 2020-11-26 | Cheshire | New Hampshire | 33005 | 469 | 3 |
766443 | 766443 | 2020-11-25 | Cheshire | New Hampshire | 33005 | 469 | 3 |
763198 | 763198 | 2020-11-24 | Cheshire | New Hampshire | 33005 | 455 | 3 |
759953 | 759953 | 2020-11-23 | Cheshire | New Hampshire | 33005 | 444 | 3 |
756707 | 756707 | 2020-11-22 | Cheshire | New Hampshire | 33005 | 432 | 3 |
753460 | 753460 | 2020-11-21 | Cheshire | New Hampshire | 33005 | 421 | 3 |
750214 | 750214 | 2020-11-20 | Cheshire | New Hampshire | 33005 | 405 | 3 |
746968 | 746968 | 2020-11-19 | Cheshire | New Hampshire | 33005 | 377 | 3 |
743722 | 743722 | 2020-11-18 | Cheshire | New Hampshire | 33005 | 371 | 3 |
740475 | 740475 | 2020-11-17 | Cheshire | New Hampshire | 33005 | 324 | 3 |
737230 | 737230 | 2020-11-16 | Cheshire | New Hampshire | 33005 | 341 | 3 |
733985 | 733985 | 2020-11-15 | Cheshire | New Hampshire | 33005 | 324 | 3 |
733986 | 733986 | 2020-11-15 | Coos | New Hampshire | 33007 | 230 | 3 |
730740 | 730740 | 2020-11-14 | Cheshire | New Hampshire | 33005 | 318 | 3 |
730741 | 730741 | 2020-11-14 | Coos | New Hampshire | 33007 | 225 | 3 |
727496 | 727496 | 2020-11-13 | Cheshire | New Hampshire | 33005 | 303 | 3 |
727497 | 727497 | 2020-11-13 | Coos | New Hampshire | 33007 | 219 | 3 |
727503 | 727503 | 2020-11-13 | Sullivan | New Hampshire | 33019 | 155 | 3 |
724252 | 724252 | 2020-11-12 | Cheshire | New Hampshire | 33005 | 288 | 3 |
724259 | 724259 | 2020-11-12 | Sullivan | New Hampshire | 33019 | 149 | 3 |
721009 | 721009 | 2020-11-11 | Cheshire | New Hampshire | 33005 | 283 | 3 |
721016 | 721016 | 2020-11-11 | Sullivan | New Hampshire | 33019 | 146 | 3 |
717766 | 717766 | 2020-11-10 | Cheshire | New Hampshire | 33005 | 274 | 3 |
714523 | 714523 | 2020-11-09 | Cheshire | New Hampshire | 33005 | 261 | 3 |
711279 | 711279 | 2020-11-08 | Cheshire | New Hampshire | 33005 | 256 | 3 |
708035 | 708035 | 2020-11-07 | Cheshire | New Hampshire | 33005 | 241 | 3 |
704792 | 704792 | 2020-11-06 | Cheshire | New Hampshire | 33005 | 232 | 3 |
701549 | 701549 | 2020-11-05 | Cheshire | New Hampshire | 33005 | 225 | 3 |
698305 | 698305 | 2020-11-04 | Cheshire | New Hampshire | 33005 | 220 | 3 |
695062 | 695062 | 2020-11-03 | Cheshire | New Hampshire | 33005 | 214 | 3 |
691820 | 691820 | 2020-11-02 | Cheshire | New Hampshire | 33005 | 209 | 3 |
688576 | 688576 | 2020-11-01 | Cheshire | New Hampshire | 33005 | 206 | 3 |
685331 | 685331 | 2020-10-31 | Cheshire | New Hampshire | 33005 | 206 | 3 |
682088 | 682088 | 2020-10-30 | Cheshire | New Hampshire | 33005 | 200 | 3 |
678845 | 678845 | 2020-10-29 | Cheshire | New Hampshire | 33005 | 195 | 3 |
675602 | 675602 | 2020-10-28 | Cheshire | New Hampshire | 33005 | 192 | 3 |
672359 | 672359 | 2020-10-27 | Cheshire | New Hampshire | 33005 | 192 | 3 |
669117 | 669117 | 2020-10-26 | Cheshire | New Hampshire | 33005 | 190 | 3 |
665873 | 665873 | 2020-10-25 | Cheshire | New Hampshire | 33005 | 182 | 3 |
662628 | 662628 | 2020-10-24 | Cheshire | New Hampshire | 33005 | 181 | 3 |
659384 | 659384 | 2020-10-23 | Cheshire | New Hampshire | 33005 | 180 | 3 |
656140 | 656140 | 2020-10-22 | Cheshire | New Hampshire | 33005 | 178 | 3 |
652895 | 652895 | 2020-10-21 | Cheshire | New Hampshire | 33005 | 176 | 3 |
649650 | 649650 | 2020-10-20 | Cheshire | New Hampshire | 33005 | 176 | 3 |
646406 | 646406 | 2020-10-19 | Cheshire | New Hampshire | 33005 | 174 | 3 |
643160 | 643160 | 2020-10-18 | Cheshire | New Hampshire | 33005 | 172 | 3 |
639912 | 639912 | 2020-10-17 | Cheshire | New Hampshire | 33005 | 171 | 3 |
636666 | 636666 | 2020-10-16 | Cheshire | New Hampshire | 33005 | 171 | 3 |
633420 | 633420 | 2020-10-15 | Cheshire | New Hampshire | 33005 | 167 | 3 |
630175 | 630175 | 2020-10-14 | Cheshire | New Hampshire | 33005 | 166 | 3 |
626931 | 626931 | 2020-10-13 | Cheshire | New Hampshire | 33005 | 162 | 3 |
623689 | 623689 | 2020-10-12 | Cheshire | New Hampshire | 33005 | 161 | 3 |
620446 | 620446 | 2020-10-11 | Cheshire | New Hampshire | 33005 | 159 | 3 |
617204 | 617204 | 2020-10-10 | Cheshire | New Hampshire | 33005 | 159 | 3 |
613962 | 613962 | 2020-10-09 | Cheshire | New Hampshire | 33005 | 159 | 3 |
610721 | 610721 | 2020-10-08 | Cheshire | New Hampshire | 33005 | 155 | 3 |
607479 | 607479 | 2020-10-07 | Cheshire | New Hampshire | 33005 | 156 | 3 |
604236 | 604236 | 2020-10-06 | Cheshire | New Hampshire | 33005 | 155 | 3 |
600994 | 600994 | 2020-10-05 | Cheshire | New Hampshire | 33005 | 155 | 3 |
597750 | 597750 | 2020-10-04 | Cheshire | New Hampshire | 33005 | 154 | 3 |
594508 | 594508 | 2020-10-03 | Cheshire | New Hampshire | 33005 | 154 | 3 |
591267 | 591267 | 2020-10-02 | Cheshire | New Hampshire | 33005 | 153 | 3 |
588026 | 588026 | 2020-10-01 | Cheshire | New Hampshire | 33005 | 152 | 3 |
584786 | 584786 | 2020-09-30 | Cheshire | New Hampshire | 33005 | 152 | 3 |
581545 | 581545 | 2020-09-29 | Cheshire | New Hampshire | 33005 | 151 | 3 |
578304 | 578304 | 2020-09-28 | Cheshire | New Hampshire | 33005 | 151 | 3 |
575063 | 575063 | 2020-09-27 | Cheshire | New Hampshire | 33005 | 148 | 3 |
571820 | 571820 | 2020-09-26 | Cheshire | New Hampshire | 33005 | 143 | 3 |
568578 | 568578 | 2020-09-25 | Cheshire | New Hampshire | 33005 | 143 | 3 |
565337 | 565337 | 2020-09-24 | Cheshire | New Hampshire | 33005 | 143 | 3 |
562096 | 562096 | 2020-09-23 | Cheshire | New Hampshire | 33005 | 143 | 3 |
558859 | 558859 | 2020-09-22 | Cheshire | New Hampshire | 33005 | 143 | 3 |
555622 | 555622 | 2020-09-21 | Cheshire | New Hampshire | 33005 | 142 | 3 |
552384 | 552384 | 2020-09-20 | Cheshire | New Hampshire | 33005 | 142 | 3 |
549145 | 549145 | 2020-09-19 | Cheshire | New Hampshire | 33005 | 142 | 3 |
545907 | 545907 | 2020-09-18 | Cheshire | New Hampshire | 33005 | 142 | 3 |
542670 | 542670 | 2020-09-17 | Cheshire | New Hampshire | 33005 | 142 | 3 |
539434 | 539434 | 2020-09-16 | Cheshire | New Hampshire | 33005 | 142 | 3 |
536196 | 536196 | 2020-09-15 | Cheshire | New Hampshire | 33005 | 142 | 3 |
532961 | 532961 | 2020-09-14 | Cheshire | New Hampshire | 33005 | 141 | 3 |
529725 | 529725 | 2020-09-13 | Cheshire | New Hampshire | 33005 | 141 | 3 |
526489 | 526489 | 2020-09-12 | Cheshire | New Hampshire | 33005 | 140 | 3 |
523253 | 523253 | 2020-09-11 | Cheshire | New Hampshire | 33005 | 140 | 3 |
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);