senate_exp
11 rows where candidate_name = "Tim Walsh" and expenditure_type = "Advertising"
This data as json, CSV (advanced)
Suggested facets: recipient, city, state, zip, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
3051 | 3051 | Senate District 20 | Tim Walsh | Republican | 2248.16 | 5/3/22 | Patriot Pathways | Lakewood | CO | 80227 | Advertising | Facebook Space Buy |
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 |
3066 | 3066 | Senate District 20 | Tim Walsh | Republican | 1050.46 | 6/22/22 | Patriot Pathways | Lakewood | CO | 80227 | Advertising | Media Advertising |
3108 | 3108 | Senate District 20 | Tim Walsh | Republican | 750.0 | 9/15/22 | Flat Creek | Lafayette | CO | 80026 | Advertising | |
3145 | 3145 | Senate District 20 | Tim Walsh | Republican | 50000.0 | 10/28/22 | Ascent Media | Denver | CO | 80202 | Advertising | Tv |
3149 | 3149 | Senate District 20 | Tim Walsh | Republican | 10000.0 | 11/1/22 | Ascent Media | Denver | CO | 80202 | Advertising | Tv |
3156 | 3156 | Senate District 20 | Tim Walsh | Republican | 15000.0 | 11/3/22 | 76 Group | Frisco | CO | 80443 | Advertising | Mailers |
3160 | 3160 | Senate District 20 | Tim Walsh | Republican | 2705.0 | 11/8/22 | Aaron, Thomas And Associates | Chatsworth | CA | 91311 | Advertising | Banners |
3161 | 3161 | Senate District 20 | Tim Walsh | Republican | 28015.74 | 11/15/22 | Flat Creek | Lafayette | CO | 80026 | Advertising | Digital Advertising |
3164 | 3164 | Senate District 20 | Tim Walsh | Republican | 1267.59 | 11/18/22 | Patriot Pathways | Lakewood | CO | 80227 | Advertising | Online |
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 );