State programs

Medicaid managed-care procurement open and upcoming watch, sourced partial tracker

medicare_semantic.vw_medicaid_procurement_open_now·partial·semantic_view

Rows

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Officially sourced Medicaid plan and adjacent vendor procurements with the next published milestone. bidding_open_now distinguishes a verified open proposal window from an announced upcoming process.

Grain

Key	Grain
N/A	1One currently open or announced procurement per state and procurement ID; 222 rows in the 2026-10-28 snapshot.

Columns (14)

Column	Type	Meaning
`state`	string
`procurement_id`	string
`procurement_number`	string
`program`	string
`program_type`	string
`status`	string
`next_milestone_date`	string
`next_milestone`	string
`source_tier`	string
`source_url`	string
`source_sha256`	string
`as_of_date`	string
`coverage_status`	varchar(16)
`bidding_open_now`	boolean

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`state,procurement_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_procurement_open_now")`
Raw door	Athena: medicare_semantic.vw_medicaid_procurement_open_now
Note	Immutable source snapshot da4461050879ae4a9b84db8a10783487612afaaed624356841f4a8856212b426 in vlada_curated.fact_medicaid_procurement_open_now_da4461050879. View includes coverage_status=research_partial. Readback 22 rows, Athena df6408c5-7776-41ca-a9de-f755d66697d5. MCP exposure is a separate release.

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