Home

Filer ID: 1234101

Table: cvr_lobby_disclosure

filing_id		744300		769215		788299		808210		838454		851631		873983		905894		928871		942973		1025689		1054912		1072362		1132529		1103494		1165336		1146694		1117104		1282973		1259441		1188239		1235783		1215307		1325463		1295382		1347244		1306579		1374144		1450256		1395784		1434790		1419101		1460871		1535307		1503263		1483130		1570921		1585794		1617220		1600397		1631570		1698932		1651855		1671949		1724965		1798544		1775412		1759714		1809564		1908889		1868609		1844803		1927735		1993056		1977828		1959541		2002481		2058381		2088009		2033326		2167017		2152078		2122781		2191069		2264588		2305331		2200271		2234226		2390987		2390987		2370117		2343345		2466020		2429616		2477507		2412040		2526123		2543321		2618230		2591069		2579642		2635322		2699619		2731342		2666382
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		1		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
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
sender_id		F24778		F24778		F24778		F24778		F24778		F24778		F24778		F24778		F24778		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101
filer_id		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101
entity_cd		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		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		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN
filer_namf		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.
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
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
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		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2001-04-26 00:00:00		2001-07-23 00:00:00		2001-10-22 00:00:00		2002-01-18 00:00:00		2002-04-29 00:00:00		2002-07-24 00:00:00		2002-10-14 00:00:00		2003-01-24 00:00:00		2003-04-24 00:00:00		2003-07-21 00:00:00		2004-07-26 00:00:00		2004-10-27 00:00:00		2005-01-14 00:00:00		2005-10-28 00:00:00		2005-04-28 00:00:00		2006-04-26 00:00:00		2006-01-30 00:00:00		2005-07-29 00:00:00		2007-07-30 00:00:00		2007-04-25 00:00:00		2006-07-27 00:00:00		2007-01-30 00:00:00		2006-10-30 00:00:00		2008-04-18 00:00:00		2007-10-26 00:00:00		2008-07-28 00:00:00		2008-01-25 00:00:00		2008-10-28 00:00:00		2009-10-27 00:00:00		2009-01-30 00:00:00		2009-07-28 00:00:00		2009-04-27 00:00:00		2010-01-26 00:00:00		2010-10-26 00:00:00		2010-07-26 00:00:00		2010-04-27 00:00:00		2011-01-31 00:00:00		2011-04-12 00:00:00		2011-10-12 00:00:00		2011-07-14 00:00:00		2012-01-25 00:00:00		2012-10-16 00:00:00		2012-04-12 00:00:00		2012-07-17 00:00:00		2013-01-14 00:00:00		2013-10-29 00:00:00		2013-07-15 00:00:00		2013-04-18 00:00:00		2014-01-10 00:00:00		2014-10-29 00:00:00		2014-07-29 00:00:00		2014-04-30 00:00:00		2015-01-21 00:00:00		2015-10-21 00:00:00		2015-07-27 00:00:00		2015-04-20 00:00:00		2016-01-05 00:00:00		2016-07-26 00:00:00		2016-10-12 00:00:00		2016-04-27 00:00:00		2017-07-13 00:00:00		2017-04-20 00:00:00		2017-01-24 00:00:00		2017-10-27 00:00:00		2018-07-13 00:00:00		2018-10-11 00:00:00		2018-01-05 00:00:00		2018-04-23 00:00:00		2019-07-18 00:00:00		2019-07-18 00:00:00		2019-04-03 00:00:00		2019-01-29 00:00:00		2020-04-16 00:00:00		2020-01-10 00:00:00		2020-07-09 00:00:00		2019-10-08 00:00:00		2020-10-29 00:00:00		2021-01-11 00:00:00		2021-10-22 00:00:00		2021-07-06 00:00:00		2021-04-29 00:00:00		2022-01-19 00:00:00		2022-07-20 00:00:00		2022-10-11 00:00:00		2022-04-14 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		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2005-07-01 00:00:00		2005-01-01 00:00:00		2006-01-01 00:00:00		2005-10-01 00:00:00		2005-04-01 00:00:00		2007-04-01 00:00:00		2007-01-01 00:00:00		2006-04-01 00:00:00		2006-10-01 00:00:00		2006-07-01 00:00:00		2008-01-01 00:00:00		2007-07-01 00:00:00		2008-04-01 00:00:00		2007-10-01 00:00:00		2008-07-01 00:00:00		2009-07-01 00:00:00		2008-10-01 00:00:00		2009-04-01 00:00:00		2009-01-01 00:00:00		2009-10-01 00:00:00		2010-07-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		2010-10-01 00:00:00		2011-01-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-01-01 00:00:00		2012-04-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		2014-10-01 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2015-10-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-01-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		2018-04-01 00:00:00		2018-07-01 00:00:00		2017-10-01 00:00:00		2018-01-01 00:00:00		2019-04-01 00:00:00		2019-04-01 00:00:00		2019-01-01 00:00:00		2018-10-01 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2020-04-01 00:00:00		2019-07-01 00:00:00		2020-07-01 00:00:00		2020-10-01 00:00:00		2021-07-01 00:00:00		2021-04-01 00:00:00		2021-01-01 00:00:00		2021-10-01 00:00:00		2022-04-01 00:00:00		2022-07-01 00:00:00		2022-01-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		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2005-09-30 00:00:00		2005-03-31 00:00:00		2006-03-31 00:00:00		2005-12-31 00:00:00		2005-06-30 00:00:00		2007-06-30 00:00:00		2007-03-31 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-09-30 00:00:00		2008-03-31 00:00:00		2007-09-30 00:00:00		2008-06-30 00:00:00		2007-12-31 00:00:00		2008-09-30 00:00:00		2009-09-30 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-03-31 00:00:00		2009-12-31 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		2010-12-31 00:00:00		2011-03-31 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-03-31 00:00:00		2012-06-30 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		2014-12-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-03-31 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		2018-06-30 00:00:00		2018-09-30 00:00:00		2017-12-31 00:00:00		2018-03-31 00:00:00		2019-06-30 00:00:00		2019-06-30 00:00:00		2019-03-31 00:00:00		2018-12-31 00:00:00		2020-03-31 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2019-09-30 00:00:00		2020-09-30 00:00:00		2020-12-31 00:00:00		2021-09-30 00:00:00		2021-06-30 00:00:00		2021-03-31 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2020-09-30 00:00:00		2022-03-31 00:00:00
cum_beg_dt		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		F24778		F24778		F24778		F24778		F24778		F24778		F24778		F24778		F24778		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101
firm_name		PAUL HASTINGS JANOFSKY & WALKER LLP		PAUL HASTINGS JANOFSKY & WALKER LLP		PAUL HASTINGS JANOFSKY & WALKER LLP		PAUL, HASTINGS, JANOFSKY & WALKER LLP		PAUL, HASTINGS, JANOFSKY & WALKER LLP		PAUL, HASTINGS, JANOFSKY & WALKER LLP		PAUL, HASTINGS, JANOFSKY & WALKER LLP		PAUL, HASTINGS, JANOFSKY & WALKER LLP		PAUL, HASTINGS, JANOFSKY & WALKER LLP		Paul Hastings Janofsky & Walker LLP		Paul, Hastings, Janofsky & Walker LLP		Paul Hastings Janofsky & Walker LLP		Paul, Hastings, Janofsky & Walker		Paul Hastings Janofsky & Walker		Paul, Hastings, Janofsky & Walker		Paul, Hastings, Janofsky & Walker		Paul, Hastings, Janofsky & Walker		Paul Hastings Janofsky & Walker		Paul Hastings Janofsky & Walker		Paul, Hastings, Janofsky & Walker		Paul Hastings Janofsky & Walker		Paul, Hastings, Janofsky & Walker		Paul, Hastings, Janofsky & Walker		Paul Hastings Janofsky & Walker		Paul Hastings Janofsky & Walker		Paul Hastings Janofsky & Walker		Paul Hastings Janofsky & Walker		Paul, Hastings, Janofsky & Walker		Paul, Hastings, Janofsky & Walker		Paul, Hastings, Janofsky & Walker		Paul, Hastings, Janofsky & Walker		Paul, Hastings, Janofsky & Walker		Paul, Hastings, Janofsky & Walker		PAUL HASTINGS, LLP		Paul Hastings, LLP		PAUL, HASTINGS		Paul Hastings, LLP		Paul Hastings, LLP		PAUL HASTINGS, LLP		PAUL HASTINGS, LLP		Paul Hastings, LLP		Paul Hastings, LLP		Paul Hastings, LLP		Paul Hastings, LLP		Paul Hastings, LLP		Paul Hastings, LLP		Paul Hastings, LLP		Paul Hastings, LLP		Paul Hastings, LLP		Paul Hastings, LLP		Paul Hastings LLP		Paul Hastings LLP		Paul Hastings, LLP		Paul Hastings		Paul Hastings LLP		PAUL HASTINGS LLP		Paul Hastings LLP		Paul Hastings, LLP		Paul Hastings, LLP		Paul Hatings, LLP		Paul Hastings LLP		Paul Hastings LLP		Paul Hastings, LLP		Paul Hastings LLP		Paul Hastings LLP		Paul Hastings LLP		Paul Hastings, LLP		Paul Hastings LLP		Hoffman Advocacy		Hoffman Advocacy		Hoffman Advocacy		Paul Hastings LLP		Hoffman Advocacy		Hoffman Advocacy		Hoffman Advocacy		Hoffman Advocacy		Hoffman Advocacy		Hoffman Advocacy		Hoffman Advocacy		Hoffman Advocacy		Hoffman Advocacy		Hoffman Advocacy		Hoffman Advocacy		Hoffman Advocacy		Hoffman Advocacy
firm_city		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		San Francisco		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		LOOMIS		LOOMIS		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS		LOOMIS		LOOMIS		LOOMIS		LOOMIS		LOOMIS		LOOMIS		LOOMIS		LOOMIS		LOOMIS		LOOMIS
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
firm_zip4		94104		94104		94104		94104		94105		94105		94105		94105		94105		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95814		95814		95650		95650		95650		95650		95650		95650		95650		95650		95650		95650		95650		95650		95650
firm_phon		415-835-1600		415-835-1600		415-835-1600		415-835-1600		415-856-7000		415-856-7000		415-856-7000		415-856-7000		415-856-7000		9165526830		9165526830		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165522881		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9165526830		9165526830		9165526830		9165526830		9165526830		9165526830		9165526830		9165522881		9165526830		9165526830		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9165522881		9162163323		9162163323		9165526830		9165522881		9162163323		9162163323		9162163323		9162163323		9162163323		9162163323		9162163323		9162163323		9162163323		9162163323		9162163323		9162163323		9162163323
mail_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2001-04-04 00:00:00		2001-07-10 00:00:00		2001-10-02 00:00:00		2002-01-05 00:00:00		2002-04-11 00:00:00		2002-07-10 00:00:00		2002-10-03 00:00:00		2003-01-16 00:00:00		2003-04-10 00:00:00		2003-07-10 00:00:00		2004-07-07 00:00:00		2004-10-01 00:00:00		2005-01-13 00:00:00		2005-10-28 00:00:00		2005-04-28 00:00:00		2006-04-26 00:00:00		2006-01-30 00:00:00		2005-07-29 00:00:00		2007-07-30 00:00:00		2007-04-25 00:00:00		2006-07-27 00:00:00		2007-01-30 00:00:00		2006-10-30 00:00:00		2008-04-18 00:00:00		2007-10-26 00:00:00		2008-07-28 00:00:00		2008-01-25 00:00:00		2008-10-28 00:00:00		2009-10-27 00:00:00		2009-01-30 00:00:00		2009-07-28 00:00:00		2009-04-27 00:00:00		2010-01-26 00:00:00		2010-10-26 00:00:00		2010-07-26 00:00:00		2010-04-27 00:00:00		2011-01-31 00:00:00		2011-04-12 00:00:00		2011-10-12 00:00:00		2011-07-14 00:00:00		2012-01-25 00:00:00		2012-10-16 00:00:00		2012-04-12 00:00:00		2012-07-17 00:00:00		2013-01-14 00:00:00		2013-10-29 00:00:00		2013-07-15 00:00:00		2013-04-18 00:00:00		2013-01-10 00:00:00		2014-10-29 00:00:00		2014-07-29 00:00:00		2014-04-30 00:00:00		2015-01-21 00:00:00		2015-10-21 00:00:00		2015-07-27 00:00:00		2015-04-20 00:00:00		2016-01-05 00:00:00		2016-07-26 00:00:00		2016-10-12 00:00:00		2016-04-27 00:00:00		2017-07-13 00:00:00		2017-04-20 00:00:00		2016-01-24 00:00:00		2017-10-27 00:00:00		2018-07-13 00:00:00		2018-10-11 00:00:00		2018-01-05 00:00:00		2018-04-23 00:00:00		2019-07-18 00:00:00		2019-07-18 00:00:00		2019-04-03 00:00:00		2019-01-29 00:00:00		2020-04-16 00:00:00		2020-01-10 00:00:00		2020-07-09 00:00:00		2019-10-08 00:00:00		2020-10-29 00:00:00		2021-01-11 00:00:00		2021-10-22 00:00:00		2021-07-06 00:00:00		2021-04-29 00:00:00		2022-01-19 00:00:00		2022-07-20 00:00:00		2022-10-11 00:00:00		2022-04-14 00:00:00
sig_loc		Sacramento CA		Sacramento CA		Sacramento CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		San Francisco, CA		San Francisco, CA		San Francisco, 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		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		Loomis, CA		Loomis, CA		Sacramento, CA		Loomis, CA		Loomis, CA		Loomis, CA		Loomis, CA		Loomis, CA		Loomis, CA		Loomis, CA		Loomis, CA		Loomis, CA		Loomis, CA		Loomis, CA		Loomis, CA		Loomis, CA
sig_naml		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman
sig_namf		Robert		Robert		Robert		Robert		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert P.		Robert		Robert P.		Robert P.		Robert P.		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert
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
sig_nams		Jr.		Jr.		Jr.		Jr.		Jr.		Jr.		Jr.		Jr.		Jr.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Hoffman		None		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman		Hoffman
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		Robert P.		None		Robert P.		Robert P.		Robert		Robert P.		Robert P.		Robert P.		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert		Robert
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
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
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		Of Counsel		None		Of Counsel		Of Counsel		None		Of Counsel		Of Counsel		Of Counsel		Of Counsel		Of Counsel		Of Counsel		Of Counsel		Of Counsel		Of Counsel		Of Counsel		Of Counsel		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Partner		Owner		Owner		Owner		Partner		Owner		Owner		Lobbyist		Owner		Owner		Owner		Lobbyist		Lobbyist		Owner		Lobbyist		Lobbyist		Lobbyist		Lobbyist
nopart1_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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Table: cvr_registration

filing_id		1069582		1273616		1384004		1555218		1721774		1917003		2113095		2113095		2336219		2536946
amend_id		0		0		0		0		0		0		0		1		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F604		F604		F604		F604		F604		F604		F604		F604		F604		F604
sender_id		F24778		F24778		F24778		F24778		F24778		F24778		F24778		F24778		F24778		1416073
filer_id		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101
entity_cd		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY
filer_naml		Hoffman		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN
filer_namf		Robert P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.
filer_namt		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None
report_num		000		000		000		000		000		000		000		001		000		000
rpt_date		2005-01-03 00:00:00		2007-06-13 00:00:00		2008-12-16 00:00:00		2010-12-29 00:00:00		2012-12-31 00:00:00		2014-12-04 00:00:00		2016-12-21 00:00:00		2017-06-30 00:00:00		2019-01-18 00:00:00		2020-12-15 00:00:00
ls_beg_yr		2005		2007		2009		2011		2013		2015		2017		2017		2019		2021
ls_end_yr		2006		2008		2010		2012		2014		2016		2018		2018		2020		2022
qual_date		None		None		None		None		None		None		2017-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00
eff_date		None		None		None		None		None		None		None		None		None		None
bus_city		San Francisco		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS
bus_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
bus_zip4		94105		95814		95814		95814		95814		95814		95814		95814		95814		95650
bus_phon		415-856-7000		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165522881		9162163323
bus_fax		415-856-7100		9164472210		9164472210		4158567176		9164472210		9164472210		9164472210		9164472210		9164472210		None
bus_email		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
mail_city		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None		None
sig_date		2004-12-02 00:00:00		2007-06-13 00:00:00		2008-12-16 00:00:00		2010-12-09 00:00:00		2012-12-31 00:00:00		2014-11-14 00:00:00		2016-12-21 00:00:00		2017-06-30 00:00:00		2019-01-18 00:00:00		2020-12-15 00:00:00
sig_loc		Sacramento, CA		None		None		None		None		None		None		None		None		None
sig_naml		Hoffman		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN
sig_namf		Robert P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.
sig_namt		None		None		None		None		None		None		None		None		None		None
sig_nams		Jr.		None		None		None		None		None		None		None		None		None
prn_naml		Hoffman		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN
prn_namf		Robert P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.
prn_namt		None		None		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None		None		None
sig_title		Of Counsel		None		None		None		None		None		None		None		None		None
stmt_firm		None		None		None		None		None		None		None		None		None		None
ind_cb		None		None		None		None		None		None		None		None		None		None
bus_cb		None		None		None		None		None		None		None		None		None		None
trade_cb		None		None		None		None		None		None		None		None		None		None
oth_cb		None		None		None		None		None		None		None		None		None		None
a_b_name		None		None		None		None		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None		None		None		None		None
descrip_1		None		None		None		None		None		None		None		None		None		None
descrip_2		None		None		None		None		None		None		None		None		None		None
c_less50		None		None		None		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None		None		None		None
ind_class		None		None		None		None		None		None		None		None		None		None
ind_descr		None		None		None		None		None		None		None		None		None		None
bus_class		None		None		None		None		None		None		None		None		None		None
bus_descr		None		None		None		None		None		None		None		None		None		None
auth_name		None		None		None		None		None		None		None		None		None		None
auth_city		None		None		None		None		None		None		None		None		None		None
auth_st		None		None		None		None		None		None		None		None		None		None
auth_zip4		None		None		None		None		None		None		None		None		None		None
lobby_int		None		None		None		None		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None		None		None		None		None
firm_name		Paul, Hastings, Janofsky & Walker LLP		Paul, Hastings, Janofsky & Walker		Paul, Hastings, Janofsky & Walker LLP		Paul, Hastings, Janofky & Walker, LLP		Paul Hastings, LLP		Paul Hastings, LLP		Paul Hastings LLP		Paul Hastings LLP		Paul Hastings, LLP		Hoffman Advocacy
newcert_cb		None		None		None		None		None		None		None		None		None		None
rencert_cb		X		None		X		None		X		None		X		None		None		None
complet_dt		None		2007-01-18 00:00:00		None		2010-11-17 00:00:00		None		2014-11-13 00:00:00		None		2017-02-02 00:00:00		2019-01-10 00:00:00		2020-11-17 00:00:00
lby_reg_cb		X		X		X		X		X		X		X		X		X		X
lby_604_cb		None		None		None		None		None		None		None		None		None		None
st_leg_yn		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y
st_agency		None		None		None		None		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None		None		None		None		None

Table: efs_filing_log

filing_date		2003-07-21 00:00:00		2003-07-21 00:00:00
filingstatus		1		0
vendor		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL
filer_id		1234101		1234101
form_type		F615		F615
error_no		ACCEPTED		ACCEPTED

Table: filer_address

filer_id		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101
adrid		2014344		2028532		2044869		2052230		2081951		2117027		2160390		2204584		2478019		2410838		2470697		2276889		2547874		2510779		2339249
effect_dt		2001-03-19 00:00:00		2002-02-07 00:00:00		2003-01-01 00:00:00		2003-01-02 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2019-02-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2013-01-01 00:00:00		2023-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		2001		2001		2003		2003		2005		2007		2009		2011		2019		2017		2019		2013		2023		2021		2015

Table: filer_ethics_class

filer_id		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101
session_id		2001		2007		2005		2011		2009		2013		2015		2017		2019		2021
ethics_date		2002-02-07 00:00:00		2007-01-18 00:00:00		2005-01-12 00:00:00		2010-11-17 00:00:00		2009-02-19 00:00:00		2013-06-20 00:00:00		2014-11-13 00:00:00		2017-06-22 00:00:00		2019-01-10 00:00:00		2020-11-17 00:00:00

Table: filer_filings

filer_id		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101
filing_id		744300		738658		738661		750658		788299		787694		769215		777467		808210		816655		838454		826763		851631		853213		842086		873983		907189		889543		905069		905894		928871		942973		933602		953113		989283		971922		1024421		1025689		1015431		1062548		1069582		1054912		1072362		1083582		1093839		1078189		1132529		1117104		1103494		1146694		1165336		1188239		1215307		1259441		1235783		1246462		1246462		1273616		1306579		1282973		1295382		1772095		1775412		1868609		1809564		1959541		1940792		1908889		1325463		1347244		1374144		1384004		1413709		1395784		1434790		1416321		1419101		1450256		1460871		1483130		1503263		1555218		1535307		1570921		1561396		1585794		1631570		1617220		1600397		1651855		1671949		1798544		1698932		1927735		1917003		1721774		1731649		1724965		1844803		1759714		1977828		2002481		2365136		2264588		2033326		2058381		2088009		2122781		2125104		2113095		2134688		2152078		2167017		2113095		2370117		2477507		2305331		2390987		2429616		2579642		2336219		2234226		2591069		2191069		2343345		2557593		2350904		2390987		2466020		2536946		2526123		2351930		2412040		2200271		2699619		2666382		2618230		2635322		1993056		2543321		2731342
period_id		165		None		None		165		167		None		166		None		168		None		169		None		170		None		None		171		None		None		None		172		173		174		None		None		None		None		None		178		None		None		181		179		180		None		None		None		183		182		181		184		185		186		187		189		188		None		None		190		192		190		191		None		214		218		216		221		None		219		193		194		195		196		None		196		198		None		197		199		200		201		202		204		203		204		None		205		208		207		206		209		210		215		211		220		220		212		None		212		217		213		222		224		None		234		225		226		227		228		None		228		None		229		230		230		237		242		235		238		240		245		237		233		246		231		236		None		None		238		241		244		243		None		239		232		250		249		247		248		223		244		243
form_id		F615		F604		F999		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F604		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F604		F615		F615		F615		F604		F615		F615		F615		F615		F604		F615		F615		F615		F615		F604		F604		F615		F615		F604		F615		F615		F615		F615		F615		F604		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F604		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F604		F604		F604		F615		F615		F604		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F604		F604		F615		F615		F604		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2001-04-26 00:00:00		2001-03-19 00:00:00		2001-04-04 00:00:00		2001-04-24 00:00:00		2001-10-22 00:00:00		2001-10-17 00:00:00		2001-07-23 00:00:00		2001-07-24 00:00:00		2002-01-18 00:00:00		2002-01-17 00:00:00		2002-04-29 00:00:00		2002-02-07 00:00:00		2002-07-24 00:00:00		2002-07-22 00:00:00		2002-04-29 00:00:00		2002-10-14 00:00:00		2003-01-02 00:00:00		2002-10-30 00:00:00		2003-01-22 00:00:00		2003-01-24 00:00:00		2003-04-24 00:00:00		2003-07-21 00:00:00		2003-04-21 00:00:00		2003-07-22 00:00:00		2004-01-27 00:00:00		2003-10-17 00:00:00		2004-07-15 00:00:00		2004-07-26 00:00:00		2004-04-30 00:00:00		2004-10-20 00:00:00		2005-01-03 00:00:00		2004-10-27 00:00:00		2005-01-14 00:00:00		2005-01-18 00:00:00		2005-01-19 00:00:00		2004-12-30 00:00:00		2005-10-28 00:00:00		2005-07-29 00:00:00		2005-04-28 00:00:00		2006-01-30 00:00:00		2006-04-26 00:00:00		2006-07-27 00:00:00		2006-10-30 00:00:00		2007-04-25 00:00:00		2007-01-30 00:00:00		2007-01-11 00:00:00		2007-06-18 00:00:00		2007-06-13 00:00:00		2008-01-25 00:00:00		2007-07-30 00:00:00		2007-10-26 00:00:00		2013-06-20 00:00:00		2013-07-15 00:00:00		2014-07-29 00:00:00		2014-01-10 00:00:00		2015-04-20 00:00:00		2014-12-12 00:00:00		2014-10-29 00:00:00		2008-04-18 00:00:00		2008-07-28 00:00:00		2008-10-28 00:00:00		2008-12-16 00:00:00		2009-01-02 00:00:00		2009-01-30 00:00:00		2009-07-28 00:00:00		2009-02-19 00:00:00		2009-04-27 00:00:00		2009-10-27 00:00:00		2010-01-26 00:00:00		2010-04-27 00:00:00		2010-07-26 00:00:00		2010-12-29 00:00:00		2010-10-26 00:00:00		2011-01-31 00:00:00		2010-12-29 00:00:00		2011-04-12 00:00:00		2012-01-25 00:00:00		2011-10-12 00:00:00		2011-07-14 00:00:00		2012-04-12 00:00:00		2012-07-17 00:00:00		2013-10-29 00:00:00		2012-10-16 00:00:00		2015-01-21 00:00:00		2014-12-04 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2013-01-14 00:00:00		2014-04-30 00:00:00		2013-04-18 00:00:00		2015-07-27 00:00:00		2016-01-05 00:00:00		2019-02-11 00:00:00		2018-07-13 00:00:00		2016-04-27 00:00:00		2016-07-26 00:00:00		2016-10-12 00:00:00		2017-01-24 00:00:00		2016-12-20 00:00:00		2016-12-21 00:00:00		2017-02-02 00:00:00		2017-04-20 00:00:00		2017-07-13 00:00:00		2017-06-30 00:00:00		2019-04-03 00:00:00		2020-07-09 00:00:00		2018-10-11 00:00:00		2019-07-18 00:00:00		2020-01-10 00:00:00		2021-04-29 00:00:00		2019-01-18 00:00:00		2018-04-23 00:00:00		2021-07-06 00:00:00		2017-10-27 00:00:00		2019-01-29 00:00:00		2020-12-16 00:00:00		2018-12-31 00:00:00		2019-07-18 00:00:00		2020-04-16 00:00:00		2020-12-15 00:00:00		2020-10-29 00:00:00		2019-01-29 00:00:00		2019-10-08 00:00:00		2018-01-05 00:00:00		2022-07-20 00:00:00		2022-04-14 00:00:00		2021-10-22 00:00:00		2022-01-19 00:00:00		2015-10-21 00:00:00		2021-01-11 00:00:00		2022-10-11 00:00:00
stmnt_type		10001		10005		10005		10005		10001		10005		10001		10005		10001		10005		10001		10002		10001		10005		10005		10001		10005		10005		10005		10001		10001		10001		10005		10005		10005		10005		10005		10001		10005		10005		10001		10001		10001		10005		10006		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10006		10001		10001		10001		10001		10006		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10006		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10006		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10002		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001
stmnt_status		11003		11001		11003		11001		11003		11001		11003		11001		11003		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003
session_id		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2007		2007		2007		2007		2007		2007		2013		2013		2013		2013		2015		2015		2013		2007		2007		2007		2009		2009		2007		2009		2009		2009		2009		2009		2009		2009		2011		2009		2009		2011		2011		2011		2011		2011		2011		2011		2013		2011		2013		2015		2013		2013		2011		2013		2013		2015		2015		2019		2017		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2019		2019		2017		2019		2019		2021		2019		2017		2021		2017		2017		2021		2019		2019		2019		2021		2019		2019		2019		2017		2021		2021		2021		2021		2015		2019		2021
user_id		*		CFLAGG		CFLAGG		CFLAGG		*		YBONILLA		*		CFLAGG		*		YBONILLA		*		SARRIAGA		*		YBONILLA		YBONILLA		*		SARRIAGA		YBONILLA		YBONILLA		COMPLETED		COMPLETED		COMPLETED		YBONILLA		KVANG		EMCENTEE		YBONILLA		EMCENTEE		COMPLETED		EMCENTEE		YRODRIGUEZ		COMPLETED		COMPLETED		COMPLETED		YRODRIGU		LTHIBAUL		SARRIAGA		YRODRIGU		YRODRIGU		YRODRIGU		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		YRODRIGU		YRODRIGU		PBANFORD		CFLAGG		*		LTHIBAUL		YRODRIGU		LTHIBAUL		PBANFORD		ASAETERN		ASAETERN		ASAETERN		JINGRAM		GKURIMOT		ASAETERN		YRODRIGU		LTHIBAUL		CFLAGG		YRODRIGU		DMCCASTL		CFLAGG		YRODRIGU		YRODRIGU		YRODRIGU		CFLAGG		CFLAGG		JINGRAM		ASAETERN		PBANFORD		ASAETERN		ASAETERN		PBANFORD		JINGRAM		ASAETERN		ASAETERN		ASAETERN		ASAETERN		AGLADNEY		ASAETERN		ASAETERN		AGLADNEY		CAFILER		SARRIAGA		SARRIAGA		ASAETERN		ASAETERN		ASAETERN		JINGRAM		AGLADNEY		SARRIAGA		AGLADNEY		AGLADNEY		AGLADNEY		JINGRAM		AGLADNEY		PBANFORD		PBANFORD		KBANH		JINGRAM		SMCCONNAN		CAFILER		VUKSTINA		VUKSTINA		JFRONEFIELD		VUKSTINA		VUKSTINA		CHARTRIDGE		CAFILER		AGLADNEY		CHATRIDGE		SMCCONNAN		AGLADNEY		MMERCHANT		PBANFORD		VUKSTINA		SUSHAKOV		MMERCHANT		MMERCHANT		PBANFORD		GTAYLOR		AGLADNEY		CAFILER		CAFILER		GTAYLOR		RATTIYEH		JINGRAM		MKIRKHAM		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11003		11003		11003		11002		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
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		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003
rpt_start		2001-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		1900-01-01 00:00:00		2002-04-01 00:00:00		2002-04-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2004-04-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2005-01-03 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		1900-01-01 00:00:00		2005-07-01 00:00:00		2005-04-01 00:00:00		2005-01-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		2006-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-06-13 00:00:00		2007-10-01 00:00:00		2007-04-01 00:00:00		2007-07-01 00:00:00		1900-01-01 00:00:00		2013-04-01 00:00:00		2014-04-01 00:00:00		2013-10-01 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2008-12-16 00:00:00		1900-01-01 00:00:00		2008-10-01 00:00:00		2009-04-01 00:00:00		1900-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-12-29 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		1900-01-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2011-04-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2013-07-01 00:00:00		2012-07-01 00:00:00		2014-10-01 00:00:00		2014-12-04 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2015-04-01 00:00:00		2015-10-01 00:00:00		1900-01-01 00:00:00		2018-04-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		1900-01-01 00:00:00		2016-12-21 00:00:00		None		2017-01-01 00:00:00		2017-04-01 00:00:00		2017-06-30 00:00:00		2019-01-01 00:00:00		2020-04-01 00:00:00		2018-07-01 00:00:00		2019-04-01 00:00:00		2019-10-01 00:00:00		2021-01-01 00:00:00		2019-01-18 00:00:00		2018-01-01 00:00:00		2021-04-01 00:00:00		2017-07-01 00:00:00		2018-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-04-01 00:00:00		2020-01-01 00:00:00		2020-12-15 00:00:00		2020-07-01 00:00:00		1900-01-01 00:00:00		2019-07-01 00:00:00		2017-10-01 00:00:00		2022-04-01 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2015-07-01 00:00:00		2020-10-01 00:00:00		2022-07-01 00:00:00
rpt_end		2001-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		1900-01-01 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-03-31 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-09-30 00:00:00		2005-01-03 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		1900-01-01 00:00:00		2005-09-30 00:00:00		2005-06-30 00:00:00		2005-03-31 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2007-03-31 00:00:00		2006-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-06-13 00:00:00		2007-12-31 00:00:00		2007-06-30 00:00:00		2007-09-30 00:00:00		1900-01-01 00:00:00		2013-06-30 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-12-16 00:00:00		1900-01-01 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		1900-01-01 00:00:00		2009-03-31 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-12-29 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2011-06-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2013-09-30 00:00:00		2012-09-30 00:00:00		2014-12-31 00:00:00		2014-12-04 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2013-03-31 00:00:00		2015-06-30 00:00:00		2015-12-31 00:00:00		1900-01-01 00:00:00		2018-06-30 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		1900-01-01 00:00:00		2016-12-21 00:00:00		None		2017-03-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2019-03-31 00:00:00		2020-06-30 00:00:00		2018-09-30 00:00:00		2019-06-30 00:00:00		2019-12-31 00:00:00		2021-03-31 00:00:00		2019-01-18 00:00:00		2018-03-31 00:00:00		2021-06-30 00:00:00		2017-09-30 00:00:00		2018-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-06-30 00:00:00		2020-03-31 00:00:00		2020-12-15 00:00:00		2020-09-30 00:00:00		1900-01-01 00:00:00		2019-09-30 00:00:00		2017-12-31 00:00:00		2022-06-30 00:00:00		2022-03-31 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2015-09-30 00:00:00		2020-12-31 00:00:00		2020-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
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		22001		22006		None		None		None		None		None		22006		None		None		22001		22006		22006		None		None		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		None		22006		22006		22006		22006		None		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		None		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		None		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006

