Home

Filer ID: 1142929

Table: filer_address

filer_id		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929
adrid		1107287		1107179		2044421		2078566		2115243		2163319		2208216		2416232		2469949		2547022		2281880		2508275		2341986
effect_dt		1997-01-01 00:00:00		1999-01-01 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		2019-01-01 00:00:00		2023-01-01 00:00:00		2013-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1997		1999		2003		2005		2007		2009		2011		2017		2019		2023		2013		2021		2015

Table: filer_filings

filer_id		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929
filing_id		469298		472714		468091		467340		498428		487605		491173		491325		495005		483977		487456		540985		472714		472714		479147		474824		478299		483977		494849		473599		464170		474824		480404		487456		629291		618717		639074		678246		662983		694544		712243		714564		756434		743022		735778		769211		786236		772602		781377		807978		796112		844224		837467		820613		859696		850253		905584		876757		893839		920829		907596		902848		936024		943278		928423		950066		965890		973568		1001265		985207		1010249		1034848		1017075		1024963		1049859		1074841		1071612		1067614		1102319		1083281		1092587		1064036		1113731		1085009		1128722		1144374		1164385		1187593		1201595		1213458		1241856		1258531		1226021		1233228		1280724		1940616		1862749		1809351		1774663		1956116		1895787		1326762		1305341		1295091		1346011		1373048		1392700		1386511		1418460		1408847		1432198		1461880		1479819		1450013		1501506		1528491		1560715		1558519		1555300		1587084		1626739		1599969		1617874		1651235		1671760		1794490		1693711		1926112		1921787		1716644		1724874		1730033		1838456		1758967		1972931		1991716		2307213		2232225		2363497		2430538		2003219		2027392		2053846		2087491		2119258		2114513		2149590		2132330		2166744		2478641		2412632		2374065		2186672		2585062		2329855		2336965		2579606		2462987		2462994		2466010		2466010		2390394		2527883		2266035		2202025		2527883		2595071		2668118		2551921		2620493		2594723		2636851		2478641		2699095		2595071		2551641		2737602
period_id		142		150		157		149		156		146		154		147		148		145		153		152		150		150		159		143		151		145		155		158		141		143		144		153		None		160		None		163		162		163		None		164		165		165		164		166		167		None		None		168		None		None		169		None		None		170		172		171		None		None		None		None		None		174		173		174		175		None		None		176		177		None		None		178		179		180		181		180		181		None		None		None		182		None		183		184		185		186		None		187		None		189		189		188		190		None		218		216		214		221		219		193		192		191		194		195		196		196		197		None		198		200		201		199		202		203		None		204		204		205		208		206		207		209		210		215		211		220		220		212		212		None		217		213		222		223		235		233		None		240		224		225		226		227		228		228		229		None		230		242		239		237		231		None		236		236		245		None		None		241		241		238		243		234		232		243		246		249		245		247		None		248		242		250		246		244		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F690		F635		F690		F635		F690		F635		F635		F635		F635		F635		F690		F635		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F605		F635		F602		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F602		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F602		F602		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		2		1		0		1		0		1		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		1		1		0		0		0		0		0		1		0		0		0		0
filing_date		1995-07-31 00:00:00		1997-07-31 00:00:00		1999-04-30 00:00:00		1997-04-30 00:00:00		1999-02-01 00:00:00		1996-07-31 00:00:00		1998-07-31 00:00:00		1996-10-31 00:00:00		1997-01-31 00:00:00		1996-04-30 00:00:00		1998-04-30 00:00:00		1998-02-02 00:00:00		1998-03-27 00:00:00		1998-01-01 00:00:00		1999-11-01 00:00:00		1995-10-31 00:00:00		1997-10-31 00:00:00		1996-06-04 00:00:00		1998-11-02 00:00:00		1999-08-02 00:00:00		1995-05-01 00:00:00		1995-10-31 00:00:00		1996-01-31 00:00:00		1998-10-13 00:00:00		2000-05-01 00:00:00		2000-01-31 00:00:00		2000-05-11 00:00:00		2000-10-27 00:00:00		2000-07-31 00:00:00		2000-10-31 00:00:00		2000-12-29 00:00:00		2001-01-25 00:00:00		2001-04-30 00:00:00		2001-04-23 00:00:00		2001-01-31 00:00:00		2001-07-23 00:00:00		2001-10-10 00:00:00		2001-07-30 00:00:00		2001-07-31 00:00:00		2002-01-17 00:00:00		2001-10-31 00:00:00		2002-04-30 00:00:00		2002-04-25 00:00:00		2002-01-31 00:00:00		2002-07-31 00:00:00		2002-07-18 00:00:00		2003-01-23 00:00:00		2002-10-23 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2003-01-07 00:00:00		2002-12-31 00:00:00		2003-04-30 00:00:00		2003-07-21 00:00:00		2003-04-22 00:00:00		2003-07-31 00:00:00		2003-10-21 00:00:00		2003-10-31 00:00:00		2004-02-02 00:00:00		2004-01-22 00:00:00		2004-04-21 00:00:00		2004-07-30 00:00:00		2004-04-30 00:00:00		2004-07-22 00:00:00		2004-10-20 00:00:00		2005-01-24 00:00:00		2005-01-12 00:00:00		2004-12-22 00:00:00		2005-04-25 00:00:00		2004-12-31 00:00:00		2005-01-31 00:00:00		2004-10-29 00:00:00		2005-07-25 00:00:00		2004-12-31 00:00:00		2005-10-19 00:00:00		2006-01-25 00:00:00		2006-04-25 00:00:00		2006-07-26 00:00:00		2006-09-22 00:00:00		2006-10-27 00:00:00		2007-01-02 00:00:00		2007-04-23 00:00:00		2007-01-02 00:00:00		2007-01-28 00:00:00		2007-07-25 00:00:00		2014-12-30 00:00:00		2014-07-14 00:00:00		2014-01-09 00:00:00		2013-07-10 00:00:00		2015-04-06 00:00:00		2014-10-09 00:00:00		2008-04-24 00:00:00		2008-01-23 00:00:00		2007-10-25 00:00:00		2008-07-25 00:00:00		2008-10-28 00:00:00		2009-01-27 00:00:00		2008-12-30 00:00:00		2009-04-23 00:00:00		2008-12-30 00:00:00		2009-07-21 00:00:00		2010-01-28 00:00:00		2010-04-14 00:00:00		2009-10-27 00:00:00		2010-07-20 00:00:00		2010-10-18 00:00:00		2010-12-30 00:00:00		2011-01-10 00:00:00		2010-12-29 00:00:00		2011-04-20 00:00:00		2012-01-04 00:00:00		2011-07-13 00:00:00		2011-10-18 00:00:00		2012-04-09 00:00:00		2012-07-16 00:00:00		2013-10-16 00:00:00		2012-10-04 00:00:00		2015-01-16 00:00:00		2014-12-30 00:00:00		2012-12-10 00:00:00		2013-01-14 00:00:00		2012-12-28 00:00:00		2014-04-15 00:00:00		2013-04-17 00:00:00		2015-07-06 00:00:00		2015-10-13 00:00:00		2018-10-16 00:00:00		2018-04-18 00:00:00		2018-12-27 00:00:00		2020-01-14 00:00:00		2016-01-11 00:00:00		2016-04-11 00:00:00		2016-07-07 00:00:00		2016-10-11 00:00:00		2017-01-12 00:00:00		2016-12-28 00:00:00		2017-04-05 00:00:00		2016-12-28 00:00:00		2017-07-12 00:00:00		2020-07-15 00:00:00		2019-10-10 00:00:00		2019-04-17 00:00:00		2017-10-05 00:00:00		2021-01-21 00:00:00		2018-12-27 00:00:00		2019-01-22 00:00:00		2021-04-29 00:00:00		2020-03-12 00:00:00		2020-03-12 00:00:00		2020-04-16 00:00:00		2020-04-30 00:00:00		2019-07-16 00:00:00		2020-10-30 00:00:00		2018-07-18 00:00:00		2018-01-16 00:00:00		2021-09-28 00:00:00		2021-07-31 00:00:00		2022-04-20 00:00:00		2021-01-30 00:00:00		2021-10-27 00:00:00		2021-01-13 00:00:00		2022-01-24 00:00:00		2021-09-28 00:00:00		2022-07-19 00:00:00		2021-07-21 00:00:00		2021-01-30 00:00:00		2022-10-20 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10005		10005		10005		10001		10005		10001		10005		10001		10001		10005		10005		10001		10005		10005		10001		10005		10005		10001		10001		10001		10005		10005		10005		10005		10005		10001		10001		10005		10001		10005		10005		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10005		10001		10001		10001		10001		10005		10001		10005		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		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10005		10001		10002		10001		10001		10001		10001		10002		10002		10001		10001		10001		10005		10001		10002		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		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11003		11001		11003		11003		11001		11001		11003		11001		11001		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		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		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11001		11003
session_id		1995		1997		1999		1997		1997		1995		1997		1995		1995		1995		1997		1997		1997		1997		1999		1995		1997		1995		1997		1999		1995		1995		1995		1997		1999		1999		1999		1999		1999		1999		2001		1999		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2005		2007		2015		2013		2013		2013		2015		2013		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2009		2011		2011		2011		2011		2011		2011		2011		2013		2011		2013		2015		2013		2011		2013		2013		2013		2015		2015		2017		2017		2019		2019		2015		2015		2015		2015		2015		2017		2017		2017		2017		2019		2019		2019		2017		2021		2019		2017		2021		2019		2019		2019		2019		2019		2019		2017		2017		2019		2021		2021		2021		2021		2021		2021		2019		2021		2021		2019		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		CFLAGG		GPEREZ		*		YBONILLA		YBONILLA		TTHAM		*		PROBERTS		*		YBONILLA		*		*		CFLAGG		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		*		COMPLETED		*		LTHIBAUL		LTHIBAUL		SARRIAGA		BSMITH		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		YBONILLA		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		SARRIAGA		LTHIBAUL		LTHIBAUL		LTHIBAUL		SARRIAGA		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		CFLAGG		LTHIBAUL		SARRIAGA		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		JINGRAM		JINGRAM		*		MGUERRA		PBANFORD		MGUERRA		JINGRAM		ASAETERN		MGUERRA		ASAETERN		ASAETERN		PBANFORD		AGLADNEY		*		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		PBANFORD		AGLADNEY		PBANFORD		AGLADNEY		ASAETERN		AGLADNEY		JINGRAM		AGLADNEY		AGLADNEY		GPEREZ		VUKSTINA		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		AGLADNEY		SARRIAGA		AGLADNEY		MKIRKHAM		GTAYLOR		VUKSTINA		AGLADNEY		SARRIAGA		GPEREZ		AGLADNEY		GTAYLOR		GPEREZ		GPEREZ		VUKSTINA		SUSHAKOV		VUKSTINA		GTAYLOR		AGLADNEY		AGLADNEY		GTAYLOR		GTAYLOR		CAFILER		CAFILER		MKIRKHAM		CVANLIEW		CHATRIDGE		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11003		11002		11002		11003		11003		11003		11002		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		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11001		11003		11003		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		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		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11003		11001		11001		11003
rpt_start		1995-04-01 00:00:00		1997-04-01 00:00:00		1999-01-01 00:00:00		1997-01-01 00:00:00		1998-10-01 00:00:00		1996-04-01 00:00:00		1998-04-01 00:00:00		1996-07-01 00:00:00		1996-10-01 00:00:00		1996-01-01 00:00:00		1998-01-01 00:00:00		1997-10-01 00:00:00		1997-04-01 00:00:00		1997-04-01 00:00:00		1999-07-01 00:00:00		1995-07-01 00:00:00		1997-07-01 00:00:00		1996-01-01 00:00:00		1998-07-01 00:00:00		1999-04-01 00:00:00		1995-01-01 00:00:00		1995-07-01 00:00:00		1995-10-01 00:00:00		1998-01-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		None		2000-07-01 00:00:00		2000-04-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		2001-01-01 00:00:00		2000-10-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		1900-01-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2002-01-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-10-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2005-01-13 00:00:00		2004-12-22 00:00:00		2005-01-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2005-04-01 00:00:00		1900-01-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		1900-01-01 00:00:00		2006-07-01 00:00:00		1900-01-01 00:00:00		2007-01-01 00:00:00		2007-01-02 00:00:00		2006-10-01 00:00:00		2007-04-01 00:00:00		1900-01-01 00:00:00		2014-04-01 00:00:00		2013-10-01 00:00:00		2013-04-01 00:00:00		2015-01-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2007-10-01 00:00:00		2007-07-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-12-30 00:00:00		2009-01-01 00:00:00		1900-01-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2009-07-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2010-12-29 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2013-07-01 00:00:00		2012-07-01 00:00:00		2014-10-01 00:00:00		2014-12-30 00:00:00		2012-12-10 00:00:00		2012-10-01 00:00:00		1900-01-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2015-04-01 00:00:00		2015-07-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		1900-01-01 00:00:00		2019-10-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		2016-12-28 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2020-04-01 00:00:00		2019-07-01 00:00:00		2019-01-01 00:00:00		2017-07-01 00:00:00		1900-01-01 00:00:00		2018-12-27 00:00:00		2018-10-01 00:00:00		2021-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2019-04-01 00:00:00		2020-07-01 00:00:00		2018-04-01 00:00:00		2017-10-01 00:00:00		2020-07-01 00:00:00		2021-04-01 00:00:00		2022-01-01 00:00:00		2021-01-30 00:00:00		2021-07-01 00:00:00		1900-01-01 00:00:00		2021-10-01 00:00:00		2020-04-01 00:00:00		2022-04-01 00:00:00		2021-04-01 00:00:00		2020-10-01 00:00:00		2022-07-01 00:00:00
rpt_end		1995-06-30 00:00:00		1997-06-30 00:00:00		1999-03-31 00:00:00		1997-03-31 00:00:00		1998-12-31 00:00:00		1996-06-30 00:00:00		1998-06-30 00:00:00		1996-09-30 00:00:00		1996-12-31 00:00:00		1996-03-31 00:00:00		1998-03-31 00:00:00		1997-12-31 00:00:00		1997-06-30 00:00:00		1997-06-30 00:00:00		1999-09-30 00:00:00		1995-09-30 00:00:00		1997-09-30 00:00:00		1996-03-31 00:00:00		1998-09-30 00:00:00		1999-06-30 00:00:00		1995-03-31 00:00:00		1995-09-30 00:00:00		1995-12-31 00:00:00		1998-03-31 00:00:00		2000-03-31 00:00:00		1999-12-31 00:00:00		None		2000-09-30 00:00:00		2000-06-30 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		2001-03-31 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		1900-01-01 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2002-03-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-12-31 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2005-01-13 00:00:00		2004-12-22 00:00:00		2005-03-31 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2005-06-30 00:00:00		1900-01-01 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		1900-01-01 00:00:00		2006-09-30 00:00:00		1900-01-01 00:00:00		2007-03-31 00:00:00		2007-01-02 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		1900-01-01 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2013-06-30 00:00:00		2015-03-31 00:00:00		2014-09-30 00:00:00		2008-03-31 00:00:00		2007-12-31 00:00:00		2007-09-30 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2008-12-30 00:00:00		2009-03-31 00:00:00		1900-01-01 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		2009-09-30 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2010-12-29 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2013-09-30 00:00:00		2012-09-30 00:00:00		2014-12-31 00:00:00		2014-12-30 00:00:00		2012-12-10 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2014-03-31 00:00:00		2013-03-31 00:00:00		2015-06-30 00:00:00		2015-09-30 00:00:00		2018-09-30 00:00:00		2018-03-31 00:00:00		1900-01-01 00:00:00		2019-12-31 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		2016-12-28 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2020-06-30 00:00:00		2019-09-30 00:00:00		2019-03-31 00:00:00		2017-09-30 00:00:00		1900-01-01 00:00:00		2018-12-27 00:00:00		2018-12-31 00:00:00		2021-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-03-31 00:00:00		2020-03-31 00:00:00		2019-06-30 00:00:00		2020-09-30 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2020-09-30 00:00:00		2021-06-30 00:00:00		2022-03-31 00:00:00		2021-01-30 00:00:00		2021-09-30 00:00:00		1900-01-01 00:00:00		2021-12-31 00:00:00		2020-06-30 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		2020-12-31 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		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		None		None		None		22001		None		None		None		None		None		None		22001		22001		None		22001		None		None		22001		22001		None		None		22001		22001		22001		22001		22001		22001		None		None		None		22001		None		22001		22001		22001		22001		None		22001		None		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		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		None		22001		22001		22006		None		None		22001		22006		22001		22001		22001		22001		22006		22006		22006		22001		22006		None		22006		22006		22006		22006		22006		22006

