| Name |
wastewater-surveillance-data-california |
|---|
| Updated |
2025-08-14 |
|---|
| CA Dataset |
link |
|---|
| Current |
False |
|---|
| 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 |
|
|---|
| 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 |
|
|---|