Home

Filer ID: 1437679

Table: cvr_campaign_disclosure

filing_id		2610980		2643199		2643199		2643199		2729969		2714951		2697930		2722605		2711405		2710732		2723203		2724117		2721926		2751205		2734267
amend_id		0		0		1		2		0		0		0		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F461		F461		F461		F461		F497		F497		F461		F497		F497		F497		F497		F497		F497		F497		F497
filer_id		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679
entity_cd		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI		MDI
filer_naml		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL
filer_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		000		001		002		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2021-09-09 00:00:00		2022-01-31 00:00:00		2022-04-18 00:00:00		2022-05-03 00:00:00		2022-10-07 00:00:00		2022-08-26 00:00:00		2022-07-13 00:00:00		2022-09-22 00:00:00		2022-08-15 00:00:00		2022-08-12 00:00:00		2022-09-23 00:00:00		2022-09-27 00:00:00		2022-09-20 00:00:00		2022-11-02 00:00:00		2022-10-14 00:00:00
stmt_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
late_rptno		None		None		None		None		G2249708		G2249703		None		G2249705		G2249702		G2249701		G2249706		G2249707		G2249704		G2249710		G2249709
from_date		2020-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		None		None		2022-01-01 00:00:00		None		None		None		None		None		None		None		None
thru_date		2020-12-31 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		None		None		2022-06-30 00:00:00		None		None		None		None		None		None		None		None
elect_date		None		None		None		None		None		None		2022-06-07 00:00:00		None		None		None		None		None		None		None		None
filer_city		FONTANA		FONTANA		FONTANA		FONTANA		FONTANA		FONTANA		FONTANA		FONTANA		FONTANA		FONTANA		FONTANA		FONTANA		FONTANA		FONTANA		FONTANA
filer_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
filer_zip4		92335		92335		92335		92335		92335		92335		92335		92335		92335		92335		92335		92335		92335		92335		92335
filer_phon		9095198202		9095198202		9095198202		9095198202		9095198202		9095198202		9095198202		9095198202		9095198202		9095198202		9095198202		9095198202		9095198202		9095198202		9095198202
filer_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
file_email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
mail_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		Cothran		Cothran		Cothran		Cothran		None		None		Cothran		None		None		None		None		None		None		None		None
tres_namf		Phil		Phil		Phil		Phil		None		None		Phil		None		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
control_yn		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sponsor_yn		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
primfrm_yn		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
brdbase_yn		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_1		None		None		Correct entry for contribution made 12/13/2021 and remove contributions to federal candidates.		Correct candidate data for the Paul Cook contribution.		None		None		None		None		None		None		None		None		None		None		None
amendexp_2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_3		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rpt_att_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
reportname		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptfromdt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptthrudt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
emplbus_cb		X		X		X		X		None		None		X		None		None		None		None		None		None		None		None
bus_name		State Farm		State Farm		State Farm		State Farm		None		None		State Farm		None		None		None		None		None		None		None		None
bus_city		Fontana		Fontana		Fontana		Fontana		None		None		Fontana		None		None		None		None		None		None		None		None
bus_st		CA		CA		CA		CA		None		None		CA		None		None		None		None		None		None		None		None
bus_zip4		92335		92335		92335		92335		None		None		92335		None		None		None		None		None		None		None		None
bus_inter		Insurance		Insurance		Insurance		Insurance		None		None		Insurance		None		None		None		None		None		None		None		None
busact_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
busactvity		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
employer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
occupation		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
selfemp_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_address

filer_id		1437679		1437679		1437679
adrid		2523474		2538799		2516925
effect_dt		2021-09-09 00:00:00		2022-07-08 00:00:00		2021-04-13 00:00:00
add_type		7051		7051		7051
session_id		2021		2021		2021

Table: filer_filings

filer_id		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679		1437679
filing_id		2643199		2697930		2573798		2610980		2643199		2643199		2714951		2663626		2663626		2724117		2723203		2711405		2699978		2663626		2710732		2721926		2722605		2734267		2729969		2751205
period_id		245		249		None		241		245		245		251		None		None		251		251		251		None		None		251		251		251		252		252		252
form_id		F461		F461		F461		F461		F461		F461		F497		F461		F461		F497		F497		F497		F461		F461		F497		F497		F497		F497		F497		F497
filing_sequence		2		0		0		0		0		1		0		1		2		0		0		0		0		0		0		0		0		0		0		0
filing_date		2022-05-03 00:00:00		2022-07-13 00:00:00		2021-01-29 00:00:00		2021-09-09 00:00:00		2022-01-31 00:00:00		2022-04-18 00:00:00		2022-08-26 00:00:00		2022-04-21 00:00:00		2022-05-09 00:00:00		2022-09-27 00:00:00		2022-09-23 00:00:00		2022-08-15 00:00:00		2022-07-21 00:00:00		2022-02-01 00:00:00		2022-08-12 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-10-14 00:00:00		2022-10-07 00:00:00		2022-11-02 00:00:00
stmnt_type		10002		10001		10005		10001		10001		10002		10001		10006		10006		10001		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003
session_id		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		GTAYLOR		GTAYLOR		GCLARA		LPHEAV		GTAYLOR		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		CAFILER		CAFILER		CAFILER		GTAYLOR		GTAYLOR		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003
rpt_start		2021-01-01 00:00:00		2022-01-01 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2022-08-26 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2022-09-27 00:00:00		2022-09-23 00:00:00		2022-08-15 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2022-08-12 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-10-14 00:00:00		2022-10-07 00:00:00		2022-11-02 00:00:00
rpt_end		2021-12-31 00:00:00		2022-06-30 00:00:00		2020-12-31 00:00:00		2020-12-31 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2022-08-26 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2022-09-27 00:00:00		2022-09-23 00:00:00		2022-08-15 00:00:00		2022-06-30 00:00:00		2021-12-31 00:00:00		2022-08-12 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-10-14 00:00:00		2022-10-07 00:00:00		2022-11-02 00:00:00
rpt_date		2022-05-03 00:00:00		2022-07-13 00:00:00		None		2021-09-09 00:00:00		2022-01-31 00:00:00		2022-04-18 00:00:00		2022-08-26 00:00:00		None		None		2022-09-27 00:00:00		2022-09-23 00:00:00		2022-08-15 00:00:00		None		None		2022-08-12 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-10-14 00:00:00		2022-10-07 00:00:00		2022-11-02 00:00:00
filing_type		22006		22006		None		22006		22006		22006		22006		None		None		22006		22006		22006		None		None		22006		22006		22006		22006		22006		22006

Table: filer_to_filer_type

filer_id		1437679
filer_type		10
active		Y
race		0
session_id		2021
category		0
category_type		40502
sub_category		0
effect_dt		2021-01-29 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		0
county_cd		0
district_cd		0

Table: filer_xref

filer_id		1437679
xref_id		1437679
effect_dt		2021-04-13 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1437679		1437679		1437679
filer_id		1437679		1437679		1437679
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE
effect_dt		2021-01-29 00:00:00		2021-01-29 00:00:00		2021-01-29 00:00:00
naml		COTHRAN, PHIL		COTHRAN, PHIL		COTHRAN, PHIL
namf		None		None		None
namt		None		None		None
nams		None		None		None
adr1		None		None		None
adr2		None		None		None
city		FONTANA		FONTANA		FONTANA
st		CA		CA		CA
zip4		92335		92335		92335
phon		9095198202		9095198202		9095198202
fax		None		None		None
email		None		[email protected]		[email protected]

Table: filers

filer_id		1437679