house_exp
3 rows where expenditure_type = "Gifts" and state = "CA"
This data as json, CSV (advanced)
Link | rowid ▼ | District | candidate_name | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
1518 | 1518 | House District 08 | Leslie Herod | 9.99 | 10/23/21 | Google Gsuite | Mountain View | CA | 94043 | Gifts | Google Suite Storage |
11368 | 11368 | House District 42 | Mandy Lindsay | 34.65 | 12/8/22 | Paypal | San Jose | CA | 95131 | Gifts | Keynote Speaker'S Book |
13767 | 13767 | House District 54 | Matt Soper | 179.0 | 1/9/21 | Stackcommerce | Venice | CA | 90291 | Gifts | Gifts To Key Campaign Volunteers. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_exp" ( "District" TEXT, "candidate_name" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );