filing_id | 676141 | 719097 | 746072 | 773073 | 792248 | 812838 | 839823 | 856086 | 882778 | 908921 | 929925 | 929925 | 941564 | 965335 | 978571 | 978571 | 1010136 | 1026421 | 1056104 | 1080168 | 1100735 | 1167574 | 1130961 | 1147046 | 1118700 | 1282348 | 1261518 | 1236681 | 1190513 | 1215046 | 1369445 | 1310831 | 1294150 | 1348961 | 1329639 | 1391982 | 1566807 | 1541078 | 1622322 | 1607455 | 1590749 | 1633501 | 1707508 | 1676266 | 1656601 | 1760806 | 1733537 | 1798011 | 1130961 | 1779225 | 1815240 | 1842008 | 1905158 | 1870063 | 1977751 | 1962139 | 1935258 | 2006928 | 1994727 | 2057571 | 2030556 | 2098944 | 2171679 | 2126244 | 2155622 | 2193386 | 2271317 | 2208393 | 2235855 | 2343928 | 2314751 | 2394215 | 2378484 | 2416328 | 2438485 | 2467609 | 2467609 | 2438485 | 2526236 | 2547265 | 2481317 | 2578281 | 2601743 | 2618833 | 2670887 | 2639098 | 2702228 | 2744100 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 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 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_type | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2000-10-25 00:00:00 | 2001-01-31 00:00:00 | 2001-04-30 00:00:00 | 2001-07-31 00:00:00 | 2001-10-31 00:00:00 | 2002-01-30 00:00:00 | 2002-04-30 00:00:00 | 2002-07-31 00:00:00 | 2002-10-30 00:00:00 | 2003-01-29 00:00:00 | 2003-04-29 00:00:00 | 2003-04-29 00:00:00 | 2003-07-14 00:00:00 | 2003-10-20 00:00:00 | 2004-01-07 00:00:00 | 2004-04-21 00:00:00 | 2004-04-21 00:00:00 | 2004-07-27 00:00:00 | 2004-10-28 00:00:00 | 2005-01-31 00:00:00 | 2005-04-18 00:00:00 | 2006-05-01 00:00:00 | 2505-10-25 00:00:00 | 2006-01-30 00:00:00 | 2005-08-01 00:00:00 | 2007-07-30 00:00:00 | 2007-04-30 00:00:00 | 2007-01-31 00:00:00 | 2006-07-31 00:00:00 | 2006-10-30 00:00:00 | 2008-10-23 00:00:00 | 2008-01-31 00:00:00 | 2007-10-30 00:00:00 | 2008-07-30 00:00:00 | 2008-04-30 00:00:00 | 2009-01-26 00:00:00 | 2011-01-27 00:00:00 | 2010-11-01 00:00:00 | 2011-10-31 00:00:00 | 2011-07-30 00:00:00 | 2011-04-28 00:00:00 | 2012-01-30 00:00:00 | 2012-10-30 00:00:00 | 2012-07-28 00:00:00 | 2012-01-30 00:00:00 | 2013-04-23 00:00:00 | 2013-01-28 00:00:00 | 2013-10-30 00:00:00 | 2505-10-25 00:00:00 | 2013-07-29 00:00:00 | 2014-01-29 00:00:00 | 2014-04-29 00:00:00 | 2014-10-22 00:00:00 | 2014-07-30 00:00:00 | 2015-07-29 00:00:00 | 2015-04-26 00:00:00 | 2015-01-31 00:00:00 | 2015-01-26 00:00:00 | 2015-10-27 00:00:00 | 2016-07-24 00:00:00 | 2016-04-21 00:00:00 | 2016-10-28 00:00:00 | 2017-07-26 00:00:00 | 2017-01-29 00:00:00 | 2017-04-28 00:00:00 | 2017-10-31 00:00:00 | 2018-07-27 00:00:00 | 2018-01-30 00:00:00 | 2018-04-25 00:00:00 | 2019-01-28 00:00:00 | 2018-10-26 00:00:00 | 2019-07-27 00:00:00 | 2019-04-29 00:00:00 | 2019-10-28 00:00:00 | 2020-01-29 00:00:00 | 2020-04-26 00:00:00 | 2020-04-26 00:00:00 | 2020-01-29 00:00:00 | 2020-10-29 00:00:00 | 2021-01-26 00:00:00 | 2020-07-27 00:00:00 | 2021-04-28 00:00:00 | 2021-07-31 00:00:00 | 2021-10-25 00:00:00 | 2022-04-26 00:00:00 | 2022-01-27 00:00:00 | 2022-07-27 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2005-01-01 00:00:00 | 2006-01-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2005-04-01 00:00:00 | 2007-04-01 00:00:00 | 2007-01-01 00:00:00 | 2006-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2008-07-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2008-04-01 00:00:00 | 2008-01-01 00:00:00 | 2008-10-01 00:00:00 | 2010-10-01 00:00:00 | 2010-07-01 00:00:00 | 2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-07-01 00:00:00 | 2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2013-01-01 00:00:00 | 2012-10-01 00:00:00 | 2013-07-01 00:00:00 | 2005-07-01 00:00:00 | 2013-04-01 00:00:00 | 2013-10-01 00:00:00 | 2014-01-01 00:00:00 | 2014-07-01 00:00:00 | 2014-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | 2017-04-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-10-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 2006-03-31 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2005-06-30 00:00:00 | 2007-06-30 00:00:00 | 2007-03-31 00:00:00 | 2006-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2008-09-30 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2008-06-30 00:00:00 | 2008-03-31 00:00:00 | 2008-12-31 00:00:00 | 2010-12-31 00:00:00 | 2010-09-30 00:00:00 | 2011-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-06-30 00:00:00 | 2012-03-31 00:00:00 | 2013-03-31 00:00:00 | 2012-12-31 00:00:00 | 2013-09-30 00:00:00 | 2005-09-30 00:00:00 | 2013-06-30 00:00:00 | 2013-12-31 00:00:00 | 2014-03-31 00:00:00 | 2014-09-30 00:00:00 | 2014-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 2017-09-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2005-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | None | None | None | None | None | None | None | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_name | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | None | None | None | None | None | None | None | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_city | SAINT LOUIS MO | SAINT LOUIS MO | SAINT LOUIS MO | SAINT LOUIS MO | SAINT LOUIS MO | SAINT LOUIS, MO | SAINT LOUIS, MO | SAINT LOUIS, MO | SAINT LOUIS, MO | SAINT LOUIS, MO | ST. LOUIS | ST. LOUIS | ST. LOUIS | ST. LOUIS | ST. LOUIS | ST. LOUIS | ST. LOUIS | St. Louis | St. Louis | St. Louis | St. Louis | St. Louis | St. Louis | St. Louis | St. Louis | St. Louis | St. Louis | St. Louis | St. Louis | St. Louis | NAPA | St. Louis | St. Louis | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | St. Louis | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ST LOUIS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_st | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | CA | MO | MO | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | MO | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | MO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_zip4 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 94558 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | 63105 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | 314/725-0800 | 314/725-0800 | 314/725-0800 | 314/725-0800 | 314/725-0800 | 314/725-0800 | 314/725-0800 | 314/725-0800 | 314/725-0800 | 314/725-0800 | 3147250800 | 3147250800 | 3147250800 | 3147250800 | 3147250800 | 3147250800 | 3147250800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 707-944-8456 | 314-725-0800 | 314-725-0800 | 707-944-8456 | 707-944-8456 | 707-944-8456 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 314-725-0800 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | 314-725-0800 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_date | 2000-10-31 00:00:00 | 2001-01-31 00:00:00 | 2001-04-30 00:00:00 | None | 2001-10-31 00:00:00 | None | None | None | None | None | 2003-04-28 00:00:00 | 2003-04-28 00:00:00 | 2003-07-15 00:00:00 | 2003-10-20 00:00:00 | 2004-01-13 00:00:00 | 2004-04-21 00:00:00 | 2004-04-21 00:00:00 | 2004-07-21 00:00:00 | 2004-10-19 00:00:00 | 2005-01-21 00:00:00 | 2005-04-15 00:00:00 | 2006-04-19 00:00:00 | 2005-10-25 00:00:00 | 2006-01-30 00:00:00 | 2005-07-27 00:00:00 | 2007-07-30 00:00:00 | 2007-04-27 00:00:00 | 2007-01-30 00:00:00 | 2006-07-27 00:00:00 | 2006-10-25 00:00:00 | 2008-10-23 00:00:00 | 2008-01-29 00:00:00 | 2007-10-24 00:00:00 | 2008-07-30 00:00:00 | 2008-04-28 00:00:00 | 2009-01-22 00:00:00 | 2011-01-26 00:00:00 | 2010-11-01 00:00:00 | 2011-10-28 00:00:00 | 2011-07-28 00:00:00 | 2011-04-28 00:00:00 | 2012-01-27 00:00:00 | 2012-10-30 00:00:00 | 2012-07-27 00:00:00 | 2012-04-26 00:00:00 | 2013-04-23 00:00:00 | 2013-01-28 00:00:00 | 2013-10-28 00:00:00 | 2013-10-31 00:00:00 | 2013-07-29 00:00:00 | 2014-01-29 00:00:00 | 2014-04-25 00:00:00 | 2014-10-24 00:00:00 | 2014-07-29 00:00:00 | 2015-07-27 00:00:00 | 2015-04-27 00:00:00 | 2015-01-29 00:00:00 | 2016-01-26 00:00:00 | 2015-10-27 00:00:00 | 2016-07-22 00:00:00 | 2016-04-21 00:00:00 | 2016-10-28 00:00:00 | 2017-07-25 00:00:00 | 2016-01-27 00:00:00 | 2017-04-28 00:00:00 | 2017-10-31 00:00:00 | 2018-07-27 00:00:00 | 2018-01-30 00:00:00 | 2018-04-25 00:00:00 | 2019-01-29 00:00:00 | 2018-10-28 00:00:00 | 2019-07-26 00:00:00 | 2019-04-29 00:00:00 | 2019-10-28 00:00:00 | 2020-04-29 00:00:00 | 2020-04-29 00:00:00 | 2020-04-26 00:00:00 | 2020-01-29 00:00:00 | 2020-10-29 00:00:00 | 2021-01-26 00:00:00 | 2020-07-27 00:00:00 | 2021-04-28 00:00:00 | 2021-07-31 00:00:00 | 2021-10-25 00:00:00 | 2022-04-26 00:00:00 | 2022-01-27 00:00:00 | 2022-07-27 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_loc | SAINT LOUIS MO | SAINT LOUIS MO | SAINT LOUIS MO | SAINT LOUIS MO | SAINT LOUIS MO | SAINT LOUIS, MO | NEW ORLEANS, LA | ST. LOUIS, MISSOURI | ST. LOUIS, MISSOURI | ST. LOUIS, MISSOURI | ST. LOUIS MISSOURI | ST. LOUIS MISSOURI | St. Louis Missouri | St Louis Missouri | ST LOUIS MISSOURI | ST LOUIS, MO | ST LOUIS, MO | ST LOUIS MO | ST LOUIS MO | ST LOUIS MO | ST LOUIS MO | NAPA CA | NAPA CA | SANTA ROSA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | ST LOUIS MO | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | ST LOUIS MO | ST LOUIS MO | NAPA CA | ST LOUIS MO | ST LOUIS MO | ST LOUIS MO | ST LOUIS MO | ST LOUIS MO | ST LOUIS MO | NAPA CA | ST. LOUIS MO | ST. LOUIS MO | ST. LOUIS MO | ST. LOUIS MO | ST. LOUIS MO | ST. LOUIS MO | ST. LOUIS MO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | ZAJAC | ZAJAC | ZAJAC | ZAJAC | ZAJAC | ZAJAC | STULL | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | Brennan | Brennan | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNEN | BRENNEN | BRENNAN | BRENNAN | BRENNEN | BRENNAN | BRENNEN | BRENNEN | BRENNEN | BRENNEN | BRENNAN | BRENNEN | RYAN | BRENNEN | BRENNEN | BRENNEN | BRENNEN | BRENNAN | BRENNAN | BRENNEN | BRENNAN | BRENNAN | BRENNEN | BRENNAN | BRENNAN | BRENNEN | BRENNAN | BRENNAN | BRENNAN | BRENNEN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | MOTIKA | MOTIKA | MOTIKA | MOTIKA | MOTIKA | MOTIKA | MOTIKA | DRESSLER | DRESSLER | DRESSLER | DRESSLER | DRESSLER | DRESSLER | DRESSLER | CONIARIS | DRESSLER | CONIARIS | CONIARIS | CONIARIS | CONIARIS | CONIARIS | CONIARIS | DRESSLER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | SCOTT | SCOTT | SCOTT | SCOTT | SCOTT | SCOTT | STEVEN T. | RYAN M. | RYAN M. | RYAN M. | RYAN M. | RYAN M. | Ryan | Ryan | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | BRENNEN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | JUSTIN | JUSTIN | JUSTIN | JUSTIN | JUSTIN | JUSTIN | JUSTIN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | CHLOE | RYAN | CHLOE | CHLOE | CHLOE | CHLOE | CHLOE | CHLOE | RYAN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_naml | ZAJAC | ZAJAC | ZAJAC | ZAJAC | ZAJAC | ZAJAC | STULL | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | Brennan | Brennan | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNEN | BRENNEN | BRENNAN | BRENNAN | BRENNEN | BRENNAN | BRENNEN | BRENNEN | BRENNEN | BRENNEN | BRENNAN | BRENNEN | RYAN | BRENNEN | BRENNEN | BRENNEN | BRENNEN | BRENNAN | BRENNAN | BRENNEN | BRENNAN | BRENNAN | BRENNEN | BRENNAN | BRENNAN | BRENNEN | BRENNAN | BRENNAN | BRENNAN | BRENNEN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | MOTIKA | MOTIKA | MOTIKA | MOTIKA | MOTIKA | MOTIKA | MOTIKA | DRESSLER | DRESSLER | DRESSLER | DRESSLER | DRESSLER | DRESSLER | DRESSLER | CONIARIS | DRESSLER | CONIARIS | CONIARIS | CONIARIS | CONIARIS | CONIARIS | CONIARIS | DRESSLER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namf | SCOTT | SCOTT | SCOTT | SCOTT | SCOTT | SCOTT | STEVEN T. | RYAN M. | RYAN M. | RYAN M. | RYAN M. | RYAN M. | Ryan | Ryan | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | BRENNEN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | JUSTIN | JUSTIN | JUSTIN | JUSTIN | JUSTIN | JUSTIN | JUSTIN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | RYAN | CHLOE | RYAN | CHLOE | CHLOE | CHLOE | CHLOE | CHLOE | CHLOE | RYAN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_title | PRESIDENT | PRESIDENT | MANANGING DIRECTOR | MANANGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | PRESIDENT | DIRECTOR OF DEVELOPMENT | DIRECTOR OF DEVELOPMENT | DIRECTOR OF DEVELOPMENT | DIRECTOR OF DEVELOPMENT | DIRECTOR OF DEVELOPMENT | Director of Development | Director of Develpment | DIRECTOR OF DEVELOPMENT | DIRECTOR OF DEVELOPMENT | DIRECTOR OF DEVELOPMENT | DIRECTOR OF DEVELOPMENT | DIRECTOR OF DEVELOPMENT | DIRECTOR OF DEVELOPMENT | DIRECTOR OF DEVELOPMENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | PRESIDENT | MANAGING DIRECTOR | SENIOR VICE PRESIDENT | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING PARTNER | MANGAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | SENIOR ASSOCIATE | SENIOR ASSOCIATE | SENIOR ASSOCIATE | SENIOR ASSOCIATE | SENIOR ASSOCIATE | SENIOR ASSOCIATE | SENIOR ASSOCIATE | PRINCIPAL | PRINCIPAL | PRINCIPAL | PRINCIPAL | PRINCIPAL | PRINCIPAL | PRINCIPAL | ASSOCIATE | PRINCIPAL | ASSOCIATE | ASSOCIATE | ASSOCIATE | ASSOCIATE | ASSOCIATE | ASSOCIATE | PRINCIPAL | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
part1_1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
part1_2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_n_cb | None | None | None | None | None | None | None | None | None | None | None | X | X | X | None | None | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_y_cb | X | X | X | X | X | X | X | X | X | X | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lby_actvty | SB 1151 | NONE | SB 24 | SB 24 | NONE | NONE | NONE | NONE | NONE | NONE | NONE | NONE | none | NONE | None | None | NONE | None | NONE | NONE | AB957 | AB957 | AB957 AB251 | none | AB957 AB251 | NONE | NONE | NONE | NONE | NONE | NONE | NONE | NONE | NONE | NONE | NONE | NONE | SB1316 | NONE | NONE | NONE | NONE | NONE | AB 643; AB 2037 | AB 643; AB 2037 | AB 305 | NONE | AB 1399 | AB 305; AB1399; GO-Biz; New Market Tax Credit | AB 305 NEW MARKETS TAX CREDIT (GOVERNOR'S OFFICE STATE LEGISLATURE) | NONE | AB 1399 | AB 1399 | AB 1399 | AB185 | AB185 | NONE | NONE | NONE | NONE | AB2647 | NONE | NONE | NONE | AB 1715; AB 1716 | NONE | NONE | NONE | NONE | NONE | AB 1715 | TAX CREDIT PROPOSAL DISCUSSIONS WITH THE GOVERNOR'S OFFICE OF BUSINESS & ECONOMIC DEVELOPMENT OFFICE OF THE TREASURER OFFICE OF THE LT. GOVERNOR AND THE LEGISLATURE | TAX CREDIT PROPOSAL DISCUSSIONS WITH GOVERNOR'S OFFICE OF BUSINESS & ECONOMIC DEVELOPMENT OFFICE OF THE TREASURER OFFICE OF THE LT. GOVERNOR AND THE LEGISLATURE | TAX CREDIT PROPOSAL DISCUSSIONS WITH THE GOVERNOR'S OFFICE OF BUSSINESS AND ECONOMIC DEVELOPMENT OFFICE OF THE TRREASURER OFFICE OF THE LT. GOVERNOR AND THE LEGISLATURE | TAX CREDIT PROPOSAL | SB 1210; TAX CREDIT PROPOSAL DISCUSSIONS OFFICE OF THE TREASURER AND LEGISLATURE | SB 1210 | TAX CREDIT PROPOSAL | SB 1210; SB 1447 TAX CREDIT PROPOSAL | TAX CREDITS; TAX CREDIT PROPOSAL DISCUSSIONS OFFICE OF THE TREASURER AND LEGISLATURE AND GOVERNOR'S OFFICE | SB 1210; TAX CREDIT PROPOSAL | SB 777 - CA LEGISLATURE/GOVERNOR'S OFFICE | SB 777 - CA LEGISLATURE; GOVERNOR'S OFFICE; AND TREASURER'S OFFICE | SB 777 - CA LEGISLATURE; GOVERNOR'S OFFICE; AND TREASURER'S OFFICE | SB 777 - CA LEGISLATURE; GOVERNOR'S OFFICE; AND TREASURER'S OFFICE | SB 777 - CA LEGISLATURE; GOVERNOR'S OFFICE; AND TREASURER'S OFFICE | SB 777 - CA LEGISLATURE; GOVERNOR'S OFFICE; ADMINISTRATION; AND TREASURER'S OFFICE | SB 777 - CA LEGISLATURE; GOVERNOR'S OFFICE; ADMINISTRATION; AND TREASURER'S OFFICE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rcpcmte_nm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_id | 1069030 | 1225691 | 1498921 | 1556324 | 1721638 | 1922381 | 2115262 | 2329458 | 2333987 | 2538516 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||
form_type | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | ||||||||||
sender_id | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | F00895 | 1303078 | F00895 | ||||||||||
filer_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | ||||||||||
entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | ||||||||||
filer_naml | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL | ||||||||||
filer_namf | None | None | None | None | None | None | None | None | None | None | ||||||||||
filer_namt | None | None | None | None | None | None | None | None | None | None | ||||||||||
filer_nams | None | None | None | None | None | None | None | None | None | None | ||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||
rpt_date | 2004-12-14 00:00:00 | 2006-12-26 00:00:00 | 2010-06-29 00:00:00 | 2010-12-29 00:00:00 | 2012-12-10 00:00:00 | 2014-12-08 00:00:00 | 2016-11-29 00:00:00 | 2018-11-09 00:00:00 | 2019-01-11 00:00:00 | 2020-12-07 00:00:00 | ||||||||||
ls_beg_yr | 2005 | 2007 | 2009 | 2011 | 2013 | 2015 | 2017 | 2019 | 2019 | 2021 | ||||||||||
ls_end_yr | 2006 | 2008 | 2010 | 2012 | 2014 | 2016 | 2018 | 2020 | 2020 | 2022 | ||||||||||
qual_date | None | None | None | None | None | None | None | None | None | None | ||||||||||
eff_date | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||||||||
bus_city | St. Louis | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST LOUIS | ||||||||||
bus_st | MO | CA | CA | CA | CA | CA | CA | CA | MO | MO | ||||||||||
bus_zip4 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | ||||||||||
bus_phon | 314/725-0800 | 707-945-0490 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 707-944-2310 | 3147250800 | 314-725-0800 | ||||||||||
bus_fax | None | None | None | None | None | None | None | None | None | None | ||||||||||
bus_email | None | None | None | None | None | None | None | None | None | None | ||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | ||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | ||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | ||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | ||||||||||
sig_date | 2004-12-15 00:00:00 | 2006-12-26 00:00:00 | 2010-06-29 00:00:00 | 2010-12-20 00:00:00 | 2012-12-10 00:00:00 | 2014-12-11 00:00:00 | 2016-12-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2020-12-07 00:00:00 | ||||||||||
sig_loc | ST LOUIS MO | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | NAPA CA | None | ST LOUIS MO | ||||||||||
sig_naml | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNAN | BRENNEN | BRENNEN | MOTIKA | Dressler | CONIARIS | ||||||||||
sig_namf | RYAN M. | RYAN M. | RYAN | RYAN | RYAN | RYAN | RYAN | JUSTIN | Ryan | CHLOE | ||||||||||
sig_namt | None | None | DIRECTOR | None | None | None | None | None | None | None | ||||||||||
sig_nams | None | None | None | None | None | None | None | None | None | None | ||||||||||
prn_naml | None | None | None | None | None | None | None | None | Dressler | None | ||||||||||
prn_namf | None | None | None | None | None | None | None | None | Ryan | None | ||||||||||
prn_namt | None | None | None | None | None | None | None | None | None | None | ||||||||||
prn_nams | None | None | None | None | None | None | None | None | None | None | ||||||||||
sig_title | PRESIDENT | PRESIDENT | None | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | MANAGING DIRECTOR | SENIOR ASSOCIATE | Principal | ASSOCIATE | ||||||||||
stmt_firm | None | None | None | None | None | None | None | None | None | None | ||||||||||
ind_cb | None | None | None | None | None | None | None | None | None | None | ||||||||||
bus_cb | None | None | None | None | None | None | None | None | X | None | ||||||||||
trade_cb | X | X | X | X | X | X | X | X | None | X | ||||||||||
oth_cb | None | None | None | None | None | None | None | None | None | None | ||||||||||
a_b_name | None | None | None | None | None | None | None | None | None | None | ||||||||||
a_b_city | None | None | None | None | None | None | None | None | None | None | ||||||||||
a_b_st | None | None | None | None | None | None | None | None | None | None | ||||||||||
a_b_zip4 | None | None | None | None | None | None | None | None | None | None | ||||||||||
descrip_1 | ORGANIZATION FORMED TO PROMOTE CAPITAL FORMATION ISSUES IN THE STATE ARENA | ORGANIZATION FORMED TO PROMOTE CAPITAL FORMATION ISSUES IN THE STATE ARENA | ORGANIZATION FORMED TO PROMOTE CAPITAL FORMATION ISSUES IN THE STATE ARENA | ORGANIZATION FORMED TO PROMOTE CAPITAL FORMATION ISSUES IN THE STATE ARENA | ORGANIZATION FORMED TO PROMOTE CAPITAL FORMATION ISSUES IN THE STATE ARENA | ORGANIZATION FORMED TO PROMOTE CAPITAL FORMATION ISSUES IN THE STATE ARENA | ORGANIZATION FORMED TO PROMOTE CAPITAL FORMATION ISSUES IN THE STATE ARENA | ORGANIZATION FORMED TO PROMOTE CAPITAL FORMATION ISSUES IN THE STATE ARENA. | Investment adviser | ORGANIZATION FORMED TO PROMOTE CAPITAL FORMATION ISSUES IN THE STATE ARENA. | ||||||||||
descrip_2 | NONE | NONE | None | None | None | None | None | None | None | ORGANIZATION FORMED TO PROMOTE CAPITAL FORMATION ISSUES IN THE STATE ARENA. | ||||||||||
c_less50 | None | None | None | None | None | None | None | None | None | None | ||||||||||
c_more50 | X | X | X | X | X | X | X | X | None | X | ||||||||||
ind_class | OTH | OTH | OTH | OTH | OTH | OTH | OTH | OTH | None | OTH | ||||||||||
ind_descr | CAPITAL ISSUES | CAPITAL ISSUES | CAPITAL ISSUES | CAPITAL ISSUES | CAPITAL ISSUES | CAPITAL ISSUES | CAPITAL ISSUES | CAPITAL ISSUES | None | CAPITAL ISSUES | ||||||||||
bus_class | None | None | None | None | None | None | None | None | FIN | None | ||||||||||
bus_descr | None | None | None | None | None | None | None | None | None | None | ||||||||||
auth_name | LANG HANSEN O'MALLEY & MILLER | LANG HANSEN O'MALLEY & MILLER | LANG HANSEN O'MALLEY & MILLER | LANG HANSEN O'MALLEY & MILLER | LANG HANSEN O'MALLEY & MILLER | LANG HANSEN O'MALLEY & MILLLER | LANG HANSEN O'MALLEY & MILLER | LANG HANSEN O'MALLEY & MILLER | Government Relations Counsel | LANG HANSEN GIROUX & KIDANE | ||||||||||
auth_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | SACRAMENTO | ||||||||||
auth_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||
auth_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||
lobby_int | None | None | None | None | None | None | None | None | None | None | ||||||||||
influen_yn | None | None | None | None | None | None | None | None | None | None | ||||||||||
firm_name | None | None | None | None | None | None | None | None | None | None | ||||||||||
newcert_cb | None | None | None | None | None | None | None | None | None | None | ||||||||||
rencert_cb | None | None | None | None | None | None | None | None | None | None | ||||||||||
complet_dt | None | None | None | None | None | None | None | None | None | None | ||||||||||
lby_reg_cb | None | None | None | None | None | None | None | None | None | None | ||||||||||
lby_604_cb | None | None | None | None | None | None | None | None | None | None | ||||||||||
st_leg_yn | None | None | None | None | None | None | None | None | None | None | ||||||||||
st_agency | None | None | None | None | None | None | None | None | None | None | ||||||||||
lobby_cb | None | None | None | None | None | None | None | None | None | None | ||||||||||
l_firm_cb | None | None | None | None | None | None | None | None | None | None |
filing_date | 2001-01-31 00:00:00 | 2001-01-31 00:00:00 | 2001-01-31 00:00:00 | 2001-01-31 00:00:00 | 2001-01-31 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-10-31 00:00:00 | 2001-10-31 00:00:00 | 2002-01-30 00:00:00 | 2002-01-30 00:00:00 | 2002-01-30 00:00:00 | 2002-04-30 00:00:00 | 2002-04-30 00:00:00 | 2002-07-31 00:00:00 | 2002-07-31 00:00:00 | 2002-10-30 00:00:00 | 2002-10-30 00:00:00 | 2003-01-29 00:00:00 | 2003-01-29 00:00:00 | 2003-02-05 00:00:00 | 2003-02-05 00:00:00 | 2003-02-05 00:00:00 | 2003-04-29 00:00:00 | 2003-04-29 00:00:00 | 2003-04-29 00:00:00 | 2003-04-29 00:00:00 | 2003-07-14 00:00:00 | 2003-07-14 00:00:00 | 2003-10-20 00:00:00 | 2003-10-20 00:00:00 | 2004-01-07 00:00:00 | 2004-01-07 00:00:00 | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filingstatus | 2 | 2 | 2 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 2 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 2 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | |||||||||||||||||||||||||||||||||||
vendor | vendor | vendor | vendor | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | vendor | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | vendor | RACE-TRAX FOR LOBBYISTS | RACE-TRAX FOR LOBBYISTS | CAL-ACCESS OBJECT MODEL | CAL-ACCESS OBJECT MODEL | CAL-ACCESS OBJECT MODEL | CAL-ACCESS OBJECT MODEL | CAL-ACCESS OBJECT MODEL | CAL-ACCESS OBJECT MODEL | CAL-ACCESS OBJECT MODEL | CAL-ACCESS OBJECT MODEL | CAL-ACCESS OBJECT MODEL | CAL-ACCESS OBJECT MODEL | |||||||||||||||||||||||||||||||||||
filer_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | |||||||||||||||||||||||||||||||||||
form_type | form | form | form | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | form | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | form | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||
error_no | BADFORMAT 254 | BADFORMAT 254 | BADFORMAT 254 | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | BADFORMAT 254 | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | BADFORMAT 254 | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED |
filer_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2027682 | 2003947 | 2002621 | 2041773 | 2077948 | 2116715 | 2190309 | 2205058 | 2504971 | 2415038 | 2471765 | 2278814 | 2547230 | 2341999 | ||||||||||||||
effect_dt | 2002-01-30 00:00:00 | 2000-08-18 00:00:00 | 2000-07-12 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2013-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 | 7051 | 7051 | ||||||||||||||
session_id | 2001 | 1999 | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2021 | 2017 | 2019 | 2013 | 2023 | 2015 |
filer_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 639335 | 676141 | 729013 | 719097 | 695439 | 701915 | 746072 | 756466 | 792248 | 797610 | 781013 | 773073 | 815791 | 812838 | 839823 | 842742 | 822930 | 864472 | 893942 | 856086 | 897272 | 882778 | 912767 | 929925 | 941284 | 941285 | 941286 | 941287 | 941288 | 936316 | 941564 | 908921 | 929925 | 949354 | 978571 | 965335 | 973396 | 1010136 | 997854 | 1026421 | 978571 | 1018035 | 1056104 | 1036354 | 1019288 | 1069030 | 1065840 | 1093294 | 1081256 | 1080168 | 1100735 | 1118700 | 1130961 | 1147046 | 1167574 | 1190513 | 1215046 | 1225691 | 1242920 | 1236681 | 1282348 | 1261518 | 1294150 | 1779225 | 1962139 | 1870063 | 1798011 | 1130961 | 1945757 | 1935258 | 1922381 | 1905158 | 1310831 | 1329639 | 1348961 | 1369445 | 1391982 | 1498921 | 1499497 | 1557451 | 1556324 | 1566807 | 1541078 | 1607455 | 1590749 | 1633501 | 1622322 | 1656601 | 1676266 | 1815240 | 1707508 | 1721638 | 1733537 | 1733562 | 1842008 | 1760806 | 1977751 | 2416328 | 2467609 | 2314751 | 2364434 | 2208393 | 2193386 | 2353510 | 2333987 | 2329458 | 2006928 | 1994727 | 2030556 | 2057571 | 2098944 | 2115262 | 2126244 | 2123910 | 2155622 | 2171679 | 2271317 | 2378484 | 2526236 | 2343928 | 2538516 | 2481317 | 2235855 | 2438485 | 2394215 | 2467609 | 2578281 | 2559716 | 2547265 | 2438485 | 2599833 | 2601743 | 2702228 | 2670887 | 2618833 | 2639098 | 2744100 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | None | 163 | 164 | 164 | 163 | None | 165 | 165 | 167 | None | None | 166 | None | 168 | 169 | None | None | None | None | 170 | None | 171 | None | 173 | 168 | 169 | 170 | 171 | 172 | None | 174 | 172 | 173 | 174 | 176 | 175 | None | 177 | None | 178 | 176 | None | 179 | None | None | 180 | None | None | None | 180 | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | None | 188 | 190 | 189 | 191 | 214 | 221 | 218 | 215 | 183 | None | 220 | 220 | 219 | 192 | 193 | 194 | 195 | 196 | 202 | None | None | 204 | 204 | 203 | 206 | 205 | 208 | 207 | 209 | 210 | 216 | 211 | 212 | 212 | None | 217 | 213 | 222 | 239 | 241 | 235 | None | 232 | 231 | None | 237 | 236 | 224 | 223 | 225 | 226 | 227 | 228 | 228 | None | 229 | 230 | 234 | 237 | 243 | 236 | 244 | 242 | 233 | 240 | 238 | 241 | 245 | None | 244 | 240 | None | 246 | 250 | 249 | 247 | 248 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F605 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F690 | F690 | F690 | F690 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 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 | 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 | 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 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2000-07-12 00:00:00 | 2000-10-25 00:00:00 | 2001-01-29 00:00:00 | 2001-01-31 00:00:00 | 2000-10-31 00:00:00 | 2000-12-22 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-10-31 00:00:00 | 2001-10-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2002-01-31 00:00:00 | 2002-01-30 00:00:00 | 2002-04-30 00:00:00 | 2002-05-02 00:00:00 | 2002-01-31 00:00:00 | 2002-07-31 00:00:00 | 2002-10-30 00:00:00 | 2002-07-31 00:00:00 | 2002-12-18 00:00:00 | 2002-10-30 00:00:00 | 2003-01-29 00:00:00 | 2003-04-29 00:00:00 | 2003-07-07 00:00:00 | 2003-07-07 00:00:00 | 2003-07-07 00:00:00 | 2003-07-07 00:00:00 | 2003-07-07 00:00:00 | 2003-04-30 00:00:00 | 2003-07-14 00:00:00 | 2003-01-29 00:00:00 | 2003-04-29 00:00:00 | 2003-07-30 00:00:00 | 2004-01-07 00:00:00 | 2003-10-20 00:00:00 | 2003-10-31 00:00:00 | 2004-04-21 00:00:00 | 2004-02-02 00:00:00 | 2004-07-27 00:00:00 | 2004-04-21 00:00:00 | 2004-04-30 00:00:00 | 2004-10-28 00:00:00 | 2004-08-02 00:00:00 | 2004-04-30 00:00:00 | 2004-12-30 00:00:00 | 2004-11-01 00:00:00 | 2005-01-31 00:00:00 | 2004-12-30 00:00:00 | 2005-01-31 00:00:00 | 2005-04-18 00:00:00 | 2005-08-01 00:00:00 | 2005-10-26 00:00:00 | 2006-01-30 00:00:00 | 2006-05-01 00:00:00 | 2006-07-31 00:00:00 | 2006-10-30 00:00:00 | 2007-01-02 00:00:00 | 2007-01-02 00:00:00 | 2007-01-31 00:00:00 | 2007-07-29 00:00:00 | 2007-04-30 00:00:00 | 2007-10-23 00:00:00 | 2013-07-28 00:00:00 | 2015-04-26 00:00:00 | 2014-07-30 00:00:00 | 2013-10-28 00:00:00 | 2013-10-31 00:00:00 | 2014-12-30 00:00:00 | 2015-01-31 00:00:00 | 2014-12-31 00:00:00 | 2014-10-24 00:00:00 | 2008-01-31 00:00:00 | 2008-04-30 00:00:00 | 2008-07-30 00:00:00 | 2008-10-23 00:00:00 | 2009-01-26 00:00:00 | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2010-12-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-26 00:00:00 | 2010-11-01 00:00:00 | 2011-07-30 00:00:00 | 2011-04-29 00:00:00 | 2012-01-29 00:00:00 | 2011-10-31 00:00:00 | 2012-04-29 00:00:00 | 2012-07-28 00:00:00 | 2014-01-29 00:00:00 | 2012-10-30 00:00:00 | 2012-12-29 00:00:00 | 2013-01-28 00:00:00 | 2012-12-28 00:00:00 | 2014-04-27 00:00:00 | 2013-04-23 00:00:00 | 2015-07-27 00:00:00 | 2019-10-28 00:00:00 | 2020-04-29 00:00:00 | 2018-10-28 00:00:00 | 2019-01-10 00:00:00 | 2018-01-30 00:00:00 | 2017-10-31 00:00:00 | 2018-12-21 00:00:00 | 2019-01-11 00:00:00 | 2018-12-21 00:00:00 | 2016-01-26 00:00:00 | 2015-10-27 00:00:00 | 2016-04-21 00:00:00 | 2016-07-24 00:00:00 | 2016-10-28 00:00:00 | 2016-12-29 00:00:00 | 2017-01-29 00:00:00 | 2016-12-29 00:00:00 | 2017-04-28 00:00:00 | 2017-07-26 00:00:00 | 2018-07-28 00:00:00 | 2019-04-29 00:00:00 | 2020-10-29 00:00:00 | 2019-01-29 00:00:00 | 2020-12-28 00:00:00 | 2020-07-27 00:00:00 | 2018-04-25 00:00:00 | 2020-04-29 00:00:00 | 2019-07-27 00:00:00 | 2020-04-26 00:00:00 | 2021-04-28 00:00:00 | 2020-12-23 00:00:00 | 2021-01-26 00:00:00 | 2020-01-29 00:00:00 | 2021-02-05 00:00:00 | 2021-07-31 00:00:00 | 2022-07-27 00:00:00 | 2022-04-26 00:00:00 | 2021-10-25 00:00:00 | 2022-01-27 00:00:00 | 2022-10-27 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10002 | 10006 | 10006 | 10006 | 10006 | 10006 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10002 | 10005 | 10001 | 10005 | 10006 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 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 | 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 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2003 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2013 | 2015 | 2013 | 2013 | 2005 | 2015 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2011 | 2011 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2013 | 2011 | 2013 | 2013 | 2013 | 2015 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2021 | 2019 | 2017 | 2019 | 2019 | 2019 | 2021 | 2021 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | GPEREZ | * | YBONILLA | * | YBONILLA | GGILMORE | * | DBARRICK | * | LTHIBAUL | LTHIBAUL | * | GPEREZ | * | * | LTHIBAUL | GGILMORE | LTHIBAUL | LTHIBAUL | * | BSMITH | * | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | EMCENTEE | COMPLETED | LTHIBAUL | LTHIBAUL | SARRIAGA | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | PBANFORD | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | AGLADNEY | MPACHECO | AGLADNEY | AGLADNEY | ASAETERN | SARRIAGA | MPACHECO | SARRIAGA | AGLADNEY | LTHIBAUL | LTHIBAUL | YRODRIGU | EMCENTEE | MGUERRA | YRODRIGU | YRODRIGU | SARRIAGA | * | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | GKURIMOT | ASAETERN | GKURIMOT | AGLADNEY | AGLADNEY | MPACHECO | SUSHAKOV | SUSHAKOV | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | SARRIAGA | GPEREZ | SARRIAGA | AGLADNEY | MPACHECO | JINGRAM | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | GPEREZ | MPACHECO | AGLADNEY | AGLADNEY | GTAYLOR | GTAYLOR | AGLADNEY | MMERCHANT | CVANLIEW | AGLADNEY | SUSHAKOV | AGLADNEY | VUKSTINA | CHATRIDGE | MMERCHANT | JMAVES | AGLADNEY | CVANLIEW | MKIRKHAM | CAFILER | CAFILER | GTAYLOR | CHATRIDGE | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11002 | 11002 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 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 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 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 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | None | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2000-10-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 1900-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-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 | 2003-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-04-01 00:00:00 | 2003-10-01 00:00:00 | 2004-12-14 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 1900-01-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-26 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 2007-01-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2005-07-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-08 00:00:00 | 2014-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 2010-06-29 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2010-12-29 00:00:00 | 2010-10-01 00:00:00 | 2010-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2012-07-01 00:00:00 | 2012-12-10 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-04-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-01-11 00:00:00 | 2018-11-09 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-11-29 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-04-01 00:00:00 | 2019-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-10-01 00:00:00 | 2020-12-07 00:00:00 | 2020-04-01 00:00:00 | 2018-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-04-01 00:00:00 | 2020-01-01 00:00:00 | 2021-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | None | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 1900-01-01 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-03-31 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 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 | 2003-03-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-09-30 00:00:00 | 2004-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-12-14 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 1900-01-01 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-26 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2007-03-31 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2005-09-30 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014-12-08 00:00:00 | 2014-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 2010-06-29 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2010-12-29 00:00:00 | 2010-12-31 00:00:00 | 2010-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-12-10 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-06-30 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 2019-01-11 00:00:00 | 2018-11-09 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-11-29 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2019-03-31 00:00:00 | 2020-09-30 00:00:00 | 2018-12-31 00:00:00 | 2020-12-07 00:00:00 | 2020-06-30 00:00:00 | 2018-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-06-30 00:00:00 | 2020-03-31 00:00:00 | 2021-03-31 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22006 | None | None | None | None | None | None | 22006 | 22001 | 22006 | None | 22006 | 22006 | None | 22006 | None | 22001 | 22006 | None | 22001 | None | None | 22001 | None | None | None | 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 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 1999 | 2003 | 2005 | 2011 | 2013 | 2007 | 2009 | 2015 | 2019 | 2017 | 2023 | 2021 | |||||||||||||
interest_cd | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40304 | 40312 | 40312 | 40312 | |||||||||||||
effect_date | 2001-01-01 00:00:00 | 2000-07-12 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2007-01-01 00:00:00 | 2010-07-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 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 | N | |||||||||||||
race | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
session_id | 2001 | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2013 | 2021 | 2015 | 2019 | 2017 | 2023 | |||||||||||||
category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
sub_category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
effect_dt | 2001-01-01 00:00:00 | 2000-07-12 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-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 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
election_type | 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 | |||||||||||||
nyq_dt | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | None | None | |||||||||||||
party_cd | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
county_cd | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
district_cd | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1224772 | |
---|---|---|
xref_id | 1224772 | |
effect_dt | 2000-07-13 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | WASHINGTON | ST. LOUIS | NEW ORLEANS | ST. LOUIS | ST. LOUIS | NAPA | NAPA | NAPA | NAPA | NAPA | NAPA | ST. LOUIS | ST. LOUIS | ST. LOUIS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | DC | MO | LA | MO | MO | CA | CA | CA | CA | CA | CA | MO | MO | MO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | 20005 | 63105 | 70112 | 63105 | 63105 | 94558 | 94558 | 94558 | 94558 | 94558 | 94558 | 63105 | 63105 | 63105 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | 2023931986 | 3147250800 | 5045224850 | 3147250800 | 3147250800 | 7079450490 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 7079442310 | 3147250800 | 3147250800 | 3147250800 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | None | 7079450161 | None | None | None | None | None | None | 7079450161 | None | None | None | None | None | None | 7079450161 | None | None | None | None | None | None | 7079450161 | None | None | None | None | None | None | 7079450161 | None | None | None | None | None | None | 7079450161 | None | None | None | None | None | None | 7079450161 | None | None | None | None | None | None | 7079450161 | None | None | None | None | None | None | 7079450161 | None | None | None | None | None | None | 7079450161 | None | None | None | None | None | None | 7079450161 | None | None | None | None | None | None | 7079450161 | None | None | None | None | None | None | 7079450161 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1224772 |
---|
filer_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0 | 10 | |||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2009 | 2021 | |||||||||||
log_dt | 2000-07-13 00:00:00 | 2000-07-13 00:00:00 | 2000-07-14 00:00:00 | 2000-08-22 00:00:00 | 2000-08-22 00:00:00 | 2002-01-31 00:00:00 | 2002-01-31 00:00:00 | 2002-01-31 00:00:00 | 2002-01-31 00:00:00 | 2010-07-01 00:00:00 | 2020-12-23 00:00:00 | |||||||||||
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | |||||||||||
correction_flg | None | None | None | None | None | None | Y | None | None | Y | None | |||||||||||
action | CHANGE | None | CHANGED | CHANGED | CHANGED | CHANGED | CHANGED | CHANGED | CHANGED | ADDED | CHANGED | |||||||||||
attribute_changed | RESPONSIBLE OFFICER | None | INTEREST | NAME | ADDRESS AND PHONE | RESPONSIBLE OFFICER | ADDRESS AND PHONE | ADDRESS | None | FIRM | RESPONSIBLE OFFICER | |||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
interests | None | None | MISCELLANEOUS | None | None | None | None | None | None | None | None | |||||||||||
filer_full_name | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | GROWTH CAPITAL ALLIANCE | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL | |||||||||||
filer_city | None | None | None | None | SAINT LOUIS | None | NEW ORLEANS | NEW ORLEANS | NEW ORLEANS | None | None | |||||||||||
filer_st | None | None | None | None | MO | None | LA | LA | LA | None | None | |||||||||||
filer_zip | None | None | None | None | 63105 | None | 70112 | 70112 | 70112 | None | None | |||||||||||
filer_phone | None | None | None | None | 3147250800 | None | 5045224850 | 5045224850 | 5045224850 | None | None | |||||||||||
entity_type | 1 | 3 | 1 | 1 | 1 | 20 | 2 | 1 | 1 | 3 | 20 | |||||||||||
entity_name | GROWTH CAPITAL ALLIANCE | LANG, HANSEN, O'MALLEY AND MILLER GOVERNMENTAL RELATIONS | GROWTH CAPITAL ALLIANCE | ADVANTAGE CAPITAL PARTNERS | ADVANTAGE CAPITAL PARTNERS | PRESIDENT STEVEN T. STULL | ADVANTAGE CAPITAL PARTNERS | None | None | LANG HANSEN O'MALLEY AND MILLER GOVERNMENTAL RELATIONS | ASSOCIATE CHLOE CONIARIS | |||||||||||
entity_city | None | None | None | None | SAINT LOUIS | None | None | None | None | None | None | |||||||||||
entity_st | None | None | None | None | MO | None | None | None | None | None | None | |||||||||||
entity_zip | None | None | None | None | 63105 | None | None | None | None | None | None | |||||||||||
entity_phone | None | None | None | None | 3147250800 | None | None | None | None | None | None | |||||||||||
entity_id | 1224772 | 1147303 | 1224772 | 1224772 | 1224772 | 1242286 | 0 | 0 | 0 | 1147303 | 1436277 | |||||||||||
responsible_officer | PRESIDENT SCOTT ZAJAC | None | None | None | None | None | None | None | None | None | None | |||||||||||
effect_dt | None | None | None | None | None | 2002-01-30 00:00:00 | 2002-01-30 00:00:00 | 2002-01-30 00:00:00 | 2002-01-30 00:00:00 | 2010-07-01 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | 1224772 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 676141_0.cal | 719097_0.cal | 746072_0.cal | 773073_0.cal | 792248_0.cal | 812838_0.cal | 839823_0.cal | 856086_0.cal | 882778_0.cal | 908921_0.cal | 929925_0.cal | 929925_1.cal | 941564_0.cal | 965335_0.cal | 978571_0.cal | 1026421_0.cal | 1056104_0.cal | 1080168_0.cal | 1100735_0.cal | 1118700_0.cal | 1130961_0.cal | 1147046_0.cal | 1167574_0.cal | 1190513_0.cal | 1329639_0.cal | 1391982_0.cal | 1348961_0.cal | 1215046_0.cal | 1369445_0.cal | 1236681_0.cal | 1282348_0.cal | 1261518_0.cal | 1294150_0.cal | 1310831_0.cal | 1842008_0.cal | 1733537_0.cal | 1676266_0.cal | 1798011_0.cal | 1541078_0.cal | 1566807_0.cal | 1815240_0.cal | 1607455_0.cal | 1590749_0.cal | 1130961_1.cal | 1760806_0.cal | 1779225_0.cal | 1633501_0.cal | 1622322_0.cal | 1707508_0.cal | 1656601_0.cal | 1870063_0.cal | 1977751_0.cal | 2126244_0.cal | 1994727_0.cal | 2006928_0.cal | 2155622_0.cal | 2030556_0.cal | 489621.cal | 489617.cal | 2098944_0.cal | 1905158_0.cal | 2057571_0.cal | 1962139_0.cal | 1935258_0.cal | 2171679_0.cal | 2314751_0.cal | 2438485_1.cal | 2208393_0.cal | 2438485_0.cal | 2481317_0.cal | 2193386_0.cal | 2394215_0.cal | 2271317_0.cal | 2378484_0.cal | 2467609_1.cal | 2343928_0.cal | 2467609_0.cal | 2235855_0.cal | 2416328_0.cal | 2526236_0.cal | 2547265_0.cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-10-25 00:00:00 | 2001-01-31 00:00:00 | 2001-04-30 00:00:00 | 2001-07-31 00:00:00 | 2001-10-31 00:00:00 | 2002-01-30 00:00:00 | 2002-04-30 00:00:00 | 2002-07-31 00:00:00 | 2002-10-30 00:00:00 | 2003-01-29 00:00:00 | 2003-04-29 00:00:00 | 2003-04-29 00:00:00 | 2003-07-14 00:00:00 | 2003-10-20 00:00:00 | 2004-01-07 00:00:00 | 2004-07-27 00:00:00 | 2004-10-28 00:00:00 | 2005-01-31 00:00:00 | 2005-04-18 00:00:00 | 2005-08-01 00:00:00 | 2005-10-26 00:00:00 | 2006-01-30 00:00:00 | 2006-05-01 00:00:00 | 2006-07-31 00:00:00 | 2008-04-30 00:00:00 | 2009-01-26 00:00:00 | 2008-07-30 00:00:00 | 2006-10-30 00:00:00 | 2008-10-23 00:00:00 | 2007-01-31 00:00:00 | 2007-07-29 00:00:00 | 2007-04-30 00:00:00 | 2007-10-23 00:00:00 | 2008-01-31 00:00:00 | 2014-04-27 00:00:00 | 2013-01-28 00:00:00 | 2012-07-28 00:00:00 | 2013-10-28 00:00:00 | 2010-11-01 00:00:00 | 2011-01-26 00:00:00 | 2014-01-29 00:00:00 | 2011-07-30 00:00:00 | 2011-04-29 00:00:00 | 2013-10-31 00:00:00 | 2013-04-23 00:00:00 | 2013-07-28 00:00:00 | 2012-01-29 00:00:00 | 2011-10-31 00:00:00 | 2012-10-30 00:00:00 | 2012-04-29 00:00:00 | 2014-07-30 00:00:00 | 2015-07-27 00:00:00 | 2017-01-29 00:00:00 | 2015-10-27 00:00:00 | 2016-01-26 00:00:00 | 2017-04-28 00:00:00 | 2016-04-21 00:00:00 | 2014-10-27 00:00:00 | 2014-10-27 00:00:00 | 2016-10-28 00:00:00 | 2014-10-24 00:00:00 | 2016-07-24 00:00:00 | 2015-04-26 00:00:00 | 2015-01-31 00:00:00 | 2017-07-26 00:00:00 | 2018-10-28 00:00:00 | 2020-04-29 00:00:00 | 2018-01-30 00:00:00 | 2020-01-29 00:00:00 | 2020-07-27 00:00:00 | 2017-10-31 00:00:00 | 2019-07-27 00:00:00 | 2018-07-28 00:00:00 | 2019-04-29 00:00:00 | 2020-04-29 00:00:00 | 2019-01-29 00:00:00 | 2020-04-26 00:00:00 | 2018-04-25 00:00:00 | 2019-10-28 00:00:00 | 2020-10-29 00:00:00 | 2021-01-26 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /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 | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /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/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 676141 | 719097 | 746072 | 773073 | 792248 | 812838 | 839823 | 856086 | 882778 | 908921 | 929925 | 929925 | 941564 | 965335 | 978571 | 1026421 | 1056104 | 1080168 | 1100735 | 1118700 | 1130961 | 1147046 | 1167574 | 1190513 | 1329639 | 1391982 | 1348961 | 1215046 | 1369445 | 1236681 | 1282348 | 1261518 | 1294150 | 1310831 | 1842008 | 1733537 | 1676266 | 1798011 | 1541078 | 1566807 | 1815240 | 1607455 | 1590749 | 1130961 | 1760806 | 1779225 | 1633501 | 1622322 | 1707508 | 1656601 | 1870063 | 1977751 | 2126244 | 1994727 | 2006928 | 2155622 | 2030556 | None | None | 2098944 | 1905158 | 2057571 | 1962139 | 1935258 | 2171679 | 2314751 | 2438485 | 2208393 | 2438485 | 2481317 | 2193386 | 2394215 | 2271317 | 2378484 | 2467609 | 2343928 | 2467609 | 2235855 | 2416328 | 2526236 | 2547265 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted, but 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 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 accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |