senate_exp
9 rows where city = "Chatsworth"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, recipient, expenditure_type, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
3056 | 3056 | Senate District 20 | Tim Walsh | Republican | 1198.08 | 5/12/22 | Aaron,,Thomas & Associatees Inc | Chatsworth | CA | 91311 | Advertising | Door Hangers |
3061 | 3061 | Senate District 20 | Tim Walsh | Republican | 328.0 | 5/23/22 | Aaron,,Thomas & Associatees Inc | Chatsworth | CA | 91311 | Advertising | Palm Cards |
3088 | 3088 | Senate District 20 | Tim Walsh | Republican | 5292.5 | 8/16/22 | Aaron, Thomas & Associates Inc | Chatsworth | CA | 91311 | Other | 6621 ∑ Yard Signs |
3128 | 3128 | Senate District 20 | Tim Walsh | Republican | 1753.0 | 10/8/22 | Aaron, Thomas & Associates Inc | Chatsworth | CA | 91311 | Other | 6615 ∑ Hang Cards |
3138 | 3138 | Senate District 20 | Tim Walsh | Republican | 443.33 | 10/22/22 | Aaron, Thomas & Associates Inc | Chatsworth | CA | 91311 | Other | 6611 ∑ Letterhead & Envelopes |
3140 | 3140 | Senate District 20 | Tim Walsh | Republican | 1375.5 | 10/24/22 | Aaron, Thomas & Associates Inc | Chatsworth | CA | 91311 | Other | 6615 ∑ Hang Cards |
3160 | 3160 | Senate District 20 | Tim Walsh | Republican | 2705.0 | 11/8/22 | Aaron, Thomas And Associates | Chatsworth | CA | 91311 | Advertising | Banners |
3720 | 3720 | Senate District 24 | Courtney Potter | Republican | 576.0 | 4/27/22 | Aaron Thomas & Associates Inc | Chatsworth | CA | 91311 | Advertising | |
3740 | 3740 | Senate District 24 | Courtney Potter | Republican | 972.0 | 7/30/22 | Aaron Thomas & Associates Inc | Chatsworth | CA | 91311 | Advertising |
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 );