state_iec

65 rows where district contains "Senate District 08" and position = "Opposing"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committee, vendor, type, candidate, affiliation

Link rowid ▼ committee vendor amount_spent date_spent date_delivered type position candidate affiliation district
1249 1249 Conservation Colorado Victory Fund Facebook 1790.8 10/28/20 10/28/20 Internet Opposing Rankin, Bob Republican Senate District 08
1250 1250 Conservation Colorado Victory Fund Facebook 2207.54 11/1/20 11/1-11/3 Internet Opposing Rankin, Bob Republican Senate District 08
1251 1251 Conservation Colorado Victory Fund Facebook 1001.3 11/3/20 11/3/20 Internet Opposing Rankin, Bob Republican Senate District 08
1252 1252 Conservation Colorado Victory Fund Moxie Media 13842.21 9/18/20 9/18/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1253 1253 Conservation Colorado Victory Fund Moxie Media 13842.21 9/20/20 9/14/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1254 1254 Conservation Colorado Victory Fund Moxie Media 13842.21 9/22/20 9/22/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1641 1641 Leading Colorado Forward AL Media 238820.0 10/13/20 10/14/2020-11/3/2020 Television Opposing Rankin, Bob Republican Senate District 08
1642 1642 Leading Colorado Forward AL Media 74663.0 10/13/20 10/14/2020-11/3/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1643 1643 Leading Colorado Forward AL Media 35000.0 10/19/20 10/20/2020-11/3/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1644 1644 Leading Colorado Forward AL Media 40000.0 10/23/20 10/23/2020-11/3/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1645 1645 Leading Colorado Forward AL Media 20000.0 10/26/20 10/27/2020-11/3/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1646 1646 Leading Colorado Forward AL Media 65000.0 10/26/20 10/27/2020-11/3/2020 Television Opposing Rankin, Bob Republican Senate District 08
1647 1647 Leading Colorado Forward Ascend Digital Strategies 4000.0 9/22/20 9/22/2020-9/28/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1648 1648 Leading Colorado Forward Ascend Digital Strategies 3000.0 9/30/20 9/29/2020-10/5/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1649 1649 Leading Colorado Forward Ascend Digital Strategies 5000.0 10/6/20 10/6/2020-10/12/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1650 1650 Leading Colorado Forward Ascend Digital Strategies 3250.0 10/13/20 10/13/2020-10/19/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1651 1651 Leading Colorado Forward Ascend Digital Strategies 750.0 10/13/20 10/13/2020-10/19/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1652 1652 Leading Colorado Forward Ascend Digital Strategies 5750.0 10/21/20 10/20/2020-10/26/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1653 1653 Leading Colorado Forward Ascend Digital Strategies 9000.0 10/26/20 10/27/2020-11/3/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1654 1654 Leading Colorado Forward Chism Strategies 1526.6 10/24/20 10/24/20 Other Opposing Rankin, Bob Republican Senate District 08
1655 1655 Leading Colorado Forward Chism Strategies 1933.6 10/24/20 10/26/20 Other Opposing Rankin, Bob Republican Senate District 08
1656 1656 Leading Colorado Forward Chism Strategies 1106.1 10/24/20 10/27/20 Other Opposing Rankin, Bob Republican Senate District 08
1657 1657 Leading Colorado Forward Facebook 1800.0 9/22/20 9/22/2020-9/28/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1658 1658 Leading Colorado Forward Facebook 1000.0 9/30/20 9/29/2020-10/5/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1659 1659 Leading Colorado Forward Facebook 809.46 10/2/20 10/1/2020-10/2/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1660 1660 Leading Colorado Forward Facebook 1274.27 10/5/20 10/4/2020-10/6/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1661 1661 Leading Colorado Forward Facebook 423.6 10/6/20 10/5/2020-10/6/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1662 1662 Leading Colorado Forward Facebook 427.88 10/7/20 10/6/2020-10/7/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1663 1663 Leading Colorado Forward Facebook 435.14 10/8/20 10/7/2020-10/8/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1664 1664 Leading Colorado Forward Facebook 490.28 10/9/20 10/8/2020-10/9/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1665 1665 Leading Colorado Forward Facebook 1117.41 10/13/20 10/11/2020-10/13/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1666 1666 Leading Colorado Forward Facebook 568.13 10/14/20 10/14/2020-10/15/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1667 1667 Leading Colorado Forward Facebook 68.45 10/15/20 10/14/2020-10/15/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1668 1668 Leading Colorado Forward Facebook 272.19 10/16/20 10/15/2020-10/16/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1669 1669 Leading Colorado Forward Facebook 968.04 10/19/20 10/19/2020-10/20/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1670 1670 Leading Colorado Forward Facebook 456.82 10/21/20 10/20/2020-10/21/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1671 1671 Leading Colorado Forward Facebook 167.43 10/21/20 10/19/2020-10/20/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1672 1672 Leading Colorado Forward Facebook 411.9 10/22/20 10/21/2020-10/22/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1673 1673 Leading Colorado Forward Facebook 645.76 10/23/20 10/22/2020-10/23/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1674 1674 Leading Colorado Forward Facebook 1661.82 10/26/20 10/26/2020-10/27/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1675 1675 Leading Colorado Forward Facebook 446.58 10/27/20 10/26/2020-10/27/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1676 1676 Leading Colorado Forward Facebook 517.27 10/28/20 10/27/2020-10/28/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1677 1677 Leading Colorado Forward Facebook 449.79 10/29/20 10/28/2020-10/29/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1678 1678 Leading Colorado Forward Facebook 380.64 10/30/20 10/29/2020-10/30/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1679 1679 Leading Colorado Forward Facebook 1147.4 11/2/20 11/1/2020-11/2/2020 Internet Opposing Rankin, Bob Republican Senate District 08
1680 1680 Leading Colorado Forward Facebook 776.75 11/3/20 11/3/20 Internet Opposing Rankin, Bob Republican Senate District 08
1681 1681 Leading Colorado Forward Moxie Media 9404.0 9/9/20 9/10/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1682 1682 Leading Colorado Forward Moxie Media 9404.0 9/9/20 9/14/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1683 1683 Leading Colorado Forward Moxie Media 8961.0 9/23/20 9/24/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1684 1684 Leading Colorado Forward Moxie Media 8961.0 9/23/20 9/28/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1685 1685 Leading Colorado Forward Moxie Media 7965.0 10/6/20 10/9/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1686 1686 Leading Colorado Forward Moxie Media 7965.0 10/9/20 10/13/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1687 1687 Leading Colorado Forward Moxie Media 7965.0 10/14/20 10/15/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1688 1688 Leading Colorado Forward Moxie Media 8961.0 10/22/20 10/23/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1689 1689 Leading Colorado Forward Moxie Media 8961.0 10/22/20 10/26/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1690 1690 Leading Colorado Forward Plumb Marketing 6220.17 9/8/20 9/10/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1691 1691 Leading Colorado Forward Plumb Marketing 6220.17 9/9/20 9/14/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1692 1692 Leading Colorado Forward Plumb Marketing 6220.17 9/22/20 9/24/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1693 1693 Leading Colorado Forward Plumb Marketing 6219.61 9/25/20 9/28/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1694 1694 Leading Colorado Forward Plumb Marketing 5484.28 10/8/20 10/9/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1695 1695 Leading Colorado Forward Plumb Marketing 5263.82 10/13/20 10/13/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1696 1696 Leading Colorado Forward Plumb Marketing 5263.02 10/14/20 10/15/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1697 1697 Leading Colorado Forward Plumb Marketing 6209.07 10/22/20 10/23/20 Mailing Opposing Rankin, Bob Republican Senate District 08
1698 1698 Leading Colorado Forward Plumb Marketing 6219.07 10/23/20 10/26/20 Mailing Opposing Rankin, Bob Republican Senate District 08
2441 2441 Unite For Colorado Action Majority Strategies 34337.99 10/8/20 10/12/20 - 10/23/20 Mailing Opposing Hanlon, Karl Democratic Senate District 08

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);