Premium x rate-activity join: E&S premium vs admitted-market rate filings, one axis
Joins E&S/surplus-lines premium (with YoY growth) against admitted-market SERFF rate-filing activity on the shared coverage category (coverage_lines.category == serff_rate_filings.coverage_category), period-aligned and optionally lag-shifted. The 0013 rate dataset exists as a leading indicator of E&S growth; this endpoint surfaces that relationship WITHOUT asserting it -- it returns both families aligned and lets you shift the rate series with lag. Rate-filing data covers CA, MS, TX, and WA; the join is most useful where the state also has E&S premium (CA has monthly premium, the richest join; TX premium by coverage category is annual; WA premium is annual), so the category-level join (line=<category>) is year-granularity; the all-lines join (line=all) is also available monthly/quarterly (rate activity summed across categories). $0.50 per query.
Request
- Base URL: https://api.querylines.com
- URL: https://api.querylines.com/v1/rates/vs-premium
- Auth: none declared
Query parameters
State with rate-filing data (CA, MS, TX, WA); default TX.
coverage_category (e.g. property, liability) or all. A specific category requires granularity=year for TX.
premium lower bound, YYYY-MM.
premium upper bound, YYYY-MM.
Shift the rate series back N periods relative to premium (lag=1 = prior period's rate activity).
Pin premium restatement to a report_date, YYYY-MM-DD.
Response
Premium points, each aligned to the rate-activity bucket at period - lag.
Changes
No recorded changes to this operation across all 1 revision of this API.