About this Dataset

WA Ground Ambulance Locally Set Rates

This dataset provides the locally established and contracted rates for local governmental ground ambulance service organizations. RCW 48.49.205 Requires the WA Office of the Insurance Commissioner to collect and post the local rate data.
Organization: State of Washington
Last updated: 2024-11-01T20:25:13.365114
Tags: ambulance, balance-bill, insurance, insurance-commissioner, surprise-bill

Tables

Table 1

@usgov.state_of_washington_wa_ground_ambulance_locally_set_rates.table_1

34.84 kB
269 rows
18 columns

CREATE TABLE table_1 (
  "recorded_date" TIMESTAMP,
  "gaso_name" VARCHAR,
  "gaso_npi" BIGINT,
  "service_counties" VARCHAR,
  "service_zips" VARCHAR,
  "rate_type" VARCHAR,
  "contracted_ambulance_provider_npi" DOUBLE,
  "contracted_ambulance_provider_name" VARCHAR,
  "a0428_bls_ne" DOUBLE  -- A0428 (BLS-NE),
  "a0429_bls_e" DOUBLE  -- A0429 (BLS-E),
  "a0426_als1_ne" DOUBLE  -- A0426 (ALS1-NE),
  "a0427_als1_e" DOUBLE  -- A0427 (ALS1-E),
  "a0433_als2" DOUBLE  -- A0433 (ALS2),
  "a0434_sct" DOUBLE  -- A0434 (SCT),
  "a0998_non_tx" DOUBLE  -- A0998 (Non-TX),
  "a0425_mileage" DOUBLE  -- A0425 (Mileage),
  "effective_date" TIMESTAMP,
  "additional_comments" VARCHAR
);