super_pacs_exp
7 rows where expenditure_type = "Advertising" and zip = 20152
This data as json, CSV (advanced)
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
1122 | 1122 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 4079.28 | 10/16/21 | Conspectus Network | Chantilly | VA | 20152 | Advertising | Phone Calls |
1136 | 1136 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 11302.73 | 10/20/21 | Conspectus Network | Chantilly | VA | 20152 | Advertising | Phone Calls |
1164 | 1164 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 28056.96 | 10/26/21 | Conspectus Network | Chantilly | VA | 20152 | Advertising | Phone Calls |
1173 | 1173 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 7440.36 | 10/27/21 | Conspectus Network | Chantilly | VA | 20152 | Advertising | Phone Calls |
1180 | 1180 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 927.66 | 10/28/21 | Conspectus Network | Chantilly | VA | 20152 | Advertising | Phone Calls |
1199 | 1199 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 1958.46 | 11/1/21 | Conspectus Network | Chantilly | VA | 20152 | Advertising | Phone Calls |
1207 | 1207 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 1506.15 | 11/2/21 | Conspectus Network | Chantilly | VA | 20152 | Advertising | Phone Calls |
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 );