Hospital-price-transparency

prices that are easy to compare

@kaggle.natesutton_hospitalpricetransparency

Table List

3 tables(6.72 MB)

Concept

Hospital

Price

Hospital

@kaggle.natesutton_hospitalpricetransparency.hospital

14.78 KB
115 rows
8 columns

hospital_id Hospital Id	hospital_name Hospital Name	hospital_npi Hospital Npi	city City	state State	critical_access_ind Critical Access Ind	affiliation Affiliation	disclosure Disclosure
1	CarolinaEast Medical Center	1801852835	New Bern	NC		Independent	https://apps.para-hcfs.com/PTT/FinalLinks/CarolinaEast_V2.aspx#
2	Carteret Health Care	1760479331	Morehead City	NC		Independent	https://www.carterethealth.org/documents/content/CHC-Charge-Comparison.xlsx
3	Catawba Valley Medical Center	1164495255	Hickory	NC		Independent	https://www.catawbavalleyhealth.org/documents/560789196_CatawbaValleyMedicalCenter_StandardCharges.csv
4	Dosher Memorial Hospital	1326589649	Southport	NC	1	Independent	nan
5	Granville Medical Center	1326061730	Oxford	NC		Independent	https://www.ghshospital.org/Content/Uploads/GranvilleMedical/files/Transparency%20Chargemaster%20Charges%20effective%201.1.21.xls
6	Hugh Chatham Memorial Hospital	1942361308	Elkin	NC		Independent	https://www.hughchatham.org/wp-content/uploads/2020/10/HCMH-Chargemaster.pdf
7	Iredell Memorial Hospital	1588709596	Statesville	NC		Independent	https://res.cloudinary.com/dpmykpsih/raw/upload/iredell-health-system-site-359/media/r/987174c3c5b24b478553986b48984339/cdm_for_internet_10-1-2020.csv
8	North Carolina Specialty Hospital	1437221785	Durham	NC		Independent	https://docs.google.com/spreadsheets/d/118qzCAtylGIzNz1503k4aOkP5A1XOAEg/edit#gid=565460623
9	Northern Regional Hospital	1366449282	Mount Airy	NC		Independent	https://wearenorthern.org/wp-content/uploads/2020/10/NRH-Comprehensive-Chargemaster-2020.xlsx
10	Sampson Regional Medical Center	1609857432	Clinton	NC		Independent	https://apps.para-hcfs.com/PTT/FinalLinks/Sampson_V2.aspx#


CREATE TABLE hospital (
  "hospital_id" BIGINT,
  "hospital_name" VARCHAR,
  "hospital_npi" BIGINT,
  "city" VARCHAR,
  "state" VARCHAR,
  "critical_access_ind" BIGINT,
  "affiliation" VARCHAR,
  "disclosure" VARCHAR
);