Back to Explore Data
Healthcare Closed Claims
Overview
Fully adjudicated (closed) medical and pharmacy claims with final payment outcomes, including amount allowed, amount paid, member cost share, denials, and reversals. Coverage spans three categories: Medical — inpatient (UB-04), outpatient (UB-04), and professional (CMS1500) claims; Pharmacy — retail and mail-order point-of-sale prescription claims (NCPDP); Other — dental (ADA), vision, behavioral health carve-outs, durable medical equipment, transportation, and other non-medical/non-pharmacy benefits. Includes patient-level enrollment information alongside claims, enabling normalization panels and PMPM analytics across consistent member cohorts.
Availability
- Aggregate, Builder: Available
- Aggregate, API: Available
- MCP Server, Lenses: Available
- MCP Server, Non-native: Available
- Row Level, Block: Available
Please note that due to access restrictions set by Carbon Arc's licensors, you may not be eligible to purchase certain data assets and/or content listed on the Carbon Arc platform.
Key Metrics
- Amount Allowed: Allowed dollar amount on the adjudicated claim.
- Amount Paid: Final amount paid by the payer on the adjudicated claim.
- Claims Count: Total number of claims represented in this record.
- Member Cost Share: Patient out-of-pocket portion (copay, deductible, coinsurance).
- Patient Count: Number of unique patients represented in the claim data row.
Product Highlights
- CarbonArc proprietary ontology covers NDC → drug brand → manufacturer → equity ticker rollups, procedure category and medical segment mappings, and standardized demographic dimensions.
- Closed (adjudicated) claims capture the final payment outcome — amount allowed, amount paid, member cost share, and reversal events — providing certainty around real dollar flow.
- Enrollment information delivered alongside claims supports normalization panels for PMPM calculations, trended utilization analytics, and disenrollment-bias correction.
- Persistent patient identifier across medical and pharmacy enables true cross-channel patient journey, cohort, and adherence analysis over 10+ years of history.
Granularity
- Medical: Trends aggregated to medical segment, procedure category, and provider by line of business (Commercial, Medicare, Medicaid, Medicare Supplement) by claim count, amount allowed, amount paid, and units billed. Pharmacy: Trends aggregated to drug brand name and drug manufacturer by line of business by claim count, ingredient cost paid, and units dispensed. Data aggregated to the week, month, quarter, fiscal quarter.
Key Fields
- Diagnosis Code: Diagnosis codes (up to 30 positions, primary + secondary) submitted with the claim.
- Drug NDC: 11-digit NDC, with drug brand and manufacturer via CarbonArc ontology (pharmacy).
- Gender: Patient gender as a string (e.g., Male, Female).
- Generation: Text label of the generation the patient belongs to (e.g., Baby Boomers).
- Line of Business: The type of insurance payer (e.g., Commercial, Medicaid, Medicare, Medicare Supplement).
- Place of Service: Setting in which the service was rendered.
- Procedure Code: CPT/HCPCS procedure codes with modifiers (CDT for dental).
Additional Information
- Category: Healthcare
- Sectors: Healthcare
- Use Case: Consumer Fixed Costs, Demand Forecasting
- Recommendations: Coming soon.
- Date Added: 6/09/2026
- Block Granularity: Medical: Claim line items including billed/allowed/paid amounts, member cost share (copay, deductible, coinsurance), units billed, persistent unique patient ID, patient demographics, diagnoses (up to 30 positions, primary + secondary, with present-on-admission indicators), procedure codes (CPT/HCPCS) with modifiers, place of service, MS-DRG (inpatient), revenue codes, billing/attending/referring provider identifiers, payer line of business and type. Includes paid date and service date. Pharmacy: Claim line items including ingredient cost paid, drug cost, dispensing fee, member cost share, days supply, units dispensed, fill source (retail/mail), persistent unique patient ID, patient demographics, drug NDC (11-digit), drug brand and manufacturer (via CarbonArc ontology), dispensing pharmacy NPI, prescriber NPI, payer line of business and type. Other: Claim line items for dental (CDT codes on ADA form), vision, behavioral health carve-outs, DME, transportation, and similar benefit categories, including billed/allowed/paid amounts, member cost share, units billed, procedure codes, billing provider identifiers, payer line of business and type, and the same patient identifier used across medical and pharmacy claims.
- Region: North America
Example Use Cases
- Adherence and persistence studies. Use the persistent patient identifier across medical and pharmacy to follow patients through diagnosis, prescription, refill cycles, and downstream medical events. Quantify adherence rates and identify drop-off points.
- Disease cohort and longitudinal patient journey. Identify patients meeting diagnostic criteria (via ICD-10 codes), then follow utilization and spend across all settings over months or years.
- PMPM and total cost of care benchmarking. Use the enrollment table to construct stable member panels, then calculate medical, pharmacy, and total PMPM trends by LOB, geography, and demographic segment.
- Payer mix and reimbursement analysis. Compare billed vs allowed vs paid amounts by payer line of business, geography, and provider type. Track contracting and reimbursement trends.
- Procedure and HCPCS volume tracking. Quantify utilization of specific procedures, devices, or provider-administered drugs (J codes) — relevant for medical device manufacturers, surgical instrument makers, and infused-drug manufacturers.
- Real-world drug utilization and brand-level market share tracking. Quantify dispensing volumes, patient reach, average cost, and persistence at the drug brand or manufacturer level. Validate manufacturer-reported sales metrics with independent claims-based evidence.
- Site-of-care analysis. Track procedure migration across inpatient, outpatient, and ambulatory settings (e.g. shift of joint replacements from inpatient to ASCs). Combine setting-level granularity with cost data to model financial impact.
- Therapeutic class dynamics. Track adoption curves across competing therapies within a class (e.g. GLP-1 evolution from Byetta and Victoza through Ozempic, Wegovy, Mounjaro and Zepbound), illustrating which agents are gaining share and which are being displaced.
Details
- Data Asset ID: CA0081
- Provider ID: Provider 81
- History: 2016-Present
- Frequency: Monthly
- Delivery: Table
- Panel Size: Total Claim Rows: 12.3B+. 2023: 1.68B / 2024: 1.69B. Total Unique Patients: 65.6M+. 2023: 26.4M / 2024: 25.8M. Total Billing Providers: 2.88M+. 2023: 1.66M / 2024: 1.66M.
- Coverage: Lines of Business (% of total claim volume, 2023-2024): Medicaid (42.2%) / Commercial (33.0%) / Medicare (21.2%) / Medicare Supplement (2.7%) / Unspecified (0.9%)., Service Setting (% of total claim volume, 2023-2024): Professional (37.6%) / Pharmacy (22.1%) / Outpatient (21.7%) / Other (15.5%) / Inpatient (3.1%)., Total Claim Rows: 12.3B+. 2023: 1.68B / 2024: 1.69B. Total Unique Patients: 65.6M+. Total Billing Providers: 2.88M+.
- Bias: Data limited to the United States.
- Lag: Claim maturity varies by service setting. Pharmacy reaches ~90% of eventual allowed dollars by month 4. Professional and Outpatient both reach ~90% by month 5. Other (dental, vision, DME, behavioral health) follows a similar pattern to Professional and Outpatient, reaching ~90% by month 5-6. Inpatient matures more slowly, reaching ~90% by month 6. Trended analyses for recent service months should account for these windows.
- Geographic Availability: CBSA/MSA, State, US, Zip
Interested in this data asset?
Request access to explore the full data dictionary, sample data, and API documentation. Sign Up. Documentation.