ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
825 rows where deaths = 0 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
931963 | 931963 | 2021-01-15 | Unknown | New Hampshire | 1001 | 0 | |
928718 | 928718 | 2021-01-14 | Unknown | New Hampshire | 1051 | 0 | |
925472 | 925472 | 2021-01-13 | Unknown | New Hampshire | 1066 | 0 | |
922227 | 922227 | 2021-01-12 | Unknown | New Hampshire | 1053 | 0 | |
918982 | 918982 | 2021-01-11 | Unknown | New Hampshire | 1020 | 0 | |
915737 | 915737 | 2021-01-10 | Unknown | New Hampshire | 988 | 0 | |
912492 | 912492 | 2021-01-09 | Unknown | New Hampshire | 973 | 0 | |
893019 | 893019 | 2021-01-03 | Unknown | New Hampshire | 902 | 0 | |
889773 | 889773 | 2021-01-02 | Unknown | New Hampshire | 903 | 0 | |
886527 | 886527 | 2021-01-01 | Unknown | New Hampshire | 883 | 0 | |
883282 | 883282 | 2020-12-31 | Unknown | New Hampshire | 883 | 0 | |
880037 | 880037 | 2020-12-30 | Unknown | New Hampshire | 863 | 0 | |
876792 | 876792 | 2020-12-29 | Unknown | New Hampshire | 860 | 0 | |
873547 | 873547 | 2020-12-28 | Unknown | New Hampshire | 805 | 0 | |
870302 | 870302 | 2020-12-27 | Unknown | New Hampshire | 762 | 0 | |
863812 | 863812 | 2020-12-25 | Unknown | New Hampshire | 660 | 0 | |
860567 | 860567 | 2020-12-24 | Unknown | New Hampshire | 660 | 0 | |
857322 | 857322 | 2020-12-23 | Unknown | New Hampshire | 687 | 0 | |
854077 | 854077 | 2020-12-22 | Unknown | New Hampshire | 733 | 0 | |
850832 | 850832 | 2020-12-21 | Unknown | New Hampshire | 708 | 0 | |
847587 | 847587 | 2020-12-20 | Unknown | New Hampshire | 683 | 0 | |
844341 | 844341 | 2020-12-19 | Unknown | New Hampshire | 658 | 0 | |
841096 | 841096 | 2020-12-18 | Unknown | New Hampshire | 648 | 0 | |
837851 | 837851 | 2020-12-17 | Unknown | New Hampshire | 605 | 0 | |
834605 | 834605 | 2020-12-16 | Unknown | New Hampshire | 627 | 0 | |
831358 | 831358 | 2020-12-15 | Unknown | New Hampshire | 638 | 0 | |
828112 | 828112 | 2020-12-14 | Unknown | New Hampshire | 617 | 0 | |
824865 | 824865 | 2020-12-13 | Unknown | New Hampshire | 570 | 0 | |
821619 | 821619 | 2020-12-12 | Unknown | New Hampshire | 563 | 0 | |
815127 | 815127 | 2020-12-10 | Unknown | New Hampshire | 503 | 0 | |
811882 | 811882 | 2020-12-09 | Unknown | New Hampshire | 488 | 0 | |
808637 | 808637 | 2020-12-08 | Unknown | New Hampshire | 485 | 0 | |
805392 | 805392 | 2020-12-07 | Unknown | New Hampshire | 467 | 0 | |
802147 | 802147 | 2020-12-06 | Unknown | New Hampshire | 406 | 0 | |
798902 | 798902 | 2020-12-05 | Unknown | New Hampshire | 420 | 0 | |
795657 | 795657 | 2020-12-04 | Unknown | New Hampshire | 413 | 0 | |
743730 | 743730 | 2020-11-18 | Unknown | New Hampshire | 223 | 0 | |
740483 | 740483 | 2020-11-17 | Unknown | New Hampshire | 237 | 0 | |
737238 | 737238 | 2020-11-16 | Unknown | New Hampshire | 186 | 0 | |
733993 | 733993 | 2020-11-15 | Unknown | New Hampshire | 181 | 0 | |
730748 | 730748 | 2020-11-14 | Unknown | New Hampshire | 162 | 0 | |
727504 | 727504 | 2020-11-13 | Unknown | New Hampshire | 136 | 0 | |
724260 | 724260 | 2020-11-12 | Unknown | New Hampshire | 106 | 0 | |
721017 | 721017 | 2020-11-11 | Unknown | New Hampshire | 104 | 0 | |
717767 | 717767 | 2020-11-10 | Coos | New Hampshire | 33007 | 174 | 0 |
717774 | 717774 | 2020-11-10 | Unknown | New Hampshire | 80 | 0 | |
714524 | 714524 | 2020-11-09 | Coos | New Hampshire | 33007 | 167 | 0 |
714531 | 714531 | 2020-11-09 | Unknown | New Hampshire | 79 | 0 | |
711280 | 711280 | 2020-11-08 | Coos | New Hampshire | 33007 | 162 | 0 |
711287 | 711287 | 2020-11-08 | Unknown | New Hampshire | 73 | 0 | |
708036 | 708036 | 2020-11-07 | Coos | New Hampshire | 33007 | 157 | 0 |
708043 | 708043 | 2020-11-07 | Unknown | New Hampshire | 62 | 0 | |
704793 | 704793 | 2020-11-06 | Coos | New Hampshire | 33007 | 147 | 0 |
704800 | 704800 | 2020-11-06 | Unknown | New Hampshire | 53 | 0 | |
701550 | 701550 | 2020-11-05 | Coos | New Hampshire | 33007 | 144 | 0 |
701557 | 701557 | 2020-11-05 | Unknown | New Hampshire | 44 | 0 | |
698306 | 698306 | 2020-11-04 | Coos | New Hampshire | 33007 | 127 | 0 |
698313 | 698313 | 2020-11-04 | Unknown | New Hampshire | 34 | 0 | |
695063 | 695063 | 2020-11-03 | Coos | New Hampshire | 33007 | 116 | 0 |
695070 | 695070 | 2020-11-03 | Unknown | New Hampshire | 36 | 0 | |
691821 | 691821 | 2020-11-02 | Coos | New Hampshire | 33007 | 98 | 0 |
691828 | 691828 | 2020-11-02 | Unknown | New Hampshire | 36 | 0 | |
688577 | 688577 | 2020-11-01 | Coos | New Hampshire | 33007 | 96 | 0 |
688584 | 688584 | 2020-11-01 | Unknown | New Hampshire | 36 | 0 | |
685332 | 685332 | 2020-10-31 | Coos | New Hampshire | 33007 | 85 | 0 |
685339 | 685339 | 2020-10-31 | Unknown | New Hampshire | 26 | 0 | |
682089 | 682089 | 2020-10-30 | Coos | New Hampshire | 33007 | 71 | 0 |
682096 | 682096 | 2020-10-30 | Unknown | New Hampshire | 20 | 0 | |
678846 | 678846 | 2020-10-29 | Coos | New Hampshire | 33007 | 64 | 0 |
678853 | 678853 | 2020-10-29 | Unknown | New Hampshire | 18 | 0 | |
675603 | 675603 | 2020-10-28 | Coos | New Hampshire | 33007 | 49 | 0 |
675610 | 675610 | 2020-10-28 | Unknown | New Hampshire | 18 | 0 | |
672360 | 672360 | 2020-10-27 | Coos | New Hampshire | 33007 | 43 | 0 |
672367 | 672367 | 2020-10-27 | Unknown | New Hampshire | 21 | 0 | |
669118 | 669118 | 2020-10-26 | Coos | New Hampshire | 33007 | 39 | 0 |
669125 | 669125 | 2020-10-26 | Unknown | New Hampshire | 16 | 0 | |
665874 | 665874 | 2020-10-25 | Coos | New Hampshire | 33007 | 39 | 0 |
665881 | 665881 | 2020-10-25 | Unknown | New Hampshire | 18 | 0 | |
662629 | 662629 | 2020-10-24 | Coos | New Hampshire | 33007 | 37 | 0 |
662636 | 662636 | 2020-10-24 | Unknown | New Hampshire | 16 | 0 | |
659385 | 659385 | 2020-10-23 | Coos | New Hampshire | 33007 | 37 | 0 |
659392 | 659392 | 2020-10-23 | Unknown | New Hampshire | 14 | 0 | |
656141 | 656141 | 2020-10-22 | Coos | New Hampshire | 33007 | 36 | 0 |
656148 | 656148 | 2020-10-22 | Unknown | New Hampshire | 15 | 0 | |
652896 | 652896 | 2020-10-21 | Coos | New Hampshire | 33007 | 34 | 0 |
652903 | 652903 | 2020-10-21 | Unknown | New Hampshire | 17 | 0 | |
649651 | 649651 | 2020-10-20 | Coos | New Hampshire | 33007 | 34 | 0 |
649658 | 649658 | 2020-10-20 | Unknown | New Hampshire | 13 | 0 | |
646407 | 646407 | 2020-10-19 | Coos | New Hampshire | 33007 | 34 | 0 |
646414 | 646414 | 2020-10-19 | Unknown | New Hampshire | 14 | 0 | |
643161 | 643161 | 2020-10-18 | Coos | New Hampshire | 33007 | 33 | 0 |
643168 | 643168 | 2020-10-18 | Unknown | New Hampshire | 14 | 0 | |
639913 | 639913 | 2020-10-17 | Coos | New Hampshire | 33007 | 31 | 0 |
639920 | 639920 | 2020-10-17 | Unknown | New Hampshire | 12 | 0 | |
636667 | 636667 | 2020-10-16 | Coos | New Hampshire | 33007 | 29 | 0 |
636674 | 636674 | 2020-10-16 | Unknown | New Hampshire | 6 | 0 | |
633421 | 633421 | 2020-10-15 | Coos | New Hampshire | 33007 | 28 | 0 |
633428 | 633428 | 2020-10-15 | Unknown | New Hampshire | 8 | 0 | |
630176 | 630176 | 2020-10-14 | Coos | New Hampshire | 33007 | 23 | 0 |
630183 | 630183 | 2020-10-14 | Unknown | New Hampshire | 8 | 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);