Dataset: Medicare Outpatient Hospitals - By Provider And Service

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: 2022-01-25T02:03:58.108941
Tags: health-care-use-payments, hospitals-facilities, medicare, original-medicare, outpatient-facilities

Tables

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

@usgov.hhs_gov_medicare_outpatient_hospitals_by_provider_and__e4833b08.medicare_outpatient_hospitals_by_provider_and_service__e1d18d67

2.24 MB
110477 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
);

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

@usgov.hhs_gov_medicare_outpatient_hospitals_by_provider_and__e4833b08.medicare_outpatient_hospitals_by_provider_and_service__c867b8d0

2.2 MB
110462 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 : 2016-12-31

@usgov.hhs_gov_medicare_outpatient_hospitals_by_provider_and__e4833b08.medicare_outpatient_hospitals_by_provider_and_service__5ca2cb7a

1.14 MB
54909 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 : 2015-12-31

@usgov.hhs_gov_medicare_outpatient_hospitals_by_provider_and__e4833b08.medicare_outpatient_hospitals_by_provider_and_service__2d0f7714

651.58 KB
33326 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
);