About this Dataset

Medicare Outpatient Hospitals - By Provider And Service

The Medicare Outpatient Hospitals by Provider 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 provider CMS Certified Number (CCN) and comprehensive Ambulatory Payment Classification (APC).
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:21:03.576561
Tags: health-care-use-payments, health-equity, hospitals-facilities, medicare, original-medicare, outpatient-facilities

Tables

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

@usgov.hhs_gov_medicare_outpatient_hospitals_by_provider_and__920819ab.medicare_outpatient_hospitals_by_provider_and_service__2d0f7714

667.23 kB
33,326 rows
18 columns

CREATE TABLE medicare_outpatient_hospitals_by_provider_and_service__2d0f7714 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "apc_cd" BIGINT,
  "apc_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 Provider And Service : 2023-01-02

@usgov.hhs_gov_medicare_outpatient_hospitals_by_provider_and__920819ab.medicare_outpatient_hospitals_by_provider_and_service__4414a8d8

2.41 MB
116,799 rows
18 columns

CREATE TABLE medicare_outpatient_hospitals_by_provider_and_service__4414a8d8 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "apc_cd" BIGINT,
  "apc_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 Provider And Service : 2016-12-31

@usgov.hhs_gov_medicare_outpatient_hospitals_by_provider_and__920819ab.medicare_outpatient_hospitals_by_provider_and_service__5ca2cb7a

1.19 MB
54,909 rows
18 columns

CREATE TABLE medicare_outpatient_hospitals_by_provider_and_service__5ca2cb7a (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "apc_cd" BIGINT,
  "apc_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 Provider And Service : 2017-12-31

@usgov.hhs_gov_medicare_outpatient_hospitals_by_provider_and__920819ab.medicare_outpatient_hospitals_by_provider_and_service__c867b8d0

2.31 MB
110,462 rows
18 columns

CREATE TABLE medicare_outpatient_hospitals_by_provider_and_service__c867b8d0 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "apc_cd" BIGINT,
  "apc_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 Provider And Service : 2018-12-31

@usgov.hhs_gov_medicare_outpatient_hospitals_by_provider_and__920819ab.medicare_outpatient_hospitals_by_provider_and_service__e1d18d67

2.35 MB
110,477 rows
18 columns

CREATE TABLE medicare_outpatient_hospitals_by_provider_and_service__e1d18d67 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "apc_cd" BIGINT,
  "apc_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
);