Home

Filer ID: 1146256

Table: filer_address

filer_id		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256
adrid		1112598		1111728		2041423		2029351		2078333		2114475		2163071		2207733		2415678		2471330		2275981		2510123		2551654		2338816
effect_dt		1999-04-01 00:00:00		1997-01-01 00:00:00		2003-01-01 00:00:00		2002-02-18 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2019-01-16 00:00:00		2013-01-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1999		1997		2003		2001		2005		2007		2009		2011		2017		2019		2013		2021		2023		2015

Table: filer_filings

filer_id		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256
filing_id		478572		473010		633669		620362		660279		674848		696314		762015		477505		482028		470952		476492		486544		465706		466645		493892		541538		483016		471963		490203		838404		828725		862516		853102		843913		881396		893609		914327		896573		931305		944180		911779		946493		968348		988335		974774		956905		999594		1012625		1032825		1017353		1029689		1057533		1091668		1064425		1081129		1092831		1117541		1104313		1131822		1146860		1164182		1188301		1212305		1234303		1260926		1232336		1284274		1783973		1982041		1966161		1800954		1935506		1951564		1912234		1328283		1297366		1311060		1350511		1376804		1409567		1395874		1420525		1437014		1463459		1451614		1484264		1504797		1538245		1570232		1559203		1590828		1605934		1620584		1635021		1656459		1675411		1819183		1708068		1872872		1743843		1737908		1846100		1765110		2004613		1997593		2310597		2233113		2413132		1997593		2036979		2062515		2067560		2101023		2125325		2151732		2140643		2117890		2168321		2388863		2189283		2263943		2202238		2545205		2537796		2478846		2560711		2202238		2189283		2372072		2334229		2390037		2335984		2372812		2659315		2429907		2470335		2675396		2518437		2635394		2573605		2699763		2671965		2617889		2573605		2593884		2733382
period_id		159		158		None		160		162		163		163		164		151		144		142		143		153		141		149		155		156		152		150		154		169		None		None		170		None		171		None		None		None		173		173		172		174		175		176		None		None		None		177		None		None		178		179		None		None		180		None		182		181		183		184		185		186		187		188		189		None		190		214		222		221		215		220		None		219		193		191		192		194		195		None		196		197		198		200		199		201		202		203		204		None		205		206		207		208		209		210		216		211		218		None		212		217		213		224		223		235		233		239		223		225		226		None		227		228		229		None		229		230		None		231		234		232		244		245		242		None		232		231		None		237		238		236		237		None		240		241		249		243		248		245		250		None		247		245		246		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F602		F635		F635		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		F602		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F602		F602		F635		F602		F635		F635		F635		F635		F602		F635		F602		F635		F635		F602		F602		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635
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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0
filing_date		1999-11-03 00:00:00		1999-08-12 00:00:00		2000-05-17 00:00:00		2000-02-07 00:00:00		2000-07-31 00:00:00		2000-10-24 00:00:00		2000-10-23 00:00:00		2001-06-05 00:00:00		1997-10-09 00:00:00		1996-02-02 00:00:00		1995-11-01 00:00:00		1995-11-01 00:00:00		1998-05-05 00:00:00		1995-11-01 00:00:00		1997-05-30 00:00:00		1998-10-28 00:00:00		1999-01-30 00:00:00		1998-02-19 00:00:00		1997-07-31 00:00:00		1998-07-31 00:00:00		2002-04-29 00:00:00		2002-02-26 00:00:00		2002-07-30 00:00:00		2002-07-29 00:00:00		2002-04-30 00:00:00		2002-10-28 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2002-12-09 00:00:00		2003-04-30 00:00:00		2003-07-17 00:00:00		2003-01-31 00:00:00		2003-07-30 00:00:00		2003-10-29 00:00:00		2004-01-29 00:00:00		2003-10-30 00:00:00		2003-07-31 00:00:00		2004-01-29 00:00:00		2004-04-29 00:00:00		2004-07-30 00:00:00		2004-04-29 00:00:00		2004-07-30 00:00:00		2004-10-29 00:00:00		2004-12-16 00:00:00		2004-10-29 00:00:00		2005-01-31 00:00:00		2005-01-31 00:00:00		2005-07-29 00:00:00		2005-04-29 00:00:00		2005-10-27 00:00:00		2006-01-30 00:00:00		2006-04-24 00:00:00		2006-07-27 00:00:00		2006-10-26 00:00:00		2007-01-29 00:00:00		2007-04-27 00:00:00		2006-12-01 00:00:00		2007-07-31 00:00:00		2013-07-31 00:00:00		2015-07-31 00:00:00		2015-04-30 00:00:00		2013-10-31 00:00:00		2015-01-31 00:00:00		2015-01-05 00:00:00		2014-10-31 00:00:00		2008-04-29 00:00:00		2007-10-31 00:00:00		2008-01-31 00:00:00		2008-07-31 00:00:00		2008-10-30 00:00:00		2008-12-15 00:00:00		2009-01-30 00:00:00		2009-04-29 00:00:00		2009-07-30 00:00:00		2010-01-29 00:00:00		2009-10-29 00:00:00		2010-04-29 00:00:00		2010-07-28 00:00:00		2010-10-28 00:00:00		2011-01-31 00:00:00		2010-12-22 00:00:00		2011-04-29 00:00:00		2011-07-28 00:00:00		2011-10-27 00:00:00		2012-01-30 00:00:00		2012-04-28 00:00:00		2012-07-26 00:00:00		2014-01-31 00:00:00		2012-10-30 00:00:00		2014-07-31 00:00:00		2012-12-07 00:00:00		2013-01-30 00:00:00		2014-04-30 00:00:00		2013-04-30 00:00:00		2016-01-19 00:00:00		2015-10-31 00:00:00		2018-10-23 00:00:00		2018-04-19 00:00:00		2019-10-15 00:00:00		2016-03-16 00:00:00		2016-04-30 00:00:00		2016-07-29 00:00:00		2016-08-08 00:00:00		2016-10-31 00:00:00		2017-01-27 00:00:00		2017-04-19 00:00:00		2017-01-09 00:00:00		2017-01-09 00:00:00		2017-07-18 00:00:00		2019-06-04 00:00:00		2017-10-20 00:00:00		2018-07-11 00:00:00		2018-02-07 00:00:00		2021-01-19 00:00:00		2020-12-21 00:00:00		2020-07-16 00:00:00		2020-12-21 00:00:00		2018-01-16 00:00:00		2018-02-07 00:00:00		2019-01-23 00:00:00		2019-01-14 00:00:00		2019-07-15 00:00:00		2019-01-18 00:00:00		2019-04-15 00:00:00		2022-03-04 00:00:00		2020-01-13 00:00:00		2020-04-30 00:00:00		2022-04-30 00:00:00		2020-10-20 00:00:00		2022-01-19 00:00:00		2021-04-12 00:00:00		2022-07-21 00:00:00		2022-04-12 00:00:00		2021-10-21 00:00:00		2021-07-16 00:00:00		2021-07-16 00:00:00		2022-10-14 00:00:00
stmnt_type		10001		10001		10005		10005		10005		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10005		10001		10005		10005		10005		10001		10005		10001		10001		10001		10001		10005		10005		10005		10001		10005		10005		10001		10001		10005		10005		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10002		10001		10001		10005		10001		10001		10001		10005		10001		10001		10005		10001		10001		10002		10001		10001		10001		10005		10001		10002		10005		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10002		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11003		11001		11001		11003		11003		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003
session_id		1999		1999		1999		1999		1999		1999		1999		1999		1997		1995		1995		1995		1997		1995		1997		1997		1997		1997		1997		1997		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2013		2015		2015		2013		2013		2015		2013		2007		2007		2007		2007		2007		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2013		2011		2013		2013		2011		2013		2013		2015		2015		2017		2017		2019		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2019		2017		2017		2017		2019		2021		2019		2021		2017		2017		2019		2019		2019		2017		2019		2021		2019		2019		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		DHORRELL		*		YBONILLA		*		YBONILLA		YBONILLA		DMCCASTL		DMCCASTL		DMCCASTL		DMCCASTL		DMCCASTL		DMCCASTL		DMCCASTL		DMCCASTL		DMCCASTL		DMCCASTL		DMCCASTL		DMCCASTL		*		SARRIAGA		LTHIBAUL		*		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		SARRIAGA		COMPLETED		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		LTHIBAUL		COMPLETED		YBONILLA		LTHIBAUL		COMPLETED		COMPLETED		EMCENTEE		LTHIBAUL		COMPLETED		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		GPEREZ		LTHIBAUL		AGLADNEY		AGLADNEY		MPACHECO		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		LTHIBAUL		LTHIBAUL		LTHIBAUL		YRODRIGU		JGRISSUM		CFLAGG		JGRISSUM		JGRISSUM		JGRISSUM		JINGRAM		MGUERRA		ASAETERN		ASAETERN		ASAETERN		AGLADNEY		DMCCASTL		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		ASAETERN		AOCHOA		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		VUKSTINA		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		PBANFORD		AGLADNEY		SARRIAGA		AGLADNEY		AGLADNEY		AGLADNEY		GTAYLOR		AROJAS		GTAYLOR		AROJAS		AGLADNEY		AGLADNEY		GPEREZ		GPEREZ		SUSHAKOV		AGLADNEY		AGLADNEY		MMERCHANT		VUKSTINA		VUKSTINA		CAFILER		JMAVES		CHATRIDGE		CHARTRIDGE		CAFILER		CVANLIEW		GTAYLOR		CHARTRIDGE		GTAYLOR		CAFILER
special_audit		11001		11001		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		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
fine_audit		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11003
rpt_start		1999-07-01 00:00:00		1999-04-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		1997-07-01 00:00:00		1995-10-01 00:00:00		1995-04-01 00:00:00		1995-07-01 00:00:00		1998-01-01 00:00:00		1995-01-01 00:00:00		1997-01-01 00:00:00		1998-07-01 00:00:00		1998-10-01 00:00:00		1997-10-01 00:00:00		1997-04-01 00:00:00		1998-04-01 00:00:00		2002-01-01 00:00:00		1900-01-01 00:00:00		2002-04-01 00:00:00		2002-04-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		1900-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2002-10-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-04-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		1900-01-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2005-04-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2006-07-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		2013-04-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2013-07-01 00:00:00		2014-10-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		1900-01-01 00:00:00		2008-10-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		1900-01-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2013-10-01 00:00:00		2012-07-01 00:00:00		2014-04-01 00:00:00		1900-01-01 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2015-10-01 00:00:00		2015-07-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2019-07-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		1900-01-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-01-09 00:00:00		2017-04-01 00:00:00		1900-01-01 00:00:00		2017-07-01 00:00:00		2018-04-01 00:00:00		2017-10-01 00:00:00		2020-10-01 00:00:00		2021-02-01 00:00:00		2020-04-01 00:00:00		1900-01-01 00:00:00		2017-10-01 00:00:00		2017-07-01 00:00:00		1900-01-01 00:00:00		2019-01-14 00:00:00		2019-04-01 00:00:00		2018-10-01 00:00:00		2019-01-01 00:00:00		1900-01-01 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		2022-01-01 00:00:00		2020-07-01 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		2022-04-01 00:00:00		1900-01-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2021-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		1999-09-30 00:00:00		1999-06-30 00:00:00		2000-03-31 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		1997-09-30 00:00:00		1995-12-31 00:00:00		1995-06-30 00:00:00		1995-09-30 00:00:00		1998-03-31 00:00:00		1995-03-31 00:00:00		1997-03-31 00:00:00		1998-09-30 00:00:00		1998-12-31 00:00:00		1997-12-31 00:00:00		1997-06-30 00:00:00		1998-06-30 00:00:00		2002-03-31 00:00:00		1900-01-01 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-03-31 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		1900-01-01 00:00:00		2003-03-31 00:00:00		2003-03-31 00:00:00		2002-12-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-06-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		1900-01-01 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-03-31 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2006-09-30 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		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2013-09-30 00:00:00		2014-12-31 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2008-03-31 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		1900-01-01 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-09-30 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2014-06-30 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2013-03-31 00:00:00		2015-12-31 00:00:00		2015-09-30 00:00:00		2018-09-30 00:00:00		2018-03-31 00:00:00		2019-09-30 00:00:00		2015-09-30 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		1900-01-01 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-01-09 00:00:00		2017-06-30 00:00:00		1900-01-01 00:00:00		2017-09-30 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2020-12-31 00:00:00		2021-02-01 00:00:00		2020-06-30 00:00:00		1900-01-01 00:00:00		2017-12-31 00:00:00		2017-09-30 00:00:00		1900-01-01 00:00:00		2019-01-14 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2019-03-31 00:00:00		1900-01-01 00:00:00		2019-12-31 00:00:00		2020-03-31 00:00:00		2022-03-31 00:00:00		2020-09-30 00:00:00		2021-12-31 00:00:00		2021-03-31 00:00:00		2022-06-30 00:00:00		1900-01-01 00:00:00		2021-09-30 00:00:00		2021-03-31 00:00:00		2021-06-30 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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		22001		None		22001		22001		22001		22001		None		None		None		22001		None		None		22001		22001		None		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22006		22001		22001		None		22001		22001		22001		None		22006		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22006		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001

Table: filer_interests

filer_id		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256
session_id		2001		1999		2003		1997		1995		2013		2005		2009		2011		2007		2017		2019		2015		2021		2023
interest_cd		40310		40310		40310		40310		40310		40312		40312		40312		40312		40312		40310		40310		40312		40312		40312
effect_date		2001-01-01 00:00:00		1999-04-01 00:00:00		2003-01-01 00:00:00		1997-01-01 00:00:00		1995-01-01 00:00:00		2013-01-01 00:00:00		2005-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2007-01-01 00:00:00		2017-01-01 00:00:00		2019-01-16 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		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256
filer_type		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
active		Y		N		N		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		None		0		None		None		None		None		None		None		None		None		None		None
session_id		1999		1995		1997		2003		2001		2005		2007		2013		2011		2009		2015		2021		2019		2017		2023
category		0		0		0		None		0		None		None		None		None		None		None		None		None		None		None
category_type		0		0		0		None		0		None		None		None		None		None		None		None		None		None		None
sub_category		0		0		0		None		0		None		None		None		None		None		None		None		None		None		None
effect_dt		1999-04-01 00:00:00		1995-01-01 00:00:00		1997-01-01 00:00:00		2003-01-01 00:00:00		2002-02-18 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2013-01-01 00:00:00		2011-01-01 00:00:00		2009-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2019-01-16 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		None		0		None		None		None		None		None		None		None		None		None		None
election_type		0		0		0		None		0		None		None		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		2000-07-01 00:00:00		2000-07-01 00:00:00		None		None		None		None		None		None		None		None
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		1146256
xref_id		C27806
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806		C27806
filer_id		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256
filer_type		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA SMALL BREWERS ASSOCIATION
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		BERKELEY		BERKELEY		BERKELEY		NEVADA CITY		NEVADA CITY		NEVADA CITY		NEVADA CITY		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814		95814		95814		94705		94705		94705		95959		95959		95959		95959		95818		95814		95814		95814		95814
phon		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260		9164442142		9164448333		5108430410		5108430410		5108430410		4152856363		5302650422		5302650422		5302650422		9162284260		9162284260		9162284260		9162284260		9162284260
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1146256

Table: lobbying_chg_log

filer_id		1146256		1146256		1146256
change_no		0		1		2
session_id		2001		2011		2015
log_dt		2002-02-26 00:00:00		2012-02-28 00:00:00		2016-07-06 00:00:00
filer_type		2		2		1
correction_flg		Y		Y		None
action		ADDED		CHANGED		DELETED
attribute_changed		FIRM		NAME FROM		FIRM
ethics_dt		None		None		None
interests		None		None		None
filer_full_name		CALIFORNIA SMALL BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION		CALIFORNIA CRAFT BREWERS ASSOCIATION
filer_city		None		SACRAMENTO		None
filer_st		None		CA		None
filer_zip		None		95814		None
filer_phone		None		9164448333		None
entity_type		3		2		3
entity_name		NOSSAMAN, GUTHNER, KNOX & ELLIOTT, LLP		CALIFORNIA SMALL BREWERS ASSOCIATION		NOSSAMAN LLP
entity_city		None		None		None
entity_st		None		None		None
entity_zip		None		None		None
entity_phone		None		None		None
entity_id		1147226		None		1147226
responsible_officer		None		None		None
effect_dt		2002-02-18 00:00:00		2012-02-24 00:00:00		2016-06-30 00:00:00

Table: received_filings

filer_id		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256		1146256
filing_file_name		674848_0.cal		838404_0.cal		853102_0.cal		881396_0.cal		911779_0.cal		931305_0.cal		946493_0.cal		968348_0.cal		988335_0.cal		1012625_0.cal		1029689_0.cal		1057533_0.cal		1081129_0.cal		1104313_0.cal		1117541_0.cal		1146860_0.cal		1164182_0.cal		1188301_0.cal		1212305_0.cal		1504797_0.cal		1395874_0.cal		1328283_0.cal		1350511_0.cal		1484264_0.cal		1463459_0.cal		1451614_0.cal		1234303_0.cal		1260926_0.cal		1420525_0.cal		1437014_0.cal		1284274_0.cal		1297366_0.cal		1376804_0.cal		1311060_0.cal		1872872_0.cal		1846100_0.cal		1737908_0.cal		1675411_0.cal		1783973_0.cal		1800954_0.cal		1538245_0.cal		1570232_0.cal		1819183_0.cal		1605934_0.cal		1590828_0.cal		1765110_0.cal		1620584_0.cal		1635021_0.cal		1656459_0.cal		1708068_0.cal		1982041_0.cal		2004613_0.cal		2101023_0.cal		2062515_0.cal		1912234_0.cal		2036979_0.cal		1935506_0.cal
received_date		2000-10-24 00:00:00		2002-04-29 00:00:00		2002-07-29 00:00:00		2002-10-28 00:00:00		2003-01-31 00:00:00		2003-04-30 00:00:00		2003-07-30 00:00:00		2003-10-29 00:00:00		2004-01-29 00:00:00		2004-04-29 00:00:00		2004-07-30 00:00:00		2004-10-29 00:00:00		2005-01-31 00:00:00		2005-04-29 00:00:00		2005-07-29 00:00:00		2006-01-30 00:00:00		2006-04-24 00:00:00		2006-07-27 00:00:00		2006-10-26 00:00:00		2010-07-28 00:00:00		2009-01-30 00:00:00		2008-04-29 00:00:00		2008-07-31 00:00:00		2010-04-29 00:00:00		2010-01-29 00:00:00		2009-10-29 00:00:00		2007-01-29 00:00:00		2007-04-27 00:00:00		2009-04-29 00:00:00		2009-07-30 00:00:00		2007-07-31 00:00:00		2007-10-31 00:00:00		2008-10-30 00:00:00		2008-01-31 00:00:00		2014-07-31 00:00:00		2014-04-30 00:00:00		2013-01-30 00:00:00		2012-07-26 00:00:00		2013-07-31 00:00:00		2013-10-31 00:00:00		2010-10-28 00:00:00		2011-01-31 00:00:00		2014-01-31 00:00:00		2011-07-28 00:00:00		2011-04-29 00:00:00		2013-04-30 00:00:00		2011-10-27 00:00:00		2012-01-30 00:00:00		2012-04-28 00:00:00		2012-10-30 00:00:00		2015-07-31 00:00:00		2016-01-19 00:00:00		2016-10-31 00:00:00		2016-07-29 00:00:00		2014-10-31 00:00:00		2016-04-30 00:00:00		2015-01-31 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		674848		838404		853102		881396		911779		931305		946493		968348		988335		1012625		1029689		1057533		1081129		1104313		1117541		1146860		1164182		1188301		1212305		1504797		1395874		1328283		1350511		1484264		1463459		1451614		1234303		1260926		1420525		1437014		1284274		1297366		1376804		1311060		1872872		1846100		1737908		1675411		1783973		1800954		1538245		1570232		1819183		1605934		1590828		1765110		1620584		1635021		1656459		1708068		1982041		2004613		2101023		2062515		1912234		2036979		1935506
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted