Extract
FCC BDC API
Programmatic retrieval of the latest Broadband Data Collection availability data across states and broadband technologies
REST API
JSON
Python
Dec. 2025
Ingest
API Ingestion
Iterate through state and technology requests, handle pagination and API responses, and capture source metadata for reproducible loads
Python
Requests
Pagination
Logging
Transform
Normalize & Validate
Standardize provider, location, technology, speed, and release fields into a consistent analytical schema before loading
Pandas
Validation
Deduplication
Schema
Load
PostgreSQL / PostGIS
Persistent relational store for broadband availability, providers, technologies, locations, and release-specific records
PostgreSQL
PostGIS
psycopg2
Indexes
Serve
Materialized Views
Update the materialized views accessed by analysts and applications
SQL
PostGIS