Home

Filer ID: 1007846

Table: filer_address

filer_id		1007846
adrid		1007080
effect_dt		2008-01-15 00:00:00
add_type		7051
session_id		2007

Table: filer_filings

filer_id		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846
filing_id		41852		41853		41854		41855		41856		41857		41858		41859		41860		41861		41862		41863		41864		41865		41866		41867		41869		41870		41871		41872		41873		41874		41875		41876		41877		41878		41879		41880		41881		41882		41883		41884		41885		41886		41887		41888		41889		41890		41891		41892		41893		41895		41896		41897		41898		41899		41900		41901		41902		41903		41904		41905		41906		41907		41908		41909		41910		41911		41912		41913		41915		41916		41917		41918		41920		41921		41922		41923		41925		41926		41927		41928		41929		41930		41931		41932		41933		41934		41935		41936		41937		41938		41939		41940		41941		41942		200217		200218		200219		200220		200221		200222		200223		200224		200225		200226		200227		200228		200230		200231		200229		579222		590889		41868		41894		41914		41919		41924		673571		765785		749049		785678		785682		785683		784770		788526		809325		803263		831632		832638		826454		829290		848484		852557		940598		934171		940598		968009		978587		936974		1007010		1027017		1038088		1070856		1060465		1057099		1114561		1060708		1070856		1080411		1080411		1130363		1143842		1155211		1227965		1219093		1248820		1867138		1952633		1902559		1906239		1304454		1392537		1512115		1529938		1543754		1544038		1537029		1565907		1581189		1671470		1833275		1926498		1881117		1878965		1888331		1723083		1726088		1848626		2351475		2262272		2335384		2049350		2265010		2682837		2682815		2682815		2717702		2722807		2737007		2733257
period_id		74		74		75		76		75		75		77		77		78		79		81		81		82		82		82		82		83		84		83		83		84		83		84		85		85		86		87		88		85		89		87		88		89		90		90		90		91		91		91		92		92		93		94		95		95		97		97		97		98		99		99		99		100		100		100		101		93		87		103		103		108		107		105		105		109		109		113		115		117		119		121		115		123		125		127		130		130		129		132		133		135		137		145		153		156		155		73		76		76		77		87		89		89		90		99		101		104		107		139		156		131		None		None		82		92		105		107		117		None		None		None		165		166		167		None		None		None		167		None		None		169		None		169		None		173		171		173		None		175		None		None		177		None		179		None		180		181		None		179		None		None		None		184		None		187		None		None		None		None		220		220		None		None		None		204		None		None		204		203		None		None		217		217		219		219		219		211		None		218		None		233		235		226		None		250		249		248		251		None		252		252
form_id		F461		F461		F461		F777		F461		F405		F480		F405		F480		F461		F461		F405		F777		F461		F777		F777		F461		F777		F461		F405		F777		F405		F461		F461		F461		F461		F461		F461		F465		F461		F405		F405		F461		F777		F777		F461		F465		F461		F461		F777		F777		F461		F461		F461		F461		F461		F405		F461		F461		F461		F461		F405		F461		F405		F405		F461		F405		F461		F461		F461		F777		F461		F405		F405		F461		F405		F461		F461		F405		F461		F461		F405		F461		F461		F461		F497		F497		F461		F777		F461		F461		F461		F461		F461		F497		F461		F440		F777		F461		F461		F405		F465		F465		F465		F405		F405		F461		F405		F461		F497		F461		F461		F999		F461		F461		F461		F405		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F497		F497		F497		F497		F461		F461		F461		F497		F461		F497		F497		F497		F461		F461		F497		F461		F461		F461		F497		F461		F497		F461		F461		F497		F461		F497		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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		1		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		1		0		0		0		0		0
filing_date		1978-05-25 00:00:00		1978-07-31 00:00:00		1978-09-29 00:00:00		1978-11-02 00:00:00		1978-10-26 00:00:00		1978-11-13 00:00:00		1979-05-09 00:00:00		1979-06-12 00:00:00		1979-07-16 00:00:00		1980-01-31 00:00:00		1980-04-30 00:00:00		1980-05-19 00:00:00		1980-05-29 00:00:00		1980-05-22 00:00:00		1980-05-27 00:00:00		1980-05-30 00:00:00		1980-09-30 00:00:00		1980-10-24 00:00:00		1980-10-23 00:00:00		1980-10-27 00:00:00		1980-11-01 00:00:00		1981-02-06 00:00:00		1981-02-02 00:00:00		1981-03-20 00:00:00		1981-05-20 00:00:00		1981-07-31 00:00:00		1981-10-22 00:00:00		1982-02-01 00:00:00		1982-02-01 00:00:00		1982-03-22 00:00:00		1982-05-17 00:00:00		1982-05-17 00:00:00		1982-05-27 00:00:00		1982-06-04 00:00:00		1982-06-09 00:00:00		1982-08-02 00:00:00		1982-09-22 00:00:00		1982-09-22 00:00:00		1982-10-21 00:00:00		1982-10-25 00:00:00		1982-10-30 00:00:00		1983-03-22 00:00:00		1983-08-01 00:00:00		1983-09-21 00:00:00		1984-01-31 00:00:00		1984-03-22 00:00:00		1984-05-24 00:00:00		1984-05-24 00:00:00		1984-07-31 00:00:00		1984-09-24 00:00:00		1984-10-25 00:00:00		1984-11-20 00:00:00		1985-01-24 00:00:00		1985-03-14 00:00:00		1985-07-26 00:00:00		1985-07-26 00:00:00		1985-07-26 00:00:00		1981-09-22 00:00:00		1985-09-23 00:00:00		1985-10-23 00:00:00		1986-10-28 00:00:00		1987-01-26 00:00:00		1987-03-05 00:00:00		1987-06-01 00:00:00		1988-02-01 00:00:00		1988-02-26 00:00:00		1988-08-01 00:00:00		1989-01-31 00:00:00		1989-08-07 00:00:00		1990-01-30 00:00:00		1990-07-31 00:00:00		1990-10-01 00:00:00		1991-01-31 00:00:00		1991-07-29 00:00:00		1992-01-30 00:00:00		1992-05-22 00:00:00		1992-05-27 00:00:00		1992-07-31 00:00:00		1992-10-23 00:00:00		1993-08-02 00:00:00		1994-01-31 00:00:00		1994-08-01 00:00:00		1997-01-31 00:00:00		1998-07-31 00:00:00		1998-10-20 00:00:00		1999-02-01 00:00:00		1978-05-01 00:00:00		1978-11-03 00:00:00		1979-01-31 00:00:00		1979-07-18 00:00:00		1981-12-24 00:00:00		1982-03-22 00:00:00		1982-05-27 00:00:00		1982-08-02 00:00:00		1985-07-26 00:00:00		1985-09-10 00:00:00		1986-01-16 00:00:00		1987-03-05 00:00:00		1995-01-31 00:00:00		1998-10-29 00:00:00		1993-02-01 00:00:00		2000-01-10 00:00:00		2000-02-14 00:00:00		1980-07-29 00:00:00		1983-01-31 00:00:00		1986-07-21 00:00:00		1987-06-01 00:00:00		1989-07-31 00:00:00		2000-07-31 00:00:00		2001-05-01 00:00:00		2001-01-31 00:00:00		2001-10-10 00:00:00		2001-10-10 00:00:00		2001-10-10 00:00:00		2001-07-26 00:00:00		2001-10-09 00:00:00		2002-01-09 00:00:00		2002-01-03 00:00:00		2002-02-27 00:00:00		2002-02-26 00:00:00		2002-02-26 00:00:00		2002-01-31 00:00:00		2002-07-08 00:00:00		2002-07-25 00:00:00		2003-07-07 00:00:00		2003-05-08 00:00:00		2003-07-07 00:00:00		2003-07-11 00:00:00		2004-01-07 00:00:00		2003-05-08 00:00:00		2004-01-12 00:00:00		2004-07-28 00:00:00		2004-07-30 00:00:00		2005-01-11 00:00:00		2004-10-29 00:00:00		2004-10-29 00:00:00		2005-07-26 00:00:00		2004-10-29 00:00:00		2005-01-31 00:00:00		2005-01-18 00:00:00		2005-02-07 00:00:00		2005-10-21 00:00:00		2006-01-24 00:00:00		2006-01-27 00:00:00		2007-01-15 00:00:00		2006-07-17 00:00:00		2007-01-19 00:00:00		2014-07-21 00:00:00		2015-01-20 00:00:00		2014-10-22 00:00:00		2014-10-27 00:00:00		2008-01-15 00:00:00		2009-01-22 00:00:00		2010-07-29 00:00:00		2010-10-20 00:00:00		2010-10-20 00:00:00		2010-10-27 00:00:00		2010-10-27 00:00:00		2011-01-25 00:00:00		2011-01-31 00:00:00		2012-07-11 00:00:00		2014-03-25 00:00:00		2015-01-16 00:00:00		2014-08-28 00:00:00		2014-08-19 00:00:00		2014-09-25 00:00:00		2013-01-08 00:00:00		2013-01-14 00:00:00		2014-05-09 00:00:00		2019-01-22 00:00:00		2018-07-03 00:00:00		2019-01-17 00:00:00		2016-06-03 00:00:00		2018-07-09 00:00:00		2022-05-16 00:00:00		2022-08-04 00:00:00		2022-05-16 00:00:00		2022-09-07 00:00:00		2022-08-04 00:00:00		2022-10-20 00:00:00		2022-10-14 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		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10001		10005		10005		10005		10001		10001		10001		10005		10005		10005		10001		10005		10005		10001		10005		10001		10005		10001		10001		10002		10006		10001		10005		10005		10001		10005		10001		10005		10001		10001		10005		10002		10005		10006		10005		10001		10005		10001		10005		10005		10005		10005		10001		10001		10005		10005		10005		10001		10005		10005		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10005		10001		10005		10001		10001		10001		10005		10001		10002		10001		10001		10005		10001		10001
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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11003
session_id		1977		1977		1977		1977		1977		1977		1979		1979		1979		1979		1979		1979		1979		1979		1979		1979		1979		1979		1979		1979		1979		1979		1979		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1985		1983		1981		1985		1985		1985		1985		1985		1985		1987		1987		1987		1987		1989		1989		1989		1987		1989		1991		1991		1991		1991		1991		1991		1993		1993		1993		1995		1997		1997		1997		1977		1977		1977		1979		1981		1981		1981		1981		1983		1985		1985		1985		1993		1997		1991		1999		1999		1979		1981		1985		1985		1989		1999		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2003		2003		2003		2001		2003		2003		2003		2003		2003		2003		2005		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2013		2013		2013		2013		2007		2007		2009		2009		2009		2009		2009		2009		2009		2011		2013		2013		2013		2013		2013		2011		2011		2013		2019		2017		2017		2015		2017		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		*		*		*		*		*		*		MKIENG		YBONILLA		MKIENG		*		*		*		DBARRICK		DBARRICK		DBARRICK		*		RALLMOND		BINTHAVO		*		DBARRICK		*		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		DWALKER		COMPLETED		DBARRICK		DHORRELL		COMPLETED		DHORRELL		COMPLETED		EMCENTEE		GKURIMOT		*		LLEONG		COMPLETED		DHORRELL		DHORRELL		DHORRELL		DHORRELL		DHORRELL		*		JMARTIN		JMARTIN		JINGRAM		RGEREMIA		CAFILER		CAFILER		SMCCABE		JINGRAM		JINGRAM		GKURIMOT		MPACHECO		MPACHECO		SARRIAGA		JINGRAM		DMCCASTL		JINGRAM		WBROWN		RGEREMIA		CAFILER		CAFILER		CAFILER		JINGRAM		JINGRAM		WBROWN		GTAYLOR		GTAYLOR		GTAYLOR		KBANH		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		CAFILER		LPHEAV		CAFILER		CAFILER
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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		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
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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		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		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11003		11003		11003		11001		11003		11003		11001		11001		11003		11001		11003		11003
rpt_start		1978-04-24 00:00:00		1978-06-23 00:00:00		1978-07-01 00:00:00		None		1978-09-24 00:00:00		1978-07-01 00:00:00		1979-01-01 00:00:00		1979-01-01 00:00:00		1979-05-08 00:00:00		1979-07-01 00:00:00		1980-01-01 00:00:00		1980-01-01 00:00:00		None		1980-04-24 00:00:00		None		None		1980-07-01 00:00:00		None		1980-09-24 00:00:00		1980-07-01 00:00:00		None		1980-09-24 00:00:00		1980-10-21 00:00:00		1981-01-01 00:00:00		1981-03-18 00:00:00		1981-05-17 00:00:00		1981-09-18 00:00:00		1981-10-18 00:00:00		1981-01-01 00:00:00		1982-01-01 00:00:00		1981-09-18 00:00:00		1981-10-18 00:00:00		1982-03-18 00:00:00		None		None		1982-05-23 00:00:00		1982-07-01 00:00:00		1982-07-01 00:00:00		1982-09-18 00:00:00		None		None		1983-01-01 00:00:00		1983-05-22 00:00:00		1983-07-01 00:00:00		1983-09-18 00:00:00		1984-01-01 00:00:00		1984-01-01 00:00:00		1984-03-18 00:00:00		1984-05-20 00:00:00		1984-07-01 00:00:00		1984-09-18 00:00:00		1984-07-01 00:00:00		1984-10-21 00:00:00		1984-10-21 00:00:00		1984-10-21 00:00:00		1985-01-01 00:00:00		1983-03-18 00:00:00		1981-07-01 00:00:00		1985-07-01 00:00:00		1985-09-18 00:00:00		None		1986-07-01 00:00:00		1986-01-01 00:00:00		1986-01-01 00:00:00		1987-01-01 00:00:00		1987-01-01 00:00:00		1988-01-01 00:00:00		1988-07-01 00:00:00		1989-01-01 00:00:00		1989-07-01 00:00:00		1990-01-01 00:00:00		1988-07-01 00:00:00		1990-07-01 00:00:00		1991-01-01 00:00:00		1991-07-01 00:00:00		None		None		1992-01-01 00:00:00		None		1993-01-01 00:00:00		1993-07-01 00:00:00		1994-01-01 00:00:00		1996-01-01 00:00:00		1998-01-01 00:00:00		None		1998-07-01 00:00:00		1978-01-01 00:00:00		None		1978-10-24 00:00:00		1979-01-01 00:00:00		1981-09-18 00:00:00		1982-01-01 00:00:00		1982-03-18 00:00:00		1982-05-23 00:00:00		1984-09-18 00:00:00		1985-01-01 00:00:00		1985-10-20 00:00:00		1986-07-01 00:00:00		1994-07-01 00:00:00		None		1992-07-01 00:00:00		1999-01-01 00:00:00		None		1980-05-20 00:00:00		1982-10-17 00:00:00		1986-01-01 00:00:00		1986-07-01 00:00:00		1989-01-01 00:00:00		2000-01-01 00:00:00		2001-01-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		None		None		2002-02-26 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2002-01-25 00:00:00		2003-01-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		2002-07-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		None		2004-10-29 00:00:00		2005-01-01 00:00:00		None		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2005-01-01 00:00:00		2005-10-01 00:00:00		2005-10-01 00:00:00		2006-07-01 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2014-10-22 00:00:00		2014-10-27 00:00:00		2007-01-01 00:00:00		2008-01-01 00:00:00		2010-01-01 00:00:00		2010-10-20 00:00:00		None		None		2010-10-27 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2012-01-01 00:00:00		2014-03-25 00:00:00		2014-01-01 00:00:00		2014-08-28 00:00:00		2014-08-19 00:00:00		2014-09-25 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2014-05-09 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2016-06-03 00:00:00		2018-01-01 00:00:00		2022-05-16 00:00:00		2022-01-01 00:00:00		2021-12-31 00:00:00		2022-09-07 00:00:00		2022-01-01 00:00:00		2022-10-20 00:00:00		2022-10-14 00:00:00
rpt_end		1978-05-22 00:00:00		1978-06-30 00:00:00		1978-09-23 00:00:00		None		1978-10-23 00:00:00		1978-09-23 00:00:00		1979-05-03 00:00:00		1979-05-07 00:00:00		1979-07-19 00:00:00		1979-12-31 00:00:00		1980-03-31 00:00:00		1980-03-31 00:00:00		None		1980-05-19 00:00:00		None		None		1980-09-23 00:00:00		None		1980-10-20 00:00:00		1980-09-23 00:00:00		None		1980-10-20 00:00:00		1980-12-31 00:00:00		1981-03-17 00:00:00		1981-05-16 00:00:00		1981-06-30 00:00:00		1981-10-17 00:00:00		1981-12-31 00:00:00		1981-12-31 00:00:00		1982-03-17 00:00:00		1981-10-17 00:00:00		1981-12-31 00:00:00		1982-05-22 00:00:00		None		None		1982-06-30 00:00:00		1982-09-17 00:00:00		1982-09-17 00:00:00		1982-10-16 00:00:00		None		None		1983-03-17 00:00:00		1983-06-30 00:00:00		1983-09-17 00:00:00		1983-12-31 00:00:00		1984-03-17 00:00:00		1984-03-17 00:00:00		1984-05-19 00:00:00		1984-06-30 00:00:00		1984-09-17 00:00:00		1984-10-20 00:00:00		1984-09-17 00:00:00		1984-12-31 00:00:00		1984-12-31 00:00:00		1984-12-31 00:00:00		1985-06-30 00:00:00		1983-05-21 00:00:00		1981-09-17 00:00:00		1985-09-17 00:00:00		1985-10-19 00:00:00		None		1986-12-31 00:00:00		1986-06-30 00:00:00		1986-06-30 00:00:00		1987-12-31 00:00:00		1987-12-31 00:00:00		1988-06-30 00:00:00		1988-12-31 00:00:00		1989-06-30 00:00:00		1989-12-31 00:00:00		1990-06-30 00:00:00		1988-12-31 00:00:00		1990-12-31 00:00:00		1991-06-30 00:00:00		1991-12-31 00:00:00		None		None		1992-06-30 00:00:00		None		1993-06-30 00:00:00		1993-12-31 00:00:00		1994-06-30 00:00:00		1996-12-31 00:00:00		1998-06-30 00:00:00		None		1998-12-31 00:00:00		1978-04-23 00:00:00		None		1978-12-31 00:00:00		1979-06-30 00:00:00		1981-10-17 00:00:00		1982-03-17 00:00:00		1982-05-22 00:00:00		1982-06-30 00:00:00		1984-10-20 00:00:00		1985-06-30 00:00:00		1985-12-31 00:00:00		1986-12-31 00:00:00		1994-12-31 00:00:00		None		1992-12-31 00:00:00		1999-12-31 00:00:00		None		1980-06-30 00:00:00		1982-12-31 00:00:00		1986-06-30 00:00:00		1986-12-31 00:00:00		1989-06-30 00:00:00		2000-06-30 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		None		None		2002-02-26 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-02-26 00:00:00		2003-06-30 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		2002-12-31 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		None		2004-10-29 00:00:00		2005-06-30 00:00:00		None		2004-12-31 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-12-31 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2014-06-30 00:00:00		2014-12-31 00:00:00		2014-10-22 00:00:00		2014-10-27 00:00:00		2007-12-31 00:00:00		2008-12-31 00:00:00		2010-06-30 00:00:00		2010-10-20 00:00:00		None		None		2010-10-27 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2012-06-30 00:00:00		2014-03-25 00:00:00		2014-12-31 00:00:00		2014-08-28 00:00:00		2014-08-19 00:00:00		2014-09-25 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2014-05-09 00:00:00		2018-12-31 00:00:00		2018-06-30 00:00:00		2018-12-31 00:00:00		2016-06-03 00:00:00		2018-06-30 00:00:00		2022-05-16 00:00:00		2022-06-30 00:00:00		2022-06-30 00:00:00		2022-09-07 00:00:00		2022-06-30 00:00:00		2022-10-20 00:00:00		2022-10-14 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2001-10-10 00:00:00		2001-10-10 00:00:00		2001-10-10 00:00:00		None		None		None		2002-01-03 00:00:00		None		None		2002-02-26 00:00:00		None		2002-07-08 00:00:00		None		2003-07-07 00:00:00		2003-05-08 00:00:00		2003-07-07 00:00:00		None		2004-01-07 00:00:00		None		None		2004-07-28 00:00:00		None		2005-01-11 00:00:00		None		2004-10-29 00:00:00		2005-07-26 00:00:00		None		2005-01-31 00:00:00		None		None		None		2006-01-24 00:00:00		None		2007-01-15 00:00:00		None		None		None		None		2014-10-22 00:00:00		2014-10-27 00:00:00		None		None		None		2010-10-20 00:00:00		None		None		2010-10-27 00:00:00		2011-01-25 00:00:00		None		None		2014-03-25 00:00:00		2015-01-16 00:00:00		2014-08-28 00:00:00		2014-08-19 00:00:00		2014-09-25 00:00:00		2013-01-08 00:00:00		None		2014-05-09 00:00:00		None		2018-07-03 00:00:00		2019-01-17 00:00:00		2016-06-03 00:00:00		None		2022-05-16 00:00:00		2022-08-04 00:00:00		2022-05-16 00:00:00		2022-09-07 00:00:00		None		2022-10-20 00:00:00		2022-10-14 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		22001		22001		None		22001		None		None		22001		None		22001		None		22001		22001		None		22001		None		None		None		22001		None		22001		None		None		None		None		22001		22001		None		None		None		22001		None		None		22001		22001		None		None		22001		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001

Table: filer_to_filer_type

filer_id		1007846
filer_type		10
active		Y
race		0
session_id		1989
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		18026
district_cd		None

Table: filer_xref

filer_id		1007846
xref_id		478173
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		478173		478173		478173		478173
filer_id		1007846		1007846		1007846		1007846
filer_type		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
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
naml		J.G. BOSWELL COMPANY, INCLUDING AGGREGATED CONTRIBUTIONS FROM THE YOKOHL RANCH COMPANY, LLC		J.G. BOSWELL COMPANY, INCLUDING AGGREGATED CONTRIBUTIONS FROM EASTLAKE COMPANY, LLC AND YOKOHL RANCH COMPANY, LLC		BOSWELL COMPANY, J.G.		J.G. BOSWELL COMPANY
namf		None		None		None		None
namt		None		None		None		None
nams		None		None		None		None
adr1		None		None		None		None
adr2		None		None		None		None
city		PASADENA		PASADENA		PASADENA		PASADENA
st		CA		CA		CA		CA
zip4		911030000		911030000		911030000		911030000
phon		6265833000		6265833000		6265833000		6265833000
fax		None		None		None		None
email		None		None		None		None

Table: filers

filer_id		1007846

Table: received_filings

filer_id		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846		1007846
filing_file_name		785678_0.cal		785682_0.cal		785683_0.cal		803263_0.cal		78289.cal		826454_0.cal		848484_0.cal		940598_0.cal		940598_1.cal		934171_0.cal		117247.cal		978587_0.cal		1027017_0.cal		409805.cal		1070856_0.cal		1070856_1.cal		1143842_0.cal		1227965_0.cal		164933.cal		1723083_0.cal		1565907_0.cal
received_date		2001-10-10 00:00:00		2001-10-10 00:00:00		2001-10-10 00:00:00		2002-01-03 00:00:00		2002-01-31 00:00:00		2002-02-26 00:00:00		2002-07-08 00:00:00		2003-07-07 00:00:00		2003-07-07 00:00:00		2003-05-08 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-07-28 00:00:00		2004-10-29 00:00:00		2005-01-11 00:00:00		2005-01-31 00:00:00		2006-01-24 00:00:00		2007-01-15 00:00:00		2007-01-12 00:00:00		2013-01-08 00:00:00		2011-01-25 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		/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/temp		/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
filing_id		785678		785682		785683		803263		None		826454		848484		940598		940598		934171		None		978587		1027017		None		1070856		1070856		1143842		1227965		None		1723083		1565907
form_id		F461		F461		F461		F461		None		F497		F461		F461		F461		F461		None		F461		F461		None		F461		F461		F461		F461		None		F461		F461
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted