Use Case 23: Performance data on health centers

From Demand-Driven Open Data
Jump to: navigation, search

Want to be notified when this use case or any of its datasets change?
You’re signing up to be notified on changes to this use case and associated data sources
* indicates required

Requirements

Use case summary


Description


Value

  • Value to customer: ___
  • Value to industry/public: The data on health centers would allow the media and public to:
    • Compare health center performance
    • Examine the oversight of centers by HRSA
    • Identify the health centers that practice and high levels and those in need of improvements

In addition, it would provide consumers who rely on health centers with timely, accurate information on their quality.

Customer

  • ProPublica
  • Mark Silverberg

Current data and limitation

  • National level summary data
    • Data source: HRSA Health Center Data
    • Limitations: National and overall state level data currently not available as a machine readable export; release of machine readable export targeted for sometime in January of 2016
  • State level data
    • Data source: HRSA Health Center Profile
    • State level and individual health center level data available via web tool
    • After selecting a state, data is available at the individual health center level
    • Aggregated center data can be exported to XLSX file
      • After selecting a state, the first box will have a link to "download [state] aggregated health center data." This will download an XLSX file with the following tabs (corresponding to the tables on the website) with each center as its own row in each table:
        • Age and Race-Ethnicity
        • Patient Characteristics
        • Services
        • Clinical Data
        • Cost
        • Resource Information
    • Data available for 2007 and on
    • Data typically released to public at end of August for prior calendar year
    • Limitations:
      • In web tool, only three years of trend data available. HRSA is working on adding additional back years for longer-term trend data.
      • Only export of tables, no graphs. HRSA is working on export of data in graphical format as well as table.

Specifications

  • Fields:
    • Quality of care measures
      • Percentage of prenatal care patients who entered treatment during their first trimester
      • Percentage of children with their 3rd birthday during the measurement year who are fully immunized before their 3rd birthday
      • Percentage of women 21–64 years of age who received one or more Pap tests to screen for cervical cancer
      • Percentage of patients aged 2 until 17 who had evidence of BMI percentile documentation AND who had documentation of counseling for nutrition AND who had documentation of counseling for physical activity during the measurement year
      • Percentage of patients aged 18 and older who had documentation of a calculated BMI during the most recent visit or within the six months prior to that visit and if the most recent BMI is outside parameters, a follow-up plan is documented
      • Percentage of patients age 18 years and older who were screened for tobacco use at least once during the measurement year or prior year AND who received cessation counseling intervention and/or pharmacotherapy if identified as a tobacco user
      • Percentage of patients aged 5 through 40 with a diagnosis of mild, moderate, or severe persistent asthma who received or were prescribed accepted pharmacologic therapy
      • Percentage of patients aged 18 years and older with a diagnosis of Coronary Artery Disease (CAD) who were prescribed a lipid-lowering therapy
      • Percentage of patients aged 18 years and older who were discharged alive for acute myocardial infarction (AMI) or coronary artery bypass graft (CABG) or percutaneous transluminal coronary angioplasty (PTCA) in the prior year OR who had a diagnosis of ischemic vascular disease during the measurement year who had documentation of use of aspirin or another antithrombotic
      • Percentage of patients aged 50 to 75 who had appropriate screening for colorectal cancer
      • Percentage of patients aged 12 and older screened for clinical depression using an age appropriate standardized tool AND follow-up plan documented
      • Percentage of newly diagnosed HIV patients who had a medical visit for HIV care within 90 days of first-ever HIV diagnosis
      • Percentage of children, age 6–9 years, at moderate to high risk for caries who received a sealant on a first permanent molar during the reporting period
    • Health outcomes and disparities
      • Percentage of adult patients 18 to 75 years of age with a diagnosis of Type I or Type II diabetes, whose hemoglobin A1c (HbA1c) was greater than 9% at the time of the last reading in the measurement year or an HbA1c test was not done
      • Percentage of patients 18 to 85 years of age with diagnosed hypertension (HTN) whose blood pressure (BP) was less than 140/90 at the time of the last reading
      • Percentage of patients born to health center patients whose birthweight was below normal (less than 2500 grams)
    • Financial viability/costs
      • Total cost per patient
      • Medical cost per medical visit
      • Health Center Program grant cost per patient
      • Change in net assets to expense ratio
      • Working capital to monthly expense ratio
      • Long term debt to equity ratio
  • Update frequency: Annual, typically released to public at end of August
  • Joins between datasets: Health center name
  • Lag time: 1 year
  • History: 2007 and on
  • Delivery mechanism: XLSX download

Solution

Short term workaround

  • ___

Long term implementation

  • ___

Want to be notified when this use case or any of its datasets change?