house_cand_exp
2 rows where expenditure_type = "Other" and state = "IS"
This data as json, CSV (advanced)
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
3178 | 3178 | House District 14 | Foley, John | Democratic | 9.9 | 7/10/20 0:00 | Wix.Com Ltd | Tel Aviv | IS | 6350671 | Other | Campaign Committee Paid For Wix Email For July 10, 2020-July 10,2021. |
3179 | 3179 | House District 14 | Foley, John | Democratic | 6.5 | 7/10/20 0:00 | Wix.Com Ltd | Tel Aviv | IS | 6350671 | Other | Campaign Committee Pd. Monthly Fee For Email |
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 );