State programs

New York Medicaid parent enrollment by native product, September 2026

medicare_silver.ny_medicaid_parent_native_product_component_202609_v1·partial·silver

Rows

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Published NY Medicaid managed-care parent components for MAP, MLTC Partial, and MLTC PACE at the publisher's September 2026 report month.
2Values are reported component sums, not unduplicated people; the three product buckets must remain separate.

Grain

Key	Grain
N/A	1One raw program, native product bucket, and effective-dated ultimate parent in NY September 2026; 233 unique groups from 152 exact publisher observation keys.

Columns (20)

Column	Type	Meaning
`state_code`	string
`report_month`	string
`raw_program`	string
`native_product_bucket`	string
`parent_id`	string
`reported_component_sum`	bigint
`source_row_count`	bigint
`source_key_set_sha256`	string
`value_unit`	string
`source_time_basis`	string
`publication_status`	string
`dated_edge_basis`	string
`raw_program_publisher_control`	bigint
`control_relation`	string
`source_url`	string
`source_sha256`	string
`bronze_object_key`	string
`s3_version_id`	string
`lineage_object_sha256`	string
`accepted_candidate_receipt_sha256`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`state_code,report_month,raw_program,native_product_bucket,parent_id`
Join	`how_to_join(source_fqn="medicare_silver.ny_medicaid_parent_native_product_component_202609_v1")`
Raw door	Governed query_substrate and /v1/studio/medicaid-mco/parent-native-products; pin state_code=NY and report_month=2026-09.
Note	Immutable content-addressed Parquet, Glue version 0, 33 groups and 152 unique source keys. The four ElderServe source rows use the accepted 2025-09-01 CareSource owning-org edges; no backcast.

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