primary_source_code
primary_source_code
Optional
SDWIS primary water source code (GW, GWP, SW, SWP, GU, GUP).
EPA Drinking Water Quality Screener - Violations, Lead & PFAS
Pricing
from $6.60 / 1,000 drinking water screening results
Screen any US coordinate for the public water system serving it: SDWA health-based violations, Lead & Copper Rule 90th-percentile results and UCMR5 PFAS detections. Built for Phase I ESA and real-estate due diligence. Never reports a clear result from a source that did not answer.
asset_label
asset_label
Optional
Your label for this location, echoed back so results can be joined to your own records.
asset_lat
asset_lat
Optional
Latitude (WGS84) that was screened. Null for a direct PWSID lookup.
asset_lon
asset_lon
Optional
Longitude (WGS84) that was screened. Null for a direct PWSID lookup.
asset_index
asset_index
Optional
Zero-based position of this location in your input array.
lookup_mode
lookup_mode
Optional
How the water system was identified: 'coordinate' (point-in-polygon against EPA service-area boundaries) or 'pwsid' (you supplied the PWSID directly).
pwsid
pwsid
Optional
EPA Public Water System Identification number of the system serving this location (2-letter primacy agency code plus 7 characters).
service_area_pws_name
service_area_pws_name
Optional
Water system name as published on the EPA service-area boundary layer.
service_area_primacy_agency
service_area_primacy_agency
Optional
Primacy agency (usually the state) on the boundary record.
service_area_population_served
service_area_population_served
Optional
Population served, as published on the boundary record.
service_area_service_connections
service_area_service_connections
Optional
Service connection count, as published on the boundary record.
service_area_type
service_area_type
Optional
Type of service area polygon, for example Residential Area or Municipality.
service_area_feature_type
service_area_feature_type
Optional
How EPA describes the polygon, for example 'Service Area Boundary'.
service_area_data_provider
service_area_data_provider
Optional
Who supplied the boundary to EPA.
service_area_data_provider_type
service_area_data_provider_type
Optional
Category of the boundary data provider, for example Private Company or State Agency.
service_area_data_source_url
service_area_data_source_url
Optional
Source URL EPA cites for this boundary.
service_area_model_method
service_area_model_method
Optional
Modelling method used to derive the boundary, when EPA records one.
service_area_modification_method
service_area_modification_method
Optional
How EPA modified the supplied boundary, when applicable.
service_area_method_details
service_area_method_details
Optional
Free-text detail on the boundary derivation method.
service_area_verification_status
service_area_verification_status
Optional
EPA's verification status for the boundary, when recorded.
service_area_confirmed
service_area_confirmed
Optional
Whether the boundary has been confirmed, as recorded by EPA.
service_area_km2
service_area_km2
Optional
Area of the service-area polygon in square kilometres. Useful for judging boundary precision.
service_area_vintage
service_area_vintage
Optional
Date the boundary was originally created. Boundaries vary widely in age - some date to 2004.
echo_detailed_facility_report_url
echo_detailed_facility_report_url
Optional
Link to EPA ECHO's Detailed Facility Report for this system.
boundary_error
boundary_error
Optional
Error message if the service-area lookup failed. Null on success.
service_area_found
service_area_found
Optional
True if a mapped EPA service area covers this location, false if none does, null if the boundary lookup failed. False and null are different answers.
service_areas_matched
service_areas_matched
Optional
How many mapped service areas cover this location. More than one is legitimate (a wholesaler plus its purchaser, or overlapping vintages).
all_pwsids
all_pwsids
Optional
Every PWSID whose mapped service area covers this location, primary first.
all_pws_names
all_pws_names
Optional
Names of every matching water system, in the same order as all_pwsids.
pws_name
pws_name
Optional
Water system name from EPA SDWIS.
pws_type_code
pws_type_code
Optional
SDWIS water system type code (CWS, NTNCWS, TNCWS, NP, U).
pws_type
pws_type
Optional
Decoded water system type, for example 'Community water system'.
pws_activity_code
pws_activity_code
Optional
SDWIS activity code (A active, I inactive, and others).
pws_activity
pws_activity
Optional
Decoded activity status, for example 'Active'.
pws_is_active
pws_is_active
Optional
True if SDWIS marks the system active, false if not, null if the water system record was not retrieved.
pws_deactivation_date
pws_deactivation_date
Optional
Date the system was deactivated in SDWIS, if applicable.
primacy_agency_code
primacy_agency_code
Optional
Two-character primacy agency code (usually the state).
primacy_agency
primacy_agency
Optional
Decoded primacy agency name.
primacy_type
primacy_type
Optional
Whether primacy is held by the State, EPA or a Tribe.
epa_region
epa_region
Optional
EPA region number for the system.
state_code
state_code
Optional
State code recorded on the SDWIS water system record.
population_served_count
population_served_count
Optional
Population served, from SDWIS. May differ from the boundary layer's figure.
service_connections_count
service_connections_count
Optional
Number of service connections, from SDWIS.
owner_type_code
owner_type_code
Optional
SDWIS owner type code (F, L, M, N, P, S).
owner_type
owner_type
Optional
Decoded owner type, for example 'Local government' or 'Private'.
primary_source_code
primary_source_code
Optional
SDWIS primary water source code (GW, GWP, SW, SWP, GU, GUP).
primary_source
primary_source
Optional
Decoded primary water source, for example 'Surface water purchased'.
gw_sw_code
gw_sw_code
Optional
Ground water / surface water code.
gw_sw
gw_sw
Optional
Decoded ground water or surface water designation.
is_wholesaler
is_wholesaler
Optional
True if the system sells water to other systems, false if not, null if not recorded.
is_school_or_daycare
is_school_or_daycare
Optional
True if the system serves a school or daycare, false if not, null if not recorded.
is_grant_eligible
is_grant_eligible
Optional
True if EPA records the system as grant eligible.
source_water_protection
source_water_protection
Optional
Whether a source-water protection programme is recorded for the system.
outstanding_performer
outstanding_performer
Optional
EPA 'outstanding performer' designation, when recorded.
pws_address
pws_address
Optional
Mailing address of the water system's administrative office.
pws_city
pws_city
Optional
City of the water system's administrative office.
pws_zip
pws_zip
Optional
ZIP code of the water system's administrative office.
pws_admin_name
pws_admin_name
Optional
Administrative contact recorded in SDWIS for the utility.
pws_org_name
pws_org_name
Optional
Organisation contact name recorded in SDWIS for the utility.
pws_phone
pws_phone
Optional
Utility contact phone number published in SDWIS.
pws_email
pws_email
Optional
Utility contact email published in SDWIS.
season_begin_date
season_begin_date
Optional
Start of the operating season for seasonal systems.
season_end_date
season_end_date
Optional
End of the operating season for seasonal systems.
counties_served
counties_served
Optional
Counties the system serves, from SDWIS GEOGRAPHIC_AREA.
cities_served
cities_served
Optional
Cities the system serves, from SDWIS GEOGRAPHIC_AREA.
zip_codes_served
zip_codes_served
Optional
ZIP codes the system serves, from SDWIS GEOGRAPHIC_AREA.
geographic_area_types
geographic_area_types
Optional
Kinds of geographic area recorded for the system (County, City, ZIP Code, Tribal, Indian Reservation).
geographic_area_rows
geographic_area_rows
Optional
Number of GEOGRAPHIC_AREA rows retrieved for the system.
water_system_record_found
water_system_record_found
Optional
True if SDWIS holds a WATER_SYSTEM record for this PWSID, false if the lookup succeeded and returned none, null if the lookup failed.
water_system_rows_expected
water_system_rows_expected
Optional
Row count EPA's own COUNT endpoint reported for the WATER_SYSTEM query, used as an exact truncation guard.
geographic_area_status
geographic_area_status
Optional
Outcome of the GEOGRAPHIC_AREA lookup: 'ok' or 'unavailable'.
system_error
system_error
Optional
Error message if the water system lookup failed. Null on success.
violations_total
violations_total
Optional
Total Safe Drinking Water Act violations on record for this system, all years and all categories.
violations_health_based
violations_health_based
Optional
Violations EPA itself flags as health-based (is_health_based_ind = Y): MCL, MRDL and treatment-technique violations. Not derived here.
violations_health_based_in_window
violations_health_based_in_window
Optional
Health-based violations whose compliance period falls inside your violationYears window. Null when the window is disabled.
violations_health_based_unresolved
violations_health_based_unresolved
Optional
Health-based violations SDWIS still marks Open. This is the flag most Phase I reviewers care about.
violations_health_based_known_unreturned
violations_health_based_known_unreturned
Optional
Health-based violations with SDWIS compliance status 'Known' - recorded but not returned to compliance. Reported separately from Open rather than lumped in, because EPA distinguishes them.
violations_health_based_returned_to_compliance
violations_health_based_returned_to_compliance
Optional
Health-based violations SDWIS marks Returned to Compliance.
violations_unresolved_total
violations_unresolved_total
Optional
All violations, health-based or not, SDWIS still marks Open.
violations_by_category
violations_by_category
Optional
Violation counts keyed by SDWIS violation_category_code (MCL, MRDL, TT, MR, MON, RPT, Other).
violations_by_compliance_status
violations_by_compliance_status
Optional
Violation counts keyed by SDWIS compliance_status_code (O Open, K Known, R Returned to Compliance, I System Inactive).
violations_mcl
violations_mcl
Optional
Maximum Contaminant Level violations.
violations_mrdl
violations_mrdl
Optional
Maximum Residual Disinfectant Level violations.
violations_treatment_technique
violations_treatment_technique
Optional
Treatment technique violations.
violations_monitoring_reporting
violations_monitoring_reporting
Optional
Monitoring and reporting violations (categories MR, MON and RPT combined).
violations_lead_copper_rule
violations_lead_copper_rule
Optional
Violations under the Lead and Copper Rule family (rule family 350).
violations_public_notification_tier1
violations_public_notification_tier1
Optional
Violations that carried a Tier 1 public notification - the most urgent tier, requiring notice within 24 hours.
violations_earliest_date
violations_earliest_date
Optional
Earliest violation compliance-period date on record.
violations_latest_date
violations_latest_date
Optional
Most recent violation compliance-period date on record.
health_based_contaminants
health_based_contaminants
Optional
Distinct contaminants named on the system's health-based violations, decoded using EPA's own REF_CODE_VALUE table. Null when EPA publishes no description for the codes involved - see health_based_contaminant_codes, which is always populated.
health_based_contaminant_codes
health_based_contaminant_codes
Optional
Raw SDWIS contaminant codes on the system's health-based violations. Always populated when health-based violations exist. EPA's reference table omits several modern codes (5200, the Revised Lead and Copper Rule contaminant, is one), so the raw code is authoritative and the decoded name may be null.
health_based_contaminants_undecoded
health_based_contaminants_undecoded
Optional
How many of the health-based contaminant codes EPA publishes no description for. Non-zero is normal and reflects a gap in EPA's own reference table, not a gap in the violation record.
most_recent_health_based_violation
most_recent_health_based_violation
Optional
The most recent health-based violation as a full object (type, category, contaminant, rule, compliance status, dates, public notification tier).
most_recent_health_based_violation_date
most_recent_health_based_violation_date
Optional
Compliance-period date of the most recent health-based violation.
health_based_violation_details
health_based_violation_details
Optional
Up to maxViolationDetails individual health-based violation records, newest first, each fully decoded.
health_based_violation_details_truncated
health_based_violation_details_truncated
Optional
True when more health-based violations exist than were included in the details array. Counts above are never truncated.
enforcement_actions_total
enforcement_actions_total
Optional
Number of formal SDWIS enforcement actions on record for this system.
most_recent_enforcement_date
most_recent_enforcement_date
Optional
Date of the most recent formal enforcement action.
most_recent_enforcement_type
most_recent_enforcement_type
Optional
Decoded type of the most recent formal enforcement action.
most_recent_enforcement_type_code
most_recent_enforcement_type_code
Optional
Raw SDWIS enforcement action type code for the most recent action.
violations_rows_expected
violations_rows_expected
Optional
Row count EPA's own COUNT endpoint reported for the violation query, used as an exact truncation guard.
violations_rows_retrieved
violations_rows_retrieved
Optional
Violation rows actually retrieved. A shortfall against violations_rows_expected fails the leg rather than publishing a rollup over a subset.
enforcement_status
enforcement_status
Optional
Outcome of the enforcement lookup: 'ok', 'unavailable' or 'skipped'.
violations_error
violations_error
Optional
Error message if the violation lookup failed. Null on success.
lead_90th_mg_l
lead_90th_mg_l
Optional
Lead and Copper Rule 90th-percentile tap result. Value for the MOST RECENT monitoring period, in mg/L. Reported by the water system under 40 CFR 141 Subpart I.
lead_90th_period_start
lead_90th_period_start
Optional
Start of the monitoring period the reported lead 90th percentile belongs to. EPA publishes the result and the period in separate tables; this actor joins them, because an undated 90th percentile can present a decade-old result as current.
lead_90th_period_end
lead_90th_period_end
Optional
End of the monitoring period the reported lead 90th percentile belongs to.
lead_90th_result_sign_code
lead_90th_result_sign_code
Optional
EPA result sign code on the lead result. 'L' means the value is an upper bound (below minimum detection limits), 'E' means exactly equal to the value reported. Null means EPA published no sign, which is the case on every row observed to date.
lead_90th_below_detection
lead_90th_below_detection
Optional
True when the lead result sign code is 'L' and the reported number is therefore an upper bound rather than a measurement. Null when EPA published no sign code.
lead_90th_reported_zero
lead_90th_reported_zero
Optional
True when EPA published the lead 90th percentile as exactly 0. That is EPA's encoding of 'at or below the laboratory detection limit at the sampled taps' - it is a reported value, not a missing one, and it is not proof that no lead is present. Between 26% and 37% of state LCR rows carry it.
lead_action_level_mg_l
lead_action_level_mg_l
Optional
The federal lead action level, 0.015 mg/L. Constant, included so a row is self-describing.
lead_action_level_exceeded
lead_action_level_exceeded
Optional
True if the most recent lead 90th percentile exceeds 0.015 mg/L, false if it does not, null if the lead leg did not answer or the system has no reported lead result.
lead_90th_max_ever_mg_l
lead_90th_max_ever_mg_l
Optional
Highest lead 90th percentile on record for this system across all monitoring periods.
lead_90th_max_ever_period_end
lead_90th_max_ever_period_end
Optional
End of the monitoring period in which the highest lead 90th percentile was reported.
lead_periods_exceeding_action_level
lead_periods_exceeding_action_level
Optional
How many distinct monitoring periods exceeded the lead action level. A system can be compliant today and have exceeded repeatedly in the past.
lead_monitoring_periods
lead_monitoring_periods
Optional
Number of distinct lead monitoring periods on record.
lead_results_reported
lead_results_reported
Optional
Number of lead 90th-percentile results retrieved for this system.
copper_90th_mg_l
copper_90th_mg_l
Optional
Copper 90th-percentile tap result for the most recent monitoring period, in mg/L.
copper_90th_period_start
copper_90th_period_start
Optional
Start of the monitoring period the reported copper 90th percentile belongs to.
copper_90th_period_end
copper_90th_period_end
Optional
End of the monitoring period the reported copper 90th percentile belongs to.
copper_90th_result_sign_code
copper_90th_result_sign_code
Optional
EPA result sign code on the copper result ('L' below detection, 'E' exactly equal). Null when EPA published no sign.
copper_90th_below_detection
copper_90th_below_detection
Optional
True when the copper result is an upper bound rather than a measurement. Null when EPA published no sign code.
copper_90th_reported_zero
copper_90th_reported_zero
Optional
True when EPA published the copper 90th percentile as exactly 0 - a reported value meaning at or below detection, not a missing one.
copper_action_level_mg_l
copper_action_level_mg_l
Optional
The federal copper action level, 1.3 mg/L. Constant, included so a row is self-describing.
copper_action_level_exceeded
copper_action_level_exceeded
Optional
True if the most recent copper 90th percentile exceeds 1.3 mg/L, false if it does not, null if the leg did not answer or no result exists.
copper_90th_max_ever_mg_l
copper_90th_max_ever_mg_l
Optional
Highest copper 90th percentile on record for this system.
copper_90th_max_ever_period_end
copper_90th_max_ever_period_end
Optional
End of the monitoring period in which the highest copper 90th percentile was reported.
copper_periods_exceeding_action_level
copper_periods_exceeding_action_level
Optional
How many distinct monitoring periods exceeded the copper action level.
copper_monitoring_periods
copper_monitoring_periods
Optional
Number of distinct copper monitoring periods on record.
copper_results_reported
copper_results_reported
Optional
Number of copper 90th-percentile results retrieved for this system.
lcr_results_total
lcr_results_total
Optional
Total Lead and Copper Rule sample-result rows retrieved for this system (lead and copper combined).
lead_period_join_status
lead_period_join_status
Optional
How well the lead and copper results joined to their monitoring periods: 'complete', 'partial', 'failed', 'no_results' or 'not_attempted'. Anything but 'complete' means some reported values are undated.
lead_period_join_matched
lead_period_join_matched
Optional
How many result rows were successfully matched to a monitoring period.
lcr_rows_expected
lcr_rows_expected
Optional
Row count EPA's own COUNT endpoint reported for the lead and copper query, used as an exact truncation guard.
lcr_sample_period_error
lcr_sample_period_error
Optional
Error message if the monitoring-period lookup failed while the results themselves succeeded.
lead_error
lead_error
Optional
Error message if the lead and copper leg failed. Null on success.
pfas_ucmr5_vintage
pfas_ucmr5_vintage
Optional
Publication timestamp of the UCMR5 occurrence file actually used, read from its Last-Modified header. The download URL contains '2023-08' but EPA replaces the file in place, so the path is NOT the vintage.
pfas_ucmr5_source_url
pfas_ucmr5_source_url
Optional
URL of the EPA UCMR5 occurrence dataset used for the PFAS screen.
pfas_ucmr5_national_rows
pfas_ucmr5_national_rows
Optional
Total UCMR5 result rows indexed on this run, measured live as a truncation guard.
pfas_ucmr5_national_systems
pfas_ucmr5_national_systems
Optional
Total public water systems present in UCMR5 on this run.
pfas_mcl_screen_basis
pfas_mcl_screen_basis
Optional
Plain statement of what the PFAS MCL comparison is and is not: a screening comparison against EPA's 2024 PFAS NPDWR values, not a compliance determination, because UCMR5 reports single entry-point samples rather than the running annual average used for compliance.
pfas_system_tested
pfas_system_tested
Optional
True if this system appears in UCMR5 at all, false if it does not (most small systems were not in the UCMR5 sample), null if the PFAS leg failed. False and null are different answers.
pfas_results_count
pfas_results_count
Optional
Number of UCMR5 result rows for this system, detections and non-detects combined.
pfas_analytes_tested
pfas_analytes_tested
Optional
Number of distinct UCMR5 analytes this system was tested for (up to 30: 29 PFAS plus lithium).
pfas_sample_points
pfas_sample_points
Optional
Number of distinct entry-point sample locations UCMR5 holds for this system.
pfas_nondetect_count
pfas_nondetect_count
Optional
Number of UCMR5 results reported as non-detect - the analyte was looked for and not found above the minimum reporting level. A non-detect is NOT zero and NOT untested.
pfas_min_reporting_level_ugl
pfas_min_reporting_level_ugl
Optional
Lowest minimum reporting level applied to this system's UCMR5 samples, in micrograms per litre. A non-detect only rules out concentrations above this level.
pfas_first_collection_date
pfas_first_collection_date
Optional
Earliest UCMR5 sample collection date for this system.
pfas_last_collection_date
pfas_last_collection_date
Optional
Most recent UCMR5 sample collection date for this system.
pfas_detected
pfas_detected
Optional
True if any PFAS analyte was detected, false if the system was tested and no PFAS was detected, null if the PFAS leg did not answer. Lithium is a UCMR5 analyte but is NOT a PFAS and never sets this true.
pfas_detection_count
pfas_detection_count
Optional
Number of individual PFAS detections (excluding lithium) across all of this system's UCMR5 samples.
pfas_analytes_detected
pfas_analytes_detected
Optional
Names of the PFAS analytes detected at this system, alphabetically. Lithium is deliberately excluded.
pfas_max_analyte
pfas_max_analyte
Optional
PFAS analyte with the highest detected concentration at this system.
pfas_max_ugl
pfas_max_ugl
Optional
Highest single PFAS concentration detected at this system, in micrograms per litre.
pfoa_max_ugl
pfoa_max_ugl
Optional
Highest detected PFOA concentration, in micrograms per litre. The 2024 NPDWR MCL is 0.004 ug/L.
pfos_max_ugl
pfos_max_ugl
Optional
Highest detected PFOS concentration, in micrograms per litre. The 2024 NPDWR MCL is 0.004 ug/L.
pfhxs_max_ugl
pfhxs_max_ugl
Optional
Highest detected PFHxS concentration, in micrograms per litre. The 2024 NPDWR MCL is 0.010 ug/L.
pfna_max_ugl
pfna_max_ugl
Optional
Highest detected PFNA concentration, in micrograms per litre. The 2024 NPDWR MCL is 0.010 ug/L.
hfpo_da_max_ugl
hfpo_da_max_ugl
Optional
Highest detected HFPO-DA (GenX chemicals) concentration, in micrograms per litre. The 2024 NPDWR MCL is 0.010 ug/L.
pfbs_max_ugl
pfbs_max_ugl
Optional
Highest detected PFBS concentration, in micrograms per litre. PFBS has no individual MCL; it is one of the four Hazard Index analytes.
pfas_hazard_index_screen
pfas_hazard_index_screen
Optional
Unitless Hazard Index computed over PFHxS, PFNA, HFPO-DA and PFBS against their published health-based water concentrations. Null when the system was not tested for any Hazard Index analyte.
pfas_hazard_index_screen_exceeded
pfas_hazard_index_screen_exceeded
Optional
True if the Hazard Index screen exceeds 1.0, false if it does not, null if it could not be computed.
pfas_mcl_screen_exceedances
pfas_mcl_screen_exceedances
Optional
PFAS analytes whose highest detected concentration exceeds the corresponding 2024 NPDWR MCL. A screening comparison only - see pfas_mcl_screen_basis.
pfas_mcl_screen_exceeded
pfas_mcl_screen_exceeded
Optional
True if any detected PFAS exceeds its 2024 NPDWR MCL on this screening comparison, false if none does, null if the PFAS leg did not answer.
lithium_max_ugl
lithium_max_ugl
Optional
Highest detected lithium concentration, in micrograms per litre. Lithium is a UCMR5 analyte and is NOT a PFAS; it is reported separately so it can never inflate a PFAS count.
lithium_detected
lithium_detected
Optional
True if lithium was detected, false if the system was tested for lithium and none was detected, null if lithium was not among the analytes tested or the leg did not answer.
pfas_error
pfas_error
Optional
Error message if the PFAS leg failed. Null on success.
water_quality_screen_level
water_quality_screen_level
Optional
Overall screening level: HIGH, MODERATE, LOW, NO_SERVICE_AREA or INCONCLUSIVE. INCONCLUSIVE whenever any requested EPA source failed - the verdict can never read LOW on data that was never checked. A screening indicator, not a regulatory determination.
screen_flags
screen_flags
Optional
Every screening flag raised, for example UNRESOLVED_HEALTH_BASED_VIOLATION, LEAD_ACTION_LEVEL_EXCEEDED, PFAS_ABOVE_2024_NPDWR_MCL_SCREEN.
screen_reason
screen_reason
Optional
Plain-English explanation of the screening level, naming the failed sources when the result is INCONCLUSIVE.
boundary_status
boundary_status
Optional
Outcome of the service-area lookup: 'ok' or 'unavailable'.
system_status
system_status
Optional
Outcome of the water system leg: 'ok', 'unavailable', 'skipped' or 'not_applicable'.
violations_status
violations_status
Optional
Outcome of the violations leg: 'ok', 'unavailable', 'skipped' or 'not_applicable'.
lead_status
lead_status
Optional
Outcome of the lead and copper leg: 'ok', 'unavailable', 'skipped' or 'not_applicable'.
pfas_status
pfas_status
Optional
Outcome of the PFAS leg: 'ok', 'unavailable', 'skipped' or 'not_applicable'.
sources_ok
sources_ok
Optional
How many of the requested EPA sources answered successfully for this location.
sources_requested
sources_requested
Optional
How many EPA sources were requested for this location (boundary, water system, violations, lead, PFAS).
sources_failed
sources_failed
Optional
Names of the EPA sources that did not answer. An empty array means every requested source answered.
sources_not_attempted
sources_not_attempted
Optional
EPA sources that were never attempted because an upstream lookup failed - for example the violation, lead and PFAS legs when the service-area lookup itself went down. Distinct from sources_failed and from a source that genuinely had nothing to look up.
data_complete
data_complete
Optional
True only when every requested EPA source answered and none was skipped by an upstream failure. False means a finding may be missing.
retrieved_at
retrieved_at
Optional
UTC timestamp when this run queried EPA.
sdwis_source
sdwis_source
Optional
Attribution for the tabular data (EPA Envirofacts SDWIS).
boundary_source
boundary_source
Optional
Attribution for the service-area boundary layer.
boundary_layer_national_count
boundary_layer_national_count
Optional
Total service-area records in EPA's national layer at run time, measured live as a truncation and drift guard.
actor_version
actor_version
Optional
Version of this actor that produced the row.
drift_status
drift_status
Optional
Result of this run's live source-integrity checks: 'ok' or 'degraded'. A 'failed' status fails the run before any row is emitted.
drift_measurements
drift_measurements
Optional
JSON string of every value measured by the live drift checks on this run (national record counts, canary results, UCMR5 vintage and vocabulary), so source health is auditable.