house_cand_exp
785 rows where affiliation = "Republican" and expenditure_type = "Advertising" sorted by explanation
This data as json, CSV (advanced)
Suggested facets: state
Link | rowid | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
507 | 507 | House District 03 | Titterington, Dean | Republican | 300.0 | 9/4/20 0:00 | Cutter Consulting Llc | Colorado Springs | CO | 80905 | Advertising | |
510 | 510 | House District 03 | Titterington, Dean | Republican | 325.0 | 10/26/20 0:00 | Acme Political Solutions | Centennial | CO | 80111 | Advertising | |
942 | 942 | House District 05 | Woodley, Jonathan | Republican | 50.0 | 4/14/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
965 | 965 | House District 05 | Woodley, Jonathan | Republican | 180.21 | 10/14/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
981 | 981 | House District 05 | Woodley, Jonathan | Republican | 9.85 | 11/2/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
2615 | 2615 | House District 10 | Stickney, Kenneth | Republican | 73.06 | 10/22/20 0:00 | Longmont Digital Printing | Longmont | CO | 80501 | 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 | |
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 | |||||
3978 | 3978 | House District 19 | Geitner, Tim | Republican | 28.98 | 10/8/20 0:00 | The Home Depot | Colorado Springs | CO | 80920 | 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 | |
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 | |
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 | ||
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 | |
6899 | 6899 | House District 28 | Roybal, Pedro | Republican | 23.88 | 7/6/20 0:00 | Go Daddy.Com | Scottsdale | AZ | 85260 | Advertising | |
6901 | 6901 | House District 28 | Roybal, Pedro | Republican | 1140.0 | 7/16/20 0:00 | Acme Political Solutions | Centennial | CO | 80111 | Advertising | |
6909 | 6909 | House District 28 | Roybal, Pedro | Republican | 22.0 | 10/27/20 0:00 | Us Postal Service | Denver | CO | 80219 | Advertising | |
7099 | 7099 | House District 29 | Warren-Demott, Vanessa | Republican | 125.0 | 9/7/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
7101 | 7101 | House District 29 | Warren-Demott, Vanessa | Republican | 163.2 | 9/18/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
7108 | 7108 | House District 29 | Warren-Demott, Vanessa | Republican | 900.0 | 10/1/20 0:00 | Your Neighbor | Eastlake | CO | 80614 | Advertising | |
7118 | 7118 | House District 29 | Warren-Demott, Vanessa | Republican | 250.0 | 10/12/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
7119 | 7119 | House District 29 | Warren-Demott, Vanessa | Republican | 210.0 | 10/13/20 0:00 | Cutter Consulting Llc | Colorado Springs | CO | 80905 | Advertising | |
7120 | 7120 | House District 29 | Warren-Demott, Vanessa | Republican | 250.0 | 10/14/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
7124 | 7124 | House District 29 | Warren-Demott, Vanessa | Republican | 400.0 | 10/19/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
7128 | 7128 | House District 29 | Warren-Demott, Vanessa | Republican | 350.0 | 10/26/20 0:00 | Mountain Views Pkwy | CA | 94043 | Advertising | ||
7132 | 7132 | House District 29 | Warren-Demott, Vanessa | Republican | 128.69 | 11/4/20 0:00 | Mountain Views Pkwy | CA | 94043 | Advertising | ||
7133 | 7133 | House District 29 | Warren-Demott, Vanessa | Republican | 135.74 | 11/4/20 0:00 | Mountain View Pakway | CA | 94043 | Advertising | ||
7134 | 7134 | House District 29 | Warren-Demott, Vanessa | Republican | 373.44 | 11/4/20 0:00 | Digital Add Prrogram | Menlo Park | CA | 94025 | Advertising | |
7609 | 7609 | House District 30 | Gutierrez, Kerrie | Republican | 999.0 | 9/18/20 0:00 | Campaign Ad Cloud | Indianapolis | IN | 46225 | Advertising | |
7610 | 7610 | House District 30 | Gutierrez, Kerrie | Republican | 50.0 | 9/20/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
7613 | 7613 | House District 30 | Gutierrez, Kerrie | Republican | 299.0 | 9/24/20 0:00 | The Data Group Llc | Orlando | FL | 32803 | Advertising | |
7614 | 7614 | House District 30 | Gutierrez, Kerrie | Republican | 109.13 | 9/25/20 0:00 | Vistaprint | Waltham | MA | 2451 | Advertising | |
7615 | 7615 | House District 30 | Gutierrez, Kerrie | Republican | 999.0 | 9/27/20 0:00 | Campaign Ad Cloud | Indianapolis | IN | 46225 | Advertising | |
7621 | 7621 | House District 30 | Gutierrez, Kerrie | Republican | 34.95 | 10/8/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
7622 | 7622 | House District 30 | Gutierrez, Kerrie | Republican | 499.5 | 10/11/20 0:00 | Campaign Ad Cloud | Indianapolis | IN | 46225 | Advertising | |
7839 | 7839 | House District 32 | Caputo, Anthony | Republican | 900.0 | 8/27/20 0:00 | Outdoor Promotions | Denver | CO | 80221 | Advertising | |
7854 | 7854 | House District 32 | Caputo, Anthony | Republican | 500.0 | 10/30/20 0:00 | El Comercio De Colorado/ Casa Magazine | Denver | CO | 8022 | Advertising | |
7997 | 7997 | House District 33 | Quiachon, Mindy | Republican | 1835.0 | 10/30/20 0:00 | Tele-Town Hall Llc | Golden | CO | 80401 | Advertising | |
7998 | 7998 | House District 33 | Quiachon, Mindy | Republican | 250.0 | 10/30/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
8002 | 8002 | House District 34 | Herman, Audrey | Republican | 172.8 | 3/18/20 0:00 | Squarespace Inc | New York | NY | 10014 | Advertising | |
8544 | 8544 | House District 37 | Cornell, Caroline | Republican | 74.99 | 9/16/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
10271 | 10271 | House District 41 | Andrews, Robert | Republican | 730.0 | 10/2/20 0:00 | Fast Signs | Missouli | MT | 59808 | Advertising | |
11417 | 11417 | House District 45 | Neville, Patrick | Republican | 119.4 | 4/20/20 0:00 | Life Light Creative | Loveland | CO | 80538 | Advertising | |
11600 | 11600 | House District 46 | Ambler, Jonathan | Republican | 102.0 | 2/12/20 0:00 | Wix.Com | San Francisco | CA | Advertising | ||
11917 | 11917 | House District 47 | Luck, Stephanie | Republican | 4.0 | 2/27/20 0:00 | Advertising | |||||
11918 | 11918 | House District 47 | Luck, Stephanie | Republican | 30.55 | 2/28/20 0:00 | Penrose Library | Penrose | CO | 81240 | Advertising | |
11919 | 11919 | House District 47 | Luck, Stephanie | Republican | 8.25 | 2/29/20 0:00 | Penrose Post Office | Penrose | CO | Advertising | ||
11921 | 11921 | House District 47 | Luck, Stephanie | Republican | 98.23 | 3/11/20 0:00 | Vistaprint | Watlham | MA | 2451 | Advertising | |
11928 | 11928 | House District 47 | Luck, Stephanie | Republican | 87.35 | 4/26/20 0:00 | Amazon | North Seattle | WA | 98109 | Advertising | |
11930 | 11930 | House District 47 | Luck, Stephanie | Republican | 12.0 | 4/30/20 0:00 | Wix.Com | San Francisco | CA | 94158 | Advertising | |
11931 | 11931 | House District 47 | Luck, Stephanie | Republican | 564.3 | 5/1/20 0:00 | Postcardmania | Clearwater | FL | 33765 | Advertising | |
11936 | 11936 | House District 47 | Luck, Stephanie | Republican | 350.0 | 5/29/20 0:00 | Data Genomix, Llc | Cleveland | OH | 44108 | 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 );