ed_cand_exp
6 rows where expenditure_date = "6/22/20 0:00" and state = "DC"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 );