house_cand_exp
22 rows where candidate = "Sarmiento, Cynthia"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, recipient, city, state, zip
expenditure_type 5 ✖
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
7632 | 7632 | House District 30 | Sarmiento, Cynthia | Republican | 25.0 | 2/5/20 0:00 | Bandcrowd.Com | Surry Hills | AU | 2010 | Advertising | Logo Design And Registration For Candidate Marketing Material |
7633 | 7633 | House District 30 | Sarmiento, Cynthia | Republican | 27.11 | 2/14/20 0:00 | Vistaprint.Com | Waltham | MA | 2451 | Advertising | Business Cards |
7634 | 7634 | House District 30 | Sarmiento, Cynthia | Republican | 20.0 | 2/15/20 0:00 | Colorado Secretary Of State | Denver | CO | 80290 | Other | Colorado Sos Sole Prop Registration Fee |
7635 | 7635 | House District 30 | Sarmiento, Cynthia | Republican | 181.2 | 2/20/20 0:00 | Scudder Press | Thornton | CO | 80229 | Fundraising Expenses | Fund Raising Envelops |
7636 | 7636 | House District 30 | Sarmiento, Cynthia | Republican | 306.51 | 3/6/20 0:00 | Scudder Press | Thornton | CO | 80229 | Advertising | Campaign Card |
7637 | 7637 | House District 30 | Sarmiento, Cynthia | Republican | 132.0 | 4/2/20 0:00 | Wix.Com | San Francisco | CA | 84158 | Advertising | Web Hosting And Domain Registration |
7638 | 7638 | House District 30 | Sarmiento, Cynthia | Republican | 500.0 | 4/7/20 0:00 | Austin Rollinson | Commerce City | CO | 80022 | Consultant & Professional Services | Campaign Consultation And Web Design |
7639 | 7639 | House District 30 | Sarmiento, Cynthia | Republican | 33.1 | 5/2/20 0:00 | Fundraising Expenses | Misc Non Itemized Fundraising Expenses, Each Under $20, No Payee Agg Over $20 | ||||
7640 | 7640 | House District 30 | Sarmiento, Cynthia | Republican | 136.0 | 5/6/20 0:00 | Austin Rollison | Commerce City | CO | 80022 | Consultant & Professional Services | Video Editing |
7641 | 7641 | House District 30 | Sarmiento, Cynthia | Republican | 231.19 | 5/13/20 0:00 | Vistaprint.Com | Waltham | MA | 2451 | Advertising | Door Hangers |
7642 | 7642 | House District 30 | Sarmiento, Cynthia | Republican | 25.0 | 5/22/20 0:00 | Priscilla Rahn | Highlands Raanch | CO | 80130 | Gifts | Donation |
7643 | 7643 | House District 30 | Sarmiento, Cynthia | Republican | 25.0 | 5/27/20 0:00 | Fundhero | Salt Lake City | CO | 84101 | Fundraising Expenses | Fundraising Sight Fee |
7644 | 7644 | House District 30 | Sarmiento, Cynthia | Republican | 25.0 | 5/27/20 0:00 | Streamyard | Victoria | BC | V8N 5H4 | Consultant & Professional Services | Web Service Fee |
7645 | 7645 | House District 30 | Sarmiento, Cynthia | Republican | 110.0 | 5/28/20 0:00 | Us Post Office | Dacono | CO | 80514 | Other | Postage |
7646 | 7646 | House District 30 | Sarmiento, Cynthia | Republican | 37.2 | 6/1/20 0:00 | Merlo Park | CA | 94025 | Advertising | Fb Ads | |
7647 | 7647 | House District 30 | Sarmiento, Cynthia | Republican | 181.0 | 6/5/20 0:00 | Austin Rollison | Commerce City | CO | 80022 | Consultant & Professional Services | Consultation |
7648 | 7648 | House District 30 | Sarmiento, Cynthia | Republican | 541.36 | 6/18/20 0:00 | Scudder Press | Thornton | CO | 80229 | Advertising | Post Card |
7649 | 7649 | House District 30 | Sarmiento, Cynthia | Republican | 8.99 | 6/29/20 0:00 | Fundhero | Salt Lake City | CO | 84101 | Fundraising Expenses | Fund Raiser Service |
7650 | 7650 | House District 30 | Sarmiento, Cynthia | Republican | 25.0 | 6/29/20 0:00 | Streamyard | Victoria | BC | V8N 5H4 | Consultant & Professional Services | Streaming Service |
7651 | 7651 | House District 30 | Sarmiento, Cynthia | Republican | 293.0 | 7/7/20 0:00 | Austin Rollison | Commerce City | CO | 80022 | Consultant & Professional Services | |
7652 | 7652 | House District 30 | Sarmiento, Cynthia | Republican | 386.34 | 8/15/20 0:00 | Cynthia Sarmiento | Thornton | CO | 80602 | Other | Repay Loan |
7653 | 7653 | House District 30 | Sarmiento, Cynthia | Republican | -386.34 | 8/15/20 0:00 | Cynthia Sarmiento | Thornton | CO | 80602 | Other | Offset Due To Deletion Of Filed Item - Repay Loan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_cand_exp" ( "district" TEXT, "candidate" TEXT, "affiliation" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );