house_cand_exp
8 rows where expenditure_type = "Food, Beverages and Meals" and state = "MA"
This data as json, CSV (advanced)
Suggested facets: district, candidate, expenditure_amount, expenditure_date, recipient, city, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
340 | 340 | House District 02 | Garnett, Alec | Democratic | 380.0 | 4/2/20 0:00 | Ngp | Somerville | MA | 2144 | Food, Beverages and Meals | |
350 | 350 | House District 02 | Garnett, Alec | Democratic | 380.0 | 6/2/20 0:00 | Ngp | Somerville | MA | 2144 | Food, Beverages and Meals | |
8743 | 8743 | House District 37 | Sullivan, Tom | Democratic | 2.18 | 2/9/20 0:00 | Act Blue | Somerville | MA | 02144-3132 | Food, Beverages and Meals | |
10468 | 10468 | House District 42 | Jackson, Dominique | Democratic | 6.1 | 6/4/19 0:00 | Starbucks | Boston | MA | 2128 | Food, Beverages and Meals | Meeting |
10472 | 10472 | House District 42 | Jackson, Dominique | Democratic | 97.77 | 6/10/19 0:00 | Saltie Girl | Boston | MA | 2116 | Food, Beverages and Meals | Meeting |
10481 | 10481 | House District 42 | Jackson, Dominique | Democratic | 8.03 | 6/18/19 0:00 | Felipes Tequeri | Cambridge | MA | 2138 | Food, Beverages and Meals | Meeting |
10482 | 10482 | House District 42 | Jackson, Dominique | Democratic | 16.69 | 6/24/19 0:00 | Tst Four Bakery | Cambridge | MA | 2138 | Food, Beverages and Meals | Meeting |
10483 | 10483 | House District 42 | Jackson, Dominique | Democratic | 30.68 | 6/24/19 0:00 | Russell House | Cambridge | MA | 2138 | Food, Beverages and Meals | Meeting |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_cand_exp" ( "district" TEXT, "candidate" TEXT, "affiliation" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );