Home

Filer ID: 1015961

Table: filer_address

filer_id		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961
adrid		1014733		2135655		2215085		2188332		2210959		2218185		2402214		2422424		2437780		2431693		2490065		2517533		2528578		2444874		2222386		2235893		2456185		2486174		2495457		2282635		2296183		2287536		2300399		2303802		2365498		2328091		2323359		2375191		2349952		2361315		2539187
effect_dt		1999-03-16 00:00:00		2008-01-31 00:00:00		2011-04-29 00:00:00		2008-04-02 00:00:00		2011-01-28 00:00:00		2011-07-28 00:00:00		2016-07-27 00:00:00		2017-01-27 00:00:00		2017-07-28 00:00:00		2017-04-25 00:00:00		2020-01-27 00:00:00		2021-04-27 00:00:00		2022-01-18 00:00:00		2018-01-30 00:00:00		2011-10-31 00:00:00		2012-07-31 00:00:00		2018-07-26 00:00:00		2019-10-29 00:00:00		2020-07-28 00:00:00		2013-01-31 00:00:00		2013-07-29 00:00:00		2013-04-30 00:00:00		2013-10-29 00:00:00		2014-01-29 00:00:00		2015-07-30 00:00:00		2014-09-24 00:00:00		2014-07-31 00:00:00		2015-10-29 00:00:00		2015-01-29 00:00:00		2015-04-29 00:00:00		2022-07-19 00:00:00
add_type		7051		7082		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1999		2007		2011		2007		2011		2011		2015		2017		2017		2017		2019		2021		2021		2017		2011		2011		2017		2019		2019		2013		2013		2013		2013		2013		2015		2013		2013		2015		2015		2015		2021

Table: filer_filings

filer_id		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961
filing_id		79567		79568		205605		860430		921033		954761		1006659		1040003		1100205		1119734		1179958		1252433		1219210		1289882		1781351		1789131		1981035		1964211		1968104		1871462		1798687		1953940		1314791		1353706		1401429		1443232		1453814		1483182		1469044		1511809		1568908		1578901		1590699		1605285		1592698		1624183		1633323		1611759		1622475		1642329		1679325		1802610		1826082		1815918		1684652		1934147		1883365		1880995		1888133		1888248		1741265		1767329		1764639		1753446		1996869		1987158		2294852		2209911		2550098		2271806		2396848		2418763		1999310		2026089		2011738		2061282		2079215		2127280		2150344		2154411		2175264		2158592		2232931		2504101		2183426		2481723		2476831		2476415		2346034		2481723		2507350		2380749		2422566		2476831		2503566		2469323		2520736		2437344		2504641		2523940		2406860		2572684		2469323		2476415		2383081		2197202		2371280		2194421		2437344		2550098		2582698		2504101		2597795		2668996		2523940		2668996		2678874		2503566		2622961		2577802		2709957		2608951		2678874		2699286		2577802		2572684		2628311		2550098		2647962		2635278		2737226		2737226		2740724		2740724
period_id		153		159		157		None		None		None		None		None		None		None		None		None		None		None		214		None		222		221		None		217		215		None		None		None		None		None		None		200		None		None		203		None		205		206		None		None		208		None		207		None		209		None		None		216		None		219		None		219		219		219		211		None		213		None		223		None		None		232		244		233		238		239		None		None		224		225		None		227		None		229		230		None		None		243		None		242		None		None		235		242		243		237		None		None		None		241		244		240		243		None		None		None		241		None		None		None		None		231		240		244		None		243		246		249		None		249		None		None		247		245		None		None		None		250		245		None		None		244		None		248		251		251		None		None
form_id		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461
filing_sequence		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		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		0		1		0		0		0		0		0		1		1		0		0		1		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		1		1		0		0		0		0		0		0		0		1		0		1		1		0		1		0		0		1		0		0		1
filing_date		1999-02-16 00:00:00		1999-10-30 00:00:00		1999-08-02 00:00:00		2002-08-02 00:00:00		2003-01-31 00:00:00		2003-07-28 00:00:00		2004-02-02 00:00:00		2004-07-30 00:00:00		2005-01-31 00:00:00		2005-08-01 00:00:00		2006-02-03 00:00:00		2007-02-02 00:00:00		2006-07-31 00:00:00		2007-08-15 00:00:00		2013-07-30 00:00:00		2013-07-31 00:00:00		2015-07-30 00:00:00		2015-04-29 00:00:00		2015-04-30 00:00:00		2014-07-31 00:00:00		2013-10-29 00:00:00		2015-02-02 00:00:00		2008-01-31 00:00:00		2008-07-30 00:00:00		2009-01-29 00:00:00		2009-07-31 00:00:00		2009-11-02 00:00:00		2010-04-27 00:00:00		2010-02-01 00:00:00		2010-08-02 00:00:00		2011-01-28 00:00:00		2011-01-31 00:00:00		2011-04-29 00:00:00		2011-07-28 00:00:00		2011-04-29 00:00:00		2011-10-31 00:00:00		2012-01-28 00:00:00		2011-07-29 00:00:00		2011-10-31 00:00:00		2012-01-31 00:00:00		2012-07-31 00:00:00		2013-10-30 00:00:00		2014-01-31 00:00:00		2014-01-30 00:00:00		2012-07-31 00:00:00		2015-01-30 00:00:00		2014-07-31 00:00:00		2014-08-27 00:00:00		2014-09-24 00:00:00		2014-09-24 00:00:00		2013-01-31 00:00:00		2013-05-01 00:00:00		2013-04-30 00:00:00		2013-03-14 00:00:00		2015-10-30 00:00:00		2015-07-31 00:00:00		2018-07-31 00:00:00		2018-01-31 00:00:00		2021-04-19 00:00:00		2018-07-30 00:00:00		2019-07-30 00:00:00		2019-10-31 00:00:00		2015-10-30 00:00:00		2016-02-01 00:00:00		2016-02-01 00:00:00		2016-07-29 00:00:00		2016-07-29 00:00:00		2017-01-30 00:00:00		2017-01-30 00:00:00		2017-04-27 00:00:00		2017-07-31 00:00:00		2017-04-28 00:00:00		2018-01-31 00:00:00		2020-09-23 00:00:00		2017-07-31 00:00:00		2020-11-06 00:00:00		2020-04-29 00:00:00		2020-09-29 00:00:00		2019-01-30 00:00:00		2020-07-28 00:00:00		2020-09-30 00:00:00		2019-04-30 00:00:00		2019-10-31 00:00:00		2020-11-09 00:00:00		2020-11-09 00:00:00		2020-04-29 00:00:00		2020-10-22 00:00:00		2020-09-23 00:00:00		2020-09-23 00:00:00		2020-09-23 00:00:00		2019-07-31 00:00:00		2021-01-29 00:00:00		2020-11-06 00:00:00		2020-01-29 00:00:00		2019-04-30 00:00:00		2017-11-01 00:00:00		2019-01-31 00:00:00		2017-10-31 00:00:00		2020-01-28 00:00:00		2021-01-29 00:00:00		2021-04-28 00:00:00		2020-09-23 00:00:00		2021-07-28 00:00:00		2022-05-12 00:00:00		2020-09-29 00:00:00		2022-04-22 00:00:00		2022-04-29 00:00:00		2020-07-28 00:00:00		2021-10-29 00:00:00		2021-04-27 00:00:00		2022-07-26 00:00:00		2021-08-02 00:00:00		2022-05-16 00:00:00		2022-07-19 00:00:00		2021-04-27 00:00:00		2021-04-26 00:00:00		2021-10-29 00:00:00		2021-04-19 00:00:00		2022-01-24 00:00:00		2022-01-19 00:00:00		2022-10-31 00:00:00		2022-10-20 00:00:00		2022-10-24 00:00:00		2022-11-09 00:00:00
stmnt_type		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10005		10001		10001		10005		10001		10001		10005		10005		10001		10005		10005		10005		10001		10005		10005		10001		10005		10001		10001		10005		10005		10001		10005		10001		10005		10001		10005		10005		10001		10005		10001		10005		10001		10001		10001		10001		10005		10001		10005		10001		10005		10005		10001		10002		10001		10001		10001		10005		10005		10001		10001		10005		10001		10005		10001		10001		10005		10005		10002		10005		10002		10005		10006		10001		10001		10001		10001		10005		10006		10006		10001		10001		10002		10001		10005		10005		10005		10002		10005		10005		10005		10005		10001		10001		10001		10005		10001		10001		10002		10006		10001		10005		10005		10001		10001		10005		10005		10006		10001		10002		10006		10005		10002		10005		10001		10002		10001		10005		10006
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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		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
session_id		1997		1999		1999		2001		2001		2003		2003		2003		2003		2005		2005		2005		2005		2007		2013		2013		2015		2015		2015		2013		2013		2013		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2011		2013		2013		2013		2013		2013		2011		2013		2013		2011		2015		2015		2017		2017		2019		2017		2019		2019		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2019		2017		2019		2019		2019		2017		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2021		2019		2019		2019		2017		2019		2017		2019		2019		2021		2019		2021		2021		2019		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021
user_id		*		*		*		LTHIBAUL		YBONILLA		SMCCABE		SMCCABE		SMCCABE		SMCCABE		SMCCABE		SMCCABE		JMARTIN		JMARTIN		SMCCABE		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		SMCCABE		SMCCABE		JINGRAM		JINGRAM		JINGRAM		*		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		CAFILER		JINGRAM		CAFILER		JINGRAM		JINGRAM		JINGRAM		RGEREMIA		JINGRAM		JINGRAM		GTAYLOR		DMCCASTL		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		LPALMER		JINGRAM		DMCCASTL		GTAYLOR		LPALMER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		RGEREMIA		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		KBANH		GTAYLOR		LPALMER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR
special_audit		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001
rpt_start		1998-01-01 00:00:00		1999-07-01 00:00:00		1999-01-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2006-07-01 00:00:00		2006-01-01 00:00:00		2007-01-01 00:00:00		2013-04-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2014-01-01 00:00:00		2013-07-01 00:00:00		2014-07-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2013-10-01 00:00:00		2012-01-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2014-08-27 00:00:00		2014-09-24 00:00:00		2014-09-24 00:00:00		2012-07-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2012-07-01 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		2018-01-01 00:00:00		2017-10-01 00:00:00		2020-10-01 00:00:00		2018-01-01 00:00:00		2019-04-01 00:00:00		2019-07-01 00:00:00		2015-07-01 00:00:00		2015-10-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2017-10-01 00:00:00		2020-07-01 00:00:00		2017-04-01 00:00:00		2020-04-01 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2018-07-01 00:00:00		2020-04-01 00:00:00		2020-09-30 00:00:00		2019-01-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2020-04-01 00:00:00		2020-01-01 00:00:00		2020-10-22 00:00:00		2019-10-01 00:00:00		2020-09-23 00:00:00		2020-07-01 00:00:00		2019-04-01 00:00:00		2020-10-01 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2019-01-01 00:00:00		2017-07-01 00:00:00		2018-07-01 00:00:00		2017-07-01 00:00:00		2019-10-01 00:00:00		2020-10-01 00:00:00		2021-01-01 00:00:00		2020-07-01 00:00:00		2021-04-01 00:00:00		2022-01-01 00:00:00		2020-07-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2020-04-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2022-04-01 00:00:00		2021-04-01 00:00:00		2022-01-01 00:00:00		2022-04-01 00:00:00		2021-01-01 00:00:00		2020-10-01 00:00:00		2021-07-01 00:00:00		2020-10-01 00:00:00		2021-10-01 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00
rpt_end		1998-12-31 00:00:00		1999-09-30 00:00:00		1999-06-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2006-12-31 00:00:00		2006-06-30 00:00:00		2007-06-30 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2015-03-31 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		2014-12-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-03-31 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2014-12-31 00:00:00		2014-06-30 00:00:00		2014-08-27 00:00:00		2014-09-25 00:00:00		2014-09-24 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		2013-03-31 00:00:00		2012-12-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2020-12-31 00:00:00		2018-06-30 00:00:00		2019-06-30 00:00:00		2019-09-30 00:00:00		2015-09-30 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2017-12-31 00:00:00		2020-09-19 00:00:00		2017-06-30 00:00:00		2020-06-30 00:00:00		2020-03-31 00:00:00		2019-12-31 00:00:00		2018-12-31 00:00:00		2020-06-30 00:00:00		2020-09-30 00:00:00		2019-03-31 00:00:00		2019-09-30 00:00:00		2020-03-31 00:00:00		2020-06-30 00:00:00		2020-03-31 00:00:00		2020-10-22 00:00:00		2019-12-31 00:00:00		2020-09-23 00:00:00		2020-09-19 00:00:00		2019-06-30 00:00:00		2020-12-31 00:00:00		2020-03-31 00:00:00		2019-12-31 00:00:00		2019-03-31 00:00:00		2017-09-30 00:00:00		2018-12-31 00:00:00		2017-09-30 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		2021-03-31 00:00:00		2020-09-19 00:00:00		2021-06-30 00:00:00		2022-03-31 00:00:00		2020-09-19 00:00:00		2022-03-31 00:00:00		2022-03-31 00:00:00		2020-06-30 00:00:00		2021-09-30 00:00:00		2021-03-31 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		2022-03-31 00:00:00		2022-06-30 00:00:00		2021-03-31 00:00:00		2020-12-31 00:00:00		2021-09-30 00:00:00		2020-12-31 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-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		2013-07-30 00:00:00		None		2015-07-30 00:00:00		2015-04-29 00:00:00		None		2014-07-31 00:00:00		2013-10-29 00:00:00		None		None		None		None		None		None		2010-04-27 00:00:00		None		None		2011-01-28 00:00:00		None		2011-04-29 00:00:00		2011-07-28 00:00:00		None		None		2012-01-28 00:00:00		None		2011-10-31 00:00:00		None		2012-07-31 00:00:00		None		None		2014-01-30 00:00:00		None		2015-01-30 00:00:00		None		2014-08-27 00:00:00		2014-09-24 00:00:00		2014-09-24 00:00:00		2013-01-31 00:00:00		None		2013-04-30 00:00:00		None		2015-10-30 00:00:00		None		None		2018-01-31 00:00:00		2021-04-19 00:00:00		2018-07-30 00:00:00		2019-07-30 00:00:00		2019-10-31 00:00:00		None		None		2016-02-01 00:00:00		2016-07-29 00:00:00		None		2017-01-30 00:00:00		None		2017-04-27 00:00:00		2017-07-31 00:00:00		None		None		2020-09-23 00:00:00		None		2020-11-06 00:00:00		None		None		2019-01-30 00:00:00		2020-07-28 00:00:00		2020-09-30 00:00:00		2019-04-30 00:00:00		None		None		None		2020-04-29 00:00:00		2020-10-22 00:00:00		2020-09-23 00:00:00		2020-09-23 00:00:00		None		None		None		2020-11-06 00:00:00		None		None		None		None		2017-10-31 00:00:00		2020-01-28 00:00:00		2021-01-29 00:00:00		None		2020-09-23 00:00:00		2021-07-28 00:00:00		2022-05-12 00:00:00		None		2022-04-22 00:00:00		None		None		2021-10-29 00:00:00		2021-04-27 00:00:00		None		None		None		2022-07-19 00:00:00		2021-04-27 00:00:00		None		None		2021-04-19 00:00:00		None		2022-01-19 00:00:00		2022-10-31 00:00:00		2022-10-20 00:00:00		None		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22006		None		22006		22006		None		22006		22006		None		None		None		None		None		None		22006		None		None		22006		None		22006		22006		None		None		22006		None		22006		None		22006		None		None		22006		None		22006		None		22006		22006		22006		22006		None		22006		None		22006		None		None		22006		22006		22006		22006		22006		None		None		22006		22006		None		22006		None		22006		22006		None		None		22006		None		22006		None		None		22006		22006		22006		22006		None		None		None		22006		22006		22006		22006		None		None		None		22006		None		None		None		None		22006		22006		22006		None		22006		22006		22006		None		22006		None		None		22006		22006		None		None		None		22006		22006		None		None		22006		None		22006		22006		22006		None		None

Table: filer_to_filer_type

filer_id		1015961
filer_type		10
active		Y
race		0
session_id		1997
category		0
category_type		40502
sub_category		0
effect_dt		1999-03-16 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		None
county_cd		18036
district_cd		None

Table: filer_xref

filer_id		1015961
xref_id		499523
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523		499523
filer_id		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961		1015961
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00		1999-03-16 00:00:00
naml		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR&R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED		CR & R INCORPORATED
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
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
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
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
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
city		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON		STANTON
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
zip4		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680		90680
phon		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7148906300		7148906300		7148906300		7148906300		7148906300		7148906300		7148906300		7148906300		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7143728202		7148906300		7148906300		7148906300		7148906300		7148906300		7148906300		7148906300		7148906300
fax		None		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		None		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347		7148906347
email		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1015961