Home

Filing ID: 2742891

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

Table: cvr2_campaign_disclosure

filing_id		2742891		2742891		2742891
amend_id		0		0		0
line_item		1		2		3
rec_type		CVR2		CVR2		CVR2
form_type		F460		F460		F460
tran_id		NIC1		NIC2		OFC1
entity_cd		COM		COM		ATR
title		None		None		None
mail_city		None		None		None
mail_st		None		None		None
mail_zip4		None		None		None
f460_part		5b		5b		3
cmte_id		1414387		1437334		None
enty_naml		Gipson for Assembly 2020		California First a Controlled Committee by Assembly member Mike Gipson ( A Ballot Measure Committee)		Orellana
enty_namf		None		None		Ingrid
enty_namt		None		None		None
enty_nams		None		None		None
enty_city		Norwalk		Norwalk		Norwalk
enty_st		CA		CA		CA
enty_zip4		90650		90650		90650
enty_phon		213 489-4792		213 489-4792		213 489-4792
enty_fax		None		None		213 489-4818
enty_email		None		None		[email protected]
tres_naml		Gould		Gould		None
tres_namf		David		David		None
tres_namt		None		None		None
tres_nams		None		None		None
control_yn		Y		Y		None
office_cd		None		None		None
offic_dscr		None		None		None
juris_cd		None		None		None
juris_dscr		None		None		None
dist_no		None		None		None
off_s_h_cd		None		None		None
bal_name		None		None		None
bal_num		None		None		None
bal_juris		None		None		None
sup_opp_cd		None		None		None

Table: cvr3_verification_info

filing_id		2742891		2742891
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-27 00:00:00		2022-10-27 00:00:00
sig_loc		None		None
sig_naml		David Gould		Mike Gipson
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2742891
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1434878
entity_cd		CTL
filer_naml		Gipson for Assembly 2022
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-27 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		Norwalk
filer_st		CA
filer_zip4		90650
filer_phon		213 489-4792
filer_fax		213 489-4818
file_email		[email protected]
mail_city		None
mail_st		None
mail_zip4		None
tres_naml		Gould
tres_namf		David
tres_namt		None
tres_nams		None
tres_city		Norwalk
tres_st		CA
tres_zip4		90650
tres_phon		213 489-4792
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		Gipson
cand_namf		Mike
cand_namt		None
cand_nams		None
cand_city		Norwalk
cand_st		CA
cand_zip4		90650
cand_phon		213 489-4792
cand_fax		213 489-4818
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		65
off_s_h_cd		None
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: debt

filing_id		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891
amend_id		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
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F		F		F		F		F		F		F		F		F		F		F
tran_id		PAY440		PAY441		PAY999		PAY1178		PAY998		PAY1087		PAY1088		PAY1086		PAY1112		PAY1113		PAY1180		PAY1150		PAY1151		PAY1153
entity_cd		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Nossaman LLP		Nossaman LLP		Fairbank, Maslin, Maullin, Metz, & Associates		Nossaman LLP		Jacobson & Zilber Strategies LLC		McKinley Pillows & Associates, LLC		McKinley Pillows & Associates, LLC		Kegeyan-Pappas Consulting		Gould & Orellana, LLC		Gould & Orellana, LLC		McKinley Pillows & Associates, LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC
payee_namf		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
payee_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		Los Angeles		Los Angeles		Oakland		Los Angeles		Los Angeles		Sacramento		Sacramento		Sherman Oaks		Norwalk		Norwalk		Sacramento		Los Angeles		Los Angeles		Los Angeles
payee_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		90017		90017		94612		90017		90027		95881		95881		91423		90650		90650		95881		90027		90027		90027
beg_bal		1188		438		35750		2405		10000		0		0		0		0		0		0		0		0		0
amt_incur		0		0		0		0		0		5153		7985		13419		5941		222		6015		20006		10837		10244
amt_paid		0		0		35750		0		10000		0		0		0		0		0		0		0		0		0
end_bal		1188		438		0		2405		0		5153		7985		13419		5941		222		6015		20006		10837		10244
expn_code		PRO		PRO		POL		PRO		CNS		CNS		CNS		CNS		PRO		OFC		CNS		LIT		LIT		LIT
expn_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		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
tres_namt		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
tres_city		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
tres_zip4		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
memo_refno		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
xref_schnm		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

Table: expn

filing_id		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891
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		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		71		72		73		74		75		76		77		78		79		80		81		82		83		84		85		86		87		88
rec_type		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN
form_type		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		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		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G
tran_id		EDT376		EXP1044		EXP1045		EXP1046		EXP1089		INC1116		INC1117		EXP1027		EXP1043		EXP1028		EXP1030		EXP1031		EXP1044		EXP1047		EXP1045		EXP1046		EXP1048		EXP1034		EXP1052		EXP1059		EXP1060		EXP1057		EXP1055		EXP1068		EXP1063		EXP1067		EXP1064		EXP1074		EXP1097		EXP1078		EXP1095		EXP1083		EXP1089		EXP1106		EXP1085		EXP1126		EXP1098		EXP1103		EXP1123		EXP1102		EXP1101		INC1116		INC1117		EXP1128		EXP1144		EXP1169		EXP1170		EXP1141		NON1154		EDT379		EDT372		EDT382		EDT377		EDT367		EDT374		EDT373		EDT366		EDT368		EDT381		EDT371		EDT375		EDT376		EDT365		EDT380		EDT378		EDT370		EDT350		EDT349		EDT389		EDT390		EDT386		EDT387		EDT388		PDT53		PDT54		PDT42		PDT41		PDT49		PDT44		PDT45		PDT48		EDT363		EDT364		NON1029		NON1162		NON1161		NON1163		NON1152
entity_cd		COM		COM		COM		COM		COM		COM		COM		IND		OTH		OTH		OTH		OTH		COM		COM		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		IND		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		OTH		COM		IND		OTH		OTH		OTH		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		OTH		OTH		OTH		OTH		IND		OTH		IND		OTH		OTH		OTH		OTH		IND		OTH		IND		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Phil Ting for Assembly 2022		Blanca Pacheco for Assembly 2022		Chris Duncan for Assembly 2022		Fauzia Rizvi for Assemly 2022		Committee to Elect Andrew Taban for Hart School Board 2022		CALIFORNIA SENIOR VOTER GUIDE		MILLENNIALS FOR EFFECTIVE GOVERNMENT		Douglas		eFundraising Connections		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Blanca Pacheco for Assembly 2022		CALIFORNIA SENIOR VOTER GUIDE		Chris Duncan for Assembly 2022		Fauzia Rizvi for Assemly 2022		MILLENNIALS FOR EFFECTIVE GOVERNMENT		Ugarte and Associates LLC		Gould & Orellana, LLC		CGU Capital Group, LLC		Fairbank, Maslin, Maullin, Metz, & Associates		Jacobson & Zilber Strategies LLC		The Grantsmanship Center		California Bank & Trust		Castro		FedEx		Kegeyan-Pappas Consulting		eFundraising Connections		eFundraising Connections		Jacobson & Zilber Strategies LLC		eFundraising Connections		FedEx		Committee to Elect Andrew Taban for Hart School Board 2022		eFundraising Connections		Jacobson & Zilber Strategies LLC		eFundraising Connections		UNITED DEMOCRATIC CAMPAIGN COMMITTEE		California Bank & Trust		eFundraising Connections		Jacobson & Zilber Strategies LLC		Premiere Political Communications		CALIFORNIA SENIOR VOTER GUIDE		MILLENNIALS FOR EFFECTIVE GOVERNMENT		eFundraising Connections		eFundraising Connections		eFundraising Connections		eFundraising Connections		Political Data Inc.		U.S. Postmaster		Avis Rent A Car		Capitol Morning Report		CBCF Inc.		Clubcorp Service		G Rossi Florist		Madre Oaxacan Restaurant		Michaels Stores		Mission Ebenezer Family		NBCSL		NBCUniversal Media, LLC		Niko's Pizzeria		Palm Restaurant		Phil Ting for Assembly 2022		Thai The House of Authentic Ingredients		The Resort at Pelican Hill		Trinity Lutheran Church		Vallejo's Restaurant		Hoy		Mailing Pros Inc.		Hoy		Mailing Pros Inc.		DS Political		Meta Platforms Inc		Political Data Inc.		Hoy		Mailing Pros Inc.		Hoy		Mailing Pros Inc.		Bullseye Marketing		Hoy		Political Data Inc.		Union Graphics LLC		Amazon.com Services LLC		Amazon.com Services LLC		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster		U.S. Postmaster
payee_namf		None		None		None		None		None		None		None		Maya		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Aide		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Ken Van		None		Ken Van		None		None		None		None		Ken Van		None		Ken Van		None		None		Ken Van		None		None		None		None		None		None		None		None		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		Sacramento		Sacramento		Sacramento		Sacramento		Newhall		Norwalk		Norwalk		Los Angeles		Sacramento		Los Angeles		Los Angeles		Los Angeles		Sacramento		Norwalk		Sacramento		Sacramento		Norwalk		Huntington Park		Norwalk		San Pedro		Oakland		Los Angeles		Los Angeles		Los Angeles		Lynwood		Pasadena		Sherman Oaks		Sacramento		Sacramento		Los Angeles		Sacramento		Pasadena		Newhall		Sacramento		Los Angeles		Sacramento		Inglewood		Los Angeles		Sacramento		Los Angeles		Ferndale		Norwalk		Norwalk		Sacramento		Sacramento		Sacramento		Sacramento		Long Beach		Los Angeles		Newport Beach		Sacramento		Washington		Los Angeles		Sacramento		Torrance		Lakewood		Carson		Washington		Los Angeles		San Pedro		Los Angeles		Sacramento		Sacramento		Newport Beach		Hawthorne		Sacramento		Wahington		Huntington Beach		Wahington		Huntington Beach		Oakland		Menlo Park		Long Beach		Wahington		Huntington Beach		Wahington		Huntington Beach		Northridge		Wahington		Long Beach		Sun Valley		Seattle		Seattle		Los Angeles		Los Angeles		Los Angeles		Los Angeles		Los Angeles
payee_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		WA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CA		CA		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		DC		CA		CA		Ca		CA		DC		CA		DC		CA		CA		DC		CA		CA		WA		WA		CA		CA		CA		CA		CA
payee_zip4		95841		95814		95815		95815		91321		90650		90650		90012		95814		90027		90027		90027		95814		90650		95815		95815		90650		90255		90650		90731		94612		90027		90017		90071		90262		91109-7321		91423		95814		95814		90027		95814		91109-7321		91321		95814		90027		95814		90301		90071		95814		90027		98248		90650		90650		95814		95814		95814		95814		90806		90071		92660		95814		20036		90071		95814		90501		90712		90745		20001		90068		90731		90015		95841		95819		92657		90250		95811		20005		92649		20005		92649		94607		94025		90806		20005		92649		20005		92649		91324		20005		90806		91352		98109		98109		90071		90071		90071		90071		90071
expn_date		2022-09-25 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-12 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 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-01 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-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-11 00:00:00		2022-10-11 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-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-18 00:00:00		2022-10-19 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-21 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 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-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-28 00:00:00		2022-10-12 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00
amount		100		1000		1000		1000		500		-2500		-5000		116		221		33582		11947		13005		1000		2500		1000		1000		5000		22500		500		1732		35750		10000		400		8405		193		31		1917		45		244		28511		221		31		500		113		16758		1		3415		448		113		34000		491		-2500		-5000		46		91		222		113		5600		3470		689		265		280		2256		174		598		164		500		375		136		131		137		100		143		147		103		102		600		27897		600		8232		21250		7290		360		600		22370		600		8011		4168		600		394		3202		608		727		16449		4872		4872		13368		4819
cum_ytd		100		1000		1000		1000		500		-2500		-5000		116		2416		592853		592853		592853		1000		1407		1000		1000		3272		70000		42903		9253		35750		592853		400		83160		193		403		37723		2416		2416		592853		2416		403		500		2416		592853		2416		3415		83160		2416		592853		1634		1407		3272		2416		2416		2416		2416		17509		6467		689		530		433		5745		174		598		164		500		375		136		131		137		100		421		36787		103		102		9250		104776		9250		104776		46750		27640		17509		9250		104776		9250		104776		96528		9250		17509		54471		1335		1335		6467		6467		6467		6467		6467
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_chkno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_code		MON		MON		MON		MON		MON		MON		MON		OFC		CMP		LIT		LIT		LIT		CTB		LIT		CTB		CTB		LIT		CNS		PRO		CMP		POL		CNS		CMP		CMP		OFC		POS		OFC		CMP		CMP		LIT		CMP		POS		CTB		CMP		LIT		CMP		LIT		CMP		CMP		LIT		PHO		None		None		CMP		CMP		CMP		CMP		LIT		POS		TRC		PRT		MTG		OFC		CMP		MTG		OFC		CVC		CMP		MTG		MTG		MTG		CTB		MTG		TRC		CVC		MTG		CNS		LIT		CNS		LIT		LIT		WEB		LIT		CNS		LIT		CNS		LIT		LIT		CNS		LIT		LIT		FND		FND		POS		POS		POS		POS		POS
expn_dscr		None		None		None		None		None		Refund of Contribution Made		Refund of Contribution Made		None		Credit Card Processing Fee		None		None		None		None		Slate Mailer		None		None		Slate Mailer		None		None		None		None		None		None		Credit Card Payment		None		None		None		Credit Card Processing Fee		Credit Card Processing Fee		None		Credit Card Processing Fee		INV # 7-907-98504		None		Credit Card Processing Fee		None		Credit Card Processing Fee		Slate Mailer		Credit Card Payment		Credit Card Processing Fee		None		None		Refund of slate mailer payment		Refund of slate mailer payment		Credit Card Processing Fee		Credit Card Processing Fee		Credit Card Processing Fee		Credit Card Processing Fee		None		None		Member car rental for week traveling up and down state for campaigning and fundraiser at Pelican Hill Resort.		Report Fee for Chief of Staff Posting.		Asm attended Congressional Black Caucus Foundation Conference in Washington DC.		Membership Dues for Member		Retirement flowers sent to Debra Gravert Chief Administrative Officer, Assembly.		Resolutiion Lunch Asm Gipson for former District Director Victor Ibarra.		Framed Flag for United Farm Workers Commemoration		None		Registration Fee charged to attend, waiting for refund.		None		USS Iowa Meeting		None		None		Dinner Asm Gipson with Rex Richardson		None		None		Legislative business lunch Asm Gipson and capitol staff.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Fundraiser Event Supplies		Fundraiser Event Supplies		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Bullseye Marketing		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		California Bank & Trust		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Jacobson & Zilber Strategies LLC		Kegeyan-Pappas Consulting		Kegeyan-Pappas Consulting		Mailing Pros Inc.		Mailing Pros Inc.		Mailing Pros Inc.		Mailing Pros Inc.		Mailing Pros Inc.
agent_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmte_id		1442437		1443511		1443620		1445659		1444102		1268286		1383025		None		None		None		None		None		1443511		1268286		1443620		1445659		1383025		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1444102		None		None		None		None		None		None		None		None		1268286		1383025		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1442437		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		Dawn Addis		Blanca Pacheco		Chris Duncan		Fauzia Rizvi		Andrew Taban		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		ASM		ASM		ASM		ASM		BED		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		ASM		ASM		ASM		ASM		OTH		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		30		64		74		63		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		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		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_filings

filer_id		1434878
filing_id		2742891
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-27 00:00:00
filing_type		22001

Table: filings

filing_id		2742891
filing_type		22001

Table: hdr

filing_id		2742891
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		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891
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
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
rec_type		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT
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		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
tran_id		IDT56		INC1037		INC1039		INC1040		INC1041		INC1038		INC1035		INC1036		INC1050		INC1049		INC1051		INC1053		IDT57		INC1062		INC1054		IDT59		INC1076		INC1065		INC1075		IDT60		INC1070		INC1071		INC1069		IDT58		IDT61		INC1081		INC1080		INC1084		INC1082		IDT64		IDT62		INC1093		INC1091		INC1092		IDT67		INC1107		IDT65		IDT66		INC1108		INC1109		INC1110		INC1111		INC1114		INC1115		INC1124		INC1119		INC1121		INC1120		INC1129		INC1130		IDT69		IDT71		INC1136		INC1132		IDT70		INC1133		INC1134		INC1138		INC1137		INC1140		INC1135		INC1139		INC1148		INC1147		INC1142		NON1099
entity_cd		OTH		COM		COM		SCC		OTH		OTH		OTH		COM		SCC		COM		OTH		SCC		OTH		COM		COM		IND		IND		COM		OTH		OTH		COM		OTH		COM		IND		IND		COM		OTH		COM		COM		OTH		OTH		COM		SCC		COM		IND		OTH		IND		IND		COM		COM		COM		COM		COM		SCC		COM		COM		OTH		SCC		COM		COM		OTH		OTH		COM		COM		IND		COM		COM		OTH		OTH		IND		COM		OTH		OTH		COM		OTH		COM
ctrib_naml		Celebrity Casinos Inc. DBA: Crystal Casino		California Apartment Association PAC		California Statewide Law Enforcement Assoc PAC		California Teachers Assn. for Better Citizenship		Genentech USA		Lighthouse Public Affairs		Watson Land Company		Western States Petroleum Association PAC (AKA WSPA PAC)		California Federation of Teachers COPE		Californians Allied for Patient Protection PAC		Pfizer Inc.		Laborers' Local 300		M Strategic Communications		The Boeing Company PAC		UPSPAC		Williams		Griffith		Laborers' International Union of North America Local 1309 PAC		Rapid Security Service Inc		World Oil Recycling		California New Car Dealers Association PAC		Meta Platforms Inc		Pharmaceutical Research And Manufacturers Assn of America PAC		Qiu		Welch		Caterpillar Inc. PAC (CATPAC)		UnitedHealth Group Inc.		AFSCME Local 3634 PAC		Honeywell International PAC		United Building Company, Inc.		Athens Services		California Mortgage Bankers Association PAC		California State Association of Electrical Workers		Wine Institute California PAC		Amalfitano		Bulletin Displays, LLC		Ungaro		Ungaro		California Credit Union League PAC		California Optometric PAC		International Paper Political Action Committee (IP PAC)		Phillips North America LLC PAC		National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy		United Domestic Workers of America Action Fund		Building Owners & Managers Association of Greater L.A. PAC		California Alliance of Taxpayers Advocates PAC		Doordash, Inc.		Southern California Pipe Trades District Council #16 PAC		Chris Ward for Assembly 2022		Consumer Attorneys Association of Los Angeles Political Action Committee		Hawaiian Gardens Casino		California Water Service Company		CALPAC California Medical Association PAC		Charter Public Schools PAC		Dake		Deputy Sheriffs' Association of San Diego County PAC		Dr. Arambula for Assembly 2022		Gilead Sciences, Inc.		Harbor Distributing LLC(Tom Reyes)		Martinez		Tasha Boerner Horvath for Assembly 2022		The Zenith		Clear Channel Outdoor, LLC(Layne Lawson)		kevin McCarty for Assembly 2022		Pacific Harbor Line Inc.		California Democratic Party
ctrib_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Ishmun Lee		John H.		None		None		None		None		None		None		Samuel		David		None		None		None		None		None		None		None		None		None		Thomas C.		None		Henry		Michael		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Glen		None		None		None		None		Efren		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_city		Compton		Sacramento		Sacramento		Burlingame		South San Francisco		San Francisco		Carson		San Rafael		Sacramento		Sacramento		Mamphis		Los Angeles		Los Angeles		Arlington		Atlanta		Los Angeles		Los Angeles		Lakewood		Los Angeles		South Gate		Sacramento		Menlo Park		Sacramento		Pasadena		Los Angeles		Deerfield		Minneapolis		Los Angeles		Washington		Redondo Beach		La Puente		Roseville		Pasadena		Long Beach		San Pedro		Long Beach		Rancho Palos Verdes		Los Alamitos		Ontario		Sacramento		Washington		Washington		Sacramento		Sacramento		Los Angeles		Sacramento		San Francisco		Los Angeles		Encinitas		Los Angeles		Hawaiian Gardens		San Jose		Sacramento		Sacramento		Los Angeles		Encinitas		Sacramento		Foster City		Huntington Beach		Huntington Park		Sacramento		Woodland Hills		San Antonio		Sacramento		Chicago		Sacramento
ctrib_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		TN		CA		CA		VA		GA		CA		CA		CA		CA		CA		CA		Ca		CA		CA		CA		IL		MN		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		TX		CA		IL		CA
ctrib_zip4		90220		95814		95814		94010		94080		94133		90745		94901		95814		95814		38120		90006		90021		22202		30328		90731		90056		90712		90020		90280		95814		94025		95814		91101		90014		60015		55436		90020		20001		90277		91746		95661		91101		90802		90732		90805		90275		90720		91761		95816		20004		20005		95815		95814		90017		95814		94107		90020		92024		90017		90716		95112		95814		95814		90063		92024		95815		94404		92647		90255		95815		91367		78249		95864		60604		95814
ctrib_emp		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Ishmun Lee Williams		Korea Realty		None		None		None		None		None		None		Qiu Accountancy Corp.		DRWELCH Attorneys		None		None		None		None		None		None		None		None		None		None		None		None		San Pedro Fish		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		GDML		None		None		None		None		Unified Consulting Services		None		None		None		None		None		None
ctrib_occ		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Real Estate		CEO		None		None		None		None		None		None		Accountant		Attorney		None		None		None		None		None		None		None		None		None		Retired		None		Retired		CEO		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Landscape Architect		None		None		None		None		Public Policy Advisor		None		None		None		None		None		None
ctrib_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		I		None		None		None		None		None		None		None		None		None		None		None		I		None		None		I		None		None		None		I		None		None		None		I		I		None		None		None		None		I		I		None		None		None		I		None		I		I		None		None		None		None		None		None		None		None		None		None		None		None		I		I		None		None		I		None		None		None		None		None		None		None		None		None		None		None
rcpt_date		2022-09-26 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-10-01 00:00:00		2022-10-01 00:00:00		2022-10-01 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-06 00:00:00		2022-10-06 00:00:00		2022-10-06 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-11 00:00:00		2022-10-11 00:00:00		2022-10-12 00:00:00		2022-10-12 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-14 00:00:00		2022-10-14 00:00:00		2022-10-15 00:00:00		2022-10-15 00:00:00		2022-10-15 00:00:00		2022-10-15 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-20 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-09-25 00:00:00
date_thru		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount		4900		4900		2000		9700		2500		1000		4900		2500		2500		1500		1500		2500		1000		1500		4000		500		4900		2400		4900		4900		2000		4900		2500		4900		2500		2000		3000		3500		1000		500		2500		1500		4400		4900		1000		1000		500		1000		2500		2400		3000		1500		1000		2000		1000		1500		1000		4800		4900		1000		4900		1500		2900		1500		1000		2400		4900		2500		1500		3000		4900		3000		2500		4900		4900		150
cum_ytd		4900		9800		2000		19400		2500		1000		4900		2500		7500		4500		1500		2500		1000		1500		4000		500		9800		7300		9800		4900		2000		9800		2500		4900		2500		2000		3000		3500		1000		500		2500		1500		11900		6800		1000		1000		500		1000		7400		3900		5000		1500		3500		2000		1500		1500		3500		4800		9800		1000		4900		1500		4900		4500		1000		4900		4900		2500		3000		3000		9800		3000		4500		4900		9800		36647
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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Phone Bank
cmte_id		None		745208		970375		741941		None		None		None		1414539		741857		920780		None		950674		None		C00142711		C00064766		None		None		851621		None		None		741623		None		1282378		None		None		None		None		1255127		C00096156		None		None		890152		743107		1277874		None		None		None		None		760225		745825		C00034405		C00239780		1318200		1302384		922454		1345580		None		760715		1434927		871554		None		None		742617		1302433		None		862122		1434574		None		None		None		1434881		None		None		1435556		None		741666
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
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
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
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
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
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
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
intr_naml		eFundraising Connections		None		None		None		None		None		None		None		None		None		None		None		eFundraising Connections		None		None		eFundraising Connections		None		None		None		eFundraising Connections		None		None		None		eFundraising Connections		eFundraising Connections		None		None		None		None		eFundraising Connections		eFundraising Connections		None		None		None		eFundraising Connections		None		eFundraising Connections		eFundraising Connections		None		None		None		None		None		None		None		None		None		None		None		None		eFundraising Connections		eFundraising Connections		None		None		eFundraising Connections		None		None		None		None		None		None		None		None		None		None		None
intr_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_city		Sacramento		None		None		None		None		None		None		None		None		None		None		None		Sacramento		None		None		Sacramento		None		None		None		Sacramento		None		None		None		Sacramento		Sacramento		None		None		None		None		Sacramento		Sacramento		None		None		None		Sacramento		None		Sacramento		Sacramento		None		None		None		None		None		None		None		None		None		None		None		None		Sacramento		Sacramento		None		None		Sacramento		None		None		None		None		None		None		None		None		None		None		None
intr_st		CA		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		CA		None		None		None		CA		None		None		None		CA		CA		None		None		None		None		CA		CA		None		None		None		CA		None		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		CA		CA		None		None		CA		None		None		None		None		None		None		None		None		None		None		None
intr_zip4		95814		None		None		None		None		None		None		None		None		None		None		None		95814		None		None		95814		None		None		None		95814		None		None		None		95814		95814		None		None		None		None		95814		95814		None		None		None		95814		None		95814		95814		None		None		None		None		None		None		None		None		None		None		None		None		95814		95814		None		None		95814		None		None		None		None		None		None		None		None		None		None		None
intr_emp		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_occ		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
office_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
juris_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
sup_opp_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
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
int_rate		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_cmteid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: smry

filing_id		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891
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		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
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		C		C		C		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H
amount_a		181035		0		181035		150		181185		234399		0		234399		34071		150		268620		154682		181035		0		234399		101318		0		0		83851		181000		35		181035		150		0		150		-3900		7500		3600		234261		137		0		234399		79821		45750		34071		0		0		0		0		0		0
amount_b		906735		0		906735		36647		943381		1133719		0		1133719		83851		36647		1254217		None		None		None		None		None		None		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
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

Table: splt

filing_id		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891		2742891
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		0		0		0		0		0		0		0		0		0		0		0		0		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		71		72		73		74		75		76		77		78		79		80		81		82		83		84		85		86		87		88		89		90		91		92		93		94		95		96		97		98		99		100		101		102		103		104		105		106
pform_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		C		D		D		D		D
ptran_id		IDT56		INC1037		INC1037		INC1039		INC1040		INC1040		INC1041		INC1041		INC1038		INC1035		INC1035		INC1036		INC1050		INC1050		INC1049		INC1049		INC1051		INC1051		INC1053		INC1053		IDT57		INC1062		INC1062		INC1054		INC1054		IDT59		INC1076		INC1076		INC1065		INC1065		INC1075		INC1075		IDT60		IDT60		INC1070		INC1070		INC1071		INC1071		INC1069		IDT58		IDT61		IDT61		INC1081		INC1080		INC1080		INC1084		INC1082		IDT64		IDT62		IDT62		INC1093		INC1091		INC1091		INC1092		INC1092		IDT67		INC1107		IDT65		IDT66		INC1108		INC1108		INC1109		INC1109		INC1110		INC1110		INC1111		INC1114		INC1114		INC1115		INC1124		INC1119		INC1121		INC1121		INC1120		INC1120		INC1129		INC1129		INC1130		IDT69		IDT71		INC1136		INC1136		INC1132		IDT70		INC1133		INC1133		INC1134		INC1138		INC1138		INC1137		INC1137		INC1140		INC1135		INC1135		INC1139		INC1139		INC1148		INC1148		INC1147		INC1142		INC1142		NON1099		INC1116		INC1116		INC1117		INC1117
elec_date		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		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		4900		4900		4900		2000		9700		9700		2000		2500		1000		3500		4900		2500		5000		2500		4000		1500		1500		1500		4950		2500		1000		1500		1500		4000		4000		500		4900		4900		4900		4900		4900		4900		2500		4900		3000		2000		4900		4900		2500		4900		3000		2500		2000		1500		3000		3500		1000		500		1000		2500		1500		9700		9700		4900		4900		1000		1000		500		1000		2500		4900		1500		2400		3500		3000		1500		2500		1000		2000		1500		1500		1500		2000		9700		9700		4900		4900		1000		4900		1500		4900		4900		4500		1000		4500		4900		4900		2500		2500		2500		1500		3000		4900		4900		2000		3000		2500		4500		4900		4900		4900		177		1407		2500		1000		5000
elec_code		G		P		G		G		P		G		P		G		G		P		G		G		P		G		P		G		P		G		P		G		G		P		G		P		G		G		P		G		P		G		P		G		P		G		P		G		P		G		G		G		P		G		G		P		G		G		G		G		P		G		G		P		G		P		G		G		G		G		G		P		G		P		G		P		G		G		P		G		G		G		G		P		G		P		G		P		G		G		G		G		P		G		G		G		P		G		G		P		G		P		G		G		P		G		P		G		P		G		G		P		G		G		P		G		P		G