trad_pacs_exp
19 rows where expenditure_type = "Bank Fees" and state = "AL"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, zip, explanation
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
436 | 436 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 30.0 | 2/15/19 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Compass Bank - Bank Fee |
819 | 819 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 15.0 | 3/28/19 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Compass Bank- Bank Fee |
1016 | 1016 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 15.0 | 4/15/19 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Compass Bank Fee |
1276 | 1276 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 15.0 | 5/15/19 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Compass Bank Fee |
1551 | 1551 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 15.0 | 6/17/19 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Compass Bank |
1865 | 1865 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 15.0 | 7/15/19 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Compass Bank |
2296 | 2296 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 15.0 | 8/15/19 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Compass Bank Fees |
2721 | 2721 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 30.0 | 9/17/19 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Bank Service Charges |
3043 | 3043 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 15.0 | 10/17/19 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Bank Fee |
3075 | 3075 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 30.0 | 11/17/19 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Bank Fee |
3262 | 3262 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 15.0 | 12/15/18 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Compass Bank - Bank Fee |
3856 | 3856 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 15.0 | 1/17/20 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Bbva Compass Bank |
4163 | 4163 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 15.0 | 2/18/20 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Bbva Compass |
4412 | 4412 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 15.0 | 3/16/20 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Bbva Compass Bank |
5927 | 5927 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 18.0 | 7/15/20 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Bank Fee |
7529 | 7529 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 17.0 | 8/17/20 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Bank Fee |
10015 | 10015 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 3.0 | 9/17/20 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Bank Fee |
12917 | 12917 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 1.0 | 10/17/20 0:00 | Compass Bank | Birmingham | AL | 35296 | Bank Fees | Bank Fee |
14783 | 14783 | Pipefitters Local 208 Political Education Committee | Small Donor Committee | 15.0 | 12/17/19 0:00 | Compass Bank | Birmingham | AL | 10566 | Bank Fees | Bbva Compass Bank |
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 );