senate_cand_exp
7 rows where expenditure_type = "Consultant & Professional Services" and state = "VA"
This data as json, CSV (advanced)
Suggested facets: district, candidate, affiliation, expenditure_date, recipient, city, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2069 | 2069 | Senate District 19 | Gerber, Lynn | Republican | 71.4 | 3/9/20 0:00 | Siteground | Alexandria | VA | 22314 | Consultant & Professional Services | |
3859 | 3859 | Senate District 23 | Boccella, Sally | Democratic | 7225.0 | 10/9/20 0:00 | Superior Blue | Woodbridge | VA | 22192 | Consultant & Professional Services | |
3861 | 3861 | Senate District 23 | Boccella, Sally | Democratic | -7225.0 | 10/9/20 0:00 | Superior Blue | Woodbridge | VA | 22192 | Consultant & Professional Services | Offset Due To Deletion Of Filed Item |
4892 | 4892 | Senate District 27 | Kolker, Chris | Democratic | 700.0 | 2/7/20 0:00 | Superior Blue Strategies | Alexandria | VA | 22309 | Consultant & Professional Services | |
4904 | 4904 | Senate District 27 | Kolker, Chris | Democratic | 425.0 | 3/25/20 0:00 | Superior Blue Strategies | Alexandria | VA | 22309 | Consultant & Professional Services | |
6005 | 6005 | Senate District 31 | Orms, Maria | Democratic | 250.0 | 2/11/20 0:00 | Derek Toro | Henrico | VA | 23294 | Consultant & Professional Services | |
6188 | 6188 | Senate District 33 | Coleman, James | Democratic | 956.5 | 2/3/20 0:00 | Brighter Day Strategies | Falls Church | VA | 22042 | Consultant & Professional Services |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_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 );