DASH Data Guide - Revision history

Rossr: /* Vacant Property */

2022-12-22T17:54:48Z

Vacant Property

← Older revision		Revision as of 17:54, 22 December 2022
Line 125:		Line 125:
	Traffic sensors at over 1,200 locations in Allegheny County collect vehicle counts for the Pennsylvania Department of Transportation. Data included in the DASH project includes hourly averages and average daily counts. The data was collected from years 2012-2014 and compiled by Carnegie Mellon University’s Traffic21 Institute.		Traffic sensors at over 1,200 locations in Allegheny County collect vehicle counts for the Pennsylvania Department of Transportation. Data included in the DASH project includes hourly averages and average daily counts. The data was collected from years 2012-2014 and compiled by Carnegie Mellon University’s Traffic21 Institute.

	=== Vacant ~~Property~~ ===		=== Vacant Addresses ===
	[[DASH Guide:Vacant ~~Property~~]]		[[DASH Guide:Vacant Addresses]]

	Mail carriers routinely collect data on address no longer receiving mail due to vacancy. This vacancy data is reported quarterly at census tract geographies in the United States for residential, commercial, and industrial properties along with counts of total mailing addresses. Data released through DASH has been aggregated to Allegheny County Municipalities and City Wards.		Mail carriers routinely collect data on address no longer receiving mail due to vacancy. This vacancy data is reported quarterly at census tract geographies in the United States for residential, commercial, and industrial properties along with counts of total mailing addresses. Data released through DASH has been aggregated to Allegheny County Municipalities and City Wards.

Rossr at 20:15, 20 December 2022

2022-12-20T20:15:46Z

← Older revision		Revision as of 20:15, 20 December 2022
Line 149:		Line 149:
	* [[UCSUR\|University of Pittsburgh Center for Social and Urban Research]]		* [[UCSUR\|University of Pittsburgh Center for Social and Urban Research]]
	* American Heart Association		* American Heart Association

			== References ==

Rossr: /* Dataset-specific guides */

2022-12-20T20:14:53Z

Dataset-specific guides

Show changes

Rossr: /* Dataset-specific guides */

2022-12-20T18:10:18Z

Dataset-specific guides

← Older revision		Revision as of 18:10, 20 December 2022
Line 24:		Line 24:

	These datasets provide de-identified co-morbidity diagnosis data for diabetes, hypertension, and hyperlipidemia. The data is provided by three managed care organizations in Allegheny County (Gateway Health Plan, Highmark Health, and UPMC) and represents their insured population (medicare, medicaid, individual, and corporate) for the 2015 calendar year. This data will soon be available as open data through the Regional Data Center		These datasets provide de-identified co-morbidity diagnosis data for diabetes, hypertension, and hyperlipidemia. The data is provided by three managed care organizations in Allegheny County (Gateway Health Plan, Highmark Health, and UPMC) and represents their insured population (medicare, medicaid, individual, and corporate) for the 2015 calendar year. This data will soon be available as open data through the Regional Data Center

			=== Clean indoor Act Exemptions ===
			[[DASH Guide:Clean Indoor Act Exemptions]]

			List and location of all the businesses and social clubs who have received an exemption from the Pennsylvania Clean Indoor Air Act.

			=== Diabetes Hospitalizations ===
			DASH Guide:Diabetes Hospitalizations

			This data includes the number of people hospitalized with diabetes between 2013-2015, by age group, for Allegheny County Zip Codes. The information was produced by Pennsylvania Health Care Cost Containment Council (PHC4) for 2013-2015.

			=== Environmental Justice Areas ===
			DASH Guide:Environmental Justice Areas

			Environmental Justice areas in this guide have been defined by the Pennsylvania Department of Environmental Protection. The Department defines an environmental justice area as any census tract where at least 20 percent of the population lives in poverty, and/or 30 percent or more of the population is minority.

			=== Fast Food Establishments ===
			DASH Guide:Fast Food Establishments

			The Allegheny County Health Department has generated this list of fast food restaurants by exporting all chain restaurants without an alcohol permit from the County’s Fee and Permit System.

			=== Greenways ===
			DASH Guide:Greenways

			Greenway data was compiled by the Allegheny Land Trust as a planning effort in the development of Allegheny Places, the Allegheny County Comprehensive Plan. The Pennsylvania Department of Conservation and Natural Resources defines a greenway as "A corridor of open space." Greenways vary greatly in size, may include public and private property, and can include land and water areas.

			=== Health Care Facilities ===
			DASH Guide:Health Care Facility

			The data on health care facilities includes the name and location of all the hospitals and primary care facilities in Allegheny County. The current listing of hospitals and primary care facilities is managed by the Allegheny County Health Department and is used in internal reporting and shared for public use.

			=== Homicides ===
			DASH Guide:Homicides

			Home ownership provides a number of financial, social, and health benefits to American families. Especially in areas with housing price appreciation, home ownership is a wealth building mechanism and home owners are also eligible to receive substantial federal and local tax benefits. Owning a home also provides families with increased residential stability, which can translate into improved school performance for children. The financial stake owners have in their neighborhood also is viewed as something that spurs them to become more-engaged in their community, and there is some research that has found that home ownership also can translate to improved health.

			Homicide data was provided by the Allegheny Department of Human Services for the years 2002-2014. Human Services received the original data from the Allegheny County Medical Examiner.

			=== Hypertension Hospitalization ===
			DASH Guide:Hypertension Hospitalization

			This data provides hypertension prevalence data for each Zip Code in Allegheny County. The information was produced by Pennsylvania Health Care Cost Containment Council (PHC4) for 2013-2015.

			=== Illegal Dump Sites ===
			DASH Guide:Illegal Dump Sites

			The Illegal Dump Site dataset includes information on illegal dumpsites, their type of trash, and the estimate tons of trash at each site. The information was provided by Allegheny Cleanways, and collected as part of a 2005 survey in Allegheny County.

			=== Median Age at Death ===
			DASH Guide:Median Age at Death

			The median age at death is calculated for each municipality in Allegheny County for 2011-2015. Data is based on the decedent's residence at the time of death, not the location where the death occurred.

			=== Obesity Rates ===
			DASH Guide:Obesity Rates

			Obesity estimates for each Census Tract in Allegheny County were produced for the study “Developing small-area predictions for smoking and obesity prevalence in the United States.” The data is not explicitly based on population surveys or data collection conducted in Allegheny County, but rather estimated using statistical modeling techniques.

			=== Older Housing (Built Before 1950) ===
			DASH Guide:Older Housing (Built Before 1950)

			Older housing can impact the quality of the occupant's health in a number of ways, including lead exposure, housing quality, and factors that may exacerbate respiratory conditions, including asthma.

			=== Particulate Matter 2.5 ===
			DASH Guide:Particulate Matter 2.5

			The U.S. Environmental Protection Agency provides information on the particulate matter concentration for Allegheny County that have a diameter greater or equal to 2.5 mm. Chronic exposure to particles contributes to the risk of developing cardiovascular and respiratory diseases, as well as of lung cancer.

			=== Poor Housing Conditions ===
			DASH Guide:Poor Housing Conditions

			This estimate of the percent of distressed housing units in each Census Tract was prepared using data from the American Community Survey and the Allegheny County Property Assessment database. The estimate was produced by the Reinvestment Fund in their work with the Allegheny County Department of Economic Development.

			=== Smoking Rates ===
			DASH Guide:Smoking Rates

			Smoking rates estimates for each Census Tract in Allegheny County were produced for the study “Developing small-area predictions for smoking and obesity prevalence in the United States”. The data is not explicitly based on population surveys or data collection conducted in Allegheny County, but rather estimated using statistical modeling techniques.

			=== Supermarkets and Convenience Stores ===
			DASH Guide:Supermarkets and Convenience Stores

			Location information for all Supermarkets and Convenience Stores in Allegheny County was produced using the Allegheny County Fee and Permit Data.

			=== Tobacco Vendors ===
			DASH Guide:Tobacco Vendors

			The tobacco vendor information provides the location of all tobacco vendors in Allegheny County in 2015. Data was compiled from administrative records managed by the Pennsylvania Department of Revenue.

			=== Toxics Release Inventory ===
			DASH Guide:Toxics Release Inventory

			The data provides information about toxic substances released into the environment in the United States. Annual releases are compiled and reported by the U.S. Environmental Protection Agency (EPA) and shared on the Toxics Release Inventory Website.

			=== Traffic Counts ===
			DASH Guide:Traffic Counts

			Traffic sensors at over 1,200 locations in Allegheny County collect vehicle counts for the Pennsylvania Department of Transportation. Data included in the DASH project includes hourly averages and average daily counts. The data was collected from years 2012-2014 and compiled by Carnegie Mellon University’s Traffic21 Institute.

			=== Vacant Property ===
			DASH Guide:Vacant Property

			Mail carriers routinely collect data on address no longer receiving mail due to vacancy. This vacancy data is reported quarterly at census tract geographies in the United States for residential, commercial, and industrial properties along with counts of total mailing addresses. Data released through DASH has been aggregated to Allegheny County Municipalities and City Wards.

			=== Walk Scores ===
			DASH Guide:Walk Scores

			Walk Score measures the walkability of any address using a patented system developed by the Walk Score company (since acquired by Redfin). For each 2010 Census Tract centroid, Walk Score analyzed walking routes to nearby amenities.

	== Partners ==		== Partners ==

Steve at 12:45, 16 November 2021

2021-11-16T12:45:00Z

← Older revision		Revision as of 12:45, 16 November 2021
Line 21:		Line 21:

	=== Cardiovascular Disease Co-Morbidity ===		=== Cardiovascular Disease Co-Morbidity ===
	[[~~DASH_Guide~~:~~Cardiovascular_Disease_Co~~-morbidity]]		[[DASH Guide:Cardiovascular Disease Co-morbidity]]

	These datasets provide de-identified co-morbidity diagnosis data for diabetes, hypertension, and hyperlipidemia. The data is provided by three managed care organizations in Allegheny County (Gateway Health Plan, Highmark Health, and UPMC) and represents their insured population (medicare, medicaid, individual, and corporate) for the 2015 calendar year. This data will soon be available as open data through the Regional Data Center		These datasets provide de-identified co-morbidity diagnosis data for diabetes, hypertension, and hyperlipidemia. The data is provided by three managed care organizations in Allegheny County (Gateway Health Plan, Highmark Health, and UPMC) and represents their insured population (medicare, medicaid, individual, and corporate) for the 2015 calendar year. This data will soon be available as open data through the Regional Data Center

Steve: /* Anxiety and Depression Medication */

2021-11-16T12:43:29Z

Anxiety and Depression Medication

← Older revision		Revision as of 12:43, 16 November 2021
Line 14:		Line 14:

	=== Anxiety and Depression Medication ===		=== Anxiety and Depression Medication ===
			[[DASH Guide:Anxiety Medication]]

	These datasets described here provide de-identified diagnosis data for customers (medicare, medicaid, individual, and corporate) of three managed care organizations in Allegheny County (Gateway Health Plan, Highmark Health, and UPMC) that have filed a claim for anxiety or depression medications in 2015. The data also includes the number of enrolled members in the three participating managed care organizations in 2015.		These datasets described here provide de-identified diagnosis data for customers (medicare, medicaid, individual, and corporate) of three managed care organizations in Allegheny County (Gateway Health Plan, Highmark Health, and UPMC) that have filed a claim for anxiety or depression medications in 2015. The data also includes the number of enrolled members in the three participating managed care organizations in 2015.

	The anxiety and depression datasets were requested after the initial data list had been collected because members of the DASH Partnership wanted to explore the relationship between anxiety and depression with cardiovascular disease following receipt of the cardiovascular disease data. There is evidence that depression is a risk factor for cardiovascular disease.<ref>https://www.heartfoundation.org.au/images/uploads/publications/Beyondblue_depression_CHD.pdf</ref>		The anxiety and depression datasets were requested after the initial data list had been collected because members of the DASH Partnership wanted to explore the relationship between anxiety and depression with cardiovascular disease following receipt of the cardiovascular disease data. There is evidence that depression is a risk factor for cardiovascular disease.<ref>https://www.heartfoundation.org.au/images/uploads/publications/Beyondblue_depression_CHD.pdf</ref>

	[[~~DASH Guide~~:~~Anxiety Medication~~]]		=== Cardiovascular Disease Co-Morbidity ===
			[[DASH_Guide:Cardiovascular_Disease_Co-morbidity]]

			These datasets provide de-identified co-morbidity diagnosis data for diabetes, hypertension, and hyperlipidemia. The data is provided by three managed care organizations in Allegheny County (Gateway Health Plan, Highmark Health, and UPMC) and represents their insured population (medicare, medicaid, individual, and corporate) for the 2015 calendar year. This data will soon be available as open data through the Regional Data Center

	== Partners ==		== Partners ==

Steve at 12:11, 16 November 2021

2021-11-16T12:11:53Z

← Older revision		Revision as of 12:11, 16 November 2021
Line 10:		Line 10:

	When the initial list of desired datasets was created, the DASH project was in the process of holding its first monthly meetings with project stakeholders. At the monthly meetings the candidate datasets and selection justification was presented to the project stakeholders. Their feedback on this information shaped the final selection of measures. The stakeholders led the project team to include data describing several more important factors risk factors such as stress proxy and food security indicators. Once finalized, the Allegheny County Health Department began to collect data appearing in this guide from many different sources.		When the initial list of desired datasets was created, the DASH project was in the process of holding its first monthly meetings with project stakeholders. At the monthly meetings the candidate datasets and selection justification was presented to the project stakeholders. Their feedback on this information shaped the final selection of measures. The stakeholders led the project team to include data describing several more important factors risk factors such as stress proxy and food security indicators. Once finalized, the Allegheny County Health Department began to collect data appearing in this guide from many different sources.

			== Dataset-specific guides ==

			=== Anxiety and Depression Medication ===
			These datasets described here provide de-identified diagnosis data for customers (medicare, medicaid, individual, and corporate) of three managed care organizations in Allegheny County (Gateway Health Plan, Highmark Health, and UPMC) that have filed a claim for anxiety or depression medications in 2015. The data also includes the number of enrolled members in the three participating managed care organizations in 2015.

			The anxiety and depression datasets were requested after the initial data list had been collected because members of the DASH Partnership wanted to explore the relationship between anxiety and depression with cardiovascular disease following receipt of the cardiovascular disease data. There is evidence that depression is a risk factor for cardiovascular disease.<ref>https://www.heartfoundation.org.au/images/uploads/publications/Beyondblue_depression_CHD.pdf</ref>

			[[DASH Guide:Anxiety Medication]]

	== Partners ==		== Partners ==

Steve at 11:57, 16 November 2021

2021-11-16T11:57:32Z

← Older revision		Revision as of 11:57, 16 November 2021
Line 23:		Line 23:
	* Highmark Health		* Highmark Health
	* Allegheny County CountyStat		* Allegheny County CountyStat
	* ~~<nowiki>~~[[UCSUR\|University of Pittsburgh Center for Social and Urban Research]]~~</nowiki>~~		* [[UCSUR\|University of Pittsburgh Center for Social and Urban Research]]
	* American Heart Association		* American Heart Association

Steve: put partners in list

2021-11-16T11:57:10Z

put partners in list

← Older revision		Revision as of 11:57, 16 November 2021
Line 13:		Line 13:
	== Partners ==		== Partners ==

	Allegheny County Department of Human Services		* Allegheny County Department of Human Services
	Allegheny County Economic Development		* Allegheny County Economic Development
	UPMC Health Plan		* UPMC Health Plan
	Jewish Healthcare Foundation		* Jewish Healthcare Foundation
	Carnegie Mellon Traffic21 Institute		* Carnegie Mellon Traffic21 Institute
	University of Pittsburgh Graduate School of Public Health		* University of Pittsburgh Graduate School of Public Health
	Rand Corporation		* Rand Corporation
	Gateway Health Plan Inc		* Gateway Health Plan Inc
	Highmark Health		* Highmark Health
	Allegheny County CountyStat		* Allegheny County CountyStat
	University of Pittsburgh Center for Social and Urban Research		* <nowiki>[[UCSUR\|University of Pittsburgh Center for Social and Urban Research]]</nowiki>
	American Heart Association		* American Heart Association

Steve: copied from old data guide

2021-11-16T11:55:16Z

copied from old data guide

New page

The data in this guide has been assembled and made available for public use as part of the Allegheny County Data Across Sectors for Health (DASH) project. This local DASH project is supported by the Robert Wood Johnson Foundation as part of their national initiative aiming to develop, implement, and evaluate multi-sector data sharing projects addressing a range of public health challenges. As part of this collaboration the Allegheny County Health Department has collected social determinants data from multiple sources in an attempt to improve the cardiovascular health of 1.2 million residents in the county. This data available through DASH not only relates to cardiovascular disease, but a wide variety of issues impacting public health, including human services, economic development, healthcare, and transportation. The lead agency for the DASH project, the Allegheny County Health Department and project partners have agreed to share these datasets publicly as open data. Community members and organizations are free use this data in a number of ways, including supporting the development of personal and organizational projects, conducting research, and fundraising.

Beyond making information more available and accessible, The Health Department and project partners are using these datasets to create a predictive model of cardiovascular disease in Allegheny County. The Public Health Dynamics Laboratory from the University of Pittsburgh has developed the Framework for Reconstructing Epidemic Dynamics (FRED) predictive model to predict infectious disease. FRED has now been modified to model chronic disease throughout the county and predict the effectiveness of possible interventions through the DASH project. Intervention plans will then be developed and information disseminated by the project partners, who are part of the larger Health Department advisory coalition comprised of over 75 partner organizations. The Health Department would like to thank all the DASH partners who have provided the majority of the data for this project, contributed technical expertise, given local and industry perspectives, and made the sharing of this data possible.

== Indicator Selection Process ==

The datasets provided in this Data Across Sectors for Health (DASH) data guide can provide supporting research to address a range of public health challenges. A dataset added to the DASH data warehouse if it has a potential connection to Cardiovascular Disease (CVD). Cardiovascular disease was chosen as the topic of research for this project because it is the leading cause of death in Allegheny County. This topic was also chosen due to the disparities that persist by race and gender in the County.

Determining what topics and measurements may predict or have a connection to cardiovascular disease was a two step process spanning a six month period from January to July, 2016. The initial list of risk variables was compiled by staff working at Allegheny County’s Department of Human Services and Health Department. These staff relied on research to identify six major contributors to heart disease, which include obesity, physical inactivity, tobacco use, abnormal blood lipid levels, hypertension, and type II diabetes. Staff involved in the selection process used these risk factors to identify candidate datasets, excluding data lacking a proxy for measurement and data that was not accessible or reliable.

When the initial list of desired datasets was created, the DASH project was in the process of holding its first monthly meetings with project stakeholders. At the monthly meetings the candidate datasets and selection justification was presented to the project stakeholders. Their feedback on this information shaped the final selection of measures. The stakeholders led the project team to include data describing several more important factors risk factors such as stress proxy and food security indicators. Once finalized, the Allegheny County Health Department began to collect data appearing in this guide from many different sources.

== Partners ==

Allegheny County Department of Human Services
Allegheny County Economic Development
UPMC Health Plan
Jewish Healthcare Foundation
Carnegie Mellon Traffic21 Institute
University of Pittsburgh Graduate School of Public Health
Rand Corporation
Gateway Health Plan Inc
Highmark Health
Allegheny County CountyStat
University of Pittsburgh Center for Social and Urban Research
American Heart Association