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.855881
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.39 MB
664992 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

9.74 MB
800640 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

7.77 MB
784512 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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.29 MB
784512 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

8.73 MB
753792 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

9.99 MB
788928 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

9.82 MB
763584 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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.13 MB
770496 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

7.43 MB
748608 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

8.83 MB
702432 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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 2013 By Month And Water Source

@usgov.ca_gov_drinking_water_public_water_system_annually_rep_c0165ed6.produced_water_year_2013_by_month_and_water_source

4.93 MB
499752 rows
34 columns


CREATE TABLE produced_water_year_2013_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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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 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

6.73 MB
601920 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

8.53 MB
588888 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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.05 MB
589680 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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.08 MB
566136 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

8.82 MB
592488 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

8.38 MB
573192 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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.26 MB
577872 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

9.67 MB
655032 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

9.09 MB
614628 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

9.65 MB
1164744 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

16.02 MB
1402560 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

13.54 MB
1372392 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

13.45 MB
1373184 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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

15.13 MB
1318920 rows
34 columns


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_combined_service_connections_cb_in_sdwis" DOUBLE,
  "number_of_commercial_service_connections_cm_in_sdwis" DOUBLE,
  "number_of_institutional_service_connections_in_in_sdwis" DOUBLE,
  "number_of_residential_service_connections_rs_in_sdwis" DOUBLE,
  "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
);