Home

Filer ID: 1146905

Table: filer_address

filer_id		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905
adrid		1110485		1111194		2001729		2044056		2046198		2080737		2080738		2091356		2114577		2130258		2140102		2159203		2203275		2538936		2465054		2491283		2413200		2504449		2504450		2553565		2553566		2264156		2338197		2384175
effect_dt		1999-01-01 00:00:00		1997-01-01 00:00:00		2000-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-08-10 00:00:00		2007-01-01 00:00:00		2007-09-25 00:00:00		2008-07-10 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2022-05-20 00:00:00		2019-01-01 00:00:00		2020-01-01 00:00:00		2017-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2016-01-01 00:00:00
add_type		7051		7051		7082		7082		7051		7051		7082		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7082		7051		7082		7051		7051		7051
session_id		1999		1997		1999		2003		2003		2005		2005		2005		2007		2007		2007		2009		2011		2021		2019		2019		2017		2021		2021		2023		2023		2013		2015		2015

Table: filer_filings

filer_id		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905
filing_id		498782		498916		499335		501330		501452		501036		503052		499765		501903		502028		502473		503618		541746		498782		541659		501903		502473		503743		503180		500615		499636		500192		501903		503743		617109		632719		661522		679648		710603		690110		715584		700067		702141		732236		756648		746110		760473		737813		790681		779329		773107		814557		797379		843557		824367		838917		843614		847673		864535		893650		875828		902000		855648		902041		914471		898584		898565		885248		909323		912192		934773		927668		931103		947529		976076		956320		970157		1001045		990770		1012723		1030773		1016682		1031821		1070633		1065729		1091993		1095107		1058024		1077935		1080170		1100655		1118414		1124246		1122223		1104962		1142115		1133745		1149034		1104962		1167315		1154493		1217120		1228760		1192241		1224843		1225555		1225564		1232850		1225564		1251220		1285162		1233849		1237132		1262169		1298351		1780231		1979684		1965543		1860642		1720170		1800692		1941611		1941613		1933816		1920930		1903551		1864834		1225564		1310832		1297137		1330242		1225564		1343156		1351565		1377863		1384375		1384405		1398737		1412726		1414340		1405700		1421413		1404272		1464566		1453153		1438312		1484043		1506987		1540407		1553292		1555088		1563604		1561089		1567643		1554757		1588710		1540407		1608430		1587349		1635427		1622895		1656998		1680130		1925889		1916991		1720170		1720567		1720744		1720849		1864834		1738761		1706245		1728479		1843420		1816076		1730777		1763872		1994663		2330365		2269887		2522102		2455247		2459771		2372830		2413696		2330365		2330365		2192095		1916991		1916991		2001397		2006789		2014572		2014308		2037461		2061324		2100780		2129111		2116241		2117570		2111782		2113881		2142893		2173314		2157271		2208252		2237297		2482674		2435992		2335508		2466943		2466943		2428566		2391032		2314013		2347624		2347736		2543973		2458276		2330993		2466943		2413696		2482674		2542095		2698246		2538729		2538729		2548282		2624381		2641290		2578351		2572720		2603432		2636895		2705157		2676181		2705157		2735313
period_id		141		149		157		144		152		159		147		150		145		153		146		148		154		141		143		145		146		156		155		151		142		158		145		156		160		161		162		163		None		163		164		None		None		None		165		165		None		164		167		None		166		168		None		None		None		169		None		None		None		None		None		None		170		None		None		172		172		171		None		172		None		None		173		174		None		None		175		None		176		177		None		None		178		None		None		None		None		179		None		180		181		182		173		None		181		None		183		184		181		185		None		187		None		186		188		188		188		None		189		None		190		None		188		189		None		214		222		221		None		219		215		None		None		220		220		219		218		193		192		191		193		195		None		194		195		196		196		196		None		None		None		197		196		200		199		198		201		202		203		204		None		None		None		204		204		205		203		206		204		208		207		209		210		None		220		212		None		212		212		218		212		211		None		217		216		None		213		223		236		234		243		241		None		237		239		241		241		231		225		224		None		224		None		None		225		226		227		228		229		None		None		228		None		230		229		232		233		242		240		236		241		241		None		238		235		None		None		245		None		236		241		239		242		None		None		244		250		244		247		248		245		None		246		None		250		249		250		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F690		F690		F690		F635		F635		F635		F635		F690		F635		F635		F635		F635		F635		F602		F635		F635		F603		F602		F602		F635		F635		F605		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F635		F605		F602		F635		F602		F635		F603		F602		F635		F603		F635		F635		F690		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F603		F635		F635		F602		F635		F602		F635		F602		F635		F666		F605		F635		F605		F635		F635		F635		F635		F605		F635		F603		F635		F602		F602		F603		F605		F603		F602		F635		F602		F635		F635		F605		F635		F635		F635		F605		F603		F635		F602		F602		F635		F602		F635		F635		F603		F635		F635		F635		F603		F605		F635		F635		F602		F603		F635		F602		F602		F603		F635		F602		F635		F635		F635		F635		F635		F635		F603		F603		F602		F602		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F603		F603		F603		F603		F602		F602		F635		F635		F635		F602		F635		F635		F602		F635		F635		F603		F635		F635		F602		F605		F635		F635		F603		F603		F635		F603		F603		F605		F635		F603		F605		F635		F635		F635		F635		F602		F605		F603		F603		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F603		F602		F605		F602		F635		F635		F635		F603		F605		F603		F603		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		1		1		0		0		0		0		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		1		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		1		2		0		0		0		3		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		2		0		2		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		2		1		0		0		0		0		0		0		0		0		0		1		0		0		0		0		1		0		0		0		0		0		0		0		1		0		0		0
filing_date		1995-04-28 00:00:00		1997-04-30 00:00:00		1999-04-30 00:00:00		1996-01-30 00:00:00		1998-01-30 00:00:00		1999-10-26 00:00:00		1996-10-29 00:00:00		1997-07-30 00:00:00		1996-04-30 00:00:00		1998-04-29 00:00:00		1996-07-31 00:00:00		1997-01-31 00:00:00		1998-07-31 00:00:00		1995-05-23 00:00:00		1995-10-27 00:00:00		1996-10-16 00:00:00		1996-10-16 00:00:00		1999-02-01 00:00:00		1998-10-29 00:00:00		1997-10-30 00:00:00		1995-07-26 00:00:00		1999-07-30 00:00:00		1996-10-29 00:00:00		1999-01-28 00:00:00		2000-01-31 00:00:00		2000-04-25 00:00:00		2000-07-31 00:00:00		2000-10-28 00:00:00		2000-12-21 00:00:00		2000-10-30 00:00:00		2001-01-27 00:00:00		2000-12-01 00:00:00		2000-12-22 00:00:00		2000-12-29 00:00:00		2001-04-30 00:00:00		2001-04-30 00:00:00		2001-05-29 00:00:00		2001-01-29 00:00:00		2001-10-30 00:00:00		2001-07-31 00:00:00		2001-07-31 00:00:00		2002-01-31 00:00:00		2001-10-30 00:00:00		2002-04-30 00:00:00		2002-01-31 00:00:00		2002-04-29 00:00:00		2002-04-30 00:00:00		2002-06-06 00:00:00		2002-07-31 00:00:00		2002-10-30 00:00:00		2002-10-18 00:00:00		2002-12-30 00:00:00		2002-07-31 00:00:00		2002-12-20 00:00:00		2003-01-31 00:00:00		2002-12-30 00:00:00		2002-12-30 00:00:00		2002-10-31 00:00:00		2002-12-30 00:00:00		2003-01-31 00:00:00		2003-04-29 00:00:00		2003-03-25 00:00:00		2003-04-30 00:00:00		2003-07-31 00:00:00		2003-10-31 00:00:00		2003-07-31 00:00:00		2003-10-31 00:00:00		2004-02-02 00:00:00		2004-02-02 00:00:00		2004-04-29 00:00:00		2004-07-28 00:00:00		2004-04-27 00:00:00		2004-08-02 00:00:00		2004-12-30 00:00:00		2004-10-29 00:00:00		2005-01-26 00:00:00		2005-01-14 00:00:00		2004-10-29 00:00:00		2004-12-30 00:00:00		2005-01-31 00:00:00		2005-04-18 00:00:00		2005-08-01 00:00:00		2005-09-01 00:00:00		2005-08-10 00:00:00		2005-05-01 00:00:00		2006-01-13 00:00:00		2005-10-31 00:00:00		2006-01-31 00:00:00		2006-02-28 00:00:00		2006-04-30 00:00:00		2006-03-06 00:00:00		2006-10-31 00:00:00		2006-12-29 00:00:00		2006-07-31 00:00:00		2006-12-27 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2007-01-23 00:00:00		2007-01-27 00:00:00		2007-01-03 00:00:00		2007-07-31 00:00:00		2006-12-29 00:00:00		2007-01-31 00:00:00		2007-04-30 00:00:00		2007-11-01 00:00:00		2013-07-29 00:00:00		2015-07-29 00:00:00		2015-04-30 00:00:00		2014-06-26 00:00:00		2014-07-02 00:00:00		2013-10-31 00:00:00		2014-12-02 00:00:00		2014-12-29 00:00:00		2015-01-30 00:00:00		2014-12-28 00:00:00		2014-10-23 00:00:00		2014-10-17 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2007-10-31 00:00:00		2008-04-30 00:00:00		2008-07-15 00:00:00		2008-07-14 00:00:00		2008-07-31 00:00:00		2008-10-31 00:00:00		2008-12-18 00:00:00		2008-12-18 00:00:00		2009-02-02 00:00:00		2008-12-19 00:00:00		2008-12-30 00:00:00		2008-12-19 00:00:00		2009-04-30 00:00:00		2009-02-27 00:00:00		2010-02-01 00:00:00		2009-11-02 00:00:00		2009-07-31 00:00:00		2010-04-29 00:00:00		2010-08-01 00:00:00		2010-11-01 00:00:00		2010-12-22 00:00:00		2010-12-23 00:00:00		2010-12-29 00:00:00		2010-12-30 00:00:00		2011-01-27 00:00:00		2010-12-28 00:00:00		2011-04-27 00:00:00		2011-03-08 00:00:00		2011-08-01 00:00:00		2011-04-20 00:00:00		2012-01-30 00:00:00		2011-10-31 00:00:00		2012-04-30 00:00:00		2012-07-31 00:00:00		2014-12-02 00:00:00		2014-12-04 00:00:00		2012-12-26 00:00:00		2012-12-20 00:00:00		2012-12-27 00:00:00		2012-12-27 00:00:00		2014-07-22 00:00:00		2013-01-31 00:00:00		2012-10-29 00:00:00		2012-12-27 00:00:00		2014-04-29 00:00:00		2014-01-30 00:00:00		2012-12-27 00:00:00		2013-04-29 00:00:00		2015-10-27 00:00:00		2018-12-28 00:00:00		2018-07-26 00:00:00		2020-10-23 00:00:00		2020-02-20 00:00:00		2020-02-25 00:00:00		2019-04-15 00:00:00		2019-10-18 00:00:00		2020-02-20 00:00:00		2020-02-20 00:00:00		2017-10-30 00:00:00		2016-03-09 00:00:00		2015-11-11 00:00:00		2015-11-13 00:00:00		2016-01-26 00:00:00		2016-02-05 00:00:00		2016-01-22 00:00:00		2016-05-02 00:00:00		2016-07-29 00:00:00		2016-10-31 00:00:00		2017-01-31 00:00:00		2017-01-02 00:00:00		2016-12-30 00:00:00		2016-12-15 00:00:00		2016-12-23 00:00:00		2016-12-30 00:00:00		2017-07-28 00:00:00		2017-05-01 00:00:00		2018-01-30 00:00:00		2018-04-26 00:00:00		2020-08-12 00:00:00		2020-01-27 00:00:00		2019-01-17 00:00:00		2020-08-11 00:00:00		2020-07-23 00:00:00		2019-12-24 00:00:00		2019-07-18 00:00:00		2018-10-26 00:00:00		2018-12-28 00:00:00		2018-12-28 00:00:00		2021-01-13 00:00:00		2020-02-25 00:00:00		2018-12-28 00:00:00		2020-04-22 00:00:00		2020-08-11 00:00:00		2020-07-29 00:00:00		2020-12-15 00:00:00		2022-06-09 00:00:00		2020-12-28 00:00:00		2022-06-08 00:00:00		2021-01-27 00:00:00		2021-11-01 00:00:00		2022-01-28 00:00:00		2021-04-28 00:00:00		2020-12-30 00:00:00		2021-08-02 00:00:00		2022-01-05 00:00:00		2022-08-01 00:00:00		2022-05-02 00:00:00		2022-07-29 00:00:00		2022-10-18 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10005		10005		10001		10005		10005		10005		10005		10001		10005		10005		10001		10005		10001		10001		10005		10005		10005		10001		10005		10005		10005		10005		10005		10005		10001		10005		10005		10001		10001		10001		10005		10001		10005		10006		10001		10001		10005		10005		10001		10005		10001		10001		10005		10005		10001		10005		10005		10005		10005		10001		10005		10001		10001		10001		10005		10005		10001		10005		10001		10001		10002		10001		10005		10001		10005		10001		10001		10001		10001		10005		10002		10005		10001		10005		10001		10001		10005		10001		10001		10001		10006		10002		10001		10005		10005		10001		10001		10001		10002		10002		10001		10001		10001		10002		10005		10001		10001		10001		10001		10001		10005		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10005		10001		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10005		10001		10001		10001		10001		10001		10001		10002		10001		10001		10002		10002		10001		10002		10002		10006		10001		10005		10006		10001		10001		10001		10001		10001		10006		10005		10001		10005		10001		10001		10001		10001		10002		10001		10001		10002		10002		10005		10001		10001		10001		10001		10001		10005		10001		10001		10002		10001		10001		10002		10001		10002		10001		10001		10001		10001		10005		10001		10005		10002		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11001		11003		11001		11001		11003		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11003		11003		11001		11003		11001		11001		11003		11003		11001		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003
session_id		1995		1997		1999		1995		1997		1999		1995		1997		1995		1997		1995		1995		1997		1995		1995		1995		1995		1997		1997		1997		1995		1999		1995		1997		1999		1999		1999		1999		2001		1999		1999		2001		2001		2001		2001		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2003		2001		2003		2003		2001		2003		2001		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2003		2005		2003		2005		2003		2005		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2007		2007		2007		2007		2007		2007		2007		2007		2005		2007		2007		2013		2015		2015		2013		2013		2013		2015		2015		2013		2015		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2009		2011		2011		2009		2011		2011		2011		2011		2011		2011		2015		2015		2013		2013		2013		2013		2013		2011		2011		2013		2013		2013		2013		2013		2015		2019		2017		2019		2019		2019		2019		2019		2019		2019		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2017		2017		2017		2019		2019		2017		2019		2019		2019		2019		2017		2019		2019		2021		2019		2019		2019		2019		2019		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		YBONILLA		*		DHULSE		YBONILLA		*		GGILMORE		CFLAGG		PBANFORD		YBONILLA		*		CFLAGG		YBONILLA		*		GPEREZ		*		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		KVANG		CFLAGG		PBANFORD		*		BSMITH		LTHIBAUL		COMPLETED		DHORRELL		*		SARRIAGA		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		DMCCASTL		LTHIBAUL		LTHIBAUL		SARRIAGA		COMPLETED		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		PROBERTS		SARRIAGA		LTHIBAUL		CFLAGG		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		SARRIAGA		LTHIBAUL		SARRIAGA		LTHIBAUL		*		DHORRELL		*		PBANFORD		*		SARRIAGA		LTHIBAUL		PBANFORD		LTHIBAUL		LTHIBAUL		SARRIAGA		AGLADNEY		AGLADNEY		AGLADNEY		SMCCONNAN		YRODRIGU		AGLADNEY		PBANFORD		JINGRAM		MPACHECO		PBANFORD		ASAETERN		ASAETERN		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		ASAETERN		YRODRIGU		YRODRIGU		ASAETERN		CFLAGG		PBANFORD		DMCCASTL		MGUERRA		YRODRIGU		MGUERRA		MGUERRA		MGUERRA		ASAETERN		ASAETERN		ASAETERN		YRODRIGU		YRODRIGU		SARRIAGA		PBANFORD		AGLADNEY		*		AGLADNEY		AGLADNEY		AGLADNEY		*		ASAETERN		ASAETERN		AGLADNEY		AGLADNEY		GPEREZ		YRODRIGU		SARRIAGA		SARRIAGA		PBANFORD		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		AGLADNEY		ASAETERN		PBANFORD		ASAETERN		JINGRAM		CAFILER		AGLADNEY		GTAYLOR		GPEREZ		AROJAS		VUKSTINA		VUKSTINA		GPEREZ		GPEREZ		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		MPACHECO		YRODRIGU		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		YRODRIGU		YRODRIGU		YRODRIGU		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		GTAYLOR		VUKSTINA		AGLADNEY		GTAYLOR		GTAYLOR		SARRIAGA		VUKSTINA		AGLADNEY		GPEREZ		DMCCASTL		SARRIAGA		GPEREZ		GPEREZ		VUKSTINA		GTAYLOR		GTAYLOR		CVANLIEW		JMENDOZA		CVANLIEW		CAFILER		GTAYLOR		GTAYLOR		CHATRIDGE		CHATRIDGE		SARRIAGA		GTAYLOR		MMERCHANT		CAFILER		CAFILER		CAFILER		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11002		11003		11002		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		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		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		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		11003		11001		11001		11003		11001		11003		11003		11003		11001		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003
rpt_start		1995-01-01 00:00:00		1997-01-01 00:00:00		1999-01-01 00:00:00		1995-10-01 00:00:00		1997-10-01 00:00:00		1999-07-01 00:00:00		1996-07-01 00:00:00		1997-04-01 00:00:00		1996-01-01 00:00:00		1998-01-01 00:00:00		1996-04-01 00:00:00		1996-10-01 00:00:00		1998-04-01 00:00:00		1995-01-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		1996-04-01 00:00:00		1998-10-01 00:00:00		1998-07-01 00:00:00		1997-07-01 00:00:00		1995-04-01 00:00:00		1999-04-01 00:00:00		1996-01-01 00:00:00		1998-10-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		1900-01-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		1900-01-01 00:00:00		2000-10-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2000-10-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-04-01 00:00:00		1900-01-01 00:00:00		2002-10-01 00:00:00		2002-12-30 00:00:00		2002-12-30 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2002-01-01 00:00:00		2003-01-01 00:00:00		2003-04-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		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		1900-01-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		1900-01-01 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2005-01-14 00:00:00		2005-04-01 00:00:00		2003-01-01 00:00:00		1900-01-01 00:00:00		2005-01-01 00:00:00		1900-01-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2005-01-01 00:00:00		2006-01-01 00:00:00		1900-01-01 00:00:00		2006-07-01 00:00:00		1900-01-01 00:00:00		2006-04-01 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		1900-01-01 00:00:00		2007-01-27 00:00:00		1900-01-01 00:00:00		2007-04-01 00:00:00		1900-01-01 00:00:00		2006-10-01 00:00:00		2007-01-01 00:00:00		1900-01-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		2014-07-02 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-10-01 00:00:00		2014-12-28 00:00:00		2014-07-01 00:00:00		2014-04-01 00:00:00		2008-01-31 00:00:00		2007-10-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-07-15 00:00:00		1900-01-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2008-12-18 00:00:00		2008-12-18 00:00:00		2008-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-01-01 00:00:00		2008-12-30 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-12-22 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2010-12-28 00:00:00		2011-01-01 00:00:00		2010-07-01 00:00:00		2011-04-01 00:00:00		2010-12-31 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		1900-01-01 00:00:00		2014-12-04 00:00:00		2012-12-26 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2012-12-27 00:00:00		2014-04-01 00:00:00		2012-10-01 00:00:00		2012-07-01 00:00:00		1900-01-01 00:00:00		2014-01-01 00:00:00		2013-10-01 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2018-12-28 00:00:00		2018-04-01 00:00:00		2020-07-01 00:00:00		2020-02-20 00:00:00		1900-01-01 00:00:00		2019-01-01 00:00:00		2019-07-01 00:00:00		2020-02-20 00:00:00		2020-02-20 00:00:00		2017-07-01 00:00:00		2016-03-09 00:00:00		2015-11-11 00:00:00		1900-01-01 00:00:00		2015-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2017-01-02 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-12-23 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2017-10-01 00:00:00		2018-01-01 00:00:00		2020-04-01 00:00:00		2019-10-01 00:00:00		2018-10-01 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		1900-01-01 00:00:00		2019-04-01 00:00:00		2018-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-01-13 00:00:00		1900-01-01 00:00:00		2018-12-28 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2020-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-12-28 00:00:00		2022-05-26 00:00:00		2020-10-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		1900-01-01 00:00:00		2021-04-01 00:00:00		1900-01-01 00:00:00		2022-04-01 00:00:00		2022-01-01 00:00:00		2022-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		1995-03-31 00:00:00		1997-03-31 00:00:00		1999-03-31 00:00:00		1995-12-31 00:00:00		1997-12-31 00:00:00		1999-09-30 00:00:00		1996-09-30 00:00:00		1997-06-30 00:00:00		1996-03-31 00:00:00		1998-03-31 00:00:00		1996-06-30 00:00:00		1996-12-31 00:00:00		1998-06-30 00:00:00		1995-03-31 00:00:00		1995-09-30 00:00:00		1996-03-31 00:00:00		1996-06-30 00:00:00		1998-12-31 00:00:00		1998-09-30 00:00:00		1997-09-30 00:00:00		1995-06-30 00:00:00		1999-06-30 00:00:00		1996-03-31 00:00:00		1998-12-31 00:00:00		1999-12-31 00:00:00		2000-03-31 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		1900-01-01 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		1900-01-01 00:00:00		2000-12-31 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2002-03-31 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		2002-03-31 00:00:00		2000-12-31 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-06-30 00:00:00		1900-01-01 00:00:00		2002-12-31 00:00:00		2002-12-30 00:00:00		2002-12-30 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2002-03-31 00:00:00		2003-03-31 00:00:00		2003-06-30 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		2003-12-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		1900-01-01 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		1900-01-01 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2005-01-14 00:00:00		2005-06-30 00:00:00		2004-12-31 00:00:00		1900-01-01 00:00:00		2005-03-31 00:00:00		1900-01-01 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2005-03-31 00:00:00		2006-03-31 00:00:00		1900-01-01 00:00:00		2006-09-30 00:00:00		1900-01-01 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		1900-01-01 00:00:00		2007-01-27 00:00:00		1900-01-01 00:00:00		2007-06-30 00:00:00		1900-01-01 00:00:00		2006-12-31 00:00:00		2007-03-31 00:00:00		1900-01-01 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		2014-07-02 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-12-31 00:00:00		2014-12-28 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2008-01-31 00:00:00		2007-12-31 00:00:00		2007-09-30 00:00:00		2008-03-31 00:00:00		2008-07-15 00:00:00		1900-01-01 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-12-18 00:00:00		2008-12-18 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-03-31 00:00:00		2008-12-30 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-22 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2010-12-28 00:00:00		2011-03-31 00:00:00		2010-09-30 00:00:00		2011-06-30 00:00:00		2010-12-31 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		1900-01-01 00:00:00		2014-12-04 00:00:00		2012-12-26 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2012-12-27 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2012-09-30 00:00:00		1900-01-01 00:00:00		2014-03-31 00:00:00		2013-12-31 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2018-12-28 00:00:00		2018-06-30 00:00:00		2020-09-30 00:00:00		2020-02-20 00:00:00		1900-01-01 00:00:00		2019-03-31 00:00:00		2019-09-30 00:00:00		2020-02-20 00:00:00		2020-02-20 00:00:00		2017-09-30 00:00:00		2016-03-09 00:00:00		2015-11-11 00:00:00		1900-01-01 00:00:00		2015-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2017-01-02 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-12-23 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2017-12-31 00:00:00		2018-03-31 00:00:00		2020-06-30 00:00:00		2019-12-31 00:00:00		2018-12-31 00:00:00		2020-03-31 00:00:00		2020-03-31 00:00:00		1900-01-01 00:00:00		2019-06-30 00:00:00		2018-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-01-13 00:00:00		1900-01-01 00:00:00		2018-12-28 00:00:00		2020-03-31 00:00:00		2019-09-30 00:00:00		2020-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-12-28 00:00:00		2022-05-26 00:00:00		2020-12-31 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2021-03-31 00:00:00		1900-01-01 00:00:00		2021-06-30 00:00:00		1900-01-01 00:00:00		2022-06-30 00:00:00		2022-03-31 00:00:00		2022-06-30 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		22001		None		None		22001		22001		None		None		22001		None		22001		22001		None		None		22001		None		None		None		None		22001		None		22001		22001		22001		None		None		22001		None		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		None		22006		None		22001		None		22001		22001		None		22006		22006		22006		None		22006		22006		None		None		22006		22006		22006		22006		22006		22006		22001		22006		22006		None		22006		22006		22006		22006		22006		None		None		None		22006		22001		22006		22006		22006		22006		22006		22006		22006		None		None		None		22006		22006		22006		22006		22006		22001		22006		22006		22006		22006		None		22006		22006		None		22001		22006		22006		22006		22006		None		22006		22006		None		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		None		22006		None		None		22006		22006		22006		22006		22006		None		None		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		None		None		22006		None		22006		22006		22006		22006		None		None		22006		22001		22006		22006		22006		22006		None		22006		None		22001		22001		22001		22001

Table: filer_interests

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

Table: filer_to_filer_type

filer_id		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905
filer_type		2		2		2		2		2		2		2		2		2		2		2		2		2		1		2		2		2
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None
session_id		1999		1995		1997		2001		2003		2005		2007		2011		2013		2009		2019		2021		2015		2015		2015		2017		2023
category		0		0		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None
category_type		0		0		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None
sub_category		0		0		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None
effect_dt		1999-01-01 00:00:00		1995-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		2013-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		2015-11-10 00:00:00		2016-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None
election_type		0		0		0		0		0		0		0		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		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		None
party_cd		None		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		None
district_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1146905
xref_id		E21121
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121		E21121
filer_id		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905
filer_type		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER
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		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		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		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		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		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GSK		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PK		RESEARCH TRIANGLE PK		SACRAMENTO		SACRAMENTO		RESEARCH TRIANGLE PARK		RESEARCH TRIANGLE PARK		SACRAMENTO		PHOENIX		RESEARCH TRIANGLE PARK		PHOENIX		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NC		NC		CA		CA		NC		NC		CA		AZ		NC		AZ		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814		27709		27709		95814		95814		27709		27709		95814		85016		27709		85016		95814		95814		958143805		958143805		958143805		95814		95814		95814		95814		95814		95814		95811		95811		95814
phon		None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080				None		9194832100		9164983308				9164484774		9164484774				9164484774		9164484774		8004529634		9164436885		9164436885		9164436885		9164436885		9164436885		9164412430		9164412430		9164412430		9167018999		9167018999				9162731080		9162731080
fax		None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144				None		None		None				9164983365		9164983365				9164983365																								9164471144				9164471144		9164471144
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		[email protected]		None		[email protected]		[email protected]		None

