issue_comm_exp
2 rows where expenditure_date = "12/2/20" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
653 | 653 | Colorado Families First | Issue Committee | 350.0 | 12/2/20 | Everyaction Ngp | Washington | DC | 20005 | Office Equipment & Supplies | |
655 | 655 | Yes On National Popular Vote | Issue Committee | 500.0 | 12/2/20 | Ngp Van, Inc. | Washington | DC | 20005 | Office Equipment & Supplies | Database |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "issue_comm_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 );