Dataset: Diabetes + Hypertension (comorbidity)

About this Dataset

Diabetes + Hypertension (comorbidity)

This data set provides de-identified population data for diabetes and hypertension comorbidity prevalence in Allegheny County. The data is provided by three managed care organizations in Allegheny County (Gateway Health Plan, Highmark Health, and UPMC) and represents their insured population for the 2015 and 2016 calendar years. Disclaimer: Users should be cautious of using administrative claims data as a measure of disease prevalence and interpreting trends over time, as data provided were collected for purposes other than surveillance. Limitations of these data include but are not limited to: misclassification, duplicate individuals, exclusion of individuals who did not seek care in past two years and those who are: uninsured, enrolled in plans not represented in the dataset, or were not enrolled in one of the represented plans for at least 90 days.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:09:45.403755
Tags: achd-dash, blood-pressure, comorbidity, diabetes, hypertension, social-determinants-of-health, type-2-diabetes-mellitus

Tables

Diabetes Hypertension Co-morbidity (2016)

@usgov.allegheny_county_city_of_pitts_diabetes_hypertension_c_f7607e2f.diabetes_hypertension_co_morbidity_2016

15.7 KB
390 rows
7 columns


CREATE TABLE diabetes_hypertension_co_morbidity_2016 (
  "ct" BIGINT,
  "btpad" BIGINT,
  "btpan" BIGINT,
  "btwad" BIGINT,
  "btwan" BIGINT,
  "btmad" BIGINT,
  "btman" BIGINT
);

Diabetes Hypertension Co-morbidity (2015)

@usgov.allegheny_county_city_of_pitts_diabetes_hypertension_c_f7607e2f.diabetes_hypertension_co_morbidity_2015

16.01 KB
390 rows
7 columns


CREATE TABLE diabetes_hypertension_co_morbidity_2015 (
  "ct" BIGINT,
  "btpad" BIGINT,
  "btpan" BIGINT,
  "btwad" BIGINT,
  "btwan" BIGINT,
  "btmad" BIGINT,
  "btman" BIGINT
);