ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,612 rows where state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 588 ✖
- 0 825
- 1 732
- 2 306
- 13 253
- 4 172
- 3 169
- 5 135
- 26 126
- 6 124
- 100 114
- 19 103
- 23 94
- 27 91
- 25 89
- 35 87
- 30 79
- 36 77
- 45 69
- 116 67
- 9 65
- 110 65
- 33 64
- 22 62
- 29 62
- 68 62
- 7 61
- 41 61
- 101 61
- 14 58
- 67 56
- 18 55
- 105 55
- 76 54
- 21 52
- 28 52
- 113 51
- 111 49
- 31 45
- 20 44
- 15 43
- 55 43
- 96 42
- 11 40
- 47 40
- 17 39
- 24 38
- 38 38
- 39 38
- 8 37
- 12 37
- 34 37
- 56 37
- 66 37
- 103 36
- 32 35
- 94 35
- 42 34
- 40 33
- 90 33
- 16 32
- 53 32
- 61 30
- 93 30
- 109 30
- 59 29
- 92 29
- 112 29
- 647 29
- 37 28
- 43 28
- 49 26
- 95 26
- 99 26
- 104 26
- 121 26
- 98 25
- 131 25
- 46 24
- 60 24
- 97 24
- 117 24
- 204 24
- 229 24
- 52 23
- 57 23
- 10 22
- 51 22
- 87 22
- 173 22
- 288 22
- 64 21
- 102 21
- 107 21
- 118 21
- 115 20
- 48 19
- 63 19
- 79 19
- 91 19
- 62 18
- 82 18
- 175 18
- 206 18
- 69 17
- 205 17
- 44 16
- 54 16
- 124 16
- 149 16
- 266 16
- 648 16
- 75 15
- 129 15
- 270 15
- 279 15
- 89 14
- 106 14
- 126 14
- 133 14
- 143 14
- 144 14
- 155 14
- 168 14
- 170 14
- 172 14
- 224 14
- 262 14
- 286 14
- 72 13
- 138 13
- 303 13
- 209 12
- 655 12
- 70 11
- 83 11
- 84 11
- 85 11
- 108 11
- 125 11
- 127 11
- 159 11
- 211 11
- 221 11
- 289 11
- 536 11
- 81 10
- 156 10
- 177 10
- 202 10
- 203 10
- 207 10
- 610 10
- 652 10
- 894 10
- 910 10
- 50 9
- 77 9
- 114 9
- 134 9
- 160 9
- 174 9
- 176 9
- 180 9
- 259 9
- 524 9
- 641 9
- 65 8
- 74 8
- 88 8
- 122 8
- 123 8
- 130 8
- 132 8
- 142 8
- 161 8
- 192 8
- 222 8
- 263 8
- 274 8
- 278 8
- 325 8
- 331 8
- 582 8
- 650 8
- 86 7
- 153 7
- 158 7
- 163 7
- 185 7
- 196 7
- 218 7
- 223 7
- 227 7
- 228 7
- 265 7
- 268 7
- 269 7
- 292 7
- 311 7
- 405 7
- 502 7
- 531 7
- 537 7
- 623 7
- 659 7
- 913 7
- 146 6
- 162 6
- 194 6
- 198 6
- 199 6
- 216 6
- 230 6
- 261 6
- 267 6
- 330 6
- 520 6
- 643 6
- 662 6
- 665 6
- 668 6
- 676 6
- 905 6
- 73 5
- 78 5
- 120 5
- 135 5
- 164 5
- 167 5
- 191 5
- 201 5
- 215 5
- 240 5
- 242 5
- 253 5
- 254 5
- 272 5
- 273 5
- 281 5
- 284 5
- 287 5
- 291 5
- 297 5
- 315 5
- 323 5
- 328 5
- 333 5
- 355 5
- 495 5
- 506 5
- 575 5
- 605 5
- 649 5
- 677 5
- 714 5
- 863 5
- 58 4
- 128 4
- 145 4
- 150 4
- 165 4
- 169 4
- 171 4
- 184 4
- 208 4
- 220 4
- 226 4
- 234 4
- 264 4
- 280 4
- 282 4
- 285 4
- 314 4
- 327 4
- 343 4
- 361 4
- 376 4
- 433 4
- 486 4
- 510 4
- 516 4
- 530 4
- 535 4
- 590 4
- 614 4
- 644 4
- 646 4
- 663 4
- 690 4
- 723 4
- 748 4
- 767 4
- 784 4
- 800 4
- 838 4
- 853 4
- 872 4
- 880 4
- 890 4
- 892 4
- 71 3
- 119 3
- 137 3
- 140 3
- 141 3
- 147 3
- 157 3
- 188 3
- 190 3
- 210 3
- 250 3
- 260 3
- 283 3
- 302 3
- 322 3
- 329 3
- 348 3
- 367 3
- 386 3
- 418 3
- 422 3
- 450 3
- 467 3
- 476 3
- 514 3
- 542 3
- 569 3
- 595 3
- 617 3
- 627 3
- 635 3
- 645 3
- 654 3
- 657 3
- 670 3
- 671 3
- 697 3
- 705 3
- 731 3
- 740 3
- 816 3
- 828 3
- 886 3
- 903 3
- 80 2
- 136 2
- 139 2
- 151 2
- 154 2
- 166 2
- 178 2
- 179 2
- 187 2
- 189 2
- 195 2
- 200 2
- 213 2
- 214 2
- 238 2
- 241 2
- 246 2
- 247 2
- 249 2
- 251 2
- 257 2
- 271 2
- 276 2
- 277 2
- 294 2
- 296 2
- 307 2
- 310 2
- 312 2
- 317 2
- 318 2
- 344 2
- 426 2
- 435 2
- 445 2
- 452 2
- 458 2
- 472 2
- 473 2
- 477 2
- 479 2
- 493 2
- 503 2
- 508 2
- 519 2
- 522 2
- 523 2
- 546 2
- 559 2
- 570 2
- 574 2
- 583 2
- 584 2
- 592 2
- 608 2
- 611 2
- 613 2
- 616 2
- 625 2
- 632 2
- 651 2
- 664 2
- 695 2
- 738 2
- 783 2
- 786 2
- 861 2
- 884 2
- 887 2
- 889 2
- 891 2
- 908 2
- 916 2
- 148 1
- 152 1
- 181 1
- 182 1
- 183 1
- 193 1
- 212 1
- 217 1
- 225 1
- 231 1
- 232 1
- 233 1
- 235 1
- 237 1
- 243 1
- 248 1
- 252 1
- 255 1
- 256 1
- 275 1
- 295 1
- 298 1
- 301 1
- 304 1
- 306 1
- 308 1
- 313 1
- 319 1
- 337 1
- 338 1
- 339 1
- 340 1
- 341 1
- 346 1
- 350 1
- 352 1
- 354 1
- 357 1
- 360 1
- 363 1
- 364 1
- 369 1
- 371 1
- 373 1
- 374 1
- 375 1
- 379 1
- 384 1
- 389 1
- 396 1
- 398 1
- 403 1
- 408 1
- 409 1
- 410 1
- 413 1
- 416 1
- 417 1
- 423 1
- 434 1
- 440 1
- 441 1
- 447 1
- 461 1
- 462 1
- 464 1
- 468 1
- 480 1
- 481 1
- 483 1
- 484 1
- 485 1
- 488 1
- 492 1
- 494 1
- 501 1
- 504 1
- 505 1
- 507 1
- 509 1
- 511 1
- 517 1
- 527 1
- 539 1
- 540 1
- 541 1
- 548 1
- 552 1
- 555 1
- 558 1
- 560 1
- 561 1
- 565 1
- 566 1
- 576 1
- 580 1
- 581 1
- 587 1
- 593 1
- 594 1
- 596 1
- 602 1
- 603 1
- 604 1
- 609 1
- 615 1
- 620 1
- 626 1
- 633 1
- 640 1
- 667 1
- 672 1
- 674 1
- 675 1
- 685 1
- 686 1
- 687 1
- 689 1
- 693 1
- 698 1
- 699 1
- 701 1
- 704 1
- 710 1
- 712 1
- 716 1
- 720 1
- 721 1
- 725 1
- 727 1
- 728 1
- 729 1
- 733 1
- 736 1
- 742 1
- 745 1
- 747 1
- 757 1
- 761 1
- 765 1
- 771 1
- 785 1
- 793 1
- 803 1
- 807 1
- 813 1
- 817 1
- 819 1
- 820 1
- 827 1
- 829 1
- 831 1
- 833 1
- 844 1
- 848 1
- 851 1
- 852 1
- 858 1
- 870 1
- 871 1
- 873 1
- 877 1
- 883 1
- 885 1
- 893 1
- 904 1
- 906 1
- 907 1
- 911 1
- 912 1
- 914 1
fips 11
county 11
state 1
- New Hampshire · 8,612 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501361 | 2501361 | 2022-05-13 | Belknap | New Hampshire | 33001 | 14152 | 178 |
2501362 | 2501362 | 2022-05-13 | Carroll | New Hampshire | 33003 | 9865 | 62 |
2501363 | 2501363 | 2022-05-13 | Cheshire | New Hampshire | 33005 | 15674 | 112 |
2501364 | 2501364 | 2022-05-13 | Coos | New Hampshire | 33007 | 7140 | 113 |
2501365 | 2501365 | 2022-05-13 | Grafton | New Hampshire | 33009 | 19227 | 68 |
2501366 | 2501366 | 2022-05-13 | Hillsborough | New Hampshire | 33011 | 101728 | 916 |
2501367 | 2501367 | 2022-05-13 | Merrimack | New Hampshire | 33013 | 33415 | 230 |
2501368 | 2501368 | 2022-05-13 | Rockingham | New Hampshire | 33015 | 70405 | 542 |
2501369 | 2501369 | 2022-05-13 | Strafford | New Hampshire | 33017 | 30978 | 210 |
2501370 | 2501370 | 2022-05-13 | Sullivan | New Hampshire | 33019 | 9725 | 67 |
2501371 | 2501371 | 2022-05-13 | Unknown | New Hampshire | 4382 | 2 | |
2498103 | 2498103 | 2022-05-12 | Belknap | New Hampshire | 33001 | 14123 | 178 |
2498104 | 2498104 | 2022-05-12 | Carroll | New Hampshire | 33003 | 9844 | 62 |
2498105 | 2498105 | 2022-05-12 | Cheshire | New Hampshire | 33005 | 15654 | 112 |
2498106 | 2498106 | 2022-05-12 | Coos | New Hampshire | 33007 | 7136 | 113 |
2498107 | 2498107 | 2022-05-12 | Grafton | New Hampshire | 33009 | 19195 | 68 |
2498108 | 2498108 | 2022-05-12 | Hillsborough | New Hampshire | 33011 | 101546 | 916 |
2498109 | 2498109 | 2022-05-12 | Merrimack | New Hampshire | 33013 | 33364 | 230 |
2498110 | 2498110 | 2022-05-12 | Rockingham | New Hampshire | 33015 | 70216 | 541 |
2498111 | 2498111 | 2022-05-12 | Strafford | New Hampshire | 33017 | 30924 | 210 |
2498112 | 2498112 | 2022-05-12 | Sullivan | New Hampshire | 33019 | 9709 | 67 |
2498113 | 2498113 | 2022-05-12 | Unknown | New Hampshire | 4416 | 2 | |
2494845 | 2494845 | 2022-05-11 | Belknap | New Hampshire | 33001 | 14099 | 177 |
2494846 | 2494846 | 2022-05-11 | Carroll | New Hampshire | 33003 | 9815 | 61 |
2494847 | 2494847 | 2022-05-11 | Cheshire | New Hampshire | 33005 | 15599 | 112 |
2494848 | 2494848 | 2022-05-11 | Coos | New Hampshire | 33007 | 7134 | 113 |
2494849 | 2494849 | 2022-05-11 | Grafton | New Hampshire | 33009 | 19145 | 68 |
2494850 | 2494850 | 2022-05-11 | Hillsborough | New Hampshire | 33011 | 101372 | 914 |
2494851 | 2494851 | 2022-05-11 | Merrimack | New Hampshire | 33013 | 33294 | 230 |
2494852 | 2494852 | 2022-05-11 | Rockingham | New Hampshire | 33015 | 70065 | 540 |
2494853 | 2494853 | 2022-05-11 | Strafford | New Hampshire | 33017 | 30838 | 209 |
2494854 | 2494854 | 2022-05-11 | Sullivan | New Hampshire | 33019 | 9699 | 67 |
2494855 | 2494855 | 2022-05-11 | Unknown | New Hampshire | 4387 | 2 | |
2491587 | 2491587 | 2022-05-10 | Belknap | New Hampshire | 33001 | 14075 | 177 |
2491588 | 2491588 | 2022-05-10 | Carroll | New Hampshire | 33003 | 9798 | 61 |
2491589 | 2491589 | 2022-05-10 | Cheshire | New Hampshire | 33005 | 15549 | 112 |
2491590 | 2491590 | 2022-05-10 | Coos | New Hampshire | 33007 | 7122 | 113 |
2491591 | 2491591 | 2022-05-10 | Grafton | New Hampshire | 33009 | 19105 | 68 |
2491592 | 2491592 | 2022-05-10 | Hillsborough | New Hampshire | 33011 | 101206 | 913 |
2491593 | 2491593 | 2022-05-10 | Merrimack | New Hampshire | 33013 | 33235 | 230 |
2491594 | 2491594 | 2022-05-10 | Rockingham | New Hampshire | 33015 | 69905 | 539 |
2491595 | 2491595 | 2022-05-10 | Strafford | New Hampshire | 33017 | 30763 | 209 |
2491596 | 2491596 | 2022-05-10 | Sullivan | New Hampshire | 33019 | 9674 | 68 |
2491597 | 2491597 | 2022-05-10 | Unknown | New Hampshire | 4428 | 2 | |
2488329 | 2488329 | 2022-05-09 | Belknap | New Hampshire | 33001 | 14061 | 177 |
2488330 | 2488330 | 2022-05-09 | Carroll | New Hampshire | 33003 | 9784 | 61 |
2488331 | 2488331 | 2022-05-09 | Cheshire | New Hampshire | 33005 | 15536 | 112 |
2488332 | 2488332 | 2022-05-09 | Coos | New Hampshire | 33007 | 7114 | 113 |
2488333 | 2488333 | 2022-05-09 | Grafton | New Hampshire | 33009 | 19065 | 68 |
2488334 | 2488334 | 2022-05-09 | Hillsborough | New Hampshire | 33011 | 101099 | 913 |
2488335 | 2488335 | 2022-05-09 | Merrimack | New Hampshire | 33013 | 33210 | 230 |
2488336 | 2488336 | 2022-05-09 | Rockingham | New Hampshire | 33015 | 69805 | 537 |
2488337 | 2488337 | 2022-05-09 | Strafford | New Hampshire | 33017 | 30721 | 207 |
2488338 | 2488338 | 2022-05-09 | Sullivan | New Hampshire | 33019 | 9667 | 68 |
2488339 | 2488339 | 2022-05-09 | Unknown | New Hampshire | 4471 | 2 | |
2485072 | 2485072 | 2022-05-08 | Belknap | New Hampshire | 33001 | 13992 | 177 |
2485073 | 2485073 | 2022-05-08 | Carroll | New Hampshire | 33003 | 9719 | 61 |
2485074 | 2485074 | 2022-05-08 | Cheshire | New Hampshire | 33005 | 15444 | 112 |
2485075 | 2485075 | 2022-05-08 | Coos | New Hampshire | 33007 | 7080 | 113 |
2485076 | 2485076 | 2022-05-08 | Grafton | New Hampshire | 33009 | 18938 | 68 |
2485077 | 2485077 | 2022-05-08 | Hillsborough | New Hampshire | 33011 | 100570 | 913 |
2485078 | 2485078 | 2022-05-08 | Merrimack | New Hampshire | 33013 | 33036 | 229 |
2485079 | 2485079 | 2022-05-08 | Rockingham | New Hampshire | 33015 | 69365 | 537 |
2485080 | 2485080 | 2022-05-08 | Strafford | New Hampshire | 33017 | 30514 | 207 |
2485081 | 2485081 | 2022-05-08 | Sullivan | New Hampshire | 33019 | 9614 | 68 |
2485082 | 2485082 | 2022-05-08 | Unknown | New Hampshire | 5016 | 2 | |
2481814 | 2481814 | 2022-05-07 | Belknap | New Hampshire | 33001 | 13992 | 177 |
2481815 | 2481815 | 2022-05-07 | Carroll | New Hampshire | 33003 | 9719 | 61 |
2481816 | 2481816 | 2022-05-07 | Cheshire | New Hampshire | 33005 | 15444 | 112 |
2481817 | 2481817 | 2022-05-07 | Coos | New Hampshire | 33007 | 7080 | 113 |
2481818 | 2481818 | 2022-05-07 | Grafton | New Hampshire | 33009 | 18938 | 68 |
2481819 | 2481819 | 2022-05-07 | Hillsborough | New Hampshire | 33011 | 100570 | 913 |
2481820 | 2481820 | 2022-05-07 | Merrimack | New Hampshire | 33013 | 33036 | 229 |
2481821 | 2481821 | 2022-05-07 | Rockingham | New Hampshire | 33015 | 69365 | 537 |
2481822 | 2481822 | 2022-05-07 | Strafford | New Hampshire | 33017 | 30514 | 207 |
2481823 | 2481823 | 2022-05-07 | Sullivan | New Hampshire | 33019 | 9614 | 68 |
2481824 | 2481824 | 2022-05-07 | Unknown | New Hampshire | 5016 | 2 | |
2478556 | 2478556 | 2022-05-06 | Belknap | New Hampshire | 33001 | 13992 | 177 |
2478557 | 2478557 | 2022-05-06 | Carroll | New Hampshire | 33003 | 9719 | 61 |
2478558 | 2478558 | 2022-05-06 | Cheshire | New Hampshire | 33005 | 15444 | 112 |
2478559 | 2478559 | 2022-05-06 | Coos | New Hampshire | 33007 | 7080 | 113 |
2478560 | 2478560 | 2022-05-06 | Grafton | New Hampshire | 33009 | 18938 | 68 |
2478561 | 2478561 | 2022-05-06 | Hillsborough | New Hampshire | 33011 | 100570 | 913 |
2478562 | 2478562 | 2022-05-06 | Merrimack | New Hampshire | 33013 | 33036 | 229 |
2478563 | 2478563 | 2022-05-06 | Rockingham | New Hampshire | 33015 | 69365 | 537 |
2478564 | 2478564 | 2022-05-06 | Strafford | New Hampshire | 33017 | 30514 | 207 |
2478565 | 2478565 | 2022-05-06 | Sullivan | New Hampshire | 33019 | 9614 | 68 |
2478566 | 2478566 | 2022-05-06 | Unknown | New Hampshire | 5016 | 2 | |
2475298 | 2475298 | 2022-05-05 | Belknap | New Hampshire | 33001 | 13972 | 177 |
2475299 | 2475299 | 2022-05-05 | Carroll | New Hampshire | 33003 | 9691 | 61 |
2475300 | 2475300 | 2022-05-05 | Cheshire | New Hampshire | 33005 | 15402 | 112 |
2475301 | 2475301 | 2022-05-05 | Coos | New Hampshire | 33007 | 7074 | 113 |
2475302 | 2475302 | 2022-05-05 | Grafton | New Hampshire | 33009 | 18881 | 68 |
2475303 | 2475303 | 2022-05-05 | Hillsborough | New Hampshire | 33011 | 100390 | 913 |
2475304 | 2475304 | 2022-05-05 | Merrimack | New Hampshire | 33013 | 32963 | 229 |
2475305 | 2475305 | 2022-05-05 | Rockingham | New Hampshire | 33015 | 69231 | 537 |
2475306 | 2475306 | 2022-05-05 | Strafford | New Hampshire | 33017 | 30437 | 207 |
2475307 | 2475307 | 2022-05-05 | Sullivan | New Hampshire | 33019 | 9582 | 68 |
2475308 | 2475308 | 2022-05-05 | Unknown | New Hampshire | 5056 | 2 | |
2472041 | 2472041 | 2022-05-04 | Belknap | New Hampshire | 33001 | 13947 | 177 |
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);