super_pacs_exp
28 rows where expenditure_type = "Advertising" and state = "CO"
This data as json, CSV (advanced)
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
1174 | 1174 | Forward Progress | Independent Expenditure Committee | 9000.0 | 10/27/21 | Effct | Denver | CO | 80202 | Advertising | Digital Advertising Opposing Scott Esserman For Denver Board Of Education |
1175 | 1175 | Forward Progress | Independent Expenditure Committee | 4500.0 | 10/27/21 | Effct | Denver | CO | 80202 | Advertising | Digital Advertising In Support Of Karolina Villagrana For Denver Board Of Education |
1176 | 1176 | Forward Progress | Independent Expenditure Committee | 4500.0 | 10/27/21 | Effct | Denver | CO | 80202 | Advertising | Digital Advertising Opposing Xochitl Gaytan And Supporting Karolina Villagrana For Denver Board Of Education |
1198 | 1198 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 2000.0 | 11/1/21 | Effct | Denver | CO | 80202 | Advertising | Digital Ads |
1208 | 1208 | Parents For Great Schools | Independent Expenditure Committee | 4612.5 | 11/2/21 | Bdo | Lakewood | CO | 80228 | Advertising | Paid Canvassing In Support Of Gene Fashaw For Denver Board Of Education |
1209 | 1209 | Parents For Great Schools | Independent Expenditure Committee | 13837.5 | 11/2/21 | Bdo | Lakewood | CO | 80228 | Advertising | Paid Canvassing In Support Of Vernon Jones Jr. For Denver Board Of Education |
1212 | 1212 | Students Deserve Better | Independent Expenditure Committee | 15000.0 | 11/3/21 | Progressive Promotions, Inc. | Denver | CO | 80203 | Advertising | Digital Advertising |
1213 | 1213 | Students Deserve Better | Independent Expenditure Committee | 5000.0 | 11/3/21 | Progressive Promotions, Inc. | Denver | CO | 80203 | Advertising | Digital Advertising |
1214 | 1214 | Students Deserve Better | Independent Expenditure Committee | 15000.0 | 11/3/21 | Progressive Promotions, Inc. | Denver | CO | 80203 | Advertising | Digital Advertising |
1215 | 1215 | Students Deserve Better | Independent Expenditure Committee | 16250.0 | 11/3/21 | Progressive Promotions, Inc. | Denver | CO | 80203 | Advertising | Digital Advertising |
1216 | 1216 | Students Deserve Better | Independent Expenditure Committee | 21250.0 | 11/3/21 | Progressive Promotions, Inc. | Denver | CO | 80203 | Advertising | Digital Advertising |
1217 | 1217 | Students Deserve Better | Independent Expenditure Committee | 10000.0 | 11/3/21 | Progressive Promotions, Inc. | Denver | CO | 80203 | Advertising | Digital Advertising |
1218 | 1218 | Weld County Freedom Fighters | Independent Expenditure Committee | 1396.15 | 11/5/21 | Mail N' Copy | Windsor | CO | 80550 | Advertising | Signs And Banners To Oppose 4A And 4B School Bond |
1219 | 1219 | Weld County Freedom Fighters | Independent Expenditure Committee | 2903.85 | 11/5/21 | Connecting Signs | Fort Collins | CO | 80525 | Advertising | Yard Signs To Oppose 4A & 4B School Bond |
1220 | 1220 | Weld County Freedom Fighters | Independent Expenditure Committee | 163.85 | 11/8/21 | Mail N' Copy | Windsor | CO | 80550 | Advertising | Signs And Banners To Oppose 4A & 4B School Bond |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "super_pacs_exp" ( "committee" TEXT, "committee_type" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );