Home

Filer ID: 1029583

Table: filer_address

filer_id		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583
adrid		1027697		2013676		2030119		2141640		2436336		2436335		2496975		2496976		2234225		2234227
effect_dt		2001-01-31 00:00:00		2001-01-31 00:00:00		2002-03-07 00:00:00		2008-07-17 00:00:00		2017-05-25 00:00:00		2017-05-25 00:00:00		2020-03-16 00:00:00		2020-03-16 00:00:00		2012-06-08 00:00:00		2012-06-08 00:00:00
add_type		7082		7051		7082		7051		7082		7051		7051		7082		7082		7051
session_id		1979		2001		2001		2007		2017		2017		2019		2019		2011		2011

Table: filer_filings

filer_id		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583
filing_id		219436		219437		219438		219439		219440		219441		219442		219444		219445		176459		176460		176461		176462		176463		176464		176465		176466		176467		680239		176397		176398		176399		176400		176401		176402		176403		176404		176405		176406		176407		176409		176410		176411		176412		176413		176414		176415		176416		176417		176418		176419		176420		176421		176422		176423		176424		176425		176426		176427		176428		176429		176430		176432		176433		176434		176435		176436		176437		176438		176439		176440		176441		176442		176443		176444		176445		176446		176447		176448		176449		176450		176451		176452		176453		176454		176455		176457		176458		583404		176408		176431		176456		219443		219446		592968		600196		595674		647478		649567		674012		674994		669988		680718		675244		675756		722835		722837		722953		719701		731814		786267		782591		786641		773458		805752		806451		828553		833355		871712		850020		843091		871532		855520		917738		894573		945320		908757		962742		951685		806451		786641		782591		962529		773458		786267		805752		978702		1003129		995692		1003146		1003152		983444		1004076		998711		1006752		999853		995180		995894		1028718		1031447		1047467		1044714		1049127		1051678		1080683		786641		1119929		1087862		1118755		1146742		1149846		1156696		1158489		1176056		1173930		1186965		1205497		1192825		1210561		1214716		1203774		1234156		1239372		1284157		1286154		1783528		1981275		1870753		1853179		1840231		1857952		1853179		1786725		1935559		1944273		1893876		1906151		1310879		1312134		833355		1343623		1334112		1334070		1342456		1362057		1362904		1371212		1368625		1402131		1397684		1395722		1402830		1435953		1440453		1474975		1463095		1466096		1491083		1504427		1474124		1522357		1492543		1508714		1527272		1530240		1531281		1530235		1540360		1570476		1568302		1607080		1605759		1634342		1638028		1624056		1648010		1647390		1402830		1675190		1662682		1679620		1665702		1668787		1821719		1833194		1818154		1694035		1695644		1892578		1857952		1874875		1878082		1885028		1738983		1734426		1840231		1985002		2244184		1402830		2565587		2384760		2353377		2255036		2435498		2312309		2453508		2253463		2316103		2014211		2005890		2046466		2041648		2029605		2033687		2048316		2058729		2042225		2042099		2048560		2069753		2067517		2078328		2082856		2075567		2086623		2094198		2097263		2128073		2107961		2147792		1402830		2176099		2178142		2159363		2162785		2216982		2283926		1402830		2273009		2237507		2450178		2494792		2297691		2384480		2211378		2486779		2293650		2312924		2244571		2548422		1402830		2297953		2228077		2237720		2401647		2274038		2308902		1402830		2296057		2336338		2396231		2673270		2473643		1402830		2673270		2474961		2598672		2614490		2636972		2646582		2614490		2646582		2676549		2686903		2577330		2688489		2646582		2682576		2706484		2565587		2646582		2494792		2712321		2636972		1402830		2683982		2688489		2686903		2681324		2676549		2661809		2548422		2486779		2743801		2725719		2731775		2732034		2730188		2730188		2733416
period_id		82		107		115		130		132		131		135		143		147		154		154		155		156		156		156		157		159		159		None		118		141		105		109		111		113		117		119		121		123		123		107		105		115		113		111		121		119		117		125		124		127		129		129		127		131		132		132		129		127		133		135		133		137		127		129		125		132		130		131		132		137		137		139		123		121		119		124		117		140		151		141		141		143		146		145		145		149		153		None		109		137		148		141		153		None		None		161		None		None		None		None		163		None		164		164		None		None		None		164		None		167		None		None		165		168		None		169		None		None		169		None		171		None		None		157		173		172		None		None		None		None		None		175		165		167		168		176		None		177		None		None		None		177		None		None		177		177		None		177		None		None		179		180		None		180		None		None		None		181		183		None		185		None		None		185		186		None		None		188		None		187		188		None		189		None		213		221		218		217		218		None		217		None		220		None		None		220		191		None		None		None		None		193		194		195		None		None		196		None		None		196		197		197		None		None		199		None		201		202		201		203		None		None		None		204		None		204		None		None		204		None		205		207		None		208		None		209		210		210		209		None		None		None		None		217		215		211		None		219		None		None		219		219		None		212		218		None		234		241		None		None		None		None		239		236		241		234		None		None		223		226		226		226		225		None		226		226		None		226		None		227		227		227		227		228		None		227		228		None		None		230		229		None		None		None		None		235		230		234		233		None		None		235		None		231		241		235		235		234		243		238		None		None		None		None		None		236		234		235		236		237		249		None		246		249		242		245		None		247		None		None		None		None		250		None		None		None		250		250		None		None		None		251		247		250		250		None		250		None		None		249		243		241		251		251		None		None		252		252		252
form_id		F410		F420		F420		F420		F420		F405		F420		F420		F420		F420		F405		F420		F420		F666		F420		F420		F405		F420		F460		F405		F497		F420		F420		F420		F420		F420		F420		F420		F420		F420		F405		F405		F405		F405		F405		F405		F405		F405		F420		F405		F420		F420		F420		F405		F420		F420		F405		F405		F405		F420		F405		F405		F405		F405		F405		F405		F405		F405		F405		F405		F420		F405		F420		F405		F405		F405		F405		F405		F420		F420		F420		F405		F405		F497		F420		F420		F420		F420		F460		F405		F420		F420		F497		F420		F460		F497		F497		F460		F410		F460		F497		F460		F405		F497		F460		F405		F405		F460		F460		F410		F460		F460		F460		F460		F460		F460		F497		F410		F460		F460		F497		F460		F460		F465		F666		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F497		F497		F460		F497		F497		F497		F497		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F497		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F497		F460		F460		F460		F460		F460		F460		F497		F460		F460		F410		F460		F460		F460		F460		F410		F460		F497		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F497		F460		F497		F410		F460		F410		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F497		F460		F497		F460		F497		F497		F460		F497		F497		F460		F460		F460		F460		F460		F410		F460		F460		F410		F410		F460		F497		F410		F460		F460		F460		F460		F497		F666		F460		F460		F497		F460		F497		F460		F410		F460		F410		F460		F460		F460		F497		F410		F460		F460		F460		F460		F410		F410		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F497		F460		F460		F460		F460		F497		F460		F410		F497		F460		F460		F410		F460		F497		F460		F460		F460		F460		F460		F460		F497		F497		F497
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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		1		0		1		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		1		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		6		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		0		0		0		0		0		0		3		0		0		0		0		0		0		0		0		0		0		0		0		5		0		0		0		0		0		0		4		0		0		0		0		0		7		1		0		0		0		1		1		1		2		0		1		0		1		0		0		0		1		3		1		0		0		8		0		0		0		0		1		0		1		1		0		0		0		0		0		1		0
filing_date		1980-05-23 00:00:00		1990-09-28 00:00:00		1990-09-28 00:00:00		1992-07-30 00:00:00		1993-01-21 00:00:00		1993-04-27 00:00:00		1994-01-07 00:00:00		1996-01-31 00:00:00		1996-10-04 00:00:00		1998-07-22 00:00:00		1998-10-05 00:00:00		1998-10-05 00:00:00		1998-10-20 00:00:00		1998-12-31 00:00:00		1999-01-29 00:00:00		1999-08-02 00:00:00		1999-08-02 00:00:00		1999-10-12 00:00:00		2000-10-27 00:00:00		1989-05-26 00:00:00		1995-02-10 00:00:00		1990-09-28 00:00:00		1990-09-28 00:00:00		1990-09-28 00:00:00		1990-09-28 00:00:00		1990-09-28 00:00:00		1990-09-28 00:00:00		1990-09-28 00:00:00		1991-01-31 00:00:00		1990-09-28 00:00:00		1991-07-11 00:00:00		1991-07-11 00:00:00		1991-07-11 00:00:00		1991-07-11 00:00:00		1991-07-11 00:00:00		1991-07-11 00:00:00		1991-07-11 00:00:00		1991-07-11 00:00:00		1991-07-31 00:00:00		1991-08-12 00:00:00		1992-01-28 00:00:00		1992-04-30 00:00:00		1992-05-21 00:00:00		1992-08-21 00:00:00		1992-10-05 00:00:00		1992-10-22 00:00:00		1993-01-21 00:00:00		1993-04-23 00:00:00		1993-04-27 00:00:00		1993-07-26 00:00:00		1993-09-15 00:00:00		1993-09-22 00:00:00		1994-06-29 00:00:00		1994-06-29 00:00:00		1994-06-29 00:00:00		1994-06-29 00:00:00		1994-06-29 00:00:00		1994-06-29 00:00:00		1994-06-29 00:00:00		1994-06-29 00:00:00		1994-07-08 00:00:00		1994-09-14 00:00:00		1994-10-03 00:00:00		1994-12-21 00:00:00		1994-12-21 00:00:00		1994-12-21 00:00:00		1994-12-21 00:00:00		1994-12-21 00:00:00		1995-01-09 00:00:00		1998-01-23 00:00:00		1995-07-21 00:00:00		1995-08-11 00:00:00		1995-09-25 00:00:00		1996-04-10 00:00:00		1996-03-14 00:00:00		1996-07-31 00:00:00		1997-07-23 00:00:00		1998-03-20 00:00:00		2000-01-10 00:00:00		1991-07-11 00:00:00		1994-03-18 00:00:00		1997-01-30 00:00:00		1995-02-02 00:00:00		1998-05-20 00:00:00		2000-02-24 00:00:00		2000-02-26 00:00:00		2000-02-28 00:00:00		2000-07-31 00:00:00		2000-05-15 00:00:00		2000-10-05 00:00:00		2000-10-24 00:00:00		2000-10-10 00:00:00		2000-10-27 00:00:00		2000-10-25 00:00:00		2000-10-25 00:00:00		2001-01-31 00:00:00		2001-01-31 00:00:00		2001-01-31 00:00:00		2001-01-31 00:00:00		2001-01-31 00:00:00		2001-10-10 00:00:00		2001-07-31 00:00:00		2001-10-10 00:00:00		2001-07-31 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-03-04 00:00:00		2002-03-07 00:00:00		2002-10-07 00:00:00		2002-07-17 00:00:00		2002-03-04 00:00:00		2002-10-07 00:00:00		2002-07-30 00:00:00		2003-01-31 00:00:00		2002-11-27 00:00:00		2003-07-28 00:00:00		2003-01-29 00:00:00		2003-10-06 00:00:00		2003-07-31 00:00:00		2003-08-05 00:00:00		2003-08-05 00:00:00		2003-08-05 00:00:00		2003-10-08 00:00:00		2003-08-05 00:00:00		2003-08-05 00:00:00		2003-08-05 00:00:00		2004-01-08 00:00:00		2004-02-24 00:00:00		2004-02-18 00:00:00		2004-02-24 00:00:00		2004-02-24 00:00:00		2004-01-08 00:00:00		2004-03-01 00:00:00		2004-02-18 00:00:00		2004-03-01 00:00:00		2004-02-24 00:00:00		2004-02-17 00:00:00		2004-02-17 00:00:00		2004-07-29 00:00:00		2004-07-30 00:00:00		2004-10-05 00:00:00		2004-10-05 00:00:00		2004-10-19 00:00:00		2004-10-19 00:00:00		2005-01-31 00:00:00		2003-08-05 00:00:00		2005-08-01 00:00:00		2005-01-31 00:00:00		2005-08-01 00:00:00		2006-01-30 00:00:00		2006-01-31 00:00:00		2006-03-21 00:00:00		2006-03-22 00:00:00		2006-05-25 00:00:00		2006-05-25 00:00:00		2006-07-25 00:00:00		2006-10-04 00:00:00		2006-07-26 00:00:00		2006-10-24 00:00:00		2006-10-25 00:00:00		2006-10-04 00:00:00		2007-01-29 00:00:00		2007-01-30 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2013-07-31 00:00:00		2015-07-30 00:00:00		2014-07-30 00:00:00		2014-05-22 00:00:00		2014-05-22 00:00:00		2014-05-27 00:00:00		2014-05-22 00:00:00		2013-07-31 00:00:00		2015-01-31 00:00:00		2015-01-27 00:00:00		2014-10-06 00:00:00		2014-10-27 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-07-17 00:00:00		2008-07-14 00:00:00		2008-05-21 00:00:00		2008-05-21 00:00:00		2008-07-08 00:00:00		2008-10-03 00:00:00		2008-10-06 00:00:00		2008-10-22 00:00:00		2008-10-22 00:00:00		2009-01-12 00:00:00		2009-01-30 00:00:00		2009-01-30 00:00:00		2009-02-18 00:00:00		2009-07-29 00:00:00		2009-07-30 00:00:00		2010-03-22 00:00:00		2010-01-29 00:00:00		2010-01-29 00:00:00		2010-05-27 00:00:00		2010-07-28 00:00:00		2010-03-22 00:00:00		2010-10-05 00:00:00		2010-05-27 00:00:00		2010-07-29 00:00:00		2010-10-05 00:00:00		2010-10-20 00:00:00		2010-10-20 00:00:00		2010-10-20 00:00:00		2010-10-20 00:00:00		2011-01-27 00:00:00		2011-01-27 00:00:00		2011-07-28 00:00:00		2011-07-28 00:00:00		2012-01-30 00:00:00		2012-01-30 00:00:00		2011-11-03 00:00:00		2012-03-22 00:00:00		2012-03-22 00:00:00		2012-06-07 00:00:00		2012-07-26 00:00:00		2012-05-23 00:00:00		2012-07-26 00:00:00		2012-05-24 00:00:00		2012-06-08 00:00:00		2014-01-31 00:00:00		2014-03-25 00:00:00		2014-01-31 00:00:00		2012-10-04 00:00:00		2012-10-04 00:00:00		2014-10-06 00:00:00		2014-05-22 00:00:00		2014-07-31 00:00:00		2014-08-15 00:00:00		2014-09-12 00:00:00		2013-01-24 00:00:00		2013-01-29 00:00:00		2014-04-22 00:00:00		2015-07-31 00:00:00		2018-05-01 00:00:00		2020-03-16 00:00:00		2021-01-28 00:00:00		2019-05-22 00:00:00		2019-01-18 00:00:00		2018-05-24 00:00:00		2020-01-24 00:00:00		2018-10-25 00:00:00		2020-02-18 00:00:00		2018-05-24 00:00:00		2018-10-25 00:00:00		2016-01-27 00:00:00		2016-01-24 00:00:00		2016-05-26 00:00:00		2016-05-11 00:00:00		2016-04-19 00:00:00		2016-04-27 00:00:00		2016-05-25 00:00:00		2016-07-26 00:00:00		2016-05-12 00:00:00		2016-04-28 00:00:00		2016-06-01 00:00:00		2016-07-28 00:00:00		2016-08-11 00:00:00		2016-09-16 00:00:00		2016-09-29 00:00:00		2016-09-09 00:00:00		2016-10-07 00:00:00		2016-09-29 00:00:00		2016-10-27 00:00:00		2017-01-30 00:00:00		2016-10-27 00:00:00		2017-01-31 00:00:00		2017-04-27 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-04-25 00:00:00		2017-05-25 00:00:00		2018-01-31 00:00:00		2018-08-16 00:00:00		2017-05-26 00:00:00		2018-07-30 00:00:00		2018-04-26 00:00:00		2020-01-24 00:00:00		2020-07-31 00:00:00		2018-09-28 00:00:00		2019-03-29 00:00:00		2018-01-31 00:00:00		2020-07-31 00:00:00		2018-09-19 00:00:00		2018-10-25 00:00:00		2018-05-02 00:00:00		2021-01-27 00:00:00		2019-05-22 00:00:00		2018-09-26 00:00:00		2018-04-03 00:00:00		2018-04-26 00:00:00		2019-07-30 00:00:00		2018-07-30 00:00:00		2018-10-19 00:00:00		2018-04-03 00:00:00		2018-09-26 00:00:00		2019-01-18 00:00:00		2019-07-30 00:00:00		2022-04-28 00:00:00		2020-03-16 00:00:00		2021-04-22 00:00:00		2022-05-26 00:00:00		2020-06-17 00:00:00		2021-07-28 00:00:00		2021-07-29 00:00:00		2022-04-15 00:00:00		2022-04-18 00:00:00		2022-04-18 00:00:00		2022-04-18 00:00:00		2022-04-28 00:00:00		2022-06-30 00:00:00		2021-04-23 00:00:00		2022-07-01 00:00:00		2022-01-25 00:00:00		2022-05-13 00:00:00		2022-08-01 00:00:00		2022-04-18 00:00:00		2022-04-18 00:00:00		2022-04-18 00:00:00		2022-08-18 00:00:00		2022-01-24 00:00:00		2022-05-06 00:00:00		2022-05-18 00:00:00		2022-05-26 00:00:00		2022-05-26 00:00:00		2022-05-09 00:00:00		2022-05-26 00:00:00		2022-03-30 00:00:00		2022-04-15 00:00:00		2022-04-15 00:00:00		2022-10-27 00:00:00		2022-09-29 00:00:00		2022-08-01 00:00:00		2022-09-29 00:00:00		2022-10-07 00:00:00		2022-10-17 00:00:00		2022-10-14 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10005		10005		10001		10005		10002		10005		10001		10001		10005		10001		10001		10005		10005		10005		10001		10002		10001		10005		10005		10001		10001		10005		10001		10002		10005		10001		10005		10001		10005		10005		10005		10001		10001		10005		10005		10006		10006		10006		10001		10002		10002		10002		10001		10005		10001		10005		10005		10005		10001		10005		10005		10001		10001		10005		10001		10005		10005		10001		10001		10005		10001		10006		10005		10005		10001		10001		10005		10001		10005		10005		10001		10001		10005		10005		10001		10005		10001		10001		10005		10001		10005		10001		10001		10001		10001		10002		10006		10002		10005		10001		10005		10005		10001		10001		10005		10006		10005		10005		10001		10001		10001		10005		10005		10001		10006		10005		10001		10001		10001		10005		10005		10001		10005		10001		10001		10001		10001		10005		10005		10005		10001		10005		10001		10005		10005		10001		10005		10001		10001		10005		10001		10005		10001		10002		10001		10001		10005		10005		10006		10005		10001		10001		10001		10005		10001		10005		10005		10001		10001		10005		10001		10001		10005		10001		10002		10005		10006		10005		10005		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10001		10005		10001		10001		10005		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10005		10005		10002		10001		10005		10006		10006		10005		10001		10002		10001		10001		10005		10005		10001		10005		10001		10001		10001		10001		10001		10001		10002		10005		10006		10005		10005		10005		10001		10002		10001		10001		10001		10001		10006		10002		10002		10001		10001		10005		10002		10006		10006		10006		10005		10002		10006		10006		10005		10001		10001		10006		10006		10006		10001		10001		10002		10001		10005		10001		10006		10006		10001		10002		10002		10001		10001		10005		10005		10001		10002		10001
stmnt_status		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		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		11002		11001		11003		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11001		11003		11001		11003		11003		11001		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		11001		11003		11001		11003		11003		11003		11001		11001		11003		11003		11001		11003		11001		11001		11003		11003		11001		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11003		11001		11001		11003		11003		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11001		11001		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11001		11003		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11003		11001		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
session_id		1979		1985		1987		1991		1991		1991		1993		1995		1995		1997		1997		1997		1997		1997		1997		1999		1999		1999		1999		1989		1995		1985		1987		1987		1987		1989		1989		1989		1989		1989		1985		1985		1987		1987		1987		1989		1989		1989		1991		1989		1991		1991		1991		1991		1991		1991		1991		1991		1991		1993		1993		1993		1993		1991		1991		1991		1991		1991		1991		1991		1993		1993		1993		1989		1989		1989		1989		1989		1993		1997		1995		1995		1995		1995		1995		1995		1997		1997		1999		1987		1993		1995		1995		1997		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		1999		2003		2001		2003		2003		2001		2001		2001		2003		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2001		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2013		2015		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2007		2007		2001		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2011		2011		2013		2013		2013		2013		2013		2011		2011		2013		2015		2017		2019		2021		2019		2017		2017		2019		2017		2019		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2019		2019		2017		2015		2017		2019		2017		2017		2017		2019		2019		2017		2017		2017		2019		2017		2017		2017		2017		2017		2019		2021		2019		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2019		2019		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		KCHAN		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		GPEREZ		*		*		JLEHMAN		DHORRELL		KCHAN		GPEREZ		*		KCHAN		*		*		TWALLS		TWALLS		TWALLS		*		EMCENTEE		*		LTHIBAUL		SARRIAGA		*		*		CFLAGG		*		EMCENTEE		DBARRICK		*		RALLMOND		*		DBARRICK		DBARRICK		PROBERTS		COMPLETED		COMPLETED		KVANG		KVOONG1		GGILMORE		DWALKER		GGILMORE		COMPLETED		COMPLETED		COMPLETED		COMPLETED		COMPLETED		GPEREZ		COMPLETED		GPEREZ		GPEREZ		KLARRY		COMPLETED		EMCENTEE		KLARRY		COMPLETED		COMPLETED		KLARRY		COMPLETED		EMCENTEE		SARRIAGA		COMPLETED		PBANFORD		GPEREZ		COMPLETED		CFLAGG		GPEREZ		CFLAGG		*		*		GPEREZ		*		GPEREZ		GPEREZ		*		*		CFLAGG		CFLAGG		*		CFLAGG		*		*		SARRIAGA		*		GPEREZ		SARRIAGA		SARRIAGA		CAFILER		MDIGRAZIA		WBROWN		MPACHECO		CAFILER		SARRIAGA		CAFILER		GCLARA		JINGRAM		WBROWN		*		SARRIAGA		EMCENTEE		CPON		TMILLER		*		CPON		*		RGEREMIA		RGEREMIA		*		RGEREMIA		JVAZQUEZ		*		*		MMORENO		MMORENO		SARRIAGA		*		SARRIAGA		*		SARRIAGA		*		SMCCONNAN		SARRIAGA		SARRIAGA		SMCCONNAN		WBROWN		SMCCONNAN		SMCCONNAN		GKURIMOT		CPON		CPON		SMCCONNAN		SMCCONNAN		MDIGRAZIA		MDIGRAZIA		PBANFORD		SARRIAGA		SARRIAGA		TRAMON		CPON		CPON		CPON		CPON		TRAMON		MPACHECO		WBROWN		MDIGRAZIA		CAFILER		MPACHECO		CAFILER		MDIGRAZIA		MPACHECO		WBROWN		WBROWN		MPACHECO		CAFILER		WBROWN		SARRIAGA		CAFILER		CAFILER		CREYNOLDS		TRAMON		LPHEAV		BSINGH		VUKSTINA		CAFILER		CAFILER		BSINGH		HSTOVALL		MDIGRAZIA		MDIGRAZIA		DMCCASTL		KBANH		KBANH		MDIGRAZIA		SARRIAGA		SARRIAGA		KBANH		MDIGRAZIA		KBANH		SARRIAGA		PDEO		PDEO		SARRIAGA		PDEO		PDEO		SARRIAGA		LBARTHOL		SARRIAGA		LBARTHOL		SARRIAGA		TRAMON		BSINGH		BSINGH		TRAMON		TRAMON		LBARTHOL		CAFILER		TRAMON		HSTOVALL		HSTOVALL		VUKSTINA		KRUSSELL		CAFILER		AROJAS		LBARTHOL		KRUSSELL		CAFILER		HSTOVALL		CAFILER		CREYNOLDS		TRAMON		CSAGABAEN		TRAMON		HSTOVALL		HCOURSEY		HSTOVALL		CAFILER		TRAMON		CSAGABAEN		LPHEAV		HCOURSEY		KRUSSELL		SARRIAGA		IMEDINA		CAFILER		RGEREMIA		KRUSSELL		KRUSSELL		CAFILER		JMAVES		JMAVES		JMAVES		KRUSSELL		CAFILER		IMEDINA		JMAVES		KRUSSELL		CAFILER		CAFILER		JMAVES		JMAVES		JMAVES		CAFILER		KRUSSELL		IMEDINA		CAFILER		KRUSSELL		KRUSSELL		IMEDINA		JMAVES		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		RGEREMIA		RGEREMIA		CAFILER		CAFILER		CAFILER
special_audit		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		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		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		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		11003		11003		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		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11003		11001		11003		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		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		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
rpt_start		None		1986-07-01 00:00:00		1988-07-01 00:00:00		1992-05-17 00:00:00		1992-10-18 00:00:00		1992-07-01 00:00:00		1993-07-01 00:00:00		1995-07-01 00:00:00		1996-07-01 00:00:00		1998-05-17 00:00:00		1998-05-17 00:00:00		1998-07-01 00:00:00		1998-10-01 00:00:00		None		1998-10-18 00:00:00		1999-01-01 00:00:00		None		1999-07-01 00:00:00		2000-10-01 00:00:00		None		None		1986-01-01 00:00:00		1987-01-01 00:00:00		1987-07-01 00:00:00		1988-01-01 00:00:00		1989-01-01 00:00:00		1989-07-01 00:00:00		1990-01-01 00:00:00		1990-07-01 00:00:00		1990-07-01 00:00:00		1986-07-30 00:00:00		1986-01-01 00:00:00		1988-07-01 00:00:00		1988-01-01 00:00:00		1987-07-01 00:00:00		1990-01-01 00:00:00		1989-07-01 00:00:00		1989-01-01 00:00:00		1991-01-01 00:00:00		1990-10-01 00:00:00		1991-07-01 00:00:00		1992-01-01 00:00:00		1992-03-18 00:00:00		1991-07-01 00:00:00		1992-07-01 00:00:00		1992-10-01 00:00:00		1992-10-01 00:00:00		1992-03-18 00:00:00		1991-09-30 00:00:00		1993-01-01 00:00:00		None		1993-01-01 00:00:00		1994-03-18 00:00:00		1991-07-01 00:00:00		1992-01-01 00:00:00		1991-01-01 00:00:00		1992-10-18 00:00:00		1992-05-17 00:00:00		1992-07-01 00:00:00		1992-10-01 00:00:00		1994-03-18 00:00:00		1994-03-18 00:00:00		1994-07-01 00:00:00		1990-07-01 00:00:00		1990-01-01 00:00:00		1989-07-01 00:00:00		1990-10-01 00:00:00		1989-01-01 00:00:00		1994-10-01 00:00:00		1997-07-01 00:00:00		1995-01-01 00:00:00		1995-01-01 00:00:00		None		None		1996-01-01 00:00:00		1996-03-10 00:00:00		1997-01-01 00:00:00		1998-01-01 00:00:00		1999-10-01 00:00:00		1987-01-01 00:00:00		1994-01-01 00:00:00		1996-10-01 00:00:00		None		1998-03-18 00:00:00		2000-01-01 00:00:00		None		2000-02-26 00:00:00		2000-02-20 00:00:00		None		2000-07-01 00:00:00		None		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-10-25 00:00:00		2000-10-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		2000-10-22 00:00:00		2000-10-22 00:00:00		None		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-03-04 00:00:00		None		2002-07-01 00:00:00		2002-01-01 00:00:00		None		2002-07-01 00:00:00		2002-01-01 00:00:00		2002-10-01 00:00:00		1999-01-01 00:00:00		2003-01-01 00:00:00		2002-10-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2003-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2003-10-01 00:00:00		None		2004-02-18 00:00:00		None		None		2003-10-01 00:00:00		2004-03-01 00:00:00		None		None		2004-02-24 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-02-15 00:00:00		2004-02-15 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-10-19 00:00:00		None		2004-10-01 00:00:00		2001-07-01 00:00:00		2005-01-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2006-03-18 00:00:00		2006-03-18 00:00:00		2006-05-21 00:00:00		2006-07-01 00:00:00		2006-05-21 00:00:00		2006-10-01 00:00:00		2006-10-01 00:00:00		2006-07-01 00:00:00		2006-10-22 00:00:00		2006-10-22 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2014-05-18 00:00:00		2014-01-01 00:00:00		2014-05-22 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2014-10-01 00:00:00		2014-10-01 00:00:00		2014-07-01 00:00:00		2014-10-27 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		None		2008-05-18 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-05-18 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-10-01 00:00:00		None		2008-10-19 00:00:00		2008-10-19 00:00:00		2009-02-18 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2010-01-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2010-03-18 00:00:00		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2010-03-18 00:00:00		2010-05-23 00:00:00		2010-07-01 00:00:00		2010-10-20 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		None		2010-10-17 00:00:00		2010-10-17 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2011-11-03 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-06-07 00:00:00		2012-05-20 00:00:00		2012-03-18 00:00:00		2012-05-20 00:00:00		2012-03-18 00:00:00		None		2013-07-01 00:00:00		2014-03-25 00:00:00		2013-07-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2014-05-18 00:00:00		2014-08-15 00:00:00		2014-09-12 00:00:00		2012-10-01 00:00:00		2012-10-01 00:00:00		2014-04-22 00:00:00		2015-01-01 00:00:00		2018-05-01 00:00:00		2020-03-10 00:00:00		2020-07-01 00:00:00		None		2018-10-21 00:00:00		2018-04-22 00:00:00		2019-07-01 00:00:00		2018-10-25 00:00:00		2020-02-18 00:00:00		2018-04-22 00:00:00		2018-09-23 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-04-24 00:00:00		2016-05-11 00:00:00		2016-04-19 00:00:00		2016-01-01 00:00:00		2016-04-24 00:00:00		2016-05-22 00:00:00		2016-05-12 00:00:00		2016-01-01 00:00:00		2016-06-01 00:00:00		2016-05-22 00:00:00		2016-08-11 00:00:00		2016-09-15 00:00:00		2016-07-01 00:00:00		2016-09-09 00:00:00		2016-10-07 00:00:00		2016-07-01 00:00:00		2016-09-25 00:00:00		2016-10-23 00:00:00		2016-09-25 00:00:00		2016-10-23 00:00:00		2017-04-27 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		None		None		2017-07-01 00:00:00		2018-08-16 00:00:00		2017-05-25 00:00:00		2018-05-20 00:00:00		2018-01-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2018-09-28 00:00:00		2015-01-01 00:00:00		2017-07-01 00:00:00		2020-01-01 00:00:00		2018-09-19 00:00:00		2018-09-23 00:00:00		2018-05-02 00:00:00		2020-07-01 00:00:00		2019-05-17 00:00:00		2018-07-01 00:00:00		None		2018-01-01 00:00:00		2019-01-01 00:00:00		2018-05-20 00:00:00		2018-10-19 00:00:00		2018-04-02 00:00:00		2018-07-01 00:00:00		2018-10-21 00:00:00		2019-01-01 00:00:00		2022-01-01 00:00:00		None		2021-04-21 00:00:00		2022-01-01 00:00:00		2020-06-17 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2022-04-24 00:00:00		None		2022-04-24 00:00:00		2021-07-01 00:00:00		2022-05-13 00:00:00		2022-05-22 00:00:00		2020-07-01 00:00:00		2021-07-01 00:00:00		2020-01-01 00:00:00		2022-08-18 00:00:00		2021-07-01 00:00:00		2022-05-05 00:00:00		2022-05-18 00:00:00		2022-04-24 00:00:00		2022-04-24 00:00:00		None		2022-01-01 00:00:00		2022-03-30 00:00:00		2020-07-01 00:00:00		2020-01-01 00:00:00		2022-09-25 00:00:00		2022-07-01 00:00:00		2022-05-22 00:00:00		2022-07-01 00:00:00		2022-10-07 00:00:00		2022-10-17 00:00:00		2022-10-14 00:00:00
rpt_end		None		1986-12-31 00:00:00		1988-12-31 00:00:00		1992-06-30 00:00:00		1992-12-31 00:00:00		1992-09-30 00:00:00		1993-12-31 00:00:00		1995-12-31 00:00:00		1996-09-30 00:00:00		1998-06-30 00:00:00		1998-06-30 00:00:00		1998-09-30 00:00:00		1998-10-17 00:00:00		None		1998-12-31 00:00:00		1999-06-30 00:00:00		None		1999-09-30 00:00:00		2000-10-21 00:00:00		None		None		1986-06-30 00:00:00		1987-06-30 00:00:00		1987-12-31 00:00:00		1988-06-30 00:00:00		1989-06-30 00:00:00		1989-12-31 00:00:00		1990-06-30 00:00:00		1990-12-31 00:00:00		1990-09-30 00:00:00		1986-12-31 00:00:00		1986-06-30 00:00:00		1988-12-31 00:00:00		1988-06-30 00:00:00		1987-12-31 00:00:00		1990-06-30 00:00:00		1989-12-31 00:00:00		1989-06-30 00:00:00		1991-06-30 00:00:00		1990-12-31 00:00:00		1991-12-31 00:00:00		1992-03-17 00:00:00		1992-05-16 00:00:00		1991-12-31 00:00:00		1992-09-30 00:00:00		1992-10-17 00:00:00		1992-10-17 00:00:00		1992-05-16 00:00:00		None		1993-06-30 00:00:00		None		1993-06-30 00:00:00		1994-05-16 00:00:00		1991-12-31 00:00:00		1992-03-17 00:00:00		1991-06-30 00:00:00		1992-12-31 00:00:00		1992-06-30 00:00:00		1992-09-30 00:00:00		1992-10-17 00:00:00		1994-06-30 00:00:00		1994-06-30 00:00:00		1994-09-30 00:00:00		1990-09-30 00:00:00		1990-06-30 00:00:00		1989-12-31 00:00:00		1990-12-31 00:00:00		1989-06-30 00:00:00		1994-12-31 00:00:00		1997-12-31 00:00:00		1995-06-30 00:00:00		1995-06-30 00:00:00		None		None		1996-03-09 00:00:00		1996-06-30 00:00:00		1997-06-30 00:00:00		1998-03-17 00:00:00		1999-12-31 00:00:00		1987-06-30 00:00:00		1994-03-17 00:00:00		1996-12-31 00:00:00		None		1998-05-16 00:00:00		2000-02-19 00:00:00		None		2000-02-26 00:00:00		2000-06-30 00:00:00		None		2000-09-30 00:00:00		None		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-10-25 00:00:00		2000-10-21 00:00:00		2000-09-30 00:00:00		2000-10-21 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		None		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2002-03-04 00:00:00		None		2002-09-30 00:00:00		2002-06-30 00:00:00		None		2002-09-30 00:00:00		2002-06-30 00:00:00		2002-12-31 00:00:00		2000-12-31 00:00:00		2003-06-30 00:00:00		2002-12-31 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2003-09-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2003-12-31 00:00:00		None		2004-02-18 00:00:00		None		None		2003-12-31 00:00:00		2004-03-01 00:00:00		None		None		2004-02-24 00:00:00		2004-02-14 00:00:00		2004-02-14 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-10-19 00:00:00		None		2004-12-31 00:00:00		2001-09-30 00:00:00		2005-06-30 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-03-17 00:00:00		2006-03-17 00:00:00		2006-05-20 00:00:00		2006-05-20 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-06-30 00:00:00		2006-10-21 00:00:00		2006-10-21 00:00:00		2006-09-30 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2014-05-17 00:00:00		2014-05-22 00:00:00		2014-05-17 00:00:00		2014-05-17 00:00:00		2013-06-30 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2014-09-30 00:00:00		2014-10-27 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		None		2008-06-30 00:00:00		2008-05-17 00:00:00		2008-05-17 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-09-30 00:00:00		2008-10-18 00:00:00		2008-10-18 00:00:00		None		2008-12-31 00:00:00		2008-12-31 00:00:00		2009-02-18 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2010-03-17 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-03-17 00:00:00		2010-09-30 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-10-20 00:00:00		2010-10-16 00:00:00		2010-10-16 00:00:00		None		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2011-11-03 00:00:00		2012-03-17 00:00:00		2012-03-17 00:00:00		2012-06-07 00:00:00		2012-06-30 00:00:00		2012-05-19 00:00:00		2012-06-30 00:00:00		2012-05-19 00:00:00		None		2013-12-31 00:00:00		2014-03-25 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2014-09-30 00:00:00		2014-05-17 00:00:00		2014-06-30 00:00:00		2014-08-15 00:00:00		2014-09-12 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2014-04-22 00:00:00		2015-06-30 00:00:00		2018-05-01 00:00:00		2020-03-10 00:00:00		2020-12-31 00:00:00		None		2018-12-31 00:00:00		2018-05-19 00:00:00		2019-12-31 00:00:00		2018-10-25 00:00:00		2020-02-18 00:00:00		2018-05-19 00:00:00		2018-10-20 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-05-21 00:00:00		2016-05-11 00:00:00		2016-04-19 00:00:00		2016-04-23 00:00:00		2016-05-21 00:00:00		2016-06-30 00:00:00		2016-05-12 00:00:00		2016-04-23 00:00:00		2016-06-01 00:00:00		2016-06-30 00:00:00		2016-08-11 00:00:00		2016-09-15 00:00:00		2016-09-24 00:00:00		2016-09-09 00:00:00		2016-10-07 00:00:00		2016-09-24 00:00:00		2016-10-22 00:00:00		2016-12-31 00:00:00		2016-10-22 00:00:00		2016-12-31 00:00:00		2017-04-27 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		None		None		2017-12-31 00:00:00		2018-08-16 00:00:00		2017-05-25 00:00:00		2018-06-30 00:00:00		2018-04-21 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2018-09-28 00:00:00		2016-12-31 00:00:00		2017-12-31 00:00:00		2020-06-30 00:00:00		2018-09-19 00:00:00		2018-10-20 00:00:00		2018-05-02 00:00:00		2020-12-31 00:00:00		2019-05-17 00:00:00		2018-09-22 00:00:00		None		2018-04-21 00:00:00		2019-06-30 00:00:00		2018-06-30 00:00:00		2018-10-19 00:00:00		2018-04-02 00:00:00		2018-09-22 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2022-04-23 00:00:00		None		2021-04-21 00:00:00		2022-04-23 00:00:00		2020-06-17 00:00:00		2021-06-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-04-23 00:00:00		2022-05-21 00:00:00		None		2022-05-21 00:00:00		2021-12-31 00:00:00		2022-05-13 00:00:00		2022-06-30 00:00:00		2020-12-31 00:00:00		2021-12-31 00:00:00		2020-06-30 00:00:00		2022-08-18 00:00:00		2021-12-31 00:00:00		2022-05-05 00:00:00		2022-05-18 00:00:00		2022-05-21 00:00:00		2022-05-21 00:00:00		None		2022-04-23 00:00:00		2022-03-30 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		2022-10-22 00:00:00		2022-09-24 00:00:00		2022-06-30 00:00:00		2022-09-30 00:00:00		2022-10-07 00:00:00		2022-10-17 00:00:00		2022-10-14 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		2000-02-26 00:00:00		None		None		None		2000-10-24 00:00:00		2000-10-05 00:00:00		None		2000-10-25 00:00:00		2000-10-25 00:00:00		None		None		None		2001-01-31 00:00:00		None		2001-10-10 00:00:00		None		None		2001-07-31 00:00:00		2002-01-10 00:00:00		None		2002-03-04 00:00:00		None		None		2002-07-12 00:00:00		None		2002-10-04 00:00:00		None		None		None		2003-07-25 00:00:00		2003-01-21 00:00:00		None		None		None		None		None		2003-10-06 00:00:00		2003-08-05 00:00:00		2003-08-05 00:00:00		2003-08-05 00:00:00		2004-01-07 00:00:00		None		2004-02-18 00:00:00		None		None		None		2004-03-01 00:00:00		None		None		2004-02-24 00:00:00		2004-02-17 00:00:00		None		2004-07-28 00:00:00		None		None		2004-10-04 00:00:00		2004-10-19 00:00:00		None		2005-01-27 00:00:00		None		None		None		2005-08-01 00:00:00		2006-01-20 00:00:00		None		2006-03-17 00:00:00		None		None		2006-05-24 00:00:00		2006-07-25 00:00:00		None		None		2006-10-23 00:00:00		None		2006-10-02 00:00:00		2007-01-22 00:00:00		None		2007-07-30 00:00:00		None		2013-07-30 00:00:00		2015-07-28 00:00:00		2014-07-24 00:00:00		2014-05-21 00:00:00		2014-05-22 00:00:00		None		2014-05-22 00:00:00		None		2015-01-26 00:00:00		None		None		2014-10-27 00:00:00		2008-01-25 00:00:00		None		None		None		None		2008-05-17 00:00:00		2008-07-08 00:00:00		2008-10-02 00:00:00		None		None		2008-10-20 00:00:00		None		None		2009-01-26 00:00:00		None		2009-07-22 00:00:00		None		None		2010-01-28 00:00:00		None		2010-05-25 00:00:00		2010-07-26 00:00:00		2010-03-19 00:00:00		2010-10-04 00:00:00		None		None		None		2010-10-20 00:00:00		None		2010-10-18 00:00:00		None		None		2011-01-25 00:00:00		None		2011-07-22 00:00:00		2012-01-26 00:00:00		None		2011-11-03 00:00:00		None		2012-03-20 00:00:00		None		2012-07-25 00:00:00		2012-05-21 00:00:00		None		None		None		None		2014-03-25 00:00:00		2014-01-28 00:00:00		2012-10-01 00:00:00		None		2014-10-02 00:00:00		None		None		2014-08-15 00:00:00		2014-09-12 00:00:00		None		2013-01-19 00:00:00		2014-04-22 00:00:00		None		2018-05-01 00:00:00		None		None		None		None		None		2020-01-15 00:00:00		2018-10-25 00:00:00		2020-02-18 00:00:00		2018-05-23 00:00:00		None		None		2016-01-20 00:00:00		2016-05-23 00:00:00		2016-05-11 00:00:00		2016-04-19 00:00:00		2016-04-27 00:00:00		None		2016-07-18 00:00:00		2016-05-12 00:00:00		None		2016-06-01 00:00:00		None		2016-08-11 00:00:00		2016-09-15 00:00:00		2016-09-27 00:00:00		2016-09-09 00:00:00		2016-10-07 00:00:00		None		2016-10-23 00:00:00		2017-01-23 00:00:00		None		None		None		2017-07-31 00:00:00		None		None		None		None		2018-08-16 00:00:00		None		2018-07-19 00:00:00		2018-04-26 00:00:00		None		None		2018-09-28 00:00:00		None		2018-01-31 00:00:00		2020-07-29 00:00:00		2018-09-19 00:00:00		2018-10-20 00:00:00		2018-05-02 00:00:00		2021-01-26 00:00:00		None		None		None		None		None		None		2018-10-19 00:00:00		None		2018-09-22 00:00:00		2019-01-08 00:00:00		2019-07-29 00:00:00		2022-04-27 00:00:00		None		None		2022-05-25 00:00:00		2020-06-17 00:00:00		2021-07-10 00:00:00		None		2022-04-12 00:00:00		None		None		None		None		2022-06-15 00:00:00		None		None		None		2022-05-13 00:00:00		2022-07-28 00:00:00		None		None		None		2022-08-18 00:00:00		2022-01-19 00:00:00		None		2022-05-18 00:00:00		None		2022-05-25 00:00:00		None		None		2022-03-30 00:00:00		2022-04-12 00:00:00		2022-04-12 00:00:00		2022-10-25 00:00:00		2022-09-26 00:00:00		None		None		2022-10-07 00:00:00		2022-10-17 00:00:00		2022-10-14 00:00:00
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		22001		22001		22001		22001		22001		None		22001		None		None		None		22001		None		None		22001		22001		None		22001		None		None		22001		22001		None		22001		None		None		None		22001		22001		None		22001		None		None		22001		22001		None		None		22001		None		22001		22001		None		22001		None		22001		22001		22001		22001		22006		None		22006		None		22001		None		None		22001		22001		None		None		None		None		22001		22001		22001		None		None		22001		None		None		22001		22006		22001		None		None		22001		None		22001		22001		22001		22001		None		None		None		22001		None		22001		None		None		22001		None		22001		22001		None		22001		None		22001		22006		22001		22001		None		None		None		None		22001		22001		22001		None		22001		None		None		22001		22001		None		22001		22001		None		22001		22001		None		None		None		None		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		None		22001		22001		None		22001		None		22001		22001		22001		22001		22001		None		22001		22001		None		None		22001		22001		None		None		None		None		22001		22001		22001		22001		None		None		22001		None		22001		22001		22001		22001		22001		22001		22001		None		None		None		None		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		None		None		None		None		22001		None		None		None		22001		22001		None		None		None		22001		22001		22001		22001		None		22001		None		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001

