Home

Filer ID: 1143403

Table: filer_address

filer_id		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403
adrid		1107765		2013969		2044742		2044743		2080213		2115182		2162614		2162615		2205309		2205310		2548885		2548886		2277746		2277747		2428907		2341338		2506733		2506734		2471977
effect_dt		1999-01-01 00:00:00		2001-01-01 00:00:00		2003-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		2009-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00
add_type		7051		7082		7051		7082		7051		7051		7051		7082		7051		7082		7051		7082		7051		7082		7051		7051		7051		7082		7051
session_id		1999		2001		2003		2003		2005		2007		2009		2009		2011		2011		2023		2023		2013		2013		2017		2015		2021		2021		2019

Table: filer_filings

filer_id		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403
filing_id		681904		469761		467862		475286		471165		473360		465915		489558		478912		491754		485870		493272		476717		478912		495424		480859		482272		484421		496887		541155		485870		464626		631586		619947		664295		681904		711544		689785		717572		757878		731760		745225		738289		781704		789583		771381		771381		776333		776333		802273		796945		813678		822706		831824		839107		843801		862094		856262		892590		903365		882684		909425		928903		934307		945020		910958		967702		953934		971362		995339		1011569		985633		1024819		1014749		1026272		1054687		1077016		1061547		1068920		1090195		1102214		1114491		1089043		1147157		1131144		1165160		1185804		1209362		1226327		1257727		1240168		1283231		1257494		1235601		1297482		1982638		1964166		1866934		1800029		1783286		1929940		1938777		1948741		1903474		1311701		1328025		1347774		1376204		1410878		1394485		1422027		1463464		1450540		1436425		1484475		1506271		1539793		1569362		1565398		1576914		1577128		1590303		1605892		1621367		1635903		1657268		1677810		1811863		1925929		1707400		1721994		1736436		1738379		1839881		1762482		1996826		2397971		2331826		2439039		2459479		2309002		2240546		2381919		2456797		2364513		2190703		2132668		2173422		2157150		2145426		2417241		2336734		2541198		2531522		2204724		2483301		2268381		2469721		2541063		2552186		2602734		2677047		2572034		2623629		2638510		2578489		2704906		2746983
period_id		163		142		157		143		150		158		149		154		159		147		153		155		151		159		148		144		152		145		156		146		153		141		161		160		162		163		163		163		164		165		None		165		164		None		167		166		166		None		None		166		None		168		None		None		169		169		None		170		None		None		171		172		173		None		174		None		175		None		None		None		177		176		178		None		None		179		180		None		180		None		181		182		None		184		183		185		186		187		188		None		None		190		189		188		191		222		221		218		215		214		220		221		None		219		192		193		194		195		None		196		197		200		199		198		201		202		203		204		None		205		205		205		206		207		208		209		210		216		221		211		212		212		None		217		213		223		238		237		240		None		235		233		237		241		None		231		229		230		229		None		239		236		244		243		232		242		234		241		244		244		246		249		None		247		248		245		250		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F635		F635		F635		F635		F635		F690		F635		F635		F635		F635		F635		F690		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F635		F635		F888		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F635		F602		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F602		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F602		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F602		F602		F635		F602		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F635
filing_sequence		1		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2000-11-06 00:00:00		1995-07-31 00:00:00		1999-04-14 00:00:00		1995-10-31 00:00:00		1997-07-31 00:00:00		1999-07-27 00:00:00		1997-04-30 00:00:00		1998-07-31 00:00:00		1999-10-18 00:00:00		1996-10-28 00:00:00		1998-04-30 00:00:00		1998-10-16 00:00:00		1997-10-31 00:00:00		1999-11-19 00:00:00		1997-01-31 00:00:00		1996-01-30 00:00:00		1998-01-30 00:00:00		1996-04-30 00:00:00		1999-01-27 00:00:00		1996-07-31 00:00:00		1998-08-07 00:00:00		1995-04-26 00:00:00		2000-05-01 00:00:00		2000-01-20 00:00:00		2000-07-31 00:00:00		2000-10-31 00:00:00		2000-11-08 00:00:00		2000-10-31 00:00:00		2001-01-30 00:00:00		2001-04-30 00:00:00		2001-01-29 00:00:00		2001-04-29 00:00:00		2001-01-31 00:00:00		2001-07-30 00:00:00		2001-10-26 00:00:00		2001-08-16 00:00:00		2001-07-30 00:00:00		2001-08-17 00:00:00		2001-08-17 00:00:00		2001-08-17 00:00:00		2001-10-26 00:00:00		2002-01-31 00:00:00		2002-01-31 00:00:00		2002-03-18 00:00:00		2002-04-30 00:00:00		2002-04-30 00:00:00		2002-07-31 00:00:00		2002-07-31 00:00:00		2002-10-30 00:00:00		2003-01-02 00:00:00		2002-10-30 00:00:00		2003-01-30 00:00:00		2003-04-25 00:00:00		2003-04-25 00:00:00		2003-07-28 00:00:00		2003-01-30 00:00:00		2003-10-27 00:00:00		2003-07-28 00:00:00		2003-10-27 00:00:00		2004-01-26 00:00:00		2004-04-27 00:00:00		2004-01-23 00:00:00		2004-07-22 00:00:00		2004-04-28 00:00:00		2004-07-26 00:00:00		2004-10-26 00:00:00		2005-01-27 00:00:00		2004-10-27 00:00:00		2004-12-30 00:00:00		2005-01-28 00:00:00		2005-04-25 00:00:00		2005-07-26 00:00:00		2005-01-03 00:00:00		2006-01-30 00:00:00		2005-10-26 00:00:00		2006-04-26 00:00:00		2006-07-20 00:00:00		2006-10-20 00:00:00		2007-01-03 00:00:00		2007-04-09 00:00:00		2007-01-03 00:00:00		2007-07-30 00:00:00		2007-04-18 00:00:00		2007-01-30 00:00:00		2007-10-31 00:00:00		2015-07-31 00:00:00		2015-04-29 00:00:00		2014-07-25 00:00:00		2013-10-30 00:00:00		2013-07-31 00:00:00		2015-01-26 00:00:00		2015-02-06 00:00:00		2014-12-29 00:00:00		2014-10-23 00:00:00		2008-01-31 00:00:00		2008-04-29 00:00:00		2008-07-29 00:00:00		2008-10-30 00:00:00		2008-12-30 00:00:00		2009-01-29 00:00:00		2009-04-30 00:00:00		2010-01-29 00:00:00		2009-10-28 00:00:00		2009-07-30 00:00:00		2010-04-29 00:00:00		2010-07-30 00:00:00		2010-10-31 00:00:00		2011-01-28 00:00:00		2010-12-28 00:00:00		2011-02-14 00:00:00		2011-02-15 00:00:00		2011-04-29 00:00:00		2011-07-28 00:00:00		2011-10-28 00:00:00		2012-01-31 00:00:00		2012-04-30 00:00:00		2012-07-30 00:00:00		2014-01-22 00:00:00		2015-01-15 00:00:00		2012-10-30 00:00:00		2012-12-31 00:00:00		2013-01-30 00:00:00		2012-12-28 00:00:00		2014-04-21 00:00:00		2013-04-26 00:00:00		2015-10-30 00:00:00		2019-07-31 00:00:00		2019-01-03 00:00:00		2020-01-29 00:00:00		2020-02-24 00:00:00		2018-10-19 00:00:00		2018-04-30 00:00:00		2019-04-30 00:00:00		2020-02-24 00:00:00		2018-12-27 00:00:00		2017-10-26 00:00:00		2017-02-03 00:00:00		2017-07-28 00:00:00		2017-05-01 00:00:00		2017-02-03 00:00:00		2019-10-29 00:00:00		2019-01-22 00:00:00		2020-12-30 00:00:00		2020-11-02 00:00:00		2018-01-24 00:00:00		2020-07-29 00:00:00		2018-07-24 00:00:00		2020-04-29 00:00:00		2020-12-30 00:00:00		2021-01-31 00:00:00		2021-08-02 00:00:00		2022-05-02 00:00:00		2020-12-30 00:00:00		2021-10-31 00:00:00		2022-01-26 00:00:00		2021-04-28 00:00:00		2022-07-29 00:00:00		2022-10-30 00:00:00
stmnt_type		10002		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		10001		10005		10005		10001		10005		10005		10001		10002		10001		10006		10002		10006		10005		10001		10005		10005		10001		10005		10005		10001		10005		10005		10001		10001		10001		10005		10001		10005		10001		10005		10005		10005		10001		10001		10001		10005		10005		10001		10001		10005		10001		10005		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10005		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001
stmnt_status		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		11003		11001		11001		11003		11001		11001		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11001		11001		11003		11003		11003		11001		11003		11001		11003		11001		11001		11001		11003		11003		11003		11001		11001		11003		11003		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		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		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003
session_id		1999		1995		1999		1995		1997		1999		1997		1997		1999		1995		1997		1997		1997		1999		1995		1995		1997		1995		1997		1995		1997		1995		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2001		2003		2003		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2007		2007		2005		2007		2015		2015		2013		2013		2013		2013		2015		2015		2013		2007		2007		2007		2007		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2015		2011		2013		2011		2013		2013		2013		2015		2019		2019		2019		2019		2017		2017		2019		2019		2019		2017		2017		2017		2017		2017		2019		2017		2021		2019		2017		2019		2017		2019		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		*		YBONILLA		*		YBONILLA		YBONILLA		*		YBONILLA		CFLAGG		*		GPEREZ		LTHIBAUL		*		*		*		JBRANNAN		JBRANNAN		JBRANNAN		LTHIBAUL		*		LTHIBAUL		CFLAGG		*		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		PBANFORD		*		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		LTHIBAUL		COMPLETED		LTHIBAUL		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		LTHIBAUL		LTHIBAUL		LTHIBAUL		SARRIAGA		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		YRODRIGU		GPEREZ		SARRIAGA		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		CAFILER		MPACHECO		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		GPEREZ		AGLADNEY		LTHIBAUL		LTHIBAUL		YRODRIGU		JGRISSUM		SARRIAGA		JGRISSUM		JGRISSUM		JINGRAM		MGUERRA		JGRISSUM		ASAETERN		ASAETERN		ASAETERN		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		AGLADNEY		SARRIAGA		ASAETERN		SARRIAGA		AGLADNEY		AGLADNEY		CAFILER		VUKSTINA		YRODRIGU		GTAYLOR		AROJAS		AGLADNEY		AGLADNEY		VUKSTINA		AROJAS		YRODRIGU		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		YRODRIGU		VUKSTINA		AGLADNEY		CAFILER		GTAYLOR		AGLADNEY		GTAYLOR		AGLADNEY		GTAYLOR		SARRIAGA		GTAYLOR		GTAYLOR		CAFILER		SARRIAGA		GTAYLOR		CHATRIDGE		GTAYLOR		CAFILER		CAFILER
special_audit		11003		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		11002		11003		11003		11002		11002		11003		11002		11003		11003		11003		11003		11003		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
fine_audit		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		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		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11003		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11003
rpt_start		2000-07-01 00:00:00		1995-04-01 00:00:00		1999-01-01 00:00:00		1995-07-01 00:00:00		1997-04-01 00:00:00		1999-04-01 00:00:00		1997-01-01 00:00:00		1998-04-01 00:00:00		1999-07-01 00:00:00		1996-07-01 00:00:00		1998-01-01 00:00:00		1998-07-01 00:00:00		1997-07-01 00:00:00		1999-07-01 00:00:00		1996-10-01 00:00:00		1995-10-01 00:00:00		1997-10-01 00:00:00		1996-01-01 00:00:00		1998-10-01 00:00:00		1996-04-01 00:00:00		1998-01-01 00:00:00		1995-01-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		2001-01-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		2000-10-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		None		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2002-10-01 00:00:00		2003-07-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-10-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-04-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2004-12-22 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		1900-01-01 00:00:00		2005-10-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		2006-12-20 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-04-01 00:00:00		2007-01-01 00:00:00		2006-10-01 00:00:00		2007-07-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2014-04-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2014-10-01 00:00:00		2015-02-06 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2007-10-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		1900-01-01 00:00:00		2008-10-01 00:00:00		2009-01-01 00:00:00		2009-10-01 00:00:00		2009-07-01 00:00:00		2009-04-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		1900-01-01 00:00:00		2011-02-14 00:00:00		2011-02-15 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2013-10-01 00:00:00		2015-01-15 00:00:00		2012-07-01 00:00:00		2012-12-31 00:00:00		2012-10-01 00:00:00		1900-01-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2019-04-01 00:00:00		2019-01-03 00:00:00		2019-10-01 00:00:00		1900-01-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2020-01-13 00:00:00		1900-01-01 00:00:00		2017-07-01 00:00:00		2017-02-03 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2019-07-01 00:00:00		2018-10-01 00:00:00		2020-12-31 00:00:00		2020-07-01 00:00:00		2017-10-01 00:00:00		2020-04-01 00:00:00		2018-04-01 00:00:00		2020-01-01 00:00:00		2020-12-31 00:00:00		2020-10-01 00:00:00		2021-04-01 00:00:00		2022-01-01 00:00:00		1900-01-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		2022-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		2000-09-30 00:00:00		1995-06-30 00:00:00		1999-03-31 00:00:00		1995-09-30 00:00:00		1997-06-30 00:00:00		1999-06-30 00:00:00		1997-03-31 00:00:00		1998-06-30 00:00:00		1999-09-30 00:00:00		1996-09-30 00:00:00		1998-03-31 00:00:00		1998-09-30 00:00:00		1997-09-30 00:00:00		1999-09-30 00:00:00		1996-12-31 00:00:00		1995-12-31 00:00:00		1997-12-31 00:00:00		1996-03-31 00:00:00		1998-12-31 00:00:00		1996-06-30 00:00:00		1998-03-31 00:00:00		1995-03-31 00:00:00		2000-03-31 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		None		2002-03-31 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2002-12-31 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2004-03-31 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2004-12-22 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2005-06-30 00:00:00		1900-01-01 00:00:00		2005-12-31 00:00:00		2005-09-30 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-12-20 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-06-30 00:00:00		2007-03-31 00:00:00		2006-12-31 00:00:00		2007-09-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2014-12-31 00:00:00		2015-02-06 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2007-12-31 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		1900-01-01 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		2009-12-31 00:00:00		2009-09-30 00:00:00		2009-06-30 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		2011-02-14 00:00:00		2011-02-15 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2015-01-15 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2014-03-31 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2019-06-30 00:00:00		2019-01-03 00:00:00		2019-12-31 00:00:00		1900-01-01 00:00:00		2018-09-30 00:00:00		2018-03-31 00:00:00		2019-03-31 00:00:00		2020-01-13 00:00:00		1900-01-01 00:00:00		2017-09-30 00:00:00		2017-02-03 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2019-09-30 00:00:00		2018-12-31 00:00:00		2020-12-31 00:00:00		2020-09-30 00:00:00		2017-12-31 00:00:00		2020-06-30 00:00:00		2018-06-30 00:00:00		2020-03-31 00:00:00		2020-12-31 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2022-03-31 00:00:00		1900-01-01 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2021-03-31 00:00:00		2022-06-30 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		22001		22001		None		22001		None		22001		None		None		None		22001		22001		22001		None		None		22001		22001		None		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001

Table: filer_interests

filer_id		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403
session_id		2003		1999		1995		1997		2001		2013		2017		2005		2011		2007		2009		2019		2021		2015		2023
interest_cd		40315		40315		40312		40315		40315		40311		40310		40315		40315		40315		40315		40310		40310		40311		40310
effect_date		2003-01-01 00:00:00		1999-01-01 00:00:00		1995-01-01 00:00:00		1997-01-01 00:00:00		2002-09-25 00:00:00		2013-01-01 00:00:00		2017-01-01 00:00:00		2005-01-01 00:00:00		2011-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00		2023-01-01 00:00:00

Table: filer_to_filer_type

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

Table: filer_xref

filer_id		1143403
xref_id		C21579
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579		C21579
filer_id		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403
filer_type		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		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		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		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		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL GROUP, INC		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL CORPORATION		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		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		None		None		None		None		None		None		None
city		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		RESTON		RESTON		SAN FRANCISCO		RESTON		SAN FRANCISCO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		VA		CA		VA		CA
zip4		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965		94105		94105		94105		94105		94105		94105		94105		941193965		94105		941193965		94105		941193965		94105		94105		20190		20190		941193965		20190		941193965
phon		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None		4157686113		None		4157689111		None		4157687158		4157687158		4157686093		None		4157686093		None		4157687158		None		4157687158		4157680100		5712620015		5712620015		None		5712620015		None
fax		4157685902		None				None								None				None				None										None				None		4157685902		None				None								None				None				None										None				None		4157685902		None				None								None				None				None										None				None		4157685902		None				None								None				None				None										None				None		4157685902		None				None								None				None				None										None				None		4157685902		None				None								None				None				None										None				None		4157685902		None				None								None				None				None										None				None		4157685902		None				None								None				None				None										None				None		4157685902		None				None								None				None				None										None				None		4157685902		None				None								None				None				None										None				None		4157685902		None				None								None				None				None										None				None		4157685902		None				None								None				None				None										None				None		4157685902		None				None								None				None				None										None				None
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1143403

