leg_loans
278 rows sorted by affiliation
This data as json, CSV (advanced)
Link | rowid | district | candidate | affiliation ▼ | loan_amount | loan_date | payment_amount | payment_date | loan_balance | filed_date |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | ||
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 |
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 |
228 | 228 | House District 46 | Ambler, Jonathan | Republican | 50.0 | 2/11/20 0:00 | 0.0 | 5/4/20 0:00 | ||
229 | 229 | House District 46 | Ambler, Jonathan | Republican | 1221.83 | 8/5/20 0:00 | 0.0 | 9/7/20 0:00 | ||
230 | 230 | House District 46 | Ambler, Jonathan | Republican | 1221.83 | 8/5/20 0:00 | 1221.83 | 11/10/20 0:00 | 0.0 | 12/3/20 0:00 |
231 | 231 | House District 46 | Ambler, Jonathan | Republican | 50.0 | 2/11/20 0:00 | 50.0 | 11/10/20 0:00 | 0.0 | 12/3/20 0:00 |
232 | 232 | House District 47 | Parker, Ron | Republican | 500.0 | 1/13/20 0:00 | 500.0 | 5/1/20 0:00 | ||
233 | 233 | House District 47 | Parker, Ron | Republican | 2000.0 | 4/20/20 0:00 | 2000.0 | 5/27/20 0:00 | ||
234 | 234 | House District 47 | Parker, Ron | Republican | 2000.0 | 5/27/20 0:00 | 2000.0 | 5/30/20 0:00 | ||
235 | 235 | House District 47 | Parker, Ron | Republican | 700.0 | 6/19/20 0:00 | 700.0 | 6/28/20 0:00 | ||
236 | 236 | House District 48 | Van Beber, Tonya | Republican | 3900.0 | 2/24/20 0:00 | 3900.0 | 5/4/20 0:00 | ||
237 | 237 | House District 48 | Van Beber, Tonya | Republican | -3900.0 | 2/24/20 0:00 | -3900.0 | 5/20/20 0:00 | ||
238 | 238 | House District 48 | Van Beber, Tonya | Republican | 3900.0 | 2/24/20 0:00 | 900.0 | 5/20/20 0:00 | ||
239 | 239 | House District 48 | Van Beber, Tonya | Republican | 7000.0 | 2/28/20 0:00 | 7000.0 | 5/4/20 0:00 | ||
240 | 240 | House District 48 | Van Beber, Tonya | Republican | -7000.0 | 2/28/20 0:00 | -7000.0 | 5/20/20 0:00 | ||
241 | 241 | House District 48 | Van Beber, Tonya | Republican | 7000.0 | 2/28/20 0:00 | 7000.0 | 5/20/20 0:00 | ||
242 | 242 | House District 48 | Van Beber, Tonya | Republican | 5000.0 | 8/14/19 0:00 | 0.0 | 5/20/20 0:00 | ||
243 | 243 | House District 48 | Van Beber, Tonya | Republican | 5000.0 | 8/14/19 0:00 | 5000.0 | 11/9/20 0:00 | 0.0 | 12/3/20 0:00 |
244 | 244 | House District 48 | Van Beber, Tonya | Republican | 3900.0 | 2/24/20 0:00 | 3000.0 | 11/9/20 0:00 | 900.0 | 12/3/20 0:00 |
245 | 245 | House District 49 | Lynch, Michael | Republican | 5000.0 | 5/26/20 0:00 | 0.0 | 5/29/20 0:00 | ||
246 | 246 | House District 49 | Lynch, Michael | Republican | 5000.0 | 5/26/20 0:00 | 5000.0 | 7/10/20 0:00 | 0.0 | 8/3/20 0:00 |
247 | 247 | House District 49 | Marble, Vicki | Republican | 7500.0 | 5/10/20 0:00 | 7500.0 | 5/18/20 0:00 | ||
248 | 248 | House District 49 | Marble, Vicki | Republican | 619.95 | 10/9/19 0:00 | 619.95 | 1/15/20 0:00 | ||
259 | 259 | House District 59 | Harris, Marilyn | Republican | 1000.0 | 7/21/20 0:00 | 1000.0 | 8/3/20 0:00 | ||
260 | 260 | House District 59 | Harris, Marilyn | Republican | 400.0 | 7/24/20 0:00 | 400.0 | 8/3/20 0:00 | ||
261 | 261 | House District 59 | Harris, Marilyn | Republican | 5000.0 | 8/11/20 0:00 | 5000.0 | 9/8/20 0:00 | ||
268 | 268 | House District 60 | Hanks, Ron | Republican | 10000.0 | 4/29/20 0:00 | 10000.0 | 5/4/20 0:00 | ||
269 | 269 | House District 60 | Hanks, Ron | Republican | 10000.0 | 12/27/19 0:00 | 10000.0 | 1/14/20 0:00 | ||
271 | 271 | House District 63 | Miller, Patricia | Republican | 2000.0 | 6/11/20 0:00 | 2000.0 | 6/29/20 0:00 | ||
272 | 272 | House District 63 | Miller, Patricia | Republican | -2000.0 | 6/11/20 0:00 | -2000.0 | 8/30/20 0:00 | ||
273 | 273 | House District 63 | Miller, Patricia | Republican | 903.49 | 6/11/20 0:00 | 0.0 | 8/30/20 0:00 | ||
274 | 274 | House District 63 | Miller, Patricia | Republican | 903.49 | 6/11/20 0:00 | 903.49 | 8/24/20 0:00 | 0.0 | 8/30/20 0:00 |
275 | 275 | House District 63 | Woog, Dan | Republican | 2000.0 | 5/14/20 0:00 | 0.0 | 6/1/20 0:00 | ||
276 | 276 | House District 63 | Woog, Dan | Republican | 1000.0 | 5/20/20 0:00 | 0.0 | 6/1/20 0:00 | ||
277 | 277 | House District 63 | Woog, Dan | Republican | 5000.0 | 5/24/20 0:00 | 0.0 | 6/1/20 0:00 | ||
278 | 278 | House District 64 | Alonso Holtorf, Richard | Republican | 5000.0 | 8/3/20 0:00 | 5000.0 | 9/8/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 );