Candidates
Data license: Public records · Data source: FEC, Nebraska Accountability and Disclosure Commission, Clerk of the Legislature, Open States
13 rows where party = "LIB" and state = "CA" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| H4CA11149 | BLUE, ELIJAH LEWIS | LIB | H | CA | 11 | C | N | 2024 | C00827683 | fec_bulk | 2026-11-18T19:49:15+00:00 |
| H4CA28135 | CASTANEDA, JOSE | LIB | H | CA | 28 | C | N | 2024 | fec_bulk | 2026-11-18T19:44:13+00:00 | |
| H6CA14064 | DEHN, JOSEPH W III | LIB | H | CA | 17 | C | N | 2026 | fec_bulk | 2026-11-18T19:49:15+00:00 | |
| H2CA01185 | GODFREY, MARCUS SCOTT | LIB | H | CA | 01 | C | N | 2022 | C00771659 | fec_bulk | 2026-11-18T19:44:13+00:00 |
| H0CA18100 | GOODWYN, BOB | LIB | H | CA | 18 | C | N | 2020 | fec_bulk | 2026-11-18T19:31:15+00:00 | |
| H4CA01082 | LAVIN, JEFFREY R MR. | LIB | H | CA | 01 | C | N | 2024 | C00766949 | fec_bulk | 2026-11-18T19:49:15+00:00 |
| S8CA00283 | LIGHTFOOT, GAIL K | LIB | S | CA | O | N | 2024 | C00386508 | fec_bulk | 2026-11-18T19:44:13+00:00 | |
| H6CA41307 | PATEL, SHAAF MR | LIB | H | CA | 41 | C | N | 2026 | C00909341 | fec_bulk | 2026-11-18T19:49:15+00:00 |
| H6CA47106 | REID, DERRICK MICHAEL | LIB | H | CA | 47 | C | C | 2026 | C00947812 | fec_bulk | 2026-11-18T19:49:15+00:00 |
| S8CA00507 | REID, DERRICK MICHAEL | LIB | S | CA | 00 | C | N | 2018 | C00676767 | fec_bulk | 2026-11-18T19:31:15+00:00 |
| H0CA40104 | RIVERA, JUAN LUIS | LIB | H | CA | 40 | C | N | 2020 | C00698704 | fec_bulk | 2026-11-18T19:44:13+00:00 |
| H0CA45020 | SHEA, JOE | LIB | H | CA | 50 | C | N | 2026 | fec_bulk | 2026-11-18T19:49:15+00:00 | |
| S2CA00864 | WHITNEY, ELLERTON PRATT MARK MR. III | LIB | S | CA | 00 | C | N | 2022 | C00744870 | fec_bulk | 2026-11-18T19:44:13+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);