super_pacs_exp
9 rows where expenditure_type = "Consultant & Professional Services" and zip = 19127
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
1048 | 1048 | Raising Colorado | Independent Expenditure Committee | 57853.25 | 9/30/21 | 40 North Advocacy | Philadelphia | PA | 19127 | Consultant & Professional Services | Direct Mail |
1049 | 1049 | Raising Colorado | Independent Expenditure Committee | 12784.85 | 9/30/21 | 40 North Advocacy | Philadelphia | PA | 19127 | Consultant & Professional Services | Direct Mail |
1080 | 1080 | Raising Colorado | Independent Expenditure Committee | 15054.85 | 10/7/21 | 40 North Advocacy | Philadelphia | PA | 19127 | Consultant & Professional Services | Direct Mail |
1081 | 1081 | Raising Colorado | Independent Expenditure Committee | 14970.01 | 10/7/21 | 40 North Advocacy | Philadelphia | PA | 19127 | Consultant & Professional Services | Direct Mail |
1114 | 1114 | Raising Colorado | Independent Expenditure Committee | 10715.34 | 10/14/21 | 40 North Advocacy | Philadelphia | PA | 19127 | Consultant & Professional Services | Direct Mail |
1115 | 1115 | Raising Colorado | Independent Expenditure Committee | 11258.5 | 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 |
1117 | 1117 | Raising Colorado | Independent Expenditure Committee | 51002.77 | 10/14/21 | 40 North Advocacy | Philadelphia | PA | 19127 | Consultant & Professional Services | Direct Mail |
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 );