state_exp
8 rows where candidate_name = "Peggy Propst" and expenditure_type = "Bank Fees"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, recipient, city, state, zip
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
8531 | 8531 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 5.0 | 5/2/22 | 1St Bank | Brighton | CO | 80631 | Bank Fees | |
8532 | 8532 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 8.3 | 5/7/22 | Anedot | New Orleans | LA | 70112 | Bank Fees | |
8538 | 8538 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 61.0 | 5/25/22 | Anedot | New Orleans | LA | 70112 | Bank Fees | |
8610 | 8610 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 5.0 | 10/3/22 | Firstbank North | Arvada | CO | 80006 | Bank Fees | |
8611 | 8611 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 56.98 | 10/5/22 | Anedot | Baton Rouge | LA | 70808 | Bank Fees | |
8614 | 8614 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 41.4 | 10/23/22 | Anedot | Baton Rouge | LA | 70808 | Bank Fees | |
8616 | 8616 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 7.34 | 11/4/22 | Anedot | Baton Rouge | LA | 70808 | Bank Fees | |
8620 | 8620 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 5.0 | 12/1/22 | Firstbank North | Arvada | CO | 80006 | Bank Fees |
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 );