trad_pacs_exp
36 rows where expenditure_type = "Advertising" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: committee, committee_type, expenditure_date, recipient, city, zip, explanation
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
896 | 896 | Colorado Democratic Party | Political Party Committee | 175.08 | 4/1/19 0:00 | Palo Alto | CA | 94301 | Advertising | ||
1584 | 1584 | Colorado Democratic Party | Political Party Committee | 500.0 | 6/24/19 0:00 | Palo Alto | CA | 94301 | Advertising | ||
1704 | 1704 | Colorado Democratic Party | Political Party Committee | 315.72 | 7/1/19 0:00 | Palo Alto | CA | 94301 | Advertising | ||
1954 | 1954 | Colorado Democratic Party | Political Party Committee | 500.0 | 7/29/19 0:00 | Palo Alto | CA | 94301 | Advertising | ||
2129 | 2129 | Colorado Democratic Party | Political Party Committee | 90.75 | 8/1/19 0:00 | Palo Alto | CA | 94301 | Advertising | ||
2393 | 2393 | Investher | Political Committee | 7.0 | 8/26/19 0:00 | Snapchat | Santa Monica | CA | 90405 | Advertising | Snapchat Filter For Event Advertising |
2516 | 2516 | Colorado Democratic Party | Political Party Committee | 14.32 | 9/3/19 0:00 | Palo Alto | CA | 94301 | Advertising | ||
3096 | 3096 | Colorado Democratic Party | Political Party Committee | 122.59 | 12/3/18 0:00 | Palo Alto | CA | 94301 | Advertising | ||
3904 | 3904 | One Colorado Small Donor Committee | Small Donor Committee | 37.62 | 1/23/20 0:00 | East Palo Alto | CA | 94303 | Advertising | Facebook Ad | |
3905 | 3905 | One Colorado Small Donor Committee | Small Donor Committee | 22.53 | 1/23/20 0:00 | East Palo Alto | CA | 94303 | Advertising | Facebook Ad | |
4196 | 4196 | One Colorado Small Donor Committee | Small Donor Committee | 12.38 | 2/23/20 0:00 | East Palo Alto | CA | 94303 | Advertising | Facebook Ad | |
4197 | 4197 | One Colorado Small Donor Committee | Small Donor Committee | 7.24 | 2/23/20 0:00 | East Palo Alto | CA | 94303 | Advertising | Facebook Ad | |
4583 | 4583 | Douglas County Municipal Alliance | Political Committee | 240.68 | 4/6/20 0:00 | Uprinting.Com | Van Nuys | CA | 91406 | Advertising | $130 Reimbursed To Barrett Rothe, But This Total Should Be Registered In Aggregate |
4608 | 4608 | Douglas County Municipal Alliance | Political Committee | 182.34 | 4/9/20 0:00 | Uprinting.Com | Van Nuys | CA | 91406 | Advertising | Printing On Uprinting.Com |
4721 | 4721 | Political Committee L 4056 (Local) | Political Committee | 500.0 | 4/25/20 0:00 | Palo Alto | CA | 94304 | Advertising | Internet Boosting Of Video | |
4790 | 4790 | Douglas County Municipal Alliance | Political Committee | 249.32 | 4/30/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4807 | 4807 | Political Committee L 4056 (Local) | Political Committee | 63.68 | 4/30/20 0:00 | Palo Alto | CA | 94304 | Advertising | Internet Boosting Of Video | |
4874 | 4874 | Greater Douglas County | Political Committee | 25.0 | 5/6/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Advertising | |
4912 | 4912 | Political Committee L 4056 (Local) | Political Committee | 236.32 | 5/11/20 0:00 | Me;Lo Park | CA | 94205 | Advertising | Facebook Advertising Boosting | |
6844 | 6844 | Rocky Mountain Gun Owners Political Action Committee (Rmgo Pac) | Small Donor Committee | 133.88 | 8/3/20 0:00 | Menlo Park | CA | 94025 | Advertising | Advertising For Superpac On Facebook | |
8246 | 8246 | Colorado Democratic Party | Political Party Committee | 25.0 | 8/27/20 0:00 | Palo Alto | CA | 94301 | Advertising | ||
8442 | 8442 | Colorado Democratic Party | Political Party Committee | 25.0 | 8/31/20 0:00 | Palo Alto | CA | 94301 | Advertising | ||
9236 | 9236 | Colorado Democratic Party | Political Party Committee | 11.02 | 9/8/20 0:00 | Palo Alto | CA | 94301 | Advertising | ||
9237 | 9237 | Colorado Democratic Party | Political Party Committee | 25.0 | 9/8/20 0:00 | Palo Alto | CA | 94301 | Advertising | ||
9515 | 9515 | Colorado Democratic Party | Political Party Committee | 50.0 | 9/14/20 0:00 | Palo Alto | CA | 94301 | Advertising | ||
9516 | 9516 | Colorado Democratic Party | Political Party Committee | 35.0 | 9/14/20 0:00 | Palo Alto | CA | 94301 | Advertising | ||
10388 | 10388 | Approval Voting Party | Political Party Committee | 16.23 | 9/23/20 0:00 | Zoom Video Communications | San Jose | CA | 95113 | Advertising | |
10785 | 10785 | Colorado Republican Committee | Political Party Committee | 1400.0 | 9/28/20 0:00 | Mountain View | CA | 94043 | Advertising | Digital Ads Run On 9/28/2020 | |
10786 | 10786 | Colorado Republican Committee | Political Party Committee | 105.36 | 9/28/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads Run On Facebook On 9/28/2020 | |
10789 | 10789 | Colorado Republican Committee | Political Party Committee | 887.0 | 9/28/20 0:00 | Mountain View | CA | 94043 | Advertising | Digital Ads Run On 9/28/2020 On Google | |
11093 | 11093 | Colorado Republican Committee | Political Party Committee | 250.0 | 9/30/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads Run On Facebook | |
11094 | 11094 | Colorado Republican Committee | Political Party Committee | 400.0 | 9/30/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads Run On Facebook | |
12049 | 12049 | Colorado Republican Committee | Political Party Committee | 553.0 | 10/8/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads For Lynn For Sd19 | |
12050 | 12050 | Colorado Republican Committee | Political Party Committee | 221.51 | 10/8/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads For Caroline Cornell | |
12118 | 12118 | Colorado Republican Committee | Political Party Committee | 3123.0 | 10/9/20 0:00 | Mountain View | CA | 94043 | Advertising | Lynn Gerber For Sd19 | |
12972 | 12972 | Colorado Republican Committee | Political Party Committee | 350.64 | 10/19/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads For Lynn Gerber |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "trad_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 );