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 cases
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 |
---|---|---|---|---|---|---|---|
68918 | 68918 | 2020-04-18 | Unknown | New Hampshire | 0 | 1 | |
448 | 448 | 2020-03-02 | Grafton | New Hampshire | 33009 | 1 | 0 |
712 | 712 | 2020-03-07 | Rockingham | New Hampshire | 33015 | 1 | 0 |
816 | 816 | 2020-03-08 | Rockingham | New Hampshire | 33015 | 1 | 0 |
940 | 940 | 2020-03-09 | Rockingham | New Hampshire | 33015 | 1 | 0 |
2546 | 2546 | 2020-03-15 | Hillsborough | New Hampshire | 33011 | 1 | 0 |
3000 | 3000 | 2020-03-16 | Carroll | New Hampshire | 33003 | 1 | 0 |
3002 | 3002 | 2020-03-16 | Hillsborough | New Hampshire | 33011 | 1 | 0 |
3512 | 3512 | 2020-03-17 | Carroll | New Hampshire | 33003 | 1 | 0 |
4109 | 4109 | 2020-03-18 | Merrimack | New Hampshire | 33013 | 1 | 0 |
5675 | 5675 | 2020-03-20 | Cheshire | New Hampshire | 33005 | 1 | 0 |
6667 | 6667 | 2020-03-21 | Cheshire | New Hampshire | 33005 | 1 | 0 |
6672 | 6672 | 2020-03-21 | Strafford | New Hampshire | 33017 | 1 | 0 |
7757 | 7757 | 2020-03-22 | Cheshire | New Hampshire | 33005 | 1 | 0 |
7763 | 7763 | 2020-03-22 | Sullivan | New Hampshire | 33019 | 1 | 0 |
8953 | 8953 | 2020-03-23 | Cheshire | New Hampshire | 33005 | 1 | 0 |
8959 | 8959 | 2020-03-23 | Sullivan | New Hampshire | 33019 | 1 | 0 |
10257 | 10257 | 2020-03-24 | Cheshire | New Hampshire | 33005 | 1 | 0 |
10263 | 10263 | 2020-03-24 | Sullivan | New Hampshire | 33019 | 1 | 0 |
11689 | 11689 | 2020-03-25 | Cheshire | New Hampshire | 33005 | 1 | 0 |
11695 | 11695 | 2020-03-25 | Sullivan | New Hampshire | 33019 | 1 | 0 |
29712 | 29712 | 2020-04-03 | Coos | New Hampshire | 33007 | 1 | 0 |
32096 | 32096 | 2020-04-04 | Coos | New Hampshire | 33007 | 1 | 0 |
34527 | 34527 | 2020-04-05 | Coos | New Hampshire | 33007 | 1 | 0 |
36997 | 36997 | 2020-04-06 | Coos | New Hampshire | 33007 | 1 | 0 |
37004 | 37004 | 2020-04-06 | Unknown | New Hampshire | 1 | 0 | |
39512 | 39512 | 2020-04-07 | Coos | New Hampshire | 33007 | 1 | 0 |
39519 | 39519 | 2020-04-07 | Unknown | New Hampshire | 1 | 0 | |
42069 | 42069 | 2020-04-08 | Coos | New Hampshire | 33007 | 1 | 0 |
42076 | 42076 | 2020-04-08 | Unknown | New Hampshire | 1 | 0 | |
44652 | 44652 | 2020-04-09 | Coos | New Hampshire | 33007 | 1 | 0 |
49924 | 49924 | 2020-04-11 | Unknown | New Hampshire | 1 | 0 | |
52597 | 52597 | 2020-04-12 | Unknown | New Hampshire | 1 | 0 | |
55280 | 55280 | 2020-04-13 | Unknown | New Hampshire | 1 | 0 | |
57980 | 57980 | 2020-04-14 | Unknown | New Hampshire | 1 | 0 | |
63420 | 63420 | 2020-04-16 | Unknown | New Hampshire | 1 | 0 | |
251178 | 251178 | 2020-06-18 | Unknown | New Hampshire | 1 | 0 | |
254293 | 254293 | 2020-06-19 | Unknown | New Hampshire | 1 | 0 | |
257416 | 257416 | 2020-06-20 | Unknown | New Hampshire | 1 | 0 | |
266798 | 266798 | 2020-06-23 | Unknown | New Hampshire | 1 | 0 | |
285657 | 285657 | 2020-06-29 | Unknown | New Hampshire | 1 | 0 | |
288807 | 288807 | 2020-06-30 | Unknown | New Hampshire | 1 | 0 | |
291959 | 291959 | 2020-07-01 | Unknown | New Hampshire | 1 | 0 | |
295114 | 295114 | 2020-07-02 | Unknown | New Hampshire | 1 | 0 | |
301437 | 301437 | 2020-07-04 | Unknown | New Hampshire | 1 | 0 | |
310935 | 310935 | 2020-07-07 | Unknown | New Hampshire | 1 | 0 | |
314106 | 314106 | 2020-07-08 | Unknown | New Hampshire | 1 | 0 | |
317280 | 317280 | 2020-07-09 | Unknown | New Hampshire | 1 | 0 | |
387708 | 387708 | 2020-07-31 | Unknown | New Hampshire | 1 | 0 | |
397358 | 397358 | 2020-08-03 | Unknown | New Hampshire | 1 | 0 | |
426337 | 426337 | 2020-08-12 | Unknown | New Hampshire | 1 | 0 | |
523261 | 523261 | 2020-09-11 | Unknown | New Hampshire | 1 | 0 | |
526497 | 526497 | 2020-09-12 | Unknown | New Hampshire | 1 | 0 | |
536204 | 536204 | 2020-09-15 | Unknown | New Hampshire | 1 | 0 | |
482 | 482 | 2020-03-03 | Grafton | New Hampshire | 33009 | 2 | 0 |
517 | 517 | 2020-03-04 | Grafton | New Hampshire | 33009 | 2 | 0 |
563 | 563 | 2020-03-05 | Grafton | New Hampshire | 33009 | 2 | 0 |
624 | 624 | 2020-03-06 | Grafton | New Hampshire | 33009 | 2 | 0 |
1090 | 1090 | 2020-03-10 | Rockingham | New Hampshire | 33015 | 2 | 0 |
1272 | 1272 | 2020-03-11 | Rockingham | New Hampshire | 33015 | 2 | 0 |
4105 | 4105 | 2020-03-18 | Belknap | New Hampshire | 33001 | 2 | 0 |
4835 | 4835 | 2020-03-19 | Merrimack | New Hampshire | 33013 | 2 | 0 |
5678 | 5678 | 2020-03-20 | Merrimack | New Hampshire | 33013 | 2 | 0 |
13292 | 13292 | 2020-03-26 | Cheshire | New Hampshire | 33005 | 2 | 0 |
13298 | 13298 | 2020-03-26 | Sullivan | New Hampshire | 33019 | 2 | 0 |
15024 | 15024 | 2020-03-27 | Cheshire | New Hampshire | 33005 | 2 | 0 |
15030 | 15030 | 2020-03-27 | Sullivan | New Hampshire | 33019 | 2 | 0 |
16853 | 16853 | 2020-03-28 | Cheshire | New Hampshire | 33005 | 2 | 0 |
16859 | 16859 | 2020-03-28 | Sullivan | New Hampshire | 33019 | 2 | 0 |
47264 | 47264 | 2020-04-10 | Coos | New Hampshire | 33007 | 2 | 0 |
49917 | 49917 | 2020-04-11 | Coos | New Hampshire | 33007 | 2 | 0 |
52590 | 52590 | 2020-04-12 | Coos | New Hampshire | 33007 | 2 | 0 |
55273 | 55273 | 2020-04-13 | Coos | New Hampshire | 33007 | 2 | 0 |
57973 | 57973 | 2020-04-14 | Coos | New Hampshire | 33007 | 2 | 0 |
60688 | 60688 | 2020-04-15 | Coos | New Hampshire | 33007 | 2 | 0 |
63413 | 63413 | 2020-04-16 | Coos | New Hampshire | 33007 | 2 | 0 |
66155 | 66155 | 2020-04-17 | Coos | New Hampshire | 33007 | 2 | 0 |
66162 | 66162 | 2020-04-17 | Unknown | New Hampshire | 2 | 0 | |
68911 | 68911 | 2020-04-18 | Coos | New Hampshire | 33007 | 2 | 0 |
71678 | 71678 | 2020-04-19 | Coos | New Hampshire | 33007 | 2 | 0 |
71685 | 71685 | 2020-04-19 | Unknown | New Hampshire | 2 | 1 | |
74453 | 74453 | 2020-04-20 | Coos | New Hampshire | 33007 | 2 | 0 |
77234 | 77234 | 2020-04-21 | Coos | New Hampshire | 33007 | 2 | 0 |
80023 | 80023 | 2020-04-22 | Coos | New Hampshire | 33007 | 2 | 0 |
82821 | 82821 | 2020-04-23 | Coos | New Hampshire | 33007 | 2 | 0 |
85625 | 85625 | 2020-04-24 | Coos | New Hampshire | 33007 | 2 | 0 |
88436 | 88436 | 2020-04-25 | Coos | New Hampshire | 33007 | 2 | 0 |
91251 | 91251 | 2020-04-26 | Coos | New Hampshire | 33007 | 2 | 0 |
94075 | 94075 | 2020-04-27 | Coos | New Hampshire | 33007 | 2 | 0 |
96911 | 96911 | 2020-04-28 | Coos | New Hampshire | 33007 | 2 | 0 |
99758 | 99758 | 2020-04-29 | Coos | New Hampshire | 33007 | 2 | 0 |
102611 | 102611 | 2020-04-30 | Coos | New Hampshire | 33007 | 2 | 0 |
105473 | 105473 | 2020-05-01 | Coos | New Hampshire | 33007 | 2 | 0 |
108339 | 108339 | 2020-05-02 | Coos | New Hampshire | 33007 | 2 | 0 |
111212 | 111212 | 2020-05-03 | Coos | New Hampshire | 33007 | 2 | 0 |
114093 | 114093 | 2020-05-04 | Coos | New Hampshire | 33007 | 2 | 0 |
116974 | 116974 | 2020-05-05 | Coos | New Hampshire | 33007 | 2 | 0 |
119935 | 119935 | 2020-05-06 | Coos | New Hampshire | 33007 | 2 | 0 |
122910 | 122910 | 2020-05-07 | Coos | New Hampshire | 33007 | 2 | 0 |
125893 | 125893 | 2020-05-08 | Coos | New Hampshire | 33007 | 2 | 0 |
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);