Skip to main content
100%

Fork of Data transformation health expenditure

✓ Published1🌍 Public
KKhatera Alizada
Last edited Feb 5, 2023
Created on Feb 5, 2023

This visualization explores personal health care spending by age, gender, and payer source, using data from the Centers for Medicare & Medicaid Services. It shows per capita expenditure differences between males and females across age groups (0-18, 19-64, 65+) for selected years from 2002 to 2014, addressing questions about spending by gender and population percentages. The code loads a CSV via `d3.csvParse` and `fetch`, then processes data with `d3.flatRollup` and `d3.sum` for aggregations. The current render displays raw JSON output via `d3.select` and `join`, with the full interactive visualization logic still under development.

AI-generated description

Personal health care (PHC) spending by type of good or service and by source of funding (private health insurance, Medicare, Medicaid, out-of-pocket, and all other payers and programs) is available for five age groups: 0-18, 19-44, 45-64, 65-84, and 85 and over and for males and females for selected years from 2002 through 2014.

Column name, description, type

  1. payer (medicaid, private health insurance, total, out-of-pocket, etc), categorical
  2. service( dental services, durable medical equipment, home health care, hospital care, nursing care facilities, Nursing Care Facilities and Continuing Care Retirement Communities, etc ), categorical
  3. age group ( 0-18, 19-64, 65 and up, total), ordinal
  4. gender( male, female, total), categorical
  5. year (2002 -2014), quantitative

Questions:

all Payers: Total Personal Health Care

  1. What is the difference between males and females per capita health spending in a given year?

Children (0-18)

  1. How does male children and female children total health care expenditure differ? Working Age Adults (19-64):
  2. Is there any difference between working-age (19-64) males and females per capita spending.

Older Adults (65 and older)

  1. What percentage of health care sepnding accounted for females 65 and older and what percentage of 65 and older population are females.

links:

https://www.cms.gov/Research-Statistics-Data-and-Systems/Statistics-Trends-and-Reports/NationalHealthExpendData/Age-and-Gender

https://catalog.data.gov/dataset/health-care-cost-growth/resource/8ef5a37b-3654-4bdb-980e-f000c8db4bf6

MIT Licensed

Similar vizzes