super_pacs_exp
5 rows where expenditure_type = "Advertising" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: committee, expenditure_date, recipient, city, zip, explanation
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
355 | 355 | Blueflower Action | Independent Expenditure Committee | 3700.0 | 3/22/21 | Menlo Park | CA | 94205 | Advertising | Digital | |
357 | 357 | Blueflower Action | Independent Expenditure Committee | 3000.0 | 3/22/21 | Mt. View | CA | 94043 | Advertising | Digital | |
1300 | 1300 | New Americans Victory Fund | Independent Expenditure Committee | 185.86 | 12/7/20 | Menlo Park | CA | 94025 | Advertising | Digital Advertiging In Support Of Bri Buentello For Hd47 | |
1301 | 1301 | New Americans Victory Fund | Independent Expenditure Committee | 174.1 | 12/7/20 | Menlo Park | CA | 94025 | Advertising | Digital Advertising In Support Of Paula Dickerson For Sd-2 | |
1319 | 1319 | Conservation Colorado Victory Fund | Independent Expenditure Committee | 721.52 | 12/10/20 | Menlo Park | CA | 94025 | Advertising | Training Video |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "super_pacs_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 );