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 |
---|---|---|---|---|---|---|---|
1088285 | 1088285 | 2021-03-04 | Washington | Pennsylvania | 42125 | 13833 | 261 |
1085040 | 1085040 | 2021-03-03 | Washington | Pennsylvania | 42125 | 13795 | 260 |
1081794 | 1081794 | 2021-03-02 | Washington | Pennsylvania | 42125 | 13766 | 258 |
1078548 | 1078548 | 2021-03-01 | Washington | Pennsylvania | 42125 | 13727 | 258 |
1075303 | 1075303 | 2021-02-28 | Washington | Pennsylvania | 42125 | 13701 | 258 |
1072057 | 1072057 | 2021-02-27 | Washington | Pennsylvania | 42125 | 13687 | 257 |
1068811 | 1068811 | 2021-02-26 | Washington | Pennsylvania | 42125 | 13664 | 257 |
1065566 | 1065566 | 2021-02-25 | Washington | Pennsylvania | 42125 | 13621 | 258 |
1062321 | 1062321 | 2021-02-24 | Washington | Pennsylvania | 42125 | 13607 | 257 |
1059076 | 1059076 | 2021-02-23 | Washington | Pennsylvania | 42125 | 13574 | 257 |
1055830 | 1055830 | 2021-02-22 | Washington | Pennsylvania | 42125 | 13544 | 257 |
1052584 | 1052584 | 2021-02-21 | Washington | Pennsylvania | 42125 | 13534 | 256 |
1049337 | 1049337 | 2021-02-20 | Washington | Pennsylvania | 42125 | 13493 | 254 |
1046090 | 1046090 | 2021-02-19 | Washington | Pennsylvania | 42125 | 13462 | 250 |
1042845 | 1042845 | 2021-02-18 | Washington | Pennsylvania | 42125 | 13430 | 249 |
1039600 | 1039600 | 2021-02-17 | Washington | Pennsylvania | 42125 | 13395 | 248 |
1036355 | 1036355 | 2021-02-16 | Washington | Pennsylvania | 42125 | 13362 | 246 |
1033110 | 1033110 | 2021-02-15 | Washington | Pennsylvania | 42125 | 13311 | 246 |
1029864 | 1029864 | 2021-02-14 | Washington | Pennsylvania | 42125 | 13278 | 246 |
1026617 | 1026617 | 2021-02-13 | Washington | Pennsylvania | 42125 | 13246 | 246 |
1023372 | 1023372 | 2021-02-12 | Washington | Pennsylvania | 42125 | 13198 | 244 |
1020127 | 1020127 | 2021-02-11 | Washington | Pennsylvania | 42125 | 13150 | 242 |
1016882 | 1016882 | 2021-02-10 | Washington | Pennsylvania | 42125 | 13116 | 240 |
1013637 | 1013637 | 2021-02-09 | Washington | Pennsylvania | 42125 | 13082 | 240 |
1010392 | 1010392 | 2021-02-08 | Washington | Pennsylvania | 42125 | 13028 | 238 |
1007146 | 1007146 | 2021-02-07 | Washington | Pennsylvania | 42125 | 13003 | 245 |
1003900 | 1003900 | 2021-02-06 | Washington | Pennsylvania | 42125 | 12949 | 242 |
1000654 | 1000654 | 2021-02-05 | Washington | Pennsylvania | 42125 | 12874 | 237 |
997408 | 997408 | 2021-02-04 | Washington | Pennsylvania | 42125 | 12812 | 235 |
994162 | 994162 | 2021-02-03 | Washington | Pennsylvania | 42125 | 12741 | 234 |
990916 | 990916 | 2021-02-02 | Washington | Pennsylvania | 42125 | 12682 | 228 |
987670 | 987670 | 2021-02-01 | Washington | Pennsylvania | 42125 | 12596 | 226 |
984423 | 984423 | 2021-01-31 | Washington | Pennsylvania | 42125 | 12562 | 225 |
981176 | 981176 | 2021-01-30 | Washington | Pennsylvania | 42125 | 12531 | 223 |
977930 | 977930 | 2021-01-29 | Washington | Pennsylvania | 42125 | 12452 | 222 |
974685 | 974685 | 2021-01-28 | Washington | Pennsylvania | 42125 | 12348 | 216 |
971440 | 971440 | 2021-01-27 | Washington | Pennsylvania | 42125 | 12267 | 207 |
968195 | 968195 | 2021-01-26 | Washington | Pennsylvania | 42125 | 12163 | 204 |
964951 | 964951 | 2021-01-25 | Washington | Pennsylvania | 42125 | 12090 | 199 |
961706 | 961706 | 2021-01-24 | Washington | Pennsylvania | 42125 | 11996 | 199 |
958461 | 958461 | 2021-01-23 | Washington | Pennsylvania | 42125 | 11945 | 197 |
955215 | 955215 | 2021-01-22 | Washington | Pennsylvania | 42125 | 11822 | 190 |
951970 | 951970 | 2021-01-21 | Washington | Pennsylvania | 42125 | 11771 | 181 |
948725 | 948725 | 2021-01-20 | Washington | Pennsylvania | 42125 | 11667 | 178 |
945479 | 945479 | 2021-01-19 | Washington | Pennsylvania | 42125 | 11556 | 172 |
942232 | 942232 | 2021-01-18 | Washington | Pennsylvania | 42125 | 11448 | 171 |
938987 | 938987 | 2021-01-17 | Washington | Pennsylvania | 42125 | 11384 | 170 |
935742 | 935742 | 2021-01-16 | Washington | Pennsylvania | 42125 | 11260 | 168 |
932497 | 932497 | 2021-01-15 | Washington | Pennsylvania | 42125 | 11148 | 168 |
929252 | 929252 | 2021-01-14 | Washington | Pennsylvania | 42125 | 11028 | 166 |
926007 | 926007 | 2021-01-13 | Washington | Pennsylvania | 42125 | 10831 | 165 |
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 |
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);