Home

Filer ID: 1042702

Table: filer_acronyms

acronym		IBEW LOCAL 100 COPE
filer_id		1042702

Table: filer_address

filer_id		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702
adrid		1041480		1041481		2061705		2061707		2099079		2099080		2492322		2213714
effect_dt		1998-08-26 00:00:00		1989-02-06 00:00:00		1986-09-23 00:00:00		2004-01-07 00:00:00		1985-06-01 00:00:00		1985-06-01 00:00:00		2020-01-15 00:00:00		2011-02-22 00:00:00
add_type		7082		7051		7051		7051		7051		7082		7051		7051
session_id		1997		1989		1985		2003		1985		1985		2019		2011

Table: filer_filings

filer_id		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702
filing_id		279569		279570		279571		279572		279573		279574		279575		279576		279577		279578		279579		279580		279581		279582		279583		279584		279585		279586		279587		279588		279589		279590		279591		279592		279593		279594		279595		279596		279597		279598		279600		279601		279602		279603		279604		279605		279606		279607		279608		279609		279610		279611		279612		279613		279614		279565		279566		279567		279568		279615		279616		279617		279618		279619		279620		279621		279622		279623		279624		426861		426862		426863		426864		426865		426866		426867		426868		426869		279599		588240		581500		597180		648627		673939		681483		723983		774144		787451		812011		804949		827461		868789		860694		827461		877047		891136		857193		870786		906646		916293		962001		944797		950959		963023		985292		978837		983073		983280		977863		1025933		998550		1026709		993881		1046012		1052995		1044133		1048391		1074741		1077495		1113629		1110066		1115150		1145656		1104868		1158341		1129575		1135311		1149947		1156046		1154392		1172834		1176033		1186329		1205442		1209857		1194648		1203169		1230865		1220028		1214463		1256617		1285685		1281067		1237805		1263122		1307145		1273361		1295468		1304718		1787898		1786819		1871982		1937509		1940977		1319898		1298428		1322622		1333663		1333081		1346403		1347557		1370787		1361927		1367209		1360972		1391632		1393599		1419651		1295468		1304718		1319898		1333081		1346403		1360972		1367209		1418773		1433638		1418773		1441315		1441318		1298428		1307145		1322622		1370787		1347557		1333663		1419651		1453701		1391632		1453701		1441315		1468304		1473458		1464043		1433638		1452088		1452088		1490025		1475621		1506859		1510108		1521372		1493286		1523436		1562302		1154392		1560389		1583889		1608837		1612095		1637563		1641311		1677294		1817909		1683925		1877609		1741766		1823123		1750029		1982235		1987610		2528011		2491711		2314340		2362153		2402731		2349864		2022199		2010686		2063907		1787898		1937509		1982235		1608837		1637563		1677294		1741766		1817909		1871982		2063907		2077250		1786819		1750029		1683925		1641311		1612095		2077250		2022199		2010686		2147970		1987610		1940977		1877609		1823123		2130104		2173713		2178404		2349541		2394184		2360665		2216684		2503116		2508898		2289375		2437229		2272775		2210818		2285926		2358387		2348574		2453566		2349864		2394184		2448331		2432027		2543239		2446972		2334563		2462019		2453569		2269131		2634830		2650785		2479902		2689865		2676333		2517866		2669178		2703073		2667187		2491711		2565321		2650785		2724804		2594160		2595650		2743675		2734051		2751711
period_id		108		110		110		113		113		114		113		116		116		116		117		119		119		117		121		121		122		123		122		121		124		124		124		125		127		129		129		131		132		129		133		134		137		137		138		139		139		140		141		143		145		145		145		147		148		134		107		107		108		148		149		151		153		153		154		155		155		156		156		105		111		115		117		132		132		137		140		157		130		None		None		None		None		None		None		None		None		None		None		None		None		169		None		None		172		None		None		171		172		None		175		173		None		None		None		None		None		177		176		177		None		None		177		None		None		179		180		180		None		182		None		None		184		181		None		183		None		None		185		185		185		None		186		None		188		None		187		188		188		None		189		190		None		None		None		None		None		191		192		213		None		217		219		None		193		None		None		None		193		194		None		None		None		196		195		196		None		None		191		192		193		193		194		195		196		197		198		197		None		None		None		None		None		None		None		None		None		None		196		None		None		None		201		200		198		199		199		201		None		202		None		203		None		None		None		205		204		None		205		None		207		None		209		215		None		None		211		None		None		221		None		None		None		236		None		None		237		None		223		225		213		219		221		205		207		209		211		215		217		225		None		None		None		None		None		None		None		None		223		None		None		None		None		None		227		229		None		235		237		None		None		243		None		235		239		None		231		235		None		235		241		237		237		None		None		243		241		237		None		241		233		247		None		241		250		None		243		249		250		250		None		None		None		250		245		None		251		None		252
form_id		F420		F420		F405		F420		F420		F420		F405		F420		F420		F405		F420		F405		F420		F405		F420		F420		F420		F420		F405		F405		F420		F405		F420		F420		F420		F420		F405		F420		F405		F405		F420		F420		F420		F420		F420		F420		F405		F420		F420		F420		F420		F420		F420		F420		F420		F405		F410		F420		F420		F420		F420		F420		F420		F420		F420		F405		F420		F420		F420		F405		F420		F420		F405		F450		F420		F405		F420		F420		F405		F420		F420		F420		F420		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		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		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		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		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		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F497		F460		F460		F497		F460		F460		F460		F410		F460		F497		F497		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		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		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		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		1		1		1		1		1		0		0		0		0		1		1		1		1		1		1		1		0		1		1		1		0		0		0		1		1		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		0		0		0		0		1		1		1		1		1		1		1		1		1		1		0		1		1		1		1		1		1		1		1		0		1		1		1		1		0		0		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		1		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0
filing_date		1987-01-29 00:00:00		1987-07-31 00:00:00		1987-10-29 00:00:00		1988-05-26 00:00:00		1988-05-26 00:00:00		1988-07-25 00:00:00		1988-10-27 00:00:00		1988-10-27 00:00:00		1989-01-30 00:00:00		1989-04-06 00:00:00		1989-07-28 00:00:00		1989-08-31 00:00:00		1990-02-02 00:00:00		1990-02-02 00:00:00		1990-03-22 00:00:00		1990-05-25 00:00:00		1990-07-31 00:00:00		1990-10-05 00:00:00		1990-10-25 00:00:00		1990-10-25 00:00:00		1990-10-25 00:00:00		1990-11-27 00:00:00		1991-01-28 00:00:00		1991-07-31 00:00:00		1992-01-31 00:00:00		1992-07-31 00:00:00		1992-10-09 00:00:00		1992-10-05 00:00:00		1992-11-02 00:00:00		1992-10-09 00:00:00		1993-07-30 00:00:00		1994-01-24 00:00:00		1994-03-22 00:00:00		1994-05-26 00:00:00		1994-07-26 00:00:00		1994-10-04 00:00:00		1994-10-26 00:00:00		1995-01-30 00:00:00		1995-07-24 00:00:00		1996-01-18 00:00:00		1996-02-14 00:00:00		1996-03-11 00:00:00		1996-07-29 00:00:00		1996-10-07 00:00:00		1996-10-25 00:00:00		1993-06-29 00:00:00		1986-09-23 00:00:00		1986-10-08 00:00:00		1986-10-23 00:00:00		1997-01-31 00:00:00		1997-07-22 00:00:00		1998-01-31 00:00:00		1998-03-23 00:00:00		1998-05-20 00:00:00		1998-07-27 00:00:00		1998-08-26 00:00:00		1998-10-05 00:00:00		1998-10-19 00:00:00		1999-01-27 00:00:00		1986-12-01 00:00:00		1988-01-30 00:00:00		1988-10-05 00:00:00		1989-02-06 00:00:00		1992-10-23 00:00:00		1993-02-01 00:00:00		1994-04-07 00:00:00		1994-10-26 00:00:00		1999-08-02 00:00:00		1992-10-09 00:00:00		2000-01-27 00:00:00		2000-01-09 00:00:00		2000-02-28 00:00:00		2000-07-31 00:00:00		2000-10-05 00:00:00		2000-10-25 00:00:00		2001-01-31 00:00:00		2001-07-24 00:00:00		2001-10-09 00:00:00		2002-01-22 00:00:00		2002-01-10 00:00:00		2002-02-21 00:00:00		2002-09-21 00:00:00		2002-07-29 00:00:00		2002-07-29 00:00:00		2002-10-23 00:00:00		2002-10-24 00:00:00		2002-07-31 00:00:00		2002-10-04 00:00:00		2003-01-27 00:00:00		2003-01-28 00:00:00		2003-10-04 00:00:00		2003-07-26 00:00:00		2003-07-26 00:00:00		2003-10-09 00:00:00		2004-01-22 00:00:00		2004-01-07 00:00:00		2004-01-06 00:00:00		2004-01-19 00:00:00		2004-01-01 00:00:00		2004-07-26 00:00:00		2004-02-19 00:00:00		2004-07-27 00:00:00		2004-02-12 00:00:00		2004-10-04 00:00:00		2004-10-21 00:00:00		2004-10-02 00:00:00		2004-10-16 00:00:00		2005-01-24 00:00:00		2005-01-27 00:00:00		2005-07-23 00:00:00		2005-05-02 00:00:00		2005-07-26 00:00:00		2006-01-27 00:00:00		2005-04-30 00:00:00		2006-03-20 00:00:00		2005-10-23 00:00:00		2005-10-31 00:00:00		2006-01-31 00:00:00		2006-03-17 00:00:00		2006-03-06 00:00:00		2006-05-23 00:00:00		2006-05-25 00:00:00		2006-07-23 00:00:00		2006-10-01 00:00:00		2006-10-22 00:00:00		2006-07-31 00:00:00		2006-10-01 00:00:00		2007-01-23 00:00:00		2006-11-03 00:00:00		2006-10-26 00:00:00		2007-04-13 00:00:00		2007-07-31 00:00:00		2007-07-25 00:00:00		2007-01-29 00:00:00		2007-04-16 00:00:00		2008-01-28 00:00:00		2006-11-03 00:00:00		2007-10-26 00:00:00		2008-01-20 00:00:00		2013-08-16 00:00:00		2013-07-31 00:00:00		2014-07-31 00:00:00		2015-02-02 00:00:00		2015-02-04 00:00:00		2008-03-24 00:00:00		2007-10-29 00:00:00		2008-03-22 00:00:00		2008-05-19 00:00:00		2008-05-18 00:00:00		2008-07-26 00:00:00		2008-07-28 00:00:00		2008-10-22 00:00:00		2008-10-02 00:00:00		2008-10-19 00:00:00		2008-09-27 00:00:00		2009-01-24 00:00:00		2009-01-28 00:00:00		2009-04-27 00:00:00		2009-08-08 00:00:00		2009-08-08 00:00:00		2009-08-08 00:00:00		2009-08-08 00:00:00		2009-08-08 00:00:00		2009-08-08 00:00:00		2009-08-08 00:00:00		2009-08-08 00:00:00		2009-07-25 00:00:00		2009-04-24 00:00:00		2009-07-30 00:00:00		2009-08-04 00:00:00		2009-08-04 00:00:00		2009-08-04 00:00:00		2009-08-04 00:00:00		2009-08-04 00:00:00		2009-08-04 00:00:00		2009-08-04 00:00:00		2009-08-04 00:00:00		2009-11-02 00:00:00		2009-08-08 00:00:00		2010-02-03 00:00:00		2010-02-03 00:00:00		2010-01-30 00:00:00		2010-03-19 00:00:00		2010-01-31 00:00:00		2010-01-31 00:00:00		2010-01-31 00:00:00		2009-10-30 00:00:00		2010-05-25 00:00:00		2010-03-20 00:00:00		2010-07-31 00:00:00		2010-07-29 00:00:00		2010-10-02 00:00:00		2010-05-26 00:00:00		2010-10-04 00:00:00		2011-01-19 00:00:00		2011-02-04 00:00:00		2011-01-16 00:00:00		2011-02-22 00:00:00		2011-08-01 00:00:00		2011-08-03 00:00:00		2012-01-31 00:00:00		2012-02-01 00:00:00		2012-07-30 00:00:00		2014-01-31 00:00:00		2012-07-31 00:00:00		2014-07-31 00:00:00		2013-02-01 00:00:00		2014-01-31 00:00:00		2013-02-01 00:00:00		2015-07-31 00:00:00		2015-07-31 00:00:00		2020-10-20 00:00:00		2020-07-28 00:00:00		2018-10-26 00:00:00		2019-02-04 00:00:00		2019-07-29 00:00:00		2019-01-31 00:00:00		2016-02-01 00:00:00		2016-01-29 00:00:00		2016-08-01 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2016-08-01 00:00:00		2016-10-31 00:00:00		2016-10-31 00:00:00		2016-10-31 00:00:00		2016-10-31 00:00:00		2016-10-31 00:00:00		2016-10-31 00:00:00		2016-10-31 00:00:00		2016-10-27 00:00:00		2017-01-31 00:00:00		2016-10-31 00:00:00		2016-10-31 00:00:00		2016-10-31 00:00:00		2016-10-31 00:00:00		2017-01-31 00:00:00		2017-07-28 00:00:00		2017-07-31 00:00:00		2019-01-31 00:00:00		2019-07-27 00:00:00		2019-01-31 00:00:00		2018-01-31 00:00:00		2020-09-21 00:00:00		2020-09-24 00:00:00		2018-09-06 00:00:00		2020-01-28 00:00:00		2018-07-27 00:00:00		2018-01-31 00:00:00		2018-08-23 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2020-02-18 00:00:00		2019-09-24 00:00:00		2019-09-24 00:00:00		2020-01-29 00:00:00		2020-01-15 00:00:00		2021-01-11 00:00:00		2020-02-06 00:00:00		2019-01-15 00:00:00		2020-02-19 00:00:00		2020-02-18 00:00:00		2018-07-25 00:00:00		2022-01-17 00:00:00		2022-04-28 00:00:00		2020-07-22 00:00:00		2022-06-02 00:00:00		2022-04-27 00:00:00		2020-10-19 00:00:00		2022-04-22 00:00:00		2022-07-28 00:00:00		2022-04-18 00:00:00		2021-09-07 00:00:00		2021-01-14 00:00:00		2022-01-24 00:00:00		2022-09-28 00:00:00		2021-07-19 00:00:00		2021-07-21 00:00:00		2022-10-27 00:00:00		2022-08-01 00:00:00		2022-11-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		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10006		10006		10001		10005		10005		10001		10001		10005		10001		10001		10005		10005		10005		10002		10005		10001		10001		10001		10005		10005		10001		10005		10005		10001		10001		10001		10005		10001		10005		10005		10001		10001		10005		10001		10005		10005		10001		10001		10001		10005		10001		10005		10001		10005		10001		10001		10001		10005		10001		10001		10005		10005		10005		10005		10005		10001		10001		10001		10005		10001		10001		10005		10001		10005		10005		10005		10001		10001		10005		10005		10005		10001		10001		10001		10005		10005		10002		10002		10002		10002		10002		10002		10002		10002		10001		10001		10005		10006		10006		10006		10006		10006		10006		10006		10006		10005		10002		10006		10006		10005		10001		10001		10002		10002		10001		10001		10005		10001		10005		10001		10005		10005		10005		10002		10001		10006		10001		10005		10001		10005		10001		10001		10005		10005		10001		10005		10005		10001		10005		10005		10005		10001		10005		10005		10001		10005		10001		10001		10002		10002		10002		10002		10002		10002		10002		10002		10002		10002		10005		10006		10006		10006		10006		10006		10006		10006		10002		10005		10006		10006		10006		10006		10001		10001		10005		10001		10001		10005		10005		10001		10005		10001		10001		10005		10001		10001		10005		10001		10001		10002		10002		10005		10006		10001		10001		10001		10005		10001		10001		10001		10006		10001		10001		10005		10001		10001		10001		10001		10006		10005		10005		10001		10001		10005		10001		10005		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		11001		11001		11001		11001		11002		11001		11002		11001		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11001		11003		11001		11001		11003		11003		11001		11003		11001		11001		11003		11003		11003		11001		11003		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11003		11003		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11003		11003		11003
session_id		1985		1987		1987		1987		1987		1987		1987		1987		1987		1987		1989		1989		1989		1989		1989		1989		1989		1989		1989		1989		1989		1989		1989		1991		1991		1991		1991		1991		1991		1991		1993		1993		1993		1993		1993		1993		1993		1993		1995		1995		1995		1995		1995		1995		1995		1993		1985		1985		1985		1995		1997		1997		1997		1997		1997		1997		1997		1997		1997		1985		1987		1987		1989		1991		1991		1993		1993		1999		1991		1999		1999		1999		1999		1999		1999		1999		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		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2005		2007		2007		2007		2007		2007		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		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		2011		2009		2011		2011		2011		2011		2011		2011		2013		2011		2013		2011		2013		2011		2015		2015		2019		2019		2017		2019		2019		2019		2015		2015		2015		2013		2013		2015		2011		2011		2011		2011		2013		2013		2015		2015		2013		2011		2011		2011		2011		2015		2015		2015		2015		2015		2013		2013		2013		2015		2017		2017		2017		2019		2017		2017		2019		2019		2017		2019		2017		2017		2017		2017		2017		2019		2019		2019		2019		2019		2019		2019		2019		2019		2019		2017		2021		2021		2019		2021		2021		2019		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		CFLAGG		*		GPEREZ		JLEHMAN		KCHAN		KCHAN		TWALLS		GPEREZ		GPEREZ		YRODRIGU		GPEREZ		DBARRICK		DHORRELL		DBARRICK		DBARRICK		*		DHORRELL		DBARRICK		*		COMPLETED		DBARRICK		COMPLETED		COMPLETED		KVOONG1		KVANG		GGILMORE		TTHAM		KLARRY		COMPLETED		COMPLETED		COMPLETED		GGILMORE		EMCENTEE		COMPLETED		GPEREZ		SARRIAGA		COMPLETED		COMPLETED		COMPLETED		CFLAGG		*		GPEREZ		GPEREZ		*		*		CFLAGG		*		GPEREZ		SARRIAGA		*		*		*		SARRIAGA		*		GPEREZ		*		GPEREZ		*		*		DHORRELL		SARRIAGA		*		*		GPEREZ		CFLAGG		CFLAGG		CFLAGG		DHORRELL		*		*		SMCCONNAN		SMCCONNAN		MDIGRAZIA		CAFILER		RGEREMIA		*		GPEREZ		SARRIAGA		TMILLER		*		*		SARRIAGA		RGEREMIA		RGEREMIA		*		*		*		JVAZQUEZ		MMORENO		*		*		*		*		*		*		*		MMORENO		MMORENO		MMORENO		MMORENO		SARRIAGA		JVAZQUEZ		JVAZQUEZ		JVAZQUEZ		JVAZQUEZ		JVAZQUEZ		JVAZQUEZ		JVAZQUEZ		CPON		*		NLANDERS		GGILMORE		MMORENO		*		MMORENO		*		*		CPON		MMORENO		SARRIAGA		MMORENO		MMORENO		SMCCONNAN		SARRIAGA		SMCCONNAN		CPON		*		CPON		RGEREMIA		MMORENO		MMORENO		SMCCONNAN		SMCCONNAN		CPON		CAFILER		CPON		MDIGRAZIA		CPON		MPACHECO		CPON		MDIGRAZIA		LPHEAV		KRUSSELL		IMEDINA		RGEREMIA		JFONSECA		CSAGABAEN		JFONSECA		MDIGRAZIA		MDIGRAZIA		SARRIAGA		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		SARRIAGA		MPACHECO		MPACHECO		MPACHECO		MPACHECO		MPACHECO		MPACHECO		MPACHECO		CAFILER		SARRIAGA		MPACHECO		MPACHECO		MPACHECO		MPACHECO		SARRIAGA		SARRIAGA		SARRIAGA		LPHEAV		CSAGABAEN		LPHEAV		HSTOVALL		IMEDINA		IMEDINA		CAFILER		LFEDOROV		BSINGH		HSTOVALL		CAFILER		AROJAS		AROJAS		CAFILER		CAFILER		CAFILER		LFEDOROV		TRAMON		SUSHAKOV		CAFILER		CAFILER		IMEDINA		IMEDINA		BSINGH		CPON		JMAVES		IMEDINA		CAFILER		KRUSSELL		KRUSSELL		KRUSSELL		CAFILER		RGEREMIA		LPHEAV		SUSHAKOV		CPON		CAFILER		BCOLON		BCOLON		CAFILER		RGEREMIA		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		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
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		11001		11001		11001		11001		11001		11001		11001		11001		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		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		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11001		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003		11003		11003		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		1986-10-19 00:00:00		1987-04-19 00:00:00		1987-04-19 00:00:00		1988-03-18 00:00:00		1988-01-01 00:00:00		1988-05-22 00:00:00		1988-03-18 00:00:00		1988-10-01 00:00:00		1988-10-23 00:00:00		1988-10-01 00:00:00		1989-01-01 00:00:00		None		1989-07-01 00:00:00		1989-01-01 00:00:00		1990-01-01 00:00:00		1990-03-18 00:00:00		1990-05-20 00:00:00		1990-07-01 00:00:00		1990-05-20 00:00:00		1990-01-01 00:00:00		1990-10-01 00:00:00		1990-10-01 00:00:00		1990-10-21 00:00:00		1991-01-01 00:00:00		1991-07-01 00:00:00		1992-01-01 00:00:00		1992-01-01 00:00:00		1992-07-01 00:00:00		None		1992-03-18 00:00:00		1993-01-01 00:00:00		1993-06-30 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-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		1996-02-11 00:00:00		1996-03-10 00:00:00		1996-07-01 00:00:00		1996-10-01 00:00:00		None		None		1986-07-01 00:00:00		1986-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-03-18 00:00:00		1998-05-17 00:00:00		None		1998-07-01 00:00:00		1998-10-01 00:00:00		1998-10-18 00:00:00		1986-01-01 00:00:00		1987-07-01 00:00:00		1988-07-01 00:00:00		None		1992-10-01 00:00:00		1992-10-18 00:00:00		1994-01-01 00:00:00		1994-10-01 00:00:00		1999-01-01 00:00:00		1992-05-17 00:00:00		2000-01-01 00:00:00		1999-07-01 00:00:00		2000-01-23 00:00:00		2000-02-20 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		2000-10-22 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		2002-01-20 00:00:00		2002-02-17 00:00:00		2002-01-01 00:00:00		2002-01-20 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2002-02-17 00:00:00		2002-07-01 00:00:00		2002-10-20 00:00:00		2002-10-20 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		None		2003-10-01 00:00:00		2004-01-01 00:00:00		2003-10-01 00:00:00		2004-02-14 00:00:00		2004-01-18 00:00:00		2004-02-14 00:00:00		2004-01-18 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-10-17 00:00:00		2004-10-17 00:00:00		2005-04-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		2005-10-01 00:00:00		2005-01-01 00:00:00		2006-01-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-03-06 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-10-01 00:00:00		2006-05-21 00:00:00		2006-07-01 00:00:00		2006-10-22 00:00:00		2006-11-03 00:00:00		2006-10-01 00:00:00		2007-01-01 00:00:00		2007-04-01 00:00:00		2007-04-01 00:00:00		2006-10-22 00:00:00		2007-01-01 00:00:00		2007-10-01 00:00:00		None		2007-07-01 00:00:00		2007-10-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2014-01-01 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-03-18 00:00:00		2008-03-18 00:00:00		2008-05-18 00:00:00		2008-05-18 00:00:00		2008-10-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-07-01 00:00:00		2008-10-18 00:00:00		2008-10-18 00:00:00		2009-01-01 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2008-01-01 00:00:00		2008-03-18 00:00:00		2008-05-18 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2008-10-18 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2008-01-01 00:00:00		2008-10-01 00:00:00		2008-05-18 00:00:00		2008-03-18 00:00:00		2009-01-01 00:00:00		2009-07-02 00:00:00		2008-10-18 00:00:00		2009-07-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2009-07-02 00:00:00		2010-03-18 00:00:00		2010-01-01 00:00:00		2010-05-23 00:00:00		2010-05-23 00:00:00		2010-07-01 00:00:00		2010-03-18 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2011-02-04 00:00:00		2010-10-01 00:00:00		None		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2012-01-01 00:00:00		2014-01-01 00:00:00		2012-07-01 00:00:00		2013-07-01 00:00:00		2012-07-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2020-09-20 00:00:00		2020-02-16 00:00:00		2018-10-26 00:00:00		2019-01-01 00:00:00		2019-01-20 00:00:00		2019-01-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2013-01-01 00:00:00		2014-07-01 00:00:00		2015-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-07-01 00:00:00		2013-07-01 00:00:00		2014-01-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2013-01-01 00:00:00		2012-07-01 00:00:00		2012-01-01 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2016-01-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-07-01 00:00:00		2015-01-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2013-07-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2018-09-23 00:00:00		2019-01-20 00:00:00		2018-09-23 00:00:00		2017-07-01 00:00:00		2020-07-01 00:00:00		2020-07-01 00:00:00		2018-09-06 00:00:00		2019-07-01 00:00:00		2018-01-01 00:00:00		2017-07-01 00:00:00		2018-08-23 00:00:00		2018-07-01 00:00:00		2018-07-01 00:00:00		2020-02-18 00:00:00		2019-01-01 00:00:00		2019-01-20 00:00:00		2019-07-01 00:00:00		None		2020-09-20 00:00:00		2020-02-06 00:00:00		2019-01-15 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2018-01-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2020-02-16 00:00:00		2022-06-02 00:00:00		2022-01-01 00:00:00		2020-09-20 00:00:00		2022-01-01 00:00:00		2022-04-24 00:00:00		2022-04-18 00:00:00		2020-02-16 00:00:00		2020-09-20 00:00:00		2021-07-01 00:00:00		2022-04-24 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2022-09-25 00:00:00		2022-04-24 00:00:00		2022-11-03 00:00:00
rpt_end		1986-12-31 00:00:00		1987-06-30 00:00:00		1987-06-30 00:00:00		1988-05-21 00:00:00		1988-03-17 00:00:00		1988-06-30 00:00:00		1988-05-21 00:00:00		1988-10-22 00:00:00		1988-12-31 00:00:00		1988-10-22 00:00:00		1989-06-30 00:00:00		None		1989-12-31 00:00:00		1989-06-30 00:00:00		1990-03-17 00:00:00		1990-05-19 00:00:00		1990-06-30 00:00:00		1990-09-30 00:00:00		1990-06-30 00:00:00		1990-03-17 00:00:00		1990-10-20 00:00:00		1990-10-20 00:00:00		1990-12-31 00:00:00		1991-06-30 00:00:00		1991-12-31 00:00:00		1992-06-30 00:00:00		1992-03-17 00:00:00		1992-09-30 00:00:00		None		1992-05-16 00:00:00		1993-06-30 00:00:00		1993-12-31 00:00:00		1994-03-17 00:00:00		1994-05-22 00:00:00		1994-06-30 00:00:00		1994-09-30 00:00:00		1994-09-30 00:00:00		1994-12-31 00:00:00		1995-06-30 00:00:00		1995-12-31 00:00:00		1996-02-10 00:00:00		1996-03-09 00:00:00		1996-06-30 00:00:00		1996-09-30 00:00:00		1996-10-19 00:00:00		None		None		1986-09-30 00:00:00		1986-10-18 00:00:00		1996-12-31 00:00:00		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-03-17 00:00:00		1998-05-16 00:00:00		1998-06-30 00:00:00		None		1998-09-30 00:00:00		1998-10-17 00:00:00		1998-12-31 00:00:00		1986-09-30 00:00:00		1987-12-31 00:00:00		1988-09-30 00:00:00		None		1992-10-17 00:00:00		1992-12-31 00:00:00		1994-03-17 00:00:00		1994-10-22 00:00:00		1999-06-30 00:00:00		1992-06-30 00:00:00		2000-01-22 00:00:00		1999-12-31 00:00:00		2000-02-19 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-10-21 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2002-01-19 00:00:00		2001-12-31 00:00:00		2002-02-16 00:00:00		2002-06-30 00:00:00		2002-01-19 00:00:00		2002-02-16 00:00:00		2002-10-19 00:00:00		2002-10-19 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2004-01-17 00:00:00		None		2003-12-31 00:00:00		2004-01-17 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-02-14 00:00:00		2004-06-30 00:00:00		2004-02-14 00:00:00		2004-09-30 00:00:00		2004-10-16 00:00:00		2004-09-30 00:00:00		2004-10-16 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-03-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-03-31 00:00:00		2006-03-17 00:00:00		2005-09-30 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-03-17 00:00:00		2006-03-06 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-10-21 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-12-31 00:00:00		2006-11-03 00:00:00		2006-10-21 00:00:00		2007-03-31 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		2006-12-31 00:00:00		2007-03-31 00:00:00		2007-12-31 00:00:00		None		2007-09-30 00:00:00		2007-12-31 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2014-06-30 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2008-03-17 00:00:00		2007-09-30 00:00:00		2008-03-17 00:00:00		2008-05-17 00:00:00		2008-05-17 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-10-18 00:00:00		2008-09-30 00:00:00		2008-10-18 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2008-03-17 00:00:00		2008-05-17 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-10-18 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2008-12-31 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2008-03-17 00:00:00		2008-10-18 00:00:00		2008-06-30 00:00:00		2008-05-17 00:00:00		2009-03-31 00:00:00		2009-09-30 00:00:00		2008-12-31 00:00:00		2009-09-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-03-17 00:00:00		2009-12-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-09-30 00:00:00		2010-05-22 00:00:00		2010-03-17 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-05-22 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2011-02-04 00:00:00		2010-12-31 00:00:00		None		2011-06-30 00:00:00		0211-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2013-12-31 00:00:00		2012-12-31 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2020-10-22 00:00:00		2020-06-30 00:00:00		2018-10-26 00:00:00		2019-01-19 00:00:00		2019-06-30 00:00:00		2019-01-19 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2013-06-30 00:00:00		2014-12-31 00:00:00		2015-06-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2012-12-31 00:00:00		2013-12-31 00:00:00		2014-06-30 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2013-06-30 00:00:00		2012-12-31 00:00:00		2012-06-30 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2016-06-30 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-12-31 00:00:00		2015-06-30 00:00:00		2014-12-31 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2017-12-31 00:00:00		2020-09-19 00:00:00		2020-09-19 00:00:00		2018-09-06 00:00:00		2019-12-31 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2018-08-23 00:00:00		2018-09-22 00:00:00		2018-09-22 00:00:00		2020-02-18 00:00:00		2019-01-19 00:00:00		2019-06-30 00:00:00		2019-12-31 00:00:00		None		2020-12-31 00:00:00		2020-02-06 00:00:00		2019-01-15 00:00:00		2020-02-15 00:00:00		2020-02-15 00:00:00		2018-06-30 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2020-06-30 00:00:00		2022-06-02 00:00:00		2022-04-23 00:00:00		2020-10-22 00:00:00		2022-04-23 00:00:00		2022-06-30 00:00:00		2022-04-18 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2021-12-31 00:00:00		2022-09-24 00:00:00		2021-06-30 00:00:00		2021-06-30 00:00:00		2022-10-22 00:00:00		2022-06-30 00:00:00		2022-11-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		None		None		None		None		None		None		None		None		None		None		None		None		None		2002-07-27 00:00:00		None		None		2002-10-23 00:00:00		None		None		2002-10-04 00:00:00		2003-01-27 00:00:00		None		2003-10-04 00:00:00		2003-07-26 00:00:00		None		None		None		None		None		2004-01-19 00:00:00		2004-01-01 00:00:00		2004-07-19 00:00:00		None		None		2004-02-12 00:00:00		None		None		2004-10-02 00:00:00		2004-10-16 00:00:00		2005-01-23 00:00:00		None		2005-07-22 00:00:00		None		None		2006-01-27 00:00:00		2005-04-30 00:00:00		None		2005-10-23 00:00:00		None		None		2006-03-17 00:00:00		None		2006-05-23 00:00:00		None		2006-07-23 00:00:00		None		2006-10-20 00:00:00		None		2006-09-29 00:00:00		2007-01-23 00:00:00		2006-11-03 00:00:00		None		2007-04-13 00:00:00		2007-07-08 00:00:00		None		None		None		None		None		2007-10-26 00:00:00		2008-01-20 00:00:00		2013-07-31 00:00:00		None		2014-07-31 00:00:00		2015-02-02 00:00:00		None		2008-03-23 00:00:00		None		None		None		2008-05-15 00:00:00		2008-07-26 00:00:00		None		None		None		2008-10-17 00:00:00		2008-09-27 00:00:00		2009-01-24 00:00:00		None		None		2009-07-25 00:00:00		2009-07-25 00:00:00		2009-07-25 00:00:00		2009-07-25 00:00:00		2009-07-25 00:00:00		2009-07-25 00:00:00		2009-07-25 00:00:00		2009-07-25 00:00:00		2009-07-24 00:00:00		2009-04-20 00:00:00		None		None		None		None		None		None		None		None		None		None		2009-07-25 00:00:00		None		None		None		2010-03-19 00:00:00		2010-01-29 00:00:00		2010-01-31 00:00:00		2010-01-31 00:00:00		2009-10-24 00:00:00		2010-05-22 00:00:00		None		2010-07-24 00:00:00		None		2010-09-25 00:00:00		None		None		None		None		2011-01-09 00:00:00		None		2011-08-01 00:00:00		None		2012-01-31 00:00:00		None		2012-07-30 00:00:00		2014-01-30 00:00:00		None		None		2013-02-01 00:00:00		None		None		2015-07-31 00:00:00		None		None		None		2018-10-26 00:00:00		None		None		2019-01-31 00:00:00		None		2016-01-29 00:00:00		2016-08-01 00:00:00		2016-10-26 00:00:00		2016-10-26 00:00:00		2016-10-26 00:00:00		2016-10-26 00:00:00		2016-10-26 00:00:00		2016-10-26 00:00:00		2016-10-26 00:00:00		2016-10-26 00:00:00		2016-10-26 00:00:00		2016-10-27 00:00:00		None		None		None		None		None		None		None		None		2016-10-27 00:00:00		None		None		None		None		None		2017-01-31 00:00:00		2017-07-27 00:00:00		None		2019-01-31 00:00:00		2019-07-26 00:00:00		None		None		2020-09-21 00:00:00		None		2018-09-06 00:00:00		2020-01-28 00:00:00		None		2018-01-30 00:00:00		2018-08-23 00:00:00		None		2019-01-31 00:00:00		2020-02-18 00:00:00		2019-09-24 00:00:00		2019-09-24 00:00:00		None		None		2021-01-11 00:00:00		2020-02-06 00:00:00		2019-01-15 00:00:00		None		2020-02-18 00:00:00		2018-07-24 00:00:00		2022-01-17 00:00:00		None		2020-07-22 00:00:00		2022-06-02 00:00:00		None		2020-10-19 00:00:00		2022-04-22 00:00:00		2022-07-28 00:00:00		2022-04-18 00:00:00		None		None		None		2022-09-28 00:00:00		2021-07-19 00:00:00		None		2022-10-27 00:00:00		None		2022-11-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		None		None		None		22001		None		22001		22001		None		None		None		None		None		22001		22001		22001		None		None		22001		None		None		22001		22001		22001		None		22001		None		None		22001		22001		None		22001		None		None		22001		22001		22001		None		22001		None		22001		None		22001		22001		22001		None		22001		22001		None		None		None		None		None		22001		22001		22001		None		22001		22001		None		22001		None		None		None		22001		22001		None		None		None		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		None		None		None		None		None		None		None		None		22001		None		None		None		22001		22001		22001		22001		22001		22001		None		22001		None		22001		None		None		None		22001		22001		None		22001		None		22001		None		22001		22001		None		None		22001		None		None		22001		None		None		None		22001		None		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		None		None		None		None		None		None		22001		None		None		None		None		None		22001		22001		None		22001		22001		None		None		22001		None		22001		22001		None		22001		22001		None		22001		22001		22001		22001		None		None		22001		22001		22001		None		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		None		None		None		22001		22001		None		22001		None		22001

Table: filer_to_filer_type

filer_id		1042702		1042702		1042702
filer_type		16		16		16
active		Y		Y		Y
race		0		0		0
session_id		1985		1989		2003
category		0		0		0
category_type		40502		40502		40502
sub_category		40103		40103		40103
effect_dt		1986-09-23 00:00:00		1989-08-31 00:00:00		2004-01-07 00:00:00
sub_category_type		0		40202		0
election_type		0		0		0
sub_category_a		S		S		S
nyq_dt		1986-09-10 00:00:00		1986-09-10 00:00:00		1986-09-10 00:00:00
party_cd		None		None		None
county_cd		18018		18018		18018
district_cd		None		None		None

Table: filer_xref

filer_id		1042702
xref_id		862034
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034		862034
filer_id		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702
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
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
effect_dt		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00		2004-01-07 00:00:00
naml		IBEW LOCAL #100 COPE		IBEW LOCAL #100 COPE		IBEW LOCAL #100 COPE		IBEW LOCAL #100 COPE		IBEW LOCAL #100 COPE		IBEW LOCAL #100 COPE		IBEW LOCAL #100 COPE		IBEW LOCAL #100 COPE		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS, LOCAL 100/COMMITTEE ON POLITICAL EDUCATION (I.B.E.W. LOCAL 100 C.O.P.E.)		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS, LOCAL 100/COMMITTEE ON POLITICAL EDUCATION (I.B.E.W. LOCAL 100 C.O.P.E.)		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS, LOCAL 100/COMMITTEE ON POLITICAL EDUCATION (I.B.E.W. LOCAL 100 C.O.P.E.)		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS, LOCAL 100/COMMITTEE ON POLITICAL EDUCATION (I.B.E.W. LOCAL 100 C.O.P.E.)		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS, LOCAL 100/COMMITTEE ON POLITICAL EDUCATION (I.B.E.W. LOCAL 100 C.O.P.E.)		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS, LOCAL 100/COMMITTEE ON POLITICAL EDUCATION (I.B.E.W. LOCAL 100 C.O.P.E.)		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS, LOCAL 100/COMMITTEE ON POLITICAL EDUCATION (I.B.E.W. LOCAL 100 C.O.P.E.)		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS, LOCAL 100/COMMITTEE ON POLITICAL EDUCATION (I.B.E.W. LOCAL 100 C.O.P.E.)		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL COMMITTEE ON POLITICAL EDUCATION		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL COMMITTEE ON POLITICAL EDUCATION		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL COMMITTEE ON POLITICAL EDUCATION		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL COMMITTEE ON POLITICAL EDUCATION		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL COMMITTEE ON POLITICAL EDUCATION		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL COMMITTEE ON POLITICAL EDUCATION		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL COMMITTEE ON POLITICAL EDUCATION		INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS LOCAL COMMITTEE ON POLITICAL EDUCATION
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
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
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
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
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
city		FRESNO		FRESNO		FRESNO		FRESNO		Fresno		None		FRESNO		FRESNO		FRESNO		FRESNO		FRESNO		FRESNO		Fresno		None		FRESNO		FRESNO		FRESNO		FRESNO		FRESNO		FRESNO		Fresno		None		FRESNO		FRESNO
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
zip4		937050000		937270000		93726		93711		93711		None		93728		93727		937050000		937270000		93726		93711		93711		None		93728		93727		937050000		937270000		93726		93711		93711		None		93728		93727
phon		2092254600		2092518241		2092518241		5592611477		559-261-1477		559-261-1477		5594851320		5592518241		2092254600		2092518241		2092518241		5592611477		559-261-1477		559-261-1477		5594851320		5592518241		2092254600		2092518241		2092518241		5592611477		559-261-1477		559-261-1477		5594851320		5592518241
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		None		None		None		[email protected]		[email protected]		None		[email protected]		None		None		None		None		[email protected]		[email protected]		None		[email protected]

Table: filers

filer_id		1042702

Table: received_filings

filer_id		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702		1042702
filing_file_name		868789_0.cal		870786_0.cal		877047_0.cal		906646_0.cal		944797_0.cal		962001_0.cal		977863_0.cal		103655.cal		21720.cal		21769.cal		21815.cal		21912.cal		21986.cal		22074.cal		22400.cal		22643.cal		1154392_0.cal		62909.cal		58777.cal		63228.cal		63334.cal		63373.cal		63426.cal		62837.cal		63655.cal		63527.cal		63385.cal		63606.cal		178170.cal		178239.cal		178213.cal		178863.cal		343887.cal		343916.cal		344677.cal		89746.cal		237402.cal		237378.cal		89502.cal		420644.cal		455298.cal		1154392_1.cal		88805.cal		460452.cal		460465.cal		301645.cal		297755.cal		366420.cal		366427.cal		2289375_0.cal		2334563_0.cal		2667187_0.cal		105941.cal
received_date		2002-09-21 00:00:00		2002-10-04 00:00:00		2002-10-23 00:00:00		2003-01-27 00:00:00		2003-07-26 00:00:00		2003-10-04 00:00:00		2004-01-01 00:00:00		2004-01-02 00:00:00		2006-03-06 00:00:00		2006-03-06 00:00:00		2006-03-06 00:00:00		2006-03-06 00:00:00		2006-03-06 00:00:00		2006-03-06 00:00:00		2006-03-06 00:00:00		2006-03-06 00:00:00		2006-03-06 00:00:00		2006-07-23 00:00:00		2006-07-23 00:00:00		2006-07-23 00:00:00		2006-07-23 00:00:00		2006-07-23 00:00:00		2006-07-23 00:00:00		2006-07-23 00:00:00		2006-07-23 00:00:00		2006-07-23 00:00:00		2006-07-23 00:00:00		2006-07-23 00:00:00		2009-08-08 00:00:00		2009-08-08 00:00:00		2009-08-08 00:00:00		2009-08-08 00:00:00		2010-01-31 00:00:00		2010-01-31 00:00:00		2010-01-31 00:00:00		2010-03-19 00:00:00		2009-07-25 00:00:00		2009-07-25 00:00:00		2011-01-28 00:00:00		2011-02-02 00:00:00		2011-02-04 00:00:00		2011-02-04 00:00:00		2011-01-28 00:00:00		2016-10-27 00:00:00		2016-10-27 00:00:00		2015-02-02 00:00:00		2015-02-02 00:00:00		2019-09-24 00:00:00		2019-09-24 00:00:00		2018-09-06 00:00:00		2019-01-15 00:00:00		2022-04-18 00:00:00		2022-07-28 00:00:00
filing_directory		/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/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp
filing_id		868789		870786		877047		906646		944797		962001		977863		None		None		None		None		None		None		None		None		None		1154392		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1154392		None		None		None		None		None		None		None		2289375		2334563		2667187		None
form_id		F460		F460		F460		F460		F460		F460		F460		None		None		None		None		None		None		None		None		None		F410		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		F410		None		None		None		None		None		None		None		F497		F497		F497		None
receive_comment		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints