Home

Filing ID: 2740231

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

Table: cvr2_campaign_disclosure

filing_id		2740231
amend_id		0
line_item		1
rec_type		CVR2
form_type		F460
tran_id		9c466dff00484337bc5
entity_cd		ATR
title		None
mail_city		None
mail_st		None
mail_zip4		None
f460_part		3
cmte_id		830078
enty_naml		Wachholz
enty_namf		Mark
enty_namt		None
enty_nams		None
enty_city		Chicago
enty_st		IL
enty_zip4		60631-3512
enty_phon		(847) 297-7800
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: cvr_campaign_disclosure

filing_id		2740231
amend_id		0
rec_type		CVR
form_type		F460
filer_id		830078
entity_cd		RCP
filer_naml		American Property Casualty Insurance Association California Political Action Committee (MPO)
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-25 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		Chicago
filer_st		IL
filer_zip4		60631-3512
filer_phon		(847) 297-7800
filer_fax		None
file_email		None
mail_city		None
mail_st		None
mail_zip4		None
tres_naml		Holmes
tres_namf		June
tres_namt		None
tres_nams		None
tres_city		Chicago
tres_st		IL
tres_zip4		60631-3512
tres_phon		(847) 297-7800
tres_fax		None
tres_email		None
cmtte_type		G
control_yn		Y
sponsor_yn		N
primfrm_yn		N
brdbase_yn		N
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: expn

filing_id		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231
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		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN		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		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E		E
tran_id		c017e4f14c9f2fd2923		0c0a13221da73d5887e		379888e7dab326dfe56		3bf45b9d73932c1903d		78e1009e58ee5775d73		f1bc9916a994d2c3c11		89e1a2d1800ca4ee749		8ca2a045a37a7255aa6		b60e954735f8f425d1d		b7df4f70edc2bcf5b80		54b2453f4e373fb3e6e		2469d38338692fda2c8		c4ff4bcda1c2f817524		4febf33aac25aa9c7f9		3a4bcea7f131dff6d03		b159e29299a6c75679b		d42a4cce7912e2b77d1		fff50cdfae358b63ea6		7bf3e19dca2c574f266		9923163261c0a63bac5		c017e4f14c9f2fd2923		0c0a13221da73d5887e		379888e7dab326dfe56		3bf45b9d73932c1903d		78e1009e58ee5775d73		f1bc9916a994d2c3c11		89e1a2d1800ca4ee749		8ca2a045a37a7255aa6		b60e954735f8f425d1d		b7df4f70edc2bcf5b80		54b2453f4e373fb3e6e		2469d38338692fda2c8		c4ff4bcda1c2f817524		4febf33aac25aa9c7f9		3a4bcea7f131dff6d03		b159e29299a6c75679b		d42a4cce7912e2b77d1		fff50cdfae358b63ea6		7bf3e19dca2c574f266		9923163261c0a63bac5
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
payee_naml		A Pipeline Project		Anna Caballero for Senate 2022		Blanca Pacheco for Assembly 2022		Bob Archuleta for Senate 2022		California Republican Party		Committee for Local Resiliency - Lisa Calderon Ballot Measure Committee		David Cortese for Senate 2024		FairPAC IE, Sponsored by the Civil Justice Association of California		Jesse Gabriel for Assembly 2022		Josh Newman for Senate 2024		Lori Wilson for Assembly 2022		Marc Berman for Assembly 2022		Matt Gunderson for Senate 2022		Re-Elect Ken Cooley for Assembly 2022		Rodriguez for Assembly 2022		Rosilicie Ochoa-Bogh for Senate 2024		Sabrina Cervantes for Assembly 2022		Suzette Martinez Valladares for Assembly 2022		Tim Grayson for Assembly 2022		Tina McKinnor for Assembly 2022		A Pipeline Project		Anna Caballero for Senate 2022		Blanca Pacheco for Assembly 2022		Bob Archuleta for Senate 2022		California Republican Party		Committee for Local Resiliency - Lisa Calderon Ballot Measure Committee		David Cortese for Senate 2024		FairPAC IE, Sponsored by the Civil Justice Association of California		Jesse Gabriel for Assembly 2022		Josh Newman for Senate 2024		Lori Wilson for Assembly 2022		Marc Berman for Assembly 2022		Matt Gunderson for Senate 2022		Re-Elect Ken Cooley for Assembly 2022		Rodriguez for Assembly 2022		Rosilicie Ochoa-Bogh for Senate 2024		Sabrina Cervantes for Assembly 2022		Suzette Martinez Valladares for Assembly 2022		Tim Grayson for Assembly 2022		Tina McKinnor for Assembly 2022
payee_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
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
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
payee_city		Sacramento		Sacramento		Long Beach		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Fullerton		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Hilmar		Sacramento		Hilmar		Sacramento		Sacramento		Sacramento		Sacramento		Long Beach		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Fullerton		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Hilmar		Sacramento		Hilmar		Sacramento		Sacramento
payee_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
payee_zip4		95815		95814		90802		95814		95814		95814		95814		95814		95814		92835		95815		95814		95814		95841		95814		95324		95815		95324		95815		95835		95815		95814		90802		95814		95814		95814		95814		95814		95814		92835		95815		95814		95814		95841		95814		95324		95815		95324		95815		95835
expn_date		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00		2022-10-18 00:00:00
amount		1000		1000		4000		4900		5000		4900		4900		10000		2000		2900		1000		4900		4000		2400		4900		1500		4900		3000		4300		4900		1000		1000		4000		4900		5000		4900		4900		10000		2000		2900		1000		4900		4000		2400		4900		1500		4900		3000		4300		4900
cum_ytd		1000		3000		6000		4900		5000		4900		4900		10000		2000		4900		3000		7800		4000		7300		8500		1500		9800		3000		4300		4900		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		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
expn_code		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
expn_dscr		2022 Contribution		2022 General		2022 General		2022 General		2022 Contribution		2022 General		2024 Primary		2022 Contribution		2022 General		2024 Primary		2022 General		2022 General		2022 General		2022 General		2022 General		2024 Primary		2022 General		2022 General		2022 General		2022 General		2022 Contribution		2022 General		2022 General		2022 General		2022 Contribution		2022 General		2024 Primary		2022 Contribution		2022 General		2024 Primary		2022 General		2022 General		2022 General		2022 General		2022 General		2024 Primary		2022 General		2022 General		2022 General		2022 General
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
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
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
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
cmte_id		1413083		1414451		1443511		1414156		810163		1450883		1435449		821251		1434953		1435010		1442763		1435363		1441367		1435371		1435019		1435065		1435160		1435635		1434632		1262979		1413083		1414451		1443511		1414156		810163		1450883		1435449		821251		1434953		1435010		1442763		1435363		1441367		1435371		1435019		1435065		1435160		1435635		1434632		1262979
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
cand_naml		A Pipeline Project		Caballero		Pacheco		Archuleta		California Republican Party		Committee for Local Resiliency - Lisa Caldero		Cortese		FairPAC IE, Sponsored by the Civil Justice As		Gabriel		Newman		Wilson		Berman		Gunderson		Cooley		Rodriguez		Ochoa Bogh		Cervantes		Valladares		Grayson		McKinnor		A Pipeline Project		Caballero		Pacheco		Archuleta		California Republican Party		Committee for Local Resiliency - Lisa Caldero		Cortese		FairPAC IE, Sponsored by the Civil Justice As		Gabriel		Newman		Wilson		Berman		Gunderson		Cooley		Rodriguez		Ochoa Bogh		Cervantes		Valladares		Grayson		McKinnor
cand_namf		None		Anna		Blanca		Bob		None		None		David		None		Jesse		Josh		Lori		Marc		Matt		Ken		Freddie		Rosilicie		Sabrina		Suzette		Timothy		Tina		None		Anna		Blanca		Bob		None		None		David		None		Jesse		Josh		Lori		Marc		Matt		Ken		Freddie		Rosilicie		Sabrina		Suzette		Timothy		Tina
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		SEN		ASM		SEN		None		None		SEN		None		ASM		SEN		ASM		ASM		SEN		ASM		ASM		SEN		ASM		ASM		ASM		ASM		None		SEN		ASM		SEN		None		None		SEN		None		ASM		SEN		ASM		ASM		SEN		ASM		ASM		SEN		ASM		ASM		ASM		ASM
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		SEN		ASM		SEN		None		None		SEN		None		ASM		SEN		ASM		ASM		SEN		ASM		ASM		SEN		ASM		ASM		ASM		ASM		None		SEN		ASM		SEN		None		None		SEN		None		ASM		SEN		ASM		ASM		SEN		ASM		ASM		SEN		ASM		ASM		ASM		ASM
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		012		064		032		None		None		015		None		045		029		011		024		038		008		052		023		060		038		014		062		None		012		064		032		None		None		015		None		045		029		011		024		038		008		052		023		060		038		014		062
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		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
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
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
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

Table: filer_filings

filer_id		1035164
filing_id		2740231
period_id		251
form_id		F460
filing_sequence		0
filing_date		2022-10-25 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-25 00:00:00
filing_type		22001

Table: filings

filing_id		2740231
filing_type		22001

Table: hdr

filing_id		2740231
amend_id		0
rec_type		HDR
ef_type		CAL
state_cd		CA
cal_ver		2.01
soft_name		DDC
soft_ver		1.00
hdrcomment		None

Table: rcpt

filing_id		2740231		2740231		2740231		2740231		2740231		2740231		2740231
amend_id		0		0		0		0		0		0		0
line_item		1		2		3		4		5		6		7
rec_type		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT
form_type		A		A		A		A		A		A		A
tran_id		2022092913136-1		2022092913136-3		2022100613137-1		2022100613137-2		2022100613137-5		202210201396-1		202210201396-2
entity_cd		OTH		OTH		OTH		OTH		OTH		OTH		OTH
ctrib_naml		Aspen American Insurance Company		Medical Professional Mutual Insurance Company		James River Insurance Company		Metromile Insurance Company		Prime Insurance Company		Great American Insurance Company		Homeowners of America Insurance Company
ctrib_namf		None		None		None		None		None		None		None
ctrib_namt		None		None		None		None		None		None		None
ctrib_nams		None		None		None		None		None		None		None
ctrib_city		New York		Boston		Richmond		San Francisco		Sandy		Cincinnati		Irving
ctrib_st		NY		MA		VA		CA		UT		OH		TX
ctrib_zip4		10022-2524		02111		23230-1728		94105-5418		84070-1420		45202-4245		75038-2939
ctrib_emp		None		None		None		None		None		None		None
ctrib_occ		Insurance		Insurance		Insurance		Insurance		Insurance		Insurance		Insurance
ctrib_self		None		None		None		None		None		None		None
tran_type		None		None		None		None		None		None		None
rcpt_date		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-06 00:00:00		2022-10-20 00:00:00		2022-10-20 00:00:00
date_thru		None		None		None		None		None		None		None
amount		798		566		829		119		372		2000		118
cum_ytd		1594		1146		1633		239		658		4016		204
cum_oth		None		None		None		None		None		None		None
ctrib_dscr		None		None		None		None		None		None		None
cmte_id		None		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None
tres_city		None		None		None		None		None		None		None
tres_st		None		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None		None
intr_naml		None		None		None		None		None		None		None
intr_namf		None		None		None		None		None		None		None
intr_namt		None		None		None		None		None		None		None
intr_nams		None		None		None		None		None		None		None
intr_city		None		None		None		None		None		None		None
intr_st		None		None		None		None		None		None		None
intr_zip4		None		None		None		None		None		None		None
intr_emp		None		None		None		None		None		None		None
intr_occ		None		None		None		None		None		None		None
intr_self		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None		None
office_cd		None		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None		None
juris_cd		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None
sup_opp_cd		None		None		None		None		None		None		None
memo_code		None		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None		None
xref_match		None		None		None		None		None		None		None
int_rate		None		None		None		None		None		None		None
intr_cmteid		None		None		None		None		None		None		None

Table: smry

filing_id		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231
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
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		4		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
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		C		C		C		I		I		I		I		D		D		D		E		E		E		E
amount_a		4891		0		4891		0		4891		76400		0		76400		0		0		76400		108697		4891		0		76400		37188		0		0		0		0		0		4802		89		4891		0		0		0		0		0		0		0		76400		0		76400		76400		0		0		76400
amount_b		214060		0		214060		0		214060		431208		0		431208		0		0		431208		None		None		None		None		None		None		None		None		0		0		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
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

Table: splt

filing_id		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231		2740231
amend_id		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
pform_type		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D		D
ptran_id		c017e4f14c9f2fd2923		0c0a13221da73d5887e		379888e7dab326dfe56		3bf45b9d73932c1903d		78e1009e58ee5775d73		f1bc9916a994d2c3c11		89e1a2d1800ca4ee749		8ca2a045a37a7255aa6		b60e954735f8f425d1d		b7df4f70edc2bcf5b80		54b2453f4e373fb3e6e		2469d38338692fda2c8		c4ff4bcda1c2f817524		4febf33aac25aa9c7f9		3a4bcea7f131dff6d03		b159e29299a6c75679b		d42a4cce7912e2b77d1		fff50cdfae358b63ea6		7bf3e19dca2c574f266		9923163261c0a63bac5
elec_date		2022-11-01 00:00:00		2022-11-01 00:00:00		2022-11-01 00:00:00		2022-11-01 00:00:00		2022-11-01 00:00:00		2022-11-01 00:00:00		2024-11-01 00:00:00		2022-11-01 00:00:00		2022-11-01 00:00:00		2024-11-01 00:00:00		2022-11-01 00:00:00		2022-11-01 00:00:00		2022-11-01 00:00:00		2022-11-01 00:00:00		2022-11-01 00:00:00		2024-11-01 00:00:00		2022-11-01 00:00:00		2022-11-01 00:00:00		2022-11-01 00:00:00		2022-11-01 00:00:00
elec_amount		0		1000		4000		4900		0		4900		4900		0		2000		4900		1000		4900		4000		4900		4900		1500		4900		3000		4900		4900
elec_code		G		G		G		G		G		G		P		G		G		P		G		G		G		G		G		P		G		G		G		G