house_cand_exp
12 rows where city = "San Diego"
This data as json, CSV (advanced)
Suggested facets: district, candidate, affiliation, expenditure_date, recipient, zip, expenditure_type, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
741 | 741 | House District 04 | Gonzales-Gutierrez, Serena | Democratic | 11.98 | 8/5/19 0:00 | Ares Travel | San Diego | CA | 92106 | Travel & Lodging | |
1898 | 1898 | House District 08 | Herod, Leslie | Democratic | 22.3 | 7/16/19 0:00 | The Lafayette Hotel | San Diego | CA | 92104 | Travel & Lodging | |
4889 | 4889 | House District 23 | Kennedy, Chris | Democratic | 73.08 | 8/24/20 0:00 | Pro Flowers | San Diego | CA | 92121 | Gifts | Gifts |
9813 | 9813 | House District 39 | Baisley, Mark | Republican | 19.0 | 11/19/19 0:00 | Ace Parking | San Diego | CA | 92108 | Travel & Lodging | Parking Travel Expense, Excelined Education Summit |
9814 | 9814 | House District 39 | Baisley, Mark | Republican | 62.58 | 11/19/19 0:00 | The Fish Market | San Diego | CA | 92101 | Food, Beverages and Meals | Travel Expense, Excelined Education Summit |
9815 | 9815 | House District 39 | Baisley, Mark | Republican | 336.41 | 11/19/19 0:00 | National Car Rental | San Diego | CA | 92101 | Travel & Lodging | Travel Expense, Excelined Education Summit |
9816 | 9816 | House District 39 | Baisley, Mark | Republican | 71.42 | 11/20/19 0:00 | Lou & Mickey'S | San Diego | CA | 92101 | Food, Beverages and Meals | Travel Expense, Excelined Education Summit |
9817 | 9817 | House District 39 | Baisley, Mark | Republican | 36.0 | 11/21/19 0:00 | Ace Parking | San Diego | CA | 92108 | Travel & Lodging | Travel Expense, Excelined Education Summit |
9818 | 9818 | House District 39 | Baisley, Mark | Republican | 100.89 | 11/21/19 0:00 | Hilton Hotel | San Diego | CA | 92101 | Travel & Lodging | Travel Expense, Excelined Education Summit |
9823 | 9823 | House District 39 | Baisley, Mark | Republican | 7.31 | 11/28/19 0:00 | National Car Rental | San Diego | CA | 92101 | Travel & Lodging | Travel Expense, Excelined Education Summit (Fee For Toll) |
9828 | 9828 | House District 39 | Baisley, Mark | Republican | 4.23 | 12/17/19 0:00 | National Car Rental | San Diego | CA | 92101 | Travel & Lodging | Travel Expense, Excelined Education Summit (Fee For Toll) |
14023 | 14023 | House District 58 | Cagin, Seth | Democratic | 99.0 | 4/3/20 0:00 | Blue Sky Network | San Diego | CA | 92108 | Advertising | Website Tech Support |
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 );