Home

Filer ID: 1143662

Table: filer_address

filer_id		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662
adrid		1108063		2045420		2080388		2116424		2164906		2207072		2516734		2417849		2553240		2279050		2338696		2468277
effect_dt		1999-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2021-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2019-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1999		2003		2005		2007		2009		2011		2021		2017		2023		2013		2015		2019

Table: filer_filings

filer_id		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662
filing_id		466020		470043		484668		481126		464893		473376		488283		489662		478927		491989		485975		493375		467878		478927		495655		495655		496987		475558		476827		495655		482384		471273		624405		635845		644002		631699		618477		649526		678533		715355		712896		696612		729796		758360		744164		769777		790651		777527		812620		794839		843970		838397		821965		849864		852333		877029		890773		905567		905497		908449		928976		924583		933683		943556		923935		954613		971131		968678		994271		1015960		1011560		985717		1024982		1024982		1028880		1074647		1039304		1098599		1056200		1076959		1101191		1064950		1088407		1112906		1129823		1142817		1166171		1189034		1208738		1230207		1256929		1255725		1254174		1280484		1246029		1262824		1294487		1777804		1978009		1868648		1961434		1954785		1906954		1305039		1344137		1326851		1364938		1390660		1384446		1411901		1431414		1419182		1450859		1458324		1458324		1431414		1483675		1483675		1501553		1483675		1536907		1556132		1562224		1569106		1619781		1588175		1632858		1588175		1601116		1653817		1677676		1796636		1814603		1930505		1716860		1706653		1733829		1841205		1746229		1764692		1994187		2577727		2468989		2338168		2364124		2008019		2036320		2057928		2097876		2123581		2155854		2133054		2168262		2379003		2275616		2391350		2312555		2524991		2437856		2192079		2572978		2342105		2546781		2333619		2234191		2207767		2416454		2481290		2636644		2577727		2618678		2700723		2596634		2670203		2739751
period_id		149		142		145		144		141		158		146		154		159		147		153		155		157		159		148		148		156		143		151		148		152		150		161		None		162		None		160		162		163		164		None		163		164		165		165		166		167		None		168		None		None		169		None		170		None		171		None		None		172		None		173		None		None		174		173		None		None		175		None		None		177		176		178		178		None		180		None		181		179		None		181		None		None		182		183		184		185		186		187		188		189		None		189		190		None		None		191		214		222		218		221		None		219		192		194		193		195		196		196		None		198		197		199		200		200		198		201		201		202		201		203		204		None		204		207		205		208		205		206		209		210		215		216		220		212		211		212		217		None		213		223		245		241		None		None		224		225		226		227		228		229		None		230		237		234		238		235		243		240		231		None		236		244		237		233		232		239		242		248		245		247		250		246		249		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F690		F690		F635		F635		F635		F635		F635		F635		F635		F999		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F690		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F602		F602		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		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		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		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		1		0		2		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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
filing_date		1997-04-28 00:00:00		1995-07-24 00:00:00		1996-04-29 00:00:00		1996-01-26 00:00:00		1995-04-27 00:00:00		1999-07-28 00:00:00		1996-07-15 00:00:00		1998-07-28 00:00:00		1999-10-28 00:00:00		1996-10-30 00:00:00		1998-04-27 00:00:00		1998-11-02 00:00:00		1999-04-30 00:00:00		1999-11-01 00:00:00		1997-01-31 00:00:00		1997-03-21 00:00:00		1999-01-20 00:00:00		1995-10-30 00:00:00		1997-10-20 00:00:00		1997-01-27 00:00:00		1998-01-29 00:00:00		1997-07-21 00:00:00		2000-05-01 00:00:00		2000-04-26 00:00:00		2000-07-28 00:00:00		2000-05-01 00:00:00		2000-01-31 00:00:00		2000-07-27 00:00:00		2000-10-27 00:00:00		2001-01-26 00:00:00		2001-01-02 00:00:00		2000-10-20 00:00:00		2001-01-30 00:00:00		2001-04-30 00:00:00		2001-04-26 00:00:00		2001-07-25 00:00:00		2001-10-30 00:00:00		2001-07-30 00:00:00		2002-01-30 00:00:00		2001-10-30 00:00:00		2002-04-30 00:00:00		2002-04-29 00:00:00		2002-01-31 00:00:00		2002-07-16 00:00:00		2002-07-18 00:00:00		2002-10-23 00:00:00		2002-10-28 00:00:00		2002-12-31 00:00:00		2003-01-23 00:00:00		2003-01-28 00:00:00		2003-04-25 00:00:00		2003-03-06 00:00:00		2003-04-28 00:00:00		2003-07-22 00:00:00		2003-03-06 00:00:00		2003-07-24 00:00:00		2003-10-31 00:00:00		2003-10-29 00:00:00		2004-01-29 00:00:00		2004-04-30 00:00:00		2004-04-27 00:00:00		2004-01-23 00:00:00		2004-08-05 00:00:00		2004-07-22 00:00:00		2004-07-27 00:00:00		2005-01-24 00:00:00		2004-08-06 00:00:00		2005-03-30 00:00:00		2004-10-28 00:00:00		2004-12-30 00:00:00		2005-04-19 00:00:00		2004-10-29 00:00:00		2005-01-26 00:00:00		2005-07-20 00:00:00		2005-10-24 00:00:00		2006-01-20 00:00:00		2006-04-28 00:00:00		2006-07-28 00:00:00		2006-10-18 00:00:00		2007-01-23 00:00:00		2007-04-16 00:00:00		2007-03-20 00:00:00		2007-03-20 00:00:00		2007-07-25 00:00:00		2007-01-02 00:00:00		2007-02-23 00:00:00		2007-10-24 00:00:00		2013-07-24 00:00:00		2015-07-27 00:00:00		2014-07-29 00:00:00		2015-04-24 00:00:00		2015-01-20 00:00:00		2014-10-28 00:00:00		2008-01-22 00:00:00		2008-07-18 00:00:00		2008-04-24 00:00:00		2008-10-09 00:00:00		2009-01-21 00:00:00		2008-12-18 00:00:00		2008-12-23 00:00:00		2009-07-16 00:00:00		2009-04-28 00:00:00		2009-10-28 00:00:00		2010-01-19 00:00:00		2010-01-27 00:00:00		2009-07-17 00:00:00		2010-04-28 00:00:00		2010-04-30 00:00:00		2010-07-20 00:00:00		2010-07-20 00:00:00		2010-10-27 00:00:00		2010-12-30 00:00:00		2010-12-28 00:00:00		2011-01-28 00:00:00		2011-10-26 00:00:00		2011-04-25 00:00:00		2012-01-27 00:00:00		2011-07-19 00:00:00		2011-07-19 00:00:00		2012-04-23 00:00:00		2012-07-30 00:00:00		2013-10-23 00:00:00		2014-01-28 00:00:00		2015-01-27 00:00:00		2012-12-11 00:00:00		2012-10-29 00:00:00		2013-01-28 00:00:00		2014-04-24 00:00:00		2012-12-28 00:00:00		2013-04-30 00:00:00		2015-10-26 00:00:00		2021-04-27 00:00:00		2020-04-29 00:00:00		2018-12-19 00:00:00		2019-01-15 00:00:00		2016-01-27 00:00:00		2016-04-29 00:00:00		2016-07-25 00:00:00		2016-10-27 00:00:00		2017-01-25 00:00:00		2017-04-28 00:00:00		2016-12-21 00:00:00		2017-07-18 00:00:00		2019-04-29 00:00:00		2018-07-31 00:00:00		2019-07-19 00:00:00		2018-10-25 00:00:00		2020-10-28 00:00:00		2020-01-29 00:00:00		2017-10-30 00:00:00		2020-12-30 00:00:00		2019-01-28 00:00:00		2021-01-25 00:00:00		2019-01-10 00:00:00		2018-04-23 00:00:00		2018-01-29 00:00:00		2019-10-28 00:00:00		2020-07-27 00:00:00		2022-01-24 00:00:00		2021-07-26 00:00:00		2021-10-25 00:00:00		2022-07-25 00:00:00		2021-07-26 00:00:00		2022-04-25 00:00:00		2022-10-24 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		10005		10001		10005		10005		10005		10001		10001		10005		10005		10005		10005		10001		10001		10001		10005		10001		10005		10005		10001		10005		10001		10005		10001		10005		10005		10001		10005		10001		10005		10005		10001		10001		10005		10005		10001		10005		10005		10001		10001		10002		10001		10005		10001		10006		10001		10001		10005		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10005		10005		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10002		10002		10001		10002		10001		10002		10001		10001		10005		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10002		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		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11001		11003		11001		11001		11003		11001		11003		11001		11001		11003		11003		11001		11001		11003		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		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		11003		11001		11003		11003
session_id		1997		1995		1995		1995		1995		1999		1995		1997		1999		1995		1997		1997		1999		1999		1995		1995		1997		1995		1997		1995		1997		1997		1999		1999		1999		1999		1999		1999		1999		1999		2001		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2005		2005		2003		2003		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2007		2007		2007		2007		2013		2015		2013		2015		2015		2013		2007		2007		2007		2007		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2011		2011		2013		2013		2013		2015		2021		2019		2019		2019		2015		2015		2015		2015		2015		2017		2017		2017		2019		2017		2019		2017		2019		2019		2017		2021		2017		2019		2019		2017		2017		2019		2019		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		CFLAGG		TTHAM		*		KCHAN		*		YBONILLA		*		*		NJACKSON		YBONILLA		YBONILLA		YBONILLA		*		*		*		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		*		LTHIBAUL		*		LTHIBAUL		GPEREZ		COMPLETED		LTHIBAUL		COMPLETED		GPEREZ		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		EMCENTEE		COMPLETED		COMPLETED		CFLAGG		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		GPEREZ		*		YRODRIGU		CFLAGG		PBANFORD		YRODRIGU		ASAETERN		MPACHECO		ASAETERN		MPACHECO		YRODRIGU		AGLADNEY		LTHIBAUL		LTHIBAUL		LTHIBAUL		JINGRAM		JINGRAM		*		SARRIAGA		MGUERRA		MGUERRA		MGUERRA		JINGRAM		MGUERRA		MGUERRA		ASAETERN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		*		DMCCASTL		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		ASAETERN		AGLADNEY		GKURIMOT		AGLADNEY		AGLADNEY		ASAETERN		GKURIMOT		AGLADNEY		JINGRAM		GTAYLOR		VUKSTINA		DMCCASTL		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		GTAYLOR		VUKSTINA		AGLADNEY		SARRIAGA		AGLADNEY		GTAYLOR		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		GTAYLOR		CHATRIDGE		GTAYLOR		GTAYLOR		CAFILER		MKIRKHAM		CAFILER		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11002		11003		11002		11003		11002		11003		11002		11003		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
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11003		11003		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		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003
rpt_start		1997-01-01 00:00:00		1995-04-01 00:00:00		1996-01-01 00:00:00		1995-10-01 00:00:00		1995-01-01 00:00:00		1999-04-01 00:00:00		1996-04-01 00:00:00		1998-04-01 00:00:00		1999-07-01 00:00:00		1996-07-01 00:00:00		1998-01-01 00:00:00		1998-07-01 00:00:00		1999-01-01 00:00:00		1999-07-01 00:00:00		1996-10-01 00:00:00		1996-10-01 00:00:00		1998-10-01 00:00:00		1995-07-01 00:00:00		1997-07-01 00:00:00		1996-10-01 00:00:00		1997-10-01 00:00:00		1997-04-01 00:00:00		2000-01-01 00:00:00		None		2000-04-01 00:00:00		2000-01-01 00:00:00		1999-10-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		1900-01-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		2002-04-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		1900-01-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		1900-01-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-03-06 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2003-10-01 00:00:00		2004-04-01 00:00:00		2004-04-01 00:00:00		2004-04-01 00:00:00		2004-10-01 00:00:00		2004-04-01 00:00:00		2005-03-07 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		2005-01-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2005-04-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		2006-07-01 00:00:00		2006-10-01 00:00:00		2007-01-01 00:00:00		1900-01-01 00:00:00		2007-03-20 00:00:00		2007-04-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-07-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		2014-04-01 00:00:00		2015-01-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2007-10-01 00:00:00		2008-04-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-12-18 00:00:00		1900-01-01 00:00:00		2009-04-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2009-10-01 00:00:00		2009-04-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2010-12-30 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2014-10-01 00:00:00		2012-12-11 00:00:00		2012-07-01 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2021-01-01 00:00:00		2020-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2019-01-01 00:00:00		2018-04-01 00:00:00		2019-04-01 00:00:00		2018-07-01 00:00:00		2020-07-01 00:00:00		2019-10-01 00:00:00		2017-07-01 00:00:00		1900-01-01 00:00:00		2018-10-01 00:00:00		2020-10-01 00:00:00		2019-01-10 00:00:00		2018-01-01 00:00:00		2017-10-01 00:00:00		2019-07-01 00:00:00		2020-04-01 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2022-04-01 00:00:00		2021-04-01 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00
rpt_end		1997-03-31 00:00:00		1995-06-30 00:00:00		1996-03-31 00:00:00		1995-12-31 00:00:00		1995-03-31 00:00:00		1999-06-30 00:00:00		1996-06-30 00:00:00		1998-06-30 00:00:00		1999-09-30 00:00:00		1996-09-30 00:00:00		1998-03-31 00:00:00		1998-09-30 00:00:00		1999-03-31 00:00:00		1999-09-30 00:00:00		1996-12-31 00:00:00		1996-12-31 00:00:00		1998-12-31 00:00:00		1995-09-30 00:00:00		1997-09-30 00:00:00		1996-12-31 00:00:00		1997-12-31 00:00:00		1997-06-30 00:00:00		2000-03-31 00:00:00		None		2000-06-30 00:00:00		2000-03-31 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		1900-01-01 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2002-03-31 00:00:00		2002-03-31 00:00:00		2001-12-31 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		1900-01-01 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		1900-01-01 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-03-06 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2004-03-31 00:00:00		2004-03-31 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		2004-06-30 00:00:00		2005-03-07 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		2005-03-31 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2005-06-30 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		2006-09-30 00:00:00		2006-12-31 00:00:00		2007-03-31 00:00:00		1900-01-01 00:00:00		2007-03-20 00:00:00		2007-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-09-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2015-03-31 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-03-31 00:00:00		2008-09-30 00:00:00		2008-12-31 00:00:00		2008-12-18 00:00:00		1900-01-01 00:00:00		2009-06-30 00:00:00		2009-03-31 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2009-06-30 00:00:00		2010-03-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-03-31 00:00:00		2010-09-30 00:00:00		2010-12-30 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2011-09-30 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2012-12-11 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2021-03-31 00:00:00		2020-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2019-03-31 00:00:00		2018-06-30 00:00:00		2019-06-30 00:00:00		2018-09-30 00:00:00		2020-09-30 00:00:00		2019-12-31 00:00:00		2017-09-30 00:00:00		1900-01-01 00:00:00		2018-12-31 00:00:00		2020-12-31 00:00:00		2019-01-10 00:00:00		2018-03-31 00:00:00		2017-12-31 00:00:00		2019-09-30 00:00:00		2020-06-30 00:00:00		2021-12-31 00:00:00		2021-03-31 00:00:00		2021-09-30 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		2022-03-31 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
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		22001		None		22001		None		None		22001		22001		None		None		22001		None		None		22001		22001		22001		22001		None		22001		None		22001		22001		None		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22006		22001		None		None		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22006		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22006		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22006		22001		22001		22001		None		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22006		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001

Table: filer_interests

filer_id		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662
session_id		2001		1999		1995		1997		2003		2009		2011		2005		2007		2013		2019		2015		2017		2023		2021
interest_cd		40304		40304		40304		40304		40304		40304		40304		40304		40304		40304		40304		40304		40304		40304		40304
effect_date		2001-01-01 00:00:00		1999-01-01 00:00:00		1995-01-01 00:00:00		1997-01-01 00:00:00		2003-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2013-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00		2021-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662
filer_type		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
active		Y		Y		Y		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		None		None		None
session_id		1999		1997		1995		2001		2003		2005		2007		2013		2011		2009		2017		2021		2019		2015		2023
category		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
category_type		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
sub_category		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
effect_dt		1999-01-01 00:00:00		1997-01-01 00:00:00		1995-01-01 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2013-01-01 00:00:00		2011-01-01 00:00:00		2009-01-01 00:00:00		2017-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
election_type		0		0		0		0		None		None		None		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		2000-01-01 00:00:00		2000-01-01 00:00:00		None		None		None		None		None		None		None		None
party_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
county_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
district_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1143662
xref_id		C23866
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866		C23866
filer_id		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662
filer_type		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES		LOS ANGELES
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010		90010
phon		3238577140		2138577140		2138577140		3238577140		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3238577140		2138577140		2138577140		3238577140		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3238577140		2138577140		2138577140		3238577140		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3238577140		2138577140		2138577140		3238577140		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3238577140		2138577140		2138577140		3238577140		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3238577140		2138577140		2138577140		3238577140		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3238577140		2138577140		2138577140		3238577140		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3238577140		2138577140		2138577140		3238577140		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3238577140		2138577140		2138577140		3238577140		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3238577140		2138577140		2138577140		3238577140		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3238577140		2138577140		2138577140		3238577140		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3238577140		2138577140		2138577140		3238577140		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909		3239372909
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1143662

Table: lobbying_chg_log

filer_id		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662
change_no		1		2		3		4		0		6		5		7
session_id		1999		1999		2003		2003		2005		2007		2007		2007
log_dt		2000-08-01 00:00:00		2000-11-21 00:00:00		2003-03-06 00:00:00		2003-12-19 00:00:00		2005-03-30 00:00:00		2007-03-20 00:00:00		2007-03-05 00:00:00		2007-03-19 00:00:00
filer_type		1		1		1		1		1		1		1		1
correction_flg		None		None		Y		Y		None		Y		Y		Y
action		DELETED		SET ACTIVE		ADDED		DELETED		ADDED		ADDED		DELETED		AMENDED
attribute_changed		FIRM		CLIENT		None		None		FIRM		FIRM		None		TERMINATION DATE
ethics_dt		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None
filer_full_name		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION & ITS SUBSIDIARY MERCURY CASUALTY COMPANY		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION		MERCURY GENERAL CORPORATION
filer_city		None		MODESTO		LOS ANGELES		None		None		LOS ANGELES		None		LOS ANGELES
filer_st		None		CA		CA		None		None		CA		None		CA
filer_zip		None		95352		90010		None		None		90010		None		90010
filer_phone		None		2095746203		3238577140		None		None		3238577140		None		3238577140
entity_type		3		3		3		3		3		3		3		3
entity_name		NORWOOD & PEDROTTI		CARPENTER SNODGRASS & ASSOCIATES		JOHNSTON, PATRICK		JOHNSTON, PATRICK		NORWOOD & MATTOCH		APREA & MICHELI		CALIFORNIA STRATEGIES & ADVOCACY, LLC		CALIFORNIA STRATEGIES & ADVOCACY, LLC
entity_city		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None
entity_id		1147391		1147269		None		1232795		1264591		None		1273600		None
responsible_officer		None		None		None		None		None		None		None		None
effect_dt		None		None		2003-02-25 00:00:00		2003-12-11 00:00:00		2005-03-01 00:00:00		2007-03-01 00:00:00		2007-03-01 00:00:00		2007-02-01 00:00:00

