# Care-site geography (CCN → CBSA/county/ZIP)

`vlada_curated.care_site_geo` · Provider identity · status live

Care-site geography: hospital_ccn → care_site_type, CBSA, county FIPS, ZIP, city, state with geo source + vintage. Places each care site in its market.

**Grain.** One row per care site (hospital_ccn) — its CBSA/county/ZIP geography.

| column | type | meaning |
|---|---|---|
| hospital_ccn | string |  |
| care_site_type | string |  |
| cbsa | string |  |
| county_fips | string |  |
| zip | string |  |
| city | string |  |
| state | string |  |
| geo_source | string |  |
| geo_vintage | string |  |

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