Home

Filer ID: 1008988

Table: filer_address

filer_id		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988
adrid		1008250		2132603		2167939		2154651		2158890		2188402		2215078		2137367		2170629		2175192		2177896		2211019		2202612		2191513		2222354		2218232		2229804		2248200		2235876		2296067		2286572		2299868		2300441		2300439		2282529
effect_dt		2001-07-16 00:00:00		2008-01-30 00:00:00		2009-04-24 00:00:00		2008-10-30 00:00:00		2009-01-29 00:00:00		2010-04-29 00:00:00		2011-04-29 00:00:00		2008-04-29 00:00:00		2009-07-23 00:00:00		2009-10-28 00:00:00		2010-01-29 00:00:00		2011-01-29 00:00:00		2010-10-27 00:00:00		2010-07-29 00:00:00		2011-10-29 00:00:00		2011-07-29 00:00:00		2012-04-28 00:00:00		2012-10-31 00:00:00		2012-07-31 00:00:00		2013-07-25 00:00:00		2013-04-22 00:00:00		2013-10-14 00:00:00		2013-10-24 00:00:00		2013-10-24 00:00:00		2013-01-30 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7082		7082		7082		7051		7082		7082
session_id		2001		2007		2009		2007		2009		2009		2011		2007		2009		2009		2009		2011		2009		2009		2011		2011		2011		2011		2011		2013		2013		2013		2013		2013		2013

Table: filer_filings

filer_id		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988
filing_id		55746		55748		55749		55750		55751		55753		55754		55755		55756		55757		55758		55759		55760		55761		55762		55763		55764		55765		55766		55767		55768		55770		55771		55772		55773		55775		55776		55777		55778		55779		55780		55781		55782		55783		55784		55785		55786		55787		55735		55736		55737		55738		55739		55740		55741		55743		55744		55745		202201		202203		202204		202205		202206		202208		55742		55747		55752		55769		55774		587634		202202		202207		668134		711594		762718		767526		792848		813523		829131		852094		849876		905226		913987		944978		954791		983380		1007382		1000396		1024198		1031634		1076049		1073792		1057941		1141326		1114817		1112642		1141326		1141326		1141326		1133149		1129813		1141326		1185340		1171226		1171226		1183490		1227376		1285271		1248853		1262565		1297850		1778277		1789928		1789928		1789930		1789932		1789934		1789941		1789946		1789951		1789953		1789866		1789884		1789888		1789890		1789892		1789892		1789894		1789896		1789880		1789896		1789898		1789902		1789905		1789907		1789909		1772696		1784506		1850953		1856938		1868013		1789902		1789905		1789907		1789909		1789892		1789894		1789896		1789898		1789877		1789880		1789884		1606562		1794153		1789877		1789937		1789937		1789943		1789949		1796132		1484068		1635249		1794153		1789866		1789884		1796132		1789888		1656483		1679103		1709625		1737650		1590357		1505681		1536962		1569711		1778277		1621585		1793277		1936171		1956422		1897257		1896114		1309176		1328598		1328598		1375774		1394173		1433102		1418750		1450818		1418750		1463164		1484068		1505681		1536962		1569711		1590357		1590357		1621585		1606562		1635249		1621585		1656483		1679103		1827517		1830750		1817196		1709625		1881456		1880498		1884529		1885230		1887740		1737650		1760488		1789877		1796132		1827517		1839078		1778277		1794153		1817196		1839345		1760488		2003764		1986198		1982833		2363891		2423561		2553429		2248525		2348758		2021017		2011025		2017678		2045585		2030040		2025196		2031900		2043054		2062652		2071057		2069121		2075324		2078854		2080890		2088718		2128297		2147317		2176867		2186510		2501303		2495070		2250612		2223268		2425297		2442741		2399915		2235850		2561636		2523892		2254614		2291142		2407136		2383425		2290573		2210767		2295099		2276126		2668716		2648936		2463975		2657311		2680551		2630350		2707041		2607945		2643185		2721168		2744264
period_id		93		95		95		95		95		97		97		97		99		99		99		100		100		97		103		103		105		107		105		109		113		123		122		121		119		125		127		133		135		137		139		141		145		147		153		155		155		157		85		85		86		86		86		89		90		90		91		91		87		92		93		109		117		129		91		95		97		115		123		None		91		121		None		163		None		165		None		167		None		None		169		171		None		173		None		175		None		None		177		None		None		179		None		184		None		181		184		184		184		None		183		184		None		None		None		185		187		190		None		189		191		214		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		214		215		218		218		217		None		None		None		None		None		None		None		None		None		None		None		206		215		None		None		None		None		None		None		201		208		215		None		None		None		None		209		210		211		212		205		202		203		204		214		207		None		219		None		220		220		192		193		194		195		196		198		197		199		197		200		201		202		203		204		205		205		207		206		208		207		209		210		None		217		216		211		None		219		219		219		219		212		213		None		None		None		218		214		215		216		218		213		225		None		221		None		240		243		234		235		225		223		None		226		226		225		226		226		225		227		227		None		227		227		228		227		None		229		None		243		243		234		233		240		239		238		None		None		None		234		235		None		None		None		231		235		233		250		None		None		249		250		248		249		None		247		None		252
form_id		F461		F461		F461		F405		F405		F461		F461		F405		F461		F405		F405		F461		F405		F461		F461		F405		F461		F461		F405		F461		F461		F461		F777		F461		F405		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F405		F461		F461		F461		F461		F461		F405		F461		F461		F405		F405		F405		F405		F461		F405		F405		F461		F461		F461		F461		F461		F461		F461		F461		F461		F405		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F497		F497		F497		F497		F461		F461		F461		F461		F461		F497		F461		F461		F461		F497		F461		F497		F461		F461		F461		F497		F461		F497		F461		F497		F461		F461		F497		F497		F497		F497		F497		F461		F497		F497		F461		F497		F497		F497		F461		F461		F461		F461		F497		F497		F497		F497		F497		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F497		F461		F497		F461		F461		F497		F497		F497		F461		F461		F461		F461		F497
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		2		3		0		0		4		0		0		1		0		0		0		0		0		0		0		0		1		0		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		1		1		1		1		2		1		2		1		1		1		1		1		1		0		0		1		0		0		0		1		1		0		1		2		1		1		1		1		1		1		2		1		1		1		1		2		0		0		0		0		0		0		0		1		0		0		0		1		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		1		2		2		1		0		2		2		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1983-08-08 00:00:00		1983-10-25 00:00:00		1984-01-10 00:00:00		1984-01-23 00:00:00		1984-02-09 00:00:00		1984-05-23 00:00:00		1984-07-19 00:00:00		1984-08-30 00:00:00		1984-09-21 00:00:00		1984-12-06 00:00:00		1985-02-14 00:00:00		1985-01-31 00:00:00		1985-05-06 00:00:00		1985-08-02 00:00:00		1986-01-31 00:00:00		1986-04-10 00:00:00		1986-07-30 00:00:00		1987-01-23 00:00:00		1987-04-10 00:00:00		1988-02-01 00:00:00		1988-08-01 00:00:00		1990-01-31 00:00:00		1990-05-31 00:00:00		1990-07-31 00:00:00		1990-10-15 00:00:00		1991-08-01 00:00:00		1992-01-31 00:00:00		1993-08-02 00:00:00		1994-01-28 00:00:00		1994-07-21 00:00:00		1995-01-30 00:00:00		1996-01-26 00:00:00		1996-07-05 00:00:00		1997-01-29 00:00:00		1998-07-10 00:00:00		1999-01-25 00:00:00		1999-03-15 00:00:00		1999-07-29 00:00:00		1981-06-04 00:00:00		1981-07-13 00:00:00		1981-08-13 00:00:00		1981-10-23 00:00:00		1981-11-16 00:00:00		1982-05-26 00:00:00		1982-07-20 00:00:00		1982-11-22 00:00:00		1982-11-22 00:00:00		1983-01-27 00:00:00		1982-01-15 00:00:00		1983-01-25 00:00:00		1984-01-11 00:00:00		1988-05-05 00:00:00		1989-07-31 00:00:00		1993-01-01 00:00:00		1982-09-28 00:00:00		1983-09-19 00:00:00		1984-03-21 00:00:00		1989-02-07 00:00:00		1991-01-30 00:00:00		2000-01-27 00:00:00		1982-10-21 00:00:00		1990-10-15 00:00:00		2000-07-31 00:00:00		2001-01-19 00:00:00		2001-01-24 00:00:00		2001-07-11 00:00:00		2001-07-16 00:00:00		2002-01-31 00:00:00		2002-01-31 00:00:00		2002-07-18 00:00:00		2002-07-16 00:00:00		2003-01-23 00:00:00		2003-01-27 00:00:00		2003-07-28 00:00:00		2003-07-28 00:00:00		2004-01-20 00:00:00		2004-01-22 00:00:00		2004-02-20 00:00:00		2004-07-20 00:00:00		2004-07-26 00:00:00		2005-01-25 00:00:00		2005-01-21 00:00:00		2004-10-25 00:00:00		2006-01-10 00:00:00		2005-07-25 00:00:00		2005-07-19 00:00:00		2006-01-16 00:00:00		2006-01-16 00:00:00		2006-01-16 00:00:00		2005-10-26 00:00:00		2005-10-24 00:00:00		2006-06-19 00:00:00		2006-07-17 00:00:00		2006-01-17 00:00:00		2006-06-26 00:00:00		2006-07-11 00:00:00		2007-01-10 00:00:00		2007-07-31 00:00:00		2007-01-17 00:00:00		2007-04-30 00:00:00		2007-10-31 00:00:00		2013-07-25 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-08-28 00:00:00		2013-08-28 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-06-26 00:00:00		2013-08-02 00:00:00		2014-05-16 00:00:00		2014-05-30 00:00:00		2014-07-28 00:00:00		2013-10-24 00:00:00		2013-10-24 00:00:00		2013-10-24 00:00:00		2013-10-24 00:00:00		2013-10-24 00:00:00		2013-10-24 00:00:00		2013-10-24 00:00:00		2013-10-24 00:00:00		2013-10-24 00:00:00		2013-10-24 00:00:00		2013-10-24 00:00:00		2013-10-20 00:00:00		2013-10-17 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-09-03 00:00:00		2013-10-18 00:00:00		2013-10-20 00:00:00		2013-10-20 00:00:00		2013-10-14 00:00:00		2013-10-24 00:00:00		2013-10-24 00:00:00		2013-10-18 00:00:00		2013-10-21 00:00:00		2013-10-19 00:00:00		2013-10-19 00:00:00		2013-10-19 00:00:00		2013-10-19 00:00:00		2013-10-20 00:00:00		2013-10-20 00:00:00		2013-10-20 00:00:00		2013-10-20 00:00:00		2013-10-17 00:00:00		2013-10-20 00:00:00		2013-09-03 00:00:00		2015-02-02 00:00:00		2015-02-02 00:00:00		2014-10-13 00:00:00		2014-10-09 00:00:00		2008-01-30 00:00:00		2008-04-29 00:00:00		2008-07-30 00:00:00		2008-10-30 00:00:00		2009-01-29 00:00:00		2009-07-23 00:00:00		2009-10-28 00:00:00		2009-10-28 00:00:00		2009-04-24 00:00:00		2010-01-29 00:00:00		2010-04-29 00:00:00		2010-07-29 00:00:00		2010-10-27 00:00:00		2011-01-29 00:00:00		2011-04-29 00:00:00		2011-06-29 00:00:00		2011-10-31 00:00:00		2011-07-29 00:00:00		2012-01-30 00:00:00		2011-10-29 00:00:00		2012-04-28 00:00:00		2012-07-31 00:00:00		2014-01-31 00:00:00		2014-03-20 00:00:00		2014-01-30 00:00:00		2012-10-31 00:00:00		2014-07-31 00:00:00		2014-08-25 00:00:00		2014-09-11 00:00:00		2014-09-15 00:00:00		2014-09-23 00:00:00		2013-01-30 00:00:00		2014-04-04 00:00:00		2014-04-08 00:00:00		2014-04-08 00:00:00		2014-04-08 00:00:00		2014-04-17 00:00:00		2014-04-04 00:00:00		2014-04-04 00:00:00		2014-04-04 00:00:00		2014-04-17 00:00:00		2013-04-22 00:00:00		2016-01-13 00:00:00		2015-07-31 00:00:00		2015-07-31 00:00:00		2019-01-31 00:00:00		2019-12-05 00:00:00		2021-02-01 00:00:00		2018-05-11 00:00:00		2019-01-31 00:00:00		2016-03-16 00:00:00		2016-01-29 00:00:00		2016-02-01 00:00:00		2016-05-24 00:00:00		2016-04-20 00:00:00		2016-03-31 00:00:00		2016-04-25 00:00:00		2016-05-16 00:00:00		2016-07-30 00:00:00		2016-08-23 00:00:00		2016-08-16 00:00:00		2016-08-01 00:00:00		2016-09-19 00:00:00		2016-09-23 00:00:00		2016-10-13 00:00:00		2017-01-30 00:00:00		2017-01-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2020-09-14 00:00:00		2020-08-25 00:00:00		2018-05-18 00:00:00		2018-03-19 00:00:00		2019-12-17 00:00:00		2020-01-31 00:00:00		2019-07-31 00:00:00		2018-01-31 00:00:00		2021-02-01 00:00:00		2020-07-31 00:00:00		2018-05-25 00:00:00		2018-09-12 00:00:00		2019-07-31 00:00:00		2019-04-30 00:00:00		2018-07-31 00:00:00		2018-01-31 00:00:00		2018-09-24 00:00:00		2018-07-31 00:00:00		2022-04-21 00:00:00		2022-01-31 00:00:00		2020-01-31 00:00:00		2022-03-14 00:00:00		2022-05-09 00:00:00		2021-12-07 00:00:00		2022-08-01 00:00:00		2021-08-02 00:00:00		2022-01-31 00:00:00		2022-08-01 00:00:00		2022-10-27 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		10005		10001		10001		10005		10001		10005		10001		10005		10001		10005		10005		10001		10001		10005		10001		10005		10001		10005		10005		10001		10005		10005		10001		10005		10001		10005		10001		10002		10002		10002		10005		10001		10002		10005		10005		10006		10001		10001		10001		10005		10001		10001		10001		10005		10006		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10006		10005		10006		10005		10005		10005		10005		10005		10005		10005		10001		10001		10001		10001		10001		10006		10006		10006		10006		10006		10006		10006		10006		10006		10006		10006		10002		10002		10005		10005		10005		10005		10005		10005		10002		10002		10001		10006		10006		10006		10006		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10005		10001		10005		10001		10001		10001		10001		10002		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10002		10002		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10002		10006		10006		10006		10001		10002		10002		10002		10001		10001		10001		10005		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10005		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10001		10005		10005		10005		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10005		10001		10005		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11001		11003		11001		11003		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		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		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11003
session_id		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1985		1985		1985		1985		1985		1987		1987		1989		1989		1989		1989		1991		1991		1993		1993		1993		1993		1995		1995		1995		1997		1997		1997		1999		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1983		1987		1989		1991		1981		1983		1983		1987		1989		1999		1981		1989		1999		1999		1999		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		2005		2007		2005		2007		2007		2013		2009		2009		2009		2009		2009		2007		2007		2007		2007		2011		2013		2013		2013		2011		2011		2011		2011		2011		2011		2011		2009		2009		2009		2009		2013		2013		2013		2013		2013		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2013		2011		2013		2011		2007		2007		2007		2007		2013		2009		2011		2013		2011		2013		2013		2013		2011		2011		2011		2011		2011		2009		2009		2009		2013		2011		0		2013		2013		2013		2013		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2011		2013		2013		2013		2013		2013		2011		2013		2011		2013		2013		2013		2013		2013		2013		2013		2013		2015		2015		2015		2019		2019		2019		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2019		2019		2017		2017		2019		2019		2019		2017		2021		2019		2017		2017		2019		2019		2017		2017		2017		2017		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		*		*		ERUTH		DMCCASTL		ERUTH		DMCCASTL		DBARRICK		*		LTHIBAUL		LTHIBAUL		*		COMPLETED		LTHIBAUL		COMPLETED		GGILMORE		COMPLETED		DHORRELL		LLEONG		COMPLETED		DHORRELL		DHORRELL		COMPLETED		GPEREZ		*		DHORRELL		*		*		*		*		DHORRELL		*		*		JMARTIN		DHORRELL		GGILMORE		*		*		JINGRAM		JMARTIN		JINGRAM		JINGRAM		JINGRAM		RGEREMIA		JINGRAM		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		JINGRAM		RGEREMIA		RGEREMIA		JINGRAM		RGEREMIA		RGEREMIA		RGEREMIA		JINGRAM		JINGRAM		JINGRAM		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		WBROWN		WBROWN		WBROWN		CAFILER		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		RGEREMIA		JINGRAM		JINGRAM		CAFILER		CAFILER		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		WBROWN		JINGRAM		JINGRAM		JINGRAM		CAFILER		CAFILER		CAFILER		CAFILER		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		WBROWN		JINGRAM		CAFILER		JINGRAM		WBROWN		JINGRAM		GKURIMOT		JINGRAM		JINGRAM		GTAYLOR		CAFILER		GTAYLOR		CAFILER		GTAYLOR		KBANH		JINGRAM		JINGRAM		GCLARA		KBANH		KBANH		KBANH		KBANH		JINGRAM		GCLARA		GCLARA		JINGRAM		GKURIMOT		GKURIMOT		GKURIMOT		JINGRAM		JINGRAM		LPALMER		LPALMER		CAFILER		CAFILER		CAFILER		GKURIMOT		CAFILER		GTAYLOR		GTAYLOR		DMCCASTL		GTAYLOR		GTAYLOR		CAFILER		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		DMCCASTL		CAFILER		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		CAFILER		CAFILER		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		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		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11002		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		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		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
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		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		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		11003		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		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		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11003
rpt_start		1983-01-01 00:00:00		1983-09-18 00:00:00		1983-07-01 00:00:00		1983-09-18 00:00:00		1983-09-18 00:00:00		1984-03-18 00:00:00		1984-01-01 00:00:00		1984-01-01 00:00:00		1984-07-01 00:00:00		1984-07-01 00:00:00		1984-07-01 00:00:00		1984-10-21 00:00:00		1984-10-21 00:00:00		1984-01-01 00:00:00		1985-07-01 00:00:00		1985-07-01 00:00:00		1986-01-01 00:00:00		1986-07-01 00:00:00		1986-01-01 00:00:00		1987-01-01 00:00:00		1988-01-01 00:00:00		1990-07-01 00:00:00		None		1990-01-01 00:00:00		1989-07-01 00:00:00		1991-01-01 00:00:00		1991-07-01 00:00:00		1993-01-01 00:00:00		1993-07-01 00:00:00		1994-01-01 00:00:00		1994-07-01 00:00:00		1995-01-01 00:00:00		1996-01-01 00:00:00		1996-07-01 00:00:00		1998-01-01 00:00:00		1998-07-01 00:00:00		1998-07-01 00:00:00		1999-01-01 00:00:00		1981-01-01 00:00:00		1981-01-01 00:00:00		1981-05-17 00:00:00		1981-06-30 00:00:00		1981-06-30 00:00:00		1982-03-18 00:00:00		1982-05-23 00:00:00		1982-05-23 00:00:00		1982-09-18 00:00:00		1982-09-18 00:00:00		1981-07-01 00:00:00		1982-10-17 00:00:00		1983-01-01 00:00:00		1987-01-01 00:00:00		1989-01-01 00:00:00		1992-01-01 00:00:00		1982-07-01 00:00:00		1983-07-01 00:00:00		1984-01-01 00:00:00		1988-07-01 00:00:00		1990-07-01 00:00:00		1999-07-01 00:00:00		1982-09-18 00:00:00		1990-01-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-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		2002-01-01 00:00:00		2002-01-01 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		None		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		None		2005-10-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-10-01 00:00:00		2005-10-01 00:00:00		2005-10-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2005-10-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2007-04-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		2007-07-01 00:00:00		2013-04-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2008-07-01 00:00:00		2007-01-01 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2012-01-01 00:00:00		2012-10-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2012-07-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2013-06-26 00:00:00		2013-08-02 00:00:00		2014-05-16 00:00:00		2014-05-30 00:00:00		2014-01-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-04-01 00:00:00		2012-07-01 00:00:00		2012-10-01 00:00:00		2011-04-01 00:00:00		2013-07-01 00:00:00		2012-04-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2008-10-01 00:00:00		2007-04-01 00:00:00		2013-07-01 00:00:00		2010-01-01 00:00:00		2011-10-01 00:00:00		2013-07-01 00:00:00		2012-01-01 00:00:00		2012-10-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2012-07-01 00:00:00		2012-10-01 00:00:00		2011-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2013-04-01 00:00:00		2011-07-01 00:00:00		2008-04-01 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2014-10-13 00:00:00		2014-10-09 00:00:00		2007-10-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2009-04-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-01-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2013-10-01 00:00:00		2014-03-20 00:00:00		2013-10-01 00:00:00		2012-07-01 00:00:00		2014-01-01 00:00:00		2014-08-25 00:00:00		2014-09-11 00:00:00		2014-09-15 00:00:00		2014-09-23 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2012-04-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2014-04-17 00:00:00		2013-04-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2014-04-17 00:00:00		2013-01-01 00:00:00		2016-01-13 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2018-07-01 00:00:00		2019-12-05 00:00:00		2020-07-01 00:00:00		2018-05-11 00:00:00		2018-07-01 00:00:00		2016-03-16 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-05-24 00:00:00		2016-04-20 00:00:00		2016-03-31 00:00:00		2016-04-25 00:00:00		2016-05-16 00:00:00		2016-01-01 00:00:00		2016-08-23 00:00:00		2016-08-16 00:00:00		2016-01-01 00:00:00		2016-09-19 00:00:00		2016-09-23 00:00:00		2016-10-13 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2020-09-11 00:00:00		2020-08-25 00:00:00		2018-05-18 00:00:00		2018-03-19 00:00:00		2019-12-17 00:00:00		2019-07-01 00:00:00		2019-04-01 00:00:00		2017-07-01 00:00:00		2020-07-01 00:00:00		2020-01-01 00:00:00		2018-05-25 00:00:00		2018-09-12 00:00:00		2019-04-01 00:00:00		2019-01-01 00:00:00		2018-01-01 00:00:00		2017-07-01 00:00:00		2018-09-24 00:00:00		2018-01-01 00:00:00		2022-04-21 00:00:00		2021-07-01 00:00:00		2019-07-01 00:00:00		2022-03-14 00:00:00		2022-05-09 00:00:00		2021-12-07 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2022-10-27 00:00:00
rpt_end		1983-06-30 00:00:00		1983-10-22 00:00:00		1983-12-31 00:00:00		1983-10-22 00:00:00		1983-10-22 00:00:00		1984-05-21 00:00:00		1984-06-30 00:00:00		1984-06-30 00:00:00		1984-09-17 00:00:00		1984-09-17 00:00:00		1984-09-17 00:00:00		1984-12-31 00:00:00		1984-12-31 00:00:00		1984-06-30 00:00:00		1985-12-31 00:00:00		1985-12-31 00:00:00		1986-06-30 00:00:00		1986-12-31 00:00:00		None		1987-12-31 00:00:00		1988-06-30 00:00:00		1990-12-31 00:00:00		None		1990-06-30 00:00:00		1989-12-31 00:00:00		1991-06-30 00:00:00		1991-12-31 00:00:00		1993-06-30 00:00:00		1993-12-31 00:00:00		1994-06-30 00:00:00		1994-12-31 00:00:00		1995-12-31 00:00:00		1996-06-30 00:00:00		1996-12-31 00:00:00		1998-06-30 00:00:00		1998-12-31 00:00:00		1998-12-31 00:00:00		1999-06-30 00:00:00		1981-04-30 00:00:00		1981-05-16 00:00:00		1981-06-30 00:00:00		1981-09-30 00:00:00		1981-09-17 00:00:00		1982-05-22 00:00:00		1982-06-30 00:00:00		1982-06-30 00:00:00		1982-10-16 00:00:00		1982-10-16 00:00:00		1981-10-17 00:00:00		1982-12-31 00:00:00		1983-06-30 00:00:00		1987-12-31 00:00:00		1989-06-30 00:00:00		1992-12-31 00:00:00		1982-09-17 00:00:00		1983-09-17 00:00:00		1984-03-17 00:00:00		1988-12-31 00:00:00		1990-12-31 00:00:00		1999-12-31 00:00:00		1982-10-16 00:00:00		1990-06-30 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-06-30 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		None		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		None		2005-12-31 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2005-09-30 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2006-12-31 00:00:00		2007-03-31 00:00:00		2007-09-30 00:00:00		2013-06-30 00:00:00		2009-03-31 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2008-09-30 00:00:00		2007-03-31 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2012-03-31 00:00:00		2012-12-31 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2011-03-31 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2012-09-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2013-06-26 00:00:00		2013-08-02 00:00:00		2014-05-16 00:00:00		2014-05-30 00:00:00		2014-06-30 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		2011-06-30 00:00:00		2013-09-30 00:00:00		2012-06-30 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2007-06-30 00:00:00		2013-09-30 00:00:00		2010-03-31 00:00:00		2011-12-31 00:00:00		2013-09-30 00:00:00		2012-03-31 00:00:00		2012-12-31 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		2011-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2013-06-30 00:00:00		2011-09-30 00:00:00		2008-06-30 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2014-10-13 00:00:00		2014-10-09 00:00:00		2007-12-31 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-03-31 00:00:00		2009-09-30 00:00:00		2009-03-31 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-03-31 00:00:00		2011-09-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2014-03-20 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2014-06-30 00:00:00		2014-08-25 00:00:00		2014-09-11 00:00:00		2014-09-15 00:00:00		2014-09-23 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		2012-06-30 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2014-04-17 00:00:00		2013-06-30 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2014-04-17 00:00:00		2013-03-31 00:00:00		2016-01-13 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2018-12-31 00:00:00		2019-12-05 00:00:00		2020-12-31 00:00:00		2018-05-11 00:00:00		2018-12-31 00:00:00		2016-03-16 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-05-24 00:00:00		2016-04-20 00:00:00		2016-03-31 00:00:00		2016-04-25 00:00:00		2016-05-16 00:00:00		2016-06-30 00:00:00		2016-08-23 00:00:00		2016-08-16 00:00:00		2016-06-30 00:00:00		2016-09-19 00:00:00		2016-09-23 00:00:00		2016-10-13 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2020-09-11 00:00:00		2020-08-25 00:00:00		2018-05-18 00:00:00		2018-03-19 00:00:00		2019-12-17 00:00:00		2019-12-31 00:00:00		2019-06-30 00:00:00		2017-12-31 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		2018-05-25 00:00:00		2018-09-12 00:00:00		2019-06-30 00:00:00		2019-03-31 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2018-09-24 00:00:00		2018-06-30 00:00:00		2022-04-21 00:00:00		2021-12-31 00:00:00		2019-12-31 00:00:00		2022-03-14 00:00:00		2022-05-09 00:00:00		2021-12-07 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2022-10-27 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		2001-01-19 00:00:00		None		2001-07-11 00:00:00		None		2002-01-31 00:00:00		None		None		2002-07-16 00:00:00		2003-01-23 00:00:00		None		2003-07-28 00:00:00		None		2004-01-20 00:00:00		None		None		2004-07-20 00:00:00		None		None		2005-01-20 00:00:00		None		2006-01-10 00:00:00		None		2005-07-19 00:00:00		2006-01-16 00:00:00		2006-01-16 00:00:00		2006-01-16 00:00:00		None		2005-10-24 00:00:00		2006-06-19 00:00:00		None		None		None		2006-07-11 00:00:00		2007-01-10 00:00:00		2007-07-31 00:00:00		None		2007-04-30 00:00:00		2007-10-31 00:00:00		2013-07-25 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2013-06-26 00:00:00		2013-08-02 00:00:00		2014-05-16 00:00:00		2014-05-30 00:00:00		2014-07-21 00:00:00		None		None		None		None		None		None		None		None		None		None		None		2013-10-20 00:00:00		2013-10-17 00:00:00		None		None		None		None		None		None		2013-10-20 00:00:00		2013-10-20 00:00:00		2013-10-14 00:00:00		None		None		None		None		2013-10-19 00:00:00		2013-10-19 00:00:00		2013-10-19 00:00:00		2013-10-19 00:00:00		2013-10-20 00:00:00		2013-10-20 00:00:00		2013-10-20 00:00:00		2013-10-20 00:00:00		2013-10-17 00:00:00		2013-10-20 00:00:00		None		2015-01-26 00:00:00		None		2014-10-13 00:00:00		2014-10-09 00:00:00		2008-01-30 00:00:00		2008-04-29 00:00:00		2008-07-30 00:00:00		2008-10-30 00:00:00		2009-01-29 00:00:00		2009-07-23 00:00:00		2009-10-28 00:00:00		2009-10-28 00:00:00		2009-04-24 00:00:00		2010-01-29 00:00:00		2010-04-29 00:00:00		2010-07-29 00:00:00		2010-10-27 00:00:00		2011-01-29 00:00:00		2011-04-29 00:00:00		2011-06-29 00:00:00		2011-10-31 00:00:00		2011-07-29 00:00:00		2012-01-30 00:00:00		2011-10-29 00:00:00		2012-04-28 00:00:00		2012-07-31 00:00:00		None		2014-03-20 00:00:00		2014-01-23 00:00:00		2012-10-31 00:00:00		None		2014-08-25 00:00:00		2014-09-11 00:00:00		2014-09-15 00:00:00		2014-09-23 00:00:00		2013-01-30 00:00:00		2014-03-31 00:00:00		None		None		None		2014-04-17 00:00:00		2014-03-31 00:00:00		2014-03-31 00:00:00		2014-03-31 00:00:00		2014-04-17 00:00:00		2013-04-22 00:00:00		2016-01-13 00:00:00		None		2015-07-31 00:00:00		None		2019-12-05 00:00:00		2021-01-25 00:00:00		2018-05-11 00:00:00		2019-01-24 00:00:00		2016-03-16 00:00:00		2016-01-27 00:00:00		None		2016-05-24 00:00:00		2016-04-20 00:00:00		2016-03-31 00:00:00		2016-04-25 00:00:00		2016-05-16 00:00:00		2016-07-13 00:00:00		2016-08-23 00:00:00		2016-08-16 00:00:00		None		2016-09-19 00:00:00		2016-09-23 00:00:00		2016-10-13 00:00:00		2017-01-26 00:00:00		None		2017-07-23 00:00:00		None		2020-09-11 00:00:00		2020-08-25 00:00:00		2018-05-18 00:00:00		2018-03-19 00:00:00		2019-12-17 00:00:00		2020-01-25 00:00:00		2019-07-23 00:00:00		None		None		None		2018-05-25 00:00:00		2018-09-12 00:00:00		None		None		None		2018-01-18 00:00:00		2018-09-24 00:00:00		2018-07-19 00:00:00		2022-04-21 00:00:00		None		None		2022-03-14 00:00:00		2022-05-09 00:00:00		2021-12-07 00:00:00		2022-07-21 00:00:00		None		2022-01-20 00:00:00		None		2022-10-27 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		22001		None		22001		None		22001		None		None		22001		None		None		22001		None		22001		None		22001		22001		22001		22001		None		22001		22001		None		None		None		22001		22001		22001		None		22001		22001		22006		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22006		22006		22001		22001		22001		None		None		None		None		None		None		None		None		None		None		None		22006		22006		None		None		None		None		None		None		22006		22006		22006		None		None		None		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22001		None		22001		22001		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22001		22001		22006		None		22001		22001		22001		22001		22006		22001		None		None		None		22001		22001		22001		22001		22001		22006		22001		None		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		None		None		None		22001		22001		None		None		None		22001		22001		22001		22001		None		None		22001		22001		22001		22001		None		22001		None		22001

Table: filer_to_filer_type

filer_id		1008988
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		0
county_cd		18022
district_cd		0

Table: filer_xref

filer_id		1008988
xref_id		481087
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087		481087
filer_id		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988
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		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		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		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		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		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		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		1990-12-01 00:00:00
naml		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY		TEJON RANCH COMPANY
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC		LEBEC
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		932430000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243-0000		93243		93243
phon		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		6612483000		2136246200
fax		None		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100		6612483100
email		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None

Table: filers

filer_id		1008988

Table: received_filings

filer_id		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988		1008988
filing_file_name		79008.cal		813523_0.cal		849876_0.cal		905226_0.cal		944978_0.cal		983380_0.cal		1073792_0.cal		313136.cal		303441.cal		313542.cal		1141326_1.cal		482118.cal		1285271_0.cal		1839078_0.cal		1850953_0.cal		1839345_0.cal		1830750_0.cal		1884529_0.cal		1856938_0.cal		2045585_0.cal		2078854_0.cal		2080890_0.cal		1896114_0.cal		1885230_0.cal		1880498_0.cal		2025196_0.cal		2030040_0.cal		2021017_0.cal		1897257_0.cal		1887740_0.cal		2088718_0.cal		2071057_0.cal		2069121_0.cal		2031900_0.cal		2043054_0.cal		259730.cal		117099.cal		2248525_0.cal		2250612_0.cal		2223268_0.cal		2423561_0.cal		2425297_0.cal		2495070_0.cal		2254614_0.cal		2291142_0.cal		2295099_0.cal		2657311_0.cal		2501303_0.cal		2668716_0.cal		310977.cal		2630350_0.cal		2680551_0.cal		2744264_0.cal
received_date		2002-01-31 00:00:00		2002-01-31 00:00:00		2002-07-16 00:00:00		2003-01-23 00:00:00		2003-07-28 00:00:00		2004-01-20 00:00:00		2005-01-21 00:00:00		2005-07-19 00:00:00		2005-07-19 00:00:00		2005-07-19 00:00:00		2006-01-16 00:00:00		2006-06-19 00:00:00		2007-07-31 00:00:00		2014-04-17 00:00:00		2014-05-16 00:00:00		2014-04-17 00:00:00		2014-03-20 00:00:00		2014-09-11 00:00:00		2014-05-30 00:00:00		2016-05-24 00:00:00		2016-09-19 00:00:00		2016-09-23 00:00:00		2014-10-09 00:00:00		2014-09-15 00:00:00		2014-08-25 00:00:00		2016-03-31 00:00:00		2016-04-20 00:00:00		2016-03-16 00:00:00		2014-10-13 00:00:00		2014-09-23 00:00:00		2016-10-13 00:00:00		2016-08-23 00:00:00		2016-08-16 00:00:00		2016-04-25 00:00:00		2016-05-16 00:00:00		2015-02-02 00:00:00		2017-07-31 00:00:00		2018-05-11 00:00:00		2018-05-18 00:00:00		2018-03-19 00:00:00		2019-12-05 00:00:00		2019-12-17 00:00:00		2020-08-25 00:00:00		2018-05-25 00:00:00		2018-09-12 00:00:00		2018-09-24 00:00:00		2022-03-14 00:00:00		2020-09-14 00:00:00		2022-04-21 00:00:00		2022-04-21 00:00:00		2021-12-07 00:00:00		2022-05-09 00:00:00		2022-10-27 00:00:00
filing_directory		/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/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/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/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		None		813523		849876		905226		944978		983380		1073792		None		None		None		1141326		None		1285271		1839078		1850953		1839345		1830750		1884529		1856938		2045585		2078854		2080890		1896114		1885230		1880498		2025196		2030040		2021017		1897257		1887740		2088718		2071057		2069121		2031900		2043054		None		None		2248525		2250612		2223268		2423561		2425297		2495070		2254614		2291142		2295099		2657311		2501303		2668716		None		2630350		2680551		2744264
form_id		None		F461		F461		F461		F461		F461		F461		None		None		None		F461		None		F461		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		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497
receive_comment		Filing did not pass validation		Filing accepted		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		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 did not pass validation		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 passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted