FCC BDC County Fixed Broadband Summary

python -m pip install pandas

from pathlib import Path
from zipfile import ZipFile
import pandas as pd

archive_path = Path("bdc_us_fixed_broadband_summary_by_geography_D25_03sep2026.zip")
with ZipFile(archive_path) as archive:
    csv_name = next(name for name in archive.namelist() if name.endswith(".csv"))
    with archive.open(csv_name) as stream:
        for chunk in pd.read_csv(stream, chunksize=5000):
            counties = chunk.loc[
                chunk["geography_type"].eq("County") & chunk["biz_res"].eq("R"),
                ["geography_id", "technology", "speed_100_20"],
            ]
            if not counties.empty:
                print(counties.head(3).to_string(index=False))
                break