ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
669 rows where fips = 69110 and state = "Northern Mariana Islands" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055564 | 1055564 | 2021-02-22 | Saipan | Northern Mariana Islands | 69110 | 141 | 2 |
1052318 | 1052318 | 2021-02-21 | Saipan | Northern Mariana Islands | 69110 | 141 | 2 |
1049071 | 1049071 | 2021-02-20 | Saipan | Northern Mariana Islands | 69110 | 133 | 2 |
1045824 | 1045824 | 2021-02-19 | Saipan | Northern Mariana Islands | 69110 | 133 | 2 |
1042579 | 1042579 | 2021-02-18 | Saipan | Northern Mariana Islands | 69110 | 133 | 2 |
1039334 | 1039334 | 2021-02-17 | Saipan | Northern Mariana Islands | 69110 | 133 | 2 |
1036089 | 1036089 | 2021-02-16 | Saipan | Northern Mariana Islands | 69110 | 132 | 2 |
1032844 | 1032844 | 2021-02-15 | Saipan | Northern Mariana Islands | 69110 | 132 | 2 |
1029598 | 1029598 | 2021-02-14 | Saipan | Northern Mariana Islands | 69110 | 132 | 2 |
1026351 | 1026351 | 2021-02-13 | Saipan | Northern Mariana Islands | 69110 | 132 | 2 |
1023106 | 1023106 | 2021-02-12 | Saipan | Northern Mariana Islands | 69110 | 132 | 2 |
1019861 | 1019861 | 2021-02-11 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1016616 | 1016616 | 2021-02-10 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1013371 | 1013371 | 2021-02-09 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1010126 | 1010126 | 2021-02-08 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1006880 | 1006880 | 2021-02-07 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1003634 | 1003634 | 2021-02-06 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1000388 | 1000388 | 2021-02-05 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
997142 | 997142 | 2021-02-04 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
993896 | 993896 | 2021-02-03 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
990650 | 990650 | 2021-02-02 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
987404 | 987404 | 2021-02-01 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
984157 | 984157 | 2021-01-31 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
980910 | 980910 | 2021-01-30 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
977664 | 977664 | 2021-01-29 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
974419 | 974419 | 2021-01-28 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
971174 | 971174 | 2021-01-27 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
967929 | 967929 | 2021-01-26 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
964685 | 964685 | 2021-01-25 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
961440 | 961440 | 2021-01-24 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
958195 | 958195 | 2021-01-23 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
954949 | 954949 | 2021-01-22 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
951704 | 951704 | 2021-01-21 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
948459 | 948459 | 2021-01-20 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
945213 | 945213 | 2021-01-19 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
941966 | 941966 | 2021-01-18 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
938721 | 938721 | 2021-01-17 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
935476 | 935476 | 2021-01-16 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
932231 | 932231 | 2021-01-15 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
928986 | 928986 | 2021-01-14 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
925741 | 925741 | 2021-01-13 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
922495 | 922495 | 2021-01-12 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
919250 | 919250 | 2021-01-11 | Saipan | Northern Mariana Islands | 69110 | 123 | 2 |
916005 | 916005 | 2021-01-10 | Saipan | Northern Mariana Islands | 69110 | 123 | 2 |
912760 | 912760 | 2021-01-09 | Saipan | Northern Mariana Islands | 69110 | 123 | 2 |
909515 | 909515 | 2021-01-08 | Saipan | Northern Mariana Islands | 69110 | 123 | 2 |
906270 | 906270 | 2021-01-07 | Saipan | Northern Mariana Islands | 69110 | 123 | 2 |
903024 | 903024 | 2021-01-06 | Saipan | Northern Mariana Islands | 69110 | 122 | 2 |
899779 | 899779 | 2021-01-05 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
896534 | 896534 | 2021-01-04 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
893288 | 893288 | 2021-01-03 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
890042 | 890042 | 2021-01-02 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
886795 | 886795 | 2021-01-01 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
883550 | 883550 | 2020-12-31 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
880305 | 880305 | 2020-12-30 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
877060 | 877060 | 2020-12-29 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
873815 | 873815 | 2020-12-28 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
870570 | 870570 | 2020-12-27 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
867325 | 867325 | 2020-12-26 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
864080 | 864080 | 2020-12-25 | Saipan | Northern Mariana Islands | 69110 | 116 | 2 |
860835 | 860835 | 2020-12-24 | Saipan | Northern Mariana Islands | 69110 | 116 | 2 |
857590 | 857590 | 2020-12-23 | Saipan | Northern Mariana Islands | 69110 | 116 | 2 |
854345 | 854345 | 2020-12-22 | Saipan | Northern Mariana Islands | 69110 | 114 | 2 |
851100 | 851100 | 2020-12-21 | Saipan | Northern Mariana Islands | 69110 | 114 | 2 |
847855 | 847855 | 2020-12-20 | Saipan | Northern Mariana Islands | 69110 | 113 | 2 |
844610 | 844610 | 2020-12-19 | Saipan | Northern Mariana Islands | 69110 | 113 | 2 |
841364 | 841364 | 2020-12-18 | Saipan | Northern Mariana Islands | 69110 | 113 | 2 |
838119 | 838119 | 2020-12-17 | Saipan | Northern Mariana Islands | 69110 | 111 | 2 |
834873 | 834873 | 2020-12-16 | Saipan | Northern Mariana Islands | 69110 | 111 | 2 |
831627 | 831627 | 2020-12-15 | Saipan | Northern Mariana Islands | 69110 | 111 | 2 |
828380 | 828380 | 2020-12-14 | Saipan | Northern Mariana Islands | 69110 | 111 | 2 |
825134 | 825134 | 2020-12-13 | Saipan | Northern Mariana Islands | 69110 | 111 | 2 |
821887 | 821887 | 2020-12-12 | Saipan | Northern Mariana Islands | 69110 | 111 | 2 |
818641 | 818641 | 2020-12-11 | Saipan | Northern Mariana Islands | 69110 | 111 | 2 |
815395 | 815395 | 2020-12-10 | Saipan | Northern Mariana Islands | 69110 | 111 | 2 |
812149 | 812149 | 2020-12-09 | Saipan | Northern Mariana Islands | 69110 | 111 | 2 |
808905 | 808905 | 2020-12-08 | Saipan | Northern Mariana Islands | 69110 | 109 | 2 |
805660 | 805660 | 2020-12-07 | Saipan | Northern Mariana Islands | 69110 | 107 | 2 |
802415 | 802415 | 2020-12-06 | Saipan | Northern Mariana Islands | 69110 | 104 | 2 |
799170 | 799170 | 2020-12-05 | Saipan | Northern Mariana Islands | 69110 | 104 | 2 |
795925 | 795925 | 2020-12-04 | Saipan | Northern Mariana Islands | 69110 | 104 | 2 |
792680 | 792680 | 2020-12-03 | Saipan | Northern Mariana Islands | 69110 | 104 | 2 |
789435 | 789435 | 2020-12-02 | Saipan | Northern Mariana Islands | 69110 | 104 | 2 |
786190 | 786190 | 2020-12-01 | Saipan | Northern Mariana Islands | 69110 | 104 | 2 |
782946 | 782946 | 2020-11-30 | Saipan | Northern Mariana Islands | 69110 | 104 | 2 |
779700 | 779700 | 2020-11-29 | Saipan | Northern Mariana Islands | 69110 | 102 | 2 |
776455 | 776455 | 2020-11-28 | Saipan | Northern Mariana Islands | 69110 | 102 | 2 |
773210 | 773210 | 2020-11-27 | Saipan | Northern Mariana Islands | 69110 | 102 | 2 |
769965 | 769965 | 2020-11-26 | Saipan | Northern Mariana Islands | 69110 | 102 | 2 |
766719 | 766719 | 2020-11-25 | Saipan | Northern Mariana Islands | 69110 | 102 | 2 |
763474 | 763474 | 2020-11-24 | Saipan | Northern Mariana Islands | 69110 | 102 | 2 |
760229 | 760229 | 2020-11-23 | Saipan | Northern Mariana Islands | 69110 | 102 | 2 |
756983 | 756983 | 2020-11-22 | Saipan | Northern Mariana Islands | 69110 | 100 | 2 |
753736 | 753736 | 2020-11-21 | Saipan | Northern Mariana Islands | 69110 | 100 | 2 |
750490 | 750490 | 2020-11-20 | Saipan | Northern Mariana Islands | 69110 | 100 | 2 |
747244 | 747244 | 2020-11-19 | Saipan | Northern Mariana Islands | 69110 | 100 | 2 |
743998 | 743998 | 2020-11-18 | Saipan | Northern Mariana Islands | 69110 | 100 | 2 |
740751 | 740751 | 2020-11-17 | Saipan | Northern Mariana Islands | 69110 | 100 | 2 |
737506 | 737506 | 2020-11-16 | Saipan | Northern Mariana Islands | 69110 | 100 | 2 |
734262 | 734262 | 2020-11-15 | Saipan | Northern Mariana Islands | 69110 | 98 | 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);