super_pacs_exp
1 row where expenditure_date = "10/21/21" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
1145 | 1145 | Raising Colorado | Independent Expenditure Committee | 14204.23 | 10/21/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 );