ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Lebanon" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279844 | 1279844 | 2021-05-02 | Lebanon | Pennsylvania | 42075 | 15456 | 281 |
1276597 | 1276597 | 2021-05-01 | Lebanon | Pennsylvania | 42075 | 15418 | 281 |
1273350 | 1273350 | 2021-04-30 | Lebanon | Pennsylvania | 42075 | 15371 | 280 |
1270103 | 1270103 | 2021-04-29 | Lebanon | Pennsylvania | 42075 | 15313 | 280 |
1266856 | 1266856 | 2021-04-28 | Lebanon | Pennsylvania | 42075 | 15266 | 279 |
1263609 | 1263609 | 2021-04-27 | Lebanon | Pennsylvania | 42075 | 15208 | 275 |
1260362 | 1260362 | 2021-04-26 | Lebanon | Pennsylvania | 42075 | 15146 | 275 |
1257115 | 1257115 | 2021-04-25 | Lebanon | Pennsylvania | 42075 | 15121 | 275 |
1253868 | 1253868 | 2021-04-24 | Lebanon | Pennsylvania | 42075 | 15073 | 275 |
1250621 | 1250621 | 2021-04-23 | Lebanon | Pennsylvania | 42075 | 15010 | 275 |
1247374 | 1247374 | 2021-04-22 | Lebanon | Pennsylvania | 42075 | 14938 | 274 |
1244127 | 1244127 | 2021-04-21 | Lebanon | Pennsylvania | 42075 | 14879 | 272 |
1240880 | 1240880 | 2021-04-20 | Lebanon | Pennsylvania | 42075 | 14794 | 271 |
1237633 | 1237633 | 2021-04-19 | Lebanon | Pennsylvania | 42075 | 14729 | 270 |
1234386 | 1234386 | 2021-04-18 | Lebanon | Pennsylvania | 42075 | 14706 | 270 |
1231138 | 1231138 | 2021-04-17 | Lebanon | Pennsylvania | 42075 | 14663 | 270 |
1227890 | 1227890 | 2021-04-16 | Lebanon | Pennsylvania | 42075 | 14576 | 269 |
1224642 | 1224642 | 2021-04-15 | Lebanon | Pennsylvania | 42075 | 14512 | 268 |
1221395 | 1221395 | 2021-04-14 | Lebanon | Pennsylvania | 42075 | 14441 | 266 |
1218147 | 1218147 | 2021-04-13 | Lebanon | Pennsylvania | 42075 | 14409 | 266 |
1214899 | 1214899 | 2021-04-12 | Lebanon | Pennsylvania | 42075 | 14325 | 266 |
1211652 | 1211652 | 2021-04-11 | Lebanon | Pennsylvania | 42075 | 14305 | 266 |
1208403 | 1208403 | 2021-04-10 | Lebanon | Pennsylvania | 42075 | 14264 | 266 |
1205155 | 1205155 | 2021-04-09 | Lebanon | Pennsylvania | 42075 | 14188 | 266 |
1201907 | 1201907 | 2021-04-08 | Lebanon | Pennsylvania | 42075 | 14149 | 266 |
1198658 | 1198658 | 2021-04-07 | Lebanon | Pennsylvania | 42075 | 14111 | 265 |
1195409 | 1195409 | 2021-04-06 | Lebanon | Pennsylvania | 42075 | 14055 | 265 |
1192161 | 1192161 | 2021-04-05 | Lebanon | Pennsylvania | 42075 | 14020 | 265 |
1188912 | 1188912 | 2021-04-04 | Lebanon | Pennsylvania | 42075 | 13996 | 265 |
1185665 | 1185665 | 2021-04-03 | Lebanon | Pennsylvania | 42075 | 13962 | 265 |
1182418 | 1182418 | 2021-04-02 | Lebanon | Pennsylvania | 42075 | 13914 | 265 |
1179171 | 1179171 | 2021-04-01 | Lebanon | Pennsylvania | 42075 | 13862 | 265 |
1175924 | 1175924 | 2021-03-31 | Lebanon | Pennsylvania | 42075 | 13841 | 264 |
1172677 | 1172677 | 2021-03-30 | Lebanon | Pennsylvania | 42075 | 13796 | 264 |
1169430 | 1169430 | 2021-03-29 | Lebanon | Pennsylvania | 42075 | 13725 | 264 |
1166182 | 1166182 | 2021-03-28 | Lebanon | Pennsylvania | 42075 | 13703 | 264 |
1162934 | 1162934 | 2021-03-27 | Lebanon | Pennsylvania | 42075 | 13677 | 264 |
1159685 | 1159685 | 2021-03-26 | Lebanon | Pennsylvania | 42075 | 13644 | 264 |
1156438 | 1156438 | 2021-03-25 | Lebanon | Pennsylvania | 42075 | 13581 | 264 |
1153191 | 1153191 | 2021-03-24 | Lebanon | Pennsylvania | 42075 | 13537 | 264 |
1149944 | 1149944 | 2021-03-23 | Lebanon | Pennsylvania | 42075 | 13469 | 264 |
1146697 | 1146697 | 2021-03-22 | Lebanon | Pennsylvania | 42075 | 13432 | 264 |
1143450 | 1143450 | 2021-03-21 | Lebanon | Pennsylvania | 42075 | 13411 | 264 |
1140203 | 1140203 | 2021-03-20 | Lebanon | Pennsylvania | 42075 | 13394 | 264 |
1136957 | 1136957 | 2021-03-19 | Lebanon | Pennsylvania | 42075 | 13362 | 264 |
1133711 | 1133711 | 2021-03-18 | Lebanon | Pennsylvania | 42075 | 13345 | 264 |
1130463 | 1130463 | 2021-03-17 | Lebanon | Pennsylvania | 42075 | 13310 | 263 |
1127216 | 1127216 | 2021-03-16 | Lebanon | Pennsylvania | 42075 | 13259 | 263 |
1123970 | 1123970 | 2021-03-15 | Lebanon | Pennsylvania | 42075 | 13229 | 263 |
1120724 | 1120724 | 2021-03-14 | Lebanon | Pennsylvania | 42075 | 13217 | 261 |
1117477 | 1117477 | 2021-03-13 | Lebanon | Pennsylvania | 42075 | 13193 | 261 |
1114230 | 1114230 | 2021-03-12 | Lebanon | Pennsylvania | 42075 | 13159 | 261 |
1110984 | 1110984 | 2021-03-11 | Lebanon | Pennsylvania | 42075 | 13121 | 261 |
1107738 | 1107738 | 2021-03-10 | Lebanon | Pennsylvania | 42075 | 13090 | 261 |
1104492 | 1104492 | 2021-03-09 | Lebanon | Pennsylvania | 42075 | 13056 | 261 |
1101246 | 1101246 | 2021-03-08 | Lebanon | Pennsylvania | 42075 | 13023 | 260 |
1098000 | 1098000 | 2021-03-07 | Lebanon | Pennsylvania | 42075 | 13008 | 260 |
1094752 | 1094752 | 2021-03-06 | Lebanon | Pennsylvania | 42075 | 12975 | 260 |
1091506 | 1091506 | 2021-03-05 | Lebanon | Pennsylvania | 42075 | 12952 | 259 |
1088260 | 1088260 | 2021-03-04 | Lebanon | Pennsylvania | 42075 | 12923 | 258 |
1085015 | 1085015 | 2021-03-03 | Lebanon | Pennsylvania | 42075 | 12902 | 259 |
1081769 | 1081769 | 2021-03-02 | Lebanon | Pennsylvania | 42075 | 12869 | 259 |
1078523 | 1078523 | 2021-03-01 | Lebanon | Pennsylvania | 42075 | 12841 | 259 |
1075278 | 1075278 | 2021-02-28 | Lebanon | Pennsylvania | 42075 | 12819 | 259 |
1072032 | 1072032 | 2021-02-27 | Lebanon | Pennsylvania | 42075 | 12798 | 258 |
1068786 | 1068786 | 2021-02-26 | Lebanon | Pennsylvania | 42075 | 12770 | 258 |
1065541 | 1065541 | 2021-02-25 | Lebanon | Pennsylvania | 42075 | 12732 | 258 |
1062296 | 1062296 | 2021-02-24 | Lebanon | Pennsylvania | 42075 | 12702 | 257 |
1059051 | 1059051 | 2021-02-23 | Lebanon | Pennsylvania | 42075 | 12678 | 257 |
1055805 | 1055805 | 2021-02-22 | Lebanon | Pennsylvania | 42075 | 12651 | 256 |
1052559 | 1052559 | 2021-02-21 | Lebanon | Pennsylvania | 42075 | 12643 | 256 |
1049312 | 1049312 | 2021-02-20 | Lebanon | Pennsylvania | 42075 | 12623 | 256 |
1046065 | 1046065 | 2021-02-19 | Lebanon | Pennsylvania | 42075 | 12584 | 255 |
1042820 | 1042820 | 2021-02-18 | Lebanon | Pennsylvania | 42075 | 12562 | 255 |
1039575 | 1039575 | 2021-02-17 | Lebanon | Pennsylvania | 42075 | 12533 | 256 |
1036330 | 1036330 | 2021-02-16 | Lebanon | Pennsylvania | 42075 | 12493 | 252 |
1033085 | 1033085 | 2021-02-15 | Lebanon | Pennsylvania | 42075 | 12468 | 252 |
1029839 | 1029839 | 2021-02-14 | Lebanon | Pennsylvania | 42075 | 12446 | 252 |
1026592 | 1026592 | 2021-02-13 | Lebanon | Pennsylvania | 42075 | 12391 | 252 |
1023347 | 1023347 | 2021-02-12 | Lebanon | Pennsylvania | 42075 | 12342 | 247 |
1020102 | 1020102 | 2021-02-11 | Lebanon | Pennsylvania | 42075 | 12308 | 245 |
1016857 | 1016857 | 2021-02-10 | Lebanon | Pennsylvania | 42075 | 12266 | 243 |
1013612 | 1013612 | 2021-02-09 | Lebanon | Pennsylvania | 42075 | 12229 | 241 |
1010367 | 1010367 | 2021-02-08 | Lebanon | Pennsylvania | 42075 | 12160 | 239 |
1007121 | 1007121 | 2021-02-07 | Lebanon | Pennsylvania | 42075 | 12125 | 237 |
1003875 | 1003875 | 2021-02-06 | Lebanon | Pennsylvania | 42075 | 12046 | 235 |
1000629 | 1000629 | 2021-02-05 | Lebanon | Pennsylvania | 42075 | 11997 | 234 |
997383 | 997383 | 2021-02-04 | Lebanon | Pennsylvania | 42075 | 11940 | 230 |
994137 | 994137 | 2021-02-03 | Lebanon | Pennsylvania | 42075 | 11888 | 226 |
990891 | 990891 | 2021-02-02 | Lebanon | Pennsylvania | 42075 | 11861 | 225 |
987645 | 987645 | 2021-02-01 | Lebanon | Pennsylvania | 42075 | 11805 | 223 |
984398 | 984398 | 2021-01-31 | Lebanon | Pennsylvania | 42075 | 11774 | 223 |
981151 | 981151 | 2021-01-30 | Lebanon | Pennsylvania | 42075 | 11715 | 223 |
977905 | 977905 | 2021-01-29 | Lebanon | Pennsylvania | 42075 | 11650 | 223 |
974660 | 974660 | 2021-01-28 | Lebanon | Pennsylvania | 42075 | 11573 | 219 |
971415 | 971415 | 2021-01-27 | Lebanon | Pennsylvania | 42075 | 11511 | 217 |
968170 | 968170 | 2021-01-26 | Lebanon | Pennsylvania | 42075 | 11412 | 215 |
964926 | 964926 | 2021-01-25 | Lebanon | Pennsylvania | 42075 | 11354 | 212 |
961681 | 961681 | 2021-01-24 | Lebanon | Pennsylvania | 42075 | 11281 | 212 |
958436 | 958436 | 2021-01-23 | Lebanon | Pennsylvania | 42075 | 11249 | 210 |
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);