ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
306 rows where deaths = 2 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
county 10
- Cheshire 117
- Carroll 97
- Unknown 39
- Grafton 29
- Belknap 6
- Hillsborough 6
- Merrimack 6
- Rockingham 4
- Coos 1
- Strafford 1
state 1
- New Hampshire · 306 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501371 | 2501371 | 2022-05-13 | Unknown | New Hampshire | 4382 | 2 | |
2498113 | 2498113 | 2022-05-12 | Unknown | New Hampshire | 4416 | 2 | |
2494855 | 2494855 | 2022-05-11 | Unknown | New Hampshire | 4387 | 2 | |
2491597 | 2491597 | 2022-05-10 | Unknown | New Hampshire | 4428 | 2 | |
2488339 | 2488339 | 2022-05-09 | Unknown | New Hampshire | 4471 | 2 | |
2485082 | 2485082 | 2022-05-08 | Unknown | New Hampshire | 5016 | 2 | |
2481824 | 2481824 | 2022-05-07 | Unknown | New Hampshire | 5016 | 2 | |
2478566 | 2478566 | 2022-05-06 | Unknown | New Hampshire | 5016 | 2 | |
2475308 | 2475308 | 2022-05-05 | Unknown | New Hampshire | 5056 | 2 | |
2472051 | 2472051 | 2022-05-04 | Unknown | New Hampshire | 5109 | 2 | |
2468795 | 2468795 | 2022-05-03 | Unknown | New Hampshire | 5148 | 2 | |
2465539 | 2465539 | 2022-05-02 | Unknown | New Hampshire | 5165 | 2 | |
2462284 | 2462284 | 2022-05-01 | Unknown | New Hampshire | 5137 | 2 | |
2459028 | 2459028 | 2022-04-30 | Unknown | New Hampshire | 5137 | 2 | |
2455772 | 2455772 | 2022-04-29 | Unknown | New Hampshire | 5137 | 2 | |
2452516 | 2452516 | 2022-04-28 | Unknown | New Hampshire | 5154 | 2 | |
2449260 | 2449260 | 2022-04-27 | Unknown | New Hampshire | 5182 | 2 | |
2446003 | 2446003 | 2022-04-26 | Unknown | New Hampshire | 5160 | 2 | |
2442748 | 2442748 | 2022-04-25 | Unknown | New Hampshire | 5147 | 2 | |
2439492 | 2439492 | 2022-04-24 | Unknown | New Hampshire | 5893 | 2 | |
2436236 | 2436236 | 2022-04-23 | Unknown | New Hampshire | 5893 | 2 | |
2432980 | 2432980 | 2022-04-22 | Unknown | New Hampshire | 5893 | 2 | |
2429724 | 2429724 | 2022-04-21 | Unknown | New Hampshire | 5862 | 2 | |
2423212 | 2423212 | 2022-04-19 | Unknown | New Hampshire | 5867 | 2 | |
2419955 | 2419955 | 2022-04-18 | Unknown | New Hampshire | 5930 | 2 | |
2416700 | 2416700 | 2022-04-17 | Unknown | New Hampshire | 5910 | 2 | |
2413444 | 2413444 | 2022-04-16 | Unknown | New Hampshire | 5910 | 2 | |
2410188 | 2410188 | 2022-04-15 | Unknown | New Hampshire | 5910 | 2 | |
2406932 | 2406932 | 2022-04-14 | Unknown | New Hampshire | 5885 | 2 | |
2403676 | 2403676 | 2022-04-13 | Unknown | New Hampshire | 6075 | 2 | |
2400421 | 2400421 | 2022-04-12 | Unknown | New Hampshire | 6117 | 2 | |
2397166 | 2397166 | 2022-04-11 | Unknown | New Hampshire | 6548 | 2 | |
2393911 | 2393911 | 2022-04-10 | Unknown | New Hampshire | 6638 | 2 | |
2390655 | 2390655 | 2022-04-09 | Unknown | New Hampshire | 6638 | 2 | |
2387399 | 2387399 | 2022-04-08 | Unknown | New Hampshire | 6638 | 2 | |
1880140 | 1880140 | 2021-11-03 | Unknown | New Hampshire | 784 | 2 | |
1876891 | 1876891 | 2021-11-02 | Unknown | New Hampshire | 775 | 2 | |
1873642 | 1873642 | 2021-11-01 | Unknown | New Hampshire | 748 | 2 | |
980642 | 980642 | 2021-01-30 | Unknown | New Hampshire | 1042 | 2 | |
841087 | 841087 | 2020-12-18 | Carroll | New Hampshire | 33003 | 701 | 2 |
837842 | 837842 | 2020-12-17 | Carroll | New Hampshire | 33003 | 693 | 2 |
834596 | 834596 | 2020-12-16 | Carroll | New Hampshire | 33003 | 673 | 2 |
831349 | 831349 | 2020-12-15 | Carroll | New Hampshire | 33003 | 651 | 2 |
828103 | 828103 | 2020-12-14 | Carroll | New Hampshire | 33003 | 631 | 2 |
824856 | 824856 | 2020-12-13 | Carroll | New Hampshire | 33003 | 609 | 2 |
821610 | 821610 | 2020-12-12 | Carroll | New Hampshire | 33003 | 591 | 2 |
818364 | 818364 | 2020-12-11 | Carroll | New Hampshire | 33003 | 573 | 2 |
818367 | 818367 | 2020-12-11 | Grafton | New Hampshire | 33009 | 793 | 2 |
815118 | 815118 | 2020-12-10 | Carroll | New Hampshire | 33003 | 560 | 2 |
815121 | 815121 | 2020-12-10 | Grafton | New Hampshire | 33009 | 753 | 2 |
811873 | 811873 | 2020-12-09 | Carroll | New Hampshire | 33003 | 545 | 2 |
811876 | 811876 | 2020-12-09 | Grafton | New Hampshire | 33009 | 733 | 2 |
808628 | 808628 | 2020-12-08 | Carroll | New Hampshire | 33003 | 528 | 2 |
808631 | 808631 | 2020-12-08 | Grafton | New Hampshire | 33009 | 711 | 2 |
805383 | 805383 | 2020-12-07 | Carroll | New Hampshire | 33003 | 513 | 2 |
805386 | 805386 | 2020-12-07 | Grafton | New Hampshire | 33009 | 691 | 2 |
802138 | 802138 | 2020-12-06 | Carroll | New Hampshire | 33003 | 500 | 2 |
802141 | 802141 | 2020-12-06 | Grafton | New Hampshire | 33009 | 650 | 2 |
798893 | 798893 | 2020-12-05 | Carroll | New Hampshire | 33003 | 483 | 2 |
798896 | 798896 | 2020-12-05 | Grafton | New Hampshire | 33009 | 637 | 2 |
795648 | 795648 | 2020-12-04 | Carroll | New Hampshire | 33003 | 462 | 2 |
795651 | 795651 | 2020-12-04 | Grafton | New Hampshire | 33009 | 624 | 2 |
792403 | 792403 | 2020-12-03 | Carroll | New Hampshire | 33003 | 441 | 2 |
792406 | 792406 | 2020-12-03 | Grafton | New Hampshire | 33009 | 614 | 2 |
789158 | 789158 | 2020-12-02 | Carroll | New Hampshire | 33003 | 423 | 2 |
789161 | 789161 | 2020-12-02 | Grafton | New Hampshire | 33009 | 589 | 2 |
785913 | 785913 | 2020-12-01 | Carroll | New Hampshire | 33003 | 401 | 2 |
785916 | 785916 | 2020-12-01 | Grafton | New Hampshire | 33009 | 553 | 2 |
782669 | 782669 | 2020-11-30 | Carroll | New Hampshire | 33003 | 385 | 2 |
782672 | 782672 | 2020-11-30 | Grafton | New Hampshire | 33009 | 543 | 2 |
779423 | 779423 | 2020-11-29 | Carroll | New Hampshire | 33003 | 375 | 2 |
779426 | 779426 | 2020-11-29 | Grafton | New Hampshire | 33009 | 534 | 2 |
776178 | 776178 | 2020-11-28 | Carroll | New Hampshire | 33003 | 342 | 2 |
776181 | 776181 | 2020-11-28 | Grafton | New Hampshire | 33009 | 523 | 2 |
772933 | 772933 | 2020-11-27 | Carroll | New Hampshire | 33003 | 327 | 2 |
772936 | 772936 | 2020-11-27 | Grafton | New Hampshire | 33009 | 508 | 2 |
769688 | 769688 | 2020-11-26 | Carroll | New Hampshire | 33003 | 327 | 2 |
769691 | 769691 | 2020-11-26 | Grafton | New Hampshire | 33009 | 496 | 2 |
766442 | 766442 | 2020-11-25 | Carroll | New Hampshire | 33003 | 327 | 2 |
766445 | 766445 | 2020-11-25 | Grafton | New Hampshire | 33009 | 496 | 2 |
763197 | 763197 | 2020-11-24 | Carroll | New Hampshire | 33003 | 321 | 2 |
763200 | 763200 | 2020-11-24 | Grafton | New Hampshire | 33009 | 489 | 2 |
759952 | 759952 | 2020-11-23 | Carroll | New Hampshire | 33003 | 312 | 2 |
759955 | 759955 | 2020-11-23 | Grafton | New Hampshire | 33009 | 486 | 2 |
756706 | 756706 | 2020-11-22 | Carroll | New Hampshire | 33003 | 301 | 2 |
756709 | 756709 | 2020-11-22 | Grafton | New Hampshire | 33009 | 475 | 2 |
753459 | 753459 | 2020-11-21 | Carroll | New Hampshire | 33003 | 293 | 2 |
753462 | 753462 | 2020-11-21 | Grafton | New Hampshire | 33009 | 463 | 2 |
750213 | 750213 | 2020-11-20 | Carroll | New Hampshire | 33003 | 287 | 2 |
750216 | 750216 | 2020-11-20 | Grafton | New Hampshire | 33009 | 453 | 2 |
746967 | 746967 | 2020-11-19 | Carroll | New Hampshire | 33003 | 263 | 2 |
746970 | 746970 | 2020-11-19 | Grafton | New Hampshire | 33009 | 445 | 2 |
743721 | 743721 | 2020-11-18 | Carroll | New Hampshire | 33003 | 256 | 2 |
743724 | 743724 | 2020-11-18 | Grafton | New Hampshire | 33009 | 430 | 2 |
740474 | 740474 | 2020-11-17 | Carroll | New Hampshire | 33003 | 251 | 2 |
740477 | 740477 | 2020-11-17 | Grafton | New Hampshire | 33009 | 419 | 2 |
737229 | 737229 | 2020-11-16 | Carroll | New Hampshire | 33003 | 241 | 2 |
737232 | 737232 | 2020-11-16 | Grafton | New Hampshire | 33009 | 407 | 2 |
733984 | 733984 | 2020-11-15 | Carroll | New Hampshire | 33003 | 232 | 2 |
733987 | 733987 | 2020-11-15 | Grafton | New Hampshire | 33009 | 399 | 2 |
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);