About this Dataset

Drinking Water - Public Water Systems Rates Information

Public Water Systems (PWS) submit their annual reports with rate information using the Electronic Annual Report (EAR) submission process on the Drinking Water Information Clearinghouse (DRINC) portal, which is reviewed, and manually updated into the Safe Drinking Water Information System (SDWIS). This includes the water rates reported by PWS in the EAR for years 2014 and 2015.
Organization: State of California
Last updated: 2021-09-08T16:15:25.776154
Tags: calwater, drinking-water, water, water-rates

Tables

Drinking Water - PWS Water Rates 2014-15

@usgov.ca_gov_drinking_water_public_water_systems_rates_information.drinking_water_pws_water_rates_2014_15

907.1 kB
13,387 rows
89 columns

CREATE TABLE drinking_water_pws_water_rates_2014_15 (
  "pwsid" VARCHAR,
  "water_system_name" VARCHAR,
  "water_system_classification" VARCHAR,
  "water_system_ownership" VARCHAR,
  "physical_location_address_1" VARCHAR,
  "physical_location_address_2" VARCHAR,
  "physical_location_city" VARCHAR,
  "physical_location_zip" VARCHAR,
  "website_url" VARCHAR,
  "population_res" VARCHAR,
  "wr_type_code" VARCHAR,
  "water_rate_type" VARCHAR,
  "wr_num_tiers" VARCHAR,
  "wr_rate_updated" VARCHAR,
  "wr_rate_changes" VARCHAR,
  "wr_frequency" VARCHAR,
  "wr_new_connection_fee" VARCHAR,
  "wr_connection_fee_updated" VARCHAR,
  "wr_sf_fbr" VARCHAR,
  "wr_sf_amt_per_hcf" VARCHAR,
  "wr_sf_amt_low" VARCHAR,
  "wr_sf_amt_high" VARCHAR,
  "wr_sf_amt_per_hcf_low" VARCHAR,
  "wr_sf_amt_per_hcf_high" VARCHAR,
  "wr_mf_fbr" VARCHAR,
  "wr_mf_amt_per_hcf" VARCHAR,
  "wr_mf_amt_low" VARCHAR,
  "wr_mf_amt_high" VARCHAR,
  "wr_mf_amt_per_hcf_low" VARCHAR,
  "wr_mf_amt_per_hcf_high" VARCHAR,
  "wr_subsidies" VARCHAR,
  "wr_s_fbr" VARCHAR,
  "water_rates_lifeline_uur_volume" VARCHAR,
  "wr_s_amt_low" VARCHAR,
  "wr_s_amt_high" VARCHAR,
  "wr_s_amt_per_hcf_low" VARCHAR,
  "wr_s_amt_per_hcf_high" VARCHAR,
  "wr_s_amt_percent" VARCHAR,
  "wr_ci_fbr" VARCHAR,
  "wr_ci_amt_per_hcf" VARCHAR,
  "wr_ci_amt_low" VARCHAR,
  "wr_ci_amt_high" VARCHAR,
  "wr_ci_amt_per_hcf_low" VARCHAR,
  "wr_ci_amt_per_hcf_high" VARCHAR,
  "wr_i_fbr" VARCHAR,
  "wr_i_amt_per_hcf" VARCHAR,
  "wr_i_amt_low" VARCHAR,
  "wr_i_amt_high" VARCHAR,
  "wr_i_amt_per_hcf_low" VARCHAR,
  "wr_i_amt_per_hcf_high" VARCHAR,
  "wr_li_fbr" VARCHAR,
  "wr_li_amt_per_hcf" VARCHAR,
  "wr_li_amt_low" VARCHAR,
  "wr_li_amt_high" VARCHAR,
  "wr_li_amt_per_hcf_low" VARCHAR,
  "wr_li_amt_per_hcf_high" VARCHAR,
  "wr_ai_fbr" VARCHAR,
  "wr_ai_amt_per_hcf" VARCHAR,
  "wr_ai_amt_low" VARCHAR,
  "wr_ai_amt_high" VARCHAR,
  "wr_ai_amt_per_hcf_low" VARCHAR,
  "wr_ai_amt_per_hcf_high" VARCHAR,
  "wr_o_fbr" VARCHAR,
  "wr_o_amt_per_hcf" VARCHAR,
  "wr_o_amt_low" VARCHAR,
  "wr_o_amt_high" VARCHAR,
  "wr_o_amt_per_hcf_low" VARCHAR,
  "wr_o_amt_per_hcf_high" VARCHAR,
  "wr_fs_surcharges" VARCHAR,
  "wr_fs_fbr" VARCHAR,
  "wr_fs_amt_per_hcf" VARCHAR,
  "wr_fs_amt_low" VARCHAR,
  "wr_fs_amt_high" VARCHAR,
  "wr_fs_amt_per_hcf_low" VARCHAR,
  "wr_fs_amt_per_hcf_high" VARCHAR,
  "wr_other_surcharges" VARCHAR,
  "wr_other_surcharges_description" VARCHAR,
  "wr_os_fbr" VARCHAR,
  "wr_os_amt_per_hcf" VARCHAR,
  "wr_os_amt_low" VARCHAR,
  "wr_os_amt_high" VARCHAR,
  "wr_os_amt_per_hcf_low" VARCHAR,
  "wr_os_amt_per_hcf_high" VARCHAR,
  "wr_avg_mon_res_cost" VARCHAR,
  "wr_avg_mon_res_cost_6_ccf" VARCHAR,
  "wr_avg_mon_res_cost_12_ccf" VARCHAR,
  "wr_avg_mon_res_cost_24_ccr" VARCHAR,
  "system" VARCHAR,
  "ear_year" BIGINT
);