Table: lobbying_chg_log

filer_id		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403
change_no		1		3		4		5		6		7		8		0		9
session_id		2001		2001		2001		1999		2001		2001		2007		2007		2015
log_dt		2001-03-19 00:00:00		2001-01-29 00:00:00		2001-03-19 00:00:00		2001-03-19 00:00:00		2001-03-19 00:00:00		2001-05-01 00:00:00		2007-04-12 00:00:00		2007-04-09 00:00:00		2015-08-07 00:00:00
filer_type		1		1		1		1		1		1		1		1		1
correction_flg		None		Y		None		None		None		None		Y		Y		Y
action		IN SUSPENSE		ADDED		CHANGED		CHANGED		CHANGED		SET ACTIVE		TERMINATED		ADDED		DELETED
attribute_changed				EMPLOYER		INTEREST		ADDRESS AND PHONE		ADDRESS		FIRM		FIRM		FIRM		FIRM
ethics_dt		None		None		None		None		None		None		None		None		None
interests		None		None		MISCELLANEOUS		None		None		None		None		None		None
filer_full_name		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC.		BECHTEL GROUP, INC
filer_city		None		None		None		SAN FRANCISCO		SAN FRANCISCO		None		None		None		SAN FRANCISCO
filer_st		None		None		None		CA		CA		None		None		None		CA
filer_zip		None		None		None		94105		94105		None		None		None		94105
filer_phone		None		None		None		4157686113		None		None		None		None		None
entity_type		1		2		3		1		1		3		3		3		3
entity_name		None		STEFFES, FOLEY & LARDNER, INC.		STEFFES, FOLEY & LARDNER, INC.		None		None		STEFFES, FOLEY & LARDNER, INC.		FOLEY & LARDNER, LLP		CAPITOL PARTNERS, INC.		CAPITOL PARTNERS, INC.
entity_city		None		SACRAMENTO		SACRAMENTO		None		None		SACRAMENTO		None		None		None
entity_st		None		CA		CA		None		None		CA		None		None		None
entity_zip		None		95814		95814		None		None		95814		None		None		None
entity_phone		None		9164446034		9164446034		None		None		9164446034		None		None		None
entity_id		0		1147230		1147230		0		0		1147230		1147230		1297424		None
responsible_officer		None		None		None		None		None		None		None		None		None
effect_dt		None		2001-01-01 00:00:00		None		None		None		None		2007-03-31 00:00:00		2007-04-02 00:00:00		2015-06-30 00:00:00

Table: lobbyist_contributions1

filer_id		1143403
filing_period_start_dt		2000-07-01 00:00:00
filing_period_end_dt		2000-09-30 00:00:00
contribution_dt		None
recipient_name		SHELLEY FOR ASSEMBLY
recipient_id		1071976
amount		1000

Table: lobbyist_contributions2

filer_id		1143403
filing_period_start_dt		2000-07-01 00:00:00
filing_period_end_dt		2000-09-30 00:00:00
contribution_dt		None
recipient_name		SHELLEY FOR ASSEMBLY
recipient_id		1071976
amount		1000

Table: received_filings

filer_id		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403		1143403
filing_file_name		681904_0.cal		15712.cal		15732.cal		15779.cal		681904_1.cal		745225_0.cal		717572_0.cal		771381_0.cal		771381_1.cal		789583_0.cal		813678_0.cal		839107_0.cal		856262_0.cal		882684_0.cal		909425_0.cal		928903_0.cal		945020_0.cal		967702_0.cal		985633_0.cal		1011569_0.cal		1024819_0.cal		1054687_0.cal		1077016_0.cal		1102214_0.cal		1114491_0.cal		1131144_0.cal		1147157_0.cal		1165160_0.cal		1185804_0.cal		1209362_0.cal		1328025_0.cal		1394485_0.cal		1347774_0.cal		1484475_0.cal		1506271_0.cal		1463464_0.cal		1450540_0.cal		1235601_0.cal		1283231_0.cal		1257494_0.cal		1422027_0.cal		1436425_0.cal		1297482_0.cal		1376204_0.cal		1311701_0.cal		1736436_0.cal		1677810_0.cal		1783286_0.cal		437931.cal		1539793_0.cal		1569362_0.cal		1839881_0.cal		1811863_0.cal		1635903_0.cal		1605892_0.cal		1590303_0.cal		1800029_0.cal		1762482_0.cal		1621367_0.cal		1707400_0.cal		1657268_0.cal		1866934_0.cal		2173422_0.cal		1996826_0.cal		1903474_0.cal		1964166_0.cal		1929940_0.cal		1982638_0.cal		2157150_0.cal		2240546_0.cal		2309002_0.cal		2190703_0.cal		2336734_0.cal		2397971_0.cal		2381919_0.cal		2204724_0.cal		2417241_0.cal		2439039_0.cal		2268381_0.cal
received_date		2000-10-31 00:00:00		2000-11-06 00:00:00		2000-11-06 00:00:00		2000-11-06 00:00:00		2000-11-06 00:00:00		2001-04-29 00:00:00		2001-01-30 00:00:00		2001-07-30 00:00:00		2001-08-16 00:00:00		2001-10-26 00:00:00		2002-01-31 00:00:00		2002-04-30 00:00:00		2002-07-31 00:00:00		2002-10-30 00:00:00		2003-01-30 00:00:00		2003-04-25 00:00:00		2003-07-28 00:00:00		2003-10-27 00:00:00		2004-01-23 00:00:00		2004-04-27 00:00:00		2004-07-22 00:00:00		2004-10-26 00:00:00		2005-01-27 00:00:00		2005-04-25 00:00:00		2005-07-26 00:00:00		2005-10-26 00:00:00		2006-01-30 00:00:00		2006-04-26 00:00:00		2006-07-20 00:00:00		2006-10-20 00:00:00		2008-04-29 00:00:00		2009-01-29 00:00:00		2008-07-29 00:00:00		2010-04-29 00:00:00		2010-07-30 00:00:00		2010-01-29 00:00:00		2009-10-28 00:00:00		2007-01-30 00:00:00		2007-07-30 00:00:00		2007-04-18 00:00:00		2009-04-30 00:00:00		2009-07-30 00:00:00		2007-10-31 00:00:00		2008-10-30 00:00:00		2008-01-31 00:00:00		2013-01-30 00:00:00		2012-07-30 00:00:00		2013-07-31 00:00:00		2013-10-30 00:00:00		2010-10-31 00:00:00		2011-01-28 00:00:00		2014-04-21 00:00:00		2014-01-22 00:00:00		2012-01-31 00:00:00		2011-07-28 00:00:00		2011-04-29 00:00:00		2013-10-30 00:00:00		2013-04-26 00:00:00		2011-10-28 00:00:00		2012-10-30 00:00:00		2012-04-30 00:00:00		2014-07-25 00:00:00		2017-07-28 00:00:00		2015-10-30 00:00:00		2014-10-23 00:00:00		2015-04-29 00:00:00		2015-01-26 00:00:00		2015-07-31 00:00:00		2017-05-01 00:00:00		2018-04-30 00:00:00		2018-10-19 00:00:00		2017-10-26 00:00:00		2019-01-22 00:00:00		2019-07-31 00:00:00		2019-04-30 00:00:00		2018-01-24 00:00:00		2019-10-29 00:00:00		2020-01-29 00:00:00		2018-07-24 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/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		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		681904		None		None		None		681904		745225		717572		771381		771381		789583		813678		839107		856262		882684		909425		928903		945020		967702		985633		1011569		1024819		1054687		1077016		1102214		1114491		1131144		1147157		1165160		1185804		1209362		1328025		1394485		1347774		1484475		1506271		1463464		1450540		1235601		1283231		1257494		1422027		1436425		1297482		1376204		1311701		1736436		1677810		1783286		None		1539793		1569362		1839881		1811863		1635903		1605892		1590303		1800029		1762482		1621367		1707400		1657268		1866934		2173422		1996826		1903474		1964166		1929940		1982638		2157150		2240546		2309002		2190703		2336734		2397971		2381919		2204724		2417241		2439039		2268381
form_id		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		F635		F635		F635		F635		F635		F635		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
receive_comment		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 accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		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