state_iec
5 rows where date_spent = "10/5/20" and position = "Opposing"
This data as json, CSV (advanced)
Link | rowid ▼ | committee | vendor | amount_spent | date_spent | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
1422 | 1422 | Leading Colorado Forward | 1220.38 | 10/5/20 | 10/4/2020-10/6/2020 | Internet | Opposing | Gerber, Lynn T | Republican | Senate District 19 | |
1583 | 1583 | Leading Colorado Forward | 1249.08 | 10/5/20 | 10/4/2020-10/6/2020 | Internet | Opposing | Priola, Kevin | Republican | Senate District 25 | |
1660 | 1660 | Leading Colorado Forward | 1274.27 | 10/5/20 | 10/4/2020-10/6/2020 | Internet | Opposing | Rankin, Bob | Republican | Senate District 08 | |
1704 | 1704 | Leading Colorado Forward | 1284.15 | 10/5/20 | 10/4/2020-10/6/2020 | Internet | Opposing | Roth, Robert C | Republican | Senate District 26 | |
1742 | 1742 | Leading Colorado Forward | 864.31 | 10/5/20 | 10/4/2020-10/6/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 );