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-10-07T07:18:35.321753
Tags: health-care-use-payments, health-equity, 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_18c355f3.medicare_outpatient_hospitals_by_geography_and_service_00bdb112

1.59 MB
90,034 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
);

Medicare Outpatient Hospitals - By Geography And Service : 2017-12-31

@usgov.hhs_gov_medicare_outpatient_hospitals_by_geography_and_18c355f3.medicare_outpatient_hospitals_by_geography_and_service_15e5527e

1.55 MB
86,083 rows
15 columns

CREATE TABLE medicare_outpatient_hospitals_by_geography_and_service_15e5527e (
  "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
);

Medicare Outpatient Hospitals - By Geography And Service : 2018-12-31

@usgov.hhs_gov_medicare_outpatient_hospitals_by_geography_and_18c355f3.medicare_outpatient_hospitals_by_geography_and_service_1a459223

1.66 MB
87,913 rows
15 columns

CREATE TABLE medicare_outpatient_hospitals_by_geography_and_service_1a459223 (
  "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
);

Medicare Outpatient Hospitals - By Geography And Service : 2016-12-31

@usgov.hhs_gov_medicare_outpatient_hospitals_by_geography_and_18c355f3.medicare_outpatient_hospitals_by_geography_and_service_1e5e255b

572.45 kB
27,828 rows
15 columns

CREATE TABLE medicare_outpatient_hospitals_by_geography_and_service_1e5e255b (
  "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
);

Medicare Outpatient Hospitals - By Geography And Service : 2022-12-01

@usgov.hhs_gov_medicare_outpatient_hospitals_by_geography_and_18c355f3.medicare_outpatient_hospitals_by_geography_and_service_2e6403a0

1.66 MB
90,591 rows
15 columns

CREATE TABLE medicare_outpatient_hospitals_by_geography_and_service_2e6403a0 (
  "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
);

Medicare Outpatient Hospitals - By Geography And Service : 2015-12-31

@usgov.hhs_gov_medicare_outpatient_hospitals_by_geography_and_18c355f3.medicare_outpatient_hospitals_by_geography_and_service_37d271e6

253.63 kB
9,902 rows
15 columns

CREATE TABLE medicare_outpatient_hospitals_by_geography_and_service_37d271e6 (
  "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
);

Medicare Outpatient Hospitals - By Geography And Service : 2020-12-02

@usgov.hhs_gov_medicare_outpatient_hospitals_by_geography_and_18c355f3.medicare_outpatient_hospitals_by_geography_and_service_690d09a5

1.59 MB
90,183 rows
15 columns

CREATE TABLE medicare_outpatient_hospitals_by_geography_and_service_690d09a5 (
  "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
);

Medicare Outpatient Hospitals - By Geography And Service : 2021-12-02

@usgov.hhs_gov_medicare_outpatient_hospitals_by_geography_and_18c355f3.medicare_outpatient_hospitals_by_geography_and_service_7160058c

1.69 MB
94,740 rows
15 columns

CREATE TABLE medicare_outpatient_hospitals_by_geography_and_service_7160058c (
  "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
);

Medicare Outpatient Hospitals - By Geography And Service : 2019-12-31

@usgov.hhs_gov_medicare_outpatient_hospitals_by_geography_and_18c355f3.medicare_outpatient_hospitals_by_geography_and_service_8077a4f1

1.75 MB
92,481 rows
15 columns

CREATE TABLE medicare_outpatient_hospitals_by_geography_and_service_8077a4f1 (
  "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
);