state_iec
31 rows where candidate = "Rankin, Bob", district contains "Senate District 08" and vendor = "Facebook"
This data as json, CSV (advanced)
Suggested facets: committee, amount_spent, date_spent, date_delivered, type, position
Link | rowid ▼ | committee | vendor | amount_spent | date_spent | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
1144 | 1144 | Colorado Values Project | 1250.0 | 6/11/20 | 6/11/2020-6/17/2020 | Digital | Associated | Rankin, Bob | Republican | Senate District 08 | |
1147 | 1147 | Colorado Values Project | 1250.0 | 6/19/20 | 6/19/2020-6/25/2020 | Digital | Associated | Rankin, Bob | Republican | Senate District 08 | |
1153 | 1153 | Colorado Values Project | 507.37 | 6/30/20 | 6/25/2020-6/30/2020 | Digital | Associated | Rankin, Bob | Republican | Senate District 08 | |
1157 | 1157 | Colorado Values Project | 2000.0 | 8/7/20 | 8/7/2020-8/14/2020 | Digital | Associated | Rankin, Bob | Republican | Senate District 08 | |
1249 | 1249 | Conservation Colorado Victory Fund | 1790.8 | 10/28/20 | 10/28/20 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1250 | 1250 | Conservation Colorado Victory Fund | 2207.54 | 11/1/20 | 11/1-11/3 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1251 | 1251 | Conservation Colorado Victory Fund | 1001.3 | 11/3/20 | 11/3/20 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1657 | 1657 | Leading Colorado Forward | 1800.0 | 9/22/20 | 9/22/2020-9/28/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1658 | 1658 | Leading Colorado Forward | 1000.0 | 9/30/20 | 9/29/2020-10/5/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1659 | 1659 | Leading Colorado Forward | 809.46 | 10/2/20 | 10/1/2020-10/2/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1660 | 1660 | Leading Colorado Forward | 1274.27 | 10/5/20 | 10/4/2020-10/6/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1661 | 1661 | Leading Colorado Forward | 423.6 | 10/6/20 | 10/5/2020-10/6/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1662 | 1662 | Leading Colorado Forward | 427.88 | 10/7/20 | 10/6/2020-10/7/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1663 | 1663 | Leading Colorado Forward | 435.14 | 10/8/20 | 10/7/2020-10/8/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1664 | 1664 | Leading Colorado Forward | 490.28 | 10/9/20 | 10/8/2020-10/9/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1665 | 1665 | Leading Colorado Forward | 1117.41 | 10/13/20 | 10/11/2020-10/13/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1666 | 1666 | Leading Colorado Forward | 568.13 | 10/14/20 | 10/14/2020-10/15/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1667 | 1667 | Leading Colorado Forward | 68.45 | 10/15/20 | 10/14/2020-10/15/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1668 | 1668 | Leading Colorado Forward | 272.19 | 10/16/20 | 10/15/2020-10/16/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1669 | 1669 | Leading Colorado Forward | 968.04 | 10/19/20 | 10/19/2020-10/20/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1670 | 1670 | Leading Colorado Forward | 456.82 | 10/21/20 | 10/20/2020-10/21/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1671 | 1671 | Leading Colorado Forward | 167.43 | 10/21/20 | 10/19/2020-10/20/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1672 | 1672 | Leading Colorado Forward | 411.9 | 10/22/20 | 10/21/2020-10/22/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1673 | 1673 | Leading Colorado Forward | 645.76 | 10/23/20 | 10/22/2020-10/23/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1674 | 1674 | Leading Colorado Forward | 1661.82 | 10/26/20 | 10/26/2020-10/27/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1675 | 1675 | Leading Colorado Forward | 446.58 | 10/27/20 | 10/26/2020-10/27/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1676 | 1676 | Leading Colorado Forward | 517.27 | 10/28/20 | 10/27/2020-10/28/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1677 | 1677 | Leading Colorado Forward | 449.79 | 10/29/20 | 10/28/2020-10/29/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1678 | 1678 | Leading Colorado Forward | 380.64 | 10/30/20 | 10/29/2020-10/30/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1679 | 1679 | Leading Colorado Forward | 1147.4 | 11/2/20 | 11/1/2020-11/2/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1680 | 1680 | Leading Colorado Forward | 776.75 | 11/3/20 | 11/3/20 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 |
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 );