Skip to content

fcc_proceedings

One row per FCC proceeding (the FCC's docket equivalent, e.g. 17-108), ingested from the FCC ECFS public API (/proceedings) by build_fcc_proceedings. The FCC does not participate in regulations.gov — its rulemaking dockets and public comments live in ECFS — so this table extends the dataset's docket universe to the FCC. Requires an api.data.gov key (DATA_GOV_API_KEY). Incremental by date_created, deduped on name. Proceedings with no created date are unreachable through the API's date-range queries and are not included (legacy shells with no filing activity). All columns are stored as VARCHAR.

  • Parquet file: fcc_proceedings.parquet
  • Queryable via MCP query_sql: Yes
Column Type Description
name VARCHAR Proceeding (docket) number, e.g. 17-108 or 23-320. Primary key / dedup key, and the join key to fcc_filings.proceeding_names_json.
id_proceeding VARCHAR ECFS internal numeric id for the proceeding.
description VARCHAR Proceeding title/subject (ECFS description_display, falling back to description), e.g. Restoring Internet Freedom.
bureau_code VARCHAR Code of the FCC bureau that owns the proceeding (e.g. WC).
bureau_name VARCHAR Name of the FCC bureau that owns the proceeding (e.g. Wireline Competition Bureau).
rulemaking_or_docket VARCHAR ECFS flag_rulemaking_or_docket: R for rulemakings (RM- numbers), D for dockets.
filing_status VARCHAR ECFS filing-window status for the proceeding (e.g. OPENALL).
date_created VARCHAR Timestamp the proceeding was created in ECFS (ISO 8601 string). Incremental cursor and sort key.
date_closed VARCHAR Timestamp the proceeding was closed, if it has been (open proceedings carry null or a far-future sentinel like 2099-12-31).
comment_start_date VARCHAR Start of the initial comment window, when ECFS records one. Often null.
comment_end_date VARCHAR End of the initial comment window, when ECFS records one. Often null.
reply_comment_start_date VARCHAR Start of the reply-comment window, when ECFS records one. Often null.
reply_comment_end_date VARCHAR End of the reply-comment window, when ECFS records one. Often null.
filed_by VARCHAR ECFS account that created the proceeding. An internal FCC username; occasionally useful for spotting bureau conventions.