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

`vlada_curated.dim_care_site` · Provider identity · status live

The 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). The unifying facility identity the county/care-site fleet and pricing tools resolve against.

**Grain.** One row per care site (care_site_id) — NPI/CCN, class, tier, geography.

| 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 |  |

Tools that read it: state_expert

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