Home

Filer ID: 1146451

Table: filer_address

filer_id		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451
adrid		1107912		2018236		2055143		2078776		2113801		2164628		2203284		2465347		2413384		2549047		2277151		2509831		2338434
effect_dt		1999-01-26 00:00:00		2001-07-27 00:00:00		2003-08-15 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		2023-01-01 00:00:00		2013-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
session_id		1999		2001		2003		2005		2007		2009		2011		2019		2017		2023		2013		2021		2015

Table: filer_filings

filer_id		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451
filing_id		473887		468355		479491		626878		617754		631165		660455		644768		678364		718425		694597		711999		712248		712256		721263		741390		747665		759301		737556		790365		790376		771163		777487		798540		810465		794829		844427		838605		819495		899938		877583		861779		854631		877583		895065		902175		919454		942771		911644		954302		953317		953573		965899		974425		1007203		1007204		1002961		1007206		1007208		1007210		1007211		1007212		1010304		965899		1011056		1028247		992993		1016710		1024057		1060294		1072416		1060294		1072637		1071240		1068717		1068570		1068079		1068080		1108859		1091974		1100424		1087257		1091285		1100424		1112474		1142305		1128080		1128080		1161879		1183566		1209471		1224323		1230884		1260165		1235998		1277379		1293221		1304011		1780975		1965367		1975801		1846061		1799656		1933652		1947376		1904052		1324204		1304011		1343483		1365790		1385164		1389700		1410226		1417567		1430619		1450833		1458251		1479824		1479824		1479824		1499734		1515765		1499734		1536736		1572635		1589510		1606558		1622416		1479824		1499734		1536736		1572635		1594664		1598622		1589436		1629837		1635146		1622416		1656116		1642199		1816757		1680055		1680055		1914280		1920285		1715723		1923657		1921995		1707263		1715723		1720535		1869903		1723401		1733667		1754446		1752996		1754446		1995903		2360955		2430825		2431101		2372427		2372429		2372433		2209230		2209230		2468437		2006948		2032739		2059185		2099365		2123977		2108781		2111226		2149540		2141787		2379197		2345247		2167473		2418252		2392175		2194332		2522036		2275240		2564105		2440379		2538421		2550832		2589717		2311363		2239940		2392175		2580772		2468437		2672042		2580772		2481291		2598550		2641625		2700196		2468437		2550832		2570053		2617483		2745570		2641625		2700196
period_id		158		157		159		161		160		161		None		162		163		164		163		163		161		162		None		None		165		165		164		166		167		None		None		None		168		None		None		169		None		None		171		None		170		171		None		None		None		174		172		None		None		175		175		None		None		None		None		None		None		None		None		None		None		175		177		None		176		None		178		179		None		179		None		180		None		180		None		None		168		None		181		None		None		181		182		184		182		182		185		186		187		188		188		189		None		190		191		192		214		221		222		217		215		220		None		219		193		192		194		195		196		196		None		197		198		199		200		201		201		201		202		None		202		203		204		205		206		207		201		202		203		204		None		None		206		209		208		207		209		None		216		210		210		None		220		220		None		220		211		212		None		218		213		212		213		None		213		223		237		241		None		None		None		None		232		231		241		224		225		226		227		228		228		None		229		None		237		236		230		239		238		231		243		234		None		240		244		244		None		235		233		238		245		241		249		245		242		246		248		250		241		244		245		247		251		248		250
form_id		F635		F635		F635		F635		F635		F635		F690		F635		F635		F635		F635		F690		F690		F690		F602		F602		F635		F635		F635		F635		F635		F888		F635		F635		F635		F635		F635		F635		F635		F690		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F690		F690		F635		F690		F690		F690		F690		F690		F690		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F602		F690		F690		F690		F690		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F603		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F603		F603		F603		F602		F635		F635		F635		F602		F635		F635		F635		F605		F603		F603		F603		F602		F635		F603		F603		F635		F602		F635		F635		F602		F635		F635		F603		F602		F602		F605		F603		F602		F635		F635		F635		F635		F635		F635		F635		F635		F603		F603		F635		F605		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		1		2		1		0		0		0		0		0		0		1		3		2		1		1		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		1		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		1		0		0		0		0		0		0		0		2		1		0		0		0		1		1
filing_date		1999-08-02 00:00:00		1999-04-30 00:00:00		1999-11-01 00:00:00		2000-04-27 00:00:00		2000-01-31 00:00:00		2000-04-20 00:00:00		2000-08-08 00:00:00		2000-07-26 00:00:00		2000-10-27 00:00:00		2001-01-31 00:00:00		2000-10-27 00:00:00		2000-11-06 00:00:00		2000-11-06 00:00:00		2000-11-06 00:00:00		2001-02-01 00:00:00		2001-03-05 00:00:00		2001-05-02 00:00:00		2001-05-02 00:00:00		2001-01-31 00:00:00		2001-10-29 00:00:00		2001-10-29 00:00:00		2001-07-27 00:00:00		2001-07-31 00:00:00		2001-11-02 00:00:00		2002-01-25 00:00:00		2001-10-30 00:00:00		2002-04-30 00:00:00		2002-04-29 00:00:00		2002-01-30 00:00:00		2002-12-16 00:00:00		2002-10-24 00:00:00		2002-07-30 00:00:00		2002-07-30 00:00:00		2002-10-25 00:00:00		2002-11-04 00:00:00		2002-10-25 00:00:00		2003-01-31 00:00:00		2003-07-18 00:00:00		2003-01-31 00:00:00		2003-07-24 00:00:00		2003-08-18 00:00:00		2003-08-19 00:00:00		2003-10-21 00:00:00		2003-10-22 00:00:00		2004-02-10 00:00:00		2004-02-10 00:00:00		2004-02-10 00:00:00		2004-02-10 00:00:00		2004-02-10 00:00:00		2004-02-10 00:00:00		2004-02-10 00:00:00		2004-02-10 00:00:00		2004-04-08 00:00:00		2004-02-03 00:00:00		2004-04-26 00:00:00		2004-07-26 00:00:00		2004-02-10 00:00:00		2004-04-27 00:00:00		2004-07-20 00:00:00		2004-11-04 00:00:00		2004-11-08 00:00:00		2004-11-08 00:00:00		2004-11-08 00:00:00		2005-01-12 00:00:00		2004-11-08 00:00:00		2004-12-29 00:00:00		2004-08-23 00:00:00		2004-08-23 00:00:00		2002-12-06 00:00:00		2004-05-07 00:00:00		2005-04-15 00:00:00		2004-12-28 00:00:00		2005-01-12 00:00:00		2005-07-13 00:00:00		2005-07-18 00:00:00		2006-01-18 00:00:00		2005-10-14 00:00:00		2005-10-14 00:00:00		2006-04-12 00:00:00		2006-07-11 00:00:00		2006-10-20 00:00:00		2006-12-21 00:00:00		2007-01-23 00:00:00		2007-04-27 00:00:00		2006-12-21 00:00:00		2007-07-16 00:00:00		2007-10-16 00:00:00		2008-01-16 00:00:00		2013-07-30 00:00:00		2015-04-30 00:00:00		2015-07-21 00:00:00		2014-04-30 00:00:00		2013-10-30 00:00:00		2015-01-30 00:00:00		2015-01-05 00:00:00		2014-10-23 00:00:00		2008-04-11 00:00:00		2008-04-08 00:00:00		2008-07-16 00:00:00		2008-10-14 00:00:00		2008-12-23 00:00:00		2009-01-15 00:00:00		2008-12-22 00:00:00		2009-04-16 00:00:00		2009-07-14 00:00:00		2009-10-28 00:00:00		2010-01-19 00:00:00		2010-04-14 00:00:00		2010-04-14 00:00:00		2010-07-22 00:00:00		2010-07-26 00:00:00		2010-08-25 00:00:00		2010-07-08 00:00:00		2010-10-27 00:00:00		2011-01-31 00:00:00		2011-04-28 00:00:00		2011-07-29 00:00:00		2011-10-31 00:00:00		2011-05-12 00:00:00		2011-05-12 00:00:00		2011-05-12 00:00:00		2011-05-12 00:00:00		2011-04-29 00:00:00		2011-06-20 00:00:00		2011-04-28 00:00:00		2012-01-20 00:00:00		2012-01-30 00:00:00		2011-10-31 00:00:00		2012-04-27 00:00:00		2012-01-23 00:00:00		2014-01-30 00:00:00		2012-07-31 00:00:00		2012-07-31 00:00:00		2014-10-31 00:00:00		2014-12-23 00:00:00		2014-10-24 00:00:00		2014-12-23 00:00:00		2014-12-30 00:00:00		2012-10-30 00:00:00		2012-12-04 00:00:00		2012-12-19 00:00:00		2014-07-30 00:00:00		2013-01-08 00:00:00		2013-01-28 00:00:00		2013-04-01 00:00:00		2013-01-10 00:00:00		2013-04-30 00:00:00		2015-10-29 00:00:00		2019-02-20 00:00:00		2020-01-15 00:00:00		2020-01-15 00:00:00		2019-02-25 00:00:00		2019-02-25 00:00:00		2019-01-31 00:00:00		2018-03-01 00:00:00		2018-01-30 00:00:00		2020-10-21 00:00:00		2016-01-26 00:00:00		2016-04-26 00:00:00		2016-07-27 00:00:00		2016-10-28 00:00:00		2017-01-25 00:00:00		2016-11-29 00:00:00		2016-11-30 00:00:00		2017-04-05 00:00:00		2017-02-13 00:00:00		2019-04-29 00:00:00		2019-01-30 00:00:00		2017-07-14 00:00:00		2019-10-30 00:00:00		2019-10-29 00:00:00		2017-10-31 00:00:00		2020-10-23 00:00:00		2018-07-31 00:00:00		2020-12-28 00:00:00		2020-01-30 00:00:00		2020-12-27 00:00:00		2021-01-29 00:00:00		2021-02-26 00:00:00		2018-10-23 00:00:00		2018-04-27 00:00:00		2019-07-23 00:00:00		2022-03-28 00:00:00		2020-04-28 00:00:00		2022-04-27 00:00:00		2021-04-30 00:00:00		2020-07-27 00:00:00		2021-07-28 00:00:00		2022-01-28 00:00:00		2022-07-22 00:00:00		2021-12-09 00:00:00		2022-01-19 00:00:00		2021-03-26 00:00:00		2021-10-20 00:00:00		2022-10-28 00:00:00		2022-10-05 00:00:00		2022-10-28 00:00:00
stmnt_type		10001		10001		10001		10005		10005		10005		10005		10005		10001		10001		10005		10005		10005		10005		10005		10005		10001		10005		10005		10001		10001		10002		10005		10006		10001		10005		10005		10001		10005		10006		10001		10005		10001		10002		10006		10005		10005		10001		10001		10005		10005		10001		10001		10005		10006		10006		10005		10006		10006		10006		10006		10006		10006		10002		10001		10005		10001		10005		10001		10001		10006		10002		10005		10001		10006		10001		10006		10006		10006		10005		10001		10005		10005		10002		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10002		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10002		10002		10002		10005		10001		10001		10001		10001		10001		10002		10002		10002		10002		10002		10005		10002		10001		10001		10001		10001		10001		10005		10001		10001		10002		10006		10001		10002		10005		10001		10001		10001		10005		10001		10001		10001		10001		10005		10002		10001		10001		10001		10005		10006		10005		10005		10002		10001		10002		10001		10001		10001		10001		10001		10001		10005		10001		10006		10001		10001		10001		10001		10002		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10002		10002		10001		10001		10001		10002		10002
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11001		11003		11003		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11001		11003		11001		11001		11001		11001		11003		11003		11003		11001		11001		11003		11003		11003
session_id		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2003		2003		2003		2005		2003		2003		2001		2005		2005		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2007		2007		2007		2007		2007		2013		2015		2015		2013		2013		2013		2015		2013		2007		2007		2007		2007		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2013		2011		2011		2013		2015		2013		2015		2015		2011		2013		2013		2013		2013		2011		2013		2013		2013		2015		2019		2019		2019		2019		2019		2019		2017		2017		2019		2015		2015		2015		2015		2015		2017		2017		2017		2017		2019		2017		2017		2019		2019		2017		2019		2017		2021		2019		2021		2019		2021		2017		2017		2019		2021		2019		2021		2021		2019		2021		2021		2021		2019		2019		2021		2021		2021		2021		2021
user_id		*		*		*		TTHAM		*		TTHAM		YBONILLA		TTHAM		*		*		YBONILLA		YBONILLA		YBONILLA		YBONILLA		TTHAM		GPEREZ		*		DHORRELL		GPEREZ		DHORRELL		*		GPEREZ		LTHIBAUL		YBONILLA		*		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		*		*		YRODRIGU		YRODRIGU		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		GPEREZ		COMPLETED		COMPLETED		LTHIBAUL		DHORRELL		DHORRELL		LTHIBAUL		DHORRELL		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		EMCENTEE		COMPLETED		COMPLETED		LTHIBAUL		DHORRELL		LTHIBAUL		COMPLETED		DHORRELL		GGILMORE		DHORRELL		DHORRELL		COMPLETED		EMCENTEE		COMPLETED		EMCENTEE		EMCENTEE		YRODRIGU		GGILMORE		LTHIBAUL		SARRIAGA		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		SARRIAGA		LTHIBAUL		YRODRIGU		LTHIBAUL		ASAETERN		AGLADNEY		AGLADNEY		ASAETERN		ASAETERN		AGLADNEY		YRODRIGU		ASAETERN		RGEREMIA		LTHIBAUL		LTHIBAUL		JINGRAM		*		JINGRAM		YRODRIGU		MGUERRA		MGUERRA		MGUERRA		ASAETERN		JINGRAM		JINGRAM		ASAETERN		ASAETERN		YRODRIGU		ASAETERN		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		GPEREZ		YRODRIGU		YRODRIGU		ASAETERN		ASAETERN		AGLADNEY		YRODRIGU		ASAETERN		AGLADNEY		AGLADNEY		PBANFORD		PBANFORD		PBANFORD		GKURIMOT		YRODRIGU		AGLADNEY		SARRIAGA		SARRIAGA		AGLADNEY		YRODRIGU		AGLADNEY		ASAETERN		YRODRIGU		ASAETERN		JINGRAM		PBANFORD		GPEREZ		GPEREZ		PBANFORD		PBANFORD		PBANFORD		AGLADNEY		AGLADNEY		CAFILER		MPACHECO		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU		AGLADNEY		PBANFORD		VUKSTINA		AGLADNEY		DMCCASTL		VUKSTINA		GTAYLOR		AGLADNEY		GTAYLOR		AGLADNEY		MMERCHANT		GTAYLOR		MMERCHANT		GTAYLOR		AROJAS		AGLADNEY		AGLADNEY		GTAYLOR		CAFILER		GTAYLOR		CAFILER		CHATRIDGE		GTAYLOR		MKIRKHAM		CHATRIDGE		CAFILER		CAFILER		CAFILER		AROJAS		CHATRIDGE		CAFILER		CAFILER		CAFILER
special_audit		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11003		11002		11003		11003		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11003		11003		11001		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11001		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		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003
rpt_start		1999-04-01 00:00:00		1999-01-01 00:00:00		1999-07-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-01-01 00:00:00		2000-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2000-10-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		None		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-07-01 00:00:00		2002-04-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2003-04-30 00:00:00		2002-10-01 00:00:00		2003-04-30 00:00:00		1900-01-01 00:00:00		2003-08-19 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-04-30 00:00:00		2003-10-01 00:00:00		2003-01-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-07-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-07-31 00:00:00		2004-07-01 00:00:00		2004-07-31 00:00:00		2004-07-31 00:00:00		2004-10-01 00:00:00		2004-04-01 00:00:00		2004-12-29 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2001-10-01 00:00:00		2003-10-01 00:00:00		2005-01-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		2005-10-01 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		2006-12-21 00:00:00		2006-10-01 00:00:00		2007-01-01 00:00:00		1900-01-01 00:00:00		2007-04-01 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2013-04-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2014-01-01 00:00:00		2013-07-01 00:00:00		2014-10-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2007-10-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2008-12-23 00:00:00		2008-10-01 00:00:00		1900-01-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		1900-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-10-31 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-10-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2011-04-28 00:00:00		2012-01-20 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		1900-01-01 00:00:00		2013-10-01 00:00:00		2012-04-01 00:00:00		2012-04-01 00:00:00		1900-01-01 00:00:00		2014-12-23 00:00:00		2014-10-24 00:00:00		1900-01-01 00:00:00		2014-12-30 00:00:00		2012-07-01 00:00:00		2012-12-04 00:00:00		1900-01-01 00:00:00		2014-04-01 00:00:00		2013-01-08 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2019-02-20 00:00:00		2020-01-14 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-10-01 00:00:00		2017-09-01 00:00:00		2020-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		2016-11-29 00:00:00		1900-01-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2019-01-01 00:00:00		2018-10-01 00:00:00		2017-04-01 00:00:00		2019-07-01 00:00:00		2019-04-01 00:00:00		2017-07-01 00:00:00		2020-07-01 00:00:00		2018-04-01 00:00:00		1900-01-01 00:00:00		2019-10-01 00:00:00		2020-11-18 00:00:00		2020-10-01 00:00:00		1900-01-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2019-04-01 00:00:00		2021-01-01 00:00:00		2020-01-01 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2020-04-01 00:00:00		2021-04-01 00:00:00		2021-10-01 00:00:00		2022-04-01 00:00:00		2020-01-01 00:00:00		2020-10-01 00:00:00		2021-02-19 00:00:00		2021-07-01 00:00:00		2022-07-01 00:00:00		2021-10-01 00:00:00		2022-04-01 00:00:00
rpt_end		1999-06-30 00:00:00		1999-03-31 00:00:00		1999-09-30 00:00:00		2000-03-31 00:00:00		1999-12-31 00:00:00		2000-03-31 00:00:00		2000-07-31 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-03-31 00:00:00		2000-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		None		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2002-03-31 00:00:00		2002-03-31 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2002-09-30 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		1900-01-01 00:00:00		2003-08-19 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-03-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-09-30 00:00:00		2003-09-30 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2003-12-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-06-30 00:00:00		2004-12-29 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2001-12-31 00:00:00		2003-12-31 00:00:00		2005-03-31 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-09-30 00:00:00		2005-09-30 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-12-21 00:00:00		2006-12-31 00:00:00		2007-03-31 00:00:00		1900-01-01 00:00:00		2007-06-30 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2013-06-30 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2014-03-31 00:00:00		2013-09-30 00:00:00		2014-12-31 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2008-03-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-12-23 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		1900-01-01 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2011-04-28 00:00:00		2012-01-20 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2012-03-31 00:00:00		1900-01-01 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		1900-01-01 00:00:00		2014-12-23 00:00:00		2014-10-24 00:00:00		1900-01-01 00:00:00		2014-12-30 00:00:00		2012-09-30 00:00:00		2012-12-04 00:00:00		1900-01-01 00:00:00		2014-06-30 00:00:00		2013-01-08 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2019-02-20 00:00:00		2020-01-14 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2020-03-31 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2016-11-29 00:00:00		1900-01-01 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2019-03-31 00:00:00		2018-12-31 00:00:00		2017-06-30 00:00:00		2019-09-30 00:00:00		2019-06-30 00:00:00		2017-09-30 00:00:00		2020-09-30 00:00:00		2018-06-30 00:00:00		1900-01-01 00:00:00		2019-12-31 00:00:00		2020-11-18 00:00:00		2020-12-31 00:00:00		1900-01-01 00:00:00		2018-09-30 00:00:00		2018-03-31 00:00:00		2019-06-30 00:00:00		2021-03-31 00:00:00		2020-03-31 00:00:00		2022-03-31 00:00:00		2021-03-31 00:00:00		2020-06-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2020-03-31 00:00:00		2020-12-31 00:00:00		2021-02-19 00:00:00		2021-09-30 00:00:00		2022-09-30 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		22001		22001		None		None		22001		22001		None		None		None		None		None		None		None		None		None		None		22001		22001		None		22001		None		22001		22001		None		22001		None		22001		None		22001		None		None		None		None		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22006		22006		22006		22006		22006		22006		None		22006		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22006		22006		22006		22006		22006		22006		22006		22006		None		None		22006		22001		22006		22006		22006		None		22006		22006		22006		None		22006		22006		None		22001		22006		22006		None		22006		22001		22006		22006		None		22006		22006		22006		22001		None		None		None		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22001		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22001		22006		22006		22006		22006

Table: filer_interests

filer_id		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451
session_id		2001		1999		2003		2009		2007		2005		2011		2013		2019		2017		2015		2021		2023
interest_cd		40312		40315		40319		40319		40319		40319		40312		40312		40312		40312		40312		40312		40312
effect_date		2001-01-01 00:00:00		1999-01-26 00:00:00		2003-08-15 00:00:00		2009-01-01 00:00:00		2007-01-01 00:00:00		2005-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2019-02-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451
filer_type		1		1		1		1		1		2		2		1		2		1		2		1		1		1		2		1
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		T		Y		N
race		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
session_id		1999		2001		2003		2005		2007		2011		2013		2009		2009		2019		2015		2021		2019		2019		2017		2023
category		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
category_type		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
sub_category		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
effect_dt		1999-01-26 00:00:00		2001-01-01 00:00:00		2003-08-15 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		2010-08-25 00:00:00		2019-02-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2020-01-14 00:00:00		2019-09-30 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
election_type		0		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		None
nyq_dt		None		None		None		2000-07-01 00:00:00		2000-07-01 00:00:00		None		None		None		None		None		None		None		None		None		None		None
party_cd		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
county_cd		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
district_cd		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1146451
xref_id		C28007
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007		C28007
filer_id		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451
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
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
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
naml		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS
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
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
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
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
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
city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SLOUGHOUSE		SLOUGHHOUSE		SLOUGHHOUSE
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
zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		956839998		95683		95683
phon		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499		9164489499
fax		9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182								9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182								9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182								9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182								9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182								9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182								9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182								9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182								9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182								9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182								9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182								9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182								9164480182		9164480182		9164480182		9164480182				9164480182		9164480182		9164480182		9164480182		9164480182
email		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		None		None

Table: filers

filer_id		1146451

Table: lobbying_chg_log

filer_id		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451
change_no		1		2		3		4		0		8		5		6		9		11		10
session_id		1999		2001		2001		2001		2003		2011		2009		2009		2011		2019		2019
log_dt		2000-11-21 00:00:00		2001-03-05 00:00:00		2001-07-27 00:00:00		2002-04-17 00:00:00		2003-08-18 00:00:00		2011-04-29 00:00:00		2010-08-25 00:00:00		2010-08-25 00:00:00		2012-01-23 00:00:00		2020-01-15 00:00:00		2019-01-31 00:00:00
filer_type		1		1		1		2		1		2		1		2		2		1		2
correction_flg		None		Y		Y		Y		Y		Y		None		Y		Y		None		None
action		SET ACTIVE		ADDED		NEW		DELETED		ADDED		ADDED		CHANGED		ADDED		ADDED		SET ACTIVE		CHANGED
attribute_changed		CLIENT		EMPLOYER		ADDRESS & PHONE		FIRM		None		LOBBYIST		NAME		LOBBYIST		FIRM				NAME
ethics_dt		None		None		None		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None		None		None		None
filer_full_name		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION		INDEPENDENT ENERGY PRODUCERS ASSOCIATION
filer_city		HOUSTON		SACRAMENTO		SACRAMENTO		None		None		None		None		SACRAMENTO		SACRAMENTO		None		None
filer_st		TX		CA		CA		None		None		None		None		CA		CA		None		None
filer_zip		77002		95814		95814		None		None		None		None		95814		95814		None		None
filer_phone		7135076400		9164489499		9164489499		None		None		None		None		9164489499		9164489499		None		None
entity_type		3		2		None		3		3		4		1		4		3		1		2
entity_name		EDSON + MODISETTE		MANATT, PHELPS & PHILLIPS, LLP		None		EDSON + MODISETTE		MILLER, OWEN & TROST		RIESENHUBER, AMBER A.		INDEPENDENT ENERGY PRODUCERS ASSOCIATION,		RIESENHUBER, AMBER A.		EDELSTEIN, GILBERT, ROBSON & SMITH, LLC		None		INDEPENDENT ENERGY PRODUCERS ASSOCIATION,
entity_city		None		None		None		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None		None		None
entity_id		1147382		0		None		1147382		1147696		1330845		0		None		None		0		0
responsible_officer		None		None		None		None		None		None		None		None		None		None		None
effect_dt		None		2001-03-02 00:00:00		2001-07-27 00:00:00		2001-12-31 00:00:00		2003-08-15 00:00:00		2011-01-01 00:00:00		2010-08-25 00:00:00		2010-08-25 00:00:00		2012-01-09 00:00:00		2020-01-14 00:00:00		2019-02-01 00:00:00

Table: lobbyist_contributions1

filer_id		1146451		1146451		1146451
filing_period_start_dt		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00
filing_period_end_dt		2001-03-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00
contribution_dt		None		None		None
recipient_name		SENATOR KEVIN MURRAY		SENATOR DEBRA BOWEN		SENATOR BILL MORROW
recipient_id		1071788		1069440		1234028
amount		1000		1000		1000

Table: lobbyist_contributions2

filer_id		1146451		1146451		1146451
filing_period_start_dt		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00
filing_period_end_dt		2001-03-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00
contribution_dt		None		None		None
recipient_name		SENATOR KEVIN MURRAY		SENATOR DEBRA BOWEN		SENATOR BILL MORROW
recipient_id		1071788		1069440		1234028
amount		1000		1000		1000

Table: received_filings

filer_id		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451		1146451
filing_file_name		678364_0.cal		718425_0.cal		280999.cal		281055.cal		281077.cal		747665_0.cal		790365_0.cal		790376_0.cal		810465_0.cal		838605_0.cal		854631_0.cal		877583_0.cal		877583_1.cal		329239.cal		329207.cal		329288.cal		345686.cal		345654.cal		345675.cal		345694.cal		345489.cal		911644_0.cal		150352.cal		150485.cal		942771_0.cal		965899_0.cal		953573_0.cal		965899_1.cal		992993_0.cal		1011056_0.cal		1024057_0.cal		1060294_0.cal		1060294_1.cal		1071240_0.cal		1100424_0.cal		304760.cal		304860.cal		304649.cal		189511.cal		189386.cal		1100424_1.cal		189818.cal		1112474_0.cal		1128080_0.cal		1128080_1.cal		235311.cal		234884.cal		235183.cal		237027.cal		1142305_0.cal		1161879_0.cal		1183566_0.cal		1209471_0.cal		1499734_0.cal		1499734_1.cal		1417567_0.cal		1389700_0.cal		1343483_0.cal		1479824_1.cal		1450833_0.cal		1458251_0.cal		1365790_0.cal		1230884_0.cal		1479824_0.cal		1277379_0.cal		1304011_0.cal		1260165_0.cal		1430619_0.cal		1293221_0.cal		1324204_0.cal		1304011_1.cal		1536736_0.cal
received_date		2000-10-27 00:00:00		2001-01-31 00:00:00		2001-05-02 00:00:00		2001-05-02 00:00:00		2001-05-02 00:00:00		2001-05-02 00:00:00		2001-10-29 00:00:00		2001-10-29 00:00:00		2002-01-25 00:00:00		2002-04-29 00:00:00		2002-07-30 00:00:00		2002-10-24 00:00:00		2002-10-25 00:00:00		2002-10-23 00:00:00		2002-10-23 00:00:00		2002-10-23 00:00:00		2003-01-09 00:00:00		2003-01-09 00:00:00		2003-01-09 00:00:00		2003-01-09 00:00:00		2003-01-09 00:00:00		2003-01-31 00:00:00		2003-07-18 00:00:00		2003-07-18 00:00:00		2003-07-18 00:00:00		2003-10-21 00:00:00		2003-08-19 00:00:00		2004-02-03 00:00:00		2004-02-10 00:00:00		2004-04-26 00:00:00		2004-07-20 00:00:00		2004-11-04 00:00:00		2004-11-08 00:00:00		2005-01-12 00:00:00		2005-04-15 00:00:00		2005-04-15 00:00:00		2005-04-15 00:00:00		2005-04-15 00:00:00		2005-07-13 00:00:00		2005-07-13 00:00:00		2005-07-13 00:00:00		2005-07-13 00:00:00		2005-07-18 00:00:00		2005-10-14 00:00:00		2005-10-14 00:00:00		2006-01-17 00:00:00		2006-01-17 00:00:00		2006-01-17 00:00:00		2006-01-17 00:00:00		2006-01-18 00:00:00		2006-04-12 00:00:00		2006-07-11 00:00:00		2006-10-20 00:00:00		2010-07-08 00:00:00		2010-07-26 00:00:00		2009-04-16 00:00:00		2009-01-15 00:00:00		2008-07-16 00:00:00		2010-04-14 00:00:00		2009-10-28 00:00:00		2010-01-19 00:00:00		2008-10-14 00:00:00		2007-01-23 00:00:00		2010-04-14 00:00:00		2007-07-16 00:00:00		2008-01-16 00:00:00		2007-04-27 00:00:00		2009-07-14 00:00:00		2007-10-16 00:00:00		2008-04-11 00:00:00		2008-04-08 00:00:00		2010-10-27 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/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/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		678364		718425		None		None		None		747665		790365		790376		810465		838605		854631		877583		877583		None		None		None		None		None		None		None		None		911644		None		None		942771		965899		953573		965899		992993		1011056		1024057		1060294		1060294		1071240		1100424		None		None		None		None		None		1100424		None		1112474		1128080		1128080		None		None		None		None		1142305		1161879		1183566		1209471		1499734		1499734		1417567		1389700		1343483		1479824		1450833		1458251		1365790		1230884		1479824		1277379		1304011		1260165		1430619		1293221		1324204		1304011		1536736
form_id		F635		F635		None		None		None		F635		F635		F635		F635		F635		F635		F635		F635		None		None		None		None		None		None		None		None		F635		None		None		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		None		None		None		None		None		F635		None		F635		F635		F635		None		None		None		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
receive_comment		Filing accepted, but but with warnings		Filing accepted, but with warnings		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing 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 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		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted