Home

Filer ID: 1146892

Table: filer_address

filer_id		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892
adrid		1109447		1108341		2042171		2079921		2113079		2159097		2189539		2205605		2415631		2471352		2510135		2281688		2489535		2343090		2550894
effect_dt		1995-01-01 00:00:00		1999-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2010-05-21 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2013-01-01 00:00:00		2019-12-01 00:00:00		2015-01-01 00:00:00		2023-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1995		1999		2003		2005		2007		2009		2009		2011		2017		2019		2021		2013		2019		2015		2023

Table: filer_filings

filer_id		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892
filing_id		500144		499284		500989		501178		499716		502563		502900		503142		501753		503468		503707		502324		502324		502563		501409		500570		502900		498630		501987		498865		499481		500337		501753		499716		501987		635835		633213		617812		664640		671955		689708		707331		690004		702079		744231		725241		754559		739835		775357		788773		780747		796190		807707		836679		820412		843233		861086		851510		901959		892998		905635		881718		898369		907664		929272		929272		925152		948962		937487		936179		957190		968676		970565		975139		985548		997087		1029612		1013077		1018022		1074711		1036580		1101422		1094998		1091979		1114593		1055947		1100638		1065328		1083928		1132183		1166669		1147482		1186795		1224474		1221654		1224825		1236131		1228371		1236131		1284725		1245722		1236131		1307529		1262404		1294132		1775941		1759797		1795907		1958657		1942772		1902110		1330147		1351430		1375058		1387574		1387574		1404258		1406371		1402742		1414234		1435634		1421755		1452319		1483107		1462319		1496698		1483107		1505961		1546110		1561056		1566516		1590290		1590290		1587339		1610401		1629832		1621323		1652310		1671181		1818302		1698077		1698077		1698077		1671181		1652310		1927117		1921647		1720727		1867484		1726688		1726688		1728387		1841052		1759797		1992482		1974501		2331277		2186456		2346196		2397040		2444163		2006364		2028822		2029175		2056956		2058521		2111889		2107744		2129732		2151770		2133565		2166676		2273211		2317723		2239150		2487415		2182019		2531864		2444163		2346900		2181770		2551384		2470392		2209321		2417229		2192663		2376935		2571082		2600799		2601975		2708383		2616777		2678078		2541100		2624782		2577136		2645773		2749632
period_id		158		157		159		144		150		154		147		155		145		148		156		146		146		154		152		151		147		141		153		149		142		143		145		150		153		None		161		160		162		163		None		164		163		None		165		None		165		164		166		167		None		None		168		169		None		None		None		170		None		None		172		171		None		None		173		173		None		174		None		None		None		175		None		None		176		None		178		177		None		180		None		181		None		None		182		179		181		None		None		183		185		184		186		188		187		188		188		None		188		190		None		188		192		189		191		214		213		215		221		None		219		193		194		195		197		197		196		None		196		None		198		197		199		201		200		None		201		202		203		None		204		205		205		204		206		208		207		209		210		216		211		211		211		210		209		220		220		212		218		212		212		None		217		213		223		222		236		None		236		238		240		224		None		225		226		226		228		227		228		229		None		230		234		235		233		242		231		243		240		None		None		244		241		232		239		231		237		None		247		246		250		None		249		244		247		245		248		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F690		F635		F635		F690		F635		F635		F635		F635		F635		F690		F690		F690		F999		F635		F635		F635		F635		F605		F635		F635		F602		F635		F603		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F603		F635		F635		F635		F690		F635		F690		F635		F635		F635		F690		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F602		F635		F603		F635		F635		F635		F635		F603		F635		F602		F635		F603		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F603		F603		F602		F603		F635		F602		F635		F635		F635		F635		F635		F605		F635		F635		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F602		F635		F635		F635		F635		F602		F605		F635		F635		F635		F635		F602		F635		F602		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F635		F602		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F602		F635		F602		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		1		0		0		0		0		0		1		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		2		0		0		0		0		1		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		1		0		0		0		0		0		0		0		0		2		1		1		1		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1999-08-02 00:00:00		1999-04-29 00:00:00		1999-11-01 00:00:00		1996-01-18 00:00:00		1997-07-29 00:00:00		1998-07-29 00:00:00		1996-10-16 00:00:00		1998-10-30 00:00:00		1996-04-22 00:00:00		1997-01-28 00:00:00		1999-02-01 00:00:00		1996-07-29 00:00:00		1997-01-28 00:00:00		1998-11-09 00:00:00		1998-01-22 00:00:00		1997-10-28 00:00:00		1997-01-28 00:00:00		1995-04-24 00:00:00		1998-04-30 00:00:00		1997-04-29 00:00:00		1995-07-17 00:00:00		1995-10-19 00:00:00		1997-01-28 00:00:00		1998-02-20 00:00:00		1998-11-09 00:00:00		2000-04-26 00:00:00		2000-04-28 00:00:00		2000-01-31 00:00:00		2000-07-27 00:00:00		2000-10-18 00:00:00		2000-11-14 00:00:00		2001-01-09 00:00:00		2000-10-24 00:00:00		2000-12-22 00:00:00		2001-04-26 00:00:00		2001-02-13 00:00:00		2001-04-26 00:00:00		2001-01-26 00:00:00		2001-08-09 00:00:00		2001-10-24 00:00:00		2001-07-25 00:00:00		2001-10-31 00:00:00		2002-01-17 00:00:00		2002-04-23 00:00:00		2002-01-23 00:00:00		2002-04-30 00:00:00		2002-07-31 00:00:00		2002-07-24 00:00:00		2002-12-20 00:00:00		2002-10-29 00:00:00		2003-01-24 00:00:00		2002-10-29 00:00:00		2002-12-24 00:00:00		2003-01-24 00:00:00		2003-04-28 00:00:00		2003-04-28 00:00:00		2003-02-03 00:00:00		2003-08-05 00:00:00		2003-04-30 00:00:00		2003-04-30 00:00:00		2003-08-05 00:00:00		2003-10-29 00:00:00		1999-12-07 00:00:00		2003-10-29 00:00:00		2004-01-23 00:00:00		2004-01-27 00:00:00		2004-07-30 00:00:00		2004-04-29 00:00:00		2004-04-30 00:00:00		2005-01-24 00:00:00		2004-08-02 00:00:00		2005-04-20 00:00:00		2005-01-14 00:00:00		2005-01-27 00:00:00		2005-07-26 00:00:00		2004-10-28 00:00:00		2005-04-18 00:00:00		2004-10-28 00:00:00		2005-02-02 00:00:00		2005-10-28 00:00:00		2006-04-28 00:00:00		2006-01-31 00:00:00		2006-07-24 00:00:00		2006-12-22 00:00:00		2006-11-16 00:00:00		2006-12-27 00:00:00		2007-01-30 00:00:00		2006-12-26 00:00:00		2007-01-30 00:00:00		2007-07-31 00:00:00		2007-01-03 00:00:00		2007-05-24 00:00:00		2008-01-28 00:00:00		2007-04-30 00:00:00		2007-10-23 00:00:00		2013-07-17 00:00:00		2013-04-22 00:00:00		2013-10-21 00:00:00		2015-04-16 00:00:00		2014-12-30 00:00:00		2014-10-22 00:00:00		2008-04-30 00:00:00		2008-07-31 00:00:00		2008-10-29 00:00:00		2009-01-05 00:00:00		2009-01-05 00:00:00		2009-02-27 00:00:00		2009-01-07 00:00:00		2009-02-17 00:00:00		2008-12-30 00:00:00		2009-07-29 00:00:00		2009-04-30 00:00:00		2009-10-30 00:00:00		2010-04-27 00:00:00		2010-01-28 00:00:00		2010-06-09 00:00:00		2010-07-13 00:00:00		2010-07-30 00:00:00		2010-11-22 00:00:00		2010-12-30 00:00:00		2011-01-26 00:00:00		2011-04-29 00:00:00		2011-06-13 00:00:00		2011-04-20 00:00:00		2011-08-03 00:00:00		2012-01-20 00:00:00		2011-10-28 00:00:00		2012-04-16 00:00:00		2012-07-13 00:00:00		2014-01-31 00:00:00		2012-10-12 00:00:00		2012-10-15 00:00:00		2012-10-12 00:00:00		2012-08-29 00:00:00		2012-08-29 00:00:00		2015-01-20 00:00:00		2014-12-30 00:00:00		2012-12-27 00:00:00		2014-07-28 00:00:00		2013-01-16 00:00:00		2013-01-16 00:00:00		2012-12-27 00:00:00		2014-04-24 00:00:00		2013-04-19 00:00:00		2015-10-19 00:00:00		2015-07-15 00:00:00		2018-12-31 00:00:00		2017-10-03 00:00:00		2019-01-30 00:00:00		2019-07-30 00:00:00		2020-03-27 00:00:00		2016-01-25 00:00:00		2016-04-12 00:00:00		2016-04-18 00:00:00		2016-07-21 00:00:00		2016-07-26 00:00:00		2016-12-19 00:00:00		2016-11-17 00:00:00		2017-01-31 00:00:00		2017-04-19 00:00:00		2016-12-19 00:00:00		2017-07-12 00:00:00		2018-07-30 00:00:00		2018-10-30 00:00:00		2018-04-27 00:00:00		2020-07-31 00:00:00		2017-08-25 00:00:00		2020-11-02 00:00:00		2020-01-31 00:00:00		2018-12-31 00:00:00		2017-08-22 00:00:00		2021-01-29 00:00:00		2020-04-30 00:00:00		2018-01-30 00:00:00		2019-10-29 00:00:00		2017-10-30 00:00:00		2019-04-24 00:00:00		2020-12-31 00:00:00		2021-07-30 00:00:00		2021-08-01 00:00:00		2022-08-01 00:00:00		2021-08-02 00:00:00		2022-05-02 00:00:00		2020-12-30 00:00:00		2021-11-01 00:00:00		2021-04-26 00:00:00		2022-01-31 00:00:00		2022-10-31 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		10001		10005		10005		10005		10005		10001		10005		10001		10005		10005		10001		10005		10005		10005		10001		10001		10005		10005		10001		10001		10005		10005		10005		10001		10005		10005		10001		10001		10005		10005		10001		10002		10006		10001		10006		10005		10005		10001		10005		10005		10001		10005		10001		10001		10005		10001		10005		10001		10005		10005		10001		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10002		10005		10001		10001		10005		10002		10001		10001		10001		10001		10002		10001		10001		10005		10001		10001		10001		10001		10001		10002		10001		10005		10001		10005		10001		10001		10001		10001		10001		10006		10002		10001		10001		10005		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10002		10002		10002		10002		10001		10001		10001		10001		10002		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10002		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11003		11003		11001		11003		11003		11003		11001		11003		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11001		11001		11001		11003
session_id		1999		1999		1999		1995		1997		1997		1995		1997		1995		1995		1997		1995		1995		1997		1997		1997		1995		1995		1997		1997		1995		1995		1995		1997		1997		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2001		2001		2003		2001		2003		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2003		2005		2003		2005		2003		2005		2005		2005		2005		2005		2007		2005		2007		2005		2007		2005		2007		2007		2005		2007		2007		2007		2013		2013		2013		2015		2015		2013		2007		2007		2007		2009		2009		2009		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2009		2011		2011		2011		2011		2011		2011		2011		2011		2013		2011		2011		2011		2011		2011		2013		2015		2013		2013		2011		2011		2013		2013		2013		2015		2015		2019		2017		2017		2019		2019		2015		2015		2015		2015		2015		2017		2015		2015		2017		2017		2017		2017		2017		2017		2019		2017		2019		2019		2019		2017		2019		2019		2017		2019		2017		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		TTHAM		*		YBONILLA		*		GPEREZ		*		YBONILLA		CFLAGG		*		GPEREZ		LTHIBAUL		YBONILLA		DHORRELL		*		JBRANNAN		LTHIBAUL		*		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		BSMITH		LTHIBAUL		COMPLETED		*		GPEREZ		DBARRICK		COMPLETED		COMPLETED		LTHIBAUL		DHORRELL		LTHIBAUL		LTHIBAUL		LTHIBAUL		COMPLETED		GGILMORE		LTHIBAUL		COMPLETED		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		LTHIBAUL		LTHIBAUL		SARRIAGA		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		PBANFORD		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		*		LTHIBAUL		SARRIAGA		LTHIBAUL		LTHIBAUL		SARRIAGA		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		AGLADNEY		AGLADNEY		AGLADNEY		MPACHECO		GPEREZ		AGLADNEY		LTHIBAUL		LTHIBAUL		JINGRAM		*		*		*		SARRIAGA		JINGRAM		PBANFORD		MGUERRA		MGUERRA		MGUERRA		ASAETERN		WBROWN		YRODRIGU		ASAETERN		ASAETERN		TBOWMAN		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		TBOWMAN		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		PBANFORD		AGLADNEY		ASAETERN		ASAETERN		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		GPEREZ		AGLADNEY		SUSHAKOV		GTAYLOR		AGLADNEY		GPEREZ		AGLADNEY		GPEREZ		AGLADNEY		PBANFORD		DWALKER		AGLADNEY		AGLADNEY		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		GTAYLOR		GPEREZ		GTAYLOR		GTAYLOR		GPEREZ		GPEREZ		MKIRKHAM		GTAYLOR		AGLADNEY		VUKSTINA		AGLADNEY		VUKSTINA		SARRIAGA		CAFILER		CHATRIDGE		CAFILER		MKIRKHAM		CAFILER		SARRIAGA		GTAYLOR		JMAVES		CHATRIDGE		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		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11002		11002		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
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		11001		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		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		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11003
rpt_start		1999-04-01 00:00:00		1999-01-01 00:00:00		1999-07-01 00:00:00		1995-10-01 00:00:00		1997-04-01 00:00:00		1998-04-01 00:00:00		1996-07-01 00:00:00		1998-07-01 00:00:00		1996-01-01 00:00:00		1996-10-01 00:00:00		1998-10-01 00:00:00		1996-04-01 00:00:00		1996-04-01 00:00:00		1998-04-01 00:00:00		1997-10-01 00:00:00		1997-07-01 00:00:00		1996-07-01 00:00:00		1995-01-01 00:00:00		1998-01-01 00:00:00		1997-01-01 00:00:00		1995-04-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		1997-04-01 00:00:00		1998-01-01 00:00:00		None		2000-01-01 00:00:00		1999-10-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		None		2000-10-01 00:00:00		2000-07-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		2000-10-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-04-01 00:00:00		1900-01-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2002-04-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		1999-04-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-10-01 00:00:00		2004-04-01 00:00:00		2005-01-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2005-04-01 00:00:00		2004-07-01 00:00:00		2005-01-13 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2005-10-01 00:00:00		2006-04-01 00:00:00		2006-12-22 00:00:00		2006-07-01 00:00:00		2006-12-31 00:00:00		2006-10-01 00:00:00		1900-01-01 00:00:00		2006-10-01 00:00:00		2007-04-01 00:00:00		1900-01-01 00:00:00		2006-10-01 00:00:00		2007-10-01 00:00:00		2007-01-01 00:00:00		2007-07-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2013-07-01 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2009-01-05 00:00:00		2009-01-05 00:00:00		2008-12-30 00:00:00		1900-01-01 00:00:00		2008-10-01 00:00:00		1900-01-01 00:00:00		2009-04-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		1900-01-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2010-12-31 00:00:00		2011-04-01 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		2013-10-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2014-10-01 00:00:00		2014-12-31 00:00:00		2012-12-31 00:00:00		2014-04-01 00:00:00		2012-10-01 00:00:00		2012-10-01 00:00:00		1900-01-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		2018-12-30 00:00:00		1900-01-01 00:00:00		2018-10-01 00:00:00		2019-04-01 00:00:00		2019-10-01 00:00:00		2015-10-01 00:00:00		1900-01-01 00:00:00		2016-01-01 00:00:00		2016-04-11 00:00:00		2016-04-01 00:00:00		2016-12-31 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2018-04-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2020-04-01 00:00:00		2017-08-14 00:00:00		2020-07-01 00:00:00		2019-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-10-01 00:00:00		2020-01-01 00:00:00		2017-10-01 00:00:00		2019-07-01 00:00:00		2017-07-01 00:00:00		2019-01-01 00:00:00		1900-01-01 00:00:00		2021-07-22 00:00:00		2021-04-01 00:00:00		2022-04-01 00:00:00		1900-01-01 00:00:00		2022-01-01 00:00:00		2020-12-31 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00
rpt_end		1999-06-30 00:00:00		1999-03-31 00:00:00		1999-09-30 00:00:00		1995-12-31 00:00:00		1997-06-30 00:00:00		1998-06-30 00:00:00		1996-09-30 00:00:00		1998-09-30 00:00:00		1996-03-31 00:00:00		1996-12-31 00:00:00		1998-12-31 00:00:00		1996-06-30 00:00:00		1996-06-30 00:00:00		1998-06-30 00:00:00		1997-12-31 00:00:00		1997-09-30 00:00:00		1996-09-30 00:00:00		1995-03-31 00:00:00		1998-03-31 00:00:00		1997-03-31 00:00:00		1995-06-30 00:00:00		1995-09-30 00:00:00		1996-03-31 00:00:00		1997-06-30 00:00:00		1998-03-31 00:00:00		None		2000-03-31 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		None		2000-12-31 00:00:00		2000-09-30 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		1900-01-01 00:00:00		2002-09-30 00:00:00		2002-12-31 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		2003-03-31 00:00:00		2002-06-30 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		1999-06-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-03-31 00:00:00		2004-12-31 00:00:00		2004-06-30 00:00:00		2005-03-31 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2004-09-30 00:00:00		2005-01-13 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		2005-09-30 00:00:00		2006-03-31 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-12-22 00:00:00		2006-09-30 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		1900-01-01 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		1900-01-01 00:00:00		2006-12-31 00:00:00		2007-12-31 00:00:00		2007-03-31 00:00:00		2007-09-30 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2013-09-30 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2009-01-05 00:00:00		2009-01-05 00:00:00		2008-12-30 00:00:00		1900-01-01 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		2009-06-30 00:00:00		2009-03-31 00:00:00		2009-09-30 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		1900-01-01 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-03-31 00:00:00		2010-12-31 00:00:00		2011-06-30 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		2013-12-31 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2012-12-31 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2014-03-31 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2018-12-30 00:00:00		1900-01-01 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2019-12-31 00:00:00		2015-12-31 00:00:00		1900-01-01 00:00:00		2016-03-31 00:00:00		2016-04-11 00:00:00		2016-06-30 00:00:00		2016-12-31 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2018-06-30 00:00:00		2018-09-30 00:00:00		2018-03-31 00:00:00		2020-06-30 00:00:00		2017-08-14 00:00:00		2020-09-30 00:00:00		2019-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-12-31 00:00:00		2020-03-31 00:00:00		2017-12-31 00:00:00		2019-09-30 00:00:00		2017-09-30 00:00:00		2019-03-31 00:00:00		1900-01-01 00:00:00		2021-07-22 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		1900-01-01 00:00:00		2022-03-31 00:00:00		2020-12-31 00:00:00		2021-09-30 00:00:00		2021-03-31 00:00:00		2021-12-31 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		None		22006		22006		None		22006		None		None		None		22006		None		None		22006		None		22006		22006		None		22006		None		22006		None		None		22006		22006		22001		None		None		22006		22006		22006		22006		22006		22006		22001		22006		None		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22001		None		22006		None		22006		22006		22006		22006		22006		None		22006		22006		22006		None		22006		22006		22006		22001		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22001		22001		22006		22006		22006		None		22006		22006		22006		22006		22001		None		22001		22001		22001		22006		None		22006		22001		22006		22001		22006		22006		22006		None		22006		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001

Table: filer_interests

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

Table: filer_to_filer_type

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

Table: filer_xref

filer_id		1146892
xref_id		E20321
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321		E20321
filer_id		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892
filer_type		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
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
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
naml		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION
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
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
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
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
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
city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865		95815		95826		95815		95815		95815		95815		95815		95815		95815		95815		95815		95815		95865		95865		95865
phon		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9163870177		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727		9166482727
fax		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		None		None		9166482738		9166482738		9166482738		9166482738				9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738		9166482738
email		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		[email protected]		None		None		None		None		None		None		None

Table: filers

filer_id		1146892

Table: lobbying_chg_log

filer_id		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892
change_no		1		2		3		5		4		6		8		7		9		10		0		11
session_id		1999		2001		2001		2001		2001		2001		2001		2001		2009		2015		2015		2017
log_dt		2000-11-14 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-12 00:00:00		2001-05-25 00:00:00		2001-05-21 00:00:00		2010-06-09 00:00:00		2016-04-22 00:00:00		2016-04-12 00:00:00		2017-09-21 00:00:00
filer_type		2		2		2		2		2		2		2		2		2		1		1		1
correction_flg		Y		None		None		None		None		None		None		None		Y		Y		Y		None
action		DELETED		SET ACTIVE		SET ACTIVE		SET ACTIVE		SET ACTIVE		SET ACTIVE		SET ACTIVE		ADDED		TEMINATED		DELETED		ADDED		DELETED
attribute_changed		LOBBYIST		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		ETHICS		LOBBYIST		FIRM		FIRM		FIRM
ethics_dt		None		None		None		None		None		None		None		2001-01-18 00:00:00		None		None		None		None
interests		None		None		None		None		None		None		None		None		None		None		None		None
filer_full_name		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION		CALIFORNIA CHIROPRACTIC ASSOCIATION
filer_city		None		DENVER		MINNEAPOLIS		MINNEAPOLIS		CLEVELAND		WALNUT CREEK		SANTA MONICA		None		None		None		None		None
filer_st		None		CO		MN		MN		OH		CA		CA		None		None		None		None		None
filer_zip		None		80264		55402		55402		441151075		94596		90405		None		None		None		None		None
filer_phone		None		3038301776		None		None		2165662239		9259386600		3103923777		None		None		None		None		None
entity_type		4		3		3		3		3		3		3		4		4		3		3		3
entity_name		BRYCE W.A. DOCHERTY		GOVERNMENTAL ADVOCATES, INC.		GOVERNMENTAL ADVOCATES, INC.		GOVERNMENTAL ADVOCATES, INC.		GOVERNMENTAL ADVOCATES, INC.		GOVERNMENTAL ADVOCATES, INC.		GOVERNMENTAL ADVOCATES, INC.		KRISTINE SHULTZ		SHULTZ, KRISTINE RENEE		GOVERNMENTAL ADVOCATES, INC.		SACRAMENTO ADVISORS, LLC		SACRAMENTO ADVISORS, LLC
entity_city		None		None		None		None		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None		None		None		None
entity_id		1223171		1147293		1147293		1147293		1147293		1147293		1147293		1149530		1149530		1147293		1384776		1384776
responsible_officer		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		None		None		None		None		None		None		None		None		2010-05-21 00:00:00		2016-04-10 00:00:00		2016-04-11 00:00:00		2017-09-01 00:00:00

Table: received_filings

filer_id		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892		1146892
filing_file_name		671955_0.cal		707331_0.cal		744231_0.cal		775357_0.cal		788773_0.cal		807707_0.cal		836679_0.cal		184120.cal		851510_0.cal		881718_0.cal		424034.cal		421893.cal		419331.cal		419434.cal		419437.cal		419604.cal		929272_0.cal		905635_0.cal		929272_1.cal		948962_0.cal		968676_0.cal		2444163_0.cal		2376935_0.cal		2417229_0.cal		2346196_0.cal		2317723_0.cal		2273211_0.cal		2239150_0.cal		2397040_0.cal		2487415_0.cal		2470392_0.cal		2209321_0.cal		2192663_0.cal		2444163_1.cal		2551384_0.cal		2749632_0.cal		2678078_0.cal		2624782_0.cal		2531864_0.cal		2601975_0.cal		2708383_0.cal		2645773_0.cal		2577136_0.cal
received_date		2000-10-18 00:00:00		2001-01-09 00:00:00		2001-04-26 00:00:00		2001-08-09 00:00:00		2001-10-24 00:00:00		2002-01-17 00:00:00		2002-04-23 00:00:00		2002-04-23 00:00:00		2002-07-24 00:00:00		2002-10-29 00:00:00		2002-10-29 00:00:00		2002-10-29 00:00:00		2002-10-29 00:00:00		2002-10-29 00:00:00		2002-10-29 00:00:00		2002-10-29 00:00:00		2003-04-28 00:00:00		2003-01-24 00:00:00		2003-04-28 00:00:00		2003-08-05 00:00:00		2003-10-29 00:00:00		2020-01-31 00:00:00		2019-04-24 00:00:00		2019-10-29 00:00:00		2019-01-30 00:00:00		2018-10-30 00:00:00		2018-07-30 00:00:00		2018-04-27 00:00:00		2019-07-30 00:00:00		2020-07-31 00:00:00		2020-04-30 00:00:00		2018-01-30 00:00:00		2017-10-30 00:00:00		2020-03-27 00:00:00		2021-01-29 00:00:00		2022-10-31 00:00:00		2022-05-02 00:00:00		2021-11-01 00:00:00		2020-11-02 00:00:00		2021-08-01 00:00:00		2022-08-01 00:00:00		2022-01-31 00:00:00		2021-04-26 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		671955		707331		744231		775357		788773		807707		836679		None		851510		881718		None		None		None		None		None		None		929272		905635		929272		948962		968676		2444163		2376935		2417229		2346196		2317723		2273211		2239150		2397040		2487415		2470392		2209321		2192663		2444163		2551384		2749632		2678078		2624782		2531864		2601975		2708383		2645773		2577136
form_id		F635		F635		F635		F635		F635		F635		F635		None		F635		F635		None		None		None		None		None		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
receive_comment		Filing accepted, but 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 passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted