# County intelligence aggregate (supply by class)

`vlada_curated.agg_county_intelligence` · Curated datasets · status live

County-fleet serving aggregate: per county and care-site class, the verified site_count, tier, ownership_resolved and ccn_linked flags. Backs the county_intelligence / county_expert supply answers.

**Grain.** One row per (county_fips, care_site_class) — verified site count + ownership/ccn flags.

| column | type | meaning |
|---|---|---|
| county_fips | string |  |
| county_name | string |  |
| state_code | string |  |
| tier | int |  |
| care_site_class | string |  |
| site_count | bigint |  |
| ownership_resolved | bigint |  |
| ccn_linked | bigint |  |
| vintage | date |  |

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