Home

Filer ID: 1075652

Table: filer_address

filer_id		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652
adrid		1090018		2030930		2088689		2088690		2088914		2451344		2451343		2287316		2528215		2528216
effect_dt		1999-01-13 00:00:00		2002-03-14 00:00:00		1999-01-04 00:00:00		1999-01-04 00:00:00		2005-05-25 00:00:00		2018-03-15 00:00:00		2018-03-15 00:00:00		2013-02-01 00:00:00		2022-01-07 00:00:00		2022-01-07 00:00:00
add_type		7051		7082		7051		7082		7051		7051		7082		7082		7051		7082
session_id		1999		2001		1999		1999		2005		2017		2017		2013		2021		2021

Table: filer_filings

filer_id		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652
filing_id		674493		415759		415760		446317		588889		582725		588343		593737		676909		645873		645891		674345		721880		721939		761572		761605		782933		785105		792912		826703		836495		829622		829623		868627		853981		871895		882062		871895		872239		877997		872239		871895		877997		872239		882062		910639		913194		962907		945922		964813		950718		981352		979010		1008738		996472		1028847		1030580		1047037		1044810		1047037		1044810		1052174		1050893		1075885		1076577		1108827		1108250		1108250		1119936		1118690		1127685		1127687		1130620		1136333		1145071		1144671		1158415		1157219		1189074		1176146		1173430		1204447		1205544		1190454		1212610		1211751		1205544		1213858		1189074		1218158		1214611		1212610		1108827		1237117		1281783		1214611		1271538		1235538		1270582		1281405		1308826		1782394		1979464		1893012		1977107		1850966		1870569		1853733		1786737		1961288		1945245		1943237		1891739		1319894		1320647		1336979		1335645		1309510		1351040		1363403		1350716		1364587		1363403		1364587		1376851		1397730		1375341		1421384		1435656		1398973		1464415		1440470		1474256		1461245		1490524		1504589		1474355		1493309		1509013		1532003		1532003		1575328		1571281		1584087		1584087		1108250		1607059		1595781		1605490		1638611		1647826		1636029		1638611		1636029		1647201		1647826		1663592		1647201		1675715		1677759		1665812		1782394		1786737		1832240		1813167		1819894		1696969		1694632		1931089		1891739		1694632		1696969		1705483		1704355		1876756		1893012		1875287		1886067		1739727		1108250		1826417		1828089		1852669		1833645		1108250		1757151		1745900		1758086		2238862		2458490		2553251		2237798		2271802		2308050		2425237		2223952		2284351		2395556		2008858		2014413		2045920		2034670		2028887		2028783		2039848		2047489		2048381		2039393		2062266		2067613		2079697		2077869		2082819		2089322		2097585		2096077		2129591		2110139		2153635		2146555		2169283		2170488		2160791		2514907		2495263		2309214		2451323		1108250		2484415		2491477		2494263		2443264		2524612		2319463		2238862		2298302		2346141		2230915		2298302		2394026		2505906		2523362		2437457		2583132		2271726		2237798		2572956		2356508		2455287		2312934		2224184		2237798		2297123		2238862		2297123		2215136		2205718		2598711		2629112		2668839		2633575		2676402		2505906		2524612		2643489		1108250		2707075		2607202		2648627		2616769		2676402		2672092		2686052		2724289		2683069		2514907		2688064		2676402		2685652		2672092		2688064		2656811		2713337		2672092		2686052		2740920		2741051		2739065		2731762
period_id		None		157		157		159		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		169		None		171		None		171		None		172		None		171		172		None		None		172		None		175		173		None		None		None		176		None		177		177		None		None		179		None		179		None		180		180		None		None		169		182		None		181		None		None		184		None		None		183		None		185		186		None		185		187		None		None		188		188		None		188		187		188		None		188		None		None		None		None		None		188		None		189		191		213		None		None		221		218		218		None		None		222		221		None		219		193		None		None		193		None		None		195		194		None		195		None		None		196		196		None		197		None		None		None		201		199		201		202		None		None		None		203		203		None		204		None		None		206		None		None		205		None		None		207		None		207		209		None		209		209		210		None		None		213		None		217		215		None		None		211		220		219		211		None		None		212		None		None		219		219		212		213		217		217		217		None		213		None		None		None		None		None		243		233		234		236		240		233		235		None		223		None		226		225		226		226		None		226		None		226		226		227		227		None		227		228		227		None		228		None		229		None		230		None		None		None		243		236		None		233		241		243		None		241		244		None		None		None		236		234		None		237		243		244		239		246		None		233		None		None		241		235		None		233		235		None		235		None		231		245		248		250		None		None		243		244		247		249		250		247		None		None		None		249		250		251		250		None		None		None		250		249		None		249		251		249		250		251		None		252		None
form_id		F465		F410		F450		F450		F465		F450		F450		F450		F460		F450		F465		F450		F450		F465		F465		F450		F465		F450		F450		F465		F410		F450		F450		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F410		F410		F460		F460		F465		F465		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F497		F460		F497		F460		F460		F410		F460		F460		F460		F497		F460		F497		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F497		F666		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F410		F497		F497		F460		F460		F410		F410		F460		F410		F460		F460		F460		F460		F460		F497		F497		F497		F497		F460		F460		F460		F460		F460		F497		F497		F460		F497		F460		F497		F460		F497		F497		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F410		F460		F497		F460		F497		F497		F460		F460		F460		F460		F497		F460		F460		F460		F497		F460		F497		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F497		F497		F410		F460		F460		F497		F460		F410		F460		F497		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F497		F460		F460		F497		F497		F460		F460		F460		F460		F497		F460
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		1		2		1		2		1		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		0		0		1		1		0		0		1		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		1		2		0		0		0		1		0		0		0		1		0		1		0		1		0		0		0		1		1		0		0		0		0		0		0		1		1		1		0		0		0		0		0		0		0		3		0		0		0		0		4		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		5		0		0		0		0		0		0		2		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		1		1		0		0		0		0		0		0		0		0		1		1		0		6		0		0		0		0		1		2		1		0		0		1		1		2		0		0		0		0		0		1		0		0		0		0		0
filing_date		2000-10-05 00:00:00		1999-01-11 00:00:00		1999-08-02 00:00:00		1999-10-05 00:00:00		2000-01-27 00:00:00		2000-01-07 00:00:00		2000-01-27 00:00:00		2000-02-24 00:00:00		2000-10-23 00:00:00		2000-07-31 00:00:00		2000-07-31 00:00:00		2000-10-05 00:00:00		2001-01-29 00:00:00		2001-01-29 00:00:00		2001-04-30 00:00:00		2001-04-30 00:00:00		2001-07-30 00:00:00		2001-07-30 00:00:00		2001-10-19 00:00:00		2002-02-21 00:00:00		2002-03-14 00:00:00		2002-01-25 00:00:00		2002-02-21 00:00:00		2002-09-20 00:00:00		2002-07-29 00:00:00		2002-10-07 00:00:00		2002-10-24 00:00:00		2002-11-12 00:00:00		2002-10-07 00:00:00		2002-10-24 00:00:00		2002-11-12 00:00:00		2003-02-27 00:00:00		2003-02-27 00:00:00		2003-02-27 00:00:00		2003-02-27 00:00:00		2003-01-30 00:00:00		2003-01-30 00:00:00		2003-10-09 00:00:00		2003-07-29 00:00:00		2003-10-10 00:00:00		2003-07-29 00:00:00		2004-01-08 00:00:00		2004-01-08 00:00:00		2004-02-19 00:00:00		2004-02-19 00:00:00		2004-07-29 00:00:00		2004-07-29 00:00:00		2004-10-21 00:00:00		2004-10-05 00:00:00		2004-10-05 00:00:00		2004-10-21 00:00:00		2004-10-21 00:00:00		2004-10-21 00:00:00		2005-01-26 00:00:00		2005-01-26 00:00:00		2005-05-25 00:00:00		2005-05-25 00:00:00		2005-05-25 00:00:00		2005-08-01 00:00:00		2005-08-01 00:00:00		2001-10-22 00:00:00		2001-10-22 00:00:00		2005-10-25 00:00:00		2005-10-25 00:00:00		2006-01-26 00:00:00		2006-01-26 00:00:00		2006-03-22 00:00:00		2006-03-22 00:00:00		2006-07-28 00:00:00		2006-05-24 00:00:00		2006-05-24 00:00:00		2006-10-05 00:00:00		2006-10-05 00:00:00		2006-07-28 00:00:00		2006-10-26 00:00:00		2006-10-25 00:00:00		2006-10-26 00:00:00		2006-10-27 00:00:00		2006-10-26 00:00:00		2006-11-01 00:00:00		2006-10-26 00:00:00		2007-01-30 00:00:00		2007-05-11 00:00:00		2007-01-30 00:00:00		2007-07-26 00:00:00		2007-01-30 00:00:00		2006-10-25 00:00:00		2007-01-30 00:00:00		2006-11-01 00:00:00		2007-07-26 00:00:00		2008-01-30 00:00:00		2013-07-31 00:00:00		2015-07-24 00:00:00		2015-01-27 00:00:00		2015-07-24 00:00:00		2014-05-16 00:00:00		2014-07-30 00:00:00		2014-05-21 00:00:00		2013-07-31 00:00:00		2015-04-23 00:00:00		2015-02-20 00:00:00		2015-01-27 00:00:00		2014-10-03 00:00:00		2008-03-24 00:00:00		2008-03-24 00:00:00		2008-05-22 00:00:00		2008-05-22 00:00:00		2008-01-29 00:00:00		2008-07-31 00:00:00		2008-10-06 00:00:00		2008-07-31 00:00:00		2008-10-06 00:00:00		2008-10-07 00:00:00		2008-10-07 00:00:00		2008-10-29 00:00:00		2009-02-02 00:00:00		2008-10-29 00:00:00		2009-04-30 00:00:00		2009-07-29 00:00:00		2009-02-02 00:00:00		2010-01-27 00:00:00		2009-07-29 00:00:00		2010-03-22 00:00:00		2010-01-27 00:00:00		2010-05-26 00:00:00		2010-07-28 00:00:00		2010-03-22 00:00:00		2010-05-26 00:00:00		2010-07-28 00:00:00		2010-10-21 00:00:00		2011-02-09 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2010-10-22 00:00:00		2011-02-09 00:00:00		2011-05-24 00:00:00		2011-07-28 00:00:00		2011-05-24 00:00:00		2011-07-28 00:00:00		2012-03-16 00:00:00		2012-03-22 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00		2012-03-16 00:00:00		2012-03-22 00:00:00		2012-05-24 00:00:00		2012-05-24 00:00:00		2012-05-24 00:00:00		2012-07-27 00:00:00		2012-07-27 00:00:00		2012-05-24 00:00:00		2014-03-03 00:00:00		2014-03-03 00:00:00		2014-03-24 00:00:00		2014-01-24 00:00:00		2014-01-24 00:00:00		2012-10-05 00:00:00		2012-10-05 00:00:00		2015-01-27 00:00:00		2015-01-27 00:00:00		2012-11-05 00:00:00		2012-11-05 00:00:00		2012-10-25 00:00:00		2012-10-25 00:00:00		2014-07-30 00:00:00		2014-10-03 00:00:00		2014-08-07 00:00:00		2014-09-17 00:00:00		2013-01-31 00:00:00		2013-02-01 00:00:00		2014-03-06 00:00:00		2014-03-13 00:00:00		2014-05-21 00:00:00		2014-03-24 00:00:00		2013-03-05 00:00:00		2013-02-01 00:00:00		2013-01-31 00:00:00		2013-03-05 00:00:00		2018-04-26 00:00:00		2020-02-20 00:00:00		2021-02-01 00:00:00		2018-07-30 00:00:00		2018-07-30 00:00:00		2018-10-17 00:00:00		2019-12-16 00:00:00		2018-03-21 00:00:00		2018-08-17 00:00:00		2019-07-26 00:00:00		2016-01-28 00:00:00		2016-01-28 00:00:00		2016-05-25 00:00:00		2016-04-28 00:00:00		2016-04-15 00:00:00		2016-04-15 00:00:00		2016-04-28 00:00:00		2016-05-27 00:00:00		2016-05-25 00:00:00		2016-05-04 00:00:00		2016-07-29 00:00:00		2016-08-11 00:00:00		2016-09-21 00:00:00		2016-07-29 00:00:00		2016-09-29 00:00:00		2016-10-14 00:00:00		2016-10-27 00:00:00		2016-09-29 00:00:00		2017-01-31 00:00:00		2016-10-27 00:00:00		2017-04-26 00:00:00		2017-01-31 00:00:00		2017-07-20 00:00:00		2017-07-20 00:00:00		2017-04-26 00:00:00		2020-09-25 00:00:00		2020-08-26 00:00:00		2018-10-19 00:00:00		2020-01-28 00:00:00		2018-03-15 00:00:00		2020-07-30 00:00:00		2020-08-14 00:00:00		2020-07-31 00:00:00		2020-01-31 00:00:00		2020-10-28 00:00:00		2018-10-25 00:00:00		2019-08-16 00:00:00		2019-08-16 00:00:00		2019-01-30 00:00:00		2018-04-13 00:00:00		2018-09-27 00:00:00		2019-07-26 00:00:00		2020-09-24 00:00:00		2020-10-26 00:00:00		2020-01-28 00:00:00		2021-05-06 00:00:00		2018-07-27 00:00:00		2018-04-26 00:00:00		2021-02-01 00:00:00		2019-01-30 00:00:00		2020-02-20 00:00:00		2018-10-25 00:00:00		2018-03-15 00:00:00		2019-08-16 00:00:00		2019-08-16 00:00:00		2018-07-30 00:00:00		2018-09-27 00:00:00		2018-01-25 00:00:00		2018-01-25 00:00:00		2021-07-28 00:00:00		2021-11-19 00:00:00		2022-04-21 00:00:00		2022-01-07 00:00:00		2022-04-27 00:00:00		2021-02-01 00:00:00		2020-10-28 00:00:00		2022-01-31 00:00:00		2022-01-07 00:00:00		2022-08-01 00:00:00		2021-08-18 00:00:00		2022-01-31 00:00:00		2021-07-29 00:00:00		2022-05-26 00:00:00		2022-08-01 00:00:00		2022-08-01 00:00:00		2022-09-27 00:00:00		2022-05-16 00:00:00		2021-02-01 00:00:00		2022-08-02 00:00:00		2022-08-02 00:00:00		2022-05-24 00:00:00		2022-04-27 00:00:00		2022-05-26 00:00:00		2022-03-11 00:00:00		2022-08-23 00:00:00		2022-05-25 00:00:00		2022-05-25 00:00:00		2022-10-25 00:00:00		2022-09-28 00:00:00		2022-10-21 00:00:00		2022-08-01 00:00:00
stmnt_type		10005		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10002		10005		10005		10001		10005		10001		10005		10002		10005		10001		10006		10002		10002		10006		10006		10001		10005		10001		10001		10005		10005		10005		10001		10005		10001		10001		10005		10006		10001		10005		10002		10005		10001		10001		10005		10006		10001		10002		10005		10001		10005		10005		10001		10005		10005		10001		10005		10001		10001		10005		10001		10001		10005		10005		10001		10001		10006		10001		10002		10001		10005		10002		10006		10005		10005		10006		10005		10001		10005		10001		10001		10001		10005		10006		10001		10001		10001		10005		10005		10001		10001		10005		10001		10001		10005		10005		10001		10005		10005		10001		10001		10005		10002		10006		10005		10001		10001		10005		10001		10005		10005		10005		10001		10001		10001		10001		10005		10005		10005		10001		10002		10005		10001		10005		10006		10002		10005		10006		10001		10006		10005		10001		10005		10002		10001		10006		10001		10002		10001		10005		10005		10002		10006		10001		10001		10005		10005		10001		10001		10002		10002		10006		10005		10001		10005		10005		10001		10001		10001		10002		10001		10001		10001		10005		10002		10002		10005		10002		10005		10005		10001		10002		10001		10001		10001		10001		10001		10005		10001		10005		10001		10001		10001		10001		10005		10001		10005		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10005		10001		10005		10001		10005		10005		10005		10001		10001		10005		10002		10001		10001		10005		10001		10001		10005		10006		10006		10001		10001		10005		10001		10001		10001		10001		10001		10005		10001		10005		10005		10001		10001		10006		10002		10002		10006		10001		10005		10001		10001		10001		10001		10006		10005		10002		10002		10001		10002		10001		10001		10005		10005		10006		10002		10002		10001		10001		10006		10006		10006		10001		10001		10005		10001		10001		10002		10001		10001		10005		10001		10005
stmnt_status		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		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		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11003		11003		11003		11001		11003		11001		11003		11001		11003		11003		11001		11003		11003		11001		11001		11003		11001		11003		11003		11003		11001		11001		11003		11001		11001		11001		11003		11001		11003		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11003		11003		11001		11003		11003		11001		11003		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003
session_id		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2001		2005		2005		2005		2005		2005		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2005		2005		2005		2007		2007		2013		2015		2013		2015		2013		2013		2013		2013		2015		2015		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2005		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2013		2011		2011		2013		2013		2011		2011		2011		2011		2013		2013		2013		2013		2011		2013		2013		2013		2013		2013		2013		2013		2011		2013		2017		2019		2019		2017		2017		2017		2019		2017		2017		2019		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2015		2017		2017		2017		2019		2019		2017		2019		2017		2019		2019		2019		2019		2019		2017		2017		2017		2017		2017		2017		2019		2019		2019		2019		2021		2017		2017		2021		2017		2019		2017		2017		2017		2017		2017		2017		2017		2017		2021		2021		2021		2021		2021		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		KCHAN		*		*		*		*		*		*		*		KCHAN		KCHAN		JLEHMAN		KCHAN		TWALLS		TWALLS		SARRIAGA		SARRIAGA		GPEREZ		SARRIAGA		CFLAGG		DBARRICK		TTHAM		DBARRICK		DBARRICK		DHORRELL		DBARRICK		*		DBARRICK		*		DBARRICK		*		DBARRICK		COMPLETED		COMPLETED		DBARRICK		DBARRICK		COMPLETED		DBARRICK		COMPLETED		COMPLETED		KVOONG1		GGILMORE		GGILMORE		COMPLETED		MHOANG		COMPLETED		COMPLETED		TTHAM		EMCENTEE		COMPLETED		SARRIAGA		COMPLETED		CFLAGG		COMPLETED		COMPLETED		SARRIAGA		TTHAM		*		*		GPEREZ		*		NWALKER		NWALKER		PBANFORD		GGILMORE		CFLAGG		*		SARRIAGA		*		*		SARRIAGA		*		*		GPEREZ		CFLAGG		*		DHORRELL		LHOANG		*		*		DHORRELL		GPEREZ		*		EMCENTEE		GPEREZ		GPEREZ		LHOANG		LHOANG		*		LHOANG		*		*		MDIGRAZIA		SARRIAGA		MPACHECO		SARRIAGA		WBROWN		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		WBROWN		WBROWN		SARRIAGA		CAFILER		*		SARRIAGA		SARRIAGA		*		SARRIAGA		RGEREMIA		*		*		RGEREMIA		*		RGEREMIA		EMCENTEE		*		GKURIMOT		NLANDERS		CPON		JVAZQUEZ		CPON		CPON		MMORENO		CPON		*		MMORENO		MMORENO		JVAZQUEZ		MMORENO		MMORENO		*		SMCCONNAN		SMCCONNAN		MMORENO		RGEREMIA		TRAMON		SARRIAGA		TRAMON		SARRIAGA		MPACHECO		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MPACHECO		MDIGRAZIA		MDIGRAZIA		CPON		CPON		MDIGRAZIA		MDIGRAZIA		MPACHECO		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MPACHECO		CAFILER		SARRIAGA		CAFILER		CAFILER		MPACHECO		MPACHECO		CAFILER		MDIGRAZIA		JINGRAM		WBROWN		WBROWN		CAFILER		TRAMON		WBROWN		WBROWN		MDIGRAZIA		MPACHECO		TRAMON		TRAMON		MPACHECO		TRAMON		CSAGABAEN		SUSHAKOV		CREYNOLDS		CAFILER		HSTOVALL		CAFILER		CAFILER		GKURIMOT		CAFILER		HCOURSEY		SMCCONNAN		SMCCONNAN		SMCCONNAN		SARRIAGA		KBANH		KBANH		SARRIAGA		KBANH		SMCCONNAN		KBANH		CPON		PDEO		PDEO		CPON		SARRIAGA		GKURIMOT		CSAGABAEN		SARRIAGA		LLEONG		CSAGABAEN		HSTOVALL		LLEONG		LBARTHOL		LBARTHOL		HSTOVALL		KRUSSELL		CAFILER		CAFILER		SUSHAKOV		TRAMON		KRUSSELL		CAFILER		KRUSSELL		CAFILER		CAFILER		CSAGABAEN		CSAGABAEN		CSAGABAEN		VUKSTINA		CAFILER		CSAGABAEN		HCOURSEY		KRUSSELL		CAFILER		SUSHAKOV		CAFILER		HSTOVALL		CSAGABAEN		CREYNOLDS		VUKSTINA		SUSHAKOV		CSAGABAEN		TRAMON		CAFILER		CAFILER		LBARTHOL		CSAGABAEN		CSAGABAEN		CSAGABAEN		KRUSSELL		CAFILER		CAFILER		IMEDINA		KRUSSELL		CAFILER		CAFILER		KRUSSELL		IMEDINA		CAFILER		CAFILER		KRUSSELL		KRUSSELL		JMAVES		CAFILER		CAFILER		CAFILER		CAFILER		JRAMOS		JMAVES		JMAVES		CAFILER		KRUSSELL		JMAVES		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		LPHEAV		CAFILER		RGEREMIA
special_audit		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		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		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11001		11003		11001		11001		11003		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
rpt_start		2000-07-01 00:00:00		None		1999-01-01 00:00:00		1999-07-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-01-23 00:00:00		2000-10-01 00:00:00		2000-02-20 00:00:00		2000-02-20 00:00:00		2000-07-01 00:00:00		2000-10-22 00:00:00		2000-10-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2002-01-20 00:00:00		2001-11-01 00:00:00		2002-01-01 00:00:00		2002-01-20 00:00:00		2002-02-17 00:00:00		2002-02-17 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-10-20 00:00:00		2002-10-20 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-02-15 00:00:00		2004-02-15 00:00:00		2004-07-01 00:00:00		2004-07-01 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		None		2002-03-13 00:00:00		2005-05-25 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2005-10-25 00:00:00		None		2005-07-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2006-05-21 00:00:00		2006-03-18 00:00:00		2006-03-18 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2006-05-21 00:00:00		2006-10-01 00:00:00		2006-10-25 00:00:00		2006-07-01 00:00:00		2006-10-27 00:00:00		2006-07-01 00:00:00		2006-11-01 00:00:00		2006-10-01 00:00:00		2006-10-01 00:00:00		None		2006-10-22 00:00:00		2007-01-01 00:00:00		2006-10-01 00:00:00		None		2006-10-22 00:00:00		None		2007-01-01 00:00:00		2007-07-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2014-07-01 00:00:00		2015-01-01 00:00:00		2014-05-16 00:00:00		2014-05-18 00:00:00		2014-03-18 00:00:00		2013-01-01 00:00:00		2015-04-23 00:00:00		2015-02-20 00:00:00		2014-10-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-03-18 00:00:00		2008-03-18 00:00:00		2007-07-01 00:00:00		2008-05-18 00:00:00		2008-07-01 00:00:00		2008-05-18 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		None		2008-10-01 00:00:00		2008-10-29 00:00:00		2005-01-01 00:00:00		2009-01-01 00:00:00		2008-10-01 00:00:00		2009-07-01 00:00:00		2009-01-01 00:00:00		2010-01-01 00:00:00		2009-07-01 00:00:00		2010-03-18 00:00:00		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-03-18 00:00:00		2010-05-23 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2010-10-17 00:00:00		2010-10-17 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2011-05-24 00:00:00		2011-01-01 00:00:00		None		2011-01-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-03-18 00:00:00		2012-01-01 00:00:00		2012-05-20 00:00:00		2012-05-20 00:00:00		2012-03-18 00:00:00		2013-01-01 00:00:00		2013-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		2014-10-01 00:00:00		2014-07-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2012-10-01 00:00:00		2012-10-01 00:00:00		2014-05-18 00:00:00		2014-07-01 00:00:00		2014-08-07 00:00:00		2014-09-17 00:00:00		2012-10-21 00:00:00		2013-01-31 00:00:00		2014-03-06 00:00:00		2014-03-13 00:00:00		2014-03-18 00:00:00		2014-01-01 00:00:00		2013-03-05 00:00:00		None		2012-10-21 00:00:00		None		2018-01-01 00:00:00		2020-01-01 00:00:00		2020-09-20 00:00:00		2018-01-01 00:00:00		2018-04-22 00:00:00		2018-10-17 00:00:00		2019-12-16 00:00:00		2018-03-21 00:00:00		2018-08-17 00:00:00		2019-01-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-04-24 00:00:00		2016-01-01 00:00:00		2016-04-15 00:00:00		2016-04-14 00:00:00		2016-01-01 00:00:00		2016-05-27 00:00:00		2016-04-24 00:00:00		2016-05-03 00:00:00		2016-05-22 00:00:00		2016-08-11 00:00:00		2016-09-21 00:00:00		2016-05-22 00:00:00		2016-07-01 00:00:00		2016-10-14 00:00:00		2016-09-25 00:00:00		2016-07-01 00:00:00		2016-10-23 00:00:00		2016-09-25 00:00:00		2017-01-01 00:00:00		2016-10-23 00:00:00		2017-04-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2020-07-01 00:00:00		2020-08-26 00:00:00		2018-10-19 00:00:00		2019-07-01 00:00:00		2018-03-15 00:00:00		2020-02-16 00:00:00		2020-08-14 00:00:00		2020-02-16 00:00:00		2020-01-31 00:00:00		2020-10-27 00:00:00		2018-09-23 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2018-10-21 00:00:00		2018-04-13 00:00:00		2018-07-01 00:00:00		2019-01-01 00:00:00		2020-07-01 00:00:00		2020-10-26 00:00:00		2019-07-01 00:00:00		2021-05-06 00:00:00		2018-04-22 00:00:00		2018-01-01 00:00:00		2020-09-20 00:00:00		2018-10-21 00:00:00		2020-01-01 00:00:00		2018-09-23 00:00:00		None		2018-01-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2017-07-01 00:00:00		2017-07-01 00:00:00		2021-01-01 00:00:00		2021-11-19 00:00:00		2022-04-21 00:00:00		None		2022-01-01 00:00:00		2020-07-01 00:00:00		2020-10-28 00:00:00		2021-07-01 00:00:00		2022-01-05 00:00:00		2022-05-22 00:00:00		2021-08-18 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-04-24 00:00:00		2022-07-01 00:00:00		2022-05-16 00:00:00		2020-07-01 00:00:00		2022-04-24 00:00:00		2022-01-01 00:00:00		2022-05-24 00:00:00		2022-01-01 00:00:00		2022-04-24 00:00:00		2022-03-11 00:00:00		2022-08-23 00:00:00		2022-01-01 00:00:00		2022-04-24 00:00:00		2022-09-25 00:00:00		2022-07-01 00:00:00		2022-10-21 00:00:00		2022-05-22 00:00:00
rpt_end		2000-09-30 00:00:00		None		1999-06-30 00:00:00		1999-09-30 00:00:00		2000-01-22 00:00:00		1999-12-31 00:00:00		2000-01-22 00:00:00		2000-02-19 00:00:00		2000-10-21 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2002-02-16 00:00:00		2001-11-01 00:00:00		2002-01-19 00:00:00		2002-02-16 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-10-19 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-10-19 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-10-19 00:00:00		2002-09-30 00:00:00		2002-10-19 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-02-14 00:00:00		2004-02-14 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-09-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		None		2002-03-13 00:00:00		2005-05-25 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2001-09-30 00:00:00		2001-10-20 00:00:00		2005-10-25 00:00:00		None		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-03-17 00:00:00		2006-03-17 00:00:00		2006-06-30 00:00:00		2006-05-20 00:00:00		2006-05-20 00:00:00		2006-09-30 00:00:00		2006-09-30 00:00:00		2006-06-30 00:00:00		2006-10-21 00:00:00		2006-10-25 00:00:00		2006-09-30 00:00:00		2006-10-27 00:00:00		2006-09-30 00:00:00		2006-11-01 00:00:00		2006-10-21 00:00:00		2006-10-21 00:00:00		None		2006-12-31 00:00:00		2007-06-30 00:00:00		2006-10-21 00:00:00		None		2006-12-31 00:00:00		None		2007-06-30 00:00:00		2007-12-31 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-09-30 00:00:00		2015-06-30 00:00:00		2014-05-16 00:00:00		2014-06-30 00:00:00		2014-05-17 00:00:00		2013-06-30 00:00:00		2015-04-23 00:00:00		2015-02-20 00:00:00		2014-12-31 00:00:00		2014-09-30 00:00:00		2008-03-17 00:00:00		2008-03-17 00:00:00		2008-05-17 00:00:00		2008-05-17 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-09-30 00:00:00		2008-09-30 00:00:00		None		2008-12-31 00:00:00		2008-10-29 00:00:00		2006-12-31 00:00:00		2009-06-30 00:00:00		2008-12-31 00:00:00		2009-12-31 00:00:00		2009-06-30 00:00:00		2010-03-17 00:00:00		2009-12-31 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-03-17 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-10-16 00:00:00		2010-10-16 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2010-10-16 00:00:00		2010-10-16 00:00:00		2011-05-24 00:00:00		2011-06-30 00:00:00		None		2011-06-30 00:00:00		2011-12-31 00:00:00		2012-03-17 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-03-17 00:00:00		2012-03-17 00:00:00		2012-05-19 00:00:00		2012-03-17 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2012-05-19 00:00:00		2013-06-30 00:00:00		2013-06-30 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		2014-12-31 00:00:00		2014-09-30 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2012-10-20 00:00:00		2012-10-20 00:00:00		2014-06-30 00:00:00		2014-09-30 00:00:00		2014-08-07 00:00:00		2014-09-17 00:00:00		2012-12-31 00:00:00		2013-01-31 00:00:00		2014-03-06 00:00:00		2014-03-13 00:00:00		2014-05-17 00:00:00		2014-03-17 00:00:00		2013-03-05 00:00:00		None		2012-12-31 00:00:00		None		2018-04-21 00:00:00		2020-02-15 00:00:00		2020-12-31 00:00:00		2018-04-21 00:00:00		2018-06-30 00:00:00		2018-10-17 00:00:00		2019-12-16 00:00:00		2018-03-21 00:00:00		2018-08-17 00:00:00		2019-06-30 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-05-21 00:00:00		2016-04-23 00:00:00		2016-04-15 00:00:00		2016-04-14 00:00:00		2016-04-23 00:00:00		2016-05-27 00:00:00		2016-05-21 00:00:00		2016-05-03 00:00:00		2016-06-30 00:00:00		2016-08-11 00:00:00		2016-09-21 00:00:00		2016-06-30 00:00:00		2016-09-24 00:00:00		2016-10-14 00:00:00		2016-10-22 00:00:00		2016-09-24 00:00:00		2016-12-31 00:00:00		2016-10-22 00:00:00		2017-03-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2020-09-19 00:00:00		2020-08-26 00:00:00		2018-10-19 00:00:00		2019-12-31 00:00:00		2018-03-15 00:00:00		2020-06-30 00:00:00		2020-08-14 00:00:00		2020-06-30 00:00:00		2020-01-31 00:00:00		2020-10-27 00:00:00		2018-10-20 00:00:00		2018-04-21 00:00:00		2018-09-22 00:00:00		2018-12-31 00:00:00		2018-04-13 00:00:00		2018-09-22 00:00:00		2019-06-30 00:00:00		2020-09-19 00:00:00		2020-10-26 00:00:00		2019-12-31 00:00:00		2021-05-06 00:00:00		2018-06-30 00:00:00		2018-04-21 00:00:00		2020-12-31 00:00:00		2018-12-31 00:00:00		2020-02-15 00:00:00		2018-10-20 00:00:00		None		2018-04-21 00:00:00		2018-09-22 00:00:00		2018-04-21 00:00:00		2018-09-22 00:00:00		2017-12-31 00:00:00		2017-12-31 00:00:00		2021-06-30 00:00:00		2021-11-19 00:00:00		2022-04-21 00:00:00		None		2022-04-23 00:00:00		2020-09-19 00:00:00		2020-10-28 00:00:00		2021-12-31 00:00:00		2022-01-05 00:00:00		2022-06-30 00:00:00		2021-08-18 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		2022-04-23 00:00:00		2022-04-23 00:00:00		2022-05-21 00:00:00		2022-09-24 00:00:00		2022-05-16 00:00:00		2020-09-19 00:00:00		2022-05-21 00:00:00		2022-04-23 00:00:00		2022-05-24 00:00:00		2022-04-23 00:00:00		2022-05-21 00:00:00		2022-03-11 00:00:00		2022-08-23 00:00:00		2022-04-23 00:00:00		2022-05-21 00:00:00		2022-10-22 00:00:00		2022-09-24 00:00:00		2022-10-21 00:00:00		2022-06-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2002-09-20 00:00:00		None		2002-10-07 00:00:00		None		2002-11-12 00:00:00		None		2002-10-24 00:00:00		None		2003-02-27 00:00:00		2003-02-27 00:00:00		None		None		2003-01-30 00:00:00		None		2003-10-09 00:00:00		2003-07-29 00:00:00		None		None		None		2004-01-08 00:00:00		None		2004-02-19 00:00:00		2004-07-29 00:00:00		None		None		2004-10-05 00:00:00		None		2004-10-21 00:00:00		None		2004-10-21 00:00:00		2005-01-26 00:00:00		None		None		None		None		None		2005-08-01 00:00:00		None		None		2005-10-25 00:00:00		None		None		2006-01-26 00:00:00		None		2006-03-22 00:00:00		2006-07-28 00:00:00		None		2006-05-24 00:00:00		2006-10-05 00:00:00		None		None		2006-10-26 00:00:00		2006-10-25 00:00:00		None		2006-10-27 00:00:00		2006-10-26 00:00:00		2006-11-01 00:00:00		None		2007-01-30 00:00:00		None		None		None		None		None		2007-01-30 00:00:00		None		2007-07-26 00:00:00		2008-01-30 00:00:00		2013-07-30 00:00:00		None		None		2015-07-24 00:00:00		2014-05-16 00:00:00		2014-07-30 00:00:00		None		None		2015-04-23 00:00:00		2015-02-20 00:00:00		None		2014-10-03 00:00:00		2008-03-24 00:00:00		None		None		2008-05-22 00:00:00		None		None		2008-10-06 00:00:00		2008-07-31 00:00:00		None		2008-10-07 00:00:00		None		None		2009-02-02 00:00:00		2008-10-29 00:00:00		None		2009-07-29 00:00:00		None		None		None		2010-03-22 00:00:00		2010-01-27 00:00:00		2010-05-26 00:00:00		2010-07-28 00:00:00		None		None		None		2010-10-21 00:00:00		2011-02-09 00:00:00		None		2011-01-31 00:00:00		None		None		None		None		None		2011-07-28 00:00:00		None		None		2012-01-31 00:00:00		None		2012-03-16 00:00:00		2012-03-22 00:00:00		None		2012-05-24 00:00:00		2012-05-24 00:00:00		2012-07-27 00:00:00		None		None		2014-03-03 00:00:00		None		2014-03-24 00:00:00		2014-01-23 00:00:00		None		None		2012-10-05 00:00:00		2015-01-27 00:00:00		2015-01-27 00:00:00		2012-11-05 00:00:00		None		None		2012-10-25 00:00:00		None		None		2014-08-07 00:00:00		2014-09-17 00:00:00		2013-01-31 00:00:00		None		2014-03-06 00:00:00		2014-03-13 00:00:00		2014-05-21 00:00:00		None		None		None		None		None		None		None		2021-02-01 00:00:00		2018-07-30 00:00:00		2018-07-26 00:00:00		2018-10-17 00:00:00		2019-12-16 00:00:00		2018-03-21 00:00:00		2018-08-17 00:00:00		None		2016-01-28 00:00:00		None		2016-05-24 00:00:00		2016-04-28 00:00:00		2016-04-15 00:00:00		2016-04-14 00:00:00		None		2016-05-27 00:00:00		None		2016-05-03 00:00:00		2016-07-29 00:00:00		2016-08-11 00:00:00		2016-09-21 00:00:00		None		2016-09-28 00:00:00		2016-10-14 00:00:00		2016-10-27 00:00:00		None		2017-01-31 00:00:00		None		2017-04-25 00:00:00		None		2017-07-20 00:00:00		None		None		None		2020-08-26 00:00:00		2018-10-19 00:00:00		None		None		2020-07-30 00:00:00		2020-08-14 00:00:00		None		2020-01-31 00:00:00		2020-10-27 00:00:00		None		None		None		2019-01-29 00:00:00		2018-04-13 00:00:00		None		2019-07-26 00:00:00		2020-09-23 00:00:00		2020-10-26 00:00:00		2020-01-28 00:00:00		2021-05-06 00:00:00		None		2018-04-26 00:00:00		None		None		2020-02-20 00:00:00		2018-10-25 00:00:00		None		2019-08-16 00:00:00		2019-08-16 00:00:00		None		2018-09-27 00:00:00		None		2018-01-25 00:00:00		2021-07-27 00:00:00		2021-11-19 00:00:00		2022-04-21 00:00:00		None		None		2021-02-01 00:00:00		2020-10-28 00:00:00		2022-01-28 00:00:00		None		2022-08-01 00:00:00		2021-08-18 00:00:00		None		None		None		2022-08-01 00:00:00		2022-08-01 00:00:00		2022-09-27 00:00:00		2022-05-16 00:00:00		None		None		None		2022-05-24 00:00:00		2022-04-27 00:00:00		None		2022-03-11 00:00:00		2022-08-23 00:00:00		2022-05-23 00:00:00		2022-05-25 00:00:00		2022-10-24 00:00:00		None		2022-10-21 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		22001		22001		None		None		22001		None		22001		22001		None		None		None		22001		None		22001		22001		None		None		22001		None		22001		None		22001		22001		None		None		22001		22001		None		22001		None		None		22001		None		None		22001		None		22001		22001		None		22001		22001		None		None		22001		22001		None		22001		22001		22001		None		22001		None		None		None		None		None		22001		None		22001		22001		22001		None		None		22001		22001		22001		None		None		22001		22001		None		22001		22001		None		None		22001		None		None		22001		22001		None		22001		None		None		22001		22001		None		22001		None		None		None		22001		22001		22001		22001		None		None		None		22001		22001		None		22001		None		None		22001		None		None		22001		None		None		22001		None		22001		22001		None		22001		22001		22001		None		None		22001		None		22001		22001		None		None		22001		22001		22001		22001		None		None		22001		None		None		22001		22001		22001		22001		22001		22001		22001		None		22001		None		None		None		None		None		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		None		22001		22001		22001		None		22001		None		22001		None		22001		None		None		None		22001		22001		None		22001		22001		22001		None		22001		22001		None		None		None		22001		22001		None		22001		22001		22001		22001		22001		None		22001		None		None		22001		22001		None		22001		22001		None		22001		None		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		None		None		None		22001		22001		22001		22001		None		None		None		22001		22001		None		22001		22001		22001		22001		22001		None		22001		None

Table: filer_to_filer_type

filer_id		1075652		1075652
filer_type		16		16
active		Y		Y
race		0		0
session_id		1999		2013
category		0		0
category_type		40502		40502
sub_category		40103		40103
effect_dt		2002-03-14 00:00:00		2013-03-05 00:00:00
sub_category_type		40203		0
election_type		0		0
sub_category_a		S		S
nyq_dt		1999-01-04 00:00:00		1999-01-04 00:00:00
party_cd		None		None
county_cd		18001		18001
district_cd		None		None

Table: filer_xref

filer_id		1075652
xref_id		990058
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058		990058
filer_id		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00		2013-03-05 00:00:00
naml		SPRINKLER FITTERS & APPRENTICES LOCAL 483 LEGISLATIVE PAC		SPRINKLER FITTERS & APPRENTICES LOCAL 483 LEGISLATIVE PAC		SPRINKLER FITTERS & APPRENTICES LOCAL 483 LEGISLATIVE PAC		SPRINKLER FITTERS & APPRENTICES LOCAL 483 LEGISLATIVE PAC		SPRINKLER FITTERS & APPRENTICES LOCAL 483 LEGISLATIVE PAC		SPRINKLER FITTERS & APPRENTICES LOCAL 483 LEGISLATIVE PAC		SPRINKLER FITTERS & APPRENTICES LOCAL 483 LEGISLATIVE PAC		SPRINKLER FITTERS & APPRENTICES LOCAL 483 LEGISLATIVE PAC		SPRINKLER FITTERS & APPRENTICES LOCAL 483 LEGISLATIVE PAC		SPRINKLER FITTERS & APPRENTICES LOCAL 483 POLITICAL ACTION COMMITTEE		SPRINKLER FITTERS & APPRENTICES LOCAL 483 POLITICAL ACTION COMMITTEE		SPRINKLER FITTERS & APPRENTICES LOCAL 483 POLITICAL ACTION COMMITTEE		SPRINKLER FITTERS & APPRENTICES LOCAL 483 POLITICAL ACTION COMMITTEE		SPRINKLER FITTERS & APPRENTICES LOCAL 483 POLITICAL ACTION COMMITTEE		SPRINKLER FITTERS & APPRENTICES LOCAL 483 POLITICAL ACTION COMMITTEE		SPRINKLER FITTERS & APPRENTICES LOCAL 483 POLITICAL ACTION COMMITTEE		SPRINKLER FITTERS & APPRENTICES LOCAL 483 POLITICAL ACTION COMMITTEE		SPRINKLER FITTERS & APPRENTICES LOCAL 483 POLITICAL ACTION COMMITTEE		SPRINKLER FITTER & APPRENTICES PAC		SPRINKLER FITTER & APPRENTICES PAC		SPRINKLER FITTER & APPRENTICES PAC		SPRINKLER FITTER & APPRENTICES PAC		SPRINKLER FITTER & APPRENTICES PAC		SPRINKLER FITTER & APPRENTICES PAC		SPRINKLER FITTER & APPRENTICES PAC		SPRINKLER FITTER & APPRENTICES PAC		SPRINKLER FITTER & APPRENTICES PAC
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		SACRAMENTO		Hayward		Sacramento		HAYWARD		SACRAMENTO		SACRAMENTO		HAYWARD		HAYWARD		SACRAMENTO		SACRAMENTO		Hayward		Sacramento		HAYWARD		SACRAMENTO		SACRAMENTO		HAYWARD		HAYWARD		SACRAMENTO		SACRAMENTO		Hayward		Sacramento		HAYWARD		SACRAMENTO		SACRAMENTO		HAYWARD		HAYWARD		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95814		94545		95814		94545		95814		95814		94545		94545		95814		95814		94545		95814		94545		95814		95814		94545		94545		95814		95814		94545		95814		94545		95814		95814		94545		94545		95814
phon				(510) 785-8483		(510) 785-8483		5107858483		5107858483		5107858483		5107858483		5107858483		5107858483				(510) 785-8483		(510) 785-8483		5107858483		5107858483		5107858483		5107858483		5107858483		5107858483				(510) 785-8483		(510) 785-8483		5107858483		5107858483		5107858483		5107858483		5107858483		5107858483
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		compliance@olsonremcho.com		compliance@olsonremcho.com		None		None		None		None		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		compliance@olsonremcho.com		compliance@olsonremcho.com		None		None		None		None		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		compliance@olsonremcho.com		compliance@olsonremcho.com

Table: filers

filer_id		1075652

Table: received_filings

filer_id		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652		1075652
filing_file_name		868627_0.cal		877997_0.cal		871895_0.cal		871895_1.cal		910639_0.cal		871895_2.cal		877997_1.cal		962907_0.cal		945922_0.cal		979010_0.cal		1108250_0.cal		1108250_1.cal		1130620_0.cal		1211751_0.cal		1218158_0.cal		1213858_0.cal		1375341_0.cal		1850966_0.cal		1826417_0.cal		1828089_0.cal		2047489_0.cal		2079697_0.cal		1875287_0.cal		1886067_0.cal		2028783_0.cal		2028887_0.cal		2089322_0.cal		2067613_0.cal		1945245_0.cal		1961288_0.cal		2039393_0.cal		2308050_0.cal		2284351_0.cal		2223952_0.cal		2309214_0.cal		2491477_0.cal		2495263_0.cal		2443264_0.cal		112982.cal		2425237_0.cal		2230915_0.cal		2629112_0.cal		2668839_0.cal		2713337_0.cal		2583132_0.cal		2683069_0.cal		2739065_0.cal		2656811_0.cal		2524612_0.cal		2607202_0.cal		509493.cal		2685652_0.cal		2524612_1.cal
received_date		2002-09-20 00:00:00		2002-10-24 00:00:00		2002-10-07 00:00:00		2002-11-12 00:00:00		2003-01-30 00:00:00		2003-02-27 00:00:00		2003-02-27 00:00:00		2003-10-09 00:00:00		2003-07-29 00:00:00		2004-01-08 00:00:00		2005-05-25 00:00:00		2005-05-25 00:00:00		2005-10-25 00:00:00		2006-10-25 00:00:00		2006-11-01 00:00:00		2006-10-27 00:00:00		2008-10-29 00:00:00		2014-05-16 00:00:00		2014-03-06 00:00:00		2014-03-13 00:00:00		2016-05-27 00:00:00		2016-09-21 00:00:00		2014-08-07 00:00:00		2014-09-17 00:00:00		2016-04-15 00:00:00		2016-04-15 00:00:00		2016-10-14 00:00:00		2016-08-11 00:00:00		2015-02-20 00:00:00		2015-04-23 00:00:00		2016-05-04 00:00:00		2018-10-17 00:00:00		2018-08-17 00:00:00		2018-03-21 00:00:00		2018-10-19 00:00:00		2020-08-14 00:00:00		2020-08-26 00:00:00		2020-01-31 00:00:00		2018-07-30 00:00:00		2019-12-16 00:00:00		2018-04-13 00:00:00		2021-11-19 00:00:00		2022-04-21 00:00:00		2022-08-23 00:00:00		2021-05-06 00:00:00		2022-05-16 00:00:00		2022-10-21 00:00:00		2022-03-11 00:00:00		2020-10-28 00:00:00		2021-08-18 00:00:00		2022-04-28 00:00:00		2022-05-24 00:00:00		2020-10-28 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		868627		877997		871895		871895		910639		871895		877997		962907		945922		979010		1108250		1108250		1130620		1211751		1218158		1213858		1375341		1850966		1826417		1828089		2047489		2079697		1875287		1886067		2028783		2028887		2089322		2067613		1945245		1961288		2039393		2308050		2284351		2223952		2309214		2491477		2495263		2443264		None		2425237		2230915		2629112		2668839		2713337		2583132		2683069		2739065		2656811		2524612		2607202		None		2685652		2524612
form_id		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F410		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		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		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		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