Home

Filer ID: 1389567

Table: filer_address

filer_id		1389567		1389567		1389567		1389567
adrid		2405389		2405391		2455144		2455145
effect_dt		2016-08-29 00:00:00		2016-08-29 00:00:00		2018-07-09 00:00:00		2018-07-09 00:00:00
add_type		7051		7082		7051		7082
session_id		2015		2015		2017		2017

Table: filer_filings

filer_id		1389567		1389567		1389567		1389567
filing_id		2074007		2084987		2097846		2263725
period_id		None		None		None		None
form_id		F410		F410		F470S		F410
filing_sequence		0		0		0		0
filing_date		2016-08-29 00:00:00		2016-09-26 00:00:00		2016-09-26 00:00:00		2018-07-09 00:00:00
stmnt_type		10005		10006		10005		10003
stmnt_status		11003		11001		11003		11001
session_id		2015		2015		2015		2017
user_id		CPON		TRAMON		CPON		PADAMS
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		1389567		1389567		1389567
filer_type		16		16		16
active		T		Y		Y
race		0		0		0
session_id		2017		2015		2015
category		40002		40002		40002
category_type		40501		40501		40501
sub_category		0		0		0
effect_dt		2018-07-01 00:00:00		2016-08-29 00:00:00		2016-09-26 00:00:00
sub_category_type		0		0		0
election_type		0		0		0
sub_category_a		None		None		None
nyq_dt		2016-09-20 00:00:00		None		2016-09-20 00:00:00
party_cd		16001		16001		16001
county_cd		18053		18053		18053
district_cd		0		0		0

Table: filer_xref

filer_id		1389567
xref_id		1389567
effect_dt		2016-09-06 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1389567		1389567		1389567		1389567
filer_id		1389567		1389567		1389567		1389567
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		TERMINATED		TERMINATED		TERMINATED		TERMINATED
effect_dt		2018-07-01 00:00:00		2018-07-01 00:00:00		2018-07-01 00:00:00		2018-07-01 00:00:00
naml		LEMUS FOR SCHOOL BOARD 2016; FRIENDS OF ESTHER		LEMUS FOR SCHOOL BOARD 2016; FRIENDS OF ESTHER		LEMUS FOR SCHOOL BOARD 2016; FRIENDS OF ESTHER		LEMUS FOR SCHOOL BOARD 2016; FRIENDS OF ESTHER
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		WINDSOR		WINDSOR		WINDSOR		WINDSOR
st		CA		CA		CA		CA
zip4		95492		95492		95492		95492
phon		3107298201		None		3107298201
fax		None		None		None		None
email		[email protected]		None		[email protected]		None

Table: filers

filer_id		1389567