Home

Filer ID: 1013270

Table: filer_address

filer_id		1013270		1013270
adrid		1012828		2094501
effect_dt		1995-02-27 00:00:00		2008-01-10 00:00:00
add_type		7051		7051
session_id		1995		2007

Table: filer_filings

filer_id		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270
filing_id		75648		75649		75650		205045		580080		749345		805237		811318		986756		979106		1072893		1077961		1142034		1128144		1129950		1178716		1183861		1185341		1181602		1178716		1231565		1230842		1221499		1252193		1274264		1303303		1302730		1783223		1787696		1967730		1942362		1963230		1976068		1870260		1858243		1783224		1794574		1794574		1794574		1942362		1938485		1942362		1950560		1950560		1898139		1880940		1883539		1902578		1336365		1336365		1371607		1338057		1370383		1390934		1392588		1391086		1442977		1447392		1448372		1431052		1458460		1449088		1460175		1499610		1499305		1499305		1565912		1599836		1499610		1571518		1618024		1629499		1629718		1601446		1618381		1674819		1822506		1817659		1821044		1681092		1929769		1447392		1458460		1499305		1565912		1599836		1618024		1629499		1674819		1877741		1879753		1737141		1571518		1499610		1460175		1681092		1601446		1618381		1449088		1629718		1842943		1817659		1794574		1822506		1849547		1838771		1838646		1744661		1759445		1759621		1976366		2203008		1993969		1993104		2005133		2013832		2032780		2059354		2057506		2083991		2123556		2136806		2220261
period_id		141		145		153		137		None		None		165		None		None		173		177		None		184		181		None		186		185		None		None		186		187		189		None		None		None		None		189		214		None		None		221		221		222		217		218		215		216		216		216		221		None		221		221		221		220		219		219		220		194		194		None		None		196		None		None		193		None		199		None		197		200		None		None		None		201		201		203		205		None		None		207		208		None		None		None		209		None		215		217		None		219		199		200		201		203		205		207		208		209		219		None		211		None		None		None		None		None		None		None		None		218		215		218		None		218		218		218		None		213		None		None		229		None		223		224		None		226		None		225		227		227		None		None
form_id		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F497		F461		F497		F497		F461		F497		F461		F461		F461		F461		F461		F497		F461		F461		F461		F497		F497		F497		F497		F497		F497		F461		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F461		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F497		F461		F461		F461
filing_sequence		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		2		0		1		2		0		1		0		1		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		0		0		0		0		0		0		0		0		0		0		0		1		1		2		1		1		1		1		1		0		0		0		1		2		1		1		1		1		1		1		0		1		3		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1996-01-17 00:00:00		1997-01-27 00:00:00		1999-02-01 00:00:00		1995-01-31 00:00:00		2000-01-03 00:00:00		2001-01-19 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2004-01-09 00:00:00		2004-01-09 00:00:00		2005-01-18 00:00:00		2005-01-19 00:00:00		2006-01-16 00:00:00		2005-10-14 00:00:00		2005-10-17 00:00:00		2006-06-02 00:00:00		2006-07-13 00:00:00		2006-07-17 00:00:00		2006-01-18 00:00:00		2006-06-05 00:00:00		2007-01-25 00:00:00		2007-01-23 00:00:00		2006-06-05 00:00:00		2007-01-26 00:00:00		2007-01-23 00:00:00		2008-01-10 00:00:00		2008-01-09 00:00:00		2013-07-31 00:00:00		2013-07-31 00:00:00		2015-04-28 00:00:00		2015-02-13 00:00:00		2015-04-28 00:00:00		2015-07-22 00:00:00		2014-07-30 00:00:00		2014-06-03 00:00:00		2013-07-31 00:00:00		2013-12-09 00:00:00		2013-10-16 00:00:00		2013-10-18 00:00:00		2015-03-06 00:00:00		2015-01-26 00:00:00		2015-02-18 00:00:00		2015-03-04 00:00:00		2015-03-05 00:00:00		2014-10-14 00:00:00		2014-08-27 00:00:00		2014-09-09 00:00:00		2014-10-22 00:00:00		2008-05-23 00:00:00		2008-05-27 00:00:00		2008-10-23 00:00:00		2008-05-27 00:00:00		2008-10-23 00:00:00		2008-05-23 00:00:00		2009-01-22 00:00:00		2009-01-22 00:00:00		2009-07-31 00:00:00		2009-10-09 00:00:00		2006-06-02 00:00:00		2009-07-15 00:00:00		2010-01-19 00:00:00		2009-10-14 00:00:00		2010-01-21 00:00:00		2010-07-06 00:00:00		2010-07-06 00:00:00		2011-01-25 00:00:00		2011-01-25 00:00:00		2011-07-12 00:00:00		2011-01-25 00:00:00		2011-01-25 00:00:00		2011-10-18 00:00:00		2012-01-19 00:00:00		2012-01-19 00:00:00		2011-07-19 00:00:00		2011-10-18 00:00:00		2012-07-26 00:00:00		2014-01-31 00:00:00		2014-01-31 00:00:00		2014-02-07 00:00:00		2012-07-26 00:00:00		2015-01-26 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2014-08-14 00:00:00		2014-07-31 00:00:00		2013-01-30 00:00:00		2012-12-27 00:00:00		2012-12-27 00:00:00		2012-12-27 00:00:00		2012-12-27 00:00:00		2012-12-27 00:00:00		2012-12-27 00:00:00		2012-12-27 00:00:00		2012-12-27 00:00:00		2014-04-28 00:00:00		2014-04-29 00:00:00		2014-04-29 00:00:00		2014-04-30 00:00:00		2014-05-13 00:00:00		2014-04-16 00:00:00		2014-04-15 00:00:00		2013-01-31 00:00:00		2013-04-18 00:00:00		2013-04-18 00:00:00		2015-07-22 00:00:00		2018-01-19 00:00:00		2015-10-21 00:00:00		2015-10-21 00:00:00		2016-01-20 00:00:00		2016-01-21 00:00:00		2016-04-26 00:00:00		2016-07-22 00:00:00		2016-07-22 00:00:00		2016-09-30 00:00:00		2017-01-25 00:00:00		2017-01-25 00:00:00		2018-01-19 00:00:00
stmnt_type		10001		10001		10001		10001		10005		10005		10001		10005		10005		10001		10001		10005		10001		10001		10005		10001		10001		10005		10005		10002		10001		10001		10006		10005		10005		10005		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10002		10001		10002		10002		10005		10002		10001		10002		10001		10001		10001		10001		10001		10002		10005		10006		10001		10005		10005		10001		10005		10001		10005		10001		10001		10005		10005		10005		10001		10002		10001		10001		10006		10005		10001		10001		10005		10005		10005		10001		10005		10001		10001		10005		10001		10002		10002		10002		10002		10002		10002		10002		10002		10001		10005		10001		10006		10006		10006		10006		10006		10006		10006		10006		10001		10002		10002		10006		10001		10001		10001		10005		10001		10005		10005		10001		10005		10001		10001		10005		10001		10005		10001		10001		10001		10005		10005
stmnt_status		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11001		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		1995		1995		1997		1993		1999		1999		2001		2001		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2005		2007		2007		2007		2013		2013		2015		2015		2015		2015		2013		2013		2013		2013		2013		2013		2015		2013		2015		2015		2015		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2005		2009		2009		2009		2009		2009		2009		2009		2009		2011		2009		2009		2011		2011		2011		2011		2011		2011		2013		2013		2013		2011		2013		2009		2009		2009		2009		2011		2011		2011		2011		2013		2013		2011		2009		2009		2009		2011		2011		2011		2009		2011		2013		2013		2013		2013		2013		2013		2013		2011		2013		2013		2015		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017
user_id		*		*		*		*		BSMITH		GGILMORE		*		LTHIBAUL		GKURIMOT		COMPLETED		COMPLETED		DHORRELL		*		*		DHORRELL		DJOHNSON		*		JMARTIN		RGEREMIA		DJOHNSON		*		*		EMCENTEE		JMARTIN		DHORRELL		SMCCABE		*		JINGRAM		JINGRAM		JINGRAM		WBROWN		JINGRAM		JINGRAM		JINGRAM		WBROWN		RGEREMIA		WBROWN		WBROWN		WBROWN		WBROWN		JINGRAM		WBROWN		WBROWN		WBROWN		CAFILER		WBROWN		CAFILER		CAFILER		*		DMCCASTL		YRODRIGU		LHOANG		DHORRELL		JINGRAM		JINGRAM		MGUERRA		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		WBROWN		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		WBROWN		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		WBROWN		JINGRAM		WBROWN		JINGRAM		WBROWN		WBROWN		WBROWN		JINGRAM		JINGRAM		JINGRAM		JINGRAM		LPALMER		JINGRAM		JINGRAM		JINGRAM		JINGRAM		KBANH		CHARTRIDGE		JINGRAM		PDEO		JINGRAM		JINGRAM		LPALMER
special_audit		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		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		11003		11003		11003		11001		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003
rpt_start		1995-01-01 00:00:00		1996-01-01 00:00:00		1998-01-01 00:00:00		1994-01-01 00:00:00		1999-01-01 00:00:00		2000-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2005-10-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2006-06-02 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2005-10-01 00:00:00		2006-06-05 00:00:00		2006-07-01 00:00:00		2007-01-23 00:00:00		None		2006-07-01 00:00:00		None		2007-01-01 00:00:00		2007-01-01 00:00:00		2013-04-01 00:00:00		2013-04-01 00:00:00		2015-01-01 00:00:00		2015-02-13 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2014-01-01 00:00:00		2014-06-03 00:00:00		2013-07-31 00:00:00		2013-12-09 00:00:00		2013-10-16 00:00:00		2013-10-18 00:00:00		2015-03-06 00:00:00		2014-07-01 00:00:00		2015-02-17 00:00:00		2015-03-04 00:00:00		2015-03-05 00:00:00		2014-10-14 00:00:00		2014-08-27 00:00:00		2014-09-09 00:00:00		2014-10-22 00:00:00		2008-05-23 00:00:00		2008-05-27 00:00:00		None		None		2008-10-23 00:00:00		None		2008-01-01 00:00:00		2008-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		None		2009-01-01 00:00:00		2009-10-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2011-10-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2014-02-07 00:00:00		2012-01-01 00:00:00		2014-07-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2014-08-14 00:00:00		2014-01-01 00:00:00		2012-07-01 00:00:00		2010-07-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2012-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2009-07-01 00:00:00		2011-10-01 00:00:00		2014-04-28 00:00:00		2013-07-01 00:00:00		2014-04-25 00:00:00		2013-07-01 00:00:00		2014-05-13 00:00:00		2014-04-15 00:00:00		2014-04-15 00:00:00		2012-07-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-04-01 00:00:00		2017-01-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2015-10-01 00:00:00		2015-10-01 00:00:00		2016-04-26 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-09-30 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00
rpt_end		1995-12-31 00:00:00		1996-12-31 00:00:00		1998-12-31 00:00:00		1994-12-31 00:00:00		1999-12-31 00:00:00		2000-12-31 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-12-31 00:00:00		2005-09-30 00:00:00		2005-09-30 00:00:00		2006-06-02 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2005-12-31 00:00:00		2006-06-05 00:00:00		2006-12-31 00:00:00		2007-01-23 00:00:00		None		2006-12-31 00:00:00		None		2007-12-31 00:00:00		2007-12-31 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2015-03-31 00:00:00		2015-02-13 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2014-06-03 00:00:00		2013-07-31 00:00:00		2013-12-09 00:00:00		2013-10-16 00:00:00		2013-10-18 00:00:00		2015-03-06 00:00:00		2014-12-31 00:00:00		2015-02-17 00:00:00		2015-03-04 00:00:00		2015-03-05 00:00:00		2014-10-14 00:00:00		2014-08-27 00:00:00		2014-09-09 00:00:00		2014-10-22 00:00:00		2008-05-23 00:00:00		2008-05-27 00:00:00		None		None		2008-10-23 00:00:00		None		2008-12-31 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		None		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2010-06-30 00:00:00		2010-12-31 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2014-02-07 00:00:00		2012-06-30 00:00:00		2014-12-31 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2014-08-14 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2010-12-31 00:00:00		2010-06-30 00:00:00		2009-12-31 00:00:00		2012-06-30 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2009-09-30 00:00:00		2011-12-31 00:00:00		2014-04-28 00:00:00		2013-12-31 00:00:00		2014-04-25 00:00:00		2013-12-31 00:00:00		2014-05-13 00:00:00		2014-04-15 00:00:00		2014-04-15 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		2013-03-31 00:00:00		2015-06-30 00:00:00		2017-12-31 00:00:00		2015-09-30 00:00:00		2015-09-30 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-04-26 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-12-31 00:00:00
rpt_date		None		None		None		None		None		None		2002-01-10 00:00:00		None		None		2004-01-07 00:00:00		2005-01-15 00:00:00		None		2006-01-06 00:00:00		2005-10-12 00:00:00		None		2006-06-02 00:00:00		2006-07-11 00:00:00		None		None		2006-06-05 00:00:00		2007-01-23 00:00:00		2007-01-23 00:00:00		None		None		None		None		2008-01-03 00:00:00		2013-07-31 00:00:00		None		None		2015-02-13 00:00:00		2015-04-10 00:00:00		2015-07-21 00:00:00		2014-07-29 00:00:00		2014-06-03 00:00:00		2013-07-31 00:00:00		2013-12-09 00:00:00		2013-10-16 00:00:00		2013-10-18 00:00:00		2015-03-06 00:00:00		None		2015-02-17 00:00:00		2015-03-04 00:00:00		2015-03-05 00:00:00		2014-10-14 00:00:00		2014-08-27 00:00:00		2014-09-09 00:00:00		2014-10-22 00:00:00		2008-05-23 00:00:00		2008-05-27 00:00:00		None		None		2008-10-23 00:00:00		None		None		2009-01-20 00:00:00		None		2009-10-08 00:00:00		None		2009-07-01 00:00:00		2010-01-06 00:00:00		None		None		None		2010-07-02 00:00:00		2011-01-19 00:00:00		2011-01-19 00:00:00		2011-07-05 00:00:00		None		None		2011-10-17 00:00:00		2012-01-17 00:00:00		None		None		None		2012-07-25 00:00:00		None		2014-01-28 00:00:00		2014-02-07 00:00:00		None		2015-01-20 00:00:00		2012-12-20 00:00:00		2012-12-20 00:00:00		2012-12-20 00:00:00		2012-12-20 00:00:00		2012-12-20 00:00:00		2012-12-20 00:00:00		2012-12-20 00:00:00		2012-12-20 00:00:00		2014-08-14 00:00:00		None		2013-01-30 00:00:00		None		None		None		None		None		None		None		None		2014-04-28 00:00:00		2014-04-25 00:00:00		2014-04-25 00:00:00		None		2014-05-13 00:00:00		2014-04-15 00:00:00		2014-04-15 00:00:00		None		2013-04-11 00:00:00		None		None		2018-01-17 00:00:00		None		2015-10-19 00:00:00		2016-01-19 00:00:00		None		2016-04-26 00:00:00		None		2016-07-18 00:00:00		2016-09-30 00:00:00		2017-01-23 00:00:00		None		None
filing_type		None		None		None		None		None		None		None		None		None		22001		22001		None		22001		22001		None		22001		22001		None		None		22001		22001		22001		None		None		None		None		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		None		None		22001		None		22001		None		22001		22001		None		None		None		22001		22001		22001		22001		None		None		22001		22001		None		None		None		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		None		None		None		None		None		None		None		None		22001		22001		22001		None		22001		22001		22001		None		22001		None		None		22001		None		22001		22001		None		22001		None		22001		22001		22001		None		None

Table: filer_to_filer_type

filer_id		1013270
filer_type		10
active		Y
race		0
session_id		2007
category		0
category_type		40502
sub_category		0
effect_dt		1995-02-27 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		None
county_cd		18026
district_cd		None

Table: filer_xref

filer_id		1013270
xref_id		495141
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		495141		495141		495141		495141		495141		495141
filer_id		1013270		1013270		1013270		1013270		1013270		1013270
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1995-02-27 00:00:00		1995-02-27 00:00:00		1995-02-27 00:00:00		1995-02-27 00:00:00		1995-02-27 00:00:00		1995-02-27 00:00:00
naml		LUXOTTICA, PARENT COMPANY OF LENSCRAFTERS		LUXOTTICA, PARENT COMPANY OF LENSCRAFTERS		LENSCRAFTERS, INC.		LENSCRAFTERS, INC.		LENSCRAFTERS		LENSCRAFTERS
namf		None		None		None		None		None		None
namt		None		None		None		None		None		None
nams		None		None		None		None		None		None
adr1		None		None		None		None		None		None
adr2		None		None		None		None		None		None
city		CINCINNATI		MASON		CINCINNATI		MASON		CINCINNATI		MASON
st		OH		OH		OH		OH		OH		OH
zip4		452420000		450408114		452420000		450408114		452420000		450408114
phon		5135836345		5137656345		5135836345		5137656345		5135836345		5137656345
fax		None		None		None		None		None		None
email		None		None		None		None		None		None

Table: filers

filer_id		1013270

Table: received_filings

filer_id		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270		1013270
filing_file_name		805237_0.cal		46305.cal		52698.cal		979106_0.cal		1072893_0.cal		1128144_0.cal		1142034_0.cal		1178716_0.cal		1178716_1.cal		1183861_0.cal		1336365_0.cal		1499305_0.cal		1391086_0.cal		1458460_0.cal		1447392_0.cal		1231565_0.cal		1431052_0.cal		1302730_0.cal		157729.cal		1336365_1.cal		1842943_0.cal		1858243_0.cal		1737141_0.cal		1838771_0.cal		1838646_0.cal		1618024_0.cal		1499305_1.cal		1565912_0.cal		1821044_0.cal		1629499_0.cal		1447392_1.cal		1458460_1.cal		1499305_2.cal		1565912_1.cal		1618024_1.cal		1629499_1.cal		1674819_1.cal		1674819_0.cal		2083991_0.cal		1877741_0.cal		1883539_0.cal		1880940_0.cal		1898139_0.cal		1902578_0.cal		2032780_0.cal		1942362_1.cal		1950560_0.cal		1942362_2.cal		1950560_1.cal		1942362_0.cal
received_date		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2004-01-09 00:00:00		2005-01-18 00:00:00		2005-10-14 00:00:00		2006-01-16 00:00:00		2006-06-02 00:00:00		2006-06-05 00:00:00		2006-07-13 00:00:00		2008-05-23 00:00:00		2010-07-06 00:00:00		2009-01-22 00:00:00		2010-01-19 00:00:00		2009-10-09 00:00:00		2007-01-25 00:00:00		2009-07-15 00:00:00		2008-01-09 00:00:00		2008-05-27 00:00:00		2008-05-27 00:00:00		2014-04-28 00:00:00		2014-06-03 00:00:00		2013-01-30 00:00:00		2014-04-16 00:00:00		2014-04-15 00:00:00		2011-10-18 00:00:00		2011-01-25 00:00:00		2011-01-25 00:00:00		2014-02-07 00:00:00		2012-01-19 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-12-21 00:00:00		2012-07-26 00:00:00		2016-09-30 00:00:00		2014-08-14 00:00:00		2014-09-09 00:00:00		2014-08-27 00:00:00		2014-10-14 00:00:00		2014-10-22 00:00:00		2016-04-26 00:00:00		2015-02-18 00:00:00		2015-03-04 00:00:00		2015-03-06 00:00:00		2015-03-05 00:00:00		2015-02-13 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		805237		None		None		979106		1072893		1128144		1142034		1178716		1178716		1183861		1336365		1499305		1391086		1458460		1447392		1231565		1431052		1302730		None		1336365		1842943		1858243		1737141		1838771		1838646		1618024		1499305		1565912		1821044		1629499		1447392		1458460		1499305		1565912		1618024		1629499		1674819		1674819		2083991		1877741		1883539		1880940		1898139		1902578		2032780		1942362		1950560		1942362		1950560		1942362
form_id		F461		None		None		F461		F461		F461		F461		F497		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		None		F497		F497		F497		F461		F497		F497		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing 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