Home

Filing ID: 2739683

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

Table: cvr2_campaign_disclosure

filing_id		2739683		2739683
amend_id		1		0
line_item		1		1
rec_type		CVR2		CVR2
form_type		F460		F460
tran_id		OFC2		OFC2
entity_cd		ATR		ATR
title		None		None
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
f460_part		3		3
cmte_id		None		None
enty_naml		Lim		Lim
enty_namf		Andy		Andy
enty_namt		None		None
enty_nams		None		None
enty_city		Camarillo		Camarillo
enty_st		CA		CA
enty_zip4		93010		93010
enty_phon		805-445-7121		805-445-7121
enty_fax		805-445-9071		805-445-9071
enty_email		andy.mscg@gmail.com		andy.mscg@gmail.com
tres_naml		None		None
tres_namf		None		None
tres_namt		None		None
tres_nams		None		None
control_yn		None		None
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
sup_opp_cd		None		None

Table: cvr3_verification_info

filing_id		2739683		2739683
amend_id		1		0
line_item		1		1
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		VER_1.1		VER_1.1
entity_cd		TRE		TRE
sig_date		2022-10-26 00:00:00		2022-10-24 00:00:00
sig_loc		None		None
sig_naml		Keith Kaplan		Keith Kaplan
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2739683		2739683
amend_id		0		1
rec_type		CVR		CVR
form_type		F460		F460
filer_id		1248664		1248664
entity_cd		RCP		RCP
filer_naml		West Hollywood Chamber of Commerce WEHO PAC (AKA WEHO PAC)		West Hollywood Chamber of Commerce WEHO PAC (AKA WEHO PAC)
filer_namf		None		None
filer_namt		None		None
filer_nams		None		None
report_num		000		001
rpt_date		2022-10-24 00:00:00		2022-10-26 00:00:00
stmt_type		PE		PE
late_rptno		None		None
from_date		2022-09-25 00:00:00		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00		2022-10-22 00:00:00
elect_date		None		None
filer_city		West Hollywood		West Hollywood
filer_st		CA		CA
filer_zip4		90046		90046
filer_phon		8054457121		8054457121
filer_fax		8054459071		8054459071
file_email		taskmaster@mlassociates.org		taskmaster@mlassociates.org
mail_city		Camarillo		Camarillo
mail_st		CA		CA
mail_zip4		90310		90310
tres_naml		Kaplan		Kaplan
tres_namf		Keith		Keith
tres_namt		None		None
tres_nams		None		None
tres_city		West Hollywood		West Hollywood
tres_st		CA		CA
tres_zip4		90046		90046
tres_phon		323-651-1400		323-651-1400
tres_fax		None		None
tres_email		None		None
cmtte_type		G		G
control_yn		Y		Y
sponsor_yn		N		N
primfrm_yn		N		N
brdbase_yn		None		None
amendexp_1		None		Updated and additional transactions
amendexp_2		None		None
amendexp_3		None		None
rpt_att_cb		None		None
cmtte_id		None		None
reportname		None		None
rptfromdt		None		None
rptthrudt		None		None
emplbus_cb		None		None
bus_name		None		None
bus_city		None		None
bus_st		None		None
bus_zip4		None		None
bus_inter		None		None
busact_cb		None		None
busactvity		None		None
assoc_cb		None		None
assoc_int		None		None
other_cb		None		None
other_int		None		None
cand_naml		None		None
cand_namf		None		None
cand_namt		None		None
cand_nams		None		None
cand_city		None		None
cand_st		None		None
cand_zip4		None		None
cand_phon		None		None
cand_fax		None		None
cand_email		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
sup_opp_cd		None		None
employer		None		None
occupation		None		None
selfemp_cb		None		None
bal_id		None		None
cand_id		None		None

Table: expn

filing_id		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683
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		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
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		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
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		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN
form_type		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		E		E		E		E		E		E		E		E		E		E		G		G		G		G		G		G		G		G		G		G		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		E		E		E		E		E		E		E		E		E		E		E		G		G		G		G		G		G		G		G		G		G
tran_id		EDT74		EDT81		EDT73		EDT80		EDT75		EDT82		EDT72		EDT79		EDT76		EDT83		EDT91		EDT90		EDT92		EDT89		EDT93		EDT88		EDT87		EDT95		EDT86		EDT96		EDT94		EDT104		EDT111		EDT105		EDT110		EDT107		EDT112		EDT103		EDT106		EDT109		EDT108		EDT113		EXP1141		EXP1142		EXP1156		EXP1144		EXP1143		EXP1145		EXP1152		EXP1153		EXP1154		EXP1155		EDT77		EDT78		EDT84		EDT85		EDT97		EDT98		EDT99		EDT101		EDT100		EDT102		EDT74		EDT81		EDT73		EDT80		EDT75		EDT82		EDT72		EDT79		EDT76		EDT83		EDT91		EDT90		EDT92		EDT89		EDT93		EDT88		EDT87		EDT95		EDT86		EDT96		EDT94		EDT104		EDT111		EDT105		EDT110		EDT107		EDT112		EDT103		EDT106		EDT109		EDT108		EDT113		EXP1141		EXP1142		EXP1156		EXP1144		EXP1143		EXP1145		EXP1152		EXP1153		EXP1154		EXP1155		EXP1162		EDT77		EDT78		EDT84		EDT85		EDT97		EDT98		EDT99		EDT101		EDT100		EDT102
entity_cd		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		John Duran for WeHo City Council 2022		John Duran for WeHo City Council 2022		John Heilman for West Hollywood City Council 2022		John Heilman for West Hollywood City Council 2022		Marquita Thomas for West Hollywood City Countil 2022		Marquita Thomas for West Hollywood City Countil 2022		Re-elect Meister for City Council 2022		Re-elect Meister for City Council 2022		Sarah Adolphson for West Hollywood City Council 2022		Sarah Adolphson for West Hollywood City Council 2022		John Duran for WeHo City Council 2022		John Heilman for West Hollywood City Council 2022		Marquita Thomas for West Hollywood City Countil 2022		Re-elect Meister for City Council 2022		Sarah Adolphson for West Hollywood City Council 2022		John Duran for WeHo City Council 2022		John Heilman for West Hollywood City Council 2022		Marquita Thomas for West Hollywood City Countil 2022		Re-elect Meister for City Council 2022		Re-elect Meister for City Council 2022		Sarah Adolphson for West Hollywood City Council 2022		John Duran for WeHo City Council 2022		John Duran for WeHo City Council 2022		John Heilman for West Hollywood City Council 2022		John Heilman for West Hollywood City Council 2022		Marquita Thomas for West Hollywood City Countil 2022		Marquita Thomas for West Hollywood City Countil 2022		Re-elect Meister for City Council 2022		Re-elect Meister for City Council 2022		Re-elect Meister for City Council 2022		Sarah Adolphson for West Hollywood City Council 2022		Sarah Adolphson for West Hollywood City Council 2022		Strategy Insights		Strategy Insights		Knecht Strategies, LLC		Boystown Media, Inc.		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Encompass Direct Marketing Group		United States Postal Service		Encompass Direct Marketing Group		United States Postal Service		Encompass Direct Marketing Group		United States Postal Service		Encompass Direct Marketing Group		Encompass Direct Marketing Group		United States Postal Service		United States Postal Service		John Duran for WeHo City Council 2022		John Duran for WeHo City Council 2022		John Heilman for West Hollywood City Council 2022		John Heilman for West Hollywood City Council 2022		Marquita Thomas for West Hollywood City Countil 2022		Marquita Thomas for West Hollywood City Countil 2022		Re-elect Meister for City Council 2022		Re-elect Meister for City Council 2022		Sarah Adolphson for West Hollywood City Council 2022		Sarah Adolphson for West Hollywood City Council 2022		John Duran for WeHo City Council 2022		John Heilman for West Hollywood City Council 2022		Marquita Thomas for West Hollywood City Countil 2022		Re-elect Meister for City Council 2022		Sarah Adolphson for West Hollywood City Council 2022		John Duran for WeHo City Council 2022		John Heilman for West Hollywood City Council 2022		Marquita Thomas for West Hollywood City Countil 2022		Re-elect Meister for City Council 2022		Re-elect Meister for City Council 2022		Sarah Adolphson for West Hollywood City Council 2022		John Duran for WeHo City Council 2022		John Duran for WeHo City Council 2022		John Heilman for West Hollywood City Council 2022		John Heilman for West Hollywood City Council 2022		Marquita Thomas for West Hollywood City Countil 2022		Marquita Thomas for West Hollywood City Countil 2022		Re-elect Meister for City Council 2022		Re-elect Meister for City Council 2022		Re-elect Meister for City Council 2022		Sarah Adolphson for West Hollywood City Council 2022		Sarah Adolphson for West Hollywood City Council 2022		Strategy Insights		Strategy Insights		Knecht Strategies, LLC		Boystown Media, Inc.		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Stripe, Inc.		Encompass Direct Marketing Group		United States Postal Service		Encompass Direct Marketing Group		United States Postal Service		Encompass Direct Marketing Group		United States Postal Service		Encompass Direct Marketing Group		Encompass Direct Marketing Group		United States Postal Service		United States Postal Service
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		Woodland		Woodland		Folsom		West Hollywood		Woodland		Woodland		Woodland		Woodland		Woodland		Woodland		Cheyenne		Washington		Cheyenne		Washington		Cheyenne		Washington		Cheyenne		Cheyenne		Washington		Washington		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		Woodland		Woodland		Folsom		West Hollywood		Woodland		Woodland		Woodland		Woodland		Woodland		Woodland		South San Francisco		Cheyenne		Washington		Cheyenne		Washington		Cheyenne		Washington		Cheyenne		Cheyenne		Washington		Washington
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		CA		CA		WY		DC		WY		DC		WY		DC		WY		WY		DC		DC		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		CA		CA		CA		WY		DC		WY		DC		WY		DC		WY		WY		DC		DC
payee_zip4		90069		90069		90069		90069		90069		90069		90048		90048		90048		90048		90069		90069		90069		90048		90048		90069		90069		90069		90048		90048		90048		90069		90069		90069		90069		90069		90069		90048		90048		90048		90048		90048		95776		95776		95630		90069		95776		95776		95776		95776		95776		95776		82001		20260		82001		20260		82001		20260		82001		82001		20260		20260		90069		90069		90069		90069		90069		90069		90048		90048		90048		90048		90069		90069		90069		90048		90048		90069		90069		90069		90048		90048		90048		90069		90069		90069		90069		90069		90069		90048		90048		90048		90048		90048		95776		95776		95630		90069		95776		95776		95776		95776		95776		95776		94080		82001		20260		82001		20260		82001		20260		82001		82001		20260		20260
expn_date		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-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-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-11 00:00:00		2022-10-11 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-03 00:00:00		2022-10-03 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-11 00:00:00		2022-10-11 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-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-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-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-11 00:00:00		2022-10-11 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-03 00:00:00		2022-10-03 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-11 00:00:00		2022-10-11 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
amount		1909		1008		1909		1008		1909		1008		3818		2017		1909		1008		240		240		240		240		240		3818		3818		3818		3818		3818		3818		3818		445		3818		445		3818		445		3818		3818		890		3818		445		11455		6050		500		1200		11455		11455		2500		11455		11455		2669		3946		4420		3946		4420		3946		4420		3946		3946		4420		4420		1909		1008		1909		1008		1909		1008		3818		2017		1909		1008		240		240		240		240		240		3818		3818		3818		3818		3818		3818		3818		445		3818		445		3818		445		3818		3818		890		3818		445		11455		6050		500		1200		11455		11455		2500		11455		11455		2669		193		3946		4420		3946		4420		3946		4420		3946		3946		4420		4420
cum_ytd		13683		13683		13683		13683		13683		13683		26127		26127		13683		13683		13683		13683		13683		26127		13683		13683		13683		13683		26127		26127		13683		13683		13683		13683		13683		13683		13683		26127		26127		26127		13683		13683		68494		68494		500		14200		68494		68494		68494		68494		68494		68494		19730		22100		19730		22100		19730		22100		19730		19730		22100		22100		13683		13683		13683		13683		13683		13683		26127		26127		13683		13683		13683		13683		13683		26127		13683		13683		13683		13683		26127		26127		13683		13683		13683		13683		13683		13683		13683		26127		26127		26127		13683		13683		68494		68494		500		14200		68494		68494		68494		68494		68494		68494		193		19730		22100		19730		22100		19730		22100		19730		19730		22100		22100
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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_code		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		LIT		PRO		WEB		IND		LIT		LIT		PRO		LIT		LIT		WEB		LIT		POS		LIT		POS		PRT		POS		LIT		LIT		LIT		LIT		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		LIT		PRO		WEB		IND		LIT		LIT		PRO		LIT		LIT		WEB		OFC		LIT		POS		LIT		POS		PRT		POS		LIT		LIT		LIT		LIT
expn_dscr		Slate Mailer		Grphaic Design and Consulting		Slate Mailer		Grphaic Design and Consulting		Slate Mailer		Grphaic Design and Consulting		Slate Mailer		Grphaic Design and Consulting		Slate Mailer		Grphaic Design and Consulting		Digital Ads		Digital Ads		Digital Ads		Digital Ads		Digital Ads		Slate Mailer		Slate Mailer		Slate Mailer		Slate Mailer		Slate Mailer		Slate Mailer		Slate Mailer		Text Messaging		Slate Mailer		Text Messaging		Slate Mailer		Text Messaging		Slate Mailer		Slate Mailer		Text Messaging		Slate Mailer		Text Messaging		Slate Ad		Grphics Design and Consulting		Website development		Digital Ads		Slate Mailer		Slate Mailer		Consulting Service		Slate Mailer		Slate Mailer		Text Messaging		Slate Mailer		Slate Mailer		Mailer Printing		Slater Mailer Postage		Printing		Postage		Printing		Printing		Postage		Postage		Slate Mailer		Grphaic Design and Consulting		Slate Mailer		Grphaic Design and Consulting		Slate Mailer		Grphaic Design and Consulting		Slate Mailer		Grphaic Design and Consulting		Slate Mailer		Grphaic Design and Consulting		Digital Ads		Digital Ads		Digital Ads		Digital Ads		Digital Ads		Slate Mailer		Slate Mailer		Slate Mailer		Slate Mailer		Slate Mailer		Slate Mailer		Slate Mailer		Text Messaging		Slate Mailer		Text Messaging		Slate Mailer		Text Messaging		Slate Mailer		Slate Mailer		Text Messaging		Slate Mailer		Text Messaging		Slate Ad		Grphics Design and Consulting		Website development		Digital Ads		Slate Mailer		Slate Mailer		Consulting Service		Slate Mailer		Slate Mailer		Text Messaging		Merchant Fees		Slate Mailer		Slate Mailer		Mailer Printing		Slater Mailer Postage		Printing		Postage		Printing		Printing		Postage		Postage
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		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights		Strategy Insights
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		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmte_id		1450157		1450157		1446639		1446639		1442044		1442044		1442109		1442109		1453036		1453036		1450157		1446639		1442044		1442109		1453036		1450157		1446639		1442044		1442109		1442109		1453036		1450157		1450157		1446639		1446639		1442044		1442044		1442109		1442109		1442109		1453036		1453036		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1450157		1450157		1446639		1446639		1442044		1442044		1442109		1442109		1453036		1453036		1450157		1446639		1442044		1442109		1453036		1450157		1446639		1442044		1442109		1442109		1453036		1450157		1450157		1446639		1446639		1442044		1442044		1442109		1442109		1442109		1453036		1453036		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		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		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		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		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		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		John Duran		John Duran		John Heilman		John Heilman		Marquita Thomas		Marquita Thomas		Lauren Meister		Lauren Meister		Sarah Adolphson		Sarah Adolphson		John Duran		John Heilman		Marquita Thomas		Lauren Meister		Sarah Adolphson		John Duran		John Heilman		Marquita Thomas		Lauren Meister		Lauren Meister		Sarah Adolphson		John Duran		John Duran		John Heilman		John Heilman		Marquita Thomas		Marquita Thomas		Lauren Meister		Lauren Meister		Lauren Meister		Sarah Adolphson		Sarah Adolphson		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		John Duran		John Duran		John Heilman		John Heilman		Marquita Thomas		Marquita Thomas		Lauren Meister		Lauren Meister		Sarah Adolphson		Sarah Adolphson		John Duran		John Heilman		Marquita Thomas		Lauren Meister		Sarah Adolphson		John Duran		John Heilman		Marquita Thomas		Lauren Meister		Lauren Meister		Sarah Adolphson		John Duran		John Duran		John Heilman		John Heilman		Marquita Thomas		Marquita Thomas		Lauren Meister		Lauren Meister		Lauren Meister		Sarah Adolphson		Sarah Adolphson		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		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		CCM		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		CIT		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		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		None		None		None		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		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		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		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		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		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
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		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		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		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		E		E		E		E		E		E		E		E		E		E		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_filings

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

Table: filings

filing_id		2739683
filing_type		22001

Table: hdr

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

Table: rcpt

filing_id		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683
amend_id		0		0		0		0		0		0		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
line_item		1		2		3		4		5		6		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22
rec_type		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT
form_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A
tran_id		INC1149		INC1150		INC1151		INC1146		INC1147		INC1148		INC1149		INC1150		INC1151		INC1146		INC1147		INC1148		IDT1284		IDT1281		IDT1286		IDT1290		IDT1279		IDT1289		IDT1287		IDT1288		IDT1283		IDT1285		IDT1282		INC1163		INC1158		INC1160		INC1159		INC1161
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		IND		OTH		IND		IND		OTH
ctrib_naml		Le Montrose Suite Hotel		Le Parc Suite Hotel		Mondrian Hotel		Sunset Marquis Hotel		The Grafton Hotel		The Grafton Hotel		Le Montrose Suite Hotel		Le Parc Suite Hotel		Mondrian Hotel		Sunset Marquis Hotel		The Grafton Hotel		The Grafton Hotel		Big Outdoor		Circus of Books		Dialog Cafe		Fleur de Mal		Keith Kaplan's Sotheby's International		Kitchen 24		Laurel Hardware		Pendry West Hollywood		Silver Creek Development		The House on Sunset		Valkyrie Cannabis Lounge		Rudge		Boa Steakhouse & Lounge / IDG		Lehman		Massie		Kermani Ventures Inc
ctrib_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Neal		None		Mark E.		Susan		None
ctrib_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_city		West Hollywood		West Hollywood		Wesy Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		Wesy Hollywood		West Hollywood		West Hollywood		West Hollywood		Los Angeles		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		Los Angeles		West Hollywood		Los Angeles		West Hollywood		Los Angeles		Singapore		Los Angeles		West Hollywood		Pacific Palisades		West Hollywood
ctrib_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		None		CA		CA		None		CA
ctrib_zip4		90069-		90069		90069		90069		90069-		90069-		90069-		90069		90069		90069		90069-		90069-		90068		90046		90069		90069		90069		90069		90046		90069		90025		90069		90015		17909		90048		90069-		90272		90069
ctrib_emp		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Pacific Licensing Studio		None		Law Offices of Mark E. Lehman		Self		None
ctrib_occ		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Partner		None		Attorney		Business Owner		None
ctrib_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tran_type		None		None		None		None		None		None		None		None		None		None		None		None		I		I		I		I		I		I		I		I		I		I		I		None		None		None		None		None
rcpt_date		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-11 00:00:00		2022-10-11 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-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-14 00:00:00		2022-10-17 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
date_thru		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount		26122		32141		16832		25000		7703		8202		26122		32141		16832		25000		7703		8202		106		106		106		106		1000		106		106		625		375		190		106		5000		5000		100		1000		500
cum_ytd		26122		32141		16832		25625		15905		15905		26122		32141		16832		25625		15905		15905		106		106		106		106		1625		106		106		625		375		190		106		5000		5190		100		1000		606
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmte_id		None		None		None		None		None		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
tres_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_naml		None		None		None		None		None		None		None		None		None		None		None		None		West Hollywood Chamber Of Commerce		West Hollywood Chamber Of Commerce		West Hollywood Chamber Of Commerce		West Hollywood Chamber Of Commerce		West Hollywood Chamber Of Commerce		West Hollywood Chamber Of Commerce		West Hollywood Chamber Of Commerce		West Hollywood Chamber Of Commerce		West Hollywood Chamber Of Commerce		West Hollywood Chamber Of Commerce		West Hollywood Chamber Of Commerce		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
intr_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_city		None		None		None		None		None		None		None		None		None		None		None		None		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		West Hollywood		None		None		None		None		None
intr_st		None		None		None		None		None		None		None		None		None		None		None		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		None		None		None		None		None
intr_zip4		None		None		None		None		None		None		None		None		None		None		None		None		90046		90046		90046		90046		90046		90046		90046		90046		90046		90046		90046		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
intr_occ		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
int_rate		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_cmteid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: smry

filing_id		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683		2739683
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		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
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		4		1		2		3		1		2		3		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		4		1		2		3		1		2		3
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		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		D		D		D		E		E		E		E		B1		B1		B1		H		H		H		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		D		D		D		E		E		E		E		B1		B1		B1		H		H		H
amount_a		116000		0		116000		0		116000		70194		0		70194		0		0		70194		26330		116000		0		70194		72136		0		0		0		116000		0		116000		67194		0		67194		70194		0		0		70194		0		0		0		0		0		0		130621		0		130621		0		130621		70403		0		70403		0		0		70403		26330		130621		0		70403		86549		0		0		0		130534		88		130621		67194		0		67194		70387		16		0		70403		0		0		0		0		0		0
amount_b		143020		0		143020		0		143020		114705		0		114705		0		0		114705		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		157641		0		157641		0		157641		114914		0		114914		0		0		114914		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None