Home

Filing ID: 2744228

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

Table: cvr2_campaign_disclosure

filing_id		2744228		2744228
amend_id		0		0
line_item		1		2
rec_type		CVR2		CVR2
form_type		F460		F460
tran_id		OFC1		NIC5
entity_cd		ATR		COM
title		None		None
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
f460_part		3		5b
cmte_id		None		1451423
enty_naml		Deane		California Dream for All, Robert Rivas Ballot Measure Committee
enty_namf		Shawnda		None
enty_namt		None		None
enty_nams		None		None
enty_city		Sacramento		Sacramento
enty_st		CA		CA
enty_zip4		95815		95815
enty_phon		(916) 285-5733		(916) 285-5733
enty_fax		None		None
enty_email		None		None
tres_naml		None		Rivas
tres_namf		None		Robert
tres_namt		None		None
tres_nams		None		None
control_yn		None		Y
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
sup_opp_cd		None		None

Table: cvr3_verification_info

filing_id		2744228		2744228
amend_id		0		0
line_item		1		2
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		VER_1.1		VER_2.2
entity_cd		ATR		CAO
sig_date		2022-10-26 00:00:00		2022-10-26 00:00:00
sig_loc		None		None
sig_naml		Shawnda Deane		Robert Rivas
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2744228
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1434962
entity_cd		CTL
filer_naml		Robert Rivas for Assembly 2022
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-27 00:00:00
stmt_type		PE
late_rptno		None
from_date		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00
elect_date		2022-11-08 00:00:00
filer_city		Sacramento
filer_st		CA
filer_zip4		95815
filer_phon		(916) 285-5733
filer_fax		(916) 333-1344
file_email		rivas2022@deaneandcompany.com
mail_city		Salinas
mail_st		CA
mail_zip4		93902
tres_naml		Rivas
tres_namf		Robert
tres_namt		None
tres_nams		None
tres_city		Sacramento
tres_st		CA
tres_zip4		9581
tres_phon		(916) 285-5733
tres_fax		None
tres_email		None
cmtte_type		C
control_yn		Y
sponsor_yn		N
primfrm_yn		None
brdbase_yn		None
amendexp_1		None
amendexp_2		None
amendexp_3		None
rpt_att_cb		None
cmtte_id		None
reportname		None
rptfromdt		None
rptthrudt		None
emplbus_cb		None
bus_name		None
bus_city		None
bus_st		None
bus_zip4		None
bus_inter		None
busact_cb		None
busactvity		None
assoc_cb		None
assoc_int		None
other_cb		None
other_int		None
cand_naml		Rivas
cand_namf		Robert
cand_namt		None
cand_nams		None
cand_city		Hollister
cand_st		CA
cand_zip4		95023
cand_phon		(831) 905-4633
cand_fax		None
cand_email		None
bal_name		None
bal_num		None
bal_juris		None
office_cd		ASM
offic_dscr		None
juris_cd		ASM
juris_dscr		None
dist_no		29
off_s_h_cd		H
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: debt

filing_id		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228
amend_id		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
rec_type		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
tran_id		PAY1312		PAY1365		PAY1432		PAY1043		PAY1174		PAY1415		PAY1416		PAY1417		PAY1310		PAY261		PAY411		PAY412		PAY486		PAY601		PAY734		PAY903		PAY937		PAY1299		PAY1411		PAY1412		PAY1352
entity_cd		OTH		OTH		OTH		OTH		OTH		IND		IND		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		IND
payee_naml		American Express		American Express		American Express		Daniel C. Weitzman, LLC		Daniel C. Weitzman, LLC		Dursa		Dursa		Dursa		Pruitt, LLC		Steven Maviglio dba Forza Communications		Steven Maviglio dba Forza Communications		Steven Maviglio dba Forza Communications		Steven Maviglio dba Forza Communications		Steven Maviglio dba Forza Communications		Steven Maviglio dba Forza Communications		Steven Maviglio dba Forza Communications		Steven Maviglio dba Forza Communications		Tonycomms, LLC		Tonycomms, LLC		Tonycomms, LLC		Young
payee_namf		None		None		None		None		None		Dominic		Dominic		Dominic		None		None		None		None		None		None		None		None		None		None		None		None		Nathan M.
payee_namt		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
payee_city		New York		New York		New York		Sacramento		Sacramento		Salinas		Salinas		Salinas		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Santa Monica		Santa Monica		Santa Monica		Columbus
payee_st		NY		NY		NY		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		OH
payee_zip4		10281		10281		10281		95814		95814		93901		93901		93901		95814		95819		95819		95819		95819		95819		95819		95819		95819		90401		90401		90401		43212
beg_bal		9919		0		0		2200		15000		181		90		178		2200		1000		1000		1000		1000		1000		1000		1000		1000		5000		353		290		2000
amt_incur		0		25676		651		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
amt_paid		9919		0		0		0		0		181		90		178		0		0		0		0		0		0		0		0		0		5000		0		0		2000
end_bal		0		25676		651		2200		15000		0		0		0		2200		1000		1000		1000		1000		1000		1000		1000		1000		0		353		290		0
expn_code		None		None		CTB		FND		FND		None		TRS		TRS		FND		None		None		None		None		None		None		None		None		CNS		TRS		TRS		None
expn_dscr		Credit Card Payment		Credit Card Payment		Food for Fundraiser - In-Kind to Jessica Self for Assembly 2022 (ID#1442987)		None		None		Mileage		None		9/12/22, Rental Car, San Diego, CA, Campaign Meeting, 1		None		Media Consulting		Media Consulting		Media Consulting		Media Consulting		Media Consulting		Media Consulting		Media Consulting		Media Consulting		None		8/16/22-8/17/22, Airfare, Sacramento, CA, Campaign Meeting, 1		8/16/22-8/17/22, Lodging, Sacramento, CA, Campaign Meeting, 1		Social Media Services
cmte_id		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
tres_namf		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
tres_nams		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
tres_st		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
memo_code		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
bakref_tid		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
xref_match		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		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53		54		55		56		57		58		59		60		61		62		63		64		65		66		67		68		69		70		71		72		73		74		75		76		77		78		79		80		81		82		83		84		85		86		87		88		89		90		91		92		93		94		95		96		97		98		99		100
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
form_type		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		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G		G
tran_id		EXP1338		EXP1386		EXP1387		PDT318		EXP1321		EXP1340		EXP1342		EXP1364		EXP1385		EXP1366		EXP1368		EXP1338		EXP1386		EXP1362		EXP1387		EXP1420		EXP1422		EXP1424		EXP1426		EXP1428		EXP1430		EXP1396		EXP1397		EXP1398		EXP1380		EXP1389		EXP1399		EXP1400		EXP1401		EXP1402		EXP1403		EXP1404		EXP1405		EXP1406		EXP1407		EXP1408		EXP1409		EXP1391		EXP1395		EXP1335		EXP1325		EXP1326		EXP1388		EXP1393		EXP1394		EXP1350		EXP1360		PDT309		PDT278		PDT317		PDT292		PDT256		PDT288		PDT303		PDT258		PDT281		PDT259		PDT290		PDT289		PDT255		PDT302		PDT273		PDT301		PDT257		PDT286		PDT283		PDT304		PDT300		PDT319		PDT260		PDT261		PDT262		PDT263		PDT264		PDT265		PDT266		PDT267		PDT269		PDT270		PDT271		PDT272		PDT277		PDT279		PDT284		PDT291		PDT293		PDT294		PDT296		PDT298		PDT299		PDT312		PDT313		PDT315		PDT316		PDT310		PDT311		PDT276		PDT306		PDT314		EDT85
entity_cd		COM		COM		COM		COM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		COM		COM		OTH		COM		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		OTH		OTH		OTH		IND		IND		IND		IND		IND		OTH		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Chris Duncan for Assembly 2022		Dawn Addis for Assembly 2022		Democratic Leadership Coalition PAC		Self for Assembly 2022		ActBlue Technical Services		ActBlue Technical Services		ActBlue Technical Services		ActBlue Technical Services		ActBlue Technical Services		American Express		American Express		Chris Duncan for Assembly 2022		Dawn Addis for Assembly 2022		Deane & Company		Democratic Leadership Coalition PAC		Dursa		Dursa		Dursa		Dursa		Dursa		Dursa		Horton		Horton		Horton		Koogler		Meza Cuellar		O'Mara		O'Mara		O'Mara		O'Mara		O'Mara		O'Mara		O'Mara		O'Mara		O'Mara		O'Mara		O'Mara		Phillips 66		Rodriguez Political Law		Tonycomms, LLC		Vargas		Vargas		Vargas		Vargas		Vargas		Walmart, Inc.		Young		AMEX Fine Hotels		AMEX Travel Car		AMEX Travel Car		Bear's Hideaway, LLC		Disneyland Resort		El Capitan Hotel		Embassy Suites		Enterprise Rent-A-Car		Enterprise Rent-A-Car		Fairfield by Marriott Inn & Suites		Fairmont Miramar Hotel		Galaxy Self Storage		Hilton Memphis		Hotel Paseo		Mailchimp		National Car Rental		Phillips 66		San Francisco 49ers		San Jose International Airport Parking		San Jose International Airport Parking		Sheraton Park Hotel		Skewers Kabob House		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		Southwest Airlines		SW Hotel		SW Hotel		The Ritz Carlton		Thrifty Car Rental		US Coachways		Budget Rent-A-Car
payee_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Dominic		Dominic		Dominic		Dominic		Dominic		Dominic		Miles		Miles		Miles		Abraham		Maria Isabel		Stephen		Stephen		Stephen		Stephen		Stephen		Stephen		Stephen		Stephen		Stephen		Stephen		Stephen		None		None		None		Julio Mendez		Julio Mendez		Julio Mendez		Julio Mendez		Julio Mendez		None		Nathan M.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
payee_city		Oceanside		Sacramento		Sacramento		Modesto		Cambridge		Cambridge		Cambridge		Cambridge		Cambridge		New York		New York		Oceanside		Sacramento		Sacramento		Sacramento		Salinas		Salinas		Salinas		Salinas		Salinas		Salinas		Sacramento		Sacramento		Sacramento		Salisbury		Soledad		San Rafael		San Rafael		San Rafael		San Rafael		San Rafael		San Rafael		San Rafael		San Rafael		San Rafael		San Rafael		San Rafael		Washington		Sacramento		Santa Monica		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Bentonville		Columbus		New York		New York		New York		San Juan Bautista		Anaheim		Merced		Palm Desert		Ontario		Ontario		Indio		Santa Monica		Hollister		Memphis		Palm Desert		Atlanta		Long Beach		Washington		Santa Clara		San Jose		San Jose		Anaheim		Modesto		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		Dallas		San Francisco		San Francisco		Half Moon Bay		Sacramento		San Francisco		Ontario
payee_st		CA		CA		CA		CA		MA		MA		MA		MA		MA		NY		NY		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CT		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		DC		CA		CA		CA		CA		CA		CA		CA		AR		OH		NY		NY		NY		CA		CA		CA		CA		CA		CA		CA		CA		CA		TN		CA		GA		CA		DC		CA		CA		CA		CA		CA		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		TX		CA		CA		CA		CA		CA		CA
payee_zip4		92054		95814		95815		95350		02138		02138		02138		02138		02138		10281		10281		92054		95814		95815		95815		93901		93901		93901		93901		93901		93901		95814		95814		95814		06068		93960		94903		94903		94903		94903		94903		94903		94903		94903		94903		94903		94903		20004		95811		90401		95814		95814		95814		95814		95814		72716		43212		10285		10285		10285		95045		92802		95340		92260		91761		91761		92203		90401		95023		38117		92260		30308		90808		20004		95054		95110		95110		92802		95354		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		75235		94133		94133		94019		95814		94124		91761
expn_date		2022-10-07 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-02 00:00:00		2022-09-25 00:00:00		2022-09-30 00:00:00		2022-10-02 00:00:00		2022-10-09 00:00:00		2022-10-16 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-07 00:00:00		2022-10-18 00:00:00		2022-10-13 00:00:00		2022-10-18 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-22 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-21 00:00:00		2022-10-19 00:00:00		2022-10-20 00:00:00		2022-10-06 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-18 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00		2022-10-11 00:00:00		2022-10-13 00:00:00		2022-10-14 00:00:00		2022-09-30 00:00:00		2022-10-21 00:00:00		2022-10-06 00:00:00		2022-09-25 00:00:00		2022-10-02 00:00:00		2022-10-10 00:00:00		2022-09-26 00:00:00		2022-10-01 00:00:00		2022-09-28 00:00:00		2022-10-06 00:00:00		2022-10-03 00:00:00		2022-09-25 00:00:00		2022-10-10 00:00:00		2022-09-29 00:00:00		2022-10-10 00:00:00		2022-09-25 00:00:00		2022-10-02 00:00:00		2022-10-01 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-02 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-10-01 00:00:00		2022-10-01 00:00:00		2022-10-06 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-09 00:00:00		2022-10-10 00:00:00		2022-10-10 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-15 00:00:00		2022-10-16 00:00:00		2022-09-30 00:00:00		2022-10-12 00:00:00		2022-10-19 00:00:00		2022-10-21 00:00:00
amount		4900		4900		125000		651		230		22		1		4		0		9919		1262		4900		4900		3131		125000		90		178		181		50		275		373		70		224		807		5000		114		49		133		400		368		331		304		292		370		254		13		292		2000		6643		5000		49		103		1500		88		270		4900		2000		1029		134		346		436		176		536		201		324		58		132		14890		145		374		290		59		255		96		345		30		90		595		651		352		335		277		277		109		109		109		99		326		119		49		15		37		129		192		281		477		109		214		326		169		293		291		213		18		175		175		108		19		639		807
cum_ytd		4900		9800		215000		651		2018		2018		2018		2018		2018		97601		97601		4900		9800		26775		217017		1148		1148		1148		1148		1148		1148		1101		1101		1101		15745		114		7875		7875		7875		7875		7875		7875		7875		7875		7875		7875		7875		2096		24616		10643		2011		2011		2011		2011		2011		4900		6530		1870		854		854		436		176		536		201		725		725		132		14890		1450		374		290		525		255		2096		345		486		486		595		651		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		12727		350		350		108		262		639		916
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
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
expn_code		MON		MON		MON		IKD		OFC		OFC		OFC		OFC		OFC		None		None		CTB		CTB		PRO		CTB		TRS		TRS		None		None		None		TRS		TRS		TRS		TRS		None		TRS		TRS		MTG		TRS		MTG		TRS		TRS		TRS		MTG		TRS		TRS		TRS		None		PRO		CNS		TRS		TRS		CNS		None		TRS		None		None		TRC		TRC		TRC		OFC		OFC		MTG		TRC		TRC		TRC		TRC		TRC		OFC		TRC		TRC		OFC		TRC		TRC		OFC		TRC		TRC		TRC		CTB		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRS		TRC		TRC		TRC		TRS		TRC		TRS		TRC		TRS		TRC		TRS		TRC		TRC		TRC		TRC		TRC		TRC		TRC		TRC		TRC		TRC		TRS
expn_dscr		None		None		None		Food for Fundraiser		None		None		None		None		None		Credit Card Payment		Credit Card Payment		None		None		None		None		None		9/12/22, Rental Car, San Diego, CA, Campaign Meeting, 1		Mileage		Mileage		Mileage		10/14/22-10/17/22, Rental Car, Salinas, CA, Campaign Meeting, 1		None		10/8/22-10/9/22, Rental Car, Palm Springs, CA, Campaign Staff Retreats, 1		10/15/22-10/16/22, Rental Car, Santa Ana, CA, Campaign Staff Retreats, 1		Writing & Editing Services		10/16/22, Parking, San Jose, CA, Campaign Events, 1		Mileage		10/9/22, Staff Retreat, 4		10/8/22-10/9/22, Rental Car, Ontario, CA, Staff Retreat, 1		10/8/22, Staff Retreat, 6		10/15/22-10/16/22, Lodging, Irvine, CA, Staff Retreat, 1		10/15/22-10/16/22, Lodging, Irvine, CA, Staff Retreat, 1		10/15/22-10/16/22, Lodging, Irvine, CA, Staff Retreat, 1		10/15/22, Staff Retreat, 6		10/22/22, Airfare, Orange County, CA, Campaign Meeting, 1		None		10/15/22-10/16/22, Lodging, Irvine, CA, Staff Retreat, 1		Refund of Contribution		None		None		None		9/25/22-9/26/22, Rental Car, Palmdale, CA, Campaign Event, 1		None		Mileage		10/15/22-10/16/22, Car Rental, San Diego, CA, Campaign Events, 1		Refund of Contribution		Social Media Services		None		None		None		Appetizers Only		None		10/2/22, Legislative Meeting, 10, including Candidate & Members of Household		None		9/23/22, Car Rental, Indio, CA, Fundraising Event, 1, Candidate		None		None		None		None		9/23/22, Lodging, Indio, CA, Fundraising Event, 1, Candidate		None		None		None		None		None		None		None		None		Food for Fundraiser		10/16/22, Airfare, Oakland, CA, Legislative Event, 1		10/16/22, Airfare, Las Vegas, NV, Legislative Event, 1		10/16/22, Airfare, Las Vegas, NV, Legislative Event, 1		10/16/22, Airfare, Las Vegas, NV, Legislative Event, 1		10/15/22, Airfare, San Diego, CA, Legislative Event, 1		10/15/22, Airfare, San Diego, CA, Legislative Event, 1		10/15/22, Airfare, San Diego, CA, Legislative Event, 1		None		10/16/22, Airfare, Las Vegas, NV, Legislative Event, 1		10/15/22, Airfare, San Diego, CA, Legislative Event, 1		None		None		None		10/14/22, Airfare, San Diego, CA, Legislative Event, 1		None		10/16/22, Airfare, San Jose, CA, Legislative Event, 1		None		10/15/22, Airfare, San Diego, CA, Legislative Event, 1		None		10/16/22, Airfare, Sacramento, CA, Legislative Event, 1		None		None		None		None		None		None		None		None		None		None		10/15/22-10/16/22, Rental Car, Santa Ana, CA, Campaign Staff Retreats, 1
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		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		American Express		Horton
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		Miles
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
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
cmte_id		None		None		None		None		None		None		None		None		None		None		None		1443620		1442437		None		1449276		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
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
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
cand_naml		Chris Duncan		Dawn Addis		None		Jessica Self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
office_cd		ASM		ASM		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
juris_cd		ASM		ASM		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
dist_no		74		30		None		22		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
sup_opp_cd		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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		F		F		F		F		E		F		F		E		F		E		F		F		E		F		F		F		E		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		F		F		F		F		F		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
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

Table: filer_filings

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

Table: filings

filing_id		2744228
filing_type		22001

Table: hdr

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

Table: rcpt

filing_id		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53
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
form_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		I
tran_id		INC1322		INC1372		INC1320		INC1334		INC1359		IDT458		INC1332		INC1328		INC1378		INC1345		INC1330		INC1356		INC1349		INC1319		INC1317		INC1355		IDT459		INC1379		INC1392		INC1354		IDT460		INC1327		INC1337		IDT448		INC1351		INC1313		INC1375		IDT449		INC1333		INC1370		INC1381		INC1413		IDT452		IDT451		INC1323		INC1347		INC1329		IDT453		INC1346		INC1318		INC1344		INC1390		INC1383		INC1382		INC1357		INC1353		INC1410		IDT454		INC1324		INC1348		INC1373		INC1316		INC1371
entity_cd		COM		OTH		OTH		OTH		OTH		IND		OTH		COM		COM		SCC		COM		SCC		SCC		COM		SCC		COM		IND		IND		COM		COM		IND		OTH		OTH		IND		COM		COM		IND		IND		COM		COM		OTH		OTH		IND		IND		OTH		SCC		SCC		IND		OTH		OTH		SCC		SCC		COM		SCC		COM		OTH		COM		IND		COM		COM		OTH		OTH		OTH
ctrib_naml		21st Century Alliance Good Government PAC		Amazon.com Services, LLC		AstraZeneca Pharmaceuticals, LP / Zeneca, Inc.		AT&T Services, Inc. and its Affiliates		Barona Band of Mission Indians		Barrios		Blue Shield of California		California Correctional Peace Officers Association PAC		California Dental Association PAC (CDA PAC)		California Federation of Teachers COPE Small Contributor Committee		California Hospital Association PAC Sponsored by California Association of Hospitals and Health Systems (CAHHS)		California State Association of Electrical Workers Small Contributor Committee		California State Council of Service Employees Small Contributor Committee		California Statewide Law Enforcement Association PAC		California Teachers Association/Association for Better Citizenship Small Contributor Committee		Californians for Jobs and a Strong Economy		Cancino		Carcione		CARGO PAC - Concerned Americans for Responsible Government sponsored by The California Trucking Association		Caterpillar, Inc. PAC (CATPAC) (FEC ID#C00148031)		Coleman		CVS Pharmacy, Inc.		DaVita, Inc. and affiliated entities		Egland		Enterprise Holdings, Inc. PAC - FEDPAC ID# C00219642		FairPAC, Sponsored by the Civil Justice Association of California		Fernandez		Fierro		Ford Motor Company Civic Action Fund		Honeywell International PAC (FED PAC ID #C00096156)		KPMG, LLP		Law Offices of Walkup, Melodia, Kelly & Schoenberger, PC		Miller		Miller		Molson Coors Beverage Company		Operating Engineers Local No. 3 Statewide PAC Small Contributor Committee		Peace Officers Research Association of California PAC (PORAC PAC) Small Contributor Committee		Pearson		Pechanga Band of Luiseno Indians		PG&E Corporation		Plumbers, Steamfitters & Refrigeration Fitters Local 393 Political Action Fund - Small Contributor Committee		SEIU United Healthcare Workers West PAC Small Contributor Committee		SMART - Transportation Division PAC		Southern California Pipe Trades District Council #16 PAC Small Contributor Committee		State Coalition of Probation Organizations PAC		Tejon Indian Tribe		The Hartford Financial Services Group, Inc. PAC (AKA The Hartford Advocates Fund) (FED PAC ID# C00168864)		Thompson		Trout Political Action Committee (TROUTPAC)		United Parcel Service Inc. PAC (FEC ID#C00064766)		Universal Music Group, Inc.		Visa, Inc.		First Foundation Bank
ctrib_namf		None		None		None		None		None		Margie		None		None		None		None		None		None		None		None		None		None		Raymon		Roberta M.		None		None		Windstead		None		None		Valerie		None		None		Robert		Joanne M.		None		None		None		None		Clint		Karen		None		None		None		James		None		None		None		None		None		None		None		None		None		Margaret		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
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
ctrib_city		Oakland		Seattle		Wilmington		Saint Louis		Lakeside		Hollister		Oakland		Sacramento		Sacramento		Sacramento		Sacramento		Pasadena		Sacramento		Sacramento		Burlingame		Sacramento		Aptos		Menlo Park		Sacramento		Deerfield		Capitola		Woonsocket		Tacoma		San Juan Bautista		St. Louis		Sacramento		San Juan Bautista		Gilroy		Dearborn		Washington		Dallas		San Francisco		Royal Oaks		Royal Oaks		Chicago		Alameda		Sacramento		Gilroy		Temecula		San Francisco		Sacramento		Los Angeles		Independence		Los Angeles		Sacramento		Arvin		Hartford		Hollister		Sacramento		Atlanta		Woodland Hills		Foster City		Irvine
ctrib_st		CA		WA		DE		MO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		IL		CA		RI		WA		CA		MO		CA		CA		CA		MI		DC		TX		CA		CA		CA		IL		CA		CA		CA		CA		CA		CA		CA		OH		CA		CA		CA		CT		CA		CA		GA		CA		CA		CA
ctrib_zip4		94607		98109		19850		63101		92040		95023		94607		95814		95814		95814		95814		91101		95814		95814		94010		95842		95003		94025		95834		60015		95010		02895		98405		95045		63105		95815		95045		95020		48126		20001		75201		94108		95076		95076		60606		94502		95834		95020		92592		94105		95814		90017		44131		90020		95826		93203		06115		95023		95814		30328		91367		94404		92612
ctrib_emp		None		None		None		None		None		Margie Barrios		None		None		None		None		None		None		None		None		None		None		Community Bridges		n/a		None		None		n/a		None		None		n/a		None		None		Robert Fernandez		n/a		None		None		None		None		n/a		n/a		None		None		None		n/a		None		None		None		None		None		None		None		None		None		Gilroy Unified School District		None		None		None		None		None
ctrib_occ		None		None		None		None		None		Accountant		None		None		None		None		None		None		None		None		None		None		Chief Executive Officer		Retired		None		None		Not Employed		None		None		Not Employed		None		None		Tax Consultant		Not Employed		None		None		None		None		Not Employed		Retired		None		None		None		Not Employed		None		None		None		None		None		None		None		None		None		Teacher		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
tran_type		None		None		None		None		None		I		None		None		None		None		None		None		None		None		None		None		I		None		None		None		I		None		None		I		None		None		None		I		None		None		None		None		I		I		None		None		None		I		None		None		None		None		None		None		None		None		None		I		None		None		None		None		None
rcpt_date		2022-09-30 00:00:00		2022-10-13 00:00:00		2022-09-27 00:00:00		2022-10-05 00:00:00		2022-10-12 00:00:00		2022-10-21 00:00:00		2022-10-05 00:00:00		2022-10-04 00:00:00		2022-10-14 00:00:00		2022-10-07 00:00:00		2022-10-05 00:00:00		2022-10-11 00:00:00		2022-10-10 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-10-11 00:00:00		2022-10-22 00:00:00		2022-10-15 00:00:00		2022-10-19 00:00:00		2022-10-11 00:00:00		2022-10-20 00:00:00		2022-10-04 00:00:00		2022-10-06 00:00:00		2022-09-29 00:00:00		2022-10-11 00:00:00		2022-09-26 00:00:00		2022-10-07 00:00:00		2022-09-29 00:00:00		2022-10-05 00:00:00		2022-10-12 00:00:00		2022-10-17 00:00:00		2022-10-21 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-10-07 00:00:00		2022-10-04 00:00:00		2022-09-29 00:00:00		2022-10-07 00:00:00		2022-09-26 00:00:00		2022-10-07 00:00:00		2022-10-18 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-11 00:00:00		2022-10-11 00:00:00		2022-10-20 00:00:00		2022-10-02 00:00:00		2022-09-30 00:00:00		2022-10-10 00:00:00		2022-10-13 00:00:00		2022-09-26 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
amount		1500		4900		2000		4800		4900		100		2400		4900		4900		2500		1000		7500		9700		2000		9700		4900		100		1000		2000		1500		250		1000		4900		15		1500		2000		250		15		4900		2500		1000		4900		250		250		1500		4900		2200		10		2400		4900		2900		9700		3000		5000		1000		2500		2000		25		4000		2500		1000		2000		59
cum_ytd		3000		4900		2000		4800		5800		100		4900		6800		5800		5000		1000		12500		19400		2000		19400		4900		100		1000		2000		1500		250		3500		4900		185		1500		2000		250		235		7900		2500		1000		4900		500		500		1500		9800		8200		190		4900		4900		2900		19400		3000		5000		1000		2500		2000		475		4000		2500		1000		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
ctrib_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Interest Earned
cmte_id		1439959		None		None		None		None		None		None		830349		742855		741857		790773		743107		831628		970375		741941		1275549		None		None		760458		1307878		None		None		None		None		992324		1311499		None		None		761070		1372848		None		None		None		None		None		981697		810830		None		None		None		851452		747285		745910		760715		911856		None		930174		None		861445		1377592		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
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
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
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
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
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
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
intr_naml		None		None		None		None		None		ActBlue		None		None		None		None		None		None		None		None		None		None		ActBlue		None		None		None		ActBlue		None		None		ActBlue		None		None		None		ActBlue		None		None		None		None		ActBlue		ActBlue		None		None		None		ActBlue		None		None		None		None		None		None		None		None		None		ActBlue		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
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
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
intr_city		None		None		None		None		None		Cambridge		None		None		None		None		None		None		None		None		None		None		Cambridge		None		None		None		Cambridge		None		None		Cambridge		None		None		None		Cambridge		None		None		None		None		Cambridge		Cambridge		None		None		None		Cambridge		None		None		None		None		None		None		None		None		None		Cambridge		None		None		None		None		None
intr_st		None		None		None		None		None		MA		None		None		None		None		None		None		None		None		None		None		MA		None		None		None		MA		None		None		MA		None		None		None		MA		None		None		None		None		MA		MA		None		None		None		MA		None		None		None		None		None		None		None		None		None		MA		None		None		None		None		None
intr_zip4		None		None		None		None		None		02138		None		None		None		None		None		None		None		None		None		None		02138		None		None		None		02138		None		None		02138		None		None		None		02138		None		None		None		None		02138		02138		None		None		None		02138		None		None		None		None		None		None		None		None		None		02138		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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
memo_refno		None		INC1372		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
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
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

Table: smry

filing_id		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228
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
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
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
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
amount_a		147805		0		147805		0		147805		182090		0		182090		8959		0		191049		679160		147805		59		182090		644935		0		0		54370		171627		360225		147565		240		147805		0		0		0		0		0		0		135451		0		135451		182090		0		0		182090		26327		17369		8959		0		0		0		59		0		0		59
amount_b		833213		0		833213		0		833213		780505		0		780505		54370		0		834875		None		None		None		None		None		None		None		None		None		None		None		None		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
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

Table: splt

filing_id		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228		2744228
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		20		21		22		23		24		25		26		27		28		29		30		31		32		33		34		35		36		37		38		39		40		41		42		43		44		45		46		47		48		49		50		51		52		53		54		55		56		57		58		59		60		61		62		63		64		65		66		67		68		69		70		71		72		73		74		75		76		77		78		79		80		81		82		83		84		85		86		87		88		89
pform_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		D		D		D		D		D
ptran_id		INC1322		INC1322		INC1372		INC1372		INC1320		INC1320		INC1334		INC1334		INC1359		INC1359		IDT458		IDT458		INC1332		INC1332		INC1328		INC1328		INC1378		INC1378		INC1345		INC1345		INC1330		INC1330		INC1356		INC1356		INC1349		INC1349		INC1319		INC1319		INC1317		INC1317		INC1355		IDT459		INC1379		INC1392		INC1354		IDT460		INC1327		INC1327		INC1337		INC1337		IDT448		IDT448		INC1351		INC1313		INC1375		INC1375		IDT449		IDT449		INC1333		INC1333		INC1370		INC1381		INC1413		IDT452		IDT452		IDT451		IDT451		INC1323		INC1323		INC1347		INC1347		INC1329		INC1329		IDT453		IDT453		INC1346		INC1346		INC1318		INC1318		INC1344		INC1390		INC1390		INC1383		INC1382		INC1357		INC1353		INC1410		IDT454		IDT454		INC1324		INC1348		INC1373		INC1373		INC1316		EXP1338		EXP1386		EXP1386		EXP1387		PDT318
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
elec_amount		1500		1500		4900		4900		2000		2000		4900		4900		4900		4900		100		100		4900		4900		4900		4900		2900		4900		2500		2500		3000		1000		9700		7800		9700		9700		1500		2000		9700		9700		4900		100		1000		2000		1500		250		2500		1000		4900		4900		325		110		1500		2000		350		250		405		160		4500		4900		2500		1000		4900		250		250		250		250		1500		1500		4900		4900		9700		8200		570		140		4900		4900		4900		4900		2900		9700		9700		3000		5000		1000		2500		2000		525		450		4000		2500		1000		1000		2000		4900		4900		4900		2017		651
elec_code		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		G		G		G		G		G		G		P		G		P		G		P		G		G		G		P		G		P		G		P		G		G		G		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		P		G		G		P		G		G		G		G		G		G		P		G		G		G		P		G		G		G		P		G		G		G