issue_comm_exp
3 rows where city = "Seattle" and expenditure_type = "Gifts"
This data as json, CSV (advanced)
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
1204 | 1204 | Weld Re-4 Together | Issue Committee | 480.87 | 7/22/22 | Amazon | Seattle | WA | 98109 | Gifts | Beach Ball To Give Out At Information Tables Order# 112-5143903-5683402 |
2281 | 2281 | Weld Re-4 Together | Issue Committee | 147.47 | 11/14/22 | Amazon | Seattle | WA | 98109 | Gifts | Campaign Gifts |
2385 | 2385 | Weld Re-4 Together | Issue Committee | 45.02 | 12/8/22 | Amazon | Seattle | WA | 98109 | Gifts |
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 );