Home

Filer ID: 1431012

Table: cvr_campaign_disclosure

filing_id		2553306		2553306		2602778		2635455		2672904		2725745		2706944		2686716		2743841
amend_id		1		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460
filer_id		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012
entity_cd		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL
filer_naml		Eric Guerra for City Council 2024		Eric Guerra for City Council 2024		Eric Guerra for City Council 2024		Eric Guerra for City Council 2024		Eric Guerra for City Council 2024		Eric Guerra for City Council 2024		Eric Guerra for City Council 2024		Eric Guerra for City Council 2024		Eric Guerra for City Council 2024
filer_namf		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None
report_num		001		000		000		000		000		000		000		000		000
rpt_date		2021-04-30 00:00:00		2021-01-29 00:00:00		2021-07-12 00:00:00		2022-01-15 00:00:00		2022-04-24 00:00:00		2022-09-26 00:00:00		2022-07-18 00:00:00		2022-05-22 00:00:00		2022-10-24 00:00:00
stmt_type		SA		SA		SA		SA		PE		PE		SA		PE		PE
late_rptno		None		None		None		None		None		None		None		None		None
from_date		2020-01-01 00:00:00		2020-01-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00		2022-05-22 00:00:00		2022-04-24 00:00:00		2022-09-25 00:00:00
thru_date		2020-12-31 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-04-23 00:00:00		2022-09-24 00:00:00		2022-06-30 00:00:00		2022-05-21 00:00:00		2022-10-22 00:00:00
elect_date		None		None		None		None		2022-06-07 00:00:00		2022-11-08 00:00:00		None		2022-06-07 00:00:00		2022-11-08 00:00:00
filer_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
filer_st		CA		CA		CA		CA		CA		CA		CA		CA		CA
filer_zip4		95815		95815		95815		95815		95815		95815		95815		95815		95815
filer_phon		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733
filer_fax		(916) 333-1344		(916) 333-1344		(916) 333-1344		(916) 333-1344		(916) 333-1344		(916) 333-1344		(916) 333-1344		(916) 333-1344		(916) 333-1344
file_email		Guerra2024@deaneandcompany.com		Guerra2024@deaneandcompany.com		Guerra2024@deaneandcompany.com		Guerra2024@deaneandcompany.com		Guerra2024@deaneandcompany.com		Guerra2024@deaneandcompany.com		Guerra2024@deaneandcompany.com		Guerra2024@deaneandcompany.com		Guerra2024@deaneandcompany.com
mail_city		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None
tres_naml		Guerra		Guerra		Guerra		Guerra		Guerra		Guerra		Guerra		Guerra		Guerra
tres_namf		Eric		Eric		Eric		Eric		Eric		Eric		Eric		Eric		Eric
tres_namt		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None
tres_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
tres_st		CA		CA		CA		CA		CA		CA		CA		CA		CA
tres_zip4		95815		95815		95815		95815		95815		95815		95815		95815		95815
tres_phon		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733
tres_fax		None		None		None		None		None		None		None		None		None
tres_email		None		None		None		None		None		None		None		None		None
cmtte_type		C		C		C		C		C		C		C		C		C
control_yn		N		N		N		N		N		N		N		N		N
sponsor_yn		N		N		N		N		N		N		N		N		N
primfrm_yn		N		N		N		None		None		None		None		None		None
brdbase_yn		N		N		N		None		None		None		None		None		None
amendexp_1		Update Summary Page and Schedule F		None		None		None		None		None		None		None		None
amendexp_2		None		None		None		None		None		None		None		None		None
amendexp_3		None		None		None		None		None		None		None		None		None
rpt_att_cb		None		None		None		None		None		None		None		None		None
cmtte_id		None		None		None		None		None		None		None		None		None
reportname		None		None		None		None		None		None		None		None		None
rptfromdt		None		None		None		None		None		None		None		None		None
rptthrudt		None		None		None		None		None		None		None		None		None
emplbus_cb		None		None		None		None		None		None		None		None		None
bus_name		None		None		None		None		None		None		None		None		None
bus_city		None		None		None		None		None		None		None		None		None
bus_st		None		None		None		None		None		None		None		None		None
bus_zip4		None		None		None		None		None		None		None		None		None
bus_inter		None		None		None		None		None		None		None		None		None
busact_cb		None		None		None		None		None		None		None		None		None
busactvity		None		None		None		None		None		None		None		None		None
assoc_cb		None		None		None		None		None		None		None		None		None
assoc_int		None		None		None		None		None		None		None		None		None
other_cb		None		None		None		None		None		None		None		None		None
other_int		None		None		None		None		None		None		None		None		None
cand_naml		Guerra		Guerra		Guerra		Guerra		Guerra		Guerra		Guerra		Guerra		Guerra
cand_namf		Eric		Eric		Eric		Eric		Eric		Eric		Eric		Eric		Eric
cand_namt		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None
cand_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
cand_st		CA		CA		CA		CA		CA		CA		CA		CA		CA
cand_zip4		95815		95815		95815		95815		95815		95815		95815		95815		95815
cand_phon		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733		(916) 285-5733
cand_fax		None		None		None		None		None		None		None		None		None
cand_email		None		None		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None
office_cd		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM
offic_dscr		None		None		None		None		None		None		None		None		None
juris_cd		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
juris_dscr		City of Sacramento		City of Sacramento		City of Sacramento		City of Sacramento		City of Sacramento		City of Sacramento		City of Sacramento		City of Sacramento		City of Sacramento
dist_no		6		6		6		6		6		6		6		6		6
off_s_h_cd		H		H		H		H		H		H		H		H		H
sup_opp_cd		None		None		None		None		None		None		None		None		None
employer		None		None		None		None		None		None		None		None		None
occupation		None		None		None		None		None		None		None		None		None
selfemp_cb		None		None		None		None		None		None		None		None		None
bal_id		None		None		None		None		None		None		None		None		None
cand_id		None		None		None		None		None		None		None		None		None

Table: filer_address

filer_id		1431012
adrid		2498828
effect_dt		2020-08-25 00:00:00
add_type		7051
session_id		2019

Table: filer_filings

filer_id		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012		1431012
filing_id		2535090		2500609		2602778		2553306		2692867		2560059		2635455		2686716		2672904		2694165		2648681		2706944		2560059		2607942		2553306		2725745		2743841		2736536
period_id		None		None		245		241		None		None		247		250		249		None		None		250		None		None		241		251		251		None
form_id		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		0		0		0
filing_date		2020-11-12 00:00:00		2020-08-25 00:00:00		2021-08-02 00:00:00		2021-02-01 00:00:00		2022-04-28 00:00:00		2021-02-01 00:00:00		2022-01-19 00:00:00		2022-05-26 00:00:00		2022-04-28 00:00:00		2022-05-26 00:00:00		2022-01-19 00:00:00		2022-08-01 00:00:00		2021-04-30 00:00:00		2021-08-02 00:00:00		2021-04-30 00:00:00		2022-09-29 00:00:00		2022-10-27 00:00:00		2022-08-01 00:00:00
stmnt_type		10006		10005		10001		10001		10005		10005		10001		10001		10001		10005		10005		10001		10006		10005		10002		10001		10001		10005
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003
session_id		2019		2019		2021		2019		2021		2019		2021		2021		2021		2021		2021		2021		2019		2021		2019		2021		2021		2021
user_id		IMEDINA		PADAMS		KRUSSELL		KRUSSELL		KRUSSELL		KRUSSELL		KRUSSELL		CAFILER		KRUSSELL		JMAVES		KRUSSELL		CAFILER		JRAMOS		KRUSSELL		CAFILER		CAFILER		CAFILER		RGEREMIA
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		None		None		2021-01-01 00:00:00		2020-01-01 00:00:00		2022-01-01 00:00:00		2020-01-01 00:00:00		2021-07-01 00:00:00		2022-04-24 00:00:00		2022-01-01 00:00:00		2022-04-24 00:00:00		2021-07-01 00:00:00		2022-05-22 00:00:00		2020-01-01 00:00:00		2021-01-01 00:00:00		2020-01-01 00:00:00		2022-07-01 00:00:00		2022-09-25 00:00:00		2022-05-22 00:00:00
rpt_end		None		None		2021-06-30 00:00:00		2020-12-31 00:00:00		2022-04-23 00:00:00		2020-12-31 00:00:00		2021-12-31 00:00:00		2022-05-21 00:00:00		2022-04-23 00:00:00		2022-05-21 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2020-12-31 00:00:00		2022-09-24 00:00:00		2022-10-22 00:00:00		2022-06-30 00:00:00
rpt_date		None		None		2021-07-12 00:00:00		2021-01-29 00:00:00		None		None		2022-01-15 00:00:00		2022-05-22 00:00:00		2022-04-24 00:00:00		None		None		2022-07-18 00:00:00		None		None		2021-04-30 00:00:00		2022-09-26 00:00:00		2022-10-24 00:00:00		None
filing_type		None		None		22001		22001		None		None		22001		22001		22001		None		None		22001		None		None		22001		22001		22001		None

Table: filer_to_filer_type

filer_id		1431012		1431012
filer_type		16		16
active		Y		Y
race		0		0
session_id		2019		2019
category		40002		40002
category_type		40505		40505
sub_category		0		0
effect_dt		2020-08-25 00:00:00		2020-11-12 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		None		None
nyq_dt		None		2020-10-16 00:00:00
party_cd		0		0
county_cd		18004		18004
district_cd		0		0

Table: filer_xref

filer_id		1431012
xref_id		1431012
effect_dt		2020-09-10 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1431012
filer_id		1431012
filer_type		RECIPIENT COMMITTEE
status		ACTIVE
effect_dt		2020-11-12 00:00:00
naml		GUERRA FOR CITY COUNCIL 2024; ERIC
namf		None
namt		None
nams		None
adr1		None
adr2		None
city		SACRAMENTO
st		CA
zip4		95815
phon		9162855733
fax		9163331344
email		guerra2024@deaneandcompany.com

Table: filers

filer_id		1431012

Table: received_filings

filer_id		1431012		1431012
filing_file_name		59689.cal		100521.cal
received_date		2021-04-29 00:00:00		2021-04-30 00:00:00
filing_directory		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp
filing_id		None		None
form_id		None		None
receive_comment		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints