skin-subs: geographic analysis — state, MSA, MAC jurisdiction variation #240
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Objective
Map geographic variation in skin substitute utilization and spending to identify soft/hard targets.
Tasks
skin_subs.geographic_summary,skin_subs.mac_lcd_comparisonClosing. All tasks complete.
Tables:
skin_subs.geographic_summary(16 rows) — per-state: claim lines, benes, providers, total paid, paid/bene, paid/provider, setting mix (% office/HOPD/ASC/SNF), specialty mix (% podiatry/dermatology), MAC jurisdictionskin_subs.mac_summary(8 rows) — per-MAC rollup: states, claim lines, benes, providers, total paid, avg paid/bene, avg % office, avg % podiatryKey findings:
MAC jurisdictions mapped: Novitas, First Coast, Palmetto, CGS, WPS, NGS, Noridian
Script:
dev/scripts/build_skin_subs_geo_setting.pyCommit:
88025d5