Raw schema
{
"type": "object",
"properties": {
"state": {
"type": "string",
"description": "Two-letter US state code, uppercase. The corpus currently covers California (`CA`) only β other state codes will return no rows."
},
"lob": {
"type": "string",
"description": "Substring match on product LOB family (state_product_type β falls back to serff_product_type). Common values: \"AUTO LIAB/PHYS DAMAGE\", \"WORKERS COMPENSATION\", \"OTHER LIABILITY\", \"MULTI-PERIL\", \"HOMEOWNERS MULTI-PERIL\", \"FIRE\", \"INLAND MARINE\". `lob=\"AUTO\"` returns all auto variants."
},
"company_name": {
"type": "string",
"description": "Substring (ILIKE) match on the leaf-filing carrier name. Use for \"Progressive programmes\" type queries."
},
"leaf_year": {
"type": "integer",
"description": "Exact leaf year (e.g. 2026). The leaf is the most recent filing in the chain β this is the programme's most recent revision. Mutually exclusive with `leaf_year_from`/`leaf_year_to`."
},
"leaf_year_from": {
"type": "integer",
"description": "Lower bound on leaf year, inclusive. Use for \"programmes whose most recent revision is on or after Y\"."
},
"leaf_year_to": {
"type": "integer",
"description": "Upper bound on leaf year, inclusive."
},
"root_type": {
"type": "string",
"description": "Substring match on the root filing's type. Common values: \"New Program\", \"Transferred Program\", \"Auto Class Plan\", \"Class Plan\", \"Manual\", \"Rate\". `root_type=\"New Program\"` returns programmes that trace back to a clean launch."
},
"leaf_likely_new": {
"type": "boolean",
"description": "True when the leaf itself is a substantive programme launch β its own filing carries the rate manual (root-type label AND β₯3MB files or β₯200KB embeds). High-confidence buildables."
},
"depth": {
"type": "integer",
"description": "Exact chain depth (number of predecessors). depth=0 means a standalone leaf with no chain."
},
"depth_from": {
"type": "integer",
"description": "Lower bound on chain depth, inclusive. Use for \"programmes with at least N predecessors\"."
},
"depth_to": {
"type": "integer",
"description": "Upper bound on chain depth, inclusive."
},
"chain_evidence_min": {
"type": "number",
"description": "Lower bound on `chain_evidence_score` (cosine similarity of leaf-filing chunks vs immediate-parent chunks, 0-1). Use to find products with strong content-overlap chains (e.g. `chain_evidence_min=0.7`). NULL scores are excluded by any min filter."
},
"chain_evidence_max": {
"type": "number",
"description": "Upper bound on `chain_evidence_score`. Use for \"low-evidence\" diagnostic queries."
},
"adoption_sources_any": {
"type": "array",
"items": {
"type": "string",
"enum": [
"bureau",
"me_too",
"proprietary",
"bureau_forms_only"
]
},
"description": "Match products whose `adoption_sources` array contains ANY of the listed labels (PostgreSQL `&&` overlap). E.g. `[\"bureau\"]` returns full-bureau-adoption products; `[\"me_too\",\"bureau_forms_only\"]` returns products that are me-too OR carry bureau forms. Valid labels: `bureau` (full bureau β loss costs + LCM), `me_too` (full adoption of another carrier), `proprietary` (carrier owns rates), `bureau_forms_only` (modifier β bureau forms with own/me-too rates)."
},
"leaf_serff": {
"type": "string",
"description": "Direct lookup by leaf SERFF id. Exact match. Same as filtering all products that this filing is the leaf of (max one row per leaf)."
},
"root_serff": {
"type": "string",
"description": "Filter to products rooted at this SERFF id. Returns all programmes whose chain terminates at the given root (typically many products share a bureau root)."
},
"all_revisions": {
"type": "boolean",
"description": "When true, returns every product including prior revisions of the same lineage cluster. Default false β only the latest revision per (company_name, state, lob) is returned. Use for time-series queries (e.g. \"how has Acme's CA auto rate manual evolved?\") or chain audits."
},
"limit": {
"type": "integer",
"description": "Max rows returned. Defaults to 25, capped at 100. Pair with `offset` to page."
},
"offset": {
"type": "integer",
"description": "Row offset for pagination. Defaults to 0."
}
}
}