Home

Filing ID: 2742673

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

Table: cvr2_campaign_disclosure

filing_id		2742673
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		Encintias
enty_st		CA
enty_zip4		92024
enty_phon		619-708-9744
enty_fax		None
enty_email		[email protected]
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		2742673		2742673
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		Nancy R Haley		Juan Carrillo
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2742673
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1443329
entity_cd		CTL
filer_naml		Juan Carrillo 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		Encinitas
filer_st		CA
filer_zip4		92024
filer_phon		619-708-9744
filer_fax		None
file_email		[email protected] / [email protected]
mail_city		None
mail_st		None
mail_zip4		None
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		Carrillo
cand_namf		Juan
cand_namt		None
cand_nams		None
cand_city		Palmdale
cand_st		CA
cand_zip4		93551
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		39
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		2742673		2742673		2742673		2742673		2742673		2742673
amend_id		0		0		0		0		0		0
line_item		1		2		3		4		5		6
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F		F		F
tran_id		PAY306		PAY445		PAY446		PAY459		PAY578		PAY580
entity_cd		OTH		OTH		OTH		IND		OTH		OTH
payee_naml		Left Hook Strategy		Method Campaign Services LLC		Haley & Co., LLC		Godina		Haley & Co., LLC		MCSA LLC
payee_namf		None		None		None		Valentin		None		None
payee_namt		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None
payee_city		Santa Monica		Burbank		Encinitas		Victorville		Encinitas		Sacramento
payee_st		CA		CA		CA		CA		CA		CA
payee_zip4		90405		91505		92024		92395		92024		95819
beg_bal		20000		5000		2000		500		0		0
amt_incur		0		0		0		0		2000		22073
amt_paid		20000		5000		2000		500		0		0
end_bal		0		0		0		0		2000		22073
expn_code		None		CNS		PRO		CNS		PRO		LIT
expn_dscr		Digital Advertising		None		None		None		None		See Sch. G
cmte_id		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None
tres_city		None		None		None		None		None		None
tres_st		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None
memo_code		None		None		None		None		None		None
memo_refno		PAY306		None		None		None		None		None
bakref_tid		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None
xref_match		None		None		None		None		None		None

Table: expn

filing_id		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673
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		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		54		55		56		57		58		59		60		61		62		63		64		65		66		67		68		69		70
rec_type		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN
form_type		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		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		E		E		E		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G
tran_id		EXP482		EXP529		EXP453		EXP479		EXP452		EXP482		EXP475		EXP489		EXP484		EXP486		EXP461		EXP487		EXP469		EXP463		EXP488		EXP468		EXP467		EXP470		EXP525		EXP521		EXP527		EXP522		EXP526		EXP517		EXP490		EXP491		EXP474		EXP515		EXP492		EXP512		EXP499		EXP502		EXP505		EXP503		EXP542		EXP543		EXP541		EXP540		EXP529		EXP538		EXP508		EXP507		EXP506		EXP553		EXP560		EXP549		EXP563		EXP564		EXP557		EXP558		EXP559		EXP568		EXP567		EXP576		EXP575		EDT106		EDT108		EDT107		NON552		NON581		EDT102		EDT99		EDT100		EDT103		EDT101		PDT3		PDT4		PDT2		EDT104		EDT105
entity_cd		COM		COM		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		IND		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Los Angeles County Democratic Party		Ohlsen for Council 2022		Bankcard Center		FedEx Office		Left Hook Strategy		Los Angeles County Democratic Party		Shell Oil		Hyatt Regency		Chevron		Southwest Airlines		Godina		Hyatt Regency		Internal Revenue Service		Method Campaign Services LLC		Pier Market		RCBS Payroll Services		Wade		Goodwin		Arco Gasoline		Conserv Fuel		Hampton Inn & Suites		Hyatt Centric Fisherman's Wharf		The Ritz Carlton Hotel		Chevron		ActBlue		ActBlue		LAC Inc.		The Home Depot		Kaufman Legal Group		Exxon Mobil		Left Hook Strategy		Wade		Haley & Co., LLC		Haley & Co., LLC		Chevron		Circle K		Molly Brown's Country Cafe		International Event Pro		Ohlsen for Council 2022		Chevron		Internal Revenue Service		RCBS Payroll Services		Wade		ActBlue		La Palma Mexican Grill		MCSA LLC		Bankcard Center		Bankcard Center		Left Hook Strategy		Method Campaign Services LLC		Uribe Printing Inc. 2020		Ventura Graphix Inc.		Mojave Gas Mart		Shell Oil		Wade		United Pacific		Meta Inc.		Landslide Digital LLC		USPS		USPS		Dependable Highway Express		Hareline Graphics		Mailing Services Inc.		Political Data Intelligence		River City Printing		Incitement LLC		Mailing Services Inc.		River City Printing		COGS South Signs		USPS
payee_namf		None		None		None		None		None		None		None		None		None		None		Valentin		None		None		None		None		None		Alexander		Kimble Deleon		None		None		None		None		None		None		None		None		None		None		None		None		None		Alexander		None		None		None		None		None		None		None		None		None		None		Alexander		None		None		None		None		None		None		None		None		None		None		None		Alexander		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		Los Angeles		Palmdale		Salt Lake City		Palmdale		Santa Monica		Los Angeles		Palmdale		Santa Clara		Los Angeles		Dallas		Victorville		Santa Clara		Los Angeles		Burbank		San Francisco		Sacramento		Palmdale		Lancaster		Lancaster		Lancaster		Merced		San Francisco		Half Moon Bay		Los Angeles		Somerville		Somerville		Sacramento		Palmdale		Los Angeles		Palmdale		Santa Monica		Palmdale		Encinitas		Encinitas		Los Angeles		Palmdale		Victorville		Lancaster		Palmdale		Los Angeles		Los Angeles		Sacramento		Palmdale		Somerville		Palmdale		Sacramento		Salt Lake City		Salt Lake City		Santa Monica		Burbank		Riverside		Palmdale		Victorville		Palmdale		Palmdale		Palm Springs		Menlo Park		Leesburg		Los Angeles		Los Angeles		West Sacramento		West Sacramento		West Sacramento		Norwalk		Sacramento		Brooklyn		West Sacramento		Sacramento		Santa Ana		Los Angeles
payee_st		CA		CA		UT		CA		CA		CA		CA		CA		CA		TX		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		MA		MA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		MA		CA		CA		UT		UT		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		CA		CA		CA		CA		CA		CA		CA		NY		CA		CA		CA		CA
payee_zip4		90010		93552		84130		93551		90405		90010		93551		95054		90026		75235		92395		95054		90012		91505		94133		95841		93551		93535		93534		93535		95340		94133		94019		90026		2144		2144		95814		93551		90017		93551		90405		93551		92024		92024		90026		93551		92392		93534		93552		90026		90012		95841		93551		2144		93550		95819		84130		84130		90405		91505		92504		93550		92394		93551		93551		92264		94025		20175		90017		90017		95605		95691		95691		90652		95834		11201		95691		95834		92707		90017
expn_date		2022-09-26 00:00:00		2022-10-12 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-02 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-04 00:00:00		2022-10-05 00:00:00		2022-10-05 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-09 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-11 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-13 00:00:00		2022-10-14 00:00:00		2022-10-14 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-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-21 00:00:00		2022-10-22 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-10-18 00:00:00		2022-10-17 00:00:00		2022-10-22 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-17 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00
amount		100		4900		2514		106		25000		100		45		448		58		228		500		109		779		5000		139		76		2020		450		52		150		176		488		250		56		101		43		13988		11		360		51		20000		59		70		2000		139		100		159		75		4900		147		779		76		2020		5		97		33043		-2514		2524		2500		8686		3279		330		100		52		46		123		13944		2500		10709		7670		600		1500		15473		924		7329		1500		10159		4820		2728		1249
cum_ytd		100		4900		16534		106		184809		100		783		557		1144		1305		500		557		8264		42212		139		1381		15327		1350		121		150		176		488		250		1144		2538		2538		48328		605		26143		328		184809		15327		8529		8529		1144		554		214		149		4900		1144		8264		1381		15327		2538		2079		71664		16534		16534		184809		42212		3279		330		100		783		15327		164		21132		6500		29737		29737		600		2600		25633		10924		12149		1500		25633		12149		12987		29737
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
expn_chkno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_code		MON		MON		OFC		OFC		None		CTB		TRC		TRC		TRC		TRC		CNS		TRC		SAL		CNS		MTG		PRO		SAL		CNS		TRC		TRC		TRC		TRC		TRC		TRC		OFC		OFC		CNS		OFC		PRO		TRC		None		MTG		PRO		PRO		TRC		TRC		MTG		MTG		CTB		TRC		SAL		PRO		SAL		OFC		MTG		LIT		OFC		OFC		WEB		CNS		LIT		LIT		TRC		TRC		MTG		TRC		None		WEB		POS		POS		POS		LIT		LIT		LIT		LIT		LIT		LIT		LIT		CMP		POS
expn_dscr		None		None		See Sch. G for Expenditures Over $100		None		Digital Advertising - See Sch. G		None		None		9/27/22: Lodging for FND		None		9/30-10/01/22: SJC-SAN-SJC for FND		None		9/27/22: Additional Lodging Charges		None		None		9/28/22: Dinner w/Candidate +3		None		None		None		None		None		10/1/22: Lodging for Candidate Canvassing		9/28/22: Lodging for FND		9/28-9/29/22: Lodging @ Californians for a Strong Economy FND		None		None		None		None		None		None		None		Digital Advertising		None		None		None		None		None		10/8/22: Lunch for Canvassers (Candidate + 4)		None		None		None		None		None		None		None		None		See Sch. G		VOID - Check Lost		Re-Issued Check		See Sch. G		See Sch. G		See Sch. G		None		None		None		None		None		Digital Advertising		None		None		None		None		Graphic Design		None		None		None		Graph Design		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Bankcard Center		Left Hook Strategy		Left Hook Strategy		Mailing Services Inc.		Mailing Services Inc.		MCSA LLC		MCSA LLC		MCSA LLC		MCSA LLC		MCSA LLC		MCSA LLC		MCSA LLC		MCSA LLC		Method Campaign Services LLC		Uribe Printing Inc. 2020
agent_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmte_id		744554		1450839		None		None		None		744554		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1450839		None		None		None		None		None		None		None		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_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
cand_naml		None		Eric Ohlsen		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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
juris_dscr		None		City of Palmdale		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		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
g_from_e_f		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		E		E		E		None		None		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		None		None		None		None		None		None		None		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

Table: filer_filings

filer_id		1443329
filing_id		2742673
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		2742673
filing_type		22001

Table: hdr

filing_id		2742673
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		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673
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
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
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
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
tran_id		INC454		INC455		INC458		INC457		INC456		INC460		INC466		INC465		INC472		INC471		INC473		INC494		INC498		INC496		INC497		INC495		INC509		INC530		INC532		INC531		INC533		INC536		INC537		INC535		INC534		INC556		INC555		INC554		INC566		INC572		INC573		INC571		INC579		INC574
entity_cd		COM		SCC		OTH		COM		SCC		SCC		SCC		OTH		OTH		COM		COM		IND		IND		COM		COM		OTH		SCC		OTH		OTH		OTH		SCC		COM		COM		COM		SCC		SCC		OTH		COM		OTH		SCC		COM		OTH		OTH		IND
ctrib_naml		American Beverage Assoc. California PAC		CA Teachers Assn / Assn for Better Citizenship		Anheuser-Busch Companies		Apartment Assn of Greater Los Angeles PAC		State Building & Construction Trades Council of CA PAC		Building A Stronger California sponsored by Southwest Regional Council of Carpenters		UFCW Western States Council Candidate PAC-SCC		Viejas Band of Kumeyaay Indians		Agua Caliente Band of Cahuilla Indians		California New Car Dealers Assoc. PAC		Western United Dairies PAC		Forrest		McHugh		NAIOP SoCal Candidate PAC		NAIOP SoCal Candidate PAC		Pechanga Band of Indians		Southern CA Pipe Trades Dist. Council #16 PAC		Morongo Band of Mission Indians		PG&E Corporation		Yocha Dehe Wintun Nation		CA State Council of Laborers SCC		CA Cable & Telecommunications Assn. PAC		CA Cattlemen's Association PAC (Cattle-Pac)		CA Grain & Feed Association PAC		United Domestic Workers of America Action Fund - SCC		CA Applicants Attorneys Assn. - SCC		KPMG LLP		State Coalition of Probation Organizations PAC		Kindred Healthcare Operating LLC / ScionHealth(Raymond Sierpina)		CA Association of Highway Patrolmen - SCC		The Hartford Financial Svcs Grp Inc. PAC		Zenith Insurance Company		Dentsply Sirona Inc.		Carrillo
ctrib_namf		None		None		None		None		None		None		None		None		None		None		None		Brady		John		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Filemon
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
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
ctrib_city		San Rafael		Burlingame		St. Louis		Los Angeles		Sacramento		Los Angeles		Buena Park		Alpine		Palm Springs		Sacramento		Turlock		San Francisco		Corona Del Mar		Irvine		Irvine		Temecula		Los Angeles		Banning		San Francisco		Brooks		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Dallas		Sacramento		Louisville		Sacramento		Hartford		Woodland Hills		Charlotte		Anaheim
ctrib_st		CA		CA		MO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		TX		CA		KY		CA		CT		CA		NC		CA
ctrib_zip4		94901		94010		63118		90071		95814		90071		90620		91901		92264		95814		95380		94114		92625		92618		92618		92593		90020		92220		94105		95606		95814		95814		95814		95814		95814		95815		75201		95826		40202		95818		06115		91367		28277		92806
ctrib_emp		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		Mobile Coin		OB Hospitalist Group		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		N/A		N/A		N/A		N/A		Mulcahy LLP
ctrib_occ		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		N/A		Technician		Physician		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		N/A		N/A		N/A		N/A		Attorney
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
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		None		None		None		None		None		None		None
rcpt_date		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-27 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-05 00:00:00		2022-10-07 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-12 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-13 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 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-19 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-21 00:00:00		2022-10-22 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
amount		2500		9700		1000		4900		9700		4700		1500		4900		1500		1000		4900		-2500		100		839		161		4900		5000		4900		1000		4900		4900		2500		2500		1500		4000		2500		2000		1000		1000		4900		1000		2000		1000		100
cum_ytd		2500		19400		1000		4900		9700		19400		1500		4900		1500		2000		4900		0		100		1000		1000		4900		5000		4900		1000		4900		4900		2500		2500		1500		4000		2500		2000		1000		1000		4900		1000		2000		1000		1000
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
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
cmte_id		1344506		741941		None		811735		743501		870169		910874		None		None		741623		771500		None		None		950520		950520		None		760715		None		None		None		902770		745932		760980		810430		1302384		1233793		None		911856		None		802001		C00511444		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
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
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
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
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
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
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
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		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
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
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
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		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		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		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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
memo_refno		None		None		None		None		None		None		None		None		None		None		None		None		INC498		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		INC574
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
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
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
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
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

