Home

Filer ID: 1040821

Table: filer_address

filer_id		1040821		1040821		1040821		1040821
adrid		1039462		1039463		2046925		2298484
effect_dt		1990-12-01 00:00:00		2002-01-18 00:00:00		2003-01-27 00:00:00		2013-08-02 00:00:00
add_type		7051		7051		7051		7051
session_id		1985		1985		2003		2013

Table: filer_filings

filer_id		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821		1040821
filing_id		269881		269882		269883		269884		269885		269886		269887		269888		269889		269890		269891		269892		269893		269894		269895		269896		269897		269898		269899		269900		269901		269902		269903		269904		269905		269906		269907		269908		269909		269910		269911		269912		269913		269914		269915		269916		269917		269918		269919		269920		269921		269922		269923		269924		269926		269927		269928		269929		269930		269931		269932		269933		269934		269935		269936		425477		425478		425479		425480		425481		425482		425483		425484		425485		269925		578000		613456		649083		723715		731830		783816		808578		808098		852635		917688		914594		944119		926836		991479		1023398		990551		1080231		1116856		1088808		1145123		1150019		1195858		1150019		1269324		1287353		1788485		1788017		1960951		1967368		1966713		1861519		1861858		1788477		1314425		1150019		1389677		1354055		1392018		1441110		1468785		1467104		1508796		1574162		1581706		1601735		1636125		1635553		1677557		1861734		2185693
period_id		105		105		106		107		106		107		107		108		109		111		111		113		113		113		114		115		116		116		116		115		117		120		119		121		121		122		123		124		124		125		125		126		126		128		129		129		131		132		133		135		137		137		139		141		143		145		145		147		149		149		153		151		153		157		155		105		105		108		111		124		126		127		132		157		141		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
form_id		F420		F420		F405		F405		F420		F420		F405		F420		F420		F420		F420		F420		F420		F405		F420		F420		F405		F420		F420		F405		F420		F405		F420		F420		F420		F420		F420		F420		F420		F420		F405		F420		F405		F405		F420		F420		F450		F450		F420		F420		F405		F420		F420		F405		F420		F405		F420		F420		F405		F420		F405		F420		F420		F405		F420		F410		F405		F420		F405		F405		F420		F420		F405		F425		F420		F425		F410		F425		F425		F410		F425		F410		F425		F425		F425		F410		F425		F425		F410		F425		F425		F425		F425		F410		F425		F410		F425		F410		F425		F425		F425		F410		F410		F410		F460		F425		F410		F425		F425		F410		F425		F425		F410		F425		F410		F425		F425		F425		F410		F425		F410		F425		F425		F425		F425
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1986-03-24 00:00:00		1986-05-22 00:00:00		1986-05-27 00:00:00		1986-07-07 00:00:00		1986-07-31 00:00:00		1986-10-06 00:00:00		1986-12-05 00:00:00		1987-02-02 00:00:00		1987-07-30 00:00:00		1988-01-29 00:00:00		1988-02-01 00:00:00		1988-03-22 00:00:00		1988-05-26 00:00:00		1988-07-13 00:00:00		1988-07-29 00:00:00		1988-10-05 00:00:00		1988-12-08 00:00:00		1989-01-31 00:00:00		1989-02-08 00:00:00		1989-03-15 00:00:00		1989-07-31 00:00:00		1989-12-04 00:00:00		1990-01-30 00:00:00		1990-03-22 00:00:00		1990-05-23 00:00:00		1990-07-31 00:00:00		1990-10-04 00:00:00		1990-10-26 00:00:00		1991-03-04 00:00:00		1991-04-26 00:00:00		1991-05-28 00:00:00		1991-07-31 00:00:00		1991-08-14 00:00:00		1991-11-22 00:00:00		1992-03-18 00:00:00		1992-07-27 00:00:00		1992-10-05 00:00:00		1993-01-29 00:00:00		1993-07-30 00:00:00		1994-02-01 00:00:00		1994-02-02 00:00:00		1994-07-27 00:00:00		1995-01-24 00:00:00		1995-01-24 00:00:00		1996-01-30 00:00:00		1996-01-30 00:00:00		1996-07-30 00:00:00		1997-01-24 00:00:00		1997-01-24 00:00:00		1997-07-23 00:00:00		1998-01-20 00:00:00		1998-01-20 00:00:00		1998-07-20 00:00:00		1999-01-29 00:00:00		1999-01-29 00:00:00		1986-01-29 00:00:00		1986-06-25 00:00:00		1986-10-23 00:00:00		1987-08-03 00:00:00		1990-11-15 00:00:00		1991-05-28 00:00:00		1992-01-30 00:00:00		1992-11-23 00:00:00		1999-08-02 00:00:00		1995-07-28 00:00:00		2000-01-26 00:00:00		2000-01-26 00:00:00		2000-08-01 00:00:00		2001-01-31 00:00:00		2001-01-31 00:00:00		2001-07-31 00:00:00		2002-01-18 00:00:00		2002-01-18 00:00:00		2002-07-24 00:00:00		2003-01-27 00:00:00		2003-01-27 00:00:00		2003-07-23 00:00:00		2003-01-31 00:00:00		2004-01-29 00:00:00		2004-07-14 00:00:00		2004-01-29 00:00:00		2005-01-28 00:00:00		2005-07-28 00:00:00		2005-01-28 00:00:00		2006-01-26 00:00:00		2006-01-26 00:00:00		2006-07-31 00:00:00		2007-05-02 00:00:00		2007-05-02 00:00:00		2007-07-31 00:00:00		2013-08-01 00:00:00		2013-08-02 00:00:00		2015-04-20 00:00:00		2015-04-30 00:00:00		2015-04-30 00:00:00		2014-07-03 00:00:00		2014-07-03 00:00:00		2013-08-01 00:00:00		2008-02-01 00:00:00		2008-02-01 00:00:00		2009-01-14 00:00:00		2008-08-04 00:00:00		2009-01-14 00:00:00		2009-07-30 00:00:00		2010-02-01 00:00:00		2010-02-01 00:00:00		2010-07-30 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2011-07-20 00:00:00		2012-01-25 00:00:00		2012-01-25 00:00:00		2012-07-20 00:00:00		2014-07-01 00:00:00		2015-04-20 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		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		10002		10005		10005		10002		10005		10002		10005		10005		10005		10002		10005		10005		10002		10005		10005		10005		10005		10002		10005		10006		10005		10006		10005		10005		10005		10002		10006		10003		10003		10005		10006		10005		10005		10006		10005		10005		10006		10005		10006		10005		10005		10005		10006		10005		10006		10005		10005		10005		10005
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		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		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003
session_id		1985		1985		1985		1985		1985		1985		1985		1985		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1989		1989		1989		1989		1989		1989		1989		1989		1989		1991		1991		1991		1991		1991		1991		1991		1991		1991		1993		1993		1993		1993		1993		1995		1995		1995		1995		1995		1997		1997		1997		1997		1997		1999		1997		1985		1985		1985		1987		1989		1991		1991		1991		1999		1995		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2003		2003		2001		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2007		2007		2011		2013		2015		2015		2015		2013		2013		2013		2007		2005		2007		2007		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2013		2013
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		JLEHMAN		TWALLS		TTHAM		GPEREZ		TTHAM		CFLAGG		DBARRICK		DBARRICK		TTHAM		KLARRY		DBARRICK		TTHAM		EMCENTEE		KLARRY		KVOONG1		GPEREZ		TTHAM		KVANG		TTHAM		GGILMORE		EMCENTEE		CFLAGG		SARRIAGA		CPON		TRAMON		TRAMON		TRAMON		MPACHECO		MDIGRAZIA		TRAMON		CPON		SMCCABE		EMCENTEE		ASAETERN		HTSUBOI		RGEREMIA		GKURIMOT		RGEREMIA		CPON		SARRIAGA		GKURIMOT		RGEREMIA		MMORENO		TRAMON		SMCCONNAN		MPACHECO		RGEREMIA		SBROWN
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11003		11001		11003		11001		11003		11001		11003		11001		11003		11001		11003		11001		11003
rpt_start		1986-01-01 00:00:00		1986-03-18 00:00:00		None		None		1986-05-18 00:00:00		1986-07-01 00:00:00		1986-07-01 00:00:00		1986-10-19 00:00:00		1987-01-01 00:00:00		1987-07-01 00:00:00		1987-07-01 00:00:00		1988-01-01 00:00:00		1988-03-18 00:00:00		1988-03-18 00:00:00		1988-05-22 00:00:00		1988-07-01 00:00:00		None		1988-10-01 00:00:00		1988-10-01 00:00:00		1988-07-01 00:00:00		1989-01-01 00:00:00		None		1989-07-01 00:00:00		1990-01-01 00:00:00		1990-03-18 00:00:00		1990-05-20 00:00:00		1990-07-01 00:00:00		1990-10-01 00:00:00		1990-10-21 00:00:00		1991-01-01 00:00:00		1991-01-01 00:00:00		1991-05-19 00:00:00		1991-05-19 00:00:00		None		1992-01-01 00:00:00		1992-03-18 00:00:00		1992-07-01 00:00:00		1992-10-01 00:00:00		1993-01-01 00:00:00		1993-07-01 00:00:00		None		1994-01-01 00:00:00		1994-07-01 00:00:00		None		1995-07-01 00:00:00		None		1996-01-01 00:00:00		1996-07-01 00:00:00		None		1997-01-01 00:00:00		None		1997-07-01 00:00:00		1998-01-01 00:00:00		None		1998-07-01 00:00:00		None		1986-03-18 00:00:00		1986-10-01 00:00:00		None		None		1991-04-21 00:00:00		1991-07-01 00:00:00		None		1999-01-01 00:00:00		1995-01-01 00:00:00		1999-07-01 00:00:00		None		2000-01-01 00:00:00		2000-07-01 00:00:00		1997-01-01 00:00:00		2001-01-01 00:00:00		2001-11-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		None		2003-01-01 00:00:00		2002-07-01 00:00:00		None		2004-01-01 00:00:00		2003-07-01 00:00:00		2004-07-01 00:00:00		2005-01-01 00:00:00		None		2005-07-01 00:00:00		None		2006-01-01 00:00:00		None		2006-07-01 00:00:00		2007-01-01 00:00:00		2012-07-01 00:00:00		None		None		None		2014-06-30 00:00:00		2014-01-01 00:00:00		None		2013-01-01 00:00:00		2007-07-01 00:00:00		None		2008-07-01 00:00:00		2008-01-01 00:00:00		None		2009-01-01 00:00:00		None		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		None		2011-01-01 00:00:00		None		2011-07-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2014-07-01 00:00:00
rpt_end		1986-03-17 00:00:00		1986-05-17 00:00:00		None		None		1986-06-30 00:00:00		1986-09-30 00:00:00		1986-09-30 00:00:00		1986-12-31 00:00:00		1987-06-30 00:00:00		1987-12-31 00:00:00		1987-12-31 00:00:00		1988-03-17 00:00:00		1988-05-21 00:00:00		1988-05-21 00:00:00		1988-06-30 00:00:00		1988-09-30 00:00:00		None		1988-12-31 00:00:00		1988-12-31 00:00:00		1988-09-30 00:00:00		1989-06-30 00:00:00		None		1989-12-31 00:00:00		1990-03-17 00:00:00		1990-05-19 00:00:00		1990-06-30 00:00:00		1990-09-30 00:00:00		1990-10-20 00:00:00		1990-12-31 00:00:00		1991-04-20 00:00:00		1991-04-20 00:00:00		1991-06-30 00:00:00		1991-06-30 00:00:00		None		1992-03-17 00:00:00		1992-06-30 00:00:00		1992-09-30 00:00:00		1992-12-31 00:00:00		1993-06-30 00:00:00		1993-12-31 00:00:00		None		1994-06-30 00:00:00		1994-12-31 00:00:00		None		1995-12-31 00:00:00		None		1996-06-30 00:00:00		1996-12-31 00:00:00		None		1997-06-30 00:00:00		None		1997-12-31 00:00:00		1998-06-30 00:00:00		None		1998-12-31 00:00:00		None		1986-05-17 00:00:00		1986-10-18 00:00:00		None		None		1991-05-18 00:00:00		1991-12-31 00:00:00		None		1999-06-30 00:00:00		1995-06-30 00:00:00		1999-12-31 00:00:00		None		2000-06-30 00:00:00		2000-12-31 00:00:00		1997-01-01 00:00:00		2001-06-30 00:00:00		2001-11-01 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-12-31 00:00:00		None		2003-06-30 00:00:00		2002-12-31 00:00:00		None		2004-06-30 00:00:00		2003-12-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		None		2005-12-31 00:00:00		None		2006-06-30 00:00:00		None		2006-12-31 00:00:00		2007-06-30 00:00:00		2012-12-31 00:00:00		None		None		None		2015-04-27 00:00:00		2014-06-30 00:00:00		None		2013-06-30 00:00:00		2007-12-31 00:00:00		None		2008-12-31 00:00:00		2008-06-30 00:00:00		None		2009-06-30 00:00:00		None		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-12-31 00:00:00		None		2011-06-30 00:00:00		None		2011-12-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2014-12-31 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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_to_filer_type

filer_id		1040821		1040821
filer_type		16		16
active		Y		T
race		0		0
session_id		1985		2013
category		0		0
category_type		40502		40502
sub_category		40103		40103
effect_dt		1990-12-01 00:00:00		2014-06-30 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		None		None
nyq_dt		1986-02-26 00:00:00		1986-02-26 00:00:00
party_cd		None		None
county_cd		18026		18026
district_cd		None		None

Table: filer_xref

filer_id		1040821
xref_id		860149
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		860149		860149		860149		860149
filer_id		1040821		1040821		1040821		1040821
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		TERMINATED		TERMINATED		TERMINATED		TERMINATED
effect_dt		2014-06-30 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00
naml		CALIFORNIA EMPLOYMENT LAW COUNCIL		CALIFORNIA EMPLOYMENT LAW COUNCIL		CALIFORNIA EMPLOYMENT LAW COUNCIL		CALIFORNIA EMPLOYMENT LAW COUNCIL
namf		None		None		None		None
namt		None		None		None		None
nams		None		None		None		None
adr1		None		None		None		None
adr2		None		None		None		None
city		SAN FRANCISCO		LOS ANGELES		LOS ANGELES		LOS ANGELES
st		CA		CA		CA		CA
zip4		941060000		900710000		900710000		900710000
phon		4159542586		2136836000		2136836000		2136835586
fax		None		None		None		None
email		None		None		None		[email protected]

Table: filers

filer_id		1040821