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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
3540 | 3540 | House District 16 | Pico, Andres | Republican | 1275.55 | 8/17/20 0:00 | The Copy Store | Colorado Springs | CO | 80917 | Advertising | |
3544 | 3544 | House District 16 | Pico, Andres | Republican | 74.25 | 9/23/20 0:00 | Weebly.Com | Unk | CO | Advertising | ||
3692 | 3692 | House District 17 | Blancken, Robert | Republican | 389.7 | 7/2/20 0:00 | Canyon Signs | Colorado Springs | CO | 80905 | Advertising | |
3694 | 3694 | House District 17 | Blancken, Robert | Republican | 668.98 | 7/10/20 0:00 | Update Printing | Colorado Springs | CO | 80906 | Advertising | |
3754 | 3754 | House District 18 | Rapko, George | Republican | 14.95 | 6/14/20 0:00 | Advertising | |||||
3759 | 3759 | House District 18 | Snyder, Marc | Democratic | 30.0 | 1/7/19 0:00 | Mountain View | CA | 94043 | Advertising | ||
3763 | 3763 | House District 18 | Snyder, Marc | Democratic | 30.0 | 2/7/19 0:00 | Mountain View | CA | 94043 | Advertising | ||
3769 | 3769 | House District 18 | Snyder, Marc | Democratic | 30.0 | 3/6/19 0:00 | Mountain View | CA | 94043 | Advertising | ||
3776 | 3776 | House District 18 | Snyder, Marc | Democratic | 20.0 | 4/26/19 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
3789 | 3789 | House District 18 | Snyder, Marc | Democratic | 45.0 | 7/28/19 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
3792 | 3792 | House District 18 | Snyder, Marc | Democratic | 45.0 | 8/27/19 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
3800 | 3800 | House District 18 | Snyder, Marc | Democratic | 2.33 | 12/6/18 0:00 | Mountain View | CA | 94043 | Advertising | ||
3866 | 3866 | House District 18 | Snyder, Marc | Democratic | 36.0 | 10/2/19 0:00 | Mountain View | CA | 94043 | Advertising | ||
3978 | 3978 | House District 19 | Geitner, Tim | Republican | 28.98 | 10/8/20 0:00 | The Home Depot | Colorado Springs | CO | 80920 | Advertising | |
4045 | 4045 | House District 20 | Crutchfield, Susan | Democratic | 140.0 | 5/27/20 0:00 | Textedly | Los Angeles | CA | 91723 | Advertising | |
4047 | 4047 | House District 20 | Crutchfield, Susan | Democratic | 50.0 | 5/29/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4048 | 4048 | House District 20 | Crutchfield, Susan | Democratic | 5.14 | 5/31/20 0:00 | Act Blue | Somerville | MA | 2144 | Advertising | |
4056 | 4056 | House District 20 | Crutchfield, Susan | Democratic | 140.0 | 6/28/20 0:00 | Textedly | Los Angeles | CA | 91723 | Advertising | |
4082 | 4082 | House District 20 | Carver, Terri | Republican | 483.44 | 7/8/20 0:00 | Victory Store | Davenport | IA | 52802 | Advertising | |
4086 | 4086 | House District 20 | Carver, Terri | Republican | 830.53 | 7/22/20 0:00 | Kaeser & Blair Inc. | Batavia | OH | 45103 | Advertising | |
4278 | 4278 | House District 21 | Rosenbaum, Liz | Democratic | 240.0 | 12/16/19 0:00 | Weebly Website | Advertising | ||||
4280 | 4280 | House District 21 | Rosenbaum, Liz | Democratic | 240.0 | 12/16/19 0:00 | Weebly Website | Advertising | ||||
4413 | 4413 | House District 22 | Larson, Colin | Republican | 500.0 | 3/23/20 0:00 | Baton Rouge | LA | 70801 | Advertising | ||
4418 | 4418 | House District 22 | Larson, Colin | Republican | 500.0 | 3/30/20 0:00 | Baton Rouge | LA | 70801 | Advertising | ||
4423 | 4423 | House District 22 | Larson, Colin | Republican | 600.0 | 4/12/20 0:00 | Baton Rouge | LA | 70801 | Advertising | ||
4424 | 4424 | House District 22 | Larson, Colin | Republican | 42.54 | 4/14/20 0:00 | Baton Rouge | LA | 70801 | Advertising | ||
4429 | 4429 | House District 22 | Larson, Colin | Republican | 900.0 | 5/1/20 0:00 | Baton Rouge | LA | 70801 | Advertising | ||
4439 | 4439 | House District 22 | Larson, Colin | Republican | 248.84 | 5/14/20 0:00 | Baton Rouge | LA | 70801 | Advertising | ||
4505 | 4505 | House District 22 | Larson, Colin | Republican | 160.85 | 7/14/20 0:00 | Baton Rouge | LA | 70801 | Advertising | ||
4510 | 4510 | House District 22 | Larson, Colin | Republican | 305.99 | 7/27/20 0:00 | Mountain View | CO | 94043 | Advertising | ||
4543 | 4543 | House District 22 | Larson, Colin | Republican | 2.25 | 9/17/20 0:00 | Anedot | Baton Rouge | LA | 70801 | Advertising | |
4706 | 4706 | House District 22 | Parker, Mary | Democratic | 2250.0 | 7/30/20 0:00 | Outdoor Promotions Of Colorado | Denver | CO | 80221 | Advertising | |
4717 | 4717 | House District 22 | Parker, Mary | Democratic | 350.0 | 9/26/20 0:00 | United States Postal Service | Littleton | CO | 80123 | Advertising | |
4750 | 4750 | House District 23 | Kennedy, Chris | Democratic | 120.0 | 1/9/19 0:00 | Ngp Van Inc. | Somerville | MA | 2144 | Advertising | |
4754 | 4754 | House District 23 | Kennedy, Chris | Democratic | 30.0 | 1/31/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
4755 | 4755 | House District 23 | Kennedy, Chris | Democratic | 30.0 | 2/1/19 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | |
4760 | 4760 | House District 23 | Kennedy, Chris | Democratic | 30.0 | 3/1/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
4768 | 4768 | House District 23 | Kennedy, Chris | Democratic | 30.0 | 4/1/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
4777 | 4777 | House District 23 | Kennedy, Chris | Democratic | 20.0 | 5/1/19 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | |
4778 | 4778 | House District 23 | Kennedy, Chris | Democratic | 30.0 | 5/1/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
4781 | 4781 | House District 23 | Kennedy, Chris | Democratic | 30.0 | 5/31/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
4783 | 4783 | House District 23 | Kennedy, Chris | Democratic | 30.0 | 6/30/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
4802 | 4802 | House District 23 | Kennedy, Chris | Democratic | 88.53 | 12/1/18 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | |
4809 | 4809 | House District 23 | Kennedy, Chris | Democratic | 30.0 | 12/31/18 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
4812 | 4812 | House District 23 | Kennedy, Chris | Democratic | 34.99 | 1/15/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
4825 | 4825 | House District 23 | Kennedy, Chris | Democratic | 34.99 | 2/29/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
4826 | 4826 | House District 23 | Kennedy, Chris | Democratic | 44.75 | 2/29/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | |
4831 | 4831 | House District 23 | Kennedy, Chris | Democratic | 34.99 | 3/30/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
4833 | 4833 | House District 23 | Kennedy, Chris | Democratic | 150.0 | 3/31/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | |
4837 | 4837 | House District 23 | Kennedy, Chris | Democratic | 950.09 | 4/23/20 0:00 | C&D Printing | Denver | CO | 80212 | Advertising | |
4840 | 4840 | House District 23 | Kennedy, Chris | Democratic | 34.99 | 5/1/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
4845 | 4845 | House District 23 | Kennedy, Chris | Democratic | 34.99 | 5/30/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
4900 | 4900 | House District 23 | Kennedy, Chris | Democratic | 25.0 | 9/2/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | |
5111 | 5111 | House District 24 | Imer, Laurel | Republican | 5.0 | 10/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5115 | 5115 | House District 24 | Imer, Laurel | Republican | 25.0 | 10/7/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5120 | 5120 | House District 24 | Imer, Laurel | Republican | 35.0 | 10/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5182 | 5182 | House District 24 | Duran, Monica | Democratic | 6.0 | 4/30/19 0:00 | Advertising | |||||
5204 | 5204 | House District 24 | Duran, Monica | Democratic | 1.21 | 7/2/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5212 | 5212 | House District 24 | Duran, Monica | Democratic | 150.0 | 7/10/19 0:00 | Jefferson Democratic Latino Initiative | Lakewood | CO | 80215 | Advertising | |
5225 | 5225 | House District 24 | Duran, Monica | Democratic | 206.14 | 8/1/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5240 | 5240 | House District 24 | Duran, Monica | Democratic | 202.32 | 9/3/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5315 | 5315 | House District 24 | Duran, Monica | Democratic | 134.93 | 6/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5333 | 5333 | House District 24 | Duran, Monica | Democratic | 155.27 | 7/7/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5344 | 5344 | House District 24 | Duran, Monica | Democratic | 44.03 | 8/3/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5366 | 5366 | House District 24 | Duran, Monica | Democratic | 96.75 | 9/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5384 | 5384 | House District 24 | Duran, Monica | Democratic | 91.25 | 10/1/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5419 | 5419 | House District 24 | Duran, Monica | Democratic | 100.0 | 11/1/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5421 | 5421 | House District 24 | Duran, Monica | Democratic | 228.38 | 11/2/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5448 | 5448 | House District 24 | Duran, Monica | Democratic | 30.0 | 12/2/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5458 | 5458 | House District 24 | Duran, Monica | Democratic | 205.35 | 12/31/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5552 | 5552 | House District 25 | Cutter, Lisa | Democratic | 29.37 | 8/28/19 0:00 | Robodial | Arlington | VA | 22203 | Advertising | |
5555 | 5555 | House District 25 | Cutter, Lisa | Democratic | 31.07 | 9/4/19 0:00 | Robodial | Arlington | VA | 22203 | Advertising | |
5557 | 5557 | House District 25 | Cutter, Lisa | Democratic | 41.14 | 9/12/19 0:00 | Robodial | Arlington | VA | 22203 | Advertising | |
5838 | 5838 | House District 25 | Cutter, Lisa | Democratic | 25.0 | 7/6/20 0:00 | Robodial | Arlington | VA | 22203 | Advertising | |
6138 | 6138 | House District 25 | Rosier, Donald | Republican | 35.0 | 5/31/20 0:00 | My Mountain Town | Longmont | CO | 80501 | Advertising | |
6144 | 6144 | House District 25 | Rosier, Donald | Republican | 54.39 | 6/30/20 0:00 | Vista Print | Waltham | MA | 2451 | Advertising | |
6166 | 6166 | House District 25 | Rosier, Donald | Republican | 524.66 | 9/2/20 0:00 | Signs.Com | Salt Lake City | UT | 84104 | Advertising | |
6169 | 6169 | House District 25 | Rosier, Donald | Republican | 524.66 | 9/3/20 0:00 | Signs.Com | Salt Lake City | UT | 84104 | Advertising | |
6173 | 6173 | House District 25 | Rosier, Donald | Republican | 35.0 | 9/9/20 0:00 | Science Sense Llc | Longmont | CO | 80501 | Advertising | |
6179 | 6179 | House District 25 | Rosier, Donald | Republican | 35.0 | 10/2/20 0:00 | Science Sense Llc | Longmont | CO | 80501 | Advertising | |
6184 | 6184 | House District 25 | Rosier, Donald | Republican | 35.0 | 10/5/20 0:00 | Science Sense Llc | Longmont | CO | 80501 | Advertising | |
6186 | 6186 | House District 25 | Rosier, Donald | Republican | 2500.0 | 10/5/20 0:00 | Colorado Serenity Magazine | Evergreen | CO | 80439 | Advertising | |
6202 | 6202 | House District 25 | Rosier, Donald | Republican | 375.0 | 10/30/20 0:00 | My Mountain Town | Longmont | CO | 80501 | Advertising | |
6756 | 6756 | House District 27 | Pyne, Vicki | Republican | 41.94 | 1/2/20 0:00 | Godaddy | Scottsdale | AZ | 85260 | Advertising | |
6763 | 6763 | House District 27 | Pyne, Vicki | Republican | 662.41 | 2/3/20 0:00 | Ministry Press | Arvada | CO | 80002 | Advertising | |
6764 | 6764 | House District 27 | Pyne, Vicki | Republican | 292.53 | 2/4/20 0:00 | Vistaprint | Waltham | MA | 2451 | Advertising | |
6794 | 6794 | House District 27 | Pyne, Vicki | Republican | 215.76 | 6/15/20 0:00 | Godaddy | Scottsdale | AZ | 85260 | Advertising | |
6807 | 6807 | House District 27 | Pyne, Vicki | Republican | 151.77 | 7/13/20 0:00 | Vistaprint | Waltham | MA | 2451 | Advertising | |
6808 | 6808 | House District 27 | Pyne, Vicki | Republican | 8.9 | 7/13/20 0:00 | Vistaprint | Waltham | MA | 2451 | Advertising | |
6810 | 6810 | House District 27 | Pyne, Vicki | Republican | 79.99 | 7/15/20 0:00 | Godaddy | Scottsdale | AZ | 85260 | Advertising | |
6815 | 6815 | House District 27 | Pyne, Vicki | Republican | 35.88 | 7/28/20 0:00 | Godaddy | Scottsdale | AZ | 85260 | Advertising | |
6816 | 6816 | House District 27 | Pyne, Vicki | Republican | 41.94 | 7/29/20 0:00 | Godaddy | Scottsdale | AZ | 85260 | Advertising | |
6823 | 6823 | House District 27 | Pyne, Vicki | Republican | 1982.07 | 8/5/20 0:00 | Vision Graphics | Denver | CO | 80216 | Advertising | |
6835 | 6835 | House District 27 | Pyne, Vicki | Republican | 1000.0 | 8/28/20 0:00 | Legacy Consulting Llc | Englewood | CO | 80113 | Advertising | |
6844 | 6844 | House District 27 | Pyne, Vicki | Republican | 784.0 | 9/8/20 0:00 | Vision Graphics | Denver | CO | 80216 | Advertising | |
6848 | 6848 | House District 27 | Pyne, Vicki | Republican | 5000.0 | 9/14/20 0:00 | Legacy Consulting Llc | Englewood | CO | 80113 | Advertising | |
6892 | 6892 | House District 27 | Pyne, Vicki | Republican | 74.92 | 12/17/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
6893 | 6893 | House District 27 | Pyne, Vicki | Republican | 6.71 | 12/18/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
6894 | 6894 | House District 27 | Pyne, Vicki | Republican | 64.99 | 12/24/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
6898 | 6898 | House District 28 | Roybal, Pedro | Republican | 19.18 | 7/6/20 0:00 | Go Daddy.Com | Scottsdale | AZ | 85260 | 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 );