Home

Filer ID: 1143477

Table: filer_address

filer_id		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477
adrid		1107855		2041605		2080937		2115379		2163361		2206482		2416941		2549993		2276947		2509602		2468756		2339271
effect_dt		1999-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00		2013-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1999		2003		2005		2007		2009		2011		2017		2023		2013		2021		2019		2015

Table: filer_filings

filer_id		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477
filing_id		663350		687063		483797		464702		478267		484491		498375		491137		480933		491820		494797		487421		464702		468669		474209		474209		479807		474209		487421		469841		483797		468669		540313		491820		480933		488108		495491		475361		488108		472684		616294		631685		623399		672824		696909		712417		712419		712421		715632		712428		712430		672824		744282		724732		715632		733902		758315		768551		791920		794774		780600		818779		808396		791920		840296		841925		846274		840296		851173		876765		890473		875708		854778		906943		904317		907753		851173		896980		929048		943884		966581		937648		954266		986882		1006401		996960		1025447		1015345		1029818		1013464		1018628		986882		1025447		1013464		1068591		1062667		1068086		1068087		1068088		1078942		1056438		1082166		1094274		1092916		1065440		1145156		1083493		1104127		1132233		1118099		1166851		1189747		1201936		1215249		1224912		1260285		1237646		1225457		1225973		1247830		1234423		1241287		1224462		1245133		1307394		1285569		1778462		1981890		1839744		1864634		1808919		1798042		1960503		1942568		1911378		1298043		1330411		1285569		1344876		1387510		1385378		1375385		1386207		1409435		1395058		1416061		1415375		1419806		1420863		1425916		1435850		1412441		1419406		1450424		1461886		1484385		1504083		1435850		1535655		1570129		1556107		1450424		1535655		1556169		1553502		1588953		1603236		1588953		1631476		1621328		1588953		1603236		1657509		1678620		1825981		1815819		1588953		1621328		1839744		1911378		1929557		1631476		1678620		1709346		1725993		1738175		1759537		1997829		1990450		2416886		2468359		2341563		2193817		2526273		2399881		2234558		2015342		2006282		2034039		2059569		2096107		2096107		2124790		2113080		2154390		2136659		2142424		2176549		2319821		2344710		2422110		2399881		2484160		2205079		2441996		2551005		2422335		2274249		2381044		2631176		2675053		2580089		2620114		2644476		2644476		2675053		2567609		2611750		2701697		2600537		2620114		2580089		2580089		2600537		2620114		2644476		2644476		2734197
period_id		162		162		152		141		151		145		156		154		144		147		155		153		141		157		158		158		159		158		153		142		152		157		149		147		144		146		148		143		146		150		160		None		None		163		163		161		160		162		164		159		163		163		165		None		164		164		165		166		167		None		None		None		168		167		169		None		None		169		170		171		None		None		170		None		172		None		170		None		173		174		175		173		None		176		None		None		178		None		None		177		None		176		178		177		180		181		None		None		None		180		179		181		None		None		None		184		None		181		183		182		185		186		None		187		188		189		188		188		189		None		None		None		188		None		192		190		214		222		217		218		217		215		221		None		219		191		193		190		194		196		196		195		196		None		196		None		None		198		197		None		198		None		198		199		200		201		202		198		203		204		None		199		203		None		204		205		206		205		208		207		205		206		209		210		None		216		205		207		217		219		220		208		210		211		None		212		213		223		None		239		241		236		231		243		238		233		None		224		225		226		227		227		228		228		229		None		None		230		235		None		None		238		242		232		240		244		240		234		237		None		249		245		247		248		248		249		None		244		250		246		247		245		245		246		247		248		248		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F690		F690		F635		F635		F690		F690		F635		F690		F635		F635		F690		F690		F635		F635		F635		F690		F635		F635		F635		F690		F635		F635		F690		F690		F690		F635		F690		F690		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F690		F635		F602		F635		F635		F635		F602		F635		F635		F635		F602		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F635		F602		F602		F690		F690		F690		F635		F635		F602		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F602		F602		F602		F602		F602		F602		F602		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F602		F602		F635		F602		F602		F635		F602		F602		F602		F635		F606		F635		F602		F606		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F602		F635		F602		F602		F635		F635		F602		F602		F635		F635		F635		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		1		1		2		0		0		1		1		0		1		0		0		1		1		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		0		0		0		0		0		0		1		0		0		0		1		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		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		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		1		1		0		0		2		0		0		0		0		1		1		0		0		0		0		3		1		1		1		0		1		1		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		1		0		0		0		0		0		0		0		0		0		2		1		1		2		1		0		0		0		0		0		1		0		1		2		3		0		0
filing_date		2000-07-28 00:00:00		2000-11-08 00:00:00		1998-02-02 00:00:00		1995-05-01 00:00:00		1997-10-28 00:00:00		1996-04-29 00:00:00		1999-02-01 00:00:00		1998-07-31 00:00:00		1996-01-30 00:00:00		1996-10-31 00:00:00		1998-10-30 00:00:00		1998-04-30 00:00:00		1996-01-10 00:00:00		1999-10-25 00:00:00		1999-10-25 00:00:00		1999-08-02 00:00:00		1999-11-01 00:00:00		1999-08-02 00:00:00		1998-07-27 00:00:00		1995-07-31 00:00:00		1998-08-10 00:00:00		1999-04-30 00:00:00		1997-04-29 00:00:00		1997-07-29 00:00:00		1996-10-10 00:00:00		1996-07-25 00:00:00		1997-01-31 00:00:00		1995-10-30 00:00:00		1997-01-21 00:00:00		1997-07-31 00:00:00		2000-01-27 00:00:00		2000-05-01 00:00:00		2000-01-28 00:00:00		2000-10-19 00:00:00		2000-10-23 00:00:00		2000-11-09 00:00:00		2000-11-09 00:00:00		2000-11-09 00:00:00		2001-01-27 00:00:00		2000-11-09 00:00:00		2000-11-09 00:00:00		2000-11-07 00:00:00		2001-04-26 00:00:00		2000-12-28 00:00:00		2001-02-14 00:00:00		2001-01-31 00:00:00		2001-04-30 00:00:00		2001-07-20 00:00:00		2001-10-31 00:00:00		2001-10-31 00:00:00		2001-07-23 00:00:00		2002-01-29 00:00:00		2002-01-21 00:00:00		2002-01-23 00:00:00		2002-04-30 00:00:00		2002-04-30 00:00:00		2002-05-31 00:00:00		2002-06-20 00:00:00		2002-07-23 00:00:00		2002-10-23 00:00:00		2002-10-28 00:00:00		2002-10-10 00:00:00		2002-07-29 00:00:00		2002-12-30 00:00:00		2003-01-21 00:00:00		2003-01-24 00:00:00		2003-02-11 00:00:00		2002-12-17 00:00:00		2003-04-25 00:00:00		2003-07-23 00:00:00		2003-10-23 00:00:00		2003-05-28 00:00:00		2003-07-28 00:00:00		2004-01-27 00:00:00		2004-03-12 00:00:00		2004-01-28 00:00:00		2004-07-23 00:00:00		2004-05-04 00:00:00		2004-07-29 00:00:00		2004-04-29 00:00:00		2004-04-30 00:00:00		2004-08-24 00:00:00		2004-08-24 00:00:00		2004-08-24 00:00:00		2004-12-29 00:00:00		2004-11-24 00:00:00		2004-08-25 00:00:00		2004-08-25 00:00:00		2004-08-25 00:00:00		2005-01-28 00:00:00		2004-10-28 00:00:00		2005-02-01 00:00:00		2005-01-31 00:00:00		2004-12-29 00:00:00		2004-11-01 00:00:00		2006-01-27 00:00:00		2004-12-29 00:00:00		2005-04-29 00:00:00		2005-10-28 00:00:00		2005-07-31 00:00:00		2006-04-28 00:00:00		2006-07-29 00:00:00		2006-09-25 00:00:00		2006-10-30 00:00:00		2006-12-27 00:00:00		2007-04-27 00:00:00		2007-01-31 00:00:00		2006-12-29 00:00:00		2007-01-02 00:00:00		2007-01-02 00:00:00		2006-12-29 00:00:00		2006-12-22 00:00:00		2006-12-22 00:00:00		2006-12-29 00:00:00		2008-01-28 00:00:00		2007-07-31 00:00:00		2013-07-25 00:00:00		2015-07-31 00:00:00		2014-04-21 00:00:00		2014-07-21 00:00:00		2014-01-07 00:00:00		2013-10-28 00:00:00		2015-04-22 00:00:00		2014-12-26 00:00:00		2014-10-31 00:00:00		2007-10-31 00:00:00		2008-05-01 00:00:00		2008-07-24 00:00:00		2008-07-22 00:00:00		2009-01-05 00:00:00		2008-12-24 00:00:00		2008-10-29 00:00:00		2008-12-29 00:00:00		2009-01-21 00:00:00		2009-01-30 00:00:00		2008-12-30 00:00:00		2008-12-29 00:00:00		2009-04-29 00:00:00		2009-04-30 00:00:00		2009-04-29 00:00:00		2009-07-29 00:00:00		2009-02-11 00:00:00		2009-04-28 00:00:00		2009-10-27 00:00:00		2010-01-28 00:00:00		2010-04-29 00:00:00		2010-07-28 00:00:00		2010-04-22 00:00:00		2010-10-26 00:00:00		2011-01-31 00:00:00		2010-12-23 00:00:00		2011-01-05 00:00:00		2011-01-20 00:00:00		2010-12-28 00:00:00		2010-12-22 00:00:00		2011-10-25 00:00:00		2011-07-26 00:00:00		2011-04-27 00:00:00		2012-01-25 00:00:00		2011-10-28 00:00:00		2011-07-15 00:00:00		2011-10-28 00:00:00		2012-04-30 00:00:00		2012-07-31 00:00:00		2014-01-14 00:00:00		2014-01-30 00:00:00		2012-10-15 00:00:00		2012-10-15 00:00:00		2015-01-20 00:00:00		2015-01-20 00:00:00		2015-01-26 00:00:00		2012-10-17 00:00:00		2012-10-17 00:00:00		2012-10-31 00:00:00		2012-12-10 00:00:00		2013-01-31 00:00:00		2013-04-18 00:00:00		2015-11-02 00:00:00		2015-09-04 00:00:00		2019-10-29 00:00:00		2020-04-28 00:00:00		2019-01-28 00:00:00		2017-10-31 00:00:00		2020-10-29 00:00:00		2019-07-31 00:00:00		2018-04-24 00:00:00		2016-01-12 00:00:00		2016-01-25 00:00:00		2016-04-28 00:00:00		2016-07-27 00:00:00		2016-10-26 00:00:00		2016-10-26 00:00:00		2017-01-26 00:00:00		2016-12-21 00:00:00		2017-04-27 00:00:00		2016-12-19 00:00:00		2016-12-22 00:00:00		2017-07-31 00:00:00		2018-10-31 00:00:00		2018-12-24 00:00:00		2019-11-14 00:00:00		2020-01-14 00:00:00		2020-07-30 00:00:00		2018-01-24 00:00:00		2020-01-31 00:00:00		2021-01-29 00:00:00		2019-11-19 00:00:00		2018-07-31 00:00:00		2019-04-30 00:00:00		2021-04-29 00:00:00		2022-04-29 00:00:00		2022-07-09 00:00:00		2022-07-09 00:00:00		2022-07-09 00:00:00		2022-07-09 00:00:00		2022-07-09 00:00:00		2020-12-18 00:00:00		2021-09-16 00:00:00		2022-07-27 00:00:00		2021-07-30 00:00:00		2021-10-26 00:00:00		2022-03-02 00:00:00		2021-04-30 00:00:00		2022-07-09 00:00:00		2022-07-09 00:00:00		2022-07-09 00:00:00		2022-01-31 00:00:00		2022-10-14 00:00:00
stmnt_type		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10005		10005		10005		10005		10001		10005		10005		10002		10001		10005		10002		10005		10005		10001		10001		10005		10005		10005		10001		10002		10001		10005		10005		10002		10001		10001		10005		10006		10005		10005		10001		10005		10002		10005		10001		10001		10001		10001		10005		10001		10005		10005		10001		10005		10005		10001		10005		10002		10002		10002		10001		10001		10006		10006		10006		10001		10001		10001		10005		10005		10005		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10002		10001		10001		10001		10001		10001		10005		10001		10005		10005		10001		10001		10003		10001		10001		10001		10001		10001		10001		10001		10002		10001		10001		10005		10002		10002		10005		10001		10002		10001		10001		10001		10001		10002		10002		10001		10001		10005		10001		10002		10002		10002		10002		10001		10002		10002		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10002		10001		10001		10001		10005		10005		10001		10001		10001		10005		10002		10001		10001		10001		10001		10001		10001		10001		10005		10001		10002		10002		10002		10002		10002		10005		10001		10001		10001		10001		10002		10001		10002		10002		10002		10001		10001
stmnt_status		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		11003		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11003		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11003		11001		11003		11001		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003
session_id		1999		1999		1997		1995		1997		1995		1997		1997		1995		1995		1997		1997		1995		1999		1999		1999		1999		1999		1997		1995		1997		1999		1997		1995		1995		1995		1995		1995		1995		1997		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2003		2003		2003		2003		2003		2005		2003		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2005		2007		2007		2007		2007		2007		2007		2007		2007		2007		2013		2015		2013		2013		2013		2013		2015		2015		2013		2007		2007		2007		2007		2009		2009		2007		2009		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2011		2011		2013		2013		2013		2011		2011		2011		2013		2011		2013		2015		2015		2019		2019		2017		2017		2019		2019		2017		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2019		2019		2019		2019		2017		2019		2019		2019		2017		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		GPEREZ		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		KCHAN		TTHAM		*		GPEREZ		GPEREZ		GPEREZ		GPEREZ		*		GPEREZ		GPEREZ		*		*		GGILMORE		*		GPEREZ		JBRANNAN		*		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		*		*		LTHIBAUL		SARRIAGA		*		*		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		SARRIAGA		COMPLETED		LTHIBAUL		COMPLETED		BSMITH		COMPLETED		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		CFLAGG		LTHIBAUL		COMPLETED		GPEREZ		GPEREZ		COMPLETED		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		COMPLETED		COMPLETED		EMCENTEE		EMCENTEE		EMCENTEE		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		SARRIAGA		LTHIBAUL		LTHIBAUL		CFLAGG		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		GPEREZ		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		*		*		GPEREZ		SARRIAGA		CFLAGG		*		GPEREZ		LTHIBAUL		YRODRIGU		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		YRODRIGU		ASAETERN		AGLADNEY		GKURIMOT		AGLADNEY		YRODRIGU		SMCCABE		YRODRIGU		SMCCABE		YRODRIGU		YRODRIGU		MGUERRA		YRODRIGU		SARRIAGA		MGUERRA		PBANFORD		JINGRAM		YRODRIGU		MGUERRA		YRODRIGU		MGUERRA		DMCCASTL		*		MGUERRA		MGUERRA		ASAETERN		ASAETERN		ASAETERN		ASAETERN		AGLADNEY		PBANFORD		ASAETERN		AGLADNEY		YRODRIGU		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		CAFILER		AGLADNEY		AGLADNEY		SARRIAGA		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		VUKSTINA		GTAYLOR		AGLADNEY		AGLADNEY		GTAYLOR		GTAYLOR		AGLADNEY		GPEREZ		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		AGLADNEY		DMCCASTL		YRODRIGU		AGLADNEY		AGLADNEY		SARRIAGA		GPEREZ		GTAYLOR		MKIRKHAM		AGLADNEY		GTAYLOR		GTAYLOR		CAFILER		AGLADNEY		VUKSTINA		MKIRKHAM		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		AROJAS		MKIRKHAM		CAFILER		CHATRIDGE		MKIRKHAM		GTAYLOR		CHATRIDGE		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER
special_audit		11003		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11003		11003		11003		11002		11003		11003		11003		11003		11002		11003		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11001		11001		11003		11001		11003		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		11001		11001		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003
rpt_start		2000-04-01 00:00:00		2000-04-01 00:00:00		1997-10-01 00:00:00		1995-01-01 00:00:00		1997-07-01 00:00:00		1996-01-01 00:00:00		1998-10-01 00:00:00		1998-04-01 00:00:00		1995-10-01 00:00:00		1996-07-01 00:00:00		1998-07-01 00:00:00		1998-01-01 00:00:00		1995-01-01 00:00:00		1999-01-01 00:00:00		1999-04-01 00:00:00		1999-04-01 00:00:00		1999-07-01 00:00:00		1999-04-01 00:00:00		1998-01-01 00:00:00		1995-04-01 00:00:00		1997-10-01 00:00:00		1999-01-01 00:00:00		1997-01-01 00:00:00		1996-07-01 00:00:00		1995-10-01 00:00:00		1996-04-01 00:00:00		1996-10-01 00:00:00		1995-07-01 00:00:00		1996-04-01 00:00:00		1997-04-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		1999-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		2000-04-01 00:00:00		2000-10-01 00:00:00		1999-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		1900-01-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		1900-01-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		2002-04-01 00:00:00		2002-04-01 00:00:00		1900-01-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2002-04-01 00:00:00		1900-01-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-10-01 00:00:00		1900-01-01 00:00:00		2003-10-01 00:00:00		2004-04-01 00:00:00		1900-01-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2003-10-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-12-21 00:00:00		2005-01-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2003-10-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2005-01-31 00:00:00		2004-10-01 00:00:00		1900-01-01 00:00:00		2004-07-01 00:00:00		2005-10-01 00:00:00		1900-01-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-04-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		1900-01-01 00:00:00		2006-07-01 00:00:00		2006-12-31 00:00:00		2007-01-01 00:00:00		2006-10-01 00:00:00		2006-12-22 00:00:00		2007-01-02 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2006-12-22 00:00:00		1900-01-01 00:00:00		2007-10-01 00:00:00		2007-04-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2014-01-07 00:00:00		2013-07-01 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2007-04-01 00:00:00		2008-04-01 00:00:00		2008-12-31 00:00:00		2008-12-20 00:00:00		2008-07-01 00:00:00		2008-12-29 00:00:00		1900-01-01 00:00:00		2008-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-04-29 00:00:00		2009-01-01 00:00:00		1900-01-01 00:00:00		2009-04-01 00:00:00		1900-01-01 00:00:00		2009-04-27 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		2009-04-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		1900-01-01 00:00:00		2009-07-01 00:00:00		2010-07-01 00:00:00		1900-01-01 00:00:00		2010-11-15 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		1900-01-01 00:00:00		2013-10-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2014-01-01 00:00:00		2014-07-01 00:00:00		2014-10-01 00:00:00		2011-10-01 00:00:00		2012-04-01 00:00:00		2012-07-01 00:00:00		1900-01-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		1900-01-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2018-10-01 00:00:00		2017-07-01 00:00:00		2020-07-01 00:00:00		2019-04-01 00:00:00		2018-01-01 00:00:00		1900-01-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-07-01 00:00:00		2016-10-01 00:00:00		2016-12-16 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		2018-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-04-01 00:00:00		2020-04-01 00:00:00		2017-10-01 00:00:00		2019-10-01 00:00:00		2020-10-01 00:00:00		2019-11-14 00:00:00		2018-04-01 00:00:00		2019-01-01 00:00:00		1900-01-01 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2021-10-01 00:00:00		2022-01-01 00:00:00		1900-01-01 00:00:00		2020-11-30 00:00:00		2022-04-01 00:00:00		2021-04-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-04-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00
rpt_end		2000-06-30 00:00:00		2000-06-30 00:00:00		1997-12-31 00:00:00		1995-03-31 00:00:00		1997-09-30 00:00:00		1996-03-31 00:00:00		1998-12-31 00:00:00		1998-06-30 00:00:00		1995-12-31 00:00:00		1996-09-30 00:00:00		1998-09-30 00:00:00		1998-03-31 00:00:00		1995-03-31 00:00:00		1999-03-31 00:00:00		1999-06-30 00:00:00		1999-06-30 00:00:00		1999-09-30 00:00:00		1999-06-30 00:00:00		1998-03-31 00:00:00		1995-06-30 00:00:00		1997-12-31 00:00:00		1999-03-31 00:00:00		1997-03-31 00:00:00		1996-09-30 00:00:00		1995-12-31 00:00:00		1996-06-30 00:00:00		1996-12-31 00:00:00		1995-09-30 00:00:00		1996-06-30 00:00:00		1997-06-30 00:00:00		1999-12-31 00:00:00		2000-03-31 00:00:00		1999-10-31 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-03-31 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		1999-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2001-03-31 00:00:00		1900-01-01 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2002-03-31 00:00:00		2002-03-31 00:00:00		1900-01-01 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		2002-06-30 00:00:00		2002-06-30 00:00:00		1900-01-01 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2002-06-30 00:00:00		1900-01-01 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-01-01 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		1900-01-01 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		1900-01-01 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-04-30 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-12-21 00:00:00		2005-01-01 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2003-12-31 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2005-01-31 00:00:00		2004-12-31 00:00:00		1900-01-01 00:00:00		2044-09-30 00:00:00		2005-12-31 00:00:00		1900-01-01 00:00:00		2005-03-31 00:00:00		2005-09-30 00:00:00		2005-06-30 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		1900-01-01 00:00:00		2006-09-30 00:00:00		2006-12-31 00:00:00		2007-03-31 00:00:00		2006-12-31 00:00:00		2006-12-22 00:00:00		2007-01-02 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2006-12-22 00:00:00		1900-01-01 00:00:00		2007-12-31 00:00:00		2007-06-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2014-01-07 00:00:00		2013-09-30 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2007-09-30 00:00:00		2008-03-31 00:00:00		2007-06-30 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2008-12-20 00:00:00		2008-09-30 00:00:00		2008-12-29 00:00:00		1900-01-01 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-04-29 00:00:00		2009-03-31 00:00:00		1900-01-01 00:00:00		2009-06-30 00:00:00		1900-01-01 00:00:00		2009-04-27 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		2009-06-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		2009-09-30 00:00:00		2010-09-30 00:00:00		1900-01-01 00:00:00		2010-11-15 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		1900-01-01 00:00:00		2013-12-31 00:00:00		2011-03-31 00:00:00		2011-09-30 00:00:00		2014-03-31 00:00:00		2014-09-30 00:00:00		2014-12-31 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2012-09-30 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		1900-01-01 00:00:00		2019-09-30 00:00:00		2020-03-31 00:00:00		2018-12-31 00:00:00		2017-09-30 00:00:00		2020-09-30 00:00:00		2019-06-30 00:00:00		2018-03-31 00:00:00		1900-01-01 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-09-30 00:00:00		2016-12-31 00:00:00		2016-12-16 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		2018-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-06-30 00:00:00		2020-06-30 00:00:00		2017-12-31 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		2019-11-14 00:00:00		2018-06-30 00:00:00		2019-03-31 00:00:00		1900-01-01 00:00:00		2022-03-31 00:00:00		2021-03-31 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2022-03-31 00:00:00		1900-01-01 00:00:00		2020-11-30 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		2021-09-30 00:00:00		2021-03-31 00:00:00		2021-03-31 00:00:00		2021-06-30 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		22001		None		22001		22001		22001		22001		None		22001		None		None		22001		None		None		22001		None		22001		22001		22001		22001		22001		None		None		None		22001		22001		22001		None		None		None		22001		None		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		None		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		None		None		22006		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001

Table: filer_interests

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

Table: filer_to_filer_type

filer_id		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477
filer_type		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
session_id		1997		1999		1995		2001		2003		2005		2007		2013		2011		2009		2017		2019		2015		2021		2023
category		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
category_type		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
sub_category		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
effect_dt		1997-01-01 00:00:00		1999-01-01 00:00:00		1994-12-05 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2013-01-01 00:00:00		2011-01-01 00:00:00		2009-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00		2021-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		1143477
xref_id		C22448
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448		C22448
filer_id		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477
filer_type		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
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
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
naml		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER, COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
city		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN		AUBURN
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
zip4		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603		95603
phon		5308894031		5308894031		5308894031		5308894031		5308894031		5308894031		5302651480		5308894030		5302651480		5308894030		5308894030		5308894030		5308894031		5308894031		5308894031		5308894031		5308894031		5308894031		5302651480		5308894030		5302651480		5308894030		5308894030		5308894030		5308894031		5308894031		5308894031		5308894031		5308894031		5308894031		5302651480		5308894030		5302651480		5308894030		5308894030		5308894030		5308894031		5308894031		5308894031		5308894031		5308894031		5308894031		5302651480		5308894030		5302651480		5308894030		5308894030		5308894030		5308894031		5308894031		5308894031		5308894031		5308894031		5308894031		5302651480		5308894030		5302651480		5308894030		5308894030		5308894030		5308894031		5308894031		5308894031		5308894031		5308894031		5308894031		5302651480		5308894030		5302651480		5308894030		5308894030		5308894030		5308894031		5308894031		5308894031		5308894031		5308894031		5308894031		5302651480		5308894030		5302651480		5308894030		5308894030		5308894030		5308894031		5308894031		5308894031		5308894031		5308894031		5308894031		5302651480		5308894030		5302651480		5308894030		5308894030		5308894030		5308894031		5308894031		5308894031		5308894031		5308894031		5308894031		5302651480		5308894030		5302651480		5308894030		5308894030		5308894030		5308894031		5308894031		5308894031		5308894031		5308894031		5308894031		5302651480		5308894030		5302651480		5308894030		5308894030		5308894030		5308894031		5308894031		5308894031		5308894031		5308894031		5308894031		5302651480		5308894030		5302651480		5308894030		5308894030		5308894030		5308894031		5308894031		5308894031		5308894031		5308894031		5308894031		5302651480		5308894030		5302651480		5308894030		5308894030		5308894030
fax		None		5308894023		5308894023																				None		5308894023		5308894023																				None		5308894023		5308894023																				None		5308894023		5308894023																				None		5308894023		5308894023																				None		5308894023		5308894023																				None		5308894023		5308894023																				None		5308894023		5308894023																				None		5308894023		5308894023																				None		5308894023		5308894023																				None		5308894023		5308894023																				None		5308894023		5308894023
email		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1143477

Table: lobbying_chg_log

filer_id		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477
change_no		0		1		2		3		4		5		6		7
session_id		2001		2007		2009		2011		2015		2015		2015		2017
log_dt		2002-05-31 00:00:00		2008-01-30 00:00:00		2009-06-08 00:00:00		2012-04-12 00:00:00		2016-01-12 00:00:00		2015-08-26 00:00:00		2016-01-12 00:00:00		2018-10-22 00:00:00
filer_type		2		1		1		1		1		1		1		1
correction_flg		Y		Y		Y		None		Y		Y		Y		None
action		ADDED		DELETED		DELETED		DELETED		DELETED		ADDED		ADDED		DELETED
attribute_changed		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM
ethics_dt		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None
filer_full_name		PLACER, COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF		PLACER; COUNTY OF
filer_city		None		None		AUBURN		None		None		AUBURN		AUBURN		None
filer_st		None		None		CA		None		None		CA		CA		None
filer_zip		None		None		95603		None		None		95603		95603		None
filer_phone		None		None		5308894031		None		None		5308894031		5308894031		None
entity_type		3		3		3		3		3		3		3		3
entity_name		HOUSTON GROUP (AKA CORPORATE ADVOCATES, INC.), THE		HOUSTON GROUP (AKA CORPORATE ADVOCATES, INC.); THE		CONSERVATION STRATEGY GROUP LLC		PLATINUM ADVISORS, LLC		PETERSON CONSULTING, INC.		CONSERVATION STRATEGY GROUP LLC		SHAW/YODER/ANTWIH, INC.		CONSERVATION STRATEGY GROUP LLC
entity_city		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None
entity_id		1147231		1147231		None		1147749		1147331		None		None		1147461
responsible_officer		None		None		None		None		None		None		None		None
effect_dt		2002-06-01 00:00:00		2008-01-30 00:00:00		2009-04-30 00:00:00		2012-03-31 00:00:00		2015-12-31 00:00:00		2015-03-11 00:00:00		2016-01-01 00:00:00		2018-09-30 00:00:00

Table: received_filings

filer_id		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477		1143477
filing_file_name		672824_0.cal		687063_0.cal		672824_1.cal		715632_0.cal		715632_1.cal		744282_0.cal		768551_0.cal		791920_0.cal		808396_0.cal		190210.cal		791920_1.cal		840296_1.cal		840296_0.cal		851173_0.cal		876765_0.cal		904317_0.cal		929048_0.cal		43579.cal		43570.cal		43562.cal		43585.cal		43669.cal		43670.cal		43704.cal		851173_1.cal		937648_0.cal		943884_0.cal		966581_0.cal		986882_0.cal		1013464_0.cal		1025447_0.cal		986882_1.cal		1013464_1.cal		1025447_1.cal		1056438_0.cal		1062667_0.cal		1078942_0.cal		1104127_0.cal		1118099_0.cal		1132233_0.cal		43961.cal		45353.cal		262120.cal		1145156_0.cal		1166851_0.cal		1189747_0.cal		1330411_0.cal		1504083_0.cal		1395058_0.cal		1344876_0.cal		1285569_1.cal		1484385_0.cal		1461886_0.cal		1450424_0.cal		1215249_0.cal		1237646_0.cal		1435850_1.cal		1260285_0.cal		1420863_0.cal		1435850_0.cal		1298043_0.cal		1285569_0.cal		1375385_0.cal		1307394_0.cal		1738175_0.cal		1678620_0.cal		1815819_0.cal		1798042_0.cal		1535655_0.cal		1621328_1.cal		1631476_1.cal		1678620_1.cal		1588953_3.cal		1588953_0.cal		1535655_1.cal		1450424_1.cal		1570129_0.cal		1839744_0.cal		1603236_0.cal		1588953_1.cal		392117.cal		30914.cal		30929.cal		1588953_2.cal		1759537_0.cal		1631476_0.cal		1603236_1.cal		1621328_0.cal		1709346_0.cal		69342.cal		282595.cal		1657509_0.cal		1864634_0.cal		1981890_0.cal		2124790_0.cal		2154390_0.cal		2059569_0.cal		2006282_0.cal		1997829_0.cal		2096107_0.cal		2096107_1.cal		1839744_1.cal		271146.cal		1911378_1.cal		1911378_0.cal		1929557_0.cal		2034039_0.cal		1960503_0.cal		2176549_0.cal		2341563_0.cal		2193817_0.cal		2441996_0.cal		2399881_1.cal		2381044_0.cal		2234558_0.cal		2319821_0.cal		2484160_0.cal		2399881_0.cal		2205079_0.cal		2416886_0.cal		451605.cal		2274249_0.cal		118363.cal		2468359_0.cal		2551005_0.cal		2675053_0.cal		2526273_0.cal		2600537_1.cal		2620114_2.cal		2644476_3.cal		2620114_0.cal		2580089_0.cal		2600537_0.cal		2644476_0.cal		2701697_0.cal		2580089_2.cal		2620114_1.cal		2644476_1.cal		2644476_2.cal		2675053_1.cal		2580089_1.cal		2734197_0.cal
received_date		2000-10-19 00:00:00		2000-11-08 00:00:00		2000-11-07 00:00:00		2001-01-27 00:00:00		2001-02-14 00:00:00		2001-04-26 00:00:00		2001-07-20 00:00:00		2001-10-31 00:00:00		2002-01-21 00:00:00		2002-01-23 00:00:00		2002-01-23 00:00:00		2002-06-20 00:00:00		2002-04-30 00:00:00		2002-07-23 00:00:00		2002-10-23 00:00:00		2003-01-21 00:00:00		2003-04-25 00:00:00		2003-02-11 00:00:00		2003-02-11 00:00:00		2003-02-11 00:00:00		2003-02-11 00:00:00		2003-02-11 00:00:00		2003-02-11 00:00:00		2003-02-11 00:00:00		2003-02-11 00:00:00		2003-05-28 00:00:00		2003-07-23 00:00:00		2003-10-23 00:00:00		2004-01-27 00:00:00		2004-04-29 00:00:00		2004-07-23 00:00:00		2004-08-24 00:00:00		2004-08-24 00:00:00		2004-08-24 00:00:00		2004-10-28 00:00:00		2004-11-24 00:00:00		2005-01-28 00:00:00		2005-04-29 00:00:00		2005-07-31 00:00:00		2005-10-28 00:00:00		2006-01-27 00:00:00		2006-01-27 00:00:00		2006-01-31 00:00:00		2006-01-27 00:00:00		2006-04-28 00:00:00		2006-07-29 00:00:00		2008-05-01 00:00:00		2010-07-28 00:00:00		2009-01-30 00:00:00		2008-07-22 00:00:00		2008-07-24 00:00:00		2010-04-29 00:00:00		2010-01-28 00:00:00		2009-10-27 00:00:00		2006-10-30 00:00:00		2007-01-31 00:00:00		2010-04-22 00:00:00		2007-04-27 00:00:00		2009-04-30 00:00:00		2009-07-29 00:00:00		2007-10-31 00:00:00		2007-07-31 00:00:00		2008-10-29 00:00:00		2008-01-28 00:00:00		2013-01-31 00:00:00		2012-07-31 00:00:00		2014-01-30 00:00:00		2013-10-28 00:00:00		2010-10-26 00:00:00		2012-10-15 00:00:00		2012-10-17 00:00:00		2012-10-17 00:00:00		2012-10-15 00:00:00		2011-04-27 00:00:00		2011-01-20 00:00:00		2011-01-05 00:00:00		2011-01-31 00:00:00		2014-04-21 00:00:00		2011-07-26 00:00:00		2011-07-15 00:00:00		2011-09-30 00:00:00		2011-10-03 00:00:00		2011-10-03 00:00:00		2011-10-25 00:00:00		2013-04-18 00:00:00		2012-01-25 00:00:00		2011-10-28 00:00:00		2011-10-28 00:00:00		2012-10-31 00:00:00		2012-04-17 00:00:00		2012-04-26 00:00:00		2012-04-30 00:00:00		2014-07-21 00:00:00		2015-07-31 00:00:00		2017-01-26 00:00:00		2017-04-27 00:00:00		2016-07-27 00:00:00		2016-01-25 00:00:00		2015-11-02 00:00:00		2016-10-26 00:00:00		2016-10-26 00:00:00		2015-01-20 00:00:00		2015-01-20 00:00:00		2015-01-20 00:00:00		2014-10-31 00:00:00		2015-01-26 00:00:00		2016-04-28 00:00:00		2015-04-22 00:00:00		2017-07-31 00:00:00		2019-01-28 00:00:00		2017-10-31 00:00:00		2020-01-31 00:00:00		2020-01-14 00:00:00		2019-04-30 00:00:00		2018-04-24 00:00:00		2018-10-31 00:00:00		2020-07-30 00:00:00		2019-07-31 00:00:00		2018-01-24 00:00:00		2019-10-29 00:00:00		2020-04-29 00:00:00		2018-07-31 00:00:00		2020-01-31 00:00:00		2020-04-28 00:00:00		2021-01-29 00:00:00		2022-04-29 00:00:00		2020-10-29 00:00:00		2022-07-09 00:00:00		2022-07-09 00:00:00		2022-07-09 00:00:00		2021-10-26 00:00:00		2021-04-30 00:00:00		2021-07-30 00:00:00		2022-01-31 00:00:00		2022-07-27 00:00:00		2022-07-09 00:00:00		2022-07-09 00:00:00		2022-07-09 00:00:00		2022-07-09 00:00:00		2022-07-09 00:00:00		2022-03-02 00:00:00		2022-10-14 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/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		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/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/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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		672824		687063		672824		715632		715632		744282		768551		791920		808396		None		791920		840296		840296		851173		876765		904317		929048		None		None		None		None		None		None		None		851173		937648		943884		966581		986882		1013464		1025447		986882		1013464		1025447		1056438		1062667		1078942		1104127		1118099		1132233		None		None		None		1145156		1166851		1189747		1330411		1504083		1395058		1344876		1285569		1484385		1461886		1450424		1215249		1237646		1435850		1260285		1420863		1435850		1298043		1285569		1375385		1307394		1738175		1678620		1815819		1798042		1535655		1621328		1631476		1678620		1588953		1588953		1535655		1450424		1570129		1839744		1603236		1588953		None		None		None		1588953		1759537		1631476		1603236		1621328		1709346		None		None		1657509		1864634		1981890		2124790		2154390		2059569		2006282		1997829		2096107		2096107		1839744		None		1911378		1911378		1929557		2034039		1960503		2176549		2341563		2193817		2441996		2399881		2381044		2234558		2319821		2484160		2399881		2205079		2416886		None		2274249		None		2468359		2551005		2675053		2526273		2600537		2620114		2644476		2620114		2580089		2600537		2644476		2701697		2580089		2620114		2644476		2644476		2675053		2580089		2734197
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		F635		F635		F635		F635		F635		F635		F635		None		None		None		None		None		None		None		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		None		None		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		None		None		F635		F635		F635		F635		F635		F635		None		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
receive_comment		Filing accepted, but but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		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 passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		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 did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing 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