Home

Filer ID: 1148579

Table: filer_address

filer_id		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579
adrid		2015786		1101195		1102408		1102234		2032954		2043190		2079249		2101442		2117417		2159928		2182439		2203452		2390941		2409908		2548862		2470518		2279414		2493698		2343198		2506712
effect_dt		2001-05-16 00:00:00		1999-01-01 00:00:00		1997-01-01 00:00:00		1995-01-01 00:00:00		2002-03-11 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2006-02-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2010-03-01 00:00:00		2011-01-01 00:00:00		2016-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00		2019-01-01 00:00:00		2013-01-01 00:00:00		2020-05-20 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00
add_type		7051		7050		7050		7050		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		2001		1999		1997		1995		2001		2003		2005		2005		2007		2009		2009		2011		2015		2017		2023		2019		2013		2019		2015		2021

Table: filer_ethics_class

filer_id		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579
session_id		1995		1997		1999		2001		2003		2005		2007		2009		2011		2013		2015		2017		2019		2021
ethics_date		1994-03-09 00:00:00		1998-11-19 00:00:00		1998-11-19 00:00:00		2000-11-14 00:00:00		2002-11-13 00:00:00		2004-11-17 00:00:00		2007-01-18 00:00:00		2009-02-19 00:00:00		2011-02-24 00:00:00		2012-11-08 00:00:00		2015-02-26 00:00:00		2017-04-20 00:00:00		2019-06-27 00:00:00		2021-01-15 00:00:00

Table: filer_filings

filer_id		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579
filing_id		515061		516485		518187		518909		513338		521265		519604		527502		523790		523335		515775		511945		512624		521691		525912		510264		529476		527950		518187		525434		624155		625416		607581		636058		644982		679712		656390		689512		703263		715641		754843		745127		750163		726179		769105		776644		817036		793297		793479		813350		834103		838445		858885		841977		852978		889539		886257		900550		916508		931910		910245		930702		951554		945990		969452		987394		971811		1011316		990991		1032178		1027560		1015260		1054649		1062968		1081895		1086975		1116539		1080988		1104990		1132974		1140823		1167506		1167063		1158240		1189304		1161137		1231274		1215517		1238148		1235285		1235285		1261262		1231274		1284357		1296822		1307972		1779188		1963627		1871007		1798198		1951525		1952434		1908106		1327763		1348444		1377379		1387101		1409379		1394968		1424545		1420835		1437096		1453163		1463695		1480718		1474598		1480718		1506838		1539823		1557256		1556252		1570013		1578855		1607538		1633634		1591162		1621619		1656533		1676501		1813262		1929397		1922538		1703180		1715937		1730131		1843126		1743562		1762990		1995081		1978435		2406847		2205139		2357002		2375141		2544964		2188114		2233795		2414835		2474535		2429752		2267324		2390616		2008272		2031598		2060849		2100368		2128250		2113183		2118069		2153020		2174941		2135107		2156672		2326045		2326045		2517995		2340860		2481305		2466311		2316849		2588801		2636428		2577024		2596367		2621808		2548208		2675747		2705574		2744581
period_id		150		143		151		159		142		152		144		155		146		153		158		149		157		145		147		141		156		148		151		154		161		161		160		None		162		163		162		163		None		164		None		165		165		164		166		None		None		None		166		168		None		169		None		None		170		None		171		None		None		None		172		173		None		174		175		176		None		177		None		None		178		None		179		None		181		None		182		None		181		183		184		185		185		185		186		None		188		187		188		None		None		189		190		190		191		192		214		221		218		215		None		None		219		193		194		195		196		None		196		None		197		198		199		200		201		None		201		202		203		None		204		204		None		206		208		205		207		209		210		216		220		221		211		212		212		217		None		213		223		222		None		232		None		237		245		231		233		239		None		240		234		238		224		225		226		227		228		228		229		None		230		None		229		239		236		243		236		242		241		235		None		248		245		246		247		244		249		250		251
form_id		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F690		F615		F615		F615		F615		F999		F615		F615		F615		F615		F604		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F604		F615		F615		F604		F604		F615		F604		F615		F615		F615		F615		F615		F615		F615		F604		F604		F615		F615		F615		F615		F604		F604		F615		F604		F615		F615		F615		F615		F615		F604		F615		F615		F615		F604		F604		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F615		F615		F604		F615		F615		F615		F604		F615		F604		F615		F604		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F604		F615		F604		F615		F604		F604		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615
filing_sequence		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		1		0		1		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		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1997-07-28 00:00:00		1995-10-31 00:00:00		1997-10-30 00:00:00		1999-10-29 00:00:00		1995-07-31 00:00:00		1998-02-02 00:00:00		1996-01-30 00:00:00		1998-10-30 00:00:00		1996-07-22 00:00:00		1998-04-30 00:00:00		1999-08-02 00:00:00		1997-04-29 00:00:00		1999-04-30 00:00:00		1996-04-30 00:00:00		1996-10-31 00:00:00		1995-05-01 00:00:00		1999-02-01 00:00:00		1997-01-07 00:00:00		1997-11-03 00:00:00		1998-07-30 00:00:00		2000-05-01 00:00:00		2000-04-28 00:00:00		2000-01-31 00:00:00		2000-04-24 00:00:00		2000-07-31 00:00:00		2000-10-28 00:00:00		2000-07-31 00:00:00		2000-10-27 00:00:00		2000-12-27 00:00:00		2001-01-27 00:00:00		2001-05-16 00:00:00		2001-04-27 00:00:00		2001-04-27 00:00:00		2001-01-30 00:00:00		2001-07-23 00:00:00		2001-07-20 00:00:00		2002-01-31 00:00:00		2001-10-31 00:00:00		2001-07-26 00:00:00		2002-01-30 00:00:00		2002-04-05 00:00:00		2002-04-29 00:00:00		2002-07-31 00:00:00		2002-04-30 00:00:00		2002-07-29 00:00:00		2002-10-30 00:00:00		2002-11-01 00:00:00		2002-12-30 00:00:00		2003-01-30 00:00:00		2003-04-29 00:00:00		2003-01-30 00:00:00		2003-04-29 00:00:00		2003-07-31 00:00:00		2003-07-29 00:00:00		2003-10-31 00:00:00		2004-01-28 00:00:00		2003-10-31 00:00:00		2004-04-26 00:00:00		2004-01-30 00:00:00		2004-07-30 00:00:00		2004-07-28 00:00:00		2004-04-29 00:00:00		2004-10-26 00:00:00		2004-10-29 00:00:00		2005-02-01 00:00:00		2004-12-29 00:00:00		2005-07-28 00:00:00		2005-01-26 00:00:00		2005-05-01 00:00:00		2005-10-30 00:00:00		2006-01-06 00:00:00		2006-05-01 00:00:00		2006-04-28 00:00:00		2006-03-28 00:00:00		2006-07-28 00:00:00		2006-01-04 00:00:00		2007-01-24 00:00:00		2006-10-30 00:00:00		2007-01-31 00:00:00		2007-01-24 00:00:00		2007-06-20 00:00:00		2007-04-30 00:00:00		2007-06-19 00:00:00		2007-07-31 00:00:00		2007-10-30 00:00:00		2008-01-29 00:00:00		2013-07-28 00:00:00		2015-04-28 00:00:00		2014-07-31 00:00:00		2013-10-28 00:00:00		2015-01-02 00:00:00		2015-02-26 00:00:00		2014-10-29 00:00:00		2008-04-28 00:00:00		2008-07-29 00:00:00		2008-10-30 00:00:00		2008-12-31 00:00:00		2009-01-08 00:00:00		2009-01-30 00:00:00		2009-02-19 00:00:00		2009-04-30 00:00:00		2009-07-30 00:00:00		2009-11-02 00:00:00		2010-01-30 00:00:00		2010-05-03 00:00:00		2010-03-18 00:00:00		2010-04-19 00:00:00		2010-07-31 00:00:00		2010-10-31 00:00:00		2010-12-30 00:00:00		2010-12-31 00:00:00		2011-01-30 00:00:00		2011-02-24 00:00:00		2011-07-31 00:00:00		2012-01-29 00:00:00		2011-04-30 00:00:00		2011-10-30 00:00:00		2012-04-29 00:00:00		2012-07-29 00:00:00		2014-01-26 00:00:00		2015-01-25 00:00:00		2015-01-02 00:00:00		2012-10-25 00:00:00		2012-12-06 00:00:00		2013-01-23 00:00:00		2014-04-29 00:00:00		2012-12-31 00:00:00		2013-04-28 00:00:00		2015-10-27 00:00:00		2015-07-28 00:00:00		2019-07-17 00:00:00		2018-01-24 00:00:00		2019-01-11 00:00:00		2019-04-19 00:00:00		2021-01-19 00:00:00		2017-10-17 00:00:00		2018-04-22 00:00:00		2019-10-23 00:00:00		2020-06-03 00:00:00		2020-01-10 00:00:00		2018-07-22 00:00:00		2019-07-17 00:00:00		2016-01-27 00:00:00		2016-04-23 00:00:00		2016-07-28 00:00:00		2016-10-30 00:00:00		2017-01-30 00:00:00		2016-12-21 00:00:00		2017-01-09 00:00:00		2017-04-20 00:00:00		2017-07-30 00:00:00		2017-01-19 00:00:00		2017-04-29 00:00:00		2019-07-03 00:00:00		2018-11-20 00:00:00		2020-10-19 00:00:00		2019-01-25 00:00:00		2020-07-27 00:00:00		2020-04-19 00:00:00		2018-10-30 00:00:00		2021-02-16 00:00:00		2022-01-23 00:00:00		2021-04-26 00:00:00		2021-07-25 00:00:00		2021-10-28 00:00:00		2021-01-27 00:00:00		2022-05-01 00:00:00		2022-07-31 00:00:00		2022-10-27 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10001		10005		10005		10005		10001		10005		10001		10005		10005		10001		10005		10005		10005		10005		10001		10005		10001		10005		10005		10001		10005		10001		10005		10005		10005		10001		10001		10005		10001		10001		10001		10005		10001		10005		10005		10001		10005		10001		10005		10001		10005		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10006		10001		10002		10001		10001		10001		10001		10001		10001		10001		10005		10006		10001		10001		10001		10001		10001		10005		10001		10006		10001		10001		10001		10001		10002		10005		10001		10001		10001		10005		10001		10001		10006		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10006		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10006		10001		10005		10001		10002		10001		10001		10001		10001		10001		10001		10005		10001		10001		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		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003
session_id		1997		1995		1997		1999		1995		1997		1995		1997		1995		1997		1999		1997		1999		1995		1995		1995		1997		1995		1997		1997		1999		1999		1999		1999		1999		1999		1999		1999		2001		1999		2001		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2005		2007		2007		2007		2007		2007		2007		2007		2013		2015		2013		2013		2015		2015		2013		2007		2007		2007		2009		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2011		2011		2011		2011		2011		2011		2011		2013		2013		2015		2011		2013		2011		2013		2013		2013		2015		2015		2019		2017		2019		2019		2021		2017		2017		2019		2019		2019		2017		2019		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2019		2019		2019		2017		2019		2019		2017		2021		2021		2021		2021		2021		2019		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		CFLAGG		TTHAM		*		TTHAM		*		*		TTHAM		GPEREZ		NJACKSON		*		SARRIAGA		*		GPEREZ		SARRIAGA		*		GPEREZ		YBONILLA		YBONILLA		GPEREZ		*		GPEREZ		*		YBONILLA		YBONILLA		*		YBONILLA		*		GPEREZ		YBONILLA		YBONILLA		COMPLETED		COMPLETED		YBONILLA		COMPLETED		COMPLETED		COMPLETED		YBONILLA		COMPLETED		EMCENTEE		EMCENTEE		YRODRIGU		EMCENTEE		COMPLETED		YRODRIGU		COMPLETED		DMCCASTL		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		LTHIBAUL		YRODRIGU		YRODRIGU		*		YRODRIGU		SARRIAGA		*		YRODRIGU		YRODRIGU		SARRIAGA		CFLAGG		YRODRIGU		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		ASAETERN		SJENSEN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		LTHIBAUL		LTHIBAUL		YRODRIGU		*		PBANFORD		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		JINGRAM		YRODRIGU		JINGRAM		ASAETERN		ASAETERN		DMCCASTL		YRODRIGU		ASAETERN		YRODRIGU		ASAETERN		ASAETERN		JINGRAM		ASAETERN		ASAETERN		AGLADNEY		ASAETERN		AGLADNEY		ASAETERN		ASAETERN		PBANFORD		ASAETERN		ASAETERN		PBANFORD		ASAETERN		JINGRAM		SJENSEN		SUSHAKOV		AGLADNEY		PBANFORD		VUKSTINA		CVANLIEW		AGLADNEY		AGLADNEY		VUKSTINA		GPEREZ		SUSHAKOV		AGLADNEY		VUKSTINA		AGLADNEY		AGLADNEY		AGLADNEY		JINGRAM		AGLADNEY		CAFILER		CAFILER		PBANFORD		SMCCONNAN		GPEREZ		JINGRAM		GPEREZ		PBANFORD		GTAYLOR		JFRONEFIELD		VUKSTINA		VUKSTINA		JFRONEFIELD		CVANLIEW		RATTIYEH		MKIRKHAM		MKIRKHAM		GTAYLOR		CHARTRIDGE		CAFILER		CAFILER		CAFILER
special_audit		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		11002		11003		11003		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		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11001		11003		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		11003		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		11003
rpt_start		1997-04-01 00:00:00		1995-07-01 00:00:00		1997-07-01 00:00:00		1999-07-01 00:00:00		1995-04-01 00:00:00		1997-10-01 00:00:00		1995-10-01 00:00:00		1998-07-01 00:00:00		1996-04-01 00:00:00		1998-01-01 00:00:00		1999-04-01 00:00:00		1997-01-01 00:00:00		1999-01-01 00:00:00		1996-01-01 00:00:00		1996-07-01 00:00:00		1995-01-01 00:00:00		1998-10-01 00:00:00		1996-10-01 00:00:00		1997-07-01 00:00:00		1998-04-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		None		2000-04-01 00:00:00		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		1900-01-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-04-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		1900-01-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		2003-10-01 00:00:00		2004-04-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2005-01-31 00:00:00		1900-01-01 00:00:00		2005-04-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-02-01 00:00:00		2006-01-01 00:00:00		2006-03-28 00:00:00		2006-04-01 00:00:00		1900-01-01 00:00:00		2006-12-31 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-01-01 00:00:00		2007-06-13 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		2015-01-01 00:00:00		2014-04-01 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		None		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-12-31 00:00:00		1900-01-01 00:00:00		2008-10-01 00:00:00		1900-01-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		1900-01-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2010-10-01 00:00:00		1900-01-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2011-01-01 00:00:00		2011-07-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		2015-01-02 00:00:00		2012-07-01 00:00:00		2012-12-06 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		1900-01-01 00:00:00		2017-10-01 00:00:00		1900-01-01 00:00:00		2019-01-01 00:00:00		2021-01-19 00:00:00		2017-07-01 00:00:00		2018-01-01 00:00:00		2019-07-01 00:00:00		1900-01-01 00:00:00		2019-10-01 00:00:00		2018-04-01 00:00:00		2019-04-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-21 00:00:00		2017-01-09 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		1900-01-01 00:00:00		2017-01-01 00:00:00		2019-07-03 00:00:00		2018-11-20 00:00:00		2020-07-01 00:00:00		2018-10-01 00:00:00		2020-04-01 00:00:00		2020-01-01 00:00:00		2018-07-01 00:00:00		1900-01-01 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		2021-04-01 00:00:00		2021-07-01 00:00:00		2020-10-01 00:00:00		2022-01-01 00:00:00		2022-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		1997-06-30 00:00:00		1995-09-30 00:00:00		1997-09-30 00:00:00		1999-09-30 00:00:00		1995-06-30 00:00:00		1997-12-31 00:00:00		1995-12-31 00:00:00		1998-09-30 00:00:00		1996-06-30 00:00:00		1998-03-31 00:00:00		1999-06-30 00:00:00		1997-03-31 00:00:00		1999-03-31 00:00:00		1996-03-31 00:00:00		1996-09-30 00:00:00		1995-03-31 00:00:00		1998-12-31 00:00:00		1996-12-31 00:00:00		1997-09-30 00:00:00		1998-06-30 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		1999-12-31 00:00:00		None		2000-06-30 00:00:00		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		1900-01-01 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-06-30 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		1900-01-01 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2004-03-31 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2005-01-31 00:00:00		1900-01-01 00:00:00		2005-06-30 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		2006-03-31 00:00:00		2006-03-28 00:00:00		2006-06-30 00:00:00		1900-01-01 00:00:00		2006-12-31 00:00:00		2006-09-30 00:00:00		2006-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-03-31 00:00:00		2007-06-13 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		2015-03-31 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		None		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		2008-12-31 00:00:00		1900-01-01 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		1900-01-01 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-03-31 00:00:00		2011-09-30 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		2015-01-02 00:00:00		2012-09-30 00:00:00		2012-12-06 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		1900-01-01 00:00:00		2017-12-31 00:00:00		1900-01-01 00:00:00		2019-03-31 00:00:00		2021-01-19 00:00:00		2017-09-30 00:00:00		2018-03-31 00:00:00		2019-09-30 00:00:00		1900-01-01 00:00:00		2019-12-31 00:00:00		2018-06-30 00:00:00		2019-06-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-21 00:00:00		2017-01-09 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		1900-01-01 00:00:00		2017-03-31 00:00:00		2019-07-03 00:00:00		2018-11-20 00:00:00		2020-09-30 00:00:00		2018-12-31 00:00:00		2020-06-30 00:00:00		2020-03-31 00:00:00		2018-09-30 00:00:00		1900-01-01 00:00:00		2021-12-31 00:00:00		2021-03-31 00:00:00		2021-06-30 00:00:00		2021-09-30 00:00:00		2020-12-31 00:00:00		2022-03-31 00:00:00		2022-06-30 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		22001		22001		None		22001		22001		22001		None		22001		None		None		22001		None		22001		None		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		None		22001		22001		22001		22006		22006		22006		22006		22006		22006		None		None		22006		22006		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		None		22006		22006		22006		None		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006

Table: filer_to_filer_type

filer_id		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579
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		1999		1995		2003		2005		2007		2011		2013		2009		2015		2021		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		1999-01-01 00:00:00		1995-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		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
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-01-01 00:00:00		2000-01-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		1148579
xref_id		L24696
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696		L24696
filer_id		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579
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		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		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		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		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		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER		BAUER
namf		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.		PAUL S.
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		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		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		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		None		None		None		None		None		None		None		None		None		None		None		None
city		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95814		95814		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		92101		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
phon		9164410202		9164472868		9164410202		9165021453		9164420401		9164420401		9164420401		9164411231		9164411232		9164411232		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9165021453		9165021453		9165021453		9164410202		9164472868		9164410202		9165021453		9164420401		9164420401		9164420401		9164411231		9164411232		9164411232		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9165021453		9165021453		9165021453		9164410202		9164472868		9164410202		9165021453		9164420401		9164420401		9164420401		9164411231		9164411232		9164411232		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9165021453		9165021453		9165021453		9164410202		9164472868		9164410202		9165021453		9164420401		9164420401		9164420401		9164411231		9164411232		9164411232		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9165021453		9165021453		9165021453		9164410202		9164472868		9164410202		9165021453		9164420401		9164420401		9164420401		9164411231		9164411232		9164411232		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9165021453		9165021453		9165021453		9164410202		9164472868		9164410202		9165021453		9164420401		9164420401		9164420401		9164411231		9164411232		9164411232		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9165021453		9165021453		9165021453		9164410202		9164472868		9164410202		9165021453		9164420401		9164420401		9164420401		9164411231		9164411232		9164411232		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9165021453		9165021453		9165021453		9164410202		9164472868		9164410202		9165021453		9164420401		9164420401		9164420401		9164411231		9164411232		9164411232		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9165021453		9165021453		9165021453		9164410202		9164472868		9164410202		9165021453		9164420401		9164420401		9164420401		9164411231		9164411232		9164411232		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9165021453		9165021453		9165021453		9164410202		9164472868		9164410202		9165021453		9164420401		9164420401		9164420401		9164411231		9164411232		9164411232		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9165021453		9165021453		9165021453		9164410202		9164472868		9164410202		9165021453		9164420401		9164420401		9164420401		9164411231		9164411232		9164411232		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9165021453		9165021453		9165021453		9164410202		9164472868		9164410202		9165021453		9164420401		9164420401		9164420401		9164411231		9164411232		9164411232		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9164441380		9165021453		9165021453		9165021453
fax		9164411222		None		None		9164428218		9164420483		9164420483				9164413243				9164413243																						9164411222		None		None		9164428218		9164420483		9164420483				9164413243				9164413243																						9164411222		None		None		9164428218		9164420483		9164420483				9164413243				9164413243																						9164411222		None		None		9164428218		9164420483		9164420483				9164413243				9164413243																						9164411222		None		None		9164428218		9164420483		9164420483				9164413243				9164413243																						9164411222		None		None		9164428218		9164420483		9164420483				9164413243				9164413243																						9164411222		None		None		9164428218		9164420483		9164420483				9164413243				9164413243																						9164411222		None		None		9164428218		9164420483		9164420483				9164413243				9164413243																						9164411222		None		None		9164428218		9164420483		9164420483				9164413243				9164413243																						9164411222		None		None		9164428218		9164420483		9164420483				9164413243				9164413243																						9164411222		None		None		9164428218		9164420483		9164420483				9164413243				9164413243																						9164411222		None		None		9164428218		9164420483		9164420483				9164413243				9164413243
email		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		None		None		pbauer@bhfs		None		None		None		None		None		pbauer@mercury llc.com		pbauer@mercury llc.com		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		None		None		pbauer@bhfs		None		None		None		None		None		pbauer@mercury llc.com		pbauer@mercury llc.com		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		None		None		pbauer@bhfs		None		None		None		None		None		pbauer@mercury llc.com		pbauer@mercury llc.com		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		None		None		pbauer@bhfs		None		None		None		None		None		pbauer@mercury llc.com		pbauer@mercury llc.com		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		None		None		pbauer@bhfs		None		None		None		None		None		pbauer@mercury llc.com		pbauer@mercury llc.com		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		None		None		pbauer@bhfs		None		None		None		None		None		pbauer@mercury llc.com		pbauer@mercury llc.com		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		None		None		pbauer@bhfs		None		None		None		None		None		pbauer@mercury llc.com		pbauer@mercury llc.com		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		None		None		pbauer@bhfs		None		None		None		None		None		pbauer@mercury llc.com		pbauer@mercury llc.com		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		None		None		pbauer@bhfs		None		None		None		None		None		pbauer@mercury llc.com		pbauer@mercury llc.com		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		None		None		pbauer@bhfs		None		None		None		None		None		pbauer@mercury llc.com		pbauer@mercury llc.com		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		None		None		pbauer@bhfs		None		None		None		None		None		pbauer@mercury llc.com		pbauer@mercury llc.com		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		[email protected]		None		None		None		pbauer@bhfs		None		None		None		None		None		pbauer@mercury llc.com		pbauer@mercury llc.com		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1148579

Table: lobbying_chg_log

filer_id		1148579		1148579		1148579		1148579		1148579		1148579
change_no		1		2		0		3		4		5
session_id		2001		2001		2005		2009		2009		2019
log_dt		2001-05-16 00:00:00		2002-03-21 00:00:00		2006-01-04 00:00:00		2010-02-16 00:00:00		2010-03-18 00:00:00		2020-06-03 00:00:00
filer_type		4		4		4		4		4		4
correction_flg		Y		Y		None		Y		Y		None
action		DELETED		CHANGED		ADDED		DELETED		ADDED		DELETED
attribute_changed		LOBBYIST		ADDRESS AND PHONE		FIRM		FIRM		FIRM		FIRM
ethics_dt		None		None		None		None		None		None
interests		None		None		None		None		None		None
filer_full_name		BAUER, PAUL S.		BAUER, PAUL S.		PAUL S. BAUER		BAUER, PAUL S.		BAUER, PAUL S.		PAUL S. BAUER
filer_city		None		SACRAMENTO		None		None		SAN DIEGO		None
filer_st		None		CA		None		None		CA		None
filer_zip		None		95814		None		None		92101		None
filer_phone		None		9164420401		None		None		9164410202		None
entity_type		4		4		3		3		3		3
entity_name		CARPI & CLAY		PAUL S. BAUER		HATCH & PARENT, A LAW CORPORATION		BROWNSTEIN HYATT FARBER SCHRECK , LLP		MERCURY PUBLIC AFFAIRS		MERCURY PUBLIC AFFAIRS
entity_city		None		None		None		None		None		None
entity_st		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None
entity_id		1147222		0		1147758		1147758		None		1325943
responsible_officer		None		None		None		None		None		None
effect_dt		2001-05-11 00:00:00		2002-03-11 00:00:00		2006-02-01 00:00:00		2010-02-08 00:00:00		2010-03-01 00:00:00		2020-05-20 00:00:00

Table: received_filings

filer_id		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579		1148579
filing_file_name		624155_0.cal		644982_0.cal		679712_0.cal		715641_0.cal		745127_0.cal		182065.cal		769105_0.cal		813350_0.cal		838445_0.cal		852978_0.cal		886257_0.cal		910245_0.cal		930702_0.cal		945990_0.cal		987394_0.cal		969452_0.cal		1011316_0.cal		1027560_0.cal		1054649_0.cal		1081895_0.cal		1104990_0.cal		1116539_0.cal		1140823_0.cal		1132974_0.cal		383693.cal		383836.cal		1158240_0.cal		1167506_0.cal		1167063_0.cal		1189304_0.cal		1215517_0.cal		1238148_0.cal		1261262_0.cal		1231274_0.cal		1231274_1.cal		1284357_0.cal		1387101_0.cal		1556252_0.cal		1715937_0.cal		2118069_0.cal		2113183_0.cal		1922538_0.cal		2326045_1.cal		2326045_0.cal		2544964_0.cal
received_date		2000-05-01 00:00:00		2000-07-31 00:00:00		2000-10-28 00:00:00		2001-01-27 00:00:00		2001-04-27 00:00:00		2001-07-26 00:00:00		2001-07-23 00:00:00		2002-01-30 00:00:00		2002-04-29 00:00:00		2002-07-29 00:00:00		2002-11-01 00:00:00		2003-01-30 00:00:00		2003-04-29 00:00:00		2003-07-29 00:00:00		2004-01-28 00:00:00		2003-10-31 00:00:00		2004-04-26 00:00:00		2004-07-28 00:00:00		2004-10-26 00:00:00		2005-02-01 00:00:00		2005-05-01 00:00:00		2005-07-28 00:00:00		2006-01-06 00:00:00		2005-10-30 00:00:00		2006-01-24 00:00:00		2006-01-24 00:00:00		2006-03-28 00:00:00		2006-05-01 00:00:00		2006-04-28 00:00:00		2006-07-28 00:00:00		2006-10-30 00:00:00		2007-01-31 00:00:00		2007-04-30 00:00:00		2007-01-24 00:00:00		2007-06-19 00:00:00		2007-07-31 00:00:00		2008-12-31 00:00:00		2010-12-31 00:00:00		2012-12-06 00:00:00		2017-01-09 00:00:00		2016-12-21 00:00:00		2015-01-02 00:00:00		2019-07-03 00:00:00		2018-11-20 00:00:00		2021-01-19 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/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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
filing_id		624155		644982		679712		715641		745127		None		769105		813350		838445		852978		886257		910245		930702		945990		987394		969452		1011316		1027560		1054649		1081895		1104990		1116539		1140823		1132974		None		None		1158240		1167506		1167063		1189304		1215517		1238148		1261262		1231274		1231274		1284357		1387101		1556252		1715937		2118069		2113183		1922538		2326045		2326045		2544964
form_id		F615		F615		F615		F615		F615		None		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		None		None		F604		F615		F615		F615		F615		F615		F615		F604		F604		F615		F604		F604		F604		F604		F604		F604		F604		F604		F604
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing 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