Table: lobbyist_contributions1

filer_id		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662
filing_period_start_dt		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00
filing_period_end_dt		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00
contribution_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
recipient_name		CALIFORNIA REPUBLICAN PARTY		JAN LEJA FOR ASSEMBLY		ARPAC (SCOTT BAUGH AD-67)		TOM MCCLINTOCK FOR STATE SENATE		JACK SCOTT FOR STATE SENATE		TOM CALDERON FOR ASSEMBLY		CHUCK QUACKENBUSH COMMITTEE		TAXPAYERS AGAINST PROPOSITION 25		EDDIE CORTEZ FOR ASSEMBLY		FRIENDS OF RICO OLLER		COMMITTEE TO ELECT KEVIN MURRAY		MADDOX FOR ASSEMBLY 2000		DAVID FREEMAN FOR ASSEMBLY		DAMIAN JONES FOR ASSEMBLY		TAXPAYERS FOR DAVE COX		CHARLENE ZETTEL FOR ASSEMBLY		FRIENDS OF DENNIS CARDOZA		ASSEMBLY DEMOCRATIC LEADERSHIP 2000 (BOB HERTZBERG AD-40)		COMMITTEE TO RE-ELECT TOM CALDERON		JACKIE SPEIER - STATE SENATE		TOM CALDERON FOR ASSEMBLY		FRIENDS OF KERRY MAZZONI		PAT WIGGINS FOR ASSEMBLY		SEN. PAT JOHNSTON MAJORITY FUND		FRIENDS OF DENNIS CARDOZA		LEJA FOR ASSEMBLY		MACHADO FOR SENATE		PAT BATES FOR ASSEMBLY		FRIENDS OF RICHARD POLANCO		AANESTAD FOR ASSEMBLY		KLEHS FOR CONTROLLER		RAY HAYNES FOR STATE SENATE		MARTIN GALLEGOS FOR STATE SENATE		FRIENDS OF SENATOR MONTEITH		KELLEY ASSEMBLY COMMITTEE		DEMOCRATIC BUSINESS PAC		ABEL MALDONADO FOR ASSEMBLY		COMMITTEE TO ELECT KEVIN MURRAY		STRICKLAND FOR ASSEMBLY		ANTHONY PESCETTI FOR ASSEMBLY		ARPAC		FLOYD CAMPAIGN COMMITTEE		MCCLINTOCK FOR SENATE		ROY ASHBURN STATE ASSEMBLY COMM.		MADDOX FOR ASSEMBLY 2000		BILL MORROW FOR SENATE		ROD PACHECO FOR ASSEMBLY		BILL LEONARD FOR ASSEMBLY		ED VINCENT FOR SENATE		ACKERMAN FOR SENATE COMMITTEE		DICK DICKERSON FOR STATE ASSEMBLY		FRIENDS OF PHILIP ANGELIDES		COMM. TO RE-ELECT TOM CALDERON		ASSEMBLY DEMOCRATIC LEADERSHIP 2000		ARPAC		JOHN DUTRA FOR ASSEMBLY		TAXPAYERS FOR DAVE COX		FRIENDS OF JIM BRULTE		HAVICE 2000		FRIENDS OF RICO OLLER		KLEHS FOR CONTROLLER		TIM LESLIE FOR STATE ASSEMBLY		FRIENDS OF SARAH REYES		ARPAC		RAY HAYNES FOR STATE SENATE		FRIENDS OF SENATOR MONTEITH		FRIENDS OF ROSS JOHNSON		COSTA FOR SENATE COMMITTEE		CALIF. VOTER REGISTRATION PROJECT		FRIENDS OF BILL CAMPBELL		DENNIS MOUNTJOY FOR ASSEMBLY		LOU CORREA FOR STATE ASSEMBLY		CITIZENS FOR BOB MARGETT		NELL SOTO FOR SENATE 2002		COMMITTEE TO ELECT KEVIN MURRAY		ROD PACHECO FOR ASSEMBLY 2000		JAY LASUER FOR ASSEMBLY		TAXPAYERS FOR MIKE MACHADO		DARIO FROMMER FOR ASSEMBLY		ANTHONY PESCETTI FOR ASSEMBLY		PAT BATES FOR ASSEMBLY		COMM TO ELECT CARL WASHINGTON		STRICKLAND FOR ASSEMBLY		SENATE MAJORITY FUND		MADDOX FOR ASSEMBLY 2000		STRICKLAND FOR ASSEMBLY		CLAUDE PARRISH STATE BOARD OF EQUALIZATION		CITIZENS FOR BOB MARGETT		FRIENDS OF LYNN DAUCHER		PESCETTI FOR ASSEMBLY		STRICKLAND FOR ASSEMBLY		MADDOX FOR ASSEMBLY		FRIENDS OF JOHN CAMPBELL		FRIENDS OF BILL CAMPBELL		ROY ASHBURN STATE ASSEMBLY COMMITTEE		FRIENDS OF GEORGE RUNNER		BATES FOR ASSEMBLY		BAUGH 98		FRIENDS OF PHIL ANGELIDES		ASSEMBLY DEMOCRATIC LEADERSHIP COMMITTEE 2000		COMMITTEE TO ELECT BOB PACHECO		MACHADO FOR SENATE 2000		GLORIA ROMERO FOR STATE SENATE		FRIENDS OF BILL CAMPBELL		GOVERNOR GRAY DAVIS COMMITTEE		ED CHAVEZ FOR ASSEMBLY		MANNY DIAZ FOR ASSEMBLY		SOTO FOR SENATE		COMMITTEE TO RE-ELECT TOM CALDERON		FRIENDS OF KEVIN MURRAY
recipient_id		1030435		1076338		1076036		1075436		1077330		1071970		1070661		1077505		1076171		1074960		1071788		1077656		1077020		1221243		1069205		1071353		1069846		1077687		1071970		1067685		1071970		1061398		1071557		1053281		1069846		1076338		1075516		1071574		1064478		1054939		1076764		1050255		1076022		1071881		1075683		1072621		1072662		1070797		1069359		1069579		1076036		1066487		1075436		1073057		1077656		1069575		1072148		1065615		1075828		1075514		1071717		1070477		1071970		1077687		1076036		1072383		1069205		1069427		1069837		1074960		1076764		1075853		1072108		1076036		1050255		1071881		1065030		1072145		1070807		1064987		None		1065492		1075685		1223120		1071788		1072148		1046458		1075516		1077266		1069579		1071574		1064536		1069359		1064947		1077656		1069359		1070573		1075685		1075910		1069579		1069359		1071858		1075631		1064987		1073057		1072110		1071574		1066780		1070477		1077687		1071691		1075516		1224066		1064987		1069390		1075999		1220119		1223120		1071970		1071788
amount		10000		15000		5000		1000		7500		1000		50000		25000		5000		1000		1000		750		500		1000		750		750		15000		20000		1000		1000		15000		500		1000		1000		1000		500		1000		750		1000		500		2500		1000		1000		1000		750		5000		750		1000		750		750		1000		500		1000		750		750		1000		1000		750		1000		1000		1000		1000		4000		50000		5000		1000		1000		1000		750		1000		1000		1000		500		5000		1000		750		1000		1000		500		1000		500		1000		1000		500		5000		500		1500		2500		500		750		750		1000		750		100000		750		750		1000		2000		500		1000		5000		5000		2500		2000		3000		4000		3300		7000		1000		5000		1000		2500		1000		2000		25000		1000		500		1000		3000		3000

Table: lobbyist_contributions2

filer_id		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662
filing_period_start_dt		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-04-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2000-10-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00
filing_period_end_dt		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-03-31 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00		2001-03-31 00:00:00
contribution_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
recipient_name		CALIFORNIA REPUBLICAN PARTY		JAN LEJA FOR ASSEMBLY		ARPAC (SCOTT BAUGH AD-67)		TOM MCCLINTOCK FOR STATE SENATE		JACK SCOTT FOR STATE SENATE		TOM CALDERON FOR ASSEMBLY		CHUCK QUACKENBUSH COMMITTEE		TAXPAYERS AGAINST PROPOSITION 25		EDDIE CORTEZ FOR ASSEMBLY		FRIENDS OF RICO OLLER		COMMITTEE TO ELECT KEVIN MURRAY		MADDOX FOR ASSEMBLY 2000		DAVID FREEMAN FOR ASSEMBLY		DAMIAN JONES FOR ASSEMBLY		TAXPAYERS FOR DAVE COX		CHARLENE ZETTEL FOR ASSEMBLY		FRIENDS OF DENNIS CARDOZA		ASSEMBLY DEMOCRATIC LEADERSHIP 2000 (BOB HERTZBERG AD-40)		COMMITTEE TO RE-ELECT TOM CALDERON		JACKIE SPEIER - STATE SENATE		TOM CALDERON FOR ASSEMBLY		FRIENDS OF KERRY MAZZONI		PAT WIGGINS FOR ASSEMBLY		SEN. PAT JOHNSTON MAJORITY FUND		FRIENDS OF DENNIS CARDOZA		LEJA FOR ASSEMBLY		MACHADO FOR SENATE		PAT BATES FOR ASSEMBLY		FRIENDS OF RICHARD POLANCO		AANESTAD FOR ASSEMBLY		KLEHS FOR CONTROLLER		RAY HAYNES FOR STATE SENATE		MARTIN GALLEGOS FOR STATE SENATE		FRIENDS OF SENATOR MONTEITH		KELLEY ASSEMBLY COMMITTEE		DEMOCRATIC BUSINESS PAC		ABEL MALDONADO FOR ASSEMBLY		COMMITTEE TO ELECT KEVIN MURRAY		STRICKLAND FOR ASSEMBLY		ANTHONY PESCETTI FOR ASSEMBLY		ARPAC		FLOYD CAMPAIGN COMMITTEE		MCCLINTOCK FOR SENATE		ROY ASHBURN STATE ASSEMBLY COMM.		MADDOX FOR ASSEMBLY 2000		BILL MORROW FOR SENATE		ROD PACHECO FOR ASSEMBLY		BILL LEONARD FOR ASSEMBLY		ED VINCENT FOR SENATE		ACKERMAN FOR SENATE COMMITTEE		DICK DICKERSON FOR STATE ASSEMBLY		FRIENDS OF PHILIP ANGELIDES		COMM. TO RE-ELECT TOM CALDERON		ASSEMBLY DEMOCRATIC LEADERSHIP 2000		ARPAC		JOHN DUTRA FOR ASSEMBLY		TAXPAYERS FOR DAVE COX		FRIENDS OF JIM BRULTE		HAVICE 2000		FRIENDS OF RICO OLLER		KLEHS FOR CONTROLLER		TIM LESLIE FOR STATE ASSEMBLY		FRIENDS OF SARAH REYES		ARPAC		RAY HAYNES FOR STATE SENATE		FRIENDS OF SENATOR MONTEITH		FRIENDS OF ROSS JOHNSON		COSTA FOR SENATE COMMITTEE		CALIF. VOTER REGISTRATION PROJECT		FRIENDS OF BILL CAMPBELL		DENNIS MOUNTJOY FOR ASSEMBLY		LOU CORREA FOR STATE ASSEMBLY		CITIZENS FOR BOB MARGETT		NELL SOTO FOR SENATE 2002		COMMITTEE TO ELECT KEVIN MURRAY		ROD PACHECO FOR ASSEMBLY 2000		JAY LASUER FOR ASSEMBLY		TAXPAYERS FOR MIKE MACHADO		DARIO FROMMER FOR ASSEMBLY		ANTHONY PESCETTI FOR ASSEMBLY		PAT BATES FOR ASSEMBLY		COMM TO ELECT CARL WASHINGTON		STRICKLAND FOR ASSEMBLY		SENATE MAJORITY FUND		MADDOX FOR ASSEMBLY 2000		STRICKLAND FOR ASSEMBLY		CLAUDE PARRISH STATE BOARD OF EQUALIZATION		CITIZENS FOR BOB MARGETT		FRIENDS OF LYNN DAUCHER		PESCETTI FOR ASSEMBLY		STRICKLAND FOR ASSEMBLY		MADDOX FOR ASSEMBLY		FRIENDS OF JOHN CAMPBELL		FRIENDS OF BILL CAMPBELL		ROY ASHBURN STATE ASSEMBLY COMMITTEE		FRIENDS OF GEORGE RUNNER		BATES FOR ASSEMBLY		BAUGH 98		FRIENDS OF PHIL ANGELIDES		ASSEMBLY DEMOCRATIC LEADERSHIP COMMITTEE 2000		COMMITTEE TO ELECT BOB PACHECO		MACHADO FOR SENATE 2000		GLORIA ROMERO FOR STATE SENATE		FRIENDS OF BILL CAMPBELL		GOVERNOR GRAY DAVIS COMMITTEE		ED CHAVEZ FOR ASSEMBLY		MANNY DIAZ FOR ASSEMBLY		SOTO FOR SENATE		COMMITTEE TO RE-ELECT TOM CALDERON		FRIENDS OF KEVIN MURRAY
recipient_id		1030435		1076338		1076036		1075436		1077330		1071970		1070661		1077505		1076171		1074960		1071788		1077656		1077020		1221243		1069205		1071353		1069846		1077687		1071970		1067685		1071970		1061398		1071557		1053281		1069846		1076338		1075516		1071574		1064478		1054939		1076764		1050255		1076022		1071881		1075683		1072621		1072662		1070797		1069359		1069579		1076036		1066487		1075436		1073057		1077656		1069575		1072148		1065615		1075828		1075514		1071717		1070477		1071970		1077687		1076036		1072383		1069205		1069427		1069837		1074960		1076764		1075853		1072108		1076036		1050255		1071881		1065030		1072145		1070807		1064987		None		1065492		1075685		1223120		1071788		1072148		1046458		1075516		1077266		1069579		1071574		1064536		1069359		1064947		1077656		1069359		1070573		1075685		1075910		1069579		1069359		1071858		1075631		1064987		1073057		1072110		1071574		1066780		1070477		1077687		1071691		1075516		1224066		1064987		1069390		1075999		1220119		1223120		1071970		1071788
amount		10000		15000		5000		1000		7500		1000		50000		25000		5000		1000		1000		750		500		1000		750		750		15000		20000		1000		1000		15000		500		1000		1000		1000		500		1000		750		1000		500		2500		1000		1000		1000		750		5000		750		1000		750		750		1000		500		1000		750		750		1000		1000		750		1000		1000		1000		1000		4000		50000		5000		1000		1000		1000		750		1000		1000		1000		500		5000		1000		750		1000		1000		500		1000		500		1000		1000		500		5000		500		1500		2500		500		750		750		1000		750		100000		750		750		1000		2000		500		1000		5000		5000		2500		2000		3000		4000		3300		7000		1000		5000		1000		2500		1000		2000		25000		1000		500		1000		3000		3000

Table: received_filings

filer_id		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662		1143662
filing_file_name		624405_0.cal		644002_0.cal		678533_0.cal		9825.cal		31104.cal		715355_0.cal		204906.cal		744164_0.cal		769777_0.cal		790651_0.cal		812620_0.cal		838397_0.cal		849864_0.cal		877029_0.cal		905497_0.cal		928976_0.cal		923935_0.cal		169632.cal		943556_0.cal		968678_0.cal		398283.cal		203720.cal		202595.cal		202862.cal		439972.cal		440042.cal		439790.cal		440588.cal		516530.cal		124553.cal		124670.cal		271641.cal		5483.cal		497793.cal		232802.cal		232291.cal
received_date		2000-05-01 00:00:00		2000-07-28 00:00:00		2000-10-27 00:00:00		2000-10-19 00:00:00		2000-10-24 00:00:00		2001-01-26 00:00:00		2001-04-26 00:00:00		2001-04-26 00:00:00		2001-07-25 00:00:00		2001-10-30 00:00:00		2002-01-30 00:00:00		2002-04-29 00:00:00		2002-07-16 00:00:00		2002-10-23 00:00:00		2003-01-23 00:00:00		2003-04-25 00:00:00		2003-03-06 00:00:00		2003-07-22 00:00:00		2003-07-22 00:00:00		2003-10-29 00:00:00		2005-04-19 00:00:00		2010-07-20 00:00:00		2010-07-20 00:00:00		2010-07-20 00:00:00		2010-04-28 00:00:00		2010-04-28 00:00:00		2010-04-28 00:00:00		2010-04-28 00:00:00		2010-04-30 00:00:00		2007-07-25 00:00:00		2007-07-25 00:00:00		2017-04-28 00:00:00		2014-10-28 00:00:00		2014-10-27 00:00:00		2021-07-26 00:00:00		2021-07-26 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/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/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/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp
filing_id		624405		644002		678533		None		None		715355		None		744164		769777		790651		812620		838397		849864		877029		905497		928976		923935		None		943556		968678		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
form_id		F635		F635		F635		None		None		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		None		F635		F635		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
receive_comment		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but with warnings		Filing did not pass validation		Filing did not pass validation		Filing accepted, but with warnings		Filing did not pass validation		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing did not pass validation		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing did not pass validation		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing did not pass validation		Filing passed validation, but failed DB constraints