Table: filer_to_filer_type

filer_id		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101
filer_type		4		4		4		4		4		4		4		4		4		4		4		4
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		None		None		None		None		None		None		None		None		None		None		None
session_id		2001		2003		2005		2007		2011		2013		2009		2015		2021		2019		2017		2023
category		0		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
sub_category		0		None		None		None		None		None		None		None		None		None		None		None
effect_dt		2001-03-19 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		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
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		2001-01-01 00:00:00		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
county_cd		0		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

Table: filer_xref

filer_id		1234101
xref_id		1234101
effect_dt		2001-04-05 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101
filer_id		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101
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
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
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
naml		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN		HOFFMAN
namf		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.		ROBERT P.
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
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
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
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
city		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		LOOMIS		LOOMIS		LOOMIS
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
zip4		941042635		95814		941053441		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95650		941042635		95814		941053441		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95650		941042635		95814		941053441		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95650		941042635		95814		941053441		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95650		941042635		95814		941053441		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95650		941042635		95814		941053441		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95650		941042635		95814		941053441		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95650		941042635		95814		941053441		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95650		941042635		95814		941053441		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95650		941042635		95814		941053441		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95650		941042635		95814		941053441		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95650		941042635		95814		941053441		95814		95814		95814		95814		95814		95814		95814		95814		95814		95650		95650		95650
phon		4158351600		9165526830		4158567000		9165526830		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9162163323		9162163323		9162163323		4158351600		9165526830		4158567000		9165526830		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9162163323		9162163323		9162163323		4158351600		9165526830		4158567000		9165526830		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9162163323		9162163323		9162163323		4158351600		9165526830		4158567000		9165526830		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9162163323		9162163323		9162163323		4158351600		9165526830		4158567000		9165526830		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9162163323		9162163323		9162163323		4158351600		9165526830		4158567000		9165526830		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9162163323		9162163323		9162163323		4158351600		9165526830		4158567000		9165526830		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9162163323		9162163323		9162163323		4158351600		9165526830		4158567000		9165526830		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9162163323		9162163323		9162163323		4158351600		9165526830		4158567000		9165526830		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9162163323		9162163323		9162163323		4158351600		9165526830		4158567000		9165526830		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9162163323		9162163323		9162163323		4158351600		9165526830		4158567000		9165526830		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9162163323		9162163323		9162163323		4158351600		9165526830		4158567000		9165526830		9165522881		9165526830		9165526830		9165522881		9165522881		9165522881		9165522881		9165526830		9162163323		9162163323		9162163323
fax		4152175333		9164472210		4158567100				9164472210		9164472210		4158567581		9164472210		4158567076		9164472210		9164472210										4152175333		9164472210		4158567100				9164472210		9164472210		4158567581		9164472210		4158567076		9164472210		9164472210										4152175333		9164472210		4158567100				9164472210		9164472210		4158567581		9164472210		4158567076		9164472210		9164472210										4152175333		9164472210		4158567100				9164472210		9164472210		4158567581		9164472210		4158567076		9164472210		9164472210										4152175333		9164472210		4158567100				9164472210		9164472210		4158567581		9164472210		4158567076		9164472210		9164472210										4152175333		9164472210		4158567100				9164472210		9164472210		4158567581		9164472210		4158567076		9164472210		9164472210										4152175333		9164472210		4158567100				9164472210		9164472210		4158567581		9164472210		4158567076		9164472210		9164472210										4152175333		9164472210		4158567100				9164472210		9164472210		4158567581		9164472210		4158567076		9164472210		9164472210										4152175333		9164472210		4158567100				9164472210		9164472210		4158567581		9164472210		4158567076		9164472210		9164472210										4152175333		9164472210		4158567100				9164472210		9164472210		4158567581		9164472210		4158567076		9164472210		9164472210										4152175333		9164472210		4158567100				9164472210		9164472210		4158567581		9164472210		4158567076		9164472210		9164472210										4152175333		9164472210		4158567100				9164472210		9164472210		4158567581		9164472210		4158567076		9164472210		9164472210
email		None		None		None		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1234101

