ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,832 rows where state = "Northern Mariana Islands" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Northern Mariana Islands · 594 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055564 | 1055564 | 2021-02-22 | Saipan | Northern Mariana Islands | 69110 | 141 | 2 |
1055565 | 1055565 | 2021-02-22 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1052318 | 1052318 | 2021-02-21 | Saipan | Northern Mariana Islands | 69110 | 141 | 2 |
1052319 | 1052319 | 2021-02-21 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1049071 | 1049071 | 2021-02-20 | Saipan | Northern Mariana Islands | 69110 | 133 | 2 |
1049072 | 1049072 | 2021-02-20 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1045824 | 1045824 | 2021-02-19 | Saipan | Northern Mariana Islands | 69110 | 133 | 2 |
1045825 | 1045825 | 2021-02-19 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1042579 | 1042579 | 2021-02-18 | Saipan | Northern Mariana Islands | 69110 | 133 | 2 |
1042580 | 1042580 | 2021-02-18 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1039334 | 1039334 | 2021-02-17 | Saipan | Northern Mariana Islands | 69110 | 133 | 2 |
1039335 | 1039335 | 2021-02-17 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1036089 | 1036089 | 2021-02-16 | Saipan | Northern Mariana Islands | 69110 | 132 | 2 |
1036090 | 1036090 | 2021-02-16 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1032844 | 1032844 | 2021-02-15 | Saipan | Northern Mariana Islands | 69110 | 132 | 2 |
1032845 | 1032845 | 2021-02-15 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1029598 | 1029598 | 2021-02-14 | Saipan | Northern Mariana Islands | 69110 | 132 | 2 |
1029599 | 1029599 | 2021-02-14 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1026351 | 1026351 | 2021-02-13 | Saipan | Northern Mariana Islands | 69110 | 132 | 2 |
1026352 | 1026352 | 2021-02-13 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1023106 | 1023106 | 2021-02-12 | Saipan | Northern Mariana Islands | 69110 | 132 | 2 |
1023107 | 1023107 | 2021-02-12 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1019861 | 1019861 | 2021-02-11 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1019862 | 1019862 | 2021-02-11 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1016616 | 1016616 | 2021-02-10 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1016617 | 1016617 | 2021-02-10 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1013371 | 1013371 | 2021-02-09 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1013372 | 1013372 | 2021-02-09 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1010126 | 1010126 | 2021-02-08 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1010127 | 1010127 | 2021-02-08 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1006880 | 1006880 | 2021-02-07 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1006881 | 1006881 | 2021-02-07 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1003634 | 1003634 | 2021-02-06 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1003635 | 1003635 | 2021-02-06 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1000388 | 1000388 | 2021-02-05 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
1000389 | 1000389 | 2021-02-05 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
997142 | 997142 | 2021-02-04 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
997143 | 997143 | 2021-02-04 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
993896 | 993896 | 2021-02-03 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
993897 | 993897 | 2021-02-03 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
990650 | 990650 | 2021-02-02 | Saipan | Northern Mariana Islands | 69110 | 131 | 2 |
990651 | 990651 | 2021-02-02 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
987404 | 987404 | 2021-02-01 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
987405 | 987405 | 2021-02-01 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
984157 | 984157 | 2021-01-31 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
984158 | 984158 | 2021-01-31 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
980910 | 980910 | 2021-01-30 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
980911 | 980911 | 2021-01-30 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
977664 | 977664 | 2021-01-29 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
977665 | 977665 | 2021-01-29 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
974419 | 974419 | 2021-01-28 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
974420 | 974420 | 2021-01-28 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
971174 | 971174 | 2021-01-27 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
971175 | 971175 | 2021-01-27 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
967929 | 967929 | 2021-01-26 | Saipan | Northern Mariana Islands | 69110 | 129 | 2 |
967930 | 967930 | 2021-01-26 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
964685 | 964685 | 2021-01-25 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
964686 | 964686 | 2021-01-25 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
961440 | 961440 | 2021-01-24 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
961441 | 961441 | 2021-01-24 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
958195 | 958195 | 2021-01-23 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
958196 | 958196 | 2021-01-23 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
954949 | 954949 | 2021-01-22 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
954950 | 954950 | 2021-01-22 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
951704 | 951704 | 2021-01-21 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
951705 | 951705 | 2021-01-21 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
948459 | 948459 | 2021-01-20 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
948460 | 948460 | 2021-01-20 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
945213 | 945213 | 2021-01-19 | Saipan | Northern Mariana Islands | 69110 | 127 | 2 |
945214 | 945214 | 2021-01-19 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
941966 | 941966 | 2021-01-18 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
941967 | 941967 | 2021-01-18 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
938721 | 938721 | 2021-01-17 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
938722 | 938722 | 2021-01-17 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
935476 | 935476 | 2021-01-16 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
935477 | 935477 | 2021-01-16 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
932231 | 932231 | 2021-01-15 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
932232 | 932232 | 2021-01-15 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
928986 | 928986 | 2021-01-14 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
928987 | 928987 | 2021-01-14 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
925741 | 925741 | 2021-01-13 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
925742 | 925742 | 2021-01-13 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
922495 | 922495 | 2021-01-12 | Saipan | Northern Mariana Islands | 69110 | 126 | 2 |
922496 | 922496 | 2021-01-12 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
919250 | 919250 | 2021-01-11 | Saipan | Northern Mariana Islands | 69110 | 123 | 2 |
919251 | 919251 | 2021-01-11 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
916005 | 916005 | 2021-01-10 | Saipan | Northern Mariana Islands | 69110 | 123 | 2 |
916006 | 916006 | 2021-01-10 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
912760 | 912760 | 2021-01-09 | Saipan | Northern Mariana Islands | 69110 | 123 | 2 |
912761 | 912761 | 2021-01-09 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
909515 | 909515 | 2021-01-08 | Saipan | Northern Mariana Islands | 69110 | 123 | 2 |
909516 | 909516 | 2021-01-08 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
906270 | 906270 | 2021-01-07 | Saipan | Northern Mariana Islands | 69110 | 123 | 2 |
906271 | 906271 | 2021-01-07 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
903024 | 903024 | 2021-01-06 | Saipan | Northern Mariana Islands | 69110 | 122 | 2 |
903025 | 903025 | 2021-01-06 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
899779 | 899779 | 2021-01-05 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
899780 | 899780 | 2021-01-05 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
896534 | 896534 | 2021-01-04 | Saipan | Northern Mariana Islands | 69110 | 120 | 2 |
896535 | 896535 | 2021-01-04 | Tinian | Northern Mariana Islands | 69120 | 2 | 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);