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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 | |
909247 | 909247 | 2021-01-08 | Unknown | New Hampshire | 1001 | 1 | |
906001 | 906001 | 2021-01-07 | Unknown | New Hampshire | 997 | 1 | |
902756 | 902756 | 2021-01-06 | Unknown | New Hampshire | 1000 | 1 | |
899511 | 899511 | 2021-01-05 | Unknown | New Hampshire | 979 | 1 | |
896266 | 896266 | 2021-01-04 | Unknown | New Hampshire | 962 | 1 | |
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 | |
867057 | 867057 | 2020-12-26 | Unknown | New Hampshire | 732 | 1 | |
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 | |
818373 | 818373 | 2020-12-11 | Unknown | New Hampshire | 536 | 1 | |
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 | |
792412 | 792412 | 2020-12-03 | Unknown | New Hampshire | 442 | 1 | |
789167 | 789167 | 2020-12-02 | Unknown | New Hampshire | 467 | 1 | |
785922 | 785922 | 2020-12-01 | Unknown | New Hampshire | 431 | 1 | |
782678 | 782678 | 2020-11-30 | Unknown | New Hampshire | 393 | 1 | |
779432 | 779432 | 2020-11-29 | Unknown | New Hampshire | 379 | 1 | |
776187 | 776187 | 2020-11-28 | Unknown | New Hampshire | 385 | 1 | |
772942 | 772942 | 2020-11-27 | Unknown | New Hampshire | 372 | 1 | |
769697 | 769697 | 2020-11-26 | Unknown | New Hampshire | 309 | 1 | |
766451 | 766451 | 2020-11-25 | Unknown | New Hampshire | 309 | 1 | |
763206 | 763206 | 2020-11-24 | Unknown | New Hampshire | 293 | 1 | |
759961 | 759961 | 2020-11-23 | Unknown | New Hampshire | 305 | 1 | |
756715 | 756715 | 2020-11-22 | Unknown | New Hampshire | 284 | 1 | |
753468 | 753468 | 2020-11-21 | Unknown | New Hampshire | 266 | 1 | |
750222 | 750222 | 2020-11-20 | Unknown | New Hampshire | 258 | 1 | |
746976 | 746976 | 2020-11-19 | Unknown | New Hampshire | 251 | 1 | |
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 | |
717774 | 717774 | 2020-11-10 | Unknown | New Hampshire | 80 | 0 | |
714531 | 714531 | 2020-11-09 | Unknown | New Hampshire | 79 | 0 | |
711287 | 711287 | 2020-11-08 | Unknown | New Hampshire | 73 | 0 | |
708043 | 708043 | 2020-11-07 | Unknown | New Hampshire | 62 | 0 | |
704800 | 704800 | 2020-11-06 | Unknown | New Hampshire | 53 | 0 | |
701557 | 701557 | 2020-11-05 | Unknown | New Hampshire | 44 | 0 | |
698313 | 698313 | 2020-11-04 | Unknown | New Hampshire | 34 | 0 | |
695070 | 695070 | 2020-11-03 | Unknown | New Hampshire | 36 | 0 | |
691828 | 691828 | 2020-11-02 | Unknown | New Hampshire | 36 | 0 | |
688584 | 688584 | 2020-11-01 | Unknown | New Hampshire | 36 | 0 | |
685339 | 685339 | 2020-10-31 | Unknown | New Hampshire | 26 | 0 | |
682096 | 682096 | 2020-10-30 | Unknown | New Hampshire | 20 | 0 | |
678853 | 678853 | 2020-10-29 | Unknown | New Hampshire | 18 | 0 | |
675610 | 675610 | 2020-10-28 | Unknown | New Hampshire | 18 | 0 | |
672367 | 672367 | 2020-10-27 | Unknown | New Hampshire | 21 | 0 | |
669125 | 669125 | 2020-10-26 | Unknown | New Hampshire | 16 | 0 | |
665881 | 665881 | 2020-10-25 | Unknown | New Hampshire | 18 | 0 | |
662636 | 662636 | 2020-10-24 | Unknown | New Hampshire | 16 | 0 | |
659392 | 659392 | 2020-10-23 | Unknown | New Hampshire | 14 | 0 | |
656148 | 656148 | 2020-10-22 | Unknown | New Hampshire | 15 | 0 | |
652903 | 652903 | 2020-10-21 | Unknown | New Hampshire | 17 | 0 | |
649658 | 649658 | 2020-10-20 | Unknown | New Hampshire | 13 | 0 | |
646414 | 646414 | 2020-10-19 | Unknown | New Hampshire | 14 | 0 | |
643168 | 643168 | 2020-10-18 | Unknown | New Hampshire | 14 | 0 | |
639920 | 639920 | 2020-10-17 | Unknown | New Hampshire | 12 | 0 | |
636674 | 636674 | 2020-10-16 | Unknown | New Hampshire | 6 | 0 | |
633428 | 633428 | 2020-10-15 | Unknown | New Hampshire | 8 | 0 | |
630183 | 630183 | 2020-10-14 | Unknown | New Hampshire | 8 | 0 | |
626939 | 626939 | 2020-10-13 | Unknown | New Hampshire | 10 | 0 | |
623697 | 623697 | 2020-10-12 | Unknown | New Hampshire | 8 | 0 | |
620454 | 620454 | 2020-10-11 | Unknown | New Hampshire | 6 | 0 | |
617212 | 617212 | 2020-10-10 | Unknown | New Hampshire | 9 | 0 | |
613970 | 613970 | 2020-10-09 | Unknown | New Hampshire | 7 | 0 | |
610729 | 610729 | 2020-10-08 | Unknown | New Hampshire | 2 | 0 | |
607487 | 607487 | 2020-10-07 | Unknown | New Hampshire | 4 | 0 | |
604244 | 604244 | 2020-10-06 | Unknown | New Hampshire | 6 | 0 | |
601002 | 601002 | 2020-10-05 | Unknown | New Hampshire | 3 | 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);