Home

Filing ID: 2739254

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

Table: cvr3_verification_info

filing_id		2739254
amend_id		0
line_item		1
rec_type		CVR3
form_type		F460
tran_id		Treas-CVR3.7804
entity_cd		TRE
sig_date		2022-10-22 00:00:00
sig_loc		Modesto,CA
sig_naml		Francis
sig_namf		Joyce
sig_namt		None
sig_nams		None

Table: cvr_campaign_disclosure

filing_id		2739254
amend_id		0
rec_type		CVR
form_type		F460
filer_id		741618
entity_cd		RCP
filer_naml		Stanislaus Republican Central Committee (State)
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-22 00:00:00
stmt_type		PE
late_rptno		None
from_date		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00
elect_date		2022-11-08 00:00:00
filer_city		Modesto
filer_st		CA
filer_zip4		95356
filer_phon		209-571-8118
filer_fax		None
file_email		Joycfrncs@Aol.Com
mail_city		Modesto
mail_st		CA
mail_zip4		95356
tres_naml		Francis
tres_namf		Joyce
tres_namt		None
tres_nams		None
tres_city		Modesto
tres_st		CA
tres_zip4		95356
tres_phon		209 988-8700
tres_fax		None
tres_email		joycfrncs@aol.com
cmtte_type		G
control_yn		N
sponsor_yn		N
primfrm_yn		Y
brdbase_yn		None
amendexp_1		None
amendexp_2		None
amendexp_3		None
rpt_att_cb		None
cmtte_id		None
reportname		None
rptfromdt		None
rptthrudt		None
emplbus_cb		None
bus_name		None
bus_city		None
bus_st		None
bus_zip4		None
bus_inter		None
busact_cb		None
busactvity		None
assoc_cb		None
assoc_int		None
other_cb		None
other_int		None
cand_naml		None
cand_namf		None
cand_namt		None
cand_nams		None
cand_city		None
cand_st		None
cand_zip4		None
cand_phon		None
cand_fax		None
cand_email		None
bal_name		None
bal_num		None
bal_juris		None
office_cd		None
offic_dscr		None
juris_cd		None
juris_dscr		None
dist_no		None
off_s_h_cd		None
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: expn

filing_id		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254
amend_id		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		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45
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
form_type		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		D		D		D		D		D		D		D		E		E		E		E		E		E		E		E		E
tran_id		D-10338		D-10341		D-10331		D-10344		D-10330		D-10326		D-10342		D-10356		D-10333		D-10348		D-10337		D-10347		D-10352		D-10351		D-10353		D-10329		D-10345		D-10357		D-10328		D-10327		D-10346		D-10354		D-10349		D-10339		D-10355		D-10319		D-10320		D-10321		D-10322		D-10323		D-10324		D-10343		D-10350		D-10332		D-10340		D-10368		E-10269		E-10272		E-10273		E-10271		E-10274		E-10360		E-10367		E-10366		E-10369
entity_cd		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		OTH		OTH		OTH		OTH		OTH		OTH		IND		IND		IND		IND		IND		OTH		OTH		IND		IND		OTH		OTH		COM		IND		OTH
payee_naml		Alanis		Amaral		Bernosky		Blubak		Chen		Christensen		Clauzel		Cortinas		Dahle		Dokoozlian		Flora		Frobase		Gamez		Gilbert		Griepp		Guerrero		Higgins		Hinton		Hochman		Howell		Keating		Maldonado-Padilla		Marks		Martinez		Nichols		None		None		None		None		None		None		Roque		Schemper		Underwood Jacobs		Williams		Gilman		CSPOA		CSPOA		Day		Hart		On Target Arms		eContact Live		Gilman for MID Division 4		Wood		Gowans Printing Company
payee_namf		Juan		Benjamin		Rob		Amy		Lanhee		Lance		Michael		Jeffrey		Brian		Nick		Heath		Robert		Cassandra		Diane		Joni		Jack		Kelley		Nancy		Nathan		Robert		Janice		Paola		Cindy		Daniel		Jeff		None		None		None		None		None		None		Carlos		Clayton		Angela		Jeremiah		Stu		None		None		Joseph		John		None		None		None		Michael		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
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
payee_city		None		None		None		None		None		None		None		None		None		None		Hilmar		None		None		None		None		None		None		Modesto		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		San Rafael		Higley		Higley		Modesto		Modesto		Modesto		Riverbank		San Rafael		Modesto		Modesto
payee_st		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		AZ		AZ		CA		CA		CA		CA		CA		CA		CA
payee_zip4		None		None		None		None		None		None		None		None		None		None		95324		None		None		None		None		None		None		95355		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		94903		85236		85236		95356		95350		95350		95367		94903		95355		95354-2428
expn_date		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-17 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-10-03 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-21 00:00:00
amount		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		422		422		422		422		422		422		456		456		456		456		500		387		2500		600		200		440		707		500		169		468
cum_ytd		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		422		422		422		422		422		422		456		456		456		456		500		None		None		None		None		None		None		None		None		None
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
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		1239		1238		1240		1243		1242		1244		1254		1253		1250
expn_code		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		IKD		MON		TRC		FND		FND		FND		FND		WEB		CTB		OFC		OFC
expn_dscr		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		Expense Made to Support/Oppose State/Local Candidate via Federal Funds Slate Mailer-Member Communication		None		Travel Expenses		Speaker Fee		Event refeshments		Event Entertainment		Event Prize		None		None		Phone reimbursement		Envelopes
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
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
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
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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		1398240		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
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
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
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
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
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
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
cand_naml		Alanis		Amaral		Bernosky		Blubak		Chen		Christensen		Clauzel		Cortinas		Dahle		Dokoozlian		Flora		Frobase		Gamez		Gilbert		Griepp		Guerrero		Higgins		Hinton		Hochman		Howell		Keating		Maldonado-Padilla		Marks		Martinez		Nichols		None		None		None		None		None		None		Roque		Schemper		Underwood Jacobs		Williams		Gilman		None		None		None		None		None		None		None		None		None
cand_namf		Juan		Benjamin		Rob		Amy		Lanhee		Lance		Michael		Jeffrey		Brian		Nick		Heath		Robert		Cassandra		Diane		Joni		Jack		Kelley		Nancy		Nathan		Robert		Janice		Paola		Cindy		Daniel		Jeff		None		None		None		None		None		None		Carlos		Clayton		Angela		Jeremiah		Stu		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
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
office_cd		ASM		CCM		SOS		MAY		CON		SUP		MAY		BED		GOV		OTH		ASM		OTH		BED		BED		BED		TRE		CCM		CCB		ATT		INS		OTH		BED		BED		CCM		BED		None		None		None		None		None		None		CCM		BED		LTG		CCM		OTH		None		None		None		None		None		None		None		None		None
offic_dscr		California State Assembly		Oakdale City Council		California Secretary of State		Turlock Mayor		California Controller		California Superintendent of Public Inst		Patterson Mayor		Turlock USD Board		California Governor		Modesto Irrigation District Board		California State Assembly		Modesto Irrigation District Board		Sylvan USD Board		Oakdake JUSD Board		Sylvan USD Board		California Treasurer		Turlock City Council		Yosemite Community College District		California Attorent General		California Insurance Commissioner		Modesto Irrigation District Board		Turlock USD Board		Modesto City Schools District Board		Ceres City Council		Turlock USD Board		None		None		None		None		None		None		Patterson City Council		Oakdale JUSD Board		California Lt. Governor		Modesto City Council		Modesto Irrigation District Board		None		None		None		None		None		None		None		None		None
juris_cd		ASM		CIT		STW		CIT		STW		STW		CIT		CIT		STW		CTY		ASM		CTY		CIT		CIT		CIT		STW		CIT		CTY		STW		STW		CTY		CIT		CIT		CIT		CIT		None		None		None		None		None		None		CIT		CIT		STW		CIT		CTY		None		None		None		None		None		None		None		None		None
juris_dscr		Assembly District		City of Oakdale		Statewide		City of Turlock		Statewide		Statewide		City of Patterson		Turlock USD Area		Statewide		Modesto Irrigation District Division		Assembly District		Modesto Irrigation District Division		Sylvan USD Area		Oakdake JUSD Area		Sylvan USD Area		Statewide		City of Turlock		Stanislaus County		Statewide		Statewide		Modesto Irrigation District Division		Turlock USD Area		Modesto City Schools District		City of Ceres		Turlock USD Area		None		None		None		None		None		None		City of Patterson		Oakdale JUSD Area		Statewide		City of Modesto		Modesto Irrigation District		None		None		None		None		None		None		None		None		None
dist_no		22		None		None		None		None		None		None		6		None		3		12		3		3		4		5		None		3		2		None		None		2		3		1		None		4		None		None		None		None		None		None		D		1		None		5		4		None		None		None		None		None		None		None		None		None
off_s_h_cd		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		S		S		S		S		S		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		Proposition 1-2022		Proposition 26-2022		Proposition 27-2022		Proposition 29-2022		Proposition 30-2022		Proposition 31-2022		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		1		26		27		29		30		31		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
sup_opp_cd		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		O		O		O		O		O		O		S		S		S		S		S		None		None		None		None		None		None		None		None		None
memo_code		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		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
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
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
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
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

Table: filer_filings

filer_id		1018376
filing_id		2739254
period_id		251
form_id		F460
filing_sequence		0
filing_date		2022-10-22 00:00:00
stmnt_type		10001
stmnt_status		11003
session_id		2021
user_id		CAFILER
special_audit		11003
fine_audit		11003
rpt_start		2022-09-25 00:00:00
rpt_end		2022-10-22 00:00:00
rpt_date		2022-10-22 00:00:00
filing_type		22001

Table: filings

filing_id		2739254
filing_type		22001

Table: hdr

filing_id		2739254
amend_id		0
rec_type		HDR
ef_type		CAL
state_cd		CA
cal_ver		2.01
soft_name		ISP
soft_ver		1.0
hdrcomment		None

Table: rcpt

filing_id		2739254		2739254		2739254
amend_id		0		0		0
line_item		1		2		3
rec_type		RCPT		RCPT		RCPT
form_type		A		A		A
tran_id		A-10266		A-10253		A-10364
entity_cd		OTH		COM		COM
ctrib_naml		Central Valley Construction & Building Supplies		Campos For Assembly 2022; Joel		Heath Flora For Assembly 2022
ctrib_namf		None		None		None
ctrib_namt		None		None		None
ctrib_nams		None		None		None
ctrib_city		Patterson		Hilmar		Hilmar
ctrib_st		CA		CA		CA
ctrib_zip4		95363		95324		95324
ctrib_emp		None		None		None
ctrib_occ		None		None		None
ctrib_self		None		None		None
tran_type		None		None		None
rcpt_date		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-10-12 00:00:00
date_thru		None		None		None
amount		300		1000		5000
cum_ytd		300		1000		6500
cum_oth		None		None		None
ctrib_dscr		None		None		None
cmte_id		None		1442667		1435262
tres_naml		None		None		None
tres_namf		None		None		None
tres_namt		None		None		None
tres_nams		None		None		None
tres_city		None		None		None
tres_st		None		None		None
tres_zip4		None		None		None
intr_naml		None		None		None
intr_namf		None		None		None
intr_namt		None		None		None
intr_nams		None		None		None
intr_city		None		None		None
intr_st		None		None		None
intr_zip4		None		None		None
intr_emp		None		None		None
intr_occ		None		None		None
intr_self		None		None		None
cand_naml		None		None		None
cand_namf		None		None		None
cand_namt		None		None		None
cand_nams		None		None		None
office_cd		None		None		None
offic_dscr		None		None		None
juris_cd		None		None		None
juris_dscr		None		None		None
dist_no		None		None		None
off_s_h_cd		None		None		None
bal_name		None		None		None
bal_num		None		None		None
bal_juris		None		None		None
sup_opp_cd		None		None		None
memo_code		None		None		None
memo_refno		None		None		None
bakref_tid		None		None		None
xref_schnm		None		None		None
xref_match		None		None		None
int_rate		None		None		None
intr_cmteid		None		None		None

Table: smry

filing_id		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254
amend_id		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
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
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
amount_a		6300		0		6300		0		6300		6021		0		6021		0		0		6021		5918		6300		0		6021		6197		0		0		0		6300		0		6300		0		0		0		0		0		0		500		0		500		5971		50		0		6021		0		0		0		0		0		0		0		0		0		0
amount_b		12650		0		12650		0		12650		11172		0		11172		0		0		11172		None		None		None		None		None		None		None		None		None		None		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
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

Table: splt

filing_id		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254		2739254
amend_id		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		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40
pform_type		A		A		A		A		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		D		D		D		D		D		D		D
ptran_id		A-10364		A-10266		A-10253		A-10364		D-10338		D-10341		D-10331		D-10344		D-10330		D-10326		D-10342		D-10356		D-10333		D-10348		D-10337		D-10347		D-10352		D-10351		D-10353		D-10329		D-10345		D-10357		D-10328		D-10327		D-10346		D-10354		D-10349		D-10339		D-10355		D-10319		D-10320		D-10321		D-10322		D-10323		D-10324		D-10343		D-10350		D-10332		D-10340		D-10368
elec_date		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00
elec_amount		1500		300		1000		5000		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		456		422		422		422		422		422		422		456		456		456		456		500
elec_code		P		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G