Home

Filing ID: 2741075

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

Table: cvr2_campaign_disclosure

filing_id		2741075
amend_id		0
line_item		1
rec_type		CVR2
form_type		F460
tran_id		OFC1
entity_cd		ATR
title		None
mail_city		None
mail_st		None
mail_zip4		None
f460_part		3
cmte_id		None
enty_naml		Stephen
enty_namf		Danielle
enty_namt		None
enty_nams		None
enty_city		Encinitas
enty_st		CA
enty_zip4		92024
enty_phon		619-708-9744
enty_fax		None
enty_email		danielle@haleyandcompany.com
tres_naml		None
tres_namf		None
tres_namt		None
tres_nams		None
control_yn		None
office_cd		None
offic_dscr		None
juris_cd		None
juris_dscr		None
dist_no		None
off_s_h_cd		None
bal_name		None
bal_num		None
bal_juris		None
sup_opp_cd		None

Table: cvr3_verification_info

filing_id		2741075		2741075
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-24 00:00:00		2022-10-24 00:00:00
sig_loc		None		None
sig_naml		Nancy R Haley		Chris Ward
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2741075
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1434927
entity_cd		CTL
filer_naml		Chris Ward for Assembly 2022
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-24 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		San Diego
filer_st		CA
filer_zip4		92103
filer_phon		619-708-9744
filer_fax		None
file_email		nancy@haleyandcompany.com
mail_city		Encinitas
mail_st		CA
mail_zip4		92024
tres_naml		Haley
tres_namf		Nancy
tres_namt		None
tres_nams		None
tres_city		Encinitas
tres_st		CA
tres_zip4		92024
tres_phon		619-708-9744
tres_fax		None
tres_email		None
cmtte_type		C
control_yn		Y
sponsor_yn		N
primfrm_yn		N
brdbase_yn		N
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		Ward
cand_namf		Christopher M.
cand_namt		None
cand_nams		None
cand_city		San Diego
cand_st		CA
cand_zip4		92103
cand_phon		None
cand_fax		None
cand_email		None
bal_name		None
bal_num		None
bal_juris		None
office_cd		ASM
offic_dscr		None
juris_cd		ASM
juris_dscr		None
dist_no		78
off_s_h_cd		H
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: debt

filing_id		2741075		2741075		2741075		2741075
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		PAY754		PAY783		PAY846		PAY847
entity_cd		OTH		OTH		OTH		OTH
payee_naml		Haley & Company LLC		KM Strategies Inc.		Haley & Company LLC		KM Strategies Inc.
payee_namf		None		None		None		None
payee_namt		None		None		None		None
payee_nams		None		None		None		None
payee_city		Encinitas		San Diego		Encinitas		San Diego
payee_st		CA		CA		CA		CA
payee_zip4		92024		92167		92024		92167
beg_bal		1250		5000		0		0
amt_incur		0		0		1500		7500
amt_paid		1250		5000		0		0
end_bal		0		0		1500		7500
expn_code		PRO		CNS		PRO		CNS
expn_dscr		None		None		None		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		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075
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
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
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
form_type		D		D		D		D		D		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		G
tran_id		EXP784		EXP810		EXP809		EXP811		EXP819		EXP834		EXP784		EXP798		EXP788		EXP791		EXP799		EXP795		EXP808		EXP806		EXP824		EXP810		EXP809		EXP811		EXP814		EXP812		EXP826		EXP827		EXP819		EXP828		EXP835		EXP831		EXP834		EXP843		EXP836		EXP839		EXP840		EDT12
entity_cd		PTY		PTY		COM		PTY		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		OTH
payee_naml		California Democratic Party - State		California Democratic Party - State		Diedre Thu-Ha Nguyen for Assembly 2022		San Diego County Democratic Party		Shawn Kumagai for Assembly 2022		Gipson for Assembly 2022		California Democratic Party - State		Lyft Ride		eFundraising Connections		KM Strategies Inc.		Counterpoint		eFundraising Connections		KM Strategies Inc.		KM Strategies Inc.		NationBuilder		California Democratic Party - State		Diedre Thu-Ha Nguyen for Assembly 2022		San Diego County Democratic Party		Haley & Company LLC		Haley & Company LLC		Squarespace Inc.		Hertz Car Rental		Shawn Kumagai for Assembly 2022		Comcast CA / Xfinity		Chase Card Services		eFundraising Connections		Gipson for Assembly 2022		Squarespace Inc.		eFundraising Connections		eFundraising Connections		eFundraising Connections		Four Seasons Hotel - Mexico City
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
payee_city		Sacramento		Sacramento		Sacramento		San Diego		Sacramento		Norwalk		Sacramento		San Francisco		Sacramento		San Diego		San Diego		Sacramento		San Diego		San Diego		Los Angeles		Sacramento		Sacramento		San Diego		Encinitas		Encinitas		New York		Sacramento		Sacramento		Sandy		Carol Stream		Sacramento		Norwalk		New York		Sacramento		Sacramento		Sacramento		Ciudad De Mexico
payee_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NY		CA		CA		UT		IL		CA		CA		NY		CA		CA		CA		None
payee_zip4		95814		95814		95841		92123		95815		90650		95814		94104		95816		92167		92102		95816		92167		92167		90071		95814		95841		92123		92024		92024		10014		95837		95815		92103		60197		95816		90650		10014		95816		95816		95816		None
expn_date		2022-09-26 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-13 00:00:00		2022-10-17 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-09-29 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-06 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-11 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-20 00:00:00		2022-10-17 00:00:00
amount		50000		30000		2400		1000		2000		4900		50000		59		12		15		137		23		4695		5000		69		30000		2400		1000		284		1250		252		175		2000		20		1149		221		4900		12		12		5		113		1149
cum_ytd		171200		171200		4900		9500		3000		9800		171200		289		1935		76077		137		1935		76077		76077		630		171200		4900		9500		14275		14275		557		175		3000		176		12195		1935		9800		557		1935		1935		1935		1149
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
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
expn_code		MON		MON		MON		MON		MON		MON		CTB		TRC		OFC		OFC		MTG		OFC		CNS		CNS		WEB		CTB		CTB		CTB		PRO		PRO		WEB		TRC		CTB		OFC		TRC		OFC		CTB		WEB		OFC		OFC		OFC		TRC
expn_dscr		None		None		None		None		None		None		None		None		None		None		09/27/22: Leg Dinner w/Candidate +3 Guests		None		None		None		None		None		None		None		None		None		None		10/10-10/11/22: Sacramento-Napa-San Francisco for FND Events		None		None		Mexico City San Diego Delegation Leg Trip - See Sch. G		None		None		None		None		None		None		10/23-10/26/22: Lodging for San Diego Delegation Leg Trip
agent_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
cmte_id		741666		741666		1444098		741906		1443307		1434878		741666		None		None		None		None		None		None		None		None		741666		1444098		741906		None		None		None		None		1443307		None		None		None		1434878		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
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
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
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
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
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
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
cand_naml		None		None		Diedre Thu-Ha Nguyen		None		Shawn Kumagai		Mike Gipson		None		None		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
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
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
office_cd		None		None		ASM		None		ASM		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
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
juris_cd		None		None		ASM		None		ASM		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
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
dist_no		None		None		70		None		20		65		None		None		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
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
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
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
sup_opp_cd		S		S		S		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
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
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
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
g_from_e_f		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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

Table: filer_filings

filer_id		1434927
filing_id		2741075
period_id		251
form_id		F460
filing_sequence		0
filing_date		2022-10-25 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-24 00:00:00
filing_type		22001

Table: filings

filing_id		2741075
filing_type		22001

Table: hdr

filing_id		2741075
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		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075
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
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
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
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		C
tran_id		INC786		INC785		INC787		INC793		INC794		INC796		INC797		INC804		INC802		INC801		INC805		INC803		INC800		INC815		INC816		INC817		INC818		INC820		INC821		INC822		INC830		INC833		INC832		INC837		INC838		INC842		NON789
entity_cd		COM		SCC		COM		COM		COM		OTH		OTH		COM		COM		SCC		COM		SCC		OTH		OTH		SCC		OTH		IND		OTH		OTH		IND		OTH		IND		COM		COM		COM		OTH		COM
ctrib_naml		CA Statewide Law Enforcement Assoc PAC		CA Teachers Assn / Assn for Better Citizenship SCC		Pacific Assn of Domestic Insurance Companies PAC (PADIC-PAC)		CA Credit Union League PAC		CA Medical Association PAC (CALPAC)		Anheuser Busch Companies		AstraZeneca		314 Action Victory Fund (FEC C00689828)		CA Correctional Peace Officers Assn PAC		CA Federation of Teachers COPE -SCC		CA New Car Dealers Assn PAC		CA Pharmacists Association SCC		Meta Platforms Inc. (Formerly Facebook Inc.)		Deloitte Services LP		PACE of CA School Employees Assn PAC - SCC		Blood Hurst & O'Reardon LLP		Fox		Amazon.com Services LLC(Andrea Fava)		Universal Music Group Inc.		Brinner		CaseyGerry Law Firm		Iredale		NUHW Committee for Quality Patient Care & Union Democracy Candidate PAC		California Asian Chamber of Commerce Candidate PAC		UPSPAC		Gilead Sciences Inc.		San Diego Credit Unions' PAC
ctrib_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Joanna		None		None		Kristin		None		Eugene G.		None		None		None		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
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
ctrib_city		Sacramento		Burlingame		Sacramento		Ontario		Sacramento		Sacramento		Wilmington		Washington		Sacramento		Sacramento		Sacramento		Sacramento		Menlo Park		Hermitage		Sacramento		San Diego		Solana Beach		Seattle		Woodland Hills		Solana Beach		San Diego		San Diego		Sacramento		Encinitas		Atlanta		Foster City		Sacramento
ctrib_st		CA		CA		CA		CA		CA		CA		DE		DC		CA		CA		CA		CA		CA		TN		CA		CA		CA		WA		CA		CA		CA		CA		CA		CA		GA		CA		CA
ctrib_zip4		95814		94010		95814		91761		95814		95814		19850		20044		95814		95814		95814		95815		94025		37076		95814		92101		92075		98108		91367		92075		92101		92101		95815		92024		30328		94404		95814
ctrib_emp		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		Fox Law Firm APC		N/A		N/A		Achieve Internet		N/A		Iredale & Yoo, APC		N/A		N/A		N/A		N/A		N/A
ctrib_occ		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		Attorney		N/A		N/A		Software Developer		N/A		Attorney		N/A		N/A		N/A		N/A		N/A
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
tran_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpt_date		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-09-30 00:00:00		2022-10-01 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-16 00:00:00		2022-10-16 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-21 00:00:00		2022-09-26 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
amount		2000		9700		1000		1500		1000		4900		1500		2500		2000		2500		2000		2000		2000		1500		1500		4900		250		2500		1000		100		2500		500		4900		1000		2500		2000		137
cum_ytd		2000		19400		1000		1500		3500		4900		3500		2500		2000		2500		3500		2000		6900		1500		1500		4900		250		2500		1000		100		2500		500		4900		1000		4500		5500		137
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
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		MTG
cmte_id		970375		741941		1350983		760225		742617		None		None		1419563		830349		741857		741623		1291777		None		None		761128		None		None		None		None		None		None		None		1318200		1358788		C00064766		None		1239870
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
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
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
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
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
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
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
intr_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
intr_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Table: smry

filing_id		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22A		22B		1		2		3		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		C		C		C		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H
amount_a		59765		0		59765		137		59902		104052		0		104052		2735		137		106924		261475		59765		0		104052		217188		0		0		9000		212392		147858		80287		123198		59750		15		59765		137		0		137		90300		0		90300		103803		249		0		104052		9000		6265		2735		0		0		0		0		0		0
amount_b		422385		0		422385		8848		431233		408105		0		408105		9000		8848		425953		None		None		None		None		None		None		None		None		218841		285526		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		2022-11-08 00:00:00		2022-06-07 00:00:00		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		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075		2741075
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
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
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		C		D		D		D		D		D
ptran_id		INC786		INC785		INC785		INC787		INC787		INC793		INC793		INC794		INC794		INC796		INC796		INC797		INC797		INC804		INC802		INC802		INC801		INC801		INC805		INC805		INC803		INC800		INC800		INC815		INC815		INC816		INC816		INC817		INC818		INC820		INC820		INC821		INC822		INC830		INC833		INC832		INC832		INC837		INC838		INC838		INC842		INC842		NON789		EXP809		EXP819		EXP819		EXP834		EXP834
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
elec_amount		2000		9700		9700		1000		1000		1500		1500		4000		1000		4900		4900		2000		1500		2500		2500		2000		2500		2500		3500		2000		2000		4900		2000		2000		1500		2500		1500		4900		250		2500		2500		1000		100		2500		500		4900		4900		1000		2000		2500		4900		2600		137		4900		1000		2000		4900		4900
elec_code		G		P		G		P		G		P		G		P		G		P		G		P		G		G		P		G		P		G		P		G		G		P		G		P		G		P		G		G		G		P		G		G		G		G		G		P		G		G		P		G		P		G		G		G		P		G		P		G