state_iec
23 rows where vendor = "Effectv"
This data as json, CSV (advanced)
Suggested facets: committee, amount_spent, date_spent, date_delivered, candidate, affiliation, district
position 3 ✖
Link | rowid ▼ | committee | vendor | amount_spent | date_spent | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
289 | 289 | Better Jobs Coalition | Effectv | 21250.0 | 5/29/20 | 5/30/20 - 6/30/20 | Television | Supporting | Larson, Colin | Republican | House District 22 |
290 | 290 | Better Jobs Coalition | Effectv | 4250.0 | 6/8/20 | 6/9/20 - 6/15/20 | Television | Supporting | Larson, Colin | Republican | House District 22 |
291 | 291 | Better Jobs Coalition | Effectv | 34000.0 | 6/16/20 | 6/16/20 - 6/30/20 | Television | Supporting | Larson, Colin | Republican | House District 22 |
292 | 292 | Better Jobs Coalition | Effectv | -34000.0 | 6/16/20 | 6/16/20 - 6/30/20 | Television | Supporting | Larson, Colin | Republican | House District 22 |
293 | 293 | Better Jobs Coalition | Effectv | 18992.0 | 6/16/20 | 6/16/20 - 6/30/20 | Television | Supporting | Larson, Colin | Republican | House District 22 |
301 | 301 | Better Jobs Coalition | Effectv | 10625.0 | 6/11/20 | 6/13/20 - 6/20/20 | Television | Supporting | Lynch, Michael Spencer | Republican | House District 49 |
302 | 302 | Better Jobs Coalition | Effectv | 10625.0 | 6/15/20 | 6/17/20 - 6/30/20 | Television | Supporting | Lynch, Michael Spencer | Republican | House District 49 |
303 | 303 | Better Jobs Coalition | Effectv | 17005.95 | 6/17/20 | 6/18/20 - 6/30/20 | Television | Supporting | Lynch, Michael Spencer | Republican | House District 49 |
306 | 306 | Better Jobs Coalition | Effectv | 56000.0 | 10/17/20 | 10/19/20 - 11/3/20 | Television | Supporting/Opposing | Rosier, Donald/Cutter, Lisa Ann | Republican | House District 25 |
307 | 307 | Better Jobs Coalition | Effectv | -56000.0 | 10/17/20 | 10/19/20 - 11/3/20 | Television | Supporting/Opposing | Rosier, Donald/Cutter, Lisa Ann | Republican | House District 25 |
308 | 308 | Better Jobs Coalition | Effectv | 36352.0 | 10/17/20 | 10/19/20 - 11/3/20 | Television | Supporting/Opposing | Rosier, Donald/Cutter, Lisa Ann | Republican | House District 25 |
311 | 311 | Better Jobs Coalition | Effectv | 36648.0 | 10/24/20 | 10/26/20 - 11/3/20 | Television | Supporting/Opposing | Van Winkle, Kevin/Mitkowski, Jennifer | Republican | House District 43 |
1089 | 1089 | Colorado Republican Committee Independent Expenditure Committee | Effectv | 27495.0 | 10/18/20 | 10/20/2020 - 10/26/2020 | Television | Supporting | Rankin, Bob | Republican | Senate District 08 |
1358 | 1358 | Gun Owners Of America | Effectv | 20009.15 | 5/28/20 | Supporting | Buck, Perry | Republican | Weld County Commission | ||
2170 | 2170 | Ready Colorado Action Fund | Effectv | 50000.0 | 10/6/20 | 10/7/20 - 10/22/20 | Television | Supporting | Rosier, Donald | Republican | House District 25 |
2358 | 2358 | Senate Majority Fund | Effectv | 10000.08 | 10/16/20 | 10/16/2020-11/3/2020 | Television | Supporting | Rankin, Bob | Republican | Senate District 08 |
2359 | 2359 | Senate Majority Fund | Effectv | -10000.08 | 10/16/20 | 10/16/2020-11/3/2020 | Television | Supporting | Rankin, Bob | Republican | Senate District 08 |
2360 | 2360 | Senate Majority Fund | Effectv | 100000.08 | 10/16/20 | 10/16/2020-11/3/2020 | Television | Supporting | Rankin, Bob | Republican | Senate District 08 |
2361 | 2361 | Senate Majority Fund | Effectv | 66000.0 | 10/22/20 | 10/23/2020-11/3/2020 | Television | Supporting | Rankin, Bob | Republican | Senate District 08 |
2426 | 2426 | Unite For Colorado Action | Effectv | 100000.0 | 9/24/20 | 9/25/20 - 8/8/20 | Television | Opposing | Dickerson, Paula Jane | Democratic | Senate District 25 |
2427 | 2427 | Unite For Colorado Action | Effectv | 100002.5 | 10/8/20 | 10/8/20- 10/16/20 | Television | Opposing | Dickerson, Paula Jane | Democratic | Senate District 25 |
2428 | 2428 | Unite For Colorado Action | Effectv | 150000.35 | 10/16/20 | 10/16/20 - 11/1/20 | Television | Opposing | Dickerson, Paula Jane | Democratic | Senate District 25 |
2429 | 2429 | Unite For Colorado Action | Effectv | 90000.0 | 10/22/20 | 10/22/20 - 11/3/20 | Television | Opposing | Dickerson, Paula Jane | Democratic | Senate District 25 |
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 );