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 · 254 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 | |
510589 | 510589 | 2020-09-07 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
510590 | 510590 | 2020-09-07 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
510591 | 510591 | 2020-09-07 | Unknown | Northern Mariana Islands | 5 | 0 | |
507356 | 507356 | 2020-09-06 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
507357 | 507357 | 2020-09-06 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
507358 | 507358 | 2020-09-06 | Unknown | Northern Mariana Islands | 4 | 0 | |
504124 | 504124 | 2020-09-05 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
504125 | 504125 | 2020-09-05 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
504126 | 504126 | 2020-09-05 | Unknown | Northern Mariana Islands | 4 | 0 | |
500890 | 500890 | 2020-09-04 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
500891 | 500891 | 2020-09-04 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
500892 | 500892 | 2020-09-04 | Unknown | Northern Mariana Islands | 3 | 0 | |
497656 | 497656 | 2020-09-03 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
497657 | 497657 | 2020-09-03 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
497658 | 497658 | 2020-09-03 | Unknown | Northern Mariana Islands | 3 | 0 | |
494423 | 494423 | 2020-09-02 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
494424 | 494424 | 2020-09-02 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
494425 | 494425 | 2020-09-02 | Unknown | Northern Mariana Islands | 3 | 0 | |
491189 | 491189 | 2020-09-01 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
491190 | 491190 | 2020-09-01 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
491191 | 491191 | 2020-09-01 | Unknown | Northern Mariana Islands | 3 | 0 | |
487956 | 487956 | 2020-08-31 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
487957 | 487957 | 2020-08-31 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
487958 | 487958 | 2020-08-31 | Unknown | Northern Mariana Islands | 2 | 0 | |
484723 | 484723 | 2020-08-30 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
484724 | 484724 | 2020-08-30 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
484725 | 484725 | 2020-08-30 | Unknown | Northern Mariana Islands | 2 | 0 | |
481488 | 481488 | 2020-08-29 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
481489 | 481489 | 2020-08-29 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
481490 | 481490 | 2020-08-29 | Unknown | Northern Mariana Islands | 2 | 0 | |
478255 | 478255 | 2020-08-28 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
478256 | 478256 | 2020-08-28 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
475022 | 475022 | 2020-08-27 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
475023 | 475023 | 2020-08-27 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
471788 | 471788 | 2020-08-26 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
471789 | 471789 | 2020-08-26 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
468556 | 468556 | 2020-08-25 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
468557 | 468557 | 2020-08-25 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
465328 | 465328 | 2020-08-24 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
465329 | 465329 | 2020-08-24 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
462099 | 462099 | 2020-08-23 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
462100 | 462100 | 2020-08-23 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
458871 | 458871 | 2020-08-22 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
458872 | 458872 | 2020-08-22 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
455643 | 455643 | 2020-08-21 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
455644 | 455644 | 2020-08-21 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
452415 | 452415 | 2020-08-20 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
452416 | 452416 | 2020-08-20 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
449187 | 449187 | 2020-08-19 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
449188 | 449188 | 2020-08-19 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
445959 | 445959 | 2020-08-18 | Saipan | Northern Mariana Islands | 69110 | 53 | 2 |
445960 | 445960 | 2020-08-18 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
442733 | 442733 | 2020-08-17 | Saipan | Northern Mariana Islands | 69110 | 52 | 2 |
442734 | 442734 | 2020-08-17 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
439506 | 439506 | 2020-08-16 | Saipan | Northern Mariana Islands | 69110 | 49 | 2 |
439507 | 439507 | 2020-08-16 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
436281 | 436281 | 2020-08-15 | Saipan | Northern Mariana Islands | 69110 | 49 | 2 |
436282 | 436282 | 2020-08-15 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
433055 | 433055 | 2020-08-14 | Saipan | Northern Mariana Islands | 69110 | 49 | 2 |
433056 | 433056 | 2020-08-14 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
429829 | 429829 | 2020-08-13 | Saipan | Northern Mariana Islands | 69110 | 48 | 2 |
429830 | 429830 | 2020-08-13 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
426604 | 426604 | 2020-08-12 | Saipan | Northern Mariana Islands | 69110 | 48 | 2 |
426605 | 426605 | 2020-08-12 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
423381 | 423381 | 2020-08-11 | Saipan | Northern Mariana Islands | 69110 | 48 | 2 |
423382 | 423382 | 2020-08-11 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
420158 | 420158 | 2020-08-10 | Saipan | Northern Mariana Islands | 69110 | 48 | 2 |
420159 | 420159 | 2020-08-10 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
416938 | 416938 | 2020-08-09 | Saipan | Northern Mariana Islands | 69110 | 47 | 2 |
416939 | 416939 | 2020-08-09 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
413717 | 413717 | 2020-08-08 | Saipan | Northern Mariana Islands | 69110 | 47 | 2 |
413718 | 413718 | 2020-08-08 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
410497 | 410497 | 2020-08-07 | Saipan | Northern Mariana Islands | 69110 | 46 | 2 |
410498 | 410498 | 2020-08-07 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
407277 | 407277 | 2020-08-06 | Saipan | Northern Mariana Islands | 69110 | 46 | 2 |
407278 | 407278 | 2020-08-06 | Tinian | Northern Mariana Islands | 69120 | 1 | 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);