state_exp
7 rows where candidate_name = "Peggy Propst" and city = "Wheat Ridge"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, recipient, expenditure_type, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
8540 | 8540 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 1500.0 | 6/1/22 | Orgo Marketing | Wheat Ridge | CO | 80033 | Other | 6142 ∑ Production & Design |
8553 | 8553 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 1000.0 | 6/22/22 | Orgo Marketing | Wheat Ridge | CO | 80033 | Other | 6142 ∑ Production & Design |
8559 | 8559 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 1000.0 | 7/11/22 | Orgo Marketing | Wheat Ridge | CO | 80033 | Other | 7420 ∑ Media Consultants |
8579 | 8579 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 1000.0 | 8/10/22 | Orgo Marketing | Wheat Ridge | CO | 80033 | Other | 6400 ∑ Website Expense |
8594 | 8594 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 1000.0 | 9/2/22 | Kathryn Mills | Wheat Ridge | CO | 80033 | Other | 7400 ∑ Consultant Expense |
8612 | 8612 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 1000.0 | 10/13/22 | Kathryn Mills | Wheat Ridge | CO | 80033 | Consultant & Professional Services | |
8617 | 8617 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 1500.0 | 11/7/22 | Kathryn Mills | Wheat Ridge | CO | 80033 | Consultant & Professional Services |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_exp" ( "District" TEXT, "candidate_name" TEXT, "Party" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );