Home

Filer ID: 1048299

Table: filer_address

filer_id		1048299		1048299		1048299		1048299		1048299		1048299
adrid		1047724		2003702		2543281		2543282		2217569		2445847
effect_dt		1999-04-22 00:00:00		2000-07-17 00:00:00		2022-08-22 00:00:00		2022-08-22 00:00:00		2011-07-13 00:00:00		2018-01-17 00:00:00
add_type		7051		7051		7051		7082		7051		7051
session_id		1999		1999		2021		2021		2011		2017

Table: filer_filings

filer_id		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299		1048299
filing_id		311265		311266		311267		311268		311269		311270		311271		311272		311273		311274		311275		311276		311277		311278		311279		311280		311281		311282		311283		311284		311286		311287		311288		311289		311291		311292		311293		311294		311295		311296		311297		311298		311263		311264		431389		431390		431391		431392		431393		431394		311285		311290		636396		639987		634448		652023		662373		667847		724015		775531		806393		836475		855525		915992		941587		991668		1026620		1087628		1116122		1130115		1143506		1192785		1232104		1290248		1304982		1777437		1976573		1864194		1777437		1810786		1942861		1343020		1361793		1389914		1432078		1459678		1501388		1563069		1601717		1602741		1598377		1600278		1631530		1643591		1672639		1731848		2442568		2203405		2265872		2219885		2265872		2394328		2013361		2073300		2147965		2170431		2206796		2356877		2714663		2714089		2714090		2714091		2714092		2714094
period_id		119		123		121		123		101		101		124		125		121		127		129		131		132		132		133		135		135		136		137		137		139		140		140		141		143		147		149		149		151		155		158		157		118		119		121		119		101		127		147		153		138		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		None		None		None		None		None		None		None		None		None		None		None		None
form_id		F420		F420		F405		F420		F420		F405		F420		F420		F405		F420		F420		F420		F420		F420		F420		F420		F420		F420		F420		F420		F420		F420		F420		F420		F405		F405		F405		F420		F420		F420		F405		F420		F410		F405		F420		F405		F405		F420		F420		F420		F420		F420		F888		F460		F460		F410		F460		F410		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F410		F460		F410		F460		F410		F460		F460		F460		F410		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F410		F450		F450		F450		F450		F450
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		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		1		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1990-07-11 00:00:00		1990-10-03 00:00:00		1990-10-05 00:00:00		1990-10-24 00:00:00		1990-10-04 00:00:00		1991-01-04 00:00:00		1991-01-11 00:00:00		1991-07-26 00:00:00		1991-07-23 00:00:00		1992-01-21 00:00:00		1992-07-13 00:00:00		1992-10-05 00:00:00		1992-10-21 00:00:00		1993-01-06 00:00:00		1993-07-02 00:00:00		1993-09-22 00:00:00		1993-10-20 00:00:00		1994-01-14 00:00:00		1994-03-21 00:00:00		1994-05-25 00:00:00		1994-10-04 00:00:00		1994-10-26 00:00:00		1995-01-09 00:00:00		1995-03-23 00:00:00		1996-01-23 00:00:00		1997-01-24 00:00:00		1997-01-24 00:00:00		1997-07-30 00:00:00		1998-01-26 00:00:00		1999-02-04 00:00:00		1999-04-22 00:00:00		1999-07-29 00:00:00		1989-06-26 00:00:00		1989-07-14 00:00:00		1990-07-13 00:00:00		1990-10-05 00:00:00		1991-01-04 00:00:00		1991-09-25 00:00:00		1997-01-24 00:00:00		1998-07-28 00:00:00		1994-07-25 00:00:00		1995-07-26 00:00:00		2000-01-28 00:00:00		2000-07-17 00:00:00		2000-01-27 00:00:00		2000-07-17 00:00:00		2000-09-14 00:00:00		2000-09-18 00:00:00		2001-01-31 00:00:00		2001-07-26 00:00:00		2002-01-08 00:00:00		2002-04-03 00:00:00		2002-07-30 00:00:00		2003-01-30 00:00:00		2003-07-10 00:00:00		2004-02-02 00:00:00		2004-07-26 00:00:00		2005-01-31 00:00:00		2005-07-15 00:00:00		2005-10-11 00:00:00		2006-01-23 00:00:00		2006-07-27 00:00:00		2007-01-24 00:00:00		2007-08-20 00:00:00		2008-01-18 00:00:00		2013-08-27 00:00:00		2015-07-16 00:00:00		2014-07-15 00:00:00		2013-07-22 00:00:00		2014-01-14 00:00:00		2015-01-29 00:00:00		2008-07-11 00:00:00		2008-08-29 00:00:00		2009-01-15 00:00:00		2009-07-20 00:00:00		2010-01-22 00:00:00		2010-07-19 00:00:00		2011-01-21 00:00:00		2011-07-19 00:00:00		2011-07-22 00:00:00		2009-01-15 00:00:00		2011-07-13 00:00:00		2012-01-24 00:00:00		2012-02-14 00:00:00		2012-07-17 00:00:00		2013-01-23 00:00:00		2020-01-17 00:00:00		2018-01-17 00:00:00		2018-07-16 00:00:00		2018-02-26 00:00:00		2019-03-20 00:00:00		2019-07-15 00:00:00		2016-01-27 00:00:00		2016-08-16 00:00:00		2017-01-31 00:00:00		2017-07-19 00:00:00		2018-01-17 00:00:00		2019-01-22 00:00:00		2022-08-22 00:00:00		2022-08-20 00:00:00		2022-08-20 00:00:00		2022-08-20 00:00:00		2022-08-20 00:00:00		2022-08-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		10005		10005		10005		10002		10005		10002		10005		10005		10005		10002		10005		10005		10005		10005		10005		10005		10005		10006		10005		10005		10005		10005		10005		10006		10005		10005		10005		10005		10005		10005		10006		10005		10005		10005		10005		10005		10005		10006		10005		10006		10005		10006		10005		10005		10005		10006		10005		10006		10006		10005		10005		10005		10005		10005		10005		10005		10006		10005		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		11003		11001		11001		11001		11003		11003		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003
session_id		1989		1989		1989		1989		1985		1985		1989		1991		1989		1991		1991		1991		1991		1991		1993		1993		1993		1993		1993		1993		1993		1993		1993		1995		1995		1995		1997		1997		1997		1997		1999		1999		1989		1989		1989		1989		1985		1991		1995		1997		1993		1995		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2003		2003		2003		2003		2005		2005		2005		2005		2005		2007		2007		2013		2015		2013		2013		2013		2013		2007		2007		2009		2009		2009		2009		2009		2011		2011		2007		2011		2011		2011		2011		2011		2019		2017		2017		2017		2017		2019		2015		2015		2015		2017		2017		2017		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		YBONILLA		TTHAM		KCHAN		DHORRELL		KCHAN		TTHAM		TWALLS		GPEREZ		GPEREZ		TTHAM		DBARRICK		DBARRICK		KVOONG1		EMCENTEE		GKURIMOT		KVOONG1		KVANG		TTHAM		GKURIMOT		GKURIMOT		SARRIAGA		GPEREZ		GKURIMOT		MPACHECO		SARRIAGA		MPACHECO		MDIGRAZIA		MPACHECO		GPEREZ		GKURIMOT		RGEREMIA		JVAZQUEZ		SARRIAGA		CPON		CPON		CPON		CPON		TRAMON		AGLADNEY		TRAMON		SMCCONNAN		TRAMON		CPON		MPACHECO		IMEDINA		TRAMON		CPON		TRAMON		KBANH		LPHEAV		SARRIAGA		MDIGRAZIA		CPON		SARRIAGA		LBARTHOL		LPHEAV		IMEDINA		LPHEAV		LPHEAV		LPHEAV		LPHEAV		LPHEAV
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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11001		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001
rpt_start		1989-07-01 00:00:00		1990-07-01 00:00:00		1990-01-01 00:00:00		1990-09-30 00:00:00		1985-01-01 00:00:00		1985-01-01 00:00:00		1990-10-21 00:00:00		1991-01-01 00:00:00		1990-01-01 00:00:00		1991-07-01 00:00:00		1992-01-01 00:00:00		1992-07-01 00:00:00		1992-10-01 00:00:00		1992-10-18 00:00:00		1993-01-01 00:00:00		1993-07-01 00:00:00		1993-09-19 00:00:00		1993-10-17 00:00:00		1994-01-01 00:00:00		1994-03-18 00:00:00		1994-07-01 00:00:00		1994-10-01 00:00:00		1994-10-23 00:00:00		1995-01-01 00:00:00		1995-07-01 00:00:00		1996-07-01 00:00:00		None		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-07-01 00:00:00		None		1999-01-01 00:00:00		None		None		1990-01-01 00:00:00		1989-07-01 00:00:00		1985-01-01 00:00:00		1991-07-01 00:00:00		1996-07-01 00:00:00		1998-01-01 00:00:00		1994-05-22 00:00:00		1995-01-01 00:00:00		None		2000-01-01 00:00:00		1999-07-01 00:00:00		None		2000-01-01 00:00:00		None		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-11-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		None		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		2007-07-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2013-07-01 00:00:00		2014-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-07-01 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		None		2008-07-01 00:00:00		None		2011-07-01 00:00:00		None		2012-01-01 00:00:00		2012-07-01 00:00:00		2019-07-01 00:00:00		None		2018-01-01 00:00:00		None		2018-01-01 00:00:00		2019-01-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2017-07-01 00:00:00		2018-07-01 00:00:00		None		2020-01-01 00:00:00		2020-07-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00
rpt_end		1989-12-31 00:00:00		1990-09-30 00:00:00		1990-06-30 00:00:00		1990-10-20 00:00:00		1989-06-30 00:00:00		1990-06-30 00:00:00		1990-12-31 00:00:00		1991-06-30 00:00:00		1990-06-30 00:00:00		1991-12-31 00:00:00		1992-06-30 00:00:00		1992-09-30 00:00:00		1992-10-17 00:00:00		1992-12-31 00:00:00		1993-06-30 00:00:00		1993-09-18 00:00:00		1993-10-16 00:00:00		1993-12-31 00:00:00		1994-03-17 00:00:00		1994-05-21 00:00:00		1994-09-30 00:00:00		1994-10-22 00:00:00		1994-12-31 00:00:00		1995-03-17 00:00:00		1995-12-31 00:00:00		1996-12-31 00:00:00		None		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-12-31 00:00:00		None		1999-06-30 00:00:00		None		None		1990-06-30 00:00:00		1989-12-31 00:00:00		1989-06-30 00:00:00		1991-09-21 00:00:00		1996-12-31 00:00:00		1998-06-30 00:00:00		1994-06-30 00:00:00		1995-06-30 00:00:00		None		2000-06-30 00:00:00		1999-12-31 00:00:00		None		2000-06-30 00:00:00		None		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-11-01 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		None		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-12-31 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2013-06-30 00:00:00		2013-12-31 00:00:00		2014-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-12-31 00:00:00		2010-06-30 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		None		2008-12-31 00:00:00		None		2011-12-31 00:00:00		None		2012-06-30 00:00:00		2012-12-31 00:00:00		2019-12-31 00:00:00		None		2018-06-30 00:00:00		None		2018-06-30 00:00:00		2019-06-30 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-12-31 00:00:00		2018-12-31 00:00:00		None		2020-06-30 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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

Table: filer_to_filer_type

filer_id		1048299		1048299
filer_type		16		16
active		Y		Y
race		0		0
session_id		1989		2021
category		0		0
category_type		40502		40503
sub_category		40103		40103
effect_dt		1989-06-26 00:00:00		2022-08-22 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		S		S
nyq_dt		1990-09-05 00:00:00		1990-09-05 00:00:00
party_cd		0		0
county_cd		18030		18030
district_cd		0		0

Table: filer_xref

filer_id		1048299
xref_id		890892
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		890892		890892		890892		890892		890892		890892
filer_id		1048299		1048299		1048299		1048299		1048299		1048299
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2022-08-22 00:00:00		2022-08-22 00:00:00		2022-08-22 00:00:00		2022-08-22 00:00:00		2022-08-22 00:00:00		2022-08-22 00:00:00
naml		AFSCME LOCAL 2703 POLITICAL ACTION COMMITTEE		AFSCME LOCAL 2703 POLITICAL ACTION COMMITTEE		AFSCME LOCAL 2703 POLITICAL ACTION COMMITTEE		AFSCME LOCAL 2703 POLITICAL ACTION COMMITTEE		AFSCME LOCAL 2703 POLITICAL ACTION COMMITTEE		AFSCME LOCAL 2703 POLITICAL ACTION COMMITTEE
namf		None		None		None		None		None		None
namt		None		None		None		None		None		None
nams		None		None		None		None		None		None
adr1		None		None		None		None		None		None
adr2		None		None		None		None		None		None
city		MERCED		MERCED		MERCED		MERCED		MERCED		MERCED
st		CA		CA		CA		CA		CA		CA
zip4		953400000		95348		95340		95340		95340		953441848
phon		2097223636		2097223636		2097229640		2097223636		2097223636		2097223636
fax		None		2097229640		2097229640		2097229640		2097229640		2097229640
email		None		None		None		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1048299