Bulk Data Feed

Delivery specification for bulk property-level PFAS risk scores. Designed for automated ingestion into ICE's data warehouse or RAP environment.

Delivery Specification

Format	gzip-compressed CSV (.csv.gz) or NDJSON (.ndjson.gz)
Frequency	Daily full refresh or incremental (delta records only)
Delivery	SFTP push or S3 bucket drop (with SNS notification)
File Naming	clima_pfas_scores_YYYYMMDD.csv.gz
Encoding	UTF-8
Delimiter (CSV)	Comma
Null Representation	Empty field (CSV) or JSON null (NDJSON)
Header Row	Included in every file (CSV only)
Record Count	Manifest file: clima_pfas_manifest_YYYYMMDD.json

Sample Output

clima_pfas_scores_20260408.csv

property_id,latitude,longitude,state,pfas_score,pfas_contam_prob,pfas_value_decline,pfas_el_adjustment_bps,pfas_cercla_tier,pfas_ws_detected,pfas_adjusted_ltv
PROP-00184291,39.6068,-75.8210,MD,72,0.68,0.064,18.3,2,true,0.854
PROP-00291034,40.2206,-74.7699,NJ,58,0.52,0.041,11.7,3,true,0.832
PROP-00437812,44.7631,-85.6206,MI,81,0.79,0.092,24.1,1,true,0.891

Manifest File

Each delivery includes a companion manifest with record counts and checksums for validation:

clima_pfas_manifest_20260408.json

{
  "date": "2026-04-08",
  "format": "csv.gz",
  "file": "clima_pfas_scores_20260408.csv.gz",
  "record_count": 4218903,
  "sha256": "a1b2c3d4e5f6...7890abcdef",
  "delivery_type": "full_refresh",
  "schema_version": "2.1"
}