state_cont
7 rows where candidate_name = "Pam Anderson" and occupation = "Insurance Industry"
This data as json, CSV (advanced)
Suggested facets: contribution_amount, city, contributor_type, contribution_type
Link | rowid ▼ | District | candidate_name | Party | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7098 | 7098 | Secretary of State | Pam Anderson | Republican | 20.0 | 2/22/22 | Craig Nelson | Parker | CO | 80138 | Lockton Companies | Insurance Industry | Individual | Monetary (Itemized) | |
7152 | 7152 | Secretary of State | Pam Anderson | Republican | 150.0 | 3/16/22 | Jeff Shrader | Golden | CO | 80403 | Jefferson County | Insurance Industry | Individual | Monetary (Itemized) | |
7169 | 7169 | Secretary of State | Pam Anderson | Republican | 50.0 | 3/20/22 | Catherine Roupe | Colorado Springs | CO | 80910 | Self Employed | Insurance Industry | Individual | Monetary (Itemized) | |
7310 | 7310 | Secretary of State | Pam Anderson | Republican | 100.0 | 5/20/22 | Lori Molinaro | Denver | CO | 80209 | State Farm Insurance | Insurance Industry | Individual | Monetary (Itemized) | |
7816 | 7816 | Secretary of State | Pam Anderson | Republican | 100.0 | 9/23/22 | Charles Bobbitt | Colorado Springs | CO | 80909 | Self-Employed | Insurance Industry | Individual | Monetary (Itemized) | |
8117 | 8117 | Secretary of State | Pam Anderson | Republican | 100.0 | 11/3/22 | Richard Hartmann | Castle Rock | CO | 80108 | Auctoris | Insurance Industry | Individual | Monetary (Itemized) | |
8221 | 8221 | Secretary of State | Pam Anderson | Republican | 1250.0 | 12/14/21 | John E Freyer Jr. | Denver | CO | 80206 | Self | Insurance Industry | Individual (Member of LLC: WESTERN ROOTS, LLC) | Monetary (Itemized) - LLC Contribution (Total Amount: 2500.00) |
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 );