Home

Filing ID: 2744435

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

Table: cvr2_campaign_disclosure

filing_id		2744435
amend_id		0
line_item		1
rec_type		CVR2
form_type		F460
tran_id		ATreas-CVR2.7
entity_cd		ATR
title		None
mail_city		None
mail_st		None
mail_zip4		None
f460_part		3
cmte_id		None
enty_naml		Lawler
enty_namf		Kelly
enty_namt		None
enty_nams		None
enty_city		Hilmar
enty_st		CA
enty_zip4		95324
enty_phon		209-656-1542
enty_fax		None
enty_email		None
tres_naml		None
tres_namf		None
tres_namt		None
tres_nams		None
control_yn		None
office_cd		None
offic_dscr		None
juris_cd		None
juris_dscr		None
dist_no		None
off_s_h_cd		None
bal_name		None
bal_num		None
bal_juris		None
sup_opp_cd		None

Table: cvr3_verification_info

filing_id		2744435		2744435		2744435
amend_id		0		0		0
line_item		1		2		3
rec_type		CVR3		CVR3		CVR3
form_type		F460		F460		F460
tran_id		Treas-CVR3.1814		Cand-CVR3.8		ATreas-CVR3.7
entity_cd		TRE		CAO		ATR
sig_date		2022-10-27 00:00:00		2022-10-27 00:00:00		2022-10-27 00:00:00
sig_loc		Pittsburg,CA		Jackson,CA		Hilmar,CA
sig_naml		Alvarado		Alvarado-Gil		Lawler
sig_namf		Cesar		Marie		Kelly
sig_namt		None		None		None
sig_nams		None		None		None

Table: cvr_campaign_disclosure

filing_id		2744435
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1444765
entity_cd		CAO
filer_naml		Alvarado Gil for Senate 2022
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-27 00:00:00
stmt_type		PE
late_rptno		None
from_date		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00
elect_date		2022-11-08 00:00:00
filer_city		Pittsburg
filer_st		CA
filer_zip4		94565
filer_phon		707-312-0752
filer_fax		None
file_email		[email protected]
mail_city		Jackson
mail_st		CA
mail_zip4		95642
tres_naml		Alvarado
tres_namf		Cesar
tres_namt		None
tres_nams		None
tres_city		Pittsburg
tres_st		CA
tres_zip4		94565
tres_phon		(925) 542-8139
tres_fax		None
tres_email		[email protected]
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		Alvarado-Gil
cand_namf		Marie
cand_namt		None
cand_nams		None
cand_city		Jackson
cand_st		CA
cand_zip4		95642
cand_phon		707-312-0752
cand_fax		None
cand_email		[email protected]
bal_name		None
bal_num		None
bal_juris		None
office_cd		SEN
offic_dscr		None
juris_cd		SEN
juris_dscr		None
dist_no		4
off_s_h_cd		S
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: debt

filing_id		2744435		2744435		2744435		2744435		2744435
amend_id		0		0		0		0		0
line_item		1		2		3		4		5
rec_type		DEBT		DEBT		DEBT		DEBT		DEBT
form_type		F		F		F		F		F
tran_id		F-5278		F-5239		F-5172		F-5275		F-5270
entity_cd		IND		OTH		OTH		OTH		OTH
payee_naml		Bravo		Onymous Media Inc.		Sandino Consulting		Sandino Consulting		Ted Angel Inc.
payee_namf		Vanessa		None		None		None		None
payee_namt		None		None		None		None		None
payee_nams		None		None		None		None		None
payee_city		Roseville		Fair Oaks		Walnut Grove		Walnut Grove		Sacramento
payee_st		CA		CA		CA		CA		CA
payee_zip4		95661		95628		95690		95690		95822
beg_bal		0		0		9000		0		0
amt_incur		327		41000		0		3007		7750
amt_paid		0		15000		9000		0		0
end_bal		327		26000		0		3007		7750
expn_code		None		WEB		CNS		CNS		None
expn_dscr		CMP and TRS		None		None		None		WEB and CNS
cmte_id		None		None		None		None		None
tres_naml		None		None		None		None		None
tres_namf		None		None		None		None		None
tres_namt		None		None		None		None		None
tres_nams		None		None		None		None		None
tres_city		None		None		None		None		None
tres_st		None		None		None		None		None
tres_zip4		None		None		None		None		None
memo_code		None		None		None		None		None
memo_refno		None		None		None		None		None
bakref_tid		None		None		None		None		None
xref_schnm		None		None		None		None		None
xref_match		None		None		None		None		None

Table: expn

filing_id		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435
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
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
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
form_type		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
tran_id		E-5240		E-5206		E-5203		E-5222		E-5224		E-5266		E-5205		E-5188		E-5238		E-5265		E-5267		E-5187		E-5213		E-5229		G-5303		G-5250		G-5248		G-5247		G-5242		G-5223		G-5302		G-5245		G-5249		G-5243		G-5241		G-5246		G-5244
entity_cd		OTH		OTH		IND		IND		IND		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		Capitol One		Clarke Broadcasting		Condit		Condit		Condit		Integrated Solutions: Political		KVGC 1340am		La Favorita Broadcasting Inc.		Onymous Media Inc.		Onymous Media Inc.		Ricky's Grub Shack		Sandino Consulting		Secretary of State		The KAL Group, Inc.		Agility Ad Exchange		AirBnB		America's Best Value Inn		Best Western		Emerge America		Facebook		Google		Hotel Charlotte		Mailchimp		Mike Hess Brewing Co, LLC		Mono County Clerk Recorder		Quality Inn		Taste Restaurant
payee_namf		None		None		Gary		Gary		Gary		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
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
payee_city		Charlotte		Sonora		Ceres		Ceres		Ceres		San Diego		Jackson		Hughson		Fair Oaks		Fair Oaks		Patterson		Walnut Grove		Sacramento		Hilmar		Draper		San Francisco		Tahoe City		Patterson		San Francisco		Menlo Park		Mountain View		Groveland		Atlanta		San Diego		Bridgeport		Mariposa		Plymouth
payee_st		NC		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		UT		CA		CA		CA		CA		CA		CA		CA		GA		CA		CA		CA		CA
payee_zip4		28269		95370		95307		95307		95307		92116		95642		95326		95628		95628		95363		95690		95814		95324		84020		94103		96145		95363		94111		94025		94043		95321		30308		92104		93517		95338		95669
expn_date		2022-10-19 00:00:00		2022-10-07 00:00:00		2022-10-06 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-04 00:00:00		2022-10-07 00:00:00		2022-09-28 00:00:00		2022-10-18 00:00:00		2022-10-20 00:00:00		2022-10-21 00:00:00		2022-09-28 00:00:00		2022-10-06 00:00:00		2022-10-17 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-14 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00
amount		4022		976		4500		1225		3500		475		1000		2000		19000		15000		194		9000		-150		119		6000		981		140		126		125		1225		54000		166		510		720		253		173		650
cum_ytd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
expn_chkno		36		32		30		33		34		None		31		28		None		None		37		29		21		35		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_code		None		RAD		CNS		WEB		WEB		OFC		RAD		RAD		WEB		WEB		MTG		CNS		OFC		POS		WEB		TRC		TRC		TRC		CNS		WEB		WEB		TRC		WEB		FND		FIL		TRC		FND
expn_dscr		FND, TRC, OFC and WEB		None		None		None		None		None		None		None		None		None		10/22/22 Food/Beverage for Meet and Greet		None		None		None		None		9/16 and 9/27 Candidate Lodging for District Travel		9/15/22 Lodging for District Travel		9/16/22 Lodging for District Travel		None		None		None		10/12/22 Lodging for Candidate District Travel		None		9/2/22 Lunch Fundraiser in San Diego		None		10/13/22 Lodging for Candidate District Travel		10/3/22 Catering for Fundraising Reception
agent_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Onymous Media Inc.		Capitol One		Capitol One		Capitol One		Capitol One		Condit		Onymous Media Inc.		Capitol One		Capitol One		Capitol One		Capitol One		Capitol One		Capitol One
agent_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Gary		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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		F-5239		E-5240		E-5240		E-5240		E-5240		E-5222		F-5239		E-5240		E-5240		E-5240		E-5240		E-5240		E-5240
g_from_e_f		None		None		None		None		None		None		None		None		None		None		None		None		None		None		F		E		E		E		E		E		F		E		E		E		E		E		E
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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

Table: filer_filings

filer_id		1444765
filing_id		2744435
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		2744435
filing_type		22001

Table: hdr

filing_id		2744435
amend_id		0
rec_type		HDR
ef_type		CAL
state_cd		CA
cal_ver		2.01
soft_name		ISP
soft_ver		1.0
hdrcomment		None

Table: rcpt

filing_id		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435
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
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
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
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
tran_id		A-5214		A-5234		A-5217		A-5235		A-5207		A-5189		A-5190		A-5191		A-5254		A-5215		A-5198		A-5192		A-5236		A-5201		A-5193		A-5227		A-5194		A-5260		A-5255		A-5256		A-5269		A-5261		A-5263		A-5228		A-5262		A-5210		A-5259		A-5179		A-5226		A-5264		A-5225		A-5208		A-5237		A-5252		A-5253		A-5218		A-5230		A-5200		A-5268		A-5216
entity_cd		COM		OTH		COM		COM		COM		OTH		COM		COM		IND		COM		IND		COM		COM		COM		IND		IND		IND		IND		IND		IND		COM		IND		IND		IND		IND		IND		IND		IND		OTH		IND		COM		COM		OTH		IND		IND		IND		COM		IND		IND		OTH
ctrib_naml		Associated General Contractors Political Action Committee of CA		AT&T Services Inc. and its Affiliates		CA Independent Petroleum Association PAC		California Cable & Telecommunications Association PAC		California Cattlemen's Association PAC (CATTLE-PAC)		California Dairies Inc.		California Dental Association Political Action Committee (CDA PAC)		California Nations Indian Gaming Association Sovereignty Protection Fund		Carson		Caterpillar Employee Political Action Committee Fec Id# C00148031, the		Christensen		Cristina Garcia for Secretary of State 2030		Dairy Institute Legislative Committee		Farmers Employees and Agents Political Action Committee		Francis		Glazer		Gonzales Schoennauer		Hill		Jordan		Lambrecht		Latinas Lead California		Levy		Liao		McLoed		Metune		Michalski		Miller		Mintert		Morongo Band of Mission Indians		Neumann		Pacific Egg & Poultry Association Political Action Committee		Personal Insurance Federation of CA Agents & Employees PAC		Sempra		Shao		Shaw		Sim		Susan Eggman for Lieutenant Governor 2026		Umberg		Villapudua		Yocha Dehe Wintun Nation
ctrib_namf		None		None		None		None		None		None		None		None		Benjamin		None		Steve		None		None		None		Leslie		Steven		Lisa		William		Damone		Daiana		None		Sandra		Lynn		Casey		Laura		Aron		Sajade		Kathleen		None		Eric		None		None		None		Lige		Matthew		Jolinda		None		Tom		Carlos		None
ctrib_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Dr.		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
ctrib_city		West Sacramento		St. Louis		Irvine		Sacramento		Sacramento		Visalia		Sacramento		Los Angeles		San Antonio		Deerfield		Sutter Creek		Long Beach		Sacramento		San Rafael		Camino		Orinda		San Jose		Memphis		San Jose		San Antonio		Long Beach		San Francisco		Orinda		Placerville		Sacramento		New Orleans		Arlington		Placerville		Banning		San Jose		Sacramento		Sacramento		San Diego		San Francisco		Newton		Plymouth		Antelope		Irvine		Stockton		Brooks
ctrib_st		CA		MO		CA		CA		CA		CA		CA		CA		TX		IL		CA		CA		CA		CA		CA		CA		CA		TN		CA		TX		CA		CA		CA		CA		CA		LA		TX		CA		CA		CA		CA		CA		CA		CA		MA		CA		CA		CA		CA		CA
ctrib_zip4		95691		63101		92618		95814		95814		93291		95814		90071		78212		60015		95685		90802		95814		94901		95709		94563		95112		38120		95123		78201		90802		94110		94563		95667		95822		70119		76017		95667		92220		95123		95814		95814		92101		94110		02459		95669		95843		92614		95203		95606
ctrib_emp		None		None		None		None		None		None		None		None		Not Employed		None		Not Employed		None		None		None		Retired		California		Mt. Diablo Unified School District		Rocketship TN		Rocketship		Rocketship Public Schools		None		Rocketship		Rocketship public schools		Side		Lake Tahoe Community College		Unemployed		Rocketship		Not Employed		None		Rocketship		None		None		None		Self Employed - Lige Shao		Rocketship Education		American Red Cross		None		Umberg/Zipser LLP		California Legislature		None
ctrib_occ		None		None		None		None		None		None		None		None		Not Employed		None		Not Employed		None		None		None		Retired		Senator		Superintendent/Principal		Educator		Finance		Advocacy director		None		Education		Non-profit manager		Broker		Education		Unemployed		Teacher		Not Employed		None		Operations director		None		None		None		Consultant		CFO		Non-profit Manager		None		Attorney		State Assembly Member		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
tran_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpt_date		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-10-07 00:00:00		2022-09-29 00:00:00		2022-09-28 00:00:00		2022-09-28 00:00:00		2022-10-19 00:00:00		2022-10-11 00:00:00		2022-10-02 00:00:00		2022-09-28 00:00:00		2022-10-18 00:00:00		2022-10-05 00:00:00		2022-09-29 00:00:00		2022-10-17 00:00:00		2022-09-29 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-22 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-17 00:00:00		2022-10-19 00:00:00		2022-10-08 00:00:00		2022-10-19 00:00:00		2022-09-25 00:00:00		2022-10-13 00:00:00		2022-10-20 00:00:00		2022-10-13 00:00:00		2022-10-07 00:00:00		2022-10-18 00:00:00		2022-10-19 00:00:00		2022-10-19 00:00:00		2022-10-12 00:00:00		2022-10-17 00:00:00		2022-10-03 00:00:00		2022-10-21 00:00:00		2022-10-11 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
amount		3000		4000		2000		1500		4900		4900		4900		2500		100		2000		500		2000		2000		2500		100		2500		100		100		150		100		1000		200		250		100		100		100		100		100		4900		100		1500		4900		3000		250		250		250		2400		2500		2000		3000
cum_ytd		3000		4000		2000		1500		4900		4900		4900		2500		100		2000		600		2000		2000		2500		100		2500		100		100		150		200		1000		200		250		100		100		300		100		100		4900		100		1500		4900		3000		250		250		250		4900		2500		2000		3000
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
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
cmte_id		890194		None		822237		745932		760980		None		742855		1266480		None		1307878		None		1450778		741436		901422		None		None		None		None		None		None		891143		None		None		None		None		None		None		None		None		None		983310		1338487		None		None		None		None		1445465		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
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
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
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
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
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
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
intr_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
intr_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Table: smry

filing_id		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435
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		20		21		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		67240		0		67240		0		67240		60947		0		60947		28084		0		89031		20990		67240		0		60947		27283		0		0		37084		16885		7403		66850		390		67240		0		0		0		0		0		0		0		0		0		60861		86		0		60947		52084		24000		28084		0		0		0		0		0		0		0
amount_b		144645		0		144645		0		144645		117362		0		117362		37084		0		154446		None		None		None		None		None		None		None		None		127760		147043		None		None		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		None		None		None		None		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		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435		2744435
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
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
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
ptran_id		A-5198		A-5256		A-5214		A-5234		A-5217		A-5235		A-5207		A-5189		A-5190		A-5191		A-5254		A-5215		A-5198		A-5192		A-5236		A-5201		A-5193		A-5227		A-5194		A-5260		A-5255		A-5256		A-5269		A-5261		A-5263		A-5228		A-5262		A-5210		A-5259		A-5179		A-5226		A-5264		A-5225		A-5208		A-5237		A-5252		A-5253		A-5218		A-5230		A-5200		A-5268		A-5216
elec_date		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00
elec_amount		100		100		3000		4000		2000		1500		4900		4900		4900		2500		100		2000		500		2000		2000		2500		100		2500		100		100		150		100		1000		200		250		100		100		300		100		100		4900		100		1500		4900		3000		250		250		250		4900		2500		2000		3000
elec_code		P		P		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