house_cand_exp
6 rows where expenditure_type = "Consultant & Professional Services" and state = "VA"
This data as json, CSV (advanced)
Suggested facets: district, candidate, recipient, city, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2781 | 2781 | House District 12 | Bernett, Tracey | Democratic | 1500.0 | 1/15/20 0:00 | Superior Blue Strategies | Alexandria | VA | 22309 | Consultant & Professional Services | |
2789 | 2789 | House District 12 | Bernett, Tracey | Democratic | 250.0 | 1/22/20 0:00 | Superior Blue Strategies | Alexandria | VA | 22309 | Consultant & Professional Services | |
2837 | 2837 | House District 12 | Bernett, Tracey | Democratic | 1803.0 | 3/18/20 0:00 | Superior Blue Strategies | Alexandria | VA | 22309 | Consultant & Professional Services | |
6641 | 6641 | House District 27 | Titone, Brianna | Democratic | 17783.0 | 10/8/20 0:00 | Superior Blue | Woodbridge | VA | 22192 | Consultant & Professional Services | Mail Program Part 2 |
6664 | 6664 | House District 27 | Titone, Brianna | Democratic | 7625.79 | 10/16/20 0:00 | Superior Blue | Woodbridge | VA | 22192 | Consultant & Professional Services | Mail Program |
8247 | 8247 | House District 35 | Bird, Shannon | Democratic | 750.0 | 10/1/20 0:00 | Superior Blue | Woodbridge | VA | 22192 | Consultant & Professional Services | Photographer Fee For Photo Shoot. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_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 );