state_iec
5 rows where affiliation = "Republican" and amount_spent = "7072.0"
This data as json, CSV (advanced)
Link | rowid ▼ | committee | vendor | amount_spent | date_spent | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
1607 | 1607 | Leading Colorado Forward | Moxie Media | 7072.0 | 9/1/20 | 9/8/20 | Mailing | Opposing | Priola, Kevin | Republican | Senate District 25 |
1609 | 1609 | Leading Colorado Forward | Moxie Media | 7072.0 | 9/15/20 | 9/15/20 | Mailing | Opposing | Priola, Kevin | Republican | Senate District 25 |
1613 | 1613 | Leading Colorado Forward | Moxie Media | 7072.0 | 9/23/20 | 9/28/20 | Mailing | Opposing | Priola, Kevin | Republican | Senate District 25 |
1614 | 1614 | Leading Colorado Forward | Moxie Media | 7072.0 | 9/28/20 | 9/30/20 | Mailing | Opposing | Priola, Kevin | Republican | Senate District 25 |
1617 | 1617 | Leading Colorado Forward | Moxie Media | 7072.0 | 10/14/20 | 10/15/20 | Mailing | Opposing | Priola, Kevin | Republican | Senate District 25 |
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 );