OpenHealth newsroom data kit: Kapaa, HI Release date: 2026-11-21 Publisher: OpenHealth, https://getopenhealth.org/newsroom You can download the files for free, and you do not need an account. This area is the Kapaa, HI micropolitan statistical area (CBSA 28180) in the Census Bureau delineation file of July 2023. Files in this folder: hospitals.csv prices.csv is absent when fewer than two hospitals in this area list a cash price for the same code in their own price files. doctors.csv is absent when the model scores no doctor in this area for the five rated operations. Sources: CMS Hospital General Information provides the name, city, type, ownership type, and overall star rating. https://data.cms.gov/provider-data/dataset/xubh-q36u (2026-11-18) CMS Hospital Enrollments links each CMS Certification Number to its enrolled organization. https://data.cms.gov/provider-characteristics/hospitals-and-other-facilities/hospital-enrollments (2026-10-01) CMS Hospital All Owners provides the private equity flag. https://data.cms.gov/provider-characteristics/hospitals-and-other-facilities/hospital-all-owners (2026-10-01) CMS Hospital Change of Ownership provides the latest change of ownership. https://data.cms.gov/provider-characteristics/hospitals-and-other-facilities/hospital-change-of-ownership (2026-09-01) Hospital price files are published under the CMS hospital price transparency rule and loaded by OpenHealth. https://getopenhealth.org/prices (2026-11-21) OpenHealth doctor ratings use model ml-4. https://getopenhealth.org/method U.S. Census Bureau core-based statistical area delineation file, July 2023, based on OMB delineations (areas and the counties in them) https://www2.census.gov/programs-surveys/metro-micro/geographies/reference-files/2023/delineation-files/list1_2023.xlsx (2026-11-21) US Census Bureau 2024 Gazetteer place and ZIP code points provide the area distances. https://www.census.gov/geographies/reference-files/time-series/geo/gazetteer-files.html Columns: hospitals.csv area: The area: a CBSA title, or for an area outside any CBSA, its anchor city. ccn: The CMS Certification Number identifies the hospital. hospital: The hospital name comes from its CMS record. city: The city comes from the hospital's CMS record. state: The state comes from the hospital's CMS record. cbsa_code: The CBSA code of the hospital's county in the Census Bureau delineation file. Blank when the county is in no CBSA or does not match one. cbsa_title: The title of that CBSA. hospital_type: The hospital type comes from CMS Hospital General Information. cms_ownership_type: The ownership type comes from CMS Hospital General Information. cms_star_rating: The CMS overall star rating ranges from 1 to 5. The field is blank when CMS published no rating. private_equity_flag: The field is yes when the CMS All Owners file flags an owner as a private equity company. The field is no when it flags no organization owner. The field is blank when the file has no flag for this hospital. A blank or a no does not mean there is no private equity owner. last_ownership_change_date: The date is the latest change of ownership listed in the CMS Change of Ownership file since 2016-01-01. The field is blank when the file lists none. last_ownership_change_type: The type is the change type that CMS wrote. price_file_loaded: The field is yes when OpenHealth has loaded this hospital's own price file. profile_url: The URL points to the hospital's OpenHealth page. embed_url: The URL points to the public embed card that already exists for this hospital or this list. Rules: An area is a core-based statistical area (CBSA) in the Census Bureau delineation file of July 2023 that holds at least one hospital whose price file OpenHealth has loaded. A hospital joins an area by the county on its CMS record. A doctor joins an area by office city. OpenHealth places the doctor by the county of the CMS hospitals in that city or by the county of the nearest CMS hospital within 10 miles. If a priced hospital's county is in no CBSA, its area is the hospital's city and everything within 25 miles that is also in no CBSA. OpenHealth measures that radius between US Census points. A blank cell means the source published no value. A blank cell is never zero. A price is the hospital's own published cash price, not a quote for any patient. A doctor rating describes predicted results at the hospitals with which the doctor is affiliated, not the doctor's own skill. The method is documented at https://getopenhealth.org/method Rows are sorted by name. The data ranks nothing by price. Cite as: OpenHealth, newsroom data kit, Kapaa, HI, release 2026-11-21, https://getopenhealth.org/newsroom