leg_loans

155 rows

View and edit SQL

Suggested facets: affiliation, payment_amount, payment_date

Link rowid ▼ district candidate affiliation loan_amount loan_date payment_amount payment_date loan_balance filed_date
1 Senate District 08 Hanlon, Karl Democratic 10000 5/29/20 0:00     10000 6/15/20 0:00
2 Senate District 08 Hanlon, Karl Democratic 2000 5/29/20 0:00     2000 6/15/20 0:00
3 Senate District 10 Liston, Larry Republican 4500 9/30/19 0:00     4500 10/15/19 0:00
4 Senate District 17 Lewis, Sonya Jaquez Democratic 5000 9/30/19 0:00     5000 9/30/19 0:00
5 Senate District 23 Kirkmeyer, Barbara Republican 1000 6/28/20 0:00     1000 8/3/20 0:00
6 Senate District 23 Kirkmeyer, Barbara Republican 2500 8/21/20 0:00     2500 9/8/20 0:00
7 Senate District 25 Dickerson, Paula Democratic 1500 3/5/20 0:00     1500 4/29/20 0:00
8 Senate District 31 Townsend, Doug Republican 5000 10/1/20 0:00     5000 10/18/20 0:00
9 House District 04 Price, Grant Republican 100 5/11/20 0:00     100 5/19/20 0:00
10 House District 05 Valdez, Alex Democratic 1500 3/6/19 0:00     1500 4/15/19 0:00
11 House District 05 Valdez, Alex Democratic 6500 7/12/18 0:00 500 12/18/18 0:00 4500 4/15/19 0:00
12 House District 06 Mcaleb, William Republican 400 6/1/20 0:00     400 6/12/20 0:00
13 House District 06 Mcaleb, William Republican 400 6/2/20 0:00     400 6/12/20 0:00
14 House District 06 Mcaleb, William Republican 400 6/3/20 0:00     400 6/12/20 0:00
15 House District 06 Mcaleb, William Republican 205.77 6/5/20 0:00     205.77 6/12/20 0:00
16 House District 06 Mcaleb, William Republican 250 6/7/20 0:00     250 6/25/20 0:00
17 House District 06 Mcaleb, William Republican 35 7/8/20 0:00     35 7/29/20 0:00
18 House District 06 Mcaleb, William Republican 182.7 7/10/20 0:00     182.7 7/29/20 0:00
19 House District 06 Mcaleb, William Republican 465.73 7/26/20 0:00     465.73 7/29/20 0:00
20 House District 06 Mcaleb, William Republican 142.84 9/3/20 0:00     142.84 9/17/20 0:00
21 House District 10 Stickney, Kenneth Republican 2000 8/28/20 0:00     2000 9/8/20 0:00
22 House District 10 Stickney, Kenneth Republican 1000 9/17/20 0:00     1000 10/4/20 0:00
23 House District 10 Stickney, Kenneth Republican 2000 9/22/20 0:00     2000 10/4/20 0:00
24 House District 11 Mccormick, Karen Democratic 12 5/4/19 0:00     12 7/15/19 0:00
25 House District 11 Mccormick, Karen Democratic 144 5/4/19 0:00     144 7/15/19 0:00
26 House District 11 Mccormick, Karen Democratic 80 5/4/19 0:00     80 7/15/19 0:00
27 House District 11 Mccormick, Karen Democratic 24 8/30/19 0:00     24 10/10/19 0:00
28 House District 11 Mccormick, Karen Democratic 12 5/4/19 0:00 12 9/9/20 0:00 0 9/20/20 0:00
29 House District 11 Mccormick, Karen Democratic 144 5/4/19 0:00 144 9/9/20 0:00 0 9/20/20 0:00
30 House District 11 Mccormick, Karen Democratic 80 5/4/19 0:00 80 9/9/20 0:00 0 9/20/20 0:00
31 House District 11 Mccormick, Karen Democratic 24 8/30/19 0:00 24 9/9/20 0:00 0 9/20/20 0:00
32 House District 13 Amabile, Judith Democratic 250 3/4/19 0:00     250 4/14/19 0:00
33 House District 13 Amabile, Judith Democratic 5000 3/29/19 0:00     5000 4/14/19 0:00
34 House District 13 Sipple, Kevin Republican 4000 5/15/20 0:00     4000 7/21/20 0:00
35 House District 13 Sipple, Kevin Republican 500 7/13/20 0:00     500 8/3/20 0:00
36 House District 13 Sipple, Kevin Republican 20000 9/4/20 0:00     20000 9/18/20 0:00
37 House District 15 Williams, Dave Republican 25000 9/30/19 0:00     25000 10/9/19 0:00
38 House District 15 Williams, Dave Republican -25000 9/30/19 0:00     -25000 5/14/20 0:00
39 House District 18 Snyder, Marc Democratic 1000 12/1/18 0:00     1000 4/14/19 0:00
40 House District 18 Snyder, Marc Democratic 2500 12/12/18 0:00     2500 4/14/19 0:00
41 House District 20 Carver, Terri Republican 831.75 7/8/20 0:00     831.75 8/2/20 0:00
42 House District 21 Bradfield, Mary Republican 6000 8/30/19 0:00     6000 10/15/19 0:00
43 House District 22 Larson, Colin Republican 500 3/23/20 0:00     0 5/4/20 0:00
44 House District 22 Larson, Colin Republican 500 3/30/20 0:00     0 5/4/20 0:00
45 House District 22 Larson, Colin Republican 600 4/12/20 0:00     0 5/4/20 0:00
46 House District 22 Larson, Colin Republican 42.54 4/14/20 0:00     0 5/4/20 0:00
47 House District 22 Larson, Colin Republican 900 5/1/20 0:00     0 5/18/20 0:00
48 House District 22 Larson, Colin Republican 248.84 5/14/20 0:00     0 6/1/20 0:00
49 House District 22 Larson, Colin Republican 900 6/5/20 0:00     0 6/15/20 0:00
50 House District 22 Larson, Colin Republican 684 6/14/20 0:00     0 6/29/20 0:00
51 House District 22 Larson, Colin Republican 350 6/19/20 0:00     0 6/29/20 0:00
52 House District 22 Larson, Colin Republican 900 6/26/20 0:00     900 8/3/20 0:00
53 House District 22 Larson, Colin Republican 500 6/27/20 0:00     500 8/3/20 0:00
54 House District 22 Larson, Colin Republican 500 3/23/20 0:00 500 7/6/20 0:00 0 8/3/20 0:00
55 House District 22 Larson, Colin Republican 500 3/30/20 0:00 500 7/6/20 0:00 0 8/3/20 0:00
56 House District 22 Larson, Colin Republican 600 4/12/20 0:00 600 7/6/20 0:00 0 8/3/20 0:00
57 House District 22 Larson, Colin Republican 42.54 4/14/20 0:00 42.54 7/6/20 0:00 0 8/3/20 0:00
58 House District 22 Larson, Colin Republican 900 5/1/20 0:00 900 7/6/20 0:00 0 8/3/20 0:00
59 House District 22 Larson, Colin Republican 248.84 5/14/20 0:00 248.84 7/6/20 0:00 0 8/3/20 0:00
60 House District 22 Larson, Colin Republican 900 6/5/20 0:00 900 7/6/20 0:00 0 8/3/20 0:00
61 House District 22 Larson, Colin Republican 684 6/14/20 0:00 684 7/6/20 0:00 0 8/3/20 0:00
62 House District 22 Larson, Colin Republican 350 6/19/20 0:00 350 7/6/20 0:00 0 8/3/20 0:00
63 House District 22 Larson, Colin Republican 160.85 7/14/20 0:00     160.85 8/3/20 0:00
64 House District 22 Larson, Colin Republican 305.99 7/27/20 0:00     305.99 8/3/20 0:00
65 House District 23 Clifford, Fred Republican 57 2/25/20 0:00     57 5/2/20 0:00
66 House District 23 Clifford, Fred Republican 17.44 2/29/20 0:00     17.44 5/2/20 0:00
67 House District 23 Clifford, Fred Republican 800.01 3/11/20 0:00     800.01 5/2/20 0:00
68 House District 23 Clifford, Fred Republican 204 3/19/20 0:00     204 5/2/20 0:00
69 House District 23 Clifford, Fred Republican 10 3/20/20 0:00     10 5/2/20 0:00
70 House District 23 Clifford, Fred Republican 17.18 3/23/20 0:00     17.18 5/2/20 0:00
71 House District 24 Duran, Monica Democratic 19400 8/15/18 0:00 500 1/5/20 0:00 4700 5/4/20 0:00
72 House District 24 Duran, Monica Democratic 19400 8/15/18 0:00 500 2/4/20 0:00 4700 5/4/20 0:00
73 House District 24 Duran, Monica Democratic 19400 8/15/18 0:00 600 3/19/20 0:00 4700 5/4/20 0:00
74 House District 24 Duran, Monica Democratic 19400 8/15/18 0:00 500 3/31/20 0:00 4700 5/4/20 0:00
75 House District 24 Duran, Monica Democratic 19400 8/15/18 0:00 500 6/1/20 0:00 4700 6/15/20 0:00
76 House District 24 Duran, Monica Democratic 19400 8/15/18 0:00 100 8/5/20 0:00 4700 9/8/20 0:00
77 House District 24 Duran, Monica Democratic 19400 8/15/18 0:00 1000 10/12/19 0:00 4700 1/15/20 0:00
78 House District 24 Duran, Monica Democratic 19400 8/15/18 0:00 1000 12/2/19 0:00 4700 1/15/20 0:00
79 House District 25 Rosier, Donald Republican 5000 11/20/19 0:00     5000 1/12/20 0:00
80 House District 31 Caraveo, Yadira Democratic 54 10/13/17 0:00 54 12/6/18 0:00 0 4/15/19 0:00
81 House District 31 Caraveo, Yadira Democratic 250 10/27/17 0:00 250 12/6/18 0:00 0 4/15/19 0:00
82 House District 31 Caraveo, Yadira Democratic 594.13 11/8/17 0:00 594.13 12/6/18 0:00 0 4/15/19 0:00
83 House District 31 Caraveo, Yadira Democratic 48 11/14/17 0:00 48 12/6/18 0:00 0 4/15/19 0:00
84 House District 31 Caraveo, Yadira Democratic 48.58 12/6/17 0:00 48.58 12/6/18 0:00 0 4/15/19 0:00
85 House District 31 Caraveo, Yadira Democratic 140 10/19/18 0:00 140 12/6/18 0:00 0 4/15/19 0:00
86 House District 32 Caputo, Anthony Republican 1500 10/6/20 0:00     1500 10/19/20 0:00
87 House District 32 Caputo, Anthony Republican 1500 10/11/20 0:00     1500 10/19/20 0:00
88 House District 33 Quiachon, Mindy Republican 150 5/14/20 0:00     150 5/30/20 0:00
89 House District 33 Quiachon, Mindy Republican 133.99 5/14/20 0:00     133.99 5/30/20 0:00
90 House District 38 Champion, Richard Republican 5000 2/24/20 0:00     5000 5/1/20 0:00
91 House District 38 Champion, Richard Republican 2500 3/30/20 0:00     2500 5/1/20 0:00
92 House District 38 Champion, Richard Republican 1000 4/29/20 0:00     1000 5/1/20 0:00
93 House District 38 Champion, Richard Republican 1000 5/8/20 0:00     1000 5/18/20 0:00
94 House District 38 Champion, Richard Republican 5000 5/27/20 0:00     5000 5/30/20 0:00
95 House District 39 Baisley, Mark Republican 100 1/18/19 0:00     100 4/15/19 0:00
96 House District 39 Baisley, Mark Republican -400 4/4/18 0:00     -400 4/13/19 0:00
97 House District 39 Baisley, Mark Republican 400 4/4/18 0:00     0 4/13/19 0:00
98 House District 39 Baisley, Mark Republican 150 4/12/19 0:00     0 7/15/19 0:00
99 House District 39 Baisley, Mark Republican 150 6/6/18 0:00     0 4/11/19 0:00
100 House District 39 Baisley, Mark Republican 150 4/12/19 0:00 150 7/22/19 0:00 0 10/15/19 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"	INTEGER,
	"loan_date"	TEXT,
	"payment_amount"	TEXT,
	"payment_date"	TEXT,
	"loan_balance"	INTEGER,
	"filed_date"	TEXT
);
Powered by Datasette · Query took 30.584ms