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 · 330 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636942 | 636942 | 2020-10-16 | Saipan | Northern Mariana Islands | 69110 | 78 | 2 |
636943 | 636943 | 2020-10-16 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
633696 | 633696 | 2020-10-15 | Saipan | Northern Mariana Islands | 69110 | 78 | 2 |
633697 | 633697 | 2020-10-15 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
630451 | 630451 | 2020-10-14 | Saipan | Northern Mariana Islands | 69110 | 75 | 2 |
630452 | 630452 | 2020-10-14 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
627207 | 627207 | 2020-10-13 | Saipan | Northern Mariana Islands | 69110 | 75 | 2 |
627208 | 627208 | 2020-10-13 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
623965 | 623965 | 2020-10-12 | Saipan | Northern Mariana Islands | 69110 | 75 | 2 |
623966 | 623966 | 2020-10-12 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
620722 | 620722 | 2020-10-11 | Saipan | Northern Mariana Islands | 69110 | 75 | 2 |
620723 | 620723 | 2020-10-11 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
617480 | 617480 | 2020-10-10 | Saipan | Northern Mariana Islands | 69110 | 75 | 2 |
617481 | 617481 | 2020-10-10 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
614238 | 614238 | 2020-10-09 | Saipan | Northern Mariana Islands | 69110 | 73 | 2 |
614239 | 614239 | 2020-10-09 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
610997 | 610997 | 2020-10-08 | Saipan | Northern Mariana Islands | 69110 | 73 | 2 |
610998 | 610998 | 2020-10-08 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
607755 | 607755 | 2020-10-07 | Saipan | Northern Mariana Islands | 69110 | 73 | 2 |
607756 | 607756 | 2020-10-07 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
604512 | 604512 | 2020-10-06 | Saipan | Northern Mariana Islands | 69110 | 73 | 2 |
604513 | 604513 | 2020-10-06 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
601270 | 601270 | 2020-10-05 | Saipan | Northern Mariana Islands | 69110 | 73 | 2 |
601271 | 601271 | 2020-10-05 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
598027 | 598027 | 2020-10-04 | Saipan | Northern Mariana Islands | 69110 | 71 | 2 |
598028 | 598028 | 2020-10-04 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
594784 | 594784 | 2020-10-03 | Saipan | Northern Mariana Islands | 69110 | 68 | 2 |
594785 | 594785 | 2020-10-03 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
591543 | 591543 | 2020-10-02 | Saipan | Northern Mariana Islands | 69110 | 68 | 2 |
591544 | 591544 | 2020-10-02 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
588302 | 588302 | 2020-10-01 | Saipan | Northern Mariana Islands | 69110 | 68 | 2 |
588303 | 588303 | 2020-10-01 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
585062 | 585062 | 2020-09-30 | Saipan | Northern Mariana Islands | 69110 | 68 | 2 |
585063 | 585063 | 2020-09-30 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
581821 | 581821 | 2020-09-29 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
581822 | 581822 | 2020-09-29 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
581823 | 581823 | 2020-09-29 | Unknown | Northern Mariana Islands | 15 | 0 | |
578581 | 578581 | 2020-09-28 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
578582 | 578582 | 2020-09-28 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
578583 | 578583 | 2020-09-28 | Unknown | Northern Mariana Islands | 15 | 0 | |
575340 | 575340 | 2020-09-27 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
575341 | 575341 | 2020-09-27 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
575342 | 575342 | 2020-09-27 | Unknown | Northern Mariana Islands | 15 | 0 | |
572096 | 572096 | 2020-09-26 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
572097 | 572097 | 2020-09-26 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
572098 | 572098 | 2020-09-26 | Unknown | Northern Mariana Islands | 15 | 0 | |
568854 | 568854 | 2020-09-25 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
568855 | 568855 | 2020-09-25 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
568856 | 568856 | 2020-09-25 | Unknown | Northern Mariana Islands | 15 | 0 | |
565613 | 565613 | 2020-09-24 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
565614 | 565614 | 2020-09-24 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
565615 | 565615 | 2020-09-24 | Unknown | Northern Mariana Islands | 15 | 0 | |
562372 | 562372 | 2020-09-23 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
562373 | 562373 | 2020-09-23 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
562374 | 562374 | 2020-09-23 | Unknown | Northern Mariana Islands | 15 | 0 | |
559135 | 559135 | 2020-09-22 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
559136 | 559136 | 2020-09-22 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
559137 | 559137 | 2020-09-22 | Unknown | Northern Mariana Islands | 15 | 0 | |
555898 | 555898 | 2020-09-21 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
555899 | 555899 | 2020-09-21 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
555900 | 555900 | 2020-09-21 | Unknown | Northern Mariana Islands | 15 | 0 | |
552661 | 552661 | 2020-09-20 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
552662 | 552662 | 2020-09-20 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
552663 | 552663 | 2020-09-20 | Unknown | Northern Mariana Islands | 14 | 0 | |
549422 | 549422 | 2020-09-19 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
549423 | 549423 | 2020-09-19 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
549424 | 549424 | 2020-09-19 | Unknown | Northern Mariana Islands | 14 | 0 | |
546183 | 546183 | 2020-09-18 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
546184 | 546184 | 2020-09-18 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
546185 | 546185 | 2020-09-18 | Unknown | Northern Mariana Islands | 8 | 0 | |
542946 | 542946 | 2020-09-17 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
542947 | 542947 | 2020-09-17 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
542948 | 542948 | 2020-09-17 | Unknown | Northern Mariana Islands | 8 | 0 | |
539710 | 539710 | 2020-09-16 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
539711 | 539711 | 2020-09-16 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
539712 | 539712 | 2020-09-16 | Unknown | Northern Mariana Islands | 7 | 0 | |
536473 | 536473 | 2020-09-15 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
536474 | 536474 | 2020-09-15 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
536475 | 536475 | 2020-09-15 | Unknown | Northern Mariana Islands | 7 | 0 | |
533237 | 533237 | 2020-09-14 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
533238 | 533238 | 2020-09-14 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
533239 | 533239 | 2020-09-14 | Unknown | Northern Mariana Islands | 7 | 0 | |
530002 | 530002 | 2020-09-13 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
530003 | 530003 | 2020-09-13 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
530004 | 530004 | 2020-09-13 | Unknown | Northern Mariana Islands | 6 | 0 | |
526765 | 526765 | 2020-09-12 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
526766 | 526766 | 2020-09-12 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
526767 | 526767 | 2020-09-12 | Unknown | Northern Mariana Islands | 6 | 0 | |
523529 | 523529 | 2020-09-11 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
523530 | 523530 | 2020-09-11 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
523531 | 523531 | 2020-09-11 | Unknown | Northern Mariana Islands | 5 | 0 | |
520293 | 520293 | 2020-09-10 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
520294 | 520294 | 2020-09-10 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
520295 | 520295 | 2020-09-10 | Unknown | Northern Mariana Islands | 5 | 0 | |
517057 | 517057 | 2020-09-09 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
517058 | 517058 | 2020-09-09 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
517059 | 517059 | 2020-09-09 | Unknown | Northern Mariana Islands | 5 | 0 | |
513822 | 513822 | 2020-09-08 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
513823 | 513823 | 2020-09-08 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
513824 | 513824 | 2020-09-08 | Unknown | Northern Mariana Islands | 5 | 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);