Hospital-price-transparency

prices that are easy to compare

@kaggle.natesutton_hospitalpricetransparency

Concept

@kaggle.natesutton_hospitalpricetransparency.concept

concept_id Concept Id	concept_code Concept Code	vocabulary_id Vocabulary Id	concept_name Concept Name
43533189	CH	HCPCS	0 percent impaired, limited or restricted
43533250	CN	HCPCS	100 percent impaired, limited or restricted
40664799	G8707	HCPCS	12-lead electrocardiogram (ecg) not performed, reason not given
40664798	G8704	HCPCS	12-lead electrocardiogram (ecg) performed
40218804	U0002	HCPCS	2019-ncov coronavirus, sars-cov-2/2019-ncov (covid-19), any technique, multiple types or subtypes (includes all targets), non-cdc
704058	U0004	HCPCS	2019-nCoV Coronavirus, SARS-CoV-2/2019-nCoV (COVID-19), any technique, multiple types or subtypes (includes all targets), non-CDC, making use of high throughput technologies as described by CMS-2020-01-R
40217535	K0082	HCPCS	22 nf non-sealed lead acid battery, each
40217536	K0083	HCPCS	22 nf sealed lead acid battery, each (e.g., gel cell, absorbed glass mat)
953362	M1008	HCPCS	<50% of total number of a patient's outpatient ra encounters assessed
953363	M1007	HCPCS	>=50% of total number of a patient's outpatient ra encounters assessed


CREATE TABLE concept (
  "concept_id" BIGINT,
  "concept_code" VARCHAR,
  "vocabulary_id" VARCHAR,
  "concept_name" VARCHAR
);