VladaOmega
Sign inStart free
Curated datasets

County intelligence aggregate (supply by class)

vlada_curated.agg_county_intelligence·live·mart
Rows
N/A
Columns
9
History
N/A
Card
nocolumns only
Typed tools
0

What it is

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

Grain

KeyGrain
N/A
  1. 1One row per (county_fips, care_site_class) — verified site count + ownership/ccn flags.

Columns (9)

ColumnTypeMeaning
county_fipsstring
county_namestring
state_codestring
tierint
care_site_classstring
site_countbigint
ownership_resolvedbigint
ccn_linkedbigint
vintagedate

Query it

describe_data_source(source_fqn="vlada_curated.agg_county_intelligence")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.agg_county_intelligence WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itnone; raw SQL
Identity keycounty_fips
Joinhow_to_join(source_fqn="vlada_curated.agg_county_intelligence")
Raw doorAthena (read-only via query_substrate): vlada_curated.agg_county_intelligence

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