Home

Filing ID: 2743817

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

Table: cvr2_campaign_disclosure

filing_id		2743817		2743817
amend_id		0		0
line_item		1		2
rec_type		CVR2		CVR2
form_type		F460		F460
tran_id		OFC4		NIC3
entity_cd		ATR		COM
title		None		None
mail_city		None		None
mail_st		None		None
mail_zip4		None		None
f460_part		3		5b
cmte_id		None		1414018
enty_naml		Deane		Newsom for California Governor 2022
enty_namf		Shawnda		None
enty_namt		None		None
enty_nams		None		None
enty_city		Sacramento		Sacramento
enty_st		CA		CA
enty_zip4		95815		95815
enty_phon		(916) 285-5733		(916) 285-5733
enty_fax		(916) 333-1344		None
enty_email		None		None
tres_naml		None		Newsom
tres_namf		None		Gavin
tres_namt		None		None
tres_nams		None		None
control_yn		None		Y
office_cd		None		None
offic_dscr		None		None
juris_cd		None		None
juris_dscr		None		None
dist_no		None		None
off_s_h_cd		None		None
bal_name		None		None
bal_num		None		None
bal_juris		None		None
sup_opp_cd		None		None

Table: cvr3_verification_info

filing_id		2743817		2743817
amend_id		0		0
line_item		1		2
rec_type		CVR3		CVR3
form_type		F460		F460
tran_id		LGAGE.1		VER_2.2
entity_cd		ATR		CAO
sig_date		2022-10-26 00:00:00		2022-10-26 00:00:00
sig_loc		None		None
sig_naml		Shawnda Deane		Gavin Newsom
sig_namf		None		None
sig_namt		None		None
sig_nams		None		None

Table: cvr_campaign_disclosure

filing_id		2743817
amend_id		0
rec_type		CVR
form_type		F460
filer_id		1380675
entity_cd		RCP
filer_naml		Governor Newsom's Ballot Measure Committee
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		Sacramento
filer_st		CA
filer_zip4		95815
filer_phon		(916) 285-5733
filer_fax		(916) 333-1344
file_email		[email protected]
mail_city		None
mail_st		None
mail_zip4		None
tres_naml		Newsom
tres_namf		Gavin
tres_namt		None
tres_nams		None
tres_city		Sacramento
tres_st		CA
tres_zip4		95815
tres_phon		(916) 285-5733
tres_fax		None
tres_email		None
cmtte_type		G
control_yn		N
sponsor_yn		N
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		Newsom
cand_namf		Gavin
cand_namt		None
cand_nams		None
cand_city		Sacramento
cand_st		CA
cand_zip4		95815
cand_phon		(916) 285-5733
cand_fax		(916) 333-1344
cand_email		None
bal_name		None
bal_num		None
bal_juris		Statewide
office_cd		GOV
offic_dscr		None
juris_cd		STW
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		2743817		2743817		2743817		2743817		2743817		2743817
amend_id		0		0		0		0		0		0
line_item		1		2		3		4		5		6
rec_type		EXPN		EXPN		EXPN		EXPN		EXPN		EXPN
form_type		E		E		E		E		E		E
tran_id		EXP1229		EXP1222		EXP1224		EXP1226		EXP1227		EXP1231
entity_cd		OTH		OTH		OTH		OTH		OTH		OTH
payee_naml		ActBlue Technical Services		ActBlue Technical Services		ActBlue Technical Services		ActBlue Technical Services		Deane & Company		Olson Remcho, LLP
payee_namf		None		None		None		None		None		None
payee_namt		None		None		None		None		None		None
payee_nams		None		None		None		None		None		None
payee_city		Somerville		Somerville		Somerville		Somerville		Sacramento		Sacramento
payee_st		MA		MA		MA		MA		CA		CA
payee_zip4		02144		02144		02144		02144		95815		95814
expn_date		2022-09-25 00:00:00		2022-09-30 00:00:00		2022-10-02 00:00:00		2022-10-09 00:00:00		2022-10-13 00:00:00		2022-10-20 00:00:00
amount		204		8		2		0		6832		1500
cum_ytd		23042		23042		23042		23042		33146		8907
cum_oth		None		None		None		None		None		None
expn_chkno		None		None		None		None		None		None
expn_code		OFC		OFC		OFC		OFC		PRO		PRO
expn_dscr		None		None		None		None		None		None
agent_naml		None		None		None		None		None		None
agent_namf		None		None		None		None		None		None
agent_namt		None		None		None		None		None		None
agent_nams		None		None		None		None		None		None
cmte_id		None		None		None		None		None		None
tres_naml		None		None		None		None		None		None
tres_namf		None		None		None		None		None		None
tres_namt		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None
tres_city		None		None		None		None		None		None
tres_st		None		None		None		None		None		None
tres_zip4		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None
cand_namf		None		None		None		None		None		None
cand_namt		None		None		None		None		None		None
cand_nams		None		None		None		None		None		None
office_cd		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None
juris_cd		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None
dist_no		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None
bal_name		None		None		None		None		None		None
bal_num		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None
sup_opp_cd		None		None		None		None		None		None
memo_code		None		None		None		None		None		None
memo_refno		None		None		None		None		None		None
bakref_tid		None		None		None		None		None		None
g_from_e_f		None		None		None		None		None		None
xref_schnm		None		None		None		None		None		None
xref_match		None		None		None		None		None		None

Table: filer_filings

filer_id		1380675
filing_id		2743817
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-25 00:00:00
filing_type		22001

Table: filings

filing_id		2743817
filing_type		22001

Table: hdr

filing_id		2743817
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		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817
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
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
rec_type		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT		RCPT
form_type		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		A		I
tran_id		IDT58974		IDT58975		IDT58976		IDT58979		IDT58981		IDT58983		IDT58984		IDT58987		IDT58991		IDT58963		IDT58998		IDT59000		IDT59001		IDT59002		IDT59005		IDT59007		IDT59115		IDT59016		IDT59019		IDT59022		IDT59026		IDT58934		IDT59033		IDT59034		IDT58968		IDT58941		IDT58942		IDT59043		IDT59045		IDT59046		IDT59049		IDT59052		IDT59053		IDT59054		IDT59059		IDT59065		IDT59067		IDT58948		IDT59068		IDT58950		IDT59076		IDT59080		IDT59082		IDT59084		IDT59085		IDT58952		IDT58955		IDT59089		IDT58957		IDT59099		IDT59101		IDT59105		IDT59107		IDT59108		IDT59109		IDT59112		INC1230
entity_cd		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		IND		OTH
ctrib_naml		Arnaout		Arzola		Aslan		Bankston		Benoit		Beringer		Bernier		Bowyer		Brody		Brody		Charles		Chomba		Clarey		Cooper		Cowman		Crawford		Crouch		Fleig		Gardiner		Gonnelli		Gray		Harris		Hodgin		Howell		Jackson		Kinsey		Kyle		Landau		Lavagetto		Livingston		Majd		May		McGuire		McQuaid		Morehouse		Padilla		Parker		Parker		Parrish		Proctor		Quigley-Neel		Roach		Roper		Samar		Sanders		Schiller		Senesi		Sennish		Stone		Talamantes		Tierk		Uyekawa		Venezia		Vue		Walker		Willis		First Foundation Bank
ctrib_namf		Walid		Kelley		Mahdi		Helen		Rikayah		Susan		Alex		Lisa		William		William		Maria		Wanja		Alan		Lana		Stephanie		Elizabeth		Kristy		James		Lauri		Carly		Ashley		Jan		Kelly		Gale		Gianna		Heather		Mary		Wrennie		Ernest		Pamela		Nazli		Lance		Gail		Yvonne		Zackery		Ramon		Katherine		Kristin		Me		Laine		Marcia		Mary		Sharon		Ladan		Lynn		Roberta		Basile		Maggie		Melanie		Angela		Eric		Colleen		Sara		Mai Summer		Shannon		Kim		None
ctrib_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_city		Thousand Oaks		Rancho Cordova		Newport Beach		San Luis Obispo		Redlands		Los Altos Hills		San Jose		Riverside		San Rafael		San Rafael		Santa Barbara		Fremont		Winters		Cool		Sunnyvale		Larkspur		Oceanside		Lafayette		Rancho Cucamonga		Brentwood		San Luis Obispo		Sebastopol		Morgan Hill		Santa Barbara		Williamstown		Carmichael		Huntington Beach		Culver City		Walnut Creek		Sacramento		Los Angeles		Albany		Berkeley		Chico		Elk Grove		Modesto		Vista		Norco		Walnut Creek		Panorama City		Vista		Mount Shasta		San Jose		Irvine		Angwin		Los Angeles		San Rafael		Culver City		Redwood City		Sylmar		Agoura Hills		Yorba Linda		San Marcos		Fresno		Fresno		Three Rivers		Sacramento
ctrib_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		NJ		CA		CA		CA		CA		CA		CA		OR		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
ctrib_zip4		91360		95670		92660		93405		92373		94024		95110		92506		94903		94903		93103		94536		95694		95614		94087		94939		92054		94549		91730		94513		93401		95472		95037		93108		08094		95608		92646		90230		94596		95825		90034		97321		94708		95928		95757		95351		92081		92860		94595		91402		93084		96067		95111		92604		94508		90034		94903		90230		94062		91342		91301		92887		92078		93722		93711		93721		95815
ctrib_emp		Walid Arnaout		State of California		Koala Capital		n/a		Patton State Hospital		Gibson Dunn		Facebook		Riverside Unified School District		n/a		n/a		University of California, Santa Barbara		Privacy & Party Governance		Canyon Creek Resort		n/a		Arrow Electronics		University of California, Los Angeles		Kristy Crouch		n/a		Fontana Unified School District		n/a		n/a		n/a		n/a		n/a		The Teachers Insurance & Annuity Association of America-College Retirement Equities Fund (TIAA)		n/a		n/a		n/a		n/a		n/a		Nazli Majd		n/a		Mission Housing Development Corporation		n/a		American Medical Response, Inc.		n/a		KPMG, LLP		Kristin Parker		San Ramon Valley Unified School District		Laine Proctor		n/a		Medtronic, Inc.		Santa Clara County Superior Court		n/a		Lynn Sanders		Dr. Don Schiller		Arc Technologies		Maggie Sennish		Plasticity Online		Los Angeles Unified School District		Eric Tierk		Colleen Uyekawa		University of California, San Diego		n/a		Realtors.com		n/a		None
ctrib_occ		Physician		Associate Governmental Program Analyst		Manager		Not Employed		Social Worker		Attorney		Manager		Teacher		Not Employed		Not Employed		Professor		Tech Manager		Manager		Not Employed		Material Planner		Genetic Counselor		Mortgage Underwriting		Not Employed		Teacher		Not Employed		Not Employed		Not Employed		Not Employed		Not Employed		Vice President of Corporate Social Responsibility		Not Employed		Not Employed		Not Employed		Retired		Not Employed		Dentist		Not Employed		Project Developer		Not Employed		Paramedic		Not Employed		Marketing Director		Licensed Marriage and Family Therapist		Teacher		Bookkeeper		Not Employed		Clinical Specialist		Attorney		Not Employed		Therapist		Medical Secretary		Chief Revenue Officer		Psychotherapist		President		Teacher		Therapist		Therapist		Pharmacist		Not Employed		Realtor		Not Employed		None
ctrib_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tran_type		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		I		None
rcpt_date		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-30 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-10-06 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-30 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-10-01 00:00:00		2022-09-27 00:00:00		2022-09-27 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-26 00:00:00		2022-09-25 00:00:00		2022-09-26 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-25 00:00:00		2022-09-26 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-25 00:00:00		2022-09-30 00:00:00
date_thru		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amount		50		25		20		25		25		100		25		100		100		-100		100		25		25		25		25		20		-100		500		50		25		25		25		25		100		25		25		25		20		25		25		100		50		10		25		25		100		25		25		25		25		25		25		25		25		25		50		20		20		25		25		25		25		25		100		25		50		658
cum_ytd		200		100		160		100		100		400		100		400		300		300		400		100		100		175		100		110		300		2000		200		100		100		100		100		400		175		100		100		160		100		125		400		200		130		100		100		400		100		100		100		100		100		100		100		100		100		300		160		160		100		100		100		100		100		400		100		200		0
cum_oth		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Interest Earned
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		None		None		None
tres_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
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
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
intr_naml		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		ActBlue		None
intr_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_city		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		Somerville		None
intr_st		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		MA		None
intr_zip4		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		02144		None
intr_emp		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_occ		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_self		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
office_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
memo_refno		None		None		None		None		None		None		None		None		None		IDT58963		None		None		None		None		None		None		IDT59115		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
int_rate		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_cmteid		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: smry

filing_id		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817		2743817
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		3017		0		3017		0		3017		8546		0		8546		0		0		8546		5531982		3017		658		8546		5527112		0		0		0		2310		707		3017		0		0		0		0		0		0		0		0		0		8546		0		0		8546		0		0		0		0		0		0		658		0		0		658
amount_b		1773356		0		1773356		25684		1799040		227232		0		227232		0		25684		252916		None		None		None		None		None		None		None		None		None		None		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