state_exp
5 rows where city = "Denver" and expenditure_type = "Gifts"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, Party, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
3618 | 3618 | Governor | Heidi Ganahl | Republican | 174.3 | 5/3/22 | Sugarwish | Denver | CO | 80231 | Gifts | |
5899 | 5899 | Governor | Jared Polis | Democratic | 104.22 | 7/11/22 | The Perfect Petal | Denver | CO | 80211 | Gifts | Flowers |
6369 | 6369 | Governor | Jared Polis | Democratic | 154.29 | 10/19/22 | Blooms By Anushka | Denver | CO | 80206 | Gifts | Flowers |
6653 | 6653 | Governor | Jared Polis | Democratic | 245.0 | 12/16/21 | Governor'S Residence Preservation Fund | Denver | CO | 80203 | Gifts | Ornaments |
8076 | 8076 | CU Regent District 01 | Wanda James | Democratic | 40.0 | 5/24/22 | Denver Democratic Central Committee | Denver | CO | 80209 | Gifts | Hd 1 Chili Cook-Off Event Tickets |
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 );