ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "York" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055834 | 1055834 | 2021-02-22 | York | Pennsylvania | 42133 | 35231 | 707 |
1052588 | 1052588 | 2021-02-21 | York | Pennsylvania | 42133 | 35185 | 707 |
1049341 | 1049341 | 2021-02-20 | York | Pennsylvania | 42133 | 35108 | 707 |
1046094 | 1046094 | 2021-02-19 | York | Pennsylvania | 42133 | 34976 | 703 |
1042849 | 1042849 | 2021-02-18 | York | Pennsylvania | 42133 | 34870 | 700 |
1039604 | 1039604 | 2021-02-17 | York | Pennsylvania | 42133 | 34721 | 698 |
1036359 | 1036359 | 2021-02-16 | York | Pennsylvania | 42133 | 34582 | 695 |
1033114 | 1033114 | 2021-02-15 | York | Pennsylvania | 42133 | 34504 | 695 |
1029868 | 1029868 | 2021-02-14 | York | Pennsylvania | 42133 | 34423 | 695 |
1026621 | 1026621 | 2021-02-13 | York | Pennsylvania | 42133 | 34254 | 695 |
1023376 | 1023376 | 2021-02-12 | York | Pennsylvania | 42133 | 34087 | 692 |
1020131 | 1020131 | 2021-02-11 | York | Pennsylvania | 42133 | 33946 | 688 |
1016886 | 1016886 | 2021-02-10 | York | Pennsylvania | 42133 | 33750 | 684 |
1013641 | 1013641 | 2021-02-09 | York | Pennsylvania | 42133 | 33618 | 672 |
1010396 | 1010396 | 2021-02-08 | York | Pennsylvania | 42133 | 33466 | 668 |
1007150 | 1007150 | 2021-02-07 | York | Pennsylvania | 42133 | 33314 | 667 |
1003904 | 1003904 | 2021-02-06 | York | Pennsylvania | 42133 | 33074 | 663 |
1000658 | 1000658 | 2021-02-05 | York | Pennsylvania | 42133 | 32858 | 657 |
997412 | 997412 | 2021-02-04 | York | Pennsylvania | 42133 | 32715 | 654 |
994166 | 994166 | 2021-02-03 | York | Pennsylvania | 42133 | 32578 | 646 |
990920 | 990920 | 2021-02-02 | York | Pennsylvania | 42133 | 32464 | 643 |
987674 | 987674 | 2021-02-01 | York | Pennsylvania | 42133 | 32263 | 635 |
984427 | 984427 | 2021-01-31 | York | Pennsylvania | 42133 | 32142 | 634 |
981180 | 981180 | 2021-01-30 | York | Pennsylvania | 42133 | 31889 | 634 |
977934 | 977934 | 2021-01-29 | York | Pennsylvania | 42133 | 31670 | 632 |
974689 | 974689 | 2021-01-28 | York | Pennsylvania | 42133 | 31218 | 630 |
971444 | 971444 | 2021-01-27 | York | Pennsylvania | 42133 | 30646 | 623 |
968199 | 968199 | 2021-01-26 | York | Pennsylvania | 42133 | 30363 | 616 |
964955 | 964955 | 2021-01-25 | York | Pennsylvania | 42133 | 30224 | 606 |
961710 | 961710 | 2021-01-24 | York | Pennsylvania | 42133 | 30002 | 604 |
958465 | 958465 | 2021-01-23 | York | Pennsylvania | 42133 | 29812 | 600 |
955219 | 955219 | 2021-01-22 | York | Pennsylvania | 42133 | 29618 | 585 |
951974 | 951974 | 2021-01-21 | York | Pennsylvania | 42133 | 29360 | 575 |
948729 | 948729 | 2021-01-20 | York | Pennsylvania | 42133 | 29155 | 564 |
945483 | 945483 | 2021-01-19 | York | Pennsylvania | 42133 | 28930 | 550 |
942236 | 942236 | 2021-01-18 | York | Pennsylvania | 42133 | 28686 | 549 |
938991 | 938991 | 2021-01-17 | York | Pennsylvania | 42133 | 28488 | 545 |
935746 | 935746 | 2021-01-16 | York | Pennsylvania | 42133 | 28125 | 542 |
932501 | 932501 | 2021-01-15 | York | Pennsylvania | 42133 | 27846 | 534 |
929256 | 929256 | 2021-01-14 | York | Pennsylvania | 42133 | 27663 | 529 |
926011 | 926011 | 2021-01-13 | York | Pennsylvania | 42133 | 27275 | 519 |
922765 | 922765 | 2021-01-12 | York | Pennsylvania | 42133 | 27005 | 505 |
919520 | 919520 | 2021-01-11 | York | Pennsylvania | 42133 | 26759 | 490 |
916275 | 916275 | 2021-01-10 | York | Pennsylvania | 42133 | 26494 | 489 |
913030 | 913030 | 2021-01-09 | York | Pennsylvania | 42133 | 26155 | 488 |
909785 | 909785 | 2021-01-08 | York | Pennsylvania | 42133 | 25710 | 478 |
906540 | 906540 | 2021-01-07 | York | Pennsylvania | 42133 | 25349 | 474 |
903294 | 903294 | 2021-01-06 | York | Pennsylvania | 42133 | 25040 | 457 |
900049 | 900049 | 2021-01-05 | York | Pennsylvania | 42133 | 24608 | 446 |
896804 | 896804 | 2021-01-04 | York | Pennsylvania | 42133 | 24158 | 435 |
893558 | 893558 | 2021-01-03 | York | Pennsylvania | 42133 | 24086 | 427 |
890312 | 890312 | 2021-01-02 | York | Pennsylvania | 42133 | 23874 | 425 |
887065 | 887065 | 2021-01-01 | York | Pennsylvania | 42133 | 23581 | 425 |
883820 | 883820 | 2020-12-31 | York | Pennsylvania | 42133 | 23283 | 419 |
880575 | 880575 | 2020-12-30 | York | Pennsylvania | 42133 | 22920 | 400 |
877330 | 877330 | 2020-12-29 | York | Pennsylvania | 42133 | 22537 | 394 |
874085 | 874085 | 2020-12-28 | York | Pennsylvania | 42133 | 22293 | 379 |
870840 | 870840 | 2020-12-27 | York | Pennsylvania | 42133 | 22088 | 374 |
867595 | 867595 | 2020-12-26 | York | Pennsylvania | 42133 | 21837 | 374 |
864350 | 864350 | 2020-12-25 | York | Pennsylvania | 42133 | 21477 | 374 |
861105 | 861105 | 2020-12-24 | York | Pennsylvania | 42133 | 21255 | 370 |
857860 | 857860 | 2020-12-23 | York | Pennsylvania | 42133 | 20897 | 361 |
854615 | 854615 | 2020-12-22 | York | Pennsylvania | 42133 | 20332 | 350 |
851370 | 851370 | 2020-12-21 | York | Pennsylvania | 42133 | 20128 | 342 |
848125 | 848125 | 2020-12-20 | York | Pennsylvania | 42133 | 19760 | 341 |
844880 | 844880 | 2020-12-19 | York | Pennsylvania | 42133 | 19439 | 337 |
841634 | 841634 | 2020-12-18 | York | Pennsylvania | 42133 | 19039 | 327 |
838389 | 838389 | 2020-12-17 | York | Pennsylvania | 42133 | 18556 | 320 |
835143 | 835143 | 2020-12-16 | York | Pennsylvania | 42133 | 18232 | 313 |
831897 | 831897 | 2020-12-15 | York | Pennsylvania | 42133 | 17811 | 306 |
828650 | 828650 | 2020-12-14 | York | Pennsylvania | 42133 | 17522 | 296 |
825404 | 825404 | 2020-12-13 | York | Pennsylvania | 42133 | 17077 | 294 |
822157 | 822157 | 2020-12-12 | York | Pennsylvania | 42133 | 16344 | 291 |
818911 | 818911 | 2020-12-11 | York | Pennsylvania | 42133 | 15879 | 287 |
815665 | 815665 | 2020-12-10 | York | Pennsylvania | 42133 | 15531 | 280 |
812419 | 812419 | 2020-12-09 | York | Pennsylvania | 42133 | 14950 | 273 |
809175 | 809175 | 2020-12-08 | York | Pennsylvania | 42133 | 14436 | 267 |
805930 | 805930 | 2020-12-07 | York | Pennsylvania | 42133 | 13967 | 263 |
802685 | 802685 | 2020-12-06 | York | Pennsylvania | 42133 | 13845 | 262 |
799440 | 799440 | 2020-12-05 | York | Pennsylvania | 42133 | 13573 | 261 |
796195 | 796195 | 2020-12-04 | York | Pennsylvania | 42133 | 12777 | 260 |
792950 | 792950 | 2020-12-03 | York | Pennsylvania | 42133 | 12388 | 260 |
789705 | 789705 | 2020-12-02 | York | Pennsylvania | 42133 | 11711 | 258 |
786460 | 786460 | 2020-12-01 | York | Pennsylvania | 42133 | 11338 | 253 |
783216 | 783216 | 2020-11-30 | York | Pennsylvania | 42133 | 11202 | 245 |
779971 | 779971 | 2020-11-29 | York | Pennsylvania | 42133 | 11001 | 245 |
776725 | 776725 | 2020-11-28 | York | Pennsylvania | 42133 | 10806 | 241 |
773480 | 773480 | 2020-11-27 | York | Pennsylvania | 42133 | 10604 | 241 |
770235 | 770235 | 2020-11-26 | York | Pennsylvania | 42133 | 10428 | 241 |
766989 | 766989 | 2020-11-25 | York | Pennsylvania | 42133 | 10161 | 239 |
763744 | 763744 | 2020-11-24 | York | Pennsylvania | 42133 | 9978 | 237 |
760499 | 760499 | 2020-11-23 | York | Pennsylvania | 42133 | 9755 | 235 |
757254 | 757254 | 2020-11-22 | York | Pennsylvania | 42133 | 9662 | 235 |
754007 | 754007 | 2020-11-21 | York | Pennsylvania | 42133 | 9103 | 234 |
750761 | 750761 | 2020-11-20 | York | Pennsylvania | 42133 | 8975 | 233 |
747515 | 747515 | 2020-11-19 | York | Pennsylvania | 42133 | 8825 | 231 |
744269 | 744269 | 2020-11-18 | York | Pennsylvania | 42133 | 8632 | 227 |
741022 | 741022 | 2020-11-17 | York | Pennsylvania | 42133 | 8454 | 224 |
737776 | 737776 | 2020-11-16 | York | Pennsylvania | 42133 | 8216 | 223 |
734532 | 734532 | 2020-11-15 | York | Pennsylvania | 42133 | 8074 | 223 |
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);