super_pacs_exp
6 rows where expenditure_type = "Advertising", state = "AZ" and zip = 85260
This data as json, CSV (advanced)
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
244 | 244 | Coloradans Against Jared Polis | Independent Expenditure Committee | 31.14 | 2/25/21 | Godaddy | Scottsdale | AZ | 85260 | Advertising | |
292 | 292 | Coloradans Against Jared Polis | Independent Expenditure Committee | 18.17 | 3/3/21 | Godaddy | Scottsdale | AZ | 85260 | Advertising | |
351 | 351 | Coloradans Against Jared Polis | Independent Expenditure Committee | 29.75 | 3/21/21 | Godaddy | Scottsdale | AZ | 85260 | Advertising | |
857 | 857 | Coloradans Against Jared Polis | Independent Expenditure Committee | 19.17 | 8/2/21 | Godaddy | Scottsdale | AZ | 85260 | Advertising | |
934 | 934 | Coloradans Against Jared Polis | Independent Expenditure Committee | 21.17 | 8/31/21 | Godaddy | Scottsdale | AZ | 85260 | Advertising | |
1008 | 1008 | Coloradans Against Jared Polis | Independent Expenditure Committee | 22.34 | 9/23/21 | Godaddy | Scottsdale | AZ | 85260 | Advertising |
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 );