Healthcare23 cols · 103 rows
This dataset provides comprehensive, structured information on provider referrals and care coordination, including referring and specialist provider details, patient information, referral reasons, authorization status, appointment scheduling, and closed-loop communication. It enables healthcare organizations to analyze referral patterns, optimize network utilization, and improve care continuity and outcomes.
| referring_provider_name | specialist_provider_name | patient_name |
|---|
| Dr. Lisa Chan | Dr. Alan Brooks | John Morris |
| Dr. Michael Stewart | Dr. Priya Desai | Emily Fox |
| Dr. Sandra Lee | Dr. Tom Sanders | Lucas Kim |
referral_idreferral_datereferring_provider_id+17 more
Healthcare21 cols · 100 rows
This dataset provides comprehensive scorecards for healthcare providers, detailing quality metrics such as HEDIS measures, patient satisfaction, cost efficiency, clinical outcomes, MIPS scores, and value-based payment performance. It enables robust benchmarking, network management, and supports value-based care initiatives by offering granular, period-specific insights into provider performance.
| provider_name | provider_type | hedis_measure_name |
|---|
| Maple Health Partners | PCP | Comprehensive Diabetes Care |
| Downtown Cardiology Group | Specialist | Heart Failure Management |
| Cedar Grove Pediatrics | Clinic | Childhood Immunization |
provider_idnetwork_idhedis_measure_id+15 more
Healthcare16 cols · 100 rows
This dataset provides a comprehensive view of healthcare provider contracts with payers, detailing contracted rates, payment terms, credentialing status, effective and expiration dates, participation status, and network tier assignments. It enables analysis of provider-payer relationships, reimbursement trends, and network management for claims processing and compliance.
| provider_name | payer_name | credentialing_status |
|---|
| Northside Family Medicine | Blue Ridge Health Plan | active |
| Uptown Pediatrics | Sunstate Insurance | active |
| Westside Cardiology Group | HealthFirst | active |
contract_idprovider_idprovider_npi+10 more
Healthcare39 cols · 100 rows
This dataset provides a comprehensive record of hospital medical staff credentialing and privileging, including education, training, certifications, licenses, DEA registration, malpractice insurance, clinical privileges, and reappointment status. It enables hospitals to efficiently manage provider compliance, credential verification, and privileging workflows, supporting regulatory and patient safety requirements.
| first_name | last_name | middle_name |
|---|
| Emily | Nguyen | A |
| James | Rodriguez | L |
| Priya | Singh | – |
provider_iddate_of_birthgender+33 more
Healthcare27 cols · 100 rows
This dataset provides a comprehensive registry of healthcare providers, including detailed demographic, credential, specialty, and practice location information mapped to the National Provider Identifier (NPI) system. It enables robust provider lookup, credential verification, and network management for healthcare organizations, payers, and regulatory agencies.
| provider_last_name | provider_first_name | provider_middle_name |
|---|
| Smith | John | A |
| CareWell Clinic | – | – |
| Johnson | Emily | Rose |
npiprovider_suffixprovider_credential+21 more
Logistics22 cols · 100 rows
This dataset provides a detailed view of pharmaceutical supply chain operations, including drug inventory levels, wholesaler transactions, shortage events, backorders, alternative therapy recommendations, and FDA shortage notifications. It enables robust analysis of supply chain resilience, regulatory compliance, and clinical impact, supporting decision-making for healthcare providers, manufacturers, and policymakers.
| drug_name | manufacturer_name | wholesaler_name |
|---|
| Amoxicillin | PharmaGen | MedSupply Inc. |
| Metformin | HealthWorks | PharmaDirect |
| Ibuprofen | WellPharm | MedSupply Inc. |
drug_idndc_codewholesaler_id+16 more
Healthcare18 cols · 100 rows
This dataset provides comprehensive records of drug utilization reviews, capturing findings such as polypharmacy, inappropriate prescribing, Beers Criteria violations, and HEDIS pharmacy measure compliance. It also tracks quality improvement interventions and links each review to patient and prescriber details, enabling robust analysis of medication safety and prescribing practices. Ideal for healthcare quality improvement, regulatory reporting, and clinical research.
| polypharmacy_flag | inappropriate_prescribing_flag | intervention_type |
|---|
| true | false | medication change |
| false | false | – |
| true | true | deprescribing |
review_idpatient_idreview_date+12 more
Healthcare26 cols · 100 rows
This dataset provides a comprehensive record of Medication Therapy Management (MTM) programs, including patient demographics, chronic conditions, pharmacist interventions, medication reviews, action plans, and Medicare eligibility. It enables detailed analysis of therapy optimization, intervention effectiveness, and compliance with chronic disease management protocols in healthcare settings.
| patient_first_name | patient_last_name | mtm_eligibility_status |
|---|
| James | Miller | eligible |
| Patricia | Smith | eligible |
| Robert | Johnson | pending |
mtm_program_idpatient_idpatient_date_of_birth+20 more
Healthcare32 cols · 100 rows
This dataset provides a detailed record of specialty pharmacy management for high-cost medications, including patient demographics, medication types, prescriber details, prior authorization status, financial assistance enrollment, and adherence support. It enables analysis of treatment patterns, cost management, and patient outcomes for biologic and oncology therapies, supporting both clinical and operational decision-making.
| patient_first_name | patient_last_name | medication_name |
|---|
| James | Anderson | Humira |
| Maria | Gutierrez | Keytruda |
| Grace | Choi | Remicade |
patient_idpatient_date_of_birthpatient_gender+26 more
Healthcare29 cols · 100 rows
This dataset provides comprehensive records of controlled substance prescriptions, including DEA schedules, opioid MME calculations, PDMP query results, and regulatory prescribing limits. It enables detailed analysis of opioid stewardship, prescriber behavior, and compliance with controlled substance regulations, supporting public health and risk mitigation efforts.
| prescriber_name | drug_name | prescribing_limit_type |
|---|
| Dr. Jennifer Smith | Oxycodone | none |
| Dr. Michael Lee | Hydrocodone/Acetaminophen | days supply |
| Dr. Alice Kim | Morphine | MME |
prescription_idprescriber_idprescriber_dea_number+23 more
Healthcare25 cols · 105 rows
This dataset provides a detailed record of clinical decision support alerts related to drug interactions, allergies, duplicate therapies, dosing checks, and renal dosing, including prescriber responses and patient context. It enables robust analysis of medication safety, alert effectiveness, and prescriber behavior, supporting quality improvement and clinical risk management in healthcare settings.
| alert_type | drug_1_name | drug_2_name |
|---|
| drug-drug interaction | Warfarin | Amiodarone |
| dose range check | Metformin | – |
| drug-allergy contraindication | Penicillin | – |
alert_idalert_severityalert_message+19 more
Healthcare19 cols · 100 rows
This dataset provides detailed records of medication reconciliation during patient care transitions, capturing home, admission, and discharge medication lists, discrepancy identification and resolution, and clinician/facility details. It enables robust patient safety monitoring, process optimization, and compliance reporting in healthcare settings.
| patient_first_name | patient_last_name | care_transition_type |
|---|
| James | Holloway | admission |
| Maria | Castro | discharge |
| Ethan | Morris | transfer |
record_idpatient_iddate_of_birth+13 more
Insurance17 cols · 100 rows
This dataset provides a comprehensive mapping of insurance formularies to covered drugs, detailing coverage tiers, prior authorization and step therapy requirements, quantity limits, and specialty drug management programs. It is ideal for pharmacy benefit analysis, formulary comparison, and regulatory reporting, supporting informed decision-making for healthcare providers, payers, and patients.
| formulary_name | insurance_plan_name | drug_name |
|---|
| PrimeCare Select 2024 | PrimeCare Silver PPO | Atorvastatin Calcium |
| PrimeCare Select 2024 | PrimeCare Silver PPO | Metformin HCL |
| PrimeCare Select 2024 | PrimeCare Silver PPO | Lisinopril |
formulary_idinsurance_plan_iddrug_id+11 more
Healthcare21 cols · 130 rows
This dataset provides detailed records of pharmacy medication dispensing events, including fill dates, drug codes, quantities, days supply, prescriber and pharmacy information, and prescription claim statuses. It enables comprehensive tracking of patient medication adherence, refill patterns, and pharmacy operations, making it ideal for clinical research, healthcare analytics, and operational monitoring.
| medication_name | claim_status | prescriber_name |
|---|
| Lisinopril 10mg Tablet | paid | James Carter, MD |
| Metformin 500mg Tablet | paid | Patricia Allen, DO |
| Atorvastatin 20mg Tablet | paid | Kenneth Smith, NP |
dispense_idpharmacy_idpatient_id+15 more
Healthcare24 cols · 120 rows
This dataset provides comprehensive electronic prescription records, including detailed medication information, standardized RxNorm codes, prescriber and pharmacy identifiers, and SCRIPT message tracking for order and dispensing events. It enables robust analysis of prescribing patterns, medication safety, and pharmacy workflow optimization, supporting interoperability across healthcare systems.
| drug_name | prescriber_name | pharmacy_name |
|---|
| Simvastatin | Dr. Richard Adams | CVS Pharmacy |
| Lisinopril | Dr. Susan Miller | Walgreens Pharmacy |
| Metformin | Dr. Alan Choi | Walmart Pharmacy |
prescription_idpatient_idrxnorm_code+18 more
Healthcare17 cols · 105 rows
This dataset provides comprehensive protein expression profiles, mass spectrometry results, post-translational modification details, and protein-protein interaction data, enabling robust biomarker discovery for disease research. It is designed for integrative analysis in proteomics, supporting both experimental and computational approaches to uncover disease mechanisms and candidate biomarkers.
| protein_name | disease_status | post_translational_modification_type |
|---|
| Serum albumin | healthy | phosphorylation |
| Alpha-1-antitrypsin | disease | glycosylation |
| Vimentin | control | – |
protein_idgene_symbolorganism+11 more
Healthcare19 cols · 110 rows
This dataset provides comprehensive RNA sequencing profiles, including gene expression quantification, differential expression analysis, pathway associations, fusion transcript detection, and molecular subtyping for each biological sample. It is designed for advanced research and clinical diagnostics, enabling biomarker discovery, disease classification, and pathway-driven insights in genomics.
| sample_type | differential_expression_status | pathway_name |
|---|
| tissue | upregulated | DNA Repair Pathway |
| blood | not_significant | B cell receptor signaling |
| cell_line | upregulated | MAPK signaling pathway |
sample_idcollection_dategene_symbol+13 more
Healthcare17 cols · 100 rows
This dataset provides comprehensive records of liquid biopsy samples and circulating tumor DNA (ctDNA) analysis for cancer patients, including molecular findings, treatment details, and clinical outcomes. It enables longitudinal monitoring of minimal residual disease, treatment response, and resistance mutations, supporting research and clinical decision-making in precision oncology.
| cancer_type | treatment_type | laboratory_name |
|---|
| lung | chemotherapy | GenomicDx Labs |
| breast | immunotherapy | Precision Oncology |
| colorectal | targeted therapy | OncoSeq Diagnostics |
sample_idpatient_idcollection_date+11 more
Healthcare26 cols · 100 rows
This dataset provides detailed records of hereditary cancer syndrome genetic testing, including patient demographics, test results for key genes (such as BRCA1/2, Lynch syndrome, TP53, PTEN), risk assessments, and recommendations for cascade testing. It enables robust analysis of genetic risk, variant prevalence, and clinical follow-up, supporting precision medicine and family-based cancer prevention strategies.
| patient_first_name | patient_last_name | test_type |
|---|
| Jennifer | Miller | BRCA1/2 |
| Samuel | Nguyen | Lynch syndrome |
| Maria | Santos | BRCA1/2 |
test_idpatient_idpatient_date_of_birth+20 more
Healthcare15 cols · 100 rows
This dataset provides detailed pharmacogenomic testing results, including CYP450 enzyme variants, drug transporter genes, HLA alleles, and other key drug metabolism genes, along with clinical implications for drug selection and dosing. It is ideal for precision medicine initiatives, clinical decision support, and research into gene-drug interactions.
| variant_name | genotype | phenotype |
|---|
| *4 | homozygous | poor metabolizer |
| *3A | heterozygous | intermediate metabolizer |
| *2A | heterozygous | intermediate metabolizer |
test_idpatient_idtest_date+9 more
Healthcare14 cols · 100 rows
This dataset provides comprehensive cancer genomic profiling results, detailing somatic mutations, driver genes, actionable mutations, tumor mutational burden (TMB), microsatellite instability (MSI), and therapeutic targets for each tumor sample. It is ideal for translational research, biomarker discovery, and precision oncology applications, enabling advanced analytics and clinical decision support.
| tumor_type | msi_status | genomic_platform |
|---|
| lung adenocarcinoma | MSS | Illumina NovaSeq |
| breast carcinoma | MSS | Ion Torrent |
| colorectal adenocarcinoma | MSI-High | Illumina HiSeq |
sample_idpatient_idcollection_date+8 more
Healthcare21 cols · 150 rows
This dataset provides comprehensive whole genome sequencing variant data, including detailed records of SNPs, indels, structural variants, and copy number variations, along with rich annotation, pathogenicity predictions, and population frequency metrics. It is ideal for precision medicine, enabling genetic analysis, clinical interpretation, and population studies. The schema supports robust data integration for research, diagnostics, and personalized healthcare applications.
| reference_allele | alternate_allele | variant_type |
|---|
| A | T | SNP |
| G | C | SNP |
| C | G | indel |
sample_idvariant_idchromosome+15 more
Healthcare28 cols · 100 rows
This dataset provides a comprehensive registry of reportable infectious disease cases, capturing patient demographics, disease details, pathogen identification, antibiotic resistance, outbreak events, contact tracing, and public health reporting. It enables robust epidemiological analysis, outbreak management, and supports public health decision-making at local, regional, and national levels.
| disease_name | reporting_facility_name | outbreak_status |
|---|
| Influenza | Midwest Medical Center | not_applicable |
| Measles | Children's Hospital Denver | confirmed |
| Legionellosis | Seattle General Hospital | suspected |
case_idpatient_idpatient_age+22 more
Healthcare24 cols · 100 rows
This dataset provides a comprehensive record of orthopedic joint replacement surgeries, including implant details, manufacturer information, surgical approach, complications, revisions, patient-reported outcomes, and implant survival. It enables robust analysis of implant performance, surgical quality, and patient outcomes, supporting continuous improvement in orthopedic care and device safety.
| manufacturer_name | implant_type | complication_type |
|---|
| Zimmer Biomet | hip | – |
| DePuy Synthes | knee | infection |
| Smith & Nephew | shoulder | – |
registry_idpatient_idimplant_id+18 more
Healthcare30 cols · 100 rows
This dataset provides a comprehensive registry of diabetes patients, including key clinical metrics such as Hemoglobin A1C, blood glucose logs, complications, medication adherence, and preventive exam results. It is ideal for chronic disease management, population health analytics, and quality improvement initiatives in healthcare organizations.
| first_name | last_name | diabetes_type |
|---|
| Maria | Santos | type 2 |
| James | Nguyen | type 2 |
| Olivia | Johnson | type 1 |
patient_iddate_of_birthgender+24 more
Healthcare21 cols · 100 rows
This cardiovascular disease registry dataset provides detailed patient-level data on myocardial infarction types, interventions (PCI/CABG), door-to-balloon times, ejection fraction, risk scores, medications, and outcomes. It is designed for hospital quality improvement, clinical research, and benchmarking, enabling robust analysis of cardiac care processes and patient outcomes.
| mi_type | pci_performed | outcome_discharge_status |
|---|
| STEMI | true | Home |
| NSTEMI | false | Home |
| STEMI | true | Home |
patient_idadmission_datecabg_performed+15 more
Healthcare23 cols · 100 rows
This cancer registry dataset provides detailed, standardized information on tumor characteristics, including primary site, histology, stage, grade, size, lymph node involvement, metastasis, biomarker results, and treatment details for SEER reporting and outcomes tracking. It enables comprehensive analysis of cancer patterns, treatment efficacy, and patient outcomes across diverse populations.
| histology_type | biomarker_1_name | biomarker_2_name |
|---|
| Invasive ductal carcinoma | ER | HER2 |
| Adenocarcinoma | EGFR | ALK |
| Adenocarcinoma | KRAS | NRAS |
tumor_idpatient_idprimary_site+17 more
Healthcare21 cols · 400 rows
This dataset provides comprehensive records of regulatory submissions and approvals for clinical trials, including IND/NDA applications, protocol amendments, safety reports, annual reports, and related FDA correspondence. It enables robust tracking of compliance activities, approval milestones, and communication with regulatory authorities, making it invaluable for regulatory affairs, clinical operations, and audit readiness.
| submission_type | status | correspondence_type |
|---|
| IND | Under Review | Information Request |
| Protocol Amendment | Approved | Clarification |
| Safety Report | Submitted | Information Request |
submission_idtrial_idsubmission_title+15 more
Healthcare19 cols · 300 rows
This dataset provides comprehensive information on clinical trial research sites, including site identification, principal investigator details, enrollment statistics, audit and compliance history, and performance metrics. It is designed to support multi-center trial management, site selection, regulatory oversight, and operational optimization for clinical research organizations.
| site_name | principal_investigator_name | site_status |
|---|
| Boston Clinical Research Center | Dr. Alan Peterson | Active |
| Phoenix Community Health Trials | Dr. Regina Miles | Inactive |
| Toronto General Clinical Unit | Prof. Linda Choi | Active |
site_idaddress_streetaddress_city+13 more
Healthcare18 cols · 100 rows
This dataset provides comprehensive laboratory and biomarker results from clinical trials, including hematology, chemistry, urinalysis, tumor markers, pharmacokinetics, pharmacodynamics, and exploratory biomarkers. It enables robust safety and efficacy analysis, longitudinal tracking of patient responses, and supports regulatory submissions and translational research.
| sample_type | test_category | test_name |
|---|
| blood | hematology | WBC |
| blood | chemistry | ALT |
| blood | chemistry | AST |
lab_result_idclinical_trial_idsubject_id+12 more
Healthcare18 cols · 100 rows
This dataset provides detailed records of drug administration, dosing schedules, compliance, dose modifications, drug accountability, and concomitant medication use for participants in clinical trials. It enables comprehensive monitoring of protocol adherence, supports safety and efficacy analyses, and facilitates regulatory reporting for pharmaceutical research.
| drug_name | dose_unit | concomitant_medication_name |
|---|
| Lisinopril | mg | Metformin |
| Lisinopril | mg | – |
| Lisinopril | mg | Atorvastatin |
trial_idsubject_idvisit_date+12 more
Healthcare16 cols · 100 rows
This dataset provides comprehensive, standardized reporting of adverse events and safety data from clinical trials, including event details, severity, regulatory coding, and pharmacovigilance notes. It enables robust safety monitoring, regulatory submissions, and data-driven risk assessments for investigational drugs.
| related_to_study_drug | serious_adverse_event | action_taken |
|---|
| true | false | none |
| true | false | dose reduced |
| false | false | none |
adverse_event_idclinical_trial_idsubject_id+10 more
Insurance14 cols · 1,003 rows
This dataset provides detailed catastrophe risk zone information across multiple hazard types, including hurricane, earthquake, wildfire, flood, tornado, and hail. Each record contains geographic identifiers, hazard scores, PML estimates, and portfolio concentration limits, enabling robust risk assessment, exposure management, and spatial analysis for insurance and financial applications.
| zone_name | country | hazard_type |
|---|
| Florida Coastal Zone | USA | hurricane |
| Texas Panhandle Tornado Belt | USA | tornado |
| San Andreas Fault Area | USA | earthquake |
zone_idstate_provincecounty_district+8 more
Insurance17 cols · 600 rows
This dataset provides a comprehensive view of underwriting guidelines, including acceptance criteria, risk appetite, declination reasons, referral triggers, authorization limits, and automated underwriting rules by line of business and risk segment. It enables insurers to standardize, analyze, and automate underwriting processes, ensuring compliance and consistency across products and segments.
| line_of_business | authorization_limit_currency | status |
|---|
| Property | USD | Active |
| Health | CAD | Active |
| Auto | GBP | Active |
guideline_idrisk_segmentacceptance_criteria+11 more
Insurance9 cols · 1,200 rows
This dataset provides comprehensive workers compensation classification codes with detailed occupational descriptions, hazard levels, and manual rates per $100 of payroll. It enables insurers, brokers, and employers to accurately assess risk, calculate premiums, and benchmark occupational safety across industries and jurisdictions.
| occupation_title | hazard_level | manual_rate_per_100_payroll |
|---|
| Office Clerk | Low | 0.35 |
| Construction Laborer | High | 8.5 |
| Registered Nurse | Moderate | 1.75 |
class_codeoccupation_descriptionstate+3 more
Insurance11 cols · 1,000 rows
This dataset provides a comprehensive catalog of commercial general liability risk classes, including classification codes, industry groups, business types, hazard ratings, and premium rates. It enables insurers and brokers to accurately assess, price, and underwrite general liability policies for a wide range of businesses, supporting risk analysis and regulatory compliance.
| business_type | rate_basis | is_excluded |
|---|
| Software Developer | per $1,000 payroll | false |
| Roofing Contractor | per $1,000 payroll | false |
| Clothing Store | per $1,000 payroll | false |
risk_class_codeindustry_groupoperations_description+5 more
Insurance11 cols · 500 rows
This dataset provides detailed long-term care utilization metrics, including nursing home admission rates, assisted living usage, home health care frequency, and care duration, segmented by age group, year, and region. It is designed to support actuarial analysis, insurance reserve modeling, and healthcare planning for aging populations. The flat structure enables easy integration with business intelligence and actuarial systems.
| age_group | gender | nursing_home_admission_rate |
|---|
| 65-69 | female | 14.6 |
| 70-74 | male | 21.2 |
| 75-79 | female | 32.8 |
record_idassisted_living_usage_ratehome_health_care_frequency+5 more
Insurance9 cols · 600 rows
This dataset provides comprehensive incidence rates for major critical illnesses and dread diseases, segmented by age, gender, risk factors, country, and year. It is ideal for actuaries, insurers, and healthcare analysts seeking granular data to inform critical illness insurance pricing, risk modeling, and public health research.
| gender | disease_type | source |
|---|
| female | other | national registry |
| male | other | insurance study |
| female | other | national registry |
record_idageincidence_rate+3 more
Insurance10 cols · 800 rows
This dataset provides comprehensive morbidity and disability rate tables for insurance pricing and valuation, detailing incidence and termination rates by age, occupation class, elimination period, gender, and year. It enables actuaries and analysts to accurately model disability risk, set premiums, and calculate reserves for disability and long-term care insurance products.
| age | occupation_class | gender |
|---|
| 29 | professional | male |
| 31 | professional | female |
| 52 | executive | male |
record_idelimination_period_daysdisability_incidence_rate+4 more
Insurance10 cols · 400 rows
This dataset provides detailed loss development factors, including age-to-age, cumulative, and tail factors by insurance line of business and development period. It enables actuaries and analysts to project ultimate losses, assess reserve adequacy, and benchmark against industry standards, supporting robust financial and risk management decisions.
| line_of_business | development_period_start | factor_source |
|---|
| Auto | 0 | Internal Study |
| Property | 0 | Industry Benchmark |
| Liability | 1 | External Peer Group |
ldf_iddevelopment_period_endage_to_age_factor+4 more
Insurance11 cols · 500 rows
This dataset provides a comprehensive view of earned premium development by accident or underwriting year and development period, segmented by exposure base, line of business, and region. It is designed for actuarial analysis, rate adequacy studies, and combined ratio calculations, enabling insurers to track premium trends and performance over time.
| year_type | exposure_base | currency |
|---|
| accident | written_premium | USD |
| underwriting | earned_premium | EUR |
| accident | policy_count | USD |
idyeardevelopment_period+5 more
Insurance9 cols · 601 rows
This dataset provides a detailed view of closed insurance claims over time, segmented by accident year and development period. It includes claim counts, settlement amounts, closure rates, and supporting metrics, enabling robust analysis of closure patterns, average settlements, and operational efficiency for insurers and actuaries.
| accident_year | development_period_months | closed_claim_count |
|---|
| 1993 | 132 | 3 |
| 1997 | 204 | 0 |
| 1908 | 192 | 2 |
total_settlement_amountaverage_settlement_amountclosure_rate+3 more
Insurance9 cols · 600 rows
This dataset provides a comprehensive view of insurance claim count development triangles, tracking reported and IBNR claim counts by accident year and development period across multiple lines of business. It enables frequency analysis, estimation of incurred but not reported claims, and supports actuarial reserving methodologies for insurance portfolios.
| accident_year | line_of_business | triangle_type |
|---|
| 2023 | property | total |
| 2024 | property | total |
| 2022 | property | total |
development_periodreported_claim_countibnr_claim_count+3 more
Insurance10 cols · 800 rows
This dataset provides detailed cumulative paid loss development triangles segmented by accident year, development period, and line of business, enabling actuaries and analysts to track payment progression, estimate ultimate losses, and assess reserve adequacy. It includes reserve estimates, currency codes, and source information for robust actuarial modeling and regulatory reporting.
| line_of_business | currency | data_source |
|---|
| Auto | USD | CoreClaims |
| Property | USD | LegacySystem |
| Liability | EUR | PartnerFeed |
triangle_idaccident_yeardevelopment_period+4 more
Insurance12 cols · 600 rows
This dataset provides detailed insights into insurance deductible and coinsurance selections, risk retention choices, and customer risk appetite across various markets and insurance lines. It enables granular analysis of affordability and risk trends by geography, segment, and year, supporting strategic pricing, product design, and market research for insurers and analysts.
| insurance_line | risk_retention_type | customer_segment |
|---|
| health | deductible | individual |
| property | self-insured retention | enterprise |
| auto | coinsurance | small business |
record_idmarket_geographypolicy_year+6 more
Insurance17 cols · 400 rows
This dataset provides detailed records of premium audit exposure adjustments, comparing estimated and actual exposures (payroll, sales, receipts) by state, territory, and classification. It enables insurers and analysts to track audit outcomes, support accurate revenue recognition, and inform experience rating calculations, offering valuable insights for underwriting, compliance, and risk management.
| classification_code | exposure_type | included_in_experience_rating |
|---|
| 8810 | payroll | true |
| 8742 | sales | false |
| 8829 | payroll | true |
audit_idaudit_datepolicy_number+11 more
Insurance12 cols · 500 rows
This dataset provides detailed information on insurance policy terms, renewal schedules, and expiration patterns, mapped by month and quarter. It enables precise cash flow forecasting, resource allocation, and renewal cycle management by offering granular insights into premium values, policy durations, and customer associations.
| policy_type | renewal_status | currency |
|---|
| auto | renewed | USD |
| home | expired | EUR |
| travel | cancelled | USD |
policy_idterm_length_monthspolicy_start_date+6 more
Insurance18 cols · 400 rows
This dataset provides comprehensive records of international and cross-border insurance exposures, detailing policy information, foreign operations, admitted and non-admitted placements, currency risks, and regulatory compliance by country. It enables insurers, brokers, and risk managers to analyze global insurance portfolios, monitor regulatory status, and assess currency and operational risks across jurisdictions.
| insured_entity_name | operation_type | placement_type |
|---|
| Alpha Manufacturing Ltd. | subsidiary | admitted |
| Alpha Manufacturing Ltd. | subsidiary | admitted |
| Beta Foods Group | subsidiary | admitted |
exposure_idpolicy_idcountry_of_exposure+12 more
Insurance16 cols · 600 rows
This dataset offers detailed insurance premium, penetration, and demographic metrics by geographic area, including population, household income, GDP, and property values. It enables market opportunity analysis, segmentation, and benchmarking for insurers, consultants, and financial analysts seeking to identify growth potential and underserved regions.
| area_name | population_total | household_count |
|---|
| Manhattan District | 1623000 | 732100 |
| Westminster Central | 107500 | 49300 |
| Paris Arrondissement | 215100 | 102800 |
area_idcountrystate_province+10 more
Insurance13 cols · 800 rows
This dataset provides detailed commercial insurance premium and exposure data broken down by SIC/NAICS industry codes, economic sectors, and portfolios over time. It enables in-depth analysis of business mix, industry concentration, and portfolio diversification, supporting risk management and strategic decision-making for insurers and analysts.
| sic_code | naics_code | industry_name |
|---|
| 2752 | – | Commercial Printing Services |
| – | 541612 | Human Resources Consulting |
| 5999 | – | Miscellaneous Retail Stores |
record_ideconomic_sectorpolicy_year+7 more
Insurance23 cols · 600 rows
This dataset provides comprehensive records of ceded premiums, reinsurance commissions, profit commissions, premium adjustments, and bordereaux reporting for both treaty and facultative reinsurance agreements. It enables detailed financial tracking, regulatory compliance, and performance analysis for reinsurance transactions between insurers and reinsurers.
| treaty_type | premium_currency | commission_type |
|---|
| Treaty | USD | Standard |
| Treaty | EUR | Standard |
| Facultative | CAD | Sliding Scale |
transaction_idtreaty_idceding_company_id+17 more
Insurance21 cols · 150 rows
This dataset provides detailed information on retrocessional reinsurance programs, including treaty types, financial structures, pricing methodologies, and market capacity. It enables analysis of risk transfer strategies among reinsurers, supports benchmarking, and facilitates regulatory compliance and risk management. The dataset is ideal for actuaries, risk managers, and insurance market analysts seeking to understand retrocession market dynamics.
| reinsurer_name | program_name | treaty_type |
|---|
| Allianz Re | Global Property XL 2021 | excess of loss |
| Swiss Re | Europe Casualty Quota Share 2022 | quota share |
| Hannover Re | Asia-Pacific Life Stop Loss 2023 | stop loss |
retrocession_program_idinception_dateexpiry_date+15 more
Insurance15 cols · 800 rows
This dataset provides a detailed record of outstanding reinsurance recoverables, capturing paid losses, case reserves, and IBNR amounts ceded to reinsurers. It includes aging information, dispute status, and reinsurer credit ratings, enabling thorough collectibility assessment and risk analysis for insurance portfolios. Ideal for financial reporting, risk management, and regulatory compliance in the insurance industry.
| reinsurer_name | recoverable_type | dispute_status |
|---|
| TransEuro Re | paid_loss | none |
| Asia Pacific Re | case_reserve | none |
| Continental Reinsure | paid_loss | none |
recoverable_idpolicy_idclaim_id+9 more
Insurance31 cols · 401 rows
This dataset provides detailed records of individual facultative reinsurance placements for large or unusual risks, including ceding and reinsurer details, risk descriptions, coverage terms, premiums, and negotiated conditions. It supports analysis of reinsurance market practices, risk transfer strategies, and regulatory compliance for complex insurance exposures.
| ceding_company_contact_name | reinsurer_contact_name | insured_name |
|---|
| Linda Martinez | Martin Gehrig | Riverside Partners LLC |
| Emily Clarke | Thomas Meyer | Bloomsbury Residences Ltd |
| Jacob Turner | Sophie Lambert | NorthPoint Logistics Inc. |
placement_idceding_companyceding_company_contact_email+25 more
Insurance18 cols · 100 rows
This dataset provides comprehensive details on aggregate excess of loss (XOL) reinsurance treaties, including coverage terms, financial parameters, claims experience, and involved parties. It enables risk managers, actuaries, and analysts to assess treaty performance, loss aggregation, and frequency of catastrophic events across policy years. Ideal for portfolio management, pricing analysis, and regulatory reporting in the insurance and reinsurance sector.
| cedent_name | reinsurer_name | aggregate_deductible_type |
|---|
| Atlas Insurance Group | Munich Re | annual |
| Zenith Assurance | Swiss Re | multi-year |
| Everest General | SCOR | annual |
treaty_idpolicy_year_startpolicy_year_end+12 more
Insurance16 cols · 150 rows
This dataset provides detailed records of surplus share reinsurance treaties, including terms of risk retention, cession, premium and loss sharing, and treaty status. It enables analysis of reinsurance arrangements between insurers and reinsurers, supporting risk management, regulatory reporting, and treaty portfolio optimization.
| cedent_company_name | reinsurer_company_name | treaty_status |
|---|
| United Assurance Group | Global Re Corp | active |
| Phoenix Mutual Insurance | Secure Re Ltd | expired |
| Horizon Insurance Company | Munich Re | active |
treaty_idtreaty_effective_datetreaty_expiry_date+10 more
Insurance16 cols · 200 rows
This dataset provides detailed records of quota share reinsurance treaties, including contract terms, participating companies, financial percentages, and commission structures. It enables comprehensive analysis of proportional risk-sharing agreements in the insurance industry, supporting operational management, regulatory compliance, and strategic decision-making.
| cedent_company_name | reinsurer_company_name | status |
|---|
| Liberty Mutual | Swiss Re | expired |
| Allianz SE | Munich Re | active |
| Ping An Insurance | SCOR | expired |
treaty_idtreaty_effective_datetreaty_expiry_date+10 more
Insurance18 cols · 300 rows
This dataset provides detailed information on property catastrophe excess of loss reinsurance treaties, including financial terms, coverage limits, reinstatement provisions, territorial scope, and involved parties. It enables comprehensive analysis of catastrophe risk transfer, treaty structuring, and market benchmarking for insurers and reinsurers.
| cedent_name | reinsurer_name | catastrophe_type |
|---|
| Pacific General Insurance | Munich Re | earthquake |
| Global Nexus Underwriters | Swiss Re | multi-peril |
| Empire Assurance | SCOR | flood |
treaty_idtreaty_yeareffective_date+12 more
Insurance11 cols · 501 rows
This dataset provides detailed Probable Maximum Loss (PML) estimates for various catastrophe exposures, including loss amounts at multiple return periods and confidence levels. It is designed to support reinsurance purchasing, risk management, and regulatory reporting by offering granular, traceable loss metrics across exposures and event types. The dataset is ideal for actuaries, risk managers, and insurance analysts seeking to quantify and manage catastrophic risk.
| catastrophe_type | return_period_years | reinsurance_layer |
|---|
| hurricane | 100 | excess of loss |
| earthquake | 1000 | stop loss |
| flood | 10 | quota share |
pml_idexposure_idconfidence_level_percent+5 more
Insurance20 cols · 600 rows
This dataset provides detailed records of professional liability and errors & omissions claims, including allegations, defense costs, expert witness fees, regulatory involvement, and settlement outcomes. It enables comprehensive analysis of claim trends, risk factors, and financial impacts across various professions and jurisdictions.
| claimant_name | claimant_type | professional_name |
|---|
| Emily Harper | client | Dr. Steven K. Lee |
| Jacob Reynolds | patient | Dr. Hannah M. Patel |
| Regulatory Commission of Bavaria | regulatory_body | Weiss Engineering GmbH |
claim_idprofessional_typepolicy_number+14 more