ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where county = "Dewey" and deaths = 1 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
818752 | 818752 | 2020-12-11 | Dewey | Oklahoma | 40043 | 320 | 1 |
815506 | 815506 | 2020-12-10 | Dewey | Oklahoma | 40043 | 312 | 1 |
812260 | 812260 | 2020-12-09 | Dewey | Oklahoma | 40043 | 304 | 1 |
809016 | 809016 | 2020-12-08 | Dewey | Oklahoma | 40043 | 294 | 1 |
805771 | 805771 | 2020-12-07 | Dewey | Oklahoma | 40043 | 287 | 1 |
802526 | 802526 | 2020-12-06 | Dewey | Oklahoma | 40043 | 285 | 1 |
799281 | 799281 | 2020-12-05 | Dewey | Oklahoma | 40043 | 274 | 1 |
796036 | 796036 | 2020-12-04 | Dewey | Oklahoma | 40043 | 268 | 1 |
792791 | 792791 | 2020-12-03 | Dewey | Oklahoma | 40043 | 250 | 1 |
789546 | 789546 | 2020-12-02 | Dewey | Oklahoma | 40043 | 241 | 1 |
786301 | 786301 | 2020-12-01 | Dewey | Oklahoma | 40043 | 237 | 1 |
783057 | 783057 | 2020-11-30 | Dewey | Oklahoma | 40043 | 236 | 1 |
779811 | 779811 | 2020-11-29 | Dewey | Oklahoma | 40043 | 226 | 1 |
776566 | 776566 | 2020-11-28 | Dewey | Oklahoma | 40043 | 223 | 1 |
773321 | 773321 | 2020-11-27 | Dewey | Oklahoma | 40043 | 215 | 1 |
770076 | 770076 | 2020-11-26 | Dewey | Oklahoma | 40043 | 198 | 1 |
766830 | 766830 | 2020-11-25 | Dewey | Oklahoma | 40043 | 198 | 1 |
763585 | 763585 | 2020-11-24 | Dewey | Oklahoma | 40043 | 172 | 1 |
760340 | 760340 | 2020-11-23 | Dewey | Oklahoma | 40043 | 172 | 1 |
757095 | 757095 | 2020-11-22 | Dewey | Oklahoma | 40043 | 163 | 1 |
753848 | 753848 | 2020-11-21 | Dewey | Oklahoma | 40043 | 161 | 1 |
750602 | 750602 | 2020-11-20 | Dewey | Oklahoma | 40043 | 158 | 1 |
747356 | 747356 | 2020-11-19 | Dewey | Oklahoma | 40043 | 152 | 1 |
744110 | 744110 | 2020-11-18 | Dewey | Oklahoma | 40043 | 148 | 1 |
740863 | 740863 | 2020-11-17 | Dewey | Oklahoma | 40043 | 142 | 1 |
737617 | 737617 | 2020-11-16 | Dewey | Oklahoma | 40043 | 142 | 1 |
734373 | 734373 | 2020-11-15 | Dewey | Oklahoma | 40043 | 138 | 1 |
731127 | 731127 | 2020-11-14 | Dewey | Oklahoma | 40043 | 127 | 1 |
727883 | 727883 | 2020-11-13 | Dewey | Oklahoma | 40043 | 122 | 1 |
724639 | 724639 | 2020-11-12 | Dewey | Oklahoma | 40043 | 120 | 1 |
721396 | 721396 | 2020-11-11 | Dewey | Oklahoma | 40043 | 119 | 1 |
718153 | 718153 | 2020-11-10 | Dewey | Oklahoma | 40043 | 117 | 1 |
714910 | 714910 | 2020-11-09 | Dewey | Oklahoma | 40043 | 112 | 1 |
711666 | 711666 | 2020-11-08 | Dewey | Oklahoma | 40043 | 109 | 1 |
708422 | 708422 | 2020-11-07 | Dewey | Oklahoma | 40043 | 109 | 1 |
705179 | 705179 | 2020-11-06 | Dewey | Oklahoma | 40043 | 97 | 1 |
701936 | 701936 | 2020-11-05 | Dewey | Oklahoma | 40043 | 95 | 1 |
702246 | 702246 | 2020-11-05 | Dewey | South Dakota | 46041 | 460 | 1 |
698692 | 698692 | 2020-11-04 | Dewey | Oklahoma | 40043 | 95 | 1 |
699002 | 699002 | 2020-11-04 | Dewey | South Dakota | 46041 | 439 | 1 |
695449 | 695449 | 2020-11-03 | Dewey | Oklahoma | 40043 | 95 | 1 |
695759 | 695759 | 2020-11-03 | Dewey | South Dakota | 46041 | 427 | 1 |
692207 | 692207 | 2020-11-02 | Dewey | Oklahoma | 40043 | 95 | 1 |
688963 | 688963 | 2020-11-01 | Dewey | Oklahoma | 40043 | 94 | 1 |
685718 | 685718 | 2020-10-31 | Dewey | Oklahoma | 40043 | 94 | 1 |
682475 | 682475 | 2020-10-30 | Dewey | Oklahoma | 40043 | 94 | 1 |
679232 | 679232 | 2020-10-29 | Dewey | Oklahoma | 40043 | 94 | 1 |
675989 | 675989 | 2020-10-28 | Dewey | Oklahoma | 40043 | 93 | 1 |
672746 | 672746 | 2020-10-27 | Dewey | Oklahoma | 40043 | 93 | 1 |
669504 | 669504 | 2020-10-26 | Dewey | Oklahoma | 40043 | 92 | 1 |
666260 | 666260 | 2020-10-25 | Dewey | Oklahoma | 40043 | 93 | 1 |
663015 | 663015 | 2020-10-24 | Dewey | Oklahoma | 40043 | 93 | 1 |
659771 | 659771 | 2020-10-23 | Dewey | Oklahoma | 40043 | 89 | 1 |
656527 | 656527 | 2020-10-22 | Dewey | Oklahoma | 40043 | 88 | 1 |
653282 | 653282 | 2020-10-21 | Dewey | Oklahoma | 40043 | 83 | 1 |
650037 | 650037 | 2020-10-20 | Dewey | Oklahoma | 40043 | 81 | 1 |
646793 | 646793 | 2020-10-19 | Dewey | Oklahoma | 40043 | 79 | 1 |
643547 | 643547 | 2020-10-18 | Dewey | Oklahoma | 40043 | 78 | 1 |
640299 | 640299 | 2020-10-17 | Dewey | Oklahoma | 40043 | 78 | 1 |
637053 | 637053 | 2020-10-16 | Dewey | Oklahoma | 40043 | 77 | 1 |
633807 | 633807 | 2020-10-15 | Dewey | Oklahoma | 40043 | 76 | 1 |
630562 | 630562 | 2020-10-14 | Dewey | Oklahoma | 40043 | 76 | 1 |
627318 | 627318 | 2020-10-13 | Dewey | Oklahoma | 40043 | 76 | 1 |
624076 | 624076 | 2020-10-12 | Dewey | Oklahoma | 40043 | 75 | 1 |
620833 | 620833 | 2020-10-11 | Dewey | Oklahoma | 40043 | 75 | 1 |
617591 | 617591 | 2020-10-10 | Dewey | Oklahoma | 40043 | 75 | 1 |
614349 | 614349 | 2020-10-09 | Dewey | Oklahoma | 40043 | 75 | 1 |
611108 | 611108 | 2020-10-08 | Dewey | Oklahoma | 40043 | 74 | 1 |
607866 | 607866 | 2020-10-07 | Dewey | Oklahoma | 40043 | 73 | 1 |
604623 | 604623 | 2020-10-06 | Dewey | Oklahoma | 40043 | 73 | 1 |
601381 | 601381 | 2020-10-05 | Dewey | Oklahoma | 40043 | 72 | 1 |
598138 | 598138 | 2020-10-04 | Dewey | Oklahoma | 40043 | 72 | 1 |
594895 | 594895 | 2020-10-03 | Dewey | Oklahoma | 40043 | 71 | 1 |
591654 | 591654 | 2020-10-02 | Dewey | Oklahoma | 40043 | 70 | 1 |
588413 | 588413 | 2020-10-01 | Dewey | Oklahoma | 40043 | 69 | 1 |
585173 | 585173 | 2020-09-30 | Dewey | Oklahoma | 40043 | 68 | 1 |
581933 | 581933 | 2020-09-29 | Dewey | Oklahoma | 40043 | 68 | 1 |
578693 | 578693 | 2020-09-28 | Dewey | Oklahoma | 40043 | 67 | 1 |
575452 | 575452 | 2020-09-27 | Dewey | Oklahoma | 40043 | 67 | 1 |
572208 | 572208 | 2020-09-26 | Dewey | Oklahoma | 40043 | 66 | 1 |
568966 | 568966 | 2020-09-25 | Dewey | Oklahoma | 40043 | 66 | 1 |
565725 | 565725 | 2020-09-24 | Dewey | Oklahoma | 40043 | 63 | 1 |
562484 | 562484 | 2020-09-23 | Dewey | Oklahoma | 40043 | 63 | 1 |
559247 | 559247 | 2020-09-22 | Dewey | Oklahoma | 40043 | 60 | 1 |
556010 | 556010 | 2020-09-21 | Dewey | Oklahoma | 40043 | 60 | 1 |
552773 | 552773 | 2020-09-20 | Dewey | Oklahoma | 40043 | 59 | 1 |
549534 | 549534 | 2020-09-19 | Dewey | Oklahoma | 40043 | 58 | 1 |
546295 | 546295 | 2020-09-18 | Dewey | Oklahoma | 40043 | 55 | 1 |
543058 | 543058 | 2020-09-17 | Dewey | Oklahoma | 40043 | 54 | 1 |
539822 | 539822 | 2020-09-16 | Dewey | Oklahoma | 40043 | 51 | 1 |
536585 | 536585 | 2020-09-15 | Dewey | Oklahoma | 40043 | 45 | 1 |
533349 | 533349 | 2020-09-14 | Dewey | Oklahoma | 40043 | 44 | 1 |
530114 | 530114 | 2020-09-13 | Dewey | Oklahoma | 40043 | 39 | 1 |
526877 | 526877 | 2020-09-12 | Dewey | Oklahoma | 40043 | 32 | 1 |
523641 | 523641 | 2020-09-11 | Dewey | Oklahoma | 40043 | 29 | 1 |
520405 | 520405 | 2020-09-10 | Dewey | Oklahoma | 40043 | 27 | 1 |
517169 | 517169 | 2020-09-09 | Dewey | Oklahoma | 40043 | 26 | 1 |
513934 | 513934 | 2020-09-08 | Dewey | Oklahoma | 40043 | 24 | 1 |
510701 | 510701 | 2020-09-07 | Dewey | Oklahoma | 40043 | 24 | 1 |
507468 | 507468 | 2020-09-06 | Dewey | Oklahoma | 40043 | 24 | 1 |
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);