state_cont
5 rows where employer = "Us Air Force"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, contribution_amount, contributor, city, zip
Link | rowid ▼ | District | candidate_name | Party | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7910 | 7910 | Secretary of State | Pam Anderson | Republican | 25.0 | 10/8/22 | John T Farquhar | Colorado Springs | CO | 80920 | Us Air Force | Individual | Monetary (Itemized) | ||
78474 | 78474 | Governor | Heidi Ganahl | Republican | 50.0 | 7/28/22 | Lisa Wedman | Peyton | CO | 80831 | Us Air Force | Military | Individual | Monetary (Itemized) | |
80226 | 80226 | Governor | Heidi Ganahl | Republican | 25.0 | 9/7/22 | Robert Boggs | Colorado Springs | CO | 80906 | Us Air Force | Military | Individual | Monetary (Itemized) | |
81177 | 81177 | Governor | Heidi Ganahl | Republican | 25.0 | 9/20/22 | John Farquhar | Colorado Springs | CO | 80920 | Us Air Force | Military | Individual | Monetary (Itemized) | |
82513 | 82513 | Governor | Heidi Ganahl | Republican | 25.0 | 10/7/22 | John Farquhar | Colorado Springs | CO | 80920 | Us Air Force | Military | Individual | Monetary (Itemized) |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_cont" ( "District" TEXT, "candidate_name" TEXT, "Party" TEXT, "contribution_amount" REAL, "contribution_date" TEXT, "contributor" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "employer" TEXT, "occupation" TEXT, "contributor_type" TEXT, "contribution_type" TEXT, "explanation" TEXT );