278 rows sorted by loan_balance

View and edit SQL

Suggested facets: affiliation

Link rowid district candidate affiliation loan_amount loan_date payment_amount payment_date loan_balance ▼ filed_date
86 House District 15 Williams, Dave Republican -25000.0 9/30/19 0:00     -25000.0 5/14/20 0:00
44 House District 06 Himelspach, Daniel Democratic -15000.0 1/2/20 0:00     -15000.0 10/28/20 0:00
46 House District 06 Himelspach, Daniel Democratic -10000.0 2/27/20 0:00     -10000.0 10/28/20 0:00
240 House District 48 Van Beber, Tonya Republican -7000.0 2/28/20 0:00     -7000.0 5/20/20 0:00
54 House District 06 Himelspach, Daniel Democratic -5200.0 7/16/20 0:00     -5200.0 10/28/20 0:00
24 Senate District 31 Townsend, Doug Republican -5000.0 10/1/20 0:00     -5000.0 12/1/20 0:00
48 House District 06 Himelspach, Daniel Democratic -5000.0 6/2/20 0:00     -5000.0 10/28/20 0:00
186 House District 38 Champion, Richard Republican -5000.0 2/24/20 0:00     -5000.0 11/28/20 0:00
195 House District 38 Champion, Richard Republican -5000.0 5/27/20 0:00     -5000.0 11/28/20 0:00
50 House District 06 Himelspach, Daniel Democratic -4000.0 6/13/20 0:00     -4000.0 10/28/20 0:00
237 House District 48 Van Beber, Tonya Republican -3900.0 2/24/20 0:00     -3900.0 5/20/20 0:00
16 Senate District 23 Siergiejczyk-Nicoll, Galina Democratic -3000.0 2/10/20 0:00     -3000.0 9/21/20 0:00
19 Senate District 23 Siergiejczyk-Nicoll, Galina Democratic -3000.0 4/28/20 0:00     -3000.0 5/18/20 0:00
164 House District 30 Sarmiento, Cynthia Republican -3000.0 2/1/20 0:00     -3000.0 9/16/20 0:00
166 House District 30 Sarmiento, Cynthia Republican -3000.0 2/1/20 0:00     -3000.0 9/16/20 0:00
189 House District 38 Champion, Richard Republican -2500.0 3/30/20 0:00     -2500.0 11/28/20 0:00
223 House District 45 Barrett, Katie Democratic -2500.0 6/4/19 0:00     -2500.0 8/1/20 0:00
67 House District 10 Stickney, Kenneth Republican -2000.0 9/22/20 0:00     -2000.0 11/28/20 0:00
272 House District 63 Miller, Patricia Republican -2000.0 6/11/20 0:00     -2000.0 8/30/20 0:00
176 House District 32 Caputo, Anthony Republican -1500.0 10/6/20 0:00     -1500.0 12/1/20 0:00
178 House District 32 Caputo, Anthony Republican -1500.0 10/11/20 0:00     -1500.0 12/1/20 0:00
14 Senate District 23 Siergiejczyk-Nicoll, Galina Democratic -1000.0 2/10/20 0:00     -1000.0 5/18/20 0:00
20 Senate District 23 Siergiejczyk-Nicoll, Galina Democratic -1000.0 4/28/20 0:00     -1000.0 9/21/20 0:00
52 House District 06 Himelspach, Daniel Democratic -1000.0 7/10/20 0:00     -1000.0 10/28/20 0:00
64 House District 10 Stickney, Kenneth Republican -1000.0 9/17/20 0:00     -1000.0 11/28/20 0:00
191 House District 38 Champion, Richard Republican -1000.0 4/29/20 0:00     -1000.0 11/28/20 0:00
193 House District 38 Champion, Richard Republican -1000.0 5/8/20 0:00     -1000.0 11/28/20 0:00
143 House District 23 Clifford, Fred Republican -800.01 3/11/20 0:00     -800.01 12/1/20 0:00
220 House District 45 Barrett, Katie Democratic 2000.0 2/20/20 0:00     -500.0 5/4/20 0:00
221 House District 45 Barrett, Katie Democratic 2000.0 2/20/20 0:00 500.0 5/15/20 0:00 -500.0 5/28/20 0:00
222 House District 45 Barrett, Katie Democratic 2000.0 2/20/20 0:00 500.0 5/15/20 0:00 -500.0 5/28/20 0:00
225 House District 45 Barrett, Katie Democratic 2000.0 2/20/20 0:00 500.0 6/24/20 0:00 -500.0 6/24/20 0:00
226 House District 45 Barrett, Katie Democratic 2000.0 2/20/20 0:00 500.0 7/12/20 0:00 -500.0 8/1/20 0:00
227 House District 45 Barrett, Katie Democratic 2000.0 2/20/20 0:00 500.0 9/8/20 0:00 -500.0 9/21/20 0:00
198 House District 39 Baisley, Mark Republican -400.0 4/4/18 0:00     -400.0 4/13/19 0:00
145 House District 23 Clifford, Fred Republican -204.0 3/19/20 0:00     -204.0 12/1/20 0:00
181 House District 33 Quiachon, Mindy Republican -150.0 5/14/20 0:00     -150.0 11/24/20 0:00
182 House District 33 Quiachon, Mindy Republican -133.99 5/14/20 0:00     -133.99 11/24/20 0:00
139 House District 23 Clifford, Fred Republican -57.0 2/25/20 0:00     -57.0 12/1/20 0:00
141 House District 23 Clifford, Fred Republican -17.44 2/29/20 0:00     -17.44 12/1/20 0:00
150 House District 23 Clifford, Fred Republican -17.18 3/23/20 0:00     -17.18 12/1/20 0:00
148 House District 23 Clifford, Fred Republican -10.0 3/20/20 0:00     -10.0 12/1/20 0:00
2 Senate District 08 Irvine, Debra Republican 2000.0 12/6/18 0:00 2000.0 7/13/20 0:00 0.0 8/2/20 0:00
7 Senate District 14 Hochheimer, Hans Republican 2000.0 3/5/20 0:00     0.0 11/30/20 0:00
8 Senate District 14 Hochheimer, Hans Republican 2000.0 3/5/20 0:00 2000.0 11/7/20 0:00 0.0 11/30/20 0:00
11 Senate District 23 Kirkmeyer, Barbara Republican 2500.0 8/21/20 0:00     0.0 9/8/20 0:00
12 Senate District 23 Kirkmeyer, Barbara Republican 2500.0 8/21/20 0:00 2500.0 11/24/20 0:00 0.0 12/3/20 0:00
21 Senate District 25 Dickerson, Paula Democratic 1500.0 3/5/20 0:00     0.0 4/29/20 0:00
22 Senate District 25 Dickerson, Paula Democratic 1500.0 3/5/20 0:00 1500.0 10/22/20 0:00 0.0 11/2/20 0:00
25 Senate District 31 Townsend, Doug Republican 600.17 10/1/20 0:00     0.0 12/1/20 0:00
26 Senate District 31 Townsend, Doug Republican 600.17 10/1/20 0:00 600.17 11/16/20 0:00 0.0 12/1/20 0:00
27 House District 04 Price, Grant Republican 100.0 5/11/20 0:00     0.0 5/19/20 0:00
28 House District 04 Price, Grant Republican 100.0 5/11/20 0:00 100.0 11/6/20 0:00 0.0 12/2/20 0:00
31 House District 05 Valdez, Alex Democratic 1500.0 3/6/19 0:00 1500.0 11/30/20 0:00 0.0 12/3/20 0:00
32 House District 05 Valdez, Alex Democratic 6500.0 7/12/18 0:00 4500.0 11/30/20 0:00 0.0 12/3/20 0:00
55 House District 06 Himelspach, Daniel Democratic 80.69 7/16/20 0:00     0.0 10/28/20 0:00
56 House District 06 Himelspach, Daniel Democratic 80.69 7/16/20 0:00 80.69 10/15/20 0:00 0.0 10/28/20 0:00
62 House District 10 Stickney, Kenneth Republican 2000.0 8/28/20 0:00     0.0 9/8/20 0:00
65 House District 10 Stickney, Kenneth Republican 66.32 9/17/20 0:00     0.0 11/28/20 0:00
68 House District 10 Stickney, Kenneth Republican 2000.0 8/28/20 0:00 2000.0 11/25/20 0:00 0.0 11/28/20 0:00
69 House District 10 Stickney, Kenneth Republican 66.32 9/17/20 0:00 66.32 11/25/20 0:00 0.0 11/28/20 0:00
74 House District 11 Mccormick, Karen Democratic 12.0 5/4/19 0:00 12.0 9/9/20 0:00 0.0 9/20/20 0:00
75 House District 11 Mccormick, Karen Democratic 144.0 5/4/19 0:00 144.0 9/9/20 0:00 0.0 9/20/20 0:00
76 House District 11 Mccormick, Karen Democratic 80.0 5/4/19 0:00 80.0 9/9/20 0:00 0.0 9/20/20 0:00
77 House District 11 Mccormick, Karen Democratic 24.0 8/30/19 0:00 24.0 9/9/20 0:00 0.0 9/20/20 0:00
80 House District 13 Amabile, Judith Democratic 250.0 3/4/19 0:00 250.0 11/2/20 0:00 0.0 12/2/20 0:00
81 House District 13 Amabile, Judith Democratic 5000.0 3/29/19 0:00 5000.0 11/2/20 0:00 0.0 12/2/20 0:00
93 House District 21 Bradfield, Mary Republican 6000.0 8/30/19 0:00 6000.0 11/16/20 0:00 0.0 12/3/20 0:00
94 House District 22 Larson, Colin Republican 500.0 3/23/20 0:00     0.0 5/4/20 0:00
95 House District 22 Larson, Colin Republican 500.0 3/30/20 0:00     0.0 5/4/20 0:00
96 House District 22 Larson, Colin Republican 600.0 4/12/20 0:00     0.0 5/4/20 0:00
97 House District 22 Larson, Colin Republican 42.54 4/14/20 0:00     0.0 5/4/20 0:00
98 House District 22 Larson, Colin Republican 900.0 5/1/20 0:00     0.0 5/18/20 0:00
99 House District 22 Larson, Colin Republican 248.84 5/14/20 0:00     0.0 6/1/20 0:00
100 House District 22 Larson, Colin Republican 900.0 6/5/20 0:00     0.0 6/15/20 0:00
101 House District 22 Larson, Colin Republican 684.0 6/14/20 0:00     0.0 6/29/20 0:00
102 House District 22 Larson, Colin Republican 350.0 6/19/20 0:00     0.0 6/29/20 0:00
105 House District 22 Larson, Colin Republican 500.0 3/23/20 0:00 500.0 7/6/20 0:00 0.0 8/3/20 0:00
106 House District 22 Larson, Colin Republican 500.0 3/30/20 0:00 500.0 7/6/20 0:00 0.0 8/3/20 0:00
107 House District 22 Larson, Colin Republican 600.0 4/12/20 0:00 600.0 7/6/20 0:00 0.0 8/3/20 0:00
108 House District 22 Larson, Colin Republican 42.54 4/14/20 0:00 42.54 7/6/20 0:00 0.0 8/3/20 0:00
109 House District 22 Larson, Colin Republican 900.0 5/1/20 0:00 900.0 7/6/20 0:00 0.0 8/3/20 0:00
110 House District 22 Larson, Colin Republican 248.84 5/14/20 0:00 248.84 7/6/20 0:00 0.0 8/3/20 0:00
111 House District 22 Larson, Colin Republican 900.0 6/5/20 0:00 900.0 7/6/20 0:00 0.0 8/3/20 0:00
112 House District 22 Larson, Colin Republican 684.0 6/14/20 0:00 684.0 7/6/20 0:00 0.0 8/3/20 0:00
113 House District 22 Larson, Colin Republican 350.0 6/19/20 0:00 350.0 7/6/20 0:00 0.0 8/3/20 0:00
116 House District 22 Everett, Justin Republican 205.0 6/17/20 0:00     0.0 6/29/20 0:00
117 House District 22 Everett, Justin Republican 500.0 6/19/20 0:00     0.0 6/29/20 0:00
118 House District 22 Everett, Justin Republican 200.0 6/23/20 0:00     0.0 6/29/20 0:00
119 House District 22 Everett, Justin Republican 100.0 6/25/20 0:00     0.0 7/29/20 0:00
120 House District 22 Everett, Justin Republican 125.0 6/26/20 0:00     0.0 7/29/20 0:00
122 House District 22 Everett, Justin Republican 2821.26 6/27/20 0:00     0.0 7/29/20 0:00
123 House District 22 Everett, Justin Republican 3000.0 6/28/20 0:00     0.0 7/29/20 0:00
124 House District 22 Everett, Justin Republican 210.0 6/29/20 0:00     0.0 7/29/20 0:00
125 House District 22 Everett, Justin Republican 2642.51 7/1/20 0:00     0.0 7/29/20 0:00
126 House District 22 Everett, Justin Republican 100.0 6/25/20 0:00 100.0 7/3/20 0:00 0.0 7/29/20 0:00
127 House District 22 Everett, Justin Republican 125.0 6/26/20 0:00 125.0 7/3/20 0:00 0.0 7/29/20 0:00
128 House District 22 Everett, Justin Republican 200.0 6/23/20 0:00 200.0 7/3/20 0:00 0.0 7/29/20 0:00
129 House District 22 Everett, Justin Republican 205.0 6/17/20 0:00 205.0 7/3/20 0:00 0.0 7/29/20 0:00
130 House District 22 Everett, Justin Republican 210.0 6/29/20 0:00 210.0 7/3/20 0:00 0.0 7/29/20 0:00

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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