IPPS DRG Provider Summary

Average Discharges, Charges, and Medicare Payments

@kaggle.thedevastator_ipps_drg_provider_summary

Table List

2 tables(6.15 MB)

Inpatient Prospective Payment System Ipps Provider Sum 59503f2f

N 97k6 Zzx3

@kaggle.thedevastator_ipps_drg_provider_summary.n_97k6_zzx3

89.52 KB
1000 rows
13 columns

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


CREATE TABLE n_97k6_zzx3 (
  "index" BIGINT,
  "provider_state" VARCHAR,
  "drg_definition" VARCHAR,
  "average_medicare_payments" DOUBLE,
  "hospital_referral_region_description" VARCHAR,
  "provider_id" BIGINT,
  "provider_city" VARCHAR,
  "provider_zip_code" BIGINT,
  "total_discharges" BIGINT,
  "provider_name" VARCHAR,
  "average_covered_charges" DOUBLE,
  "provider_street_address" VARCHAR,
  "average_medicare_payments_2" DOUBLE
);