Table: smry

filing_id		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673
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		96545		0		96545		15		96560		133010		0		133010		-3427		15		129597		148070		96545		0		133010		111605		0		0		24073		268419		265672		222525		252998		96500		45		96545		0		15		15		5000		0		5000		131967		1043		0		133010		24073		27500		-3427		0		0		0		0		0		0
amount_b		588586		0		588586		5139		593726		478710		0		478710		24073		5139		507922		None		None		None		None		None		None		None		None		325307		295684		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		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673		2742673
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
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
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		D		D
ptran_id		INC454		INC455		INC455		INC458		INC457		INC456		INC460		INC460		INC466		INC465		INC472		INC471		INC473		INC494		INC498		INC496		INC496		INC497		INC497		INC495		INC509		INC530		INC532		INC531		INC533		INC536		INC537		INC535		INC534		INC556		INC555		INC554		INC566		INC572		INC573		INC571		INC579		INC574		INC574		EXP482		EXP529
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
elec_amount		2500		9700		9700		1000		4900		9700		9700		9700		1500		4900		1500		2000		4900		0		100		839		161		839		161		4900		5000		4900		1000		4900		4900		2500		2500		1500		4000		2500		2000		1000		1000		4900		1000		2000		1000		500		500		100		4900
elec_code		G		P		G		G		G		G		P		G		P		G		G		G		G		P		G		P		G		P		G		P		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		P		G		G		G