| Name |
wastewater-surveillance-data-california |
|---|
| Updated |
2025-08-14 |
|---|
| CA Dataset |
link |
|---|
| Current |
True |
|---|
| Tables |
| nwss_change_logs |
|
use_of_semantic_versioning_began_with_v2_0_0_a_description_foll - varchar(334)
|
| 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)
|
|
|---|
| 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 |
|
|---|
| Updated | |
|---|