Home

Filer ID: 1030073

Table: filer_address

filer_id		1030073		1030073		1030073
adrid		1028209		2298255		2298254
effect_dt		1990-12-01 00:00:00		2013-08-01 00:00:00		2009-01-13 00:00:00
add_type		7051		7051		7051
session_id		1979		2013		2009

Table: filer_filings

filer_id		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073
filing_id		180550		180551		180552		180553		180554		180555		180556		180557		180558		180559		180560		180561		180562		180563		180564		180565		180566		180567		180568		180569		180570		180571		180572		180573		180575		180576		180577		180578		180579		180580		180581		180582		180583		180584		180585		180586		180587		180588		180589		180539		180540		180541		180542		180543		180544		180545		180546		180547		180548		180549		180590		180591		180592		180593		180594		180595		180596		180597		180598		180599		180600		180601		180602		180604		180605		180606		180607		180608		180609		180610		180611		180612		180613		180614		180615		180616		180617		180618		180619		180620		180621		220028		220029		220030		220031		220032		220033		220034		220035		220036		220037		220038		220039		580866		180574		180603		180622		647406		722941		783702		792927		804598		845322		850966		880162		886061		915749		935021		964741		950633		982335		1033995		1047455		1077277		1114586		1146391		1120099		1106517		1156986		1149849		1158755		1176516		1175364		1174198		1207206		1207206		1212551		1249541		1251159		1285597		1270115		1298499		1289089		1262229		1265314		1297896		1765357		1777990		1786146		1767394		1785317		1981757		1967171		1965383		1802077		1936706		1917482		1947221		1907106		1330827		1330203		1311883		1351438		1351438		1353205		1374350		1353205		1395455		1400048		1421436		1422672		1422672		1421436		1441311		1405195		1453660		1441311		1464944		1438403		1438403		1467458		1485230		1485230		1452161		1485230		1509867		1487102		1487102		1507898		1509867		1540585		1507898		1540585		1548129		1548129		1548129		1548129		1540585		1540585		1573995		1598105		1569566		1608160		1592456		1591727		1623794		1623794		1635822		1610809		1621656		1621656		1639504		1635822		1635822		1639504		1657532		1678290		1658784		1801103		1824851		1817524		1683126		1712950		1709422		1869873		1873606		1739206		1845160		1848129		1767394		1744023		1765357		1998647		1997929		1986513		2241750		2313910		2245116		2486003		2274822		2210514		2362352		2564196		2402457		2532691		2012126		2024922		2037963		2060760		2040843		2075753		2101219		2126309		2107420		2145640		2160686		2157520		2169106		2175873		2415444		2279044		2216758		2348008		2526357		2443553		2494705		2195489		2382556		2420974		2396199		2580764		2193250		2380025		2448647		2472601		2322106		2470445		2603464		2553087		2624660		2587402		2679941		2627695		2706845		2644118		2621484		2677049		2652063		2733554		2741494
period_id		99		99		100		101		103		103		104		105		105		107		109		111		114		113		115		115		119		121		123		123		124		125		126		125		130		131		132		132		135		133		134		134		135		135		138		137		139		139		138		84		84		93		92		93		94		96		96		97		97		98		137		140		140		140		141		141		143		145		145		147		148		148		148		145		143		141		140		140		139		138		148		149		151		153		153		154		155		141		133		156		157		92		93		96		117		124		126		129		140		145		148		147		159		None		127		145		157		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		182		183		None		None		185		None		None		None		None		185		187		187		188		188		None		190		None		None		None		189		None		191		213		214		None		None		None		222		None		221		None		220		None		None		219		None		193		192		194		194		None		195		None		196		None		197		None		None		197		None		None		None		None		200		198		198		None		201		201		199		201		None		None		None		202		None		203		202		203		None		None		None		None		203		203		None		None		204		206		None		205		None		None		208		None		207		207		None		208		208		None		209		210		None		215		None		216		None		None		211		218		None		212		217		None		None		None		213		None		223		None		233		235		None		242		234		232		None		None		None		None		224		None		225		226		None		None		227		228		None		None		None		229		230		None		239		None		None		236		243		240		None		None		None		None		238		245		231		237		None		None		None		241		246		244		247		None		None		None		250		248		None		249		None		None		251
form_id		F450		F450		F450		F450		F421		F421		F421		F421		F421		F421		F421		F421		F405		F420		F405		F421		F420		F420		F420		F420		F420		F420		F405		F405		F420		F420		F420		F420		F405		F420		F420		F405		F420		F420		F450		F420		F420		F405		F405		F410		F420		F420		F405		F420		F420		F420		F420		F420		F420		F450		F405		F420		F497		F497		F405		F420		F420		F405		F420		F420		F497		F497		F405		F405		F405		F405		F405		F405		F405		F405		F420		F420		F450		F420		F420		F420		F420		F666		F666		F450		F420		F420		F420		F405		F421		F495		F420		F420		F420		F420		F420		F405		F460		F460		F420		F405		F405		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F497		F460		F460		F460		F497		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		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		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
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		0		0		1		1		0		0		0		1		0		0		1		0		1		0		0		2		0		0		1		0		1		0		1		1		0		1		2		3		2		3		0		0		0		0		0		0		0		1		1		0		0		1		1		0		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1984-09-20 00:00:00		1984-10-25 00:00:00		1985-01-31 00:00:00		1985-07-31 00:00:00		1985-09-20 00:00:00		1985-10-24 00:00:00		1986-01-30 00:00:00		1986-03-24 00:00:00		1986-07-31 00:00:00		1987-01-28 00:00:00		1987-07-28 00:00:00		1988-02-01 00:00:00		1988-06-17 00:00:00		1988-07-27 00:00:00		1988-09-07 00:00:00		1989-01-31 00:00:00		1990-01-31 00:00:00		1990-07-31 00:00:00		1990-10-05 00:00:00		1990-10-25 00:00:00		1991-01-31 00:00:00		1991-05-23 00:00:00		1992-01-31 00:00:00		1992-01-31 00:00:00		1992-07-31 00:00:00		1992-10-05 00:00:00		1992-10-22 00:00:00		1993-02-01 00:00:00		1993-06-10 00:00:00		1993-06-10 00:00:00		1993-08-02 00:00:00		1993-09-22 00:00:00		1993-09-22 00:00:00		1994-01-31 00:00:00		1994-07-28 00:00:00		1994-07-28 00:00:00		1994-10-05 00:00:00		1994-10-25 00:00:00		1994-10-25 00:00:00		1980-10-16 00:00:00		1981-01-30 00:00:00		1983-03-22 00:00:00		1983-03-28 00:00:00		1983-05-26 00:00:00		1983-10-26 00:00:00		1984-01-31 00:00:00		1984-02-09 00:00:00		1984-03-22 00:00:00		1984-05-23 00:00:00		1984-07-31 00:00:00		1994-10-25 00:00:00		1994-10-26 00:00:00		1994-10-28 00:00:00		1994-11-03 00:00:00		1995-03-23 00:00:00		1995-07-31 00:00:00		1996-01-31 00:00:00		1996-07-31 00:00:00		1996-07-31 00:00:00		1996-10-07 00:00:00		1996-10-25 00:00:00		1996-10-31 00:00:00		1997-02-07 00:00:00		1997-02-07 00:00:00		1997-02-07 00:00:00		1997-02-07 00:00:00		1997-02-07 00:00:00		1997-02-07 00:00:00		1997-02-07 00:00:00		1997-02-07 00:00:00		1997-01-31 00:00:00		1997-07-31 00:00:00		1998-02-02 00:00:00		1998-03-23 00:00:00		1998-05-21 00:00:00		1998-07-31 00:00:00		1998-10-05 00:00:00		1998-11-30 00:00:00		1997-12-31 00:00:00		1999-02-08 00:00:00		1999-07-30 00:00:00		1983-01-31 00:00:00		1983-07-29 00:00:00		1984-02-09 00:00:00		1989-07-06 00:00:00		1990-10-05 00:00:00		1991-07-31 00:00:00		1992-05-21 00:00:00		1995-01-31 00:00:00		1996-03-19 00:00:00		1996-10-24 00:00:00		1997-02-07 00:00:00		1999-10-12 00:00:00		2000-01-10 00:00:00		1992-01-31 00:00:00		1997-02-07 00:00:00		1999-11-01 00:00:00		2000-07-31 00:00:00		2001-01-31 00:00:00		2001-07-31 00:00:00		2001-10-31 00:00:00		2002-01-09 00:00:00		2002-04-30 00:00:00		2002-07-19 00:00:00		2002-10-24 00:00:00		2002-10-29 00:00:00		2003-01-31 00:00:00		2003-04-30 00:00:00		2003-10-10 00:00:00		2003-07-31 00:00:00		2004-01-12 00:00:00		2004-08-02 00:00:00		2004-10-05 00:00:00		2005-01-26 00:00:00		2005-07-26 00:00:00		2006-01-30 00:00:00		2005-07-29 00:00:00		2005-05-02 00:00:00		2006-03-22 00:00:00		2006-01-31 00:00:00		2006-03-22 00:00:00		2006-05-09 00:00:00		2006-05-25 00:00:00		2006-05-25 00:00:00		2006-10-13 00:00:00		2006-10-13 00:00:00		2006-10-26 00:00:00		2007-02-28 00:00:00		2007-02-28 00:00:00		2007-07-31 00:00:00		2006-10-27 00:00:00		2007-10-31 00:00:00		2007-08-10 00:00:00		2007-04-30 00:00:00		2007-04-30 00:00:00		2007-10-31 00:00:00		2013-07-24 00:00:00		2013-07-24 00:00:00		2013-07-31 00:00:00		2013-08-01 00:00:00		2013-08-01 00:00:00		2015-07-31 00:00:00		2015-04-30 00:00:00		2015-04-30 00:00:00		2013-10-31 00:00:00		2015-02-02 00:00:00		2014-10-29 00:00:00		2015-02-02 00:00:00		2014-10-28 00:00:00		2008-04-30 00:00:00		2008-04-30 00:00:00		2008-01-31 00:00:00		2008-07-31 00:00:00		2008-07-31 00:00:00		2008-07-31 00:00:00		2008-10-28 00:00:00		2008-08-01 00:00:00		2009-01-30 00:00:00		2009-02-02 00:00:00		2009-04-30 00:00:00		2009-04-30 00:00:00		2009-05-01 00:00:00		2009-04-30 00:00:00		2009-07-31 00:00:00		2009-01-13 00:00:00		2009-11-02 00:00:00		2009-11-02 00:00:00		2010-02-01 00:00:00		2009-07-31 00:00:00		2009-10-30 00:00:00		2010-02-01 00:00:00		2010-04-30 00:00:00		2010-04-30 00:00:00		2009-10-30 00:00:00		2010-04-30 00:00:00		2010-08-02 00:00:00		2010-04-30 00:00:00		2010-05-03 00:00:00		2010-08-02 00:00:00		2010-10-04 00:00:00		2010-11-01 00:00:00		2010-10-01 00:00:00		2010-11-01 00:00:00		2010-11-02 00:00:00		2010-11-02 00:00:00		2010-12-28 00:00:00		2010-12-28 00:00:00		2010-12-23 00:00:00		2010-12-23 00:00:00		2011-01-31 00:00:00		2008-10-29 00:00:00		2011-01-29 00:00:00		2011-08-01 00:00:00		2011-05-02 00:00:00		2011-05-02 00:00:00		2011-10-31 00:00:00		2011-11-01 00:00:00		2012-01-31 00:00:00		2011-08-01 00:00:00		2011-10-30 00:00:00		2011-10-30 00:00:00		2012-02-01 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00		2012-04-30 00:00:00		2012-07-31 00:00:00		2012-04-30 00:00:00		2013-10-31 00:00:00		2014-01-31 00:00:00		2014-01-31 00:00:00		2012-07-30 00:00:00		2012-10-31 00:00:00		2012-10-31 00:00:00		2014-07-30 00:00:00		2014-07-31 00:00:00		2013-01-31 00:00:00		2014-04-30 00:00:00		2014-04-30 00:00:00		2013-04-30 00:00:00		2013-01-31 00:00:00		2013-04-30 00:00:00		2015-11-02 00:00:00		2015-11-02 00:00:00		2015-07-31 00:00:00		2018-04-30 00:00:00		2018-10-26 00:00:00		2018-04-30 00:00:00		2020-07-31 00:00:00		2018-07-31 00:00:00		2018-01-31 00:00:00		2019-01-31 00:00:00		2021-02-01 00:00:00		2019-07-31 00:00:00		2020-11-02 00:00:00		2016-02-01 00:00:00		2016-02-01 00:00:00		2016-05-02 00:00:00		2016-07-28 00:00:00		2016-05-03 00:00:00		2016-08-01 00:00:00		2016-10-31 00:00:00		2017-01-29 00:00:00		2016-11-01 00:00:00		2017-01-31 00:00:00		2017-05-01 00:00:00		2017-05-01 00:00:00		2017-07-20 00:00:00		2017-07-24 00:00:00		2019-10-25 00:00:00		2018-07-31 00:00:00		2018-01-31 00:00:00		2019-01-31 00:00:00		2020-10-29 00:00:00		2020-01-31 00:00:00		2020-07-31 00:00:00		2017-10-31 00:00:00		2019-04-30 00:00:00		2019-10-31 00:00:00		2019-07-30 00:00:00		2021-04-30 00:00:00		2017-10-31 00:00:00		2019-04-30 00:00:00		2020-01-31 00:00:00		2020-04-30 00:00:00		2018-10-26 00:00:00		2020-04-30 00:00:00		2021-08-02 00:00:00		2021-02-01 00:00:00		2021-11-01 00:00:00		2021-04-30 00:00:00		2022-05-02 00:00:00		2021-11-01 00:00:00		2022-08-01 00:00:00		2022-01-31 00:00:00		2021-08-02 00:00:00		2022-05-02 00:00:00		2022-01-31 00:00:00		2022-08-02 00:00:00		2022-10-26 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		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10001		10005		10005		10001		10005		10005		10006		10005		10001		10001		10002		10001		10001		10005		10001		10005		10005		10005		10001		10005		10001		10002		10001		10005		10006		10002		10001		10005		10001		10005		10001		10005		10005		10001		10005		10001		10001		10001		10002		10005		10001		10006		10001		10005		10001		10005		10006		10002		10005		10006		10005		10006		10001		10001		10002		10005		10002		10001		10001		10002		10005		10005		10006		10001		10006		10001		10002		10002		10005		10006		10006		10006		10002		10002		10005		10005		10001		10001		10005		10001		10005		10006		10002		10005		10001		10002		10006		10001		10002		10005		10001		10001		10005		10001		10005		10001		10005		10005		10001		10001		10005		10001		10001		10005		10005		10005		10001		10005		10001		10005		10001		10001		10005		10001		10001		10001		10005		10005		10005		10005		10001		10005		10001		10001		10005		10005		10001		10001		10005		10005		10005		10001		10001		10005		10001		10005		10005		10001		10001		10001		10005		10005		10005		10005		10001		10001		10001		10001		10005		10005		10005		10001		10001		10001		10001		10005		10005		10005		10001		10001		10005		10001		10005		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11003		11001		11001		11003		11003		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003
session_id		1983		1983		1983		1985		1985		1985		1985		1985		1985		1985		1987		1987		1987		1987		1987		1987		1989		1989		1989		1989		1989		1991		1991		1991		1991		1991		1991		1991		1993		1993		1993		1993		1993		1993		1993		1993		1993		1993		1993		1979		1979		1983		1981		1983		1983		1983		1983		1983		1983		1983		1993		1993		1993		1993		1995		1995		1995		1995		1995		1995		1995		1995		1995		1995		1995		1995		1993		1993		1993		1993		1995		1997		1997		1997		1997		1997		1997		1995		1993		1997		1999		1981		1983		1983		1989		1989		1991		1991		1993		1995		1995		1995		1999		1999		1991		1995		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2005		2007		2007		2007		2007		2007		2013		2013		2013		2013		2013		2015		2015		2015		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		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		2009		2009		2009		2007		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2011		2011		2011		2013		2013		2011		2013		2013		2013		2011		2013		2015		2015		2015		2017		2017		2017		2019		2017		2017		2017		2021		2019		2019		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2019		2017		2017		2017		2019		2019		2019		2017		2019		2019		2019		2021		2017		2019		2019		2019		2017		2019		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		JLEHMAN		TWALLS		GPEREZ		GPEREZ		GPEREZ		DBARRICK		DBARRICK		KLARRY		DHORRELL		DBARRICK		DBARRICK		KVOONG1		GGILMORE		MHOANG		GKURIMOT		EMCENTEE		GKURIMOT		*		*		CFLAGG		GKURIMOT		*		GPEREZ		GPEREZ		TTHAM		GPEREZ		*		*		*		DHORRELL		DHORRELL		NWALKER		*		DHORRELL		SARRIAGA		DHORRELL		*		CFLAGG		*		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MPACHECO		TRAMON		MDIGRAZIA		SARRIAGA		SARRIAGA		MPACHECO		CAFILER		RGEREMIA		GCLARA		CAFILER		TRAMON		CPON		*		CPON		*		CPON		TRAMON		RGEREMIA		CPON		TRAMON		MMORENO		JVAZQUEZ		MMORENO		MMORENO		MMORENO		RGEREMIA		MMORENO		MMORENO		MMORENO		MMORENO		MMORENO		JVAZQUEZ		MMORENO		MMORENO		MMORENO		MMORENO		SMCCONNAN		MMORENO		JVAZQUEZ		SMCCONNAN		MPACHECO		CPON		*		*		CPON		MPACHECO		MPACHECO		MPACHECO		*		*		SMCCONNAN		TRAMON		SMCCONNAN		CPON		MPACHECO		MMORENO		MMORENO		MMORENO		CAFILER		CPON		MMORENO		MMORENO		MPACHECO		CAFILER		CAFILER		MPACHECO		CAFILER		CPON		CPON		CAFILER		GGILMORE		MDIGRAZIA		CPON		MDIGRAZIA		MDIGRAZIA		CAFILER		MPACHECO		CAFILER		MDIGRAZIA		MDIGRAZIA		CPON		MPACHECO		CPON		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		CSAGABAEN		YMORA		CSAGABAEN		KRUSSELL		HSTOVALL		CSAGABAEN		JFONSECA		CREYNOLDS		HCOURSEY		CPON		MDIGRAZIA		MDIGRAZIA		SMCCONNAN		SARRIAGA		SMCCONNAN		SARRIAGA		LPALMER		CPON		LPALMER		CPON		HSTOVALL		HSTOVALL		LBARTHOL		LBARTHOL		CAFILER		HSTOVALL		CSAGABAEN		JFONSECA		CPON		VUKSTINA		KRUSSELL		LBARTHOL		YMORA		YMORA		HCOURSEY		CREYNOLDS		LBARTHOL		YMORA		VUKSTINA		SUSHAKOV		YMORA		SUSHAKOV		LPHEAV		CREYNOLDS		IMEDINA		CREYNOLDS		SARRIAGA		IMEDINA		CAFILER		KRUSSELL		LPHEAV		SARRIAGA		KRUSSELL		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11001		11003		11003		11003		11003		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11003		11001		11003		11003		11001		11001		11001		11003		11001		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11001		11001		11003		11001		11001		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11001		11003		11001		11001		11003		11003		11001		11001		11003		11003		11003
rpt_start		1984-07-01 00:00:00		1984-09-18 00:00:00		1984-10-21 00:00:00		1985-01-01 00:00:00		1985-07-01 00:00:00		1985-09-18 00:00:00		1985-10-20 00:00:00		1986-01-01 00:00:00		1986-01-01 00:00:00		1986-07-01 00:00:00		1987-01-01 00:00:00		1987-07-01 00:00:00		None		1988-01-01 00:00:00		None		1988-07-01 00:00:00		1989-07-01 00:00:00		1990-01-01 00:00:00		1990-07-01 00:00:00		1990-09-30 00:00:00		1990-10-21 00:00:00		1991-01-01 00:00:00		1991-05-19 00:00:00		1991-01-01 00:00:00		1992-05-17 00:00:00		1992-07-01 00:00:00		1992-10-01 00:00:00		1992-10-18 00:00:00		1993-07-01 00:00:00		1993-01-01 00:00:00		1993-05-23 00:00:00		1993-05-23 00:00:00		1993-07-01 00:00:00		1993-09-19 00:00:00		1994-05-22 00:00:00		1994-01-01 00:00:00		1994-07-01 00:00:00		1994-07-01 00:00:00		1994-05-22 00:00:00		None		1980-10-24 00:00:00		1983-01-01 00:00:00		1982-10-17 00:00:00		1983-03-18 00:00:00		1983-06-30 00:00:00		1983-10-22 00:00:00		1983-10-23 00:00:00		1984-01-01 00:00:00		1984-03-18 00:00:00		1984-05-20 00:00:00		1994-01-01 00:00:00		1994-10-01 00:00:00		None		None		None		1995-01-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		1996-03-10 00:00:00		1996-07-01 00:00:00		None		None		1996-10-01 00:00:00		1996-01-01 00:00:00		1995-07-01 00:00:00		1995-01-01 00:00:00		1994-10-23 00:00:00		1994-10-01 00:00:00		1994-07-01 00:00:00		1994-05-22 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		1998-07-01 00:00:00		1995-01-01 00:00:00		1993-01-01 00:00:00		1998-10-01 00:00:00		1999-01-01 00:00:00		1982-10-17 00:00:00		1983-01-01 00:00:00		1983-10-23 00:00:00		1989-01-01 00:00:00		None		1991-05-19 00:00:00		1992-01-01 00:00:00		1994-10-23 00:00:00		1996-01-01 00:00:00		1996-10-01 00:00:00		1996-07-01 00:00:00		1999-07-01 00:00:00		1999-10-01 00:00:00		1991-07-01 00:00:00		1996-03-10 00:00:00		1999-01-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		None		2002-07-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-04-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2005-04-01 00:00:00		2005-07-01 00:00:00		2005-04-01 00:00:00		2005-01-01 00:00:00		2006-01-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		None		2006-03-18 00:00:00		2006-03-18 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2006-10-26 00:00:00		2006-10-01 00:00:00		2006-10-01 00:00:00		2007-04-01 00:00:00		None		2007-07-01 00:00:00		2007-04-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-07-01 00:00:00		2013-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-04-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2013-07-01 00:00:00		2014-10-01 00:00:00		2014-07-01 00:00:00		2014-10-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2007-10-01 00:00:00		2008-04-01 00:00:00		2008-04-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2008-04-01 00:00:00		2008-10-01 00:00:00		2008-10-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		None		2009-07-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2009-04-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2008-07-01 00:00:00		2010-10-01 00:00:00		2011-04-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2011-10-01 00:00:00		2011-10-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2013-10-01 00:00:00		2012-04-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2014-04-01 00:00:00		2014-04-01 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2020-04-01 00:00:00		2018-04-01 00:00:00		2017-10-01 00:00:00		2018-10-01 00:00:00		2020-10-01 00:00:00		2019-04-01 00:00:00		2020-07-01 00:00:00		2015-10-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-04-01 00:00:00		2017-04-01 00:00:00		2019-07-01 00:00:00		2018-04-01 00:00:00		2017-10-01 00:00:00		2018-10-01 00:00:00		2020-07-01 00:00:00		2019-10-01 00:00:00		2020-04-01 00:00:00		2017-07-01 00:00:00		2019-01-01 00:00:00		2019-07-01 00:00:00		2019-04-01 00:00:00		2021-01-01 00:00:00		2017-07-01 00:00:00		2019-01-01 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		2018-07-01 00:00:00		2020-01-01 00:00:00		2021-04-01 00:00:00		2020-10-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2022-04-01 00:00:00		2021-10-01 00:00:00		2021-04-01 00:00:00		2022-01-01 00:00:00		2021-10-01 00:00:00		2022-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		1984-09-17 00:00:00		1984-10-20 00:00:00		1984-12-31 00:00:00		1985-06-30 00:00:00		1985-09-17 00:00:00		1985-10-19 00:00:00		1985-12-31 00:00:00		1986-03-17 00:00:00		1986-06-30 00:00:00		1986-12-31 00:00:00		1987-06-30 00:00:00		1987-12-31 00:00:00		None		1988-06-30 00:00:00		None		1988-12-31 00:00:00		1989-12-31 00:00:00		1990-06-30 00:00:00		1990-09-30 00:00:00		1990-10-20 00:00:00		1990-12-31 00:00:00		1991-05-18 00:00:00		1991-06-30 00:00:00		1991-05-18 00:00:00		1992-06-30 00:00:00		1992-09-30 00:00:00		1992-10-17 00:00:00		1992-12-31 00:00:00		1993-09-30 00:00:00		1993-05-22 00:00:00		1993-06-30 00:00:00		1993-06-30 00:00:00		1993-09-18 00:00:00		1993-12-31 00:00:00		1994-06-30 00:00:00		1994-05-21 00:00:00		1994-09-30 00:00:00		1994-09-30 00:00:00		1994-06-30 00:00:00		None		1980-12-31 00:00:00		1983-03-17 00:00:00		1982-12-31 00:00:00		1983-05-21 00:00:00		1983-10-22 00:00:00		1983-12-31 00:00:00		1983-12-31 00:00:00		1984-03-17 00:00:00		1984-05-19 00:00:00		1984-06-30 00:00:00		1994-05-21 00:00:00		1994-10-22 00:00:00		None		None		None		1995-06-30 00:00:00		1995-12-31 00:00:00		1996-03-09 00:00:00		1996-06-30 00:00:00		1996-09-30 00:00:00		None		None		1996-10-19 00:00:00		1996-03-09 00:00:00		1996-12-31 00:00:00		1995-06-30 00:00:00		1994-12-31 00:00:00		1994-10-22 00:00:00		1994-09-30 00:00:00		1994-06-30 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		1998-09-30 00:00:00		1996-12-31 00:00:00		1994-12-31 00:00:00		1998-12-31 00:00:00		1999-06-30 00:00:00		1982-12-31 00:00:00		1983-06-30 00:00:00		1983-12-31 00:00:00		1989-06-30 00:00:00		None		1991-06-30 00:00:00		1992-05-16 00:00:00		1994-12-31 00:00:00		1996-03-09 00:00:00		1996-10-19 00:00:00		1996-09-30 00:00:00		1999-09-30 00:00:00		1999-12-31 00:00:00		1991-12-31 00:00:00		1996-06-30 00:00:00		1999-06-30 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		None		2002-09-30 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-06-30 00:00:00		2005-03-31 00:00:00		2006-03-17 00:00:00		2005-12-31 00:00:00		2006-03-17 00:00:00		None		2006-05-20 00:00:00		2006-05-20 00:00:00		2006-09-30 00:00:00		2006-09-30 00:00:00		2006-10-26 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		None		2007-09-30 00:00:00		2007-06-30 00:00:00		2007-03-31 00:00:00		2007-03-31 00:00:00		2007-09-30 00:00:00		2013-03-31 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		2015-03-31 00:00:00		2015-03-31 00:00:00		2013-09-30 00:00:00		2014-12-31 00:00:00		2014-09-30 00:00:00		2014-12-31 00:00:00		2014-09-30 00:00:00		2008-03-31 00:00:00		2008-03-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		2009-03-31 00:00:00		2009-03-31 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		None		2009-09-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		2010-03-31 00:00:00		2009-09-30 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-09-30 00:00:00		2010-09-30 00:00:00		2010-09-30 00:00:00		2010-09-30 00:00:00		2010-09-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2008-09-30 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-03-31 00:00:00		2011-03-31 00:00:00		2011-09-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2014-03-31 00:00:00		2013-03-31 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		2018-03-31 00:00:00		2018-09-30 00:00:00		2018-03-31 00:00:00		2020-06-30 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2018-12-31 00:00:00		2020-12-31 00:00:00		2019-06-30 00:00:00		2020-09-30 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		2017-03-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2019-09-30 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2018-12-31 00:00:00		2020-09-30 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2017-09-30 00:00:00		2019-03-31 00:00:00		2019-09-30 00:00:00		2019-06-30 00:00:00		2021-03-31 00:00:00		2017-09-30 00:00:00		2019-03-31 00:00:00		2019-12-31 00:00:00		2020-03-31 00:00:00		2018-09-30 00:00:00		2020-03-31 00:00:00		2021-06-30 00:00:00		2020-12-31 00:00:00		2021-09-30 00:00:00		2021-03-31 00:00:00		2022-03-31 00:00:00		2021-09-30 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		2022-03-31 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2005-07-26 00:00:00		2006-01-23 00:00:00		None		None		2006-03-22 00:00:00		None		None		None		None		2006-05-25 00:00:00		2006-10-12 00:00:00		2006-10-13 00:00:00		2006-10-26 00:00:00		2007-02-28 00:00:00		None		2007-07-31 00:00:00		None		None		None		2007-04-30 00:00:00		None		2007-10-31 00:00:00		2013-07-24 00:00:00		2013-07-24 00:00:00		None		None		None		2015-07-31 00:00:00		None		2015-04-30 00:00:00		None		2015-02-02 00:00:00		None		None		2014-10-28 00:00:00		None		2008-04-30 00:00:00		2008-01-31 00:00:00		2008-07-31 00:00:00		2008-07-31 00:00:00		None		2008-10-28 00:00:00		None		2009-01-30 00:00:00		None		2009-04-30 00:00:00		None		None		2009-04-30 00:00:00		None		None		None		None		2010-02-01 00:00:00		2009-07-31 00:00:00		2009-10-30 00:00:00		None		2010-04-30 00:00:00		2010-04-30 00:00:00		2009-10-30 00:00:00		2010-04-30 00:00:00		None		None		None		2010-08-02 00:00:00		None		2010-11-01 00:00:00		2010-10-01 00:00:00		2010-11-01 00:00:00		None		None		None		None		2010-12-23 00:00:00		2010-12-23 00:00:00		None		None		2011-01-29 00:00:00		2011-08-01 00:00:00		None		2011-05-02 00:00:00		None		None		2012-01-31 00:00:00		None		2011-10-30 00:00:00		2011-10-30 00:00:00		None		2012-01-31 00:00:00		2012-01-31 00:00:00		None		2012-04-30 00:00:00		2012-07-31 00:00:00		None		2013-10-31 00:00:00		None		2014-01-31 00:00:00		None		None		2012-10-31 00:00:00		2014-07-30 00:00:00		None		2013-01-31 00:00:00		2014-04-30 00:00:00		None		None		None		2013-04-30 00:00:00		None		2015-11-02 00:00:00		None		2018-04-30 00:00:00		2018-10-26 00:00:00		None		2020-07-31 00:00:00		2018-07-31 00:00:00		2018-01-31 00:00:00		None		None		None		None		2016-02-01 00:00:00		None		2016-05-02 00:00:00		2016-07-28 00:00:00		None		None		2016-10-31 00:00:00		2017-01-29 00:00:00		None		None		None		2017-05-01 00:00:00		2017-07-20 00:00:00		None		2019-10-25 00:00:00		None		None		2019-01-31 00:00:00		2020-10-29 00:00:00		2020-01-31 00:00:00		None		None		None		None		2019-07-30 00:00:00		2021-04-30 00:00:00		2017-10-31 00:00:00		2019-04-30 00:00:00		None		None		None		2020-04-30 00:00:00		2021-08-02 00:00:00		2021-02-01 00:00:00		2021-11-01 00:00:00		None		None		None		2022-08-01 00:00:00		2022-01-31 00:00:00		None		2022-05-02 00:00:00		None		None		2022-10-26 00:00:00
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		22001		None		None		22001		None		None		None		None		22001		22001		22001		22001		22001		None		22001		None		None		None		22001		None		22001		22006		22006		None		None		None		22006		None		22006		None		22006		None		None		22006		None		22001		22001		22001		22001		None		22001		None		22001		None		22001		None		None		22001		None		None		None		None		22001		22001		22001		None		22001		22001		22001		22001		None		None		None		22001		None		22001		22001		22001		None		None		None		None		22001		22001		None		None		22001		22001		None		22001		None		None		22001		None		22001		22001		None		22001		22001		None		22001		22001		None		22006		None		22006		None		None		22001		22006		None		22006		22006		None		None		None		22006		None		22006		None		22006		22006		None		22006		22006		22006		None		None		None		None		22006		None		22006		22006		None		None		22006		22006		None		None		None		22006		22006		None		22006		None		None		22006		22006		22006		None		None		None		None		22006		22006		22006		22006		None		None		None		22006		22006		22006		22006		None		None		None		22006		22006		None		22006		None		None		22006

Table: filer_to_filer_type

filer_id		1030073		1030073
filer_type		16		16
active		Y		Y
race		0		0
session_id		1979		2009
category		0		0
category_type		40502		40502
sub_category		40103		40103
effect_dt		1990-12-01 00:00:00		2009-01-13 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		None		S
nyq_dt		1980-10-16 00:00:00		1980-10-16 00:00:00
party_cd		None		None
county_cd		18004		18004
district_cd		None		None

Table: filer_xref

filer_id		1030073
xref_id		802270
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		802270		802270		802270		802270		802270		802270		802270		802270		802270		802270		802270		802270
filer_id		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073
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
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2009-01-13 00:00:00		2009-01-13 00:00:00		2009-01-13 00:00:00		2009-01-13 00:00:00		2009-01-13 00:00:00		2009-01-13 00:00:00		2009-01-13 00:00:00		2009-01-13 00:00:00		2009-01-13 00:00:00		2009-01-13 00:00:00		2009-01-13 00:00:00		2009-01-13 00:00:00
naml		SURETY PRODUCERS ASSOCIATION OF CALIFORNIA PAC		SURETY PRODUCERS ASSOCIATION OF CALIFORNIA PAC		SURETY PRODUCERS ASSOCIATION OF CALIFORNIA PAC		ASSOCIATION OF CALIFORNIA SURETY COMPANIES		ASSOCIATION OF CALIFORNIA SURETY COMPANIES		ASSOCIATION OF CALIFORNIA SURETY COMPANIES		SURETY PRODUCERS ASSOCIATION POLITICAL ACTION COMMITTEE		SURETY PRODUCERS ASSOCIATION POLITICAL ACTION COMMITTEE		SURETY PRODUCERS ASSOCIATION POLITICAL ACTION COMMITTEE		ASSOCIATION OF CALIFORNIA SURETY COMPANIES POLITICAL ACTION COMMITTEE		ASSOCIATION OF CALIFORNIA SURETY COMPANIES POLITICAL ACTION COMMITTEE		ASSOCIATION OF CALIFORNIA SURETY COMPANIES POLITICAL ACTION COMMITTEE
namf		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
nams		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
adr2		None		None		None		None		None		None		None		None		None		None		None		None
city		SACAMENTO		SACAMENTO		SACAMENTO		SACAMENTO		SACAMENTO		SACAMENTO		SACAMENTO		SACAMENTO		SACAMENTO		SACAMENTO		SACAMENTO		SACAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		958140000		958140000		958140000		958140000		958140000		958140000		958140000		958140000		958140000		958140000		958140000		958140000
phon		9164414166		9164414166		9164414166		9164414166		9164414166		9164414166		9164414166		9164414166		9164414166		9164414166		9164414166		9164414166
fax		None		None		None		None		None		None		None		None		None		None		None		None
email		None		shawna@desmondlobbyfirm.com		anne@desmondlobbyfirm.com		None		shawna@desmondlobbyfirm.com		anne@desmondlobbyfirm.com		None		shawna@desmondlobbyfirm.com		anne@desmondlobbyfirm.com		None		shawna@desmondlobbyfirm.com		anne@desmondlobbyfirm.com

Table: filers

filer_id		1030073

Table: received_filings

filer_id		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073		1030073
filing_file_name		1212551_0.cal		522004.cal		97941.cal		98074.cal		98494.cal		154306.cal		158757.cal		158826.cal		156766.cal		154242.cal		154486.cal		159008.cal		323603.cal		323285.cal		126646.cal		126709.cal		126807.cal		126945.cal
received_date		2006-10-26 00:00:00		2010-04-30 00:00:00		2009-10-30 00:00:00		2009-10-30 00:00:00		2009-10-30 00:00:00		2009-04-30 00:00:00		2009-04-30 00:00:00		2009-04-30 00:00:00		2009-04-30 00:00:00		2009-04-30 00:00:00		2009-04-30 00:00:00		2009-04-30 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00
filing_directory		/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
filing_id		1212551		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
form_id		F497		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
receive_comment		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 did not pass validation		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