johns_hopkins_csse_daily_reports

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 source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

39,474 rows where province_or_state = "Pennsylvania" sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

province_or_state

  • Pennsylvania · 39,474 ✖

country_or_region

  • US 39,474
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
34927 34927 2021-10-23 US Pennsylvania Adams 42001 13067 219 0   39.87140411 -77.21610347 2021-10-24 04:21:22 Adams, Pennsylvania, US
34928 34928 2021-10-23 US Pennsylvania Allegheny 42003 129734 2303 0   40.46809875 -79.98167747 2021-10-24 04:21:22 Allegheny, Pennsylvania, US
34929 34929 2021-10-23 US Pennsylvania Armstrong 42005 8645 196 0   40.81665618 -79.46290811 2021-10-24 04:21:22 Armstrong, Pennsylvania, US
34930 34930 2021-10-23 US Pennsylvania Beaver 42007 21786 466 0   40.6825484 -80.34921611 2021-10-24 04:21:22 Beaver, Pennsylvania, US
34931 34931 2021-10-23 US Pennsylvania Bedford 42009 6688 169 0   40.00522157 -78.48998442 2021-10-24 04:21:22 Bedford, Pennsylvania, US
34932 34932 2021-10-23 US Pennsylvania Berks 42011 57860 1136 0   40.41570541 -75.92457766 2021-10-24 04:21:22 Berks, Pennsylvania, US
34933 34933 2021-10-23 US Pennsylvania Blair 42013 17031 379 0   40.47961444 -78.34917412 2021-10-24 04:21:22 Blair, Pennsylvania, US
34934 34934 2021-10-23 US Pennsylvania Bradford 42015 7577 121 0   41.78869215 -76.51570822 2021-10-24 04:21:22 Bradford, Pennsylvania, US
34935 34935 2021-10-23 US Pennsylvania Bucks 42017 72642 1419 0   40.33682119 -75.10836643 2021-10-24 04:21:22 Bucks, Pennsylvania, US
34936 34936 2021-10-23 US Pennsylvania Butler 42019 24698 495 0   40.91152759 -79.91351055 2021-10-24 04:21:22 Butler, Pennsylvania, US
34937 34937 2021-10-23 US Pennsylvania Cambria 42021 19076 500 0   40.49527404 -78.71377428 2021-10-24 04:21:22 Cambria, Pennsylvania, US
34938 34938 2021-10-23 US Pennsylvania Cameron 42023 490 11 0   41.43625568 -78.20376845 2021-10-24 04:21:22 Cameron, Pennsylvania, US
34939 34939 2021-10-23 US Pennsylvania Carbon 42025 8750 200 0   40.91545395 -75.7068525 2021-10-24 04:21:22 Carbon, Pennsylvania, US
34940 34940 2021-10-23 US Pennsylvania Centre 42027 20378 242 0   40.92058903 -77.82200624 2021-10-24 04:21:22 Centre, Pennsylvania, US
34941 34941 2021-10-23 US Pennsylvania Chester 42029 50251 871 0   39.97291773 -75.74768357 2021-10-24 04:21:22 Chester, Pennsylvania, US
34942 34942 2021-10-23 US Pennsylvania Clarion 42031 4711 121 0   41.19265812 -79.42413524 2021-10-24 04:21:22 Clarion, Pennsylvania, US
34943 34943 2021-10-23 US Pennsylvania Clearfield 42033 11021 191 0   41.00110782 -78.47592663 2021-10-24 04:21:22 Clearfield, Pennsylvania, US
34944 34944 2021-10-23 US Pennsylvania Clinton 42035 4839 73 0   41.23255967 -77.63785995 2021-10-24 04:21:22 Clinton, Pennsylvania, US
34945 34945 2021-10-23 US Pennsylvania Columbia 42037 7733 151 0   41.04821986 -76.40565017 2021-10-24 04:21:22 Columbia, Pennsylvania, US
34946 34946 2021-10-23 US Pennsylvania Crawford 42039 10736 187 0   41.68447709 -80.10760592 2021-10-24 04:21:22 Crawford, Pennsylvania, US
34947 34947 2021-10-23 US Pennsylvania Cumberland 42041 27803 610 0   40.1625372 -77.26130755 2021-10-24 04:21:22 Cumberland, Pennsylvania, US
34948 34948 2021-10-23 US Pennsylvania Dauphin 42043 34320 636 0   40.41377078 -76.77993242 2021-10-24 04:21:22 Dauphin, Pennsylvania, US
34949 34949 2021-10-23 US Pennsylvania Delaware 42045 61635 1495 0   39.91680171 -75.40243663 2021-10-24 04:21:22 Delaware, Pennsylvania, US
34950 34950 2021-10-23 US Pennsylvania Elk 42047 4049 56 0   41.42822061 -78.64524744 2021-10-24 04:21:22 Elk, Pennsylvania, US
34951 34951 2021-10-23 US Pennsylvania Erie 42049 28683 481 0   41.99253829 -80.03301954 2021-10-24 04:21:22 Erie, Pennsylvania, US
34952 34952 2021-10-23 US Pennsylvania Fayette 42051 17485 396 0   39.92041012 -79.64291195 2021-10-24 04:21:22 Fayette, Pennsylvania, US
34953 34953 2021-10-23 US Pennsylvania Forest 42053 1579 24 0   41.51095103 -79.23229292 2021-10-24 04:21:22 Forest, Pennsylvania, US
34954 34954 2021-10-23 US Pennsylvania Franklin 42055 21477 450 0   39.92956518 -77.72157791 2021-10-24 04:21:22 Franklin, Pennsylvania, US
34955 34955 2021-10-23 US Pennsylvania Fulton 42057 2194 28 0   39.92913544 -78.11163677 2021-10-24 04:21:22 Fulton, Pennsylvania, US
34956 34956 2021-10-23 US Pennsylvania Greene 42059 4766 53 0   39.85746531 -80.22357106 2021-10-24 04:21:22 Greene, Pennsylvania, US
34957 34957 2021-10-23 US Pennsylvania Huntingdon 42061 6742 156 0   40.42162652 -77.97673273 2021-10-24 04:21:22 Huntingdon, Pennsylvania, US
34958 34958 2021-10-23 US Pennsylvania Indiana 42063 8808 223 0   40.65241041 -79.08963285 2021-10-24 04:21:22 Indiana, Pennsylvania, US
34959 34959 2021-10-23 US Pennsylvania Jefferson 42065 4857 118 0   41.12913106 -78.9986361 2021-10-24 04:21:22 Jefferson, Pennsylvania, US
34960 34960 2021-10-23 US Pennsylvania Juniata 42067 2843 115 0   40.53358749 -77.39975129999998 2021-10-24 04:21:22 Juniata, Pennsylvania, US
34961 34961 2021-10-23 US Pennsylvania Lackawanna 42069 22512 515 0   41.43564672 -75.60379201 2021-10-24 04:21:22 Lackawanna, Pennsylvania, US
34962 34962 2021-10-23 US Pennsylvania Lancaster 42071 70505 1302 0   40.03904563 -76.24770128 2021-10-24 04:21:22 Lancaster, Pennsylvania, US
34963 34963 2021-10-23 US Pennsylvania Lawrence 42073 10632 261 0   40.99206278 -80.33393706 2021-10-24 04:21:22 Lawrence, Pennsylvania, US
34964 34964 2021-10-23 US Pennsylvania Lebanon 42075 20339 327 0   40.36680311 -76.45651841 2021-10-24 04:21:22 Lebanon, Pennsylvania, US
34965 34965 2021-10-23 US Pennsylvania Lehigh 42077 48060 933 0   40.6154815 -75.59435245 2021-10-24 04:21:22 Lehigh, Pennsylvania, US
34966 34966 2021-10-23 US Pennsylvania Luzerne 42079 40346 916 0   41.17823008 -75.98447579 2021-10-24 04:21:22 Luzerne, Pennsylvania, US
34967 34967 2021-10-23 US Pennsylvania Lycoming 42081 16035 352 0   41.34310539 -77.06629984 2021-10-24 04:21:22 Lycoming, Pennsylvania, US
34968 34968 2021-10-23 US Pennsylvania McKean 42083 5042 86 0   41.80938602 -78.56478358 2021-10-24 04:21:22 McKean, Pennsylvania, US
34969 34969 2021-10-23 US Pennsylvania Mercer 42085 13444 322 0   41.30248872 -80.25816981 2021-10-24 04:21:22 Mercer, Pennsylvania, US
34970 34970 2021-10-23 US Pennsylvania Mifflin 42087 7128 192 0   40.61116939 -77.61070738 2021-10-24 04:21:22 Mifflin, Pennsylvania, US
34971 34971 2021-10-23 US Pennsylvania Monroe 42089 19430 360 0   41.05934058 -75.34031025 2021-10-24 04:21:22 Monroe, Pennsylvania, US
34972 34972 2021-10-23 US Pennsylvania Montgomery 42091 84851 1840 0   40.21053671 -75.36652296 2021-10-24 04:21:22 Montgomery, Pennsylvania, US
34973 34973 2021-10-23 US Pennsylvania Montour 42093 2488 71 0   41.03023987 -76.66345939 2021-10-24 04:21:22 Montour, Pennsylvania, US
34974 34974 2021-10-23 US Pennsylvania Northampton 42095 44138 790 0   40.75182733 -75.30471829 2021-10-24 04:21:22 Northampton, Pennsylvania, US
34975 34975 2021-10-23 US Pennsylvania Northumberland 42097 12516 399 0   40.84785433 -76.70798222 2021-10-24 04:21:22 Northumberland, Pennsylvania, US
34976 34976 2021-10-23 US Pennsylvania Perry 42099 5219 119 0   40.40206612 -77.26297447 2021-10-24 04:21:22 Perry, Pennsylvania, US
34977 34977 2021-10-23 US Pennsylvania Philadelphia 42101 180602 3993 0   40.00338507 -75.1379271 2021-10-24 04:21:22 Philadelphia, Pennsylvania, US
34978 34978 2021-10-23 US Pennsylvania Pike 42103 5328 61 0   41.33155042 -75.03208106 2021-10-24 04:21:22 Pike, Pennsylvania, US
34979 34979 2021-10-23 US Pennsylvania Potter 42105 1849 44 0   41.74471626 -77.89559864 2021-10-24 04:21:22 Potter, Pennsylvania, US
34980 34980 2021-10-23 US Pennsylvania Schuylkill 42107 18849 468 0   40.70497338 -76.2150785 2021-10-24 04:21:22 Schuylkill, Pennsylvania, US
34981 34981 2021-10-23 US Pennsylvania Snyder 42109 4670 102 0   40.77129231 -77.06840691 2021-10-24 04:21:22 Snyder, Pennsylvania, US
34982 34982 2021-10-23 US Pennsylvania Somerset 42111 10428 248 0   39.97172723 -79.02699593 2021-10-24 04:21:22 Somerset, Pennsylvania, US
34983 34983 2021-10-23 US Pennsylvania Sullivan 42113 581 24 0   41.44634738 -76.51246591 2021-10-24 04:21:22 Sullivan, Pennsylvania, US
34984 34984 2021-10-23 US Pennsylvania Susquehanna 42115 3602 66 0   41.82147784 -75.80071959 2021-10-24 04:21:22 Susquehanna, Pennsylvania, US
34985 34985 2021-10-23 US Pennsylvania Tioga 42117 4438 129 0   41.77255149 -77.25433032 2021-10-24 04:21:22 Tioga, Pennsylvania, US
34986 34986 2021-10-23 US Pennsylvania Unassigned 90042 0 0 0   41.99253829 -80.34921611 2021-10-24 04:21:22 Unassigned, Pennsylvania, US
34987 34987 2021-10-23 US Pennsylvania Union 42119 7339 98 0   40.96188846 -77.05996014 2021-10-24 04:21:22 Union, Pennsylvania, US
34988 34988 2021-10-23 US Pennsylvania Venango 42121 6214 132 0   41.40323442 -79.75845449 2021-10-24 04:21:22 Venango, Pennsylvania, US
34989 34989 2021-10-23 US Pennsylvania Warren 42123 3916 123 0   41.81304978 -79.26969577 2021-10-24 04:21:22 Warren, Pennsylvania, US
34990 34990 2021-10-23 US Pennsylvania Washington 42125 25165 386 0   40.19208869 -80.24582867 2021-10-24 04:21:22 Washington, Pennsylvania, US
34991 34991 2021-10-23 US Pennsylvania Wayne 42127 5615 106 0   41.64938475 -75.29956506 2021-10-24 04:21:22 Wayne, Pennsylvania, US
34992 34992 2021-10-23 US Pennsylvania Westmoreland 42129 44251 889 0   40.31377979999999 -79.46615476 2021-10-24 04:21:22 Westmoreland, Pennsylvania, US
34993 34993 2021-10-23 US Pennsylvania Wyoming 42131 2716 63 0   41.51955538 -76.01074915 2021-10-24 04:21:22 Wyoming, Pennsylvania, US
34994 34994 2021-10-23 US Pennsylvania York 42133 61293 954 0   39.9210089 -76.73040131 2021-10-24 04:21:22 York, Pennsylvania, US
315411 315411 2021-10-22 US Pennsylvania Adams 42001 13026 218 0   39.87140411 -77.21610347 2021-10-23 04:21:32 Adams, Pennsylvania, US
315412 315412 2021-10-22 US Pennsylvania Allegheny 42003 129285 2298 0   40.46809875 -79.98167747 2021-10-23 04:21:32 Allegheny, Pennsylvania, US
315413 315413 2021-10-22 US Pennsylvania Armstrong 42005 8612 196 0   40.81665618 -79.46290811 2021-10-23 04:21:32 Armstrong, Pennsylvania, US
315414 315414 2021-10-22 US Pennsylvania Beaver 42007 21688 464 0   40.6825484 -80.34921611 2021-10-23 04:21:32 Beaver, Pennsylvania, US
315415 315415 2021-10-22 US Pennsylvania Bedford 42009 6662 167 0   40.00522157 -78.48998442 2021-10-23 04:21:32 Bedford, Pennsylvania, US
315416 315416 2021-10-22 US Pennsylvania Berks 42011 57717 1136 0   40.41570541 -75.92457766 2021-10-23 04:21:32 Berks, Pennsylvania, US
315417 315417 2021-10-22 US Pennsylvania Blair 42013 16945 378 0   40.47961444 -78.34917412 2021-10-23 04:21:32 Blair, Pennsylvania, US
315418 315418 2021-10-22 US Pennsylvania Bradford 42015 7554 119 0   41.78869215 -76.51570822 2021-10-23 04:21:32 Bradford, Pennsylvania, US
315419 315419 2021-10-22 US Pennsylvania Bucks 42017 72496 1416 0   40.33682119 -75.10836643 2021-10-23 04:21:32 Bucks, Pennsylvania, US
315420 315420 2021-10-22 US Pennsylvania Butler 42019 24606 494 0   40.91152759 -79.91351055 2021-10-23 04:21:32 Butler, Pennsylvania, US
315421 315421 2021-10-22 US Pennsylvania Cambria 42021 19001 494 0   40.49527404 -78.71377428 2021-10-23 04:21:32 Cambria, Pennsylvania, US
315422 315422 2021-10-22 US Pennsylvania Cameron 42023 487 11 0   41.43625568 -78.20376845 2021-10-23 04:21:32 Cameron, Pennsylvania, US
315423 315423 2021-10-22 US Pennsylvania Carbon 42025 8725 200 0   40.91545395 -75.7068525 2021-10-23 04:21:32 Carbon, Pennsylvania, US
315424 315424 2021-10-22 US Pennsylvania Centre 42027 20328 242 0   40.92058903 -77.82200624 2021-10-23 04:21:32 Centre, Pennsylvania, US
315425 315425 2021-10-22 US Pennsylvania Chester 42029 50251 871 0   39.97291773 -75.74768357 2021-10-23 04:21:32 Chester, Pennsylvania, US
315426 315426 2021-10-22 US Pennsylvania Clarion 42031 4646 121 0   41.19265812 -79.42413524 2021-10-23 04:21:32 Clarion, Pennsylvania, US
315427 315427 2021-10-22 US Pennsylvania Clearfield 42033 10990 191 0   41.00110782 -78.47592663 2021-10-23 04:21:32 Clearfield, Pennsylvania, US
315428 315428 2021-10-22 US Pennsylvania Clinton 42035 4809 73 0   41.23255967 -77.63785995 2021-10-23 04:21:32 Clinton, Pennsylvania, US
315429 315429 2021-10-22 US Pennsylvania Columbia 42037 7689 151 0   41.04821986 -76.40565017 2021-10-23 04:21:32 Columbia, Pennsylvania, US
315430 315430 2021-10-22 US Pennsylvania Crawford 42039 10677 186 0   41.68447709 -80.10760592 2021-10-23 04:21:32 Crawford, Pennsylvania, US
315431 315431 2021-10-22 US Pennsylvania Cumberland 42041 27699 608 0   40.1625372 -77.26130755 2021-10-23 04:21:32 Cumberland, Pennsylvania, US
315432 315432 2021-10-22 US Pennsylvania Dauphin 42043 34227 634 0   40.41377078 -76.77993242 2021-10-23 04:21:32 Dauphin, Pennsylvania, US
315433 315433 2021-10-22 US Pennsylvania Delaware 42045 61501 1494 0   39.91680171 -75.40243663 2021-10-23 04:21:32 Delaware, Pennsylvania, US
315434 315434 2021-10-22 US Pennsylvania Elk 42047 4028 56 0   41.42822061 -78.64524744 2021-10-23 04:21:32 Elk, Pennsylvania, US
315435 315435 2021-10-22 US Pennsylvania Erie 42049 28577 481 0   41.99253829 -80.03301954 2021-10-23 04:21:32 Erie, Pennsylvania, US
315436 315436 2021-10-22 US Pennsylvania Fayette 42051 17410 396 0   39.92041012 -79.64291195 2021-10-23 04:21:32 Fayette, Pennsylvania, US
315437 315437 2021-10-22 US Pennsylvania Forest 42053 1577 24 0   41.51095103 -79.23229292 2021-10-23 04:21:32 Forest, Pennsylvania, US
315438 315438 2021-10-22 US Pennsylvania Franklin 42055 21442 450 0   39.92956518 -77.72157791 2021-10-23 04:21:32 Franklin, Pennsylvania, US
315439 315439 2021-10-22 US Pennsylvania Fulton 42057 2189 28 0   39.92913544 -78.11163677 2021-10-23 04:21:32 Fulton, Pennsylvania, US
315440 315440 2021-10-22 US Pennsylvania Greene 42059 4753 53 0   39.85746531 -80.22357106 2021-10-23 04:21:32 Greene, Pennsylvania, US
315441 315441 2021-10-22 US Pennsylvania Huntingdon 42061 6731 155 0   40.42162652 -77.97673273 2021-10-23 04:21:32 Huntingdon, Pennsylvania, US
315442 315442 2021-10-22 US Pennsylvania Indiana 42063 8757 222 0   40.65241041 -79.08963285 2021-10-23 04:21:32 Indiana, Pennsylvania, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);