Home

Filer ID: 1022714

Table: filer_acronyms

acronym		CITPAC
filer_id		1022714

Table: filer_address

filer_id		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714
adrid		1020629		2056102		2056103		2056104		2102368		2153051		2167584		2464504		2486313		2234222
effect_dt		1992-08-10 00:00:00		1977-07-21 00:00:00		1988-03-02 00:00:00		1995-09-19 00:00:00		2006-04-12 00:00:00		2008-08-11 00:00:00		2009-02-19 00:00:00		2018-09-24 00:00:00		2019-09-18 00:00:00		2012-06-08 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1991		1977		1987		1995		2005		2007		2009		2017		2019		2011

Table: filer_filings

filer_id		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714
filing_id		134573		134574		134575		134576		134521		134522		134523		134524		134525		134526		134527		134528		134529		134530		134531		134532		134533		134534		134535		134536		134537		134539		134540		134541		134542		134544		134545		134546		134547		134548		134549		134550		134551		134552		134553		134554		134555		134556		134557		134558		134559		134560		134561		134563		134564		134565		134566		134568		134569		134570		134571		134572		134577		134578		134579		134580		134581		134582		134583		134584		134585		134586		134587		134588		134589		134590		134591		134593		134594		134595		134596		134597		134598		134599		134600		134601		134602		134603		134604		134605		134606		134607		134608		134609		134610		134611		134612		134613		134614		134615		134616		134617		134618		134620		134621		134622		134623		134624		134625		134626		134627		134628		134629		134630		134631		134632		134633		134634		134635		134636		134637		134638		134639		134640		134642		134643		213455		213456		213457		213458		213459		213460		213461		213462		213463		213464		213465		213466		213467		213468		213469		583760		134538		134543		134562		134567		134592		134619		592880		213470		603627		602949		678077		645695		671851		714156		786040		784882		773965		804719		807309		823465		828274		852633		855397		870318		877710		876453		871019		915385		915428		908903		952359		946414		967851		951664		988683		972101		1025493		1015711		993100		1014610		1030597		1076013		1059139		1055769		1055772		1059146		1088201		1121407		1106519		1143975		1104999		1164452		1136579		1132949		1118427		1152257		1188025		1173000		1205635		1196140		1181315		1203615		1218570		1211680		1243635		1234612		1284018		1284018		1289534		1287270		1981281		1965909		1966680		1966755		1950535		1870756		1857003		1854860		1853169		1801769		1403093		1783375		1786728		1807418		1800808		1935564		1944272		1950535		1893891		1905148		1164452		1320402		1311860		1314336		1349589		1334830		1311860		1337128		1314336		1321201		1368920		1349589		1353613		1361681		1353613		1362217		1363797		1373521		1393725		1417261		1393725		1368920		1400737		1373521		1403093		1403093		1400737		1421730		1421301		1436812		1451518		1451597		1440449		1474989		1463097		1466103		1491084		1504430		1474121		1522297		1492544		1508713		1527274		1570143		1568296		1607079		1620718		1632597		1605761		1636457		1620383		1648009		1647391		1665557		1662679		1403093		1675173		1679619		1668786		1669222		1821734		1826605		1829168		1831951		1818140		1694043		1695645		1403093		1703244		1702943		1706841		1892566		1881631		1874884		1739074		1848961		1834645		1833775		1840351		1746872		1998619		1985026		2299167		2299169		2432225		2224300		2237530		2476899		2243855		2249419		2544392		2205398		2499993		2256460		2477476		2388976		2190866		2283872		2253396		2190113		2014221		1997629		2005891		2033685		2030321		2049287		2058743		2042095		2072406		2070425		2082853		2069835		2094232		2128051		2149722		1403093		2173530		2171417		2159362		2273013		1403093		2414704		2508679		2228774		1403093		2445644		2525071		2297940		2591386		2395102		2410371		2237699		2356741		2496704		2504489		2274028		2295926		2336615		1403093		2412070		2685071		2635083		2698016		2593507		2511951		2496704		2518692		2565580		2615673		2636682		2626355		2715362		2727997		2743618		2725573
period_id		107		108		109		111		71		74		73		71		74		73		74		74		74		74		71		73		75		75		76		76		79		78		87		89		89		91		91		71		91		92		93		93		94		95		93		95		97		97		98		98		99		99		100		99		100		101		99		104		103		105		105		106		113		114		113		115		116		115		116		115		115		116		117		119		119		123		124		127		127		125		127		129		129		128		131		130		131		131		132		117		132		121		121		133		134		137		137		138		138		134		137		137		140		141		144		143		141		143		145		145		148		148		148		149		151		153		153		154		158		153		156		156		157		156		156		159		75		77		87		90		101		102		103		104		121		125		127		129		139		143		145		None		77		91		99		103		124		141		None		147		None		161		None		None		None		None		None		167		None		168		None		169		None		None		169		171		None		172		None		None		None		172		None		173		175		None		176		None		178		None		None		177		None		180		None		179		180		None		None		None		None		184		181		None		None		183		182		None		186		185		None		None		None		187		None		188		None		188		189		189		None		None		222		221		222		None		222		218		218		None		217		None		216		213		None		None		215		220		None		221		None		220		None		193		191		None		194		193		191		None		None		None		196		194		None		None		None		195		None		None		196		None		196		196		None		None		197		197		None		None		197		198		None		199		None		None		200		None		201		202		201		203		None		None		None		None		204		None		None		208		205		None		207		None		209		None		209		210		210		None		None		None		None		217		217		217		216		211		None		210		212		None		212		219		219		None		212		218		217		None		218		None		None		None		None		None		240		233		233		241		234		234		244		232		243		None		None		237		None		235		234		231		None		223		224		225		226		226		226		None		227		227		227		None		None		227		None		230		None		229		None		234		239		None		None		None		235		None		None		None		245		None		None		None		None		243		243		None		235		235		235		239		250		248		249		None		244		243		243		None		247		None		None		251		None		None		251
form_id		F420		F420		F420		F420		F405		F405		F420		F420		F420		F405		F405		F420		F405		F405		F405		F405		F420		F420		F420		F405		F405		F420		F405		F420		F420		F420		F405		F410		F405		F420		F420		F420		F420		F420		F405		F420		F420		F420		F420		F405		F420		F420		F420		F405		F405		F420		F405		F420		F405		F420		F420		F420		F405		F405		F420		F420		F420		F405		F405		F405		F405		F405		F420		F420		F405		F420		F420		F420		F420		F405		F405		F420		F405		F420		F888		F420		F405		F420		F420		F666		F420		F405		F405		F420		F420		F420		F420		F420		F405		F405		F405		F405		F420		F405		F405		F420		F405		F405		F405		F420		F497		F420		F497		F420		F420		F420		F420		F420		F420		F420		F420		F497		F420		F497		F420		F420		F405		F420		F420		F420		F420		F420		F420		F405		F420		F420		F405		F420		F420		F405		F420		F460		F405		F420		F405		F420		F420		F420		F460		F420		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F450		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F497		F460		F497		F460		F460		F460		F410		F460		F460		F410		F460		F460		F460		F497		F460		F497		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F410		F410		F460		F497		F497		F460		F460		F460		F460		F410		F460		F460		F497		F460		F497		F460		F460		F497		F497		F460		F497		F460		F460		F460		F410		F410		F460		F497		F460		F460		F497		F497		F460		F460		F497		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F497		F497		F460		F460		F460		F460		F460		F410		F460		F460		F410		F460		F410		F460		F460		F460		F410		F460		F460		F460		F460		F460		F410		F460		F460		F497		F460		F460		F460		F460		F410		F460		F497		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F497		F460		F460		F460
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		1		0		0		0		0		0		4		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		0		1		0		0		1		0		0		1		0		0		0		1		0		0		1		1		1		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		0		0		0		0		0		0		0		0		0		0		0		3		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		5		0		0		0		0		8		0		0		0		6		0		0		0		0		0		0		0		0		1		0		0		0		0		7		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1986-10-06 00:00:00		1987-01-30 00:00:00		1987-08-03 00:00:00		1988-01-28 00:00:00		1978-04-29 00:00:00		1978-04-29 00:00:00		1978-05-01 00:00:00		1978-04-29 00:00:00		1978-05-25 00:00:00		1978-06-05 00:00:00		1978-06-15 00:00:00		1978-07-31 00:00:00		1978-09-07 00:00:00		1978-09-07 00:00:00		1978-09-07 00:00:00		1978-09-07 00:00:00		1978-09-27 00:00:00		1978-10-26 00:00:00		1979-01-25 00:00:00		1979-03-09 00:00:00		1979-08-10 00:00:00		1981-01-15 00:00:00		1982-03-11 00:00:00		1982-03-23 00:00:00		1982-05-26 00:00:00		1982-10-20 00:00:00		1982-11-15 00:00:00		1977-07-21 00:00:00		1983-01-13 00:00:00		1983-01-21 00:00:00		1983-03-18 00:00:00		1983-05-26 00:00:00		1983-08-01 00:00:00		1983-09-20 00:00:00		1984-01-03 00:00:00		1984-01-30 00:00:00		1984-03-22 00:00:00		1984-05-23 00:00:00		1984-07-18 00:00:00		1984-08-13 00:00:00		1984-09-21 00:00:00		1984-10-23 00:00:00		1985-01-24 00:00:00		1985-05-13 00:00:00		1985-05-13 00:00:00		1985-07-31 00:00:00		1985-07-31 00:00:00		1986-01-30 00:00:00		1986-03-03 00:00:00		1986-03-24 00:00:00		1986-05-22 00:00:00		1986-07-31 00:00:00		1988-03-02 00:00:00		1988-04-06 00:00:00		1988-07-21 00:00:00		1988-10-03 00:00:00		1989-01-30 00:00:00		1989-01-30 00:00:00		1989-03-20 00:00:00		1989-03-20 00:00:00		1989-06-08 00:00:00		1989-06-08 00:00:00		1989-07-21 00:00:00		1990-01-26 00:00:00		1990-06-11 00:00:00		1990-10-04 00:00:00		1990-10-25 00:00:00		1991-09-26 00:00:00		1991-10-23 00:00:00		1992-01-23 00:00:00		1992-01-23 00:00:00		1992-03-19 00:00:00		1992-05-20 00:00:00		1992-01-23 00:00:00		1992-07-13 00:00:00		1992-07-13 00:00:00		1992-08-10 00:00:00		1992-10-05 00:00:00		1992-10-21 00:00:00		1993-01-29 00:00:00		1993-01-13 00:00:00		1993-05-29 00:00:00		1993-05-29 00:00:00		1993-07-23 00:00:00		1994-01-25 00:00:00		1994-05-03 00:00:00		1994-05-26 00:00:00		1994-07-26 00:00:00		1994-08-01 00:00:00		1994-08-01 00:00:00		1994-08-01 00:00:00		1994-08-01 00:00:00		1995-01-19 00:00:00		1995-09-19 00:00:00		1995-12-08 00:00:00		1996-01-17 00:00:00		1996-01-18 00:00:00		1996-06-07 00:00:00		1996-06-07 00:00:00		1996-07-10 00:00:00		1996-10-28 00:00:00		1997-01-23 00:00:00		1996-10-11 00:00:00		1997-07-30 00:00:00		1998-01-20 00:00:00		1998-04-21 00:00:00		1998-05-21 00:00:00		1998-07-15 00:00:00		1999-07-20 00:00:00		1998-09-30 00:00:00		1998-10-20 00:00:00		1998-10-22 00:00:00		1999-06-04 00:00:00		1998-10-23 00:00:00		1999-01-15 00:00:00		1999-10-12 00:00:00		1978-10-17 00:00:00		1979-08-01 00:00:00		1982-02-01 00:00:00		1982-07-27 00:00:00		1985-03-22 00:00:00		1985-07-31 00:00:00		1985-10-24 00:00:00		1986-03-31 00:00:00		1990-07-23 00:00:00		1991-07-10 00:00:00		1992-01-23 00:00:00		1992-05-20 00:00:00		1994-10-04 00:00:00		1995-09-19 00:00:00		1996-03-19 00:00:00		2000-01-05 00:00:00		1979-11-01 00:00:00		1982-09-21 00:00:00		1985-05-13 00:00:00		1985-09-23 00:00:00		1991-01-24 00:00:00		1995-07-31 00:00:00		2000-02-18 00:00:00		1996-10-04 00:00:00		2000-03-01 00:00:00		2000-03-03 00:00:00		2000-10-26 00:00:00		2000-07-31 00:00:00		2000-10-02 00:00:00		2001-01-19 00:00:00		2001-10-04 00:00:00		2001-10-03 00:00:00		2001-07-23 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-02-22 00:00:00		2002-02-22 00:00:00		2002-07-25 00:00:00		2002-07-31 00:00:00		2002-10-02 00:00:00		2002-10-23 00:00:00		2002-10-22 00:00:00		2002-10-03 00:00:00		2002-01-31 00:00:00		2003-01-31 00:00:00		2003-01-29 00:00:00		2003-08-05 00:00:00		2003-07-30 00:00:00		2003-10-27 00:00:00		2003-07-31 00:00:00		2004-01-29 00:00:00		2003-10-28 00:00:00		2004-07-25 00:00:00		2004-05-03 00:00:00		2004-02-02 00:00:00		2004-04-30 00:00:00		2004-07-29 00:00:00		2005-01-26 00:00:00		2004-10-28 00:00:00		2004-10-27 00:00:00		2004-10-27 00:00:00		2004-10-28 00:00:00		2005-01-31 00:00:00		2005-08-01 00:00:00		2005-05-02 00:00:00		2006-01-24 00:00:00		2005-05-01 00:00:00		2006-04-12 00:00:00		2005-10-31 00:00:00		2005-10-30 00:00:00		2005-08-01 00:00:00		2006-02-08 00:00:00		2006-07-26 00:00:00		2006-05-23 00:00:00		2006-10-05 00:00:00		2006-07-31 00:00:00		2006-05-30 00:00:00		2006-10-03 00:00:00		2006-10-26 00:00:00		2006-10-25 00:00:00		2007-01-30 00:00:00		2007-01-29 00:00:00		2007-07-31 00:00:00		2007-08-09 00:00:00		2007-08-14 00:00:00		2007-07-31 00:00:00		2015-07-30 00:00:00		2015-04-30 00:00:00		2015-05-01 00:00:00		2015-04-30 00:00:00		2015-04-29 00:00:00		2014-07-30 00:00:00		2014-05-30 00:00:00		2014-05-22 00:00:00		2014-05-22 00:00:00		2013-10-31 00:00:00		2013-12-02 00:00:00		2013-07-31 00:00:00		2013-07-31 00:00:00		2013-12-03 00:00:00		2013-10-31 00:00:00		2015-01-31 00:00:00		2015-01-27 00:00:00		2015-03-04 00:00:00		2014-10-06 00:00:00		2014-10-24 00:00:00		2008-04-04 00:00:00		2008-03-24 00:00:00		2008-01-31 00:00:00		2008-01-31 00:00:00		2008-07-30 00:00:00		2008-05-22 00:00:00		2008-05-21 00:00:00		2008-05-22 00:00:00		2008-05-23 00:00:00		2008-03-24 00:00:00		2008-10-22 00:00:00		2008-08-07 00:00:00		2008-07-31 00:00:00		2008-08-11 00:00:00		2008-08-08 00:00:00		2008-10-03 00:00:00		2008-10-06 00:00:00		2008-10-23 00:00:00		2009-01-29 00:00:00		2009-02-19 00:00:00		2009-01-29 00:00:00		2009-01-29 00:00:00		2009-02-02 00:00:00		2009-02-02 00:00:00		2009-02-19 00:00:00		2009-02-19 00:00:00		2009-02-02 00:00:00		2009-04-29 00:00:00		2009-04-30 00:00:00		2009-07-30 00:00:00		2009-10-29 00:00:00		2009-10-29 00:00:00		2009-07-30 00:00:00		2010-03-22 00:00:00		2010-01-29 00:00:00		2010-01-29 00:00:00		2010-05-27 00:00:00		2010-07-28 00:00:00		2010-03-22 00:00:00		2010-10-05 00:00:00		2010-05-27 00:00:00		2010-07-29 00:00:00		2010-10-05 00:00:00		2011-01-27 00:00:00		2011-01-27 00:00:00		2011-07-28 00:00:00		2011-10-27 00:00:00		2012-01-26 00:00:00		2011-07-28 00:00:00		2012-01-30 00:00:00		2011-10-27 00:00:00		2012-03-22 00:00:00		2012-03-22 00:00:00		2012-05-24 00:00:00		2012-05-23 00:00:00		2012-06-07 00:00:00		2012-07-26 00:00:00		2012-07-26 00:00:00		2012-06-08 00:00:00		2012-06-21 00:00:00		2014-01-31 00:00:00		2014-03-07 00:00:00		2014-03-15 00:00:00		2014-03-24 00:00:00		2014-01-31 00:00:00		2012-10-04 00:00:00		2012-10-04 00:00:00		2012-06-20 00:00:00		2012-10-25 00:00:00		2012-10-24 00:00:00		2012-10-29 00:00:00		2014-10-06 00:00:00		2014-08-29 00:00:00		2014-07-31 00:00:00		2013-01-31 00:00:00		2014-05-10 00:00:00		2014-03-31 00:00:00		2014-03-24 00:00:00		2014-04-22 00:00:00		2013-01-31 00:00:00		2015-11-02 00:00:00		2015-07-31 00:00:00		2018-09-24 00:00:00		2018-09-24 00:00:00		2020-01-20 00:00:00		2018-03-22 00:00:00		2018-04-26 00:00:00		2020-07-06 00:00:00		2018-05-01 00:00:00		2018-05-15 00:00:00		2021-01-14 00:00:00		2018-01-25 00:00:00		2020-09-09 00:00:00		2018-05-24 00:00:00		2020-07-06 00:00:00		2019-07-08 00:00:00		2017-10-24 00:00:00		2018-08-16 00:00:00		2018-05-24 00:00:00		2017-10-24 00:00:00		2016-01-27 00:00:00		2015-10-31 00:00:00		2016-01-24 00:00:00		2016-04-27 00:00:00		2016-04-20 00:00:00		2016-06-03 00:00:00		2016-07-26 00:00:00		2016-04-28 00:00:00		2016-08-27 00:00:00		2016-08-19 00:00:00		2016-09-29 00:00:00		2016-07-28 00:00:00		2016-09-29 00:00:00		2017-01-30 00:00:00		2017-01-31 00:00:00		2017-04-26 00:00:00		2017-07-25 00:00:00		2017-07-25 00:00:00		2017-04-25 00:00:00		2018-07-30 00:00:00		2019-09-18 00:00:00		2019-10-09 00:00:00		2020-09-23 00:00:00		2018-01-25 00:00:00		2018-09-24 00:00:00		2020-01-22 00:00:00		2020-10-21 00:00:00		2018-09-26 00:00:00		2021-07-07 00:00:00		2019-07-08 00:00:00		2019-09-18 00:00:00		2018-04-26 00:00:00		2019-01-22 00:00:00		2020-09-09 00:00:00		2020-09-23 00:00:00		2018-07-30 00:00:00		2018-09-26 00:00:00		2019-01-21 00:00:00		2018-09-24 00:00:00		2019-10-08 00:00:00		2022-05-23 00:00:00		2022-01-18 00:00:00		2022-07-13 00:00:00		2021-07-07 00:00:00		2020-10-08 00:00:00		2020-08-31 00:00:00		2020-10-20 00:00:00		2021-01-14 00:00:00		2021-10-13 00:00:00		2022-01-18 00:00:00		2021-10-13 00:00:00		2022-08-29 00:00:00		2022-07-13 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10005		10001		10005		10005		10005		10005		10005		10001		10005		10001		10005		10001		10005		10005		10001		10001		10005		10001		10005		10005		10005		10001		10002		10001		10001		10005		10001		10005		10001		10005		10005		10001		10005		10001		10005		10001		10001		10005		10005		10005		10005		10001		10001		10006		10005		10001		10001		10005		10001		10001		10002		10005		10005		10001		10005		10001		10005		10001		10001		10002		10006		10005		10001		10001		10001		10005		10002		10001		10001		10005		10001		10005		10002		10001		10005		10006		10001		10001		10005		10001		10005		10001		10006		10001		10001		10005		10001		10001		10002		10005		10006		10005		10001		10002		10005		10006		10006		10001		10005		10005		10002		10006		10001		10002		10006		10006		10001		10002		10005		10005		10001		10001		10005		10001		10005		10005		10001		10005		10001		10001		10001		10001		10005		10005		10005		10005		10001		10005		10005		10001		10001		10005		10001		10005		10001		10005		10001		10002		10001		10005		10006		10006		10005		10001		10001		10001		10001		10001		10005		10002		10001		10005		10001		10001		10001		10005		10001		10001		10001		10005		10001		10005		10005		10005		10006		10006		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10005		10001		10005		10002		10005		10001		10006		10001		10002		10005		10005		10005		10002		10005		10005		10005		10001		10005		10006		10005		10005		10002		10001		10005		10001		10001		10002		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10005		10005		10001		10005		10005		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11003		11001		11003		11001		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		11001		11003		11003		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11003		11003		11001		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11003		11003		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		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003		11003
session_id		1985		1985		1987		1987		1977		1977		1977		1977		1977		1977		1977		1977		1977		1977		1977		1977		1977		1977		1977		1977		1979		1979		1981		1981		1981		1981		1981		1977		1981		1981		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1983		1985		1983		1985		1985		1985		1985		1985		1987		1987		1987		1987		1987		1987		1987		1987		1987		1987		1989		1989		1989		1989		1989		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1991		1989		1991		1989		1989		1993		1993		1993		1993		1993		1993		1993		1993		1993		1993		1995		1995		1995		1995		1995		1995		1995		1995		1995		1995		1997		1997		1997		1997		1997		1999		1997		1997		1997		1999		1997		1997		1999		1977		1979		1981		1981		1985		1985		1985		1985		1989		1991		1991		1991		1993		1995		1995		1999		1979		1981		1983		1985		1989		1995		1999		1995		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2007		2015		2015		2015		2015		2015		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2015		2013		2013		2005		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2007		2007		2009		2007		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		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2013		2011		2011		2011		2011		2011		2011		2013		2013		2013		2011		2013		2013		2013		2013		2011		2015		2015		2017		2017		2019		2017		2017		2019		2017		2017		2019		2017		2019		2017		2019		2019		2017		2017		2017		2017		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2019		2019		2019		2017		2017		2019		2019		2017		2021		2019		2019		2017		2017		2019		2019		2017		2017		2017		2017		2019		2021		2021		2021		2021		2019		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		KCHAN		JLEHMAN		KCHAN		TWALLS		CFLAGG		*		GPEREZ		*		CFLAGG		*		RALLMOND		DBARRICK		*		*		DBARRICK		*		DBARRICK		DHORRELL		SARRIAGA		COMPLETED		TTHAM		COMPLETED		COMPLETED		GGILMORE		COMPLETED		GGILMORE		COMPLETED		EMCENTEE		EMCENTEE		COMPLETED		TTHAM		COMPLETED		CFLAGG		DHORRELL		DHORRELL		CFLAGG		CFLAGG		GPEREZ		GPEREZ		*		*		TTHAM		KVANG		*		*		CFLAGG		*		DHORRELL		CFLAGG		CFLAGG		DHORRELL		*		CFLAGG		*		SARRIAGA		*		*		*		LHOANG		GPEREZ		MDIGRAZIA		CAFILER		CAFILER		MPACHECO		CAFILER		CAFILER		WBROWN		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		TRAMON		SARRIAGA		SARRIAGA		TRAMON		MDIGRAZIA		CAFILER		GCLARA		GKURIMOT		SARRIAGA		CAFILER		CFLAGG		*		*		SARRIAGA		*		*		*		HTSUBOI		LHOANG		SARRIAGA		*		*		RGEREMIA		RGEREMIA		JVAZQUEZ		TMILLER		TMILLER		RGEREMIA		*		RGEREMIA		*		*		JVAZQUEZ		JVAZQUEZ		*		*		JVAZQUEZ		SARRIAGA		*		MMORENO		MMORENO		MMORENO		MMORENO		SARRIAGA		*		GGILMORE		MMORENO		SARRIAGA		MMORENO		SMCCONNAN		MMORENO		SARRIAGA		SMCCONNAN		CPON		CPON		MMORENO		MMORENO		MDIGRAZIA		MMORENO		MDIGRAZIA		MMORENO		GCLARA		GCLARA		MPACHECO		CAFILER		TRAMON		CPON		CPON		TRAMON		TRAMON		CPON		WBROWN		WBROWN		MDIGRAZIA		CPON		CPON		CPON		TRAMON		CAFILER		MPACHECO		CAFILER		SARRIAGA		CAFILER		MPACHECO		CAFILER		WBROWN		WBROWN		MDIGRAZIA		WBROWN		MPACHECO		MDIGRAZIA		MDIGRAZIA		TRAMON		TRAMON		HCOURSEY		CAFILER		HSTOVALL		SUSHAKOV		CAFILER		CAFILER		SUSHAKOV		HSTOVALL		CAFILER		BSINGH		SUSHAKOV		HCOURSEY		LBARTHOL		CAFILER		BSINGH		LBARTHOL		SARRIAGA		MDIGRAZIA		SARRIAGA		MDIGRAZIA		KBANH		KBANH		SMCCONNAN		MDIGRAZIA		PDEO		PDEO		GPEREZ		SMCCONNAN		GPEREZ		CPON		GTAYLOR		TRAMON		CSAGABAEN		CSAGABAEN		TRAMON		HSTOVALL		TRAMON		HCOURSEY		KRUSSELL		HSTOVALL		TRAMON		HCOURSEY		KRUSSELL		HSTOVALL		BCOLON		HCOURSEY		TRAMON		HSTOVALL		LPHEAV		CAFILER		KRUSSELL		HSTOVALL		HSTOVALL		CAFILER		TRAMON		HCOURSEY		CAFILER		KRUSSELL		CAFILER		BCOLON		CAFILER		CAFILER		KRUSSELL		SUSHAKOV		KRUSSELL		KRUSSELL		KRUSSELL		CAFILER		JMAVES		LPHEAV		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		1986-07-01 00:00:00		1986-10-01 00:00:00		1987-01-01 00:00:00		1987-07-01 00:00:00		1977-07-19 00:00:00		None		1978-01-01 00:00:00		1977-07-19 00:00:00		1978-04-24 00:00:00		1978-01-01 00:00:00		1978-04-24 00:00:00		1978-05-23 00:00:00		1978-04-24 00:00:00		1978-05-24 00:00:00		1977-07-19 00:00:00		1978-01-01 00:00:00		1978-07-01 00:00:00		1978-09-24 00:00:00		1978-10-24 00:00:00		1978-10-24 00:00:00		None		1979-06-01 00:00:00		1981-07-01 00:00:00		1982-01-01 00:00:00		1982-03-17 00:00:00		1982-09-18 00:00:00		1982-07-01 00:00:00		None		1982-09-18 00:00:00		1982-10-18 00:00:00		1983-01-01 00:00:00		1983-03-18 00:00:00		1983-05-23 00:00:00		1983-07-01 00:00:00		1983-01-01 00:00:00		1983-09-18 00:00:00		1984-01-01 00:00:00		1984-03-18 00:00:00		1984-05-20 00:00:00		1984-05-20 00:00:00		1984-07-01 00:00:00		1984-09-18 00:00:00		1984-10-21 00:00:00		1984-07-01 00:00:00		1984-10-21 00:00:00		1985-03-18 00:00:00		1984-07-01 00:00:00		1985-10-19 00:00:00		1985-09-18 00:00:00		1986-01-01 00:00:00		1986-03-18 00:00:00		1986-05-18 00:00:00		None		None		1988-01-01 00:00:00		1988-07-01 00:00:00		1988-10-01 00:00:00		1988-07-01 00:00:00		1988-10-01 00:00:00		1988-07-01 00:00:00		1988-07-01 00:00:00		1988-10-01 00:00:00		1989-01-01 00:00:00		1989-07-01 00:00:00		1989-07-01 00:00:00		1990-07-01 00:00:00		1990-10-01 00:00:00		1991-07-01 00:00:00		1991-09-22 00:00:00		1991-01-01 00:00:00		1991-09-22 00:00:00		1992-01-01 00:00:00		1992-01-01 00:00:00		1991-10-20 00:00:00		None		1992-05-17 00:00:00		None		1992-07-01 00:00:00		1992-10-01 00:00:00		1989-01-01 00:00:00		1992-10-17 00:00:00		1990-01-01 00:00:00		1990-01-01 00:00:00		1993-01-01 00:00:00		1993-06-30 00:00:00		1994-01-01 00:00:00		1994-03-18 00:00:00		1994-05-21 00:00:00		1994-05-21 00:00:00		1993-06-30 00:00:00		1994-01-01 00:00:00		1994-03-18 00:00:00		1994-10-01 00:00:00		1995-01-01 00:00:00		None		1995-07-01 00:00:00		1995-01-01 00:00:00		1995-07-01 00:00:00		1996-01-01 00:00:00		1996-03-18 00:00:00		None		1996-10-01 00:00:00		None		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-01-01 00:00:00		1998-03-18 00:00:00		1998-05-17 00:00:00		1999-04-01 00:00:00		1998-01-01 00:00:00		1998-10-01 00:00:00		None		1999-01-01 00:00:00		None		1998-10-01 00:00:00		1999-07-01 00:00:00		1978-07-01 00:00:00		1979-01-01 00:00:00		1981-07-01 00:00:00		1982-05-23 00:00:00		1985-01-01 00:00:00		1985-05-19 00:00:00		1985-09-18 00:00:00		1985-10-19 00:00:00		1990-01-01 00:00:00		1991-01-01 00:00:00		1991-07-01 00:00:00		1992-03-18 00:00:00		1994-07-01 00:00:00		None		1996-01-01 00:00:00		1999-10-01 00:00:00		1979-01-01 00:00:00		1982-07-01 00:00:00		1984-09-18 00:00:00		1985-07-01 00:00:00		1990-10-21 00:00:00		1995-01-01 00:00:00		2000-01-01 00:00:00		1996-07-01 00:00:00		None		2000-03-01 00:00:00		2000-10-01 00:00:00		2000-02-20 00:00:00		2000-07-01 00:00:00		2000-10-22 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-02-22 00:00:00		None		2002-01-01 00:00:00		2002-01-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		2002-05-09 00:00:00		2002-10-20 00:00:00		2002-10-20 00:00:00		None		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-10-17 00:00:00		2004-07-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2004-10-17 00:00:00		2005-04-01 00:00:00		2005-01-01 00:00:00		2005-10-01 00:00:00		2005-01-01 00:00:00		None		2005-07-01 00:00:00		2005-07-01 00:00:00		2005-04-01 00:00:00		2005-10-01 00:00:00		2006-05-21 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2006-05-21 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		2006-10-01 00:00:00		2006-10-22 00:00:00		2006-10-22 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2015-05-01 00:00:00		2015-01-01 00:00:00		2015-04-29 00:00:00		2014-05-18 00:00:00		2014-05-30 00:00:00		2014-03-18 00:00:00		2014-03-18 00:00:00		2013-07-01 00:00:00		2013-12-02 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		None		2013-07-01 00:00:00		2014-10-01 00:00:00		2014-10-01 00:00:00		2015-03-04 00:00:00		2014-07-01 00:00:00		2014-10-24 00:00:00		None		2008-01-01 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		2008-05-18 00:00:00		2008-03-18 00:00:00		2007-07-01 00:00:00		2008-03-18 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-10-01 00:00:00		2008-05-18 00:00:00		2008-05-18 00:00:00		None		2008-05-18 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-10-19 00:00:00		None		2008-10-19 00:00:00		2008-10-01 00:00:00		2008-10-19 00:00:00		2008-10-01 00:00:00		2009-02-19 00:00:00		2009-02-19 00:00:00		2008-10-19 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2009-04-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2009-10-01 00:00:00		2010-03-18 00:00:00		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2010-03-18 00:00:00		2010-05-23 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-03-18 00:00:00		2012-03-18 00:00:00		2012-06-07 00:00:00		2012-05-20 00:00:00		2012-05-20 00:00:00		None		None		2013-10-01 00:00:00		2014-03-07 00:00:00		2014-03-15 00:00:00		2014-01-01 00:00:00		2013-10-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2012-06-20 00:00:00		2012-10-01 00:00:00		2012-10-01 00:00:00		2012-10-29 00:00:00		2014-07-01 00:00:00		2014-08-29 00:00:00		2014-05-18 00:00:00		2012-10-21 00:00:00		2014-05-10 00:00:00		2014-03-30 00:00:00		2014-01-01 00:00:00		2014-04-22 00:00:00		2012-10-21 00:00:00		2015-07-01 00:00:00		2015-04-01 00:00:00		None		None		2019-10-01 00:00:00		2018-03-22 00:00:00		2018-01-01 00:00:00		2020-01-01 00:00:00		2018-05-01 00:00:00		2018-05-15 00:00:00		2020-10-18 00:00:00		2017-10-01 00:00:00		2020-09-09 00:00:00		2018-04-22 00:00:00		2020-01-01 00:00:00		2019-01-01 00:00:00		2017-07-01 00:00:00		2018-08-16 00:00:00		2018-04-22 00:00:00		2017-07-01 00:00:00		2015-10-01 00:00:00		2015-07-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-20 00:00:00		2016-06-03 00:00:00		2016-04-24 00:00:00		2016-01-01 00:00:00		2016-08-27 00:00:00		2016-08-19 00:00:00		2016-07-01 00:00:00		2016-04-24 00:00:00		2016-07-01 00:00:00		2016-09-25 00:00:00		2016-09-25 00:00:00		2017-04-25 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		None		2018-05-20 00:00:00		2019-09-05 00:00:00		2019-07-01 00:00:00		2020-07-01 00:00:00		2017-10-01 00:00:00		2018-09-24 00:00:00		2019-10-01 00:00:00		2020-09-20 00:00:00		2018-07-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		None		2018-01-01 00:00:00		2018-09-23 00:00:00		2020-09-09 00:00:00		2020-07-01 00:00:00		2018-05-20 00:00:00		2018-07-01 00:00:00		2018-09-23 00:00:00		2018-09-24 00:00:00		2019-07-01 00:00:00		2022-05-23 00:00:00		2021-10-01 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2020-10-08 00:00:00		2020-08-31 00:00:00		2020-09-20 00:00:00		2020-10-18 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2021-07-01 00:00:00		2022-08-29 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00
rpt_end		1986-09-30 00:00:00		1986-12-31 00:00:00		1987-06-30 00:00:00		1987-12-31 00:00:00		1977-12-31 00:00:00		None		1978-04-23 00:00:00		1977-12-31 00:00:00		1978-05-23 00:00:00		1978-04-23 00:00:00		1978-05-23 00:00:00		1978-06-30 00:00:00		1978-05-23 00:00:00		1978-06-30 00:00:00		1977-12-31 00:00:00		1978-04-23 00:00:00		1978-09-23 00:00:00		1978-10-23 00:00:00		1978-12-31 00:00:00		1978-12-31 00:00:00		None		1980-12-31 00:00:00		1981-12-31 00:00:00		1982-03-17 00:00:00		1982-05-22 00:00:00		1982-10-16 00:00:00		1982-09-17 00:00:00		None		1982-10-16 00:00:00		1982-12-31 00:00:00		1983-03-17 00:00:00		1983-05-21 00:00:00		1983-06-30 00:00:00		1983-09-17 00:00:00		1983-03-17 00:00:00		1983-12-31 00:00:00		1984-03-17 00:00:00		1984-05-19 00:00:00		1984-06-30 00:00:00		1984-06-30 00:00:00		1984-09-18 00:00:00		1984-10-20 00:00:00		1984-12-31 00:00:00		1984-09-10 00:00:00		1984-12-31 00:00:00		1985-05-18 00:00:00		1984-09-17 00:00:00		1985-12-31 00:00:00		1985-10-19 00:00:00		1986-03-17 00:00:00		1986-05-17 00:00:00		1986-06-30 00:00:00		None		None		1988-06-30 00:00:00		1988-09-30 00:00:00		1988-12-31 00:00:00		1988-09-30 00:00:00		1988-12-31 00:00:00		1988-09-30 00:00:00		1988-09-30 00:00:00		1988-12-31 00:00:00		1989-06-30 00:00:00		1989-12-31 00:00:00		1989-12-31 00:00:00		1990-09-30 00:00:00		1990-10-20 00:00:00		1991-09-21 00:00:00		1991-10-19 00:00:00		1991-06-30 00:00:00		1991-10-19 00:00:00		1992-03-17 00:00:00		1992-03-17 00:00:00		1991-12-31 00:00:00		None		1992-06-30 00:00:00		None		1992-09-30 00:00:00		1992-10-17 00:00:00		1990-12-31 00:00:00		1992-12-31 00:00:00		1990-06-30 00:00:00		1990-05-17 00:00:00		1993-06-30 00:00:00		1993-12-31 00:00:00		1994-03-17 00:00:00		1994-05-21 00:00:00		1994-06-30 00:00:00		1994-06-30 00:00:00		1993-12-31 00:00:00		1994-03-17 00:00:00		1994-05-21 00:00:00		1994-12-31 00:00:00		1995-06-30 00:00:00		None		1995-12-31 00:00:00		1995-06-30 00:00:00		1995-12-31 00:00:00		1996-03-17 00:00:00		1996-06-30 00:00:00		None		1996-12-31 00:00:00		None		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-03-17 00:00:00		1998-05-16 00:00:00		1998-06-30 00:00:00		1999-06-30 00:00:00		1998-09-30 00:00:00		1998-10-17 00:00:00		None		1999-03-31 00:00:00		None		1998-12-31 00:00:00		1999-09-30 00:00:00		1978-09-23 00:00:00		1979-06-01 00:00:00		1981-12-31 00:00:00		1982-06-30 00:00:00		1985-03-17 00:00:00		1985-06-30 00:00:00		1985-10-19 00:00:00		1985-12-31 00:00:00		1990-06-30 00:00:00		1991-06-30 00:00:00		1991-09-21 00:00:00		1992-05-16 00:00:00		1994-09-30 00:00:00		None		1996-03-17 00:00:00		1999-12-31 00:00:00		1979-06-01 00:00:00		1982-09-17 00:00:00		1984-10-20 00:00:00		1985-09-17 00:00:00		1990-12-31 00:00:00		1995-06-30 00:00:00		2000-02-19 00:00:00		1996-09-30 00:00:00		None		2000-03-01 00:00:00		2000-10-21 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2002-02-22 00:00:00		None		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-10-18 00:00:00		2002-10-19 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		None		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2003-12-31 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-10-16 00:00:00		2004-10-16 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-03-31 00:00:00		2005-12-31 00:00:00		2005-03-31 00:00:00		None		2005-09-30 00:00:00		2005-09-30 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-05-20 00:00:00		2006-09-30 00:00:00		2006-06-30 00:00:00		2006-05-20 00:00:00		2006-09-30 00:00:00		2006-10-21 00:00:00		2006-10-21 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2015-05-01 00:00:00		2015-03-31 00:00:00		2015-04-29 00:00:00		2014-06-30 00:00:00		2014-05-30 00:00:00		2014-05-17 00:00:00		2014-05-17 00:00:00		2013-09-30 00:00:00		2013-12-02 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		None		2013-09-30 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2015-03-04 00:00:00		2014-09-30 00:00:00		2014-10-24 00:00:00		None		2008-03-17 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-05-17 00:00:00		2007-12-31 00:00:00		2008-05-17 00:00:00		2007-12-31 00:00:00		2008-03-17 00:00:00		2008-10-18 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		None		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-09-30 00:00:00		2008-10-18 00:00:00		2008-12-31 00:00:00		None		2008-12-31 00:00:00		2008-10-18 00:00:00		2008-12-31 00:00:00		2008-10-18 00:00:00		2009-02-19 00:00:00		2009-02-19 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-09-30 00:00:00		2009-06-30 00:00:00		2010-03-17 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-03-17 00:00:00		2010-09-30 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2012-03-17 00:00:00		2012-03-17 00:00:00		2012-05-19 00:00:00		2012-05-19 00:00:00		2012-06-07 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		None		None		2013-12-31 00:00:00		2014-03-07 00:00:00		2014-03-15 00:00:00		2014-03-17 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2012-06-20 00:00:00		2012-10-20 00:00:00		2012-10-20 00:00:00		2012-10-29 00:00:00		2014-09-30 00:00:00		2014-08-29 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		2014-05-10 00:00:00		2014-03-30 00:00:00		2014-03-17 00:00:00		2014-04-22 00:00:00		2012-12-31 00:00:00		2015-09-30 00:00:00		2015-06-30 00:00:00		None		None		2019-12-31 00:00:00		2018-03-22 00:00:00		2018-04-21 00:00:00		2020-06-30 00:00:00		2018-05-01 00:00:00		2018-05-15 00:00:00		2020-12-31 00:00:00		2017-12-31 00:00:00		2020-09-09 00:00:00		2018-05-19 00:00:00		2020-06-30 00:00:00		2019-06-30 00:00:00		2017-09-30 00:00:00		2018-08-16 00:00:00		2018-05-19 00:00:00		2017-09-30 00:00:00		2015-12-31 00:00:00		2015-09-30 00:00:00		2015-12-31 00:00:00		2016-04-23 00:00:00		2016-04-20 00:00:00		2016-06-03 00:00:00		2016-06-30 00:00:00		2016-04-23 00:00:00		2016-08-27 00:00:00		2016-08-19 00:00:00		2016-09-24 00:00:00		2016-06-30 00:00:00		2016-09-24 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-04-25 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		None		2018-06-30 00:00:00		2019-09-05 00:00:00		2019-09-30 00:00:00		2020-09-19 00:00:00		2017-12-31 00:00:00		2018-09-24 00:00:00		2019-12-31 00:00:00		2020-10-17 00:00:00		2018-09-22 00:00:00		2021-06-30 00:00:00		2019-06-30 00:00:00		None		2018-04-21 00:00:00		2018-12-31 00:00:00		2020-09-09 00:00:00		2020-09-19 00:00:00		2018-06-30 00:00:00		2018-09-22 00:00:00		2018-12-31 00:00:00		2018-09-24 00:00:00		2019-09-30 00:00:00		2022-05-23 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		2020-10-08 00:00:00		2020-08-31 00:00:00		2020-10-17 00:00:00		2020-12-31 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2021-09-30 00:00:00		2022-08-29 00:00:00		2022-06-30 00:00:00		2022-09-24 00:00:00		2022-09-24 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2000-03-01 00:00:00		None		None		None		None		None		2001-10-03 00:00:00		None		2002-01-10 00:00:00		None		2002-02-22 00:00:00		None		None		2002-07-19 00:00:00		2002-10-02 00:00:00		None		2002-10-22 00:00:00		None		None		None		2003-01-29 00:00:00		None		2003-07-28 00:00:00		2003-10-27 00:00:00		None		2004-01-29 00:00:00		None		2004-07-31 00:00:00		None		None		2004-04-30 00:00:00		None		2005-01-26 00:00:00		None		2004-10-27 00:00:00		2004-10-27 00:00:00		None		None		None		None		2006-01-24 00:00:00		2005-04-27 00:00:00		None		None		2005-10-30 00:00:00		2005-07-31 00:00:00		None		2006-07-26 00:00:00		2006-05-23 00:00:00		None		None		None		2006-10-03 00:00:00		None		2006-10-25 00:00:00		None		2007-01-29 00:00:00		2007-07-31 00:00:00		2007-08-09 00:00:00		None		None		2015-07-28 00:00:00		2015-04-29 00:00:00		2015-05-01 00:00:00		None		2015-04-29 00:00:00		2014-07-27 00:00:00		2014-05-30 00:00:00		None		2014-05-20 00:00:00		None		None		2013-07-31 00:00:00		None		None		2013-10-25 00:00:00		2015-01-26 00:00:00		None		2015-03-04 00:00:00		None		2014-10-24 00:00:00		None		2008-03-21 00:00:00		2008-01-31 00:00:00		None		2008-07-30 00:00:00		2008-05-22 00:00:00		2008-04-03 00:00:00		None		None		None		2008-10-22 00:00:00		2008-08-07 00:00:00		None		None		None		2008-10-03 00:00:00		None		None		2009-01-29 00:00:00		None		2009-01-29 00:00:00		2009-01-29 00:00:00		None		None		None		None		None		None		2009-04-28 00:00:00		2009-07-29 00:00:00		None		2009-10-28 00:00:00		None		None		2010-01-22 00:00:00		None		2010-05-25 00:00:00		2010-07-26 00:00:00		2010-03-18 00:00:00		2010-10-04 00:00:00		None		None		None		None		2011-01-06 00:00:00		None		None		2012-01-26 00:00:00		2011-07-26 00:00:00		None		2011-10-20 00:00:00		None		2012-03-21 00:00:00		None		2012-05-20 00:00:00		None		2012-07-25 00:00:00		None		None		None		None		2014-03-07 00:00:00		2014-03-15 00:00:00		2014-03-19 00:00:00		2014-01-29 00:00:00		2012-10-01 00:00:00		None		None		2012-10-21 00:00:00		None		2012-10-29 00:00:00		2014-10-03 00:00:00		2014-08-29 00:00:00		None		2013-01-30 00:00:00		2014-05-10 00:00:00		2014-03-30 00:00:00		None		2014-04-22 00:00:00		None		None		None		None		None		2020-01-06 00:00:00		2018-03-22 00:00:00		2018-04-25 00:00:00		2020-07-01 00:00:00		2018-05-01 00:00:00		2018-05-15 00:00:00		2021-01-05 00:00:00		2018-01-07 00:00:00		2020-09-09 00:00:00		None		None		2019-06-17 00:00:00		None		2018-08-16 00:00:00		2018-05-22 00:00:00		2017-10-19 00:00:00		None		2015-10-26 00:00:00		2016-01-20 00:00:00		2016-04-25 00:00:00		2016-04-20 00:00:00		2016-06-03 00:00:00		2016-07-15 00:00:00		None		2016-08-27 00:00:00		2016-08-19 00:00:00		2016-09-26 00:00:00		None		None		2017-01-23 00:00:00		None		None		None		2017-07-24 00:00:00		None		2018-07-24 00:00:00		None		None		None		None		None		None		None		None		2021-07-01 00:00:00		None		None		None		None		2020-09-09 00:00:00		2020-09-23 00:00:00		None		2018-09-25 00:00:00		2019-01-16 00:00:00		None		2019-10-03 00:00:00		2022-05-23 00:00:00		2022-01-18 00:00:00		2022-07-11 00:00:00		None		2020-10-08 00:00:00		2020-08-31 00:00:00		2020-10-17 00:00:00		None		2021-09-29 00:00:00		None		None		2022-08-29 00:00:00		None		None		2022-09-29 00:00:00
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		22001		22001		None		22001		None		22001		None		None		22001		None		22001		None		22001		22001		None		None		None		None		22001		22001		None		None		22001		22001		None		22001		22001		None		None		None		22001		None		22001		None		22001		22001		22001		None		None		22001		22001		22001		None		22006		22001		22001		None		22001		None		22006		22001		None		None		22001		22001		None		22001		None		22001		None		22001		22001		None		22001		22001		22001		None		None		None		22001		22001		None		None		None		22001		None		None		22001		None		22001		22001		None		None		22006		22006		None		None		22001		22001		None		22001		None		None		22001		None		22001		22001		22001		22001		None		None		None		None		22001		None		None		22001		22001		None		22001		None		22001		None		22001		22006		22001		None		None		None		None		22001		22001		22001		22001		22001		None		22006		22001		None		22001		22001		22001		None		22001		22001		22001		None		22001		None		None		None		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		None		22001		None		22001		None		22001		None		22001		22001		None		None		None		22001		None		None		None		22001		None		None		None		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		None		None		22001		None		None		22001

Table: filer_to_filer_type

filer_id		1022714		1022714		1022714
filer_type		16		16		16
active		Y		Y		Y
race		0		0		0
session_id		1977		1977		1987
category		0		0		0
category_type		0		40502		40502
sub_category		40103		40103		40103
effect_dt		1977-07-21 00:00:00		1978-04-29 00:00:00		1988-03-02 00:00:00
sub_category_type		0		0		0
election_type		0		0		0
sub_category_a		None		None		S
nyq_dt		1977-05-10 00:00:00		1977-05-10 00:00:00		1977-05-10 00:00:00
party_cd		None		None		None
county_cd		18004		18004		18004
district_cd		None		None		None

Table: filer_xref

filer_id		1022714
xref_id		771171
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171		771171
filer_id		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00		1988-03-02 00:00:00
naml		CALIFORNIA TELEPHONE ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA TELEPHONE ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA TELEPHONE ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA TELEPHONE ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA TELEPHONE ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA TELEPHONE ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA TELEPHONE ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA TELEPHONE ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA TELEPHONE ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA TELEPHONE ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE COMPANY POLITICAL ACTION COMMITTEE (CITPAC)		CALIFORNIA INDEPENDENT TELEPHONE COMPANY POLITICAL ACTION COMMITTEE (CITPAC)		CALIFORNIA INDEPENDENT TELEPHONE COMPANY POLITICAL ACTION COMMITTEE (CITPAC)		CALIFORNIA INDEPENDENT TELEPHONE COMPANY POLITICAL ACTION COMMITTEE (CITPAC)		CALIFORNIA INDEPENDENT TELEPHONE COMPANY POLITICAL ACTION COMMITTEE (CITPAC)		CALIFORNIA INDEPENDENT TELEPHONE COMPANY POLITICAL ACTION COMMITTEE (CITPAC)		CALIFORNIA INDEPENDENT TELEPHONE COMPANY POLITICAL ACTION COMMITTEE (CITPAC)		CALIFORNIA INDEPENDENT TELEPHONE COMPANY POLITICAL ACTION COMMITTEE (CITPAC)		CALIFORNIA INDEPENDENT TELEPHONE COMPANY POLITICAL ACTION COMMITTEE (CITPAC)		CALIFORNIA INDEPENDENT TELEPHONE COMPANY POLITICAL ACTION COMMITTEE (CITPAC)		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE		CALIFORNIA INDEPENDENT TELEPHONE POLITICAL ACTION COMMITTEE
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
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
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
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
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
city		SACRAMENTO		ROSEVILLE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		ROSEVILLE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		ROSEVILLE		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		ROSEVILLE		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
zip4		958154922		95678		958154922		958154922		958154922		95825		95814		95814		95814		95814		958154922		95678		958154922		958154922		958154922		95825		95814		95814		95814		95814		958154922		95678		958154922		958154922		958154922		95825		95814		95814		95814		95814		958154922		95678		958154922		958154922		958154922		95825		95814		95814		95814		95814
phon		9165676700		9167828424		9169224407		9165676700		9165676702		9165676702		9164428888		9164428888		9167062677		9167062677		9165676700		9167828424		9169224407		9165676700		9165676702		9165676702		9164428888		9164428888		9167062677		9167062677		9165676700		9167828424		9169224407		9165676700		9165676702		9165676702		9164428888		9164428888		9167062677		9167062677		9165676700		9167828424		9169224407		9165676700		9165676702		9165676702		9164428888		9164428888		9167062677		9167062677
fax		None		None		None		None		None		None		9164420382		9164420382						None		None		None		None		None		None		9164420382		9164420382						None		None		None		None		None		None		9164420382		9164420382						None		None		None		None		None		None		9164420382		9164420382
email		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1022714

Table: received_filings

filer_id		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714		1022714
filing_file_name		784882_0.cal		804719_0.cal		823465_0.cal		855397_0.cal		876453_0.cal		870318_0.cal		314482.cal		314475.cal		314511.cal		908903_0.cal		946414_0.cal		967851_0.cal		296637.cal		296660.cal		477931.cal		477888.cal		1403093_1.cal		239050.cal		1848961_0.cal		1834645_0.cal		1840351_0.cal		1829168_0.cal		1826605_0.cal		1706841_0.cal		1857003_0.cal		1966680_0.cal		2049287_0.cal		1881631_0.cal		2030321_0.cal		2072406_0.cal		2070425_0.cal		1950535_1.cal		1950535_0.cal		2243855_0.cal		2224300_0.cal		2249419_0.cal		2283872_0.cal		2496704_0.cal		2496704_1.cal		2499993_0.cal		2685071_0.cal		2715362_0.cal		2511951_0.cal
received_date		2001-10-03 00:00:00		2002-01-10 00:00:00		2002-02-22 00:00:00		2002-07-31 00:00:00		2002-10-22 00:00:00		2002-10-02 00:00:00		2002-10-22 00:00:00		2002-10-22 00:00:00		2002-10-22 00:00:00		2003-01-29 00:00:00		2003-07-30 00:00:00		2003-10-27 00:00:00		2005-10-30 00:00:00		2005-10-30 00:00:00		2006-01-24 00:00:00		2006-01-24 00:00:00		2009-02-19 00:00:00		2008-01-31 00:00:00		2014-05-10 00:00:00		2014-03-31 00:00:00		2014-04-22 00:00:00		2014-03-15 00:00:00		2014-03-07 00:00:00		2012-10-29 00:00:00		2014-05-30 00:00:00		2015-05-01 00:00:00		2016-06-03 00:00:00		2014-08-29 00:00:00		2016-04-20 00:00:00		2016-08-27 00:00:00		2016-08-19 00:00:00		2015-04-29 00:00:00		2015-03-04 00:00:00		2018-05-01 00:00:00		2018-03-22 00:00:00		2018-05-15 00:00:00		2018-08-16 00:00:00		2020-08-31 00:00:00		2020-09-09 00:00:00		2020-09-09 00:00:00		2022-05-23 00:00:00		2022-08-29 00:00:00		2020-10-08 00:00:00
filing_directory		/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/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/temp		/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		784882		804719		823465		855397		876453		870318		None		None		None		908903		946414		967851		None		None		None		None		1403093		None		1848961		1834645		1840351		1829168		1826605		1706841		1857003		1966680		2049287		1881631		2030321		2072406		2070425		1950535		1950535		2243855		2224300		2249419		2283872		2496704		2496704		2499993		2685071		2715362		2511951
form_id		F460		F460		F497		F460		F460		F460		None		None		None		F460		F460		F460		None		None		None		None		F410		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted