house_exp
12 rows where District = "House District 42" and expenditure_type = "Employee Services"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, recipient, city, zip, explanation
Link | rowid ▼ | District | candidate_name | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
11215 | 11215 | House District 42 | Mandy Lindsay | 896.0 | 7/3/22 | Bella Brown | Denver | CO | 80222 | Employee Services | Campaign/Canvass Work |
11216 | 11216 | House District 42 | Mandy Lindsay | 240.0 | 7/6/22 | Penny Holmes | Aurora | CO | 80010 | Employee Services | Canvass Pay |
11218 | 11218 | House District 42 | Mandy Lindsay | 240.0 | 7/11/22 | Logan Kicklighter | Denver | CO | 80238 | Employee Services | Canvass Work |
11249 | 11249 | House District 42 | Mandy Lindsay | 100.0 | 8/30/22 | Tristan M Lindsay | Aurora | CO | 80010 | Employee Services | Pay For Campaign Work |
11326 | 11326 | House District 42 | Mandy Lindsay | 100.0 | 11/7/22 | Logan Kicklighter | Denver | CO | 80238 | Employee Services | Canvassing Pay |
11327 | 11327 | House District 42 | Mandy Lindsay | 100.0 | 11/7/22 | Penny Holmes | Aurora | CO | 80010 | Employee Services | Canvassing Pay |
11328 | 11328 | House District 42 | Mandy Lindsay | 100.0 | 11/7/22 | Ewan Holmes | Aurora | CO | 80010 | Employee Services | Canvassing Pay |
11329 | 11329 | House District 42 | Mandy Lindsay | 100.0 | 11/7/22 | Tristan M Lindsay | Aurora | CO | 80010 | Employee Services | Canvassing Pay |
11348 | 11348 | House District 42 | Mandy Lindsay | 100.0 | 11/28/22 | Logan Kicklighter | Denver | CO | 80238 | Employee Services | Win Bonus |
11349 | 11349 | House District 42 | Mandy Lindsay | 100.0 | 11/28/22 | Penny Holmes | Aurora | CO | 80010 | Employee Services | Win Bonus |
11350 | 11350 | House District 42 | Mandy Lindsay | 100.0 | 11/28/22 | Ewan Holmes | Aurora | CO | 80010 | Employee Services | Win Bonus |
11351 | 11351 | House District 42 | Mandy Lindsay | 100.0 | 11/28/22 | Tristan Lindsay | Aurora | CO | 80010 | Employee Services | Win Bonus |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_exp" ( "District" TEXT, "candidate_name" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );