Home

Filer ID: 1142856

Table: filer_acronyms

acronym		CAAA
filer_id		1142856

Table: filer_address

filer_id		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856
adrid		1107152		2043040		2077938		2116568		2162707		2205465		2415489		2470975		2509428		2276774		2341292		2550740
effect_dt		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		2021-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2023-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1995		2003		2005		2007		2009		2011		2017		2019		2021		2013		2015		2023

Table: filer_filings

filer_id		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856
filing_id		663294		483607		483910		474651		474753		472506		494520		487225		487540		498108		494942		540387		467143		480334		487225		469225		478076		540387		490875		469225		540387		464097		490875		480235		491258		633782		635854		616100		681336		651895		656443		650666		710106		710109		708301		693334		704566		716716		706930		717942		739741		745652		756624		784499		794779		773823		745652		773823		792788		792788		814715		833597		837976		832510		832511		832512		819944		855914		843936		855168		881399		899881		936439		894100		914295		897110		924234		929670		910624		943593		954345		968294		990287		976237		1000134		1012100		1028552		1020992		1012100		1024951		1065877		1018631		1058823		1078941		1095645		1086652		1108027		1103877		1114699		1128977		1107498		1131964		1143429		1168044		1103877		1114699		1131964		1143429		1210508		1190698		1223795		1230890		1230890		1257114		1248156		1257932		1248498		1285505		1297851		1772468		1778392		1778392		1980371		1945401		1964447		1760711		1801582		1945401		1948595		1328799		1310227		1344866		1344866		1375792		1395113		1410516		1421266		1435704		1449296		1421266		1457680		1484292		1484292		1503140		1532526		1550272		1569649		1566132		1569909		1590548		1582039		1590548		1590548		1573500		1606083		1594385		1634000		1634000		1622302		1656487		1675286		1932600		1914079		1914079		1867520		1729420		1729420		1721929		1732347		1707429		1846350		1846350		1816276		1760711		1997555		2309679		2203819		2331318		2374862		2343484		2242850		2013081		2013081		2038748		2064669		2038748		2038748		2064669		2099374		2119427		2115918		2127546		2152281		2125169		2152281		2137051		2135975		2139700		2174751		2152281		2374862		2416607		2333912		2348011		2487060		2571437		2537860		2433343		2557372		2578379		2392252		2555187		2275031		2469097		2189362		2340463		2529230		2588887		2673881		2639005		2594718		2622077		2705046		2744985
period_id		162		152		145		158		143		150		155		153		146		156		148		157		149		144		153		142		151		157		154		142		157		141		154		159		147		None		None		160		163		160		162		161		None		None		None		163		165		None		None		164		164		165		165		166		None		166		165		166		167		167		168		None		169		None		None		None		None		170		None		170		171		None		None		None		None		172		None		173		172		174		None		175		176		None		None		177		None		None		177		178		None		None		179		180		None		None		None		181		182		None		182		183		184		185		181		182		183		184		187		186		188		188		188		None		None		189		None		190		191		None		214		214		222		220		221		213		215		220		None		193		192		194		194		195		196		None		197		198		199		197		200		201		201		202		203		204		205		None		204		205		None		205		205		205		206		None		208		208		207		209		210		221		219		219		218		212		212		212		None		211		217		217		216		213		223		235		232		236		237		None		233		224		224		225		226		225		225		226		227		229		228		228		229		None		229		None		229		None		230		229		237		239		236		None		242		None		244		240		244		245		238		244		234		241		231		236		243		None		249		248		246		247		250		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F635		F690		F635		F635		F690		F690		F690		F635		F635		F635		F635		F635		F635		F999		F635		F635		F690		F635		F635		F602		F603		F602		F635		F602		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F690		F690		F690		F635		F635		F635		F635		F635		F602		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F690		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F602		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F602		F635		F635		F602		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F602		F635		F602		F602		F602		F635		F635		F635		F635		F602		F602		F635		F602		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		2		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		1		1		0		0		0		0		0		1		0		0		0		0		0		0		0		1		0		0		1		0		1		0		0		0		0		0		0		1		0		0		0		0		0		0		1		0		0		1		0		0		0		0		0		0		1		0		0		2		0		0		0		0		1		0		0		0		0		1		0		0		1		0		0		0		0		0		1		0		0		0		0		0		0		1		0		0		1		0		0		0		2		1		1		0		0		0		0		1		0		0		0		0		0		0		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2000-07-31 00:00:00		1998-02-02 00:00:00		1996-04-30 00:00:00		1999-08-02 00:00:00		1995-10-31 00:00:00		1997-07-31 00:00:00		1998-11-02 00:00:00		1998-05-06 00:00:00		1996-07-30 00:00:00		1999-02-01 00:00:00		1997-02-03 00:00:00		1999-06-03 00:00:00		1997-05-08 00:00:00		1996-01-31 00:00:00		1998-11-03 00:00:00		1995-07-26 00:00:00		1997-10-31 00:00:00		1999-07-23 00:00:00		1998-11-03 00:00:00		1995-10-31 00:00:00		1999-05-06 00:00:00		1995-04-27 00:00:00		1998-07-31 00:00:00		1999-11-01 00:00:00		1996-10-31 00:00:00		2000-05-08 00:00:00		2000-04-27 00:00:00		2000-01-31 00:00:00		2000-10-30 00:00:00		2000-05-11 00:00:00		2000-08-30 00:00:00		2000-08-09 00:00:00		2000-12-29 00:00:00		2000-11-29 00:00:00		2001-01-02 00:00:00		2000-10-31 00:00:00		2001-01-02 00:00:00		2001-01-26 00:00:00		2001-01-02 00:00:00		2001-01-30 00:00:00		2001-02-01 00:00:00		2001-04-30 00:00:00		2001-04-30 00:00:00		2001-09-28 00:00:00		2001-10-31 00:00:00		2001-08-02 00:00:00		2002-02-11 00:00:00		2002-02-11 00:00:00		2002-02-11 00:00:00		2001-10-31 00:00:00		2002-01-31 00:00:00		2002-02-19 00:00:00		2002-04-26 00:00:00		2002-02-19 00:00:00		2002-02-19 00:00:00		2002-02-19 00:00:00		2002-01-31 00:00:00		2002-07-30 00:00:00		2002-04-30 00:00:00		2002-07-30 00:00:00		2002-10-28 00:00:00		2002-12-20 00:00:00		2003-04-30 00:00:00		2002-10-31 00:00:00		2002-12-30 00:00:00		2002-12-20 00:00:00		2003-01-31 00:00:00		2003-04-28 00:00:00		2003-01-30 00:00:00		2003-07-22 00:00:00		2003-07-23 00:00:00		2003-10-28 00:00:00		2004-02-02 00:00:00		2003-10-31 00:00:00		2004-02-03 00:00:00		2004-05-04 00:00:00		2004-07-26 00:00:00		2004-05-06 00:00:00		2004-04-28 00:00:00		2004-07-22 00:00:00		2004-11-01 00:00:00		2004-04-30 00:00:00		2004-11-01 00:00:00		2005-01-28 00:00:00		2005-01-31 00:00:00		2004-12-15 00:00:00		2005-05-19 00:00:00		2005-04-28 00:00:00		2005-07-26 00:00:00		2005-02-07 00:00:00		2005-05-13 00:00:00		2005-10-27 00:00:00		2006-02-13 00:00:00		2006-05-01 00:00:00		2006-02-10 00:00:00		2006-02-13 00:00:00		2006-02-13 00:00:00		2006-01-24 00:00:00		2006-10-24 00:00:00		2006-07-31 00:00:00		2006-12-19 00:00:00		2007-01-23 00:00:00		2007-01-23 00:00:00		2007-03-02 00:00:00		2007-01-19 00:00:00		2007-04-19 00:00:00		2006-12-21 00:00:00		2007-07-31 00:00:00		2007-10-31 00:00:00		2013-06-20 00:00:00		2013-07-31 00:00:00		2013-07-25 00:00:00		2015-07-30 00:00:00		2015-03-20 00:00:00		2015-04-29 00:00:00		2014-07-24 00:00:00		2013-10-31 00:00:00		2015-02-20 00:00:00		2015-01-08 00:00:00		2008-04-29 00:00:00		2008-01-30 00:00:00		2008-07-22 00:00:00		2008-07-23 00:00:00		2008-10-30 00:00:00		2009-01-30 00:00:00		2008-12-31 00:00:00		2009-04-30 00:00:00		2009-07-29 00:00:00		2009-10-23 00:00:00		2009-04-30 00:00:00		2010-01-13 00:00:00		2010-04-29 00:00:00		2010-05-12 00:00:00		2010-07-26 00:00:00		2010-10-22 00:00:00		2010-12-10 00:00:00		2011-01-29 00:00:00		2011-01-06 00:00:00		2011-01-30 00:00:00		2011-04-29 00:00:00		2011-01-06 00:00:00		2011-04-29 00:00:00		2011-05-02 00:00:00		2011-02-02 00:00:00		2011-07-29 00:00:00		2011-05-11 00:00:00		2012-01-30 00:00:00		2012-01-31 00:00:00		2011-10-31 00:00:00		2012-04-28 00:00:00		2012-07-26 00:00:00		2015-01-29 00:00:00		2014-11-05 00:00:00		2014-11-04 00:00:00		2014-07-28 00:00:00		2013-02-01 00:00:00		2013-01-21 00:00:00		2012-12-31 00:00:00		2013-01-02 00:00:00		2012-10-30 00:00:00		2014-04-30 00:00:00		2014-05-01 00:00:00		2014-01-30 00:00:00		2013-04-23 00:00:00		2015-10-31 00:00:00		2018-10-21 00:00:00		2018-01-22 00:00:00		2018-12-31 00:00:00		2019-04-23 00:00:00		2018-12-21 00:00:00		2018-04-30 00:00:00		2016-02-02 00:00:00		2016-02-01 00:00:00		2016-05-02 00:00:00		2016-08-01 00:00:00		2016-08-06 00:00:00		2016-05-07 00:00:00		2016-08-31 00:00:00		2016-10-28 00:00:00		2017-01-13 00:00:00		2016-12-30 00:00:00		2017-01-30 00:00:00		2017-04-26 00:00:00		2016-12-19 00:00:00		2017-04-21 00:00:00		2017-01-31 00:00:00		2017-02-10 00:00:00		2017-01-13 00:00:00		2017-07-30 00:00:00		2017-07-18 00:00:00		2019-04-18 00:00:00		2019-10-28 00:00:00		2019-01-11 00:00:00		2019-01-11 00:00:00		2020-07-31 00:00:00		2020-12-29 00:00:00		2020-12-22 00:00:00		2020-01-22 00:00:00		2021-02-11 00:00:00		2021-04-28 00:00:00		2019-07-23 00:00:00		2021-02-01 00:00:00		2018-07-31 00:00:00		2020-04-29 00:00:00		2017-10-21 00:00:00		2019-01-25 00:00:00		2020-10-31 00:00:00		2021-02-16 00:00:00		2022-04-28 00:00:00		2022-01-27 00:00:00		2021-07-20 00:00:00		2021-10-29 00:00:00		2022-07-29 00:00:00		2022-10-28 00:00:00
stmnt_type		10005		10001		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		10005		10001		10005		10001		10001		10005		10005		10005		10005		10001		10005		10005		10001		10005		10001		10005		10005		10005		10001		10002		10002		10002		10001		10001		10005		10001		10005		10005		10005		10005		10005		10005		10001		10001		10005		10005		10005		10005		10001		10005		10001		10001		10001		10005		10001		10001		10005		10005		10002		10005		10006		10001		10001		10005		10005		10001		10001		10005		10005		10005		10001		10001		10005		10001		10001		10002		10001		10002		10002		10002		10001		10001		10001		10001		10001		10002		10005		10005		10001		10005		10001		10001		10005		10002		10001		10001		10002		10001		10002		10001		10001		10005		10001		10001		10001		10002		10001		10001		10005		10001		10001		10001		10002		10001		10001		10002		10001		10001		10001		10001		10005		10001		10002		10005		10001		10002		10001		10001		10005		10001		10002		10001		10001		10001		10001		10002		10001		10001		10002		10001		10001		10005		10001		10001		10002		10001		10001		10001		10001		10001		10001		10002		10001		10001		10002		10001		10001		10001		10002		10002		10002		10001		10001		10001		10001		10002		10005		10001		10001		10001		10005		10001		10002		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		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		11001		11001		11001		11003		11001		11003		11003		11001		11003		11001		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		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		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		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		11003		11003		11001		11001		11001		11003		11003
session_id		1999		1997		1995		1999		1995		1997		1997		1997		1995		1997		1995		1999		1997		1995		1997		1995		1997		1999		1997		1995		1999		1995		1997		1999		1995		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		1999		2001		2001		2001		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2001		2003		2003		2001		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2005		2007		2007		2007		2007		2007		2007		2013		2013		2013		2015		2013		2015		2013		2013		2013		2015		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2011		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2015		2013		2013		2013		2011		2011		2013		2013		2011		2013		2013		2013		2013		2015		2017		2017		2019		2019		2019		2017		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2015		2017		2017		2017		2017		2017		2017		2017		2017		2019		2019		2019		2019		2019		2021		2021		2019		2021		2021		2019		2019		2017		2019		2017		2017		2019		2021		2021		2021		2021		2021		2021		2021
user_id		YBONILLA		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		DHORRELL		TTHAM		*		*		JLEHMAN		*		*		TTHAM		YBONILLA		GGILMORE		YBONILLA		*		GGILMORE		FWALKER		*		YBONILLA		*		YBONILLA		YBONILLA		LTHIBAUL		DHORRELL		*		*		*		*		*		LTHIBAUL		*		DBARRICK		LTHIBAUL		LTHIBAUL		DHORRELL		LTHIBAUL		LTHIBAUL		*		*		PBANFORD		LTHIBAUL		LTHIBAUL		BSMITH		*		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		KVANG		COMPLETED		KLARRY		EMCENTEE		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		SARRIAGA		SARRIAGA		LTHIBAUL		LTHIBAUL		GGILMORE		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		GPEREZ		LTHIBAUL		LTHIBAUL		PBANFORD		GPEREZ		LTHIBAUL		LLEONG		LTHIBAUL		LTHIBAUL		YRODRIGU		AGLADNEY		AGLADNEY		MPACHECO		GCLARA		MPACHECO		AGLADNEY		AGLADNEY		GCLARA		ASAETERN		LTHIBAUL		LTHIBAUL		YRODRIGU		YRODRIGU		JGRISSUM		JGRISSUM		DMCCASTL		JGRISSUM		JGRISSUM		MGUERRA		JGRISSUM		JINGRAM		ASAETERN		ASAETERN		ASAETERN		ASAETERN		YRODRIGU		YRODRIGU		CFLAGG		*		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		YRODRIGU		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		ASAETERN		GCLARA		GCLARA		AGLADNEY		ASAETERN		ASAETERN		SARRIAGA		SARRIAGA		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		MPACHECO		AGLADNEY		AGLADNEY		YRODRIGU		VUKSTINA		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		CAFILER		PBANFORD		AGLADNEY		AGLADNEY		PBANFORD		AGLADNEY		PBANFORD		PBANFORD		PBANFORD		AGLADNEY		AGLADNEY		VUKSTINA		VUKSTINA		SARRIAGA		SARRIAGA		GTAYLOR		SARRIAGA		SARRIAGA		GTAYLOR		CVANLIEW		GTAYLOR		VUKSTINA		GTAYLOR		AGLADNEY		GTAYLOR		AGLADNEY		AGLADNEY		GTAYLOR		CVANLIEW		CAFILER		CHATRIDGE		GTAYLOR		MKIRKHAM		CAFILER		CAFILER
special_audit		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		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
fine_audit		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		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		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11003
rpt_start		2000-04-01 00:00:00		1997-10-01 00:00:00		1996-01-01 00:00:00		1999-04-01 00:00:00		1995-07-01 00:00:00		1997-04-01 00:00:00		1998-07-01 00:00:00		1998-01-01 00:00:00		1996-04-01 00:00:00		1998-10-01 00:00:00		1996-10-01 00:00:00		1999-01-01 00:00:00		1997-01-01 00:00:00		1995-10-01 00:00:00		1998-01-01 00:00:00		1995-04-01 00:00:00		1997-07-01 00:00:00		1999-01-01 00:00:00		1998-04-01 00:00:00		1995-04-01 00:00:00		1999-01-01 00:00:00		1995-01-01 00:00:00		1998-04-01 00:00:00		1999-07-01 00:00:00		1996-07-01 00:00:00		2000-01-01 00:00:00		None		1999-10-01 00:00:00		2000-07-01 00:00:00		1999-10-01 00:00:00		2000-04-01 00:00:00		2000-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2000-07-01 00:00:00		2001-01-02 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2000-10-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-07-01 00:00:00		2001-04-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2001-04-01 00:00:00		2002-01-01 00:00:00		2001-04-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2002-04-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		2003-01-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		2002-12-20 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2002-10-01 00:00:00		2003-04-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-10-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		2003-01-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		2004-10-01 00:00:00		2005-05-12 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-07-01 00:00:00		2006-04-01 00:00:00		2006-12-19 00:00:00		2006-10-01 00:00:00		2006-10-01 00:00:00		1900-01-01 00:00:00		1900-01-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		1900-01-01 00:00:00		2013-04-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		2014-10-01 00:00:00		2015-01-01 00:00:00		2013-01-01 00:00:00		2013-07-01 00:00:00		2014-10-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-04-01 00:00:00		2008-07-01 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-01-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-12-10 00:00:00		2011-01-29 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		1900-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-02-02 00:00:00		2011-04-01 00:00:00		1900-01-01 00:00:00		2011-10-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2015-01-29 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2014-04-01 00:00:00		2012-10-01 00:00:00		2012-10-01 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2012-07-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2013-10-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2018-07-01 00:00:00		2017-10-01 00:00:00		2018-12-31 00:00:00		2019-01-01 00:00:00		1900-01-01 00:00:00		2018-01-01 00:00:00		2015-10-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2017-01-06 00:00:00		2016-12-30 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-02-10 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2019-07-01 00:00:00		2018-12-06 00:00:00		1900-01-01 00:00:00		2020-04-01 00:00:00		1900-01-01 00:00:00		2020-11-12 00:00:00		2019-10-01 00:00:00		2020-12-14 00:00:00		2021-01-01 00:00:00		2019-04-01 00:00:00		2020-10-01 00:00:00		2018-04-01 00:00:00		2020-01-01 00:00:00		2017-07-01 00:00:00		2018-10-01 00:00:00		2020-07-01 00:00:00		1900-01-01 00:00:00		2022-01-01 00:00:00		2021-10-01 00:00:00		2021-04-01 00:00:00		2021-07-01 00:00:00		2022-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		2000-06-30 00:00:00		1997-12-31 00:00:00		1996-03-31 00:00:00		1999-06-30 00:00:00		1995-09-30 00:00:00		1997-06-30 00:00:00		1998-09-30 00:00:00		1998-03-31 00:00:00		1996-06-30 00:00:00		1998-12-31 00:00:00		1996-12-31 00:00:00		1999-03-31 00:00:00		1997-03-31 00:00:00		1995-12-31 00:00:00		1998-03-31 00:00:00		1995-06-30 00:00:00		1997-09-30 00:00:00		1999-03-31 00:00:00		1998-06-30 00:00:00		1995-06-30 00:00:00		1999-03-31 00:00:00		1995-03-31 00:00:00		1998-06-30 00:00:00		1999-09-30 00:00:00		1996-09-30 00:00:00		2000-03-31 00:00:00		None		1999-12-31 00:00:00		2000-09-30 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		2000-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2000-09-30 00:00:00		2001-01-02 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2000-12-31 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-09-30 00:00:00		2001-06-30 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-06-30 00:00:00		2002-03-31 00:00:00		2001-03-01 00:00:00		2001-03-31 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2002-06-30 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		2003-03-31 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		2002-12-20 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-12-31 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		2003-03-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-04-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2005-03-31 00:00:00		2005-06-30 00:00:00		2004-12-31 00:00:00		2005-05-12 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		2005-03-31 00:00:00		2005-06-30 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-09-30 00:00:00		2006-06-30 00:00:00		2006-12-19 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 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		1900-01-01 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-12-31 00:00:00		2015-03-31 00:00:00		2013-03-31 00:00:00		2013-09-30 00:00:00		2014-12-31 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-06-30 00:00:00		2008-09-30 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-03-31 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-10 00:00:00		2011-01-29 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		1900-01-01 00:00:00		2011-03-31 00:00:00		2011-03-31 00:00:00		2011-02-02 00:00:00		2011-06-30 00:00:00		1900-01-01 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2015-01-29 00:00:00		2014-09-30 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2012-09-30 00:00:00		2014-03-31 00:00:00		2014-03-31 00:00:00		2013-12-31 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2018-09-30 00:00:00		2017-12-31 00:00:00		2018-12-31 00:00:00		2019-03-31 00:00:00		1900-01-01 00:00:00		2018-03-31 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-03-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2017-01-06 00:00:00		2016-12-30 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-02-10 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2019-03-31 00:00:00		2019-09-30 00:00:00		2018-12-06 00:00:00		1900-01-01 00:00:00		2020-06-30 00:00:00		1900-01-01 00:00:00		2020-11-12 00:00:00		2019-12-31 00:00:00		2020-12-14 00:00:00		2021-03-31 00:00:00		2019-06-30 00:00:00		2020-12-31 00:00:00		2018-06-30 00:00:00		2020-03-31 00:00:00		2017-09-30 00:00:00		2018-12-31 00:00:00		2020-09-30 00:00:00		1900-01-01 00:00:00		2022-03-31 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		2021-09-30 00:00:00		2022-06-30 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		22001		22001		None		22001		22001		None		None		22006		None		None		22001		22001		None		None		22001		22001		None		None		None		22001		22001		None		22001		22001		22006		22006		22006		22006		22006		22001		22006		22006		22006		22006		22006		None		None		22006		None		22006		22006		None		22006		22006		22001		22006		22001		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		None		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22006		22001		22001		None		22001		None		22006		None		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001

Table: filer_interests

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

Table: filer_to_filer_type

filer_id		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856
filer_type		1		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		T		Y		Y		Y		Y		Y		N
race		0		0		0		0		None		None		None		None		None		0		None		None		None		None		None		None
session_id		1995		1997		1999		2001		2003		2005		2007		2011		2013		2009		2009		2015		2021		2019		2017		2023
category		0		0		0		0		None		None		None		None		None		0		None		None		None		None		None		None
category_type		0		0		0		0		None		None		None		None		None		0		None		None		None		None		None		None
sub_category		0		0		0		0		None		None		None		None		None		0		None		None		None		None		None		None
effect_dt		1995-01-01 00:00:00		1997-01-01 00:00:00		1999-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		2010-12-06 00:00:00		2009-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		0		None		None		None		None		None		0		None		None		None		None		None		None
election_type		0		0		0		0		None		None		None		None		None		0		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		None		None		2000-01-01 00:00:00		2000-01-01 00:00:00		None		None		None		None		None		None		None		None		None
party_cd		None		None		None		None		None		None		None		None		None		0		None		None		None		None		None		None
county_cd		None		None		None		None		None		None		None		None		None		0		None		None		None		None		None		None
district_cd		None		None		None		None		None		None		None		None		None		0		None		None		None		None		None		None

Table: filer_xref

filer_id		1142856
xref_id		C00111
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111		C00111
filer_id		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856
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
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
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
naml		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION
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
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
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
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
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
city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
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
zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
phon		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155		9164445155
fax		9164440661		9164440661																						9164440661		9164440661																						9164440661		9164440661																						9164440661		9164440661																						9164440661		9164440661																						9164440661		9164440661																						9164440661		9164440661																						9164440661		9164440661																						9164440661		9164440661																						9164440661		9164440661																						9164440661		9164440661																						9164440661		9164440661																						9164440661		9164440661
email		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None

Table: filers

filer_id		1142856

Table: lobbying_chg_log

filer_id		1142856		1142856		1142856		1142856		1142856		1142856
change_no		1		7		6		0		8		9
session_id		1999		2001		2001		2005		2009		2009
log_dt		2000-10-23 00:00:00		2002-07-23 00:00:00		2002-01-31 00:00:00		2005-05-19 00:00:00		2009-11-24 00:00:00		2011-01-06 00:00:00
filer_type		1		2		2		1		1		1
correction_flg		None		Y		Y		None		Y		Y
action		SET ACTIVE		DELETED		DELETED		ADDED		DELETED		ADDED
attribute_changed		CLIENT		FIRM		FIRM		FIRM		FIRM		FIRM
ethics_dt		None		None		None		None		None		None
interests		None		None		None		None		None		None
filer_full_name		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION		CALIFORNIA APPLICANTS' ATTORNEYS ASSOCIATION
filer_city		WOODLAND HILLS		None		None		None		None		SACRAMENTO
filer_st		CA		None		None		None		None		CA
filer_zip		91367		None		None		None		None		95814
filer_phone		8187043594		None		None		None		None		9164445155
entity_type		3		3		3		3		3		3
entity_name		HYDE, MILLER, OWEN & TROST		JOHNSTON, PATRICK		HYDE, MILLER, OWEN & TROST		ROSS COMMUNICATIONS		ROSS; RICHARD		SENATORS (RET.) FIRM, LLP; THE
entity_city		None		None		None		None		None		None
entity_st		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None
entity_id		1147696		1232795		1147696		1147680		1147680		None
responsible_officer		None		None		None		None		None		None
effect_dt		None		2002-06-30 00:00:00		2001-10-31 00:00:00		2005-04-01 00:00:00		2009-12-31 00:00:00		2010-11-01 00:00:00

Table: lobbyist_contributions1

filer_id		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856
filing_period_start_dt		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00
filing_period_end_dt		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00
contribution_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
recipient_name		ASSEMBLY DEMOCRATIC LEADERSHIP 2000		BOWEN FOR STATE SENATE		WASHINGTON COMMITTEE TO ELECT CARL		HAYASHINO FOR ASSEMBLY CAROLE		GALLEGOS STATE ASSEMBLY COMMITTEE TO ELECT DR. MARTIN		BUSTAMANTE COMMITTEE LIEUTENANT GOVERNOR		CHAVEZ FOR ASSEMBLY EDWARD		FLOYD CAMPAIGN COMMITTEE		ALQUIST FRIENDS OF ELAINE		OROPEZA 2000 FRIENDS OF JENNY		HERTZBERG FRIENDS OF BOB		BURTON FOR STATE SENATE 2000		LONGVILLE FOR ASSEMBLY		SOTO FOR SENATE		ORTIZ FOR SENATE		WRIGHT FOR ASSEMBLY ROD		SACRAMENTO WOMENS CAMPAIGN FUND		HAVICE 2000 COMMITTEE		SCHIFF FOR STATE SENATE		SENATE DEMOCRATIC LEADERSHIP FUND		JOHNSTON MAJORITY FUND SENATOR PATRICK		CARDENAS 2000 TONY		CHESBRO FOR SENATE
recipient_id		1077687		1069440		1064536		1076070		1061344		1072280		1075999		1066487		1053563		1075882		1069827		1069401		1054549		1077483		1077483		1050512		1032025		1069837		1066273		1064947		1053281		1069524		1071796
amount		1000		1000		500		5000		500		5000		1000		20000		500		1000		2000		1000		1000		2500		1000		1000		1000		1000		1000		5000		2500		1000		1000

Table: lobbyist_contributions2

filer_id		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856
filing_period_start_dt		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00
filing_period_end_dt		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00
contribution_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
recipient_name		ASSEMBLY DEMOCRATIC LEADERSHIP 2000		BOWEN FOR STATE SENATE		WASHINGTON COMMITTEE TO ELECT CARL		HAYASHINO FOR ASSEMBLY CAROLE		GALLEGOS STATE ASSEMBLY COMMITTEE TO ELECT DR. MARTIN		BUSTAMANTE COMMITTEE LIEUTENANT GOVERNOR		CHAVEZ FOR ASSEMBLY EDWARD		FLOYD CAMPAIGN COMMITTEE		ALQUIST FRIENDS OF ELAINE		OROPEZA 2000 FRIENDS OF JENNY		HERTZBERG FRIENDS OF BOB		BURTON FOR STATE SENATE 2000		LONGVILLE FOR ASSEMBLY		SOTO FOR SENATE		ORTIZ FOR SENATE		WRIGHT FOR ASSEMBLY ROD		SACRAMENTO WOMENS CAMPAIGN FUND		HAVICE 2000 COMMITTEE		SCHIFF FOR STATE SENATE		SENATE DEMOCRATIC LEADERSHIP FUND		JOHNSTON MAJORITY FUND SENATOR PATRICK		CARDENAS 2000 TONY		CHESBRO FOR SENATE
recipient_id		1077687		1069440		1064536		1076070		1061344		1072280		1075999		1066487		1053563		1075882		1069827		1069401		1054549		1077483		1077483		1050512		1032025		1069837		1066273		1064947		1053281		1069524		1071796
amount		1000		1000		500		5000		500		5000		1000		20000		500		1000		2000		1000		1000		2500		1000		1000		1000		1000		1000		5000		2500		1000		1000

Table: received_filings

filer_id		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856		1142856
filing_file_name		656443_0.cal		650666_0.cal		681336_0.cal		704566_0.cal		646.cal		717942_0.cal		745652_0.cal		773823_0.cal		792788_0.cal		814715_0.cal		161893.cal		745652_1.cal		773823_1.cal		161953.cal		792788_1.cal		410110.cal		408744.cal		408771.cal		837976_0.cal		855168_0.cal		881399_0.cal		897110_0.cal		910624_0.cal		929670_0.cal		943593_0.cal		968294_0.cal		990287_0.cal		72373.cal		72954.cal		1012100_0.cal		1024951_0.cal		1058823_0.cal		1078941_0.cal		1103877_0.cal		1107498_0.cal		1114699_0.cal		1131964_0.cal		1143429_0.cal
received_date		2000-08-30 00:00:00		2000-08-09 00:00:00		2000-10-30 00:00:00		2001-01-02 00:00:00		2001-01-02 00:00:00		2001-01-30 00:00:00		2001-04-30 00:00:00		2001-08-02 00:00:00		2001-10-31 00:00:00		2002-01-31 00:00:00		2002-02-11 00:00:00		2002-02-11 00:00:00		2002-02-11 00:00:00		2002-02-11 00:00:00		2002-02-11 00:00:00		2002-02-05 00:00:00		2002-02-05 00:00:00		2002-02-05 00:00:00		2002-04-26 00:00:00		2002-07-30 00:00:00		2002-10-28 00:00:00		2002-12-20 00:00:00		2003-01-30 00:00:00		2003-04-28 00:00:00		2003-07-22 00:00:00		2003-10-28 00:00:00		2004-02-02 00:00:00		2004-04-28 00:00:00		2004-04-28 00:00:00		2004-04-28 00:00:00		2004-07-22 00:00:00		2004-11-01 00:00:00		2005-01-28 00:00:00		2005-04-28 00:00:00		2005-05-13 00:00:00		2005-07-26 00:00:00		2005-10-27 00:00:00		2006-01-24 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/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		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/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/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
filing_id		656443		650666		681336		704566		None		717942		745652		773823		792788		814715		None		745652		773823		None		792788		None		None		None		837976		855168		881399		897110		910624		929670		943593		968294		990287		None		None		1012100		1024951		1058823		1078941		1103877		1107498		1114699		1131964		1143429
form_id		F635		F635		F635		F602		None		F635		F635		F635		F635		F635		None		F635		F635		None		F635		None		None		None		F635		F635		F635		F602		F635		F635		F635		F635		F635		None		None		F635		F635		F635		F635		F635		F602		F635		F635		F635
receive_comment		Filing accepted		Filing accepted, but but with warnings		Filing accepted		Filing accepted		Filing pass validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		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