Home

Filer ID: 1147260

Table: filer_address

filer_id		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260
adrid		1109903		2041820		2079615		2115046		2159528		2204879		2276639		2547755		2520090
effect_dt		1997-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		2013-01-01 00:00:00		2023-01-01 00:00:00		2021-03-10 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1997		2003		2005		2007		2009		2011		2013		2023		2021

Table: filer_filings

filer_id		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260
filing_id		509507		509658		504509		506514		505983		506990		505508		503994		508183		509006		507509		504976		508850		542051		506514		542051		507666		508339		506690		541870		504672		611638		626590		653844		655161		719557		704556		688764		708403		682709		765662		746618		725816		749638		792340		777026		771885		787199		704556		793034		704556		813188		815496		794478		842933		841648		839263		852159		855960		704556		848623		886818		897509		909711		898600		938273		883856		898600		942866		957811		943132		929632		932456		910638		898600		898600		953149		898600		948748		939032		898600		989248		971610		898600		968939		992385		992391		991008		1020121		1024439		1023738		1023736		1013288		1015316		1022825		1068379		1068379		1062847		1056182		1085852		1081081		1097097		1090937		1115200		1103627		1131317		1145300		1166144		1187806		1182796		1223589		1213365		1259547		1231921		1223589		1282776		1232484		1273049		1223589		1223589		1223589		1297491		1223589		1282776		1223589		1223589		1300653		1760989		1778910		1734060		1785798		1734060		1844888		1844888		1734060		1870345		1859430		1796244		1906966		1318393		1311324		1223589		1312993		1330135		1331077		1223589		1348046		1340568		1384662		1378389		1392783		1411486		1406679		1406680		1384662		1421636		1427187		1427182		1427185		1427186		1427188		1427189		1384662		1425922		1433902		1384662		1384662		1384662		1384662		1384662		1384662		1451199		1429882		1429891		1482741		1461746		1505183		1539557		1551366		1552891		1572703		1567460		1580023		1605088		1589017		1632081		1620807		1654309		1815372		1674584		1929239		1706940		1873399		1732702		1734060		1844888		1850255		1734060		1837873		1760989		1762330		2579154		2674735		2650897		2621848		2589922		2568204		2695926		2706881		2579154		2568204		2599098		2747851
period_id		155		148		149		151		143		144		150		141		153		147		152		142		154		156		151		156		145		146		159		158		157		160		161		162		None		164		165		163		None		163		None		165		164		165		167		None		166		None		168		167		168		168		None		None		None		None		169		170		None		170		None		None		None		None		172		None		171		175		174		None		None		173		None		172		174		175		None		174		None		None		174		176		None		175		175		None		None		None		None		None		None		None		177		None		178		180		181		None		179		None		180		None		None		182		181		183		184		185		186		None		188		187		189		188		190		190		None		None		190		190		193		191		192		190		192		192		None		213		214		215		None		217		217		217		218		218		None		215		219		None		192		193		None		193		None		194		194		None		196		195		192		None		197		197		197		197		None		None		None		None		None		None		198		None		198		197		197		197		197		197		197		199		None		None		201		200		202		203		204		None		204		None		205		206		205		208		207		209		216		210		220		211		None		212		213		217		None		218		None		213		None		245		249		248		247		None		250		None		250		245		245		246		251
form_id		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F690		F690		F625		F625		F625		F625		F625		F625		F625		F625		F605		F625		F601		F625		F601		F625		F605		F625		F625		F625		F625		F625		F625		F605		F601		F625		F601		F625		F625		F605		F605		F625		F625		F625		F625		F601		F605		F625		F601		F625		F601		F605		F625		F601		F625		F605		F605		F625		F625		F625		F601		F601		F625		F601		F605		F605		F601		F625		F625		F601		F625		F605		F605		F625		F605		F625		F605		F605		F625		F625		F625		F601		F601		F625		F625		F625		F625		F602		F601		F625		F625		F625		F625		F625		F625		F605		F601		F625		F625		F625		F601		F625		F601		F605		F601		F601		F601		F625		F601		F625		F601		F601		F605		F625		F625		F601		F605		F601		F625		F625		F601		F625		F605		F625		F625		F605		F625		F601		F605		F625		F605		F601		F625		F605		F601		F625		F625		F601		F602		F602		F601		F625		F605		F605		F605		F605		F605		F605		F601		F605		F625		F601		F601		F601		F601		F601		F601		F625		F602		F605		F625		F625		F625		F625		F601		F601		F625		F602		F602		F625		F625		F625		F625		F625		F625		F625		F625		F625		F605		F625		F601		F625		F605		F601		F602		F625		F601		F625		F625		F625		F625		F601		F601		F605		F625		F625		F601		F625		F625
filing_sequence		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		2		0		1		0		0		0		0		0		0		0		0		3		0		0		0		0		0		0		0		4		0		0		0		0		0		0		3		5		0		1		0		0		2		0		0		6		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		2		3		7		0		4		1		5		6		0		1		0		1		0		4		2		1		3		0		0		0		0		0		0		8		0		0		0		9		0		0		0		0		0		0		0		0		3		0		0		0		0		0		0		0		8		0		0		1		4		5		6		7		2		0		0		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		1		0		0		0		0		1		0		0		0		0		0		0
filing_date		1998-11-02 00:00:00		1997-01-31 00:00:00		1997-04-30 00:00:00		1997-10-31 00:00:00		1995-10-31 00:00:00		1996-01-31 00:00:00		1997-07-31 00:00:00		1995-05-01 00:00:00		1998-04-29 00:00:00		1996-10-31 00:00:00		1998-02-02 00:00:00		1995-07-31 00:00:00		1998-07-30 00:00:00		1999-02-01 00:00:00		1997-11-25 00:00:00		1999-02-01 00:00:00		1996-04-30 00:00:00		1996-07-31 00:00:00		1999-11-01 00:00:00		1999-07-30 00:00:00		1999-04-30 00:00:00		2000-01-28 00:00:00		2000-05-01 00:00:00		2000-07-27 00:00:00		2000-08-25 00:00:00		2001-01-31 00:00:00		2001-01-02 00:00:00		2000-10-31 00:00:00		2001-01-02 00:00:00		2000-10-31 00:00:00		2001-06-27 00:00:00		2001-04-30 00:00:00		2001-01-31 00:00:00		2001-04-30 00:00:00		2001-10-31 00:00:00		2001-07-30 00:00:00		2001-07-30 00:00:00		2001-10-11 00:00:00		2001-11-09 00:00:00		2001-10-30 00:00:00		2001-10-31 00:00:00		2002-01-30 00:00:00		2002-01-28 00:00:00		2001-10-30 00:00:00		2002-05-08 00:00:00		2002-04-29 00:00:00		2002-04-30 00:00:00		2002-07-26 00:00:00		2002-07-22 00:00:00		2002-05-09 00:00:00		2002-07-05 00:00:00		2002-10-30 00:00:00		2002-12-19 00:00:00		2003-01-29 00:00:00		2002-12-30 00:00:00		2003-06-03 00:00:00		2002-10-30 00:00:00		2003-07-28 00:00:00		2003-07-18 00:00:00		2003-09-03 00:00:00		2003-07-18 00:00:00		2003-04-28 00:00:00		2003-04-30 00:00:00		2003-01-30 00:00:00		2003-06-25 00:00:00		2003-08-08 00:00:00		2003-07-18 00:00:00		2003-06-09 00:00:00		2003-08-04 00:00:00		2003-06-13 00:00:00		2003-06-18 00:00:00		2004-01-30 00:00:00		2003-10-31 00:00:00		2003-09-08 00:00:00		2003-10-30 00:00:00		2004-01-30 00:00:00		2004-01-30 00:00:00		2004-01-30 00:00:00		2004-06-07 00:00:00		2004-07-16 00:00:00		2004-07-16 00:00:00		2004-07-16 00:00:00		2004-04-29 00:00:00		2004-04-29 00:00:00		2004-07-14 00:00:00		2004-12-29 00:00:00		2005-01-13 00:00:00		2004-10-28 00:00:00		2004-10-28 00:00:00		2005-01-31 00:00:00		2005-01-31 00:00:00		2005-01-31 00:00:00		2004-12-27 00:00:00		2005-07-27 00:00:00		2005-04-28 00:00:00		2005-10-27 00:00:00		2006-01-27 00:00:00		2006-04-28 00:00:00		2006-07-26 00:00:00		2006-07-05 00:00:00		2006-12-15 00:00:00		2006-10-27 00:00:00		2007-04-25 00:00:00		2007-01-26 00:00:00		2007-06-04 00:00:00		2007-07-30 00:00:00		2007-01-02 00:00:00		2007-06-07 00:00:00		2007-06-06 00:00:00		2007-06-06 00:00:00		2008-01-16 00:00:00		2007-10-31 00:00:00		2007-10-05 00:00:00		2007-11-07 00:00:00		2007-12-07 00:00:00		2007-12-07 00:00:00		2007-12-06 00:00:00		2013-07-27 00:00:00		2013-07-26 00:00:00		2013-07-31 00:00:00		2013-07-31 00:00:00		2014-07-30 00:00:00		2014-07-30 00:00:00		2014-06-26 00:00:00		2014-06-10 00:00:00		2014-07-30 00:00:00		2014-06-10 00:00:00		2013-10-22 00:00:00		2014-10-28 00:00:00		2008-03-17 00:00:00		2008-01-31 00:00:00		2008-03-07 00:00:00		2008-02-01 00:00:00		2008-04-30 00:00:00		2008-05-02 00:00:00		2008-05-21 00:00:00		2008-07-29 00:00:00		2008-06-03 00:00:00		2008-12-19 00:00:00		2008-10-31 00:00:00		2009-01-27 00:00:00		2008-12-19 00:00:00		2009-03-11 00:00:00		2009-03-11 00:00:00		2009-03-18 00:00:00		2009-04-30 00:00:00		2009-03-17 00:00:00		2009-03-17 00:00:00		2009-03-17 00:00:00		2009-03-17 00:00:00		2009-03-17 00:00:00		2009-03-17 00:00:00		2009-06-08 00:00:00		2009-06-08 00:00:00		2009-07-27 00:00:00		2009-03-12 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-10-29 00:00:00		2009-03-10 00:00:00		2009-03-09 00:00:00		2010-04-27 00:00:00		2010-01-27 00:00:00		2010-07-29 00:00:00		2010-10-30 00:00:00		2010-12-17 00:00:00		2010-12-16 00:00:00		2011-01-31 00:00:00		2011-01-24 00:00:00		2011-03-01 00:00:00		2011-07-28 00:00:00		2011-04-27 00:00:00		2012-01-26 00:00:00		2011-10-28 00:00:00		2012-04-24 00:00:00		2014-01-29 00:00:00		2012-07-25 00:00:00		2015-01-23 00:00:00		2012-10-29 00:00:00		2014-07-30 00:00:00		2013-01-25 00:00:00		2013-01-28 00:00:00		2014-04-30 00:00:00		2014-04-04 00:00:00		2014-04-04 00:00:00		2014-03-21 00:00:00		2013-04-23 00:00:00		2013-01-28 00:00:00		2022-03-23 00:00:00		2022-04-29 00:00:00		2022-02-18 00:00:00		2021-10-29 00:00:00		2021-06-04 00:00:00		2022-06-23 00:00:00		2022-06-20 00:00:00		2022-08-01 00:00:00		2021-04-29 00:00:00		2021-03-20 00:00:00		2021-07-29 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		10005		10005		10005		10005		10001		10001		10005		10005		10001		10005		10001		10005		10005		10001		10005		10001		10005		10002		10005		10002		10001		10005		10005		10005		10005		10001		10001		10005		10002		10005		10005		10005		10005		10001		10005		10001		10002		10001		10005		10005		10001		10005		10001		10002		10002		10005		10002		10005		10005		10002		10001		10005		10002		10001		10005		10005		10005		10005		10005		10005		10005		10001		10005		10001		10001		10002		10005		10001		10005		10001		10005		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10002		10001		10005		10005		10002		10002		10002		10001		10002		10002		10002		10002		10005		10002		10001		10002		10006		10002		10002		10002		10002		10001		10006		10001		10001		10005		10001		10002		10005		10001		10005		10002		10001		10005		10001		10001		10001		10001		10001		10001		10002		10001		10006		10006		10006		10006		10006		10006		10002		10006		10001		10002		10002		10002		10002		10002		10002		10001		10005		10006		10001		10001		10001		10001		10001		10005		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10006		10001		10001		10001		10006		10002		10005		10001		10005		10002		10001		10001		10001		10005		10002		10005		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11002		11001		11003		11001		11001		11003		11001		11003		11001		11003		11001		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003		11003		11001		11001		11003		11001		11003		11003		11003		11001		11003		11001		11001		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11001		11003		11001		11003		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003
session_id		1997		1995		1997		1997		1995		1995		1997		1995		1997		1995		1997		1995		1997		1997		1997		1997		1995		1995		1999		1999		1999		1999		1999		1999		1999		1999		2001		1999		2001		1999		2001		2001		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2003		2003		2001		2003		2003		2003		2003		2003		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2007		2005		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2011		2011		2011		2011		2011		2011		2011		2013		2011		2013		2011		2013		2011		2013		2013		2013		2013		2013		2013		2013		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		TTHAM		TTHAM		GPEREZ		*		*		MKIENG		YBONILLA		GKURIMOT		SARRIAGA		*		MHOANG		SARRIAGA		*		CFLAGG		*		SARRIAGA		*		YBONILLA		*		*		YBONILLA		SARRIAGA		SARRIAGA		YBONILLA		*		*		YBONILLA		*		CFLAGG		YBONILLA		SARRIAGA		YBONILLA		COMPLETED		CFLAGG		*		COMPLETED		COMPLETED		SARRIAGA		CFLAGG		COMPLETED		YBONILLA		COMPLETED		COMPLETED		COMPLETED		YBONILLA		COMPLETED		CFLAGG		SARRIAGA		COMPLETED		COMPLETED		YBONILLA		COMPLETED		COMPLETED		SARRIAGA		SARRIAGA		LTHIBAUL		GPEREZ		LTHIBAUL		CFLAGG		CFLAGG		COMPLETED		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		YRODRIGUEZ		COMPLETED		YRODRIGU		COMPLETED		SARRIAGA		SARRIAGA		YRODRIGU		YRODRIGU		YRODRIGU		LTHIBAUL		LTHIBAUL		LTHIBAUL		GPEREZ		*		LTHIBAUL		YRODRIGU		YRODRIGU		*		YRODRIGU		GPEREZ		GPEREZ		*		*		*		YRODRIGU		*		YRODRIGU		*		*		GPEREZ		ASAETERN		ASAETERN		PBANFORD		PBANFORD		YRODRIGU		ASAETERN		ASAETERN		PBANFORD		ASAETERN		PBANFORD		ASAETERN		ASAETERN		CFLAGG		LTHIBAUL		*		GPEREZ		YRODRIGU		YRODRIGU		YRODRIGU		LTHIBAUL		YRODRIGU		YRODRIGU		MGUERRA		MGUERRA		DMCCASTL		YRODRIGU		YRODRIGU		YRODRIGU		MGUERRA		PBANFORD		PBANFORD		PBANFORD		PBANFORD		PBANFORD		PBANFORD		YRODRIGU		YRODRIGU		MGUERRA		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		MGUERRA		YRODRIGU		YRODRIGU		MGUERRA		MGUERRA		ASAETERN		ASAETERN		YRODRIGU		DMCCASTL		ASAETERN		SARRIAGA		YRODRIGU		ASAETERN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		JINGRAM		AGLADNEY		ASAETERN		YRODRIGU		ASAETERN		PBANFORD		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		PBANFORD		CAFILER		CAFILER		CHATRIDGE		CHATRIDGE		MKIRKHAM		SARRIAGA		SARRIAGA		CAFILER		MKIRKHAM		MKIRKHAM		MKIRKHAM		CAFILER
special_audit		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		11002		11003		11003		11002		11003		11003		11002		11003		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
fine_audit		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11001		11003		11001		11003
rpt_start		1998-07-01 00:00:00		1996-10-01 00:00:00		1997-01-01 00:00:00		1997-07-01 00:00:00		1995-07-01 00:00:00		1995-10-01 00:00:00		1997-04-01 00:00:00		1995-01-01 00:00:00		1998-01-01 00:00:00		1996-07-01 00:00:00		1997-10-01 00:00:00		1995-04-01 00:00:00		1998-04-01 00:00:00		1998-10-01 00:00:00		1997-07-01 00:00:00		1998-10-01 00:00:00		1996-01-01 00:00:00		1996-04-01 00:00:00		1999-07-01 00:00:00		1999-04-01 00:00:00		1999-01-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-04-01 00:00:00		None		2000-10-01 00:00:00		2001-01-02 00:00:00		2000-07-01 00:00:00		1900-01-01 00:00:00		2000-07-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		2000-10-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		1900-01-01 00:00:00		2001-11-09 00:00:00		2001-07-01 00:00:00		2001-10-31 00:00:00		2001-10-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		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-04-01 00:00:00		2002-05-09 00:00:00		1900-01-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		2002-10-01 00:00:00		2002-12-30 00:00:00		1900-01-01 00:00:00		2002-07-01 00:00:00		2003-07-28 00:00:00		2003-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2002-10-01 00:00:00		2003-06-25 00:00:00		2003-08-08 00:00:00		2003-04-01 00:00:00		2003-06-09 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-06-18 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2003-09-08 00:00:00		2003-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-10-01 00:00:00		1900-01-01 00:00:00		2004-04-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-12-29 00:00:00		2005-01-13 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		1900-01-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		2005-10-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		1900-01-01 00:00:00		2006-12-15 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		2006-10-01 00:00:00		2007-06-04 00:00:00		2007-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-06-06 00:00:00		2007-06-06 00:00:00		2008-01-16 00:00:00		2007-07-01 00:00:00		2007-10-05 00:00:00		2007-04-01 00:00:00		2007-12-07 00:00:00		2007-12-07 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		2013-04-01 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		2014-03-07 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2014-04-18 00:00:00		2014-04-01 00:00:00		1900-01-01 00:00:00		2013-07-01 00:00:00		2014-07-01 00:00:00		1900-01-01 00:00:00		2007-10-01 00:00:00		2008-03-07 00:00:00		1900-01-01 00:00:00		2008-01-01 00:00:00		1900-01-01 00:00:00		2008-05-21 00:00:00		2008-04-01 00:00:00		1900-01-01 00:00:00		2008-12-19 00:00:00		2008-07-01 00:00:00		2007-10-01 00:00:00		1900-01-01 00:00:00		2009-03-11 00:00:00		2009-03-11 00:00:00		2009-03-18 00:00:00		2009-01-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		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-06-08 00:00:00		1900-01-01 00:00:00		2009-04-01 00:00:00		2009-03-12 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-12-17 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		1900-01-01 00:00:00		2011-03-01 00:00:00		2011-04-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		2013-10-01 00:00:00		2012-04-01 00:00:00		2014-10-01 00:00:00		2012-07-01 00:00:00		1900-01-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2014-01-01 00:00:00		1900-01-01 00:00:00		2014-04-04 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		1900-01-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2021-10-01 00:00:00		2021-07-01 00:00:00		1900-01-01 00:00:00		2022-06-23 00:00:00		1900-01-01 00:00:00		2022-04-01 00:00:00		2021-01-01 00:00:00		2021-03-20 00:00:00		2021-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		1998-09-30 00:00:00		1996-12-31 00:00:00		1997-03-31 00:00:00		1997-09-30 00:00:00		1995-09-30 00:00:00		1995-12-31 00:00:00		1997-06-30 00:00:00		1995-03-31 00:00:00		1998-03-31 00:00:00		1996-09-30 00:00:00		1997-12-31 00:00:00		1995-06-30 00:00:00		1998-06-30 00:00:00		1998-12-31 00:00:00		1997-09-30 00:00:00		1998-12-31 00:00:00		1996-03-31 00:00:00		1996-06-30 00:00:00		1999-09-30 00:00:00		1999-06-30 00:00:00		1999-03-31 00:00:00		1999-12-31 00:00:00		2000-03-31 00:00:00		2000-06-30 00:00:00		None		2000-12-31 00:00:00		2001-01-02 00:00:00		2000-09-30 00:00:00		1900-01-01 00:00:00		2000-09-30 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		1900-01-01 00:00:00		2001-11-09 00:00:00		2001-09-30 00:00:00		2001-10-31 00:00:00		2001-12-31 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		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-05-09 00:00:00		1900-01-01 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		2002-12-31 00:00:00		2002-12-30 00:00:00		1900-01-01 00:00:00		2002-09-30 00:00:00		2003-07-28 00:00:00		2003-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2003-03-31 00:00:00		2002-12-31 00:00:00		2003-06-25 00:00:00		2003-08-08 00:00:00		2003-06-30 00:00:00		2003-06-09 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-06-18 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2003-09-08 00:00:00		2003-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2003-12-31 00:00:00		1900-01-01 00:00:00		2004-06-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-12-29 00:00:00		2005-01-13 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		1900-01-01 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		2005-12-31 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		1900-01-01 00:00:00		2006-12-15 00:00:00		2006-09-30 00:00:00		2007-03-31 00:00:00		2006-12-31 00:00:00		2007-06-04 00:00:00		2007-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-06-06 00:00:00		2007-06-06 00:00:00		2008-01-16 00:00:00		2007-09-30 00:00:00		2007-10-05 00:00:00		2007-06-30 00:00:00		2007-12-07 00:00:00		2007-12-07 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		2013-06-30 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		2014-03-07 00:00:00		2014-03-31 00:00:00		2014-03-31 00:00:00		2014-04-18 00:00:00		2014-06-30 00:00:00		1900-01-01 00:00:00		2013-09-30 00:00:00		2014-09-30 00:00:00		1900-01-01 00:00:00		2007-12-31 00:00:00		2008-03-07 00:00:00		1900-01-01 00:00:00		2008-03-31 00:00:00		1900-01-01 00:00:00		2008-05-21 00:00:00		2008-06-30 00:00:00		1900-01-01 00:00:00		2008-12-19 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		2009-03-11 00:00:00		2009-03-11 00:00:00		2009-03-18 00:00:00		2009-03-31 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		1900-01-01 00:00:00		1900-01-01 00:00:00		2009-06-08 00:00:00		1900-01-01 00:00:00		2009-06-30 00:00:00		2009-03-12 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-17 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		1900-01-01 00:00:00		2011-03-01 00:00:00		2011-06-30 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2012-03-31 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2014-12-31 00:00:00		2012-09-30 00:00:00		1900-01-01 00:00:00		2012-12-31 00:00:00		2013-01-01 00:00:00		2014-03-31 00:00:00		1900-01-01 00:00:00		2014-04-04 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		1900-01-01 00:00:00		2021-03-31 00:00:00		2022-03-31 00:00:00		2021-12-31 00:00:00		2021-09-30 00:00:00		1900-01-01 00:00:00		2022-06-23 00:00:00		1900-01-01 00:00:00		2022-06-30 00:00:00		2021-03-31 00:00:00		2021-03-20 00:00:00		2021-06-30 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
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		22001		22006		None		None		22006		None		22001		22001		22001		None		22001		None		None		22001		22006		None		22001		22006		None		None		None		None		None		None		None		22006		None		22006		22001		22001		None		22006		None		22006		None		None		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		None		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22001		22001		22001		None		22001		22001		22001		22001		22001		None		22001		22001		None		22006		22006		None		22006		None		22006		22006		None		22006		22006		22006		None		22001		22001		22001		22001		None		None		None		None		None		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		None		22001		None		22006		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006

Table: filer_to_filer_type

filer_id		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260
filer_type		3		3		3		3		3		3		3		3		3		3		3		3
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		0		0		0		None		None		None		None		None		None		None		None
session_id		1997		1995		1999		2001		2003		2005		2011		2013		2007		2009		2021		2023
category		0		0		0		0		None		None		None		None		None		None		None		None
category_type		0		0		0		0		None		None		None		None		None		None		None		None
sub_category		0		0		0		0		None		None		None		None		None		None		None		None
effect_dt		1997-01-01 00:00:00		1995-01-01 00:00:00		1999-01-01 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2021-03-10 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		0		None		None		None		None		None		None		None		None
election_type		0		0		0		0		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		2000-07-01 00:00:00		None		None		2000-07-01 00:00:00		None		None		None
party_cd		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
district_cd		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1147260
xref_id		F00602
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602		F00602
filer_id		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260
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
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
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
naml		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE		ORRICK, HERRINGTON & SUTCLIFFE		ORRICK, HERRINGTON & SUTCLIFFE		ORRICK, HERRINGTON & SUTCLIFFE		ORRICK, HERRINGTON & SUTCLIFFE		ORRICK, HERRINGTON & SUTCLIFFE		ORRICK, HERRINGTON & SUTCLIFFE		ORRICK, HERRINGTON & SUTCLIFFE		ORRICK, HERRINGTON & SUTCLIFFE		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP
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
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
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
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
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
city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		WASHINGTON		WASHINGTON		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		WASHINGTON		WASHINGTON		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		WASHINGTON		WASHINGTON		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		WASHINGTON		WASHINGTON		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		WASHINGTON		WASHINGTON		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		WASHINGTON		WASHINGTON		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		WASHINGTON		WASHINGTON		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		WASHINGTON		WASHINGTON		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		WASHINGTON		WASHINGTON		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		WASHINGTON		WASHINGTON		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		WASHINGTON		WASHINGTON
st		CA		CA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		CA		DC		DC
zip4		95814		95814		95814		95814		95814		95814		95814		20005		20005		95814		95814		95814		95814		95814		95814		95814		20005		20005		95814		95814		95814		95814		95814		95814		95814		20005		20005		95814		95814		95814		95814		95814		95814		95814		20005		20005		95814		95814		95814		95814		95814		95814		95814		20005		20005		95814		95814		95814		95814		95814		95814		95814		20005		20005		95814		95814		95814		95814		95814		95814		95814		20005		20005		95814		95814		95814		95814		95814		95814		95814		20005		20005		95814		95814		95814		95814		95814		95814		95814		20005		20005		95814		95814		95814		95814		95814		95814		95814		20005		20005		95814		95814		95814		95814		95814		95814		95814		20005		20005
phon		9164479200		9163297953		9163297953		9163297953		9163297953		9164479200		9164479200		2028499002		2028499002		9164479200		9163297953		9163297953		9163297953		9163297953		9164479200		9164479200		2028499002		2028499002		9164479200		9163297953		9163297953		9163297953		9163297953		9164479200		9164479200		2028499002		2028499002		9164479200		9163297953		9163297953		9163297953		9163297953		9164479200		9164479200		2028499002		2028499002		9164479200		9163297953		9163297953		9163297953		9163297953		9164479200		9164479200		2028499002		2028499002		9164479200		9163297953		9163297953		9163297953		9163297953		9164479200		9164479200		2028499002		2028499002		9164479200		9163297953		9163297953		9163297953		9163297953		9164479200		9164479200		2028499002		2028499002		9164479200		9163297953		9163297953		9163297953		9163297953		9164479200		9164479200		2028499002		2028499002		9164479200		9163297953		9163297953		9163297953		9163297953		9164479200		9164479200		2028499002		2028499002		9164479200		9163297953		9163297953		9163297953		9163297953		9164479200		9164479200		2028499002		2028499002		9164479200		9163297953		9163297953		9163297953		9163297953		9164479200		9164479200		2028499002		2028499002
fax		None		9163294900		9163294900		9163294900		9163294900		9163294900		9163294900						None		9163294900		9163294900		9163294900		9163294900		9163294900		9163294900						None		9163294900		9163294900		9163294900		9163294900		9163294900		9163294900						None		9163294900		9163294900		9163294900		9163294900		9163294900		9163294900						None		9163294900		9163294900		9163294900		9163294900		9163294900		9163294900						None		9163294900		9163294900		9163294900		9163294900		9163294900		9163294900						None		9163294900		9163294900		9163294900		9163294900		9163294900		9163294900						None		9163294900		9163294900		9163294900		9163294900		9163294900		9163294900						None		9163294900		9163294900		9163294900		9163294900		9163294900		9163294900						None		9163294900		9163294900		9163294900		9163294900		9163294900		9163294900						None		9163294900		9163294900		9163294900		9163294900		9163294900		9163294900
email		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		None		None		[email protected]		[email protected]

Table: filers

filer_id		1147260

Table: lobbying_chg_log

filer_id		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260
change_no		1		2		3		6		4		5		9		8		7		10		0		16		11		12		17		13		14		15		19		18		20		21		22		25		26		23		24		31		32		33		27		28		29		30		35		36		34		38		37
session_id		1999		1999		1999		1999		1999		2001		1999		1999		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2007		2007		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2013		2013		2013		2013		2013
log_dt		2000-08-25 00:00:00		2000-11-04 00:00:00		2000-12-05 00:00:00		2001-05-30 00:00:00		2001-05-14 00:00:00		2001-05-14 00:00:00		2002-07-05 00:00:00		2001-06-27 00:00:00		2001-10-11 00:00:00		2002-05-08 00:00:00		2003-06-13 00:00:00		2004-06-07 00:00:00		2003-08-04 00:00:00		2004-01-30 00:00:00		2004-07-16 00:00:00		2003-06-03 00:00:00		2003-09-03 00:00:00		2003-07-18 00:00:00		2006-07-05 00:00:00		2005-01-31 00:00:00		2007-12-06 00:00:00		2007-06-07 00:00:00		2007-12-06 00:00:00		2008-05-02 00:00:00		2008-06-03 00:00:00		2008-02-01 00:00:00		2008-03-17 00:00:00		2009-03-17 00:00:00		2009-03-17 00:00:00		2009-03-09 00:00:00		2009-03-17 00:00:00		2009-03-17 00:00:00		2009-03-17 00:00:00		2009-03-17 00:00:00		2013-01-28 00:00:00		2013-01-28 00:00:00		2013-01-28 00:00:00		2014-06-10 00:00:00		2014-04-04 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
correction_flg		Y		None		None		None		None		None		Y		Y		Y		Y		Y		None		Y		None		None		Y		Y		Y		None		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		None
action		ADDED		CHANGED		CHANGED		CHANGED		CHANGED		ADDED		DELETED		DELETED		ADDED		ADDED		NEW		DELETED		ADDED		DELETED		DELETED		ADDED		NEW		NEW		DELETED		ADDED		DELETED		ADDED		ADDED		DELETED		ADDED		ADDED		DELETED		DELETED		DELETED		DELETED		DELETED		DELETED		DELETED		DELETED		ADDED		ADDED		ADDED		DELETED		ADDED
attribute_changed		CLIENT		NAME		NAME		None		PHONE		ETHICS		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		None		CLIENT		None		CLIENT		CLIENT		None		None		None		CLIENT		None		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		FIRM		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		LOBBYIST		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		LOBBYIST		EMPLOYER		CLIENT
ethics_dt		None		None		None		None		None		2001-01-18 00:00:00		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK, HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP		ORRICK HERRINGTON & SUTCLIFFE, LLP
filer_city		None		None		None		None		None		None		None		SACRAMENTO		None		SACRAMENTO		None		None		None		None		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		None		None		SACRAMENTO		None		None		None		None		None		None		None		None		SACRAMENTO		SACRAMENTO		None		None		None
filer_st		None		None		None		None		None		None		None		CA		None		CA		None		None		None		None		None		CA		CA		CA		None		CA		None		CA		CA		None		None		CA		None		None		None		None		None		None		None		None		CA		CA		None		None		None
filer_zip		None		None		None		None		None		None		None		95814		None		95814		None		None		None		None		None		95814		95814		95814		None		95814		None		95814		95814		None		None		95814		None		None		None		None		None		None		None		None		95814		95814		None		None		None
filer_phone		None		None		None		None		None		None		None		9164479200		None		9164479200		None		None		None		None		None		9164479200		9164479200		9164479200		None		9164479200		None		9164479200		9164479200		None		None		9164479200		None		None		None		None		None		None		None		None		9164479200		9164479200		None		None		None
entity_type		1		2		2		4		4		4		2		2		2		2		2		1		2		1		1		2		2		2		1		2		2		2		2		2		3		2		2		2		2		4		2		2		2		2		2		2		4		2		1
entity_name		DEL NORTE, COUNTY OF		GTE CALIFORNIA INC.		VERIZON		JAMES W. BRUNER JR.		JAMES W. BRUNER JR.		JAMES W. BRUNER JR.		VERIZON COMMUNICATIONS INC.- CALIFORNIA		PITTSBURG POWER COMPANY		PITTSBURG, CITY OF		THE PROCTER & GAMBLE DISTRIBUTING COMPANY		TRANSAMERICA CORPORATION		DEWEY SQUARE GROUP		DEWEY SQUARE GROUP		SANTA BARBARA, THE REDEVELOPMENT AGENCY OF THE CITY OF		MARSHALL NAIFY REVOCABLE TRUST		PROCTER & GAMBLE DISTRIBUTING COMPANY		REDEVELOPMENT AGENCY OF THE CITY OF SANTA BARBARA, THE		MARSHALL NAIFY REVOCABLE TRUST		TRANSAMERICA CORPORATION		NATIONAL ASSOCIATION OF SECURITIES DEALERS		AFFILIATED COMPUTER SERVICES, INC.		AFFILIATED COMPUTER SERVICES, INC		AFFILIATED COMPUTER SERVICES, INC AND OTHER SUBSIDIARIES INCLUDING ACS STATE AND LOCAL SOLUTIONS, INC.		FINANCIAL INDUSTRY REGULATORY AUTHORITY		DISCOVER FINANCIAL SERVICES		HALF MOON BAY; CITY OF		PROCTER & GAMBLE		NASDAQ STOCK MARKET; THE		SECURITIES INDUSTRY AND FINANCIAL MARKETS ASSOCIATION		BETTENCOURT; JOANNE M.		COUNCIL OF UC FACULTY ASSOCIATIONS		HALF MOON BAY; CITY OF		DISCOVER FINANCIAL SERVICES		INVESTMENT COMPANY INSTITUTE		MORGAN STANLEY & CO, INCORPORATED		ORRICK HERRINGTON & SUTCLIFFE, LLP		BRUNER, JAMES W.		CALIFORNIA EARTHQUAKE AUTHORITY		CALIFORNIA EARTHQUAKE AUTHORITY
entity_city		None		None		None		SACRAMENTO		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
entity_st		None		None		None		CA		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
entity_zip		None		None		None		95814		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
entity_phone		None		None		None		9163297901		9163297901		None		None		None		None		None		None		None		None		None		None		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		1143674		1146823		1146823		1147812		1147812		1147812		1146823		None		1143368		None		1255622		1244123		1244123		1258210		1256345		None		None		None		1255622		None		1298874		None		None		1144544		1303261		None		1144084		1251307		1143423		1232024		1142939		1303359		1303261		1145653		None		None		0		1244186		1244186
responsible_officer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		1999-12-31 00:00:00		1999-12-31 00:00:00		2001-09-17 00:00:00		2002-04-23 00:00:00		2003-06-11 00:00:00		2004-05-26 00:00:00		2003-07-31 00:00:00		2004-01-12 00:00:00		2004-06-28 00:00:00		2003-06-01 00:00:00		2003-08-27 00:00:00		2003-07-14 00:00:00		2006-04-01 00:00:00		2005-01-14 00:00:00		2007-10-01 00:00:00		2007-06-06 00:00:00		2007-10-01 00:00:00		2008-04-23 00:00:00		2008-05-23 00:00:00		2008-01-15 00:00:00		2008-03-01 00:00:00		2009-03-06 00:00:00		2009-03-06 00:00:00		2009-03-06 00:00:00		2009-03-06 00:00:00		2009-03-06 00:00:00		2009-05-15 00:00:00		2009-03-06 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2014-04-17 00:00:00		2014-03-07 00:00:00

Table: lobbyist_contributions1

filer_id		1147260		1147260
filing_period_start_dt		2001-01-01 00:00:00		2001-01-01 00:00:00
filing_period_end_dt		2001-03-31 00:00:00		2001-03-31 00:00:00
contribution_dt		None		None
recipient_name		FRIENDS OF PHILIP ANGELIDES/STATE TREASURER		CLAUDE PARRISH S.B.E. CAMPAIGN COMMITTEE
recipient_id		1070477		1070573
amount		500		249

Table: lobbyist_contributions2

filer_id		1147260		1147260
filing_period_start_dt		2001-01-01 00:00:00		2001-01-01 00:00:00
filing_period_end_dt		2001-03-31 00:00:00		2001-03-31 00:00:00
contribution_dt		None		None
recipient_name		FRIENDS OF PHILIP ANGELIDES/STATE TREASURER		CLAUDE PARRISH S.B.E. CAMPAIGN COMMITTEE
recipient_id		1070477		1070573
amount		500		249

Table: received_filings

filer_id		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260		1147260
filing_file_name		682709_0.cal		704556_0.cal		719557_0.cal		746618_0.cal		771885_0.cal		704556_2.cal		704556_1.cal		792340_0.cal		813188_0.cal		839263_0.cal		406962.cal		407164.cal		704556_3.cal		852159_0.cal		898600_0.cal		270107.cal		883856_0.cal		910638_0.cal		898600_2.cal		898600_1.cal		929632_0.cal		942866_0.cal		898600_3.cal		15347.cal		898600_5.cal		898600_4.cal		898600_6.cal		968939_0.cal		1068379_1.cal		1068379_0.cal		1505183_0.cal		1384662_1.cal		1384662_2.cal		1461746_0.cal		1482741_0.cal		1451199_0.cal		1223589_0.cal		1223589_3.cal		1223589_2.cal		1223589_7.cal		1223589_1.cal		1433902_0.cal		1384662_8.cal		1223589_5.cal		1223589_6.cal		1223589_4.cal		1384662_0.cal		1223589_9.cal		1223589_8.cal		1384662_3.cal		1384662_4.cal		1384662_5.cal		56527.cal		56475.cal		1384662_6.cal		1384662_7.cal		1844888_0.cal		1732702_0.cal		1734060_0.cal		1734060_1.cal		1796244_0.cal		1551366_0.cal		89019.cal		89631.cal		89713.cal		89655.cal		92562.cal		92637.cal		1539557_0.cal		1589017_0.cal		1572703_0.cal		1620807_0.cal		1815372_0.cal		1605088_0.cal		144672.cal		1778910_0.cal		1760989_1.cal		1760989_0.cal		1632081_0.cal		1706940_0.cal		1654309_0.cal		1674584_0.cal		1734060_4.cal		1844888_2.cal		1870345_0.cal		1844888_1.cal		1734060_3.cal		1734060_2.cal		1906966_0.cal		1929239_0.cal		2568204_1.cal		2568204_0.cal
received_date		2000-10-31 00:00:00		2001-01-02 00:00:00		2001-01-31 00:00:00		2001-04-30 00:00:00		2001-07-30 00:00:00		2001-11-09 00:00:00		2001-10-31 00:00:00		2001-10-31 00:00:00		2002-01-30 00:00:00		2002-04-30 00:00:00		2002-05-09 00:00:00		2002-05-09 00:00:00		2002-05-09 00:00:00		2002-07-26 00:00:00		2002-12-30 00:00:00		2002-12-30 00:00:00		2002-10-30 00:00:00		2003-01-30 00:00:00		2003-06-18 00:00:00		2003-06-09 00:00:00		2003-04-28 00:00:00		2003-07-18 00:00:00		2003-06-25 00:00:00		2003-08-08 00:00:00		2003-08-08 00:00:00		2003-07-28 00:00:00		2003-09-08 00:00:00		2003-10-30 00:00:00		2005-01-13 00:00:00		2004-12-29 00:00:00		2010-07-29 00:00:00		2009-03-12 00:00:00		2009-03-18 00:00:00		2010-01-27 00:00:00		2010-04-27 00:00:00		2009-10-29 00:00:00		2006-12-15 00:00:00		2007-06-06 00:00:00		2007-06-06 00:00:00		2008-01-16 00:00:00		2007-06-04 00:00:00		2009-07-27 00:00:00		2009-06-08 00:00:00		2007-12-07 00:00:00		2007-12-07 00:00:00		2007-10-05 00:00:00		2008-12-19 00:00:00		2008-05-21 00:00:00		2008-03-07 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2009-03-18 00:00:00		2014-04-30 00:00:00		2013-01-25 00:00:00		2013-01-28 00:00:00		2013-07-31 00:00:00		2013-10-22 00:00:00		2010-12-17 00:00:00		2010-12-17 00:00:00		2010-12-17 00:00:00		2010-12-17 00:00:00		2010-12-17 00:00:00		2010-12-17 00:00:00		2010-12-17 00:00:00		2010-10-30 00:00:00		2011-04-27 00:00:00		2011-01-31 00:00:00		2011-10-28 00:00:00		2014-01-29 00:00:00		2011-07-28 00:00:00		2013-04-23 00:00:00		2013-07-26 00:00:00		2013-07-27 00:00:00		2013-04-23 00:00:00		2012-01-26 00:00:00		2012-10-29 00:00:00		2012-04-24 00:00:00		2012-07-25 00:00:00		2014-07-30 00:00:00		2014-07-30 00:00:00		2014-07-30 00:00:00		2014-06-26 00:00:00		2014-06-10 00:00:00		2014-04-04 00:00:00		2014-10-28 00:00:00		2015-01-23 00:00:00		2022-06-23 00:00:00		2021-03-20 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/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/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/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/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		682709		704556		719557		746618		771885		704556		704556		792340		813188		839263		None		None		704556		852159		898600		None		883856		910638		898600		898600		929632		942866		898600		None		898600		898600		898600		968939		1068379		1068379		1505183		1384662		1384662		1461746		1482741		1451199		1223589		1223589		1223589		1223589		1223589		1433902		1384662		1223589		1223589		1223589		1384662		1223589		1223589		1384662		1384662		1384662		None		None		1384662		1384662		1844888		1732702		1734060		1734060		1796244		1551366		None		None		None		None		None		None		1539557		1589017		1572703		1620807		1815372		1605088		None		1778910		1760989		1760989		1632081		1706940		1654309		1674584		1734060		1844888		1870345		1844888		1734060		1734060		1906966		1929239		2568204		2568204
form_id		F625		F601		F625		F625		F625		F601		F601		F625		F625		F625		None		None		F601		F625		F601		None		F625		F625		F601		F601		F625		F625		F601		None		F601		F601		F601		F625		F601		F601		F625		F601		F601		F625		F625		F625		F601		F601		F601		F601		F601		F625		F601		F601		F601		F601		F601		F601		F601		F601		F601		F601		None		None		F601		F601		F625		F625		F601		F601		F625		F601		None		None		None		None		None		None		F625		F625		F625		F625		F625		F625		None		F625		F625		F625		F625		F625		F625		F625		F601		F625		F625		F625		F601		F601		F625		F625		F601		F601
receive_comment		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing 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 accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted