ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 42095 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195419 | 1195419 | 2021-04-06 | Northampton | Pennsylvania | 42095 | 31389 | 681 |
1192171 | 1192171 | 2021-04-05 | Northampton | Pennsylvania | 42095 | 31225 | 681 |
1188922 | 1188922 | 2021-04-04 | Northampton | Pennsylvania | 42095 | 31125 | 681 |
1185675 | 1185675 | 2021-04-03 | Northampton | Pennsylvania | 42095 | 31002 | 681 |
1182428 | 1182428 | 2021-04-02 | Northampton | Pennsylvania | 42095 | 30768 | 679 |
1179181 | 1179181 | 2021-04-01 | Northampton | Pennsylvania | 42095 | 30602 | 678 |
1175934 | 1175934 | 2021-03-31 | Northampton | Pennsylvania | 42095 | 30460 | 678 |
1172687 | 1172687 | 2021-03-30 | Northampton | Pennsylvania | 42095 | 30312 | 677 |
1169440 | 1169440 | 2021-03-29 | Northampton | Pennsylvania | 42095 | 30082 | 676 |
1166192 | 1166192 | 2021-03-28 | Northampton | Pennsylvania | 42095 | 29974 | 675 |
1162944 | 1162944 | 2021-03-27 | Northampton | Pennsylvania | 42095 | 29886 | 674 |
1159695 | 1159695 | 2021-03-26 | Northampton | Pennsylvania | 42095 | 29725 | 673 |
1156448 | 1156448 | 2021-03-25 | Northampton | Pennsylvania | 42095 | 29543 | 673 |
1153201 | 1153201 | 2021-03-24 | Northampton | Pennsylvania | 42095 | 29341 | 673 |
1149954 | 1149954 | 2021-03-23 | Northampton | Pennsylvania | 42095 | 29150 | 671 |
1146707 | 1146707 | 2021-03-22 | Northampton | Pennsylvania | 42095 | 28955 | 669 |
1143460 | 1143460 | 2021-03-21 | Northampton | Pennsylvania | 42095 | 28907 | 669 |
1140213 | 1140213 | 2021-03-20 | Northampton | Pennsylvania | 42095 | 28822 | 668 |
1136967 | 1136967 | 2021-03-19 | Northampton | Pennsylvania | 42095 | 28639 | 668 |
1133721 | 1133721 | 2021-03-18 | Northampton | Pennsylvania | 42095 | 28482 | 666 |
1130473 | 1130473 | 2021-03-17 | Northampton | Pennsylvania | 42095 | 28358 | 665 |
1127226 | 1127226 | 2021-03-16 | Northampton | Pennsylvania | 42095 | 28257 | 664 |
1123980 | 1123980 | 2021-03-15 | Northampton | Pennsylvania | 42095 | 28136 | 661 |
1120734 | 1120734 | 2021-03-14 | Northampton | Pennsylvania | 42095 | 28076 | 656 |
1117487 | 1117487 | 2021-03-13 | Northampton | Pennsylvania | 42095 | 28001 | 656 |
1114240 | 1114240 | 2021-03-12 | Northampton | Pennsylvania | 42095 | 27898 | 656 |
1110994 | 1110994 | 2021-03-11 | Northampton | Pennsylvania | 42095 | 27765 | 656 |
1107748 | 1107748 | 2021-03-10 | Northampton | Pennsylvania | 42095 | 27650 | 656 |
1104502 | 1104502 | 2021-03-09 | Northampton | Pennsylvania | 42095 | 27564 | 654 |
1101256 | 1101256 | 2021-03-08 | Northampton | Pennsylvania | 42095 | 27483 | 653 |
1098010 | 1098010 | 2021-03-07 | Northampton | Pennsylvania | 42095 | 27446 | 652 |
1094762 | 1094762 | 2021-03-06 | Northampton | Pennsylvania | 42095 | 27389 | 651 |
1091516 | 1091516 | 2021-03-05 | Northampton | Pennsylvania | 42095 | 27286 | 651 |
1088270 | 1088270 | 2021-03-04 | Northampton | Pennsylvania | 42095 | 27207 | 650 |
1085025 | 1085025 | 2021-03-03 | Northampton | Pennsylvania | 42095 | 27090 | 649 |
1081779 | 1081779 | 2021-03-02 | Northampton | Pennsylvania | 42095 | 26969 | 648 |
1078533 | 1078533 | 2021-03-01 | Northampton | Pennsylvania | 42095 | 26855 | 644 |
1075288 | 1075288 | 2021-02-28 | Northampton | Pennsylvania | 42095 | 26814 | 644 |
1072042 | 1072042 | 2021-02-27 | Northampton | Pennsylvania | 42095 | 26747 | 643 |
1068796 | 1068796 | 2021-02-26 | Northampton | Pennsylvania | 42095 | 26662 | 643 |
1065551 | 1065551 | 2021-02-25 | Northampton | Pennsylvania | 42095 | 26549 | 639 |
1062306 | 1062306 | 2021-02-24 | Northampton | Pennsylvania | 42095 | 26453 | 634 |
1059061 | 1059061 | 2021-02-23 | Northampton | Pennsylvania | 42095 | 26356 | 632 |
1055815 | 1055815 | 2021-02-22 | Northampton | Pennsylvania | 42095 | 26208 | 631 |
1052569 | 1052569 | 2021-02-21 | Northampton | Pennsylvania | 42095 | 26143 | 631 |
1049322 | 1049322 | 2021-02-20 | Northampton | Pennsylvania | 42095 | 26058 | 631 |
1046075 | 1046075 | 2021-02-19 | Northampton | Pennsylvania | 42095 | 25960 | 626 |
1042830 | 1042830 | 2021-02-18 | Northampton | Pennsylvania | 42095 | 25837 | 623 |
1039585 | 1039585 | 2021-02-17 | Northampton | Pennsylvania | 42095 | 25694 | 618 |
1036340 | 1036340 | 2021-02-16 | Northampton | Pennsylvania | 42095 | 25546 | 611 |
1033095 | 1033095 | 2021-02-15 | Northampton | Pennsylvania | 42095 | 25433 | 611 |
1029849 | 1029849 | 2021-02-14 | Northampton | Pennsylvania | 42095 | 25386 | 611 |
1026602 | 1026602 | 2021-02-13 | Northampton | Pennsylvania | 42095 | 25250 | 611 |
1023357 | 1023357 | 2021-02-12 | Northampton | Pennsylvania | 42095 | 25060 | 609 |
1020112 | 1020112 | 2021-02-11 | Northampton | Pennsylvania | 42095 | 24910 | 605 |
1016867 | 1016867 | 2021-02-10 | Northampton | Pennsylvania | 42095 | 24719 | 602 |
1013622 | 1013622 | 2021-02-09 | Northampton | Pennsylvania | 42095 | 24613 | 599 |
1010377 | 1010377 | 2021-02-08 | Northampton | Pennsylvania | 42095 | 24388 | 589 |
1007131 | 1007131 | 2021-02-07 | Northampton | Pennsylvania | 42095 | 24327 | 590 |
1003885 | 1003885 | 2021-02-06 | Northampton | Pennsylvania | 42095 | 24147 | 588 |
1000639 | 1000639 | 2021-02-05 | Northampton | Pennsylvania | 42095 | 23981 | 582 |
997393 | 997393 | 2021-02-04 | Northampton | Pennsylvania | 42095 | 23867 | 576 |
994147 | 994147 | 2021-02-03 | Northampton | Pennsylvania | 42095 | 23799 | 574 |
990901 | 990901 | 2021-02-02 | Northampton | Pennsylvania | 42095 | 23716 | 573 |
987655 | 987655 | 2021-02-01 | Northampton | Pennsylvania | 42095 | 23585 | 571 |
984408 | 984408 | 2021-01-31 | Northampton | Pennsylvania | 42095 | 23443 | 569 |
981161 | 981161 | 2021-01-30 | Northampton | Pennsylvania | 42095 | 23315 | 567 |
977915 | 977915 | 2021-01-29 | Northampton | Pennsylvania | 42095 | 23135 | 564 |
974670 | 974670 | 2021-01-28 | Northampton | Pennsylvania | 42095 | 22687 | 561 |
971425 | 971425 | 2021-01-27 | Northampton | Pennsylvania | 42095 | 22485 | 552 |
968180 | 968180 | 2021-01-26 | Northampton | Pennsylvania | 42095 | 22277 | 549 |
964936 | 964936 | 2021-01-25 | Northampton | Pennsylvania | 42095 | 22026 | 546 |
961691 | 961691 | 2021-01-24 | Northampton | Pennsylvania | 42095 | 21929 | 544 |
958446 | 958446 | 2021-01-23 | Northampton | Pennsylvania | 42095 | 21800 | 544 |
955200 | 955200 | 2021-01-22 | Northampton | Pennsylvania | 42095 | 21553 | 542 |
951955 | 951955 | 2021-01-21 | Northampton | Pennsylvania | 42095 | 21337 | 535 |
948710 | 948710 | 2021-01-20 | Northampton | Pennsylvania | 42095 | 21157 | 527 |
945464 | 945464 | 2021-01-19 | Northampton | Pennsylvania | 42095 | 20952 | 511 |
942217 | 942217 | 2021-01-18 | Northampton | Pennsylvania | 42095 | 20716 | 511 |
938972 | 938972 | 2021-01-17 | Northampton | Pennsylvania | 42095 | 20611 | 510 |
935727 | 935727 | 2021-01-16 | Northampton | Pennsylvania | 42095 | 20432 | 506 |
932482 | 932482 | 2021-01-15 | Northampton | Pennsylvania | 42095 | 20191 | 503 |
929237 | 929237 | 2021-01-14 | Northampton | Pennsylvania | 42095 | 19981 | 499 |
925992 | 925992 | 2021-01-13 | Northampton | Pennsylvania | 42095 | 19753 | 493 |
922746 | 922746 | 2021-01-12 | Northampton | Pennsylvania | 42095 | 19508 | 485 |
919501 | 919501 | 2021-01-11 | Northampton | Pennsylvania | 42095 | 19334 | 481 |
916256 | 916256 | 2021-01-10 | Northampton | Pennsylvania | 42095 | 19205 | 481 |
913011 | 913011 | 2021-01-09 | Northampton | Pennsylvania | 42095 | 18990 | 480 |
909766 | 909766 | 2021-01-08 | Northampton | Pennsylvania | 42095 | 18653 | 473 |
906521 | 906521 | 2021-01-07 | Northampton | Pennsylvania | 42095 | 18331 | 469 |
903275 | 903275 | 2021-01-06 | Northampton | Pennsylvania | 42095 | 18017 | 460 |
900030 | 900030 | 2021-01-05 | Northampton | Pennsylvania | 42095 | 17738 | 450 |
896785 | 896785 | 2021-01-04 | Northampton | Pennsylvania | 42095 | 17430 | 439 |
893539 | 893539 | 2021-01-03 | Northampton | Pennsylvania | 42095 | 17358 | 438 |
890293 | 890293 | 2021-01-02 | Northampton | Pennsylvania | 42095 | 17261 | 438 |
887046 | 887046 | 2021-01-01 | Northampton | Pennsylvania | 42095 | 16940 | 436 |
883801 | 883801 | 2020-12-31 | Northampton | Pennsylvania | 42095 | 16648 | 431 |
880556 | 880556 | 2020-12-30 | Northampton | Pennsylvania | 42095 | 16380 | 427 |
877311 | 877311 | 2020-12-29 | Northampton | Pennsylvania | 42095 | 16084 | 416 |
874066 | 874066 | 2020-12-28 | Northampton | Pennsylvania | 42095 | 15893 | 411 |
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);