Home

Filer ID: 1009728

Table: filer_address

filer_id		1009728		1009728
adrid		1009009		2296818
effect_dt		2008-01-31 00:00:00		2013-07-31 00:00:00
add_type		7051		7051
session_id		2007		2013

Table: filer_filings

filer_id		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728
filing_id		61319		61320		61321		61322		61323		61324		61325		61326		61327		61328		61329		61330		61287		61288		61289		61290		61292		61293		61294		61295		61296		61297		61298		61299		61300		61301		61302		61303		61304		61305		61306		61307		61308		61309		61310		61311		61312		61313		61314		61315		61316		61317		202995		202996		202997		202998		202999		203000		61291		61318		585380		599295		599612		595292		595423		675562		681216		682559		684522		684300		714142		690494		751766		787912		785834		792302		773118		803603		826792		826792		831622		838013		827870		828524		829388		835523		858240		848273		851813		885644		884415		917292		945314		911756		959993		960190		954423		962224		962532		983538		978703		1000334		1003181		999840		1028793		996858		1038140		1055119		1067117		1058954		1099810		1080687		1102727		1105028		1116635		1118359		1146730		1182206		1174063		1187355		1176422		1210549		1202515		1218681		1221676		1253657		1260470		1257423		1234105		1234165		1273830		1269080		1284135		1260847		1274284		1286580		1783521		1981255		1870723		1856540		1839806		1788419		1935534		1933373		1909349		1897229		1310878		1312962		1350925		1349575		1369411		1368132		1378458		1395752		1380092		1435957		1438994		1401465		1451816		1451595		1465093		1463110		1490292		1490396		1504431		1530410		1510699		1543758		1576929		1568287		1620617		1632581		1620381		1634432		1675113		1829909		1831855		1818151		1681162		1933045		1899735		1880442		1877405		1882151		1884585		1739761		1828030		1829775		1837632		1752417		1748837		1998509		1984037		2249446		2305209		2182058		2228543		2305209		2276205		2379910		2422096		2429575		2232817		2285886		2230773		1997631		2009391		2021260		2023924		2005878		2017059		2021260		2040954		2033621		2042711		2067297		2052854		2047884		2058770		2075216		2068392		2104488		2086648		2128096		2127373		2136471		2174105		2396220		2457018		2284256		2368909		2519839		2247422		2599749		2223238		2211386		2476685		2348447		2193470		2533324		2195626		2313901		2487145		2404828		2443253		2382482		2419257		2510717		2552136		2522154		2566966		2703333		2682857		2656184		2687912		2639207		2607800		2712239		2713346		2745005		2732751		2733369
period_id		143		145		148		147		149		154		153		156		155		157		160		159		122		89		92		93		95		97		98		99		99		105		109		116		115		117		119		121		123		113		113		133		125		127		129		129		131		133		135		138		138		137		93		97		127		138		139		145		95		141		None		None		None		None		161		None		164		None		None		164		163		None		None		None		167		None		165		168		170		169		None		None		169		169		None		None		None		None		169		None		172		None		173		171		175		None		None		None		175		None		176		None		None		177		177		177		None		180		None		180		None		179		181		None		182		None		183		None		186		185		186		188		None		188		None		None		None		None		189		187		None		None		190		189		None		None		213		221		217		218		218		None		219		None		220		220		191		None		193		None		None		196		196		195		None		197		None		None		None		199		None		200		202		None		201		204		None		None		None		203		None		208		205		None		209		217		217		215		None		221		220		219		None		219		219		211		None		217		218		213		None		None		None		234		236		None		234		236		233		237		None		241		234		235		None		223		225		225		225		224		None		226		226		226		226		None		226		226		225		227		227		228		228		227		229		None		229		238		241		None		None		244		234		245		233		232		None		235		231		None		None		236		241		None		240		None		239		244		243		244		None		249		250		None		250		247		None		None		251		252		252		252
form_id		F461		F461		F497		F461		F461		F497		F461		F497		F461		F461		F497		F461		F777		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F405		F461		F461		F461		F461		F461		F405		F461		F497		F461		F461		F461		F405		F461		F461		F461		F497		F497		F461		F461		F461		F405		F497		F461		F405		F461		F461		F461		F497		F497		F497		F497		F461		F497		F497		F497		F497		F461		F497		F461		F461		F461		F461		F461		F461		F497		F497		F497		F497		F497		F497		F461		F497		F461		F497		F461		F497		F497		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F497		F497		F497		F461		F497		F461		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F497		F461		F497		F497		F461		F461		F497		F497		F461		F497		F497		F461		F461		F497		F461		F461		F461		F461		F497		F497		F461		F461		F461		F497		F497		F461		F461		F461		F461		F497		F497		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F497		F497		F497		F461		F497		F497		F461		F461		F497		F497		F497		F461		F461		F461		F497		F497		F461		F497		F497		F461		F461		F461		F497		F497		F497		F461		F461		F497		F497		F497		F461		F461		F497		F497		F497		F497		F461		F497		F497		F461		F497		F497		F497		F497		F461		F497		F461		F461		F461		F497		F461		F461		F497		F497		F461		F497		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F497		F461		F497		F461		F461		F497		F461		F497		F461		F461		F461		F497		F497		F497		F497
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		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		0		0		0
filing_date		1996-01-31 00:00:00		1996-07-31 00:00:00		1996-10-30 00:00:00		1997-01-31 00:00:00		1998-01-30 00:00:00		1998-05-22 00:00:00		1998-07-30 00:00:00		1998-10-28 00:00:00		1999-01-28 00:00:00		1999-07-28 00:00:00		1999-10-22 00:00:00		1999-10-08 00:00:00		1990-06-13 00:00:00		1982-11-30 00:00:00		1983-01-31 00:00:00		1983-09-14 00:00:00		1984-01-31 00:00:00		1984-05-23 00:00:00		1984-07-31 00:00:00		1984-09-24 00:00:00		1985-01-30 00:00:00		1987-01-27 00:00:00		1988-01-29 00:00:00		1988-11-29 00:00:00		1989-01-26 00:00:00		1989-07-28 00:00:00		1990-01-31 00:00:00		1990-07-30 00:00:00		1991-01-31 00:00:00		1988-11-29 00:00:00		1988-07-28 00:00:00		1993-01-28 00:00:00		1991-07-31 00:00:00		1992-01-31 00:00:00		1992-07-31 00:00:00		1992-11-17 00:00:00		1993-01-29 00:00:00		1993-07-30 00:00:00		1994-01-31 00:00:00		1994-06-01 00:00:00		1994-06-07 00:00:00		1994-07-29 00:00:00		1983-05-03 00:00:00		1984-03-21 00:00:00		1992-11-17 00:00:00		1994-05-25 00:00:00		1995-01-31 00:00:00		1996-08-22 00:00:00		1983-09-22 00:00:00		1995-07-31 00:00:00		2000-01-07 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-02-25 00:00:00		2000-02-28 00:00:00		2000-07-27 00:00:00		2000-10-30 00:00:00		2000-10-30 00:00:00		2000-11-02 00:00:00		2000-11-02 00:00:00		2001-01-24 00:00:00		2000-10-30 00:00:00		2001-01-30 00:00:00		2001-10-10 00:00:00		2001-10-10 00:00:00		2001-07-31 00:00:00		2001-07-31 00:00:00		2002-01-07 00:00:00		2002-05-16 00:00:00		2002-02-27 00:00:00		2002-02-27 00:00:00		2002-03-04 00:00:00		2002-03-01 00:00:00		2002-03-04 00:00:00		2002-01-09 00:00:00		2002-03-01 00:00:00		2002-07-30 00:00:00		2002-05-16 00:00:00		2002-07-25 00:00:00		2002-10-31 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2003-07-28 00:00:00		2003-01-31 00:00:00		2003-09-26 00:00:00		2003-09-26 00:00:00		2003-07-31 00:00:00		2003-10-06 00:00:00		2003-10-08 00:00:00		2004-01-08 00:00:00		2004-01-08 00:00:00		2004-02-19 00:00:00		2004-02-24 00:00:00		2004-02-24 00:00:00		2004-07-29 00:00:00		2004-02-19 00:00:00		2004-07-30 00:00:00		2004-10-27 00:00:00		2004-11-01 00:00:00		2004-11-01 00:00:00		2005-01-31 00:00:00		2005-01-31 00:00:00		2005-04-26 00:00:00		2005-04-29 00:00:00		2005-07-28 00:00:00		2005-07-29 00:00:00		2006-01-30 00:00:00		2006-01-31 00:00:00		2006-05-25 00:00:00		2006-07-25 00:00:00		2006-05-30 00:00:00		2006-10-24 00:00:00		2006-07-26 00:00:00		2006-11-02 00:00:00		2006-05-30 00:00:00		2007-01-30 00:00:00		2007-04-27 00:00:00		2004-10-27 00:00:00		2007-01-29 00:00:00		2007-01-29 00:00:00		2006-11-02 00:00:00		2006-10-24 00:00:00		2007-07-31 00:00:00		2007-04-27 00:00:00		2007-01-29 00:00:00		2007-07-31 00:00:00		2013-07-31 00:00:00		2015-07-30 00:00:00		2014-07-30 00:00:00		2014-05-29 00:00:00		2014-04-21 00:00:00		2013-07-31 00:00:00		2015-01-31 00:00:00		2015-01-27 00:00:00		2014-10-30 00:00:00		2014-10-13 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-07-31 00:00:00		2008-07-30 00:00:00		2008-10-21 00:00:00		2008-10-21 00:00:00		2008-10-31 00:00:00		2009-01-30 00:00:00		2008-10-31 00:00:00		2009-07-29 00:00:00		2009-07-30 00:00:00		2009-01-30 00:00:00		2009-10-29 00:00:00		2009-10-29 00:00:00		2010-01-29 00:00:00		2010-01-29 00:00:00		2010-05-26 00:00:00		2010-05-26 00:00:00		2010-07-28 00:00:00		2010-10-20 00:00:00		2010-07-29 00:00:00		2010-10-20 00:00:00		2011-01-27 00:00:00		2011-01-27 00:00:00		2011-10-27 00:00:00		2012-01-26 00:00:00		2011-10-27 00:00:00		2012-01-30 00:00:00		2012-07-26 00:00:00		2014-03-18 00:00:00		2014-03-24 00:00:00		2014-01-31 00:00:00		2012-07-26 00:00:00		2015-01-29 00:00:00		2014-10-17 00:00:00		2014-08-25 00:00:00		2014-07-31 00:00:00		2014-09-03 00:00:00		2014-09-11 00:00:00		2013-01-31 00:00:00		2014-01-31 00:00:00		2014-03-18 00:00:00		2014-04-10 00:00:00		2013-03-07 00:00:00		2013-01-31 00:00:00		2015-11-02 00:00:00		2015-07-31 00:00:00		2018-05-15 00:00:00		2018-10-11 00:00:00		2017-07-28 00:00:00		2018-04-05 00:00:00		2018-10-11 00:00:00		2018-07-31 00:00:00		2019-04-30 00:00:00		2019-10-31 00:00:00		2020-01-10 00:00:00		2018-04-19 00:00:00		2018-08-23 00:00:00		2018-01-31 00:00:00		2015-10-31 00:00:00		2016-01-28 00:00:00		2016-03-17 00:00:00		2016-03-28 00:00:00		2016-01-24 00:00:00		2016-01-27 00:00:00		2016-04-27 00:00:00		2016-05-09 00:00:00		2016-04-27 00:00:00		2016-05-13 00:00:00		2016-07-28 00:00:00		2016-06-27 00:00:00		2016-05-31 00:00:00		2016-07-26 00:00:00		2016-09-08 00:00:00		2016-08-15 00:00:00		2016-11-03 00:00:00		2016-10-07 00:00:00		2017-01-30 00:00:00		2017-01-30 00:00:00		2017-01-31 00:00:00		2017-07-28 00:00:00		2019-07-30 00:00:00		2020-02-24 00:00:00		2018-07-31 00:00:00		2019-01-31 00:00:00		2020-10-21 00:00:00		2018-05-08 00:00:00		2021-07-29 00:00:00		2018-03-19 00:00:00		2018-01-31 00:00:00		2020-01-31 00:00:00		2019-01-31 00:00:00		2017-10-31 00:00:00		2020-07-30 00:00:00		2017-10-31 00:00:00		2018-10-26 00:00:00		2020-07-31 00:00:00		2019-07-30 00:00:00		2020-01-31 00:00:00		2019-04-30 00:00:00		2019-10-31 00:00:00		2020-10-06 00:00:00		2021-01-31 00:00:00		2020-10-23 00:00:00		2021-01-29 00:00:00		2022-07-28 00:00:00		2022-05-16 00:00:00		2022-01-28 00:00:00		2022-05-27 00:00:00		2022-01-27 00:00:00		2021-07-30 00:00:00		2922-07-29 00:00:00		2022-08-23 00:00:00		2022-10-28 00:00:00		2022-10-13 00:00:00		2022-10-14 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10001		10005		10001		10005		10001		10001		10001		10005		10005		10005		10001		10005		10001		10001		10002		10001		10005		10005		10001		10001		10005		10005		10005		10002		10001		10005		10001		10005		10001		10001		10001		10001		10005		10005		10001		10005		10001		10005		10005		10001		10001		10001		10005		10001		10005		10001		10005		10001		10001		10005		10001		10005		10001		10005		10001		10001		10001		10001		10005		10001		10005		10005		10005		10005		10001		10001		10005		10005		10001		10001		10005		10005		10001		10001		10001		10001		10001		10005		10001		10005		10001		10001		10001		10005		10001		10005		10005		10001		10001		10001		10005		10001		10005		10005		10005		10001		10005		10001		10001		10005		10001		10001		10005		10005		10005		10001		10005		10001		10001		10005		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10005		10005		10005		10001		10001		10005		10001		10002		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10005		10002		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10005		10001		10001		10001		10001		10001		10005		10001		10001		10005		10005		10001		10001		10005		10001		10005		10001		10001		10001		10001		10005		10001		10001		10005		10001		10001		10005		10005		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11003		11003		11003		11001		11001		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11001		11001		11001		11003		11001		11001		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11003		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		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11003		11003
session_id		1995		1995		1995		1995		1997		1997		1997		1997		1997		1999		1999		1999		1989		1981		1981		1983		1983		1983		1983		1983		1983		1985		1987		1987		1987		1989		1989		1989		1989		1987		1987		1993		1991		1991		1991		1991		1991		1993		1993		1993		1993		1993		1983		1983		1991		1993		1993		1995		1983		1995		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		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		2007		2003		2007		2005		2005		2005		2007		2007		2007		2007		2013		2015		2013		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2013		2013		2013		2011		2015		2013		2013		2013		2013		2013		2011		2013		2013		2013		2013		2011		2015		2015		2017		2017		2017		2017		2017		2017		2019		2019		2019		2017		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2015		2017		2019		2019		2017		2019		2019		2017		2021		2017		2017		2019		2017		2017		2019		2017		2017		2019		2019		2019		2019		2019		2019		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		*		*		*		*		EMCENTEE		*		KCHAN		GPEREZ		*		*		GKURIMOT		EMCENTEE		JBRANNON		*		DBARRICK		*		*		*		*		KLARRY		RALLMOND		*		*		LTHIBAUL		EMCENTEE		LTHIBAUL		DHORRELL		*		CFLAGG		*		DHORRELL		COMPLETED		COMPLETED		COMPLETED		GPEREZ		GGILMORE		DHORRELL		COMPLETED		CFLAGG		COMPLETED		LLEONG		GPEREZ		COMPLETED		COMPLETED		COMPLETED		DHORRELL		COMPLETED		EMCENTEE		GKURIMOT		DHORRELL		COMPLETED		*		DHORRELL		*		DHORRELL		*		RGEREMIA		*		*		DJOHNSON		DHORRELL		JMARTIN		DHORRELL		EMCENTEE		JMARTIN		JMARTIN		LHOANG		DHORRELL		SMCCABE		LHOANG		RGEREMIA		SMCCABE		SMCCABE		LHOANG		JMARTIN		JINGRAM		JINGRAM		JINGRAM		WBROWN		WBROWN		JINGRAM		JINGRAM		JINGRAM		WBROWN		WBROWN		SMCCABE		SMCCABE		MGUERRA		MGUERRA		YRODRIGU		DHORRELL		DHORRELL		JINGRAM		RGEREMIA		JINGRAM		JINGRAM		JINGRAM		JVAZQUEZ		JINGRAM		JINGRAM		JINGRAM		DHORRELL		GKURIMOT		JINGRAM		WBROWN		JINGRAM		MPACHECO		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		WBROWN		WBROWN		JINGRAM		JINGRAM		WBROWN		WBROWN		WBROWN		JINGRAM		WBROWN		WBROWN		JINGRAM		JINGRAM		WBROWN		WBROWN		WBROWN		JINGRAM		JINGRAM		JINGRAM		GTAYLOR		CAFILER		LPALMER		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		CAFILER		DMCCASTL		JINGRAM		WBROWN		KBANH		KBANH		JINGRAM		KBANH		RGEREMIA		KBANH		KBANH		KBANH		JINGRAM		RGEREMIA		KBANH		JINGRAM		PDEO		GCLARA		PDEO		PDEO		JINGRAM		RGEREMIA		JINGRAM		LPALMER		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		DMCCASTL		GTAYLOR		GTAYLOR		LPALMER		GTAYLOR		LPALMER		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		CAFILER		CAFILER		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11001		11003		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		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11001		11001		11003		11001		11003		11001		11003		11001		11003		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11003		11003
rpt_start		1995-07-01 00:00:00		1996-01-01 00:00:00		None		1996-07-01 00:00:00		1997-01-01 00:00:00		None		1998-01-01 00:00:00		None		1998-07-01 00:00:00		1999-01-01 00:00:00		None		1999-07-01 00:00:00		None		1982-01-01 00:00:00		1982-10-17 00:00:00		1983-03-18 00:00:00		1983-09-18 00:00:00		1984-03-18 00:00:00		1984-05-19 00:00:00		1984-07-01 00:00:00		1984-09-18 00:00:00		1986-01-01 00:00:00		1987-01-01 00:00:00		None		1988-07-01 00:00:00		1989-01-01 00:00:00		1989-07-01 00:00:00		1990-01-01 00:00:00		1990-07-01 00:00:00		1988-01-01 00:00:00		1988-01-01 00:00:00		None		1991-01-01 00:00:00		1991-07-01 00:00:00		1992-01-01 00:00:00		1992-01-01 00:00:00		1992-07-01 00:00:00		1993-01-01 00:00:00		1993-07-01 00:00:00		None		None		1994-01-01 00:00:00		1983-01-01 00:00:00		1984-01-01 00:00:00		1991-07-01 00:00:00		None		1994-07-01 00:00:00		1996-01-01 00:00:00		1983-07-01 00:00:00		1995-01-01 00:00:00		1999-10-01 00:00:00		None		None		None		2000-02-25 00:00:00		2000-01-01 00:00:00		2000-10-30 00:00:00		2000-10-30 00:00:00		None		2000-11-02 00:00:00		2000-07-01 00:00:00		2000-10-30 00:00:00		2000-07-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-10-01 00:00:00		2002-05-16 00:00:00		2002-02-27 00:00:00		None		None		2002-03-01 00:00:00		2002-03-04 00:00:00		2001-10-01 00:00:00		None		2002-01-01 00:00:00		None		2002-01-01 00:00:00		None		2002-10-31 00:00:00		2002-07-01 00:00:00		2003-01-01 00:00:00		2002-07-01 00:00:00		2003-09-26 00:00:00		None		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		None		None		2004-02-24 00:00:00		2004-01-01 00:00:00		2004-02-19 00:00:00		2004-01-01 00:00:00		2004-10-27 00:00:00		None		2004-11-01 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		2005-04-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2006-05-25 00:00:00		2006-01-01 00:00:00		2006-05-30 00:00:00		2006-10-24 00:00:00		2006-01-01 00:00:00		2006-11-02 00:00:00		None		2006-07-01 00:00:00		2007-01-01 00:00:00		None		2007-01-29 00:00:00		2006-07-01 00:00:00		None		None		2007-04-01 00:00:00		2007-01-01 00:00:00		None		2007-04-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2014-01-01 00:00:00		2014-05-29 00:00:00		2014-04-21 00:00:00		2013-01-01 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2014-10-30 00:00:00		2014-10-13 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		None		2008-10-21 00:00:00		2008-10-31 00:00:00		2008-07-01 00:00:00		None		2009-01-01 00:00:00		2009-01-01 00:00:00		2008-07-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2009-10-01 00:00:00		2010-05-26 00:00:00		None		2010-01-01 00:00:00		2010-10-20 00:00:00		2010-01-01 00:00:00		None		2010-07-01 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2014-03-18 00:00:00		2014-03-24 00:00:00		2013-07-01 00:00:00		2012-01-01 00:00:00		2015-01-29 00:00:00		2014-10-17 00:00:00		2014-08-25 00:00:00		2014-01-01 00:00:00		2014-09-03 00:00:00		2014-09-11 00:00:00		2012-07-01 00:00:00		2013-07-01 00:00:00		2014-03-18 00:00:00		2014-04-10 00:00:00		2013-03-07 00:00:00		2012-07-01 00:00:00		2015-07-01 00:00:00		2015-01-01 00:00:00		2018-05-15 00:00:00		2018-10-11 00:00:00		2017-01-01 00:00:00		2018-04-05 00:00:00		2018-10-11 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2019-07-01 00:00:00		2020-01-10 00:00:00		2018-04-19 00:00:00		2018-08-23 00:00:00		2017-10-01 00:00:00		2015-07-01 00:00:00		2016-01-28 00:00:00		2016-03-17 00:00:00		2016-03-28 00:00:00		2015-10-01 00:00:00		2015-10-01 00:00:00		2016-04-27 00:00:00		2016-05-09 00:00:00		2016-04-27 00:00:00		2016-05-13 00:00:00		2016-01-01 00:00:00		2016-06-27 00:00:00		2016-05-31 00:00:00		2016-01-01 00:00:00		2016-09-08 00:00:00		2016-08-15 00:00:00		2016-11-03 00:00:00		2016-10-07 00:00:00		2016-07-01 00:00:00		2017-01-30 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2019-04-01 00:00:00		2020-02-24 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2020-10-21 00:00:00		2018-05-08 00:00:00		2021-01-01 00:00:00		2018-03-19 00:00:00		2017-10-01 00:00:00		2019-10-01 00:00:00		2018-07-01 00:00:00		2017-07-01 00:00:00		2020-01-01 00:00:00		2017-07-01 00:00:00		2018-10-26 00:00:00		2020-01-01 00:00:00		2019-04-01 00:00:00		2019-10-01 00:00:00		2019-01-01 00:00:00		2019-07-01 00:00:00		2020-10-06 00:00:00		2020-07-01 00:00:00		2020-10-23 00:00:00		2020-07-01 00:00:00		2022-01-01 00:00:00		2022-05-16 00:00:00		2021-07-01 00:00:00		2022-05-27 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2022-08-23 00:00:00		2022-10-28 00:00:00		2022-10-13 00:00:00		2022-10-14 00:00:00
rpt_end		1995-12-31 00:00:00		1996-06-30 00:00:00		None		1996-12-31 00:00:00		1997-12-31 00:00:00		None		1998-06-30 00:00:00		None		1998-12-31 00:00:00		1999-06-30 00:00:00		None		1999-09-30 00:00:00		None		1982-10-16 00:00:00		1982-12-31 00:00:00		1983-06-30 00:00:00		1983-12-31 00:00:00		1984-05-19 00:00:00		1984-06-30 00:00:00		1984-09-17 00:00:00		1984-12-31 00:00:00		1986-12-31 00:00:00		1987-12-31 00:00:00		None		1988-12-31 00:00:00		1989-06-30 00:00:00		1989-12-31 00:00:00		1990-06-30 00:00:00		1990-12-31 00:00:00		1988-06-30 00:00:00		1988-06-30 00:00:00		None		1991-06-30 00:00:00		1991-12-31 00:00:00		1992-06-30 00:00:00		1992-06-30 00:00:00		1992-12-31 00:00:00		1993-06-30 00:00:00		1993-12-31 00:00:00		None		None		1994-06-30 00:00:00		1983-03-17 00:00:00		1984-03-17 00:00:00		1991-12-31 00:00:00		None		1994-12-31 00:00:00		1996-06-30 00:00:00		1983-09-17 00:00:00		1995-06-30 00:00:00		1999-12-31 00:00:00		None		None		None		2000-02-25 00:00:00		2000-06-30 00:00:00		2000-10-30 00:00:00		2000-10-30 00:00:00		None		2000-11-02 00:00:00		2000-12-31 00:00:00		2000-10-30 00:00:00		2000-12-31 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2002-05-16 00:00:00		2002-02-27 00:00:00		None		None		2002-03-01 00:00:00		2002-03-04 00:00:00		2001-12-31 00:00:00		None		2002-06-30 00:00:00		None		2002-06-30 00:00:00		None		2002-10-31 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2002-12-31 00:00:00		2003-09-26 00:00:00		None		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		None		None		2004-02-24 00:00:00		2004-06-30 00:00:00		2004-02-19 00:00:00		2004-06-30 00:00:00		2004-10-27 00:00:00		None		2004-11-01 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2005-03-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-05-25 00:00:00		2006-06-30 00:00:00		2006-05-30 00:00:00		2006-10-24 00:00:00		2006-06-30 00:00:00		2006-11-02 00:00:00		None		2006-12-31 00:00:00		2007-03-31 00:00:00		None		2007-01-29 00:00:00		2006-12-31 00:00:00		None		None		2007-06-30 00:00:00		2007-03-31 00:00:00		None		2007-06-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2014-05-29 00:00:00		2014-04-21 00:00:00		2013-06-30 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2014-10-30 00:00:00		2014-10-13 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		None		2008-10-21 00:00:00		2008-10-31 00:00:00		2008-12-31 00:00:00		None		2009-06-30 00:00:00		2009-06-30 00:00:00		2008-12-31 00:00:00		2009-09-30 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2010-05-26 00:00:00		None		2010-06-30 00:00:00		2010-10-20 00:00:00		2010-06-30 00:00:00		None		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2014-03-18 00:00:00		2014-03-24 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2015-01-29 00:00:00		2014-10-17 00:00:00		2014-08-25 00:00:00		2014-06-30 00:00:00		2014-09-03 00:00:00		2014-09-11 00:00:00		2012-12-31 00:00:00		2013-12-31 00:00:00		2014-03-18 00:00:00		2014-04-10 00:00:00		2013-03-07 00:00:00		2012-12-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2018-05-15 00:00:00		2018-10-11 00:00:00		2017-06-30 00:00:00		2018-04-05 00:00:00		2018-10-11 00:00:00		2018-06-30 00:00:00		2019-03-31 00:00:00		2019-09-30 00:00:00		2020-01-10 00:00:00		2018-04-19 00:00:00		2018-08-23 00:00:00		2017-12-31 00:00:00		2015-09-30 00:00:00		2016-01-28 00:00:00		2016-03-17 00:00:00		2016-03-28 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-04-27 00:00:00		2016-05-09 00:00:00		2016-04-27 00:00:00		2016-05-13 00:00:00		2016-06-30 00:00:00		2016-06-27 00:00:00		2016-05-31 00:00:00		2016-06-30 00:00:00		2016-09-08 00:00:00		2016-08-15 00:00:00		2016-11-03 00:00:00		2016-10-07 00:00:00		2016-12-31 00:00:00		2017-01-30 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2019-06-30 00:00:00		2020-02-24 00:00:00		2018-06-30 00:00:00		2018-12-31 00:00:00		2020-10-21 00:00:00		2018-05-08 00:00:00		2021-06-30 00:00:00		2018-03-19 00:00:00		2017-12-31 00:00:00		2019-12-31 00:00:00		2018-12-31 00:00:00		2017-09-30 00:00:00		2020-06-30 00:00:00		2017-09-30 00:00:00		2018-10-26 00:00:00		2020-06-30 00:00:00		2019-06-30 00:00:00		2019-12-31 00:00:00		2019-03-31 00:00:00		2019-09-30 00:00:00		2020-10-06 00:00:00		2020-12-31 00:00:00		2020-10-23 00:00:00		2020-12-31 00:00:00		2022-06-30 00:00:00		2022-05-16 00:00:00		2021-12-31 00:00:00		2022-05-27 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		2022-08-23 00:00:00		2022-10-28 00:00:00		2022-10-13 00:00:00		2022-10-14 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		2000-02-25 00:00:00		None		2000-10-30 00:00:00		None		2000-11-02 00:00:00		2000-11-02 00:00:00		2001-01-24 00:00:00		None		None		None		2001-10-05 00:00:00		None		2001-07-26 00:00:00		2002-01-03 00:00:00		2002-05-16 00:00:00		2002-02-27 00:00:00		None		None		2002-03-01 00:00:00		2002-03-04 00:00:00		None		None		None		None		2002-07-25 00:00:00		None		2002-10-31 00:00:00		None		2003-07-25 00:00:00		2003-01-30 00:00:00		2003-09-26 00:00:00		None		None		None		2003-10-02 00:00:00		None		2004-01-07 00:00:00		None		None		2004-02-24 00:00:00		2004-07-29 00:00:00		2004-02-19 00:00:00		None		2004-10-27 00:00:00		None		2004-11-01 00:00:00		None		2005-01-28 00:00:00		2005-04-25 00:00:00		None		2005-07-20 00:00:00		None		2006-01-27 00:00:00		None		2006-05-25 00:00:00		2006-07-25 00:00:00		2006-05-30 00:00:00		2006-10-24 00:00:00		None		2006-11-02 00:00:00		None		None		None		None		2007-01-29 00:00:00		2007-01-25 00:00:00		None		None		2007-07-25 00:00:00		2007-04-26 00:00:00		None		None		2013-07-31 00:00:00		2015-07-28 00:00:00		2014-07-30 00:00:00		2014-05-29 00:00:00		2014-04-21 00:00:00		None		2015-01-27 00:00:00		None		2014-10-30 00:00:00		2014-10-13 00:00:00		2008-01-28 00:00:00		None		2008-07-29 00:00:00		None		None		2008-10-21 00:00:00		2008-10-31 00:00:00		2009-01-27 00:00:00		None		2009-07-17 00:00:00		None		None		None		2009-10-22 00:00:00		None		2010-01-27 00:00:00		2010-05-26 00:00:00		None		2010-07-21 00:00:00		2010-10-20 00:00:00		None		None		None		2011-01-26 00:00:00		None		2012-01-24 00:00:00		2011-10-19 00:00:00		None		2012-07-25 00:00:00		2014-03-18 00:00:00		2014-03-24 00:00:00		2014-01-31 00:00:00		None		2015-01-29 00:00:00		2014-10-17 00:00:00		2014-08-25 00:00:00		None		2014-09-03 00:00:00		2014-09-11 00:00:00		2013-01-30 00:00:00		None		2014-03-18 00:00:00		2014-04-10 00:00:00		2013-03-07 00:00:00		None		None		None		2018-05-15 00:00:00		2018-10-11 00:00:00		None		2018-04-05 00:00:00		2018-10-11 00:00:00		2018-07-24 00:00:00		2019-04-17 00:00:00		None		2020-01-10 00:00:00		2018-04-19 00:00:00		2018-08-23 00:00:00		None		2015-10-29 00:00:00		2016-01-28 00:00:00		2016-03-17 00:00:00		2016-03-28 00:00:00		2016-01-19 00:00:00		None		2016-04-27 00:00:00		2016-05-09 00:00:00		2016-04-27 00:00:00		2016-05-13 00:00:00		None		2016-06-27 00:00:00		2016-05-31 00:00:00		2016-07-22 00:00:00		2016-09-08 00:00:00		2016-08-15 00:00:00		2016-11-03 00:00:00		2016-10-07 00:00:00		2017-01-26 00:00:00		2017-01-30 00:00:00		None		2017-07-21 00:00:00		2019-07-15 00:00:00		2020-02-24 00:00:00		None		None		2020-10-21 00:00:00		2018-05-08 00:00:00		2021-07-12 00:00:00		2018-03-19 00:00:00		2018-01-23 00:00:00		None		2019-01-17 00:00:00		2017-10-26 00:00:00		None		None		2018-10-26 00:00:00		2020-07-04 00:00:00		None		2020-01-22 00:00:00		None		2019-10-02 00:00:00		2020-10-06 00:00:00		2021-01-19 00:00:00		2020-10-23 00:00:00		None		2022-07-11 00:00:00		2022-05-16 00:00:00		None		2022-05-27 00:00:00		2022-01-20 00:00:00		None		None		2022-08-23 00:00:00		2022-10-28 00:00:00		2022-10-13 00:00:00		2022-10-14 00:00:00
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		22001		22001		22001		None		None		None		22001		None		22001		None		None		22001		22001		22001		None		22001		None		22001		None		22001		22001		None		22001		None		22001		None		22001		22001		22001		22001		None		22001		None		None		None		None		22001		22001		None		None		22001		22001		None		None		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		None		22001		None		None		22001		22001		22001		None		22001		None		None		None		22001		None		22001		22001		None		22001		22001		None		None		None		22001		None		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		None		None		None		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22006		22001		22001		22001		None		22006		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		None		22001		22001		22001		22001		22001		None		22001		22001		None		None		22001		22001		None		22001		None		22001		22001		22001		22001		None		22001		22001		None		22001		22001		None		None		22001		22001		22001		22001

Table: filer_to_filer_type

filer_id		1009728
filer_type		10
active		Y
race		0
session_id		2007
category		0
category_type		40502
sub_category		0
effect_dt		1990-12-01 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		0
county_cd		18004
district_cd		0

Table: filer_xref

filer_id		1009728
xref_id		482659
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		482659		482659		482659		482659
filer_id		1009728		1009728		1009728		1009728
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00
naml		NOSSAMAN LLP		NOSSAMAN LLP		NOSSAMAN GUTHNER KNOX & ELLIOTT LLP		NOSSAMAN GUTHNER KNOX & ELLIOTT LLP
namf		None		None		None		None
namt		None		None		None		None
nams		None		None		None		None
adr1		None		None		None		None
adr2		None		None		None		None
city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA
zip4		958140000		95814		958140000		95814
phon		9164428888		9164428888		9164428888		9164428888
fax		None		None		None		None
email		None		None		None		None

Table: filers

filer_id		1009728

Table: received_filings

filer_id		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728		1009728
filing_file_name		684300_0.cal		22249.cal		22268.cal		22504.cal		681216_0.cal		714142_0.cal		785834_0.cal		310678.cal		310812.cal		310833.cal		773118_0.cal		16834.cal		291427.cal		803603_0.cal		451831.cal		826792_0.cal		827870_0.cal		828524_0.cal		826792_1.cal		851813_0.cal		884415_0.cal		911756_0.cal		945314_0.cal		959993_0.cal		962532_0.cal		978703_0.cal		996858_0.cal		999840_0.cal		1058954_0.cal		1055119_0.cal		1174063_0.cal		1176422_0.cal		1210549_0.cal		1530410_0.cal		1504431_0.cal		1435957_0.cal		1350925_0.cal		1490292_0.cal		1451595_0.cal		1218681_0.cal		1368132_0.cal		1234105_0.cal		1284135_0.cal		1260847_0.cal		1463110_0.cal		1310878_0.cal		1378458_0.cal		500069.cal		1752417_0.cal		1739761_0.cal		255911.cal		1829775_0.cal		1829909_0.cal		1837632_0.cal		1831855_0.cal		1783521_0.cal		1818151_0.cal		86191.cal		1839806_0.cal		1620381_0.cal		1632581_0.cal		1675113_0.cal		1856540_0.cal		1870723_0.cal		1981255_0.cal		2127373_0.cal		2047884_0.cal		2052854_0.cal		2058770_0.cal		2005878_0.cal		1997631_0.cal		2075216_0.cal		2104488_0.cal		2086648_0.cal		1884585_0.cal		1880442_0.cal		1882151_0.cal		2023924_0.cal		2040954_0.cal		2021260_0.cal		1897229_0.cal		1899735_0.cal		1909349_0.cal		281599.cal		2068392_0.cal		511905.cal		2042711_0.cal		2033621_0.cal		1935534_0.cal		1933045_0.cal		2305209_0.cal		2249446_0.cal		2305209_1.cal		2228543_0.cal		2232817_0.cal		2285886_0.cal		2247422_0.cal		2429575_0.cal		2223238_0.cal		2457018_0.cal		2313901_0.cal		2733369_0.cal		2519839_0.cal		2682857_0.cal		2732751_0.cal		2687912_0.cal		2745005_0.cal		2510717_0.cal		2522154_0.cal
received_date		2000-11-02 00:00:00		2000-10-30 00:00:00		2000-10-30 00:00:00		2000-10-30 00:00:00		2000-10-30 00:00:00		2001-01-24 00:00:00		2001-10-10 00:00:00		2001-08-02 00:00:00		2001-08-02 00:00:00		2001-08-02 00:00:00		2001-07-31 00:00:00		2001-10-24 00:00:00		2002-01-04 00:00:00		2002-01-07 00:00:00		2002-02-27 00:00:00		2002-02-27 00:00:00		2002-03-01 00:00:00		2002-03-04 00:00:00		2002-05-16 00:00:00		2002-07-25 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2003-07-28 00:00:00		2003-09-26 00:00:00		2003-10-08 00:00:00		2004-01-08 00:00:00		2004-02-19 00:00:00		2004-02-24 00:00:00		2004-11-01 00:00:00		2004-10-27 00:00:00		2006-05-25 00:00:00		2006-05-30 00:00:00		2006-10-24 00:00:00		2010-10-20 00:00:00		2010-07-28 00:00:00		2009-07-29 00:00:00		2008-07-31 00:00:00		2010-05-26 00:00:00		2009-10-29 00:00:00		2006-11-02 00:00:00		2008-10-21 00:00:00		2007-01-29 00:00:00		2007-07-31 00:00:00		2007-04-27 00:00:00		2010-01-29 00:00:00		2008-01-31 00:00:00		2008-10-31 00:00:00		2013-03-07 00:00:00		2013-03-07 00:00:00		2013-01-31 00:00:00		2013-04-01 00:00:00		2014-03-18 00:00:00		2014-03-18 00:00:00		2014-04-10 00:00:00		2014-03-24 00:00:00		2013-07-31 00:00:00		2014-01-31 00:00:00		2014-03-14 00:00:00		2014-04-21 00:00:00		2011-10-27 00:00:00		2012-01-26 00:00:00		2012-07-26 00:00:00		2014-05-29 00:00:00		2014-07-30 00:00:00		2015-07-30 00:00:00		2017-01-30 00:00:00		2016-05-31 00:00:00		2016-06-27 00:00:00		2016-07-26 00:00:00		2016-01-24 00:00:00		2015-10-31 00:00:00		2016-09-08 00:00:00		2016-11-03 00:00:00		2016-10-07 00:00:00		2014-09-11 00:00:00		2014-08-25 00:00:00		2014-09-03 00:00:00		2016-03-28 00:00:00		2016-05-09 00:00:00		2016-03-17 00:00:00		2014-10-13 00:00:00		2014-10-17 00:00:00		2014-10-30 00:00:00		2016-08-15 00:00:00		2016-08-15 00:00:00		2016-08-29 00:00:00		2016-05-13 00:00:00		2016-04-27 00:00:00		2015-01-31 00:00:00		2015-01-29 00:00:00		2018-10-11 00:00:00		2018-05-15 00:00:00		2018-10-11 00:00:00		2018-04-05 00:00:00		2018-04-19 00:00:00		2018-08-23 00:00:00		2018-05-08 00:00:00		2020-01-10 00:00:00		2018-03-19 00:00:00		2020-02-24 00:00:00		2018-10-26 00:00:00		2022-10-14 00:00:00		2020-10-21 00:00:00		2022-05-16 00:00:00		2022-10-13 00:00:00		2022-05-27 00:00:00		2022-10-28 00:00:00		2020-10-06 00:00:00		2020-10-23 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/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/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/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/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		684300		None		None		None		681216		714142		785834		None		None		None		773118		None		None		803603		None		826792		827870		828524		826792		851813		884415		911756		945314		959993		962532		978703		996858		999840		1058954		1055119		1174063		1176422		1210549		1530410		1504431		1435957		1350925		1490292		1451595		1218681		1368132		1234105		1284135		1260847		1463110		1310878		1378458		None		1752417		1739761		None		1829775		1829909		1837632		1831855		1783521		1818151		None		1839806		1620381		1632581		1675113		1856540		1870723		1981255		2127373		2047884		2052854		2058770		2005878		1997631		2075216		2104488		2086648		1884585		1880442		1882151		2023924		2040954		2021260		1897229		1899735		1909349		None		2068392		None		2042711		2033621		1935534		1933045		2305209		2249446		2305209		2228543		2232817		2285886		2247422		2429575		2223238		2457018		2313901		2733369		2519839		2682857		2732751		2687912		2745005		2510717		2522154
form_id		F497		None		None		None		F497		F461		F461		None		None		None		F461		None		None		F461		None		F497		F497		F497		F497		F461		F497		F461		F461		F497		F461		F461		F497		F497		F497		F497		F497		F497		F497		F497		F461		F461		F461		F497		F461		F497		F497		F497		F461		F461		F461		F461		F497		None		F497		F461		None		F497		F497		F497		F497		F461		F461		None		F497		F461		F461		F461		F497		F461		F461		F497		F497		F497		F461		F461		F461		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		None		F497		F497		F461		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing accepted, but with warnings		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		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 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 accepted		Filing accepted		Filing passed validation, but failed DB constraints		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 accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted