ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Divide" 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 |
---|---|---|---|---|---|---|---|
782903 | 782903 | 2020-11-30 | Divide | North Dakota | 38023 | 126 | 1 |
779657 | 779657 | 2020-11-29 | Divide | North Dakota | 38023 | 126 | 1 |
776412 | 776412 | 2020-11-28 | Divide | North Dakota | 38023 | 122 | 1 |
773167 | 773167 | 2020-11-27 | Divide | North Dakota | 38023 | 121 | 1 |
769922 | 769922 | 2020-11-26 | Divide | North Dakota | 38023 | 121 | 1 |
766676 | 766676 | 2020-11-25 | Divide | North Dakota | 38023 | 120 | 1 |
763431 | 763431 | 2020-11-24 | Divide | North Dakota | 38023 | 118 | 1 |
760186 | 760186 | 2020-11-23 | Divide | North Dakota | 38023 | 117 | 1 |
756940 | 756940 | 2020-11-22 | Divide | North Dakota | 38023 | 117 | 1 |
753693 | 753693 | 2020-11-21 | Divide | North Dakota | 38023 | 117 | 1 |
750447 | 750447 | 2020-11-20 | Divide | North Dakota | 38023 | 115 | 1 |
747201 | 747201 | 2020-11-19 | Divide | North Dakota | 38023 | 115 | 1 |
743955 | 743955 | 2020-11-18 | Divide | North Dakota | 38023 | 114 | 1 |
740708 | 740708 | 2020-11-17 | Divide | North Dakota | 38023 | 109 | 1 |
737463 | 737463 | 2020-11-16 | Divide | North Dakota | 38023 | 106 | 1 |
734219 | 734219 | 2020-11-15 | Divide | North Dakota | 38023 | 105 | 1 |
730973 | 730973 | 2020-11-14 | Divide | North Dakota | 38023 | 104 | 1 |
727729 | 727729 | 2020-11-13 | Divide | North Dakota | 38023 | 101 | 1 |
724485 | 724485 | 2020-11-12 | Divide | North Dakota | 38023 | 98 | 1 |
721242 | 721242 | 2020-11-11 | Divide | North Dakota | 38023 | 97 | 1 |
717999 | 717999 | 2020-11-10 | Divide | North Dakota | 38023 | 96 | 1 |
714756 | 714756 | 2020-11-09 | Divide | North Dakota | 38023 | 92 | 1 |
711512 | 711512 | 2020-11-08 | Divide | North Dakota | 38023 | 91 | 1 |
708268 | 708268 | 2020-11-07 | Divide | North Dakota | 38023 | 91 | 1 |
705025 | 705025 | 2020-11-06 | Divide | North Dakota | 38023 | 86 | 1 |
701782 | 701782 | 2020-11-05 | Divide | North Dakota | 38023 | 86 | 1 |
698538 | 698538 | 2020-11-04 | Divide | North Dakota | 38023 | 83 | 1 |
695295 | 695295 | 2020-11-03 | Divide | North Dakota | 38023 | 75 | 1 |
692053 | 692053 | 2020-11-02 | Divide | North Dakota | 38023 | 71 | 1 |
688809 | 688809 | 2020-11-01 | Divide | North Dakota | 38023 | 71 | 1 |
685564 | 685564 | 2020-10-31 | Divide | North Dakota | 38023 | 70 | 1 |
682321 | 682321 | 2020-10-30 | Divide | North Dakota | 38023 | 68 | 1 |
679078 | 679078 | 2020-10-29 | Divide | North Dakota | 38023 | 62 | 1 |
675835 | 675835 | 2020-10-28 | Divide | North Dakota | 38023 | 62 | 1 |
672592 | 672592 | 2020-10-27 | Divide | North Dakota | 38023 | 60 | 1 |
669350 | 669350 | 2020-10-26 | Divide | North Dakota | 38023 | 54 | 1 |
666106 | 666106 | 2020-10-25 | Divide | North Dakota | 38023 | 53 | 1 |
662861 | 662861 | 2020-10-24 | Divide | North Dakota | 38023 | 47 | 1 |
659617 | 659617 | 2020-10-23 | Divide | North Dakota | 38023 | 47 | 1 |
656373 | 656373 | 2020-10-22 | Divide | North Dakota | 38023 | 45 | 1 |
653128 | 653128 | 2020-10-21 | Divide | North Dakota | 38023 | 45 | 1 |
649883 | 649883 | 2020-10-20 | Divide | North Dakota | 38023 | 45 | 1 |
646639 | 646639 | 2020-10-19 | Divide | North Dakota | 38023 | 41 | 1 |
643393 | 643393 | 2020-10-18 | Divide | North Dakota | 38023 | 41 | 1 |
640145 | 640145 | 2020-10-17 | Divide | North Dakota | 38023 | 41 | 1 |
636899 | 636899 | 2020-10-16 | Divide | North Dakota | 38023 | 37 | 1 |
633653 | 633653 | 2020-10-15 | Divide | North Dakota | 38023 | 34 | 1 |
630408 | 630408 | 2020-10-14 | Divide | North Dakota | 38023 | 32 | 1 |
627164 | 627164 | 2020-10-13 | Divide | North Dakota | 38023 | 29 | 1 |
623922 | 623922 | 2020-10-12 | Divide | North Dakota | 38023 | 24 | 1 |
620679 | 620679 | 2020-10-11 | Divide | North Dakota | 38023 | 24 | 1 |
617437 | 617437 | 2020-10-10 | Divide | North Dakota | 38023 | 24 | 1 |
614195 | 614195 | 2020-10-09 | Divide | North Dakota | 38023 | 22 | 1 |
610954 | 610954 | 2020-10-08 | Divide | North Dakota | 38023 | 21 | 1 |
607712 | 607712 | 2020-10-07 | Divide | North Dakota | 38023 | 18 | 1 |
604469 | 604469 | 2020-10-06 | Divide | North Dakota | 38023 | 11 | 1 |
601227 | 601227 | 2020-10-05 | Divide | North Dakota | 38023 | 9 | 1 |
597984 | 597984 | 2020-10-04 | Divide | North Dakota | 38023 | 9 | 1 |
594741 | 594741 | 2020-10-03 | Divide | North Dakota | 38023 | 9 | 1 |
591500 | 591500 | 2020-10-02 | Divide | North Dakota | 38023 | 9 | 1 |
588259 | 588259 | 2020-10-01 | Divide | North Dakota | 38023 | 8 | 1 |
585019 | 585019 | 2020-09-30 | Divide | North Dakota | 38023 | 8 | 0 |
581778 | 581778 | 2020-09-29 | Divide | North Dakota | 38023 | 8 | 0 |
578538 | 578538 | 2020-09-28 | Divide | North Dakota | 38023 | 7 | 0 |
575297 | 575297 | 2020-09-27 | Divide | North Dakota | 38023 | 7 | 0 |
572053 | 572053 | 2020-09-26 | Divide | North Dakota | 38023 | 7 | 0 |
568811 | 568811 | 2020-09-25 | Divide | North Dakota | 38023 | 7 | 0 |
565570 | 565570 | 2020-09-24 | Divide | North Dakota | 38023 | 7 | 0 |
562329 | 562329 | 2020-09-23 | Divide | North Dakota | 38023 | 6 | 0 |
559092 | 559092 | 2020-09-22 | Divide | North Dakota | 38023 | 6 | 0 |
555855 | 555855 | 2020-09-21 | Divide | North Dakota | 38023 | 6 | 0 |
552618 | 552618 | 2020-09-20 | Divide | North Dakota | 38023 | 6 | 0 |
549379 | 549379 | 2020-09-19 | Divide | North Dakota | 38023 | 6 | 0 |
546140 | 546140 | 2020-09-18 | Divide | North Dakota | 38023 | 6 | 0 |
542903 | 542903 | 2020-09-17 | Divide | North Dakota | 38023 | 6 | 0 |
539667 | 539667 | 2020-09-16 | Divide | North Dakota | 38023 | 6 | 0 |
536430 | 536430 | 2020-09-15 | Divide | North Dakota | 38023 | 6 | 0 |
533194 | 533194 | 2020-09-14 | Divide | North Dakota | 38023 | 6 | 0 |
529959 | 529959 | 2020-09-13 | Divide | North Dakota | 38023 | 6 | 0 |
526722 | 526722 | 2020-09-12 | Divide | North Dakota | 38023 | 6 | 0 |
523486 | 523486 | 2020-09-11 | Divide | North Dakota | 38023 | 6 | 0 |
520250 | 520250 | 2020-09-10 | Divide | North Dakota | 38023 | 6 | 0 |
517014 | 517014 | 2020-09-09 | Divide | North Dakota | 38023 | 6 | 0 |
513779 | 513779 | 2020-09-08 | Divide | North Dakota | 38023 | 6 | 0 |
510546 | 510546 | 2020-09-07 | Divide | North Dakota | 38023 | 6 | 0 |
507313 | 507313 | 2020-09-06 | Divide | North Dakota | 38023 | 6 | 0 |
504081 | 504081 | 2020-09-05 | Divide | North Dakota | 38023 | 5 | 0 |
500847 | 500847 | 2020-09-04 | Divide | North Dakota | 38023 | 5 | 0 |
497613 | 497613 | 2020-09-03 | Divide | North Dakota | 38023 | 5 | 0 |
494380 | 494380 | 2020-09-02 | Divide | North Dakota | 38023 | 5 | 0 |
491146 | 491146 | 2020-09-01 | Divide | North Dakota | 38023 | 5 | 0 |
487913 | 487913 | 2020-08-31 | Divide | North Dakota | 38023 | 5 | 0 |
484680 | 484680 | 2020-08-30 | Divide | North Dakota | 38023 | 5 | 0 |
481445 | 481445 | 2020-08-29 | Divide | North Dakota | 38023 | 5 | 0 |
478212 | 478212 | 2020-08-28 | Divide | North Dakota | 38023 | 5 | 0 |
474979 | 474979 | 2020-08-27 | Divide | North Dakota | 38023 | 5 | 0 |
471745 | 471745 | 2020-08-26 | Divide | North Dakota | 38023 | 5 | 0 |
468513 | 468513 | 2020-08-25 | Divide | North Dakota | 38023 | 5 | 0 |
465285 | 465285 | 2020-08-24 | Divide | North Dakota | 38023 | 5 | 0 |
462056 | 462056 | 2020-08-23 | Divide | North Dakota | 38023 | 5 | 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);