Provider identity

Care-Site Spine (NPI/CCN-keyed facility identity)

vlada_curated.dim_care_site·live·dim·Vlada Provider & Facility Identity

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The care-site identity spine: care_site_id with NPI, CCN, legal name, NPPES taxonomy, care_site_class, tier, entity type, and geography (geo_id + county FIPS).
2The unifying facility identity the county/care-site fleet and pricing tools resolve against.

Grain

Key	Grain
N/A	1One row per care site (care_site_id) — NPI/CCN, class, tier, geography.

Columns (30)

Column	Type	Meaning
`care_site_id`	string
`npi`	string
`ccn`	string
`legal_name`	string
`nppes_taxonomy_code`	string
`care_site_class`	string
`tier`	int
`entity_type`	int
`city`	string
`state_code`	string
`zip_code`	string
`geo_id`	string
`county_name`	string
`county_fips`	string
`cbsa_code`	string
`in_hospital_registry`	boolean
`source`	string
`nppes_version`	string
`confidence_basis`	string
`needs_validation`	boolean
`build_scope`	string
`vintage`	date
`parent_system`	string
`parent_system_type`	string
`ownership_type`	string
`validation_status`	string
`validated_at`	date
`enrichment_note`	string
`canonical_site_id`	string
`routing_bucket`	string

Query it

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

Item	Value
Typed tools that read it	state_expert
Identity key	`care_site_id`
Join	`how_to_join(source_fqn="vlada_curated.dim_care_site")`
Raw door	Athena (read-only via query_substrate): vlada_curated.dim_care_site

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