house_cont
6 rows where contribution_type = "Non-Monetary (Itemized)" and occupation = "Media/Public Relations"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, Party, contribution_amount, contribution_date, city, zip, employer
Link | rowid ▼ | District | candidate_name | Party | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21124 | 21124 | House District 31 | Said Sharbini | Democratic | 400.0 | 1/4/22 | Frederick Winter | Denver | CO | 80210 | Self Employed | Media/Public Relations | Individual | Non-Monetary (Itemized) | Help With Photography |
27539 | 27539 | House District 42 | Mandy Lindsay | Democratic | 375.0 | 2/28/22 | Jessica Smith | Denver | CO | 80207 | 4B Marketing | Media/Public Relations | Individual | Non-Monetary (Itemized) | Website Services |
28894 | 28894 | House District 45 | Lisa Frizell | Republican | 400.0 | 5/24/22 | Nick Lucey | Castle Rock | CO | 80104 | Self Employed | Media/Public Relations | Individual | Non-Monetary (Itemized) | Photography Services |
29824 | 29824 | House District 48 | Gabe Evans | Republican | 20.0 | 3/16/22 | Bob Grand | Keenesburg | CO | 80643 | Lost Creek Guide | Media/Public Relations | Individual | Non-Monetary (Itemized) | |
29944 | 29944 | House District 48 | Gabe Evans | Republican | 400.0 | 10/12/22 | Joel R Flores | Henderson | CO | 80640 | News Media | Media/Public Relations | Individual | Non-Monetary (Itemized) | |
29945 | 29945 | House District 48 | Gabe Evans | Republican | 400.0 | 10/12/22 | Mary A Flores | Henderson | CO | 80640 | La Prensa De Colorado Spanish | Media/Public Relations | Individual | Non-Monetary (Itemized) | Professional Services |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_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 );