Home

Filing ID: 2744612

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

Table: cvr3_verification_info

filing_id		2744612		2744612
amend_id		0		0
line_item		1		2
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		VER_1.1		VER_2.2
entity_cd		TRE		CAO
sig_date		2022-10-26 00:00:00		2022-10-26 00:00:00
sig_loc		None		None
sig_naml		Yolanda Miranda		Luz Rivas
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2744612
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1434959
entity_cd		CTL
filer_naml		Luz Rivas for Assembly 2022
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-26 00:00:00
stmt_type		PE
late_rptno		None
from_date		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00
elect_date		2022-11-08 00:00:00
filer_city		Covina
filer_st		CA
filer_zip4		91722
filer_phon		626-915-7635
filer_fax		626-915-6626
file_email		[email protected]
mail_city		Covina
mail_st		CA
mail_zip4		91722
tres_naml		Miranda
tres_namf		Yolanda
tres_namt		None
tres_nams		None
tres_city		Covina
tres_st		CA
tres_zip4		91722
tres_phon		626-915-7635
tres_fax		None
tres_email		None
cmtte_type		C
control_yn		Y
sponsor_yn		N
primfrm_yn		None
brdbase_yn		None
amendexp_1		None
amendexp_2		None
amendexp_3		None
rpt_att_cb		None
cmtte_id		None
reportname		None
rptfromdt		None
rptthrudt		None
emplbus_cb		None
bus_name		None
bus_city		None
bus_st		None
bus_zip4		None
bus_inter		None
busact_cb		None
busactvity		None
assoc_cb		None
assoc_int		None
other_cb		None
other_int		None
cand_naml		Rivas
cand_namf		Luz
cand_namt		None
cand_nams		None
cand_city		North Hollywood
cand_st		CA
cand_zip4		91605
cand_phon		818-806-8240
cand_fax		None
cand_email		[email protected]
bal_name		None
bal_num		None
bal_juris		None
office_cd		ASM
offic_dscr		None
juris_cd		ASM
juris_dscr		None
dist_no		43
off_s_h_cd		S
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: debt

filing_id		2744612		2744612		2744612		2744612
amend_id		0		0		0		0
line_item		1		2		3		4
rec_type		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F
tran_id		PAY712		PAY632		PAY673		PAY628
entity_cd		IND		OTH		OTH		OTH
payee_naml		Becerra		Chase Card Services		Chase Card Services		Yolanda Miranda & Assoc.
payee_namf		Maribel		None		None		None
payee_namt		None		None		None		None
payee_nams		None		None		None		None
payee_city		Van Nuys		Carol Stream		Carol Stream		Covina
payee_st		CA		IL		IL		CA
payee_zip4		91401		60197-6294		60197-6294		91722
beg_bal		0		7151		0		8
amt_incur		160		0		3656		0
amt_paid		0		7151		0		8
end_bal		160		0		3656		0
expn_code		OFC		None		None		POS
expn_dscr		Reimbursement for office supplies		Credit card payment		Credit card payment		None
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		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39
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
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		E		E		E		G		G		G		G		G		G		G		G		G		G		G		G		G
tran_id		EXP697		EXP716		EXP690		EXP665		PDT94		EXP706		EXP689		EXP666		EXP670		EXP684		EXP697		EXP716		EXP683		EXP677		EXP655		EXP667		EXP690		EXP675		EXP674		EXP665		EXP706		EXP689		EXP666		EXP698		EXP700		EXP702		PDT109		PDT95		PDT104		PDT113		PDT110		PDT98		PDT99		PDT111		PDT114		PDT94		PDT112		EDT130		PDT96
entity_cd		COM		COM		COM		COM		None		COM		COM		COM		OTH		OTH		COM		COM		IND		OTH		OTH		OTH		COM		OTH		OTH		COM		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Action Democrats of the San Fernando Valley		Ballin for City Council 2022		Fajardo for City Council 2022		Josh Lowenthall for Assembly 2022		L.A. County Democratic Party		Leticia Garcia for Sacramento City School Board 2022		Mendoza for City Council 2022		Tina McKinnor for Assembly 2022		ActBlue of California		ActBlue of California		Action Democrats of the San Fernando Valley		Ballin for City Council 2022		Becerra		Bertolina & Barnato, Inc.		Chase Card Services		Corazon Media & Print, Inc.		Fajardo for City Council 2022		Firefighters Print & Design		Image Cube, Inc.		Josh Lowenthall for Assembly 2022		Leticia Garcia for Sacramento City School Board 2022		Mendoza for City Council 2022		Tina McKinnor for Assembly 2022		Yolanda Miranda & Assoc.		Yolanda Miranda & Assoc.		Yolanda Miranda & Assoc.		Amazon Marketplace		Asn Flowers		Costco Wholesale		Dialpad Meeting		DTLA Proper Hotel		FedEx Office		FedEx Office		Google, LLC		Google, LLC		L.A. County Democratic Party		Mailchimp		Target Store		U.S. Postal Services
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		Maribel		None		None		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
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
payee_city		Sherman Oaks		San Fernando		San Fernando		Sacramento		Los Angeles		Sacramento		San Fernando		Los Angeles		Somerville		Somerville		Sherman Oaks		San Fernando		Van Nuys		Sacramento		Carol Stream		Sacramento		San Fernando		Sacramento		Sylmar		Sacramento		Sacramento		San Fernando		Los Angeles		Covina		Covina		Covina		Seattle		San Bernardino		Van Nuys		San Ramon		Los Angeles		Van Nuys		Van Nuys		Mountain View		Mountain View		Los Angeles		Atlanta		North Hollywood		Burbank
payee_st		CA		CA		CA		CA		CA		CA		CA		CA		MA		MA		CA		CA		CA		CA		IL		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		WA		CA		CA		CA		CA		CA		CA		CA		CA		CA		GA		CA		CA
payee_zip4		91403		91340		91340		95814		90017		95841		91340		90071		02144-3132		02144-3132		91403		91340		91401		95814		60197-6294		95864		91340		95833		91342		95814		95841		91340		90071		91722		91722		91722		98144		92405		91411		94583		90015		91411		91411		94043		94043		90017		30308		91606		91505
expn_date		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-09-30 00:00:00		2022-10-04 00:00:00		2022-10-19 00:00:00		2022-10-13 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-09 00:00:00		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-10-10 00:00:00		2022-10-05 00:00:00		2022-09-26 00:00:00		2022-09-30 00:00:00		2022-10-13 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-09-30 00:00:00		2022-10-19 00:00:00		2022-10-13 00:00:00		2022-09-30 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-09-27 00:00:00		2022-10-03 00:00:00		2022-09-26 00:00:00		2022-10-10 00:00:00		2022-09-30 00:00:00		2022-09-25 00:00:00		2022-09-26 00:00:00		2022-10-04 00:00:00		2022-10-12 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-13 00:00:00		2022-10-06 00:00:00
amount		250		500		500		4900		1500		1000		500		4900		4		40		250		500		156		2500		7151		8000		500		460		1076		4900		1000		500		4900		1750		8		31		35		167		178		22		54		66		66		36		13		1500		70		27		182
cum_ytd		250		500		500		9800		3578		1000		500		4900		855		855		250		500		8547		26142		34200		20000		500		460		1076		9800		1000		500		4900		15952		15952		15952		1626		167		1444		196		54		476		476		439		439		3578		693		76		253
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
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
expn_code		MON		MON		MON		MON		MON		MON		MON		MON		OFC		OFC		CTB		CTB		None		CNS		None		CNS		CTB		None		None		CTB		CTB		CTB		CTB		PRO		POS		POS		OFC		OFC		OFC		WEB		OFC		POS		POS		OFC		OFC		CTB		WEB		OFC		OFC
expn_dscr		None		None		None		None		None		None		None		None		Processing Fees		Processing Fees		None		None		Reimbursement for campaign expenses		None		Credit card payment		None		None		T-Shirts		Halloween Bags for District Trunk or Treat Event		None		None		None		None		None		None		None		None		10/03/22 Flowers for Assemblyman James Ramos Family		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		None		None		None		None		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services		Chase Card Services
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
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
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
cmte_id		None		None		None		None		None		None		None		None		None		None		922441		1442612		None		None		None		None		1442526		None		None		1443482		1445674		1443082		1444546		None		None		None		None		None		None		None		None		None		None		None		None		744554		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
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
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
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
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
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
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
cand_naml		Action Democrats of the San Fernando Valley		Sylvia Ballin		Joel Fajardo		Josh Lowenthal		L.A. County Democratic Party		Leticia Garcia		Mary Mendoza		Tina McKinnor		None		None		None		None		None		None		None		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
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
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
office_cd		None		CCM		CCM		ASM		None		BED		CCM		ASM		None		None		None		None		None		None		None		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
juris_cd		None		OTH		OTH		ASM		None		OTH		OTH		ASM		None		None		None		None		None		None		None		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		San Fernando		City of San Fernando		None		None		Sacramento School Board		City of San Fernando		None		None		None		None		None		None		None		None		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		69		None		None		None		61		None		None		None		None		None		None		None		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
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
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
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
sup_opp_cd		S		S		S		S		None		S		S		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		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
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
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
g_from_e_f		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		E		E		E		E		E		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
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

Table: filer_filings

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

Table: filings

filing_id		2744612
filing_type		22001

Table: hdr

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

Table: rcpt

filing_id		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612
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
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
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
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
tran_id		INC707		INC664		INC681		INC705		INC659		INC661		INC658		INC691		INC680		INC672		INC686		INC687		INC694		INC662		INC668		INC660		INC695		INC685		INC708		INC663		INC704		IDT108		IDT107		INC682		INC692		IDT106		INC671		INC693
entity_cd		OTH		OTH		OTH		OTH		OTH		SCC		COM		COM		COM		COM		COM		COM		SCC		SCC		SCC		COM		COM		COM		OTH		OTH		COM		COM		OTH		OTH		OTH		IND		COM		COM
ctrib_naml		Amazon.com Services LLC(Robert Saltaformaggio)		AstraZeneca Pharmaceuticals, LP		Aya Healthcare, Inc.		Barona Band of Mission Indians		Blue Shield of California		Building A Stronger CA Sponsored by Southwest Regional Council of Carpenters		CA Cable & Telecommunications Ass. PAC		CA Dental Association PAC (CDA PAC)		CA Hospital Assoc. PAC		CA New Car Dealers Association PAC (CNCDA-PAC)		CA Optometric PAC		CA Sierra Club P.A.C.		CA State Assn. of Electrical Workers		CA State Council of Service Employees		California Federation of Teachers COPE		CALPAC-CA Medical Association PAC		General Motors Company(GM PAC)		Honeywell International PAC		Intersect Power, LLC(Michael Wheeler)		Molson Coors Beverage Company		National Union of Healthcare Workers Candidate Comm. for Quality Patient Care & Union Democracy		NWPC California		Paramount Pictures		Pechanga Band of Luiseno Indians		PG&E Corporation		Pulkka		UAW Region 8 Western States PAC		United Domestic Workers of America Action Fund Expenditure PAC
ctrib_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		Aaron		None		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
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
ctrib_city		Seattle		Wilmington		San Diego		Lakeside		Oakland		Los Angeles		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Los Angeles		Pasadena		Sacramento		Sacramento		Sacramento		Washington		Washington		Oakland		Milwaukee		Sacramento		Washington		Los Angeles		Temecula		San Francisco		Newhall		Pico Rivera		Sacramento
ctrib_st		WA		DE		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		DC		CA		WI		CA		DC		CA		CA		CA		CA		CA		CA
ctrib_zip4		98109		19850		92121		92040		94607		90071		95814		95814		95814		95814		95816		90010		91101		95814		95814		95814		20001		20001		94612		53208		95814		20006		90038		92592		94105		91321		90660		95814
ctrib_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		Amber Labs		None		None
ctrib_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		Program Director		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		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		I		I		None		None		I		None		None
rcpt_date		2022-10-20 00:00:00		2022-09-30 00:00:00		2022-10-07 00:00:00		2022-10-19 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-26 00:00:00		2022-10-13 00:00:00		2022-10-05 00:00:00		2022-10-03 00:00:00		2022-10-11 00:00:00		2022-10-12 00:00:00		2022-10-14 00:00:00		2022-09-28 00:00:00		2022-09-30 00:00:00		2022-09-28 00:00:00		2022-10-17 00:00:00		2022-10-11 00:00:00		2022-10-20 00:00:00		2022-09-29 00:00:00		2022-10-19 00:00:00		2022-10-17 00:00:00		2022-10-04 00:00:00		2022-10-07 00:00:00		2022-10-13 00:00:00		2022-09-27 00:00:00		2022-10-03 00:00:00		2022-10-14 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
amount		2500		1500		1000		2000		3000		3000		2000		4900		2000		2000		3900		250		100		9700		1500		2000		1500		2500		2000		1500		1000		250		1000		2400		3300		100		1000		2000
cum_ytd		2500		1500		1000		2000		3000		3000		2000		7800		2000		5400		3900		250		9700		9700		1500		2000		1500		2500		2000		1500		3500		250		1000		4900		5800		100		1000		2000
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
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
cmte_id		None		None		None		None		None		870169		745932		742885		790773		741623		745825		1399719		743107		831628		741857		742617		C00076810		C00096156		None		None		1318200		746373		None		None		None		None		743787		1367550
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
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
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
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
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
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
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
intr_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		ActBlue of California		ActBlue of California		None		None		ActBlue of California		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
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
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
intr_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Somerville		Somerville		None		None		Somerville		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		MA		MA		None		None		MA		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		02144-3132		02144-3132		None		None		02144-3132		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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Table: smry

filing_id		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		1		2		3		1		2		3		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		4
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		B1		B1		B1		C		C		C		D		D		D		E		E		E		E		F		F		F		H		H		H		I		I		I		I
amount_a		59650		0		59650		0		59650		33769		0		33769		-3343		0		30426		462708		59650		0		33769		488590		0		0		3816		59900		-250		59650		0		0		0		0		0		0		14050		0		14050		33724		45		0		33769		3816		7159		-3343		0		0		0		0		0		0		0
amount_b		409590		0		409590		4000		413590		481415		0		481415		3816		4000		489231		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount_c		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: splt

filing_id		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612		2744612
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53
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		D		D		D		D		D		D		D		D
ptran_id		INC707		INC707		INC664		INC664		INC681		INC705		INC705		INC659		INC659		INC661		INC658		INC691		INC691		INC680		INC680		INC672		INC672		INC686		INC687		INC694		INC694		INC662		INC662		INC668		INC668		INC660		INC660		INC695		INC695		INC685		INC708		INC663		INC663		INC704		INC704		IDT108		IDT107		IDT107		INC682		INC682		INC692		INC692		IDT106		INC671		INC693		EXP716		EXP690		EXP665		EXP665		PDT94		EXP706		EXP689		EXP666
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
elec_amount		2500		2500		2000		1500		1000		2000		2000		3000		3000		3000		2000		4900		4900		1500		2000		4900		2000		3900		250		9700		9700		9700		9700		3000		1500		4900		2000		1500		1500		2500		2000		1500		1500		2500		1000		250		1000		1000		4900		4900		4900		3400		100		1000		2000		500		500		4900		4900		128		1000		500		4900
elec_code		P		G		P		G		G		P		G		P		G		G		G		P		G		P		G		P		G		G		G		P		G		P		G		P		G		P		G		P		G		G		G		P		G		P		G		G		P		G		P		G		P		G		G		G		G		G		G		P		G		G		G		G		G