issue_comm_exp
9 rows where recipient = "Uplift" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
402 | 402 | Yes On Prop. 119 | Issue Committee | 65000.0 | 9/1/21 | Uplift | Berkeley | CA | 94704 | Advertising | Digital Advertising |
445 | 445 | Yes On Prop. 119 | Issue Committee | 48000.0 | 9/17/21 | Uplift | Berkeley | CA | 94704 | Advertising | Digital Advertising |
452 | 452 | Yes On Prop. 119 | Issue Committee | 92000.0 | 9/20/21 | Uplift | Berkeley | CA | 94704 | Advertising | Digital Advertising |
483 | 483 | Yes On Prop. 119 | Issue Committee | 50000.0 | 10/1/21 | Uplift | Berkeley | CA | 94704 | Advertising | Digital Advertising |
544 | 544 | Yes On Prop. 119 | Issue Committee | 100000.0 | 10/22/21 | Uplift | Berkeley | CA | 94704 | Advertising | Digital Advertising |
555 | 555 | Yes On Prop. 119 | Issue Committee | 40000.0 | 10/25/21 | Uplift | Berkeley | CA | 94704 | Advertising | Digital Advertising |
572 | 572 | Yes On Prop. 119 | Issue Committee | 40000.0 | 10/28/21 | Uplift | Berkeley | CA | 94704 | Advertising | Digital Advertising |
580 | 580 | Yes On Prop. 119 | Issue Committee | 40000.0 | 10/29/21 | Uplift | Berkeley | CA | 94704 | Advertising | Digital Advertising |
592 | 592 | Yes On Prop. 119 | Issue Committee | 30000.0 | 11/1/21 | Uplift | Berkeley | CA | 94704 | Advertising | Digital Advertising |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "issue_comm_exp" ( "committee" TEXT, "committee_type" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );