ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

7,752 rows where state = "Pennsylvania" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Pennsylvania · 7,752
Link rowid date ▲ county state fips cases deaths
336596 2020-07-15 Adams Pennsylvania 42001 399 14
336597 2020-07-15 Allegheny Pennsylvania 42003 5610 204
336598 2020-07-15 Armstrong Pennsylvania 42005 94 6
336599 2020-07-15 Beaver Pennsylvania 42007 884 79
336600 2020-07-15 Bedford Pennsylvania 42009 94 4
336601 2020-07-15 Berks Pennsylvania 42011 4744 359
336602 2020-07-15 Blair Pennsylvania 42013 113 1
336603 2020-07-15 Bradford Pennsylvania 42015 61 3
336604 2020-07-15 Bucks Pennsylvania 42017 6189 572
336605 2020-07-15 Butler Pennsylvania 42019 444 13
336606 2020-07-15 Cambria Pennsylvania 42021 143 3
336607 2020-07-15 Cameron Pennsylvania 42023 5 0
336608 2020-07-15 Carbon Pennsylvania 42025 306 27
336609 2020-07-15 Centre Pennsylvania 42027 262 8
336610 2020-07-15 Chester Pennsylvania 42029 4153 337
336611 2020-07-15 Clarion Pennsylvania 42031 66 2
336612 2020-07-15 Clearfield Pennsylvania 42033 96 0
336613 2020-07-15 Clinton Pennsylvania 42035 100 5
336614 2020-07-15 Columbia Pennsylvania 42037 424 35
336615 2020-07-15 Crawford Pennsylvania 42039 101 1
336616 2020-07-15 Cumberland Pennsylvania 42041 982 66
336617 2020-07-15 Dauphin Pennsylvania 42043 2325 149
336618 2020-07-15 Delaware Pennsylvania 42045 7698 717
336619 2020-07-15 Elk Pennsylvania 42047 31 0
336620 2020-07-15 Erie Pennsylvania 42049 747 13
336621 2020-07-15 Fayette Pennsylvania 42051 220 4
336622 2020-07-15 Forest Pennsylvania 42053 7 0
336623 2020-07-15 Franklin Pennsylvania 42055 1019 46
336624 2020-07-15 Fulton Pennsylvania 42057 19 1
336625 2020-07-15 Greene Pennsylvania 42059 75 0
336626 2020-07-15 Huntingdon Pennsylvania 42061 263 4
336627 2020-07-15 Indiana Pennsylvania 42063 168 6
336628 2020-07-15 Jefferson Pennsylvania 42065 41 1
336629 2020-07-15 Juniata Pennsylvania 42067 116 6
336630 2020-07-15 Lackawanna Pennsylvania 42069 1771 211
336631 2020-07-15 Lancaster Pennsylvania 42071 4906 388
336632 2020-07-15 Lawrence Pennsylvania 42073 207 9
336633 2020-07-15 Lebanon Pennsylvania 42075 1476 51
336634 2020-07-15 Lehigh Pennsylvania 42077 4465 330
336635 2020-07-15 Luzerne Pennsylvania 42079 3036 181
336636 2020-07-15 Lycoming Pennsylvania 42081 252 20
336637 2020-07-15 McKean Pennsylvania 42083 20 1
336638 2020-07-15 Mercer Pennsylvania 42085 203 6
336639 2020-07-15 Mifflin Pennsylvania 42087 74 1
336640 2020-07-15 Monroe Pennsylvania 42089 1482 113
336641 2020-07-15 Montgomery Pennsylvania 42091 8972 832
336642 2020-07-15 Montour Pennsylvania 42093 81 2
336643 2020-07-15 Northampton Pennsylvania 42095 3582 283
336644 2020-07-15 Northumberland Pennsylvania 42097 352 10
336645 2020-07-15 Perry Pennsylvania 42099 96 5
336646 2020-07-15 Philadelphia Pennsylvania 42101 27867 1653
336647 2020-07-15 Pike Pennsylvania 42103 508 21
336648 2020-07-15 Potter Pennsylvania 42105 19 0
336649 2020-07-15 Schuylkill Pennsylvania 42107 782 48
336650 2020-07-15 Snyder Pennsylvania 42109 74 2
336651 2020-07-15 Somerset Pennsylvania 42111 86 1
336652 2020-07-15 Sullivan Pennsylvania 42113 10 0
336653 2020-07-15 Susquehanna Pennsylvania 42115 195 26
336654 2020-07-15 Tioga Pennsylvania 42117 31 2
336655 2020-07-15 Union Pennsylvania 42119 108 2
336656 2020-07-15 Venango Pennsylvania 42121 49 0
336657 2020-07-15 Warren Pennsylvania 42123 11 1
336658 2020-07-15 Washington Pennsylvania 42125 494 6
336659 2020-07-15 Wayne Pennsylvania 42127 143 8
336660 2020-07-15 Westmoreland Pennsylvania 42129 1054 39
336661 2020-07-15 Wyoming Pennsylvania 42131 48 7
336662 2020-07-15 York Pennsylvania 42133 1908 66
333404 2020-07-14 Adams Pennsylvania 42001 399 14
333405 2020-07-14 Allegheny Pennsylvania 42003 5364 199
333406 2020-07-14 Armstrong Pennsylvania 42005 88 6
333407 2020-07-14 Beaver Pennsylvania 42007 870 79
333408 2020-07-14 Bedford Pennsylvania 42009 93 4
333409 2020-07-14 Berks Pennsylvania 42011 4710 358
333410 2020-07-14 Blair Pennsylvania 42013 107 1
333411 2020-07-14 Bradford Pennsylvania 42015 59 3
333412 2020-07-14 Bucks Pennsylvania 42017 6137 572
333413 2020-07-14 Butler Pennsylvania 42019 444 13
333414 2020-07-14 Cambria Pennsylvania 42021 137 3
333415 2020-07-14 Cameron Pennsylvania 42023 4 0
333416 2020-07-14 Carbon Pennsylvania 42025 301 27
333417 2020-07-14 Centre Pennsylvania 42027 253 8
333418 2020-07-14 Chester Pennsylvania 42029 4103 335
333419 2020-07-14 Clarion Pennsylvania 42031 66 2
333420 2020-07-14 Clearfield Pennsylvania 42033 95 0
333421 2020-07-14 Clinton Pennsylvania 42035 96 5
333422 2020-07-14 Columbia Pennsylvania 42037 421 35
333423 2020-07-14 Crawford Pennsylvania 42039 80 1
333424 2020-07-14 Cumberland Pennsylvania 42041 961 66
333425 2020-07-14 Dauphin Pennsylvania 42043 2309 149
333426 2020-07-14 Delaware Pennsylvania 42045 7650 709
333427 2020-07-14 Elk Pennsylvania 42047 31 0
333428 2020-07-14 Erie Pennsylvania 42049 740 13
333429 2020-07-14 Fayette Pennsylvania 42051 213 4
333430 2020-07-14 Forest Pennsylvania 42053 7 0
333431 2020-07-14 Franklin Pennsylvania 42055 1016 46
333432 2020-07-14 Fulton Pennsylvania 42057 19 1
333433 2020-07-14 Greene Pennsylvania 42059 72 0
333434 2020-07-14 Huntingdon Pennsylvania 42061 260 4
333435 2020-07-14 Indiana Pennsylvania 42063 169 6
333436 2020-07-14 Jefferson Pennsylvania 42065 41 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1107.556ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette