senate_exp
9 rows where District = "Senate District 35" and state = "WA"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
5160 | 5160 | Senate District 35 | Rod Pelton | Republican | 333.3 | 5/8/22 | Amazon | Seattle | WA | 98109 | Advertising | Sign Brackets |
5162 | 5162 | Senate District 35 | Rod Pelton | Republican | 2.05 | 5/11/22 | Amazon | Seattle | WA | 98109 | Advertising | |
5182 | 5182 | Senate District 35 | Rod Pelton | Republican | 76.12 | 6/16/22 | Amazon | Seattle | WA | 98109 | Advertising | |
5184 | 5184 | Senate District 35 | Rod Pelton | Republican | 109.55 | 6/20/22 | Amazon | Seattle | WA | 98109 | Advertising | Parade Supplies |
5185 | 5185 | Senate District 35 | Rod Pelton | Republican | 82.3 | 6/20/22 | Amazon | Seattle | WA | 98109 | Advertising | Parade Candy |
5189 | 5189 | Senate District 35 | Rod Pelton | Republican | 82.3 | 6/27/22 | Amazon | Seattle | WA | 98109 | Advertising | Parade Candy |
5208 | 5208 | Senate District 35 | Rod Pelton | Republican | 181.32 | 7/17/22 | Amazon | Seattle | WA | 98109 | Advertising | Stakes For Signs |
5212 | 5212 | Senate District 35 | Rod Pelton | Republican | 116.52 | 7/20/22 | Amazon | Seattle | WA | 98109 | Advertising | Stakes For Signs |
5241 | 5241 | Senate District 35 | Rod Pelton | Republican | 41.42 | 8/22/22 | Amazon | Seattle | WA | 98109 | Advertising | Parade Candy |
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 );