trad_pacs_exp
4 rows where expenditure_amount = "12.32" and expenditure_type = "Telephone"
This data as json, CSV (advanced)
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
203 | 203 | Libertarian Party Of Colorado (Lpco) | Political Party Committee | 12.32 | 1/23/19 0:00 | Line2 | San Francisco | CA | 94111 | Telephone | |
497 | 497 | Libertarian Party Of Colorado (Lpco) | Political Party Committee | 12.32 | 2/25/19 0:00 | Line2 | San Francisco | CA | 94111 | Telephone | |
779 | 779 | Libertarian Party Of Colorado (Lpco) | Political Party Committee | 12.32 | 3/25/19 0:00 | Line2 | San Francisco | CA | 94111 | Telephone | |
3358 | 3358 | Libertarian Party Of Colorado (Lpco) | Political Party Committee | 12.32 | 12/24/18 0:00 | Line2 | San Francisco | CA | 94111 | Telephone |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "trad_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 );