Home

Filer ID: 1018371

Table: filer_address

filer_id		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371
adrid		1016024		1016025		2003660		2089658		2118676		2118677		2124085		2124086		2157601		2436869		2438881		2297629		2299588		2299587		2522344
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00		2000-07-19 00:00:00		2005-06-21 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-02-22 00:00:00		2007-02-22 00:00:00		2009-01-11 00:00:00		2017-06-19 00:00:00		2017-08-01 00:00:00		2009-01-11 00:00:00		2013-09-13 00:00:00		2013-09-13 00:00:00		2021-08-09 00:00:00
add_type		7051		7051		7051		7051		7051		7082		7051		7082		7051		7051		7051		7082		7082		7051		7051
session_id		1977		1977		1999		2005		1899		1899		2007		2007		2009		2017		2017		2009		2013		2013		2021

Table: filer_filings

filer_id		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371
filing_id		85519		85520		85522		85523		85524		85525		85527		85528		85529		85530		85531		85532		85533		85534		85535		85536		85537		85538		85539		85540		85541		85542		85543		85544		85545		85546		85547		85548		85549		85550		85551		85552		85554		85555		85556		85557		85558		85559		85560		85561		85562		85563		85564		85565		85566		85567		85568		85569		85570		85571		85572		85573		85574		85504		85505		85506		85507		85508		85509		85510		85511		85512		85513		85514		85515		85516		85517		85518		206453		206455		206456		206457		206458		206460		206461		206462		206463		206464		206454		206459		85503		85521		85526		85553		580999		593761		672864		676626		651991		667827		645763		645854		722641		782430		806907		865137		878290		895288		883034		880301		916282		912115		947152		951670		985508		979902		985508		979902		1034000		1029694		1029206		1049721		1045267		1047813		1048928		1051274		1051645		1060490		1077453		1058850		1080460		1116131		1116716		1110304		1143054		1148160		1176092		1159722		1190296		1174372		1177194		1217994		1213097		1195261		1245556		1220583		1235423		1224345		1279712		1237817		1273256		1302293		1283914		1110304		1785153		1789725		1789726		1789174		1789177		1974129		1974130		1975174		1864720		1789103		1791399		1791629		1944072		1901267		1110304		1245556		1319992		1303697		1320636		1345023		1348646		1370072		1373161		1245556		1393570		1395931		1405105		1407262		1406997		1435534		1433364		1458192		1471217		1459673		1471600		1509857		1508348		1547459		1571877		1578476		1578937		1585029		1586965		1606634		1600221		1637072		1636078		1647562		1647902		1814634		1824894		1832660		1898933		1879031		1842383		1834947		1984017		2280304		2251304		2296116		2309954		2196893		2479172		2323338		2362541		2517574		2296116		2391433		2261646		2201844		2290105		2196444		2309954		2017755		2017447		2021448		2017167		2020311		2025306		2016403		2057549		2163535		2173006		2163185		2164625		2179028		2180034		2524787		2290106		2323194		2511065		2313060		2448701		2312376		2491519		2525102		1245556		2405050		2518642		2262749		2435879		2196441		2462074		2302169		2547326		2272041		2218256		2312376		2453397		2263048		2336689		2448249		2606907		2625994		2633564		2503314		2593376		2605927		2608740		2652017		2558556		2558563		2698489		2595669		2734068
period_id		87		89		89		90		91		91		94		93		94		97		95		98		99		99		101		101		101		103		103		104		105		104		105		106		107		108		108		72		61		57		75		73		118		121		129		130		130		133		145		145		147		147		148		149		153		153		154		155		155		156		156		156		157		73		75		75		65		65		77		80		81		82		83		83		84		85		85		79		75		77		82		97		100		103		134		145		151		151		76		102		73		87		92		113		None		None		None		None		None		None		None		None		None		None		None		None		172		None		None		None		None		172		173		None		None		175		None		175		None		165		177		180		179		None		180		180		None		None		None		None		180		None		181		None		None		183		None		173		186		185		186		None		187		None		189		188		188		None		None		None		None		191		189		None		None		None		None		211		213		220		219		221		217		209		None		None		None		None		None		194		193		None		None		None		193		195		None		197		None		196		None		None		197		197		None		199		201		None		None		None		201		203		204		205		None		None		None		205		None		None		207		209		None		215		None		217		219		None		None		None		None		None		234		235		235		None		241		236		None		243		235		237		233		232		235		231		235		None		225		225		None		None		None		223		225		None		229		227		None		None		None		244		235		236		None		236		None		None		None		None		235		None		244		None		239		232		None		None		244		None		None		None		241		234		236		241		247		None		247		243		245		None		None		None		None		None		249		247		None
form_id		F420		F420		F420		F420		F420		F420		F405		F420		F420		F420		F405		F420		F420		F420		F420		F420		F405		F420		F420		F420		F420		F405		F420		F420		F420		F420		F420		F405		F405		F410		F405		F405		F405		F405		F405		F405		F405		F888		F420		F405		F405		F405		F420		F420		F420		F420		F420		F405		F420		F405		F420		F420		F420		F420		F420		F405		F420		F420		F420		F420		F420		F420		F420		F420		F420		F405		F420		F420		F420		F405		F420		F420		F420		F405		F405		F405		F420		F405		F420		F420		F450		F405		F420		F405		F420		F420		F460		F460		F410		F410		F460		F405		F460		F460		F460		F460		F497		F410		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F666		F460		F497		F460		F460		F497		F460		F497		F497		F460		F460		F460		F460		F460		F410		F460		F460		F460		F666		F460		F460		F497		F460		F460		F460		F410		F497		F460		F460		F460		F460		F497		F460		F460		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F410		F410		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F888		F460		F460		F460		F497		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F410		F497		F497		F497		F460		F497		F460		F460		F460		F460		F410		F460		F497		F460		F460		F497		F460		F460		F460		F410		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F496		F460
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		1		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		1		0		0		0		0		0		0		0		2		0		0		0		0		0		0		0		0		0		0		0		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		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		3		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
filing_date		1982-01-29 00:00:00		1982-03-22 00:00:00		1982-05-27 00:00:00		1982-08-02 00:00:00		1982-09-22 00:00:00		1982-10-27 00:00:00		1983-05-13 00:00:00		1983-07-20 00:00:00		1984-01-23 00:00:00		1984-03-21 00:00:00		1984-05-29 00:00:00		1984-07-27 00:00:00		1984-09-24 00:00:00		1984-10-24 00:00:00		1985-03-21 00:00:00		1985-05-22 00:00:00		1985-06-28 00:00:00		1985-09-20 00:00:00		1985-10-24 00:00:00		1986-01-25 00:00:00		1986-03-22 00:00:00		1986-04-07 00:00:00		1986-05-20 00:00:00		1986-07-24 00:00:00		1986-10-06 00:00:00		1986-10-21 00:00:00		1987-01-27 00:00:00		1977-10-07 00:00:00		1975-01-28 00:00:00		1974-02-26 00:00:00		1978-08-03 00:00:00		1978-02-02 00:00:00		1989-04-19 00:00:00		1990-01-22 00:00:00		1992-01-06 00:00:00		1992-04-24 00:00:00		1992-05-18 00:00:00		1993-01-21 00:00:00		1996-07-31 00:00:00		1996-08-02 00:00:00		1996-07-31 00:00:00		1996-09-10 00:00:00		1997-01-31 00:00:00		1997-07-31 00:00:00		1998-03-23 00:00:00		1998-05-21 00:00:00		1998-07-29 00:00:00		1998-07-29 00:00:00		1998-10-05 00:00:00		1998-10-06 00:00:00		1998-10-21 00:00:00		1999-02-01 00:00:00		1999-08-02 00:00:00		1978-11-21 00:00:00		1978-11-13 00:00:00		1978-11-21 00:00:00		1979-07-31 00:00:00		1979-07-24 00:00:00		1979-07-31 00:00:00		1980-01-31 00:00:00		1980-04-30 00:00:00		1980-05-26 00:00:00		1980-09-30 00:00:00		1980-10-23 00:00:00		1981-02-02 00:00:00		1981-02-02 00:00:00		1981-07-31 00:00:00		1979-10-30 00:00:00		1978-10-06 00:00:00		1979-09-21 00:00:00		1980-07-31 00:00:00		1984-05-24 00:00:00		1985-01-31 00:00:00		1986-02-01 00:00:00		1993-04-09 00:00:00		1996-09-10 00:00:00		1998-01-30 00:00:00		1998-07-29 00:00:00		1979-02-01 00:00:00		1985-07-16 00:00:00		1978-08-01 00:00:00		1982-03-23 00:00:00		1983-01-31 00:00:00		1988-03-04 00:00:00		2000-01-10 00:00:00		2000-02-24 00:00:00		2000-10-05 00:00:00		2000-10-25 00:00:00		2000-07-19 00:00:00		2000-09-14 00:00:00		2000-07-31 00:00:00		2000-07-31 00:00:00		2001-01-31 00:00:00		2001-07-31 00:00:00		2002-01-10 00:00:00		2002-07-30 00:00:00		2002-10-24 00:00:00		2002-11-14 00:00:00		2002-10-23 00:00:00		2002-10-24 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2003-07-31 00:00:00		2003-07-31 00:00:00		2004-03-10 00:00:00		2004-01-12 00:00:00		2004-01-16 00:00:00		2004-03-09 00:00:00		2004-08-02 00:00:00		2004-07-30 00:00:00		2004-07-30 00:00:00		2004-10-20 00:00:00		2004-10-05 00:00:00		2004-10-05 00:00:00		2004-10-19 00:00:00		2004-10-21 00:00:00		2004-10-19 00:00:00		2004-10-21 00:00:00		2005-01-24 00:00:00		2004-10-21 00:00:00		2005-01-31 00:00:00		2005-07-22 00:00:00		2005-07-28 00:00:00		2005-06-21 00:00:00		2006-01-20 00:00:00		2006-01-31 00:00:00		2006-05-25 00:00:00		2006-03-30 00:00:00		2006-07-31 00:00:00		2006-05-25 00:00:00		2006-05-31 00:00:00		2006-10-26 00:00:00		2006-10-26 00:00:00		2006-07-27 00:00:00		2007-02-15 00:00:00		2006-11-06 00:00:00		2007-01-30 00:00:00		2006-06-02 00:00:00		2007-07-24 00:00:00		2007-01-29 00:00:00		2006-11-06 00:00:00		2008-01-07 00:00:00		2007-07-31 00:00:00		2007-02-22 00:00:00		2013-07-26 00:00:00		2013-08-27 00:00:00		2013-08-27 00:00:00		2013-08-26 00:00:00		2013-08-26 00:00:00		2015-07-13 00:00:00		2015-07-13 00:00:00		2015-07-19 00:00:00		2014-07-21 00:00:00		2013-08-25 00:00:00		2013-09-13 00:00:00		2013-09-12 00:00:00		2015-01-22 00:00:00		2014-10-17 00:00:00		2008-04-28 00:00:00		2008-04-01 00:00:00		2008-03-24 00:00:00		2008-01-15 00:00:00		2008-03-24 00:00:00		2008-07-22 00:00:00		2008-07-30 00:00:00		2008-10-23 00:00:00		2008-10-22 00:00:00		2009-01-12 00:00:00		2009-01-28 00:00:00		2009-01-30 00:00:00		2009-01-13 00:00:00		2009-03-12 00:00:00		2009-03-12 00:00:00		2009-07-29 00:00:00		2009-07-23 00:00:00		2010-01-18 00:00:00		2010-03-04 00:00:00		2010-01-22 00:00:00		2010-03-05 00:00:00		2010-07-29 00:00:00		2010-08-02 00:00:00		2010-12-02 00:00:00		2011-01-31 00:00:00		2011-02-23 00:00:00		2011-02-24 00:00:00		2011-03-28 00:00:00		2010-12-02 00:00:00		2011-07-29 00:00:00		2011-07-13 00:00:00		2012-01-30 00:00:00		2012-01-31 00:00:00		2012-03-22 00:00:00		2012-03-22 00:00:00		2014-01-28 00:00:00		2014-01-30 00:00:00		2014-03-24 00:00:00		2014-10-15 00:00:00		2014-08-04 00:00:00		2013-12-12 00:00:00		2014-03-25 00:00:00		2015-07-27 00:00:00		2018-08-01 00:00:00		2018-05-21 00:00:00		2018-11-28 00:00:00		2018-11-28 00:00:00		2017-11-17 00:00:00		2020-07-17 00:00:00		2018-11-03 00:00:00		2019-02-05 00:00:00		2020-10-18 00:00:00		2018-09-26 00:00:00		2019-07-20 00:00:00		2018-06-26 00:00:00		2018-01-14 00:00:00		2018-09-08 00:00:00		2017-11-17 00:00:00		2018-10-22 00:00:00		2016-02-23 00:00:00		2016-02-25 00:00:00		2016-03-18 00:00:00		2016-02-02 00:00:00		2016-03-11 00:00:00		2016-03-22 00:00:00		2016-02-21 00:00:00		2016-07-23 00:00:00		2017-06-15 00:00:00		2017-07-27 00:00:00		2017-06-14 00:00:00		2017-06-19 00:00:00		2017-07-31 00:00:00		2017-08-01 00:00:00		2020-10-28 00:00:00		2018-09-08 00:00:00		2018-11-02 00:00:00		2020-09-29 00:00:00		2018-10-25 00:00:00		2020-01-30 00:00:00		2018-10-23 00:00:00		2020-07-27 00:00:00		2020-10-22 00:00:00		2018-07-01 00:00:00		2019-07-30 00:00:00		2020-10-20 00:00:00		2018-06-29 00:00:00		2020-01-26 00:00:00		2017-11-17 00:00:00		2020-02-21 00:00:00		2018-09-27 00:00:00		2021-01-26 00:00:00		2018-07-26 00:00:00		2018-01-29 00:00:00		2018-12-14 00:00:00		2020-02-17 00:00:00		2018-07-08 00:00:00		2019-01-21 00:00:00		2020-02-09 00:00:00		2021-08-16 00:00:00		2021-08-20 00:00:00		2022-01-10 00:00:00		2020-09-21 00:00:00		2021-07-14 00:00:00		2021-08-09 00:00:00		2021-08-05 00:00:00		2022-01-31 00:00:00		2021-02-04 00:00:00		2021-02-08 00:00:00		2022-07-15 00:00:00		2021-07-22 00:00:00		2022-08-01 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		10005		10005		10005		10005		10002		10002		10005		10005		10005		10005		10005		10005		10001		10002		10005		10005		10005		10001		10001		10005		10006		10001		10005		10002		10005		10005		10001		10001		10001		10005		10001		10001		10005		10005		10005		10005		10001		10005		10001		10006		10005		10001		10005		10005		10001		10001		10001		10005		10001		10005		10001		10001		10001		10005		10005		10005		10005		10001		10001		10006		10002		10005		10005		10001		10001		10001		10001		10001		10001		10001		10002		10005		10005		10005		10006		10002		10001		10005		10005		10005		10001		10001		10005		10002		10005		10001		10006		10005		10001		10001		10005		10001		10001		10005		10005		10005		10001		10001		10001		10001		10005		10005		10005		10001		10005		10005		10001		10001		10005		10001		10005		10001		10001		10005		10005		10005		10005		10005		10001		10002		10002		10005		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10006		10001		10001		10005		10005		10005		10001		10001		10005		10001		10001		10006		10005		10006		10001		10001		10001		10005		10001		10005		10005		10005		10005		10002		10005		10001		10005		10001		10001		10005		10005		10001		10006		10005		10002		10001		10001		10001		10001		10001		10005		10001		10001		10001		10006		10005		10005		10005		10005		10001		10001		10005
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		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11001		11001		11003		11003		11003		11001		11003		11001		11003		11001		11003		11003		11001		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11003		11003		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		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		11003		11003		11003		11003
session_id		1981		1981		1981		1981		1981		1981		1983		1983		1983		1983		1983		1983		1983		1983		1985		1985		1985		1985		1985		1985		1985		1985		1985		1985		1985		1985		1985		1977		1975		1973		1977		1977		1989		1989		1991		1991		1991		1993		1995		1995		1995		1995		1995		1997		1997		1997		1997		1997		1997		1997		1997		1997		1999		1977		1977		1977		1975		1975		1979		1979		1979		1979		1979		1979		1979		1981		1981		1979		1977		1979		1979		1983		1983		1985		1993		1995		1997		1997		1977		1985		1977		1981		1981		1987		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2003		2005		2005		2005		2005		2005		2005		2007		2005		2005		2005		2007		2005		2005		2007		2007		2005		2013		2011		2013		2011		2013		2013		2013		2015		2013		2011		2013		2011		2013		2013		2005		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2013		2013		2013		2015		2017		2017		2017		2017		2017		2019		2017		2017		2019		2017		2019		2017		2017		2017		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2015		2017		2017		2017		2019		2017		2017		2019		2017		2019		2017		2019		2019		2017		2019		2019		2017		2019		2017		2019		2017		2019		2017		2017		2017		2019		2017		2017		2019		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		KCHAN		KCHAN		DHORRELL		TTHAM		JLEHMAN		JLEHMAN		TWALLS		LTHIBAUL		MHOANG		DBARRICK		*		TTHAM		DBARRICK		KLARRY		DBARRICK		COMPLETED		COMPLETED		GGILMORE		RSAGARIO		COMPLETED		KLARRY		COMPLETED		EMCENTEE		PROBERTS		COMPLETED		PBANFORD		COMPLETED		GPEREZ		GKURIMOT		COMPLETED		GPEREZ		EMCENTEE		KVOONG1		SARRIAGA		COMPLETED		KVANG		*		TTHAM		DHORRELL		*		CFLAGG		PROBERTS		*		*		*		CFLAGG		*		GPEREZ		*		DHORRELL		*		GGILMORE		GPEREZ		SARRIAGA		DHORRELL		*		*		EMCENTEE		TRAMON		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		CAFILER		MDIGRAZIA		MDIGRAZIA		CAFILER		CPON		TRAMON		CPON		GCLARA		RGEREMIA		EMCENTEE		*		*		TMILLER		SARRIAGA		RGEREMIA		*		*		NLANDERS		*		JVAZQUEZ		*		RGEREMIA		CPON		CPON		*		SARRIAGA		CPON		CPON		CPON		CPON		SMCCONNAN		SMCCONNAN		CPON		*		MMORENO		MDIGRAZIA		TBOWMAN		CPON		SMCCONNAN		SMCCONNAN		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		CAFILER		GGILMORE		CAFILER		RGEREMIA		RGEREMIA		SBROWN		RGEREMIA		MDIGRAZIA		BSINGH		CAFILER		CAFILER		CAFILER		CSAGABAEN		IMEDINA		CAFILER		AROJAS		IMEDINA		CSAGABAEN		HCOURSEY		CSAGABAEN		CSAGABAEN		RGEREMIA		CSAGABAEN		CSAGABAEN		SMCCONNAN		MDIGRAZIA		CAFILER		SMCCONNAN		MDIGRAZIA		MPACHECO		SMCCONNAN		CAFILER		LLEONG		LBARTHOL		KBANH		TRAMON		LBARTHOL		RSAGARIO		CAFILER		RGEREMIA		CAFILER		CPON		CAFILER		VUKSTINA		CSAGABAEN		IMEDINA		IMEDINA		TRAMON		HCOURSEY		CAFILER		CSAGABAEN		VUKSTINA		GKURIMOT		IMEDINA		CSAGABAEN		CPON		TRAMON		CSAGABAEN		LBARTHOL		IMEDINA		BSINGH		AROJAS		RGEREMIA		IMEDINA		IMEDINA		KRUSSELL		CPON		LPHEAV		IMEDINA		LPHEAV		KRUSSELL		CPON		SUSHAKOV		CAFILER		CAFILER		RGEREMIA
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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		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		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11003		11001		11001		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11003		11001		11001		11003		11001		11001		11003		11001		11001		11003		11001		11003		11001		11003		11001		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11003		11003		11003		11003
rpt_start		1981-07-01 00:00:00		1982-01-01 00:00:00		1982-03-18 00:00:00		1982-05-23 00:00:00		1982-07-01 00:00:00		1982-09-18 00:00:00		None		1983-01-01 00:00:00		1983-06-30 00:00:00		1984-01-01 00:00:00		1983-07-01 00:00:00		1984-05-20 00:00:00		1984-07-01 00:00:00		1984-09-18 00:00:00		1985-01-01 00:00:00		1985-03-18 00:00:00		1985-03-18 00:00:00		1985-07-01 00:00:00		1985-09-18 00:00:00		1985-10-20 00:00:00		1986-01-01 00:00:00		1985-10-20 00:00:00		1986-03-18 00:00:00		1986-05-18 00:00:00		1986-07-01 00:00:00		1986-10-01 00:00:00		1986-10-19 00:00:00		None		None		None		None		None		None		None		None		None		None		None		1996-01-01 00:00:00		1996-01-01 00:00:00		None		None		1996-10-20 00:00:00		1997-01-01 00:00:00		1998-01-01 00:00:00		1998-03-18 00:00:00		1998-05-17 00:00:00		None		1998-07-01 00:00:00		None		1998-10-01 00:00:00		1998-10-18 00:00:00		1999-01-01 00:00:00		1978-01-01 00:00:00		1978-09-24 00:00:00		1978-07-01 00:00:00		1976-01-01 00:00:00		1976-01-01 00:00:00		1979-01-01 00:00:00		1979-10-23 00:00:00		1980-01-01 00:00:00		1980-04-24 00:00:00		1980-07-01 00:00:00		1980-09-24 00:00:00		1980-10-21 00:00:00		None		1981-01-01 00:00:00		1979-09-25 00:00:00		1978-07-01 00:00:00		1979-01-01 00:00:00		1980-05-20 00:00:00		1984-03-18 00:00:00		1984-10-21 00:00:00		1985-07-01 00:00:00		None		1996-01-01 00:00:00		1997-07-01 00:00:00		1997-07-01 00:00:00		1978-10-24 00:00:00		1985-05-19 00:00:00		1978-01-01 00:00:00		1981-07-01 00:00:00		1982-10-17 00:00:00		None		1999-07-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		None		None		2000-02-20 00:00:00		2000-01-01 00:00:00		2000-10-22 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2002-10-24 00:00:00		None		2002-07-01 00:00:00		None		2002-10-20 00:00:00		2002-10-20 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		2003-07-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		2002-10-20 00:00:00		2004-01-01 00:00:00		2004-10-20 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-10-19 00:00:00		2004-10-01 00:00:00		None		None		2004-10-17 00:00:00		2004-10-01 00:00:00		2004-10-17 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		None		2005-07-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2003-01-01 00:00:00		2006-05-21 00:00:00		2006-01-01 00:00:00		2006-05-31 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2006-05-21 00:00:00		2007-02-15 00:00:00		2006-11-06 00:00:00		2006-10-22 00:00:00		2006-01-01 00:00:00		2007-01-01 00:00:00		2006-10-22 00:00:00		None		2007-07-01 00:00:00		2007-01-01 00:00:00		None		None		2012-07-01 00:00:00		2013-01-01 00:00:00		2012-07-01 00:00:00		2013-01-01 00:00:00		2014-10-01 00:00:00		2014-07-01 00:00:00		2015-01-01 00:00:00		2014-01-01 00:00:00		2012-03-18 00:00:00		None		2012-03-18 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		None		2008-04-01 00:00:00		2008-01-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-03-18 00:00:00		2008-03-18 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2009-01-11 00:00:00		2008-10-19 00:00:00		2008-10-19 00:00:00		None		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-03-08 00:00:00		2009-03-08 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-02-28 00:00:00		2010-02-28 00:00:00		2010-07-01 00:00:00		2010-11-21 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2010-11-21 00:00:00		2010-07-01 00:00:00		2011-02-20 00:00:00		2011-02-20 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2014-01-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2014-01-01 00:00:00		2015-01-01 00:00:00		2018-06-24 00:00:00		2018-05-21 00:00:00		2018-07-01 00:00:00		2018-09-23 00:00:00		2017-07-01 00:00:00		2020-02-16 00:00:00		2018-11-03 00:00:00		2018-10-21 00:00:00		2020-09-20 00:00:00		2018-07-01 00:00:00		2019-01-01 00:00:00		2018-01-01 00:00:00		2017-10-22 00:00:00		2018-09-08 00:00:00		2017-07-01 00:00:00		2018-09-23 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2016-02-21 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2016-02-21 00:00:00		2015-07-01 00:00:00		2016-03-20 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2016-07-01 00:00:00		None		2017-01-01 00:00:00		None		2020-10-28 00:00:00		2018-09-08 00:00:00		2018-11-02 00:00:00		2020-07-01 00:00:00		2018-10-25 00:00:00		2019-07-01 00:00:00		2018-09-23 00:00:00		2020-02-16 00:00:00		2020-09-20 00:00:00		2018-07-01 00:00:00		2019-01-01 00:00:00		2020-10-20 00:00:00		2018-01-01 00:00:00		2019-07-01 00:00:00		2017-11-17 00:00:00		2020-01-01 00:00:00		2018-07-01 00:00:00		2020-10-18 00:00:00		None		2017-10-22 00:00:00		2018-09-23 00:00:00		2020-01-01 00:00:00		2018-06-24 00:00:00		2018-10-21 00:00:00		2020-02-09 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2021-08-01 00:00:00		2020-07-01 00:00:00		2021-01-01 00:00:00		None		2021-01-01 00:00:00		2021-08-01 00:00:00		2020-10-18 00:00:00		2020-07-01 00:00:00		2022-01-01 00:00:00		2021-07-22 00:00:00		2022-01-01 00:00:00
rpt_end		1981-12-31 00:00:00		1982-03-17 00:00:00		1982-05-22 00:00:00		1982-06-30 00:00:00		1982-09-17 00:00:00		1982-10-16 00:00:00		None		1983-06-30 00:00:00		1983-12-31 00:00:00		1984-03-17 00:00:00		1983-12-31 00:00:00		1984-06-30 00:00:00		1984-09-17 00:00:00		1984-10-20 00:00:00		1985-03-17 00:00:00		1985-05-18 00:00:00		1985-05-18 00:00:00		1985-09-17 00:00:00		1985-10-19 00:00:00		1985-12-31 00:00:00		1986-03-17 00:00:00		1985-12-31 00:00:00		1986-05-17 00:00:00		1986-06-30 00:00:00		1986-09-30 00:00:00		1986-10-18 00:00:00		1986-12-31 00:00:00		None		None		None		None		None		None		None		None		None		None		None		1996-06-30 00:00:00		1996-06-30 00:00:00		None		None		1996-12-31 00:00:00		1997-06-30 00:00:00		1998-03-17 00:00:00		1998-05-16 00:00:00		1998-06-30 00:00:00		None		1998-09-30 00:00:00		None		1998-10-17 00:00:00		1998-12-31 00:00:00		1999-06-30 00:00:00		1978-06-30 00:00:00		1978-10-23 00:00:00		1978-09-23 00:00:00		1976-04-26 00:00:00		1976-04-26 00:00:00		1979-06-30 00:00:00		1979-12-31 00:00:00		1980-04-23 00:00:00		1980-05-19 00:00:00		1980-09-23 00:00:00		1980-10-20 00:00:00		1980-12-31 00:00:00		None		1981-06-30 00:00:00		1979-10-22 00:00:00		1978-09-23 00:00:00		1979-06-30 00:00:00		1980-06-30 00:00:00		1984-05-19 00:00:00		1984-12-31 00:00:00		1985-09-17 00:00:00		None		1996-06-30 00:00:00		1997-12-31 00:00:00		1997-12-31 00:00:00		1978-12-31 00:00:00		1985-06-30 00:00:00		None		1981-12-31 00:00:00		1982-12-31 00:00:00		None		1999-12-31 00:00:00		2000-02-22 00:00:00		2000-09-30 00:00:00		2000-10-21 00:00:00		None		None		2000-06-30 00:00:00		2000-02-19 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-10-24 00:00:00		None		2002-10-19 00:00:00		None		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		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2002-12-31 00:00:00		2004-06-30 00:00:00		2004-10-20 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-10-19 00:00:00		2004-10-16 00:00:00		None		None		2004-12-31 00:00:00		2004-10-16 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		None		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-05-20 00:00:00		2004-12-31 00:00:00		2006-06-30 00:00:00		2006-05-20 00:00:00		2006-05-31 00:00:00		2006-10-21 00:00:00		2006-10-21 00:00:00		2006-06-30 00:00:00		2007-02-15 00:00:00		2006-11-06 00:00:00		2006-12-31 00:00:00		2006-05-20 00:00:00		2007-06-30 00:00:00		2006-12-31 00:00:00		None		2007-12-31 00:00:00		2007-06-30 00:00:00		None		None		2012-12-31 00:00:00		2013-06-30 00:00:00		2012-12-31 00:00:00		2013-06-30 00:00:00		2014-10-18 00:00:00		2014-12-31 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2012-06-30 00:00:00		None		2012-06-30 00:00:00		2014-12-31 00:00:00		2014-09-30 00:00:00		None		2008-04-01 00:00:00		2008-03-17 00:00:00		2007-12-31 00:00:00		2008-03-17 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-10-18 00:00:00		2008-10-18 00:00:00		2009-01-11 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		None		2009-03-07 00:00:00		2009-03-07 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-02-27 00:00:00		2009-12-31 00:00:00		2010-02-27 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-11-20 00:00:00		2010-12-31 00:00:00		2011-02-19 00:00:00		2011-02-19 00:00:00		2010-12-31 00:00:00		2010-11-20 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-03-17 00:00:00		2012-03-17 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2014-03-17 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2013-06-30 00:00:00		2014-03-17 00:00:00		2015-06-30 00:00:00		2018-06-30 00:00:00		2018-05-21 00:00:00		2018-09-22 00:00:00		2018-10-20 00:00:00		2017-10-21 00:00:00		2020-06-30 00:00:00		2018-11-03 00:00:00		2018-12-31 00:00:00		2020-10-17 00:00:00		2018-09-22 00:00:00		2019-06-30 00:00:00		2018-06-23 00:00:00		2017-12-31 00:00:00		2018-09-08 00:00:00		2017-10-21 00:00:00		2018-10-20 00:00:00		2015-12-31 00:00:00		2016-02-20 00:00:00		2016-03-19 00:00:00		2015-12-31 00:00:00		2016-02-20 00:00:00		2016-03-19 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2016-12-31 00:00:00		None		2017-06-30 00:00:00		None		2020-10-28 00:00:00		2018-09-08 00:00:00		2018-11-02 00:00:00		2020-09-19 00:00:00		2018-10-25 00:00:00		2019-12-31 00:00:00		2018-10-20 00:00:00		2020-06-30 00:00:00		2020-10-17 00:00:00		2018-07-01 00:00:00		2019-06-30 00:00:00		2020-10-20 00:00:00		2018-06-23 00:00:00		2019-12-31 00:00:00		2017-11-17 00:00:00		2020-02-15 00:00:00		2018-09-22 00:00:00		2020-12-31 00:00:00		None		2017-12-31 00:00:00		2018-10-20 00:00:00		2020-02-15 00:00:00		2018-06-30 00:00:00		2018-12-31 00:00:00		2020-02-09 00:00:00		2021-07-31 00:00:00		2021-07-31 00:00:00		2021-12-31 00:00:00		2020-09-19 00:00:00		2021-06-30 00:00:00		None		2021-06-30 00:00:00		2021-12-31 00:00:00		2020-12-31 00:00:00		2020-12-31 00:00:00		2022-06-30 00:00:00		2021-07-22 00:00:00		2022-06-30 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		2002-10-24 00:00:00		None		None		None		None		2003-01-16 00:00:00		2003-06-30 00:00:00		None		None		2003-12-31 00:00:00		None		2003-12-31 00:00:00		None		None		2004-06-30 00:00:00		2004-10-20 00:00:00		2004-09-30 00:00:00		None		2004-10-19 00:00:00		2004-10-16 00:00:00		None		None		None		None		2004-12-31 00:00:00		None		2005-07-11 00:00:00		None		None		2006-01-16 00:00:00		None		None		2006-07-24 00:00:00		2006-05-23 00:00:00		2006-05-31 00:00:00		None		2006-10-23 00:00:00		None		None		2006-11-06 00:00:00		2007-01-11 00:00:00		None		None		None		None		2008-01-03 00:00:00		2007-07-31 00:00:00		None		None		None		None		2013-08-26 00:00:00		2013-08-26 00:00:00		2015-07-13 00:00:00		2015-07-13 00:00:00		2015-07-19 00:00:00		2014-07-21 00:00:00		2013-08-25 00:00:00		None		None		None		None		None		None		2008-03-20 00:00:00		None		None		None		2008-07-08 00:00:00		2008-10-20 00:00:00		None		None		None		2009-01-19 00:00:00		None		None		2009-03-11 00:00:00		2009-07-14 00:00:00		None		2010-01-15 00:00:00		2010-03-02 00:00:00		None		None		None		2010-07-26 00:00:00		2010-12-02 00:00:00		2011-01-31 00:00:00		2011-02-22 00:00:00		None		None		None		2011-07-07 00:00:00		None		None		2012-01-24 00:00:00		2012-03-21 00:00:00		None		2014-01-28 00:00:00		None		2014-03-24 00:00:00		2014-10-15 00:00:00		None		None		None		None		None		2018-05-21 00:00:00		2018-11-28 00:00:00		2018-11-28 00:00:00		None		2020-07-16 00:00:00		2018-11-03 00:00:00		None		2020-10-16 00:00:00		2018-09-22 00:00:00		2019-07-16 00:00:00		2018-06-26 00:00:00		2018-01-14 00:00:00		2018-09-08 00:00:00		2017-11-17 00:00:00		2018-10-22 00:00:00		None		2016-02-25 00:00:00		2016-03-24 00:00:00		None		None		None		2016-02-01 00:00:00		2016-08-01 00:00:00		None		2017-07-27 00:00:00		2017-06-14 00:00:00		None		None		None		2020-10-28 00:00:00		2018-09-08 00:00:00		2018-11-02 00:00:00		None		2018-10-25 00:00:00		None		None		None		None		None		None		2020-10-20 00:00:00		None		2020-01-26 00:00:00		2017-11-17 00:00:00		None		None		2021-01-18 00:00:00		None		None		None		2020-02-17 00:00:00		2018-07-08 00:00:00		2019-01-21 00:00:00		2020-02-09 00:00:00		2021-08-16 00:00:00		None		2022-01-10 00:00:00		2020-09-21 00:00:00		2021-07-14 00:00:00		None		None		None		None		None		2022-07-15 00:00:00		2021-07-22 00:00:00		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		22001		None		None		22001		22001		22001		None		22001		22001		None		None		None		None		22001		None		22001		None		None		22001		None		None		22001		22001		22001		None		22001		None		22001		22001		22001		None		None		None		None		22001		22001		None		None		None		None		22001		22001		22001		22001		22001		22001		22001		None		None		None		None		None		22001		22001		None		None		None		22001		22001		None		22001		None		22001		None		None		22001		22001		None		22001		22001		None		None		None		22001		22001		22001		22001		None		None		None		22001		None		None		22001		22001		None		22001		None		22001		22001		None		None		None		None		None		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		None		None		22001		22001		None		22001		22001		None		None		None		22001		22001		22001		None		22001		None		None		None		None		22001		None		22001		None		22001		22001		None		None		22001		None		None		None		22001		22001		22001		22001		22001		None		22001		22001		22001		None		None		None		None		None		22001		22001		None

Table: filer_to_filer_type

filer_id		1018371		1018371
filer_type		16		16
active		Y		Y
race		0		0
session_id		1977		2003
category		0		0
category_type		40502		40502
sub_category		40103		40104
effect_dt		2002-11-14 00:00:00		2003-08-04 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		S		S
nyq_dt		1977-10-19 00:00:00		1977-10-19 00:00:00
party_cd		0		0
county_cd		18012		18012
district_cd		0		0

Table: filer_xref

filer_id		1018371
xref_id		741598
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598		741598
filer_id		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT 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		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00		2003-08-04 00:00:00
naml		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN PARTY		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE		BUTTE COUNTY REPUBLICAN CENTRAL COMMITTEE
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		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		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		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		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		None		None		None		None		None
city		PARADISE		CHICO		MAGALIA		MAGALIA		Magalia		Magalia		MAGALIA		MAGALIA		MAGALIA		MAGALIA		MAGALIA		MAGALIA		CHICO		CHICO		CHICO		PARADISE		CHICO		MAGALIA		MAGALIA		Magalia		Magalia		MAGALIA		MAGALIA		MAGALIA		MAGALIA		MAGALIA		MAGALIA		CHICO		CHICO		CHICO
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		CA		CA		CA		CA		CA
zip4		959690000		959280000		95954		95954		95954-9645		95954-0822		95954		959540822		95954		959540822		95954		95954		95926		95926		95973		959690000		959280000		95954		95954		95954-9645		95954-0822		95954		959540822		95954		959540822		95954		95954		95926		95926		95973
phon		9163450757		5308952199		5308952199		5308732379		(530) 894-6567		(530) 894-6567		5308946567				5308946567		5308946567		5308946567				5308946567		7142204009		9166227474		9163450757		5308952199		5308952199		5308732379		(530) 894-6567		(530) 894-6567		5308946567				5308946567		5308946567		5308946567				5308946567		7142204009		9166227474
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1018371

Table: received_filings

filer_id		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371		1018371
filing_file_name		878290_0.cal		912115_0.cal		947152_0.cal		979902_0.cal		186323.cal		186435.cal		186411.cal		1048928_0.cal		1049721_0.cal		1177194_0.cal		1220583_0.cal		159684.cal		416963.cal		160386.cal		416609.cal		2251304_0.cal		2323338_0.cal		2290105_0.cal		2290106_0.cal		2323194_0.cal		2313060_0.cal		2448249_0.cal		2196441_0.cal		2524787_0.cal		2518642_0.cal
received_date		2002-10-24 00:00:00		2003-01-31 00:00:00		2003-07-31 00:00:00		2004-01-12 00:00:00		2004-03-09 00:00:00		2004-03-09 00:00:00		2004-03-09 00:00:00		2004-10-19 00:00:00		2004-10-20 00:00:00		2006-05-31 00:00:00		2006-11-06 00:00:00		2016-02-02 00:00:00		2016-02-21 00:00:00		2016-02-02 00:00:00		2016-02-21 00:00:00		2018-05-21 00:00:00		2018-11-03 00:00:00		2018-09-08 00:00:00		2018-09-08 00:00:00		2018-11-02 00:00:00		2018-10-25 00:00:00		2020-02-09 00:00:00		2017-11-17 00:00:00		2020-10-28 00:00:00		2020-10-20 00:00:00
filing_directory		/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/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
filing_id		878290		912115		947152		979902		None		None		None		1048928		1049721		1177194		1220583		None		None		None		None		2251304		2323338		2290105		2290106		2323194		2313060		2448249		2196441		2524787		2518642
form_id		F497		F460		F460		F460		None		None		None		F497		F497		F497		F497		None		None		None		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		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