Home

Filer ID: 1013224

Table: filer_address

filer_id		1013224		1013224
adrid		1012781		2179972
effect_dt		2008-01-31 00:00:00		2010-02-01 00:00:00
add_type		7051		7051
session_id		2007		2009

Table: filer_filings

filer_id		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224
filing_id		683943		683947		683951		683953		683954		75555		75556		75557		75558		75559		75560		75561		75562		75563		75564		75565		75566		75567		205034		205033		580071		598059		606525		606527		606530		598698		598701		598703		598135		598142		610890		604432		604433		604434		683884		683896		641818		676216		676269		580071		673689		683891		720255		683560		683562		683563		683564		683565		683568		683569		683570		749164		749164		787887		792008		785829		784431		804529		809272		866376		878236		855277		896018		891033		891033		785829		804529		855277		876137		895117		895118		895119		895120		911264		923981		936924		965048		979553		980851		955792		986793		1003276		1029866		1004605		1004608		1005039		1048859		1050158		1049281		1039459		1058239		1079321		1099080		1121861		1148524		1189556		1180401		1180564		1201733		1214072		1218293		1253596		1232441		1267093		1262978		1271161		1286479		1266315		1872095		1857018		1806141		1935307		1955075		1951054		1315577		1354981		1402038		1444262		1443455		1470270		1442915		1497559		1502872		1495546		1510652		1538160		1563967		1546265		1576528		1608136		1611595		1623890		1635068		1622950		1639924		1667318		1678188		1802452		1799861		1816578		1822608		1705439		1711877		1684082		1879994		1887419		1735471		1816578		1799861		1822608		1802452		1747968		1998188		1980951		1985867		2373172		2273769		2459362		2258129		2185192		2021228		1999057		2028326		2011143		2056276		2074975		2063083		2068340		2131226		2144042		2177205		2350492		2291675		2229680		2209565		2407478		2568474		2485146		2601030		2443671		2254208		2516481		2460418		2399879		2293286		2651650		2669765		2641055		2515632		2551869		2611243		2661827		2651650		2608213		2710666		2706100		2718950		2730497
period_id		None		None		None		None		None		137		145		147		154		154		154		154		154		154		156		155		0		157		0		153		None		161		None		None		None		None		None		None		161		161		161		161		161		161		None		None		None		None		164		None		None		None		163		164		164		164		164		164		164		164		164		None		None		None		None		167		None		168		None		None		None		169		None		165		165		167		168		169		172		None		None		None		None		171		None		None		None		176		None		None		None		177		177		None		None		None		180		180		None		None		None		179		None		None		183		185		186		None		None		188		188		None		187		None		None		None		None		None		217		218		216		219		None		221		None		None		None		None		None		None		199		None		201		202		None		204		203		None		None		205		None		None		208		207		None		210		209		None		213		216		None		212		212		None		None		219		211		216		213		None		None		None		223		221		None		None		233		241		234		None		None		None		226		224		227		None		225		227		227		None		229		235		None		None		231		None		None		241		245		239		234		244		None		237		235		249		None		247		None		243		247		249		249		None		251		249		None		252
form_id		F497		F497		F497		F497		F497		F461		F461		F461		F497		F497		F497		F497		F497		F497		F497		F461		F405		F461		F405		F461		F461		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F461		F461		F497		F461		F497		F497		F497		F497		F497		F497		F497		F497		F461		F461		F461		F461		F461		F497		F461		F461		F461		F497		F461		F497		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F497		F497		F497		F497		F497		F461		F497		F461		F461		F461		F461		F461		F497		F461		F461		F497		F497		F461		F461		F497		F461		F497		F461		F497		F461		F497		F497		F461		F461		F497		F461		F461		F461		F497		F461		F461		F497		F497		F461		F497		F461		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F497		F497		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F497		F461		F497		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F497		F497		F461		F461		F461		F461		F497		F497		F497		F461		F497		F461		F461		F497
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		1		1		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0
filing_date		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		1995-01-27 00:00:00		1996-07-30 00:00:00		1997-01-31 00:00:00		1998-05-19 00:00:00		1998-05-20 00:00:00		1998-05-22 00:00:00		1998-05-27 00:00:00		1998-05-28 00:00:00		1998-05-29 00:00:00		1998-10-26 00:00:00		1999-01-29 00:00:00		1999-04-22 00:00:00		1999-08-02 00:00:00		1998-04-22 00:00:00		1998-07-31 00:00:00		2000-01-10 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-03-14 00:00:00		2000-03-04 00:00:00		2000-03-04 00:00:00		2000-03-04 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-03-14 00:00:00		2000-10-25 00:00:00		2000-10-25 00:00:00		2000-01-24 00:00:00		2000-07-27 00:00:00		2000-11-01 00:00:00		2001-02-02 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2001-01-10 00:00:00		2001-02-07 00:00:00		2001-10-10 00:00:00		2001-07-23 00:00:00		2001-10-10 00:00:00		1999-04-22 00:00:00		2002-01-09 00:00:00		2002-01-10 00:00:00		2002-07-31 00:00:00		2002-10-21 00:00:00		2002-07-30 00:00:00		2002-11-11 00:00:00		2002-11-11 00:00:00		2002-11-11 00:00:00		2002-11-11 00:00:00		2002-11-11 00:00:00		2002-11-11 00:00:00		2002-10-21 00:00:00		2002-11-12 00:00:00		2002-11-12 00:00:00		2002-11-12 00:00:00		2002-11-12 00:00:00		2003-01-30 00:00:00		2003-01-31 00:00:00		2003-04-30 00:00:00		2003-10-14 00:00:00		2004-01-11 00:00:00		2003-10-14 00:00:00		2003-07-31 00:00:00		2004-01-13 00:00:00		2004-02-27 00:00:00		2004-07-30 00:00:00		2004-02-20 00:00:00		2004-02-20 00:00:00		2004-02-27 00:00:00		2004-10-18 00:00:00		2004-10-20 00:00:00		2004-10-18 00:00:00		2004-08-02 00:00:00		2004-10-20 00:00:00		2005-01-30 00:00:00		2005-01-31 00:00:00		2005-08-01 00:00:00		2006-01-31 00:00:00		2006-07-28 00:00:00		2006-06-13 00:00:00		2006-01-31 00:00:00		2006-07-31 00:00:00		2006-10-28 00:00:00		2006-11-01 00:00:00		2007-01-31 00:00:00		2007-01-26 00:00:00		2006-06-13 00:00:00		2007-04-30 00:00:00		2006-11-01 00:00:00		2007-07-31 00:00:00		2006-10-28 00:00:00		2014-07-31 00:00:00		2014-05-30 00:00:00		2013-11-27 00:00:00		2015-01-31 00:00:00		2015-02-02 00:00:00		2015-03-05 00:00:00		2008-01-31 00:00:00		2008-07-31 00:00:00		2009-02-02 00:00:00		2009-08-18 00:00:00		2009-07-30 00:00:00		2010-02-01 00:00:00		2009-08-18 00:00:00		2010-06-04 00:00:00		2010-07-24 00:00:00		2010-06-04 00:00:00		2010-08-02 00:00:00		2010-10-28 00:00:00		2011-01-22 00:00:00		2010-10-28 00:00:00		2011-01-24 00:00:00		2011-08-01 00:00:00		2011-08-01 00:00:00		2011-10-31 00:00:00		2012-01-30 00:00:00		2011-10-31 00:00:00		2012-01-31 00:00:00		2012-06-01 00:00:00		2012-07-31 00:00:00		2013-10-31 00:00:00		2013-10-30 00:00:00		2014-01-30 00:00:00		2014-01-31 00:00:00		2012-10-26 00:00:00		2012-11-02 00:00:00		2012-07-31 00:00:00		2014-07-31 00:00:00		2014-09-22 00:00:00		2013-01-29 00:00:00		2014-04-08 00:00:00		2014-04-08 00:00:00		2014-04-09 00:00:00		2014-04-09 00:00:00		2013-01-31 00:00:00		2015-11-02 00:00:00		2015-07-30 00:00:00		2015-07-31 00:00:00		2019-01-31 00:00:00		2018-07-31 00:00:00		2020-02-27 00:00:00		2018-05-31 00:00:00		2017-07-31 00:00:00		2016-02-01 00:00:00		2015-11-02 00:00:00		2016-04-13 00:00:00		2016-01-30 00:00:00		2016-07-19 00:00:00		2016-08-02 00:00:00		2016-08-01 00:00:00		2016-08-15 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-07-31 00:00:00		2019-01-31 00:00:00		2018-07-31 00:00:00		2018-01-31 00:00:00		2018-01-30 00:00:00		2019-07-31 00:00:00		2021-01-30 00:00:00		2020-07-31 00:00:00		2021-07-30 00:00:00		2020-01-31 00:00:00		2018-05-24 00:00:00		2020-10-15 00:00:00		2020-01-31 00:00:00		2019-07-31 00:00:00		2018-09-18 00:00:00		2022-02-22 00:00:00		2022-01-31 00:00:00		2022-01-28 00:00:00		2020-07-27 00:00:00		2021-01-30 00:00:00		2021-09-13 00:00:00		2022-03-30 00:00:00		2022-03-02 00:00:00		2021-08-02 00:00:00		2022-08-12 00:00:00		2022-08-01 00:00:00		2022-08-02 00:00:00		2022-10-10 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		10005		10001		10005		10005		10005		10005		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10006		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10006		10005		10005		10001		10005		10001		10005		10005		10005		10001		10005		10001		10002		10002		10002		10002		10001		10002		10002		10002		10002		10001		10005		10005		10005		10001		10006		10005		10005		10001		10001		10005		10005		10005		10001		10001		10001		10005		10005		10001		10005		10005		10001		10001		10001		10005		10005		10001		10001		10005		10001		10005		10005		10005		10005		10005		10001		10001		10001		10001		10005		10001		10005		10005		10005		10005		10005		10005		10001		10005		10001		10001		10005		10001		10001		10005		10005		10001		10005		10005		10001		10001		10005		10001		10001		10005		10001		10001		10005		10001		10001		10005		10005		10001		10001		10002		10002		10006		10006		10005		10001		10001		10005		10005		10001		10001		10001		10005		10005		10005		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10005		10001		10001		10005		10005		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10005		10001		10001		10001		10002		10005		10001		10001		10005		10001
stmnt_status		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		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		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		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11003
session_id		1999		1999		1999		1999		1999		1993		1995		1995		1997		1997		1997		1997		1997		1997		1997		1997		1911		1999		1911		1997		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		1997		2001		2001		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		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2007		2005		2013		2013		2013		2013		2013		2015		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2011		2011		2011		2013		2013		2011		2013		2013		2013		2013		2011		2015		2015		2015		2017		2017		2019		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2019		2021		2019		2021		2019		2017		2019		2019		2019		2017		2021		2021		2021		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021
user_id		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		*		TTHAM		TTHAM		TTHAM		*		*		*		*		*		*		*		*		*		CFLAGG		CFLAGG		GGILMORE		SARRIAGA		*		BSMITH		GGILMORE		CFLAGG		*		*		*		*		*		*		*		*		*		GGILMORE		GGILMORE		JBRANNON		ERUTH		*		GGILMORE		*		YBONILLA		LTHIBAUL		KLARRY		*		KLARRY		*		*		*		*		*		*		DHORRELL		DHORRELL		DHORRELL		DHORRELL		COMPLETED		DBARRICK		DBARRICK		DHORRELL		COMPLETED		GKURIMOT		GGILMORE		GKURIMOT		COMPLETED		COMPLETED		GPEREZ		GPEREZ		LLEONG		COMPLETED		GKURIMOT		DMCCASTL		DHORRELL		LLEONG		COMPLETED		DHORRELL		KLARRY		*		*		LHOANG		GGILMORE		JMARTIN		DHORRELL		DHORRELL		JMARTIN		*		RGEREMIA		JMARTIN		RGEREMIA		JMARTIN		CFLAGG		JINGRAM		CAFILER		WBROWN		JINGRAM		JINGRAM		WBROWN		SMCCABE		MGUERRA		JINGRAM		DHORRELL		JINGRAM		JINGRAM		DHORRELL		DHORRELL		JINGRAM		DHORRELL		JINGRAM		PBANFORD		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		PBANFORD		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		CAFILER		CAFILER		JINGRAM		JINGRAM		CAFILER		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		GTAYLOR		GTAYLOR		CAFILER		CAFILER		LPALMER		JINGRAM		JINGRAM		KBANH		JINGRAM		RGEREMIA		GCLARA		JINGRAM		PDEO		JINGRAM		JINGRAM		LPALMER		GTAYLOR		GTAYLOR		DMCCASTL		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		CAFILER		GTAYLOR		GTAYLOR		CAFILER		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		RGEREMIA		CAFILER		CAFILER		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		CAFILER
special_audit		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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
fine_audit		11003		11003		11003		11003		11003		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		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		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003		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		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11003
rpt_start		None		None		None		None		None		1994-01-01 00:00:00		1996-01-01 00:00:00		1996-07-01 00:00:00		None		None		None		None		None		None		None		1998-07-01 00:00:00		None		1999-01-01 00:00:00		None		1998-01-01 00:00:00		1999-07-01 00:00:00		2000-02-29 00:00:00		None		None		None		None		None		None		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-03-14 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		None		None		None		None		2000-10-25 00:00:00		1999-07-01 00:00:00		2000-01-01 00:00:00		None		2000-07-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		None		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		None		2002-01-01 00:00:00		None		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-10-21 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		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-10-01 00:00:00		2003-04-01 00:00:00		2003-04-01 00:00:00		2003-10-01 00:00:00		2004-02-27 00:00:00		2004-01-01 00:00:00		None		None		None		2004-10-18 00:00:00		2004-10-20 00:00:00		None		2004-01-01 00:00:00		None		2004-07-01 00:00:00		2004-07-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-06-13 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-10-28 00:00:00		2006-11-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		None		2007-01-01 00:00:00		None		2007-04-01 00:00:00		None		2014-01-01 00:00:00		2014-05-30 00:00:00		2013-11-27 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2015-03-05 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		None		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-08-18 00:00:00		None		2010-01-01 00:00:00		2010-06-04 00:00:00		2010-01-01 00:00:00		2010-10-28 00:00:00		2010-07-01 00:00:00		None		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-06-01 00:00:00		2012-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-10-01 00:00:00		2013-10-01 00:00:00		2012-10-26 00:00:00		2012-11-02 00:00:00		2012-01-01 00:00:00		2014-01-01 00:00:00		2014-09-22 00:00:00		2012-07-01 00:00:00		2013-10-01 00:00:00		2013-01-01 00:00:00		2013-10-01 00:00:00		2013-01-01 00:00:00		2012-07-01 00:00:00		2015-07-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2020-02-27 00:00:00		2018-05-31 00:00:00		2017-01-01 00:00:00		2015-10-01 00:00:00		2015-07-01 00:00:00		2016-04-13 00:00:00		2015-10-01 00:00:00		2016-07-19 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-08-15 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2017-07-01 00:00:00		2017-07-01 00:00:00		2019-01-01 00:00:00		2020-07-01 00:00:00		2020-01-01 00:00:00		2021-01-01 00:00:00		2019-07-01 00:00:00		2018-05-24 00:00:00		2020-10-15 00:00:00		2019-07-01 00:00:00		2019-01-01 00:00:00		2018-09-18 00:00:00		2022-02-22 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2020-01-01 00:00:00		2020-07-01 00:00:00		2021-09-13 00:00:00		2022-03-30 00:00:00		2022-03-02 00:00:00		2021-01-01 00:00:00		2022-08-11 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-10-10 00:00:00
rpt_end		None		None		None		None		None		1994-12-31 00:00:00		1996-06-30 00:00:00		1996-12-31 00:00:00		None		None		None		None		None		None		None		1998-12-31 00:00:00		None		1999-06-30 00:00:00		None		1998-06-30 00:00:00		1999-12-31 00:00:00		2000-02-29 00:00:00		None		None		None		None		None		None		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-03-14 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		None		None		None		None		2000-10-25 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		None		2000-12-31 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		None		2001-12-31 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		None		2002-06-30 00:00:00		None		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-10-21 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2002-06-30 00:00:00		2001-12-31 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2004-02-27 00:00:00		2004-06-30 00:00:00		None		None		None		2004-10-18 00:00:00		2004-10-20 00:00:00		None		2004-06-30 00:00:00		None		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-06-13 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-10-28 00:00:00		2006-11-01 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		None		2007-03-31 00:00:00		None		2007-06-30 00:00:00		None		2014-06-30 00:00:00		2014-05-30 00:00:00		2013-11-27 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2015-03-05 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		None		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-08-18 00:00:00		None		2010-06-30 00:00:00		2010-06-04 00:00:00		2010-06-30 00:00:00		2010-10-28 00:00:00		2010-12-31 00:00:00		None		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-06-01 00:00:00		2012-06-30 00:00:00		2013-09-30 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2012-10-26 00:00:00		2012-11-02 00:00:00		2012-06-30 00:00:00		2014-06-30 00:00:00		2014-09-22 00:00:00		2012-12-31 00:00:00		2013-12-31 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2013-09-30 00:00:00		2012-12-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2018-12-31 00:00:00		2018-06-30 00:00:00		2020-02-27 00:00:00		2018-05-31 00:00:00		2017-06-30 00:00:00		2015-12-31 00:00:00		2015-09-30 00:00:00		2016-04-13 00:00:00		2015-12-31 00:00:00		2016-07-19 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-08-15 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2018-12-31 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2019-06-30 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		2021-06-30 00:00:00		2019-12-31 00:00:00		2018-05-24 00:00:00		2020-10-15 00:00:00		2019-12-31 00:00:00		2019-06-30 00:00:00		2018-09-18 00:00:00		2022-02-22 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2021-09-13 00:00:00		2022-03-30 00:00:00		2022-03-02 00:00:00		2021-06-30 00:00:00		2022-08-11 00:00:00		2022-06-30 00:00:00		2022-06-30 00:00:00		2022-10-10 00:00:00
rpt_date		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2000-02-29 00:00:00		None		None		None		None		None		None		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-03-14 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		None		2000-10-25 00:00:00		2000-10-25 00:00:00		None		None		2000-11-01 00:00:00		2001-02-02 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		None		None		None		None		2001-10-10 00:00:00		None		2002-01-09 00:00:00		None		None		None		2002-07-30 00:00:00		None		2002-11-11 00:00:00		2002-11-11 00:00:00		2002-11-11 00:00:00		2002-11-11 00:00:00		2002-11-11 00:00:00		2002-10-21 00:00:00		None		None		None		None		2003-01-30 00:00:00		None		None		None		2004-01-11 00:00:00		None		None		None		2004-02-27 00:00:00		2004-07-28 00:00:00		None		None		None		2004-10-18 00:00:00		2004-10-20 00:00:00		None		None		None		2005-01-30 00:00:00		None		None		2006-01-31 00:00:00		2006-07-28 00:00:00		2006-06-13 00:00:00		None		None		2006-10-28 00:00:00		2006-11-01 00:00:00		None		2007-01-26 00:00:00		None		None		None		None		None		2014-07-31 00:00:00		2014-05-30 00:00:00		2013-11-27 00:00:00		2015-02-02 00:00:00		None		2015-03-05 00:00:00		None		None		None		None		None		None		2009-08-18 00:00:00		None		2010-07-24 00:00:00		2010-06-04 00:00:00		None		2010-10-28 00:00:00		2011-01-22 00:00:00		None		None		2011-08-01 00:00:00		None		None		2012-01-30 00:00:00		2011-10-31 00:00:00		None		2012-06-01 00:00:00		2012-07-31 00:00:00		None		2013-10-30 00:00:00		2014-01-30 00:00:00		None		2012-10-26 00:00:00		2012-11-02 00:00:00		None		None		2014-09-22 00:00:00		2013-01-29 00:00:00		2014-04-08 00:00:00		2014-04-08 00:00:00		None		None		None		2015-10-30 00:00:00		2015-07-30 00:00:00		None		None		2018-07-11 00:00:00		2020-02-27 00:00:00		2018-05-31 00:00:00		None		None		None		2016-04-13 00:00:00		2016-01-29 00:00:00		2016-07-19 00:00:00		None		2016-07-21 00:00:00		2016-08-15 00:00:00		2017-01-11 00:00:00		None		2017-07-08 00:00:00		2019-01-12 00:00:00		None		None		2018-01-30 00:00:00		None		None		2020-07-11 00:00:00		2021-07-31 00:00:00		2020-01-31 00:00:00		2018-05-24 00:00:00		2020-10-15 00:00:00		None		2019-07-19 00:00:00		2018-09-18 00:00:00		2022-02-22 00:00:00		None		2022-01-12 00:00:00		None		2021-01-11 00:00:00		2021-09-13 00:00:00		2022-03-30 00:00:00		2022-03-02 00:00:00		None		2022-08-11 00:00:00		2022-07-11 00:00:00		None		2022-10-10 00:00:00
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		None		22001		None		None		None		22001		22001		None		None		None		22001		22001		None		None		None		22001		None		None		22001		22001		22001		None		None		22001		22001		None		22001		None		None		None		None		None		22001		22001		22001		22001		None		22001		None		None		None		None		None		None		22001		None		22001		22001		None		22001		22001		None		None		22001		None		None		22001		22001		None		22001		22001		None		22001		22001		None		22001		22001		None		None		22001		22001		22001		22001		None		None		None		22001		22001		None		None		22001		22001		22001		None		None		None		22001		22001		22001		None		22001		22001		22001		None		22001		22001		None		None		22001		None		None		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		None		22001		22001		22001		22001		None		22001		22001		None		22001

Table: filer_to_filer_type

filer_id		1013224
filer_type		10
active		Y
race		0
session_id		2007
category		0
category_type		40502
sub_category		0
effect_dt		1995-02-08 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		1013224
xref_id		495093
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		495093		495093
filer_id		1013224		1013224
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE
effect_dt		1995-02-08 00:00:00		1995-02-08 00:00:00
naml		KPMG LLP		KPMG PEAT MARWICK 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		90071		90071
phon		4153896800		4153896800
fax		None		None
email		None		None

Table: filers

filer_id		1013224

Table: received_filings

filer_id		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224		1013224
filing_file_name		598059_0.cal		598135_0.cal		598142_0.cal		610890_0.cal		676269_0.cal		683560_0.cal		683562_0.cal		683563_0.cal		683564_0.cal		683565_0.cal		683568_0.cal		683569_0.cal		683570_0.cal		31618.cal		720255_0.cal		785829_0.cal		804529_0.cal		855277_0.cal		876137_0.cal		891033_0.cal		891033_1.cal		785829_1.cal		804529_1.cal		855277_1.cal		911264_0.cal		979553_0.cal		1079321_0.cal		1148524_0.cal		1189556_0.cal		1502872_0.cal		1232441_0.cal		1735471_0.cal		1678188_0.cal		277336.cal		1563967_0.cal		1608136_0.cal		1635068_0.cal		1622950_0.cal		274131.cal
received_date		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		2000-03-14 00:00:00		2000-10-25 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2000-11-01 00:00:00		2001-02-02 00:00:00		2001-02-02 00:00:00		2001-10-10 00:00:00		2002-01-09 00:00:00		2002-07-30 00:00:00		2002-10-21 00:00:00		2002-11-11 00:00:00		2002-11-11 00:00:00		2002-11-11 00:00:00		2002-11-11 00:00:00		2002-11-11 00:00:00		2003-01-30 00:00:00		2004-01-11 00:00:00		2005-01-30 00:00:00		2006-01-31 00:00:00		2006-07-28 00:00:00		2010-07-24 00:00:00		2007-01-26 00:00:00		2013-01-29 00:00:00		2012-07-31 00:00:00		2014-04-08 00:00:00		2011-01-22 00:00:00		2011-08-01 00:00:00		2012-01-30 00:00:00		2011-10-31 00:00:00		2022-03-30 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/cal		/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/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/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp
filing_id		598059		598135		598142		610890		676269		683560		683562		683563		683564		683565		683568		683569		683570		None		720255		785829		804529		855277		876137		891033		891033		785829		804529		855277		911264		979553		1079321		1148524		1189556		1502872		1232441		1735471		1678188		None		1563967		1608136		1635068		1622950		None
form_id		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		None		F461		F461		F461		F461		None
receive_comment		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing did not pass validation		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		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 passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints