Home

Filer ID: 1066578

Table: filer_address

filer_id		1066578		1066578		1066578		1066578
adrid		1075547		1075548		2123903		2246777
effect_dt		1995-12-04 00:00:00		1995-12-04 00:00:00		2007-02-01 00:00:00		2012-09-04 00:00:00
add_type		7051		7051		7051		7051
session_id		1995		1995		2007		2011

Table: filer_filings

filer_id		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578
filing_id		389470		389471		389472		389473		389474		389475		389476		442562		442563		389469		653765		655160		728427		785095		784734		831928		865951		849946		886259		884017		913736		951898		983140		981850		972074		1026517		1073030		1092670		1092674		1115462		1121452		1116166		1147371		1145127		1185045		1185262		1254229		1236943		1280694		1267923		1299121		1776071		1775798		1975584		1943049		1928031		1974744		1864205		1853885		1851946		1853885		1943049		1911688		1901211		1320109		1310822		1322198		1315782		1348605		1352415		1374977		1399670		1397613		1376543		1416845		1396464		1432789		1434399		1467714		1474098		1474098		1479143		1494483		1494483		1460956		1509470		1522389		1522389		1504853		1498378		1498378		1479143		1525570		1525570		1570449		1575106		1608980		1636631		1607009		1641156		1676864		1814180		1693633		1399670		1683243		1928031		1710948		1702787		1862607		1821483		1733039		1848884		1850175		1814180		1851946		1821483		1749041		1991331		1991726		2276600		2204952		2308137		2313341		2313341		2300658		2520532		2278794		2504907		2395872		2007212		2004380		2033489		2037215		2055727		2070921		2101943		2123087		2145257		2178233		2282361		2175918		2451344		2458228		2308137		2517139		2494952		2390858		2486281		2549899		2312885		2533666		2454385		2278794		2296825		2276600		2215018		2534200		2282691		2356126		2337010		2322458		2437583		2592993		2549899		2454920		2506180		2564673		2534200		2564673		2636687		2635081		2592574		2700733		2742816		2731474
period_id		145		145		145		149		151		155		157		147		153		144		None		None		None		None		None		None		157		None		None		None		None		None		None		None		None		None		None		165		165		179		None		181		None		183		None		185		None		187		189		None		None		None		213		None		None		219		221		None		None		217		None		None		220		220		193		191		None		None		193		None		196		197		None		None		None		195		197		None		None		201		201		None		None		None		199		None		203		203		202		201		201		None		None		None		204		None		None		207		205		None		209		215		None		211		None		219		None		211		218		None		212		218		218		215		217		None		None		223		None		233		231		236		236		236		None		243		None		243		None		None		224		225		None		226		None		228		227		None		None		235		229		None		None		236		244		None		237		241		244		235		None		241		None		235		233		None		None		235		None		236		None		239		None		244		241		243		None		None		None		None		247		245		249		251		None
form_id		F420		F420		F405		F420		F420		F420		F420		F420		F420		F410		F450		F460		F460		F460		F460		F460		F666		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F666		F666		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F497		F410		F460		F497		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F410		F460		F460		F460		F460		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F497		F497		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F497		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		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		0		0		0		0		0		0		0		0		1		1		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		1		0		0		0		1		0		0		1		0		0		1		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		0		0		0		1		0		0		0		0		0		1		0		1		1		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		1		0		0		0		1		1		0		0		0		0		0		0
filing_date		1996-03-16 00:00:00		1996-07-31 00:00:00		1997-02-04 00:00:00		1998-04-21 00:00:00		1998-04-21 00:00:00		1999-02-01 00:00:00		1999-08-02 00:00:00		1997-01-31 00:00:00		1998-07-31 00:00:00		1995-11-29 00:00:00		2000-08-09 00:00:00		2000-08-09 00:00:00		2001-02-07 00:00:00		2001-07-31 00:00:00		2001-07-30 00:00:00		2002-02-01 00:00:00		2002-09-03 00:00:00		2002-07-11 00:00:00		2002-10-23 00:00:00		2002-10-07 00:00:00		2002-10-23 00:00:00		2003-07-25 00:00:00		2003-09-23 00:00:00		2004-01-07 00:00:00		2003-10-10 00:00:00		2004-07-22 00:00:00		2005-01-12 00:00:00		2005-02-28 00:00:00		2005-02-28 00:00:00		2005-07-27 00:00:00		2005-08-01 00:00:00		2005-07-28 00:00:00		2006-01-30 00:00:00		2006-01-27 00:00:00		2006-07-11 00:00:00		2006-07-20 00:00:00		2007-01-31 00:00:00		2007-01-31 00:00:00		2007-07-25 00:00:00		2007-02-01 00:00:00		2007-11-08 00:00:00		2013-07-16 00:00:00		2013-07-16 00:00:00		2015-07-16 00:00:00		2015-07-16 00:00:00		2015-07-16 00:00:00		2015-07-16 00:00:00		2014-07-15 00:00:00		2014-05-20 00:00:00		2014-07-14 00:00:00		2014-07-15 00:00:00		2015-01-22 00:00:00		2014-10-31 00:00:00		2014-10-21 00:00:00		2008-03-24 00:00:00		2008-01-31 00:00:00		2008-03-25 00:00:00		2008-01-31 00:00:00		2008-07-30 00:00:00		2008-07-31 00:00:00		2008-10-29 00:00:00		2009-02-04 00:00:00		2009-01-30 00:00:00		2008-10-29 00:00:00		2009-02-10 00:00:00		2009-01-31 00:00:00		2009-07-23 00:00:00		2009-07-27 00:00:00		2010-02-01 00:00:00		2010-04-19 00:00:00		2010-03-22 00:00:00		2010-04-27 00:00:00		2010-07-12 00:00:00		2010-05-27 00:00:00		2010-01-27 00:00:00		2010-08-02 00:00:00		2010-10-14 00:00:00		2010-10-05 00:00:00		2010-07-29 00:00:00		2010-07-03 00:00:00		2010-06-23 00:00:00		2010-04-02 00:00:00		2010-10-18 00:00:00		2010-10-05 00:00:00		2011-01-31 00:00:00		2011-01-31 00:00:00		2011-08-01 00:00:00		2012-01-31 00:00:00		2011-07-29 00:00:00		2012-01-31 00:00:00		2012-07-30 00:00:00		2014-01-28 00:00:00		2012-09-04 00:00:00		2012-08-31 00:00:00		2012-07-31 00:00:00		2015-01-22 00:00:00		2012-10-25 00:00:00		2012-10-25 00:00:00		2014-07-14 00:00:00		2014-05-20 00:00:00		2013-01-27 00:00:00		2014-05-09 00:00:00		2014-05-15 00:00:00		2014-05-20 00:00:00		2014-05-20 00:00:00		2014-01-29 00:00:00		2013-01-31 00:00:00		2015-10-09 00:00:00		2015-10-09 00:00:00		2018-09-27 00:00:00		2018-01-24 00:00:00		2018-10-25 00:00:00		2018-10-25 00:00:00		2018-10-25 00:00:00		2018-09-26 00:00:00		2020-10-22 00:00:00		2018-09-28 00:00:00		2020-09-24 00:00:00		2019-07-18 00:00:00		2016-01-19 00:00:00		2016-01-18 00:00:00		2016-04-27 00:00:00		2016-04-27 00:00:00		2016-07-17 00:00:00		2016-07-18 00:00:00		2016-10-31 00:00:00		2017-01-25 00:00:00		2017-01-25 00:00:00		2017-07-31 00:00:00		2018-08-10 00:00:00		2017-07-31 00:00:00		2020-01-29 00:00:00		2020-02-20 00:00:00		2018-10-17 00:00:00		2020-10-16 00:00:00		2020-07-31 00:00:00		2019-07-18 00:00:00		2020-07-31 00:00:00		2021-01-28 00:00:00		2018-10-25 00:00:00		2020-09-24 00:00:00		2020-02-19 00:00:00		2018-07-31 00:00:00		2018-09-27 00:00:00		2018-07-31 00:00:00		2018-01-26 00:00:00		2020-10-22 00:00:00		2018-08-13 00:00:00		2019-01-22 00:00:00		2019-01-22 00:00:00		2018-10-26 00:00:00		2020-01-29 00:00:00		2021-07-12 00:00:00		2021-09-02 00:00:00		2020-02-20 00:00:00		2020-09-25 00:00:00		2021-01-29 00:00:00		2021-09-02 00:00:00		2021-09-02 00:00:00		2022-01-18 00:00:00		2022-01-18 00:00:00		2021-07-12 00:00:00		2022-07-25 00:00:00		2022-10-27 00:00:00		2022-07-25 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10005		10001		10005		10001		10005		10001		10005		10001		10001		10002		10005		10005		10001		10005		10006		10002		10001		10005		10005		10002		10006		10005		10001		10001		10001		10001		10005		10005		10001		10005		10001		10001		10005		10005		10006		10001		10001		10005		10005		10002		10001		10006		10006		10005		10001		10005		10002		10001		10001		10002		10001		10005		10006		10005		10001		10005		10005		10001		10001		10005		10001		10001		10006		10002		10005		10001		10005		10001		10001		10006		10001		10001		10001		10002		10001		10005		10005		10001		10005		10002		10001		10002		10002		10001		10005		10001		10002		10001		10005		10005		10001		10001		10005		10001		10005		10001		10001		10005		10005		10001		10001		10005		10005		10001		10001		10005		10001		10001		10001		10001		10005		10001		10005		10001		10001		10005		10005		10001		10005		10001		10005		10001		10005		10002		10001		10001		10005		10006		10006		10005		10001		10001		10001		10001		10005
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11003		11001		11001		11001		11003		11003		11003
session_id		1995		1995		1995		1997		1997		1997		1999		1995		1997		1995		1999		1999		1999		2001		2001		2001		1999		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2001		2001		2003		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2013		2013		2015		2013		2013		2015		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2009		2009		2007		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2013		2011		2011		2011		2013		2011		2011		2013		2013		2011		2013		2013		2013		2013		2013		2011		2015		2015		2017		2017		2017		2017		2017		2017		2019		2017		2019		2019		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2019		2019		2017		2019		2019		2019		2019		2019		2017		2019		2019		2017		2017		2017		2017		2019		2017		2017		2017		2017		2019		2021		2019		2019		2019		2019		2019		2019		2021		2021		2021		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		DHORRELL		JLEHMAN		DHORRELL		LTHIBAUL		GPEREZ		GPEREZ		PROBERTS		DHORRELL		DBARRICK		DBARRICK		DBARRICK		KVOONG1		KLARRY		GGILMORE		GGILMORE		GKURIMOT		GKURIMOT		PROBERTS		PROBERTS		DHORRELL		CFLAGG		*		SARRIAGA		*		DHORRELL		DHORRELL		DHORRELL		DHORRELL		*		NWALKER		SARRIAGA		MPACHECO		CPON		CPON		MPACHECO		CAFILER		CPON		MPACHECO		MDIGRAZIA		CAFILER		MPACHECO		GCLARA		CAFILER		CAFILER		*		*		DHORRELL		SARRIAGA		CPON		CPON		DHORRELL		*		JVAZQUEZ		EMCENTEE		RGEREMIA		*		CPON		CPON		CPON		MMORENO		MMORENO		NWALKER		MPACHECO		MMORENO		CPON		MMORENO		*		SMCCONNAN		MMORENO		*		MMORENO		NWALKER		MPACHECO		MPACHECO		SMCCONNAN		SMCCONNAN		CPON		MDIGRAZIA		CPON		MDIGRAZIA		CPON		CAFILER		TRAMON		TRAMON		CPON		CAFILER		MPACHECO		CAFILER		CAFILER		MPACHECO		CAFILER		CAFILER		CAFILER		MDIGRAZIA		MDIGRAZIA		MPACHECO		MPACHECO		SARRIAGA		SARRIAGA		CAFILER		LBARTHOL		CAFILER		RGEREMIA		RGEREMIA		LBARTHOL		KRUSSELL		RPOOJA		KRUSSELL		HCOURSEY		SMCCONNAN		SMCCONNAN		SARRIAGA		SARRIAGA		SARRIAGA		SARRIAGA		PDEO		SARRIAGA		SARRIAGA		CSAGABAEN		CAFILER		CSAGABAEN		VUKSTINA		HCOURSEY		CAFILER		CAFILER		KRUSSELL		HCOURSEY		KRUSSELL		BCOLON		YMORA		KRUSSELL		RGEREMIA		CSAGABAEN		LBARTHOL		CSAGABAEN		LBARTHOL		KRUSSELL		CAFILER		LPHEAV		LPHEAV		YMORA		VUKSTINA		SARRIAGA		CAFILER		HCOURSEY		CAFILER		BCOLON		JMAVES		JMAVES		KRUSSELL		KRUSSELL		SARRIAGA		CAFILER		CAFILER		AXIONG
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11001		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		1996-01-25 00:00:00		1996-03-10 00:00:00		1996-01-01 00:00:00		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-07-01 00:00:00		1999-01-01 00:00:00		1996-07-01 00:00:00		1998-01-01 00:00:00		None		2000-01-01 00:00:00		1999-07-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		1999-01-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-09-21 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2004-07-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		None		2007-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2014-07-01 00:00:00		2014-07-01 00:00:00		2015-01-01 00:00:00		2014-05-18 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2014-07-01 00:00:00		2014-10-31 00:00:00		2014-10-20 00:00:00		2008-01-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2007-07-01 00:00:00		2008-03-18 00:00:00		2008-03-18 00:00:00		2008-10-29 00:00:00		2009-02-04 00:00:00		2008-07-01 00:00:00		None		None		2008-07-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-03-18 00:00:00		2010-03-18 00:00:00		2009-07-01 00:00:00		2010-05-23 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2010-05-23 00:00:00		2010-03-18 00:00:00		2010-03-18 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2010-07-01 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		None		2012-08-31 00:00:00		2012-01-01 00:00:00		2014-07-01 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2014-05-18 00:00:00		2013-07-01 00:00:00		2012-10-21 00:00:00		2014-05-09 00:00:00		2014-05-15 00:00:00		2013-07-01 00:00:00		2014-01-01 00:00:00		2013-07-01 00:00:00		2012-10-21 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2018-01-01 00:00:00		2017-07-01 00:00:00		2018-10-25 00:00:00		2018-10-25 00:00:00		2018-10-25 00:00:00		2018-07-01 00:00:00		2020-09-20 00:00:00		2018-01-01 00:00:00		2020-07-01 00:00:00		2019-01-01 00:00:00		2015-10-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-04-24 00:00:00		2016-04-24 00:00:00		2016-10-31 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2018-08-10 00:00:00		2017-01-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2018-10-17 00:00:00		2020-10-16 00:00:00		2020-02-16 00:00:00		2019-01-01 00:00:00		2020-02-16 00:00:00		2020-10-18 00:00:00		2018-09-23 00:00:00		2020-07-01 00:00:00		2020-02-19 00:00:00		2018-01-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2017-07-01 00:00:00		2020-09-20 00:00:00		2018-08-13 00:00:00		2018-10-21 00:00:00		2018-10-21 00:00:00		2018-09-23 00:00:00		2019-07-01 00:00:00		2021-01-01 00:00:00		2020-10-18 00:00:00		2020-01-01 00:00:00		2020-09-25 00:00:00		2020-10-18 00:00:00		2020-09-20 00:00:00		2020-10-18 00:00:00		2021-07-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00		2022-01-01 00:00:00
rpt_end		1996-03-15 00:00:00		1996-06-30 00:00:00		1996-06-30 00:00:00		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-12-31 00:00:00		1999-06-30 00:00:00		1996-12-31 00:00:00		1998-06-30 00:00:00		None		2000-06-30 00:00:00		1999-12-31 00:00:00		2000-12-31 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2000-12-31 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-10-19 00:00:00		2003-06-30 00:00:00		2003-09-20 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		2002-12-31 00:00:00		2001-03-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		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-06-06 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		None		2007-06-30 00:00:00		2013-06-30 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2014-12-31 00:00:00		2014-12-31 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		2014-05-17 00:00:00		2014-05-17 00:00:00		2014-05-17 00:00:00		2014-12-31 00:00:00		2014-10-31 00:00:00		2014-10-20 00:00:00		2008-03-17 00:00:00		2007-12-31 00:00:00		2008-03-17 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-06-30 00:00:00		2008-10-29 00:00:00		2009-02-04 00:00:00		2008-12-31 00:00:00		None		None		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-03-17 00:00:00		2010-03-17 00:00:00		2010-03-17 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		2010-03-17 00:00:00		2010-09-30 00:00:00		2010-09-30 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		None		2012-08-31 00:00:00		2012-06-30 00:00:00		2014-12-31 00:00:00		2012-10-20 00:00:00		2012-10-20 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2012-12-31 00:00:00		2014-05-09 00:00:00		2014-05-15 00:00:00		2013-12-31 00:00:00		2014-05-17 00:00:00		2013-12-31 00:00:00		2012-12-31 00:00:00		2015-09-30 00:00:00		2015-09-30 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2018-10-25 00:00:00		2018-10-25 00:00:00		2018-10-25 00:00:00		2018-09-22 00:00:00		2020-10-17 00:00:00		2018-06-30 00:00:00		2020-09-19 00:00:00		2019-06-30 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-04-23 00:00:00		2016-04-23 00:00:00		2016-06-30 00:00:00		2016-06-30 00:00:00		2016-10-31 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2018-08-10 00:00:00		2017-06-30 00:00:00		2019-12-31 00:00:00		2020-02-15 00:00:00		2018-10-17 00:00:00		2020-10-16 00:00:00		2020-06-30 00:00:00		2019-06-30 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2018-10-20 00:00:00		2020-09-19 00:00:00		2020-02-19 00:00:00		2018-06-30 00:00:00		2018-09-22 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2020-10-17 00:00:00		2018-08-13 00:00:00		2018-12-31 00:00:00		2018-12-31 00:00:00		2018-10-20 00:00:00		2019-12-31 00:00:00		2021-06-30 00:00:00		2020-12-31 00:00:00		2020-02-15 00:00:00		2020-09-25 00:00:00		2020-12-31 00:00:00		2020-10-17 00:00:00		2020-12-31 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		2022-10-22 00:00:00		2022-06-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		2004-12-31 00:00:00		None		2005-06-30 00:00:00		None		2005-12-31 00:00:00		None		2006-06-30 00:00:00		None		2006-12-31 00:00:00		2007-06-30 00:00:00		None		None		None		2013-07-08 00:00:00		None		None		2015-07-13 00:00:00		2015-07-13 00:00:00		None		None		2014-07-11 00:00:00		None		None		2014-10-31 00:00:00		2014-10-20 00:00:00		2008-03-17 00:00:00		2007-12-31 00:00:00		None		None		2008-06-30 00:00:00		None		2008-10-29 00:00:00		None		None		None		None		2008-12-31 00:00:00		2009-06-30 00:00:00		None		None		2010-03-17 00:00:00		2010-03-17 00:00:00		None		None		None		2009-12-31 00:00:00		None		2010-09-30 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		None		None		None		2010-12-31 00:00:00		None		None		2011-12-31 00:00:00		2011-06-30 00:00:00		None		2012-07-30 00:00:00		2014-01-16 00:00:00		None		None		None		2015-01-15 00:00:00		None		2012-10-25 00:00:00		2014-07-09 00:00:00		None		2013-01-27 00:00:00		2014-05-09 00:00:00		2014-05-15 00:00:00		2014-05-19 00:00:00		2014-05-19 00:00:00		None		None		2015-10-02 00:00:00		None		2018-09-27 00:00:00		2018-01-16 00:00:00		2018-10-25 00:00:00		2018-10-25 00:00:00		2018-10-25 00:00:00		None		2020-10-22 00:00:00		None		2020-09-22 00:00:00		None		None		2016-01-13 00:00:00		2016-04-22 00:00:00		None		2016-07-12 00:00:00		None		2016-10-31 00:00:00		2017-01-19 00:00:00		None		None		2018-08-10 00:00:00		2017-07-26 00:00:00		None		None		2018-10-17 00:00:00		2020-10-16 00:00:00		None		2019-07-09 00:00:00		2020-07-25 00:00:00		2021-01-16 00:00:00		2018-10-25 00:00:00		None		2020-02-19 00:00:00		None		2018-09-27 00:00:00		2018-07-31 00:00:00		None		None		2018-08-13 00:00:00		None		2019-01-11 00:00:00		None		2020-01-27 00:00:00		None		2021-07-08 00:00:00		2020-02-19 00:00:00		2020-09-25 00:00:00		None		None		None		None		2022-01-14 00:00:00		2021-07-09 00:00:00		2022-07-24 00:00:00		2022-10-26 00:00:00		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		22001		None		22001		None		22001		None		22001		None		22001		22001		None		None		None		22001		None		None		22001		22001		None		None		22001		None		None		22001		22001		22001		22001		None		None		22001		None		22006		22006		None		None		None		22001		22001		None		None		22001		22001		None		None		None		22001		None		22001		22001		22001		22001		22001		None		None		None		22001		None		None		22001		22001		None		22006		22001		None		22006		None		22001		None		22006		22001		None		22006		22001		22001		22001		22001		None		None		22001		None		22001		22001		22001		22001		22001		None		22001		None		22001		None		None		22001		22001		None		22001		None		22001		22001		None		None		22001		22001		None		None		22001		22001		None		22001		22001		22001		22001		None		22001		None		22001		22001		None		None		22001		None		22001		None		22001		None		22001		22001		22001		None		None		None		None		22001		22001		22001		22001		None

