house_cand_exp
9 rows where expenditure_type = "Fundraising Expenses" and zip = 95131
This data as json, CSV (advanced)
Suggested facets: district, candidate, expenditure_amount, expenditure_date
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
4992 | 4992 | House District 23 | Clifford, Fred | Republican | 1.75 | 4/8/20 0:00 | Paypal | San Jose | CA | 95131 | Fundraising Expenses | Donation Transaction Fee |
5007 | 5007 | House District 23 | Clifford, Fred | Republican | 3.93 | 6/9/20 0:00 | Paypal | San Jose | CA | 95131 | Fundraising Expenses | |
5008 | 5008 | House District 23 | Clifford, Fred | Republican | 0.88 | 6/18/20 0:00 | Paypal | San Jose | CA | 95131 | Fundraising Expenses | |
5009 | 5009 | House District 23 | Clifford, Fred | Republican | 1.03 | 7/5/20 0:00 | Paypal | San Jose | CA | 95131 | Fundraising Expenses | Payment Fee From Mason Lee Donation |
5010 | 5010 | House District 23 | Clifford, Fred | Republican | 4.65 | 7/5/20 0:00 | Paypal | San Jose | CA | 95131 | Fundraising Expenses | Paypal Donation Expense For Donna Ytterberg. |
5013 | 5013 | House District 23 | Clifford, Fred | Republican | 0.74 | 7/19/20 0:00 | Paypal | San Jose | CA | 95131 | Fundraising Expenses | |
5014 | 5014 | House District 23 | Clifford, Fred | Republican | 0.88 | 7/19/20 0:00 | Paypal | San Jose | CA | 95131 | Fundraising Expenses | |
5015 | 5015 | House District 23 | Clifford, Fred | Republican | 1.75 | 7/22/20 0:00 | Paypal | San Jose | CA | 95131 | Fundraising Expenses | |
13423 | 13423 | House District 54 | Soper, Matt | Republican | 24.92 | 2/7/20 0:00 | Paypal | San Jose | CA | 95131 | Fundraising Expenses | Credit Card Reader |
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 );