house_cont
3 rows where employer = "Jlh Consulting & Public Affairs, Llc"
This data as json, CSV (advanced)
Suggested facets: Party, contributor, occupation, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18713 | 18713 | House District 27 | Brianna Titone | Democratic | 200.0 | 7/6/22 | Jason Hopfer | Highlands Ranch | CO | 80130 | Jlh Consulting & Public Affairs, Llc | Lobbyist | Individual | Monetary (Itemized) | Check#3589 |
20553 | 20553 | House District 29 | Shannon Bird | Democratic | 200.0 | 9/26/22 | Kelly Hopfer | Highlands Ranch | CO | 80130 | Jlh Consulting & Public Affairs, Llc | Attorney/Legal | Individual | Monetary (Itemized) | |
32684 | 32684 | House District 54 | Matt Soper | Republican | 200.0 | 7/30/22 | Jason Hopfer | Highlands Ranch | CO | 80130 | Jlh Consulting & Public Affairs, Llc | Lobbyist | Individual (Member of LLC: JLH CONSULTING & PUBLIC AFFAIRS) | Monetary (Itemized) - LLC Contribution (Total Amount: 200.00) |
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 );