house_cand_exp
7 rows where expenditure_type = "Rent & Utilities" and state = "NY"
This data as json, CSV (advanced)
Suggested facets: district, candidate, affiliation, expenditure_amount, recipient, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
975 | 975 | House District 05 | Woodley, Jonathan | Republican | 50.0 | 10/26/20 0:00 | Starry | New York | NY | 10038 | Rent & Utilities | Internet |
3353 | 3353 | House District 16 | Vigil, Stephanie | Democratic | 60.0 | 4/2/20 0:00 | Wix.Com | New York | NY | 10011 | Rent & Utilities | Web Domain |
5981 | 5981 | House District 25 | Cutter, Lisa | Democratic | 59.97 | 8/27/20 0:00 | Squarespace, Inc | New York | NY | 10013 | Rent & Utilities | Website Development |
6486 | 6486 | House District 27 | Titone, Brianna | Democratic | 20.0 | 7/30/19 0:00 | Squarespace Inc | New York | NY | 10014 | Rent & Utilities | Web Services |
6490 | 6490 | House District 27 | Titone, Brianna | Democratic | 216.0 | 8/14/19 0:00 | Squarespace Inc | New York | NY | 10014 | Rent & Utilities | Squarespace Web Services |
6601 | 6601 | House District 27 | Titone, Brianna | Democratic | 216.0 | 8/17/20 0:00 | Squarespace Inc | New York | NY | 10014 | Rent & Utilities | Website |
6605 | 6605 | House District 27 | Titone, Brianna | Democratic | 52.44 | 8/19/20 0:00 | Beenverified.Com | New York | NY | 10018 | Rent & Utilities | Webservice |
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 );