Home

Filer ID: 1069796

Table: filer_address

filer_id		1069796		1069796		1069796		1069796		1069796
adrid		1080704		1080705		2084537		2289179		2524500
effect_dt		1996-12-30 00:00:00		1996-12-30 00:00:00		2005-01-21 00:00:00		2013-03-19 00:00:00		2021-09-30 00:00:00
add_type		7051		7051		7051		7051		7051
session_id		1995		1995		2005		2013		2021

Table: filer_filings

filer_id		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796		1069796
filing_id		680462		399439		399440		399441		399442		399443		399444		399445		399446		399447		443986		443987		443988		588262		577623		593251		672572		593251		648282		673856		671903		671903		724909		783677		828491		859093		916025		942833		1025356		1021323		1076975		1083731		1115377		1115768		1143091		1186119		1232032		1286708		1776022		1775177		1973647		1974793		1864520		1867262		1811139		1943462		1314031		1344417		1384250		1399953		1440406		1439883		1467117		1501906		1562337		1604826		1610746		1631858		1630992		1674555		1820325		1672705		1927891		1732382		1729308		1723267		1723267		1752920		1758276		2004070		2492346		2483764		2433636		2265811		2549944		2398933		2006395		2065269		2054881		2120692		2142641		2175730		2168949		2345579		2451074		2403704		2204773		2566478		2264808		2358132		2209958		2597484		2630203		2593535		2630191		1723267		2629693		2629696		2614183		1723267
period_id		None		156		145		149		151		153		154		155		157		159		148		153		156		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		213		221		None		217		None		215		None		None		None		None		None		None		None		None		None		None		205		None		None		207		None		None		209		219		211		None		213		213		None		None		223		None		241		239		None		243		237		None		None		225		227		None		None		229		235		None		None		231		None		233		None		None		245		None		None		None		247		248		247		None		248
form_id		F460		F420		F420		F420		F420		F420		F420		F420		F420		F420		F410		F420		F420		F420		F999		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F410		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F410		F497		F460		F410		F410
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		0		0		0		3
filing_date		2000-10-27 00:00:00		1998-10-23 00:00:00		1997-01-30 00:00:00		1997-07-30 00:00:00		1998-01-28 00:00:00		1998-05-21 00:00:00		1998-07-30 00:00:00		1998-10-05 00:00:00		1999-08-02 00:00:00		1999-10-12 00:00:00		1996-12-30 00:00:00		1998-03-23 00:00:00		1999-01-30 00:00:00		2000-01-11 00:00:00		2000-01-12 00:00:00		2000-02-24 00:00:00		2000-10-06 00:00:00		2000-08-01 00:00:00		2000-07-29 00:00:00		2000-10-11 00:00:00		2000-10-02 00:00:00		2000-08-01 00:00:00		2001-01-31 00:00:00		2001-07-31 00:00:00		2002-02-21 00:00:00		2002-07-31 00:00:00		2003-01-30 00:00:00		2003-07-18 00:00:00		2004-07-21 00:00:00		2004-01-15 00:00:00		2005-01-21 00:00:00		2005-01-21 00:00:00		2005-07-13 00:00:00		2005-07-13 00:00:00		2006-01-20 00:00:00		2006-07-20 00:00:00		2007-01-25 00:00:00		2007-07-31 00:00:00		2013-07-16 00:00:00		2013-07-12 00:00:00		2015-07-09 00:00:00		2015-07-13 00:00:00		2014-07-21 00:00:00		2014-07-24 00:00:00		2014-01-17 00:00:00		2015-01-23 00:00:00		2008-01-31 00:00:00		2008-07-18 00:00:00		2008-12-11 00:00:00		2009-02-02 00:00:00		2009-07-31 00:00:00		2009-07-29 00:00:00		2010-01-29 00:00:00		2010-07-20 00:00:00		2011-01-19 00:00:00		2011-07-27 00:00:00		2011-07-29 00:00:00		2012-01-25 00:00:00		2012-01-24 00:00:00		2012-07-23 00:00:00		2014-01-24 00:00:00		2012-07-19 00:00:00		2015-01-21 00:00:00		2013-01-25 00:00:00		2013-01-18 00:00:00		2013-01-08 00:00:00		2013-03-15 00:00:00		2013-01-04 00:00:00		2013-03-19 00:00:00		2016-01-15 00:00:00		2020-07-30 00:00:00		2020-07-30 00:00:00		2020-01-22 00:00:00		2018-07-17 00:00:00		2021-01-28 00:00:00		2019-07-31 00:00:00		2016-01-19 00:00:00		2016-07-18 00:00:00		2016-07-13 00:00:00		2017-01-18 00:00:00		2017-01-20 00:00:00		2017-07-24 00:00:00		2017-07-20 00:00:00		2019-01-30 00:00:00		2020-01-24 00:00:00		2019-07-31 00:00:00		2018-01-24 00:00:00		2021-01-29 00:00:00		2018-07-14 00:00:00		2019-01-31 00:00:00		2018-01-17 00:00:00		2021-07-27 00:00:00		2021-12-03 00:00:00		2021-07-14 00:00:00		2021-12-03 00:00:00		2021-09-26 00:00:00		2021-11-30 00:00:00		2021-11-30 00:00:00		2021-09-30 00:00:00		2021-11-30 00:00:00
stmnt_type		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10006		10005		10005		10005		10006		10005		10005		10005		10005		10005		10005		10005		10005		10005		10002		10005		10005		10005		10005		10005		10005		10005		10001		10001		10005		10001		10005		10001		10005		10005		10005		10006		10005		10005		10005		10005		10005		10005		10001		10005		10005		10001		10005		10005		10001		10001		10001		10005		10001		10002		10006		10002		10001		10005		10001		10001		10005		10001		10001		10005		10005		10001		10001		10005		10005		10001		10001		10005		10005		10001		10005		10001		10005		10005		10001		10003		10005		10005		10002		10001		10001		10006		10002
stmnt_status		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11003		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		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		11003		11001		11003		11001		11003		11003		11001		11001		11001
session_id		1999		1997		1995		1997		1997		1997		1997		1997		1999		1999		1995		1997		1997		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2007		2013		2013		2015		2015		2013		2013		2013		2013		2007		2007		2007		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2013		2011		2013		2011		2011		2013		2013		2013		2013		2015		2019		2019		2019		2017		2019		2019		2015		2015		2015		2015		2015		2017		2017		2017		2019		2019		2017		2021		2017		2017		2017		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		KCHAN		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		KCHAN		JLEHMAN		TTHAM		KCHAN		KCHAN		GGILMORE		TWALLS		GPEREZ		GPEREZ		DBARRICK		DBARRICK		KLARRY		EMCENTEE		KVANG		GKURIMOT		TTHAM		KVANG		KVANG		GKURIMOT		GGILMORE		GKURIMOT		CFLAGG		MPACHECO		CAFILER		MDIGRAZIA		MDIGRAZIA		CAFILER		MPACHECO		CAFILER		DODONOGHUE		GKURIMOT		GKURIMOT		RGEREMIA		MMORENO		GKURIMOT		MMORENO		MMORENO		GKURIMOT		CPON		CAFILER		CPON		CPON		CPON		CPON		MPACHECO		CPON		MDIGRAZIA		CAFILER		MPACHECO		TRAMON		TRAMON		TRAMON		TRAMON		MDIGRAZIA		IMEDINA		IMEDINA		VUKSTINA		CPON		CREYNOLDS		YMORA		MDIGRAZIA		SMCCONNAN		SMCCONNAN		SARRIAGA		SARRIAGA		BSINGH		BSINGH		JFONSECA		VUKSTINA		YMORA		KKRASNAYA		CREYNOLDS		CPON		JFONSECA		KKRASNAYA		CAFILER		JMENDOZA		BCOLON		KRUSSELL		CAFILER		CAFILER		KRUSSELL		IMEDINA		JMENDOZA
special_audit		11003		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		2000-10-01 00:00:00		1998-10-01 00:00:00		1996-01-01 00:00:00		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-03-18 00:00:00		1998-05-17 00:00:00		1998-07-01 00:00:00		1999-01-01 00:00:00		1999-07-01 00:00:00		None		1998-01-01 00:00:00		1998-10-18 00:00:00		1999-10-01 00:00:00		None		2000-01-23 00:00:00		2000-07-01 00:00:00		2000-01-23 00:00:00		2000-02-20 00:00:00		2000-07-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-10-22 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		2004-01-01 00:00:00		2003-07-01 00:00:00		2004-07-01 00:00:00		None		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2013-07-01 00:00:00		2014-07-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		None		2008-07-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2010-01-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		2012-01-01 00:00:00		2014-07-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2013-01-02 00:00:00		2013-03-15 00:00:00		None		None		2015-07-01 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2018-01-01 00:00:00		2020-07-01 00:00:00		2019-01-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		2019-07-01 00:00:00		2019-01-01 00:00:00		2017-07-01 00:00:00		2020-07-01 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2017-07-01 00:00:00		2021-01-01 00:00:00		None		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-09-26 00:00:00		2021-11-30 00:00:00		2021-07-01 00:00:00		None		2021-11-30 00:00:00
rpt_end		2000-10-21 00:00:00		1998-10-17 00:00:00		1996-12-31 00:00:00		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-05-16 00:00:00		1998-06-30 00:00:00		1998-09-30 00:00:00		1999-06-30 00:00:00		1999-09-30 00:00:00		None		1998-03-17 00:00:00		1998-12-31 00:00:00		1999-12-31 00:00:00		None		2000-02-19 00:00:00		2000-09-30 00:00:00		2000-02-19 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-01-22 00:00:00		2000-01-22 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		2004-06-30 00:00:00		2003-12-31 00:00:00		2004-12-31 00:00:00		None		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		None		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-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		2012-06-30 00:00:00		2014-12-31 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2013-01-02 00:00:00		2013-03-15 00:00:00		None		None		2015-12-31 00:00:00		2020-06-30 00:00:00		2020-06-30 00:00:00		2019-12-31 00:00:00		2018-06-30 00:00:00		2020-12-31 00:00:00		2019-06-30 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		2019-12-31 00:00:00		2019-06-30 00:00:00		2017-12-31 00:00:00		2020-12-31 00:00:00		2018-06-30 00:00:00		2018-12-31 00:00:00		2017-12-31 00:00:00		2021-06-30 00:00:00		None		2021-06-30 00:00:00		2021-11-30 00:00:00		2021-09-26 00:00:00		2021-11-30 00:00:00		2021-11-30 00:00:00		None		2021-11-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		2013-07-31 00:00:00		2015-07-31 00:00:00		None		2014-07-31 00:00:00		None		2014-01-31 00:00:00		None		None		None		None		None		None		None		None		None		None		2011-07-31 00:00:00		None		None		2012-01-31 00:00:00		None		None		2012-07-31 00:00:00		2015-01-31 00:00:00		2013-01-31 00:00:00		None		None		None		None		None		2016-02-01 00:00:00		None		2020-07-31 00:00:00		2020-01-31 00:00:00		None		2021-01-14 00:00:00		2019-07-31 00:00:00		None		None		2016-07-31 00:00:00		2017-01-31 00:00:00		None		None		2017-07-08 00:00:00		2019-01-31 00:00:00		None		None		2018-01-06 00:00:00		None		2018-07-31 00:00:00		None		None		2021-08-02 00:00:00		None		None		None		None		2021-11-30 00:00:00		2021-11-30 00:00:00		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		22001		22001		None		22001		None		22001		None		None		None		None		None		None		None		None		None		None		22001		None		None		22001		None		None		22001		22001		22001		None		22001		22001		None		None		22001		None		22001		22001		None		22001		22001		None		None		22001		22001		None		None		22001		22001		None		None		22001		None		22001		None		None		22001		None		None		None		22001		22001		22001		None		22001

Table: filer_to_filer_type

filer_id		1069796		1069796
filer_type		16		16
active		Y		T
race		0		0
session_id		1995		2021
category		0		0
category_type		40502		40502
sub_category		40103		40103
effect_dt		1996-12-30 00:00:00		2021-11-30 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		None		None
nyq_dt		1996-12-20 00:00:00		1996-12-20 00:00:00
party_cd		None		None
county_cd		18004		18004
district_cd		None		None

Table: filer_xref

filer_id		1069796
xref_id		963045
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		963045		963045		963045		963045		963045
filer_id		1069796		1069796		1069796		1069796		1069796
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED
effect_dt		2021-11-30 00:00:00		2021-11-30 00:00:00		2021-11-30 00:00:00		2021-11-30 00:00:00		2021-11-30 00:00:00
naml		COMMON SENSE COALITION OF AMERICA STATE POLITICAL ACTION COMMITTEE		COMMON SENSE COALITION OF AMERICA STATE POLITICAL ACTION COMMITTEE		COMMON SENSE COALITION OF AMERICA STATE POLITICAL ACTION COMMITTEE		COMMON SENSE COALITION OF AMERICA STATE POLITICAL ACTION COMMITTEE		COMMON SENSE COALITION OF AMERICA STATE POLITICAL ACTION COMMITTEE
namf		None		None		None		None		None
namt		None		None		None		None		None
nams		None		None		None		None		None
adr1		None		None		None		None		None
adr2		None		None		None		None		None
city		SACRAMENTO		FAIR OAKS		SACRAMENTO		SACRAMENTO		GRANITE BAY
st		CA		CA		CA		CA		CA
zip4		958140000		956280000		95833		95833		95746
phon		9164469049		9999999999		9164734298		9164734298		9164734298
fax		None		None		None		None		None
email		None		None		None		[email protected]		[email protected]

Table: filers

filer_id		1069796