Home

Filer ID: 1389672

Table: filer_address

filer_id		1389672		1389672		1389672		1389672
adrid		2452056		2413123		2405541		2405543
effect_dt		2018-03-26 00:00:00		2016-10-12 00:00:00		2016-08-30 00:00:00		2016-08-30 00:00:00
add_type		7051		7051		7051		7082
session_id		2017		2015		2015		2015

Table: filer_filings

filer_id		1389672		1389672		1389672		1389672
filing_id		2074457		2090006		2110020		2227829
period_id		None		None		None		None
form_id		F410		F410		F470S		F410
filing_sequence		0		0		0		0
filing_date		2016-08-30 00:00:00		2016-10-12 00:00:00		2016-09-20 00:00:00		2018-03-26 00:00:00
stmnt_type		10005		10006		10005		10006
stmnt_status		11003		11001		11003		11001
session_id		2015		2015		2015		2017
user_id		GPEREZ		TRAMON		CPON		TRAMON
special_audit		11003		11003		11003		11003
fine_audit		11003		11003		11003		11003
rpt_start		None		None		None		None
rpt_end		None		None		None		None
rpt_date		None		None		None		None
filing_type		None		None		None		None

Table: filer_to_filer_type

filer_id		1389672		1389672
filer_type		16		16
active		Y		Y
race		0		0
session_id		2015		2015
category		40002		40002
category_type		40501		40501
sub_category		0		0
effect_dt		2016-08-30 00:00:00		2016-10-12 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		None		None
nyq_dt		None		2016-09-19 00:00:00
party_cd		0		0
county_cd		18049		18049
district_cd		0		0

Table: filer_xref

filer_id		1389672
xref_id		1389672
effect_dt		2016-09-07 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1389672		1389672		1389672		1389672
filer_id		1389672		1389672		1389672		1389672
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2016-10-12 00:00:00		2016-10-12 00:00:00		2016-10-12 00:00:00		2016-10-12 00:00:00
naml		GERTLER FOR PORT COMMISSIONER 2016, DARREN		GERTLER FOR PORT COMMISSIONER 2016, DARREN		GERTLER FOR PORT COMMISSIONER 2016, DARREN		GERTLER FOR PORT COMMISSIONER 2016, DARREN
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		SOQUEL		CAPITOLA		SOQUEL		SOQUEL
st		CA		CA		CA		CA
zip4		95073		95010		95073		95073
phon		8315152752				8313254990		8315152752
fax		None		None		None		None
email		[email protected]		None		[email protected]		[email protected]

Table: filers

filer_id		1389672