Home

Filer ID: 1009365

Table: filer_address

filer_id		1009365		1009365		1009365		1009365
adrid		1008635		2090812		2218370		2423601
effect_dt		2001-10-10 00:00:00		2008-01-31 00:00:00		2011-07-28 00:00:00		2017-01-31 00:00:00
add_type		7051		7051		7051		7051
session_id		2001		2007		2011		2015

Table: filer_filings

filer_id		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365
filing_id		202670		59016		59017		59018		59019		669222		690916		713434		683495		747581		748264		769936		785459		785459		802980		809909		809911		769936		829386		887289		908633		881050		916981		1099807		1080638		1118355		1116633		1111459		1111458		1146734		1178538		1787721		1981251		1870496		1855526		1856907		1783368		1935528		1899150		1897980		1310888		1312927		1349566		1345437		1395755		1401468		1538862		1544065		1576941		1568289		1609932		1632569		1605804		1634420		1831253		1826645		1818137		1932871		1877437		1734300		1734414		1828037		1846850		1846852		1851234		1839786		1839953		1837087		1984052		2289755		2291167		2182817		2463640		2435506		2391306		2253059		2005874		2017105		2067287		2058753		2076278		2080151		2085924		2090896		2092437		2086631		2105869		2105876		2128081		2136499		2172934		2273006		2273006		2339838		2294995		2336375		2487137		2392525		2316784		2205392		2227037		2253059		2293884		2303842		2285564		2289755		2339838		2533328		2336375		2552134		2566968		2703330		2656205		2639206		2599738		2607814		2712293
period_id		141		89		137		141		145		None		None		163		164		None		None		165		167		167		168		None		None		165		None		None		169		172		None		None		177		None		181		None		None		183		None		None		221		217		218		218		213		219		220		220		189		None		None		193		195		None		204		None		None		201		None		207		205		None		217		217		215		None		None		None		209		None		218		218		218		218		218		218		None		None		235		None		None		239		237		234		223		None		None		225		227		227		228		228		228		228		228		228		227		None		229		233		233		None		235		235		241		None		236		231		None		234		235		236		235		None		None		None		235		243		None		249		None		247		245		None		None
form_id		F465		F461		F461		F461		F461		F461		F497		F461		F497		F461		F461		F461		F461		F461		F461		F405		F405		F461		F461		F497		F461		F497		F461		F461		F461		F461		F461		F405		F405		F461		F461		F461		F461		F461		F497		F497		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F497		F497		F497		F497		F497		F497		F461		F461		F497		F461		F461		F461		F461		F497		F461		F461		F461		F461		F497		F497		F497		F497		F497		F497		F497		F497		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F497		F461		F461		F497		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		1		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		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		1		0		0		0		0		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0
filing_date		1996-01-29 00:00:00		1982-06-02 00:00:00		1995-02-08 00:00:00		1996-01-29 00:00:00		1997-01-29 00:00:00		2000-07-27 00:00:00		2000-11-01 00:00:00		2001-01-23 00:00:00		2000-11-01 00:00:00		2001-01-30 00:00:00		2001-03-23 00:00:00		2001-07-25 00:00:00		2001-10-09 00:00:00		2002-01-02 00:00:00		2002-01-02 00:00:00		2002-01-09 00:00:00		2001-10-10 00:00:00		2002-01-02 00:00:00		2002-01-09 00:00:00		2002-10-28 00:00:00		2003-01-29 00:00:00		2002-10-28 00:00:00		2003-01-31 00:00:00		2005-01-31 00:00:00		2005-01-31 00:00:00		2005-07-29 00:00:00		2005-07-28 00:00:00		2002-01-09 00:00:00		2002-01-09 00:00:00		2006-01-30 00:00:00		2006-01-31 00:00:00		2013-07-31 00:00:00		2015-07-30 00:00:00		2014-07-30 00:00:00		2014-05-28 00:00:00		2014-05-30 00:00:00		2013-07-31 00:00:00		2015-01-31 00:00:00		2014-10-16 00:00:00		2014-10-14 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-07-30 00:00:00		2008-07-23 00:00:00		2009-01-30 00:00:00		2009-01-30 00:00:00		2010-10-29 00:00:00		2010-10-29 00:00:00		2011-01-27 00:00:00		2011-01-27 00:00:00		2011-07-28 00:00:00		2012-01-26 00:00:00		2011-07-28 00:00:00		2012-01-27 00:00:00		2014-03-21 00:00:00		2014-03-07 00:00:00		2014-01-31 00:00:00		2015-01-27 00:00:00		2014-07-31 00:00:00		2013-01-24 00:00:00		2013-01-29 00:00:00		2014-01-31 00:00:00		2014-05-02 00:00:00		2014-05-02 00:00:00		2014-05-17 00:00:00		2014-04-21 00:00:00		2014-04-21 00:00:00		2014-04-08 00:00:00		2015-07-31 00:00:00		2018-07-30 00:00:00		2018-09-12 00:00:00		2017-07-27 00:00:00		2020-01-24 00:00:00		2020-01-24 00:00:00		2019-07-19 00:00:00		2018-06-07 00:00:00		2016-01-24 00:00:00		2016-01-27 00:00:00		2016-07-28 00:00:00		2016-07-26 00:00:00		2016-09-13 00:00:00		2016-09-22 00:00:00		2016-10-06 00:00:00		2016-10-18 00:00:00		2016-10-20 00:00:00		2016-10-07 00:00:00		2016-11-07 00:00:00		2016-11-07 00:00:00		2017-01-30 00:00:00		2017-01-31 00:00:00		2017-07-27 00:00:00		2018-08-17 00:00:00		2018-07-30 00:00:00		2019-01-18 00:00:00		2018-09-24 00:00:00		2020-07-31 00:00:00		2020-07-31 00:00:00		2019-07-19 00:00:00		2018-10-30 00:00:00		2018-01-25 00:00:00		2018-01-25 00:00:00		2018-05-24 00:00:00		2018-09-20 00:00:00		2018-10-09 00:00:00		2018-08-22 00:00:00		2018-08-17 00:00:00		2020-07-30 00:00:00		2020-07-30 00:00:00		2019-01-18 00:00:00		2021-01-31 00:00:00		2021-01-29 00:00:00		2022-07-28 00:00:00		2022-01-28 00:00:00		2022-01-27 00:00:00		2021-07-29 00:00:00		2021-07-30 00:00:00		2922-07-29 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10005		10005		10001		10001		10005		10005		10001		10001		10002		10001		10005		10005		10002		10005		10005		10001		10001		10005		10005		10001		10005		10001		10005		10005		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10005		10005		10001		10005		10001		10001		10005		10001		10001		10001		10005		10005		10005		10001		10005		10001		10001		10001		10001		10001		10001		10005		10005		10001		10005		10005		10001		10001		10002		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10002		10001		10005		10001		10002		10001		10005		10001		10001		10005		10001		10001		10001		10001		10006		10006		10005		10001		10001		10005		10001		10005		10001		10001		10005		10005
stmnt_status		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		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		11001		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		11003		11001		11001		11001		11003		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		1995		1981		1993		1995		1995		1999		1999		1999		1999		1999		1997		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2005		2005		2001		2001		2005		2005		2013		2015		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2011		2011		2011		2011		2013		2013		2013		2013		2013		2011		2011		2013		2013		2013		2013		2013		2013		2013		2015		2017		2017		2017		2019		2019		2019		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2019		2017		2017		2019		2019		2017		2017		2017		2017		2017		2017		2017		2017		2019		2019		2017		2019		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		EMCENTEE		GKURIMOT		*		*		EMCENTEE		DHORRELL		*		*		*		*		LTHIBAUL		DHORRELL		*		LTHIBAUL		KLARRY		COMPLETED		*		LTHIBAUL		DHORRELL		COMPLETED		DHORRELL		*		DHORRELL		DHORRELL		DHORRELL		DHORRELL		JINGRAM		JINGRAM		JINGRAM		WBROWN		WBROWN		JINGRAM		JINGRAM		WBROWN		WBROWN		SMCCABE		SMCCABE		SMCCABE		SMCCABE		JINGRAM		JINGRAM		CREYNOLDS		MPACHECO		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		WBROWN		WBROWN		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		WBROWN		WBROWN		WBROWN		WBROWN		WBROWN		WBROWN		JINGRAM		GTAYLOR		CAFILER		LPALMER		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		JINGRAM		JINGRAM		JINGRAM		JINGRAM		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		RGEREMIA		PDEO		JINGRAM		JINGRAM		LPALMER		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		DMCCASTL		DMCCASTL		CAFILER		CAFILER		CAFILER		CAFILER		AROJAS		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR
special_audit		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
fine_audit		11001		11001		11001		11001		11001		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		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		11003		11001		11001		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001
rpt_start		1995-01-01 00:00:00		1982-01-01 00:00:00		1994-01-01 00:00:00		1995-01-01 00:00:00		1996-01-01 00:00:00		2000-01-01 00:00:00		2000-11-01 00:00:00		2000-07-01 00:00:00		2000-11-01 00:00:00		2000-07-01 00:00:00		1998-01-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-10-01 00:00:00		None		2002-01-01 00:00:00		2002-10-28 00:00:00		2002-01-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2014-01-01 00:00:00		2014-05-28 00:00:00		2014-05-30 00:00:00		2013-01-01 00:00:00		2014-07-01 00:00:00		2014-10-16 00:00:00		2014-10-14 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2010-10-29 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-01-01 00:00:00		2011-07-01 00:00:00		2014-03-21 00:00:00		2014-03-07 00:00:00		2013-07-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2014-05-02 00:00:00		2014-05-02 00:00:00		2014-05-17 00:00:00		2014-04-21 00:00:00		2014-04-21 00:00:00		2014-04-08 00:00:00		2015-01-01 00:00:00		2018-01-01 00:00:00		2018-09-12 00:00:00		2017-01-01 00:00:00		2019-07-01 00:00:00		2019-07-01 00:00:00		2019-01-01 00:00:00		2018-06-07 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-09-13 00:00:00		2016-09-22 00:00:00		2016-10-06 00:00:00		2016-10-18 00:00:00		2016-10-20 00:00:00		2016-10-07 00:00:00		2016-11-07 00:00:00		2016-11-07 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2018-01-01 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2018-09-24 00:00:00		2018-07-01 00:00:00		2020-01-01 00:00:00		2019-01-01 00:00:00		2018-10-30 00:00:00		2017-07-01 00:00:00		2017-07-01 00:00:00		2018-05-24 00:00:00		2018-09-20 00:00:00		2018-10-09 00:00:00		2018-08-22 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2020-01-01 00:00:00		2018-07-01 00:00:00		2020-07-01 00:00:00		2020-07-01 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00
rpt_end		1995-12-31 00:00:00		1982-06-30 00:00:00		1994-12-31 00:00:00		1995-12-31 00:00:00		1996-12-31 00:00:00		2000-06-30 00:00:00		2000-11-01 00:00:00		2000-12-31 00:00:00		2000-11-01 00:00:00		2000-12-31 00:00:00		1998-12-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		None		2002-12-31 00:00:00		2002-10-28 00:00:00		2002-12-31 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2014-05-28 00:00:00		2014-05-30 00:00:00		2013-06-30 00:00:00		2014-12-31 00:00:00		2014-10-16 00:00:00		2014-10-14 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2010-10-29 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-06-30 00:00:00		2011-12-31 00:00:00		2014-03-21 00:00:00		2014-03-07 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2013-12-31 00:00:00		2014-05-02 00:00:00		2014-05-02 00:00:00		2014-05-17 00:00:00		2014-04-21 00:00:00		2014-04-21 00:00:00		2014-04-08 00:00:00		2015-06-30 00:00:00		2018-06-30 00:00:00		2018-09-12 00:00:00		2017-06-30 00:00:00		2019-12-31 00:00:00		2019-12-31 00:00:00		2019-06-30 00:00:00		2018-06-07 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-09-13 00:00:00		2016-09-22 00:00:00		2016-10-06 00:00:00		2016-10-18 00:00:00		2016-10-20 00:00:00		2016-10-07 00:00:00		2016-11-07 00:00:00		2016-11-07 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2018-06-30 00:00:00		2018-06-30 00:00:00		2018-12-31 00:00:00		2018-09-24 00:00:00		2018-12-31 00:00:00		2020-06-30 00:00:00		2019-06-30 00:00:00		2018-10-30 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2018-05-24 00:00:00		2018-09-20 00:00:00		2018-10-09 00:00:00		2018-08-22 00:00:00		2018-06-30 00:00:00		2018-12-31 00:00:00		2020-06-30 00:00:00		2018-12-31 00:00:00		2020-12-31 00:00:00		2020-12-31 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00
rpt_date		None		None		None		None		None		None		None		2001-01-22 00:00:00		2000-11-01 00:00:00		None		None		2001-07-23 00:00:00		2001-10-04 00:00:00		2001-12-28 00:00:00		2001-12-28 00:00:00		None		None		2001-12-28 00:00:00		None		None		2003-01-21 00:00:00		2002-10-28 00:00:00		None		None		2005-01-18 00:00:00		None		2005-07-21 00:00:00		None		None		2006-01-24 00:00:00		None		None		2015-07-07 00:00:00		2014-07-21 00:00:00		2014-05-28 00:00:00		2014-05-30 00:00:00		2013-07-23 00:00:00		2015-01-12 00:00:00		2014-10-16 00:00:00		2014-10-14 00:00:00		2008-01-16 00:00:00		None		None		2008-07-16 00:00:00		2009-01-16 00:00:00		None		2010-10-29 00:00:00		None		None		2011-01-18 00:00:00		None		2012-01-23 00:00:00		2011-07-12 00:00:00		None		2014-03-21 00:00:00		2014-03-07 00:00:00		2014-01-23 00:00:00		None		None		None		2013-01-18 00:00:00		None		2014-05-02 00:00:00		2014-05-02 00:00:00		2014-05-17 00:00:00		2014-04-21 00:00:00		2014-04-21 00:00:00		2014-04-08 00:00:00		None		None		2018-09-12 00:00:00		None		None		2020-01-02 00:00:00		2019-07-08 00:00:00		2018-06-07 00:00:00		2016-01-12 00:00:00		None		None		2016-07-15 00:00:00		2016-09-13 00:00:00		2016-09-22 00:00:00		2016-10-06 00:00:00		2016-10-18 00:00:00		2016-10-20 00:00:00		2016-10-07 00:00:00		2016-11-07 00:00:00		2016-11-07 00:00:00		2017-01-13 00:00:00		None		2017-07-21 00:00:00		2018-08-14 00:00:00		2018-07-26 00:00:00		None		2018-09-24 00:00:00		2020-07-13 00:00:00		2020-07-21 00:00:00		None		2018-10-30 00:00:00		2018-01-21 00:00:00		None		2018-05-24 00:00:00		2018-09-20 00:00:00		2018-10-09 00:00:00		2018-08-22 00:00:00		None		None		None		2019-01-08 00:00:00		2021-01-13 00:00:00		None		2022-07-09 00:00:00		None		2022-01-12 00:00:00		2021-07-13 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		22001		None		None		None		22001		None		22001		None		None		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		None		22001		None		None		22001		None		22001		22001		None		22001		22001		22001		None		None		None		22001		None		22001		22001		22001		22001		22001		22001		None		None		22001		None		None		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		None		None		None		22001		22001		None		22001		None		22001		22001		None		None

Table: filer_to_filer_type

filer_id		1009365
filer_type		10
active		Y
race		0
session_id		1981
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		None
county_cd		18042
district_cd		None

Table: filer_xref

filer_id		1009365
xref_id		482268
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		482268		482268		482268		482268		482268		482268		482268		482268
filer_id		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365
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
status		ACTIVE		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		1990-12-01 00:00:00
naml		CALIFORNIA-AMERICAN WATER COMPANY		CALIFORNIA-AMERICAN WATER COMPANY		CALIFORNIA-AMERICAN WATER COMPANY		CALIFORNIA-AMERICAN WATER COMPANY		CALIFORNIA AMERICAN WATER, A WHOLLY-OWNED SUBSIDIARY OF AMERICAN WATER WORKS CO.		CALIFORNIA AMERICAN WATER, A WHOLLY-OWNED SUBSIDIARY OF AMERICAN WATER WORKS CO.		CALIFORNIA AMERICAN WATER, A WHOLLY-OWNED SUBSIDIARY OF AMERICAN WATER WORKS CO.		CALIFORNIA AMERICAN WATER, A WHOLLY-OWNED SUBSIDIARY OF AMERICAN WATER WORKS CO.
namf		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None
city		CHULA VISTA		CHULA VISTA		CORONADO		SAN DIEGO		CHULA VISTA		CHULA VISTA		CORONADO		SAN DIEGO
st		CA		CA		CA		CA		CA		CA		CA		CA
zip4		919140000		919100000		921180000		92101		919140000		919100000		921180000		92101
phon		6196562400		6194097700		6194357402		6194464763		6196562400		6194097700		6194357402		6194464763
fax		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		None

Table: filers

filer_id		1009365

Table: received_filings

filer_id		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365		1009365
filing_file_name		683495_0.cal		713434_0.cal		769936_0.cal		785459_0.cal		185101.cal		769936_1.cal		785459_1.cal		187541.cal		187493.cal		802980_0.cal		881050_0.cal		908633_0.cal		1080638_0.cal		1395755_0.cal		1345437_0.cal		1310888_0.cal		1846850_0.cal		1846852_0.cal		1851234_0.cal		494618.cal		494653.cal		1839786_0.cal		1831253_0.cal		1837087_0.cal		1783368_0.cal		1538862_0.cal		1568289_0.cal		1839953_0.cal		1826645_0.cal		1818137_0.cal		1605804_0.cal		66064.cal		1632569_0.cal		1856907_0.cal		1870496_0.cal		1855526_0.cal		1981251_0.cal		2058753_0.cal		2005874_0.cal		2085924_0.cal		2080151_0.cal		2086631_0.cal		1897980_0.cal		2090896_0.cal		2092437_0.cal		2105869_0.cal		2105876_0.cal		1899150_0.cal		2076278_0.cal		1935528_0.cal		2291167_0.cal		2253059_1.cal		2294995_0.cal		2316784_0.cal		2253059_0.cal		2293884_0.cal		2303842_0.cal		2285564_0.cal
received_date		2000-11-01 00:00:00		2001-01-23 00:00:00		2001-07-25 00:00:00		2001-10-09 00:00:00		2002-01-02 00:00:00		2002-01-02 00:00:00		2002-01-02 00:00:00		2002-01-02 00:00:00		2002-01-02 00:00:00		2002-01-02 00:00:00		2002-10-28 00:00:00		2003-01-29 00:00:00		2005-01-31 00:00:00		2009-01-30 00:00:00		2008-07-23 00:00:00		2008-01-31 00:00:00		2014-05-02 00:00:00		2014-05-02 00:00:00		2014-05-17 00:00:00		2013-01-29 00:00:00		2013-01-29 00:00:00		2014-04-21 00:00:00		2014-03-21 00:00:00		2014-04-08 00:00:00		2013-07-31 00:00:00		2010-10-29 00:00:00		2011-01-27 00:00:00		2014-04-21 00:00:00		2014-03-07 00:00:00		2014-01-31 00:00:00		2011-07-28 00:00:00		2012-01-30 00:00:00		2012-01-26 00:00:00		2014-05-30 00:00:00		2014-07-30 00:00:00		2014-05-28 00:00:00		2015-07-30 00:00:00		2016-07-26 00:00:00		2016-01-24 00:00:00		2016-10-06 00:00:00		2016-09-22 00:00:00		2016-10-07 00:00:00		2014-10-14 00:00:00		2016-10-18 00:00:00		2016-10-20 00:00:00		2016-11-07 00:00:00		2016-11-07 00:00:00		2014-10-16 00:00:00		2016-09-13 00:00:00		2015-01-31 00:00:00		2018-09-12 00:00:00		2018-06-07 00:00:00		2018-09-24 00:00:00		2018-10-30 00:00:00		2018-05-24 00:00:00		2018-09-20 00:00:00		2018-10-09 00:00:00		2018-08-22 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/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/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/temp		/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/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/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		683495		713434		769936		785459		None		769936		785459		None		None		802980		881050		908633		1080638		1395755		1345437		1310888		1846850		1846852		1851234		None		None		1839786		1831253		1837087		1783368		1538862		1568289		1839953		1826645		1818137		1605804		None		1632569		1856907		1870496		1855526		1981251		2058753		2005874		2085924		2080151		2086631		1897980		2090896		2092437		2105869		2105876		1899150		2076278		1935528		2291167		2253059		2294995		2316784		2253059		2293884		2303842		2285564
form_id		F497		F461		F461		F461		None		F461		F461		None		None		F461		F497		F461		F461		F461		F461		F461		F497		F497		F497		None		None		F497		F497		F497		F461		F497		F461		F497		F497		F461		F461		None		F461		F497		F461		F497		F461		F461		F461		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F461		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		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 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 accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted