Home

Filer ID: 1385867

Table: cvr_lobby_disclosure

filing_id		2061379		2097203
amend_id		0		0
rec_type		CVR		CVR
form_type		F615		F615
sender_id		1385867		1385867
filer_id		1385867		1385867
entity_cd		FRM		FRM
filer_naml		COFFEY		COFFEY
filer_namf		MICHAEL		MICHAEL
filer_namt		None		None
filer_nams		None		None
report_num		000		000
rpt_date		2016-07-29 00:00:00		2016-10-27 00:00:00
from_date		2016-04-01 00:00:00		2016-07-01 00:00:00
thru_date		2016-06-30 00:00:00		2016-09-30 00:00:00
cum_beg_dt		None		None
firm_id		1385867		1385867
firm_name		SDDCO Brokerage Advisors L.L.C.		SDDCO Brokerage Advisors L.L.C.
firm_city		BOSTON		BOSTON
firm_st		MA		MA
firm_zip4		02108		02108
firm_phon		6176462300		6176462300
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
mail_phon		None		None
sig_date		2016-07-18 00:00:00		2016-10-24 00:00:00
sig_loc		Boston, MA		Boston, MA
sig_naml		Coffey		Coffey
sig_namf		Michael		Michael
sig_namt		None		None
sig_nams		None		None
prn_naml		Coffey		Coffey
prn_namf		Michael		Michael
prn_namt		None		None
prn_nams		None		None
sig_title		Senior VP		Senior VP
nopart1_cb		X		X
nopart2_cb		X		X
part1_1_cb		None		None
part1_2_cb		None		None
ctrib_n_cb		None		None
ctrib_y_cb		None		None
lby_actvty		None		None
lobby_n_cb		None		None
lobby_y_cb		None		None
major_naml		None		None
major_namf		None		None
major_namt		None		None
major_nams		None		None
rcpcmte_nm		None		None
rcpcmte_id		None		None

Table: filer_address

filer_id		1385867
adrid		2396643
effect_dt		2016-05-11 00:00:00
add_type		7051
session_id		2015

Table: filer_filings

filer_id		1385867		1385867		1385867		1385867		1385867
filing_id		2043801		2061379		2097203		2107627		2116851
period_id		None		226		227		None		None
form_id		F604		F615		F615		F607		F607
filing_sequence		0		0		0		0		0
filing_date		2016-05-17 00:00:00		2016-07-29 00:00:00		2016-10-27 00:00:00		2016-11-01 00:00:00		2016-12-28 00:00:00
stmnt_type		10005		10001		10001		10005		10005
stmnt_status		11003		11001		11001		11001		11001
session_id		2015		2015		2015		2015		2015
user_id		GPEREZ		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU
special_audit		11003		11003		11003		11003		11003
fine_audit		11003		11001		11001		11001		11001
rpt_start		1900-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00
rpt_end		1900-01-01 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00
rpt_date		None		None		None		None		None
filing_type		None		22006		22006		None		None

Table: filer_to_filer_type

filer_id		1385867		1385867
filer_type		4		4
active		W		Y
race		None		0
session_id		2015		2015
category		None		0
category_type		None		0
sub_category		None		0
effect_dt		2016-05-12 00:00:00		2016-05-11 00:00:00
sub_category_type		None		0
election_type		None		0
sub_category_a		None		None
nyq_dt		None		None
party_cd		None		0
county_cd		None		0
district_cd		None		0

Table: filer_xref

filer_id		1385867
xref_id		1385867
effect_dt		2016-05-18 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1385867
filer_id		1385867
filer_type		LOBBYIST
status		W
effect_dt		2016-05-12 00:00:00
naml		COFFEY
namf		MICHAEL
namt		None
nams		None
adr1		None
adr2		None
city		BOSTON
st		MA
zip4		02108
phon		6176462300
fax		None
email		[email protected]

Table: filers

filer_id		1385867

Table: lobbying_chg_log

filer_id		1385867
change_no		0
session_id		2015
log_dt		2016-05-17 00:00:00
filer_type		4
correction_flg		Y
action		ADDED
attribute_changed		FIRM
ethics_dt		None
interests		None
filer_full_name		COFFEY, MICHAEL
filer_city		None
filer_st		None
filer_zip		None
filer_phone		None
entity_type		3
entity_name		SDDCO BROKERAGE ADVISORS LLC
entity_city		None
entity_st		None
entity_zip		None
entity_phone		None
entity_id		1377125
responsible_officer		None
effect_dt		2016-05-11 00:00:00