Table: filers

filer_id		1146905

Table: lobbying_chg_log

filer_id		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905
change_no		1		2		3		4		15		6		7		8		10		9		11		12		5		13		14		0		17		18
session_id		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		1999		2001		2001		2001		2001		2005		2007		2013
log_dt		2000-08-09 00:00:00		2000-08-09 00:00:00		2000-11-21 00:00:00		2001-03-26 00:00:00		2002-10-18 00:00:00		2001-04-09 00:00:00		2001-05-01 00:00:00		2001-05-01 00:00:00		2001-05-01 00:00:00		2001-05-01 00:00:00		2001-05-05 00:00:00		2001-05-12 00:00:00		2001-04-09 00:00:00		2001-05-25 00:00:00		2001-05-29 00:00:00		2006-01-13 00:00:00		2008-07-14 00:00:00		2014-07-11 00:00:00
filer_type		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2
correction_flg		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		Y		None		Y		None
action		SET INACTIVE		SET INACTIVE		SET ACTIVE		IN SUSPENSE		TERMINATED		IN SUSPENSE		SET ACTIVE		SET ACTIVE		SET ACTIVE		SET ACTIVE		CHANGED		SET ACTIVE		IN SUSPENSE		SET ACTIVE		ADDED		ADDED		TERMINATED		DELETED
attribute_changed		None		None		CLIENT		CLIENT		LOBBYIST		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		ADDRESS		CLIENT		FIRM		CLIENT		LOBBYIST		LOBBYIST		LOBBYIST		FIRM
ethics_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_full_name		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXO WELLCOME INC.		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE		GLAXOSMITHKLINE
filer_city		None		None		CERRITOS		DANA POINT		None		None		DENVER		MINNEAPOLIS		MINNEAPOLIS		CLEVELAND		None		WALNUT CREEK		SACRAMENTO		SANTA MONICA		None		None		None		None
filer_st		None		None		CA		CA		None		None		CO		MN		MN		OH		None		CA		CA		CA		None		None		None		None
filer_zip		None		None		907026028		92829		None		None		80264		55402		55402		441151075		None		94596		95814		90405		None		None		None		None
filer_phone		None		None		3109240000		9494888800		None		None		3038301776		None		None		2165662239		None		9259386600		9165579944		3103923777		None		None		None		None
entity_type		3		3		3		3		4		3		3		3		3		3		3		3		3		3		4		4		4		3
entity_name		WILKE, FLEURY, HOFFELT, GOULD & BIRNEY, LLP		WILKE, FLEURY, HOFFELT, GOULD & BIRNEY, LLP		WILKE, FLEURY, HOFFELT, GOULD & BIRNEY, LLP		WOOLLEY GROUP, THE		THOMAS A. BURNS		WILKE, FLEURY, HOFFELT, GOULD & BIRNEY, LLP		GOVERNMENTAL ADVOCATES, INC.		GOVERNMENTAL ADVOCATES, INC.		GOVERNMENTAL ADVOCATES, INC.		GOVERNMENTAL ADVOCATES, INC.		WILKE, FLEURY, HOFFELT, GOULD & BIRNEY, LLP		GOVERNMENTAL ADVOCATES, INC.		WILKE, FLEURY, HOFFELT, GOULD & BIRNEY, LLP		GOVERNMENTAL ADVOCATES, INC.		THOMAS A. BURNS		THELMA HARRIS		KIMBROUGH, JOHN		GOVERNMENTAL ADVOCATES, INC.
entity_city		None		None		None		None		None		None		None		None		None		None		SACRAMENTO		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None		None		None		95814		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None		None		9164412430		None		None		None		None		None		None		None
entity_id		1147240		1147240		1147240		1147445		1148272		1147240		1147293		1147293		1147293		1147293		1147240		1147293		1147240		1147293		1148272		1282454		1148913		1147293
responsible_officer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		None		None		None		None		2002-09-30 00:00:00		None		None		None		None		None		None		None		None		None		2001-05-15 00:00:00		2006-01-06 00:00:00		2008-06-30 00:00:00		2014-06-30 00:00:00

Table: lobbyist_contributions1

filer_id		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905
filing_period_start_dt		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00
filing_period_end_dt		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00
contribution_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
recipient_name		CHARLENE ZETTEL FOR ASSEMBLY		COMMITTEE TO ELECT KEVIN MURRAY		DEDE ALPERT FOR SENATE		FIGUEROA FOR SENATE		FRED KEELEY FOR ASSEMBLY		FRIENDS OF PETER FRUSETTA		FRIENDS OF SARAH REYES		FRIENDS OF SENATOR MONTEITH		FRIENDS OF SENATOR RICHARD ALARCON		JAY LASUER FOR ASSEMBLY		LEJA FOR ASSEMBLY		LOU CORREA FOR STATE ASSEMBLY		LT. GOVERNOR CRUZ BUSTAMANTE COMMITTEE		MARTHA ESCUTIA FOR SENATE		MARTIN GALLEGOS FOR STATE SENATE		POOCHIGIAN SENATE COMMITTEE		RAY HAYNES FOR STATE SENATE		REBECCA COHN FOR STATE ASSEMBLY		RE-ELECT ASSEMBLYWOMAN CAROLE MIGDEN		SHELLEY FOR ASSEMBLY		SHER FOR STATE SENATE		TIM LESLIE FOR ASSEMBLY		TONY CARDENAS 2000		WESSON FOR ASSEMBLY
recipient_id		1071353		1071788		1065754		1072096		1064740		1072048		1072108		1071881		1071999		1066101		1076338		1065492		1072280		1069502		1076022		1076065		1050255		1076212		1069416		1071976		1065979		1075853		1069524		1069406
amount		150		1000		1000		1000		1000		1000		500		750		600		750		500		1000		2000		1000		1000		1000		1000		500		1000		2000		1000		1500		1000		1000

