leg_loans
278 rows sorted by loan_balance descending
This data as json, CSV (advanced)
Link | rowid | district | candidate | affiliation | loan_amount | loan_date | payment_amount | payment_date | loan_balance ▲ | filed_date |
---|---|---|---|---|---|---|---|---|---|---|
179 | 179 | House District 33 | Quiachon, Mindy | Republican | 150.0 | 5/14/20 0:00 | 150.0 | 5/30/20 0:00 | ||
71 | 71 | House District 11 | Mccormick, Karen | Democratic | 144.0 | 5/4/19 0:00 | 144.0 | 7/15/19 0:00 | ||
41 | 41 | House District 06 | Mcaleb, William | Republican | 142.84 | 9/3/20 0:00 | 142.84 | 9/17/20 0:00 | ||
180 | 180 | House District 33 | Quiachon, Mindy | Republican | 133.99 | 5/14/20 0:00 | 133.99 | 5/30/20 0:00 | ||
197 | 197 | House District 39 | Baisley, Mark | Republican | 100.0 | 1/18/19 0:00 | 100.0 | 4/15/19 0:00 | ||
72 | 72 | House District 11 | Mccormick, Karen | Democratic | 80.0 | 5/4/19 0:00 | 80.0 | 7/15/19 0:00 | ||
205 | 205 | House District 39 | Baisley, Mark | Republican | 75.0 | 12/6/18 0:00 | 75.0 | 4/15/19 0:00 | ||
252 | 252 | House District 49 | Zokaie, Yara | Democratic | 70.0 | 8/20/20 0:00 | 70.0 | 9/8/20 0:00 | ||
138 | 138 | House District 23 | Clifford, Fred | Republican | 57.0 | 2/25/20 0:00 | 57.0 | 5/2/20 0:00 | ||
250 | 250 | House District 49 | Zokaie, Yara | Democratic | 50.0 | 6/14/20 0:00 | 50.0 | 6/29/20 0:00 | ||
38 | 38 | House District 06 | Mcaleb, William | Republican | 35.0 | 7/8/20 0:00 | 35.0 | 7/29/20 0:00 | ||
209 | 209 | House District 39 | Baisley, Mark | Republican | 75.0 | 12/6/18 0:00 | 50.0 | 1/21/20 0:00 | 25.0 | 5/4/20 0:00 |
73 | 73 | House District 11 | Mccormick, Karen | Democratic | 24.0 | 8/30/19 0:00 | 24.0 | 10/10/19 0:00 | ||
249 | 249 | House District 49 | Zokaie, Yara | Democratic | 20.0 | 9/23/19 0:00 | 20.0 | 10/15/19 0:00 | ||
140 | 140 | House District 23 | Clifford, Fred | Republican | 17.44 | 2/29/20 0:00 | 17.44 | 5/2/20 0:00 | ||
149 | 149 | House District 23 | Clifford, Fred | Republican | 17.18 | 3/23/20 0:00 | 17.18 | 5/2/20 0:00 | ||
70 | 70 | House District 11 | Mccormick, Karen | Democratic | 12.0 | 5/4/19 0:00 | 12.0 | 7/15/19 0:00 | ||
147 | 147 | House District 23 | Clifford, Fred | Republican | 10.0 | 3/20/20 0:00 | 10.0 | 5/2/20 0:00 | ||
2 | 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 | 7 | Senate District 14 | Hochheimer, Hans | Republican | 2000.0 | 3/5/20 0:00 | 0.0 | 11/30/20 0:00 | ||
8 | 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 | 11 | Senate District 23 | Kirkmeyer, Barbara | Republican | 2500.0 | 8/21/20 0:00 | 0.0 | 9/8/20 0:00 | ||
12 | 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 | 21 | Senate District 25 | Dickerson, Paula | Democratic | 1500.0 | 3/5/20 0:00 | 0.0 | 4/29/20 0:00 | ||
22 | 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 | 25 | Senate District 31 | Townsend, Doug | Republican | 600.17 | 10/1/20 0:00 | 0.0 | 12/1/20 0:00 | ||
26 | 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 | 27 | House District 04 | Price, Grant | Republican | 100.0 | 5/11/20 0:00 | 0.0 | 5/19/20 0:00 | ||
28 | 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 | 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 | 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 | 55 | House District 06 | Himelspach, Daniel | Democratic | 80.69 | 7/16/20 0:00 | 0.0 | 10/28/20 0:00 | ||
56 | 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 | 62 | House District 10 | Stickney, Kenneth | Republican | 2000.0 | 8/28/20 0:00 | 0.0 | 9/8/20 0:00 | ||
65 | 65 | House District 10 | Stickney, Kenneth | Republican | 66.32 | 9/17/20 0:00 | 0.0 | 11/28/20 0:00 | ||
68 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 94 | House District 22 | Larson, Colin | Republican | 500.0 | 3/23/20 0:00 | 0.0 | 5/4/20 0:00 | ||
95 | 95 | House District 22 | Larson, Colin | Republican | 500.0 | 3/30/20 0:00 | 0.0 | 5/4/20 0:00 | ||
96 | 96 | House District 22 | Larson, Colin | Republican | 600.0 | 4/12/20 0:00 | 0.0 | 5/4/20 0:00 | ||
97 | 97 | House District 22 | Larson, Colin | Republican | 42.54 | 4/14/20 0:00 | 0.0 | 5/4/20 0:00 | ||
98 | 98 | House District 22 | Larson, Colin | Republican | 900.0 | 5/1/20 0:00 | 0.0 | 5/18/20 0:00 | ||
99 | 99 | House District 22 | Larson, Colin | Republican | 248.84 | 5/14/20 0:00 | 0.0 | 6/1/20 0:00 | ||
100 | 100 | House District 22 | Larson, Colin | Republican | 900.0 | 6/5/20 0:00 | 0.0 | 6/15/20 0:00 | ||
101 | 101 | House District 22 | Larson, Colin | Republican | 684.0 | 6/14/20 0:00 | 0.0 | 6/29/20 0:00 | ||
102 | 102 | House District 22 | Larson, Colin | Republican | 350.0 | 6/19/20 0:00 | 0.0 | 6/29/20 0:00 | ||
105 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 116 | House District 22 | Everett, Justin | Republican | 205.0 | 6/17/20 0:00 | 0.0 | 6/29/20 0:00 | ||
117 | 117 | House District 22 | Everett, Justin | Republican | 500.0 | 6/19/20 0:00 | 0.0 | 6/29/20 0:00 | ||
118 | 118 | House District 22 | Everett, Justin | Republican | 200.0 | 6/23/20 0:00 | 0.0 | 6/29/20 0:00 | ||
119 | 119 | House District 22 | Everett, Justin | Republican | 100.0 | 6/25/20 0:00 | 0.0 | 7/29/20 0:00 | ||
120 | 120 | House District 22 | Everett, Justin | Republican | 125.0 | 6/26/20 0:00 | 0.0 | 7/29/20 0:00 | ||
122 | 122 | House District 22 | Everett, Justin | Republican | 2821.26 | 6/27/20 0:00 | 0.0 | 7/29/20 0:00 | ||
123 | 123 | House District 22 | Everett, Justin | Republican | 3000.0 | 6/28/20 0:00 | 0.0 | 7/29/20 0:00 | ||
124 | 124 | House District 22 | Everett, Justin | Republican | 210.0 | 6/29/20 0:00 | 0.0 | 7/29/20 0:00 | ||
125 | 125 | House District 22 | Everett, Justin | Republican | 2642.51 | 7/1/20 0:00 | 0.0 | 7/29/20 0:00 | ||
126 | 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 | 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 | 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 | 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 | 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 |
131 | 131 | House District 22 | Everett, Justin | Republican | 500.0 | 6/19/20 0:00 | 500.0 | 7/3/20 0:00 | 0.0 | 7/29/20 0:00 |
132 | 132 | House District 22 | Everett, Justin | Republican | 2642.51 | 7/1/20 0:00 | 2642.51 | 7/3/20 0:00 | 0.0 | 7/29/20 0:00 |
133 | 133 | House District 22 | Everett, Justin | Republican | 2821.26 | 6/27/20 0:00 | 2821.26 | 7/3/20 0:00 | 0.0 | 7/29/20 0:00 |
134 | 134 | House District 22 | Everett, Justin | Republican | 3000.0 | 6/28/20 0:00 | 2864.0 | 7/3/20 0:00 | 0.0 | 7/29/20 0:00 |
135 | 135 | House District 22 | Everett, Justin | Republican | 3000.0 | 6/28/20 0:00 | 135.0 | 7/3/20 0:00 | 0.0 | 7/29/20 0:00 |
136 | 136 | House District 22 | Everett, Justin | Republican | 3000.0 | 6/28/20 0:00 | 1.0 | 7/10/20 0:00 | 0.0 | 7/29/20 0:00 |
146 | 146 | House District 23 | Clifford, Fred | Republican | 65.49 | 3/19/20 0:00 | 0.0 | 12/1/20 0:00 | ||
151 | 151 | House District 23 | Clifford, Fred | Republican | 65.49 | 3/19/20 0:00 | 65.49 | 11/30/20 0:00 | 0.0 | 12/1/20 0:00 |
152 | 152 | House District 24 | Duran, Monica | Democratic | 19400.0 | 8/15/18 0:00 | 500.0 | 1/5/20 0:00 | 0.0 | 5/4/20 0:00 |
153 | 153 | House District 24 | Duran, Monica | Democratic | 19400.0 | 8/15/18 0:00 | 500.0 | 2/4/20 0:00 | 0.0 | 5/4/20 0:00 |
154 | 154 | House District 24 | Duran, Monica | Democratic | 19400.0 | 8/15/18 0:00 | 600.0 | 3/19/20 0:00 | 0.0 | 5/4/20 0:00 |
155 | 155 | House District 24 | Duran, Monica | Democratic | 19400.0 | 8/15/18 0:00 | 500.0 | 3/31/20 0:00 | 0.0 | 5/4/20 0:00 |
156 | 156 | House District 24 | Duran, Monica | Democratic | 19400.0 | 8/15/18 0:00 | 500.0 | 6/1/20 0:00 | 0.0 | 6/15/20 0:00 |
157 | 157 | House District 24 | Duran, Monica | Democratic | 19400.0 | 8/15/18 0:00 | 100.0 | 8/5/20 0:00 | 0.0 | 9/8/20 0:00 |
158 | 158 | House District 24 | Duran, Monica | Democratic | 19400.0 | 8/15/18 0:00 | 1000.0 | 10/12/19 0:00 | 0.0 | 1/15/20 0:00 |
159 | 159 | House District 24 | Duran, Monica | Democratic | 19400.0 | 8/15/18 0:00 | 4700.0 | 11/28/20 0:00 | 0.0 | 12/3/20 0:00 |
160 | 160 | House District 24 | Duran, Monica | Democratic | 19400.0 | 8/15/18 0:00 | 1000.0 | 12/2/19 0:00 | 0.0 | 1/15/20 0:00 |
161 | 161 | House District 25 | Rosier, Donald | Republican | 5000.0 | 11/20/19 0:00 | 5250.0 | 10/5/20 0:00 | 0.0 | 12/3/20 0:00 |
162 | 162 | House District 25 | Rosier, Donald | Republican | 5000.0 | 11/20/19 0:00 | 0.0 | 1/12/20 0:00 | ||
167 | 167 | House District 30 | Sarmiento, Cynthia | Republican | 386.34 | 2/1/20 0:00 | 0.0 | 9/16/20 0:00 | ||
169 | 169 | House District 31 | Caraveo, Yadira | Democratic | 54.0 | 10/13/17 0:00 | 54.0 | 12/6/18 0:00 | 0.0 | 4/15/19 0:00 |
170 | 170 | House District 31 | Caraveo, Yadira | Democratic | 250.0 | 10/27/17 0:00 | 250.0 | 12/6/18 0:00 | 0.0 | 4/15/19 0:00 |
171 | 171 | House District 31 | Caraveo, Yadira | Democratic | 594.13 | 11/8/17 0:00 | 594.13 | 12/6/18 0:00 | 0.0 | 4/15/19 0:00 |
172 | 172 | House District 31 | Caraveo, Yadira | Democratic | 48.0 | 11/14/17 0:00 | 48.0 | 12/6/18 0:00 | 0.0 | 4/15/19 0:00 |
Advanced export
JSON shape: default, array, newline-delimited
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 );