super_pacs_exp
1 row where expenditure_type = "Contributions" and state = "DC" sorted by city
This data as json, CSV (advanced)
Link | rowid | committee | committee_type | expenditure_amount | expenditure_date | recipient | city ▼ | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
1354 | 1354 | Cry Freedom For An Ethical Garfield County | Independent Expenditure Committee | 303.58 | 12/16/20 | Cry Freedom Pac | Washington | DC | 20003-4303 | Contributions |
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 );