Candidates
Data license: Public records · Data source: FEC, Nebraska Accountability and Disclosure Commission, Clerk of the Legislature, Open States
6 rows where party = "W" and state = "PA" sorted by name
This data as json, CSV (advanced)
| candidate_id | name ▼ | party | office | state | district | incumbent_challenge | status | election_year | principal_committee | source | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| H2PA05124 | BESTMAN, WILLIAM DAVID | W | H | PA | 05 | C | N | 2022 | fec_bulk | 2026-11-18T19:37:54+00:00 | |
| S2PA00695 | MAGEE, QUINCY | W | S | PA | 00 | O | N | 2022 | C00802108 | fec_bulk | 2026-11-18T19:44:13+00:00 |
| S0PA00525 | SOLOMON, GAVIN | W | S | PA | 00 | N | 2029 | fec_bulk | 2026-11-18T19:49:15+00:00 | ||
| S0PA00533 | SOLOMON, GAVIN | W | S | PA | 00 | N | 2030 | fec_bulk | 2026-11-18T19:49:15+00:00 | ||
| S8PA00361 | SOLOMON, GAVIN | W | S | PA | 00 | N | 2027 | fec_bulk | 2026-11-18T19:49:15+00:00 | ||
| S8PA00379 | SOLOMON, GAVIN | W | S | PA | 00 | N | 2028 | fec_bulk | 2026-11-18T19:49:15+00:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE candidates (
candidate_id TEXT PRIMARY KEY, -- FEC candidate ID, e.g. H6NE01064
name TEXT,
party TEXT,
office TEXT, -- H = House, S = Senate, P = President
state TEXT, -- state of the office sought
district TEXT,
incumbent_challenge TEXT, -- I / C / O (open seat)
status TEXT,
election_year INTEGER,
principal_committee TEXT,
source TEXT,
updated_at TEXT
);
CREATE INDEX idx_candidates_state ON candidates(state, office);