Home

Filer ID: 1065274

Table: filer_acronyms

acronym		TOC PAC
filer_id		1065274

Table: filer_address

filer_id		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274
adrid		1073463		2018835		2063305		2074051		2071568		2071569		2168054		2188528		2392576		2398057		2398056		2392577		2430355		2430354		2362508		2362510		2438757		2438756
effect_dt		1995-07-14 00:00:00		2001-08-06 00:00:00		1998-06-18 00:00:00		2004-08-23 00:00:00		1995-05-01 00:00:00		1995-05-01 00:00:00		2009-03-03 00:00:00		2010-05-03 00:00:00		2016-03-18 00:00:00		2016-05-09 00:00:00		2016-05-09 00:00:00		2016-03-18 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2017-08-03 00:00:00		2017-08-03 00:00:00
add_type		7051		7050		7050		7051		7051		7082		7082		7051		7051		7082		7051		7082		7082		7051		7051		7082		7082		7051
session_id		1995		2001		1997		2003		1995		1995		2009		2009		2015		2015		2015		2015		2017		2017		2015		2015		2017		2017

Table: filer_filings

filer_id		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274
filing_id		384710		384711		384712		384713		384714		384715		384716		384717		384718		384719		384721		384722		384723		384724		384725		384726		384728		384729		384730		384731		384732		384734		384735		441882		441883		441884		384709		384720		384727		587676		672444		648385		723644		774676		784080		786931		786106		786106		772627		803887		809523		811849		808794		786931		820751		826672		869780		876830		852206		857181		870423		879204		895309		905251		894537		916599		962865		950503		962519		946360		984065		979274		981893		1005823		986055		1034100		1027237		1027237		993127		1049619		1042173		1044736		993127		1053032		1047317		1034100		1063866		1075415		1101599		1118104		1087133		1146209		1132577		1106413		1135295		1153787		1172436		1186736		1190743		1203603		1207269		1201615		1217646		1232133		1285844		1267356		1278533		1272000		1308786		1271999		993127		1771558		1784610		1979570		993127		1969967		1977055		1864221		1817830		1853113		1854740		1862536		1780179		1943150		1893113		1321928		1314337		1324544		1335255		1338360		1365136		1362545		1367487		1354141		1381647		1382225		1411610		1420906		1426320		1396631		1486468		1486469		1503316		1484567		1484569		1486301		1486302		1490341		1513107		1493405		1569242		1574056		1603114		1611011		1647959		993127		1646298		1649645		1647819		1645001		1674622		1672810		1817830		1821006		1694586		1693683		1693411		1928343		1925487		1711026		1700924		1892371		1878151		1821006		993127		1851526		1851526		1753661		1746169		1736871		1746169		1756936		993127		1736871		993127		2002630		2397097		2208257		2358025		2217389		2420598		2208257		2024440		2009407		2019001		2058412		2043617		2069805		993127		2126931		2142760		2135492		2281503		993127		2175926		2179787		2217389		2494650		2440949		2486300		2566200		2181857		2550553		2403962		2451191		2217389		2281503		2348565		2276065		2276065		2419801		2624625		2665871		2692279		2673210		2603855		2680373		2707168		2665871		2672051		2624625		2603855		2641762		2657092		2686653
period_id		145		145		143		145		145		145		146		145		148		149		151		153		153		154		154		155		156		156		156		141		157		147		157		145		143		147		143		149		156		None		None		None		None		None		None		None		167		167		165		168		None		None		169		None		169		None		171		172		169		None		None		None		None		172		None		None		None		None		175		173		177		176		None		None		None		None		177		177		177		180		None		179		179		None		None		None		165		180		181		182		None		184		183		None		None		None		185		186		None		187		None		187		None		None		None		None		189		188		191		188		213		None		None		None		222		None		221		None		215		217		None		218		213		None		None		193		None		None		193		None		None		195		194		None		196		None		None		None		None		196		None		None		202		197		199		None		None		201		None		None		203		None		205		None		None		209		209		None		None		207		None		209		215		None		None		211		212		220		221		212		212		219		219		None		213		218		218		None		None		212		None		None		213		212		224		None		237		231		None		None		None		231		None		223		None		225		None		None		229		227		None		None		None		231		229		None		None		None		240		241		None		None		243		None		None		None		None		235		233		233		239		None		250		None		249		245		None		250		250		250		None		245		247		None		250
form_id		F497		F420		F420		F497		F420		F405		F420		F405		F420		F420		F420		F420		F420		F405		F420		F420		F420		F405		F420		F666		F405		F405		F420		F497		F405		F420		F410		F405		F497		F420		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F410		F460		F410		F460		F410		F460		F460		F460		F666		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F496		F460		F460		F460		F460		F460		F460		F460		F460		F410		F410		F460		F460		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F497		F497		F497		F460		F497		F460		F410		F497		F497		F410		F460		F460		F460		F410		F410		F460		F410		F410		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F410		F460		F410		F460		F460		F410		F460		F410		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		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		5		0		0		0		6		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		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		3		1		0		0		0		1		1		0		4		0		7		0		0		1		0		2		0		0		0		0		0		0		0		0		8		0		0		0		0		9		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		1		0		0		1		0		0		0		0		0		0		0		1		1		0		0		0
filing_date		1996-03-19 00:00:00		1996-03-18 00:00:00		1996-03-18 00:00:00		1996-03-21 00:00:00		1996-05-24 00:00:00		1996-07-15 00:00:00		1996-07-30 00:00:00		1996-08-26 00:00:00		1997-01-31 00:00:00		1997-07-30 00:00:00		1998-01-26 00:00:00		1998-03-23 00:00:00		1998-05-21 00:00:00		1998-06-18 00:00:00		1998-08-31 00:00:00		1998-10-05 00:00:00		1998-10-23 00:00:00		1998-10-01 00:00:00		1999-02-01 00:00:00		1999-01-29 00:00:00		1999-02-02 00:00:00		1996-10-15 00:00:00		1999-08-02 00:00:00		1996-03-18 00:00:00		1996-07-15 00:00:00		1996-10-07 00:00:00		1995-07-14 00:00:00		1997-12-04 00:00:00		1998-10-21 00:00:00		2000-01-27 00:00:00		2000-10-06 00:00:00		2000-07-31 00:00:00		2001-02-01 00:00:00		2001-08-06 00:00:00		2001-08-01 00:00:00		2001-10-10 00:00:00		2001-10-31 00:00:00		2001-10-10 00:00:00		2001-07-31 00:00:00		2002-01-08 00:00:00		2002-01-10 00:00:00		2002-01-24 00:00:00		2002-01-22 00:00:00		2001-11-19 00:00:00		2002-02-18 00:00:00		2002-02-21 00:00:00		2002-09-30 00:00:00		2002-10-23 00:00:00		2002-07-26 00:00:00		2002-07-31 00:00:00		2002-10-02 00:00:00		2002-10-24 00:00:00		2002-11-21 00:00:00		2003-01-23 00:00:00		2002-11-13 00:00:00		2003-01-31 00:00:00		2003-10-07 00:00:00		2003-07-30 00:00:00		2003-10-08 00:00:00		2003-07-30 00:00:00		2004-01-21 00:00:00		2004-01-09 00:00:00		2004-01-09 00:00:00		2004-02-17 00:00:00		2004-01-21 00:00:00		2004-08-02 00:00:00		2004-08-02 00:00:00		2004-07-28 00:00:00		2004-02-10 00:00:00		2004-10-20 00:00:00		2004-08-23 00:00:00		2004-10-05 00:00:00		2004-08-19 00:00:00		2004-10-21 00:00:00		2004-10-05 00:00:00		2004-08-05 00:00:00		2004-12-01 00:00:00		2005-01-25 00:00:00		2005-04-21 00:00:00		2005-08-01 00:00:00		2005-01-31 00:00:00		2006-01-30 00:00:00		2005-10-28 00:00:00		2005-04-27 00:00:00		2005-10-31 00:00:00		2006-01-31 00:00:00		2006-05-22 00:00:00		2006-07-24 00:00:00		2006-07-28 00:00:00		2006-10-03 00:00:00		2006-10-04 00:00:00		2006-09-25 00:00:00		2006-10-26 00:00:00		2007-01-23 00:00:00		2007-07-31 00:00:00		2006-05-25 00:00:00		2007-07-19 00:00:00		2007-06-05 00:00:00		2008-01-30 00:00:00		2007-06-05 00:00:00		2013-06-03 00:00:00		2013-06-03 00:00:00		2013-07-30 00:00:00		2015-07-24 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-07-24 00:00:00		2014-07-15 00:00:00		2014-05-22 00:00:00		2014-05-22 00:00:00		2014-05-22 00:00:00		2014-07-11 00:00:00		2013-07-29 00:00:00		2015-01-26 00:00:00		2014-10-06 00:00:00		2008-03-27 00:00:00		2008-01-30 00:00:00		2008-04-08 00:00:00		2008-05-22 00:00:00		2008-05-22 00:00:00		2008-10-06 00:00:00		2008-10-06 00:00:00		2008-10-20 00:00:00		2008-07-31 00:00:00		2008-11-17 00:00:00		2008-11-17 00:00:00		2009-02-02 00:00:00		2009-03-03 00:00:00		2005-07-27 00:00:00		2009-01-31 00:00:00		2010-04-30 00:00:00		2010-04-30 00:00:00		2010-07-26 00:00:00		2010-04-29 00:00:00		2010-04-29 00:00:00		2010-05-03 00:00:00		2010-05-03 00:00:00		2010-05-26 00:00:00		2010-08-02 00:00:00		2010-05-27 00:00:00		2011-01-28 00:00:00		2011-01-31 00:00:00		2011-07-25 00:00:00		2011-08-01 00:00:00		2012-03-22 00:00:00		2012-03-20 00:00:00		2012-03-20 00:00:00		2012-03-22 00:00:00		2012-03-15 00:00:00		2012-03-14 00:00:00		2012-07-20 00:00:00		2012-07-19 00:00:00		2014-01-31 00:00:00		2014-01-31 00:00:00		2012-10-04 00:00:00		2012-10-04 00:00:00		2012-10-03 00:00:00		2015-01-22 00:00:00		2015-01-14 00:00:00		2012-11-01 00:00:00		2012-10-22 00:00:00		2014-10-06 00:00:00		2014-08-16 00:00:00		2014-05-22 00:00:00		2013-01-10 00:00:00		2014-05-19 00:00:00		2014-05-19 00:00:00		2013-01-11 00:00:00		2013-01-31 00:00:00		2013-02-14 00:00:00		2013-02-14 00:00:00		2013-01-31 00:00:00		2013-01-30 00:00:00		2013-01-30 00:00:00		2016-01-05 00:00:00		2016-01-05 00:00:00		2019-07-30 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2019-10-31 00:00:00		2018-01-30 00:00:00		2016-03-18 00:00:00		2016-01-28 00:00:00		2016-01-29 00:00:00		2016-07-26 00:00:00		2016-05-09 00:00:00		2016-07-27 00:00:00		2017-01-30 00:00:00		2017-01-30 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2018-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2017-07-31 00:00:00		2018-01-30 00:00:00		2020-07-31 00:00:00		2020-01-30 00:00:00		2020-07-31 00:00:00		2021-01-29 00:00:00		2017-08-03 00:00:00		2021-01-29 00:00:00		2019-07-31 00:00:00		2020-01-31 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2018-07-31 00:00:00		2019-01-31 00:00:00		2019-10-31 00:00:00		2021-08-02 00:00:00		2022-05-18 00:00:00		2022-05-26 00:00:00		2022-04-28 00:00:00		2021-08-02 00:00:00		2022-04-28 00:00:00		2022-08-01 00:00:00		2022-04-13 00:00:00		2022-04-27 00:00:00		2022-01-28 00:00:00		2022-01-28 00:00:00		2022-01-28 00:00:00		2022-01-28 00:00:00		2022-05-26 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10002		10005		10005		10002		10001		10001		10001		10005		10005		10001		10006		10001		10005		10001		10001		10001		10005		10005		10005		10002		10001		10005		10005		10005		10005		10001		10001		10001		10001		10005		10002		10005		10005		10002		10001		10001		10001		10002		10001		10002		10005		10005		10006		10005		10001		10001		10001		10005		10001		10001		10005		10005		10005		10001		10001		10005		10001		10005		10001		10005		10005		10005		10005		10001		10001		10001		10001		10002		10006		10005		10005		10002		10006		10001		10005		10002		10001		10005		10001		10001		10005		10005		10001		10005		10005		10001		10005		10005		10001		10001		10005		10001		10005		10005		10006		10005		10001		10005		10005		10001		10001		10001		10006		10006		10001		10005		10005		10001		10005		10001		10005		10005		10002		10001		10006		10005		10001		10005		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10006		10002		10002		10001		10006		10005		10002		10006		10002		10002		10001		10002		10006		10001		10002		10005		10006		10005		10001		10006		10001		10005		10001		10006		10005		10002		10001		10005		10006		10005		10002		10001		10005		10005		10005		10001		10001		10005		10006		10001		10005		10005		10006		10006		10001		10001		10002		10001		10005		10002		10005		10001		10001		10005		10001		10001		10001		10006		10002		10001		10005		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11003		11003		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11001		11003		11001		11003		11003		11003		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11003		11001		11001		11003		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003
session_id		1995		1995		1995		1995		1995		1995		1995		1995		1995		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1995		1999		1995		1999		1995		1995		1995		1995		1997		1997		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2001		2003		2005		2005		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2005		2007		2005		2013		2013		2013		2015		2015		2015		2015		2013		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2005		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2011		2011		2011		2013		2015		2011		2011		2013		2013		2013		2013		2013		2013		2013		2011		2011		2011		2013		2013		2011		2015		2015		2019		2017		2017		2017		2019		2017		2015		2015		2015		2015		2015		2015		2017		2015		2015		2017		2017		2017		2017		2017		2017		2019		2019		2019		2019		2017		2019		2019		2019		2017		2017		2017		2017		2017		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		KCHAN		TTHAM		TWALLS		TTHAM		SARRIAGA		CFLAGG		*		*		*		*		SARRIAGA		SARRIAGA		*		CFLAGG		*		DBARRICK		*		*		*		DBARRICK		DBARRICK		DBARRICK		TTHAM		COMPLETED		DBARRICK		KVANG		KVANG		KVOONG1		COMPLETED		COMPLETED		COMPLETED		COMPLETED		KVOONG1		TTHAM		GGILMORE		EMCENTEE		COMPLETED		COMPLETED		COMPLETED		COMPLETED		TTHAM		COMPLETED		COMPLETED		CFLAGG		CFLAGG		EMCENTEE		PROBERTS		COMPLETED		*		*		SARRIAGA		*		*		SARRIAGA		KVANG		CFLAGG		*		*		RGEREMIA		*		SARRIAGA		*		GKURIMOT		GKURIMOT		SARRIAGA		SARRIAGA		*		*		*		*		CAFILER		TRAMON		MPACHECO		SARRIAGA		TRAMON		TRAMON		SARRIAGA		MPACHECO		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		CAFILER		CAFILER		GCLARA		JINGRAM		*		SARRIAGA		RGEREMIA		*		TMILLER		RGEREMIA		*		*		GKURIMOT		*		RGEREMIA		NWALKER		RGEREMIA		JLANDERS		*		NWALKER		MMORENO		*		NWALKER		MMORENO		RGEREMIA		RGEREMIA		CPON		CFLAGG		CPON		SARRIAGA		SARRIAGA		MMORENO		MMORENO		MDIGRAZIA		TRAMON		MDIGRAZIA		TRAMON		MDIGRAZIA		MDIGRAZIA		CPON		CPON		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		CAFILER		CAFILER		GKURIMOT		CAFILER		CAFILER		CAFILER		CAFILER		MPACHECO		TRAMON		CAFILER		CAFILER		TRAMON		MPACHECO		CAFILER		MPACHECO		TRAMON		TRAMON		CAFILER		TRAMON		TRAMON		SARRIAGA		CAFILER		LPHEAV		YMORA		HCOURSEY		CSAGABAEN		DHOANG		SMCCONNAN		SMCCONNAN		GPEREZ		DHOANG		GPEREZ		TRAMON		GPEREZ		GPEREZ		TRAMON		HSTOVALL		TRAMON		BSINGH		BSINGH		CSAGABAEN		KRUSSELL		LFEDOROV		KRUSSELL		BCOLON		TRAMON		BCOLON		SARRIAGA		LFEDOROV		LPHEAV		LPHEAV		LPHEAV		HSTOVALL		CAFILER		HCOURSEY		KRUSSELL		CAFILER		JMAVES		KRUSSELL		KRUSSELL		KRUSSELL		CAFILER		CAFILER		CAFILER		JMAVES		CAFILER		KRUSSELL		KRUSSELL		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11003		11001		11003		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		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
rpt_start		None		1996-01-01 00:00:00		1995-07-01 00:00:00		None		1996-03-18 00:00:00		1996-01-01 00:00:00		1996-05-19 00:00:00		1996-03-10 00:00:00		1996-10-01 00:00:00		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-01-01 00:00:00		1998-03-18 00:00:00		None		1998-05-17 00:00:00		1998-07-01 00:00:00		1998-10-01 00:00:00		None		1998-10-18 00:00:00		1995-01-01 00:00:00		None		1996-07-01 00:00:00		1999-01-01 00:00:00		None		1995-07-01 00:00:00		1996-07-01 00:00:00		None		1997-01-01 00:00:00		None		1999-07-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		None		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2001-07-01 00:00:00		2002-01-20 00:00:00		2002-01-20 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-02-17 00:00:00		2002-02-17 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		None		2002-10-20 00:00:00		2002-10-01 00:00:00		2003-10-20 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2004-01-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		None		2004-01-01 00:00:00		2004-01-18 00:00:00		2004-01-18 00:00:00		2004-01-18 00:00:00		2004-02-10 00:00:00		2004-10-01 00:00:00		None		2004-07-01 00:00:00		2004-08-11 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2004-01-18 00:00:00		2001-01-01 00:00:00		2004-10-16 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		2004-10-16 00:00:00		2005-10-01 00:00:00		2005-07-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-05-21 00:00:00		2006-05-21 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2006-09-25 00:00:00		2006-10-01 00:00:00		2006-10-22 00:00:00		2007-01-01 00:00:00		2006-01-01 00:00:00		2007-01-01 00:00:00		2006-10-22 00:00:00		2007-07-01 00:00:00		2006-10-01 00:00:00		2013-01-28 00:00:00		None		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-05-19 00:00:00		None		2015-01-01 00:00:00		2014-05-18 00:00:00		2013-07-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2014-05-18 00:00:00		2013-01-01 00:00:00		2014-10-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-03-18 00:00:00		2008-03-18 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-05-18 00:00:00		2008-05-18 00:00:00		2008-10-01 00:00:00		2008-10-01 00:00:00		2008-10-19 00:00:00		None		2005-04-01 00:00:00		2008-10-19 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2010-05-23 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		None		None		2010-01-01 00:00:00		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2012-01-01 00:00:00		2012-03-20 00:00:00		2012-01-01 00:00:00		None		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-03-18 00:00:00		2012-03-18 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2012-10-03 00:00:00		2014-10-01 00:00:00		2015-01-14 00:00:00		2012-11-01 00:00:00		2012-10-22 00:00:00		2014-07-01 00:00:00		2014-08-15 00:00:00		2013-07-01 00:00:00		2013-01-02 00:00:00		2014-05-19 00:00:00		2014-05-19 00:00:00		None		2012-10-01 00:00:00		2012-10-01 00:00:00		2012-10-01 00:00:00		None		2013-01-29 00:00:00		2012-10-01 00:00:00		2015-12-14 00:00:00		None		2019-01-01 00:00:00		2017-07-01 00:00:00		2018-07-01 00:00:00		2017-07-01 00:00:00		2019-07-01 00:00:00		2017-07-01 00:00:00		None		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		None		2016-01-01 00:00:00		2017-01-27 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		None		2018-01-01 00:00:00		2017-07-31 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-07-01 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		2020-07-01 00:00:00		None		2020-07-01 00:00:00		2019-01-01 00:00:00		2019-10-01 00:00:00		2017-07-01 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2018-01-01 00:00:00		2019-07-01 00:00:00		2021-01-01 00:00:00		2022-05-18 00:00:00		2022-04-24 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2022-05-22 00:00:00		2022-04-13 00:00:00		2022-04-27 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2022-04-24 00:00:00
rpt_end		None		1996-03-09 00:00:00		1995-12-31 00:00:00		None		1996-05-18 00:00:00		1996-03-09 00:00:00		1996-06-30 00:00:00		1996-05-18 00:00:00		1996-12-31 00:00:00		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-03-17 00:00:00		1998-05-16 00:00:00		None		1998-06-30 00:00:00		1998-09-30 00:00:00		1998-10-17 00:00:00		None		1998-12-31 00:00:00		1996-12-31 00:00:00		None		1996-09-30 00:00:00		1999-06-30 00:00:00		None		1995-12-31 00:00:00		1996-09-30 00:00:00		None		1997-06-30 00:00:00		None		1999-12-31 00:00:00		2000-09-30 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		None		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2002-01-19 00:00:00		2002-01-19 00:00:00		2001-09-30 00:00:00		2002-02-16 00:00:00		2002-02-16 00:00:00		2002-09-30 00:00:00		2002-10-19 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-10-19 00:00:00		None		2002-12-31 00:00:00		2002-10-19 00:00:00		2002-12-31 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2004-01-17 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		None		2004-01-17 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-06-30 00:00:00		2004-02-10 00:00:00		2004-10-16 00:00:00		None		2004-09-30 00:00:00		2004-08-11 00:00:00		2004-10-16 00:00:00		2004-09-30 00:00:00		2004-06-30 00:00:00		2002-12-31 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2005-06-30 00:00:00		2004-12-31 00:00:00		2005-12-31 00:00:00		2005-09-30 00:00:00		2005-03-31 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-05-20 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-09-30 00:00:00		2006-09-25 00:00:00		2006-10-21 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2006-05-20 00:00:00		2007-06-30 00:00:00		2006-12-31 00:00:00		2007-12-31 00:00:00		2006-10-21 00:00:00		2013-01-28 00:00:00		None		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-05-19 00:00:00		None		2015-06-30 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2014-05-17 00:00:00		2014-05-17 00:00:00		2014-06-30 00:00:00		2013-06-30 00:00:00		2014-12-31 00:00:00		2014-09-30 00:00:00		2008-03-17 00:00:00		2007-12-31 00:00:00		2008-03-17 00:00:00		2008-05-17 00:00:00		2008-05-17 00:00:00		2008-09-30 00:00:00		2008-09-30 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-10-31 00:00:00		2008-10-31 00:00:00		2008-12-31 00:00:00		None		2005-06-30 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		None		None		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-05-22 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2012-03-17 00:00:00		2012-03-20 00:00:00		2012-03-17 00:00:00		None		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2012-10-03 00:00:00		2014-12-31 00:00:00		2015-01-14 00:00:00		2012-11-01 00:00:00		2012-10-22 00:00:00		2014-09-30 00:00:00		2014-08-15 00:00:00		2013-12-31 00:00:00		2013-01-02 00:00:00		2014-05-19 00:00:00		2014-05-19 00:00:00		None		2012-12-31 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		None		2013-01-29 00:00:00		2012-12-31 00:00:00		2015-12-14 00:00:00		None		2019-06-30 00:00:00		2017-12-31 00:00:00		2018-12-31 00:00:00		2017-12-31 00:00:00		2019-09-30 00:00:00		2017-12-31 00:00:00		None		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		None		2016-06-30 00:00:00		2017-01-27 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		None		2018-06-30 00:00:00		2017-07-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		2017-12-31 00:00:00		2020-06-30 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		None		2020-12-31 00:00:00		2019-06-30 00:00:00		2019-12-31 00:00:00		2017-12-31 00:00:00		2018-06-30 00:00:00		2018-12-31 00:00:00		2018-06-30 00:00:00		2018-06-30 00:00:00		2019-09-30 00:00:00		2021-06-30 00:00:00		2022-05-18 00:00:00		2022-05-21 00:00:00		2022-04-23 00:00:00		2021-06-30 00:00:00		2022-04-23 00:00:00		2022-06-30 00:00:00		2022-04-13 00:00:00		2022-04-27 00:00:00		2021-06-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2022-05-21 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		2001-10-30 00:00:00		2001-10-10 00:00:00		2001-07-31 00:00:00		2002-01-08 00:00:00		None		None		2002-01-22 00:00:00		None		2002-02-18 00:00:00		None		2002-09-30 00:00:00		2002-10-23 00:00:00		2002-07-26 00:00:00		None		None		None		None		2003-01-23 00:00:00		None		None		None		None		2003-10-08 00:00:00		2003-07-30 00:00:00		2004-01-21 00:00:00		2004-01-09 00:00:00		None		None		None		None		2004-08-02 00:00:00		2004-07-28 00:00:00		None		2004-10-20 00:00:00		None		2004-10-05 00:00:00		None		None		None		None		None		2005-01-19 00:00:00		1905-04-21 00:00:00		2005-07-25 00:00:00		None		2006-01-30 00:00:00		2005-10-19 00:00:00		None		None		None		2006-05-22 00:00:00		2006-07-24 00:00:00		None		2006-10-03 00:00:00		None		2006-09-25 00:00:00		None		None		None		None		2007-07-20 00:00:00		2007-01-18 00:00:00		2008-01-30 00:00:00		2006-10-24 00:00:00		None		None		None		None		None		None		2015-07-09 00:00:00		None		2014-05-21 00:00:00		2014-05-21 00:00:00		None		2014-07-02 00:00:00		2013-07-23 00:00:00		None		None		2008-03-24 00:00:00		None		None		2008-05-22 00:00:00		None		None		2008-10-06 00:00:00		2008-07-25 00:00:00		None		2008-11-17 00:00:00		None		None		None		None		2009-01-31 00:00:00		None		None		2010-07-19 00:00:00		2010-04-28 00:00:00		2010-04-28 00:00:00		None		None		2010-05-25 00:00:00		None		None		2011-01-25 00:00:00		None		2011-07-23 00:00:00		None		None		None		2012-03-15 00:00:00		None		None		2012-03-08 00:00:00		None		2012-07-13 00:00:00		2014-01-30 00:00:00		None		None		2012-10-03 00:00:00		2012-10-03 00:00:00		2015-01-14 00:00:00		2015-01-14 00:00:00		2012-11-01 00:00:00		2012-10-22 00:00:00		2014-10-02 00:00:00		2014-08-15 00:00:00		None		None		2014-05-19 00:00:00		2014-05-19 00:00:00		None		None		2013-02-08 00:00:00		None		None		None		2013-01-29 00:00:00		None		None		2019-07-30 00:00:00		2019-01-23 00:00:00		None		None		None		2018-01-17 00:00:00		None		2016-01-11 00:00:00		None		2016-07-08 00:00:00		None		None		None		2017-01-27 00:00:00		None		None		None		None		2017-07-31 00:00:00		None		None		None		2020-01-25 00:00:00		2020-07-29 00:00:00		None		None		2021-01-28 00:00:00		None		None		None		None		2019-01-23 00:00:00		2018-07-25 00:00:00		2019-01-23 00:00:00		2019-10-29 00:00:00		None		2022-05-18 00:00:00		None		2022-04-25 00:00:00		2021-08-02 00:00:00		None		2022-07-23 00:00:00		2022-04-13 00:00:00		2022-04-27 00:00:00		None		2022-01-20 00:00:00		2022-01-20 00:00:00		None		2022-05-24 00:00:00
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		None		None		22001		22001		22001		22001		None		None		None		None		22001		22001		22001		22001		None		22001		22001		None		None		None		None		22001		22001		22001		None		22001		22001		None		None		None		22001		22001		None		22001		None		22006		None		None		None		None		22001		22001		22001		22001		22001		None		None		None		22001		None		22001		None		22001		22001		None		22001		22001		None		None		22001		None		None		22001		None		None		22001		22001		None		22001		None		None		None		None		22001		None		None		22001		22001		22001		None		None		22001		None		None		22001		None		22001		None		None		22001		22001		None		None		22001		None		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		None		22001		None		None		22001		22001		22001		None		22001		22001		None		None		None		22001		None		22001		None		22001		None		None		22001		22001		None		None		None		22001		22001		None		None		None		22001		22001		None		None		22001		None		None		None		None		22001		22001		22001		22001		None		22001		None		22001		22001		None		22001		22001		22001		None		22001		22001		None		22001

Table: filer_to_filer_type

filer_id		1065274		1065274		1065274
filer_type		16		16		16
active		Y		Y		Y
race		0		0		0
session_id		1995		1999		2015
category		0		0		0
category_type		40502		40502		40502
sub_category		40103		40103		40103
effect_dt		1995-07-14 00:00:00		1999-02-02 00:00:00		2015-05-28 00:00:00
sub_category_type		0		0		0
election_type		0		0		0
sub_category_a		S		S		S
nyq_dt		None		1995-07-14 00:00:00		1995-07-14 00:00:00
party_cd		None		None		None
county_cd		18026		18042		18026
district_cd		None		None		None

Table: filer_xref

filer_id		1065274
xref_id		950767
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767		950767
filer_id		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00		2015-05-28 00:00:00
naml		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE, AKA TOC PAC		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE		THOROUGHBRED OWNERS OF CALIFORNIA POLITICAL ACTION COMMITTEE
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
city		ARCADIA		DEL MAR		DEL MAR		DEL MAR		DEL MAR		DEL MAR		DEL MAR		ARCADIA		MONROVIA		ARCADIA		MONROVIA		ARCADIA		MONROVIA		ARCADIA		MONROVIA		ARCADIA		MONROVIA		ARCADIA		DEL MAR		DEL MAR		DEL MAR		DEL MAR		DEL MAR		DEL MAR		ARCADIA		MONROVIA		ARCADIA		MONROVIA		ARCADIA		MONROVIA		ARCADIA		MONROVIA		ARCADIA		MONROVIA		ARCADIA		DEL MAR		DEL MAR		DEL MAR		DEL MAR		DEL MAR		DEL MAR		ARCADIA		MONROVIA		ARCADIA		MONROVIA		ARCADIA		MONROVIA		ARCADIA		MONROVIA		ARCADIA		MONROVIA
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
zip4		91007		92014		92014		92014		92014		92014		92014		91007		91017		91007		91017		91007		91017		91007		91017		91007		91017		91007		92014		92014		92014		92014		92014		92014		91007		91017		91007		91017		91007		91017		91007		91017		91007		91017		91007		92014		92014		92014		92014		92014		92014		91007		91017		91007		91017		91007		91017		91007		91017		91007		91017
phon		8587941018		6197941018		(858) 794-1019		(858) 794-1019		8587941019		8587941019		8587941019		6265746621				6265746602				6265746620				6265746621				6265746621				8587941018		6197941018		(858) 794-1019		(858) 794-1019		8587941019		8587941019		8587941019		6265746621				6265746602				6265746620				6265746621				6265746621				8587941018		6197941018		(858) 794-1019		(858) 794-1019		8587941019		8587941019		8587941019		6265746621				6265746602				6265746620				6265746621				6265746621
fax		None		6197945331		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		6197945331		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		6197945331		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		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		[email protected]		None		[email protected]		None		[email protected]		None

Table: filers

filer_id		1065274

Table: received_filings

filer_id		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274		1065274
filing_file_name		786106_0.cal		404366.cal		404343.cal		404813.cal		772627_0.cal		59845.cal		60063.cal		786106_1.cal		471522.cal		803887_0.cal		808794_0.cal		820751_0.cal		852206_0.cal		869780_0.cal		876830_0.cal		905251_0.cal		946360_0.cal		962519_0.cal		130757.cal		979274_0.cal		93491.cal		150060.cal		150086.cal		150199.cal		1851526_0.cal		1851526_1.cal		1700924_0.cal		1711026_0.cal		1878151_0.cal		1925487_0.cal		2665871_1.cal		2665871_0.cal		2672051_0.cal
received_date		2001-10-10 00:00:00		2001-10-10 00:00:00		2001-10-10 00:00:00		2001-10-10 00:00:00		2001-07-31 00:00:00		2001-10-30 00:00:00		2001-10-30 00:00:00		2001-10-31 00:00:00		2002-01-08 00:00:00		2002-01-08 00:00:00		2002-01-22 00:00:00		2002-02-18 00:00:00		2002-07-26 00:00:00		2002-09-30 00:00:00		2002-10-23 00:00:00		2003-01-23 00:00:00		2003-07-30 00:00:00		2003-10-08 00:00:00		2004-01-09 00:00:00		2004-01-09 00:00:00		2004-02-10 00:00:00		2004-08-19 00:00:00		2004-08-19 00:00:00		2004-08-19 00:00:00		2014-05-19 00:00:00		2014-05-19 00:00:00		2012-10-22 00:00:00		2012-11-01 00:00:00		2014-08-16 00:00:00		2015-01-14 00:00:00		2022-05-18 00:00:00		2022-04-13 00:00:00		2022-04-27 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/temp		/usr/users/cafiler/disclose/ca99/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		/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/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		786106		None		None		None		772627		None		None		786106		None		803887		808794		820751		852206		869780		876830		905251		946360		962519		None		979274		None		None		None		None		1851526		1851526		1700924		1711026		1878151		1925487		2665871		2665871		2672051
form_id		F460		None		None		None		F460		None		None		F460		None		F460		F460		F460		F460		F460		F460		F460		F460		F460		None		F460		None		None		None		None		F497		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted, but with warnings		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		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 did not pass validation		Filing accepted, but with warnings		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted