Home

Filer ID: 1010222

Table: filer_address

filer_id		1010222		1010222		1010222		1010222
adrid		1009515		2120948		2172291		2428346
effect_dt		1990-12-01 00:00:00		2008-01-31 00:00:00		2009-08-25 00:00:00		2017-01-31 00:00:00
add_type		7051		7051		7082		7051
session_id		1989		2007		2009		2015

Table: filer_filings

filer_id		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222
filing_id		64472		64473		64474		64475		64476		64477		64478		64479		64481		64482		64483		64484		64486		64487		64488		64489		64490		64491		64492		203449		203450		203452		203451		64480		64485		592479		609326		595287		595421		622918		673101		685217		682547		645109		683395		684030		685621		717784		683759		763175		749020		745487		786251		791981		772213		788539		804677		829059		645109		717784		834133		834134		834133		834134		832926		829208		859869		882581		881308		889120		855440		879078		888062		888274		876593		917300		883887		931423		911144		947114		954648		936894		979743		959156		992210		1031295		1038157		1054668		1060040		1093622		1080959		1093622		1061834		1121298		1105921		1118464		1147552		1180462		1177445		1147552		1190920		1301618		1219429		1252736		1235339		1180462		1283848		1288489		1981463		1935146		1940140		1309624		1312949		1350215		1352702		1374360		1401612		1376958		1423164		1423670		1437332		1397877		1452906		1453830		1442959		1469186		1463774		1511565		1507029		1532285		1544480		1576330		1580568		1609895		1606146		1635756		1638931		1822369		1818635		1682465		1680289		1740535		1744751		1984201		2397620		2440686		2071541		2062921		2130679		2142721		2348188		2380188		2367505		2464216		2404407		2382494		2707197		2715610		2659005
period_id		99		105		113		115		121		129		133		137		145		145		145		145		147		149		153		156		155		157		158		121		137		148		145		141		148		161		None		None		161		None		None		164		164		161		None		None		None		163		164		None		None		165		167		None		166		None		168		169		161		163		None		None		None		None		None		None		None		None		172		None		169		None		172		None		172		None		172		173		171		174		None		None		175		0		None		177		None		180		None		None		179		None		180		None		None		182		183		None		186		183		185		None		None		None		187		None		189		None		221		217		None		191		None		193		None		196		None		None		198		None		197		195		199		None		None		None		200		None		201		204		None		203		None		None		205		207		None		None		213		None		209		211		None		None		238		239		None		225		227		None		233		237		None		None		None		None		249		None		249
form_id		F461		F461		F461		F461		F405		F461		F461		F461		F497		F497		F461		F405		F461		F461		F461		F497		F461		F461		F461		F461		F461		F497		F497		F461		F497		F497		F461		F497		F497		F999		F461		F497		F497		F461		F497		F497		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F497		F461		F461		F497		F497		F497		F461		F497		F497		F497		F497		F461		F497		F461		F461		F461		F461		F461		F461		E530		F461		F461		F461		F497		F497		F461		F461		F461		F497		F461		F461		F461		F461		F461		F497		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1984-09-21 00:00:00		1987-02-03 00:00:00		1989-03-03 00:00:00		1989-03-02 00:00:00		1991-10-21 00:00:00		1993-02-01 00:00:00		1994-01-31 00:00:00		1995-02-17 00:00:00		1996-03-20 00:00:00		1996-03-21 00:00:00		1996-07-31 00:00:00		1996-08-26 00:00:00		1997-01-31 00:00:00		1998-02-25 00:00:00		1998-07-31 00:00:00		1998-10-23 00:00:00		1999-02-01 00:00:00		1999-04-29 00:00:00		1999-08-02 00:00:00		1991-01-31 00:00:00		1995-02-21 00:00:00		1996-10-24 00:00:00		1996-03-18 00:00:00		1996-01-31 00:00:00		1996-10-25 00:00:00		2000-02-24 00:00:00		2000-01-31 00:00:00		2000-02-24 00:00:00		2000-02-28 00:00:00		2000-02-24 00:00:00		2000-07-31 00:00:00		2000-11-03 00:00:00		2000-10-31 00:00:00		2000-07-31 00:00:00		2000-10-31 00:00:00		2000-11-01 00:00:00		2000-11-03 00:00:00		2001-01-30 00:00:00		2000-11-01 00:00:00		2001-04-30 00:00:00		2001-01-31 00:00:00		2001-04-30 00:00:00		2001-10-10 00:00:00		2001-07-03 00:00:00		2001-07-30 00:00:00		2001-10-10 00:00:00		2002-01-10 00:00:00		2002-03-05 00:00:00		2002-03-19 00:00:00		2002-03-19 00:00:00		2002-03-20 00:00:00		2002-03-20 00:00:00		2002-03-20 00:00:00		2002-03-20 00:00:00		2002-03-05 00:00:00		2002-01-10 00:00:00		2002-07-31 00:00:00		2002-10-28 00:00:00		2002-10-28 00:00:00		2002-11-04 00:00:00		2002-07-31 00:00:00		2002-10-22 00:00:00		2002-11-04 00:00:00		2002-10-30 00:00:00		2002-10-22 00:00:00		2003-01-31 00:00:00		2002-10-30 00:00:00		2003-04-30 00:00:00		2003-01-30 00:00:00		2003-07-31 00:00:00		2003-07-31 00:00:00		2003-04-30 00:00:00		2004-01-12 00:00:00		2003-09-23 00:00:00		2004-01-12 00:00:00		2004-08-01 00:00:00		2004-07-30 00:00:00		2004-10-26 00:00:00		2004-10-26 00:00:00		2005-02-01 00:00:00		2005-01-31 00:00:00		2005-01-31 00:00:00		2004-11-12 00:00:00		2005-08-01 00:00:00		2005-05-02 00:00:00		2005-08-01 00:00:00		2006-01-31 00:00:00		2006-01-31 00:00:00		2006-05-31 00:00:00		2006-05-31 00:00:00		2006-07-31 00:00:00		2006-05-31 00:00:00		2006-07-31 00:00:00		2007-01-31 00:00:00		2007-01-30 00:00:00		2006-07-25 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2015-07-31 00:00:00		2015-01-31 00:00:00		2015-01-30 00:00:00		2008-01-30 00:00:00		2008-01-31 00:00:00		2008-07-31 00:00:00		2008-07-31 00:00:00		2008-10-28 00:00:00		2009-02-02 00:00:00		2008-10-28 00:00:00		2009-05-07 00:00:00		2009-05-07 00:00:00		2009-07-31 00:00:00		2009-02-02 00:00:00		2009-11-02 00:00:00		2009-11-02 00:00:00		2009-07-31 00:00:00		2010-02-01 00:00:00		2010-01-30 00:00:00		2010-08-02 00:00:00		2010-08-01 00:00:00		2010-10-22 00:00:00		2010-10-22 00:00:00		2011-02-09 00:00:00		2011-02-09 00:00:00		2011-07-29 00:00:00		2011-07-29 00:00:00		2012-01-31 00:00:00		2012-01-30 00:00:00		2014-01-31 00:00:00		2014-01-31 00:00:00		2012-07-31 00:00:00		2012-07-31 00:00:00		2013-01-31 00:00:00		2013-01-31 00:00:00		2015-07-31 00:00:00		2019-07-31 00:00:00		2020-01-30 00:00:00		2016-08-01 00:00:00		2016-07-31 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2019-01-31 00:00:00		2019-04-30 00:00:00		2019-01-31 00:00:00		2020-01-30 00:00:00		2019-07-31 00:00:00		2019-04-30 00:00:00		2022-08-01 00:00:00		2022-08-01 00:00:00		2022-03-21 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10001		10005		10001		10005		10001		10001		10002		10002		10005		10005		10006		10006		10005		10005		10005		10005		10001		10005		10001		10005		10001		10005		10001		10005		10001		10001		10001		10001		10005		10005		10001		10001		10005		10001		10005		10001		10005		10006		10001		10005		10001		10005		10005		10001		10001		10005		10001		10002		10001		10005		10005		10005		10001		10006		10001		10005		10001		10001		10005		10001		10005		10001		10005		10001		10005		10005		10001		10005		10001		10001		10001		10005		10005		10005		10001		10005		10001		10001		10005		10001		10005		10005		10001		10001		10005		10005		10001		10005		10001		10001		10005		10005		10001		10001		10005		10001		10001		10005		10001		10001		10005		10005		10005		10005		10001		10005		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11003		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		11001		11001		11001		11001		11003
session_id		1983		1985		1987		1987		1989		1991		1993		1993		1995		1995		1995		1995		1995		1997		1997		1997		1997		1999		1999		1989		1993		1995		1995		1995		1995		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		1999		2001		2001		2001		2001		2001		2001		2001		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2015		2013		2013		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2013		2013		2011		2011		2011		2011		2015		2019		2019		2015		2015		2015		2015		2017		2019		2019		2019		2019		2019		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		*		*		KCHAN		BSMITH		*		*		BSMITH		SARRIAGA		CFLAGG		GPEREZ		BSMITH		*		YBONILLA		BSMITH		*		*		ERUTH		*		JBRANNON		*		*		*		*		DBARRICK		LTHIBAUL		LTHIBAUL		MKIENG		RALLMOND		YBONILLA		LTHIBAUL		CFLAGG		*		DHORRELL		*		KLARRY		*		BSMITH		*		DHORRELL		*		COMPLETED		COMPLETED		COMPLETED		GGILMORE		DBARRICK		COMPLETED		*		GKURIMOT		COMPLETED		DHORRELL		GKURIMOT		LLEONG		DHORRELL		COMPLETED		DHORRELL		COMPLETED		KLARRY		DHORRELL		*		*		GGILMORE		*		*		*		PHOANG		JMARTIN		JMARTIN		*		JMARTIN		*		JMARTIN		JINGRAM		JINGRAM		JINGRAM		*		SMCCABE		MGUERRA		MGUERRA		PBANFORD		JINGRAM		EMCENTEE		DHORRELL		GKURIMOT		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		CREYNOLDS		MPACHECO		TBOWMAN		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		GTAYLOR		GTAYLOR		JINGRAM		JINGRAM		JINGRAM		JINGRAM		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11001		11001		11003
rpt_start		None		1986-01-01 00:00:00		1988-01-01 00:00:00		1988-07-01 00:00:00		1990-01-01 00:00:00		1992-01-01 00:00:00		1993-01-01 00:00:00		1994-01-01 00:00:00		None		None		1996-01-01 00:00:00		1996-01-01 00:00:00		1996-07-01 00:00:00		1997-01-01 00:00:00		1998-01-01 00:00:00		None		1998-07-01 00:00:00		1999-01-01 00:00:00		1999-04-01 00:00:00		1990-01-01 00:00:00		1994-01-01 00:00:00		None		None		1995-01-01 00:00:00		None		2000-02-24 00:00:00		1999-07-01 00:00:00		None		2000-02-24 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-11-03 00:00:00		2000-10-31 00:00:00		2000-01-01 00:00:00		None		None		None		2000-07-01 00:00:00		2000-11-01 00:00:00		2001-01-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-07-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		2002-03-05 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		None		2001-10-01 00:00:00		2002-01-01 00:00:00		None		2002-10-28 00:00:00		None		2002-01-01 00:00:00		None		2002-11-04 00:00:00		None		2002-10-22 00:00:00		2002-07-01 00:00:00		2002-10-30 00:00:00		2003-01-01 00:00:00		2002-07-01 00:00:00		2003-04-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-09-22 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-10-26 00:00:00		None		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-11-12 00:00:00		2005-04-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2006-05-31 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		None		2006-01-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2005-07-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2015-01-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-10-28 00:00:00		2008-07-01 00:00:00		None		2009-05-07 00:00:00		None		2009-01-01 00:00:00		2008-07-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2009-01-01 00:00:00		2009-10-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-10-22 00:00:00		None		2010-07-01 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2015-01-01 00:00:00		2019-04-01 00:00:00		2019-07-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2018-01-01 00:00:00		2019-07-01 00:00:00		2019-04-01 00:00:00		2019-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-03-21 00:00:00
rpt_end		1984-09-17 00:00:00		1986-12-31 00:00:00		1988-06-30 00:00:00		1988-12-31 00:00:00		1990-12-31 00:00:00		1992-12-31 00:00:00		1993-12-31 00:00:00		1994-12-31 00:00:00		None		None		1996-06-30 00:00:00		1996-06-30 00:00:00		1996-12-31 00:00:00		1997-12-31 00:00:00		1998-06-30 00:00:00		None		1998-12-31 00:00:00		1999-03-31 00:00:00		1999-06-30 00:00:00		1990-12-31 00:00:00		1994-12-31 00:00:00		None		None		1995-12-31 00:00:00		None		2000-02-24 00:00:00		1999-12-31 00:00:00		None		2000-02-24 00:00:00		2000-12-31 00:00:00		2000-06-30 00:00:00		2000-11-03 00:00:00		2000-10-31 00:00:00		2000-06-30 00:00:00		None		None		None		2000-12-31 00:00:00		2000-11-01 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2001-09-30 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		2002-03-05 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		None		2001-12-31 00:00:00		2002-06-30 00:00:00		None		2002-10-28 00:00:00		None		2002-06-30 00:00:00		None		2002-11-04 00:00:00		None		2002-10-22 00:00:00		2002-12-31 00:00:00		2002-10-30 00:00:00		2003-03-31 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2003-12-31 00:00:00		2003-09-22 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-10-26 00:00:00		None		2004-12-31 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2004-11-12 00:00:00		2005-06-30 00:00:00		2005-03-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-05-31 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		None		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2005-12-31 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		2015-06-30 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-10-28 00:00:00		2008-12-31 00:00:00		None		2009-05-07 00:00:00		None		2009-06-30 00:00:00		2008-12-31 00:00:00		2009-09-30 00:00:00		2009-09-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-10-22 00:00:00		None		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2015-06-30 00:00:00		2019-06-30 00:00:00		2019-12-31 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2018-12-31 00:00:00		2019-03-31 00:00:00		2018-12-31 00:00:00		2019-12-31 00:00:00		2019-06-30 00:00:00		2019-03-31 00:00:00		2022-06-30 00:00:00		2022-06-30 00:00:00		2022-03-21 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		2000-02-24 00:00:00		None		None		2000-02-24 00:00:00		None		None		2000-11-03 00:00:00		2000-10-31 00:00:00		2000-07-25 00:00:00		2000-10-31 00:00:00		2000-11-01 00:00:00		2000-11-03 00:00:00		2001-01-30 00:00:00		2000-11-01 00:00:00		None		None		2001-04-27 00:00:00		2001-10-03 00:00:00		None		2001-07-18 00:00:00		None		2002-01-03 00:00:00		2002-03-05 00:00:00		2002-03-18 00:00:00		2002-03-18 00:00:00		None		None		None		None		None		None		None		None		2002-10-28 00:00:00		None		2002-07-25 00:00:00		None		2002-11-04 00:00:00		None		2002-10-22 00:00:00		None		2002-10-30 00:00:00		2003-04-21 00:00:00		2003-01-17 00:00:00		2003-07-24 00:00:00		None		None		2004-01-08 00:00:00		None		None		2004-07-27 00:00:00		None		2004-10-26 00:00:00		None		None		2005-01-20 00:00:00		None		2004-11-12 00:00:00		None		None		2005-07-26 00:00:00		2006-01-24 00:00:00		None		2006-05-31 00:00:00		2006-04-27 00:00:00		2006-07-21 00:00:00		None		None		None		2007-01-23 00:00:00		None		2007-07-22 00:00:00		None		2015-07-30 00:00:00		2015-01-24 00:00:00		None		2008-01-29 00:00:00		None		2008-07-22 00:00:00		None		2008-10-28 00:00:00		None		None		2009-05-07 00:00:00		None		2009-07-24 00:00:00		2009-01-26 00:00:00		2009-10-26 00:00:00		None		None		None		2010-01-30 00:00:00		None		2010-07-26 00:00:00		2010-10-22 00:00:00		None		2011-02-09 00:00:00		None		None		2011-07-20 00:00:00		2012-01-27 00:00:00		None		None		2014-01-27 00:00:00		None		2012-07-31 00:00:00		2013-01-31 00:00:00		None		None		2019-07-22 00:00:00		2020-01-21 00:00:00		None		2016-07-27 00:00:00		2017-01-30 00:00:00		None		2019-01-31 00:00:00		2019-04-25 00:00:00		None		None		None		None		2022-07-28 00:00:00		None		2022-03-21 00:00:00
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		22001		22001		None		None		22001		None		None		22001		None		22001		None		None		22001		None		22001		None		None		22001		22001		None		22001		22001		22001		None		None		None		22001		None		22001		None		22001		22001		None		22001		None		22001		None		22001		None		None		22001		None		22001		22001		22001		None		None		None		22001		None		22001		22001		None		22001		None		None		22001		22001		None		None		22001		None		22001		22001		None		None		22001		22001		None		22001		22001		None		22001		22001		None		None		None		None		22001		None		22001

Table: filer_to_filer_type

filer_id		1010222
filer_type		10
active		Y
race		0
session_id		2007
category		0
category_type		40502
sub_category		0
effect_dt		1990-12-01 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		0
county_cd		18004
district_cd		0

Table: filer_xref

filer_id		1010222
xref_id		484234
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		484234		484234		484234
filer_id		1010222		1010222		1010222
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00
naml		INTEL CORPORATION		INTEL CORPORATION		INTEL CORPORATION
namf		None		None		None
namt		None		None		None
nams		None		None		None
adr1		None		None		None
adr2		None		None		None
city		FOLSOM		FOLSOM		FOLSOM
st		CA		CA		CA
zip4		956300000		956300000		95630
phon		9163566122		9163566122		9163774120
fax		None		None		None
email		None		None		None

Table: filers

filer_id		1010222

Table: received_filings

filer_id		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222		1010222
filing_file_name		592479_0.cal		645109_0.cal		682547_0.cal		685217_0.cal		683759_0.cal		27126.cal		717784_0.cal		745487_0.cal		786251_0.cal		772213_0.cal		804677_0.cal		829059_0.cal		645109_1.cal		717784_1.cal		855440_0.cal		881308_0.cal		876593_0.cal		888062_0.cal		883887_0.cal		911144_0.cal		947114_0.cal		931423_0.cal		979743_0.cal		1031295_0.cal		1054668_0.cal		1080959_0.cal		1118464_0.cal		1147552_0.cal		1147552_1.cal		1190920_0.cal		1507029_0.cal		1397877_0.cal		1350215_0.cal		1463774_0.cal		1452906_0.cal		1235339_0.cal		1283848_0.cal		1437332_0.cal		1309624_0.cal		1740535_0.cal		1680289_0.cal		1606146_0.cal		1576330_0.cal		1635756_0.cal
received_date		2000-02-24 00:00:00		2000-07-31 00:00:00		2000-10-31 00:00:00		2000-11-03 00:00:00		2000-11-01 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-04-30 00:00:00		2001-10-10 00:00:00		2001-07-30 00:00:00		2002-01-10 00:00:00		2002-03-05 00:00:00		2002-03-19 00:00:00		2002-03-19 00:00:00		2002-07-31 00:00:00		2002-10-28 00:00:00		2002-10-22 00:00:00		2002-11-04 00:00:00		2002-10-30 00:00:00		2003-01-30 00:00:00		2003-07-31 00:00:00		2003-04-30 00:00:00		2004-01-12 00:00:00		2004-08-01 00:00:00		2004-10-26 00:00:00		2005-01-31 00:00:00		2005-08-01 00:00:00		2006-01-31 00:00:00		2006-05-31 00:00:00		2006-07-31 00:00:00		2010-08-01 00:00:00		2009-02-02 00:00:00		2008-07-31 00:00:00		2010-01-30 00:00:00		2009-11-02 00:00:00		2007-01-30 00:00:00		2007-07-31 00:00:00		2009-07-31 00:00:00		2008-01-30 00:00:00		2013-01-31 00:00:00		2012-07-31 00:00:00		2011-07-29 00:00:00		2011-02-09 00:00:00		2012-01-31 00:00:00
filing_directory		/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		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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		592479		645109		682547		685217		683759		None		717784		745487		786251		772213		804677		829059		645109		717784		855440		881308		876593		888062		883887		911144		947114		931423		979743		1031295		1054668		1080959		1118464		1147552		1147552		1190920		1507029		1397877		1350215		1463774		1452906		1235339		1283848		1437332		1309624		1740535		1680289		1606146		1576330		1635756
form_id		F497		F461		F497		F497		F497		None		F461		F461		F461		F461		F461		F497		F461		F461		F461		F497		F497		F497		F497		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461
receive_comment		Filing accepted, but but with warnings		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing did not pass validation		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing 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