ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Lycoming" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419431 | 1419431 | 2021-06-14 | Lycoming | Pennsylvania | 42081 | 11922 | 291 |
1416186 | 1416186 | 2021-06-13 | Lycoming | Pennsylvania | 42081 | 11918 | 291 |
1412940 | 1412940 | 2021-06-12 | Lycoming | Pennsylvania | 42081 | 11917 | 291 |
1409695 | 1409695 | 2021-06-11 | Lycoming | Pennsylvania | 42081 | 11916 | 291 |
1406450 | 1406450 | 2021-06-10 | Lycoming | Pennsylvania | 42081 | 11914 | 291 |
1403204 | 1403204 | 2021-06-09 | Lycoming | Pennsylvania | 42081 | 11907 | 291 |
1399959 | 1399959 | 2021-06-08 | Lycoming | Pennsylvania | 42081 | 11905 | 290 |
1396714 | 1396714 | 2021-06-07 | Lycoming | Pennsylvania | 42081 | 11902 | 288 |
1393467 | 1393467 | 2021-06-06 | Lycoming | Pennsylvania | 42081 | 11899 | 288 |
1390222 | 1390222 | 2021-06-05 | Lycoming | Pennsylvania | 42081 | 11895 | 288 |
1386977 | 1386977 | 2021-06-04 | Lycoming | Pennsylvania | 42081 | 11891 | 288 |
1383732 | 1383732 | 2021-06-03 | Lycoming | Pennsylvania | 42081 | 11881 | 287 |
1380486 | 1380486 | 2021-06-02 | Lycoming | Pennsylvania | 42081 | 11878 | 287 |
1377241 | 1377241 | 2021-06-01 | Lycoming | Pennsylvania | 42081 | 11872 | 286 |
1373995 | 1373995 | 2021-05-31 | Lycoming | Pennsylvania | 42081 | 11863 | 286 |
1370750 | 1370750 | 2021-05-30 | Lycoming | Pennsylvania | 42081 | 11859 | 286 |
1367504 | 1367504 | 2021-05-29 | Lycoming | Pennsylvania | 42081 | 11856 | 286 |
1364258 | 1364258 | 2021-05-28 | Lycoming | Pennsylvania | 42081 | 11849 | 285 |
1361012 | 1361012 | 2021-05-27 | Lycoming | Pennsylvania | 42081 | 11841 | 284 |
1357766 | 1357766 | 2021-05-26 | Lycoming | Pennsylvania | 42081 | 11827 | 284 |
1354520 | 1354520 | 2021-05-25 | Lycoming | Pennsylvania | 42081 | 11816 | 284 |
1351274 | 1351274 | 2021-05-24 | Lycoming | Pennsylvania | 42081 | 11806 | 284 |
1348028 | 1348028 | 2021-05-23 | Lycoming | Pennsylvania | 42081 | 11796 | 284 |
1344780 | 1344780 | 2021-05-22 | Lycoming | Pennsylvania | 42081 | 11755 | 284 |
1341532 | 1341532 | 2021-05-21 | Lycoming | Pennsylvania | 42081 | 11755 | 284 |
1338284 | 1338284 | 2021-05-20 | Lycoming | Pennsylvania | 42081 | 11739 | 284 |
1335037 | 1335037 | 2021-05-19 | Lycoming | Pennsylvania | 42081 | 11719 | 284 |
1331790 | 1331790 | 2021-05-18 | Lycoming | Pennsylvania | 42081 | 11711 | 283 |
1328543 | 1328543 | 2021-05-17 | Lycoming | Pennsylvania | 42081 | 11683 | 283 |
1325297 | 1325297 | 2021-05-16 | Lycoming | Pennsylvania | 42081 | 11682 | 282 |
1322051 | 1322051 | 2021-05-15 | Lycoming | Pennsylvania | 42081 | 11676 | 280 |
1318805 | 1318805 | 2021-05-14 | Lycoming | Pennsylvania | 42081 | 11656 | 280 |
1315557 | 1315557 | 2021-05-13 | Lycoming | Pennsylvania | 42081 | 11635 | 280 |
1312311 | 1312311 | 2021-05-12 | Lycoming | Pennsylvania | 42081 | 11612 | 278 |
1309064 | 1309064 | 2021-05-11 | Lycoming | Pennsylvania | 42081 | 11590 | 278 |
1305818 | 1305818 | 2021-05-10 | Lycoming | Pennsylvania | 42081 | 11558 | 277 |
1302572 | 1302572 | 2021-05-09 | Lycoming | Pennsylvania | 42081 | 11552 | 277 |
1299325 | 1299325 | 2021-05-08 | Lycoming | Pennsylvania | 42081 | 11532 | 277 |
1296078 | 1296078 | 2021-05-07 | Lycoming | Pennsylvania | 42081 | 11480 | 277 |
1292832 | 1292832 | 2021-05-06 | Lycoming | Pennsylvania | 42081 | 11465 | 277 |
1289586 | 1289586 | 2021-05-05 | Lycoming | Pennsylvania | 42081 | 11438 | 277 |
1286340 | 1286340 | 2021-05-04 | Lycoming | Pennsylvania | 42081 | 11424 | 276 |
1283094 | 1283094 | 2021-05-03 | Lycoming | Pennsylvania | 42081 | 11395 | 276 |
1279847 | 1279847 | 2021-05-02 | Lycoming | Pennsylvania | 42081 | 11379 | 276 |
1276600 | 1276600 | 2021-05-01 | Lycoming | Pennsylvania | 42081 | 11341 | 276 |
1273353 | 1273353 | 2021-04-30 | Lycoming | Pennsylvania | 42081 | 11322 | 276 |
1270106 | 1270106 | 2021-04-29 | Lycoming | Pennsylvania | 42081 | 11286 | 274 |
1266859 | 1266859 | 2021-04-28 | Lycoming | Pennsylvania | 42081 | 11259 | 274 |
1263612 | 1263612 | 2021-04-27 | Lycoming | Pennsylvania | 42081 | 11237 | 274 |
1260365 | 1260365 | 2021-04-26 | Lycoming | Pennsylvania | 42081 | 11202 | 274 |
1257118 | 1257118 | 2021-04-25 | Lycoming | Pennsylvania | 42081 | 11195 | 274 |
1253871 | 1253871 | 2021-04-24 | Lycoming | Pennsylvania | 42081 | 11153 | 274 |
1250624 | 1250624 | 2021-04-23 | Lycoming | Pennsylvania | 42081 | 11113 | 273 |
1247377 | 1247377 | 2021-04-22 | Lycoming | Pennsylvania | 42081 | 11071 | 272 |
1244130 | 1244130 | 2021-04-21 | Lycoming | Pennsylvania | 42081 | 11029 | 272 |
1240883 | 1240883 | 2021-04-20 | Lycoming | Pennsylvania | 42081 | 10994 | 270 |
1237636 | 1237636 | 2021-04-19 | Lycoming | Pennsylvania | 42081 | 10952 | 270 |
1234389 | 1234389 | 2021-04-18 | Lycoming | Pennsylvania | 42081 | 10936 | 270 |
1231141 | 1231141 | 2021-04-17 | Lycoming | Pennsylvania | 42081 | 10910 | 270 |
1227893 | 1227893 | 2021-04-16 | Lycoming | Pennsylvania | 42081 | 10864 | 269 |
1224645 | 1224645 | 2021-04-15 | Lycoming | Pennsylvania | 42081 | 10817 | 268 |
1221398 | 1221398 | 2021-04-14 | Lycoming | Pennsylvania | 42081 | 10766 | 268 |
1218150 | 1218150 | 2021-04-13 | Lycoming | Pennsylvania | 42081 | 10736 | 267 |
1214902 | 1214902 | 2021-04-12 | Lycoming | Pennsylvania | 42081 | 10683 | 266 |
1211655 | 1211655 | 2021-04-11 | Lycoming | Pennsylvania | 42081 | 10673 | 266 |
1208406 | 1208406 | 2021-04-10 | Lycoming | Pennsylvania | 42081 | 10624 | 266 |
1205158 | 1205158 | 2021-04-09 | Lycoming | Pennsylvania | 42081 | 10591 | 266 |
1201910 | 1201910 | 2021-04-08 | Lycoming | Pennsylvania | 42081 | 10556 | 266 |
1198661 | 1198661 | 2021-04-07 | Lycoming | Pennsylvania | 42081 | 10515 | 265 |
1195412 | 1195412 | 2021-04-06 | Lycoming | Pennsylvania | 42081 | 10478 | 265 |
1192164 | 1192164 | 2021-04-05 | Lycoming | Pennsylvania | 42081 | 10435 | 265 |
1188915 | 1188915 | 2021-04-04 | Lycoming | Pennsylvania | 42081 | 10401 | 265 |
1185668 | 1185668 | 2021-04-03 | Lycoming | Pennsylvania | 42081 | 10386 | 265 |
1182421 | 1182421 | 2021-04-02 | Lycoming | Pennsylvania | 42081 | 10300 | 264 |
1179174 | 1179174 | 2021-04-01 | Lycoming | Pennsylvania | 42081 | 10252 | 263 |
1175927 | 1175927 | 2021-03-31 | Lycoming | Pennsylvania | 42081 | 10213 | 262 |
1172680 | 1172680 | 2021-03-30 | Lycoming | Pennsylvania | 42081 | 10139 | 261 |
1169433 | 1169433 | 2021-03-29 | Lycoming | Pennsylvania | 42081 | 10108 | 261 |
1166185 | 1166185 | 2021-03-28 | Lycoming | Pennsylvania | 42081 | 10080 | 261 |
1162937 | 1162937 | 2021-03-27 | Lycoming | Pennsylvania | 42081 | 10066 | 261 |
1159688 | 1159688 | 2021-03-26 | Lycoming | Pennsylvania | 42081 | 9997 | 261 |
1156441 | 1156441 | 2021-03-25 | Lycoming | Pennsylvania | 42081 | 9953 | 261 |
1153194 | 1153194 | 2021-03-24 | Lycoming | Pennsylvania | 42081 | 9917 | 259 |
1149947 | 1149947 | 2021-03-23 | Lycoming | Pennsylvania | 42081 | 9881 | 259 |
1146700 | 1146700 | 2021-03-22 | Lycoming | Pennsylvania | 42081 | 9846 | 257 |
1143453 | 1143453 | 2021-03-21 | Lycoming | Pennsylvania | 42081 | 9836 | 257 |
1140206 | 1140206 | 2021-03-20 | Lycoming | Pennsylvania | 42081 | 9818 | 257 |
1136960 | 1136960 | 2021-03-19 | Lycoming | Pennsylvania | 42081 | 9771 | 257 |
1133714 | 1133714 | 2021-03-18 | Lycoming | Pennsylvania | 42081 | 9749 | 254 |
1130466 | 1130466 | 2021-03-17 | Lycoming | Pennsylvania | 42081 | 9715 | 254 |
1127219 | 1127219 | 2021-03-16 | Lycoming | Pennsylvania | 42081 | 9696 | 254 |
1123973 | 1123973 | 2021-03-15 | Lycoming | Pennsylvania | 42081 | 9657 | 254 |
1120727 | 1120727 | 2021-03-14 | Lycoming | Pennsylvania | 42081 | 9647 | 253 |
1117480 | 1117480 | 2021-03-13 | Lycoming | Pennsylvania | 42081 | 9627 | 253 |
1114233 | 1114233 | 2021-03-12 | Lycoming | Pennsylvania | 42081 | 9601 | 253 |
1110987 | 1110987 | 2021-03-11 | Lycoming | Pennsylvania | 42081 | 9582 | 253 |
1107741 | 1107741 | 2021-03-10 | Lycoming | Pennsylvania | 42081 | 9552 | 251 |
1104495 | 1104495 | 2021-03-09 | Lycoming | Pennsylvania | 42081 | 9526 | 249 |
1101249 | 1101249 | 2021-03-08 | Lycoming | Pennsylvania | 42081 | 9493 | 249 |
1098003 | 1098003 | 2021-03-07 | Lycoming | Pennsylvania | 42081 | 9476 | 249 |
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);