state_exp
2 rows where District = "Attorney General" and state = "RE"
This data as json, CSV (advanced)
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
10207 | 10207 | Attorney General | John Kellner | Republican | 1393.05 | 11/21/22 | Doubletree | Requested | RE | REQUE | Other | 5120 ∑ Event Space Rental |
10210 | 10210 | Attorney General | John Kellner | Republican | 237.04 | 12/2/22 | Doubletree | Requested | RE | REQUE | Other | 7630 ∑ Lodging |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_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 );