daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
65 rows where country_or_region = "US", deaths = 118 and province_or_state = "Pennsylvania" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-06 | US | Pennsylvania | Wyoming | 42131 | 6218 | 118 | 0 | 41.51955538 | -76.01074915 | 2022-12-07 04:20:58 | Wyoming, Pennsylvania, US | |
2022-12-05 | US | Pennsylvania | Wyoming | 42131 | 6218 | 118 | 0 | 41.51955538 | -76.01074915 | 2022-12-06 04:21:03 | Wyoming, Pennsylvania, US | |
2022-12-04 | US | Pennsylvania | Wyoming | 42131 | 6218 | 118 | 0 | 41.51955538 | -76.01074915 | 2022-12-05 04:20:58 | Wyoming, Pennsylvania, US | |
2022-12-03 | US | Pennsylvania | Wyoming | 42131 | 6218 | 118 | 0 | 41.51955538 | -76.01074915 | 2022-12-04 04:20:56 | Wyoming, Pennsylvania, US | |
2022-12-02 | US | Pennsylvania | Wyoming | 42131 | 6218 | 118 | 0 | 41.51955538 | -76.01074915 | 2022-12-03 04:21:02 | Wyoming, Pennsylvania, US | |
2022-12-01 | US | Pennsylvania | Wyoming | 42131 | 6218 | 118 | 0 | 41.51955538 | -76.01074915 | 2022-12-02 04:21:07 | Wyoming, Pennsylvania, US | |
2022-11-30 | US | Pennsylvania | Wyoming | 42131 | 6218 | 118 | 0 | 41.51955538 | -76.01074915 | 2022-12-01 04:21:03 | Wyoming, Pennsylvania, US | |
2022-01-10 | US | Pennsylvania | McKean | 42083 | 6662 | 118 | 0 | 41.80938602 | -78.56478358 | 2022-01-11 04:22:01 | McKean, Pennsylvania, US | |
2022-01-09 | US | Pennsylvania | McKean | 42083 | 6609 | 118 | 0 | 41.80938602 | -78.56478358 | 2022-01-10 04:22:07 | McKean, Pennsylvania, US | |
2022-01-08 | US | Pennsylvania | McKean | 42083 | 6569 | 118 | 0 | 41.80938602 | -78.56478358 | 2022-01-09 04:21:46 | McKean, Pennsylvania, US | |
2022-01-07 | US | Pennsylvania | McKean | 42083 | 6498 | 118 | 0 | 41.80938602 | -78.56478358 | 2022-01-08 04:21:53 | McKean, Pennsylvania, US | |
2022-01-06 | US | Pennsylvania | McKean | 42083 | 6470 | 118 | 0 | 41.80938602 | -78.56478358 | 2022-01-07 04:22:09 | McKean, Pennsylvania, US | |
2021-12-15 | US | Pennsylvania | Snyder | 42109 | 5807 | 118 | 0 | 40.77129231 | -77.06840691 | 2021-12-16 04:22:11 | Snyder, Pennsylvania, US | |
2021-11-14 | US | Pennsylvania | Wayne | 42127 | 6087 | 118 | 0 | 41.64938475 | -75.29956506 | 2021-11-15 04:21:36 | Wayne, Pennsylvania, US | |
2021-11-13 | US | Pennsylvania | Wayne | 42127 | 6069 | 118 | 0 | 41.64938475 | -75.29956506 | 2021-11-14 04:21:31 | Wayne, Pennsylvania, US | |
2021-10-26 | US | Pennsylvania | Jefferson | 42065 | 4943 | 118 | 0 | 41.12913106 | -78.9986361 | 2021-10-27 04:22:32 | Jefferson, Pennsylvania, US | |
2021-10-25 | US | Pennsylvania | Jefferson | 42065 | 4915 | 118 | 0 | 41.12913106 | -78.9986361 | 2021-10-26 04:22:09 | Jefferson, Pennsylvania, US | |
2021-10-24 | US | Pennsylvania | Jefferson | 42065 | 4902 | 118 | 0 | 41.12913106 | -78.9986361 | 2021-10-25 04:22:31 | Jefferson, Pennsylvania, US | |
2021-10-23 | US | Pennsylvania | Jefferson | 42065 | 4884 | 118 | 0 | 41.12913106 | -78.9986361 | 2021-10-24 04:21:22 | Jefferson, Pennsylvania, US | |
2021-10-19 | US | Pennsylvania | Warren | 42123 | 3806 | 118 | 0 | 41.81304978 | -79.26969577 | 2021-10-20 04:21:00 | Warren, Pennsylvania, US | |
2021-10-18 | US | Pennsylvania | Warren | 42123 | 3785 | 118 | 0 | 41.81304978 | -79.26969577 | 2021-10-19 04:20:54 | Warren, Pennsylvania, US | |
2021-10-17 | US | Pennsylvania | Clarion | 42031 | 4567 | 118 | 0 | 41.19265812 | -79.42413524 | 2021-10-18 04:21:10 | Clarion, Pennsylvania, US | |
2021-10-16 | US | Pennsylvania | Clarion | 42031 | 4536 | 118 | 0 | 41.19265812 | -79.42413524 | 2021-10-17 04:21:29 | Clarion, Pennsylvania, US | |
2021-10-15 | US | Pennsylvania | Clarion | 42031 | 4517 | 118 | 0 | 41.19265812 | -79.42413524 | 2021-10-16 04:21:15 | Clarion, Pennsylvania, US | |
2021-10-12 | US | Pennsylvania | Venango | 42121 | 5860 | 118 | 0 | 41.40323442 | -79.75845449 | 2021-10-13 04:20:51 | Venango, Pennsylvania, US | |
2021-10-11 | US | Pennsylvania | Venango | 42121 | 5823 | 118 | 0 | 41.40323442 | -79.75845449 | 2021-10-12 04:21:09 | Venango, Pennsylvania, US | |
2021-10-10 | US | Pennsylvania | Venango | 42121 | 5792 | 118 | 0 | 41.40323442 | -79.75845449 | 2021-10-11 04:21:31 | Venango, Pennsylvania, US | |
2021-10-09 | US | Pennsylvania | Venango | 42121 | 5765 | 118 | 0 | 41.40323442 | -79.75845449 | 2021-10-10 04:21:38 | Venango, Pennsylvania, US | |
2021-10-08 | US | Pennsylvania | Venango | 42121 | 5723 | 118 | 0 | 41.40323442 | -79.75845449 | 2021-10-09 04:21:34 | Venango, Pennsylvania, US | |
2021-10-07 | US | Pennsylvania | Venango | 42121 | 5661 | 118 | 0 | 41.40323442 | -79.75845449 | 2021-10-08 04:21:25 | Venango, Pennsylvania, US | |
2021-10-06 | US | Pennsylvania | Venango | 42121 | 5599 | 118 | 0 | 41.40323442 | -79.75845449 | 2021-10-07 04:21:36 | Venango, Pennsylvania, US | |
2021-10-05 | US | Pennsylvania | Venango | 42121 | 5548 | 118 | 0 | 41.40323442 | -79.75845449 | 2021-10-06 04:21:33 | Venango, Pennsylvania, US | |
2021-09-29 | US | Pennsylvania | Tioga | 42117 | 3990 | 118 | 0 | 41.77255149 | -77.25433032 | 2021-09-30 04:21:20 | Tioga, Pennsylvania, US | |
2021-09-28 | US | Pennsylvania | Tioga | 42117 | 3950 | 118 | 0 | 41.77255149 | -77.25433032 | 2021-09-29 04:21:45 | Tioga, Pennsylvania, US | |
2021-03-23 | US | Pennsylvania | Armstrong | 42005 | 5076 | 118 | 0 | 40.81665618 | -79.46290811 | 2021-03-24 05:25:40 | Armstrong, Pennsylvania, US | |
2021-03-22 | US | Pennsylvania | Armstrong | 42005 | 5068 | 118 | 0 | 40.81665618 | -79.46290811 | 2021-03-23 05:26:18 | Armstrong, Pennsylvania, US | |
2021-03-21 | US | Pennsylvania | Armstrong | 42005 | 5063 | 118 | 0 | 40.81665618 | -79.46290811 | 2021-03-22 05:25:43 | Armstrong, Pennsylvania, US | |
2021-03-20 | US | Pennsylvania | Armstrong | 42005 | 5060 | 118 | 0 | 40.81665618 | -79.46290811 | 2021-03-21 05:25:44 | Armstrong, Pennsylvania, US | |
2021-03-19 | US | Pennsylvania | Armstrong | 42005 | 5049 | 118 | 0 | 40.81665618 | -79.46290811 | 2021-03-20 05:25:46 | Armstrong, Pennsylvania, US | |
2021-03-18 | US | Pennsylvania | Armstrong | 42005 | 5039 | 118 | 0 | 40.81665618 | -79.46290811 | 2021-03-19 05:26:09 | Armstrong, Pennsylvania, US | |
2021-03-17 | US | Pennsylvania | Armstrong | 42005 | 5029 | 118 | 0 | 40.81665618 | -79.46290811 | 2021-03-18 05:26:22 | Armstrong, Pennsylvania, US | |
2021-02-17 | US | Pennsylvania | Huntingdon | 42061 | 4115 | 118 | 0 | 3997 | 40.42162652 | -77.97673273 | 2021-02-18 05:22:58 | Huntingdon, Pennsylvania, US |
2021-02-16 | US | Pennsylvania | Huntingdon | 42061 | 4098 | 118 | 0 | 3980 | 40.42162652 | -77.97673273 | 2021-02-17 05:23:10 | Huntingdon, Pennsylvania, US |
2021-02-15 | US | Pennsylvania | Huntingdon | 42061 | 4091 | 118 | 0 | 3973 | 40.42162652 | -77.97673273 | 2021-02-16 05:24:38 | Huntingdon, Pennsylvania, US |
2021-02-14 | US | Pennsylvania | Huntingdon | 42061 | 4089 | 118 | 0 | 3971 | 40.42162652 | -77.97673273 | 2021-02-15 05:24:49 | Huntingdon, Pennsylvania, US |
2021-02-13 | US | Pennsylvania | Huntingdon | 42061 | 4077 | 118 | 0 | 3959 | 40.42162652 | -77.97673273 | 2021-02-14 05:23:43 | Huntingdon, Pennsylvania, US |
2021-02-04 | US | Pennsylvania | Columbia | 42037 | 4270 | 118 | 0 | 4152 | 41.04821986 | -76.40565017 | 2021-02-05 05:22:38 | Columbia, Pennsylvania, US |
2021-02-03 | US | Pennsylvania | Columbia | 42037 | 4246 | 118 | 0 | 4128 | 41.04821986 | -76.40565017 | 2021-02-04 05:22:26 | Columbia, Pennsylvania, US |
2021-01-26 | US | Pennsylvania | Bedford | 42009 | 3543 | 118 | 0 | 3425 | 40.00522157 | -78.48998442 | 2021-01-27 05:23:41 | Bedford, Pennsylvania, US |
2021-01-25 | US | Pennsylvania | Carbon | 42025 | 4159 | 118 | 0 | 4041 | 40.91545395 | -75.7068525 | 2021-01-26 05:22:02 | Carbon, Pennsylvania, US |
2020-12-18 | US | Pennsylvania | Centre | 42027 | 8312 | 118 | 0 | 8194 | 40.92058903 | -77.82200624 | 2020-12-19 05:27:52 | Centre, Pennsylvania, US |
2020-12-17 | US | Pennsylvania | Centre | 42027 | 8237 | 118 | 0 | 8119 | 40.92058903 | -77.82200624 | 2020-12-18 05:28:18 | Centre, Pennsylvania, US |
2020-11-16 | US | Pennsylvania | Northumberland | 42097 | 1967 | 118 | 0 | 1849 | 40.84785433 | -76.70798222 | 2020-11-17 05:25:54 | Northumberland, Pennsylvania, US |
2020-11-15 | US | Pennsylvania | Northumberland | 42097 | 1957 | 118 | 0 | 1839 | 40.84785433 | -76.70798222 | 2020-11-16 05:25:57 | Northumberland, Pennsylvania, US |
2020-11-09 | US | Pennsylvania | Westmoreland | 42129 | 5270 | 118 | 0 | 5152 | 40.31377979999999 | -79.46615476 | 2020-11-10 05:40:07 | Westmoreland, Pennsylvania, US |
2020-11-08 | US | Pennsylvania | Westmoreland | 42129 | 5173 | 118 | 0 | 5055 | 40.31377979999999 | -79.46615476 | 2020-11-09 05:25:45 | Westmoreland, Pennsylvania, US |
2020-11-07 | US | Pennsylvania | Westmoreland | 42129 | 5073 | 118 | 0 | 4955 | 40.31377979999999 | -79.46615476 | 2020-11-08 05:24:56 | Westmoreland, Pennsylvania, US |
2020-09-22 | US | Pennsylvania | Beaver | 42007 | 1840 | 118 | 0 | 1722 | 40.6825484 | -80.34921611 | 2020-09-23 04:23:00 | Beaver, Pennsylvania, US |
2020-09-21 | US | Pennsylvania | Beaver | 42007 | 1838 | 118 | 0 | 1720 | 40.6825484 | -80.34921611 | 2020-09-22 04:23:00 | Beaver, Pennsylvania, US |
2020-08-28 | US | Pennsylvania | York | 42133 | 3266 | 118 | 0 | 3148 | 39.9210089 | -76.73040131 | 2020-08-29 04:28:19 | York, Pennsylvania, US |
2020-06-19 | US | Pennsylvania | Dauphin | 42043 | 1716 | 118 | 0 | 1598 | 40.41377078 | -76.77993242 | 2020-06-20 04:33:19 | Dauphin, Pennsylvania, US |
2020-05-04 | US | Pennsylvania | Berks | 42011 | 2949 | 118 | 0 | 2831 | 40.41570541 | -75.92457766 | 2020-05-05 02:32:34 | Berks, Pennsylvania, US |
2020-05-03 | US | Pennsylvania | Berks | 42011 | 2886 | 118 | 0 | 2768 | 40.41570541 | -75.92457766 | 2020-05-04 02:32:28 | Berks, Pennsylvania, US |
2020-05-02 | US | Pennsylvania | Berks | 42011 | 2815 | 118 | 0 | 2697 | 40.41570541 | -75.92457766 | 2020-05-03 02:32:28 | Berks, Pennsylvania, US |
2020-04-21 | US | Pennsylvania | Delaware | 42045 | 2637 | 118 | 0 | 2519 | 39.91680171 | -75.40243663 | 2020-04-21 23:30:50 | Delaware, Pennsylvania, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;