senate_exp
11 rows where expenditure_type = "Advertising" and state = "WA"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, expenditure_amount, expenditure_date, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
536 | 536 | Senate District 03 | Stephen A. Varela | Republican | 131.44 | 9/6/22 | Amazon | Seattle | WA | 98109 | Advertising | Advertising Materials |
1270 | 1270 | Senate District 08 | Matt Solomon | Republican | 34.21 | 2/18/22 | Amazon | Seattle | WA | 98109 | Advertising | |
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 );