state_iec
9 rows where date_delivered = "9/8/2020-9/14/2020" and position = "Opposing"
This data as json, CSV (advanced)
Suggested facets: vendor, amount_spent, date_spent, candidate, district
Link | rowid ▼ | committee | vendor | amount_spent | date_spent | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
1563 | 1563 | Leading Colorado Forward | Ascend Digital Strategies | 4808.33 | 9/8/20 | 9/8/2020-9/14/2020 | Internet | Opposing | Priola, Kevin | Republican | Senate District 25 |
1573 | 1573 | Leading Colorado Forward | 250.0 | 9/4/20 | 9/8/2020-9/14/2020 | Internet | Opposing | Priola, Kevin | Republican | Senate District 25 | |
1574 | 1574 | Leading Colorado Forward | 3200.0 | 9/8/20 | 9/8/2020-9/14/2020 | Internet | Opposing | Priola, Kevin | Republican | Senate District 25 | |
1575 | 1575 | Leading Colorado Forward | 600.0 | 9/9/20 | 9/8/2020-9/14/2020 | Internet | Opposing | Priola, Kevin | Republican | Senate District 25 | |
1576 | 1576 | Leading Colorado Forward | 900.0 | 9/11/20 | 9/8/2020-9/14/2020 | Internet | Opposing | Priola, Kevin | Republican | Senate District 25 | |
1728 | 1728 | Leading Colorado Forward | Ascend Digital Strategies | 4750.0 | 9/8/20 | 9/8/2020-9/14/2020 | Internet | Opposing | Staiert, Suzanne | Republican | Senate District 27 |
1736 | 1736 | Leading Colorado Forward | 2500.0 | 9/8/20 | 9/8/2020-9/14/2020 | Internet | Opposing | Staiert, Suzanne | Republican | Senate District 27 | |
1737 | 1737 | Leading Colorado Forward | 600.0 | 9/9/20 | 9/8/2020-9/14/2020 | Internet | Opposing | Staiert, Suzanne | Republican | Senate District 27 | |
1738 | 1738 | Leading Colorado Forward | 900.0 | 9/11/20 | 9/8/2020-9/14/2020 | Internet | Opposing | Staiert, Suzanne | Republican | Senate 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 );