Home

Filer ID: 1148479

Table: filer_address

filer_id		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479
adrid		1103146		2011169		2028053		2041887		2080988		2119043		2160702		2167712		2204158		2411354		2470556		2507668		2507669		2550097		2550098		2279516		2343273		2343274
effect_dt		1999-01-01 00:00:00		2001-01-01 00:00:00		2002-02-04 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2009-02-19 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7082		7051		7051		7051		7051		7082		7051		7082		7051		7051		7082
session_id		1999		2001		2001		2003		2005		2007		2009		2009		2011		2017		2019		2021		2021		2023		2023		2013		2015		2015

Table: filer_ethics_class

filer_id		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479
session_id		1999		2001		1997		1995		2003		2005		2007		2009		2011		2013		2015		2017		2019		2021
ethics_date		1999-01-08 00:00:00		2000-11-14 00:00:00		1999-01-08 00:00:00		1994-03-09 00:00:00		2002-11-13 00:00:00		2004-11-17 00:00:00		2007-02-08 00:00:00		2009-02-19 00:00:00		2011-04-21 00:00:00		2013-05-16 00:00:00		2015-06-16 00:00:00		2017-06-22 00:00:00		2019-05-23 00:00:00		2021-04-15 00:00:00

Table: filer_filings

filer_id		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479
filing_id		515757		520403		511070		511589		514690		512608		514163		517302		518889		523025		522479		525130		527219		528688		529208		524569		526678		517824		520921		624627		633079		618038		681604		662809		644398		719131		696533		703979		730503		755658		745926		769324		791563		780714		812203		797885		815941		839545		824414		719131		863159		843418		853563		893515		878470		898042		875345		908995		919910		930082		947678		936640		973633		988778		955932		968846		1010641		997847		1033363		1018349		1074333		1058094		1066112		1068679		1073208		1035788		1094954		1104597		1118965		1146695		1132747		1166901		1192481		1219663		1238446		1279990		1246719		1262294		1275458		1295530		1768659		1729516		1766102		1779292		1978854		1964118		1971595		1923232		1869341		1800082		1961511		1910781		1310274		1327492		1346374		1310274		1391236		1372984		1387480		1418977		1408933		1408933		1436076		1449930		1462265		1504835		1481298		1557088		1535171		1570034		1578481		1593150		1591414		1623121		1607384		1636930		1658577		1678602		1817188		1934064		1923232		1708289		1743271		1729516		1728170		1996925		1844494		2344374		2548467		2240466		2212406		2385685		2418724		2271559		2194482		2010972		2035799		2062973		2103168		2118614		2131459		2135948		2175768		2156332		2164034		2118614		2363990		2315667		2356721		2468554		2436011		2400218		2481629		2363990		2544468		2380033		2544468		2580918		2671186		2524876		2622228		2601331		2705335		2591773		2646081		2568263		2746915
period_id		158		144		141		149		150		157		142		143		159		153		145		154		155		148		156		146		147		151		152		161		161		160		163		162		162		164		163		None		164		165		165		166		167		None		168		None		None		169		None		164		None		None		170		None		171		None		None		172		None		173		174		None		None		176		None		175		177		None		178		None		180		179		None		180		None		None		None		181		182		184		183		185		186		187		188		190		None		189		None		191		None		215		213		214		222		221		None		222		218		215		None		219		192		193		194		192		196		195		197		197		None		None		198		199		200		202		201		None		203		204		205		None		205		207		206		208		209		210		216		220		221		211		None		213		212		223		217		236		244		233		232		None		239		234		231		224		225		226		227		229		228		None		230		229		None		231		237		235		None		241		240		238		242		238		246		237		245		245		249		243		247		246		250		None		248		None		251
form_id		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F690		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F615		F604		F604		F615		F615		F615		F615		F604		F604		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F604		F615		F615		F615		F615		F615		F604		F615		F615		F604		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F604		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F615		F615		F604		F604		F604		F615		F604		F615		F615		F615		F615		F604		F604		F615		F604		F615		F615		F615		F615		F615		F615		F604		F615		F604		F615
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		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		1		0		0		0		0		0		1		0		0		0		0		0		0		0		1		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		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1999-07-30 00:00:00		1996-01-31 00:00:00		1995-04-28 00:00:00		1997-04-30 00:00:00		1997-07-31 00:00:00		1999-04-30 00:00:00		1995-07-31 00:00:00		1995-10-30 00:00:00		1999-10-29 00:00:00		1998-04-30 00:00:00		1996-04-30 00:00:00		1998-07-31 00:00:00		1998-11-02 00:00:00		1997-01-31 00:00:00		1999-02-01 00:00:00		1996-07-31 00:00:00		1996-10-31 00:00:00		1997-10-31 00:00:00		1998-01-29 00:00:00		2000-05-02 00:00:00		2000-05-01 00:00:00		2000-01-31 00:00:00		2000-10-31 00:00:00		2000-07-31 00:00:00		2000-07-31 00:00:00		2001-01-31 00:00:00		2000-10-31 00:00:00		2000-12-28 00:00:00		2001-01-31 00:00:00		2001-04-30 00:00:00		2001-04-30 00:00:00		2001-07-24 00:00:00		2001-10-31 00:00:00		2001-07-31 00:00:00		2002-01-29 00:00:00		2001-10-31 00:00:00		2002-01-03 00:00:00		2002-04-30 00:00:00		2002-01-30 00:00:00		2002-09-19 00:00:00		2002-07-31 00:00:00		2002-04-30 00:00:00		2002-07-29 00:00:00		2002-10-30 00:00:00		2002-10-24 00:00:00		2002-12-20 00:00:00		2002-09-19 00:00:00		2003-01-29 00:00:00		2003-01-31 00:00:00		2003-04-29 00:00:00		2003-07-31 00:00:00		2003-04-29 00:00:00		2003-10-31 00:00:00		2004-01-29 00:00:00		2003-07-31 00:00:00		2003-10-30 00:00:00		2004-04-22 00:00:00		2004-02-02 00:00:00		2004-08-02 00:00:00		2004-04-30 00:00:00		2005-01-23 00:00:00		2004-10-29 00:00:00		2004-11-01 00:00:00		2004-12-29 00:00:00		2004-12-30 00:00:00		2004-07-31 00:00:00		2005-01-28 00:00:00		2005-04-29 00:00:00		2005-08-01 00:00:00		2006-01-30 00:00:00		2005-10-28 00:00:00		2006-04-28 00:00:00		2006-07-31 00:00:00		2006-11-03 00:00:00		2007-01-31 00:00:00		2007-07-24 00:00:00		2006-11-28 00:00:00		2007-04-30 00:00:00		2007-06-26 00:00:00		2007-10-27 00:00:00		2013-05-16 00:00:00		2013-07-29 00:00:00		2013-04-30 00:00:00		2013-07-29 00:00:00		2015-07-29 00:00:00		2015-04-29 00:00:00		2015-06-16 00:00:00		2015-06-22 00:00:00		2014-07-30 00:00:00		2013-10-30 00:00:00		2015-01-26 00:00:00		2014-10-30 00:00:00		2008-01-31 00:00:00		2008-04-28 00:00:00		2008-07-26 00:00:00		2008-04-27 00:00:00		2009-01-22 00:00:00		2008-10-27 00:00:00		2009-01-05 00:00:00		2009-04-27 00:00:00		2009-02-19 00:00:00		2009-01-15 00:00:00		2009-07-30 00:00:00		2009-10-27 00:00:00		2010-01-28 00:00:00		2010-07-29 00:00:00		2010-04-21 00:00:00		2011-01-03 00:00:00		2010-10-26 00:00:00		2011-01-30 00:00:00		2011-02-23 00:00:00		2011-04-21 00:00:00		2011-05-02 00:00:00		2011-10-31 00:00:00		2011-07-30 00:00:00		2012-01-31 00:00:00		2012-05-01 00:00:00		2012-07-31 00:00:00		2014-01-30 00:00:00		2015-01-30 00:00:00		2015-01-06 00:00:00		2012-10-30 00:00:00		2012-12-26 00:00:00		2013-01-21 00:00:00		2013-01-17 00:00:00		2015-10-30 00:00:00		2014-04-30 00:00:00		2019-01-29 00:00:00		2021-01-27 00:00:00		2018-04-29 00:00:00		2018-02-01 00:00:00		2019-05-30 00:00:00		2019-10-31 00:00:00		2018-07-30 00:00:00		2017-10-31 00:00:00		2016-01-29 00:00:00		2016-04-29 00:00:00		2016-07-31 00:00:00		2016-11-01 00:00:00		2017-01-11 00:00:00		2017-01-31 00:00:00		2016-12-27 00:00:00		2017-07-31 00:00:00		2017-04-29 00:00:00		2017-06-22 00:00:00		2017-07-10 00:00:00		2019-02-28 00:00:00		2018-10-29 00:00:00		2018-12-27 00:00:00		2020-04-29 00:00:00		2020-01-27 00:00:00		2019-07-31 00:00:00		2020-07-27 00:00:00		2019-06-10 00:00:00		2021-05-17 00:00:00		2019-04-30 00:00:00		2021-01-14 00:00:00		2021-04-30 00:00:00		2022-04-27 00:00:00		2020-10-28 00:00:00		2021-10-29 00:00:00		2021-07-30 00:00:00		2022-07-30 00:00:00		2021-05-03 00:00:00		2022-02-01 00:00:00		2020-12-30 00:00:00		2022-10-30 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		10005		10005		10001		10005		10001		10001		10005		10005		10005		10005		10001		10001		10001		10005		10001		10005		10005		10001		10005		10002		10005		10005		10001		10005		10001		10005		10006		10001		10005		10001		10001		10005		10005		10001		10005		10001		10001		10005		10001		10005		10001		10001		10005		10001		10005		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10002		10001		10006		10002		10001		10001		10001		10001		10006		10002		10001		10001		10005		10001		10001		10001		10001		10002		10001		10001		10001		10001		10006		10005		10001		10001		10001		10001		10001		10005		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10006		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10006		10002		10001		10001		10005		10001		10001		10001		10001		10002		10002		10001		10001		10001		10001		10001		10001		10001		10001		10002		10001		10005		10001
stmnt_status		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		11001		11001		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11001		11001		11003		11001		11003		11001		11001		11003		11001		11003		11003		11003		11001		11003		11001		11003		11003		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11003
session_id		1999		1995		1995		1997		1997		1999		1995		1995		1999		1997		1995		1997		1997		1995		1997		1995		1995		1997		1997		1999		1999		1999		1999		1999		1999		1999		1999		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		1999		2001		2001		2001		2001		2001		2003		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2007		2007		2013		2013		2013		2013		2015		2015		2015		2015		2013		2013		2015		2013		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2015		2011		2013		2013		2011		2015		2013		2017		2019		2017		2017		2019		2019		2017		2017		2015		2015		2015		2015		2017		2015		2017		2017		2017		2017		2017		2019		2017		2019		2019		2019		2019		2019		2019		2021		2019		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		*		*		CFLAGG		*		*		CFLAGG		YBONILLA		YBONILLA		YBONILLA		*		*		*		LTHIBAUL		*		LTHIBAUL		SARRIAGA		*		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		*		GPEREZ		LTHIBAUL		COMPLETED		LTHIBAUL		COMPLETED		COMPLETED		DBARRICK		LTHIBAUL		COMPLETED		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		SARRIAGA		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		YRODRIGU		YRODRIGU		YRODRIGU		GPEREZ		YRODRIGU		GPEREZ		LTHIBAUL		PBANFORD		CAFILER		ASAETERN		ASAETERN		JINGRAM		JINGRAM		PBANFORD		PBANFORD		ASAETERN		ASAETERN		GPEREZ		ASAETERN		YRODRIGU		LTHIBAUL		LTHIBAUL		LTHIBAUL		JINGRAM		JINGRAM		*		JINGRAM		YRODRIGU		YRODRIGU		JINGRAM		JINGRAM		JINGRAM		ASAETERN		JINGRAM		GPEREZ		ASAETERN		ASAETERN		*		CFLAGG		JINGRAM		ASAETERN		ASAETERN		ASAETERN		ASAETERN		AGLADNEY		ASAETERN		AGLADNEY		CAFILER		ASAETERN		PBANFORD		CAFILER		ASAETERN		JINGRAM		ASAETERN		JFRONEFIELD		GTAYLOR		AGLADNEY		KBANH		SUSHAKOV		VUKSTINA		JFRONEFIELD		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		CAFILER		AGLADNEY		GPEREZ		SMCCONNAN		AGLADNEY		PBANFORD		PBANFORD		CAFILER		JFRONEFIELD		PBANFORD		VUKSTINA		GTAYLOR		VUKSTINA		VUKSTINA		CAFILER		MMERCHANT		VUKSTINA		CVANLIEW		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		CHATRIDGE		CAFILER		MMERCHANT		RATTIYEH		CVANLIEW		CAFILER
special_audit		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		11002		11003		11002		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11001		11001		11001		11002		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11003		11001		11001		11001		11003		11003		11001		11003		11003
rpt_start		1999-04-01 00:00:00		1995-10-01 00:00:00		1995-01-01 00:00:00		1997-01-01 00:00:00		1997-04-01 00:00:00		1999-01-01 00:00:00		1995-04-01 00:00:00		1995-07-01 00:00:00		1999-07-01 00:00:00		1998-01-01 00:00:00		1996-01-01 00:00:00		1998-04-01 00:00:00		1998-07-01 00:00:00		1996-10-01 00:00:00		1998-10-01 00:00:00		1996-04-01 00:00:00		1996-07-01 00:00:00		1997-07-01 00:00:00		1997-10-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		2000-07-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-10-01 00:00:00		2000-07-01 00:00:00		1900-01-01 00:00:00		2000-10-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		1900-01-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		2000-10-01 00:00:00		2002-04-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		2000-10-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		2003-10-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-12-29 00:00:00		1900-01-01 00:00:00		2004-04-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		2005-10-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		2007-04-01 00:00:00		1900-01-01 00:00:00		2007-01-01 00:00:00		1900-01-01 00:00:00		2007-07-01 00:00:00		1900-01-01 00:00:00		2013-07-29 00:00:00		2013-01-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		2015-06-22 00:00:00		2014-04-01 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2007-10-31 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2007-10-01 00:00:00		2008-10-01 00:00:00		2008-07-01 00:00:00		2009-01-05 00:00:00		2009-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		1900-01-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2011-02-23 00:00:00		1900-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2013-10-01 00:00:00		2014-10-01 00:00:00		2015-01-06 00:00:00		2012-07-01 00:00:00		1900-01-01 00:00:00		2013-01-21 00:00:00		2012-10-01 00:00:00		2015-07-01 00:00:00		2014-01-01 00:00:00		2018-10-01 00:00:00		2020-10-01 00:00:00		2018-01-01 00:00:00		2017-10-01 00:00:00		1900-01-01 00:00:00		2019-07-01 00:00:00		2018-04-01 00:00:00		2017-07-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2017-01-11 00:00:00		2016-10-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-07-10 00:00:00		2019-02-28 00:00:00		2018-07-01 00:00:00		1900-01-01 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2019-04-01 00:00:00		2020-04-01 00:00:00		2019-06-10 00:00:00		2021-05-17 00:00:00		2019-01-01 00:00:00		2021-01-14 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2020-07-01 00:00:00		2021-07-01 00:00:00		2021-04-01 00:00:00		2022-04-01 00:00:00		1900-01-01 00:00:00		2021-10-01 00:00:00		1900-01-01 00:00:00		2022-07-01 00:00:00
rpt_end		1999-06-30 00:00:00		1995-12-31 00:00:00		1995-03-31 00:00:00		1997-03-31 00:00:00		1997-06-30 00:00:00		1999-03-31 00:00:00		1995-06-30 00:00:00		1995-09-30 00:00:00		1999-09-30 00:00:00		1998-03-31 00:00:00		1996-03-31 00:00:00		1998-06-30 00:00:00		1998-09-30 00:00:00		1996-12-31 00:00:00		1998-12-31 00:00:00		1996-06-30 00:00:00		1996-09-30 00:00:00		1997-09-30 00:00:00		1997-12-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		1999-12-31 00:00:00		2000-09-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2000-09-30 00:00:00		1900-01-01 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		1900-01-01 00:00:00		2002-03-31 00:00:00		2001-12-31 00:00:00		2000-12-31 00:00:00		2002-06-30 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		2000-12-31 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2004-03-31 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-12-29 00:00:00		1900-01-01 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-09-30 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2007-12-31 00:00:00		2007-06-30 00:00:00		1900-01-01 00:00:00		2007-03-31 00:00:00		1900-01-01 00:00:00		2007-09-30 00:00:00		1900-01-01 00:00:00		2013-07-29 00:00:00		2013-03-31 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		2015-06-22 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2007-12-31 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2007-12-31 00:00:00		2008-12-31 00:00:00		2008-09-30 00:00:00		2009-01-05 00:00:00		2009-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		1900-01-01 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2011-02-23 00:00:00		1900-01-01 00:00:00		2011-03-31 00:00:00		2011-09-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2015-01-06 00:00:00		2012-09-30 00:00:00		1900-01-01 00:00:00		2013-01-21 00:00:00		2012-12-31 00:00:00		2015-09-30 00:00:00		2014-03-31 00:00:00		2018-12-31 00:00:00		2020-12-31 00:00:00		2018-03-31 00:00:00		2017-12-31 00:00:00		1900-01-01 00:00:00		2019-09-30 00:00:00		2018-06-30 00:00:00		2017-09-30 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2017-01-11 00:00:00		2016-12-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-07-10 00:00:00		2019-02-28 00:00:00		2018-09-30 00:00:00		1900-01-01 00:00:00		2020-03-31 00:00:00		2019-12-31 00:00:00		2019-06-30 00:00:00		2020-06-30 00:00:00		2019-06-10 00:00:00		2021-05-17 00:00:00		2019-03-31 00:00:00		2021-01-14 00:00:00		2021-03-31 00:00:00		2022-03-31 00:00:00		2020-09-30 00:00:00		2021-09-30 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		1900-01-01 00:00:00		2021-12-31 00:00:00		1900-01-01 00:00:00		2022-09-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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		22001		None		22001		22001		None		None		22001		None		22001		22001		None		22001		None		22001		22001		None		22001		None		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22006		None		22006		None		22006		None		22006		22006		22006		22006		22006		None		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		None		22006		22006		22006		22006		22006		None		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		None		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		None		22006

Table: filer_to_filer_type

filer_id		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479
filer_type		4		4		4		4		4		4		4		4		4		4		4		4		4		4		4		4		4
active		Y		Y		Y		Y		T		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
session_id		2001		1995		1999		1997		2001		2001		2003		2005		2007		2011		2013		2009		2015		2021		2019		2017		2023
category		0		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
category_type		0		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
sub_category		0		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
effect_dt		2001-01-01 00:00:00		1995-01-01 00:00:00		1999-01-01 00:00:00		1997-01-01 00:00:00		2001-12-31 00:00:00		2002-01-02 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
election_type		0		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		None		None		2000-01-01 00:00:00		2000-01-01 00:00:00		None		None		None		None		None		None		None		None
party_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
county_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
district_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1148479
xref_id		L24496
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496		L24496
filer_id		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479
filer_type		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA		MORIYAMA
namf		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFF		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.		CLIFFORD H.
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		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		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		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		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		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958122166		95812		95814		95812		95814		95814		95814		95814		95814		95814		95814		95814		95814
phon		9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215				9164437933		9164437933		9164434676		9164434676		9164434676		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215		9162155215		9162155215				9162155215
fax		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626																		None		None		9164430938		9164430938				9168483626		9168483626						9168483626
email		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None

Table: filers

filer_id		1148479

Table: lobbying_chg_log

filer_id		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479
change_no		1		0		2		3		4		5		6		7		8
session_id		2001		2001		2001		2001		2001		1999		1999		2015		2015
log_dt		2002-01-24 00:00:00		2002-01-03 00:00:00		2002-01-03 00:00:00		2002-01-03 00:00:00		2002-01-03 00:00:00		2002-01-03 00:00:00		2002-01-03 00:00:00		2015-01-26 00:00:00		2015-01-26 00:00:00
filer_type		4		4		4		4		4		4		4		4		4
correction_flg		None		None		None		None		None		None		None		None		Y
action		DELETED		ADDED		TERMINATED		CHANGED		SET ACTIVE		CHANGED		CHANGED		SET ACTIVE		ADDED
attribute_changed		EMPLOYER		EMPLOYER				ADDRESS AND PHONE				NAME		NAME				FIRM
ethics_dt		None		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None		None
filer_full_name		CLIFF MORIYAMA		CLIFF MORIYAMA		FILER INFORMATION		FILER INFORMATION		FILER INFORMATION		CLIFF MORIYAMA		CLIFF0RD H. MORIYAMA		MORIYAMA, CLIFFORD H.		MORIYAMA, CLIFFORD H.
filer_city		None		None		None		SACRAMENTO		None		None		None		None		None
filer_st		None		None		None		CA		None		None		None		None		None
filer_zip		None		None		None		95814		None		None		None		None		None
filer_phone		None		None		None		9164434676		None		None		None		None		None
entity_type		2		2		4		4		4		4		4		4		3
entity_name		CALIFORNIA BUILDING INDUSTRY ASSOCIATION		CALIFORNIA BUSINESS PROPERTIES ASSOCIATION		None		None		None		FILER INFORMATION		FILER INFORMATION		None		MORIYAMA CONSULTING; CLIFF
entity_city		None		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None
entity_id		1146938		1146887		0		0		0		0		0		0		1295401
responsible_officer		None		None		None		None		None		None		None		None		None
effect_dt		2001-12-31 00:00:00		2002-01-02 00:00:00		2001-12-31 00:00:00		2002-02-04 00:00:00		2002-01-02 00:00:00		1999-01-01 00:00:00		1999-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00

Table: received_filings

filer_id		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479		1148479
filing_file_name		624627_0.cal		644398_0.cal		681604_0.cal		719131_0.cal		745926_0.cal		247740.cal		769324_0.cal		791563_0.cal		812203_0.cal		839545_0.cal		853563_0.cal		719131_1.cal		878470_0.cal		908995_0.cal		930082_0.cal		947678_0.cal		968846_0.cal		988778_0.cal		1010641_0.cal		1033363_0.cal		1058094_0.cal		1068679_0.cal		1074333_0.cal		1104597_0.cal		1118965_0.cal		1132747_0.cal		1146695_0.cal		1166901_0.cal		1192481_0.cal		1219663_0.cal		1238446_0.cal		1729516_0.cal		1578481_0.cal		1729516_1.cal		1923232_1.cal		2118614_0.cal		1923232_0.cal		2118614_1.cal		2363990_1.cal		2363990_0.cal		2544468_0.cal		2544468_1.cal
received_date		2000-05-02 00:00:00		2000-07-31 00:00:00		2000-10-31 00:00:00		2001-01-31 00:00:00		2001-04-30 00:00:00		2001-04-30 00:00:00		2001-07-24 00:00:00		2001-10-31 00:00:00		2002-01-29 00:00:00		2002-04-30 00:00:00		2002-07-29 00:00:00		2002-09-19 00:00:00		2002-10-24 00:00:00		2003-01-29 00:00:00		2003-04-29 00:00:00		2003-07-31 00:00:00		2003-10-30 00:00:00		2004-01-29 00:00:00		2004-04-22 00:00:00		2004-08-02 00:00:00		2004-10-29 00:00:00		2004-12-29 00:00:00		2005-01-23 00:00:00		2005-04-29 00:00:00		2005-08-01 00:00:00		2005-10-28 00:00:00		2006-01-30 00:00:00		2006-04-28 00:00:00		2006-07-31 00:00:00		2006-11-03 00:00:00		2007-01-31 00:00:00		2013-01-21 00:00:00		2011-02-23 00:00:00		2013-07-29 00:00:00		2015-06-22 00:00:00		2017-01-11 00:00:00		2015-01-06 00:00:00		2017-07-10 00:00:00		2019-06-10 00:00:00		2019-02-28 00:00:00		2021-01-14 00:00:00		2021-05-17 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/temp		/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		/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		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		624627		644398		681604		719131		745926		None		769324		791563		812203		839545		853563		719131		878470		908995		930082		947678		968846		988778		1010641		1033363		1058094		1068679		1074333		1104597		1118965		1132747		1146695		1166901		1192481		1219663		1238446		1729516		1578481		1729516		1923232		2118614		1923232		2118614		2363990		2363990		2544468		2544468
form_id		F615		F615		F615		F615		F615		None		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F604		F604		F604		F604		F604		F604		F604		F604		F604
receive_comment		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted