Home

Filer ID: 1019165

Table: filer_address

filer_id		1019165		1019165		1019165		1019165
adrid		1016946		1016947		2526618		2526619
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00		2021-11-22 00:00:00		2021-11-22 00:00:00
add_type		7051		7051		7051		7082
session_id		1973		1973		2021		2021

Table: filer_filings

filer_id		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165
filing_id		108154		108155		108156		108158		108159		108160		108161		108162		108163		108164		108165		108166		108167		108168		108169		108170		108171		108172		108173		108175		108176		108177		108178		108180		108181		108182		108183		108185		108186		108187		108188		108189		108190		108191		108192		108193		108194		108195		108196		108197		108198		108199		108200		108201		108202		108203		108204		108205		108207		108208		108210		108211		108212		108213		108214		108215		108216		108217		108218		108219		108220		108221		108222		108223		108224		108225		108226		108227		108228		108230		108231		108232		108233		108235		108236		108237		108238		209689		209690		209691		209692		209693		209694		209695		209696		209697		209698		209700		209699		609429		587522		108157		108174		108179		108184		108206		108209		108229		108234		624643		634063		674199		678419		646154		722336		783647		792878		813955		795452		825900		826263		859374		876017		855679		873470		877695		872328		872328		917071		945325		911458		951573		1009249		988729		1023430		991657		1009555		1025421		1055058		1061262		1077721		1061262		1055058		1088206		1112804		1112804		1115104		1115140		1151389		1145549		1189455		1205627		1203645		1195988		1234565		1239574		1283515		1279268		1261157		1263086		1308715		1778100		1975628		1775839		1943083		1313648		1330817		1327966		1298445		1296061		1371628		1353204		1347171		1389638		1375051		1390516		1432323		1434380		1463620		1467221		1503199		1509082		1564394		1561391		1602538		1603343		1630713		1632550		1674595		1671679		1825698		1814079		1927232		1879805		1868229		1729783		1741427		1984028		2317209		2491910		2323693		2215613		2441806		2007420		2020306		2057519		2068702		2095846		2126051		2105004		2151228		2174552		2270894		2346605		2480748		2278687		2403926		2357704		2187664		2450786		2393974		2207019		2685358		2551810		2629262		2568832		2601805		2694478		2642840		2701515		2655072		2625872		2734104		2740445
period_id		74		74		75		79		82		83		83		85		87		87		89		90		91		91		91		91		92		93		93		94		95		96		97		98		99		99		100		101		101		102		103		103		105		105		106		108		107		109		111		113		115		116		117		119		121		122		124		123		61		124		127		129		132		131		132		135		137		139		141		142		143		145		147		148		149		148		149		151		153		154		155		155		156		157		143		158		159		75		81		84		89		97		101		104		107		129		133		144		140		161		None		77		93		97		99		60		125		153		156		None		None		None		None		None		None		None		None		None		None		None		None		None		172		169		None		None		171		171		None		173		172		None		177		175		177		None		None		None		179		None		180		None		179		None		181		181		None		None		None		183		185		None		187		None		188		None		None		190		189		None		192		None		221		213		None		None		None		193		None		191		195		None		194		196		None		None		197		None		199		None		201		None		None		203		205		None		207		None		None		209		None		215		219		None		217		211		None		None		235		None		None		None		239		223		None		225		None		228		227		228		None		229		233		236		241		None		None		None		None		None		237		231		249		243		None		None		245		None		247		250		None		None		None		251
form_id		F460		F460		F450		F461		F461		F461		F461		F461		F461		F450		F450		F450		F450		F405		F450		F405		F450		F450		F405		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F405		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F405		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F450		F405		F450		F450		F450		F450		F450		F450		F450		F450		F450		F405		F450		F450		F460		F461		F461		F450		F405		F405		F450		F450		F450		F450		F450		F450		F497		F450		F461		F450		F450		F405		F410		F450		F450		F450		F497		F450		F450		F450		F450		F450		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460
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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		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		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		1978-05-25 00:00:00		1978-07-31 00:00:00		1978-10-26 00:00:00		1980-01-30 00:00:00		1980-07-31 00:00:00		1980-09-30 00:00:00		1980-10-23 00:00:00		1981-07-20 00:00:00		1981-09-22 00:00:00		1982-02-01 00:00:00		1982-05-27 00:00:00		1982-07-30 00:00:00		1982-09-22 00:00:00		1982-10-25 00:00:00		1982-10-21 00:00:00		1982-12-20 00:00:00		1983-01-31 00:00:00		1983-03-22 00:00:00		1983-05-31 00:00:00		1983-08-01 00:00:00		1983-09-22 00:00:00		1984-01-30 00:00:00		1984-03-22 00:00:00		1984-07-31 00:00:00		1984-09-20 00:00:00		1984-10-23 00:00:00		1985-02-01 00:00:00		1985-03-21 00:00:00		1985-05-23 00:00:00		1985-08-19 00:00:00		1985-09-19 00:00:00		1985-10-24 00:00:00		1986-03-22 00:00:00		1986-06-03 00:00:00		1986-07-31 00:00:00		1987-01-26 00:00:00		1986-10-22 00:00:00		1987-07-21 00:00:00		1988-01-29 00:00:00		1988-07-28 00:00:00		1988-10-04 00:00:00		1989-01-31 00:00:00		1989-08-24 00:00:00		1990-01-30 00:00:00		1990-05-24 00:00:00		1990-07-31 00:00:00		1991-01-31 00:00:00		1990-10-31 00:00:00		1975-02-03 00:00:00		1990-10-31 00:00:00		1992-01-31 00:00:00		1992-05-05 00:00:00		1992-10-30 00:00:00		1992-10-30 00:00:00		1993-01-29 00:00:00		1994-01-31 00:00:00		1994-08-01 00:00:00		1994-10-27 00:00:00		1995-05-01 00:00:00		1995-07-31 00:00:00		1995-10-31 00:00:00		1996-07-31 00:00:00		1996-10-07 00:00:00		1996-10-23 00:00:00		1997-01-06 00:00:00		1997-01-31 00:00:00		1997-07-31 00:00:00		1998-01-29 00:00:00		1998-03-25 00:00:00		1998-07-30 00:00:00		1998-10-01 00:00:00		1998-10-14 00:00:00		1998-10-23 00:00:00		1999-04-28 00:00:00		1995-11-06 00:00:00		1999-08-02 00:00:00		1999-10-15 00:00:00		1978-10-02 00:00:00		1980-06-25 00:00:00		1981-01-30 00:00:00		1982-03-23 00:00:00		1985-02-01 00:00:00		1985-07-01 00:00:00		1986-01-28 00:00:00		1986-10-01 00:00:00		1992-07-31 00:00:00		1993-08-02 00:00:00		1996-01-30 00:00:00		1995-01-31 00:00:00		2000-03-10 00:00:00		2000-01-26 00:00:00		1979-07-27 00:00:00		1983-05-26 00:00:00		1984-05-24 00:00:00		1985-02-01 00:00:00		1974-11-06 00:00:00		1991-07-31 00:00:00		1998-05-22 00:00:00		1999-02-01 00:00:00		2000-03-07 00:00:00		2000-03-07 00:00:00		2000-10-06 00:00:00		2000-10-26 00:00:00		2000-07-31 00:00:00		2001-01-31 00:00:00		2001-07-31 00:00:00		2001-10-30 00:00:00		2002-01-30 00:00:00		2001-10-31 00:00:00		2002-02-22 00:00:00		2002-02-22 00:00:00		2002-08-02 00:00:00		2002-10-21 00:00:00		2002-07-31 00:00:00		2002-10-08 00:00:00		2002-10-23 00:00:00		2002-10-07 00:00:00		2002-10-08 00:00:00		2003-01-31 00:00:00		2003-07-28 00:00:00		2003-01-31 00:00:00		2003-07-30 00:00:00		2004-04-15 00:00:00		2004-01-29 00:00:00		2004-07-16 00:00:00		2004-02-02 00:00:00		2004-04-19 00:00:00		2004-07-23 00:00:00		2004-10-27 00:00:00		2004-10-29 00:00:00		2005-01-27 00:00:00		2004-11-12 00:00:00		2004-11-09 00:00:00		2005-01-31 00:00:00		2005-07-20 00:00:00		2005-07-19 00:00:00		2005-07-26 00:00:00		2005-07-26 00:00:00		2006-01-31 00:00:00		2006-01-27 00:00:00		2006-07-28 00:00:00		2006-10-05 00:00:00		2006-10-03 00:00:00		2006-07-31 00:00:00		2007-01-29 00:00:00		2007-01-31 00:00:00		2007-07-30 00:00:00		2007-07-23 00:00:00		2007-04-29 00:00:00		2007-05-01 00:00:00		2008-01-29 00:00:00		2013-07-18 00:00:00		2015-07-21 00:00:00		2013-07-16 00:00:00		2015-01-23 00:00:00		2008-01-31 00:00:00		2008-04-30 00:00:00		2008-04-28 00:00:00		2007-10-31 00:00:00		2007-10-29 00:00:00		2008-10-24 00:00:00		2008-07-31 00:00:00		2008-07-28 00:00:00		2009-01-14 00:00:00		2008-10-24 00:00:00		2009-01-16 00:00:00		2009-07-21 00:00:00		2009-07-27 00:00:00		2010-01-29 00:00:00		2010-02-01 00:00:00		2010-07-26 00:00:00		2010-07-28 00:00:00		2011-01-21 00:00:00		2011-01-18 00:00:00		2011-07-22 00:00:00		2011-07-25 00:00:00		2012-01-23 00:00:00		2012-01-26 00:00:00		2012-07-18 00:00:00		2012-07-16 00:00:00		2014-01-31 00:00:00		2014-01-27 00:00:00		2015-01-20 00:00:00		2014-08-20 00:00:00		2014-07-29 00:00:00		2013-01-22 00:00:00		2013-01-30 00:00:00		2015-07-27 00:00:00		2018-10-30 00:00:00		2020-07-30 00:00:00		2018-10-30 00:00:00		2018-01-29 00:00:00		2020-01-31 00:00:00		2016-01-26 00:00:00		2016-01-26 00:00:00		2016-07-22 00:00:00		2016-07-27 00:00:00		2016-10-25 00:00:00		2017-01-28 00:00:00		2016-11-04 00:00:00		2017-01-30 00:00:00		2017-07-29 00:00:00		2018-07-27 00:00:00		2019-01-30 00:00:00		2020-07-24 00:00:00		2018-07-31 00:00:00		2019-07-29 00:00:00		2019-01-28 00:00:00		2017-10-11 00:00:00		2020-01-30 00:00:00		2019-07-26 00:00:00		2018-01-28 00:00:00		2022-05-24 00:00:00		2021-01-30 00:00:00		2021-11-22 00:00:00		2021-01-28 00:00:00		2021-07-31 00:00:00		2022-05-25 00:00:00		2022-01-31 00:00:00		2022-07-26 00:00:00		2022-01-27 00:00:00		2021-07-30 00:00:00		2022-07-27 00:00:00		2022-10-25 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10001		10005		10005		10001		10002		10005		10001		10001		10005		10001		10001		10001		10005		10005		10005		10001		10005		10001		10006		10002		10005		10002		10001		10006		10005		10005		10001		10001		10005		10001		10005		10001		10005		10005		10001		10001		10005		10001		10005		10001		10001		10005		10005		10005		10001		10005		10001		10001		10005		10001		10001		10005		10005		10001		10005		10001		10005		10001		10005		10005		10001		10001		10005		10001		10005		10005		10001		10005		10001		10001		10005		10001		10001		10005		10005		10001		10005		10005		10005		10001		10001		10005		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10005		10005		10005		10005		10005		10001		10001		10001		10001		10006		10005		10001		10005		10001		10001		10005		10005		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		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11001		11001		11001		11003		11003		11001		11003		11001		11003		11001		11001		11003		11003		11001		11003		11001		11003		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003
session_id		1977		1977		1977		1979		1979		1979		1979		1981		1981		1981		1981		1981		1981		1981		1981		1981		1981		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1985		1985		1985		1985		1985		1985		1985		1985		1985		1985		1987		1987		1987		1987		1987		1989		1989		1989		1989		1989		1989		1975		1989		1991		1991		1991		1991		1991		1993		1993		1993		1995		1995		1995		1995		1995		1995		1997		1995		1997		1997		1997		1997		1997		1997		1997		1999		1995		1999		1999		1977		1979		1979		1981		1983		1985		1985		1985		1991		1993		1995		1993		1999		1999		1979		1983		1983		1983		1973		1991		1997		1997		1999		1999		1999		1999		1999		1999		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		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2007		2007		2013		2015		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2013		2011		2011		2015		2017		2019		2017		2017		2019		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2019		2017		2019		2017		2017		2019		2019		2017		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		DWALKER		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		GGILMORE		CFLAGG		KCHAN		KCHAN		JLEHMAN		TWALLS		CFLAGG		GPEREZ		GPEREZ		GPEREZ		DBARRICK		CFLAGG		DBARRICK		*		*		DBARRICK		DBARRICK		*		*		DBARRICK		COMPLETED		COMPLETED		KVOONG1		COMPLETED		COMPLETED		COMPLETED		EMCENTEE		EMCENTEE		EMCENTEE		COMPLETED		CFLAGG		COMPLETED		EMCENTEE		COMPLETED		CFLAGG		*		*		SARRIAGA		SARRIAGA		SARRIAGA		*		*		GPEREZ		*		SARRIAGA		*		CFLAGG		GPEREZ		*		*		CFLAGG		*		CPON		CAFILER		CPON		GCLARA		TBOWMAN		CPON		CPON		GPEREZ		*		NWALKER		CPON		CPON		*		NWALKER		JVAZQUEZ		CPON		CPON		CPON		CPON		SMCCONNAN		SARRIAGA		SMCCONNAN		SMCCONNAN		SMCCONNAN		SMCCONNAN		CPON		CPON		CPON		CPON		GGILMORE		CAFILER		CAFILER		RGEREMIA		CAFILER		CAFILER		MPACHECO		MPACHECO		JFONSECA		KRUSSELL		JFONSECA		LBARTHOL		LFEDOROV		SMCCONNAN		SMCCONNAN		TRAMON		TRAMON		GKURIMOT		SARRIAGA		GKURIMOT		SARRIAGA		CSAGABAEN		CSAGABAEN		JFONSECA		KRUSSELL		CSAGABAEN		CSAGABAEN		JFONSECA		CSAGABAEN		LFEDOROV		CSAGABAEN		LBARTHOL		SARRIAGA		AXIONG		IMEDINA		AXIONG		KRUSSELL		SARRIAGA		KRUSSELL		CAFILER		KRUSSELL		KRUSSELL		RGEREMIA		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		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		11003		11003		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		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		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		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		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		11001		11003		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003
rpt_start		1978-04-24 00:00:00		1978-05-23 00:00:00		1978-09-24 00:00:00		1979-07-01 00:00:00		1980-05-20 00:00:00		1980-07-01 00:00:00		1980-09-24 00:00:00		1981-01-01 00:00:00		1981-07-01 00:00:00		1981-09-18 00:00:00		1982-03-18 00:00:00		1982-05-23 00:00:00		1982-07-01 00:00:00		1982-07-01 00:00:00		1982-09-18 00:00:00		1982-07-01 00:00:00		1982-10-17 00:00:00		1983-01-01 00:00:00		1983-01-01 00:00:00		1983-05-22 00:00:00		1983-07-01 00:00:00		1983-10-23 00:00:00		1984-01-01 00:00:00		1984-05-20 00:00:00		1984-07-01 00:00:00		1984-09-18 00:00:00		1984-10-21 00:00:00		1985-01-01 00:00:00		1985-03-18 00:00:00		1985-05-19 00:00:00		1985-07-01 00:00:00		1985-09-18 00:00:00		1986-01-01 00:00:00		1986-03-18 00:00:00		1986-05-19 00:00:00		1986-10-01 00:00:00		1986-07-01 00:00:00		1987-01-01 00:00:00		1987-07-01 00:00:00		1988-01-01 00:00:00		1988-07-01 00:00:00		1988-10-01 00:00:00		1989-01-01 00:00:00		1989-07-01 00:00:00		1990-01-01 00:00:00		1990-05-20 00:00:00		1990-10-21 00:00:00		1990-07-01 00:00:00		None		1990-10-01 00:00:00		1991-07-01 00:00:00		1992-01-01 00:00:00		1992-10-01 00:00:00		1992-07-01 00:00:00		1992-10-20 00:00:00		1993-07-01 00:00:00		1994-01-01 00:00:00		1994-07-01 00:00:00		1995-01-01 00:00:00		1995-04-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		1996-07-01 00:00:00		1996-10-01 00:00:00		None		1996-10-20 00:00:00		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-01-01 00:00:00		1998-05-17 00:00:00		1998-07-01 00:00:00		1998-07-01 00:00:00		1998-10-01 00:00:00		1999-01-01 00:00:00		1995-07-01 00:00:00		1999-04-01 00:00:00		1999-07-01 00:00:00		1978-07-01 00:00:00		1980-01-01 00:00:00		1980-10-21 00:00:00		1982-01-01 00:00:00		1984-03-18 00:00:00		1985-01-01 00:00:00		1985-10-20 00:00:00		1986-07-01 00:00:00		1992-01-01 00:00:00		1993-01-01 00:00:00		1995-10-01 00:00:00		1994-10-23 00:00:00		2000-03-07 00:00:00		1999-10-01 00:00:00		1979-01-01 00:00:00		1983-03-18 00:00:00		1984-03-18 00:00:00		1984-07-01 00:00:00		None		1991-01-01 00:00:00		1998-03-18 00:00:00		1998-10-18 00:00:00		None		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		2000-03-07 00:00:00		2000-11-07 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-10-21 00:00:00		2001-09-23 00:00:00		2002-01-21 00:00:00		2002-01-01 00:00:00		2002-02-18 00:00:00		2002-10-01 00:00:00		2002-02-18 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-10-20 00:00:00		2003-01-01 00:00:00		2002-10-20 00:00:00		2003-01-01 00:00:00		2004-01-01 00:00:00		2003-07-01 00:00:00		2004-03-02 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		2004-03-02 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-10-17 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-10-17 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		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2006-01-01 00:00:00		2006-10-01 00:00:00		2006-10-01 00:00:00		2007-04-01 00:00:00		2007-04-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-10-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2013-01-01 00:00:00		2014-07-01 00:00:00		2007-10-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		2008-07-01 00:00:00		2008-04-01 00:00:00		2008-04-01 00:00:00		2008-10-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-01-01 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		2012-01-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2015-01-01 00:00:00		2018-07-01 00:00:00		2020-01-01 00:00:00		2018-07-01 00:00:00		2017-07-01 00:00:00		2019-07-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-10-25 00:00:00		2016-07-01 00:00:00		2016-11-04 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2018-01-01 00:00:00		2018-10-21 00:00:00		2020-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2018-10-21 00:00:00		2017-01-01 00:00:00		2019-07-01 00:00:00		2019-01-01 00:00:00		2017-07-01 00:00:00		2022-01-01 00:00:00		2020-07-01 00:00:00		None		2020-07-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2022-05-22 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2022-05-22 00:00:00		2022-07-01 00:00:00
rpt_end		1978-05-22 00:00:00		1978-06-30 00:00:00		1978-10-23 00:00:00		1979-12-31 00:00:00		1980-06-30 00:00:00		1980-09-23 00:00:00		1980-10-20 00:00:00		1981-06-30 00:00:00		1981-09-17 00:00:00		1981-12-31 00:00:00		1982-05-22 00:00:00		1982-06-30 00:00:00		1982-09-17 00:00:00		1982-09-17 00:00:00		1982-10-16 00:00:00		1982-09-17 00:00:00		1982-12-31 00:00:00		1983-03-17 00:00:00		1983-03-17 00:00:00		1983-06-30 00:00:00		1983-09-17 00:00:00		1983-12-31 00:00:00		1984-03-17 00:00:00		1984-06-30 00:00:00		1984-09-17 00:00:00		1984-10-20 00:00:00		1984-12-31 00:00:00		1985-03-17 00:00:00		1985-05-18 00:00:00		1985-06-30 00:00:00		1985-09-17 00:00:00		1985-10-19 00:00:00		1986-03-17 00:00:00		1986-05-18 00:00:00		1986-06-30 00:00:00		1986-12-31 00:00:00		1986-09-30 00:00:00		1987-06-30 00:00:00		1987-12-31 00:00:00		1988-06-30 00:00:00		1988-09-30 00:00:00		1988-12-31 00:00:00		1989-06-30 00:00:00		1989-12-31 00:00:00		1990-05-19 00:00:00		1990-06-30 00:00:00		1990-12-31 00:00:00		1990-09-30 00:00:00		None		1990-10-20 00:00:00		1991-12-31 00:00:00		1992-03-31 00:00:00		1992-10-17 00:00:00		1992-09-30 00:00:00		1992-12-31 00:00:00		1993-12-31 00:00:00		1994-06-30 00:00:00		1994-10-22 00:00:00		1995-03-31 00:00:00		1995-06-30 00:00:00		1995-09-30 00:00:00		1996-06-30 00:00:00		1996-09-30 00:00:00		1996-10-19 00:00:00		None		1996-12-31 00:00:00		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-03-17 00:00:00		1998-06-30 00:00:00		1998-09-30 00:00:00		1998-09-30 00:00:00		1998-10-17 00:00:00		1999-03-31 00:00:00		1995-09-30 00:00:00		1999-06-30 00:00:00		1999-09-30 00:00:00		1978-09-23 00:00:00		1980-05-19 00:00:00		1980-12-31 00:00:00		1982-03-17 00:00:00		1984-05-19 00:00:00		1985-03-17 00:00:00		1985-12-31 00:00:00		1986-09-17 00:00:00		1992-06-30 00:00:00		1993-06-30 00:00:00		1995-12-31 00:00:00		1994-12-31 00:00:00		2000-03-07 00:00:00		1999-12-31 00:00:00		1979-06-30 00:00:00		1983-05-21 00:00:00		1984-05-19 00:00:00		1984-09-17 00:00:00		None		1991-06-30 00:00:00		1998-05-16 00:00:00		1998-12-31 00:00:00		None		2000-03-06 00:00:00		2000-09-30 00:00:00		2000-10-21 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-09-22 00:00:00		2001-12-31 00:00:00		2001-10-20 00:00:00		2002-02-17 00:00:00		2002-01-20 00:00:00		2002-06-30 00:00:00		2002-10-19 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-10-19 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2004-03-01 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2003-12-31 00:00:00		2004-03-01 00:00:00		2004-06-30 00:00:00		2004-10-16 00:00:00		2004-10-16 00:00:00		2004-12-31 00:00:00		2004-10-16 00:00:00		2004-10-16 00:00:00		2004-12-31 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-12-31 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-09-30 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		2007-03-31 00:00:00		2007-03-31 00:00:00		2007-12-31 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2013-06-30 00:00:00		2014-12-31 00:00:00		2007-12-31 00:00:00		2008-03-31 00:00:00		2008-03-31 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2008-09-30 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2009-06-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-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		2012-06-30 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2015-06-30 00:00:00		2018-10-20 00:00:00		2020-06-30 00:00:00		2018-10-20 00:00:00		2017-12-31 00:00:00		2019-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-10-25 00:00:00		2016-12-31 00:00:00		2016-11-04 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2018-06-30 00:00:00		2018-12-31 00:00:00		2020-06-30 00:00:00		2018-06-30 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2017-06-30 00:00:00		2019-12-31 00:00:00		2019-06-30 00:00:00		2017-12-31 00:00:00		2022-05-21 00:00:00		2020-12-31 00:00:00		None		2020-12-31 00:00:00		2021-06-30 00:00:00		2022-05-21 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		2022-10-22 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2000-03-07 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2002-10-21 00:00:00		2002-07-31 00:00:00		None		None		2002-10-07 00:00:00		2002-10-08 00:00:00		None		2003-07-28 00:00:00		2003-01-31 00:00:00		None		2004-04-15 00:00:00		2004-01-29 00:00:00		2004-07-16 00:00:00		None		None		None		2004-10-27 00:00:00		None		2005-01-27 00:00:00		None		2004-11-09 00:00:00		None		2005-07-20 00:00:00		2005-07-19 00:00:00		None		None		None		2006-01-27 00:00:00		2006-07-28 00:00:00		None		2006-10-03 00:00:00		None		2007-01-29 00:00:00		None		None		2007-07-23 00:00:00		2007-04-29 00:00:00		None		2008-01-29 00:00:00		None		2015-07-21 00:00:00		2013-07-16 00:00:00		None		None		None		2008-04-28 00:00:00		None		2007-10-29 00:00:00		2008-10-24 00:00:00		None		2008-07-28 00:00:00		2009-01-14 00:00:00		None		None		2009-07-21 00:00:00		None		2010-01-29 00:00:00		None		2010-07-26 00:00:00		None		None		2011-01-18 00:00:00		2011-07-22 00:00:00		None		2012-01-23 00:00:00		None		None		2012-07-16 00:00:00		None		2014-01-27 00:00:00		2015-01-20 00:00:00		None		2014-07-29 00:00:00		2013-01-22 00:00:00		None		None		2018-10-30 00:00:00		None		None		None		2020-01-31 00:00:00		2016-01-26 00:00:00		None		2016-07-22 00:00:00		None		2016-10-25 00:00:00		2017-01-28 00:00:00		2016-11-04 00:00:00		None		2017-07-29 00:00:00		2018-07-27 00:00:00		2019-01-30 00:00:00		2020-07-24 00:00:00		None		None		None		None		None		2019-07-26 00:00:00		2018-01-28 00:00:00		2022-05-24 00:00:00		2021-01-30 00:00:00		None		None		2021-07-31 00:00:00		None		2022-01-31 00:00:00		2022-07-26 00:00:00		None		None		None		2022-10-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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		22001		None		22001		22001		22001		None		None		None		22001		None		22001		None		22001		None		22001		22001		None		None		None		22006		22006		None		22006		None		22006		None		None		22006		22006		None		22006		None		22006		22006		None		None		None		22006		None		22006		22006		None		22006		22006		None		None		22006		None		22006		None		22006		None		None		22006		22006		None		22006		None		None		22006		None		22006		22006		None		22006		22006		None		None		22006		None		None		None		22006		22006		None		22006		None		22006		22006		22006		None		22006		22006		22006		22006		None		None		None		None		None		22006		22006		22006		22006		None		None		22006		None		22006		22006		None		None		None		22006

Table: filer_to_filer_type

filer_id		1019165
filer_type		16
active		Y
race		0
session_id		1973
category		0
category_type		40502
sub_category		40103
effect_dt		1990-12-01 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		1974-11-06 00:00:00
party_cd		None
county_cd		18041
district_cd		None

Table: filer_xref

filer_id		1019165
xref_id		744692
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		744692		744692		744692		744692
filer_id		1019165		1019165		1019165		1019165
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		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
naml		MILK PRODUCERS COUNCIL		MILK PRODUCERS COUNCIL		MILK PRODUCERS COUNCIL		MILK PRODUCERS COUNCIL
namf		None		None		None		None
namt		None		None		None		None
nams		None		None		None		None
adr1		None		None		None		None
adr2		None		None		None		None
city		ONTARIO		ONTARIO		ONTARIO		ONTARIO
st		CA		CA		CA		CA
zip4		917610000		917610000		917610000		917610000
phon		9096286018		7146286018		7146286018		7146286018
fax		None		None		None		None
email		None		None		[email protected]		[email protected]

Table: filers

filer_id		1019165

Table: received_filings

filer_id		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165		1019165
filing_file_name		855679_0.cal		876017_0.cal		872328_0.cal		872328_1.cal		405189.cal		405348.cal		911458_0.cal		911526_0.cal		945325_0.cal		330022.cal		330204.cal
received_date		2002-07-31 00:00:00		2002-10-21 00:00:00		2002-10-07 00:00:00		2002-10-08 00:00:00		2002-10-28 00:00:00		2002-10-28 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2003-07-28 00:00:00		2004-10-27 00:00:00		2004-10-27 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp
filing_id		855679		876017		872328		872328		None		None		911458		911526		945325		None		None
form_id		F460		F460		F460		F460		None		None		F460		F635		F460		None		None
receive_comment		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 passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing did not pass validation		Filing did not pass validation