Medicare Advantage, Part D, Medicaid

MA network intelligence: NUCC taxonomy -> normalized specialty (CMS MA network-adequacy types)

medicare_silver.dim_network_specialty_v1·partial·dim

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The specialty vocabulary of the network layer: each NPPES taxonomy code mapped to one specialty, CMS's MA network-adequacy provider specialty types (30) where the code belongs to one, a plain group otherwise.
2The mapping is Vlada's (tools/data_tracker/network_specialty_map.py), by NUCC classification and specialization, first match wins.

Grain

Key	Grain
N/A	1One row per NUCC taxonomy code (884, NUCC v26.0): provider_class, specialty, adequacy_type, map_version.

Columns (8)

Column	Type	Meaning
`taxonomy_code`	string
`nucc_grouping`	string
`nucc_classification`	string
`nucc_specialization`	string
`provider_class`	string
`specialty`	string
`adequacy_type`	boolean
`map_version`	string

Query it

describe_data_source(source_fqn="medicare_silver.dim_network_specialty_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.dim_network_specialty_v1 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`taxonomy_code`
Join	`how_to_join(source_fqn="medicare_silver.dim_network_specialty_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.dim_network_specialty_v1 (join taxonomy_code = vlada_curated.dim_provider.taxonomy_code_1)

This page as markdown: /docs-md/data/medicare_silver_dim_network_specialty_v1.md · every page in one file: /llms-full.txt