82
edits
Difference between revisions of "DASH Data Guide"
Jump to navigation
Jump to search
→Vacant Property
(copied from old data guide) |
|||
| (8 intermediate revisions by 2 users not shown) | |||
| 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 === | |||
[[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. | |||
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> | |||
=== 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 | |||
=== 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 Hospitalization]] | |||
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. | |||
=== Home Ownership === | |||
[[DASH Guide:Home Ownership]] | |||
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. | |||
=== Homicides === | |||
[[DASH Guide:Homicides]] | |||
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 Addresses === | |||
[[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. | |||
=== 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 == | ||
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 | * [[UCSUR|University of Pittsburgh Center for Social and Urban Research]] | ||
American Heart Association | * American Heart Association | ||
== References == | |||