Home

Filer ID: 1012862

Table: filer_address

filer_id		1012862		1012862		1012862		1012862		1012862		1012862		1012862
adrid		1012398		2025385		2091052		2160438		2287294		2311995		2474999
effect_dt		1994-03-11 00:00:00		2001-10-10 00:00:00		2005-08-01 00:00:00		2009-02-02 00:00:00		2013-04-26 00:00:00		2014-01-27 00:00:00		2019-02-12 00:00:00
add_type		7050		7082		7051		7051		7051		7051		7051
session_id		1993		2001		2007		2007		2013		2013		2019

Table: filer_filings

filer_id		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862
filing_id		74553		74554		74555		74556		74557		74558		74559		74561		74562		74563		74564		74565		74566		74567		204889		204890		204891		204892		584019		74560		578289		601580		638599		673093		719749		743619		788522		806066		830078		888556		885072		885074		917997		911549		963796		965792		957487		980177		992236		1004321		1006794		1031987		1038474		1060532		1054716		1055604		1081615		1056583		1092476		1119306		1121191		1137786		1133876		1133876		1139068		1135153		1149250		1190020		1175729		1137786		1171609		1177290		1176760		1218109		1222309		1222308		1213752		1226770		1239225		1285152		1247089		1264398		1273148		1270232		1286564		1262208		1776579		1778256		1782059		1788935		1954459		1975478		1978824		1977576		1847531		1863654		1865407		1804636		1796932		1960027		1930146		1940791		1908368		1300471		1312382		1315459		1297772		1338998		1338480		1352026		1338946		1352919		1339502		1376578		1378656		1398733		1421934		1438588		1399124		1422458		1453864		1453120		1423078		1442043		1464791		1468803		1497520		1497573		1494004		1507651		1495184		1513986		1538117		1573403		1572671		1546300		1592655		1591994		1580980		1608782		1611377		1637515		1641456		1664576		1667243		1802558		1826579		1812753		1682771		1680636		1927940		1916422		1710193		1877402		1886248		1733466		1736333		1845063		1841502		1763139		1760605		1997925		1993191		2385064		2221537		2413079		2457236		2376207		2407618		2390697		2303229		2566160		2358209		2282758		2259215		2286452		2196462		2294766		2280364		2502207		2202027		2429198		2336771		2006497		2017558		2001281		2022298		1993312		2006701		2026592		2017096		2030404		2031130		2032363		2032351		2038923		2065105		2039702		2044901		2057607		2079566		2092187		2094913		2090533		2099112		2104783		2124083		2154526		2155931		2178258		2142770		2167313		2168505		2300446		2265839		2509514		2392467		2263346		2325323		2544543		2182435		2220509		2228480		2479084		2243435		2301520		2461601		2196280		2217412		2371756		2296503		2411995		2387018		2680117		2686749		2503637		2519418		2616586		2659990		2664668		2702881		2637937		2617555		2656284		2723506		2716766		2675926		2715284		2716382		2721172		2735288
period_id		157		133		137		140		140		137		147		145		156		153		157		158		159		159		140		141		147		156		None		145		None		None		None		None		163		None		None		168		None		None		172		172		None		169		175		None		None		176		None		177		None		177		None		None		180		180		179		None		None		181		None		None		183		183		None		184		184		185		186		None		None		186		186		188		None		None		188		None		187		190		None		None		None		None		None		189		215		214		None		215		221		222		None		None		218		217		None		216		215		221		None		221		220		None		192		None		191		None		194		193		194		None		None		196		None		195		197		198		None		None		None		199		198		None		200		None		None		None		202		201		202		None		204		205		203		None		None		205		None		206		None		207		None		210		210		None		None		216		None		209		219		220		212		219		219		211		None		218		218		None		213		None		224		238		233		None		241		None		239		238		236		None		None		235		234		235		None		235		235		243		232		240		235		None		225		224		225		223		224		226		225		226		226		225		226		None		None		226		226		226		227		228		228		228		228		228		227		229		None		231		None		230		None		236		None		244		None		233		236		243		231		None		234		241		234		236		None		231		233		237		235		239		238		250		250		None		244		245		249		250		249		248		None		None		251		251		250		251		None		251		252
form_id		F461		F461		F461		F497		F405		F461		F461		F405		F497		F461		F497		F461		F461		F405		F497		F461		F405		F497		F405		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F497		F497		F497		F461		F497		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F497		F461		F461		F497		F497		F497		F497		F497		F497		F461		F461		F461		F461		F461		F497		F497		F461		F461		F497		F461		F461		F497		F497		F461		F461		F461		F497		F461		F461		F497		F461		F461		F461		F497		F497		F461		F461		F461		F461		F497		F497		F461		F497		F461		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F497		F497		F497		F461		F497		F461		F497		F497		F461		F497		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F497		F497		F497		F497		F461		F461		F497		F497		F461		F461		F461		F497		F497		F497		F461		F497		F461		F497		F461		F497		F461		F461		F497		F497		F497		F461		F497		F497		F497		F461		F461		F461		F461		F497		F497		F497		F461		F461		F497		F497		F497		F497		F461		F497		F461		F461		F497		F497		F461		F497		F497		F497		F497		F497		F497		F461		F461		F461		F497		F461		F461		F461		F497		F461		F497		F461		F461		F497		F461		F497		F461		F497		F461		F497		F497		F461		F461		F497		F461		F497		F461		F497		F497		F497		F461		F497		F461		F497		F497		F461		F461		F461		F461		F497		F497		F497		F497		F461		F497		F497
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		1999-04-30 00:00:00		1994-01-31 00:00:00		1994-08-01 00:00:00		1994-11-07 00:00:00		1994-11-09 00:00:00		1995-01-30 00:00:00		1996-12-27 00:00:00		1997-01-28 00:00:00		1998-10-22 00:00:00		1999-01-29 00:00:00		1999-01-15 00:00:00		1999-08-02 00:00:00		1999-10-12 00:00:00		1999-11-10 00:00:00		1994-11-04 00:00:00		1996-01-30 00:00:00		1997-01-21 00:00:00		1998-10-20 00:00:00		1999-12-23 00:00:00		1997-01-31 00:00:00		2000-01-10 00:00:00		2000-03-01 00:00:00		2000-03-01 00:00:00		2000-07-31 00:00:00		2001-01-31 00:00:00		2001-01-31 00:00:00		2001-10-10 00:00:00		2002-01-11 00:00:00		2002-01-10 00:00:00		2002-10-31 00:00:00		2002-10-31 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2003-10-10 00:00:00		2003-10-10 00:00:00		2003-07-31 00:00:00		2004-01-12 00:00:00		2004-01-12 00:00:00		2004-03-02 00:00:00		2004-03-02 00:00:00		2004-08-02 00:00:00		2004-08-02 00:00:00		2004-10-27 00:00:00		2004-10-26 00:00:00		2004-10-27 00:00:00		2005-01-31 00:00:00		2004-10-26 00:00:00		2005-01-31 00:00:00		2005-08-01 00:00:00		2005-08-01 00:00:00		2005-10-31 00:00:00		2005-10-31 00:00:00		2006-01-31 00:00:00		2005-11-02 00:00:00		2005-11-02 00:00:00		2006-01-31 00:00:00		2006-07-30 00:00:00		2006-05-26 00:00:00		2006-01-31 00:00:00		2006-01-31 00:00:00		2006-05-31 00:00:00		2006-05-30 00:00:00		2006-11-01 00:00:00		2006-05-31 00:00:00		2006-05-26 00:00:00		2006-10-27 00:00:00		2006-07-31 00:00:00		2007-02-01 00:00:00		2007-07-31 00:00:00		2007-01-31 00:00:00		2007-04-30 00:00:00		2006-10-27 00:00:00		2006-11-01 00:00:00		2007-07-31 00:00:00		2007-04-30 00:00:00		2013-07-19 00:00:00		2013-07-25 00:00:00		2013-07-29 00:00:00		2013-08-23 00:00:00		2015-03-24 00:00:00		2015-07-21 00:00:00		2015-07-27 00:00:00		2015-07-22 00:00:00		2014-05-06 00:00:00		2014-07-17 00:00:00		2014-07-17 00:00:00		2013-11-21 00:00:00		2013-10-24 00:00:00		2015-04-21 00:00:00		2015-01-26 00:00:00		2015-02-11 00:00:00		2014-10-29 00:00:00		2007-10-31 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2007-10-31 00:00:00		2008-05-29 00:00:00		2008-05-29 00:00:00		2008-07-31 00:00:00		2008-05-30 00:00:00		2008-07-31 00:00:00		2008-05-30 00:00:00		2008-10-30 00:00:00		2008-10-30 00:00:00		2009-02-02 00:00:00		2009-04-30 00:00:00		2009-07-31 00:00:00		2009-02-02 00:00:00		2009-04-30 00:00:00		2009-11-02 00:00:00		2009-11-02 00:00:00		2009-05-07 00:00:00		2009-07-31 00:00:00		2010-02-01 00:00:00		2010-02-01 00:00:00		2010-06-02 00:00:00		2010-06-04 00:00:00		2010-06-02 00:00:00		2010-08-02 00:00:00		2010-06-04 00:00:00		2010-08-02 00:00:00		2010-10-28 00:00:00		2011-02-01 00:00:00		2011-01-31 00:00:00		2010-10-28 00:00:00		2011-05-02 00:00:00		2011-05-02 00:00:00		2011-01-31 00:00:00		2011-08-01 00:00:00		2011-08-01 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00		2012-05-25 00:00:00		2012-06-01 00:00:00		2013-10-31 00:00:00		2014-01-27 00:00:00		2014-01-24 00:00:00		2012-07-31 00:00:00		2012-07-31 00:00:00		2015-01-22 00:00:00		2014-11-26 00:00:00		2012-10-31 00:00:00		2014-08-14 00:00:00		2014-09-18 00:00:00		2013-01-28 00:00:00		2013-01-29 00:00:00		2014-04-30 00:00:00		2014-04-25 00:00:00		2013-04-26 00:00:00		2013-04-23 00:00:00		2015-10-26 00:00:00		2015-10-22 00:00:00		2019-05-30 00:00:00		2018-03-13 00:00:00		2019-10-10 00:00:00		2020-02-25 00:00:00		2019-04-17 00:00:00		2019-08-22 00:00:00		2019-07-17 00:00:00		2018-10-08 00:00:00		2021-01-19 00:00:00		2019-01-24 00:00:00		2018-08-14 00:00:00		2018-06-04 00:00:00		2018-08-27 00:00:00		2017-11-16 00:00:00		2018-09-24 00:00:00		2018-08-07 00:00:00		2020-09-17 00:00:00		2018-01-16 00:00:00		2020-01-09 00:00:00		2019-01-22 00:00:00		2016-01-21 00:00:00		2016-02-26 00:00:00		2015-12-15 00:00:00		2016-03-22 00:00:00		2015-10-22 00:00:00		2016-01-26 00:00:00		2016-04-07 00:00:00		2016-02-24 00:00:00		2016-04-21 00:00:00		2016-04-22 00:00:00		2016-04-26 00:00:00		2016-04-26 00:00:00		2016-04-29 00:00:00		2016-07-26 00:00:00		2016-05-05 00:00:00		2016-05-23 00:00:00		2016-07-25 00:00:00		2016-09-21 00:00:00		2016-10-20 00:00:00		2016-10-25 00:00:00		2016-10-18 00:00:00		2016-10-28 00:00:00		2016-11-04 00:00:00		2017-01-26 00:00:00		2017-04-27 00:00:00		2017-04-27 00:00:00		2017-08-02 00:00:00		2017-01-30 00:00:00		2017-07-14 00:00:00		2017-07-12 00:00:00		2018-10-03 00:00:00		2018-07-12 00:00:00		2020-10-05 00:00:00		2019-07-19 00:00:00		2018-07-10 00:00:00		2018-11-12 00:00:00		2021-01-15 00:00:00		2017-08-30 00:00:00		2018-01-18 00:00:00		2018-04-05 00:00:00		2020-07-17 00:00:00		2018-05-01 00:00:00		2018-10-04 00:00:00		2020-01-14 00:00:00		2017-11-16 00:00:00		2018-02-21 00:00:00		2019-04-10 00:00:00		2018-09-27 00:00:00		2019-10-08 00:00:00		2019-06-20 00:00:00		2022-05-09 00:00:00		2022-05-26 00:00:00		2020-08-06 00:00:00		2020-10-21 00:00:00		2021-10-19 00:00:00		2022-03-24 00:00:00		2022-04-11 00:00:00		2022-07-28 00:00:00		2022-01-26 00:00:00		2021-10-20 00:00:00		2022-01-28 00:00:00		2022-09-26 00:00:00		2022-09-02 00:00:00		2022-05-02 00:00:00		2022-08-29 00:00:00		2022-08-01 00:00:00		2022-09-19 00:00:00		2022-10-18 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10005		10005		10005		10005		10001		10005		10005		10001		10005		10005		10001		10001		10005		10001		10001		10005		10005		10001		10005		10001		10005		10001		10005		10005		10001		10001		10001		10005		10005		10001		10005		10005		10001		10002		10005		10001		10001		10001		10001		10006		10005		10001		10001		10001		10005		10005		10001		10005		10001		10001		10005		10005		10005		10005		10005		10001		10001		10001		10005		10001		10001		10001		10005		10005		10001		10001		10005		10001		10001		10001		10005		10001		10001		10005		10001		10005		10001		10005		10001		10001		10001		10001		10005		10001		10005		10001		10001		10001		10005		10005		10005		10001		10001		10005		10001		10005		10005		10005		10001		10001		10001		10005		10001		10001		10001		10005		10005		10001		10005		10001		10005		10001		10005		10001		10001		10005		10005		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10005		10001		10005		10001		10001		10001		10005		10001		10005		10001		10001		10001		10005		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10005		10001		10005		10001		10005		10001		10005		10001		10001		10001		10001		10005		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10005		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11003		11001		11001		11003		11003		11003		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11003		11001		11003		11003		11003		11001		11003		11001		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11003
session_id		1999		1993		1993		1993		1993		1993		1995		1995		1997		1997		1999		1999		1999		1999		1993		1995		1995		1997		1999		1995		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		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		2007		2005		2007		2005		2007		2007		2005		2007		2007		2013		2013		2013		2013		2015		2015		2015		2015		2013		2013		2013		2013		2013		2015		2013		2015		2013		2007		2007		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		2011		2009		2009		2011		2011		2009		2011		2011		2011		2011		2011		2011		2013		2013		2013		2011		2011		2013		2013		2011		2013		2013		2011		2011		2013		2013		2013		2013		2015		2015		2019		2017		2019		2019		2019		2019		2019		2017		2021		2019		2017		2017		2017		2017		2017		2017		2019		2017		2019		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2015		2017		2017		2017		2017		2019		2019		2017		2017		2019		2017		2017		2017		2019		2017		2017		2019		2017		2017		2019		2017		2019		2019		2021		2021		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		*		BSMITH		*		TTHAM		GGILMORE		*		TWALLS		DBARRICK		*		YBONILLA		BSMITH		DHORRELL		*		LTHIBAUL		COMPLETED		COMPLETED		DHORRELL		GGILMORE		COMPLETED		GKURIMOT		COMPLETED		KLARRY		COMPLETED		DHORRELL		EMCENTEE		GKURIMOT		PBANFORD		GKURIMOT		GPEREZ		GKURIMOT		*		KLARRY		DHORRELL		*		*		KVANG		DMCCASTL		*		*		DJOHNSON		NLANDERS		DHORRELL		DJOHNSON		*		DHORRELL		LHOANG		LHOANG		DHORRELL		JMARTIN		*		*		JMARTIN		JMARTIN		CFLAGG		LHOANG		JMARTIN		*		RGEREMIA		JINGRAM		JINGRAM		WBROWN		WBROWN		JINGRAM		GCLARA		JINGRAM		WBROWN		JINGRAM		JINGRAM		WBROWN		JINGRAM		JINGRAM		JINGRAM		WBROWN		CAFILER		SMCCABE		SMCCABE		SMCCABE		*		LHOANG		DHORRELL		SMCCABE		DMCCASTL		SMCCABE		LHOANG		DHORRELL		RGEREMIA		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		DHORRELL		JINGRAM		JINGRAM		JINGRAM		DHORRELL		DHORRELL		PBANFORD		JINGRAM		PBANFORD		JINGRAM		WBROWN		CREYNOLDS		JINGRAM		MPACHECO		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		PBANFORD		PBANFORD		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		CAFILER		WBROWN		WBROWN		CAFILER		JINGRAM		JINGRAM		WBROWN		WBROWN		JINGRAM		JINGRAM		JINGRAM		WBROWN		CAFILER		PBANFORD		GTAYLOR		CAFILER		GTAYLOR		CAFILER		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		CAFILER		CAFILER		CAFILER		KBANH		CAFILER		CAFILER		CAFILER		DMCCASTL		GTAYLOR		GTAYLOR		JINGRAM		PDEO		WBROWN		KBANH		JINGRAM		JINGRAM		KBANH		PDEO		KBANH		KBANH		JINGRAM		KBANH		JINGRAM		AROBERTS		KBANH		KBANH		JINGRAM		PDEO		PDEO		PDEO		PDEO		PDEO		PDEO		JINGRAM		JINGRAM		JINGRAM		GKURIMOT		DWALKER		LPALMER		LPALMER		CAFILER		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		GKURIMOT		DMCCASTL		CAFILER		GTAYLOR		CAFILER		CAFILER		GTAYLOR		KBANH		PBANFORD		GTAYLOR		CAFILER		GTAYLOR		CAFILER		CAFILER		CAFILER		GTAYLOR		CAFILER		GTAYLOR		CAFILER		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		CAFILER		CAFILER		CAFILER		GTAYLOR		CAFILER		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11001		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		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		11002		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11003		11003		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11003
rpt_start		1999-01-01 00:00:00		1993-01-01 00:00:00		1994-01-01 00:00:00		None		None		1994-01-01 00:00:00		1996-07-01 00:00:00		1996-01-01 00:00:00		None		1998-01-01 00:00:00		None		1999-04-01 00:00:00		1999-07-01 00:00:00		1999-07-01 00:00:00		None		1995-01-01 00:00:00		1996-07-01 00:00:00		None		1999-07-01 00:00:00		1996-01-01 00:00:00		1999-10-01 00:00:00		None		None		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		None		2002-10-31 00:00:00		2002-10-31 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2004-03-02 00:00:00		None		2004-01-01 00:00:00		2004-01-01 00:00:00		None		2004-10-26 00:00:00		2004-10-27 00:00:00		2004-07-01 00:00:00		None		2004-07-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		None		2005-11-02 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-05-26 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-05-31 00:00:00		2006-05-30 00:00:00		2006-11-01 00:00:00		None		None		2006-10-27 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2007-04-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		None		None		2007-04-01 00:00:00		2007-01-01 00:00:00		2013-07-19 00:00:00		2013-04-01 00:00:00		2013-04-01 00:00:00		2013-08-23 00:00:00		2015-03-24 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2014-05-06 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2013-11-20 00:00:00		2013-07-01 00:00:00		2015-01-01 00:00:00		2014-07-01 00:00:00		2015-02-11 00:00:00		2014-10-29 00:00:00		2007-07-01 00:00:00		2007-10-01 00:00:00		2007-10-01 00:00:00		2007-07-01 00:00:00		None		2008-05-29 00:00:00		2008-01-01 00:00:00		2008-05-30 00:00:00		2008-01-01 00:00:00		None		2008-10-30 00:00:00		None		2008-07-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2008-07-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2009-05-07 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2009-10-01 00:00:00		None		None		2010-06-02 00:00:00		2010-01-01 00:00:00		2010-06-04 00:00:00		2010-01-01 00:00:00		2010-10-28 00:00:00		2011-02-01 00:00:00		2010-07-01 00:00:00		2010-10-27 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2010-07-01 00:00:00		2011-04-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-05-25 00:00:00		2012-06-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2013-10-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2014-07-01 00:00:00		2014-11-26 00:00:00		2012-10-31 00:00:00		2014-08-14 00:00:00		2014-09-18 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2014-04-30 00:00:00		2014-04-25 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2015-10-22 00:00:00		2019-05-30 00:00:00		2018-03-12 00:00:00		2019-07-01 00:00:00		2020-02-25 00:00:00		2019-01-01 00:00:00		2019-08-22 00:00:00		2019-04-01 00:00:00		2018-10-08 00:00:00		2020-07-01 00:00:00		2018-07-01 00:00:00		2018-08-14 00:00:00		2018-06-04 00:00:00		2018-08-27 00:00:00		2017-07-01 00:00:00		2018-09-24 00:00:00		2018-08-07 00:00:00		2020-09-17 00:00:00		2017-10-01 00:00:00		2019-10-01 00:00:00		2018-07-01 00:00:00		2015-10-01 00:00:00		2016-02-26 00:00:00		2015-12-15 00:00:00		2016-03-22 00:00:00		2015-07-01 00:00:00		2015-10-01 00:00:00		2016-04-07 00:00:00		2016-02-24 00:00:00		2016-04-21 00:00:00		2016-04-22 00:00:00		2016-01-01 00:00:00		2016-04-26 00:00:00		2016-01-01 00:00:00		2016-04-24 00:00:00		2016-05-05 00:00:00		2016-05-23 00:00:00		2016-04-24 00:00:00		2016-09-21 00:00:00		2016-10-20 00:00:00		2016-10-25 00:00:00		2016-10-18 00:00:00		2016-10-28 00:00:00		2016-11-04 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-08-02 00:00:00		2016-07-01 00:00:00		2017-04-01 00:00:00		2017-04-01 00:00:00		2018-10-03 00:00:00		2018-01-01 00:00:00		2020-10-05 00:00:00		2019-04-01 00:00:00		2018-01-01 00:00:00		2018-11-12 00:00:00		2020-07-01 00:00:00		2017-08-30 00:00:00		2017-10-01 00:00:00		2018-04-05 00:00:00		2020-01-01 00:00:00		2018-05-01 00:00:00		2018-10-04 00:00:00		2019-10-01 00:00:00		2017-07-01 00:00:00		2018-02-21 00:00:00		2019-01-01 00:00:00		2018-09-27 00:00:00		2019-07-01 00:00:00		2019-06-20 00:00:00		2022-05-09 00:00:00		2022-05-26 00:00:00		2020-01-01 00:00:00		2020-10-21 00:00:00		2021-01-01 00:00:00		2022-03-24 00:00:00		2022-04-11 00:00:00		2022-01-01 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		2021-10-01 00:00:00		2022-09-26 00:00:00		2022-09-02 00:00:00		2022-05-02 00:00:00		2022-08-29 00:00:00		2022-01-01 00:00:00		2022-09-19 00:00:00		2022-10-18 00:00:00
rpt_end		1999-03-31 00:00:00		1993-12-31 00:00:00		1994-06-30 00:00:00		None		None		1994-12-31 00:00:00		1996-12-31 00:00:00		1996-12-31 00:00:00		None		1998-12-31 00:00:00		None		1999-06-30 00:00:00		1999-09-30 00:00:00		1999-09-30 00:00:00		None		1995-12-31 00:00:00		1996-12-31 00:00:00		None		1999-09-30 00:00:00		1996-12-31 00:00:00		1999-12-31 00:00:00		None		None		2000-06-30 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		None		2002-10-31 00:00:00		2002-10-31 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-03-02 00:00:00		None		2004-06-30 00:00:00		2004-06-30 00:00:00		None		2004-10-26 00:00:00		2004-10-27 00:00:00		2004-12-31 00:00:00		None		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-09-30 00:00:00		2005-09-30 00:00:00		2005-09-30 00:00:00		None		2005-11-02 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-05-26 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-05-31 00:00:00		2006-05-30 00:00:00		2006-11-01 00:00:00		None		None		2006-10-27 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2006-12-31 00:00:00		2007-03-31 00:00:00		None		None		2007-06-30 00:00:00		2007-03-31 00:00:00		2013-07-19 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2013-08-23 00:00:00		2015-03-24 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2014-05-06 00:00:00		2014-06-30 00:00:00		2014-06-30 00:00:00		2013-11-20 00:00:00		2013-09-30 00:00:00		2015-03-31 00:00:00		2014-12-31 00:00:00		2015-02-11 00:00:00		2014-10-29 00:00:00		2007-09-30 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2007-09-30 00:00:00		None		2008-05-29 00:00:00		2008-06-30 00:00:00		2008-05-30 00:00:00		2008-06-30 00:00:00		None		2008-10-30 00:00:00		None		2008-12-31 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		2009-09-30 00:00:00		2009-09-30 00:00:00		2009-05-07 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		None		None		2010-06-02 00:00:00		2010-06-30 00:00:00		2010-06-04 00:00:00		2010-06-30 00:00:00		2010-10-28 00:00:00		2011-02-01 00:00:00		2010-12-31 00:00:00		2010-10-28 00:00:00		2011-03-31 00:00:00		2011-03-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-05-25 00:00:00		2012-06-01 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-06-30 00:00:00		2014-12-31 00:00:00		2014-11-26 00:00:00		2012-10-31 00:00:00		2014-08-14 00:00:00		2014-09-18 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		2014-04-30 00:00:00		2014-04-25 00:00:00		2013-03-31 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2015-10-22 00:00:00		2019-05-30 00:00:00		2018-03-12 00:00:00		2019-09-30 00:00:00		2020-02-25 00:00:00		2019-03-31 00:00:00		2019-08-22 00:00:00		2019-06-30 00:00:00		2018-10-08 00:00:00		2020-12-31 00:00:00		2018-12-31 00:00:00		2018-08-14 00:00:00		2018-06-04 00:00:00		2018-08-27 00:00:00		2017-09-30 00:00:00		2018-09-24 00:00:00		2018-08-07 00:00:00		2020-09-17 00:00:00		2017-12-31 00:00:00		2019-12-31 00:00:00		2018-12-31 00:00:00		2015-12-31 00:00:00		2016-02-26 00:00:00		2015-12-15 00:00:00		2016-03-22 00:00:00		2015-09-30 00:00:00		2015-12-31 00:00:00		2016-04-07 00:00:00		2016-02-24 00:00:00		2016-04-21 00:00:00		2016-04-22 00:00:00		2016-04-23 00:00:00		2016-04-26 00:00:00		2016-04-23 00:00:00		2016-06-30 00:00:00		2016-05-05 00:00:00		2016-05-23 00:00:00		2016-06-30 00:00:00		2016-09-21 00:00:00		2016-10-20 00:00:00		2016-10-25 00:00:00		2016-10-18 00:00:00		2016-10-28 00:00:00		2016-11-04 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		2017-03-31 00:00:00		2017-08-02 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2018-10-03 00:00:00		2018-06-30 00:00:00		2020-10-05 00:00:00		2019-06-30 00:00:00		2018-06-30 00:00:00		2018-11-12 00:00:00		2020-12-31 00:00:00		2017-08-30 00:00:00		2017-12-31 00:00:00		2018-04-05 00:00:00		2020-06-30 00:00:00		2018-05-01 00:00:00		2018-10-04 00:00:00		2019-12-31 00:00:00		2017-09-30 00:00:00		2018-02-21 00:00:00		2019-03-31 00:00:00		2018-09-27 00:00:00		2019-09-30 00:00:00		2019-06-20 00:00:00		2022-05-09 00:00:00		2022-05-26 00:00:00		2020-06-30 00:00:00		2020-10-21 00:00:00		2021-09-30 00:00:00		2022-03-24 00:00:00		2022-04-11 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2022-09-26 00:00:00		2022-09-02 00:00:00		2022-05-02 00:00:00		2022-08-29 00:00:00		2022-06-30 00:00:00		2022-09-19 00:00:00		2022-10-18 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		2001-01-31 00:00:00		None		None		2002-01-11 00:00:00		None		None		2002-10-31 00:00:00		2002-10-31 00:00:00		None		2003-01-24 00:00:00		2003-10-10 00:00:00		None		None		2004-01-12 00:00:00		None		2004-03-02 00:00:00		None		2004-07-21 00:00:00		None		None		2004-10-26 00:00:00		2004-10-27 00:00:00		2005-01-21 00:00:00		None		None		2005-07-14 00:00:00		None		None		2005-10-18 00:00:00		2005-11-01 00:00:00		None		2005-11-02 00:00:00		2006-01-19 00:00:00		2006-07-17 00:00:00		2006-05-26 00:00:00		None		None		2006-05-31 00:00:00		2006-05-30 00:00:00		2006-11-01 00:00:00		None		None		2006-10-27 00:00:00		None		2007-01-16 00:00:00		2007-07-18 00:00:00		None		None		None		None		None		2007-04-19 00:00:00		2013-07-19 00:00:00		2013-07-09 00:00:00		None		2013-08-23 00:00:00		2015-03-24 00:00:00		2015-07-21 00:00:00		None		None		2014-05-06 00:00:00		2014-07-17 00:00:00		None		2013-11-20 00:00:00		2013-10-01 00:00:00		2015-04-21 00:00:00		None		2015-02-11 00:00:00		2014-10-29 00:00:00		None		2008-01-19 00:00:00		None		2007-10-17 00:00:00		None		2008-05-29 00:00:00		2008-07-17 00:00:00		2008-05-30 00:00:00		None		None		2008-10-30 00:00:00		None		2009-01-23 00:00:00		2009-04-30 00:00:00		2009-07-14 00:00:00		None		None		None		2009-10-09 00:00:00		2009-05-07 00:00:00		None		2010-01-18 00:00:00		None		None		None		2010-06-02 00:00:00		2010-07-14 00:00:00		2010-06-04 00:00:00		None		2010-10-28 00:00:00		2011-02-01 00:00:00		2011-01-31 00:00:00		None		None		2011-04-19 00:00:00		None		2011-07-12 00:00:00		None		2012-01-17 00:00:00		None		2012-05-25 00:00:00		2012-06-01 00:00:00		None		None		2014-01-16 00:00:00		None		2012-07-25 00:00:00		2015-01-21 00:00:00		2014-11-26 00:00:00		2012-10-31 00:00:00		2014-08-14 00:00:00		2014-09-18 00:00:00		2013-01-25 00:00:00		None		2014-04-30 00:00:00		2014-04-25 00:00:00		None		2013-04-01 00:00:00		None		2015-10-22 00:00:00		2019-05-30 00:00:00		2018-03-12 00:00:00		None		2020-02-25 00:00:00		None		2019-08-22 00:00:00		2019-07-17 00:00:00		2018-10-08 00:00:00		None		None		2018-08-14 00:00:00		2018-06-04 00:00:00		2018-08-27 00:00:00		None		2018-09-24 00:00:00		2018-08-07 00:00:00		2020-09-17 00:00:00		2018-01-16 00:00:00		2019-01-09 00:00:00		2019-01-22 00:00:00		None		2016-02-26 00:00:00		2015-12-15 00:00:00		2016-03-22 00:00:00		2015-10-20 00:00:00		2016-01-19 00:00:00		2016-04-07 00:00:00		2016-02-24 00:00:00		2016-04-21 00:00:00		2016-04-22 00:00:00		2016-04-26 00:00:00		2016-04-26 00:00:00		None		None		2016-05-05 00:00:00		2016-05-23 00:00:00		2016-07-25 00:00:00		2016-09-21 00:00:00		2016-10-20 00:00:00		2016-10-25 00:00:00		2016-10-18 00:00:00		2016-10-28 00:00:00		2016-11-04 00:00:00		2017-01-26 00:00:00		2017-04-27 00:00:00		None		2017-08-02 00:00:00		None		2017-07-10 00:00:00		None		2018-10-03 00:00:00		None		2020-10-05 00:00:00		None		2018-07-10 00:00:00		2018-11-12 00:00:00		2021-01-15 00:00:00		2017-08-30 00:00:00		None		2018-04-05 00:00:00		2020-07-17 00:00:00		2018-05-01 00:00:00		2018-10-04 00:00:00		None		2017-11-15 00:00:00		2018-02-21 00:00:00		2019-04-10 00:00:00		2018-09-27 00:00:00		2019-10-08 00:00:00		2019-06-20 00:00:00		2022-05-09 00:00:00		2022-05-26 00:00:00		None		2020-10-21 00:00:00		2021-10-19 00:00:00		2022-03-24 00:00:00		2022-04-11 00:00:00		2022-07-28 00:00:00		2022-01-26 00:00:00		None		None		2022-09-26 00:00:00		2022-09-02 00:00:00		2022-05-02 00:00:00		2022-08-29 00:00:00		None		2022-09-19 00:00:00		2022-10-18 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		22001		22001		None		None		22001		None		22001		None		22001		None		None		22001		22001		22001		None		None		22001		None		None		22001		22001		None		22001		22001		22001		22001		None		None		22001		22001		22001		None		None		22001		None		22001		22001		None		None		None		None		None		22001		22001		22001		None		22001		22001		22001		None		None		22001		22001		None		22001		22001		22001		None		22001		22001		None		22001		None		22001		None		22001		22001		22001		None		None		22001		None		22001		22001		22001		None		None		None		22001		22006		None		22001		None		None		None		22001		22001		22001		None		22001		22001		22001		None		None		22001		None		22001		None		22001		None		22001		22001		None		None		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22001		None		22001		22001		22001		None		22001		None		22001		22001		22001		None		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		None		22001		None		22001		None		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		None		22001		22001

Table: filer_to_filer_type

filer_id		1012862
filer_type		10
active		Y
race		0
session_id		2007
category		0
category_type		40502
sub_category		0
effect_dt		1994-03-11 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		0
county_cd		18026
district_cd		0

Table: filer_xref

filer_id		1012862
xref_id		494059
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		494059		494059		494059		494059		494059		494059		494059		494059		494059		494059		494059		494059		494059		494059
filer_id		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1994-03-11 00:00:00		1994-03-11 00:00:00		1994-03-11 00:00:00		1994-03-11 00:00:00		1994-03-11 00:00:00		1994-03-11 00:00:00		1994-03-11 00:00:00		1994-03-11 00:00:00		1994-03-11 00:00:00		1994-03-11 00:00:00		1994-03-11 00:00:00		1994-03-11 00:00:00		1994-03-11 00:00:00		1994-03-11 00:00:00
naml		AMGEN INC.		AMGEN INC.		AMGEN INC.		AMGEN INC.		AMGEN INC.		AMGEN INC.		AMGEN INC.		AMGEN, INC.		AMGEN, INC.		AMGEN, INC.		AMGEN, INC.		AMGEN, INC.		AMGEN, INC.		AMGEN, INC.
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		WASHINGTON		WASHINGTON		WASHINGTON		WASHINGTON		WASHINGTON		WASHINGTON		WASHINGTON		WASHINGTON		WASHINGTON		WASHINGTON		WASHINGTON		WASHINGTON		WASHINGTON		WASHINGTON
st		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC		DC
zip4		200050000		200050000		200040000		200050000		200050000		200050000		200050000		200050000		200050000		200040000		200050000		200050000		200050000		200050000
phon		9165561776		2023546116		2025859614		2025859614		2025859720		2025859614		2025859614		9165561776		2023546116		2025859614		2025859614		2025859720		2025859614		2025859614
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1012862

Table: received_filings

filer_id		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862		1012862
filing_file_name		719749_0.cal		806066_0.cal		91610.cal		92147.cal		885072_0.cal		885074_0.cal		911549_0.cal		346617.cal		963796_0.cal		980177_0.cal		1004321_0.cal		375568.cal		375723.cal		313437.cal		313534.cal		1054716_0.cal		1055604_0.cal		411398.cal		1119306_0.cal		445484.cal		1135153_0.cal		1133876_0.cal		250265.cal		1133876_1.cal		1149250_0.cal		1177290_0.cal		470164.cal		1190020_0.cal		1507651_0.cal		1438588_0.cal		1338480_0.cal		1352026_0.cal		1495184_0.cal		1494004_0.cal		1464791_0.cal		1453120_0.cal		134901.cal		1218109_0.cal		422203.cal		262564.cal		1239225_0.cal		1262208_0.cal		1421934_0.cal		1285152_0.cal		1312382_0.cal		1297772_0.cal		93348.cal		1376578_0.cal		1664576_0.cal		1847531_0.cal		1845063_0.cal		73758.cal		1680636_0.cal		1841502_0.cal		1796932_0.cal		1591994_0.cal		237440.cal		239020.cal		239306.cal		1572671_0.cal		241405.cal		410129.cal		140184.cal		139913.cal		1608782_0.cal		1760605_0.cal		1778256_0.cal		1637515_0.cal		1710193_0.cal		1667243_0.cal		1863654_0.cal		1975478_0.cal		2154526_0.cal		2124083_0.cal		2044901_0.cal		1993312_0.cal		2006701_0.cal		2104783_0.cal		2079566_0.cal		1886248_0.cal		1877402_0.cal		2022298_0.cal		2026592_0.cal		2094913_0.cal		2090533_0.cal		2099112_0.cal		2092187_0.cal		1927940_0.cal		1916422_0.cal		2032363_0.cal		2057607_0.cal		2039702_0.cal		2031130_0.cal		2032351_0.cal		2167313_0.cal		2221537_0.cal		2371756_0.cal		2303229_0.cal		2286452_0.cal		2282758_0.cal		2259215_0.cal		2294766_0.cal		2280364_0.cal		2202027_0.cal		2336771_0.cal		2300446_0.cal		2385064_0.cal		2411995_0.cal		2390697_0.cal		2243435_0.cal		2301520_0.cal		2457236_0.cal		2479084_0.cal		2196280_0.cal		2296503_0.cal		2429198_0.cal		2217412_0.cal		2616586_0.cal		2664668_0.cal		2637937_0.cal		2502207_0.cal		2509514_0.cal		2702881_0.cal		2680117_0.cal		2686749_0.cal		2721172_0.cal		2716766_0.cal		2675926_0.cal		2544543_0.cal
received_date		2001-01-31 00:00:00		2002-01-11 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-10-31 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2003-10-10 00:00:00		2003-10-10 00:00:00		2004-01-12 00:00:00		2004-03-02 00:00:00		2004-08-02 00:00:00		2004-08-02 00:00:00		2004-10-26 00:00:00		2004-10-26 00:00:00		2004-10-26 00:00:00		2004-10-27 00:00:00		2005-01-31 00:00:00		2005-08-01 00:00:00		2005-11-02 00:00:00		2005-11-02 00:00:00		2005-10-31 00:00:00		2006-01-31 00:00:00		2006-01-31 00:00:00		2006-01-31 00:00:00		2006-05-31 00:00:00		2006-05-26 00:00:00		2006-07-30 00:00:00		2010-08-02 00:00:00		2009-07-31 00:00:00		2008-05-29 00:00:00		2008-07-31 00:00:00		2010-06-04 00:00:00		2010-06-02 00:00:00		2010-02-01 00:00:00		2009-11-02 00:00:00		2006-10-27 00:00:00		2006-11-01 00:00:00		2006-11-01 00:00:00		2007-02-01 00:00:00		2007-02-01 00:00:00		2007-04-30 00:00:00		2009-04-30 00:00:00		2007-07-31 00:00:00		2008-01-31 00:00:00		2007-10-31 00:00:00		2008-10-30 00:00:00		2008-10-30 00:00:00		2012-05-25 00:00:00		2014-05-06 00:00:00		2014-04-30 00:00:00		2012-07-31 00:00:00		2012-07-31 00:00:00		2014-04-25 00:00:00		2013-10-24 00:00:00		2011-05-02 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2011-02-01 00:00:00		2011-05-02 00:00:00		2011-05-02 00:00:00		2011-08-01 00:00:00		2013-04-23 00:00:00		2013-07-25 00:00:00		2012-01-31 00:00:00		2012-10-31 00:00:00		2012-06-01 00:00:00		2014-07-17 00:00:00		2015-07-21 00:00:00		2017-04-27 00:00:00		2017-01-26 00:00:00		2016-05-23 00:00:00		2015-10-22 00:00:00		2016-01-26 00:00:00		2016-11-04 00:00:00		2016-09-21 00:00:00		2014-09-18 00:00:00		2014-08-14 00:00:00		2016-03-22 00:00:00		2016-04-07 00:00:00		2016-10-25 00:00:00		2016-10-18 00:00:00		2016-10-28 00:00:00		2016-10-20 00:00:00		2015-01-22 00:00:00		2014-11-26 00:00:00		2016-04-26 00:00:00		2016-07-25 00:00:00		2016-05-05 00:00:00		2016-04-22 00:00:00		2016-04-26 00:00:00		2017-07-14 00:00:00		2018-03-13 00:00:00		2019-04-10 00:00:00		2018-10-08 00:00:00		2018-08-27 00:00:00		2018-08-14 00:00:00		2018-06-04 00:00:00		2018-09-24 00:00:00		2018-08-07 00:00:00		2018-01-16 00:00:00		2019-01-22 00:00:00		2018-10-03 00:00:00		2019-05-30 00:00:00		2019-10-08 00:00:00		2019-07-17 00:00:00		2018-05-01 00:00:00		2018-10-04 00:00:00		2020-02-25 00:00:00		2020-07-17 00:00:00		2017-11-16 00:00:00		2018-09-27 00:00:00		2020-01-09 00:00:00		2018-02-21 00:00:00		2021-10-19 00:00:00		2022-04-11 00:00:00		2022-01-26 00:00:00		2020-09-17 00:00:00		2020-10-05 00:00:00		2022-07-28 00:00:00		2022-05-09 00:00:00		2022-05-26 00:00:00		2022-09-19 00:00:00		2022-09-02 00:00:00		2022-05-02 00:00:00		2021-01-15 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/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/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/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/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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		719749		806066		None		None		885072		885074		911549		None		963796		980177		1004321		None		None		None		None		1054716		1055604		None		1119306		None		1135153		1133876		None		1133876		1149250		1177290		None		1190020		1507651		1438588		1338480		1352026		1495184		1494004		1464791		1453120		None		1218109		None		None		1239225		1262208		1421934		1285152		1312382		1297772		None		1376578		1664576		1847531		1845063		None		1680636		1841502		1796932		1591994		None		None		None		1572671		None		None		None		None		1608782		1760605		1778256		1637515		1710193		1667243		1863654		1975478		2154526		2124083		2044901		1993312		2006701		2104783		2079566		1886248		1877402		2022298		2026592		2094913		2090533		2099112		2092187		1927940		1916422		2032363		2057607		2039702		2031130		2032351		2167313		2221537		2371756		2303229		2286452		2282758		2259215		2294766		2280364		2202027		2336771		2300446		2385064		2411995		2390697		2243435		2301520		2457236		2479084		2196280		2296503		2429198		2217412		2616586		2664668		2637937		2502207		2509514		2702881		2680117		2686749		2721172		2716766		2675926		2544543
form_id		F461		F461		None		None		F497		F497		F461		None		F461		F461		F497		None		None		None		None		F497		F497		None		F461		None		F497		F461		None		F461		F461		F497		None		F461		F461		F461		F497		F461		F497		F497		F461		F461		None		F497		None		None		F461		F461		F461		F461		F461		F461		None		F497		F497		F497		F497		None		F461		F497		F461		F461		None		None		None		F461		None		None		None		None		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F497		F461		F461		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F461		F497		F461		F461		F497		F497		F497		F461		F497		F461		F497		F497		F497		F497		F497		F497		F461		F461		F497		F497		F461		F461		F497		F497		F497		F461		F461		F497		F461		F497		F461		F497		F461		F497		F497		F461		F497		F497		F497		F497		F497		F461
receive_comment		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing did not pass validation		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 did not pass validation		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted