Home

Filer ID: 1008394

Table: filer_address

filer_id		1008394
adrid		1007644
effect_dt		2008-01-30 00:00:00
add_type		7051
session_id		2007

Table: filer_filings

filer_id		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394
filing_id		201423		201424		201426		201427		201428		50273		50274		50275		50276		50277		50278		50279		50280		50281		50283		50284		50285		50286		50288		50289		50290		50291		50293		201421		201422		50294		50295		50296		50297		50298		50299		50300		50301		50302		50303		50304		50305		50306		50307		50308		50309		50310		50311		50312		50314		50315		50316		201425		50282		50287		50292		50313		586552		666205		719430		762620		805509		805510		805511		826587		831408		831407		868456		868954		859916		855865		870198		855865		879152		876644		906918		909140		954750		961110		965674		1007256		996081		1034541		1027832		1052548		1049248		1052207		1051667		1077020		1080420		1182092		1188882		1203497		1245759		1232770		1188882		1203497		1274987		1299101		1299102		1934028		1946485		1911499		1312882		1348067		1373937		1404085		1401463		1401463		1453442		1465353		1511831		1465353		1530887		1533039		1543873		1524803		1546139		1582282		1572808		1634284		1819745		1681448		1898775		1873501		1878412		1882312		1738443		1681448		1735963		2306616		2018201		2121344		2144679		2222353		2366352
period_id		98		105		141		149		159		73		77		81		85		77		87		89		90		91		93		93		95		99		99		101		109		113		110		87		92		112		109		115		113		115		117		119		121		124		123		125		127		129		133		135		137		139		143		145		153		155		157		131		91		97		111		147		None		None		163		None		165		167		168		None		None		None		171		None		None		169		None		169		None		172		171		None		None		None		None		None		None		None		177		None		180		180		None		179		None		None		185		None		None		187		185		None		None		None		None		219		None		220		None		None		None		None		None		None		None		None		None		None		204		204		None		None		None		None		203		None		None		None		220		None		219		219		None		None		211		236		None		229		None		None		None
form_id		F461		F461		F461		F461		F461		F461		F461		F461		F461		F405		F461		F461		F461		F461		F461		F405		F461		F461		F405		F461		F461		F461		F461		F405		F461		F461		F461		F461		F405		F405		F461		F461		F461		F777		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F405		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F497		F497		F461		F461		F461		F497		F461		F461		F497		F461		F461		F497		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F497		F461		F461		F497		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F497		F497		F497		F497		F497		F461		F461		F461		F461		F461		F497		F461		F497		F497		F461		F461		F461		F497		F461		F497		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		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		1		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0
filing_date		1984-07-31 00:00:00		1986-06-20 00:00:00		1995-07-24 00:00:00		1997-07-30 00:00:00		1999-10-12 00:00:00		1979-01-21 00:00:00		1980-01-31 00:00:00		1981-04-06 00:00:00		1981-07-30 00:00:00		1981-08-24 00:00:00		1982-01-29 00:00:00		1982-05-25 00:00:00		1982-07-27 00:00:00		1982-09-22 00:00:00		1983-09-22 00:00:00		1983-10-03 00:00:00		1984-01-31 00:00:00		1984-09-24 00:00:00		1985-09-17 00:00:00		1986-06-17 00:00:00		1988-10-03 00:00:00		1988-10-06 00:00:00		1988-10-06 00:00:00		1982-06-11 00:00:00		1983-01-31 00:00:00		1988-10-06 00:00:00		1988-10-03 00:00:00		1989-01-03 00:00:00		1989-01-13 00:00:00		1989-01-13 00:00:00		1989-07-31 00:00:00		1990-01-31 00:00:00		1990-07-23 00:00:00		1990-11-06 00:00:00		1991-01-29 00:00:00		1991-07-30 00:00:00		1992-01-29 00:00:00		1992-07-30 00:00:00		1993-08-02 00:00:00		1994-01-31 00:00:00		1994-07-25 00:00:00		1995-01-30 00:00:00		1996-01-31 00:00:00		1996-07-31 00:00:00		1998-07-30 00:00:00		1999-02-01 00:00:00		1999-07-22 00:00:00		1993-01-29 00:00:00		1982-10-21 00:00:00		1985-09-17 00:00:00		1988-10-03 00:00:00		1997-01-30 00:00:00		2000-01-10 00:00:00		2000-07-31 00:00:00		2001-01-31 00:00:00		2001-01-31 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-09-19 00:00:00		2002-09-20 00:00:00		2002-07-31 00:00:00		2002-10-01 00:00:00		2002-09-30 00:00:00		2002-07-31 00:00:00		2002-10-22 00:00:00		2002-10-22 00:00:00		2003-01-27 00:00:00		2003-01-27 00:00:00		2003-07-28 00:00:00		2003-09-30 00:00:00		2003-10-10 00:00:00		2004-01-12 00:00:00		2004-02-17 00:00:00		2004-07-28 00:00:00		2004-07-29 00:00:00		2004-10-22 00:00:00		2004-10-19 00:00:00		2004-10-22 00:00:00		2004-10-19 00:00:00		2005-01-27 00:00:00		2005-01-26 00:00:00		2006-01-27 00:00:00		2006-07-28 00:00:00		2006-07-27 00:00:00		2007-01-26 00:00:00		2007-01-27 00:00:00		2007-01-27 00:00:00		2007-01-26 00:00:00		2006-11-01 00:00:00		2004-02-18 00:00:00		2004-02-18 00:00:00		2015-01-30 00:00:00		2015-01-30 00:00:00		2014-10-31 00:00:00		2008-01-30 00:00:00		2008-07-28 00:00:00		2008-10-24 00:00:00		2009-02-19 00:00:00		2009-03-03 00:00:00		2009-01-30 00:00:00		2005-07-28 00:00:00		2010-01-29 00:00:00		2010-07-27 00:00:00		2010-07-27 00:00:00		2010-10-21 00:00:00		2010-10-22 00:00:00		2010-10-22 00:00:00		2010-09-01 00:00:00		2010-10-21 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2012-01-26 00:00:00		2014-01-31 00:00:00		2012-07-27 00:00:00		2014-10-15 00:00:00		2014-07-15 00:00:00		2014-08-18 00:00:00		2014-09-03 00:00:00		2012-01-29 00:00:00		2013-01-29 00:00:00		2013-01-30 00:00:00		2018-10-15 00:00:00		2016-01-29 00:00:00		2017-01-20 00:00:00		2017-01-27 00:00:00		2018-01-30 00:00:00		2019-01-29 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10005		10001		10001		10001		10005		10005		10005		10001		10005		10005		10002		10006		10001		10005		10001		10001		10005		10005		10005		10005		10005		10005		10005		10001		10005		10001		10001		10005		10001		10005		10005		10001		10005		10005		10001		10002		10006		10005		10005		10006		10001		10005		10001		10005		10005		10005		10002		10006		10005		10005		10005		10005		10006		10001		10001		10005		10005		10005		10005		10001		10005		10005		10005		10001		10005		10001		10001		10005		10006		10001		10001		10005		10001		10005		10005		10005
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11003		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		1983		1985		1995		1997		1999		1977		1979		1979		1981		1979		1981		1981		1981		1981		1983		1983		1983		1983		1983		1985		1987		1987		1987		1981		1981		1987		1987		1987		1987		1987		1989		1989		1989		1989		1989		1991		1991		1991		1993		1993		1993		1993		1995		1995		1997		1997		1999		1991		1981		1983		1987		1995		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2003		2003		2013		2015		2013		2007		2007		2007		2007		2007		2007		2005		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2013		2011		2013		2013		2013		2013		2011		2011		2011		2017		2015		2017		2015		2017		2019
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		DPASTRAN		*		DPASTRAN		*		*		*		LTHIBAUL		LTHIBAUL		RALLMOND		*		PBANFORD		LTHIBAUL		*		LTHIBAUL		*		KLARRY		*		COMPLETED		LTHIBAUL		GGILMORE		GPEREZ		DHORRELL		DHORRELL		LLEONG		DHORRELL		COMPLETED		DMCCASTL		PBANFORD		GKURIMOT		GPEREZ		COMPLETED		DHORRELL		RGEREMIA		*		JMARTIN		JMARTIN		*		*		JMARTIN		RGEREMIA		GGILMORE		GGILMORE		JINGRAM		JINGRAM		CAFILER		SMCCABE		MGUERRA		LTHIBAUL		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		CREYNOLDS		SARRIAGA		MPACHECO		TBOWMAN		MPACHECO		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		CAFILER		JINGRAM		CAFILER		CAFILER		JINGRAM		JINGRAM		JINGRAM		RGEREMIA		JINGRAM		RGEREMIA		JINGRAM		LPALMER		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		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		11001		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		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11001		11001		11003		11001		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003
rpt_start		1984-05-20 00:00:00		1986-01-01 00:00:00		1995-01-01 00:00:00		1997-01-01 00:00:00		1999-07-01 00:00:00		1978-01-01 00:00:00		1979-01-01 00:00:00		1980-01-01 00:00:00		1981-01-01 00:00:00		1979-01-01 00:00:00		1981-07-01 00:00:00		1982-01-01 00:00:00		1982-05-23 00:00:00		1982-07-01 00:00:00		1983-01-01 00:00:00		1983-01-01 00:00:00		1983-09-18 00:00:00		1984-07-01 00:00:00		1984-07-01 00:00:00		1985-01-01 00:00:00		1987-01-01 00:00:00		1988-01-01 00:00:00		1987-04-01 00:00:00		1981-07-01 00:00:00		1982-10-17 00:00:00		1987-10-01 00:00:00		1987-01-01 00:00:00		1988-07-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		1990-01-01 00:00:00		None		1990-07-01 00:00:00		1991-01-01 00:00:00		1991-07-01 00:00:00		1992-01-01 00:00:00		1993-01-01 00:00:00		1993-07-01 00:00:00		1994-01-01 00:00:00		1994-07-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		1998-01-01 00:00:00		1998-07-01 00:00:00		1999-01-01 00:00:00		1992-07-01 00:00:00		1982-09-18 00:00:00		1984-01-01 00:00:00		1987-07-01 00:00:00		1996-07-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2002-09-18 00:00:00		None		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		None		2002-10-22 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2003-01-01 00:00:00		None		2003-07-01 00:00:00		2003-10-01 00:00:00		None		2004-01-01 00:00:00		2004-01-01 00:00:00		None		2004-10-19 00:00:00		2004-10-22 00:00:00		None		2004-07-01 00:00:00		2004-07-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		None		None		None		2014-07-01 00:00:00		2014-07-01 00:00:00		2014-10-31 00:00:00		2007-01-01 00:00:00		2008-01-01 00:00:00		None		None		2008-07-01 00:00:00		2008-07-01 00:00:00		2005-01-01 00:00:00		2009-01-01 00:00:00		2010-01-01 00:00:00		2009-01-01 00:00:00		2010-10-21 00:00:00		2010-10-22 00:00:00		None		2010-08-11 00:00:00		2010-10-21 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2012-01-01 00:00:00		2014-10-15 00:00:00		2014-01-01 00:00:00		2014-08-18 00:00:00		2014-09-03 00:00:00		2012-07-01 00:00:00		2012-01-01 00:00:00		2012-07-01 00:00:00		2018-10-15 00:00:00		2015-01-01 00:00:00		2017-01-20 00:00:00		2016-01-01 00:00:00		2017-01-01 00:00:00		2018-01-01 00:00:00
rpt_end		1984-06-30 00:00:00		1986-06-16 00:00:00		1995-06-30 00:00:00		1997-06-30 00:00:00		1999-09-30 00:00:00		1978-12-31 00:00:00		1979-12-31 00:00:00		1980-12-31 00:00:00		1981-06-30 00:00:00		1979-12-31 00:00:00		1981-12-31 00:00:00		1982-05-22 00:00:00		1982-06-30 00:00:00		1982-09-17 00:00:00		1983-09-17 00:00:00		1983-09-17 00:00:00		1983-12-31 00:00:00		1984-09-17 00:00:00		1984-12-31 00:00:00		1985-12-31 00:00:00		1987-12-31 00:00:00		1988-06-01 00:00:00		1987-06-30 00:00:00		1981-12-31 00:00:00		1982-12-31 00:00:00		1987-12-31 00:00:00		1987-03-31 00:00:00		1988-12-31 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		1990-06-30 00:00:00		None		1990-12-31 00:00:00		1991-06-30 00:00:00		1991-12-31 00:00:00		1992-06-30 00:00:00		1993-06-30 00:00:00		1993-12-31 00:00:00		1994-06-30 00:00:00		1994-12-31 00:00:00		1995-12-31 00:00:00		1996-06-30 00:00:00		1998-06-30 00:00:00		1998-12-31 00:00:00		1999-06-30 00:00:00		1992-12-31 00:00:00		1982-10-16 00:00:00		1984-06-30 00:00:00		1987-09-30 00:00:00		1996-12-31 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2002-09-18 00:00:00		None		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		None		2002-10-22 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		None		2003-09-30 00:00:00		2003-12-31 00:00:00		None		2004-06-30 00:00:00		2004-06-30 00:00:00		None		2004-10-19 00:00:00		2004-10-22 00:00:00		None		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		None		None		None		2014-12-31 00:00:00		2014-12-31 00:00:00		2014-10-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		None		None		2008-12-31 00:00:00		2008-12-31 00:00:00		2005-06-30 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2009-12-31 00:00:00		2010-10-21 00:00:00		2010-10-22 00:00:00		None		2010-08-11 00:00:00		2010-10-23 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-12-31 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2014-10-15 00:00:00		2014-06-30 00:00:00		2014-08-18 00:00:00		2014-09-03 00:00:00		2012-12-31 00:00:00		2012-06-30 00:00:00		2012-12-31 00:00:00		2018-10-15 00:00:00		2015-12-31 00:00:00		2017-01-20 00:00:00		2016-12-31 00:00:00		2017-12-31 00:00:00		2018-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		None		None		None		None		2001-01-31 00:00:00		None		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		None		None		None		2002-09-18 00:00:00		None		None		2002-10-01 00:00:00		None		2002-07-31 00:00:00		None		2002-10-22 00:00:00		2003-01-27 00:00:00		None		None		None		None		None		None		None		2004-07-29 00:00:00		None		2004-10-19 00:00:00		2004-10-22 00:00:00		None		2005-01-27 00:00:00		None		None		2006-07-28 00:00:00		None		None		2007-01-27 00:00:00		2007-01-27 00:00:00		None		None		None		None		2015-01-30 00:00:00		None		2014-10-31 00:00:00		None		None		None		None		None		None		None		None		None		None		2010-10-21 00:00:00		2010-10-22 00:00:00		None		None		None		None		2011-01-31 00:00:00		None		None		None		2014-10-15 00:00:00		None		2014-08-18 00:00:00		2014-09-03 00:00:00		None		None		2013-01-30 00:00:00		2018-10-15 00:00:00		None		2017-01-20 00:00:00		None		None		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		None		None		None		None		None		22001		None		22001		22001		None		22001		None		None		22001		None		None		22001		22001		None		None		None		None		22001		None		22001		None		None		None		None		None		None		None		None		None		None		22001		22001		None		None		None		None		22001		None		None		None		22001		None		22001		22001		None		None		22001		22001		None		22001		None		None		None

Table: filer_to_filer_type

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

Table: filer_xref

filer_id		1008394
xref_id		479060
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		479060		479060
filer_id		1008394		1008394
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00
naml		ROSE, KLEIN & MARIAS, LLP., LAW OFFICES OF		ROSE, KLEIN & MARIAS, LLP
namf		None		None
namt		None		None
nams		None		None
adr1		None		None
adr2		None		None
city		LOS ANGELES		LOS ANGELES
st		CA		CA
zip4		900170000		900170000
phon		2136260571		2136260571
fax		None		None
email		None		None

Table: filers

filer_id		1008394

Table: received_filings

filer_id		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394		1008394
filing_file_name		719430_0.cal		805509_0.cal		805510_0.cal		805511_0.cal		855865_0.cal		868456_0.cal		876644_0.cal		855865_1.cal		906918_0.cal		1027832_0.cal		1049248_0.cal		1052207_0.cal		1232770_0.cal		1530887_0.cal		1735963_0.cal		1533039_0.cal		1572808_0.cal		2121344_0.cal		1878412_0.cal		1882312_0.cal		1898775_0.cal		1911499_0.cal		2306616_0.cal
received_date		2001-01-31 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-07-31 00:00:00		2002-09-19 00:00:00		2002-10-22 00:00:00		2002-10-01 00:00:00		2003-01-27 00:00:00		2004-07-29 00:00:00		2004-10-19 00:00:00		2004-10-22 00:00:00		2007-01-27 00:00:00		2010-10-21 00:00:00		2013-01-30 00:00:00		2010-10-22 00:00:00		2011-01-31 00:00:00		2017-01-20 00:00:00		2014-08-18 00:00:00		2014-09-03 00:00:00		2014-10-15 00:00:00		2014-10-31 00:00:00		2018-10-15 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		719430		805509		805510		805511		855865		868456		876644		855865		906918		1027832		1049248		1052207		1232770		1530887		1735963		1533039		1572808		2121344		1878412		1882312		1898775		1911499		2306616
form_id		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F497		F497		F461		F497		F461		F497		F461		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted