senate_cand_exp
25 rows where district = "Senate District 27" and expenditure_type = "Advertising"
This data as json, CSV (advanced)
Suggested facets: candidate, affiliation, expenditure_amount, recipient, city, state, zip, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
4778 | 4778 | Senate District 27 | Staiert, Suzanne | Republican | 1150.0 | 8/25/20 0:00 | Acme Political Solutions | Centennial | CO | 80111 | Advertising | Yard Signs |
4796 | 4796 | Senate District 27 | Staiert, Suzanne | Republican | 375.0 | 10/1/20 0:00 | Independence Institute | Denver | CO | 80203 | Advertising | Video Fees |
4807 | 4807 | Senate District 27 | Staiert, Suzanne | Republican | 211.2 | 10/19/20 0:00 | Paragon Graphics And Printing | Denver | CO | 80222 | Advertising | |
4832 | 4832 | Senate District 27 | Kolker, Chris | Democratic | 20.33 | 2/4/19 0:00 | Menlo Park | CA | 94025 | Advertising | Post Boost | |
4833 | 4833 | Senate District 27 | Kolker, Chris | Democratic | 4.67 | 2/11/19 0:00 | Menlo Park | CA | 94025 | Advertising | Post Boost | |
4835 | 4835 | Senate District 27 | Kolker, Chris | Democratic | 75.0 | 2/20/19 0:00 | Minuteman Press | Centennial | CO | 80122 | Advertising | Design Services |
4836 | 4836 | Senate District 27 | Kolker, Chris | Democratic | 21.35 | 3/1/19 0:00 | Minuteman Press | Centennial | CO | 80122 | Advertising | Graphic Design |
4837 | 4837 | Senate District 27 | Kolker, Chris | Democratic | 208.55 | 3/4/19 0:00 | C & D Printing | Denver | CO | 80212 | Advertising | Envelopes And Design |
4846 | 4846 | Senate District 27 | Kolker, Chris | Democratic | 21.84 | 4/25/19 0:00 | Menlo Park | CA | 94025 | Advertising | Post Boost | |
4848 | 4848 | Senate District 27 | Kolker, Chris | Democratic | 33.71 | 4/29/19 0:00 | Menlo Park | CA | 94025 | Advertising | Post Boost | |
4849 | 4849 | Senate District 27 | Kolker, Chris | Democratic | 42.13 | 5/1/19 0:00 | Menlo Park | CA | 94025 | Advertising | Post Boost | |
4850 | 4850 | Senate District 27 | Kolker, Chris | Democratic | 31.33 | 5/3/19 0:00 | Menlo Park | CA | 94025 | Advertising | Post Boost | |
4851 | 4851 | Senate District 27 | Kolker, Chris | Democratic | 12.83 | 5/9/19 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
4857 | 4857 | Senate District 27 | Kolker, Chris | Democratic | 34.71 | 6/10/19 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
4858 | 4858 | Senate District 27 | Kolker, Chris | Democratic | 25.29 | 6/12/19 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
4862 | 4862 | Senate District 27 | Kolker, Chris | Democratic | 49.65 | 7/1/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4864 | 4864 | Senate District 27 | Kolker, Chris | Democratic | 10.35 | 7/8/19 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ad | |
4875 | 4875 | Senate District 27 | Kolker, Chris | Democratic | 38.48 | 9/6/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4878 | 4878 | Senate District 27 | Kolker, Chris | Democratic | 21.51 | 9/13/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4895 | 4895 | Senate District 27 | Kolker, Chris | Democratic | 125.0 | 2/18/20 0:00 | Denver Area Labor Federation | Denver | CO | 80224 | Advertising | |
5008 | 5008 | Senate District 27 | Kolker, Chris | Democratic | 10000.0 | 10/2/20 0:00 | Turn It Blue Llc | Boulder | CO | 80304 | Advertising | Digital Ad Buy |
5012 | 5012 | Senate District 27 | Kolker, Chris | Democratic | 60.0 | 10/5/20 0:00 | Callfire | Santa Monica | CA | 90401 | Advertising | Voter Outreach Software |
5018 | 5018 | Senate District 27 | Kolker, Chris | Democratic | 10000.0 | 10/9/20 0:00 | Turn It Blue Llc | Boulder | CO | 80304 | Advertising | Digital Ad Buy |
5034 | 5034 | Senate District 27 | Kolker, Chris | Democratic | 10000.0 | 10/20/20 0:00 | Turn It Blue Llc | Boulder | CO | 80304 | Advertising | Digital Ad Buy |
5043 | 5043 | Senate District 27 | Kolker, Chris | Democratic | 5000.0 | 10/27/20 0:00 | Turn It Blue Llc | Boulder | CO | 80304 | Advertising | Digital Ad Buy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_cand_exp" ( "district" TEXT, "candidate" TEXT, "affiliation" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );