# States W8 Parent book of business: parent_book_fl_v1

`vlada_curated.parent_book_fl_v1` · State programs · status partial · 418,680 rows

whole_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. One table per state (parent_book_<st>_v1, state_code). Filter line, segment and measure before summing; value_status and coverage_scope say what the value covers. 1 state(s): FL.

**Grain.** The parent book of business: every line a parent holds in the state, one measure per row, bound through the parent crosswalk. 418,680 rows (Athena, 2026-10-29). Period 2014-01-01 to 2026-12-31 (period_start).

| 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: `query_substrate` with `SELECT ... FROM vlada_curated.parent_book_fl_v1 WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.parent_book_fl_v1")` first.