house_cand_exp
14 rows where candidate = "Ortiz, David" and expenditure_type = "Telephone"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
9259 | 9259 | House District 38 | Ortiz, David | Democratic | 298.0 | 1/3/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | Phoneburner Is A Telephone Software That Houses Contacts For You. |
9273 | 9273 | House District 38 | Ortiz, David | Democratic | 298.0 | 2/3/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | Phoneburner Is A Telephone Software That Houses Contacts For You. |
9287 | 9287 | House District 38 | Ortiz, David | Democratic | 298.0 | 3/2/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | Phoneburner Is A Telephone Software That Houses Contacts For You. |
9295 | 9295 | House District 38 | Ortiz, David | Democratic | 298.0 | 4/2/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | Phoneburner Is A Telephone Software That Houses Contacts For You. |
9315 | 9315 | House District 38 | Ortiz, David | Democratic | 298.0 | 5/4/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | Phoneburner Is A Telephone Software. |
9329 | 9329 | House District 38 | Ortiz, David | Democratic | 29.0 | 5/27/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | Phoneburner Is A Phone Software Program |
9337 | 9337 | House District 38 | Ortiz, David | Democratic | 447.0 | 6/2/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | Phoneburner Monthly Fee |
9371 | 9371 | House District 38 | Ortiz, David | Democratic | 447.0 | 7/2/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
9393 | 9393 | House District 38 | Ortiz, David | Democratic | 447.0 | 8/3/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
9414 | 9414 | House District 38 | Ortiz, David | Democratic | 447.0 | 9/2/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
9443 | 9443 | House District 38 | Ortiz, David | Democratic | 447.0 | 10/2/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
9482 | 9482 | House District 38 | Ortiz, David | Democratic | 29.8 | 10/30/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
9483 | 9483 | House District 38 | Ortiz, David | Democratic | 14.9 | 10/30/20 0:00 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
9491 | 9491 | House District 38 | Ortiz, David | Democratic | 894.0 | 11/2/20 0:00 | Phoneburner | 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 );