ed_cand_exp
2 rows where state = "TN" sorted by expenditure_type
This data as json, CSV (advanced)
Link | rowid | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type ▼ | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
805 | 805 | CU Regent District 02 | Harber, Aaron | Democratic | 2500.0 | 8/6/20 0:00 | Text Request | Chattanooga | TN | 37408 | Advertising | Ongoing Text |
785 | 785 | CU Regent District 02 | Harber, Aaron | Democratic | 3049.0 | 5/15/20 0:00 | Text Request | Chattanooga | TN | 37408 | Consultant & Professional Services |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "ed_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 );