95 rows

View and edit SQL

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

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"	TEXT,
	"payment_date"	TEXT,
	"loan_balance"	REAL,
	"filed_date"	TEXT
);