state_exp
11 rows where expenditure_type = "Rent & Utilities" and explanation = "Utilities"
This data as json, CSV (advanced)
Suggested facets: expenditure_date, recipient, city, state, zip
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
6707 | 6707 | Governor | Jared Polis | Democratic | 698.49 | 1/11/19 | Comcast | Seattle | WA | 98124 | Rent & Utilities | Utilities |
6731 | 6731 | Governor | Jared Polis | Democratic | 114.67 | 1/22/19 | Xcel Energy | Minneapolis | MN | 55484 | Rent & Utilities | Utilities |
6736 | 6736 | Governor | Jared Polis | Democratic | 135.0 | 1/29/19 | Master Sanitation | Broomfield | CO | 80020 | Rent & Utilities | Utilities |
6747 | 6747 | Governor | Jared Polis | Democratic | 244.21 | 2/11/19 | Comcast | Seattle | WA | 98124 | Rent & Utilities | Utilities |
6756 | 6756 | Governor | Jared Polis | Democratic | 26.75 | 2/21/19 | Shred It | Denver | CO | 80207 | Rent & Utilities | Utilities |
6913 | 6913 | Governor | Jared Polis | Democratic | 294.83 | 12/6/18 | Comcast | Seattle | WA | 98124 | Rent & Utilities | Utilities |
6917 | 6917 | Governor | Jared Polis | Democratic | 74.25 | 12/6/18 | Northern Colorado Disposal | Greeley | CO | 80631 | Rent & Utilities | Utilities |
6919 | 6919 | Governor | Jared Polis | Democratic | 25.0 | 12/6/18 | Shred It | Denver | CO | 80207 | Rent & Utilities | Utilities |
6924 | 6924 | Governor | Jared Polis | Democratic | 333.0 | 12/10/18 | Master Sanitation | Broomfield | CO | 80020 | Rent & Utilities | Utilities |
6942 | 6942 | Governor | Jared Polis | Democratic | 43.81 | 12/13/18 | Black Hills Energy | Rapid City | SD | 57709 | Rent & Utilities | Utilities |
6988 | 6988 | Governor | Jared Polis | Democratic | 651.76 | 12/26/18 | Xcel Energy | Minneapolis | MN | 55484 | Rent & Utilities | Utilities |
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 );