trad_pacs_exp
3 rows where city = "Somerville" and expenditure_type = "Miscellaneous" sorted by expenditure_type
This data as json, CSV (advanced)
Link | rowid | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type ▼ | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
3090 | 3090 | Sweep Blue | Political Committee | 24.69 | 1/2/22 | Actblue | Somerville | MA | 2144 | Miscellaneous | |
6195 | 6195 | Sweep Blue | Political Committee | 24.69 | 7/3/22 | Actblue | Somerville | MA | 2144 | Miscellaneous | |
7157 | 7157 | Sweep Blue | Political Committee | 24.69 | 7/31/22 | Actblue | Somerville | MA | 2144 | Miscellaneous |
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 );