About this Dataset

COVID-19 Wastewater Surveillance Data. California

The California Department of Public Health (CDPH) and the California State Water Resources Control Board (SWRCB) together are coordinating with several wastewater utilities, local health departments, universities, and laboratories in California on wastewater surveillance for SARS-CoV-2, the virus causing COVID-19. Data collected from this network of participants, called the California Surveillance of Wastewater Systems (Cal-SuWers) Network, are submitted to the U.S. Centers for Disease Control and Prevention (CDC) National Wastewater Surveillance System (NWSS).

During the COVID-19 pandemic, it has been used for the detection and quantification of SARS-CoV-2 virus shed into wastewater via feces of infected persons. Wastewater surveillance tracks ""pooled samples"" that reflect the overall disease activity for a community serviced by the wastewater treatment plant (an area known as a ""sewershed""), rather than tracking samples from individual people. Notably, while SARS-CoV-2 virus is shed fecally by infected persons, COVID-19 is spread primarily through the respiratory route, and there is no evidence to date that exposure to treated or untreated wastewater has led to infection with COVID-19.

Collecting and analyzing wastewater samples for the overall amount of SARS-CoV-2 viral particles present can help inform public health about the level of viral transmission within a community. Data from wastewater testing are not intended to replace existing COVID-19 surveillance systems, but are meant to complement them. While wastewater surveillance cannot determine the exact number of infected persons in the area being monitored, it can provide the overall trend of virus concentration within that community. With our local partners, the SWRCB and CDPH are currently monitoring and quantifying levels of SARS-CoV-2 at the headworks or ""influent"" of 21 wastewater treatment plants representing approximately 48% of California's population."
Organization: State of California
Last updated: 2022-02-28T22:13:29.550945
Tags: covid-19-wastewater-surveillance, national-wastewater-surveillance-data, sars-cov-2-wastewater-measurements, sewershed-surveillance-for-covid-19

Tables

NWSS Metadata.

@usgov.ca_gov_covid_19_wastewater_surveillance_data_california_6ff35.nwss_metadata

15.79 kB
102 rows
7 columns

CREATE TABLE nwss_metadata (
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "description" VARCHAR,
  "value_set" VARCHAR,
  "units" VARCHAR,
  "submission_requirement" VARCHAR,
  "dependent_fields" VARCHAR
);

NWSS ReadMe.

@usgov.ca_gov_covid_19_wastewater_surveillance_data_california_6ff35.nwss_readme

4.91 kB
43 rows
2 columns

CREATE TABLE nwss_readme (
  "general_notes" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1
);

NWSS Value Sets

@usgov.ca_gov_covid_19_wastewater_surveillance_data_california_6ff35.nwss_value_sets

60.5 kB
146 rows
77 columns

CREATE TABLE nwss_value_sets (
  "field" VARCHAR,
  "value_set_name" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "value_set_name_2be8b1" VARCHAR  -- Value Set Name:,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "vs_concentration_method" VARCHAR,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "vs_extraction_method" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "vs_hum_frac_target_chem" VARCHAR,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "vs_hum_frac_target_mic" VARCHAR,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "vs_institution_type" VARCHAR,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "vs_mic_chem_units" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "vs_mic_chem_units_e" VARCHAR,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "vs_num_no_target_control" VARCHAR,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "vs_other_norm_name" VARCHAR,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "vs_pcr_target" VARCHAR,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "vs_pcr_gene_target" VARCHAR,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "vs_pcr_type" VARCHAR,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "vs_quant_stan_type" VARCHAR,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "vs_rec_eff_spike_matrix" VARCHAR,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "vs_rec_eff_target_name" VARCHAR,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "vs_reporting_jurisdiction" VARCHAR,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "vs_sample_location" VARCHAR,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "vs_sample_matrix" VARCHAR,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "vs_sample_type" VARCHAR,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "vs_solids_separation" VARCHAR,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "vs_wwtp_jurisdiction" VARCHAR,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "vs_yn" VARCHAR,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "vs_yne" VARCHAR,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "vs_ynn" VARCHAR,
  "unnamed_76" VARCHAR  -- Unnamed: 76
);