Home

Filer ID: 1147392

Table: filer_address

filer_id		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392
adrid		1110791		2043447		2079486		2113623		2159409		2204765		2412477		2545076		2507277		2228709		2465741		2255079		2340129
effect_dt		1999-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00		2021-01-01 00:00:00		2012-02-29 00:00:00		2019-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1999		2003		2005		2007		2009		2011		2017		2023		2021		2011		2019		2013		2015

Table: filer_filings

filer_id		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392
filing_id		509423		504435		505225		505877		507918		506234		506433		507428		507238		506886		508584		508097		504237		504237		505877		507918		507918		506234		506234		507238		509890		505429		509247		510056		508765		505225		505877		507238		508584		509247		504866		624456		614647		625816		610661		638961		638967		638973		638979		638985		621590		621842		621844		660444		660446		661134		644856		655744		650568		650570		680830		650572		717217		709244		684239		686929		741063		754873		754882		752312		745321		731693		747279		725566		749367		790803		793336		776440		780690		771364		815607		802281		813012		799464		801422		837287		836814		823775		831447		842016		820923		858139		855394		886695		906558		909764		884370		902212		944515		930846		932259		940590		945105		930846		944515		966653		951190		940105		940116		962402		983851		983856		977373		977375		988207		987083		972160		1005374		990479		1013832		1014441		1028963		1026213		1037158		1039685		1063239		1068417		1075926		1083415		1058723		1070032		1026213		1058723		1099648		1092700		1113644		1112958		1113644		1103515		1132444		1137934		1142996		1163574		1163574		1184878		1229909		1212108		1212108		1222270		1222270		1252562		1260260		1222270		1222270		1248255		1248259		1248263		1222270		1256222		1280798		1285748		1285749		1222270		1222270		1222270		1222270		1255647		1260307		1268825		1260260		1305215		1222270		1222270		1222270		1292465		1295878		1777885		1761300		1722154		1771004		1789591		1920187		1958681		1979022		1864034		1722154		1867398		1722154		1722154		1805274		1722154		1808019		1722154		1793907		1794432		1958681		1944221		1939087		1954938		1902052		1895149		1864034		1902052		1314954		1327798		1299500		1346877		1358500		1346877		1222270		1393204		1383026		1388006		1387371		1408583		1413968		1375360		1387371		1387371		1429272		1429277		1387371		1420376		1387371		1431001		1450458		1453559		1387371		1432766		1387371		1387371		1468714		1455454		1478880		1387371		1387371		1481706		1387371		1461038		1471610		1503070		1477972		1510492		1516387		1387371		1387371		1387371		1514071		1536724		1552487		1557151		1564346		1563146		1555544		1555544		1564015		1555544		1555544		1602733		1587264		1620624		1596683		1587160		1632404		1650064		1654419		1555544		1555544		1555544		1678959		1672949		1813060		1812765		1722154		1812765		1700097		1931542		1722154		1918199		1916358		1920030		1920187		1717055		1722154		1883069		1722154		1885000		1731094		1723902		1730244		1722154		1734233		1824425		1722154		1848764		1848802		1722154		1840271		1722154		1766517		1766580		1731094		1722154		1763855		1761300		1722154		1970149		1992363		1920187		1920187		2402688		2115171		2115171		2376899		2329788		2547635		2214581		2364318		2482718		2115171		2354840		2272906		2204982		2115171		2437151		2437151		2329788		2238950		2115171		2449269		1999247		2005512		1989898		2032402		2032402		2052805		1920187		1920187		2052998		2059438		2095257		2115171		2115171		2115171		2139137		2146682		2122524		2136196		2172043		2157196		2178531		2115171		2157196		2171969		2115171		2115171		2157485		2160930		2248417		2248439		2115171		2329788		2394751		2234709		2234931		2234932		2329788		2329788		2329788		2115171		2467755		2467755		2157196		2171969		2189984		2525769		2547635		2329788		2582812		2345178		2377675		2377677		2115171		2181741		2181751		2180889		2180890		2415058		2190771		2401620		2207969		2207251		2207297		2207298		2329788		2329788		2318219		2171969		2189984		2115171		2115171		2423660		2115171		2405200		2222657		2552881		2621253		2599031		2586279		2547635		2547635		2605298		2482718		2488787		2696707		2696709		2706117		2547635		2605665		2638307		2639386		2547635		2547635		2638010		2613074		2721094		2694706		2695671		2568265		2580036		2675957		2547635		2547635		2747445
period_id		155		149		142		158		145		143		151		152		144		159		146		153		141		141		158		145		145		143		143		144		148		150		147		156		154		142		158		144		146		147		157		161		158		161		160		None		None		None		None		None		None		None		None		161		162		None		162		162		162		162		163		162		164		None		162		163		None		None		None		None		165		None		165		164		None		167		None		None		None		166		None		None		168		None		None		169		None		None		None		None		None		None		170		None		172		None		171		None		174		173		None		None		None		173		174		175		None		None		None		None		None		None		None		None		None		176		None		None		None		177		None		None		178		None		None		None		180		180		None		179		None		178		179		None		None		182		None		182		181		183		None		184		185		185		186		188		187		187		188		189		189		189		189		189		None		None		None		189		None		190		None		None		190		191		191		191		None		None		None		189		192		193		192		192		None		191		214		213		215		None		None		221		221		222		218		219		None		216		216		None		216		None		215		None		215		221		None		None		None		219		None		218		219		None		193		None		194		None		194		195		196		196		None		196		None		None		195		197		198		None		None		198		197		199		None		199		None		200		198		201		201		None		None		None		201		202		201		200		200		None		202		None		None		None		203		203		203		None		203		204		None		None		None		204		205		204		205		206		206		None		207		None		205		208		None		209		209		211		211		None		210		None		216		217		216		211		220		220		None		None		220		220		212		219		None		219		None		212		None		None		212		213		None		218		None		None		218		217		214		None		None		212		213		None		213		214		None		223		223		223		None		233		233		237		242		246		None		None		242		231		None		234		233		231		240		240		237		233		233		None		None		224		None		225		225		None		226		226		None		226		227		228		229		230		None		None		228		None		None		229		None		231		229		230		231		230		None		None		None		None		234		238		238		None		None		None		238		237		236		231		241		241		229		230		231		243		245		240		None		236		None		None		233		None		None		None		None		239		None		None		None		232		None		None		238		241		235		230		231		231		232		None		234		None		None		244		247		246		None		250		250		None		242		None		None		None		250		244		None		None		248		247		251		None		None		None		250		None		None		245		249		249		252		251
form_id		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F690		F690		F690		F690		F690		F690		F690		F625		F625		F625		F625		F625		F690		F690		F690		F690		F690		F625		F625		F690		F625		F625		F605		F605		F605		F605		F605		F605		F605		F605		F690		F690		F605		F625		F625		F690		F690		F625		F690		F625		F601		F690		F625		F605		F605		F605		F605		F625		F602		F625		F625		F605		F625		F625		F625		F605		F625		F625		F605		F625		F605		F605		F625		F605		F605		F605		F625		F605		F625		F625		F625		F625		F625		F625		F601		F625		F625		F625		F605		F605		F625		F625		F625		F625		F605		F605		F605		F690		F690		F605		F605		F625		F625		F625		F605		F605		F625		F625		F625		F625		F605		F605		F625		F601		F625		F625		F625		F690		F625		F625		F690		F601		F625		F605		F625		F625		F625		F605		F625		F625		F625		F625		F625		F625		F625		F601		F601		F602		F625		F601		F601		F605		F605		F601		F601		F605		F625		F605		F605		F601		F601		F601		F601		F602		F605		F605		F625		F625		F601		F601		F601		F605		F625		F625		F625		F601		F605		F605		F601		F625		F625		F625		F601		F605		F601		F601		F605		F601		F605		F601		F605		F625		F625		F602		F601		F605		F625		F602		F625		F625		F605		F625		F605		F625		F605		F625		F601		F625		F602		F601		F601		F602		F605		F625		F601		F601		F605		F605		F601		F625		F601		F605		F625		F605		F601		F625		F601		F601		F605		F605		F605		F601		F601		F625		F601		F625		F605		F625		F605		F605		F605		F601		F601		F601		F605		F625		F602		F602		F605		F601		F601		F601		F625		F601		F601		F625		F605		F625		F605		F625		F625		F605		F625		F601		F601		F601		F605		F625		F605		F625		F601		F625		F625		F625		F601		F602		F605		F602		F601		F602		F601		F605		F601		F605		F625		F602		F601		F601		F602		F605		F601		F605		F605		F601		F625		F601		F605		F605		F625		F601		F602		F625		F601		F605		F625		F601		F601		F605		F601		F601		F625		F601		F601		F605		F601		F625		F601		F602		F625		F602		F601		F625		F625		F601		F625		F601		F605		F605		F625		F605		F625		F625		F605		F601		F601		F605		F625		F625		F601		F601		F601		F602		F605		F625		F601		F605		F625		F605		F601		F625		F625		F601		F601		F605		F605		F605		F602		F601		F601		F625		F605		F602		F602		F601		F601		F601		F601		F625		F625		F625		F625		F625		F625		F601		F601		F602		F625		F605		F605		F601		F605		F605		F605		F605		F625		F605		F605		F602		F625		F605		F605		F601		F601		F625		F625		F625		F601		F601		F605		F601		F605		F605		F625		F625		F625		F601		F601		F601		F602		F625		F605		F602		F605		F625		F601		F605		F605		F625		F601		F601		F605		F605		F605		F602		F605		F602		F625		F625		F601		F601		F625
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		1		2		2		1		1		2		1		0		0		0		0		0		1		1		2		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		0		0		0		0		0		1		0		0		0		0		0		1		0		0		1		0		0		1		0		0		4		3		0		0		0		2		0		0		0		0		5		6		7		8		0		0		0		1		0		11		10		9		0		0		0		1		4		0		0		1		1		0		0		12		0		6		7		0		8		0		5		0		0		0		0		0		0		1		0		1		0		0		0		0		0		0		1		12		0		0		0		0		0		0		0		1		2		0		0		3		0		4		0		0		0		6		0		8		7		0		0		0		9		10		0		5		0		0		0		0		0		0		11		13		12		0		0		0		0		0		0		0		1		0		2		3		0		0		0		0		0		0		0		0		4		5		6		0		0		0		0		9		1		0		0		15		0		0		0		0		0		13		0		14		0		1		0		0		0		0		0		10		0		0		11		0		3		0		0		0		1		0		0		2		0		0		3		2		0		12		14		0		8		2		0		0		0		9		0		0		0		8		0		1		2		0		13		0		0		0		0		0		1		0		4		5		0		0		0		0		1		2		0		0		0		0		0		1		0		5		0		0		4		3		0		0		0		0		15		4		0		0		0		0		3		1		0		7		0		1		2		2		1		0		1		6		0		0		0		0		11		0		0		0		0		0		0		0		0		0		0		0		5		7		0		1		0		6		10		0		16		0		0		0		0		0		0		5		6		0		1		0		0		0		0		0		0		0		0		3		7		0		0		0		0		0		0		0		0		4		8		0
filing_date		1998-10-29 00:00:00		1997-04-30 00:00:00		1995-07-28 00:00:00		1999-07-29 00:00:00		1996-04-26 00:00:00		1995-10-31 00:00:00		1997-10-29 00:00:00		1998-01-28 00:00:00		1996-01-31 00:00:00		1999-10-29 00:00:00		1996-07-30 00:00:00		1998-04-29 00:00:00		1995-05-01 00:00:00		1995-09-12 00:00:00		1999-08-26 00:00:00		1996-12-16 00:00:00		1996-08-12 00:00:00		1995-12-18 00:00:00		1996-03-06 00:00:00		1996-03-06 00:00:00		1997-01-31 00:00:00		1997-07-31 00:00:00		1996-10-31 00:00:00		1999-01-27 00:00:00		1998-07-31 00:00:00		1995-12-18 00:00:00		1999-08-11 00:00:00		1996-10-22 00:00:00		1996-08-12 00:00:00		1996-11-05 00:00:00		1999-04-30 00:00:00		2000-05-01 00:00:00		1999-12-13 00:00:00		2000-05-01 00:00:00		2000-01-28 00:00:00		2000-06-01 00:00:00		2000-05-31 00:00:00		2000-05-31 00:00:00		2000-05-31 00:00:00		2000-06-01 00:00:00		2000-03-30 00:00:00		2000-01-21 00:00:00		2000-03-30 00:00:00		2000-09-08 00:00:00		2000-09-08 00:00:00		2000-09-12 00:00:00		2000-07-31 00:00:00		2000-07-31 00:00:00		2000-08-08 00:00:00		2000-08-08 00:00:00		2000-10-30 00:00:00		2000-08-08 00:00:00		2001-01-30 00:00:00		2000-12-22 00:00:00		2000-09-15 00:00:00		2000-10-31 00:00:00		2001-03-19 00:00:00		2001-05-14 00:00:00		2001-05-14 00:00:00		2001-04-27 00:00:00		2001-04-30 00:00:00		2001-02-01 00:00:00		2001-04-30 00:00:00		2001-01-31 00:00:00		2001-05-02 00:00:00		2001-10-30 00:00:00		2001-10-31 00:00:00		2001-07-31 00:00:00		2001-09-10 00:00:00		2001-07-30 00:00:00		2002-01-31 00:00:00		2001-12-11 00:00:00		2002-01-30 00:00:00		2001-11-30 00:00:00		2001-12-18 00:00:00		2002-04-25 00:00:00		2002-04-22 00:00:00		2002-02-19 00:00:00		2002-03-14 00:00:00		2002-04-30 00:00:00		2002-02-13 00:00:00		2002-07-31 00:00:00		2002-07-31 00:00:00		2002-10-31 00:00:00		2003-01-27 00:00:00		2003-01-27 00:00:00		2002-10-31 00:00:00		2002-12-27 00:00:00		2003-07-25 00:00:00		2003-04-30 00:00:00		2003-04-30 00:00:00		2003-07-01 00:00:00		2003-07-22 00:00:00		2003-10-24 00:00:00		2003-10-24 00:00:00		2003-10-24 00:00:00		2003-07-25 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-10-07 00:00:00		2003-10-24 00:00:00		2003-10-24 00:00:00		2003-12-24 00:00:00		2003-12-24 00:00:00		2004-01-28 00:00:00		2004-01-27 00:00:00		2003-10-24 00:00:00		2004-03-03 00:00:00		2004-01-28 00:00:00		2004-04-30 00:00:00		2004-04-30 00:00:00		2004-07-27 00:00:00		2004-07-27 00:00:00		2004-08-12 00:00:00		2004-08-30 00:00:00		2004-11-01 00:00:00		2004-12-29 00:00:00		2005-01-26 00:00:00		2005-01-27 00:00:00		2005-01-26 00:00:00		2004-11-01 00:00:00		2004-11-01 00:00:00		2004-11-01 00:00:00		2005-01-27 00:00:00		2004-12-29 00:00:00		2005-07-24 00:00:00		2005-07-20 00:00:00		2005-08-16 00:00:00		2005-04-28 00:00:00		2005-10-28 00:00:00		2005-11-28 00:00:00		2006-01-22 00:00:00		2006-04-21 00:00:00		2006-05-10 00:00:00		2006-07-18 00:00:00		2007-01-22 00:00:00		2006-11-08 00:00:00		2006-10-26 00:00:00		2006-11-21 00:00:00		2007-01-18 00:00:00		2007-03-14 00:00:00		2007-04-27 00:00:00		2007-03-22 00:00:00		2007-03-09 00:00:00		2007-02-08 00:00:00		2007-02-08 00:00:00		2007-01-02 00:00:00		2007-01-26 00:00:00		2007-03-12 00:00:00		2007-07-26 00:00:00		2007-07-31 00:00:00		2007-07-31 00:00:00		2007-05-21 00:00:00		2007-07-23 00:00:00		2007-07-23 00:00:00		2007-07-23 00:00:00		2007-03-12 00:00:00		2007-04-09 00:00:00		2007-05-22 00:00:00		2007-05-24 00:00:00		2008-01-23 00:00:00		2008-01-29 00:00:00		2007-11-09 00:00:00		2007-10-01 00:00:00		2007-10-09 00:00:00		2007-10-29 00:00:00		2013-07-24 00:00:00		2013-07-24 00:00:00		2013-08-13 00:00:00		2013-05-14 00:00:00		2013-08-15 00:00:00		2015-04-30 00:00:00		2015-07-29 00:00:00		2015-07-29 00:00:00		2014-07-18 00:00:00		2014-07-23 00:00:00		2014-07-24 00:00:00		2013-11-11 00:00:00		2013-11-11 00:00:00		2013-11-12 00:00:00		2013-12-23 00:00:00		2013-12-23 00:00:00		2013-09-30 00:00:00		2013-10-01 00:00:00		2013-10-16 00:00:00		2015-04-16 00:00:00		2014-12-30 00:00:00		2014-12-23 00:00:00		2012-07-17 00:00:00		2014-10-30 00:00:00		2014-10-03 00:00:00		2014-10-22 00:00:00		2014-10-22 00:00:00		2008-02-08 00:00:00		2008-04-28 00:00:00		2007-11-16 00:00:00		2008-07-28 00:00:00		2008-08-29 00:00:00		2008-09-24 00:00:00		2008-08-18 00:00:00		2009-01-28 00:00:00		2008-12-08 00:00:00		2009-01-06 00:00:00		2009-01-05 00:00:00		2008-12-31 00:00:00		2009-02-10 00:00:00		2008-10-29 00:00:00		2009-02-06 00:00:00		2009-05-14 00:00:00		2009-06-11 00:00:00		2009-05-14 00:00:00		2009-06-12 00:00:00		2009-04-29 00:00:00		2009-07-21 00:00:00		2009-07-14 00:00:00		2009-10-28 00:00:00		2009-10-29 00:00:00		2009-12-07 00:00:00		2009-07-23 00:00:00		2010-03-05 00:00:00		2010-02-04 00:00:00		2010-02-04 00:00:00		2009-12-08 00:00:00		2010-04-08 00:00:00		2010-03-29 00:00:00		2010-04-08 00:00:00		2010-04-23 00:00:00		2009-10-30 00:00:00		2010-01-27 00:00:00		2010-03-04 00:00:00		2010-07-26 00:00:00		2010-03-30 00:00:00		2010-08-03 00:00:00		2010-08-31 00:00:00		2010-08-04 00:00:00		2010-08-31 00:00:00		2010-08-18 00:00:00		2010-08-17 00:00:00		2010-10-27 00:00:00		2010-12-21 00:00:00		2010-12-22 00:00:00		2011-01-13 00:00:00		2010-12-30 00:00:00		2010-12-30 00:00:00		2011-01-12 00:00:00		2011-01-23 00:00:00		2011-03-23 00:00:00		2011-05-24 00:00:00		2011-07-25 00:00:00		2011-03-25 00:00:00		2011-10-28 00:00:00		2011-05-24 00:00:00		2011-04-20 00:00:00		2012-01-26 00:00:00		2012-03-06 00:00:00		2012-04-25 00:00:00		2012-03-05 00:00:00		2012-07-17 00:00:00		2012-07-24 00:00:00		2012-07-26 00:00:00		2012-07-20 00:00:00		2013-11-12 00:00:00		2014-01-24 00:00:00		2014-02-13 00:00:00		2014-02-13 00:00:00		2012-10-19 00:00:00		2015-01-28 00:00:00		2014-11-05 00:00:00		2014-11-25 00:00:00		2014-11-04 00:00:00		2014-12-22 00:00:00		2014-12-23 00:00:00		2012-12-13 00:00:00		2014-08-28 00:00:00		2014-08-26 00:00:00		2014-09-10 00:00:00		2014-09-11 00:00:00		2013-01-31 00:00:00		2012-12-14 00:00:00		2013-01-02 00:00:00		2013-01-02 00:00:00		2013-01-29 00:00:00		2014-02-14 00:00:00		2014-05-02 00:00:00		2014-04-30 00:00:00		2014-04-30 00:00:00		2014-05-02 00:00:00		2014-04-22 00:00:00		2013-05-14 00:00:00		2013-03-05 00:00:00		2013-04-04 00:00:00		2013-01-24 00:00:00		2013-03-06 00:00:00		2013-01-29 00:00:00		2013-04-24 00:00:00		2013-04-03 00:00:00		2015-04-29 00:00:00		2015-10-19 00:00:00		2015-10-15 00:00:00		2015-09-08 00:00:00		2019-07-30 00:00:00		2018-01-24 00:00:00		2018-03-13 00:00:00		2019-04-24 00:00:00		2020-07-23 00:00:00		2021-05-13 00:00:00		2018-02-06 00:00:00		2018-12-28 00:00:00		2020-07-29 00:00:00		2017-08-22 00:00:00		2018-12-31 00:00:00		2018-07-30 00:00:00		2018-01-24 00:00:00		2017-08-22 00:00:00		2020-01-28 00:00:00		2020-07-31 00:00:00		2019-03-18 00:00:00		2018-04-27 00:00:00		2018-02-13 00:00:00		2020-02-07 00:00:00		2015-10-14 00:00:00		2016-01-22 00:00:00		2015-09-08 00:00:00		2016-04-26 00:00:00		2016-05-13 00:00:00		2016-06-24 00:00:00		2016-06-28 00:00:00		2016-06-28 00:00:00		2016-06-28 00:00:00		2016-07-27 00:00:00		2016-10-25 00:00:00		2016-12-29 00:00:00		2017-03-13 00:00:00		2017-04-28 00:00:00		2016-12-29 00:00:00		2017-03-02 00:00:00		2017-01-24 00:00:00		2016-12-29 00:00:00		2017-07-25 00:00:00		2017-07-25 00:00:00		2017-08-02 00:00:00		2017-08-03 00:00:00		2017-05-01 00:00:00		2017-07-26 00:00:00		2017-07-25 00:00:00		2017-05-12 00:00:00		2017-04-28 00:00:00		2017-05-12 00:00:00		2018-05-08 00:00:00		2018-05-08 00:00:00		2018-04-20 00:00:00		2019-04-29 00:00:00		2019-07-29 00:00:00		2018-04-23 00:00:00		2018-04-23 00:00:00		2018-04-23 00:00:00		2019-04-25 00:00:00		2019-03-13 00:00:00		2018-12-27 00:00:00		2017-08-15 00:00:00		2020-04-27 00:00:00		2020-07-29 00:00:00		2018-01-29 00:00:00		2018-01-29 00:00:00		2018-01-29 00:00:00		2020-10-28 00:00:00		2021-03-29 00:00:00		2019-12-05 00:00:00		2021-01-04 00:00:00		2019-01-30 00:00:00		2019-03-18 00:00:00		2019-03-13 00:00:00		2018-01-24 00:00:00		2017-08-22 00:00:00		2017-08-22 00:00:00		2017-08-16 00:00:00		2017-08-16 00:00:00		2019-10-24 00:00:00		2017-10-25 00:00:00		2019-04-29 00:00:00		2018-01-26 00:00:00		2018-01-29 00:00:00		2018-01-26 00:00:00		2018-01-26 00:00:00		2019-07-29 00:00:00		2020-02-07 00:00:00		2018-10-31 00:00:00		2017-10-24 00:00:00		2017-10-24 00:00:00		2017-08-15 00:00:00		2017-10-25 00:00:00		2019-12-05 00:00:00		2018-05-09 00:00:00		2019-05-02 00:00:00		2018-03-14 00:00:00		2021-02-01 00:00:00		2021-10-28 00:00:00		2021-07-29 00:00:00		2021-01-28 00:00:00		2022-06-20 00:00:00		2022-06-28 00:00:00		2021-03-10 00:00:00		2020-08-19 00:00:00		2020-07-27 00:00:00		2022-06-30 00:00:00		2022-06-30 00:00:00		2022-08-01 00:00:00		2021-01-26 00:00:00		2021-03-24 00:00:00		2022-01-18 00:00:00		2022-01-27 00:00:00		2022-01-11 00:00:00		2022-09-06 00:00:00		2022-01-13 00:00:00		2021-05-10 00:00:00		2022-08-31 00:00:00		2022-06-22 00:00:00		2022-06-15 00:00:00		2020-12-30 00:00:00		2021-04-30 00:00:00		2022-05-02 00:00:00		2022-01-13 00:00:00		2022-11-02 00:00:00		2022-10-31 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10005		10005		10005		10001		10005		10001		10005		10005		10005		10005		10005		10005		10005		10001		10005		10005		10005		10005		10001		10005		10005		10005		10001		10005		10005		10001		10005		10005		10001		10005		10005		10005		10005		10005		10005		10001		10005		10001		10005		10001		10005		10001		10001		10005		10005		10005		10002		10002		10001		10005		10005		10005		10005		10006		10006		10005		10005		10005		10001		10005		10005		10005		10001		10005		10005		10001		10005		10005		10005		10001		10001		10005		10002		10006		10002		10001		10006		10005		10001		10005		10002		10001		10001		10005		10001		10001		10002		10001		10001		10002		10001		10001		10002		10001		10001		10002		10002		10005		10005		10005		10002		10005		10001		10005		10005		10002		10002		10002		10002		10005		10005		10005		10002		10001		10002		10002		10002		10005		10001		10001		10002		10002		10005		10006		10002		10002		10001		10001		10002		10006		10002		10002		10006		10002		10006		10002		10006		10001		10001		10005		10005		10006		10002		10005		10002		10001		10005		10001		10005		10001		10005		10002		10002		10001		10001		10005		10001		10005		10006		10001		10002		10002		10005		10005		10002		10001		10002		10005		10001		10006		10002		10001		10002		10002		10006		10006		10006		10002		10002		10001		10002		10001		10006		10001		10006		10006		10006		10002		10002		10002		10006		10001		10001		10005		10006		10005		10001		10002		10001		10002		10002		10001		10006		10001		10006		10001		10001		10006		10001		10002		10002		10002		10006		10001		10006		10001		10002		10002		10001		10001		10002		10005		10006		10001		10001		10001		10002		10005		10002		10006		10002		10005		10005		10001		10001		10006		10002		10005		10005		10002		10001		10002		10006		10006		10001		10002		10005		10001		10002		10006		10001		10002		10002		10005		10002		10002		10001		10002		10002		10006		10005		10001		10002		10001		10001		10001		10002		10001		10002		10002		10001		10002		10005		10006		10001		10006		10001		10002		10005		10002		10002		10005		10001		10001		10001		10002		10002		10005		10005		10001		10005		10006		10002		10005		10002		10001		10001		10002		10002		10005		10005		10006		10005		10002		10002		10001		10005		10005		10005		10002		10002		10001		10002		10001		10002		10002		10002		10002		10001		10002		10002		10005		10001		10005		10005		10002		10005		10005		10005		10005		10001		10005		10005		10005		10001		10005		10005		10002		10002		10001		10002		10001		10002		10002		10005		10002		10005		10006		10001		10001		10001		10005		10002		10002		10002		10002		10005		10005		10005		10001		10001		10005		10002		10001		10002		10002		10002		10002		10002		10001		10005		10005		10001		10001		10002		10002		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		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		11003		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11003		11003		11001		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11003		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003
session_id		1997		1997		1995		1999		1995		1995		1997		1997		1995		1999		1995		1997		1995		1995		1999		1995		1995		1995		1995		1995		1995		1997		1995		1997		1997		1995		1999		1995		1995		1995		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		1999		1999		2001		2001		2001		2001		2001		2001		2001		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		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2013		2013		2013		2013		2013		2015		2015		2015		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2015		2015		2015		2011		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2011		2013		2013		2013		2013		2015		2015		2013		2013		2013		2013		2013		2011		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2011		2013		2013		2013		2013		2015		2015		2015		2015		2019		2017		2017		2019		2019		2021		2017		2019		2019		2017		2019		2017		2017		2017		2019		2019		2019		2017		2017		2019		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2015		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2019		2019		2017		2017		2017		2019		2019		2019		2017		2019		2019		2017		2017		2017		2019		2021		2019		2021		2017		2019		2019		2017		2017		2017		2017		2017		2019		2017		2019		2017		2017		2017		2017		2019		2019		2017		2017		2017		2017		2017		2019		2017		2019		2017		2019		2021		2021		2021		2021		2021		2021		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		GKURIMOT		*		GGILMORE		*		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		*		*		*		GPEREZ		GPEREZ		GPEREZ		GKURIMOT		TTHAM		JLEHMAN		JLEHMAN		GKURIMOT		JLEHMAN		*		SARRIAGA		MHOANG		SARRIAGA		GPEREZ		SARRIAGA		SARRIAGA		GPEREZ		*		GPEREZ		GPEREZ		CFLAGG		GPEREZ		*		YBONILLA		YBONILLA		CFLAGG		*		YBONILLA		SARRIAGA		*		GPEREZ		GPEREZ		*		GPEREZ		GPEREZ		GPEREZ		YBONILLA		SARRIAGA		YBONILLA		*		YBONILLA		COMPLETED		YBONILLA		*		PBANFORD		COMPLETED		COMPLETED		YBONILLA		GPEREZ		SARRIAGA		COMPLETED		COMPLETED		COMPLETED		KVANG		GPEREZ		GPEREZ		CFLAGG		YBONILLA		YBONILLA		GPEREZ		GPEREZ		YBONILLA		COMPLETED		YBONILLA		SARRIAGA		SARRIAGA		COMPLETED		KLARRY		KLARRY		COMPLETED		GPEREZ		GPEREZ		YRODRIGU		COMPLETED		COMPLETED		YRODRIGU		COMPLETED		YRODRIGU		COMPLETED		COMPLETED		YRODRIGU		SARRIAGA		YRODRIGU		SARRIAGA		YRODRIGU		YRODRIGU		YRODRIGU		CFLAGG		LTHIBAUL		LTHIBAUL		LTHIBAUL		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		*		*		*		YRODRIGU		*		*		SARRIAGA		SARRIAGA		SARRIAGA		*		SARRIAGA		LTHIBAUL		CFLAGG		CFLAGG		*		*		*		*		SARRIAGA		SARRIAGA		SARRIAGA		YRODRIGU		LTHIBAUL		*		*		*		GPEREZ		LTHIBAUL		ASAETERN		ASAETERN		PBANFORD		SARRIAGA		PBANFORD		YRODRIGU		AGLADNEY		AGLADNEY		ASAETERN		YRODRIGU		SMCCONNAN		SMCCONNAN		SMCCONNAN		YRODRIGU		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		ASAETERN		AGLADNEY		PBANFORD		GKURIMOT		YRODRIGU		ASAETERN		YRODRIGU		ASAETERN		ASAETERN		SARRIAGA		LTHIBAUL		SARRIAGA		MGUERRA		LTHIBAUL		MGUERRA		*		MGUERRA		YRODRIGU		SARRIAGA		*		SARRIAGA		YRODRIGU		MGUERRA		*		PBANFORD		PBANFORD		PBANFORD		PBANFORD		MGUERRA		YRODRIGU		CFLAGG		MGUERRA		YRODRIGU		YRODRIGU		MGUERRA		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		MGUERRA		YRODRIGU		MGUERRA		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		MPACHECO		YRODRIGU		YRODRIGU		ASAETERN		YRODRIGU		YRODRIGU		ASAETERN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		CFLAGG		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		JINGRAM		YRODRIGU		ASAETERN		YRODRIGU		ASAETERN		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		PBANFORD		YRODRIGU		YRODRIGU		YRODRIGU		SARRIAGA		YRODRIGU		PBANFORD		ASAETERN		GPEREZ		PBANFORD		PBANFORD		YRODRIGU		YRODRIGU		YRODRIGU		SARRIAGA		SARRIAGA		YRODRIGU		ASAETERN		YRODRIGU		PBANFORD		PBANFORD		ASAETERN		PBANFORD		YRODRIGU		ASAETERN		PBANFORD		YRODRIGU		AGLADNEY		YRODRIGU		YRODRIGU		GPEREZ		GPEREZ		YRODRIGU		AGLADNEY		GPEREZ		MKIRKHAM		YRODRIGU		GPEREZ		MKIRKHAM		GPEREZ		SARRIAGA		AGLADNEY		GPEREZ		GPEREZ		AGLADNEY		CAFILER		GPEREZ		AGLADNEY		YRODRIGU		GPEREZ		YRODRIGU		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		GPEREZ		GPEREZ		GPEREZ		GPEREZ		AGLADNEY		AGLADNEY		SARRIAGA		GPEREZ		SARRIAGA		SARRIAGA		SARRIAGA		AGLADNEY		SARRIAGA		YRODRIGU		AGLADNEY		GPEREZ		GPEREZ		AGLADNEY		AGLADNEY		YRODRIGU		GPEREZ		SARRIAGA		GPEREZ		YRODRIGU		YRODRIGU		GPEREZ		SARRIAGA		AGLADNEY		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		MKIRKHAM		CAFILER		AGLADNEY		AGLADNEY		AGLADNEY		MKIRKHAM		SARRIAGA		GPEREZ		CVANLIEW		AGLADNEY		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		GPEREZ		AGLADNEY		GPEREZ		SARRIAGA		YRODRIGU		AGLADNEY		GPEREZ		GPEREZ		GPEREZ		GPEREZ		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		GPEREZ		GPEREZ		YRODRIGU		GPEREZ		YRODRIGU		MKIRKHAM		CHATRIDGE		MKIRKHAM		MMERCHANT		CVANLIEW		CVANLIEW		CVANLIEW		CAFILER		GPEREZ		CVANLIEW		CVANLIEW		CAFILER		MMERCHANT		SARRIAGA		CVANLIEW		MKIRKHAM		MMERCHANT		CVANLIEW		MMERCHANT		MKIRKHAM		CVANLIEW		CVANLIEW		CVANLIEW		CVANLIEW		MKIRKHAM		CAFILER		MMERCHANT		CAFILER		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11003		11003		11003		11003		11003		11003		11003		11003		11002		11003		11002		11003		11002		11003		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11003		11001		11001		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		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		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11001		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003
rpt_start		1998-07-01 00:00:00		1997-01-01 00:00:00		1995-04-01 00:00:00		1999-04-01 00:00:00		1996-01-01 00:00:00		1995-07-01 00:00:00		1997-07-01 00:00:00		1997-10-01 00:00:00		1995-10-01 00:00:00		1999-07-01 00:00:00		1996-04-01 00:00:00		1998-01-01 00:00:00		1995-01-01 00:00:00		1995-01-01 00:00:00		1999-04-01 00:00:00		1996-01-01 00:00:00		1996-01-01 00:00:00		1995-07-01 00:00:00		1995-07-01 00:00:00		1995-10-01 00:00:00		1996-10-01 00:00:00		1997-04-01 00:00:00		1996-07-01 00:00:00		1998-10-01 00:00:00		1998-04-01 00:00:00		1995-04-01 00:00:00		1999-04-01 00:00:00		1995-10-01 00:00:00		1996-04-01 00:00:00		1996-07-01 00:00:00		1999-01-01 00:00:00		2000-01-01 00:00:00		1999-04-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		None		None		None		None		None		None		None		None		2000-01-01 00:00:00		2000-04-01 00:00:00		None		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		2000-04-01 00:00:00		2000-10-01 00:00:00		1900-01-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		2000-10-01 00:00:00		1900-01-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		1900-01-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		1900-01-01 00:00:00		2001-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-01-01 00:00:00		1900-01-01 00:00:00		2002-04-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-07-01 00:00:00		2004-12-28 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2004-04-01 00:00:00		2004-04-01 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		2005-04-01 00:00:00		1900-01-01 00:00:00		2005-04-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		1900-01-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2006-10-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2006-11-21 00:00:00		2007-01-18 00:00:00		2007-03-14 00:00:00		2007-01-01 00:00:00		2007-03-22 00:00:00		2007-03-09 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-01-26 00:00:00		1900-01-01 00:00:00		2007-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-05-21 00:00:00		2007-07-23 00:00:00		2007-07-23 00:00:00		2007-07-23 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-01-01 00:00:00		2007-10-01 00:00:00		2008-01-29 00:00:00		2007-11-09 00:00:00		2007-10-01 00:00:00		1900-01-01 00:00:00		2007-07-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2013-08-05 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-03-30 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2014-04-01 00:00:00		2014-07-21 00:00:00		1900-01-01 00:00:00		2013-11-07 00:00:00		2013-11-07 00:00:00		1900-01-01 00:00:00		2013-12-10 00:00:00		1900-01-01 00:00:00		2013-09-09 00:00:00		1900-01-01 00:00:00		2013-07-01 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		1900-01-01 00:00:00		2014-04-01 00:00:00		2014-07-01 00:00:00		1900-01-01 00:00:00		2008-01-01 00:00:00		1900-01-01 00:00:00		2008-04-01 00:00:00		1900-01-01 00:00:00		2008-04-01 00:00:00		2008-08-18 00:00:00		2008-10-01 00:00:00		2008-12-08 00:00:00		1900-01-01 00:00:00		2008-12-03 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-07-01 00:00:00		2009-01-20 00:00:00		2009-05-07 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-06-01 00:00:00		2009-01-01 00:00:00		2009-07-07 00:00:00		1900-01-01 00:00:00		2009-07-01 00:00:00		1900-01-01 00:00:00		2009-11-23 00:00:00		2009-04-01 00:00:00		2010-02-16 00:00:00		2010-02-03 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-03-12 00:00:00		2010-04-06 00:00:00		2010-01-01 00:00:00		2009-10-19 00:00:00		2009-10-01 00:00:00		1900-01-01 00:00:00		2010-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-07-29 00:00:00		2010-08-30 00:00:00		2010-08-12 00:00:00		1900-01-01 00:00:00		2010-07-01 00:00:00		2010-12-21 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-11-10 00:00:00		2011-01-05 00:00:00		2010-10-01 00:00:00		2011-03-21 00:00:00		2011-05-17 00:00:00		2011-04-01 00:00:00		1900-01-01 00:00:00		2011-07-01 00:00:00		1900-01-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		1900-01-01 00:00:00		2012-01-01 00:00:00		2012-02-29 00:00:00		2012-07-10 00:00:00		2012-07-23 00:00:00		1900-01-01 00:00:00		2012-04-01 00:00:00		1900-01-01 00:00:00		2013-10-01 00:00:00		2014-02-10 00:00:00		2013-10-01 00:00:00		2012-07-01 00:00:00		2014-10-01 00:00:00		2014-10-15 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-12-22 00:00:00		2014-11-10 00:00:00		2012-12-13 00:00:00		2014-08-19 00:00:00		1900-01-01 00:00:00		2014-09-05 00:00:00		1900-01-01 00:00:00		2012-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-11-08 00:00:00		2013-01-29 00:00:00		1900-01-01 00:00:00		2014-04-22 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-04-30 00:00:00		2014-01-01 00:00:00		2013-05-13 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-10-01 00:00:00		2013-01-30 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		2013-04-03 00:00:00		1900-01-01 00:00:00		2015-07-01 00:00:00		2015-09-30 00:00:00		2015-08-20 00:00:00		1900-01-01 00:00:00		2018-01-24 00:00:00		2018-03-07 00:00:00		2019-01-01 00:00:00		2020-06-23 00:00:00		2021-04-29 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-04-01 00:00:00		2017-08-11 00:00:00		1900-01-01 00:00:00		2018-04-01 00:00:00		2018-01-24 00:00:00		2017-08-11 00:00:00		2019-10-01 00:00:00		2019-10-01 00:00:00		2019-03-14 00:00:00		2018-01-01 00:00:00		2018-02-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-10-01 00:00:00		1900-01-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		1900-01-01 00:00:00		2016-06-08 00:00:00		2016-06-08 00:00:00		1900-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-11-28 00:00:00		2017-02-22 00:00:00		2017-04-26 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-08-01 00:00:00		2017-01-01 00:00:00		2017-04-01 00:00:00		2017-07-18 00:00:00		2017-05-11 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-04-04 00:00:00		2019-04-29 00:00:00		2019-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-04-17 00:00:00		2019-03-11 00:00:00		2018-11-26 00:00:00		2017-08-02 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2017-01-01 00:00:00		2017-04-01 00:00:00		2017-07-01 00:00:00		2020-07-01 00:00:00		2021-03-09 00:00:00		2019-12-03 00:00:00		1900-01-01 00:00:00		2018-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-01-02 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-04-29 00:00:00		2020-01-16 00:00:00		2018-07-01 00:00:00		2017-04-01 00:00:00		2017-07-01 00:00:00		2017-08-02 00:00:00		2017-10-24 00:00:00		1900-01-01 00:00:00		2018-04-25 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-10-01 00:00:00		2021-07-01 00:00:00		2021-04-01 00:00:00		1900-01-01 00:00:00		2022-06-09 00:00:00		2022-06-15 00:00:00		1900-01-01 00:00:00		2020-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2022-04-01 00:00:00		2020-11-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-10-01 00:00:00		2021-08-03 00:00:00		2022-08-26 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2022-06-22 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2022-01-11 00:00:00		2022-10-20 00:00:00		2022-07-01 00:00:00
rpt_end		1998-09-30 00:00:00		1997-03-31 00:00:00		1995-06-30 00:00:00		1999-06-30 00:00:00		1996-03-31 00:00:00		1995-09-30 00:00:00		1997-09-30 00:00:00		1997-12-31 00:00:00		1995-12-31 00:00:00		1999-09-30 00:00:00		1996-06-30 00:00:00		1998-03-31 00:00:00		1995-03-31 00:00:00		1995-03-31 00:00:00		1999-06-30 00:00:00		1996-03-31 00:00:00		1996-03-31 00:00:00		1995-09-30 00:00:00		1995-09-30 00:00:00		1995-12-31 00:00:00		1996-12-31 00:00:00		1997-06-30 00:00:00		1996-09-30 00:00:00		1998-12-31 00:00:00		1998-06-30 00:00:00		1995-06-30 00:00:00		1999-06-30 00:00:00		1995-12-31 00:00:00		1996-06-30 00:00:00		1996-09-30 00:00:00		1999-03-31 00:00:00		2000-03-31 00:00:00		1999-06-30 00:00:00		2000-03-31 00:00:00		1999-12-31 00:00:00		None		None		None		None		None		None		None		None		2000-03-31 00:00:00		2000-06-30 00:00:00		None		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		1900-01-01 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		1900-01-01 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		1900-01-01 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		1900-01-01 00:00:00		2001-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-03-31 00:00:00		1900-01-01 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2003-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-03-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-09-30 00:00:00		2004-12-28 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2004-09-30 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		1900-01-01 00:00:00		2005-06-30 00:00:00		1900-01-01 00:00:00		2005-06-30 00:00:00		2005-03-31 00:00:00		2005-09-30 00:00:00		1900-01-01 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-09-30 00:00:00		2006-09-30 00:00:00		2006-11-21 00:00:00		2007-01-18 00:00:00		2007-03-14 00:00:00		2007-03-31 00:00:00		2007-03-22 00:00:00		2007-03-09 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-01-26 00:00:00		1900-01-01 00:00:00		2007-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-05-21 00:00:00		2007-07-23 00:00:00		2007-07-23 00:00:00		2007-07-23 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-03-31 00:00:00		2007-12-31 00:00:00		2008-01-29 00:00:00		2007-11-09 00:00:00		2007-10-01 00:00:00		1900-01-01 00:00:00		2007-09-30 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2013-08-05 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-03-30 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2014-07-21 00:00:00		1900-01-01 00:00:00		2013-11-07 00:00:00		2013-11-07 00:00:00		1900-01-01 00:00:00		2013-12-10 00:00:00		1900-01-01 00:00:00		2013-09-09 00:00:00		1900-01-01 00:00:00		2013-09-30 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		1900-01-01 00:00:00		2014-06-30 00:00:00		2014-09-30 00:00:00		1900-01-01 00:00:00		2008-03-31 00:00:00		1900-01-01 00:00:00		2008-06-30 00:00:00		1900-01-01 00:00:00		2008-06-30 00:00:00		2008-08-18 00:00:00		2008-12-31 00:00:00		2008-12-08 00:00:00		1900-01-01 00:00:00		2008-12-03 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-09-30 00:00:00		2009-01-20 00:00:00		2009-05-07 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-06-01 00:00:00		2009-03-31 00:00:00		2009-07-07 00:00:00		1900-01-01 00:00:00		2009-09-30 00:00:00		1900-01-01 00:00:00		2009-11-23 00:00:00		2009-06-30 00:00:00		2010-02-16 00:00:00		2010-02-03 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-03-12 00:00:00		2010-04-06 00:00:00		2010-03-31 00:00:00		2009-10-19 00:00:00		2009-12-31 00:00:00		1900-01-01 00:00:00		2010-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-07-29 00:00:00		2010-08-30 00:00:00		2010-08-12 00:00:00		1900-01-01 00:00:00		2010-09-30 00:00:00		2010-12-21 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-11-10 00:00:00		2011-01-05 00:00:00		2010-12-31 00:00:00		2011-03-21 00:00:00		2011-05-17 00:00:00		2011-06-30 00:00:00		1900-01-01 00:00:00		2011-09-30 00:00:00		1900-01-01 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		1900-01-01 00:00:00		2012-03-31 00:00:00		2012-02-29 00:00:00		2012-07-10 00:00:00		2012-07-23 00:00:00		1900-01-01 00:00:00		2012-06-30 00:00:00		1900-01-01 00:00:00		2013-12-31 00:00:00		2014-02-10 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2014-12-31 00:00:00		2014-10-15 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-12-22 00:00:00		2014-11-10 00:00:00		2012-12-13 00:00:00		2014-08-19 00:00:00		1900-01-01 00:00:00		2014-09-05 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-11-08 00:00:00		2013-01-29 00:00:00		1900-01-01 00:00:00		2014-04-22 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-04-30 00:00:00		2014-03-31 00:00:00		2013-05-13 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2013-01-30 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		2013-04-03 00:00:00		1900-01-01 00:00:00		2015-09-30 00:00:00		2015-09-30 00:00:00		2015-08-20 00:00:00		1900-01-01 00:00:00		2018-01-24 00:00:00		2018-03-07 00:00:00		2019-03-31 00:00:00		2020-06-23 00:00:00		2021-04-29 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-06-30 00:00:00		2017-08-11 00:00:00		1900-01-01 00:00:00		2018-06-30 00:00:00		2018-01-24 00:00:00		2017-08-11 00:00:00		2019-12-31 00:00:00		2019-12-31 00:00:00		2019-03-14 00:00:00		2018-03-31 00:00:00		2018-02-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-12-31 00:00:00		1900-01-01 00:00:00		2016-03-31 00:00:00		2016-03-31 00:00:00		1900-01-01 00:00:00		2016-06-08 00:00:00		2016-06-08 00:00:00		1900-01-01 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-11-28 00:00:00		2017-02-22 00:00:00		2017-04-26 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-08-01 00:00:00		2017-03-31 00:00:00		2017-06-30 00:00:00		2017-07-18 00:00:00		2017-05-11 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-04-04 00:00:00		2019-04-29 00:00:00		2019-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-04-17 00:00:00		2019-03-11 00:00:00		2018-11-26 00:00:00		2017-08-02 00:00:00		2020-03-31 00:00:00		2020-03-31 00:00:00		2017-03-31 00:00:00		2017-06-30 00:00:00		2017-09-30 00:00:00		2020-09-30 00:00:00		2021-03-09 00:00:00		2019-12-03 00:00:00		1900-01-01 00:00:00		2018-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-01-02 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-04-29 00:00:00		2020-01-16 00:00:00		2018-09-30 00:00:00		2017-06-30 00:00:00		2017-09-30 00:00:00		2017-08-02 00:00:00		2017-10-24 00:00:00		1900-01-01 00:00:00		2018-04-25 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-12-31 00:00:00		2021-09-30 00:00:00		2021-06-30 00:00:00		1900-01-01 00:00:00		2022-06-09 00:00:00		2022-06-15 00:00:00		1900-01-01 00:00:00		2020-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2022-06-30 00:00:00		2020-11-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-12-31 00:00:00		2021-08-03 00:00:00		2022-08-26 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2022-06-22 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-03-31 00:00:00		2022-03-31 00:00:00		2022-01-11 00:00:00		2022-10-20 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		None		22001		22001		None		None		None		22001		22001		22001		None		None		None		None		None		None		None		None		None		22001		None		None		None		22001		None		None		22001		None		None		None		22001		22001		None		22001		None		22001		22001		None		None		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22006		22006		22006		22001		22006		22006		None		None		None		22006		None		22001		None		None		22006		22006		22006		22006		None		None		None		22001		22001		22006		22006		22006		None		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		None		22001		22001		None		22001		None		22001		None		22001		22001		None		None		None		22001		None		22001		22001		None		22001		None		22001		None		22001		22006		22001		22006		None		22001		None		None		22001		22001		22001		None		None		22001		22001		22001		None		22001		None		22001		22001		22001		22001		None		None		None		22001		22001		22001		22001		22001		None		22001		None		None		None		22001		22001		22001		None		22001		22006		None		None		None		22001		22001		22001		22001		22001		22001		None		22001		None		22001		22001		None		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		None		None		22006		22001		22006		22001		None		22001		None		22001		None		None		22001		22001		None		22001		None		None		22001		22001		22001		None		None		22001		22001		None		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		None		22001		22001		None		22001		22001		None		22001		22001		22001		22001		22001		None		None		22001		None		None		22001		None		22001		22001		22001		22001		22001		None		None		None		None		22001		22001		22001		None		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		None		None		22001		None		None		None		None		22001		None		None		None		22001		None		None		22001		22001		22001		22001		22001		22001		22001		None		22001		None		None		22001		22001		22001		None		22001		22001		None		22001		None		None		None		22001		22001		None		None		22001		22001		22001		None		None		None		22006		None		None		22001		22001		22001		22001		22001

Table: filer_to_filer_type

filer_id		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392
filer_type		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
session_id		1999		1997		1995		2001		2001		2003		2005		2007		2011		2013		2009		2021		2015		2017		2019		2023
category		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
category_type		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
sub_category		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
effect_dt		1999-01-01 00:00:00		1997-01-01 00:00:00		1995-01-01 00:00:00		2001-12-19 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
election_type		0		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		None		2000-01-01 00:00:00		2000-01-01 00:00:00		None		None		None		None		None		None		None		None
party_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
county_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
district_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1147392
xref_id		F22210
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210		F22210
filer_id		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392
filer_type		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		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		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		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		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		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		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		958143396		958143396		958143396		95814		95814		95814		95814		95814		95814		95814		95814		95814
phon		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392
fax		9164466003		9164466003		9164466003		9164466003																				9164466003		9164466003		9164466003		9164466003																				9164466003		9164466003		9164466003		9164466003																				9164466003		9164466003		9164466003		9164466003																				9164466003		9164466003		9164466003		9164466003																				9164466003		9164466003		9164466003		9164466003																				9164466003		9164466003		9164466003		9164466003																				9164466003		9164466003		9164466003		9164466003																				9164466003		9164466003		9164466003		9164466003																				9164466003		9164466003		9164466003		9164466003																				9164466003		9164466003		9164466003		9164466003																				9164466003		9164466003		9164466003		9164466003																				9164466003		9164466003		9164466003		9164466003
email		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1147392

Table: lobbying_chg_log

filer_id		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392
change_no		7		8		9		1		5		2		6		4		11		10		12		13		14		15		16		21		22		24		25		17		18		26		20		28		27		31		0		29		32		33		35		34		37		44		36		38		45		42		43		39		41		40		48		47		46		49		50		51		52		53		54		55		56		57		58		59		60		62		63		61		65		66		67		64		69		68		70		71		72		73		74		76		77		78		79		80		75		81		82		83		84		85		86		87		88		89		90		91
session_id		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2005		2003		2007		2009		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2013		2013		2013		2013		2013		2013		2013		2015		2015		2015		2015		2015		2017		2015		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2019		2019		2019		2021		2021		2021		2021		2021
log_dt		2000-05-31 00:00:00		2000-05-31 00:00:00		2000-05-31 00:00:00		2000-06-01 00:00:00		2000-07-22 00:00:00		2000-05-31 00:00:00		2000-08-08 00:00:00		2000-07-03 00:00:00		2000-11-02 00:00:00		2000-06-01 00:00:00		2001-05-02 00:00:00		2001-05-11 00:00:00		2001-05-14 00:00:00		2001-05-14 00:00:00		2001-02-01 00:00:00		2001-11-30 00:00:00		2001-12-18 00:00:00		2001-12-18 00:00:00		2001-12-11 00:00:00		2001-03-19 00:00:00		2001-04-27 00:00:00		2002-02-19 00:00:00		2001-09-10 00:00:00		2002-03-14 00:00:00		2002-03-14 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-12-24 00:00:00		2003-12-24 00:00:00		2005-11-28 00:00:00		2004-03-03 00:00:00		2007-10-09 00:00:00		2010-03-04 00:00:00		2007-04-09 00:00:00		2008-08-29 00:00:00		2010-03-30 00:00:00		2009-12-08 00:00:00		2010-02-04 00:00:00		2009-07-14 00:00:00		2009-10-29 00:00:00		2009-06-11 00:00:00		2010-08-17 00:00:00		2010-08-03 00:00:00		2010-03-30 00:00:00		2010-08-31 00:00:00		2011-03-25 00:00:00		2012-07-17 00:00:00		2012-07-17 00:00:00		2012-07-17 00:00:00		2013-03-05 00:00:00		2013-04-04 00:00:00		2013-05-14 00:00:00		2013-10-01 00:00:00		2013-12-03 00:00:00		2014-07-24 00:00:00		2014-10-27 00:00:00		2015-04-06 00:00:00		2015-10-14 00:00:00		2015-04-29 00:00:00		2016-06-24 00:00:00		2016-06-28 00:00:00		2017-05-12 00:00:00		2016-06-24 00:00:00		2017-07-25 00:00:00		2017-04-28 00:00:00		2017-08-22 00:00:00		2017-08-16 00:00:00		2017-08-02 00:00:00		2017-08-16 00:00:00		2017-08-22 00:00:00		2018-01-26 00:00:00		2018-01-26 00:00:00		2018-01-26 00:00:00		2018-04-23 00:00:00		2018-03-14 00:00:00		2017-10-25 00:00:00		2018-05-08 00:00:00		2018-05-08 00:00:00		2018-05-08 00:00:00		2019-03-18 00:00:00		2019-03-13 00:00:00		2020-07-27 00:00:00		2021-01-28 00:00:00		2021-01-28 00:00:00		2021-01-28 00:00:00		2021-01-28 00:00:00		2021-01-28 00:00:00
filer_type		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3
correction_flg		Y		Y		Y		Y		None		Y		None		Y		Y		Y		Y		None		Y		Y		Y		Y		None		Y		Y		Y		Y		Y		Y		Y		None		Y		Y		Y		Y		Y		None		None		Y		Y		Y		Y		None		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		None		None		None		None		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		None		None		None		None		None		None		None		None
action		ADDED		ADDED		ADDED		ADDED		CHANGED		ADDED		CHANGED		ADDED		DELETED		ADDED		DELETED		CHANGED		ADDED		ADDED		ADDED		NEW		SET ACTIVE		CHANGED		NEW		NEW		ADDED		DELETED		ADDED		DELETED		DELETED		NEW		NEW		DELETED		DELETED		DELETED		ADDED		ADDED		DELETED		ADDED		ADDED		ADDED		ADDED		DELETED		DELETED		ADDED		ADDED		ADDED		ADDED		DELETED		ADDED		DELETED		DELETED		DELETED		DELETED		DELETED		ADDED		DELETED		DELETED		ADDED		DELETED		DELETED		DELETED		ADDED		ADDED		ADDED		ADDED		ADDED		DELETED		TERMINATED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		DELETED		DELETED		DELETED		ADDED		ADDED		DELETED		ADDED		ADDED		ADDED		DELETED		DELETED		DELETED		ADDED		ADDED		ADDED		ADDED		ADDED
attribute_changed		CLIENT		CLIENT		CLIENT		CLIENT		None		LOBBYIST		ADDRESS AND PHONE		CLIENT		DELETED CLIENT		CLIENT		EMPLOYER		PHONE		EMPLOYER		EMPLOYER		FIRM		EMPLOYER				NAME		EMPLOYER		EMPLOYER		EMPLOYER		CLIENT/FIRM		CLIENT/FIRM		EMPLOYER		CLIENT		None		None		None		None		None		CLIENT		CLIENT		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		CLIENT		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		None		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		CLIENT		FIRM		CLIENT		FIRM		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		LOBBYIST		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
ethics_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
interests		None		GOVERNMENT		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_full_name		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, THE		GUALCO GROUP, THE		GUALCO GROUP, INC., THE		GUALCO GROUP, THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC., THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE		GUALCO GROUP, INC.; THE
filer_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SACRAMENTO		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		None		None		None		None		None		None		None		None		None		SACRAMENTO		SACRAMENTO		None		None		None		None		None		None		SACRAMENTO		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SACRAMENTO		None		None		SACRAMENTO		SACRAMENTO		None		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		None		None		SACRAMENTO		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		None		None		None		None		None		None		None
filer_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		CA		None		CA		CA		None		None		None		None		None		None		None		None		None		CA		CA		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		CA		CA		None		None		CA		CA		CA		CA		CA		CA		CA		None		None		None		CA		CA		None		CA		CA		CA		None		None		None		None		None		None		None		None
filer_zip		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None				95814		95814		None		95814		95814		None		None		None		None		None		None		None		None		None		95814		95814		None		None		None		None		None		None		95814		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		95814		None		None		95814		95814		None		None		95814		95814		95814		95814		95814		95814		95814		None		None		None		95814		95814		None		95814		95814		95814		None		None		None		None		None		None		None		None
filer_phone		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None				9164411392		9164411392		None		9164411392		9164411392		None		None		None		None		None		None		None		None		None		9164411392		9164411392		None		None		None		None		None		None		9164411392		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		9164411392		None		None		9164411392		9164411392		None		None		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		9164411392		None		None		None		9164411392		9164411392		None		9164411392		9164411392		9164411392		None		None		None		None		None		None		None		None
entity_type		1		1		1		1		2		4		1		1		1		1		2		1		2		2		3		2		3		3		2		2		2		3		None		2		1		2		2		2		2		2		1		1		2		2		2		2		1		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		1		3		1		3		2		2		2		2		2		2		4		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		1		1		1		1		1		1		1		1
entity_name		ALLSCRIPTS		COLUSA BASIN DRAINAGE DISTRICT		SUN-MAID GROWERS OF CALIFORNIA		SOUTHERN CALIFORNIA ROCK PRODUCTS ASSOCIATION		CALIFORNIA COUNCIL FOR ENVIRONMENTAL AND ECONOMIC BALANCE		PATRICK D. LEATHERS		SAN GABRIEL BASIN WATER QUALITY AUTHORITY		CAPTAIN'S TABLE HOTEL, LLC		COLUMBUS PUBLIC AFFAIRS ON BEHALF OF CUMMINS ENGINE COMPANY		SOUTHERN CALIFORNIA READY MIXED CONCRETE ASSOCIATION		FELD ENTERTAINMENT, INC.		FELD ENTERTAINMENT, INC.		CITY OF PASADENA		CITY OF BURBANK		NOSSAMAN, GUTHNER, KNOX & ELLIOTT, LLP		RECLAMATION DISTRICT - 800 - BYRON TRACT		None		GUALCO GROUP, THE		AMERICAN INSTITUTES FOR RESEARCH		CITY OF VACAVILLE		CITY OF GLENDALE		CARPI & CLAY		CARPI & CLAY		PORT OF OAKLAND		FILER INFORMATION		GULF OYSTER INDUSTRY COUNCIL		SCIENTIFIC GAMES INTERNATIONAL, INC.		DELTA WETLANDS PROPERTIES, INC.		VACAVILLE, CITY OF		GULF OYSTER INDUSTRY COUNCIL		NAPA FLOOD CONTROL AND WATER CONSERVATION DISTRICT		LAKE COUNTY SANITATION DISTRICT		GLENN-COLUSA IRRIGATION DISTRICT		UNITED WATER CONSERVATION DISTRICT		CAN MANUFACTURERS INSTITUTE		ASSOCIATION OF CALIFORNIA VETERINARIANS		GREAT OAKS WATER COMPANY		ASSOCIATION OF CALIFORNIA VETERINARIANS		SCIENTIFIC GAMES INTERNATIONAL, INC.		LS POWER ASSOCIATES, L.P.		TRUE ORGANIC PRODUCTS		TRANSMISSION AGENCY OF NORTHERN CALIFORNIA		GREY K. RENEWABLE ENERGY LIMITED		AMADOR WATER AGENCY		GREAT OAKS WATER COMPANY		CALIFORNIA CONSTRUCTION & INDUSTRIAL MATERIALS ASSOCIATION		GREAT OAKS WATER COMPANY		GREY K. RENEWABLE ENERGY LIMITED		COLUSA BASIN DRAINAGE DISTRICT		TRANSMISSION AGENCY OF NORTHERN CALIFORNIA		KELLOGG COMPANY		UPPER SAN GABRIEL VALLEY MUNICIPAL WATER DISTRICT		SAN LUIS DELTA-MENDOTA WATER AUTHORITY		DELOITTE CONSULTING LLP		CLEAN TECH ADVOCATES		AES SOUTHLAND		CARPI & CLAY, INC.		WEST HILLS COMMUNITY COLLEGE DISTRICT		TULELAKE IRRIGATION DISTRICT		UNITED TECHNOLOGIES CORPORATION (DIVISIONS: CARRIER, PRATT & WHITNEY;OTIS;SIKROSKY;HAMILTON SUNDSTRAND;GOODRICH;UTC FIRE & SECURITY;UTC AEROSPACE SYSTEMS;UTC BUILDING & INDUSTRIAL SYSTEMS)		MARATHON ADMINISTRATIVE COMPANY, INC.		ENVIRONMENTAL SECONDARY MARKETS		IMPERIAL IRRIGATION DISTRICT		THEISEN, MARK A.		STANISLAUS REGIONAL WATER AUTHORITY		CALIFORNIA INDEPENDENT PETROLEUM ASSOCIATION (CIPA)		ANTIOCH; CITY OF		CALIFORNIA MUNICIPAL UTILITIES ASSOCIATION		PUBLIC GENERATING POOL		KELLOGG COMPANY		CALIFORNIA CATHOLIC CONFERENCE		PUBLIC GENERATING POOL		CALIFORNIA ASSOCIATION OF ZOOS AND AQUARIUMS		ZOOLOGICAL SOCIETY OF SAN DIEGO; THE		SAN DIEGO UNIFIED PORT DISTRICT		FRESNO; CITY OF		CALIFORNIA MUNICIPAL UTILITIES ASSOCIATION		CERNER CORPORATION		AMADOR WATER AGENCY		SANTA CRUZ COUNTY FLOOD CONTROL & WATER CONSERVATION DISTRICE-ZONE 7		AMADOR WATER AGENCY		UNITED WATER CONSERVATION DISTRICT		UNITED TECHNOLOGIES CORPORATION		CALIFORNIA COUNCIL FOR ENVIRONMENTAL AND ECONOMIC BALANCE		FRIENDS OF OCEANO DUNES, INC.		SAN GABRIEL BASIN WATER QUALITY AUTHORITY		SAN JOSE WATER COMPANY		SANTA CRUZ; CITY OF
entity_city		LIBERTYVILLE		WINTERS		Kingsburg		None		SAN FRANCISCO		None		COVINA		FOLSOM		None		SOUTH PASADENA		None		VIENNA		None		None		SACRAMENTO		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_st		IL		CA		CA		None		CA		None		CA		CA		None		CA		None		VA		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_zip		600484464		95694		936319232		None		94105		None		91724		95630		None		91030		None		22182		None		None		95814		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_phone		8476803515		5307953038		5598976334		None		4155127890		None		6268597777		9163511500		None		6264413107		None		7037495547		None		None		9164428888		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_id		1146465		1146521		1145555		1143056		1142920		1149267		1146396		1224718		1222787		1143055		1145189		1145189		1143872		1143265		1147226		1240612		0		0		None		None		None		1147222		None		None		1146293		1256016		1255929		1144155		1234076		1256016		1281678		1263655		1144878		None		None		1309864		1251387		1309864		1255929		1319453		1322516		None		1330026		1292929		1327344		1143055		1327344		1330026		1146521		1318824		1356012		1231775		1143704		1225430		1354722		1146194		1147222		None		1380673		1239066		None		None		1143378		1148222		None		None		None		None		None		None		None		1397937		1143475		1143347		None		None		1146798		None		None		None		1292929		1325218		1239066		1142920		1243776		1146396		1314735		1145714
responsible_officer		None		MANAGER GAYE LOPEZ		PRESIDENT BARRY KRIEBEL		None		None		None		None		MEMBER ROBERT LEACH		None		STEPHEN BLEDSOE		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		None		None		None		None		None		None		None		None		None		None		2001-03-31 00:00:00		None		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-01-30 00:00:00		2001-11-15 00:00:00		2001-01-01 00:00:00		2002-01-01 00:00:00		2001-12-01 00:00:00		2001-03-01 00:00:00		2001-04-01 00:00:00		2001-12-31 00:00:00		2001-09-10 00:00:00		2002-03-12 00:00:00		2002-03-12 00:00:00		2003-06-06 00:00:00		2003-07-01 00:00:00		2003-07-04 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2005-11-15 00:00:00		2004-02-01 00:00:00		2007-09-30 00:00:00		2010-02-01 00:00:00		2007-04-01 00:00:00		2008-08-18 00:00:00		2010-03-01 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2009-07-01 00:00:00		2009-10-08 00:00:00		2009-06-01 00:00:00		2010-08-12 00:00:00		2010-06-30 00:00:00		2010-03-01 00:00:00		2010-08-31 00:00:00		2011-03-11 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2013-02-01 00:00:00		2013-03-31 00:00:00		2013-03-31 00:00:00		2013-10-01 00:00:00		2013-11-01 00:00:00		2014-06-30 00:00:00		2014-10-01 00:00:00		2015-01-01 00:00:00		2015-10-01 00:00:00		2015-04-01 00:00:00		2016-06-01 00:00:00		2016-06-01 00:00:00		2017-05-12 00:00:00		2016-06-30 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-07-05 00:00:00		2017-08-01 00:00:00		2017-07-24 00:00:00		2017-07-01 00:00:00		2017-08-10 00:00:00		2017-09-24 00:00:00		2018-01-23 00:00:00		2018-01-23 00:00:00		2018-04-01 00:00:00		2018-03-01 00:00:00		2017-10-20 00:00:00		2018-04-01 00:00:00		2018-04-01 00:00:00		2018-04-01 00:00:00		2019-01-01 00:00:00		2019-02-28 00:00:00		2020-03-31 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00

Table: lobbyist_contributions1

filer_id		1147392
filing_period_start_dt		2000-01-01 00:00:00
filing_period_end_dt		2000-03-31 00:00:00
contribution_dt		None
recipient_name		CAROL LUI FOR STATE ASSEMBLY
recipient_id		1076190
amount		250

Table: lobbyist_contributions2

filer_id		1147392
filing_period_start_dt		2000-01-01 00:00:00
filing_period_end_dt		2000-03-31 00:00:00
contribution_dt		None
recipient_name		CAROL LUI FOR STATE ASSEMBLY
recipient_id		1076190
amount		250

Table: received_filings

filer_id		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392		1147392
filing_file_name		624456_0.cal		644856_0.cal		7737.cal		680830_0.cal		144701.cal		144707.cal		144736.cal		144797.cal		717217_0.cal		745321_0.cal		771364_0.cal		790803_0.cal		813012_0.cal		837287_0.cal		855394_0.cal		884370_0.cal		906558_0.cal		930846_0.cal		944515_0.cal		930846_1.cal		944515_1.cal		966653_0.cal		1068417_0.cal		258044.cal		499540.cal		348019.cal		186238.cal		45922.cal		204266.cal		103633.cal		355430.cal		355240.cal		355666.cal		356325.cal		291183.cal		473433.cal		205249.cal		500288.cal		500329.cal		43825.cal		44778.cal		38444.cal		38905.cal		1555544_5.cal		1864034_0.cal		1555544_6.cal		470296.cal		1722154_11.cal		1722154_10.cal		470234.cal		470332.cal		470491.cal		468818.cal		101718.cal		289464.cal		289494.cal		290138.cal		290178.cal		290224.cal		290279.cal		290348.cal		290428.cal		1722154_2.cal		1722154_1.cal		476376.cal		1840271_0.cal		1722154_5.cal		1722154_6.cal		266841.cal		1722154_7.cal		1794432_0.cal		1722154_4.cal		327900.cal		326015.cal		328009.cal		1722154_9.cal		1812765_1.cal		420978.cal		1722154_8.cal		1812765_0.cal		1555544_3.cal		1722154_3.cal		1761300_1.cal		1777885_0.cal		1761300_0.cal		1722154_0.cal		1555544_4.cal		1722154_12.cal		1920187_2.cal		471660.cal		471741.cal		1958681_1.cal		471066.cal		1920187_5.cal		1920187_4.cal		1722154_14.cal		1722154_13.cal		316159.cal		1902052_0.cal		1864034_1.cal		1902052_1.cal		200638.cal		1920187_0.cal		462656.cal		1931542_0.cal		200601.cal		200665.cal		169871.cal		1920187_3.cal		1958681_0.cal		470888.cal		470784.cal		379263.cal		381683.cal		407690.cal		406322.cal		407984.cal		406214.cal		2204982_0.cal		272609.cal		443137.cal		469792.cal		417627.cal		406149.cal		2552881_0.cal		2621253_0.cal		2747445_0.cal		2580036_0.cal		117216.cal		380034.cal		2525769_0.cal		116459.cal		2639386_0.cal		2599031_0.cal		2706117_0.cal		384209.cal		380091.cal		2675957_0.cal
received_date		2000-05-01 00:00:00		2000-07-31 00:00:00		2000-07-31 00:00:00		2000-10-30 00:00:00		2001-03-22 00:00:00		2001-03-22 00:00:00		2001-03-22 00:00:00		2001-03-22 00:00:00		2001-01-30 00:00:00		2001-04-30 00:00:00		2001-07-30 00:00:00		2001-10-30 00:00:00		2002-01-30 00:00:00		2002-04-25 00:00:00		2002-07-31 00:00:00		2002-10-31 00:00:00		2003-01-27 00:00:00		2003-04-30 00:00:00		2003-07-25 00:00:00		2003-10-24 00:00:00		2003-10-24 00:00:00		2003-10-24 00:00:00		2004-12-29 00:00:00		2005-08-26 00:00:00		2009-01-05 00:00:00		2010-05-13 00:00:00		2010-01-26 00:00:00		2010-04-08 00:00:00		2010-01-27 00:00:00		2009-10-30 00:00:00		2007-03-12 00:00:00		2007-03-12 00:00:00		2007-03-12 00:00:00		2007-03-12 00:00:00		2010-03-29 00:00:00		2010-02-04 00:00:00		2010-01-27 00:00:00		2009-06-12 00:00:00		2009-06-12 00:00:00		2008-10-29 00:00:00		2008-10-29 00:00:00		2008-10-29 00:00:00		2008-10-29 00:00:00		2012-07-17 00:00:00		2014-07-18 00:00:00		2012-07-24 00:00:00		2014-05-02 00:00:00		2014-05-02 00:00:00		2014-05-02 00:00:00		2014-05-02 00:00:00		2014-05-02 00:00:00		2014-05-02 00:00:00		2013-01-28 00:00:00		2013-01-31 00:00:00		2013-04-03 00:00:00		2013-04-03 00:00:00		2013-04-03 00:00:00		2013-04-03 00:00:00		2013-04-03 00:00:00		2013-04-03 00:00:00		2013-04-03 00:00:00		2013-04-03 00:00:00		2013-04-03 00:00:00		2013-03-06 00:00:00		2013-03-06 00:00:00		2014-04-22 00:00:00		2013-09-30 00:00:00		2013-11-11 00:00:00		2013-11-11 00:00:00		2013-11-11 00:00:00		2013-10-16 00:00:00		2013-08-13 00:00:00		2010-12-30 00:00:00		2010-12-30 00:00:00		2010-12-30 00:00:00		2014-02-13 00:00:00		2014-02-13 00:00:00		2013-12-23 00:00:00		2013-12-23 00:00:00		2014-01-24 00:00:00		2011-05-24 00:00:00		2013-05-14 00:00:00		2013-07-24 00:00:00		2013-07-24 00:00:00		2013-04-24 00:00:00		2013-01-02 00:00:00		2012-03-05 00:00:00		2014-07-23 00:00:00		2015-09-08 00:00:00		2015-09-08 00:00:00		2015-09-08 00:00:00		2015-07-29 00:00:00		2017-03-13 00:00:00		2016-06-28 00:00:00		2016-06-28 00:00:00		2014-09-10 00:00:00		2014-08-28 00:00:00		2016-12-29 00:00:00		2014-10-22 00:00:00		2014-10-22 00:00:00		2014-10-30 00:00:00		2014-12-23 00:00:00		2014-12-23 00:00:00		2015-01-28 00:00:00		2015-01-28 00:00:00		2014-12-23 00:00:00		2014-12-23 00:00:00		2016-04-26 00:00:00		2015-10-15 00:00:00		2015-04-16 00:00:00		2017-05-01 00:00:00		2017-05-01 00:00:00		2017-07-24 00:00:00		2018-01-24 00:00:00		2018-04-25 00:00:00		2018-02-08 00:00:00		2018-04-25 00:00:00		2018-02-08 00:00:00		2018-01-24 00:00:00		2018-04-20 00:00:00		2018-05-09 00:00:00		2019-04-29 00:00:00		2018-04-25 00:00:00		2018-02-08 00:00:00		2021-02-01 00:00:00		2021-10-28 00:00:00		2022-10-31 00:00:00		2021-04-30 00:00:00		2021-01-26 00:00:00		2022-06-20 00:00:00		2020-10-28 00:00:00		2021-01-26 00:00:00		2022-01-27 00:00:00		2021-07-29 00:00:00		2022-08-01 00:00:00		2022-08-01 00:00:00		2022-06-20 00:00:00		2022-05-02 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/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/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/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/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/temp		/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/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/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/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/cal
filing_id		624456		644856		None		680830		None		None		None		None		717217		745321		771364		790803		813012		837287		855394		884370		906558		930846		944515		930846		944515		966653		1068417		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1555544		1864034		1555544		None		1722154		1722154		None		None		None		None		None		None		None		None		None		None		None		None		None		1722154		1722154		None		1840271		1722154		1722154		None		1722154		1794432		1722154		None		None		None		1722154		1812765		None		1722154		1812765		1555544		1722154		1761300		1777885		1761300		1722154		1555544		1722154		1920187		None		None		1958681		None		1920187		1920187		1722154		1722154		None		1902052		1864034		1902052		None		1920187		None		1931542		None		None		None		1920187		1958681		None		None		None		None		None		None		None		None		2204982		None		None		None		None		None		2552881		2621253		2747445		2580036		None		None		2525769		None		2639386		2599031		2706117		None		None		2675957
form_id		F625		F625		None		F625		None		None		None		None		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F601		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		F601		F625		F601		None		F601		F601		None		None		None		None		None		None		None		None		None		None		None		None		None		F601		F601		None		F625		F601		F601		None		F601		F625		F601		None		None		None		F601		F625		None		F601		F625		F601		F601		F625		F625		F625		F601		F601		F601		F601		None		None		F625		None		F601		F601		F601		F601		None		F625		F625		F625		None		F601		None		F625		None		None		None		F601		F625		None		None		None		None		None		None		None		None		F602		None		None		None		None		None		F625		F625		F625		F625		None		None		F625		None		F625		F625		F625		None		None		F625
receive_comment		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing pass validation, but failed DB constraints		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing did not pass validation		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 accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		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 accepted		Filing accepted		Filing passed validation, but failed DB constraints		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 accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		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 passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing accepted		Filing accepted		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing accepted		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing accepted