Home

Filer ID: 1142870

Table: filer_address

filer_id		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870
adrid		1113512		1107023		2063023		2043062		2080905		2115915		2162895		2207409		2415688		2516403		2553526		2277791		2341459		2472363
effect_dt		1999-01-01 00:00:00		1997-01-01 00:00:00		2003-11-08 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2019-01-01 00:00:00
add_type		7051		7050		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1999		1997		2003		2003		2005		2007		2009		2011		2017		2021		2023		2013		2015		2019

Table: filer_filings

filer_id		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870
filing_id		483883		483921		468430		464110		479572		480346		472765		498504		491232		491269		494917		494952		467389		473971		474764		469237		487551		478350		487513		616373		632385		681294		665127		651786		696358		705555		717853		753309		733968		743326		767923		797761		788647		780814		811479		837486		823130		863006		851626		883085		844359		899935		892476		909212		924252		956470		930881		946791		935279		1002129		968714		988306		973210		1011335		992207		1028231		1026804		1016797		1076360		1070368		1057270		1065704		1094819		1102440		1082076		1114045		1142254		1131999		1163133		1189706		1217007		1258661		1242322		1236801		1283240		1273877		1297467		1778932		1982454		1964310		1865923		1799366		1948947		1902129		1304516		1328030		1346262		1376173		1394146		1411173		1421966		1436221		1448915		1462395		1484197		1504222		1538690		1555151		1576885		1577103		1588495		1569297		1621229		1633750		1605704		1657065		1676780		1817671		1924453		1934202		1707136		1739494		1732827		1721958		1838423		1762337		1997962		2397981		2483309		2341298		2381928		2191502		2211263		2531532		2011801		2037339		2059243		2098402		2123727		2156504		2144457		2175800		2331671		2439042		2345417		2318720		2417248		2469727		2235957		2381928		2275772		2552190		2623632		2623632		2541071		2601650		2572074		2677056		2638514		2578495		2704913		2746986
period_id		152		145		157		141		159		144		150		156		154		147		155		148		149		158		143		142		146		151		153		160		None		163		162		161		163		None		164		165		164		165		166		None		167		None		168		169		None		None		170		171		None		None		None		172		None		None		173		174		None		None		175		176		None		177		None		None		178		None		None		180		179		None		None		181		180		182		184		183		185		186		187		189		None		188		190		None		191		214		222		221		218		215		None		219		192		193		194		195		196		None		197		198		199		200		201		202		203		None		205		205		205		204		207		208		206		209		210		216		221		220		211		None		212		212		217		213		223		238		242		None		237		231		232		243		224		225		226		227		228		229		None		230		237		240		236		235		239		241		233		237		234		244		247		247		244		246		None		249		248		245		250		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F605		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F605		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F602		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635
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		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		1		0		0		0		0		0		0		0		0
filing_date		1998-02-02 00:00:00		1996-04-30 00:00:00		1999-04-29 00:00:00		1995-04-28 00:00:00		1999-11-01 00:00:00		1996-01-30 00:00:00		1997-07-31 00:00:00		1999-02-01 00:00:00		1998-07-30 00:00:00		1996-10-31 00:00:00		1998-10-31 00:00:00		1997-01-31 00:00:00		1997-04-30 00:00:00		1999-08-05 00:00:00		1995-10-31 00:00:00		1995-07-27 00:00:00		1996-07-29 00:00:00		1997-10-31 00:00:00		1998-04-30 00:00:00		2000-01-31 00:00:00		2000-05-01 00:00:00		2000-10-30 00:00:00		2000-07-27 00:00:00		2000-06-05 00:00:00		2000-10-31 00:00:00		2000-12-29 00:00:00		2001-01-30 00:00:00		2001-04-30 00:00:00		2001-01-31 00:00:00		2001-04-24 00:00:00		2001-07-16 00:00:00		2001-10-31 00:00:00		2001-10-23 00:00:00		2001-07-31 00:00:00		2002-01-28 00:00:00		2002-04-25 00:00:00		2002-01-31 00:00:00		2002-07-31 00:00:00		2002-07-24 00:00:00		2002-10-30 00:00:00		2002-04-30 00:00:00		2002-12-23 00:00:00		2002-10-31 00:00:00		2003-01-29 00:00:00		2003-01-31 00:00:00		2003-07-31 00:00:00		2003-04-30 00:00:00		2003-07-30 00:00:00		2003-04-30 00:00:00		2004-01-30 00:00:00		2003-10-29 00:00:00		2004-01-29 00:00:00		2003-10-31 00:00:00		2004-04-26 00:00:00		2004-01-30 00:00:00		2004-07-26 00:00:00		2004-07-27 00:00:00		2004-04-28 00:00:00		2004-12-06 00:00:00		2005-01-06 00:00:00		2004-10-29 00:00:00		2004-10-29 00:00:00		2005-01-31 00:00:00		2005-04-25 00:00:00		2005-02-01 00:00:00		2005-07-25 00:00:00		2006-01-18 00:00:00		2005-10-27 00:00:00		2006-04-19 00:00:00		2006-07-29 00:00:00		2006-10-31 00:00:00		2007-04-23 00:00:00		2007-01-10 00:00:00		2007-01-31 00:00:00		2007-07-30 00:00:00		2007-06-12 00:00:00		2007-10-31 00:00:00		2013-07-26 00:00:00		2015-07-31 00:00:00		2015-04-29 00:00:00		2014-07-24 00:00:00		2013-10-30 00:00:00		2014-12-09 00:00:00		2014-10-22 00:00:00		2008-01-18 00:00:00		2008-04-29 00:00:00		2008-07-25 00:00:00		2008-10-30 00:00:00		2009-01-29 00:00:00		2008-12-30 00:00:00		2009-04-30 00:00:00		2009-07-30 00:00:00		2009-10-21 00:00:00		2010-01-28 00:00:00		2010-04-29 00:00:00		2010-07-28 00:00:00		2010-10-29 00:00:00		2010-12-23 00:00:00		2011-02-14 00:00:00		2011-02-15 00:00:00		2011-04-26 00:00:00		2011-01-28 00:00:00		2011-10-28 00:00:00		2012-01-30 00:00:00		2011-07-28 00:00:00		2012-04-30 00:00:00		2012-07-30 00:00:00		2014-01-31 00:00:00		2015-01-09 00:00:00		2015-01-30 00:00:00		2012-10-30 00:00:00		2012-12-28 00:00:00		2013-01-25 00:00:00		2012-12-31 00:00:00		2014-04-15 00:00:00		2013-04-26 00:00:00		2015-11-02 00:00:00		2019-07-31 00:00:00		2020-07-29 00:00:00		2018-12-27 00:00:00		2019-04-30 00:00:00		2017-10-28 00:00:00		2018-01-31 00:00:00		2020-11-02 00:00:00		2016-02-01 00:00:00		2016-05-02 00:00:00		2016-07-27 00:00:00		2016-10-27 00:00:00		2017-01-25 00:00:00		2017-04-29 00:00:00		2016-12-22 00:00:00		2017-07-31 00:00:00		2019-01-02 00:00:00		2020-01-29 00:00:00		2019-01-30 00:00:00		2018-10-31 00:00:00		2019-10-29 00:00:00		2020-04-29 00:00:00		2018-04-25 00:00:00		2019-05-22 00:00:00		2018-07-31 00:00:00		2021-01-31 00:00:00		2021-10-31 00:00:00		2021-12-17 00:00:00		2020-12-30 00:00:00		2021-07-30 00:00:00		2020-12-30 00:00:00		2022-05-02 00:00:00		2022-01-26 00:00:00		2021-04-28 00:00:00		2022-07-29 00:00:00		2022-10-30 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10005		10005		10005		10005		10001		10005		10005		10001		10001		10005		10001		10005		10001		10001		10005		10005		10001		10001		10005		10005		10005		10001		10005		10005		10001		10001		10005		10005		10001		10001		10005		10001		10005		10005		10001		10005		10005		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		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		10002		10001		10001		10001		10002		10001		10001		10005		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11003		11003		11001		11001		11003		11001		11001		11003		11003		11001		11001		11003		11003		11001		11003		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003
session_id		1997		1995		1999		1995		1999		1995		1997		1997		1997		1995		1997		1995		1997		1999		1995		1995		1995		1997		1997		1999		1999		1999		1999		1999		1999		2001		1999		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2003		2003		2003		2005		2003		2005		2005		2005		2005		2005		2005		2007		2007		2005		2007		2007		2007		2013		2015		2015		2013		2013		2015		2013		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2009		2011		2011		2011		2011		2011		2013		2015		2013		2011		2013		2011		2013		2013		2013		2015		2019		2019		2019		2019		2017		2017		2019		2015		2015		2015		2015		2015		2017		2017		2017		2019		2019		2017		2017		2019		2019		2017		2019		2017		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		*		YBONILLA		YBONILLA		YBONILLA		NJACKSON		*		YBONILLA		YBONILLA		*		*		LTHIBAUL		*		LTHIBAUL		*		*		LTHIBAUL		LTHIBAUL		*		*		RALLMOND		GPEREZ		LTHIBAUL		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		SARRIAGA		LTHIBAUL		COMPLETED		LTHIBAUL		CFLAGG		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		LTHIBAUL		COMPLETED		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		CFLAGG		LTHIBAUL		LTHIBAUL		SARRIAGA		LTHIBAUL		AGLADNEY		AGLADNEY		MPACHECO		AGLADNEY		AGLADNEY		GPEREZ		AGLADNEY		LTHIBAUL		LTHIBAUL		YRODRIGU		JGRISSUM		JGRISSUM		SARRIAGA		JGRISSUM		JGRISSUM		MGUERRA		JINGRAM		ASAETERN		ASAETERN		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		CAFILER		AGLADNEY		AGLADNEY		SARRIAGA		ASAETERN		SARRIAGA		ASAETERN		AGLADNEY		AGLADNEY		SUSHAKOV		GTAYLOR		YRODRIGU		VUKSTINA		AGLADNEY		AGLADNEY		GTAYLOR		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		SARRIAGA		AGLADNEY		YRODRIGU		GTAYLOR		AGLADNEY		AGLADNEY		VUKSTINA		GTAYLOR		AGLADNEY		VUKSTINA		AGLADNEY		GTAYLOR		GTAYLOR		GTAYLOR		SARRIAGA		GTAYLOR		SARRIAGA		CAFILER		CHATRIDGE		GTAYLOR		CAFILER		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11002		11003		11003		11002		11003		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		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		11003		11003		11003		11001		11001		11001		11001		11001		11003		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		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11003		11003
rpt_start		1997-10-01 00:00:00		1996-01-01 00:00:00		1999-01-01 00:00:00		1995-01-01 00:00:00		1999-07-01 00:00:00		1995-10-01 00:00:00		1997-04-01 00:00:00		1998-10-01 00:00:00		1998-04-01 00:00:00		1996-07-01 00:00:00		1998-07-01 00:00:00		1996-10-01 00:00:00		1997-01-01 00:00:00		1999-04-01 00:00:00		1995-07-01 00:00:00		1995-04-01 00:00:00		1996-04-01 00:00:00		1997-07-01 00:00:00		1998-01-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-04-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		1900-01-01 00:00:00		2000-10-01 00:00:00		2001-01-01 00:00:00		2000-10-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		2002-04-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-01-01 00:00:00		1900-01-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		1900-01-01 00:00:00		2004-04-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2004-10-01 00:00:00		2005-04-01 00:00:00		2005-10-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		1900-01-01 00:00:00		2006-10-01 00:00:00		2007-04-01 00:00:00		1900-01-01 00:00:00		2007-07-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2014-04-01 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2007-10-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		1900-01-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		1900-01-01 00:00:00		2011-02-14 00:00:00		2011-02-15 00:00:00		2011-01-01 00:00:00		2010-10-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2011-04-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2013-10-01 00:00:00		2015-01-09 00:00:00		2014-10-01 00:00:00		2012-07-01 00:00:00		1900-01-01 00:00:00		2012-10-01 00:00:00		2012-12-31 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2019-04-01 00:00:00		2020-04-01 00:00:00		1900-01-01 00:00:00		2019-01-01 00:00:00		2017-07-01 00:00:00		2017-10-01 00:00:00		2020-07-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2019-01-02 00:00:00		2019-10-01 00:00:00		2018-10-01 00:00:00		2018-07-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2018-04-01 00:00:00		2020-10-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2020-12-31 00:00:00		2021-04-01 00:00:00		1900-01-01 00:00:00		2022-01-01 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		2022-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		1997-12-31 00:00:00		1996-03-31 00:00:00		1999-03-31 00:00:00		1995-03-31 00:00:00		1999-09-30 00:00:00		1995-12-31 00:00:00		1997-06-30 00:00:00		1998-12-31 00:00:00		1998-06-30 00:00:00		1996-09-30 00:00:00		1998-09-30 00:00:00		1996-12-31 00:00:00		1997-03-31 00:00:00		1999-06-30 00:00:00		1995-09-30 00:00:00		1995-06-30 00:00:00		1996-06-30 00:00:00		1997-09-30 00:00:00		1998-03-31 00:00:00		1999-12-31 00:00:00		2000-03-31 00:00:00		2000-09-30 00:00:00		2000-06-30 00:00:00		2000-03-31 00:00:00		2000-09-30 00:00:00		1900-01-01 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-03-31 00:00:00		1900-01-01 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2004-03-31 00:00:00		1900-01-01 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-09-30 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2007-03-31 00:00:00		1900-01-01 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		1900-01-01 00:00:00		2007-09-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2007-12-31 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		1900-01-01 00:00:00		2011-02-14 00:00:00		2011-02-15 00:00:00		2011-03-31 00:00:00		2010-12-31 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2015-01-09 00:00:00		2014-12-31 00:00:00		2012-09-30 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2019-06-30 00:00:00		2020-06-30 00:00:00		1900-01-01 00:00:00		2019-03-31 00:00:00		2017-09-30 00:00:00		2017-12-31 00:00:00		2020-09-30 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2019-01-02 00:00:00		2019-12-31 00:00:00		2018-12-31 00:00:00		2018-09-30 00:00:00		2019-09-30 00:00:00		2020-03-31 00:00:00		2018-03-31 00:00:00		2019-03-31 00:00:00		2018-06-30 00:00:00		2020-12-31 00:00:00		2021-09-30 00:00:00		2021-09-30 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		1900-01-01 00:00:00		2022-03-31 00:00:00		2021-12-31 00:00:00		2021-03-31 00:00:00		2022-06-30 00:00:00		2022-09-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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		22001		None		None		22001		22001		None		None		22001		22001		None		22001		None		None		22001		None		None		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001

Table: filer_interests

filer_id		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870
session_id		1997		1999		1995		2001		2003		2011		2007		2013		2009		2005		2017		2019		2015		2023		2021
interest_cd		40312		40312		40312		40312		40312		40312		40312		40315		40312		40312		40312		40312		40315		40312		40312
effect_date		1997-01-01 00:00:00		1999-01-01 00:00:00		1995-01-01 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2011-01-01 00:00:00		2007-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2005-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00		2023-01-01 00:00:00		2021-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870
filer_type		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
session_id		1997		1995		1999		2001		2003		2005		2007		2011		2013		2009		2019		2021		2015		2017		2023
category		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
category_type		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
sub_category		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
effect_dt		1997-01-01 00:00:00		1995-01-01 00:00:00		1999-01-01 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
election_type		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		2000-07-01 00:00:00		2000-07-01 00:00:00		None		None		None		None		None		None		None		None
party_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
county_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
district_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1142870
xref_id		C00147
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147		C00147
filer_id		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870
filer_type		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTION ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION		CALIFORNIA DISTRIBUTORS ASSOCIATION
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
phon		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843		9164467841		9164467841		9164467841		9164467841		9164467843		9164467841		9164467841		9164467841		9164467841		9164467841		9164467841		9164467843		9164467843		9164467843
fax		None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961								None		9164425961								9164425961		9164425961		9164425961		9164425961				9164425961
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1142870

Table: received_filings

filer_id		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870		1142870
filing_file_name		681294_0.cal		717853_0.cal		743326_0.cal		767923_0.cal		788647_0.cal		811479_0.cal		837486_0.cal		851626_0.cal		883085_0.cal		909212_0.cal		930881_0.cal		946791_0.cal		968714_0.cal		988306_0.cal		1011335_0.cal		1057270_0.cal		1082076_0.cal		1102440_0.cal		1114045_0.cal		1142254_0.cal		1131999_0.cal		1163133_0.cal		1189706_0.cal		1328030_0.cal		1504222_0.cal		1394146_0.cal		1346262_0.cal		1484197_0.cal		1462395_0.cal		1448915_0.cal		1217007_0.cal		1236801_0.cal		67265.cal		1258661_0.cal		1283240_0.cal		1436221_0.cal		1421966_0.cal		1304516_0.cal		1297467_0.cal		1376173_0.cal		1732827_0.cal		1676780_0.cal		1838423_0.cal		1799366_0.cal		1588495_0.cal		1569297_0.cal		1817671_0.cal		1605704_0.cal		1778932_0.cal		1762337_0.cal		1633750_0.cal		1621229_0.cal		1707136_0.cal		1657065_0.cal		1865923_0.cal		2123727_0.cal		2059243_0.cal		2011801_0.cal		1997962_0.cal		2098402_0.cal		1902129_0.cal		1964310_0.cal		2037339_0.cal		1982454_0.cal		1934202_0.cal		2175800_0.cal		2156504_0.cal		2211263_0.cal		2191502_0.cal		2417248_0.cal		2331671_0.cal		2381928_1.cal		2469727_0.cal		2397981_0.cal		2483309_0.cal		2439042_0.cal		2381928_0.cal		2345417_0.cal		2318720_0.cal		2235957_0.cal		2275772_0.cal		2623632_0.cal		433796.cal		2531532_0.cal		2552190_0.cal		2677056_0.cal		2578495_0.cal		2601650_0.cal		2623632_1.cal		2704913_0.cal		2746986_0.cal		2638514_0.cal
received_date		2000-10-30 00:00:00		2001-01-30 00:00:00		2001-04-24 00:00:00		2001-07-16 00:00:00		2001-10-23 00:00:00		2002-01-28 00:00:00		2002-04-25 00:00:00		2002-07-24 00:00:00		2002-10-30 00:00:00		2003-01-29 00:00:00		2003-04-30 00:00:00		2003-07-30 00:00:00		2003-10-29 00:00:00		2004-01-29 00:00:00		2004-04-26 00:00:00		2004-10-29 00:00:00		2005-02-01 00:00:00		2005-04-25 00:00:00		2005-07-25 00:00:00		2006-01-18 00:00:00		2005-10-27 00:00:00		2006-04-19 00:00:00		2006-07-29 00:00:00		2008-04-29 00:00:00		2010-07-28 00:00:00		2009-01-29 00:00:00		2008-07-25 00:00:00		2010-04-29 00:00:00		2010-01-28 00:00:00		2009-10-21 00:00:00		2006-10-31 00:00:00		2007-01-31 00:00:00		2007-01-31 00:00:00		2007-04-23 00:00:00		2007-07-30 00:00:00		2009-07-30 00:00:00		2009-04-30 00:00:00		2008-01-18 00:00:00		2007-10-31 00:00:00		2008-10-30 00:00:00		2013-01-25 00:00:00		2012-07-30 00:00:00		2014-04-15 00:00:00		2013-10-30 00:00:00		2011-04-26 00:00:00		2011-01-28 00:00:00		2014-01-31 00:00:00		2011-07-28 00:00:00		2013-07-26 00:00:00		2013-04-26 00:00:00		2012-01-30 00:00:00		2011-10-28 00:00:00		2012-10-30 00:00:00		2012-04-30 00:00:00		2014-07-24 00:00:00		2017-01-25 00:00:00		2016-07-27 00:00:00		2016-02-01 00:00:00		2015-11-02 00:00:00		2016-10-27 00:00:00		2014-10-22 00:00:00		2015-04-29 00:00:00		2016-05-02 00:00:00		2015-07-31 00:00:00		2015-01-30 00:00:00		2017-07-31 00:00:00		2017-04-29 00:00:00		2018-01-31 00:00:00		2017-10-28 00:00:00		2019-10-29 00:00:00		2019-01-02 00:00:00		2019-05-22 00:00:00		2020-04-29 00:00:00		2019-07-31 00:00:00		2020-07-29 00:00:00		2020-01-29 00:00:00		2019-04-30 00:00:00		2019-01-30 00:00:00		2018-10-31 00:00:00		2018-04-25 00:00:00		2018-07-31 00:00:00		2021-10-31 00:00:00		2020-11-02 00:00:00		2020-11-02 00:00:00		2021-01-31 00:00:00		2022-05-02 00:00:00		2021-04-28 00:00:00		2021-07-30 00:00:00		2021-12-17 00:00:00		2022-07-29 00:00:00		2022-10-30 00:00:00		2022-01-26 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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
filing_id		681294		717853		743326		767923		788647		811479		837486		851626		883085		909212		930881		946791		968714		988306		1011335		1057270		1082076		1102440		1114045		1142254		1131999		1163133		1189706		1328030		1504222		1394146		1346262		1484197		1462395		1448915		1217007		1236801		None		1258661		1283240		1436221		1421966		1304516		1297467		1376173		1732827		1676780		1838423		1799366		1588495		1569297		1817671		1605704		1778932		1762337		1633750		1621229		1707136		1657065		1865923		2123727		2059243		2011801		1997962		2098402		1902129		1964310		2037339		1982454		1934202		2175800		2156504		2211263		2191502		2417248		2331671		2381928		2469727		2397981		2483309		2439042		2381928		2345417		2318720		2235957		2275772		2623632		None		2531532		2552190		2677056		2578495		2601650		2623632		2704913		2746986		2638514
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		F635
receive_comment		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		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 accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted