da_cand_exp
6 rows where expenditure_type = "Consultant & Professional Services" and state = "TX"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
771 | 771 | DA 2 Denver | Mccann, Beth | Democratic | 14.99 | 1/7/19 0:00 | Site5 | Austin | TX | 78754 | Consultant & Professional Services | |
795 | 795 | DA 2 Denver | Mccann, Beth | Democratic | 19.95 | 11/19/18 0:00 | Site5 | Austin | TX | 78754 | Consultant & Professional Services | |
2415 | 2415 | DA 11 Park et al | Turner, Kaitlin | Democratic | 415.65 | 9/6/20 0:00 | Uz Marketing Print Materials | Houston | TX | 77092 | Consultant & Professional Services | |
2417 | 2417 | DA 11 Park et al | Turner, Kaitlin | Democratic | -415.65 | 9/6/20 0:00 | Uz Marketing Print Materials | Houston | TX | 77092 | Consultant & Professional Services | Offset Due To Update Of Filed Item |
2418 | 2418 | DA 11 Park et al | Turner, Kaitlin | Democratic | 415.65 | 9/6/20 0:00 | Uz Marketing Print Materials | Houston | TX | 77092 | Consultant & Professional Services | Yard Signs |
2419 | 2419 | DA 11 Park et al | Turner, Kaitlin | Democratic | -415.65 | 9/6/20 0:00 | Uz Marketing Print Materials | Houston | TX | 77092 | Consultant & Professional Services | Offset Due To Deletion Of Filed Item - Yard Signs |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "da_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 );