ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Adams" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195372 | 1195372 | 2021-04-06 | Adams | Pennsylvania | 42001 | 8302 | 161 |
1192124 | 1192124 | 2021-04-05 | Adams | Pennsylvania | 42001 | 8275 | 161 |
1188875 | 1188875 | 2021-04-04 | Adams | Pennsylvania | 42001 | 8263 | 161 |
1185628 | 1185628 | 2021-04-03 | Adams | Pennsylvania | 42001 | 8240 | 161 |
1182381 | 1182381 | 2021-04-02 | Adams | Pennsylvania | 42001 | 8194 | 161 |
1179134 | 1179134 | 2021-04-01 | Adams | Pennsylvania | 42001 | 8144 | 161 |
1175887 | 1175887 | 2021-03-31 | Adams | Pennsylvania | 42001 | 8112 | 161 |
1172640 | 1172640 | 2021-03-30 | Adams | Pennsylvania | 42001 | 8062 | 159 |
1169393 | 1169393 | 2021-03-29 | Adams | Pennsylvania | 42001 | 8008 | 159 |
1166145 | 1166145 | 2021-03-28 | Adams | Pennsylvania | 42001 | 7988 | 159 |
1162897 | 1162897 | 2021-03-27 | Adams | Pennsylvania | 42001 | 7955 | 159 |
1159648 | 1159648 | 2021-03-26 | Adams | Pennsylvania | 42001 | 7922 | 158 |
1156401 | 1156401 | 2021-03-25 | Adams | Pennsylvania | 42001 | 7862 | 158 |
1153154 | 1153154 | 2021-03-24 | Adams | Pennsylvania | 42001 | 7822 | 158 |
1149907 | 1149907 | 2021-03-23 | Adams | Pennsylvania | 42001 | 7774 | 158 |
1146660 | 1146660 | 2021-03-22 | Adams | Pennsylvania | 42001 | 7758 | 158 |
1143413 | 1143413 | 2021-03-21 | Adams | Pennsylvania | 42001 | 7745 | 158 |
1140166 | 1140166 | 2021-03-20 | Adams | Pennsylvania | 42001 | 7724 | 158 |
1136920 | 1136920 | 2021-03-19 | Adams | Pennsylvania | 42001 | 7699 | 158 |
1133674 | 1133674 | 2021-03-18 | Adams | Pennsylvania | 42001 | 7680 | 157 |
1130426 | 1130426 | 2021-03-17 | Adams | Pennsylvania | 42001 | 7662 | 156 |
1127179 | 1127179 | 2021-03-16 | Adams | Pennsylvania | 42001 | 7629 | 156 |
1123933 | 1123933 | 2021-03-15 | Adams | Pennsylvania | 42001 | 7614 | 155 |
1120687 | 1120687 | 2021-03-14 | Adams | Pennsylvania | 42001 | 7607 | 155 |
1117440 | 1117440 | 2021-03-13 | Adams | Pennsylvania | 42001 | 7586 | 155 |
1114193 | 1114193 | 2021-03-12 | Adams | Pennsylvania | 42001 | 7564 | 155 |
1110947 | 1110947 | 2021-03-11 | Adams | Pennsylvania | 42001 | 7527 | 155 |
1107701 | 1107701 | 2021-03-10 | Adams | Pennsylvania | 42001 | 7502 | 155 |
1104455 | 1104455 | 2021-03-09 | Adams | Pennsylvania | 42001 | 7476 | 153 |
1101209 | 1101209 | 2021-03-08 | Adams | Pennsylvania | 42001 | 7436 | 152 |
1097963 | 1097963 | 2021-03-07 | Adams | Pennsylvania | 42001 | 7429 | 152 |
1094715 | 1094715 | 2021-03-06 | Adams | Pennsylvania | 42001 | 7406 | 152 |
1091469 | 1091469 | 2021-03-05 | Adams | Pennsylvania | 42001 | 7378 | 152 |
1088223 | 1088223 | 2021-03-04 | Adams | Pennsylvania | 42001 | 7357 | 152 |
1084978 | 1084978 | 2021-03-03 | Adams | Pennsylvania | 42001 | 7332 | 151 |
1081732 | 1081732 | 2021-03-02 | Adams | Pennsylvania | 42001 | 7298 | 151 |
1078486 | 1078486 | 2021-03-01 | Adams | Pennsylvania | 42001 | 7284 | 150 |
1075241 | 1075241 | 2021-02-28 | Adams | Pennsylvania | 42001 | 7273 | 150 |
1071995 | 1071995 | 2021-02-27 | Adams | Pennsylvania | 42001 | 7250 | 150 |
1068749 | 1068749 | 2021-02-26 | Adams | Pennsylvania | 42001 | 7229 | 150 |
1065504 | 1065504 | 2021-02-25 | Adams | Pennsylvania | 42001 | 7203 | 150 |
1062259 | 1062259 | 2021-02-24 | Adams | Pennsylvania | 42001 | 7186 | 148 |
1059014 | 1059014 | 2021-02-23 | Adams | Pennsylvania | 42001 | 7162 | 148 |
1055768 | 1055768 | 2021-02-22 | Adams | Pennsylvania | 42001 | 7136 | 148 |
1052522 | 1052522 | 2021-02-21 | Adams | Pennsylvania | 42001 | 7120 | 148 |
1049275 | 1049275 | 2021-02-20 | Adams | Pennsylvania | 42001 | 7102 | 148 |
1046028 | 1046028 | 2021-02-19 | Adams | Pennsylvania | 42001 | 7074 | 148 |
1042783 | 1042783 | 2021-02-18 | Adams | Pennsylvania | 42001 | 7041 | 148 |
1039538 | 1039538 | 2021-02-17 | Adams | Pennsylvania | 42001 | 7018 | 148 |
1036293 | 1036293 | 2021-02-16 | Adams | Pennsylvania | 42001 | 7002 | 147 |
1033048 | 1033048 | 2021-02-15 | Adams | Pennsylvania | 42001 | 6977 | 147 |
1029802 | 1029802 | 2021-02-14 | Adams | Pennsylvania | 42001 | 6959 | 147 |
1026555 | 1026555 | 2021-02-13 | Adams | Pennsylvania | 42001 | 6919 | 146 |
1023310 | 1023310 | 2021-02-12 | Adams | Pennsylvania | 42001 | 6895 | 145 |
1020065 | 1020065 | 2021-02-11 | Adams | Pennsylvania | 42001 | 6876 | 144 |
1016820 | 1016820 | 2021-02-10 | Adams | Pennsylvania | 42001 | 6843 | 144 |
1013575 | 1013575 | 2021-02-09 | Adams | Pennsylvania | 42001 | 6821 | 145 |
1010330 | 1010330 | 2021-02-08 | Adams | Pennsylvania | 42001 | 6796 | 141 |
1007084 | 1007084 | 2021-02-07 | Adams | Pennsylvania | 42001 | 6779 | 144 |
1003838 | 1003838 | 2021-02-06 | Adams | Pennsylvania | 42001 | 6754 | 144 |
1000592 | 1000592 | 2021-02-05 | Adams | Pennsylvania | 42001 | 6704 | 144 |
997346 | 997346 | 2021-02-04 | Adams | Pennsylvania | 42001 | 6672 | 144 |
994100 | 994100 | 2021-02-03 | Adams | Pennsylvania | 42001 | 6631 | 142 |
990854 | 990854 | 2021-02-02 | Adams | Pennsylvania | 42001 | 6603 | 142 |
987608 | 987608 | 2021-02-01 | Adams | Pennsylvania | 42001 | 6578 | 142 |
984361 | 984361 | 2021-01-31 | Adams | Pennsylvania | 42001 | 6564 | 142 |
981114 | 981114 | 2021-01-30 | Adams | Pennsylvania | 42001 | 6507 | 142 |
977868 | 977868 | 2021-01-29 | Adams | Pennsylvania | 42001 | 6471 | 142 |
974623 | 974623 | 2021-01-28 | Adams | Pennsylvania | 42001 | 6446 | 140 |
971378 | 971378 | 2021-01-27 | Adams | Pennsylvania | 42001 | 6400 | 140 |
968133 | 968133 | 2021-01-26 | Adams | Pennsylvania | 42001 | 6323 | 137 |
964889 | 964889 | 2021-01-25 | Adams | Pennsylvania | 42001 | 6281 | 137 |
961644 | 961644 | 2021-01-24 | Adams | Pennsylvania | 42001 | 6228 | 137 |
958399 | 958399 | 2021-01-23 | Adams | Pennsylvania | 42001 | 6183 | 135 |
955153 | 955153 | 2021-01-22 | Adams | Pennsylvania | 42001 | 6130 | 130 |
951908 | 951908 | 2021-01-21 | Adams | Pennsylvania | 42001 | 6085 | 128 |
948663 | 948663 | 2021-01-20 | Adams | Pennsylvania | 42001 | 6032 | 126 |
945417 | 945417 | 2021-01-19 | Adams | Pennsylvania | 42001 | 5952 | 125 |
942170 | 942170 | 2021-01-18 | Adams | Pennsylvania | 42001 | 5892 | 124 |
938925 | 938925 | 2021-01-17 | Adams | Pennsylvania | 42001 | 5830 | 124 |
935680 | 935680 | 2021-01-16 | Adams | Pennsylvania | 42001 | 5749 | 123 |
932435 | 932435 | 2021-01-15 | Adams | Pennsylvania | 42001 | 5690 | 122 |
929190 | 929190 | 2021-01-14 | Adams | Pennsylvania | 42001 | 5642 | 120 |
925945 | 925945 | 2021-01-13 | Adams | Pennsylvania | 42001 | 5508 | 116 |
922699 | 922699 | 2021-01-12 | Adams | Pennsylvania | 42001 | 5434 | 115 |
919454 | 919454 | 2021-01-11 | Adams | Pennsylvania | 42001 | 5401 | 114 |
916209 | 916209 | 2021-01-10 | Adams | Pennsylvania | 42001 | 5341 | 112 |
912964 | 912964 | 2021-01-09 | Adams | Pennsylvania | 42001 | 5230 | 111 |
909719 | 909719 | 2021-01-08 | Adams | Pennsylvania | 42001 | 5145 | 108 |
906474 | 906474 | 2021-01-07 | Adams | Pennsylvania | 42001 | 5059 | 108 |
903228 | 903228 | 2021-01-06 | Adams | Pennsylvania | 42001 | 4973 | 101 |
899983 | 899983 | 2021-01-05 | Adams | Pennsylvania | 42001 | 4865 | 95 |
896738 | 896738 | 2021-01-04 | Adams | Pennsylvania | 42001 | 4786 | 92 |
893492 | 893492 | 2021-01-03 | Adams | Pennsylvania | 42001 | 4768 | 91 |
890246 | 890246 | 2021-01-02 | Adams | Pennsylvania | 42001 | 4701 | 90 |
886999 | 886999 | 2021-01-01 | Adams | Pennsylvania | 42001 | 4649 | 90 |
883754 | 883754 | 2020-12-31 | Adams | Pennsylvania | 42001 | 4557 | 88 |
880509 | 880509 | 2020-12-30 | Adams | Pennsylvania | 42001 | 4477 | 81 |
877264 | 877264 | 2020-12-29 | Adams | Pennsylvania | 42001 | 4325 | 77 |
874019 | 874019 | 2020-12-28 | Adams | Pennsylvania | 42001 | 4262 | 74 |
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);