OpenCalAccess

Filing ID: 2743970

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

Table: cvr2_campaign_disclosure
filing_id	2743970	2743970	2743970	2743970
amend_id	0	0	1	1
line_item	1	2	1	2
rec_type	CVR2	CVR2	CVR2	CVR2
form_type	F460	F460	F460	F460
tran_id	OFC1	NIC2	OFC1	NIC2
entity_cd	ATR	COM	ATR	COM
title	None	None	None	None
mail_city	None	None	None	None
mail_st	None	None	None	None
mail_zip4	None	None	None	None
f460_part	3	5b	3	5b
cmte_id	None	1385108	None	1385108
enty_naml	Deane	Committee to Improve the Quality of Life in California, Assemblymember Jim Wood Ballot Measure Committee	Deane	Committee to Improve the Quality of Life in California, Assemblymember Jim Wood Ballot Measure Committee
enty_namf	Shawnda	None	Shawnda	None
enty_namt	None	None	None	None
enty_nams	None	None	None	None
enty_city	Sacramento	Sacramento	Sacramento	Sacramento
enty_st	CA	CA	CA	CA
enty_zip4	95815	95815	95815	95815
enty_phon	(916) 285-5733	(916) 285-5733	(916) 285-5733	(916) 285-5733
enty_fax	None	None	None	None
enty_email	None	None	None	None
tres_naml	None	Wood	None	Wood
tres_namf	None	Jim	None	Jim
tres_namt	None	None	None	None
tres_nams	None	None	None	None
control_yn	None	Y	None	Y
office_cd	None	None	None	None
offic_dscr	None	None	None	None
juris_cd	None	None	None	None
juris_dscr	None	None	None	None
dist_no	None	None	None	None
off_s_h_cd	None	None	None	None
bal_name	None	None	None	None
bal_num	None	None	None	None
bal_juris	None	None	None	None
sup_opp_cd	None	None	None	None

Table: cvr3_verification_info
filing_id	2743970	2743970	2743970	2743970
amend_id	0	0	1	1
line_item	1	2	1	2
rec_type	CVR3	CVR3	CVR3	CVR3
form_type	F460	F460	F460	F460
tran_id	VER_1.1	VER_2.2	VER_1.1	VER_2.2
entity_cd	ATR	CAO	ATR	CAO
sig_date	2022-10-26 00:00:00	2022-10-26 00:00:00	2022-11-06 00:00:00	2022-11-06 00:00:00
sig_loc	None	None	None	None
sig_naml	Shawnda Deane	Jim Wood	Shawnda Deane	Jim Wood
sig_namf	None	None	None	None
sig_namt	None	None	None	None
sig_nams	None	None	None	None

Table: cvr_campaign_disclosure
filing_id	2743970	2743970
amend_id	0	1
rec_type	CVR	CVR
form_type	F460	F460
filer_id	1434721	1434721
entity_cd	CTL	CTL
filer_naml	Jim Wood for Assembly 2022	Jim Wood for Assembly 2022
filer_namf	None	None
filer_namt	None	None
filer_nams	None	None
report_num	000	001
rpt_date	2022-10-27 00:00:00	2022-11-06 00:00:00
stmt_type	PE	PE
late_rptno	None	None
from_date	2022-09-25 00:00:00	2022-09-25 00:00:00
thru_date	2022-10-22 00:00:00	2022-10-22 00:00:00
elect_date	2022-11-08 00:00:00	2022-11-08 00:00:00
filer_city	Santa Rosa	Santa Rosa
filer_st	CA	CA
filer_zip4	95409	95409
filer_phon	(707) 321-4637	(707) 321-4637
filer_fax	(916) 333-1344	(916) 333-1344
file_email	Wood2022@deaneandcompany.com	Wood2022@deaneandcompany.com
mail_city	Sacramento	Sacramento
mail_st	CA	CA
mail_zip4	95815	95815
tres_naml	Wood	Wood
tres_namf	Jim	Jim
tres_namt	None	None
tres_nams	None	None
tres_city	Santa Rosa	Santa Rosa
tres_st	CA	CA
tres_zip4	95409	95409
tres_phon	(707) 321-4637	(707) 321-4637
tres_fax	None	None
tres_email	None	None
cmtte_type	C	C
control_yn	Y	Y
sponsor_yn	N	N
primfrm_yn	None	None
brdbase_yn	None	None
amendexp_1	None	Update Summary Page, Sch. F & Sch. G
amendexp_2	None	None
amendexp_3	None	None
rpt_att_cb	None	None
cmtte_id	None	None
reportname	None	None
rptfromdt	None	None
rptthrudt	None	None
emplbus_cb	None	None
bus_name	None	None
bus_city	None	None
bus_st	None	None
bus_zip4	None	None
bus_inter	None	None
busact_cb	None	None
busactvity	None	None
assoc_cb	None	None
assoc_int	None	None
other_cb	None	None
other_int	None	None
cand_naml	Wood	Wood
cand_namf	Jim	Jim
cand_namt	None	None
cand_nams	None	None
cand_city	Santa Rosa	Santa Rosa
cand_st	CA	CA
cand_zip4	95409	95409
cand_phon	(707) 321-4637	(707) 321-4637
cand_fax	None	None
cand_email	None	None
bal_name	None	None
bal_num	None	None
bal_juris	None	None
office_cd	ASM	ASM
offic_dscr	None	None
juris_cd	ASM	ASM
juris_dscr	None	None
dist_no	2	2
off_s_h_cd	H	H
sup_opp_cd	None	None
employer	None	None
occupation	None	None
selfemp_cb	None	None
bal_id	None	None
cand_id	None	None

Table: debt
filing_id	2743970	2743970	2743970	2743970	2743970	2743970	2743970
amend_id	0	0	0	1	1	1	1
line_item	1	2	3	1	2	3	4
rec_type	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT
form_type	F	F	F	F	F	F	F
tran_id	PAY949	PAY995	PAY996	PAY949	PAY995	PAY996	PAY1035
entity_cd	OTH	OTH	OTH	OTH	OTH	OTH	OTH
payee_naml	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Mayacama Golf Club
payee_namf	None	None	None	None	None	None	None
payee_namt	None	None	None	None	None	None	None
payee_nams	None	None	None	None	None	None	None
payee_city	Kennesaw	Kennesaw	Kennesaw	Kennesaw	Kennesaw	Kennesaw	Santa Rosa
payee_st	GA	GA	GA	GA	GA	GA	CA
payee_zip4	30144	30144	30144	30144	30144	30144	95403
beg_bal	1009	0	0	1009	0	0	0
amt_incur	0	340	1700	0	340	2464	8360
amt_paid	0	0	0	0	0	0	0
end_bal	1009	340	1700	1009	340	2464	8360
expn_code	None	None	None	None	None	None	FND
expn_dscr	Credit Card Payment	Credit Card Payment	Credit Card Payment	Credit Card Payment	Credit Card Payment	Credit Card Payment	None
cmte_id	None	None	None	None	None	None	None
tres_naml	None	None	None	None	None	None	None
tres_namf	None	None	None	None	None	None	None
tres_namt	None	None	None	None	None	None	None
tres_nams	None	None	None	None	None	None	None
tres_city	None	None	None	None	None	None	None
tres_st	None	None	None	None	None	None	None
tres_zip4	None	None	None	None	None	None	None
memo_code	None	None	None	None	None	None	None
memo_refno	None	None	None	None	None	None	None
bakref_tid	None	None	None	None	None	None	None
xref_schnm	None	None	None	None	None	None	None
xref_match	None	None	None	None	None	None	None

Table: expn
filing_id	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
line_item	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54
rec_type	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN	EXPN
form_type	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	E	E	E	E	E	E	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	G	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	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
tran_id	EXP951	EXP971	EXP992	EXP963	EXP999	EXP1002	EXP1001	EXP964	EXP1000	EXP973	EXP951	EXP978	EXP979	EXP989	EXP1007	EXP971	EXP992	EXP981	EXP982	EXP963	EXP999	EXP1002	EXP960	EXP986	EXP1001	EXP972	EXP964	EXP958	EXP959	EXP984	EXP985	EXP969	EXP970	EXP1000	PDT341	PDT343	PDT350	PDT342	PDT358	PDT365	PDT369	PDT357	PDT366	PDT354	PDT368	PDT355	PDT345	PDT361	EDT145	EDT148	EDT146	EDT149	EXP951	EXP971	EXP992	EXP963	EXP999	EXP1002	EXP1001	EXP964	EXP1000	EXP973	EXP951	EXP978	EXP979	EXP989	EXP1007	EXP971	EXP992	EXP981	EXP982	EXP963	EXP999	EXP1002	EXP960	EXP986	EXP1001	EXP972	EXP964	EXP958	EXP959	EXP984	EXP985	EXP969	EXP970	EXP1000	PDT341	PDT389	PDT343	PDT350	PDT342	PDT358	PDT365	PDT369	PDT357	PDT373	PDT366	PDT354	PDT368	PDT355	PDT345	PDT361	EDT145	EDT148	EDT146	EDT149
entity_cd	COM	COM	COM	COM	COM	COM	COM	COM	COM	OTH	COM	OTH	OTH	OTH	OTH	COM	COM	OTH	IND	COM	COM	COM	IND	IND	COM	OTH	COM	OTH	OTH	OTH	OTH	IND	IND	COM	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	IND	IND	IND	IND	COM	COM	COM	COM	COM	COM	COM	COM	COM	OTH	COM	OTH	OTH	OTH	OTH	COM	COM	OTH	IND	COM	COM	COM	IND	IND	COM	OTH	COM	OTH	OTH	OTH	OTH	IND	IND	COM	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	IND	IND	IND	IND
payee_naml	Avelino Valencia for Assembly 2022	Democratic Leadership Coalition PAC	Democratic Leadership Coalition PAC	Gail Pellerin for Assembly 2022	Gregg Hart for Assembly 2022	Humboldt County Democratic Central Committee	Pilar Schiavo for Assembly 2022	Self for Assembly 2022	Villescaz for Senate 2022	Authorize.net	Avelino Valencia for Assembly 2022	Deane & Company	Deane & Company	Deane & Company	Deane & Company	Democratic Leadership Coalition PAC	Democratic Leadership Coalition PAC	Foggy Bottom Boys Farm	Friedemann	Gail Pellerin for Assembly 2022	Gregg Hart for Assembly 2022	Humboldt County Democratic Central Committee	Intuit, Inc.	Intuit, Inc.	Pilar Schiavo for Assembly 2022	Pruitt, LLC	Self for Assembly 2022	United States Treasury	United States Treasury	United States Treasury	United States Treasury	Valenzuela	Valenzuela	Villescaz for Senate 2022	Big Mountain Mail	Dierk's Parkside Cafe	Dierk's Parkside Cafe	Double O Mini Storage	Fairmont Grand Del Mar	Golden Harvest Cafe	Golden Harvest Cafe	Los Angeles Times	Pearl Lounge	Residence Inn by Marriott Cypress Los Alamitos	Samoa Cookhouse	The Station Taphouse Bar and Grill	Times Standard	UPS Store	Ramey	Ramey	Tesconi	Tesconi	Avelino Valencia for Assembly 2022	Democratic Leadership Coalition PAC	Democratic Leadership Coalition PAC	Gail Pellerin for Assembly 2022	Gregg Hart for Assembly 2022	Humboldt County Democratic Central Committee	Pilar Schiavo for Assembly 2022	Self for Assembly 2022	Villescaz for Senate 2022	Authorize.net	Avelino Valencia for Assembly 2022	Deane & Company	Deane & Company	Deane & Company	Deane & Company	Democratic Leadership Coalition PAC	Democratic Leadership Coalition PAC	Foggy Bottom Boys Farm	Friedemann	Gail Pellerin for Assembly 2022	Gregg Hart for Assembly 2022	Humboldt County Democratic Central Committee	Intuit, Inc.	Intuit, Inc.	Pilar Schiavo for Assembly 2022	Pruitt, LLC	Self for Assembly 2022	United States Treasury	United States Treasury	United States Treasury	United States Treasury	Valenzuela	Valenzuela	Villescaz for Senate 2022	Big Mountain Mail	Courtyard by Marriott Cypress Anaheim/Orange County	Dierk's Parkside Cafe	Dierk's Parkside Cafe	Double O Mini Storage	Fairmont Grand Del Mar	Golden Harvest Cafe	Golden Harvest Cafe	Los Angeles Times	NationBuilder	Pearl Lounge	Residence Inn by Marriott Cypress Los Alamitos	Samoa Cookhouse	The Station Taphouse Bar and Grill	Times Standard	UPS Store	Ramey	Ramey	Tesconi	Tesconi
payee_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	John	None	None	None	None	None	None	None	None	None	None	None	None	Ruth	Ruth	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Paul	Paul	William B.	William B.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	John	None	None	None	None	None	None	None	None	None	None	None	None	Ruth	Ruth	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Paul	Paul	William B.	William B.
payee_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
payee_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
payee_city	Long Beach	Sacramento	Sacramento	Sacramento	Santa Barbara	Eureka	Chatsworth	Sacramento	Sacramento	American Fork	Long Beach	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Ferndale	Santa Rosa	Sacramento	Santa Barbara	Eureka	Mountain View	Mountain View	Chatsworth	Sacramento	Sacramento	Washington	Washington	Washington	Washington	Ukiah	Ukiah	Sacramento	Salida	Santa Rosa	Santa Rosa	Healdsburg	San Diego	Eureka	Eureka	El Segundo	Eureka	Alamitos	Samoa	Banning	Eureka	Santa Rosa	Brentwood	Brentwood	Santa Rosa	Santa Rosa	Long Beach	Sacramento	Sacramento	Sacramento	Santa Barbara	Eureka	Chatsworth	Sacramento	Sacramento	American Fork	Long Beach	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Ferndale	Santa Rosa	Sacramento	Santa Barbara	Eureka	Mountain View	Mountain View	Chatsworth	Sacramento	Sacramento	Washington	Washington	Washington	Washington	Ukiah	Ukiah	Sacramento	Salida	Cypress	Santa Rosa	Santa Rosa	Healdsburg	San Diego	Eureka	Eureka	El Segundo	Los Angeles	Eureka	Alamitos	Samoa	Banning	Eureka	Santa Rosa	Brentwood	Brentwood	Santa Rosa	Santa Rosa
payee_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	UT	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	DC	DC	DC	DC	CA	CA	CA	CO	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	UT	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	DC	DC	DC	DC	CA	CA	CA	CO	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
payee_zip4	90802	95815	95815	95841	93101	95502	91311	95814	95814	84003	90802	95815	95815	95815	95815	95815	95815	95536	95403	95841	93101	95502	94043	94043	91311	95814	95814	20220	20220	20220	20220	95482	95482	95814	81201	95404	95404	95448	92130	95503	95503	90245	95501	90720	95564	92220	95501	95409	94513	94513	95404	95404	90802	95815	95815	95841	93101	95502	91311	95814	95814	84003	90802	95815	95815	95815	95815	95815	95815	95536	95403	95841	93101	95502	94043	94043	91311	95814	95814	20220	20220	20220	20220	95482	95482	95814	81201	90630	95404	95404	95448	92130	95503	95503	90245	90071	95501	90720	95564	92220	95501	95409	94513	94513	95404	95404
expn_date	2022-09-26 00:00:00	2022-10-06 00:00:00	2022-10-13 00:00:00	2022-10-03 00:00:00	2022-10-18 00:00:00	2022-10-19 00:00:00	2022-10-19 00:00:00	2022-10-03 00:00:00	2022-10-18 00:00:00	2022-10-04 00:00:00	2022-09-26 00:00:00	2022-10-11 00:00:00	2022-10-11 00:00:00	2022-10-13 00:00:00	2022-10-22 00:00:00	2022-10-06 00:00:00	2022-10-13 00:00:00	2022-10-11 00:00:00	2022-10-11 00:00:00	2022-10-03 00:00:00	2022-10-18 00:00:00	2022-10-19 00:00:00	2022-09-30 00:00:00	2022-10-14 00:00:00	2022-10-19 00:00:00	2022-10-07 00:00:00	2022-10-03 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-10-14 00:00:00	2022-10-14 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-18 00:00:00	2022-10-01 00:00:00	2022-10-02 00:00:00	2022-10-08 00:00:00	2022-10-01 00:00:00	2022-10-13 00:00:00	2022-10-17 00:00:00	2022-10-19 00:00:00	2022-10-11 00:00:00	2022-10-18 00:00:00	2022-10-08 00:00:00	2022-10-19 00:00:00	2022-10-09 00:00:00	2022-10-03 00:00:00	2022-10-14 00:00:00	2022-09-30 00:00:00	2022-10-14 00:00:00	2022-09-30 00:00:00	2022-10-14 00:00:00	2022-09-26 00:00:00	2022-10-06 00:00:00	2022-10-13 00:00:00	2022-10-03 00:00:00	2022-10-18 00:00:00	2022-10-19 00:00:00	2022-10-19 00:00:00	2022-10-03 00:00:00	2022-10-18 00:00:00	2022-10-04 00:00:00	2022-09-26 00:00:00	2022-10-11 00:00:00	2022-10-11 00:00:00	2022-10-13 00:00:00	2022-10-22 00:00:00	2022-10-06 00:00:00	2022-10-13 00:00:00	2022-10-11 00:00:00	2022-10-11 00:00:00	2022-10-03 00:00:00	2022-10-18 00:00:00	2022-10-19 00:00:00	2022-09-30 00:00:00	2022-10-14 00:00:00	2022-10-19 00:00:00	2022-10-07 00:00:00	2022-10-03 00:00:00	2022-09-30 00:00:00	2022-09-30 00:00:00	2022-10-14 00:00:00	2022-10-14 00:00:00	2022-10-05 00:00:00	2022-10-05 00:00:00	2022-10-18 00:00:00	2022-10-01 00:00:00	2022-10-22 00:00:00	2022-10-02 00:00:00	2022-10-08 00:00:00	2022-10-01 00:00:00	2022-10-13 00:00:00	2022-10-17 00:00:00	2022-10-19 00:00:00	2022-10-11 00:00:00	2022-10-22 00:00:00	2022-10-18 00:00:00	2022-10-08 00:00:00	2022-10-19 00:00:00	2022-10-09 00:00:00	2022-10-03 00:00:00	2022-10-14 00:00:00	2022-09-30 00:00:00	2022-10-14 00:00:00	2022-09-30 00:00:00	2022-10-14 00:00:00
amount	4900	30000	25000	4900	4900	100	4900	4900	2400	30	4900	75	75	3049	75	30000	25000	240	3750	4900	4900	100	764	764	4900	24720	4900	154	15	154	15	132	157	2400	20	19	48	70	297	52	74	24	254	213	164	382	12	7	231	231	530	530	4900	30000	25000	4900	4900	100	4900	4900	2400	30	4900	75	75	3049	75	30000	25000	240	3750	4900	4900	100	764	764	4900	24720	4900	154	15	154	15	132	157	2400	20	132	19	48	70	297	52	74	24	574	254	213	164	382	12	7	231	231	530	530
cum_ytd	4900	100000	100000	4900	4900	100	4900	4900	4900	300	4900	27821	27821	27821	27821	100000	100000	240	3750	4900	4900	100	14525	14525	4900	69737	4900	3632	3632	3632	3632	289	289	4900	200	437	437	700	297	203	203	120	254	213	164	382	132	158	4387	4387	10272	10272	4900	100000	100000	4900	4900	100	4900	4900	4900	300	4900	27821	27821	27821	27821	100000	100000	240	3750	4900	4900	100	14525	14525	4900	69737	4900	3632	3632	3632	3632	289	289	4900	200	132	437	437	700	297	203	203	120	5365	254	213	164	382	132	158	4387	4387	10272	10272
cum_oth	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
expn_chkno	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
expn_code	MON	MON	MON	MON	MON	MON	MON	MON	MON	OFC	CTB	PRO	PRO	PRO	PRO	CTB	CTB	MTG	FND	CTB	CTB	CTB	SAL	SAL	CTB	FND	CTB	SAL	SAL	SAL	SAL	MTG	MTG	CTB	OFC	OFC	OFC	OFC	TRC	OFC	OFC	OFC	MTG	TRC	MTG	MTG	OFC	POS	SAL	SAL	SAL	SAL	MON	MON	MON	MON	MON	MON	MON	MON	MON	OFC	CTB	PRO	PRO	PRO	PRO	CTB	CTB	MTG	FND	CTB	CTB	CTB	SAL	SAL	CTB	FND	CTB	SAL	SAL	SAL	SAL	MTG	MTG	CTB	OFC	TRC	OFC	OFC	OFC	TRC	OFC	OFC	OFC	WEB	MTG	TRC	MTG	MTG	OFC	POS	SAL	SAL	SAL	SAL
expn_dscr	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	10/4/22, Campaign Staff Meeting, 4 including Candidate	None	None	None	None	None	None	None	None	None	None	None	None	None	9/28/22, Campaign Meeting, 3, including Candidate	9/29/22, Campaign Meeting, 3, including Candidate	None	None	None	None	None	10/10/22-10/12/22, Lodging, Del Mar, CA, Legislative Conference, 1, Candidate	None	None	None	10/18/22, Legislative Meeting, 4, including Candidate	10/08/22-10/09/22, Lodging, Los Alamitos, CA, Legislative Meeting, 1, Candidate	10/19/22, Legislative Meeting, 5, including Candidate	10/9/22, Legislative Meeting, 8, including Candidate	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	10/4/22, Campaign Staff Meeting, 4 including Candidate	None	None	None	None	None	None	None	None	None	None	None	None	None	9/28/22, Campaign Meeting, 3, including Candidate	9/29/22, Campaign Meeting, 3, including Candidate	None	None	10/22/22-10/23/22, Lodging, Cypress, CA, Campaign Travel, 1, Candidate	None	None	None	10/10/22-10/12/22, Lodging, Del Mar, CA, Legislative Conference, 1, Candidate	None	None	None	None	10/18/22, Legislative Meeting, 4, including Candidate	10/08/22-10/09/22, Lodging, Los Alamitos, CA, Legislative Meeting, 1, Candidate	10/19/22, Legislative Meeting, 5, including Candidate	10/9/22, Legislative Meeting, 8, including Candidate	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	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Intuit, Inc.	Intuit, Inc.	Intuit, Inc.	Intuit, Inc.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Card Services Center	Intuit, Inc.	Intuit, Inc.	Intuit, Inc.	Intuit, Inc.
agent_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
agent_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
agent_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cmte_id	None	None	None	None	None	None	None	None	None	None	1446169	None	None	None	None	1449276	1449276	None	None	1445957	1444010	761414	None	None	1438397	None	1442987	None	None	None	None	None	None	1443351	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	1446169	None	None	None	None	1449276	1449276	None	None	1445957	1444010	761414	None	None	1438397	None	1442987	None	None	None	None	None	None	1443351	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_naml	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
tres_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_naml	Avelino Valencia	None	None	Gail Pellerin	Gregg Hart	None	Pilar Schiavo	Jessica Self	Paula Villescaz	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Avelino Valencia	None	None	Gail Pellerin	Gregg Hart	None	Pilar Schiavo	Jessica Self	Paula Villescaz	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
cand_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
office_cd	ASM	None	None	ASM	ASM	None	ASM	ASM	SEN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	ASM	None	None	ASM	ASM	None	ASM	ASM	SEN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None
juris_cd	ASM	None	None	ASM	ASM	None	ASM	ASM	SEN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	ASM	None	None	ASM	ASM	None	ASM	ASM	SEN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None
dist_no	68	None	None	28	37	None	40	22	6	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	68	None	None	28	37	None	40	22	6	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
off_s_h_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_name	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_num	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bal_juris	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sup_opp_cd	S	S	S	S	S	S	S	S	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	S	S	S	S	S	S	S	S	S	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None
memo_refno	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
bakref_tid	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	E	E	E	E	F	F	F	F	F	F	F	F	E	F	E	E	E	E	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E
xref_schnm	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
xref_match	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: filer_filings
filer_id	1434721	1434721
filing_id	2743970	2743970
period_id	251	251
form_id	F460	F460
filing_sequence	0	1
filing_date	2022-10-27 00:00:00	2022-11-07 00:00:00
stmnt_type	10001	10002
stmnt_status	11003	11003
session_id	2021	2021
user_id	CAFILER	CAFILER
special_audit	11003	11003
fine_audit	11003	11003
rpt_start	2022-09-25 00:00:00	2022-09-25 00:00:00
rpt_end	2022-10-22 00:00:00	2022-10-22 00:00:00
rpt_date	2022-10-27 00:00:00	2022-11-06 00:00:00
filing_type	22001	22001

Table: filings
filing_id		2743970
filing_type		22001

Table: hdr
filing_id	2743970	2743970
amend_id	0	1
rec_type	HDR	HDR
ef_type	CAL	CAL
state_cd	CA	CA
cal_ver	2.01	2.01
soft_name	NETFILE	NETFILE
soft_ver	2022451	2022451
hdrcomment	None	None

Table: rcpt
filing_id	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970
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	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
line_item	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	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
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
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	I	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	I
tran_id	INC976	INC988	INC980	INC962	INC987	INC961	INC974	INC1003	INC1012	INC983	INC954	INC956	INC957	INC1013	INC968	INC966	INC1005	INC1006	INC998	INC967	INC975	INC994	INC965	INC997	INC977	INC1004	INC993	INC976	INC988	INC980	INC962	INC987	INC961	INC974	INC1003	INC1012	INC983	INC954	INC956	INC957	INC1013	INC968	INC966	INC1005	INC1006	INC998	INC967	INC975	INC994	INC965	INC997	INC977	INC1004	INC993
entity_cd	OTH	COM	COM	OTH	OTH	COM	SCC	COM	COM	SCC	COM	SCC	OTH	OTH	OTH	OTH	COM	SCC	OTH	SCC	OTH	COM	SCC	OTH	COM	COM	OTH	OTH	COM	COM	OTH	OTH	COM	SCC	COM	COM	SCC	COM	SCC	OTH	OTH	OTH	OTH	COM	SCC	OTH	SCC	OTH	COM	SCC	OTH	COM	COM	OTH
ctrib_naml	Amazon.com Services, LLC	American Property Casualty Insurance Association California PAC	Association of California State Supervisors PAC	AstraZeneca Pharmaceuticals, LP	Barona Band of Mission Indians	California Chiropractic Association PAC	California Federation of Teachers COPE Small Contributor Committee	California New Car Dealers Association PAC	California Sierra Club PAC	California State Association of Electrical Workers Small Contributor Committee	California Statewide Law Enforcement Association PAC	California Teachers Association/Association for Better Citizenship Small Contributor Committee	Ford Motor Company Civic Action Fund Federal Community	James F. Demartini Attorny at Law	Meta Platforms, Inc.	Namic Administrative Fund	National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy	Operating Engineers Local No. 3 Statewide PAC Small Contributor Committee	Pacific Ultrapower Chinese Station	Peace Officers Research Association of California PAC (PORAC PAC) Small Contributor Committee	Pechanga Band of Indians	Philips North America LLC PAC (FED PAC ID#C00239780)	Professional Engineers in California Government PECG-PAC Small Contributor Committee	Rio Bravo Rocklin	TROUT PAC	United Domestic Workers of America Action Fund Independent Expenditure PAC	First Foundation Bank	Amazon.com Services, LLC	American Property Casualty Insurance Association California PAC	Association of California State Supervisors PAC	AstraZeneca Pharmaceuticals, LP	Barona Band of Mission Indians	California Chiropractic Association PAC	California Federation of Teachers COPE Small Contributor Committee	California New Car Dealers Association PAC	California Sierra Club PAC	California State Association of Electrical Workers Small Contributor Committee	California Statewide Law Enforcement Association PAC	California Teachers Association/Association for Better Citizenship Small Contributor Committee	Ford Motor Company Civic Action Fund Federal Community	James F. Demartini Attorny at Law	Meta Platforms, Inc.	Namic Administrative Fund	National Union of Healthcare Workers Candidate Committee for Quality Patient Care and Union Democracy	Operating Engineers Local No. 3 Statewide PAC Small Contributor Committee	Pacific Ultrapower Chinese Station	Peace Officers Research Association of California PAC (PORAC PAC) Small Contributor Committee	Pechanga Band of Indians	Philips North America LLC PAC (FED PAC ID#C00239780)	Professional Engineers in California Government PECG-PAC Small Contributor Committee	Rio Bravo Rocklin	TROUT PAC	United Domestic Workers of America Action Fund Independent Expenditure PAC	First Foundation Bank
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	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	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
ctrib_city	Seattle	Chicago	Sacramento	Wilmington	Lakeside	Sacramento	Sacramento	Sacramento	Los Angeles	Pasadena	Sacramento	Burlingame	Dearborn	Cloverdale	Menlo Park	Indianapolis	Sacramento	Alameda	Aliso Viejo	Sacramento	Temecula	Washington	Sacramento	Aliso Viejo	Sacramento	Sacramento	Irvine	Seattle	Chicago	Sacramento	Wilmington	Lakeside	Sacramento	Sacramento	Sacramento	Los Angeles	Pasadena	Sacramento	Burlingame	Dearborn	Cloverdale	Menlo Park	Indianapolis	Sacramento	Alameda	Aliso Viejo	Sacramento	Temecula	Washington	Sacramento	Aliso Viejo	Sacramento	Sacramento	Irvine
ctrib_st	WA	IL	CA	DE	CA	CA	CA	CA	CA	CA	CA	CA	MI	CA	CA	IN	CA	CA	CA	CA	CA	DC	CA	CA	CA	CA	CA	WA	IL	CA	DE	CA	CA	CA	CA	CA	CA	CA	CA	MI	CA	CA	IN	CA	CA	CA	CA	CA	DC	CA	CA	CA	CA	CA
ctrib_zip4	98109	60631	95814	19850	92040	95814	95814	95814	90010	91101	95814	94010	48126	95425	94025	46268	95815	94502	92656	95834	92592	20005	95814	92656	95814	95814	92612	98109	60631	95814	19850	92040	95814	95814	95814	90010	91101	95814	94010	48126	95425	94025	46268	95815	94502	92656	95834	92592	20005	95814	92656	95814	95814	92612
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	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	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	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
rcpt_date	2022-10-07 00:00:00	2022-10-12 00:00:00	2022-10-10 00:00:00	2022-09-30 00:00:00	2022-10-12 00:00:00	2022-09-28 00:00:00	2022-10-07 00:00:00	2022-10-20 00:00:00	2022-10-20 00:00:00	2022-10-11 00:00:00	2022-09-26 00:00:00	2022-09-26 00:00:00	2022-09-27 00:00:00	2022-10-20 00:00:00	2022-10-04 00:00:00	2022-09-27 00:00:00	2022-10-20 00:00:00	2022-10-20 00:00:00	2022-10-17 00:00:00	2022-10-04 00:00:00	2022-10-07 00:00:00	2022-10-14 00:00:00	2022-10-03 00:00:00	2022-10-17 00:00:00	2022-10-07 00:00:00	2022-10-20 00:00:00	2022-09-30 00:00:00	2022-10-07 00:00:00	2022-10-12 00:00:00	2022-10-10 00:00:00	2022-09-30 00:00:00	2022-10-12 00:00:00	2022-09-28 00:00:00	2022-10-07 00:00:00	2022-10-20 00:00:00	2022-10-20 00:00:00	2022-10-11 00:00:00	2022-09-26 00:00:00	2022-09-26 00:00:00	2022-09-27 00:00:00	2022-10-20 00:00:00	2022-10-04 00:00:00	2022-09-27 00:00:00	2022-10-20 00:00:00	2022-10-20 00:00:00	2022-10-17 00:00:00	2022-10-04 00:00:00	2022-10-07 00:00:00	2022-10-14 00:00:00	2022-10-03 00:00:00	2022-10-17 00:00:00	2022-10-07 00:00:00	2022-10-20 00:00:00	2022-09-30 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
amount	4900	4900	1500	2000	1500	2000	1500	1000	100	5000	2000	9700	2500	500	2000	500	4900	4900	1750	3000	2400	1500	1500	1750	4000	2000	54	4900	4900	1500	2000	1500	2000	1500	1000	100	5000	2000	9700	2500	500	2000	500	4900	4900	1750	3000	2400	1500	1500	1750	4000	2000	54
cum_ytd	0	1900	0	0	1500	0	0	0	0	0	0	9700	0	0	0	0	4900	0	0	0	0	0	1000	0	0	0	0	4900	6800	1500	2000	3000	2000	1500	1000	100	5000	2000	19400	2500	500	2000	500	9800	4900	3500	6000	2400	1500	3500	3500	4000	2000	0
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
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	Interest Earned	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Interest Earned
cmte_id	None	830078	1303937	None	None	742986	741857	741623	1399719	743107	970375	741941	C00046474	None	None	None	1318200	981697	None	810830	None	1367728	822501	None	861445	1367550	None	None	830078	1303937	None	None	742986	741857	741623	1399719	743107	970375	741941	C00046474	None	None	None	1318200	981697	None	810830	None	1367728	822501	None	861445	1367550	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
memo_refno	INC976	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	INC976	None	None	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
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
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
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
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

Table: smry
filing_id	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970
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	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
line_item	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	22A	22B	1	2	3	1	2	3	1	2	3	1	2	3	1	2	3	4	1	2	3	1	2	3	1	2	3	4	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	22A	22B	1	2	3	1	2	3	1	2	3	1	2	3	1	2	3	4	1	2	3	1	2	3	1	2	3	4
rec_type	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY
form_type	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	A	A	A	B1	B1	B1	C	C	C	D	D	D	E	E	E	E	F	F	F	H	H	H	I	I	I	I	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	A	A	A	B1	B1	B1	C	C	C	D	D	D	E	E	E	E	F	F	F	H	H	H	I	I	I	I
amount_a	69350	0	69350	0	69350	116248	0	116248	2040	0	118288	468913	69350	54	116248	422070	0	0	3050	78058	225168	69300	50	69350	0	0	0	0	0	0	82000	0	82000	116171	77	0	116248	2040	0	2040	0	0	0	54	0	0	54	69350	0	69350	0	69350	116248	0	116248	11164	0	127412	468913	69350	54	116248	422070	0	0	12174	87182	225168	69300	50	69350	0	0	0	0	0	0	82000	0	82000	116171	77	0	116248	11164	0	11164	0	0	0	54	0	0	54
amount_b	436658	0	436658	4750	441408	484300	0	484300	3050	4750	492099	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	436658	0	436658	4750	441408	484300	0	484300	12174	4750	501223	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
amount_c	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	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	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	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970	2743970
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	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
line_item	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	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
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	D	D	D	D	D	D	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	D	D	D	D	D	D
ptran_id	INC976	INC976	INC988	INC988	INC980	INC962	INC962	INC987	INC987	INC961	INC961	INC974	INC974	INC1003	INC1003	INC1012	INC983	INC954	INC956	INC956	INC957	INC1013	INC968	INC966	INC1005	INC1005	INC1006	INC1006	INC998	INC998	INC967	INC967	INC975	INC994	INC965	INC965	INC997	INC997	INC977	INC1004	EXP951	EXP963	EXP999	EXP1001	EXP964	EXP1000	INC976	INC976	INC988	INC988	INC980	INC962	INC962	INC987	INC987	INC961	INC961	INC974	INC974	INC1003	INC1003	INC1012	INC983	INC954	INC956	INC956	INC957	INC1013	INC968	INC966	INC1005	INC1005	INC1006	INC1006	INC998	INC998	INC967	INC967	INC975	INC994	INC965	INC965	INC997	INC997	INC977	INC1004	EXP951	EXP963	EXP999	EXP1001	EXP964	EXP1000
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
elec_amount	2500	4900	4900	4900	1500	2500	2000	1500	1500	1500	2000	1500	1500	2500	1000	100	5000	2000	9700	9700	2500	500	2000	500	4900	4900	4900	4900	3500	3500	9700	6000	2400	1500	5000	2500	3500	3500	4000	2000	4900	4900	4900	4900	4900	4900	2500	4900	4900	4900	1500	2500	2000	1500	1500	1500	2000	1500	1500	2500	1000	100	5000	2000	9700	9700	2500	500	2000	500	4900	4900	4900	4900	3500	3500	9700	6000	2400	1500	5000	2500	3500	3500	4000	2000	4900	4900	4900	4900	4900	4900
elec_code	P	G	P	G	G	P	G	P	G	P	G	P	G	P	G	G	G	G	P	G	G	G	G	G	P	G	P	G	P	G	P	G	G	G	P	G	P	G	G	G	G	G	G	G	G	G	P	G	P	G	G	P	G	P	G	P	G	P	G	P	G	G	G	G	P	G	G	G	G	G	P	G	P	G	P	G	P	G	G	G	P	G	P	G	G	G	G	G	G	G	G	G