Home

Filer ID: 1011153

Table: filer_address

filer_id		1011153		1011153
adrid		1010480		2199318
effect_dt		2008-01-31 00:00:00		2010-08-02 00:00:00
add_type		7051		7051
session_id		2007		2009

Table: filer_filings

filer_id		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153
filing_id		68928		68929		68930		68931		68933		68934		68935		68936		204085		204086		204087		204088		68932		585283		598472		600152		601634		666100		645121		772441		792529		814123		825221		834792		826332		828648		829333		858468		857083		825221		915267		912526		954404		947994		1007149		990915		1049851		1049226		1051662		1058216		1094778		1079840		1116991		1118738		1147561		1210263		1192298		1202509		1210263		1220526		1253533		1269057		1269121		1270977		1236338		1288411		1938506		1937362		1572482		1575882		1898623		1896410		1899993		1896508		1312964		1336534		1339209		1351641		1352811		1337634		1339504		1401658		1398462		1438673		1464680		1465469		1442500		1508369		1513999		1528804		1529710		1534418		1543704		1544465		1532844		1575882		1572482		1912175		1742347		2367763		2255289		2395638		2248197		2314588		2289796		2244948		2025066		2058689		2049031		2056318		2086678		2078530		2073554		2102616		2097468		2096083		2095302		2088569		2096083		2103704		2125507		2144569		2221282		2524532		2404597		2347635		2224911		2205119		2269272		2442387		2548398		2476624		2272447		2607898		2648238		2567040		2643513		2607898
period_id		113		121		133		138		140		139		145		149		109		135		140		153		137		None		161		161		None		None		161		165		None		167		169		None		169		None		None		None		169		171		None		171		None		173		None		175		180		180		None		None		None		177		181		None		183		188		185		None		188		188		None		None		None		None		187		None		None		217		203		None		220		220		220		220		None		194		194		193		None		None		None		None		195		197		None		199		None		201		None		204		204		None		None		None		204		None		203		220		None		None		234		237		234		236		235		234		225		None		226		225		228		227		227		228		228		228		228		228		228		228		227		None		None		244		None		235		233		229		233		239		241		None		None		None		None		None		247		None
form_id		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F497		F461		F461		F461		F497		F497		F497		F461		F461		F461		F461		F461		F497		F497		F497		F461		F497		F461		F461		F497		F461		F461		F461		F461		F461		F461		F497		F497		F497		F497		F461		F461		F461		F461		F461		F497		F461		F461		F497		F497		F461		F497		F497		F497		F461		F461		F461		F461		F461		F461		F497		F497		F497		F497		F461		F497		F497		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F497		F497		F497		F497		F461		F461		F497		F461		F461		F497		F461		F497		F497		F497		F497		F497		F461		F497		F461		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F461		F461		F461		F497		F461		F461		F497		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		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		1		0		0		0		0		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		1		0		0		0		0
filing_date		1988-12-20 00:00:00		1991-01-31 00:00:00		1993-08-02 00:00:00		1994-05-25 00:00:00		1994-11-02 00:00:00		1995-01-31 00:00:00		1997-01-31 00:00:00		1997-07-31 00:00:00		1988-02-01 00:00:00		1994-01-28 00:00:00		1994-11-05 00:00:00		1998-07-29 00:00:00		1994-08-01 00:00:00		2000-01-31 00:00:00		2000-03-01 00:00:00		2000-03-02 00:00:00		2000-03-01 00:00:00		2000-07-31 00:00:00		2000-07-31 00:00:00		2001-07-31 00:00:00		2001-07-31 00:00:00		2002-01-31 00:00:00		2002-02-23 00:00:00		2002-02-26 00:00:00		2002-02-26 00:00:00		2002-01-31 00:00:00		2002-02-23 00:00:00		2002-07-31 00:00:00		2002-07-31 00:00:00		2002-07-29 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2003-07-31 00:00:00		2003-07-31 00:00:00		2004-01-02 00:00:00		2004-02-02 00:00:00		2004-10-20 00:00:00		2004-10-19 00:00:00		2004-10-19 00:00:00		2004-10-20 00:00:00		2005-01-28 00:00:00		2005-01-31 00:00:00		2005-07-29 00:00:00		2005-07-28 00:00:00		2006-01-31 00:00:00		2006-10-23 00:00:00		2006-07-31 00:00:00		2006-07-31 00:00:00		2006-11-03 00:00:00		2006-11-06 00:00:00		2007-01-30 00:00:00		2006-10-23 00:00:00		2006-11-03 00:00:00		2006-11-06 00:00:00		2007-01-30 00:00:00		2007-07-31 00:00:00		2015-02-02 00:00:00		2015-02-02 00:00:00		2015-03-05 00:00:00		2015-03-05 00:00:00		2014-10-15 00:00:00		2014-10-10 00:00:00		2014-10-17 00:00:00		2014-10-10 00:00:00		2008-01-31 00:00:00		2008-05-23 00:00:00		2008-05-30 00:00:00		2008-07-31 00:00:00		2008-07-31 00:00:00		2008-05-23 00:00:00		2008-05-30 00:00:00		2009-02-02 00:00:00		2009-02-02 00:00:00		2009-07-31 00:00:00		2010-01-29 00:00:00		2010-02-01 00:00:00		2009-07-31 00:00:00		2010-08-02 00:00:00		2010-08-02 00:00:00		2010-10-18 00:00:00		2010-10-19 00:00:00		2010-10-19 00:00:00		2010-10-18 00:00:00		2010-10-22 00:00:00		2010-10-22 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2014-10-31 00:00:00		2013-01-31 00:00:00		2019-01-31 00:00:00		2018-05-25 00:00:00		2019-07-29 00:00:00		2018-05-10 00:00:00		2018-10-26 00:00:00		2018-09-07 00:00:00		2018-05-02 00:00:00		2016-03-30 00:00:00		2016-07-19 00:00:00		2016-06-02 00:00:00		2016-07-19 00:00:00		2016-10-07 00:00:00		2016-09-16 00:00:00		2016-09-02 00:00:00		2016-10-31 00:00:00		2016-10-27 00:00:00		2016-11-03 00:00:00		2016-10-25 00:00:00		2016-10-13 00:00:00		2016-10-26 00:00:00		2016-11-02 00:00:00		2017-01-27 00:00:00		2017-01-27 00:00:00		2018-01-24 00:00:00		2020-10-27 00:00:00		2019-07-29 00:00:00		2019-01-31 00:00:00		2018-03-23 00:00:00		2018-01-24 00:00:00		2018-07-25 00:00:00		2020-01-31 00:00:00		2021-01-27 00:00:00		2020-01-31 00:00:00		2018-07-25 00:00:00		2021-11-19 00:00:00		2022-01-31 00:00:00		2021-01-28 00:00:00		2022-01-31 00:00:00		2021-08-02 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10005		10005		10001		10001		10005		10001		10001		10005		10001		10005		10005		10005		10001		10002		10005		10001		10005		10001		10005		10001		10001		10001		10005		10005		10005		10001		10001		10005		10001		10001		10001		10005		10002		10001		10005		10005		10005		10005		10001		10005		10005		10001		10002		10006		10001		10001		10001		10001		10005		10001		10001		10001		10005		10005		10005		10005		10001		10001		10005		10001		10005		10001		10005		10001		10001		10005		10005		10005		10001		10005		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10005		10005		10001		10005		10001		10001		10001		10001		10001		10001		10005		10005		10006		10005		10005		10001		10005
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11003		11003		11001		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		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		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		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
session_id		1987		1989		1993		1993		1993		1993		1995		1997		1987		1993		1993		1997		1993		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2013		2013		2009		2011		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2009		2013		2011		2019		2017		2019		2017		2017		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2019		2019		2017		2017		2017		2017		2019		2019		2019		2017		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		*		*		*		EMCENTEE		*		*		DBARRICK		*		*		BINTHAVO		*		LTHIBAUL		KLARRY		LTHIBAUL		*		*		LTHIBAUL		COMPLETED		GGILMORE		COMPLETED		DHORRELL		COMPLETED		GKURIMOT		PBANFORD		GPEREZ		LLEONG		DHORRELL		COMPLETED		*		DHORRELL		*		DHORRELL		SMCCABE		JMARTIN		DHORRELL		DHORRELL		JMARTIN		DHORRELL		CFLAGG		RGEREMIA		SMCCABE		JMARTIN		JINGRAM		JINGRAM		JINGRAM		JINGRAM		CAFILER		CAFILER		CAFILER		CAFILER		SMCCABE		PBANFORD		DHORRELL		MGUERRA		MGUERRA		LHOANG		DHORRELL		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		PBANFORD		PBANFORD		MPACHECO		MPACHECO		MPACHECO		CREYNOLDS		JINGRAM		JINGRAM		CAFILER		JINGRAM		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		CAFILER		RGEREMIA		KBANH		JINGRAM		KBANH		JINGRAM		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		JINGRAM		JINGRAM		DMCCASTL		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		DMCCASTL		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR
special_audit		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		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
fine_audit		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		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		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		11003		11003		11003		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001
rpt_start		1988-01-01 00:00:00		1990-01-01 00:00:00		1993-01-01 00:00:00		None		None		1994-07-01 00:00:00		1996-01-01 00:00:00		1997-01-01 00:00:00		1987-01-01 00:00:00		1993-07-01 00:00:00		None		1998-01-01 00:00:00		1994-01-01 00:00:00		1999-01-01 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		None		2000-01-01 00:00:00		2000-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2002-02-23 00:00:00		None		2002-02-26 00:00:00		2001-07-01 00:00:00		None		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-07-29 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2004-10-20 00:00:00		2004-10-19 00:00:00		None		None		2004-01-01 00:00:00		2004-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2006-10-23 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2006-11-03 00:00:00		2006-11-06 00:00:00		2006-07-01 00:00:00		None		None		None		2006-07-01 00:00:00		2007-01-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2014-10-15 00:00:00		2014-10-10 00:00:00		2014-10-17 00:00:00		2014-10-10 00:00:00		2007-07-01 00:00:00		2008-05-23 00:00:00		2008-05-30 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		None		None		2008-07-01 00:00:00		2008-07-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2009-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-10-18 00:00:00		2010-10-19 00:00:00		None		None		None		2010-10-22 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2014-10-31 00:00:00		2012-01-01 00:00:00		2018-07-01 00:00:00		2018-05-25 00:00:00		2019-01-01 00:00:00		2018-05-10 00:00:00		2018-10-26 00:00:00		2018-09-07 00:00:00		2018-05-02 00:00:00		2016-03-30 00:00:00		2016-01-01 00:00:00		2016-06-02 00:00:00		2016-01-01 00:00:00		2016-10-07 00:00:00		2016-09-16 00:00:00		2016-09-02 00:00:00		2016-10-31 00:00:00		2016-10-27 00:00:00		2016-11-03 00:00:00		2016-10-25 00:00:00		2016-10-13 00:00:00		2016-10-26 00:00:00		2016-11-02 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2020-10-27 00:00:00		2019-01-01 00:00:00		2018-07-01 00:00:00		2018-03-23 00:00:00		2017-01-01 00:00:00		2018-01-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2018-01-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2020-01-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00
rpt_end		1988-12-31 00:00:00		1990-12-31 00:00:00		1993-06-30 00:00:00		None		None		1994-12-31 00:00:00		1996-12-31 00:00:00		1997-06-30 00:00:00		1987-12-31 00:00:00		1993-12-31 00:00:00		None		1998-06-30 00:00:00		1994-06-30 00:00:00		1999-12-31 00:00:00		2000-02-29 00:00:00		2000-02-29 00:00:00		None		2000-06-30 00:00:00		2000-06-30 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2002-02-23 00:00:00		None		2002-02-26 00:00:00		2001-12-31 00:00:00		None		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-07-29 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-10-20 00:00:00		2004-10-19 00:00:00		None		None		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2006-10-23 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2006-11-03 00:00:00		2006-11-06 00:00:00		2006-12-31 00:00:00		None		None		None		2006-12-31 00:00:00		2007-06-30 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2014-10-15 00:00:00		2014-10-10 00:00:00		2014-10-17 00:00:00		2014-10-10 00:00:00		2007-12-31 00:00:00		2008-05-23 00:00:00		2008-05-30 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		None		None		2008-12-31 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2009-06-30 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-10-18 00:00:00		2010-10-19 00:00:00		None		None		None		2010-10-22 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2014-10-31 00:00:00		2012-12-31 00:00:00		2018-12-31 00:00:00		2018-05-25 00:00:00		2019-06-30 00:00:00		2018-05-10 00:00:00		2018-10-26 00:00:00		2018-09-07 00:00:00		2018-05-02 00:00:00		2016-03-30 00:00:00		2016-06-30 00:00:00		2016-06-02 00:00:00		2016-06-30 00:00:00		2016-10-07 00:00:00		2016-09-16 00:00:00		2016-09-02 00:00:00		2016-10-31 00:00:00		2016-10-27 00:00:00		2016-11-03 00:00:00		2016-10-25 00:00:00		2016-10-13 00:00:00		2016-10-26 00:00:00		2016-11-02 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-12-31 00:00:00		2020-10-27 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2018-03-23 00:00:00		2017-12-31 00:00:00		2018-06-30 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		2019-12-31 00:00:00		2018-06-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2020-12-31 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2000-02-29 00:00:00		2000-02-29 00:00:00		None		None		2000-07-31 00:00:00		2001-07-31 00:00:00		None		2002-01-31 00:00:00		2002-02-23 00:00:00		None		2002-02-26 00:00:00		None		None		None		2002-07-31 00:00:00		2002-07-29 00:00:00		None		2003-01-31 00:00:00		None		2003-07-31 00:00:00		None		2004-02-02 00:00:00		2004-10-20 00:00:00		2004-10-19 00:00:00		None		None		None		2005-01-31 00:00:00		2005-07-29 00:00:00		None		2006-01-31 00:00:00		2006-10-23 00:00:00		2006-07-31 00:00:00		None		2006-11-03 00:00:00		2006-11-06 00:00:00		None		None		None		None		2006-12-31 00:00:00		None		None		2015-02-02 00:00:00		2015-03-05 00:00:00		None		2014-10-15 00:00:00		2014-10-10 00:00:00		2014-10-17 00:00:00		2014-10-10 00:00:00		None		2008-05-23 00:00:00		2008-05-30 00:00:00		2008-07-31 00:00:00		None		None		None		None		2009-02-02 00:00:00		2009-07-31 00:00:00		None		2010-02-01 00:00:00		None		2010-08-02 00:00:00		None		2010-10-18 00:00:00		2010-10-19 00:00:00		None		None		None		2010-10-22 00:00:00		None		2011-01-31 00:00:00		2014-10-31 00:00:00		None		None		2018-05-25 00:00:00		2019-07-29 00:00:00		2018-05-10 00:00:00		2018-10-26 00:00:00		2018-09-07 00:00:00		2018-05-02 00:00:00		2016-03-30 00:00:00		None		2016-06-02 00:00:00		2016-07-19 00:00:00		2016-10-07 00:00:00		2016-09-16 00:00:00		2016-09-02 00:00:00		2016-10-31 00:00:00		2016-10-27 00:00:00		2016-11-03 00:00:00		2016-10-25 00:00:00		2016-10-13 00:00:00		2016-10-26 00:00:00		2016-11-02 00:00:00		2017-01-26 00:00:00		None		None		2020-10-27 00:00:00		None		2019-01-30 00:00:00		2018-03-23 00:00:00		2018-01-24 00:00:00		2018-07-25 00:00:00		2020-01-11 00:00:00		2021-01-17 00:00:00		None		None		None		None		None		2022-01-22 00:00:00		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		22001		None		22001		22001		22001		None		None		None		22001		22001		None		22001		22001		22001		None		22001		22001		None		None		None		None		22001		None		None		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		None		None		None		None		22001		22001		None		22001		None		22001		None		22001		22001		None		None		None		22001		None		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		None		22001		22001		22001		22001		22001		22001		None		None		None		None		None		22001		None

