senate_cand_exp
7 rows where affiliation = "Republican" and expenditure_type = "Gifts"
This data as json, CSV (advanced)
Suggested facets: district, candidate, recipient, city, state, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
242 | 242 | Senate District 08 | Rankin, Bob | Republican | 155.43 | 4/24/19 0:00 | Pinmart | Elk Grove Village | IL | 60007 | Gifts | Flag Pins For Students |
757 | 757 | Senate District 10 | Liston, Larry | Republican | 74.99 | 11/20/20 0:00 | Costco | Colorado Springs | CO | 80918 | Gifts | Gift Baskets For Volunteers |
1298 | 1298 | Senate District 17 | Menza, Matthew | Republican | 19.5 | 7/23/20 0:00 | Mashalls | Longmont | CO | 80504 | Gifts | Gifts For Fundraiser Paid With Personal Cc, Paid Back By Campaign Ch1006 Combined |
4009 | 4009 | Senate District 25 | Priola, Kevin | Republican | 400.0 | 9/30/20 0:00 | Westridge Elementary School | Thornton | CO | 80602 | Gifts | |
4073 | 4073 | Senate District 25 | Priola, Kevin | Republican | 50.0 | 10/15/20 0:00 | Menlo Park | CA | 94025 | Gifts | Donation | |
4143 | 4143 | Senate District 25 | Priola, Kevin | Republican | 100.0 | 10/29/19 0:00 | Menlo Park | CA | 94025 | Gifts | Ataxia Foundation | |
4165 | 4165 | Senate District 25 | Priola, Kevin | Republican | 36.0 | 12/15/19 0:00 | Knights Of Columbus | Northglenn | CO | 80234 | Gifts |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_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 );