Home

Filer ID: 1433562

Table: cvr_lobby_disclosure

filing_id		2530769		2549093		2576874		2599382		2615857		2637293		2549093		2615857		2530769		2729321		2680877		2701723
amend_id		0		0		0		0		0		0		1		1		1		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625
sender_id		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562
filer_id		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562
entity_cd		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		MACKAY, GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.
filer_namf		None		None		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		000		000		000		000		000		001		001		001		000		000		000
rpt_date		2020-11-02 00:00:00		2021-01-28 00:00:00		2021-04-26 00:00:00		2021-07-29 00:00:00		2021-10-14 00:00:00		2022-01-25 00:00:00		2022-01-25 00:00:00		2022-01-25 00:00:00		2021-12-06 00:00:00		2022-10-06 00:00:00		2022-05-10 00:00:00		2022-07-27 00:00:00
from_date		2020-09-01 00:00:00		2020-10-01 00:00:00		2021-01-01 00:00:00		2021-04-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2020-10-01 00:00:00		2021-07-01 00:00:00		2020-07-01 00:00:00		2022-07-01 00:00:00		2022-01-01 00:00:00		2022-04-01 00:00:00
thru_date		2020-09-30 00:00:00		2020-12-31 00:00:00		2021-03-31 00:00:00		2021-06-30 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2020-12-31 00:00:00		2021-09-30 00:00:00		2020-09-30 00:00:00		2022-09-30 00:00:00		2022-03-31 00:00:00		2022-06-30 00:00:00
cum_beg_dt		2020-09-01 00:00:00		2020-09-01 00:00:00		2020-09-01 00:00:00		2020-09-01 00:00:00		2020-09-01 00:00:00		2020-09-01 00:00:00		2020-09-01 00:00:00		2020-09-01 00:00:00		2020-09-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00
firm_id		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562
firm_name		None		None		None		None		None		None		None		None		None		None		None		None
firm_city		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK
firm_st		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY		NY
firm_zip4		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019		10019
firm_phon		2128499600		2128499600		2128499600		2128499600		2128499600		2128499600		2128499600		2128499600		2128499600		2128499600		2128499600		2128499600
mail_city		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2020-11-02 00:00:00		2021-01-28 00:00:00		2021-04-26 00:00:00		2021-07-29 00:00:00		2021-10-14 00:00:00		2022-01-25 00:00:00		2022-01-25 00:00:00		2022-01-25 00:00:00		2021-12-06 00:00:00		2022-10-04 00:00:00		2022-05-10 00:00:00		2022-07-27 00:00:00
sig_loc		New York, New York		New York, New York		New York, New York		New York, New York		New York, NY		New York, NY		New York, NY		Dallas, TX		Dallas, TX		New York, NY		New York, NY		New York, NY
sig_naml		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay
sig_namf		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin
sig_namt		None		None		None		None		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None		None		None		None		None
prn_naml		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay		Mackay
prn_namf		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin		Gavin
prn_namt		None		None		None		None		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None		None		None		None		None
sig_title		Chief Business Development Officer		Chief Business Development Officer		Chief Business Development Officer		Chief Business Development Officer		Chief Business Development Officer		Chief Business Development Officer		Chief Business Development Officer		Chief Business Development Officer		Managing Director, Business Development		Senior Managing Director		Chief Business Development Officer		Senior Managing Director
nopart1_cb		None		None		None		None		None		None		None		None		None		None		None		None
nopart2_cb		None		None		None		None		None		None		None		None		None		None		None		None
part1_1_cb		X		X		X		X		X		X		X		X		X		X		X		X
part1_2_cb		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_n_cb		X		X		X		X		X		X		X		X		X		X		X		X
ctrib_y_cb		None		None		None		None		None		None		None		None		None		None		None		None
lby_actvty		None		None		None		None		None		None		None		None		None		None		None		None
lobby_n_cb		X		X		X		X		X		X		X		X		X		X		X		X
lobby_y_cb		None		None		None		None		None		None		None		None		None		None		None		None
major_naml		None		None		None		None		None		None		None		None		None		None		None		None
major_namf		None		None		None		None		None		None		None		None		None		None		None		None
major_namt		None		None		None		None		None		None		None		None		None		None		None		None
major_nams		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_nm		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_id		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_address

filer_id		1433562		1433562		1433562
adrid		2502196		2511612		2549582
effect_dt		2020-09-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00
add_type		7051		7051		7051
session_id		2019		2021		2023

Table: filer_filings

filer_id		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562
filing_id		2516339		2530769		2615857		2680877		2615857		2530769		2637293		2545239		2549093		2701723		2599382		2549093		2576874		2729321
period_id		None		243		247		249		247		243		248		None		244		250		246		244		245		251
form_id		F601		F625		F625		F625		F625		F625		F625		F601		F625		F625		F625		F625		F625		F625
filing_sequence		0		0		0		0		1		1		0		0		0		0		0		1		0		0
filing_date		2020-09-17 00:00:00		2020-11-02 00:00:00		2021-10-14 00:00:00		2022-05-10 00:00:00		2022-01-25 00:00:00		2021-12-06 00:00:00		2022-01-25 00:00:00		2020-12-29 00:00:00		2021-01-28 00:00:00		2022-07-27 00:00:00		2021-07-29 00:00:00		2022-01-25 00:00:00		2021-04-26 00:00:00		2022-10-06 00:00:00
stmnt_type		10005		10001		10001		10001		10002		10002		10001		10005		10001		10001		10001		10002		10001		10001
stmnt_status		11001		11001		11001		11003		11001		11003		11001		11001		11001		11003		11001		11003		11001		11003
session_id		2019		2019		2021		2021		2021		2019		2021		2021		2019		2021		2021		2019		2021		2021
user_id		GPEREZ		MKIRKHAM		MKIRKHAM		LPHEAV		MKIRKHAM		CAFILER		MKIRKHAM		AROJAS		MKIRKHAM		CAFILER		MKIRKHAM		CAFILER		CHATRIDGE		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11003		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11003		11001		11003
rpt_start		1900-01-01 00:00:00		2020-09-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2020-07-01 00:00:00		2021-10-01 00:00:00		1900-01-01 00:00:00		2020-10-01 00:00:00		2022-04-01 00:00:00		2021-04-01 00:00:00		2020-10-01 00:00:00		2021-01-01 00:00:00		2022-07-01 00:00:00
rpt_end		1900-01-01 00:00:00		2020-09-30 00:00:00		2021-09-30 00:00:00		2022-03-31 00:00:00		2021-09-30 00:00:00		2020-09-30 00:00:00		2021-12-31 00:00:00		1900-01-01 00:00:00		2020-12-31 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		2020-12-31 00:00:00		2021-03-31 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filing_type		None		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006

Table: filer_to_filer_type

filer_id		1433562		1433562		1433562
filer_type		3		3		3
active		Y		Y		N
race		0		0		None
session_id		2019		2021		2023
category		0		0		None
category_type		0		0		None
sub_category		0		0		None
effect_dt		2020-09-01 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		None
election_type		0		0		None
sub_category_a		None		None		None
nyq_dt		None		None		None
party_cd		0		0		None
county_cd		0		0		None
district_cd		0		0		None

Table: filer_xref

filer_id		1433562
xref_id		1433562
effect_dt		2020-10-15 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562
filer_id		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562		1433562
filer_type		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.		MACKAY; GAVIN J.
namf		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None
city		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK		NEW YORK
st		NY		NY		NY		NY		NY		NY		NY		NY		NY
zip4		10019		10019		10019		10019		10019		10019		10019		10019		10019
phon		2128499600		2128499600		2128499600		2128499600		2128499600		2128499600		2128499600		2128499600		2128499600
fax		None		None		None		None		None		None		None		None		None
email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1433562

Table: lobbying_chg_log

filer_id		1433562		1433562		1433562
change_no		1		0		2
session_id		2019		2019		2019
log_dt		2020-09-17 00:00:00		2020-09-17 00:00:00		2020-09-16 00:00:00
filer_type		3		3		3
correction_flg		None		None		None
action		SET ACTIVE		ADDED		SET ACTIVE
attribute_changed				LOBBYIST		CLIENT
ethics_dt		None		None		None
interests		None		None		None
filer_full_name		MACKAY, GAVIN J.		MACKAY, GAVIN J.		MACKAY, GAVIN J.
filer_city		None		None		None
filer_st		None		None		None
filer_zip		None		None		None
filer_phone		None		None		None
entity_type		3		4		1
entity_name		None		GAVIN MACKAY		HUDSON ADVISORS L.P.
entity_city		None		None		None
entity_st		None		None		None
entity_zip		None		None		None
entity_phone		None		None		None
entity_id		0		1396648		1433564
responsible_officer		None		None		None
effect_dt		2020-09-01 00:00:00		2020-09-01 00:00:00		2020-09-01 00:00:00