ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 38089 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
782936 | 782936 | 2020-11-30 | Stark | North Dakota | 38089 | 3612 | 39 |
779690 | 779690 | 2020-11-29 | Stark | North Dakota | 38089 | 3582 | 39 |
776445 | 776445 | 2020-11-28 | Stark | North Dakota | 38089 | 3542 | 39 |
773200 | 773200 | 2020-11-27 | Stark | North Dakota | 38089 | 3498 | 39 |
769955 | 769955 | 2020-11-26 | Stark | North Dakota | 38089 | 3471 | 39 |
766709 | 766709 | 2020-11-25 | Stark | North Dakota | 38089 | 3436 | 39 |
763464 | 763464 | 2020-11-24 | Stark | North Dakota | 38089 | 3416 | 39 |
760219 | 760219 | 2020-11-23 | Stark | North Dakota | 38089 | 3383 | 39 |
756973 | 756973 | 2020-11-22 | Stark | North Dakota | 38089 | 3344 | 39 |
753726 | 753726 | 2020-11-21 | Stark | North Dakota | 38089 | 3283 | 39 |
750480 | 750480 | 2020-11-20 | Stark | North Dakota | 38089 | 3234 | 38 |
747234 | 747234 | 2020-11-19 | Stark | North Dakota | 38089 | 3182 | 37 |
743988 | 743988 | 2020-11-18 | Stark | North Dakota | 38089 | 3106 | 37 |
740741 | 740741 | 2020-11-17 | Stark | North Dakota | 38089 | 3091 | 38 |
737496 | 737496 | 2020-11-16 | Stark | North Dakota | 38089 | 3065 | 37 |
734252 | 734252 | 2020-11-15 | Stark | North Dakota | 38089 | 3012 | 36 |
731006 | 731006 | 2020-11-14 | Stark | North Dakota | 38089 | 2970 | 36 |
727762 | 727762 | 2020-11-13 | Stark | North Dakota | 38089 | 2814 | 35 |
724518 | 724518 | 2020-11-12 | Stark | North Dakota | 38089 | 2802 | 35 |
721275 | 721275 | 2020-11-11 | Stark | North Dakota | 38089 | 2777 | 35 |
718032 | 718032 | 2020-11-10 | Stark | North Dakota | 38089 | 2766 | 35 |
714789 | 714789 | 2020-11-09 | Stark | North Dakota | 38089 | 2732 | 35 |
711545 | 711545 | 2020-11-08 | Stark | North Dakota | 38089 | 2711 | 35 |
708301 | 708301 | 2020-11-07 | Stark | North Dakota | 38089 | 2671 | 35 |
705058 | 705058 | 2020-11-06 | Stark | North Dakota | 38089 | 2613 | 35 |
701815 | 701815 | 2020-11-05 | Stark | North Dakota | 38089 | 2586 | 35 |
698571 | 698571 | 2020-11-04 | Stark | North Dakota | 38089 | 2523 | 35 |
695328 | 695328 | 2020-11-03 | Stark | North Dakota | 38089 | 2508 | 35 |
692086 | 692086 | 2020-11-02 | Stark | North Dakota | 38089 | 2498 | 34 |
688842 | 688842 | 2020-11-01 | Stark | North Dakota | 38089 | 2473 | 34 |
685597 | 685597 | 2020-10-31 | Stark | North Dakota | 38089 | 2438 | 34 |
682354 | 682354 | 2020-10-30 | Stark | North Dakota | 38089 | 2410 | 34 |
679111 | 679111 | 2020-10-29 | Stark | North Dakota | 38089 | 2350 | 34 |
675868 | 675868 | 2020-10-28 | Stark | North Dakota | 38089 | 2342 | 34 |
672625 | 672625 | 2020-10-27 | Stark | North Dakota | 38089 | 2328 | 34 |
669383 | 669383 | 2020-10-26 | Stark | North Dakota | 38089 | 2317 | 34 |
666139 | 666139 | 2020-10-25 | Stark | North Dakota | 38089 | 2308 | 34 |
662894 | 662894 | 2020-10-24 | Stark | North Dakota | 38089 | 2294 | 34 |
659650 | 659650 | 2020-10-23 | Stark | North Dakota | 38089 | 2275 | 34 |
656406 | 656406 | 2020-10-22 | Stark | North Dakota | 38089 | 2234 | 30 |
653161 | 653161 | 2020-10-21 | Stark | North Dakota | 38089 | 2233 | 30 |
649916 | 649916 | 2020-10-20 | Stark | North Dakota | 38089 | 2207 | 30 |
646672 | 646672 | 2020-10-19 | Stark | North Dakota | 38089 | 2189 | 29 |
643426 | 643426 | 2020-10-18 | Stark | North Dakota | 38089 | 2181 | 29 |
640178 | 640178 | 2020-10-17 | Stark | North Dakota | 38089 | 2168 | 29 |
636932 | 636932 | 2020-10-16 | Stark | North Dakota | 38089 | 2131 | 28 |
633686 | 633686 | 2020-10-15 | Stark | North Dakota | 38089 | 2105 | 25 |
630441 | 630441 | 2020-10-14 | Stark | North Dakota | 38089 | 2089 | 25 |
627197 | 627197 | 2020-10-13 | Stark | North Dakota | 38089 | 2064 | 25 |
623955 | 623955 | 2020-10-12 | Stark | North Dakota | 38089 | 2060 | 25 |
620712 | 620712 | 2020-10-11 | Stark | North Dakota | 38089 | 2001 | 25 |
617470 | 617470 | 2020-10-10 | Stark | North Dakota | 38089 | 1997 | 24 |
614228 | 614228 | 2020-10-09 | Stark | North Dakota | 38089 | 1983 | 22 |
610987 | 610987 | 2020-10-08 | Stark | North Dakota | 38089 | 1926 | 21 |
607745 | 607745 | 2020-10-07 | Stark | North Dakota | 38089 | 1877 | 20 |
604502 | 604502 | 2020-10-06 | Stark | North Dakota | 38089 | 1862 | 20 |
601260 | 601260 | 2020-10-05 | Stark | North Dakota | 38089 | 1836 | 18 |
598017 | 598017 | 2020-10-04 | Stark | North Dakota | 38089 | 1825 | 17 |
594774 | 594774 | 2020-10-03 | Stark | North Dakota | 38089 | 1792 | 16 |
591533 | 591533 | 2020-10-02 | Stark | North Dakota | 38089 | 1698 | 14 |
588292 | 588292 | 2020-10-01 | Stark | North Dakota | 38089 | 1682 | 14 |
585052 | 585052 | 2020-09-30 | Stark | North Dakota | 38089 | 1664 | 14 |
581811 | 581811 | 2020-09-29 | Stark | North Dakota | 38089 | 1659 | 14 |
578571 | 578571 | 2020-09-28 | Stark | North Dakota | 38089 | 1639 | 14 |
575330 | 575330 | 2020-09-27 | Stark | North Dakota | 38089 | 1616 | 14 |
572086 | 572086 | 2020-09-26 | Stark | North Dakota | 38089 | 1585 | 13 |
568844 | 568844 | 2020-09-25 | Stark | North Dakota | 38089 | 1523 | 10 |
565603 | 565603 | 2020-09-24 | Stark | North Dakota | 38089 | 1422 | 7 |
562362 | 562362 | 2020-09-23 | Stark | North Dakota | 38089 | 1391 | 7 |
559125 | 559125 | 2020-09-22 | Stark | North Dakota | 38089 | 1366 | 6 |
555888 | 555888 | 2020-09-21 | Stark | North Dakota | 38089 | 1348 | 6 |
552651 | 552651 | 2020-09-20 | Stark | North Dakota | 38089 | 1331 | 6 |
549412 | 549412 | 2020-09-19 | Stark | North Dakota | 38089 | 1297 | 6 |
546173 | 546173 | 2020-09-18 | Stark | North Dakota | 38089 | 1248 | 6 |
542936 | 542936 | 2020-09-17 | Stark | North Dakota | 38089 | 1193 | 6 |
539700 | 539700 | 2020-09-16 | Stark | North Dakota | 38089 | 1129 | 6 |
536463 | 536463 | 2020-09-15 | Stark | North Dakota | 38089 | 1120 | 6 |
533227 | 533227 | 2020-09-14 | Stark | North Dakota | 38089 | 1115 | 6 |
529992 | 529992 | 2020-09-13 | Stark | North Dakota | 38089 | 1080 | 6 |
526755 | 526755 | 2020-09-12 | Stark | North Dakota | 38089 | 1045 | 6 |
523519 | 523519 | 2020-09-11 | Stark | North Dakota | 38089 | 995 | 6 |
520283 | 520283 | 2020-09-10 | Stark | North Dakota | 38089 | 989 | 6 |
517047 | 517047 | 2020-09-09 | Stark | North Dakota | 38089 | 922 | 6 |
513812 | 513812 | 2020-09-08 | Stark | North Dakota | 38089 | 896 | 6 |
510579 | 510579 | 2020-09-07 | Stark | North Dakota | 38089 | 895 | 6 |
507346 | 507346 | 2020-09-06 | Stark | North Dakota | 38089 | 891 | 6 |
504114 | 504114 | 2020-09-05 | Stark | North Dakota | 38089 | 880 | 6 |
500880 | 500880 | 2020-09-04 | Stark | North Dakota | 38089 | 862 | 6 |
497646 | 497646 | 2020-09-03 | Stark | North Dakota | 38089 | 819 | 6 |
494413 | 494413 | 2020-09-02 | Stark | North Dakota | 38089 | 751 | 6 |
491179 | 491179 | 2020-09-01 | Stark | North Dakota | 38089 | 740 | 6 |
487946 | 487946 | 2020-08-31 | Stark | North Dakota | 38089 | 687 | 6 |
484713 | 484713 | 2020-08-30 | Stark | North Dakota | 38089 | 677 | 6 |
481478 | 481478 | 2020-08-29 | Stark | North Dakota | 38089 | 669 | 6 |
478245 | 478245 | 2020-08-28 | Stark | North Dakota | 38089 | 659 | 6 |
475012 | 475012 | 2020-08-27 | Stark | North Dakota | 38089 | 611 | 6 |
471778 | 471778 | 2020-08-26 | Stark | North Dakota | 38089 | 556 | 6 |
468546 | 468546 | 2020-08-25 | Stark | North Dakota | 38089 | 553 | 6 |
465318 | 465318 | 2020-08-24 | Stark | North Dakota | 38089 | 544 | 6 |
462089 | 462089 | 2020-08-23 | Stark | North Dakota | 38089 | 523 | 6 |
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);