Home

Filer ID: 1145670

Table: filer_address

filer_id		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670
adrid		1111323		2042948		2080537		2116068		2165085		2203319		2522639		2522640		2421413		2421258		2263436		2466854		2466855		2545641		2545642		2337443		2505421		2505422
effect_dt		1999-01-01 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		2011-01-01 00:00:00		2021-03-15 00:00:00		2021-03-15 00:00:00		2017-01-12 00:00:00		2017-01-01 00:00:00		2013-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7082		7082		7051		7051		7051		7082		7051		7082		7051		7051		7082
session_id		1999		2003		2005		2007		2009		2011		2021		2021		2017		2017		2013		2019		2019		2023		2023		2015		2021		2021

Table: filer_filings

filer_id		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670
filing_id		468416		472040		466715		497570		490283		486627		473956		477587		479558		493964		473956		483103		632005		612962		661464		681122		715498		718358		695329		758548		751497		737564		791630		778850		772271		794801		813684		838855		820373		856374		844923		866199		899738		892471		885158		931395		911201		924313		931395		967017		935180		947499		969569		990317		956316		973669		1006477		1032589		1014338		1018052		1035899		1064714		1069751		1059029		1083118		1093398		1079509		1104143		1146494		1135803		1133635		1118032		1137365		1167836		1190069		1210536		1216174		1241605		1234655		1284418		1261373		1965222		1982712		1872385		1800642		1782590		1937046		1947163		1922262		1296887		1312222		1329755		1349787		1340705		1381666		1377320		1381666		1381666		1394922		1420707		1429948		1440882		1413029		1451680		1436821		1484946		1463638		1507265		1540087		1543506		1543506		1540087		1552281		1552551		1558168		1577060		1591515		1608017		1621035		1636985		1656991		1817731		1680342		1926832		1911872		1709851		1717760		1719786		1739442		1716544		1845223		1752562		1765685		1997820		2330303		2115375		2526783		2244103		2011816		2036958		2064225		2103434		2115375		2118111		2140554		2131410		2174036		2157788		2399652		2337890		2346091		2241125		2276259		2419493		2319563		2399652		2558215		2381252		2208932		2330303		2549442		2540791		2506832		2506833		2485168		2193944		2442332		2346091		2607433		2330303		2594201		2621767		2470780		2598295		2673123		2641390		2569312		2579486		2706079		2540791		2745087
period_id		157		150		149		156		154		153		158		151		159		155		158		152		None		160		162		163		None		164		163		165		165		164		167		None		166		None		168		169		None		170		None		None		None		None		171		173		172		None		173		None		None		174		175		176		None		None		None		178		177		None		None		None		181		179		None		None		180		181		184		184		183		182		None		185		186		188		187		None		188		190		189		221		222		218		215		214		220		None		220		191		192		193		194		None		196		195		196		196		196		197		None		199		None		199		198		201		200		202		203		204		204		203		204		None		None		204		205		206		207		208		209		216		210		None		219		211		212		None		212		212		217		None		213		223		236		234		243		None		224		225		226		227		228		None		None		228		230		229		238		None		236		233		234		239		235		238		245		237		232		243		244		244		None		None		242		231		240		236		None		243		None		247		241		246		249		248		None		245		250		246		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F690		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F602		F635		F635		F602		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F603		F635		F635		F635		F635		F605		F602		F635		F602		F602		F635		F635		F603		F603		F602		F635		F635		F635		F635		F635		F635		F602		F602		F635		F603		F603		F602		F635		F635		F635		F635		F635		F635		F635		F635		F603		F635		F635		F603		F603		F635		F602		F635		F602		F635		F635		F603		F603		F635		F605		F635		F635		F635		F635		F603		F603		F602		F635		F635		F635		F635		F603		F635		F635		F635		F635		F635		F635		F606		F635		F635		F603		F635		F603		F605		F605		F635		F635		F635		F635		F603		F603		F606		F635		F635		F635		F635		F635		F603		F635		F635		F603		F635
filing_sequence		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		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		0		0		0		2		1		0		0		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		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		1		0		0		0		1		0		0		0		0		0		0		0		0		0		2		0		0		0		0		0		0		0		0		0		1		0
filing_date		1999-04-29 00:00:00		1997-07-29 00:00:00		1997-04-29 00:00:00		1999-01-25 00:00:00		1998-07-31 00:00:00		1998-04-30 00:00:00		1999-07-27 00:00:00		1997-10-30 00:00:00		1999-10-28 00:00:00		1998-10-28 00:00:00		1999-10-29 00:00:00		1998-02-02 00:00:00		2000-04-28 00:00:00		2000-01-28 00:00:00		2000-07-31 00:00:00		2000-10-30 00:00:00		2001-01-16 00:00:00		2001-01-31 00:00:00		2000-10-31 00:00:00		2001-04-30 00:00:00		2001-05-14 00:00:00		2001-01-31 00:00:00		2001-10-31 00:00:00		2001-07-31 00:00:00		2001-07-30 00:00:00		2001-10-31 00:00:00		2002-01-31 00:00:00		2002-04-29 00:00:00		2002-01-31 00:00:00		2002-07-31 00:00:00		2002-04-30 00:00:00		2002-07-31 00:00:00		2002-12-26 00:00:00		2002-10-31 00:00:00		2002-10-31 00:00:00		2003-04-30 00:00:00		2003-01-30 00:00:00		2003-01-31 00:00:00		2003-07-21 00:00:00		2003-07-31 00:00:00		2003-04-30 00:00:00		2003-07-31 00:00:00		2003-10-31 00:00:00		2004-02-02 00:00:00		2003-07-31 00:00:00		2003-10-31 00:00:00		2004-02-02 00:00:00		2004-08-02 00:00:00		2004-04-30 00:00:00		2004-04-30 00:00:00		2004-08-02 00:00:00		2004-11-01 00:00:00		2005-01-04 00:00:00		2004-11-01 00:00:00		2005-01-04 00:00:00		2005-01-31 00:00:00		2005-01-31 00:00:00		2005-04-29 00:00:00		2006-01-30 00:00:00		2005-11-03 00:00:00		2005-10-31 00:00:00		2005-07-31 00:00:00		2005-11-15 00:00:00		2006-05-01 00:00:00		2006-07-30 00:00:00		2006-10-24 00:00:00		2006-10-31 00:00:00		2007-11-07 00:00:00		2007-01-29 00:00:00		2007-07-31 00:00:00		2007-04-30 00:00:00		2015-04-30 00:00:00		2015-07-31 00:00:00		2014-07-31 00:00:00		2013-10-31 00:00:00		2013-07-31 00:00:00		2015-02-02 00:00:00		2014-12-30 00:00:00		2014-12-31 00:00:00		2007-10-31 00:00:00		2008-01-31 00:00:00		2008-04-30 00:00:00		2008-07-30 00:00:00		2008-06-09 00:00:00		2008-11-17 00:00:00		2008-10-30 00:00:00		2008-12-18 00:00:00		2008-11-18 00:00:00		2009-01-30 00:00:00		2009-04-29 00:00:00		2009-07-07 00:00:00		2009-08-06 00:00:00		2008-12-23 00:00:00		2009-10-29 00:00:00		2009-07-30 00:00:00		2010-04-30 00:00:00		2010-01-30 00:00:00		2010-08-02 00:00:00		2010-11-08 00:00:00		2010-11-08 00:00:00		2010-11-18 00:00:00		2010-11-01 00:00:00		2010-12-20 00:00:00		2010-12-20 00:00:00		2010-12-29 00:00:00		2011-02-15 00:00:00		2011-05-02 00:00:00		2011-08-01 00:00:00		2011-10-28 00:00:00		2012-01-31 00:00:00		2012-04-30 00:00:00		2014-01-31 00:00:00		2012-07-31 00:00:00		2014-12-30 00:00:00		2014-10-31 00:00:00		2012-10-31 00:00:00		2012-12-17 00:00:00		2012-12-17 00:00:00		2013-01-31 00:00:00		2012-12-07 00:00:00		2014-04-30 00:00:00		2012-12-28 00:00:00		2013-04-30 00:00:00		2015-11-02 00:00:00		2018-12-28 00:00:00		2018-05-01 00:00:00		2020-10-29 00:00:00		2018-04-30 00:00:00		2016-02-01 00:00:00		2016-04-30 00:00:00		2016-08-01 00:00:00		2016-11-01 00:00:00		2016-12-29 00:00:00		2016-12-30 00:00:00		2017-01-24 00:00:00		2017-01-31 00:00:00		2017-07-28 00:00:00		2017-05-01 00:00:00		2019-07-31 00:00:00		2018-12-21 00:00:00		2019-04-30 00:00:00		2018-04-30 00:00:00		2018-07-31 00:00:00		2019-10-31 00:00:00		2018-10-31 00:00:00		2019-09-12 00:00:00		2021-02-17 00:00:00		2019-04-30 00:00:00		2018-01-30 00:00:00		2020-08-13 00:00:00		2021-01-28 00:00:00		2020-12-30 00:00:00		2020-08-17 00:00:00		2020-08-17 00:00:00		2020-07-31 00:00:00		2017-10-31 00:00:00		2020-01-31 00:00:00		2019-01-30 00:00:00		2021-03-22 00:00:00		2020-08-13 00:00:00		2021-02-19 00:00:00		2021-10-28 00:00:00		2020-04-30 00:00:00		2021-07-28 00:00:00		2022-04-28 00:00:00		2022-01-28 00:00:00		2021-01-04 00:00:00		2021-04-29 00:00:00		2022-08-01 00:00:00		2021-04-06 00:00:00		2022-10-28 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10005		10001		10005		10005		10001		10005		10001		10005		10001		10005		10001		10001		10005		10001		10005		10005		10005		10005		10001		10001		10001		10005		10002		10005		10005		10001		10001		10001		10005		10005		10005		10001		10001		10005		10005		10005		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10002		10002		10001		10001		10005		10001		10005		10001		10001		10001		10001		10001		10002		10001		10002		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10002		10001		10006		10001		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10002		10001		10001		10001		10002		10001		10001		10005		10005		10001		10001		10001		10001		10005		10002		10003		10001		10001		10001		10001		10001		10005		10001		10001		10002		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11003		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11003		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003
session_id		1999		1997		1997		1997		1997		1997		1999		1997		1999		1997		1999		1997		1999		1999		1999		1999		2001		1999		1999		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2001		2003		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2005		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2007		2005		2007		2007		2015		2015		2013		2013		2013		2013		2015		2015		2007		2007		2007		2007		2007		2009		2007		2009		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2011		2011		2011		2009		2011		2011		2011		2011		2011		2013		2011		2015		2013		2011		2013		2013		2011		2013		2013		2013		2013		2015		2019		2017		2019		2017		2015		2015		2015		2015		2017		2017		2017		2015		2017		2017		2019		2019		2017		2017		2017		2019		2017		2019		2021		2019		2017		2019		2019		2021		2019		2019		2019		2017		2019		2017		2021		2019		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		*		JLEHMAN		*		CFLAGG		*		YBONILLA		YBONILLA		*		YBONILLA		*		LTHIBAUL		*		LTHIBAUL		*		*		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		BSMITH		LTHIBAUL		*		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		KLARRY		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		SARRIAGA		LTHIBAUL		COMPLETED		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		GPEREZ		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		SARRIAGA		LTHIBAUL		YRODRIGU		LTHIBAUL		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		ASAETERN		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		LTHIBAUL		LTHIBAUL		LTHIBAUL		YRODRIGU		*		ASAETERN		*		*		ASAETERN		MGUERRA		CFLAGG		*		PBANFORD		MGUERRA		MGUERRA		ASAETERN		MGUERRA		ASAETERN		ASAETERN		*		*		ASAETERN		YRODRIGU		YRODRIGU		SARRIAGA		AGLADNEY		AGLADNEY		AGLADNEY		ASAETERN		ASAETERN		AGLADNEY		ASAETERN		AGLADNEY		GPEREZ		AGLADNEY		AGLADNEY		GKURIMOT		GKURIMOT		AGLADNEY		YRODRIGU		ASAETERN		YRODRIGU		AGLADNEY		JINGRAM		SARRIAGA		YRODRIGU		GTAYLOR		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		PBANFORD		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		GTAYLOR		DMCCASTL		AGLADNEY		AGLADNEY		AGLADNEY		VUKSTINA		AGLADNEY		GTAYLOR		MMERCHANT		AGLADNEY		AGLADNEY		SARRIAGA		CHARTRIDGE		JMENDOZA		SARRIAGA		SARRIAGA		MKIRKHAM		AGLADNEY		GTAYLOR		AGLADNEY		JMENDOZA		SARRIAGA		MMERCHANT		MKIRKHAM		VUKSTINA		MKIRKHAM		CAFILER		CHATRIDGE		JMENDOZA		CHATRIDGE		CAFILER		CAFILER		CAFILER
special_audit		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		11002		11003		11002		11002		11003		11002		11003		11003		11003		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		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		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		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		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		11003		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11003		11001		11003		11001		11003		11003		11003
rpt_start		1999-01-01 00:00:00		1997-04-01 00:00:00		1997-01-01 00:00:00		1998-10-01 00:00:00		1998-04-01 00:00:00		1998-01-01 00:00:00		1999-04-01 00:00:00		1997-07-01 00:00:00		1999-07-01 00:00:00		1998-07-01 00:00:00		1999-04-01 00:00:00		1997-10-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		1900-01-01 00:00:00		2000-10-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2000-10-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		2002-04-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		1900-01-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2003-01-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-04-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		2003-10-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-07-01 00:00:00		2005-01-02 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-10-01 00:00:00		2005-11-03 00:00:00		2005-07-01 00:00:00		2005-04-01 00:00:00		1900-01-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2006-10-24 00:00:00		2006-07-01 00:00:00		1900-01-01 00:00:00		2006-10-01 00:00:00		2007-04-01 00:00:00		2007-01-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2014-04-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2014-10-01 00:00:00		1900-01-01 00:00:00		2014-12-31 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		1900-01-01 00:00:00		2008-11-17 00:00:00		2008-07-01 00:00:00		2008-11-17 00:00:00		2008-11-17 00:00:00		2008-10-01 00:00:00		2009-01-01 00:00:00		1900-01-01 00:00:00		2009-08-06 00:00:00		1900-01-01 00:00:00		2009-07-01 00:00:00		2009-04-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-11-08 00:00:00		2010-11-08 00:00:00		2010-07-01 00:00:00		2010-12-20 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2013-10-01 00:00:00		2012-04-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2012-07-01 00:00:00		2012-12-17 00:00:00		1900-01-01 00:00:00		2012-10-01 00:00:00		2012-12-07 00:00:00		2014-01-01 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2018-12-28 00:00:00		2018-05-01 00:00:00		2020-07-01 00:00:00		1900-01-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		2016-12-29 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-10-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2019-04-01 00:00:00		1900-01-01 00:00:00		2018-10-01 00:00:00		2018-01-01 00:00:00		2018-04-01 00:00:00		2019-07-01 00:00:00		2018-07-01 00:00:00		2019-04-01 00:00:00		2021-02-17 00:00:00		2019-01-01 00:00:00		2017-10-01 00:00:00		2020-08-13 00:00:00		2020-10-01 00:00:00		2020-12-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-04-01 00:00:00		2017-07-01 00:00:00		2019-10-01 00:00:00		2018-10-01 00:00:00		1900-01-01 00:00:00		2020-08-13 00:00:00		1900-01-01 00:00:00		2021-07-01 00:00:00		2020-01-01 00:00:00		2021-04-01 00:00:00		2022-01-01 00:00:00		2021-10-01 00:00:00		1900-01-01 00:00:00		2021-01-01 00:00:00		2022-04-01 00:00:00		2021-04-06 00:00:00		2022-07-01 00:00:00
rpt_end		1999-03-31 00:00:00		1997-06-30 00:00:00		1997-03-31 00:00:00		1998-12-31 00:00:00		1998-06-30 00:00:00		1998-03-31 00:00:00		1999-06-30 00:00:00		1997-09-30 00:00:00		1999-09-30 00:00:00		1998-09-30 00:00:00		1999-06-30 00:00:00		1997-12-31 00:00:00		2000-03-31 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		1900-01-01 00:00:00		2000-12-31 00:00:00		2000-09-30 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		1900-01-01 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2003-03-31 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-03-31 00:00:00		2003-03-31 00:00:00		2003-06-30 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		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2005-01-02 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2005-12-31 00:00:00		2005-11-03 00:00:00		2005-09-30 00:00:00		2005-06-30 00:00:00		1900-01-01 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2006-10-24 00:00:00		2006-09-30 00:00:00		1900-01-01 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-03-31 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2014-12-31 00:00:00		1900-01-01 00:00:00		2014-12-31 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		1900-01-01 00:00:00		2008-11-17 00:00:00		2008-09-30 00:00:00		2008-11-17 00:00:00		2008-11-17 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		1900-01-01 00:00:00		2009-08-06 00:00:00		1900-01-01 00:00:00		2009-09-30 00:00:00		2009-06-30 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-11-08 00:00:00		2010-11-08 00:00:00		2010-09-30 00:00:00		2010-12-20 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2012-09-30 00:00:00		2012-12-17 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2012-12-07 00:00:00		2014-03-31 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2018-12-28 00:00:00		2018-05-01 00:00:00		2020-09-30 00:00:00		1900-01-01 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		2016-12-29 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2019-06-30 00:00:00		1900-01-01 00:00:00		2018-12-31 00:00:00		2018-03-31 00:00:00		2018-06-30 00:00:00		2019-09-30 00:00:00		2018-09-30 00:00:00		2019-06-30 00:00:00		2021-02-17 00:00:00		2019-03-31 00:00:00		2017-12-31 00:00:00		2020-08-13 00:00:00		2020-12-31 00:00:00		2020-12-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-06-30 00:00:00		2017-09-30 00:00:00		2019-12-31 00:00:00		2018-12-31 00:00:00		1900-01-01 00:00:00		2020-08-13 00:00:00		1900-01-01 00:00:00		2021-09-30 00:00:00		2020-03-31 00:00:00		2021-06-30 00:00:00		2022-03-31 00:00:00		2021-12-31 00:00:00		1900-01-01 00:00:00		2021-03-31 00:00:00		2022-06-30 00:00:00		2021-04-06 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		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		22001		22001		None		22001		None		None		22001		22001		22001		None		None		None		22001		22001		None		None		None		22001		22001		None		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		None		22001		22006		22001		22001		22006		22006		None		22006		None		22006		22006		22006		22006		22006		22006		22001		22001		22006		22006		None		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		None		22006		22006		22006		None		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		None		None		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		None		22006		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		None		22006		22006		22006		22006

Table: filer_interests

filer_id		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670
session_id		1999		1997		2001		2003		2007		2005		2011		2009		2013		2009		2021		2015		2017		2019		2023		2021
interest_cd		40301		40301		40301		40301		40312		40301		40319		40312		40319		40319		40319		40319		40319		40319		40319		40319
effect_date		1999-01-01 00:00:00		1997-01-01 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2007-01-01 00:00:00		2005-01-01 00:00:00		2011-01-01 00:00:00		2009-01-01 00:00:00		2013-01-01 00:00:00		2009-07-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00		2021-03-15 00:00:00

Table: filer_to_filer_type

filer_id		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670
filer_type		1		1		1		1		1		1		2		2		2		2		2		2		2		2		2		2
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		T		Y		Y		N
race		0		0		0		None		None		None		None		None		None		None		None		None		None		None		None		None
session_id		1999		1997		2001		2003		2005		2007		2011		2013		2009		2017		2021		2015		2021		2021		2019		2023
category		0		0		0		None		None		None		None		None		None		None		None		None		None		None		None		None
category_type		0		0		0		None		None		None		None		None		None		None		None		None		None		None		None		None
sub_category		0		0		0		None		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		1999-01-01 00:00:00		1997-01-01 00:00:00		2001-01-01 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		2017-01-01 00:00:00		2021-03-15 00:00:00		2015-01-01 00:00:00		2021-02-12 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		None		None		None		None		None		None		None		None		None		None		None		None		None
election_type		0		0		0		None		None		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
nyq_dt		None		None		None		None		2000-07-01 00:00:00		2000-07-01 00:00:00		None		None		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
county_cd		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

Table: filer_xref

filer_id		1145670
xref_id		C27182
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182		C27182
filer_id		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670
filer_type		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER
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
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
naml		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
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
zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
phon		9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333				9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333				9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333				9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333				9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333				9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333				9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333				9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333				9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333				9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333				9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333				9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333				9164482333		9164482333		9164482333		9164428333		9164428333		9164428333		9164428333		9164428333		9164428333				9164428333				9164428333				9164428333				9164428333
fax		9164424035								9164424035		9164424035																										9164424035								9164424035		9164424035																										9164424035								9164424035		9164424035																										9164424035								9164424035		9164424035																										9164424035								9164424035		9164424035																										9164424035								9164424035		9164424035																										9164424035								9164424035		9164424035																										9164424035								9164424035		9164424035																										9164424035								9164424035		9164424035																										9164424035								9164424035		9164424035																										9164424035								9164424035		9164424035																										9164424035								9164424035		9164424035																										9164424035								9164424035		9164424035
email		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None

Table: filers

filer_id		1145670

Table: lobbying_chg_log

filer_id		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670
change_no		1		2		11		8		6		5		4		10		9		7		3		13		0		12		14		15
session_id		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2005		2005		2005		2009		2017
log_dt		2000-11-28 00:00:00		2000-11-28 00:00:00		2001-04-12 00:00:00		2001-04-12 00:00:00		2001-04-12 00:00:00		2001-04-12 00:00:00		2001-04-12 00:00:00		2001-04-12 00:00:00		2001-04-12 00:00:00		2001-04-12 00:00:00		2001-04-12 00:00:00		2005-12-09 00:00:00		2005-11-15 00:00:00		2005-11-15 00:00:00		2009-07-07 00:00:00		2018-01-04 00:00:00
filer_type		1		1		1		1		1		1		1		1		1		1		1		1		1		1		2		2
correction_flg		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Y		Y
action		SET ACTIVE		SET ACTIVE		IN SUSPENSE		IN SUSPENSE		IN SUSPENSE		IN SUSPENSE		IN SUSPENSE		IN SUSPENSE		IN SUSPENSE		IN SUSPENSE		IN SUSPENSE		DELETED		ADDED		IN SUSPENSE		ADDED		DELETED
attribute_changed		CLIENT		CLIENT		EMPLOYER		EMPLOYER		CLIENT		EMPLOYER		CLIENT		EMPLOYER		CLIENT		CLIENT		LOBBYIST		FIRM		FIRM		FIRM		LOBBYIST		FIRM
ethics_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_full_name		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION		NORTHERN CALIFORNIA WATER ASSOCIATION
filer_city		Trona		Los Angeles		SACRAMENTO		SACRAMENTO		CYPRESS		Sacramento		Sacramento		SACRAMENTO		SACRAMENTO		Roseville		None		None		None		None		SACRAMENTO		None
filer_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		None		None		None		None		CA		None
filer_zip		93592		90007		95814		95814		90630		95814		95814		95814		95814		95661		None		None		None		None		95814		None
filer_phone		7603722042		2137633346		9164475793		9164446670		7142263582		9164467100		9164482162		9164475793		9164467100		9167743381		None		None		None		None		9164482333		None
entity_type		3		3		3		3		3		3		3		3		3		3		3		3		3		3		4		3
entity_name		KAHL/POWNALL ADVOCATES		KAHL/POWNALL ADVOCATES		KAHL/POWNALL ADVOCATES		KAHL/POWNALL ADVOCATES		KAHL/POWNALL ADVOCATES		KAHL/POWNALL ADVOCATES		KAHL/POWNALL ADVOCATES		KAHL/POWNALL ADVOCATES		KAHL/POWNALL ADVOCATES		KAHL/POWNALL ADVOCATES		KAHL/POWNALL ADVOCATES		KAHL/POWNALL ADVOCATES		DUNLAP, VAN VLECK & BROWN, LLC		DUNLAP, VAN VLECK & BROWN, LLC		MANLEY, TODD N.		DI MARE, BROWN, HICKS & KESSLER, LLC
entity_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_id		1147235		1147235		1147235		1147235		1147235		1147235		1147235		1147235		1147235		1147235		1147235		1147235		1276403		1276403		None		1276403
responsible_officer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		None		None		None		None		None		None		None		None		None		None		None		2005-12-06 00:00:00		2005-11-01 00:00:00		2005-11-01 00:00:00		2009-07-01 00:00:00		2017-12-31 00:00:00

Table: received_filings

filer_id		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670		1145670
filing_file_name		681122_0.cal		718358_0.cal		751497_0.cal		772271_0.cal		791630_0.cal		813684_0.cal		838855_0.cal		856374_0.cal		885158_0.cal		911201_0.cal		931395_1.cal		947499_0.cal		931395_0.cal		969569_0.cal		1069751_0.cal		1381666_0.cal		1381666_1.cal		1381666_2.cal
received_date		2000-10-30 00:00:00		2001-01-31 00:00:00		2001-05-14 00:00:00		2001-07-30 00:00:00		2001-10-31 00:00:00		2002-01-31 00:00:00		2002-04-29 00:00:00		2002-07-31 00:00:00		2002-10-31 00:00:00		2003-01-30 00:00:00		2003-07-21 00:00:00		2003-07-31 00:00:00		2003-04-30 00:00:00		2003-10-31 00:00:00		2005-01-04 00:00:00		2008-11-17 00:00:00		2008-11-18 00:00:00		2008-12-18 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		/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		681122		718358		751497		772271		791630		813684		838855		856374		885158		911201		931395		947499		931395		969569		1069751		1381666		1381666		1381666
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F602		F602
receive_comment		Filing accepted, but with warnings		Filing accepted		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