ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where county = "Cowlitz", deaths = 7 and state = "Washington" 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 |
---|---|---|---|---|---|---|---|
715804 | 715804 | 2020-11-09 | Cowlitz | Washington | 53015 | 928 | 7 |
712560 | 712560 | 2020-11-08 | Cowlitz | Washington | 53015 | 915 | 7 |
709316 | 709316 | 2020-11-07 | Cowlitz | Washington | 53015 | 904 | 7 |
706072 | 706072 | 2020-11-06 | Cowlitz | Washington | 53015 | 896 | 7 |
702829 | 702829 | 2020-11-05 | Cowlitz | Washington | 53015 | 875 | 7 |
699586 | 699586 | 2020-11-04 | Cowlitz | Washington | 53015 | 864 | 7 |
696342 | 696342 | 2020-11-03 | Cowlitz | Washington | 53015 | 849 | 7 |
693100 | 693100 | 2020-11-02 | Cowlitz | Washington | 53015 | 840 | 7 |
689856 | 689856 | 2020-11-01 | Cowlitz | Washington | 53015 | 832 | 7 |
686611 | 686611 | 2020-10-31 | Cowlitz | Washington | 53015 | 831 | 7 |
683368 | 683368 | 2020-10-30 | Cowlitz | Washington | 53015 | 823 | 7 |
680125 | 680125 | 2020-10-29 | Cowlitz | Washington | 53015 | 817 | 7 |
676882 | 676882 | 2020-10-28 | Cowlitz | Washington | 53015 | 807 | 7 |
673639 | 673639 | 2020-10-27 | Cowlitz | Washington | 53015 | 803 | 7 |
670397 | 670397 | 2020-10-26 | Cowlitz | Washington | 53015 | 798 | 7 |
667154 | 667154 | 2020-10-25 | Cowlitz | Washington | 53015 | 797 | 7 |
663909 | 663909 | 2020-10-24 | Cowlitz | Washington | 53015 | 795 | 7 |
660665 | 660665 | 2020-10-23 | Cowlitz | Washington | 53015 | 792 | 7 |
657421 | 657421 | 2020-10-22 | Cowlitz | Washington | 53015 | 779 | 7 |
654176 | 654176 | 2020-10-21 | Cowlitz | Washington | 53015 | 776 | 7 |
650931 | 650931 | 2020-10-20 | Cowlitz | Washington | 53015 | 773 | 7 |
647687 | 647687 | 2020-10-19 | Cowlitz | Washington | 53015 | 766 | 7 |
644441 | 644441 | 2020-10-18 | Cowlitz | Washington | 53015 | 761 | 7 |
641193 | 641193 | 2020-10-17 | Cowlitz | Washington | 53015 | 759 | 7 |
637946 | 637946 | 2020-10-16 | Cowlitz | Washington | 53015 | 754 | 7 |
634701 | 634701 | 2020-10-15 | Cowlitz | Washington | 53015 | 744 | 7 |
631456 | 631456 | 2020-10-14 | Cowlitz | Washington | 53015 | 736 | 7 |
628212 | 628212 | 2020-10-13 | Cowlitz | Washington | 53015 | 734 | 7 |
624969 | 624969 | 2020-10-12 | Cowlitz | Washington | 53015 | 719 | 7 |
621726 | 621726 | 2020-10-11 | Cowlitz | Washington | 53015 | 719 | 7 |
618483 | 618483 | 2020-10-10 | Cowlitz | Washington | 53015 | 719 | 7 |
615241 | 615241 | 2020-10-09 | Cowlitz | Washington | 53015 | 716 | 7 |
612000 | 612000 | 2020-10-08 | Cowlitz | Washington | 53015 | 715 | 7 |
608758 | 608758 | 2020-10-07 | Cowlitz | Washington | 53015 | 712 | 7 |
605515 | 605515 | 2020-10-06 | Cowlitz | Washington | 53015 | 711 | 7 |
602273 | 602273 | 2020-10-05 | Cowlitz | Washington | 53015 | 704 | 7 |
599030 | 599030 | 2020-10-04 | Cowlitz | Washington | 53015 | 701 | 7 |
595787 | 595787 | 2020-10-03 | Cowlitz | Washington | 53015 | 695 | 7 |
592545 | 592545 | 2020-10-02 | Cowlitz | Washington | 53015 | 690 | 7 |
589305 | 589305 | 2020-10-01 | Cowlitz | Washington | 53015 | 688 | 7 |
586064 | 586064 | 2020-09-30 | Cowlitz | Washington | 53015 | 684 | 7 |
582824 | 582824 | 2020-09-29 | Cowlitz | Washington | 53015 | 679 | 7 |
579585 | 579585 | 2020-09-28 | Cowlitz | Washington | 53015 | 661 | 7 |
576344 | 576344 | 2020-09-27 | Cowlitz | Washington | 53015 | 659 | 7 |
573100 | 573100 | 2020-09-26 | Cowlitz | Washington | 53015 | 660 | 7 |
569858 | 569858 | 2020-09-25 | Cowlitz | Washington | 53015 | 657 | 7 |
446960 | 446960 | 2020-08-18 | Cowlitz | Washington | 53015 | 510 | 7 |
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);