Home

Filer ID: 1008031

Table: filer_address

filer_id		1008031		1008031
adrid		1007272		2156628
effect_dt		2008-01-29 00:00:00		2008-07-28 00:00:00
add_type		7051		7051
session_id		2007		2007

Table: filer_filings

filer_id		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031
filing_id		45658		45659		45660		45661		45662		45663		45664		45665		45666		45667		45668		45600		45601		45602		45603		45605		45606		45607		45608		45609		45610		45611		45612		45613		45614		45615		45616		45617		45618		45619		45620		45621		45622		45624		45625		45626		45627		45629		45630		45631		45632		45634		45635		45636		45637		45638		45639		45640		45641		45642		45643		45644		45645		45646		45647		45648		45649		45650		45651		45652		45653		45654		45655		45656		45657		200754		200755		200756		200757		200758		200759		200760		200761		200762		200763		200764		200753		45604		45623		45628		45633		586954		677285		676298		668972		718344		762976		762980		809156		832920		869124		858702		886962		906893		973129		1007290		986302		990422		1027849		1034638		1095479		1078133		1136553		1146289		1188973		1179678		1202814		1173541		1179421		1217097		1245749		1232634		1273003		1269676		1272922		1938369		1900549		1888612		1299232		1310842		1348078		1377299		1393489		1397127		1379981		1449594		1822411		1818696		1681390		1933095		1888001		1867336		1885771		1739566		1735440		1985048		1990292		2206341		2293508		2314467		2259349		2343831		2303492		2307310		2516949		2464340		2182565		2281894		2012484		2018762		2039053		2029831		2043033		2067000		2047502		2059699		2075210		2075210		2079816		2085705		2129907		2137641		2153205		2270260		2483602		2502716		2312681		2436585		2410413		2410535		2227058		2366299		2231173		2516891		2264153		2426502		2549211		2702887		2638271		2654705		2570730		2711029		2727308		2752495
period_id		145		137		140		140		140		140		144		141		147		145		153		73		73		75		75		79		77		82		83		83		82		85		86		87		88		89		90		91		91		95		93		96		98		99		97		98		99		101		100		101		103		104		108		107		109		112		114		113		116		115		117		119		117		122		121		124		128		123		128		125		129		131		133		136		135		81		85		87		102		105		111		116		139		140		144		155		76		77		97		99		103		None		None		164		None		163		None		None		None		None		None		None		172		171		176		None		None		173		177		None		None		179		None		181		185		None		None		186		186		188		None		187		None		None		None		None		220		219		None		None		None		196		None		195		None		None		None		213		None		219		219		None		219		None		211		None		224		231		235		236		234		235		236		236		None		None		None		None		223		None		226		226		226		None		226		225		227		227		227		228		227		None		None		233		241		243		236		237		239		239		None		None		234		244		235		240		243		249		245		None		None		None		252		252
form_id		F461		F461		F497		F497		F497		F461		F497		F461		F461		F461		F461		F440		F440		F461		F461		F461		F405		F461		F461		F461		F405		F405		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F405		F405		F405		F461		F461		F461		F461		F461		F777		F461		F461		F461		F777		F461		F777		F461		F461		F461		F405		F777		F461		F777		F405		F461		F777		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F777		F461		F496		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F497		F461		F461		F497		F461		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F497		F461		F461		F497		F497		F497		F461		F497		F497		F497		F461		F461		F497		F461		F461		F497		F497		F461		F461		F461		F461		F497		F461		F497		F461		F461		F461		F497		F461		F497		F497		F497		F461		F497		F497		F461		F461		F461		F461		F461		F461		F497		F497		F497		F461		F497		F461		F497		F497		F497		F497		F461		F461		F461		F461		F461		F497		F497		F461		F497		F497		F461		F461		F497		F497		F497		F497		F461		F461		F461		F461		F461		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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1996-07-15 00:00:00		1994-07-25 00:00:00		1994-10-26 00:00:00		1994-11-04 00:00:00		1994-11-03 00:00:00		1995-01-19 00:00:00		1995-10-24 00:00:00		1995-10-24 00:00:00		1997-01-31 00:00:00		1997-01-31 00:00:00		1998-07-31 00:00:00		1978-06-29 00:00:00		1978-09-14 00:00:00		1978-09-29 00:00:00		1978-10-26 00:00:00		1980-01-14 00:00:00		1980-01-14 00:00:00		1980-07-30 00:00:00		1980-09-30 00:00:00		1980-10-24 00:00:00		1980-09-17 00:00:00		1981-07-24 00:00:00		1981-07-31 00:00:00		1981-10-13 00:00:00		1982-01-29 00:00:00		1982-05-27 00:00:00		1982-08-02 00:00:00		1982-09-22 00:00:00		1983-02-14 00:00:00		1983-10-27 00:00:00		1983-10-27 00:00:00		1984-01-19 00:00:00		1984-07-31 00:00:00		1984-09-24 00:00:00		1984-09-26 00:00:00		1984-09-26 00:00:00		1984-10-29 00:00:00		1985-03-22 00:00:00		1985-01-23 00:00:00		1985-05-23 00:00:00		1985-09-23 00:00:00		1986-01-29 00:00:00		1986-11-01 00:00:00		1987-02-02 00:00:00		1987-07-31 00:00:00		1988-02-01 00:00:00		1988-05-24 00:00:00		1988-07-22 00:00:00		1988-11-07 00:00:00		1989-01-31 00:00:00		1989-07-31 00:00:00		1990-01-31 00:00:00		1990-01-16 00:00:00		1990-05-25 00:00:00		1990-07-31 00:00:00		1990-10-24 00:00:00		1991-10-31 00:00:00		1991-01-31 00:00:00		1991-10-29 00:00:00		1992-01-31 00:00:00		1992-07-31 00:00:00		1993-01-22 00:00:00		1993-07-23 00:00:00		1993-10-21 00:00:00		1994-01-24 00:00:00		1980-05-30 00:00:00		1981-05-22 00:00:00		1981-09-21 00:00:00		1985-07-31 00:00:00		1986-07-31 00:00:00		1987-10-29 00:00:00		1988-10-31 00:00:00		1994-10-04 00:00:00		1994-10-26 00:00:00		1996-01-29 00:00:00		1999-02-01 00:00:00		1979-01-31 00:00:00		1979-09-26 00:00:00		1984-07-31 00:00:00		1984-10-25 00:00:00		1985-10-24 00:00:00		2000-01-10 00:00:00		2000-10-25 00:00:00		2000-10-25 00:00:00		2000-07-31 00:00:00		2001-01-31 00:00:00		2001-01-31 00:00:00		2001-01-31 00:00:00		2002-01-09 00:00:00		2002-03-05 00:00:00		2002-09-19 00:00:00		2002-07-29 00:00:00		2002-11-01 00:00:00		2003-01-27 00:00:00		2003-11-25 00:00:00		2004-01-29 00:00:00		2003-11-25 00:00:00		2004-02-02 00:00:00		2004-07-29 00:00:00		2004-07-28 00:00:00		2005-01-27 00:00:00		2005-01-28 00:00:00		2003-01-27 00:00:00		2006-01-30 00:00:00		2006-07-28 00:00:00		2005-01-27 00:00:00		2006-07-27 00:00:00		2006-05-24 00:00:00		2006-06-05 00:00:00		2006-10-31 00:00:00		2007-01-26 00:00:00		2007-01-26 00:00:00		2006-06-05 00:00:00		2006-11-01 00:00:00		2006-05-24 00:00:00		2015-01-29 00:00:00		2014-10-20 00:00:00		2014-09-25 00:00:00		2007-11-05 00:00:00		2008-01-29 00:00:00		2008-07-28 00:00:00		2008-10-30 00:00:00		2009-01-26 00:00:00		2009-02-02 00:00:00		2008-10-30 00:00:00		2009-10-22 00:00:00		2014-01-31 00:00:00		2014-01-31 00:00:00		2012-07-27 00:00:00		2015-01-29 00:00:00		2014-09-24 00:00:00		2014-07-22 00:00:00		2014-09-16 00:00:00		2012-01-29 00:00:00		2013-01-29 00:00:00		2015-07-30 00:00:00		2015-10-01 00:00:00		2018-01-26 00:00:00		2018-09-19 00:00:00		2018-10-26 00:00:00		2018-06-04 00:00:00		2019-01-29 00:00:00		2018-10-08 00:00:00		2018-10-16 00:00:00		2020-07-31 00:00:00		2020-01-27 00:00:00		2017-07-25 00:00:00		2018-07-26 00:00:00		2016-02-01 00:00:00		2016-02-01 00:00:00		2016-05-03 00:00:00		2016-04-19 00:00:00		2016-05-16 00:00:00		2016-07-27 00:00:00		2016-05-27 00:00:00		2016-07-27 00:00:00		2016-09-08 00:00:00		2016-09-12 00:00:00		2016-09-21 00:00:00		2016-10-05 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-04-21 00:00:00		2018-07-26 00:00:00		2020-07-30 00:00:00		2020-09-18 00:00:00		2018-10-25 00:00:00		2020-01-27 00:00:00		2019-09-24 00:00:00		2019-09-25 00:00:00		2018-01-26 00:00:00		2019-01-29 00:00:00		2018-04-13 00:00:00		2020-10-16 00:00:00		2018-07-12 00:00:00		2019-12-23 00:00:00		2021-01-28 00:00:00		2022-07-28 00:00:00		2022-01-26 00:00:00		2022-01-26 00:00:00		2021-01-28 00:00:00		2022-07-27 00:00:00		2022-10-03 00:00:00		2022-11-04 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		10005		10005		10001		10005		10001		10005		10005		10005		10005		10006		10005		10001		10001		10001		10005		10001		10001		10001		10005		10005		10001		10005		10001		10001		10005		10005		10001		10001		10001		10005		10001		10005		10005		10005		10005		10001		10001		10005		10005		10005		10001		10005		10001		10005		10005		10005		10001		10005		10001		10001		10005		10001		10005		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10001		10005		10001		10001		10001		10005		10001		10001		10001		10002		10001		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10005		10005		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		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		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		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003
session_id		1995		1993		1993		1993		1993		1993		1995		1995		1995		1995		1997		1977		1977		1977		1977		1979		1979		1979		1979		1979		1979		1981		1981		1981		1981		1981		1981		1981		1981		1983		1983		1983		1983		1983		1983		1983		1983		1985		1983		1985		1985		1985		1985		1985		1987		1987		1987		1987		1987		1987		1989		1989		1989		1989		1989		1989		1991		1989		1991		1991		1991		1991		1993		1993		1993		1979		1981		1981		1985		1985		1987		1987		1993		1993		1995		1997		1977		1979		1983		1983		1985		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2001		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2009		2013		2013		2011		2013		2013		2013		2013		2011		2011		2015		2015		2017		2017		2017		2017		2017		2017		2017		2019		2019		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2019		2019		2017		2019		2019		2019		2017		2019		2017		2019		2017		2019		2019		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		KCHAN		*		ERUTH		*		TWALLS		ERUTH		LTHIBAUL		RALLMOND		LTHIBAUL		LTHIBAUL		*		COMPLETED		COMPLETED		DHORRELL		PBANFORD		COMPLETED		COMPLETED		DHORRELL		DHORRELL		COMPLETED		DHORRELL		*		*		PROBERTS		JMARTIN		DHORRELL		DHORRELL		DHORRELL		JMARTIN		*		DHORRELL		DHORRELL		DHORRELL		JINGRAM		CAFILER		CAFILER		SMCCABE		SMCCABE		MGUERRA		PBANFORD		JINGRAM		JINGRAM		RGEREMIA		GKURIMOT		JINGRAM		JINGRAM		JINGRAM		JINGRAM		CAFILER		JINGRAM		CAFILER		JINGRAM		JINGRAM		JINGRAM		GKURIMOT		DMCCASTL		CAFILER		CAFILER		GTAYLOR		GTAYLOR		CAFILER		CAFILER		GTAYLOR		GTAYLOR		LPALMER		GTAYLOR		JINGRAM		JINGRAM		KBANH		KBANH		KBANH		JINGRAM		KBANH		JINGRAM		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		JINGRAM		JINGRAM		JINGRAM		GTAYLOR		GTAYLOR		CAFILER		CAFILER		GTAYLOR		GKURIMOT		GKURIMOT		DMCCASTL		GTAYLOR		GTAYLOR		CAFILER		RGEREMIA		GKURIMOT		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11003		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		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11003
rpt_start		1996-01-01 00:00:00		1994-01-01 00:00:00		None		None		None		1994-10-01 00:00:00		None		1995-01-01 00:00:00		1996-07-01 00:00:00		1996-01-01 00:00:00		1998-01-01 00:00:00		1978-01-01 00:00:00		1978-01-01 00:00:00		1978-07-01 00:00:00		1978-09-24 00:00:00		1979-09-25 00:00:00		1979-01-01 00:00:00		1980-05-20 00:00:00		1980-07-01 00:00:00		1980-09-24 00:00:00		1980-05-20 00:00:00		1981-01-01 00:00:00		1981-05-16 00:00:00		1981-09-18 00:00:00		1981-10-18 00:00:00		1982-01-01 00:00:00		1982-05-23 00:00:00		1982-07-01 00:00:00		1982-09-18 00:00:00		1983-09-18 00:00:00		1983-01-01 00:00:00		1983-10-23 00:00:00		1984-05-20 00:00:00		1984-07-01 00:00:00		1984-01-01 00:00:00		1984-05-20 00:00:00		1984-07-01 00:00:00		1985-01-01 00:00:00		1984-10-21 00:00:00		1985-03-18 00:00:00		1985-07-01 00:00:00		1985-10-20 00:00:00		None		1986-07-01 00:00:00		1987-01-01 00:00:00		1987-10-01 00:00:00		None		1988-01-01 00:00:00		None		1988-07-01 00:00:00		1989-01-01 00:00:00		1989-07-01 00:00:00		1989-01-01 00:00:00		None		1990-01-01 00:00:00		None		None		1990-07-01 00:00:00		None		1991-01-01 00:00:00		1992-01-01 00:00:00		1992-07-01 00:00:00		1993-01-01 00:00:00		None		1993-07-01 00:00:00		1980-01-01 00:00:00		1981-01-01 00:00:00		1981-07-01 00:00:00		1985-05-19 00:00:00		1986-01-01 00:00:00		1987-07-01 00:00:00		None		1994-07-01 00:00:00		None		1995-10-22 00:00:00		1998-07-01 00:00:00		1978-10-24 00:00:00		1979-01-01 00:00:00		1984-01-01 00:00:00		1984-09-18 00:00:00		1985-09-18 00:00:00		1999-01-01 00:00:00		2000-10-25 00:00:00		2000-10-25 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		None		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-11-01 00:00:00		2002-07-01 00:00:00		2003-11-25 00:00:00		2003-01-01 00:00:00		None		2003-01-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2002-07-01 00:00:00		2005-01-01 00:00:00		2006-01-01 00:00:00		2005-01-01 00:00:00		2006-01-01 00:00:00		2006-05-24 00:00:00		2006-06-05 00:00:00		2006-10-31 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		None		None		None		2014-07-01 00:00:00		2014-10-20 00:00:00		2014-09-25 00:00:00		None		2007-01-01 00:00:00		2008-01-01 00:00:00		2008-10-30 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		None		None		2013-01-01 00:00:00		2013-01-01 00:00:00		2012-01-01 00:00:00		2014-07-01 00:00:00		2014-09-24 00:00:00		2014-01-01 00:00:00		2014-09-16 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2015-01-01 00:00:00		2015-10-01 00:00:00		2017-07-01 00:00:00		2018-09-19 00:00:00		2018-10-26 00:00:00		2018-06-04 00:00:00		2018-07-01 00:00:00		2018-10-08 00:00:00		2018-10-16 00:00:00		2020-01-01 00:00:00		2019-01-01 00:00:00		2017-04-01 00:00:00		2018-01-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-05-03 00:00:00		2016-04-19 00:00:00		2016-05-16 00:00:00		2016-01-01 00:00:00		2016-05-27 00:00:00		2016-01-01 00:00:00		2016-09-08 00:00:00		2016-09-12 00:00:00		2016-09-21 00:00:00		2016-10-05 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		2020-01-01 00:00:00		2020-09-18 00:00:00		2018-10-25 00:00:00		2019-01-01 00:00:00		2019-09-24 00:00:00		2019-09-25 00:00:00		2017-07-01 00:00:00		2018-07-01 00:00:00		2018-04-13 00:00:00		2020-10-16 00:00:00		2018-07-12 00:00:00		2019-12-23 00:00:00		2020-07-01 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2020-07-01 00:00:00		2022-01-01 00:00:00		2022-10-03 00:00:00		2022-11-04 00:00:00
rpt_end		1996-06-30 00:00:00		1994-06-30 00:00:00		None		None		None		1994-12-31 00:00:00		None		1995-10-21 00:00:00		1996-12-31 00:00:00		1996-12-31 00:00:00		1998-06-30 00:00:00		1978-06-30 00:00:00		1978-06-30 00:00:00		1978-09-23 00:00:00		1978-10-23 00:00:00		1979-12-31 00:00:00		1979-09-24 00:00:00		1980-06-30 00:00:00		1980-09-23 00:00:00		1980-10-20 00:00:00		1980-06-30 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		1982-05-18 00:00:00		1982-06-30 00:00:00		1982-09-17 00:00:00		1982-12-31 00:00:00		1983-10-22 00:00:00		1983-09-17 00:00:00		1983-12-31 00:00:00		1984-06-30 00:00:00		1984-09-17 00:00:00		1984-05-19 00:00:00		1984-06-30 00:00:00		1984-09-17 00:00:00		1985-03-17 00:00:00		1984-12-31 00:00:00		1985-05-18 00:00:00		1985-09-17 00:00:00		1985-12-31 00:00:00		None		1986-12-31 00:00:00		1987-06-30 00:00:00		1987-12-31 00:00:00		None		1988-06-30 00:00:00		None		1988-12-31 00:00:00		1989-06-30 00:00:00		1989-12-31 00:00:00		1989-06-30 00:00:00		None		1990-06-30 00:00:00		None		None		1990-12-31 00:00:00		None		1991-12-31 00:00:00		1992-06-30 00:00:00		1992-12-31 00:00:00		1993-06-30 00:00:00		None		1993-12-31 00:00:00		1980-05-29 00:00:00		1981-05-16 00:00:00		1981-09-17 00:00:00		1985-06-30 00:00:00		1986-06-30 00:00:00		1987-09-30 00:00:00		None		1994-09-30 00:00:00		None		1995-12-31 00:00:00		1998-12-31 00:00:00		1978-12-31 00:00:00		1979-09-24 00:00:00		1984-05-19 00:00:00		1984-10-20 00:00:00		1985-10-19 00:00:00		1999-12-31 00:00:00		2000-10-25 00:00:00		2000-10-25 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-12-31 00:00:00		None		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-11-01 00:00:00		2002-12-31 00:00:00		2003-11-25 00:00:00		2003-12-31 00:00:00		None		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2002-12-31 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-05-24 00:00:00		2006-06-05 00:00:00		2006-10-31 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		None		None		None		2014-12-31 00:00:00		2014-10-20 00:00:00		2014-09-25 00:00:00		None		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-10-30 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		None		None		2013-12-31 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2014-12-31 00:00:00		2014-09-24 00:00:00		2014-06-30 00:00:00		2014-09-16 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2015-06-30 00:00:00		2015-10-01 00:00:00		2017-12-31 00:00:00		2018-09-19 00:00:00		2018-10-26 00:00:00		2018-06-04 00:00:00		2018-12-31 00:00:00		2018-10-08 00:00:00		2018-10-16 00:00:00		2020-06-30 00:00:00		2019-12-31 00:00:00		2017-06-30 00:00:00		2018-06-30 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-05-03 00:00:00		2016-04-19 00:00:00		2016-05-16 00:00:00		2016-06-30 00:00:00		2016-05-27 00:00:00		2016-06-30 00:00:00		2016-09-08 00:00:00		2016-09-12 00:00:00		2016-09-21 00:00:00		2016-10-05 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		2018-06-30 00:00:00		2020-06-30 00:00:00		2020-09-18 00:00:00		2018-10-25 00:00:00		2019-12-31 00:00:00		2019-09-24 00:00:00		2019-09-25 00:00:00		2017-12-31 00:00:00		2018-12-31 00:00:00		2018-04-13 00:00:00		2020-10-16 00:00:00		2018-07-12 00:00:00		2019-12-23 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		2020-12-31 00:00:00		2022-06-30 00:00:00		2022-10-03 00:00:00		2022-11-04 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		2000-10-25 00:00:00		None		2001-01-31 00:00:00		None		None		None		None		None		None		2002-11-01 00:00:00		2003-01-27 00:00:00		2003-11-25 00:00:00		None		None		2004-02-02 00:00:00		2004-07-29 00:00:00		None		None		2005-01-28 00:00:00		None		2006-01-30 00:00:00		2006-07-28 00:00:00		None		None		2006-05-24 00:00:00		2006-06-05 00:00:00		2006-10-31 00:00:00		None		2007-01-26 00:00:00		None		None		None		None		2014-10-20 00:00:00		2014-09-25 00:00:00		None		None		None		2008-10-30 00:00:00		None		2009-02-02 00:00:00		None		None		None		2014-01-31 00:00:00		None		2015-01-29 00:00:00		2014-09-24 00:00:00		None		2014-09-16 00:00:00		None		2013-01-29 00:00:00		None		2015-10-01 00:00:00		2018-01-26 00:00:00		2018-09-19 00:00:00		2018-10-26 00:00:00		2018-06-04 00:00:00		2019-01-29 00:00:00		2018-10-08 00:00:00		2018-10-16 00:00:00		None		None		None		None		2016-02-01 00:00:00		None		2016-05-03 00:00:00		2016-04-19 00:00:00		2016-05-16 00:00:00		None		2016-05-27 00:00:00		2016-07-27 00:00:00		2016-09-08 00:00:00		2016-09-12 00:00:00		2016-09-21 00:00:00		2016-10-05 00:00:00		2017-01-31 00:00:00		None		None		2018-07-26 00:00:00		2020-07-30 00:00:00		2020-09-18 00:00:00		2018-10-25 00:00:00		2020-01-27 00:00:00		2019-09-24 00:00:00		2019-09-25 00:00:00		None		None		2018-04-13 00:00:00		2020-10-16 00:00:00		2018-07-12 00:00:00		2019-12-23 00:00:00		2021-01-26 00:00:00		2022-07-28 00:00:00		2022-01-20 00:00:00		None		None		None		2022-10-03 00:00:00		2022-11-04 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		22001		22001		None		None		22001		22001		None		None		22001		None		22001		22001		None		None		22001		22001		22001		None		22001		None		None		None		None		22001		22001		None		None		None		22001		None		22001		None		None		None		22001		None		22001		22001		None		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		None		None		None		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		None		None		None		22001		22001

Table: filer_to_filer_type

filer_id		1008031
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		1008031
xref_id		478373
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		478373		478373		478373		478373
filer_id		1008031		1008031		1008031		1008031
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		SHORENSTEIN REALTY SERVICES AND AFFILIATED ENTITIES		SHORENSTEIN, DOUGLAS W. AND AFFILIATED ENTITIES		SHORENSTEIN AND AFFILIATED ENTITIES INCLUDING THE SHORENSTEIN COMPANY		SHORENSTEIN AND AFFILIATED ENTITIES, DOUGLAS W.
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		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO
st		CA		CA		CA		CA
zip4		941040000		941040000		941040000		941040000
phon		4157727000		4157727000		4157727000		4157727000
fax		None		None		None		None
email		None		None		None		None

Table: filers

filer_id		1008031

Table: received_filings

filer_id		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031		1008031
filing_file_name		676298_0.cal		718344_0.cal		886962_0.cal		906893_0.cal		973129_0.cal		990422_0.cal		1027849_0.cal		1078133_0.cal		1146289_0.cal		1173541_0.cal		1179421_0.cal		1188973_0.cal		1397127_0.cal		1217097_0.cal		1232634_0.cal		1377299_0.cal		1735440_0.cal		1990292_0.cal		2075210_0.cal		2085705_0.cal		2079816_0.cal		1885771_0.cal		2029831_0.cal		1888612_0.cal		1888001_0.cal		2043033_0.cal		1900549_0.cal		2075210_1.cal		2293508_0.cal		2259349_0.cal		2314467_0.cal		2303492_0.cal		2410535_0.cal		2307310_0.cal		2410413_0.cal		2426502_0.cal		2312681_0.cal		2231173_0.cal		2264153_0.cal		2727308_0.cal		101878.cal		102864.cal		2752495_0.cal		2516891_0.cal		436674.cal		102542.cal
received_date		2000-10-25 00:00:00		2001-01-31 00:00:00		2002-11-01 00:00:00		2003-01-27 00:00:00		2003-11-25 00:00:00		2004-02-02 00:00:00		2004-07-29 00:00:00		2005-01-28 00:00:00		2006-01-30 00:00:00		2006-05-24 00:00:00		2006-06-05 00:00:00		2006-07-28 00:00:00		2009-02-02 00:00:00		2006-10-31 00:00:00		2007-01-26 00:00:00		2008-10-30 00:00:00		2013-01-29 00:00:00		2015-10-01 00:00:00		2016-09-08 00:00:00		2016-10-05 00:00:00		2016-09-21 00:00:00		2014-09-16 00:00:00		2016-04-19 00:00:00		2014-09-25 00:00:00		2014-09-24 00:00:00		2016-05-16 00:00:00		2014-10-20 00:00:00		2016-09-12 00:00:00		2018-09-19 00:00:00		2018-06-04 00:00:00		2018-10-26 00:00:00		2018-10-08 00:00:00		2019-09-25 00:00:00		2018-10-16 00:00:00		2019-09-24 00:00:00		2019-12-23 00:00:00		2018-10-25 00:00:00		2018-04-13 00:00:00		2018-07-12 00:00:00		2022-10-03 00:00:00		2022-07-28 00:00:00		2022-07-28 00:00:00		2022-11-04 00:00:00		2020-10-16 00:00:00		2020-09-18 00:00:00		2022-07-28 00:00:00
filing_directory		/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/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp
filing_id		676298		718344		886962		906893		973129		990422		1027849		1078133		1146289		1173541		1179421		1188973		1397127		1217097		1232634		1377299		1735440		1990292		2075210		2085705		2079816		1885771		2029831		1888612		1888001		2043033		1900549		2075210		2293508		2259349		2314467		2303492		2410535		2307310		2410413		2426502		2312681		2231173		2264153		2727308		None		None		2752495		2516891		None		None
form_id		F497		F461		F497		F461		F497		F461		F461		F461		F461		F497		F497		F461		F461		F497		F461		F497		F461		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		None		F497		F497		None		None
receive_comment		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 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 did not pass validation		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation