Home

Filing ID: 2743623

PDF: https://cal-access.sos.ca.gov/PDFGen/pdfgen.prg?filingid=2743623&amendid=1

Table: cvr2_campaign_disclosure

filing_id		2743623		2743623
amend_id		0		1
line_item		1		1
rec_type		CVR2		CVR2
form_type		F460		F460
tran_id		OFC1		OFC1
entity_cd		ATR		ATR
title		None		None
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
f460_part		3		3
cmte_id		None		None
enty_naml		Deane		Hidalgo
enty_namf		Shawnda		Sonia
enty_namt		None		None
enty_nams		None		None
enty_city		Sacramento		Sacramento
enty_st		CA		CA
enty_zip4		95815		95815
enty_phon		(916) 285-5733		(916) 285-5733
enty_fax		None		None
enty_email		None		None
tres_naml		None		None
tres_namf		None		None
tres_namt		None		None
tres_nams		None		None
control_yn		None		None
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
sup_opp_cd		None		None

Table: cvr3_verification_info

filing_id		2743623		2743623
amend_id		0		1
line_item		1		1
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		VER_1.1		VER_1.1
entity_cd		ATR		ATR
sig_date		2022-10-26 00:00:00		2022-11-05 00:00:00
sig_loc		None		None
sig_naml		Shawnda Deane		Sonia Hidalgo
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2743623		2743623
amend_id		1		0
rec_type		CVR		CVR
form_type		F460		F460
filer_id		1443088		1443088
entity_cd		RCP		RCP
filer_naml		Climate Safe California PAC / Tides Advocacy		Climate Safe California PAC / Tides Advocacy
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		001		000
rpt_date		2022-11-05 00:00:00		2022-10-24 00:00:00
stmt_type		PE		PE
late_rptno		None		None
from_date		2022-09-25 00:00:00		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00		2022-10-22 00:00:00
elect_date		2022-11-08 00:00:00		2022-11-08 00:00:00
filer_city		Sacramento		Sacramento
filer_st		CA		CA
filer_zip4		95815		95815
filer_phon		(916) 285-5733		(916) 285-5733
filer_fax		(916) 333-1344		(916) 333-1344
file_email		ClimateSafeCA@deaneandcompany.com		ClimateSafeCA@deaneandcompany.com
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
tres_naml		Cohen		Cohen
tres_namf		Ellie		Ellie
tres_namt		None		None
tres_nams		None		None
tres_city		Sacramento		Sacramento
tres_st		CA		CA
tres_zip4		95815		95815
tres_phon		(916) 285-5733		(916) 285-5733
tres_fax		None		None
tres_email		None		None
cmtte_type		G		G
control_yn		Y		Y
sponsor_yn		N		N
primfrm_yn		N		N
brdbase_yn		None		None
amendexp_1		Update Summary Page, Schedule D & Schedule F		None
amendexp_2		None		None
amendexp_3		None		None
rpt_att_cb		None		None
cmtte_id		None		None
reportname		None		None
rptfromdt		None		None
rptthrudt		None		None
emplbus_cb		None		None
bus_name		None		None
bus_city		None		None
bus_st		None		None
bus_zip4		None		None
bus_inter		None		None
busact_cb		None		None
busactvity		None		None
assoc_cb		None		None
assoc_int		None		None
other_cb		None		None
other_int		None		None
cand_naml		None		None
cand_namf		None		None
cand_namt		None		None
cand_nams		None		None
cand_city		None		None
cand_st		None		None
cand_zip4		None		None
cand_phon		None		None
cand_fax		None		None
cand_email		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
sup_opp_cd		None		None
employer		None		None
occupation		None		None
selfemp_cb		None		None
bal_id		None		None
cand_id		None		None

Table: debt

filing_id		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623
amend_id		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		1
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F		F
tran_id		PAY151		PAY72		PAY163		PAY147		PAY107		PAY143		PAY29		PAY48		PAY155		PAY131		PAY135		PAY115		PAY81		PAY123		PAY127		PAY171		PAY84		PAY111		PAY159		PAY68		PAY98		PAY102		PAY139		PAY76		PAY167		PAY94		PAY89		PAY119		PAY29
entity_cd		IND		IND		IND		IND		IND		IND		OTH		OTH		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		OTH
payee_naml		Amos		Chavez		Collins		Cooper		Darling		Davidson		DevCollaborative, LLC		DevCollaborative, LLC		Doria		Gomez		Grijalva		Hernandez-Bautista		Isaeff		Jamieson		Kailey		Lee		Mano		Millan		Millan		Naimi		Okungbowa		Opalach		Quadra		Segura		Sneed		Swearengin		Sweck		Thorpe		DevCollaborative, LLC
payee_namf		Roaje		Angel Cisneros		Te'Zjon		Reality		Jayden Nathaniel		Patricia M.		None		None		Serene		Monica		Nicholas A.		Jocelin		Clayton		Malachi		Manvir S.		Xang		Daniel		Jesus		Stephanie		Ahmad Jawadi		Itohan		Jaqueline Beth		Nova		Angela Guadalupe		Troi		Isaac Roy		Edward		Karen		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		Woodland		Merced		Elk Grove		El Dorado Hills		Antelope		Sacramento		Winchester		Winchester		Sacramento		Stockton		Antelope		Sacramento		Sacramento		Folsom		Antelope		Sacramento		Sacramento		Sacramento		Elk Grove		Rancho Cordova		Sacramento		Davis		Sacramento		Stockton		Sacramento		West Sacramento		Sacramento		Sacramento		Winchester
payee_st		CA		CA		CA		CA		CA		CA		MA		MA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		MA
payee_zip4		95776		95341		95624		95762		95843		95824		01890		01890		95835		95203		95843		95817		95831		95630		95843		95823		95816		95815		95624		95670		95832		95616		95816		95203		95841		95605		95835		95835		01890
beg_bal		0		0		0		0		0		0		816		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		816
amt_incur		750		750		750		750		750		750		0		280		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		0
amt_paid		0		0		0		0		0		0		816		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		816
end_bal		750		750		750		750		750		750		0		280		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		0
expn_code		IND		IND		IND		IND		IND		IND		WEB		WEB		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		WEB
expn_dscr		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		None		None		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		None
cmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		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		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: expn

filing_id		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623
amend_id		0		0		0		0		0		0		0		0		0		0		0		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
line_item		1		2		3		4		5		6		7		8		9		10		11		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37
rec_type		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN
form_type		D		D		D		E		E		E		E		E		E		E		E		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		E		E		E		E		E		E		E		E
tran_id		EDT1		EDT2		EDT3		EXP27		EXP19		EXP20		EXP30		EXP32		EXP26		EXP28		EXP25		EDT1		PDT3		PDT4		PDT5		PDT6		PDT7		PDT8		PDT9		PDT10		PDT11		PDT12		PDT13		PDT15		PDT16		PDT17		PDT18		PDT19		PDT20		PDT21		PDT22		PDT23		PDT24		PDT25		PDT26		PDT27		PDT28		PDT29		EDT2		EDT3		EXP27		EXP19		EXP20		EXP30		EXP32		EXP26		EXP28		EXP25
entity_cd		COM		COM		COM		IND		COM		OTH		OTH		OTH		IND		IND		OTH		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		IND		COM		OTH		OTH		OTH		IND		IND		OTH
payee_naml		Jones		Jones		Jones		Aguirre		Dave Jones for State Senate 2022		Deane & Company		DevCollaborative, LLC		Olson Remcho, LLP		Salgado		Shetab		The Climate Center Action Fund/Tides Advocacy		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Jones		Aguirre		Dave Jones for State Senate 2022		Deane & Company		DevCollaborative, LLC		Olson Remcho, LLP		Salgado		Shetab		The Climate Center Action Fund/Tides Advocacy
payee_namf		Dave		Dave		Dave		Cesar Julian		None		None		None		None		Luis A. Cisneros		Zohra		None		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Dave		Cesar Julian		None		None		None		None		Luis A. Cisneros		Zohra		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		None		None		None		Sacramento		Sacramento		Sacramento		Winchester		West Sacramento		Merced		Sacramento		El Monte		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Sacramento		Sacramento		Sacramento		Winchester		West Sacramento		Merced		Sacramento		El Monte
payee_st		None		None		None		CA		CA		CA		MA		CA		CA		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		CA		CA		MA		CA		CA		CA		CA
payee_zip4		None		None		None		95814		95815		95815		01890		95814		95341		95832		91731		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		95814		95815		95815		01890		95814		95341		95832		91731
expn_date		2022-10-20 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-06 00:00:00		2022-10-11 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-06 00:00:00		2022-10-11 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00
amount		2000		2250		2000		2000		2500		505		816		238		2250		2000		12000		2000		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		750		2250		2000		2000		2500		505		816		238		2250		2000		12000
cum_ytd		6250		6250		6250		2000		5000		2536		816		238		2250		2000		12000		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		25750		2000		5000		2536		1096		238		2250		2000		12000
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_chkno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_code		IND		IND		IND		IND		None		PRO		WEB		PRO		IND		IND		CVC		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		None		PRO		WEB		PRO		IND		IND		CVC
expn_dscr		Field Expenses		Field Expenses		Field Expenses		Field Expenses/Support/Dave Jones/State Senate/District 8		Re-Issue of Refunded Contribution; See Schedule I		None		None		None		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		None		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses		Field Expenses/Support/Dave Jones/State Senate/District 8		Re-Issue of Refunded Contribution; See Schedule I		None		None		None		Field Expenses/Support/Dave Jones/State Senate/District 8		Field Expenses/Support/Dave Jones/State Senate/District 8		None
agent_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmte_id		None		None		None		None		1435640		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1435640		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		Dave Jones		Dave Jones		Dave Jones		None		None		None		None		None		None		None		None		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		Dave Jones		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		SEN		SEN		SEN		None		None		None		None		None		None		None		None		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		SEN		SEN		SEN		None		None		None		None		None		None		None		None		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		SEN		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		8		8		8		None		None		None		None		None		None		None		None		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		8		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		S		S		S		None		None		None		None		None		None		None		None		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
g_from_e_f		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_filings

filer_id		1443088		1443088
filing_id		2743623		2743623
period_id		251		251
form_id		F460		F460
filing_sequence		0		1
filing_date		2022-10-27 00:00:00		2022-11-07 00:00:00
stmnt_type		10001		10002
stmnt_status		11003		11003
session_id		2021		2021
user_id		CAFILER		CAFILER
special_audit		11003		11003
fine_audit		11003		11003
rpt_start		2022-09-25 00:00:00		2022-09-25 00:00:00
rpt_end		2022-10-22 00:00:00		2022-10-22 00:00:00
rpt_date		2022-10-24 00:00:00		2022-11-05 00:00:00
filing_type		22001		22001

Table: filings

filing_id		2743623
filing_type		22001

Table: hdr

filing_id		2743623		2743623
amend_id		0		1
rec_type		HDR		HDR
ef_type		CAL		CAL
state_cd		CA		CA
cal_ver		2.01		2.01
soft_name		NETFILE		NETFILE
soft_ver		2022451		2022451
hdrcomment		None		None

Table: rcpt

filing_id		2743623		2743623		2743623		2743623
amend_id		0		0		1		1
line_item		1		2		1		2
rec_type		RCPT		RCPT		RCPT		RCPT
form_type		A		I		A		I
tran_id		INC21		INC18		INC21		INC18
entity_cd		COM		COM		COM		COM
ctrib_naml		California Alliance, a Coalition of Consumer Attorney's and Conservationist		Dave Jones for State Senate 2022		California Alliance, a Coalition of Consumer Attorney's and Conservationist		Dave Jones for State Senate 2022
ctrib_namf		None		None		None		None
ctrib_namt		None		None		None		None
ctrib_nams		None		None		None		None
ctrib_city		Sacramento		Sacramento		Sacramento		Sacramento
ctrib_st		CA		CA		CA		CA
ctrib_zip4		95814		95815		95814		95815
ctrib_emp		None		None		None		None
ctrib_occ		None		None		None		None
ctrib_self		None		None		None		None
tran_type		None		None		None		None
rcpt_date		2022-10-11 00:00:00		2022-10-05 00:00:00		2022-10-11 00:00:00		2022-10-05 00:00:00
date_thru		None		None		None		None
amount		100000		2500		100000		2500
cum_ytd		100000		0		100000		0
cum_oth		None		None		None		None
ctrib_dscr		None		Refund of Contribution		None		Refund of Contribution
cmte_id		240727		1435640		240727		1435640
tres_naml		None		None		None		None
tres_namf		None		None		None		None
tres_namt		None		None		None		None
tres_nams		None		None		None		None
tres_city		None		None		None		None
tres_st		None		None		None		None
tres_zip4		None		None		None		None
intr_naml		None		None		None		None
intr_namf		None		None		None		None
intr_namt		None		None		None		None
intr_nams		None		None		None		None
intr_city		None		None		None		None
intr_st		None		None		None		None
intr_zip4		None		None		None		None
intr_emp		None		None		None		None
intr_occ		None		None		None		None
intr_self		None		None		None		None
cand_naml		None		None		None		None
cand_namf		None		None		None		None
cand_namt		None		None		None		None
cand_nams		None		None		None		None
office_cd		None		None		None		None
offic_dscr		None		None		None		None
juris_cd		None		None		None		None
juris_dscr		None		None		None		None
dist_no		None		None		None		None
off_s_h_cd		None		None		None		None
bal_name		None		None		None		None
bal_num		None		None		None		None
bal_juris		None		None		None		None
sup_opp_cd		None		None		None		None
memo_code		None		None		None		None
memo_refno		None		None		None		None
bakref_tid		None		None		None		None
xref_schnm		None		None		None		None
xref_match		None		None		None		None
int_rate		None		None		None		None
intr_cmteid		None		None		None		None

Table: smry

filing_id		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623		2743623
amend_id		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		1		2		3		1		2		3		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		4		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		1		2		3		1		2		3		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		4
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		B1		B1		B1		C		C		C		D		D		D		E		E		E		E		F		F		F		H		H		H		I		I		I		I		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		B1		B1		B1		C		C		C		D		D		D		E		E		E		E		F		F		F		H		H		H		I		I		I		I
amount_a		100075		0		100075		0		100075		22308		0		22308		18964		0		41272		70418		100075		2500		22308		150685		0		0		19780		100000		75		100075		0		0		0		0		0		0		25750		0		25750		22308		0		0		22308		19780		816		18964		0		0		0		2500		0		0		2500		100075		0		100075		0		100075		22308		0		22308		-816		0		21492		70418		100075		2500		22308		150685		0		0		0		100000		75		100075		0		0		0		0		0		0		6250		0		6250		22308		0		0		22308		0		816		-816		0		0		0		2500		0		0		2500
amount_b		175075		0		175075		0		175075		26890		0		26890		19780		0		46670		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		175075		0		175075		0		175075		26890		0		26890		0		0		26890		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount_c		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None