state_exp
3 rows where candidate_name = "Kathy Plomer" and expenditure_type = "Travel & Lodging"
This data as json, CSV (advanced)
Suggested facets: state
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
998 | 998 | STATE BD. OF ED. AT LARGE | Kathy Plomer | Democratic | 235.92 | 6/21/22 | Hotwire | San Francisco | CA | 94105 | Travel & Lodging | Lodging In Grand Junction For Candidate & Campaign Staff On Education Road Tour |
1001 | 1001 | STATE BD. OF ED. AT LARGE | Kathy Plomer | Democratic | 209.12 | 6/23/22 | Quality Inn Durango | Durango | CO | 81301 | Travel & Lodging | Lodging During Voter Outreach Tour |
1050 | 1050 | STATE BD. OF ED. AT LARGE | Kathy Plomer | Democratic | 154.4 | 10/8/22 | The Windsor Hotel | Del Norte | CO | 81132 | Travel & Lodging |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_exp" ( "District" TEXT, "candidate_name" TEXT, "Party" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );