Embedded Files
Every state should have a comprehensive health data portal. to provide transparency for stakeholders. Many states have portals, but all fall short of easy access to data sets and macro-level views of aggregated data. See the following:
- Wisconsin Collaborative for Healthcare Quality (WCHQ), offers a fancy appliccation for casual or focused users, but lacks aggregated data sets for download. WCHQ also lacks the hyperlinks to many relevant data resources.
- CoHID, the Colorado Healthcare Information Dataset, contains an interactive tool for finding some data field, but needs data sets, for example their birth and death databases. Aggregated metrics, with relevant metadata, are needed. Cancer registry data sets needed.
- The American Association of State and Territorial Health Officials (ASTHO) is another resource for leadership, setting guidelines for assessment and performance improvement of their respective membership. Their survey results are proprietary and restricted use, which violates the public need for data transparency. They should select key metrics and make a data set available on their website.
- Guidelines at ASTHO provide helpful resources for Accreditation and Performance Improvement. Certainly data transparency is an essential pillar for stakeholder engagement and accountability.
- CDPHE, the Colorado Department of Public Health and Environment, has many opportunities, including CoHID, to improve data transparency, by creating a portal for the variety of data sets they collect. See Healthy Colorado.
- The Kaiser Family Foundation allows you to select a state. They should provide aggregated data sets for serious users.
- See also, an excellent example of data portal at California's OSHPD (Office of State Health Planning and Development)
- Metrics and Strategy from Social Progress Imperative, for states. See also, country comparisons.
It would be impressive to have this data in an Excel file, where users could see a compact list of measures, with quintiles. A pivot table gives users options to select from meta-data, or calculate.
See additional files below.
The governor of Colorado aspires to "the healthiest state in the country." Accountability requires Transparency and easy Accessibility. Stakeholders in Counties should be able to track recent metrics on at least an annual basis. See the Governor's Dashboard.
Health Expenditure Accounts are available at the National Level and State level. State Health Expenditures (SHE) provide basic expenses by payer types as well as category of expenditure. Reducing overall expenditures is imperative, not just shifting costs from one silo to another. See this article on "Wasted Health Spending" in Health Affairs, May 2018.
Peterson - Kaiser Health Tracker and the Kaiser Family Foundation provide a wealth of data points, mostly in single metric buckets. They could aggregate their metrics into common-sense data sets. See Utilization rates by state, below.
See the US Census and the Congressional Budget Office. Data sets from these entities could be standardized with Excel pivot tables.
It must also be recognized how important Education metrics are, for healthy kids. See dashboards at the Colorado Dept of Education.
Additional data sets are provided below for comparison of state metrics, from the Commonwealth Fund (CWF), Gallup, Hospital Satisfaction Scores (HCAPHS), American Health Rankings and the National Survey of Child Health (NSCH).
See the pdf extracts for the State of Colorado.
Metrics for comparison of US states, from the Social Progress Imperative
Google Sites
Report abuse