super_pacs_exp
7 rows where expenditure_date = "11/3/21" and expenditure_type = "Advertising"
This data as json, CSV (advanced)
Suggested facets: committee, expenditure_amount, recipient, city, state, zip, explanation
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
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.Ì |
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 |
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 );