Home

Filer ID: 1011044

Table: filer_address

filer_id		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044
adrid		1010368		2027986		2066822		2421692		2401464		2235589		2474124		2282376		2364617		2350056		2379736		2374816
effect_dt		1990-12-01 00:00:00		2002-01-31 00:00:00		2008-03-04 00:00:00		2017-01-19 00:00:00		2016-07-19 00:00:00		2012-04-24 00:00:00		2019-01-29 00:00:00		2013-01-18 00:00:00		2015-07-27 00:00:00		2015-02-02 00:00:00		2016-01-20 00:00:00		2015-10-20 00:00:00
add_type		7051		7082		7082		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1989		2001		2007		2017		2015		2011		2019		2013		2015		2015		2015		2015

Table: filer_filings

filer_id		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044
filing_id		68555		68556		68558		68559		68560		68561		68562		68563		68564		68565		68566		68567		68568		68569		68570		68571		68572		68573		68574		68575		204033		204034		204035		204036		68557		68576		613481		675255		747557		774207		784822		814480		845678		821972		832566		832651		840030		827382		827393		821972		825575		828240		828644		829335		829336		881649		857511		891490		891495		877797		857511		853466		840030		918640		918641		918642		918643		918644		880290		853466		909341		881649		909341		853466		840030		948462		983540		955737		978678		957766		956842		969148		970698		998191		1002947		1004762		997463		997464		1001763		1031531		1013657		1038177		1014619		1056922		1055289		1080837		1038177		1014619		1056922		1092354		1092354		1055289		1080837		1031531		1013657		1122082		1080837		1118995		1132542		1118995		1118995		1122082		1122082		1134460		1080837		1092354		1092354		1056922		1055289		1167520		1167520		1132542		1148332		1168705		1168705		1148332		1179845		1203741		1203614		1179840		1218870		1191339		1218430		1222353		1222354		1219181		1254011		1238524		1191339		1238524		1283853		1270017		1297446		1286578		1080837		1092354		1271167		1780596		1769812		1785373		1869249		1865267		1936653		1936653		1956253		1956253		1283853		1297446		1315456		1311565		1295136		1297446		1311565		1315456		1286578		1349588		1283853		1338974		1336593		1337967		1315456		1315456		1286578		1370065		1371638		1352768		1338045		1381303		1380681		1378705		1394058		1395292		1375880		1394058		1394058		1395292		1395292		1134460		1446184		1446184		1436292		1452914		1452008		1462307		1465878		1512070		1544032		1536865		1570470		1582187		1603255		1606158		1635034		1639343		1635034		1825975		1825975		1814397		1674747		1639343		1681152		1899044		1700768		1702104		1706214		1882458		1734827		1814397		1841199		1749083		1992825		1997989		1977701		1983299		2366558		2004918		2014135		2066400		2066400		2056017		2076104		2072939		2056017		2078682		2079561		2087355		2099932		2120745		2133439		2342482		2366558		2342482
period_id		105		109		113		115		117		121		123		125		133		137		139		145		147		145		147		148		151		153		155		157		129		145		145		151		111		155		None		None		None		165		None		167		None		169		None		None		169		169		169		169		169		None		None		None		None		171		None		None		None		172		None		170		169		None		None		None		None		None		None		170		172		171		172		170		169		173		None		None		176		175		175		175		None		None		177		None		177		177		None		178		177		None		None		None		179		180		None		None		None		None		None		179		180		178		177		None		180		181		183		181		181		None		None		None		180		None		None		None		179		185		185		183		184		None		None		184		None		188		188		None		188		186		188		None		None		None		None		187		186		187		189		None		191		None		180		None		None		213		214		None		None		217		219		219		None		None		189		191		None		192		None		191		192		None		None		193		189		None		194		194		None		None		None		196		None		None		None		None		196		None		195		None		196		195		195		None		None		None		None		None		197		None		199		200		None		None		None		204		203		None		205		None		207		None		207		None		None		215		209		None		None		220		212		212		212		219		211		215		218		None		223		None		221		None		None		224		None		None		None		225		227		227		225		227		227		228		228		227		None		235		None		233
form_id		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F405		F461		F405		F461		F461		F461		F461		F461		F461		F461		F461		F405		F405		F461		F405		F461		F461		F461		F461		F461		F461		F461		F497		F497		F496		F461		F497		F496		F497		F497		F497		F461		F497		F497		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F497		F497		F497		F497		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		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F497		F461		F497		F497		F497		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F497		F497		F497		F461		F461		F461		F497		F497		F461		F497		F497		F497		F497		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F497		F497		F497		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F497		F497		F497		F497		F461		F461		F461		F461		F461
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		1		0		0		0		0		0		0		1		0		0		0		0		0		1		0		0		0		0		0		0		1		0		1		1		2		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		1		1		0		1		1		1		1		0		2		0		0		2		1		1		2		0		3		2		3		2		2		0		1		1		1		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		0		0		4		4		0		0		0		0		0		0		0		1		0		1		1		1		0		0		0		2		1		1		1		0		2		0		0		0		2		3		2		0		0		0		0		0		0		0		0		0		0		1		2		3		1		1		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		0		0		1		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		1		0		1		0		0		0		0		0		0		0		0		0		0		1		1
filing_date		1987-08-28 00:00:00		1987-10-08 00:00:00		1988-07-26 00:00:00		1989-01-26 00:00:00		1990-01-24 00:00:00		1990-07-30 00:00:00		1991-01-22 00:00:00		1992-01-22 00:00:00		1994-04-05 00:00:00		1994-08-01 00:00:00		1995-01-31 00:00:00		1996-08-05 00:00:00		1996-12-31 00:00:00		1996-12-31 00:00:00		1997-01-03 00:00:00		1997-07-14 00:00:00		1998-01-23 00:00:00		1998-07-23 00:00:00		1999-02-26 00:00:00		1999-07-27 00:00:00		1993-01-25 00:00:00		1996-07-31 00:00:00		1997-01-03 00:00:00		1998-02-10 00:00:00		1988-01-19 00:00:00		1999-07-27 00:00:00		2000-01-31 00:00:00		2000-07-28 00:00:00		2001-01-31 00:00:00		2001-08-06 00:00:00		2001-07-31 00:00:00		2002-01-31 00:00:00		2002-05-01 00:00:00		2002-02-21 00:00:00		2002-02-28 00:00:00		2002-02-28 00:00:00		2002-04-30 00:00:00		2002-02-28 00:00:00		2002-02-28 00:00:00		2002-02-25 00:00:00		2002-02-25 00:00:00		2002-02-21 00:00:00		2002-01-31 00:00:00		2002-02-25 00:00:00		2002-02-25 00:00:00		2002-10-29 00:00:00		2002-07-30 00:00:00		2002-10-29 00:00:00		2002-10-29 00:00:00		2002-10-24 00:00:00		2002-07-30 00:00:00		2002-07-29 00:00:00		2002-07-29 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2002-10-24 00:00:00		2002-10-29 00:00:00		2003-01-30 00:00:00		2003-02-03 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-08-01 00:00:00		2004-01-08 00:00:00		2003-07-31 00:00:00		2004-01-08 00:00:00		2003-09-04 00:00:00		2003-08-27 00:00:00		2003-10-30 00:00:00		2003-10-30 00:00:00		2004-02-19 00:00:00		2004-02-27 00:00:00		2004-02-27 00:00:00		2004-02-20 00:00:00		2004-02-20 00:00:00		2004-02-20 00:00:00		2004-08-02 00:00:00		2004-04-30 00:00:00		2004-07-30 00:00:00		2004-04-30 00:00:00		2004-10-27 00:00:00		2004-10-27 00:00:00		2005-01-31 00:00:00		2005-02-08 00:00:00		2004-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-01-31 00:00:00		2005-02-08 00:00:00		2005-02-10 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-08-01 00:00:00		2005-12-14 00:00:00		2005-08-01 00:00:00		2005-10-28 00:00:00		2005-10-28 00:00:00		2005-08-11 00:00:00		2005-08-15 00:00:00		2005-10-28 00:00:00		2005-10-28 00:00:00		2005-12-16 00:00:00		2005-12-16 00:00:00		2005-12-16 00:00:00		2005-12-16 00:00:00		2005-12-14 00:00:00		2006-05-01 00:00:00		2006-05-01 00:00:00		2006-01-31 00:00:00		2006-02-07 00:00:00		2006-05-01 00:00:00		2006-05-01 00:00:00		2006-01-31 00:00:00		2005-01-31 00:00:00		2006-10-04 00:00:00		2006-10-03 00:00:00		2005-01-31 00:00:00		2006-11-02 00:00:00		2006-07-31 00:00:00		2006-11-02 00:00:00		2003-08-28 00:00:00		2003-09-04 00:00:00		2006-07-31 00:00:00		2007-01-31 00:00:00		2007-01-31 00:00:00		2007-05-29 00:00:00		2007-05-29 00:00:00		2007-07-31 00:00:00		2007-04-26 00:00:00		2007-10-31 00:00:00		2007-07-31 00:00:00		2007-08-22 00:00:00		2007-08-22 00:00:00		2006-11-02 00:00:00		2013-07-30 00:00:00		2013-06-04 00:00:00		2013-07-30 00:00:00		2014-07-23 00:00:00		2014-07-23 00:00:00		2015-02-02 00:00:00		2015-02-02 00:00:00		2015-02-02 00:00:00		2015-03-02 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2006-11-02 00:00:00		2008-03-04 00:00:00		2008-03-04 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-07-30 00:00:00		2008-03-04 00:00:00		2008-05-28 00:00:00		2008-05-24 00:00:00		2008-05-28 00:00:00		2008-03-04 00:00:00		2008-03-04 00:00:00		2008-03-04 00:00:00		2008-10-23 00:00:00		2008-10-24 00:00:00		2008-07-31 00:00:00		2008-05-24 00:00:00		2008-11-06 00:00:00		2008-11-05 00:00:00		2008-10-30 00:00:00		2009-01-29 00:00:00		2009-01-29 00:00:00		2008-10-30 00:00:00		2009-04-29 00:00:00		2009-07-30 00:00:00		2009-07-30 00:00:00		2009-04-30 00:00:00		2006-01-31 00:00:00		2006-01-31 00:00:00		2006-02-10 00:00:00		2009-07-30 00:00:00		2009-10-30 00:00:00		2009-10-30 00:00:00		2010-01-28 00:00:00		2010-01-28 00:00:00		2010-07-28 00:00:00		2010-10-27 00:00:00		2010-10-27 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2011-07-26 00:00:00		2011-07-26 00:00:00		2012-01-30 00:00:00		2012-01-31 00:00:00		2012-07-26 00:00:00		2014-02-13 00:00:00		2014-02-13 00:00:00		2014-01-28 00:00:00		2012-07-26 00:00:00		2012-07-26 00:00:00		2012-07-26 00:00:00		2014-10-16 00:00:00		2012-10-22 00:00:00		2012-10-24 00:00:00		2012-10-29 00:00:00		2014-09-04 00:00:00		2013-01-29 00:00:00		2014-02-13 00:00:00		2014-04-24 00:00:00		2013-01-31 00:00:00		2015-10-21 00:00:00		2015-10-27 00:00:00		2015-07-27 00:00:00		2015-07-28 00:00:00		2019-01-30 00:00:00		2016-01-20 00:00:00		2016-01-27 00:00:00		2016-07-25 00:00:00		2016-07-21 00:00:00		2016-07-21 00:00:00		2016-09-13 00:00:00		2016-08-31 00:00:00		2016-07-19 00:00:00		2016-09-17 00:00:00		2016-09-21 00:00:00		2016-10-11 00:00:00		2016-10-29 00:00:00		2017-01-19 00:00:00		2017-01-20 00:00:00		2019-01-29 00:00:00		2019-03-27 00:00:00		2019-03-25 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10005		10001		10005		10001		10005		10005		10001		10001		10001		10002		10001		10005		10005		10005		10005		10001		10006		10006		10005		10001		10005		10001		10002		10005		10006		10006		10006		10006		10005		10002		10001		10002		10002		10002		10002		10001		10005		10005		10001		10001		10001		10001		10005		10005		10001		10005		10001		10001		10005		10001		10001		10005		10005		10005		10001		10001		10006		10006		10006		10006		10005		10002		10002		10002		10002		10005		10002		10001		10001		10002		10002		10006		10006		10005		10002		10006		10006		10006		10002		10001		10002		10002		10002		10005		10006		10001		10005		10001		10001		10005		10001		10001		10001		10005		10005		10005		10005		10001		10002		10002		10001		10005		10001		10005		10002		10006		10005		10001		10001		10005		10005		10001		10001		10002		10005		10006		10002		10002		10005		10001		10005		10002		10002		10006		10006		10001		10002		10005		10001		10001		10006		10006		10006		10001		10005		10001		10005		10005		10001		10005		10001		10005		10001		10002		10002		10006		10006		10006		10005		10006		10001		10005		10001		10001		10005		10005		10005		10001		10001		10005		10001		10005		10001		10005		10002		10005		10006		10001		10001		10006		10005		10001		10001		10001		10001		10001		10001		10002		10001		10005		10001		10005		10001		10005		10005		10001		10005		10006		10005		10002		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10006		10002
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11001		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11003		11003		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		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		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		1985		1987		1987		1987		1989		1989		1989		1991		1993		1993		1993		1995		1995		1995		1995		1995		1997		1997		1997		1999		1991		1995		1995		1997		1987		1997		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		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		2005		2005		2005		2005		2005		2005		2005		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2003		2003		2005		2005		2005		2005		2005		2007		2005		2007		2007		2003		2003		2005		2013		2013		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2005		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2007		2007		2007		2009		2009		2005		2005		2005		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2013		2013		2013		2011		2011		2011		2013		2011		2011		2011		2013		2011		2013		2013		2011		2015		2015		2015		2015		2019		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2019		2017
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		KVOONG1		KVOONG1		*		DBARRICK		*		RALLMOND		*		RALLMOND		RALLMOND		*		*		*		*		*		RALLMOND		YBONILLA		KLARRY		KLARRY		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		*		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		DHORRELL		KLARRY		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		COMPLETED		COMPLETED		COMPLETED		CFLAGG		GGILMORE		COMPLETED		COMPLETED		COMPLETED		COMPLETED		DHORRELL		LLEONG		COMPLETED		GPEREZ		COMPLETED		COMPLETED		LLEONG		COMPLETED		COMPLETED		DHORRELL		DHORRELL		DHORRELL		COMPLETED		COMPLETED		DHORRELL		DHORRELL		DHORRELL		DHORRELL		DHORRELL		COMPLETED		COMPLETED		COMPLETED		COMPLETED		KLARRY		*		*		*		*		*		DHORRELL		DHORRELL		DHORRELL		*		DHORRELL		DHORRELL		DHORRELL		*		DHORRELL		DHORRELL		*		*		DHORRELL		DHORRELL		*		RFARAIMO		DHORRELL		*		RFARAIMO		DHORRELL		*		DHORRELL		LHOANG		LHOANG		JMARTIN		JMARTIN		*		*		*		*		RGEREMIA		*		JMARTIN		*		JMARTIN		RGEREMIA		JINGRAM		WBROWN		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		*		*		SMCCABE		*		RGEREMIA		*		*		SMCCABE		SMCCABE		SMCCABE		*		LHOANG		PBANFORD		DHORRELL		SMCCABE		SMCCABE		SMCCABE		PBANFORD		YRODRIGU		SMCCABE		LHOANG		RGEREMIA		PBANFORD		RGEREMIA		JINGRAM		JINGRAM		PBANFORD		*		*		JVAZQUEZ		JVAZQUEZ		NLANDERS		NLANDERS		NLANDERS		*		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		MPACHECO		SARRIAGA		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		WBROWN		WBROWN		WBROWN		WBROWN		WBROWN		JINGRAM		JINGRAM		WBROWN		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		GTAYLOR		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		GCLARA		GCLARA		JINGRAM		GCLARA		GCLARA		GCLARA		GCLARA		JINGRAM		JINGRAM		GTAYLOR		GTAYLOR		GTAYLOR
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11003		11003		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		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		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11001		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003
rpt_start		1986-01-01 00:00:00		1987-01-01 00:00:00		1988-01-01 00:00:00		1988-07-01 00:00:00		1989-01-01 00:00:00		1990-01-01 00:00:00		1990-07-01 00:00:00		1991-01-01 00:00:00		1993-01-01 00:00:00		1994-01-01 00:00:00		1994-07-01 00:00:00		1996-01-01 00:00:00		1996-07-01 00:00:00		1996-01-01 00:00:00		1996-07-01 00:00:00		1996-12-31 00:00:00		1997-07-01 00:00:00		1998-01-01 00:00:00		1998-07-01 00:00:00		1999-01-01 00:00:00		1992-01-01 00:00:00		1996-01-01 00:00:00		1996-01-01 00:00:00		1997-07-01 00:00:00		1987-07-01 00:00:00		1998-07-01 00:00:00		1999-07-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2002-02-21 00:00:00		None		None		2002-01-01 00:00:00		2002-02-28 00:00:00		2002-02-28 00:00:00		2002-02-25 00:00:00		2002-02-25 00:00:00		None		2001-07-01 00:00:00		None		None		2002-07-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-10-24 00:00:00		2002-04-01 00:00:00		2002-04-01 00:00:00		2002-01-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2002-07-01 00:00:00		2002-04-01 00:00:00		2002-01-01 00:00:00		None		2002-04-01 00:00:00		2002-10-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-04-01 00:00:00		2002-01-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		2003-09-04 00:00:00		2003-08-27 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		None		2004-02-27 00:00:00		None		2004-02-19 00:00:00		2004-02-20 00:00:00		None		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2005-01-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2005-10-01 00:00:00		2005-10-01 00:00:00		2006-10-04 00:00:00		2006-10-03 00:00:00		2005-07-01 00:00:00		2006-11-02 00:00:00		2006-04-01 00:00:00		2006-11-02 00:00:00		None		None		2006-04-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		None		2007-07-01 00:00:00		2007-01-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		None		2013-01-01 00:00:00		2013-06-04 00:00:00		2013-01-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2007-01-01 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2007-10-01 00:00:00		None		2007-07-01 00:00:00		2007-10-01 00:00:00		2007-07-01 00:00:00		2007-01-01 00:00:00		2008-01-01 00:00:00		2007-01-01 00:00:00		None		2008-05-24 00:00:00		2008-05-28 00:00:00		2007-10-01 00:00:00		2007-07-01 00:00:00		2007-01-01 00:00:00		2008-10-23 00:00:00		None		2008-01-01 00:00:00		None		None		2008-11-05 00:00:00		None		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-10-30 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2005-10-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		None		2010-10-27 00:00:00		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		2011-07-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2012-01-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2014-10-16 00:00:00		2012-10-22 00:00:00		2012-10-24 00:00:00		2012-10-29 00:00:00		2014-09-04 00:00:00		2012-07-01 00:00:00		2013-07-01 00:00:00		2014-04-24 00:00:00		2012-07-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2018-07-01 00:00:00		2015-10-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-09-13 00:00:00		2016-08-31 00:00:00		2016-01-01 00:00:00		2016-09-17 00:00:00		2016-09-21 00:00:00		2016-10-11 00:00:00		2016-10-29 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2018-01-01 00:00:00
rpt_end		1986-12-31 00:00:00		1987-06-30 00:00:00		1988-06-30 00:00:00		1988-12-31 00:00:00		1989-12-31 00:00:00		1990-06-30 00:00:00		1990-12-31 00:00:00		1991-12-31 00:00:00		1993-12-31 00:00:00		1994-06-30 00:00:00		1994-12-31 00:00:00		1996-06-30 00:00:00		1996-12-30 00:00:00		1996-06-30 00:00:00		1996-12-31 00:00:00		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-06-30 00:00:00		1998-12-31 00:00:00		1999-06-30 00:00:00		1992-12-31 00:00:00		1996-06-30 00:00:00		1996-06-30 00:00:00		1997-12-31 00:00:00		1987-12-31 00:00:00		1998-12-31 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		2002-02-21 00:00:00		None		None		2002-03-31 00:00:00		2002-02-28 00:00:00		2002-02-28 00:00:00		2002-02-25 00:00:00		2002-02-25 00:00:00		None		2001-12-31 00:00:00		None		None		2002-09-30 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-10-24 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-03-31 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2002-09-30 00:00:00		2002-06-30 00:00:00		2002-03-31 00:00:00		None		2002-06-30 00:00:00		2002-12-31 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2002-06-30 00:00:00		2002-03-31 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-09-04 00:00:00		2003-08-27 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		None		2004-02-27 00:00:00		None		2004-02-19 00:00:00		2004-02-20 00:00:00		None		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2005-06-30 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-09-30 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-09-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2006-03-31 00:00:00		2006-03-31 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		2006-03-31 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-10-04 00:00:00		2006-10-03 00:00:00		2005-09-30 00:00:00		2006-11-02 00:00:00		2006-06-30 00:00:00		2006-11-02 00:00:00		None		None		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		None		2007-09-30 00:00:00		2007-06-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		None		2013-06-30 00:00:00		2013-06-04 00:00:00		2013-06-30 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2007-06-30 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		None		2007-09-30 00:00:00		2007-12-31 00:00:00		2007-09-30 00:00:00		2007-06-30 00:00:00		2008-06-30 00:00:00		2007-06-30 00:00:00		None		2008-05-24 00:00:00		2008-05-28 00:00:00		2007-12-31 00:00:00		2007-09-30 00:00:00		2007-06-30 00:00:00		2008-10-23 00:00:00		None		2008-06-30 00:00:00		None		None		2008-11-05 00:00:00		None		2008-12-31 00:00:00		2008-12-31 00:00:00		2008-10-30 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		None		2010-10-27 00:00:00		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		2011-12-31 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2014-10-16 00:00:00		2012-10-22 00:00:00		2012-10-24 00:00:00		2012-10-29 00:00:00		2014-09-04 00:00:00		2012-12-31 00:00:00		2013-12-31 00:00:00		2014-04-24 00:00:00		2012-12-31 00:00:00		2015-09-30 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2018-12-31 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-09-13 00:00:00		2016-08-31 00:00:00		2016-06-30 00:00:00		2016-09-17 00:00:00		2016-09-21 00:00:00		2016-10-11 00:00:00		2016-10-29 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2018-12-31 00:00:00		2018-12-31 00:00:00		2018-12-31 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		2001-08-06 00:00:00		None		2002-01-31 00:00:00		None		2002-02-21 00:00:00		None		None		2002-04-30 00:00:00		2002-02-28 00:00:00		2002-02-28 00:00:00		2002-02-25 00:00:00		2002-02-25 00:00:00		None		None		None		None		2002-10-24 00:00:00		None		None		None		2002-10-24 00:00:00		None		2002-07-29 00:00:00		2002-07-29 00:00:00		None		None		None		None		None		None		2002-10-29 00:00:00		2003-01-29 00:00:00		2003-02-03 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-07-31 00:00:00		None		None		2004-01-08 00:00:00		2003-09-04 00:00:00		2003-08-27 00:00:00		2003-10-30 00:00:00		None		None		2004-02-27 00:00:00		None		2004-02-19 00:00:00		2004-02-20 00:00:00		None		2004-07-30 00:00:00		2004-04-30 00:00:00		None		None		None		2004-10-27 00:00:00		2005-01-31 00:00:00		None		None		None		None		None		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		None		2005-12-05 00:00:00		2005-08-01 00:00:00		2005-10-28 00:00:00		2005-10-19 00:00:00		2005-08-11 00:00:00		None		None		None		2005-12-15 00:00:00		None		None		None		2005-12-05 00:00:00		2006-05-01 00:00:00		2006-05-01 00:00:00		2006-01-31 00:00:00		2006-02-06 00:00:00		None		None		2006-01-31 00:00:00		None		2006-10-04 00:00:00		2006-10-03 00:00:00		None		2006-11-02 00:00:00		2006-07-31 00:00:00		2006-11-02 00:00:00		None		None		None		None		2007-01-31 00:00:00		2007-05-29 00:00:00		2007-05-29 00:00:00		2007-07-31 00:00:00		None		2007-10-31 00:00:00		None		2007-08-22 00:00:00		None		None		2013-07-30 00:00:00		2013-06-04 00:00:00		None		None		2014-07-23 00:00:00		2015-02-02 00:00:00		2015-02-02 00:00:00		None		None		2008-01-31 00:00:00		2008-01-31 00:00:00		None		2008-01-31 00:00:00		None		2008-03-04 00:00:00		2008-03-04 00:00:00		None		None		2008-07-30 00:00:00		2008-03-04 00:00:00		None		2008-05-24 00:00:00		2008-05-28 00:00:00		None		None		None		2008-10-23 00:00:00		None		None		None		None		2008-11-05 00:00:00		None		2009-01-29 00:00:00		None		2008-10-30 00:00:00		2009-04-29 00:00:00		2009-07-30 00:00:00		None		None		None		None		None		2009-07-30 00:00:00		None		2009-10-30 00:00:00		2010-01-28 00:00:00		None		None		None		2010-10-27 00:00:00		2011-01-31 00:00:00		None		2011-07-26 00:00:00		None		2012-01-31 00:00:00		None		2012-07-26 00:00:00		None		None		2014-01-28 00:00:00		2012-07-26 00:00:00		None		None		2014-10-16 00:00:00		2012-10-22 00:00:00		2012-10-24 00:00:00		2012-10-29 00:00:00		2014-09-04 00:00:00		2013-01-29 00:00:00		2014-02-13 00:00:00		2014-04-24 00:00:00		None		2015-10-21 00:00:00		None		2015-07-27 00:00:00		None		None		2016-01-20 00:00:00		None		None		None		2016-07-21 00:00:00		2016-09-13 00:00:00		2016-08-31 00:00:00		2016-07-19 00:00:00		2016-09-17 00:00:00		2016-09-21 00:00:00		2016-10-11 00:00:00		2016-10-29 00:00:00		2017-01-19 00:00:00		None		2019-01-29 00:00:00		None		2019-03-25 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		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		None		None		22001		None		22001		22001		None		22001		22001		None		None		None		22001		22001		None		None		None		None		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		None		None		None		22001		None		None		None		22001		22001		22001		22001		22001		None		None		22001		None		22001		22001		None		22001		22001		22001		None		None		None		None		22001		22001		22001		22001		None		22001		None		22001		None		None		22006		22006		None		None		22006		22006		22006		None		None		22001		22001		None		22001		None		22001		22001		None		None		22001		22001		None		22001		22001		None		None		None		22001		None		None		None		None		22001		None		22001		None		22001		22001		22001		None		None		None		None		None		22001		None		22001		22001		None		None		None		22001		22001		None		22001		None		22001		None		22006		None		None		22006		22006		None		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		None		22006		None		None		22006		None		None		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		None		22006

Table: filer_to_filer_type

filer_id		1011044
filer_type		10
active		Y
race		0
session_id		1985
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		1011044
xref_id		487141
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141		487141
filer_id		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044
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		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		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		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		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00
naml		CH2M HILL, INC.		CH2M HILL, INC.		CH2M HILL, INC.		CH2M HILL, INC.		CH2M HILL, INC.		CH2M HILL, INC.		CH2M HILL, INC.		CH2M HILL, INC.		CH2M HILL, INC.		CH2M HILL, INC.		CH2M HILL, INC.		CH2M HILL, INC.		CH2M HILL CALIFORNIA, INCORPORATED		CH2M HILL CALIFORNIA, INCORPORATED		CH2M HILL CALIFORNIA, INCORPORATED		CH2M HILL CALIFORNIA, INCORPORATED		CH2M HILL CALIFORNIA, INCORPORATED		CH2M HILL CALIFORNIA, INCORPORATED		CH2M HILL CALIFORNIA, INCORPORATED		CH2M HILL CALIFORNIA, INCORPORATED		CH2M HILL CALIFORNIA, INCORPORATED		CH2M HILL CALIFORNIA, INCORPORATED		CH2M HILL CALIFORNIA, INCORPORATED		CH2M HILL CALIFORNIA, INCORPORATED
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
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
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
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
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
city		BOISE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		BOISE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		ID		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		ID		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		837120000		958140000		95833		95833		95833		95833		95833		95833		95833		95833		95833		95833		837120000		958140000		95833		95833		95833		95833		95833		95833		95833		95833		95833		95833
phon		2083455310		9165511335		9169200300		9169200300		9169200300		9169200300		9169200300		9169200300		9169200300		9169200300		9169200300		9169200300		2083455310		9165511335		9169200300		9169200300		9169200300		9169200300		9169200300		9169200300		9169200300		9169200300		9169200300		9169200300
fax		None		None		None		None		None		2027603098		2027603098		2027603098		2027603098		2027603098		2027603098		2027603098		None		None		None		None		None		2027603098		2027603098		2027603098		2027603098		2027603098		2027603098		2027603098
email		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1011044

Table: received_filings

filer_id		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044		1011044
filing_file_name		774207_0.cal		265279.cal		114923.cal		814480_0.cal		821972_0.cal		345582.cal		821972_1.cal		825575_0.cal		827382_0.cal		504268.cal		499889.cal		827393_0.cal		309290.cal		840030_0.cal		196167.cal		196446.cal		853466_0.cal		840030_1.cal		877797_0.cal		412941.cal		853466_1.cal		411419.cal		411816.cal		412105.cal		881649_0.cal		909341_1.cal		840030_2.cal		853466_2.cal		440084.cal		909341_0.cal		475003.cal		881649_1.cal		474740.cal		948462_0.cal		956842_0.cal		957766_0.cal		969148_0.cal		978678_0.cal		1002947_0.cal		358305.cal		997463_0.cal		997464_0.cal		129765.cal		1080837_1.cal		1055289_1.cal		129140.cal		129299.cal		115707.cal		129450.cal		129549.cal		129656.cal		129443.cal		128861.cal		129655.cal		129712.cal		1031531_1.cal		1055289_2.cal		1080837_3.cal		1167520_1.cal		1203614_0.cal		1203741_0.cal		1336593_0.cal		1394058_0.cal		1337967_0.cal		1462307_0.cal		1218430_0.cal		1218870_0.cal		1370065_0.cal		1080837_4.cal		1283853_0.cal		156616.cal		373859.cal		373887.cal		375231.cal		373525.cal		1394058_1.cal		1297446_0.cal		387216.cal		387211.cal		387263.cal		1380681_0.cal		1375880_0.cal		226961.cal		229314.cal		1297446_1.cal		214715.cal		1311565_1.cal		215001.cal		1311565_0.cal		222829.cal		215006.cal		1297446_2.cal		216080.cal		1536865_0.cal		1570470_0.cal		1603255_0.cal		80996.cal		81651.cal
received_date		2001-08-06 00:00:00		2001-07-31 00:00:00		2002-01-31 00:00:00		2002-01-31 00:00:00		2002-02-21 00:00:00		2002-02-25 00:00:00		2002-02-25 00:00:00		2002-02-25 00:00:00		2002-02-28 00:00:00		2002-02-28 00:00:00		2002-02-28 00:00:00		2002-02-28 00:00:00		2002-04-30 00:00:00		2002-04-30 00:00:00		2002-07-29 00:00:00		2002-07-29 00:00:00		2002-07-29 00:00:00		2002-07-29 00:00:00		2002-10-24 00:00:00		2002-10-29 00:00:00		2002-10-29 00:00:00		2002-10-29 00:00:00		2002-10-29 00:00:00		2002-10-29 00:00:00		2002-10-29 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-01-31 00:00:00		2003-02-03 00:00:00		2003-01-31 00:00:00		2003-08-01 00:00:00		2003-08-27 00:00:00		2003-09-04 00:00:00		2003-10-30 00:00:00		2004-01-08 00:00:00		2004-02-27 00:00:00		2004-08-02 00:00:00		2004-02-20 00:00:00		2004-02-20 00:00:00		2005-02-08 00:00:00		2005-02-10 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-12-14 00:00:00		2005-12-16 00:00:00		2006-05-01 00:00:00		2006-10-03 00:00:00		2006-10-04 00:00:00		2008-05-24 00:00:00		2009-01-29 00:00:00		2008-05-28 00:00:00		2010-01-28 00:00:00		2006-11-02 00:00:00		2006-11-02 00:00:00		2008-10-23 00:00:00		2007-08-22 00:00:00		2007-07-31 00:00:00		2007-05-29 00:00:00		2009-07-30 00:00:00		2009-07-30 00:00:00		2009-07-30 00:00:00		2009-07-30 00:00:00		2009-04-29 00:00:00		2007-10-31 00:00:00		2008-11-05 00:00:00		2008-11-05 00:00:00		2008-11-05 00:00:00		2008-11-05 00:00:00		2008-10-30 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-03-04 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-03-04 00:00:00		2008-01-31 00:00:00		2010-10-27 00:00:00		2011-01-31 00:00:00		2011-07-26 00:00:00		2012-01-30 00:00:00		2012-01-30 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/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/temp		/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/temp		/usr/users/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/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/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/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/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/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp
filing_id		774207		None		None		814480		821972		None		821972		825575		827382		None		None		827393		None		840030		None		None		853466		840030		877797		None		853466		None		None		None		881649		909341		840030		853466		None		909341		None		881649		None		948462		956842		957766		969148		978678		1002947		None		997463		997464		None		1080837		1055289		None		None		None		None		None		None		None		None		None		None		1031531		1055289		1080837		1167520		1203614		1203741		1336593		1394058		1337967		1462307		1218430		1218870		1370065		1080837		1283853		None		None		None		None		None		1394058		1297446		None		None		None		1380681		1375880		None		None		1297446		None		1311565		None		1311565		None		None		1297446		None		1536865		1570470		1603255		None		None
form_id		F461		None		None		F461		F497		None		F497		F497		F497		None		None		F496		None		F461		None		None		F461		F461		F497		None		F461		None		None		None		F461		F461		F461		F461		None		F461		None		F461		None		F461		F497		F497		F461		F461		F497		None		F497		F497		None		F461		F461		None		None		None		None		None		None		None		None		None		None		F461		F461		F461		F461		F497		F497		F497		F461		F497		F461		F497		F497		F497		F461		F461		None		None		None		None		None		F461		F461		None		None		None		F497		F497		None		None		F461		None		F461		None		F461		None		None		F461		None		F497		F461		F461		None		None
receive_comment		Filing accepted, but with warnings		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing accepted, but with warnings		Filing did not pass validation		Filing accepted		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 passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		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 passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing 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 did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing did not pass validation		Filing accepted		Filing did not pass validation		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation