super_pacs_exp

33 rows where state = "PA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committee, expenditure_date, recipient, city, zip, expenditure_type, explanation

Link rowid ▼ committee committee_type expenditure_amount expenditure_date recipient city state zip expenditure_type explanation
1009 1009 Denver Students, Families And Teachers United For Excellent Schools Independent Expenditure Committee 61354.32 9/23/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Direct Mail
1035 1035 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 8119.12 9/29/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Postcard Mailer Production, Printing, And Postage
1048 1048 Raising Colorado Independent Expenditure Committee 57853.25 9/30/21 40 North Advocacy Philadelphia PA 19127 Consultant & Professional Services Direct Mail
1049 1049 Raising Colorado Independent Expenditure Committee 12784.85 9/30/21 40 North Advocacy Philadelphia PA 19127 Consultant & Professional Services Direct Mail
1062 1062 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 20741.23 10/4/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Mailer Production, Printing, And Postage
1067 1067 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 15247.1 10/6/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Direct Mail Production, Printing And Postage
1069 1069 Denver Students, Families And Teachers United For Excellent Schools Independent Expenditure Committee 12371.04 10/6/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Direct Mail
1077 1077 Denver Students, Families And Teachers United For Excellent Schools Independent Expenditure Committee 11280.75 10/7/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Direct Mail
1079 1079 Parents For Great Schools Independent Expenditure Committee 14606.5 10/7/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Printing Of Mail In Support Of Gene Fashaw For Denver Board Of Education
1080 1080 Raising Colorado Independent Expenditure Committee 15054.85 10/7/21 40 North Advocacy Philadelphia PA 19127 Consultant & Professional Services Direct Mail
1081 1081 Raising Colorado Independent Expenditure Committee 14970.01 10/7/21 40 North Advocacy Philadelphia PA 19127 Consultant & Professional Services Direct Mail
1085 1085 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 45431.52 10/8/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Direct Mail Production, Printing And Postage
1089 1089 Parents For Great Schools Independent Expenditure Committee 54932.66 10/8/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Printing Of Mail In Support Of Vernon Jones Jr. For Denver Board Of Education
1090 1090 Parents For Great Schools Independent Expenditure Committee 9018.8 10/8/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Printing Of Mail In Support Of Karolina Villagrana For Denver Board Of Education
1091 1091 Parents For Great Schools Independent Expenditure Committee 18037.59 10/8/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Printing Of Mail In Support Of Gene Fashaw For Denver Board Of Education
1108 1108 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 100979.17 10/14/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Mailing Production, Printing, And Postage
1109 1109 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 3425.23 10/14/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Mailings Production, Printing And Postage
1114 1114 Raising Colorado Independent Expenditure Committee 10715.34 10/14/21 40 North Advocacy Philadelphia PA 19127 Consultant & Professional Services Direct Mail
1115 1115 Raising Colorado Independent Expenditure Committee 11258.5 10/14/21 40 North Advocacy Philadelphia PA 19127 Consultant & Professional Services Direct Mail
1116 1116 Raising Colorado Independent Expenditure Committee 10715.34 10/14/21 40 North Advocacy Philadelphia PA 19127 Consultant & Professional Services Direct Mail
1117 1117 Raising Colorado Independent Expenditure Committee 51002.77 10/14/21 40 North Advocacy Philadelphia PA 19127 Consultant & Professional Services Direct Mail
1119 1119 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 2500.0 10/15/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Internet Advertising - Online Ad Design
1129 1129 Denver Students, Families And Teachers United For Excellent Schools Independent Expenditure Committee 12013.24 10/18/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Direct Mail
1132 1132 Denver Students, Families And Teachers United For Excellent Schools Independent Expenditure Committee 10829.52 10/19/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Direct Mail
1134 1134 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 13424.64 10/20/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Internet Advertising Design And Promotion
1139 1139 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 49150.17 10/21/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Mailers Production, Printing, And Postage
1140 1140 Parents For Great Schools Independent Expenditure Committee 53788.21 10/21/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Mail Piece In Support Of Vernon Jones Jr. For Denver Board Of Education
1141 1141 Parents For Great Schools Independent Expenditure Committee 16659.28 10/21/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Mail Pieces In Support Of Gene Fashaw For Denver Board Of Education
1142 1142 Parents For Great Schools Independent Expenditure Committee 17685.67 10/21/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Mail Pieces In Support Of Gene Fashaw For Denver Board Of Education
1145 1145 Raising Colorado Independent Expenditure Committee 14204.23 10/21/21 40 North Advocacy Philadelphia PA 19127 Consultant & Professional Services Direct Mail
1151 1151 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 14304.23 10/25/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Mailer Production, Printing And Postage
1153 1153 Denver Students, Families And Teachers United For Excellent Schools Independent Expenditure Committee 62428.7 10/25/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Direct Mail
1179 1179 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 8542.29 10/28/21 40 North Advocacy, Llc Oreland PA 19075 Advertising Graphic Design, Video Production, And Digital Advertising

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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