state_iec
18 rows where affiliation = "Republican", district = "House District 27" and position = "Opposing"
This data as json, CSV (advanced)
Suggested facets: vendor, amount_spent, date_spent, date_delivered, type
Link | rowid ▼ | committee | vendor | amount_spent | date_spent | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
224 | 224 | Better Colorado Alliance | Blueprint Interactive | 20000.0 | 9/18/20 | 9/22/2020-10/5/2020 | Internet | Opposing | Pyne, Vicki C | Republican | House District 27 |
225 | 225 | Better Colorado Alliance | Blueprint Interactive | 10000.0 | 10/6/20 | 10/6/2020-10/19/2020 | Internet | Opposing | Pyne, Vicki C | Republican | House District 27 |
226 | 226 | Better Colorado Alliance | Blueprint Interactive | 10000.0 | 10/6/20 | 10/6/2020-10/19/2020 | Internet | Opposing | Pyne, Vicki C | Republican | House District 27 |
227 | 227 | Better Colorado Alliance | Blueprint Interactive | 10000.0 | 10/19/20 | 10/20/2020-11/3/2020 | Internet | Opposing | Pyne, Vicki C | Republican | House District 27 |
228 | 228 | Better Colorado Alliance | Blueprint Interactive | 10000.0 | 10/19/20 | 10/20/2020-11/3/2020 | Internet | Opposing | Pyne, Vicki C | Republican | House District 27 |
229 | 229 | Better Colorado Alliance | Blueprint Interactive | 10000.0 | 10/28/20 | 10/28/2020-11/3/2020 | Internet | Opposing | Pyne, Vicki C | Republican | House District 27 |
230 | 230 | Better Colorado Alliance | Gumbinner & Davies | 14358.57 | 9/14/20 | 9/15/20 | Mailing | Opposing | Pyne, Vicki C | Republican | House District 27 |
231 | 231 | Better Colorado Alliance | Gumbinner & Davies | 14358.57 | 9/14/20 | 9/18/20 | Mailing | Opposing | Pyne, Vicki C | Republican | House District 27 |
232 | 232 | Better Colorado Alliance | Gumbinner & Davies | 13395.69 | 9/21/20 | 9/22/20 | Mailing | Opposing | Pyne, Vicki C | Republican | House District 27 |
233 | 233 | Better Colorado Alliance | Gumbinner & Davies | 16087.23 | 9/21/20 | 9/25/20 | Mailing | Opposing | Pyne, Vicki C | Republican | House District 27 |
234 | 234 | Better Colorado Alliance | Gumbinner & Davies | 14364.29 | 9/29/20 | 9/29/20 | Mailing | Opposing | Pyne, Vicki C | Republican | House District 27 |
235 | 235 | Better Colorado Alliance | Gumbinner & Davies | 13395.69 | 9/29/20 | 10/2/20 | Mailing | Opposing | Pyne, Vicki C | Republican | House District 27 |
236 | 236 | Better Colorado Alliance | Gumbinner & Davies | 12103.23 | 10/6/20 | 10/9/20 | Mailing | Opposing | Pyne, Vicki C | Republican | House District 27 |
237 | 237 | Better Colorado Alliance | Gumbinner & Davies | 12922.05 | 10/13/20 | 10/13/20 | Mailing | Opposing | Pyne, Vicki C | Republican | House District 27 |
238 | 238 | Better Colorado Alliance | Gumbinner & Davies | 16160.01 | 10/13/20 | 10/16/20 | Mailing | Opposing | Pyne, Vicki C | Republican | House District 27 |
239 | 239 | Better Colorado Alliance | Gumbinner & Davies | 13425.21 | 10/19/20 | 10/20/20 | Mailing | Opposing | Pyne, Vicki C | Republican | House District 27 |
240 | 240 | Better Colorado Alliance | Gumbinner & Davies | 12070.1 | 10/19/20 | 10/22/20 | Mailing | Opposing | Pyne, Vicki C | Republican | House District 27 |
241 | 241 | Better Colorado Alliance | Gumbinner & Davies | 11671.1 | 10/26/20 | 10/26/20 | Mailing | Opposing | Pyne, Vicki C | Republican | House District 27 |
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 );