house_cand_exp
5 rows where candidate = "Mclachlan, Barbara", expenditure_type = "Telephone" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, recipient, city, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
14211 | 14211 | House District 59 | Mclachlan, Barbara | Democratic | 10.0 | 10/12/20 0:00 | Google G Suite | Mountain View | CA | 94043 | 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 );