Home

Filing ID: 2744196

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

Table: cvr2_campaign_disclosure

filing_id		2744196
amend_id		0
line_item		1
rec_type		CVR2
form_type		F460
tran_id		NIC3
entity_cd		COM
title		None
mail_city		None
mail_st		None
mail_zip4		None
f460_part		5b
cmte_id		1290201
enty_naml		JANET NGUYEN FOR SUPERVISOR 2022
enty_namf		None
enty_namt		None
enty_nams		None
enty_city		GARDEN GROVE
enty_st		CA
enty_zip4		92840
enty_phon		916/473-4298
enty_fax		None
enty_email		None
tres_naml		BAUER
tres_namf		DAVID
tres_namt		None
tres_nams		None
control_yn		Y
office_cd		None
offic_dscr		None
juris_cd		None
juris_dscr		None
dist_no		None
off_s_h_cd		None
bal_name		None
bal_num		None
bal_juris		None
sup_opp_cd		None

Table: cvr3_verification_info

filing_id		2744196		2744196
amend_id		0		0
line_item		1		2
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		VER_1.1		VER_2.2
entity_cd		TRE		CAO
sig_date		2022-10-27 00:00:00		2022-10-27 00:00:00
sig_loc		None		None
sig_naml		DAVID BAUER		JANET NGUYEN
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2744196
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1443408
entity_cd		CTL
filer_naml		JANET NGUYEN FOR SENATE 2022
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-27 00:00:00
stmt_type		PE
late_rptno		None
from_date		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00
elect_date		2022-06-07 00:00:00
filer_city		GARDEN GROVE
filer_st		CA
filer_zip4		92840
filer_phon		916/473-4298
filer_fax		None
file_email		[email protected]
mail_city		GRANITE BAY
mail_st		CA
mail_zip4		95746
tres_naml		BAUER
tres_namf		DAVID
tres_namt		None
tres_nams		None
tres_city		GRANITE BAY
tres_st		CA
tres_zip4		95746
tres_phon		916/473-4298
tres_fax		None
tres_email		None
cmtte_type		C
control_yn		Y
sponsor_yn		N
primfrm_yn		N
brdbase_yn		N
amendexp_1		None
amendexp_2		None
amendexp_3		None
rpt_att_cb		None
cmtte_id		None
reportname		None
rptfromdt		None
rptthrudt		None
emplbus_cb		None
bus_name		None
bus_city		None
bus_st		None
bus_zip4		None
bus_inter		None
busact_cb		None
busactvity		None
assoc_cb		None
assoc_int		None
other_cb		None
other_int		None
cand_naml		NGUYEN
cand_namf		JANET
cand_namt		None
cand_nams		None
cand_city		HUNTINGTON BEACH
cand_st		CA
cand_zip4		92649
cand_phon		714/928-4568
cand_fax		None
cand_email		[email protected]
bal_name		None
bal_num		None
bal_juris		None
office_cd		SEN
offic_dscr		None
juris_cd		SEN
juris_dscr		None
dist_no		36
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		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196
amend_id		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F		F		F		F		F		F		F
tran_id		PAY450		PAY685		PAY692		PAY699		PAY718		PAY745		PAY687		PAY876		PAY882		PAY883
entity_cd		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		GILLIARD BLANNING & ASSOCIATES, INC.		WENDY WARFIELD & ASSOC.		CHASE CARD SERVICES		CHASE CARD SERVICES		TLT GROUP, LLC		SELECT GRAPHICS & PRINTING		CHASE CARD SERVICES		WENDY WARFIELD & ASSOC.		CHASE CARD SERVICES		CHASE CARD SERVICES
payee_namf		None		None		None		None		None		None		None		None		None		None
payee_namt		None		None		None		None		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None		None		None		None		None
payee_city		ROCKLIN		SACRAMENTO		CAROL STREAM		CAROL STREAM		HUNTINGTON BEACH		GARDEN GROVE		CAROL STREAM		SACRAMENTO		CAROL STREAM		CAROL STREAM
payee_st		CA		CA		IL		IL		CA		CA		IL		CA		IL		IL
payee_zip4		95765		95814		60197		60197		92647		92840		60197		95814		60197		60197
beg_bal		25000		8460		7043		887		25000		19928		0		0		0		0
amt_incur		0		0		0		0		0		0		1208		1980		379		4563
amt_paid		0		8460		7043		887		25000		19928		0		0		0		0
end_bal		25000		0		0		0		0		0		1208		1980		379		4563
expn_code		WEB		CNS		None		None		CNS		LIT		CTB		CNS		WEB		OFC
expn_dscr		None		None		SEE SCH. G		SEE SCH G		None		None		None		None		None		SEE SCH. G
cmte_id		None		None		None		None		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None		None
memo_refno		PAY450		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None

Table: expn

filing_id		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196
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
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
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
form_type		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		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		PDT28		EXP700		EXP695		EXP697		EXP716		EXP727		EXP728		EXP748		EXP729		EXP723		EXP730		EXP785		EXP738		EXP288		EXP749		EXP756		EXP757		EXP764		EXP766		EXP771		EXP779		EXP794		EXP787		EXP788		EXP746		EXP789		EXP792		EXP793		EXP796		EXP797		EXP799		EXP805		EXP806		EXP811		EXP807		EXP808		EXP821		EXP820		EXP828		EXP829		EXP826		EXP827		EXP838		EXP845		EXP839		EXP833		EXP842		EXP843		EXP850		EXP851		EXP853		EXP854		EXP855		PDT28		EDT92		EDT93		EDT91		EDT85		EDT87		EDT86		EDT90		EDT89		EDT88		EDT80		EDT81		EDT82		EDT79		PDT43		PDT40		PDT45		PDT42		PDT39		PDT44		PDT46		PDT41		EDT78		EDT99		EDT96		EDT77		EDT83		EDT95		EDT94		EDT98		EDT97
entity_cd		PTY		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		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		OTH		IND		IND		OTH		OTH		OTH		OTH		OTH		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		REPUBLICAN PARTY OF ORANGE COUNTY		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		EFUNDRAISING CONNECTIONS		BUDGET WATCHDOGS		CALIFORNIA VOTER GUIDE		EFUNDRAISING CONNECTIONS		SENIOR ADVOCATE		SPHERION STAFFING		TLT GROUP, LLC		CALIFORNIA BANK AND TRUST		EFUNDRAISING CONNECTIONS		HUNTINGTON PARTNERS, LLC		EFUNDRAISING CONNECTIONS		EFUNDRAISING CONNECTIONS		WENDY WARFIELD & ASSOC.		EFUNDRAISING CONNECTIONS		SPHERION STAFFING		TLT GROUP, LLC		TLT GROUP, LLC		CALIFORNIA BANK AND TRUST		EFUNDRAISING CONNECTIONS		GILLIARD BLANNING & ASSOCIATES, INC.		SELECT GRAPHICS & PRINTING		THE MONACO GROUP		ADVANTAGE INC.		CALIFORNIA BANK AND TRUST		CHASE CARD SERVICES		CHASE CARD SERVICES		THE MONACO GROUP		SPHERION STAFFING		BAUER		LITTLE SAIGON RADIO		VIETNAM AMERICA TV, INC.		VNCR		THE MONACO GROUP		WENDY WARFIELD & ASSOC.		ADVANTAGE INC.		CALIFORNIA BANK AND TRUST		THE MONACO GROUP		WENDY WARFIELD & ASSOC.		EFUNDRAISING CONNECTIONS		NGUYEN		RAMIREZ		SELECT GRAPHICS & PRINTING		THE MONACO GROUP		THE MONACO GROUP		EFUNDRAISING CONNECTIONS		SPHERION STAFFING		VBS TELEVISION		DAVIS		GILLIARD BLANNING & ASSOCIATES, INC.		REPUBLICAN PARTY OF ORANGE COUNTY		COSTCO		GREEN FARM MARKET		BLEU RESTAURANT		SPECTRUM TV		DROPBOX		T-MOBILE		COSTCO		HOME DEPOT		VONAGE		RED CASTLE KOREAN BBQ		SELECT GRAPHICS & PRINTING		TRAM CHIM RESTAURANT		U.S. POSTAL SVC.		AMAZON		BUFFALO WILD WINGS		BUON GUSTO DELI		CAMPAIGNSIDEKICK		CONSTANT CONTACT		RESTAURANT DEPOT		SAM'S CLUB		U.S. POSTAL SVC.		FACEBOOK		FACEBOOK		U.S. POSTAL SVC.		GILLIARD BLANNING & ASSOCIATES, INC.		U.S. POSTAL SVC.		GILLIARD BLANNING & ASSOCIATES, INC.		U.S. POSTAL SVC.		GILLIARD BLANNING & ASSOCIATES, INC.		U.S. POSTAL SVC.
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		DAVID		None		None		None		None		None		None		None		None		None		None		DANNY		FRANCISCO		None		None		None		None		None		None		STACY		None		None		None		None		None		None		None		None		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
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
payee_city		TUSTIN		CAROL STREAM		CAROL STREAM		CAROL STREAM		SACRAMENTO		TORRANCE		TORRANCE		SACRAMENTO		TORRANCE		REDDING		HUNTINGTON BEACH		LOS ANGELES		SACRAMENTO		HUNTINGTON BEACH		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		REDDING		HUNTINGTON BEACH		HUNTINGTON BEACH		LOS ANGELES		SACRAMENTO		ROCKLIN		GARDEN GROVE		SANTA ANA		BONITA SPRINGS		LOS ANGELES		CAROL STREAM		CAROL STREAM		SANTA ANA		REDDING		GRANITE BAY		WESTMINSTER		GARDEN GROVE		FOUNTAIN VALLEY		SANTA ANA		SACRAMENTO		BONITA SPRINGS		LOS ANGELES		SANTA ANA		SACRAMENTO		SACRAMENTO		WESTMINSTER		ORANGE		GARDEN GROVE		SANTA ANA		SANTA ANA		SACRAMENTO		REDDING		WESTMINSTER		LAKE FOREST		ROCKLIN		TUSTIN		HUNTINGTON BEACH		GARDENA		WESTMINSTER		None		None		CINCINNATI		HUNTINGTON BEACH		HUNTINGTON BEACH		None		GARDEN GROVE		GARDEN GROVE		GARDEN GROVE		SANTA ANA		SEATTLE		HUNTINGTON BEACH		HUNTINGTON BEACH		None		None		HUNTINGTON BEACH		HUNTINGTON BEACH		HUNTINGTON BEACH		MENLO PARK		MENLO PARK		SANTA ANA		ROCKLIN		SANTA ANA		ROCKLIN		SANTA ANA		ROCKLIN		SANTA ANA
payee_st		CA		IL		IL		IL		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		FL		CA		IL		IL		CA		CA		CA		CA		CA		CA		CA		CA		FL		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		None		None		OH		CA		CA		None		CA		CA		CA		CA		WA		CA		CA		None		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		92780		60197		60197		60197		95816		90505		90505		95816		90505		96002		92647		90071		95816		92647		95816		95816		95814		95816		96002		92647		92647		90071		95816		95765		92840		92705		34135		90071		60197		60197		92705		96002		95746		92683		92843		92706		92705		95814		34135		90071		92705		95814		95816		92683		92867		92840		92705		92705		95816		96002		92683		92630		95765		92780		92647		90249		92683		None		None		45274		92647		92647		None		92844		92840		92844		92701		98109		92647		92649		None		None		92647		92646		92648		94025		94025		92701		95765		92701		95765		92701		95765		92701
expn_date		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-28 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-01 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-06 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-13 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-15 00:00:00		2022-10-15 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-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-20 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-09-26 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-09-29 00:00:00		2022-10-01 00:00:00		2022-10-01 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-07 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-11 00:00:00		2022-10-21 00:00:00		2022-10-19 00:00:00		2022-10-11 00:00:00		2022-10-15 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00
amount		1750		887		7043		1863		101		2500		1500		36		1500		4568		25000		24		7		2000		36		160		8460		2		4568		12500		12500		35		5		10000		19928		7692		350		35		10458		922		375		4568		1698		1785		1800		1500		17603		5282		350		35		53541		4870		3		2000		450		7618		17603		15477		73		4568		1500		3840		15000		1750		330		180		258		200		120		194		177		321		169		512		1536		139		6600		547		214		187		1208		379		426		139		1320		8500		12750		4581		1016		17603		4888		19332		2105		17603
cum_ytd		1750		92480		92480		92480		2854		2750		1750		2854		1750		102233		157500		258		2854		20000		2854		2854		38628		2854		102233		157500		157500		258		2854		159205		39198		154355		700		258		92480		92480		154355		102233		9219		1785		1800		1750		154355		38628		700		258		154355		38628		2854		2000		450		39198		154355		154355		2854		102233		1500		5797		159205		1750		4034		180		1047		986		120		2601		4034		1113		169		512		39198		139		84964		919		214		2263		10765		3482		535		139		3350		43256		43256		84964		159205		84964		159205		84964		159205		84964
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
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
expn_code		MON		None		None		CTB		OFC		LIT		LIT		OFC		LIT		CNS		CNS		OFC		OFC		OFC		OFC		OFC		CNS		OFC		CNS		CNS		CNS		OFC		OFC		WEB		LIT		LIT		WEB		OFC		None		None		LIT		CNS		PRO		RAD		TEL		RAD		LIT		CNS		WEB		OFC		LIT		CNS		OFC		MTG		MTG		LIT		LIT		LIT		OFC		CNS		TEL		CNS		WEB		CTB		OFC		OFC		MTG		OFC		OFC		OFC		OFC		OFC		OFC		MTG		LIT		MTG		LIT		OFC		None		None		WEB		WEB		None		OFC		None		WEB		WEB		LIT		LIT		LIT		LIT		LIT		LIT		LIT
expn_dscr		None		SEE SCH G		SEE SCH. G		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		MAIL, MEETINGS		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		FOOD FOR VOLUNTEERS		FOOD FOR VOLUNTEERS		None		None		FOOD FOR VOLUNTEERS		None		STAMPS		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		CHASE CARD SERVICES		GILLIARD BLANNING & ASSOCIATES, INC.		GILLIARD BLANNING & ASSOCIATES, INC.		SELECT GRAPHICS & PRINTING		THE MONACO GROUP		THE MONACO GROUP		THE MONACO GROUP		THE MONACO GROUP		THE MONACO GROUP		THE MONACO GROUP
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
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
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
cmte_id		742088		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		742088		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
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
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
cand_naml		REPUBLICAN PARTY OF ORANGE COUNTY		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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		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
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		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
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
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
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
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
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
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		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
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		EDT91		None		None		None		None		None		None		EDT80		None		EDT82		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
g_from_e_f		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		F		E		E		E		E		E		E		E		E		E		E		E		E		E		F		F		F		F		F		F		F		F		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
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

Table: filer_filings

filer_id		1443408
filing_id		2744196
period_id		251
form_id		F460
filing_sequence		0
filing_date		2022-10-27 00:00:00
stmnt_type		10001
stmnt_status		11003
session_id		2021
user_id		CAFILER
special_audit		11003
fine_audit		11003
rpt_start		2022-09-25 00:00:00
rpt_end		2022-10-22 00:00:00
rpt_date		2022-10-27 00:00:00
filing_type		22001

Table: filings

filing_id		2744196
filing_type		22001

Table: hdr

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

Table: rcpt

filing_id		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196
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
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
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		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		A		A		A		A		A		A		A		A		A		A		A		A		A		A		C		C		C		C		C		C		C		C
tran_id		INC712		INC693		INC703		INC709		INC706		INC690		INC713		INC707		INC702		INC689		INC711		INC704		INC688		INC708		INC691		INC705		INC715		INC726		INC721		INC720		INC724		INC719		INC734		INC733		INC722		INC740		INC741		INC737		INC736		INC739		INC742		INC752		INC753		INC751		INC755		INC754		INC760		INC763		INC761		INC759		INC762		INC765		INC777		INC767		INC769		INC774		INC776		INC778		INC772		INC773		INC768		INC781		INC780		INC783		INC782		INC786		INC791		INC801		INC803		INC802		INC817		INC818		INC813		INC819		INC816		INC823		INC822		INC824		INC830		INC831		INC834		INC835		INC832		INC836		INC841		INC840		INC852		INC844		INC859		INC857		INC860		INC856		INC861		INC858		INC863		NON714		NON743		NON732		NON790		NON800		NON804		NON846		NON847
entity_cd		COM		IND		IND		IND		IND		IND		COM		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		OTH		IND		IND		COM		IND		COM		IND		IND		IND		IND		IND		OTH		COM		IND		COM		OTH		COM		OTH		COM		COM		COM		OTH		OTH		SCC		IND		IND		COM		OTH		IND		IND		IND		IND		IND		OTH		OTH		OTH		OTH		OTH		COM		COM		COM		COM		COM		OTH		OTH		COM		OTH		OTH		COM		COM		COM		IND		OTH		COM		OTH		IND		COM		COM		COM		IND		IND		OTH		IND		SCC		IND		COM		COM		IND		PTY		OTH		PTY		PTY		PTY		PTY		PTY		PTY
ctrib_naml		CALIF. CHAMBER OF COMMERCE PAC (CHAMBERPAC)		Le		Le		Nguy		Nguyen		Nguyen		OC TAX PAC		Pham		Pham		Pham		Pham		Pham		Tran		Tran		Tran		Truong		Dang		ADVANCE BEAUTY COLLEGE INC.		Bui		Le		LONG BEACH AREA REPUBLICANS		Nguyen		CALIF. MEDICAL ASSOC. PAC		NGO		Suzanski		Duong		Gabbard		Le		My Best Homecare		THE HOME DEPOT INC. PAC		MARTIN		CALIF. BANKERS ASSOC. STATE PAC		DIAGIO NORTH AMERICA, INC.		NATIONAL ASSOC. OF INSURANCE AND FINANCIAL ADVISORS CA PAC		THE H & N GROUP MANAGEMENT CO.		UPS PAC		BUILDING OWNERS & MANAGERS ASSOC. OF OC PAC (BOMA OC PAC)		CALIF. CORRECTIONAL PEACE OFFICERS ASSOC. (CCPOA) PAC		CR&R INCORPORATED		FIDELIMEX INC.		PEACE OFFICERS RESEARCH ASSOC. OF CALIF. PAC SMALL CONTRIBUTOR COMMITTEE		Wilson		BLACKMUN		CALIF. RICE PAC		CLAYTON, CLAYTON & CO.		CRANDALL		CRANDALL		JAUREGUI JR.		NGUYEN		TRINH		VAN HUY VU, MD, INC.		1-800-CONTACTS, INC.		AMERICAN EXPRESS		NETSTAR		SEMPRA ENERGY		CALIF. INDEPENDENT PETROLEUM ASSOC. PAC		BANK OF AMERICA STATE AND FEDERAL PAC		CALIF. LIFE SCIENCES ASSOC. PAC		CALIF. MORTGAGE BANKERS ASSOC. PAC		MILK PRODUCERS COUNCIL PAC		BARONA BAND OF MISSION INDIANS		ENSIGN FACILITY SERVICES, INC.		KINECTA FEDERAL CREDIT UNION STATE PAC		PROVIDENCE GROUP INC.		UNIVERSAL MUSIC GROUP, INC.		ASSOC. OF CALIF. STATE SUPERVISORS PAC		NEW MAJORITY PAC - ORANGE COUNTY		AMERICAN COUNCIL OF ENGINEERING COMPANIES CALIFORNIA PAC		Neves-Hatchwell		YOCHA DEHE WINTUN NATION		DAIRY INSTITUTE LEGISLATIVE COMMITTEE		DOOR DASH, INC.		Montejano		NFIB CALIFORNIA PAC		CA STATE LODGE FOP PAC		CALIF. ASSOC. OF LICENSED INVESTIGATORS PAC		Bergen		Cohen		ANTHEM BLUE CROSS		Burris		CALIF. ASSOC. OF HIGHWAY PATROLMEN PAC		Kent		ORANGE COUNTY BUSINESS COUNCIL'S BIZ PAC		THE HARTFORD FINANCIAL SERVICES GRP, INC. PAC		APICELLA		CALIF. REPUBLICAN PARTY		BLEU RESTAURANT		CALIF. REPUBLICAN PARTY		CALIF. REPUBLICAN PARTY		CALIF. REPUBLICAN PARTY		REPUBLICAN PARTY OF ORANGE COUNTY		REPUBLICAN PARTY OF ORANGE COUNTY		REPUBLICAN PARTY OF ORANGE COUNTY
ctrib_namf		None		An		Tram		Kim		Kim		Tuan		None		Duc		Luan		Nam		Nhu		Than		Ngoc		Thi		Ty		Nhung		Kiem		None		Rose		Nghiem		None		Nhien		None		KEVIN		Lynne		David		John		Chuck		None		None		RAYMOND		None		None		None		None		None		None		None		None		None		None		Scott		DARREL		None		None		LARRY		SANDRA		ISMAEL		DIEUQUYEN		TRUONG		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Mercedes		None		None		None		Jeff		None		None		None		Ronald		Sam		None		Michael		None		Mike		None		None		DENISE		None		None		None		None		None		None		None		None
ctrib_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_city		SACRAMENTO		Carmel		Anaheim		San Diego		Silver Spring		Beaverton		SACRAMENTO		Wichita		Oakland		Quincy		Houston		Bremerton		Garden Grove		Tacoma		San Jose		Tampa		Charlotte		GARDEN GROVE		Huntington Beach		West Carrollton		LONG BEACH		Westminster		SACRAMENTO		NEWPORT BEACH		Huntington Beach		Oakland		Dana Point		Newport Beach		San Jose		WASHINGTON		HUNTINGTON BEACH		SACRAMENTO		NORWALK		SACRAMENTO		SANTA ANA		ATLANTA		TUSTIN		SACRAMENTO		STANTON		FOUNTAIN VALLEY		SACRAMENTO		Concord		GARDEN GROVE		SACRAMENTO		NEWPORT BEACH		FOUNTAIN VALLEY		FOUNTAIN VALLEY		GARDEN GROVE		GARDEN GROVE		SAN JOSE		FOUNTAIN VALLEY		DRAPER		WASHINGTON		PALO ALTO		SAN DIEGO		IRVINE		WILMINGTON		SACRAMENTO		ROSEVILLE		ONTARIO		LAKESIDE		SAN JUAN CAPISTRANO		MANHATTAN BEACH		FARMINGTON		WOODLAND HILLS		SACRAMENTO		SAN RAFAEL		SACRAMENTO		Seal Beach		BROOKS		SACRAMENTO		SAN FRANCISCO		San clemente		WASHINGTON		SACRAMENTO		GLENDORA		Newport Beach		Santa Ynez		CINCINATTI		Huntington Beach		SACRAMENTO		Long Beach		LOS ANGELES		HARTFORD		LAGUNA BEACH		SACRAMENTO		WESTMINSTER		SACRAMENTO		SACRAMENTO		SACRAMENTO		TUSTIN		TUSTIN		TUSTIN
ctrib_st		CA		IN		CA		CA		MD		OR		CA		KS		CA		MA		TX		WA		CA		WA		CA		FL		NC		CA		CA		OH		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CT		CA		CA		GA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		UT		DC		CA		CA		CA		DE		CA		CA		CA		CA		CA		CA		UT		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CA		CA		OH		CA		CA		CA		CA		CT		CA		CA		CA		CA		CA		CA		CA		CA		CA
ctrib_zip4		95814		46033		92801		92130		20902		97008		95814		67220		94607		02171		77075		98312		92843		98465		95117		33615		28269		92843		92647		45449		90853		92683		95814		92660		92647		94606		92629		92657		95131		20004		92649		95814		06851		95814		92703		30328		92780		95814		90680		92708		95834		94518		92841		95814		92660		92708		92708		92840		92841		95123		92708		84020		20018		94306		92101		92618		19884		95814		95661		91761		90240		92675		90266		84025		91367		95814		94901		95814		90740		95606		95814		94107		92673		20004		9814		91740		92660		93460		45209		92648		95818		90803		90071		06115		92651		95814		92683		95814		95814		95814		92780		92780		92780
ctrib_emp		None		Retired		Retired		Retired		Retired		Retired		None		Retired		Retired		Retired		Retired		Retired		Retired		Retired		Retired		Retired		Retired		None		Arlington law Office		Retired		None		Retired		None		KEVCOMP		Retired		CA Waste Solutions		Miramar Properties		7 Day Dental		None		None		RAYMOND DEAN		None		None		None		None		None		None		None		None		None		None		Lawrence Livermore National Laboratory		N/A		None		None		N/A		N/A		N/A		SBTN		N/A		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Mercedes International Signals Inc		None		None		None		BIA		None		None		None		Retired		Santa Ynez Band of Chumash Indians		None		Retired		None		Caprock partners		None		None		N/A		None		None		None		None		None		None		None		None
ctrib_occ		None		Retired		Retired		Retired		Retired		Retired		None		Retired		Retired		Retired		Retired		Retired		Retired		Retired		Retired		Retired		Retired		None		Lawyer		Retired		None		Retired		None		CEO		Retired		CEO		Real Estate		Dentist		None		None		REAL ESTATE BROKER		None		None		None		None		None		None		None		None		None		None		Community Relations Officer		RETIRED		None		None		RETIRED		RETIRED		RETIRED		RADIO HOST		RETIRED		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Self employed		None		None		None		exec		None		None		None		Retired		Government and Legal Specialist		None		Retired		None		Asset & Property Manager		None		None		RETIRED		None		None		None		None		None		None		None		None
ctrib_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpt_date		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-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-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-27 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-01 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-03 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-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-06 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-07 00:00:00		2022-10-08 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-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-15 00:00:00		2022-10-15 00:00:00		2022-10-16 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-22 00:00:00		2022-09-27 00:00:00		2022-09-28 00:00:00		2022-09-29 00:00:00		2022-10-11 00:00:00		2022-10-12 00:00:00		2022-10-12 00:00:00		2022-10-19 00:00:00		2022-10-19 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount		2000		100		100		100		100		200		4900		100		100		100		100		100		120		100		100		200		150		500		250		100		500		100		3400		1000		250		4900		1000		2500		1000		2000		1000		2000		2000		2000		4900		2500		1500		4900		1500		1000		5000		100		100		2500		500		100		100		400		200		100		250		1000		2000		1000		2900		2000		2000		1500		1500		2500		3000		2000		500		4900		1000		1500		4900		1900		600		4900		2500		1000		1000		1000		2000		500		250		2000		3000		1000		4900		1500		2500		1000		100		30489		1600		22230		53569		53569		6682		50000		6682
cum_ytd		5000		100		100		100		100		200		4900		100		100		100		100		100		120		100		100		200		150		500		250		100		500		100		9800		1000		250		9800		2000		2500		1000		2000		5900		9069		2000		3000		4900		2500		4000		9800		1500		1000		18900		100		100		2500		1000		100		100		400		200		100		250		2500		2000		1000		9800		2000		2000		1500		1500		2500		3000		2000		500		4900		1000		8400		9800		8400		600		6900		2500		1000		1000		1000		2000		500		350		2000		3000		1000		19300		1500		2500		1000		100		472526		3600		472526		472526		472526		63364		63364		63364
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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		MASS MAIL		FUNDRAISING EVENT		MASS MAIL		MASS MAIL		MASS MAIL		SIGNS		PHONEBANKS		SIGNS
cmte_id		950352		None		None		None		None		None		1288619		None		None		None		None		None		None		None		None		None		None		None		None		None		1405347		None		742617		None		None		None		None		None		None		1409634		None		742694		None		743365		None		1377592		1347850		830349		None		None		810830		None		None		891390		None		None		None		None		None		None		None		None		None		None		None		822237		1357000		1272633		890152		744692		None		None		1285775		None		None		1303937		992074		782143		None		None		741436		None		None		822768		1334557		791587		None		None		None		None		802001		None		802010		930174		None		810683		None		810683		810683		810683		742088		742088		742088
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
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
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
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
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
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
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
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		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		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		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		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		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		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		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		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		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		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		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
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
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
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		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
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		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
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
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
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
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
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
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		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
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
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
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
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
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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: smry

filing_id		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196
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
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22A		22B		1		2		3		1		2		3		1		2		3		4		1		2		3		1		2		3		4		1		2		3		1		2		3		1		2		3
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		A		A		A		C		C		C		I		I		I		I		D		D		D		E		E		E		E		F		F		F		B1		B1		B1		H		H		H
amount_a		125238		0		125238		224822		350060		296240		0		296240		-53189		224822		467873		649031		125238		35		296240		478064		0		0		33130		660695		281391		563783		241631		124670		568		125238		224822		0		224822		0		35		0		35		1750		0		1750		296220		20		0		296240		8130		61319		-53189		0		0		0		0		0		0
amount_b		1270060		0		1270060		274864		1544924		792753		0		792753		33130		274864		1100747		None		None		None		None		None		None		None		None		884229		825096		None		None		None		None		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
elec_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2022-11-08 00:00:00		2022-06-07 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: splt

filing_id		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196		2744196
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53		54		55		56		57		58		59		60		61		62		63		64		65		66		67		68		69		70		71		72		73		74		75		76		77		78		79		80		81		82		83		84		85		86		87		88		89		90		91		92		93		94		95		96		97		98		99		100		101		102		103		104		105		106		107		108		109		110		111		112		113
pform_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		C		C		C		C		C		C		C		C		C
ptran_id		INC712		INC712		INC693		INC703		INC709		INC706		INC690		INC713		INC707		INC702		INC689		INC711		INC704		INC688		INC708		INC691		INC705		INC715		INC726		INC721		INC720		INC724		INC719		INC734		INC734		INC733		INC722		INC740		INC740		INC741		INC741		INC737		INC736		INC739		INC742		INC742		INC752		INC752		INC753		INC751		INC751		INC755		INC754		INC760		INC760		INC763		INC763		INC761		INC759		INC762		INC762		INC765		INC777		INC767		INC769		INC769		INC774		INC776		INC778		INC772		INC773		INC768		INC781		INC781		INC780		INC783		INC782		INC782		INC786		INC791		INC801		INC803		INC802		INC817		INC818		INC813		INC819		INC816		INC823		INC823		INC822		INC822		INC824		INC824		INC830		INC831		INC831		INC834		INC835		INC832		INC836		INC841		INC840		INC852		INC852		INC844		INC859		INC857		INC860		INC860		INC856		INC861		INC858		INC863		NON714		NON743		NON743		NON732		NON790		NON800		NON804		NON846		NON847
elec_date		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00
elec_amount		2000		3000		100		100		100		100		200		4900		100		100		100		100		100		120		100		100		200		150		500		250		100		500		100		4900		4900		1000		250		4900		4900		1000		1000		2500		1000		2000		4900		1000		4169		4900		2000		1000		2000		4900		2500		2500		1500		4900		4900		1500		1000		9800		9100		100		100		2500		500		500		100		100		400		200		100		250		1500		1000		2000		1000		4900		4900		2000		2000		1500		1500		2500		3000		2000		500		4900		1000		4900		3500		4900		4900		4900		3500		600		2000		4900		2500		1000		1000		1000		2000		500		100		250		2000		3000		1000		9700		9600		1500		2500		1000		100		472526		1600		2000		472526		472526		472526		63364		63364		63364
elec_code		P		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		P		G		G		G		P		G		P		G		G		G		G		P		G		P		G		G		P		G		G		G		P		G		P		G		G		G		P		G		G		G		G		P		G		G		G		G		G		G		G		P		G		G		G		P		G		G		G		G		G		G		G		G		G		G		G		P		G		P		G		P		G		G		P		G		G		G		G		G		G		G		P		G		G		G		G		P		G		G		G		G		G		G		G		P		G		G		G		G		G		G