OpenCalAccess

Filing ID: 2724272

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

Table: cvr3_verification_info
filing_id	2724272	2724272	2724272	2724272
amend_id	1	1	0	0
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	TRE	CAO	TRE	CAO
sig_date	2022-10-25 00:00:00	2022-10-25 00:00:00	2022-09-27 00:00:00	2022-09-27 00:00:00
sig_loc	None	None	None	None
sig_naml	James R. Santos	Kevin McCarty	James R. Santos	Kevin McCarty
sig_namf	None	None	None	None
sig_namt	None	None	None	None
sig_nams	None	None	None	None

Table: cvr_campaign_disclosure
filing_id	2724272	2724272
amend_id	0	1
rec_type	CVR	CVR
form_type	F460	F460
filer_id	1435556	1435556
entity_cd	CTL	CTL
filer_naml	Kevin McCarty for Assembly 2022	Kevin McCarty for Assembly 2022
filer_namf	None	None
filer_namt	None	None
filer_nams	None	None
report_num	000	001
rpt_date	2022-09-27 00:00:00	2022-10-25 00:00:00
stmt_type	PE	PE
late_rptno	None	None
from_date	2022-07-01 00:00:00	2022-07-01 00:00:00
thru_date	2022-09-24 00:00:00	2022-09-24 00:00:00
elect_date	2022-11-08 00:00:00	2022-11-08 00:00:00
filer_city	Sacramento	Sacramento
filer_st	CA	CA
filer_zip4	95864	95864
filer_phon	916-486-9399	916-486-9399
filer_fax	916-486-9398	916-486-9398
file_email	jrshms@surewest.net	jrshms@surewest.net
mail_city	None	None
mail_st	None	None
mail_zip4	None	None
tres_naml	Santos	Santos
tres_namf	James	James
tres_namt	None	None
tres_nams	None	None
tres_city	Sacramento	Sacramento
tres_st	CA	CA
tres_zip4	95864	95864
tres_phon	916-486-9399	916-486-9399
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	Amend for Add. Contributions, Add. Exps. & Accrued. Update Summary Page.
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	McCarty	McCarty
cand_namf	Kevin	Kevin
cand_namt	None	None
cand_nams	None	None
cand_city	Sacramento	Sacramento
cand_st	CA	CA
cand_zip4	95816	95816
cand_phon	916-719-1886	916-719-1886
cand_fax	None	None
cand_email	kevinmccarty95816@icloud.com	kevinmccarty95816@icloud.com
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	6	6
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	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272
amend_id	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	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	1	2	3	4	5	6	7	8	9	10	11	12	13
rec_type	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT	DEBT
form_type	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F	F
tran_id	PAY644	PAY662	PAY725	PAY750	PAY659	PAY681	PAY761	PAY649	PAY650	PAY651	PAY726	PAY727	PAY728	PAY729	PAY799	PAY724	PAY791	PAY644	PAY662	PAY725	PAY659	PAY681	PAY649	PAY650	PAY651	PAY726	PAY727	PAY728	PAY729	PAY724
entity_cd	IND	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	IND	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH
payee_naml	Alvarez	Bertolina & Barnato, Inc.	Bertolina & Barnato, Inc.	Bertolina & Barnato, Inc.	CA Bank & Trust Bankcard Center	CA Bank & Trust Bankcard Center	CA Bank & Trust Bankcard Center	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	Olson Remcho, LLP	Olson Remcho, LLP	Alvarez	Bertolina & Barnato, Inc.	Bertolina & Barnato, Inc.	CA Bank & Trust Bankcard Center	CA Bank & Trust Bankcard Center	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	Olson Remcho, LLP
payee_namf	Maria	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Maria	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
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
payee_city	Sacramento	Sacramento	Sacramento	Sacramento	Los Angeles	Los Angeles	Los Angeles	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Los Angeles	Los Angeles	Sacramento	Sacramento	Sacramento	Sacramento	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
payee_zip4	95818	95814	95814	95814	90071	90071	90071	95864	95864	95864	95864	95864	95864	95864	95864	95814-4503	95814-4503	95818	95814	95814	90071	90071	95864	95864	95864	95864	95864	95864	95864	95814-4503
beg_bal	286	2500	0	0	1177	64	0	3406	80	27	0	0	0	0	0	0	0	286	2500	0	1177	64	3406	80	27	0	0	0	0	0
amt_incur	0	0	2500	2000	0	0	1417	0	0	0	2880	197	10	512	2116	7170	354	0	0	2500	0	0	0	0	0	2880	197	10	512	7170
amt_paid	286	2500	0	0	1177	64	0	3406	80	27	0	0	0	0	0	0	0	286	2500	0	1177	64	3406	80	27	0	0	0	0	0
end_bal	0	0	2500	2000	0	0	1417	0	0	0	2880	197	10	512	2116	7170	354	0	0	2500	0	0	0	0	0	2880	197	10	512	7170
expn_code	None	CNS	CNS	CNS	None	None	None	PRO	POS	LIT	PRO	POS	LIT	OFC	PRO	PRO	PRO	None	CNS	CNS	None	None	PRO	POS	LIT	PRO	POS	LIT	OFC	PRO
expn_dscr	6-29-2022; Food & Beverages for Staff Event; (G)	None	None	None	See Sch G for Credit Card Payees	No Credit Card Payees for Sch G	See Sch. G for Credit Card Payees	None	None	None	None	None	None	None	None	None	None	6-29-2022; Food & Beverages for Staff Event; (G)	None	None	See Sch G for Credit Card Payees	No Credit Card Payees for Sch G	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
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
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
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
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
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
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
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
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
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
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
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
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

Table: expn
filing_id	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272
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	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	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
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
form_type	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	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	G	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	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	E	G
tran_id	EXP718	EXP689	EXP691	EXP696	EXP704	EXP692	EXP688	EXP690	EXP671	EXP678	EXP700	EXP723	EXP716	EXP730	EXP645	EXP668	EXP669	EXP679	EXP680	EXP711	EXP712	EXP665	EXP663	EXP677	EXP718	EXP689	EXP660	EXP684	EXP682	EXP703	EXP691	EXP648	EXP706	EXP696	EXP704	EXP652	EXP654	EXP656	EXP685	EXP686	EXP687	EXP675	EXP694	EXP705	EXP714	EXP676	EXP692	EXP688	EXP690	EXP647	PDT43	EXP718	EXP689	EXP691	EXP696	EXP704	EXP692	EXP688	EXP690	EXP671	EXP678	EXP700	EXP723	EXP716	EXP730	EXP746	EXP645	EXP668	EXP669	EXP679	EXP680	EXP711	EXP712	EXP665	EXP663	EXP677	EXP718	EXP689	EXP660	EXP684	EXP682	EXP703	EXP691	EXP648	EXP706	EXP696	EXP704	EXP652	EXP654	EXP656	EXP685	EXP686	EXP687	EXP675	EXP694	EXP705	EXP714	EXP676	EXP692	EXP688	EXP690	EXP647	PDT43
entity_cd	COM	COM	COM	COM	COM	COM	COM	COM	OTH	OTH	OTH	OTH	OTH	OTH	IND	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	COM	COM	OTH	OTH	OTH	OTH	COM	IND	IND	COM	COM	OTH	OTH	OTH	OTH	OTH	OTH	IND	IND	IND	IND	OTH	COM	COM	COM	IND	OTH	COM	COM	COM	COM	COM	COM	COM	COM	OTH	OTH	OTH	OTH	OTH	OTH	OTH	IND	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	OTH	COM	COM	OTH	OTH	OTH	OTH	COM	IND	IND	COM	COM	OTH	OTH	OTH	OTH	OTH	OTH	IND	IND	IND	IND	OTH	COM	COM	COM	IND	OTH
payee_naml	Blanca Pacheco for Assembly 2022	Brian Maienschein for Assembly 2020	Christy Holstege for Assembly 2022	David Alvarez for Assembly 2022 Special Election	DCCC--Democratic Congressional Campaign Committee	Pilar Schiavo for Assembly 2022	Re-Elect Ken Cooley for Assembly 2022	Soria for Assembly 2022	Acosta Consulting	Acosta Consulting	Acosta Consulting	Acosta Consulting	ActBlue Technical Services	ActBlue Technical Services	Alvarez	AMW Consulting	AMW Consulting	AMW Consulting	AMW Consulting	AMW Consulting	AMW Consulting	Bertolina & Barnato, Inc.	Bertolina & Barnato, Inc.	Bertolina & Barnato, Inc.	Blanca Pacheco for Assembly 2022	Brian Maienschein for Assembly 2020	CA Bank & Trust Bankcard Center	CA Bank & Trust Bankcard Center	CA Bank & Trust Bankcard Center	CA Bank & Trust Bankcard Center	Christy Holstege for Assembly 2022	Cooperman	Cooperman	David Alvarez for Assembly 2022 Special Election	DCCC--Democratic Congressional Campaign Committee	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	Lawrence	Lawrence	Lawrence	Lawrence	Olson Remcho, LLP	Pilar Schiavo for Assembly 2022	Re-Elect Ken Cooley for Assembly 2022	Soria for Assembly 2022	Soto	Netfile	Blanca Pacheco for Assembly 2022	Brian Maienschein for Assembly 2020	Christy Holstege for Assembly 2022	David Alvarez for Assembly 2022 Special Election	DCCC--Democratic Congressional Campaign Committee	Pilar Schiavo for Assembly 2022	Re-Elect Ken Cooley for Assembly 2022	Soria for Assembly 2022	Acosta Consulting	Acosta Consulting	Acosta Consulting	Acosta Consulting	ActBlue Technical Services	ActBlue Technical Services	ActBlue Technical Services	Alvarez	AMW Consulting	AMW Consulting	AMW Consulting	AMW Consulting	AMW Consulting	AMW Consulting	Bertolina & Barnato, Inc.	Bertolina & Barnato, Inc.	Bertolina & Barnato, Inc.	Blanca Pacheco for Assembly 2022	Brian Maienschein for Assembly 2020	CA Bank & Trust Bankcard Center	CA Bank & Trust Bankcard Center	CA Bank & Trust Bankcard Center	CA Bank & Trust Bankcard Center	Christy Holstege for Assembly 2022	Cooperman	Cooperman	David Alvarez for Assembly 2022 Special Election	DCCC--Democratic Congressional Campaign Committee	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	James R. Santos Bookkeeping Services	Lawrence	Lawrence	Lawrence	Lawrence	Olson Remcho, LLP	Pilar Schiavo for Assembly 2022	Re-Elect Ken Cooley for Assembly 2022	Soria for Assembly 2022	Soto	Netfile
payee_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Maria	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Rachel	Rachel	None	None	None	None	None	None	None	None	Jessica	Jessica	Jessica	Jessica	None	None	None	None	Delaney	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Maria	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Rachel	Rachel	None	None	None	None	None	None	None	None	Jessica	Jessica	Jessica	Jessica	None	None	None	None	Delaney	None
payee_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
payee_city	Sacramento	La Mesa	Sacramento	Sacramento	Washington	Chatsworth	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Somerville	Somerville	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	La Mesa	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Sacramento	West Sacramento	West Sacramento	Sacramento	Washington	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Citrus Heights	Citrus Heights	Citrus Heights	Citrus Heights	Sacramento	Chatsworth	Sacramento	Sacramento	Sacramento	Mariposa	Sacramento	La Mesa	Sacramento	Sacramento	Washington	Chatsworth	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Somerville	Somerville	Somerville	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	La Mesa	Los Angeles	Los Angeles	Los Angeles	Los Angeles	Sacramento	West Sacramento	West Sacramento	Sacramento	Washington	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Citrus Heights	Citrus Heights	Citrus Heights	Citrus Heights	Sacramento	Chatsworth	Sacramento	Sacramento	Sacramento	Mariposa
payee_st	CA	CA	CA	CA	DC	CA	CA	CA	CA	CA	CA	CA	MA	MA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	DC	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	DC	CA	CA	CA	CA	CA	CA	CA	MA	MA	MA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	DC	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
payee_zip4	95814	91942	95815	95814	20003	91311	95815	95815	95822	95822	95822	95822	02144-3132	02144-3132	95818	95816	95816	95816	95816	95816	95816	95814	95814	95814	95814	91942	90071	90071	90071	90071	95815	95691	95691	95814	20003	95864	95864	95864	95864	95864	95864	95621	95621	95621	95621	95814-4503	91311	95815	95815	95825	95338	95814	91942	95815	95814	20003	91311	95815	95815	95822	95822	95822	95822	02144-3132	02144-3132	02144-3132	95818	95816	95816	95816	95816	95816	95816	95814	95814	95814	95814	91942	90071	90071	90071	90071	95815	95691	95691	95814	20003	95864	95864	95864	95864	95864	95864	95621	95621	95621	95621	95814-4503	91311	95815	95815	95825	95338
expn_date	2022-09-20 00:00:00	2022-08-11 00:00:00	2022-08-11 00:00:00	2022-08-18 00:00:00	2022-09-06 00:00:00	2022-08-11 00:00:00	2022-08-11 00:00:00	2022-08-11 00:00:00	2022-07-26 00:00:00	2022-08-09 00:00:00	2022-08-22 00:00:00	2022-09-23 00:00:00	2022-09-11 00:00:00	2022-09-18 00:00:00	2022-07-02 00:00:00	2022-07-22 00:00:00	2022-07-22 00:00:00	2022-08-09 00:00:00	2022-08-09 00:00:00	2022-09-08 00:00:00	2022-09-08 00:00:00	2022-07-12 00:00:00	2022-07-12 00:00:00	2022-08-09 00:00:00	2022-09-20 00:00:00	2022-08-11 00:00:00	2022-07-11 00:00:00	2022-08-09 00:00:00	2022-08-09 00:00:00	2022-09-06 00:00:00	2022-08-11 00:00:00	2022-07-11 00:00:00	2022-09-06 00:00:00	2022-08-18 00:00:00	2022-09-06 00:00:00	2022-07-11 00:00:00	2022-07-11 00:00:00	2022-07-11 00:00:00	2022-08-09 00:00:00	2022-08-09 00:00:00	2022-08-09 00:00:00	2022-08-08 00:00:00	2022-08-17 00:00:00	2022-09-06 00:00:00	2022-09-09 00:00:00	2022-08-09 00:00:00	2022-08-11 00:00:00	2022-08-11 00:00:00	2022-08-11 00:00:00	2022-07-07 00:00:00	2022-08-31 00:00:00	2022-09-20 00:00:00	2022-08-11 00:00:00	2022-08-11 00:00:00	2022-08-18 00:00:00	2022-09-06 00:00:00	2022-08-11 00:00:00	2022-08-11 00:00:00	2022-08-11 00:00:00	2022-07-26 00:00:00	2022-08-09 00:00:00	2022-08-22 00:00:00	2022-09-23 00:00:00	2022-09-11 00:00:00	2022-09-18 00:00:00	2022-09-24 00:00:00	2022-07-02 00:00:00	2022-07-22 00:00:00	2022-07-22 00:00:00	2022-08-09 00:00:00	2022-08-09 00:00:00	2022-09-08 00:00:00	2022-09-08 00:00:00	2022-07-12 00:00:00	2022-07-12 00:00:00	2022-08-09 00:00:00	2022-09-20 00:00:00	2022-08-11 00:00:00	2022-07-11 00:00:00	2022-08-09 00:00:00	2022-08-09 00:00:00	2022-09-06 00:00:00	2022-08-11 00:00:00	2022-07-11 00:00:00	2022-09-06 00:00:00	2022-08-18 00:00:00	2022-09-06 00:00:00	2022-07-11 00:00:00	2022-07-11 00:00:00	2022-07-11 00:00:00	2022-08-09 00:00:00	2022-08-09 00:00:00	2022-08-09 00:00:00	2022-08-08 00:00:00	2022-08-17 00:00:00	2022-09-06 00:00:00	2022-09-09 00:00:00	2022-08-09 00:00:00	2022-08-11 00:00:00	2022-08-11 00:00:00	2022-08-11 00:00:00	2022-07-07 00:00:00	2022-08-31 00:00:00
amount	4900	4900	4900	2500	500	4900	4900	4900	1000	1000	1000	1000	59	20	286	1000	63	1000	63	1000	63	2500	2500	2500	4900	4900	1177	820	64	1819	4900	133	80	2500	500	27	80	3406	2626	77	33	147	63	118	63	1081	4900	4900	4900	405	512	4900	4900	4900	2500	500	4900	4900	4900	1000	1000	1000	1000	59	20	118	286	1000	63	1000	63	1000	63	2500	2500	2500	4900	4900	1177	820	64	1819	4900	133	80	2500	500	27	80	3406	2626	77	33	147	63	118	63	1081	4900	4900	4900	405	512
cum_ytd	4900	4900	4900	2500	500	4900	4900	4900	160168	160168	160168	160168	2461	2461	286	9955	9955	9955	9955	9955	9955	23080	23080	23080	4900	4900	45177	45177	45177	45177	4900	262	262	2500	500	29094	29094	29094	29094	29094	29094	520	520	520	520	8251	4900	4900	4900	405	512	4900	4900	4900	2500	500	4900	4900	4900	160168	160168	160168	160168	2579	2579	2579	286	9955	9955	9955	9955	9955	9955	25080	25080	25080	4900	4900	46594	46594	46594	46594	4900	262	262	2500	500	31211	31211	31211	31211	31211	31211	520	520	520	520	8605	4900	4900	4900	405	512
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
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
expn_code	MON	MON	MON	MON	MON	MON	MON	MON	CNS	CNS	CNS	CNS	OFC	OFC	None	CNS	LIT	CNS	LIT	CNS	LIT	CNS	CNS	CNS	CTB	CTB	None	None	None	None	CTB	None	None	CTB	CTB	LIT	POS	PRO	PRO	POS	LIT	None	OFC	None	OFC	LEG	CTB	CTB	CTB	None	OFC	MON	MON	MON	MON	MON	MON	MON	MON	CNS	CNS	CNS	CNS	OFC	OFC	OFC	None	CNS	LIT	CNS	LIT	CNS	LIT	CNS	CNS	CNS	CTB	CTB	None	None	None	None	CTB	None	None	CTB	CTB	LIT	POS	PRO	PRO	POS	LIT	None	OFC	None	OFC	LEG	CTB	CTB	CTB	None	OFC
expn_dscr	None	None	None	Debt. Retirement	None	None	None	None	None	None	None	None	None	None	6-29-2022; Food & Beverages for Staff Event; (G)	None	None	None	None	None	None	None	None	None	None	None	See Sch G for Credit Card Payees	See Sch G for Credit Card Payees	No Credit Card Payees for Sch G	See Sch G for Credit Card Payees	None	Dry Ice for CGNA Family Night Out; (P)	Chalk for the Chalk It Up Event; (P)	Debt. Retirement	None	None	None	None	None	None	None	Refreshments and Snacks for Softball Game; (G)	None	09-01-2022; End of Session Brunch for Legislative Staff; (P)	None	None	None	None	None	7-4-2022; Popsicles, Donuts, Ice, Rubber Gloves, & Dry Ice for Paletas at the 4th of July Parade; (P)	None	None	None	None	Debt. Retirement	None	None	None	None	None	None	None	None	None	None	None	6-29-2022; Food & Beverages for Staff Event; (G)	None	None	None	None	None	None	None	None	None	None	None	See Sch G for Credit Card Payees	See Sch G for Credit Card Payees	No Credit Card Payees for Sch G	See Sch G for Credit Card Payees	None	Dry Ice for CGNA Family Night Out; (P)	Chalk for the Chalk It Up Event; (P)	Debt. Retirement	None	None	None	None	None	None	None	Refreshments and Snacks for Softball Game; (G)	None	09-01-2022; End of Session Brunch for Legislative Staff; (P)	None	None	None	None	None	7-4-2022; Popsicles, Donuts, Ice, Rubber Gloves, & Dry Ice for Paletas at the 4th of July Parade; (P)	None
agent_naml	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	James R. Santos Bookkeeping Services	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	James R. Santos Bookkeeping Services
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
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
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
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	1443511	1414261	None	None	None	None	1439961	None	None	1443832	C00000935	None	None	None	None	None	None	None	None	None	None	None	1438397	1435371	1443835	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	1443511	1414261	None	None	None	None	1439961	None	None	1443832	C00000935	None	None	None	None	None	None	None	None	None	None	None	1438397	1435371	1443835	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
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
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
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
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
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
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
cand_naml	Blanca Pacheco	Brian Maienschein	Christy Holstege	David Alvarez	DCCC--Democratic Congressional Campaign Committee	Pilar Schiavo	Ken Cooley	Esmeralda Soria	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Blanca Pacheco	Brian Maienschein	Christy Holstege	David Alvarez	DCCC--Democratic Congressional Campaign Committee	Pilar Schiavo	Ken Cooley	Esmeralda Soria	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
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
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
office_cd	ASM	ASM	ASM	ASM	None	ASM	ASM	ASM	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	ASM	ASM	ASM	None	ASM	ASM	ASM	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
juris_cd	ASM	ASM	ASM	ASM	None	ASM	ASM	ASM	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	ASM	ASM	ASM	None	ASM	ASM	ASM	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
dist_no	64	76	47	80	None	40	7	27	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	64	76	47	80	None	40	7	27	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	H	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	H	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
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
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
sup_opp_cd	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
memo_refno	None	None	None	EXP696	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	EXP696	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	EXP696	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	EXP696	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
g_from_e_f	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	F	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	F
xref_schnm	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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

Table: filer_filings
filer_id	1435556	1435556
filing_id	2724272	2724272
period_id	251	251
form_id	F460	F460
filing_sequence	0	1
filing_date	2022-09-27 00:00:00	2022-10-25 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-07-01 00:00:00	2022-07-01 00:00:00
rpt_end	2022-09-24 00:00:00	2022-09-24 00:00:00
rpt_date	2022-09-27 00:00:00	2022-10-25 00:00:00
filing_type	22001	22001

Table: filings
filing_id		2724272
filing_type		22001

Table: hdr
filing_id	2724272	2724272
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	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272
amend_id	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	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	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22
rec_type	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	RCPT	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	C	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	A	C
tran_id	INC708	INC710	IDT146	IDT137	IDT145	INC695	INC667	INC670	INC672	INC722	EXP674	INC673	INC701	IDT138	IDT140	IDT139	IDT141	IDT144	INC697	INC693	INC736	INC702	INC699	INC698	INC735	INC709	IDT136	NON715	INC708	INC710	INC719	IDT137	INC695	INC667	INC670	INC672	INC722	EXP674	INC673	INC701	INC721	INC697	INC693	INC720	INC702	INC699	INC698	INC709	IDT136	NON715
entity_cd	SCC	OTH	IND	IND	IND	COM	COM	COM	COM	COM	OTH	OTH	COM	IND	IND	IND	IND	IND	SCC	SCC	SCC	COM	SCC	OTH	OTH	OTH	IND	OTH	SCC	OTH	IND	IND	COM	COM	COM	COM	COM	OTH	OTH	COM	IND	SCC	SCC	SCC	COM	SCC	OTH	OTH	IND	OTH
ctrib_naml	American Federation of State, Co. & Municipal Employees -- CA People	AT&T Services Inc. and its Affiliates	Brown	Bugatto	Burke	CA Association Of Professional Scientist CAPSPAC	CA Cable & Telecommunications Assn. -PAC	CA Correctional Peace Officers PAC	CA Dental Assoc. PAC (CDA PAC)	CA Statewide Law Enforcement Association-PAC	Capital Mobile Estates, LLC(Reguested Information)	Coalition Ignition Interlock Manufactures	Doctors Company - PAC The aka DOCPAC	Isenberg	Isenberg	Isenberg	Isenberg	Lubarsky	Northern CA Carpenters Regional Council	PACE of CA School Employees Assoc.-SCC	PACE of CA School Employees Assoc.-SCC	Pharmaceutical Research & Manufacturers Assn of America PAC	Professional Engineers in CA Government PECG-PAC	Santa Ynez Band of Mission Indians	The Clara Kunsch Smith Living Trust	Yocha Dehe Winton Nation	Zimmerman	Sacramento Rivercats	American Federation of State, Co. & Municipal Employees -- CA People	AT&T Services Inc. and its Affiliates	Brown	Bugatto	CA Association Of Professional Scientist CAPSPAC	CA Cable & Telecommunications Assn. -PAC	CA Correctional Peace Officers PAC	CA Dental Assoc. PAC (CDA PAC)	CA Statewide Law Enforcement Association-PAC	Capital Mobile Estates, LLC(Reguested Information)	Coalition Ignition Interlock Manufactures	Doctors Company - PAC The aka DOCPAC	Lubarsky	Northern CA Carpenters Regional Council	PACE of CA School Employees Assoc.-SCC	PACE of CA School Employees Assoc.-SCC	Pharmaceutical Research & Manufacturers Assn of America PAC	Professional Engineers in CA Government PECG-PAC	Santa Ynez Band of Mission Indians	Yocha Dehe Winton Nation	Zimmerman	Sacramento Rivercats
ctrib_namf	None	None	Melissa	David	Joan	None	None	None	None	None	None	None	None	Marilyn	Marilyn	Phil	Phil	David	None	None	None	None	None	None	None	None	Michael	None	None	None	Melissa	David	None	None	None	None	None	None	None	None	David	None	None	None	None	None	None	None	Michael	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
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
ctrib_city	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Beverly Hills	Des Moines	Napa	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Oakland	Sacramento	Sacramento	Sacramento	Sacramento	Santa Ynez	Sacramento	Brooks	Sacramento	West Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Beverly Hills	Des Moines	Napa	Sacramento	Oakland	Sacramento	Sacramento	Sacramento	Sacramento	Santa Ynez	Brooks	Sacramento	West Sacramento
ctrib_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	IA	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	IA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
ctrib_zip4	95814-4602	95814-3947	95816	95864	95864	95814-4433	95814	95814	95814	95814	90212	50322	94558-6270	95822	95822	95822	95822	95825	94621	95814	95814	95814	95814-9581	93460	95816	95606	95841	95691	95814-4602	95814-3947	95816	95864	95814-4433	95814	95814	95814	95814	90212	50322	94558-6270	95825	94621	95814	95814	95814	95814-9581	93460	95606	95841	95691
ctrib_emp	None	None	Fraulob-Brown/ University of the Pacific McGeorge School of Law	Alleghany Properties LLC	Sacramento Loaves & Fishes	None	None	None	None	None	None	None	None	N/A	N/A	N/A	N/A	UC Davis Health	None	None	None	None	None	None	None	None	MTI College	None	None	None	Fraulob-Brown/ University of the Pacific McGeorge School of Law	Alleghany Properties LLC	None	None	None	None	None	None	None	None	UC Davis Health	None	None	None	None	None	None	None	MTI College	None
ctrib_occ	None	None	Law Professor/Attorney	Real Estate Investments	Director of Advocacy	None	None	None	None	None	None	None	None	Not Employed	Not Employed	Retired	Retired	CEO	None	None	None	None	None	None	None	None	President	None	None	None	Law Professor/Attorney	Real Estate Investments	None	None	None	None	None	None	None	None	CEO	None	None	None	None	None	None	None	President	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
tran_type	None	None	I	I	I	None	None	None	None	None	R	None	None	I	I	I	I	I	None	None	None	None	None	None	None	None	I	None	None	None	None	I	None	None	None	None	None	R	None	None	None	None	None	None	None	None	None	None	I	None
rcpt_date	2022-09-06 00:00:00	2022-09-06 00:00:00	2022-09-20 00:00:00	2022-09-15 00:00:00	2022-09-20 00:00:00	2022-08-17 00:00:00	2022-07-11 00:00:00	2022-07-18 00:00:00	2022-07-27 00:00:00	2022-09-23 00:00:00	2022-08-04 00:00:00	2022-07-27 00:00:00	2022-08-30 00:00:00	2022-09-24 00:00:00	2022-09-24 00:00:00	2022-09-24 00:00:00	2022-09-24 00:00:00	2022-09-21 00:00:00	2022-08-18 00:00:00	2022-08-15 00:00:00	2022-09-21 00:00:00	2022-08-30 00:00:00	2022-08-22 00:00:00	2022-08-22 00:00:00	2022-09-23 00:00:00	2022-09-06 00:00:00	2022-09-06 00:00:00	2022-09-09 00:00:00	2022-09-06 00:00:00	2022-09-06 00:00:00	2022-09-20 00:00:00	2022-09-15 00:00:00	2022-08-17 00:00:00	2022-07-11 00:00:00	2022-07-18 00:00:00	2022-07-27 00:00:00	2022-09-23 00:00:00	2022-08-04 00:00:00	2022-07-27 00:00:00	2022-08-30 00:00:00	2022-09-21 00:00:00	2022-08-18 00:00:00	2022-08-15 00:00:00	2022-09-21 00:00:00	2022-08-30 00:00:00	2022-08-22 00:00:00	2022-08-22 00:00:00	2022-09-06 00:00:00	2022-09-06 00:00:00	2022-09-09 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
amount	1500	1500	1000	500	100	1000	2900	4900	900	2000	-500	4900	1500	250	13	250	13	1000	5000	1500	1500	1500	1000	2000	200	2000	1500	750	1500	1500	1000	500	1000	2900	4900	900	2000	-500	4900	1500	1000	5000	1500	1500	1500	1000	2000	2000	1500	750
cum_ytd	11200	1500	1000	500	100	1000	5900	9800	4900	2000	0	4900	2500	513	513	513	513	2000	14700	3000	3000	1500	6200	6900	200	2000	2500	750	11200	1500	1000	500	1000	5900	9800	4900	2000	0	4900	2500	2000	14700	3000	3000	1500	6200	6900	2000	2500	750
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
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	10 Tickets for a Baseball Game; (P)	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	10 Tickets for a Baseball Game; (P)
cmte_id	960772	None	None	None	None	860894	745932	830349	742855	970375	None	None	923140	None	None	None	None	None	972104	761128	761128	1282378	822501	None	None	None	None	None	960772	None	None	None	860894	745932	830349	742855	970375	None	None	923140	None	972104	761128	761128	1282378	822501	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
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
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
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
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
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
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
intr_naml	None	None	Actblue California	Actblue California	Actblue California	None	None	None	None	None	None	None	None	Actblue California	Actblue California	Actblue California	Actblue California	Actblue California	None	None	None	None	None	None	None	None	Actblue California	None	None	None	None	Actblue California	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Actblue California	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
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
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
intr_city	None	None	Somerville	Somerville	Somerville	None	None	None	None	None	None	None	None	Somerville	Somerville	Somerville	Somerville	Somerville	None	None	None	None	None	None	None	None	Somerville	None	None	None	None	Somerville	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Somerville	None
intr_st	None	None	MA	MA	MA	None	None	None	None	None	None	None	None	MA	MA	MA	MA	MA	None	None	None	None	None	None	None	None	MA	None	None	None	None	MA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	MA	None
intr_zip4	None	None	02144-3132	02144-3132	02144-3132	None	None	None	None	None	None	None	None	02144-3132	02144-3132	02144-3132	02144-3132	02144-3132	None	None	None	None	None	None	None	None	02144-3132	None	None	None	None	02144-3132	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	02144-3132	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Table: smry
filing_id	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272
amend_id	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	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
line_item	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22A	22B	22C	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	20	21	22A	22B	22C	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	SMRY	SMRY	SMRY	SMRY	SMRY	SMRY
form_type	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	F460	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	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	40275	0	40275	750	41025	59789	0	59789	11616	750	72155	438638	40275	63	59789	419187	0	0	19156	474206	462719	46471	460646	9047	39925	350	40275	0	0	0	750	0	750	32400	0	32400	59789	0	0	59789	19156	7539	11616	0	0	0	0	63	0	63	39100	0	39100	750	39850	59671	0	59671	5729	750	66150	438638	39100	63	59671	418130	0	0	13268	474206	462719	42582	460646	9047	39100	0	39100	0	0	0	750	0	750	32400	0	32400	59671	0	0	59671	13268	7539	5729	0	0	0	0	63	0	63
amount_b	454629	0	454629	60602	515231	455117	0	455117	19156	60602	534874	None	None	None	None	None	None	None	None	41025	79694	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	453454	0	453454	60602	514056	454999	0	454999	13268	60602	528869	None	None	None	None	None	None	None	None	39850	73689	None	None	None	None	None	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	None	None	None	None	None	None
elec_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2022-11-08 00:00:00	2022-06-07 00:00:00	2021-04-06 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	None	None	2022-11-08 00:00:00	2022-06-07 00:00:00	2021-04-06 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	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272	2724272
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	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	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
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	C	D	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	A	A	A	A	A	A	C	D	D	D	D	D	D	D
ptran_id	INC708	INC708	INC710	INC710	INC719	INC719	IDT137	INC695	INC667	INC667	INC670	INC670	INC672	INC672	INC722	EXP674	INC673	INC701	INC701	INC721	INC721	INC697	INC697	INC693	INC693	INC720	INC720	INC702	INC699	INC699	INC698	INC698	INC709	INC709	IDT136	IDT136	NON715	EXP718	EXP689	EXP691	EXP704	EXP692	EXP688	EXP690	INC708	INC708	INC710	INC710	IDT146	IDT146	IDT137	IDT145	INC695	INC667	INC667	INC670	INC670	INC672	INC672	INC722	EXP674	INC673	INC701	INC701	IDT138	IDT138	IDT140	IDT140	IDT139	IDT139	IDT141	IDT141	IDT144	IDT144	INC697	INC697	INC693	INC693	INC736	INC736	INC702	INC699	INC699	INC698	INC698	INC735	INC709	INC709	IDT136	IDT136	NON715	EXP718	EXP689	EXP691	EXP704	EXP692	EXP688	EXP690
elec_date	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00	2022-01-01 00:00:00
elec_amount	9700	1500	1500	1500	1000	1000	500	1000	3000	2900	4900	4900	4900	4900	2000	0	4900	1000	1500	1000	1000	9700	5000	9700	3000	9700	3000	1500	9700	1000	4900	2000	2000	2000	2000	1500	750	4900	4900	4900	500	4900	4900	4900	9700	1500	1500	1500	1000	1000	500	100	1000	3000	2900	4900	4900	4900	4900	2000	0	4900	1000	1500	250	263	250	263	250	263	250	263	1000	1000	9700	5000	9700	3000	9700	3000	1500	9700	1000	4900	2000	200	2000	2000	2000	1500	750	4900	4900	4900	500	4900	4900	4900
elec_code	P	G	P	G	P	G	G	G	P	G	P	G	P	G	G	P	G	P	G	P	G	P	G	P	G	P	G	G	P	G	P	G	P	G	P	G	G	G	G	G	G	G	G	G	P	G	P	G	P	G	G	G	G	P	G	P	G	P	G	G	P	G	P	G	P	G	P	G	P	G	P	G	P	G	P	G	P	G	P	G	G	P	G	P	G	G	P	G	P	G	G	G	G	G	G	G	G	G