This View is created to group Death counts by County and by Month.
This dataset contains aggregate death data at the state and county level for Pennsylvania residents. The data are displayed by county, date, death counts, averages, rates based on population. Pennsylvania statewide numbers are listed with Pennsylvania named as the county for the statewide totals. Do not add up the entire file (all rows) or counts will be duplicated.
Data will be updated between 9-11 am every day.

This figure represents the number of mail ballots returned to the counties for review and decision during the 2020 general election.

This view is created from the 2020 General Election Mail Ballot Requests dataset which describes the current state of mail ballot requests. It’s a snapshot in time of the current volume of ballot requests across the Commonwealth.
This view is created to assist with analyzing the original dataset of over 3M rows. This view is an aggregated count of rows by County and by Party Designation.
Original Dataset is here - https://data.pa.gov/Government-Efficiency-Citizen-Engagement/2020-General-Election-Mail-Ballot-Requests-Departm/mcba-yywm

Chart showing the total number of Inmate admissions that receive Medication-Assisted Treatment by year starting in Quarter 1 2017 - Current with the ability to drill through to the quarters. Data supplied by Department of Corrections.

The database was constructed from using the source “Sapphire Emar”. The raw data was condensed to remove any duplicate data that expressed the following: data rows with the same inmate name who had multiple of the same medications or multiple of the same medication type. Then the data sets were sorted by admission dates. Then grouped by quarters or years or both. After that, data was sorted by various descriptor columns: Age Range, Ethnicity, Gender and Drug type.
What is the story the data is telling? The data shows a significantly higher admission rate for Caucasians and Males. The data also shows the age range of 30-34 consistently has the highest percent admission rate. The data also shows a high percentage of inmates receive Vivitrol/Revia as opposed to Suboxone.
What to realize about this data? Although Males and Caucasians have a higher admission rate it is worth noting that this does not take into the account of how many inmates based on gender or ethnicity there are/were in the DOC at a given time. Regardless of Year the Inmate age peaks at 30-34 suggesting they are the most likely to seek treatment.

The database was constructed from using the source “Sapphire Emar”. The raw data was condensed to remove any duplicate data that expressed the following: data rows with the same inmate name who had multiple of the same medications or multiple of the same medication type. Then the data sets were sorted by admission dates. Then grouped by quarters or years or both. After that, data was sorted by various descriptor columns: Age Range, Ethnicity, Gender and Drug type.
What is the story the data is telling? The data shows a significantly higher admission rate for Caucasians and Males. The data also shows the age range of 30-34 consistently has the highest percent admission rate. The data also shows a high percentage of inmates receive Vivitrol/Revia as opposed to Suboxone.
What to realize about this data? Although Males and Caucasians have a higher admission rate it is worth noting that this does not take into the account of how many inmates based on gender or ethnicity there are/were in the DOC at a given time. Regardless of Year the Inmate age peaks at 30-34 suggesting they are the most likely to seek treatment.

Drug type used for Medicated-Assisted Treatment chart from year 2017 to current. Delineated drug type data is not available prior to 2017.

The database was constructed from using the source “Sapphire Emar”. The raw data was condensed to remove any duplicate data that expressed the following: data rows with the same inmate name who had multiple of the same medications or multiple of the same medication type. Then the data sets were sorted by admission dates. Then grouped by quarters or years or both. After that, data was sorted by various descriptor columns: Age Range, Ethnicity, Gender and Drug type.
What is the story the data is telling? The data shows a significantly higher admission rate for Caucasians and Males. The data also shows the age range of 30-34 consistently has the highest percent admission rate. The data also shows a high percentage of inmates receive Vivitrol/Revia as opposed to Suboxone.
What to realize about this data? Although Males and Caucasians have a higher admission rate it is worth noting that this does not take into the account of how many inmates based on gender or ethnicity there are/were in the DOC at a given time. Regardless of Year the Inmate age peaks at 30-34 suggesting they are the most likely to seek treatment.

Filtered for race & ethnicity demographics total admissions. Delineated data is not available prior to year 2017.

Filtered for Age Groupings total admissions. Delineation is not available prior to Year 2017.