Home

Filer ID: 1070627

Table: filer_address

filer_id		1070627		1070627		1070627		1070627		1070627		1070627		1070627
adrid		1081997		1081998		2157058		2503625		2521352		2444762		2282618
effect_dt		1997-06-25 00:00:00		1997-06-25 00:00:00		1997-08-20 00:00:00		2020-07-27 00:00:00		2021-07-22 00:00:00		2018-01-09 00:00:00		2012-12-20 00:00:00
add_type		7051		7051		7082		7051		7051		7051		7051
session_id		1997		1997		1997		2019		2021		2017		2011

Table: filer_filings

filer_id		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627
filing_id		402313		402314		402315		402316		402317		402318		402319		402320		402322		402323		444397		402321		583716		640248		676983		676685		671980		717139		676685		671980		786298		774064		779892		785268		808680		804895		804477		809994		825012		846214		820989		849573		869986		869987		850392		870435		901264		903125		941596		943110		963005		961327		978436		983118		995918		997937		994887		1024303		1001782		1025325		1044987		1043862		1050579		1048478		1071925		1077546		1110822		1116152		1142301		1129321		1127665		1141869		1156503		1158617		1172830		1175049		1182366		1183982		1172830		1172831		1175049		1205433		1203319		1211606		1229958		1232007		1211606		1276834		1275092		1272585		1272668		1275884		1304654		1305501		1775790		1776074		1973434		1973539		1853336		1854865		1942404		1909254		1894294		1901307		1318990		1319239		1343727		1342796		1362100		1333728		1335072		1367619		1362776		1390151		1371477		1387630		1387630		1405354		1390583		1423987		1423073		1430560		1430820		1459632		1423073		1474956		1474030		1474956		1458711		1489360		1490201		1490201		1495388		1474030		1503498		1521758		1501213		1489360		1493865		1529227		1528054		1523368		1561205		1601547		1559481		1601187		1628221		1628438		1648023		1646273		1646273		1662309		1665618		1670358		1648023		1671226		1829933		1830222		1817630		1824703		1692411		1693239		1926510		1923695		1387630		1701470		1702937		1891085		1893039		1862068		1874649		1863349		1884667		1739051		1727760		1729793		1826236		1826359		1848168		1851699		1848754		1852699		2002746		2003105		2356228		2491731		2201699		1387630		2251329		2251417		2285124		2025821		2045131		2033789		2039738		2039635		2048852		2051100		2054262		2069117		2054821		2081435		2075206		2087849		2091324		2094708		2119334		2109276		2125230		2166254		2167657		2298182		2264192		2200436		2295273		2486649		2518956		2508043		2259387		2573919		2388421		2262963		2201384		2533774		1387630		2394754		2429299		2280850		2598773		2358683		2534140		1387630		2244085		1387630		2331508		2490614		2316247		2504494		2686607		2478150		2664314		2672525		2446127		1387630		2692113		2670241		2650366		2641515		2680244		2545522		2725373		2704171		2597031		2710004		2627465		2618694		2656109		2731186		2731186		2743135		2725568		2731426
period_id		150		149		151		151		153		153		154		155		157		159		156		156		None		None		None		None		None		None		None		None		None		None		165		167		169		None		168		None		None		157		169		169		171		171		None		None		172		None		173		None		None		175		176		None		None		177		177		177		None		None		None		179		None		180		180		None		181		None		None		None		183		184		185		None		185		None		186		None		185		186		None		None		187		188		188		None		188		None		None		None		None		189		191		None		213		None		221		None		None		218		None		None		220		220		193		None		None		194		195		193		None		196		None		196		None		197		197		None		None		None		198		197		None		None		198		None		201		None		199		201		None		None		None		201		None		203		202		201		202		None		204		None		None		None		204		205		207		None		None		209		209		209		None		210		None		None		217		None		215		None		211		None		221		220		212		212		None		219		None		218		219		None		219		None		212		None		217		217		218		217		218		218		223		None		None		None		None		233		233		None		235		226		226		225		None		226		226		None		226		227		None		227		227		228		None		227		228		None		None		229		None		None		None		231		235		None		243		244		234		None		237		234		None		None		246		None		239		None		245		237		None		243		234		235		235		243		236		243		250		241		250		249		None		248		None		250		249		247		None		244		None		250		None		251		None		None		None		252		252		251		251		None
form_id		F410		F420		F405		F420		F420		F420		F420		F420		F420		F420		F420		F420		F420		F460		F405		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F666		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F497		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		F497		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F410		F410		F460		F497		F497		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F497		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		F497		F460		F410		F460		F460		F460		F460		F460		F497		F460		F497		F410		F460		F460		F497		F497		F497		F460		F497		F497		F460		F460		F460		F460		F410		F410		F460		F460		F497		F497		F460		F460		F460		F497		F497		F460		F460		F497		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F497		F497		F460		F460		F460		F460		F460		F410		F460		F460		F410		F460		F497		F460		F410		F497		F410		F460		F497		F497		F460		F460		F460		F497		F460		F460		F410		F460		F497		F497		F460		F460		F460		F460		F460		F410		F497		F410		F460		F460		F497		F497		F460		F460		F460
filing_sequence		0		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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		0		0		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		1		0		0		0		0		1		0		0		0		0		0		1		1		0		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		1		0		0		0		0		0		0		0		0		0		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		3		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		6		0		0		0		0		0		0		5		0		4		0		0		0		0		0		0		0		0		0		7		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0
filing_date		1997-06-25 00:00:00		1997-07-03 00:00:00		1997-08-15 00:00:00		1998-01-21 00:00:00		1998-03-18 00:00:00		1998-05-18 00:00:00		1998-07-13 00:00:00		1998-10-01 00:00:00		1999-07-14 00:00:00		1999-10-06 00:00:00		1998-10-19 00:00:00		1999-01-15 00:00:00		2000-01-03 00:00:00		2000-07-18 00:00:00		2000-10-24 00:00:00		2000-10-24 00:00:00		2000-10-02 00:00:00		2001-01-26 00:00:00		2000-11-22 00:00:00		2000-11-08 00:00:00		2001-10-10 00:00:00		2001-07-24 00:00:00		2001-09-05 00:00:00		2001-10-08 00:00:00		2002-01-22 00:00:00		2002-01-10 00:00:00		2002-01-09 00:00:00		2002-01-22 00:00:00		2002-02-21 00:00:00		2002-05-31 00:00:00		2002-02-19 00:00:00		2002-07-15 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2002-07-18 00:00:00		2002-10-01 00:00:00		2003-01-13 00:00:00		2003-01-14 00:00:00		2003-07-14 00:00:00		2003-07-16 00:00:00		2003-10-03 00:00:00		2003-10-02 00:00:00		2004-01-06 00:00:00		2004-01-09 00:00:00		2004-02-17 00:00:00		2004-02-20 00:00:00		2004-02-16 00:00:00		2004-07-21 00:00:00		2004-02-20 00:00:00		2004-07-22 00:00:00		2004-10-04 00:00:00		2004-10-01 00:00:00		2004-10-18 00:00:00		2004-10-18 00:00:00		2005-01-13 00:00:00		2005-01-14 00:00:00		2005-07-05 00:00:00		2005-07-05 00:00:00		2006-01-13 00:00:00		2005-10-11 00:00:00		2005-10-11 00:00:00		2006-01-12 00:00:00		2006-03-20 00:00:00		2006-03-20 00:00:00		2006-06-23 00:00:00		2006-05-24 00:00:00		2006-07-05 00:00:00		2006-07-10 00:00:00		2006-05-23 00:00:00		2006-05-23 00:00:00		2006-06-23 00:00:00		2006-10-03 00:00:00		2006-10-02 00:00:00		2006-10-27 00:00:00		2007-01-22 00:00:00		2007-01-23 00:00:00		2006-10-25 00:00:00		2007-07-05 00:00:00		2006-10-27 00:00:00		2006-10-25 00:00:00		2006-05-23 00:00:00		2007-07-02 00:00:00		2008-01-18 00:00:00		2008-01-22 00:00:00		2013-07-16 00:00:00		2013-07-16 00:00:00		2015-07-08 00:00:00		2015-07-08 00:00:00		2014-05-20 00:00:00		2014-05-23 00:00:00		2015-01-08 00:00:00		2014-10-21 00:00:00		2014-10-07 00:00:00		2014-10-21 00:00:00		2008-03-19 00:00:00		2008-03-19 00:00:00		2008-07-15 00:00:00		2008-07-10 00:00:00		2008-10-03 00:00:00		2008-05-20 00:00:00		2008-05-21 00:00:00		2008-10-20 00:00:00		2008-10-06 00:00:00		2009-01-19 00:00:00		2008-10-21 00:00:00		2009-01-12 00:00:00		2009-01-06 00:00:00		2009-01-13 00:00:00		2009-01-20 00:00:00		2009-05-13 00:00:00		2009-05-13 00:00:00		2009-07-14 00:00:00		2009-07-14 00:00:00		2010-01-21 00:00:00		2009-05-06 00:00:00		2010-03-22 00:00:00		2010-04-12 00:00:00		2010-04-13 00:00:00		2010-01-20 00:00:00		2010-06-15 00:00:00		2010-06-15 00:00:00		2010-05-25 00:00:00		2010-06-03 00:00:00		2010-03-22 00:00:00		2010-07-20 00:00:00		2010-10-04 00:00:00		2010-07-19 00:00:00		2010-05-24 00:00:00		2010-06-02 00:00:00		2010-10-18 00:00:00		2010-10-18 00:00:00		2010-10-04 00:00:00		2011-01-13 00:00:00		2011-07-19 00:00:00		2011-01-12 00:00:00		2011-07-19 00:00:00		2012-01-12 00:00:00		2012-01-12 00:00:00		2012-03-22 00:00:00		2012-03-20 00:00:00		2012-05-22 00:00:00		2012-05-22 00:00:00		2012-05-24 00:00:00		2012-07-10 00:00:00		2012-05-24 00:00:00		2012-07-10 00:00:00		2014-03-18 00:00:00		2014-03-18 00:00:00		2014-01-31 00:00:00		2014-01-31 00:00:00		2012-10-01 00:00:00		2012-10-02 00:00:00		2015-01-16 00:00:00		2015-01-07 00:00:00		2012-12-19 00:00:00		2012-10-23 00:00:00		2012-10-23 00:00:00		2014-10-02 00:00:00		2014-10-03 00:00:00		2014-07-09 00:00:00		2014-08-06 00:00:00		2014-07-10 00:00:00		2014-09-11 00:00:00		2012-12-20 00:00:00		2013-01-16 00:00:00		2013-01-17 00:00:00		2014-03-06 00:00:00		2014-03-06 00:00:00		2014-05-07 00:00:00		2014-05-19 00:00:00		2014-05-09 00:00:00		2014-05-21 00:00:00		2016-01-07 00:00:00		2016-01-07 00:00:00		2019-01-02 00:00:00		2020-07-28 00:00:00		2018-01-09 00:00:00		2018-01-08 00:00:00		2018-05-21 00:00:00		2018-05-21 00:00:00		2018-08-21 00:00:00		2016-04-04 00:00:00		2016-05-23 00:00:00		2016-04-27 00:00:00		2016-04-28 00:00:00		2016-05-04 00:00:00		2016-06-02 00:00:00		2016-05-23 00:00:00		2016-07-08 00:00:00		2016-08-16 00:00:00		2016-07-12 00:00:00		2016-09-26 00:00:00		2016-09-08 00:00:00		2016-10-12 00:00:00		2016-09-27 00:00:00		2016-10-24 00:00:00		2017-01-12 00:00:00		2016-10-26 00:00:00		2017-01-13 00:00:00		2017-07-10 00:00:00		2017-07-11 00:00:00		2018-09-25 00:00:00		2018-07-06 00:00:00		2018-01-08 00:00:00		2018-09-25 00:00:00		2020-07-27 00:00:00		2020-10-20 00:00:00		2020-10-01 00:00:00		2018-06-04 00:00:00		2021-01-29 00:00:00		2019-07-02 00:00:00		2018-07-06 00:00:00		2018-01-09 00:00:00		2020-09-24 00:00:00		2021-07-22 00:00:00		2019-07-03 00:00:00		2020-01-09 00:00:00		2018-08-03 00:00:00		2021-07-29 00:00:00		2019-02-13 00:00:00		2020-10-22 00:00:00		2020-07-13 00:00:00		2018-05-01 00:00:00		2018-08-02 00:00:00		2019-01-02 00:00:00		2020-08-12 00:00:00		2018-10-29 00:00:00		2020-09-23 00:00:00		2022-05-26 00:00:00		2020-07-13 00:00:00		2022-04-08 00:00:00		2022-04-28 00:00:00		2020-01-09 00:00:00		2021-11-03 00:00:00		2022-05-26 00:00:00		2022-04-25 00:00:00		2022-02-16 00:00:00		2022-01-28 00:00:00		2022-04-28 00:00:00		2021-01-21 00:00:00		2022-07-29 00:00:00		2022-07-29 00:00:00		2021-07-22 00:00:00		2022-08-10 00:00:00		2021-11-05 00:00:00		2021-07-30 00:00:00		2022-01-28 00:00:00		2022-10-11 00:00:00		2022-10-25 00:00:00		2022-10-27 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10005		10005		10006		10006		10005		10005		10001		10001		10001		10005		10001		10005		10005		10005		10001		10001		10001		10001		10005		10005		10001		10005		10001		10005		10005		10001		10001		10005		10005		10001		10001		10001		10005		10005		10005		10001		10005		10001		10001		10005		10001		10005		10005		10005		10001		10001		10001		10005		10002		10005		10001		10005		10001		10001		10006		10005		10001		10002		10001		10005		10001		10005		10006		10005		10005		10001		10001		10005		10001		10005		10001		10005		10005		10001		10005		10005		10001		10001		10001		10005		10005		10001		10001		10001		10005		10001		10005		10001		10005		10002		10001		10006		10005		10006		10002		10001		10005		10005		10001		10005		10002		10006		10001		10002		10006		10005		10005		10001		10005		10001		10001		10001		10001		10005		10001		10005		10005		10005		10001		10001		10001		10005		10005		10001		10002		10001		10005		10001		10006		10005		10001		10005		10001		10005		10001		10005		10001		10001		10002		10001		10005		10001		10005		10001		10001		10005		10001		10006		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10006		10002		10001		10005		10001		10001		10001		10001		10005		10001		10001		10005		10001		10001		10005		10001		10001		10001		10005		10001		10001		10005		10005		10001		10005		10005		10005		10001		10001		10006		10001		10001		10001		10005		10001		10001		10005		10005		10002		10005		10001		10006		10001		10001		10005		10002		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10005		10002		10005		10001		10001		10001		10005		10001		10005		10001		10006		10001		10002		10005		10005		10001		10002		10001		10001		10005
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11001		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11003		11003		11003		11001		11003		11001		11003		11001		11003		11001		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11003		11001		11003		11001		11003		11001		11001		11003		11003		11003		11003		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003
session_id		1997		1997		1997		1997		1997		1997		1997		1997		1999		1999		1997		1997		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		1999		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		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2005		2005		2007		2007		2007		2013		2013		2015		2015		2013		2013		2013		2013		2013		2013		2007		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		2011		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2011		2011		2015		2013		2011		2011		2011		2013		2013		2013		2013		2013		2013		2011		2011		2011		2013		2013		2013		2013		2013		2013		2015		2015		2017		2019		2017		2017		2017		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2019		2019		2019		2017		2021		2019		2017		2017		2019		2021		2019		2019		2017		2021		2019		2019		2019		2017		2017		2017		2019		2017		2019		2021		2019		2021		2021		2019		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		KCHAN		KCHAN		KCHAN		TWALLS		DHORRELL		KCHAN		CFLAGG		GPEREZ		DHORRELL		*		*		CFLAGG		*		CFLAGG		KLARRY		PROBERTS		*		*		*		*		DBARRICK		DBARRICK		COMPLETED		DBARRICK		COMPLETED		KLARRY		KVANG		COMPLETED		COMPLETED		KLARRY		KLARRY		COMPLETED		COMPLETED		COMPLETED		LLEONG		EMCENTEE		CFLAGG		COMPLETED		CFLAGG		COMPLETED		COMPLETED		GPEREZ		*		CFLAGG		GPEREZ		GPEREZ		*		*		*		GPEREZ		*		CFLAGG		*		CFLAGG		*		DHORRELL		RGEREMIA		GPEREZ		*		DHORRELL		*		SARRIAGA		DHORRELL		GPEREZ		DHORRELL		DHORRELL		DHORRELL		*		*		HTSUBOI		MDIGRAZIA		MDIGRAZIA		SARRIAGA		SARRIAGA		MDIGRAZIA		WBROWN		DODONOGHUE		SARRIAGA		WBROWN		SARRIAGA		*		SARRIAGA		SARRIAGA		*		*		*		SARRIAGA		*		RGEREMIA		*		RGEREMIA		*		*		RGEREMIA		JVAZQUEZ		GKURIMOT		DHORRELL		CPON		CPON		MMORENO		DHORRELL		SARRIAGA		*		JVAZQUEZ		MMORENO		*		MPACHECO		SARRIAGA		DHORRELL		*		CPON		CPON		CPON		*		DHORRELL		SMCCONNAN		SMCCONNAN		CPON		CPON		MMORENO		CPON		MMORENO		CPON		CPON		CPON		CPON		CAFILER		MDIGRAZIA		MDIGRAZIA		CPON		MPACHECO		CPON		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		CAFILER		MPACHECO		WBROWN		CAFILER		CAFILER		CAFILER		MPACHECO		CAFILER		JINGRAM		CAFILER		WBROWN		MPACHECO		WBROWN		TRAMON		CAFILER		MPACHECO		WBROWN		WBROWN		WBROWN		MDIGRAZIA		WBROWN		WBROWN		MDIGRAZIA		MDIGRAZIA		VUKSTINA		KRUSSELL		TRAMON		TRAMON		CSAGABAEN		CSAGABAEN		CAFILER		KBANH		SMCCONNAN		MDIGRAZIA		MDIGRAZIA		KBANH		KBANH		SMCCONNAN		SMCCONNAN		PDEO		SMCCONNAN		SARRIAGA		PDEO		PDEO		SARRIAGA		LBARTHOL		SARRIAGA		LBARTHOL		SARRIAGA		LBARTHOL		LBARTHOL		BSINGH		HSTOVALL		LBARTHOL		BSINGH		TRAMON		KRUSSELL		CAFILER		CAFILER		CREYNOLDS		YMORA		HSTOVALL		LBARTHOL		KRUSSELL		CAFILER		YMORA		SUSHAKOV		TRAMON		DCODY		CAFILER		KRUSSELL		TRAMON		CAFILER		TRAMON		VUKSTINA		CAFILER		CAFILER		KRUSSELL		CAFILER		KRUSSELL		CAFILER		KRUSSELL		SUSHAKOV		CAFILER		JMAVES		CAFILER		CAFILER		KRUSSELL		KRUSSELL		CREYNOLDS		JMAVES		CAFILER		IMEDINA		CAFILER		IMEDINA		DCODY		KRUSSELL		CAFILER		CAFILER		CAFILER		CAFILER		AXIONG
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		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		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		11003		11003		11003		11001		11003		11003		11001		11003		11001		11001		11001		11003		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		None		1997-01-01 00:00:00		None		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		1999-01-01 00:00:00		1999-07-01 00:00:00		1998-10-01 00:00:00		1998-10-18 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		2000-07-01 00:00:00		2000-10-22 00:00:00		2000-10-01 00:00:00		2000-07-01 00:00:00		2001-07-01 00:00:00		2001-01-01 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		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-01-20 00:00:00		1999-01-01 00:00:00		2002-01-20 00:00:00		2002-02-17 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-02-17 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-02-20 00:00:00		2004-01-01 00:00:00		2004-02-15 00:00:00		None		2004-02-15 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2004-10-17 00:00:00		2004-10-17 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-10-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-01-01 00:00:00		2006-03-18 00:00:00		2006-03-18 00:00:00		2006-05-21 00:00:00		2006-05-21 00:00:00		2006-03-18 00:00:00		2006-05-23 00:00:00		2006-03-18 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2006-10-27 00:00:00		2006-10-01 00:00:00		2006-10-01 00:00:00		2006-10-25 00:00:00		2007-01-01 00:00:00		None		None		None		2007-01-01 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2014-03-18 00:00:00		2014-05-23 00:00:00		2014-10-19 00:00:00		2014-10-01 00:00:00		2014-10-07 00:00:00		2014-10-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-05-18 00:00:00		2008-05-18 00:00:00		2008-07-01 00:00:00		2008-03-18 00:00:00		2008-03-18 00:00:00		2008-10-01 00:00:00		2008-07-01 00:00:00		2008-10-19 00:00:00		2008-10-01 00:00:00		2009-01-12 00:00:00		2009-01-06 00:00:00		None		2008-10-19 00:00:00		None		2009-05-13 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-05-06 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2009-07-01 00:00:00		2010-03-18 00:00:00		2010-03-18 00:00:00		2010-03-18 00:00:00		None		2010-01-01 00:00:00		2010-05-23 00:00:00		2010-07-01 00:00:00		2010-05-23 00:00:00		2010-03-18 00:00:00		2010-06-02 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		2010-07-01 00:00:00		2010-10-17 00:00:00		2011-01-01 00:00:00		2010-10-17 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		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-03-18 00:00:00		2012-03-18 00:00:00		2012-05-20 00:00:00		2012-01-01 00:00:00		2012-05-20 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2015-01-16 00:00:00		2014-10-19 00:00:00		2012-12-13 00:00:00		2012-10-01 00:00:00		2012-10-01 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2014-05-18 00:00:00		2014-08-06 00:00:00		2014-05-18 00:00:00		2014-09-11 00:00:00		None		2012-10-21 00:00:00		2012-10-21 00:00:00		2014-03-05 00:00:00		2014-03-06 00:00:00		2014-05-07 00:00:00		2014-03-18 00:00:00		2014-05-09 00:00:00		2014-05-20 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2018-09-23 00:00:00		2020-01-01 00:00:00		None		2018-01-03 00:00:00		2018-01-01 00:00:00		2018-01-01 00:00:00		2018-08-21 00:00:00		2016-04-04 00:00:00		2016-04-24 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-05-04 00:00:00		2016-06-02 00:00:00		2016-04-24 00:00:00		2016-05-22 00:00:00		2016-08-16 00:00:00		2016-05-22 00:00:00		2016-07-01 00:00:00		2016-09-08 00:00:00		2016-10-11 00:00:00		2016-07-01 00:00:00		2016-09-25 00:00:00		2016-10-23 00:00:00		2016-09-25 00:00:00		2016-10-23 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2018-07-01 00:00:00		2018-05-20 00:00:00		2017-07-01 00:00:00		2018-07-01 00:00:00		None		2020-09-20 00:00:00		2020-10-01 00:00:00		2018-06-04 00:00:00		2020-10-18 00:00:00		2019-01-01 00:00:00		2018-05-20 00:00:00		2017-07-01 00:00:00		2020-07-01 00:00:00		2021-06-01 00:00:00		2019-01-01 00:00:00		2019-07-01 00:00:00		None		2021-01-01 00:00:00		2019-02-13 00:00:00		2020-09-20 00:00:00		2020-07-01 00:00:00		2018-05-01 00:00:00		2018-08-01 00:00:00		2018-09-23 00:00:00		2020-08-12 00:00:00		2018-10-29 00:00:00		2020-07-01 00:00:00		2022-04-24 00:00:00		2020-01-01 00:00:00		2022-04-08 00:00:00		2022-01-01 00:00:00		2019-07-01 00:00:00		2021-11-01 00:00:00		2022-04-24 00:00:00		2022-04-25 00:00:00		2022-02-16 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2020-10-18 00:00:00		2022-05-22 00:00:00		2022-05-22 00:00:00		None		2022-08-10 00:00:00		None		2021-01-01 00:00:00		2021-07-01 00:00:00		2022-10-11 00:00:00		2022-10-25 00:00:00		2022-09-25 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00
rpt_end		None		1997-06-30 00:00:00		None		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		1999-06-30 00:00:00		1999-09-30 00:00:00		1998-10-17 00:00:00		1998-12-31 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-10-21 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		2000-10-21 00:00:00		2000-09-30 00:00:00		2001-09-30 00:00:00		2001-06-30 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		2001-12-31 00:00:00		2002-01-19 00:00:00		2002-02-16 00:00:00		2000-12-31 00:00:00		2002-02-16 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-09-30 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-06-30 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-02-14 00:00:00		2004-02-20 00:00:00		2004-02-14 00:00:00		2004-06-30 00:00:00		None		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-10-16 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-06-30 00:00:00		2005-12-31 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-17 00:00:00		2006-05-20 00:00:00		2006-05-20 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2006-05-20 00:00:00		2006-05-23 00:00:00		2006-05-20 00:00:00		2006-09-30 00:00:00		2006-09-30 00:00:00		2006-10-27 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2006-10-25 00:00:00		2007-06-30 00:00:00		None		None		None		2007-06-30 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2014-05-17 00:00:00		2014-05-23 00:00:00		2014-12-31 00:00:00		2014-10-18 00:00:00		2014-10-07 00:00:00		2014-10-18 00:00:00		2008-03-17 00:00:00		2008-03-17 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-05-17 00:00:00		2008-05-17 00:00:00		2008-10-18 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2008-10-18 00:00:00		2009-01-12 00:00:00		2009-01-06 00:00:00		None		2008-12-31 00:00:00		None		2009-05-13 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-05-06 00:00:00		2010-03-17 00:00:00		2010-03-17 00:00:00		2010-03-17 00:00:00		2009-12-31 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		None		2010-03-17 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-05-22 00:00:00		2010-06-02 00:00:00		2010-10-16 00:00:00		2010-10-16 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-03-17 00:00:00		2012-03-17 00:00:00		2012-03-17 00:00:00		2012-05-19 00:00:00		2012-05-19 00:00:00		2012-06-30 00:00:00		2012-03-17 00:00:00		2012-06-30 00:00:00		2014-03-17 00:00:00		2014-03-17 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2015-01-16 00:00:00		2014-12-31 00:00:00		2012-12-13 00:00:00		2012-10-20 00:00:00		2012-10-20 00:00:00		2014-09-30 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2014-08-06 00:00:00		2014-06-30 00:00:00		2014-09-11 00:00:00		None		2012-12-31 00:00:00		2012-12-31 00:00:00		2014-03-05 00:00:00		2014-03-06 00:00:00		2014-05-07 00:00:00		2014-05-17 00:00:00		2014-05-09 00:00:00		2014-05-20 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2018-12-31 00:00:00		2020-06-30 00:00:00		None		2018-01-03 00:00:00		2018-05-19 00:00:00		2018-05-19 00:00:00		2018-08-21 00:00:00		2016-04-04 00:00:00		2016-05-21 00:00:00		2016-04-23 00:00:00		2016-04-23 00:00:00		2016-05-04 00:00:00		2016-06-02 00:00:00		2016-05-21 00:00:00		2016-06-30 00:00:00		2016-08-16 00:00:00		2016-06-30 00:00:00		2016-09-24 00:00:00		2016-09-08 00:00:00		2016-10-11 00:00:00		2016-09-24 00:00:00		2016-10-22 00:00:00		2016-12-31 00:00:00		2016-10-22 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2018-09-22 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2018-09-22 00:00:00		None		2020-10-17 00:00:00		2020-10-01 00:00:00		2018-06-04 00:00:00		2020-12-31 00:00:00		2019-06-30 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2020-09-19 00:00:00		2021-06-01 00:00:00		2019-06-30 00:00:00		2019-12-31 00:00:00		None		2021-06-30 00:00:00		2019-02-13 00:00:00		2020-10-17 00:00:00		2020-07-01 00:00:00		2018-05-01 00:00:00		2018-08-01 00:00:00		2018-12-31 00:00:00		2020-08-12 00:00:00		2018-10-29 00:00:00		2020-09-19 00:00:00		2022-05-21 00:00:00		2020-06-30 00:00:00		2022-04-08 00:00:00		2022-04-23 00:00:00		2019-12-31 00:00:00		2021-11-01 00:00:00		2022-05-21 00:00:00		2022-04-25 00:00:00		2022-02-16 00:00:00		2021-12-31 00:00:00		2022-04-23 00:00:00		2020-12-31 00:00:00		2022-06-30 00:00:00		2022-06-30 00:00:00		None		2022-08-10 00:00:00		None		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-10-11 00:00:00		2022-10-25 00:00:00		2022-10-22 00:00:00		2022-09-24 00:00:00		2022-09-24 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		2001-07-13 00:00:00		2001-10-05 00:00:00		2002-01-22 00:00:00		None		2002-01-09 00:00:00		None		None		None		2002-02-19 00:00:00		2002-07-11 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		None		None		2003-01-10 00:00:00		None		2003-07-09 00:00:00		None		None		2003-10-01 00:00:00		2004-01-02 00:00:00		None		None		2004-02-20 00:00:00		2004-02-16 00:00:00		2004-07-07 00:00:00		None		None		None		2004-10-01 00:00:00		None		2004-10-17 00:00:00		2005-01-11 00:00:00		None		2005-06-29 00:00:00		None		None		None		2005-10-05 00:00:00		2006-01-10 00:00:00		2006-03-18 00:00:00		None		2006-06-19 00:00:00		None		2006-07-05 00:00:00		None		2006-05-22 00:00:00		2006-05-23 00:00:00		None		None		2006-09-30 00:00:00		2006-10-27 00:00:00		2007-01-18 00:00:00		None		2006-10-25 00:00:00		None		None		None		None		2007-07-02 00:00:00		2008-01-16 00:00:00		None		2013-07-11 00:00:00		None		2015-07-06 00:00:00		None		None		2014-05-23 00:00:00		None		None		2014-10-07 00:00:00		2014-10-20 00:00:00		2008-03-18 00:00:00		None		None		2008-07-07 00:00:00		2008-10-03 00:00:00		2008-05-19 00:00:00		None		2008-10-20 00:00:00		None		2009-01-19 00:00:00		None		None		None		None		None		None		2009-05-13 00:00:00		2009-07-07 00:00:00		None		None		2009-05-06 00:00:00		None		2010-04-07 00:00:00		None		2010-01-12 00:00:00		2010-06-10 00:00:00		None		None		None		2010-03-19 00:00:00		None		2010-10-01 00:00:00		2010-07-15 00:00:00		2010-05-24 00:00:00		2010-06-02 00:00:00		None		2010-10-18 00:00:00		None		None		None		2011-01-10 00:00:00		2011-07-18 00:00:00		2012-01-09 00:00:00		None		None		2012-03-19 00:00:00		2012-05-17 00:00:00		2012-05-21 00:00:00		None		2012-07-05 00:00:00		None		None		2014-03-18 00:00:00		None		2014-01-10 00:00:00		None		2012-10-01 00:00:00		None		2015-01-16 00:00:00		2015-01-06 00:00:00		None		2012-10-22 00:00:00		None		2014-10-01 00:00:00		None		2014-07-03 00:00:00		2014-08-06 00:00:00		None		2014-09-11 00:00:00		None		2013-01-14 00:00:00		None		2014-03-05 00:00:00		2014-03-06 00:00:00		2014-05-07 00:00:00		2014-05-19 00:00:00		2014-05-09 00:00:00		2014-05-20 00:00:00		2016-01-04 00:00:00		None		None		None		None		None		2018-05-21 00:00:00		None		2018-08-21 00:00:00		2016-04-04 00:00:00		2016-05-23 00:00:00		2016-04-25 00:00:00		None		2016-05-04 00:00:00		2016-06-02 00:00:00		None		2016-07-06 00:00:00		2016-08-16 00:00:00		None		2016-09-26 00:00:00		2016-09-08 00:00:00		2016-10-11 00:00:00		None		2016-10-24 00:00:00		2017-01-11 00:00:00		None		None		2017-07-05 00:00:00		None		None		None		2018-01-03 00:00:00		2018-09-24 00:00:00		None		2020-10-19 00:00:00		2020-10-01 00:00:00		2018-06-04 00:00:00		None		2019-07-01 00:00:00		2018-07-05 00:00:00		None		None		None		None		2020-01-02 00:00:00		None		2021-07-07 00:00:00		2019-02-13 00:00:00		None		None		2018-05-01 00:00:00		None		2019-01-02 00:00:00		2020-08-12 00:00:00		2018-10-29 00:00:00		2020-09-21 00:00:00		2022-05-23 00:00:00		2020-07-01 00:00:00		2022-04-08 00:00:00		2022-04-25 00:00:00		None		None		None		2022-04-25 00:00:00		2022-02-16 00:00:00		2022-01-11 00:00:00		None		2021-01-05 00:00:00		None		2022-07-13 00:00:00		None		2022-08-10 00:00:00		None		None		None		2022-10-11 00:00:00		2022-10-25 00:00:00		2022-10-22 00:00:00		2022-09-25 00:00:00		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		22001		None		None		22001		22001		None		None		22001		22001		22001		None		None		None		22001		None		22001		22001		None		22001		None		None		None		22001		22001		22001		None		22001		None		22001		None		22001		22001		None		None		22001		22001		22001		None		22001		None		None		None		None		22001		22001		None		22001		None		22001		None		None		22001		None		None		22001		22001		22001		None		None		22001		22001		22001		None		22001		None		22001		None		22001		22001		None		None		None		22001		22001		None		None		22001		None		22001		None		22001		22001		None		None		None		22001		None		22001		22001		22001		22001		None		22001		None		None		None		22001		22001		22001		None		None		22001		22001		22001		None		22001		None		None		22001		None		22001		None		22001		None		22001		22001		22001		22001		None		22001		None		22001		22001		None		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		None		None		None		None		22001		22001		None		22001		22001		22001		22001		None		22001		22001		None		22001		22001		None		22001		22001		22001		None		22001		22001		None		None		22001		None		None		None		22001		22001		None		22001		22001		22001		None		22001		22001		None		None		22001		None		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		None		22001		None		22001		None		22001		None		None		None		22001		22001		22001		22001		None

Table: filer_to_filer_type

filer_id		1070627		1070627
filer_type		16		16
active		Y		Y
race		0		0
session_id		1997		2009
category		0		0
category_type		40502		40502
sub_category		40103		40103
effect_dt		1997-06-25 00:00:00		2009-01-13 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		S		S
nyq_dt		None		1997-08-20 00:00:00
party_cd		None		None
county_cd		18004		18004
district_cd		None		None

Table: filer_xref

filer_id		1070627
xref_id		970787
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		970787		970787		970787		970787		970787		970787		970787		970787		970787		970787		970787		970787		970787		970787
filer_id		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627
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
status		ACTIVE		ACTIVE		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		2009-01-13 00:00:00		2009-01-13 00:00:00
naml		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE (AKA CSA PAC)		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE (AKA CSA PAC)		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE (AKA CSA PAC)		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE (AKA CSA PAC)		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE (AKA CSA PAC)		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE (AKA CSA PAC)		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE (AKA CSA PAC)		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA SEED ASSOCIATION POLITICAL ACTION COMMITTEE
namf		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
nams		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
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		958140000		958140000		95814		958140000		95814		95814		95814		958140000		958140000		95814		958140000		95814		95814		95814
phon		9164422280		9164412272		(916) 442-2272		9164422272		9164422272		9164422272		9164422272		9164422280		9164412272		(916) 442-2272		9164422272		9164422272		9164422272		9164422272
fax		None		None		(916) 442-1693		None		9164421693		9164421693		9164421693		None		None		(916) 442-1693		None		9164421693		9164421693		9164421693
email		None		None		336000jh		None		[email protected]		[email protected]		[email protected]		None		None		336000jh		None		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1070627

Table: received_filings

filer_id		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627		1070627
filing_file_name		779892_0.cal		785268_0.cal		804477_0.cal		808680_0.cal		820989_0.cal		849573_0.cal		869986_0.cal		869987_0.cal		901264_0.cal		941596_0.cal		961327_0.cal		978436_0.cal		997937_0.cal		1172831_0.cal		1387630_0.cal		126356.cal		1493865_0.cal		1211606_1.cal		1423073_1.cal		1423073_0.cal		1852699_0.cal		1848754_0.cal		1848168_0.cal		1826359_0.cal		1826236_0.cal		1854865_0.cal		2048852_0.cal		2075206_0.cal		2087849_0.cal		1884667_0.cal		1874649_0.cal		2025821_0.cal		1894294_0.cal		1926510_0.cal		2069117_0.cal		2039635_0.cal		2490614_0.cal		2285124_0.cal		2259387_0.cal		2358683_0.cal		351774.cal		2244085_0.cal		2316247_0.cal		351931.cal		2664314_0.cal		2731186_0.cal		2508043_0.cal		2710004_0.cal		2650366_0.cal		2670241_0.cal		2731186_1.cal
received_date		2001-09-05 00:00:00		2001-10-08 00:00:00		2002-01-09 00:00:00		2002-01-22 00:00:00		2002-02-19 00:00:00		2002-07-15 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2003-01-13 00:00:00		2003-07-14 00:00:00		2003-10-02 00:00:00		2004-01-06 00:00:00		2004-02-20 00:00:00		2006-05-23 00:00:00		2009-01-06 00:00:00		2009-01-12 00:00:00		2010-06-02 00:00:00		2006-10-27 00:00:00		2009-05-13 00:00:00		2009-05-06 00:00:00		2014-05-21 00:00:00		2014-05-09 00:00:00		2014-05-07 00:00:00		2014-03-06 00:00:00		2014-03-06 00:00:00		2014-05-23 00:00:00		2016-06-02 00:00:00		2016-09-08 00:00:00		2016-10-12 00:00:00		2014-09-11 00:00:00		2014-08-06 00:00:00		2016-04-04 00:00:00		2014-10-07 00:00:00		2015-01-16 00:00:00		2016-08-16 00:00:00		2016-05-04 00:00:00		2020-08-12 00:00:00		2018-08-21 00:00:00		2018-06-04 00:00:00		2019-02-13 00:00:00		2020-07-13 00:00:00		2018-05-01 00:00:00		2018-10-29 00:00:00		2020-07-13 00:00:00		2022-04-08 00:00:00		2022-10-11 00:00:00		2020-10-01 00:00:00		2022-08-10 00:00:00		2022-02-16 00:00:00		2022-04-25 00:00:00		2022-10-25 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		779892		785268		804477		808680		820989		849573		869986		869987		901264		941596		961327		978436		997937		1172831		1387630		None		1493865		1211606		1423073		1423073		1852699		1848754		1848168		1826359		1826236		1854865		2048852		2075206		2087849		1884667		1874649		2025821		1894294		1926510		2069117		2039635		2490614		2285124		2259387		2358683		None		2244085		2316247		None		2664314		2731186		2508043		2710004		2650366		2670241		2731186
form_id		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F410		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		None		F497		F497		F497		F497		F497		F497		F497
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 accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted