Home

Filer ID: 1064902

Table: filer_address

filer_id		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902
adrid		1072849		1072850		2014266		2013892		2188330		2181335		2286820		2290434		2290433
effect_dt		1995-04-12 00:00:00		1995-04-12 00:00:00		2001-03-30 00:00:00		2001-02-13 00:00:00		2010-04-21 00:00:00		2010-03-08 00:00:00		2013-01-31 00:00:00		2013-06-12 00:00:00		2013-06-12 00:00:00
add_type		7051		7051		7082		7051		7082		7082		7082		7082		7051
session_id		1995		1995		2001		2001		2009		2009		2013		2013		2013

Table: filer_filings

filer_id		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902
filing_id		680207		382504		382505		382506		382507		382508		382509		382510		382511		382512		382513		382514		382516		382517		382518		382519		382520		382521		382522		382523		382524		382526		382527		382528		382529		382530		441568		441569		441570		441571		382515		382525		592060		581707		609621		609623		589313		609712		601674		603150		613514		676874		643630		669299		646002		672059		683512		718310		722199		683286		737103		733248		782602		772677		772677		718310		669299		676874		643630		592060		722199		782602		592060		646002		786241		786764		672059		680207		722199		718310		782602		805092		805970		805092		824651		805970		828269		825508		822525		858016		855182		822525		855182		871820		877630		879104		858016		825508		872277		931414		911123		915687		935022		931414		947095		963351		964823		950635		935022		982279		979667		998604		985315		996389		984544		1030776		1031641		1046313		1045064		1050415		1052142		1052221		1060325		1079072		1085410		1119612		1117596		1147015		1153134		1156784		1158775		1175416		1175487		1173784		1190762		1193975		1177419		1204191		1205376		1215506		1218157		1218809		1204191		1212039		1205376		1214632		1219788		1216847		1235067		1239469		1273850		1273458		1266831		1270155		1271119		1283876		1286055		1271041		1300828		1301009		1385141		1771641		1782456		1786127		1789367		1982539		1947705		1871371		1853998		1855305		1854602		1961466		1936347		1910909		1911194		1893842		1898647		1903947		1888543		1319820		1309788		1312597		1320079		1349547		1338841		1333774		1335318		1334251		1334590		1336344		1338450		1363236		1370855		1352383		1335275		1369782		1362568		1369303		1368238		1385141		1385141		1385676		1363236		1362568		1394579		1398229		1421761		1420821		1436756		1440107		1467968		1385141		1483081		1385141		1463808		1495297		1385141		1472607		1494074		1496410		1494227		1510242		1491444		1507923		1493389		1493563		1510242		1533264		1507923		1523380		1531865		1567055		1570332		1521887		1541832		1544089		1603739		1604307		1634539		1638058		1647833		1647298		1666681		1663815		1664779		1823154		1832120		1805379		1833344		1817417		1695774		1678816		1695226		1681732		1681732		1666681		1678816		1703456		1663815		1701856		1710659		1892495		1874960		1884677		1739015		1385141		1846999		1837402		1744802		1756935		1987733		2297763		2290299		2296575		2446577		2338107		2217434		2493279		2458218		2278002		2325766		2520418		2236695		2377685		2223311		2020172		2023775		2012230		2040018		2025174		2034329		2036005		2052163		2047560		2046659		2049440		2064688		2076529		2081536		2082872		2070037		2103376		2093308		2096294		2097948		2108874		2146998		2130322		2176309		2178182		2312315		2501492		2322289		2454645		2274914		2282153		2496752		2359786		2484380		2439386		2348780		2523960		2508706		2195663		2259762		2237122		2575408		2403700		2210215		2583712		2533943		2303406		2433328		2473869		2504942		2297524		2534079		2488338		2379217		1385141		2393837		2548772		2599802		2692241		2446015		2617763		2626660		2680317		2689236		2703008		2720840		2725230		2621914		2682216		2656757		2640498		2686360		2671414		2657016		2743305		2740377		2726909
period_id		None		142		143		144		145		145		146		145		147		148		148		148		149		150		151		151		152		153		154		154		153		156		156		141		141		157		143		154		156		159		148		156		None		None		161		161		None		161		None		None		None		164		161		163		None		None		None		164		None		164		None		None		None		165		165		164		163		164		161		161		None		None		None		None		167		None		None		None		None		164		None		168		None		168		169		None		None		None		169		None		169		169		169		171		172		None		None		None		None		173		172		None		None		173		174		175		None		None		None		None		176		None		None		177		177		None		177		None		179		180		None		180		None		180		None		None		181		183		None		185		None		None		186		185		186		None		186		187		None		188		188		188		187		188		None		None		188		188		188		None		None		None		None		None		None		189		None		None		192		None		214		None		213		None		215		221		None		218		217		218		None		222		220		None		220		None		220		220		219		193		191		None		None		194		None		194		194		None		193		None		194		None		None		None		None		None		195		196		196		196		196		None		None		195		196		None		None		197		198		None		None		201		None		202		199		None		202		None		None		None		202		None		201		202		None		202		None		204		202		None		204		204		None		203		None		None		205		None		207		None		None		209		None		209		210		None		217		216		None		215		None		210		211		None		None		None		210		212		209		212		None		219		None		219		212		213		218		218		None		None		None		None		235		235		241		237		None		243		None		None		None		243		233		237		233		225		None		223		226		225		225		None		None		226		226		226		226		None		227		227		227		228		228		None		227		None		None		228		229		None		235		243		236		241		234		235		243		None		241		239		236		244		244		232		234		None		None		None		231		246		None		236		241		None		243		235		None		None		None		242		238		244		245		None		None		None		None		None		250		250		251		251		247		250		249		248		250		249		None		None		252		None
form_id		F460		F410		F405		F420		F420		F420		F405		F420		F420		F497		F420		F497		F420		F420		F405		F420		F420		F420		F405		F497		F420		F420		F497		F666		F666		F420		F420		F420		F420		F420		F420		F420		F460		F460		F497		F497		F460		F497		F497		F497		F410		F460		F460		F460		F460		F460		F497		F460		F460		F497		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F497		F460		F460		F497		F497		F497		F460		F460		F460		F460		F497		F497		F460		F460		F497		F497		F497		F497		F497		F460		F460		F497		F497		F497		F410		F410		F460		F460		F497		F460		F460		F460		F460		F497		F460		F497		F460		F460		F497		F460		F497		F460		F497		F460		F460		F460		F460		F460		F497		F497		F497		F497		F460		F497		F497		F460		F460		F460		F460		F497		F460		F460		F497		F410		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F410		F410		F460		F497		F410		F410		F497		F410		F497		F460		F460		F460		F460		F497		F460		F497		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F497		F460		F410		F497		F497		F460		F410		F460		F460		F497		F460		F497		F497		F460		F497		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F497		F497		F460		F460		F460		F497		F460		F497		F460		F460		F497		F460		F497		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F497		F497		F460		F460		F460		F460		F497		F497		F497		F497		F460		F460		F460		F460		F497		F460		F497		F497		F410		F460		F497		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F497		F460		F460		F497		F497		F460		F460		F460		F460		F460		F497		F460
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		2		1		1		1		1		1		1		2		1		0		0		1		1		2		1		2		0		0		1		0		1		0		0		0		0		0		1		1		0		0		0		1		1		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		1		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		6		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		1		0		0		0		0		0		0		0		2		0		3		0		0		4		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		0		1		1		1		0		1		0		0		0		0		0		0		5		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		7		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2000-10-27 00:00:00		1995-04-12 00:00:00		1995-08-17 00:00:00		1996-01-31 00:00:00		1996-02-15 00:00:00		1996-03-11 00:00:00		1996-05-17 00:00:00		1996-07-30 00:00:00		1996-10-07 00:00:00		1996-10-22 00:00:00		1996-10-24 00:00:00		1996-10-24 00:00:00		1997-04-30 00:00:00		1997-07-31 00:00:00		1997-11-03 00:00:00		1997-10-31 00:00:00		1998-02-02 00:00:00		1998-03-23 00:00:00		1998-04-17 00:00:00		1998-05-19 00:00:00		1998-05-21 00:00:00		1998-10-22 00:00:00		1998-10-29 00:00:00		1999-01-29 00:00:00		1999-01-29 00:00:00		1999-07-26 00:00:00		1995-10-31 00:00:00		1998-07-31 00:00:00		1999-02-01 00:00:00		1999-10-12 00:00:00		1997-01-30 00:00:00		1998-10-22 00:00:00		2000-02-24 00:00:00		2000-01-10 00:00:00		2000-03-13 00:00:00		2000-03-13 00:00:00		2000-01-27 00:00:00		2000-03-13 00:00:00		2000-03-01 00:00:00		2000-03-01 00:00:00		2000-01-26 00:00:00		2000-10-26 00:00:00		2000-07-28 00:00:00		2000-10-05 00:00:00		2000-07-31 00:00:00		2000-10-05 00:00:00		2000-11-01 00:00:00		2001-01-31 00:00:00		2001-01-31 00:00:00		2000-11-01 00:00:00		2001-03-30 00:00:00		2001-02-13 00:00:00		2001-07-31 00:00:00		2001-07-31 00:00:00		2001-09-21 00:00:00		2001-09-21 00:00:00		2001-09-21 00:00:00		2001-09-21 00:00:00		2001-09-21 00:00:00		2001-09-21 00:00:00		2001-07-31 00:00:00		2001-09-12 00:00:00		2001-09-19 00:00:00		2001-09-19 00:00:00		2001-10-10 00:00:00		2001-10-10 00:00:00		2001-09-19 00:00:00		2001-09-19 00:00:00		2001-09-19 00:00:00		2001-07-31 00:00:00		2001-09-19 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-02-01 00:00:00		2002-02-22 00:00:00		2002-01-31 00:00:00		2002-02-22 00:00:00		2002-02-21 00:00:00		2002-02-21 00:00:00		2002-07-31 00:00:00		2002-07-30 00:00:00		2002-10-07 00:00:00		2002-10-07 00:00:00		2002-10-07 00:00:00		2002-10-24 00:00:00		2002-10-24 00:00:00		2002-10-07 00:00:00		2002-10-07 00:00:00		2002-10-07 00:00:00		2003-04-30 00:00:00		2003-01-30 00:00:00		2003-01-31 00:00:00		2003-04-30 00:00:00		2003-07-31 00:00:00		2003-07-31 00:00:00		2003-10-10 00:00:00		2003-10-10 00:00:00		2003-07-31 00:00:00		2003-07-31 00:00:00		2004-01-12 00:00:00		2004-01-12 00:00:00		2004-02-19 00:00:00		2004-01-22 00:00:00		2004-02-19 00:00:00		2004-01-22 00:00:00		2004-07-30 00:00:00		2004-08-02 00:00:00		2004-10-05 00:00:00		2004-10-05 00:00:00		2004-10-21 00:00:00		2004-10-21 00:00:00		2004-10-22 00:00:00		2004-10-22 00:00:00		2005-01-29 00:00:00		2005-01-31 00:00:00		2005-08-01 00:00:00		2005-07-29 00:00:00		2006-01-30 00:00:00		2006-01-31 00:00:00		2006-03-21 00:00:00		2006-03-22 00:00:00		2006-05-25 00:00:00		2006-05-26 00:00:00		2006-05-25 00:00:00		2006-07-31 00:00:00		2006-07-31 00:00:00		2006-05-31 00:00:00		2006-10-05 00:00:00		2006-10-05 00:00:00		2006-10-30 00:00:00		2006-11-01 00:00:00		2006-11-02 00:00:00		2006-10-26 00:00:00		2006-10-26 00:00:00		2006-10-26 00:00:00		2006-10-26 00:00:00		2006-11-03 00:00:00		2006-10-31 00:00:00		2007-01-30 00:00:00		2007-01-31 00:00:00		2006-11-02 00:00:00		2006-11-03 00:00:00		2006-10-30 00:00:00		2006-11-01 00:00:00		2006-05-31 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2006-10-31 00:00:00		2007-12-07 00:00:00		2007-12-10 00:00:00		2013-06-12 00:00:00		2013-06-12 00:00:00		2013-07-31 00:00:00		2013-07-31 00:00:00		2013-08-28 00:00:00		2015-07-31 00:00:00		2015-02-02 00:00:00		2014-07-31 00:00:00		2014-05-22 00:00:00		2014-05-27 00:00:00		2014-05-22 00:00:00		2015-04-24 00:00:00		2015-02-02 00:00:00		2014-10-23 00:00:00		2014-10-31 00:00:00		2014-10-06 00:00:00		2014-10-15 00:00:00		2014-10-23 00:00:00		2014-09-25 00:00:00		2008-03-24 00:00:00		2008-01-30 00:00:00		2008-01-31 00:00:00		2008-03-24 00:00:00		2008-07-30 00:00:00		2008-05-29 00:00:00		2008-05-20 00:00:00		2008-05-22 00:00:00		2008-05-20 00:00:00		2008-05-22 00:00:00		2008-05-22 00:00:00		2008-05-29 00:00:00		2008-10-06 00:00:00		2008-10-23 00:00:00		2008-07-31 00:00:00		2008-05-22 00:00:00		2008-10-21 00:00:00		2008-10-06 00:00:00		2008-10-23 00:00:00		2008-10-21 00:00:00		2008-12-23 00:00:00		2008-12-23 00:00:00		2008-12-23 00:00:00		2008-10-16 00:00:00		2008-10-16 00:00:00		2009-01-29 00:00:00		2009-02-02 00:00:00		2009-04-30 00:00:00		2009-04-30 00:00:00		2009-07-30 00:00:00		2009-07-31 00:00:00		2010-02-01 00:00:00		2010-03-11 00:00:00		2010-04-21 00:00:00		2010-04-21 00:00:00		2010-01-30 00:00:00		2010-06-02 00:00:00		2010-05-27 00:00:00		2010-03-09 00:00:00		2010-06-01 00:00:00		2010-05-27 00:00:00		2010-06-02 00:00:00		2010-08-02 00:00:00		2010-05-27 00:00:00		2010-08-02 00:00:00		2010-05-27 00:00:00		2010-06-01 00:00:00		2010-10-08 00:00:00		2010-10-23 00:00:00		2010-10-08 00:00:00		2010-10-04 00:00:00		2010-10-21 00:00:00		2011-01-26 00:00:00		2011-01-26 00:00:00		2010-10-04 00:00:00		2010-10-23 00:00:00		2010-10-21 00:00:00		2011-07-26 00:00:00		2011-07-26 00:00:00		2012-01-30 00:00:00		2012-01-30 00:00:00		2012-03-22 00:00:00		2012-03-22 00:00:00		2012-05-24 00:00:00		2012-05-24 00:00:00		2012-05-25 00:00:00		2014-01-31 00:00:00		2014-03-24 00:00:00		2013-11-22 00:00:00		2014-03-24 00:00:00		2014-01-31 00:00:00		2012-10-05 00:00:00		2012-07-31 00:00:00		2012-10-05 00:00:00		2012-07-31 00:00:00		2012-10-26 00:00:00		2012-10-26 00:00:00		2012-10-25 00:00:00		2012-10-25 00:00:00		2012-10-25 00:00:00		2012-10-23 00:00:00		2012-10-25 00:00:00		2014-10-06 00:00:00		2014-07-31 00:00:00		2014-09-11 00:00:00		2013-01-31 00:00:00		2013-01-31 00:00:00		2014-05-02 00:00:00		2014-04-09 00:00:00		2013-01-31 00:00:00		2013-01-31 00:00:00		2015-07-31 00:00:00		2018-09-27 00:00:00		2018-09-10 00:00:00		2018-09-27 00:00:00		2020-02-05 00:00:00		2019-01-23 00:00:00		2018-01-31 00:00:00		2020-08-20 00:00:00		2020-02-20 00:00:00		2018-07-31 00:00:00		2018-10-25 00:00:00		2020-10-22 00:00:00		2018-04-26 00:00:00		2019-04-26 00:00:00		2018-03-19 00:00:00		2016-03-11 00:00:00		2016-02-01 00:00:00		2016-02-01 00:00:00		2016-05-05 00:00:00		2016-03-31 00:00:00		2016-04-28 00:00:00		2016-04-28 00:00:00		2016-05-26 00:00:00		2016-05-27 00:00:00		2016-05-26 00:00:00		2016-06-03 00:00:00		2016-08-01 00:00:00		2016-08-01 00:00:00		2016-09-26 00:00:00		2016-09-29 00:00:00		2016-08-18 00:00:00		2016-11-01 00:00:00		2016-10-21 00:00:00		2016-09-29 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2018-10-25 00:00:00		2020-09-15 00:00:00		2018-11-02 00:00:00		2020-02-20 00:00:00		2018-07-31 00:00:00		2018-08-10 00:00:00		2020-08-31 00:00:00		2019-01-31 00:00:00		2020-07-30 00:00:00		2020-01-30 00:00:00		2019-01-31 00:00:00		2020-10-27 00:00:00		2020-10-02 00:00:00		2017-11-08 00:00:00		2018-06-05 00:00:00		2018-04-26 00:00:00		2021-01-29 00:00:00		2019-07-26 00:00:00		2018-01-31 00:00:00		2021-05-11 00:00:00		2020-09-24 00:00:00		2018-10-08 00:00:00		2020-01-22 00:00:00		2020-05-06 00:00:00		2020-09-24 00:00:00		2018-09-28 00:00:00		2020-10-22 00:00:00		2020-07-31 00:00:00		2019-04-26 00:00:00		2020-05-04 00:00:00		2019-07-26 00:00:00		2021-01-28 00:00:00		2021-07-29 00:00:00		2022-05-26 00:00:00		2020-01-30 00:00:00		2021-07-30 00:00:00		2021-10-29 00:00:00		2022-04-28 00:00:00		2022-06-01 00:00:00		2022-07-28 00:00:00		2022-09-16 00:00:00		2022-09-29 00:00:00		2021-10-29 00:00:00		2022-05-13 00:00:00		2022-03-11 00:00:00		2022-01-28 00:00:00		2022-05-26 00:00:00		2022-04-27 00:00:00		2022-01-28 00:00:00		2022-09-29 00:00:00		2022-10-25 00:00:00		2022-07-29 00:00:00
stmnt_type		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10001		10005		10001		10005		10005		10002		10001		10001		10001		10005		10005		10001		10001		10005		10001		10002		10002		10005		10001		10002		10002		10002		10002		10002		10002		10006		10006		10006		10006		10001		10005		10006		10006		10006		10002		10006		10001		10005		10002		10001		10006		10005		10005		10001		10005		10001		10002		10002		10001		10001		10005		10006		10006		10005		10001		10001		10005		10005		10002		10001		10001		10005		10005		10006		10005		10001		10005		10005		10001		10001		10005		10001		10005		10001		10001		10005		10001		10005		10001		10005		10005		10001		10001		10005		10001		10005		10005		10001		10001		10001		10005		10001		10001		10005		10001		10001		10001		10002		10001		10006		10005		10001		10001		10001		10005		10005		10005		10005		10005		10005		10001		10005		10005		10001		10005		10002		10006		10001		10005		10001		10001		10005		10001		10001		10001		10005		10001		10001		10005		10001		10005		10001		10001		10001		10001		10001		10005		10005		10001		10005		10001		10001		10005		10001		10005		10001		10005		10005		10005		10005		10005		10001		10001		10001		10001		10002		10006		10006		10002		10001		10005		10005		10001		10001		10005		10005		10002		10006		10002		10001		10005		10002		10006		10005		10006		10001		10005		10001		10001		10005		10001		10006		10001		10002		10005		10001		10001		10005		10001		10005		10005		10001		10005		10001		10005		10005		10001		10005		10001		10001		10005		10001		10001		10005		10001		10005		10001		10001		10005		10006		10006		10002		10001		10002		10001		10005		10001		10005		10001		10001		10002		10001		10001		10005		10002		10005		10005		10001		10001		10001		10001		10005		10001		10005		10005		10005		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10005		10001		10005		10005		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10001		10005		10001		10001		10006		10001		10001		10005		10005		10005		10002		10001		10001		10001		10005		10005		10005		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10005
stmnt_status		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		11003		11003		11001		11003		11001		11001		11001		11003		11003		11003		11001		11003		11001		11003		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11001		11003		11003		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		11001		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11001		11003		11001		11001		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11001		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		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		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11003		11001		11003		11003		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11003		11001		11003		11001		11001		11003		11003		11003
session_id		1999		1995		1995		1995		1995		1995		1995		1995		1995		1995		1995		1995		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1995		1995		1999		1995		1997		1997		1999		1995		1997		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		1999		1999		1999		1999		1999		1999		2001		1999		1999		2001		2001		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2005		2005		2005		2007		2007		2005		2007		2007		2013		2013		2013		2013		2013		2015		2013		2013		2013		2013		2013		2015		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2013		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2011		2013		2013		2013		2011		2013		2015		2017		2017		2017		2019		2019		2017		2019		2019		2017		2017		2019		2017		2019		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2019		2017		2019		2017		2017		2019		2017		2019		2019		2017		2019		2019		2017		2017		2017		2019		2019		2017		2021		2019		2017		2019		2019		2019		2017		2019		2019		2019		2019		2019		2019		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		KCHAN		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		KCHAN		SARRIAGA		*		TWALLS		*		TTHAM		TTHAM		SARRIAGA		*		*		*		*		*		*		*		SARRIAGA		LTHIBAUL		CFLAGG		CFLAGG		*		GPEREZ		CFLAGG		CFLAGG		CFLAGG		*		CFLAGG		*		GPEREZ		*		*		GPEREZ		RALLMOND		DBARRICK		*		DBARRICK		*		*		*		*		*		DBARRICK		DBARRICK		DBARRICK		DBARRICK		COMPLETED		COMPLETED		DBARRICK		DBARRICK		COMPLETED		COMPLETED		COMPLETED		KVOONG1		GGILMORE		GGILMORE		MHOANG		COMPLETED		JMARTIN		GGILMORE		COMPLETED		COMPLETED		TTHAM		COMPLETED		GPEREZ		COMPLETED		COMPLETED		SARRIAGA		PBANFORD		EMCENTEE		COMPLETED		CFLAGG		SARRIAGA		*		*		SARRIAGA		*		CFLAGG		CFLAGG		*		*		*		SARRIAGA		LHOANG		*		GPEREZ		DHORRELL		LHOANG		DHORRELL		*		*		LHOANG		SARRIAGA		DHORRELL		LHOANG		*		CFLAGG		DHORRELL		DHORRELL		LHOANG		LHOANG		LHOANG		*		GPEREZ		LHOANG		*		DHORRELL		TRAMON		JINGRAM		SARRIAGA		SARRIAGA		WBROWN		CAFILER		GCLARA		CAFILER		MDIGRAZIA		WBROWN		MDIGRAZIA		WBROWN		CAFILER		MPACHECO		WBROWN		JINGRAM		WBROWN		CAFILER		WBROWN		*		*		CFLAGG		SARRIAGA		CPON		LHOANG		PBANFORD		DHORRELL		LHOANG		*		LHOANG		DHORRELL		RGEREMIA		RGEREMIA		CPON		SARRIAGA		YRODRIGU		*		*		DHORRELL		*		*		RGEREMIA		RGEREMIA		*		*		JVAZQUEZ		SARRIAGA		*		*		SARRIAGA		SARRIAGA		*		RGEREMIA		*		*		DHORRELL		*		RGEREMIA		DHORRELL		RGEREMIA		DHORRELL		MMORENO		CPON		MMORENO		CPON		PBANFORD		MPACHECO		CREYNOLDS		MMORENO		CPON		SMCCONNAN		SMCCONNAN		SMCCONNAN		CPON		GKURIMOT		SMCCONNAN		CPON		CPON		CPON		CPON		CPON		CPON		CPON		CPON		PBANFORD		MPACHECO		MDIGRAZIA		WBROWN		MDIGRAZIA		MDIGRAZIA		MPACHECO		CAFILER		CAFILER		MPACHECO		MPACHECO		MPACHECO		CAFILER		SARRIAGA		CAFILER		WBROWN		SARRIAGA		CAFILER		SMCCONNAN		WBROWN		CAFILER		TRAMON		WBROWN		WBROWN		MPACHECO		TRAMON		SARRIAGA		LBARTHOL		CAFILER		LBARTHOL		CAFILER		CAFILER		HSTOVALL		CAFILER		SUSHAKOV		CSAGABAEN		CSAGABAEN		IMEDINA		CSAGABAEN		YMORA		CAFILER		KBANH		SARRIAGA		CAFILER		KBANH		KBANH		SARRIAGA		SARRIAGA		SMCCONNAN		KBANH		SMCCONNAN		KBANH		SARRIAGA		SARRIAGA		RGEREMIA		GPEREZ		PDEO		PDEO		PDEO		GPEREZ		BSINGH		BSINGH		SARRIAGA		SARRIAGA		BSINGH		BSINGH		CSAGABAEN		CAFILER		CAFILER		SUSHAKOV		CSAGABAEN		CAFILER		CAFILER		LPHEAV		IMEDINA		SUSHAKOV		LPHEAV		CAFILER		CAFILER		PBANFORD		CAFILER		CSAGABAEN		BCOLON		LPHEAV		HSTOVALL		CAFILER		IMEDINA		CAFILER		CAFILER		TRAMON		IMEDINA		CAFILER		IMEDINA		IMEDINA		YMORA		TRAMON		LPHEAV		BCOLON		DCODY		JMAVES		SUSHAKOV		DCODY		KRUSSELL		KRUSSELL		CAFILER		CAFILER		CAFILER		CAFILER		KRUSSELL		CAFILER		CAFILER		KRUSSELL		CAFILER		KRUSSELL		KRUSSELL		LPHEAV		CAFILER		JMAVES
special_audit		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11001		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11001		11003		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		2000-10-01 00:00:00		None		None		1995-10-01 00:00:00		1996-01-01 00:00:00		1996-02-11 00:00:00		None		1996-03-10 00:00:00		1996-07-01 00:00:00		None		1996-10-01 00:00:00		None		1997-01-01 00:00:00		1997-04-01 00:00:00		1997-07-01 00:00:00		1997-07-01 00:00:00		1997-10-01 00:00:00		1998-01-01 00:00:00		None		None		1998-03-18 00:00:00		1998-10-01 00:00:00		None		1995-01-01 00:00:00		1995-01-01 00:00:00		1999-01-01 00:00:00		1995-07-01 00:00:00		1998-05-17 00:00:00		1998-10-18 00:00:00		1999-07-01 00:00:00		1996-10-20 00:00:00		1998-10-21 00:00:00		2000-01-23 00:00:00		1999-10-01 00:00:00		2000-03-01 00:00:00		2000-03-01 00:00:00		2000-01-01 00:00:00		2000-03-01 00:00:00		None		None		None		2000-10-01 00:00:00		2000-02-20 00:00:00		2000-07-01 00:00:00		2000-02-20 00:00:00		2000-07-01 00:00:00		None		2000-10-22 00:00:00		2000-10-22 00:00:00		2000-11-01 00:00:00		1997-10-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2000-10-22 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		2000-02-20 00:00:00		2000-01-23 00:00:00		2000-10-22 00:00:00		2001-01-01 00:00:00		2000-01-23 00:00:00		2000-02-20 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		2000-10-22 00:00:00		2000-10-22 00:00:00		2001-01-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-02-22 00:00:00		2001-10-01 00:00:00		None		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-02-17 00:00:00		2002-02-17 00:00:00		2002-01-01 00:00:00		2002-02-17 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2002-02-17 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2003-01-01 00:00:00		2002-10-20 00:00:00		2002-10-20 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-07-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2004-01-18 00:00:00		2004-01-01 00:00:00		2004-01-18 00:00:00		2004-01-01 00:00:00		2004-02-15 00:00:00		2004-02-15 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2004-10-22 00:00:00		None		2004-10-17 00:00:00		2004-10-17 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2006-03-18 00:00:00		2006-05-26 00:00:00		2006-03-18 00:00:00		2006-05-21 00:00:00		2006-05-21 00:00:00		2006-05-31 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2006-10-30 00:00:00		2006-11-01 00:00:00		2006-11-02 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		2006-11-03 00:00:00		2006-10-31 00:00:00		2006-10-22 00:00:00		2006-10-22 00:00:00		None		None		None		None		None		2007-01-01 00:00:00		2007-01-01 00:00:00		None		2007-12-07 00:00:00		None		2013-06-11 00:00:00		None		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-08-28 00:00:00		2015-01-01 00:00:00		2014-10-19 00:00:00		2014-05-18 00:00:00		2014-03-18 00:00:00		2014-05-27 00:00:00		2014-03-18 00:00:00		2015-04-24 00:00:00		2014-10-19 00:00:00		2014-10-01 00:00:00		2014-10-31 00:00:00		2014-07-01 00:00:00		2014-10-15 00:00:00		2014-10-01 00:00:00		2014-09-25 00:00:00		2008-01-01 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-05-18 00:00:00		None		2008-05-20 00:00:00		2008-05-22 00:00:00		None		2008-03-18 00:00:00		None		2008-05-29 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-05-18 00:00:00		2008-03-18 00:00:00		None		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-10-21 00:00:00		2008-12-23 00:00:00		2008-12-23 00:00:00		None		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-10-19 00:00:00		2008-10-19 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2010-03-11 00:00:00		None		2010-04-21 00:00:00		2009-07-01 00:00:00		None		2010-05-27 00:00:00		None		None		None		2010-06-02 00:00:00		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-06-01 00:00:00		2010-05-23 00:00:00		2010-10-23 00:00:00		2010-05-23 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2010-10-17 00:00:00		2010-10-17 00:00:00		2010-07-01 00:00:00		None		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-03-18 00:00:00		2012-03-18 00:00:00		2012-05-25 00:00:00		2013-07-01 00:00:00		2014-01-01 00:00:00		2013-11-22 00:00:00		2014-01-01 00:00:00		2013-07-01 00:00:00		2012-07-01 00:00:00		2012-05-20 00:00:00		2012-07-01 00:00:00		2012-05-20 00:00:00		2012-05-20 00:00:00		2012-03-18 00:00:00		2012-05-20 00:00:00		2012-10-01 00:00:00		2012-03-18 00:00:00		2012-10-23 00:00:00		2012-10-01 00:00:00		2014-07-01 00:00:00		2014-05-18 00:00:00		2014-09-11 00:00:00		2012-10-21 00:00:00		2013-01-31 00:00:00		2014-05-02 00:00:00		2014-04-09 00:00:00		2012-10-21 00:00:00		None		2015-01-01 00:00:00		2018-07-01 00:00:00		2018-09-10 00:00:00		2018-07-01 00:00:00		2020-02-05 00:00:00		2019-01-23 00:00:00		2017-07-01 00:00:00		2020-08-20 00:00:00		2020-01-01 00:00:00		2018-04-22 00:00:00		2018-09-23 00:00:00		2020-09-20 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2018-03-19 00:00:00		2016-03-11 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-05-05 00:00:00		2016-03-31 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-04-24 00:00:00		2016-05-27 00:00:00		2016-04-24 00:00:00		2016-06-03 00:00:00		2016-05-22 00:00:00		2016-05-22 00:00:00		2016-09-26 00:00:00		2016-07-01 00:00:00		2016-08-18 00:00:00		2016-11-01 00:00:00		2016-10-20 00:00:00		2016-07-01 00:00:00		2016-09-25 00:00:00		2016-09-25 00:00:00		2016-10-23 00:00:00		2016-10-23 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2018-09-23 00:00:00		2020-09-15 00:00:00		2018-11-02 00:00:00		2020-01-01 00:00:00		2018-04-22 00:00:00		2018-08-10 00:00:00		2020-08-31 00:00:00		2018-10-21 00:00:00		2020-02-16 00:00:00		2019-07-01 00:00:00		2018-10-21 00:00:00		2020-10-27 00:00:00		2020-10-02 00:00:00		2017-11-08 00:00:00		2018-06-05 00:00:00		2018-01-01 00:00:00		2020-10-18 00:00:00		2019-04-01 00:00:00		2017-07-01 00:00:00		2021-05-11 00:00:00		2020-07-01 00:00:00		2018-10-08 00:00:00		2020-01-22 00:00:00		None		2020-07-01 00:00:00		2018-09-27 00:00:00		2020-09-20 00:00:00		2020-02-16 00:00:00		2019-01-01 00:00:00		2020-04-28 00:00:00		2019-04-01 00:00:00		2020-10-18 00:00:00		2021-01-01 00:00:00		2022-04-24 00:00:00		2019-07-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2022-06-01 00:00:00		2022-05-22 00:00:00		2022-09-16 00:00:00		2022-07-01 00:00:00		2021-07-01 00:00:00		2022-05-13 00:00:00		2022-03-11 00:00:00		2021-10-01 00:00:00		2022-04-24 00:00:00		2022-01-01 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00		2022-10-25 00:00:00		2022-05-22 00:00:00
rpt_end		2000-10-21 00:00:00		None		None		1995-12-31 00:00:00		1996-02-10 00:00:00		1996-03-09 00:00:00		None		1996-06-30 00:00:00		1996-09-30 00:00:00		None		1996-10-19 00:00:00		None		1997-03-31 00:00:00		1997-06-30 00:00:00		1997-09-30 00:00:00		1997-09-30 00:00:00		1997-12-31 00:00:00		1998-03-17 00:00:00		None		None		1998-05-16 00:00:00		1998-10-17 00:00:00		None		1996-12-31 00:00:00		1995-12-31 00:00:00		1999-06-30 00:00:00		1995-09-30 00:00:00		1998-06-30 00:00:00		1998-12-31 00:00:00		1999-09-30 00:00:00		1996-12-31 00:00:00		1998-10-21 00:00:00		2000-02-19 00:00:00		1999-12-31 00:00:00		2000-03-01 00:00:00		2000-03-01 00:00:00		2000-01-22 00:00:00		2000-03-01 00:00:00		None		None		None		2000-10-21 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		None		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-11-01 00:00:00		1997-10-01 00:00:00		1900-01-01 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2000-12-31 00:00:00		2000-09-30 00:00:00		2000-10-21 00:00:00		2000-06-30 00:00:00		2000-02-19 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2000-02-19 00:00:00		2000-06-30 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2000-09-30 00:00:00		2000-10-21 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2002-02-22 00:00:00		2001-12-31 00:00:00		None		2002-02-16 00:00:00		2002-02-16 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-02-16 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-10-19 00:00:00		2002-10-19 00:00:00		2002-06-30 00:00:00		2002-02-16 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-06-30 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-02-14 00:00:00		2004-01-17 00:00:00		2004-02-14 00:00:00		2004-01-17 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-10-16 00:00:00		2004-10-16 00:00:00		2004-10-22 00:00:00		None		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-03-17 00:00:00		2006-03-17 00:00:00		2006-05-20 00:00:00		2006-05-26 00:00:00		2006-05-20 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2006-05-31 00:00:00		2006-09-30 00:00:00		2006-09-30 00:00:00		2006-10-30 00:00:00		2006-11-01 00:00:00		2006-11-02 00:00:00		2006-09-30 00:00:00		2006-10-21 00:00:00		2006-09-30 00:00:00		2006-10-21 00:00:00		2006-11-03 00:00:00		2006-10-31 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		None		None		None		None		None		2007-06-30 00:00:00		2007-06-30 00:00:00		None		2007-12-07 00:00:00		None		2013-06-11 00:00:00		None		2013-06-30 00:00:00		2013-06-30 00:00:00		2013-08-28 00:00:00		2015-06-30 00:00:00		2014-12-31 00:00:00		2014-06-30 00:00:00		2014-05-17 00:00:00		2014-05-27 00:00:00		2014-05-17 00:00:00		2015-04-24 00:00:00		2014-12-31 00:00:00		2014-10-18 00:00:00		2014-10-31 00:00:00		2014-09-30 00:00:00		2014-10-15 00:00:00		2014-10-18 00:00:00		2014-09-25 00:00:00		2008-03-17 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2008-03-17 00:00:00		2008-06-30 00:00:00		None		2008-05-20 00:00:00		2008-05-22 00:00:00		None		2008-05-17 00:00:00		None		2008-05-29 00:00:00		2008-09-30 00:00:00		2008-10-18 00:00:00		2008-06-30 00:00:00		2008-05-17 00:00:00		None		2008-09-30 00:00:00		2008-10-18 00:00:00		2008-10-21 00:00:00		2008-12-23 00:00:00		2008-12-23 00:00:00		None		2008-09-30 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-03-11 00:00:00		None		2010-04-21 00:00:00		2009-12-31 00:00:00		None		2010-05-27 00:00:00		None		None		None		2010-06-02 00:00:00		2010-06-30 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-05-22 00:00:00		2010-06-01 00:00:00		2010-06-30 00:00:00		2010-10-23 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-10-16 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2010-09-30 00:00:00		None		2010-10-16 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-03-17 00:00:00		2012-03-17 00:00:00		2012-05-19 00:00:00		2012-05-19 00:00:00		2012-05-25 00:00:00		2013-12-31 00:00:00		2014-03-17 00:00:00		2013-11-22 00:00:00		2014-03-17 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2012-05-19 00:00:00		2012-06-30 00:00:00		2012-10-20 00:00:00		2012-05-19 00:00:00		2012-10-23 00:00:00		2012-10-20 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2014-09-11 00:00:00		2012-12-31 00:00:00		2013-01-31 00:00:00		2014-05-02 00:00:00		2014-04-09 00:00:00		2012-12-31 00:00:00		None		2015-06-30 00:00:00		2018-09-22 00:00:00		2018-09-10 00:00:00		2018-09-22 00:00:00		2020-02-05 00:00:00		2019-01-23 00:00:00		2017-12-31 00:00:00		2020-08-20 00:00:00		2020-02-15 00:00:00		2018-06-30 00:00:00		2018-10-20 00:00:00		2020-10-17 00:00:00		2018-04-21 00:00:00		2019-03-31 00:00:00		2018-03-19 00:00:00		2016-03-11 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-05-05 00:00:00		2016-03-31 00:00:00		2016-04-23 00:00:00		2016-04-23 00:00:00		2016-05-21 00:00:00		2016-05-27 00:00:00		2016-05-21 00:00:00		2016-06-03 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-09-26 00:00:00		2016-09-24 00:00:00		2016-08-18 00:00:00		2016-11-01 00:00:00		2016-10-20 00:00:00		2016-09-24 00:00:00		2016-10-22 00:00:00		2016-10-22 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2018-10-20 00:00:00		2020-09-15 00:00:00		2018-11-02 00:00:00		2020-02-15 00:00:00		2018-06-30 00:00:00		2018-08-10 00:00:00		2020-08-31 00:00:00		2018-12-31 00:00:00		2020-06-30 00:00:00		2019-12-31 00:00:00		2018-12-31 00:00:00		2020-10-27 00:00:00		2020-10-02 00:00:00		2017-11-08 00:00:00		2018-06-05 00:00:00		2018-04-21 00:00:00		2020-12-31 00:00:00		2019-06-30 00:00:00		2017-12-31 00:00:00		2021-05-11 00:00:00		2020-09-19 00:00:00		2018-10-08 00:00:00		2020-01-22 00:00:00		None		2020-09-19 00:00:00		2018-09-27 00:00:00		2020-10-17 00:00:00		2020-06-30 00:00:00		2019-03-31 00:00:00		2020-04-28 00:00:00		2019-06-30 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2022-05-21 00:00:00		2019-12-31 00:00:00		2021-06-30 00:00:00		2021-09-30 00:00:00		2022-04-23 00:00:00		2022-06-01 00:00:00		2022-06-30 00:00:00		2022-09-16 00:00:00		2022-09-24 00:00:00		2021-09-30 00:00:00		2022-05-13 00:00:00		2022-03-11 00:00:00		2021-12-31 00:00:00		2022-05-21 00:00:00		2022-04-23 00:00:00		2021-12-31 00:00:00		2022-09-24 00:00:00		2022-10-25 00:00:00		2022-06-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2000-03-01 00:00:00		2000-03-01 00:00:00		None		2000-03-01 00:00:00		None		None		None		2000-10-26 00:00:00		2000-07-26 00:00:00		2000-10-05 00:00:00		None		None		2000-11-01 00:00:00		2000-01-31 00:00:00		None		2000-11-01 00:00:00		None		None		None		2001-07-31 00:00:00		2001-09-17 00:00:00		2001-09-17 00:00:00		2001-09-17 00:00:00		2001-09-17 00:00:00		2001-09-17 00:00:00		2001-09-17 00:00:00		None		None		None		None		2001-10-10 00:00:00		None		None		None		None		2001-07-31 00:00:00		None		2002-01-09 00:00:00		None		2002-01-31 00:00:00		2002-02-22 00:00:00		None		None		None		2002-02-20 00:00:00		None		2002-07-29 00:00:00		2002-10-02 00:00:00		2002-10-07 00:00:00		2002-10-03 00:00:00		2002-10-22 00:00:00		None		None		None		None		2003-04-10 00:00:00		2003-01-17 00:00:00		None		None		2003-07-21 00:00:00		2003-07-21 00:00:00		2003-10-07 00:00:00		None		None		None		None		2004-01-08 00:00:00		None		None		2004-02-16 00:00:00		2004-01-19 00:00:00		None		2004-07-21 00:00:00		None		2004-10-02 00:00:00		2004-10-19 00:00:00		None		2004-10-22 00:00:00		None		2005-01-23 00:00:00		None		None		2005-07-10 00:00:00		2006-01-16 00:00:00		None		2006-03-20 00:00:00		None		None		2006-05-26 00:00:00		2006-05-23 00:00:00		2006-07-20 00:00:00		None		2006-05-31 00:00:00		2006-10-03 00:00:00		None		2006-10-30 00:00:00		2006-11-01 00:00:00		2006-11-02 00:00:00		2006-10-23 00:00:00		2006-10-23 00:00:00		None		None		2006-11-03 00:00:00		2006-10-31 00:00:00		2007-01-17 00:00:00		None		None		None		None		None		None		2007-07-18 00:00:00		None		None		2007-12-07 00:00:00		None		None		None		2013-07-31 00:00:00		None		2013-08-28 00:00:00		2015-07-31 00:00:00		None		2014-07-31 00:00:00		2014-05-22 00:00:00		2014-05-27 00:00:00		None		2015-04-24 00:00:00		2015-02-02 00:00:00		None		2014-10-31 00:00:00		None		2014-10-15 00:00:00		2014-10-23 00:00:00		2014-09-25 00:00:00		2008-03-19 00:00:00		2008-01-17 00:00:00		None		None		2008-07-18 00:00:00		None		2008-05-20 00:00:00		2008-05-22 00:00:00		None		2008-05-19 00:00:00		None		2008-05-29 00:00:00		None		None		None		None		None		2008-10-04 00:00:00		2008-10-19 00:00:00		2008-10-21 00:00:00		None		None		None		None		2008-10-15 00:00:00		2009-01-24 00:00:00		None		None		2009-04-17 00:00:00		2009-07-16 00:00:00		None		None		None		None		None		2010-01-18 00:00:00		None		None		None		None		None		2010-06-02 00:00:00		None		2010-05-27 00:00:00		2010-08-02 00:00:00		None		2010-06-01 00:00:00		None		2010-10-23 00:00:00		2010-10-08 00:00:00		None		2010-10-21 00:00:00		2011-01-26 00:00:00		None		2010-10-04 00:00:00		None		None		2011-07-26 00:00:00		None		2012-01-30 00:00:00		None		None		2012-03-22 00:00:00		None		2012-05-24 00:00:00		2012-05-25 00:00:00		None		2014-03-24 00:00:00		2013-11-22 00:00:00		None		2014-01-31 00:00:00		None		2012-07-31 00:00:00		2012-10-05 00:00:00		None		None		None		2012-10-25 00:00:00		2012-10-25 00:00:00		2012-10-25 00:00:00		2012-10-23 00:00:00		None		2014-10-06 00:00:00		None		2014-09-11 00:00:00		2013-01-31 00:00:00		None		2014-05-02 00:00:00		2014-04-09 00:00:00		None		None		None		None		2018-09-10 00:00:00		2018-09-25 00:00:00		2020-02-05 00:00:00		2019-01-23 00:00:00		None		2020-08-20 00:00:00		None		None		None		2020-10-17 00:00:00		2018-04-25 00:00:00		2019-04-19 00:00:00		2018-03-19 00:00:00		2016-03-11 00:00:00		None		2016-02-01 00:00:00		2016-05-05 00:00:00		2016-03-31 00:00:00		2016-04-28 00:00:00		None		None		2016-05-27 00:00:00		2016-05-26 00:00:00		2016-06-03 00:00:00		2016-08-01 00:00:00		None		2016-09-26 00:00:00		2016-09-29 00:00:00		2016-08-18 00:00:00		2016-11-01 00:00:00		2016-10-20 00:00:00		None		2016-10-27 00:00:00		None		None		2017-01-31 00:00:00		2017-07-27 00:00:00		None		2018-10-25 00:00:00		2020-09-15 00:00:00		2018-11-02 00:00:00		2020-02-15 00:00:00		2018-07-25 00:00:00		2018-08-10 00:00:00		2020-08-31 00:00:00		None		2020-07-23 00:00:00		2020-01-18 00:00:00		2019-01-31 00:00:00		2020-10-27 00:00:00		2020-10-02 00:00:00		2017-11-08 00:00:00		2018-06-05 00:00:00		None		None		None		2018-01-21 00:00:00		2021-05-11 00:00:00		None		2018-10-08 00:00:00		2020-01-22 00:00:00		None		2020-09-22 00:00:00		2018-09-27 00:00:00		None		None		None		None		2019-07-16 00:00:00		2021-01-15 00:00:00		2021-07-19 00:00:00		None		None		None		None		None		2022-06-01 00:00:00		2022-07-12 00:00:00		2022-09-16 00:00:00		2022-09-24 00:00:00		2021-10-12 00:00:00		2022-05-13 00:00:00		2022-03-11 00:00:00		2022-01-18 00:00:00		2022-05-21 00:00:00		2022-04-26 00:00:00		None		None		2022-10-25 00:00:00		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		22001		22001		22001		None		None		None		None		22001		None		None		22001		22001		None		22001		None		22001		22001		None		22001		None		22001		None		None		22001		22001		None		22001		None		None		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		None		None		None		None		None		None		22001		None		None		22001		None		22001		None		22001		None		22001		22001		None		22001		22001		22001		None		22001		22001		None		22001		None		22001		22001		22001		22001		22001		None		None		22001		None		22001		22001		None		22001		None		22001		None		None		None		None		None		22001		22001		22001		22001		22001		None		None		22001		22001		None		None		22001		22001		None		None		22006		None		22001		22001		None		22001		None		None		None		22001		None		22001		22001		None		22001		None		22001		22001		None		22001		22001		None		22001		None		None		22001		None		22001		None		None		22001		None		22001		22001		None		22001		22001		None		22001		None		22001		22001		None		None		None		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		None		None		None		None		22001		22001		22001		22001		None		22001		None		None		None		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		None		22001		None		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		None		None		22001		22001		None		22001		22001		None		22001		22001		None		None		None		22001		22001		22001		22001		None		None		None		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		None

Table: filer_to_filer_type

filer_id		1064902		1064902
filer_type		16		16
active		Y		Y
race		0		0
session_id		1995		2009
category		0		0
category_type		40502		40502
sub_category		40103		40103
effect_dt		1995-04-12 00:00:00		2010-05-27 00:00:00
sub_category_type		40203		0
election_type		0		0
sub_category_a		None		S
nyq_dt		1995-08-08 00:00:00		1995-08-08 00:00:00
party_cd		None		None
county_cd		18004		18004
district_cd		None		None

Table: filer_xref

filer_id		1064902
xref_id		950393
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		950393		950393		950393		950393		950393		950393		950393		950393		950393		950393		950393		950393		950393		950393		950393		950393		950393		950393
filer_id		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00
naml		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION PAC AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION PAC AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION PAC AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION PAC AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION PAC AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION PAC AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION PAC AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION PAC AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION PAC AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION POLITICAL ACTION COMMITTEE, THE AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION POLITICAL ACTION COMMITTEE, THE AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION POLITICAL ACTION COMMITTEE, THE AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION POLITICAL ACTION COMMITTEE, THE AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION POLITICAL ACTION COMMITTEE, THE AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION POLITICAL ACTION COMMITTEE, THE AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION POLITICAL ACTION COMMITTEE, THE AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION POLITICAL ACTION COMMITTEE, THE AKA LSCOA-PAC		LOCAL SOCIETIES OF THE CALIFORNIA OPTOMETRIC ASSOCIATION POLITICAL ACTION COMMITTEE, THE AKA LSCOA-PAC
namf		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
nams		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
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		WHITTIER		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		WHITTIER		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
zip4		906010000		958142591		95816		95814		95814		95816		95814		95814		95814		906010000		958142591		95816		95814		95814		95816		95814		95814		95814
phon		5626983607		9164413990		9164413990		None		9164413990		9164413990		9164413990		9164413990				5626983607		9164413990		9164413990		None		9164413990		9164413990		9164413990		9164413990
fax		None		None		None		None		None		9164421280		9164421280		9164427759				None		None		None		None		None		9164421280		9164421280		9164427759
email		None		None		None		None		None		None		info@olsonhagel.com		fppc@bmhlaw.com		None		None		None		None		None		None		None		info@olsonhagel.com		fppc@bmhlaw.com		None

Table: filers

filer_id		1064902

Table: received_filings

filer_id		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902		1064902
filing_file_name		669299_0.cal		643630_0.cal		676874_0.cal		683286_0.cal		718310_0.cal		786241_0.cal		718310_1.cal		772677_1.cal		718310_2.cal		669299_1.cal		676874_1.cal		643630_1.cal		592060_1.cal		772677_0.cal		805092_0.cal		822525_0.cal		805092_1.cal		824651_0.cal		855182_0.cal		822525_1.cal		855182_1.cal		871820_0.cal		877630_0.cal		911123_0.cal		931414_1.cal		947095_0.cal		931414_0.cal		963351_0.cal		979667_0.cal		1494227_0.cal		1493563_0.cal		1385141_2.cal		1664779_0.cal		1846999_0.cal		1837402_0.cal		1789367_0.cal		1805379_0.cal		1533264_0.cal		1701856_0.cal		116383.cal		1855305_0.cal		2049440_0.cal		2047560_0.cal		2103376_0.cal		2081536_0.cal		1884677_0.cal		2020172_0.cal		2025174_0.cal		1888543_0.cal		2093308_0.cal		1898647_0.cal		2070037_0.cal		1961466_0.cal		1911194_0.cal		2040018_0.cal		2290299_0.cal		2338107_0.cal		2446577_0.cal		350772.cal		351180.cal		2223311_0.cal		2496752_0.cal		2322289_0.cal		2282153_0.cal		2493279_0.cal		2195663_0.cal		2259762_0.cal		2303406_0.cal		2297524_0.cal		2433328_0.cal		350640.cal		2501492_0.cal		2682216_0.cal		2720840_0.cal		2656757_0.cal		2523960_0.cal		2583712_0.cal		2508706_0.cal		408717.cal		2740377_0.cal
received_date		2000-10-05 00:00:00		2000-07-28 00:00:00		2000-10-26 00:00:00		2000-11-01 00:00:00		2001-01-31 00:00:00		2001-10-10 00:00:00		2001-07-31 00:00:00		2001-09-21 00:00:00		2001-09-21 00:00:00		2001-09-21 00:00:00		2001-09-21 00:00:00		2001-09-21 00:00:00		2001-09-21 00:00:00		2001-07-31 00:00:00		2002-01-10 00:00:00		2002-02-21 00:00:00		2002-02-01 00:00:00		2002-02-22 00:00:00		2002-07-30 00:00:00		2002-10-07 00:00:00		2002-10-07 00:00:00		2002-10-07 00:00:00		2002-10-24 00:00:00		2003-01-30 00:00:00		2003-07-31 00:00:00		2003-07-31 00:00:00		2003-04-30 00:00:00		2003-10-10 00:00:00		2004-01-12 00:00:00		2010-06-02 00:00:00		2010-06-01 00:00:00		2010-03-11 00:00:00		2012-05-25 00:00:00		2014-05-02 00:00:00		2014-04-09 00:00:00		2013-08-28 00:00:00		2013-11-22 00:00:00		2010-10-23 00:00:00		2012-10-23 00:00:00		2012-10-25 00:00:00		2014-05-27 00:00:00		2016-06-03 00:00:00		2016-05-27 00:00:00		2016-11-01 00:00:00		2016-09-26 00:00:00		2014-09-11 00:00:00		2016-03-11 00:00:00		2016-03-31 00:00:00		2014-09-25 00:00:00		2016-10-21 00:00:00		2014-10-15 00:00:00		2016-08-18 00:00:00		2015-04-24 00:00:00		2014-10-31 00:00:00		2016-05-05 00:00:00		2018-09-10 00:00:00		2019-01-23 00:00:00		2020-02-05 00:00:00		2018-10-25 00:00:00		2018-10-25 00:00:00		2018-03-19 00:00:00		2020-08-31 00:00:00		2018-11-02 00:00:00		2018-08-10 00:00:00		2020-08-20 00:00:00		2017-11-08 00:00:00		2018-06-05 00:00:00		2018-10-08 00:00:00		2018-09-28 00:00:00		2020-01-22 00:00:00		2018-10-25 00:00:00		2020-09-15 00:00:00		2022-05-13 00:00:00		2022-09-16 00:00:00		2022-03-11 00:00:00		2020-10-27 00:00:00		2021-05-11 00:00:00		2020-10-02 00:00:00		2022-10-25 00:00:00		2022-10-25 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/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/temp		/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/temp		/cafiler/disclose/ca99/temp		/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/temp		/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/temp		/cafiler/disclose/ca99/cal
filing_id		669299		643630		676874		683286		718310		786241		718310		772677		718310		669299		676874		643630		592060		772677		805092		822525		805092		824651		855182		822525		855182		871820		877630		911123		931414		947095		931414		963351		979667		1494227		1493563		1385141		1664779		1846999		1837402		1789367		1805379		1533264		1701856		None		1855305		2049440		2047560		2103376		2081536		1884677		2020172		2025174		1888543		2093308		1898647		2070037		1961466		1911194		2040018		2290299		2338107		2446577		None		None		2223311		2496752		2322289		2282153		2493279		2195663		2259762		2303406		2297524		2433328		None		2501492		2682216		2720840		2656757		2523960		2583712		2508706		None		2740377
form_id		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F410		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		None		F497
receive_comment		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		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 did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted