house_cand_exp
5 rows where expenditure_type = "Telephone" and recipient = "Phone Burner"
This data as json, CSV (advanced)
Suggested facets: district, candidate, expenditure_amount, city, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
6977 | 6977 | House District 28 | Tipper, Kerry | Democratic | 149.0 | 7/8/20 0:00 | Phone Burner | Ladera Ranch | CA | 92694 | Telephone | Dialing Service |
14132 | 14132 | House District 59 | Mclachlan, Barbara | Democratic | 150.0 | 8/8/20 0:00 | Phone Burner | Laguna Beach | CA | 92651 | Telephone | |
14149 | 14149 | House District 59 | Mclachlan, Barbara | Democratic | 149.0 | 9/7/20 0:00 | Phone Burner | Laguna Beach | CA | 92651 | Telephone | |
14201 | 14201 | House District 59 | Mclachlan, Barbara | Democratic | 149.0 | 10/8/20 0:00 | Phone Burner | Laguna Beach | CA | 92651 | Telephone | |
14223 | 14223 | House District 59 | Mclachlan, Barbara | Democratic | 54.63 | 10/27/20 0:00 | Phone Burner | Laguna Beach | CA | 92651 | Telephone |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_cand_exp" ( "district" TEXT, "candidate" TEXT, "affiliation" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );