house_cand_exp
2,378 rows where expenditure_type = "Advertising" sorted by explanation
This data as json, CSV (advanced)
Link | rowid | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2014 | 2014 | House District 08 | Herod, Leslie | Democratic | 2.99 | 6/8/20 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2017 | 2017 | House District 08 | Herod, Leslie | Democratic | 3.99 | 6/22/20 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2019 | 2019 | House District 08 | Herod, Leslie | Democratic | 299.0 | 7/6/20 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2020 | 2020 | House District 08 | Herod, Leslie | Democratic | 2.99 | 7/6/20 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2023 | 2023 | House District 08 | Herod, Leslie | Democratic | 125.0 | 7/31/20 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
2025 | 2025 | House District 08 | Herod, Leslie | Democratic | 24.0 | 8/3/20 0:00 | Google Gsuite | Mountain View | CA | 94043 | Advertising | |
2027 | 2027 | House District 08 | Herod, Leslie | Democratic | 2.99 | 8/6/20 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2029 | 2029 | House District 08 | Herod, Leslie | Democratic | 9.99 | 8/24/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
2030 | 2030 | House District 08 | Herod, Leslie | Democratic | 3.99 | 8/25/20 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2032 | 2032 | House District 08 | Herod, Leslie | Democratic | 125.0 | 8/31/20 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
2033 | 2033 | House District 08 | Herod, Leslie | Democratic | 24.0 | 9/2/20 0:00 | Google Gsuite | Mountain View | CA | 94043 | Advertising | |
2035 | 2035 | House District 08 | Herod, Leslie | Democratic | 2.99 | 9/8/20 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2036 | 2036 | House District 08 | Herod, Leslie | Democratic | 3.99 | 9/23/20 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2040 | 2040 | House District 08 | Herod, Leslie | Democratic | 125.0 | 9/30/20 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
2046 | 2046 | House District 08 | Herod, Leslie | Democratic | 2.99 | 10/8/20 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2063 | 2063 | House District 08 | Herod, Leslie | Democratic | 9.99 | 10/23/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
2064 | 2064 | House District 08 | Herod, Leslie | Democratic | 3.99 | 10/26/20 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2067 | 2067 | House District 08 | Herod, Leslie | Democratic | 125.0 | 10/31/19 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
2071 | 2071 | House District 08 | Herod, Leslie | Democratic | 225.0 | 11/2/20 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
2078 | 2078 | House District 08 | Herod, Leslie | Democratic | 299.0 | 11/5/20 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2090 | 2090 | House District 08 | Herod, Leslie | Democratic | 3.99 | 11/25/19 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2093 | 2093 | House District 08 | Herod, Leslie | Democratic | 350.0 | 11/25/19 0:00 | Superior Blue Strategies | Washington | DC | 20006 | Advertising | |
2094 | 2094 | House District 08 | Herod, Leslie | Democratic | 399.0 | 11/25/20 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2095 | 2095 | House District 08 | Herod, Leslie | Democratic | 225.0 | 11/25/20 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
2101 | 2101 | House District 08 | Herod, Leslie | Democratic | 125.0 | 12/2/19 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
2124 | 2124 | House District 08 | Herod, Leslie | Democratic | 3.99 | 12/23/19 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2125 | 2125 | House District 08 | Herod, Leslie | Democratic | 125.0 | 12/25/19 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
2127 | 2127 | House District 08 | Herod, Leslie | Democratic | 24.85 | 12/30/19 0:00 | Wix.Com | San Francisco | CO | 94140 | Advertising | |
2175 | 2175 | House District 09 | Sirota, Emily | Democratic | 52.16 | 4/25/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2179 | 2179 | House District 09 | Sirota, Emily | Democratic | 52.16 | 5/28/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2181 | 2181 | House District 09 | Sirota, Emily | Democratic | 52.16 | 6/25/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2185 | 2185 | House District 09 | Sirota, Emily | Democratic | 52.16 | 7/25/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2186 | 2186 | House District 09 | Sirota, Emily | Democratic | 5.0 | 8/15/19 0:00 | Constant Contact | Loveland | CO | 80538 | Advertising | |
2189 | 2189 | House District 09 | Sirota, Emily | Democratic | 52.16 | 8/26/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2190 | 2190 | House District 09 | Sirota, Emily | Democratic | 10.0 | 9/16/19 0:00 | Constant Contact | Loveland | CO | 80538 | Advertising | |
2193 | 2193 | House District 09 | Sirota, Emily | Democratic | 52.16 | 9/25/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2197 | 2197 | House District 09 | Sirota, Emily | Democratic | 10.0 | 1/15/20 0:00 | Constant Contact | Loveland | CO | 80538 | Advertising | |
2199 | 2199 | House District 09 | Sirota, Emily | Democratic | 12.0 | 1/23/20 0:00 | Google Domains | Mountain View | CA | 94043 | Advertising | |
2200 | 2200 | House District 09 | Sirota, Emily | Democratic | 62.58 | 1/27/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2202 | 2202 | House District 09 | Sirota, Emily | Democratic | 168.0 | 2/3/20 0:00 | Wix.Com, Inc | New York | NY | 10011 | Advertising | |
2203 | 2203 | House District 09 | Sirota, Emily | Democratic | 10.0 | 2/18/20 0:00 | Constant Contact | Loveland | CO | 80538 | Advertising | |
2205 | 2205 | House District 09 | Sirota, Emily | Democratic | 62.58 | 2/27/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2209 | 2209 | House District 09 | Sirota, Emily | Democratic | 10.0 | 3/16/20 0:00 | Constant Contact | Loveland | CO | 80538 | Advertising | |
2210 | 2210 | House District 09 | Sirota, Emily | Democratic | 62.58 | 3/25/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2213 | 2213 | House District 09 | Sirota, Emily | Democratic | 10.0 | 4/27/20 0:00 | Constant Contact | Loveland | CO | 80538 | Advertising | |
2214 | 2214 | House District 09 | Sirota, Emily | Democratic | 62.58 | 4/27/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2218 | 2218 | House District 09 | Sirota, Emily | Democratic | 10.0 | 5/15/20 0:00 | Constant Contact | Loveland | CO | 80538 | Advertising | |
2219 | 2219 | House District 09 | Sirota, Emily | Democratic | 62.59 | 5/26/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2225 | 2225 | House District 09 | Sirota, Emily | Democratic | 62.58 | 6/25/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2226 | 2226 | House District 09 | Sirota, Emily | Democratic | 62.58 | 7/27/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2230 | 2230 | House District 09 | Sirota, Emily | Democratic | 62.58 | 8/25/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2232 | 2232 | House District 09 | Sirota, Emily | Democratic | 186.55 | 8/31/20 0:00 | C&D Printing Inc | Denver | CO | 80212 | Advertising | |
2249 | 2249 | House District 09 | Sirota, Emily | Democratic | 10.0 | 10/15/19 0:00 | Constant Contact | Loveland | CO | 80538 | Advertising | |
2251 | 2251 | House District 09 | Sirota, Emily | Democratic | 62.58 | 10/25/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2253 | 2253 | House District 09 | Sirota, Emily | Democratic | 62.58 | 10/28/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2256 | 2256 | House District 09 | Sirota, Emily | Democratic | 383.64 | 11/3/20 0:00 | Intermountain Jewish News | Denver | CO | 80203 | Advertising | |
2259 | 2259 | House District 09 | Sirota, Emily | Democratic | 10.0 | 11/15/19 0:00 | Constant Contact | Loveland | CO | 80538 | Advertising | |
2261 | 2261 | House District 09 | Sirota, Emily | Democratic | 62.58 | 11/25/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2262 | 2262 | House District 09 | Sirota, Emily | Democratic | 65.7 | 11/25/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2267 | 2267 | House District 09 | Sirota, Emily | Democratic | 10.0 | 12/16/19 0:00 | Constant Contact | Loveland | CO | 80538 | Advertising | |
2269 | 2269 | House District 09 | Sirota, Emily | Democratic | 62.58 | 12/26/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
2615 | 2615 | House District 10 | Stickney, Kenneth | Republican | 73.06 | 10/22/20 0:00 | Longmont Digital Printing | Longmont | CO | 80501 | Advertising | |
2804 | 2804 | House District 12 | Bernett, Tracey | Democratic | 60.0 | 2/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2807 | 2807 | House District 12 | Bernett, Tracey | Democratic | 240.0 | 2/16/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2814 | 2814 | House District 12 | Bernett, Tracey | Democratic | 450.0 | 2/22/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2826 | 2826 | House District 12 | Bernett, Tracey | Democratic | 300.0 | 2/29/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2831 | 2831 | House District 12 | Bernett, Tracey | Democratic | 600.0 | 3/5/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2833 | 2833 | House District 12 | Bernett, Tracey | Democratic | 210.0 | 3/8/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2834 | 2834 | House District 12 | Bernett, Tracey | Democratic | 170.46 | 3/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2835 | 2835 | House District 12 | Bernett, Tracey | Democratic | 210.0 | 3/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2850 | 2850 | House District 12 | Bernett, Tracey | Democratic | 321.77 | 4/21/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2852 | 2852 | House District 12 | Bernett, Tracey | Democratic | 100.0 | 5/19/20 0:00 | Boulder County Democratic Party | Boulder | CO | 80303 | Advertising | |
2881 | 2881 | House District 12 | Bernett, Tracey | Democratic | 199.49 | 7/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
3019 | 3019 | House District 13 | Amabile, Judith | Democratic | 250.35 | 7/31/19 0:00 | C & D Prinitng | Denver | CO | 80212 | Advertising | |
3021 | 3021 | House District 13 | Amabile, Judith | Democratic | 133.03 | 8/21/19 0:00 | C & D Prinitng | Denver | CO | 80212 | Advertising | |
3036 | 3036 | House District 13 | Amabile, Judith | Democratic | 216.83 | 1/27/20 0:00 | C & D Prinitng | Denver | CO | 80212 | Advertising | |
3044 | 3044 | House District 13 | Amabile, Judith | Democratic | 181.22 | 2/21/20 0:00 | C & D Prinitng | Denver | CO | 80212 | Advertising | |
3045 | 3045 | House District 13 | Amabile, Judith | Democratic | 843.24 | 2/24/20 0:00 | C & D Prinitng | Denver | CO | 80212 | Advertising | |
3046 | 3046 | House District 13 | Amabile, Judith | Democratic | 8.25 | 3/2/20 0:00 | United States Postal Service | Boulder | CO | 80302 | Advertising | |
3049 | 3049 | House District 13 | Amabile, Judith | Democratic | 605.46 | 3/10/20 0:00 | C & D Prinitng | Denver | CO | 80212 | Advertising | |
3055 | 3055 | House District 13 | Amabile, Judith | Democratic | 111.96 | 4/9/20 0:00 | Hustle, Inc. | San Francisco | CA | 94103 | Advertising | |
3056 | 3056 | House District 13 | Amabile, Judith | Democratic | 10.62 | 4/10/20 0:00 | Hustle, Inc. | San Francisco | CA | 94103 | Advertising | |
3063 | 3063 | House District 13 | Amabile, Judith | Democratic | 6.12 | 5/12/20 0:00 | Hustle, Inc. | San Francisco | CA | 94103 | Advertising | |
3064 | 3064 | House District 13 | Amabile, Judith | Democratic | 6.52 | 5/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
3065 | 3065 | House District 13 | Amabile, Judith | Democratic | 25.0 | 5/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
3066 | 3066 | House District 13 | Amabile, Judith | Democratic | 25.0 | 5/15/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
3067 | 3067 | House District 13 | Amabile, Judith | Democratic | 50.0 | 5/18/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
3068 | 3068 | House District 13 | Amabile, Judith | Democratic | 35.0 | 5/18/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
3114 | 3114 | House District 13 | Amabile, Judith | Democratic | 20.0 | 10/15/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
3131 | 3131 | House District 13 | Amabile, Judith | Democratic | 12.84 | 11/12/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
3156 | 3156 | House District 13 | Sipple, Kevin | Republican | 652.0 | 9/25/20 0:00 | Boulder Weekly | Boulder | CO | 80305 | Advertising | |
3159 | 3159 | House District 13 | Sipple, Kevin | Republican | 652.0 | 10/5/20 0:00 | Boulder Weekly | Boulder | CO | 80305 | Advertising | |
3161 | 3161 | House District 13 | Sipple, Kevin | Republican | 1285.2 | 10/14/20 0:00 | Colorado Mountain News | Gypsum | CO | 81637 | Advertising | |
3163 | 3163 | House District 13 | Sipple, Kevin | Republican | 275.0 | 10/14/20 0:00 | Yellow Scene Magazine | Erie | CO | 80516 | Advertising | |
3164 | 3164 | House District 13 | Sipple, Kevin | Republican | 360.0 | 10/14/20 0:00 | Colorado Mountain News | Gypsum | CO | 81637 | Advertising | |
3173 | 3173 | House District 13 | Sipple, Kevin | Republican | 882.0 | 11/2/20 0:00 | Jackson County Star | Walden | CO | 80480 | Advertising | |
3233 | 3233 | House District 14 | Sandridge, Shane | Republican | 31.0 | 2/3/20 0:00 | Campaign Partner | Still River | MA | 1467 | Advertising | |
3236 | 3236 | House District 14 | Sandridge, Shane | Republican | 31.0 | 3/3/20 0:00 | Campaign Partner | Still River | MA | 1467 | Advertising | |
3278 | 3278 | House District 14 | Sandridge, Shane | Republican | 72.3 | 10/25/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
3282 | 3282 | House District 14 | Sandridge, Shane | Republican | 31.0 | 11/2/20 0:00 | Campaign Partner | Still River | MA | 1467 | Advertising |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_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 );