state_exp
36 rows where expenditure_type = "Advertising" and state = "DC"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, expenditure_date, recipient, zip, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1039 | 1039 | STATE BD. OF ED. AT LARGE | Kathy Plomer | Democratic | 23500.0 | 9/30/22 | Compete Digital Llc | Washington | DC | 20003 | Advertising | Digital Advertising Services Between 10/10/22 And 11/08/22- $23,500 |
1046 | 1046 | STATE BD. OF ED. AT LARGE | Kathy Plomer | Democratic | 5000.0 | 10/6/22 | Compete Digital Llc | Washington | DC | 20003 | Advertising | Digital Advertising Services Between 10/10/22 And 11/08/22 |
1055 | 1055 | STATE BD. OF ED. AT LARGE | Kathy Plomer | Democratic | 45000.0 | 10/17/22 | Compete Digital Llc | Washington | DC | 20003 | Advertising | Setup Fee - 1,500 Persuation Placement - 37,286 Ad Placement Fee - 5,674 |
1063 | 1063 | STATE BD. OF ED. AT LARGE | Kathy Plomer | Democratic | 7000.0 | 10/31/22 | Compete Digital Llc | Washington | DC | 20003 | Advertising | Internet Campaign Ads 10/30/22 Through 11/08/22 |
5510 | 5510 | Governor | Jared Polis | Democratic | 29856.06 | 3/16/22 | Three Point Media | Washington | DC | 20007 | Advertising | Production |
5740 | 5740 | Governor | Jared Polis | Democratic | 4761.9 | 6/1/22 | Ascend Digital Services | Washington | DC | 20001 | Advertising | Facebook Ads |
5743 | 5743 | Governor | Jared Polis | Democratic | 150.0 | 6/1/22 | Ascend Digital Services | Washington | DC | 20001 | Advertising | Facebook Ads |
5796 | 5796 | Governor | Jared Polis | Democratic | 15993.0 | 6/15/22 | Precision Strategies Llc | Washington | DC | 20001 | Advertising | Digital Ads |
5869 | 5869 | Governor | Jared Polis | Democratic | 5000.0 | 7/1/22 | Precision Strategies Llc | Washington | DC | 20001 | Advertising | Digital Ads |
5948 | 5948 | Governor | Jared Polis | Democratic | 9760.0 | 7/22/22 | Precision Strategies Llc | Washington | DC | 20001 | Advertising | Digital Ads |
6035 | 6035 | Governor | Jared Polis | Democratic | 10000.0 | 8/11/22 | Precision Strategies Llc | Washington | DC | 20001 | Advertising | Digital Advertising |
6047 | 6047 | Governor | Jared Polis | Democratic | 113000.0 | 8/15/22 | Precision Strategies Llc | Washington | DC | 20001 | Advertising | Digital Advertising |
6069 | 6069 | Governor | Jared Polis | Democratic | 274671.66 | 8/19/22 | Three Point Media | Washington | DC | 20007 | Advertising | Production |
6118 | 6118 | Governor | Jared Polis | Democratic | 74.65 | 9/2/22 | Ascend Digital Services | Washington | DC | 20001 | Advertising | Website Hosting |
6230 | 6230 | Governor | Jared Polis | Democratic | 680600.0 | 9/27/22 | Precision Strategies Llc | Washington | DC | 20001 | Advertising | Digital Advertising |
6255 | 6255 | Governor | Jared Polis | Democratic | 777000.0 | 9/30/22 | Precision Strategies Llc | Washington | DC | 20001 | Advertising | Digital Advertising |
6264 | 6264 | Governor | Jared Polis | Democratic | 500.0 | 10/3/22 | Ascend Digital Services | Washington | DC | 20001 | Advertising | Facebook Ads |
6265 | 6265 | Governor | Jared Polis | Democratic | 966.68 | 10/3/22 | Ascend Digital Services | Washington | DC | 20001 | Advertising | Texting |
6331 | 6331 | Governor | Jared Polis | Democratic | 20000.0 | 10/14/21 | Ascend Digital Services | Washington | DC | 20001 | Advertising | Online Advertising |
6332 | 6332 | Governor | Jared Polis | Democratic | 32500.0 | 10/14/21 | Ascend Digital Services | Washington | DC | 20001 | Advertising | Data Acquisition |
6359 | 6359 | Governor | Jared Polis | Democratic | 47773.28 | 10/17/22 | Three Point Media | Washington | DC | 20007 | Advertising | Production |
6374 | 6374 | Governor | Jared Polis | Democratic | 1153.18 | 10/20/22 | Veracity Media | Washington | DC | 20002 | Advertising | Social Media Messaging Service |
6431 | 6431 | Governor | Jared Polis | Democratic | 151788.63 | 10/28/22 | Three Point Media | Washington | DC | 20007 | Advertising | Production |
6459 | 6459 | Governor | Jared Polis | Democratic | 3163.89 | 11/2/22 | Ascend Digital Services | Washington | DC | 20001 | Advertising | Texting |
6478 | 6478 | Governor | Jared Polis | Democratic | 5832.8 | 11/4/22 | Three Point Media | Washington | DC | 20007 | Advertising | Production |
6577 | 6577 | Governor | Jared Polis | Democratic | 20313.0 | 11/28/22 | Three Point Media | Washington | DC | 20007 | Advertising | Production |
6610 | 6610 | Governor | Jared Polis | Democratic | 1500.0 | 12/2/22 | Ascend Digital Services | Washington | DC | 20001 | Advertising | Facebook Ads |
6611 | 6611 | Governor | Jared Polis | Democratic | 176.49 | 12/2/22 | Ascend Digital Services | Washington | DC | 20001 | Advertising | Texting |
6813 | 6813 | Governor | Jared Polis | Democratic | 5000.0 | 5/23/19 | Precision Strategies Llc | Washington | DC | 20001 | Advertising | |
9512 | 9512 | Attorney General | Phil Weiser | Democratic | 15030.0 | 8/22/22 | Ascend Digital Strategies Llc | Washington | DC | 20001 | Advertising | Advertising |
9517 | 9517 | Attorney General | Phil Weiser | Democratic | 64745.0 | 8/30/22 | Putnam Partners, Llc | Washington | DC | 20005 | Advertising | Advertisement Costs |
9518 | 9518 | Attorney General | Phil Weiser | Democratic | 47480.0 | 8/30/22 | Putnam Partners, Llc | Washington | DC | 20005 | Advertising | Advertisement Costs |
9540 | 9540 | Attorney General | Phil Weiser | Democratic | 15000.0 | 9/23/22 | Ascend Digital Strategies Llc | Washington | DC | 20001 | Advertising | Advertising |
9603 | 9603 | Attorney General | Phil Weiser | Democratic | 7610.33 | 10/25/22 | Putnam Partners, Llc | Washington | DC | 20005 | Advertising | Advertisement Costs |
9654 | 9654 | Attorney General | Phil Weiser | Democratic | 21357.0 | 11/30/22 | Putnam Partners, Llc | Washington | DC | 20005 | Advertising | Advertising Costs |
9681 | 9681 | Attorney General | Phil Weiser | Democratic | 3800.0 | 1/25/19 | Putnam Partners, Llc | Washington | DC | 20005 | Advertising | Media Buy Commission - Digital |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_exp" ( "District" TEXT, "candidate_name" TEXT, "Party" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );