Home

Filer ID: 1047876

Table: filer_address

filer_id		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876
adrid		1047198		2153550		2513675		2513674		2464363		2464362		2459904		2311440		2298491		2298490		2324148		2324147
effect_dt		1990-12-01 00:00:00		2008-09-03 00:00:00		2020-10-23 00:00:00		2020-10-23 00:00:00		2018-09-20 00:00:00		2018-09-20 00:00:00		2018-08-06 00:00:00		2014-01-29 00:00:00		2013-08-02 00:00:00		2013-08-02 00:00:00		2014-07-28 00:00:00		2014-07-28 00:00:00
add_type		7051		7082		7082		7051		7082		7051		7051		7051		7082		7051		7082		7051
session_id		1989		2007		2019		2019		2017		2017		2017		2013		2013		2013		2013		2013

Table: filer_filings

filer_id		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876
filing_id		307098		307099		307100		307101		307102		307103		307104		307105		307106		307107		307108		307109		307110		307111		307113		307114		307115		307116		307117		307118		307119		307120		307092		307093		307094		307095		307096		307097		430793		430794		430795		430796		307112		582055		593715		672650		648951		652021		722653		733063		731644		759275		761740		788697		731644		770001		759275		785195		784139		733063		785232		786800		802164		804026		806418		877280		859040		871148		853517		872497		882983		904427		901018		913738		943565		952024		982347		977890		1002840		1004730		1000758		1025524		994831		1034899		1046701		1044174		1059936		1075053		1044174		1046701		1119890		1112562		1088081		1145711		1153064		1177812		1173220		1186759		1173888		1177514		1204089		1207312		1222011		1222012		1196196		1243467		1233285		1285919		1277361		1308646		1267061		1772586		1785791		1787743		1783537		1869462		1860485		1388657		1869704		1931631		1945211		1306693		1313332		1311159		1308646		1314298		1333029		1336742		1344436		1365311		1353665		1364600		1361902		1361902		1391661		1364600		1400013		1388657		1430487		1404742		1439933		1463711		1466942		1501073		1502200		1562033		1559987		1602337		1604907		1633581		1641148		1388657		1671245		1824065		1824890		1812693		1678229		1683208		1877596		1388657		1731883		1678229		1728537		1683208		1976190		1984099		1388657		2299094		1388657		2528720		2217440		2283148		2297109		2452242		2298860		2452242		2197109		2020894		2009376		2058553		2082271		2077901		2122907		2107734		2147122		2171378		2514603		2495711		2508166		2346134		2509616		2520182		2325660		2497907		2440744		2270184		2526202		2281319		2205379		2401857		2356500		2312926		2393259		2647482		2668864		2587561		2505166		2600030		2440744		2486755		2553146		2670318		2520841		2589359		2688679		2663594		2704292		2686704		2639122		2751183		2738488
period_id		123		124		125		127		131		133		135		137		139		140		141		143		145		145		151		149		151		153		155		158		157		158		117		117		119		121		124		124		118		123		124		129		147		None		None		None		None		None		None		None		165		165		None		None		165		166		165		None		None		None		167		None		None		168		None		172		None		171		169		None		None		None		172		None		173		None		None		175		177		None		None		177		177		None		None		179		None		180		179		None		None		181		None		183		None		186		186		186		185		None		187		None		None		None		None		None		188		None		189		193		None		214		None		None		213		None		215		215		217		219		None		191		None		None		193		None		193		None		194		None		None		None		195		195		196		None		None		197		197		None		None		199		None		201		None		None		203		205		None		207		None		211		None		None		None		None		209		None		None		218		None		209		211		None		221		None		235		None		235		None		None		None		235		None		None		None		None		None		223		225		227		None		227		None		None		229		244		None		244		236		None		244		None		243		239		233		None		None		231		None		None		235		237		None		250		246		243		245		239		241		244		249		243		None		None		None		250		250		247		252		None
form_id		F405		F450		F450		F450		F450		F420		F450		F450		F450		F450		F450		F450		F405		F450		F405		F450		F450		F450		F450		F405		F450		F420		F410		F450		F450		F420		F420		F405		F405		F420		F405		F450		F450		F420		F450		F460		F450		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F497		F497		F497		F410		F460		F460		F410		F460		F410		F460		F460		F460		F460		F497		F497		F497		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F410		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F410		F410		F460		F410		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F410		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F497		F460		F460		F497		F460		F497		F460		F460		F410		F410		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F497		F460
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		1		0		1		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		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		2		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		1		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		3		0		1		0		1		0		0		5		0		4		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		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1990-11-26 00:00:00		1991-01-30 00:00:00		1991-07-30 00:00:00		1992-01-31 00:00:00		1993-02-01 00:00:00		1993-08-02 00:00:00		1994-01-31 00:00:00		1994-08-01 00:00:00		1994-10-05 00:00:00		1995-01-31 00:00:00		1995-07-28 00:00:00		1996-01-31 00:00:00		1996-01-16 00:00:00		1996-07-31 00:00:00		1997-07-18 00:00:00		1997-07-31 00:00:00		1998-02-02 00:00:00		1998-07-31 00:00:00		1999-02-01 00:00:00		1999-04-05 00:00:00		1999-06-01 00:00:00		1999-08-02 00:00:00		1989-03-16 00:00:00		1989-07-31 00:00:00		1990-01-31 00:00:00		1990-07-31 00:00:00		1990-10-26 00:00:00		1990-11-26 00:00:00		1989-05-01 00:00:00		1990-10-05 00:00:00		1990-12-11 00:00:00		1992-07-31 00:00:00		1997-01-31 00:00:00		2000-01-10 00:00:00		2000-02-24 00:00:00		2000-10-06 00:00:00		2000-07-31 00:00:00		2000-07-06 00:00:00		2001-01-31 00:00:00		2001-03-05 00:00:00		2001-02-28 00:00:00		2001-05-24 00:00:00		2001-05-25 00:00:00		2001-08-01 00:00:00		2001-07-26 00:00:00		2001-07-26 00:00:00		2001-07-26 00:00:00		2001-10-05 00:00:00		2001-07-31 00:00:00		2001-08-01 00:00:00		2001-10-07 00:00:00		2001-10-10 00:00:00		2001-12-17 00:00:00		2002-01-08 00:00:00		2002-01-10 00:00:00		2002-10-23 00:00:00		2002-07-31 00:00:00		2002-10-05 00:00:00		2002-07-29 00:00:00		2002-10-07 00:00:00		2002-10-24 00:00:00		2003-01-21 00:00:00		2003-01-12 00:00:00		2002-10-24 00:00:00		2003-07-22 00:00:00		2003-07-31 00:00:00		2004-01-12 00:00:00		2004-01-02 00:00:00		2004-02-27 00:00:00		2004-02-27 00:00:00		2004-02-19 00:00:00		2004-07-26 00:00:00		2004-02-15 00:00:00		2004-08-02 00:00:00		2004-10-05 00:00:00		2004-10-03 00:00:00		2004-10-21 00:00:00		2005-01-25 00:00:00		2004-12-14 00:00:00		2004-12-20 00:00:00		2005-08-01 00:00:00		2005-07-19 00:00:00		2005-01-31 00:00:00		2006-01-28 00:00:00		2006-01-31 00:00:00		2006-06-01 00:00:00		2006-05-24 00:00:00		2006-07-24 00:00:00		2006-05-25 00:00:00		2006-05-25 00:00:00		2006-10-04 00:00:00		2006-10-05 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-07-31 00:00:00		2007-01-31 00:00:00		2007-01-28 00:00:00		2007-07-31 00:00:00		2007-07-15 00:00:00		2008-01-29 00:00:00		2006-06-01 00:00:00		2013-06-25 00:00:00		2013-08-02 00:00:00		2013-08-02 00:00:00		2013-07-31 00:00:00		2014-07-28 00:00:00		2014-06-27 00:00:00		2013-08-02 00:00:00		2014-07-30 00:00:00		2015-01-28 00:00:00		2015-01-30 00:00:00		2008-01-26 00:00:00		2008-01-31 00:00:00		2008-01-29 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-05-18 00:00:00		2008-05-22 00:00:00		2008-07-21 00:00:00		2008-09-03 00:00:00		2008-07-31 00:00:00		2008-10-06 00:00:00		2008-10-03 00:00:00		2009-01-25 00:00:00		2009-01-25 00:00:00		2009-02-03 00:00:00		2009-02-02 00:00:00		2009-01-10 00:00:00		2009-07-13 00:00:00		2009-01-14 00:00:00		2009-07-29 00:00:00		2010-01-30 00:00:00		2010-02-01 00:00:00		2010-07-16 00:00:00		2010-07-19 00:00:00		2011-01-18 00:00:00		2011-01-14 00:00:00		2011-07-22 00:00:00		2011-07-27 00:00:00		2012-01-29 00:00:00		2012-01-31 00:00:00		2012-07-05 00:00:00		2012-07-09 00:00:00		2014-01-29 00:00:00		2014-01-29 00:00:00		2014-01-14 00:00:00		2012-07-31 00:00:00		2012-07-31 00:00:00		2014-07-31 00:00:00		2014-06-27 00:00:00		2013-01-23 00:00:00		2013-01-17 00:00:00		2013-01-17 00:00:00		2013-01-23 00:00:00		2015-07-22 00:00:00		2015-07-27 00:00:00		2018-09-20 00:00:00		2018-09-20 00:00:00		2018-07-26 00:00:00		2020-10-22 00:00:00		2018-01-31 00:00:00		2018-08-03 00:00:00		2018-09-27 00:00:00		2020-09-24 00:00:00		2018-09-27 00:00:00		2020-01-30 00:00:00		2017-07-28 00:00:00		2016-02-01 00:00:00		2016-01-28 00:00:00		2016-07-26 00:00:00		2016-09-28 00:00:00		2016-07-29 00:00:00		2017-01-24 00:00:00		2016-09-28 00:00:00		2017-01-30 00:00:00		2017-07-25 00:00:00		2020-10-13 00:00:00		2020-07-31 00:00:00		2020-10-01 00:00:00		2019-01-30 00:00:00		2020-09-24 00:00:00		2020-10-21 00:00:00		2018-10-25 00:00:00		2020-09-01 00:00:00		2020-01-30 00:00:00		2018-07-26 00:00:00		2020-10-23 00:00:00		2018-08-06 00:00:00		2018-01-25 00:00:00		2019-07-25 00:00:00		2019-01-30 00:00:00		2018-10-25 00:00:00		2019-07-25 00:00:00		2022-01-27 00:00:00		2022-04-21 00:00:00		2021-06-10 00:00:00		2020-09-24 00:00:00		2021-07-29 00:00:00		2020-07-31 00:00:00		2020-07-31 00:00:00		2021-02-01 00:00:00		2022-04-25 00:00:00		2020-10-22 00:00:00		2021-06-22 00:00:00		2022-05-26 00:00:00		2017-07-28 00:00:00		2022-07-29 00:00:00		2022-05-26 00:00:00		2022-01-27 00:00:00		2022-11-02 00:00:00		2022-07-29 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		10005		10005		10005		10005		10002		10005		10005		10001		10001		10005		10006		10002		10001		10002		10002		10005		10006		10001		10005		10002		10001		10005		10001		10005		10001		10001		10005		10005		10005		10001		10005		10001		10005		10005		10001		10001		10005		10005		10001		10001		10005		10005		10001		10002		10001		10002		10006		10005		10001		10005		10001		10005		10001		10001		10001		10001		10005		10001		10005		10005		10005		10005		10005		10001		10005		10001		10001		10005		10001		10006		10005		10001		10006		10001		10002		10001		10001		10005		10001		10006		10005		10002		10005		10001		10005		10001		10002		10005		10005		10001		10002		10001		10006		10005		10001		10001		10006		10005		10001		10005		10001		10005		10005		10001		10001		10005		10001		10005		10002		10006		10006		10005		10006		10001		10005		10005		10002		10005		10002		10001		10006		10001		10005		10002		10006		10002		10005		10005		10005		10001		10006		10005		10005		10005		10005		10001		10001		10001		10005		10001		10005		10005		10001		10001		10005		10001		10001		10005		10001		10005		10001		10001		10001		10006		10006		10001		10005		10005		10001		10001		10005		10001		10001		10001		10001		10002		10001		10001		10001		10001		10006		10005		10005		10001		10001		10001		10001		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		11003		11001		11001		11003		11001		11003		11003		11001		11001		11003		11003		11003		11001		11001		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11003		11003		11001		11001		11003		11003		11003		11003		11001		11003		11003
session_id		1989		1989		1991		1991		1991		1993		1993		1993		1993		1993		1995		1995		1995		1995		1997		1997		1997		1997		1997		1999		1999		1999		1989		1989		1989		1989		1989		1989		1989		1989		1989		1991		1995		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2005		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2013		2013		2013		2011		2011		2013		2013		2011		2011		2011		2011		2015		2015		2017		2017		2017		2019		2017		2017		2017		2019		2017		2019		2017		2015		2015		2015		2015		2015		2015		2015		2015		2017		2019		2019		2019		2017		2019		2019		2017		2019		2019		2017		2019		2017		2017		2019		2017		2017		2019		2021		2021		2021		2019		2021		2019		2019		2019		2021		2019		2021		2021		2017		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		KCHAN		JLEHMAN		DHORRELL		TWALLS		GPEREZ		*		*		SARRIAGA		SARRIAGA		*		*		*		TTHAM		SARRIAGA		SARRIAGA		*		CFLAGG		TTHAM		*		DBARRICK		*		DBARRICK		*		*		DBARRICK		DBARRICK		DBARRICK		COMPLETED		DBARRICK		COMPLETED		KVOONG1		MHOANG		COMPLETED		COMPLETED		GPEREZ		KLARRY		COMPLETED		COMPLETED		EMCENTEE		CFLAGG		COMPLETED		TTHAM		COMPLETED		COMPLETED		EMCENTEE		SARRIAGA		*		KVOONG1		*		KVANG		DHORRELL		DJOHNSON		*		*		CFLAGG		*		SARRIAGA		NWALKER		NWALKER		GPEREZ		GPEREZ		*		SARRIAGA		*		DHORRELL		DHORRELL		RGEREMIA		TRAMON		CPON		CPON		TRAMON		CAFILER		TRAMON		CAFILER		CAFILER		GCLARA		*		LHOANG		LHOANG		LHOANG		SARRIAGA		*		HTSUBOI		CPON		TBOWMAN		CPON		RGEREMIA		*		MMORENO		MMORENO		JVAZQUEZ		MMORENO		*		MMORENO		RGEREMIA		MMORENO		CPON		CPON		SMCCONNAN		SMCCONNAN		SMCCONNAN		SMCCONNAN		MMORENO		MMORENO		SMCCONNAN		SMCCONNAN		TRAMON		TRAMON		TRAMON		GGILMORE		TRAMON		MDIGRAZIA		MDIGRAZIA		MPACHECO		TRAMON		MPACHECO		CAFILER		CAFILER		MPACHECO		MDIGRAZIA		MDIGRAZIA		TRAMON		TRAMON		RSAGARIO		IMEDINA		CSAGABAEN		LPALMER		LBARTHOL		SUSHAKOV		LBARTHOL		SUSHAKOV		HSTOVALL		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		HSTOVALL		CAFILER		IMEDINA		CAFILER		LPHEAV		IMEDINA		CAFILER		CSAGABAEN		CAFILER		SUSHAKOV		LPALMER		IMEDINA		RSAGARIO		CSAGABAEN		HCOURSEY		LPHEAV		CSAGABAEN		HCOURSEY		KRUSSELL		CAFILER		CAFILER		IMEDINA		CAFILER		CAFILER		IMEDINA		CAFILER		CAFILER		IMEDINA		IMEDINA		JMAVES		AXIONG		CAFILER		CAFILER		KRUSSELL		CAFILER		JMAVES
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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		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		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11001		11001		11001		11003		11003		11003		11001		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		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
rpt_start		1990-07-01 00:00:00		1990-10-21 00:00:00		1991-01-01 00:00:00		1991-07-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		1994-10-01 00:00:00		1995-01-01 00:00:00		1995-07-01 00:00:00		None		1996-01-01 00:00:00		None		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-01-01 00:00:00		1998-07-01 00:00:00		None		1999-01-01 00:00:00		1999-05-23 00:00:00		None		1989-01-01 00:00:00		1989-07-01 00:00:00		1990-01-01 00:00:00		1990-10-01 00:00:00		1990-10-01 00:00:00		None		1990-07-01 00:00:00		None		1992-01-01 00:00:00		1996-07-01 00:00:00		1999-07-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-02-20 00:00:00		None		2000-10-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-02-25 00:00:00		2001-02-25 00:00:00		2001-02-25 00:00:00		2001-01-01 00:00:00		2001-05-20 00:00:00		2001-02-25 00:00:00		1900-01-01 00:00:00		2001-05-20 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		1900-01-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-10-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-10-20 00:00:00		2002-10-20 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2004-02-27 00:00:00		None		2004-01-01 00:00:00		2004-02-15 00:00:00		2004-01-01 00:00:00		2004-02-15 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		None		2004-10-01 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2004-10-17 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2006-06-01 00:00:00		2006-05-24 00:00:00		2006-05-21 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		None		None		2006-05-21 00:00:00		2006-10-01 00:00:00		2006-10-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2008-01-29 00:00:00		None		2013-06-25 00:00:00		None		2013-01-01 00:00:00		2013-01-01 00:00:00		None		2013-07-01 00:00:00		2013-08-02 00:00:00		2014-01-01 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2007-07-01 00:00:00		None		None		2008-01-31 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-05-18 00:00:00		None		2008-05-18 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2009-01-10 00:00:00		2009-01-01 00:00:00		None		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-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-07-05 00:00:00		None		None		2013-07-01 00:00:00		None		2012-01-01 00:00:00		2012-01-01 00:00:00		2014-01-01 00:00:00		2014-06-27 00:00:00		2012-07-01 00:00:00		2012-01-01 00:00:00		2012-07-01 00:00:00		2012-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2018-09-04 00:00:00		None		2018-07-26 00:00:00		2020-09-20 00:00:00		2017-07-01 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2019-07-01 00:00:00		2018-07-01 00:00:00		2019-07-01 00:00:00		2017-01-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2016-07-01 00:00:00		2016-01-01 00:00:00		2016-09-25 00:00:00		2016-07-01 00:00:00		2016-09-25 00:00:00		2017-01-01 00:00:00		2020-10-13 00:00:00		2020-01-01 00:00:00		2020-10-01 00:00:00		2018-10-21 00:00:00		2020-07-01 00:00:00		2020-10-21 00:00:00		2018-09-23 00:00:00		2020-08-31 00:00:00		2019-07-01 00:00:00		2018-01-01 00:00:00		None		None		2017-07-01 00:00:00		2019-01-01 00:00:00		2018-10-21 00:00:00		2018-09-23 00:00:00		2019-01-01 00:00:00		2021-07-01 00:00:00		2022-04-21 00:00:00		2021-06-10 00:00:00		2020-07-01 00:00:00		2021-01-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2020-10-18 00:00:00		2022-01-01 00:00:00		2020-09-20 00:00:00		None		2022-04-24 00:00:00		2017-01-01 00:00:00		2022-05-22 00:00:00		2022-04-24 00:00:00		2021-07-01 00:00:00		2022-11-01 00:00:00		2022-05-22 00:00:00
rpt_end		1990-09-30 00:00:00		1990-12-31 00:00:00		1991-06-30 00:00:00		1991-12-31 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-09-30 00:00:00		1994-12-31 00:00:00		1995-06-30 00:00:00		1995-12-31 00:00:00		None		1996-06-30 00:00:00		None		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-06-30 00:00:00		1998-12-31 00:00:00		None		1999-05-22 00:00:00		1999-06-30 00:00:00		None		1989-06-30 00:00:00		1989-12-31 00:00:00		1990-06-30 00:00:00		1990-10-20 00:00:00		1990-10-20 00:00:00		None		1990-09-30 00:00:00		None		1992-06-30 00:00:00		1996-12-31 00:00:00		1999-12-31 00:00:00		2000-02-19 00:00:00		2000-09-30 00:00:00		2000-06-30 00:00:00		None		2000-12-31 00:00:00		2001-02-24 00:00:00		2001-02-24 00:00:00		2001-05-19 00:00:00		2001-05-19 00:00:00		2001-05-19 00:00:00		2001-02-24 00:00:00		2001-06-30 00:00:00		2001-05-19 00:00:00		1900-01-01 00:00:00		2001-06-30 00:00:00		2001-02-24 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		1900-01-01 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2002-10-19 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-10-19 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2002-10-19 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-02-27 00:00:00		None		2004-02-14 00:00:00		2004-06-30 00:00:00		2004-02-14 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		None		2004-12-31 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2004-12-31 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-06-01 00:00:00		2006-05-24 00:00:00		2006-06-30 00:00:00		2006-05-20 00:00:00		2006-05-20 00:00:00		2006-09-30 00:00:00		2006-09-30 00:00:00		None		None		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-06-30 00:00:00		2008-01-29 00:00:00		None		2013-06-25 00:00:00		None		2013-06-30 00:00:00		2013-06-30 00:00:00		None		2013-12-31 00:00:00		2013-08-02 00:00:00		2014-06-30 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2007-12-31 00:00:00		None		None		2008-01-31 00:00:00		2007-12-31 00:00:00		2008-05-17 00:00:00		2008-05-17 00:00:00		2008-06-30 00:00:00		None		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-09-30 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2009-01-10 00:00:00		2009-06-30 00:00:00		None		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-12-31 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-07-05 00:00:00		None		None		2013-12-31 00:00:00		None		2012-06-30 00:00:00		2012-06-30 00:00:00		2014-06-30 00:00:00		2014-06-27 00:00:00		2012-12-31 00:00:00		2012-06-30 00:00:00		2012-12-31 00:00:00		2012-06-30 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2018-09-04 00:00:00		None		2018-07-26 00:00:00		2020-10-17 00:00:00		2017-12-31 00:00:00		2018-06-30 00:00:00		2018-09-22 00:00:00		2019-12-31 00:00:00		2018-09-22 00:00:00		2019-12-31 00:00:00		2017-06-30 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-09-24 00:00:00		2016-06-30 00:00:00		2016-12-31 00:00:00		2016-09-24 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2020-10-13 00:00:00		2020-06-30 00:00:00		2020-10-01 00:00:00		2018-12-31 00:00:00		2020-09-19 00:00:00		2020-10-21 00:00:00		2018-10-20 00:00:00		2020-08-31 00:00:00		2019-12-31 00:00:00		2018-06-30 00:00:00		None		None		2017-12-31 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2018-10-20 00:00:00		2019-06-30 00:00:00		2021-12-31 00:00:00		2022-04-21 00:00:00		2021-06-10 00:00:00		2020-09-19 00:00:00		2021-06-30 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2022-04-23 00:00:00		2020-10-17 00:00:00		None		2022-05-21 00:00:00		2017-06-30 00:00:00		2022-06-30 00:00:00		2022-05-21 00:00:00		2021-12-31 00:00:00		2022-11-01 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		2001-02-24 00:00:00		2001-05-19 00:00:00		None		None		2001-02-24 00:00:00		2001-06-30 00:00:00		2001-05-19 00:00:00		None		None		None		2001-09-30 00:00:00		None		None		2001-12-31 00:00:00		None		2002-10-19 00:00:00		None		2002-09-30 00:00:00		2002-06-30 00:00:00		None		None		None		2002-12-31 00:00:00		None		2003-06-30 00:00:00		None		None		2003-12-31 00:00:00		2004-02-27 00:00:00		None		None		2004-06-30 00:00:00		2004-02-14 00:00:00		None		None		2004-09-30 00:00:00		None		2004-12-31 00:00:00		2004-09-30 00:00:00		None		None		2005-06-30 00:00:00		None		2005-12-31 00:00:00		None		2006-06-01 00:00:00		2006-05-24 00:00:00		2006-06-30 00:00:00		2006-05-20 00:00:00		None		2006-09-30 00:00:00		None		None		None		None		None		2006-12-31 00:00:00		None		2007-06-30 00:00:00		2008-01-29 00:00:00		None		2013-06-25 00:00:00		None		None		2013-07-31 00:00:00		None		2014-06-27 00:00:00		None		2014-07-30 00:00:00		2015-01-28 00:00:00		None		2007-12-31 00:00:00		None		None		2008-01-31 00:00:00		None		2008-05-17 00:00:00		None		2008-06-30 00:00:00		None		None		None		2008-09-30 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		None		None		None		2009-06-30 00:00:00		None		None		2009-12-31 00:00:00		None		2010-06-30 00:00:00		None		None		2010-12-31 00:00:00		2011-06-30 00:00:00		None		2011-12-31 00:00:00		None		None		None		None		None		None		2012-06-30 00:00:00		None		None		None		None		2012-06-30 00:00:00		2013-01-17 00:00:00		None		2015-07-22 00:00:00		None		None		None		None		None		None		None		2018-09-27 00:00:00		None		None		None		None		None		2016-01-28 00:00:00		2016-07-26 00:00:00		2016-09-28 00:00:00		None		2017-01-24 00:00:00		None		None		2017-07-25 00:00:00		2020-10-13 00:00:00		None		2020-10-01 00:00:00		2019-01-29 00:00:00		None		2020-10-21 00:00:00		None		2020-08-31 00:00:00		2020-01-19 00:00:00		2018-07-26 00:00:00		None		None		2018-01-25 00:00:00		None		None		2018-10-25 00:00:00		2019-07-24 00:00:00		None		2022-04-21 00:00:00		2021-06-10 00:00:00		2020-09-24 00:00:00		2021-07-13 00:00:00		2020-07-29 00:00:00		2020-07-14 00:00:00		2021-01-15 00:00:00		2022-04-25 00:00:00		2020-10-17 00:00:00		None		None		None		2022-07-12 00:00:00		2022-05-23 00:00:00		2022-01-08 00:00:00		2022-11-01 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		22001		None		None		22001		22001		None		None		22001		22001		None		None		22001		None		22001		22001		None		None		22001		None		22001		None		22006		22006		22001		22001		None		22001		None		None		None		None		None		22001		None		22001		22006		None		22006		None		None		22001		None		22006		22001		22006		22006		None		22001		None		None		22006		None		22001		None		22001		None		None		None		22001		22001		22001		None		None		22006		22001		None		None		22001		None		22001		None		None		22001		22001		None		22001		None		22006		None		None		None		None		22001		None		None		22006		None		22001		22006		None		22006		None		22001		None		22006		None		None		None		22001		None		None		None		None		None		22006		22006		22006		None		22006		None		None		22006		22001		None		22001		22001		None		22001		None		22001		22001		22006		None		None		22006		None		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		None		22001		22001		22001		22001		None

Table: filer_to_filer_type

filer_id		1047876		1047876		1047876
filer_type		16		16		16
active		Y		Y		Y
race		0		0		0
session_id		1989		2019		2021
category		0		0		0
category_type		40502		40503		40503
sub_category		40103		40101		40103
effect_dt		2001-10-05 00:00:00		2020-10-23 00:00:00		2021-06-22 00:00:00
sub_category_type		40203		40203		40203
election_type		0		0		0
sub_category_a		S		S		S
nyq_dt		1990-01-31 00:00:00		1990-01-31 00:00:00		1990-01-31 00:00:00
party_cd		0		0		0
county_cd		18026		18026		18026
district_cd		0		0		0

Table: filer_xref

filer_id		1047876
xref_id		890464
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464		890464
filer_id		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00		2021-06-22 00:00:00
naml		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE, A COMMITTEE FOR MEASURE RR		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE, A COMMITTEE FOR MEASURE RR		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE, A COMMITTEE FOR MEASURE RR		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE, A COMMITTEE FOR MEASURE RR		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE, A COMMITTEE FOR MEASURE RR		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE, A COMMITTEE FOR MEASURE RR		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE, A COMMITTEE FOR MEASURE RR		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE, A COMMITTEE FOR MEASURE RR		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE, A COMMITTEE FOR MEASURE RR		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE, A COMMITTEE FOR MEASURE RR		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE, A COMMITTEE FOR MEASURE RR		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE, A COMMITTEE FOR MEASURE RR		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION OF JOURNEYMEN & APPRENTICES OF THE PLUMBING & PIPEFITTING INDUSTRY LOCAL UNION NUMBER 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION LOCAL UNION 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION LOCAL UNION 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION LOCAL UNION 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION LOCAL UNION 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION LOCAL UNION 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION LOCAL UNION 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION LOCAL UNION 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION LOCAL UNION 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION LOCAL UNION 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION LOCAL UNION 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION LOCAL UNION 345 POLITICAL ACTION COMMITTEE		UNITED ASSOCIATION LOCAL UNION 345 POLITICAL ACTION COMMITTEE		PLUMBERS AND STEAMFITTERS LOCAL UNION NO. 345 - POLITICAL ACTION COMMITTEE		PLUMBERS AND STEAMFITTERS LOCAL UNION NO. 345 - POLITICAL ACTION COMMITTEE		PLUMBERS AND STEAMFITTERS LOCAL UNION NO. 345 - POLITICAL ACTION COMMITTEE		PLUMBERS AND STEAMFITTERS LOCAL UNION NO. 345 - POLITICAL ACTION COMMITTEE		PLUMBERS AND STEAMFITTERS LOCAL UNION NO. 345 - POLITICAL ACTION COMMITTEE		PLUMBERS AND STEAMFITTERS LOCAL UNION NO. 345 - POLITICAL ACTION COMMITTEE		PLUMBERS AND STEAMFITTERS LOCAL UNION NO. 345 - POLITICAL ACTION COMMITTEE		PLUMBERS AND STEAMFITTERS LOCAL UNION NO. 345 - POLITICAL ACTION COMMITTEE		PLUMBERS AND STEAMFITTERS LOCAL UNION NO. 345 - POLITICAL ACTION COMMITTEE		PLUMBERS AND STEAMFITTERS LOCAL UNION NO. 345 - POLITICAL ACTION COMMITTEE		PLUMBERS AND STEAMFITTERS LOCAL UNION NO. 345 - POLITICAL ACTION COMMITTEE		PLUMBERS AND STEAMFITTERS LOCAL UNION NO. 345 - POLITICAL ACTION COMMITTEE
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
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
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
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
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
city		MONROVIA		DUARTE		DUARTE		SACRAMENTO		DUARTE		DUARTE		LOS ANGELES		DUARTE		DUARTE		SACRAMENTO		DUARTE		SACRAMENTO		MONROVIA		DUARTE		DUARTE		SACRAMENTO		DUARTE		DUARTE		LOS ANGELES		DUARTE		DUARTE		SACRAMENTO		DUARTE		SACRAMENTO		MONROVIA		DUARTE		DUARTE		SACRAMENTO		DUARTE		DUARTE		LOS ANGELES		DUARTE		DUARTE		SACRAMENTO		DUARTE		SACRAMENTO		MONROVIA		DUARTE		DUARTE		SACRAMENTO		DUARTE		DUARTE		LOS ANGELES		DUARTE		DUARTE		SACRAMENTO		DUARTE		SACRAMENTO		MONROVIA		DUARTE		DUARTE		SACRAMENTO		DUARTE		DUARTE		LOS ANGELES		DUARTE		DUARTE		SACRAMENTO		DUARTE		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
zip4		910164557		91010		91010		95814		91010		91010		90017		91010		91010		95814		91010		95814		910164557		91010		91010		95814		91010		91010		90017		91010		91010		95814		91010		95814		910164557		91010		91010		95814		91010		91010		90017		91010		91010		95814		91010		95814		910164557		91010		91010		95814		91010		91010		90017		91010		91010		95814		91010		95814		910164557		91010		91010		95814		91010		91010		90017		91010		91010		95814		91010		95814
phon		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345		6263579345
fax		None		None		None		None		6263590359		6263590359		6263590359		6263590359										None		None		None		None		6263590359		6263590359		6263590359		6263590359										None		None		None		None		6263590359		6263590359		6263590359		6263590359										None		None		None		None		6263590359		6263590359		6263590359		6263590359										None		None		None		None		6263590359		6263590359		6263590359		6263590359
email		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1047876

Table: received_filings

filer_id		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876		1047876
filing_file_name		731644_0.cal		770001_0.cal		759275_1.cal		731644_1.cal		785232_0.cal		759275_0.cal		804026_0.cal		853517_0.cal		871148_0.cal		877280_0.cal		901018_0.cal		943565_0.cal		977890_0.cal		1002840_0.cal		1388657_1.cal		2497907_0.cal		2668864_0.cal		2508166_0.cal		2514603_0.cal		2520182_0.cal		2751183_0.cal
received_date		2001-02-28 00:00:00		2001-07-26 00:00:00		2001-07-26 00:00:00		2001-07-26 00:00:00		2001-10-07 00:00:00		2001-05-24 00:00:00		2002-01-08 00:00:00		2002-07-29 00:00:00		2002-10-05 00:00:00		2002-10-23 00:00:00		2003-01-12 00:00:00		2003-07-22 00:00:00		2004-01-02 00:00:00		2004-02-27 00:00:00		2012-07-05 00:00:00		2020-09-01 00:00:00		2022-04-21 00:00:00		2020-10-01 00:00:00		2020-10-13 00:00:00		2020-10-21 00:00:00		2022-11-02 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/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		731644		770001		759275		731644		785232		759275		804026		853517		871148		877280		901018		943565		977890		1002840		1388657		2497907		2668864		2508166		2514603		2520182		2751183
form_id		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F410		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted