super_pacs_exp

22 rows where state = "PA"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ committee committee_type expenditure_amount expenditure_date recipient city state zip expenditure_type explanation
7 7 Better Leaders, Stronger Schools Independent Expenditure Committee 79200.0 10/16/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mail
8 8 Better Leaders, Stronger Schools Independent Expenditure Committee 79200.0 10/17/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
11 11 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 67285.0 10/16/23 40 North Advocacy Llc Fort Washington PA 19034 Consultant & Professional Services Direct Mail Services
12 12 Better Leaders, Stronger Schools Independent Expenditure Committee 64800.0 10/19/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
13 13 Better Leaders, Stronger Schools Independent Expenditure Committee 64800.0 10/30/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
29 29 Clcs (Colorado League Of Charter Schools) Action Iec (Independent Expenditure Committee) Independent Expenditure Committee 36500.0 10/19/23 40 North Advocacy Llc Fort Washington PA 19034 Consultant & Professional Services Digital Advertising Services
66 66 Better Leaders, Stronger Schools Independent Expenditure Committee 21600.0 10/16/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mail
67 67 Better Leaders, Stronger Schools Independent Expenditure Committee 21600.0 10/17/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
68 68 Better Leaders, Stronger Schools Independent Expenditure Committee 21600.0 10/18/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
69 69 Better Leaders, Stronger Schools Independent Expenditure Committee 21600.0 10/25/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
70 70 Better Leaders, Stronger Schools Independent Expenditure Committee 21600.0 10/28/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
71 71 Better Leaders, Stronger Schools Independent Expenditure Committee 21600.0 10/31/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
83 83 Better Leaders, Stronger Schools Independent Expenditure Committee 18600.0 11/1/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
85 85 Better Leaders, Stronger Schools Independent Expenditure Committee 18000.0 10/16/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mail
86 86 Better Leaders, Stronger Schools Independent Expenditure Committee 18000.0 10/17/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
87 87 Better Leaders, Stronger Schools Independent Expenditure Committee 18000.0 10/19/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
88 88 Better Leaders, Stronger Schools Independent Expenditure Committee 18000.0 10/25/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
89 89 Better Leaders, Stronger Schools Independent Expenditure Committee 18000.0 10/30/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
90 90 Better Leaders, Stronger Schools Independent Expenditure Committee 18000.0 11/1/23 Ampersand Strategies Philadelphia PA 19107 Advertising Mailing
100 100 Better Schools For A Stronger Colorado Iec (Bssc Iec) Independent Expenditure Committee 17000.0 10/9/23 Powers Interactive Digital Llc Lower Gwynedd PA 19002 Advertising Media Buy For Digital Ads In Support Of Stu Boyd, Dawn Kirk, Denise Chapman, Briah Freeman, Seth Bryant, Keegan Barkley, Mike Knott, Dr. Brenda Campos-Spitze, Natalie Mash, Lori Goldstein, Paula Battistelli, Alexis Marsh Holschen, Kate Singh, Shay Da
113 113 Better Leaders, Stronger Schools Independent Expenditure Committee 14320.0 11/7/23 Ampersand Strategies Philadelphia PA 19107 Other Production
481 481 Better Leaders, Stronger Schools Independent Expenditure Committee 750.0 11/7/23 Ampersand Strategies Philadelphia PA 19107 Consultant & Professional Services Design

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