Back to Explore Data
Medical & Pharmacy Open Claims
Overview
Medical: Clearinghouse derived and consists of encounters across the care continuum, including provider office visits, hospital stays, emergency room visits, outpatient surgeries, procedures, lab tests, imaging, durable medical equipment, and provider-administered treatments such as infusions or injections. Pharmacy: Comprised of clearinghouse and PBM sourced data and captures a point in sale transaction when a patient fills their prescription across both retail and specialty channels. We receive claim adjudication outcomes.
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
- Average Total Charge: Average charge per claim (equal to total charge if claim count is 1).
- Claims Count: Total number of claims submitted for this record.
- Patient Count: Number of unique patients represented in the claim data row.
- Total Charge: Total amount charged for the medical service.
Product Highlights
- Connection with Carbon Arc proprietary ontology and ability to easily join with other datasets.
- Data Limitations: As noted above, the Change cyberattack resulted in a number of providers dropping out of the medical dataset resulting in an inorganic decline in claim volume at that point in time. This outage also affected clearinghouse-derived pharmacy data. Additionally, our data partner lost one of their clearinghouse vendors at the end of 2024, which resulted in a separate decline in pharmacy clearinghouse volume. Normalizing the pharmacy clearinghouse-sourced data on the pharmacy_npi field adjusts for these two isolated events.
- Data on the platform is deduplicated using Carbon Arc's proprietary logic that accounts for key claim attributes and includes exceptions in the medical data based on modifier codes, ensuring that clinically distinct claim lines are not removed, and adjudication outcomes on the pharmacy side to retain only paid claims. Block data is provided in full with a field ca_claim_include designating whether the row has passed deduplication logic.
- For Medical data, there is an option to normalize data on the platform for billing providers that have seen consistent monthly activity since 2019. Our provider panel adjusts for instances such as the Change Healthcare hack in February 2024 and other inorganic fluctuations in data due to providers entering and exiting the dataset.
Granularity
- Medical: Trends aggregated to medical segment, drug brand name, and drug manufacturer by line of business (Commercial, Medicare, Medicaid) by claim count, charge amount billed, and units billed. Data aggregated to the week, month, quarter, fiscal quarter. Pharmacy: Trends aggregated for paid claims only to drug brand name and drug manufacturer by source type and line of business (Commercial, Medicare, Medicaid) by claim count, ingredient cost paid, and units billed. Data aggregated to the week, month, quarter, fiscal quarter.
Key Fields
- Billing Type: Indicates whether the claim was institutional or professional (e.g., 'P' for Professional).
- Diagnosis Code Description: Description of the medical condition related to the diagnosis code..
- Diagnosis Code: Primary diagnosis code submitted with the claim.
- 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).
- Medical Department Type Specialty or taxonomy of the provider who performed the procedure (e.g., Emergency Medicine).
Additional Information
- Category: Healthcare
- Sectors: Healthcare
- Use Case: Consumer Fixed Costs, Demand Forecasting
- Recommendations: Coming soon.
- Date Added: 5/01/2025
- Block Granularity: Medical: Includes and is not limited to line charge amount, days of supply, units billed, unique patient ID and other patient demographics, patient diagnoses, procedure code, procedure modifiers, drug brand name, drug NDC, billing provider, rendering provider, organization, payer name and type, claim type etc. Pharmacy: Includes and is not limited to ingredient cost paid, days of supply, units dispensed, unique patient ID and other patient demographics, adjudication outcome, fill number, drug brand name, drug NDC, drug generic name, pharmacy NPI, rendering provider, organization, payer name and type etc.
- Region: North America
Example Use Cases
- Beyond tracking high-level utilization trends of procedures and therapeutics through claims volume, patient counts, or costs on the Carbon Arc platform, our block dataset offering is attribute-rich, with fields that support a wide range of analyses. This includes diagnoses, insurance types, patient demographics such as age, and geographic information, enabling insights like trend monitoring, segmentation, and utilization patterns.
- Medical and pharmacy claims can be leveraged to track real-world utilization and benchmark it against manufacturer-reported metrics such as sales, claim count, average cost, units or unique patients.Eg. analyzing Aristada pharmacy claims enables us to observe dispensing volumes over time, assess patient reach, and compare these trends to Alkermes' reported sales figures. This approach provides a data-driven view of market adoption, helping validate reported metrics and identify patterns in therapy use across different patient populations and care settings.
- The ca_patient_id field in the block offering is a persistent, unique patient identifier consistent across both medical and pharmacy claims, allowing for longitudinal tracking and cohort analyses across different therapies or services.
- Use healthcare claims data to track drugs across entire therapeutics groups. Eg. GLP-1 prescription activity across Byetta, Bydureon, Victoza, Trulicity, Ozempic, Rybelsus, Wegovy, and Mounjaro, illustrating how newer-generation agents such as semaglutide and tirzepatide have steadily displaced older therapies like exenatide and liraglutide. Mounjaro, the most recent market entrant, now represents a substantial and rapidly expanding share of GLP-1 use, reflecting the broader shift toward dual-agonist treatments.
Details
- Data Asset ID: CA0049, CA0049R, CA0049M
- Provider ID: Provider 49
- History: Medical: 2015-Present, Pharmacy: Clearinghouse: 2015 - Present. PBM: 2017 - Present.
- Frequency: Weekly
- Delivery: Table
- Panel Size: Total Claims: 34B+, 2023: Medical Claims: 2.27B+, Pharmacy Claims: 4.17B+, 2024: Medical Claims: 1.59B+, Pharmacy Claims: 3.17B+
- Coverage: Medical: Total Claim Line Items: 57.9B+. 2023: 6.73B+. 2024: 5.24B+. Patients: 200M+ annually. Billing Providers: 725K+ annually. LOBs: Commercial, Medicare, and Medicaid, Pharmacy: Total Claims: 36.7B+. 2023: PBM Claims (618M+) Clearinghouse Claims (3.28+). 2024: PBM Claims (775M+) Clearinghouse Claims (2.60B+). Patients: 130M+ annually. Pharmacies: PBM *10.4k+ annually) Clearinghouse (38.4k+ annually historically, currently ~20K annually). LOBs: Commercial, Medicare, and Medicaid
- Bias: Data limited to the United States. 70-75% US Geographic Coverage.
- Lag: Medical: T + 5 days for latest day of service claim, however, there is an inherent lag given filling latency which varies by segment; on average we see ~45% of claims represented within the first week and 80% within 4 weeks. Pharmacy: T + 5 Days
- Geographic Availability: CBSA, DMA, Medical Geography: derived from facility or billing provider addresses, Pharmacy Geography: derived from patient addresses, State, US, Zip Code
Interested in this data asset?
Request access to explore the full data dictionary, sample data, and API documentation. Sign Up. Documentation.