state_exp
7 rows where city = "Colorado Springs" and expenditure_type = "Miscellaneous"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, Party, expenditure_amount, recipient, zip, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
6625 | 6625 | Governor | Jared Polis | Democratic | 17.99 | 12/7/21 | Colorado Springs Gazette | Colorado Springs | CO | 80903 | Miscellaneous | News Subscription |
6669 | 6669 | Governor | Jared Polis | Democratic | 12.99 | 12/28/21 | Colorado Springs Gazette | Colorado Springs | CO | 80903 | Miscellaneous | News Subscription |
6726 | 6726 | Governor | Jared Polis | Democratic | 12.99 | 1/17/19 | Colorado Springs Gazette | Colorado Springs | CO | 80903 | Miscellaneous | Subscription |
6973 | 6973 | Governor | Jared Polis | Democratic | 12.99 | 12/19/18 | Colorado Springs Gazette | Colorado Springs | CO | 80903 | Miscellaneous | Subscription |
7981 | 7981 | CU Regent District 05 | Ken Montera | Republican | 400.0 | 10/19/22 | Jody Richie | Colorado Springs | CO | 80918 | Miscellaneous | Election Night Party |
8495 | 8495 | BD. ED. DISTRICT 08 | Rhonda Solis | Democratic | 700.0 | 12/3/22 | Clancy Consulting | Colorado Springs | CO | 80910 | Miscellaneous | Worked On Campaign |
10028 | 10028 | Attorney General | John Kellner | Republican | 150.0 | 7/28/22 | El Paso County Republican Central Committee | Colorado Springs | CO | 80919 | Miscellaneous |
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 );