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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536474 | 536474 | 2020-09-15 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
533238 | 533238 | 2020-09-14 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
530003 | 530003 | 2020-09-13 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
526766 | 526766 | 2020-09-12 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
523530 | 523530 | 2020-09-11 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
520294 | 520294 | 2020-09-10 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
517058 | 517058 | 2020-09-09 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
513823 | 513823 | 2020-09-08 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
510590 | 510590 | 2020-09-07 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
507357 | 507357 | 2020-09-06 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
504125 | 504125 | 2020-09-05 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
500891 | 500891 | 2020-09-04 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
497657 | 497657 | 2020-09-03 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
494424 | 494424 | 2020-09-02 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
491190 | 491190 | 2020-09-01 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
487957 | 487957 | 2020-08-31 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
484724 | 484724 | 2020-08-30 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
481489 | 481489 | 2020-08-29 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
478256 | 478256 | 2020-08-28 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
475023 | 475023 | 2020-08-27 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
471789 | 471789 | 2020-08-26 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
468557 | 468557 | 2020-08-25 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
465329 | 465329 | 2020-08-24 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
462100 | 462100 | 2020-08-23 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
458872 | 458872 | 2020-08-22 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
455644 | 455644 | 2020-08-21 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
452416 | 452416 | 2020-08-20 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
449188 | 449188 | 2020-08-19 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
445960 | 445960 | 2020-08-18 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
442734 | 442734 | 2020-08-17 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
439507 | 439507 | 2020-08-16 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
436282 | 436282 | 2020-08-15 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
433056 | 433056 | 2020-08-14 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
429830 | 429830 | 2020-08-13 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
426605 | 426605 | 2020-08-12 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
423382 | 423382 | 2020-08-11 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
420159 | 420159 | 2020-08-10 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
416939 | 416939 | 2020-08-09 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
413718 | 413718 | 2020-08-08 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
410498 | 410498 | 2020-08-07 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
407278 | 407278 | 2020-08-06 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
404059 | 404059 | 2020-08-05 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
400841 | 400841 | 2020-08-04 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
397626 | 397626 | 2020-08-03 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
394409 | 394409 | 2020-08-02 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
391193 | 391193 | 2020-08-01 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
387976 | 387976 | 2020-07-31 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
384759 | 384759 | 2020-07-30 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
381541 | 381541 | 2020-07-29 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
378324 | 378324 | 2020-07-28 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
375107 | 375107 | 2020-07-27 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
371895 | 371895 | 2020-07-26 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
368683 | 368683 | 2020-07-25 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
365474 | 365474 | 2020-07-24 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
362268 | 362268 | 2020-07-23 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
359062 | 359062 | 2020-07-22 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
355858 | 355858 | 2020-07-21 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
352655 | 352655 | 2020-07-20 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
349452 | 349452 | 2020-07-19 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
346251 | 346251 | 2020-07-18 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
343052 | 343052 | 2020-07-17 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
339854 | 339854 | 2020-07-16 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
336658 | 336658 | 2020-07-15 | Tinian | Northern Mariana Islands | 69120 | 1 | 0 |
333464 | 333464 | 2020-07-14 | 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);