filing_id | 746620 | 771905 | 792345 | 813190 | 839268 | 852161 | 883860 | 910647 | 931787 | 942875 | 968934 | 989245 | 1013304 | 1022832 | 1056201 | 1081191 | 1145326 | 1131336 | 1166125 | 1103645 | 1115156 | 1187829 | 1282797 | 1231948 | 1259564 | 1213380 | 1348063 | 1297502 | 1329311 | 1311816 | 1452934 | 1392789 | 1421649 | 1420907 | 1378267 | 1435924 | 1505763 | 1567959 | 1483124 | 1465019 | 1590411 | 1539562 | 1619853 | 1604561 | 1631841 | 1706878 | 1679371 | 1655461 | 1734050 | 1794246 | 1776135 | 1765595 | 1810514 | 1899755 | 1866132 | 1839851 | 1963975 | 1926358 | 1978966 | 1995424 | 2056936 | 2031420 | 2007895 | 2097748 | 2166979 | 2152309 | 2122823 | 2192073 | 2207547 | 2236196 | 2271914 | 2391866 | 2334536 | 2315420 | 2380088 | 2433353 | 2467842 | 2416463 | 2545797 | 2526422 | 2485445 | 2621544 | 2597302 | 2580274 | 2671293 | 2699264 | 2640773 | 2743539 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | F00602 | F00602 | F00602 | F00602 | F00602 | F00602 | F00602 | F00602 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | F00594 | 1232024 | F00602 | F00594 | 1232024 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | LBY | FRM | LBY | LBY | FRM | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | Bettencourt | BETTENCOURT | Bettencourt | Bettencourt | BETTENCOURT | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namf | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | Joanne M. | JOANNE M. | Joanne M. | Joanne M. | JOANNE M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2001-04-30 00:00:00 | 2001-07-30 00:00:00 | 2001-10-31 00:00:00 | 2002-01-30 00:00:00 | 2002-04-30 00:00:00 | 2002-07-26 00:00:00 | 2002-10-30 00:00:00 | 2003-01-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-18 00:00:00 | 2003-10-30 00:00:00 | 2004-01-30 00:00:00 | 2004-04-29 00:00:00 | 2004-07-14 00:00:00 | 2004-10-28 00:00:00 | 2005-01-31 00:00:00 | 2006-01-27 00:00:00 | 2005-10-27 00:00:00 | 2006-04-28 00:00:00 | 2005-04-28 00:00:00 | 2005-07-27 00:00:00 | 2006-07-26 00:00:00 | 2007-07-30 00:00:00 | 2007-01-26 00:00:00 | 2007-04-25 00:00:00 | 2006-10-27 00:00:00 | 2008-07-29 00:00:00 | 2007-10-31 00:00:00 | 2008-04-30 00:00:00 | 2008-01-31 00:00:00 | 2009-11-02 00:00:00 | 2009-01-27 00:00:00 | 2009-04-30 00:00:00 | 2009-04-30 00:00:00 | 2008-10-31 00:00:00 | 2009-07-29 00:00:00 | 2010-07-29 00:00:00 | 2011-01-27 00:00:00 | 2010-04-27 00:00:00 | 2010-02-01 00:00:00 | 2011-04-29 00:00:00 | 2010-10-30 00:00:00 | 2011-10-26 00:00:00 | 2011-07-27 00:00:00 | 2012-01-25 00:00:00 | 2012-10-29 00:00:00 | 2012-07-31 00:00:00 | 2012-04-27 00:00:00 | 2013-01-28 00:00:00 | 2013-10-15 00:00:00 | 2013-07-17 00:00:00 | 2013-04-30 00:00:00 | 2014-01-16 00:00:00 | 2014-10-17 00:00:00 | 2014-07-24 00:00:00 | 2014-04-21 00:00:00 | 2015-04-29 00:00:00 | 2015-01-16 00:00:00 | 2015-07-29 00:00:00 | 2015-10-28 00:00:00 | 2016-07-21 00:00:00 | 2016-04-22 00:00:00 | 2016-01-27 00:00:00 | 2016-10-27 00:00:00 | 2017-07-13 00:00:00 | 2017-04-21 00:00:00 | 2017-01-24 00:00:00 | 2017-10-30 00:00:00 | 2018-01-29 00:00:00 | 2018-04-25 00:00:00 | 2018-07-30 00:00:00 | 2019-07-22 00:00:00 | 2019-01-15 00:00:00 | 2018-10-29 00:00:00 | 2019-04-30 00:00:00 | 2020-01-22 00:00:00 | 2020-04-27 00:00:00 | 2019-10-28 00:00:00 | 2021-01-22 00:00:00 | 2020-10-29 00:00:00 | 2020-07-31 00:00:00 | 2021-10-28 00:00:00 | 2021-07-27 00:00:00 | 2021-04-30 00:00:00 | 2022-04-27 00:00:00 | 2022-07-19 00:00:00 | 2022-01-28 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 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-04-01 00:00:00 | 2003-07-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-10-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-01 00:00:00 | 2006-04-01 00:00:00 | 2007-04-01 00:00:00 | 2006-10-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00 | 2008-04-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2009-07-01 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 2009-03-09 00:00:00 | 2008-07-01 00:00:00 | 2009-04-01 00:00:00 | 2010-04-01 00:00:00 | 2010-10-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2011-01-01 00:00:00 | 2010-07-01 00:00:00 | 2011-07-01 00:00:00 | 2011-04-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 | 2012-10-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2015-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-04-01 00:00:00 | 2015-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2019-04-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 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-06-30 00:00:00 | 2003-09-30 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-12-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2006-06-30 00:00:00 | 2007-06-30 00:00:00 | 2006-12-31 00:00:00 | 2007-03-31 00:00:00 | 2006-09-30 00:00:00 | 2008-06-30 00:00:00 | 2007-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2009-09-30 00:00:00 | 2008-12-31 00:00:00 | 2009-03-06 00:00:00 | 2009-03-31 00:00:00 | 2008-09-30 00:00:00 | 2009-06-30 00:00:00 | 2010-06-30 00:00:00 | 2010-12-31 00:00:00 | 2010-03-31 00:00:00 | 2009-12-31 00:00:00 | 2011-03-31 00:00:00 | 2010-09-30 00:00:00 | 2011-09-30 00:00:00 | 2011-06-30 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 | 2012-12-31 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2013-12-31 00:00:00 | 2014-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2015-03-31 00:00:00 | 2014-12-31 00:00:00 | 2015-06-30 00:00:00 | 2015-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2019-09-30 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_id | F00602 | F00602 | F00602 | F00602 | F00602 | F00602 | F00602 | F00602 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | F00594 | 1232024 | F00602 | F00594 | 1232024 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | F00594 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_name | Orrick Herrington & Sutcliffe LLP | Orrick Herrington & Sutcliffe LLP | Orrick Herrington & Sutcliffe LLP | Orrick, Herrington & Sutcliffe, LLP | Orrick, Herrington & Sutcliffe, LLP | Orrick, Herrington & Sutcliffe, LLP | Orrick, Herrington & Sutcliffe, LLP | Orrick, Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Advocation, Inc. | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Advocation, Inc. | Orrick Herrington & Sutcliffe, LLP | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation Strategies, Inc | Advocation Strategies, Inc | Advocation Strategies, Inc | Advocation Strategies | Advocation Strategies, Inc | Advocation Strategies, Inc | Advocation Strategies, Inc | Advocation Strategies, Inc | Advocation Strategies, Inc | Advocation Strategies, Inc | Advocation Strategies, Inc | Advocation Strategies, Inc | Advocation Strategies, Inc | Advocation Strategies, Inc | Advocation Strategies | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_city | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | SACRAMENTO | Sacramento | Sacramento | SACRAMENTO | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | W. SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_zip4 | 95814-4407 | 95814-4407 | 95814-4407 | 95814-4407 | 95814-4407 | 95814-4407 | 95814-4407 | 95814-4407 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814-4407 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95814 | 95605 | 95605 | 95814 | 95814 | 95814 | 95814 | 95605 | 95814 | 95814 | 95605 | 95605 | 95605 | 95605 | 95605 | 95605 | 95605 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | (916) 447-9200 | (916) 447-9200 | (916) 447-9200 | (916) 447-9200 | (916) 447-9200 | (916) 447-9200 | (916) 447-9200 | (916) 447-9200 | 9164479200 | 9164479200 | 9164479200 | 9164479200 | 9164479200 | 9164479200 | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9163297953 | 9163297953 | 9163297953 | 9163297953 | 9163297953 | 9163297953 | 9163297953 | 9163297953 | 9163297953 | 9163297953 | 9163297953 | (916) 447-8229 | 9163297953 | (916) 447-9200 | (916) 447-8229 | 9163297953 | (916) 447-8229 | (916) 447-8229 | (916) 447-8229 | (916) 447-8229 | (916) 447-8229 | (916) 447-8229 | (916) 447-8229 | (916) 447-8229 | (916) 447-8229 | (916) 447-8229 | (916) 447-8229 | (916) 447-8229 | (916) 447-8229 | (916) 447-8229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | SACRAMENTO | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | CA | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 95814 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 9163297953 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 2001-04-30 00:00:00 | 2001-07-23 00:00:00 | 2001-10-25 00:00:00 | 2002-01-23 00:00:00 | 2002-04-26 00:00:00 | 2002-07-11 00:00:00 | 2002-10-29 00:00:00 | 2003-01-22 00:00:00 | 2003-04-30 00:00:00 | 2003-07-15 00:00:00 | None | 2004-01-12 00:00:00 | 2004-04-19 00:00:00 | 2004-07-14 00:00:00 | 2004-10-15 00:00:00 | 2005-01-31 00:00:00 | 2006-01-27 00:00:00 | 2005-10-27 00:00:00 | 2006-04-25 00:00:00 | 2005-04-20 00:00:00 | 2005-07-27 00:00:00 | 2006-07-26 00:00:00 | 2007-07-13 00:00:00 | 2007-01-15 00:00:00 | 2007-04-25 00:00:00 | 2007-10-27 00:00:00 | 2008-07-31 00:00:00 | 2007-10-31 00:00:00 | 2008-04-25 00:00:00 | 2008-01-31 00:00:00 | 2009-11-02 00:00:00 | 2009-01-28 00:00:00 | 2009-04-29 00:00:00 | 2009-04-29 00:00:00 | 2008-10-02 00:00:00 | 2009-07-27 00:00:00 | 2010-07-29 00:00:00 | 2011-01-24 00:00:00 | 2010-04-27 00:00:00 | 2010-01-29 00:00:00 | 2011-04-25 00:00:00 | 2010-10-28 00:00:00 | 2011-10-26 00:00:00 | 2011-07-26 00:00:00 | 2012-01-19 00:00:00 | 2012-10-24 00:00:00 | 2012-07-30 00:00:00 | 2012-04-26 00:00:00 | 2013-01-28 00:00:00 | 2013-10-15 00:00:00 | 2013-07-17 00:00:00 | 2013-04-30 00:00:00 | 2014-01-16 00:00:00 | 2014-10-17 00:00:00 | 2014-04-24 00:00:00 | 2014-04-21 00:00:00 | 2015-04-29 00:00:00 | 2015-01-16 00:00:00 | 2015-07-29 00:00:00 | 2015-10-28 00:00:00 | 2016-07-21 00:00:00 | 2016-04-22 00:00:00 | 2016-01-27 00:00:00 | 2016-10-27 00:00:00 | 2017-07-13 00:00:00 | 2017-04-21 00:00:00 | 2017-01-24 00:00:00 | 2017-10-30 00:00:00 | 2018-01-29 00:00:00 | 2018-04-25 00:00:00 | 2018-07-30 00:00:00 | 2019-07-22 00:00:00 | 2019-01-15 00:00:00 | 2018-10-29 00:00:00 | 2019-04-30 00:00:00 | 2020-01-22 00:00:00 | 2020-04-27 00:00:00 | 2019-10-28 00:00:00 | 2021-01-22 00:00:00 | 2020-10-29 00:00:00 | 2020-07-31 00:00:00 | 2021-10-28 00:00:00 | 2021-07-27 00:00:00 | 2021-04-30 00:00:00 | 2022-04-27 00:00:00 | 2022-07-19 00:00:00 | 2022-01-28 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_loc | Sacramento CA | Sacramento CA | Sacramento CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | None | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, Ca | Sacramento, Ca | Sacramento, Ca | Sacramento, CA | Sacramento, Ca | Sacramento, CA | Sacramento, Ca | Sacramento, Ca | Sacramento, Ca | Sacramento, Ca | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, Ca | Sacramento, Ca | Sacramento, Ca | W. Sacramento, CA | W. Sacramento, CA | Sacramento, CA | Sacramento, Ca | Sacramento, Ca | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento | Sacramento, CA | Sacamento, CA | Sacramento | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, California | Sacramento, CA | Sacramento, California | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | None | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne | Joanne | None | Joanne | Joanne | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne M. | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Bettencourt | None | None | None | None | Bettencourt | None | None | Bettencourt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | Bettencourt | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_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 | Joanne M. | None | None | None | None | Joanne M. | None | None | Joanne M. | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | Joanne | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Lobbyist | None | None | None | None | Lobbyist | None | None | Lobbyist | None | None | None | None | None | None | None | None | None | None | None | None | None | None | Senior Legislative Advocate | Senior Lobbyist | Sr Lobbyist | Sr Lobbyist | Sr Legislative Advocate | Sr. Lobbyist | Sr. Lobbyist | Sr. Legislative Advocate | Sr Legislative Advocate | Sr Lobbyist | Sr. Lobbyist | Sr. Lobbyist | Sr Lobbyist | Sr. Lobbyist | Sr. Lobbyist | President | President | President | President | President | President | President | President | President | President | President | President | President | President | President | President | President | President | President | President | President | President | President | President | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart1_cb | X | X | X | X | X | X | X | X | X | X | X | None | X | X | X | None | None | X | X | X | X | X | X | None | X | X | X | X | X | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart2_cb | 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 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lby_actvty | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | 898601 | 1068382 | 1223130 | 1383856 | 1383856 | 1552805 | 1552805 | 1922927 | 1922927 | 2083931 | 2118349 | 2333949 | 2550881 | 2577779 | 2579520 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||||
form_type | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | |||||||||||||||
sender_id | F00602 | F00602 | F00602 | F00602 | F00594 | F00594 | F00594 | 1355325 | 1355325 | 1390945 | 1390945 | 1390945 | 1390945 | 1390945 | 1390945 | |||||||||||||||
filer_id | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | |||||||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | |||||||||||||||
filer_naml | Bettencourt | Bettencourt | BETTENCOURT | BETTENCOURT | Bettencourt | Bettencourt | Bettencourt | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | |||||||||||||||
filer_namf | Joanne M. | Joanne M. | JOANNE M. | JOANNE M. | Joanne M. | Joanne M | Joanne M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | |||||||||||||||
filer_namt | 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 | |||||||||||||||
report_num | 000 | 000 | 000 | 000 | 001 | 000 | 001 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||||||||
rpt_date | 2002-12-30 00:00:00 | 2004-12-29 00:00:00 | 2006-12-07 00:00:00 | 2008-12-16 00:00:00 | 2009-03-11 00:00:00 | 2010-12-21 00:00:00 | 2010-12-31 00:00:00 | 2015-01-05 00:00:00 | 2015-03-11 00:00:00 | 2016-09-30 00:00:00 | 2017-01-10 00:00:00 | 2019-01-11 00:00:00 | 2021-01-29 00:00:00 | 2021-04-27 00:00:00 | 2021-04-29 00:00:00 | |||||||||||||||
ls_beg_yr | 2003 | 2005 | 2007 | 2009 | 2009 | 2011 | 2011 | 2015 | 2015 | 2015 | 2017 | 2019 | 2021 | 2021 | 2021 | |||||||||||||||
ls_end_yr | 2004 | 2006 | 2008 | 2010 | 2010 | 2012 | 2012 | 2016 | 2016 | 2016 | 2018 | 2020 | 2022 | 2022 | 2022 | |||||||||||||||
qual_date | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | None | 2009-01-01 00:00:00 | None | None | None | None | None | None | None | 2018-11-15 00:00:00 | 2021-01-28 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | |||||||||||||||
eff_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bus_city | Sacramento | Sacramento | SACRAMENTO | SACRAMENTO | Sacramento | Sacramento | Sacramento | SACRAMENTO | SACRAMENTO | WEST SACRAMENTO | W. SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||||||||||
bus_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||
bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||
bus_phon | (916) 329-7953 | (916) 329-7953 | 9163297953 | 9163297935 | (916) 447-8229 | 916 447-8229 | (916) 447-8229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | |||||||||||||||
bus_fax | (916) 329-4900 | (916) 329-4900 | 9163294900 | 9163294900 | (916) 447-3447 | 916 447-3447 | (916) 447-3447 | 9164473447 | 9164473447 | None | None | None | None | None | None | |||||||||||||||
bus_email | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | |||||||||||||||
mail_city | Sacramento | Sacramento | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
mail_st | CA | CA | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
mail_zip4 | 95814 | 95814 | 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 | |||||||||||||||
sig_date | 2002-12-02 00:00:00 | 2004-12-21 00:00:00 | 2006-12-06 00:00:00 | 2008-12-16 00:00:00 | 2009-03-09 00:00:00 | 2010-12-10 00:00:00 | 2011-03-09 00:00:00 | 2014-12-22 00:00:00 | 2015-01-22 00:00:00 | 2016-09-30 00:00:00 | 2017-01-10 00:00:00 | 2019-01-01 00:00:00 | 2021-01-29 00:00:00 | 2021-04-27 00:00:00 | 2021-04-29 00:00:00 | |||||||||||||||
sig_loc | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sig_naml | Bettencourt | Bettencourt | BETTENCOURT | BETTENCOURT | Bettencourt | Bettencourt | Bettencourt | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | |||||||||||||||
sig_namf | Joanne M. | Joanne M. | JOANNE M. | JOANNE M. | Joanne M. | Joanne | Joanne M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | |||||||||||||||
sig_namt | 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 | |||||||||||||||
prn_naml | None | None | BETTENCOURT | BETTENCOURT | None | Bettencourt | None | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | |||||||||||||||
prn_namf | None | None | JOANNE M. | JOANNE M. | None | Joanne | None | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | |||||||||||||||
prn_namt | 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 | |||||||||||||||
sig_title | None | None | None | None | None | Lobbyist | None | None | None | None | None | None | None | None | None | |||||||||||||||
stmt_firm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
ind_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bus_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
trade_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
oth_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
a_b_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
a_b_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
a_b_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
a_b_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
descrip_1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
descrip_2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
c_less50 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
c_more50 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
ind_class | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
ind_descr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bus_class | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bus_descr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
auth_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
auth_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
auth_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
auth_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
lobby_int | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
influen_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
firm_name | Orrick, Herrington & Sutcliffe, LLP | Orrick, Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Orrick Herrington & Sutcliffe, LLP | Advocation, Inc. | Advocation, Inc. | Advocation, Inc. | Advocation Strategies, Inc | Advocation Strategies, Inc | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | Bettencourt Government Relations | |||||||||||||||
newcert_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | X | None | |||||||||||||||
rencert_cb | X | None | None | None | None | X | None | X | None | None | X | None | None | None | X | |||||||||||||||
complet_dt | None | 2004-11-17 00:00:00 | 2006-11-16 00:00:00 | 2008-11-12 00:00:00 | 2008-11-12 00:00:00 | None | 2011-01-13 00:00:00 | None | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | None | 2018-11-15 00:00:00 | 2021-01-28 00:00:00 | None | None | |||||||||||||||
lby_reg_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||||
lby_604_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
st_leg_yn | None | None | Y | Y | None | None | None | Y | Y | Y | Y | Y | Y | Y | Y | |||||||||||||||
st_agency | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
lobby_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
l_firm_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filing_date | 2003-07-18 00:00:00 | 2003-07-18 00:00:00 | 2003-04-30 00:00:00 | 2003-04-30 00:00:00 | 2003-10-30 00:00:00 | 2003-10-30 00:00:00 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
filingstatus | 1 | 0 | 1 | 0 | 1 | 0 | ||||||
vendor | 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 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | ||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | ||||||
error_no | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED | ACCEPTED |
filer_id | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2011766 | 2041824 | 2079263 | 2115048 | 2159943 | 2170129 | 2203477 | 2409942 | 2431532 | 2407796 | 2549099 | 2469412 | 2230462 | 2278704 | 2338125 | 2506885 | ||||||||||||||||
effect_dt | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-03-09 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-10 00:00:00 | 2016-10-01 00:00:00 | 2023-01-01 00:00:00 | 2019-01-01 00:00:00 | 2012-04-18 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||||||
session_id | 2001 | 2003 | 2005 | 2007 | 2009 | 2009 | 2011 | 2017 | 2017 | 2015 | 2023 | 2019 | 2011 | 2013 | 2015 | 2021 |
filer_id | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 2003 | 2005 | 2009 | 2007 | 2011 | 2013 | 2015 | 2017 | 2019 | 2021 | |||||||||||
ethics_date | 2001-01-25 00:00:00 | 2003-02-07 00:00:00 | 2004-11-17 00:00:00 | 2008-11-12 00:00:00 | 2006-11-16 00:00:00 | 2011-01-13 00:00:00 | 2013-04-11 00:00:00 | 2015-01-22 00:00:00 | 2017-01-12 00:00:00 | 2018-11-15 00:00:00 | 2021-01-28 00:00:00 |
filer_id | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 713428 | 713428 | 746620 | 749659 | 792345 | 782061 | 771905 | 813190 | 793097 | 815558 | 841650 | 839268 | 855961 | 852161 | 910028 | 886819 | 897517 | 898601 | 910647 | 883860 | 931787 | 942875 | 944433 | 924641 | 932468 | 936576 | 989245 | 971612 | 968934 | 991010 | 1024440 | 1015317 | 1022832 | 1013304 | 1068382 | 1062848 | 1056201 | 1086360 | 1081191 | 1090933 | 1092624 | 1145326 | 1115156 | 1103645 | 1131336 | 1166125 | 1187829 | 1213380 | 1223130 | 1259564 | 1231948 | 1282797 | 1232488 | 1297502 | 1776135 | 1978966 | 1963975 | 1839851 | 1866132 | 1794246 | 1810514 | 1922927 | 1944231 | 1899755 | 1329311 | 1311816 | 1348063 | 1378267 | 1383856 | 1392789 | 1411707 | 1383856 | 1420907 | 1421649 | 1435924 | 1429899 | 1452934 | 1483124 | 1465019 | 1505763 | 1539562 | 1552805 | 1552797 | 1567959 | 1552805 | 1586770 | 1604561 | 1590411 | 1631841 | 1619853 | 1655461 | 1679371 | 1929660 | 1926358 | 1922927 | 1706878 | 1743225 | 1734050 | 1765595 | 1759460 | 1995424 | 2339056 | 2545797 | 2334536 | 2333949 | 2207547 | 2007895 | 2031420 | 2056936 | 2084365 | 2083931 | 2097748 | 2119972 | 2122823 | 2152309 | 2134168 | 2118349 | 2166979 | 2315420 | 2236196 | 2550881 | 2597302 | 2467842 | 2580274 | 2192073 | 2433353 | 2416463 | 2271914 | 2485445 | 2391866 | 2380088 | 2589891 | 2579520 | 2621544 | 2576756 | 2577779 | 2526422 | 2640773 | 2699264 | 2671293 | 2743539 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | None | None | 165 | 165 | 167 | None | 166 | 168 | 167 | None | None | 169 | None | 170 | None | None | None | 172 | 172 | 171 | 173 | 174 | 174 | None | None | None | 176 | None | 175 | None | None | None | 178 | 177 | 180 | None | 179 | None | 180 | None | None | 184 | 182 | 181 | 183 | 185 | 186 | 187 | 188 | 189 | 188 | 190 | None | 191 | 214 | 222 | 221 | 217 | 218 | 215 | 216 | 221 | None | 219 | 193 | 192 | 194 | 195 | 196 | 196 | None | 197 | 197 | 197 | 198 | None | 199 | 201 | 200 | 202 | 203 | 204 | None | 204 | 204 | None | 206 | 205 | 208 | 207 | 209 | 210 | None | 220 | 221 | 211 | None | 212 | 213 | None | 223 | None | 244 | 236 | 237 | 232 | 224 | 225 | 226 | None | 227 | 227 | None | 228 | 229 | None | 229 | 230 | 235 | 233 | 245 | 246 | 241 | 245 | 231 | 240 | 239 | 234 | 242 | 238 | 237 | None | 246 | 247 | None | 246 | 243 | 248 | 250 | 249 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2001-01-12 00:00:00 | 2001-01-25 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-10-31 00:00:00 | 2001-07-30 00:00:00 | 2001-07-30 00:00:00 | 2002-01-30 00:00:00 | 2001-10-30 00:00:00 | 2002-01-28 00:00:00 | 2002-04-29 00:00:00 | 2002-04-30 00:00:00 | 2002-07-22 00:00:00 | 2002-07-26 00:00:00 | 2003-01-29 00:00:00 | 2002-10-30 00:00:00 | 2002-12-19 00:00:00 | 2002-12-30 00:00:00 | 2003-01-30 00:00:00 | 2002-10-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-18 00:00:00 | 2003-07-18 00:00:00 | 2003-02-07 00:00:00 | 2003-04-30 00:00:00 | 2003-04-30 00:00:00 | 2004-01-30 00:00:00 | 2003-10-31 00:00:00 | 2003-10-30 00:00:00 | 2004-01-30 00:00:00 | 2004-07-16 00:00:00 | 2004-04-29 00:00:00 | 2004-07-14 00:00:00 | 2004-04-29 00:00:00 | 2004-12-29 00:00:00 | 2004-10-28 00:00:00 | 2004-10-28 00:00:00 | 2005-01-31 00:00:00 | 2005-01-31 00:00:00 | 2004-12-27 00:00:00 | 2005-01-31 00:00:00 | 2006-01-27 00:00:00 | 2005-07-27 00:00:00 | 2005-04-28 00:00:00 | 2005-10-27 00:00:00 | 2006-04-28 00:00:00 | 2006-07-26 00:00:00 | 2006-10-27 00:00:00 | 2006-12-07 00:00:00 | 2007-04-25 00:00:00 | 2007-01-26 00:00:00 | 2007-07-30 00:00:00 | 2007-01-02 00:00:00 | 2007-10-31 00:00:00 | 2013-07-17 00:00:00 | 2015-07-29 00:00:00 | 2015-04-29 00:00:00 | 2014-04-21 00:00:00 | 2014-07-24 00:00:00 | 2013-10-15 00:00:00 | 2014-01-16 00:00:00 | 2015-03-11 00:00:00 | 2014-12-30 00:00:00 | 2014-10-17 00:00:00 | 2008-04-30 00:00:00 | 2008-01-31 00:00:00 | 2008-07-29 00:00:00 | 2008-10-31 00:00:00 | 2008-12-16 00:00:00 | 2009-01-27 00:00:00 | 2008-12-19 00:00:00 | 2009-03-11 00:00:00 | 2009-04-30 00:00:00 | 2009-04-30 00:00:00 | 2009-07-29 00:00:00 | 2009-03-10 00:00:00 | 2009-11-02 00:00:00 | 2010-04-27 00:00:00 | 2010-02-01 00:00:00 | 2010-07-29 00:00:00 | 2010-10-30 00:00:00 | 2010-12-21 00:00:00 | 2010-12-20 00:00:00 | 2011-01-27 00:00:00 | 2011-03-15 00:00:00 | 2011-03-14 00:00:00 | 2011-07-27 00:00:00 | 2011-04-29 00:00:00 | 2012-01-25 00:00:00 | 2011-10-26 00:00:00 | 2012-04-27 00:00:00 | 2012-07-31 00:00:00 | 2015-01-22 00:00:00 | 2015-01-16 00:00:00 | 2015-01-05 00:00:00 | 2012-10-29 00:00:00 | 2013-01-15 00:00:00 | 2013-01-28 00:00:00 | 2013-04-30 00:00:00 | 2013-04-11 00:00:00 | 2015-10-28 00:00:00 | 2018-12-19 00:00:00 | 2021-01-22 00:00:00 | 2019-01-15 00:00:00 | 2019-01-11 00:00:00 | 2018-01-29 00:00:00 | 2016-01-27 00:00:00 | 2016-04-22 00:00:00 | 2016-07-21 00:00:00 | 2016-09-30 00:00:00 | 2016-09-30 00:00:00 | 2016-10-27 00:00:00 | 2017-01-12 00:00:00 | 2017-01-24 00:00:00 | 2017-04-21 00:00:00 | 2017-01-09 00:00:00 | 2017-01-10 00:00:00 | 2017-07-13 00:00:00 | 2018-10-29 00:00:00 | 2018-04-25 00:00:00 | 2021-01-29 00:00:00 | 2021-07-27 00:00:00 | 2020-04-27 00:00:00 | 2021-04-30 00:00:00 | 2017-10-30 00:00:00 | 2020-01-22 00:00:00 | 2019-10-28 00:00:00 | 2018-07-30 00:00:00 | 2020-07-31 00:00:00 | 2019-07-22 00:00:00 | 2019-04-30 00:00:00 | 2021-02-01 00:00:00 | 2021-04-29 00:00:00 | 2021-10-28 00:00:00 | 2021-01-04 00:00:00 | 2021-04-27 00:00:00 | 2020-10-29 00:00:00 | 2022-01-28 00:00:00 | 2022-07-19 00:00:00 | 2022-04-27 00:00:00 | 2022-10-27 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10006 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 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 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 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 | 11003 | 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 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2015 | 2013 | 2015 | 2011 | 2013 | 2011 | 2013 | 2013 | 2015 | 2019 | 2019 | 2017 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2021 | 2021 | 2019 | 2021 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | YBONILLA | BSMITH | * | SARRIAGA | * | CFLAGG | * | * | YBONILLA | YBONILLA | YBONILLA | * | YBONILLA | * | YBONILLA | YBONILLA | SARRIAGA | COMPLETED | COMPLETED | * | COMPLETED | COMPLETED | YBONILLA | GPEREZ | LTHIBAUL | YBONILLA | COMPLETED | YBONILLA | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | YRODRIGUEZ | COMPLETED | YRODRIGU | COMPLETED | SARRIAGA | KVANG | LTHIBAUL | YRODRIGU | YRODRIGU | YRODRIGU | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | YRODRIGU | YRODRIGU | YRODRIGU | LLEONG | LTHIBAUL | ASAETERN | JINGRAM | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | YRODRIGU | YRODRIGU | ASAETERN | YRODRIGU | YRODRIGU | LTHIBAUL | YRODRIGU | * | YRODRIGU | DMCCASTL | * | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | JINGRAM | YRODRIGU | ASAETERN | ASAETERN | * | SARRIAGA | ASAETERN | PBANFORD | PBANFORD | ASAETERN | JINGRAM | JINGRAM | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | AGLADNEY | YRODRIGU | ASAETERN | GKURIMOT | ASAETERN | ASAETERN | SMCCONNAN | JINGRAM | DMCCASTL | JRAMOS | AGLADNEY | CAFILER | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | YRODRIGU | JINGRAM | PBANFORD | AGLADNEY | JINGRAM | YRODRIGU | YRODRIGU | SMCCONNAN | JFRONEFIELD | AGLADNEY | MKIRKHAM | CHATRIDGE | VUKSTINA | CHARTRIDGE | SMCCONNAN | VUKSTINA | GTAYLOR | AGLADNEY | CVANLIEW | VUKSTINA | VUKSTINA | AROJAS | AROJAS | GTAYLOR | MKIRKHAM | AROJAS | CVANLIEW | RATTIYEH | CAFILER | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11002 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11002 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1900-01-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-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-12-30 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-12-29 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-10-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-07 00:00:00 | 2007-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 1900-01-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2013-10-01 00:00:00 | 2015-03-11 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-16 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 2009-03-11 00:00:00 | 2009-03-09 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-12-21 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2010-12-31 00:00:00 | 1900-01-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 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-01-05 00:00:00 | 2012-07-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-11 00:00:00 | 2017-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 1900-01-01 00:00:00 | 2016-09-30 00:00:00 | 2016-07-01 00:00:00 | None | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-10 00:00:00 | 2017-04-01 00:00:00 | 2018-07-01 00:00:00 | 2018-01-01 00:00:00 | 2021-01-29 00:00:00 | 2021-04-01 00:00:00 | 2020-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-07-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2018-04-01 00:00:00 | 2020-04-01 00:00:00 | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-29 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-27 00:00:00 | 2020-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1900-01-01 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-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-12-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-12-29 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-07 00:00:00 | 2007-03-31 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 1900-01-01 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-03-31 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2013-12-31 00:00:00 | 2015-03-11 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-16 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 2009-03-11 00:00:00 | 2009-03-31 00:00:00 | 2009-03-06 00:00:00 | 2009-06-30 00:00:00 | 1900-01-01 00:00:00 | 2009-09-30 00:00:00 | 2010-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-21 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 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 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2015-01-05 00:00:00 | 2012-09-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-01-11 00:00:00 | 2017-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 1900-01-01 00:00:00 | 2016-09-30 00:00:00 | 2016-09-30 00:00:00 | None | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-01-10 00:00:00 | 2017-06-30 00:00:00 | 2018-09-30 00:00:00 | 2018-03-31 00:00:00 | 2021-01-29 00:00:00 | 2021-06-30 00:00:00 | 2020-03-31 00:00:00 | 2021-03-31 00:00:00 | 2017-09-30 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2018-06-30 00:00:00 | 2020-06-30 00:00:00 | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-04-29 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 00:00:00 | 2021-04-27 00:00:00 | 2020-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-03-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 | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | None | 22006 | 22006 | None | None | None | None | 22006 | None | 22006 | None | None | None | 22006 | 22006 | 22001 | None | 22006 | None | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22006 | 22006 | 22001 | None | 22001 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | T | Y | Y | Y | Y | Y | N | ||||||||||||||
race | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
session_id | 2001 | 2003 | 2005 | 2011 | 2013 | 2007 | 2009 | 2009 | 2009 | 2015 | 2021 | 2019 | 2017 | 2023 | ||||||||||||||
category | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
category_type | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
effect_dt | 2001-01-01 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 | 2009-01-01 00:00:00 | 2009-03-06 00:00:00 | 2009-03-09 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||
sub_category_type | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
election_type | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
nyq_dt | None | None | 2001-01-01 00:00:00 | None | None | 2001-01-01 00:00:00 | None | None | None | None | None | None | None | None | ||||||||||||||
party_cd | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
county_cd | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
district_cd | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1232024 | |
---|---|---|
xref_id | 1232024 | |
effect_dt | 2001-01-17 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 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 | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | BETTENCOURT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | JOANNE M. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | W. SACRAMENTO | WEST SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95605 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95605 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95605 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95605 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95605 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95605 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95605 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95605 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95605 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95605 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95605 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95605 | 95605 | 95814 | 95605 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9164479200 | 9164479200 | 9163297953 | 9163297953 | 9163297953 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9164478229 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | 9162125923 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | 9163294900 | 9163294900 | 9163294900 | 9163294900 | 9164473447 | 9164473447 | 9164473447 | 9164473447 | None | 9163294900 | 9163294900 | 9163294900 | 9163294900 | 9164473447 | 9164473447 | 9164473447 | 9164473447 | None | 9163294900 | 9163294900 | 9163294900 | 9163294900 | 9164473447 | 9164473447 | 9164473447 | 9164473447 | None | 9163294900 | 9163294900 | 9163294900 | 9163294900 | 9164473447 | 9164473447 | 9164473447 | 9164473447 | None | 9163294900 | 9163294900 | 9163294900 | 9163294900 | 9164473447 | 9164473447 | 9164473447 | 9164473447 | None | 9163294900 | 9163294900 | 9163294900 | 9163294900 | 9164473447 | 9164473447 | 9164473447 | 9164473447 | None | 9163294900 | 9163294900 | 9163294900 | 9163294900 | 9164473447 | 9164473447 | 9164473447 | 9164473447 | None | 9163294900 | 9163294900 | 9163294900 | 9163294900 | 9164473447 | 9164473447 | 9164473447 | 9164473447 | None | 9163294900 | 9163294900 | 9163294900 | 9163294900 | 9164473447 | 9164473447 | 9164473447 | 9164473447 | None | 9163294900 | 9163294900 | 9163294900 | 9163294900 | 9164473447 | 9164473447 | 9164473447 | 9164473447 | None | 9163294900 | 9163294900 | 9163294900 | 9163294900 | 9164473447 | 9164473447 | 9164473447 | 9164473447 | None | 9163294900 | 9163294900 | 9163294900 | 9163294900 | 9164473447 | 9164473447 | 9164473447 | 9164473447 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1232024 |
---|
filer_id | 1232024 | 1232024 | 1232024 | |||
---|---|---|---|---|---|---|
change_no | 1 | 0 | 2 | |||
session_id | 2009 | 2009 | 2015 | |||
log_dt | 2009-03-09 00:00:00 | 2009-03-10 00:00:00 | 2016-09-30 00:00:00 | |||
filer_type | 4 | 4 | 4 | |||
correction_flg | Y | Y | None | |||
action | DELETED | ADDED | DELETED | |||
attribute_changed | FIRM | FIRM | FIRM | |||
ethics_dt | None | None | None | |||
interests | None | None | None | |||
filer_full_name | BETTENCOURT; JOANNE M. | BETTENCOURT, JOANNE M. | JOANNE M. BETTENCOURT | |||
filer_city | None | None | None | |||
filer_st | None | None | None | |||
filer_zip | None | None | None | |||
filer_phone | None | None | None | |||
entity_type | 3 | 3 | 3 | |||
entity_name | ORRICK, HERRINGTON & SUTCLIFFE, LLP | ADVOCATION, INC. | ADVOCATION STRATEGIES, INC. | |||
entity_city | None | None | None | |||
entity_st | None | None | None | |||
entity_zip | None | None | None | |||
entity_phone | None | None | None | |||
entity_id | 1147260 | 1147259 | 1355325 | |||
responsible_officer | None | None | None | |||
effect_dt | 2009-03-06 00:00:00 | 2009-03-09 00:00:00 | 2016-09-30 00:00:00 |
filer_id | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | 1232024 | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 746620_0.cal | 771905_0.cal | 792345_0.cal | 813190_0.cal | 839268_0.cal | 852161_0.cal | 898601_0.cal | 883860_0.cal | 910647_0.cal | 931787_0.cal | 942875_0.cal | 968934_0.cal | 1068382_0.cal | 1505763_0.cal | 1383856_1.cal | 1435924_0.cal | 1452934_0.cal | 1223130_0.cal | 1465019_0.cal | 1483124_0.cal | 1421649_0.cal | 1420907_0.cal | 1383856_0.cal | 1734050_0.cal | 1679371_0.cal | 1539562_0.cal | 1552805_0.cal | 1552805_1.cal | 1567959_0.cal | 1604561_0.cal | 1631841_0.cal | 1590411_0.cal | 1619853_0.cal | 1706878_0.cal | 1655461_0.cal | 2118349_0.cal | 2083931_0.cal | 1922927_0.cal | 1922927_1.cal | 2333949_0.cal | 2579520_0.cal | 96346.cal | 96473.cal | 96014.cal | 2550881_0.cal | 96583.cal | 95783.cal | 2577779_0.cal | ||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2001-04-30 00:00:00 | 2001-07-30 00:00:00 | 2001-10-31 00:00:00 | 2002-01-30 00:00:00 | 2002-04-30 00:00:00 | 2002-07-26 00:00:00 | 2002-12-30 00:00:00 | 2002-10-30 00:00:00 | 2003-01-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-18 00:00:00 | 2003-10-30 00:00:00 | 2004-12-29 00:00:00 | 2010-07-29 00:00:00 | 2009-03-11 00:00:00 | 2009-07-29 00:00:00 | 2009-11-02 00:00:00 | 2006-12-07 00:00:00 | 2010-02-01 00:00:00 | 2010-04-27 00:00:00 | 2009-04-30 00:00:00 | 2009-04-30 00:00:00 | 2008-12-16 00:00:00 | 2013-01-28 00:00:00 | 2012-07-31 00:00:00 | 2010-10-30 00:00:00 | 2010-12-21 00:00:00 | 2011-03-15 00:00:00 | 2011-01-27 00:00:00 | 2011-07-27 00:00:00 | 2012-01-25 00:00:00 | 2011-04-29 00:00:00 | 2011-10-26 00:00:00 | 2012-10-29 00:00:00 | 2012-04-27 00:00:00 | 2017-01-10 00:00:00 | 2016-09-30 00:00:00 | 2015-01-05 00:00:00 | 2015-03-11 00:00:00 | 2019-01-11 00:00:00 | 2021-04-29 00:00:00 | 2021-04-30 00:00:00 | 2021-04-30 00:00:00 | 2021-04-30 00:00:00 | 2021-01-29 00:00:00 | 2021-04-30 00:00:00 | 2021-04-30 00:00:00 | 2021-04-27 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 | /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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 746620 | 771905 | 792345 | 813190 | 839268 | 852161 | 898601 | 883860 | 910647 | 931787 | 942875 | 968934 | 1068382 | 1505763 | 1383856 | 1435924 | 1452934 | 1223130 | 1465019 | 1483124 | 1421649 | 1420907 | 1383856 | 1734050 | 1679371 | 1539562 | 1552805 | 1552805 | 1567959 | 1604561 | 1631841 | 1590411 | 1619853 | 1706878 | 1655461 | 2118349 | 2083931 | 1922927 | 1922927 | 2333949 | 2579520 | None | None | None | 2550881 | None | None | 2577779 | ||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F604 | F604 | F604 | None | None | None | F604 | None | None | F604 | ||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | 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 passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted |