trad_pacs_exp
6 rows where expenditure_type = "Advertising" and state = "WA"
This data as json, CSV (advanced)
Suggested facets: expenditure_date
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
6137 | 6137 | Colorado Center Party Central Committee | Political Party Committee | 4.99 | 6/30/22 | White Pages | Seattle | WA | 98108 | Advertising | |
6138 | 6138 | Colorado Center Party Central Committee | Political Party Committee | 4.99 | 6/30/22 | White Pages | Seattle | WA | 98108 | Advertising | |
7144 | 7144 | Colorado Center Party Central Committee | Political Party Committee | 4.99 | 7/31/22 | White Pages | Seattle | WA | 98108 | Advertising | |
8735 | 8735 | Colorado Center Party Central Committee | Political Party Committee | 4.99 | 8/31/22 | White Pages | Seattle | WA | 98108 | Advertising | |
13387 | 13387 | Colorado Center Party Central Committee | Political Party Committee | 4.99 | 10/31/22 | White Pages | Seattle | WA | 98108 | Advertising | |
14371 | 14371 | Colorado Center Party Central Committee | Political Party Committee | 4.99 | 11/30/22 | White Pages | Seattle | WA | 98108 | 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 );