senate_cand_exp
1 row where district = "Senate District 10" and expenditure_type = "Rent & Utilities"
This data as json, CSV (advanced)
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
616 | 616 | Senate District 10 | Liston, Larry | Republican | 54.14 | 1/25/20 0:00 | Jody Richie | Colorado Springs | CO | 80918 | Rent & Utilities | Reimbursement: Amazon: 22.96 - Clipboard The Copy Store: 31.18 - Petition Printing |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_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 );