ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Fayette" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419416 | 1419416 | 2021-06-14 | Fayette | Pennsylvania | 42051 | 13341 | 328 |
1416171 | 1416171 | 2021-06-13 | Fayette | Pennsylvania | 42051 | 13337 | 328 |
1412925 | 1412925 | 2021-06-12 | Fayette | Pennsylvania | 42051 | 13336 | 328 |
1409680 | 1409680 | 2021-06-11 | Fayette | Pennsylvania | 42051 | 13334 | 325 |
1406435 | 1406435 | 2021-06-10 | Fayette | Pennsylvania | 42051 | 13319 | 325 |
1403189 | 1403189 | 2021-06-09 | Fayette | Pennsylvania | 42051 | 13294 | 325 |
1399944 | 1399944 | 2021-06-08 | Fayette | Pennsylvania | 42051 | 13290 | 325 |
1396699 | 1396699 | 2021-06-07 | Fayette | Pennsylvania | 42051 | 13273 | 324 |
1393452 | 1393452 | 2021-06-06 | Fayette | Pennsylvania | 42051 | 13267 | 324 |
1390207 | 1390207 | 2021-06-05 | Fayette | Pennsylvania | 42051 | 13261 | 324 |
1386962 | 1386962 | 2021-06-04 | Fayette | Pennsylvania | 42051 | 13252 | 323 |
1383717 | 1383717 | 2021-06-03 | Fayette | Pennsylvania | 42051 | 13235 | 323 |
1380471 | 1380471 | 2021-06-02 | Fayette | Pennsylvania | 42051 | 13228 | 322 |
1377226 | 1377226 | 2021-06-01 | Fayette | Pennsylvania | 42051 | 13217 | 322 |
1373980 | 1373980 | 2021-05-31 | Fayette | Pennsylvania | 42051 | 13198 | 322 |
1370735 | 1370735 | 2021-05-30 | Fayette | Pennsylvania | 42051 | 13194 | 322 |
1367489 | 1367489 | 2021-05-29 | Fayette | Pennsylvania | 42051 | 13183 | 322 |
1364243 | 1364243 | 2021-05-28 | Fayette | Pennsylvania | 42051 | 13177 | 322 |
1360997 | 1360997 | 2021-05-27 | Fayette | Pennsylvania | 42051 | 13152 | 320 |
1357751 | 1357751 | 2021-05-26 | Fayette | Pennsylvania | 42051 | 13144 | 318 |
1354505 | 1354505 | 2021-05-25 | Fayette | Pennsylvania | 42051 | 13128 | 317 |
1351259 | 1351259 | 2021-05-24 | Fayette | Pennsylvania | 42051 | 13105 | 316 |
1348013 | 1348013 | 2021-05-23 | Fayette | Pennsylvania | 42051 | 13096 | 316 |
1344765 | 1344765 | 2021-05-22 | Fayette | Pennsylvania | 42051 | 13060 | 316 |
1341517 | 1341517 | 2021-05-21 | Fayette | Pennsylvania | 42051 | 13060 | 315 |
1338269 | 1338269 | 2021-05-20 | Fayette | Pennsylvania | 42051 | 13017 | 314 |
1335022 | 1335022 | 2021-05-19 | Fayette | Pennsylvania | 42051 | 12990 | 314 |
1331775 | 1331775 | 2021-05-18 | Fayette | Pennsylvania | 42051 | 12968 | 313 |
1328528 | 1328528 | 2021-05-17 | Fayette | Pennsylvania | 42051 | 12917 | 312 |
1325282 | 1325282 | 2021-05-16 | Fayette | Pennsylvania | 42051 | 12903 | 312 |
1322036 | 1322036 | 2021-05-15 | Fayette | Pennsylvania | 42051 | 12893 | 312 |
1318790 | 1318790 | 2021-05-14 | Fayette | Pennsylvania | 42051 | 12843 | 312 |
1315542 | 1315542 | 2021-05-13 | Fayette | Pennsylvania | 42051 | 12820 | 311 |
1312296 | 1312296 | 2021-05-12 | Fayette | Pennsylvania | 42051 | 12798 | 311 |
1309049 | 1309049 | 2021-05-11 | Fayette | Pennsylvania | 42051 | 12764 | 311 |
1305803 | 1305803 | 2021-05-10 | Fayette | Pennsylvania | 42051 | 12722 | 309 |
1302557 | 1302557 | 2021-05-09 | Fayette | Pennsylvania | 42051 | 12713 | 309 |
1299310 | 1299310 | 2021-05-08 | Fayette | Pennsylvania | 42051 | 12704 | 309 |
1296063 | 1296063 | 2021-05-07 | Fayette | Pennsylvania | 42051 | 12653 | 309 |
1292817 | 1292817 | 2021-05-06 | Fayette | Pennsylvania | 42051 | 12622 | 309 |
1289571 | 1289571 | 2021-05-05 | Fayette | Pennsylvania | 42051 | 12596 | 308 |
1286325 | 1286325 | 2021-05-04 | Fayette | Pennsylvania | 42051 | 12576 | 308 |
1283079 | 1283079 | 2021-05-03 | Fayette | Pennsylvania | 42051 | 12552 | 306 |
1279832 | 1279832 | 2021-05-02 | Fayette | Pennsylvania | 42051 | 12518 | 306 |
1276585 | 1276585 | 2021-05-01 | Fayette | Pennsylvania | 42051 | 12470 | 306 |
1273338 | 1273338 | 2021-04-30 | Fayette | Pennsylvania | 42051 | 12438 | 306 |
1270091 | 1270091 | 2021-04-29 | Fayette | Pennsylvania | 42051 | 12363 | 306 |
1266844 | 1266844 | 2021-04-28 | Fayette | Pennsylvania | 42051 | 12339 | 306 |
1263597 | 1263597 | 2021-04-27 | Fayette | Pennsylvania | 42051 | 12315 | 305 |
1260350 | 1260350 | 2021-04-26 | Fayette | Pennsylvania | 42051 | 12269 | 302 |
1257103 | 1257103 | 2021-04-25 | Fayette | Pennsylvania | 42051 | 12263 | 302 |
1253856 | 1253856 | 2021-04-24 | Fayette | Pennsylvania | 42051 | 12228 | 302 |
1250609 | 1250609 | 2021-04-23 | Fayette | Pennsylvania | 42051 | 12185 | 302 |
1247362 | 1247362 | 2021-04-22 | Fayette | Pennsylvania | 42051 | 12159 | 302 |
1244115 | 1244115 | 2021-04-21 | Fayette | Pennsylvania | 42051 | 12124 | 302 |
1240868 | 1240868 | 2021-04-20 | Fayette | Pennsylvania | 42051 | 12075 | 299 |
1237621 | 1237621 | 2021-04-19 | Fayette | Pennsylvania | 42051 | 12018 | 298 |
1234374 | 1234374 | 2021-04-18 | Fayette | Pennsylvania | 42051 | 12012 | 298 |
1231126 | 1231126 | 2021-04-17 | Fayette | Pennsylvania | 42051 | 11989 | 298 |
1227878 | 1227878 | 2021-04-16 | Fayette | Pennsylvania | 42051 | 11923 | 297 |
1224630 | 1224630 | 2021-04-15 | Fayette | Pennsylvania | 42051 | 11875 | 296 |
1221383 | 1221383 | 2021-04-14 | Fayette | Pennsylvania | 42051 | 11836 | 296 |
1218135 | 1218135 | 2021-04-13 | Fayette | Pennsylvania | 42051 | 11790 | 296 |
1214887 | 1214887 | 2021-04-12 | Fayette | Pennsylvania | 42051 | 11733 | 296 |
1211640 | 1211640 | 2021-04-11 | Fayette | Pennsylvania | 42051 | 11706 | 296 |
1208391 | 1208391 | 2021-04-10 | Fayette | Pennsylvania | 42051 | 11640 | 296 |
1205143 | 1205143 | 2021-04-09 | Fayette | Pennsylvania | 42051 | 11602 | 294 |
1201895 | 1201895 | 2021-04-08 | Fayette | Pennsylvania | 42051 | 11535 | 294 |
1198646 | 1198646 | 2021-04-07 | Fayette | Pennsylvania | 42051 | 11503 | 294 |
1195397 | 1195397 | 2021-04-06 | Fayette | Pennsylvania | 42051 | 11461 | 291 |
1192149 | 1192149 | 2021-04-05 | Fayette | Pennsylvania | 42051 | 11396 | 290 |
1188900 | 1188900 | 2021-04-04 | Fayette | Pennsylvania | 42051 | 11376 | 290 |
1185653 | 1185653 | 2021-04-03 | Fayette | Pennsylvania | 42051 | 11352 | 290 |
1182406 | 1182406 | 2021-04-02 | Fayette | Pennsylvania | 42051 | 11279 | 289 |
1179159 | 1179159 | 2021-04-01 | Fayette | Pennsylvania | 42051 | 11239 | 289 |
1175912 | 1175912 | 2021-03-31 | Fayette | Pennsylvania | 42051 | 11216 | 288 |
1172665 | 1172665 | 2021-03-30 | Fayette | Pennsylvania | 42051 | 11174 | 286 |
1169418 | 1169418 | 2021-03-29 | Fayette | Pennsylvania | 42051 | 11152 | 286 |
1166170 | 1166170 | 2021-03-28 | Fayette | Pennsylvania | 42051 | 11108 | 286 |
1162922 | 1162922 | 2021-03-27 | Fayette | Pennsylvania | 42051 | 11089 | 286 |
1159673 | 1159673 | 2021-03-26 | Fayette | Pennsylvania | 42051 | 11073 | 286 |
1156426 | 1156426 | 2021-03-25 | Fayette | Pennsylvania | 42051 | 11031 | 286 |
1153179 | 1153179 | 2021-03-24 | Fayette | Pennsylvania | 42051 | 11017 | 285 |
1149932 | 1149932 | 2021-03-23 | Fayette | Pennsylvania | 42051 | 10983 | 285 |
1146685 | 1146685 | 2021-03-22 | Fayette | Pennsylvania | 42051 | 10957 | 282 |
1143438 | 1143438 | 2021-03-21 | Fayette | Pennsylvania | 42051 | 10944 | 282 |
1140191 | 1140191 | 2021-03-20 | Fayette | Pennsylvania | 42051 | 10915 | 282 |
1136945 | 1136945 | 2021-03-19 | Fayette | Pennsylvania | 42051 | 10884 | 281 |
1133699 | 1133699 | 2021-03-18 | Fayette | Pennsylvania | 42051 | 10857 | 281 |
1130451 | 1130451 | 2021-03-17 | Fayette | Pennsylvania | 42051 | 10828 | 281 |
1127204 | 1127204 | 2021-03-16 | Fayette | Pennsylvania | 42051 | 10798 | 280 |
1123958 | 1123958 | 2021-03-15 | Fayette | Pennsylvania | 42051 | 10760 | 273 |
1120712 | 1120712 | 2021-03-14 | Fayette | Pennsylvania | 42051 | 10750 | 271 |
1117465 | 1117465 | 2021-03-13 | Fayette | Pennsylvania | 42051 | 10734 | 271 |
1114218 | 1114218 | 2021-03-12 | Fayette | Pennsylvania | 42051 | 10705 | 271 |
1110972 | 1110972 | 2021-03-11 | Fayette | Pennsylvania | 42051 | 10680 | 271 |
1107726 | 1107726 | 2021-03-10 | Fayette | Pennsylvania | 42051 | 10657 | 271 |
1104480 | 1104480 | 2021-03-09 | Fayette | Pennsylvania | 42051 | 10640 | 271 |
1101234 | 1101234 | 2021-03-08 | Fayette | Pennsylvania | 42051 | 10613 | 270 |
1097988 | 1097988 | 2021-03-07 | Fayette | Pennsylvania | 42051 | 10607 | 269 |
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);