Candidates
Data license: Public records · Data source: FEC, Nebraska Accountability and Disclosure Commission, Clerk of the Legislature, Open States
8 rows where office = "S" and party = "AIP" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| S4WI00181 | AUBART, SCOTT A MR | AIP | S | WI | 00 | C | N | 2024 | fec_bulk | 2026-11-18T19:44:13+00:00 | |
| S4WI00199 | AUBART, SCOTT ALAN MR | AIP | S | WI | 00 | C | N | 2024 | C00840843 | fec_bulk | 2026-11-18T19:49:15+00:00 |
| S2WI00375 | AUBART, SCOTT ALAN MR | AIP | S | WI | 00 | C | N | 2022 | fec_bulk | 2026-11-18T19:37:54+00:00 | |
| S2VT00185 | COESTER, C. MARK MR | AIP | S | VT | 00 | O | P | 2022 | C00792176 | fec_bulk | 2026-11-18T19:44:13+00:00 |
| S2AK00143 | DARDEN, DUSTIN | AIP | S | AK | 00 | C | N | 2022 | fec_bulk | 2026-11-18T19:37:54+00:00 | |
| S6MA00247 | DEVINCENTIS, PHILIP PETER MR JR | AIP | S | MA | 00 | C | N | 2025 | fec_bulk | 2026-11-18T19:49:15+00:00 | |
| S6IN00282 | GREEN, CARMEN CHARMAINE | AIP | S | IN | 00 | C | N | 2026 | fec_bulk | 2026-11-18T19:49:15+00:00 | |
| S4NY00297 | MILLER, YUEXIN | AIP | S | NY | 00 | C | N | 2023 | C00830794 | 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);