ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where fips = 38081 and state = "North Dakota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
349437 | 349437 | 2020-07-19 | Sargent | North Dakota | 38081 | 8 | 0 |
352640 | 352640 | 2020-07-20 | Sargent | North Dakota | 38081 | 8 | 0 |
355843 | 355843 | 2020-07-21 | Sargent | North Dakota | 38081 | 8 | 0 |
359047 | 359047 | 2020-07-22 | Sargent | North Dakota | 38081 | 9 | 0 |
362253 | 362253 | 2020-07-23 | Sargent | North Dakota | 38081 | 8 | 0 |
365459 | 365459 | 2020-07-24 | Sargent | North Dakota | 38081 | 9 | 0 |
368668 | 368668 | 2020-07-25 | Sargent | North Dakota | 38081 | 8 | 0 |
371880 | 371880 | 2020-07-26 | Sargent | North Dakota | 38081 | 8 | 0 |
375092 | 375092 | 2020-07-27 | Sargent | North Dakota | 38081 | 8 | 0 |
378309 | 378309 | 2020-07-28 | Sargent | North Dakota | 38081 | 8 | 0 |
381526 | 381526 | 2020-07-29 | Sargent | North Dakota | 38081 | 8 | 0 |
384744 | 384744 | 2020-07-30 | Sargent | North Dakota | 38081 | 9 | 0 |
387961 | 387961 | 2020-07-31 | Sargent | North Dakota | 38081 | 8 | 0 |
391178 | 391178 | 2020-08-01 | Sargent | North Dakota | 38081 | 8 | 0 |
394394 | 394394 | 2020-08-02 | Sargent | North Dakota | 38081 | 8 | 0 |
397611 | 397611 | 2020-08-03 | Sargent | North Dakota | 38081 | 9 | 0 |
400826 | 400826 | 2020-08-04 | Sargent | North Dakota | 38081 | 11 | 0 |
404044 | 404044 | 2020-08-05 | Sargent | North Dakota | 38081 | 10 | 0 |
407263 | 407263 | 2020-08-06 | Sargent | North Dakota | 38081 | 10 | 0 |
410483 | 410483 | 2020-08-07 | Sargent | North Dakota | 38081 | 11 | 0 |
413703 | 413703 | 2020-08-08 | Sargent | North Dakota | 38081 | 11 | 0 |
416924 | 416924 | 2020-08-09 | Sargent | North Dakota | 38081 | 10 | 0 |
420144 | 420144 | 2020-08-10 | Sargent | North Dakota | 38081 | 10 | 0 |
423367 | 423367 | 2020-08-11 | Sargent | North Dakota | 38081 | 10 | 0 |
426590 | 426590 | 2020-08-12 | Sargent | North Dakota | 38081 | 10 | 0 |
429815 | 429815 | 2020-08-13 | Sargent | North Dakota | 38081 | 10 | 0 |
433041 | 433041 | 2020-08-14 | Sargent | North Dakota | 38081 | 10 | 0 |
436267 | 436267 | 2020-08-15 | Sargent | North Dakota | 38081 | 10 | 0 |
439492 | 439492 | 2020-08-16 | Sargent | North Dakota | 38081 | 10 | 0 |
442719 | 442719 | 2020-08-17 | Sargent | North Dakota | 38081 | 10 | 0 |
445945 | 445945 | 2020-08-18 | Sargent | North Dakota | 38081 | 10 | 0 |
449173 | 449173 | 2020-08-19 | Sargent | North Dakota | 38081 | 10 | 0 |
452401 | 452401 | 2020-08-20 | Sargent | North Dakota | 38081 | 10 | 0 |
455629 | 455629 | 2020-08-21 | Sargent | North Dakota | 38081 | 10 | 0 |
458857 | 458857 | 2020-08-22 | Sargent | North Dakota | 38081 | 10 | 0 |
462085 | 462085 | 2020-08-23 | Sargent | North Dakota | 38081 | 10 | 0 |
465314 | 465314 | 2020-08-24 | Sargent | North Dakota | 38081 | 10 | 0 |
468542 | 468542 | 2020-08-25 | Sargent | North Dakota | 38081 | 12 | 0 |
471774 | 471774 | 2020-08-26 | Sargent | North Dakota | 38081 | 13 | 0 |
475008 | 475008 | 2020-08-27 | Sargent | North Dakota | 38081 | 13 | 0 |
478241 | 478241 | 2020-08-28 | Sargent | North Dakota | 38081 | 15 | 0 |
481474 | 481474 | 2020-08-29 | Sargent | North Dakota | 38081 | 15 | 0 |
484709 | 484709 | 2020-08-30 | Sargent | North Dakota | 38081 | 15 | 0 |
487942 | 487942 | 2020-08-31 | Sargent | North Dakota | 38081 | 17 | 0 |
491175 | 491175 | 2020-09-01 | Sargent | North Dakota | 38081 | 16 | 0 |
494409 | 494409 | 2020-09-02 | Sargent | North Dakota | 38081 | 18 | 0 |
497642 | 497642 | 2020-09-03 | Sargent | North Dakota | 38081 | 18 | 0 |
500876 | 500876 | 2020-09-04 | Sargent | North Dakota | 38081 | 18 | 0 |
504110 | 504110 | 2020-09-05 | Sargent | North Dakota | 38081 | 19 | 0 |
507342 | 507342 | 2020-09-06 | Sargent | North Dakota | 38081 | 19 | 0 |
510575 | 510575 | 2020-09-07 | Sargent | North Dakota | 38081 | 20 | 0 |
513808 | 513808 | 2020-09-08 | Sargent | North Dakota | 38081 | 20 | 0 |
517043 | 517043 | 2020-09-09 | Sargent | North Dakota | 38081 | 25 | 0 |
520279 | 520279 | 2020-09-10 | Sargent | North Dakota | 38081 | 28 | 0 |
523515 | 523515 | 2020-09-11 | Sargent | North Dakota | 38081 | 29 | 0 |
526751 | 526751 | 2020-09-12 | Sargent | North Dakota | 38081 | 29 | 0 |
529988 | 529988 | 2020-09-13 | Sargent | North Dakota | 38081 | 29 | 0 |
533223 | 533223 | 2020-09-14 | Sargent | North Dakota | 38081 | 30 | 0 |
536459 | 536459 | 2020-09-15 | Sargent | North Dakota | 38081 | 32 | 0 |
539696 | 539696 | 2020-09-16 | Sargent | North Dakota | 38081 | 36 | 0 |
542932 | 542932 | 2020-09-17 | Sargent | North Dakota | 38081 | 40 | 0 |
546169 | 546169 | 2020-09-18 | Sargent | North Dakota | 38081 | 44 | 0 |
549408 | 549408 | 2020-09-19 | Sargent | North Dakota | 38081 | 49 | 0 |
552647 | 552647 | 2020-09-20 | Sargent | North Dakota | 38081 | 55 | 0 |
555884 | 555884 | 2020-09-21 | Sargent | North Dakota | 38081 | 56 | 0 |
559121 | 559121 | 2020-09-22 | Sargent | North Dakota | 38081 | 56 | 0 |
562358 | 562358 | 2020-09-23 | Sargent | North Dakota | 38081 | 58 | 0 |
565599 | 565599 | 2020-09-24 | Sargent | North Dakota | 38081 | 62 | 0 |
568840 | 568840 | 2020-09-25 | Sargent | North Dakota | 38081 | 71 | 0 |
572082 | 572082 | 2020-09-26 | Sargent | North Dakota | 38081 | 73 | 0 |
575326 | 575326 | 2020-09-27 | Sargent | North Dakota | 38081 | 74 | 0 |
578567 | 578567 | 2020-09-28 | Sargent | North Dakota | 38081 | 74 | 0 |
581807 | 581807 | 2020-09-29 | Sargent | North Dakota | 38081 | 76 | 0 |
585048 | 585048 | 2020-09-30 | Sargent | North Dakota | 38081 | 76 | 0 |
588288 | 588288 | 2020-10-01 | Sargent | North Dakota | 38081 | 79 | 0 |
591529 | 591529 | 2020-10-02 | Sargent | North Dakota | 38081 | 81 | 0 |
594770 | 594770 | 2020-10-03 | Sargent | North Dakota | 38081 | 83 | 1 |
598013 | 598013 | 2020-10-04 | Sargent | North Dakota | 38081 | 85 | 1 |
601256 | 601256 | 2020-10-05 | Sargent | North Dakota | 38081 | 85 | 1 |
604498 | 604498 | 2020-10-06 | Sargent | North Dakota | 38081 | 86 | 1 |
607741 | 607741 | 2020-10-07 | Sargent | North Dakota | 38081 | 91 | 1 |
610983 | 610983 | 2020-10-08 | Sargent | North Dakota | 38081 | 93 | 1 |
614224 | 614224 | 2020-10-09 | Sargent | North Dakota | 38081 | 92 | 1 |
617466 | 617466 | 2020-10-10 | Sargent | North Dakota | 38081 | 94 | 1 |
620708 | 620708 | 2020-10-11 | Sargent | North Dakota | 38081 | 95 | 1 |
623951 | 623951 | 2020-10-12 | Sargent | North Dakota | 38081 | 97 | 1 |
627193 | 627193 | 2020-10-13 | Sargent | North Dakota | 38081 | 101 | 1 |
630437 | 630437 | 2020-10-14 | Sargent | North Dakota | 38081 | 103 | 1 |
633682 | 633682 | 2020-10-15 | Sargent | North Dakota | 38081 | 103 | 2 |
636928 | 636928 | 2020-10-16 | Sargent | North Dakota | 38081 | 105 | 2 |
640174 | 640174 | 2020-10-17 | Sargent | North Dakota | 38081 | 105 | 2 |
643422 | 643422 | 2020-10-18 | Sargent | North Dakota | 38081 | 112 | 2 |
646668 | 646668 | 2020-10-19 | Sargent | North Dakota | 38081 | 112 | 2 |
649912 | 649912 | 2020-10-20 | Sargent | North Dakota | 38081 | 115 | 2 |
653157 | 653157 | 2020-10-21 | Sargent | North Dakota | 38081 | 117 | 2 |
656402 | 656402 | 2020-10-22 | Sargent | North Dakota | 38081 | 121 | 2 |
659646 | 659646 | 2020-10-23 | Sargent | North Dakota | 38081 | 123 | 2 |
662890 | 662890 | 2020-10-24 | Sargent | North Dakota | 38081 | 126 | 2 |
666135 | 666135 | 2020-10-25 | Sargent | North Dakota | 38081 | 128 | 2 |
669379 | 669379 | 2020-10-26 | Sargent | North Dakota | 38081 | 129 | 2 |
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);