state_exp
5 rows where candidate_name = "Mark VanDriel" and expenditure_type = "Advertising"
This data as json, CSV (advanced)
Suggested facets: recipient, city, state, zip
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
8349 | 8349 | CU Regent District 08 | Mark VanDriel | Republican | 175.17 | 4/1/22 | The Copy Shoppe | Greeley | CO | 80634 | Advertising | Printing Of Flyers |
8350 | 8350 | CU Regent District 08 | Mark VanDriel | Republican | 94.04 | 5/9/22 | Vistaprint | Waltham | MA | 2451 | Advertising | |
8353 | 8353 | CU Regent District 08 | Mark VanDriel | Republican | 165.72 | 7/31/22 | Vistaprint | Waltham | MA | 2451 | Advertising | |
8356 | 8356 | CU Regent District 08 | Mark VanDriel | Republican | 543.12 | 8/10/22 | Political Yard Signs | Neenah | WI | 54956 | Advertising | |
8359 | 8359 | CU Regent District 08 | Mark VanDriel | Republican | 254.23 | 9/7/22 | Vistaprint | Waltham | MA | 2451 | Advertising | Card Printing |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_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 );