Home

Filer ID: 1040629

Table: filer_address

filer_id		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629
adrid		1039252		2021659		2053208		2103105		2191231		2191230		2286706		2479992		2479991		2450423		2450422
effect_dt		1986-07-14 00:00:00		2001-10-01 00:00:00		1985-12-19 00:00:00		2006-05-09 00:00:00		2010-07-21 00:00:00		2001-10-01 00:00:00		2013-01-31 00:00:00		2019-04-15 00:00:00		2019-04-15 00:00:00		2018-03-05 00:00:00		2018-03-05 00:00:00
add_type		7051		7051		7051		7051		7051		7082		7082		7082		7051		7051		7082
session_id		1985		2001		1985		2005		2009		2001		2013		2019		2019		2017		2017

Table: filer_filings

filer_id		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629
filing_id		268810		268811		268812		268813		268814		268815		268816		268817		268818		268819		268766		268767		268768		268769		268770		268771		268772		268773		268774		268775		268776		268777		268778		268779		268780		268781		268782		268783		268784		268785		268786		268787		268788		268789		268790		268792		268793		268794		268795		268796		268797		268799		268800		268801		268802		268803		268804		268805		268806		268807		268808		268809		425319		425320		425321		425322		425323		425324		425325		425326		268798		589649		589408		589412		639955		676924		683734		710673		781756		786183		784487		784487		787125		787167		773953		805864		805390		786183		821436		825172		871720		854436		871542		855659		908213		907059		784487		962904		945926		940442		964814		950714		978836		981351		979011		784487		1003317		996462		784487		999299		1005130		1028764		1030569		1019624		1044756		784487		1053978		1047075		1056665		1075891		1054764		1077275		1095701		1119638		1145094		1117357		1131984		1131984		1144653		1119638		1075891		1117357		1077275		1135241		1135250		1156811		1158662		1173578		784487		1189256		784487		1158662		1171485		1144653		1156811		1173578		1145094		1173660		1175452		1205547		1210245		1204449		1195275		1175452		1234407		1239525		1268898		1281988		1281624		1779820		1778961		1766081		1978694		1979488		1947611		1977135		1870033		1855839		1773214		784487		1956857		1957899		784487		1944275		1900861		1905492		1311801		1313060		1335539		1346906		1347542		1371602		1335225		1363373		1363615		1373745		784487		1402159		1397354		1421717		1420009		1434786		1398978		1444139		1444167		1464434		1453672		1435303		1461240		1452935		1474240		1489955		1490141		1491214		1474374		1492524		784487		1503446		1504526		1509025		1523385		1572649		1521877		1575900		1523385		1509025		1492524		1603710		1604221		1491214		1504526		1521877		1638357		1637000		1647355		1648690		1662931		1664016		1677392		1675439		1665744		1821205		1829088		1833722		1813808		1695663		1694637		784487		1689291		1930934		1916724		1901454		1705538		1684381		1703832		1708102		1892776		1893104		1867657		1874540		1878330		1740330		784487		1831094		1743662		1748142		1665744		1677392		1695663		1664016		1675439		1694637		1756903		1763294		784487		2238887		2433775		2296253		2394693		2257945		2403262		2215558		2307782		2263235		2205047		2310266		2375169		2016775		784487		2010609		2020044		2041014		2052238		2046776		2058000		2071812		2072764		2083040		2096160		2091937		2103160		2098067		2108613		2153135		2098067		2108613		2130004		2146578		2170527		2169243		2160775		2249875		2318581		2494198		2516482		2366578		2221883		2433780		2252619		2445198		2445213		2482919		2230766		784487		2267976		2298042		2523105		2307823		2236340		2268635		2521152		2342359		784487		2355007		2252690		2313221		784487		2424601		2430348		2632168		2676449		2687200		2701340		2621325		2643659		2672140		2672140		2565003		2549011		2598602		2717548		2718418		2648650		2725082		2680772		2616733		2585096		2688695		2608504		2669500		2676449		2718416		2691289		2748094		2669500		2735611		2742269		2741017		2742653		2727467
period_id		145		147		148		148		149		151		153		155		156		157		104		107		105		105		109		105		109		112		111		111		113		113		113		113		115		113		115		115		115		117		119		117		121		119		123		125		123		127		129		130		130		132		133		135		137		137		138		139		140		141		143		145		107		107		124		121		127		131		154		157		132		None		None		None		None		None		None		None		165		167		168		168		None		None		None		None		168		167		169		None		None		169		171		None		None		172		174		175		173		None		None		None		None		None		176		176		177		177		177		None		None		177		None		None		179		179		None		None		None		180		180		None		181		None		None		181		183		183		184		None		180		181		None		None		None		185		None		185		187		186		186		None		None		184		185		185		None		186		None		None		188		187		None		None		188		None		None		None		189		None		214		None		None		None		None		221		None		218		214		222		222		None		221		None		220		220		191		None		193		194		None		196		None		195		None		None		197		None		196		None		197		198		None		199		None		None		None		None		200		199		201		202		None		201		None		None		203		None		202		None		None		204		203		None		None		None		None		205		None		201		202		203		None		207		209		None		210		209		None		210		None		None		217		None		215		None		211		211		None		220		220		220		None		211		212		212		219		None		217		219		219		212		213		217		None		213		None		None		None		209		210		211		None		213		223		None		239		235		237		234		None		None		236		None		231		236		None		None		225		223		None		226		None		225		226		None		227		227		None		228		228		227		None		229		227		None		228		None		None		230		None		234		None		None		244		237		None		241		None		None		None		241		234		234		234		None		None		236		233		None		243		236		238		None		234		235		233		240		241		None		None		250		250		247		248		249		249		None		244		245		251		251		None		251		250		None		246		None		247		250		None		251		250		252		252		252		None		None		251		252
form_id		F420		F420		F420		F420		F420		F420		F420		F420		F420		F405		F410		F420		F420		F420		F420		F405		F405		F405		F420		F405		F420		F420		F405		F420		F420		F405		F420		F405		F405		F420		F420		F405		F420		F405		F420		F420		F405		F405		F420		F497		F420		F420		F420		F420		F420		F420		F420		F420		F420		F420		F420		F420		F405		F405		F420		F405		F420		F420		F420		F420		F420		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F410		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F410		F460		F460		F410		F460		F460		F410		F497		F460		F410		F460		F497		F460		F460		F410		F460		F410		F410		F460		F497		F460		F497		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F495		F460		F460		F460		F460		F410		F460		F410		F460		F410		F460		F460		F460		F460		F497		F460		F460		F497		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F410		F460		F410		F460		F460		F497		F497		F410		F497		F410		F410		F460		F497		F497		F460		F460		F460		F460		F460		F497		F460		F460		F460		F497		F410		F410		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F410		F410		F460		F497		F497		F460		F497		F460		F497		F460		F460		F460		F497		F497		F460		F410		F460		F460		F497		F460		F460		F460		F460		F460		F460		F410		F460		F410		F460		F460		F460		F460		F497		F460		F460		F497		F410		F460		F497		F410		F410		F410		F460		F460		F497		F460		F460		F460		F460		F497		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F497		F497		F410		F460		F460		F460		F460		F460		F497		F410		F460		F460		F460		F497		F460		F460		F460		F460		F410		F460		F460		F460		F410		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F497		F460		F497		F460		F497		F497		F460		F497		F497		F497		F497		F497		F460		F460		F460		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		1		0		0		0		0		0		1		0		0		0		0		0		0		0		0		2		0		0		0		0		0		0		0		0		3		0		0		4		0		0		0		0		0		0		5		0		0		0		0		0		0		0		0		0		0		1		0		0		1		1		1		1		0		0		0		0		1		7		0		6		1		0		1		1		0		1		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		13		0		0		12		0		0		0		0		0		0		0		0		0		0		0		0		0		8		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		9		0		0		0		0		0		0		0		1		1		1		0		0		1		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		10		0		0		0		0		0		0		0		0		0		0		0		0		0		0		11		0		0		0		1		1		1		1		1		1		0		0		14		0		0		0		0		0		0		0		0		0		0		0		0		0		15		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		17		0		0		0		0		0		0		0		0		18		0		0		0		16		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		1		0		0		0		0		0
filing_date		1996-07-10 00:00:00		1996-10-04 00:00:00		1996-10-24 00:00:00		1997-01-14 00:00:00		1997-07-11 00:00:00		1998-01-28 00:00:00		1998-05-20 00:00:00		1998-10-05 00:00:00		1999-01-25 00:00:00		1999-01-13 00:00:00		1985-12-19 00:00:00		1986-01-28 00:00:00		1986-11-04 00:00:00		1986-11-03 00:00:00		1987-07-13 00:00:00		1987-07-20 00:00:00		1987-10-28 00:00:00		1987-10-30 00:00:00		1988-01-11 00:00:00		1988-03-01 00:00:00		1988-03-22 00:00:00		1988-05-25 00:00:00		1988-06-07 00:00:00		1988-08-01 00:00:00		1988-10-05 00:00:00		1988-12-08 00:00:00		1989-01-27 00:00:00		1989-02-16 00:00:00		1989-07-03 00:00:00		1989-07-28 00:00:00		1990-01-29 00:00:00		1990-05-04 00:00:00		1990-07-12 00:00:00		1990-10-12 00:00:00		1991-01-11 00:00:00		1991-07-24 00:00:00		1991-08-01 00:00:00		1991-09-06 00:00:00		1992-05-18 00:00:00		1992-05-27 00:00:00		1992-07-23 00:00:00		1993-01-11 00:00:00		1993-07-20 00:00:00		1994-01-18 00:00:00		1994-03-23 00:00:00		1994-05-24 00:00:00		1994-07-18 00:00:00		1994-10-25 00:00:00		1995-01-23 00:00:00		1995-07-21 00:00:00		1996-01-12 00:00:00		1996-03-13 00:00:00		1986-07-14 00:00:00		1987-06-30 00:00:00		1990-10-23 00:00:00		1991-03-13 00:00:00		1992-01-29 00:00:00		1992-10-02 00:00:00		1998-07-24 00:00:00		1999-07-26 00:00:00		1992-10-21 00:00:00		2000-02-16 00:00:00		2000-01-26 00:00:00		2000-01-26 00:00:00		2000-07-14 00:00:00		2000-10-20 00:00:00		2000-10-17 00:00:00		2001-01-05 00:00:00		2001-09-15 00:00:00		2001-10-10 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2001-10-10 00:00:00		2001-10-01 00:00:00		2001-07-25 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-01-30 00:00:00		2002-02-20 00:00:00		2002-02-20 00:00:00		2002-10-07 00:00:00		2002-07-30 00:00:00		2002-10-07 00:00:00		2002-07-30 00:00:00		2003-01-27 00:00:00		2003-01-27 00:00:00		2003-06-24 00:00:00		2003-10-09 00:00:00		2003-07-29 00:00:00		2003-06-23 00:00:00		2003-10-10 00:00:00		2003-07-29 00:00:00		2003-11-04 00:00:00		2004-01-08 00:00:00		2004-01-08 00:00:00		2003-11-04 00:00:00		2004-02-27 00:00:00		2004-02-19 00:00:00		2004-03-25 00:00:00		2004-02-19 00:00:00		2004-02-27 00:00:00		2004-07-29 00:00:00		2004-07-29 00:00:00		2004-03-25 00:00:00		2004-10-05 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-10-05 00:00:00		2004-10-26 00:00:00		2005-01-26 00:00:00		2004-10-26 00:00:00		2005-01-26 00:00:00		2005-03-08 00:00:00		2005-07-29 00:00:00		2006-01-26 00:00:00		2005-07-29 00:00:00		2006-01-26 00:00:00		2005-10-27 00:00:00		2006-01-26 00:00:00		2005-10-27 00:00:00		2005-10-27 00:00:00		2005-10-27 00:00:00		2005-10-27 00:00:00		2005-10-27 00:00:00		2005-10-27 00:00:00		2006-03-21 00:00:00		2006-03-21 00:00:00		2006-07-28 00:00:00		2006-07-28 00:00:00		2006-07-28 00:00:00		2006-05-09 00:00:00		2006-05-24 00:00:00		2006-05-09 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-10-05 00:00:00		2006-10-23 00:00:00		2006-10-05 00:00:00		2006-07-28 00:00:00		2006-07-28 00:00:00		2007-01-29 00:00:00		2007-01-29 00:00:00		2006-10-23 00:00:00		2007-07-27 00:00:00		2007-07-27 00:00:00		2013-07-26 00:00:00		2013-07-26 00:00:00		2013-04-29 00:00:00		2015-07-27 00:00:00		2015-07-24 00:00:00		2015-02-19 00:00:00		2015-07-24 00:00:00		2014-07-28 00:00:00		2014-05-28 00:00:00		2013-06-28 00:00:00		2015-04-02 00:00:00		2015-04-08 00:00:00		2015-04-02 00:00:00		2015-02-19 00:00:00		2015-01-27 00:00:00		2014-10-20 00:00:00		2014-10-24 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-05-22 00:00:00		2008-07-28 00:00:00		2008-07-28 00:00:00		2008-10-24 00:00:00		2008-05-22 00:00:00		2008-10-06 00:00:00		2008-10-06 00:00:00		2008-10-24 00:00:00		2009-01-12 00:00:00		2009-01-12 00:00:00		2009-02-02 00:00:00		2009-04-29 00:00:00		2009-04-29 00:00:00		2009-07-28 00:00:00		2009-02-02 00:00:00		2009-08-28 00:00:00		2009-08-28 00:00:00		2010-01-27 00:00:00		2009-11-02 00:00:00		2009-07-28 00:00:00		2010-01-27 00:00:00		2009-11-02 00:00:00		2010-03-22 00:00:00		2010-05-25 00:00:00		2010-05-25 00:00:00		2010-05-27 00:00:00		2010-03-22 00:00:00		2010-05-27 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-28 00:00:00		2010-07-28 00:00:00		2010-10-04 00:00:00		2011-01-31 00:00:00		2010-10-04 00:00:00		2011-01-31 00:00:00		2011-04-11 00:00:00		2011-04-11 00:00:00		2011-04-11 00:00:00		2011-07-26 00:00:00		2011-07-26 00:00:00		2011-04-11 00:00:00		2011-04-11 00:00:00		2011-04-11 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00		2012-03-22 00:00:00		2012-03-22 00:00:00		2012-05-23 00:00:00		2012-05-24 00:00:00		2012-07-26 00:00:00		2012-07-26 00:00:00		2012-05-24 00:00:00		2014-01-27 00:00:00		2014-03-14 00:00:00		2014-03-21 00:00:00		2014-01-27 00:00:00		2012-10-05 00:00:00		2012-10-05 00:00:00		2012-08-16 00:00:00		2012-08-16 00:00:00		2015-01-27 00:00:00		2014-12-02 00:00:00		2014-10-21 00:00:00		2012-10-25 00:00:00		2012-08-10 00:00:00		2012-10-25 00:00:00		2012-10-30 00:00:00		2014-10-06 00:00:00		2014-10-06 00:00:00		2014-07-28 00:00:00		2014-08-06 00:00:00		2014-08-18 00:00:00		2013-01-31 00:00:00		2013-01-31 00:00:00		2014-03-21 00:00:00		2013-01-31 00:00:00		2013-02-15 00:00:00		2013-02-19 00:00:00		2013-02-19 00:00:00		2013-02-19 00:00:00		2013-02-19 00:00:00		2013-02-19 00:00:00		2013-02-19 00:00:00		2013-01-31 00:00:00		2013-04-29 00:00:00		2015-07-27 00:00:00		2018-04-25 00:00:00		2020-01-23 00:00:00		2018-09-26 00:00:00		2019-07-29 00:00:00		2018-05-31 00:00:00		2019-07-29 00:00:00		2018-01-24 00:00:00		2018-10-17 00:00:00		2018-06-29 00:00:00		2018-01-24 00:00:00		2018-10-22 00:00:00		2019-04-15 00:00:00		2016-02-17 00:00:00		2016-02-17 00:00:00		2016-01-29 00:00:00		2016-01-29 00:00:00		2016-05-09 00:00:00		2016-05-26 00:00:00		2016-05-26 00:00:00		2016-07-25 00:00:00		2016-07-25 00:00:00		2016-08-30 00:00:00		2016-09-29 00:00:00		2016-09-29 00:00:00		2016-10-19 00:00:00		2016-11-01 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2017-04-25 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-07-20 00:00:00		2017-07-20 00:00:00		2017-04-25 00:00:00		2018-05-16 00:00:00		2018-10-25 00:00:00		2020-07-31 00:00:00		2020-10-15 00:00:00		2019-03-12 00:00:00		2018-03-05 00:00:00		2020-01-23 00:00:00		2018-05-23 00:00:00		2020-01-23 00:00:00		2020-01-23 00:00:00		2020-07-29 00:00:00		2018-04-12 00:00:00		2018-06-29 00:00:00		2018-07-23 00:00:00		2018-09-26 00:00:00		2020-10-22 00:00:00		2018-10-17 00:00:00		2018-04-25 00:00:00		2018-07-23 00:00:00		2020-10-22 00:00:00		2019-01-28 00:00:00		2019-04-15 00:00:00		2019-01-28 00:00:00		2018-05-23 00:00:00		2018-10-25 00:00:00		2018-03-05 00:00:00		2019-12-11 00:00:00		2020-01-14 00:00:00		2021-10-28 00:00:00		2022-04-27 00:00:00		2022-05-26 00:00:00		2022-07-26 00:00:00		2021-10-28 00:00:00		2022-01-31 00:00:00		2022-07-26 00:00:00		2022-04-27 00:00:00		2021-01-28 00:00:00		2021-01-28 00:00:00		2021-07-28 00:00:00		2022-09-06 00:00:00		2022-09-08 00:00:00		2022-01-31 00:00:00		2022-09-28 00:00:00		2022-05-09 00:00:00		2021-07-29 00:00:00		2021-05-21 00:00:00		2022-05-26 00:00:00		2021-08-24 00:00:00		2022-04-22 00:00:00		2022-07-26 00:00:00		2022-09-08 00:00:00		2022-06-04 00:00:00		2022-10-31 00:00:00		2022-10-03 00:00:00		2022-10-18 00:00:00		2022-07-26 00:00:00		2022-09-28 00:00:00		2022-10-27 00:00:00		2022-10-03 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		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		10005		10005		10005		10005		10005		10005		10001		10001		10001		10002		10005		10002		10005		10005		10001		10002		10001		10005		10005		10001		10001		10005		10005		10001		10002		10001		10001		10002		10005		10005		10002		10005		10001		10002		10001		10001		10002		10005		10005		10001		10005		10002		10001		10002		10002		10005		10005		10001		10001		10005		10001		10005		10005		10001		10002		10001		10001		10006		10002		10002		10006		10005		10005		10001		10005		10002		10002		10001		10002		10006		10006		10002		10002		10001		10006		10001		10005		10005		10001		10001		10005		10006		10001		10005		10005		10005		10001		10005		10001		10005		10006		10005		10002		10001		10005		10001		10001		10002		10001		10006		10002		10005		10001		10001		10001		10005		10001		10001		10005		10001		10005		10001		10005		10005		10002		10006		10001		10005		10001		10001		10005		10001		10005		10005		10005		10005		10001		10001		10001		10001		10005		10001		10005		10005		10002		10006		10001		10005		10005		10001		10001		10005		10006		10006		10006		10001		10005		10002		10002		10002		10005		10001		10001		10005		10001		10001		10005		10001		10005		10005		10001		10005		10001		10005		10001		10002		10006		10001		10001		10001		10005		10001		10001		10001		10001		10005		10001		10001		10001		10001		10002		10001		10005		10001		10006		10006		10006		10002		10002		10002		10002		10001		10002		10005		10001		10001		10001		10001		10005		10005		10001		10005		10001		10001		10006		10006		10002		10001		10005		10001		10005		10001		10001		10005		10001		10001		10005		10001		10001		10001		10005		10001		10002		10006		10001		10005		10005		10001		10005		10001		10005		10005		10001		10001		10006		10001		10005		10005		10005		10001		10001		10002		10001		10005		10005		10001		10001		10005		10001		10001		10002		10005		10001		10001		10002		10001		10001		10005		10005		10001		10001		10001		10001		10002		10001		10005		10001		10001		10001		10001		10005		10001		10001		10005		10001		10005		10001		10001		10006		10001		10001		10001		10002		10001		10005		10005		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		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		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11003		11003		11003		11001		11003		11003		11001		11001		11001		11003		11003		11001		11003		11001		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11003		11003		11001		11001		11003		11001		11003		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
session_id		1995		1995		1995		1995		1997		1997		1997		1997		1997		1999		1985		1985		1985		1985		1987		1985		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1989		1989		1989		1989		1989		1989		1991		1989		1991		1991		1991		1991		1991		1993		1993		1993		1993		1993		1993		1993		1995		1995		1995		1985		1985		1989		1989		1991		1991		1997		1999		1991		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2003		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2013		2013		2013		2015		2015		2015		2015		2013		2013		2013		2015		2015		2015		2015		2013		2013		2013		2007		2007		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		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2011		2011		2011		2011		2013		2013		2013		2011		2011		2011		2011		2013		2013		2013		2013		2013		2011		2013		2013		2011		2013		2011		2011		2011		2011		2011		2011		2013		2013		2015		2017		2019		2017		2019		2017		2019		2017		2017		2017		2017		2017		2019		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2015		2015		2015		2015		2017		2017		2017		2017		2017		2019		2019		2019		2017		2019		2017		2019		2019		2019		2017		2017		2017		2017		2019		2017		2017		2017		2019		2017		2019		2017		2017		2017		2017		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		KCHAN		DHORRELL		TWALLS		DHORRELL		*		*		*		CFLAGG		TTHAM		SARRIAGA		CFLAGG		*		*		*		DBARRICK		GPEREZ		*		*		DBARRICK		DBARRICK		COMPLETED		COMPLETED		COMPLETED		COMPLETED		TTHAM		KVOONG1		GPEREZ		TTHAM		GGILMORE		COMPLETED		COMPLETED		COMPLETED		COMPLETED		COMPLETED		KLARRY		LLEONG		COMPLETED		CFLAGG		TTHAM		COMPLETED		COMPLETED		TTHAM		EMCENTEE		GPEREZ		COMPLETED		GKURIMOT		KVOONG1		COMPLETED		KVANG		CFLAGG		*		*		*		*		KVANG		*		*		KVANG		JGRISSUM		KVANG		*		SARRIAGA		*		*		*		*		KVANG		TTHAM		*		*		*		KVANG		*		SARRIAGA		SARRIAGA		DHORRELL		*		CFLAGG		KVANG		*		GPEREZ		DHORRELL		GPEREZ		*		MDIGRAZIA		MDIGRAZIA		MPACHECO		TRAMON		MDIGRAZIA		TRAMON		MDIGRAZIA		MDIGRAZIA		CAFILER		WBROWN		TRAMON		CAFILER		TRAMON		TRAMON		MDIGRAZIA		CAFILER		CAFILER		*		CFLAGG		*		*		SARRIAGA		PBANFORD		SARRIAGA		*		RGEREMIA		LTHIBAUL		*		RGEREMIA		*		SARRIAGA		*		MMORENO		JVAZQUEZ		DHORRELL		DHORRELL		CPON		CPON		MMORENO		CPON		CPON		MMORENO		DHORRELL		GKURIMOT		CPON		MMORENO		CPON		*		RGEREMIA		MMORENO		MMORENO		SMCCONNAN		SMCCONNAN		SMCCONNAN		SMCCONNAN		MPACHECO		MPACHECO		MPACHECO		MMORENO		MMORENO		*		*		*		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		PBANFORD		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		CAFILER		MDIGRAZIA		MDIGRAZIA		MPACHECO		CAFILER		TRAMON		TRAMON		MDIGRAZIA		CAFILER		CAFILER		MPACHECO		WBROWN		CAFILER		WBROWN		MDIGRAZIA		JINGRAM		MDIGRAZIA		CAFILER		CAFILER		CAFILER		TRAMON		MDIGRAZIA		MPACHECO		WBROWN		MPACHECO		MPACHECO		MPACHECO		MDIGRAZIA		CAFILER		CAFILER		TRAMON		MDIGRAZIA		TRAMON		CSAGABAEN		SUSHAKOV		MXIONG		HCOURSEY		CAFILER		HCOURSEY		HSTOVALL		CAFILER		TRAMON		HSTOVALL		CAFILER		TRAMON		DHOANG		DHOANG		MDIGRAZIA		MDIGRAZIA		PDEO		SMCCONNAN		SMCCONNAN		GPEREZ		GPEREZ		PDEO		GPEREZ		GPEREZ		GKURIMOT		GKURIMOT		BSINGH		BSINGH		HSTOVALL		CAFILER		MPACHECO		SARRIAGA		SARRIAGA		HSTOVALL		HSTOVALL		HSTOVALL		CAFILER		RPOOJA		IMEDINA		CAFILER		CAFILER		TRAMON		SUSHAKOV		BSINGH		SUSHAKOV		SUSHAKOV		IMEDINA		CAFILER		TRAMON		CSAGABAEN		MXIONG		IMEDINA		CAFILER		CSAGABAEN		CSAGABAEN		IMEDINA		LPHEAV		TRAMON		LPHEAV		BSINGH		RPOOJA		TRAMON		CAFILER		CAFILER		DCODY		KRUSSELL		CAFILER		CAFILER		DCODY		KRUSSELL		CAFILER		KRUSSELL		SUSHAKOV		SUSHAKOV		KRUSSELL		CAFILER		CAFILER		KRUSSELL		CAFILER		CAFILER		KRUSSELL		CAFILER		JMAVES		CAFILER		CAFILER		JMAVES		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		AXIONG		LPHEAV		CAFILER		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11003		11003		11001		11003		11001		11001		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		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		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		1996-03-10 00:00:00		1996-07-01 00:00:00		1996-10-01 00:00:00		1996-10-20 00:00:00		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-01-01 00:00:00		1998-07-01 00:00:00		1998-10-01 00:00:00		None		None		1986-07-01 00:00:00		1986-03-18 00:00:00		1986-01-01 00:00:00		1987-01-01 00:00:00		1986-01-01 00:00:00		1987-01-01 00:00:00		None		1987-07-01 00:00:00		1987-07-01 00:00:00		1988-01-01 00:00:00		1988-03-18 00:00:00		1988-01-01 00:00:00		1988-01-01 00:00:00		1988-07-01 00:00:00		1988-01-01 00:00:00		1988-07-01 00:00:00		1988-07-01 00:00:00		1988-07-01 00:00:00		1989-01-01 00:00:00		1989-07-01 00:00:00		1989-01-01 00:00:00		1990-01-01 00:00:00		1989-07-01 00:00:00		1990-07-01 00:00:00		1991-01-01 00:00:00		1990-07-01 00:00:00		None		1992-01-01 00:00:00		None		1992-05-17 00:00:00		1992-10-18 00:00:00		1993-01-01 00:00:00		1993-07-01 00:00:00		1994-01-01 00:00:00		1994-03-18 00:00:00		1994-05-22 00:00:00		1994-07-01 00:00:00		1994-10-23 00:00:00		1995-01-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		None		1986-07-01 00:00:00		1990-10-01 00:00:00		1990-01-01 00:00:00		1991-07-01 00:00:00		1992-07-01 00:00:00		1998-05-17 00:00:00		1999-01-01 00:00:00		1992-10-01 00:00:00		2000-01-23 00:00:00		1999-07-01 00:00:00		2000-01-01 00:00:00		2000-02-24 00:00:00		2000-10-01 00:00:00		2000-07-01 00:00:00		2000-10-22 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		None		2001-01-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2002-02-17 00:00:00		2002-07-01 00:00:00		2002-02-17 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2003-06-24 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		None		2003-07-01 00:00:00		2003-01-01 00:00:00		None		2003-10-01 00:00:00		2003-10-01 00:00:00		2003-11-04 00:00:00		2004-02-27 00:00:00		2004-01-01 00:00:00		2004-03-25 00:00:00		2004-01-01 00:00:00		None		2004-02-15 00:00:00		2004-02-15 00:00:00		None		2004-07-01 00:00:00		2004-09-30 00:00:00		None		2004-07-01 00:00:00		None		2004-10-01 00:00:00		2004-10-26 00:00:00		2004-10-01 00:00:00		2005-03-08 00:00:00		2005-01-01 00:00:00		2005-10-23 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2005-10-23 00:00:00		2005-01-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2004-10-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-07-28 00:00:00		2006-05-21 00:00:00		2006-05-09 00:00:00		2006-01-01 00:00:00		None		2005-10-23 00:00:00		2006-01-01 00:00:00		2006-03-18 00:00:00		2005-10-23 00:00:00		2006-05-24 00:00:00		2006-03-18 00:00:00		2006-07-01 00:00:00		2006-10-23 00:00:00		2006-07-01 00:00:00		2006-05-21 00:00:00		2006-03-18 00:00:00		2006-10-01 00:00:00		2006-10-01 00:00:00		None		2007-01-01 00:00:00		2007-01-01 00:00:00		2013-04-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		None		2015-01-01 00:00:00		None		2015-01-01 00:00:00		2014-03-18 00:00:00		2014-05-28 00:00:00		2013-06-28 00:00:00		2015-04-02 00:00:00		2015-04-08 00:00:00		None		2015-02-19 00:00:00		2014-10-01 00:00:00		2014-10-20 00:00:00		2014-10-24 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-05-18 00:00:00		2008-05-18 00:00:00		2008-10-24 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		None		2009-01-12 00:00:00		None		2008-10-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2008-10-01 00:00:00		2009-08-28 00:00:00		None		2009-10-01 00:00:00		2009-07-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-05-25 00:00:00		None		2010-03-18 00:00:00		2010-01-01 00:00:00		2010-03-18 00:00:00		2010-07-21 00:00:00		None		2010-05-23 00:00:00		2010-05-23 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2010-07-01 00:00:00		2010-05-23 00:00:00		2010-03-18 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2010-03-18 00:00:00		2010-05-23 00:00:00		2010-07-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-05-23 00:00:00		2012-03-18 00:00:00		2012-05-20 00:00:00		2012-05-20 00:00:00		2012-03-18 00:00:00		2013-07-01 00:00:00		2014-03-14 00:00:00		2014-01-01 00:00:00		2013-07-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2012-08-16 00:00:00		None		2014-10-01 00:00:00		2014-12-02 00:00:00		2014-10-21 00:00:00		2012-10-01 00:00:00		2012-08-10 00:00:00		2012-10-01 00:00:00		2012-10-30 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2014-03-18 00:00:00		2014-08-06 00:00:00		2014-08-18 00:00:00		2012-10-21 00:00:00		2013-01-31 00:00:00		2014-01-01 00:00:00		2012-10-21 00:00:00		2013-02-15 00:00:00		2012-03-18 00:00:00		2012-05-20 00:00:00		2012-07-01 00:00:00		2012-03-18 00:00:00		2012-05-20 00:00:00		2012-07-01 00:00:00		None		2013-01-01 00:00:00		2015-07-27 00:00:00		2018-01-01 00:00:00		2019-07-01 00:00:00		2018-07-01 00:00:00		2019-01-01 00:00:00		2018-05-31 00:00:00		2019-01-01 00:00:00		2017-07-01 00:00:00		2018-10-17 00:00:00		None		2017-07-01 00:00:00		2018-10-22 00:00:00		None		None		2016-02-17 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-05-09 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-05-22 00:00:00		2016-05-22 00:00:00		2016-08-30 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2016-10-19 00:00:00		2016-11-01 00:00:00		2016-09-25 00:00:00		2016-09-25 00:00:00		2017-01-01 00:00:00		2016-09-25 00:00:00		2016-09-25 00:00:00		2016-10-23 00:00:00		2016-10-23 00:00:00		2017-04-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2018-05-16 00:00:00		2018-09-23 00:00:00		2020-01-19 00:00:00		2020-10-15 00:00:00		2019-03-12 00:00:00		None		2020-01-01 00:00:00		2018-04-22 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2020-01-19 00:00:00		2018-04-12 00:00:00		2018-06-29 00:00:00		2018-05-20 00:00:00		2018-07-01 00:00:00		2020-07-01 00:00:00		2018-10-17 00:00:00		2018-01-01 00:00:00		2018-05-20 00:00:00		2020-07-01 00:00:00		2018-10-21 00:00:00		2019-04-15 00:00:00		2018-10-21 00:00:00		2018-04-22 00:00:00		2018-09-23 00:00:00		2018-03-05 00:00:00		2019-12-11 00:00:00		2020-01-14 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2022-04-24 00:00:00		2022-05-22 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2020-10-18 00:00:00		2020-10-18 00:00:00		2021-01-01 00:00:00		2022-09-06 00:00:00		2022-09-08 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00		2022-05-10 00:00:00		2021-01-01 00:00:00		2021-05-21 00:00:00		2022-04-24 00:00:00		2021-08-24 00:00:00		2022-04-22 00:00:00		2022-01-01 00:00:00		2022-09-07 00:00:00		2022-06-04 00:00:00		2022-10-31 00:00:00		2022-10-03 00:00:00		2022-10-18 00:00:00		2022-05-22 00:00:00		2022-07-01 00:00:00		2022-09-25 00:00:00		2022-10-03 00:00:00
rpt_end		1996-06-30 00:00:00		1996-09-30 00:00:00		1996-10-19 00:00:00		1996-12-31 00:00:00		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-05-16 00:00:00		1998-09-30 00:00:00		1998-12-31 00:00:00		None		None		1986-12-31 00:00:00		1986-05-17 00:00:00		1986-06-30 00:00:00		1987-06-30 00:00:00		1986-06-30 00:00:00		1987-06-30 00:00:00		None		1987-12-31 00:00:00		1987-12-31 00:00:00		1988-03-17 00:00:00		1988-05-21 00:00:00		1988-03-17 00:00:00		1988-07-31 00:00:00		1988-09-30 00:00:00		1988-06-30 00:00:00		1988-12-31 00:00:00		1988-09-30 00:00:00		1988-12-31 00:00:00		1989-06-30 00:00:00		1989-12-31 00:00:00		1989-06-30 00:00:00		1990-06-30 00:00:00		1989-12-31 00:00:00		1990-12-31 00:00:00		1991-06-30 00:00:00		1990-10-20 00:00:00		None		1992-05-16 00:00:00		None		1992-06-30 00:00:00		1992-12-31 00:00:00		1993-06-30 00:00:00		1993-12-31 00:00:00		1994-03-17 00:00:00		1994-05-21 00:00:00		1994-06-30 00:00:00		1994-10-22 00:00:00		1994-12-31 00:00:00		1995-06-30 00:00:00		1995-12-31 00:00:00		1996-03-09 00:00:00		None		1986-12-31 00:00:00		1990-10-20 00:00:00		1990-06-30 00:00:00		1991-12-31 00:00:00		1992-09-30 00:00:00		1998-06-30 00:00:00		1999-06-30 00:00:00		1992-10-17 00:00:00		2000-02-24 00:00:00		1999-12-31 00:00:00		2000-01-22 00:00:00		2000-06-30 00:00:00		2000-10-21 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2001-09-30 00:00:00		None		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2002-02-16 00:00:00		2002-02-16 00:00:00		2002-09-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-06-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-06-24 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		None		2003-09-30 00:00:00		2003-06-30 00:00:00		None		2003-12-31 00:00:00		2003-12-31 00:00:00		2003-11-04 00:00:00		2004-02-27 00:00:00		2004-02-14 00:00:00		2004-03-25 00:00:00		2004-02-14 00:00:00		None		2004-06-30 00:00:00		2004-06-30 00:00:00		None		2004-09-30 00:00:00		2004-09-30 00:00:00		None		2004-09-30 00:00:00		None		2004-12-31 00:00:00		2004-10-26 00:00:00		2004-12-31 00:00:00		2005-03-08 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-06-30 00:00:00		2005-10-22 00:00:00		2005-10-22 00:00:00		2005-12-31 00:00:00		2005-06-30 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2004-12-31 00:00:00		2005-10-22 00:00:00		2005-10-22 00:00:00		2006-03-17 00:00:00		2006-03-17 00:00:00		2006-05-20 00:00:00		2006-07-28 00:00:00		2006-06-30 00:00:00		2006-05-09 00:00:00		2006-03-17 00:00:00		None		2005-12-31 00:00:00		2006-03-17 00:00:00		2006-05-20 00:00:00		2005-12-31 00:00:00		2006-05-24 00:00:00		2006-05-20 00:00:00		2006-09-30 00:00:00		2006-10-23 00:00:00		2006-09-30 00:00:00		2006-06-30 00:00:00		2006-05-20 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		None		2007-06-30 00:00:00		2007-06-30 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		None		2015-06-30 00:00:00		None		2015-06-30 00:00:00		2014-06-30 00:00:00		2014-05-28 00:00:00		2013-06-28 00:00:00		2015-04-02 00:00:00		2015-04-08 00:00:00		None		2015-02-19 00:00:00		2014-12-31 00:00:00		2014-10-20 00:00:00		2014-10-24 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2008-05-17 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-10-24 00:00:00		2008-05-17 00:00:00		2008-09-30 00:00:00		2008-09-30 00:00:00		None		2009-01-12 00:00:00		None		2008-12-31 00:00:00		2009-03-31 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2008-12-31 00:00:00		2009-08-28 00:00:00		None		2009-12-31 00:00:00		2009-09-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-09-30 00:00:00		2010-03-17 00:00:00		2010-05-25 00:00:00		None		2010-05-22 00:00:00		2010-03-17 00:00:00		2010-05-22 00:00:00		2010-07-21 00:00:00		None		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-05-22 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-03-17 00:00:00		2012-03-17 00:00:00		2012-05-23 00:00:00		2012-05-19 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2012-05-19 00:00:00		2013-12-31 00:00:00		2014-03-14 00:00:00		2014-03-17 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2012-08-16 00:00:00		None		2014-12-31 00:00:00		2014-12-02 00:00:00		2014-10-21 00:00:00		2012-10-20 00:00:00		2012-08-10 00:00:00		2012-10-20 00:00:00		2012-10-30 00:00:00		2014-09-30 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2014-08-06 00:00:00		2014-08-18 00:00:00		2012-12-31 00:00:00		2013-01-31 00:00:00		2014-03-17 00:00:00		2012-12-31 00:00:00		2013-02-15 00:00:00		2012-05-19 00:00:00		2012-06-30 00:00:00		2012-09-30 00:00:00		2012-05-19 00:00:00		2012-06-30 00:00:00		2012-09-30 00:00:00		None		2013-03-31 00:00:00		2015-07-27 00:00:00		2018-04-21 00:00:00		2019-12-31 00:00:00		2018-09-22 00:00:00		2019-06-30 00:00:00		2018-05-31 00:00:00		2019-06-30 00:00:00		2017-12-31 00:00:00		2018-10-17 00:00:00		None		2017-12-31 00:00:00		2018-10-22 00:00:00		None		None		2016-02-17 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-05-09 00:00:00		2016-05-21 00:00:00		2016-05-21 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-08-30 00:00:00		2016-09-24 00:00:00		2016-09-24 00:00:00		2016-10-19 00:00:00		2016-11-01 00:00:00		2016-10-22 00:00:00		2016-10-22 00:00:00		2017-03-31 00:00:00		2016-10-22 00:00:00		2016-10-22 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2018-05-16 00:00:00		2018-10-20 00:00:00		2020-06-30 00:00:00		2020-10-15 00:00:00		2019-03-12 00:00:00		None		2020-01-18 00:00:00		2018-05-19 00:00:00		2019-12-31 00:00:00		2020-01-18 00:00:00		2020-06-30 00:00:00		2018-04-12 00:00:00		2018-06-29 00:00:00		2018-06-30 00:00:00		2018-09-22 00:00:00		2020-10-17 00:00:00		2018-10-17 00:00:00		2018-04-21 00:00:00		2018-06-30 00:00:00		2020-10-17 00:00:00		2018-12-31 00:00:00		2019-04-15 00:00:00		2018-12-31 00:00:00		2018-05-19 00:00:00		2018-10-20 00:00:00		2018-03-05 00:00:00		2019-12-11 00:00:00		2020-01-14 00:00:00		2021-09-30 00:00:00		2022-04-23 00:00:00		2022-05-21 00:00:00		2022-06-30 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2022-04-23 00:00:00		2022-04-23 00:00:00		2020-12-31 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2022-09-06 00:00:00		2022-09-08 00:00:00		2021-12-31 00:00:00		2022-09-24 00:00:00		2022-05-10 00:00:00		2021-06-30 00:00:00		2021-05-21 00:00:00		2022-05-21 00:00:00		2021-08-24 00:00:00		2022-04-22 00:00:00		2022-04-23 00:00:00		2022-09-07 00:00:00		2022-06-04 00:00:00		2022-10-31 00:00:00		2022-10-03 00:00:00		2022-10-18 00:00:00		2022-06-30 00:00:00		2022-09-24 00:00:00		2022-10-22 00:00:00		2022-10-03 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		2001-09-15 00:00:00		2001-10-10 00:00:00		None		None		None		None		None		None		2002-01-10 00:00:00		2002-01-30 00:00:00		2002-02-20 00:00:00		None		None		2002-07-30 00:00:00		2002-10-07 00:00:00		None		None		2003-01-27 00:00:00		None		2003-10-09 00:00:00		2003-07-29 00:00:00		None		None		None		None		None		2004-01-08 00:00:00		None		2004-02-27 00:00:00		2004-02-19 00:00:00		None		None		None		2004-07-29 00:00:00		None		None		2004-10-05 00:00:00		None		None		None		None		2005-01-26 00:00:00		2004-10-26 00:00:00		None		2005-03-08 00:00:00		None		None		2005-07-29 00:00:00		2006-01-26 00:00:00		2005-10-27 00:00:00		2006-01-26 00:00:00		None		2005-10-27 00:00:00		2005-10-27 00:00:00		None		None		None		2006-03-21 00:00:00		None		2006-07-31 00:00:00		None		2006-07-31 00:00:00		None		None		None		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		None		2006-05-24 00:00:00		None		None		2006-10-23 00:00:00		2006-10-05 00:00:00		None		None		2007-01-29 00:00:00		None		None		None		2007-07-27 00:00:00		None		2013-07-26 00:00:00		None		None		None		None		2015-07-24 00:00:00		None		2014-05-28 00:00:00		2013-06-28 00:00:00		None		2015-04-08 00:00:00		None		None		None		2014-10-20 00:00:00		2014-10-24 00:00:00		2008-01-31 00:00:00		None		2008-05-22 00:00:00		2008-07-28 00:00:00		None		2008-10-24 00:00:00		None		2008-10-06 00:00:00		None		None		None		None		2009-02-02 00:00:00		None		2009-04-29 00:00:00		2009-07-28 00:00:00		None		2009-08-28 00:00:00		None		None		None		None		2010-01-27 00:00:00		2009-11-02 00:00:00		2010-03-22 00:00:00		2010-05-25 00:00:00		None		2010-05-27 00:00:00		None		None		None		None		2010-07-28 00:00:00		None		None		2011-01-31 00:00:00		2010-10-04 00:00:00		None		None		None		None		2011-07-26 00:00:00		None		2011-04-11 00:00:00		2011-04-11 00:00:00		2011-04-11 00:00:00		None		2012-01-31 00:00:00		2012-03-22 00:00:00		None		2012-05-23 00:00:00		2012-05-24 00:00:00		None		2012-07-26 00:00:00		None		None		2014-03-14 00:00:00		None		2014-01-27 00:00:00		None		2012-10-05 00:00:00		None		None		2015-01-27 00:00:00		2014-12-02 00:00:00		2014-10-21 00:00:00		None		2012-08-10 00:00:00		2012-10-25 00:00:00		2012-10-30 00:00:00		2014-10-06 00:00:00		None		2014-07-28 00:00:00		2014-08-06 00:00:00		2014-08-18 00:00:00		2013-01-31 00:00:00		None		2014-03-21 00:00:00		None		2013-02-15 00:00:00		None		None		None		2013-02-15 00:00:00		2013-02-15 00:00:00		2013-02-15 00:00:00		None		2013-04-24 00:00:00		None		None		2020-01-22 00:00:00		2018-09-26 00:00:00		2019-07-25 00:00:00		2018-05-31 00:00:00		None		None		2018-10-17 00:00:00		None		2018-01-24 00:00:00		2018-10-22 00:00:00		None		None		None		2016-01-29 00:00:00		None		2016-05-09 00:00:00		None		2016-05-26 00:00:00		2016-07-25 00:00:00		None		2016-08-30 00:00:00		2016-09-29 00:00:00		None		2016-10-19 00:00:00		2016-11-01 00:00:00		2016-10-27 00:00:00		None		2017-04-25 00:00:00		2017-01-31 00:00:00		None		2017-01-31 00:00:00		None		None		2017-07-20 00:00:00		None		2018-05-16 00:00:00		None		None		2020-10-15 00:00:00		2019-03-12 00:00:00		None		2020-01-22 00:00:00		None		None		None		2020-07-29 00:00:00		2018-04-12 00:00:00		None		2018-07-23 00:00:00		None		None		2018-10-17 00:00:00		2018-04-25 00:00:00		None		2020-10-22 00:00:00		2019-01-28 00:00:00		None		None		2018-05-23 00:00:00		2018-10-25 00:00:00		None		2019-12-11 00:00:00		2020-01-14 00:00:00		None		None		2022-05-26 00:00:00		2022-07-25 00:00:00		2021-10-21 00:00:00		2022-01-28 00:00:00		2022-07-25 00:00:00		2022-04-26 00:00:00		None		2021-01-19 00:00:00		2021-07-27 00:00:00		2022-09-06 00:00:00		2022-09-08 00:00:00		None		2022-09-28 00:00:00		2022-05-10 00:00:00		None		2021-05-21 00:00:00		None		2021-08-24 00:00:00		2022-04-22 00:00:00		None		2022-09-07 00:00:00		2022-06-04 00:00:00		2022-10-31 00:00:00		2022-10-03 00:00:00		2022-10-18 00:00:00		None		None		2022-10-24 00:00:00		2022-10-03 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		22001		22001		22001		22001		None		None		None		None		None		22001		22001		22001		22001		22001		None		None		22001		None		None		22001		22001		None		None		None		22001		22001		None		22001		None		None		22001		22001		22001		22001		None		22001		22001		None		None		None		22001		None		22001		22001		22001		22001		None		None		22001		22001		22001		None		22001		None		None		22001		22001		None		None		22001		None		None		None		22001		None		22001		None		None		None		None		22001		None		22001		22001		22001		22001		None		22001		None		22001		22001		22001		None		22001		22001		None		22001		None		22001		None		None		22001		None		22001		None		22001		22001		None		22001		None		None		None		None		22001		22001		22001		22001		None		22001		None		None		22001		None		22001		None		None		22001		22001		None		None		None		None		22001		None		22001		22001		22001		None		22001		22001		None		22001		22001		None		22001		None		None		22001		None		22001		None		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		None		None		None		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		None		None		22001		None		22001		22001		None		None		22001		22001		None		22001		None		22001		22001		None		22001		22001		None		22001		22001		22001		None		22001		22001		None		22001		None		None		22001		None		22001		None		None		22001		22001		None		22001		None		None		None		22001		22001		22001		22001		None		None		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		None		22001		None		22001		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001

Table: filer_to_filer_type

filer_id		1040629		1040629		1040629
filer_type		16		16		16
active		Y		Y		Y
race		0		0		0
session_id		1985		2003		2009
category		0		0		0
category_type		40502		40502		40502
sub_category		40103		40103		40103
effect_dt		1985-12-19 00:00:00		2004-09-30 00:00:00		2010-07-21 00:00:00
sub_category_type		0		40203		40203
election_type		0		0		0
sub_category_a		S		S		S
nyq_dt		1986-04-05 00:00:00		1986-04-05 00:00:00		1986-04-05 00:00:00
party_cd		None		None		0
county_cd		18026		18026		18004
district_cd		None		None		None

Table: filer_xref

filer_id		1040629
xref_id		851706
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706		851706
filer_id		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629
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
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
effect_dt		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00		2010-07-21 00:00:00
naml		WESTERN STATES COUNCIL OF SHEET METAL WORKERS PAC		WESTERN STATES COUNCIL OF SHEET METAL WORKERS PAC		WESTERN STATES COUNCIL OF SHEET METAL WORKERS PAC		WESTERN STATES COUNCIL OF SHEET METAL WORKERS PAC		WESTERN STATES COUNCIL OF SHEET METAL WORKERS PAC		WESTERN STATES COUNCIL OF SHEET METAL WORKERS PAC		WESTERN STATES COUNCIL OF SHEET METAL WORKERS PAC		WESTERN STATES COUNCIL OF SHEET METAL WORKERS PAC		WESTERN STATES COUNCIL OF SHEET METAL WORKERS PAC		WESTERN STATES COUNCIL OF SHEET METAL WORKERS PAC		WESTERN STATES COUNCIL OF SHEET METAL WORKERS PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES COUNCIL OF SHEET METAL WORKERS P.A.C.		WESTERN STATES COUNCIL OF SHEET METAL WORKERS P.A.C.		WESTERN STATES COUNCIL OF SHEET METAL WORKERS P.A.C.		WESTERN STATES COUNCIL OF SHEET METAL WORKERS P.A.C.		WESTERN STATES COUNCIL OF SHEET METAL WORKERS P.A.C.		WESTERN STATES COUNCIL OF SHEET METAL WORKERS P.A.C.		WESTERN STATES COUNCIL OF SHEET METAL WORKERS P.A.C.		WESTERN STATES COUNCIL OF SHEET METAL WORKERS P.A.C.		WESTERN STATES COUNCIL OF SHEET METAL WORKERS P.A.C.		WESTERN STATES COUNCIL OF SHEET METAL WORKERS P.A.C.		WESTERN STATES COUNCIL OF SHEET METAL WORKERS P.A.C.		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC		WESTERN STATES PAC
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
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
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
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
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
city		FAIR OAKS		SPARKS		CITRUS HEIGHTS		RENO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		FAIR OAKS		SPARKS		CITRUS HEIGHTS		RENO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		FAIR OAKS		SPARKS		CITRUS HEIGHTS		RENO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		FAIR OAKS		SPARKS		CITRUS HEIGHTS		RENO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		NV		CA		NV		CA		CA		CA		CA		CA		CA		CA		CA		NV		CA		NV		CA		CA		CA		CA		CA		CA		CA		CA		NV		CA		NV		CA		CA		CA		CA		CA		CA		CA		CA		NV		CA		NV		CA		CA		CA		CA		CA		CA		CA
zip4		956280000		89431		95610		895109513		95814		95811		95814		95814		95811		95834		95814		956280000		89431		95610		895109513		95814		95811		95814		95814		95811		95834		95814		956280000		89431		95610		895109513		95814		95811		95814		95814		95811		95834		95814		956280000		89431		95610		895109513		95814		95811		95814		95814		95811		95834		95814
phon		9169651557		7753511314		9169651557		7753511314		7753511314		9163397359		9163397359		9163397359		9163397359		9163397359		9163397359		9169651557		7753511314		9169651557		7753511314		7753511314		9163397359		9163397359		9163397359		9163397359		9163397359		9163397359		9169651557		7753511314		9169651557		7753511314		7753511314		9163397359		9163397359		9163397359		9163397359		9163397359		9163397359		9169651557		7753511314		9169651557		7753511314		7753511314		9163397359		9163397359		9163397359		9163397359		9163397359		9163397359
fax		None		None		None		None		None		None		None		9164421280		9164421280		9164421280		9164421280		None		None		None		None		None		None		None		9164421280		9164421280		9164421280		9164421280		None		None		None		None		None		None		None		9164421280		9164421280		9164421280		9164421280		None		None		None		None		None		None		None		9164421280		9164421280		9164421280		9164421280
email		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1040629

Table: received_filings

filer_id		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629		1040629
filing_file_name		781756_0.cal		786183_0.cal		784487_0.cal		784487_1.cal		805390_0.cal		786183_1.cal		821436_0.cal		854436_0.cal		871542_0.cal		907059_0.cal		784487_2.cal		962904_0.cal		945926_0.cal		784487_3.cal		979011_0.cal		1003317_0.cal		784487_4.cal		784487_5.cal		1054764_0.cal		1095701_0.cal		14854.cal		784487_6.cal		1173660_0.cal		784487_7.cal		1210245_0.cal		1444139_0.cal		1371602_0.cal		1662931_0.cal		1829088_0.cal		239524.cal		239585.cal		240750.cal		1708102_0.cal		1855839_0.cal		2103160_0.cal		1878330_0.cal		1874540_0.cal		2091937_0.cal		1901454_0.cal		1900861_0.cal		1916724_0.cal		1905492_0.cal		2041014_0.cal		1956857_0.cal		2424601_0.cal		2257945_0.cal		2307782_0.cal		2430348_0.cal		2310266_0.cal		2249875_0.cal		2230766_0.cal		2307823_0.cal		2718418_0.cal		2717548_0.cal		2718416_0.cal		2608504_0.cal		2669500_1.cal		2585096_0.cal		2669500_0.cal		2516482_0.cal		2748094_0.cal		508562.cal		2735611_0.cal		2680772_0.cal		2727467_0.cal		2691289_0.cal
received_date		2001-09-15 00:00:00		2001-10-10 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-01-10 00:00:00		2002-01-30 00:00:00		2002-02-20 00:00:00		2002-07-30 00:00:00		2002-10-07 00:00:00		2003-01-27 00:00:00		2003-06-24 00:00:00		2003-10-09 00:00:00		2003-07-29 00:00:00		2003-11-04 00:00:00		2004-01-08 00:00:00		2004-02-27 00:00:00		2004-03-25 00:00:00		2004-09-30 00:00:00		2004-10-26 00:00:00		2005-03-08 00:00:00		2006-01-26 00:00:00		2006-05-09 00:00:00		2006-05-24 00:00:00		2006-07-28 00:00:00		2006-10-23 00:00:00		2009-08-28 00:00:00		2008-10-24 00:00:00		2012-05-23 00:00:00		2014-03-14 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2012-10-30 00:00:00		2014-05-28 00:00:00		2016-11-01 00:00:00		2014-08-18 00:00:00		2014-08-06 00:00:00		2016-10-19 00:00:00		2014-10-21 00:00:00		2014-10-20 00:00:00		2014-12-02 00:00:00		2014-10-24 00:00:00		2016-05-09 00:00:00		2015-04-08 00:00:00		2019-12-11 00:00:00		2018-05-31 00:00:00		2018-10-17 00:00:00		2020-01-14 00:00:00		2018-10-22 00:00:00		2018-05-16 00:00:00		2018-04-12 00:00:00		2018-10-17 00:00:00		2022-09-08 00:00:00		2022-09-06 00:00:00		2022-09-08 00:00:00		2021-08-24 00:00:00		2022-10-03 00:00:00		2021-05-21 00:00:00		2022-04-22 00:00:00		2020-10-15 00:00:00		2022-10-31 00:00:00		2022-04-28 00:00:00		2022-10-18 00:00:00		2022-05-09 00:00:00		2022-10-03 00:00:00		2022-06-04 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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/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		/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
filing_id		781756		786183		784487		784487		805390		786183		821436		854436		871542		907059		784487		962904		945926		784487		979011		1003317		784487		784487		1054764		1095701		None		784487		1173660		784487		1210245		1444139		1371602		1662931		1829088		None		None		None		1708102		1855839		2103160		1878330		1874540		2091937		1901454		1900861		1916724		1905492		2041014		1956857		2424601		2257945		2307782		2430348		2310266		2249875		2230766		2307823		2718418		2717548		2718416		2608504		2669500		2585096		2669500		2516482		2748094		None		2735611		2680772		2727467		2691289
form_id		F460		F460		F410		F410		F460		F460		F460		F460		F460		F460		F410		F460		F460		F410		F460		F497		F410		F410		F497		F497		None		F410		F497		F410		F497		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		F497		F497		F497		F497		None		F497		F497		F497		F497
receive_comment		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		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, but with warnings		Filing accepted, but with warnings		Filing accepted		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 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		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted