Home

Filing ID: 2724953

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

Table: cvr2_campaign_disclosure

filing_id		2724953
amend_id		0
line_item		1
rec_type		CVR2
form_type		F460
tran_id		OFC2
entity_cd		ATR
title		None
mail_city		None
mail_st		None
mail_zip4		None
f460_part		3
cmte_id		None
enty_naml		Ferruccio
enty_namf		John
enty_namt		None
enty_nams		None
enty_city		Los Angeles
enty_st		CA
enty_zip4		90020
enty_phon		(213) 487-4262
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		2724953		2724953
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		TRE		OFF
sig_date		2022-09-28 00:00:00		2022-09-28 00:00:00
sig_loc		None		None
sig_naml		Rodney Cobos		Rodney Cobos
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2724953
amend_id		0
rec_type		CVR
form_type		F460
filer_id		760715
entity_cd		RCP
filer_naml		Southern California Pipe Trades District Council No. 16 Political Action Committee
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-09-28 00:00:00
stmt_type		PE
late_rptno		None
from_date		2022-07-01 00:00:00
thru_date		2022-09-24 00:00:00
elect_date		2022-11-08 00:00:00
filer_city		Los Angeles
filer_st		CA
filer_zip4		90020
filer_phon		(213) 487-4262
filer_fax		None
file_email		[email protected]
mail_city		Sacramento
mail_st		CA
mail_zip4		95814
tres_naml		Cobos
tres_namf		Rodney
tres_namt		None
tres_nams		None
tres_city		Los Angeles
tres_st		CA
tres_zip4		90020
tres_phon		(213) 487-4262
tres_fax		None
tres_email		None
cmtte_type		G
control_yn		Y
sponsor_yn		Y
primfrm_yn		N
brdbase_yn		None
amendexp_1		None
amendexp_2		None
amendexp_3		None
rpt_att_cb		None
cmtte_id		None
reportname		None
rptfromdt		None
rptthrudt		None
emplbus_cb		None
bus_name		None
bus_city		None
bus_st		None
bus_zip4		None
bus_inter		None
busact_cb		None
busactvity		None
assoc_cb		None
assoc_int		None
other_cb		None
other_int		None
cand_naml		None
cand_namf		None
cand_namt		None
cand_nams		None
cand_city		None
cand_st		None
cand_zip4		None
cand_phon		None
cand_fax		None
cand_email		None
bal_name		None
bal_num		None
bal_juris		None
office_cd		None
offic_dscr		None
juris_cd		None
juris_dscr		None
dist_no		None
off_s_h_cd		None
sup_opp_cd		None
employer		None
occupation		None
selfemp_cb		None
bal_id		None
cand_id		None

Table: debt

filing_id		2724953
amend_id		0
line_item		1
rec_type		DEBT
form_type		F
tran_id		PAY2637
entity_cd		OTH
payee_naml		Olson Remcho, LLP
payee_namf		None
payee_namt		None
payee_nams		None
payee_city		Sacramento
payee_st		CA
payee_zip4		95814
beg_bal		0
amt_incur		3157
amt_paid		0
end_bal		3157
expn_code		PRO
expn_dscr		None
cmte_id		None
tres_naml		None
tres_namf		None
tres_namt		None
tres_nams		None
tres_city		None
tres_st		None
tres_zip4		None
memo_code		None
memo_refno		None
bakref_tid		None
xref_schnm		None
xref_match		None

Table: expn

filing_id		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953
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		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		101		102		103		104		105		106		107		108
rec_type		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN
form_type		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		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
tran_id		EXP2620		EXP2618		EXP2573		EXP2630		EXP2604		EXP2614		EXP2610		EXP2621		EXP2616		EXP2606		EXP2592		EXP2575		EXP2574		EXP2599		EXP2591		EXP2608		EXP2629		EXP2634		EXP2585		EXP2588		EXP2578		EXP2619		EXP2625		EXP2593		EXP2609		EXP2601		EXP2636		EXP2581		EXP2623		EXP2638		EXP2577		EXP2602		EXP2611		EXP2582		EXP2617		EXP2605		EXP2579		EXP2603		EXP2624		EXP2613		EXP2572		EXP2615		EXP2576		EXP2596		EXP2598		EXP2586		EXP2597		EXP2635		EXP2600		EXP2632		EXP2633		EXP2612		EXP2631		EXP2569		EXP2620		EXP2618		EXP2573		EXP2630		EXP2604		EXP2614		EXP2610		EXP2621		EXP2616		EXP2606		EXP2592		EXP2575		EXP2574		EXP2599		EXP2591		EXP2608		EXP2629		EXP2634		EXP2585		EXP2588		EXP2578		EXP2619		EXP2625		EXP2593		EXP2609		EXP2601		EXP2636		EXP2581		EXP2623		EXP2638		EXP2577		EXP2602		EXP2611		EXP2582		EXP2617		EXP2605		EXP2579		EXP2603		EXP2624		EXP2613		EXP2572		EXP2615		EXP2576		EXP2596		EXP2598		EXP2586		EXP2597		EXP2635		EXP2600		EXP2632		EXP2633		EXP2612		EXP2631		EXP2569
entity_cd		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		None		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		OTH		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM
payee_naml		Allen for Water Replenishment District 2022		Brenes for LAUSD School Board 2022 - General		Buelna for College Board 2022		Cabrera for Mayor 2022		Carr for Senate 2022		Carr for Senate 2022		Carrillo for Assembly 2022		Caruso for City Council 2022		Cedillo Officeholder Account 2013		Chen for Assembly 2022		Dino for Palmdale Water District 2022		Fong for Assembly 2022		Gill for City Attorney 2022		Gill for City Attorney 2022		Gomez for Palmdale City Council District 3 2022		Gonez for School Board 2022 - General		Hawkins for West Valley Water District 2024		Hernandez for City Council 2022		Hernandez for Community College Trustee 2022		Hernandez for Community College Trustee 2022		Holstege for Assembly 2022		Holstege for Assembly 2022		Homes for Families and Workers sponsored by Labor Organizations		Iino for LACCD Trustee 2022		Koretz for Controller 2022 General		Kwan for West Basin Water Board 2022		Kyriaco for Goleta City Council 2022		Kyriaco for Goleta City Council 2022		McKinnor for Assembly 2022		McOsker for City Council 2022 - General		Newman for Senate 2024		Newman for Senate 2024		Nguyen for Supervisor 2022		Ntuk for LBCCD Trustee 2022		Numark for Torrance Mayor 2022		Ortega-Toro for Assembly 2022		Park for City Council 2022 - General		Petrie-Norris for Assembly 2022		Richardson for Mayor 2022		Ricks-Oddie for Council 2022		Rizvi for Assembly 2022		Rosenthal for Assembly 2022		Rubalcava for City Council 2022		San Diego County Democratic Party		Santiago for Assembly 2022		Schiavo for Assembly 2022		Schiavo for Assembly 2022		Soto for Santa Maria City Council, District 3, 2022		The Plumbing Piping & Mechanical Contractors PAC		Thurmond for Superintendent of Public Instruction 2022		Tran for Mayor 2022		Valencia for Assembly 2022		Wilson Trustee of Chaffey Joint Union High School District for Area 4 - 2022		Yes to Safeguard San Diego Infrastructure, Sponsored by Labor and Community Organizations		Allen for Water Replenishment District 2022		Brenes for LAUSD School Board 2022 - General		Buelna for College Board 2022		Cabrera for Mayor 2022		Carr for Senate 2022		Carr for Senate 2022		Carrillo for Assembly 2022		Caruso for City Council 2022		Cedillo Officeholder Account 2013		Chen for Assembly 2022		Dino for Palmdale Water District 2022		Fong for Assembly 2022		Gill for City Attorney 2022		Gill for City Attorney 2022		Gomez for Palmdale City Council District 3 2022		Gonez for School Board 2022 - General		Hawkins for West Valley Water District 2024		Hernandez for City Council 2022		Hernandez for Community College Trustee 2022		Hernandez for Community College Trustee 2022		Holstege for Assembly 2022		Holstege for Assembly 2022		Homes for Families and Workers sponsored by Labor Organizations		Iino for LACCD Trustee 2022		Koretz for Controller 2022 General		Kwan for West Basin Water Board 2022		Kyriaco for Goleta City Council 2022		Kyriaco for Goleta City Council 2022		McKinnor for Assembly 2022		McOsker for City Council 2022 - General		Newman for Senate 2024		Newman for Senate 2024		Nguyen for Supervisor 2022		Ntuk for LBCCD Trustee 2022		Numark for Torrance Mayor 2022		Ortega-Toro for Assembly 2022		Park for City Council 2022 - General		Petrie-Norris for Assembly 2022		Richardson for Mayor 2022		Ricks-Oddie for Council 2022		Rizvi for Assembly 2022		Rosenthal for Assembly 2022		Rubalcava for City Council 2022		San Diego County Democratic Party		Santiago for Assembly 2022		Schiavo for Assembly 2022		Schiavo for Assembly 2022		Soto for Santa Maria City Council, District 3, 2022		The Plumbing Piping & Mechanical Contractors PAC		Thurmond for Superintendent of Public Instruction 2022		Tran for Mayor 2022		Valencia for Assembly 2022		Wilson Trustee of Chaffey Joint Union High School District for Area 4 - 2022		Yes to Safeguard San Diego Infrastructure, Sponsored by Labor and Community Organizations
payee_namf		Committee to Re-Elect John		Maria		None		None		Kim		Kim		Juan		Kailee		Councilmember		Phillip		Vincent		Mike		Faisal		Faisal		Committee to Elect Dave		Kelly		Channing		None		Sara		Sara		Christy		Christy		Yes on E		Kelsey		None		Carol		James		James		Tina		Tim		Josh		Josh		Kim		Re-Elect		Cliff		Liz		Traci		Cottie		Rex		None		Fauzia		Andrea		Natalie		None		Miguel		Pilar		Pilar		Gloria		None		Re-Elect Tony		Helen		Avelino		Kassandra		None		Committee to Re-Elect John		Maria		None		None		Kim		Kim		Juan		Kailee		Councilmember		Phillip		Vincent		Mike		Faisal		Faisal		Committee to Elect Dave		Kelly		Channing		None		Sara		Sara		Christy		Christy		Yes on E		Kelsey		None		Carol		James		James		Tina		Tim		Josh		Josh		Kim		Re-Elect		Cliff		Liz		Traci		Cottie		Rex		None		Fauzia		Andrea		Natalie		None		Miguel		Pilar		Pilar		Gloria		None		Re-Elect Tony		Helen		Avelino		Kassandra		None
payee_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
payee_city		Long Beach		Los Angeles		Norwalk		Moreno Valley		Irvine		Irvine		Sacramento		Long Beach		Los Angeles		Yorba Linda		Palmdale		Encino		Los Angeles		Los Angeles		Palmdale		Encino		Rialto		Santa Maria		Los Angeles		Los Angeles		Sacramento		Sacramento		Oakland		Encino		Los Angeles		Los Angeles		Santa Barbara		Santa Barbara		Los Angeles		Los Angeles		Fullerton		Fullerton		Santa Ana		Long Beach		Torrance		Sacramento		Venice		Los Angeles		Long Beach		Long Beach		Corona		Sacramento		Santa Ana		San Diego		Sherman Oaks		Chatsworth		Chatsworth		Santa Barbara		Sacramento		Oakland		San Bernardino		Long Beach		Rancho Cucamonga		Sacramento		Long Beach		Los Angeles		Norwalk		Moreno Valley		Irvine		Irvine		Sacramento		Long Beach		Los Angeles		Yorba Linda		Palmdale		Encino		Los Angeles		Los Angeles		Palmdale		Encino		Rialto		Santa Maria		Los Angeles		Los Angeles		Sacramento		Sacramento		Oakland		Encino		Los Angeles		Los Angeles		Santa Barbara		Santa Barbara		Los Angeles		Los Angeles		Fullerton		Fullerton		Santa Ana		Long Beach		Torrance		Sacramento		Venice		Los Angeles		Long Beach		Long Beach		Corona		Sacramento		Santa Ana		San Diego		Sherman Oaks		Chatsworth		Chatsworth		Santa Barbara		Sacramento		Oakland		San Bernardino		Long Beach		Rancho Cucamonga		Sacramento
payee_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		90815		90017		90650		92551		92618		92618		95814		90806		90010		92886		93552		91436		90017		90017		93550		94136		92377		93455		90023		90023		95815		95815		94607		91436		90004		90071		93101		93101		90071		90017		92835		92835		92704		90802		90505		95814		90291		90025		90802		90802		92879		95815		92704		92123		91423		91311		91311		93101		95814		94607		92408		90802		91739		95814		90815		90017		90650		92551		92618		92618		95814		90806		90010		92886		93552		91436		90017		90017		93550		94136		92377		93455		90023		90023		95815		95815		94607		91436		90004		90071		93101		93101		90071		90017		92835		92835		92704		90802		90505		95814		90291		90025		90802		90802		92879		95815		92704		92123		91423		91311		91311		93101		95814		94607		92408		90802		91739		95814
expn_date		2022-09-08 00:00:00		2022-09-08 00:00:00		2022-07-18 00:00:00		2022-09-20 00:00:00		2022-09-01 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-08 00:00:00		2022-09-08 00:00:00		2022-09-01 00:00:00		2022-08-18 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-08-30 00:00:00		2022-08-18 00:00:00		2022-09-07 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-08-08 00:00:00		2022-08-08 00:00:00		2022-07-18 00:00:00		2022-09-08 00:00:00		2022-09-14 00:00:00		2022-08-18 00:00:00		2022-09-07 00:00:00		2022-09-01 00:00:00		2022-07-21 00:00:00		2022-08-01 00:00:00		2022-09-08 00:00:00		2022-09-01 00:00:00		2022-07-18 00:00:00		2022-09-01 00:00:00		2022-09-07 00:00:00		2022-08-01 00:00:00		2022-09-08 00:00:00		2022-09-01 00:00:00		2022-07-19 00:00:00		2022-09-01 00:00:00		2022-09-09 00:00:00		2022-09-07 00:00:00		2022-07-18 00:00:00		2022-09-08 00:00:00		2022-07-18 00:00:00		2022-08-19 00:00:00		2022-08-08 00:00:00		2022-08-08 00:00:00		2022-08-23 00:00:00		2022-09-20 00:00:00		2022-08-30 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-07 00:00:00		2022-09-20 00:00:00		2022-07-14 00:00:00		2022-09-08 00:00:00		2022-09-08 00:00:00		2022-07-18 00:00:00		2022-09-20 00:00:00		2022-09-01 00:00:00		2022-09-07 00:00:00		2022-09-07 00:00:00		2022-09-08 00:00:00		2022-09-08 00:00:00		2022-09-01 00:00:00		2022-08-18 00:00:00		2022-07-18 00:00:00		2022-07-18 00:00:00		2022-08-30 00:00:00		2022-08-18 00:00:00		2022-09-07 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-08-08 00:00:00		2022-08-08 00:00:00		2022-07-18 00:00:00		2022-09-08 00:00:00		2022-09-14 00:00:00		2022-08-18 00:00:00		2022-09-07 00:00:00		2022-09-01 00:00:00		2022-07-21 00:00:00		2022-08-01 00:00:00		2022-09-08 00:00:00		2022-09-01 00:00:00		2022-07-18 00:00:00		2022-09-01 00:00:00		2022-09-07 00:00:00		2022-08-01 00:00:00		2022-09-08 00:00:00		2022-09-01 00:00:00		2022-07-19 00:00:00		2022-09-01 00:00:00		2022-09-09 00:00:00		2022-09-07 00:00:00		2022-07-18 00:00:00		2022-09-08 00:00:00		2022-07-18 00:00:00		2022-08-19 00:00:00		2022-08-08 00:00:00		2022-08-08 00:00:00		2022-08-23 00:00:00		2022-09-20 00:00:00		2022-08-30 00:00:00		2022-09-20 00:00:00		2022-09-20 00:00:00		2022-09-07 00:00:00		2022-09-20 00:00:00		2022-07-14 00:00:00
amount		2500		1300		2500		1500		4000		4900		5000		400		-800		5000		5000		5000		1500		-1500		4900		1300		1000		500		-1500		-2500		2500		2500		75000		2500		1500		5000		-2000		2000		2500		800		9700		2500		2200		5000		-1000		4900		800		5000		900		400		1000		-4900		800		2500		-2500		-2500		9500		500		-7800		5000		500		5000		1500		10000		2500		1300		2500		1500		4000		4900		5000		400		-800		5000		5000		5000		1500		-1500		4900		1300		1000		500		-1500		-2500		2500		2500		75000		2500		1500		5000		-2000		2000		2500		800		9700		2500		2200		5000		-1000		4900		800		5000		900		400		1000		-4900		800		2500		-2500		-2500		9500		500		-7800		5000		500		5000		1500		10000
cum_ytd		2500		1300		2500		1500		8900		8900		5000		400		0		12000		5000		5000		0		0		4900		1300		1000		500		-1500		-1500		7500		7500		75000		2500		1500		5000		2000		2000		2500		800		12200		12200		3200		6500		0		4900		800		7500		1800		400		1000		0		1800		2500		0		9500		9500		500		8100		8500		1000		12500		3900		10000		2500		1300		2500		1500		8900		8900		5000		400		0		12000		5000		5000		0		0		4900		1300		1000		500		-1500		-1500		7500		7500		75000		2500		1500		5000		2000		2000		2500		800		12200		12200		3200		6500		0		4900		800		7500		1800		400		1000		0		1800		2500		0		9500		9500		500		8100		8500		1000		12500		3900		10000
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_chkno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
expn_code		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		MON		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB		CTB
expn_dscr		None		None		None		None		None		None		None		None		Void Check		None		None		None		None		Void Check		None		None		None		None		Void Check		Void Check		None		None		None		None		None		None		Void Check		None		None		None		None		None		None		None		Void Check		None		None		None		None		None		None		Void Check		None		None		Void Check		Void Check		None		None		Void Check		None		None		None		None		None		None		None		None		None		None		None		None		None		Void Check		None		None		None		None		Void Check		None		None		None		None		Void Check		Void Check		None		None		None		None		None		None		Void Check		None		None		None		None		None		None		None		Void Check		None		None		None		None		None		None		Void Check		None		None		Void Check		Void Check		None		None		Void Check		None		None		None		None		None
agent_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
agent_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		1370323		1449077		1392470		1440069		1443808		1443808		1443329		1446626		1360884		1434989		1354662		1436882		1437323		1437323		1450689		1449110		1419577		1448673		1438882		1438882		1439961		1439961		1452637		1448396		1448974		1452345		1401816		1401816		1444546		1449036		1435010		1435010		1442910		1442902		1437154		1443078		1449034		1435043		1443096		1443373		1445659		1439409		1439463		741906		1435164		1438397		1438397		1407086		1219570		1414313		1435791		1446169		1445396		1448694
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		John Allen		Maria Brenes		Gabriel Buena		Ulises Cabrera		Kim Carr		Kim Carr		Juan Carrillo		Kailee Caruso		Gil Cedillo (O)		Phillip Chen		Vincent Dino		Mike Fong		Faisal Gill		Faisal Gill		Dave Gomez		Kelly Gonez		Channing Hawkins		Maribel Aguilera-Hernandez		Sara Hernandez		Sara Hernandez		Christy Holstege		Christy Holstege		None		Kelsey Iino		Paul Koretz		Carol Kwan		James Kyriaco		James Kyriaco		Tina McKinnor		Tim McOsker		Josh Newman		Josh Newman		Kim Nguyen		Uduak-Joe Ntuk		Cliff Numark		Liz Ortega-Toro		Traci Park		Cottie Petrie-Norris		Rex Richardson		Joni Ricks-Oddie		Fauzia Rizvi		Andrea Rosenthal		Natalie Rubalcava		San Diego County Democratic Party		Miguel Santiago		Pilar Schiavo		Pilar Schiavo		Gloria Soto		The Plumbing Piping & Mechanical Contractors PAC Sponsored by CA Legis. Conference of Plumbing		Tony Thurmond		Helen Tran		Avelino Valencia		Kassandra Wilson		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		OTH		OTH		OTH		MAY		SEN		SEN		ASM		CCM		CCM		ASM		OTH		ASM		CAT		CAT		CCM		OTH		OTH		CCM		OTH		OTH		ASM		ASM		None		OTH		OTH		OTH		CCM		CCM		ASM		CCM		SEN		SEN		CSU		OTH		MAY		ASM		CCM		ASM		MAY		CCM		ASM		ASM		CCM		None		ASM		ASM		ASM		CCM		None		SUP		MAY		ASM		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
offic_dscr		Board Member		Board Member		Board Member		None		None		None		None		None		None		None		Board Member		None		None		None		None		Board Member		Board Member		None		Board Member		Board Member		None		None		None		Board Member		Controller		Board Member		None		None		None		None		None		None		None		Board Member		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Board Member		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		OTH		OTH		OTH		OTH		SEN		SEN		ASM		OTH		OTH		ASM		OTH		ASM		OTH		OTH		OTH		OTH		OTH		OTH		OTH		OTH		ASM		ASM		None		OTH		OTH		OTH		OTH		OTH		ASM		OTH		SEN		SEN		OTH		OTH		OTH		ASM		OTH		ASM		OTH		OTH		ASM		ASM		OTH		None		ASM		ASM		ASM		OTH		None		STW		OTH		ASM		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
juris_dscr		Long Beach Water Commission		Los Angeles Unified School District		Los Angeles Community College District		City of Moreno Valley		None		None		None		City of Long Beach		City of Los Angeles		None		Palmdale Water District		None		City of Los Angeles		City of Los Angeles		City of Palmdale		Los Angeles Unified School District		West Valley Water District		City of Santa Maria		Los Angeles Community College District		Los Angeles Community College District		None		None		None		Los Angeles Community College District		City of Los Angeles		West Basin Water Board		City of Goleta		City of Goleta		None		City of Los Angeles		None		None		Orange County		Long Beach Community College District		City of Torrance		None		City of Los Angeles		None		City of Long Beach		City of Long Beach		None		None		City of Anaheim		None		None		None		None		City of Santa Maria		None		None		City of San Bernardino		None		Chaffey Union High School District		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		3		2		6		None		36		36		39		3		1		59		5		49		None		None		3		6		4		None		4		4		47		47		None		7		None		1		2		2		61		15		29		29		2		1		None		20		11		73		None		9		63		39		3		None		54		40		40		3		None		None		None		68		4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Affordable Housing - Board of Supervisors		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Yes to Safeguard San Diego Infrastructure, sponsored by Labor and Community Organizations		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		E		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		City and County of San Francisco		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
g_from_e_f		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_filings

filer_id		1021564
filing_id		2724953
period_id		251
form_id		F460
filing_sequence		0
filing_date		2022-09-28 00:00:00
stmnt_type		10001
stmnt_status		11003
session_id		2021
user_id		CAFILER
special_audit		11003
fine_audit		11003
rpt_start		2022-07-01 00:00:00
rpt_end		2022-09-24 00:00:00
rpt_date		2022-09-28 00:00:00
filing_type		22001

Table: filings

filing_id		2724953
filing_type		22001

Table: hdr

filing_id		2724953
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		2724953
amend_id		0
line_item		1
rec_type		RCPT
form_type		C
tran_id		NON2590
entity_cd		OTH
ctrib_naml		Southern California Pipe Trades District Council No. 16
ctrib_namf		None
ctrib_namt		None
ctrib_nams		None
ctrib_city		Los Angeles
ctrib_st		CA
ctrib_zip4		90020
ctrib_emp		None
ctrib_occ		None
ctrib_self		None
tran_type		None
rcpt_date		2022-07-18 00:00:00
date_thru		None
amount		1639
cum_ytd		16386
cum_oth		None
ctrib_dscr		Legal and Reporting Services
cmte_id		None
tres_naml		None
tres_namf		None
tres_namt		None
tres_nams		None
tres_city		None
tres_st		None
tres_zip4		None
intr_naml		None
intr_namf		None
intr_namt		None
intr_nams		None
intr_city		None
intr_st		None
intr_zip4		None
intr_emp		None
intr_occ		None
intr_self		None
cand_naml		None
cand_namf		None
cand_namt		None
cand_nams		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
memo_code		X
memo_refno		None
bakref_tid		None
xref_schnm		None
xref_match		None
int_rate		None
intr_cmteid		None

Table: smry

filing_id		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953
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
line_item		1		2		3		4		5		6		7		8		9		10		11		12		13		14		15		16		17		18		19		1		2		3		1		2		3		1		2		3		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
form_type		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		169018		0		169018		0		169018		181321		0		181321		3157		0		184478		1142543		169018		0		181321		1130240		0		0		3157		0		169018		169018		0		0		0		0		0		0		181300		0		181300		181300		21		0		181321		3157		0		3157		0		0		0		0		0		0		0
amount_b		531917		0		531917		0		531917		414064		0		414064		3157		0		417221		None		None		None		None		None		None		None		None		None		None		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
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

Table: splt

filing_id		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953		2724953
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
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
pform_type		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D
ptran_id		EXP2604		EXP2614		EXP2610		EXP2606		EXP2606		EXP2575		EXP2575		EXP2591		EXP2578		EXP2578		EXP2619		EXP2619		EXP2636		EXP2581		EXP2623		EXP2577		EXP2577		EXP2602		EXP2602		EXP2605		EXP2603		EXP2603		EXP2572		EXP2615		EXP2598		EXP2598		EXP2586		EXP2586		EXP2597		EXP2597		EXP2632		EXP2632		EXP2633		EXP2633		EXP2612		EXP2612
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		2024-01-01 00:00:00		2024-01-01 00:00:00		2024-01-01 00:00:00		2024-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		2022-01-01 00:00:00		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		8900		8900		5000		7000		5000		9700		5000		4900		2500		5000		2500		5000		0		0		2500		9700		2500		9700		2500		4900		2500		5000		1000		0		9700		0		9700		9700		9700		9700		16200		8500		500		500		7500		5000
elec_code		G		G		G		P		G		P		G		G		P		G		P		G		P		P		G		P		G		P		G		G		P		G		G		P		P		G		P		G		P		G		P		G		P		G		P		G