Home

Filer ID: 1013066

Table: filer_address

filer_id		1013066		1013066
adrid		1012611		2325187
effect_dt		1994-09-20 00:00:00		2014-07-31 00:00:00
add_type		7051		7051
session_id		1993		2013

Table: filer_filings

filer_id		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066
filing_id		75177		75178		75179		75180		75181		75182		75183		75184		75185		75187		204979		204980		584938		75186		668206		762688		787905		792676		785545		805562		811793		834238		827238		858246		852357		877064		880003		920905		910199		944674		964591		944674		1004515		1004515		979757		963161		963161		964591		983368		983368		964591		1004515		1039438		1099072		1954835		1866801		1937141		1889537		1907486		1564025		1576576		1702291		1879346		1882733		1886805		1888087		1735514		1847035		1748052		2370783		2350350		2307966		2258141		2276005		2286558		2306707		2294964		2725104		2739074
period_id		129		140		139		137		145		147		153		153		155		160		137		145		None		155		None		None		None		None		167		168		None		None		169		None		169		172		None		None		171		173		None		173		None		None		176		175		175		None		None		None		None		None		None		None		None		219		219		219		220		201		None		212		None		219		219		219		209		218		None		None		235		236		234		233		None		236		235		251		252
form_id		F461		F497		F461		F461		F405		F461		F461		F405		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F497		F461		F461		F497		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497		F461		F497		F497		F461		F461		F497		F461		F497		F497		F497		F461		F497		F461		F461		F461		F497		F497		F461		F461		F497		F497		F497		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		0		1		0		1		0		1		0		1		0		1		2		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1994-09-16 00:00:00		1994-11-04 00:00:00		1995-01-31 00:00:00		1995-01-31 00:00:00		1996-09-09 00:00:00		1997-01-31 00:00:00		1998-07-27 00:00:00		1998-09-14 00:00:00		1998-09-10 00:00:00		1999-10-29 00:00:00		1994-09-16 00:00:00		1996-07-31 00:00:00		2000-01-31 00:00:00		1999-02-01 00:00:00		2000-07-31 00:00:00		2001-01-31 00:00:00		2001-10-10 00:00:00		2001-08-01 00:00:00		2001-10-09 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2002-02-27 00:00:00		2002-02-27 00:00:00		2002-07-31 00:00:00		2002-07-26 00:00:00		2002-10-23 00:00:00		2002-10-23 00:00:00		2003-01-31 00:00:00		2003-01-30 00:00:00		2003-07-25 00:00:00		2003-10-14 00:00:00		2004-01-12 00:00:00		2003-07-31 00:00:00		2004-01-13 00:00:00		2004-01-12 00:00:00		2004-01-12 00:00:00		2003-10-10 00:00:00		2003-01-13 00:00:00		2004-01-12 00:00:00		2004-03-26 00:00:00		2004-03-26 00:00:00		2004-03-26 00:00:00		2004-08-02 00:00:00		2005-01-31 00:00:00		2015-02-02 00:00:00		2014-07-25 00:00:00		2015-02-02 00:00:00		2014-09-29 00:00:00		2014-10-28 00:00:00		2011-01-23 00:00:00		2011-01-24 00:00:00		2012-10-24 00:00:00		2014-07-31 00:00:00		2014-09-05 00:00:00		2014-09-19 00:00:00		2014-09-24 00:00:00		2013-01-29 00:00:00		2014-05-02 00:00:00		2013-01-31 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2018-10-17 00:00:00		2018-05-31 00:00:00		2018-07-31 00:00:00		2018-07-31 00:00:00		2018-10-15 00:00:00		2018-09-24 00:00:00		2022-09-28 00:00:00		2022-10-21 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10005		10005		10005		10005		10001		10001		10005		10005		10001		10005		10001		10001		10005		10005		10001		10001		10005		10002		10005		10006		10001		10002		10001		10006		10005		10006		10006		10006		10005		10005		10005		10001		10001		10001		10001		10001		10005		10001		10005		10001		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10005		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11001		11003		11003		11003		11001		11003		11001		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003
session_id		1991		1993		1993		1993		1995		1995		1997		1997		1997		1999		1993		1995		1999		1997		1999		1999		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		2013		2013		2013		2013		2013		2009		2009		2011		2013		2013		2013		2013		2011		2013		2011		2019		2017		2017		2017		2017		2017		2017		2017		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		*		BSMITH		*		ERUTH		ERUTH		JBRANNON		DHORRELL		*		*		LTHIBAUL		BINTHAVO		*		LTHIBAUL		*		*		KLARRY		DHORRELL		COMPLETED		COMPLETED		DHORRELL		COMPLETED		DHORRELL		DHORRELL		COMPLETED		COMPLETED		COMPLETED		CFLAGG		DHORRELL		DHORRELL		DHORRELL		DHORRELL		DHORRELL		DHORRELL		JINGRAM		CAFILER		JINGRAM		CAFILER		CAFILER		JINGRAM		JINGRAM		CAFILER		JINGRAM		CAFILER		CAFILER		CAFILER		JINGRAM		CAFILER		JINGRAM		GTAYLOR		GTAYLOR		CAFILER		CAFILER		GTAYLOR		GTAYLOR		CAFILER		CAFILER		CAFILER		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11001		11003		11001		11003		11003		11001		11001		11003		11001		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		1992-01-01 00:00:00		None		1994-07-01 00:00:00		1994-01-01 00:00:00		1996-01-01 00:00:00		1996-07-01 00:00:00		1998-01-01 00:00:00		1998-01-01 00:00:00		None		None		1994-01-01 00:00:00		1996-01-01 00:00:00		1999-01-01 00:00:00		1998-07-01 00:00:00		2000-01-01 00:00:00		2000-07-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		None		2002-02-27 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-10-23 00:00:00		None		2002-07-01 00:00:00		2002-07-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2003-01-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		2014-07-01 00:00:00		2014-07-25 00:00:00		2014-07-01 00:00:00		2014-09-29 00:00:00		2014-10-28 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2012-10-24 00:00:00		2014-01-01 00:00:00		2014-09-05 00:00:00		2014-09-19 00:00:00		2014-09-24 00:00:00		2012-01-01 00:00:00		2014-05-02 00:00:00		2012-01-01 00:00:00		2018-07-01 00:00:00		2018-07-01 00:00:00		2018-10-17 00:00:00		2018-05-31 00:00:00		2018-01-01 00:00:00		2018-01-01 00:00:00		2018-10-15 00:00:00		2018-09-24 00:00:00		2022-09-28 00:00:00		2022-10-21 00:00:00
rpt_end		1992-12-31 00:00:00		None		1994-12-31 00:00:00		1994-12-31 00:00:00		1996-06-30 00:00:00		1996-12-31 00:00:00		1998-06-30 00:00:00		1998-06-30 00:00:00		None		None		1994-06-30 00:00:00		1996-06-30 00:00:00		1999-12-31 00:00:00		1998-12-31 00:00:00		2000-06-30 00:00:00		2000-12-31 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		None		2002-02-27 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-10-23 00:00:00		None		2002-12-31 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2003-06-30 00:00:00		2004-06-30 00:00:00		2004-12-31 00:00:00		2014-12-31 00:00:00		2014-07-25 00:00:00		2014-12-31 00:00:00		2014-09-29 00:00:00		2014-10-28 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2012-10-24 00:00:00		2014-06-30 00:00:00		2014-09-05 00:00:00		2014-09-19 00:00:00		2014-09-24 00:00:00		2012-12-31 00:00:00		2014-05-02 00:00:00		2012-12-31 00:00:00		2018-12-31 00:00:00		2018-12-31 00:00:00		2018-10-17 00:00:00		2018-05-31 00:00:00		2018-06-30 00:00:00		2018-06-30 00:00:00		2018-10-15 00:00:00		2018-09-24 00:00:00		2022-09-28 00:00:00		2022-10-21 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2001-10-09 00:00:00		2002-01-09 00:00:00		None		None		2002-02-27 00:00:00		None		2002-07-22 00:00:00		2002-10-23 00:00:00		None		None		2003-01-30 00:00:00		2003-07-25 00:00:00		None		2004-01-12 00:00:00		None		None		2004-01-06 00:00:00		2004-01-12 00:00:00		2003-09-22 00:00:00		None		None		None		None		None		None		None		None		2014-07-25 00:00:00		2015-02-02 00:00:00		2014-09-29 00:00:00		2014-10-28 00:00:00		2011-01-23 00:00:00		None		2012-10-24 00:00:00		None		2014-09-05 00:00:00		2014-09-19 00:00:00		2014-09-24 00:00:00		2013-01-29 00:00:00		2014-05-02 00:00:00		None		None		2019-01-31 00:00:00		2018-10-17 00:00:00		2018-05-31 00:00:00		2018-07-31 00:00:00		None		2018-10-15 00:00:00		2018-09-24 00:00:00		2022-09-28 00:00:00		2022-10-21 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		22001		22001		None		22001		None		None		22001		22001		22001		None		None		None		None		None		None		None		None		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		None		22001		22001		22001		22001

Table: filer_to_filer_type

filer_id		1013066
filer_type		10
active		Y
race		0
session_id		1993
category		0
category_type		40502
sub_category		0
effect_dt		1994-09-20 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		None
county_cd		18026
district_cd		None

Table: filer_xref

filer_id		1013066
xref_id		494274
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		494274		494274		494274		494274		494274		494274		494274		494274		494274		494274		494274		494274		494274		494274		494274		494274
filer_id		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066
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		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		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		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00		1994-09-20 00:00:00
naml		TUTTLE, ROBERT H.; INCLUDING TUTTLE-CLICK AUTOMOTIVE GROUP		TUTTLE, ROBERT H.; INCLUDING TUTTLE-CLICK AUTOMOTIVE GROUP		TUTTLE, ROBERT H.		TUTTLE, ROBERT H.		TUTTLE, ROBERT H. INCLUDING TCAG MANAGEMENT SERVICES		TUTTLE, ROBERT H. INCLUDING TCAG MANAGEMENT SERVICES		TUTTLE, ROBERT H./TUTTLE-CLICK FORD/TUTTLE-CLICK INC.		TUTTLE, ROBERT H./TUTTLE-CLICK FORD/TUTTLE-CLICK INC.		TUTTLE-CLICK FORD		TUTTLE-CLICK FORD		TUTTLE-CLICK,INC.		TUTTLE-CLICK,INC.		TUTTLE-CLICK TUSTIN SOSLE		TUTTLE-CLICK TUSTIN SOSLE		TUTTLE, ROBERT H./TUTTLE-CLICK FORD/TUTTLE-CLICK INC./TUTTLE-CLICK'S TUSTIN DODGE		TUTTLE, ROBERT H./TUTTLE-CLICK FORD/TUTTLE-CLICK INC./TUTTLE-CLICK'S TUSTIN DODGE
namf		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
nams		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
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS		BEVERLY HILLS
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		902100000		90212		902100000		90212		902100000		90212		902100000		90212		902100000		90212		902100000		90212		902100000		90212		902100000		90212
phon		4153886874		4153896800		4153886874		4153896800		4153886874		4153896800		4153886874		4153896800		4153886874		4153896800		4153886874		4153896800		4153886874		4153896800		4153886874		4153896800
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1013066

Table: received_filings

filer_id		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066		1013066
filing_file_name		398020.cal		785545_0.cal		805562_0.cal		827238_0.cal		852357_0.cal		877064_0.cal		910199_0.cal		944674_0.cal		963161_0.cal		979757_0.cal		147403.cal		147548.cal		963161_1.cal		944674_1.cal		1735514_0.cal		1564025_0.cal		1866801_0.cal		85901.cal
received_date		2001-10-09 00:00:00		2001-10-09 00:00:00		2002-01-10 00:00:00		2002-02-27 00:00:00		2002-07-26 00:00:00		2002-10-23 00:00:00		2003-01-30 00:00:00		2003-07-25 00:00:00		2003-10-10 00:00:00		2004-01-12 00:00:00		2004-01-12 00:00:00		2004-01-12 00:00:00		2004-01-12 00:00:00		2004-01-12 00:00:00		2013-01-29 00:00:00		2011-01-23 00:00:00		2014-07-25 00:00:00		2014-09-29 00:00:00
filing_directory		/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp
filing_id		None		785545		805562		827238		852357		877064		910199		944674		963161		979757		None		None		963161		944674		1735514		1564025		1866801		None
form_id		None		F461		F461		F497		F461		F497		F461		F461		F461		F461		None		None		F461		F461		F461		F461		F497		None
receive_comment		Filing did not pass validation		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 passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints