Home

Filer ID: 1147218

Table: filer_address

filer_id		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218
adrid		1113071		1112224		1110922		2045594		2079115		2119551		2159352		2204720		2412388		2233956		2276551		2337838
effect_dt		1995-01-01 00:00:00		1997-01-01 00:00:00		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		2012-05-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		7051		7051
session_id		1995		1997		1999		2003		2005		2007		2009		2011		2017		2011		2013		2015

Table: filer_filings

filer_id		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218
filing_id		509531		510159		504530		505888		507930		504249		508600		509264		504878		508872		506246		509904		507534		541851		504530		504530		505530		507249		506537		506897		508206		610531		628795		658164		681088		686953		714384		715828		721366		721510		747009		749235		745469		769480		777357		788466		809599		793245		794313		815514		839269		836245		842275		840385		856276		881275		890671		854086		909731		916999		917203		917204		905759		930100		925664		933397		933401		920958		926458		933944		944922		923523		923685		934184		966157		951236		984110		988126		972134		990514		1010763		1012568		1000082		1032795		1013120		1028749		1020644		1071271		1046855		930100		1062694		1070013		1070190		1075179		1070190		1070190		1097650		1103770		1083352		1070190		1117691		1120491		1134014		1106579		1128874		1147641		1163326		1070190		1188791		1210411		1240491		1260039		1248614		1240491		1284468		1284097		1244924		1264485		1264491		1235536		1284468		1293679		1307626		1289272		1240491		1298214		1778499		1979328		1966653		1964142		1923026		1870572		1797940		1923026		1952727		1952695		1911398		1324656		1240491		1348285		1240491		1357031		1352594		1240491		1240491		1376252		1407968		1396327		1421188		1407668		1425064		1407668		1435054		1426794		1426799		1407668		1407668		1438856		1407668		1407668		1463152		1467620		1449912		1493781		1503187		1482901		1493781		1536846		1559705		1559705		1559705		1565949		1565970		1564954		1575855		1559705		1589633		1594058		1631825		1618187		1633873		1605199		1605199		1559705		1618187		1559705		1652764		1648188		1559705		1676004		1667783		1816994		1699490		1931732		1816994		1842246		1870572		1923026		1729289		1882531		1729289		1729311		1733550		1842246		1760097		1760915		1993071		2206455		2325474		2325476		2234509		2148769		2267136		2189733		2006471		2037792		2058060		2092030		2124337		2148769		2153154		2152166		2175523		2152166		2307611
period_id		155		156		149		158		145		141		146		147		157		154		143		148		152		142		149		149		150		144		151		159		153		160		161		162		163		163		164		164		None		None		165		None		165		166		None		167		168		None		None		None		169		None		None		None		None		171		None		170		None		None		None		None		172		173		None		None		None		None		None		None		174		None		None		None		175		None		176		None		None		None		177		None		None		None		None		178		None		None		179		173		None		None		180		180		182		181		None		181		None		182		182		None		173		None		183		184		185		187		186		187		190		189		None		189		190		None		None		None		None		188		190		191		192		None		190		None		214		222		None		221		222		218		215		221		None		None		219		193		192		194		195		None		None		195		196		195		None		196		197		198		None		199		198		None		None		198		198		None		197		201		200		None		199		None		202		201		None		203		205		205		205		None		None		204		None		205		205		None		208		207		None		206		206		209		207		209		209		None		210		210		None		216		211		220		216		217		218		221		219		None		212		212		212		217		None		213		223		232		None		None		233		236		234		231		224		225		226		227		228		229		None		229		230		229		235
form_id		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F690		F690		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F605		F601		F625		F605		F625		F625		F625		F625		F625		F625		F605		F625		F625		F605		F625		F605		F625		F625		F625		F625		F625		F601		F605		F605		F625		F625		F605		F605		F605		F605		F605		F625		F625		F605		F605		F605		F625		F625		F625		F625		F625		F605		F625		F605		F605		F625		F625		F625		F605		F601		F625		F625		F625		F690		F601		F625		F601		F601		F605		F625		F625		F601		F625		F605		F666		F605		F625		F625		F625		F601		F625		F625		F601		F625		F605		F601		F625		F605		F601		F605		F601		F625		F625		F625		F625		F605		F601		F605		F625		F625		F605		F625		F601		F625		F625		F601		F605		F601		F625		F625		F601		F625		F601		F605		F605		F601		F601		F625		F601		F625		F625		F601		F605		F601		F625		F605		F605		F601		F601		F605		F601		F601		F625		F605		F625		F605		F625		F625		F605		F625		F601		F601		F601		F601		F605		F625		F605		F601		F625		F605		F625		F625		F605		F625		F625		F601		F625		F601		F625		F605		F601		F625		F605		F625		F625		F625		F625		F625		F625		F601		F601		F605		F601		F602		F625		F625		F601		F625		F625		F625		F605		F606		F625		F601		F625		F625		F625		F625		F625		F625		F625		F601		F601		F625		F625		F625		F625
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		2		1		0		0		0		3		0		0		0		0		0		0		0		4		0		0		1		0		0		0		0		0		0		0		0		0		1		0		0		0		2		0		0		0		0		0		2		0		0		1		0		0		0		0		3		0		4		0		0		5		6		0		0		0		0		3		0		4		0		0		0		1		2		0		0		5		0		0		0		1		0		0		0		0		0		2		1		0		0		0		0		3		0		0		0		1		0		0		1		4		0		5		0		0		6		0		0		0		0		0		1		1		1		0		1		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		1		0
filing_date		1998-10-29 00:00:00		1999-01-27 00:00:00		1997-04-30 00:00:00		1999-07-15 00:00:00		1996-07-03 00:00:00		1995-05-01 00:00:00		1996-07-12 00:00:00		1996-10-22 00:00:00		1999-04-26 00:00:00		1998-07-29 00:00:00		1995-10-31 00:00:00		1997-01-30 00:00:00		1998-01-30 00:00:00		1995-07-31 00:00:00		1997-08-18 00:00:00		1997-06-12 00:00:00		1997-07-25 00:00:00		1996-01-26 00:00:00		1997-10-29 00:00:00		1999-10-20 00:00:00		1998-04-29 00:00:00		2000-01-27 00:00:00		2000-04-19 00:00:00		2000-07-31 00:00:00		2000-10-30 00:00:00		2000-10-30 00:00:00		2001-01-25 00:00:00		2001-01-26 00:00:00		2001-02-06 00:00:00		2001-01-08 00:00:00		2001-04-30 00:00:00		2001-04-30 00:00:00		2001-04-30 00:00:00		2001-07-24 00:00:00		2001-07-31 00:00:00		2001-10-23 00:00:00		2002-01-24 00:00:00		2001-10-31 00:00:00		2001-10-31 00:00:00		2002-01-24 00:00:00		2002-04-30 00:00:00		2002-04-16 00:00:00		2002-04-30 00:00:00		2002-04-30 00:00:00		2002-07-30 00:00:00		2002-10-28 00:00:00		2002-10-29 00:00:00		2002-07-30 00:00:00		2003-01-24 00:00:00		2003-01-10 00:00:00		2003-01-14 00:00:00		2003-01-14 00:00:00		2003-01-24 00:00:00		2003-04-29 00:00:00		2003-03-26 00:00:00		2003-04-30 00:00:00		2003-04-30 00:00:00		2003-02-05 00:00:00		2003-04-04 00:00:00		2003-04-29 00:00:00		2003-07-28 00:00:00		2003-02-27 00:00:00		2003-02-27 00:00:00		2003-05-02 00:00:00		2003-10-22 00:00:00		2003-07-29 00:00:00		2004-01-21 00:00:00		2004-01-22 00:00:00		2003-10-24 00:00:00		2004-01-28 00:00:00		2004-04-23 00:00:00		2004-04-26 00:00:00		2004-02-24 00:00:00		2004-07-30 00:00:00		2004-04-26 00:00:00		2004-07-29 00:00:00		2004-06-14 00:00:00		2005-01-05 00:00:00		2004-10-12 00:00:00		2004-09-29 00:00:00		2004-10-13 00:00:00		2004-09-29 00:00:00		2005-01-05 00:00:00		2005-01-25 00:00:00		2005-05-02 00:00:00		2005-02-18 00:00:00		2005-02-18 00:00:00		2005-04-28 00:00:00		2005-01-25 00:00:00		2005-08-02 00:00:00		2005-07-29 00:00:00		2005-08-02 00:00:00		2005-10-31 00:00:00		2005-05-04 00:00:00		2005-10-19 00:00:00		2006-01-31 00:00:00		2006-04-20 00:00:00		2006-07-27 00:00:00		2006-07-27 00:00:00		2006-10-24 00:00:00		2007-04-26 00:00:00		2007-04-26 00:00:00		2007-02-01 00:00:00		2007-02-02 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2007-02-02 00:00:00		2007-04-27 00:00:00		2007-04-27 00:00:00		2007-01-30 00:00:00		2007-10-19 00:00:00		2007-10-19 00:00:00		2008-01-28 00:00:00		2007-08-13 00:00:00		2007-08-13 00:00:00		2007-10-31 00:00:00		2013-07-25 00:00:00		2015-07-29 00:00:00		2015-04-29 00:00:00		2015-04-29 00:00:00		2015-04-29 00:00:00		2014-07-30 00:00:00		2013-10-28 00:00:00		2015-01-15 00:00:00		2015-01-15 00:00:00		2015-01-08 00:00:00		2014-10-31 00:00:00		2008-04-15 00:00:00		2007-10-26 00:00:00		2008-07-29 00:00:00		2008-07-31 00:00:00		2008-08-21 00:00:00		2008-07-31 00:00:00		2008-10-30 00:00:00		2008-10-30 00:00:00		2008-10-30 00:00:00		2009-03-17 00:00:00		2009-01-30 00:00:00		2009-04-30 00:00:00		2009-04-30 00:00:00		2009-05-05 00:00:00		2009-07-28 00:00:00		2009-07-28 00:00:00		2009-04-30 00:00:00		2009-04-30 00:00:00		2009-04-24 00:00:00		2009-04-24 00:00:00		2009-07-30 00:00:00		2009-03-17 00:00:00		2010-01-25 00:00:00		2010-01-29 00:00:00		2010-02-01 00:00:00		2009-10-26 00:00:00		2010-06-15 00:00:00		2010-07-26 00:00:00		2010-04-27 00:00:00		2010-05-20 00:00:00		2010-10-27 00:00:00		2011-01-13 00:00:00		2011-02-03 00:00:00		2011-01-20 00:00:00		2011-01-13 00:00:00		2011-01-20 00:00:00		2011-01-24 00:00:00		2011-02-03 00:00:00		2011-04-25 00:00:00		2011-04-28 00:00:00		2011-04-26 00:00:00		2012-01-25 00:00:00		2012-01-25 00:00:00		2012-01-26 00:00:00		2011-07-28 00:00:00		2012-01-25 00:00:00		2012-01-25 00:00:00		2011-10-19 00:00:00		2012-02-06 00:00:00		2012-04-18 00:00:00		2012-02-07 00:00:00		2012-05-25 00:00:00		2012-07-27 00:00:00		2012-05-29 00:00:00		2014-01-30 00:00:00		2012-10-17 00:00:00		2015-01-28 00:00:00		2014-10-31 00:00:00		2014-10-31 00:00:00		2014-10-31 00:00:00		2015-01-05 00:00:00		2014-08-28 00:00:00		2014-08-28 00:00:00		2013-01-18 00:00:00		2013-01-18 00:00:00		2013-01-28 00:00:00		2014-04-28 00:00:00		2013-01-22 00:00:00		2013-04-23 00:00:00		2015-10-21 00:00:00		2018-01-26 00:00:00		2018-11-02 00:00:00		2018-11-02 00:00:00		2018-04-24 00:00:00		2018-10-26 00:00:00		2018-07-20 00:00:00		2017-10-23 00:00:00		2016-01-25 00:00:00		2016-05-02 00:00:00		2016-07-25 00:00:00		2016-10-19 00:00:00		2017-01-26 00:00:00		2017-03-29 00:00:00		2017-03-29 00:00:00		2017-04-20 00:00:00		2017-07-31 00:00:00		2017-05-01 00:00:00		2018-10-17 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		10005		10005		10005		10001		10005		10001		10005		10005		10005		10005		10005		10001		10001		10005		10001		10001		10005		10005		10005		10001		10005		10005		10005		10005		10001		10005		10001		10005		10005		10005		10005		10001		10001		10005		10005		10005		10005		10005		10005		10001		10005		10005		10005		10001		10005		10001		10005		10005		10005		10001		10005		10005		10005		10005		10001		10005		10005		10001		10002		10005		10006		10001		10001		10002		10002		10005		10001		10005		10002		10001		10005		10005		10005		10001		10001		10001		10002		10001		10001		10002		10001		10005		10001		10001		10005		10005		10005		10006		10001		10002		10001		10001		10005		10002		10005		10001		10001		10006		10001		10002		10001		10001		10002		10006		10005		10001		10001		10002		10001		10002		10005		10005		10002		10002		10001		10005		10001		10001		10002		10005		10002		10001		10005		10005		10002		10002		10006		10001		10002		10001		10006		10001		10006		10001		10001		10006		10001		10001		10002		10002		10005		10005		10001		10005		10002		10001		10006		10001		10002		10006		10001		10002		10002		10001		10002		10001		10006		10002		10001		10006		10001		10001		10001		10002		10002		10002		10001		10002		10005		10001		10001		10001		10001		10005		10001		10001		10001		10006		10003		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10002		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		1997		1997		1997		1999		1995		1995		1995		1995		1999		1997		1995		1995		1997		1995		1997		1997		1997		1995		1997		1999		1997		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		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		2003		2003		2003		2003		2005		2003		2005		2005		2005		2005		2003		2005		2005		2005		2003		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2007		2007		2007		2007		2007		2007		2005		2007		2007		2007		2007		2007		2007		2013		2015		2015		2015		2015		2013		2013		2015		2015		2015		2013		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		2009		2009		2011		2011		2011		2011		2011		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2011		2013		2013		2013		2013		2015		2013		2013		2013		2013		2011		2013		2013		2013		2015		2017		2017		2017		2017		2017		2017		2017		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		GGILMORE		TTHAM		*		MKIENG		*		TWALLS		NJACKSON		CFLAGG		YBONILLA		GPEREZ		*		*		GPEREZ		*		*		YBONILLA		SARRIAGA		YBONILLA		*		SARRIAGA		YBONILLA		CFLAGG		YBONILLA		*		YBONILLA		*		YBONILLA		GPEREZ		GPEREZ		GPEREZ		COMPLETED		COMPLETED		GPEREZ		SARRIAGA		SARRIAGA		GPEREZ		CFLAGG		YBONILLA		COMPLETED		SARRIAGA		SARRIAGA		SARRIAGA		COMPLETED		LTHIBAUL		COMPLETED		LTHIBAUL		YBONILLA		SARRIAGA		COMPLETED		SARRIAGA		GPEREZ		LTHIBAUL		LTHIBAUL		COMPLETED		SARRIAGA		SARRIAGA		COMPLETED		COMPLETED		YRODRIGU		YRODRIGU		COMPLETED		COMPLETED		*		COMPLETED		CFLAGG		YRODRIGU		YRODRIGU		*		YRODRIGU		GPEREZ		PROBERTS		CFLAGG		YRODRIGU		LTHIBAUL		YRODRIGU		*		YRODRIGU		YRODRIGU		*		YRODRIGU		SARRIAGA		*		LTHIBAUL		CFLAGG		SARRIAGA		CFLAGG		CFLAGG		YRODRIGU		LTHIBAUL		LTHIBAUL		LTHIBAUL		SARRIAGA		*		SARRIAGA		ASAETERN		AGLADNEY		YRODRIGU		AGLADNEY		YRODRIGU		ASAETERN		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		LTHIBAUL		*		MGUERRA		*		LTHIBAUL		LTHIBAUL		*		*		MGUERRA		PBANFORD		MGUERRA		MGUERRA		YRODRIGU		YRODRIGU		YRODRIGU		MGUERRA		CFLAGG		CFLAGG		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		MGUERRA		YRODRIGU		MGUERRA		YRODRIGU		ASAETERN		MGUERRA		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		SARRIAGA		SARRIAGA		ASAETERN		SARRIAGA		YRODRIGU		ASAETERN		YRODRIGU		ASAETERN		ASAETERN		YRODRIGU		ASAETERN		ASAETERN		YRODRIGU		ASAETERN		YRODRIGU		ASAETERN		YRODRIGU		CAFILER		AGLADNEY		CFLAGG		ASAETERN		ASAETERN		AGLADNEY		ASAETERN		ASAETERN		ASAETERN		YRODRIGU		YRODRIGU		SARRIAGA		PBANFORD		CAFILER		ASAETERN		ASAETERN		PBANFORD		ASAETERN		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU
special_audit		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		11002		11003		11003		11002		11003		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
fine_audit		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		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		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		11003		11003		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		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
rpt_start		1998-07-01 00:00:00		1998-10-01 00:00:00		1997-01-01 00:00:00		1999-04-01 00:00:00		1996-01-01 00:00:00		1995-01-01 00:00:00		1996-04-01 00:00:00		1996-07-01 00:00:00		1999-01-01 00:00:00		1998-04-01 00:00:00		1995-07-01 00:00:00		1996-10-01 00:00:00		1997-10-01 00:00:00		1995-04-01 00:00:00		1997-01-01 00:00:00		1997-01-01 00:00:00		1997-04-01 00:00:00		1995-10-01 00:00:00		1997-07-01 00:00:00		1999-07-01 00:00:00		1998-01-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-10-01 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		1900-01-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		1900-01-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		1900-01-01 00:00:00		2002-01-01 00:00:00		1900-01-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-04-01 00:00:00		2002-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-10-01 00:00:00		2003-01-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		1900-01-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-07-01 00:00:00		2003-04-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		1900-01-01 00:00:00		2004-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-04-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		2003-01-01 00:00:00		2004-07-01 00:00:00		2003-01-01 00:00:00		2004-12-15 00:00:00		2004-10-01 00:00:00		2005-04-21 00:00:00		2005-02-18 00:00:00		1900-01-01 00:00:00		2005-01-01 00:00:00		2004-10-01 00:00:00		2005-06-30 00:00:00		2005-04-01 00:00:00		1900-01-01 00:00:00		2003-01-01 00:00:00		1900-01-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-07-26 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		2007-04-19 00:00:00		2007-01-01 00:00:00		1900-01-01 00:00:00		2007-01-23 00:00:00		2007-04-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		2006-10-01 00:00:00		2007-04-01 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		1900-01-01 00:00:00		2007-05-01 00:00:00		1900-01-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		1900-01-01 00:00:00		2015-01-01 00:00:00		2015-04-27 00:00:00		2014-04-01 00:00:00		2013-07-01 00:00:00		2015-01-09 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2007-10-25 00:00:00		2008-04-01 00:00:00		2008-07-28 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-08-19 00:00:00		2008-10-28 00:00:00		2008-07-01 00:00:00		1900-01-01 00:00:00		2008-10-01 00:00:00		2009-01-01 00:00:00		2009-04-28 00:00:00		1900-01-01 00:00:00		2009-07-27 00:00:00		2009-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-04-01 00:00:00		2009-04-01 00:00:00		1900-01-01 00:00:00		2009-01-05 00:00:00		2010-01-05 00:00:00		2009-10-01 00:00:00		1900-01-01 00:00:00		2009-07-01 00:00:00		1900-01-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		1900-01-01 00:00:00		2010-07-01 00:00:00		2011-01-06 00:00:00		2011-01-31 00:00:00		2011-01-20 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		1900-01-01 00:00:00		2011-03-31 00:00:00		2011-01-01 00:00:00		1900-01-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		1900-01-01 00:00:00		2011-04-01 00:00:00		2011-04-01 00:00:00		2012-01-20 00:00:00		2011-07-01 00:00:00		2012-01-20 00:00:00		2012-01-01 00:00:00		1900-01-01 00:00:00		2012-05-25 00:00:00		2012-04-01 00:00:00		1900-01-01 00:00:00		2013-10-01 00:00:00		2012-07-01 00:00:00		2014-10-01 00:00:00		2013-10-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2015-01-05 00:00:00		2014-08-21 00:00:00		1900-01-01 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2017-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-01-01 00:00:00		2018-10-19 00:00:00		2018-04-01 00:00:00		2017-07-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2017-01-09 00:00:00		1900-01-01 00:00:00		2017-01-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2018-07-01 00:00:00
rpt_end		1998-09-30 00:00:00		1998-12-31 00:00:00		1997-03-31 00:00:00		1999-06-30 00:00:00		1996-03-31 00:00:00		1995-03-31 00:00:00		1996-06-30 00:00:00		1996-09-30 00:00:00		1999-03-31 00:00:00		1998-06-30 00:00:00		1995-09-30 00:00:00		1996-12-31 00:00:00		1997-12-31 00:00:00		1995-06-30 00:00:00		1997-03-31 00:00:00		1997-03-31 00:00:00		1997-06-30 00:00:00		1995-12-31 00:00:00		1997-09-30 00:00:00		1999-09-30 00:00:00		1998-03-31 00:00:00		1999-12-31 00:00:00		2000-03-31 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-12-31 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		1900-01-01 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		1900-01-01 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		1900-01-01 00:00:00		2002-03-31 00:00:00		1900-01-01 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-06-30 00:00:00		2002-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-12-31 00:00:00		2003-03-31 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		1900-01-01 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		1900-01-01 00:00:00		2004-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-06-30 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		2003-03-31 00:00:00		2004-09-30 00:00:00		2003-03-31 00:00:00		2004-12-15 00:00:00		2004-12-31 00:00:00		2005-04-21 00:00:00		2005-02-18 00:00:00		1900-01-01 00:00:00		2005-03-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		1900-01-01 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		2006-07-26 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2007-04-19 00:00:00		2007-03-31 00:00:00		1900-01-01 00:00:00		2007-01-23 00:00:00		2007-06-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		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		1900-01-01 00:00:00		2007-05-01 00:00:00		1900-01-01 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		1900-01-01 00:00:00		2015-03-31 00:00:00		2015-04-27 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		2015-01-09 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2008-03-31 00:00:00		2007-10-25 00:00:00		2008-06-30 00:00:00		2008-07-28 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-08-19 00:00:00		2008-10-28 00:00:00		2008-09-30 00:00:00		1900-01-01 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		2009-04-28 00:00:00		1900-01-01 00:00:00		2009-07-27 00:00:00		2009-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-04-01 00:00:00		2009-04-01 00:00:00		1900-01-01 00:00:00		2009-01-05 00:00:00		2010-01-05 00:00:00		2009-12-31 00:00:00		1900-01-01 00:00:00		2009-09-30 00:00:00		1900-01-01 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		1900-01-01 00:00:00		2010-09-30 00:00:00		2011-01-06 00:00:00		2011-01-31 00:00:00		2011-01-20 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		2011-03-31 00:00:00		2011-03-31 00:00:00		1900-01-01 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		1900-01-01 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2012-01-20 00:00:00		2011-09-30 00:00:00		2012-01-20 00:00:00		2012-03-31 00:00:00		1900-01-01 00:00:00		2012-05-25 00:00:00		2012-06-30 00:00:00		1900-01-01 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2014-12-31 00:00:00		2013-12-31 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2015-01-05 00:00:00		2014-08-21 00:00:00		1900-01-01 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2017-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-03-31 00:00:00		2018-10-19 00:00:00		2018-06-30 00:00:00		2017-09-30 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2017-01-09 00:00:00		1900-01-01 00:00:00		2017-03-31 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2018-09-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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		22001		22001		None		None		None		None		None		None		22001		None		None		None		22001		None		22001		None		None		None		22001		None		None		None		None		22001		None		None		22001		22001		None		None		22001		22001		22001		22001		None		22001		None		22001		22001		None		None		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		None		None		None		22001		22001		22001		22001		None		22001		None		22001		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		None		22001		22001		22001		None		22001		22001		None		None		22001		22001		None		22001		22001		22001		None		22001		None		22001		22001		None		22001		22001		22001		22001		None		None		22001		None		22001		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001

Table: filer_to_filer_type

filer_id		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218
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		T
race		0		0		0		0		None		None		None		None		None		None		None		None		None
session_id		1999		1997		1995		2001		2003		2005		2011		2013		2007		2009		2015		2017		2017
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		1999-01-01 00:00:00		1997-01-01 00:00:00		1995-01-01 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2018-09-30 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-07-01 00:00:00		None		None		2000-07-01 00:00:00		None		None		None		None
party_cd		None		None		None		None		None		None		None		None		None		None		None		None		None
county_cd		None		None		None		None		None		None		None		None		None		None		None		None		None
district_cd		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1147218
xref_id		F00053
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053		F00053
filer_id		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218
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		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM
status		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED		TERMINATED
effect_dt		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00
naml		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.
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		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		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		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		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		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		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		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
phon		9168064326		8006099701		9164478229		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		8006099701		9164478229		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		8006099701		9164478229		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		8006099701		9164478229		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		8006099701		9164478229		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		8006099701		9164478229		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		8006099701		9164478229		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		8006099701		9164478229		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		8006099701		9164478229		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		8006099701		9164478229		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1147218

Table: lobbying_chg_log

filer_id		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218
change_no		1		2		3		4		6		7		5		8		9		13		14		15		23		20		18		19		16		17		21		0		31		22		26		27		28		29		24		25		32		30		34		33		37		35		36		39		38		44		40		41		42		43		45		46		47		48		49		50		51
session_id		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2003		2005		2003		2003		2003		2003		2003		2003		2003		2007		2005		2007		2007		2007		2007		2005		2007		2007		2007		2009		2009		2011		2009		2009		2011		2011		2013		2013		2013		2013		2013		2013		2013		2015		2017		2017		2017		2017
log_dt		2000-08-08 00:00:00		2000-08-08 00:00:00		2000-09-30 00:00:00		2001-03-27 00:00:00		2001-05-01 00:00:00		2001-04-30 00:00:00		2001-04-30 00:00:00		2001-10-31 00:00:00		2002-01-24 00:00:00		2002-04-16 00:00:00		2002-04-30 00:00:00		2003-02-27 00:00:00		2005-05-04 00:00:00		2004-01-28 00:00:00		2003-05-02 00:00:00		2003-04-30 00:00:00		2003-04-30 00:00:00		2003-04-04 00:00:00		2004-02-24 00:00:00		2004-06-14 00:00:00		2007-08-13 00:00:00		2005-02-18 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2008-07-31 00:00:00		2007-07-31 00:00:00		2009-04-30 00:00:00		2009-04-30 00:00:00		2011-04-26 00:00:00		2009-07-30 00:00:00		2010-06-15 00:00:00		2012-02-07 00:00:00		2012-01-26 00:00:00		2013-01-22 00:00:00		2013-01-22 00:00:00		2013-01-22 00:00:00		2013-01-22 00:00:00		2013-01-22 00:00:00		2013-01-22 00:00:00		2013-01-22 00:00:00		2015-04-29 00:00:00		2017-03-29 00:00:00		2017-03-29 00:00:00		2017-03-29 00:00:00		2017-03-29 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		3		3		3
correction_flg		None		None		None		None		None		Y		None		Y		Y		Y		Y		Y		None		None		Y		Y		None		Y		None		None		Y		None		Y		Y		Y		Y		None		Y		Y		Y		Y		Y		Y		Y		Y		Y		None		Y		Y		None		Y		Y		Y		Y		Y		Y		Y		Y		Y
action		SET INACTIVE		SET INACTIVE		SET INACTIVE		CHANGED		SET ACTIVE		ADDED		SET ACTIVE		DELETED		NEW		ADDED		ADDED		NEW		ADDED		DELETED		NEW		CHANGED		ADDED		NEW		DELETED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		DELETED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		DELETED		ADDED		ADDED		ADDED		ADDED
attribute_changed		None		None		None		ADDRESS AND PHONE		FIRM		EMPLOYER		FIRM		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		None		CLIENT		CLIENT		None		REGISTRATION DATE		CLIENT		None		CLIENT		CLIENT/FIRM		EMPLOYER		CLIENT		LOBBYIST		EMPLOYER		EMPLOYER		EMPLOYER		CLIENT		EMPLOYER		CLIENT		CLIENT		CLIENT		EMPLOYER		EMPLOYER		CLIENT		EMPLOYER		EMPLOYER		CLIENT		EMPLOYER		LOBBYIST		/ FIRM		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		LOBBYIST		/ FIRM		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		None		None		None
interests		None		None		None		None		None		MISCELLANEOUS		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING, WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.		DOHRING; WILLIAM "BILL" F.
filer_city		None		None		None		None		SACRAMENTO		None		SACRAMENTO		None		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		None		None		None		SACRAMENTO		None		SACRAMENTO		None		None		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		None		None		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
filer_st		None		None		None		None		CA		None		CA		None		CA		None		CA		CA		None		None		None		CA		None		CA		None		None		CA		None		CA		CA		CA		CA		None		None		CA		CA		CA		None		CA		CA		None		None		None		CA		CA		CA		CA		CA		CA		CA		None		CA		CA		CA		CA
filer_zip		None		None		None		None		95814		None		95814		None		95814		None		95814		95814		None		None		None		95814		None		95814		None		None		95814		None		95814		95814		95814		95814		None		None		95814		95814		95814		None		95814		95814		None		None		None		95814		95814		95814		95814		95814		95814		95814		None		95814		95814		95814		95814
filer_phone		None		None		None		None		9164465508		None		9164472251		None		9164478229		None		9164478229		9164478229		None		None		None		9164478229		None		9164478229		None		None		9164478229		None		9164478229		9164478229		9164478229		9164478229		None		None		9164478229		9164478229		9164478229		None		9164478229		9164478229		None		None		None		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		9168064326		None		9168064326		9168064326		9168064326		9168064326
entity_type		3		3		3		1		3		2		1		2		2		2		2		2		1		1		2		2		1		2		1		3		2		1		4		2		2		2		1		2		3		3		3		2		2		3		2		2		1		2		4		1		2		2		2		2		2		4		1		2		2
entity_name		ADVOCATION, INC.		ADVOCATION, INC.		ADVOCATION, INC.		EDISON INTERNATIONAL & SUBSIDIARIES		ADVOCATION, INC.		SPECIALTY TOBACCO COUNCIL, INC.		EDISON INTERNATIONAL & SUBSIDIARIES		SPECIALTY TOBACCO COUNCIL, INC.		CITY OF BRAWLEY		INDEPENDENT AUTOMOBILE DEALERS ASSOCIATION OF CALIFORNIA		SCHOOL MANUFACTURING GROUP		REGIONAL PARKING INC.		INDEPENDENT AUTOMOBILE DEALERS ASSOCIATION OF CALIFORNIA		CALIFORNIA ASSOCIATION OF REGISTRATION SERVICES		CALIFORNIA ASSOCIATION OF MSO'S		CALIFORNIA ASSOCIATION OF REGISTRATION SERVICES		SCHOOL MANUFACTURING GROUP		CALIFORNIA ASSOCIATION OF REGISTRATION SERVICES		SCHOOL MANUFACTURING GROUP		ADVOCAL		BRAWLEY; CITY OF		BRAWLEY, CITY OF		DOHRING, WILLIAM "BILL" F.		IMPERIAL; COUNTY OF		INDEPENDENT AUTOMOBILE DEALERS ASSOCIATION OF CALIFORNIA		SAVAGE; SCOTT		CALIFORNIA ASSOCIATION OF SCHOOL TRANSPORTATION OFFICIALS (CASTO)		CALIFORNIA ASSOCIATION OF SCHOOL TRANSPORTATION OFFICIALS (CASTO)		PLATINUM ADVISORS, LLC		ADVOCATION, INC.		ADVOCAL		BRAWLEY; CITY OF		CALIFORNIA ASSOCIATION OF SCHOOL TRANSPORTATION OFFICIALS (CASTO)		PLATINUM ADVISORS, LLC		CALIFORNIA ASSOCIATION OF SCHOOL TRANSPORTATION OFFICIALS (CASTO)		ENERGY SOURCE		BRAWLEY; CITY OF		IMPERIAL; COUNTY OF		DOHRING, WILLIAM "BILL" F.		ADVOCATION, INC		CALIFORNIA ASSOCIATION OF SCHOOL TRANSPORTATION OFFICIALS (CASTO)		ENERGY SOURCE		INDEPENDENT AUTOMOBILE DEALERS ASSOCIATION OF CALIFORNIA		MOTORCYCLE INDUSTRY COUNCIL		IMPERIAL; COUNTY OF		DOHRING, WILLIAM "BILL" F.		ADVOCATION, INC.		INDEPENDENT AUTOMOBILE DEALERS ASSOCIATION OF CALIFORNIA		MOTORCYCLE INDUSTRY COUNCIL
entity_city		None		None		None		ROSEMEAD		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		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		None		None		None		None		None		None		None
entity_zip		None		None		None		91770		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		8183021986		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		1147259		1147259		1147259		1146844		1147259		1234649		1146844		1234649		None		1142978		None		None		1142978		1254354		1254672		None		1222686		None		1222686		1147273		None		1242253		None		None		None		None		1223857		1223857		None		None		None		1242253		None		None		1223857		1346314		1242253		None		None		None		None		None		None		None		1146201		None		None		None		None
responsible_officer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		2001-04-15 00:00:00		None		2001-09-15 00:00:00		2002-01-19 00:00:00		2002-04-01 00:00:00		2002-03-01 00:00:00		2003-02-26 00:00:00		2005-01-01 00:00:00		2003-12-31 00:00:00		2003-04-21 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-12-31 00:00:00		2003-01-06 00:00:00		2007-05-01 00:00:00		2005-01-01 00:00:00		2007-02-02 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-22 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2008-06-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2009-05-01 00:00:00		2009-01-01 00:00:00		2012-01-01 00:00:00		2011-12-30 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-02-22 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00

Table: received_filings

filer_id		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218		1147218
filing_file_name		10805.cal		19325.cal		19509.cal		19666.cal		681088_0.cal		714384_0.cal		745463_0.cal		745469_0.cal		788466_0.cal		788468_0.cal		769480_0.cal		769484_0.cal		63133.cal		809599_0.cal		809600_0.cal		839269_0.cal		839277_0.cal		854086_0.cal		854089_0.cal		881275_0.cal		881280_0.cal		905759_0.cal		905761_0.cal		930100_0.cal		944922_0.cal		966157_0.cal		984110_0.cal		1010763_0.cal		1028749_0.cal		930100_1.cal		1046855_0.cal		1070190_0.cal		337585.cal		1075179_0.cal		339896.cal		1103770_0.cal		280388.cal		1070190_2.cal		337671.cal		1070190_1.cal		1117691_0.cal		281799.cal		1070190_3.cal		281581.cal		282106.cal		281942.cal		1128874_0.cal		1147641_0.cal		1163326_0.cal		130838.cal		1070190_4.cal		1188791_0.cal		1210411_0.cal		1407668_0.cal		208408.cal		208464.cal		1407668_1.cal		208556.cal		1240491_4.cal		475737.cal		475808.cal		476183.cal		411813.cal		411849.cal		1240491_0.cal		1235536_0.cal		1260039_0.cal		1240491_1.cal		162520.cal		96241.cal		1240491_2.cal		1284468_0.cal		333291.cal		1240491_3.cal		83244.cal		84594.cal		1240491_5.cal		1240491_6.cal		54074.cal		1559705_1.cal		1559705_0.cal		440894.cal		1618187_0.cal		1605199_0.cal		1631825_0.cal		1605199_1.cal		1618187_1.cal		1589633_0.cal		428150.cal		428198.cal		2124337_0.cal		2152166_0.cal		2058060_0.cal		2006471_0.cal		1993071_0.cal		1979328_0.cal		496016.cal		2092030_0.cal		98964.cal		1964142_0.cal		411366.cal		1923026_2.cal		21647.cal		21856.cal		22000.cal		199386.cal		2037792_0.cal		2152166_1.cal		2175523_0.cal		492241.cal		428568.cal		2206455_0.cal		2234509_0.cal		2267136_0.cal		2189733_0.cal		2307611_0.cal
received_date		2000-10-30 00:00:00		2000-10-30 00:00:00		2000-10-30 00:00:00		2000-10-30 00:00:00		2000-10-30 00:00:00		2001-01-25 00:00:00		2001-04-30 00:00:00		2001-04-30 00:00:00		2001-10-23 00:00:00		2001-10-23 00:00:00		2001-07-24 00:00:00		2001-07-24 00:00:00		2001-10-30 00:00:00		2002-01-24 00:00:00		2002-01-24 00:00:00		2002-04-30 00:00:00		2002-04-30 00:00:00		2002-07-30 00:00:00		2002-07-30 00:00:00		2002-10-28 00:00:00		2002-10-28 00:00:00		2003-01-24 00:00:00		2003-01-24 00:00:00		2003-04-29 00:00:00		2003-07-28 00:00:00		2003-10-22 00:00:00		2004-01-21 00:00:00		2004-04-23 00:00:00		2004-07-29 00:00:00		2004-09-29 00:00:00		2004-10-12 00:00:00		2005-01-05 00:00:00		2005-01-05 00:00:00		2005-01-25 00:00:00		2005-01-05 00:00:00		2005-04-28 00:00:00		2005-05-02 00:00:00		2005-05-02 00:00:00		2005-02-18 00:00:00		2005-02-18 00:00:00		2005-07-29 00:00:00		2005-08-02 00:00:00		2005-08-02 00:00:00		2005-08-02 00:00:00		2005-08-02 00:00:00		2005-08-02 00:00:00		2005-10-19 00:00:00		2006-01-31 00:00:00		2006-04-20 00:00:00		2006-04-20 00:00:00		2006-07-27 00:00:00		2006-07-27 00:00:00		2006-10-24 00:00:00		2009-03-17 00:00:00		2009-04-24 00:00:00		2009-04-24 00:00:00		2009-04-24 00:00:00		2009-04-24 00:00:00		2008-07-31 00:00:00		2010-05-20 00:00:00		2010-05-20 00:00:00		2010-05-20 00:00:00		2008-08-21 00:00:00		2008-08-21 00:00:00		2007-02-02 00:00:00		2007-01-30 00:00:00		2007-04-26 00:00:00		2007-04-26 00:00:00		2009-04-30 00:00:00		2007-08-13 00:00:00		2007-08-13 00:00:00		2007-07-31 00:00:00		2007-10-26 00:00:00		2007-10-26 00:00:00		2008-10-30 00:00:00		2008-10-30 00:00:00		2008-10-30 00:00:00		2008-10-30 00:00:00		2012-05-25 00:00:00		2011-01-20 00:00:00		2011-01-13 00:00:00		2011-02-03 00:00:00		2011-10-19 00:00:00		2011-07-28 00:00:00		2012-01-25 00:00:00		2012-01-25 00:00:00		2012-01-25 00:00:00		2011-04-28 00:00:00		2012-02-06 00:00:00		2012-02-06 00:00:00		2017-01-26 00:00:00		2017-04-20 00:00:00		2016-07-25 00:00:00		2016-01-25 00:00:00		2015-10-21 00:00:00		2015-07-29 00:00:00		2015-10-21 00:00:00		2016-10-19 00:00:00		2015-01-09 00:00:00		2015-04-29 00:00:00		2015-04-29 00:00:00		2015-04-29 00:00:00		2015-01-05 00:00:00		2015-01-05 00:00:00		2015-01-05 00:00:00		2015-01-15 00:00:00		2016-05-02 00:00:00		2017-05-01 00:00:00		2017-07-31 00:00:00		2017-05-01 00:00:00		2018-10-26 00:00:00		2018-01-26 00:00:00		2018-04-24 00:00:00		2018-07-20 00:00:00		2017-10-23 00:00:00		2018-10-17 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/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/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/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/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/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		None		None		None		None		681088		714384		745463		745469		788466		788468		769480		769484		None		809599		809600		839269		839277		854086		854089		881275		881280		905759		905761		930100		944922		966157		984110		1010763		1028749		930100		1046855		1070190		None		1075179		None		1103770		None		1070190		None		1070190		1117691		None		1070190		None		None		None		1128874		1147641		1163326		None		1070190		1188791		1210411		1407668		None		None		1407668		None		1240491		None		None		None		None		None		1240491		1235536		1260039		1240491		None		None		1240491		1284468		None		1240491		None		None		1240491		1240491		None		1559705		1559705		None		1618187		1605199		1631825		1605199		1618187		1589633		None		None		2124337		2152166		2058060		2006471		1993071		1979328		None		2092030		None		1964142		None		1923026		None		None		None		None		2037792		2152166		2175523		None		None		2206455		2234509		2267136		2189733		2307611
form_id		None		None		None		None		F625		F625		F615		F625		F625		F615		F625		F615		None		F625		F615		F625		F615		F625		F615		F625		F615		F625		F615		F625		F625		F625		F625		F625		F625		F625		F625		F601		None		F625		None		F625		None		F601		None		F601		F625		None		F601		None		None		None		F625		F625		F625		None		F601		F625		F625		F601		None		None		F601		None		F601		None		None		None		None		None		F601		F625		F625		F601		None		None		F601		F625		None		F601		None		None		F601		F601		None		F601		F601		None		F625		F625		F625		F625		F625		F625		None		None		F625		F625		F625		F625		F625		F625		None		F625		None		F625		None		F601		None		None		None		None		F625		F625		F625		None		None		F625		F625		F625		F625		F625
receive_comment		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, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		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 did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing accepted		Filing accepted		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		Filing accepted		Filing accepted		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing did not pass validation		Filing accepted		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 accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted