Home

Filer ID: 1061257

Table: filer_address

filer_id		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257
adrid		1067076		1067077		2064002		2110546		2181331		2497829		2497828		2477174		2477173		2289458		2289457
effect_dt		1994-02-17 00:00:00		1994-02-17 00:00:00		2004-01-23 00:00:00		2006-08-24 00:00:00		2010-03-08 00:00:00		2020-04-13 00:00:00		2020-04-13 00:00:00		2019-01-28 00:00:00		2019-01-28 00:00:00		2013-04-08 00:00:00		2013-04-08 00:00:00
add_type		7051		7051		7051		7051		7082		7082		7051		7082		7051		7051		7082
session_id		1993		1993		2003		2005		2009		2019		2019		2019		2019		2013		2013

Table: filer_filings

filer_id		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257
filing_id		369643		369644		369646		369647		369648		369649		369650		369651		369652		369653		369654		369655		369657		369658		369642		439729		439730		439731		439732		369645		369656		582485		647414		722250		783420		806039		854033		886991		915715		950617		982014		991488		986126		950617		1033986		1066851		1080111		1119913		1125355		1150391		1191199		1125355		1219623		1239470		1285361		1285865		1781003		1780570		1982033		1864699		1943203		1908274		1904177		1311756		1312734		1351668		1352478		1371430		1374642		1399342		1398779		1438437		1425863		1464354		1464740		1439802		1475096		1471973		1490839		1472606		1473837		1494948		1507563		1509394		1519342		1531416		1534324		1519577		1570611		1570367		1608139		1608715		1637161		1638043		1677700		1821091		1815968		1681077		1933781		1710633		1703372		1866522		1739167		1758435		1471973		1746909		1986660		2245156		2341952		2232547		2440497		2228861		2473668		2498621		2235104		2390642		2229386		2394281		2009971		2014425		2061618		2061618		2069497		2129325		2147834		2173370		2229386		2229412		2174339		1471973		2275182		2207401		1471973		2268366		2215500		2353164		2354997		2483028		2446033		2553463		2568892		2685490		2685023		2649657		2643955		2603409		2703955		2620021		2732603
period_id		137		137		140		140		141		143		145		149		149		151		153		155		157		159		137		139		140		147		151		139		157		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		189		None		None		213		221		217		None		None		219		191		None		193		None		195		None		None		196		197		None		None		199		None		None		201		201		None		201		None		202		None		203		204		None		None		204		None		None		205		207		None		209		None		215		None		220		None		211		None		212		None		214		None		None		None		235		234		239		234		None		None		233		237		234		None		223		None		225		225		None		227		None		229		234		234		None		237		234		231		242		None		None		None		None		241		None		243		None		250		250		None		247		245		249		None		None
form_id		F405		F420		F420		F420		F420		F420		F420		F405		F420		F405		F420		F420		F420		F420		F410		F405		F420		F420		F420		F420		F405		F460		F460		F460		F425		F425		F460		F497		F460		F460		F460		F410		F405		F460		F460		F497		F460		F460		F410		F460		F460		F410		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		F410		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F410		F460		F460		F460		F460		F497		F460		F497		F410		F425		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F410		F460		F460		F410		F460		F460		F410		F460		F425		F460		F460		F460		F497		F497		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		1		0		0		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		1		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		1		0		0		0		0		0		0		0		2		0		0		3		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1994-03-14 00:00:00		1994-08-01 00:00:00		1994-10-24 00:00:00		1994-10-24 00:00:00		1995-07-28 00:00:00		1996-01-30 00:00:00		1996-07-31 00:00:00		1997-01-31 00:00:00		1997-07-25 00:00:00		1997-07-25 00:00:00		1998-07-31 00:00:00		1999-02-01 00:00:00		1999-08-02 00:00:00		1999-10-12 00:00:00		1994-02-17 00:00:00		1994-09-28 00:00:00		1995-01-23 00:00:00		1997-01-31 00:00:00		1998-01-30 00:00:00		1994-10-04 00:00:00		1999-02-01 00:00:00		2000-01-10 00:00:00		2000-07-31 00:00:00		2001-01-29 00:00:00		2001-08-29 00:00:00		2002-01-10 00:00:00		2002-07-25 00:00:00		2002-10-26 00:00:00		2003-01-31 00:00:00		2003-07-31 00:00:00		2004-01-12 00:00:00		2004-01-23 00:00:00		2004-01-23 00:00:00		2004-02-09 00:00:00		2004-08-02 00:00:00		2004-10-29 00:00:00		2005-01-28 00:00:00		2005-08-01 00:00:00		2005-08-26 00:00:00		2006-01-30 00:00:00		2006-07-28 00:00:00		2006-08-24 00:00:00		2006-10-25 00:00:00		2007-01-31 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2013-07-26 00:00:00		2013-07-30 00:00:00		2015-07-31 00:00:00		2014-07-21 00:00:00		2015-01-27 00:00:00		2014-10-23 00:00:00		2014-10-23 00:00:00		2008-01-31 00:00:00		2008-01-30 00:00:00		2008-07-31 00:00:00		2008-07-31 00:00:00		2008-10-24 00:00:00		2008-10-24 00:00:00		2009-02-02 00:00:00		2009-02-02 00:00:00		2009-07-31 00:00:00		2006-10-25 00:00:00		2010-01-27 00:00:00		2010-02-01 00:00:00		2009-07-30 00:00:00		2010-03-22 00:00:00		2010-03-11 00:00:00		2010-05-27 00:00:00		2010-03-09 00:00:00		2010-03-20 00:00:00		2010-05-27 00:00:00		2010-08-02 00:00:00		2010-07-30 00:00:00		2010-09-21 00:00:00		2010-10-21 00:00:00		2010-10-21 00:00:00		2010-09-21 00:00:00		2011-01-31 00:00:00		2011-01-26 00:00:00		2011-07-29 00:00:00		2011-08-01 00:00:00		2012-01-31 00:00:00		2012-01-30 00:00:00		2012-07-30 00:00:00		2014-01-30 00:00:00		2014-01-30 00:00:00		2012-07-30 00:00:00		2015-01-30 00:00:00		2012-10-25 00:00:00		2012-10-25 00:00:00		2014-07-22 00:00:00		2013-01-31 00:00:00		2013-04-08 00:00:00		2013-04-09 00:00:00		2013-01-31 00:00:00		2015-07-30 00:00:00		2018-04-24 00:00:00		2019-01-28 00:00:00		2018-04-18 00:00:00		2020-01-30 00:00:00		2018-04-06 00:00:00		2020-04-13 00:00:00		2020-07-30 00:00:00		2018-04-24 00:00:00		2019-07-17 00:00:00		2018-04-11 00:00:00		2019-07-12 00:00:00		2016-01-29 00:00:00		2016-01-28 00:00:00		2016-07-29 00:00:00		2016-07-29 00:00:00		2016-07-28 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-07-28 00:00:00		2018-04-09 00:00:00		2018-04-09 00:00:00		2017-07-26 00:00:00		2019-01-28 00:00:00		2018-07-31 00:00:00		2018-01-29 00:00:00		2020-04-14 00:00:00		2018-07-23 00:00:00		2018-01-29 00:00:00		2019-01-28 00:00:00		2019-01-28 00:00:00		2020-07-29 00:00:00		2020-01-30 00:00:00		2021-02-01 00:00:00		2021-02-01 00:00:00		2022-05-24 00:00:00		2022-05-23 00:00:00		2022-01-31 00:00:00		2022-01-31 00:00:00		2021-08-02 00:00:00		2022-07-29 00:00:00		2021-08-02 00:00:00		2022-07-27 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10002		10005		10006		10005		10005		10005		10005		10006		10005		10005		10006		10005		10005		10001		10005		10005		10001		10001		10001		10005		10005		10001		10001		10005		10001		10005		10001		10005		10005		10001		10001		10005		10005		10001		10005		10005		10001		10001		10006		10001		10005		10001		10005		10001		10001		10005		10005		10001		10005		10005		10001		10001		10005		10001		10005		10001		10005		10001		10005		10001		10005		10001		10002		10002		10005		10005		10005		10001		10001		10001		10001		10006		10005		10001		10001		10002		10005		10001		10005		10001		10002		10005		10001		10005		10001		10001		10001		10005		10002		10001		10001		10002		10005		10005		10006		10005		10001		10005		10001		10005		10001		10001		10005		10001		10001		10001		10005		10005
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		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11003
session_id		1993		1993		1993		1993		1995		1995		1995		1997		1997		1997		1997		1997		1999		1999		1993		1993		1993		1995		1997		1993		1999		1999		1999		1999		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2007		2007		2013		2013		2015		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2009		2007		2009		2005		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2013		2013		2011		2013		2011		2011		2013		2011		2013		2013		2011		2015		2017		2017		2017		2019		2017		2019		2019		2017		2019		2017		2019		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2019		2017		2017		2019		2017		2017		2019		2017		2019		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		JLEHMAN		TWALLS		LTHIBAUL		DBARRICK		DBARRICK		KLARRY		DBARRICK		GGILMORE		KVOONG1		TTHAM		GGILMORE		EMCENTEE		GKURIMOT		EMCENTEE		KVOONG1		GKURIMOT		TTHAM		GKURIMOT		GPEREZ		EMCENTEE		DWALKER		GPEREZ		*		SARRIAGA		MPACHECO		CAFILER		MDIGRAZIA		CAFILER		GCLARA		MPACHECO		CAFILER		*		GPEREZ		CPON		CPON		NWALKER		NWALKER		CPON		CPON		CPON		JLANDERS		CPON		CPON		CPON		MMORENO		*		CPON		RGEREMIA		MMORENO		CPON		*		SARRIAGA		*		MMORENO		MMORENO		MPACHECO		SMCCONNAN		SMCCONNAN		CPON		CPON		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MPACHECO		CAFILER		MDIGRAZIA		MDIGRAZIA		MPACHECO		CAFILER		MPACHECO		CAFILER		JINGRAM		JINGRAM		MPACHECO		MDIGRAZIA		CSAGABAEN		VUKSTINA		RGEREMIA		LFEDOROV		CAFILER		TRAMON		IMEDINA		CSAGABAEN		VUKSTINA		CAFILER		VUKSTINA		MDIGRAZIA		MDIGRAZIA		SARRIAGA		CAFILER		SARRIAGA		LPALMER		LBARTHOL		LBARTHOL		CAFILER		CAFILER		LBARTHOL		TRAMON		HSTOVALL		CSAGABAEN		TRAMON		HSTOVALL		CSAGABAEN		TRAMON		VUKSTINA		IMEDINA		LFEDOROV		AXIONG		AXIONG		CAFILER		CAFILER		KRUSSELL		KRUSSELL		DCODY		CAFILER		DCODY		JMAVES
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		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
rpt_start		None		1994-01-01 00:00:00		1994-10-01 00:00:00		1994-10-01 00:00:00		1995-01-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		None		1997-01-01 00:00:00		None		1998-01-01 00:00:00		1998-07-01 00:00:00		1999-01-01 00:00:00		1999-07-01 00:00:00		None		None		1994-10-23 00:00:00		1996-07-01 00:00:00		1997-07-01 00:00:00		1994-07-01 00:00:00		None		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		None		2002-07-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		None		2003-07-01 00:00:00		2003-01-01 00:00:00		2004-01-01 00:00:00		None		2004-07-01 00:00:00		2005-01-01 00:00:00		None		2005-07-01 00:00:00		2006-01-01 00:00:00		None		2006-07-01 00:00:00		2006-10-22 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2014-01-01 00:00:00		2014-10-19 00:00:00		2014-07-01 00:00:00		2014-07-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-07-01 00:00:00		2008-07-01 00:00:00		2008-10-19 00:00:00		2008-10-19 00:00:00		2009-01-01 00:00:00		2006-07-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2009-01-01 00:00:00		2010-01-01 00:00:00		2010-03-11 00:00:00		2010-03-18 00:00:00		None		2010-01-01 00:00:00		2010-03-18 00:00:00		2010-05-23 00:00:00		2010-05-23 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		2010-07-01 00:00:00		2010-10-17 00:00:00		2010-10-17 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		2013-07-01 00:00:00		2013-07-01 00:00:00		2012-01-01 00:00:00		2014-10-19 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2014-01-01 00:00:00		2012-10-21 00:00:00		None		2013-04-09 00:00:00		2012-10-21 00:00:00		2015-01-01 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2018-04-18 00:00:00		2019-07-01 00:00:00		2018-04-06 00:00:00		None		2020-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2018-04-11 00:00:00		2019-01-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-01-01 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2018-04-09 00:00:00		2018-04-09 00:00:00		2017-01-01 00:00:00		2019-01-28 00:00:00		2018-04-22 00:00:00		2017-07-01 00:00:00		2020-04-10 00:00:00		2018-04-22 00:00:00		2017-07-01 00:00:00		None		2018-07-01 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2020-07-01 00:00:00		2020-07-01 00:00:00		2022-05-24 00:00:00		2022-05-22 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00
rpt_end		None		1994-06-30 00:00:00		1994-10-24 00:00:00		1994-10-22 00:00:00		1995-06-30 00:00:00		1995-12-31 00:00:00		1996-06-30 00:00:00		None		1997-06-30 00:00:00		None		1998-06-30 00:00:00		1998-12-31 00:00:00		1999-06-30 00:00:00		1999-09-30 00:00:00		None		None		1994-12-31 00:00:00		1996-12-31 00:00:00		1997-12-31 00:00:00		1994-09-30 00:00:00		None		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-12-31 00:00:00		2002-06-30 00:00:00		None		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		None		2003-12-31 00:00:00		2003-06-30 00:00:00		2004-06-30 00:00:00		None		2004-12-31 00:00:00		2005-06-30 00:00:00		None		2005-12-31 00:00:00		2006-06-30 00:00:00		None		2006-10-21 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2014-12-31 00:00:00		2014-10-18 00:00:00		2014-10-18 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-18 00:00:00		2008-10-18 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2006-10-21 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2009-06-30 00:00:00		2010-03-17 00:00:00		2010-03-11 00:00:00		2010-05-22 00:00:00		None		2010-03-17 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-10-16 00:00:00		2010-10-16 00:00:00		2010-09-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		2013-12-31 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2014-12-31 00:00:00		2012-10-20 00:00:00		2012-10-20 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		None		2013-04-09 00:00:00		2012-12-31 00:00:00		2015-06-30 00:00:00		2018-04-21 00:00:00		2018-12-31 00:00:00		2018-04-18 00:00:00		2019-12-31 00:00:00		2018-04-06 00:00:00		None		2020-06-30 00:00:00		2018-04-21 00:00:00		2019-06-30 00:00:00		2018-04-11 00:00:00		2019-06-30 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-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2018-04-09 00:00:00		2018-04-09 00:00:00		2017-06-30 00:00:00		2019-01-28 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2020-04-10 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		None		2018-12-31 00:00:00		2020-06-30 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		2020-12-31 00:00:00		2022-05-24 00:00:00		2022-05-22 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2007-07-31 00:00:00		None		None		2013-07-23 00:00:00		2015-07-28 00:00:00		2014-07-20 00:00:00		None		None		2014-10-23 00:00:00		2008-01-28 00:00:00		None		2008-07-30 00:00:00		None		2008-10-24 00:00:00		None		None		2009-01-29 00:00:00		2009-07-30 00:00:00		None		None		2010-01-22 00:00:00		None		None		None		2010-05-24 00:00:00		None		2010-03-19 00:00:00		None		2010-08-02 00:00:00		None		2010-09-21 00:00:00		2010-10-21 00:00:00		None		None		2011-01-31 00:00:00		None		None		2011-08-01 00:00:00		2012-01-16 00:00:00		None		2012-07-27 00:00:00		None		2014-01-29 00:00:00		None		2015-01-26 00:00:00		None		2012-10-24 00:00:00		None		2013-01-25 00:00:00		None		None		None		None		None		2019-01-28 00:00:00		2018-04-18 00:00:00		2020-01-30 00:00:00		2018-04-06 00:00:00		None		None		2018-04-23 00:00:00		2019-07-08 00:00:00		2018-04-11 00:00:00		None		2016-01-25 00:00:00		None		2016-07-26 00:00:00		2016-07-29 00:00:00		None		2017-01-29 00:00:00		None		2017-07-25 00:00:00		2018-04-09 00:00:00		2018-04-09 00:00:00		None		None		2018-07-23 00:00:00		2018-01-26 00:00:00		None		None		None		None		None		2020-07-29 00:00:00		None		2021-02-01 00:00:00		None		2022-05-24 00:00:00		2022-05-22 00:00:00		None		2022-01-19 00:00:00		2021-07-30 00:00:00		2022-07-27 00:00:00		None		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		22001		22001		22001		None		None		22001		22001		None		22001		None		22001		None		None		22001		22001		None		None		22001		None		None		22001		22001		None		22001		None		22006		None		22001		22001		None		None		22001		None		None		22001		22001		None		22001		None		22001		None		22001		None		22001		None		22001		None		22006		None		None		None		22001		22006		22001		22006		None		None		22001		22001		22006		None		22001		None		22001		22001		None		22001		None		22001		22006		22006		None		22001		22001		22001		22001		None		None		None		None		22001		None		22001		None		22001		22001		None		22001		22001		22001		None		None

Table: filer_to_filer_type

filer_id		1061257
filer_type		16
active		Y
race		0
session_id		1993
category		0
category_type		40502
sub_category		40103
effect_dt		1994-02-17 00:00:00
sub_category_type		0
election_type		0
sub_category_a		S
nyq_dt		1994-03-01 00:00:00
party_cd		None
county_cd		18004
district_cd		None

Table: filer_xref

filer_id		1061257
xref_id		940569
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		940569		940569		940569		940569		940569		940569		940569		940569		940569		940569		940569
filer_id		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1994-02-17 00:00:00		1994-02-17 00:00:00		1994-02-17 00:00:00		1994-02-17 00:00:00		1994-02-17 00:00:00		1994-02-17 00:00:00		1994-02-17 00:00:00		1994-02-17 00:00:00		1994-02-17 00:00:00		1994-02-17 00:00:00		1994-02-17 00:00:00
naml		SACRAMENTO HISPANIC CHAMBER OF COMMERCE PAC		SACRAMENTO HISPANIC CHAMBER OF COMMERCE PAC		SACRAMENTO HISPANIC CHAMBER OF COMMERCE PAC		SACRAMENTO HISPANIC CHAMBER OF COMMERCE PAC		SACRAMENTO HISPANIC CHAMBER OF COMMERCE PAC		SACRAMENTO HISPANIC CHAMBER OF COMMERCE PAC		SACRAMENTO HISPANIC CHAMBER OF COMMERCE PAC		SACRAMENTO HISPANIC CHAMBER OF COMMERCE PAC		SACRAMENTO HISPANIC CHAMBER OF COMMERCE PAC		SACRAMENTO HISPANIC CHAMBER OF COMMERCE PAC		SACRAMENTO HISPANIC CHAMBER OF COMMERCE PAC
namf		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None
city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		958140000		958160000		95825		95815		95814		95814		95815		95815		95814		95815		95814
phon		9164920935		9165547420		9164867700		9164867700		9164867700				9164867700		9164412430		9164412430		9167018999		9167018999
fax		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1061257

Table: received_filings

filer_id		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257		1061257
filing_file_name		520578.cal		1739167_0.cal		1815968_0.cal		1608715_0.cal		453527.cal		1780570_0.cal		1637161_0.cal		1864699_0.cal		1982033_0.cal		2129325_0.cal		2061618_0.cal		2061618_1.cal		2009971_0.cal		1904177_0.cal		1933781_0.cal		2173370_0.cal		2341952_0.cal		44058.cal		44134.cal		44552.cal		2390642_0.cal		2235104_0.cal		44157.cal		2275182_0.cal		2207401_0.cal		20106.cal		2440497_0.cal		44605.cal		169192.cal		20667.cal		42037.cal		44449.cal		42349.cal		44222.cal		44294.cal		1471973_3.cal		2483028_0.cal		2553463_0.cal		2685023_0.cal		2703955_0.cal		2603409_0.cal		2685490_0.cal		2643955_0.cal
received_date		2010-03-10 00:00:00		2013-01-31 00:00:00		2014-01-30 00:00:00		2011-08-01 00:00:00		2013-07-23 00:00:00		2013-07-30 00:00:00		2012-01-31 00:00:00		2014-07-21 00:00:00		2015-07-31 00:00:00		2017-01-31 00:00:00		2016-07-29 00:00:00		2016-07-29 00:00:00		2016-01-29 00:00:00		2014-10-23 00:00:00		2015-01-30 00:00:00		2017-07-28 00:00:00		2019-01-28 00:00:00		2018-04-09 00:00:00		2018-04-09 00:00:00		2018-04-09 00:00:00		2019-07-17 00:00:00		2018-04-24 00:00:00		2018-04-09 00:00:00		2018-07-31 00:00:00		2018-01-29 00:00:00		2019-01-28 00:00:00		2020-01-30 00:00:00		2018-04-09 00:00:00		2020-04-14 00:00:00		2019-01-28 00:00:00		2018-04-09 00:00:00		2018-04-09 00:00:00		2018-04-09 00:00:00		2018-04-09 00:00:00		2018-04-09 00:00:00		2020-04-14 00:00:00		2020-07-29 00:00:00		2021-02-01 00:00:00		2022-05-23 00:00:00		2022-07-29 00:00:00		2021-08-02 00:00:00		2022-05-24 00:00:00		2022-01-31 00:00:00
filing_directory		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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/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/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
filing_id		None		1739167		1815968		1608715		None		1780570		1637161		1864699		1982033		2129325		2061618		2061618		2009971		1904177		1933781		2173370		2341952		None		None		None		2390642		2235104		None		2275182		2207401		None		2440497		None		None		None		None		None		None		None		None		1471973		2483028		2553463		2685023		2703955		2603409		2685490		2643955
form_id		None		F460		F460		F460		None		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		None		None		None		F460		F460		None		F460		F460		None		F460		None		None		None		None		None		None		None		None		F410		F425		F460		F497		F460		F460		F497		F460
receive_comment		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing 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 passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing 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