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 = "MN" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| H0MN02118 | OLSON, RICHARD THOMAS | W | H | MN | 02 | C | P | 2022 | C00815993 | fec_bulk | 2026-11-18T19:44:13+00:00 |
| S0MN00419 | SOLOMON, GAVIN | W | S | MN | 00 | N | 2029 | fec_bulk | 2026-11-18T19:49:15+00:00 | ||
| S0MN00427 | SOLOMON, GAVIN | W | S | MN | 00 | N | 2030 | fec_bulk | 2026-11-18T19:49:15+00:00 | ||
| S8MN00750 | SOLOMON, GAVIN | W | S | MN | 00 | N | 2027 | fec_bulk | 2026-11-18T19:49:15+00:00 | ||
| S8MN00768 | SOLOMON, GAVIN | W | S | MN | 00 | N | 2028 | fec_bulk | 2026-11-18T19:49:15+00:00 | ||
| S2MN00316 | WHITCIMB, PATRICK | W | S | MN | 00 | C | N | 2022 | fec_bulk | 2026-11-18T19:37:54+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);