Table: lobbying_chg_log

filer_id		1234101		1234101
change_no		1		2
session_id		2001		2019
log_dt		2001-03-19 00:00:00		2019-02-07 00:00:00
filer_type		4		4
correction_flg		Y		None
action		ADDED		DELETED
attribute_changed		FIRM		FIRM
ethics_dt		None		None
interests		None		None
filer_full_name		HOFFMAN, ROBERT P.		ROBERT P. HOFFMAN
filer_city		None		None
filer_st		None		None
filer_zip		None		None
filer_phone		None		None
entity_type		3		3
entity_name		PAUL, HASTINGS, JANOFSKY & WALKER LLP		PAUL HASTINGS LLP
entity_city		None		None
entity_st		None		None
entity_zip		None		None
entity_phone		None		None
entity_id		1223535		1223535
responsible_officer		None		None
effect_dt		2001-03-19 00:00:00		2019-02-01 00:00:00

Table: received_filings

filer_id		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101		1234101
filing_file_name		744300_0.cal		769215_0.cal		788299_0.cal		808210_0.cal		838454_0.cal		851631_0.cal		873983_0.cal		905894_0.cal		928871_0.cal		942973_0.cal		1069582_0.cal		1273616_0.cal		1384004_0.cal		1555218_0.cal		1721774_0.cal		2113095_1.cal		2113095_0.cal		1917003_0.cal		2336219_0.cal		2536946_0.cal
received_date		2001-04-26 00:00:00		2001-07-23 00:00:00		2001-10-22 00:00:00		2002-01-18 00:00:00		2002-04-29 00:00:00		2002-07-24 00:00:00		2002-10-14 00:00:00		2003-01-24 00:00:00		2003-04-24 00:00:00		2003-07-21 00:00:00		2005-01-03 00:00:00		2007-06-13 00:00:00		2008-12-16 00:00:00		2010-12-29 00:00:00		2012-12-31 00:00:00		2017-06-30 00:00:00		2016-12-21 00:00:00		2014-12-04 00:00:00		2019-01-18 00:00:00		2020-12-15 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
filing_id		744300		769215		788299		808210		838454		851631		873983		905894		928871		942973		1069582		1273616		1384004		1555218		1721774		2113095		2113095		1917003		2336219		2536946
form_id		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F604		F604		F604		F604		F604		F604		F604		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		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted