Home

Filing ID: 2744431

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

Table: cvr3_verification_info

filing_id		2744431		2744431
amend_id		0		0
line_item		1		2
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		Treas-CVR3.812		Cand-CVR3.2534
entity_cd		TRE		CAO
sig_date		2022-10-25 00:00:00		2022-10-25 00:00:00
sig_loc		Hilmar,CA		Modesto,CA
sig_naml		Lawler		Alanis
sig_namf		Kelly		Juan
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2744431
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1445119
entity_cd		CAO
filer_naml		Juan Alanis For Assembly 2022
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-25 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		Modesto
filer_st		CA
filer_zip4		95355
filer_phon		209-527-2041
filer_fax		None
file_email		kellylawler@thekalgroup.com
mail_city		Modesto
mail_st		CA
mail_zip4		95355
tres_naml		Lawler
tres_namf		Kelly
tres_namt		None
tres_nams		None
tres_city		Hilmar
tres_st		CA
tres_zip4		95324
tres_phon		(209) 656-1542
tres_fax		None
tres_email		None
cmtte_type		C
control_yn		Y
sponsor_yn		N
primfrm_yn		None
brdbase_yn		None
amendexp_1		None
amendexp_2		None
amendexp_3		None
rpt_att_cb		None
cmtte_id		None
reportname		None
rptfromdt		None
rptthrudt		None
emplbus_cb		None
bus_name		None
bus_city		None
bus_st		None
bus_zip4		None
bus_inter		None
busact_cb		None
busactvity		None
assoc_cb		None
assoc_int		None
other_cb		None
other_int		None
cand_naml		Alanis
cand_namf		Juan
cand_namt		None
cand_nams		None
cand_city		Modesto
cand_st		CA
cand_zip4		95355
cand_phon		2095272041
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		22
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		2744431		2744431		2744431		2744431		2744431
amend_id		0		0		0		0		0
line_item		1		2		3		4		5
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F		F
tran_id		F-606		F-656		F-680		F-659		F-824
entity_cd		OTH		OTH		OTH		OTH		OTH
payee_naml		AimPoint Inc.		AimPoint Inc.		AimPoint Inc.		CITI Card		CITI Card
payee_namf		None		None		None		None		None
payee_namt		None		None		None		None		None
payee_nams		None		None		None		None		None
payee_city		Sacramento		Sacramento		Sacramento		New York		New York
payee_st		CA		CA		CA		NY		NY
payee_zip4		95814		95814		95814		10013		10013
beg_bal		3634		4628		914		333		0
amt_incur		0		0		0		0		589
amt_paid		3634		4628		0		333		0
end_bal		0		0		914		0		589
expn_code		None		CNS		FND		None		None
expn_dscr		FND and POS		None		9/23/22 Fundraising Reception Food and Beverage		OFC, MTG, CVC and CMP		OFC, MTG, TRC and CMP
cmte_id		None		None		None		None		None
tres_naml		None		None		None		None		None
tres_namf		None		None		None		None		None
tres_namt		None		None		None		None		None
tres_nams		None		None		None		None		None
tres_city		None		None		None		None		None
tres_st		None		None		None		None		None
tres_zip4		None		None		None		None		None
memo_code		None		None		None		None		None
memo_refno		None		None		None		None		None
bakref_tid		None		None		None		None		None
xref_schnm		None		None		None		None		None
xref_match		None		None		None		None		None

Table: expn

filing_id		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431
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
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
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
form_type		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
tran_id		E-686		E-666		E-667		E-643		E-669		E-691		E-690		E-693		E-692		E-699		E-841		E-713		E-710		E-734		E-721		E-722		E-714		E-728		E-736		E-741		E-735		E-744		E-746		E-760		E-776		E-754		E-755		E-783		E-766		E-774		E-785		E-787		E-791		E-789		E-807		E-795		E-823		G-687		G-688		G-846		G-847		G-848		G-849		G-850		G-851		G-852		G-723		G-853		G-854		G-855		G-856		G-857		G-858		G-859		G-724		G-867		G-868		G-747		G-756		G-757		G-866		G-865		G-864		G-863		G-862		G-861		G-860		G-796		G-797		G-826		G-825
entity_cd		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		IND		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		IND		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND		IND		OTH		OTH
payee_naml		Spherion Staffing LLC		AimPoint Inc.		AimPoint Inc.		The Battin Group		eFundraising Connections		Budget Watchdogs Newsletter		California Voter Guide		Nygren & Company		Senior Advocate		Integrated Solutions: Political		CITI Card		eFundraising Connections		eFundraising Connections		eFundraising Connections		Cops Voter Guide, Inc.		Spherion Staffing LLC		The Battin Group		Signature Signs		Farkas		Media Placement Services		Nygren & Company		The KAL Group Inc.		The Monaco Group		eFundraising Connections		eFundraising Connections		Hilmar High School		Spherion Staffing LLC		eFundraising Connections		Kinney		AimPoint Inc.		eFundraising Connections		eFundraising Connections		eFundraising Connections		The Battin Group		eFundraising Connections		Spherion Staffing LLC		Alanis		Farkas		Miller		KATM-FM		KHKK-FM		KHOP-FM		KJSN-FM		KMRQ-FM		KRVR-FM		KVIN-AM		Farkas		KATM-FM		KHKK-FM		KHOP-FM		KJSN-FM		KMRQ-FM		KRVR-FM		KVIN-AM		Miller		Cross Screen Media		El Toro		USPS		Farkas		Miller		KATM-FM		KHKK-FM		KHOP-FM		KJSN-FM		KMRQ-FM		KRVR-FM		KVIN-AM		Farkas		Miller		Francis Dean and Associates		The Party Connection
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Justin		None		None		None		None		None		None		None		None		None		Paul		None		None		None		None		None		None		None		Barbara		Justin		Emily		None		None		None		None		None		None		None		Justin		None		None		None		None		None		None		None		Emily		None		None		None		Justin		Emily		None		None		None		None		None		None		None		Justin		Emily		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
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
payee_city		Anderson		Sacramento		Sacramento		Reno		Sacramento		Torrance		Torrance		Folsom		Torrance		San Diego		New York		Sacramento		Sacramento		Sacramento		Folsom		Anderson		Reno		Oakdale		Modesto		Las Vegas		Folsom		Hilmar		Santa Ana		Sacramento		Sacramento		Hilmar		Anderson		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Reno		Sacramento		Anderson		Modesto		Modesto		Sacramento		Stockton		Stockton		Stockton		Modesto		Modesto		Modesto		Modesto		Modesto		Stockton		Stockton		Stockton		Modesto		Modesto		Modesto		Modesto		Sacramento		Alexandria		Louisville		Modesto		Modesto		Sacramento		Stockton		Stockton		Stockton		Modesto		Modesto		Modesto		Modesto		Modesto		Sacramento		Fort Myers		Turlock
payee_st		CA		CA		CA		NV		CA		CA		CA		CA		CA		CA		NY		CA		CA		CA		CA		CA		NV		CA		CA		NV		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		NV		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		VA		KY		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		FL		CA
payee_zip4		96007		95814		95814		89511		95816		90505		90505		95630		90505		92116		10013		95816		95816		95816		95630		96007		89511		95361		95356		89147		95630		95324		92705		95816		95816		95324		96007		95816		95831		95814		95816		95816		95816		89511		95816		96007		95355		95356		95816		95206		95206		95206		95355		95355		95351		95351		95356		95206		95206		95206		95355		95355		95351		95351		95816		22314		40202		95350		95356		95816		95206		95206		95206		95355		95355		95351		95351		95356		95816		33907		95380
expn_date		2022-09-25 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 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-10-03 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-07 00:00:00		2022-10-07 00:00:00		2022-10-07 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-11 00:00:00		2022-10-11 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-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-19 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-22 00:00:00		2022-09-25 00:00:00		2022-09-25 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-26 00:00:00		2022-09-26 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-07 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-07 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00
amount		2148		3634		4628		45750		23		500		500		3000		500		475		333		6		15		5		500		2148		45750		268		197		20000		1348		1301		12866		4		14		100		2148		10		1200		10475		52		6		113		22875		23		2148		282		1250		231		9843		7344		6579		6095		2703		3162		3162		1250		9843		7344		6579		6095		2703		3162		3162		231		10000		10000		6056		1250		231		4922		3672		3290		3047		1352		1581		1581		1250		231		126		120
cum_ytd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
expn_chkno		2066		2064		2065		None		94		2068		2067		2070		2069		None		None		99		98		102		2071		2072		None		2073		2075		None		2074		2076		2077		105		107		2078		2079		109		2080		2081		110		111		112		None		114		2082		2083		None		None		None		None		None		None		None		None		None		None		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		SAL		None		CNS		RAD		OFC		LIT		LIT		CNS		LIT		OFC		None		OFC		OFC		OFC		LIT		SAL		RAD		CMP		CMP		WEB		CNS		PRO		None		OFC		OFC		MTG		SAL		OFC		RAD		CNS		OFC		OFC		OFC		RAD		OFC		SAL		TRS		SAL		SAL		RAD		RAD		RAD		RAD		RAD		RAD		RAD		SAL		RAD		RAD		RAD		RAD		RAD		RAD		RAD		SAL		WEB		WEB		POS		SAL		SAL		RAD		RAD		RAD		RAD		RAD		RAD		RAD		SAL		SAL		FND		FND
expn_dscr		None		FND and POS		None		None		None		None		None		None		None		None		OFC, MTG, CVC and CMP		None		None		None		None		None		None		None		None		None		None		None		LIT and POS		None		None		Parade Fee		None		None		None		None		None		None		None		None		None		None		10/9 to 10/10 Air travel for candidate spouse Sacramento to Las Vegas roundtrip for travel with candidate to California Bail Agents Association Conference		None		None		None		None		None		None		None		None		None		None		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_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		Spherion Staffing LLC		Spherion Staffing LLC		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		Spherion Staffing LLC		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		Spherion Staffing LLC		Media Placement Services		Media Placement Services		The Monaco Group		Spherion Staffing LLC		Spherion Staffing LLC		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		The Battin Group		Spherion Staffing LLC		Spherion Staffing LLC		CITI Card		CITI Card
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
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
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
cmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
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
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
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
cand_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
office_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
juris_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
sup_opp_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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		E-686		E-686		E-643		E-643		E-643		E-643		E-643		E-643		E-643		E-722		E-714		E-714		E-714		E-714		E-714		E-714		E-714		E-722		E-741		E-741		E-746		E-755		E-755		E-789		E-789		E-789		E-789		E-789		E-789		E-789		E-795		E-795		F-824		F-824
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		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		F		F
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
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

Table: filer_filings

filer_id		1445119
filing_id		2744431
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-25 00:00:00
filing_type		22001

Table: filings

filing_id		2744431
filing_type		22001

Table: hdr

filing_id		2744431
amend_id		0
rec_type		HDR
ef_type		CAL
state_cd		CA
cal_ver		2.01
soft_name		ISP
soft_ver		1.0
hdrcomment		None

Table: loan

filing_id		2744431
amend_id		0
line_item		1
rec_type		LOAN
form_type		B1
tran_id		B1-130
loan_type		None
entity_cd		IND
lndr_naml		Alanis
lndr_namf		Juan
lndr_namt		None
lndr_nams		None
loan_city		Modesto
loan_st		CA
loan_zip4		95355
loan_date1		2022-04-21 00:00:00
loan_date2		2026-12-31 00:00:00
loan_amt1		0
loan_amt2		40000
loan_amt3		40000
loan_amt4		40000
loan_rate		0
loan_emp		Stanislaus County Sheriffs Department
loan_occ		Sergeant
loan_self		None
cmte_id		None
tres_naml		None
tres_namf		None
tres_namt		None
tres_nams		None
tres_city		None
tres_st		None
tres_zip4		None
intr_naml		None
intr_namf		None
intr_namt		None
intr_nams		None
intr_city		None
intr_st		None
intr_zip4		None
memo_code		None
memo_refno		None
bakref_tid		None
xref_schnm		None
xref_match		None
loan_amt5		0
loan_amt6		0
loan_amt7		0
loan_amt8		40000

Table: rcpt

filing_id		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431
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
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
rec_type		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		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		A		A		A		A		A		A		C		C		C		C		C		C		C
tran_id		A-683		A-681		A-696		A-694		A-695		A-697		A-698		A-700		A-702		A-703		A-707		A-704		A-705		A-720		A-716		A-717		A-715		A-719		A-718		A-726		A-737		A-731		A-730		A-742		A-743		A-837		A-832		A-831		A-739		A-835		A-834		A-738		A-839		A-833		A-838		A-752		A-748		A-749		A-763		A-801		A-800		A-761		A-762		A-803		A-802		A-804		A-769		A-765		A-770		A-772		A-771		A-773		A-780		A-777		A-779		A-788		A-793		A-794		A-808		A-812		A-814		A-811		A-813		A-816		A-819		A-820		A-810		A-815		A-809		A-817		A-822		C-682		C-701		C-729		C-751		C-750		C-778		C-792
entity_cd		OTH		OTH		COM		IND		COM		SCC		IND		IND		IND		COM		IND		COM		COM		COM		OTH		IND		IND		COM		SCC		COM		IND		COM		OTH		OTH		COM		IND		IND		IND		PTY		IND		IND		IND		IND		OTH		OTH		COM		IND		IND		COM		IND		IND		IND		IND		IND		IND		OTH		COM		IND		COM		COM		COM		OTH		SCC		IND		OTH		IND		COM		COM		IND		COM		IND		COM		IND		IND		OTH		OTH		COM		IND		IND		OTH		OTH		PTY		PTY		PTY		IND		IND		PTY		OTH
ctrib_naml		Anheuser Busch Companies		Hilmar Cheese Company		Association of California Insurance Companies Political Action Committee		Doornenbal		Farmers Employees and Agents Political Action Committee		Peace Officers Research Association of California PAC (PORAC PAC)		Godfrey		Ridenour		Hochberg		California Statewide Law Enforcement Association (CSLEA) PAC		Phipps		Lincoln Club of Northern California PAC		Western United Dairymen PAC		California Fresh Fruit Association Political Action Committee		Central Valley Automotive		Costa		Dichellis		Joe Patterson for Assembly 2022		Peace Officers Research Association of California PAC (PORAC PAC)		Jordan Cunningham for Lieutenant Governor 2026		Balmain		Devon Mathis for Assembly 2022		Novartis Services Inc.		Pechanga Band of Indians		United Parcel Service Inc. Political Action Committee (FEC ID #C00064766)		Arauza		Avila		Bairos		California Republican Party		Dykzeul		Godfrey		Hogan		James		Joanna R Smith Bail Bonds		World Title Designs		Milk Producers Council		Sanders		Solorio		California Cattlemen's Association PAC (CATTLE-PAC)		Facha		Fisher		Gilbert		Godfrey		Rank		Rose		Western Singh Brokers		Anesthesia Service Medical Group Advocacy Fund		Mendoza		MOPAC		Pacific Egg & Poultry Association Political Action Committee		Taylor Morrison, Inc. Building Strong Business PAC (FEC ID#C00564807)		Fitzpatrick Dealership Group		California Real Estate Political Action Committee (CREPAC) - California Association of Realtors		Martinez		Sempra Energy		Costa		Bayer US LLC Employee PAC		California Electrical Contractors PAC Sponsored by the California Chapters of the National Electrical Contractors Association		Koch		American Pistachio Growers California PAC		Bains		Concerned Americans for Responsible Government, Sponsored by the California Trucking Association		Kanno		Lusher		Lyons Investments Management LLC and Affilaited entities		Lyons Investments Management LLC and Affilaited entities		National Federation of Independent Business California Political Action Committee		Parson		Ratto		Roth Legal - A Professional Law Corporation		Mitchell Gas and Wash Inc.		California Republican Party		California Republican Party		California Republican Party		Garcia		Garcia		California Republican Party		The Grand Oak
ctrib_namf		None		None		None		John		None		None		Patricia		Douglas		Jason		None		Cory		None		None		None		None		Dan		Peter		None		None		None		Joanna		None		None		None		None		Virginia		Efren		Cherilyn		None		Peter		Patricia		Patrick		Edith		None		None		None		Mary Ann		Eulogio		None		Katherine		Rocky		James		Jennifer		Steven		Kimberlee		None		None		Roberto		None		None		None		None		None		Adrian		None		Chad		None		None		Judith		None		Devinder		None		John		Danny		None		None		None		Shane		Raymond		None		None		None		None		None		Angela		Mark		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		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		Jr.		None		None		None		None		Jr.		None		None		None		None		None		None		None		None		None
ctrib_city		Sacramento		Hilmar		Chicago		Modesto		San Rafael		Sacramento		Hughson		Modesto		La Jolla		Sacramento		Modesto		Sacramento		Turlock		Fresno		Modesto		Modesto		Santa Monica		Wilton		Sacramento		Roseville		Salida		Hilmar		Sacramento		Temecula		Atlanta		Riverbank		Turlock		Oakdale		Sacramento		Oakdale		Hughson		Ripon		Modesto		Modesto		Riverbank		Ontario		Modesto		Atwater		Sacramento		Modesto		Ceres		Oakdale		Modesto		Modesto		Waterford		Modesto		San Diego		Riverbank		Modesto		Sacramento		Scottsdale		Modesto		Los Angeles		Turlock		San Diego		Modesto		St. Louis		Sacramento		Palo Alto		Sacramento		Hughson		Sacramento		Oakdale		Turlock		Modesto		Modesto		Washington		Ceres		Modesto		Modesto		Ceres		Sacramento		Sacramento		Sacramento		Oakdale		Oakdale		Sacramento		Turlock
ctrib_st		CA		CA		IL		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		GA		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		AZ		CA		CA		CA		CA		CA		MO		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
ctrib_zip4		95814		95324		60631		95350		94901		95834		95326		95355		92037		95814		95357		95814		95380		93711		95356		95356		90403		95693		95834		95747		95368		95324		95819		92592		30328		95367		95380		95361		95814		95361		95326		95366		95355		95354		95367		91762		95350		95301		95814		95355		95307		95361		95355		95351		95386		95351		92119		95367		95354		95814		85253		95356		90071		95380		92101		95350		63132		95814		94303		95814		95326		95834		95361		95380		95358		95358		20004		95307		95356		95354		95307		95814		95814		95814		95361		95361		95814		95380
ctrib_emp		None		None		None		Retired		None		None		Ceres Police Department		Retired		Self Employed - Jason Hochberg		None		Retired		None		None		None		None		Kevin's Natural Foods		Retired		None		None		None		Retired		None		None		None		None		Self Employed - Virginia Arauza		Univeral Jewelers		Basi Hub		None		Self Employed - Peter Dykzeul		Ceres Police Department		Stanislaus County		Retired		None		None		None		Retired		Stanislaus Sheriff Department		None		Retired		Retired		A. L. Gilbert Company		Sutter Health		Rank Investigations-Protection		Retired		None		None		Rocha transportation		None		None		None		None		None		Adrian's Bail Bonds		None		ReMax		None		None		Retired		None		Turlock Chrysler Dodge Jeep Ram		None		FABEXCO		Stanislaus County Sheriff		None		None		None		Diamond Bary Areana		Ratto Bros.		None		None		None		None		None		Most Wanted Wine Bar		Most Wanted Wine Bar		None		None
ctrib_occ		None		None		None		Retired		None		None		Police Officer		Retired		Real Estate		None		Retired		None		None		None		None		CEO		Retired		None		None		None		Retired		None		None		None		None		Consultant		Jeweler		Insurance Agent		None		Farmer		Police Officer		Attorney		Retired		None		None		None		Retired		Deputy		None		Retired		Retired		Manager		IT		Self Employed		Retired		None		None		Commercial Driver		None		None		None		None		None		Owner		None		Self Employed		None		None		Retired		None		President		None		Mainteance Manager		Deputy		None		None		None		Self Employed		Farmer		None		None		None		None		None		Co-Owner		Co-Owner		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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-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-10-02 00:00:00		2022-10-02 00:00:00		2022-10-03 00:00:00		2022-10-04 00:00:00		2022-10-04 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-06 00:00:00		2022-10-06 00:00:00		2022-10-08 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-10 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-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-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-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 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-14 00:00:00		2022-10-16 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-19 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-09-28 00:00:00		2022-10-03 00:00:00		2022-10-07 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-14 00:00:00		2022-10-18 00:00:00
date_thru		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount		4900		2500		2500		200		2500		4900		125		100		100		2000		100		2500		2500		1500		500		500		150		1000		4800		4900		75		4900		1000		4900		2500		250		200		100		20000		100		50		300		500		500		300		2000		200		125		2500		125		50		1000		75		600		500		250		1000		25		1000		2000		1000		2500		9700		500		1900		100		2000		2500		2500		1000		500		3000		250		125		1250		1250		2000		100		250		1000		4000		22788		22762		7500		1300		1300		22180		2000
cum_ytd		8900		2500		2500		200		2500		14600		400		100		100		2000		200		2500		2500		1500		500		1000		150		1000		14600		4900		200		4900		1000		7900		2500		250		200		100		206353		100		400		800		500		500		300		2000		400		125		2500		125		100		1000		600		600		500		250		1000		175		1000		2000		1000		2500		9700		750		4900		100		2000		2500		2500		1000		500		3000		250		125		2500		2500		2000		100		250		1000		4000		206353		206353		206353		1300		1300		206353		2000
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		Printing, Mailing and Postage		Printing, Mailing and Postage		Polling		Food and Beverages for Event		Food and Beverages for Event		Mailing, Printing and Postage		Venue for Campaign Event
cmte_id		None		None		830078		None		901422		810830		None		None		None		970375		None		820082		771500		800697		None		None		None		1443381		810830		1447529		None		1435405		None		None		1377592		None		None		None		810163		None		None		None		None		None		None		744692		None		None		760980		None		None		None		None		None		None		None		870598		None		890637		983310		1411094		None		890106		None		None		None		1442148		960891		None		1343200		None		760458		None		None		None		None		822768		None		None		None		None		810163		810163		810163		None		None		810163		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
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
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
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
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
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
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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_occ		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
office_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
juris_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
sup_opp_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
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
int_rate		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_cmteid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: smry

filing_id		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431
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
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		1		2		3		1		2		3		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3		4
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		B1		B1		B1		C		C		C		D		D		D		E		E		E		E		F		F		F		H		H		H		I		I		I		I
amount_a		123215		0		123215		79830		203045		185408		0		185408		-8007		79830		257232		147518		123215		0		185408		85325		0		0		41503		248206		160513		122825		390		123215		0		0		0		79830		0		79830		0		0		0		185343		65		0		185408		589		8596		-8007		0		0		0		0		0		0		0
amount_b		475524		40000		515524		168027		683551		430205		0		430205		1503		168027		599735		None		None		None		None		None		None		None		None		435345		439223		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount_c		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: splt

filing_id		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431		2744431
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
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
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		B1		C		C		C		C		C		C		C		C		C		C		C
ptran_id		A-683		A-697		A-698		A-707		A-717		A-718		A-737		A-742		A-739		A-834		A-738		A-748		A-762		A-765		A-777		A-683		A-681		A-696		A-694		A-695		A-697		A-698		A-700		A-702		A-703		A-707		A-704		A-705		A-720		A-716		A-717		A-715		A-719		A-718		A-726		A-737		A-731		A-730		A-742		A-743		A-837		A-832		A-831		A-739		A-835		A-834		A-738		A-839		A-833		A-838		A-752		A-748		A-749		A-763		A-801		A-800		A-761		A-762		A-803		A-802		A-804		A-769		A-765		A-770		A-772		A-771		A-773		A-780		A-777		A-779		A-788		A-793		A-794		A-808		A-812		A-814		A-811		A-813		A-816		A-819		A-820		A-810		A-815		A-809		A-817		A-822		B1-130		C-682		C-701		C-729		C-778		C-682		C-701		C-729		C-751		C-750		C-778		C-792
elec_date		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00
elec_amount		4000		4900		225		100		500		4900		125		3000		20752		225		500		200		225		50		250		4900		2500		2500		200		2500		9700		175		100		100		2000		100		2500		2500		1500		500		500		150		1000		9700		4900		75		4900		1000		4900		2500		250		200		100		185600		100		175		300		500		500		300		2000		200		125		2500		125		100		1000		375		600		500		250		1000		125		1000		2000		1000		2500		9700		500		4900		100		2000		2500		2500		1000		500		3000		250		125		2500		2500		2000		100		250		1000		4000		41750		20752		20752		20752		20752		185600		185600		185600		1300		1300		185600		2000
elec_code		P		P		P		P		P		P		P		P		P		P		P		P		P		P		P		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		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		P		P		P		P		P		G		G		G		G		G		G		G