state_exp
5 rows where District = "CU Regent District 04" and city = "Somerville"
This data as json, CSV (advanced)
Suggested facets: zip, expenditure_type, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
8241 | 8241 | CU Regent District 04 | Robert Barrionton | Democratic | 0.4 | 6/15/22 | Actblue Technical Services | Somerville | MA | 2144 | Fundraising Expenses | Actblue Fee |
8244 | 8244 | CU Regent District 04 | Robert Barrionton | Democratic | 1.98 | 7/17/22 | Actblue Technical Services | Somerville | MA | 2144 | Fundraising Expenses | |
8256 | 8256 | CU Regent District 04 | Robert Barrionton | Democratic | 0.99 | 9/25/22 | Actblue Technical Services | Somerville | MA | 02144-3132 | Contributions | Actblue Charge |
8261 | 8261 | CU Regent District 04 | Robert Barrionton | Democratic | 3.96 | 10/2/22 | Actblue Technical Services | Somerville | MA | 02144-3132 | Fundraising Expenses | Actblue Fee |
8264 | 8264 | CU Regent District 04 | Robert Barrionton | Democratic | 3.95 | 10/9/22 | Actblue Technical Services | Somerville | MA | 02144-3132 | Fundraising Expenses | Actblue Fee |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_exp" ( "District" TEXT, "candidate_name" TEXT, "Party" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );