ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);