super_pacs_exp
17 rows where expenditure_type = "Advertising" and state = "DC"
This data as json, CSV (advanced)
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
356 | 356 | Blueflower Action | Independent Expenditure Committee | 22300.0 | 3/22/21 | Dspolitical | Washington | DC | 20005 | Advertising | Digital |
993 | 993 | Parents For Great Schools | Independent Expenditure Committee | 19000.0 | 9/16/21 | Strother Nuckels | Washington | DC | 20002 | Advertising | Digital Advertising In Support Of Gene Fashaw For Denver Board Of Education |
994 | 994 | Parents For Great Schools | Independent Expenditure Committee | 19000.0 | 9/16/21 | Strother Nuckels | Washington | DC | 20002 | Advertising | Digital Advertising In Support Of Karolina Villagrana For Denver Board Of Education |
1078 | 1078 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 652.73 | 10/7/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1106 | 1106 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 126.83 | 10/13/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1121 | 1121 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 102.77 | 10/15/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1124 | 1124 | Parents For Great Schools | Independent Expenditure Committee | 40000.0 | 10/16/21 | Strother Nuckels | Washington | DC | 20002 | Advertising | In Support Of Vernon Jones Jr. And Karolina Villagrana For Denver Board Of Education |
1137 | 1137 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 625.59 | 10/20/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1148 | 1148 | Protect Our Public Schools | Independent Expenditure Committee | 30000.0 | 10/22/21 | Complete Digital Llc | Washingnton | DC | 20003 | Advertising | -Oppose Schume Navarro: Qanon Conspiracy Theorist And Insurrectionist Produce And Distribute Advertising That: -Oppose Jen Gibbons: Enthusiastically Endorsed By The Fec United Militia -Oppose Jason Lester: Connected To Qanon Conspiracy Believer An |
1156 | 1156 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 155.83 | 10/25/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1172 | 1172 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 100.1 | 10/27/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1183 | 1183 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 509.47 | 10/29/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1184 | 1184 | Parents For Great Schools | Independent Expenditure Committee | 40000.0 | 10/29/21 | Strother Nuckels | Washington | DC | 20002 | Advertising | Digital Advertising In Support Of Gene Fashaw And Karolina Villagrana For Denver Board Of Education |
1189 | 1189 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 367.11 | 10/30/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1197 | 1197 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 1108.62 | 11/1/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Mesaging |
1206 | 1206 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 541.27 | 11/2/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1211 | 1211 | Protect Our Public Schools | Independent Expenditure Committee | 5000.0 | 11/3/21 | Complete Digital Llc | Washington | DC | 80218 | Advertising | Supporting Or Opposing Candidates For Elected Office Based On The Candidatesí Public Education Policies.Ì |
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 );