state_iec
5 rows where date_spent = "10/20/20", district contains "Senate District 08" and type = "Internet"
This data as json, CSV (advanced)
Suggested facets: committee, vendor, date_delivered, position, candidate, affiliation
Link | rowid ▼ | committee | vendor | amount_spent | date_spent | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
520 | 520 | Coloradans Creating Opportunities | Blueprint Interactive | 12676.0 | 10/20/20 | 10/19/2020-11/3/2020 | Internet | Supporting | Hanlon, Karl | Democratic | Senate District 08 |
1340 | 1340 | Family Policy Alliance Independent Expenditure Committee | Awareness Analytics Partners, Llc | 1500.0 | 10/20/20 | 10/20/20 | Internet | Supporting/Opposing | Rankin, Bob/Hanlon, Karl | Republican | Senate District 08 |
2366 | 2366 | Senate Majority Fund | Majority Strategies | 6500.0 | 10/20/20 | 10/20/2020-11/3/2020 | Internet | Supporting | Rankin, Bob | Republican | Senate District 08 |
2367 | 2367 | Senate Majority Fund | Majority Strategies | -6500.0 | 10/20/20 | 10/20/2020-11/3/2020 | Internet | Supporting | Rankin, Bob | Republican | Senate District 08 |
2368 | 2368 | Senate Majority Fund | Majority Strategies | 65000.0 | 10/20/20 | 10/20/2020-11/3/2020 | Internet | Supporting | 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 );