Home

Filer ID: 1347730

Table: cvr_lobby_disclosure

filing_id		1766162		1733040		1731936		1731938		1781497		1797896		1781497		1872374		1846395		1819344		1982744		1982744		1983573		1982744		1935601		1935602		1997024		1997024		2062626		2037091		2037091		2012396		2012396		2101234		2154541		2168269		2168269		2154541		2131602		2191482		2191482		2274966		2209455		2241273		2274966		2334546		2397186		2334546		2379305		2313966		2424653		2440868		2471862		2481843		2481843		2552558		2527798		2471862		2481843		2527798		2599239		2623740		2471862		2552558		2599239		2580543		2481843		2527798		2623740		2580543		2674647		2580543		2599239		2643181		2623740		2703207		2674647		2643181		2623740		2745873
amend_id		0		0		0		0		1		0		0		0		0		0		1		2		0		0		0		0		1		0		0		1		0		0		1		0		1		1		0		0		0		1		0		0		0		0		1		1		0		0		0		0		0		0		0		1		0		0		0		1		2		1		0		0		2		1		1		1		3		2		1		0		0		2		2		0		3		0		1		1		2		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		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625		F625
sender_id		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730
filer_id		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730
entity_cd		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM		FRM
filer_naml		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		SC AND ASSOCIATES		SC AND ASSOCIATES		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC
filer_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_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
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		000		000		000		001		000		000		000		000		000		001		002		000		000		000		000		001		000		000		001		000		000		001		000		001		001		000		000		000		001		000		000		000		000		001		001		000		000		000		000		000		000		000		001		000		000		000		001		002		001		000		000		002		001		001		001		003		002		001		000		000		002		002		000		003		000		001		001		002		000
rpt_date		2013-04-30 00:00:00		2013-01-27 00:00:00		2013-01-24 00:00:00		2013-01-24 00:00:00		2013-09-04 00:00:00		2013-10-28 00:00:00		2013-07-30 00:00:00		2014-07-31 00:00:00		2014-04-30 00:00:00		2014-01-31 00:00:00		2015-08-03 00:00:00		2015-08-03 00:00:00		2015-08-03 00:00:00		2015-07-31 00:00:00		2015-01-31 00:00:00		2015-01-31 00:00:00		2015-10-30 00:00:00		2015-10-30 00:00:00		2016-07-30 00:00:00		2016-08-11 00:00:00		2016-05-01 00:00:00		2016-02-01 00:00:00		2016-02-01 00:00:00		2016-10-31 00:00:00		2017-07-24 00:00:00		2017-07-24 00:00:00		2017-07-18 00:00:00		2017-04-27 00:00:00		2017-01-31 00:00:00		2017-10-30 00:00:00		2017-10-28 00:00:00		2018-07-31 00:00:00		2018-01-30 00:00:00		2018-04-30 00:00:00		2018-09-13 00:00:00		2019-01-15 00:00:00		2019-07-30 00:00:00		2019-01-15 00:00:00		2019-04-29 00:00:00		2018-10-26 00:00:00		2019-12-12 00:00:00		2020-01-30 00:00:00		2020-04-30 00:00:00		2020-10-30 00:00:00		2020-07-28 00:00:00		2021-01-31 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2021-08-17 00:00:00		2021-10-25 00:00:00		2021-07-29 00:00:00		2021-10-31 00:00:00		2021-08-17 00:00:00		2022-01-26 00:00:00		2021-11-01 00:00:00		2021-07-15 00:00:00		2021-11-30 00:00:00		2021-11-30 00:00:00		2021-11-01 00:00:00		2021-04-30 00:00:00		2022-04-29 00:00:00		2022-06-03 00:00:00		2022-06-03 00:00:00		2022-01-31 00:00:00		2022-06-03 00:00:00		2022-07-28 00:00:00		2022-06-03 00:00:00		2022-06-03 00:00:00		2022-01-31 00:00:00		2022-10-28 00:00:00
from_date		2013-01-01 00:00:00		2012-10-01 00:00:00		2012-07-01 00:00:00		2012-04-30 00:00:00		2013-04-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		2013-10-01 00:00:00		2015-04-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2014-07-01 00:00:00		2014-10-01 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2015-10-01 00:00:00		2015-10-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2017-04-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		2017-07-01 00:00:00		2018-04-01 00:00:00		2017-10-01 00:00:00		2018-01-01 00:00:00		2018-04-01 00:00:00		2018-10-01 00:00:00		2019-04-01 00:00:00		2018-10-01 00:00:00		2019-01-01 00:00:00		2018-07-01 00:00:00		2019-07-01 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		2020-04-01 00:00:00		2020-04-01 00:00:00		2020-10-01 00:00:00		2020-07-01 00:00:00		2020-01-01 00:00:00		2020-04-01 00:00:00		2020-07-01 00:00:00		2021-04-01 00:00:00		2021-07-01 00:00:00		2020-01-01 00:00:00		2020-10-01 00:00:00		2021-04-01 00:00:00		2021-01-01 00:00:00		2020-04-01 00:00:00		2020-07-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2021-01-01 00:00:00		2021-04-01 00:00:00		2021-10-01 00:00:00		2021-07-01 00:00:00		2022-04-01 00:00:00		2022-01-01 00:00:00		2021-10-01 00:00:00		2021-07-01 00:00:00		2022-07-01 00:00:00
thru_date		2013-03-31 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		2013-06-30 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2014-06-30 00:00:00		2014-03-31 00:00:00		2013-12-31 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2014-09-30 00:00:00		2014-12-31 00:00:00		2015-09-30 00:00:00		2015-09-30 00:00:00		2016-06-30 00:00:00		2016-03-31 00:00:00		2015-03-31 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-09-30 00:00:00		2017-03-31 00:00:00		2017-06-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		2017-09-30 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2018-03-31 00:00:00		2018-06-30 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2018-12-31 00:00:00		2019-03-31 00:00:00		2018-09-30 00:00:00		2019-09-30 00:00:00		2019-12-31 00:00:00		2020-03-31 00:00:00		2020-06-30 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2020-09-30 00:00:00		2020-03-31 00:00:00		2020-06-30 00:00:00		2020-09-30 00:00:00		2021-06-30 00:00:00		2021-09-30 00:00:00		2020-03-31 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2021-03-31 00:00:00		2020-06-30 00:00:00		2020-09-30 00:00:00		2021-09-30 00:00:00		2021-03-31 00:00:00		2022-03-31 00:00:00		2021-03-31 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2021-09-30 00:00:00		2022-06-30 00:00:00		2022-03-31 00:00:00		2021-12-31 00:00:00		2021-09-30 00:00:00		2022-09-30 00:00:00
cum_beg_dt		2013-03-06 00:00:00		2012-04-13 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2013-03-07 00:00:00		2013-03-06 00:00:00		2013-03-07 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2013-03-06 00:00:00		2015-04-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2014-01-01 00:00:00		2014-01-01 00:00:00		2015-04-01 00:00:00		2015-04-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2016-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2016-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2016-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2018-01-01 00:00:00		2017-01-01 00:00:00		2018-01-01 00:00:00		2018-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2018-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2020-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2020-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00
firm_id		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730
firm_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
firm_city		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		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		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
firm_zip4		95834		95835		95835		95835		95834		95834		95834		95834		95834		95834		95814		95814		95814		95814		95834		95834		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		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
firm_phon		9163961770		9163961770		9163961770		9163961770		9163961770		9163961770		9163961770		9163961770		9163961770		9163961770		9168620941		9168620941		9168620941		9168620941		9163961770		9163961770		9168620941		9168620941		9168620941		9168620941		9168620941		9168620941		9168620941		9168620941		9164765103		9164765103		9164765103		9164765103		9168620941		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164765103		9164427757		9164427757		9164427757		9164765103		9164427757		9164427757		9164427757		9164427757		9164765103		9164765103
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		None		None		None		None		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		SACRAMENTO
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		None		None		None		None		None		CA		CA		CA		None		CA		CA		CA		CA		None		CA
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		None		None		None		None		None		95814		95814		95814		None		95814		95814		95814		95814		None		95814
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		None		None		None		None		None		9164427757		9164427757		9164427757		None		9164427757		9164427757		9164427757		9164427757		None		9164427757
sig_date		2013-04-30 00:00:00		2013-01-27 00:00:00		2013-01-24 00:00:00		2013-01-24 00:00:00		2013-09-04 00:00:00		2013-10-28 00:00:00		2013-07-30 00:00:00		2014-07-31 00:00:00		2014-04-30 00:00:00		2014-01-31 00:00:00		2015-08-03 00:00:00		2015-08-03 00:00:00		2015-08-03 00:00:00		2015-07-31 00:00:00		2015-01-31 00:00:00		2014-01-31 00:00:00		2015-10-30 00:00:00		2015-10-30 00:00:00		2016-07-30 00:00:00		2016-08-11 00:00:00		2016-05-01 00:00:00		2016-02-01 00:00:00		2016-02-01 00:00:00		2016-10-31 00:00:00		2017-07-24 00:00:00		2017-07-24 00:00:00		2017-07-18 00:00:00		2017-04-27 00:00:00		2017-01-31 00:00:00		2017-10-30 00:00:00		2017-10-28 00:00:00		2018-07-31 00:00:00		2018-01-30 00:00:00		2018-04-30 00:00:00		2018-09-13 00:00:00		2019-01-15 00:00:00		2019-07-30 00:00:00		2019-01-15 00:00:00		2019-04-29 00:00:00		2018-10-26 00:00:00		2019-12-12 00:00:00		2020-01-30 00:00:00		2020-04-30 00:00:00		2020-10-30 00:00:00		2020-07-28 00:00:00		2020-01-31 00:00:00		2020-10-30 00:00:00		2020-10-30 00:00:00		2021-08-17 00:00:00		2021-10-25 00:00:00		2021-07-29 00:00:00		2021-10-31 00:00:00		2021-08-17 00:00:00		2022-01-26 00:00:00		2021-11-01 00:00:00		2021-07-15 00:00:00		2021-11-30 00:00:00		2021-11-30 00:00:00		2021-10-31 00:00:00		2021-04-30 00:00:00		2022-04-19 00:00:00		2022-06-03 00:00:00		2022-06-03 00:00:00		2022-01-31 00:00:00		2022-06-03 00:00:00		2022-07-18 00:00:00		2022-06-03 00:00:00		2022-05-25 00:00:00		2022-01-31 00:00:00		2022-10-15 00:00:00
sig_loc		Sacramento		Sacramento		SACRAMENTO		SACRAMENTO		Sacramento		Sacramento		Sacramento		Sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento, CA		sacramento, CA		Sacramento, CA		Sacramento, CA		Sacramento		Sacramento		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		Sacramento, CA		Sacramento, CA		Sacramento		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		Corbin		Corbin		CORBIN		CORBIN		Corbin		Corbin		Corbin		Corbin		Corbin		Corbin		Corbin		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Corbin		Corbin		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		KANDO-KAISER		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		KANDO-KAISER		KANDO-KAISER		Kando-Kaiser		Kando-Kaiser		KANDO-KAISER
sig_namf		Samantha		Samantha		SAMANTHA		SAMANTHA		Samantha		Samantha		Samantha		Samantha		Samantha		Samantha		Samantha		Danielle		Danielle		Danielle		Samantha		Samantha		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		DANIELLE		Danielle		Danielle		Danielle		Danielle		DANIELLE		DANIELLE		Danielle		Danielle		DANIELLE
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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
prn_naml		Corbin		Corbin		CORBIN		CORBIN		Corbin		Corbin		Corbin		Corbin		Corbin		Corbin		Corbin		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Corbin		Corbin		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		KANDO-KAISER		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		Kando-Kaiser		KANDO-KAISER		KANDO-KAISER		Kando-Kaiser		Kando-Kaiser		KANDO-KAISER
prn_namf		Samantha		Samantha		SAMANTHA		SAMANTHA		Samantha		Samantha		Samantha		Samantha		Samantha		Samantha		Samantha		Danielle		Danielle		Danielle		Samantha		Samantha		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		Danielle		DANIELLE		Danielle		Danielle		Danielle		Danielle		DANIELLE		DANIELLE		Danielle		Danielle		DANIELLE
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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sig_title		Consultant		Consultant		CONSULTANT		CONSULTANT		Consultant		Consultant/Owner		07/30/2013		Consultant/Primary		Consultant/Primary		Consultant		Principle		Principal		Principal		Partner		Consultant/Primary		Consultant/Primary		Lobbyist/Partner		Lobbyist/Partner		Principal		Principal		Lobbyist/Partner		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Principal		Founding Partner		Principal		Principal		Principal		Principal		Principal		Principal		PRINCIPAL		Principal		Principal		Principal		Principal		PRINCIPAL		PRINCIPAL		Principal		Principal		PRINCIPAL
nopart1_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nopart2_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
part1_1_cb		X		None		None		None		X		X		None		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		X		X		X		X		X		X		X		X
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
ctrib_n_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		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
lobby_n_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		X		X		X		X		X		X		X		X		X		X		X		X		X		X		X
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		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		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		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		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		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		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: cvr_registration

filing_id		1731937		1846392		1966428		1997083		2538257
amend_id		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR
form_type		F601		F601		F601		F606		F601
sender_id		1347730		1347730		1347730		1347730		1347730
filer_id		1347730		1347730		1347730		1347730		1347730
entity_cd		FRM		FRM		FRM		LBY		FRM
filer_naml		SC AND ASSOCIATES		SC AND ASSOCIATES		Corbin and Kaiser, LLC.		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC
filer_namf		SAMANTHA CORBIN		None		None		None		None
filer_namt		None		None		None		None		None
filer_nams		None		None		None		None		None
report_num		000		000		000		000		000
rpt_date		2013-01-24 00:00:00		2014-04-30 00:00:00		2015-04-30 00:00:00		2015-10-30 00:00:00		2020-12-23 00:00:00
ls_beg_yr		2011		2013		2015		2015		2021
ls_end_yr		2012		2014		2016		2016		2022
qual_date		2012-04-01 00:00:00		2013-01-01 00:00:00		2015-01-15 00:00:00		None		2015-01-15 00:00:00
eff_date		None		None		None		2015-10-31 00:00:00		None
bus_city		SACRAMENTO		SACRAMENTO		Sacramento		SACRAMENTO		SACRAMENTO
bus_st		CA		CA		CA		CA		CA
bus_zip4		95835		95814		95814		95814		95814
bus_phon		9163961770		9168620941		9163961770		None		9164765103
bus_fax		None		None		None		None		None
bus_email		[email protected]		[email protected]		[email protected]		None		[email protected]
mail_city		None		None		None		None		None
mail_st		None		None		None		None		None
mail_zip4		None		None		None		None		None
mail_phon		None		None		None		None		None
sig_date		2013-01-24 00:00:00		2014-04-30 00:00:00		2015-04-30 00:00:00		2015-10-30 00:00:00		2020-12-23 00:00:00
sig_loc		None		None		None		None		None
sig_naml		CORBIN		Corbin		Corbin		Kando-Kaiser		Kando-Kaiser
sig_namf		SAMANTHA		Samantha		Samantha		Danielle		Danielle
sig_namt		None		None		None		None		None
sig_nams		None		None		None		None		None
prn_naml		CORBIN		Corbin		Corbin		Kando-Kaiser		Kando-Kaiser
prn_namf		SAMANTHA		Samantha		Samantha		Danielle		Danielle
prn_namt		None		None		None		None		None
prn_nams		None		None		None		None		None
sig_title		CONSULTANT		Primary/Consultant		Partner		Lobbyist/Partner		Principal
stmt_firm		SC AND ASSOCIATES		SC and Associates		Corbin and Kaiser, LLC		None		Corbin and Kaiser, LLC
ind_cb		None		None		None		None		None
bus_cb		None		None		None		None		None
trade_cb		None		None		None		None		None
oth_cb		None		None		None		None		None
a_b_name		None		None		None		None		None
a_b_city		None		None		None		None		None
a_b_st		None		None		None		None		None
a_b_zip4		None		None		None		None		None
descrip_1		None		None		None		None		None
descrip_2		None		None		None		None		None
c_less50		None		None		None		None		None
c_more50		None		None		None		None		None
ind_class		None		None		None		None		None
ind_descr		None		None		None		None		None
bus_class		None		None		None		None		None
bus_descr		None		None		None		None		None
auth_name		None		None		None		None		None
auth_city		None		None		None		None		None
auth_st		None		None		None		None		None
auth_zip4		None		None		None		None		None
lobby_int		None		None		None		None		None
influen_yn		None		None		None		None		None
firm_name		None		None		None		None		None
newcert_cb		None		None		None		None		None
rencert_cb		None		None		None		None		None
complet_dt		None		None		None		None		None
lby_reg_cb		None		None		None		None		None
lby_604_cb		None		None		None		None		None
st_leg_yn		None		None		None		None		None
st_agency		None		None		None		None		None
lobby_cb		None		None		None		None		None
l_firm_cb		None		None		None		None		None

Table: filer_address

filer_id		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730
adrid		2412365		2549300		2230918		2276603		2468831		2545866		2545867		2504771		2360981		2532720
effect_dt		2017-01-01 00:00:00		2022-09-01 00:00:00		2012-04-20 00:00:00		2013-03-06 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2021-01-01 00:00:00		2015-01-15 00:00:00		2021-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7082		7051		7051		7082
session_id		2017		2021		2011		2013		2019		2023		2023		2021		2015		2021

Table: filer_filings

filer_id		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730
filing_id		1781497		1766162		1982744		1966428		1969673		1970632		1970634		1781497		1797896		1961536		1961538		1961528		1935601		1935602		1662273		1662271		1819344		1872374		1733040		1731936		1731937		1731938		1846392		1846395		1835223		1761105		1972852		1997083		1997024		1997024		1997209		1983573		1982744		1982744		2300569		2192452		2274966		2440868		2282778		2241273		2360892		2191482		2012396		2012396		2037091		2062626		2037091		2086885		2101234		2107564		2154541		2131946		2142528		2131602		2168823		2169594		2154541		2168269		2168269		2376833		2205687		2379305		2471862		2423893		2456090		2456128		2456142		2397186		2209455		2274966		2527798		2191482		2472188		2472189		2481843		2313966		2599239		2334546		2536145		2429987		2334546		2471862		2408151		2424653		2527798		2481843		2471862		2629142		2629149		2580543		2643181		2599239		2691915		2552558		2599239		2623740		2643181		2580543		2623740		2580543		2527798		2674647		2538257		2656543		2656552		2656555		2623740		2670001		2623740		2683897		2656375		2656386		2656394		2656417		2656456		2725186		2552558		2481843		2633651		2661449		2674647		2656229		2656337		2656347		2628856		2481843		2703207		2745873
period_id		214		213		222		222		None		None		None		214		215		None		None		None		219		220		None		None		216		218		212		211		213		210		218		217		None		None		None		224		223		223		None		221		222		222		None		None		234		240		None		233		None		231		224		224		221		226		225		None		227		None		229		None		None		228		None		None		229		230		230		None		None		237		241		None		None		None		None		238		232		234		243		231		None		None		242		235		246		236		None		None		236		241		None		239		243		242		241		None		None		245		248		246		None		244		246		247		248		245		247		245		243		249		244		None		None		None		247		None		247		None		None		None		None		None		None		None		244		242		None		None		249		None		None		None		None		242		250		251
form_id		F625		F625		F625		F601		F605		F605		F605		F625		F625		F605		F605		F601		F625		F625		F999		F601		F625		F625		F625		F625		F601		F625		F601		F625		F605		F601		F605		F606		F625		F625		F605		F625		F625		F625		F605		F605		F625		F625		F605		F625		F601		F625		F625		F625		F625		F625		F625		F605		F625		F605		F625		F601		F605		F625		F605		F605		F625		F625		F625		F605		F605		F625		F625		F605		F605		F605		F605		F625		F625		F625		F625		F625		F605		F605		F625		F625		F625		F625		F605		F605		F625		F625		F605		F625		F625		F625		F625		F605		F605		F625		F625		F625		F605		F625		F625		F625		F625		F625		F625		F625		F625		F625		F601		F605		F605		F605		F625		F605		F625		F605		F601		F601		F601		F605		F605		F605		F625		F625		F605		F605		F625		F601		F605		F605		F605		F625		F625		F625
filing_sequence		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		1		0		0		0		1		2		0		0		0		0		0		0		0		1		1		0		0		0		1		0		0		0		0		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		1		0		0		0		1		0		0		1		1		2		0		0		2		0		2		0		0		1		1		1		1		2		0		2		0		0		0		0		0		0		0		3		0		0		0		0		0		0		0		1		3		0		0		1		0		0		0		0		2		0		0
filing_date		2013-07-30 00:00:00		2013-04-30 00:00:00		2015-07-31 00:00:00		2015-04-30 00:00:00		2015-05-21 00:00:00		2015-06-04 00:00:00		2015-04-24 00:00:00		2013-09-04 00:00:00		2013-10-28 00:00:00		2015-02-13 00:00:00		2015-04-20 00:00:00		2015-02-13 00:00:00		2015-01-31 00:00:00		2015-01-31 00:00:00		2012-05-22 00:00:00		2012-04-30 00:00:00		2014-01-31 00:00:00		2014-07-31 00:00:00		2013-01-27 00:00:00		2013-01-24 00:00:00		2013-01-24 00:00:00		2013-01-24 00:00:00		2014-04-30 00:00:00		2014-04-30 00:00:00		2014-03-12 00:00:00		2013-03-07 00:00:00		2015-06-25 00:00:00		2015-10-30 00:00:00		2015-10-30 00:00:00		2015-10-30 00:00:00		2015-10-30 00:00:00		2015-08-03 00:00:00		2015-08-03 00:00:00		2015-08-03 00:00:00		2018-09-28 00:00:00		2017-10-27 00:00:00		2018-07-31 00:00:00		2020-01-30 00:00:00		2018-08-13 00:00:00		2018-04-30 00:00:00		2019-01-14 00:00:00		2017-10-30 00:00:00		2016-02-01 00:00:00		2016-02-01 00:00:00		2016-05-01 00:00:00		2016-07-30 00:00:00		2016-08-11 00:00:00		2016-10-06 00:00:00		2016-10-31 00:00:00		2016-11-15 00:00:00		2017-04-27 00:00:00		2016-11-15 00:00:00		2017-02-02 00:00:00		2017-01-31 00:00:00		2017-07-18 00:00:00		2017-07-18 00:00:00		2017-07-24 00:00:00		2017-07-24 00:00:00		2017-07-18 00:00:00		2019-04-02 00:00:00		2018-01-23 00:00:00		2019-04-29 00:00:00		2020-04-30 00:00:00		2019-12-02 00:00:00		2020-02-18 00:00:00		2020-02-18 00:00:00		2020-02-18 00:00:00		2019-07-30 00:00:00		2018-01-30 00:00:00		2018-09-13 00:00:00		2020-10-30 00:00:00		2017-10-28 00:00:00		2020-04-24 00:00:00		2020-04-24 00:00:00		2020-07-28 00:00:00		2018-10-26 00:00:00		2021-07-29 00:00:00		2019-01-15 00:00:00		2020-11-30 00:00:00		2020-01-09 00:00:00		2019-01-15 00:00:00		2020-10-30 00:00:00		2019-08-13 00:00:00		2019-12-12 00:00:00		2021-10-25 00:00:00		2020-10-30 00:00:00		2021-08-17 00:00:00		2021-11-08 00:00:00		2021-11-08 00:00:00		2022-06-03 00:00:00		2022-01-31 00:00:00		2022-06-03 00:00:00		2022-05-20 00:00:00		2021-01-31 00:00:00		2021-11-01 00:00:00		2021-11-01 00:00:00		2022-06-03 00:00:00		2021-07-15 00:00:00		2022-01-31 00:00:00		2021-04-30 00:00:00		2021-11-30 00:00:00		2022-04-29 00:00:00		2020-12-23 00:00:00		2021-02-04 00:00:00		2021-02-04 00:00:00		2021-10-28 00:00:00		2021-10-31 00:00:00		2022-04-11 00:00:00		2022-06-03 00:00:00		2022-05-05 00:00:00		2021-11-29 00:00:00		2021-04-22 00:00:00		2021-09-16 00:00:00		2021-10-28 00:00:00		2021-02-04 00:00:00		2022-09-16 00:00:00		2022-01-26 00:00:00		2021-11-30 00:00:00		2021-02-04 00:00:00		2022-03-18 00:00:00		2022-06-03 00:00:00		2022-01-11 00:00:00		2022-02-28 00:00:00		2022-02-22 00:00:00		2021-10-28 00:00:00		2021-08-17 00:00:00		2022-07-28 00:00:00		2022-10-28 00:00:00
stmnt_type		10001		10001		10001		10001		10006		10006		10006		10002		10001		10006		10006		10005		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10006		10005		10006		10001		10002		10001		10006		10001		10002		10002		10005		10006		10001		10001		10005		10001		10001		10002		10002		10001		10001		10001		10002		10005		10001		10005		10001		10001		10006		10001		10005		10006		10002		10002		10001		10006		10006		10001		10001		10005		10002		10002		10002		10001		10001		10002		10001		10001		10005		10005		10001		10001		10001		10002		10005		10005		10001		10002		10005		10001		10002		10002		10002		10002		10002		10002		10001		10002		10002		10001		10002		10002		10002		10002		10002		10001		10002		10001		10001		10002		10002		10002		10001		10005		10002		10002		10005		10005		10005		10002		10002		10002		10002		10002		10002		10002		10002		10005		10002		10002		10005		10002		10001		10001
stmnt_status		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		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		11001		11001		11003		11001		11001		11001		11001		11003		11001		11001		11003		11003		11003		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11003		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003
session_id		2013		2013		2015		2015		2015		2015		2015		2013		2013		2015		2015		2015		2013		2013		2011		2011		2013		2013		2011		2011		2011		2011		2013		2013		2013		2013		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2019		2017		2017		2019		2017		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2015		2017		2017		2017		2017		2017		2019		2017		2019		2019		2019		2019		2019		2019		2019		2017		2017		2019		2017		2019		2019		2019		2017		2021		2017		2019		2019		2017		2019		2019		2019		2019		2019		2019		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2019		2021		2021		2019		2019		2021		2021		2021		2021		2021		2021		2021		2019		2021		2021
user_id		ASAETERN		ASAETERN		AGLADNEY		YRODRIGU		YRODRIGU		YRODRIGU		YRODRIGU		ASAETERN		ASAETERN		YRODRIGU		YRODRIGU		YRODRIGU		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU		ASAETERN		ASAETERN		ASAETERN		RGEREMIA		PBANFORD		ASAETERN		YRODRIGU		ASAETERN		YRODRIGU		PBANFORD		YRODRIGU		YRODRIGU		AGLADNEY		AGLADNEY		YRODRIGU		RGEREMIA		AGLADNEY		AGLADNEY		GPEREZ		YRODRIGU		AGLADNEY		AGLADNEY		GPEREZ		AGLADNEY		DMCCASTL		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		AGLADNEY		GPEREZ		AGLADNEY		PBANFORD		PBANFORD		AGLADNEY		GPEREZ		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		YRODRIGU		AGLADNEY		MKIRKHAM		SARRIAGA		AROJAS		AROJAS		AROJAS		AGLADNEY		AGLADNEY		AGLADNEY		MKIRKHAM		AGLADNEY		GPEREZ		GPEREZ		MKIRKHAM		AGLADNEY		CAFILER		AGLADNEY		GPEREZ		GPEREZ		AGLADNEY		CAFILER		SARRIAGA		KBANH		CAFILER		CAFILER		CAFILER		MKIRKHAM		MKIRKHAM		CAFILER		CHATRIDGE		CAFILER		CVANLIEW		MKIRKHAM		CAFILER		CHATRIDGE		CHATRIDGE		CAFILER		CHATRIDGE		CAFILER		CAFILER		CAFILER		MKIRKHAM		MKIRKHAM		MKIRKHAM		MKIRKHAM		CHATRIDGE		CVANLIEW		CHATRIDGE		CVANLIEW		MKIRKHAM		MKIRKHAM		MKIRKHAM		MKIRKHAM		MKIRKHAM		CVANLIEW		CAFILER		CAFILER		CVANLIEW		MKIRKHAM		CAFILER		MKIRKHAM		MKIRKHAM		MKIRKHAM		SARRIAGA		CAFILER		CAFILER		CAFILER
special_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		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		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		11003		11003		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		2013-04-01 00:00:00		2013-01-01 00:00:00		2015-04-01 00:00:00		2015-04-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-04-01 00:00:00		2013-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		2014-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-10-01 00:00:00		2014-04-01 00:00:00		2012-10-01 00:00:00		2012-07-01 00:00:00		2013-01-24 00:00:00		2012-04-30 00:00:00		2014-04-30 00:00:00		2014-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-10-30 00:00:00		2015-07-01 00:00:00		2015-07-01 00:00:00		1900-01-01 00:00:00		2015-01-01 00:00:00		2015-04-01 00:00:00		2015-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-04-01 00:00:00		2019-10-01 00:00:00		1900-01-01 00:00:00		2018-01-01 00:00:00		1900-01-01 00:00:00		2017-07-01 00:00:00		2015-10-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-01-01 00:00:00		1900-01-01 00:00:00		2016-07-01 00:00:00		1900-01-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-01-01 00:00:00		2017-04-01 00:00:00		2017-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-01-01 00:00:00		2020-01-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-04-01 00:00:00		2017-10-01 00:00:00		2018-04-01 00:00:00		2020-07-01 00:00:00		2017-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-04-01 00:00:00		2018-07-01 00:00:00		2021-04-01 00:00:00		2018-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-10-01 00:00:00		2020-01-01 00:00:00		1900-01-01 00:00:00		2019-07-01 00:00:00		2020-07-01 00:00:00		2020-04-01 00:00:00		2020-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-01-01 00:00:00		2021-10-01 00:00:00		2021-04-01 00:00:00		1900-01-01 00:00:00		2020-10-01 00:00:00		2021-04-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2021-01-01 00:00:00		2020-07-01 00:00:00		2022-01-01 00:00:00		2020-12-23 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-07-01 00:00:00		1900-01-01 00:00:00		2021-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		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-10-01 00:00:00		2020-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2022-01-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		2020-04-01 00:00:00		2022-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		2013-06-30 00:00:00		2013-03-31 00:00:00		2015-06-30 00:00:00		2015-04-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-06-30 00:00:00		2013-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		2014-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2013-12-31 00:00:00		2014-06-30 00:00:00		2013-12-31 00:00:00		2012-09-30 00:00:00		2013-01-24 00:00:00		2012-12-31 00:00:00		2014-04-30 00:00:00		2014-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2015-10-30 00:00:00		2015-09-30 00:00:00		2015-09-30 00:00:00		1900-01-01 00:00:00		2015-03-31 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-06-30 00:00:00		2019-12-31 00:00:00		1900-01-01 00:00:00		2018-03-31 00:00:00		1900-01-01 00:00:00		2017-09-30 00:00:00		2015-12-31 00:00:00		2015-12-31 00:00:00		2015-03-31 00:00:00		2016-06-30 00:00:00		2016-03-31 00:00:00		1900-01-01 00:00:00		2016-09-30 00:00:00		1900-01-01 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2016-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2017-03-31 00:00:00		2017-06-30 00:00:00		2017-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-03-31 00:00:00		2020-03-31 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-06-30 00:00:00		2017-12-31 00:00:00		2018-06-30 00:00:00		2020-09-30 00:00:00		2017-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-06-30 00:00:00		2018-09-30 00:00:00		2021-06-30 00:00:00		2018-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2018-12-31 00:00:00		2020-03-31 00:00:00		1900-01-01 00:00:00		2019-09-30 00:00:00		2020-09-30 00:00:00		2020-06-30 00:00:00		2020-03-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-03-31 00:00:00		2021-12-31 00:00:00		2021-06-30 00:00:00		1900-01-01 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2021-09-30 00:00:00		2021-12-31 00:00:00		2021-03-31 00:00:00		2021-09-30 00:00:00		2021-03-31 00:00:00		2020-09-30 00:00:00		2022-03-31 00:00:00		2020-12-23 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2021-09-30 00:00:00		1900-01-01 00:00:00		2021-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		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2022-03-31 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		2020-06-30 00:00:00		2022-06-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		None		None		None		None		None		None		None		None		None		None		None		None		None		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		22006		22006		22006		22006		None		None		None		22006		22006		None		None		None		22006		22006		None		None		22006		22006		22006		22006		22006		22006		22006		22006		None		None		None		22006		22006		22006		None		22006		22006		22006		None		None		22006		22006		None		22006		None		22006		22006		22006		22006		22006		22006		None		22006		None		22006		None		None		22006		None		None		22006		22006		22006		None		None		22006		22006		None		None		None		None		22006		22006		22006		22006		22006		None		None		22006		22006		22006		22006		None		None		22006		22006		None		22006		22006		22006		22006		None		None		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		None		None		22006		None		22006		None		None		None		None		None		None		None		22006		22006		None		None		22006		None		None		None		None		22006		22006		22006

Table: filer_to_filer_type

filer_id		1347730		1347730		1347730		1347730		1347730		1347730		1347730
filer_type		3		3		3		3		3		3		3
active		Y		Y		Y		Y		Y		Y		N
race		0		None		None		None		None		None		None
session_id		2011		2013		2019		2015		2021		2017		2023
category		0		None		None		None		None		None		None
category_type		0		None		None		None		None		None		None
sub_category		0		None		None		None		None		None		None
effect_dt		2012-04-20 00:00:00		2013-03-06 00:00:00		2019-01-01 00:00:00		2015-01-15 00:00:00		2021-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		None		None		None		None		None		None
election_type		0		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		None		None
party_cd		0		None		None		None		None		None		None
county_cd		0		None		None		None		None		None		None
district_cd		0		None		None		None		None		None		None

Table: filer_xref

filer_id		1347730
xref_id		1347730
effect_dt		2012-05-22 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730
filer_id		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730
filer_type		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM		FIRM
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
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
naml		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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
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
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
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
city		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		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
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
zip4		95835		95834		95814		95814		95814		95814		95814		95814		95814		95814		95835		95834		95814		95814		95814		95814		95814		95814		95814		95814		95835		95834		95814		95814		95814		95814		95814		95814		95814		95814		95835		95834		95814		95814		95814		95814		95814		95814		95814		95814		95835		95834		95814		95814		95814		95814		95814		95814		95814		95814		95835		95834		95814		95814		95814		95814		95814		95814		95814		95814		95835		95834		95814		95814		95814		95814		95814		95814		95814		95814
phon		9163961770		9163961770		9168620941		9164765103		9164765103		9164427757		9164427757		9164765103		9164765103		9164765103		9163961770		9163961770		9168620941		9164765103		9164765103		9164427757		9164427757		9164765103		9164765103		9164765103		9163961770		9163961770		9168620941		9164765103		9164765103		9164427757		9164427757		9164765103		9164765103		9164765103		9163961770		9163961770		9168620941		9164765103		9164765103		9164427757		9164427757		9164765103		9164765103		9164765103		9163961770		9163961770		9168620941		9164765103		9164765103		9164427757		9164427757		9164765103		9164765103		9164765103		9163961770		9163961770		9168620941		9164765103		9164765103		9164427757		9164427757		9164765103		9164765103		9164765103		9163961770		9163961770		9168620941		9164765103		9164765103		9164427757		9164427757		9164765103		9164765103		9164765103
fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
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]

Table: filers

filer_id		1347730

Table: lobbying_chg_log

filer_id		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730		1347730
change_no		0		4		5		6		7		8		15		9		12		10		11		13		14		16		17		18		19		25		26		23		27		22		20		21		24		28		32		33		30		31		29
session_id		2011		2013		2013		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2017		2017		2017		2019		2019		2019		2019		2019		2017		2017		2019		2021		2021		2021		2021		2021		2021
log_dt		2012-04-30 00:00:00		2013-03-07 00:00:00		2013-03-07 00:00:00		2015-04-20 00:00:00		2015-04-20 00:00:00		2015-04-24 00:00:00		2016-11-15 00:00:00		2015-02-13 00:00:00		2015-02-13 00:00:00		2015-02-13 00:00:00		2015-02-13 00:00:00		2015-10-30 00:00:00		2016-10-06 00:00:00		2017-07-18 00:00:00		2017-07-18 00:00:00		2018-01-23 00:00:00		2018-08-13 00:00:00		2020-04-24 00:00:00		2020-04-24 00:00:00		2020-02-18 00:00:00		2020-11-30 00:00:00		2020-01-09 00:00:00		2018-08-30 00:00:00		2018-09-28 00:00:00		2020-02-18 00:00:00		2021-11-08 00:00:00		2021-02-04 00:00:00		2021-02-04 00:00:00		2022-02-22 00:00:00		2021-02-04 00:00:00		2022-02-28 00:00:00
filer_type		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3		3
correction_flg		None		Y		Y		Y		Y		Y		None		Y		Y		Y		Y		Y		None		Y		Y		Y		Y		None		None		None		None		None		None		None		None		None		None		None		None		None		None
action		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		DELETED		DELETED		DELETED		ADDED		ADDED		DELETED		DELETED		DELETED		ADDED		DELETED		DELETED		SET ACTIVE		DELETED		ADDED		ADDED		ADDED		ADDED		ADDED		ADDED		CHANGED
attribute_changed		LOBBYIST		LOBBYIST		/ FIRM		EMPLOYER		EMPLOYER		EMPLOYER		CLIENT		LOBBYIST		EMPLOYER		EMPLOYER		/ FIRM		/ FIRM		CLIENT		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		CLIENT		CLIENT		CLIENT		CLIENT		EMPLOYER		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		ADDRESS AND PHONE
ethics_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
interests		None		None		None		None		None		None		None		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_full_name		SC AND ASSOCIATES		SC AND ASSOCIATES		SC AND ASSOCIATES		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC		CORBIN AND KAISER, LLC
filer_city		None		None		None		None		None		None		None		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		None		None		None		None		SACRAMENTO		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SACRAMENTO
filer_st		None		None		None		None		None		None		None		CA		CA		CA		CA		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA
filer_zip		None		None		None		None		None		None		None		95835		95835		95835		95835		None		None		None		None		95814		None		None		None		None		None		None		None		None		None		None		None		None		None		None		95814
filer_phone		None		None		None		None		None		None		None		9163961770		9163961770		9163961770		9163961770		None		None		None		None		9164765103		None		None		None		None		None		None		None		None		None		None		None		None		None		None		9164427757
entity_type		4		4		1		2		2		2		1		4		2		2		1		1		1		2		2		2		2		1		1		1		1		2		1		1		1		1		1		1		1		1		3
entity_name		SAMANTHA CORBIN		CORBIN, SAMANTHA AYRES		HOWARD ADVOCACY INC.; ED		LAKE TAHOE COMMUNITY COLLEGE		ELECTRONIC FRONTIER FOUNDATION		COMMON SENSE KIDS ACTION		QICO, INC.		CORBIN, SAMANTHA A.		PRIVACY RIGHTS CLEARINGHOUSE		CALIFORNIA TAX REFORM ASSOCIATION		HOWARD ADVOCACY, INC.		HOWARD ADVOCACY, INC.		LAKE TAHOE COMMUNITY COLLEGE		CALIFORNIA CORRECTIONAL PEACE OFFICERS ASSOCIATION BENEFIT TRUST		BEHAVIOR ANALYST CERTIFICATION BOARD		WE SAID ENOUGH		BEHAVIOR ANALYST CERTIFICATION BOARD		EMPIRE GLOBAL VENTURES		MILLER MOBILE NOTARY; MATT		MILLER MOBILE NOTARY; MATT		COMMON SENSE KIDS ACTION		GIFFORDS		LAKE TAHOE COMMUNITY COLLEGE		LAKE TAHOE COMMUNITY COLLEGE		CHARLOTTE'S WEB, INC.		ORIGIN MATERIALS		SAFE CALL NOW		SUNSTREET		ACM-WEST		CROP ORGANIZATION; THE		None
entity_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
entity_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
entity_zip		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
entity_id		1347731		1347731		1282191		1377054		1377880		1377882		1392407		None		None		None		None		1282191		1377054		1395069		1338458		None		1338458		1423415		1425051		1425051		1377882		1417252		1377054		1377054		1425399		1442539		1445892		1425656		1445875		1445889		0
responsible_officer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		2012-04-20 00:00:00		2013-03-06 00:00:00		2013-03-06 00:00:00		2015-03-30 00:00:00		2015-04-17 00:00:00		2015-04-17 00:00:00		2016-11-15 00:00:00		2015-01-15 00:00:00		2015-01-15 00:00:00		2015-01-30 00:00:00		2015-01-30 00:00:00		2015-10-31 00:00:00		2015-10-30 00:00:00		2017-07-18 00:00:00		2017-08-01 00:00:00		2018-01-11 00:00:00		2018-07-31 00:00:00		2020-03-31 00:00:00		2020-03-31 00:00:00		2020-01-15 00:00:00		2020-09-13 00:00:00		2019-12-31 00:00:00		2018-05-01 00:00:00		2018-06-30 00:00:00		2020-02-01 00:00:00		2021-11-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-11-15 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00

Table: received_filings

filer_id		1347730		1347730		1347730		1347730
filing_file_name		1846392_0.cal		1731937_0.cal		1966428_0.cal		2538257_0.cal
received_date		2014-04-30 00:00:00		2013-01-24 00:00:00		2015-04-30 00:00:00		2020-12-23 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		1846392		1731937		1966428		2538257
form_id		F601		F601		F601		F601
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted