Home

Filer ID: 1026242

Table: filer_address

filer_id		1026242		1026242		1026242		1026242		1026242		1026242		1026242
adrid		1024264		2157328		2157329		2481197		2481198		2360454		2360453
effect_dt		2002-07-31 00:00:00		1979-01-01 00:00:00		1979-01-01 00:00:00		2019-06-07 00:00:00		2019-06-07 00:00:00		2015-03-26 00:00:00		2015-03-26 00:00:00
add_type		7051		7051		7082		7051		7082		7082		7051
session_id		1979		1979		1979		2019		2019		2015		2015

Table: filer_filings

filer_id		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242
filing_id		156205		156206		156207		156208		156209		156210		156152		156153		156154		156155		156156		156157		156158		156159		156160		156161		156162		156163		156164		156165		156166		156167		156168		156169		156170		156171		156172		156173		156174		156175		156176		156177		156178		156179		156181		156182		156183		156184		156185		156186		156187		156188		156189		156190		156191		156192		156193		156194		156195		156196		156197		156198		156199		156200		156201		156202		156203		156204		156211		156212		156213		156214		156215		156216		156217		156218		156219		156220		156221		156222		156223		156224		156225		156226		156227		156228		156229		156230		156231		156232		156233		156234		156235		156236		156237		156238		156239		156240		156241		216544		216545		216546		216547		216548		216549		216550		216551		216552		216553		216554		216555		216556		216557		156180		582520		621354		647844		681441		723051		775516		771137		807294		828485		864855		864855		866746		857197		915264		909190		945616		857197		950833		982357		980318		999451		996253		1024699		1030556		1045248		1053977		1047001		1056654		1077757		1116565		1087780		1119618		1147137		1149574		1188371		1205633		1204006		1191171		1211778		1234633		1248590		1239596		1248590		866746		1281765		1283409		1274191		1776183		1784147		1946866		1978451		1863782		1862229		1955523		1957847		1943223		1309270		1313080		1349893		1334513		1337018		1364244		1353134		1369747		1369114		1362750		1371092		1368029		1388015		1376097		1402443		1399325		1397379		1425873		1425877		1437075		1388015		1447000		1439989		1445592		1466601		1463574		1388015		1506015		1494394		1491116		1477197		1474182		1475503		1489459		1510272		1522111		1489626		1477356		1528216		1530085		1532506		1566753		1570471		1602462		1613871		1594804		1630167		1629250		1618285		1600889		1652043		1676178		1662952		1665671		1672175		1810263		1692169		1693431		1696815		1698550		1683086		1709954		1701928		1724898		1729251		1821288		1810263		1821288		1929895		2003873		1986445		2436944		2277552		2386657		2479280		2334092		2204513		2395408		2006843		1999415		2030713		2056336		2084949		2065870		2117428		2125181		2172438		2167183		2216608		2390155		2444768		2562309		2266807		2355059		2604585		2647303		2480171		2597687		2637087		2700931		2544945		2716533		2737968
period_id		118		119		121		122		124		122		86		77		79		79		80		85		87		89		87		90		91		91		89		92		93		94		93		91		96		95		96		97		101		101		101		100		101		101		102		103		105		106		105		106		108		108		110		109		109		111		111		112		114		114		115		116		116		113		116		116		116		118		124		127		128		125		121		130		129		131		131		133		133		137		135		137		139		141		143		145		148		0		148		147		149		151		153		156		156		156		155		155		160		77		79		89		101		103		105		107		117		123		125		127		151		155		157		102		None		None		None		None		None		None		None		None		None		171		171		None		None		None		171		173		None		None		None		175		None		177		177		None		179		180		None		None		180		181		None		None		183		None		185		None		187		None		188		188		189		None		189		None		None		189		None		213		None		221		221		None		217		222		None		None		191		None		194		193		None		None		None		None		196		195		None		196		197		196		None		None		196		None		None		197		199		None		None		None		None		199		199		202		None		201		202		201		None		202		None		203		None		None		None		204		None		204		None		None		None		206		None		207		208		205		210		211		209		None		210		215		211		211		None		212		None		None		212		212		None		None		215		None		219		223		None		239		None		None		241		235		231		None		None		224		None		225		None		None		227		None		None		229		None		237		None		None		233		None		None		None		None		245		247		249		243		None		None
form_id		F405		F420		F420		F420		F405		F405		F405		F405		F420		F420		F450		F450		F450		F450		F405		F450		F450		F450		F405		F450		F450		F405		F450		F450		F405		F405		F450		F405		F420		F405		F777		F405		F450		F405		F405		F450		F450		F405		F450		F450		F450		F450		F405		F420		F405		F405		F420		F420		F405		F420		F420		F420		F777		F420		F777		F420		F405		F405		F420		F405		F405		F405		F420		F405		F420		F420		F405		F405		F420		F405		F420		F420		F420		F420		F420		F420		F497		F405		F405		F420		F420		F420		F420		F495		F420		F495		F420		F405		F497		F410		F405		F405		F405		F450		F405		F450		F420		F420		F420		F420		F405		F420		F420		F450		F450		F410		F460		F460		F460		F460		F410		F460		F460		F497		F497		F410		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		F497		F460		F497		F410		F460		F460		F497		F460		F460		F497		F460		F460		F460		F497		F410		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F497		F410		F497		F410		F460		F460		F460		F460		F460		F410		F410		F460		F410		F460		F460		F410		F460		F460		F460		F497		F460		F460		F497		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F410		F497		F460		F460		F497		F460		F497		F497		F460		F460		F460		F460		F497		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F497		F410		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		0		0		0		0		0		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		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1989-05-31 00:00:00		1990-01-29 00:00:00		1990-05-24 00:00:00		1990-07-13 00:00:00		1990-10-12 00:00:00		1991-01-22 00:00:00		1981-04-01 00:00:00		1979-04-10 00:00:00		1979-08-13 00:00:00		1979-10-24 00:00:00		1980-01-07 00:00:00		1981-08-20 00:00:00		1982-01-27 00:00:00		1982-05-27 00:00:00		1982-05-27 00:00:00		1982-07-15 00:00:00		1982-09-21 00:00:00		1982-10-19 00:00:00		1982-10-22 00:00:00		1983-01-18 00:00:00		1983-03-22 00:00:00		1983-04-14 00:00:00		1983-07-26 00:00:00		1983-10-27 00:00:00		1983-11-03 00:00:00		1983-12-09 00:00:00		1984-01-27 00:00:00		1984-02-06 00:00:00		1985-03-22 00:00:00		1985-03-25 00:00:00		1985-03-07 00:00:00		1985-04-23 00:00:00		1985-05-22 00:00:00		1985-07-01 00:00:00		1986-01-13 00:00:00		1986-01-29 00:00:00		1986-03-22 00:00:00		1986-05-12 00:00:00		1986-05-21 00:00:00		1986-07-29 00:00:00		1986-10-21 00:00:00		1987-02-13 00:00:00		1987-04-21 00:00:00		1987-07-27 00:00:00		1987-10-20 00:00:00		1987-11-10 00:00:00		1987-10-20 00:00:00		1988-02-01 00:00:00		1988-04-28 00:00:00		1988-07-08 00:00:00		1988-10-04 00:00:00		1988-10-25 00:00:00		1988-10-26 00:00:00		1988-05-31 00:00:00		1988-10-31 00:00:00		1989-02-01 00:00:00		1989-03-24 00:00:00		1989-04-05 00:00:00		1991-01-22 00:00:00		1991-09-03 00:00:00		1991-12-02 00:00:00		1992-01-13 00:00:00		1992-02-28 00:00:00		1992-06-08 00:00:00		1992-08-27 00:00:00		1993-03-13 00:00:00		1993-03-19 00:00:00		1993-03-23 00:00:00		1993-08-02 00:00:00		1994-03-08 00:00:00		1994-03-04 00:00:00		1994-08-02 00:00:00		1995-01-31 00:00:00		1995-07-31 00:00:00		1996-01-31 00:00:00		1996-07-31 00:00:00		1996-10-29 00:00:00		1996-10-29 00:00:00		1996-12-20 00:00:00		1997-01-31 00:00:00		1997-07-30 00:00:00		1998-02-02 00:00:00		1998-07-31 00:00:00		1998-10-15 00:00:00		1998-10-27 00:00:00		1998-10-27 00:00:00		1999-02-01 00:00:00		1999-08-04 00:00:00		1999-10-18 00:00:00		1979-03-02 00:00:00		1979-11-23 00:00:00		1982-01-27 00:00:00		1985-04-29 00:00:00		1985-09-23 00:00:00		1986-03-22 00:00:00		1986-10-03 00:00:00		1989-07-28 00:00:00		1990-10-25 00:00:00		1991-08-23 00:00:00		1992-02-28 00:00:00		1997-08-01 00:00:00		1998-10-15 00:00:00		1999-08-02 00:00:00		1985-07-22 00:00:00		2000-01-10 00:00:00		2000-03-16 00:00:00		2000-07-28 00:00:00		2000-10-26 00:00:00		2001-01-30 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2002-01-10 00:00:00		2002-02-21 00:00:00		2002-08-26 00:00:00		2002-08-22 00:00:00		2002-07-31 00:00:00		2002-07-31 00:00:00		2003-01-31 00:00:00		2003-01-29 00:00:00		2003-07-29 00:00:00		2003-01-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-02-18 00:00:00		2004-07-21 00:00:00		2004-07-30 00:00:00		2004-10-05 00:00:00		2004-10-26 00:00:00		2004-10-05 00:00:00		2004-10-26 00:00:00		2005-01-27 00:00:00		2005-07-28 00:00:00		2005-01-31 00:00:00		2005-08-01 00:00:00		2006-01-30 00:00:00		2006-01-31 00:00:00		2006-07-27 00:00:00		2006-10-05 00:00:00		2006-10-04 00:00:00		2006-07-28 00:00:00		2006-10-25 00:00:00		2007-01-29 00:00:00		2007-02-26 00:00:00		2007-01-31 00:00:00		2007-02-26 00:00:00		2007-05-18 00:00:00		2007-07-26 00:00:00		2007-07-30 00:00:00		2007-02-26 00:00:00		2013-07-17 00:00:00		2013-07-26 00:00:00		2015-02-25 00:00:00		2015-07-28 00:00:00		2014-07-14 00:00:00		2014-07-10 00:00:00		2015-04-01 00:00:00		2015-03-26 00:00:00		2015-01-27 00:00:00		2008-01-30 00:00:00		2008-01-31 00:00:00		2008-07-30 00:00:00		2008-05-21 00:00:00		2008-05-22 00:00:00		2008-10-06 00:00:00		2008-07-31 00:00:00		2008-10-21 00:00:00		2008-10-22 00:00:00		2008-10-06 00:00:00		2008-10-23 00:00:00		2008-10-21 00:00:00		2009-01-08 00:00:00		2008-10-30 00:00:00		2009-01-12 00:00:00		2009-02-02 00:00:00		2009-02-02 00:00:00		2006-10-26 00:00:00		2006-01-31 00:00:00		2009-07-30 00:00:00		2009-09-22 00:00:00		2009-09-24 00:00:00		2009-07-29 00:00:00		2009-08-11 00:00:00		2010-02-01 00:00:00		2010-01-29 00:00:00		2009-08-06 00:00:00		2010-07-30 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-04-01 00:00:00		2010-03-22 00:00:00		2010-03-22 00:00:00		2010-05-24 00:00:00		2010-08-02 00:00:00		2010-10-05 00:00:00		2010-05-24 00:00:00		2010-04-02 00:00:00		2010-10-05 00:00:00		2010-10-20 00:00:00		2010-10-20 00:00:00		2011-01-26 00:00:00		2011-01-27 00:00:00		2011-07-22 00:00:00		2011-08-22 00:00:00		2011-05-19 00:00:00		2012-01-20 00:00:00		2012-01-18 00:00:00		2011-10-19 00:00:00		2011-07-18 00:00:00		2012-04-13 00:00:00		2012-07-27 00:00:00		2012-05-23 00:00:00		2012-05-24 00:00:00		2012-07-17 00:00:00		2014-01-15 00:00:00		2012-09-29 00:00:00		2012-10-03 00:00:00		2012-10-05 00:00:00		2012-10-15 00:00:00		2012-07-30 00:00:00		2012-10-25 00:00:00		2012-10-23 00:00:00		2013-01-14 00:00:00		2013-01-17 00:00:00		2014-02-06 00:00:00		2014-02-05 00:00:00		2014-01-28 00:00:00		2015-01-26 00:00:00		2016-01-14 00:00:00		2015-07-30 00:00:00		2020-01-28 00:00:00		2018-07-31 00:00:00		2019-06-07 00:00:00		2020-07-19 00:00:00		2019-01-14 00:00:00		2018-01-23 00:00:00		2019-07-22 00:00:00		2016-01-20 00:00:00		2015-11-10 00:00:00		2016-04-15 00:00:00		2016-07-19 00:00:00		2016-09-26 00:00:00		2016-07-21 00:00:00		2017-01-05 00:00:00		2017-01-12 00:00:00		2017-07-21 00:00:00		2017-07-13 00:00:00		2018-01-31 00:00:00		2019-07-15 00:00:00		2020-01-30 00:00:00		2021-01-22 00:00:00		2018-07-19 00:00:00		2019-01-18 00:00:00		2021-07-28 00:00:00		2022-01-26 00:00:00		2020-07-20 00:00:00		2021-07-27 00:00:00		2022-01-24 00:00:00		2022-07-25 00:00:00		2021-01-18 00:00:00		2022-08-30 00:00:00		2022-07-29 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		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		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10002		10005		10005		10005		10005		10002		10005		10005		10002		10001		10002		10005		10005		10001		10001		10006		10005		10005		10001		10005		10001		10001		10005		10001		10001		10005		10005		10001		10001		10005		10005		10001		10005		10001		10002		10001		10005		10001		10001		10001		10005		10002		10006		10005		10001		10005		10001		10005		10001		10001		10005		10001		10001		10006		10005		10001		10005		10001		10001		10005		10005		10005		10005		10001		10001		10005		10001		10001		10001		10006		10005		10001		10005		10005		10001		10002		10006		10005		10006		10005		10001		10002		10001		10005		10001		10001		10001		10005		10001		10005		10001		10005		10005		10005		10001		10005		10001		10005		10005		10006		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10005		10001		10005		10005		10001		10001		10005		10006		10002		10005		10001		10001		10005		10001		10005		10006		10001		10001		10001		10005		10005		10001		10006		10001		10006		10005		10001		10005		10005		10001		10005		10001		10005		10005		10001		10005		10005		10005		10005		10001		10001		10001		10001		10006		10005
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11001		11001		11003		11001		11003		11001		11003		11001		11003		11003		11001		11001		11003		11001		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11001		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11003		11003		11003		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		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003
session_id		1989		1989		1989		1989		1989		1989		1981		1979		1979		1979		1979		1981		1981		1981		1981		1981		1981		1981		1981		1981		1983		1983		1983		1981		1983		1983		1983		1983		1985		1985		1985		1983		1985		1985		1985		1985		1985		1985		1985		1985		1985		1985		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1989		1989		1991		1991		1991		1989		1991		1991		1991		1991		1993		1993		1993		1993		1993		1993		1995		1995		1995		1995		1911		1995		1995		1997		1997		1997		1997		1997		1997		1997		1997		1999		1979		1979		1981		1985		1985		1985		1985		1989		1989		1991		1991		1997		1997		1999		1985		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2007		2001		2007		2007		2007		2013		2013		2015		2015		2013		2013		2015		2015		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2007		2009		2009		2007		2005		2005		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		2011		2011		2011		2013		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2015		2015		2019		2017		2019		2019		2017		2017		2019		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2019		2019		2021		2017		2017		2021		2021		2019		2021		2021		2021		2019		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		KCHAN		TWALLS		SARRIAGA		TTHAM		MHOANG		DBARRICK		*		*		TTHAM		DBARRICK		DBARRICK		COMPLETED		COMPLETED		DBARRICK		GGILMORE		MHOANG		COMPLETED		KLARRY		COMPLETED		COMPLETED		TTHAM		COMPLETED		GKURIMOT		CFLAGG		GPEREZ		COMPLETED		*		SARRIAGA		GPEREZ		*		CFLAGG		*		SARRIAGA		*		GPEREZ		*		*		LHOANG		GPEREZ		*		EMCENTEE		SARRIAGA		*		LHOANG		CAFILER		MPACHECO		WBROWN		SARRIAGA		MPACHECO		CAFILER		WBROWN		TRAMON		GCLARA		*		CFLAGG		*		*		SARRIAGA		RGEREMIA		RGEREMIA		YRODRIGU		*		*		RGEREMIA		DHORRELL		*		DHORRELL		RGEREMIA		MMORENO		MMORENO		FAZAM		FAZAM		MMORENO		*		RGEREMIA		MMORENO		RGEREMIA		CPON		CPON		*		*		MMORENO		MMORENO		DHORRELL		MMORENO		MMORENO		DHORRELL		SARRIAGA		CPON		GKURIMOT		DHORRELL		CPON		MMORENO		MMORENO		SMCCONNAN		SMCCONNAN		SMCCONNAN		TRAMON		PBANFORD		SMCCONNAN		SMCCONNAN		CREYNOLDS		SMCCONNAN		CREYNOLDS		CAFILER		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		CPON		CAFILER		CPON		CPON		CAFILER		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		CAFILER		MPACHECO		MPACHECO		CAFILER		CPON		CAFILER		MDIGRAZIA		SARRIAGA		LFEDOROV		BSINGH		JFRONEFIELD		VUKSTINA		VUKSTINA		CSAGABAEN		VUKSTINA		MDIGRAZIA		WBROWN		DHOANG		SARRIAGA		TRAMON		SARRIAGA		SARRIAGA		SARRIAGA		LBARTHOL		LBARTHOL		CSAGABAEN		VUKSTINA		LFEDOROV		SUSHAKOV		BSINGH		VUKSTINA		BCOLON		KRUSSELL		VUKSTINA		BCOLON		KRUSSELL		CAFILER		SUSHAKOV		IMEDINA		JMAVES
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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
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		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		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		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		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11001		11001		11003		11003		11001		11003		11003		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		None		1989-07-01 00:00:00		1990-01-01 00:00:00		1990-05-20 00:00:00		None		1990-05-20 00:00:00		None		1979-01-01 00:00:00		1979-07-31 00:00:00		1979-09-03 00:00:00		1979-10-22 00:00:00		1981-01-01 00:00:00		1981-09-18 00:00:00		1982-03-18 00:00:00		1981-09-18 00:00:00		1982-05-23 00:00:00		1982-07-01 00:00:00		1982-09-18 00:00:00		1982-03-18 00:00:00		1982-10-17 00:00:00		1983-01-01 00:00:00		None		1983-03-17 00:00:00		1982-09-18 00:00:00		None		1983-07-01 00:00:00		1983-10-23 00:00:00		None		1985-01-01 00:00:00		None		None		1984-10-21 00:00:00		1985-03-18 00:00:00		1985-01-01 00:00:00		1985-05-19 00:00:00		1985-09-18 00:00:00		1986-01-01 00:00:00		None		1986-03-18 00:00:00		1986-05-18 00:00:00		1986-10-01 00:00:00		1986-10-18 00:00:00		None		1987-01-01 00:00:00		1987-01-01 00:00:00		1987-07-01 00:00:00		1987-07-01 00:00:00		1987-10-18 00:00:00		None		1988-05-22 00:00:00		1988-07-01 00:00:00		1988-10-01 00:00:00		None		1988-01-01 00:00:00		None		1988-10-23 00:00:00		1988-10-01 00:00:00		None		1990-10-21 00:00:00		None		None		1991-01-01 00:00:00		1990-01-01 00:00:00		None		1992-01-01 00:00:00		1992-07-01 00:00:00		1992-07-01 00:00:00		None		1993-01-01 00:00:00		None		1993-07-01 00:00:00		1994-01-01 00:00:00		1994-07-01 00:00:00		1995-01-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		None		None		None		1996-07-01 00:00:00		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-01-01 00:00:00		None		1998-10-01 00:00:00		None		1998-07-01 00:00:00		1998-07-01 00:00:00		None		None		1979-09-03 00:00:00		None		1985-01-01 00:00:00		1985-07-01 00:00:00		None		1986-07-01 00:00:00		1989-01-01 00:00:00		1990-07-01 00:00:00		1991-01-01 00:00:00		1991-07-01 00:00:00		None		1998-07-01 00:00:00		1999-01-01 00:00:00		1985-05-18 00:00:00		1999-07-01 00:00:00		None		2000-01-01 00:00:00		2000-10-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		1998-10-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2002-08-26 00:00:00		2002-08-22 00:00:00		None		2002-02-17 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2003-01-01 00:00:00		2002-02-17 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2004-01-01 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-10-26 00:00:00		2004-07-01 00:00:00		None		2004-10-01 00:00:00		2005-01-01 00:00:00		2004-10-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-07-01 00:00:00		2006-07-01 00:00:00		2006-01-01 00:00:00		2006-10-01 00:00:00		2006-10-22 00:00:00		2007-02-26 00:00:00		2006-10-22 00:00:00		2007-02-26 00:00:00		None		2007-01-01 00:00:00		2007-01-01 00:00:00		None		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-02-25 00:00:00		2015-01-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2015-04-01 00:00:00		None		2014-07-01 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		2008-05-18 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2008-05-18 00:00:00		None		2008-10-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-10-21 00:00:00		2009-01-08 00:00:00		2008-10-30 00:00:00		None		2008-10-19 00:00:00		2008-10-19 00:00:00		2006-10-01 00:00:00		2005-07-01 00:00:00		2009-01-01 00:00:00		2009-09-22 00:00:00		None		2009-01-01 00:00:00		None		2009-07-01 00:00:00		2009-07-01 00:00:00		2009-08-06 00:00:00		2010-05-23 00:00:00		2010-03-18 00:00:00		2010-03-18 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-05-24 00:00:00		2010-05-23 00:00:00		2010-07-01 00:00:00		None		None		2010-07-01 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		2010-10-17 00:00:00		2010-10-17 00:00:00		2011-01-01 00:00:00		None		2011-05-19 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2011-10-19 00:00:00		2011-01-01 00:00:00		2012-04-13 00:00:00		2012-07-27 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-05-20 00:00:00		2013-07-01 00:00:00		2012-08-30 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2012-10-15 00:00:00		2012-05-20 00:00:00		2012-10-01 00:00:00		2012-10-01 00:00:00		2012-10-21 00:00:00		2012-10-21 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2014-07-01 00:00:00		2015-07-01 00:00:00		2015-01-01 00:00:00		2019-07-01 00:00:00		2018-01-01 00:00:00		None		2020-01-01 00:00:00		2018-07-01 00:00:00		2017-07-01 00:00:00		2019-01-01 00:00:00		2015-07-01 00:00:00		2015-11-10 00:00:00		None		2016-01-01 00:00:00		None		2016-01-01 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-07-01 00:00:00		2019-01-01 00:00:00		2019-07-01 00:00:00		2020-07-01 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2020-01-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2020-07-01 00:00:00		None		2022-01-01 00:00:00
rpt_end		None		1989-12-31 00:00:00		1990-05-19 00:00:00		1990-06-30 00:00:00		None		1990-06-30 00:00:00		None		1979-12-31 00:00:00		1979-08-06 00:00:00		1979-10-22 00:00:00		1980-01-03 00:00:00		1981-07-30 00:00:00		1981-12-31 00:00:00		1982-05-22 00:00:00		1981-12-31 00:00:00		1982-06-30 00:00:00		1982-09-17 00:00:00		1982-10-16 00:00:00		1982-05-22 00:00:00		1982-12-31 00:00:00		1983-03-17 00:00:00		None		1983-06-30 00:00:00		1983-10-22 00:00:00		None		1983-10-22 00:00:00		1983-12-31 00:00:00		None		1985-03-17 00:00:00		None		None		1984-12-31 00:00:00		1985-05-18 00:00:00		1985-03-17 00:00:00		1985-06-30 00:00:00		1985-12-30 00:00:00		1986-03-17 00:00:00		None		1986-05-18 00:00:00		1986-06-30 00:00:00		1986-10-18 00:00:00		1986-12-31 00:00:00		None		1987-06-30 00:00:00		1987-06-30 00:00:00		1987-10-17 00:00:00		1987-10-17 00:00:00		1987-12-31 00:00:00		None		1988-06-30 00:00:00		1988-09-30 00:00:00		1988-10-22 00:00:00		None		1988-05-21 00:00:00		None		1988-12-31 00:00:00		1988-10-22 00:00:00		None		1990-12-31 00:00:00		None		None		1991-06-30 00:00:00		1992-02-02 00:00:00		None		1992-06-30 00:00:00		1992-12-31 00:00:00		1992-12-31 00:00:00		None		1993-06-30 00:00:00		None		1993-12-31 00:00:00		1994-06-30 00:00:00		1994-12-31 00:00:00		1995-06-30 00:00:00		1995-12-31 00:00:00		1996-06-30 00:00:00		None		None		None		1996-12-31 00:00:00		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-06-30 00:00:00		None		1998-10-22 00:00:00		None		1998-12-31 00:00:00		1998-12-31 00:00:00		None		None		1979-11-22 00:00:00		None		1985-03-17 00:00:00		1985-09-17 00:00:00		None		1986-09-30 00:00:00		1989-06-30 00:00:00		1990-10-20 00:00:00		1991-06-30 00:00:00		1991-12-31 00:00:00		None		1998-09-30 00:00:00		1999-06-30 00:00:00		1985-06-30 00:00:00		1999-12-31 00:00:00		None		2000-06-30 00:00:00		2000-10-26 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		1998-10-01 00:00:00		2001-12-31 00:00:00		2002-02-16 00:00:00		2002-08-26 00:00:00		2002-08-22 00:00:00		None		2002-06-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2002-06-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-02-14 00:00:00		2004-02-14 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-10-26 00:00:00		2004-09-30 00:00:00		None		2004-12-31 00:00:00		2005-06-30 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-09-30 00:00:00		2006-06-30 00:00:00		2006-10-21 00:00:00		2006-12-31 00:00:00		2007-02-26 00:00:00		2006-12-31 00:00:00		2007-02-26 00:00:00		None		2007-06-30 00:00:00		2007-06-30 00:00:00		None		2013-06-30 00:00:00		2013-06-30 00:00:00		2015-02-25 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2015-04-01 00:00:00		None		2014-12-31 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-05-17 00:00:00		2008-05-17 00:00:00		2008-09-30 00:00:00		2008-06-30 00:00:00		None		2008-10-18 00:00:00		2008-09-30 00:00:00		2008-10-18 00:00:00		2008-10-21 00:00:00		2009-01-08 00:00:00		2008-10-30 00:00:00		None		2008-12-31 00:00:00		2008-12-31 00:00:00		2006-10-21 00:00:00		2005-12-31 00:00:00		2009-06-30 00:00:00		2009-09-22 00:00:00		None		2009-06-30 00:00:00		None		2009-12-31 00:00:00		2009-12-31 00:00:00		2009-08-06 00:00:00		2010-06-30 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		2010-04-01 00:00:00		2010-03-17 00:00:00		2010-03-17 00:00:00		2010-05-24 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		None		None		2010-09-30 00:00:00		2010-10-16 00:00:00		2010-10-16 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		None		2011-05-19 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2011-10-19 00:00:00		2011-06-30 00:00:00		2012-04-13 00:00:00		2012-07-27 00:00:00		2012-05-19 00:00:00		2012-05-19 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2012-08-30 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2012-10-15 00:00:00		2012-06-30 00:00:00		2012-10-20 00:00:00		2012-10-20 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2015-12-31 00:00:00		2015-06-30 00:00:00		2019-12-31 00:00:00		2018-06-30 00:00:00		None		2020-06-30 00:00:00		2018-12-31 00:00:00		2017-12-31 00:00:00		2019-06-30 00:00:00		2015-12-31 00:00:00		2015-11-10 00:00:00		None		2016-06-30 00:00:00		None		2016-06-30 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		2017-12-31 00:00:00		2019-06-30 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		2018-06-30 00:00:00		2018-12-31 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2020-06-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2020-12-31 00:00:00		None		2022-06-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2002-08-26 00:00:00		2002-08-22 00:00:00		None		None		None		2003-01-29 00:00:00		2003-07-22 00:00:00		None		None		None		2004-01-12 00:00:00		None		2004-02-16 00:00:00		2004-07-19 00:00:00		None		2004-10-05 00:00:00		2004-10-26 00:00:00		None		None		2005-01-27 00:00:00		2005-07-28 00:00:00		None		None		2006-01-18 00:00:00		None		2006-07-20 00:00:00		None		2006-10-03 00:00:00		None		2006-10-21 00:00:00		2007-01-29 00:00:00		2007-02-26 00:00:00		None		2007-02-26 00:00:00		None		None		2007-07-18 00:00:00		None		2013-07-17 00:00:00		None		2015-02-25 00:00:00		2015-07-23 00:00:00		None		2014-07-10 00:00:00		2015-04-01 00:00:00		None		None		2008-01-22 00:00:00		None		2008-07-21 00:00:00		2008-05-21 00:00:00		None		None		None		None		2008-10-20 00:00:00		2008-10-02 00:00:00		None		2008-10-21 00:00:00		None		2008-10-30 00:00:00		None		None		2009-01-19 00:00:00		None		None		2009-07-31 00:00:00		None		None		None		None		None		2010-01-29 00:00:00		None		2010-07-30 00:00:00		None		2010-05-27 00:00:00		2010-04-01 00:00:00		2010-03-22 00:00:00		None		2010-05-24 00:00:00		None		2010-10-05 00:00:00		None		None		None		2010-10-20 00:00:00		None		2011-01-26 00:00:00		None		None		None		2011-05-19 00:00:00		None		2012-01-18 00:00:00		2011-10-19 00:00:00		2011-07-18 00:00:00		2012-04-13 00:00:00		2012-07-27 00:00:00		2012-05-23 00:00:00		None		2012-07-17 00:00:00		2014-01-15 00:00:00		2012-08-30 00:00:00		2012-09-30 00:00:00		None		2012-10-15 00:00:00		None		None		2012-10-20 00:00:00		2013-01-09 00:00:00		None		None		2014-02-05 00:00:00		None		2015-01-26 00:00:00		2016-01-14 00:00:00		None		2020-01-11 00:00:00		None		None		2020-07-08 00:00:00		2019-01-11 00:00:00		2018-01-11 00:00:00		None		None		2015-11-10 00:00:00		None		2016-07-12 00:00:00		None		None		2017-01-04 00:00:00		None		None		2017-07-13 00:00:00		None		2019-07-12 00:00:00		None		None		2018-07-17 00:00:00		None		None		None		None		2021-07-10 00:00:00		2022-01-13 00:00:00		2022-07-13 00:00:00		2021-01-11 00:00:00		None		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		22001		None		22001		22001		None		22001		22001		None		None		22001		22001		None		None		22001		None		22001		None		22001		None		22001		22001		22001		None		22001		None		None		22001		None		22001		None		22001		22001		None		22001		22001		None		None		22001		None		22001		22001		None		None		None		None		22001		22001		None		22001		22001		22001		None		None		22001		None		None		22001		22001		None		None		None		None		22001		22001		22001		None		22001		22001		22001		None		22001		None		22001		None		None		None		22001		None		22001		None		None		None		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		None		None		22001		22001		None		None		22001		None		22001		22001		None		22001		None		None		22001		22001		22001		None		None		22001		None		22001		None		None		22001		None		None		22001		None		22001		None		None		22001		None		None		None		None		22001		22001		22001		22001		None		None

Table: filer_to_filer_type

filer_id		1026242
filer_type		16
active		Y
race		0
session_id		1979
category		0
category_type		40502
sub_category		40103
effect_dt		2001-07-27 00:00:00
sub_category_type		0
election_type		0
sub_category_a		S
nyq_dt		1979-01-04 00:00:00
party_cd		None
county_cd		18042
district_cd		None

Table: filer_xref

filer_id		1026242
xref_id		790378
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		790378		790378		790378		790378		790378		790378		790378		790378		790378		790378		790378		790378		790378		790378		790378		790378		790378		790378		790378		790378		790378
filer_id		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00
naml		SAN DIEGO ASSOCIATION OF REALTORS IMPAC		SAN DIEGO ASSOCIATION OF REALTORS IMPAC		SAN DIEGO ASSOCIATION OF REALTORS IMPAC		SAN DIEGO ASSOCIATION OF REALTORS IMPAC		SAN DIEGO ASSOCIATION OF REALTORS IMPAC		SAN DIEGO ASSOCIATION OF REALTORS IMPAC		SAN DIEGO ASSOCIATION OF REALTORS IMPAC		SAN DIEGO BOARD OF REALTORS ISSUES MOBILIZATION PAC		SAN DIEGO BOARD OF REALTORS ISSUES MOBILIZATION PAC		SAN DIEGO BOARD OF REALTORS ISSUES MOBILIZATION PAC		SAN DIEGO BOARD OF REALTORS ISSUES MOBILIZATION PAC		SAN DIEGO BOARD OF REALTORS ISSUES MOBILIZATION PAC		SAN DIEGO BOARD OF REALTORS ISSUES MOBILIZATION PAC		SAN DIEGO BOARD OF REALTORS ISSUES MOBILIZATION PAC		SAN DIEGO BOARD OF REALTORS IMPAC		SAN DIEGO BOARD OF REALTORS IMPAC		SAN DIEGO BOARD OF REALTORS IMPAC		SAN DIEGO BOARD OF REALTORS IMPAC		SAN DIEGO BOARD OF REALTORS IMPAC		SAN DIEGO BOARD OF REALTORS IMPAC		SAN DIEGO BOARD OF REALTORS IMPAC
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		SAN DIEGO		San Diego		Encinitas		SAN DIEGO		ENCINITAS		SAN DIEGO		ENCINITAS		SAN DIEGO		San Diego		Encinitas		SAN DIEGO		ENCINITAS		SAN DIEGO		ENCINITAS		SAN DIEGO		San Diego		Encinitas		SAN DIEGO		ENCINITAS		SAN DIEGO		ENCINITAS
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		921110000		92111		92024		92111		92024		92111		92024		921110000		92111		92024		92111		92024		92111		92024		921110000		92111		92024		92111		92024		92111		92024
phon		7606323600		760/632-3600		760/632-3600		7606323600		7606323600		6197089744				7606323600		760/632-3600		760/632-3600		7606323600		7606323600		6197089744				7606323600		760/632-3600		760/632-3600		7606323600		7606323600		6197089744
fax		7606323601		760/632-3601		760/632-3601		7606323601		7606323601		7606323601				7606323601		760/632-3601		760/632-3601		7606323601		7606323601		7606323601				7606323601		760/632-3601		760/632-3601		7606323601		7606323601		7606323601
email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None

Table: filers

filer_id		1026242

Table: received_filings

filer_id		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242		1026242
filing_file_name		864855_0.cal		864855_1.cal		909190_0.cal		945616_0.cal		980318_0.cal		20423.cal		250958.cal		389944.cal		1368029_0.cal		68550.cal		1248590_1.cal
received_date		2002-08-22 00:00:00		2002-08-26 00:00:00		2003-01-29 00:00:00		2003-07-29 00:00:00		2004-01-12 00:00:00		2004-10-05 00:00:00		2005-01-27 00:00:00		2009-09-22 00:00:00		2008-10-21 00:00:00		2007-02-26 00:00:00		2007-02-26 00:00:00
filing_directory		/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal
filing_id		864855		864855		909190		945616		980318		None		None		None		1368029		None		1248590
form_id		F497		F497		F460		F460		F460		None		None		None		F497		None		F497
receive_comment		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing did not pass validation		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted