ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 42129 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536741 | 536741 | 2020-09-15 | Westmoreland | Pennsylvania | 42129 | 1993 | 49 |
533505 | 533505 | 2020-09-14 | Westmoreland | Pennsylvania | 42129 | 1985 | 49 |
530270 | 530270 | 2020-09-13 | Westmoreland | Pennsylvania | 42129 | 1962 | 49 |
527033 | 527033 | 2020-09-12 | Westmoreland | Pennsylvania | 42129 | 1962 | 49 |
523797 | 523797 | 2020-09-11 | Westmoreland | Pennsylvania | 42129 | 1945 | 49 |
520561 | 520561 | 2020-09-10 | Westmoreland | Pennsylvania | 42129 | 1925 | 49 |
517325 | 517325 | 2020-09-09 | Westmoreland | Pennsylvania | 42129 | 1914 | 49 |
514090 | 514090 | 2020-09-08 | Westmoreland | Pennsylvania | 42129 | 1907 | 49 |
510857 | 510857 | 2020-09-07 | Westmoreland | Pennsylvania | 42129 | 1897 | 49 |
507624 | 507624 | 2020-09-06 | Westmoreland | Pennsylvania | 42129 | 1888 | 49 |
504392 | 504392 | 2020-09-05 | Westmoreland | Pennsylvania | 42129 | 1868 | 49 |
501158 | 501158 | 2020-09-04 | Westmoreland | Pennsylvania | 42129 | 1861 | 49 |
497924 | 497924 | 2020-09-03 | Westmoreland | Pennsylvania | 42129 | 1851 | 49 |
494691 | 494691 | 2020-09-02 | Westmoreland | Pennsylvania | 42129 | 1837 | 49 |
491457 | 491457 | 2020-09-01 | Westmoreland | Pennsylvania | 42129 | 1819 | 49 |
488224 | 488224 | 2020-08-31 | Westmoreland | Pennsylvania | 42129 | 1815 | 49 |
484991 | 484991 | 2020-08-30 | Westmoreland | Pennsylvania | 42129 | 1809 | 49 |
481756 | 481756 | 2020-08-29 | Westmoreland | Pennsylvania | 42129 | 1802 | 49 |
478522 | 478522 | 2020-08-28 | Westmoreland | Pennsylvania | 42129 | 1789 | 49 |
475289 | 475289 | 2020-08-27 | Westmoreland | Pennsylvania | 42129 | 1778 | 49 |
472055 | 472055 | 2020-08-26 | Westmoreland | Pennsylvania | 42129 | 1763 | 49 |
468823 | 468823 | 2020-08-25 | Westmoreland | Pennsylvania | 42129 | 1748 | 49 |
465595 | 465595 | 2020-08-24 | Westmoreland | Pennsylvania | 42129 | 1740 | 49 |
462366 | 462366 | 2020-08-23 | Westmoreland | Pennsylvania | 42129 | 1731 | 49 |
459138 | 459138 | 2020-08-22 | Westmoreland | Pennsylvania | 42129 | 1716 | 49 |
455910 | 455910 | 2020-08-21 | Westmoreland | Pennsylvania | 42129 | 1696 | 49 |
452682 | 452682 | 2020-08-20 | Westmoreland | Pennsylvania | 42129 | 1678 | 49 |
449454 | 449454 | 2020-08-19 | Westmoreland | Pennsylvania | 42129 | 1658 | 49 |
446226 | 446226 | 2020-08-18 | Westmoreland | Pennsylvania | 42129 | 1640 | 48 |
443000 | 443000 | 2020-08-17 | Westmoreland | Pennsylvania | 42129 | 1627 | 48 |
439773 | 439773 | 2020-08-16 | Westmoreland | Pennsylvania | 42129 | 1620 | 48 |
436548 | 436548 | 2020-08-15 | Westmoreland | Pennsylvania | 42129 | 1609 | 48 |
433321 | 433321 | 2020-08-14 | Westmoreland | Pennsylvania | 42129 | 1593 | 47 |
430095 | 430095 | 2020-08-13 | Westmoreland | Pennsylvania | 42129 | 1586 | 47 |
426870 | 426870 | 2020-08-12 | Westmoreland | Pennsylvania | 42129 | 1573 | 47 |
423647 | 423647 | 2020-08-11 | Westmoreland | Pennsylvania | 42129 | 1555 | 47 |
420424 | 420424 | 2020-08-10 | Westmoreland | Pennsylvania | 42129 | 1553 | 46 |
417204 | 417204 | 2020-08-09 | Westmoreland | Pennsylvania | 42129 | 1537 | 46 |
413983 | 413983 | 2020-08-08 | Westmoreland | Pennsylvania | 42129 | 1523 | 46 |
410763 | 410763 | 2020-08-07 | Westmoreland | Pennsylvania | 42129 | 1500 | 46 |
407543 | 407543 | 2020-08-06 | Westmoreland | Pennsylvania | 42129 | 1484 | 46 |
404324 | 404324 | 2020-08-05 | Westmoreland | Pennsylvania | 42129 | 1475 | 46 |
401106 | 401106 | 2020-08-04 | Westmoreland | Pennsylvania | 42129 | 1464 | 46 |
397891 | 397891 | 2020-08-03 | Westmoreland | Pennsylvania | 42129 | 1457 | 46 |
394674 | 394674 | 2020-08-02 | Westmoreland | Pennsylvania | 42129 | 1438 | 46 |
391458 | 391458 | 2020-08-01 | Westmoreland | Pennsylvania | 42129 | 1422 | 46 |
388241 | 388241 | 2020-07-31 | Westmoreland | Pennsylvania | 42129 | 1409 | 46 |
385024 | 385024 | 2020-07-30 | Westmoreland | Pennsylvania | 42129 | 1382 | 45 |
381806 | 381806 | 2020-07-29 | Westmoreland | Pennsylvania | 42129 | 1351 | 45 |
378589 | 378589 | 2020-07-28 | Westmoreland | Pennsylvania | 42129 | 1327 | 44 |
375373 | 375373 | 2020-07-27 | Westmoreland | Pennsylvania | 42129 | 1313 | 43 |
372160 | 372160 | 2020-07-26 | Westmoreland | Pennsylvania | 42129 | 1302 | 43 |
368948 | 368948 | 2020-07-25 | Westmoreland | Pennsylvania | 42129 | 1271 | 43 |
365739 | 365739 | 2020-07-24 | Westmoreland | Pennsylvania | 42129 | 1252 | 42 |
362533 | 362533 | 2020-07-23 | Westmoreland | Pennsylvania | 42129 | 1234 | 41 |
359327 | 359327 | 2020-07-22 | Westmoreland | Pennsylvania | 42129 | 1214 | 41 |
356123 | 356123 | 2020-07-21 | Westmoreland | Pennsylvania | 42129 | 1193 | 40 |
352920 | 352920 | 2020-07-20 | Westmoreland | Pennsylvania | 42129 | 1174 | 40 |
349717 | 349717 | 2020-07-19 | Westmoreland | Pennsylvania | 42129 | 1153 | 40 |
346517 | 346517 | 2020-07-18 | Westmoreland | Pennsylvania | 42129 | 1135 | 40 |
343317 | 343317 | 2020-07-17 | Westmoreland | Pennsylvania | 42129 | 1117 | 40 |
340119 | 340119 | 2020-07-16 | Westmoreland | Pennsylvania | 42129 | 1089 | 40 |
336922 | 336922 | 2020-07-15 | Westmoreland | Pennsylvania | 42129 | 1054 | 39 |
333728 | 333728 | 2020-07-14 | Westmoreland | Pennsylvania | 42129 | 1033 | 39 |
330536 | 330536 | 2020-07-13 | Westmoreland | Pennsylvania | 42129 | 1010 | 39 |
327350 | 327350 | 2020-07-12 | Westmoreland | Pennsylvania | 42129 | 994 | 39 |
324165 | 324165 | 2020-07-11 | Westmoreland | Pennsylvania | 42129 | 975 | 39 |
320985 | 320985 | 2020-07-10 | Westmoreland | Pennsylvania | 42129 | 952 | 39 |
317807 | 317807 | 2020-07-09 | Westmoreland | Pennsylvania | 42129 | 917 | 39 |
314634 | 314634 | 2020-07-08 | Westmoreland | Pennsylvania | 42129 | 896 | 39 |
311462 | 311462 | 2020-07-07 | Westmoreland | Pennsylvania | 42129 | 863 | 39 |
308293 | 308293 | 2020-07-06 | Westmoreland | Pennsylvania | 42129 | 828 | 38 |
305126 | 305126 | 2020-07-05 | Westmoreland | Pennsylvania | 42129 | 801 | 38 |
301963 | 301963 | 2020-07-04 | Westmoreland | Pennsylvania | 42129 | 774 | 38 |
298799 | 298799 | 2020-07-03 | Westmoreland | Pennsylvania | 42129 | 744 | 38 |
295640 | 295640 | 2020-07-02 | Westmoreland | Pennsylvania | 42129 | 711 | 38 |
292484 | 292484 | 2020-07-01 | Westmoreland | Pennsylvania | 42129 | 675 | 38 |
289332 | 289332 | 2020-06-30 | Westmoreland | Pennsylvania | 42129 | 646 | 38 |
286181 | 286181 | 2020-06-29 | Westmoreland | Pennsylvania | 42129 | 640 | 38 |
283036 | 283036 | 2020-06-28 | Westmoreland | Pennsylvania | 42129 | 620 | 38 |
279890 | 279890 | 2020-06-27 | Westmoreland | Pennsylvania | 42129 | 607 | 38 |
276742 | 276742 | 2020-06-26 | Westmoreland | Pennsylvania | 42129 | 587 | 38 |
273595 | 273595 | 2020-06-25 | Westmoreland | Pennsylvania | 42129 | 578 | 38 |
270456 | 270456 | 2020-06-24 | Westmoreland | Pennsylvania | 42129 | 563 | 38 |
267322 | 267322 | 2020-06-23 | Westmoreland | Pennsylvania | 42129 | 552 | 38 |
264194 | 264194 | 2020-06-22 | Westmoreland | Pennsylvania | 42129 | 546 | 38 |
261066 | 261066 | 2020-06-21 | Westmoreland | Pennsylvania | 42129 | 530 | 38 |
257939 | 257939 | 2020-06-20 | Westmoreland | Pennsylvania | 42129 | 519 | 38 |
254813 | 254813 | 2020-06-19 | Westmoreland | Pennsylvania | 42129 | 510 | 38 |
251698 | 251698 | 2020-06-18 | Westmoreland | Pennsylvania | 42129 | 502 | 38 |
248583 | 248583 | 2020-06-17 | Westmoreland | Pennsylvania | 42129 | 498 | 38 |
245470 | 245470 | 2020-06-16 | Westmoreland | Pennsylvania | 42129 | 493 | 38 |
242358 | 242358 | 2020-06-15 | Westmoreland | Pennsylvania | 42129 | 492 | 38 |
239249 | 239249 | 2020-06-14 | Westmoreland | Pennsylvania | 42129 | 490 | 38 |
236141 | 236141 | 2020-06-13 | Westmoreland | Pennsylvania | 42129 | 487 | 38 |
233036 | 233036 | 2020-06-12 | Westmoreland | Pennsylvania | 42129 | 483 | 38 |
229931 | 229931 | 2020-06-11 | Westmoreland | Pennsylvania | 42129 | 474 | 38 |
226827 | 226827 | 2020-06-10 | Westmoreland | Pennsylvania | 42129 | 473 | 38 |
223727 | 223727 | 2020-06-09 | Westmoreland | Pennsylvania | 42129 | 467 | 38 |
220632 | 220632 | 2020-06-08 | Westmoreland | Pennsylvania | 42129 | 461 | 38 |
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);