Home

Filing ID: 2742549

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

Table: cvr2_campaign_disclosure

filing_id		2742549
amend_id		0
line_item		1
rec_type		CVR2
form_type		F460
tran_id		OFC4
entity_cd		ATR
title		None
mail_city		None
mail_st		None
mail_zip4		None
f460_part		3
cmte_id		None
enty_naml		Hildreth
enty_namf		Brian T.
enty_namt		None
enty_nams		None
enty_city		Sacramento
enty_st		CA
enty_zip4		95814
enty_phon		(916) 442-7757
enty_fax		None
enty_email		None
tres_naml		None
tres_namf		None
tres_namt		None
tres_nams		None
control_yn		None
office_cd		None
offic_dscr		None
juris_cd		None
juris_dscr		None
dist_no		None
off_s_h_cd		None
bal_name		None
bal_num		None
bal_juris		None
sup_opp_cd		None

Table: cvr3_verification_info

filing_id		2742549
amend_id		0
line_item		1
rec_type		CVR3
form_type		F460
tran_id		VER_1.1
entity_cd		TRE
sig_date		2022-10-22 00:00:00
sig_loc		None
sig_naml		Thomas W. Hiltachk
sig_namf		None
sig_namt		None
sig_nams		None

Table: cvr_campaign_disclosure

filing_id		2742549
amend_id		0
rec_type		CVR
form_type		F460
filer_id		890483
entity_cd		RCP
filer_naml		California Building Industry Association PAC
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-22 00:00:00
stmt_type		PE
late_rptno		None
from_date		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00
elect_date		2022-11-08 00:00:00
filer_city		Sacramento
filer_st		CA
filer_zip4		95814
filer_phon		(916) 443-7933
filer_fax		(916) 442-7759
file_email		[email protected]
mail_city		Sacramento
mail_st		CA
mail_zip4		95814
tres_naml		Hiltachk
tres_namf		Thomas W.
tres_namt		None
tres_nams		None
tres_city		Sacramento
tres_st		CA
tres_zip4		95814
tres_phon		(916) 442-7757
tres_fax		None
tres_email		None
cmtte_type		G
control_yn		Y
sponsor_yn		N
primfrm_yn		N
brdbase_yn		None
amendexp_1		None
amendexp_2		None
amendexp_3		None
rpt_att_cb		None
cmtte_id		None
reportname		None
rptfromdt		None
rptthrudt		None
emplbus_cb		None
bus_name		None
bus_city		None
bus_st		None
bus_zip4		None
bus_inter		None
busact_cb		None
busactvity		None
assoc_cb		None
assoc_int		None
other_cb		None
other_int		None
cand_naml		None
cand_namf		None
cand_namt		None
cand_nams		None
cand_city		None
cand_st		None
cand_zip4		None
cand_phon		None
cand_fax		None
cand_email		None
bal_name		None
bal_num		None
bal_juris		None
office_cd		None
offic_dscr		None
juris_cd		None
juris_dscr		None
dist_no		None
off_s_h_cd		None
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: expn

filing_id		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549
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
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
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
form_type		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		E		E		E		E		E		E		E		E
tran_id		EXP13124		EXP13123		EXP13126		EXP13125		EXP13140		EXP13139		EXP13138		EXP13141		EXP13133		EXP13142		EXP13136		EXP13134		EXP13132		EXP13143		EXP13137		EXP13135		EXP13124		EXP13123		EXP13126		EXP13125		EXP13127		EXP13128		EXP13129		EXP13140		EXP13139		EXP13138		EXP13141		EXP13133		EXP13142		EXP13136		EXP13134		EXP13132		EXP13143		EXP13137		EXP13135
entity_cd		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		OTH		OTH		OTH		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM
payee_naml		Californians for Jobs and a Strong Economy		Rahn for Assembly 2022		Sabrina Cervantes for Assembly 2022		Soria for Assembly 2022		Blanca Pacheco for Assembly 2022		Corey Jackson for Assembly 2022		Dawn Addis for Assembly 2022		Gail Pellerin for Assembly 2022		Gipson for Assembly 2022		Juan Alanis for Assembly 2022		Laurie Davies for Assembly 2022		Megan Dahle for Assembly 2022		Phil Ting for Assembly 2022		Rick Chavez Zbur for Assembly 2022		Rob Bonta for CA Attorney General 2022		Tina McKinnor for Assembly 2022		Californians for Jobs and a Strong Economy		Rahn for Assembly 2022		Sabrina Cervantes for Assembly 2022		Soria for Assembly 2022		California Legislative Black Caucus Policy Institute		Sacramento Downtown Arena, LLC		Bell, McAndrews & Hiltachk, LLP		Blanca Pacheco for Assembly 2022		Corey Jackson for Assembly 2022		Dawn Addis for Assembly 2022		Gail Pellerin for Assembly 2022		Gipson for Assembly 2022		Juan Alanis for Assembly 2022		Laurie Davies for Assembly 2022		Megan Dahle for Assembly 2022		Phil Ting for Assembly 2022		Rick Chavez Zbur for Assembly 2022		Rob Bonta for CA Attorney General 2022		Tina McKinnor for Assembly 2022
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
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
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
payee_city		Sacramento		Wilton		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Hilmar		Hilmar		Hilmar		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Wilton		Sacramento		Sacramento		Los Angeles		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Hilmar		Hilmar		Hilmar		Sacramento		Sacramento		Sacramento		Sacramento
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
payee_zip4		95814		95693		95814		95814		95814		95814		95814		95814		95814		95988		95324		95324		95814		95815		95814		95835		95814		95693		95814		95814		90017		95814		95814		95814		95814		95814		95814		95814		95988		95324		95324		95814		95815		95814		95835
expn_date		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-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 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-10-05 00:00:00		2022-10-05 00:00:00		2022-10-10 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00
amount		25000		2000		1500		3000		2000		2000		2000		2000		2450		2000		1000		2450		1900		2000		4000		2000		25000		2000		1500		3000		30000		101522		510		2000		2000		2000		2000		2450		2000		1000		2450		1900		2000		4000		2000
cum_ytd		25000		2000		1500		3000		2000		2000		2000		2000		4900		2000		2500		2450		1900		2000		8000		2000		25000		2000		1500		3000		30000		301522		5880		2000		2000		2000		2000		4900		2000		2500		2450		1900		2000		8000		2000
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
expn_code		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		CTB		CTB		CTB		CTB		CVC		FND		PRO		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB
expn_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
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
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
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
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
cmte_id		1275549		1443672		1435160		1443835		1443511		1441894		1442437		1445957		1434878		1445119		1435669		1435439		1437844		1437343		1437201		1444546		1275549		1443672		1435160		1443835		None		None		None		1443511		1441894		1442437		1445957		1434878		1445119		1435669		1435439		1437844		1437343		1437201		1444546
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
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
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
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
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
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
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
cand_naml		Californians for Jobs and a Strong Economy		Matthew Rahn		Sabrina Cervantes		Esmeralda Soria		Blanca Pacheco		Corey Jackson		Dawn Addis		Gail Pellerin		Mike Gipson		Juan Alanis		Laurie Davies		Megan Dahle		Phil Ting		Rick Chavez Zbur		Rob Bonta		Tina McKinnor		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
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
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
office_cd		OTH		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ATT		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		General Purpose Recipient Committee		None		None		None		None		None		None		None		None		None		None		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		STW		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		ASM		STW		ASM		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
dist_no		None		71		58		27		64		60		30		28		65		22		74		01		19		51		None		61		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
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
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
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
sup_opp_cd		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
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
memo_refno		EXP13124		EXP13123		EXP13126		EXP13125		EXP13140		EXP13139		EXP13138		EXP13141		EXP13133		EXP13142		EXP13136		EXP13134		EXP13132		EXP13143		EXP13137		EXP13135		EXP13124		EXP13123		EXP13126		EXP13125		EXP13127		EXP13128		EXP13129		EXP13140		EXP13139		EXP13138		EXP13141		EXP13133		EXP13142		EXP13136		EXP13134		EXP13132		EXP13143		EXP13137		EXP13135
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
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
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
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

Table: filer_filings

filer_id		1047894
filing_id		2742549
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-22 00:00:00
filing_type		22001

Table: filings

filing_id		2742549
filing_type		22001

Table: hdr

filing_id		2742549
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		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549
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
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
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
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
tran_id		IDT20674		IDT20700		IDT20709		IDT20732		IDT20710		IDT20634		IDT20651		IDT20698		IDT20642		IDT20697		IDT20736		IDT20650		IDT20654		IDT20714		IDT20724		IDT20633		IDT20681		IDT20738		IDT20668		IDT20617		IDT20694		IDT20660		IDT20742		IDT20719		IDT20749		IDT20696		IDT20725		IDT20624		IDT20720		IDT20693		IDT20690		IDT20616		IDT20686		IDT20721		IDT20744		IDT20747		IDT20699		IDT20684		INC13131
entity_cd		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		OTH		OTH		OTH		OTH		OTH		OTH		OTH
ctrib_naml		Andrew Lauren Interiors, Inc.		Architects Orange (AO)		Bassenian Lagoni Architects		Builders FirstSource		Carlson, Barbee & Gibson, Inc.		Century Communities, Inc.		Chicago Title Company		Circle M Contractors, Inc.		DR Horton LA Holding Co., Inc.		Eagle Roofing Products		Eagle Roofing Products		Eagle Roofing Products		FBC Mortgage, LLC (Donna Mauer)		Gouvis Engineering Consulting Group, Inc.		Integral Communities, LLC (Lance Waite)		Interior Logic Group Builder Services		Kimball, Tirey & St. John, LLP		KPS Alarms, Inc. / KPS Fire Sprinkers		Lixil		loanDepot.com, LLC (Mike Surges)		loanDepot.com, LLC (Mike Surges)		Nortek Security & Control		OJ Insulation Industries Company, Inc.		Old Republic Title		Pacific InterWest Building Consultants, Inc.		Prime Association Services		River Islands Development, LLC (Susan Dell'Osso)		Ryan Young Interiors		SDG Architects + Engineering		Smart Systems Technologies, Inc.		Soil Retention Systems, Inc.		Sunnova Energy Corporation		SunPower Corp.		The Ryness Company		The Sherwin Williams Company		TruTeam of California, Inc.		United Site Services of California, Inc.		Zonda Homes		Taylor Morrison Inc. Building Strong Business PAC (FEC ID#C00564807)
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		None		None		None		None		None		None		None		None		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
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
ctrib_city		San Diego		Orange		Newport Beach		Indio		San Ramon		San Jose		Roseville		Rancho Santa Margarita		Corona		Stockton		Stockton		Stockton		Orlando		Newport Beach		Danville		Sacramento		San Diego		Ontario		Sacramento		Roseville		Roseville		Carlsbad		Temecula		Fresno		Walnut Creek		San Clemente		Lathrop		National City		Brentwood		Irvine		San Diego		Houston		Anaheim		Danville		San Diego		Sacramento		Escondido		Costa Mesa		Scottsdale
ctrib_st		CA		CA		CA		CA		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		TX		CA		CA		CA		CA		CA		CA		AZ
ctrib_zip4		92121		92866		92660		92201		94583		95113		95661		92688		92880		95206		95206		95206		32801		92660		94526		95834		92108		91761		95811		95661		95661		92010		92590		93711		94596		92673		95330		91950		94513		92618		92127		77046		92806		94526		92123		95834		92029		92626		85251
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		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
tran_type		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		None
rcpt_date		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-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-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-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-06 00:00:00		2022-10-06 00:00:00		2022-10-17 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
amount		75		75		75		75		75		75		1000		75		75		75		75		1000		75		75		75		75		75		75		56		75		75		38		75		75		75		75		75		75		75		75		75		75		75		75		75		75		75		75		8100
cum_ytd		150		150		300		225		1075		300		1075		150		300		1375		1375		1375		150		150		3300		225		150		225		206		300		300		113		150		150		300		150		150		225		1150		150		150		450		150		150		150		300		225		225		8100
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
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
cmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
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
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
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
intr_naml		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		California Building Industry Association		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
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
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
intr_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None
intr_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		None
intr_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
memo_refno		IDT20674		IDT20700		IDT20709		IDT20732		IDT20710		IDT20634		IDT20651		IDT20698		IDT20642		IDT20697		IDT20736		IDT20650		IDT20654		IDT20714		IDT20724		IDT20633		IDT20681		IDT20738		IDT20668		IDT20617		IDT20694		IDT20660		IDT20742		IDT20719		IDT20749		IDT20696		IDT20725		IDT20624		IDT20720		IDT20693		IDT20690		IDT20616		IDT20686		IDT20721		IDT20744		IDT20747		IDT20699		IDT20684		INC13131
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
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
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
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
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

Table: smry

filing_id		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549
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
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
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
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
amount_a		19490		0		19490		0		19490		189332		0		189332		0		0		189332		525632		19490		0		189332		355790		0		0		0		12744		6747		19490		57300		0		57300		189332		0		0		189332		0		0		0		0		0		0
amount_b		333411		0		333411		0		333411		558173		0		558173		0		0		558173		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
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

Table: splt

filing_id		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549		2742549
amend_id		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
pform_type		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D
ptran_id		EXP13123		EXP13126		EXP13125		EXP13140		EXP13139		EXP13138		EXP13141		EXP13133		EXP13133		EXP13142		EXP13136		EXP13136		EXP13134		EXP13134		EXP13132		EXP13132		EXP13143		EXP13137		EXP13137		EXP13135
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
elec_amount		2000		1500		3000		2000		2000		2000		2000		3950		2450		2000		4500		1000		3000		2450		3000		1900		2000		4000		4000		2000
elec_code		G		G		G		G		G		G		G		P		G		G		P		G		P		G		P		G		G		P		G		G