{"uid":"cap_eLVPJoJv-OBj756Vg-RrS","slug":"e-s-premium-vs-admitted-market-rate-filing-activity-querylines-90fdf6a9","name":"E&S Premium vs. Admitted-Market Rate Filing Activity (QueryLines)","description":"The leading-indicator join: E&S premium (with YoY growth) aligned period-by-period against admitted-market SERFF rate-filing activity (filing_count, avg_rate_change_pct, share_increasing, max_increase) on the shared coverage category. `lag` shifts the rate series back N periods to test the relationship. TX only; category join is annual, line=all also monthly/quarterly. Two aligned data families, not a prediction. $0.50/query. Free: /v1/rates/sample. Docs: https://api.querylines.com/openapi.json","url":"https://api.querylines.com/v1/rates/vs-premium","method":"GET","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method"],"properties":{"type":{"type":"string","const":"http"},"method":{"enum":["GET"],"type":"string"},"queryParams":{"type":"object","properties":{"to":{"type":"string","description":"YYYY-MM"},"lag":{"type":"integer","default":0,"description":"shift rate series back N periods"},"from":{"type":"string","description":"YYYY-MM"},"line":{"type":"string","description":"coverage category or all"},"state":{"type":"string","description":"state with rate data (CA, MS, TX, WA); default TX"},"granularity":{"enum":["month","quarter","year"],"type":"string","default":"year"}}}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":"object"}}}}},"responseSchema":{"type":"json","example":{"lag":1,"data":[{"period":"2023","premium":5828639373.87,"rate_period":"2022","filing_count":448,"max_increase":85.6,"premium_yoy_pct":39.16,"filings_with_pct":436,"share_increasing":0.5,"avg_rate_change_pct":5.67},{"period":"2024","premium":6513015839.17,"rate_period":"2023","filing_count":491,"max_increase":97,"premium_yoy_pct":11.74,"filings_with_pct":477,"share_increasing":0.541,"avg_rate_change_pct":7.72}],"line":"property","state":"TX","data_as_of":"2024","granularity":"year","rate_source":"Texas Department of Insurance - P&C Rate Filings (open data)","report_date":"2026-07-13","coverage_note":"Two aligned data families, not a prediction. Premium is E&S/surplus-lines; the rate side is admitted-market SERFF rate-filing activity, a leading indicator. Category join is TX annual; `lag` shifts the rate series.","premium_source":"SLTX Year to Year Comparison by Line of Business, 2025"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.5","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.5/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.5","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.5","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_ptKKeUAs8f_cgMDmmONAg","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.5","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Aligns surplus-lines (E&S) premium with YoY growth against SERFF admitted-market rate-filing activity period-by-period by coverage category, with optional lag shifting to test lead/lag relationships.","exampleAgentPrompt":"Pull the E&S premium vs. admitted-market SERFF rate filing comparison for Texas homeowners coverage, yearly granularity from 2018-01 to 2023-12, and shift the rate series back 1 year so I can see if E&S growth leads admitted-market rate increases.","exampleUseCases":null,"resultDescription":"Returns two aligned data series per period: E&S premium figures with YoY growth rates, and admitted-market SERFF rate filing metrics (filing count, average rate change %, share of filings with increasing rates, max increase), joined on the shared coverage category and optionally lag-shifted for lead/lag analysis.","failureModes":["Invalid or unsupported state code returns error (only TX fully supported, CA/MS/WA limited)","Coverage line not found in joined dataset returns empty or partial results","Date range outside available data returns no rows","Unsupported granularity for requested line (monthly/quarterly only available for line=all in TX)","Missing required parameters returns 400 validation error","Payment not processed (x402) returns 402 Payment Required"],"whenToPreferThis":"Use this endpoint when you need to study the relationship between the E&S (surplus lines) insurance market and admitted-market rate-filing behavior — especially to test whether E&S premium growth is a leading indicator for admitted-market hardening. Prefer this over the raw rates or raw E&S endpoints when you specifically need both data families aligned in a single response with lag-shift capability.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T06:42:19.717Z","isFirstParty":false}