ed_cand_exp

24 rows where candidate = "Escarcega, Lisa" and city = "Denver"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: expenditure_amount, recipient, zip, expenditure_type, explanation

Link rowid ▼ district candidate affiliation expenditure_amount expenditure_date recipient city state zip expenditure_type explanation
3 3 Bd. Ed. District 01 Escarcega, Lisa Democratic 1000.0 1/9/20 0:00 Kristen Seidel Denver CO 80224 Consultant & Professional Services  
4 4 Bd. Ed. District 01 Escarcega, Lisa Democratic 1055.99 1/27/20 0:00 C&D Printing, Inc Denver CO 80212 Other Printing Services For Campaign Materials
6 6 Bd. Ed. District 01 Escarcega, Lisa Democratic 1500.0 2/7/20 0:00 Kristen Seidel Denver CO 80224 Consultant & Professional Services  
7 7 Bd. Ed. District 01 Escarcega, Lisa Democratic 1500.0 3/2/20 0:00 Kristen Seidel Denver CO 80224 Consultant & Professional Services  
11 11 Bd. Ed. District 01 Escarcega, Lisa Democratic 1560.0 4/3/20 0:00 Kristen Seidel Denver CO 80224 Consultant & Professional Services  
13 13 Bd. Ed. District 01 Escarcega, Lisa Democratic 60.0 4/8/20 0:00 Tay Anderson Denver CO 80205 Consultant & Professional Services  
14 14 Bd. Ed. District 01 Escarcega, Lisa Democratic 20.0 4/13/20 0:00 C&D Printing, Inc Denver CO 80212 Other Printing Services For Campaign Materials
15 15 Bd. Ed. District 01 Escarcega, Lisa Democratic 657.98 4/21/20 0:00 Kristen Seidel Denver CO 80224 Consultant & Professional Services  
16 16 Bd. Ed. District 01 Escarcega, Lisa Democratic 1643.53 4/27/20 0:00 C&D Printing, Inc Denver CO 80212 Other Printing Services
18 18 Bd. Ed. District 01 Escarcega, Lisa Democratic 1500.0 5/4/20 0:00 Kristen Seidel Denver CO 80224 Consultant & Professional Services  
24 24 Bd. Ed. District 01 Escarcega, Lisa Democratic 1500.0 6/1/20 0:00 Kristen Seidel Denver CO 80224 Consultant & Professional Services Consulting Services
30 30 Bd. Ed. District 01 Escarcega, Lisa Democratic 21.12 6/15/20 0:00 Colorado Democratic Party Denver CO 80203 Other Campaign Texts
32 32 Bd. Ed. District 01 Escarcega, Lisa Democratic 490.0 6/22/20 0:00 United States Post Office Denver CO 80217 Miscellaneous Postage Stamps
35 35 Bd. Ed. District 01 Escarcega, Lisa Democratic 480.0 6/24/20 0:00 Daniel Sarche Denver CO 80237 Other Canvasing/Literature Distribution
39 39 Bd. Ed. District 01 Escarcega, Lisa Democratic 1500.0 7/1/20 0:00 Kristen Seidel Denver CO 80224 Consultant & Professional Services  
43 43 Bd. Ed. District 01 Escarcega, Lisa Democratic 90.0 7/6/20 0:00 Daniel Sarche Denver CO 80237 Other Phone Banking
47 47 Bd. Ed. District 01 Escarcega, Lisa Democratic 500.0 8/3/20 0:00 Kristen Seidel Denver CO 80224 Consultant & Professional Services  
51 51 Bd. Ed. District 01 Escarcega, Lisa Democratic 500.0 9/4/20 0:00 Kristen Seidel Denver CO 80224 Consultant & Professional Services  
57 57 Bd. Ed. District 01 Escarcega, Lisa Democratic 750.0 10/1/20 0:00 Kristen Seidel Denver CO 80224 Consultant & Professional Services  
59 59 Bd. Ed. District 01 Escarcega, Lisa Democratic 78.56 10/23/19 0:00 C&D Printing, Inc Denver CO 80212 Other Printing Services
60 60 Bd. Ed. District 01 Escarcega, Lisa Democratic 500.0 10/25/19 0:00 Colorado Democratic Party Denver CO 80203 Other Van Access
63 63 Bd. Ed. District 01 Escarcega, Lisa Democratic 750.0 11/5/20 0:00 Kristen Seidel Denver CO 80224 Consultant & Professional Services  
64 64 Bd. Ed. District 01 Escarcega, Lisa Democratic 552.03 11/18/19 0:00 C&D Printing, Inc Denver CO 80212 Other Printing Brochures For Face-To-Face Distribution
65 65 Bd. Ed. District 01 Escarcega, Lisa Democratic 500.0 11/22/19 0:00 White River Strategies, Llc Denver CO 80204 Consultant & Professional Services Campaign Services

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
);