state_iec
5 rows where affiliation = "Democratic" and type = "Radio"
This data as json, CSV (advanced)
Suggested facets: position, candidate, district
Link | rowid ▼ | committee | vendor | amount_spent | date_spent | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
794 | 794 | Colorado Advocates For Rural Electrification (CARE) | Wr Communications | 445.0 | 10/6/20 | 10/6/20 | Radio | Supporting | Buentello, Brianna Anastasia | Democratic | House District 47 |
1264 | 1264 | Conservation Colorado Victory Fund | Solidarity Strategies, Llc | 30000.0 | 10/20/20 | 10/20-10/27 | Radio | Supporting | Robinson, Leslie A; Soto, Beatriz | Democratic | Garfield County Commissioner |
1308 | 1308 | Earthworks Action Fund Ie Committee | Progressive Promotions | 3000.0 | 10/14/20 | 10/19/2020-11/1/2020 | Radio | Supporting | Shadduck-Mcnally, Jody; Stephens, Kristin | Democratic | Larimer County Commissioner |
1364 | 1364 | Justice First Committee | KBNO | 1610.0 | 10/30/20 | 10/30/20 | Radio | Supporting | Padden, Amy L | Democratic | Arapahoe County District Attorney |
2381 | 2381 | Take Back Colorado | Rearden Strategic, Inc | 11014.3 | 10/21/20 | 10/22/2020-11/2/2020 | Radio | Opposing | Buentello, Brianna Anastasia | Democratic | House District 47 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_iec" ( "committee" TEXT, "vendor" TEXT, "amount_spent" REAL, "date_spent" TEXT, "date_delivered" TEXT, "type" TEXT, "position" TEXT, "candidate" TEXT, "affiliation" TEXT, "district" TEXT );