Home

Filer ID: 1143055

Table: filer_acronyms

acronym		CALCIMA
filer_id		1143055

Table: filer_address

filer_id		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055
adrid		1107344		2001642		2044317		2081661		2120181		2112079		2159101		2168982		2203179		2526771		2412982		2545110		2545111		2507300		2260997		2465783		2338791
effect_dt		1999-01-01 00:00:00		1999-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2021-11-15 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2021-01-01 00:00:00		2013-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7082		7051		7051		7082		7051		7051		7082		7051		7051		7051		7051		7082		7051		7051		7051		7051
session_id		1999		1999		2003		2005		2007		2007		2009		2009		2011		2021		2017		2023		2023		2021		2013		2019		2015

Table: filer_filings

filer_id		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055
filing_id		468504		469418		479646		472313		474044		466971		484091		497837		477876		490570		494232		487717		480524		474944		483401		487717		464288		486929		491434		495115		474944		468504		620036		638988		631570		664065		709305		694284		719830		701296		730046		770305		756245		775722		777671		821217		797252		812133		801591		801597		835906		850743		841476		854495		893313		880959		903821		850743		902495		924810		928172		925081		943956		936153		967427		954521		938671		975808		975993		983451		1011863		1016902		1026015		1028913		997319		1026015		1048672		1068503		1065999		1074785		1069282		1093486		1093882		1101810		1112696		1144158		1128238		1162525		1183907		1203961		1230417		1183907		1223115		1250656		1271268		1264267		1267911		1279174		1262702		1292232		1778678		1963489		1975934		1716523		1865161		1795913		1948597		1906008		1302640		1323222		1342642		1345921		1341447		1374086		1386449		1387402		1425617		1421061		1435443		1396509		1374086		1396509		1417768		1412854		1450352		1461433		1421061		1481694		1488384		1487540		1421061		1503754		1538404		1568741		1567593		1569071		1557590		1553490		1604509		1589420		1629673		1618513		1654037		1654037		1672378		1813693		1930762		1932048		1918741		1924671		1716523		1717941		1707372		1857514		1721912		1736363		1840978		1751525		1762687		1918741		1992662		1989211		1989245		2524373		2328522		2241964		2436404		2343488		2335262		2005037		1988557		2017483		1918741		2032390		2058468		2090868		2114235		2111177		2120512		2115908		2151907		2125172		2169333		2268866		2376803		2331320		2391549		2205819		2479785		2310647		2189559		2537861		2537849		2467743		2335656		2413636		2328522		2534382		2547760		2672596		2596766		2579275		2623808		2537849		2638702		2573253		2629912		2706270		2749021
period_id		157		142		159		150		158		149		145		156		151		154		155		146		144		143		152		146		141		153		147		148		143		157		160		None		161		162		None		163		None		None		164		165		165		None		None		None		None		168		166		167		169		170		None		170		None		171		172		170		None		None		173		None		174		None		171		None		None		None		None		176		177		None		178		178		None		178		179		180		None		180		None		None		None		181		182		184		183		185		186		187		188		186		188		None		None		None		None		190		189		191		214		221		222		218		218		215		None		219		192		193		None		194		None		195		196		196		None		197		198		196		195		196		None		None		199		200		197		201		None		202		197		202		203		None		204		205		205		None		206		205		208		207		209		209		210		216		220		221		220		None		212		None		211		None		212		212		217		None		213		223		223		None		None		243		244		233		240		None		236		224		223		None		225		225		226		227		None		228		228		228		229		None		230		234		237		236		238		232		242		235		231		244		244		241		None		239		236		None		244		249		246		245		247		248		248		None		None		250		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F635		F635		F635		F635		F690		F690		F635		F602		F635		F635		F602		F635		F602		F602		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F690		F635		F635		F635		F635		F602		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		F602		F605		F602		F602		F635		F635		F635		F635		F635		F635		F603		F635		F635		F602		F635		F635		F635		F603		F635		F605		F635		F603		F602		F603		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F602		F602		F635		F635		F635		F603		F635		F603		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F603		F603		F603		F603		F635		F605		F602		F635		F635		F602		F635		F603		F635		F602		F605		F635		F603		F635		F635		F602		F635		F635		F602		F605		F603		F635		F635		F635		F603		F603		F635		F602		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F635		F602		F603		F635		F603		F635		F603		F605		F635		F635		F635		F635		F635		F603		F635		F603		F605		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		0		0		2		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		1		0		0		0		0		0		0		0		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0
filing_date		1999-04-29 00:00:00		1995-07-31 00:00:00		1999-11-01 00:00:00		1997-07-25 00:00:00		1999-07-29 00:00:00		1997-04-28 00:00:00		1996-04-30 00:00:00		1999-02-01 00:00:00		1997-10-27 00:00:00		1998-07-31 00:00:00		1998-11-02 00:00:00		1996-07-26 00:00:00		1996-01-31 00:00:00		1995-10-31 00:00:00		1998-02-02 00:00:00		1996-07-29 00:00:00		1995-05-01 00:00:00		1998-04-30 00:00:00		1996-10-28 00:00:00		1997-01-27 00:00:00		1996-04-29 00:00:00		1999-04-30 00:00:00		2000-01-29 00:00:00		2000-06-01 00:00:00		2000-05-01 00:00:00		2000-07-31 00:00:00		2000-12-22 00:00:00		2000-10-31 00:00:00		2001-01-04 00:00:00		2000-12-21 00:00:00		2001-01-26 00:00:00		2001-04-30 00:00:00		2001-04-30 00:00:00		2001-07-25 00:00:00		2001-07-31 00:00:00		2002-01-29 00:00:00		2001-10-26 00:00:00		2002-01-29 00:00:00		2001-12-20 00:00:00		2001-12-20 00:00:00		2002-04-18 00:00:00		2002-07-22 00:00:00		2002-04-29 00:00:00		2002-07-25 00:00:00		2002-10-28 00:00:00		2002-10-28 00:00:00		2003-01-21 00:00:00		2003-02-14 00:00:00		2002-12-27 00:00:00		2003-01-23 00:00:00		2003-04-21 00:00:00		2003-02-18 00:00:00		2003-07-24 00:00:00		2003-04-23 00:00:00		2003-10-27 00:00:00		2003-07-28 00:00:00		2003-06-09 00:00:00		2003-12-29 00:00:00		2003-10-29 00:00:00		2004-01-20 00:00:00		2004-04-28 00:00:00		2004-04-29 00:00:00		2004-07-27 00:00:00		2004-07-28 00:00:00		2004-01-23 00:00:00		2004-10-18 00:00:00		2004-10-18 00:00:00		2004-12-29 00:00:00		2004-10-21 00:00:00		2005-01-24 00:00:00		2004-10-21 00:00:00		2004-12-29 00:00:00		2005-01-27 00:00:00		2005-04-21 00:00:00		2005-07-19 00:00:00		2006-01-25 00:00:00		2005-10-17 00:00:00		2006-04-17 00:00:00		2006-07-13 00:00:00		2006-10-04 00:00:00		2007-01-23 00:00:00		2006-11-20 00:00:00		2006-12-07 00:00:00		2007-01-02 00:00:00		2007-05-31 00:00:00		2007-05-01 00:00:00		2007-04-05 00:00:00		2007-07-23 00:00:00		2007-05-01 00:00:00		2007-10-09 00:00:00		2013-07-26 00:00:00		2015-04-28 00:00:00		2015-07-22 00:00:00		2014-05-28 00:00:00		2014-07-22 00:00:00		2013-10-21 00:00:00		2015-01-05 00:00:00		2014-10-27 00:00:00		2008-01-08 00:00:00		2008-04-04 00:00:00		2008-07-09 00:00:00		2008-07-24 00:00:00		2008-06-23 00:00:00		2008-10-28 00:00:00		2008-12-30 00:00:00		2009-01-05 00:00:00		2009-05-12 00:00:00		2009-04-30 00:00:00		2009-07-29 00:00:00		2009-01-31 00:00:00		2009-04-03 00:00:00		2009-04-03 00:00:00		2009-01-12 00:00:00		2009-01-06 00:00:00		2009-10-27 00:00:00		2010-01-27 00:00:00		2010-03-23 00:00:00		2010-04-23 00:00:00		2010-05-10 00:00:00		2010-05-13 00:00:00		2010-03-23 00:00:00		2010-07-27 00:00:00		2010-10-29 00:00:00		2011-01-27 00:00:00		2011-01-27 00:00:00		2011-01-28 00:00:00		2011-01-06 00:00:00		2010-12-21 00:00:00		2011-07-27 00:00:00		2011-04-28 00:00:00		2012-01-19 00:00:00		2011-10-20 00:00:00		2012-04-24 00:00:00		2012-05-01 00:00:00		2012-07-18 00:00:00		2014-01-27 00:00:00		2015-01-27 00:00:00		2015-01-28 00:00:00		2014-12-17 00:00:00		2014-12-18 00:00:00		2012-12-07 00:00:00		2012-12-11 00:00:00		2012-10-30 00:00:00		2014-05-28 00:00:00		2012-12-31 00:00:00		2013-01-30 00:00:00		2014-04-24 00:00:00		2013-01-02 00:00:00		2013-04-26 00:00:00		2015-09-11 00:00:00		2015-10-20 00:00:00		2015-09-11 00:00:00		2015-09-14 00:00:00		2020-10-27 00:00:00		2020-10-27 00:00:00		2018-04-30 00:00:00		2020-01-27 00:00:00		2018-12-21 00:00:00		2019-01-17 00:00:00		2016-01-20 00:00:00		2015-09-11 00:00:00		2016-01-25 00:00:00		2016-01-25 00:00:00		2016-04-26 00:00:00		2016-07-26 00:00:00		2016-10-18 00:00:00		2016-12-19 00:00:00		2016-12-15 00:00:00		2017-01-18 00:00:00		2016-12-30 00:00:00		2017-04-19 00:00:00		2016-12-19 00:00:00		2017-07-21 00:00:00		2018-07-25 00:00:00		2019-04-24 00:00:00		2018-12-31 00:00:00		2019-07-21 00:00:00		2018-01-26 00:00:00		2020-07-22 00:00:00		2018-10-23 00:00:00		2017-10-23 00:00:00		2020-12-22 00:00:00		2020-12-22 00:00:00		2020-04-27 00:00:00		2018-12-17 00:00:00		2019-10-18 00:00:00		2018-12-18 00:00:00		2020-10-30 00:00:00		2021-01-26 00:00:00		2022-04-28 00:00:00		2021-07-26 00:00:00		2021-04-29 00:00:00		2021-11-01 00:00:00		2021-11-15 00:00:00		2022-01-27 00:00:00		2020-12-29 00:00:00		2021-11-17 00:00:00		2022-08-01 00:00:00		2022-10-31 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10005		10005		10005		10005		10005		10001		10001		10001		10001		10001		10005		10005		10005		10001		10001		10002		10005		10005		10001		10006		10001		10005		10001		10005		10005		10005		10005		10001		10001		10005		10001		10005		10005		10002		10001		10001		10005		10001		10006		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10002		10001		10005		10005		10005		10005		10001		10001		10001		10001		10001		10001		10002		10001		10001		10005		10001		10001		10001		10005		10001		10005		10001		10001		10001		10005		10001		10001		10001		10002		10002		10001		10005		10001		10001		10002		10001		10005		10001		10002		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10005		10001		10005		10001		10006		10001		10001		10001		10005		10001		10002		10001		10005		10006		10001		10002		10001		10001		10001		10001		10001		10001		10005		10002		10001		10001		10001		10005		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10002		10001		10001		10001		10001		10001		10002		10001		10005		10002		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11001		11001		11003		11001		11003		11001		11003		11003		11001		11003		11001		11003		11003		11001		11003		11001		11001		11003		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11003		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		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003
session_id		1999		1995		1999		1997		1999		1997		1995		1997		1997		1997		1997		1995		1995		1995		1997		1995		1995		1997		1995		1995		1995		1999		1999		1999		1999		1999		2001		1999		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2003		2005		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2007		2005		2007		2007		2007		2013		2015		2015		2013		2013		2013		2015		2013		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2015		2015		2015		2013		2013		2011		2013		2013		2011		2013		2013		2013		2015		2015		2015		2015		2019		2019		2017		2019		2019		2017		2015		2015		2015		2015		2015		2015		2015		2017		2017		2015		2017		2017		2017		2017		2017		2019		2019		2019		2017		2019		2017		2017		2021		2021		2019		2019		2019		2019		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		GPEREZ		TTHAM		YBONILLA		SARRIAGA		YBONILLA		NJACKSON		NJACKSON		YBONILLA		MHOANG		YBONILLA		SARRIAGA		YBONILLA		LTHIBAUL		LTHIBAUL		*		DHORRELL		DHORRELL		*		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		COMPLETED		COMPLETED		PBANFORD		LTHIBAUL		COMPLETED		LTHIBAUL		COMPLETED		LTHIBAUL		COMPLETED		MHOANG		SARRIAGA		GGILMORE		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		EMCENTEE		SARRIAGA		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		DMCCASTL		DMCCASTL		DMCCASTL		DMCCASTL		CFLAGG		LTHIBAUL		LTHIBAUL		LTHIBAUL		AGLADNEY		AGLADNEY		AGLADNEY		CAFILER		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		CFLAGG		JINGRAM		*		*		YRODRIGU		MGUERRA		MGUERRA		JINGRAM		JINGRAM		JINGRAM		DMCCASTL		YRODRIGU		MGUERRA		WBROWN		JINGRAM		ASAETERN		YRODRIGU		YRODRIGU		JINGRAM		ASAETERN		ASAETERN		CPON		AGLADNEY		YRODRIGU		YRODRIGU		CPON		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU		GKURIMOT		GKURIMOT		GPEREZ		ASAETERN		SMCCONNAN		CAFILER		ASAETERN		AOCHOA		SARRIAGA		ASAETERN		YRODRIGU		MPACHECO		YRODRIGU		YRODRIGU		GTAYLOR		CAFILER		AGLADNEY		GTAYLOR		YRODRIGU		AGLADNEY		AGLADNEY		YRODRIGU		GPEREZ		CAFILER		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		CAFILER		AGLADNEY		PBANFORD		AGLADNEY		PBANFORD		AGLADNEY		AGLADNEY		GTAYLOR		YRODRIGU		VUKSTINA		AGLADNEY		MKIRKHAM		AGLADNEY		AGLADNEY		SARRIAGA		SARRIAGA		GTAYLOR		PBANFORD		VUKSTINA		PBANFORD		AROJAS		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		MKIRKHAM		JMENDOZA		CHATRIDGE		SARRIAGA		JMENDOZA		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11003		11003		11003		11003		11003		11003		11002		11002		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		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		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		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11003		11001		11003		11003		11003		11003
rpt_start		1999-01-01 00:00:00		1995-04-01 00:00:00		1999-07-01 00:00:00		1997-04-01 00:00:00		1999-04-01 00:00:00		1997-01-01 00:00:00		1996-01-01 00:00:00		1998-10-01 00:00:00		1997-07-01 00:00:00		1998-04-01 00:00:00		1998-07-01 00:00:00		1996-04-01 00:00:00		1995-10-01 00:00:00		1995-07-01 00:00:00		1997-10-01 00:00:00		1996-04-01 00:00:00		1995-01-01 00:00:00		1998-01-01 00:00:00		1996-07-01 00:00:00		1996-10-01 00:00:00		1995-07-01 00:00:00		1999-01-01 00:00:00		1999-10-01 00:00:00		None		2000-01-01 00:00:00		2000-04-01 00:00:00		1900-01-01 00:00:00		2000-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2000-10-01 00:00:00		None		2001-01-01 00:00:00		1900-01-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-04-01 00:00:00		1900-01-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2002-04-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-04-01 00:00:00		1900-01-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-04-01 00:00:00		2003-10-01 00:00:00		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-12-28 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-04-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		2005-10-01 00:00:00		2005-07-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		2006-04-01 00:00:00		2006-12-07 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-04-01 00:00:00		2007-01-01 00:00:00		2007-07-01 00:00:00		2013-04-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2014-05-27 00:00:00		2014-04-01 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2007-10-01 00:00:00		2008-01-01 00:00:00		1900-01-01 00:00:00		2008-04-01 00:00:00		1900-01-01 00:00:00		2008-07-01 00:00:00		2008-12-30 00:00:00		2008-12-03 00:00:00		1900-01-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2008-10-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		1900-01-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		1900-01-01 00:00:00		2010-05-13 00:00:00		2009-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2011-01-27 00:00:00		2011-01-06 00:00:00		1900-01-01 00:00:00		2011-04-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2012-01-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		2015-01-28 00:00:00		2014-12-17 00:00:00		1900-01-01 00:00:00		2012-11-12 00:00:00		1900-01-01 00:00:00		2012-07-01 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		2015-09-11 00:00:00		2015-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-07-01 00:00:00		2020-10-26 00:00:00		2018-01-01 00:00:00		2019-10-01 00:00:00		1900-01-01 00:00:00		2018-10-01 00:00:00		2015-10-01 00:00:00		2015-09-09 00:00:00		1900-01-01 00:00:00		2016-01-21 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		1900-01-01 00:00:00		2016-11-02 00:00:00		2016-10-01 00:00:00		2016-12-30 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2018-04-01 00:00:00		2019-01-01 00:00:00		2018-12-31 00:00:00		2019-04-01 00:00:00		2017-10-01 00:00:00		2020-04-01 00:00:00		2018-07-01 00:00:00		2017-07-01 00:00:00		2020-11-12 00:00:00		2020-12-09 00:00:00		2020-01-01 00:00:00		1900-01-01 00:00:00		2019-07-01 00:00:00		2018-12-18 00:00:00		1900-01-01 00:00:00		2020-10-01 00:00:00		2022-01-01 00:00:00		2021-04-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-11-15 00:00:00		2021-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2022-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		1999-03-31 00:00:00		1995-06-30 00:00:00		1999-09-30 00:00:00		1997-06-30 00:00:00		1999-06-30 00:00:00		1997-03-31 00:00:00		1996-03-31 00:00:00		1998-12-31 00:00:00		1997-09-30 00:00:00		1998-06-30 00:00:00		1998-09-30 00:00:00		1996-06-30 00:00:00		1995-12-31 00:00:00		1995-09-30 00:00:00		1997-12-31 00:00:00		1996-06-30 00:00:00		1995-03-31 00:00:00		1998-03-31 00:00:00		1996-09-30 00:00:00		1996-12-31 00:00:00		1995-09-30 00:00:00		1999-03-31 00:00:00		1999-12-31 00:00:00		None		2000-03-31 00:00:00		2000-06-30 00:00:00		1900-01-01 00:00:00		2000-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2000-12-31 00:00:00		None		2001-03-31 00:00:00		1900-01-01 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2002-06-30 00:00:00		1900-01-01 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2002-06-30 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2002-09-30 00:00:00		2003-06-30 00:00:00		1900-01-01 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2004-03-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-12-28 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-06-30 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-09-30 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		2006-06-30 00:00:00		2006-12-07 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-06-30 00:00:00		2007-03-31 00:00:00		2007-09-30 00:00:00		2013-06-30 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2014-05-27 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2007-12-31 00:00:00		2008-03-31 00:00:00		1900-01-01 00:00:00		2008-06-30 00:00:00		1900-01-01 00:00:00		2008-09-30 00:00:00		2008-12-30 00:00:00		2008-12-03 00:00:00		1900-01-01 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2008-12-31 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		1900-01-01 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		1900-01-01 00:00:00		2010-05-13 00:00:00		2009-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2011-01-27 00:00:00		2011-01-06 00:00:00		1900-01-01 00:00:00		2011-06-30 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2012-03-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		2015-01-28 00:00:00		2014-12-17 00:00:00		1900-01-01 00:00:00		2012-11-12 00:00:00		1900-01-01 00:00:00		2012-09-30 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		2015-09-11 00:00:00		2015-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-09-30 00:00:00		2020-10-26 00:00:00		2018-03-31 00:00:00		2019-12-31 00:00:00		1900-01-01 00:00:00		2018-12-31 00:00:00		2015-12-31 00:00:00		2015-09-09 00:00:00		1900-01-01 00:00:00		2016-01-21 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		1900-01-01 00:00:00		2016-11-02 00:00:00		2016-12-31 00:00:00		2016-12-30 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2018-06-30 00:00:00		2019-03-31 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2017-12-31 00:00:00		2020-06-30 00:00:00		2018-09-30 00:00:00		2017-09-30 00:00:00		2020-11-12 00:00:00		2020-12-09 00:00:00		2020-03-31 00:00:00		1900-01-01 00:00:00		2019-09-30 00:00:00		2018-12-18 00:00:00		1900-01-01 00:00:00		2020-12-31 00:00:00		2022-03-31 00:00:00		2021-06-30 00:00:00		2021-03-31 00:00:00		2021-09-30 00:00:00		2021-11-15 00:00:00		2021-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2022-06-30 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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		22001		22001		None		None		22001		None		22001		None		22001		None		None		None		None		22001		22001		None		22001		None		None		22001		22001		22001		None		22001		None		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22006		None		None		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22006		None		22006		22006		22001		None		22001		22001		22006		22006		22006		None		None		22001		22001		22001		22001		None		22006		22001		22001		22001		None		22001		22001		22006		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22006		22001		None		22001		None		22001		None		22006		22001		22001		None		22001		22001		22001		None		None		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22006		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001

Table: filer_interests

filer_id		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055
session_id		1999		1995		1997		2003		2001		2009		2005		2007		2007		2011		2013		2017		2019		2015		2021		2023
interest_cd		40310		40310		40310		40315		40310		40315		40315		40312		40315		40312		40312		40312		40312		40312		40312		40312
effect_date		1999-01-01 00:00:00		1995-01-01 00:00:00		1997-01-01 00:00:00		2003-01-01 00:00:00		2001-01-01 00:00:00		2009-01-01 00:00:00		2005-01-01 00:00:00		2008-07-09 00:00:00		2007-01-01 00:00:00		2011-01-01 00:00:00		2013-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		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055
filer_type		1		1		1		1		1		1		2		1		2		2		2		2		2		2		2		2
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		0		None		None		None		0		None		0		0		None		None		None		None		None
session_id		1999		1995		1997		2001		2003		2005		2013		2007		2011		2007		2009		2021		2015		2017		2019		2023
category		0		0		0		0		None		None		None		0		None		0		0		None		None		None		None		None
category_type		0		0		0		0		None		None		None		0		None		0		0		None		None		None		None		None
sub_category		0		0		0		0		None		None		None		0		None		0		0		None		None		None		None		None
effect_dt		1999-01-01 00:00:00		1995-01-01 00:00:00		1997-01-01 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2013-01-01 00:00:00		2007-01-01 00:00:00		2011-01-01 00:00:00		2008-07-09 00:00:00		2009-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		0		None		None		None		0		None		0		0		None		None		None		None		None
election_type		0		0		0		0		None		None		None		0		None		0		0		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		2001-04-01 00:00:00		None		2006-12-07 00:00:00		None		2006-12-07 00:00:00		2006-12-07 00:00:00		None		None		None		None		None
party_cd		0		None		None		0		None		None		None		0		None		0		0		None		None		None		None		None
county_cd		0		None		None		0		None		None		None		0		None		0		0		None		None		None		None		None
district_cd		0		None		None		0		None		None		None		0		None		0		0		None		None		None		None		None

Table: filer_xref

filer_id		1143055
xref_id		C00774
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774		C00774
filer_id		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055
filer_type		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION AND INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS 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		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SOUTH PASADENA
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		CA		CA		CA		CA		CA		CA		CA		CA
zip4		91030		91031		91030		91030		91030		91030		91030		91030		95814		95814		95814		95814		95814		95814		95814		95814		91030		91030		91031		91030		91030		91030		91030		91030		91030		95814		95814		95814		95814		95814		95814		95814		95814		91030		91030		91031		91030		91030		91030		91030		91030		91030		95814		95814		95814		95814		95814		95814		95814		95814		91030		91030		91031		91030		91030		91030		91030		91030		91030		95814		95814		95814		95814		95814		95814		95814		95814		91030		91030		91031		91030		91030		91030		91030		91030		91030		95814		95814		95814		95814		95814		95814		95814		95814		91030		91030		91031		91030		91030		91030		91030		91030		91030		95814		95814		95814		95814		95814		95814		95814		95814		91030		91030		91031		91030		91030		91030		91030		91030		91030		95814		95814		95814		95814		95814		95814		95814		95814		91030		91030		91031		91030		91030		91030		91030		91030		91030		95814		95814		95814		95814		95814		95814		95814		95814		91030		91030		91031		91030		91030		91030		91030		91030		91030		95814		95814		95814		95814		95814		95814		95814		95814		91030		91030		91031		91030		91030		91030		91030		91030		91030		95814		95814		95814		95814		95814		95814		95814		95814		91030		91030		91031		91030		91030		91030		91030		91030		91030		95814		95814		95814		95814		95814		95814		95814		95814		91030		91030		91031		91030		91030		91030		91030		91030		91030		95814		95814		95814		95814		95814		95814		95814		95814		91030
phon		6264413107		None		6264413107		6264413107		6264413107				6264413107				9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000				6264413107		None		6264413107		6264413107		6264413107				6264413107				9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000				6264413107		None		6264413107		6264413107		6264413107				6264413107				9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000				6264413107		None		6264413107		6264413107		6264413107				6264413107				9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000				6264413107		None		6264413107		6264413107		6264413107				6264413107				9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000				6264413107		None		6264413107		6264413107		6264413107				6264413107				9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000				6264413107		None		6264413107		6264413107		6264413107				6264413107				9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000				6264413107		None		6264413107		6264413107		6264413107				6264413107				9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000				6264413107		None		6264413107		6264413107		6264413107				6264413107				9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000				6264413107		None		6264413107		6264413107		6264413107				6264413107				9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000				6264413107		None		6264413107		6264413107		6264413107				6264413107				9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000				6264413107		None		6264413107		6264413107		6264413107				6264413107				9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000		9165541000
fax		6264410649		None		6264410649						None						9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042				6264410649		None		6264410649						None						9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042				6264410649		None		6264410649						None						9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042				6264410649		None		6264410649						None						9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042				6264410649		None		6264410649						None						9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042				6264410649		None		6264410649						None						9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042				6264410649		None		6264410649						None						9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042				6264410649		None		6264410649						None						9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042				6264410649		None		6264410649						None						9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042				6264410649		None		6264410649						None						9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042				6264410649		None		6264410649						None						9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042				6264410649		None		6264410649						None						9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042		9165541042
email		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1143055

Table: lobbying_chg_log

filer_id		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055
change_no		1		2		3		0		4		5		6		10		7		8		9		11		12		13		14		15
session_id		1999		1999		1999		2001		2003		2007		2007		2009		2009		2009		2009		2009		2009		2015		2015		2019
log_dt		2000-06-24 00:00:00		2000-08-08 00:00:00		2000-10-18 00:00:00		2001-08-06 00:00:00		2003-06-09 00:00:00		2008-07-09 00:00:00		2008-07-09 00:00:00		2009-11-24 00:00:00		2009-05-12 00:00:00		2009-05-12 00:00:00		2009-05-12 00:00:00		2010-05-10 00:00:00		2010-08-31 00:00:00		2015-09-11 00:00:00		2016-03-07 00:00:00		2020-10-30 00:00:00
filer_type		1		1		1		1		1		1		2		2		2		2		2		2		2		2		2		2
correction_flg		None		None		None		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		None
action		None		DELETED		SET ACTIVE		ADDED		ADDED		ADDED		ADDED		DELETED		ADDED		ADDED		ADDED		ADDED		DELETED		ADDED		DELETED		CHANGED
attribute_changed		None		CLIENT		CLIENT		EMPLOYER		None		LOBBYIST		LOBBYIST		FIRM		LOBBYIST		LOBBYIST		LOBBYIST		FIRM		FIRM		FIRM		FIRM		RESPONSIBLE OFFICER
ethics_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_full_name		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		SOUTHERN CALIFORNIA READY-MIXED CONCRETE ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION
filer_city		None		None		Kingsburg		None		SOUTH PASADENA		None		SOUTH PASADENA		None		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		SOUTH PASADENA		None		SOUTH PASADENA		None		None
filer_st		None		None		CA		None		CA		None		CA		None		CA		CA		CA		CA		None		CA		None		None
filer_zip		None		None		936319232		None		91030		None		91030		None		91030		91030		91030		91030		None		91031		None		None
filer_phone		None		None		2098972362		None		6264413107		None		6264413107		None		6264413107		6264413107		6264413107		6264413107		None		None		None		None
entity_type		3		3		3		2		3		4		4		3		4		4		4		3		3		3		3		20
entity_name		GUALCO GROUP, THE		WILSON GROUP, THE		GUALCO GROUP, THE		CLINE & DUPLISSEA		BLEDSOE, STEPHEN L.		REA, CHARLES L.		HARPER, ADAM J.		ROSS; RICHARD		HARPER, ADAM J.		BLEDSOE, STEPHEN L.		REA, CHARLES L.		ROSS; RICHARD		GUALCO GROUP, INC.; THE		HIESTAND, APC; FRED J.		HIESTAND, APC; FRED J.		PRESIDENT /CHIEF EXECUTIVE OFFICER ROBERT DUGAN
entity_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_id		1147392		1147264		1147392		1234678		None		0		None		1147680		None		None		None		None		1147392		None		1147247		1434608
responsible_officer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		None		None		None		2001-05-21 00:00:00		2003-04-25 00:00:00		2008-06-13 00:00:00		2008-06-13 00:00:00		2009-12-31 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2010-05-01 00:00:00		2010-08-31 00:00:00		2015-09-09 00:00:00		2015-12-31 00:00:00		2020-07-21 00:00:00

Table: received_filings

filer_id		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055		1143055
filing_file_name		801591_0.cal		56692.cal		801597_0.cal		812133_0.cal		487746.cal		488331.cal		487648.cal		491935.cal		491938.cal		492292.cal		136773.cal		835906_0.cal		850743_0.cal		880959_0.cal		903821_0.cal		928172_0.cal		850743_1.cal		943956_0.cal		967427_0.cal		1461433_0.cal		1450352_0.cal		1481694_0.cal		1421061_1.cal		1421061_2.cal		507652.cal		508565.cal		508827.cal		1435443_0.cal		1421061_0.cal		407043.cal		407013.cal		297838.cal		195699.cal		297749.cal		297729.cal		146469.cal
received_date		2001-12-20 00:00:00		2001-12-20 00:00:00		2001-12-20 00:00:00		2002-01-29 00:00:00		2002-01-29 00:00:00		2002-01-29 00:00:00		2002-01-29 00:00:00		2002-01-29 00:00:00		2002-01-29 00:00:00		2002-01-29 00:00:00		2002-04-18 00:00:00		2002-04-18 00:00:00		2002-07-22 00:00:00		2002-10-28 00:00:00		2003-01-21 00:00:00		2003-04-21 00:00:00		2003-02-14 00:00:00		2003-07-24 00:00:00		2003-10-27 00:00:00		2010-01-27 00:00:00		2009-10-27 00:00:00		2010-04-23 00:00:00		2010-03-23 00:00:00		2010-03-23 00:00:00		2009-05-14 00:00:00		2009-05-14 00:00:00		2009-05-14 00:00:00		2009-07-29 00:00:00		2009-04-30 00:00:00		2011-04-28 00:00:00		2011-04-28 00:00:00		2020-12-22 00:00:00		2022-10-31 00:00:00		2020-12-22 00:00:00		2020-12-22 00:00:00		2022-10-31 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp
filing_id		801591		None		801597		812133		None		None		None		None		None		None		None		835906		850743		880959		903821		928172		850743		943956		967427		1461433		1450352		1481694		1421061		1421061		None		None		None		1435443		1421061		None		None		None		None		None		None		None
form_id		F635		None		F635		F635		None		None		None		None		None		None		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		None		None		F635		F635		None		None		None		None		None		None		None
receive_comment		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing did not pass validation