Home

Filer ID: 1007740

Table: filer_address

filer_id		1007740
adrid		1006965
effect_dt		2008-01-31 00:00:00
add_type		7051
session_id		2007

Table: filer_filings

filer_id		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740
filing_id		37523		37524		37525		37526		37527		37528		37529		37530		37531		37532		37533		37534		37535		37536		37537		37538		37539		37540		37541		37488		37489		37490		37491		37492		37493		37494		37495		37496		37497		37498		37499		37500		37501		37502		37503		37504		37505		37506		37507		37509		37510		37511		37512		37514		37515		37516		37517		37518		37519		37520		37521		37522		37542		37543		37544		37545		37546		37547		37548		37549		37550		37551		37552		37553		37554		37555		37556		37557		37558		37559		37560		37561		37562		37563		37564		199595		199596		199597		199598		199599		199600		199601		199602		199603		199604		584036		37508		37513		597665		593401		591240		595219		622924		666210		645068		593401		720173		743822		784395		1091335		1133360		1135338		1148251		1175593		1172610		1189953		1173914		1201997		1222310		1229424		1247509		1956298		1935423		1908658		1898249		1309588		1315643		1351272		1371912		1369999		1369021		1360537		1374024		1401552		1376625		1398312		1462019		1544458		1571146		1578784		1611812		1633328		1641883		1829451		1817167		1684951		1881533		1873140		1886128		1732990		1836593		1852461		1746109		2233963		2554011		2483146		2367309		2028133		2011071		2059945		2069913		2126848		2142669		2345971		2476885		2298536		2435378		2569326		2441301		2642526		2503645		2660691
period_id		125		125		122		122		124		127		129		131		133		136		135		133		137		140		140		140		137		141		144		73		74		75		75		75		76		76		77		79		77		85		87		87		89		91		91		93		95		93		95		99		99		100		101		107		111		113		115		120		120		120		121		123		143		145		145		145		148		148		148		149		149		145		147		151		154		154		153		153		156		156		156		155		157		159		157		74		75		101		109		117		119		139		145		145		147		None		97		105		161		None		161		None		None		None		161		None		163		None		None		None		181		None		184		186		None		185		186		None		None		187		None		None		219		220		220		189		None		None		196		None		196		None		None		None		None		195		None		None		201		None		None		207		None		None		213		None		None		217		219		211		218		218		None		None		243		241		None		None		221		225		None		227		None		233		None		235		241		None		237		245		None		None
form_id		F461		F405		F777		F777		F777		F461		F461		F461		F461		F497		F461		F405		F461		F497		F497		F497		F405		F461		F497		F461		F461		F461		F405		F461		F461		F405		F405		F461		F461		F461		F405		F461		F461		F461		F405		F461		F461		F405		F405		F461		F461		F461		F405		F461		F461		F461		F461		F777		F777		F405		F461		F461		F461		F497		F497		F497		F497		F497		F497		F461		F405		F405		F405		F461		F497		F497		F405		F461		F497		F497		F497		F461		F461		F461		F405		F405		F405		F461		F461		F461		F461		F461		F497		F461		F461		F405		F461		F461		F497		F405		F497		F497		F999		F461		F461		F405		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F497		F461		F497		F461		F461		F461		F461		F497		F497		F461		F461		F461		F497		F497		F497		F497		F497		F461		F497		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1991-07-31 00:00:00		1991-12-16 00:00:00		1990-05-25 00:00:00		1990-06-05 00:00:00		1990-10-29 00:00:00		1992-01-30 00:00:00		1992-07-31 00:00:00		1993-02-01 00:00:00		1993-08-02 00:00:00		1993-11-02 00:00:00		1994-01-31 00:00:00		1994-02-03 00:00:00		1994-08-01 00:00:00		1994-10-29 00:00:00		1994-10-28 00:00:00		1994-11-04 00:00:00		1995-02-03 00:00:00		1995-07-31 00:00:00		1995-11-29 00:00:00		1978-04-28 00:00:00		1978-05-25 00:00:00		1978-10-02 00:00:00		1978-10-26 00:00:00		1978-10-26 00:00:00		1979-01-31 00:00:00		1979-02-20 00:00:00		1979-03-15 00:00:00		1980-01-31 00:00:00		1980-01-31 00:00:00		1981-08-17 00:00:00		1982-04-06 00:00:00		1982-01-29 00:00:00		1982-07-20 00:00:00		1983-01-31 00:00:00		1983-04-26 00:00:00		1983-07-30 00:00:00		1984-01-31 00:00:00		1984-01-31 00:00:00		1984-05-25 00:00:00		1984-09-21 00:00:00		1984-10-24 00:00:00		1985-01-31 00:00:00		1986-04-22 00:00:00		1987-02-02 00:00:00		1988-02-01 00:00:00		1988-08-01 00:00:00		1989-01-31 00:00:00		1989-10-30 00:00:00		1989-11-01 00:00:00		1989-12-19 00:00:00		1990-07-31 00:00:00		1991-01-31 00:00:00		1996-01-31 00:00:00		1996-03-18 00:00:00		1996-03-25 00:00:00		1996-03-27 00:00:00		1996-10-29 00:00:00		1996-10-30 00:00:00		1996-10-31 00:00:00		1997-07-31 00:00:00		1997-08-11 00:00:00		1997-08-11 00:00:00		1997-08-11 00:00:00		1998-02-02 00:00:00		1998-05-19 00:00:00		1998-05-29 00:00:00		1998-08-04 00:00:00		1998-07-31 00:00:00		1998-10-31 00:00:00		1998-10-29 00:00:00		1998-11-03 00:00:00		1999-02-01 00:00:00		1999-08-02 00:00:00		1999-10-12 00:00:00		1999-10-14 00:00:00		1978-08-01 00:00:00		1978-12-18 00:00:00		1986-01-31 00:00:00		1987-07-30 00:00:00		1989-07-31 00:00:00		1990-01-31 00:00:00		1995-01-31 00:00:00		1996-03-14 00:00:00		1996-07-31 00:00:00		1997-01-31 00:00:00		2000-01-13 00:00:00		1984-07-30 00:00:00		1986-07-28 00:00:00		2000-02-29 00:00:00		2000-02-25 00:00:00		2000-02-23 00:00:00		2000-02-23 00:00:00		2000-02-23 00:00:00		2000-07-31 00:00:00		2000-07-31 00:00:00		2000-01-10 00:00:00		2001-02-01 00:00:00		2001-02-01 00:00:00		2001-07-31 00:00:00		2005-01-31 00:00:00		2005-10-31 00:00:00		2005-10-31 00:00:00		2006-01-31 00:00:00		2006-05-26 00:00:00		2006-01-31 00:00:00		2006-07-30 00:00:00		2006-05-25 00:00:00		2006-07-31 00:00:00		2006-05-26 00:00:00		2007-01-20 00:00:00		2007-01-24 00:00:00		2015-02-02 00:00:00		2015-01-31 00:00:00		2014-10-29 00:00:00		2014-10-15 00:00:00		2008-01-30 00:00:00		2008-01-31 00:00:00		2008-07-30 00:00:00		2008-10-24 00:00:00		2008-10-22 00:00:00		2008-10-22 00:00:00		2008-05-31 00:00:00		2008-10-24 00:00:00		2009-02-02 00:00:00		2008-10-24 00:00:00		2009-02-02 00:00:00		2010-01-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-01-28 00:00:00		2012-01-30 00:00:00		2014-01-31 00:00:00		2014-01-30 00:00:00		2012-07-31 00:00:00		2014-07-31 00:00:00		2014-07-31 00:00:00		2014-09-17 00:00:00		2013-01-26 00:00:00		2014-04-07 00:00:00		2014-05-21 00:00:00		2013-01-31 00:00:00		2018-01-31 00:00:00		2021-02-01 00:00:00		2020-07-29 00:00:00		2019-01-30 00:00:00		2016-02-01 00:00:00		2016-01-30 00:00:00		2016-07-28 00:00:00		2016-08-01 00:00:00		2017-01-30 00:00:00		2017-01-30 00:00:00		2019-01-30 00:00:00		2020-01-31 00:00:00		2018-09-28 00:00:00		2020-01-24 00:00:00		2021-02-01 00:00:00		2020-01-30 00:00:00		2022-01-30 00:00:00		2020-07-31 00:00:00		2022-01-31 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		10005		10001		10001		10001		10005		10001		10005		10005		10005		10001		10006		10001		10005		10005		10005		10001		10005		10001		10001		10005		10001		10001		10005		10005		10001		10005		10005		10001		10001		10001		10001		10005		10001		10001		10005		10001		10005		10005		10005		10005		10001		10005		10005		10001		10005		10005		10001		10005		10005		10001		10005		10005		10001		10001		10001		10001		10001		10005		10005		10001		10001		10005		10005		10001		10001		10005		10001		10005		10001		10005		10001		10001		10005		10001		10001		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11001		11003		11001		11003		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11003		11003		11001		11003		11003		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001
session_id		1991		1991		1989		1989		1989		1991		1991		1991		1993		1993		1993		1993		1993		1993		1993		1993		1993		1995		1995		1977		1977		1977		1977		1977		1977		1977		1979		1979		1979		1981		1981		1981		1981		1981		1981		1983		1983		1983		1983		1983		1983		1983		1985		1985		1987		1987		1987		1989		1989		1989		1989		1989		1995		1995		1995		1995		1995		1995		1995		1997		1997		1995		1995		1997		1997		1997		1997		1997		1997		1997		1997		1997		1999		1999		1999		1977		1977		1985		1987		1989		1989		1993		1995		1995		1995		1999		1983		1985		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2009		2007		2007		2009		2009		2009		2009		2011		2011		2011		2013		2013		2011		2013		2013		2013		2011		2013		2013		2011		2017		2019		2019		2019		2015		2015		2015		2015		2015		2017		2017		2019		2017		2019		2021		2019		2021		2019		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		*		*		*		*		*		*		KCHAN		MHOANG		*		BSMITH		*		MHOANG		DBARRICK		GKURIMOT		*		DHORRELL		DHORRELL		DJOHNSON		DHORRELL		*		*		JMARTIN		LHOANG		*		JINGRAM		JINGRAM		JINGRAM		CAFILER		CAFILER		*		SMCCABE		SMCCABE		GKURIMOT		YRODRIGU		PBANFORD		DHORRELL		RGEREMIA		JVAZQUEZ		EMCENTEE		JINGRAM		JINGRAM		MPACHECO		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		CAFILER		JINGRAM		WBROWN		CAFILER		JINGRAM		LPALMER		GTAYLOR		GTAYLOR		GTAYLOR		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		GTAYLOR		GTAYLOR		CAFILER		CAFILER		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001
rpt_start		1991-01-01 00:00:00		1991-01-01 00:00:00		None		None		None		1991-07-01 00:00:00		1992-01-01 00:00:00		1992-07-01 00:00:00		1993-01-01 00:00:00		None		1993-07-01 00:00:00		1993-01-01 00:00:00		1994-01-01 00:00:00		None		None		None		1994-01-01 00:00:00		1995-01-01 00:00:00		None		1978-01-01 00:00:00		1978-04-24 00:00:00		1978-07-01 00:00:00		1978-07-01 00:00:00		1978-09-23 00:00:00		1978-10-23 00:00:00		1978-10-23 00:00:00		None		1979-07-01 00:00:00		1979-01-01 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-07-01 00:00:00		1982-07-01 00:00:00		1983-01-01 00:00:00		1983-07-01 00:00:00		1983-01-01 00:00:00		1983-07-01 00:00:00		1984-07-01 00:00:00		1984-09-18 00:00:00		1984-10-21 00:00:00		1985-01-01 00:00:00		1986-07-01 00:00:00		1987-07-01 00:00:00		1988-01-01 00:00:00		1988-07-01 00:00:00		None		None		None		1990-01-01 00:00:00		1990-07-01 00:00:00		1995-07-01 00:00:00		None		None		None		None		None		None		1997-01-01 00:00:00		1997-01-01 00:00:00		1996-01-01 00:00:00		1996-07-01 00:00:00		1997-07-01 00:00:00		None		None		1998-01-01 00:00:00		1998-01-01 00:00:00		None		None		None		1998-07-01 00:00:00		1999-01-01 00:00:00		1999-07-01 00:00:00		1999-01-01 00:00:00		1978-04-24 00:00:00		1978-09-23 00:00:00		1985-01-01 00:00:00		1987-01-01 00:00:00		1989-01-01 00:00:00		1989-07-01 00:00:00		1994-07-01 00:00:00		None		1996-01-01 00:00:00		1996-07-01 00:00:00		1999-07-01 00:00:00		1984-01-01 00:00:00		1986-01-01 00:00:00		2000-02-29 00:00:00		1999-10-01 00:00:00		2000-02-23 00:00:00		None		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2004-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-10-01 00:00:00		2006-05-26 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-05-25 00:00:00		2006-01-01 00:00:00		None		2006-07-01 00:00:00		2006-07-01 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2014-10-29 00:00:00		2014-10-15 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2008-01-01 00:00:00		2008-10-24 00:00:00		None		2008-10-22 00:00:00		None		None		2008-07-01 00:00:00		None		2008-07-01 00:00:00		2009-01-01 00:00:00		None		2010-01-01 00:00:00		2010-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2012-01-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2014-09-17 00:00:00		2012-07-01 00:00:00		2014-04-07 00:00:00		2014-05-21 00:00:00		2012-07-01 00:00:00		2017-01-01 00:00:00		2020-07-01 00:00:00		2020-01-01 00:00:00		2018-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2018-09-28 00:00:00		2020-01-24 00:00:00		2020-07-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2020-01-01 00:00:00		2021-01-01 00:00:00
rpt_end		1991-06-30 00:00:00		1991-06-30 00:00:00		None		None		None		1991-12-31 00:00:00		1992-06-30 00:00:00		1992-12-31 00:00:00		1993-06-30 00:00:00		None		1993-12-31 00:00:00		1993-06-30 00:00:00		1994-06-30 00:00:00		None		None		None		1994-06-30 00:00:00		1995-06-30 00:00:00		None		1978-04-23 00:00:00		1978-05-22 00:00:00		1978-09-23 00:00:00		1978-09-23 00:00:00		1978-10-23 00:00:00		1978-12-31 00:00:00		1978-12-31 00:00:00		None		1979-12-31 00:00:00		1979-12-31 00:00:00		1981-06-30 00:00:00		1981-12-31 00:00:00		1981-12-31 00:00:00		1982-06-30 00:00:00		1982-12-31 00:00:00		1982-12-31 00:00:00		1983-06-30 00:00:00		1983-12-31 00:00:00		1983-06-30 00:00:00		1983-12-31 00:00:00		1984-09-17 00:00:00		1984-10-20 00:00:00		1984-12-31 00:00:00		1985-12-31 00:00:00		1986-12-31 00:00:00		1987-12-31 00:00:00		1988-06-30 00:00:00		1988-12-31 00:00:00		None		None		None		1990-06-30 00:00:00		1990-12-31 00:00:00		1995-12-31 00:00:00		None		None		None		None		None		None		1997-06-30 00:00:00		1997-06-30 00:00:00		1996-06-30 00:00:00		1996-12-31 00:00:00		1997-12-31 00:00:00		None		None		1998-06-30 00:00:00		1998-06-30 00:00:00		None		None		None		1998-12-31 00:00:00		1999-06-30 00:00:00		1999-09-30 00:00:00		1999-06-30 00:00:00		1978-05-22 00:00:00		1978-10-23 00:00:00		1985-12-31 00:00:00		1987-06-30 00:00:00		1989-06-30 00:00:00		1989-12-31 00:00:00		1994-12-31 00:00:00		None		1996-06-30 00:00:00		1996-12-31 00:00:00		1999-09-30 00:00:00		1984-06-30 00:00:00		1986-06-30 00:00:00		2000-02-29 00:00:00		1999-12-31 00:00:00		2000-02-23 00:00:00		None		2000-12-31 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		1999-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2004-12-31 00:00:00		2005-09-30 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-05-26 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-05-25 00:00:00		2006-06-30 00:00:00		None		2006-12-31 00:00:00		2006-12-31 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2014-10-29 00:00:00		2014-10-15 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-10-24 00:00:00		None		2008-10-22 00:00:00		None		None		2008-12-31 00:00:00		None		2008-12-31 00:00:00		2009-12-31 00:00:00		None		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2014-09-17 00:00:00		2012-12-31 00:00:00		2014-04-07 00:00:00		2014-05-21 00:00:00		2012-12-31 00:00:00		2017-12-31 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		2018-12-31 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2018-12-31 00:00:00		2019-12-31 00:00:00		2018-09-28 00:00:00		2020-01-24 00:00:00		2020-12-31 00:00:00		2019-12-31 00:00:00		2021-12-31 00:00:00		2020-06-30 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2000-02-29 00:00:00		None		2000-02-23 00:00:00		None		None		None		2000-07-31 00:00:00		None		2001-02-01 00:00:00		None		None		None		2005-10-25 00:00:00		None		2006-01-18 00:00:00		2006-05-26 00:00:00		None		2006-07-19 00:00:00		2006-05-25 00:00:00		None		None		2007-01-16 00:00:00		None		None		2015-01-24 00:00:00		2014-10-29 00:00:00		2014-10-15 00:00:00		2008-01-22 00:00:00		None		None		2008-10-24 00:00:00		None		2008-10-22 00:00:00		None		None		None		None		2009-01-24 00:00:00		None		None		2011-01-31 00:00:00		None		None		2012-01-16 00:00:00		None		None		2014-01-27 00:00:00		None		None		2014-07-23 00:00:00		2014-09-17 00:00:00		2013-01-17 00:00:00		2014-04-07 00:00:00		2014-05-21 00:00:00		None		None		2021-02-01 00:00:00		2020-07-22 00:00:00		None		None		2016-01-26 00:00:00		2016-07-25 00:00:00		None		2017-01-26 00:00:00		None		2019-01-30 00:00:00		None		2018-09-28 00:00:00		2020-01-24 00:00:00		None		2020-01-29 00:00:00		2022-01-26 00:00:00		None		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		22001		22001		None		22001		22001		None		None		22001		None		None		22001		22001		22001		22001		None		None		22001		None		22001		None		None		None		None		22001		None		None		22001		None		None		22001		None		None		22001		None		None		22001		22001		22001		22001		22001		None		None		22001		22001		None		None		22001		22001		None		22001		None		22001		None		22001		22001		None		22001		22001		None		None

Table: filer_to_filer_type

filer_id		1007740
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		18036
district_cd		0

Table: filer_xref

filer_id		1007740
xref_id		478058
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		478058		478058		478058		478058		478058		478058		478058
filer_id		1007740		1007740		1007740		1007740		1007740		1007740		1007740
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
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00
naml		ARGYROS AND AFFILIATED ENTITIES, GEORGE		ARNEL DEVELOPMENT COMPANY		ARGYROS, GEORGE: ARNEL DEVELOPMENT COMPANY AND AFFILIATED ENTITIES		ARGYROS, GEORGE/ORANGE COUNTY SUNBIRD AVIATION		ARGYROS; GEORGE AND AFFILIATED ENTITIES		GEORGE ARGYROS AND AFFILIATED ENTITIES		ARNEL AND AFFILIATED ENTITIES
namf		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None
city		COSTA MESA		COSTA MESA		COSTA MESA		COSTA MESA		COSTA MESA		COSTA MESA		COSTA MESA
st		CA		CA		CA		CA		CA		CA		CA
zip4		926260000		926260000		926260000		926260000		926260000		926260000		926260000
phon		7144815052		7144815052		7144815052		7144815052		7144815052		7144815052		7144815052
fax		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None

Table: filers

filer_id		1007740

Table: received_filings

filer_id		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740		1007740
filing_file_name		591240_0.cal		597665_0.cal		645068_0.cal		720173_0.cal		15228.cal		15415.cal		1133360_0.cal		1148251_0.cal		1173914_0.cal		1175593_0.cal		1189953_0.cal		1398312_0.cal		1229424_0.cal		1369021_0.cal		1371912_0.cal		1309588_0.cal		1732990_0.cal		1852461_0.cal		1836593_0.cal		1571146_0.cal		1633328_0.cal		11738.cal		1898249_0.cal		1886128_0.cal		2435378_0.cal
received_date		2000-02-23 00:00:00		2000-02-29 00:00:00		2000-07-31 00:00:00		2001-02-01 00:00:00		2001-02-12 00:00:00		2001-02-12 00:00:00		2005-10-31 00:00:00		2006-01-31 00:00:00		2006-05-25 00:00:00		2006-05-26 00:00:00		2006-07-30 00:00:00		2009-02-02 00:00:00		2007-01-20 00:00:00		2008-10-22 00:00:00		2008-10-24 00:00:00		2008-01-30 00:00:00		2013-01-26 00:00:00		2014-05-21 00:00:00		2014-04-07 00:00:00		2011-01-31 00:00:00		2012-01-28 00:00:00		2012-01-28 00:00:00		2014-10-15 00:00:00		2014-09-17 00:00:00		2020-01-24 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		/usr/users/cafiler/disclose/ca99/temp		/usr/users/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		591240		597665		645068		720173		None		None		1133360		1148251		1173914		1175593		1189953		1398312		1229424		1369021		1371912		1309588		1732990		1852461		1836593		1571146		1633328		None		1898249		1886128		2435378
form_id		F497		F497		F461		F461		None		None		F461		F461		F497		F497		F461		F461		F461		F497		F497		F461		F461		F497		F497		F461		F461		None		F497		F497		F497
receive_comment		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		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 passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted