Provider identity

CMS PECOS Provider Ownership ("All Owners", PE-rollup layer)

medicare_silver.fact_provider_ownership·live·silver·Provider Enrollment & Ownership (PECOS)

Rows

814,242

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The CMS PECOS "All Owners" ownership records, unified across six facility types (hospital, hha, hospice, snf, fqhc, rhc).
2One row per facility↔owner edge: owner identity (individual or org name/DBA/address), percentage ownership, role, association date, and the owner-type flags that drive accountability/PE analysis — PRIVATE EQUITY, REIT, HOLDING COMPANY, INVESTMENT FIRM, CHAIN HOME OFFICE, PARENT COMPANY, TRUST/TRUSTEE, FOR/NON PROFIT, plus an indirect-chain "owned by another org" flag.
3THE ownership / private-equity-rollup intelligence layer (who really owns each facility).

Grain

Key	Grain
N/A	1One row per facility ↔ owner edge (enrollment_id × owner), partitioned by facility_type.

Columns (56)

Column	Type	Meaning
`facility_type`	string
`enrollment_id`	string
`associate_id`	string
`organization_name`	string
`owner_associate_id`	string
`owner_type`	string
`role_code`	string
`role_text`	string
`association_date`	string
`owner_first_name`	string
`owner_middle_name`	string
`owner_last_name`	string
`owner_title`	string
`owner_org_name`	string
`owner_dba_name`	string
`owner_address1`	string
`owner_address2`	string
`owner_city`	string
`owner_state`	string
`owner_zip`	string
`other_type_text`	string
`percentage_ownership`	double
`created_for_acquisition`	boolean
`is_corporation`	boolean
`is_llc`	boolean
`is_medical_provider`	boolean
`is_management_services`	boolean
`is_medical_staffing`	boolean
`is_holding_company`	boolean
`is_investment_firm`	boolean
`is_financial_institution`	boolean
`is_consulting_firm`	boolean
`is_for_profit`	boolean
`is_non_profit`	boolean
`is_private_equity`	boolean
`is_reit`	boolean
`is_chain_home_office`	boolean
`is_parent_company`	boolean
`is_trust_or_trustee`	boolean
`is_other_type`	boolean
`owned_by_another`	boolean
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

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

Item	Value
Typed tools that read it	resolve_provider
Identity key	`enrollment_id`
Join	`how_to_join(source_fqn="medicare_silver.fact_provider_ownership")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_provider_ownership
Company names	`organization_name` `owner_org_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Iceberg table medicare_silver.fact_provider_ownership, partitioned by facility_type; one All-Owners file fully restates its type (replace, idempotent by SHA-256). One runner ingests all six datasets.

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