About this Dataset

WA-APCD Quality And Cost Summary Report: Practice Quality

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:20:29.558670

Tables

Table 1

@usgov.state_of_washington_wa_apcd_quality_and_cost_summary_r_894ba2b4.table_1

110.58 kB
7,972 rows
16 columns

CREATE TABLE table_1 (
  "summarization_level" VARCHAR,
  "name" VARCHAR,
  "organization_city" VARCHAR,
  "organization_zip" DOUBLE,
  "product_type" VARCHAR,
  "measure_code" VARCHAR,
  "measure_description" VARCHAR,
  "measure_component" VARCHAR,
  "measure_summary_units" VARCHAR,
  "age_stratification" VARCHAR,
  "measure_result" DOUBLE,
  "lower_95_ci" DOUBLE,
  "upper_95_ci" DOUBLE,
  "reporting_period_begin_dt" VARCHAR,
  "reporting_period_end_dt" VARCHAR,
  "performance_category" VARCHAR
);