ed_cand_exp

10 rows where expenditure_type = "Travel & Lodging"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate, affiliation, recipient, city, zip

Link rowid ▼ district candidate affiliation expenditure_amount expenditure_date recipient city state zip expenditure_type explanation
229 229 Bd. Ed. District 03 Simpson, Mayling Democratic 31.37 9/18/20 0:00 Conoco Steamboat Springs CO 80487 Travel & Lodging  
230 230 Bd. Ed. District 03 Simpson, Mayling Democratic 92.8 9/20/20 0:00 Jack Dysart Steamboat Springs CO 80477-6149 Travel & Lodging Travel Reimbursement - Delivered Yard Signs To Grand Junction
233 233 Bd. Ed. District 03 Simpson, Mayling Democratic 5.0 9/21/20 0:00 Colorado Mesa University Grand Junction CO 81501 Travel & Lodging Parking Fee
241 241 Bd. Ed. District 03 Simpson, Mayling Democratic 194.0 10/4/20 0:00 Laura Baker Montrose CO 81401 Travel & Lodging Campaign Signs Delivery
274 274 Bd. Ed. District 03 Simpson, Mayling Democratic 500.0 10/28/20 0:00 Laura Baker Montrose CO 81401 Travel & Lodging Reimbursement To Laura For Mileage And Meals
291 291 Bd. Ed. District 03 Rankin, Joyce Republican 112.32 6/29/19 0:00 Joyce Rankin Carbondale CO 81623 Travel & Lodging Mileage To Meetings
326 326 Bd. Ed. District 03 Rankin, Joyce Republican 154.92 9/5/20 0:00 Fairfield Inn Alamosa CO 81101 Travel & Lodging  
327 327 Bd. Ed. District 03 Rankin, Joyce Republican 215.87 9/6/20 0:00 Courtyard By Marriott Pueblo CO 81003 Travel & Lodging  
328 328 Bd. Ed. District 03 Rankin, Joyce Republican 993.0 9/16/20 0:00 Joyce Rankin Carbondale CO 81623 Travel & Lodging Mileage
332 332 Bd. Ed. District 03 Rankin, Joyce Republican 272.25 10/15/20 0:00 Joyce Rankin Carbondale CO 81623 Travel & Lodging  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "ed_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
);