house_cand_exp
6 rows where expenditure_type = "Travel & Lodging" and state = "DC"
This data as json, CSV (advanced)
Suggested facets: district, candidate, recipient, city, zip, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
87 | 87 | House District 01 | Lontine, Susan | Democratic | 450.72 | 12/10/18 0:00 | Hyattregency Hotel | Washington | DC | 20001 | Travel & Lodging | Conference Ncls |
475 | 475 | House District 02 | Garnett, Alec | Democratic | 228.75 | 12/16/19 0:00 | Mandarin | Washington | DC | 20024 | Travel & Lodging | |
1958 | 1958 | House District 08 | Herod, Leslie | Democratic | 99.0 | 2/18/20 0:00 | Aipac | Washington | DC | 20001 | Travel & Lodging | Conference Registration Fee |
10549 | 10549 | House District 42 | Jackson, Dominique | Democratic | 76.98 | 12/4/18 0:00 | Uvc | Washington | DC | 20018 | Travel & Lodging | Cab To Dulles |
11464 | 11464 | House District 46 | Esgar, Daneya | Democratic | 50.41 | 9/25/19 0:00 | Uber | Washington Dc | DC | Travel & Lodging | Uber In Dc | |
11468 | 11468 | House District 46 | Esgar, Daneya | Democratic | 41.41 | 9/26/19 0:00 | Uber | Washington Dc | DC | Travel & Lodging | Uber In Dc |
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 );