About this Dataset

WA-APCD Quality And Cost Summary Report: Facility Cost

WA-APCD - Washington All Payers Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.
Organization: State of Washington
Last updated: 2020-11-10T17:21:28.663494

Tables

Table 1

@usgov.state_of_washington_wa_apcd_quality_and_cost_summary_r_4e344d4e.table_1

92.37 kB
3,239 rows
11 columns

CREATE TABLE table_1 (
  "summarization_level" VARCHAR,
  "name" VARCHAR,
  "organization_city" VARCHAR,
  "organization_zip" DOUBLE,
  "service_description" VARCHAR,
  "service_method_name" VARCHAR,
  "median_allowed_amt" DOUBLE,
  "lower_25_allowed_amt" DOUBLE,
  "upper_75_allowed_amt" DOUBLE,
  "reporting_period_begin_dt" VARCHAR,
  "reporting_period_end_dt" VARCHAR
);