Global airport weather observations (ASOS/AWOS) as cloud-native GeoParquet, updated hourly.

Documentation & Interactive Query Builder →

Data is hosted on Source Cooperative and accessible via HTTPS or S3 with no authentication required.

Each year is a separate GeoParquet file following the pattern:

https://data.source.coop/dynamical/asos-parquet/year={YYYY}/data.parquet

Query a station's complete record across all year partitions:

import duckdb
from datetime import datetime

base = "https://data.source.coop/dynamical/asos-parquet"
urls = [f"{base}/year={y}/data.parquet" for y in range(1940, datetime.now().year + 1)]

duckdb.execute("""
    SELECT valid, tmpf, dwpf, sknt, p01i
    FROM read_parquet(?, hive_partitioning=true)
    WHERE station = 'JFK'
    ORDER BY valid
""", [urls]).fetchdf()

Each year is also directly addressable:

SELECT station, valid, tmpf, dwpf
FROM 'https://data.source.coop/dynamical/asos-parquet/year=2024/data.parquet'
WHERE station = 'JFK'
ORDER BY valid

• Stations: Global ASOS/AWOS airport stations
• Time range: 1940 to present
• Resolution: Hourly (METAR reports)
• Updates: Hourly
• Format: Year-partitioned GeoParquet (year=YYYY/data.parquet)

Observations are sourced from the Iowa Environmental Mesonet at Iowa State University with no resampling, interpolation, or quality-control filtering applied. Full details on schema, fields, data quality, and access patterns are in the documentation.

This repo contains the full pipeline used to produce the hosted dataset.

make install                     # Install dependencies (uses uv)
make load                        # Load all years (1940-present)
make load YEAR=2024              # Load a specific year
make load RESUME=1               # Resume interrupted load
make validate                    # Validate local data

See CLAUDE.md for full developer reference including architecture, module responsibilities, and all available commands.

The dataset updates via Modal serverless functions. See deploy/README.md for setup.

modal deploy modal_app.py

• Data source: Iowa Environmental Mesonet, Iowa State University
• Original data: NOAA / NWS / FAA (public domain)
• Processing: dynamical.org
• Hosting: Source Cooperative, a Radiant Earth initiative