States M1D Duals bridge: medicaid_mco_duals_bridge_v1

What it is

1. 1Medicaid product M1D (Duals bridge) of the States lane: dual-eligible integrated plan members by parent by state by month (D-SNP by integration level, MMP, PACE), to add or subtract duals in the M1 tie-out to company filings.
2. 2One row per report_month x state_code x parent x dual_product_type (DSNP_CO, DSNP_HIDE, DSNP_FIDE, MMP, OTHER_INTEGRATED_PACE, DSNP_UNCLASSIFIED).
3. 3Pick the product types before summing.
4. 4HIDE/FIDE before 2022-07 is inferred from each plan's first CMS-reported status (integration_status_basis backcast_from_first_cms_status), not reported.
5. 5MMP ends 2025-12 and converts into FIDE/HIDE in 2026-01: compare MMP + FIDE + HIDE across that boundary, never MMP alone. likely_in_medicaid_line is a default, not a filing fact: which company line reports duals is in docs/research/states/M1-SEC-COUNT-BASIS.csv (UNH's Medicaid line includes Community & State D-SNPs). state_code UNALLOCATED holds members with no county row (6 rows, 2019-12): include it in a national total, never in a state. members_weak_allocation is the part of members split by county-row count because every CPSC cell was suppressed (0.008%). canonical_parent_id follows the MA estate's mapping, which differs from vlada_curated.parent_crosswalk_v1 for about 14 organisations: join M1 on the same mapping.
6. 657 state(s): AK AL AR AS AZ CA CO CT DC DE FL GA GU HI IA ID IL IN KS KY LA MA MD ME MI MN MO MP MS MT NC ND NE NH NJ NM NV NY OH OK OR PA PR RI SC SD TN TX UNALLOCATED UT VA VI VT WA WI WV WY.

Grain

Columns (27)

Query it

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