ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 42011 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195377 | 1195377 | 2021-04-06 | Berks | Pennsylvania | 42011 | 41042 | 932 |
1192129 | 1192129 | 2021-04-05 | Berks | Pennsylvania | 42011 | 40836 | 932 |
1188880 | 1188880 | 2021-04-04 | Berks | Pennsylvania | 42011 | 40692 | 932 |
1185633 | 1185633 | 2021-04-03 | Berks | Pennsylvania | 42011 | 40559 | 932 |
1182386 | 1182386 | 2021-04-02 | Berks | Pennsylvania | 42011 | 40225 | 930 |
1179139 | 1179139 | 2021-04-01 | Berks | Pennsylvania | 42011 | 40054 | 930 |
1175892 | 1175892 | 2021-03-31 | Berks | Pennsylvania | 42011 | 39895 | 930 |
1172645 | 1172645 | 2021-03-30 | Berks | Pennsylvania | 42011 | 39706 | 930 |
1169398 | 1169398 | 2021-03-29 | Berks | Pennsylvania | 42011 | 39419 | 927 |
1166150 | 1166150 | 2021-03-28 | Berks | Pennsylvania | 42011 | 39328 | 927 |
1162902 | 1162902 | 2021-03-27 | Berks | Pennsylvania | 42011 | 39204 | 927 |
1159653 | 1159653 | 2021-03-26 | Berks | Pennsylvania | 42011 | 39062 | 924 |
1156406 | 1156406 | 2021-03-25 | Berks | Pennsylvania | 42011 | 38848 | 924 |
1153159 | 1153159 | 2021-03-24 | Berks | Pennsylvania | 42011 | 38650 | 923 |
1149912 | 1149912 | 2021-03-23 | Berks | Pennsylvania | 42011 | 38374 | 920 |
1146665 | 1146665 | 2021-03-22 | Berks | Pennsylvania | 42011 | 38226 | 920 |
1143418 | 1143418 | 2021-03-21 | Berks | Pennsylvania | 42011 | 38174 | 920 |
1140171 | 1140171 | 2021-03-20 | Berks | Pennsylvania | 42011 | 38084 | 919 |
1136925 | 1136925 | 2021-03-19 | Berks | Pennsylvania | 42011 | 37768 | 917 |
1133679 | 1133679 | 2021-03-18 | Berks | Pennsylvania | 42011 | 37631 | 916 |
1130431 | 1130431 | 2021-03-17 | Berks | Pennsylvania | 42011 | 37507 | 916 |
1127184 | 1127184 | 2021-03-16 | Berks | Pennsylvania | 42011 | 37375 | 915 |
1123938 | 1123938 | 2021-03-15 | Berks | Pennsylvania | 42011 | 37228 | 913 |
1120692 | 1120692 | 2021-03-14 | Berks | Pennsylvania | 42011 | 37166 | 911 |
1117445 | 1117445 | 2021-03-13 | Berks | Pennsylvania | 42011 | 37061 | 911 |
1114198 | 1114198 | 2021-03-12 | Berks | Pennsylvania | 42011 | 36951 | 911 |
1110952 | 1110952 | 2021-03-11 | Berks | Pennsylvania | 42011 | 36740 | 911 |
1107706 | 1107706 | 2021-03-10 | Berks | Pennsylvania | 42011 | 36611 | 911 |
1104460 | 1104460 | 2021-03-09 | Berks | Pennsylvania | 42011 | 36529 | 909 |
1101214 | 1101214 | 2021-03-08 | Berks | Pennsylvania | 42011 | 36444 | 908 |
1097968 | 1097968 | 2021-03-07 | Berks | Pennsylvania | 42011 | 36378 | 908 |
1094720 | 1094720 | 2021-03-06 | Berks | Pennsylvania | 42011 | 36307 | 908 |
1091474 | 1091474 | 2021-03-05 | Berks | Pennsylvania | 42011 | 36185 | 907 |
1088228 | 1088228 | 2021-03-04 | Berks | Pennsylvania | 42011 | 36077 | 906 |
1084983 | 1084983 | 2021-03-03 | Berks | Pennsylvania | 42011 | 35888 | 904 |
1081737 | 1081737 | 2021-03-02 | Berks | Pennsylvania | 42011 | 35791 | 903 |
1078491 | 1078491 | 2021-03-01 | Berks | Pennsylvania | 42011 | 35699 | 900 |
1075246 | 1075246 | 2021-02-28 | Berks | Pennsylvania | 42011 | 35658 | 900 |
1072000 | 1072000 | 2021-02-27 | Berks | Pennsylvania | 42011 | 35577 | 898 |
1068754 | 1068754 | 2021-02-26 | Berks | Pennsylvania | 42011 | 35476 | 898 |
1065509 | 1065509 | 2021-02-25 | Berks | Pennsylvania | 42011 | 35370 | 893 |
1062264 | 1062264 | 2021-02-24 | Berks | Pennsylvania | 42011 | 35302 | 889 |
1059019 | 1059019 | 2021-02-23 | Berks | Pennsylvania | 42011 | 35180 | 886 |
1055773 | 1055773 | 2021-02-22 | Berks | Pennsylvania | 42011 | 35105 | 880 |
1052527 | 1052527 | 2021-02-21 | Berks | Pennsylvania | 42011 | 35025 | 879 |
1049280 | 1049280 | 2021-02-20 | Berks | Pennsylvania | 42011 | 34960 | 879 |
1046033 | 1046033 | 2021-02-19 | Berks | Pennsylvania | 42011 | 34859 | 877 |
1042788 | 1042788 | 2021-02-18 | Berks | Pennsylvania | 42011 | 34794 | 874 |
1039543 | 1039543 | 2021-02-17 | Berks | Pennsylvania | 42011 | 34616 | 872 |
1036298 | 1036298 | 2021-02-16 | Berks | Pennsylvania | 42011 | 34506 | 868 |
1033053 | 1033053 | 2021-02-15 | Berks | Pennsylvania | 42011 | 34377 | 868 |
1029807 | 1029807 | 2021-02-14 | Berks | Pennsylvania | 42011 | 34325 | 868 |
1026560 | 1026560 | 2021-02-13 | Berks | Pennsylvania | 42011 | 34284 | 868 |
1023315 | 1023315 | 2021-02-12 | Berks | Pennsylvania | 42011 | 34140 | 864 |
1020070 | 1020070 | 2021-02-11 | Berks | Pennsylvania | 42011 | 34009 | 860 |
1016825 | 1016825 | 2021-02-10 | Berks | Pennsylvania | 42011 | 33874 | 854 |
1013580 | 1013580 | 2021-02-09 | Berks | Pennsylvania | 42011 | 33769 | 847 |
1010335 | 1010335 | 2021-02-08 | Berks | Pennsylvania | 42011 | 33625 | 843 |
1007089 | 1007089 | 2021-02-07 | Berks | Pennsylvania | 42011 | 33530 | 838 |
1003843 | 1003843 | 2021-02-06 | Berks | Pennsylvania | 42011 | 33364 | 836 |
1000597 | 1000597 | 2021-02-05 | Berks | Pennsylvania | 42011 | 33202 | 827 |
997351 | 997351 | 2021-02-04 | Berks | Pennsylvania | 42011 | 33104 | 821 |
994105 | 994105 | 2021-02-03 | Berks | Pennsylvania | 42011 | 32957 | 815 |
990859 | 990859 | 2021-02-02 | Berks | Pennsylvania | 42011 | 32843 | 811 |
987613 | 987613 | 2021-02-01 | Berks | Pennsylvania | 42011 | 32713 | 804 |
984366 | 984366 | 2021-01-31 | Berks | Pennsylvania | 42011 | 32577 | 802 |
981119 | 981119 | 2021-01-30 | Berks | Pennsylvania | 42011 | 32481 | 800 |
977873 | 977873 | 2021-01-29 | Berks | Pennsylvania | 42011 | 32287 | 796 |
974628 | 974628 | 2021-01-28 | Berks | Pennsylvania | 42011 | 30822 | 790 |
971383 | 971383 | 2021-01-27 | Berks | Pennsylvania | 42011 | 30633 | 771 |
968138 | 968138 | 2021-01-26 | Berks | Pennsylvania | 42011 | 30418 | 760 |
964894 | 964894 | 2021-01-25 | Berks | Pennsylvania | 42011 | 30230 | 748 |
961649 | 961649 | 2021-01-24 | Berks | Pennsylvania | 42011 | 30099 | 747 |
958404 | 958404 | 2021-01-23 | Berks | Pennsylvania | 42011 | 29973 | 745 |
955158 | 955158 | 2021-01-22 | Berks | Pennsylvania | 42011 | 29687 | 731 |
951913 | 951913 | 2021-01-21 | Berks | Pennsylvania | 42011 | 29433 | 723 |
948668 | 948668 | 2021-01-20 | Berks | Pennsylvania | 42011 | 29253 | 707 |
945422 | 945422 | 2021-01-19 | Berks | Pennsylvania | 42011 | 29064 | 692 |
942175 | 942175 | 2021-01-18 | Berks | Pennsylvania | 42011 | 28726 | 691 |
938930 | 938930 | 2021-01-17 | Berks | Pennsylvania | 42011 | 28578 | 687 |
935685 | 935685 | 2021-01-16 | Berks | Pennsylvania | 42011 | 28373 | 685 |
932440 | 932440 | 2021-01-15 | Berks | Pennsylvania | 42011 | 28001 | 674 |
929195 | 929195 | 2021-01-14 | Berks | Pennsylvania | 42011 | 27742 | 669 |
925950 | 925950 | 2021-01-13 | Berks | Pennsylvania | 42011 | 27452 | 652 |
922704 | 922704 | 2021-01-12 | Berks | Pennsylvania | 42011 | 27070 | 632 |
919459 | 919459 | 2021-01-11 | Berks | Pennsylvania | 42011 | 26732 | 629 |
916214 | 916214 | 2021-01-10 | Berks | Pennsylvania | 42011 | 26512 | 628 |
912969 | 912969 | 2021-01-09 | Berks | Pennsylvania | 42011 | 26198 | 624 |
909724 | 909724 | 2021-01-08 | Berks | Pennsylvania | 42011 | 25874 | 614 |
906479 | 906479 | 2021-01-07 | Berks | Pennsylvania | 42011 | 25523 | 605 |
903233 | 903233 | 2021-01-06 | Berks | Pennsylvania | 42011 | 25180 | 595 |
899988 | 899988 | 2021-01-05 | Berks | Pennsylvania | 42011 | 24820 | 579 |
896743 | 896743 | 2021-01-04 | Berks | Pennsylvania | 42011 | 24318 | 574 |
893497 | 893497 | 2021-01-03 | Berks | Pennsylvania | 42011 | 24232 | 573 |
890251 | 890251 | 2021-01-02 | Berks | Pennsylvania | 42011 | 24052 | 572 |
887004 | 887004 | 2021-01-01 | Berks | Pennsylvania | 42011 | 23758 | 571 |
883759 | 883759 | 2020-12-31 | Berks | Pennsylvania | 42011 | 23439 | 565 |
880514 | 880514 | 2020-12-30 | Berks | Pennsylvania | 42011 | 23154 | 557 |
877269 | 877269 | 2020-12-29 | Berks | Pennsylvania | 42011 | 22758 | 546 |
874024 | 874024 | 2020-12-28 | Berks | Pennsylvania | 42011 | 22486 | 540 |
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);