Home

Filer ID: 1010689

Table: filer_address

filer_id		1010689		1010689
adrid		1009999		2179948
effect_dt		1990-12-01 00:00:00		2010-03-03 00:00:00
add_type		7051		7051
session_id		2007		2009

Table: filer_filings

filer_id		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689
filing_id		66891		66892		66893		66894		66895		66896		203796		578049		580491		593931		593934		593937		593940		593944		593951		593954		593960		594897		594907		594909		594911		594913		594929		594931		594932		679188		679264		675452		717956		751384		675452		787893		809261		787893		912346		923991		965044		955773		986786		1079326		1099088		1117091		1121830		1145569		1188988		1178761		1181654		1202329		1218940		1221620		1253679		1232515		1253679		1282260		1232515		1286475		1271168		1781049		1980967		1872134		1786620		1935303		1954974		1878531		1904206		1315588		1310062		1354985		1402030		1395081		1423977		1433036		1438239		1443448		1438239		1431612		1443448		1470262		1463289		1502893		1510643		1533266		1544497		1568979		1576767		1608150		1611599		1639830		1635095		1678196		1827642		1816948		1683941		1735483		1822845		1847664		1837436		1747994		1998217		1967625		1985669		2407339		2289846		2399544		2515313		2184795		2260099		2184795		2422189		2022080		1999073		2011149		2064733		2068001		2074555		2078504		2088736		2091742		2096914		2144068		2131253		2195834		2418870		2308494		2370467		2516470		2512964		2292181		2443641		2193592		2210104		2457449		2528543		2350429		2228891		2275910		2653653		2553176		2512964		2622613		2608123		2683102		2564545		2601268		2719904		2716839		2627254		2641259		2752213
period_id		105		137		145		153		157		159		148		None		None		None		None		None		None		None		None		None		None		161		161		161		161		161		161		161		161		None		164		None		163		None		None		None		None		None		169		None		None		None		None		177		None		181		None		183		185		186		None		None		188		None		None		187		None		189		187		None		None		213		221		217		None		219		None		None		220		None		191		None		None		195		None		None		197		None		197		198		None		None		199		201		None		204		None		203		None		205		None		None		207		209		217		215		None		211		None		218		218		None		223		222		None		None		None		237		None		None		None		None		None		None		None		224		225		227		None		227		228		228		228		None		227		None		239		236		None		244		244		235		240		231		232		None		244		235		None		233		None		243		244		247		None		250		None		245		None		251		None		248		252
form_id		F461		F461		F461		F461		F461		F461		F497		F999		F461		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F497		F461		F461		F461		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F461		F497		F461		F461		F461		F461		F497		F497		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F497		F497		F497		F461		F461		F461		F461		F497		F461		F497		F497		F497		F461		F461		F461		F461		F497		F461		F461		F461		F461		F461		F497		F461		F461		F497		F461		F461		F461		F497		F461		F461		F497
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		1		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		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		1		0		0		0		0		0		0		0		0		0		0
filing_date		1986-07-31 00:00:00		1995-01-31 00:00:00		1997-01-31 00:00:00		1999-02-01 00:00:00		1999-08-02 00:00:00		1999-10-12 00:00:00		1996-10-22 00:00:00		2000-01-21 00:00:00		2000-01-28 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-28 00:00:00		2000-02-28 00:00:00		2000-02-28 00:00:00		2000-02-28 00:00:00		2000-02-28 00:00:00		2000-02-28 00:00:00		2000-02-28 00:00:00		2000-02-28 00:00:00		2000-10-27 00:00:00		2000-10-27 00:00:00		2000-07-31 00:00:00		2001-01-30 00:00:00		2001-01-31 00:00:00		2001-02-01 00:00:00		2001-10-10 00:00:00		2002-01-10 00:00:00		2001-11-21 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2003-10-14 00:00:00		2003-07-31 00:00:00		2004-01-13 00:00:00		2005-01-30 00:00:00		2005-01-31 00:00:00		2005-07-29 00:00:00		2005-08-01 00:00:00		2006-01-27 00:00:00		2006-07-28 00:00:00		2006-06-02 00:00:00		2006-01-31 00:00:00		2006-07-31 00:00:00		2006-11-02 00:00:00		2006-06-02 00:00:00		2007-01-31 00:00:00		2007-01-26 00:00:00		2007-03-06 00:00:00		2007-07-28 00:00:00		2007-03-06 00:00:00		2007-07-31 00:00:00		2006-11-02 00:00:00		2013-07-30 00:00:00		2015-07-30 00:00:00		2014-07-31 00:00:00		2013-07-31 00:00:00		2015-01-31 00:00:00		2015-02-02 00:00:00		2014-07-31 00:00:00		2014-10-23 00:00:00		2008-01-31 00:00:00		2008-01-30 00:00:00		2008-07-31 00:00:00		2009-02-02 00:00:00		2009-01-30 00:00:00		2009-05-13 00:00:00		2009-07-18 00:00:00		2009-07-31 00:00:00		2009-07-30 00:00:00		2009-09-04 00:00:00		2009-07-18 00:00:00		2009-09-08 00:00:00		2010-02-01 00:00:00		2010-01-29 00:00:00		2010-07-25 00:00:00		2010-08-02 00:00:00		2010-10-23 00:00:00		2010-10-23 00:00:00		2011-01-28 00:00:00		2011-01-28 00:00:00		2011-08-01 00:00:00		2011-08-01 00:00:00		2012-01-31 00:00:00		2012-01-30 00:00:00		2012-07-31 00:00:00		2014-03-12 00:00:00		2014-01-30 00:00:00		2012-07-31 00:00:00		2013-01-29 00:00:00		2014-01-31 00:00:00		2014-05-06 00:00:00		2014-04-09 00:00:00		2013-01-31 00:00:00		2015-11-02 00:00:00		2015-05-07 00:00:00		2015-07-31 00:00:00		2019-07-31 00:00:00		2018-07-31 00:00:00		2019-07-31 00:00:00		2020-07-27 00:00:00		2017-07-31 00:00:00		2018-04-06 00:00:00		2018-04-06 00:00:00		2019-10-31 00:00:00		2016-02-01 00:00:00		2015-11-02 00:00:00		2016-01-30 00:00:00		2016-08-01 00:00:00		2016-08-12 00:00:00		2016-07-30 00:00:00		2016-09-16 00:00:00		2016-10-13 00:00:00		2016-10-19 00:00:00		2016-10-26 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-10-31 00:00:00		2019-10-31 00:00:00		2018-10-18 00:00:00		2019-01-31 00:00:00		2020-10-15 00:00:00		2020-10-10 00:00:00		2018-09-14 00:00:00		2020-01-31 00:00:00		2017-10-31 00:00:00		2018-01-31 00:00:00		2020-01-31 00:00:00		2020-10-30 00:00:00		2019-01-31 00:00:00		2018-01-31 00:00:00		2018-07-31 00:00:00		2022-01-31 00:00:00		2021-02-01 00:00:00		2020-10-29 00:00:00		2021-10-29 00:00:00		2021-08-02 00:00:00		2022-05-16 00:00:00		2021-02-01 00:00:00		2021-07-30 00:00:00		2022-08-02 00:00:00		2022-09-02 00:00:00		2021-11-01 00:00:00		2022-01-28 00:00:00		2022-11-04 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10005		10006		10005		10005		10006		10001		10005		10005		10005		10005		10001		10005		10001		10005		10001		10001		10001		10005		10005		10001		10005		10005		10001		10006		10001		10002		10005		10005		10001		10001		10001		10005		10001		10005		10005		10001		10005		10001		10005		10005		10001		10005		10005		10001		10005		10002		10001		10006		10005		10001		10001		10005		10001		10005		10001		10005		10001		10005		10005		10001		10001		10001		10001		10005		10001		10005		10001		10001		10005		10001		10001		10005		10005		10006		10001		10005		10005		10001		10006		10005		10005		10005		10001		10001		10001		10005		10001		10001		10001		10001		10005		10001		10005		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10005		10001		10005		10001		10002		10001		10005		10001		10005		10001		10005		10001		10005		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		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		11003		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003
session_id		1985		1993		1995		1997		1999		1999		1995		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2007		2005		2013		2015		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2009		2005		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2013		2013		2011		2011		2013		2013		2013		2011		2015		2015		2015		2019		2017		2019		2019		2017		2017		2017		2019		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2019		2017		2019		2019		2019		2017		2019		2017		2017		2019		2019		2017		2017		2017		2021		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		BSMITH		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		SARRIAGA		*		EMCENTEE		*		EMCENTEE		EMCENTEE		JBRANNON		LTHIBAUL		DBARRICK		COMPLETED		LTHIBAUL		DHORRELL		GGILMORE		GKURIMOT		COMPLETED		DHORRELL		*		KLARRY		*		*		DJOHNSON		RGEREMIA		JMARTIN		DHORRELL		EMCENTEE		JMARTIN		*		JMARTIN		*		*		JMARTIN		RGEREMIA		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		WBROWN		SMCCABE		SMCCABE		MGUERRA		JINGRAM		JINGRAM		GKURIMOT		JINGRAM		JINGRAM		JINGRAM		*		DHORRELL		JVAZQUEZ		JINGRAM		JINGRAM		JINGRAM		JINGRAM		CREYNOLDS		MPACHECO		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		WBROWN		JINGRAM		JINGRAM		JINGRAM		JINGRAM		WBROWN		WBROWN		JINGRAM		JINGRAM		GKURIMOT		JINGRAM		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		LPALMER		GTAYLOR		DMCCASTL		GTAYLOR		JINGRAM		JINGRAM		JINGRAM		JINGRAM		GCLARA		JINGRAM		PDEO		PDEO		PDEO		PDEO		JINGRAM		JINGRAM		LPALMER		GTAYLOR		GKURIMOT		GTAYLOR		CAFILER		CAFILER		GKURIMOT		GTAYLOR		LPALMER		LPALMER		GTAYLOR		CAFILER		GTAYLOR		LPALMER		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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
fine_audit		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		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11003		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003
rpt_start		1986-01-01 00:00:00		1994-01-01 00:00:00		1996-01-01 00:00:00		1998-01-01 00:00:00		1999-01-01 00:00:00		1999-07-01 00:00:00		None		None		1999-10-01 00:00:00		None		None		None		None		None		None		None		None		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		None		2000-10-27 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2000-07-01 00:00:00		2000-01-01 00:00:00		2001-01-01 00:00:00		2001-10-01 00:00:00		2001-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-06-02 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-11-02 00:00:00		None		2006-07-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		None		2013-01-01 00:00:00		2015-01-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2014-10-23 00:00:00		2007-07-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		None		2006-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-05-13 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-10-23 00:00:00		None		2010-07-01 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2014-03-12 00:00:00		2013-07-01 00:00:00		2012-01-01 00:00:00		2012-07-01 00:00:00		2013-07-01 00:00:00		2014-05-06 00:00:00		2014-04-09 00:00:00		2012-07-01 00:00:00		2015-07-01 00:00:00		2015-05-07 00:00:00		2015-01-01 00:00:00		2019-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2020-01-01 00:00:00		2017-01-01 00:00:00		2018-01-01 00:00:00		2017-01-01 00:00:00		2019-07-01 00:00:00		2015-10-01 00:00:00		2015-07-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-08-12 00:00:00		2016-01-01 00:00:00		2016-09-16 00:00:00		2016-10-13 00:00:00		2016-10-19 00:00:00		2016-10-26 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2017-07-01 00:00:00		2019-07-01 00:00:00		2018-10-18 00:00:00		2018-07-01 00:00:00		2020-10-15 00:00:00		2020-10-10 00:00:00		2018-09-14 00:00:00		2019-10-01 00:00:00		2017-07-01 00:00:00		2017-10-01 00:00:00		2019-10-01 00:00:00		2020-10-30 00:00:00		2018-07-01 00:00:00		2017-10-01 00:00:00		2018-01-01 00:00:00		2021-10-01 00:00:00		2020-07-01 00:00:00		2020-10-29 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2022-05-16 00:00:00		2020-07-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2022-09-02 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2022-11-03 00:00:00
rpt_end		1986-06-30 00:00:00		1994-12-31 00:00:00		1996-12-31 00:00:00		1998-12-31 00:00:00		1999-06-30 00:00:00		1999-09-30 00:00:00		None		None		1999-12-31 00:00:00		None		None		None		None		None		None		None		None		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		None		2000-10-27 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-06-02 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-11-02 00:00:00		None		2006-12-31 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		None		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2013-06-30 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2014-06-30 00:00:00		2014-10-23 00:00:00		2007-12-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2008-12-31 00:00:00		None		2006-12-31 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-05-13 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-10-23 00:00:00		None		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2014-03-12 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2012-12-31 00:00:00		2013-12-31 00:00:00		2014-05-06 00:00:00		2014-04-09 00:00:00		2012-12-31 00:00:00		2015-09-30 00:00:00		2015-05-07 00:00:00		2015-06-30 00:00:00		2019-06-30 00:00:00		2018-06-30 00:00:00		2019-06-30 00:00:00		2020-06-30 00:00:00		2017-06-30 00:00:00		2018-06-30 00:00:00		2017-06-30 00:00:00		2019-09-30 00:00:00		2015-12-31 00:00:00		2015-09-30 00:00:00		2015-12-31 00:00:00		2016-06-30 00:00:00		2016-08-12 00:00:00		2016-06-30 00:00:00		2016-09-16 00:00:00		2016-10-13 00:00:00		2016-10-19 00:00:00		2016-10-26 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-09-30 00:00:00		2019-09-30 00:00:00		2018-10-18 00:00:00		2018-12-31 00:00:00		2020-10-15 00:00:00		2020-10-10 00:00:00		2018-09-14 00:00:00		2019-12-31 00:00:00		2017-09-30 00:00:00		2017-12-31 00:00:00		2019-12-31 00:00:00		2020-10-30 00:00:00		2018-12-31 00:00:00		2017-12-31 00:00:00		2018-06-30 00:00:00		2021-12-31 00:00:00		2020-12-31 00:00:00		2020-10-29 00:00:00		2021-09-30 00:00:00		2021-06-30 00:00:00		2022-05-16 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		2022-09-02 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2022-11-03 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-02-24 00:00:00		2000-10-27 00:00:00		2000-10-27 00:00:00		None		2001-01-30 00:00:00		None		None		None		None		None		2003-01-31 00:00:00		None		None		None		None		2005-01-30 00:00:00		None		2005-07-29 00:00:00		None		2006-01-27 00:00:00		2006-07-28 00:00:00		2006-06-02 00:00:00		None		None		2006-11-02 00:00:00		None		None		2007-01-26 00:00:00		None		2007-07-28 00:00:00		2007-03-06 00:00:00		None		None		2013-07-30 00:00:00		2015-07-30 00:00:00		2014-07-31 00:00:00		None		2015-01-31 00:00:00		None		None		2014-10-23 00:00:00		None		2008-01-30 00:00:00		None		None		2009-01-30 00:00:00		None		None		2009-07-31 00:00:00		None		2009-09-03 00:00:00		2009-05-13 00:00:00		None		None		2010-01-29 00:00:00		2010-07-25 00:00:00		None		2010-10-23 00:00:00		None		2011-01-28 00:00:00		None		2011-08-01 00:00:00		None		None		2012-01-30 00:00:00		2012-07-31 00:00:00		2014-03-12 00:00:00		2014-01-30 00:00:00		None		2013-01-29 00:00:00		None		2014-05-06 00:00:00		2014-04-09 00:00:00		None		2015-11-02 00:00:00		2015-05-07 00:00:00		None		None		None		2019-07-31 00:00:00		None		None		None		None		None		None		None		2016-01-21 00:00:00		2016-08-01 00:00:00		2016-08-12 00:00:00		None		2016-09-16 00:00:00		2016-10-13 00:00:00		2016-10-19 00:00:00		2016-10-26 00:00:00		None		2017-01-12 00:00:00		None		2019-10-31 00:00:00		2018-10-18 00:00:00		None		2020-10-15 00:00:00		2020-10-10 00:00:00		2018-09-14 00:00:00		2020-01-31 00:00:00		2017-10-31 00:00:00		2018-01-31 00:00:00		None		2020-10-30 00:00:00		2019-01-31 00:00:00		None		2018-07-03 00:00:00		None		2021-01-31 00:00:00		2020-10-29 00:00:00		2021-11-01 00:00:00		None		2022-05-16 00:00:00		None		2021-07-31 00:00:00		None		2022-09-02 00:00:00		None		2022-01-31 00:00:00		2022-11-03 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		22001		None		None		None		None		22001		None		22001		None		22001		22001		22001		None		None		22001		None		None		22001		None		22001		22001		None		None		22001		22001		22001		None		22001		None		None		22001		None		22001		None		None		22001		None		None		22001		None		22001		22001		None		None		22001		22001		None		22001		None		22001		None		22001		None		None		22001		22001		22001		22001		None		22001		None		22001		22001		None		22001		22001		None		None		None		22001		None		None		None		None		None		None		None		22001		22001		22001		None		22001		22001		22001		22001		None		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22001		None		22001		22001		22001		None		22001		None		22001		None		22001		None		22001		22001

Table: filer_to_filer_type

filer_id		1010689
filer_type		10
active		Y
race		0
session_id		2007
category		0
category_type		40502
sub_category		0
effect_dt		1990-12-01 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		0
county_cd		18026
district_cd		0

Table: filer_xref

filer_id		1010689
xref_id		486161
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		486161		486161		486161		486161		486161		486161
filer_id		1010689		1010689		1010689		1010689		1010689		1010689
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00		1990-12-01 00:00:00
naml		MERCK, SHARP & DOHME CORP. AND AFFILIATED ENTITIES		MERCK, SHARP & DOHME CORP. AND AFFILIATED ENTITIES		MERCK, SHARP & DOHME CORP.		MERCK, SHARP & DOHME CORP.		MERCK & CO., INC.		MERCK & CO., INC.
namf		None		None		None		None		None		None
namt		None		None		None		None		None		None
nams		None		None		None		None		None		None
adr1		None		None		None		None		None		None
adr2		None		None		None		None		None		None
city		WEST POINT		NORTH WALES		WEST POINT		NORTH WALES		WEST POINT		NORTH WALES
st		PA		PA		PA		PA		PA		PA
zip4		194860000		194540000		194860000		194540000		194860000		194540000
phon		4153896800		4153896800		4153896800		4153896800		4153896800		4153896800
fax		None		None		None		None		None		None
email		None		None		None		None		None		None

Table: filers

filer_id		1010689

Table: received_filings

filer_id		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689		1010689
filing_file_name		679264_0.cal		717956_0.cal		912346_0.cal		1079326_0.cal		1117091_0.cal		1145569_0.cal		1502893_0.cal		1395081_0.cal		1438239_1.cal		1232515_0.cal		1232515_1.cal		1282260_0.cal		1438239_0.cal		1310062_0.cal		1463289_0.cal		1735483_0.cal		1678196_0.cal		1608150_0.cal		1635095_0.cal		2091742_0.cal		2516470_0.cal		2528543_0.cal
received_date		2000-10-27 00:00:00		2001-01-30 00:00:00		2003-01-31 00:00:00		2005-01-30 00:00:00		2005-07-29 00:00:00		2006-01-27 00:00:00		2010-07-25 00:00:00		2009-01-30 00:00:00		2009-09-04 00:00:00		2007-01-26 00:00:00		2007-03-06 00:00:00		2007-07-28 00:00:00		2009-07-31 00:00:00		2008-01-30 00:00:00		2010-01-29 00:00:00		2013-01-29 00:00:00		2012-07-31 00:00:00		2011-08-01 00:00:00		2012-01-30 00:00:00		2016-10-19 00:00:00		2020-10-15 00:00:00		2020-10-30 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		679264		717956		912346		1079326		1117091		1145569		1502893		1395081		1438239		1232515		1232515		1282260		1438239		1310062		1463289		1735483		1678196		1608150		1635095		2091742		2516470		2528543
form_id		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F497
receive_comment		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted