Home

Filer ID: 1147273

Table: filer_address

filer_id		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273
adrid		1108816		2041508		2079017		2113732		2159247		2204591		2412241		2465238		2278615		2337836
effect_dt		1999-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1999		2003		2005		2007		2009		2011		2017		2019		2013		2015

Table: filer_filings

filer_id		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273
filing_id		674751		509949		504991		504626		507976		506294		507004		504296		506644		507296		508353		504009		509018		509309		505998		507681		505998		504991		507681		505635		508646		504009		504991		504009		509672		504009		504009		504991		507004		507681		509949		505998		504009		504991		505284		505998		508646		505635		624003		626472		605944		605946		628875		645288		654047		714921		713728		713728		689365		711605		702208		713637		713728		713279		762926		766204		743615		734407		724828		750439		774187		777275		784210		791329		810917		821250		815511		793552		810917		839865		839030		841995		847812		848535		848536		848898		890661		856169		854941		882659		926136		926135		906163		896952		898800		916583		920114		898800		927249		911323		932355		929777		966837		951530		946990		969336		974016		987941		989417		898800		1007747		971814		1012377		1009112		999859		898800		1026760		1007995		1013284		1027740		1020642		1049151		1055615		1039755		1039757		1038876		1055615		1067574		1073387		1062755		1080607		1078947		1099635		1117647		1104838		1132104		1165523		1154254		1154255		1149306		1154309		1189041		1067574		1194650		1181072		1149306		1224065		1067574		1221889		1220250		1215279		1224065		1224065		1232963		1233560		1233563		1232397		1256195		1280301		1224065		1261296		1261748		1224065		1295843		1301377		1224065		1781833		1718928		1789449		1961896		1981045		1966210		1799283		1792193		1718928		1943696		1925140		1908737		1327277		1290446		1310893		1350893		1357796		1357033		1224065		1224065		1375902		1357017		1375902		1383503		1397388		1420412		1436914		1421824		1426801		1407734		1448701		1458305		1383503		1467634		1482427		1462242		1383503		1511992		1505007		1538559		1543161		1567867		1383503		1559685		1552008		1552008		1588163		1552008		1621089		1579477		1604271		1552008		1636154		1638206		1638212		1615988		1552008		1644161		1552008		1552008		1652840		1655496		1643844		1621089		1636154		1679133		1552008		1655496		1925140		1934546		1552008		1718928		1708533		1718928		1868207		1882140		1726436		1716792		1844996		1847951		1850350		1816561		1718928		1718928		1764840		1735811		1995146		1966210		1993163		1925140		1986878		1925140		2210572		2119435		2274409		2318887		2119435		2241425		2263080		2007683		2036667		2047950		2048855		2062111		2101237		2128622		2119435		2154660		2119435		2132959		2173049		2161210		2119435		2196807		2190531		2119435		2231524		2347790		2190714
period_id		163		156		142		157		153		151		144		149		159		152		146		141		147		155		143		145		143		142		145		158		154		141		142		141		148		141		141		142		144		145		156		143		141		142		150		143		154		158		161		None		160		160		161		162		162		164		165		165		163		None		None		None		165		164		None		None		165		152		None		165		166		None		None		167		168		None		None		None		168		None		169		None		None		None		None		None		None		None		170		171		None		None		None		None		172		None		None		172		None		172		None		173		None		None		174		175		None		176		None		177		None		None		177		None		None		178		178		None		None		None		None		None		179		None		None		None		179		180		None		None		None		180		None		182		181		183		185		None		None		184		None		186		187		None		None		184		188		188		188		None		187		188		188		None		None		None		188		None		190		188		189		None		191		191		None		192		214		214		None		None		222		221		215		None		215		None		220		219		193		None		192		194		None		None		195		195		195		None		195		197		196		197		198		197		None		None		199		None		201		None		201		200		203		None		202		203		None		204		204		None		205		204		205		207		207		None		206		209		208		None		None		None		209		None		209		210		None		209		None		207		208		210		209		209		220		220		212		212		211		219		218		None		None		None		217		None		None		216		218		218		213		212		223		221		None		223		None		223		232		232		234		235		234		233		None		224		225		226		None		226		227		228		228		229		230		None		230		None		232		None		231		234		None		236		None
form_id		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F690		F625		F690		F690		F690		F690		F690		F690		F690		F690		F625		F690		F690		F690		F690		F690		F690		F690		F690		F690		F625		F625		F625		F625		F625		F601		F625		F625		F625		F625		F625		F625		F601		F601		F625		F605		F601		F605		F601		F625		F605		F605		F625		F690		F601		F625		F625		F625		F605		F625		F625		F605		F625		F625		F625		F605		F625		F625		F690		F605		F605		F602		F625		F625		F625		F625		F605		F605		F605		F601		F601		F625		F605		F601		F690		F625		F625		F625		F690		F625		F625		F625		F602		F625		F625		F601		F605		F625		F625		F605		F605		F601		F625		F605		F625		F625		F602		F605		F625		F605		F605		F605		F625		F601		F601		F625		F625		F625		F690		F625		F625		F625		F625		F605		F605		F625		F605		F625		F601		F605		F605		F625		F601		F601		F602		F605		F625		F601		F601		F601		F605		F601		F625		F605		F625		F601		F625		F605		F601		F625		F605		F601		F625		F601		F605		F605		F625		F625		F625		F605		F601		F601		F601		F625		F625		F605		F625		F625		F605		F602		F601		F601		F625		F605		F625		F601		F625		F625		F625		F602		F602		F601		F625		F605		F601		F602		F625		F625		F601		F605		F625		F625		F605		F625		F601		F601		F601		F601		F625		F601		F625		F605		F625		F601		F625		F605		F605		F605		F601		F605		F601		F601		F605		F625		F605		F625		F625		F625		F601		F625		F601		F625		F601		F601		F625		F601		F625		F605		F601		F605		F625		F605		F605		F625		F601		F601		F625		F625		F625		F625		F605		F601		F605		F601		F625		F601		F625		F625		F601		F625		F605		F625		F625		F602		F602		F625		F625		F625		F601		F625		F601		F601		F625		F605		F601		F605		F625		F601		F605		F625		F605
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		3		0		1		1		2		1		1		2		2		1		0		4		5		3		1		1		1		2		3		4		0		0		0		0		0		0		0		0		0		0		0		0		1		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		2		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		1		0		0		1		0		2		0		0		0		3		1		0		0		0		0		0		0		2		0		0		4		0		0		5		0		1		0		0		0		1		0		0		2		0		1		0		0		0		0		0		0		0		7		6		0		0		1		0		0		0		0		0		0		0		0		0		1		0		0		0		2		0		0		0		0		0		3		0		1		0		0		2		0		0		0		3		0		0		0		0		4		0		5		7		0		0		0		1		1		0		6		1		0		0		8		0		0		5		0		0		0		0		0		0		0		0		4		3		0		0		0		0		0		2		0		3		0		3		0		0		5		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		2		0		0		4		0		0		0
filing_date		2000-10-24 00:00:00		1999-01-28 00:00:00		1995-07-26 00:00:00		1999-04-26 00:00:00		1998-04-28 00:00:00		1997-10-17 00:00:00		1996-01-23 00:00:00		1997-04-24 00:00:00		1999-10-25 00:00:00		1998-01-30 00:00:00		1996-07-29 00:00:00		1995-04-26 00:00:00		1996-10-28 00:00:00		1998-10-26 00:00:00		1996-01-23 00:00:00		1996-04-25 00:00:00		1995-12-15 00:00:00		1995-09-25 00:00:00		1996-07-29 00:00:00		1999-11-19 00:00:00		1998-09-16 00:00:00		1995-09-25 00:00:00		1996-01-23 00:00:00		1995-06-09 00:00:00		1997-01-30 00:00:00		1996-01-23 00:00:00		1996-02-13 00:00:00		1996-01-23 00:00:00		1996-02-13 00:00:00		1996-05-07 00:00:00		1999-06-22 00:00:00		1996-01-23 00:00:00		1996-01-23 00:00:00		1996-02-13 00:00:00		1997-07-24 00:00:00		1995-10-25 00:00:00		1998-07-17 00:00:00		1999-07-28 00:00:00		2000-04-29 00:00:00		2000-01-06 00:00:00		2000-01-25 00:00:00		2000-01-13 00:00:00		2000-04-28 00:00:00		2000-08-01 00:00:00		2000-07-21 00:00:00		2001-01-23 00:00:00		2001-02-05 00:00:00		2001-02-05 00:00:00		2000-10-25 00:00:00		2001-01-16 00:00:00		2000-12-21 00:00:00		2001-01-18 00:00:00		2001-01-24 00:00:00		2001-01-23 00:00:00		2001-06-04 00:00:00		2001-07-03 00:00:00		2001-04-25 00:00:00		1998-04-28 00:00:00		2001-02-07 00:00:00		2001-04-25 00:00:00		2001-08-06 00:00:00		2001-07-25 00:00:00		2001-09-27 00:00:00		2001-10-30 00:00:00		2002-01-27 00:00:00		2002-02-14 00:00:00		2002-01-24 00:00:00		2001-10-30 00:00:00		2002-04-28 00:00:00		2002-04-30 00:00:00		2002-04-29 00:00:00		2002-04-30 00:00:00		2002-04-30 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-07-08 00:00:00		2002-10-28 00:00:00		2002-07-30 00:00:00		2002-07-30 00:00:00		2002-10-30 00:00:00		2003-04-01 00:00:00		2003-04-01 00:00:00		2003-01-10 00:00:00		2002-12-19 00:00:00		2003-01-01 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-12 00:00:00		2003-03-12 00:00:00		2003-01-31 00:00:00		2003-04-30 00:00:00		2003-04-28 00:00:00		2003-09-16 00:00:00		2003-07-29 00:00:00		2003-07-30 00:00:00		2003-10-30 00:00:00		2003-12-04 00:00:00		2004-01-28 00:00:00		2004-01-28 00:00:00		2004-03-23 00:00:00		2004-03-23 00:00:00		2003-10-31 00:00:00		2004-04-28 00:00:00		2004-04-13 00:00:00		2004-02-24 00:00:00		2004-04-04 00:00:00		2004-07-27 00:00:00		2004-03-26 00:00:00		2004-04-28 00:00:00		2004-07-27 00:00:00		2004-06-14 00:00:00		2004-10-19 00:00:00		2004-10-27 00:00:00		2004-08-26 00:00:00		2004-08-26 00:00:00		2004-08-23 00:00:00		2005-01-17 00:00:00		2004-12-22 00:00:00		2004-12-29 00:00:00		2004-10-26 00:00:00		2005-01-26 00:00:00		2005-01-29 00:00:00		2005-01-26 00:00:00		2005-07-29 00:00:00		2005-04-30 00:00:00		2005-10-27 00:00:00		2006-04-27 00:00:00		2006-03-02 00:00:00		2006-03-02 00:00:00		2006-01-31 00:00:00		2006-03-02 00:00:00		2006-07-28 00:00:00		2006-08-07 00:00:00		2006-08-04 00:00:00		2003-02-13 00:00:00		2006-08-04 00:00:00		2006-12-20 00:00:00		2006-11-02 00:00:00		2006-11-17 00:00:00		2006-11-02 00:00:00		2006-10-30 00:00:00		2007-04-23 00:00:00		2007-01-19 00:00:00		2006-12-20 00:00:00		2007-01-09 00:00:00		2007-01-09 00:00:00		2007-01-26 00:00:00		2007-03-05 00:00:00		2007-07-25 00:00:00		2007-03-06 00:00:00		2007-04-30 00:00:00		2007-04-25 00:00:00		2007-08-30 00:00:00		2007-10-29 00:00:00		2007-12-17 00:00:00		2008-01-08 00:00:00		2013-07-31 00:00:00		2013-08-07 00:00:00		2013-08-08 00:00:00		2015-02-24 00:00:00		2015-07-30 00:00:00		2015-05-01 00:00:00		2013-10-30 00:00:00		2013-09-24 00:00:00		2013-09-24 00:00:00		2015-01-13 00:00:00		2015-02-24 00:00:00		2014-10-29 00:00:00		2008-04-25 00:00:00		2007-08-30 00:00:00		2008-01-31 00:00:00		2008-07-31 00:00:00		2008-08-26 00:00:00		2008-08-21 00:00:00		2008-08-25 00:00:00		2008-08-21 00:00:00		2008-10-30 00:00:00		2008-08-21 00:00:00		2008-10-31 00:00:00		2008-12-11 00:00:00		2009-02-02 00:00:00		2009-04-29 00:00:00		2009-07-30 00:00:00		2009-04-30 00:00:00		2009-04-30 00:00:00		2008-12-12 00:00:00		2009-10-21 00:00:00		2010-01-14 00:00:00		2010-01-13 00:00:00		2010-02-01 00:00:00		2010-04-26 00:00:00		2010-01-28 00:00:00		2010-08-11 00:00:00		2010-08-11 00:00:00		2010-07-29 00:00:00		2010-10-29 00:00:00		2010-11-05 00:00:00		2011-01-27 00:00:00		2010-11-05 00:00:00		2010-12-22 00:00:00		2011-02-14 00:00:00		2010-12-20 00:00:00		2011-04-25 00:00:00		2011-09-16 00:00:00		2011-10-28 00:00:00		2011-02-15 00:00:00		2011-07-27 00:00:00		2012-01-05 00:00:00		2012-01-31 00:00:00		2012-01-05 00:00:00		2012-01-12 00:00:00		2011-09-15 00:00:00		2012-01-11 00:00:00		2012-02-23 00:00:00		2012-02-15 00:00:00		2012-04-13 00:00:00		2012-04-17 00:00:00		2012-04-27 00:00:00		2012-02-16 00:00:00		2012-07-31 00:00:00		2012-07-31 00:00:00		2012-07-31 00:00:00		2012-02-27 00:00:00		2012-07-31 00:00:00		2015-01-13 00:00:00		2015-01-30 00:00:00		2012-11-19 00:00:00		2012-12-20 00:00:00		2012-10-31 00:00:00		2014-08-28 00:00:00		2014-07-29 00:00:00		2014-08-28 00:00:00		2012-12-27 00:00:00		2012-11-20 00:00:00		2014-04-30 00:00:00		2014-04-15 00:00:00		2014-04-24 00:00:00		2014-01-30 00:00:00		2014-04-23 00:00:00		2014-04-16 00:00:00		2013-04-30 00:00:00		2013-01-30 00:00:00		2015-10-28 00:00:00		2015-04-30 00:00:00		2015-10-06 00:00:00		2015-08-07 00:00:00		2015-08-07 00:00:00		2015-10-05 00:00:00		2018-01-31 00:00:00		2017-11-21 00:00:00		2018-07-31 00:00:00		2018-10-31 00:00:00		2018-07-06 00:00:00		2018-04-30 00:00:00		2018-07-06 00:00:00		2016-01-27 00:00:00		2016-04-29 00:00:00		2016-05-31 00:00:00		2016-06-01 00:00:00		2016-07-29 00:00:00		2016-10-31 00:00:00		2017-01-31 00:00:00		2017-01-13 00:00:00		2017-04-27 00:00:00		2017-04-27 00:00:00		2017-01-13 00:00:00		2017-07-27 00:00:00		2017-04-27 00:00:00		2017-10-25 00:00:00		2017-11-21 00:00:00		2017-10-26 00:00:00		2018-04-11 00:00:00		2018-04-13 00:00:00		2019-01-31 00:00:00		2017-10-25 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		10005		10005		10005		10005		10001		10005		10005		10002		10002		10005		10005		10005		10005		10001		10001		10005		10005		10001		10006		10006		10005		10001		10005		10005		10001		10001		10005		10005		10005		10002		10005		10001		10005		10005		10005		10005		10005		10005		10005		10001		10001		10005		10005		10005		10005		10001		10005		10005		10002		10006		10001		10005		10001		10006		10005		10001		10001		10005		10001		10005		10002		10005		10005		10001		10005		10005		10002		10001		10005		10005		10005		10005		10005		10001		10005		10005		10005		10002		10001		10005		10005		10005		10001		10006		10001		10001		10001		10001		10005		10005		10001		10005		10001		10002		10005		10005		10002		10001		10002		10001		10005		10001		10002		10002		10005		10005		10006		10001		10005		10001		10002		10001		10005		10002		10001		10005		10002		10001		10002		10005		10006		10001		10002		10001		10006		10002		10005		10002		10001		10001		10005		10001		10001		10005		10005		10002		10002		10001		10005		10002		10001		10001		10001		10001		10001		10005		10005		10001		10006		10002		10005		10001		10001		10002		10006		10001		10001		10006		10001		10002		10005		10002		10001		10001		10002		10001		10006		10001		10002		10001		10006		10006		10006		10002		10006		10002		10002		10006		10001		10006		10002		10002		10001		10002		10002		10001		10001		10002		10001		10001		10002		10001		10005		10005		10006		10001		10005		10006		10001		10002		10002		10001		10001		10001		10001		10006		10002		10006		10002		10001		10002		10001		10001		10002		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10002		10005		10001		10006		10002		10006		10001		10002		10006		10001		10005
stmnt_status		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		11001		11003		11001		11003		11001		11003		11001		11001		11003		11003		11003		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11003		11001		11003		11003		11003		11001		11003		11003		11003		11001		11001		11003		11001		11001		11003		11003		11001		11003		11003		11001		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		1999		1997		1995		1999		1997		1997		1995		1997		1999		1997		1995		1995		1995		1997		1995		1995		1995		1995		1995		1999		1997		1995		1995		1995		1995		1995		1995		1995		1995		1995		1997		1995		1995		1995		1997		1995		1997		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		1999		2001		2001		2001		2001		1999		2001		2001		2001		1997		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2001		2003		2003		2001		2001		2003		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2003		2005		2007		2005		2005		2005		2005		2007		2007		2007		2007		2007		2005		2007		2007		2007		2007		2007		2007		2007		2007		2007		2013		2013		2013		2015		2015		2015		2013		2013		2013		2015		2015		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2015		2013		2011		2013		2011		2013		2013		2013		2013		2011		2013		2013		2013		2013		2013		2013		2013		2011		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2017		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017
user_id		DHULSE		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		DHULSE		DMCCASTL		CFLAGG		*		TTHAM		DHULSE		TTHAM		MKIENG		*		*		DHORRELL		NJACKSON		GPEREZ		NJACKSON		*		*		SARRIAGA		GPEREZ		*		TWALLS		CFLAGG		DHORRELL		DHORRELL		GPEREZ		GPEREZ		*		*		SARRIAGA		YBONILLA		YBONILLA		*		CFLAGG		*		YBONILLA		YBONILLA		CFLAGG		CFLAGG		SARRIAGA		YBONILLA		YBONILLA		*		*		CFLAGG		CFLAGG		GPEREZ		GPEREZ		COMPLETED		YBONILLA		GPEREZ		COMPLETED		YBONILLA		COMPLETED		YBONILLA		COMPLETED		YBONILLA		KVANG		COMPLETED		COMPLETED		GPEREZ		COMPLETED		EMCENTEE		COMPLETED		SARRIAGA		YBONILLA		COMPLETED		SARRIAGA		GPEREZ		COMPLETED		COMPLETED		SARRIAGA		EMCENTEE		EMCENTEE		SARRIAGA		SARRIAGA		COMPLETED		CFLAGG		CFLAGG		CFLAGG		COMPLETED		COMPLETED		CFLAGG		YRODRIGU		YRODRIGU		COMPLETED		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		SARRIAGA		SARRIAGA		LTHIBAUL		SARRIAGA		YRODRIGU		*		SARRIAGA		SARRIAGA		LTHIBAUL		*		*		*		CFLAGG		JMARTIN		*		*		CFLAGG		CFLAGG		CFLAGG		YRODRIGU		CFLAGG		LTHIBAUL		*		YRODRIGU		CFLAGG		*		LTHIBAUL		GPEREZ		*		ASAETERN		YRODRIGU		SARRIAGA		YRODRIGU		AGLADNEY		AGLADNEY		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		LTHIBAUL		GPEREZ		LTHIBAUL		YRODRIGU		LTHIBAUL		LTHIBAUL		*		*		YRODRIGU		LTHIBAUL		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		CFLAGG		SARRIAGA		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		MGUERRA		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		ASAETERN		YRODRIGU		ASAETERN		YRODRIGU		CFLAGG		PBANFORD		YRODRIGU		ASAETERN		YRODRIGU		ASAETERN		PBANFORD		ASAETERN		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		AGLADNEY		YRODRIGU		AGLADNEY		SMCCONNAN		SARRIAGA		JINGRAM		YRODRIGU		ASAETERN		SARRIAGA		SARRIAGA		SMCCONNAN		ASAETERN		SARRIAGA		SMCCONNAN		ASAETERN		YRODRIGU		SARRIAGA		ASAETERN		ASAETERN		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		GPEREZ		AGLADNEY		GPEREZ		AGLADNEY		AGLADNEY		YRODRIGU		GPEREZ		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		AGLADNEY		YRODRIGU		YRODRIGU		AGLADNEY		YRODRIGU		GPEREZ		YRODRIGU		AGLADNEY		YRODRIGU		YRODRIGU		AGLADNEY		GPEREZ
special_audit		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11003		11003		11003		11003		11002		11003		11003		11003		11003		11002		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11003
rpt_start		2000-07-01 00:00:00		1998-10-01 00:00:00		1995-04-01 00:00:00		1999-01-01 00:00:00		1998-01-01 00:00:00		1997-07-01 00:00:00		1995-10-01 00:00:00		1997-01-01 00:00:00		1999-07-01 00:00:00		1997-10-01 00:00:00		1996-04-01 00:00:00		1995-01-01 00:00:00		1996-07-01 00:00:00		1998-07-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		1995-07-01 00:00:00		1995-04-01 00:00:00		1996-01-01 00:00:00		1999-04-01 00:00:00		1998-04-01 00:00:00		1995-01-01 00:00:00		1995-04-01 00:00:00		1995-01-01 00:00:00		1996-10-01 00:00:00		1995-01-01 00:00:00		1995-01-01 00:00:00		1995-04-01 00:00:00		1995-10-01 00:00:00		1996-01-01 00:00:00		1998-10-01 00:00:00		1995-07-01 00:00:00		1995-01-01 00:00:00		1995-04-01 00:00:00		1997-04-01 00:00:00		1995-07-01 00:00:00		1998-04-01 00:00:00		1999-04-01 00:00:00		2000-01-01 00:00:00		None		1999-10-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-10-01 00:00:00		2001-01-04 00:00:00		2001-01-04 00:00:00		2000-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2001-01-04 00:00:00		2000-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		1997-10-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		1900-01-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		1900-01-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		1900-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-07-01 00:00:00		2002-04-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-12-19 00:00:00		2002-10-01 00:00:00		1900-01-01 00:00:00		2002-12-19 00:00:00		2002-01-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2002-04-01 00:00:00		2003-04-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		1900-01-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2004-03-23 00:00:00		1900-01-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-04-04 00:00:00		2004-04-01 00:00:00		1900-01-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-07-01 00:00:00		2004-12-17 00:00:00		None		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2005-04-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2005-10-01 00:00:00		1900-01-01 00:00:00		2006-04-01 00:00:00		2006-08-03 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2005-10-01 00:00:00		2006-11-01 00:00:00		2006-11-01 00:00:00		2006-11-01 00:00:00		1900-01-01 00:00:00		2006-07-01 00:00:00		2006-11-01 00:00:00		2006-11-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2006-10-01 00:00:00		1900-01-01 00:00:00		2007-04-01 00:00:00		2006-11-01 00:00:00		2007-01-01 00:00:00		1900-01-01 00:00:00		2007-08-22 00:00:00		2007-07-01 00:00:00		1900-01-01 00:00:00		2007-12-13 00:00:00		2013-04-01 00:00:00		2013-06-18 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		2013-09-21 00:00:00		1900-01-01 00:00:00		2014-11-07 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		1900-01-01 00:00:00		2007-10-01 00:00:00		2008-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-08-22 00:00:00		2008-08-19 00:00:00		2008-07-01 00:00:00		1900-01-01 00:00:00		2008-07-01 00:00:00		2009-01-01 00:00:00		2008-10-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-07-01 00:00:00		1900-01-01 00:00:00		2010-01-05 00:00:00		1900-01-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2010-08-03 00:00:00		1900-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		1900-01-01 00:00:00		2011-02-14 00:00:00		2010-11-04 00:00:00		2011-01-01 00:00:00		2011-09-09 00:00:00		2011-07-01 00:00:00		1900-01-01 00:00:00		2011-04-01 00:00:00		2012-01-05 00:00:00		2011-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-01-09 00:00:00		1900-01-01 00:00:00		2012-02-02 00:00:00		2012-04-11 00:00:00		1900-01-01 00:00:00		2012-01-01 00:00:00		1900-01-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-04-01 00:00:00		2012-02-19 00:00:00		2012-01-01 00:00:00		2014-11-07 00:00:00		2014-10-01 00:00:00		2012-11-07 00:00:00		2012-11-14 00:00:00		2012-07-01 00:00:00		2014-08-22 00:00:00		2014-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-10-01 00:00:00		2014-04-17 00:00:00		2014-04-11 00:00:00		2013-01-01 00:00:00		2012-10-01 00:00:00		2015-07-01 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		2015-07-30 00:00:00		1900-01-01 00:00:00		2015-09-25 00:00:00		2017-10-01 00:00:00		2017-11-02 00:00:00		2018-04-01 00:00:00		2018-07-01 00:00:00		2018-06-22 00:00:00		2018-01-01 00:00:00		1900-01-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-05-10 00:00:00		1900-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2016-11-08 00:00:00		2017-01-01 00:00:00		2017-04-11 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		1900-01-01 00:00:00		2017-10-20 00:00:00		1900-01-01 00:00:00		2017-07-01 00:00:00		2018-04-09 00:00:00		1900-01-01 00:00:00		2018-10-01 00:00:00		1900-01-01 00:00:00
rpt_end		2000-09-30 00:00:00		1998-12-31 00:00:00		1995-06-30 00:00:00		1999-03-31 00:00:00		1998-03-31 00:00:00		1997-09-30 00:00:00		1995-12-31 00:00:00		1997-03-31 00:00:00		1999-09-30 00:00:00		1997-12-31 00:00:00		1996-06-30 00:00:00		1995-03-31 00:00:00		1996-09-30 00:00:00		1998-09-30 00:00:00		1995-09-30 00:00:00		1996-03-31 00:00:00		1995-09-30 00:00:00		1995-06-30 00:00:00		1996-03-31 00:00:00		1999-06-30 00:00:00		1998-06-30 00:00:00		1995-03-31 00:00:00		1995-06-30 00:00:00		1995-03-31 00:00:00		1996-12-31 00:00:00		1995-03-31 00:00:00		1995-03-31 00:00:00		1995-06-30 00:00:00		1995-12-31 00:00:00		1996-03-31 00:00:00		1998-12-31 00:00:00		1995-09-30 00:00:00		1995-03-31 00:00:00		1995-06-30 00:00:00		1997-06-30 00:00:00		1995-09-30 00:00:00		1998-06-30 00:00:00		1999-06-30 00:00:00		2000-03-31 00:00:00		None		1999-12-31 00:00:00		1999-12-31 00:00:00		2000-03-31 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2001-01-04 00:00:00		2001-01-04 00:00:00		2000-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2001-01-04 00:00:00		2000-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		1997-12-31 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		1900-01-01 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		1900-01-01 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		1900-01-01 00:00:00		2002-03-31 00:00:00		2002-03-31 00:00:00		2001-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-09-30 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-12-19 00:00:00		2002-12-31 00:00:00		1900-01-01 00:00:00		2002-12-19 00:00:00		2002-03-31 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-03-31 00:00:00		2002-06-30 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		1900-01-01 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-03-23 00:00:00		1900-01-01 00:00:00		2003-09-30 00:00:00		2004-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-04-04 00:00:00		2004-06-30 00:00:00		1900-01-01 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-09-30 00:00:00		2004-12-17 00:00:00		None		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2005-06-30 00:00:00		2005-03-31 00:00:00		2005-09-30 00:00:00		2006-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2005-12-31 00:00:00		1900-01-01 00:00:00		2006-06-30 00:00:00		2006-08-03 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2005-12-31 00:00:00		2006-11-01 00:00:00		2006-11-01 00:00:00		2006-11-01 00:00:00		1900-01-01 00:00:00		2006-09-30 00:00:00		2006-11-01 00:00:00		2006-11-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2006-12-31 00:00:00		1900-01-01 00:00:00		2007-06-30 00:00:00		2006-11-01 00:00:00		2007-03-31 00:00:00		1900-01-01 00:00:00		2007-08-22 00:00:00		2007-09-30 00:00:00		1900-01-01 00:00:00		2007-12-13 00:00:00		2013-06-30 00:00:00		2013-06-18 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		2013-09-21 00:00:00		1900-01-01 00:00:00		2014-11-07 00:00:00		2014-09-30 00:00:00		2008-03-31 00:00:00		1900-01-01 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-08-22 00:00:00		2008-08-19 00:00:00		2008-09-30 00:00:00		1900-01-01 00:00:00		2008-09-30 00:00:00		2009-01-01 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-09-30 00:00:00		1900-01-01 00:00:00		2010-01-05 00:00:00		1900-01-01 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		2010-08-03 00:00:00		1900-01-01 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2010-10-01 00:00:00		1900-01-01 00:00:00		2011-02-14 00:00:00		2010-11-04 00:00:00		2011-03-31 00:00:00		2011-09-09 00:00:00		2011-09-30 00:00:00		1900-01-01 00:00:00		2011-06-30 00:00:00		2012-01-05 00:00:00		2011-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-01-09 00:00:00		1900-01-01 00:00:00		2012-02-02 00:00:00		2012-04-11 00:00:00		1900-01-01 00:00:00		2012-03-31 00:00:00		1900-01-01 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2012-02-19 00:00:00		2012-03-31 00:00:00		2014-11-07 00:00:00		2014-12-31 00:00:00		2012-11-07 00:00:00		2012-11-14 00:00:00		2012-09-30 00:00:00		2014-08-22 00:00:00		2014-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-12-31 00:00:00		2014-04-17 00:00:00		2014-04-11 00:00:00		2013-03-31 00:00:00		2012-12-31 00:00:00		2015-09-30 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		2015-07-30 00:00:00		1900-01-01 00:00:00		2015-09-25 00:00:00		2017-12-31 00:00:00		2017-11-02 00:00:00		2018-06-30 00:00:00		2018-09-30 00:00:00		2018-06-22 00:00:00		2018-03-31 00:00:00		1900-01-01 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-05-10 00:00:00		1900-01-01 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2016-11-08 00:00:00		2017-03-31 00:00:00		2017-04-11 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		1900-01-01 00:00:00		2017-10-20 00:00:00		1900-01-01 00:00:00		2017-09-30 00:00:00		2018-04-09 00:00:00		1900-01-01 00:00:00		2018-12-31 00:00:00		1900-01-01 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		22001		None		22001		None		22001		None		None		22001		22001		None		22001		None		22001		None		None		22001		None		None		22001		22001		None		None		None		None		None		22001		None		None		None		22001		22001		None		None		None		22001		None		22001		22001		22001		22001		None		None		22001		None		22001		22001		None		None		22001		22001		22001		22001		None		22001		22001		22001		None		None		None		22001		None		22001		22001		22001		None		22001		22001		None		22001		22001		22001		None		None		22001		22001		22001		None		22001		None		22001		22001		22001		None		22001		22001		None		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		None		22001		None		22001		None		22001		22001		22001		None		22001		22001		None		22001		22001		None		22001		22001		22001		22001		22001		None		22001		22001		22001		None		None		None		22001		None		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		None		22001		None		None		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		None		22001		None		22001		22001		None		22001		None

Table: filer_to_filer_type

filer_id		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273
filer_type		3		3		3		3		3		3		3		3		3		3		3		3		3
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		0		None		None		None		None		None		None		None		None		None
session_id		1997		1995		1999		2001		2003		2005		2007		2011		2013		2009		2015		2017		2019
category		0		0		0		0		None		None		None		None		None		None		None		None		None
category_type		0		0		0		0		None		None		None		None		None		None		None		None		None
sub_category		0		0		0		0		None		None		None		None		None		None		None		None		None
effect_dt		1997-01-01 00:00:00		1994-12-05 00:00:00		1999-01-01 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00
sub_category_type		0		0		0		0		None		None		None		None		None		None		None		None		None
election_type		0		0		0		0		None		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		2000-01-01 00:00:00		2000-01-01 00:00:00		None		None		None		None		None		None
party_cd		None		None		0		0		None		None		None		None		None		None		None		None		None
county_cd		None		None		0		0		None		None		None		None		None		None		None		None		None
district_cd		None		None		0		0		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1147273
xref_id		F00696
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696		F00696
filer_id		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273
filer_type		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00
naml		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
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		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		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		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		958146518		958146518		958146518		958146518		95811		95811		95811		95811		95811		95811		958146518		958146518		958146518		958146518		95811		95811		95811		95811		95811		95811		958146518		958146518		958146518		958146518		95811		95811		95811		95811		95811		95811		958146518		958146518		958146518		958146518		95811		95811		95811		95811		95811		95811		958146518		958146518		958146518		958146518		95811		95811		95811		95811		95811		95811		958146518		958146518		958146518		958146518		95811		95811		95811		95811		95811		95811		958146518		958146518		958146518		958146518		95811		95811		95811		95811		95811		95811		958146518		958146518		958146518		958146518		95811		95811		95811		95811		95811		95811		958146518		958146518		958146518		958146518		95811		95811		95811		95811		95811		95811		958146518		958146518		958146518		958146518		95811		95811		95811		95811		95811		95811
phon		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161
fax		9164436719						9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719						9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719						9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719						9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719						9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719						9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719						9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719						9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719						9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719						9164436719		9164436719		9164436719		9164436719		9164436719		9164436719		9164436719
email		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None

Table: filers

filer_id		1147273

Table: lobbying_chg_log

filer_id		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273
change_no		2		1		3		4		10		5		12		13		16		17		18		19		0		14		15		25		21		20		22		23		24		26		27		29		28		30		31		32		38		37		36		34		33		35		40		39		41		42		43		46		44		45		47		48		50		49
session_id		1999		1999		1999		1999		2001		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2007		2007		2007		2007		2009		2009		2009		2011		2011		2011		2011		2011		2011		2013		2013		2013		2015		2015		2017		2017		2017		2017		2017		2017		2017
log_dt		2000-07-20 00:00:00		2000-07-07 00:00:00		2000-10-16 00:00:00		2001-04-12 00:00:00		2001-06-14 00:00:00		2001-06-04 00:00:00		2001-07-03 00:00:00		2001-07-03 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-07-08 00:00:00		2001-09-27 00:00:00		2002-02-14 00:00:00		2004-08-23 00:00:00		2003-04-01 00:00:00		2003-04-01 00:00:00		2004-01-28 00:00:00		2004-02-24 00:00:00		2004-02-24 00:00:00		2007-03-05 00:00:00		2007-08-30 00:00:00		2008-08-21 00:00:00		2007-12-17 00:00:00		2010-01-14 00:00:00		2010-08-11 00:00:00		2010-11-05 00:00:00		2012-04-17 00:00:00		2012-02-23 00:00:00		2012-02-16 00:00:00		2012-01-05 00:00:00		2011-09-15 00:00:00		2012-01-12 00:00:00		2013-08-03 00:00:00		2013-09-24 00:00:00		2013-08-08 00:00:00		2015-02-24 00:00:00		2015-08-07 00:00:00		2017-10-25 00:00:00		2017-04-27 00:00:00		2017-04-27 00:00:00		2017-11-21 00:00:00		2017-11-21 00:00:00		2018-07-06 00:00:00		2018-04-13 00:00:00
filer_type		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3
correction_flg		None		Y		Y		None		None		Y		None		None		Y		Y		Y		Y		None		Y		Y		None		Y		Y		None		None		None		Y		Y		Y		Y		Y		Y		Y		None		Y		Y		Y		Y		Y		Y		None		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y
action		CHANGED		DELETED		NEW		CHANGED		CHANGED		ADDED		CHANGED		CHANGED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		ADDED		NEW		NEW		DELETED		DELETED		DELETED		DELETED		IN SUSPENSE		SET ACTIVE		DELETED		ADDED		ADDED		ADDED		ADDED		DELETED		ADDED		DELETED		ADDED		DELETED		DELETED		ADDED		ADDED		DELETED		ADDED		ADDED		ADDED		DELETED		ADDED		DELETED		ADDED		ADDED		ADDED		DELETED		DELETED
attribute_changed		ADDRESS AND PHONE		CLIENT		EMPLOYER		ADDRESS		ADDRESS		EMPLOYER		None		None		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		FIRM		EMPLOYER		EMPLOYER		CLIENT		None		None		FIRM		CLIENT		CLIENT		None		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		CLIENT		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		CLIENT		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER
ethics_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
interests		None		None		40306		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_full_name		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL		ADVOCAL
filer_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SACRAMENTO		None		None		None		None		None		None		None		SACRAMENTO		None		SACRAMENTO		None		None		None		None		None		None		None		None		None		SACRAMENTO		None		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		SACRAMENTO
filer_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		CA		None		CA		None		None		None		None		None		None		None		None		None		CA		None		CA		None		CA		CA		CA		CA		CA		CA		None		CA
filer_zip		None		None		None		None		None		None		None		None		None		None		None		None		None		None		958146518		None		None		None		None		None		None		None		958146518		None		958146518		None		None		None		None		None		None		None		None		None		958146518		None		958146518		None		958146518		958146518		958146518		958146518		958146518		958146518		None		958146518
filer_phone		None		None		None		None		None		None		None		None		None		None		None		None		None		None		9164466161		None		None		None		None		None		None		None		9164466161		None		9164466161		None		None		None		None		None		None		None		None		None		9164466161		None		9164466161		None		9164466161		9164466161		9164466161		9164466161		9164466161		9164466161		None		9164466161
entity_type		1		1		2		1		1		2		1		1		2		2		2		2		3		2		2		1		2		2		3		1		1		2		2		2		2		2		2		2		1		2		2		2		2		2		2		1		2		2		2		2		2		2		2		2		2		2
entity_name		CALIFORNIA ASSOCIATION OF LICENSED REPOSSESSORS		CALIFORNIA PREMIUM FINANCE ASSOCIATION		S & B SURGERY CENTER		ASSOCIATION OF CALIFORNIA CARTRIDGE REMANUFACTURERS		AMERICAN BOARD OF ELECTROENCEPHALOGRAPHY AND NEUROPHYSIOLOGY, INC.		AMERICAN BOARD OF ELECTROENCEPHALOGRAPHY AND NEUROPHYSIOLOGY, INC.		COALITION OF CALIFORNIA HOME INSPECTORS		COALITION OF CALIFORNIA HOME INSPECTORS		AMERICAN BOARD OF ELECTROENCEPHALOGRAPHY AND NEUROPHYSIOLOGY, INC.		CALIFORNIA ASSOCIATION OF INTERLOCK SERVICE PROVIDERS		MORROW INSTITUTE DBA THE MORROW SKIN INSTITUTE, A MEDICAL GROUP		WYNN OIL COMPANY		MURPHY JR., FRANK		COMPREHENSIVE OUTPATIENT SURGERY CENTER		VISIONQUEST INDUSTRIES, INC., DBA VQ ORTHOCARE		MONTLAKE HOLDINGS, LLC		S & B SURGERY CENTER		COMPREHENSIVE OUTPATIENT SURGERY CENTER		PLOTKIN GOVERNMENT RELATIONS		WORK INJURY NETWORK		WORK INJURY NETWORK		Z-A MANAGEMENT		INDEPENDENT AUTOMOBILE DEALERS ASSOCIATION OF CALIFORNIA		NICCO AND CHARLES RICHARDSON; DAVID		GOLDEN STATE FEED AND GRAIN SAFETY ASSOCIATION		RACE PLATE MARKETING LLC		ALZHEIMER'S FOUNDATION OF AMERICA		CALIFORNIA REAL ESTATE INSPECTION ASSOCIATION		CALIFORNIA SOCIETY OF INTERVENTIONAL PAIN PHYSICIANS		CALIFORNIA PROFESSIONAL COPY SERVICE ASSOCIATION, INC.		COALITION OF CALIFORNIA HOME INSPECTORS		CALIFORNIA ASSOCIATION OF LICENSED REPOSSESSORS		CALIFORNIA SOCIETY OF INTERVENTIONAL PAIN PHYSICIANS		CALIFORNIA CHAPTER, INTERNATIONAL ASSOCIATION OF REHABILITATION PROFESSIONALS		CALIFORNIA EQUINE INDUSTRY COUNCIL		CALIFORNIA WORKERS' COMPENSATION INTERPRETERS ASSOCIATION		CALIFORNIA ALLIANCE OF RESALE MERCHANTS AND COLLECTORS		COUNCIL FOR THE ECONOMIC DEVELOPMENT OF SINALOA, MEXICO		CALIFORNIA REAL ESTATE INSPECTION ASSOCIATION, INC.		SBG FINANCE, LLC		CALIFORNIA CHAPTER, INTERNATIONAL ASSOCIATION OF REHABILITATION PROFESSIONALS		CALIFORNIA CHAPTER, INTERNATIONAL ASSOCIATION OF REHABILITATION PROFESSIONALS		INDEPENDENT PHYSICAL THERAPISTS OF CALIFORNIA		NATIONAL ROOF CERTIFICATION AND INSPECTION ASSOCIATION		CALIFORNIA SOCIETY OF INDUSTRIAL MEDICINE & SURGERY		SBG FINANCE, LLC
entity_city		FRESNO		None		BEVERLY HILLS		IRVINE		LAS VEGAS		None		PALM SPRINGS		SAN DIEGO		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_st		CA		None		CA		CA		NV		None		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_zip		93722		None		90212		926122621		89102		None		92262		921164039		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_phone		9164465165		None		3103857755		9492258233		7023884244		None		9164465165		6194913031		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_id		1143173		1146225		1228976		1146245		1235509		1235509		1144630		1144630		1235509		1145449		1146410		1231611		1147289		1238519		None		1264369		1228976		1238519		1236171		1263324		1263324		1288521		None		1310162		None		1323594		1292669		1144377		1341692		1345170		1144630		1143173		1341692		1343927		None		1360857		None		1366056		None		None		None		None		None		None		1143115		None
responsible_officer		None		None		CHIEF EXECUTIVE OFFICER RANDY S. ROSEN, M.D.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		None		None		2000-10-05 00:00:00		None		None		2001-06-01 00:00:00		None		None		2002-06-28 00:00:00		2002-06-28 00:00:00		2002-06-28 00:00:00		2002-06-28 00:00:00		2002-07-01 00:00:00		2001-09-26 00:00:00		2002-02-15 00:00:00		2004-08-23 00:00:00		2003-03-31 00:00:00		2003-03-31 00:00:00		2004-01-20 00:00:00		2004-01-16 00:00:00		2004-01-16 00:00:00		2007-02-28 00:00:00		2007-10-01 00:00:00		2008-08-19 00:00:00		2008-01-01 00:00:00		2010-01-04 00:00:00		2010-04-30 00:00:00		2010-10-01 00:00:00		2012-03-31 00:00:00		2012-01-01 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2011-08-26 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2013-09-21 00:00:00		2013-07-01 00:00:00		2015-02-01 00:00:00		2015-07-23 00:00:00		2017-10-23 00:00:00		2017-04-11 00:00:00		2017-04-11 00:00:00		2017-10-01 00:00:00		2017-10-01 00:00:00		2018-06-30 00:00:00		2018-03-31 00:00:00

Table: lobbyist_contributions1

filer_id		1147273		1147273		1147273
filing_period_start_dt		2000-01-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00
filing_period_end_dt		2000-03-31 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00
contribution_dt		None		None		None
recipient_name		RE-ELECT AUDIE BOCK (IN-KIND CONTRIBUTION - TELEPHONE)		BOCK, AUDIE		BOCK, AUDIE
recipient_id		1219352		1219352		1219352
amount		52		14		150

Table: lobbyist_contributions2

filer_id		1147273		1147273		1147273
filing_period_start_dt		2000-01-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00
filing_period_end_dt		2000-03-31 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00
contribution_dt		None		None		None
recipient_name		RE-ELECT AUDIE BOCK (IN-KIND CONTRIBUTION - TELEPHONE)		BOCK, AUDIE		BOCK, AUDIE
recipient_id		1219352		1219352		1219352
amount		52		14		150

Table: received_filings

filer_id		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273		1147273
filing_file_name		624003_0.cal		13011.cal		645288_0.cal		674751_0.cal		713279_0.cal		713728_0.cal		713728_1.cal		713728_2.cal		743615_0.cal		774187_0.cal		791329_0.cal		810917_0.cal		810917_1.cal		839030_0.cal		854941_0.cal		882659_0.cal		898800_1.cal		455745.cal		455852.cal		455861.cal		456329.cal		898800_0.cal		911323_0.cal		929777_0.cal		946990_0.cal		969336_0.cal		898800_3.cal		898800_2.cal		1067574_0.cal		65105.cal		23750.cal		216855.cal		464974.cal		203985.cal		204243.cal		452552.cal		1221889_0.cal		410731.cal		271515.cal		272374.cal		271930.cal		272359.cal		272473.cal		313811.cal		162744.cal		155334.cal		155542.cal		473555.cal		134848.cal		34577.cal		34731.cal		193218.cal		169014.cal		48836.cal		48946.cal		156825.cal		2119435_1.cal		2119435_0.cal		429126.cal		2119435_3.cal		2119435_5.cal		2119435_2.cal		2119435_4.cal
received_date		2000-04-29 00:00:00		2000-08-10 00:00:00		2000-08-01 00:00:00		2000-10-24 00:00:00		2001-01-23 00:00:00		2001-01-24 00:00:00		2001-02-05 00:00:00		2001-02-05 00:00:00		2001-04-25 00:00:00		2001-08-06 00:00:00		2001-10-30 00:00:00		2002-01-27 00:00:00		2002-04-28 00:00:00		2002-04-29 00:00:00		2002-07-30 00:00:00		2002-10-30 00:00:00		2003-01-12 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-01 00:00:00		2003-01-31 00:00:00		2003-04-28 00:00:00		2003-07-30 00:00:00		2003-10-30 00:00:00		2004-04-04 00:00:00		2004-03-23 00:00:00		2004-12-22 00:00:00		2006-08-07 00:00:00		2006-08-04 00:00:00		2009-02-02 00:00:00		2010-01-13 00:00:00		2006-12-20 00:00:00		2006-12-20 00:00:00		2006-11-02 00:00:00		2006-11-17 00:00:00		2008-08-21 00:00:00		2007-01-19 00:00:00		2007-01-19 00:00:00		2007-01-19 00:00:00		2007-01-19 00:00:00		2007-01-19 00:00:00		2007-04-10 00:00:00		2009-04-30 00:00:00		2010-01-25 00:00:00		2010-01-25 00:00:00		2008-12-11 00:00:00		2010-12-20 00:00:00		2011-02-11 00:00:00		2011-02-11 00:00:00		2011-09-16 00:00:00		2013-09-24 00:00:00		2012-01-11 00:00:00		2012-01-11 00:00:00		2015-07-30 00:00:00		2017-04-27 00:00:00		2017-01-13 00:00:00		2014-08-28 00:00:00		2017-11-21 00:00:00		2018-07-06 00:00:00		2017-10-25 00:00:00		2018-04-11 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		624003		None		645288		674751		713279		713728		713728		713728		743615		774187		791329		810917		810917		839030		854941		882659		898800		None		None		None		None		898800		911323		929777		946990		969336		898800		898800		1067574		None		None		None		None		None		None		None		1221889		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2119435		2119435		None		2119435		2119435		2119435		2119435
form_id		F625		None		F625		F625		F625		F601		F601		F601		F625		F625		F625		F625		F625		F625		F625		F625		F601		None		None		None		None		F601		F625		F625		F625		F625		F601		F601		F601		None		None		None		None		None		None		None		F602		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		F601		F601		None		F601		F601		F601		F601
receive_comment		Filing accepted		Filing pass validation, but failed DB constraints		Filing accepted		Filing accepted, but but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		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, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted