Comments (1)
and here is the output from that block of code
<details><summary>Details</summary>
<p>
worksheet name : ED+Hosp Map
County1-alias SUM(Count)-alias Latitude (generated)-value \
0 York 6.322 39.9734
1 Wyoming 1.921 41.5143
2 Westmoreland 5.721 40.3607
3 Wayne 4.083 41.6172
4 Washington 8.116 40.2155
.. ... ... ...
62 Bedford 3.793 40.0255
63 Beaver 9.422 40.6657
64 Armstrong 8.296 40.8485
65 Allegheny 5.961 40.4317
66 Adams 3.649 39.8953
Latitude (generated)-alias Longitude (generated)-value \
0 39.973 -76.7442
1 41.514 -76.007
2 40.361 -79.3848
3 41.617 -75.2609
4 40.216 -80.2389
.. ... ...
62 40.026 -78.483
63 40.666 -80.3336
64 40.849 -79.4535
65 40.432 -80.0043
66 39.895 -77.2259
Longitude (generated)-alias ATTR(Rate v count label)-alias \
0 -76.744 per 10,000 Population
1 -76.007 per 10,000 Population
2 -79.385 per 10,000 Population
3 -75.261 per 10,000 Population
4 -80.239 per 10,000 Population
.. ... ...
62 -78.483 per 10,000 Population
63 -80.334 per 10,000 Population
64 -79.454 per 10,000 Population
65 -80.004 per 10,000 Population
66 -77.226 per 10,000 Population
ATTR(Class1)-alias ATTR(Measure1)-alias \
0 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
1 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
2 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
3 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
4 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
.. ... ...
62 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
63 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
64 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
65 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
66 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
ATTR(Notes)-alias ATTR(Time Period1)-alias
0 %null% 2023 Q2
1 %null% 2023 Q2
2 %null% 2023 Q2
3 %null% 2023 Q2
4 %null% 2023 Q2
.. ... ...
62 %null% 2023 Q2
63 %null% 2023 Q2
64 %null% 2023 Q2
65 %null% 2023 Q2
66 %null% 2023 Q2
[67 rows x 11 columns]
worksheet name : ED+Hosp-Trends
County1-value County1-alias Time Period1-value Time Period1-alias \
0 Philadelphia Philadelphia 2015 Q1 2015 Q1
1 Philadelphia Philadelphia 2015 Q2 2015 Q2
2 Philadelphia Philadelphia 2015 Q3 2015 Q3
3 Philadelphia Philadelphia 2015 Q4 2015 Q4
4 Philadelphia Philadelphia 2016 Q1 2016 Q1
.. ... ... ... ...
97 Pennsylvania Pennsylvania 2022 Q2 2022 Q2
98 Pennsylvania Pennsylvania 2022 Q3 2022 Q3
99 Pennsylvania Pennsylvania 2022 Q4 2022 Q4
100 Pennsylvania Pennsylvania 2023 Q1 2023 Q1
101 Pennsylvania Pennsylvania 2023 Q2 2023 Q2
SUM(Count)-value SUM(Count)-alias ATTR(Rate v count label)-alias \
0 5.994 5.994 per 10,000 Population
1 7.323 7.323 per 10,000 Population
2 9.264 9.264 per 10,000 Population
3 9.359 9.359 per 10,000 Population
4 8.208 8.208 per 10,000 Population
.. ... ... ...
97 7.394 7.394 per 10,000 Population
98 7.876 7.876 per 10,000 Population
99 7.059 7.059 per 10,000 Population
100 7.132 7.132 per 10,000 Population
101 7.298 7.298 per 10,000 Population
ATTR(Class1)-alias ATTR(Measure1)-alias \
0 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
1 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
2 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
3 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
4 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
.. ... ...
97 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
98 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
99 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
100 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
101 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
ATTR(Notes)-alias ATTR(Time Period1)-alias
0 %null% 2015 Q1
1 %null% 2015 Q2
2 %null% 2015 Q3
3 %null% 2015 Q4
4 %null% 2016 Q1
.. ... ...
97 %null% 2022 Q2
98 %null% 2022 Q3
99 %null% 2022 Q4
100 %null% 2023 Q1
101 %null% 2023 Q2
[102 rows x 11 columns]
worksheet name : dateupdated
MONTH(today)-alias WEEK(last year)-alias
0 July 2023 August 21, 2022
worksheet name : info
SUM(menu)-alias
0 1
worksheet name : menu
SUM(menu)-alias
0 1
[]
[{'column': 'County1', 'values': ['Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Philadelphia', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Allegheny', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania', 'Pennsylvania']}, {'column': 'Time Period1', 'values': ['2015 Q1', '2015 Q2', '2015 Q3', '2015 Q4', '2016 Q1', '2016 Q2', '2016 Q3', '2016 Q4', '2017 Q1', '2017 Q2', '2017 Q3', '2017 Q4', '2018 Q1', '2018 Q2', '2018 Q3', '2018 Q4', '2019 Q1', '2019 Q2', '2019 Q3', '2019 Q4', '2020 Q1', '2020 Q2', '2020 Q3', '2020 Q4', '2021 Q1', '2021 Q2', '2021 Q3', '2021 Q4', '2022 Q1', '2022 Q2', '2022 Q3', '2022 Q4', '2023 Q1', '2023 Q2', '2015 Q1', '2015 Q2', '2015 Q3', '2015 Q4', '2016 Q1', '2016 Q2', '2016 Q3', '2016 Q4', '2017 Q1', '2017 Q2', '2017 Q3', '2017 Q4', '2018 Q1', '2018 Q2', '2018 Q3', '2018 Q4', '2019 Q1', '2019 Q2', '2019 Q3', '2019 Q4', '2020 Q1', '2020 Q2', '2020 Q3', '2020 Q4', '2021 Q1', '2021 Q2', '2021 Q3', '2021 Q4', '2022 Q1', '2022 Q2', '2022 Q3', '2022 Q4', '2023 Q1', '2023 Q2', '2015 Q1', '2015 Q2', '2015 Q3', '2015 Q4', '2016 Q1', '2016 Q2', '2016 Q3', '2016 Q4', '2017 Q1', '2017 Q2', '2017 Q3', '2017 Q4', '2018 Q1', '2018 Q2', '2018 Q3', '2018 Q4', '2019 Q1', '2019 Q2', '2019 Q3', '2019 Q4', '2020 Q1', '2020 Q2', '2020 Q3', '2020 Q4', '2021 Q1', '2021 Q2', '2021 Q3', '2021 Q4', '2022 Q1', '2022 Q2', '2022 Q3', '2022 Q4', '2023 Q1', '2023 Q2']}, {'column': 'SUM(Count)', 'values': [5.994, 7.323, 9.264, 9.359, 8.208, 9.432, 10.637, 12.863, 13.789, 17.31, 16.937, 13.454, 12.222, 15.034, 19.73, 17.996, 17.255, 18.978, 18.953, 17.022, 16.764, 16.933, 16.746, 15.815, 15.657, 17.669, 18.024, 14.382, 13.094, 14.357, 14.966, 13.113, 13.545, 14.598, 5.743, 7.004, 6.223, 6.15, 7.711, 8.599, 11.395, 11.949, 11.881, 12.701, 12.332, 9.808, 8.673, 8.69, 9.429, 9.331, 8.045, 9.682, 10.578, 8.974, 9.193, 8.817, 10.082, 8.761, 7.778, 9.159, 7.697, 6.736, 5.953, 6.631, 7.253, 7.092, 6.34, 5.961, 5.176, 6.905, 7.518, 6.629, 6.762, 7.38, 8.627, 8.848, 8.96, 10.162, 10.193, 8.653, 7.723, 8.899, 10.349, 9.257, 8.483, 9.596, 9.935, 8.778, 8.484, 8.854, 9.543, 8.438, 8.156, 9.269, 9.327, 7.815, 7.165, 7.394, 7.876, 7.059, 7.132, 7.298]}, {'column': 'ATTR(Rate v count label)', 'values': [' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population', ' per 10,000 Population']}, {'column': 'ATTR(Class1)', 'values': ['Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose', 'Any Drug Overdose']}, {'column': 'ATTR(Measure1)', 'values': ['Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)', 'Rate of ED Visits per 10,000 Population (by home location)']}, {'column': 'ATTR(Notes)', 'values': ['%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%', '%null%']}, {'column': 'ATTR(Time Period1)', 'values': ['2015 Q1', '2015 Q2', '2015 Q3', '2015 Q4', '2016 Q1', '2016 Q2', '2016 Q3', '2016 Q4', '2017 Q1', '2017 Q2', '2017 Q3', '2017 Q4', '2018 Q1', '2018 Q2', '2018 Q3', '2018 Q4', '2019 Q1', '2019 Q2', '2019 Q3', '2019 Q4', '2020 Q1', '2020 Q2', '2020 Q3', '2020 Q4', '2021 Q1', '2021 Q2', '2021 Q3', '2021 Q4', '2022 Q1', '2022 Q2', '2022 Q3', '2022 Q4', '2023 Q1', '2023 Q2', '2015 Q1', '2015 Q2', '2015 Q3', '2015 Q4', '2016 Q1', '2016 Q2', '2016 Q3', '2016 Q4', '2017 Q1', '2017 Q2', '2017 Q3', '2017 Q4', '2018 Q1', '2018 Q2', '2018 Q3', '2018 Q4', '2019 Q1', '2019 Q2', '2019 Q3', '2019 Q4', '2020 Q1', '2020 Q2', '2020 Q3', '2020 Q4', '2021 Q1', '2021 Q2', '2021 Q3', '2021 Q4', '2022 Q1', '2022 Q2', '2022 Q3', '2022 Q4', '2023 Q1', '2023 Q2', '2015 Q1', '2015 Q2', '2015 Q3', '2015 Q4', '2016 Q1', '2016 Q2', '2016 Q3', '2016 Q4', '2017 Q1', '2017 Q2', '2017 Q3', '2017 Q4', '2018 Q1', '2018 Q2', '2018 Q3', '2018 Q4', '2019 Q1', '2019 Q2', '2019 Q3', '2019 Q4', '2020 Q1', '2020 Q2', '2020 Q3', '2020 Q4', '2021 Q1', '2021 Q2', '2021 Q3', '2021 Q4', '2022 Q1', '2022 Q2', '2022 Q3', '2022 Q4', '2023 Q1', '2023 Q2']}]
[{'column': 'County1', 'ordinal': 0, 'values': ['Pennsylvania', 'Adams', 'Allegheny', 'Armstrong', 'Beaver', 'Bedford', 'Berks', 'Blair', 'Bradford', 'Bucks', 'Butler', 'Cambria', 'Cameron', 'Carbon', 'Centre', 'Chester', 'Clarion', 'Clearfield', 'Clinton', 'Columbia', 'Crawford', 'Cumberland', 'Dauphin', 'Delaware', 'Elk', 'Erie', 'Fayette', 'Forest', 'Franklin', 'Fulton', 'Greene', 'Huntingdon', 'Indiana', 'Jefferson', 'Juniata', 'Lackawanna', 'Lancaster', 'Lawrence', 'Lebanon', 'Lehigh', 'Luzerne', 'Lycoming', 'McKean', 'Mercer', 'Mifflin', 'Monroe', 'Montgomery', 'Montour', 'Northampton', 'Northumberland', 'Perry', 'Philadelphia', 'Pike', 'Potter', 'Schuylkill', 'Snyder', 'Somerset', 'Sullivan', 'Susquehanna', 'Tioga', 'Union', 'Venango', 'Warren', 'Washington', 'Wayne', 'Westmoreland', 'Wyoming', 'York'], 'globalFieldName': '[federated.0s134hy08qgkzd10o4nj215amiyk (copy)].[none:County:nk]', 'selection': ['Pennsylvania', 'Allegheny', 'Philadelphia'], 'selectionAlt': [{'fn': '[federated.0s134hy08qgkzd10o4nj215amiyk (copy)].[none:County:nk]', 'columnFullNames': ['[County1]'], 'domainTables': [{'isSelected': True, 'label': 'Pennsylvania'}]}]}]
County1-value County1-alias Time Period1-value Time Period1-alias \
0 York York 2015 Q1 2015 Q1
1 York York 2015 Q2 2015 Q2
2 York York 2015 Q3 2015 Q3
3 York York 2015 Q4 2015 Q4
4 York York 2016 Q1 2016 Q1
... ... ... ... ...
2185 Pennsylvania Pennsylvania 2022 Q2 2022 Q2
2186 Pennsylvania Pennsylvania 2022 Q3 2022 Q3
2187 Pennsylvania Pennsylvania 2022 Q4 2022 Q4
2188 Pennsylvania Pennsylvania 2023 Q1 2023 Q1
2189 Pennsylvania Pennsylvania 2023 Q2 2023 Q2
SUM(Count)-value SUM(Count)-alias ATTR(Rate v count label)-alias \
0 4.413 4.413 per 10,000 Population
1 6.472 6.472 per 10,000 Population
2 7.151 7.151 per 10,000 Population
3 6.608 6.608 per 10,000 Population
4 5.766 5.766 per 10,000 Population
... ... ... ...
2185 7.394 7.394 per 10,000 Population
2186 7.876 7.876 per 10,000 Population
2187 7.059 7.059 per 10,000 Population
2188 7.132 7.132 per 10,000 Population
2189 7.298 7.298 per 10,000 Population
ATTR(Class1)-alias ATTR(Measure1)-alias \
0 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
1 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
2 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
3 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
4 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
... ... ...
2185 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
2186 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
2187 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
2188 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
2189 Any Drug Overdose Rate of ED Visits per 10,000 Population (by ho...
ATTR(Notes)-alias ATTR(Time Period1)-alias
0 %null% 2015 Q1
1 %null% 2015 Q2
2 %null% 2015 Q3
3 %null% 2015 Q4
4 %null% 2016 Q1
... ... ...
2185 %null% 2022 Q2
2186 %null% 2022 Q3
2187 %null% 2022 Q4
2188 %null% 2023 Q1
2189 %null% 2023 Q2
[2190 rows x 11 columns]
</p>
</details>
from tableau-scraping.
Related Issues (20)
- Issue selecting Parameter in Story Point HOT 1
- getTupleIds fail to run when `presModel` is None
- Can't set a Parameter if not listed in getParameters() HOT 2
- Can't set a filter to a value thats not in the defined list for that filter HOT 2
- add missing method for command `select-region-no-return-server` HOT 1
- Add getFilterItems() method
- Scraping tableau data based on data filtered with dropdown boxes in non existent worksheet columns
- Adding range filters
- soup.find fails to find Tableau data HOT 3
- Scraping from a private-access dashboard
- scraping workbook, NOT worksheet with selectables HOT 6
- Attempting to fetch data from sheet but can't get worksheets using getWorksheets(), most requests are returning empty arrays.
- Zones don't always update when there are story points
- getFilters() only returns the first 200 values
- How to scrape pagination data
- Radio Button filtering does not work
- Warning: mixed data types
- Add support for the 'Choose a format to download' > 'Data' option (alongside the crosstab option)
- Setting a filter produces `WARNING - no data dictionary present in response` and causes `getCsvData` to raise `TypeError`
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tableau-scraping.