Home

Filing ID: 2743915

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

Table: cvr3_verification_info

filing_id		2743915
amend_id		0
line_item		1
rec_type		CVR3
form_type		F401
tran_id		VER_1.1
entity_cd		TRE
sig_date		2022-10-27 00:00:00
sig_loc		None
sig_naml		JAMES R. SUTTON
sig_namf		None
sig_namt		None
sig_nams		None

Table: cvr_campaign_disclosure

filing_id		2743915
amend_id		0
rec_type		CVR
form_type		F401
filer_id		1342688
entity_cd		SMO
filer_naml		SAN FRANCISCO FIREFIGHTERS SLATE CARD
filer_namf		None
filer_namt		None
filer_nams		None
report_num		000
rpt_date		2022-10-27 00:00:00
stmt_type		None
late_rptno		None
from_date		2022-09-25 00:00:00
thru_date		2022-10-22 00:00:00
elect_date		None
filer_city		SAN FRANCISCO
filer_st		CA
filer_zip4		94108
filer_phon		4157327700
filer_fax		None
file_email		None
mail_city		None
mail_st		None
mail_zip4		None
tres_naml		SUTTON
tres_namf		JAMES R.
tres_namt		None
tres_nams		None
tres_city		SAN FRANCISCO
tres_st		CA
tres_zip4		94108
tres_phon		4157327700
tres_fax		None
tres_email		None
cmtte_type		None
control_yn		None
sponsor_yn		None
primfrm_yn		None
brdbase_yn		None
amendexp_1		None
amendexp_2		None
amendexp_3		None
rpt_att_cb		None
cmtte_id		None
reportname		None
rptfromdt		None
rptthrudt		None
emplbus_cb		None
bus_name		None
bus_city		None
bus_st		None
bus_zip4		None
bus_inter		None
busact_cb		None
busactvity		None
assoc_cb		None
assoc_int		None
other_cb		None
other_int		None
cand_naml		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: filer_filings

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

Table: filings

filing_id		2743915
filing_type		22001

Table: hdr

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

Table: rcpt

filing_id		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915
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
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
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
form_type		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A		F401A
tran_id		IDT39		IDT41		IDT40		INC352		INC354		IDT44		IDT43		IDT42		IDT46		IDT47		IDT45		IDT48		IDT49		IDT50		IDT55		IDT65		INC367		IDT54		IDT56		IDT58		IDT59		IDT57		IDT60		IDT62		IDT76		IDT78		IDT75		IDT79		IDT74		IDT77		IDT73		IDT71		IDT67		IDT70		IDT66		IDT69		IDT72		IDT68		IDT85		IDT87		IDT81		IDT80		IDT83		IDT84		IDT88		IDT86		IDT61		IDT64		IDT63
entity_cd		OTH		OTH		OTH		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		COM		OTH		COM		COM		COM		OTH		OTH		OTH		OTH		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
ctrib_naml		SAN FRANCISCO BUILDING & CONSTRUCTION TRADES COUNCIL ISSUES COMMITTEE		SAN FRANCISCO BUILDING & CONSTRUCTION TRADES COUNCIL ISSUES COMMITTEE		SAN FRANCISCO BUILDING & CONSTRUCTION TRADES COUNCIL ISSUES COMMITTEE		YES ON A: RESTORE RETIRED CITY WORKERS EARNED BENEFITS, SPONSORED BY PROTECT OUR BENEFITS		ROB BONTA FOR CA ATTORNEY GENERAL 2022		BETTER ROADS AND TRANSIT, YES ON L		LAINIE MOTAMEDI FOR SAN FRANCISCO BOARD OF EDUCATION 2022		LISA WEISSMAN-WARD FOR SAN FRANCISCO BOARD OF EDUCATION 2022		PHIL TING FOR ASSEMBLY 2022		SHAMANN WALTON FOR SUPERVISOR 2022		YES ON C, HOMELESSNESS ACCOUNTABILITY NOW		GORDON MAR FOR DISTRICT 4 SUPERVISOR		MANO RAJU FOR PUBLIC DEFENDER 2022		BETTER ROADS AND TRANSIT, YES ON L		RAFAEL MANDELMAN FOR SUPERVISOR 2022		SAN FRANCISCO BUILDING & CONSTRUCTION TRADES		CATHERINE STEFANI FOR SUPERVISOR 2022		MALIA COHEN FOR CONTROLLER 2022		MATT HANEY FOR ASSEMBLY 2022		CRUISE LLC(PRASHANTHI RAMAN)		CRUISE LLC(PRASHANTHI RAMAN)		CRUISE LLC(PRASHANTHI RAMAN)		CRUISE LLC(PRASHANTHI RAMAN)		RE-ELECT FIONA MA FOR STATE TREASURER 2022		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		SAN FRANCISCO FIREFIGHTERS LOCAL 798 PAC		WORKERS AND NEIGHBORS FOR CITY COLLEGE		SAN FRANCISCO LABOR COUNCIL LABOR & NEIGHBOR PAC		SAN FRANCISCO LABOR COUNCIL LABOR & NEIGHBOR PAC
ctrib_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
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
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
ctrib_city		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		OAKLAND		ALAMEDA		OAKLAND		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		NOVATO		NOVATO		OAKLAND		OAKLAND		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		OAKLAND		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO
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		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		94109		94109		94109		94607		94501		94607		94122		94110		95841		94104		94118		94949		94949		94607		94607		94109		94108		95815		94607		94103		94103		94103		94103		95864		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94103		94107		94109		94109
ctrib_emp		None		None		None		None		None		None		SFUSD		STANFORD		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_occ		None		None		None		None		None		None		COMMISSIONER		LECTURER		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_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
tran_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpt_date		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-09-27 00:00:00		2022-09-29 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-09-30 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-04 00:00:00		2022-10-05 00:00:00		2022-10-05 00:00:00		2022-10-07 00:00:00		2022-10-11 00:00:00		2022-10-12 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-13 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-14 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-17 00:00:00		2022-10-20 00:00:00		2022-10-21 00:00:00		2022-10-21 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
amount		5000		5000		5000		5000		1000		25000		100		100		500		500		5000		2000		100		25000		250		10000		250		500		1000		2500		2500		2500		2500		1000		1087		1087		1087		1087		1087		1087		1087		1087		1087		1087		1087		1087		1087		1087		1087		1087		1087		1087		1087		1087		1087		2174		500		1250		1250
cum_ytd		5000		16250		106087		5000		2087		106087		1287		1287		2087		5837		11087		7587		1287		106087		2750		16250		3837		2087		1000		7587		5837		3837		2750		3087		7587		5837		3837		1287		2087		1337		2087		3087		2087		2087		1087		1087		1087		1087		11087		106087		1287		1287		1087		1087		1087		2174		500		16250		5837
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
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
cmte_id		1286295		1286295		1286295		1439319		1437201		1440527		1449659		1449604		1437844		1436079		1451214		1437853		1342688		1440527		1439601		None		1439427		1437983		1441330		None		None		None		None		1414254		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		810802		1448789		941562		941562
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
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
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
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
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
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
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
intr_naml		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
intr_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
intr_emp		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
cand_naml		None		None		None		None		ROB BONTA		None		LAINIE MOTAMEDI		LISA WEISSMAN-WARD		PHIL TING		SHAMANN WALTON		None		GORDON MAR		MANOHAR RAJU		None		RAFAEL MANDELMAN		None		CATHERINE STEFANI		MALIA COHEN		MATT HANEY		GORDON MAR		SHAMANN WALTON		CATHERINE STEFANI		RAFAEL MANDELMAN		FIONA MA		GORDON MAR		SHAMANN WALTON		CATHERINE STEFANI		MANOHAR RAJU		PHIL TING		None		None		FIONA MA		ROB BONTA		MALIA COHEN		GAVIN NEWSOM		SHIRLEY WEBER		TONY THURMOND		ELENI KOUNALAKIS		None		None		LAINIE MOTAMEDI		LISA WEISSMAN-WARD		NO ON B		YES ON A		YES ON O		YES ON E, NO ON D		None		None		SHAMANN WALTON
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
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
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
office_cd		None		None		None		None		ATT		None		BED		BED		ASM		CSU		None		CSU		PDR		None		CSU		None		CSU		TRE		ASM		CSU		CSU		CSU		CSU		TRE		CSU		CSU		CSU		PDR		ASM		CSU		ASM		TRE		ATT		TRE		None		None		None		None		None		None		BED		BED		None		None		None		None		None		None		CSU
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
juris_cd		None		None		None		None		STW		None		OTH		OTH		ASM		OTH		None		OTH		OTH		None		OTH		None		OTH		STW		ASM		OTH		OTH		OTH		OTH		STW		OTH		OTH		OTH		OTH		ASM		CTY		ASM		STW		STW		STW		None		None		None		None		None		None		OTH		OTH		None		None		None		None		None		None		OTH
juris_dscr		None		None		None		None		None		None		SAN FRANCISCO		SAN FRANCISCO		None		SAN FRANCISCO		None		SAN FRANCISCO		SAN FRANCISCO		None		SAN FRANCISCO		None		SAN FRANCISCO		None		None		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		None		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		None		None		None		None		None		None		None		None		None		None		None		None		SAN FRANCISCO		SAN FRANCISCO		None		None		None		None		None		None		SAN FRANCISCO
dist_no		None		None		None		None		None		None		None		None		19		10		None		4		None		None		8		None		2		None		17		4		10		2		8		None		4		10		2		None		19		8		17		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		10
off_s_h_cd		None		None		None		None		H		None		None		None		H		H		None		H		H		None		None		None		None		S		H		H		H		None		None		H		H		H		None		H		H		None		None		H		H		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		H
bal_name		Public Works Department and Commission, Sanitation and Streets Department and Commission		Affordable Housing o?= Board of Supervisors		Sales Tax for Transportation Projects		Retiree Supplemental Cost of Living Adjustment; Retirement Board Contract with Executive Director		None		Sales Tax for Transportation Projects		None		None		None		None		HOMELESSNESS OVERSIGHT COMMISSION		None		None		Sales Tax for Transportation Projects		None		Affordable Housing o?= 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		HOMELESSNESS OVERSIGHT COMMISSION		Sales Tax for Transportation Projects		None		None		None		None		None		None		Additional Parcel Tax for City College		Affordable Housing o?= Board of Supervisors		None
bal_num		B		E		L		A		None		L		None		None		None		None		C		None		None		L		None		E		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		C		L		None		None		None		None		None		None		O		E		None
bal_juris		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		None		SAN FRANCISCO		None		None		None		None		SAN FRANCISCO		None		None		SAN FRANCISCO		None		SAN FRANCISCO		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SAN FRANCISCO		SAN FRANCISCO		None		None		None		None		None		None		SAN FRANCISCO		SAN FRANCISCO		None
sup_opp_cd		O		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
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
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
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
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
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
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
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

Table: s401

filing_id		2743915
amend_id		0
line_item		1
rec_type		S401
form_type		F401B
tran_id		EXP376
agent_naml		None
agent_namf		None
agent_namt		None
agent_nams		None
payee_naml		MJE STRATEGIES LLC
payee_namf		None
payee_namt		None
payee_nams		None
payee_city		FREMONT
payee_st		CA
payee_zip4		94536
amount		87255
aggregate		0
expn_dscr		DIRECT MAIL
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		None
memo_refno		None
bakref_tid		None

Table: smry

filing_id		2743915		2743915		2743915		2743915		2743915		2743915		2743915		2743915
amend_id		0		0		0		0		0		0		0		0
line_item		1		2		1		2		3		1		2		3
rec_type		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY		SMRY
form_type		F401		F401		401A		401A		401A		401B		401B		401B
amount_a		130300		87255		130300		0		130300		87255		0		87255
amount_b		130300		87255		None		None		None		None		None		None
amount_c		None		None		None		None		None		None		None		None
elec_dt		None		None		None		None		None		None		None		None