Sold by: ZipCheckup
Open data
|
Deployed on AWS
A normalized, address- and ZIP-level compilation of US public environmental
health records: machine-parsed Consumer Confidence Reports (drinking water
contaminant tables, including PFAS, for 9,700+ water systems, 2023-2024),
lead service line records aggregated from 94 state and utility inventories
(18.4M address-level records), a ZIP-level summary layer covering 41,000+
ZIP codes across 17 environmental risk categories, and companion layers
built from EPA SDWIS, UCMR5, FEMA NRI, USGS, CDC, and Census sources.
All records are machine-readable, carry per-record source provenance
(source document URL, legal authority, parse/refresh date), and are
reproducible from cited public documents. CSV, JSON, and Parquet formats;
Parquet mirrors of the large collections are provided for Amazon Athena
and columnar workflows.
Overview
A normalized, address- and ZIP-level compilation of US public environmental health records: machine-parsed Consumer Confidence Reports (drinking water contaminant tables, including PFAS, for 9,700+ water systems, 2023-2024), lead service line records aggregated from 94 state and utility inventories (18.4M address-level records), a ZIP-level summary layer covering 41,000+ ZIP codes across 17 environmental risk categories, and companion layers built from EPA SDWIS, UCMR5, FEMA NRI, USGS, CDC, and Census sources. All records are machine-readable, carry per-record source provenance (source document URL, legal authority, parse/refresh date), and are reproducible from cited public documents. CSV, JSON, and Parquet formats; Parquet mirrors of the large collections are provided for Amazon Athena and columnar workflows.
Features and programs
Open Data Sponsorship Program
This dataset is part of the Open Data Sponsorship Program, an AWS program that covers the cost of storage for publicly available high-value cloud-optimized datasets.
Pricing
This is a publicly available data set. No subscription is required.
Legal
Content disclaimer
Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.
Delivery details
AWS Data Exchange (ADX)
AWS Data Exchange is a service that helps AWS easily share and manage data entitlements from other organizations at scale.
Open data resources
Available with or without an AWS account.
- How to use
- To access these resources, reference the Amazon Resource Name (ARN) using the AWS Command Line Interface (CLI). Learn more
- Description
- ZIP summary layer (41,000+ ZIP codes, 17 risk categories), parsed CCR corpus (9,811 water-system JSON documents + consolidated Parquet), lead service line address compilation (18,465,827 records across 5,795 ZIP codes, JSON per ZIP + consolidated Parquet), and companion layers.
- Resource type
- S3 bucket
- Amazon Resource Name (ARN)
- arn:aws:s3:::zipcheckup-open-data
- AWS region
- us-west-2
- AWS CLI access (No AWS account required)
- aws s3 ls --no-sign-request s3://zipcheckup-open-data/
Resources
Vendor resources
Support
Contact
Managed By
How to cite
US Home Environmental Risk Compilation (ZipCheckup Open Data) was accessed on DATE from https://registry.opendata.aws/zipcheckup-us-home-environmental-risk .
License
Similar products
Detailed air model results from EPA’s Risk-Screening Environmental Indicators (RSEI) model.
![U.S. Environmental Protection Agency (EPA) Center for Computational[...]](https://d1ewbp317vsrbd.cloudfront.net/6f7f789a-9232-4665-8a1a-31826a8a8ada.png)
High-throughput transcriptomics (HTTr) data generated by US EPA Office of Research and Development, Center for Computational Toxicology and Exposure (CCTE), Biomolecular and Computational Toxicology Division. All data is generated using TempO-Seq targeted RNA-seq technology from in vitro cell culture systems.
CSV files of flood statistics for the 48 contiguous states at the congressional district, county, and zip code level. The CSV for each of these geographical extents includes statistics on the amount of properties at risk according to FEMA, the number of properties at risk according to First Street Foundation, and the difference between the two.
Aggregated health and social factors that influence risk from exposure to wildland fires. Data is curated from authoritative sources including the U.S. CDC and Census Bureau.