Home

Filer ID: 1386707

Table: f501_502

filing_id		2053012		2053012		2385414		2583974
amend_id		0		1		0		0
rec_type		CVR		CVR		CVR		CVR
form_type		F501		F501		F501		F501
filer_id		1386707		1386707		1386707		1386707
committee_id		None		None		None		1437549
entity_cd		8		8		8		8
report_num		None		None		None		None
rpt_date		2016-06-27 00:00:00		2018-01-08 00:00:00		2019-06-04 00:00:00		2021-05-10 00:00:00
stmt_type		10001		10002		10001		10001
from_date		None		None		None		None
thru_date		None		None		None		None
elect_date		None		None		None		None
cand_naml		AGUILAR		AGUILAR		AGUILAR		AGUILAR
cand_namf		JAMES R.		JAMES R.		JAMES R.		JAMES
can_namm		None		None		None		None
cand_namt		None		None		None		None
cand_nams		None		None		None		None
moniker_pos		None		None		None		None
moniker		None		None		None		None
cand_city		SAN LEANDRO		SAN LEANDRO		SAN LEANDRO		SAN LEANDRO
cand_st		CA		CA		CA		CA
cand_zip4		94578-		94578-		94578		94578
cand_phon		5105006973		5105006973		5105006973		5105006973
cand_fax		None		None		None		None
cand_email		aguilarforassembly@gmail.com		jamesaguilarslz@gmail.com		jamesaguilarslz@gmail.com		info@jamesforcalifornia.com
fin_naml		None		None		None		None
fin_namf		None		None		None		None
fin_namt		None		None		None		None
fin_nams		None		None		None		None
fin_city		None		None		None		None
fin_st		None		None		None		None
fin_zip4		None		None		None		None
fin_phon		None		None		None		None
fin_fax		None		None		None		None
fin_email		None		None		None		None
office_cd		30013		30013		30013		30013
offic_dscr		ASSEMBLY		ASSEMBLY		ASSEMBLY		ASSEMBLY
agency_nam		LEGISLATIVE		LEGISLATIVE		LEGISLATIVE		LEGISLATIVE
juris_cd		40502		40502		40502		40502
juris_dscr		None		None		None		None
dist_no		None		None		None		None
party		None		None		None		None
yr_of_elec		2018		2018		2022		2021
elec_type		3002		3002		3002		3004
execute_dt		2016-06-27 00:00:00		2018-01-05 00:00:00		2019-05-30 00:00:00		2021-04-30 00:00:00
can_sig		None		None		None		None
account_no		None		None		None		None
acct_op_dt		None		None		None		None
party_cd		16001		16001		16001		16001
district_cd		17024		17024		17024		17024
accept_limit_yn		Y		Y		Y		Y
did_exceed_dt		None		None		None		None
cntrb_prsnl_fnds_dt		None		None		None		None

Table: filer_address

filer_id		1386707		1386707		1386707		1386707
adrid		2400328		2480318		2443552		2518186
effect_dt		2016-06-27 00:00:00		2021-05-10 00:00:00		2019-06-04 00:00:00		2021-05-10 00:00:00
add_type		7051		7051		7051		7051
session_id		2015		2019		2017		2021

Table: filer_filings

filer_id		1386707		1386707		1386707		1386707		1386707
filing_id		2385414		2053012		2053012		2588410		2583974
period_id		0		0		0		None		0
form_id		F501		F501		F501		F470		F501
filing_sequence		0		0		1		0		0
filing_date		2019-06-04 00:00:00		2016-06-27 00:00:00		2018-01-08 00:00:00		2021-06-07 00:00:00		2021-05-10 00:00:00
stmnt_type		10001		10001		10002		10005		10001
stmnt_status		11001		11001		11001		11001		11003
session_id		2019		2015		2017		2021		2021
user_id		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA
special_audit		11003		11003		None		11003		11003
fine_audit		11001		11001		11001		11001		11001
rpt_start		None		None		None		2021-01-01 00:00:00		None
rpt_end		None		None		None		2021-12-31 00:00:00		None
rpt_date		None		None		None		None		None
filing_type		None		None		None		None		None

Table: filer_to_filer_type

filer_id		1386707		1386707		1386707		1386707
filer_type		8		8		8		8
active		Y		Y		W		Y
race		0		0		0		0
session_id		2021		2021		2017		2017
category		0		0		0		0
category_type		40502		40502		40502		40502
sub_category		0		0		0		0
effect_dt		2019-06-04 00:00:00		2021-05-10 00:00:00		2018-01-08 00:00:00		2016-06-27 00:00:00
sub_category_type		0		0		0		0
election_type		0		0		0		0
sub_category_a		None		None		None		None
nyq_dt		None		None		None		None
party_cd		16001		16001		16001		16001
county_cd		0		0		0		0
district_cd		0		0		0		0

Table: filer_xref

filer_id		1386707
xref_id		1386707
effect_dt		2016-06-29 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1386707		1386707		1386707		1386707		1386707		1386707		1386707		1386707
filer_id		1386707		1386707		1386707		1386707		1386707		1386707		1386707		1386707
filer_type		CANDIDATE/OFFICEHOLDER		CANDIDATE/OFFICEHOLDER		CANDIDATE/OFFICEHOLDER		CANDIDATE/OFFICEHOLDER		CANDIDATE/OFFICEHOLDER		CANDIDATE/OFFICEHOLDER		CANDIDATE/OFFICEHOLDER		CANDIDATE/OFFICEHOLDER
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2021-05-10 00:00:00		2021-05-10 00:00:00		2021-05-10 00:00:00		2021-05-10 00:00:00		2021-05-10 00:00:00		2021-05-10 00:00:00		2021-05-10 00:00:00		2021-05-10 00:00:00
naml		AGUILAR		AGUILAR		AGUILAR		AGUILAR		AGUILAR		AGUILAR		AGUILAR		AGUILAR
namf		JAMES R.		JAMES R.		JAMES R.		JAMES R.		JAMES		JAMES		JAMES		JAMES
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 LEANDRO		SAN LEANDRO		SAN LEANDRO		SAN LEANDRO		SAN LEANDRO		SAN LEANDRO		SAN LEANDRO		SAN LEANDRO
st		CA		CA		CA		CA		CA		CA		CA		CA
zip4		94578-		94578-		94578		None		94578-		94578-		94578		None
phon		5105006973		5105006973		5105006973		5105006973		5105006973		5105006973		5105006973		5105006973
fax		None		None		None		None		None		None		None		None
email		aguilarforassembly@gmail.com		jamesaguilarslz@gmail.com		info@jamesforcalifornia.com		info@jamesforcalifornia.com		aguilarforassembly@gmail.com		jamesaguilarslz@gmail.com		info@jamesforcalifornia.com		info@jamesforcalifornia.com

Table: filers

filer_id		1386707