Hospital Charges In America

Hospital Expenses in America!

@kaggle.dhirajnirne_hospital_charges_in_america

Table List

1 table(5.17 MB)

Hospital Charges

@kaggle.dhirajnirne_hospital_charges_in_america.hospital_charges

5.17 MB
163065 rows
12 columns

drg_definition DRG Definition	provider_id Provider Id	provider_name Provider Name	provider_street_address Provider Street Address	provider_city Provider City	provider_state Provider State	provider_zip_code Provider Zip Code	hospital_referral_region_description Hospital Referral Region Description	n__total_discharges Total Discharges	n__average_covered_charges Average Covered Charges	n__average_total_payments Average Total Payments	average_medicare_payments Average Medicare Payments
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10001	SOUTHEAST ALABAMA MEDICAL CENTER	1108 ROSS CLARK CIRCLE	DOTHAN	AL	36301	AL - Dothan	91	$32963.07	$5777.24	$4763.73
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10005	MARSHALL MEDICAL CENTER SOUTH	2505 U S HIGHWAY 431 NORTH	BOAZ	AL	35957	AL - Birmingham	14	$15131.85	$5787.57	$4976.71
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10006	ELIZA COFFEE MEMORIAL HOSPITAL	205 MARENGO STREET	FLORENCE	AL	35631	AL - Birmingham	24	$37560.37	$5434.95	$4453.79
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10011	ST VINCENT'S EAST	50 MEDICAL PARK EAST DRIVE	BIRMINGHAM	AL	35235	AL - Birmingham	25	$13998.28	$5417.56	$4129.16
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10016	SHELBY BAPTIST MEDICAL CENTER	1000 FIRST STREET NORTH	ALABASTER	AL	35007	AL - Birmingham	18	$31633.27	$5658.33	$4851.44
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10023	BAPTIST MEDICAL CENTER SOUTH	2105 EAST SOUTH BOULEVARD	MONTGOMERY	AL	36116	AL - Montgomery	67	$16920.79	$6653.80	$5374.14
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10029	EAST ALABAMA MEDICAL CENTER AND SNF	2000 PEPPERELL PARKWAY	OPELIKA	AL	36801	AL - Birmingham	51	$11977.13	$5834.74	$4761.41
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10033	UNIVERSITY OF ALABAMA HOSPITAL	619 SOUTH 19TH STREET	BIRMINGHAM	AL	35233	AL - Birmingham	32	$35841.09	$8031.12	$5858.50
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10039	HUNTSVILLE HOSPITAL	101 SIVLEY RD	HUNTSVILLE	AL	35801	AL - Huntsville	135	$28523.39	$6113.38	$5228.40
039 - EXTRACRANIAL PROCEDURES W/O CC/MCC	10040	GADSDEN REGIONAL MEDICAL CENTER	1007 GOODYEAR AVENUE	GADSDEN	AL	35903	AL - Birmingham	34	$75233.38	$5541.05	$4386.94


CREATE TABLE hospital_charges (
  "drg_definition" VARCHAR,
  "provider_id" BIGINT,
  "provider_name" VARCHAR,
  "provider_street_address" VARCHAR,
  "provider_city" VARCHAR,
  "provider_state" VARCHAR,
  "provider_zip_code" BIGINT,
  "hospital_referral_region_description" VARCHAR,
  "n__total_discharges" BIGINT,
  "n__average_covered_charges" VARCHAR,
  "n__average_total_payments" VARCHAR,
  "average_medicare_payments" VARCHAR
);