Table: filer_to_filer_type

filer_id		1029583		1029583
filer_type		16		16
active		Y		Y
race		0		0
session_id		1979		2007
category		0		0
category_type		40502		40502
sub_category		40103		40103
effect_dt		1990-12-01 00:00:00		2008-07-17 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		None		S
nyq_dt		1980-05-23 00:00:00		1980-05-23 00:00:00
party_cd		None		None
county_cd		18004		18004
district_cd		None		None

Table: filer_xref

filer_id		1029583
xref_id		801777
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777		801777
filer_id		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00		2008-07-17 00:00:00
naml		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSN. OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSN. OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSN. OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSN. OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSN. OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSN. OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSN. OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSN. OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSN. OF SHEET METAL AND AIR CONDITIONING CONTRACTORS PAC		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS POLITICAL ACTION COMMITTEE		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS POLITICAL ACTION COMMITTEE		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS POLITICAL ACTION COMMITTEE		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS POLITICAL ACTION COMMITTEE		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS POLITICAL ACTION COMMITTEE		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS POLITICAL ACTION COMMITTEE		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS POLITICAL ACTION COMMITTEE		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS POLITICAL ACTION COMMITTEE		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING CONTRACTORS POLITICAL ACTION COMMITTEE		CALIFORNIA ASSOCIATION SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION		CALIFORNIA ASSOCIATION SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION		CALIFORNIA ASSOCIATION SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION		CALIFORNIA ASSOCIATION SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION		CALIFORNIA ASSOCIATION SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION		CALIFORNIA ASSOCIATION SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION		CALIFORNIA ASSOCIATION SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION		CALIFORNIA ASSOCIATION SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION		CALIFORNIA ASSOCIATION SHEET METAL & AIR CONDITIONING CONTRACTORS NATIONAL ASSOCIATION		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING		CALIFORNIA ASSOCIATION OF SHEET METAL AND AIR CONDITIONING
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
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
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
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
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
city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
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
zip4		95826		95814		95826		95814		95826		95814		95814		95814		95815		95826		95814		95826		95814		95826		95814		95814		95814		95815		95826		95814		95826		95814		95826		95814		95814		95814		95815		95826		95814		95826		95814		95826		95814		95814		95814		95815		95826		95814		95826		95814		95826		95814		95814		95814		95815
phon		9163637460		9164428888		9163637460		9163637460		9163637460		9163637460		9163637460		9162855733				9163637460		9164428888		9163637460		9163637460		9163637460		9163637460		9163637460		9162855733				9163637460		9164428888		9163637460		9163637460		9163637460		9163637460		9163637460		9162855733				9163637460		9164428888		9163637460		9163637460		9163637460		9163637460		9163637460		9162855733				9163637460		9164428888		9163637460		9163637460		9163637460		9163637460		9163637460		9162855733
fax		None		9164420382		None		9163637544		9163637544		9163637544		9163637544		9163331344				None		9164420382		None		9163637544		9163637544		9163637544		9163637544		9163331344				None		9164420382		None		9163637544		9163637544		9163637544		9163637544		9163331344				None		9164420382		None		9163637544		9163637544		9163637544		9163637544		9163331344				None		9164420382		None		9163637544		9163637544		9163637544		9163637544		9163331344
email		None		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None

Table: filers

filer_id		1029583

Table: received_filings

filer_id		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583		1029583
filing_file_name		675244_0.cal		18444.cal		28689.cal		31228.cal		669988_0.cal		26041.cal		26284.cal		675756_0.cal		23937.cal		719701_0.cal		786267_0.cal		773458_0.cal		92191.cal		91660.cal		805752_0.cal		828553_0.cal		373168.cal		850020_0.cal		871532_0.cal		908757_0.cal		773458_1.cal		10047.cal		786267_1.cal		805752_1.cal		945320_0.cal		962529_0.cal		978702_0.cal		1004076_0.cal		999853_0.cal		995692_0.cal		1049127_0.cal		1530240_0.cal		8251.cal		1840231_0.cal		1833194_0.cal		1624056_0.cal		1840231_1.cal		191597.cal		191717.cal		198272.cal		2048560_0.cal		2086623_0.cal		2078328_0.cal		1878082_0.cal		1885028_0.cal		2029605_0.cal		1906151_0.cal		2067517_0.cal		2075567_0.cal		2042225_0.cal		2041648_0.cal		2244184_0.cal		2453508_0.cal		2312309_0.cal		2283926_0.cal		2297691_0.cal		2244571_0.cal		2293650_0.cal		2308902_0.cal		2730188_0.cal		2683982_0.cal		2712321_0.cal		2661809_0.cal		2733416_0.cal		2730188_1.cal
received_date		2000-10-25 00:00:00		2000-10-05 00:00:00		2000-10-06 00:00:00		2000-10-10 00:00:00		2000-10-10 00:00:00		2000-10-05 00:00:00		2000-10-05 00:00:00		2000-10-25 00:00:00		2001-01-31 00:00:00		2001-01-31 00:00:00		2001-10-10 00:00:00		2001-07-31 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-03-04 00:00:00		2002-03-07 00:00:00		2002-07-17 00:00:00		2002-10-07 00:00:00		2003-01-29 00:00:00		2003-08-05 00:00:00		2003-08-05 00:00:00		2003-08-05 00:00:00		2003-08-05 00:00:00		2003-07-28 00:00:00		2003-10-08 00:00:00		2004-01-08 00:00:00		2004-03-01 00:00:00		2004-02-24 00:00:00		2004-02-18 00:00:00		2004-10-19 00:00:00		2010-10-20 00:00:00		2014-03-31 00:00:00		2014-04-22 00:00:00		2014-03-25 00:00:00		2011-11-03 00:00:00		2014-05-22 00:00:00		2017-04-26 00:00:00		2017-04-26 00:00:00		2017-04-26 00:00:00		2016-06-01 00:00:00		2016-10-07 00:00:00		2016-09-16 00:00:00		2014-08-15 00:00:00		2014-09-12 00:00:00		2016-04-19 00:00:00		2014-10-27 00:00:00		2016-08-11 00:00:00		2016-09-09 00:00:00		2016-05-12 00:00:00		2016-05-11 00:00:00		2018-05-01 00:00:00		2020-02-18 00:00:00		2018-10-25 00:00:00		2018-08-16 00:00:00		2018-09-28 00:00:00		2018-05-02 00:00:00		2018-09-19 00:00:00		2018-10-19 00:00:00		2022-10-07 00:00:00		2022-05-18 00:00:00		2022-08-18 00:00:00		2022-03-30 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00
filing_directory		/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/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/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/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/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/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		675244		None		None		None		669988		None		None		675756		None		719701		786267		773458		None		None		805752		828553		None		850020		871532		908757		773458		None		786267		805752		945320		962529		978702		1004076		999853		995692		1049127		1530240		None		1840231		1833194		1624056		1840231		None		None		None		2048560		2086623		2078328		1878082		1885028		2029605		1906151		2067517		2075567		2042225		2041648		2244184		2453508		2312309		2283926		2297691		2244571		2293650		2308902		2730188		2683982		2712321		2661809		2733416		2730188
form_id		F497		None		None		None		F460		None		None		F460		None		F460		F460		F460		None		None		F460		F497		None		F460		F460		F460		F460		None		F460		F460		F460		F460		F460		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		None		None		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted, but but with warnings		Filing did not pass validation		Filing did not pass validation		Filing accepted, but but with warnings		Filing did not pass validation		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing did not pass validation		Filing did not pass validation		Filing accepted, but with warnings		Filing accepted		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 passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted