super_pacs_exp
2 rows where expenditure_amount = "10715.34" and expenditure_type = "Consultant & Professional Services"
This data as json, CSV (advanced)
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
1114 | 1114 | Raising Colorado | Independent Expenditure Committee | 10715.34 | 10/14/21 | 40 North Advocacy | Philadelphia | PA | 19127 | Consultant & Professional Services | Direct Mail |
1116 | 1116 | Raising Colorado | Independent Expenditure Committee | 10715.34 | 10/14/21 | 40 North Advocacy | Philadelphia | PA | 19127 | Consultant & Professional Services | Direct Mail |
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 );