Home

Filer ID: 1047154

Table: filer_address

filer_id		1047154		1047154		1047154
adrid		1046335		1046336		2475904
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00		2019-01-17 00:00:00
add_type		7051		7051		7051
session_id		1987		1987		2019

Table: filer_filings

filer_id		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154		1047154
filing_id		299206		299207		299208		299209		299211		299212		299213		299214		299215		299216		299217		299218		299219		299220		299221		299222		299223		299224		299225		299226		299227		299228		299229		299230		299231		299232		299233		429669		429670		429671		588152		299210		650869		727626		783781		828494		863659		915580		951674		1005020		1034061		1087397		1122587		1152751		1165911		1192630		1198725		1197927		1242985		1239148		1283488		1303893		1304966		1783109		1787583		1947121		1866242		1287704		1350283		1345994		1394452		1399235		1431218		1430217		1459694		1457554		1505909		1509640		1509640		1505909		1574035		1561991		1607596		1612121		1638151		1632773		1675065		1825935		1815323		1681209		1934680		1711745		1876699		1735290		1982414		1985602		2356595		2356614		2337408		2204069		2334121		2010821		2021685		2059494		2069808		2127166		2147982		2167443		2173050		2334074		2217065		2280527		2269555		2334117
period_id		142		117		116		116		118		117		119		117		119		121		123		125		127		121		129		131		133		135		137		139		141		145		147		149		153		155		157		135		143		151		None		113		None		None		None		None		None		None		None		None		None		None		None		None		183		181		None		185		None		187		189		191		None		213		None		None		217		None		None		193		195		None		None		197		None		199		201		None		None		201		None		203		205		None		None		207		209		None		215		None		219		211		None		212		221		None		None		None		None		231		235		223		None		225		None		227		None		229		None		235		None		None		233		237
form_id		F405		F405		F410		F490		F405		F420		F420		F405		F405		F420		F420		F420		F420		F405		F420		F420		F420		F425		F425		F420		F450		F420		F420		F420		F420		F420		F420		F425		F425		F420		F460		F405		F460		F460		F460		F460		F460		F425		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F425		F425		F460		F460		F460		F460		F460		F460		F460		F460		F425		F425		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F450		F425		F410		F425		F450		F460		F460		F460		F460		F460		F460		F460		F460		F425		F450		F460		F460		F410
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		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		0		0		0		0		0		0		0		0
filing_date		1995-05-15 00:00:00		1989-03-23 00:00:00		1988-10-25 00:00:00		1989-02-06 00:00:00		1989-06-26 00:00:00		1989-07-31 00:00:00		1990-01-30 00:00:00		1990-02-22 00:00:00		1990-05-21 00:00:00		1990-07-31 00:00:00		1991-01-31 00:00:00		1991-07-31 00:00:00		1992-01-31 00:00:00		1992-05-26 00:00:00		1992-07-31 00:00:00		1993-02-01 00:00:00		1993-07-31 00:00:00		1994-01-31 00:00:00		1994-08-01 00:00:00		1995-01-31 00:00:00		1995-07-31 00:00:00		1996-07-29 00:00:00		1997-01-31 00:00:00		1997-07-28 00:00:00		1998-07-31 00:00:00		1999-02-01 00:00:00		1999-08-02 00:00:00		1994-02-01 00:00:00		1996-01-29 00:00:00		1998-02-02 00:00:00		2000-01-18 00:00:00		1989-05-05 00:00:00		2000-08-10 00:00:00		2001-02-01 00:00:00		2001-07-31 00:00:00		2002-02-25 00:00:00		2002-08-06 00:00:00		2003-01-31 00:00:00		2003-07-31 00:00:00		2004-03-01 00:00:00		2004-08-02 00:00:00		2005-02-01 00:00:00		2005-08-02 00:00:00		2006-02-06 00:00:00		2006-04-27 00:00:00		2006-07-31 00:00:00		2006-08-25 00:00:00		2006-08-24 00:00:00		2007-01-31 00:00:00		2007-01-31 00:00:00		2007-07-30 00:00:00		2008-01-16 00:00:00		2008-01-18 00:00:00		2013-07-31 00:00:00		2013-07-31 00:00:00		2015-01-30 00:00:00		2014-07-24 00:00:00		2007-07-30 00:00:00		2008-07-30 00:00:00		2008-07-24 00:00:00		2009-01-29 00:00:00		2009-02-02 00:00:00		2009-07-15 00:00:00		2009-07-13 00:00:00		2010-01-21 00:00:00		2010-01-13 00:00:00		2010-07-30 00:00:00		2010-08-02 00:00:00		2010-11-18 00:00:00		2010-11-15 00:00:00		2011-01-31 00:00:00		2011-01-19 00:00:00		2011-07-31 00:00:00		2011-08-08 00:00:00		2012-01-30 00:00:00		2012-01-27 00:00:00		2012-07-26 00:00:00		2014-01-31 00:00:00		2014-01-29 00:00:00		2012-07-30 00:00:00		2015-01-30 00:00:00		2012-11-02 00:00:00		2014-07-31 00:00:00		2013-01-29 00:00:00		2015-07-31 00:00:00		2015-08-03 00:00:00		2019-01-17 00:00:00		2019-01-17 00:00:00		2019-01-17 00:00:00		2018-01-22 00:00:00		2019-01-14 00:00:00		2016-01-29 00:00:00		2016-02-01 00:00:00		2016-07-27 00:00:00		2016-08-01 00:00:00		2017-01-30 00:00:00		2017-01-31 00:00:00		2017-07-14 00:00:00		2017-07-21 00:00:00		2019-01-14 00:00:00		2018-01-29 00:00:00		2018-07-31 00:00:00		2018-07-25 00:00:00		2019-01-14 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		10005		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10001		10005		10001		10005		10001		10001		10001		10005		10001		10005		10005		10001		10005		10005		10001		10001		10005		10005		10001		10005		10001		10001		10005		10006		10002		10005		10001		10001		10005		10005		10001		10001		10005		10001		10005		10001		10001		10005		10001		10001		10005		10003		10005		10003		10001		10001		10001		10005		10001		10005		10001		10005		10001		10005		10001		10005		10005		10001		10003
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		11003		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001
session_id		1995		1989		1987		1987		1989		1989		1989		1989		1989		1989		1989		1991		1991		1989		1991		1991		1993		1993		1993		1993		1995		1995		1995		1997		1997		1997		1999		1993		1995		1997		1999		1987		1999		1999		2001		2001		2001		2001		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2013		2013		2013		2013		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2013		2013		2011		2013		2011		2013		2011		2015		2015		2017		2017		2019		2017		2017		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2019
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		JLEHMAN		TWALLS		GPEREZ		GPEREZ		DBARRICK		DBARRICK		GGILMORE		DHORRELL		GKURIMOT		KVOONG1		KVANG		EMCENTEE		DHORRELL		DHORRELL		CFLAGG		DHORRELL		SARRIAGA		*		*		*		RGEREMIA		CPON		CPON		GCLARA		CAFILER		GPEREZ		CPON		CPON		*		ASAETERN		CPON		CPON		CPON		CPON		MMORENO		MMORENO		MPACHECO		*		SMCCONNAN		SMCCONNAN		MMORENO		MMORENO		MPACHECO		CAFILER		CPON		MPACHECO		CAFILER		CPON		CAFILER		CAFILER		MPACHECO		CAFILER		CAFILER		RGEREMIA		CSAGABAEN		CSAGABAEN		PADAMS		HSTOVALL		CSAGABAEN		MDIGRAZIA		MDIGRAZIA		CAFILER		MPACHECO		SARRIAGA		SARRIAGA		BSINGH		BSINGH		KBANH		HSTOVALL		JFRONEFIELD		JFRONEFIELD		PADAMS
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		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		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		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003
rpt_start		None		None		None		1988-10-21 00:00:00		None		1989-01-01 00:00:00		1989-07-01 00:00:00		1989-01-01 00:00:00		1989-07-01 00:00:00		1990-01-01 00:00:00		1990-07-01 00:00:00		1991-01-01 00:00:00		1991-07-01 00:00:00		1990-01-01 00:00:00		1992-01-01 00:00:00		1992-07-01 00:00:00		1993-01-01 00:00:00		1993-07-01 00:00:00		1994-01-01 00:00:00		1994-07-01 00:00:00		1995-01-01 00:00:00		1996-01-01 00:00:00		1996-07-01 00:00:00		1997-01-01 00:00:00		1998-01-01 00:00:00		1998-07-01 00:00:00		1999-01-01 00:00:00		1993-07-01 00:00:00		1995-07-01 00:00:00		1997-07-01 00:00:00		1999-07-01 00:00:00		1988-01-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2005-01-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2007-01-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2012-01-01 00:00:00		2014-07-01 00:00:00		2012-07-01 00:00:00		2014-01-01 00:00:00		2012-11-02 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2018-07-02 00:00:00		2018-07-01 00:00:00		None		2017-07-01 00:00:00		2018-07-02 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2018-07-01 00:00:00		2017-07-01 00:00:00		2018-01-01 00:00:00		2018-01-01 00:00:00		2019-01-14 00:00:00
rpt_end		None		None		None		1988-12-31 00:00:00		None		1989-06-30 00:00:00		1989-12-31 00:00:00		1989-06-30 00:00:00		1989-12-31 00:00:00		1990-06-30 00:00:00		1990-12-31 00:00:00		1991-06-30 00:00:00		1991-12-31 00:00:00		1990-06-30 00:00:00		1992-06-30 00:00:00		1992-12-31 00:00:00		1993-06-30 00:00:00		1993-12-31 00:00:00		1994-06-30 00:00:00		1994-12-31 00:00:00		1995-06-30 00:00:00		1996-06-30 00:00:00		1996-12-31 00:00:00		1997-06-30 00:00:00		1998-06-30 00:00:00		1998-12-31 00:00:00		1999-06-30 00:00:00		1993-12-31 00:00:00		1995-12-31 00:00:00		1997-12-31 00:00:00		1999-12-31 00:00:00		1988-12-31 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2005-06-30 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2014-12-31 00:00:00		2014-06-30 00:00:00		2007-06-30 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		0211-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2014-12-31 00:00:00		2012-11-01 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2018-12-31 00:00:00		2018-12-31 00:00:00		None		2017-12-31 00:00:00		2018-12-31 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2018-12-31 00:00:00		2017-12-31 00:00:00		2018-06-30 00:00:00		2018-06-30 00:00:00		2019-01-14 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		2006-04-27 00:00:00		2006-07-31 00:00:00		None		2006-08-24 00:00:00		None		2007-01-31 00:00:00		2007-07-30 00:00:00		2008-01-16 00:00:00		None		2013-07-31 00:00:00		None		None		2014-07-24 00:00:00		None		None		2008-07-24 00:00:00		2009-01-29 00:00:00		None		None		2009-07-13 00:00:00		None		2010-01-13 00:00:00		2010-07-30 00:00:00		None		None		2010-11-15 00:00:00		None		2011-01-19 00:00:00		2011-07-31 00:00:00		None		None		2012-01-27 00:00:00		2012-07-26 00:00:00		None		2014-01-29 00:00:00		None		2015-01-30 00:00:00		2012-11-02 00:00:00		None		2013-01-29 00:00:00		2015-07-31 00:00:00		None		None		None		None		2018-01-22 00:00:00		2019-01-14 00:00:00		2016-01-29 00:00:00		None		2016-07-27 00:00:00		None		2017-01-30 00:00:00		None		2017-07-14 00:00:00		None		2019-01-14 00:00:00		None		None		2018-07-25 00:00:00		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		22006		22006		None		22006		None		22006		22006		22006		None		22006		None		None		22006		None		None		22006		22006		None		None		22006		None		22006		22006		None		None		22006		None		22006		22006		None		None		22006		22006		None		22006		None		22006		22006		None		22006		22006		None		None		None		None		22006		22006		22006		None		22006		None		22006		None		22006		None		22006		None		None		22006		22006

Table: filer_to_filer_type

filer_id		1047154		1047154
filer_type		16		16
active		Y		T
race		0		0
session_id		1987		2019
category		0		0
category_type		40502		40502
sub_category		40103		40103
effect_dt		1990-12-01 00:00:00		2019-01-14 00:00:00
sub_category_type		40202		40202
election_type		0		0
sub_category_a		None		None
nyq_dt		1988-10-25 00:00:00		1988-10-25 00:00:00
party_cd		None		None
county_cd		18019		18019
district_cd		None		None

Table: filer_xref

filer_id		1047154
xref_id		882293
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		882293		882293		882293
filer_id		1047154		1047154		1047154
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		TERMINATED		TERMINATED		TERMINATED
effect_dt		2019-01-14 00:00:00		2019-01-14 00:00:00		2019-01-14 00:00:00
naml		COMMUNITY RESEARCH AND INFORMATION CENTER		COMMUNITY RESEARCH AND INFORMATION CENTER		COMMUNITY RESEARCH AND INFORMATION CENTER
namf		None		None		None
namt		None		None		None
nams		None		None		None
adr1		None		None		None
adr2		None		None		None
city		LOS ANGELES		LOS ANGELES		LOS ANGELES
st		CA		CA		CA
zip4		900480000		900360000		900360000
phon		2139399236		2139399236		3239399236
fax		None		None		None
email		None		None		None

Table: filers

filer_id		1047154

Table: received_filings

filer_id		1047154		1047154		1047154		1047154		1047154		1047154
filing_file_name		23511.cal		404952.cal		405161.cal		409592.cal		396622.cal		396587.cal
received_date		2011-01-26 00:00:00		2011-01-20 00:00:00		2011-01-20 00:00:00		2011-01-20 00:00:00		2011-01-19 00:00:00		2011-01-19 00:00:00
filing_directory		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp
filing_id		None		None		None		None		None		None
form_id		None		None		None		None		None		None
receive_comment		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints