ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Grant" and fips = 38037 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
737470 | 737470 | 2020-11-16 | Grant | North Dakota | 38037 | 118 | 4 |
734226 | 734226 | 2020-11-15 | Grant | North Dakota | 38037 | 118 | 4 |
730980 | 730980 | 2020-11-14 | Grant | North Dakota | 38037 | 116 | 4 |
727736 | 727736 | 2020-11-13 | Grant | North Dakota | 38037 | 113 | 4 |
724492 | 724492 | 2020-11-12 | Grant | North Dakota | 38037 | 112 | 4 |
721249 | 721249 | 2020-11-11 | Grant | North Dakota | 38037 | 107 | 4 |
718006 | 718006 | 2020-11-10 | Grant | North Dakota | 38037 | 107 | 4 |
714763 | 714763 | 2020-11-09 | Grant | North Dakota | 38037 | 104 | 4 |
711519 | 711519 | 2020-11-08 | Grant | North Dakota | 38037 | 98 | 4 |
708275 | 708275 | 2020-11-07 | Grant | North Dakota | 38037 | 96 | 4 |
705032 | 705032 | 2020-11-06 | Grant | North Dakota | 38037 | 94 | 4 |
701789 | 701789 | 2020-11-05 | Grant | North Dakota | 38037 | 93 | 4 |
698545 | 698545 | 2020-11-04 | Grant | North Dakota | 38037 | 90 | 4 |
695302 | 695302 | 2020-11-03 | Grant | North Dakota | 38037 | 86 | 4 |
692060 | 692060 | 2020-11-02 | Grant | North Dakota | 38037 | 85 | 4 |
688816 | 688816 | 2020-11-01 | Grant | North Dakota | 38037 | 84 | 4 |
685571 | 685571 | 2020-10-31 | Grant | North Dakota | 38037 | 83 | 4 |
682328 | 682328 | 2020-10-30 | Grant | North Dakota | 38037 | 78 | 4 |
679085 | 679085 | 2020-10-29 | Grant | North Dakota | 38037 | 76 | 3 |
675842 | 675842 | 2020-10-28 | Grant | North Dakota | 38037 | 71 | 3 |
672599 | 672599 | 2020-10-27 | Grant | North Dakota | 38037 | 70 | 3 |
669357 | 669357 | 2020-10-26 | Grant | North Dakota | 38037 | 67 | 3 |
666113 | 666113 | 2020-10-25 | Grant | North Dakota | 38037 | 66 | 3 |
662868 | 662868 | 2020-10-24 | Grant | North Dakota | 38037 | 66 | 3 |
659624 | 659624 | 2020-10-23 | Grant | North Dakota | 38037 | 62 | 3 |
656380 | 656380 | 2020-10-22 | Grant | North Dakota | 38037 | 60 | 3 |
653135 | 653135 | 2020-10-21 | Grant | North Dakota | 38037 | 58 | 2 |
649890 | 649890 | 2020-10-20 | Grant | North Dakota | 38037 | 56 | 2 |
646646 | 646646 | 2020-10-19 | Grant | North Dakota | 38037 | 57 | 2 |
643400 | 643400 | 2020-10-18 | Grant | North Dakota | 38037 | 56 | 2 |
640152 | 640152 | 2020-10-17 | Grant | North Dakota | 38037 | 55 | 2 |
636906 | 636906 | 2020-10-16 | Grant | North Dakota | 38037 | 55 | 1 |
633660 | 633660 | 2020-10-15 | Grant | North Dakota | 38037 | 54 | 1 |
630415 | 630415 | 2020-10-14 | Grant | North Dakota | 38037 | 53 | 1 |
627171 | 627171 | 2020-10-13 | Grant | North Dakota | 38037 | 50 | 1 |
623929 | 623929 | 2020-10-12 | Grant | North Dakota | 38037 | 50 | 1 |
620686 | 620686 | 2020-10-11 | Grant | North Dakota | 38037 | 50 | 1 |
617444 | 617444 | 2020-10-10 | Grant | North Dakota | 38037 | 47 | 1 |
614202 | 614202 | 2020-10-09 | Grant | North Dakota | 38037 | 44 | 1 |
610961 | 610961 | 2020-10-08 | Grant | North Dakota | 38037 | 43 | 1 |
607719 | 607719 | 2020-10-07 | Grant | North Dakota | 38037 | 43 | 1 |
604476 | 604476 | 2020-10-06 | Grant | North Dakota | 38037 | 41 | 1 |
601234 | 601234 | 2020-10-05 | Grant | North Dakota | 38037 | 40 | 1 |
597991 | 597991 | 2020-10-04 | Grant | North Dakota | 38037 | 37 | 1 |
594748 | 594748 | 2020-10-03 | Grant | North Dakota | 38037 | 36 | 1 |
591507 | 591507 | 2020-10-02 | Grant | North Dakota | 38037 | 33 | 1 |
588266 | 588266 | 2020-10-01 | Grant | North Dakota | 38037 | 30 | 1 |
585026 | 585026 | 2020-09-30 | Grant | North Dakota | 38037 | 29 | 1 |
581785 | 581785 | 2020-09-29 | Grant | North Dakota | 38037 | 25 | 1 |
578545 | 578545 | 2020-09-28 | Grant | North Dakota | 38037 | 21 | 0 |
575304 | 575304 | 2020-09-27 | Grant | North Dakota | 38037 | 21 | 0 |
572060 | 572060 | 2020-09-26 | Grant | North Dakota | 38037 | 19 | 0 |
568818 | 568818 | 2020-09-25 | Grant | North Dakota | 38037 | 17 | 0 |
565577 | 565577 | 2020-09-24 | Grant | North Dakota | 38037 | 16 | 0 |
562336 | 562336 | 2020-09-23 | Grant | North Dakota | 38037 | 15 | 0 |
559099 | 559099 | 2020-09-22 | Grant | North Dakota | 38037 | 12 | 0 |
555862 | 555862 | 2020-09-21 | Grant | North Dakota | 38037 | 12 | 0 |
552625 | 552625 | 2020-09-20 | Grant | North Dakota | 38037 | 12 | 0 |
549386 | 549386 | 2020-09-19 | Grant | North Dakota | 38037 | 11 | 0 |
546147 | 546147 | 2020-09-18 | Grant | North Dakota | 38037 | 11 | 0 |
542910 | 542910 | 2020-09-17 | Grant | North Dakota | 38037 | 11 | 0 |
539674 | 539674 | 2020-09-16 | Grant | North Dakota | 38037 | 11 | 0 |
536437 | 536437 | 2020-09-15 | Grant | North Dakota | 38037 | 11 | 0 |
533201 | 533201 | 2020-09-14 | Grant | North Dakota | 38037 | 9 | 0 |
529966 | 529966 | 2020-09-13 | Grant | North Dakota | 38037 | 9 | 0 |
526729 | 526729 | 2020-09-12 | Grant | North Dakota | 38037 | 9 | 0 |
523493 | 523493 | 2020-09-11 | Grant | North Dakota | 38037 | 9 | 0 |
520257 | 520257 | 2020-09-10 | Grant | North Dakota | 38037 | 9 | 0 |
517021 | 517021 | 2020-09-09 | Grant | North Dakota | 38037 | 9 | 0 |
513786 | 513786 | 2020-09-08 | Grant | North Dakota | 38037 | 9 | 0 |
510553 | 510553 | 2020-09-07 | Grant | North Dakota | 38037 | 9 | 0 |
507320 | 507320 | 2020-09-06 | Grant | North Dakota | 38037 | 9 | 0 |
504088 | 504088 | 2020-09-05 | Grant | North Dakota | 38037 | 9 | 0 |
500854 | 500854 | 2020-09-04 | Grant | North Dakota | 38037 | 9 | 0 |
497620 | 497620 | 2020-09-03 | Grant | North Dakota | 38037 | 9 | 0 |
494387 | 494387 | 2020-09-02 | Grant | North Dakota | 38037 | 9 | 0 |
491153 | 491153 | 2020-09-01 | Grant | North Dakota | 38037 | 9 | 0 |
487920 | 487920 | 2020-08-31 | Grant | North Dakota | 38037 | 9 | 0 |
484687 | 484687 | 2020-08-30 | Grant | North Dakota | 38037 | 9 | 0 |
481452 | 481452 | 2020-08-29 | Grant | North Dakota | 38037 | 9 | 0 |
478219 | 478219 | 2020-08-28 | Grant | North Dakota | 38037 | 9 | 0 |
474986 | 474986 | 2020-08-27 | Grant | North Dakota | 38037 | 9 | 0 |
471752 | 471752 | 2020-08-26 | Grant | North Dakota | 38037 | 9 | 0 |
468520 | 468520 | 2020-08-25 | Grant | North Dakota | 38037 | 9 | 0 |
465292 | 465292 | 2020-08-24 | Grant | North Dakota | 38037 | 9 | 0 |
462063 | 462063 | 2020-08-23 | Grant | North Dakota | 38037 | 9 | 0 |
458835 | 458835 | 2020-08-22 | Grant | North Dakota | 38037 | 8 | 0 |
455607 | 455607 | 2020-08-21 | Grant | North Dakota | 38037 | 5 | 0 |
452379 | 452379 | 2020-08-20 | Grant | North Dakota | 38037 | 4 | 0 |
449151 | 449151 | 2020-08-19 | Grant | North Dakota | 38037 | 4 | 0 |
445923 | 445923 | 2020-08-18 | Grant | North Dakota | 38037 | 4 | 0 |
442697 | 442697 | 2020-08-17 | Grant | North Dakota | 38037 | 4 | 0 |
439470 | 439470 | 2020-08-16 | Grant | North Dakota | 38037 | 4 | 0 |
436245 | 436245 | 2020-08-15 | Grant | North Dakota | 38037 | 4 | 0 |
433019 | 433019 | 2020-08-14 | Grant | North Dakota | 38037 | 4 | 0 |
429793 | 429793 | 2020-08-13 | Grant | North Dakota | 38037 | 4 | 0 |
426568 | 426568 | 2020-08-12 | Grant | North Dakota | 38037 | 4 | 0 |
423345 | 423345 | 2020-08-11 | Grant | North Dakota | 38037 | 4 | 0 |
420122 | 420122 | 2020-08-10 | Grant | North Dakota | 38037 | 4 | 0 |
416902 | 416902 | 2020-08-09 | Grant | North Dakota | 38037 | 4 | 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);