fec_candidate_crosswalk

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

1,711 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, chamber

Next page

CREATE TABLE fec_candidate_crosswalk (
    fec_candidate_id TEXT NOT NULL,
    bioguide_id TEXT NOT NULL,
    full_name TEXT,
    party TEXT,
    state TEXT,
    chamber TEXT,
    PRIMARY KEY (fec_candidate_id, bioguide_id)
);
CREATE INDEX idx_fec_xwalk_bio ON fec_candidate_crosswalk(bioguide_id);