leg_loans
278 rows sorted by district
This data as json, CSV (advanced)
Link | rowid | district ▼ | candidate | affiliation | loan_amount | loan_date | payment_amount | payment_date | loan_balance | filed_date |
---|---|---|---|---|---|---|---|---|---|---|
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 |
137 | 137 | House District 22 | Everett, Justin | Republican | 6665.59 | 6/26/20 0:00 | 899.62 | 7/10/20 0:00 | 5765.97 | 7/29/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 | ||
139 | 139 | House District 23 | Clifford, Fred | Republican | -57.0 | 2/25/20 0:00 | -57.0 | 12/1/20 0:00 | ||
140 | 140 | House District 23 | Clifford, Fred | Republican | 17.44 | 2/29/20 0:00 | 17.44 | 5/2/20 0:00 | ||
141 | 141 | House District 23 | Clifford, Fred | Republican | -17.44 | 2/29/20 0:00 | -17.44 | 12/1/20 0:00 | ||
142 | 142 | House District 23 | Clifford, Fred | Republican | 800.01 | 3/11/20 0:00 | 800.01 | 5/2/20 0:00 | ||
143 | 143 | House District 23 | Clifford, Fred | Republican | -800.01 | 3/11/20 0:00 | -800.01 | 12/1/20 0:00 | ||
144 | 144 | House District 23 | Clifford, Fred | Republican | 204.0 | 3/19/20 0:00 | 204.0 | 5/2/20 0:00 | ||
145 | 145 | House District 23 | Clifford, Fred | Republican | -204.0 | 3/19/20 0:00 | -204.0 | 12/1/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 | ||
147 | 147 | House District 23 | Clifford, Fred | Republican | 10.0 | 3/20/20 0:00 | 10.0 | 5/2/20 0:00 | ||
148 | 148 | House District 23 | Clifford, Fred | Republican | -10.0 | 3/20/20 0:00 | -10.0 | 12/1/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 | ||
150 | 150 | House District 23 | Clifford, Fred | Republican | -17.18 | 3/23/20 0:00 | -17.18 | 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 | ||
163 | 163 | House District 30 | Sarmiento, Cynthia | Republican | 3000.0 | 2/1/20 0:00 | 3000.0 | 5/2/20 0:00 | ||
164 | 164 | House District 30 | Sarmiento, Cynthia | Republican | -3000.0 | 2/1/20 0:00 | -3000.0 | 9/16/20 0:00 | ||
165 | 165 | House District 30 | Sarmiento, Cynthia | Republican | 3000.0 | 2/1/20 0:00 | 3000.0 | 9/16/20 0:00 | ||
166 | 166 | House District 30 | Sarmiento, Cynthia | Republican | -3000.0 | 2/1/20 0:00 | -3000.0 | 9/16/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 | ||
168 | 168 | House District 30 | Sarmiento, Cynthia | Republican | 3000.0 | 2/1/20 0:00 | 386.34 | 8/15/20 0:00 | 3000.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 |
173 | 173 | House District 31 | Caraveo, Yadira | Democratic | 48.58 | 12/6/17 0:00 | 48.58 | 12/6/18 0:00 | 0.0 | 4/15/19 0:00 |
174 | 174 | House District 31 | Caraveo, Yadira | Democratic | 140.0 | 10/19/18 0:00 | 140.0 | 12/6/18 0:00 | 0.0 | 4/15/19 0:00 |
175 | 175 | House District 32 | Caputo, Anthony | Republican | 1500.0 | 10/6/20 0:00 | 1500.0 | 10/19/20 0:00 | ||
176 | 176 | House District 32 | Caputo, Anthony | Republican | -1500.0 | 10/6/20 0:00 | -1500.0 | 12/1/20 0:00 | ||
177 | 177 | House District 32 | Caputo, Anthony | Republican | 1500.0 | 10/11/20 0:00 | 1500.0 | 10/19/20 0:00 | ||
178 | 178 | House District 32 | Caputo, Anthony | Republican | -1500.0 | 10/11/20 0:00 | -1500.0 | 12/1/20 0:00 | ||
179 | 179 | House District 33 | Quiachon, Mindy | Republican | 150.0 | 5/14/20 0:00 | 150.0 | 5/30/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 | ||
181 | 181 | House District 33 | Quiachon, Mindy | Republican | -150.0 | 5/14/20 0:00 | -150.0 | 11/24/20 0:00 | ||
182 | 182 | House District 33 | Quiachon, Mindy | Republican | -133.99 | 5/14/20 0:00 | -133.99 | 11/24/20 0:00 | ||
183 | 183 | House District 38 | Ferguson, Candice | Democratic | 186.72 | 5/9/19 0:00 | 186.72 | 7/14/19 0:00 | ||
184 | 184 | House District 38 | Ferguson, Candice | Democratic | 186.72 | 5/9/19 0:00 | 186.72 | 7/9/20 0:00 | 0.0 | 7/27/20 0:00 |
185 | 185 | House District 38 | Champion, Richard | Republican | 5000.0 | 2/24/20 0:00 | 5000.0 | 5/1/20 0:00 | ||
186 | 186 | House District 38 | Champion, Richard | Republican | -5000.0 | 2/24/20 0:00 | -5000.0 | 11/28/20 0:00 | ||
187 | 187 | House District 38 | Champion, Richard | Republican | 2525.82 | 2/24/20 0:00 | 0.0 | 11/28/20 0:00 | ||
188 | 188 | House District 38 | Champion, Richard | Republican | 2500.0 | 3/30/20 0:00 | 2500.0 | 5/1/20 0:00 | ||
189 | 189 | House District 38 | Champion, Richard | Republican | -2500.0 | 3/30/20 0:00 | -2500.0 | 11/28/20 0:00 | ||
190 | 190 | House District 38 | Champion, Richard | Republican | 1000.0 | 4/29/20 0:00 | 1000.0 | 5/1/20 0:00 | ||
191 | 191 | House District 38 | Champion, Richard | Republican | -1000.0 | 4/29/20 0:00 | -1000.0 | 11/28/20 0:00 | ||
192 | 192 | House District 38 | Champion, Richard | Republican | 1000.0 | 5/8/20 0:00 | 1000.0 | 5/18/20 0:00 | ||
193 | 193 | House District 38 | Champion, Richard | Republican | -1000.0 | 5/8/20 0:00 | -1000.0 | 11/28/20 0:00 | ||
194 | 194 | House District 38 | Champion, Richard | Republican | 5000.0 | 5/27/20 0:00 | 5000.0 | 5/30/20 0:00 | ||
195 | 195 | House District 38 | Champion, Richard | Republican | -5000.0 | 5/27/20 0:00 | -5000.0 | 11/28/20 0:00 | ||
196 | 196 | House District 38 | Champion, Richard | Republican | 2525.82 | 2/24/20 0:00 | 2525.82 | 11/16/20 0:00 | 0.0 | 11/28/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 | ||
198 | 198 | House District 39 | Baisley, Mark | Republican | -400.0 | 4/4/18 0:00 | -400.0 | 4/13/19 0:00 | ||
199 | 199 | House District 39 | Baisley, Mark | Republican | 400.0 | 4/4/18 0:00 | 0.0 | 4/13/19 0:00 | ||
200 | 200 | House District 39 | Baisley, Mark | Republican | 150.0 | 4/12/19 0:00 | 0.0 | 7/15/19 0:00 | ||
201 | 201 | House District 39 | Baisley, Mark | Republican | 150.0 | 6/6/18 0:00 | 0.0 | 4/11/19 0:00 | ||
202 | 202 | House District 39 | Baisley, Mark | Republican | 150.0 | 4/12/19 0:00 | 150.0 | 7/22/19 0:00 | 0.0 | 10/15/19 0:00 |
203 | 203 | House District 39 | Baisley, Mark | Republican | 400.0 | 4/4/18 0:00 | -100.0 | 8/27/18 0:00 | 0.0 | 4/13/19 0:00 |
204 | 204 | House District 39 | Baisley, Mark | Republican | 150.0 | 6/6/18 0:00 | 100.0 | 8/27/18 0:00 | 0.0 | 4/13/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 | ||
206 | 206 | House District 39 | Baisley, Mark | Republican | 150.0 | 6/6/18 0:00 | 50.0 | 12/24/18 0:00 | 0.0 | 4/15/19 0:00 |
207 | 207 | House District 39 | Baisley, Mark | Republican | 25.0 | 11/15/18 0:00 | 25.0 | 12/24/18 0:00 | 0.0 | 4/15/19 0:00 |
208 | 208 | House District 39 | Baisley, Mark | Republican | 100.0 | 1/18/19 0:00 | 100.0 | 1/21/20 0:00 | 0.0 | 5/4/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 |
210 | 210 | House District 40 | Ricks, Naquetta | Democratic | 2100.0 | 1/1/20 0:00 | 2100.0 | 10/6/20 0:00 | ||
211 | 211 | House District 40 | Ricks, Naquetta | Democratic | 500.0 | 3/17/20 0:00 | 500.0 | 5/9/20 0:00 | ||
212 | 212 | House District 40 | Ricks, Naquetta | Democratic | 300.0 | 10/1/20 0:00 | 300.0 | 10/19/20 0:00 | ||
213 | 213 | House District 40 | Ricks, Naquetta | Democratic | 600.0 | 12/24/19 0:00 | 600.0 | 1/16/20 0:00 | ||
214 | 214 | House District 41 | Andrews, Robert | Republican | 1000.0 | 3/6/20 0:00 | 1000.0 | 5/1/20 0:00 | ||
215 | 215 | House District 44 | Ransom, Kim | Republican | 3000.0 | 1/18/19 0:00 | 1000.0 | 4/13/19 0:00 | ||
216 | 216 | House District 44 | Ransom, Kim | Republican | 3000.0 | 1/18/19 0:00 | 2000.0 | 12/23/19 0:00 | 1000.0 | 1/11/20 0:00 |
217 | 217 | House District 45 | Barrett, Katie | Democratic | 2500.0 | 6/4/19 0:00 | 2500.0 | 7/15/19 0:00 | ||
218 | 218 | House District 45 | Barrett, Katie | Democratic | 500.0 | 9/9/19 0:00 | 0.0 | 10/3/19 0:00 | ||
219 | 219 | House District 45 | Barrett, Katie | Democratic | 500.0 | 9/9/19 0:00 | 500.0 | 9/17/19 0:00 | 0.0 | 10/3/19 0:00 |
220 | 220 | House District 45 | Barrett, Katie | Democratic | 2000.0 | 2/20/20 0:00 | -500.0 | 5/4/20 0:00 | ||
221 | 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 | 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 |
223 | 223 | House District 45 | Barrett, Katie | Democratic | -2500.0 | 6/4/19 0:00 | -2500.0 | 8/1/20 0:00 | ||
224 | 224 | House District 45 | Barrett, Katie | Democratic | 500.0 | 6/4/19 0:00 | 500.0 | 8/1/20 0:00 | ||
225 | 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 | 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 |
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 );