Home

Filer ID: 1009059

Table: filer_address

filer_id		1009059		1009059		1009059		1009059		1009059		1009059
adrid		1008323		2126904		2224997		2235531		2283866		2522670
effect_dt		1990-12-01 00:00:00		2008-01-29 00:00:00		2012-01-31 00:00:00		2012-07-24 00:00:00		2013-01-31 00:00:00		2021-08-19 00:00:00
add_type		7051		7051		7051		7082		7051		7051
session_id		1989		2007		2011		2011		2011		2021

Table: filer_filings

filer_id		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059
filing_id		56197		56198		56199		56200		56201		56202		56203		56204		56205		56206		56207		56208		56209		56210		56211		56213		56214		56215		56217		56218		56219		56220		56221		56222		56223		56224		56225		56226		56227		56228		56229		56230		56231		56232		202268		202269		202270		202271		202272		56212		56216		580441		675364		751462		792240		829135		862457		862457		889171		922846		913297		954814		980325		1007127		1040064		1038702		1067134		1081461		1059590		1099794		1119411		1121147		1106240		1149439		1138746		1178851		1173544		1190536		1173544		1181576		1202286		1231638		1213048		1213697		1221574		1253381		1284190		1266360		1307345		1270797		1296068		1286629		1266307		1300375		1777405		1776559		1975969		1979598		1975969		1852207		1865220		1889528		1897712		1900210		1885375		1311015		1346351		1338578		1336381		1346351		1337623		1354902		1392179		1397162		1378990		1418209		1419530		1451810		1450742		1436287		1469652		1442053		1464451		1496168		1493501		1354902		1397162		1442053		1451810		1469652		1494093		1497602		1284190		1296068		1346351		1392179		1436287		1450742		1464451		1149439		1507983		1106240		1121147		1138746		1181576		1286629		1311015		1300375		1307345		1513448		1543887		1532947		1574618		1578002		1588709		1591551		1572255		1607980		1611797		1639673		1642662		1674258		1673404		1827076		1827076		1812011		1931427		1900217		1889274		1885276		1893517		1873527		1738978		1849659		1750779		1927921		2261141		2325315		2205128		2171459		2181940		2566012		2389930		2387186		2343924		2250966		2016146		2016146		2007440		2024060		2007440		2027815		2026774		2040100		2041339		2057870		2074360		2063026		2080427		2079849		2085342		2069660		2092551		2103122		2098264		2124031		2105927		2145539		2171459		2246453		2252198		2181940		2228484		2314439		2373100		2385826		2248254		2291583		2294585		2233581		2391921		2260483		2286825		2288541		2284069		2262246		2272557		2545215		2438931		2476348		2607595		2596825		2635473		2651886
period_id		85		87		87		88		89		89		89		105		109		111		113		113		115		117		119		124		123		125		132		129		135		136		137		139		141		143		145		147		149		154		153		155		157		159		85		127		133		140		145		121		128		None		None		None		None		None		None		None		None		None		171		None		175		None		179		None		None		179		180		None		177		None		None		184		None		186		186		185		186		None		None		187		188		188		None		None		189		None		192		None		191		None		None		None		None		213		221		None		221		218		217		219		None		220		219		None		193		194		194		193		None		None		195		None		196		197		None		None		199		198		None		None		200		202		202		None		None		None		None		None		None		None		189		191		193		195		198		199		200		184		201		None		None		None		None		None		None		None		192		None		None		204		205		None		205		None		203		206		None		207		None		None		209		None		None		215		None		220		219		219		219		None		211		218		None		220		234		236		231		229		None		None		237		238		235		234		None		None		223		225		223		226		226		226		226		225		227		None		227		227		228		227		228		228		228		227		228		None		229		234		234		None		None		236		None		238		234		None		235		234		None		234		235		235		235		235		233		241		239		None		None		245		247		None
form_id		F461		F461		F461		F461		F405		F461		F405		F461		F461		F461		F461		F405		F461		F461		F461		F777		F461		F461		F777		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F497		F461		F497		F461		F497		F461		F461		F461		F461		F461		F461		F497		F497		F461		F497		F461		F461		F461		F497		F497		F497		F461		F461		F497		F461		F497		F461		F461		F497		F461		F461		F461		F461		F461		F461		F497		F461		F497		F461		F497		F497		F461		F461		F497		F497		F461		F497		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F497		F461		F461		F461		F497		F461		F461		F497		F497		F461		F461		F461		F461		F461		F497		F461		F497		F461		F461		F461		F497		F461		F497		F497		F497		F497		F461		F497		F461		F497		F497		F497		F497		F497		F497		F497		F461		F497		F461		F461		F497		F497		F461		F461		F497		F461		F497		F497		F461		F497		F497		F461		F497		F497		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461
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		1		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		1		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		1		1		1		1		1		0		0		1		1		2		1		1		1		1		1		0		1		1		1		1		1		1		1		1		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		1		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		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1981-08-27 00:00:00		1981-09-21 00:00:00		1981-10-22 00:00:00		1982-01-27 00:00:00		1982-08-02 00:00:00		1982-06-01 00:00:00		1983-06-27 00:00:00		1987-02-02 00:00:00		1987-07-31 00:00:00		1988-02-01 00:00:00		1988-08-01 00:00:00		1988-08-29 00:00:00		1989-01-23 00:00:00		1989-07-24 00:00:00		1990-01-29 00:00:00		1990-11-02 00:00:00		1991-01-31 00:00:00		1991-07-29 00:00:00		1992-10-24 00:00:00		1993-02-01 00:00:00		1993-11-01 00:00:00		1994-01-31 00:00:00		1994-07-27 00:00:00		1995-01-30 00:00:00		1995-07-31 00:00:00		1996-01-30 00:00:00		1996-07-24 00:00:00		1997-01-31 00:00:00		1998-01-30 00:00:00		1998-05-19 00:00:00		1998-07-29 00:00:00		1999-01-25 00:00:00		1999-07-30 00:00:00		1999-10-11 00:00:00		1981-08-27 00:00:00		1991-10-30 00:00:00		1993-08-02 00:00:00		1994-11-03 00:00:00		1996-03-11 00:00:00		1990-07-27 00:00:00		1992-01-31 00:00:00		2000-01-07 00:00:00		2000-07-27 00:00:00		2001-01-24 00:00:00		2001-07-31 00:00:00		2002-01-30 00:00:00		2002-07-31 00:00:00		2002-08-20 00:00:00		2002-11-04 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2003-07-29 00:00:00		2004-01-12 00:00:00		2004-01-09 00:00:00		2004-09-01 00:00:00		2004-08-02 00:00:00		2004-11-01 00:00:00		2005-01-31 00:00:00		2004-11-01 00:00:00		2005-01-31 00:00:00		2005-08-01 00:00:00		2005-08-01 00:00:00		2005-04-27 00:00:00		2006-01-31 00:00:00		2005-11-04 00:00:00		2006-06-02 00:00:00		2006-05-24 00:00:00		2006-07-31 00:00:00		2006-06-02 00:00:00		2006-02-03 00:00:00		2006-08-08 00:00:00		2007-01-25 00:00:00		2006-10-26 00:00:00		2006-10-27 00:00:00		2006-06-02 00:00:00		2007-01-25 00:00:00		2007-07-31 00:00:00		2006-05-23 00:00:00		2008-01-28 00:00:00		2006-10-26 00:00:00		2007-10-29 00:00:00		2007-08-01 00:00:00		2006-10-27 00:00:00		2007-11-01 00:00:00		2013-07-19 00:00:00		2013-07-18 00:00:00		2015-07-28 00:00:00		2015-07-27 00:00:00		2015-07-22 00:00:00		2014-05-20 00:00:00		2014-07-22 00:00:00		2014-09-29 00:00:00		2014-10-07 00:00:00		2014-10-18 00:00:00		2014-09-15 00:00:00		2008-01-29 00:00:00		2008-07-25 00:00:00		2008-05-29 00:00:00		2008-05-23 00:00:00		2008-07-31 00:00:00		2008-05-23 00:00:00		2008-07-31 00:00:00		2009-01-26 00:00:00		2009-01-28 00:00:00		2008-10-31 00:00:00		2009-04-22 00:00:00		2009-04-23 00:00:00		2009-10-28 00:00:00		2009-10-28 00:00:00		2009-07-30 00:00:00		2010-02-01 00:00:00		2009-07-31 00:00:00		2010-02-01 00:00:00		2010-06-08 00:00:00		2010-06-01 00:00:00		2010-07-12 00:00:00		2010-07-12 00:00:00		2010-07-12 00:00:00		2010-07-12 00:00:00		2010-07-12 00:00:00		2010-06-01 00:00:00		2010-06-08 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-08-02 00:00:00		2010-07-12 00:00:00		2010-07-12 00:00:00		2010-07-12 00:00:00		2010-07-12 00:00:00		2010-07-12 00:00:00		2010-07-12 00:00:00		2010-07-12 00:00:00		2010-07-07 00:00:00		2010-08-02 00:00:00		2010-10-22 00:00:00		2010-10-22 00:00:00		2011-02-03 00:00:00		2011-01-31 00:00:00		2011-04-27 00:00:00		2011-04-29 00:00:00		2011-01-31 00:00:00		2011-08-01 00:00:00		2011-08-01 00:00:00		2012-02-05 00:00:00		2012-02-06 00:00:00		2012-07-24 00:00:00		2012-07-22 00:00:00		2014-02-03 00:00:00		2014-01-27 00:00:00		2014-01-23 00:00:00		2015-01-23 00:00:00		2014-10-18 00:00:00		2014-09-29 00:00:00		2014-09-15 00:00:00		2014-10-06 00:00:00		2014-07-25 00:00:00		2013-01-31 00:00:00		2014-05-14 00:00:00		2013-01-31 00:00:00		2015-01-21 00:00:00		2018-06-20 00:00:00		2018-11-09 00:00:00		2018-01-24 00:00:00		2018-01-23 00:00:00		2017-07-28 00:00:00		2021-01-21 00:00:00		2019-07-12 00:00:00		2019-06-21 00:00:00		2019-01-29 00:00:00		2018-05-18 00:00:00		2016-01-28 00:00:00		2016-01-29 00:00:00		2016-01-28 00:00:00		2016-03-28 00:00:00		2016-01-26 00:00:00		2016-04-12 00:00:00		2016-04-07 00:00:00		2016-05-05 00:00:00		2016-05-10 00:00:00		2016-07-25 00:00:00		2016-09-06 00:00:00		2016-07-29 00:00:00		2016-09-22 00:00:00		2016-09-21 00:00:00		2016-10-04 00:00:00		2016-08-17 00:00:00		2016-10-20 00:00:00		2016-11-01 00:00:00		2016-10-27 00:00:00		2017-01-25 00:00:00		2016-11-07 00:00:00		2017-01-27 00:00:00		2017-07-25 00:00:00		2018-05-04 00:00:00		2018-05-22 00:00:00		2018-01-26 00:00:00		2018-01-29 00:00:00		2018-10-26 00:00:00		2019-01-31 00:00:00		2019-06-06 00:00:00		2018-05-10 00:00:00		2018-07-31 00:00:00		2018-09-21 00:00:00		2018-04-20 00:00:00		2019-07-17 00:00:00		2018-06-08 00:00:00		2018-08-27 00:00:00		2018-08-31 00:00:00		2018-08-16 00:00:00		2018-07-02 00:00:00		2018-07-30 00:00:00		2021-01-19 00:00:00		2020-01-29 00:00:00		2020-01-31 00:00:00		2021-07-28 00:00:00		2021-07-26 00:00:00		2022-01-19 00:00:00		2022-01-28 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		10005		10005		10005		10005		10005		10005		10006		10005		10005		10001		10005		10001		10005		10001		10005		10005		10001		10001		10005		10001		10005		10005		10001		10005		10001		10001		10001		10002		10005		10005		10001		10001		10001		10005		10005		10001		10005		10001		10005		10001		10005		10005		10005		10005		10001		10002		10005		10001		10001		10001		10001		10005		10001		10001		10005		10001		10001		10001		10002		10005		10005		10001		10005		10001		10001		10005		10005		10001		10001		10005		10005		10001		10001		10001		10006		10006		10006		10006		10006		10005		10005		10002		10002		10002		10002		10002		10002		10002		10002		10001		10006		10006		10006		10006		10006		10006		10006		10002		10005		10005		10001		10001		10005		10001		10005		10001		10001		10005		10001		10005		10005		10001		10006		10005		10001		10005		10001		10001		10001		10001		10005		10001		10001		10005		10001		10001		10001		10001		10002		10005		10005		10001		10001		10001		10001		10005		10006		10002		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10006		10005		10001		10005		10001		10001		10005		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10001		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		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11001		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11003		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		1981		1981		1981		1981		1981		1981		1981		1985		1987		1987		1987		1987		1987		1989		1989		1989		1989		1991		1991		1991		1993		1993		1993		1993		1995		1995		1995		1995		1997		1997		1997		1997		1999		1999		1981		1991		1993		1993		1995		1989		1991		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2007		2005		2007		2007		2005		2007		2013		2013		2015		2015		2015		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2007		2007		2009		2009		2009		2009		2009		2007		2007		2007		2007		2009		2009		2009		2005		2009		2005		2005		2005		2005		2007		2007		2007		2007		2009		2009		2009		2011		2009		2011		2011		2009		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2013		2013		2013		2013		2013		2011		2013		2011		2013		2017		2017		2017		2017		2017		2021		2019		2019		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2017		2019		2017		2017		2017		2017		2019		2017		2017		2017		2017		2017		2017		2019		2019		2019		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		EMCENTEE		EMCENTEE		ERUTH		LTHIBAUL		LTHIBAUL		LTHIBAUL		BSMITH		LTHIBAUL		COMPLETED		GGILMORE		COMPLETED		DHORRELL		COMPLETED		DHORRELL		EMCENTEE		COMPLETED		GKURIMOT		DHORRELL		*		DMCCASTL		DHORRELL		*		DHORRELL		DJOHNSON		DHORRELL		*		*		RGEREMIA		JMARTIN		*		DHORRELL		DHORRELL		EMCENTEE		JMARTIN		*		CFLAGG		SMCCABE		RGEREMIA		*		JMARTIN		RGEREMIA		JINGRAM		JINGRAM		JINGRAM		CAFILER		JINGRAM		JINGRAM		CAFILER		JINGRAM		CAFILER		JINGRAM		CAFILER		CAFILER		SMCCABE		MGUERRA		DHORRELL		PBANFORD		JINGRAM		LHOANG		MGUERRA		JINGRAM		JINGRAM		DHORRELL		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		PBANFORD		DHORRELL		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		DHORRELL		DHORRELL		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		MPACHECO		SARRIAGA		CREYNOLDS		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		RGEREMIA		RGEREMIA		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		CAFILER		CAFILER		CAFILER		JINGRAM		JINGRAM		JINGRAM		CAFILER		JINGRAM		JINGRAM		RGEREMIA		RGEREMIA		CAFILER		DMCCASTL		LPALMER		GTAYLOR		GTAYLOR		RGEREMIA		GTAYLOR		GKURIMOT		JINGRAM		JINGRAM		JINGRAM		RGEREMIA		JINGRAM		KBANH		KBANH		RGEREMIA		KBANH		JINGRAM		PDEO		JINGRAM		PDEO		PDEO		PDEO		GCLARA		PDEO		PDEO		PDEO		JINGRAM		PDEO		JINGRAM		LPALMER		GKURIMOT		GKURIMOT		DMCCASTL		DMCCASTL		GKURIMOT		GTAYLOR		CAFILER		GKURIMOT		GTAYLOR		RGEREMIA		GKURIMOT		GTAYLOR		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR
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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11003		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11003		11001		11001		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		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001
rpt_start		1981-03-18 00:00:00		1981-07-01 00:00:00		1981-09-18 00:00:00		1981-10-18 00:00:00		1982-03-18 00:00:00		1982-03-18 00:00:00		1982-03-18 00:00:00		1986-01-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-07-01 00:00:00		1989-01-01 00:00:00		1989-07-01 00:00:00		None		1990-07-01 00:00:00		1991-01-01 00:00:00		None		1992-01-01 00:00:00		1993-07-01 00:00:00		1993-10-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		1996-07-01 00:00:00		1997-01-01 00:00:00		None		1998-01-01 00:00:00		1998-07-01 00:00:00		1999-01-01 00:00:00		1999-07-01 00:00:00		1981-01-01 00:00:00		1991-07-01 00:00:00		1993-01-01 00:00:00		None		None		1990-01-01 00:00:00		1991-10-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		None		2002-07-01 00:00:00		2002-07-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2004-08-31 00:00:00		2004-01-01 00:00:00		None		2004-07-01 00:00:00		2004-10-29 00:00:00		2004-07-01 00:00:00		2004-01-01 00:00:00		2005-04-01 00:00:00		2005-01-01 00:00:00		2005-10-01 00:00:00		2005-07-01 00:00:00		2006-06-01 00:00:00		2006-05-23 00:00:00		2006-01-01 00:00:00		2006-05-23 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2006-10-26 00:00:00		2006-10-27 00:00:00		None		2006-07-01 00:00:00		2007-01-01 00:00:00		None		2007-10-01 00:00:00		None		2007-07-01 00:00:00		2007-01-01 00:00:00		None		2007-07-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2014-05-20 00:00:00		2014-01-01 00:00:00		2014-09-29 00:00:00		2014-07-01 00:00:00		2014-10-18 00:00:00		2014-09-15 00:00:00		2007-10-01 00:00:00		2008-01-01 00:00:00		2008-05-28 00:00:00		2008-05-22 00:00:00		2008-01-01 00:00:00		None		2008-01-01 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-10-30 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		2009-04-01 00:00:00		2009-10-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2010-06-07 00:00:00		2010-06-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		None		None		2007-01-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2005-10-01 00:00:00		2010-01-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2007-01-01 00:00:00		2007-10-01 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2010-01-01 00:00:00		None		2010-10-21 00:00:00		2011-02-02 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2010-07-01 00:00:00		2011-04-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2014-10-01 00:00:00		2014-10-18 00:00:00		2014-09-29 00:00:00		2014-09-15 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2012-07-01 00:00:00		2014-05-14 00:00:00		2012-07-01 00:00:00		2014-10-01 00:00:00		2018-06-20 00:00:00		2018-11-09 00:00:00		2017-07-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2020-01-01 00:00:00		2019-01-01 00:00:00		2019-06-21 00:00:00		2018-07-01 00:00:00		2018-05-18 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-03-28 00:00:00		2015-07-01 00:00:00		2016-04-12 00:00:00		2016-04-07 00:00:00		2016-05-05 00:00:00		2016-05-10 00:00:00		2016-01-01 00:00:00		2016-09-06 00:00:00		2016-01-01 00:00:00		2016-09-22 00:00:00		2016-09-21 00:00:00		2016-10-04 00:00:00		2016-08-17 00:00:00		2016-10-20 00:00:00		2016-11-01 00:00:00		2016-10-27 00:00:00		2016-07-01 00:00:00		2016-11-07 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2018-05-04 00:00:00		2018-05-22 00:00:00		2017-01-01 00:00:00		2017-07-01 00:00:00		2018-10-26 00:00:00		2018-07-01 00:00:00		2019-06-06 00:00:00		2018-05-10 00:00:00		2018-01-01 00:00:00		2018-09-21 00:00:00		2018-04-20 00:00:00		2019-01-01 00:00:00		2018-06-08 00:00:00		2018-08-27 00:00:00		2018-08-31 00:00:00		2018-08-16 00:00:00		2018-07-02 00:00:00		2018-01-01 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2019-07-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00
rpt_end		1981-05-16 00:00:00		1981-09-17 00:00:00		1981-10-17 00:00:00		1981-12-31 00:00:00		1982-05-22 00:00:00		1982-05-22 00:00:00		1982-05-22 00:00:00		1986-12-31 00:00:00		1987-06-30 00:00:00		1987-12-31 00:00:00		1988-06-30 00:00:00		1988-06-30 00:00:00		1988-12-31 00:00:00		1989-06-30 00:00:00		1989-12-31 00:00:00		None		1990-12-31 00:00:00		1991-06-30 00:00:00		None		1992-12-31 00:00:00		1993-09-30 00:00:00		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		1996-12-31 00:00:00		1997-12-31 00:00:00		None		1998-06-30 00:00:00		1998-12-31 00:00:00		1999-06-30 00:00:00		1999-09-30 00:00:00		1981-06-30 00:00:00		1991-09-30 00:00:00		1993-06-30 00:00:00		None		None		1990-06-30 00:00:00		1991-12-31 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		None		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-08-31 00:00:00		2004-06-30 00:00:00		None		2004-12-31 00:00:00		2004-10-29 00:00:00		2004-12-31 00:00:00		2004-06-30 00:00:00		2005-06-30 00:00:00		2005-03-31 00:00:00		2005-12-31 00:00:00		2005-09-30 00:00:00		2006-06-01 00:00:00		2006-05-23 00:00:00		2006-06-30 00:00:00		2006-05-23 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-10-26 00:00:00		2006-10-27 00:00:00		None		2006-12-31 00:00:00		2007-06-30 00:00:00		None		2007-12-31 00:00:00		None		2007-09-30 00:00:00		2007-06-30 00:00:00		None		2007-09-30 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2014-05-20 00:00:00		2014-06-30 00:00:00		2014-09-29 00:00:00		2014-09-30 00:00:00		2014-10-18 00:00:00		2014-09-15 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-05-28 00:00:00		2008-05-22 00:00:00		2008-06-30 00:00:00		None		2008-06-30 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2008-10-30 00:00:00		2009-03-31 00:00:00		2009-03-31 00:00:00		2009-09-30 00:00:00		2009-09-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-06-07 00:00:00		2010-06-01 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		None		None		2007-06-30 00:00:00		2007-09-30 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2005-12-31 00:00:00		2010-06-30 00:00:00		2005-03-31 00:00:00		2005-06-30 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2007-06-30 00:00:00		2007-12-31 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2010-06-30 00:00:00		None		2010-10-21 00:00:00		2011-02-02 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-03-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2012-06-30 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		2014-10-18 00:00:00		2014-09-29 00:00:00		2014-09-15 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2014-05-14 00:00:00		2012-12-31 00:00:00		2014-12-31 00:00:00		2018-06-20 00:00:00		2018-11-09 00:00:00		2017-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2020-12-31 00:00:00		2019-06-30 00:00:00		2019-06-21 00:00:00		2018-12-31 00:00:00		2018-05-18 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-03-28 00:00:00		2015-12-31 00:00:00		2016-04-12 00:00:00		2016-04-07 00:00:00		2016-05-05 00:00:00		2016-05-10 00:00:00		2016-06-30 00:00:00		2016-09-06 00:00:00		2016-06-30 00:00:00		2016-09-22 00:00:00		2016-09-21 00:00:00		2016-10-04 00:00:00		2016-08-17 00:00:00		2016-10-20 00:00:00		2016-11-01 00:00:00		2016-10-27 00:00:00		2016-12-31 00:00:00		2016-11-07 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2018-05-04 00:00:00		2018-05-22 00:00:00		2017-06-30 00:00:00		2017-12-31 00:00:00		2018-10-26 00:00:00		2018-12-31 00:00:00		2019-06-06 00:00:00		2018-05-10 00:00:00		2018-06-30 00:00:00		2018-09-21 00:00:00		2018-04-20 00:00:00		2019-06-30 00:00:00		2018-06-08 00:00:00		2018-08-27 00:00:00		2018-08-31 00:00:00		2018-08-16 00:00:00		2018-07-02 00:00:00		2018-06-30 00:00:00		2020-12-31 00:00:00		2019-12-31 00:00:00		2019-12-31 00:00:00		2021-06-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2021-12-31 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		2003-01-31 00:00:00		None		2004-01-08 00:00:00		None		2004-08-31 00:00:00		None		None		2005-01-26 00:00:00		2004-10-29 00:00:00		None		2004-07-27 00:00:00		None		None		2006-01-27 00:00:00		None		2006-06-01 00:00:00		2006-05-23 00:00:00		2006-07-28 00:00:00		2006-05-23 00:00:00		None		None		2007-01-25 00:00:00		2006-10-26 00:00:00		2006-10-27 00:00:00		None		None		2007-07-31 00:00:00		None		2008-01-10 00:00:00		None		2007-10-26 00:00:00		None		None		None		None		2013-07-18 00:00:00		2015-07-28 00:00:00		None		2015-07-22 00:00:00		2014-05-20 00:00:00		2014-07-22 00:00:00		2014-09-29 00:00:00		None		2014-10-18 00:00:00		2014-09-15 00:00:00		None		2008-07-21 00:00:00		2008-05-28 00:00:00		2008-05-22 00:00:00		2008-07-31 00:00:00		None		None		2009-01-26 00:00:00		None		2008-10-30 00:00:00		2009-04-13 00:00:00		None		None		2009-10-26 00:00:00		2009-07-29 00:00:00		None		None		2010-01-11 00:00:00		2010-06-07 00:00:00		2010-06-01 00:00:00		None		None		None		None		None		None		None		2010-06-03 00:00:00		2010-06-03 00:00:00		2010-06-03 00:00:00		2010-06-03 00:00:00		2010-06-10 00:00:00		2010-06-10 00:00:00		2010-06-10 00:00:00		2010-06-10 00:00:00		2010-08-01 00:00:00		None		None		None		None		None		None		None		2010-06-03 00:00:00		None		None		2010-10-21 00:00:00		2011-02-02 00:00:00		None		2011-04-22 00:00:00		None		2011-01-30 00:00:00		2011-07-31 00:00:00		None		2012-01-31 00:00:00		None		None		2012-07-22 00:00:00		None		None		2014-01-23 00:00:00		None		2014-10-18 00:00:00		2014-09-29 00:00:00		2014-09-15 00:00:00		2014-10-06 00:00:00		None		2013-01-31 00:00:00		2014-05-14 00:00:00		None		2015-01-21 00:00:00		2018-06-20 00:00:00		2018-11-09 00:00:00		2018-01-24 00:00:00		2018-01-22 00:00:00		None		None		2019-07-03 00:00:00		2019-06-21 00:00:00		2019-01-29 00:00:00		2018-05-18 00:00:00		None		None		2016-01-28 00:00:00		2016-03-28 00:00:00		2016-01-26 00:00:00		2016-04-12 00:00:00		2016-04-07 00:00:00		2016-05-05 00:00:00		2016-05-10 00:00:00		2016-07-25 00:00:00		2016-09-06 00:00:00		None		2016-09-22 00:00:00		2016-09-21 00:00:00		2016-10-04 00:00:00		2016-08-17 00:00:00		2016-10-20 00:00:00		2016-11-01 00:00:00		2016-10-27 00:00:00		2017-01-25 00:00:00		2016-11-07 00:00:00		None		2017-07-25 00:00:00		2018-05-04 00:00:00		2018-05-22 00:00:00		None		None		2018-10-26 00:00:00		None		2019-06-06 00:00:00		2018-05-10 00:00:00		None		2018-09-21 00:00:00		2018-04-20 00:00:00		None		2018-06-08 00:00:00		2018-08-27 00:00:00		2018-08-31 00:00:00		2018-08-16 00:00:00		2018-07-02 00:00:00		2018-07-30 00:00:00		2021-01-19 00:00:00		2020-01-29 00:00:00		None		None		2021-07-23 00:00:00		2022-01-19 00:00:00		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		22001		None		22001		None		None		22001		22001		None		22001		None		None		22001		None		22001		22001		22001		22001		None		None		22001		22001		22001		None		None		22001		None		22001		None		22001		None		None		None		None		22001		22001		None		22001		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		None		None		22001		None		22001		22001		None		None		22001		22001		None		None		22001		22001		22001		None		None		None		None		None		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		None		None		None		None		None		22001		None		None		22001		22001		None		22001		None		22001		22001		None		22001		None		None		22001		None		None		22001		None		22001		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		None		22001		None		22001		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		None

Table: filer_to_filer_type

filer_id		1009059
filer_type		10
active		Y
race		0
session_id		2007
category		0
category_type		40502
sub_category		0
effect_dt		1981-08-27 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		0
county_cd		18026
district_cd		0

Table: filer_xref

filer_id		1009059
xref_id		481174
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174		481174
filer_id		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		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		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00		1981-08-27 00:00:00
naml		MANATT, PHELPS & PHILLIPS, LLC		MANATT, PHELPS & PHILLIPS, LLC		MANATT, PHELPS & PHILLIPS, LLC		MANATT, PHELPS & PHILLIPS, LLC		MANATT, PHELPS & PHILLIPS, LLC		MANATT, PHELPS & PHILLIPS, LLP		MANATT, PHELPS & PHILLIPS, LLP		MANATT, PHELPS & PHILLIPS, LLP		MANATT, PHELPS & PHILLIPS, LLP		MANATT, PHELPS & PHILLIPS, LLP		MANATT, PHELPS, ROTHENBERG & PHILLIPS		MANATT, PHELPS, ROTHENBERG & PHILLIPS		MANATT, PHELPS, ROTHENBERG & PHILLIPS		MANATT, PHELPS, ROTHENBERG & PHILLIPS		MANATT, PHELPS, ROTHENBERG & PHILLIPS		MANATT, PHELPS, ROTHENBERG & PHILLIPS		MANATT, PHELPS, ROTHENBERG & PHILLIPS		MANATT, PHELPS, ROTHENBERG & PHILLIPS		MANATT, PHELPS, ROTHENBERG & PHILLIPS		MANATT, PHELPS, ROTHENBERG & PHILLIPS		MANATT, PHELPS & PHILLIPS		MANATT, PHELPS & PHILLIPS		MANATT, PHELPS & PHILLIPS		MANATT, PHELPS & PHILLIPS		MANATT, PHELPS & PHILLIPS		MANATT, PHELPS & PHILLIPS		MANATT, PHELPS & PHILLIPS		MANATT, PHELPS & PHILLIPS		MANATT, PHELPS & PHILLIPS		MANATT, PHELPS & PHILLIPS
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		900640000		900100000		90064		90064		90067		900640000		900100000		90064		90064		90067		900640000		900100000		90064		90064		90067		900640000		900100000		90064		90064		90067		900640000		900100000		90064		90064		90067		900640000		900100000		90064		90064		90067
phon		8182600669		8182600669		2194894792		2134894792		2134894792		8182600669		8182600669		2194894792		2134894792		2134894792		8182600669		8182600669		2194894792		2134894792		2134894792		8182600669		8182600669		2194894792		2134894792		2134894792		8182600669		8182600669		2194894792		2134894792		2134894792		8182600669		8182600669		2194894792		2134894792		2134894792
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1009059

Table: received_filings

filer_id		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059		1009059
filing_file_name		913297_0.cal		980325_0.cal		1040064_0.cal		1059590_0.cal		1081461_0.cal		1149439_0.cal		368016.cal		366613.cal		366550.cal		366971.cal		367662.cal		368383.cal		366761.cal		366975.cal		196250.cal		196604.cal		196913.cal		1213048_0.cal		1507983_0.cal		1307345_1.cal		1296068_1.cal		509929.cal		1346351_2.cal		1436287_1.cal		1450742_1.cal		1464451_1.cal		1149439_1.cal		1284190_1.cal		1418209_0.cal		1392179_0.cal		1346351_0.cal		1346351_1.cal		1450742_0.cal		1213697_0.cal		1464451_0.cal		1436287_0.cal		1296068_0.cal		1307345_0.cal		1673404_0.cal		1588709_0.cal		1532947_0.cal		253529.cal		1572255_0.cal		1607980_0.cal		416907.cal		417026.cal		193294.cal		127602.cal
received_date		2003-01-31 00:00:00		2004-01-12 00:00:00		2004-09-01 00:00:00		2004-11-01 00:00:00		2005-01-31 00:00:00		2006-01-31 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-06-02 00:00:00		2006-06-02 00:00:00		2006-06-02 00:00:00		2006-10-26 00:00:00		2010-08-02 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2010-07-07 00:00:00		2009-04-22 00:00:00		2009-01-26 00:00:00		2008-07-25 00:00:00		2008-07-31 00:00:00		2009-10-28 00:00:00		2006-10-27 00:00:00		2010-02-01 00:00:00		2009-07-30 00:00:00		2007-10-29 00:00:00		2008-01-28 00:00:00		2012-07-22 00:00:00		2011-04-27 00:00:00		2010-10-22 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2011-08-01 00:00:00		2012-02-05 00:00:00		2012-02-05 00:00:00		2014-10-18 00:00:00		2018-07-30 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/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp
filing_id		913297		980325		1040064		1059590		1081461		1149439		None		None		None		None		None		None		None		None		None		None		None		1213048		1507983		1307345		1296068		None		1346351		1436287		1450742		1464451		1149439		1284190		1418209		1392179		1346351		1346351		1450742		1213697		1464451		1436287		1296068		1307345		1673404		1588709		1532947		None		1572255		1607980		None		None		None		None
form_id		F461		F461		F497		F497		F461		F461		None		None		None		None		None		None		None		None		None		None		None		F497		F461		F461		F461		None		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F497		None		F461		F461		None		None		None		None
receive_comment		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		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 passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing did not pass validation