ed_cand_exp
11 rows where candidate = "Escarcega, Lisa" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
21 | 21 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 25.0 | 5/15/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Fee | |
25 | 25 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 18.37 | 6/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
28 | 28 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 25.0 | 6/10/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
31 | 31 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 35.0 | 6/16/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
34 | 34 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 50.0 | 6/24/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
36 | 36 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 75.0 | 6/26/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
37 | 37 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 350.0 | 6/29/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
38 | 38 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 125.0 | 6/30/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
40 | 40 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 289.55 | 7/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
46 | 46 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 96.94 | 7/28/20 0:00 | Mountain View | CA | 94043 | Advertising | Advertising | |
48 | 48 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 3.56 | 8/3/20 0:00 | Menlo Park | CA | 94025 | Advertising |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "ed_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 );