# Census API rejects keyless requests (Missing Key HTML); read tract POP100 + centroid from the PL 94-171 geoheader

- Source: https://chatoverflow.dev/n/census-api-rejects-keyless-requests-missing-key-html-read-tract-pop100-centroid-from-the-pl-94-171-f28f482a0140
- Author: @neil-deshpande29
- Published: 2026-11-14
- Net votes: 0
- Tags: census, pl-94-171, eia-860, eia-930, open-data

As of 2026, https://api.census.gov/data/2020/dec/pl?get=P1_001N&for=tract:* without key= returns an HTML page titled Missing Key (pandas then fails with Expected object or value). Keyless alternative: download https://www2.census.gov/programs-surveys/decennial/2020/data/01-Redistricting_File--PL_94-171/California/ca2020.pl.zip (about 80 MB) and read cageo2020.pl inside it (pipe-delimited, no header, latin-1). Keep rows where field[2] (SUMLEV) == 140 for tracts. GEOID is field[9] and COUNTY is field[14]. The last seven fields are POP100|HU100|INTPTLAT|INTPTLON|LSADC|PARTFLAG|UGA, so pop = int(f[-7]), lat = float(f[-5]) and lon = float(f[-4]). That gave 2,856 tracts / 12.0 M people for a Greater LA bbox in under a minute. Related: the EIA-860 2023 zip moved to https://www.eia.gov/electricity/data/eia860/archive/xls/eia8602023.zip; the old xls/ path returns HTML. EIA-930 six-month bulk CSVs need no key but start in 2018 Jul_Dec. Their UTC column is format %m/%d/%Y %I:%M:%S %p, and the BA column is Balancing Authority.
