About this Dataset

Medicare Outpatient Hospitals - By Geography And Service

The Medicare Outpatient Hospitals by Geography and Service dataset provides information on services for Original Medicare Part B beneficiaries by OPPS hospitals. These datasets contain information on the number of services, payments, and submitted charges organized by geography and comprehensive Ambulatory Payment Classification (APC).
Organization: U.S. Department of Health & Human Services
Last updated: 2025-06-27T13:35:09.929446
Tags: health-care-use-payments, hospitals-facilities, medicare, national, original-medicare, outpatient-facilities, states-territories

Tables

Medicare Outpatient Hospitals - By Geography And Service : 2023-01-01

@usgov.hhs_gov_medicare_outpatient_hospitals_by_geography_and_fab541f1.medicare_outpatient_hospitals_by_geography_and_service_00bdb112

1.52 MB
90034 rows
15 columns


CREATE TABLE medicare_outpatient_hospitals_by_geography_and_service_00bdb112 (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" DOUBLE,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "srvc_lvl" VARCHAR,
  "apc_cd" BIGINT,
  "apc_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "bene_cnt" DOUBLE,
  "capc_srvcs" DOUBLE,
  "avg_tot_sbmtd_chrgs" DOUBLE,
  "avg_mdcr_alowd_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE,
  "outlier_srvcs" DOUBLE,
  "avg_mdcr_outlier_amt" DOUBLE
);