Visualization Inventory

Production:

NEW PMPM Payments Commercial Payers (2016-2019)
NEW PMPM Payments Medicaid MCO Payers (2016-2019)
NEW PMPM Payments Medicaid FFS Payers (2016-2019)
NEW PMPM Payments Medicare Advantage Payers (2016-2018)
NEW PMPM Payments Medicare FFS Payers (2016-2018)
NEW PMPM Payments Dual Payers (2016-2018)

NEW PMPM RI Residents Commercial Payers (2016-2019)
NEW PMPM RI Residents Medicaid MCO Payers (2016-2019)
NEW PMPM RI Residents Medicaid FFS Payers (2016-2019)
NEW PMPM RI Residents Medicare Advantage Payers (2016-2018)
NEW PMPM RI Residents Medicare FFS Payers (2016-2018)
NEW PMPM RI Residents Dual Payers (2016-2018)

RI Pharmacy PMPM Percentages
Top Five Drug Classes Allowed Claims PMPM ($) by Payer Type
Top Five Drug Classes Allowed Claims PMPM ($) by Payer Type (no Other class)
Pharmacy: Spending, Utilization, and Price for Top 5 Commercial Drug Classes
Pharmacy: Spending, Utilization, and Price for Top 5 Medicaid Drug Classes
Medical Pharmacy: RI Top J Codes Percentages
Medical Pharmacy: Spending, Utilization, and Price: Commercial Pharmacy
Medical Pharmacy: Spending, Utilization, and Price: Medicaid MCO Pharmacy

Commercial Spending, Utilization, and Price: Episode Procedure By Code (2016-2018)

PMPM Payments by Payer Type
Total RI PMPM Spending By Age By Gender
HCCI RI Commercial Spending By Age (2018)
PMPM Payments Increase by Payer Type

PMPM Commercial Professional Services Payments (2016-2018)
PMPM Medicaid MCO Professional Services Payments (2016-2018)
PMPM Professional Services Payments (2016-2018)

PMPM Commercial Outpatient Services Payments (2016-2018)
PMPM Medicaid MCO Outpatient Services Payments (2016-2018)
PMPM Outpatient Payments (2016-2018)

Mean N of Insureds by Payer Type
Total RI Unique Enrollees By Age By Gender (2016-2018)
RI Residents Spending By Location (2016-2018)
Claims Risk Groups Analysis by Payer Type (2016-2018)

Total RI Risk-Adjusted Full Cohort by Provider (2018)
Total RI Risk-Adjusted Full Cohort Duals (2018)
Total RI Risk-Adjusted Diabetes Cohort by Provider (2018)
Total RI Risk-Adjusted Depression Cohort by Provider (2018)
Total RI Risk-Adjusted High Risk Cohort by Provider (2018)
RI Non-ACO PYPY v. All Provider Means (2018)
RI All Cohort Non-ACO Expense Categories PYPY v. All Provider Means (2018)
Total RI Full Cohort Selected Variables by Provider (2018)

RI Commercial Insured Allowed Claims PMPM ($) by Service Type
RI Commercial HOPD Insured Allowed Claims PMPM ($) by Service Type
RI Medicaid MCO Insured Allowed Claims PMPM ($) by Service Type
RI Medicaid MCO HOPD Insured Allowed Claims PMPM ($) by Service Type

Specialty (Professional Services) Analysis Honing in on Betos Data (used in Feb-26-2021 presentation)
0. PMPM Payments by Payer Type
A. Total RI Primary Care v. Non-Primary Care PMPM (2016-2018)
A1. Total RI Professional Services Categorized PMPM (2016-2018)
A2. Total RI Professional Services Categorized PMPM (2016-2018)
B1. Primary Care Categorized PMPM (2016-2018)
C1. Specialty Non-Procedural Medicine by Subcategory PMPM
C1. Specialty Non-Procedural Medicine by Subcategory PMPM TreeMap
C2. Unclassified Medical Oncology PMPM
C3. Unclassified Neurology PMPM
C4. Unclassified Rheumatology PMPM
D2. Specialty Internal Medicine by Subcategory PMPM
E1. Total Surgical Specialities PMPM
E3. Total Ophthalmology Categorized PMPM
E5. Total Orthopedic Surgery Categorized PMPM
F1. Total RI Other Medical Specialities PMPM PMPM
G1. Total RI Other Health Professional Specialities PMPM PMPM
G3. Total Nurse Practitioner Categorized PMPM
G5. Total Physician Assistant Categorized PMPM

Specialty (Professional Services) Analysis Honing in on Betos Data (used in Dec-14-2020 presentation)
0. PMPM Payments by Payer Type
1. Total Medical + Rx PMPM
2. Total Medical + Rx (Professional v. Non-Professional) PMPM
3. Total Professional Medical + Rx (Individual v. Organization) PMPM
4. Total Professional Medical + Rx (AOP v. Individual) PMPM
5. Specialty Individual by Subcategory PMPM
6. Specialty AOP by Subcategory PMPM
7. Specialty Physician Assistants & Advanced Practice Nurse by Subcategory PMPM
8. Specialty Behavioral Health & Social Service Providers by Subcategory PMPM
9. Specialty Internal Medicine Providers by Subcategory PMPM


KNOWN TO DOs:
  1. outpatient surgery analyses

Alpha (numbers placeholders only):

Red-Green replaced with Yellow-Purple for color-blindness improvement and to avoid cultural biases:
Claims Risk Groups Analysis for All Payers (red-green)

Dendrogram of Specialists:
Specialists Category and Count

Control References (numbers are placeholders only):

PMPM Professional Services Payments No Other Category (2016-2018)
PMPM Professional Services Payments (2014-2019)
PMPM Outpatient Payments (2014-2019)



Archives:

2016-2018 visualizations updated in production with 2019 numbers
PMPM Payments Commercial Payers (2016-2018)
PMPM Payments Medicaid MCO Payers (2016-2018)

Specialty Analysis from Alex (captures about half of the data so not used in Dec-14-2020 presentation)
1. PMPM Payments by Payer Type
2. Specialty PMPM by Payer (LOB)
3. Specialty Physician/Non-Physician by Year
4. Specialty Physician by Payer (LOB)
5. Specialty Physician/Non-Physician by Payer (LOB)
6a. Specialty Primary Care/Specialty by Payer (LOB)
6b. Specialty Family/Internal Medicine by Payer (LOB)
6c. Specialty Subgroups by Payer (LOB)
6d. Specialty Location by Payer (LOB)
6e. Surgical Subgroups by Payer (LOB) TreeMap
6f. Radiology Subgroups by Payer (LOB)
6g. Internal Medicine Subgroups by Payer (LOB)


(as presented on April 14, 2020 to Brown project group):
PMPM Payments by Payer Type (7 types)
PMPM Professional Services Payments (2016-2018, 6 types)
PMPM Outpatient Payments (2016-2018, 6 types)
Utilization v. Payments Analysis
Spending, Utilization, and Price by Payer Type

(as presented on February 21, 2020 to stakeholders meeting):