Table: filer_interests

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

Table: filer_to_filer_type

filer_id		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929
filer_type		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
active		Y		Y		Y		Y		Y		Y		Y		T		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None		None
session_id		1995		1997		1999		2001		2003		2005		2007		2005		2013		2011		2009		2015		2021		2019		2017		2023
category		0		0		0		0		None		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		None
sub_category		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		1995-01-01 00:00:00		1997-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		2005-05-20 00:00:00		2013-01-01 00:00:00		2011-01-01 00:00:00		2009-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2019-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		None
election_type		0		0		0		0		None		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		None
nyq_dt		None		None		None		None		None		2000-07-01 00:00:00		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		None
county_cd		None		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		None

Table: filer_xref

filer_id		1142929
xref_id		C00369
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369		C00369
filer_id		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929
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		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		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		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		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE AND COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF
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		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		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		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		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		None		None		None		None		None		None		None		None		None		None		None		None
city		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE		COMMERCE
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		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410		900401487		90040		900401487		900401487		900401487		900401487		900401487		900401410		900401410		900401410		900401410		900401410		900401410
phon		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		2137224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805		3237224805
fax		3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None																								3238384243		None
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		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1142929

Table: lobbying_chg_log

filer_id		1142929		1142929		1142929		1142929
change_no		1		0		2		3
session_id		1997		2001		2003		2005
log_dt		2000-06-26 00:00:00		2001-07-30 00:00:00		2003-01-17 00:00:00		2006-09-22 00:00:00
filer_type		1		1		1		1
correction_flg		None		Y		None		None
action		CHANGED		ADDED		CHANGED		DELETED
attribute_changed		ADDRESS		EMPLOYER		RESPONSIBLE OFFICER		FIRM
ethics_dt		None		None		None		None
interests		None		None		None		None
filer_full_name		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION, CITY OF		COMMERCE/COMMERCE DEVELOPMENT COMMISSION; CITY OF
filer_city		COMMERCE		None		None		None
filer_st		CA		None		None		None
filer_zip		90040		None		None		None
filer_phone		2137224805		None		None		None
entity_type		1		2		20		3
entity_name		COMMERCE/COMMERCE COMMUNITY DEVELOPMENT COMMISSION, CITY OF		LEGISLATIVE ADVOCACY GROUP, INC.		ACTING DIRECTOR OF FINANCE GEORGE E. VARA		LEGISLATIVE ADVOCACY GROUP INC.
entity_city		COMMERCE		None		None		None
entity_st		CA		None		None		None
entity_zip		90040		None		None		None
entity_phone		2137224805		None		None		None
entity_id		1142929		1147624		1252092		1147624
responsible_officer		None		None		None		None
effect_dt		None		2001-01-01 00:00:00		2003-01-01 00:00:00		2005-05-20 00:00:00

Table: received_filings

filer_id		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929		1142929
filing_file_name		714564_0.cal		678246_0.cal		743022_0.cal		769211_0.cal		786236_0.cal		807978_0.cal		837467_0.cal		850253_0.cal		876757_0.cal		905584_0.cal		928423_0.cal		943278_0.cal		965890_0.cal		1074841_0.cal		473886.cal		1102319_0.cal		1113731_0.cal		1128722_0.cal		1144374_0.cal		1164385_0.cal		1187593_0.cal		1501506_0.cal		1392700_0.cal		1346011_0.cal		1461880_0.cal		1450013_0.cal		1213458_0.cal		1233228_0.cal		1479819_0.cal		1280724_0.cal		128766.cal		1258531_0.cal		1432198_0.cal		1295091_0.cal		1373048_0.cal		1418460_0.cal		1326762_0.cal		1305341_0.cal		1528491_0.cal		1671760_0.cal		146952.cal		147190.cal		1724874_0.cal		1838456_0.cal		1794490_0.cal		1587084_0.cal		1693711_0.cal		1617874_0.cal		1558519_0.cal		1809351_0.cal		1599969_0.cal		1758967_0.cal		1774663_0.cal		1626739_0.cal		1651235_0.cal		1862749_0.cal		1972931_0.cal		2149590_0.cal		2053846_0.cal		93187.cal		2003219_0.cal		2119258_0.cal		2087491_0.cal		2027392_0.cal		381435.cal		1895787_0.cal		1926112_0.cal		1956116_0.cal		1991716_0.cal		2166744_0.cal		2307213_0.cal		2390394_0.cal		2232225_0.cal		2466010_0.cal		2186672_0.cal		2374065_0.cal		2336965_0.cal		2478641_0.cal		2430538_0.cal		2412632_0.cal		2266035_0.cal		2202025_0.cal		2527883_0.cal
received_date		2001-01-25 00:00:00		2000-10-27 00:00:00		2001-04-23 00:00:00		2001-07-23 00:00:00		2001-10-10 00:00:00		2002-01-17 00:00:00		2002-04-25 00:00:00		2002-07-18 00:00:00		2002-10-23 00:00:00		2003-01-23 00:00:00		2003-04-22 00:00:00		2003-07-21 00:00:00		2003-10-21 00:00:00		2005-01-24 00:00:00		2004-12-22 00:00:00		2005-04-25 00:00:00		2005-07-25 00:00:00		2005-10-19 00:00:00		2006-01-25 00:00:00		2006-04-25 00:00:00		2006-07-26 00:00:00		2010-07-20 00:00:00		2009-01-27 00:00:00		2008-07-25 00:00:00		2010-01-28 00:00:00		2009-10-27 00:00:00		2006-10-27 00:00:00		2007-01-28 00:00:00		2010-04-14 00:00:00		2007-07-25 00:00:00		2007-07-25 00:00:00		2007-04-23 00:00:00		2009-07-21 00:00:00		2007-10-25 00:00:00		2008-10-28 00:00:00		2009-04-23 00:00:00		2008-04-24 00:00:00		2008-01-23 00:00:00		2010-10-18 00:00:00		2012-07-16 00:00:00		2012-07-16 00:00:00		2012-07-16 00:00:00		2013-01-14 00:00:00		2014-04-15 00:00:00		2013-10-16 00:00:00		2011-04-20 00:00:00		2012-10-04 00:00:00		2011-10-18 00:00:00		2011-01-10 00:00:00		2014-01-09 00:00:00		2011-07-13 00:00:00		2013-04-17 00:00:00		2013-07-10 00:00:00		2012-01-04 00:00:00		2012-04-09 00:00:00		2014-07-14 00:00:00		2015-07-06 00:00:00		2017-04-05 00:00:00		2016-07-07 00:00:00		2015-10-27 00:00:00		2016-01-11 00:00:00		2017-01-12 00:00:00		2016-10-11 00:00:00		2016-04-11 00:00:00		2016-04-11 00:00:00		2014-10-09 00:00:00		2015-01-16 00:00:00		2015-04-06 00:00:00		2015-10-13 00:00:00		2017-07-12 00:00:00		2018-10-16 00:00:00		2019-07-16 00:00:00		2018-04-18 00:00:00		2020-04-16 00:00:00		2017-10-05 00:00:00		2019-04-17 00:00:00		2019-01-22 00:00:00		2020-07-15 00:00:00		2020-01-14 00:00:00		2019-10-10 00:00:00		2018-07-18 00:00:00		2018-01-16 00:00:00		2020-10-30 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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/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/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/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
filing_id		714564		678246		743022		769211		786236		807978		837467		850253		876757		905584		928423		943278		965890		1074841		None		1102319		1113731		1128722		1144374		1164385		1187593		1501506		1392700		1346011		1461880		1450013		1213458		1233228		1479819		1280724		None		1258531		1432198		1295091		1373048		1418460		1326762		1305341		1528491		1671760		None		None		1724874		1838456		1794490		1587084		1693711		1617874		1558519		1809351		1599969		1758967		1774663		1626739		1651235		1862749		1972931		2149590		2053846		None		2003219		2119258		2087491		2027392		None		1895787		1926112		1956116		1991716		2166744		2307213		2390394		2232225		2466010		2186672		2374065		2336965		2478641		2430538		2412632		2266035		2202025		2527883
form_id		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		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		F635		F635		F635		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
receive_comment		Filing accepted, but with warnings		Filing accepted, but but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing 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 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 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