Home

Filer ID: 1241889

Table: cvr_lobby_disclosure

filing_id		835803		852737		888019		912578		930483		946736		968373		988022		1621743		1607795		1589651		1636750		1708999		1671651		1653587		1734970		1794471		1779043		1764233		1813344		1909044		1865503		1839253		1992514		1965183		1978980		1935777		2060001		2037316		2010172		2100586		2169939		2157222		2127989		2191414		2273258		2232528		2209381		2344218		2392410		2317997		2380995		2468502		2414160		2438995		2479716		2548452		2525748		2603153		2635492		2577842		2619832		2735299		2677893		2701403
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
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615
sender_id		C28023		C28023		C28023		C28023		C28023		C28023		1241889		1241889		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875
filer_id		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889
entity_cd		LBY		LBY		LBY		LBY		LBY		LBY		FRM		FRM		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY		LBY
filer_naml		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES
filer_namf		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE R.		BRANCHE R.		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE
filer_namt		MR		MR		MR		MR		MR		MR		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_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
report_num		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2002-04-17 00:00:00		2002-07-26 00:00:00		2002-11-04 00:00:00		2003-01-31 00:00:00		2003-04-29 00:00:00		2003-07-30 00:00:00		2003-10-29 00:00:00		2004-01-29 00:00:00		2011-10-31 00:00:00		2011-07-31 00:00:00		2011-04-30 00:00:00		2012-01-31 00:00:00		2012-10-31 00:00:00		2012-07-31 00:00:00		2012-04-30 00:00:00		2013-01-31 00:00:00		2013-10-31 00:00:00		2013-07-31 00:00:00		2013-04-30 00:00:00		2014-01-31 00:00:00		2014-10-31 00:00:00		2014-07-31 00:00:00		2014-04-30 00:00:00		2015-10-31 00:00:00		2015-04-30 00:00:00		2015-07-31 00:00:00		2015-01-31 00:00:00		2016-08-02 00:00:00		2016-04-30 00:00:00		2016-01-31 00:00:00		2016-10-31 00:00:00		2017-07-31 00:00:00		2017-04-30 00:00:00		2017-01-31 00:00:00		2017-10-31 00:00:00		2018-07-20 00:00:00		2018-04-05 00:00:00		2018-01-31 00:00:00		2019-01-22 00:00:00		2019-07-16 00:00:00		2018-10-11 00:00:00		2019-04-19 00:00:00		2020-04-02 00:00:00		2019-10-14 00:00:00		2020-01-12 00:00:00		2020-04-02 00:00:00		2021-01-12 00:00:00		2020-10-17 00:00:00		2021-01-12 00:00:00		2021-12-31 00:00:00		2021-01-12 00:00:00		2021-10-19 00:00:00		2022-10-10 00:00:00		2022-04-30 00:00:00		2022-07-13 00:00:00
from_date		2002-01-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2011-07-01 00:00:00		2011-04-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2012-07-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2012-10-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2013-10-01 00:00:00		2014-07-01 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		2015-07-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2014-10-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		2015-10-01 00:00:00		2016-07-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2016-10-01 00:00:00		2017-07-01 00:00:00		2018-04-01 00:00:00		2018-01-01 00:00:00		2017-10-01 00:00:00		2018-10-01 00:00:00		2019-04-01 00:00:00		2018-07-01 00:00:00		2019-01-01 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2019-10-01 00:00:00		2020-04-01 00:00:00		2020-10-01 00:00:00		2020-07-01 00:00:00		2021-04-01 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2022-07-01 00:00:00		2022-01-01 00:00:00		2022-04-01 00:00:00
thru_date		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2011-09-30 00:00:00		2011-06-30 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2012-09-30 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2012-12-31 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2013-12-31 00:00:00		2014-09-30 00:00:00		2014-06-30 00:00:00		2014-03-31 00:00:00		2015-09-30 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2014-12-31 00:00:00		2016-06-30 00:00:00		2016-03-31 00:00:00		2015-12-31 00:00:00		2016-09-30 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2016-12-31 00:00:00		2017-09-30 00:00:00		2018-06-30 00:00:00		2018-03-31 00:00:00		2017-12-31 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2018-09-30 00:00:00		2019-03-31 00:00:00		2020-03-31 00:00:00		2019-09-30 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2020-09-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2021-03-31 00:00:00		2021-09-30 00:00:00		2022-09-30 00:00:00		2022-03-31 00:00:00		2022-06-30 00:00:00
cum_beg_dt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
firm_id		C28023		C28023		C28023		C28023		C28023		C28023		1241889		1241889		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875		1335875
firm_name		JONES		JONES		JONES		JONES		JONES		SAN FRANCISCO UNIFIED SCHOOL DISTRICT		SAN FRANCISCO UNIFIED SCHOOL DISTRICT		SAN FRANCISCO UNIFIED SCHOOL DISTRICT		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES
firm_city		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		CARMICHAEL		CARMICHAEL		CARMICHAEL		CARMICHAEL		CARMICHAEL		CARMICHAEL		CARMICHAEL		CARMICHAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
firm_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
firm_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95608		95608		95608		95608		95608		95608		95608		95608		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
firm_phon		9164424903		9164424903		9164424903		9164424903		9164424903		9164424903		9164424903		9164424903		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711
mail_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
mail_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
mail_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
mail_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_date		2002-04-17 00:00:00		2002-07-26 00:00:00		2002-10-30 00:00:00		2003-01-31 00:00:00		2003-04-29 00:00:00		2003-07-30 00:00:00		2003-10-29 00:00:00		2004-01-29 00:00:00		2011-10-19 00:00:00		2011-07-22 00:00:00		2011-04-26 00:00:00		2012-01-19 00:00:00		2012-10-16 00:00:00		2012-07-11 00:00:00		2012-04-11 00:00:00		2013-01-23 00:00:00		2013-10-09 00:00:00		2013-07-18 00:00:00		2013-04-19 00:00:00		2014-01-14 00:00:00		2014-10-14 00:00:00		2014-07-10 00:00:00		2014-04-10 00:00:00		2015-10-07 00:00:00		2015-04-15 00:00:00		2015-07-14 00:00:00		2015-01-23 00:00:00		2016-07-19 00:00:00		2016-04-13 00:00:00		2016-01-18 00:00:00		2016-10-13 00:00:00		2017-07-10 00:00:00		2017-04-14 00:00:00		2017-01-20 00:00:00		2017-10-12 00:00:00		2018-07-20 00:00:00		2018-04-05 00:00:00		2018-01-10 00:00:00		2019-01-22 00:00:00		2019-07-16 00:00:00		2018-10-11 00:00:00		2019-04-19 00:00:00		2020-04-02 00:00:00		2019-10-14 00:00:00		2020-01-12 00:00:00		2020-07-12 00:00:00		2021-01-12 00:00:00		2020-10-17 00:00:00		2021-07-20 00:00:00		2022-01-07 00:00:00		2021-04-15 00:00:00		2021-10-19 00:00:00		2022-10-10 00:00:00		2022-04-11 00:00:00		2022-07-13 00:00:00
sig_loc		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO		CARMICHAEL, CA		CARMICHAEL, CA		CARMICHAEL, CA		CARMICHAEL, CA		CARMICHAEL, CA		CARMICHAEL, CA		CARMICHAEL, CA		CARMICHAEL, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA
sig_naml		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES
sig_namf		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE
sig_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
sig_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
prn_naml		JONES		JONES		JONES		JONES		JONES		JONES		None		None		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES (454500-MM)		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES
prn_namf		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		None		None		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE
prn_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
prn_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
sig_title		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nopart1_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
nopart2_cb		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
part1_1_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
part1_2_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_n_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_y_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lby_actvty		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_n_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_y_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
major_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
major_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
major_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
major_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
rcpcmte_nm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rcpcmte_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

Table: cvr_registration

filing_id		1582272		1724339		1922967		2117064		2329740		2329740		2538440
amend_id		0		0		0		0		0		1		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F604		F604		F604		F604		F604		F604		F604
sender_id		1335875		1335875		1335875		1335875		1335875		1335875		1335875
filer_id		1241889		1241889		1241889		1241889		1241889		1241889		1241889
entity_cd		LBY		LBY		LBY		LBY		LBY		LBY		LBY
filer_naml		JONES		JONES		JONES		JONES		JONES		JONES		JONES
filer_namf		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE
filer_namt		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None
report_num		000		000		000		000		000		001		000
rpt_date		2011-03-15 00:00:00		2012-12-31 00:00:00		2014-12-31 00:00:00		2016-12-31 00:00:00		2018-11-15 00:00:00		2019-01-10 00:00:00		2020-11-19 00:00:00
ls_beg_yr		2011		2013		2015		2017		2019		2019		2021
ls_end_yr		2012		2014		2016		2018		2020		2020		2022
qual_date		2011-01-26 00:00:00		None		None		None		None		None		None
eff_date		None		None		None		None		None		None		None
bus_city		CARMICHAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
bus_st		CA		CA		CA		CA		CA		CA		CA
bus_zip4		95608		95814		95814		95814		95814		95814		95814
bus_phon		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711		(916) 296-2711
bus_fax		None		None		None		None		None		None		None
bus_email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
mail_city		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None
sig_date		2011-03-15 00:00:00		2013-01-11 00:00:00		2014-12-22 00:00:00		2016-11-21 00:00:00		2018-11-15 00:00:00		2019-01-10 00:00:00		2020-11-19 00:00:00
sig_loc		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA		SACRAMENTO, CA
sig_naml		JONES		JONES		JONES		JONES		JONES		JONES		JONES
sig_namf		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE
sig_namt		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None
prn_naml		JONES		JONES		JONES		JONES		JONES		JONES		JONES
prn_namf		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE
prn_namt		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None
sig_title		LOBBYIST(454500-MM)		LOBBYIST(454500-MM)		LOBBYIST(454500-MM)		LOBBYIST(454500-MM)		LOBBYIST		LOBBYIST		LOBBYIST
stmt_firm		None		None		None		None		None		None		None
ind_cb		None		None		None		None		None		None		None
bus_cb		None		None		None		None		None		None		None
trade_cb		None		None		None		None		None		None		None
oth_cb		None		None		None		None		None		None		None
a_b_name		None		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None		None
descrip_1		None		None		None		None		None		None		None
descrip_2		None		None		None		None		None		None		None
c_less50		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None
ind_class		None		None		None		None		None		None		None
ind_descr		None		None		None		None		None		None		None
bus_class		None		None		None		None		None		None		None
bus_descr		None		None		None		None		None		None		None
auth_name		None		None		None		None		None		None		None
auth_city		None		None		None		None		None		None		None
auth_st		None		None		None		None		None		None		None
auth_zip4		None		None		None		None		None		None		None
lobby_int		None		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None		None
firm_name		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES		BRANCHE JONES
newcert_cb		X		X		None		None		None		None		None
rencert_cb		None		None		None		None		X		None		None
complet_dt		None		None		2014-11-13 00:00:00		2016-11-17 00:00:00		None		2019-01-10 00:00:00		2020-11-19 00:00:00
lby_reg_cb		X		X		X		X		X		X		X
lby_604_cb		None		None		None		None		None		None		None
st_leg_yn		Y		Y		Y		Y		Y		Y		Y
st_agency		None		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None		None

Table: efs_filing_log

filing_date		2003-10-29 00:00:00		2003-10-29 00:00:00
filingstatus		1		0
vendor		CAL-ACCESS OBJECT MODEL		CAL-ACCESS OBJECT MODEL
filer_id		1241889		1241889
form_type		F615		F615
error_no		ACCEPTED		ACCEPTED

Table: filer_address

filer_id		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889
adrid		2027035		2046430		2211086		2410923		2470169		2283975		2548043		2510806		2345260
effect_dt		2002-01-04 00:00:00		2003-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2013-02-28 00:00:00		2023-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		2001		2003		2011		2017		2019		2013		2023		2021		2015

Table: filer_ethics_class

filer_id		1241889		1241889		1241889		1241889		1241889		1241889		1241889
session_id		2001		2011		2013		2015		2019		2017		2021
ethics_date		2002-02-07 00:00:00		2011-05-19 00:00:00		2013-04-11 00:00:00		2014-11-13 00:00:00		2019-01-10 00:00:00		2016-11-17 00:00:00		2020-11-19 00:00:00

Table: filer_filings

filer_id		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889
filing_id		807523		807525		835803		826682		860996		847806		842451		893481		852737		888019		893110		920587		920887		913892		934880		912578		930483		936332		946736		954724		984016		975913		968373		976393		988022		1001293		1001556		1779043		1978980		1965183		1865503		1935777		1944960		1570840		1582272		1607795		1589651		1594986		1621743		1636750		1671651		1653587		1794471		1813344		1909044		1922967		1708999		1724339		1734970		1735367		1839253		1764233		1759368		1992514		2273258		2329740		2414160		2573288		2354754		2354768		2354770		2380995		2525748		2191414		2344218		2010172		2037316		2060001		2100586		2127989		2117064		2139224		2169939		2157222		2317997		2232528		2209381		2479716		2603153		2577842		2329740		2468502		2438995		2392410		2548452		2677893		2538440		2635492		2701403		2619832		2735299
period_id		None		None		169		None		None		None		None		None		170		171		None		None		None		None		None		172		173		None		174		None		None		None		175		None		176		None		None		214		222		221		218		220		None		None		205		206		205		None		207		208		210		209		215		216		219		220		211		212		212		None		217		213		None		223		234		237		239		None		None		None		None		237		243		231		236		224		225		226		227		228		228		None		230		229		235		233		232		242		246		245		236		241		240		238		244		249		244		248		250		247		251
form_id		F604		F999		F615		F604		F615		F615		F615		F615		F615		F615		F615		F635		F615		F604		F615		F615		F615		F615		F615		F615		F606		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F604		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F604		F615		F604		F615		F604		F615		F615		F604		F615		F615		F604		F615		F604		F604		F604		F605		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F604		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2002-01-07 00:00:00		2002-01-16 00:00:00		2002-04-17 00:00:00		2002-02-07 00:00:00		2002-07-31 00:00:00		2002-04-29 00:00:00		2002-04-23 00:00:00		2002-10-30 00:00:00		2002-07-26 00:00:00		2002-11-04 00:00:00		2002-10-31 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2003-04-29 00:00:00		2003-01-31 00:00:00		2003-04-29 00:00:00		2003-04-30 00:00:00		2003-07-30 00:00:00		2003-07-31 00:00:00		2004-01-16 00:00:00		2003-10-30 00:00:00		2003-10-29 00:00:00		2003-10-29 00:00:00		2004-01-29 00:00:00		2004-01-27 00:00:00		2004-02-02 00:00:00		2013-07-26 00:00:00		2015-07-29 00:00:00		2015-04-30 00:00:00		2014-07-23 00:00:00		2015-02-01 00:00:00		2015-01-05 00:00:00		2011-01-27 00:00:00		2011-03-15 00:00:00		2011-08-01 00:00:00		2011-04-28 00:00:00		2011-05-19 00:00:00		2011-10-30 00:00:00		2012-01-31 00:00:00		2012-07-16 00:00:00		2012-04-23 00:00:00		2013-10-16 00:00:00		2014-01-26 00:00:00		2014-10-29 00:00:00		2015-01-05 00:00:00		2012-10-31 00:00:00		2013-01-11 00:00:00		2013-01-29 00:00:00		2013-01-11 00:00:00		2014-04-17 00:00:00		2013-04-29 00:00:00		2013-04-11 00:00:00		2015-10-19 00:00:00		2018-07-30 00:00:00		2019-01-10 00:00:00		2019-10-21 00:00:00		2020-12-28 00:00:00		2018-12-27 00:00:00		2019-01-11 00:00:00		2019-01-02 00:00:00		2019-04-30 00:00:00		2020-10-28 00:00:00		2017-10-27 00:00:00		2019-01-29 00:00:00		2016-01-29 00:00:00		2016-05-02 00:00:00		2016-07-28 00:00:00		2016-10-30 00:00:00		2017-01-30 00:00:00		2017-01-04 00:00:00		2017-01-04 00:00:00		2017-07-24 00:00:00		2017-05-01 00:00:00		2018-10-30 00:00:00		2018-04-18 00:00:00		2018-01-30 00:00:00		2020-07-21 00:00:00		2021-08-02 00:00:00		2021-04-27 00:00:00		2018-12-27 00:00:00		2020-04-28 00:00:00		2020-01-29 00:00:00		2019-07-23 00:00:00		2021-01-27 00:00:00		2022-05-02 00:00:00		2020-12-27 00:00:00		2022-01-20 00:00:00		2022-07-26 00:00:00		2021-10-26 00:00:00		2022-10-18 00:00:00
stmnt_type		10005		10005		10001		10002		10005		10006		10005		10005		10001		10001		10005		10005		10005		10005		10005		10001		10001		10005		10001		10005		10005		10005		10001		10005		10001		10005		10005		10001		10001		10001		10001		10001		10005		10005		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10006		10001		10001		10002		10001		10005		10001		10006		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11003
session_id		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2013		2015		2015		2013		2013		2015		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2015		2011		2013		2011		2013		2013		2013		2013		2015		2017		2019		2019		2021		2019		2019		2019		2019		2019		2017		2017		2015		2015		2015		2015		2015		2017		2017		2017		2017		2017		2017		2017		2019		2021		2021		2019		2019		2019		2019		2019		2021		2021		2021		2021		2021		2021
user_id		CFLAGG		CFLAGG		*		SARRIAGA		GGILMORE		GGILMORE		LTHIBAUL		LTHIBAUL		*		*		LTHIBAUL		KVANG		LTHIBAUL		GKURIMOT		KVOONG1		COMPLETED		COMPLETED		KVOONG1		COMPLETED		LTHIBAUL		GPEREZ		LTHIBAUL		COMPLETED		LTHIBAUL		COMPLETED		LTHIBAUL		EMCENTEE		ASAETERN		JINGRAM		JINGRAM		ASAETERN		AGLADNEY		PBANFORD		PBANFORD		*		ASAETERN		JINGRAM		PBANFORD		ASAETERN		ASAETERN		AGLADNEY		ASAETERN		ASAETERN		ASAETERN		ASAETERN		PBANFORD		ASAETERN		PBANFORD		ASAETERN		PBANFORD		ASAETERN		ASAETERN		SMCCONNAN		JINGRAM		AGLADNEY		SARRIAGA		VUKSTINA		MKIRKHAM		SARRIAGA		SARRIAGA		SUSHAKOV		SUSHAKOV		MKIRKHAM		SMCCONNAN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		JINGRAM		AGLADNEY		SARRIAGA		SARRIAGA		SMCCONNAN		AGLADNEY		JFRONEFIELD		AGLADNEY		AGLADNEY		VUKSTINA		CHATRIDGE		CHARTRIDGE		SARRIAGA		VUKSTINA		AGLADNEY		VUKSTINA		CHARTRIDGE		CAFILER		MKIRKHAM		RATTIYEH		CAFILER		GTAYLOR		CAFILER
special_audit		11003		11003		11003		11003		11002		11003		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11003		11001		11003
rpt_start		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-01-01 00:00:00		1900-01-01 00:00:00		2002-04-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2002-04-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		1900-01-01 00:00:00		2003-01-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-04-01 00:00:00		1900-01-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2014-04-01 00:00:00		2014-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2011-03-15 00:00:00		2011-04-01 00:00:00		2011-01-01 00:00:00		1900-01-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2014-07-01 00:00:00		2014-12-31 00:00:00		2012-07-01 00:00:00		2012-12-31 00:00:00		2012-10-01 00:00:00		1900-01-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		1900-01-01 00:00:00		2015-07-01 00:00:00		2018-04-01 00:00:00		2019-01-10 00:00:00		2019-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-01-01 00:00:00		2020-07-01 00:00:00		2017-07-01 00:00:00		2018-10-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2016-12-31 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2018-07-01 00:00:00		2018-01-01 00:00:00		2017-10-01 00:00:00		2020-04-01 00:00:00		2021-04-01 00:00:00		2021-01-01 00:00:00		2018-11-15 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2019-04-01 00:00:00		2020-10-01 00:00:00		2022-01-01 00:00:00		2020-11-19 00:00:00		2021-10-01 00:00:00		2022-04-01 00:00:00		2021-07-01 00:00:00		2022-07-01 00:00:00
rpt_end		1900-01-01 00:00:00		1900-01-01 00:00:00		2002-03-31 00:00:00		1900-01-01 00:00:00		2002-06-30 00:00:00		2002-03-31 00:00:00		2002-03-31 00:00:00		2002-09-30 00:00:00		2002-06-30 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		1900-01-01 00:00:00		2003-03-31 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		1900-01-01 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2014-06-30 00:00:00		2014-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2011-03-15 00:00:00		2011-06-30 00:00:00		2011-03-31 00:00:00		1900-01-01 00:00:00		2011-09-30 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		2013-09-30 00:00:00		2013-12-31 00:00:00		2014-09-30 00:00:00		2014-12-31 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2014-03-31 00:00:00		2013-03-31 00:00:00		1900-01-01 00:00:00		2015-09-30 00:00:00		2018-06-30 00:00:00		2019-01-10 00:00:00		2019-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-03-31 00:00:00		2020-09-30 00:00:00		2017-09-30 00:00:00		2018-12-31 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2018-09-30 00:00:00		2018-03-31 00:00:00		2017-12-31 00:00:00		2020-06-30 00:00:00		2021-06-30 00:00:00		2021-03-31 00:00:00		2018-11-15 00:00:00		2020-03-31 00:00:00		2019-12-31 00:00:00		2019-06-30 00:00:00		2020-12-31 00:00:00		2022-03-31 00:00:00		2020-11-19 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00		2021-09-30 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		22001		None		22001		None		None		None		22006		None		22006		None		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		None		None		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001

Table: filer_to_filer_type

filer_id		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889
filer_type		4		4		4		4		4		4		4		4		4		4
active		Y		Y		T		Y		Y		Y		Y		Y		Y		N
race		None		0		None		None		None		None		None		None		None		None
session_id		2003		2001		2003		2013		2011		2015		2021		2019		2017		2023
category		None		0		None		None		None		None		None		None		None		None
category_type		None		0		None		None		None		None		None		None		None		None
sub_category		None		0		None		None		None		None		None		None		None		None
effect_dt		2003-01-01 00:00:00		2002-01-04 00:00:00		2003-12-31 00:00:00		2013-01-01 00:00:00		2011-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		None		0		None		None		None		None		None		None		None		None
election_type		None		0		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		2002-01-01 00:00:00		None		2002-01-01 00:00:00		None		None		None		None		None
party_cd		None		0		None		None		None		None		None		None		None		None
county_cd		None		0		None		None		None		None		None		None		None		None
district_cd		None		0		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1241889
xref_id		1241889
effect_dt		2002-01-16 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889
filer_id		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889
filer_type		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES		JONES
namf		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE R.		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE		BRANCHE
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
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
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		SACRAMENTO		SACRAMENTO		CARMICHAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		CARMICHAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		CARMICHAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		CARMICHAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		CARMICHAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		CARMICHAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		CARMICHAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		CARMICHAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		CARMICHAEL		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO
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
zip4		95814		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		95608		95814		95814		95814		95814		95814		95814		95814		95814		95608		95814		95814		95814		95814		95814		95814
phon		9164424903		9164424903		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9164424903		9164424903		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9164424903		9164424903		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9164424903		9164424903		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9164424903		9164424903		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9164424903		9164424903		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9164424903		9164424903		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9164424903		9164424903		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9164424903		9164424903		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711		9162962711
fax		9164431508		9164431508																9164431508		9164431508																9164431508		9164431508																9164431508		9164431508																9164431508		9164431508																9164431508		9164431508																9164431508		9164431508																9164431508		9164431508																9164431508		9164431508
email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1241889

Table: lobbying_chg_log

filer_id		1241889		1241889		1241889		1241889		1241889		1241889
change_no		0		1		2		3		4		5
session_id		2001		2001		2001		2001		2001		2003
log_dt		2002-01-07 00:00:00		2002-01-16 00:00:00		2002-01-16 00:00:00		2002-01-16 00:00:00		2002-02-07 00:00:00		2004-01-27 00:00:00
filer_type		4		4		4		4		4		4
correction_flg		Y		None		None		None		None		None
action		NEW		SET ACTIVE		CHANGED		CHANGED		None		DELETED
attribute_changed		LOBBYIST				None		NAME		ETHICS DATE		EMPLOYER
ethics_dt		None		None		None		None		2002-02-07 00:00:00		None
interests		None		None		None		None		None		None
filer_full_name		JONES, BRANCHE R.		FILER INFORMATION		FILER INFORMATION		BRANCHE R. JONES		JONES, BRANCHE R.		BRANCHE R. JONES
filer_city		None		None		SACRAMENTO		None		None		None
filer_st		None		None		CA		None		None		None
filer_zip		None		None		95814		None		None		None
filer_phone		None		None		9164424903		None		None		None
entity_type		4		4		4		4		4		2
entity_name		SAN FRANCISCO UNIFIED SCHOOL DISTRICT		None		None		FILER INFORMATION		None		SAN FRANCISCO UNIFIED SCHOOL DISTRICT
entity_city		None		None		None		None		None		None
entity_st		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None
entity_id		1146467		0		0		0		0		1146467
responsible_officer		None		None		None		None		None		None
effect_dt		2002-01-04 00:00:00		2002-01-04 00:00:00		2002-01-04 00:00:00		2002-01-04 00:00:00		2002-02-07 00:00:00		2003-12-31 00:00:00

Table: received_filings

filer_id		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889		1241889
filing_file_name		835803_0.cal		852737_0.cal		888019_0.cal		912578_0.cal		930483_0.cal		946736_0.cal		968373_0.cal		1671651_0.cal		1734970_0.cal		1724339_0.cal		1839253_0.cal		1794471_0.cal		1582272_0.cal		1813344_0.cal		1607795_0.cal		1589651_0.cal		1764233_0.cal		1779043_0.cal		1636750_0.cal		1621743_0.cal		1708999_0.cal		1653587_0.cal		1865503_0.cal		1978980_0.cal		1965183_0.cal		2127989_0.cal		2060001_0.cal		1992514_0.cal		2010172_0.cal		2117064_0.cal		2100586_0.cal		1909044_0.cal		1922967_0.cal		2037316_0.cal		1935777_0.cal		2157222_0.cal		2169939_0.cal		2329740_1.cal		2273258_0.cal		2479716_0.cal		2191414_0.cal		2392410_0.cal		2344218_0.cal		2232528_0.cal		2317997_0.cal		2414160_0.cal		2209381_0.cal		2468502_0.cal		2438995_0.cal		2380995_0.cal		2329740_0.cal		2603153_0.cal		2677893_0.cal		2577842_0.cal		2701403_0.cal		2525748_0.cal		2548452_0.cal		2635492_0.cal		2619832_0.cal		2735299_0.cal		2538440_0.cal
received_date		2002-04-17 00:00:00		2002-07-26 00:00:00		2002-11-04 00:00:00		2003-01-31 00:00:00		2003-04-29 00:00:00		2003-07-30 00:00:00		2003-10-29 00:00:00		2012-07-16 00:00:00		2013-01-29 00:00:00		2013-01-11 00:00:00		2014-04-17 00:00:00		2013-10-16 00:00:00		2011-03-15 00:00:00		2014-01-26 00:00:00		2011-08-01 00:00:00		2011-04-28 00:00:00		2013-04-29 00:00:00		2013-07-26 00:00:00		2012-01-31 00:00:00		2011-10-30 00:00:00		2012-10-31 00:00:00		2012-04-23 00:00:00		2014-07-23 00:00:00		2015-07-29 00:00:00		2015-04-30 00:00:00		2017-01-30 00:00:00		2016-07-28 00:00:00		2015-10-19 00:00:00		2016-01-29 00:00:00		2017-01-04 00:00:00		2016-10-30 00:00:00		2014-10-29 00:00:00		2015-01-05 00:00:00		2016-05-02 00:00:00		2015-02-01 00:00:00		2017-05-01 00:00:00		2017-07-24 00:00:00		2019-01-10 00:00:00		2018-07-30 00:00:00		2020-07-21 00:00:00		2017-10-27 00:00:00		2019-07-23 00:00:00		2019-01-29 00:00:00		2018-04-18 00:00:00		2018-10-30 00:00:00		2019-10-21 00:00:00		2018-01-30 00:00:00		2020-04-28 00:00:00		2020-01-29 00:00:00		2019-04-30 00:00:00		2018-12-27 00:00:00		2021-08-02 00:00:00		2022-05-02 00:00:00		2021-04-27 00:00:00		2022-07-26 00:00:00		2020-10-28 00:00:00		2021-01-27 00:00:00		2022-01-20 00:00:00		2021-10-26 00:00:00		2022-10-18 00:00:00		2020-12-27 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		835803		852737		888019		912578		930483		946736		968373		1671651		1734970		1724339		1839253		1794471		1582272		1813344		1607795		1589651		1764233		1779043		1636750		1621743		1708999		1653587		1865503		1978980		1965183		2127989		2060001		1992514		2010172		2117064		2100586		1909044		1922967		2037316		1935777		2157222		2169939		2329740		2273258		2479716		2191414		2392410		2344218		2232528		2317997		2414160		2209381		2468502		2438995		2380995		2329740		2603153		2677893		2577842		2701403		2525748		2548452		2635492		2619832		2735299		2538440
form_id		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F604		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604		F615		F615		F615		F615		F615		F615		F615		F615		F615		F604
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted