ny_times_us_counties

Table actions
⚠️ 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

38,907 rows where state = "Pennsylvania" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Pennsylvania · 38,907 ✖
Link rowid date ▲ county state fips cases deaths
1844872 1844872 2021-10-23 Adams Pennsylvania 42001 13067 219
1844873 1844873 2021-10-23 Allegheny Pennsylvania 42003 129734 2303
1844874 1844874 2021-10-23 Armstrong Pennsylvania 42005 8645 196
1844875 1844875 2021-10-23 Beaver Pennsylvania 42007 21786 466
1844876 1844876 2021-10-23 Bedford Pennsylvania 42009 6688 169
1844877 1844877 2021-10-23 Berks Pennsylvania 42011 57860 1136
1844878 1844878 2021-10-23 Blair Pennsylvania 42013 17031 379
1844879 1844879 2021-10-23 Bradford Pennsylvania 42015 7577 121
1844880 1844880 2021-10-23 Bucks Pennsylvania 42017 72642 1419
1844881 1844881 2021-10-23 Butler Pennsylvania 42019 24698 495
1844882 1844882 2021-10-23 Cambria Pennsylvania 42021 19076 500
1844883 1844883 2021-10-23 Cameron Pennsylvania 42023 490 11
1844884 1844884 2021-10-23 Carbon Pennsylvania 42025 8750 200
1844885 1844885 2021-10-23 Centre Pennsylvania 42027 20378 242
1844886 1844886 2021-10-23 Chester Pennsylvania 42029 50330 871
1844887 1844887 2021-10-23 Clarion Pennsylvania 42031 4711 121
1844888 1844888 2021-10-23 Clearfield Pennsylvania 42033 11021 191
1844889 1844889 2021-10-23 Clinton Pennsylvania 42035 4839 73
1844890 1844890 2021-10-23 Columbia Pennsylvania 42037 7733 151
1844891 1844891 2021-10-23 Crawford Pennsylvania 42039 10736 187
1844892 1844892 2021-10-23 Cumberland Pennsylvania 42041 27803 610
1844893 1844893 2021-10-23 Dauphin Pennsylvania 42043 34320 636
1844894 1844894 2021-10-23 Delaware Pennsylvania 42045 61635 1495
1844895 1844895 2021-10-23 Elk Pennsylvania 42047 4049 56
1844896 1844896 2021-10-23 Erie Pennsylvania 42049 28683 481
1844897 1844897 2021-10-23 Fayette Pennsylvania 42051 17485 396
1844898 1844898 2021-10-23 Forest Pennsylvania 42053 1579 24
1844899 1844899 2021-10-23 Franklin Pennsylvania 42055 21477 450
1844900 1844900 2021-10-23 Fulton Pennsylvania 42057 2194 28
1844901 1844901 2021-10-23 Greene Pennsylvania 42059 4766 53
1844902 1844902 2021-10-23 Huntingdon Pennsylvania 42061 6742 156
1844903 1844903 2021-10-23 Indiana Pennsylvania 42063 8808 223
1844904 1844904 2021-10-23 Jefferson Pennsylvania 42065 4857 118
1844905 1844905 2021-10-23 Juniata Pennsylvania 42067 2843 115
1844906 1844906 2021-10-23 Lackawanna Pennsylvania 42069 22512 515
1844907 1844907 2021-10-23 Lancaster Pennsylvania 42071 70505 1302
1844908 1844908 2021-10-23 Lawrence Pennsylvania 42073 10632 261
1844909 1844909 2021-10-23 Lebanon Pennsylvania 42075 20339 327
1844910 1844910 2021-10-23 Lehigh Pennsylvania 42077 48060 933
1844911 1844911 2021-10-23 Luzerne Pennsylvania 42079 40346 916
1844912 1844912 2021-10-23 Lycoming Pennsylvania 42081 16035 352
1844913 1844913 2021-10-23 McKean Pennsylvania 42083 5042 86
1844914 1844914 2021-10-23 Mercer Pennsylvania 42085 13444 322
1844915 1844915 2021-10-23 Mifflin Pennsylvania 42087 7128 192
1844916 1844916 2021-10-23 Monroe Pennsylvania 42089 19430 360
1844917 1844917 2021-10-23 Montgomery Pennsylvania 42091 84851 1840
1844918 1844918 2021-10-23 Montour Pennsylvania 42093 2488 71
1844919 1844919 2021-10-23 Northampton Pennsylvania 42095 44138 790
1844920 1844920 2021-10-23 Northumberland Pennsylvania 42097 12516 399
1844921 1844921 2021-10-23 Perry Pennsylvania 42099 5219 119
1844922 1844922 2021-10-23 Philadelphia Pennsylvania 42101 180910 3995
1844923 1844923 2021-10-23 Pike Pennsylvania 42103 5328 61
1844924 1844924 2021-10-23 Potter Pennsylvania 42105 1849 44
1844925 1844925 2021-10-23 Schuylkill Pennsylvania 42107 18849 468
1844926 1844926 2021-10-23 Snyder Pennsylvania 42109 4670 102
1844927 1844927 2021-10-23 Somerset Pennsylvania 42111 10428 248
1844928 1844928 2021-10-23 Sullivan Pennsylvania 42113 581 24
1844929 1844929 2021-10-23 Susquehanna Pennsylvania 42115 3602 66
1844930 1844930 2021-10-23 Tioga Pennsylvania 42117 4438 129
1844931 1844931 2021-10-23 Union Pennsylvania 42119 7339 98
1844932 1844932 2021-10-23 Venango Pennsylvania 42121 6214 132
1844933 1844933 2021-10-23 Warren Pennsylvania 42123 3916 123
1844934 1844934 2021-10-23 Washington Pennsylvania 42125 25165 386
1844935 1844935 2021-10-23 Wayne Pennsylvania 42127 5615 106
1844936 1844936 2021-10-23 Westmoreland Pennsylvania 42129 44251 889
1844937 1844937 2021-10-23 Wyoming Pennsylvania 42131 2716 63
1844938 1844938 2021-10-23 York Pennsylvania 42133 61293 954
1841622 1841622 2021-10-22 Adams Pennsylvania 42001 13026 218
1841623 1841623 2021-10-22 Allegheny Pennsylvania 42003 129285 2298
1841624 1841624 2021-10-22 Armstrong Pennsylvania 42005 8612 196
1841625 1841625 2021-10-22 Beaver Pennsylvania 42007 21688 464
1841626 1841626 2021-10-22 Bedford Pennsylvania 42009 6662 167
1841627 1841627 2021-10-22 Berks Pennsylvania 42011 57717 1136
1841628 1841628 2021-10-22 Blair Pennsylvania 42013 16945 378
1841629 1841629 2021-10-22 Bradford Pennsylvania 42015 7554 119
1841630 1841630 2021-10-22 Bucks Pennsylvania 42017 72496 1416
1841631 1841631 2021-10-22 Butler Pennsylvania 42019 24606 494
1841632 1841632 2021-10-22 Cambria Pennsylvania 42021 19001 494
1841633 1841633 2021-10-22 Cameron Pennsylvania 42023 487 11
1841634 1841634 2021-10-22 Carbon Pennsylvania 42025 8725 200
1841635 1841635 2021-10-22 Centre Pennsylvania 42027 20328 242
1841636 1841636 2021-10-22 Chester Pennsylvania 42029 50251 871
1841637 1841637 2021-10-22 Clarion Pennsylvania 42031 4646 121
1841638 1841638 2021-10-22 Clearfield Pennsylvania 42033 10990 191
1841639 1841639 2021-10-22 Clinton Pennsylvania 42035 4809 73
1841640 1841640 2021-10-22 Columbia Pennsylvania 42037 7689 151
1841641 1841641 2021-10-22 Crawford Pennsylvania 42039 10677 186
1841642 1841642 2021-10-22 Cumberland Pennsylvania 42041 27699 608
1841643 1841643 2021-10-22 Dauphin Pennsylvania 42043 34227 634
1841644 1841644 2021-10-22 Delaware Pennsylvania 42045 61501 1494
1841645 1841645 2021-10-22 Elk Pennsylvania 42047 4028 56
1841646 1841646 2021-10-22 Erie Pennsylvania 42049 28577 481
1841647 1841647 2021-10-22 Fayette Pennsylvania 42051 17410 396
1841648 1841648 2021-10-22 Forest Pennsylvania 42053 1577 24
1841649 1841649 2021-10-22 Franklin Pennsylvania 42055 21442 450
1841650 1841650 2021-10-22 Fulton Pennsylvania 42057 2189 28
1841651 1841651 2021-10-22 Greene Pennsylvania 42059 4753 53
1841652 1841652 2021-10-22 Huntingdon Pennsylvania 42061 6731 155
1841653 1841653 2021-10-22 Indiana Pennsylvania 42063 8757 222
1841654 1841654 2021-10-22 Jefferson Pennsylvania 42065 4813 115

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
);
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);