For manufacturers, pharmacy networks and health systems
The register, as a file you keep
94,399 rows, newest load read 2026-10-14 — download 100 real rows (CSV, no email).
$25,000/year a year, for the whole register, by card or purchase order; one state, $4,500/year a year, by card. A one-year term from the day it is paid.
Read the license agreement before you buy: the agreement (one-page PDF) · W-9 (VELARIONAI LLC)
What the license is
the 340b register, licensed as data: every table below, as the agency publishes it, with the columns the license file carries and nothing recomputed.
License terms and price
- The whole register, internal use: $25,000/year
- The whole register, with the right to redistribute: $75,000/year
Update cadence: rebuilt daily from the live register.
Download a 100-row sample (CSV) — the license file's own columns, a hundred real rows, no email required.
The full register is 94,399 covered_entities. License it — the nation, internal use, $25,000/year.
See the full data sheet — 4 tables, every column, as the register holds it
Tables and columns
hlth340b_entities — Every covered entity on the register, as the daily report prints it.
94,399 rows, newest load read 2026-10-14
entity_340b_id— HRSA's unique 340B id for this covered entity.ce_id— HRSA's covered entity id (parent organization id), when a site carries its own 340B id.entity_type— HRSA's 340B entity/program type code for this covered entity.entity_name— The covered entity's name of record.sub_division_name— The entity's sub-division name, when filed as a site of a parent.participating_raw— HRSA's own participation status text for this covered entity.participating_start_date— Date the entity's current 340B participation began.termination_date— Date the entity's 340B participation ended, when it has.termination_reason— The reason code HRSA assigns for the termination, when filed.certified_date— Date the entity's 340B enrollment was certified.parent_340b_id— The 340B id of this entity's parent organization, when it is a child site.site_id— HRSA's site id for this entity, when it is one site of a multi-site covered entity.grant_number— The federal grant number the entity's 340B eligibility is tied to, when filed.ccn— CMS Certification Number -- the id this entity's row joins to its Medicare cost report on.npi— The entity's National Provider Identifier, when filed.medicaid_number— The entity's state Medicaid provider number, when filed.rural— Whether HRSA's own file flags this entity as rural.street_address_1— Street address, line 1.street_address_2— Street address, line 2.street_city— City, as HRSA's file prints it.street_state— State, USPS code.street_zip— ZIP code.edit_date— Date HRSA's own file last edited this entity's record.first_seen_file_date— Date of the first daily 340B file this exact row was read from.last_seen_file_date— Date of the most recent daily 340B file this row was confirmed on.source_file— The HRSA 340B OPAIS extract file this row was read from.source_url— The HRSA source this row was read from.
hlth340b_contract_pharmacies — Every arrangement between a covered entity and a pharmacy that dispenses on its behalf.
398,746 rows, newest load read 2026-10-02
contract_id— HRSA's unique id for this contract-pharmacy arrangement.entity_340b_id— The covered entity this arrangement belongs to -- the id covered_entities carries.pharmacy_id— HRSA's id for the dispensing pharmacy.pharmacy_name— The contract pharmacy's name of record.contract_begin_date— Date the contract-pharmacy arrangement began.contract_termination_date— Date the arrangement ended, when it has.pharmacy_address_1— The pharmacy's street address.pharmacy_city— The pharmacy's city.pharmacy_state— The pharmacy's state, USPS code.pharmacy_zip— The pharmacy's ZIP code.first_seen_file_date— Date of the first daily 340B file this exact row was read from.last_seen_file_date— Date of the most recent daily 340B file this row was confirmed on.source_file— The HRSA 340B OPAIS extract file this row was read from.source_url— The HRSA source this row was read from.
hlth340b_status_history — Every value that changed between one daily report and the next, with the report that first showed it.
9,347 rows
id— This change's own row id.entity_340b_id— The covered entity this change belongs to.field_name— Which field on the entity changed.old_value— The value the field held before the change.new_value— The value the field holds after the change.first_shown_file_date— Date of the first daily 340B file that showed the new value.prior_file_date— Date of the daily 340B file that still showed the old value.source_file— The HRSA 340B OPAIS extract file this change was read from.source_url— The HRSA source this change was read from.
v_hosp_filers — The Medicare cost report each hospital filed, figure by figure, joined to the register on the certification number both print.
10,200 rows
ccn— CMS Certification Number -- the id this cost report joins to the 340B entity on.provider_name— The hospital's name of record on the cost report.city— City, as the cost report prints it.state_code— State, USPS code.county— County, as the cost report prints it.facility_class— CMS's facility class for this hospital's cost report form.on_340b_register— Whether this hospital is on the 340B covered entity register.form— Which CMS cost report form this filing was made on.fiscal_year— The hospital's fiscal year this report covers.fy_begin— Fiscal year start date.fy_end— Fiscal year end date.fy_days— Number of days in the fiscal year.report_status— CMS's status for this cost report filing (as-filed, settled, amended, etc.).proc_date— Date CMS processed this cost report.total_patient_revenue— Gross revenue from patient care, as filed.contractual_allowances— Contractual allowances and discounts deducted from gross revenue, as filed.net_patient_revenue— Patient revenue after contractual allowances, as filed.total_operating_expenses— Total operating expenses, as filed.net_income_from_patients— Net income from patient care activities, as filed.charity_care_charges— Charity care, at the hospital's billed charges, as filed.charity_care_cost— Charity care, at the hospital's own cost, as filed.bad_debt_expense— Bad debt expense, as filed.non_medicare_bad_debt_cost— Bad debt cost attributable to non-Medicare patients, as filed.uncompensated_care_cost— Uncompensated care, at cost, as filed.total_facility_beds— Total licensed beds, as filed.bed_band— The hospital's bed-count band, as this register groups it.cost_to_charge_ratio— Ratio used to convert billed charges to estimated cost.dsh_percentage— The hospital's Disproportionate Share Hospital percentage, as filed.locators— The cost report worksheet, line and column each figure above was printed on.source_file— The CMS Healthcare Cost Report Information System extract this row was read from.source_url— The CMS source this row was read from.source_fy— The fiscal year of the cost report file this row was read from.
Sample built 2026-10-19T00:18:21Z (UTC).
The public source is a spreadsheet that is replaced every morning and keeps no history, so the answer to “when did this arrangement start” is only as good as the day somebody on your team began saving copies. This is the same register with its history kept for you: every entity, every site, every dispensing arrangement, every value that changed and the report that first showed it — joined to the Medicare cost report of each hospital that files one.
- 94,399Records on the register
- 65,437Currently participating
What arrives
- covered_entities.csvcovered_entities.parquet94,399 rowsEvery covered entity and registered site
- contract_pharmacies.csvcontract_pharmacies.parquet398,746 rowsEvery arrangement with a dispensing pharmacy
- register_changes.csvregister_changes.parquet9,347 rowsEvery value that changed, and the report that showed it
- hospital_finances.csvhospital_finances.parquet10,200 rowsThe filed cost report of every hospital that files one
- manifest.jsonREADME.txt—The report each file was built from, and a checksum for every one
29.0 MB, one zip. Rebuilt every day the register is republished, and your API key reaches the current data for the whole term.
Buy with a purchase order
An invoice from VELARIONAI LLC, sent to your billing address, for either scope. The license, the file and the API key arrive the moment it is paid.
The scopes
- One state$4,500/year
- Every covered entity in a state, its sites and its contract pharmacies, with the daily history and the finances where a cost report is on file.
- The whole register, internal use$25,000/year
- Every entity, every site, every arrangement, and every filed cost report — for use inside your own organization.
- Enterprise, with redistribution$75,000/year
- The same file, with the right to build it into something you sell or publish. Invoiced rather than charged to a card, with the redistribution grant attached to the license: buy it with a purchase order and the invoice is sent at once.
Post-acute (skilled nursing) data license
Every figure a facility page shows, for every loaded facility: finances, staffing, inspections, deficiencies, penalties and ownership.
14,691 rows — download 100 real rows (CSV, no email).
What the license is
the post-acute register, licensed as data: every table below, as the agency publishes it, with the columns the license file carries and nothing recomputed.
License terms and price
- The whole register, internal use: $15,000/year
Update cadence: rebuilt daily from the live register.
Download a 100-row sample (CSV) — the license file's own columns, a hundred real rows, no email required.
The full register is 14,691 facility_register. License it — the nation, internal use, $15,000/year.
See the full data sheet — 7 tables, every column, as the register holds it
Tables and columns
snf_facilities — Every skilled nursing facility on Care Compare's own Provider Information file, as filed.
14,691 rows
ccn— CMS Certification Number -- the id every other table here joins on.provider_name— The facility's name of record.street_address— Street address.city— City, as Care Compare's file prints it.state_code— State, USPS code.zip_code— ZIP code.county— County, as filed.ownership_type— Ownership type (for-profit, non-profit, government).provider_type— CMS provider type code for this facility.certified_beds— Number of Medicare/Medicaid certified beds.legal_business_name— The facility's legal business name, when it differs from its trade name.chain_name— The name of the chain this facility belongs to, when CMS's file identifies one.chain_id— CMS's id for the chain this facility belongs to, when one is identified.special_focus_status— Whether CMS has designated this facility a Special Focus Facility.changed_ownership_12mo— Whether ownership changed in the trailing 12 months, as CMS's file flags it.is_current— Whether this is the facility's current Provider Information record.source_file— The CMS Provider Information extract this row was read from.source_url— The CMS source this row was read from.
snf_cost_reports — Every Medicare cost report figure each facility filed for its latest report year, each with the worksheet, line and column it was printed on; confidence carries, beside it, the arithmetic check the filing passes or the difference the filing leaves.
396,970 rows
ccn— CMS Certification Number -- the id every other table here joins on.provider_name— The facility's name of record on the cost report.city— City, as the cost report prints it.state_code— State, USPS code.form— Which CMS cost report form this filing was made on.fiscal_year— The facility's fiscal year this report covers.fy_begin— Fiscal year start date.fy_end— Fiscal year end date.fy_days— Number of days in the fiscal year.report_status— CMS's status for this cost report filing (as-filed, settled, amended, etc.).proc_date— Date CMS processed this cost report.total_patient_revenue— Gross revenue from patient care, as filed.contractual_allowances— Contractual allowances and discounts deducted from gross revenue, as filed.net_patient_revenue— Patient revenue after contractual allowances, as filed.total_operating_expenses— Total operating expenses, as filed.net_income_from_patients— Net income from patient care activities, as filed.other_income_total— Non-patient income, as filed.net_income_after_other— Net income after non-patient income and expense, as filed.other_expenses_total— Non-patient expenses, as filed.income_taxes— Income taxes, as filed.net_income_final— Net income as the facility filed it, after taxes.total_facility_beds— Total licensed beds, as filed.bed_days_available— Total bed-days available in the cost reporting period.medicare_patient_days— Patient days attributable to Medicare.medicaid_patient_days— Patient days attributable to Medicaid.other_payer_patient_days— Patient days attributable to payers other than Medicare and Medicaid.total_patient_days— Total patient days in the period.medicare_discharges— Discharges attributable to Medicare.medicaid_discharges— Discharges attributable to Medicaid.other_payer_discharges— Discharges attributable to payers other than Medicare and Medicaid.total_discharges— Total discharges in the period.medicare_alos— Average length of stay, Medicare patients.medicaid_alos— Average length of stay, Medicaid patients.total_alos— Average length of stay, all patients.locators— The cost report worksheet, line and column each figure above was printed on.withheld— Whether a figure on this report was withheld rather than estimated, as this register flags it.confidence— CMS's own arithmetic-check note on this filing, when one is recorded.source_file— The CMS Healthcare Cost Report Information System extract this row was read from.source_url— The CMS source this row was read from.source_fy— The fiscal year of the cost report file this row was read from.
snf_staffing_quarters — Payroll-Based Journal staffing, per facility per quarter. Staffing is delivered in its own file, never beside a finance figure.
539,243 rows
ccn— CMS Certification Number -- the id every other table here joins on.cy_qtr— Calendar year and quarter this staffing record covers.quarter_end— Last date of the quarter.days_reported— Number of days in the quarter the facility reported payroll-based staffing for.resident_days— Total resident days in the quarter -- the denominator every hours-per-resident-day figure below divides by.rn_hours— Total registered nurse hours reported in the quarter.lpn_hours— Total licensed practical nurse hours reported in the quarter.aide_hours— Total nurse aide hours reported in the quarter.total_nurse_hours— Total nurse staffing hours (RN + LPN + aide) reported in the quarter.rn_hprd— Registered nurse hours per resident day.lpn_hprd— Licensed practical nurse hours per resident day.aide_hprd— Nurse aide hours per resident day.total_nurse_hprd— Total nurse hours per resident day.derivation— How this quarter's figures were derived (as filed, imputed, or otherwise), as CMS's file flags it.source_file— The CMS Payroll-Based Journal extract this row was read from.source_url— The CMS source this row was read from.
snf_inspections — Every recorded health and fire safety survey cycle.
45,657 rows
ccn— CMS Certification Number -- the id every other table here joins on.inspection_cycle— Which of the facility's survey cycles this row covers (CMS numbers each facility's cycles in sequence).health_survey_date— Date of the health survey in this cycle.fire_survey_date— Date of the fire safety survey in this cycle.total_health_deficiencies— Count of health deficiencies cited in this cycle.total_fire_deficiencies— Count of fire safety deficiencies cited in this cycle.source_file— The CMS Health Deficiencies/Survey extract this row was read from.source_url— The CMS source this row was read from.
snf_deficiencies — Every cited deficiency, as filed.
429,858 rows
ccn— CMS Certification Number -- the id every other table here joins on.survey_date— Date of the survey this deficiency was cited on.survey_type— Type of survey the deficiency was cited under (standard, complaint, etc.).deficiency_prefix— CMS's deficiency prefix code (which regulation group the tag belongs to).deficiency_category— CMS's deficiency category for this citation.deficiency_tag— CMS's F-tag (deficiency) code.deficiency_description— CMS's description of the cited deficiency.scope_severity— CMS's scope-and-severity grade for this citation.deficiency_corrected— Whether the facility corrected the deficiency, as CMS's file shows.correction_date— Date the deficiency was corrected, when filed.standard_deficiency— Whether this citation came from a standard (routine) survey.complaint_deficiency— Whether this citation came from a complaint investigation.infection_control— Whether this citation was an infection-control deficiency.source_file— The CMS Health Deficiencies extract this row was read from.source_url— The CMS source this row was read from.
snf_penalties — Every civil money penalty and payment-denial action.
16,208 rows
ccn— CMS Certification Number -- the id every other table here joins on.penalty_date— Date the penalty was imposed.penalty_type— CMS's penalty type (civil money penalty or payment denial).fine_id— CMS's id for this fine, when the penalty is a fine.fine_amount— Dollar amount of the fine, when the penalty is a fine.payment_denial_start— Date a payment-denial penalty began, when the penalty is a payment denial.payment_denial_days— Number of days of payment denial imposed, when the penalty is a payment denial.source_file— The CMS Penalties extract this row was read from.source_url— The CMS source this row was read from.
snf_owners — Care Compare's current ownership file. A blank field here follows CMS's own pause on the expanded Form CMS-855A ownership disclosure (guidance dated 11 December 2025) -- not a gap in this file.
251,314 rows, newest load read 2026-09-01
ccn— CMS Certification Number -- the id every other table here joins on.role— The owner's role at this facility (operator, officer/director, etc.), as CMS's file states it.owner_type— Whether the owner is an individual or an organization.owner_name— The owner's name of record.ownership_pct— Percentage ownership, when filed.association_date— Date the ownership association began, when filed.first_seen_file_date— Date of the first Care Compare ownership file this row was read from.last_seen_file_date— Date of the most recent Care Compare ownership file this row was confirmed on.is_current— Whether this is the facility's current ownership record.source_file— The CMS Ownership extract this row was read from.source_url— The CMS source this row was read from.
Sample built 2026-10-19T00:18:38Z (UTC).
Research engagements
A written study of one state or one health system, taking the register and the cost reports as far as they go on a question you set. The scope is agreed and published before the work starts, the finished study is published on this site, and the same scope is offered to anyone on either side of the question at the same price. From $15,000.
How the figures are built
Every figure is the one its source document printed, shown with the file it came from. The three shares that are divided and the positions that are ranked are named on one page. Nothing is estimated. How each figure is defined.
Who publishes this
VELARIONAI LLC · Andrew Richardson, founder. Corrections reach a person: hello@velarionrecords.com. About this publication.
If it is not what you needed
Full refund within 7 days, one click — a subscription from your own page, a report or a license from the link that delivered it. No trial to forget to cancel.
A question before you buy?
Tell us the scope and what you would use it for, and a person answers. Or write to hello@velarionrecords.com.
Ask about a license
Cite this data
The free register snapshot behind this license is deposited on Zenodo as a citable record: 10.5281/zenodo.23092077.
HRSA 340B covered-entity register, via hlth340b_entities. doi:10.5281/zenodo.23092077. https://velarionrecords.com/340b
Every figure in the file is the value its source document printed, with the file it came from and the date its publisher stamped inside it. How these figures are defined.