ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52,441 rows where state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 42045 629
- 42127 629
- 42091 628
- 42089 626
- 42101 625
- 42017 624
- 42095 623
- 42103 623
- 42029 622
- 42041 622
- 42125 622
- 42003 621
- 42077 620
- 42079 620
- 42007 618
- 42001 617
- 42011 617
- 42069 617
- 42133 617
- 42071 616
- 42075 616
- 42129 616
- 42027 615
- 42049 615
- 42055 615
- 42105 615
- 42019 614
- 42093 614
- 42037 613
- 42043 613
- …
county >30
- Delaware 629
- Wayne 629
- Montgomery 628
- Monroe 626
- Philadelphia 625
- Bucks 624
- Northampton 623
- Pike 623
- Chester 622
- Cumberland 622
- Washington 622
- Allegheny 621
- Lehigh 620
- Luzerne 620
- Beaver 618
- Adams 617
- Berks 617
- Lackawanna 617
- York 617
- Lancaster 616
- Lebanon 616
- Westmoreland 616
- Centre 615
- Erie 615
- Franklin 615
- Potter 615
- Butler 614
- Montour 614
- Columbia 613
- Dauphin 613
- …
state 1
- Pennsylvania · 41,051 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948862 | 1948862 | 2021-11-24 | Adams | Pennsylvania | 42001 | 14461 | 241 |
1948863 | 1948863 | 2021-11-24 | Allegheny | Pennsylvania | 42003 | 146794 | 2468 |
1948864 | 1948864 | 2021-11-24 | Armstrong | Pennsylvania | 42005 | 10155 | 224 |
1948865 | 1948865 | 2021-11-24 | Beaver | Pennsylvania | 42007 | 25234 | 519 |
1948866 | 1948866 | 2021-11-24 | Bedford | Pennsylvania | 42009 | 7604 | 191 |
1948867 | 1948867 | 2021-11-24 | Berks | Pennsylvania | 42011 | 63456 | 1195 |
1948868 | 1948868 | 2021-11-24 | Blair | Pennsylvania | 42013 | 20222 | 426 |
1948869 | 1948869 | 2021-11-24 | Bradford | Pennsylvania | 42015 | 9047 | 136 |
1948870 | 1948870 | 2021-11-24 | Bucks | Pennsylvania | 42017 | 77964 | 1474 |
1948871 | 1948871 | 2021-11-24 | Butler | Pennsylvania | 42019 | 28231 | 543 |
1948872 | 1948872 | 2021-11-24 | Cambria | Pennsylvania | 42021 | 22134 | 555 |
1948873 | 1948873 | 2021-11-24 | Cameron | Pennsylvania | 42023 | 584 | 13 |
1948874 | 1948874 | 2021-11-24 | Carbon | Pennsylvania | 42025 | 9785 | 209 |
1948875 | 1948875 | 2021-11-24 | Centre | Pennsylvania | 42027 | 22396 | 256 |
1948876 | 1948876 | 2021-11-24 | Chester | Pennsylvania | 42029 | 54518 | 902 |
1948877 | 1948877 | 2021-11-24 | Clarion | Pennsylvania | 42031 | 5777 | 140 |
1948878 | 1948878 | 2021-11-24 | Clearfield | Pennsylvania | 42033 | 12506 | 225 |
1948879 | 1948879 | 2021-11-24 | Clinton | Pennsylvania | 42035 | 5880 | 86 |
1948880 | 1948880 | 2021-11-24 | Columbia | Pennsylvania | 42037 | 8958 | 165 |
1948881 | 1948881 | 2021-11-24 | Crawford | Pennsylvania | 42039 | 12949 | 217 |
1948882 | 1948882 | 2021-11-24 | Cumberland | Pennsylvania | 42041 | 30896 | 649 |
1948883 | 1948883 | 2021-11-24 | Dauphin | Pennsylvania | 42043 | 37612 | 685 |
1948884 | 1948884 | 2021-11-24 | Delaware | Pennsylvania | 42045 | 65455 | 1525 |
1948885 | 1948885 | 2021-11-24 | Elk | Pennsylvania | 42047 | 4722 | 65 |
1948886 | 1948886 | 2021-11-24 | Erie | Pennsylvania | 42049 | 34725 | 539 |
1948887 | 1948887 | 2021-11-24 | Fayette | Pennsylvania | 42051 | 20118 | 452 |
1948888 | 1948888 | 2021-11-24 | Forest | Pennsylvania | 42053 | 1729 | 28 |
1948889 | 1948889 | 2021-11-24 | Franklin | Pennsylvania | 42055 | 23626 | 485 |
1948890 | 1948890 | 2021-11-24 | Fulton | Pennsylvania | 42057 | 2575 | 38 |
1948891 | 1948891 | 2021-11-24 | Greene | Pennsylvania | 42059 | 5550 | 65 |
1948892 | 1948892 | 2021-11-24 | Huntingdon | Pennsylvania | 42061 | 7455 | 175 |
1948893 | 1948893 | 2021-11-24 | Indiana | Pennsylvania | 42063 | 10527 | 261 |
1948894 | 1948894 | 2021-11-24 | Jefferson | Pennsylvania | 42065 | 5973 | 142 |
1948895 | 1948895 | 2021-11-24 | Juniata | Pennsylvania | 42067 | 3235 | 123 |
1948896 | 1948896 | 2021-11-24 | Lackawanna | Pennsylvania | 42069 | 24908 | 542 |
1948897 | 1948897 | 2021-11-24 | Lancaster | Pennsylvania | 42071 | 77149 | 1397 |
1948898 | 1948898 | 2021-11-24 | Lawrence | Pennsylvania | 42073 | 12344 | 285 |
1948899 | 1948899 | 2021-11-24 | Lebanon | Pennsylvania | 42075 | 22489 | 353 |
1948900 | 1948900 | 2021-11-24 | Lehigh | Pennsylvania | 42077 | 51852 | 958 |
1948901 | 1948901 | 2021-11-24 | Luzerne | Pennsylvania | 42079 | 45004 | 974 |
1948902 | 1948902 | 2021-11-24 | Lycoming | Pennsylvania | 42081 | 18947 | 382 |
1948903 | 1948903 | 2021-11-24 | McKean | Pennsylvania | 42083 | 5746 | 102 |
1948904 | 1948904 | 2021-11-24 | Mercer | Pennsylvania | 42085 | 15474 | 365 |
1948905 | 1948905 | 2021-11-24 | Mifflin | Pennsylvania | 42087 | 8008 | 220 |
1948906 | 1948906 | 2021-11-24 | Monroe | Pennsylvania | 42089 | 21361 | 378 |
1948907 | 1948907 | 2021-11-24 | Montgomery | Pennsylvania | 42091 | 91175 | 1895 |
1948908 | 1948908 | 2021-11-24 | Montour | Pennsylvania | 42093 | 2813 | 75 |
1948909 | 1948909 | 2021-11-24 | Northampton | Pennsylvania | 42095 | 47741 | 813 |
1948910 | 1948910 | 2021-11-24 | Northumberland | Pennsylvania | 42097 | 14470 | 422 |
1948911 | 1948911 | 2021-11-24 | Perry | Pennsylvania | 42099 | 5796 | 132 |
1948912 | 1948912 | 2021-11-24 | Philadelphia | Pennsylvania | 42101 | 189812 | 4088 |
1948913 | 1948913 | 2021-11-24 | Pike | Pennsylvania | 42103 | 5901 | 69 |
1948914 | 1948914 | 2021-11-24 | Potter | Pennsylvania | 42105 | 2220 | 54 |
1948915 | 1948915 | 2021-11-24 | Schuylkill | Pennsylvania | 42107 | 21768 | 497 |
1948916 | 1948916 | 2021-11-24 | Snyder | Pennsylvania | 42109 | 5263 | 110 |
1948917 | 1948917 | 2021-11-24 | Somerset | Pennsylvania | 42111 | 11913 | 272 |
1948918 | 1948918 | 2021-11-24 | Sullivan | Pennsylvania | 42113 | 646 | 24 |
1948919 | 1948919 | 2021-11-24 | Susquehanna | Pennsylvania | 42115 | 4440 | 74 |
1948920 | 1948920 | 2021-11-24 | Tioga | Pennsylvania | 42117 | 5407 | 146 |
1948921 | 1948921 | 2021-11-24 | Union | Pennsylvania | 42119 | 8020 | 109 |
1948922 | 1948922 | 2021-11-24 | Venango | Pennsylvania | 42121 | 7772 | 162 |
1948923 | 1948923 | 2021-11-24 | Warren | Pennsylvania | 42123 | 4961 | 149 |
1948924 | 1948924 | 2021-11-24 | Washington | Pennsylvania | 42125 | 29182 | 421 |
1948925 | 1948925 | 2021-11-24 | Wayne | Pennsylvania | 42127 | 6364 | 123 |
1948926 | 1948926 | 2021-11-24 | Westmoreland | Pennsylvania | 42129 | 50547 | 967 |
1948927 | 1948927 | 2021-11-24 | Wyoming | Pennsylvania | 42131 | 3116 | 68 |
1948928 | 1948928 | 2021-11-24 | York | Pennsylvania | 42133 | 69066 | 1058 |
1945611 | 1945611 | 2021-11-23 | Adams | Pennsylvania | 42001 | 14405 | 241 |
1945612 | 1945612 | 2021-11-23 | Allegheny | Pennsylvania | 42003 | 145902 | 2462 |
1945613 | 1945613 | 2021-11-23 | Armstrong | Pennsylvania | 42005 | 10101 | 224 |
1945614 | 1945614 | 2021-11-23 | Beaver | Pennsylvania | 42007 | 25068 | 513 |
1945615 | 1945615 | 2021-11-23 | Bedford | Pennsylvania | 42009 | 7576 | 189 |
1945616 | 1945616 | 2021-11-23 | Berks | Pennsylvania | 42011 | 63248 | 1190 |
1945617 | 1945617 | 2021-11-23 | Blair | Pennsylvania | 42013 | 20119 | 422 |
1945618 | 1945618 | 2021-11-23 | Bradford | Pennsylvania | 42015 | 8973 | 135 |
1945619 | 1945619 | 2021-11-23 | Bucks | Pennsylvania | 42017 | 77767 | 1468 |
1945620 | 1945620 | 2021-11-23 | Butler | Pennsylvania | 42019 | 28064 | 543 |
1945621 | 1945621 | 2021-11-23 | Cambria | Pennsylvania | 42021 | 21957 | 554 |
1945622 | 1945622 | 2021-11-23 | Cameron | Pennsylvania | 42023 | 576 | 13 |
1945623 | 1945623 | 2021-11-23 | Carbon | Pennsylvania | 42025 | 9747 | 209 |
1945624 | 1945624 | 2021-11-23 | Centre | Pennsylvania | 42027 | 22296 | 255 |
1945625 | 1945625 | 2021-11-23 | Chester | Pennsylvania | 42029 | 54377 | 902 |
1945626 | 1945626 | 2021-11-23 | Clarion | Pennsylvania | 42031 | 5720 | 139 |
1945627 | 1945627 | 2021-11-23 | Clearfield | Pennsylvania | 42033 | 12426 | 224 |
1945628 | 1945628 | 2021-11-23 | Clinton | Pennsylvania | 42035 | 5844 | 86 |
1945629 | 1945629 | 2021-11-23 | Columbia | Pennsylvania | 42037 | 8902 | 164 |
1945630 | 1945630 | 2021-11-23 | Crawford | Pennsylvania | 42039 | 12855 | 216 |
1945631 | 1945631 | 2021-11-23 | Cumberland | Pennsylvania | 42041 | 30775 | 648 |
1945632 | 1945632 | 2021-11-23 | Dauphin | Pennsylvania | 42043 | 37477 | 684 |
1945633 | 1945633 | 2021-11-23 | Delaware | Pennsylvania | 42045 | 65302 | 1523 |
1945634 | 1945634 | 2021-11-23 | Elk | Pennsylvania | 42047 | 4696 | 65 |
1945635 | 1945635 | 2021-11-23 | Erie | Pennsylvania | 42049 | 34500 | 534 |
1945636 | 1945636 | 2021-11-23 | Fayette | Pennsylvania | 42051 | 20011 | 451 |
1945637 | 1945637 | 2021-11-23 | Forest | Pennsylvania | 42053 | 1724 | 28 |
1945638 | 1945638 | 2021-11-23 | Franklin | Pennsylvania | 42055 | 23537 | 483 |
1945639 | 1945639 | 2021-11-23 | Fulton | Pennsylvania | 42057 | 2567 | 38 |
1945640 | 1945640 | 2021-11-23 | Greene | Pennsylvania | 42059 | 5515 | 65 |
1945641 | 1945641 | 2021-11-23 | Huntingdon | Pennsylvania | 42061 | 7435 | 175 |
1945642 | 1945642 | 2021-11-23 | Indiana | Pennsylvania | 42063 | 10437 | 258 |
1945643 | 1945643 | 2021-11-23 | Jefferson | Pennsylvania | 42065 | 5924 | 141 |
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);