Custom Query

Run precise SQL queries directly against the Insuraviews database for highly customized analysis.

What it does: Provides direct database access for users who need specific data combinations not available through standard search and reporting tools.

Who should use this:

• Data analysts and actuaries comfortable with SQL

• Users needing complex data relationships

• Teams requiring specific data formats for internal systems

• Advanced users who want maximum flexibility in data extraction

How to use:

1. Access "Custom Query"

2. Write Your Query: Use SQL syntax to specify exactly what data you need

   • Access tables for filings, companies, states, rate changes, and more

   • Join multiple data sources for complex analysis

   • Apply custom filters and calculations

3. Test and Validate: Preview results before running full query

4. Execute Query: Run against live database

5. Export Results: Download in your preferred format (CSV, Excel, JSON)

Example Query Types:

• Complex Rate Analysis: "Show me all auto rate increases >10% in California and Texas from companies with >$1B premium, including their loss ratios"

• Temporal Patterns: "Compare rate filing timing patterns between Q1 and Q4 over the last 3 years"

• Regulatory Trends: "Identify states with fastest approval times for homeowners rate increases"

• Market Positioning: "Calculate market share changes based on rate competitiveness by territory"

Database Schema Access:

• Complete documentation of available tables and fields

• Data dictionary explaining field definitions and relationships

Safety Features:

• Read-only access ensures data integrity

• Query timeout limits prevent system overload

• Result size limits for manageable outputs

• Query history for reproducing previous analysis

Custom Query