ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
669 rows where county = "Tinian" and state = "Northern Mariana Islands" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
333464 | 333464 | 2020-07-14 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
336658 | 336658 | 2020-07-15 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
339854 | 339854 | 2020-07-16 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
343052 | 343052 | 2020-07-17 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
346251 | 346251 | 2020-07-18 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
349452 | 349452 | 2020-07-19 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
352655 | 352655 | 2020-07-20 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
355858 | 355858 | 2020-07-21 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
359062 | 359062 | 2020-07-22 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
362268 | 362268 | 2020-07-23 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
365474 | 365474 | 2020-07-24 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
368683 | 368683 | 2020-07-25 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
371895 | 371895 | 2020-07-26 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
375107 | 375107 | 2020-07-27 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
378324 | 378324 | 2020-07-28 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
381541 | 381541 | 2020-07-29 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
384759 | 384759 | 2020-07-30 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
387976 | 387976 | 2020-07-31 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
391193 | 391193 | 2020-08-01 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
394409 | 394409 | 2020-08-02 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
397626 | 397626 | 2020-08-03 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
400841 | 400841 | 2020-08-04 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
404059 | 404059 | 2020-08-05 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
407278 | 407278 | 2020-08-06 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
410498 | 410498 | 2020-08-07 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
413718 | 413718 | 2020-08-08 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
416939 | 416939 | 2020-08-09 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
420159 | 420159 | 2020-08-10 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
423382 | 423382 | 2020-08-11 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
426605 | 426605 | 2020-08-12 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
429830 | 429830 | 2020-08-13 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
433056 | 433056 | 2020-08-14 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
436282 | 436282 | 2020-08-15 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
439507 | 439507 | 2020-08-16 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
442734 | 442734 | 2020-08-17 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
445960 | 445960 | 2020-08-18 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
449188 | 449188 | 2020-08-19 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
452416 | 452416 | 2020-08-20 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
455644 | 455644 | 2020-08-21 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
458872 | 458872 | 2020-08-22 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
462100 | 462100 | 2020-08-23 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
465329 | 465329 | 2020-08-24 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
468557 | 468557 | 2020-08-25 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
471789 | 471789 | 2020-08-26 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
475023 | 475023 | 2020-08-27 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
478256 | 478256 | 2020-08-28 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
481489 | 481489 | 2020-08-29 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
484724 | 484724 | 2020-08-30 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
487957 | 487957 | 2020-08-31 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
491190 | 491190 | 2020-09-01 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
494424 | 494424 | 2020-09-02 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
497657 | 497657 | 2020-09-03 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
500891 | 500891 | 2020-09-04 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
504125 | 504125 | 2020-09-05 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
507357 | 507357 | 2020-09-06 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
510590 | 510590 | 2020-09-07 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
513823 | 513823 | 2020-09-08 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
517058 | 517058 | 2020-09-09 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
520294 | 520294 | 2020-09-10 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
523530 | 523530 | 2020-09-11 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
526766 | 526766 | 2020-09-12 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
530003 | 530003 | 2020-09-13 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
533238 | 533238 | 2020-09-14 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
536474 | 536474 | 2020-09-15 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
539711 | 539711 | 2020-09-16 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
542947 | 542947 | 2020-09-17 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
546184 | 546184 | 2020-09-18 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
549423 | 549423 | 2020-09-19 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
552662 | 552662 | 2020-09-20 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
555899 | 555899 | 2020-09-21 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
559136 | 559136 | 2020-09-22 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
562373 | 562373 | 2020-09-23 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
565614 | 565614 | 2020-09-24 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
568855 | 568855 | 2020-09-25 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
572097 | 572097 | 2020-09-26 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
575341 | 575341 | 2020-09-27 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
578582 | 578582 | 2020-09-28 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
581822 | 581822 | 2020-09-29 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
585063 | 585063 | 2020-09-30 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
588303 | 588303 | 2020-10-01 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
591544 | 591544 | 2020-10-02 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
594785 | 594785 | 2020-10-03 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
598028 | 598028 | 2020-10-04 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
601271 | 601271 | 2020-10-05 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
604513 | 604513 | 2020-10-06 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
607756 | 607756 | 2020-10-07 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
610998 | 610998 | 2020-10-08 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
614239 | 614239 | 2020-10-09 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
617481 | 617481 | 2020-10-10 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
620723 | 620723 | 2020-10-11 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
623966 | 623966 | 2020-10-12 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
627208 | 627208 | 2020-10-13 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
630452 | 630452 | 2020-10-14 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
633697 | 633697 | 2020-10-15 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
636943 | 636943 | 2020-10-16 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
640189 | 640189 | 2020-10-17 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
643437 | 643437 | 2020-10-18 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
646683 | 646683 | 2020-10-19 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
649927 | 649927 | 2020-10-20 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
653172 | 653172 | 2020-10-21 | 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);