ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Washington" and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923340 | 923340 | 2021-01-12 | Washington | Utah | 49053 | 16524 | 131 |
920095 | 920095 | 2021-01-11 | Washington | Utah | 49053 | 16524 | 131 |
916850 | 916850 | 2021-01-10 | Washington | Utah | 49053 | 16184 | 129 |
913605 | 913605 | 2021-01-09 | Washington | Utah | 49053 | 16184 | 129 |
910360 | 910360 | 2021-01-08 | Washington | Utah | 49053 | 15973 | 129 |
907115 | 907115 | 2021-01-07 | Washington | Utah | 49053 | 15725 | 127 |
903869 | 903869 | 2021-01-06 | Washington | Utah | 49053 | 15521 | 124 |
900624 | 900624 | 2021-01-05 | Washington | Utah | 49053 | 15283 | 122 |
897379 | 897379 | 2021-01-04 | Washington | Utah | 49053 | 14990 | 119 |
894133 | 894133 | 2021-01-03 | Washington | Utah | 49053 | 14887 | 114 |
890887 | 890887 | 2021-01-02 | Washington | Utah | 49053 | 14887 | 114 |
887640 | 887640 | 2021-01-01 | Washington | Utah | 49053 | 14765 | 111 |
884395 | 884395 | 2020-12-31 | Washington | Utah | 49053 | 14765 | 111 |
881150 | 881150 | 2020-12-30 | Washington | Utah | 49053 | 14492 | 110 |
877905 | 877905 | 2020-12-29 | Washington | Utah | 49053 | 14268 | 109 |
874660 | 874660 | 2020-12-28 | Washington | Utah | 49053 | 14126 | 107 |
871415 | 871415 | 2020-12-27 | Washington | Utah | 49053 | 13933 | 106 |
868170 | 868170 | 2020-12-26 | Washington | Utah | 49053 | 13933 | 106 |
864925 | 864925 | 2020-12-25 | Washington | Utah | 49053 | 13797 | 105 |
861680 | 861680 | 2020-12-24 | Washington | Utah | 49053 | 13797 | 105 |
858435 | 858435 | 2020-12-23 | Washington | Utah | 49053 | 13622 | 105 |
855190 | 855190 | 2020-12-22 | Washington | Utah | 49053 | 13415 | 105 |
851945 | 851945 | 2020-12-21 | Washington | Utah | 49053 | 13277 | 103 |
848700 | 848700 | 2020-12-20 | Washington | Utah | 49053 | 13018 | 100 |
845455 | 845455 | 2020-12-19 | Washington | Utah | 49053 | 13018 | 100 |
842209 | 842209 | 2020-12-18 | Washington | Utah | 49053 | 12837 | 100 |
838964 | 838964 | 2020-12-17 | Washington | Utah | 49053 | 12684 | 99 |
835718 | 835718 | 2020-12-16 | Washington | Utah | 49053 | 12475 | 98 |
832472 | 832472 | 2020-12-15 | Washington | Utah | 49053 | 12269 | 98 |
829225 | 829225 | 2020-12-14 | Washington | Utah | 49053 | 12150 | 95 |
825979 | 825979 | 2020-12-13 | Washington | Utah | 49053 | 11915 | 91 |
822732 | 822732 | 2020-12-12 | Washington | Utah | 49053 | 11915 | 91 |
819486 | 819486 | 2020-12-11 | Washington | Utah | 49053 | 11681 | 89 |
816240 | 816240 | 2020-12-10 | Washington | Utah | 49053 | 11546 | 88 |
812994 | 812994 | 2020-12-09 | Washington | Utah | 49053 | 11337 | 88 |
809750 | 809750 | 2020-12-08 | Washington | Utah | 49053 | 11141 | 85 |
806505 | 806505 | 2020-12-07 | Washington | Utah | 49053 | 10994 | 83 |
803260 | 803260 | 2020-12-06 | Washington | Utah | 49053 | 10726 | 81 |
800015 | 800015 | 2020-12-05 | Washington | Utah | 49053 | 10726 | 81 |
796770 | 796770 | 2020-12-04 | Washington | Utah | 49053 | 10504 | 80 |
793525 | 793525 | 2020-12-03 | Washington | Utah | 49053 | 10233 | 80 |
790280 | 790280 | 2020-12-02 | Washington | Utah | 49053 | 9978 | 79 |
787035 | 787035 | 2020-12-01 | Washington | Utah | 49053 | 9710 | 78 |
783791 | 783791 | 2020-11-30 | Washington | Utah | 49053 | 9550 | 76 |
780546 | 780546 | 2020-11-29 | Washington | Utah | 49053 | 9160 | 75 |
777300 | 777300 | 2020-11-28 | Washington | Utah | 49053 | 9160 | 75 |
774055 | 774055 | 2020-11-27 | Washington | Utah | 49053 | 8840 | 71 |
770810 | 770810 | 2020-11-26 | Washington | Utah | 49053 | 8840 | 71 |
767564 | 767564 | 2020-11-25 | Washington | Utah | 49053 | 8840 | 71 |
764319 | 764319 | 2020-11-24 | Washington | Utah | 49053 | 8719 | 68 |
761074 | 761074 | 2020-11-23 | Washington | Utah | 49053 | 8563 | 70 |
757829 | 757829 | 2020-11-22 | Washington | Utah | 49053 | 8318 | 67 |
754582 | 754582 | 2020-11-21 | Washington | Utah | 49053 | 8318 | 67 |
751336 | 751336 | 2020-11-20 | Washington | Utah | 49053 | 8059 | 66 |
748090 | 748090 | 2020-11-19 | Washington | Utah | 49053 | 7765 | 64 |
744844 | 744844 | 2020-11-18 | Washington | Utah | 49053 | 7615 | 60 |
741597 | 741597 | 2020-11-17 | Washington | Utah | 49053 | 7269 | 59 |
738350 | 738350 | 2020-11-16 | Washington | Utah | 49053 | 7134 | 58 |
735106 | 735106 | 2020-11-15 | Washington | Utah | 49053 | 6896 | 55 |
731860 | 731860 | 2020-11-14 | Washington | Utah | 49053 | 6896 | 55 |
728615 | 728615 | 2020-11-13 | Washington | Utah | 49053 | 6736 | 53 |
725372 | 725372 | 2020-11-12 | Washington | Utah | 49053 | 6558 | 52 |
722129 | 722129 | 2020-11-11 | Washington | Utah | 49053 | 6384 | 52 |
718886 | 718886 | 2020-11-10 | Washington | Utah | 49053 | 6300 | 52 |
715643 | 715643 | 2020-11-09 | Washington | Utah | 49053 | 5990 | 50 |
712399 | 712399 | 2020-11-08 | Washington | Utah | 49053 | 5951 | 49 |
709155 | 709155 | 2020-11-07 | Washington | Utah | 49053 | 5951 | 49 |
705911 | 705911 | 2020-11-06 | Washington | Utah | 49053 | 5836 | 49 |
702668 | 702668 | 2020-11-05 | Washington | Utah | 49053 | 5673 | 47 |
699425 | 699425 | 2020-11-04 | Washington | Utah | 49053 | 5555 | 47 |
696181 | 696181 | 2020-11-03 | Washington | Utah | 49053 | 5433 | 47 |
692939 | 692939 | 2020-11-02 | Washington | Utah | 49053 | 5333 | 47 |
689695 | 689695 | 2020-11-01 | Washington | Utah | 49053 | 5196 | 47 |
686450 | 686450 | 2020-10-31 | Washington | Utah | 49053 | 5196 | 47 |
683207 | 683207 | 2020-10-30 | Washington | Utah | 49053 | 5115 | 46 |
679964 | 679964 | 2020-10-29 | Washington | Utah | 49053 | 5024 | 46 |
676721 | 676721 | 2020-10-28 | Washington | Utah | 49053 | 4927 | 45 |
673478 | 673478 | 2020-10-27 | Washington | Utah | 49053 | 4843 | 45 |
670236 | 670236 | 2020-10-26 | Washington | Utah | 49053 | 4766 | 44 |
666993 | 666993 | 2020-10-25 | Washington | Utah | 49053 | 4608 | 41 |
663748 | 663748 | 2020-10-24 | Washington | Utah | 49053 | 4608 | 41 |
660504 | 660504 | 2020-10-23 | Washington | Utah | 49053 | 4536 | 41 |
657260 | 657260 | 2020-10-22 | Washington | Utah | 49053 | 4423 | 40 |
654015 | 654015 | 2020-10-21 | Washington | Utah | 49053 | 4364 | 40 |
650770 | 650770 | 2020-10-20 | Washington | Utah | 49053 | 4291 | 39 |
647526 | 647526 | 2020-10-19 | Washington | Utah | 49053 | 4252 | 39 |
644280 | 644280 | 2020-10-18 | Washington | Utah | 49053 | 4145 | 38 |
641032 | 641032 | 2020-10-17 | Washington | Utah | 49053 | 4145 | 38 |
637785 | 637785 | 2020-10-16 | Washington | Utah | 49053 | 4075 | 38 |
634540 | 634540 | 2020-10-15 | Washington | Utah | 49053 | 4034 | 38 |
631295 | 631295 | 2020-10-14 | Washington | Utah | 49053 | 3953 | 38 |
628051 | 628051 | 2020-10-13 | Washington | Utah | 49053 | 3932 | 38 |
624808 | 624808 | 2020-10-12 | Washington | Utah | 49053 | 3878 | 38 |
621565 | 621565 | 2020-10-11 | Washington | Utah | 49053 | 3791 | 35 |
618322 | 618322 | 2020-10-10 | Washington | Utah | 49053 | 3791 | 35 |
615080 | 615080 | 2020-10-09 | Washington | Utah | 49053 | 3726 | 34 |
611839 | 611839 | 2020-10-08 | Washington | Utah | 49053 | 3676 | 34 |
608597 | 608597 | 2020-10-07 | Washington | Utah | 49053 | 3652 | 33 |
605354 | 605354 | 2020-10-06 | Washington | Utah | 49053 | 3605 | 32 |
602112 | 602112 | 2020-10-05 | Washington | Utah | 49053 | 3576 | 32 |
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);