Home

Filing ID: 2744208

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

Table: cvr2_campaign_disclosure

filing_id		2744208		2744208
amend_id		1		0
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		Deane
enty_namf		Shawnda		Shawnda
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		2744208		2744208		2744208		2744208
amend_id		1		1		0		0
line_item		1		2		1		2
rec_type		CVR3		CVR3		CVR3		CVR3
form_type		F460		F460		F460		F460
tran_id		VER_1.1		VER_2.2		VER_1.1		VER_2.2
entity_cd		ATR		CAO		ATR		CAO
sig_date		2022-11-06 00:00:00		2022-11-06 00:00:00		2022-10-26 00:00:00		2022-10-26 00:00:00
sig_loc		None		None		None		None
sig_naml		Shawnda Deane		Al Muratsuchi		Shawnda Deane		Al Muratsuchi
sig_namf		None		None		None		None
sig_namt		None		None		None		None
sig_nams		None		None		None		None

Table: cvr_campaign_disclosure

filing_id		2744208		2744208
amend_id		1		0
rec_type		CVR		CVR
form_type		F460		F460
filer_id		1435331		1435331
entity_cd		CTL		CTL
filer_naml		Muratsuchi for Assembly 2022		Muratsuchi for Assembly 2022
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		001		000
rpt_date		2022-11-06 00:00:00		2022-10-26 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		Muratsuchi2022@deaneandcompany.con		Muratsuchi2022@deaneandcompany.con
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
tres_naml		Muratsuchi		Muratsuchi
tres_namf		Al		Al
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		C		C
control_yn		Y		Y
sponsor_yn		N		N
primfrm_yn		None		None
brdbase_yn		None		None
amendexp_1		Update Schedule E & Schedule G		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		Muratsuchi		Muratsuchi
cand_namf		Al		Al
cand_namt		None		None
cand_nams		None		None
cand_city		Sacramento		Sacramento
cand_st		CA		CA
cand_zip4		95815		95815
cand_phon		(916) 285-5733		(916) 285-5733
cand_fax		None		None
cand_email		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
office_cd		ASM		ASM
offic_dscr		None		None
juris_cd		ASM		ASM
juris_dscr		None		None
dist_no		66		66
off_s_h_cd		H		H
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		2744208		2744208		2744208		2744208
amend_id		1		1		0		0
line_item		1		2		1		2
rec_type		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F
tran_id		PAY551		PAY605		PAY551		PAY605
entity_cd		OTH		OTH		OTH		OTH
payee_naml		Card Services Center		Card Services Center		Card Services Center		Card Services Center
payee_namf		None		None		None		None
payee_namt		None		None		None		None
payee_nams		None		None		None		None
payee_city		Dallas		Dallas		Dallas		Dallas
payee_st		TX		TX		TX		TX
payee_zip4		75247		75247		75247		75247
beg_bal		2380		0		2380		0
amt_incur		0		156		0		156
amt_paid		2380		0		2380		0
end_bal		0		156		0		156
expn_code		None		None		None		None
expn_dscr		Credit Card Payment		Credit Card Payment		Credit Card Payment		Credit Card Payment
cmte_id		None		None		None		None
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
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

Table: expn

filing_id		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208
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		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		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
form_type		D		D		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G		G		G		G		G		G		D		D		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G		G		G		G		G
tran_id		PDT149		PDT150		EXP566		EXP575		EXP588		EXP599		EXP606		EXP608		EXP569		EXP586		EXP582		EXP576		EXP566		EXP578		EXP579		EXP580		EXP581		EXP601		EXP636		EXP571		EXP589		EXP590		PDT156		PDT149		PDT150		PDT155		PDT152		PDT153		EDT37		EDT39		EDT40		PDT149		PDT150		EXP566		EXP575		EXP588		EXP599		EXP606		EXP608		EXP569		EXP586		EXP582		EXP576		EXP566		EXP578		EXP579		EXP580		EXP581		EXP601		EXP571		EXP589		EXP590		PDT156		PDT149		PDT150		PDT155		PDT152		PDT153		EDT37		EDT39
entity_cd		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		COM		COM		OTH		OTH		OTH		OTH		OTH
payee_naml		Ken Inouye for Huntington Beach City Council 2022		Ken Inouye for Huntington Beach City Council 2022		Melissa Ramoso for City Council 2022		ActBlue Technical Services		ActBlue Technical Services		ActBlue Technical Services		Card Services Center		Card Services Center		Daniel C. Weitzman, LLC		Deane & Company		Digital Tractor Graphic Design		Election Digest		Melissa Ramoso for City Council 2022		NM Marketing		NM Marketing		NM Marketing		NM Marketing		Press Print, Inc.		Press Print, Inc.		Singh		The House of Printing, Inc.		The House of Printing, Inc.		Constant Contact		Ken Inouye for Huntington Beach City Council 2022		Ken Inouye for Huntington Beach City Council 2022		Public Storage		San Francisco Chronicle		TrackNEWS Library		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		Ken Inouye for Huntington Beach City Council 2022		Ken Inouye for Huntington Beach City Council 2022		Melissa Ramoso for City Council 2022		ActBlue Technical Services		ActBlue Technical Services		ActBlue Technical Services		Card Services Center		Card Services Center		Daniel C. Weitzman, LLC		Deane & Company		Digital Tractor Graphic Design		Election Digest		Melissa Ramoso for City Council 2022		NM Marketing		NM Marketing		NM Marketing		NM Marketing		Press Print, Inc.		Singh		The House of Printing, Inc.		The House of Printing, Inc.		Constant Contact		Ken Inouye for Huntington Beach City Council 2022		Ken Inouye for Huntington Beach City Council 2022		Public Storage		San Francisco Chronicle		TrackNEWS Library		U.S. Postmaster		U.S. Postmaster
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Bryan 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		Bryan C.		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
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
payee_city		Huntington Beach		Huntington Beach		Encino		Somerville		Somerville		Somerville		Dallas		Dallas		Sacramento		Sacramento		Sacramento		Torrance		Encino		Palmdale		Palmdale		Palmdale		Palmdale		Banning		Banning		Elk Grove		Pasadena		Pasadena		San Francisco		Huntington Beach		Huntington Beach		Torrance		San Francisco		Shady Dale		Washington		Washington		Washington		Huntington Beach		Huntington Beach		Encino		Somerville		Somerville		Somerville		Dallas		Dallas		Sacramento		Sacramento		Sacramento		Torrance		Encino		Palmdale		Palmdale		Palmdale		Palmdale		Banning		Elk Grove		Pasadena		Pasadena		San Francisco		Huntington Beach		Huntington Beach		Torrance		San Francisco		Shady Dale		Washington		Washington
payee_st		CA		CA		CA		MA		MA		MA		TX		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		GA		DC		DC		DC		CA		CA		CA		MA		MA		MA		TX		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		GA		DC		DC
payee_zip4		92646		92646		91436		02144		02144		02144		75247		75247		95814		95815		95818		90505		91436		93552		93552		93552		93552		92220		92220		95758		91107		91107		94105		92646		92646		90501		94103		31085		20260		20260		20260		92646		92646		91436		02144		02144		02144		75247		75247		95814		95815		95818		90505		91436		93552		93552		93552		93552		92220		95758		91107		91107		94105		92646		92646		90501		94103		31085		20260		20260
expn_date		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-10-09 00:00:00		2022-10-16 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-03 00:00:00		2022-10-13 00:00:00		2022-10-11 00:00:00		2022-10-09 00:00:00		2022-09-29 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-05 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-03 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-10-03 00:00:00		2022-09-27 00:00:00		2022-09-30 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-19 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-10-09 00:00:00		2022-10-16 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-03 00:00:00		2022-10-13 00:00:00		2022-10-11 00:00:00		2022-10-09 00:00:00		2022-09-29 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-19 00:00:00		2022-10-05 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-03 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-10-03 00:00:00		2022-09-27 00:00:00		2022-09-30 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00
amount		500		500		500		0		11		4		2380		1721		4000		2506		1306		700		500		2713		1604		1250		1421		843		727		500		2450		1936		65		500		500		192		20		335		2713		1421		843		500		500		500		0		11		4		2380		1721		4000		2506		1306		700		500		2713		1604		1250		1421		1571		500		2450		1936		65		500		500		192		20		335		2713		1421
cum_ytd		1000		1000		500		480		480		480		18334		18334		40000		21939		1306		700		500		6989		6989		6989		6989		1571		1571		1000		5204		5204		745		1000		1000		1638		121		1083		5138		5138		5138		1000		1000		500		480		480		480		18334		18334		40000		21939		1306		700		500		6989		6989		6989		6989		1571		1000		5204		5204		745		1000		1000		1638		121		1083		4295		4295
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
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
expn_code		MON		MON		MON		OFC		OFC		OFC		None		None		FND		PRO		LIT		None		CTB		LIT		POS		LIT		POS		POS		LIT		CNS		LIT		LIT		OFC		CTB		CTB		OFC		OFC		OFC		POS		POS		POS		MON		MON		MON		OFC		OFC		OFC		None		None		FND		PRO		LIT		None		CTB		LIT		POS		LIT		POS		LIT		CNS		LIT		LIT		OFC		CTB		CTB		OFC		OFC		OFC		POS		POS
expn_dscr		None		None		None		None		None		None		Credit Card Payment		Credit Card Payment		None		None		None		Slate Mailer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Credit Card Payment		Credit Card Payment		None		None		None		Slate Mailer		None		None		None		None		None		None		None		None		None		None		None		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		Card Services Center		Card Services Center		Card Services Center		Card Services Center		Card Services Center		Card Services Center		NM Marketing		NM Marketing		Press Print, Inc.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Card Services Center		Card Services Center		Card Services Center		Card Services Center		Card Services Center		Card Services Center		NM Marketing		NM Marketing
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
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
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
cmte_id		None		None		None		None		None		None		None		None		None		None		None		1345303		1409946		None		None		None		None		None		None		None		None		None		None		1451179		1451179		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1345303		1409946		None		None		None		None		None		None		None		None		None		1451179		1451179		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
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
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
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
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
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
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
cand_naml		Kenneth Inouye		Kenneth Inouye		Melissa Ramoso		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Kenneth Inouye		Kenneth Inouye		Melissa Ramoso		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		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
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
office_cd		CCM		CCM		CCM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CCM		CCM		CCM		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		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		OTH		OTH		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		OTH		OTH		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
juris_dscr		City of Huntington Beach		City of Huntington Beach		City of Artesia		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		City of Huntington Beach		City of Huntington Beach		City of Artesia		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
sup_opp_cd		None		None		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		S		None		None		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		None		None		None		None		None		None		None		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		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
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		E		E		E		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		E		E		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
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

Table: filer_filings

filer_id		1435331		1435331
filing_id		2744208		2744208
period_id		251		251
form_id		F460		F460
filing_sequence		1		0
filing_date		2022-11-07 00:00:00		2022-10-27 00:00:00
stmnt_type		10002		10001
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-11-06 00:00:00		2022-10-26 00:00:00
filing_type		22001		22001

Table: filings

filing_id		2744208
filing_type		22001

Table: hdr

filing_id		2744208		2744208
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		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208
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		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		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		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
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		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		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		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		I		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		I
tran_id		INC616		IDT109		INC597		INC573		INC572		INC592		INC568		INC602		IDT113		INC603		INC610		INC611		INC591		IDT111		INC595		INC593		INC612		INC584		INC613		INC564		INC565		INC614		INC617		IDT110		INC600		INC615		INC618		INC577		INC619		INC620		INC621		INC594		INC570		INC622		INC585		INC616		IDT109		INC597		INC573		INC572		INC592		INC568		INC602		IDT113		INC603		INC610		INC611		INC591		IDT111		INC595		INC593		INC612		INC584		INC613		INC564		INC565		INC614		INC617		IDT110		INC600		INC615		INC618		INC577		INC619		INC620		INC621		INC594		INC570		INC622		INC585
entity_cd		IND		IND		OTH		COM		COM		SCC		SCC		SCC		OTH		COM		IND		IND		IND		IND		COM		COM		IND		COM		IND		COM		IND		IND		IND		IND		OTH		IND		IND		OTH		IND		IND		OTH		SCC		COM		IND		OTH		IND		IND		OTH		COM		COM		SCC		SCC		SCC		OTH		COM		IND		IND		IND		IND		COM		COM		IND		COM		IND		COM		IND		IND		IND		IND		OTH		IND		IND		OTH		IND		IND		OTH		SCC		COM		IND		OTH
ctrib_naml		Baba		Bacharach		Barona Band of Mission Indians		California Correctional Peace Officers Association PAC		California New Car Dealers Association PAC		California Professional Firefighters PAC Small Contributor Committee		California Real Estate PAC (CREPAC) Small Contributor Committee		California State Council of Service Employees (SEIU) Small Contributor Committee		California Water Service Company		Charter Public School PAC		Chaya		Endo		Fujimoto		Gallardo		GFC Courage Committee - Hollywood Chapter		GFC Courage Committee - Palo Alto Chapter		Higa		Honeywell International PAC (FED PAC ID #C00096156)		Iwashita		Kinecta Federal Credit Union State PAC		Kishimoto		Kitagaito		Komiyama		Kurnick		Lockheed Martin Employees' Federal Political Action Committee PAC		Ota		Otani		Pechanga Band of Luiseno Indians		Takahashi		Tome		Torrance Yamaha Music Center		United Domestic Workers of America Action Fund Small Contributor Committee		Wescom Credit Union State PAC		Yamazaki		First Foundation Bank		Baba		Bacharach		Barona Band of Mission Indians		California Correctional Peace Officers Association PAC		California New Car Dealers Association PAC		California Professional Firefighters PAC Small Contributor Committee		California Real Estate PAC (CREPAC) Small Contributor Committee		California State Council of Service Employees (SEIU) Small Contributor Committee		California Water Service Company		Charter Public School PAC		Chaya		Endo		Fujimoto		Gallardo		GFC Courage Committee - Hollywood Chapter		GFC Courage Committee - Palo Alto Chapter		Higa		Honeywell International PAC (FED PAC ID #C00096156)		Iwashita		Kinecta Federal Credit Union State PAC		Kishimoto		Kitagaito		Komiyama		Kurnick		Lockheed Martin Employees' Federal Political Action Committee PAC		Ota		Otani		Pechanga Band of Luiseno Indians		Takahashi		Tome		Torrance Yamaha Music Center		United Domestic Workers of America Action Fund Small Contributor Committee		Wescom Credit Union State PAC		Yamazaki		First Foundation Bank
ctrib_namf		Kazuho		Jacqueline		None		None		None		None		None		None		None		None		Takashi		Takako S.		Akira		Oscar		None		None		Chogi		None		Hisa		None		Masayuki		Kazue		Yoichi		Luann		None		Mitsuko		Kihei		None		Yusuke		Sadao		None		None		None		Ichiro		None		Kazuho		Jacqueline		None		None		None		None		None		None		None		None		Takashi		Takako S.		Akira		Oscar		None		None		Chogi		None		Hisa		None		Masayuki		Kazue		Yoichi		Luann		None		Mitsuko		Kihei		None		Yusuke		Sadao		None		None		None		Ichiro		None
ctrib_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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Anaheim		Rancho Palos Verdes		Lakeside		Sacramento		Sacramento		Sacramento		Los Angeles		Sacramento		San Jose		Sacramento		Torrance		Downey		Los Angeles		Hermosa Beach		San Rafael		San Rafael		Gardena		Washington		Los Angeles		Manhattan Beach		Palos Verdes Estates		Rancho Palos Verdes		Palos Verdes Estates		Palos Verdes		Arlington		Santa Ana		Santa Ana		Temecula		Palos Verdes Peninsula		Chino Hills		Torrance		Sacramento		Pasadena		Carson		Irvine		Anaheim		Rancho Palos Verdes		Lakeside		Sacramento		Sacramento		Sacramento		Los Angeles		Sacramento		San Jose		Sacramento		Torrance		Downey		Los Angeles		Hermosa Beach		San Rafael		San Rafael		Gardena		Washington		Los Angeles		Manhattan Beach		Palos Verdes Estates		Rancho Palos Verdes		Palos Verdes Estates		Palos Verdes		Arlington		Santa Ana		Santa Ana		Temecula		Palos Verdes Peninsula		Chino Hills		Torrance		Sacramento		Pasadena		Carson		Irvine
ctrib_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CA		CA		CA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CA		CA		CA		CA		VA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
ctrib_zip4		92808		90275		92040		95814		95814		95833		90071		95814		95112		95814		90501		90241		90012		90254		94901		94901		90247		20001		90066		90266		90274		90275		90274		90274		22202		92705		92705		92592		90274		91709		90505		95814		91101		90746		92612		92808		90275		92040		95814		95814		95833		90071		95814		95112		95814		90501		90241		90012		90254		94901		94901		90247		20001		90066		90266		90274		90275		90274		90274		22202		92705		92705		92592		90274		91709		90505		95814		91101		90746		92612
ctrib_emp		Isuzu		n/a		None		None		None		None		None		None		None		None		Person Realty, Inc.		Takako S. Endo		Sanwa Enterprise, Inc.		Los Angeles County		None		None		n/a		None		Hisa Iwashita		None		Kishimoto Family International, Inc.		Japanese Prefectural Association of Southern California		Takuyo Corporation Lighthouse Career Planning		n/a		None		Pi Water, Inc.		NYLA USA Corporation		None		Kardea Capital, LLC		Okinave		None		None		None		Parachute Graphics, Inc.		None		Isuzu		n/a		None		None		None		None		None		None		None		None		Person Realty, Inc.		Takako S. Endo		Sanwa Enterprise, Inc.		Los Angeles County		None		None		n/a		None		Hisa Iwashita		None		Kishimoto Family International, Inc.		Japanese Prefectural Association of Southern California		Takuyo Corporation Lighthouse Career Planning		n/a		None		Pi Water, Inc.		NYLA USA Corporation		None		Kardea Capital, LLC		Okinave		None		None		None		Parachute Graphics, Inc.		None
ctrib_occ		Sales		Not Employed		None		None		None		None		None		None		None		None		President		Kimono Professional		President		Physical Therapist		None		None		Not Employed		None		Gardener		None		Owner		Vice President		Owner		Retired		None		Vice President		Agent		None		Investor		Journalist		None		None		None		Manager		None		Sales		Not Employed		None		None		None		None		None		None		None		None		President		Kimono Professional		President		Physical Therapist		None		None		Not Employed		None		Gardener		None		Owner		Vice President		Owner		Retired		None		Vice President		Agent		None		Investor		Journalist		None		None		None		Manager		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		I		None		None		None		None		None		None		I		None		None		None		None		I		None		None		None		None		None		None		None		None		None		I		None		None		None		None		None		None		None		None		None		None		None		None		I		None		None		None		None		None		None		I		None		None		None		None		I		None		None		None		None		None		None		None		None		None		I		None		None		None		None		None		None		None		None		None		None		None
rcpt_date		2022-10-17 00:00:00		2022-10-09 00:00:00		2022-10-14 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-12 00:00:00		2022-09-30 00:00:00		2022-10-19 00:00:00		2022-10-21 00:00:00		2022-10-20 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-12 00:00:00		2022-10-10 00:00:00		2022-10-14 00:00:00		2022-10-12 00:00:00		2022-10-17 00:00:00		2022-10-12 00:00:00		2022-10-17 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-09 00:00:00		2022-10-18 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-07 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-13 00:00:00		2022-09-28 00:00:00		2022-10-17 00:00:00		2022-09-30 00:00:00		2022-10-17 00:00:00		2022-10-09 00:00:00		2022-10-14 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-12 00:00:00		2022-09-30 00:00:00		2022-10-19 00:00:00		2022-10-21 00:00:00		2022-10-20 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-12 00:00:00		2022-10-10 00:00:00		2022-10-14 00:00:00		2022-10-12 00:00:00		2022-10-17 00:00:00		2022-10-12 00:00:00		2022-10-17 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-09 00:00:00		2022-10-18 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-07 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-13 00:00:00		2022-09-28 00:00:00		2022-10-17 00:00:00		2022-09-30 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		500		90		1500		3900		1000		1000		1000		9700		2500		1500		200		100		1555		100		4900		4900		100		2000		200		1000		4900		300		500		200		1000		100		100		2400		500		100		200		2000		500		100		26		500		90		1500		3900		1000		1000		1000		9700		2500		1500		200		100		1555		100		4900		4900		100		2000		200		1000		4900		300		500		200		1000		100		100		2400		500		100		200		2000		500		100		26
cum_ytd		500		100		3000		4900		2000		4000		1000		19400		2500		1500		200		100		1555		100		4900		4900		100		2000		200		1000		4900		300		500		200		1000		100		100		4900		500		100		200		2000		500		100		0		500		100		3000		4900		2000		4000		1000		19400		2500		1500		200		100		1555		100		4900		4900		100		2000		200		1000		4900		300		500		200		1000		100		100		4900		500		100		200		2000		500		100		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Interest Earned		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Interest Earned
cmte_id		None		None		None		830349		741623		744058		890106		831628		None		1302433		None		None		None		None		1416424		1416422		None		1372848		None		1285775		None		None		None		None		None		None		None		None		None		None		None		1302384		1273830		None		None		None		None		None		830349		741623		744058		890106		831628		None		1302433		None		None		None		None		1416424		1416422		None		1372848		None		1285775		None		None		None		None		None		None		None		None		None		None		None		1302384		1273830		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
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
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
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
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
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
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
intr_naml		None		ActBlue		None		None		None		None		None		None		ActBlue		None		None		None		None		ActBlue		None		None		None		None		None		None		None		None		None		ActBlue		None		None		None		None		None		None		None		None		None		None		None		None		ActBlue		None		None		None		None		None		None		ActBlue		None		None		None		None		ActBlue		None		None		None		None		None		None		None		None		None		ActBlue		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Somerville		None		None		None		None		None		None		Somerville		None		None		None		None		Somerville		None		None		None		None		None		None		None		None		None		Somerville		None		None		None		None		None		None		None		None		None		None		None		None		Somerville		None		None		None		None		None		None		Somerville		None		None		None		None		Somerville		None		None		None		None		None		None		None		None		None		Somerville		None		None		None		None		None		None		None		None		None		None		None
intr_st		None		MA		None		None		None		None		None		None		MA		None		None		None		None		MA		None		None		None		None		None		None		None		None		None		MA		None		None		None		None		None		None		None		None		None		None		None		None		MA		None		None		None		None		None		None		MA		None		None		None		None		MA		None		None		None		None		None		None		None		None		None		MA		None		None		None		None		None		None		None		None		None		None		None
intr_zip4		None		02144		None		None		None		None		None		None		02144		None		None		None		None		02144		None		None		None		None		None		None		None		None		None		02144		None		None		None		None		None		None		None		None		None		None		None		None		02144		None		None		None		None		None		None		02144		None		None		None		None		02144		None		None		None		None		None		None		None		None		None		02144		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		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		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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208
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		50715		0		50715		0		50715		26574		0		26574		-2224		0		24350		246262		50715		26		26574		270430		0		0		156		50645		70		50715		0		0		0		0		0		0		1500		0		1500		26574		0		0		26574		156		2380		-2224		0		0		0		26		0		0		26		50715		0		50715		0		50715		26574		0		26574		-2224		0		24350		246262		50715		26		26574		270430		0		0		156		50645		70		50715		0		0		0		0		0		0		1500		0		1500		26574		0		0		26574		156		2380		-2224		0		0		0		26		0		0		26
amount_b		335611		0		335611		0		335611		293506		0		293506		156		0		293663		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		335611		0		335611		0		335611		293506		0		293506		156		0		293663		None		None		None		None		None		None		None		None		None		None		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

Table: splt

filing_id		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208		2744208
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		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		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		1		2		3		4		5		6		7		8		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
pform_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A
ptran_id		INC572		INC592		INC592		INC568		INC602		INC602		IDT113		INC603		INC610		INC611		INC591		IDT111		INC595		INC593		INC612		INC584		INC613		INC564		INC564		INC565		INC565		INC614		INC617		IDT110		INC600		INC615		INC618		INC577		INC577		INC619		INC619		INC620		INC621		INC594		INC570		INC622		INC616		IDT109		IDT109		INC597		INC597		INC573		INC573		INC572		INC616		IDT109		IDT109		INC597		INC597		INC573		INC573		INC572		INC572		INC592		INC592		INC568		INC602		INC602		IDT113		INC603		INC610		INC611		INC591		IDT111		INC595		INC593		INC612		INC584		INC613		INC564		INC564		INC565		INC565		INC614		INC617		IDT110		INC600		INC615		INC618		INC577		INC577		INC619		INC619		INC620		INC621		INC594		INC570		INC622
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		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		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		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		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		1000		6000		2000		1000		9700		9700		2500		1500		200		100		1555		100		4900		4900		100		2000		200		500		1000		4900		4900		300		500		200		1000		100		100		4900		4900		500		500		100		200		2000		500		100		500		100		100		3500		1500		4900		4900		1000		500		100		100		3500		1500		4900		4900		1000		1000		6000		2000		1000		9700		9700		2500		1500		200		100		1555		100		4900		4900		100		2000		200		500		1000		4900		4900		300		500		200		1000		100		100		4900		4900		500		500		100		200		2000		500		100
elec_code		G		P		G		G		P		G		G		G		G		G		G		G		G		G		G		G		G		P		G		P		G		G		G		G		G		G		G		P		G		P		G		G		G		G		G		G		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		G		P		G		G		G		G		G		G		G		G		G		G		G		G		P		G		P		G		G		G		G		G		G		G		P		G		P		G		G		G		G		G		G