Table: filer_to_filer_type

filer_id		1011153
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		None
county_cd		18043
district_cd		None

Table: filer_xref

filer_id		1011153
xref_id		488046
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		488046		488046
filer_id		1011153		1011153
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00
naml		NATURE CONSERVANCY, THE		NATURE CONSERVANCY ACTION FUND, THE
namf		None		None
namt		None		None
nams		None		None
adr1		None		None
adr2		None		None
city		SAN FRANCISCO		SAN FRANCISCO
st		CA		CA
zip4		94105		94105
phon		4157770487		4157770487
fax		None		None
email		None		None

Table: filers

filer_id		1011153

Table: received_filings

filer_id		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153		1011153
filing_file_name		598472_0.cal		645121_0.cal		772441_0.cal		814123_0.cal		825221_0.cal		826332_0.cal		50567.cal		825221_1.cal		857083_0.cal		912526_0.cal		947994_0.cal		990915_0.cal		1049226_0.cal		1049851_0.cal		1079840_0.cal		1116991_0.cal		1147561_0.cal		1210263_0.cal		1336534_0.cal		1398462_0.cal		1339209_0.cal		1351641_0.cal		1508369_0.cal		1210263_1.cal		1220526_0.cal		1236338_0.cal		1465469_0.cal		1438673_0.cal		1528804_0.cal		1529710_0.cal		1532844_0.cal		1572482_0.cal		2049031_0.cal		282693.cal		2096083_1.cal		2102616_0.cal		2103704_0.cal		2078530_0.cal		2097468_0.cal		2086678_0.cal		2088569_0.cal		2025066_0.cal		58383.cal		1898623_0.cal		1896410_0.cal		1896508_0.cal		2095302_0.cal		2096083_0.cal		1899993_0.cal		2073554_0.cal		1912175_0.cal		2255289_0.cal		2314588_0.cal		2244948_0.cal		2289796_0.cal		2248197_0.cal		2224911_0.cal		2524532_0.cal
received_date		2000-03-01 00:00:00		2000-07-31 00:00:00		2001-07-31 00:00:00		2002-01-31 00:00:00		2002-02-23 00:00:00		2002-02-26 00:00:00		2002-03-01 00:00:00		2002-07-29 00:00:00		2002-07-31 00:00:00		2003-01-31 00:00:00		2003-07-31 00:00:00		2004-02-02 00:00:00		2004-10-19 00:00:00		2004-10-20 00:00:00		2005-01-31 00:00:00		2005-07-29 00:00:00		2006-01-31 00:00:00		2006-10-23 00:00:00		2008-05-23 00:00:00		2009-02-02 00:00:00		2008-05-30 00:00:00		2008-07-31 00:00:00		2010-08-02 00:00:00		2006-11-03 00:00:00		2006-11-06 00:00:00		2007-01-30 00:00:00		2010-02-01 00:00:00		2009-07-31 00:00:00		2010-10-18 00:00:00		2010-10-19 00:00:00		2010-10-22 00:00:00		2011-01-31 00:00:00		2016-06-02 00:00:00		2016-06-02 00:00:00		2016-11-03 00:00:00		2016-10-31 00:00:00		2016-11-02 00:00:00		2016-09-16 00:00:00		2016-10-27 00:00:00		2016-10-07 00:00:00		2016-10-13 00:00:00		2016-03-30 00:00:00		2016-03-30 00:00:00		2014-10-15 00:00:00		2014-10-10 00:00:00		2014-10-10 00:00:00		2016-10-25 00:00:00		2016-10-26 00:00:00		2014-10-17 00:00:00		2016-09-02 00:00:00		2014-10-31 00:00:00		2018-05-25 00:00:00		2018-10-26 00:00:00		2018-05-02 00:00:00		2018-09-07 00:00:00		2018-05-10 00:00:00		2018-03-23 00:00:00		2020-10-27 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/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		/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/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
filing_id		598472		645121		772441		814123		825221		826332		None		825221		857083		912526		947994		990915		1049226		1049851		1079840		1116991		1147561		1210263		1336534		1398462		1339209		1351641		1508369		1210263		1220526		1236338		1465469		1438673		1528804		1529710		1532844		1572482		2049031		None		2096083		2102616		2103704		2078530		2097468		2086678		2088569		2025066		None		1898623		1896410		1896508		2095302		2096083		1899993		2073554		1912175		2255289		2314588		2244948		2289796		2248197		2224911		2524532
form_id		F497		F461		F461		F461		F497		F497		None		F497		F461		F461		F461		F461		F497		F497		F461		F461		F461		F497		F497		F461		F497		F461		F461		F497		F497		F461		F461		F461		F497		F497		F497		F461		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		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		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		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