senate_exp
3 rows where District = "Senate District 27" and city = "Irvine"
This data as json, CSV (advanced)
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
3901 | 3901 | Senate District 27 | Tom Sullivan | Democratic | 19.11 | 8/9/22 | Numero | Irvine | CA | 92618 | Fundraising Expenses | Numero Expenses From 08/02 Through 08/09/2022 |
3914 | 3914 | Senate District 27 | Tom Sullivan | Democratic | 36.83 | 8/31/22 | Numero | Irvine | CA | 92618 | Fundraising Expenses | Numero Expenses From 08/10/2022 Through 08/31/2022 |
3938 | 3938 | Senate District 27 | Tom Sullivan | Democratic | 35.02 | 10/12/22 | Numero | Irvine | CA | 92618 | Fundraising Expenses | Numero Expenses From 09/29/22 Through 10/12/22 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_exp" ( "District" TEXT, "candidate_name" TEXT, "Party" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );