super_pacs_exp
9 rows where explanation = "Text Messaging" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
1078 | 1078 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 652.73 | 10/7/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1106 | 1106 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 126.83 | 10/13/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1121 | 1121 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 102.77 | 10/15/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1137 | 1137 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 625.59 | 10/20/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1156 | 1156 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 155.83 | 10/25/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1172 | 1172 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 100.1 | 10/27/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1183 | 1183 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 509.47 | 10/29/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1189 | 1189 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 367.11 | 10/30/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
1206 | 1206 | Denver Students, Families And Teachers United For Excellent Schools | Independent Expenditure Committee | 541.27 | 11/2/21 | 50Can Action Fund Inc. | Washington | DC | 20010 | Advertising | Text Messaging |
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 );