issue_comm_exp
4 rows where expenditure_type = "Miscellaneous" and zip = 10014
This data as json, CSV (advanced)
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
2806 | 2806 | Coloradans For National Popular Vote | Issue Committee | 20.0 | 8/19/19 0:00 | Squarespace | New York | NY | 10014 | Miscellaneous | |
2807 | 2807 | Coloradans For National Popular Vote | Issue Committee | 20.0 | 8/19/19 0:00 | Squarespace | New York | NY | 10014 | Miscellaneous | |
2808 | 2808 | Coloradans For National Popular Vote | Issue Committee | 20.0 | 8/19/19 0:00 | Squarespace | New York | NY | 10014 | Miscellaneous | |
2809 | 2809 | Coloradans For National Popular Vote | Issue Committee | 20.0 | 8/19/19 0:00 | Squarespace | New York | NY | 10014 | Miscellaneous |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "issue_comm_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 );