About this Dataset

WA-APCD Quality And Cost Summary Report: County Cost

WA-APCD - Washington All-Payer 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:19:48.755260

Tables

Table 1

@usgov.state_of_washington_wa_apcd_quality_and_cost_summary_r_2441d76f.table_1

21.84 kB
1,069 rows
11 columns

CREATE TABLE table_1 (
  "summarization_level" VARCHAR,
  "name" VARCHAR,
  "organization_city" VARCHAR,
  "organization_zip" VARCHAR,
  "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
);