# Medicaid managed-care subcontract and delegated-function observations

`medicare_silver.org_subcontract` · State programs · status partial · 506 rows

Source-name subcontract observations from California, Georgia, Illinois, and Minnesota, including 282 additional Minnesota December 2018 delegation-form name cells with raw function and program flags. Evidence URL/SHA, date basis, and reported function are preserved. Legal identities and member attribution remain unresolved.

**Grain.** One source-reported prime-to-subcontractor observation per subcontract_id; source_relationship_basis separates functional delegation reports from Georgia's thresholded business transactions.

| column | type | meaning |
|---|---|---|
| subcontract_id | string |  |
| state_code | string |  |
| prime_legal_entity_id | string |  |
| prime_name | string |  |
| subcontractor_legal_entity_id | string |  |
| subcontractor_name | string |  |
| subcontractor_parent_id | string |  |
| valid_from | string |  |
| valid_to | string |  |
| date_basis | string |  |
| members | string |  |
| evidence | string |  |
| confidence | string |  |
| note | string |  |
| county_or_region | string |  |
| program_type | string |  |
| function | string |  |
| members_as_of | string |  |
| evidence_sha256 | string |  |
| prime_legal_entity_candidate_id | string |  |
| subcontractor_legal_entity_candidate_id | string |  |
| subcontractor_parent_candidate_id | string |  |
| prime_identity_status | string |  |
| subcontractor_identity_status | string |  |
| parent_identity_status | string |  |
| identity_status | string |  |
| identity_confidence | string |  |
| source_relationship_basis | string |  |
| source_report_year | string |  |
| reported_function | string |  |
| source_cell_group_id | string |  |
| source_cell_member_count | string |  |
| source_actor_class | string |  |
| medicaid_specificity | string |  |
| source_review_tier | string |  |
| source_csv_sha256 | string |  |
| spine_review_status | string |  |

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