Table: filer_to_filer_type

filer_id		1066578		1066578
filer_type		16		16
active		Y		Y
race		0		0
session_id		1995		2011
category		0		0
category_type		40502		40502
sub_category		40103		40103
effect_dt		1995-12-04 00:00:00		2012-09-04 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		S		S
nyq_dt		None		2000-01-01 00:00:00
party_cd		None		None
county_cd		18036		18008
district_cd		None		None

Table: filer_xref

filer_id		1066578
xref_id		952071
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		952071		952071		952071		952071
filer_id		1066578		1066578		1066578		1066578
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2012-09-04 00:00:00		2012-09-04 00:00:00		2012-09-04 00:00:00		2012-09-04 00:00:00
naml		ASPHALT PAVEMENT ASSOCIATION POLITICAL ACTION COMMITTEE		ASPHALT PAVEMENT ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA ASPHALT PAVEMENT ASSOCIATION POLITICAL ACTION COMMITTEE		CALIFORNIA ASPHALT PAVEMENT ASSOCIATION POLITICAL ACTION COMMITTEE
namf		None		None		None		None
namt		None		None		None		None
nams		None		None		None		None
adr1		None		None		None		None
adr2		None		None		None		None
city		LAGUNA HILLS		WEST SACRAMENTO		LAGUNA HILLS		WEST SACRAMENTO
st		CA		CA		CA		CA
zip4		926530000		956910000		926530000		956910000
phon		9498556489		9167915044		9498556489		9167915044
fax		None		None		None		None
email		None		None		None		None

Table: filers

filer_id		1066578

Table: received_filings

filer_id		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578		1066578
filing_file_name		1848884_0.cal		1850175_0.cal		1399670_1.cal		2101943_0.cal		1901211_0.cal		1911688_0.cal		2308137_1.cal		2313341_1.cal		2313341_0.cal		2282361_0.cal		2308137_0.cal		2454385_0.cal		2282691_0.cal		395371.cal		2517139_0.cal		501435.cal		501569.cal		501542.cal		501661.cal		215956.cal		2506180_0.cal
received_date		2014-05-09 00:00:00		2014-05-15 00:00:00		2012-08-31 00:00:00		2016-10-31 00:00:00		2014-10-21 00:00:00		2014-10-31 00:00:00		2018-10-25 00:00:00		2018-10-25 00:00:00		2018-10-25 00:00:00		2018-08-10 00:00:00		2018-10-17 00:00:00		2020-02-19 00:00:00		2018-08-13 00:00:00		2020-10-22 00:00:00		2020-10-16 00:00:00		2021-07-12 00:00:00		2021-07-12 00:00:00		2021-07-12 00:00:00		2021-07-12 00:00:00		2021-09-02 00:00:00		2020-09-25 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal
filing_id		1848884		1850175		1399670		2101943		1901211		1911688		2308137		2313341		2313341		2282361		2308137		2454385		2282691		None		2517139		None		None		None		None		None		2506180
form_id		F497		F497		F410		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		None		None		None		None		None		F497
receive_comment		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 passed validation, but failed DB constraints		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted