state_exp
7 rows where Party = "Democratic", expenditure_type = "Telephone" and explanation = "Cell Phone Stipend"
This data as json, CSV (advanced)
Suggested facets: city, state, zip
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
5398 | 5398 | Governor | Jared Polis | Democratic | 25.0 | 2/15/22 | Sarah Andrews | Denver | CO | 80236 | Telephone | Cell Phone Stipend |
5400 | 5400 | Governor | Jared Polis | Democratic | 25.0 | 2/15/22 | Hayley Drapkin | Denver | CO | 80236 | Telephone | Cell Phone Stipend |
5402 | 5402 | Governor | Jared Polis | Democratic | 25.0 | 2/15/22 | Emily Haddaway | Denver | CO | 80236 | Telephone | Cell Phone Stipend |
5404 | 5404 | Governor | Jared Polis | Democratic | 25.0 | 2/15/22 | Julia Harrington | Washington | DC | 20002 | Telephone | Cell Phone Stipend |
5406 | 5406 | Governor | Jared Polis | Democratic | 25.0 | 2/15/22 | Amber Miller | Denver | CO | 80236 | Telephone | Cell Phone Stipend |
5408 | 5408 | Governor | Jared Polis | Democratic | 25.0 | 2/15/22 | Jose Soto | Greenville | NC | 27858 | Telephone | Cell Phone Stipend |
5410 | 5410 | Governor | Jared Polis | Democratic | 25.0 | 2/15/22 | Danielle Young-Kombo | Denver | CO | 80236 | Telephone | Cell Phone Stipend |
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 );