ed_cand_exp
21 rows where expenditure_type = "Advertising" and state = "DC"
This data as json, CSV (advanced)
Suggested facets: district, candidate, expenditure_amount, expenditure_date, recipient, zip, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
461 | 461 | CU Regent District 02 | Rennison, Callie | Democratic | 30.0 | 1/16/20 0:00 | Action Network | Washington | DC | 20036 | Advertising | |
482 | 482 | CU Regent District 02 | Rennison, Callie | Democratic | 30.0 | 3/16/20 0:00 | Action Network | Washington | DC | 20036 | Advertising | |
513 | 513 | CU Regent District 02 | Rennison, Callie | Democratic | 17500.0 | 6/1/20 0:00 | Complete Digital Llc | Washington | DC | 20003 | Advertising | |
514 | 514 | CU Regent District 02 | Rennison, Callie | Democratic | -17500.0 | 6/1/20 0:00 | Complete Digital Llc | Washington | DC | 20003 | Advertising | Offset Due To Update Of Filed Item |
515 | 515 | CU Regent District 02 | Rennison, Callie | Democratic | 17500.0 | 6/1/20 0:00 | Complete Digital Llc | Washington | DC | 20003 | Advertising | Digital Advertising For Callie Rennison For Cu Regent |
530 | 530 | CU Regent District 02 | Rennison, Callie | Democratic | 12650.0 | 6/15/20 0:00 | Complete Digital Llc | Washington | DC | 20003 | Advertising | |
531 | 531 | CU Regent District 02 | Rennison, Callie | Democratic | -12650.0 | 6/15/20 0:00 | Complete Digital Llc | Washington | DC | 20003 | Advertising | Offset Due To Update Of Filed Item |
532 | 532 | CU Regent District 02 | Rennison, Callie | Democratic | 12650.0 | 6/15/20 0:00 | Complete Digital Llc | Washington | DC | 20003 | Advertising | Digital Ads For Callie Rennison For Cu Regent |
536 | 536 | CU Regent District 02 | Rennison, Callie | Democratic | 7000.0 | 6/22/20 0:00 | Complete Digital Llc | Washington | DC | 20003 | Advertising | |
537 | 537 | CU Regent District 02 | Rennison, Callie | Democratic | 1850.0 | 6/22/20 0:00 | Complete Digital Llc | Washington | DC | 20003 | Advertising | |
538 | 538 | CU Regent District 02 | Rennison, Callie | Democratic | -7000.0 | 6/22/20 0:00 | Complete Digital Llc | Washington | DC | 20003 | Advertising | Offset Due To Update Of Filed Item |
539 | 539 | CU Regent District 02 | Rennison, Callie | Democratic | 7000.0 | 6/22/20 0:00 | Complete Digital Llc | Washington | DC | 20003 | Advertising | Digital Advertising For Callie Rennison For Cu Regent |
540 | 540 | CU Regent District 02 | Rennison, Callie | Democratic | -1850.0 | 6/22/20 0:00 | Complete Digital Llc | Washington | DC | 20003 | Advertising | Offset Due To Update Of Filed Item |
541 | 541 | CU Regent District 02 | Rennison, Callie | Democratic | 1850.0 | 6/22/20 0:00 | Complete Digital Llc | Washington | DC | 20003 | Advertising | Digitial Advertising For Callie Rennison For Cu Regent |
829 | 829 | CU Regent District 06 | Spiegel, Ilana | Democratic | 30.0 | 9/3/19 0:00 | Ngp Van | Washington | DC | 20005 | Advertising | |
874 | 874 | CU Regent District 06 | Spiegel, Ilana | Democratic | 840.0 | 9/4/20 0:00 | Ngp Van | Washington | DC | 20005 | Advertising | |
881 | 881 | CU Regent District 06 | Spiegel, Ilana | Democratic | 210.0 | 9/26/20 0:00 | Ngp Van | Washington | DC | 20005 | Advertising | |
884 | 884 | CU Regent District 06 | Spiegel, Ilana | Democratic | 30.0 | 10/2/19 0:00 | Ngp Van | Washington | DC | 20005 | Advertising | |
887 | 887 | CU Regent District 06 | Spiegel, Ilana | Democratic | 84.0 | 10/7/20 0:00 | Ngp Van | Washington | DC | 20005 | Advertising | |
904 | 904 | CU Regent District 06 | Spiegel, Ilana | Democratic | 30.0 | 11/4/19 0:00 | Ngp Van | Washington | DC | 20005 | Advertising | |
912 | 912 | CU Regent District 06 | Spiegel, Ilana | Democratic | 30.0 | 12/2/19 0:00 | Ngp Van | Washington | DC | 20005 | Advertising |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "ed_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 );