house_exp
9 rows where city = "Laguna Beach" and expenditure_type = "Telephone"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount
Link | rowid ▼ | District | candidate_name | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
10239 | 10239 | House District 38 | David Ortiz | 149.0 | 1/4/22 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
10244 | 10244 | House District 38 | David Ortiz | 149.0 | 2/3/22 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
10290 | 10290 | House District 38 | David Ortiz | 149.0 | 6/3/22 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
10292 | 10292 | House District 38 | David Ortiz | 134.1 | 6/6/22 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
10310 | 10310 | House District 38 | David Ortiz | 298.0 | 7/5/22 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
10328 | 10328 | House District 38 | David Ortiz | 298.0 | 8/3/22 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
10343 | 10343 | House District 38 | David Ortiz | 298.0 | 9/6/22 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
10363 | 10363 | House District 38 | David Ortiz | 298.0 | 10/3/22 | Phoneburner | Laguna Beach | CA | 92651 | Telephone | |
10406 | 10406 | House District 38 | David Ortiz | 298.0 | 11/3/22 | Phoneburner | Laguna Beach | CA | 92651 | Telephone |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_exp" ( "District" TEXT, "candidate_name" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );