State programs

States M5 RFP / procurement tracker: vw_medicaid_procurement_contract_runway

medicare_semantic.vw_medicaid_procurement_contract_runway·partial·semantic_view

Rows

220

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Medicaid product M5 (RFP / procurement tracker) of the States lane: Medicaid managed care procurements: each contract's award, go-live, base and option term and the months left, with current members.
2One row per state x program x procurement x winning entity. term_end_base and term_end_max are the contract's base and outside dates; extension_exercise_status says whether an option was used.
3Dates read 'not_published' where the state does not print them: that text is a finding, not a date. current_members is the latest enrollment month (current_enrollment_month), not the award.
443 state(s): AR AZ CA CO DC DE FL GA HI IA ID IL IN KS KY LA MA MD MI MO MS NC ND NE NH NJ NM NV NY OH OK OR PA PR RI SC TN TX UT VA WA WI WV.

Grain

Key	Grain
N/A	1Medicaid managed care procurements: each contract's award, go-live, base and option term and the months left, with current members. 2220 rows (Athena, 2026-10-29). 3Period 2014-01-01 to not_published (term_start).

Columns (38)

Column	Type	Meaning
`state`	string
`program`	string
`program_type`	string
`procurement_class`	string
`procurement_id`	string
`winning_legal_entity`	string
`parent_id`	string
`parent_name`	string
`award_outcome`	string
`award_source_url`	string
`go_live`	string
`go_live_source_url`	string
`term_start`	string
`term_end_base`	string
`term_end_max`	string
`term_source`	string
`term_source_page`	string
`term_scope_evidence`	string
`term_period_kind`	string
`option_schedule`	string
`ordinary_option_end`	string
`absolute_max_status`	string
`extension_exercise_status`	string
`extension_effective_date`	string
`extension_end`	string
`extension_source_url`	string
`extension_source_page`	string
`as_of_date`	string
`months_remaining_base`	string
`months_remaining_max`	string
`current_enrollment_month`	string
`current_members`	string
`current_enrollment_measure`	string
`enrollment_source_url`	string
`enrollment_query_id`	string
`enrollment_status`	string
`parent_unknown_reason`	string
`coverage_status`	varchar(16)

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_procurement_contract_runway")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_procurement_contract_runway (filter state)
Company names	`parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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