Dashboard 1: Patient visit count of population
We explore the distribution of visit count across sections of the overall patient population in AZ. The bottom left graph shows the map of Arizona with counties colored based on average median income. Clicking or selecting regions, will filter the other visualizations for those regions. The other two graphs in this dashboard show the distribution of patient visit count across the 17 body system categories (Circulatory system, digestive systems, musculoskeletal system, neoplasms, etc) and patient age groups (0-9 years, 10-19 years, 20-29 years, etc). The visualizations shows that a majority of Arizonans were affected by Circulatory and Musculoskeletal System disorders. For a majority of disorders, over half of the affected gender was female. A majority of diseases affected those who identified as white in most regions. An exception to this was Apache county where the most affected ethnicity was American Indian, due in part to variability in ethnic backgrounds based on various counties across Arizona.
Readers are urged to use the filters and click on the interactive (linked) visualizations to explore other patterns of visit counts across different categories of age groups, body systems, time periods, counties, gender and ethnicity.
Dashboard 2: Average visit costs of population
This dashboard presents the variability in average patient costs of visits across diseases classified under different body systems. We further include information on payer type using color codes to compare visit costs across different payer types such as medicaid, health maintenance organizations (HMO), preferred provider organization (PPO), medicare, etc.
Visits with congenital anomalies related diagnoses have the highest costs followed by neoplasm and circulatory system related visits. Proportion of average cost expenditure by Arizona Health Care Cost Containment System (AHCCCS) Medicaid is higher than other payers for congenital anomalies related visits, whereas PPOs spend on average for parasitic and infectious disease related visits. Commercial indemnity plans have higher average spending on visits related to injury/poisoning and skin problems related visits. These patterns could be due to different patient segments (differentiated by age groups, income-levels, education levels, occupations, etc) having access to different insurance options and hence different payer types. We urge the reader to use the filters and click on the interactive (linked) visualizations to explore average visit cost patterns across different values of filter variables.
Dashboard 3: Visit count and cost across population
In this dashboard, we explore patterns in visit count and average visit cost simultaneously across two variables - Age groups and discharge status. Discharge statuses have been grouped into four categories - discharged home, transferred to another institution, expired and left against medical advice. Visit cost where patient has expired is 1.5 times higher than visit costs in other discharge status categories for all time periods. Across all time periods, the pattern of patient visit counts is fairly consistent across age groups; admission is highest for 60-69 and 70-79 age groups categories. The average cost for patients in age group 0-9 is consistently increasing with time, from $68,211 in the first half of 2012 to $100,689 in the second half of 2016. There is a data input issue for the second half of 2016 for discharge status and hence this particular set of observations can be ignored. The rate of increase in average cost and total patient visits has steadily increased from 2012-01 (i.e. first half of 2012) to 2016-02 (i.e. second half of 2016).
Readers are urged to use the filters and click on the interactive (linked) visualizations to explore other patterns across different values of filter variables.
Photo of Tucson sunset courtesy Pixabay.