house_cand_exp
2,378 rows where expenditure_type = "Advertising" sorted by city
This data as json, CSV (advanced)
Link | rowid | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city ▼ | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
6315 | 6315 | House District 26 | Roberts, Dylan | Democratic | 59.99 | 5/26/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mailchimp Dues |
6319 | 6319 | House District 26 | Roberts, Dylan | Democratic | 59.99 | 6/23/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mailchimp Fees |
6325 | 6325 | House District 26 | Roberts, Dylan | Democratic | 59.99 | 7/23/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mailchimp Fees |
6334 | 6334 | House District 26 | Roberts, Dylan | Democratic | 59.99 | 8/24/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mailchimp Fees |
6342 | 6342 | House District 26 | Roberts, Dylan | Democratic | 59.99 | 9/23/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mailchimp Fees |
6355 | 6355 | House District 26 | Roberts, Dylan | Democratic | 59.99 | 10/23/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mailchimp Fees |
6357 | 6357 | House District 26 | Roberts, Dylan | Democratic | 59.99 | 10/26/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mailchimp Fees |
6367 | 6367 | House District 26 | Roberts, Dylan | Democratic | 62.99 | 11/23/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mailchimp Fees |
6368 | 6368 | House District 26 | Roberts, Dylan | Democratic | 59.99 | 11/25/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mailchimp Fees |
6382 | 6382 | House District 26 | Roberts, Dylan | Democratic | 59.99 | 12/23/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mailchimp Fees |
7504 | 7504 | House District 30 | Michaelson Jenet, Dafna | Democratic | 29.99 | 6/15/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mail Chimp Subscription |
7510 | 7510 | House District 30 | Michaelson Jenet, Dafna | Democratic | 29.99 | 7/15/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mailchimp Newsletter |
7519 | 7519 | House District 30 | Michaelson Jenet, Dafna | Democratic | 29.99 | 8/15/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Newsletter |
7528 | 7528 | House District 30 | Michaelson Jenet, Dafna | Democratic | 26.99 | 9/12/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Newspaper |
7629 | 7629 | House District 30 | Gutierrez, Kerrie | Republican | 163.45 | 10/29/20 0:00 | Mailchimp | Atlanta | GA | 303808 | Advertising | Email Sends |
7868 | 7868 | House District 33 | Gray, Matt | Democratic | 30.0 | 4/2/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7871 | 7871 | House District 33 | Gray, Matt | Democratic | 30.0 | 5/2/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7873 | 7873 | House District 33 | Gray, Matt | Democratic | 30.0 | 6/3/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7876 | 7876 | House District 33 | Gray, Matt | Democratic | 30.0 | 7/2/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7878 | 7878 | House District 33 | Gray, Matt | Democratic | 30.0 | 8/2/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7880 | 7880 | House District 33 | Gray, Matt | Democratic | 30.0 | 9/3/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7883 | 7883 | House District 33 | Gray, Matt | Democratic | 30.0 | 12/3/18 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7887 | 7887 | House District 33 | Gray, Matt | Democratic | 34.0 | 1/2/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7890 | 7890 | House District 33 | Gray, Matt | Democratic | 34.99 | 2/3/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7892 | 7892 | House District 33 | Gray, Matt | Democratic | 34.99 | 3/2/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7894 | 7894 | House District 33 | Gray, Matt | Democratic | 34.99 | 4/2/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7896 | 7896 | House District 33 | Gray, Matt | Democratic | 34.99 | 5/4/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7898 | 7898 | House District 33 | Gray, Matt | Democratic | 34.99 | 6/2/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7900 | 7900 | House District 33 | Gray, Matt | Democratic | 34.99 | 7/3/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7905 | 7905 | House District 33 | Gray, Matt | Democratic | 34.99 | 8/3/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Email Communication. |
7909 | 7909 | House District 33 | Gray, Matt | Democratic | 34.99 | 9/2/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Email Communication |
7922 | 7922 | House District 33 | Gray, Matt | Democratic | 34.99 | 10/2/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7923 | 7923 | House District 33 | Gray, Matt | Democratic | 34.99 | 10/2/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Email Marketing |
7939 | 7939 | House District 33 | Gray, Matt | Democratic | 34.99 | 11/2/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Email Adveristing |
7940 | 7940 | House District 33 | Gray, Matt | Democratic | 34.99 | 11/4/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
7946 | 7946 | House District 33 | Gray, Matt | Democratic | 34.99 | 12/2/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
8544 | 8544 | House District 37 | Cornell, Caroline | Republican | 74.99 | 9/16/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
8658 | 8658 | House District 37 | Sullivan, Tom | Democratic | 27.0 | 1/25/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8665 | 8665 | House District 37 | Sullivan, Tom | Democratic | 27.0 | 2/25/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8669 | 8669 | House District 37 | Sullivan, Tom | Democratic | 27.0 | 3/25/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8674 | 8674 | House District 37 | Sullivan, Tom | Democratic | 27.0 | 4/25/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8684 | 8684 | House District 37 | Sullivan, Tom | Democratic | 27.0 | 5/28/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8691 | 8691 | House District 37 | Sullivan, Tom | Democratic | 27.0 | 6/25/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8698 | 8698 | House District 37 | Sullivan, Tom | Democratic | 27.0 | 7/25/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8705 | 8705 | House District 37 | Sullivan, Tom | Democratic | 27.0 | 8/26/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8713 | 8713 | House District 37 | Sullivan, Tom | Democratic | 27.0 | 9/25/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8729 | 8729 | House District 37 | Sullivan, Tom | Democratic | 27.0 | 12/26/18 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8740 | 8740 | House District 37 | Sullivan, Tom | Democratic | 31.49 | 1/27/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8747 | 8747 | House District 37 | Sullivan, Tom | Democratic | 31.49 | 2/25/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8754 | 8754 | House District 37 | Sullivan, Tom | Democratic | 31.49 | 3/25/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8761 | 8761 | House District 37 | Sullivan, Tom | Democratic | 31.49 | 4/26/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8770 | 8770 | House District 37 | Sullivan, Tom | Democratic | 31.49 | 5/26/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8779 | 8779 | House District 37 | Sullivan, Tom | Democratic | 31.49 | 6/25/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8793 | 8793 | House District 37 | Sullivan, Tom | Democratic | 31.49 | 7/27/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8812 | 8812 | House District 37 | Sullivan, Tom | Democratic | 31.49 | 8/25/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8831 | 8831 | House District 37 | Sullivan, Tom | Democratic | 31.03 | 9/23/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8833 | 8833 | House District 37 | Sullivan, Tom | Democratic | 31.49 | 9/25/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8885 | 8885 | House District 37 | Sullivan, Tom | Democratic | 31.49 | 10/25/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8925 | 8925 | House District 37 | Sullivan, Tom | Democratic | 31.49 | 11/25/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8926 | 8926 | House District 37 | Sullivan, Tom | Democratic | 32.39 | 11/25/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
8936 | 8936 | House District 37 | Sullivan, Tom | Democratic | 31.49 | 12/26/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
9370 | 9370 | House District 38 | Ortiz, David | Democratic | 29.99 | 7/1/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
9439 | 9439 | House District 38 | Ortiz, David | Democratic | 29.99 | 9/30/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
9490 | 9490 | House District 38 | Ortiz, David | Democratic | 29.99 | 11/2/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
9533 | 9533 | House District 38 | Ortiz, David | Democratic | 30.99 | 11/30/20 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | |
11066 | 11066 | House District 44 | Storojev, Kyra | Democratic | 49.95 | 5/1/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | 5 Months Of Mailchimp At $9.99 A Month. E-Mail Software |
11079 | 11079 | House District 44 | Storojev, Kyra | Democratic | 9.99 | 5/24/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Mail Chimp Online Email System 1 Month, Order Mc10719913 |
11085 | 11085 | House District 44 | Storojev, Kyra | Democratic | 9.99 | 6/4/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | June Mailchimp (Software) Charge |
11180 | 11180 | House District 44 | Storojev, Kyra | Democratic | 9.99 | 9/25/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | E-Mail System Monthly Charge |
11237 | 11237 | House District 44 | Storojev, Kyra | Democratic | 9.99 | 12/25/19 0:00 | Mailchimp | Atlanta | GA | 30308 | Advertising | Mailchimp |
14408 | 14408 | House District 61 | Mccluskie, Julie | Democratic | 30.0 | 1/2/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Monthly Account Payment |
14412 | 14412 | House District 61 | Mccluskie, Julie | Democratic | 30.0 | 2/2/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Monthly Mailchimp |
14414 | 14414 | House District 61 | Mccluskie, Julie | Democratic | 30.0 | 3/2/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | March Charge |
14439 | 14439 | House District 61 | Mccluskie, Julie | Democratic | 30.0 | 7/3/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Mailchimp |
14447 | 14447 | House District 61 | Mccluskie, Julie | Democratic | 30.0 | 8/5/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Mailchimp |
14450 | 14450 | House District 61 | Mccluskie, Julie | Democratic | 30.0 | 9/3/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Mailchimp |
14454 | 14454 | House District 61 | Mccluskie, Julie | Democratic | 30.0 | 12/2/18 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Mailchimp Monhtly Charge |
14466 | 14466 | House District 61 | Mccluskie, Julie | Democratic | 34.99 | 1/3/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
14469 | 14469 | House District 61 | Mccluskie, Julie | Democratic | 34.99 | 2/3/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
14475 | 14475 | House District 61 | Mccluskie, Julie | Democratic | 34.99 | 3/3/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
14485 | 14485 | House District 61 | Mccluskie, Julie | Democratic | 34.99 | 4/3/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | |
14504 | 14504 | House District 61 | Mccluskie, Julie | Democratic | 31.49 | 7/3/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Mail Chimp |
14522 | 14522 | House District 61 | Mccluskie, Julie | Democratic | 31.49 | 8/3/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | .Mail Chimp Monthly Fee |
14538 | 14538 | House District 61 | Mccluskie, Julie | Democratic | 34.99 | 9/3/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Monthly Mailchimp Fee |
14552 | 14552 | House District 61 | Mccluskie, Julie | Democratic | 34.99 | 10/3/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Mailchimp Monthly Fee |
14556 | 14556 | House District 61 | Mccluskie, Julie | Democratic | 34.99 | 10/5/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Monthly Fee |
14591 | 14591 | House District 61 | Mccluskie, Julie | Democratic | 34.99 | 11/3/20 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Mailchimp Monthly Fee |
14593 | 14593 | House District 61 | Mccluskie, Julie | Democratic | 34.99 | 11/4/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Mailchimp Monthly Fee |
14608 | 14608 | House District 61 | Mccluskie, Julie | Democratic | 34.99 | 12/3/19 0:00 | Mail Chimp | Atlanta | GA | 30308 | Advertising | Mailchimp Monthly Fee |
204 | 204 | House District 01 | Koch, Samantha | Republican | 1587.5 | 9/8/20 0:00 | Salem Media | Aurora | CO | 80114 | Advertising | Digital Advertising Campaign - Salem Mediasubtotal: $1587.50Tax: $0.00Shipping: $0.00Total: $1587.50 Kbjd-Am--Knus-Krks-Am- |
206 | 206 | House District 01 | Koch, Samantha | Republican | 1200.0 | 9/25/20 0:00 | Trey Taylor | Aurora | CO | 80113 | Advertising | Deposit For Fundraising Event On 10/12 With Country Artist. |
210 | 210 | House District 01 | Koch, Samantha | Republican | 1412.5 | 10/19/20 0:00 | Salem Media | Aurora | CO | 80114 | Advertising | Campaign Digital Advertising With Salem Media |
1222 | 1222 | House District 06 | Himelspach, Daniel | Democratic | 165.0 | 6/20/20 0:00 | Eduardo Aguilar | Aurora | CO | 80012 | Advertising | Voter Outreach |
1233 | 1233 | House District 06 | Himelspach, Daniel | Democratic | 255.0 | 6/29/20 0:00 | Eduardo Aguilar | Aurora | CO | 80012 | Advertising | Voter Outreach |
3637 | 3637 | House District 17 | Exum Sr, Thomas | Democratic | 350.0 | 10/8/20 0:00 | Bizzy Bee Enterprise | Aurora | CO | 80041 | Advertising | Newspaper Ads |
5051 | 5051 | House District 23 | Clifford, Fred | Republican | 5775.0 | 10/12/20 0:00 | Salem Surround Salem Media Of Colorado, Inc | Aurora | CO | 80014 | Advertising | Digital Banner Ad Marketting |
5054 | 5054 | House District 23 | Clifford, Fred | Republican | 2000.0 | 11/8/20 0:00 | Salem Surround Salem Media Of Colorado, Inc | Aurora | CO | 80014 | Advertising | Salem Surround Digital Marketing Purchased 10/25/2020 |
5055 | 5055 | House District 23 | Clifford, Fred | Republican | 1200.0 | 11/30/20 0:00 | Salem Surround Salem Media Of Colorado, Inc | Aurora | CO | 80014 | Advertising | Invoice For Electronic Electioneering Prior To The Election. |
5103 | 5103 | House District 24 | Imer, Laurel | Republican | 976.5 | 9/23/20 0:00 | Royal Printing Solutions | Aurora | CO | 80011 | Advertising | Yard Signs |
8419 | 8419 | House District 36 | Bishop, Dustin | Republican | 1.82 | 3/14/20 0:00 | Arc Thrift Store | Aurora | CO | 80013 | Advertising | Corrugated Plastic Sign, And Business Cards For Advertisement |
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 );