filer_id | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1108845 | 2042998 | 2078526 | 2114696 | 2163275 | 2209864 | 2416187 | 2471280 | 2277084 | 2510141 | 2547557 | 2345120 | ||||||||||||
effect_dt | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2019 | 2013 | 2021 | 2023 | 2015 |
filer_id | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 483737 | 473848 | 467258 | 465194 | 488675 | 498305 | 479450 | 494729 | 496027 | 492376 | 541034 | 491074 | 468320 | 481499 | 470426 | 475937 | 478206 | 487360 | 472626 | 470426 | 628475 | 617776 | 651883 | 662969 | 675811 | 693768 | 705352 | 717679 | 743642 | 757802 | 733915 | 792335 | 781573 | 769922 | 797402 | 809748 | 812696 | 834009 | 836657 | 820323 | 836657 | 864460 | 842810 | 846466 | 854415 | 899806 | 892466 | 907340 | 883723 | 897100 | 944684 | 931064 | 912056 | 935644 | 968445 | 975835 | 976001 | 956759 | 990097 | 1012757 | 1012757 | 1027150 | 997844 | 1030782 | 1027151 | 1024886 | 1072915 | 1055274 | 1067641 | 1073789 | 1064282 | 1091468 | 1103319 | 1115502 | 1130405 | 1144202 | 1165816 | 1187905 | 1210732 | 1224263 | 1224263 | 1259980 | 1231731 | 1233661 | 1281350 | 1297832 | 1976536 | 1868733 | 1840757 | 1796600 | 1774837 | 1961227 | 1941106 | 1928513 | 1918560 | 1907309 | 1309879 | 1343422 | 1328570 | 1384502 | 1372425 | 1382839 | 1404135 | 1412491 | 1421671 | 1452577 | 1437622 | 1462456 | 1482877 | 1505640 | 1539883 | 1565440 | 1548711 | 1553409 | 1621027 | 1589501 | 1605313 | 1636194 | 1657319 | 1678974 | 1811977 | 1718675 | 1707715 | 1739284 | 1732349 | 1761810 | 1995653 | 2183253 | 2183591 | 2190956 | 2472460 | 2472495 | 2236194 | 2399922 | 2209410 | 2005423 | 2031648 | 2055405 | 2099230 | 2112636 | 2124822 | 2139885 | 2171301 | 2152126 | 2161712 | 2183253 | 2327950 | 2484426 | 2419438 | 2312692 | 2377901 | 2537218 | 2327950 | 2575851 | 2345878 | 2347482 | 2549479 | 2528521 | 2270278 | 2571125 | 2470518 | 2377901 | 2438646 | 2473242 | 2663758 | 2484426 | 2601665 | 2623151 | 2641468 | 2557745 | 2641468 | 2675495 | 2541105 | 2705055 | 2528521 | 2741093 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 152 | 158 | 149 | 141 | 146 | 156 | 159 | 155 | 148 | 147 | 145 | 154 | 157 | 144 | 142 | 143 | 151 | 153 | 150 | 142 | 161 | 160 | 161 | 162 | 163 | 163 | None | 164 | 165 | 165 | 164 | 167 | None | 166 | None | None | 168 | None | 169 | None | 169 | None | None | None | 170 | None | None | 172 | 171 | 172 | 174 | 173 | None | None | 175 | None | None | None | 176 | 177 | 177 | None | None | None | None | 178 | 180 | 179 | 180 | None | None | None | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 188 | 189 | 188 | None | 190 | 191 | 222 | 218 | 217 | 215 | 214 | 221 | None | 220 | 220 | 219 | 192 | 194 | 193 | 196 | 195 | 196 | 196 | None | 197 | 199 | 198 | 200 | 201 | 202 | 203 | 204 | 204 | None | 207 | 205 | 206 | 208 | 209 | 210 | 216 | 212 | 211 | 212 | None | 213 | 223 | 231 | None | 231 | None | None | 233 | 238 | 232 | 224 | 225 | 226 | 227 | 228 | 228 | None | 230 | 229 | None | 231 | 236 | 242 | 239 | 235 | 237 | 244 | 242 | 245 | 236 | None | 244 | 243 | 234 | None | 241 | 237 | 240 | 242 | None | 242 | 246 | 247 | 248 | None | 248 | 249 | 244 | 250 | 243 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F690 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F602 | F602 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1998-01-30 00:00:00 | 1999-07-26 00:00:00 | 1997-04-30 00:00:00 | 1995-04-28 00:00:00 | 1996-07-31 00:00:00 | 1999-01-29 00:00:00 | 1999-10-28 00:00:00 | 1998-10-29 00:00:00 | 1997-01-31 00:00:00 | 1996-10-31 00:00:00 | 1996-04-30 00:00:00 | 1998-07-31 00:00:00 | 1999-04-29 00:00:00 | 1996-01-31 00:00:00 | 1995-07-31 00:00:00 | 1995-10-31 00:00:00 | 1997-10-29 00:00:00 | 1998-04-29 00:00:00 | 1997-07-31 00:00:00 | 1996-01-31 00:00:00 | 2000-04-28 00:00:00 | 2000-01-31 00:00:00 | 2000-05-11 00:00:00 | 2000-07-31 00:00:00 | 2000-10-25 00:00:00 | 2000-10-31 00:00:00 | 2000-12-28 00:00:00 | 2001-01-30 00:00:00 | 2001-04-25 00:00:00 | 2001-04-30 00:00:00 | 2001-01-31 00:00:00 | 2001-10-31 00:00:00 | 2001-07-26 00:00:00 | 2001-07-25 00:00:00 | 2001-10-31 00:00:00 | 2002-01-18 00:00:00 | 2002-01-30 00:00:00 | 2002-03-19 00:00:00 | 2002-04-23 00:00:00 | 2002-01-31 00:00:00 | 2002-04-24 00:00:00 | 2002-07-30 00:00:00 | 2002-04-23 00:00:00 | 2002-04-24 00:00:00 | 2002-07-30 00:00:00 | 2002-12-20 00:00:00 | 2002-10-31 00:00:00 | 2003-01-28 00:00:00 | 2002-10-30 00:00:00 | 2002-12-20 00:00:00 | 2003-07-25 00:00:00 | 2003-04-30 00:00:00 | 2003-01-29 00:00:00 | 2003-04-30 00:00:00 | 2003-10-29 00:00:00 | 2003-12-30 00:00:00 | 2003-10-30 00:00:00 | 2003-07-29 00:00:00 | 2004-02-02 00:00:00 | 2004-04-29 00:00:00 | 2004-04-29 00:00:00 | 2004-04-30 00:00:00 | 2004-02-02 00:00:00 | 2004-07-28 00:00:00 | 2004-04-30 00:00:00 | 2004-07-22 00:00:00 | 2005-01-18 00:00:00 | 2004-10-27 00:00:00 | 2004-12-22 00:00:00 | 2004-12-22 00:00:00 | 2004-10-28 00:00:00 | 2005-01-25 00:00:00 | 2005-04-27 00:00:00 | 2005-07-27 00:00:00 | 2005-10-25 00:00:00 | 2006-01-25 00:00:00 | 2006-04-27 00:00:00 | 2006-07-26 00:00:00 | 2006-10-24 00:00:00 | 2006-12-21 00:00:00 | 2006-12-21 00:00:00 | 2007-04-26 00:00:00 | 2007-01-25 00:00:00 | 2006-12-22 00:00:00 | 2007-07-26 00:00:00 | 2007-10-31 00:00:00 | 2015-07-23 00:00:00 | 2014-07-29 00:00:00 | 2014-04-23 00:00:00 | 2013-10-23 00:00:00 | 2013-07-11 00:00:00 | 2015-04-23 00:00:00 | 2014-12-16 00:00:00 | 2015-01-22 00:00:00 | 2014-12-16 00:00:00 | 2014-10-28 00:00:00 | 2008-01-30 00:00:00 | 2008-07-15 00:00:00 | 2008-04-29 00:00:00 | 2008-12-18 00:00:00 | 2008-10-27 00:00:00 | 2008-12-04 00:00:00 | 2009-02-26 00:00:00 | 2008-12-23 00:00:00 | 2009-04-30 00:00:00 | 2009-11-01 00:00:00 | 2009-07-31 00:00:00 | 2010-01-28 00:00:00 | 2010-04-27 00:00:00 | 2010-07-29 00:00:00 | 2010-10-31 00:00:00 | 2011-01-25 00:00:00 | 2010-12-08 00:00:00 | 2010-12-08 00:00:00 | 2011-10-28 00:00:00 | 2011-04-28 00:00:00 | 2011-07-28 00:00:00 | 2012-01-31 00:00:00 | 2012-04-30 00:00:00 | 2012-07-31 00:00:00 | 2014-01-22 00:00:00 | 2012-12-19 00:00:00 | 2012-10-30 00:00:00 | 2013-01-31 00:00:00 | 2012-12-19 00:00:00 | 2013-04-25 00:00:00 | 2015-10-28 00:00:00 | 2017-09-06 00:00:00 | 2017-09-07 00:00:00 | 2017-10-26 00:00:00 | 2020-04-28 00:00:00 | 2020-04-30 00:00:00 | 2018-04-25 00:00:00 | 2019-07-31 00:00:00 | 2018-01-30 00:00:00 | 2016-01-21 00:00:00 | 2016-04-23 00:00:00 | 2016-07-14 00:00:00 | 2016-10-28 00:00:00 | 2016-12-20 00:00:00 | 2017-01-26 00:00:00 | 2016-12-21 00:00:00 | 2017-07-25 00:00:00 | 2017-04-20 00:00:00 | 2017-05-18 00:00:00 | 2017-09-06 00:00:00 | 2018-12-12 00:00:00 | 2020-07-30 00:00:00 | 2019-10-31 00:00:00 | 2018-10-25 00:00:00 | 2019-04-26 00:00:00 | 2020-12-16 00:00:00 | 2020-04-23 00:00:00 | 2021-04-21 00:00:00 | 2019-01-30 00:00:00 | 2018-12-27 00:00:00 | 2021-01-28 00:00:00 | 2020-10-30 00:00:00 | 2018-07-26 00:00:00 | 2020-12-31 00:00:00 | 2020-04-30 00:00:00 | 2020-11-04 00:00:00 | 2020-01-29 00:00:00 | 2020-05-20 00:00:00 | 2022-03-28 00:00:00 | 2020-08-19 00:00:00 | 2021-07-30 00:00:00 | 2021-10-29 00:00:00 | 2022-01-28 00:00:00 | 2020-12-17 00:00:00 | 2022-02-16 00:00:00 | 2022-04-30 00:00:00 | 2020-12-30 00:00:00 | 2022-07-29 00:00:00 | 2021-09-22 00:00:00 | 2022-10-25 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10002 | 10005 | 10005 | 10006 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10002 | 10005 | 10005 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10005 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10005 | 10002 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10001 | 10001 | 10002 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1999 | 1997 | 1995 | 1995 | 1997 | 1999 | 1997 | 1995 | 1995 | 1995 | 1997 | 1999 | 1995 | 1995 | 1995 | 1997 | 1997 | 1997 | 1995 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2015 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2011 | 2011 | 2013 | 2013 | 2015 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2021 | 2019 | 2021 | 2017 | 2019 | 2019 | 2019 | 2017 | 2021 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | CFLAGG | JLEHMAN | YBONILLA | * | YBONILLA | DHULSE | * | * | YBONILLA | YBONILLA | * | LTHIBAUL | * | LTHIBAUL | SARRIAGA | * | SARRIAGA | * | LTHIBAUL | * | GGILMORE | LTHIBAUL | LTHIBAUL | * | PBANFORD | MHOANG | COMPLETED | * | * | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | GGILMORE | COMPLETED | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | * | LTHIBAUL | LTHIBAUL | PBANFORD | LTHIBAUL | LTHIBAUL | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | PBANFORD | AGLADNEY | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | JINGRAM | * | JINGRAM | CFLAGG | MGUERRA | MGUERRA | MGUERRA | JINGRAM | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | * | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | ASAETERN | PBANFORD | ASAETERN | AGLADNEY | YRODRIGU | YRODRIGU | AGLADNEY | GPEREZ | GPEREZ | AGLADNEY | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | PBANFORD | AGLADNEY | AGLADNEY | GPEREZ | YRODRIGU | GPEREZ | MKIRKHAM | VUKSTINA | AGLADNEY | VUKSTINA | MMERCHANT | GPEREZ | GTAYLOR | AGLADNEY | GPEREZ | GTAYLOR | GTAYLOR | AGLADNEY | SARRIAGA | SUSHAKOV | CAFILER | GTAYLOR | CAFILER | CVANLIEW | GTAYLOR | GTAYLOR | GTAYLOR | MKIRKHAM | MMERCHANT | MKIRKHAM | CAFILER | SARRIAGA | CAFILER | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11002 | 11002 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-10-01 00:00:00 | 1999-04-01 00:00:00 | 1997-01-01 00:00:00 | 1995-01-01 00:00:00 | 1996-04-01 00:00:00 | 1998-10-01 00:00:00 | 1999-07-01 00:00:00 | 1998-07-01 00:00:00 | 1996-10-01 00:00:00 | 1996-07-01 00:00:00 | 1996-01-01 00:00:00 | 1998-04-01 00:00:00 | 1999-01-01 00:00:00 | 1995-10-01 00:00:00 | 1995-04-01 00:00:00 | 1995-07-01 00:00:00 | 1997-07-01 00:00:00 | 1998-01-01 00:00:00 | 1997-04-01 00:00:00 | 1995-04-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 1900-01-01 00:00:00 | 2001-10-01 00:00:00 | 1900-01-01 00:00:00 | 2002-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 1900-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 2002-12-12 00:00:00 | 2003-04-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2004-12-14 00:00:00 | 1900-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-06 00:00:00 | 2006-12-21 00:00:00 | 2007-01-01 00:00:00 | 2006-10-01 00:00:00 | 1900-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-07-01 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-16 00:00:00 | 2014-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2008-01-01 00:00:00 | 2008-12-04 00:00:00 | 2008-07-01 00:00:00 | 2008-12-04 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 2010-12-08 00:00:00 | 1900-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2012-11-27 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2017-09-06 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-04-01 00:00:00 | 2017-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-11-03 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-09-06 00:00:00 | 2018-12-12 00:00:00 | 2020-04-01 00:00:00 | 2019-07-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2020-12-16 00:00:00 | 2020-04-23 00:00:00 | 2021-01-01 00:00:00 | 2018-10-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2018-04-01 00:00:00 | 1900-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2020-04-22 00:00:00 | 1900-01-01 00:00:00 | 2020-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2020-12-31 00:00:00 | 2022-04-01 00:00:00 | 2020-07-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-12-31 00:00:00 | 1999-06-30 00:00:00 | 1997-03-31 00:00:00 | 1995-03-31 00:00:00 | 1996-06-30 00:00:00 | 1998-12-31 00:00:00 | 1999-09-30 00:00:00 | 1998-09-30 00:00:00 | 1996-12-31 00:00:00 | 1996-09-30 00:00:00 | 1996-03-31 00:00:00 | 1998-06-30 00:00:00 | 1999-03-31 00:00:00 | 1995-12-31 00:00:00 | 1995-06-30 00:00:00 | 1995-09-30 00:00:00 | 1997-09-30 00:00:00 | 1998-03-31 00:00:00 | 1997-06-30 00:00:00 | 1995-06-30 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 1900-01-01 00:00:00 | 2001-12-31 00:00:00 | 1900-01-01 00:00:00 | 2002-03-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 2002-12-12 00:00:00 | 2003-06-30 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-12-14 00:00:00 | 1900-01-01 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-06 00:00:00 | 2006-12-21 00:00:00 | 2007-03-31 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014-12-16 00:00:00 | 2014-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-03-31 00:00:00 | 2008-12-04 00:00:00 | 2008-09-30 00:00:00 | 2008-12-04 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-09-30 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2010-12-08 00:00:00 | 1900-01-01 00:00:00 | 2011-09-30 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2012-11-27 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2017-09-06 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 2019-06-30 00:00:00 | 2017-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-11-03 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-09-06 00:00:00 | 2018-12-12 00:00:00 | 2020-06-30 00:00:00 | 2019-09-30 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2020-12-16 00:00:00 | 2020-04-23 00:00:00 | 2021-03-31 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2018-06-30 00:00:00 | 1900-01-01 00:00:00 | 2020-03-31 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2020-04-22 00:00:00 | 1900-01-01 00:00:00 | 2020-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2020-12-31 00:00:00 | 2022-06-30 00:00:00 | 2020-09-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | None | None | 22001 | 22001 | None | None | 22001 | None | None | None | 22001 | 22001 | 22001 | None | None | None | None | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 1999 | 1997 | 1995 | 2003 | 2011 | 2007 | 2005 | 2017 | 2009 | 2013 | 2015 | 2021 | 2019 | 2023 | |||||||||||||||
interest_cd | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | |||||||||||||||
effect_date | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 1995-01-01 00:00:00 | 2003-01-01 00:00:00 | 2011-01-01 00:00:00 | 2007-01-01 00:00:00 | 2005-01-01 00:00:00 | 2017-01-01 00:00:00 | 2009-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
session_id | 1997 | 1999 | 1995 | 2001 | 2003 | 2005 | 2007 | 2013 | 2011 | 2009 | 2015 | 2021 | 2019 | 2017 | 2023 | |||||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 1995-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
election_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
nyq_dt | None | None | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | None | None | None | |||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1144107 | |
---|---|---|
xref_id | C25371 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | C25371 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | CEERT COALITION | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | 9164427785 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1144107 |
---|
filer_id | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 0 | 2 | 1 | 3 | 4 | 5 | ||||||
session_id | 2001 | 2001 | 2001 | 2017 | 2017 | 2017 | ||||||
log_dt | 2002-01-18 00:00:00 | 2002-03-19 00:00:00 | 2002-03-14 00:00:00 | 2017-09-14 00:00:00 | 2018-11-09 00:00:00 | 2018-12-28 00:00:00 | ||||||
filer_type | 1 | 2 | 2 | 2 | 1 | 1 | ||||||
correction_flg | Y | Y | Y | Y | None | None | ||||||
action | ADDED | ADDED | DELETED | ADDED | DELETED | DELETED | ||||||
attribute_changed | EMPLOYER | EMPLOYER | FIRM | FIRM | FIRM | FIRM | ||||||
ethics_dt | None | None | None | None | None | None | ||||||
interests | None | None | None | None | None | None | ||||||
filer_full_name | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | CLEAN POWER CAMPAIGN | ||||||
filer_city | None | SACRAMENTO | None | SACRAMENTO | None | None | ||||||
filer_st | None | CA | None | CA | None | None | ||||||
filer_zip | None | 95814 | None | 95814 | None | None | ||||||
filer_phone | None | 9164427785 | None | 9164427785 | None | None | ||||||
entity_type | 2 | 2 | 3 | 3 | 3 | 3 | ||||||
entity_name | ROBINSON & ASSOCIATES, INC., RICHARD | LEHMAN ENGLISH & ASSOCIATES | ROBINSON & ASSOCIATES, INC., RICHARD | TRATTENPRICE | OLLIN STRATEGIES | TRATTENPRICE CONSULTING | ||||||
entity_city | None | None | None | None | None | None | ||||||
entity_st | None | None | None | None | None | None | ||||||
entity_zip | None | None | None | None | None | None | ||||||
entity_phone | None | None | None | None | None | None | ||||||
entity_id | 1147420 | None | 1147420 | None | 1393023 | 1394663 | ||||||
responsible_officer | None | None | None | None | None | None | ||||||
effect_dt | 2002-01-15 00:00:00 | 2002-03-19 00:00:00 | 2002-03-15 00:00:00 | 2017-07-01 00:00:00 | 2018-11-01 00:00:00 | 2018-09-30 00:00:00 |
filer_id | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_period_start_dt | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2000-10-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | ||||||||
filing_period_end_dt | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | ||||||||
contribution_dt | None | None | None | None | None | None | None | None | ||||||||
recipient_name | PAULEY, FRAN | SHELLEY, KEVIN | LIU, CAROL | MURRAY, KEVIN | KELLY, DAVID | PAULEY FOR ASSEMBLY | SHELLEY FOR ASSEMBLY | |||||||||
recipient_id | 1076957 | 1071976 | 1076190 | 1071788 | 1075683 | None | 1076957 | 1071976 | ||||||||
amount | 500 | 750 | 100 | 1000 | 500 | 0 | 500 | 500 |
filer_id | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_period_start_dt | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2000-10-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | ||||||||
filing_period_end_dt | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | ||||||||
contribution_dt | None | None | None | None | None | None | None | None | ||||||||
recipient_name | PAULEY, FRAN | SHELLEY, KEVIN | LIU, CAROL | MURRAY, KEVIN | KELLY, DAVID | PAULEY FOR ASSEMBLY | SHELLEY FOR ASSEMBLY | |||||||||
recipient_id | 1076957 | 1071976 | 1076190 | 1071788 | 1075683 | None | 1076957 | 1071976 | ||||||||
amount | 500 | 750 | 100 | 1000 | 500 | 0 | 500 | 500 |
filer_id | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | 1144107 | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 675811_0.cal | 31333.cal | 31186.cal | 31101.cal | 16584.cal | 5597.cal | 717679_0.cal | 743642_0.cal | 769922_0.cal | 792335_0.cal | 812696_0.cal | 836657_1.cal | 183101.cal | 836657_0.cal | 854415_0.cal | 883723_0.cal | 897100_0.cal | 447820.cal | 447928.cal | 448000.cal | 448176.cal | 907340_0.cal | 931064_0.cal | 944684_0.cal | 968445_0.cal | 223030.cal | 223202.cal | 222158.cal | 222811.cal | 1482877_0.cal | 1297832_0.cal | 1309879_0.cal | 1565440_0.cal | |||||||||||||||||||||||||||||||||
received_date | 2000-10-25 00:00:00 | 2001-01-29 00:00:00 | 2001-01-29 00:00:00 | 2001-01-29 00:00:00 | 2001-01-30 00:00:00 | 2001-01-30 00:00:00 | 2001-01-30 00:00:00 | 2001-04-25 00:00:00 | 2001-07-25 00:00:00 | 2001-10-31 00:00:00 | 2002-01-30 00:00:00 | 2002-04-24 00:00:00 | 2002-04-23 00:00:00 | 2002-04-23 00:00:00 | 2002-07-30 00:00:00 | 2002-10-30 00:00:00 | 2002-12-20 00:00:00 | 2002-10-30 00:00:00 | 2002-10-30 00:00:00 | 2002-10-30 00:00:00 | 2002-10-30 00:00:00 | 2003-01-28 00:00:00 | 2003-04-30 00:00:00 | 2003-07-25 00:00:00 | 2003-10-29 00:00:00 | 2006-12-21 00:00:00 | 2006-12-21 00:00:00 | 2006-12-21 00:00:00 | 2006-12-21 00:00:00 | 2010-04-27 00:00:00 | 2007-10-31 00:00:00 | 2008-01-30 00:00:00 | 2011-01-25 00:00:00 | |||||||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||
filing_id | 675811 | None | None | None | None | None | 717679 | 743642 | 769922 | 792335 | 812696 | 836657 | None | 836657 | 854415 | 883723 | 897100 | None | None | None | None | 907340 | 931064 | 944684 | 968445 | None | None | None | None | 1482877 | 1297832 | 1309879 | 1565440 | |||||||||||||||||||||||||||||||||
form_id | F635 | None | None | None | None | None | F635 | F635 | F635 | F635 | F635 | F635 | None | F635 | F635 | F635 | F602 | None | None | None | None | F635 | F635 | F635 | F635 | None | None | None | None | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||
receive_comment | Filing accepted, but but with warnings | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing passed validation, but failed DB constraints | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted |