81 rows

View and edit SQL

Suggested facets: district, filed_date

Link rowid ▼ district candidate loan_amount loan_date payment_amount payment_date loan_balance filed_date
1 ACADEMY 20 SALT, AARON 1500.0 8/31/21     1500.0 9/4/21
2 COLORADO SPRINGS 11 BANKES, SANDRA 1000.0 5/5/21     1000.0 6/1/21
3 WOODLAND PARK RE-2 PATTERSON, SUZANNE 1500.0 6/30/21     1500.0 7/30/21
4 WOODLAND PARK RE-2 PATTERSON, SUZANNE 200.0 7/28/21     200.0 7/30/21
5 WOODLAND PARK RE-2 PATTERSON, SUZANNE 500.0 8/23/21     500.0 9/3/21
6 WOODLAND PARK RE-2 PATTERSON, SUZANNE 100.0 8/31/21     100.0 9/3/21
7 WOODLAND PARK RE-2 PATTERSON, SUZANNE 300.0 9/1/21     300.0 9/3/21
8 WOODLAND PARK RE-2 PATTERSON, SUZANNE 1150.0 9/7/21     1150.0 9/16/21
9 ADAMS-ARAPAHOE 28J IVEY, MARQUES 100.0 8/31/21     100.0 9/6/21
10 ADAMS-ARAPAHOE 28J IVEY, MARQUES -100.0 8/31/21     -100.0 10/4/21
11 ADAMS-ARAPAHOE 28J IVEY, MARQUES 100.0 9/6/21     100.0 9/21/21
12 ADAMS-ARAPAHOE 28J IVEY, MARQUES -100.0 9/6/21     -100.0 10/4/21
13 BRIGHTON 27J THORNTON, ARVIN 3500.0 7/13/21     3500.0 7/29/21
14 MESA COUNTY VALLEY 51 HAITZ, ANDREA 1000.0 6/21/21     1000.0 9/18/21
15 ACADEMY 20 LAVALLEY, THOMAS 10000.0 6/23/21     10000.0 7/28/21
16 ACADEMY 20 LAVALLEY, THOMAS 5000.0 9/1/21     5000.0 9/2/21
17 MESA COUNTY VALLEY 51 LEMA, ANGELA 1000.0 6/24/21     1000.0 7/1/21
18 GREELEY 6 CALDERON, ARACELI 1611.57 8/23/21     1611.57 9/3/21
19 GREELEY 6 CALDERON, ARACELI -1611.57 8/23/21     -1611.57 9/17/21
20 GREELEY 6 CALDERON, ARACELI 1611.57 8/23/21 1611.57 8/30/21 1611.57 9/3/21
21 GREELEY 6 CALDERON, ARACELI 1611.57 8/23/21 -1611.57 8/30/21 1611.57 9/17/21
22 MESA COUNTY VALLEY 51 COMBS, DAVID 1000.0 8/3/21     1000.0 9/7/21
23 BOULDER VALLEY RE 2 BUCHER, DEANN 1350.0 7/27/21     0.0 8/1/21
24 BOULDER VALLEY RE 2 BUCHER, DEANN 1350.0 7/27/21 800.0 9/25/21 0.0 10/5/21
25 BOULDER VALLEY RE 2 BUCHER, DEANN 1350.0 7/27/21 550.0 10/16/21 0.0 10/18/21
26 CHERRY CREEK 5 GIBBONS, JENNIFER 1000.0 8/16/21     1000.0 9/6/21
27 POUDRE R-1 BROKISH, JIM 500.0 8/18/21     500.0 9/6/21
28 POUDRE R-1 BROKISH, JIM 1500.0 9/29/21     1500.0 10/4/21
29 COLORADO SPRINGS 11 WALLIS, CHRIS 10000.0 10/2/21     10000.0 10/18/21
30 DOUGLAS COUNTY RE 1 LEUNG, KEVIN 20000.0 9/30/21     20000.0 10/18/21
31 POUDRE R-1 GAITER, JEANNETTE 1000.0 8/11/21     1000.0 9/3/21
32 ENGLEWOOD 1 HOAG, JULIE 240.0 9/22/21     240.0 9/29/21
33 POUDRE R-1 REED, CAROLYN 2000.0 9/17/21     2000.0 10/5/21
34 LITTLETON 6 ANDERSSEN, JOAN 183.9 8/28/21     183.9 9/19/21
35 LITTLETON 6 ANDERSSEN, JOAN 9.6 9/3/21     9.6 9/19/21
36 LITTLETON 6 ANDERSSEN, JOAN 900.0 9/14/21     900.0 10/18/21
37 LITTLETON 6 ANDERSSEN, JOAN 1450.0 9/17/21     1450.0 10/18/21
38 LITTLETON 6 ANDERSSEN, JOAN 5.0 9/18/21     5.0 10/5/21
39 LITTLETON 6 ANDERSSEN, JOAN 2490.98 9/28/21     2490.98 10/5/21
40 ST. VRAIN VALLEY RE 1J GEARHART, TYLER 2005.0 8/24/21     2005.0 9/7/21
41 ST. VRAIN VALLEY RE 1J GEARHART, TYLER -2005.0 8/24/21     -2005.0 10/18/21
42 ST. VRAIN VALLEY RE 1J GEARHART, TYLER 88.51 8/24/21     0.0 10/18/21
43 ST. VRAIN VALLEY RE 1J GEARHART, TYLER 88.51 8/24/21 88.51 10/18/21 0.0 10/18/21
44 DOUGLAS COUNTY RE 1 WATKINS, JULI 500.0 9/1/21     500.0 9/8/21
45 DOUGLAS COUNTY RE 1 WATKINS, JULI -500.0 9/1/21     -500.0 9/20/21
46 DOUGLAS COUNTY RE 1 WATKINS, JULI 500.0 9/1/21     500.0 9/20/21
47 THOMPSON R2-J LESSEM, ALEXANDRA 200.0 8/23/21     0.0 9/3/21
48 THOMPSON R2-J LESSEM, ALEXANDRA 200.0 8/23/21 160.0 9/10/21 0.0 9/17/21
49 THOMPSON R2-J LESSEM, ALEXANDRA 200.0 8/23/21 40.0 9/10/21 0.0 9/17/21
50 ASPEN 1 ZANE, ANNA 1000.0 8/27/21     1000.0 9/19/21
51 PARK (ESTES PARK) R-3 MAUERMAN, MARGARET 1000.0 8/26/21     1000.0 9/3/21
52 THOMPSON R2-J RUMFELT, NANCY 1000.0 8/31/21     500.0 9/3/21
53 THOMPSON R2-J RUMFELT, NANCY 1000.0 8/31/21 500.0 10/13/21 500.0 10/17/21
54 WOODLAND PARK RE-2 BROVETTO, GARY 20.0 9/2/21     20.0 9/15/21
55 WOODLAND PARK RE-2 BROVETTO, GARY 25.0 9/2/21     25.0 9/15/21
56 WOODLAND PARK RE-2 BROVETTO, GARY 27.29 9/9/21     27.29 9/15/21
57 PARK (ESTES PARK) R-3 WOLF, DANIELLE 250.0 8/27/21     250.0 9/6/21
58 PARK (ESTES PARK) R-3 WOLF, DANIELLE 250.0 9/10/21     250.0 9/20/21
59 PARK (ESTES PARK) R-3 WOLF, DANIELLE 250.0 10/4/21     250.0 10/16/21
60 POUDRE R-1 ZAMORA, JESSICA 800.0 9/1/21     800.0 9/6/21
61 POUDRE R-1 ZAMORA, JESSICA 800.0 9/13/21     800.0 9/20/21
62 SUMMIT RE-1 HUDNUT, KATHERINE 500.0 9/15/21     500.0 9/20/21
63 DURANGO 9-R PETERSEN, RICHARD 1000.0 9/6/21     0.0 9/16/21
64 DURANGO 9-R PETERSEN, RICHARD 1000.0 9/6/21 250.0 9/17/21 0.0 9/30/21
65 DURANGO 9-R PETERSEN, RICHARD 1000.0 9/6/21 750.0 10/9/21 0.0 10/18/21
66 ASPEN 1 WEISS, STACEY 500.0 8/31/21     500.0 9/4/21
67 BRIGHTON 27J BEACH, RENE 100.0 9/1/21     100.0 9/6/21
68 PARK (ESTES PARK) R-3 CABRERA, COURTNEY 100.0 8/27/21     100.0 9/17/21
69 PARK (ESTES PARK) R-3 CABRERA, COURTNEY 350.0 9/9/21     350.0 9/17/21
70 PARK (ESTES PARK) R-3 CABRERA, COURTNEY 350.0 9/17/21     350.0 10/3/21
71 FALCON 49 HARRIS, ELMER 533.18 9/21/21     533.18 10/18/21
72 GREELEY 6 SULLIVAN, TAYLOR 2441.84 9/29/21     2441.84 10/5/21
73 ST. VRAIN VALLEY RE 1J ABSHIER, NATALIE 3288.62 9/17/21     3288.62 10/6/21
74 RIDGWAY R-2 HEPP, JILL 400.0 9/28/21     400.0 9/29/21
75 RIDGWAY R-2 HEPP, JILL 100.0 10/1/21     100.0 10/14/21
76 FALCON 49 CRUSON, DAVE 5000.0 9/15/21     5000.0 9/20/21
77 FALCON 49 CRUSON, DAVE 750.0 9/22/21     750.0 10/5/21
78 EATON RE-2 OATMAN, JEFFREY 300.0 9/27/21     300.0 10/4/21
79 EATON RE-2 OATMAN, JEFFREY 400.0 10/11/21     400.0 10/17/21
80 PUEBLO COUNTY 70 WILSON, DR. AARON (A.J.) 300.0 10/1/21     300.0 10/15/21
81 WIDEFIELD 3 FISHER, GREG 350.0 9/28/21     350.0 10/4/21

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "school_board_loans" (
"district" TEXT,
  "candidate" TEXT,
  "loan_amount" REAL,
  "loan_date" TEXT,
  "payment_amount" REAL,
  "payment_date" TEXT,
  "loan_balance" REAL,
  "filed_date" TEXT
);