house_cand_exp
5 rows where city = "Venlo"
This data as json, CSV (advanced)
Suggested facets: district, candidate, affiliation, expenditure_date, recipient, expenditure_type
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
11602 | 11602 | House District 46 | Ambler, Jonathan | Republican | 30.12 | 2/27/20 0:00 | Vistaprint Netherlands Bv | Venlo | TH | 5928LW | Advertising | Business Cards |
14839 | 14839 | House District 63 | Schneider, Geneiveve | Democratic | 134.99 | 6/27/20 0:00 | Vistaprint | Venlo | TH | 5928LW | Advertising | Leaflets |
14851 | 14851 | House District 63 | Schneider, Geneiveve | Democratic | 113.19 | 9/16/20 0:00 | Vistaprint | Venlo | TH | 5928LW | Advertising | Face Masks |
14852 | 14852 | House District 63 | Schneider, Geneiveve | Democratic | 113.96 | 9/16/20 0:00 | Vistaprint | Venlo | TH | 5928LW | Advertising | Flyers |
14862 | 14862 | House District 63 | Schneider, Geneiveve | Democratic | -113.19 | 10/13/20 0:00 | Vistaprint | Venlo | TH | 5928LW | Returned Expenditure | The Masks Were Wrong |
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 );