ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
735 rows where county = "Unknown" and state = "New Hampshire" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
68918 | 68918 | 2020-04-18 | Unknown | New Hampshire | 0 | 1 | |
37004 | 37004 | 2020-04-06 | Unknown | New Hampshire | 1 | 0 | |
39519 | 39519 | 2020-04-07 | Unknown | New Hampshire | 1 | 0 | |
42076 | 42076 | 2020-04-08 | Unknown | New Hampshire | 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 | |
66162 | 66162 | 2020-04-17 | Unknown | New Hampshire | 2 | 0 | |
71685 | 71685 | 2020-04-19 | Unknown | New Hampshire | 2 | 1 | |
260542 | 260542 | 2020-06-21 | Unknown | New Hampshire | 2 | 0 | |
269933 | 269933 | 2020-06-24 | Unknown | New Hampshire | 2 | 0 | |
273072 | 273072 | 2020-06-25 | Unknown | New Hampshire | 2 | 0 | |
276217 | 276217 | 2020-06-26 | Unknown | New Hampshire | 2 | 0 | |
279365 | 279365 | 2020-06-27 | Unknown | New Hampshire | 2 | 0 | |
282512 | 282512 | 2020-06-28 | Unknown | New Hampshire | 2 | 0 | |
298274 | 298274 | 2020-07-03 | Unknown | New Hampshire | 2 | 0 | |
320456 | 320456 | 2020-07-10 | Unknown | New Hampshire | 2 | 0 | |
323636 | 323636 | 2020-07-11 | Unknown | New Hampshire | 2 | 0 | |
416671 | 416671 | 2020-08-09 | Unknown | New Hampshire | 2 | 0 | |
452148 | 452148 | 2020-08-20 | Unknown | New Hampshire | 2 | 0 | |
455376 | 455376 | 2020-08-21 | Unknown | New Hampshire | 2 | 0 | |
487689 | 487689 | 2020-08-31 | Unknown | New Hampshire | 2 | 0 | |
490922 | 490922 | 2020-09-01 | Unknown | New Hampshire | 2 | 0 | |
497389 | 497389 | 2020-09-03 | Unknown | New Hampshire | 2 | 0 | |
500623 | 500623 | 2020-09-04 | Unknown | New Hampshire | 2 | 0 | |
510322 | 510322 | 2020-09-07 | Unknown | New Hampshire | 2 | 0 | |
516789 | 516789 | 2020-09-09 | Unknown | New Hampshire | 2 | 0 | |
545915 | 545915 | 2020-09-18 | Unknown | New Hampshire | 2 | 0 | |
565345 | 565345 | 2020-09-24 | Unknown | New Hampshire | 2 | 0 | |
591275 | 591275 | 2020-10-02 | Unknown | New Hampshire | 2 | 0 | |
610729 | 610729 | 2020-10-08 | Unknown | New Hampshire | 2 | 0 | |
85632 | 85632 | 2020-04-24 | Unknown | New Hampshire | 3 | 1 | |
102618 | 102618 | 2020-04-30 | Unknown | New Hampshire | 3 | 0 | |
248063 | 248063 | 2020-06-17 | Unknown | New Hampshire | 3 | 0 | |
263671 | 263671 | 2020-06-22 | Unknown | New Hampshire | 3 | 0 | |
307767 | 307767 | 2020-07-06 | Unknown | New Hampshire | 3 | 0 | |
384491 | 384491 | 2020-07-30 | Unknown | New Hampshire | 3 | 0 | |
403791 | 403791 | 2020-08-05 | Unknown | New Hampshire | 3 | 0 | |
407010 | 407010 | 2020-08-06 | Unknown | New Hampshire | 3 | 0 | |
410230 | 410230 | 2020-08-07 | Unknown | New Hampshire | 3 | 0 | |
474755 | 474755 | 2020-08-27 | Unknown | New Hampshire | 3 | 0 | |
477988 | 477988 | 2020-08-28 | Unknown | New Hampshire | 3 | 0 | |
481220 | 481220 | 2020-08-29 | Unknown | New Hampshire | 3 | 0 | |
484455 | 484455 | 2020-08-30 | Unknown | New Hampshire | 3 | 0 | |
494156 | 494156 | 2020-09-02 | Unknown | New Hampshire | 3 | 0 | |
513555 | 513555 | 2020-09-08 | Unknown | New Hampshire | 3 | 0 | |
520024 | 520024 | 2020-09-10 | Unknown | New Hampshire | 3 | 0 | |
529733 | 529733 | 2020-09-13 | Unknown | New Hampshire | 3 | 0 | |
532969 | 532969 | 2020-09-14 | Unknown | New Hampshire | 3 | 0 | |
549153 | 549153 | 2020-09-19 | Unknown | New Hampshire | 3 | 0 | |
562104 | 562104 | 2020-09-23 | Unknown | New Hampshire | 3 | 0 | |
571828 | 571828 | 2020-09-26 | Unknown | New Hampshire | 3 | 0 | |
581553 | 581553 | 2020-09-29 | Unknown | New Hampshire | 3 | 0 | |
584794 | 584794 | 2020-09-30 | Unknown | New Hampshire | 3 | 0 | |
597758 | 597758 | 2020-10-04 | Unknown | New Hampshire | 3 | 0 | |
601002 | 601002 | 2020-10-05 | Unknown | New Hampshire | 3 | 0 | |
32103 | 32103 | 2020-04-04 | Unknown | New Hampshire | 4 | 0 | |
74460 | 74460 | 2020-04-20 | Unknown | New Hampshire | 4 | 1 | |
99765 | 99765 | 2020-04-29 | Unknown | New Hampshire | 4 | 1 | |
192390 | 192390 | 2020-05-30 | Unknown | New Hampshire | 4 | 0 | |
229411 | 229411 | 2020-06-11 | Unknown | New Hampshire | 4 | 0 | |
244950 | 244950 | 2020-06-16 | Unknown | New Hampshire | 4 | 0 | |
304600 | 304600 | 2020-07-05 | Unknown | New Hampshire | 4 | 0 | |
400573 | 400573 | 2020-08-04 | Unknown | New Hampshire | 4 | 0 | |
507089 | 507089 | 2020-09-06 | Unknown | New Hampshire | 4 | 0 | |
568586 | 568586 | 2020-09-25 | Unknown | New Hampshire | 4 | 0 | |
575071 | 575071 | 2020-09-27 | Unknown | New Hampshire | 4 | 0 | |
588034 | 588034 | 2020-10-01 | Unknown | New Hampshire | 4 | 0 | |
607487 | 607487 | 2020-10-07 | Unknown | New Hampshire | 4 | 0 | |
91258 | 91258 | 2020-04-26 | Unknown | New Hampshire | 5 | 1 | |
232516 | 232516 | 2020-06-12 | Unknown | New Hampshire | 5 | 0 | |
235621 | 235621 | 2020-06-13 | Unknown | New Hampshire | 5 | 0 | |
238728 | 238728 | 2020-06-14 | Unknown | New Hampshire | 5 | 0 | |
241838 | 241838 | 2020-06-15 | Unknown | New Hampshire | 5 | 0 | |
330007 | 330007 | 2020-07-13 | Unknown | New Hampshire | 5 | 0 | |
555630 | 555630 | 2020-09-21 | Unknown | New Hampshire | 5 | 0 | |
578312 | 578312 | 2020-09-28 | Unknown | New Hampshire | 5 | 0 | |
594516 | 594516 | 2020-10-03 | Unknown | New Hampshire | 5 | 0 | |
34534 | 34534 | 2020-04-05 | Unknown | New Hampshire | 6 | 0 | |
88443 | 88443 | 2020-04-25 | Unknown | New Hampshire | 6 | 1 |
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);