Home

Filer ID: 1443003

Table: filer_address

filer_id		1443003		1443003		1443003		1443003
adrid		2549933		2549934		2527304		2527307
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00
add_type		7051		7082		7051		7082
session_id		2023		2023		2021		2021

Table: filer_filings

filer_id		1443003		1443003
filing_id		2631285		2631287
period_id		None		None
form_id		F602		F999
filing_sequence		0		0
filing_date		2021-04-29 00:00:00		2021-04-29 00:00:00
stmnt_type		10005		10005
stmnt_status		11001		11001
session_id		2021		2021
user_id		MKIRKHAM		MKIRKHAM
special_audit		11003		11003
fine_audit		11003		11003
rpt_start		1900-01-01 00:00:00		1900-01-01 00:00:00
rpt_end		1900-01-01 00:00:00		1900-01-01 00:00:00
rpt_date		None		None
filing_type		None		None

Table: filer_interests

filer_id		1443003		1443003
session_id		2023		2021
interest_cd		40303		40303
effect_date		2023-01-01 00:00:00		2021-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1443003		1443003
filer_type		1		1
active		N		Y
race		None		0
session_id		2023		2021
category		None		0
category_type		None		0
sub_category		None		0
effect_dt		2023-01-01 00:00:00		2021-01-01 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		1443003
xref_id		1443003
effect_dt		2021-12-17 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1443003		1443003		1443003		1443003		1443003		1443003		1443003		1443003
filer_id		1443003		1443003		1443003		1443003		1443003		1443003		1443003		1443003
filer_type		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
status		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
naml		BROADWAY SAN FRANCISCO, LLC		BROADWAY SAN FRANCISCO, LLC		BROADWAY SAN FRANCISCO, LLC		BROADWAY SAN FRANCISCO, LLC		BROADWAY SAN FRANCISCO, LLC		BROADWAY SAN FRANCISCO, LLC		BROADWAY SAN FRANCISCO, LLC		BROADWAY SAN FRANCISCO, LLC
namf		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None
city		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO
st		CA		CA		CA		CA		CA		CA		CA		CA
zip4		94102		94102		94102		94102		94102		94102		94102		94102
phon		4155512050		None		4155512050		None		4155512050		None		4155512050		None
fax		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		None

Table: filers

filer_id		1443003

Table: lobbying_chg_log

filer_id		1443003
change_no		0
session_id		2021
log_dt		2021-09-27 00:00:00
filer_type		1
correction_flg		None
action		ADDED
attribute_changed		FIRM
ethics_dt		None
interests		None
filer_full_name		BROADWAY SAN FRANCISCO, LLC
filer_city		None
filer_st		None
filer_zip		None
filer_phone		None
entity_type		3
entity_name		PLATINUM ADVISORS, LLC
entity_city		None
entity_st		None
entity_zip		None
entity_phone		None
entity_id		1147749
responsible_officer		None
effect_dt		2021-01-01 00:00:00