trad_pacs_exp
51 rows where expenditure_type = "Advertising" and state = "CA"
This data as json, CSV (advanced)
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
10751 | 10751 | Colorado Center Party Central Committee | Political Party Committee | 10.0 | 9/28/22 | Menlo Park | CA | 94025 | Advertising | ||
10845 | 10845 | Colorado Center Party Central Committee | Political Party Committee | 10.0 | 9/29/22 | Menlo Park | CA | 94025 | Advertising | ||
10925 | 10925 | Colorado Center Party Central Committee | Political Party Committee | 10.0 | 9/30/22 | Menlo Park | CA | 94025 | Advertising | ||
11014 | 11014 | Colorado Center Party Central Committee | Political Party Committee | 15.0 | 10/1/22 | Menlo Park | CA | 94025 | Advertising | ||
11015 | 11015 | Colorado Center Party Central Committee | Political Party Committee | 29.97 | 10/1/22 | Google Ads | Mountain View | CA | 94043 | Advertising | |
11032 | 11032 | Colorado Center Party Central Committee | Political Party Committee | 15.0 | 10/2/22 | Menlo Park | CA | 94025 | Advertising | ||
11070 | 11070 | Colorado Center Party Central Committee | Political Party Committee | 5.61 | 10/3/22 | Menlo Park | CA | 94025 | Advertising | ||
11098 | 11098 | Moving Mountains | Small Donor Committee | 11.34 | 10/3/22 | G Suites | Mountain View | CA | 94043 | Advertising | |
11341 | 11341 | Colorado Center Party Central Committee | Political Party Committee | 25.0 | 10/6/22 | Menlo Park | CA | 94025 | Advertising | ||
11511 | 11511 | Combine | Small Donor Committee | 48.38 | 10/9/21 | Wild Apricot | Toronto | CA | ON M5J 2L7 | Advertising | |
11826 | 11826 | Colorado Center Party Central Committee | Political Party Committee | 350.0 | 10/12/22 | Google Ads | Mountain View | CA | 94043 | Advertising | |
12125 | 12125 | Colorado Center Party Central Committee | Political Party Committee | 35.0 | 10/14/22 | Menlo Park | CA | 94025 | Advertising | Internet Advertising | |
12902 | 12902 | Colorado Center Party Central Committee | Political Party Committee | 1.99 | 10/24/22 | Google Ads | Mountain View | CA | 94043 | Advertising | Internet Advertising |
13505 | 13505 | Colorado Center Party Central Committee | Political Party Committee | 130.61 | 11/2/22 | Google Ads | Mountain View | CA | 94043 | Advertising | |
13585 | 13585 | Colorado Center Party Central Committee | Political Party Committee | 305.25 | 11/3/22 | Menlo Park | CA | 94025 | Advertising | ||
13802 | 13802 | Combine | Small Donor Committee | 48.38 | 11/9/21 | Wild Apricot | Toronto | CA | ON M5J 2L7 | Advertising | |
14237 | 14237 | Colorado Center Party Central Committee | Political Party Committee | 1.99 | 11/24/22 | Google Ads | Mountain View | CA | 94043 | Advertising | |
14425 | 14425 | Colorado Center Party Central Committee | Political Party Committee | 416.85 | 12/1/22 | Google Ads | Mountain View | CA | 94043 | Advertising | |
14490 | 14490 | Colorado Center Party Central Committee | Political Party Committee | 305.31 | 12/3/22 | Menlo Park | CA | 94025 | Advertising | ||
14617 | 14617 | Combine | Small Donor Committee | 49.38 | 12/9/21 | Wild Apricot | Toronto | CA | ON M5J 2L7 | Advertising |
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 );