Table: lobbyist_contributions2

filer_id		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905
filing_period_start_dt		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00
filing_period_end_dt		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00
contribution_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
recipient_name		CHARLENE ZETTEL FOR ASSEMBLY		COMMITTEE TO ELECT KEVIN MURRAY		DEDE ALPERT FOR SENATE		FIGUEROA FOR SENATE		FRED KEELEY FOR ASSEMBLY		FRIENDS OF PETER FRUSETTA		FRIENDS OF SARAH REYES		FRIENDS OF SENATOR MONTEITH		FRIENDS OF SENATOR RICHARD ALARCON		JAY LASUER FOR ASSEMBLY		LEJA FOR ASSEMBLY		LOU CORREA FOR STATE ASSEMBLY		LT. GOVERNOR CRUZ BUSTAMANTE COMMITTEE		MARTHA ESCUTIA FOR SENATE		MARTIN GALLEGOS FOR STATE SENATE		POOCHIGIAN SENATE COMMITTEE		RAY HAYNES FOR STATE SENATE		REBECCA COHN FOR STATE ASSEMBLY		RE-ELECT ASSEMBLYWOMAN CAROLE MIGDEN		SHELLEY FOR ASSEMBLY		SHER FOR STATE SENATE		TIM LESLIE FOR ASSEMBLY		TONY CARDENAS 2000		WESSON FOR ASSEMBLY
recipient_id		1071353		1071788		1065754		1072096		1064740		1072048		1072108		1071881		1071999		1066101		1076338		1065492		1072280		1069502		1076022		1076065		1050255		1076212		1069416		1071976		1065979		1075853		1069524		1069406
amount		150		1000		1000		1000		1000		1000		500		750		600		750		500		1000		2000		1000		1000		1000		1000		500		1000		2000		1000		1500		1000		1000

Table: received_filings

filer_id		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905		1146905
filing_file_name		14260.cal		14140.cal		14284.cal		679648_0.cal		27916.cal		715584_0.cal		746110_0.cal		30690.cal		773107_0.cal		790681_0.cal		814557_0.cal		838917_0.cal		855648_0.cal		898584_0.cal		885248_0.cal		912192_0.cal		931103_0.cal		947529_0.cal		970157_0.cal		1012723_0.cal		1058024_0.cal		1080170_0.cal		1104962_0.cal		1118414_0.cal		1133745_0.cal		1149034_0.cal		1104962_1.cal		1167315_0.cal		354770.cal		348892.cal		1192241_0.cal		352710.cal		1217120_0.cal		1225564_0.cal		1237132_0.cal		1262169_0.cal		1297137_0.cal		1285162_0.cal		145723.cal		145823.cal
received_date		2000-10-27 00:00:00		2000-10-27 00:00:00		2000-10-27 00:00:00		2000-10-28 00:00:00		2000-10-28 00:00:00		2001-01-27 00:00:00		2001-04-30 00:00:00		2001-06-04 00:00:00		2001-07-31 00:00:00		2001-10-30 00:00:00		2002-01-31 00:00:00		2002-04-29 00:00:00		2002-07-31 00:00:00		2002-12-30 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2003-04-30 00:00:00		2003-07-31 00:00:00		2003-10-31 00:00:00		2004-04-29 00:00:00		2004-10-29 00:00:00		2005-01-31 00:00:00		2005-05-01 00:00:00		2005-08-01 00:00:00		2005-10-31 00:00:00		2006-01-31 00:00:00		2006-02-28 00:00:00		2006-04-30 00:00:00		2006-07-31 00:00:00		2006-07-31 00:00:00		2006-07-31 00:00:00		2006-07-31 00:00:00		2006-10-31 00:00:00		2006-12-31 00:00:00		2007-01-31 00:00:00		2007-04-30 00:00:00		2007-10-31 00:00:00		2007-07-31 00:00:00		2020-02-20 00:00:00		2020-02-20 00:00:00
filing_directory		/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/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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/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
filing_id		None		None		None		679648		None		715584		746110		None		773107		790681		814557		838917		855648		898584		885248		912192		931103		947529		970157		1012723		1058024		1080170		1104962		1118414		1133745		1149034		1104962		1167315		None		None		1192241		None		1217120		1225564		1237132		1262169		1297137		1285162		None		None
form_id		None		None		None		F635		None		F635		F635		None		F635		F635		F635		F635		F635		F603		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		None		F635		None		F635		F603		F635		F635		F635		F635		None		None
receive_comment		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted, but with warnings		Filing pass validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing did not pass validation		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation