fcc_filings
One row per FCC ECFS filing — the FCC's comment equivalent: comments, reply comments, ex-parte notices, letters, and other submissions — ingested from the FCC ECFS public API (/filings) by build_fcc_filings. Requires an api.data.gov key (DATA_GOV_API_KEY). Incremental by date_received, deduped on id_submission. Because ECFS holds tens of millions of filings, a first run with no prior table is bounded to the trailing 30 days; deeper history is backfilled in slices via FCC_SINCE and/or scoped to specific proceedings via FCC_PROCEEDINGS. All columns are stored as VARCHAR, array fields serialized as JSON strings.
- Parquet file:
fcc_filings.parquet - Queryable via MCP
query_sql: Yes
| Column | Type | Description |
|---|---|---|
id_submission |
VARCHAR |
ECFS submission id (e.g. 26109947027). Primary key / dedup key. |
proceeding_names_json |
VARCHAR |
JSON array of proceeding (docket) numbers the filing was submitted to (e.g. ["17-108"]). Join key to fcc_proceedings.name. |
submission_type |
VARCHAR |
ECFS submission type description, e.g. COMMENT, REPLY TO COMMENTS, NOTICE OF EXPARTE. |
express_comment |
VARCHAR |
1 if the filing is an express comment (text-only, entered in the web form), 0 for standard filings with uploaded documents. |
date_received |
VARCHAR |
Timestamp ECFS records the filing as received (ISO 8601 string). Incremental cursor and sort key. |
date_submission |
VARCHAR |
Timestamp the filer submitted the filing (ISO 8601 string). |
date_disseminated |
VARCHAR |
Timestamp the filing was disseminated (made public) by ECFS (ISO 8601 string). |
filing_status |
VARCHAR |
ECFS workflow status description (e.g. DISSEMINATED). |
viewing_status |
VARCHAR |
ECFS viewing status description (e.g. Unrestricted, Confidential). |
exparte_or_late_filed |
VARCHAR |
Y if the filing is ex-parte or late-filed, else N. |
filers_json |
VARCHAR |
JSON array of filer names (individuals or organizations) on the filing. |
authors_json |
VARCHAR |
JSON array of author names on the filing, when distinct from the filers. Often empty. |
lawfirms_json |
VARCHAR |
JSON array of law-firm names on the filing. Often empty. |
bureaus_json |
VARCHAR |
JSON array of FCC bureau names the filing was routed to. Often empty. |
text_data |
VARCHAR |
The filing's inline text — for express comments this is the full comment text. Null for document-only filings. |
total_page_count |
VARCHAR |
Total page count across the filing's attached documents, as a numeric string. |
documents_json |
VARCHAR |
JSON array of attached documents as {filename, src} objects, where src is the fcc.gov download URL. |
filing_url |
VARCHAR |
Canonical fcc.gov URL for the filing (https://www.fcc.gov/ecfs/filing/<id_submission>). |