johns_hopkins_csse_daily_reports

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

9,758 rows where province_or_state = "Pennsylvania" sorted by day descending

View and edit SQL

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

province_or_state

  • Pennsylvania · 9,758

country_or_region

  • US 9,758
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
136673 2020-08-12 US Pennsylvania Adams 42001 535 20 0 515 39.87140411 -77.21610347 2020-08-13 04:29:15 Adams, Pennsylvania, US
136674 2020-08-12 US Pennsylvania Allegheny 42003 9078 259 0 8819 40.46809875 -79.98167747 2020-08-13 04:29:15 Allegheny, Pennsylvania, US
136675 2020-08-12 US Pennsylvania Armstrong 42005 230 8 0 222 40.81665618 -79.46290811 2020-08-13 04:29:15 Armstrong, Pennsylvania, US
136676 2020-08-12 US Pennsylvania Beaver 42007 1351 93 0 1258 40.6825484 -80.34921611 2020-08-13 04:29:15 Beaver, Pennsylvania, US
136677 2020-08-12 US Pennsylvania Bedford 42009 145 4 0 141 40.00522157 -78.48998442 2020-08-13 04:29:15 Bedford, Pennsylvania, US
136678 2020-08-12 US Pennsylvania Berks 42011 5470 372 0 5098 40.41570541 -75.92457766 2020-08-13 04:29:15 Berks, Pennsylvania, US
136679 2020-08-12 US Pennsylvania Blair 42013 302 7 0 295 40.47961444 -78.34917412 2020-08-13 04:29:15 Blair, Pennsylvania, US
136680 2020-08-12 US Pennsylvania Bradford 42015 90 3 0 87 41.78869215 -76.51570822 2020-08-13 04:29:15 Bradford, Pennsylvania, US
136681 2020-08-12 US Pennsylvania Bucks 42017 7275 582 0 6693 40.33682119 -75.10836643 2020-08-13 04:29:15 Bucks, Pennsylvania, US
136682 2020-08-12 US Pennsylvania Butler 42019 695 16 0 679 40.91152759 -79.91351055 2020-08-13 04:29:15 Butler, Pennsylvania, US
136683 2020-08-12 US Pennsylvania Cambria 42021 351 3 0 348 40.49527404 -78.71377428 2020-08-13 04:29:15 Cambria, Pennsylvania, US
136684 2020-08-12 US Pennsylvania Cameron 42023 7 0 0 7 41.43625568 -78.20376845 2020-08-13 04:29:15 Cameron, Pennsylvania, US
136685 2020-08-12 US Pennsylvania Carbon 42025 377 28 0 349 40.91545395 -75.7068525 2020-08-13 04:29:15 Carbon, Pennsylvania, US
136686 2020-08-12 US Pennsylvania Centre 42027 377 10 0 367 40.92058903 -77.82200624 2020-08-13 04:29:15 Centre, Pennsylvania, US
136687 2020-08-12 US Pennsylvania Chester 42029 5234 350 0 4884 39.97291773 -75.74768357 2020-08-13 04:29:15 Chester, Pennsylvania, US
136688 2020-08-12 US Pennsylvania Clarion 42031 83 2 0 81 41.19265812 -79.42413524 2020-08-13 04:29:15 Clarion, Pennsylvania, US
136689 2020-08-12 US Pennsylvania Clearfield 42033 177 1 0 176 41.00110782 -78.47592663 2020-08-13 04:29:15 Clearfield, Pennsylvania, US
136690 2020-08-12 US Pennsylvania Clinton 42035 124 5 0 119 41.23255967 -77.63785995 2020-08-13 04:29:15 Clinton, Pennsylvania, US
136691 2020-08-12 US Pennsylvania Columbia 42037 481 35 0 446 41.04821986 -76.40565017 2020-08-13 04:29:15 Columbia, Pennsylvania, US
136692 2020-08-12 US Pennsylvania Crawford 42039 162 1 0 161 41.68447709 -80.10760592 2020-08-13 04:29:15 Crawford, Pennsylvania, US
136693 2020-08-12 US Pennsylvania Cumberland 42041 1327 71 0 1256 40.1625372 -77.26130755 2020-08-13 04:29:15 Cumberland, Pennsylvania, US
136694 2020-08-12 US Pennsylvania Dauphin 42043 2873 159 0 2714 40.41377078 -76.77993242 2020-08-13 04:29:15 Dauphin, Pennsylvania, US
136695 2020-08-12 US Pennsylvania Delaware 42045 9436 706 0 8730 39.91680171 -75.40243663 2020-08-13 04:29:15 Delaware, Pennsylvania, US
136696 2020-08-12 US Pennsylvania Elk 42047 54 2 0 52 41.42822061 -78.64524744 2020-08-13 04:29:15 Elk, Pennsylvania, US
136697 2020-08-12 US Pennsylvania Erie 42049 1143 22 0 1121 41.99253829 -80.03301954 2020-08-13 04:29:15 Erie, Pennsylvania, US
136698 2020-08-12 US Pennsylvania Fayette 42051 582 6 0 576 39.92041012 -79.64291195 2020-08-13 04:29:15 Fayette, Pennsylvania, US
136699 2020-08-12 US Pennsylvania Forest 42053 10 0 0 10 41.51095103 -79.23229292 2020-08-13 04:29:15 Forest, Pennsylvania, US
136700 2020-08-12 US Pennsylvania Franklin 42055 1385 46 0 1339 39.92956518 -77.72157791 2020-08-13 04:29:15 Franklin, Pennsylvania, US
136701 2020-08-12 US Pennsylvania Fulton 42057 27 2 0 25 39.92913544 -78.11163677 2020-08-13 04:29:15 Fulton, Pennsylvania, US
136702 2020-08-12 US Pennsylvania Greene 42059 118 1 0 117 39.85746531 -80.22357106 2020-08-13 04:29:15 Greene, Pennsylvania, US
136703 2020-08-12 US Pennsylvania Huntingdon 42061 309 4 0 305 40.42162652 -77.97673273 2020-08-13 04:29:15 Huntingdon, Pennsylvania, US
136704 2020-08-12 US Pennsylvania Indiana 42063 335 7 0 328 40.65241041 -79.08963285 2020-08-13 04:29:15 Indiana, Pennsylvania, US
136705 2020-08-12 US Pennsylvania Jefferson 42065 74 1 0 73 41.12913106 -78.9986361 2020-08-13 04:29:15 Jefferson, Pennsylvania, US
136706 2020-08-12 US Pennsylvania Juniata 42067 135 6 0 129 40.53358749 -77.39975129999998 2020-08-13 04:29:15 Juniata, Pennsylvania, US
136707 2020-08-12 US Pennsylvania Lackawanna 42069 1946 212 0 1734 41.43564672 -75.60379201 2020-08-13 04:29:15 Lackawanna, Pennsylvania, US
136708 2020-08-12 US Pennsylvania Lancaster 42071 6028 417 0 5611 40.03904563 -76.24770128 2020-08-13 04:29:15 Lancaster, Pennsylvania, US
136709 2020-08-12 US Pennsylvania Lawrence 42073 401 16 0 385 40.99206278 -80.33393706 2020-08-13 04:29:15 Lawrence, Pennsylvania, US
136710 2020-08-12 US Pennsylvania Lebanon 42075 1626 55 0 1571 40.36680311 -76.45651841 2020-08-13 04:29:15 Lebanon, Pennsylvania, US
136711 2020-08-12 US Pennsylvania Lehigh 42077 5022 338 0 4684 40.6154815 -75.59435245 2020-08-13 04:29:15 Lehigh, Pennsylvania, US
136712 2020-08-12 US Pennsylvania Luzerne 42079 3526 184 0 3342 41.17823008 -75.98447579 2020-08-13 04:29:15 Luzerne, Pennsylvania, US
136713 2020-08-12 US Pennsylvania Lycoming 42081 411 20 0 391 41.34310539 -77.06629984 2020-08-13 04:29:15 Lycoming, Pennsylvania, US
136714 2020-08-12 US Pennsylvania McKean 42083 34 1 0 33 41.80938602 -78.56478358 2020-08-13 04:29:15 McKean, Pennsylvania, US
136715 2020-08-12 US Pennsylvania Mercer 42085 456 11 0 445 41.30248872 -80.25816981 2020-08-13 04:29:15 Mercer, Pennsylvania, US
136716 2020-08-12 US Pennsylvania Mifflin 42087 121 1 0 120 40.61116939 -77.61070738 2020-08-13 04:29:15 Mifflin, Pennsylvania, US
136717 2020-08-12 US Pennsylvania Monroe 42089 1650 124 0 1526 41.05934058 -75.34031025 2020-08-13 04:29:15 Monroe, Pennsylvania, US
136718 2020-08-12 US Pennsylvania Montgomery 42091 10219 859 0 9360 40.21053671 -75.36652296 2020-08-13 04:29:15 Montgomery, Pennsylvania, US
136719 2020-08-12 US Pennsylvania Montour 42093 104 3 0 101 41.03023987 -76.66345939 2020-08-13 04:29:15 Montour, Pennsylvania, US
136720 2020-08-12 US Pennsylvania Northampton 42095 3956 293 0 3663 40.75182733 -75.30471829 2020-08-13 04:29:15 Northampton, Pennsylvania, US
136721 2020-08-12 US Pennsylvania Northumberland 42097 513 15 0 498 40.84785433 -76.70798222 2020-08-13 04:29:15 Northumberland, Pennsylvania, US
136722 2020-08-12 US Pennsylvania Perry 42099 125 5 0 120 40.40206612 -77.26297447 2020-08-13 04:29:15 Perry, Pennsylvania, US
136723 2020-08-12 US Pennsylvania Philadelphia 42101 31725 1709 0 30016 40.00338507 -75.1379271 2020-08-13 04:29:15 Philadelphia, Pennsylvania, US
136724 2020-08-12 US Pennsylvania Pike 42103 526 21 0 505 41.33155042 -75.03208106 2020-08-13 04:29:15 Pike, Pennsylvania, US
136725 2020-08-12 US Pennsylvania Potter 42105 20 0 0 20 41.74471626 -77.89559864 2020-08-13 04:29:15 Potter, Pennsylvania, US
136726 2020-08-12 US Pennsylvania Schuylkill 42107 928 51 0 877 40.70497338 -76.2150785 2020-08-13 04:29:15 Schuylkill, Pennsylvania, US
136727 2020-08-12 US Pennsylvania Snyder 42109 112 2 0 110 40.77129231 -77.06840691 2020-08-13 04:29:15 Snyder, Pennsylvania, US
136728 2020-08-12 US Pennsylvania Somerset 42111 138 3 0 135 39.97172723 -79.02699593 2020-08-13 04:29:15 Somerset, Pennsylvania, US
136729 2020-08-12 US Pennsylvania Sullivan 42113 10 0 0 10 41.44634738 -76.51246591 2020-08-13 04:29:15 Sullivan, Pennsylvania, US
136730 2020-08-12 US Pennsylvania Susquehanna 42115 217 27 0 190 41.82147784 -75.80071959 2020-08-13 04:29:15 Susquehanna, Pennsylvania, US
136731 2020-08-12 US Pennsylvania Tioga 42117 39 3 0 36 41.77255149 -77.25433032 2020-08-13 04:29:15 Tioga, Pennsylvania, US
136732 2020-08-12 US Pennsylvania Unassigned 90042 0 0 0 0 41.99253829 -80.34921611 2020-08-13 04:29:15 Unassigned, Pennsylvania, US
136733 2020-08-12 US Pennsylvania Union 42119 276 2 0 274 40.96188846 -77.05996014 2020-08-13 04:29:15 Union, Pennsylvania, US
136734 2020-08-12 US Pennsylvania Venango 42121 67 0 0 67 41.40323442 -79.75845449 2020-08-13 04:29:15 Venango, Pennsylvania, US
136735 2020-08-12 US Pennsylvania Warren 42123 23 1 0 22 41.81304978 -79.26969577 2020-08-13 04:29:15 Warren, Pennsylvania, US
136736 2020-08-12 US Pennsylvania Washington 42125 871 13 0 858 40.19208869 -80.24582867 2020-08-13 04:29:15 Washington, Pennsylvania, US
136737 2020-08-12 US Pennsylvania Wayne 42127 162 10 0 152 41.64938475 -75.29956506 2020-08-13 04:29:15 Wayne, Pennsylvania, US
136738 2020-08-12 US Pennsylvania Westmoreland 42129 1573 47 0 1526 40.31377979999999 -79.46615476 2020-08-13 04:29:15 Westmoreland, Pennsylvania, US
136739 2020-08-12 US Pennsylvania Wyoming 42131 61 8 0 53 41.51955538 -76.01074915 2020-08-13 04:29:15 Wyoming, Pennsylvania, US
136740 2020-08-12 US Pennsylvania York 42133 2680 97 0 2583 39.9210089 -76.73040131 2020-08-13 04:29:15 York, Pennsylvania, US
503043 2020-08-11 US Pennsylvania Adams 42001 531 20 0 511 39.87140411 -77.21610347 2020-08-12 04:27:29 Adams, Pennsylvania, US
503044 2020-08-11 US Pennsylvania Allegheny 42003 9008 254 0 8754 40.46809875 -79.98167747 2020-08-12 04:27:29 Allegheny, Pennsylvania, US
503045 2020-08-11 US Pennsylvania Armstrong 42005 222 8 0 214 40.81665618 -79.46290811 2020-08-12 04:27:29 Armstrong, Pennsylvania, US
503046 2020-08-11 US Pennsylvania Beaver 42007 1332 92 0 1240 40.6825484 -80.34921611 2020-08-12 04:27:29 Beaver, Pennsylvania, US
503047 2020-08-11 US Pennsylvania Bedford 42009 143 4 0 139 40.00522157 -78.48998442 2020-08-12 04:27:29 Bedford, Pennsylvania, US
503048 2020-08-11 US Pennsylvania Berks 42011 5431 369 0 5062 40.41570541 -75.92457766 2020-08-12 04:27:29 Berks, Pennsylvania, US
503049 2020-08-11 US Pennsylvania Blair 42013 298 6 0 292 40.47961444 -78.34917412 2020-08-12 04:27:29 Blair, Pennsylvania, US
503050 2020-08-11 US Pennsylvania Bradford 42015 90 3 0 87 41.78869215 -76.51570822 2020-08-12 04:27:29 Bradford, Pennsylvania, US
503051 2020-08-11 US Pennsylvania Bucks 42017 7231 582 0 6649 40.33682119 -75.10836643 2020-08-12 04:27:29 Bucks, Pennsylvania, US
503052 2020-08-11 US Pennsylvania Butler 42019 677 15 0 662 40.91152759 -79.91351055 2020-08-12 04:27:29 Butler, Pennsylvania, US
503053 2020-08-11 US Pennsylvania Cambria 42021 349 3 0 346 40.49527404 -78.71377428 2020-08-12 04:27:29 Cambria, Pennsylvania, US
503054 2020-08-11 US Pennsylvania Cameron 42023 7 0 0 7 41.43625568 -78.20376845 2020-08-12 04:27:29 Cameron, Pennsylvania, US
503055 2020-08-11 US Pennsylvania Carbon 42025 372 28 0 344 40.91545395 -75.7068525 2020-08-12 04:27:29 Carbon, Pennsylvania, US
503056 2020-08-11 US Pennsylvania Centre 42027 373 10 0 363 40.92058903 -77.82200624 2020-08-12 04:27:29 Centre, Pennsylvania, US
503057 2020-08-11 US Pennsylvania Chester 42029 5194 349 0 4845 39.97291773 -75.74768357 2020-08-12 04:27:29 Chester, Pennsylvania, US
503058 2020-08-11 US Pennsylvania Clarion 42031 81 2 0 79 41.19265812 -79.42413524 2020-08-12 04:27:29 Clarion, Pennsylvania, US
503059 2020-08-11 US Pennsylvania Clearfield 42033 174 1 0 173 41.00110782 -78.47592663 2020-08-12 04:27:29 Clearfield, Pennsylvania, US
503060 2020-08-11 US Pennsylvania Clinton 42035 123 5 0 118 41.23255967 -77.63785995 2020-08-12 04:27:29 Clinton, Pennsylvania, US
503061 2020-08-11 US Pennsylvania Columbia 42037 478 35 0 443 41.04821986 -76.40565017 2020-08-12 04:27:29 Columbia, Pennsylvania, US
503062 2020-08-11 US Pennsylvania Crawford 42039 158 1 0 157 41.68447709 -80.10760592 2020-08-12 04:27:29 Crawford, Pennsylvania, US
503063 2020-08-11 US Pennsylvania Cumberland 42041 1311 71 0 1240 40.1625372 -77.26130755 2020-08-12 04:27:29 Cumberland, Pennsylvania, US
503064 2020-08-11 US Pennsylvania Dauphin 42043 2850 159 0 2691 40.41377078 -76.77993242 2020-08-12 04:27:29 Dauphin, Pennsylvania, US
503065 2020-08-11 US Pennsylvania Delaware 42045 9347 701 0 8646 39.91680171 -75.40243663 2020-08-12 04:27:29 Delaware, Pennsylvania, US
503066 2020-08-11 US Pennsylvania Elk 42047 50 2 0 48 41.42822061 -78.64524744 2020-08-12 04:27:29 Elk, Pennsylvania, US
503067 2020-08-11 US Pennsylvania Erie 42049 1126 21 0 1105 41.99253829 -80.03301954 2020-08-12 04:27:29 Erie, Pennsylvania, US
503068 2020-08-11 US Pennsylvania Fayette 42051 562 6 0 556 39.92041012 -79.64291195 2020-08-12 04:27:29 Fayette, Pennsylvania, US
503069 2020-08-11 US Pennsylvania Forest 42053 10 0 0 10 41.51095103 -79.23229292 2020-08-12 04:27:29 Forest, Pennsylvania, US
503070 2020-08-11 US Pennsylvania Franklin 42055 1375 46 0 1329 39.92956518 -77.72157791 2020-08-12 04:27:29 Franklin, Pennsylvania, US
503071 2020-08-11 US Pennsylvania Fulton 42057 27 2 0 25 39.92913544 -78.11163677 2020-08-12 04:27:29 Fulton, Pennsylvania, US
503072 2020-08-11 US Pennsylvania Greene 42059 117 1 0 116 39.85746531 -80.22357106 2020-08-12 04:27:29 Greene, Pennsylvania, US
503073 2020-08-11 US Pennsylvania Huntingdon 42061 310 4 0 306 40.42162652 -77.97673273 2020-08-12 04:27:29 Huntingdon, Pennsylvania, US
503074 2020-08-11 US Pennsylvania Indiana 42063 326 7 0 319 40.65241041 -79.08963285 2020-08-12 04:27:29 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]);
Powered by Datasette · Query took 1933.354ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette