Enter the password to view this site.
data/supplier-comparison.json)Per supplier NPI and service code: claims count and average payout (2024-07 to 2024-12). Data includes month; table, summary, and chart are derived in the browser.
HHS Data is stored as pre-aggregated rows. Each row represents a bucket for a given billing provider (BILLING_PROVIDER_NPI_NUM), service code (HCPCS_CODE), and month (CLAIM_FROM_MONTH). Each row already contains TOTAL_CLAIMS (number of claims in that bucket) and TOTAL_PAID (total amount paid). There are no individual claim IDs—we sum these pre-aggregated counts and amounts.
{
"BILLING_PROVIDER_NPI_NUM": "1234567890",
"HCPCS_CODE": "99213",
"CLAIM_FROM_MONTH": "2024-07",
"TOTAL_CLAIMS": 150,
"TOTAL_PAID": 22500.00
}
Client Data is stored as claim-level rows. Each row is one claim line (one service on one claim): CLAIM_ID, SUPPLIER_NPI, SUPPLIER_NAME, SERVICE_CODE, RECEIPT_DATE, and TOTAL_PAID. CLAIM_ID is not the actual claim identifier—it is a randomly assigned value to prevent PHI leakage and to avoid traceability to real claims. The month used for filtering and comparison with HHS is derived from RECEIPT_DATE. The same claim can appear on multiple rows (one per service line). In the comparison table we count distinct CLAIM_ID per NPI + service code.
{
"CLAIM_ID": "CLM-001",
"SUPPLIER_NPI": "1234567890",
"SUPPLIER_NAME": "Example Provider",
"SERVICE_CODE": "99213",
"RECEIPT_DATE": "2024-07-05 00:00:00",
"TOTAL_PAID": 150.00
}
Each table row is one combination of supplier (NPI) and service code. Filters apply to both supplier and HHS data when a month is selected.
| Column | Description |
|---|---|
| Supplier NPI | From Client Data (SUPPLIER_NPI). The billing provider's National Provider Identifier. |
| Supplier Name | From Client Data (SUPPLIER_NAME). |
| Service Code | From Client Data (SERVICE_CODE). Matched to HHS by the same code. |
| Service code description | Looked up from yearly_service_averages.parquet (SERVICE_SHORT_DESC by SERVICE_CODE). Shown when that file is available. |
| Client claims | Your data. Distinct claim count (by CLAIM_ID, which is randomly assigned—not the actual claim ID—to prevent PHI leakage and traceability) per NPI + service code. Sum of this column equals total Client claims for the filtered set. |
| HHS claims | HHS Data. Sum of TOTAL_CLAIMS from HHS Data for the same NPI and service code, for the selected period (or single month if filtered). |
| $ / Client claim | Average payout per claim for that NPI + service code (total paid ÷ distinct claim count). |
| $ / HHS claim | Average payout per HHS claim for that NPI + service code (total paid ÷ HHS claim count). |
CLAIM_ID, a randomly assigned value—not the actual claim identifier—to prevent PHI leakage and traceability) in Client Data for that NPI and service code, after applying filters (month derived from RECEIPT_DATE).| Supplier NPI | Supplier Name | Service Code | Service code description | Client claims i The number of times this provider was billed for this service code in your data—counting each claim once even when a claim has multiple lines for the same service. | HHS claims i The number of claims for this provider and service code in the HHS Medicaid dataset for the same period—how often this service was billed in the reference data. | $ / Client claim i The average amount paid per claim for this provider and service code in your data—total paid for this NPI and service divided by the number of claims. | $ / HHS claim i The average amount paid per claim for this provider and service code in the HHS Medicaid data—total paid in the reference dataset divided by the number of HHS claims. |
|---|