Home

Filer ID: 1029314

Table: filer_address

filer_id		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314
adrid		2050651		2165358		2165359		2165360		2165361		2165362		2165363		2217834		2481559
effect_dt		1980-04-18 00:00:00		1980-04-18 00:00:00		1992-02-04 00:00:00		1995-03-02 00:00:00		2003-05-09 00:00:00		2006-09-28 00:00:00		2007-09-25 00:00:00		2011-07-20 00:00:00		2019-06-21 00:00:00
add_type		7051		7082		7051		7051		7051		7051		7051		7051		7082
session_id		1979		1979		1991		1995		2003		2005		2007		2011		2019

Table: filer_filings

filer_id		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314
filing_id		174773		174774		174775		174776		174777		174779		174780		174781		174782		174784		174785		174786		174787		174788		174789		174790		174791		174792		174793		174794		174795		174796		174797		174799		174800		174801		174802		174804		174805		174806		174807		174809		174810		174811		174812		174813		174814		174815		174816		174817		174818		174819		174820		174821		174822		174823		174824		174825		174826		174827		174828		174829		174831		174832		174833		174835		174836		174837		174838		174839		174840		174841		174842		174843		174844		174845		174846		174847		174848		174849		174850		174851		219204		219205		219206		219207		219208		219209		219210		219212		219213		219214		174798		174803		174808		174830		174834		174778		174783		583075		219211		638766		710983		786085		779971		785171		782516		804873		804102		849162		869968		849796		888984		886626		870533		901181		903079		944105		944320		934168		935032		982614		1033145		1035571		1087660		1081803		1114253		1115603		1144999		1181005		1149246		1174151		1192534		1205027		1207513		1217865		1212808		1196242		1242421		935032		1238872		1279720		1285595		1291599		1776265		1775705		1976869		1849236		1862550		1864184		1811759		1944053		1895089		1902638		1310802		1314208		1319523		1320792		1344319		1345368		1334468		1366442		1335428		1362047		934168		1399266		1291599		1394901		1429800		1429034		1467996		1460905		1499533		1523692		1521454		1499951		1529763		1532393		1559565		1559031		1600698		1601857		1601822		1629356		1630165		1670689		1810083		1694025		1697457		1672283		1927096		1704611		1892635		1857951		1738862		1730068		1739771		1731928		1851536		1852666		1974612		2226228		2215676		2477048		2337754		2520701		2252343		2392848		2235047		2299016		2312200		2315451		2014402		2007450		2034422		2040351		2065690		2054704		2082614		2106193		2097157		2120257		2141712		2169732		2166651		2387357		2505168		2491989		2450865		934168		2266251		2510072		2544910		2202930		2456084		2562194		2431298		2237737		2269245		2533429		2401436		2478362		2295766		2300946		2355166		2252343		2594415		2682891		2507593		2697236		2646448		2723967		2722651		2682530		2595658		2634801		2627452		2728090		2743458		2744340		2736221
period_id		83		84		85		87		87		89		89		90		90		91		92		93		94		93		95		95		95		97		97		98		97		99		99		101		102		103		105		105		107		108		108		108		109		111		113		113		113		114		115		116		117		119		121		121		121		122		122		123		125		127		129		130		130		132		132		137		137		138		140		139		141		141		143		145		147		148		149		151		153		155		157		159		82		86		88		100		102		106		108		129		131		135		101		103		107		129		133		88		91		None		124		None		None		None		165		167		None		None		168		169		171		None		None		172		None		172		None		None		173		174		None		None		177		None		None		179		None		181		None		None		183		185		186		187		None		None		188		None		None		None		188		None		189		None		None		213		None		218		218		None		None		None		None		220		191		None		193		None		194		None		193		None		None		195		197		None		None		196		None		197		None		199		201		None		203		None		204		None		None		204		205		None		None		207		None		209		215		211		None		None		220		212		219		None		None		212		None		213		218		217		221		233		None		241		236		243		234		237		233		None		235		None		None		223		225		None		None		226		227		None		228		227		None		None		229		None		243		243		None		238		234		None		244		231		241		None		239		None		None		244		None		None		235		236		None		234		245		250		243		249		None		251		251		250		None		247		None		None		None		251		252
form_id		F420		F420		F420		F420		F405		F420		F420		F405		F420		F420		F420		F420		F420		F405		F420		F405		F420		F420		F420		F420		F405		F420		F405		F420		F420		F420		F420		F420		F420		F420		F420		F405		F420		F420		F420		F405		F420		F420		F420		F420		F420		F420		F420		F420		F405		F405		F420		F420		F420		F420		F420		F420		F405		F420		F420		F420		F420		F420		F497		F420		F405		F420		F420		F420		F420		F420		F420		F420		F420		F420		F420		F420		F410		F420		F405		F420		F405		F420		F420		F420		F420		F420		F420		F405		F405		F405		F420		F420		F420		F420		F420		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F410		F460		F460		F460		F497		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F497		F460		F460		F497		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F410		F460		F497		F460		F410		F460		F460		F460		F460		F497		F460		F460		F460		F460		F497		F460		F460		F460		F497		F460		F497		F460		F497		F497		F460		F460		F460		F497		F497		F460		F460		F410		F460		F460		F460		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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		1		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		2		0		0		0		0		0		0		0		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		1980-10-21 00:00:00		1981-01-22 00:00:00		1981-05-18 00:00:00		1981-10-21 00:00:00		1981-12-18 00:00:00		1982-03-22 00:00:00		1982-05-26 00:00:00		1982-06-17 00:00:00		1982-07-20 00:00:00		1982-10-21 00:00:00		1983-01-24 00:00:00		1983-05-26 00:00:00		1983-07-26 00:00:00		1983-08-08 00:00:00		1983-09-22 00:00:00		1983-12-20 00:00:00		1984-01-30 00:00:00		1984-03-21 00:00:00		1984-05-22 00:00:00		1984-07-23 00:00:00		1984-07-23 00:00:00		1984-10-23 00:00:00		1984-12-12 00:00:00		1985-05-22 00:00:00		1985-07-30 00:00:00		1986-01-25 00:00:00		1986-03-21 00:00:00		1986-05-20 00:00:00		1986-10-06 00:00:00		1986-11-18 00:00:00		1987-01-20 00:00:00		1987-01-20 00:00:00		1987-07-29 00:00:00		1988-01-29 00:00:00		1988-03-17 00:00:00		1988-05-09 00:00:00		1988-06-20 00:00:00		1988-07-25 00:00:00		1988-10-24 00:00:00		1989-01-24 00:00:00		1989-07-27 00:00:00		1990-01-22 00:00:00		1990-04-12 00:00:00		1990-05-24 00:00:00		1990-05-29 00:00:00		1990-05-29 00:00:00		1990-07-12 00:00:00		1990-10-25 00:00:00		1991-07-25 00:00:00		1992-01-31 00:00:00		1992-03-23 00:00:00		1992-07-31 00:00:00		1992-10-07 00:00:00		1992-10-23 00:00:00		1993-02-01 00:00:00		1994-03-22 00:00:00		1994-05-27 00:00:00		1994-08-01 00:00:00		1994-11-05 00:00:00		1995-01-31 00:00:00		1995-03-02 00:00:00		1995-07-14 00:00:00		1996-01-29 00:00:00		1996-07-17 00:00:00		1996-10-01 00:00:00		1997-01-13 00:00:00		1997-07-09 00:00:00		1998-01-21 00:00:00		1998-07-13 00:00:00		1999-01-15 00:00:00		1999-07-07 00:00:00		1999-10-04 00:00:00		1980-04-18 00:00:00		1981-07-23 00:00:00		1982-03-22 00:00:00		1985-01-30 00:00:00		1985-10-18 00:00:00		1986-08-01 00:00:00		1986-11-17 00:00:00		1992-05-22 00:00:00		1992-10-05 00:00:00		1994-01-31 00:00:00		1985-03-22 00:00:00		1986-03-31 00:00:00		1987-01-20 00:00:00		1992-02-04 00:00:00		1993-08-02 00:00:00		1982-01-21 00:00:00		1982-09-21 00:00:00		2000-01-04 00:00:00		1991-02-01 00:00:00		2000-07-05 00:00:00		2001-01-16 00:00:00		2001-10-09 00:00:00		2001-09-05 00:00:00		2001-10-05 00:00:00		2001-07-10 00:00:00		2002-01-10 00:00:00		2002-01-08 00:00:00		2002-07-11 00:00:00		2002-10-01 00:00:00		2002-07-12 00:00:00		2002-11-01 00:00:00		2002-11-01 00:00:00		2002-10-01 00:00:00		2003-01-13 00:00:00		2003-01-14 00:00:00		2003-07-23 00:00:00		2003-07-24 00:00:00		2003-05-08 00:00:00		2003-05-09 00:00:00		2004-01-12 00:00:00		2004-08-02 00:00:00		2004-07-31 00:00:00		2005-01-31 00:00:00		2005-01-31 00:00:00		2005-07-18 00:00:00		2005-07-27 00:00:00		2006-01-25 00:00:00		2006-05-26 00:00:00		2006-01-31 00:00:00		2006-05-25 00:00:00		2006-07-31 00:00:00		2006-10-05 00:00:00		2006-10-05 00:00:00		2006-10-26 00:00:00		2006-10-26 00:00:00		2006-07-31 00:00:00		2007-01-31 00:00:00		2006-09-28 00:00:00		2007-01-31 00:00:00		2007-07-24 00:00:00		2007-07-31 00:00:00		2007-09-25 00:00:00		2013-07-17 00:00:00		2013-07-16 00:00:00		2015-07-21 00:00:00		2014-05-12 00:00:00		2014-07-12 00:00:00		2014-07-16 00:00:00		2014-01-16 00:00:00		2015-01-21 00:00:00		2014-10-06 00:00:00		2014-10-22 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-03-21 00:00:00		2008-03-24 00:00:00		2008-07-19 00:00:00		2008-07-23 00:00:00		2008-05-21 00:00:00		2008-10-06 00:00:00		2008-05-22 00:00:00		2008-10-03 00:00:00		2009-01-11 00:00:00		2009-02-02 00:00:00		2009-01-13 00:00:00		2009-01-29 00:00:00		2009-07-08 00:00:00		2009-07-07 00:00:00		2010-01-29 00:00:00		2010-01-26 00:00:00		2010-07-07 00:00:00		2010-10-05 00:00:00		2010-10-02 00:00:00		2010-07-09 00:00:00		2010-10-19 00:00:00		2010-10-21 00:00:00		2011-01-12 00:00:00		2011-01-11 00:00:00		2011-07-17 00:00:00		2011-07-20 00:00:00		2011-07-20 00:00:00		2012-01-18 00:00:00		2012-01-20 00:00:00		2012-07-11 00:00:00		2014-01-14 00:00:00		2012-10-04 00:00:00		2012-10-05 00:00:00		2012-07-13 00:00:00		2015-01-20 00:00:00		2012-10-25 00:00:00		2014-10-06 00:00:00		2014-05-22 00:00:00		2013-01-25 00:00:00		2013-01-22 00:00:00		2013-01-25 00:00:00		2013-01-24 00:00:00		2014-05-19 00:00:00		2014-05-21 00:00:00		2015-07-15 00:00:00		2018-03-29 00:00:00		2018-01-24 00:00:00		2020-07-06 00:00:00		2019-01-22 00:00:00		2020-10-22 00:00:00		2018-05-23 00:00:00		2019-07-24 00:00:00		2018-04-24 00:00:00		2018-09-27 00:00:00		2018-10-24 00:00:00		2018-10-25 00:00:00		2016-01-28 00:00:00		2016-01-26 00:00:00		2016-04-28 00:00:00		2016-04-28 00:00:00		2016-07-18 00:00:00		2016-07-12 00:00:00		2016-09-28 00:00:00		2016-09-29 00:00:00		2016-10-27 00:00:00		2017-01-17 00:00:00		2017-01-19 00:00:00		2017-07-18 00:00:00		2017-07-11 00:00:00		2019-06-21 00:00:00		2020-09-24 00:00:00		2020-08-17 00:00:00		2020-01-22 00:00:00		2019-06-19 00:00:00		2018-07-18 00:00:00		2020-09-25 00:00:00		2021-01-18 00:00:00		2018-01-18 00:00:00		2020-02-21 00:00:00		2021-01-21 00:00:00		2020-01-16 00:00:00		2018-04-26 00:00:00		2018-07-24 00:00:00		2020-11-05 00:00:00		2019-07-29 00:00:00		2020-07-09 00:00:00		2018-09-26 00:00:00		2018-10-03 00:00:00		2019-01-24 00:00:00		2018-05-23 00:00:00		2021-07-19 00:00:00		2022-05-16 00:00:00		2020-09-30 00:00:00		2022-07-09 00:00:00		2022-01-21 00:00:00		2022-09-26 00:00:00		2022-09-22 00:00:00		2022-05-13 00:00:00		2021-07-21 00:00:00		2022-01-17 00:00:00		2021-11-05 00:00:00		2022-07-14 00:00:00		2022-09-29 00:00:00		2022-10-27 00:00:00		2022-10-19 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		10005		10001		10005		10005		10005		10001		10001		10005		10005		10001		10001		10001		10005		10005		10001		10005		10001		10005		10005		10001		10001		10002		10005		10001		10005		10005		10001		10005		10001		10005		10005		10001		10001		10001		10001		10005		10005		10001		10005		10005		10006		10001		10005		10001		10002		10005		10001		10005		10001		10001		10005		10005		10005		10005		10001		10001		10005		10001		10005		10001		10005		10001		10005		10005		10001		10002		10005		10006		10001		10005		10001		10005		10001		10001		10005		10001		10005		10001		10005		10005		10001		10001		10006		10005		10001		10005		10001		10001		10001		10005		10005		10001		10001		10001		10005		10005		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10001		10002		10001		10001		10005		10001		10005		10005		10001		10001		10005		10005		10001		10001		10005		10001		10001		10005		10005		10001		10006		10001		10001		10005		10002		10001		10005		10001		10001		10001		10005		10001		10005		10005		10001		10005		10005		10001		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10002		10005		10005		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11003		11003		11001		11003		11003		11003		11001		11001		11001		11003		11003		11003		11003
session_id		1979		1979		1981		1981		1981		1981		1981		1981		1981		1981		1981		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1985		1985		1985		1985		1985		1985		1985		1985		1985		1987		1987		1987		1987		1987		1987		1987		1987		1989		1989		1989		1989		1989		1989		1989		1989		1991		1991		1991		1991		1991		1991		1991		1993		1993		1993		1993		1993		1995		1995		1995		1995		1995		1995		1997		1997		1997		1997		1999		1999		1979		1981		1981		1983		1985		1985		1985		1991		1991		1993		1985		1985		1985		1991		1993		1981		1981		1999		1989		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2003		2005		2007		2007		2007		2013		2013		2015		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2013		2011		2011		2011		2013		2011		2013		2013		2011		2011		2013		2013		2013		2013		2015		2017		2017		2019		2017		2019		2017		2019		2017		2017		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2019		2019		2019		2019		2019		2017		2019		2019		2017		2019		2021		2019		2017		2017		2019		2019		2019		2017		2017		2017		2017		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		TWALLS		CFLAGG		DHORRELL		*		GPEREZ		CFLAGG		*		*		*		DBARRICK		KLARRY		*		DBARRICK		COMPLETED		DBARRICK		KLARRY		COMPLETED		COMPLETED		TTHAM		KVOONG1		COMPLETED		KLARRY		SARRIAGA		COMPLETED		SARRIAGA		*		KVANG		CFLAGG		*		*		*		*		SARRIAGA		GPEREZ		*		GPEREZ		GPEREZ		EMCENTEE		*		SARRIAGA		*		NWALKER		MPACHECO		CAFILER		MDIGRAZIA		CAFILER		CAFILER		MPACHECO		MPACHECO		GCLARA		JINGRAM		CAFILER		*		SARRIAGA		CPON		CPON		*		HTSUBOI		*		CPON		SARRIAGA		CPON		*		JVAZQUEZ		EMCENTEE		*		MMORENO		MMORENO		CPON		CPON		SMCCONNAN		SMCCONNAN		SMCCONNAN		SARRIAGA		CPON		CPON		SMCCONNAN		SMCCONNAN		MMORENO		TRAMON		MMORENO		SMCCONNAN		SMCCONNAN		MDIGRAZIA		MDIGRAZIA		CAFILER		MPACHECO		MDIGRAZIA		MDIGRAZIA		CAFILER		CAFILER		MDIGRAZIA		MPACHECO		CAFILER		SARRIAGA		SARRIAGA		CAFILER		MDIGRAZIA		MDIGRAZIA		GKURIMOT		HSTOVALL		SUSHAKOV		LPHEAV		CAFILER		CAFILER		HCOURSEY		HSTOVALL		LBARTHOL		LBARTHOL		LBARTHOL		MDIGRAZIA		MDIGRAZIA		SARRIAGA		SARRIAGA		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GKURIMOT		SARRIAGA		SARRIAGA		HSTOVALL		HSTOVALL		TRAMON		IMEDINA		CAFILER		SUSHAKOV		TRAMON		CSAGABAEN		IMEDINA		SUSHAKOV		HSTOVALL		CAFILER		SUSHAKOV		SUSHAKOV		HSTOVALL		CSAGABAEN		RGEREMIA		HCOURSEY		SUSHAKOV		LBARTHOL		CAFILER		LPHEAV		CAFILER		BCOLON		CAFILER		CAFILER		CAFILER		KRUSSELL		CAFILER		CAFILER		CAFILER		BCOLON		KRUSSELL		IMEDINA		JMAVES		LPHEAV		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		1980-07-01 00:00:00		1980-10-21 00:00:00		1981-01-01 00:00:00		1981-07-01 00:00:00		1981-07-01 00:00:00		1982-01-01 00:00:00		1982-03-18 00:00:00		None		1982-05-23 00:00:00		1982-09-18 00:00:00		1982-10-17 00:00:00		1983-01-01 00:00:00		1983-05-22 00:00:00		1983-01-01 00:00:00		1983-07-01 00:00:00		1983-07-01 00:00:00		1983-09-18 00:00:00		1984-01-01 00:00:00		1984-03-18 00:00:00		1984-05-20 00:00:00		1984-03-18 00:00:00		1984-07-01 00:00:00		1984-07-01 00:00:00		1985-03-18 00:00:00		1985-05-19 00:00:00		1985-07-01 00:00:00		1986-01-01 00:00:00		1986-03-18 00:00:00		1986-07-01 00:00:00		1986-10-01 00:00:00		1986-10-19 00:00:00		1986-10-01 00:00:00		1987-01-01 00:00:00		1987-07-01 00:00:00		1988-01-01 00:00:00		1988-01-01 00:00:00		1988-03-18 00:00:00		1988-05-22 00:00:00		1988-07-01 00:00:00		1988-10-23 00:00:00		1989-01-01 00:00:00		1989-07-01 00:00:00		1990-01-01 00:00:00		1990-03-18 00:00:00		1990-03-18 00:00:00		None		1990-05-20 00:00:00		1990-07-01 00:00:00		1991-01-01 00:00:00		1991-07-01 00:00:00		1992-01-01 00:00:00		1992-05-17 00:00:00		1992-05-17 00:00:00		1992-10-01 00:00:00		1992-10-18 00:00:00		1994-01-01 00:00:00		1994-03-18 00:00:00		1994-05-22 00:00:00		None		1994-07-01 00:00:00		None		1995-01-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		1996-07-01 00:00:00		1996-10-01 00:00:00		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-01-01 00:00:00		1998-07-01 00:00:00		1999-01-01 00:00:00		1999-07-01 00:00:00		None		1981-05-17 00:00:00		1981-10-17 00:00:00		1984-10-21 00:00:00		1985-05-19 00:00:00		1986-05-18 00:00:00		1986-10-01 00:00:00		1992-03-18 00:00:00		1992-07-01 00:00:00		1993-07-01 00:00:00		1985-01-01 00:00:00		1985-07-01 00:00:00		1986-07-01 00:00:00		None		1993-01-01 00:00:00		1981-10-17 00:00:00		1982-07-01 00:00:00		1999-10-01 00:00:00		1990-10-21 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2002-01-01 00:00:00		None		2002-11-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-05-05 00:00:00		None		2003-07-01 00:00:00		2004-01-01 00:00:00		2004-01-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-07-01 00:00:00		2006-01-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-05-21 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		2006-10-01 00:00:00		2006-05-21 00:00:00		2006-10-22 00:00:00		None		2006-10-22 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		None		2013-01-20 00:00:00		2013-01-20 00:00:00		2015-01-01 00:00:00		2014-05-12 00:00:00		2014-05-18 00:00:00		2014-05-18 00:00:00		2013-07-01 00:00:00		2014-10-01 00:00:00		2014-07-01 00:00:00		2014-10-22 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		2008-05-18 00:00:00		2008-05-18 00:00:00		2008-03-18 00:00:00		2008-07-01 00:00:00		2008-03-18 00:00:00		2008-07-01 00:00:00		2009-01-11 00:00:00		2008-10-01 00:00:00		None		2008-10-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2010-01-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-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2012-01-01 00:00:00		2014-10-01 00:00:00		2012-10-25 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2012-10-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2014-05-19 00:00:00		2014-01-01 00:00:00		2015-01-01 00:00:00		2018-03-29 00:00:00		2017-07-01 00:00:00		2020-01-01 00:00:00		2018-10-21 00:00:00		2020-09-20 00:00:00		2018-05-23 00:00:00		2019-01-01 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2018-09-23 00:00:00		2018-09-23 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-04-24 00:00:00		2016-04-24 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2016-10-27 00:00:00		2016-09-25 00:00:00		2016-09-25 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		None		2020-07-01 00:00:00		2020-08-17 00:00:00		2019-07-01 00:00:00		2019-06-19 00:00:00		2018-04-22 00:00:00		2020-07-01 00:00:00		2020-10-18 00:00:00		2017-07-01 00:00:00		2020-02-21 00:00:00		2020-10-18 00:00:00		2019-07-01 00:00:00		2018-01-01 00:00:00		2018-04-22 00:00:00		2020-11-05 00:00:00		2019-01-01 00:00:00		2020-01-01 00:00:00		2018-07-01 00:00:00		2018-10-03 00:00:00		2018-10-21 00:00:00		2018-05-23 00:00:00		2021-01-01 00:00:00		2022-05-16 00:00:00		2020-09-30 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2022-07-01 00:00:00		2022-09-22 00:00:00		2022-05-12 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		None		2022-01-01 00:00:00		2022-07-01 00:00:00		2022-09-25 00:00:00		2022-10-19 00:00:00
rpt_end		1980-10-20 00:00:00		1980-12-31 00:00:00		1981-05-16 00:00:00		1981-10-17 00:00:00		1981-10-17 00:00:00		1982-03-17 00:00:00		1982-05-22 00:00:00		None		1982-06-30 00:00:00		1982-10-16 00:00:00		1982-12-31 00:00:00		1983-05-21 00:00:00		1983-06-30 00:00:00		1983-05-21 00:00:00		1983-09-17 00:00:00		1983-09-17 00:00:00		1983-12-31 00:00:00		1984-03-17 00:00:00		1984-05-19 00:00:00		1984-06-30 00:00:00		1984-05-19 00:00:00		1984-10-20 00:00:00		1984-10-20 00:00:00		1985-05-18 00:00:00		1985-06-30 00:00:00		1985-12-31 00:00:00		1986-03-17 00:00:00		1986-05-17 00:00:00		1986-09-30 00:00:00		1986-10-18 00:00:00		1986-12-31 00:00:00		1986-10-18 00:00:00		1987-06-30 00:00:00		1987-12-31 00:00:00		1988-03-17 00:00:00		1988-03-17 00:00:00		1988-05-21 00:00:00		1988-06-30 00:00:00		1988-10-22 00:00:00		1988-12-31 00:00:00		1989-06-30 00:00:00		1989-12-31 00:00:00		1990-03-17 00:00:00		1990-05-19 00:00:00		1990-05-19 00:00:00		None		1990-06-30 00:00:00		1990-10-20 00:00:00		1991-06-30 00:00:00		1991-12-31 00:00:00		1992-03-17 00:00:00		1992-06-30 00:00:00		1992-06-30 00:00:00		1992-10-17 00:00:00		1992-12-31 00:00:00		1994-03-17 00:00:00		1994-05-21 00:00:00		1994-06-30 00:00:00		None		1994-12-31 00:00:00		None		1995-06-30 00:00:00		1995-12-31 00:00:00		1996-06-30 00:00:00		1996-09-30 00:00:00		1996-12-31 00:00:00		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-06-30 00:00:00		1998-12-31 00:00:00		1999-06-30 00:00:00		1999-09-30 00:00:00		None		1981-06-30 00:00:00		1981-12-31 00:00:00		1984-12-31 00:00:00		1985-06-30 00:00:00		1986-06-30 00:00:00		1986-10-18 00:00:00		1992-05-16 00:00:00		1992-09-30 00:00:00		1993-12-31 00:00:00		1985-03-17 00:00:00		1985-12-31 00:00:00		1986-09-30 00:00:00		None		1993-06-30 00:00:00		1981-12-31 00:00:00		1982-09-17 00:00:00		1999-12-31 00:00:00		1990-12-31 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-06-30 00:00:00		None		2002-11-01 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-05-05 00:00:00		None		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2006-05-20 00:00:00		2005-12-31 00:00:00		2006-05-20 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-09-30 00:00:00		2006-10-21 00:00:00		2006-10-21 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		None		2006-12-31 00:00:00		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-06-30 00:00:00		2014-05-12 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2014-09-30 00:00:00		2014-10-22 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2008-03-17 00:00:00		2008-03-17 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-05-17 00:00:00		2008-09-30 00:00:00		2008-05-17 00:00:00		2008-09-30 00:00:00		2009-01-11 00:00:00		2008-12-31 00:00:00		None		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-09-30 00:00:00		2010-06-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-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2014-12-31 00:00:00		2012-10-25 00:00:00		2014-09-30 00:00:00		2014-05-17 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2013-01-19 00:00:00		2013-01-19 00:00:00		2014-05-19 00:00:00		2014-05-17 00:00:00		2015-06-30 00:00:00		2018-03-29 00:00:00		2017-12-31 00:00:00		2020-06-30 00:00:00		2018-12-31 00:00:00		2020-10-17 00:00:00		2018-05-23 00:00:00		2019-06-30 00:00:00		2018-04-21 00:00:00		2018-09-22 00:00:00		2018-10-20 00:00:00		2018-10-20 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-04-23 00:00:00		2016-04-23 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-09-24 00:00:00		2016-09-24 00:00:00		2016-10-27 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		None		2020-09-19 00:00:00		2020-08-17 00:00:00		2019-12-31 00:00:00		2019-06-19 00:00:00		2018-06-30 00:00:00		2020-09-19 00:00:00		2020-12-31 00:00:00		2017-12-31 00:00:00		2020-02-21 00:00:00		2020-12-31 00:00:00		2019-12-31 00:00:00		2018-04-21 00:00:00		2018-06-30 00:00:00		2020-11-05 00:00:00		2019-06-30 00:00:00		2020-06-30 00:00:00		2018-09-22 00:00:00		2018-10-03 00:00:00		2018-12-31 00:00:00		2018-05-23 00:00:00		2021-06-30 00:00:00		2022-05-16 00:00:00		2020-09-30 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		2022-09-24 00:00:00		2022-09-22 00:00:00		2022-05-12 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		None		2022-06-30 00:00:00		2022-09-24 00:00:00		2022-10-22 00:00:00		2022-10-19 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		2001-07-09 00:00:00		2001-10-01 00:00:00		None		None		2002-01-08 00:00:00		2002-07-01 00:00:00		2002-09-24 00:00:00		None		None		2002-11-01 00:00:00		None		2003-01-08 00:00:00		None		None		2003-07-24 00:00:00		None		None		None		2004-08-02 00:00:00		None		None		2005-01-31 00:00:00		None		2005-07-27 00:00:00		None		None		2006-01-31 00:00:00		2006-05-25 00:00:00		2006-07-31 00:00:00		2006-10-05 00:00:00		None		None		2006-10-26 00:00:00		None		None		None		2007-01-31 00:00:00		None		2007-07-31 00:00:00		None		None		2013-07-16 00:00:00		None		2014-05-12 00:00:00		2014-07-11 00:00:00		None		None		None		None		2014-10-22 00:00:00		2008-01-31 00:00:00		None		2008-03-21 00:00:00		None		2008-07-19 00:00:00		None		2008-05-21 00:00:00		None		None		2008-10-03 00:00:00		None		None		None		2009-01-29 00:00:00		None		2009-07-07 00:00:00		None		2010-01-26 00:00:00		2010-07-07 00:00:00		None		2010-10-02 00:00:00		None		2010-10-19 00:00:00		None		None		2011-01-11 00:00:00		2011-07-16 00:00:00		None		None		2012-01-18 00:00:00		None		2012-07-11 00:00:00		2014-01-12 00:00:00		2012-10-04 00:00:00		None		None		2015-01-20 00:00:00		2012-10-25 00:00:00		2014-10-05 00:00:00		None		None		2013-01-22 00:00:00		None		2013-01-24 00:00:00		2014-05-19 00:00:00		2014-05-21 00:00:00		2015-07-15 00:00:00		2018-03-29 00:00:00		None		2020-07-06 00:00:00		2019-01-22 00:00:00		2020-10-21 00:00:00		2018-05-23 00:00:00		2019-07-24 00:00:00		2018-04-23 00:00:00		None		2018-10-24 00:00:00		None		None		2016-01-26 00:00:00		2016-04-28 00:00:00		None		None		2016-07-12 00:00:00		2016-09-28 00:00:00		None		2016-10-27 00:00:00		2017-01-17 00:00:00		None		None		2017-07-11 00:00:00		None		2020-09-24 00:00:00		2020-08-17 00:00:00		None		None		2018-07-18 00:00:00		None		2021-01-18 00:00:00		2018-01-18 00:00:00		2020-02-21 00:00:00		None		2020-01-16 00:00:00		None		None		2020-11-05 00:00:00		None		None		2018-09-25 00:00:00		2018-10-03 00:00:00		None		2018-05-23 00:00:00		2021-07-19 00:00:00		2022-05-16 00:00:00		2020-09-30 00:00:00		2022-07-09 00:00:00		None		2022-09-26 00:00:00		2022-09-22 00:00:00		2022-05-12 00:00:00		None		2022-01-16 00:00:00		None		None		None		2022-10-27 00:00:00		2022-10-19 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		22001		22001		None		None		22001		None		None		22001		None		22001		None		None		22001		22001		22001		22001		None		None		22001		None		None		None		22001		None		22001		None		None		22001		None		22001		22001		None		None		None		None		22001		22001		None		22001		None		22001		None		22001		None		None		22001		22001		None		None		22001		None		22001		None		22001		22001		None		22001		None		22001		None		None		22001		22001		None		None		22001		None		22001		22001		22001		None		None		22001		22001		22001		None		None		22001		None		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		None		None		22001		22001		None		None		22001		22001		None		22001		22001		None		None		22001		None		22001		22001		None		22001		22001		None		22001		22001		22001		None		22001		None		None		22001		None		None		22001		22001		None		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		None		None		None		22001		22001

Table: filer_to_filer_type

filer_id		1029314
filer_type		16
active		Y
race		0
session_id		1979
category		0
category_type		40502
sub_category		40103
effect_dt		1980-04-18 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		1980-05-01 00:00:00
party_cd		None
county_cd		18026
district_cd		None

Table: filer_xref

filer_id		1029314
xref_id		801508
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		801508		801508		801508		801508		801508		801508		801508		801508		801508		801508		801508		801508		801508		801508		801508		801508		801508		801508
filer_id		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00		1980-04-18 00:00:00
naml		WEST LOS ANGELES HEALTH POLITICAL ACTION COMMITTEE		WEST LOS ANGELES HEALTH POLITICAL ACTION COMMITTEE		WEST LOS ANGELES HEALTH POLITICAL ACTION COMMITTEE		WEST LOS ANGELES HEALTH POLITICAL ACTION COMMITTEE		WEST LOS ANGELES HEALTH POLITICAL ACTION COMMITTEE		WEST LOS ANGELES HEALTH POLITICAL ACTION COMMITTEE		WEST LOS ANGELES HEALTH POLITICAL ACTION COMMITTEE		WEST LOS ANGELES HEALTH POLITICAL ACTION COMMITTEE		WEST LOS ANGELES HEALTH POLITICAL ACTION COMMITTEE		WEST LOS ANGELES HEALTH PAC - STATE		WEST LOS ANGELES HEALTH PAC - STATE		WEST LOS ANGELES HEALTH PAC - STATE		WEST LOS ANGELES HEALTH PAC - STATE		WEST LOS ANGELES HEALTH PAC - STATE		WEST LOS ANGELES HEALTH PAC - STATE		WEST LOS ANGELES HEALTH PAC - STATE		WEST LOS ANGELES HEALTH PAC - STATE		WEST LOS ANGELES HEALTH PAC - STATE
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		LOS ANGELES		LOS ANGELES		LOS ANGELES		SACRAMENTO		LOS ANGELES		CULVER CITY		LOS ANGELES		LOS ANGELES		LONG BEACH		LOS ANGELES		LOS ANGELES		LOS ANGELES		SACRAMENTO		LOS ANGELES		CULVER CITY		LOS ANGELES		LOS ANGELES		LONG BEACH
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		90068		90035		90017		95814		90017		90230		90071		90010		90802		90068		90035		90017		95814		90017		90230		90071		90010		90802
phon								9164422280		2136230820		3102151054		2134894792		2134894792		2134894792								9164422280		2136230820		3102151054		2134894792		2134894792		2134894792
fax		None		None		None		None		None		None		None		None		2134894818		None		None		None		None		None		None		None		None		2134894818
email		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1029314

Table: received_filings

filer_id		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314		1029314
filing_file_name		779971_0.cal		785171_0.cal		804102_0.cal		849162_0.cal		869968_0.cal		886626_0.cal		901181_0.cal		934168_0.cal		291081.cal		944320_0.cal		97664.cal		1704611_0.cal		21540.cal		2252343_1.cal		2456084_0.cal		2252343_0.cal		2736221_0.cal		2682530_0.cal
received_date		2001-09-05 00:00:00		2001-10-05 00:00:00		2002-01-08 00:00:00		2002-07-11 00:00:00		2002-10-01 00:00:00		2002-11-01 00:00:00		2003-01-13 00:00:00		2003-05-08 00:00:00		2003-07-31 00:00:00		2003-07-24 00:00:00		2009-01-11 00:00:00		2012-10-25 00:00:00		2011-07-17 00:00:00		2018-05-23 00:00:00		2020-02-21 00:00:00		2018-05-23 00:00:00		2022-10-19 00:00:00		2022-05-13 00:00:00
filing_directory		/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/temp		/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
filing_id		779971		785171		804102		849162		869968		886626		901181		934168		None		944320		None		1704611		None		2252343		2456084		2252343		2736221		2682530
form_id		F460		F460		F460		F460		F460		F497		F460		F410		None		F460		None		F497		None		F497		F497		F497		F497		F497
receive_comment		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted, but with warnings		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted