state_iec
5 rows where vendor = "Constellation Political"
This data as json, CSV (advanced)
Suggested facets: amount_spent, date_spent, date_delivered, type
Link | rowid ▼ | committee | vendor | amount_spent | date_spent | date_delivered | type | position | candidate | affiliation | district |
---|---|---|---|---|---|---|---|---|---|---|---|
366 | 366 | Citizens For Intelligence Driven Prosecution | Constellation Political | 8505.0 | 6/5/20 | 6/16/2020 - 6/30/2020 | Television | Supporting/Opposing | Allen, Michael J/Waller, Donald Mark | Republican | El Paso District Attorney |
367 | 367 | Citizens For Intelligence Driven Prosecution | Constellation Political | 8505.0 | 6/5/20 | 6/16/2020 - 6/30/2020 | Television | Supporting/Opposing | Allen, Michael J/Waller, Donald Mark | Republican | El Paso District Attorney |
368 | 368 | Citizens For Intelligence Driven Prosecution | Constellation Political | 1500.0 | 6/23/20 | 6/24/20 - 6/30/20 | Television | Supporting/Opposing | Allen, Michael J/Waller, Donald Mark | Republican | El Paso District Attorney |
369 | 369 | Citizens For Intelligence Driven Prosecution | Constellation Political | 800.0 | 6/25/20 | 6/25/20 - 6/30/20 | Internet | Supporting/Opposing | Allen, Michael J/Waller, Donald Mark | Republican | El Paso District Attorney |
370 | 370 | Citizens For Intelligence Driven Prosecution | Constellation Political | -8505.0 | 6/5/20 | 6/16/2020 - 6/30/2020 | Television | Supporting/Opposing | Allen, Michael J/Waller, Donald Mark | Republican | El Paso District Attorney |
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 );