Home

Filer ID: 1143649

Table: filer_address

filer_id		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649
adrid		1108046		2045165		2078307		2116320		2109281		2163053		2207636		2415816		2470227		2514289		2231075		2278231		2341556		2548135
effect_dt		1999-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2006-08-01 00:00:00		2009-01-01 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		2012-01-01 00:00:00		2013-01-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
session_id		1999		2003		2005		2007		2005		2009		2011		2017		2019		2021		2011		2013		2015		2023

Table: filer_filings

filer_id		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649
filing_id		467933		464877		478229		478981		470025		481108		475542		484654		472648		473431		488267		491973		494752		495640		487382		483760		467277		487382		491096		464877		495640		498329		491096		491973		483760		498329		615475		631430		663940		696338		717964		703034		753722		772884		746500		733765		789045		781143		797238		789045		814201		798503		840143		820633		856420		884574		843281		853939		893904		904536		924161		943230		928361		928361		911833		935652		950285		965836		1002148		973316		984564		1009937		1032780		1017617		1022810		1050569		1072617		1050569		1065284		1093723		1100355		1065312		1085542		1112476		1112476		1131876		1148694		1148694		1165915		1165915		1188786		1188786		1211298		1222917		1236345		1256441		1237459		1283925		1306011		1295874		1781153		1764246		1962906		1977414		1867009		1797280		1781153		1948159		1905796		1328047		1346509		1346509		1373246		1346509		1386680		1392241		1386692		1392241		1432319		1412895		1448785		1458499		1418837		1482098		1502948		1561771		1534905		1564071		1589123		1605008		1618587		1618587		1631717		1654834		1673765		1813937		1929348		1703864		1732199		1728705		1842033		1977414		1994545		1977414		2354108		2378082		2310056		2415885		2189676		2268827		2268827		2033468		2009722		2059724		2100446		2126203		2155108		2137142		2171509		2239933		2436275		2395608		2206936		2344364		2481607		2467643		2640572		2436275		2547743		2524511		2563874		2598423		2576611		2619013		2640572		2703464		2619013		2671785		2746367		2746367
period_id		157		141		151		159		142		144		143		145		150		158		146		147		155		148		153		152		149		153		154		141		148		156		154		147		152		156		160		161		162		163		164		None		165		166		165		164		167		None		None		167		168		None		169		None		170		171		None		170		None		None		None		174		173		173		172		None		174		175		None		None		176		177		None		None		178		179		180		179		180		None		181		None		None		182		182		183		184		184		185		185		186		186		187		188		188		189		None		190		192		191		214		213		221		222		218		215		214		None		219		193		194		194		195		194		196		196		196		196		198		None		199		200		197		201		202		None		203		204		205		206		207		207		208		209		210		216		220		211		212		None		217		222		223		222		None		237		235		239		231		234		234		225		224		226		227		228		229		None		230		233		240		238		232		236		242		241		248		240		244		243		None		246		245		247		248		250		247		249		251		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F690		F690		F690		F690		F690		F690		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		1		1		1		1		1		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		1		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		0		0		1		0		0		1		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		1		0		0		2		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		2		0		1		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		0		0		1
filing_date		1999-04-30 00:00:00		1995-05-01 00:00:00		1997-10-31 00:00:00		1999-10-29 00:00:00		1995-07-31 00:00:00		1996-02-01 00:00:00		1995-10-31 00:00:00		1996-04-30 00:00:00		1997-07-31 00:00:00		1999-07-30 00:00:00		1996-07-31 00:00:00		1996-10-31 00:00:00		1998-10-30 00:00:00		1997-01-29 00:00:00		1998-04-30 00:00:00		1998-01-30 00:00:00		1997-04-30 00:00:00		1998-05-15 00:00:00		1998-07-31 00:00:00		1995-06-15 00:00:00		1997-05-02 00:00:00		1999-05-21 00:00:00		1998-10-22 00:00:00		1997-05-02 00:00:00		1998-02-09 00:00:00		1999-01-28 00:00:00		2000-01-31 00:00:00		2000-05-01 00:00:00		2000-07-31 00:00:00		2000-10-31 00:00:00		2001-01-31 00:00:00		2000-12-27 00:00:00		2001-04-30 00:00:00		2001-07-31 00:00:00		2001-04-30 00:00:00		2001-01-31 00:00:00		2001-10-24 00:00:00		2001-07-31 00:00:00		2001-10-31 00:00:00		2001-11-20 00:00:00		2002-01-31 00:00:00		2001-11-09 00:00:00		2002-04-30 00:00:00		2002-01-31 00:00:00		2002-07-30 00:00:00		2002-10-31 00:00:00		2002-04-30 00:00:00		2002-07-30 00:00:00		2002-10-31 00:00:00		2002-12-30 00:00:00		2003-01-31 00:00:00		2003-07-21 00:00:00		2003-04-22 00:00:00		2003-04-22 00:00:00		2003-01-31 00:00:00		2003-04-30 00:00:00		2003-07-31 00:00:00		2003-10-21 00:00:00		2004-01-30 00:00:00		2003-10-31 00:00:00		2004-01-22 00:00:00		2004-04-20 00:00:00		2004-07-30 00:00:00		2004-04-30 00:00:00		2004-07-14 00:00:00		2004-10-21 00:00:00		2005-01-17 00:00:00		2004-11-04 00:00:00		2004-12-08 00:00:00		2005-01-31 00:00:00		2005-04-14 00:00:00		2004-11-01 00:00:00		2004-12-30 00:00:00		2005-07-29 00:00:00		2005-07-18 00:00:00		2005-10-27 00:00:00		2006-02-07 00:00:00		2006-01-31 00:00:00		2006-04-27 00:00:00		2006-07-27 00:00:00		2006-07-27 00:00:00		2006-10-24 00:00:00		2006-10-25 00:00:00		2006-12-01 00:00:00		2007-01-30 00:00:00		2007-04-12 00:00:00		2006-12-27 00:00:00		2007-07-31 00:00:00		2008-01-24 00:00:00		2007-10-29 00:00:00		2013-07-30 00:00:00		2013-04-29 00:00:00		2015-04-27 00:00:00		2015-07-26 00:00:00		2014-07-26 00:00:00		2013-10-25 00:00:00		2013-09-09 00:00:00		2014-12-29 00:00:00		2014-10-25 00:00:00		2008-04-29 00:00:00		2008-08-11 00:00:00		2008-07-28 00:00:00		2008-10-28 00:00:00		2008-10-22 00:00:00		2008-12-30 00:00:00		2009-01-26 00:00:00		2008-12-30 00:00:00		2009-05-13 00:00:00		2009-07-21 00:00:00		2008-12-29 00:00:00		2009-10-21 00:00:00		2010-01-19 00:00:00		2009-04-24 00:00:00		2010-04-25 00:00:00		2010-07-25 00:00:00		2010-12-22 00:00:00		2010-10-25 00:00:00		2011-01-23 00:00:00		2011-04-27 00:00:00		2011-07-27 00:00:00		2011-10-20 00:00:00		2011-11-02 00:00:00		2012-01-25 00:00:00		2012-04-25 00:00:00		2012-07-23 00:00:00		2014-01-27 00:00:00		2015-01-24 00:00:00		2012-10-25 00:00:00		2013-01-25 00:00:00		2012-12-27 00:00:00		2014-04-27 00:00:00		2015-08-15 00:00:00		2015-10-26 00:00:00		2015-08-02 00:00:00		2018-12-17 00:00:00		2019-04-27 00:00:00		2018-10-22 00:00:00		2019-10-26 00:00:00		2017-10-23 00:00:00		2018-07-24 00:00:00		2018-08-17 00:00:00		2016-04-27 00:00:00		2016-01-28 00:00:00		2016-07-27 00:00:00		2016-10-30 00:00:00		2017-01-28 00:00:00		2017-04-27 00:00:00		2016-12-19 00:00:00		2017-07-25 00:00:00		2018-04-27 00:00:00		2020-07-08 00:00:00		2019-07-29 00:00:00		2018-01-27 00:00:00		2019-01-29 00:00:00		2020-07-27 00:00:00		2020-04-26 00:00:00		2022-01-28 00:00:00		2020-01-27 00:00:00		2021-01-26 00:00:00		2020-10-27 00:00:00		2020-12-18 00:00:00		2021-07-28 00:00:00		2021-04-25 00:00:00		2021-10-25 00:00:00		2022-02-25 00:00:00		2022-07-28 00:00:00		2021-11-06 00:00:00		2022-04-27 00:00:00		2022-10-29 00:00:00		2022-11-06 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		10001		10005		10005		10005		10005		10001		10005		10005		10001		10001		10005		10001		10005		10005		10002		10001		10006		10001		10005		10005		10001		10005		10001		10005		10005		10005		10001		10001		10002		10001		10005		10005		10001		10005		10005		10001		10001		10005		10005		10001		10001		10001		10002		10001		10005		10001		10005		10005		10002		10001		10001		10002		10001		10001		10002		10001		10002		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10002		10005		10001		10001		10002		10001		10001		10002		10001		10001		10001		10002		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10005		10001		10002		10001		10002		10001		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10005		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10002		10001		10002		10001		10001		10002
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		11001		11003		11001		11001		11003		11003		11001		11003		11001		11001		11003		11003		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11003		11003		11001		11001		11003		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		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		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		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		11003		11003
session_id		1999		1995		1997		1999		1995		1995		1995		1995		1997		1999		1995		1995		1997		1995		1997		1997		1997		1997		1997		1995		1995		1997		1997		1995		1997		1997		1999		1999		1999		1999		1999		2001		2001		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2003		2003		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2007		2007		2007		2007		2007		2013		2013		2015		2015		2013		2013		2013		2015		2013		2007		2007		2007		2007		2007		2009		2007		2009		2007		2009		2009		2009		2009		2009		2009		2009		2011		2009		2009		2011		2011		2011		2011		2011		2011		2011		2013		2013		2011		2011		2013		2013		2015		2015		2015		2019		2019		2017		2019		2017		2017		2017		2015		2015		2015		2015		2015		2017		2017		2017		2017		2019		2019		2017		2017		2019		2019		2021		2019		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		LTHIBAUL		LTHIBAUL		*		YBONILLA		YBONILLA		*		*		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		*		LTHIBAUL		PBANFORD		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		LTHIBAUL		SARRIAGA		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		CFLAGG		LTHIBAUL		LTHIBAUL		LTHIBAUL		AGLADNEY		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		AGLADNEY		LTHIBAUL		YRODRIGU		YRODRIGU		JGRISSUM		LTHIBAUL		*		JGRISSUM		*		JGRISSUM		JGRISSUM		PBANFORD		MGUERRA		JINGRAM		JGRISSUM		ASAETERN		ASAETERN		GKURIMOT		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		MPACHECO		AGLADNEY		ASAETERN		SARRIAGA		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		SARRIAGA		VUKSTINA		AGLADNEY		VUKSTINA		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		SARRIAGA		AGLADNEY		AGLADNEY		GTAYLOR		SUSHAKOV		AGLADNEY		AGLADNEY		GTAYLOR		VUKSTINA		CHATRIDGE		GTAYLOR		GTAYLOR		GTAYLOR		MMERCHANT		MKIRKHAM		GTAYLOR		GTAYLOR		CHATRIDGE		CAFILER		GTAYLOR		CAFILER		CAFILER		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11002		11003		11002		11003		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
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		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		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		11003		11001		11001		11001		11001		11003		11001		11003		11003		11003
rpt_start		1999-01-01 00:00:00		1995-01-01 00:00:00		1997-07-01 00:00:00		1999-07-01 00:00:00		1995-04-01 00:00:00		1995-10-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		1997-04-01 00:00:00		1999-04-01 00:00:00		1996-04-01 00:00:00		1996-07-01 00:00:00		1998-07-01 00:00:00		1996-10-01 00:00:00		1998-01-01 00:00:00		1997-10-01 00:00:00		1997-01-01 00:00:00		1998-01-01 00:00:00		1998-04-01 00:00:00		1995-01-01 00:00:00		1996-10-01 00:00:00		1998-10-01 00:00:00		1998-04-01 00:00:00		1996-07-01 00:00:00		1997-10-01 00:00:00		1998-10-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-01-01 00:00:00		2000-10-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		2003-10-02 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2004-12-08 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		2005-04-01 00:00:00		2005-04-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		2006-12-01 00:00:00		2006-10-01 00:00:00		2007-01-01 00:00:00		1900-01-01 00:00:00		2007-04-01 00:00:00		2007-10-01 00:00:00		2007-07-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2014-04-01 00:00:00		2013-07-01 00:00:00		2013-04-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-04-01 00:00:00		2008-07-01 00:00:00		2008-04-01 00:00:00		2008-12-30 00:00:00		2008-10-01 00:00:00		2008-12-30 00:00:00		2008-10-01 00:00:00		2009-04-01 00:00:00		1900-01-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2009-01-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		1900-01-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2013-10-01 00:00:00		2014-10-01 00:00:00		2012-07-01 00:00:00		2012-10-01 00:00:00		1900-01-01 00:00:00		2014-01-01 00:00:00		2015-04-01 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		1900-01-01 00:00:00		2019-01-01 00:00:00		2018-07-01 00:00:00		2019-07-01 00:00:00		2017-07-01 00:00:00		2018-04-01 00:00:00		2018-04-01 00:00:00		2016-01-01 00:00:00		2015-10-01 00:00:00		2016-04-01 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-01-01 00:00:00		2019-10-01 00:00:00		2019-04-01 00:00:00		2017-10-01 00:00:00		2018-10-01 00:00:00		2020-04-01 00:00:00		2020-01-01 00:00:00		2021-10-01 00:00:00		2019-10-01 00:00:00		2020-10-01 00:00:00		2020-07-01 00:00:00		1900-01-01 00:00:00		2021-04-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2022-04-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00
rpt_end		1999-03-31 00:00:00		1995-03-31 00:00:00		1997-09-30 00:00:00		1999-09-30 00:00:00		1995-06-30 00:00:00		1995-12-31 00:00:00		1995-09-30 00:00:00		1996-03-31 00:00:00		1997-06-30 00:00:00		1999-06-30 00:00:00		1996-06-30 00:00:00		1996-09-30 00:00:00		1998-09-30 00:00:00		1996-12-31 00:00:00		1998-03-31 00:00:00		1997-12-31 00:00:00		1997-03-31 00:00:00		1998-03-31 00:00:00		1998-06-30 00:00:00		1995-03-31 00:00:00		1996-12-31 00:00:00		1998-12-31 00:00:00		1998-06-30 00:00:00		1996-09-30 00:00:00		1997-12-31 00:00:00		1998-12-31 00:00:00		1999-12-31 00:00:00		2000-03-31 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2002-03-31 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2003-03-31 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2004-12-08 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-12-01 00:00:00		2006-12-31 00:00:00		2007-03-31 00:00:00		1900-01-01 00:00:00		2007-06-30 00:00:00		2007-12-31 00:00:00		2007-09-30 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		2013-06-30 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-06-30 00:00:00		2008-09-30 00:00:00		2008-06-30 00:00:00		2008-12-30 00:00:00		2008-12-31 00:00:00		2008-12-30 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		1900-01-01 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2009-03-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		1900-01-01 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2014-03-31 00:00:00		2015-06-30 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		1900-01-01 00:00:00		2019-03-31 00:00:00		2018-09-30 00:00:00		2019-09-30 00:00:00		2017-09-30 00:00:00		2018-06-30 00:00:00		2018-06-30 00:00:00		2016-03-31 00:00:00		2015-12-31 00:00:00		2016-06-30 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-03-31 00:00:00		2019-12-31 00:00:00		2019-06-30 00:00:00		2017-12-31 00:00:00		2018-12-31 00:00:00		2020-06-30 00:00:00		2020-03-31 00:00:00		2021-12-31 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		2020-09-30 00:00:00		1900-01-01 00:00:00		2021-06-30 00:00:00		2021-03-31 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2021-09-30 00:00:00		2022-03-31 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22006		22006		22006		22001		None		None		22006		None		None		22006		22006		None		None		22006		22006		22006		22006		22001		None		22006		None		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22001		22001		22001		22001		22001		22001		22006		None		22001		22001		22001		22001		22001		22006		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22006		22001		22006		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001

Table: filer_interests

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

Table: filer_to_filer_type

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

Table: filer_xref

filer_id		1143649
xref_id		C23747
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747		C23747
filer_id		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649
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
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
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
naml		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY ASSOCIATION		CALIFORNIA RICE INDUSTRY 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
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
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
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
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
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
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
zip4		95825		95825		95825		95826		95826		95826		95826		95814		95814		95814		95814		95814		95814		95814		95825		95825		95825		95826		95826		95826		95826		95814		95814		95814		95814		95814		95814		95814		95825		95825		95825		95826		95826		95826		95826		95814		95814		95814		95814		95814		95814		95814		95825		95825		95825		95826		95826		95826		95826		95814		95814		95814		95814		95814		95814		95814		95825		95825		95825		95826		95826		95826		95826		95814		95814		95814		95814		95814		95814		95814		95825		95825		95825		95826		95826		95826		95826		95814		95814		95814		95814		95814		95814		95814		95825		95825		95825		95826		95826		95826		95826		95814		95814		95814		95814		95814		95814		95814		95825		95825		95825		95826		95826		95826		95826		95814		95814		95814		95814		95814		95814		95814		95825		95825		95825		95826		95826		95826		95826		95814		95814		95814		95814		95814		95814		95814		95825		95825		95825		95826		95826		95826		95826		95814		95814		95814		95814		95814		95814		95814		95825		95825		95825		95826		95826		95826		95826		95814		95814		95814		95814		95814		95814		95814		95825		95825		95825		95826		95826		95826		95826		95814		95814		95814		95814		95814		95814		95814
phon		9169292264		9169292264		9169292264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9169292264		9169292264		9169292264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9169292264		9169292264		9169292264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9169292264		9169292264		9169292264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9169292264		9169292264		9169292264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9169292264		9169292264		9169292264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9169292264		9169292264		9169292264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9169292264		9169292264		9169292264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9169292264		9169292264		9169292264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9169292264		9169292264		9169292264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9169292264		9169292264		9169292264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9169292264		9169292264		9169292264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264		9163872264
fax		None		None		9169292553				9163872265																				None		None		9169292553				9163872265																				None		None		9169292553				9163872265																				None		None		9169292553				9163872265																				None		None		9169292553				9163872265																				None		None		9169292553				9163872265																				None		None		9169292553				9163872265																				None		None		9169292553				9163872265																				None		None		9169292553				9163872265																				None		None		9169292553				9163872265																				None		None		9169292553				9163872265																				None		None		9169292553				9163872265
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1143649

Table: lobbying_chg_log

filer_id		1143649
change_no		1
session_id		2021
log_dt		2020-12-18 00:00:00
filer_type		1
correction_flg		None
action		CHANGED
attribute_changed		RESPONSIBLE OFFICER
ethics_dt		None
interests		None
filer_full_name		CALIFORNIA RICE INDUSTRY ASSOCIATION
filer_city		None
filer_st		None
filer_zip		None
filer_phone		None
entity_type		20
entity_name		PRESIDENT/CHIEF EXECUTIVE OFFICER TIMOTHY A. JOHNSON
entity_city		None
entity_st		None
entity_zip		None
entity_phone		None
entity_id		1274160
responsible_officer		None
effect_dt		2021-01-01 00:00:00

Table: lobbyist_contributions1

filer_id		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649
filing_period_start_dt		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00
filing_period_end_dt		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00
contribution_dt		None		None		None		None		None		None		None		None		None		None		None
recipient_name		BRULTE FRIENDS OF JIM		HERTZBERG FRIENDS OF BOB		AANESTAD FOR ASSEMBLY		LESLIE FOR ASSEMBLY TIM		CARDOZA FRIENDS OF DENNIS		REYES FRIENDS OF SARAH		DICKERSON FOR ASSEMBLY		THOMSON FOR ASSEMBLY HELEN		DICKERSON FOR ASSEMBLY		COX-ASSEMBLY 2000 TAXPAYERS FOR DAVE		WAYNE FOR STATE ASSEMBLY HOWARD
recipient_id		1069427		1069827		1054939		1075853		1069846		1072108		1071717		1065177		1071717		1069205		1069933
amount		1000		1000		500		500		1000		500		1000		1000		500		500		1000

Table: lobbyist_contributions2

filer_id		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649
filing_period_start_dt		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00
filing_period_end_dt		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00
contribution_dt		None		None		None		None		None		None		None		None		None		None		None
recipient_name		BRULTE FRIENDS OF JIM		HERTZBERG FRIENDS OF BOB		AANESTAD FOR ASSEMBLY		LESLIE FOR ASSEMBLY TIM		CARDOZA FRIENDS OF DENNIS		REYES FRIENDS OF SARAH		DICKERSON FOR ASSEMBLY		THOMSON FOR ASSEMBLY HELEN		DICKERSON FOR ASSEMBLY		COX-ASSEMBLY 2000 TAXPAYERS FOR DAVE		WAYNE FOR STATE ASSEMBLY HOWARD
recipient_id		1069427		1069827		1054939		1075853		1069846		1072108		1071717		1065177		1071717		1069205		1069933
amount		1000		1000		500		500		1000		500		1000		1000		500		500		1000

Table: received_filings

filer_id		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649		1143649
filing_file_name		29636.cal		717964_0.cal		746500_0.cal		772884_0.cal		789045_0.cal		789045_1.cal		93304.cal		814201_0.cal		840143_0.cal		853939_0.cal		884574_0.cal		928361_0.cal		911833_0.cal		943230_0.cal		928361_1.cal		965836_0.cal		1328047_0.cal		1502948_0.cal		1392241_0.cal		1418837_0.cal		1346509_0.cal		1458499_0.cal		1448785_0.cal		1482098_0.cal		1392241_1.cal		1432319_0.cal		1373246_0.cal		1673765_0.cal		1842033_0.cal		1732199_0.cal		114576.cal		1781153_0.cal		113041.cal		1534905_0.cal		1703864_0.cal		1564071_0.cal		1813937_0.cal		1618587_0.cal		431104.cal		1605008_0.cal		1797280_0.cal		1764246_0.cal		1618587_1.cal		430333.cal		1654834_0.cal		1867009_0.cal		1977414_1.cal		1977414_0.cal		2126203_0.cal		2155108_0.cal		2059724_0.cal		1994545_0.cal		2009722_0.cal		2100446_0.cal		1905796_0.cal		1929348_0.cal		2033468_0.cal		1977414_2.cal		1962906_0.cal		2171509_0.cal		2395608_0.cal		2310056_0.cal		466114.cal		2268827_0.cal		2268827_1.cal		2189676_0.cal		2239933_0.cal		2436275_0.cal		2378082_0.cal		466354.cal		2481607_0.cal		2344364_0.cal		2467643_0.cal		2415885_0.cal		2640572_0.cal		2619013_0.cal		2547743_0.cal		2576611_0.cal		2671785_0.cal		2746367_0.cal		2619013_1.cal		2598423_0.cal		2703464_0.cal		2746367_1.cal		2640572_1.cal		2524511_0.cal
received_date		2001-01-31 00:00:00		2001-01-31 00:00:00		2001-04-30 00:00:00		2001-07-31 00:00:00		2001-10-24 00:00:00		2001-11-20 00:00:00		2001-10-31 00:00:00		2002-01-31 00:00:00		2002-04-30 00:00:00		2002-07-30 00:00:00		2002-10-31 00:00:00		2003-04-22 00:00:00		2003-01-31 00:00:00		2003-07-21 00:00:00		2003-04-22 00:00:00		2003-10-21 00:00:00		2008-04-29 00:00:00		2010-07-25 00:00:00		2009-01-26 00:00:00		2009-04-24 00:00:00		2008-07-28 00:00:00		2010-01-19 00:00:00		2009-10-21 00:00:00		2010-04-25 00:00:00		2009-05-13 00:00:00		2009-07-21 00:00:00		2008-10-28 00:00:00		2012-07-23 00:00:00		2014-04-27 00:00:00		2013-01-25 00:00:00		2013-07-30 00:00:00		2013-07-30 00:00:00		2013-07-30 00:00:00		2010-10-25 00:00:00		2012-10-25 00:00:00		2011-01-23 00:00:00		2014-01-27 00:00:00		2011-10-20 00:00:00		2012-01-24 00:00:00		2011-07-27 00:00:00		2013-10-25 00:00:00		2013-04-29 00:00:00		2011-11-02 00:00:00		2012-01-24 00:00:00		2012-04-25 00:00:00		2014-07-26 00:00:00		2015-08-02 00:00:00		2015-07-26 00:00:00		2017-01-28 00:00:00		2017-04-27 00:00:00		2016-07-27 00:00:00		2015-10-26 00:00:00		2016-01-28 00:00:00		2016-10-30 00:00:00		2014-10-25 00:00:00		2015-01-24 00:00:00		2016-04-27 00:00:00		2015-08-15 00:00:00		2015-04-27 00:00:00		2017-07-25 00:00:00		2019-07-29 00:00:00		2018-10-22 00:00:00		2018-01-27 00:00:00		2018-07-24 00:00:00		2018-08-17 00:00:00		2017-10-23 00:00:00		2018-04-27 00:00:00		2020-01-27 00:00:00		2019-04-27 00:00:00		2018-01-27 00:00:00		2020-07-27 00:00:00		2019-01-29 00:00:00		2020-04-26 00:00:00		2019-10-26 00:00:00		2022-01-28 00:00:00		2021-10-25 00:00:00		2021-01-26 00:00:00		2021-04-25 00:00:00		2022-04-27 00:00:00		2022-10-29 00:00:00		2021-11-06 00:00:00		2021-07-28 00:00:00		2022-07-28 00:00:00		2022-11-06 00:00:00		2022-02-25 00:00:00		2020-10-27 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/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		None		717964		746500		772884		789045		789045		None		814201		840143		853939		884574		928361		911833		943230		928361		965836		1328047		1502948		1392241		1418837		1346509		1458499		1448785		1482098		1392241		1432319		1373246		1673765		1842033		1732199		None		1781153		None		1534905		1703864		1564071		1813937		1618587		None		1605008		1797280		1764246		1618587		None		1654834		1867009		1977414		1977414		2126203		2155108		2059724		1994545		2009722		2100446		1905796		1929348		2033468		1977414		1962906		2171509		2395608		2310056		None		2268827		2268827		2189676		2239933		2436275		2378082		None		2481607		2344364		2467643		2415885		2640572		2619013		2547743		2576611		2671785		2746367		2619013		2598423		2703464		2746367		2640572		2524511
form_id		None		F635		F635		F635		F635		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		F635		None		F635		F635		F635		F635		F635		None		F635		F635		F635		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		F635		F635		F635		F635		F635		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
receive_comment		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		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 did not pass validation		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted