Home

Filing ID: 2725222

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

Table: cvr2_campaign_disclosure

filing_id		2725222		2725222		2725222
amend_id		2		0		1
line_item		1		1		1
rec_type		CVR2		CVR2		CVR2
form_type		F460		F460		F460
tran_id		OFC1		OFC1		OFC1
entity_cd		ATR		ATR		ATR
title		None		None		None
mail_city		None		None		None
mail_st		None		None		None
mail_zip4		None		None		None
f460_part		3		3		3
cmte_id		None		None		None
enty_naml		Titus		Titus		Titus
enty_namf		Ashlee N.		Ashlee N.		Ashlee N.
enty_namt		None		None		None
enty_nams		None		None		None
enty_city		Sacramento		Sacramento		Sacramento
enty_st		CA		CA		CA
enty_zip4		95814		95814		95814
enty_phon		916-442-7757		916-442-7757		916-442-7757
enty_fax		None		None		None
enty_email		None		None		None
tres_naml		None		None		None
tres_namf		None		None		None
tres_namt		None		None		None
tres_nams		None		None		None
control_yn		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

Table: cvr3_verification_info

filing_id		2725222		2725222		2725222		2725222		2725222		2725222
amend_id		2		2		0		0		1		1
line_item		1		2		1		2		1		2
rec_type		CVR3		CVR3		CVR3		CVR3		CVR3		CVR3
form_type		F460		F460		F460		F460		F460		F460
tran_id		VER_1.1		VER_2.2		VER_1.1		VER_2.2		VER_1.1		VER_2.2
entity_cd		TRE		SPO		TRE		SPO		TRE		SPO
sig_date		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-09-24 00:00:00		2022-09-24 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00
sig_loc		None		None		None		None		None		None
sig_naml		Thomas W. Hiltachk		Thomas W. Hiltachk		Thomas W. Hiltachk		Thomas W. Hiltachk		Thomas W. Hiltachk		Thomas W. Hiltachk
sig_namf		None		None		None		None		None		None
sig_namt		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None

Table: cvr_campaign_disclosure

filing_id		2725222		2725222		2725222
amend_id		1		0		2
rec_type		CVR		CVR		CVR
form_type		F460		F460		F460
filer_id		1233321		1233321		1233321
entity_cd		RCP		RCP		RCP
filer_naml		California Dental Association Independent Expenditure PAC		California Dental Association Independent Expenditure PAC		California Dental Association Independent Expenditure PAC
filer_namf		None		None		None
filer_namt		None		None		None
filer_nams		None		None		None
report_num		001		000		002
rpt_date		2022-09-30 00:00:00		2022-09-29 00:00:00		2022-10-12 00:00:00
stmt_type		PE		PE		PE
late_rptno		None		None		None
from_date		2022-07-01 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00
thru_date		2022-09-24 00:00:00		2022-09-24 00:00:00		2022-09-24 00:00:00
elect_date		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00
filer_city		Sacramento		Sacramento		Sacramento
filer_st		CA		CA		CA
filer_zip4		95814		95814		95814
filer_phon		916-442-7757		916-442-7757		916-442-7757
filer_fax		None		None		None
file_email		[email protected]		[email protected]		[email protected]
mail_city		Sacramento		Sacramento		Sacramento
mail_st		CA		CA		CA
mail_zip4		95814		95814		95814
tres_naml		Hiltachk		Hiltachk		Hiltachk
tres_namf		Thomas W.		Thomas W.		Thomas W.
tres_namt		None		None		None
tres_nams		None		None		None
tres_city		Sacramento		Sacramento		Sacramento
tres_st		CA		CA		CA
tres_zip4		95814		95814		95814
tres_phon		916-442-7757		916-442-7757		916-442-7757
tres_fax		None		None		None
tres_email		None		None		None
cmtte_type		G		G		G
control_yn		Y		Y		Y
sponsor_yn		N		N		N
primfrm_yn		N		N		N
brdbase_yn		None		None		None
amendexp_1		Amend Summary Page and Schedule F to add accrued expenses.		None		Amend Summary Page and Schedule F to add accrued expenses.
amendexp_2		None		None		None
amendexp_3		None		None		None
rpt_att_cb		None		None		None
cmtte_id		None		None		None
reportname		None		None		None
rptfromdt		None		None		None
rptthrudt		None		None		None
emplbus_cb		None		None		None
bus_name		None		None		None
bus_city		None		None		None
bus_st		None		None		None
bus_zip4		None		None		None
bus_inter		None		None		None
busact_cb		None		None		None
busactvity		None		None		None
assoc_cb		None		None		None
assoc_int		None		None		None
other_cb		None		None		None
other_int		None		None		None
cand_naml		None		None		None
cand_namf		None		None		None
cand_namt		None		None		None
cand_nams		None		None		None
cand_city		None		None		None
cand_st		None		None		None
cand_zip4		None		None		None
cand_phon		None		None		None
cand_fax		None		None		None
cand_email		None		None		None
bal_name		None		None		None
bal_num		None		None		None
bal_juris		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
sup_opp_cd		None		None		None
employer		None		None		None
occupation		None		None		None
selfemp_cb		None		None		None
bal_id		None		None		None
cand_id		None		None		None

Table: debt

filing_id		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222
amend_id		2		2		2		2		2		2		0		0		0		1		1		1		1
line_item		1		2		3		4		5		6		1		2		3		1		2		3		4
rec_type		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
tran_id		PAY84629		PAY84890		PAY84886		PAY84898		PAY84783		PAY84786		PAY84629		PAY84783		PAY84786		PAY84629		PAY84886		PAY84783		PAY84786
entity_cd		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Bell, McAndrews & Hiltachk, LLP		VoterLink		Bold Decision Consulting LLC		Bold Decision Consulting LLC		Goodwin Simon Strategic Research, Inc.		Fairbank, Maslin, Maullin, Metz & Associates		Bell, McAndrews & Hiltachk, LLP		Goodwin Simon Strategic Research, Inc.		Fairbank, Maslin, Maullin, Metz & Associates		Bell, McAndrews & Hiltachk, LLP		Bold Decision Consulting LLC		Goodwin Simon Strategic Research, Inc.		Fairbank, Maslin, Maullin, Metz & Associates
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_namt		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
payee_city		Sacramento		Alpine		Washington		Washington		Culver City		Oakland		Sacramento		Culver City		Oakland		Sacramento		Washington		Culver City		Oakland
payee_st		CA		UT		DC		DC		CA		CA		CA		CA		CA		CA		DC		CA		CA
payee_zip4		95814		84004		20016		20016		90232		94612		95814		90232		94612		95814		20016		90232		94612
beg_bal		1020		0		0		0		0		0		1020		0		0		1020		0		0		0
amt_incur		0		2650		5333		5333		6893		13150		0		6893		13150		0		10667		6893		13150
amt_paid		1020		0		0		0		0		0		1020		0		0		1020		0		0		0
end_bal		0		2650		5333		5333		6893		13150		0		6893		13150		0		10667		6893		13150
expn_code		PRO		IND		IND		POL		POL		IND		PRO		POL		POL		PRO		POL		POL		IND
expn_dscr		None		POL; Support; Tom Lackey; AD34		POL; Support; Janet Nguyen; SD36		None		None		POL; Support; Angelique Ashby; SD08		None		None		None		None		None		None		POL; Support; Angelique Ashby; SD08
cmte_id		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
tres_namf		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
tres_nams		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
tres_st		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
memo_code		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
bakref_tid		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
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: expn

filing_id		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222
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		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		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		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		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		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
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		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		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G		G		G		D		D		D		D		D		D		D		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G		G		G		D		D		D		D		D		D		D		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G		G		G
tran_id		EXP84767		EDT871		EDT872		EDT873		EDT874		EDT877		EDT878		EDT879		EXP84630		EXP84671		EXP84773		EXP84767		EXP84768		EXP84770		EXP84769		EXP84771		EXP84774		EXP84775		EXP84776		EXP84777		EXP84778		EXP84779		EXP84780		EDT875		EDT880		PDT97		PDT99		EDT876		EDT881		EXP84767		EDT871		EDT872		EDT873		EDT874		EDT877		EDT878		EDT879		EXP84630		EXP84671		EXP84773		EXP84767		EXP84768		EXP84770		EXP84769		EXP84771		EXP84774		EXP84775		EXP84776		EXP84777		EXP84778		EXP84779		EXP84780		EDT875		EDT880		PDT97		PDT99		EDT876		EDT881		EXP84767		EDT871		EDT872		EDT873		EDT874		EDT877		EDT878		EDT879		EXP84630		EXP84671		EXP84773		EXP84767		EXP84768		EXP84770		EXP84769		EXP84771		EXP84774		EXP84775		EXP84776		EXP84777		EXP84778		EXP84779		EXP84780		EDT875		EDT880		PDT97		PDT99		EDT876		EDT881
entity_cd		COM		COM		COM		COM		COM		COM		COM		COM		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		COM		COM		COM		COM		COM		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		COM		COM		COM		COM		COM		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Californians for Better Priorities Supporting Dr. Jasmeet Bains for Assembly 2022		Suzette Martinez Valladares G2022		Suzette Martinez Valladares G2022		Suzette Martinez Valladares G2022		Suzette Martinez Valladares G2022		Pilar Schiavo G2022		Pilar Schiavo G2022		Pilar Schiavo G2022		Bell, McAndrews & Hiltachk, LLP		Bell, McAndrews & Hiltachk, LLP		Uptown Strategies, LLC		Californians for Better Priorities Supporting Dr. Jasmeet Bains for Assembly 2022		Prospect Strategic Communications LLC		Bold Decision Consulting LLC		Uptown Strategies, LLC		Bold Decision Consulting LLC		Aaron, Thomas & Associates, Inc.		Nygren & Company, Inc.		Nygren & Company, Inc.		Uptown Strategies, LLC		Aaron, Thomas & Associates, Inc.		Nygren & Company, Inc.		Nygren & Company, Inc.		United States Postal Service		United States Postal Service		Elliott Benson Research		KGS Research, Inc.		VoterLink		VoterLink		Californians for Better Priorities Supporting Dr. Jasmeet Bains for Assembly 2022		Suzette Martinez Valladares G2022		Suzette Martinez Valladares G2022		Suzette Martinez Valladares G2022		Suzette Martinez Valladares G2022		Pilar Schiavo G2022		Pilar Schiavo G2022		Pilar Schiavo G2022		Bell, McAndrews & Hiltachk, LLP		Bell, McAndrews & Hiltachk, LLP		Uptown Strategies, LLC		Californians for Better Priorities Supporting Dr. Jasmeet Bains for Assembly 2022		Prospect Strategic Communications LLC		Bold Decision Consulting LLC		Uptown Strategies, LLC		Bold Decision Consulting LLC		Aaron, Thomas & Associates, Inc.		Nygren & Company, Inc.		Nygren & Company, Inc.		Uptown Strategies, LLC		Aaron, Thomas & Associates, Inc.		Nygren & Company, Inc.		Nygren & Company, Inc.		United States Postal Service		United States Postal Service		Elliott Benson Research		KGS Research, Inc.		VoterLink		VoterLink		Californians for Better Priorities Supporting Dr. Jasmeet Bains for Assembly 2022		Suzette Martinez Valladares G2022		Suzette Martinez Valladares G2022		Suzette Martinez Valladares G2022		Suzette Martinez Valladares G2022		Pilar Schiavo G2022		Pilar Schiavo G2022		Pilar Schiavo G2022		Bell, McAndrews & Hiltachk, LLP		Bell, McAndrews & Hiltachk, LLP		Uptown Strategies, LLC		Californians for Better Priorities Supporting Dr. Jasmeet Bains for Assembly 2022		Prospect Strategic Communications LLC		Bold Decision Consulting LLC		Uptown Strategies, LLC		Bold Decision Consulting LLC		Aaron, Thomas & Associates, Inc.		Nygren & Company, Inc.		Nygren & Company, Inc.		Uptown Strategies, LLC		Aaron, Thomas & Associates, Inc.		Nygren & Company, Inc.		Nygren & Company, Inc.		United States Postal Service		United States Postal Service		Elliott Benson Research		KGS Research, Inc.		VoterLink		VoterLink
payee_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Sacramento		None		None		None		None		None		None		None		Sacramento		Sacramento		Washington		Sacramento		El Segundo		Washington		Washington		Washington		Chatsworth		Folsom		Folsom		Washington		Chatsworth		Folsom		Folsom		Chatsworth		Chatsworth		Sacramento		Las Vegas		Alpine		Alpine		Sacramento		None		None		None		None		None		None		None		Sacramento		Sacramento		Washington		Sacramento		El Segundo		Washington		Washington		Washington		Chatsworth		Folsom		Folsom		Washington		Chatsworth		Folsom		Folsom		Chatsworth		Chatsworth		Sacramento		Las Vegas		Alpine		Alpine		Sacramento		None		None		None		None		None		None		None		Sacramento		Sacramento		Washington		Sacramento		El Segundo		Washington		Washington		Washington		Chatsworth		Folsom		Folsom		Washington		Chatsworth		Folsom		Folsom		Chatsworth		Chatsworth		Sacramento		Las Vegas		Alpine		Alpine
payee_st		CA		None		None		None		None		None		None		None		CA		CA		DC		CA		CA		DC		DC		DC		CA		CA		CA		DC		CA		CA		CA		CA		CA		CA		NV		UT		UT		CA		None		None		None		None		None		None		None		CA		CA		DC		CA		CA		DC		DC		DC		CA		CA		CA		DC		CA		CA		CA		CA		CA		CA		NV		UT		UT		CA		None		None		None		None		None		None		None		CA		CA		DC		CA		CA		DC		DC		DC		CA		CA		CA		DC		CA		CA		CA		CA		CA		CA		NV		UT		UT
payee_zip4		95814		None		None		None		None		None		None		None		95814		95814		20008		95814		90245		20016		20008		20016		91311		95630		95630		20008		91311		95630		95630		91311		91311		95814		89119		84004		84004		95814		None		None		None		None		None		None		None		95814		95814		20008		95814		90245		20016		20008		20016		91311		95630		95630		20008		91311		95630		95630		91311		91311		95814		89119		84004		84004		95814		None		None		None		None		None		None		None		95814		95814		20008		95814		90245		20016		20008		20016		91311		95630		95630		20008		91311		95630		95630		91311		91311		95814		89119		84004		84004
expn_date		2022-09-07 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-22 00:00:00		2022-09-22 00:00:00		2022-07-11 00:00:00		2022-08-19 00:00:00		2022-08-30 00:00:00		2022-09-07 00:00:00		2022-09-08 00:00:00		2022-09-15 00:00:00		2022-09-15 00:00:00		2022-09-16 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-22 00:00:00		2022-09-22 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-24 00:00:00		2022-09-24 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-07 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-22 00:00:00		2022-09-22 00:00:00		2022-07-11 00:00:00		2022-08-19 00:00:00		2022-08-30 00:00:00		2022-09-07 00:00:00		2022-09-08 00:00:00		2022-09-15 00:00:00		2022-09-15 00:00:00		2022-09-16 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-22 00:00:00		2022-09-22 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-24 00:00:00		2022-09-24 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-07 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-22 00:00:00		2022-09-22 00:00:00		2022-07-11 00:00:00		2022-08-19 00:00:00		2022-08-30 00:00:00		2022-09-07 00:00:00		2022-09-08 00:00:00		2022-09-15 00:00:00		2022-09-15 00:00:00		2022-09-16 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-22 00:00:00		2022-09-22 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00		2022-09-24 00:00:00		2022-09-24 00:00:00		2022-09-20 00:00:00		2022-09-22 00:00:00
amount		250000		4590		12529		1359		534		35828		798		1115		1020		1020		15300		250000		6000		6150		9180		8500		12529		534		1359		5657		35828		1115		798		5833		18830		2311		3726		427		638		250000		4590		12529		1359		534		35828		798		1115		1020		1020		15300		250000		6000		6150		9180		8500		12529		534		1359		5657		35828		1115		798		5833		18830		2311		3726		427		638		250000		4590		12529		1359		534		35828		798		1115		1020		1020		15300		250000		6000		6150		9180		8500		12529		534		1359		5657		35828		1115		798		5833		18830		2311		3726		427		638
cum_ytd		250000		19012		19012		19012		19012		37740		37740		37740		5100		5100		30137		250000		6000		14650		30137		14650		48357		3805		3805		30137		48357		3805		3805		24662		24662		2311		3726		1065		1065		250000		19012		19012		19012		19012		37740		37740		37740		5100		5100		30137		250000		6000		25317		30137		25317		48357		3805		3805		30137		48357		3805		3805		24662		24662		2311		3726		3715		3715		250000		19012		19012		19012		19012		37740		37740		37740		5100		5100		30137		250000		6000		25317		30137		25317		48357		3805		3805		30137		48357		3805		3805		24662		24662		2311		3726		1065		1065
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		MON		IND		IND		IND		IND		IND		IND		IND		PRO		PRO		POL		CTB		POL		POL		IND		POL		IND		IND		IND		POL		IND		IND		IND		POS		POS		POL		POL		LIT		LIT		MON		IND		IND		IND		IND		IND		IND		IND		PRO		PRO		POL		CTB		POL		POL		IND		POL		IND		IND		IND		POL		IND		IND		IND		POS		POS		POL		POL		LIT		LIT		MON		IND		IND		IND		IND		IND		IND		IND		PRO		PRO		POL		CTB		POL		POL		IND		POL		IND		IND		IND		POL		IND		IND		IND		POS		POS		POL		POL		LIT		LIT
expn_dscr		None		POL		LIT, POS		LIT		LIT		LIT, POS		LIT		LIT		None		None		None		None		None		None		POL; Support; Suzette Martinez Valladares; AD40		None		LIT, POS; Support; Suzette Martinez Valladares; AD40		LIT; Support; Suzette Martinez Valladares; AD40		LIT; Support; Suzette Martinez Valladares; AD40		None		LIT, POS; Oppose; Pilar Schiavo; AD40		LIT; Oppose; Pilar Schiavo; AD40		LIT; Oppose; Pilar Schiavo; AD40		None		None		None		None		None		None		None		POL		LIT, POS		LIT		LIT		LIT, POS		LIT		LIT		None		None		None		None		None		None		POL; Support; Suzette Martinez Valladares; AD40		None		LIT, POS; Support; Suzette Martinez Valladares; AD40		LIT; Support; Suzette Martinez Valladares; AD40		LIT; Support; Suzette Martinez Valladares; AD40		None		LIT, POS; Oppose; Pilar Schiavo; AD40		LIT; Oppose; Pilar Schiavo; AD40		LIT; Oppose; Pilar Schiavo; AD40		None		None		None		None		None		None		None		POL		LIT, POS		LIT		LIT		LIT, POS		LIT		LIT		None		None		None		None		None		None		POL; Support; Suzette Martinez Valladares; AD40		None		LIT, POS; Support; Suzette Martinez Valladares; AD40		LIT; Support; Suzette Martinez Valladares; AD40		LIT; Support; Suzette Martinez Valladares; AD40		None		LIT, POS; Oppose; Pilar Schiavo; AD40		LIT; Oppose; Pilar Schiavo; AD40		LIT; Oppose; Pilar Schiavo; AD40		None		None		None		None		None		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		Aaron, Thomas & Associates, Inc.		Aaron, Thomas & Associates, Inc.		Fairbank, Maslin, Maullin, Metz & Associates		Fairbank, Maslin, Maullin, Metz & Associates		Nygren & Company, Inc.		Nygren & Company, Inc.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Aaron, Thomas & Associates, Inc.		Aaron, Thomas & Associates, Inc.		Fairbank, Maslin, Maullin, Metz & Associates		Fairbank, Maslin, Maullin, Metz & Associates		Nygren & Company, Inc.		Nygren & Company, Inc.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Aaron, Thomas & Associates, Inc.		Aaron, Thomas & Associates, Inc.		Fairbank, Maslin, Maullin, Metz & Associates		Fairbank, Maslin, Maullin, Metz & Associates		Nygren & Company, Inc.		Nygren & Company, Inc.
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		1447991		None		None		None		None		None		None		None		None		None		None		1447991		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1447991		None		None		None		None		None		None		None		None		None		None		1447991		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1447991		None		None		None		None		None		None		None		None		None		None		1447991		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Dr. Jasmeet Bains		Suzette Martinez Valladares		Suzette Martinez Valladares		Suzette Martinez Valladares		Suzette Martinez Valladares		Pilar Schiavo		Pilar Schiavo		Pilar Schiavo		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Dr. Jasmeet Bains		Suzette Martinez Valladares		Suzette Martinez Valladares		Suzette Martinez Valladares		Suzette Martinez Valladares		Pilar Schiavo		Pilar Schiavo		Pilar Schiavo		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Dr. Jasmeet Bains		Suzette Martinez Valladares		Suzette Martinez Valladares		Suzette Martinez Valladares		Suzette Martinez Valladares		Pilar Schiavo		Pilar Schiavo		Pilar Schiavo		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		ASM		ASM		ASM		ASM		ASM		ASM		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		35		40		40		40		40		40		40		40		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		35		40		40		40		40		40		40		40		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		35		40		40		40		40		40		40		40		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		O		O		O		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		S		S		S		S		S		O		O		O		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		S		S		S		S		S		O		O		O		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		EXP84773		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		EXP84773		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		EXP84773		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		E		E		F		F		E		E		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		E		E		E		E		E		E		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		E		E		E		E		E		E
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		1233321		1233321		1233321
filing_id		2725222		2725222		2725222
period_id		251		251		251
form_id		F460		F460		F460
filing_sequence		0		2		1
filing_date		2022-09-29 00:00:00		2022-10-17 00:00:00		2022-10-03 00:00:00
stmnt_type		10001		10002		10002
stmnt_status		11003		11003		11003
session_id		2021		2021		2021
user_id		CAFILER		CAFILER		CAFILER
special_audit		11003		11003		11003
fine_audit		11003		11003		11003
rpt_start		2022-07-01 00:00:00		2022-07-01 00:00:00		2022-07-01 00:00:00
rpt_end		2022-09-24 00:00:00		2022-09-24 00:00:00		2022-09-24 00:00:00
rpt_date		2022-09-29 00:00:00		2022-10-12 00:00:00		2022-09-30 00:00:00
filing_type		22001		22001		22001

Table: filings

filing_id		2725222
filing_type		22001

Table: hdr

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

Table: rcpt

filing_id		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222
amend_id		2		2		2		2		2		2		2		2		0		0		0		0		0		0		0		0		1		1		1		1		1		1		1		1
line_item		1		2		3		4		5		6		7		8		1		2		3		4		5		6		7		8		1		2		3		4		5		6		7		8
rec_type		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT
form_type		A		A		A		C		C		C		C		I		A		A		A		C		C		C		C		I		A		A		A		C		C		C		C		I
tran_id		INC84654		INC84672		INC84727		NON84571		NON84766		NON84572		NON84781		INC84772		INC84654		INC84672		INC84727		NON84571		NON84766		NON84572		NON84781		INC84772		INC84654		INC84672		INC84727		NON84571		NON84766		NON84572		NON84781		INC84772
entity_cd		IND		COM		IND		OTH		OTH		OTH		OTH		OTH		IND		COM		IND		OTH		OTH		OTH		OTH		OTH		IND		COM		IND		OTH		OTH		OTH		OTH		OTH
ctrib_naml		Belluscio		California Dental Association Political Action Committee (CDA PAC)		Belluscio		California Dental Association		California Dental Association		California Dental Association		California Dental Association		Uptown Strategies, LLC		Belluscio		California Dental Association Political Action Committee (CDA PAC)		Belluscio		California Dental Association		California Dental Association		California Dental Association		California Dental Association		Uptown Strategies, LLC		Belluscio		California Dental Association Political Action Committee (CDA PAC)		Belluscio		California Dental Association		California Dental Association		California Dental Association		California Dental Association		Uptown Strategies, LLC
ctrib_namf		Michael P		None		Michael P		None		None		None		None		None		Michael P		None		Michael P		None		None		None		None		None		Michael P		None		Michael P		None		None		None		None		None
ctrib_namt		Dr.		None		Dr.		None		None		None		None		None		Dr.		None		Dr.		None		None		None		None		None		Dr.		None		Dr.		None		None		None		None		None
ctrib_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
ctrib_city		Fortuna		Sacramento		Fortuna		Sacramento		Sacramento		Sacramento		Sacramento		Washington		Fortuna		Sacramento		Fortuna		Sacramento		Sacramento		Sacramento		Sacramento		Washington		Fortuna		Sacramento		Fortuna		Sacramento		Sacramento		Sacramento		Sacramento		Washington
ctrib_st		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CA		CA		CA		CA		CA		DC
ctrib_zip4		95540-2347		95814		95540-2347		95814		95814		95814		95814		20008		95540-2347		95814		95540-2347		95814		95814		95814		95814		20008		95540-2347		95814		95540-2347		95814		95814		95814		95814		20008
ctrib_emp		Self Employed-no business name		None		Self Employed-no business name		None		None		None		None		None		Self Employed-no business name		None		Self Employed-no business name		None		None		None		None		None		Self Employed-no business name		None		Self Employed-no business name		None		None		None		None		None
ctrib_occ		Dentist		None		Dentist		None		None		None		None		None		Dentist		None		Dentist		None		None		None		None		None		Dentist		None		Dentist		None		None		None		None		None
ctrib_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tran_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpt_date		2022-07-27 00:00:00		2022-08-30 00:00:00		2022-08-31 00:00:00		2022-07-31 00:00:00		2022-08-05 00:00:00		2022-08-31 00:00:00		2022-09-14 00:00:00		2022-09-19 00:00:00		2022-07-27 00:00:00		2022-08-30 00:00:00		2022-08-31 00:00:00		2022-07-31 00:00:00		2022-08-05 00:00:00		2022-08-31 00:00:00		2022-09-14 00:00:00		2022-09-19 00:00:00		2022-07-27 00:00:00		2022-08-30 00:00:00		2022-08-31 00:00:00		2022-07-31 00:00:00		2022-08-05 00:00:00		2022-08-31 00:00:00		2022-09-14 00:00:00		2022-09-19 00:00:00
date_thru		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		51		500000		51		368		1020		368		1020		15300		51		500000		51		368		1020		368		1020		15300		51		500000		51		368		1020		368		1020		15300
cum_ytd		206		750000		206		8541		8541		8541		8541		0		206		750000		206		8541		8541		8541		8541		0		206		750000		206		8541		8541		8541		8541		0
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
ctrib_dscr		None		None		None		None		None		None		None		Refund payment		None		None		None		None		None		None		None		Refund payment		None		None		None		None		None		None		None		Refund payment
cmte_id		None		742855		None		None		None		None		None		None		None		742855		None		None		None		None		None		None		None		742855		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
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
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
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
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
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
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
intr_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
intr_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
intr_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
intr_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
intr_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
intr_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
intr_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
intr_emp		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_occ		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_self		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		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_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
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
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
office_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
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
juris_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
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
dist_no		None		None		None		None		None		None		None		None		None		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		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
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
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
sup_opp_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
memo_code		None		None		None		X		X		X		X		None		None		None		None		X		X		X		X		None		None		None		None		X		X		X		X		None
memo_refno		None		None		None		NON84571		NON84766		NON84572		NON84781		None		None		None		None		NON84571		NON84766		NON84572		NON84781		None		None		None		None		NON84571		NON84766		NON84572		NON84781		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
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
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
int_rate		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_cmteid		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: smry

filing_id		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222
amend_id		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		2		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		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
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		4		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		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		4		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		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		4		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3
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		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		C		C		C		I		I		I		I		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		C		C		C		I		I		I		I		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		C		C		C		I		I		I		I		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H
amount_a		501534		0		501534		0		501534		354989		0		354989		32340		0		387329		56742		501534		15300		354989		218587		0		0		33360		500102		1432		501534		0		0		0		15300		0		0		15300		306752		0		306752		354989		0		0		354989		33360		1020		32340		0		0		0		0		0		0		501534		0		501534		0		501534		354989		0		354989		19023		0		374013		56742		501534		15300		354989		218587		0		0		20043		500102		1432		501534		0		0		0		15300		0		0		15300		306752		0		306752		354989		0		0		354989		20043		1020		19023		0		0		0		0		0		0		501534		0		501534		0		501534		354989		0		354989		29690		0		384679		56742		501534		15300		354989		218587		0		0		30710		500102		1432		501534		0		0		0		15300		0		0		15300		306752		0		306752		354989		0		0		354989		30710		1020		29690		0		0		0		0		0		0
amount_b		763560		0		763560		15575		779135		661761		0		661761		33360		15575		710695		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		763560		0		763560		15575		779135		661761		0		661761		20043		15575		697379		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		763560		0		763560		15575		779135		661761		0		661761		30710		15575		708045		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222		2725222
amend_id		0		0		0		0		0		0		0		2		2		2		2		2		2		2		1		1		1		1		1		1		1
line_item		1		2		3		4		5		6		7		1		2		3		4		5		6		7		1		2		3		4		5		6		7
pform_type		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D
ptran_id		EDT871		EDT872		EDT873		EDT874		EDT877		EDT878		EDT879		EDT871		EDT872		EDT873		EDT874		EDT877		EDT878		EDT879		EDT871		EDT872		EDT873		EDT874		EDT877		EDT878		EDT879
elec_date		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00
elec_amount		19012		19012		19012		19012		37740		37740		37740		19012		19012		19012		19012		37740		37740		37740		19012		19012		19012		19012		37740		37740		37740
elec_code		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G