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 |
---|---|---|---|---|---|---|---|---|---|---|---|
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 );