leg_loans
278 rows sorted by candidate
This data as json, CSV (advanced)
Link | rowid | district | candidate ▼ | affiliation | loan_amount | loan_date | payment_amount | payment_date | loan_balance | filed_date |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 | ||
3 | 3 | Senate District 08 | Hanlon, Karl | Democratic | 10000.0 | 5/29/20 0:00 | 10000.0 | 6/15/20 0:00 | ||
4 | 4 | Senate District 08 | Hanlon, Karl | Democratic | 2000.0 | 5/29/20 0:00 | 2000.0 | 6/15/20 0:00 | ||
5 | 5 | Senate District 08 | Hanlon, Karl | Democratic | 6000.0 | 10/2/20 0:00 | 6000.0 | 11/2/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 | ||
43 | 43 | House District 06 | Himelspach, Daniel | Democratic | 15000.0 | 1/2/20 0:00 | 15000.0 | 5/5/20 0:00 | ||
44 | 44 | House District 06 | Himelspach, Daniel | Democratic | -15000.0 | 1/2/20 0:00 | -15000.0 | 10/28/20 0:00 | ||
45 | 45 | House District 06 | Himelspach, Daniel | Democratic | 10000.0 | 2/27/20 0:00 | 10000.0 | 5/5/20 0:00 | ||
46 | 46 | House District 06 | Himelspach, Daniel | Democratic | -10000.0 | 2/27/20 0:00 | -10000.0 | 10/28/20 0:00 | ||
47 | 47 | House District 06 | Himelspach, Daniel | Democratic | 5000.0 | 6/2/20 0:00 | 5000.0 | 6/15/20 0:00 | ||
48 | 48 | House District 06 | Himelspach, Daniel | Democratic | -5000.0 | 6/2/20 0:00 | -5000.0 | 10/28/20 0:00 | ||
49 | 49 | House District 06 | Himelspach, Daniel | Democratic | 4000.0 | 6/13/20 0:00 | 4000.0 | 6/29/20 0:00 | ||
50 | 50 | House District 06 | Himelspach, Daniel | Democratic | -4000.0 | 6/13/20 0:00 | -4000.0 | 10/28/20 0:00 | ||
51 | 51 | House District 06 | Himelspach, Daniel | Democratic | 1000.0 | 7/10/20 0:00 | 1000.0 | 7/30/20 0:00 | ||
52 | 52 | House District 06 | Himelspach, Daniel | Democratic | -1000.0 | 7/10/20 0:00 | -1000.0 | 10/28/20 0:00 | ||
53 | 53 | House District 06 | Himelspach, Daniel | Democratic | 5200.0 | 7/16/20 0:00 | 5200.0 | 7/30/20 0:00 | ||
54 | 54 | House District 06 | Himelspach, Daniel | Democratic | -5200.0 | 7/16/20 0:00 | -5200.0 | 10/28/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 |
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 |
1 | 1 | Senate District 08 | Irvine, Debra | Republican | 2000.0 | 12/6/18 0:00 | 2000.0 | 1/15/19 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 |
10 | 10 | Senate District 23 | Kirkmeyer, Barbara | Republican | 1000.0 | 6/28/20 0:00 | 1000.0 | 8/3/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 |
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 | ||
103 | 103 | House District 22 | Larson, Colin | Republican | 900.0 | 6/26/20 0:00 | 900.0 | 8/3/20 0:00 | ||
104 | 104 | House District 22 | Larson, Colin | Republican | 500.0 | 6/27/20 0:00 | 500.0 | 8/3/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 |
114 | 114 | House District 22 | Larson, Colin | Republican | 160.85 | 7/14/20 0:00 | 160.85 | 8/3/20 0:00 | ||
115 | 115 | House District 22 | Larson, Colin | Republican | 305.99 | 7/27/20 0:00 | 305.99 | 8/3/20 0:00 | ||
9 | 9 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 5000.0 | 9/30/19 0:00 | 5000.0 | 9/30/19 0:00 | ||
6 | 6 | Senate District 10 | Liston, Larry | Republican | 4500.0 | 9/30/19 0:00 | 4500.0 | 10/15/19 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 | ||
33 | 33 | House District 06 | Mcaleb, William | Republican | 400.0 | 6/1/20 0:00 | 400.0 | 6/12/20 0:00 | ||
34 | 34 | House District 06 | Mcaleb, William | Republican | 400.0 | 6/2/20 0:00 | 400.0 | 6/12/20 0:00 | ||
35 | 35 | House District 06 | Mcaleb, William | Republican | 400.0 | 6/3/20 0:00 | 400.0 | 6/12/20 0:00 | ||
36 | 36 | House District 06 | Mcaleb, William | Republican | 205.77 | 6/5/20 0:00 | 205.77 | 6/12/20 0:00 | ||
37 | 37 | House District 06 | Mcaleb, William | Republican | 250.0 | 6/7/20 0:00 | 250.0 | 6/25/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 | ||
39 | 39 | House District 06 | Mcaleb, William | Republican | 182.7 | 7/10/20 0:00 | 182.7 | 7/29/20 0:00 | ||
40 | 40 | House District 06 | Mcaleb, William | Republican | 465.73 | 7/26/20 0:00 | 465.73 | 7/29/20 0:00 | ||
41 | 41 | House District 06 | Mcaleb, William | Republican | 142.84 | 9/3/20 0:00 | 142.84 | 9/17/20 0:00 | ||
42 | 42 | House District 06 | Mcaleb, William | Republican | 991.14 | 10/30/20 0:00 | 991.14 | 11/30/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 | ||
71 | 71 | House District 11 | Mccormick, Karen | Democratic | 144.0 | 5/4/19 0:00 | 144.0 | 7/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 | ||
73 | 73 | House District 11 | Mccormick, Karen | Democratic | 24.0 | 8/30/19 0:00 | 24.0 | 10/10/19 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 |
257 | 257 | House District 59 | Mclachlan, Barbara | Democratic | 200.0 | 4/1/19 0:00 | 200.0 | 7/15/19 0:00 | ||
258 | 258 | House District 59 | Mclachlan, Barbara | Democratic | 200.0 | 4/1/19 0:00 | 200.0 | 11/30/20 0:00 | 0.0 | 12/3/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 |
57 | 57 | House District 06 | Paletz, Steven | Democratic | 20000.0 | 5/27/20 0:00 | 20000.0 | 6/1/20 0:00 | ||
58 | 58 | House District 06 | Paletz, Steven | Democratic | 60000.0 | 5/29/20 0:00 | 60000.0 | 6/15/20 0:00 | ||
59 | 59 | House District 06 | Paletz, Steven | Democratic | 15000.0 | 6/16/20 0:00 | 15000.0 | 6/29/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 );