ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Washington" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922761 | 922761 | 2021-01-12 | Washington | Pennsylvania | 42125 | 10648 | 164 |
919516 | 919516 | 2021-01-11 | Washington | Pennsylvania | 42125 | 10515 | 157 |
916271 | 916271 | 2021-01-10 | Washington | Pennsylvania | 42125 | 10433 | 156 |
913026 | 913026 | 2021-01-09 | Washington | Pennsylvania | 42125 | 10353 | 156 |
909781 | 909781 | 2021-01-08 | Washington | Pennsylvania | 42125 | 10121 | 152 |
906536 | 906536 | 2021-01-07 | Washington | Pennsylvania | 42125 | 9900 | 148 |
903290 | 903290 | 2021-01-06 | Washington | Pennsylvania | 42125 | 9774 | 144 |
900045 | 900045 | 2021-01-05 | Washington | Pennsylvania | 42125 | 9567 | 138 |
896800 | 896800 | 2021-01-04 | Washington | Pennsylvania | 42125 | 9462 | 138 |
893554 | 893554 | 2021-01-03 | Washington | Pennsylvania | 42125 | 9345 | 137 |
890308 | 890308 | 2021-01-02 | Washington | Pennsylvania | 42125 | 9278 | 136 |
887061 | 887061 | 2021-01-01 | Washington | Pennsylvania | 42125 | 9084 | 135 |
883816 | 883816 | 2020-12-31 | Washington | Pennsylvania | 42125 | 8947 | 131 |
880571 | 880571 | 2020-12-30 | Washington | Pennsylvania | 42125 | 8798 | 128 |
877326 | 877326 | 2020-12-29 | Washington | Pennsylvania | 42125 | 8727 | 122 |
874081 | 874081 | 2020-12-28 | Washington | Pennsylvania | 42125 | 8438 | 122 |
870836 | 870836 | 2020-12-27 | Washington | Pennsylvania | 42125 | 8390 | 120 |
867591 | 867591 | 2020-12-26 | Washington | Pennsylvania | 42125 | 8336 | 121 |
864346 | 864346 | 2020-12-25 | Washington | Pennsylvania | 42125 | 8264 | 121 |
861101 | 861101 | 2020-12-24 | Washington | Pennsylvania | 42125 | 8150 | 120 |
857856 | 857856 | 2020-12-23 | Washington | Pennsylvania | 42125 | 7974 | 119 |
854611 | 854611 | 2020-12-22 | Washington | Pennsylvania | 42125 | 7824 | 116 |
851366 | 851366 | 2020-12-21 | Washington | Pennsylvania | 42125 | 7681 | 112 |
848121 | 848121 | 2020-12-20 | Washington | Pennsylvania | 42125 | 7522 | 110 |
844876 | 844876 | 2020-12-19 | Washington | Pennsylvania | 42125 | 7471 | 110 |
841630 | 841630 | 2020-12-18 | Washington | Pennsylvania | 42125 | 7252 | 108 |
838385 | 838385 | 2020-12-17 | Washington | Pennsylvania | 42125 | 7153 | 106 |
835139 | 835139 | 2020-12-16 | Washington | Pennsylvania | 42125 | 7018 | 103 |
831893 | 831893 | 2020-12-15 | Washington | Pennsylvania | 42125 | 6878 | 100 |
828646 | 828646 | 2020-12-14 | Washington | Pennsylvania | 42125 | 6662 | 95 |
825400 | 825400 | 2020-12-13 | Washington | Pennsylvania | 42125 | 6554 | 93 |
822153 | 822153 | 2020-12-12 | Washington | Pennsylvania | 42125 | 6430 | 92 |
818907 | 818907 | 2020-12-11 | Washington | Pennsylvania | 42125 | 6224 | 88 |
815661 | 815661 | 2020-12-10 | Washington | Pennsylvania | 42125 | 5930 | 85 |
812415 | 812415 | 2020-12-09 | Washington | Pennsylvania | 42125 | 5789 | 81 |
809171 | 809171 | 2020-12-08 | Washington | Pennsylvania | 42125 | 5677 | 80 |
805926 | 805926 | 2020-12-07 | Washington | Pennsylvania | 42125 | 5546 | 77 |
802681 | 802681 | 2020-12-06 | Washington | Pennsylvania | 42125 | 5464 | 76 |
799436 | 799436 | 2020-12-05 | Washington | Pennsylvania | 42125 | 5348 | 75 |
796191 | 796191 | 2020-12-04 | Washington | Pennsylvania | 42125 | 5115 | 75 |
792946 | 792946 | 2020-12-03 | Washington | Pennsylvania | 42125 | 4987 | 73 |
789701 | 789701 | 2020-12-02 | Washington | Pennsylvania | 42125 | 4802 | 73 |
786456 | 786456 | 2020-12-01 | Washington | Pennsylvania | 42125 | 4721 | 71 |
783212 | 783212 | 2020-11-30 | Washington | Pennsylvania | 42125 | 4609 | 71 |
779967 | 779967 | 2020-11-29 | Washington | Pennsylvania | 42125 | 4545 | 70 |
776721 | 776721 | 2020-11-28 | Washington | Pennsylvania | 42125 | 4511 | 70 |
773476 | 773476 | 2020-11-27 | Washington | Pennsylvania | 42125 | 4372 | 70 |
770231 | 770231 | 2020-11-26 | Washington | Pennsylvania | 42125 | 4237 | 70 |
766985 | 766985 | 2020-11-25 | Washington | Pennsylvania | 42125 | 4121 | 69 |
763740 | 763740 | 2020-11-24 | Washington | Pennsylvania | 42125 | 4020 | 67 |
760495 | 760495 | 2020-11-23 | Washington | Pennsylvania | 42125 | 3886 | 63 |
757250 | 757250 | 2020-11-22 | Washington | Pennsylvania | 42125 | 3767 | 63 |
754003 | 754003 | 2020-11-21 | Washington | Pennsylvania | 42125 | 3713 | 62 |
750757 | 750757 | 2020-11-20 | Washington | Pennsylvania | 42125 | 3596 | 58 |
747511 | 747511 | 2020-11-19 | Washington | Pennsylvania | 42125 | 3493 | 56 |
744265 | 744265 | 2020-11-18 | Washington | Pennsylvania | 42125 | 3340 | 53 |
741018 | 741018 | 2020-11-17 | Washington | Pennsylvania | 42125 | 3223 | 50 |
737772 | 737772 | 2020-11-16 | Washington | Pennsylvania | 42125 | 3106 | 50 |
734528 | 734528 | 2020-11-15 | Washington | Pennsylvania | 42125 | 3036 | 50 |
731282 | 731282 | 2020-11-14 | Washington | Pennsylvania | 42125 | 2928 | 49 |
728038 | 728038 | 2020-11-13 | Washington | Pennsylvania | 42125 | 2877 | 44 |
724794 | 724794 | 2020-11-12 | Washington | Pennsylvania | 42125 | 2791 | 44 |
721551 | 721551 | 2020-11-11 | Washington | Pennsylvania | 42125 | 2693 | 44 |
718308 | 718308 | 2020-11-10 | Washington | Pennsylvania | 42125 | 2636 | 42 |
715065 | 715065 | 2020-11-09 | Washington | Pennsylvania | 42125 | 2556 | 41 |
711821 | 711821 | 2020-11-08 | Washington | Pennsylvania | 42125 | 2489 | 41 |
708577 | 708577 | 2020-11-07 | Washington | Pennsylvania | 42125 | 2454 | 41 |
705334 | 705334 | 2020-11-06 | Washington | Pennsylvania | 42125 | 2399 | 41 |
702091 | 702091 | 2020-11-05 | Washington | Pennsylvania | 42125 | 2346 | 40 |
698847 | 698847 | 2020-11-04 | Washington | Pennsylvania | 42125 | 2281 | 37 |
695604 | 695604 | 2020-11-03 | Washington | Pennsylvania | 42125 | 2233 | 37 |
692362 | 692362 | 2020-11-02 | Washington | Pennsylvania | 42125 | 2188 | 37 |
689118 | 689118 | 2020-11-01 | Washington | Pennsylvania | 42125 | 2153 | 37 |
685873 | 685873 | 2020-10-31 | Washington | Pennsylvania | 42125 | 2136 | 37 |
682630 | 682630 | 2020-10-30 | Washington | Pennsylvania | 42125 | 2098 | 35 |
679387 | 679387 | 2020-10-29 | Washington | Pennsylvania | 42125 | 2024 | 35 |
676144 | 676144 | 2020-10-28 | Washington | Pennsylvania | 42125 | 1986 | 34 |
672901 | 672901 | 2020-10-27 | Washington | Pennsylvania | 42125 | 1945 | 34 |
669659 | 669659 | 2020-10-26 | Washington | Pennsylvania | 42125 | 1881 | 34 |
666415 | 666415 | 2020-10-25 | Washington | Pennsylvania | 42125 | 1860 | 34 |
663170 | 663170 | 2020-10-24 | Washington | Pennsylvania | 42125 | 1847 | 34 |
659926 | 659926 | 2020-10-23 | Washington | Pennsylvania | 42125 | 1818 | 34 |
656682 | 656682 | 2020-10-22 | Washington | Pennsylvania | 42125 | 1754 | 34 |
653437 | 653437 | 2020-10-21 | Washington | Pennsylvania | 42125 | 1718 | 34 |
650192 | 650192 | 2020-10-20 | Washington | Pennsylvania | 42125 | 1699 | 32 |
646948 | 646948 | 2020-10-19 | Washington | Pennsylvania | 42125 | 1675 | 32 |
643702 | 643702 | 2020-10-18 | Washington | Pennsylvania | 42125 | 1654 | 32 |
640454 | 640454 | 2020-10-17 | Washington | Pennsylvania | 42125 | 1625 | 32 |
637208 | 637208 | 2020-10-16 | Washington | Pennsylvania | 42125 | 1594 | 32 |
633962 | 633962 | 2020-10-15 | Washington | Pennsylvania | 42125 | 1577 | 31 |
630717 | 630717 | 2020-10-14 | Washington | Pennsylvania | 42125 | 1563 | 31 |
627473 | 627473 | 2020-10-13 | Washington | Pennsylvania | 42125 | 1556 | 31 |
624231 | 624231 | 2020-10-12 | Washington | Pennsylvania | 42125 | 1538 | 31 |
620988 | 620988 | 2020-10-11 | Washington | Pennsylvania | 42125 | 1520 | 30 |
617745 | 617745 | 2020-10-10 | Washington | Pennsylvania | 42125 | 1507 | 30 |
614503 | 614503 | 2020-10-09 | Washington | Pennsylvania | 42125 | 1494 | 30 |
611262 | 611262 | 2020-10-08 | Washington | Pennsylvania | 42125 | 1484 | 30 |
608020 | 608020 | 2020-10-07 | Washington | Pennsylvania | 42125 | 1469 | 30 |
604777 | 604777 | 2020-10-06 | Washington | Pennsylvania | 42125 | 1465 | 30 |
601535 | 601535 | 2020-10-05 | Washington | Pennsylvania | 42125 | 1449 | 30 |
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);