Home

Dataset:

Name wastewater-surveillance-data-california
Updated 2025-08-01
CA Dataset link
Current False
Tables
nwss_change_logs     use_of_semantic_versioning_began_with_v2_0_0_a_description_foll - varchar(334)
nwss_read_me     general_notes - varchar(59)
wastewater_surveillance     elevation - varchar(9)
epaid - varchar(11)
wwtp_name - varchar(23)
reporting_jurisdiction - varchar(22)
county_names - varchar(19)
zipcode - varchar(7)
capacity_mgd - varchar(12)
population_served - varchar(17)
industrial_input - varchar(16)
stormwater_input - varchar(16)
influent_equilibrated - varchar(21)
sewage_travel_time - varchar(18)
institution_type - varchar(24)
wwtp_jurisdiction - varchar(17)
solids_separation - varchar(17)
pasteurized - varchar(11)
time_zone - varchar(9)
sample_id - varchar(23)
lab_id - varchar(10)
sample_collect_date - varchar(19)
sample_collect_time - varchar(19)
flow_rate - varchar(16)
collection_water_temp - varchar(21)
sample_type - varchar(29)
composite_freq - varchar(18)
sample_matrix - varchar(17)
sample_location - varchar(15)
sample_location_specify - varchar(36)
collection_storage_time - varchar(23)
collection_storage_temp - varchar(23)
pretreatment - varchar(12)
pretreatment_specify - varchar(328)
concentration_method - varchar(89)
extraction_method - varchar(101)
pre_conc_storage_time - varchar(21)
pre_conc_storage_temp - varchar(21)
pre_ext_storage_time - varchar(20)
pre_ext_storage_temp - varchar(20)
tot_conc_vol - varchar(12)
ext_blank - varchar(9)
rec_eff_target_name - varchar(19)
rec_eff_spike_matrix - varchar(30)
rec_eff_spike_conc - varchar(18)
inhibition_detect - varchar(17)
pcr_type - varchar(8)
lod_ref - varchar(1561)
hum_frac_target_mic - varchar(24)
hum_frac_target_mic_ref - varchar(388)
hum_frac_target_chem - varchar(20)
hum_frac_target_chem_ref - varchar(24)
other_norm_name - varchar(15)
other_norm_ref - varchar(75)
quant_stan_type - varchar(15)
stan_ref - varchar(216)
inhibition_method - varchar(196)
num_no_target_control - varchar(21)
test_result_date - varchar(16)
ph - varchar(7)
conductivity - varchar(12)
tss - varchar(6)
equiv_sewage_amt - varchar(16)
lod_sewage - varchar(14)
ntc_amplify - varchar(11)
rec_eff_percent - varchar(17)
inhibition_adjust - varchar(17)
hum_frac_mic_conc - varchar(18)
hum_frac_mic_unit - varchar(25)
hum_frac_chem_conc - varchar(18)
hum_frac_chem_unit - varchar(18)
other_norm_conc - varchar(15)
other_norm_unit - varchar(15)
quality_flag - varchar(12)
qc_ignore - varchar(9)
dashboard_ignore - varchar(16)
analysis_ignore - varchar(15)
major_lab_method - varchar(16)
major_lab_method_desc - varchar(142)
facility_name - varchar(72)
pcr_target - varchar(14)
pcr_gene_target - varchar(24)
pcr_gene_target_ref - varchar(129)
pcr_target_units - varchar(25)
pcr_target_avg_conc - varchar(19)
pcr_target_std_error - varchar(20)
pcr_target_cl_95_lo - varchar(19)
pcr_target_cl_95_up - varchar(19)
pcr_target_below_lod - varchar(20)
data_source - varchar(39)
validated_methods - varchar(17)
site_id - varchar(18)
epa_registry_id - varchar(15)
created_at - varchar(19)
county_treatmentplant - varchar(21)
label_name - varchar(56)
wastewater_surveillance_log     date_of_change - varchar(14)
details - varchar(85)
type - varchar(5)
Sources
nwss-value-sets.xlsx - None
nwss-data-dictionary.xlsx - None
datapackage.json - None
nwss-change-logs.xlsx - nwss_change_logs
nwss-read-me.xlsx - nwss_read_me
wastewater-surveillance-california.csv - wastewater_surveillance
wastewater-change-surveillance-log.csv - wastewater_surveillance_log
Updates
2025-07-11 17:43:49      None
2025-07-04 20:37:36      0
2025-06-27 13:26:27      0
2025-06-25 13:35:48      0
2025-06-25 13:13:39      0
2025-06-14 15:42:48      0
2025-06-11 11:25:34      0
2025-06-09 12:22:17      0
2025-06-06 12:31:00      0
2025-06-04 13:09:13      0
2025-06-04 12:27:48      0
2025-06-04 12:26:16      0
2025-06-04 12:22:57      0
2025-06-04 12:19:40      0
2025-06-04 12:13:35      0
2025-04-20 19:10:07      0
2025-04-16 09:45:41      0
2025-04-14 09:25:50      0
2025-04-11 11:46:12      0
2025-04-03 11:46:23      0
2025-03-31 11:05:48      0
2025-03-28 19:47:23      0
2025-03-24 10:48:03      0
2025-03-21 14:17:57      0
2025-03-18 12:26:48      0
2025-03-15 10:18:11      0
2025-03-12 19:06:21      0
2025-03-10 10:04:17      0
2025-03-05 10:11:15      0
2025-03-03 10:11:06      0
2025-02-28 10:27:43      0
2025-02-25 09:14:44      0
2025-02-21 11:32:11      0
2025-02-19 11:17:14      0
2025-02-16 17:05:59      0
2025-02-13 11:22:55      0
2025-02-10 10:59:11      0
2025-02-08 14:21:37      0
2025-02-06 18:23:42      0
2025-02-06 14:59:31      0
2025-02-04 17:52:38      0
2025-02-02 19:21:17      0
2025-02-02 15:20:52      0
2025-01-31 10:10:50      0
2025-01-29 11:29:27      0
2025-01-25 12:58:58      0
2025-01-23 20:18:23      0
2025-01-19 13:16:41      0
2025-01-19 13:16:39      0
2025-01-17 06:19:59      0
2025-01-17 06:19:58      0
2025-01-16 19:57:48      0
2025-01-16 19:57:47      0
2025-01-14 12:16:50      0
2025-01-10 11:31:16      0
2025-01-03 14:49:40      0
2024-12-30 16:11:36      0
2024-12-28 14:43:24      0
2024-11-16 19:38:58      None