Home

Filer ID: 1143643

Table: filer_address

filer_id		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643
adrid		1108037		1109180		2043060		2081223		2116561		2164139		2210079		2418104		2470075		2470076		2266316		2547329		2547330		2510763		2510764		2341796		2335246		2351197
effect_dt		1999-01-01 00:00:00		1995-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2013-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00		2014-10-22 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7082		7051		7051		7082		7051		7082		7051		7051		7082
session_id		1999		1995		2003		2005		2007		2009		2011		2017		2019		2019		2013		2023		2023		2021		2021		2015		2013		2015

Table: filer_filings

filer_id		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643
filing_id		464871		468009		479061		481102		475536		482362		484648		491967		485953		476807		495635		471252		541517		488261		484648		473511		470019		471252		489641		495635		466001		488261		493354		620778		631639		682134		666503		697263		713829		708234		772817		741806		742851		755193		777764		772817		797633		798525		815076		793196		820192		838638		840905		861253		893417		899929		854128		920657		885097		912171		945686		931030		936498		956161		968559		973671		986403		1012617		1032768		1018173		997057		1027974		1053951		1074636		1064895		1066623		1085774		1101094		1092876		1116961		1129441		1143833		1163422		1185698		1212406		1223075		1259978		1235792		1248559		1305875		1297401		1284994		1259978		1783034		1981849		1931592		1943677		1801405		1911583		1900609		1329876		1305875		1348972		1377686		1377686		1382767		1418647		1411131		1395809		1436626		1460730		1452114		1482509		1507834		1538679		1555801		1565000		1590555		1550371		1605209		1636431		1621280		1657713		1819456		1681268		1931592		1709561		1873013		1734834		1733439		1846529		1762068		1763659		1993446		1966038		1966038		2207487		2396307		2417947		2317304		2365140		2010848		2036306		2062251		2097514		2130149		2155977		2130149		2144094		2172039		2380212		2484159		2275168		2466495		2519586		2466495		2275168		2577967		2333749		2240994		2345395		2432675		2432675		2189907		2380212		2543881		2484159		2615496		2667471		2543881		2705295		2705295		2595509		2620057		2640717		2750953
period_id		141		157		159		144		143		152		145		147		153		151		148		150		156		146		145		158		142		150		154		148		149		146		155		160		161		163		None		163		None		164		166		164		165		165		None		166		None		None		168		167		None		169		None		None		None		None		170		None		171		172		174		173		None		None		175		None		176		177		None		None		None		178		179		180		None		180		None		181		None		182		183		184		185		186		187		188		189		188		None		192		191		190		189		214		222		220		None		215		219		None		193		192		194		195		195		196		197		None		196		198		200		199		201		202		203		None		204		205		204		206		208		206		209		216		210		220		211		218		212		213		217		None		213		223		221		221		232		238		239		235		None		224		225		226		227		228		229		228		None		230		237		242		234		241		243		241		234		245		237		233		236		240		240		231		237		244		242		247		249		244		250		250		246		None		248		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F690		F690		F635		F635		F635		F635		F690		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		1		0		1		1		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		0		0		0		1		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		1		1		0		0		0		0		1		0		0		1		0		1		0		0		1		0		1		0		0		0		0
filing_date		1995-05-01 00:00:00		1999-04-30 00:00:00		1999-11-03 00:00:00		1996-01-30 00:00:00		1995-10-26 00:00:00		1998-02-02 00:00:00		1996-04-30 00:00:00		1996-10-31 00:00:00		1998-04-30 00:00:00		1997-10-31 00:00:00		1997-01-31 00:00:00		1999-08-17 00:00:00		1999-02-01 00:00:00		1996-11-04 00:00:00		1996-11-04 00:00:00		1999-08-02 00:00:00		1995-07-31 00:00:00		1997-08-01 00:00:00		1998-07-31 00:00:00		1998-02-04 00:00:00		1997-04-30 00:00:00		1996-07-29 00:00:00		1998-11-09 00:00:00		2000-02-09 00:00:00		2000-05-01 00:00:00		2000-10-31 00:00:00		2000-08-03 00:00:00		2000-11-04 00:00:00		2001-01-22 00:00:00		2001-01-10 00:00:00		2001-07-31 00:00:00		2001-02-07 00:00:00		2001-04-23 00:00:00		2001-05-01 00:00:00		2001-07-31 00:00:00		2001-08-09 00:00:00		2001-10-31 00:00:00		2001-08-15 00:00:00		2002-02-01 00:00:00		2001-11-02 00:00:00		2002-01-31 00:00:00		2002-04-29 00:00:00		2002-04-29 00:00:00		2002-07-30 00:00:00		2002-10-31 00:00:00		2003-12-23 00:00:00		2002-07-30 00:00:00		2003-01-31 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2003-07-29 00:00:00		2003-04-30 00:00:00		2003-04-30 00:00:00		2003-07-29 00:00:00		2003-10-29 00:00:00		2003-10-31 00:00:00		2004-01-26 00:00:00		2004-04-29 00:00:00		2004-07-30 00:00:00		2004-04-29 00:00:00		2004-01-27 00:00:00		2004-07-29 00:00:00		2004-10-26 00:00:00		2005-01-24 00:00:00		2004-10-28 00:00:00		2004-12-14 00:00:00		2004-12-22 00:00:00		2005-04-19 00:00:00		2005-01-31 00:00:00		2005-07-29 00:00:00		2005-10-21 00:00:00		2006-01-24 00:00:00		2006-04-20 00:00:00		2006-07-20 00:00:00		2006-10-26 00:00:00		2006-12-06 00:00:00		2007-04-26 00:00:00		2007-01-30 00:00:00		2006-12-19 00:00:00		2008-01-24 00:00:00		2007-10-31 00:00:00		2007-07-31 00:00:00		2007-10-18 00:00:00		2013-07-31 00:00:00		2015-07-31 00:00:00		2015-06-03 00:00:00		2014-12-31 00:00:00		2013-10-31 00:00:00		2014-10-31 00:00:00		2014-10-14 00:00:00		2008-04-30 00:00:00		2008-05-16 00:00:00		2008-07-30 00:00:00		2008-10-31 00:00:00		2008-12-12 00:00:00		2008-12-03 00:00:00		2009-04-24 00:00:00		2009-12-19 00:00:00		2009-01-30 00:00:00		2009-07-30 00:00:00		2010-01-26 00:00:00		2009-10-30 00:00:00		2010-04-26 00:00:00		2010-08-02 00:00:00		2010-10-29 00:00:00		2010-12-23 00:00:00		2011-01-24 00:00:00		2011-04-29 00:00:00		2010-12-13 00:00:00		2011-07-28 00:00:00		2012-01-31 00:00:00		2011-10-28 00:00:00		2012-04-30 00:00:00		2014-01-31 00:00:00		2012-08-01 00:00:00		2015-01-28 00:00:00		2012-10-31 00:00:00		2014-07-31 00:00:00		2013-01-29 00:00:00		2013-01-28 00:00:00		2014-05-01 00:00:00		2013-01-31 00:00:00		2013-04-29 00:00:00		2015-10-22 00:00:00		2015-04-30 00:00:00		2015-09-23 00:00:00		2018-01-29 00:00:00		2019-07-30 00:00:00		2019-10-30 00:00:00		2018-10-30 00:00:00		2019-01-11 00:00:00		2016-01-29 00:00:00		2016-04-29 00:00:00		2016-07-29 00:00:00		2016-10-27 00:00:00		2017-01-31 00:00:00		2017-04-28 00:00:00		2017-04-28 00:00:00		2017-01-09 00:00:00		2017-07-26 00:00:00		2019-04-30 00:00:00		2020-07-30 00:00:00		2018-07-31 00:00:00		2020-04-20 00:00:00		2020-10-21 00:00:00		2020-07-28 00:00:00		2018-07-31 00:00:00		2021-04-28 00:00:00		2019-01-10 00:00:00		2018-04-30 00:00:00		2019-01-30 00:00:00		2020-07-28 00:00:00		2020-01-21 00:00:00		2017-10-24 00:00:00		2020-07-28 00:00:00		2021-01-13 00:00:00		2021-09-17 00:00:00		2021-10-12 00:00:00		2022-04-19 00:00:00		2021-12-03 00:00:00		2022-07-30 00:00:00		2022-08-02 00:00:00		2021-07-22 00:00:00		2021-10-26 00:00:00		2022-01-28 00:00:00		2022-11-02 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10005		10005		10005		10001		10001		10005		10001		10005		10005		10002		10005		10006		10001		10001		10005		10001		10005		10005		10005		10005		10001		10005		10001		10001		10001		10001		10005		10005		10001		10005		10001		10001		10005		10005		10005		10001		10001		10001		10005		10001		10005		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10002		10001		10001		10002		10005		10001		10001		10005		10001		10002		10001		10001		10002		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10002		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10002		10005		10001		10001		10001		10001		10001		10001		10002		10002		10001		10001		10001		10001		10002		10001		10001		10002		10001		10002		10001		10001		10002		10001		10002		10001		10005		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11001		11003		11001		11001		11003		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11003		11001		11003		11003		11003		11001		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11003
session_id		1995		1999		1999		1995		1995		1997		1995		1995		1997		1997		1995		1997		1997		1995		1995		1999		1995		1997		1997		1995		1997		1995		1997		1999		1999		1999		1999		1999		2001		1999		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2003		2005		2005		2005		2005		2005		2005		2007		2007		2005		2007		2007		2007		2007		2007		2013		2015		2013		2015		2013		2013		2013		2007		2007		2007		2007		2007		2009		2009		2009		2007		2009		2009		2009		2009		2009		2009		2011		2009		2011		2011		2011		2011		2011		2011		2013		2011		2013		2011		2013		2011		2013		2013		2013		2013		2015		2015		2015		2017		2019		2019		2017		2019		2015		2015		2015		2015		2015		2017		2015		2017		2017		2019		2019		2017		2019		2019		2019		2017		2021		2019		2017		2017		2019		2019		2017		2019		2019		2019		2021		2021		2019		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		*		DHORRELL		YBONILLA		SARRIAGA		*		*		YBONILLA		*		LTHIBAUL		YBONILLA		*		LTHIBAUL		YBONILLA		*		DHORRELL		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		SARRIAGA		*		LTHIBAUL		*		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		LTHIBAUL		COMPLETED		COMPLETED		GPEREZ		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		SARRIAGA		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		SARRIAGA		LTHIBAUL		YRODRIGU		YRODRIGU		LTHIBAUL		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		ASAETERN		AGLADNEY		YRODRIGU		RGEREMIA		YRODRIGU		LTHIBAUL		ASAETERN		ASAETERN		*		WBROWN		MGUERRA		ASAETERN		WBROWN		WBROWN		WBROWN		ASAETERN		ASAETERN		ASAETERN		PBANFORD		ASAETERN		CFLAGG		YRODRIGU		ASAETERN		ASAETERN		AGLADNEY		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		PBANFORD		RGEREMIA		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		VUKSTINA		VUKSTINA		AGLADNEY		SARRIAGA		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		SARRIAGA		AGLADNEY		AGLADNEY		MKIRKHAM		AGLADNEY		GTAYLOR		CHARTRIDGE		GTAYLOR		AGLADNEY		CHATRIDGE		SARRIAGA		AGLADNEY		AGLADNEY		GTAYLOR		GTAYLOR		AGLADNEY		GTAYLOR		GTAYLOR		CAFILER		CHATRIDGE		CAFILER		CAFILER		CAFILER		CAFILER		GTAYLOR		MKIRKHAM		RATTIYEH		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11002		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11003		11001		11003
rpt_start		1995-01-01 00:00:00		1999-01-01 00:00:00		1999-07-01 00:00:00		1995-10-01 00:00:00		1995-07-01 00:00:00		1997-10-01 00:00:00		1996-01-01 00:00:00		1996-07-01 00:00:00		1998-01-01 00:00:00		1997-07-01 00:00:00		1996-10-01 00:00:00		1997-04-01 00:00:00		1998-10-01 00:00:00		1996-04-01 00:00:00		1996-01-01 00:00:00		1999-04-01 00:00:00		1995-04-01 00:00:00		1997-04-01 00:00:00		1998-04-01 00:00:00		1996-10-01 00:00:00		1997-01-01 00:00:00		1996-04-01 00:00:00		1998-07-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		1900-01-01 00:00:00		2000-10-01 00:00:00		2001-04-01 00:00:00		2000-10-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		2002-04-01 00:00:00		2002-10-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2003-10-01 00:00:00		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2004-12-14 00:00:00		1900-01-01 00:00:00		2005-01-01 00:00:00		2004-10-01 00:00:00		2005-04-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		2006-12-06 00:00:00		2007-01-01 00:00:00		2006-10-01 00:00:00		1900-01-01 00:00:00		2007-10-31 00:00:00		2007-07-01 00:00:00		2007-04-01 00:00:00		2007-01-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		2014-10-01 00:00:00		1900-01-01 00:00:00		2013-07-01 00:00:00		2014-07-01 00:00:00		1900-01-01 00:00:00		2008-01-01 00:00:00		2007-10-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-12-03 00:00:00		2009-01-01 00:00:00		1900-01-01 00:00:00		2008-10-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2010-12-13 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2011-06-01 00:00:00		2012-01-01 00:00:00		2013-10-31 00:00:00		2012-04-01 00:00:00		2014-10-01 00:00:00		2012-07-01 00:00:00		2014-04-01 00:00:00		2012-10-01 00:00:00		2013-01-28 00:00:00		2014-01-01 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2017-10-01 00:00:00		2019-04-01 00:00:00		2019-07-01 00:00:00		2018-07-01 00:00:00		1900-01-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		2016-10-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2019-01-01 00:00:00		2020-04-01 00:00:00		2018-04-01 00:00:00		2020-01-01 00:00:00		2020-07-01 00:00:00		2020-01-01 00:00:00		2018-04-01 00:00:00		2021-01-01 00:00:00		2019-01-10 00:00:00		2018-01-01 00:00:00		2018-10-01 00:00:00		2019-10-01 00:00:00		2019-10-01 00:00:00		2017-07-01 00:00:00		2019-01-01 00:00:00		2020-10-01 00:00:00		2020-04-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2020-10-01 00:00:00		2022-04-01 00:00:00		2022-04-01 00:00:00		2021-04-01 00:00:00		1900-01-01 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00
rpt_end		1995-03-31 00:00:00		1999-03-31 00:00:00		1999-09-30 00:00:00		1995-12-31 00:00:00		1995-09-30 00:00:00		1997-12-31 00:00:00		1996-03-31 00:00:00		1996-09-30 00:00:00		1998-03-31 00:00:00		1997-09-30 00:00:00		1996-12-31 00:00:00		1997-06-30 00:00:00		1998-12-31 00:00:00		1996-06-30 00:00:00		1996-03-31 00:00:00		1999-06-30 00:00:00		1995-06-30 00:00:00		1997-06-30 00:00:00		1998-06-30 00:00:00		1996-12-31 00:00:00		1997-03-31 00:00:00		1996-06-30 00:00:00		1998-09-30 00:00:00		1999-12-31 00:00:00		2000-03-31 00:00:00		2000-09-30 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		1900-01-01 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		2002-06-30 00:00:00		2002-12-31 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-03-30 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2004-12-14 00:00:00		1900-01-01 00:00:00		2005-03-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-12-06 00:00:00		2007-03-31 00:00:00		2006-12-31 00:00:00		1900-01-01 00:00:00		2007-12-31 00:00:00		2007-09-30 00:00:00		2007-06-30 00:00:00		2007-03-31 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-12-31 00:00:00		1900-01-01 00:00:00		2013-09-30 00:00:00		2014-09-30 00:00:00		1900-01-01 00:00:00		2008-03-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-09-30 00:00:00		2008-12-03 00:00:00		2009-03-31 00:00:00		1900-01-01 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-09-30 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2010-12-13 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2012-03-30 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2015-12-31 00:00:00		2012-09-30 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2013-01-28 00:00:00		2014-03-31 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2015-03-31 00:00:00		2015-03-31 00:00:00		2017-12-31 00:00:00		2019-06-30 00:00:00		2019-09-30 00:00:00		2018-09-30 00:00:00		1900-01-01 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		2016-12-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2019-03-31 00:00:00		2020-06-30 00:00:00		2018-06-30 00:00:00		2020-03-31 00:00:00		2020-09-30 00:00:00		2020-03-31 00:00:00		2018-06-30 00:00:00		2021-03-31 00:00:00		2019-01-10 00:00:00		2018-03-31 00:00:00		2018-12-31 00:00:00		2019-12-31 00:00:00		2019-12-31 00:00:00		2017-09-30 00:00:00		2019-03-31 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		2021-09-30 00:00:00		2022-03-31 00:00:00		2020-12-31 00:00:00		2022-06-30 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		1900-01-01 00:00:00		2021-12-31 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		22006		22006		None		None		22006		None		22006		22006		None		None		None		22006		22006		22006		None		22001		None		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006

Table: filer_interests

filer_id		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643
session_id		2001		1999		1995		1997		2003		2009		2011		2013		2005		2007		2017		2015		2019		2021		2023
interest_cd		40312		40312		40312		40312		40312		40319		40319		40319		40312		40312		40319		40319		40319		40319		40319
effect_date		2001-01-01 00:00:00		1999-01-01 00:00:00		1995-01-01 00:00:00		1997-01-01 00:00:00		2003-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643
filer_type		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
session_id		1995		1999		1997		2001		2003		2005		2007		2011		2013		2009		2017		2015		2021		2019		2023
category		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
category_type		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
sub_category		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
effect_dt		1995-01-01 00:00:00		1999-01-01 00:00:00		1997-01-01 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
election_type		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		2000-07-01 00:00:00		2000-07-01 00:00:00		None		None		None		None		None		None		None		None
party_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
county_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
district_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1143643
xref_id		C23705
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705		C23705
filer_id		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643
filer_type		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		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		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		TOWARD UTILITY RATE NORMALIZATION		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK (TURN), THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE		UTILITY REFORM NETWORK (TURN); THE
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		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		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94102		94102		94102		94102		94102		94102		94104		94104		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103
phon		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876				4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876		4159298876				4159298876		4159298876				4159298876				4159298876
fax		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132																		4159291132		None						4159291132		4159291132		4159291132		4159291132		4159291132		4159291132
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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: filers

filer_id		1143643

Table: lobbying_chg_log

filer_id		1143643		1143643		1143643
change_no		1		2		0
session_id		1999		2013		2013
log_dt		2001-01-22 00:00:00		2013-01-31 00:00:00		2014-10-14 00:00:00
filer_type		1		1		1
correction_flg		None		Y		None
action		SET ACTIVE		ADDED		ADDED
attribute_changed		CLIENT		FIRM		FIRM
ethics_dt		None		None		None
interests		None		None		None
filer_full_name		UTILITY REFORM NETWORK, THE		UTILITY REFORM NETWORK; THE		UTILITY REFORM NETWORK; THE
filer_city		SACRAMENTO		None		None
filer_st		CA		None		None
filer_zip		95814		None		None
filer_phone		9164464300		None		None
entity_type		3		3		3
entity_name		GOLDBERG & ASSOCIATES, LENNY		GOLDBERG & ASSOCIATES; LENNY		HERNANDEZ STRATEGY GROUP
entity_city		None		None		None
entity_st		None		None		None
entity_zip		None		None		None
entity_phone		None		None		None
entity_id		1147343		0		1252705
responsible_officer		None		None		None
effect_dt		None		2013-01-01 00:00:00		2014-10-14 00:00:00

Table: received_filings

filer_id		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643		1143643
filing_file_name		682134_0.cal		708234_0.cal		742851_0.cal		772817_1.cal		772817_0.cal		793196_0.cal		815076_0.cal		838638_0.cal		854128_0.cal		885097_0.cal		470601.cal		470642.cal		470640.cal		470797.cal		912171_0.cal		931030_0.cal		945686_0.cal		968559_0.cal
received_date		2000-10-31 00:00:00		2001-01-10 00:00:00		2001-04-23 00:00:00		2001-08-09 00:00:00		2001-07-31 00:00:00		2001-11-02 00:00:00		2002-02-01 00:00:00		2002-04-29 00:00:00		2002-07-30 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2003-04-30 00:00:00		2003-07-29 00:00:00		2003-10-29 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		682134		708234		742851		772817		772817		793196		815076		838638		854128		885097		None		None		None		None		912171		931030		945686		968559
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		None		None		None		F635		F635		F635		F635
receive_comment		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings