ed_cand_exp
10 rows where candidate = "Spiegel, Ilana" and state = "DC"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_type
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
820 | 820 | CU Regent District 06 | Spiegel, Ilana | Democratic | 30.0 | 6/26/19 0:00 | Ngp Van | Washington | DC | 20005 | Other | Voter Files |
826 | 826 | CU Regent District 06 | Spiegel, Ilana | Democratic | 30.0 | 8/2/19 0:00 | Ngp Van | Washington | DC | 20005 | Consultant & Professional Services | Ngp Van |
829 | 829 | CU Regent District 06 | Spiegel, Ilana | Democratic | 30.0 | 9/3/19 0:00 | Ngp Van | Washington | DC | 20005 | Advertising | |
843 | 843 | CU Regent District 06 | Spiegel, Ilana | Democratic | 8.4 | 4/3/20 0:00 | Ngp Van | Washington | DC | 20005 | Consultant & Professional Services | |
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 );