house_cand_exp
4 rows where expenditure_type = "Food, Beverages and Meals" and state = "MT"
This data as json, CSV (advanced)
Suggested facets: expenditure_date, city, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
10495 | 10495 | House District 42 | Jackson, Dominique | Democratic | 72.32 | 7/16/19 0:00 | The Country Market | Gallatin Gateway | MT | 59730 | Food, Beverages and Meals | Council Of State Governments |
10504 | 10504 | House District 42 | Jackson, Dominique | Democratic | 25.0 | 7/19/19 0:00 | The Lotus Pad | Big Sky | MT | 59716 | Food, Beverages and Meals | Council Of State Governments |
10505 | 10505 | House District 42 | Jackson, Dominique | Democratic | 24.6 | 7/19/19 0:00 | Big Sky F&B Dining | Big Sky | MT | 59716 | Food, Beverages and Meals | Council Of State Governments |
10506 | 10506 | House District 42 | Jackson, Dominique | Democratic | 7.04 | 7/22/19 0:00 | Thriftway | Bozeman | MT | 59718 | Food, Beverages and Meals | Council Of State Governments |
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 );