state_iec
11 rows where date_spent = "10/2/20" and position = "Opposing"
This data as json, CSV (advanced)
Suggested facets: vendor, date_delivered, type, candidate, district
Link | rowid ▼ | committee | vendor | amount_spent | date_spent | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
1421 | 1421 | Leading Colorado Forward | 855.26 | 10/2/20 | 9/1/2020-9/2/2020 | Internet | Opposing | Gerber, Lynn T | Republican | Senate District 19 | |
1448 | 1448 | Leading Colorado Forward | Plumb Marketing | 3494.96 | 10/2/20 | 10/5/20 | Mailing | Opposing | Gerber, Lynn T | Republican | Senate District 19 |
1553 | 1553 | Leading Colorado Forward | AL Media | 352740.0 | 10/2/20 | 10/6/2020-10/19/2020 | Television | Opposing | Priola, Kevin | Republican | Senate District 25 |
1554 | 1554 | Leading Colorado Forward | AL Media | 41250.0 | 10/2/20 | 10/6/2020-10/19/2020 | Internet | Opposing | Priola, Kevin | Republican | Senate District 25 |
1582 | 1582 | Leading Colorado Forward | 857.79 | 10/2/20 | 10/1/2020-10/2/2020 | Internet | Opposing | Priola, Kevin | Republican | Senate District 25 | |
1659 | 1659 | Leading Colorado Forward | 809.46 | 10/2/20 | 10/1/2020-10/2/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1703 | 1703 | Leading Colorado Forward | 765.38 | 10/2/20 | 10/1/2020-10/2/2020 | Internet | Opposing | Roth, Robert C | Republican | Senate District 26 | |
1720 | 1720 | Leading Colorado Forward | AL Media | 370678.0 | 10/2/20 | 10/6/2020-10/19/2020 | Television | Opposing | Staiert, Suzanne | Republican | Senate District 27 |
1721 | 1721 | Leading Colorado Forward | AL Media | 44500.0 | 10/2/20 | 10/6/2020-10/19/2020 | Internet | Opposing | Staiert, Suzanne | Republican | Senate District 27 |
1741 | 1741 | Leading Colorado Forward | 673.92 | 10/2/20 | 10/1/2020-10/2/2020 | Internet | Opposing | Staiert, Suzanne | Republican | Senate District 27 | |
1786 | 1786 | Leading Colorado Forward | Plumb Marketing | 3392.84 | 10/2/20 | 10/5/20 | Mailing | 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 );