Home

Filer ID: 1149000

Table: filer_address

filer_id		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000
adrid		1105763		1106402		1104139		2013080		1131867		2039917		2042216		2081678		2114187		2160596		2204074		2505843		2470488		2550271		2550272		2279171		2279172		2343018		2411199
effect_dt		1997-01-01 00:00:00		1996-02-08 00:00:00		1999-10-01 00:00:00		2001-01-01 00:00:00		1999-01-01 00:00:00		2002-11-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		2021-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00
add_type		7050		7050		7050		7051		7082		7051		7051		7051		7051		7051		7051		7051		7051		7051		7082		7051		7082		7051		7051
session_id		1997		1995		1999		2001		2001		2001		2003		2005		2007		2009		2011		2021		2019		2023		2023		2013		2013		2015		2017

Table: filer_ethics_class

filer_id		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000
session_id		1999		1997		1995		2001		2003		2005		2007		2009		2011		2013		2015		2019		2017		2021
ethics_date		1999-01-08 00:00:00		1999-01-08 00:00:00		1996-11-13 00:00:00		2001-03-16 00:00:00		2003-05-15 00:00:00		2005-03-17 00:00:00		2007-03-15 00:00:00		2009-03-19 00:00:00		2011-02-24 00:00:00		2013-04-04 00:00:00		2015-04-09 00:00:00		2018-11-15 00:00:00		2017-04-20 00:00:00		2021-01-28 00:00:00

Table: filer_filings

filer_id		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000
filing_id		519481		513197		524767		516349		518435		528866		515305		522682		527793		523623		525748		526864		529758		512178		521526		625333		606901		606903		656577		709834		684192		686114		747631		757743		748625		726978		745092		747631		776932		798921		793637		800042		814630		840216		841689		816751		856732		860229		887983		891555		884151		918760		933582		910434		921691		931287		938051		953521		947320		988877		972510		969670		1029469		993597		1055062		1015531		1035234		1013865		1075394		1067536		1063426		1067536		1103504		1098934		1077913		1086236		1116308		1144284		1131548		1164444		1188299		1214942		1223366		1260442		1259346		1245892		1235672		1282940		1295305		1304538		1777468		1957544		1964065		1976859		1866969		1795312		1946668		1907128		1326393		1347984		1369388		1391276		1407507		1417812		1383827		1419198		1436281		1448748		1459310		1485239		1504224		1538633		1565984		1554510		1559051		1579213		1589437		1605485		1620282		1632901		1655175		1675913		1814926		1932380		1920258		1717402		1737235		1707423		1844456		1766800		1763673		1762284		1995446		2420114		2397140		2241737		2192308		2349989		2310856		2007558		2033226		2059025		2095555		2126412		2113022		2154462		2156011		2133030		2170346		2380639		2467829		2269161		2192308		2444586		2328161		2353765		2211262		2482808		2623524		2604357		2702878		2533314		2675460		2536423		2560013		2544052		2599007		2536423		2641266		2576848		2735514
period_id		159		157		146		158		151		148		150		145		155		153		154		147		156		149		152		161		160		160		162		None		163		163		164		None		165		164		165		164		None		166		None		167		168		169		None		None		170		None		None		None		171		None		None		172		None		173		None		None		174		176		None		175		178		None		179		None		None		177		None		180		None		180		181		None		180		None		182		184		183		185		186		187		188		189		None		None		188		190		191		192		214		None		221		222		218		215		None		219		193		194		195		196		None		None		196		197		198		199		200		201		202		203		204		204		None		None		205		206		207		208		209		210		216		220		220		212		212		211		217		None		213		None		223		239		238		233		231		236		235		224		225		226		227		228		228		229		None		None		230		237		241		234		231		240		236		None		232		242		247		None		250		243		249		241		None		244		246		244		248		245		251
form_id		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F604		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F615		F604		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F604		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F604		F604		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F615		F615		F615		F604		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F604		F615		F615		F615		F615		F615		F615		F604		F604		F615		F615		F615		F604		F615		F615		F615		F604		F604		F615		F615		F604		F615		F615		F615
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		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		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		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		1		0		0		0		0		0		0		0
filing_date		1999-11-01 00:00:00		1999-04-23 00:00:00		1996-08-19 00:00:00		1999-08-02 00:00:00		1997-10-31 00:00:00		1997-02-06 00:00:00		1997-07-31 00:00:00		1996-04-26 00:00:00		1998-10-30 00:00:00		1998-04-30 00:00:00		1998-07-31 00:00:00		1996-10-31 00:00:00		1999-02-01 00:00:00		1997-04-30 00:00:00		1998-01-30 00:00:00		2000-04-28 00:00:00		2000-01-31 00:00:00		2000-01-31 00:00:00		2000-07-31 00:00:00		2000-12-29 00:00:00		2000-11-02 00:00:00		2000-10-31 00:00:00		2001-05-02 00:00:00		2001-05-22 00:00:00		2001-05-01 00:00:00		2001-01-31 00:00:00		2001-04-27 00:00:00		2001-05-09 00:00:00		2001-07-31 00:00:00		2001-11-26 00:00:00		2001-10-31 00:00:00		2001-12-07 00:00:00		2002-01-31 00:00:00		2002-04-30 00:00:00		2002-04-30 00:00:00		2002-01-31 00:00:00		2002-07-31 00:00:00		2002-07-31 00:00:00		2002-10-31 00:00:00		2002-11-07 00:00:00		2002-10-30 00:00:00		2003-01-31 00:00:00		2003-04-30 00:00:00		2003-01-30 00:00:00		2002-12-27 00:00:00		2003-04-30 00:00:00		2003-05-29 00:00:00		2003-07-31 00:00:00		2003-07-31 00:00:00		2004-01-30 00:00:00		2003-10-30 00:00:00		2003-10-31 00:00:00		2004-07-30 00:00:00		2004-02-02 00:00:00		2004-10-27 00:00:00		2004-04-30 00:00:00		2004-08-02 00:00:00		2004-04-30 00:00:00		2004-12-27 00:00:00		2004-12-21 00:00:00		2004-11-01 00:00:00		2005-03-30 00:00:00		2005-04-28 00:00:00		2005-04-01 00:00:00		2005-01-28 00:00:00		2005-01-31 00:00:00		2005-07-28 00:00:00		2006-01-25 00:00:00		2005-10-27 00:00:00		2006-04-25 00:00:00		2006-07-27 00:00:00		2006-10-30 00:00:00		2006-12-13 00:00:00		2007-04-27 00:00:00		2007-03-23 00:00:00		2006-12-29 00:00:00		2007-01-30 00:00:00		2007-07-30 00:00:00		2007-10-26 00:00:00		2008-01-18 00:00:00		2013-07-23 00:00:00		2015-04-09 00:00:00		2015-04-29 00:00:00		2015-07-24 00:00:00		2014-07-26 00:00:00		2013-10-17 00:00:00		2014-12-29 00:00:00		2014-10-28 00:00:00		2008-04-23 00:00:00		2008-07-29 00:00:00		2008-10-23 00:00:00		2009-01-23 00:00:00		2008-12-29 00:00:00		2009-03-26 00:00:00		2008-12-15 00:00:00		2009-04-28 00:00:00		2009-07-30 00:00:00		2009-10-21 00:00:00		2010-01-22 00:00:00		2010-04-30 00:00:00		2010-07-28 00:00:00		2010-10-29 00:00:00		2011-01-25 00:00:00		2010-12-28 00:00:00		2010-12-30 00:00:00		2011-02-24 00:00:00		2011-04-28 00:00:00		2011-07-28 00:00:00		2011-10-27 00:00:00		2012-01-27 00:00:00		2012-04-26 00:00:00		2012-07-27 00:00:00		2014-01-29 00:00:00		2015-01-29 00:00:00		2014-12-23 00:00:00		2012-12-14 00:00:00		2013-01-30 00:00:00		2012-10-30 00:00:00		2014-04-30 00:00:00		2013-04-26 00:00:00		2013-04-29 00:00:00		2012-12-31 00:00:00		2015-10-28 00:00:00		2019-10-31 00:00:00		2019-07-30 00:00:00		2018-04-30 00:00:00		2018-02-26 00:00:00		2019-01-31 00:00:00		2018-10-23 00:00:00		2016-01-27 00:00:00		2016-04-27 00:00:00		2016-07-27 00:00:00		2016-10-25 00:00:00		2017-01-30 00:00:00		2016-12-21 00:00:00		2017-04-27 00:00:00		2017-04-20 00:00:00		2016-12-23 00:00:00		2017-07-24 00:00:00		2019-04-30 00:00:00		2020-04-27 00:00:00		2018-07-25 00:00:00		2017-10-30 00:00:00		2020-02-03 00:00:00		2018-12-14 00:00:00		2018-12-24 00:00:00		2018-01-31 00:00:00		2020-07-29 00:00:00		2021-10-31 00:00:00		2021-04-01 00:00:00		2022-07-28 00:00:00		2020-11-05 00:00:00		2022-04-30 00:00:00		2021-02-17 00:00:00		2020-12-21 00:00:00		2021-01-14 00:00:00		2021-07-29 00:00:00		2020-12-09 00:00:00		2022-01-28 00:00:00		2021-04-26 00:00:00		2022-10-18 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10005		10001		10005		10001		10002		10005		10005		10001		10002		10005		10001		10005		10001		10001		10001		10005		10005		10001		10005		10005		10005		10001		10005		10005		10001		10005		10001		10002		10005		10001		10001		10005		10001		10001		10005		10001		10005		10005		10001		10005		10001		10005		10002		10001		10005		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10006		10005		10001		10001		10001		10001		10001		10006		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10005		10006		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10006		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10006		10001		10005		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10006		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10002		10005		10001		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		11001		11003		11001		11003		11001		11003		11001		11003		11003		11001		11003		11001		11003		11003		11003		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11001		11001		11003		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		11003		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003
session_id		1999		1999		1995		1999		1997		1995		1997		1995		1997		1997		1997		1995		1997		1997		1997		1999		1999		1999		1999		2001		1999		1999		1999		2001		2001		1999		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2003		2005		2005		2005		2003		2003		2005		2005		2005		2005		2005		2005		2007		2007		2007		2007		2005		2007		2007		2007		2013		2015		2015		2015		2013		2013		2015		2013		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2015		2013		2011		2011		2013		2013		2013		2013		2015		2019		2019		2017		2017		2017		2017		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2019		2019		2017		2017		2019		2019		2019		2017		2019		2021		2021		2021		2019		2021		2021		2021		2019		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		GGILMORE		*		GGILMORE		TTHAM		NJACKSON		*		MKIENG		*		GPEREZ		TWALLS		MKIENG		*		*		GPEREZ		*		YBONILLA		*		*		*		YBONILLA		YBONILLA		*		YBONILLA		YBONILLA		CFLAGG		*		YBONILLA		YBONILLA		COMPLETED		GPEREZ		COMPLETED		GPEREZ		YBONILLA		COMPLETED		COMPLETED		YBONILLA		COMPLETED		COMPLETED		EMCENTEE		COMPLETED		EMCENTEE		EMCENTEE		COMPLETED		PBANFORD		COMPLETED		YRODRIGU		COMPLETED		YRODRIGU		CFLAGG		COMPLETED		YRODRIGU		YRODRIGU		LTHIBAUL		YRODRIGU		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		YRODRIGU		CFLAGG		PBANFORD		YRODRIGU		YRODRIGU		LTHIBAUL		YRODRIGU		ASAETERN		PBANFORD		JINGRAM		JINGRAM		ASAETERN		ASAETERN		SARRIAGA		ASAETERN		LTHIBAUL		LTHIBAUL		JINGRAM		JINGRAM		SARRIAGA		YRODRIGU		*		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		ASAETERN		ASAETERN		ASAETERN		*		DMCCASTL		SMCCONNAN		JINGRAM		ASAETERN		ASAETERN		ASAETERN		ASAETERN		AGLADNEY		ASAETERN		AGLADNEY		SARRIAGA		SARRIAGA		ASAETERN		ASAETERN		ASAETERN		SMCCONNAN		ASAETERN		SARRIAGA		JINGRAM		VUKSTINA		VUKSTINA		AGLADNEY		AGLADNEY		JFRONEFIELD		JFRONEFIELD		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		CAFILER		AGLADNEY		PBANFORD		GPEREZ		SMCCONNAN		VUKSTINA		VUKSTINA		AGLADNEY		AGLADNEY		DWALKER		PBANFORD		PBANFORD		AGLADNEY		CVANLIEW		MKIRKHAM		CVANLIEW		CAFILER		GTAYLOR		CAFILER		CVANLIEW		MKIRKHAM		JRAMOS		GTAYLOR		MKIRKHAM		RATTIYEH		CHARTRIDGE		CAFILER
special_audit		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		11002		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		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11001		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11003
rpt_start		1999-07-01 00:00:00		1999-01-01 00:00:00		1996-04-01 00:00:00		1999-04-01 00:00:00		1997-07-01 00:00:00		1996-10-01 00:00:00		1997-04-01 00:00:00		1996-01-01 00:00:00		1998-07-01 00:00:00		1998-01-01 00:00:00		1998-04-01 00:00:00		1996-07-01 00:00:00		1998-10-01 00:00:00		1997-01-01 00:00:00		1997-10-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		1999-10-01 00:00:00		2000-04-01 00:00:00		1900-01-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		2000-10-01 00:00:00		2001-01-01 00:00:00		2000-10-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-10-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-07-01 00:00:00		1900-01-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2002-10-01 00:00:00		1900-01-01 00:00:00		2003-01-01 00:00:00		1900-01-01 00:00:00		2003-04-01 00:00:00		2003-04-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2004-04-01 00:00:00		2003-10-01 00:00:00		2004-07-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		1900-01-01 00:00:00		2004-12-17 00:00:00		2004-07-01 00:00:00		2004-12-17 00:00:00		2005-01-01 00:00:00		1900-01-01 00:00:00		2004-10-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		2006-12-13 00:00:00		2007-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2006-10-01 00:00:00		2007-04-01 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2013-04-01 00:00:00		1900-01-01 00:00:00		2015-01-01 00:00:00		2015-04-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		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		1900-01-01 00:00:00		2008-12-15 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		2010-10-01 00:00:00		2010-12-28 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2013-10-01 00:00:00		2014-10-01 00:00:00		2014-12-22 00:00:00		2012-12-14 00:00:00		2012-10-01 00:00:00		2012-07-01 00:00:00		2014-01-01 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		1900-01-01 00:00:00		2015-07-01 00:00:00		2019-07-01 00:00:00		2019-04-01 00:00:00		2018-01-01 00:00:00		2017-07-01 00:00:00		2018-10-01 00:00:00		2018-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		2016-12-08 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2019-01-01 00:00:00		2020-01-01 00:00:00		2018-04-01 00:00:00		2017-07-01 00:00:00		2019-10-01 00:00:00		2018-12-14 00:00:00		1900-01-01 00:00:00		2017-10-01 00:00:00		2020-04-01 00:00:00		2021-07-01 00:00:00		1900-01-01 00:00:00		2022-04-01 00:00:00		2020-07-01 00:00:00		2022-01-01 00:00:00		2020-02-17 00:00:00		1900-01-01 00:00:00		2020-10-01 00:00:00		2021-04-01 00:00:00		2020-12-09 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		2022-07-01 00:00:00
rpt_end		1999-09-30 00:00:00		1999-03-31 00:00:00		1996-06-30 00:00:00		1999-06-30 00:00:00		1997-09-30 00:00:00		1996-12-31 00:00:00		1997-06-30 00:00:00		1996-03-31 00:00:00		1998-09-30 00:00:00		1998-03-31 00:00:00		1998-06-30 00:00:00		1996-09-30 00:00:00		1998-12-31 00:00:00		1997-03-31 00:00:00		1997-12-31 00:00:00		2000-03-31 00:00:00		1999-12-31 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		1900-01-01 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		2001-06-01 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-12-31 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-09-30 00:00:00		1900-01-01 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2002-12-31 00:00:00		1900-01-01 00:00:00		2003-03-31 00:00:00		1900-01-01 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2004-06-30 00:00:00		2003-12-31 00:00:00		2004-09-30 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		1900-01-01 00:00:00		2004-12-17 00:00:00		2004-09-30 00:00:00		2004-12-17 00:00:00		2005-03-31 00:00:00		1900-01-01 00:00:00		2004-12-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		2006-12-13 00:00:00		2007-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2013-06-30 00:00:00		1900-01-01 00:00:00		2015-03-31 00:00:00		2015-06-30 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		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		1900-01-01 00:00:00		2008-12-15 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		2010-12-31 00:00:00		2010-12-28 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2014-12-22 00:00:00		2012-12-14 00:00:00		2012-12-31 00:00:00		2012-09-30 00:00:00		2014-03-31 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		1900-01-01 00:00:00		2015-09-30 00:00:00		2019-09-30 00:00:00		2019-06-30 00:00:00		2018-03-31 00:00:00		2017-09-30 00:00:00		2018-12-31 00:00:00		2018-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		2016-12-08 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2019-03-31 00:00:00		2020-03-31 00:00:00		2018-06-30 00:00:00		2017-09-30 00:00:00		2019-12-31 00:00:00		2018-12-14 00:00:00		1900-01-01 00:00:00		2017-12-31 00:00:00		2020-06-30 00:00:00		2021-09-30 00:00:00		1900-01-01 00:00:00		2022-06-30 00:00:00		2020-09-30 00:00:00		2022-03-31 00:00:00		2020-02-17 00:00:00		1900-01-01 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2020-12-09 00:00:00		2021-12-31 00:00:00		2021-03-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
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		22001		None		None		22001		22001		None		22001		22001		None		22001		None		None		22001		None		22001		None		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001

Table: filer_to_filer_type

filer_id		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000
filer_type		4		4		4		4		4		4		4		4		4		4		4		4		4		4		4
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		2001		1997		1995		1999		2003		2005		2007		2011		2013		2009		2021		2015		2019		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		2001-01-01 00:00:00		1997-01-01 00:00:00		1996-02-08 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		2011-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2021-01-01 00:00:00		2015-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
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		1149000
xref_id		L25197
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197		L25197
filer_id		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000
filer_type		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST
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		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		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		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		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN		MARGOLIN
namf		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT		BURT
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		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		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		WASHINGTON		Los Angeles		Washington		LOS ANGELES		SACRAMENTO		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		WASHINGTON		Los Angeles		Washington		LOS ANGELES		SACRAMENTO		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		WASHINGTON		Los Angeles		Washington		LOS ANGELES		SACRAMENTO		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		WASHINGTON		Los Angeles		Washington		LOS ANGELES		SACRAMENTO		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		WASHINGTON		Los Angeles		Washington		LOS ANGELES		SACRAMENTO		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		WASHINGTON		Los Angeles		Washington		LOS ANGELES		SACRAMENTO		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		WASHINGTON		Los Angeles		Washington		LOS ANGELES		SACRAMENTO		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		WASHINGTON		Los Angeles		Washington		LOS ANGELES		SACRAMENTO		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		WASHINGTON		Los Angeles		Washington		LOS ANGELES		SACRAMENTO		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		WASHINGTON		Los Angeles		Washington		LOS ANGELES		SACRAMENTO		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		WASHINGTON		Los Angeles		Washington		LOS ANGELES		SACRAMENTO		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		WASHINGTON		Los Angeles		Washington		LOS ANGELES		SACRAMENTO		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES
st		DC		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		20036		90067		20036		90067		95825		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90064		90064		90067		20036		90067		20036		90067		95825		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90064		90064		90067		20036		90067		20036		90067		95825		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90064		90064		90067		20036		90067		20036		90067		95825		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90064		90064		90067		20036		90067		20036		90067		95825		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90064		90064		90067		20036		90067		20036		90067		95825		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90064		90064		90067		20036		90067		20036		90067		95825		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90064		90064		90067		20036		90067		20036		90067		95825		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90064		90064		90067		20036		90067		20036		90067		95825		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90064		90064		90067		20036		90067		20036		90067		95825		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90064		90064		90067		20036		90067		20036		90067		95825		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90064		90064		90067		20036		90067		20036		90067		95825		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90067		90064		90064		90067
phon		2029556067		3102826848		2029556067		None		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		None		3102826848		3102826848		3102826848		3102826848		3102826848		None		2029556067		3102826848		2029556067		None		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		None		3102826848		3102826848		3102826848		3102826848		3102826848		None		2029556067		3102826848		2029556067		None		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		None		3102826848		3102826848		3102826848		3102826848		3102826848		None		2029556067		3102826848		2029556067		None		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		None		3102826848		3102826848		3102826848		3102826848		3102826848		None		2029556067		3102826848		2029556067		None		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		None		3102826848		3102826848		3102826848		3102826848		3102826848		None		2029556067		3102826848		2029556067		None		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		None		3102826848		3102826848		3102826848		3102826848		3102826848		None		2029556067		3102826848		2029556067		None		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		None		3102826848		3102826848		3102826848		3102826848		3102826848		None		2029556067		3102826848		2029556067		None		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		None		3102826848		3102826848		3102826848		3102826848		3102826848		None		2029556067		3102826848		2029556067		None		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		None		3102826848		3102826848		3102826848		3102826848		3102826848		None		2029556067		3102826848		2029556067		None		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		None		3102826848		3102826848		3102826848		3102826848		3102826848		None		2029556067		3102826848		2029556067		None		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		None		3102826848		3102826848		3102826848		3102826848		3102826848		None		2029556067		3102826848		2029556067		None		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		3102826848		None		3102826848		3102826848		3102826848		3102826848		3102826848		None
fax		None		None		None		None		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		None		3102826841										None		None		None		None		None		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		None		3102826841										None		None		None		None		None		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		None		3102826841										None		None		None		None		None		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		None		3102826841										None		None		None		None		None		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		None		3102826841										None		None		None		None		None		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		None		3102826841										None		None		None		None		None		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		None		3102826841										None		None		None		None		None		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		None		3102826841										None		None		None		None		None		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		None		3102826841										None		None		None		None		None		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		None		3102826841										None		None		None		None		None		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		None		3102826841										None		None		None		None		None		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		3102826841		None		3102826841										None
email		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None

Table: filers

filer_id		1149000

Table: lobbying_chg_log

filer_id		1149000		1149000		1149000		1149000		1149000
change_no		1		2		0		3		4
session_id		2001		2001		2001		2007		2007
log_dt		2001-05-22 00:00:00		2002-11-12 00:00:00		2002-11-12 00:00:00		2007-03-23 00:00:00		2007-03-23 00:00:00
filer_type		4		4		4		4		4
correction_flg		None		None		None		None		None
action		ADDED		DELETED		ADDED		CHANGED		None
attribute_changed		ETHICS		FIRM		FIRM		ADDRESS		ETHICS DATE
ethics_dt		2001-03-16 00:00:00		None		None		None		2007-03-15 00:00:00
interests		None		None		None		None		None
filer_full_name		BURT MARGOLIN		BURT MARGOLIN		BURT MARGOLIN		MARGOLIN, BURT		MARGOLIN, BURT
filer_city		None		None		None		LOS ANGELES		None
filer_st		None		None		None		CA		None
filer_zip		None		None		None		90067		None
filer_phone		None		None		None		3102826848		None
entity_type		4		3		3		4		4
entity_name		None		BERLINER, CANDON & JIMISON, A PROFESSIONAL CORPORATION		MARGOLIN GROUP, INC., THE		None		None
entity_city		None		None		None		None		None
entity_st		None		None		None		None		None
entity_zip		None		None		None		None		None
entity_phone		None		None		None		None		None
entity_id		0		1147473		1250501		0		0
responsible_officer		None		None		None		None		None
effect_dt		None		2002-10-31 00:00:00		2002-11-01 00:00:00		2007-03-15 00:00:00		2007-03-15 00:00:00

Table: received_filings

filer_id		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000		1149000
filing_file_name		684192_0.cal		747631_1.cal		745092_0.cal		747631_0.cal		365960.cal		798921_0.cal		800042_0.cal		814630_0.cal		840216_0.cal		856732_0.cal		884151_0.cal		457820.cal		445984.cal		910434_0.cal		931287_0.cal		947320_0.cal		969670_0.cal		988877_0.cal		1013865_0.cal		1029469_0.cal		1055062_0.cal		1077913_0.cal		1067536_0.cal		1103504_0.cal		1067536_1.cal		1116308_0.cal		1131548_0.cal		1144284_0.cal		1164444_0.cal		1188299_0.cal		1326393_0.cal		1554510_0.cal		1504224_0.cal		1419198_0.cal		1391276_0.cal		1347984_0.cal		1485239_0.cal		1459310_0.cal		1448748_0.cal		1214942_0.cal		1223366_0.cal		1369388_0.cal		1235672_0.cal		1282940_0.cal		1260442_0.cal		1436281_0.cal		1304538_0.cal		1295305_0.cal		1383827_0.cal		1844456_0.cal		1737235_0.cal		1675913_0.cal		1795312_0.cal		1538633_0.cal		1565984_0.cal		1814926_0.cal		1605485_0.cal		1589437_0.cal		1777468_0.cal		1763673_0.cal		1632901_0.cal		1620282_0.cal		1717402_0.cal		1707423_0.cal		1655175_0.cal		1866969_0.cal		1976859_0.cal		2154462_0.cal		2126412_0.cal		2059025_0.cal		2007558_0.cal		1995446_0.cal		2113022_0.cal		2095555_0.cal		1907128_0.cal		1964065_0.cal		1920258_0.cal		2033226_0.cal		1932380_0.cal		2170346_0.cal		2192308_1.cal		2241737_0.cal		2349989_0.cal		2310856_0.cal		2397140_0.cal		2269161_0.cal		2444586_0.cal		2192308_0.cal		2420114_0.cal		2328161_0.cal		2380639_0.cal		2482808_0.cal		2211262_0.cal		2467829_0.cal		2536423_1.cal		2623524_0.cal		2599007_0.cal		2544052_0.cal		2702878_0.cal		2576848_0.cal		2675460_0.cal		2735514_0.cal		2641266_0.cal		2533314_0.cal		2536423_0.cal
received_date		2000-11-02 00:00:00		2001-05-09 00:00:00		2001-04-27 00:00:00		2001-05-02 00:00:00		2001-11-23 00:00:00		2001-11-26 00:00:00		2001-12-07 00:00:00		2002-01-31 00:00:00		2002-04-30 00:00:00		2002-07-31 00:00:00		2002-10-30 00:00:00		2002-10-30 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-04-30 00:00:00		2003-07-31 00:00:00		2003-10-31 00:00:00		2004-01-30 00:00:00		2004-04-30 00:00:00		2004-07-30 00:00:00		2004-10-27 00:00:00		2005-01-28 00:00:00		2004-12-21 00:00:00		2005-04-28 00:00:00		2005-03-30 00:00:00		2005-07-28 00:00:00		2005-10-27 00:00:00		2006-01-25 00:00:00		2006-04-25 00:00:00		2006-07-27 00:00:00		2008-04-23 00:00:00		2010-12-28 00:00:00		2010-07-28 00:00:00		2009-04-28 00:00:00		2009-01-23 00:00:00		2008-07-29 00:00:00		2010-04-30 00:00:00		2010-01-22 00:00:00		2009-10-21 00:00:00		2006-10-30 00:00:00		2006-12-13 00:00:00		2008-10-23 00:00:00		2007-01-30 00:00:00		2007-07-30 00:00:00		2007-04-27 00:00:00		2009-07-30 00:00:00		2008-01-18 00:00:00		2007-10-26 00:00:00		2008-12-15 00:00:00		2014-04-30 00:00:00		2013-01-30 00:00:00		2012-07-27 00:00:00		2013-10-17 00:00:00		2010-10-29 00:00:00		2011-01-25 00:00:00		2014-01-29 00:00:00		2011-07-28 00:00:00		2011-04-28 00:00:00		2013-07-23 00:00:00		2013-04-29 00:00:00		2012-01-27 00:00:00		2011-10-27 00:00:00		2012-12-14 00:00:00		2012-10-30 00:00:00		2012-04-26 00:00:00		2014-07-26 00:00:00		2015-07-24 00:00:00		2017-04-27 00:00:00		2017-01-30 00:00:00		2016-07-27 00:00:00		2016-01-27 00:00:00		2015-10-28 00:00:00		2016-12-21 00:00:00		2016-10-25 00:00:00		2014-10-28 00:00:00		2015-04-29 00:00:00		2014-12-23 00:00:00		2016-04-27 00:00:00		2015-01-29 00:00:00		2017-07-24 00:00:00		2018-02-26 00:00:00		2018-04-30 00:00:00		2019-01-31 00:00:00		2018-10-23 00:00:00		2019-07-30 00:00:00		2018-07-25 00:00:00		2020-02-03 00:00:00		2017-10-30 00:00:00		2019-10-31 00:00:00		2018-12-14 00:00:00		2019-04-30 00:00:00		2020-07-29 00:00:00		2018-01-31 00:00:00		2020-04-27 00:00:00		2021-02-17 00:00:00		2021-10-31 00:00:00		2021-07-29 00:00:00		2021-01-14 00:00:00		2022-07-28 00:00:00		2021-04-26 00:00:00		2022-04-30 00:00:00		2022-10-18 00:00:00		2022-01-28 00:00:00		2020-11-05 00:00:00		2020-12-09 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/temp		/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/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/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/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
filing_id		684192		747631		745092		747631		None		798921		800042		814630		840216		856732		884151		None		None		910434		931287		947320		969670		988877		1013865		1029469		1055062		1077913		1067536		1103504		1067536		1116308		1131548		1144284		1164444		1188299		1326393		1554510		1504224		1419198		1391276		1347984		1485239		1459310		1448748		1214942		1223366		1369388		1235672		1282940		1260442		1436281		1304538		1295305		1383827		1844456		1737235		1675913		1795312		1538633		1565984		1814926		1605485		1589437		1777468		1763673		1632901		1620282		1717402		1707423		1655175		1866969		1976859		2154462		2126412		2059025		2007558		1995446		2113022		2095555		1907128		1964065		1920258		2033226		1932380		2170346		2192308		2241737		2349989		2310856		2397140		2269161		2444586		2192308		2420114		2328161		2380639		2482808		2211262		2467829		2536423		2623524		2599007		2544052		2702878		2576848		2675460		2735514		2641266		2533314		2536423
form_id		F615		F615		F615		F615		None		F615		F615		F615		F615		F615		F615		None		None		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604
receive_comment		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 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 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 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