# States M1D Duals bridge: medicaid_mco_duals_bridge_v1

`medicare_silver.medicaid_mco_duals_bridge_v1` · State programs · status partial · 253,984 rows

Medicaid 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. One 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). Pick the product types before summing. HIDE/FIDE before 2022-07 is inferred from each plan's first CMS-reported status (integration_status_basis backcast_from_first_cms_status), not reported. MMP 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. 57 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.** 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. 253,984 rows (Athena, 2026-10-31). Period 2019-01-01 to 2026-10-01 (report_month).

| column | type | meaning |
|---|---|---|
| report_month | date |  |
| report_year | bigint |  |
| state_code | string |  |
| canonical_parent_id | string |  |
| canonical_parent_name | string |  |
| parent_of_record | string |  |
| reporting_group | varchar(5) |  |
| dual_product_type | varchar(21) |  |
| likely_in_medicaid_line | boolean |  |
| integration_status_basis | string |  |
| members | double |  |
| members_rounded | bigint |  |
| members_upper_bound | double |  |
| members_applicable_integrated_plan | double |  |
| members_partial_dual_only_plan | double |  |
| plan_or_contract_count | bigint |  |
| contract_count | bigint |  |
| contract_ids | string |  |
| suppressed_source_cells | bigint |  |
| state_allocation_method | string |  |
| members_weak_allocation | double |  |
| count_source | string |  |
| count_source_sha256 | string |  |
| count_source_url | string |  |
| state_split_source_sha256 | string |  |
| state_split_source_url | string |  |
| built_at_utc | timestamp |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.medicaid_mco_duals_bridge_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.medicaid_mco_duals_bridge_v1")` first.