super_pacs_exp
1 row where explanation = "-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" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 );