State programs

States W8 Parent book of business: parent_book_tx_v1

vlada_curated.parent_book_tx_v1·partial·silver

Rows

1,524,029

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1whole_state product W8 (Parent book of business) of the States lane: the parent book of business: every line a parent holds in the state, one measure per row, bound through the parent crosswalk.
2One table per state (parent_book_<st>_v1, state_code).
3Filter line, segment and measure before summing; value_status and coverage_scope say what the value covers.
41 state(s): TX.

Grain

Key	Grain
N/A	1The parent book of business: every line a parent holds in the state, one measure per row, bound through the parent crosswalk. 21,524,029 rows (Athena, 2026-10-29). 3Period 2014-01-01 to 2026-12-31 (period_start).

Columns (26)

Column	Type	Meaning
`state_code`	varchar(2)
`canonical_parent_id`	string
`canonical_parent_name`	string
`line`	varchar(8)
`segment`	string
`measure`	string
`period_start`	date
`period_end`	date
`geography_type`	string
`county_fips`	string
`source_entity_id`	string
`source_row_key`	string
`value`	double
`value_unit`	string
`value_status`	string
`coverage_scope`	string
`source_sha256`	string
`source_locator`	string
`crosswalk_row_key`	string
`source_parent_id`	string
`source_parent_name`	string
`parent_valid_from`	string
`parent_valid_to`	string
`as_of`	date
`facility_ccn`	string
`enrollment_total_authorized`	boolean

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="vlada_curated.parent_book_tx_v1")`
Raw door	Athena (read-only via query_substrate): vlada_curated.parent_book_tx_v1 (filter state_code)
Company names	`canonical_parent_name` `source_parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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