state_iec
9 rows where candidate = "Rankin, Bob", district contains "Senate District 08" and vendor = "Plumb Marketing"
This data as json, CSV (advanced)
Suggested facets: amount_spent
Link | rowid ▼ | committee | vendor | amount_spent | date_spent | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 );