Baselight
Sign In

Drinking Water - Public Water System Annually Reported Water Production And Delivery Information 2013-2022

State of California

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6

Loading...
Loading...

About this Dataset

Drinking Water - Public Water System Annually Reported Water Production And Delivery Information 2013-2022

Amount of water produced by month and by source and the water delivered by type of use and by month for every Public Water System (PWS) reporting. Public Water Systems submit their annual inventory information using the electronic Annual Report (eAR) submission process. The electronic Annual Report (eAR) is a survey of public water systems, currently required annually, to collect critical water system information intended to assess the status of compliance with specific regulatory requirements such as source water capacity, provides updated contact and inventory information (such as population and number of service connections). The specific dataset is section 6 of the eAR for the years 2013-2022 (both included) that collects the water produced by month and by source and the water delivered by type of use and by month for every water system reporting. It also includes facility public information details from the SDWIS database as metadata associated to the dataset. More information about the eAR required reporting here: https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/ear.html . A "Public Water System" means a system for the provision of water for human consumption through pipes or other constructed conveyances that has 15 or more service connections or regularly serves at least 25 individuals daily at least 60 days out of the year.
Organization: State of California
Last updated: 2024-11-27T01:19:51.855882
Tags: drinking-water, electronic-annual-report, sources-of-drinking-water, urban-water-produced, urban-water-reporting, urban-water-use, water-delivered, where-is-my-water-coming-from

Tables

Delivered Water – YEAR 2013 By Month And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.delivered_water_year_2013_by_month_and_connection_type_0fee4a4e
  • 5.73 MB
  • 664,992 rows
  • 34 columns
Loading... 
CREATE TABLE delivered_water_year_2013_by_month_and_connection_type_0fee4a4e (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Delivered Water – YEAR 2014 By Month And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.delivered_water_year_2014_by_month_and_connection_type_08c5b36f
  • 10.31 MB
  • 800,640 rows
  • 34 columns
Loading... 
CREATE TABLE delivered_water_year_2014_by_month_and_connection_type_08c5b36f (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Delivered Water – YEAR 2015 By Month And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.delivered_water_year_2015_by_month_and_connection_type_4781f8dd
  • 8.28 MB
  • 784,512 rows
  • 34 columns
Loading... 
CREATE TABLE delivered_water_year_2015_by_month_and_connection_type_4781f8dd (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Delivered Water – YEAR 2016 By Month And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.delivered_water_year_2016_by_month_and_connection_type_787210f2
  • 7.74 MB
  • 784,512 rows
  • 34 columns
Loading... 
CREATE TABLE delivered_water_year_2016_by_month_and_connection_type_787210f2 (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" BIGINT
);

Delivered Water – YEAR 2017 By Month And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.delivered_water_year_2017_by_month_and_connection_type_51bacff0
  • 9.25 MB
  • 753,792 rows
  • 34 columns
Loading... 
CREATE TABLE delivered_water_year_2017_by_month_and_connection_type_51bacff0 (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Delivered Water – YEAR 2018 By Month And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.delivered_water_year_2018_by_month_and_connection_type_9fe5047e
  • 10.59 MB
  • 788,928 rows
  • 34 columns
Loading... 
CREATE TABLE delivered_water_year_2018_by_month_and_connection_type_9fe5047e (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Delivered Water – YEAR 2019 By Month And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.delivered_water_year_2019_by_month_and_connection_type_f8c35d0e
  • 10.44 MB
  • 763,584 rows
  • 34 columns
Loading... 
CREATE TABLE delivered_water_year_2019_by_month_and_connection_type_f8c35d0e (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" BIGINT
);

Delivered Water – YEAR 2020 By Month And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.delivered_water_year_2020_by_month_and_connection_type_e7e4bbe9
  • 10.65 MB
  • 770,496 rows
  • 34 columns
Loading... 
CREATE TABLE delivered_water_year_2020_by_month_and_connection_type_e7e4bbe9 (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Delivered Water – YEAR 2021 By Month And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.delivered_water_year_2021_by_month_and_connection_type_4fe7c635
  • 8.12 MB
  • 748,608 rows
  • 34 columns
Loading... 
CREATE TABLE delivered_water_year_2021_by_month_and_connection_type_4fe7c635 (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Delivered Water – YEAR 2022 By Month And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.delivered_water_year_2022_by_month_and_connection_type_74381d8e
  • 9.99 MB
  • 702,432 rows
  • 34 columns
Loading... 
CREATE TABLE delivered_water_year_2022_by_month_and_connection_type_74381d8e (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" BIGINT,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Produced Water – YEAR 2014 By Month And Water Source

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.produced_water_year_2014_by_month_and_water_source
  • 7.21 MB
  • 601,920 rows
  • 34 columns
Loading... 
CREATE TABLE produced_water_year_2014_by_month_and_water_source (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Produced Water – YEAR 2015 By Month And Water Source

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.produced_water_year_2015_by_month_and_water_source
  • 9.18 MB
  • 588,888 rows
  • 34 columns
Loading... 
CREATE TABLE produced_water_year_2015_by_month_and_water_source (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Produced Water – YEAR 2016 By Month And Water Source

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.produced_water_year_2016_by_month_and_water_source
  • 8.66 MB
  • 589,680 rows
  • 34 columns
Loading... 
CREATE TABLE produced_water_year_2016_by_month_and_water_source (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" BIGINT
);

Produced Water – YEAR 2017 By Month And Water Source

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.produced_water_year_2017_by_month_and_water_source
  • 8.7 MB
  • 566,136 rows
  • 34 columns
Loading... 
CREATE TABLE produced_water_year_2017_by_month_and_water_source (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Produced Water – YEAR 2018 By Month And Water Source

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.produced_water_year_2018_by_month_and_water_source
  • 9.5 MB
  • 592,488 rows
  • 34 columns
Loading... 
CREATE TABLE produced_water_year_2018_by_month_and_water_source (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Produced Water – YEAR 2019 By Month And Water Source

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.produced_water_year_2019_by_month_and_water_source
  • 9.01 MB
  • 573,192 rows
  • 34 columns
Loading... 
CREATE TABLE produced_water_year_2019_by_month_and_water_source (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" BIGINT
);

Produced Water – YEAR 2020 By Month And Water Source

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.produced_water_year_2020_by_month_and_water_source
  • 9.76 MB
  • 577,872 rows
  • 34 columns
Loading... 
CREATE TABLE produced_water_year_2020_by_month_and_water_source (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Produced Water – YEAR 2021 By Month And Water Source

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.produced_water_year_2021_by_month_and_water_source
  • 10.49 MB
  • 655,032 rows
  • 34 columns
Loading... 
CREATE TABLE produced_water_year_2021_by_month_and_water_source (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Produced Water – YEAR 2022 By Month And Water Source

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.produced_water_year_2022_by_month_and_water_source
  • 10.38 MB
  • 614,628 rows
  • 34 columns
Loading... 
CREATE TABLE produced_water_year_2022_by_month_and_water_source (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" BIGINT,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Urban Water Produced And Delivered – YEAR 2013 By Month And Water Source Type And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.urban_water_produced_and_delivered_year_2013_by_month__570a8055
  • 10.26 MB
  • 1,164,744 rows
  • 34 columns
Loading... 
CREATE TABLE urban_water_produced_and_delivered_year_2013_by_month__570a8055 (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Urban Water Produced And Delivered – YEAR 2014 By Month And Water Source Type And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.urban_water_produced_and_delivered_year_2014_by_month__5ebe1191
  • 17.08 MB
  • 1,402,560 rows
  • 34 columns
Loading... 
CREATE TABLE urban_water_produced_and_delivered_year_2014_by_month__5ebe1191 (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Urban Water Produced And Delivered – YEAR 2015 By Month And Water Source Type And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.urban_water_produced_and_delivered_year_2015_by_month__1bd9959a
  • 14.47 MB
  • 1,372,392 rows
  • 34 columns
Loading... 
CREATE TABLE urban_water_produced_and_delivered_year_2015_by_month__1bd9959a (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Urban Water Produced And Delivered – YEAR 2016 By Month And Water Source Type And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.urban_water_produced_and_delivered_year_2016_by_month__5f583f23
  • 14.4 MB
  • 1,373,184 rows
  • 34 columns
Loading... 
CREATE TABLE urban_water_produced_and_delivered_year_2016_by_month__5f583f23 (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" BIGINT
);

Urban Water Produced And Delivered – YEAR 2017 By Month And Water Source Type And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.urban_water_produced_and_delivered_year_2017_by_month__c65541c4
  • 16.13 MB
  • 1,318,920 rows
  • 34 columns
Loading... 
CREATE TABLE urban_water_produced_and_delivered_year_2017_by_month__c65541c4 (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Urban Water Produced And Delivered – YEAR 2018 By Month And Water Source Type And Connection Type (water Use Type)

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.urban_water_produced_and_delivered_year_2018_by_month__46e0602c
  • 14.77 MB
  • 1,379,400 rows
  • 34 columns
Loading... 
CREATE TABLE urban_water_produced_and_delivered_year_2018_by_month__46e0602c (
  "ear_url" VARCHAR,
  "regulating_agency" VARCHAR,
  "water_system_name" VARCHAR,
  "principal_county_served" VARCHAR,
  "federal_water_system_type" VARCHAR,
  "state_water_system_type" VARCHAR,
  "system_status" VARCHAR,
  "owner_type" VARCHAR,
  "primary_water_source_type" VARCHAR,
  "residential_population_in_sdwis" DOUBLE,
  "non_transient_population_in_sdwis" DOUBLE,
  "transient_population_in_sdwis" DOUBLE,
  "total_population_in_sdwis" DOUBLE,
  "number_of_agricultural_service_connections_ag_in_sdwis" DOUBLE  -- Number Of Agricultural Service Connections (AG) IN SDWIS,
  "number_of_combined_service_connections_cb_in_sdwis" DOUBLE  -- Number Of Combined Service Connections (CB) IN SDWIS,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE  -- Number Of Commercial Service Connections (CM) IN SDWIS,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE  -- Number Of Institutional Service Connections (IN) IN SDWIS,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE  -- Number Of Residential Service Connections (RS) IN SDWIS,
  "total_number_of_service_connections_in_sdwis" DOUBLE,
  "city" VARCHAR,
  "treatment_plant_class" VARCHAR,
  "distribution_system_class" VARCHAR,
  "pwsid" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "datestartofmonth" TIMESTAMP,
  "water_produced_or_delivered" VARCHAR,
  "typecode" VARCHAR,
  "typename" VARCHAR,
  "units_of_measure_as_reported" VARCHAR,
  "quantity_as_in_units_reported" DOUBLE,
  "calculated_quantity_in_af" DOUBLE,
  "calculated_quantity_in_gallons" DOUBLE,
  "connections" DOUBLE
);

Share link

Anyone who has the link will be able to view this.