Home

Filer ID: 1302802

Table: cvr_lobby_disclosure

filing_id		1371200		1325981		1344209		1307159		1450197		1421483		1436313		1396852		1532734		1483021		1504272		1462285		1570726		1622099		1605252		1605252		1590344		1634376		1707539		1674402		1655225		1738743		1797845		1816407		1782241		1763460		1870173		1843497		1929892		1910151		1980679		1965546		2007094		1995300		2059556		2036128		2101327		2175794		2155330		2122337		2188791		2204281		2273529		2243041		2393718		2320074		2379850		2338342		2415388		2469576		2441270		2555056		2484685		2529580		2625591		2603532		2581669		2678244		2739767		2645598		2700868
amend_id		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		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		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
sender_id		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802
filer_id		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802
entity_cd		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM
filer_naml		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF
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
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
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
report_num		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		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		2008-10-20 00:00:00		2008-04-15 00:00:00		2008-07-11 00:00:00		2008-01-16 00:00:00		2009-10-23 00:00:00		2009-04-21 00:00:00		2009-07-24 00:00:00		2009-01-20 00:00:00		2010-10-14 00:00:00		2010-04-19 00:00:00		2010-07-26 00:00:00		2010-01-20 00:00:00		2011-01-14 00:00:00		2011-10-10 00:00:00		2011-10-13 00:00:00		2011-07-12 00:00:00		2011-04-11 00:00:00		2012-01-17 00:00:00		2012-10-17 00:00:00		2012-07-17 00:00:00		2012-04-16 00:00:00		2013-01-17 00:00:00		2013-10-15 00:00:00		2014-01-13 00:00:00		2013-07-22 00:00:00		2013-04-12 00:00:00		2014-07-10 00:00:00		2014-04-15 00:00:00		2015-01-19 00:00:00		2014-10-07 00:00:00		2015-07-10 00:00:00		2015-04-08 00:00:00		2016-01-13 00:00:00		2015-10-14 00:00:00		2016-07-12 00:00:00		2016-04-14 00:00:00		2016-10-19 00:00:00		2017-07-12 00:00:00		2017-04-20 00:00:00		2017-01-12 00:00:00		2017-07-12 00:00:00		2018-01-14 00:00:00		2018-07-17 00:00:00		2018-04-12 00:00:00		2019-07-14 00:00:00		2018-10-23 00:00:00		2019-04-15 00:00:00		2019-01-14 00:00:00		2019-10-16 00:00:00		2020-04-30 00:00:00		2020-01-31 00:00:00		2021-01-31 00:00:00		2020-07-31 00:00:00		2020-10-31 00:00:00		2021-10-31 00:00:00		2021-07-31 00:00:00		2021-04-30 00:00:00		2022-04-30 00:00:00		2022-10-31 00:00:00		2022-01-31 00:00:00		2022-07-31 00:00:00
from_date		2008-07-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2007-10-01 00:00:00		2009-07-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2008-10-01 00:00:00		2010-07-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2009-10-01 00:00:00		2010-10-01 00:00:00		2011-07-01 00:00:00		2011-04-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		2002-10-01 00:00:00		2013-07-01 00:00:00		2013-10-01 00:00:00		2013-04-01 00:00:00		2013-01-01 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		2014-10-01 00:00:00		2014-07-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2015-10-01 00:00:00		2015-07-01 00:00:00		2016-04-01 00:00:00		2016-01-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		2017-10-01 00:00:00		2018-04-01 00:00:00		2018-01-01 00:00:00		2019-04-01 00:00:00		2018-07-01 00:00:00		2019-01-01 00:00:00		2018-10-01 00:00:00		2019-07-01 00:00:00		2020-01-01 00:00:00		2019-10-01 00:00:00		2020-10-01 00:00:00		2020-04-01 00:00:00		2020-07-01 00:00:00		2021-07-01 00:00:00		2021-04-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00		2021-10-01 00:00:00		2022-04-01 00:00:00
thru_date		2008-09-30 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2007-12-31 00:00:00		2009-09-30 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2008-12-31 00:00:00		2010-09-30 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2009-12-31 00:00:00		2010-12-31 00:00:00		2011-09-30 00:00:00		2011-06-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-12-31 00:00:00		2013-06-30 00:00:00		2013-03-31 00:00:00		2014-06-30 00:00:00		2014-03-31 00:00:00		2014-12-31 00:00:00		2014-09-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2015-12-31 00:00:00		2015-09-30 00:00:00		2016-06-30 00:00:00		2016-03-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		2017-12-31 00:00:00		2018-06-30 00:00:00		2018-03-31 00:00:00		2019-06-30 00:00:00		2018-09-30 00:00:00		2019-03-31 00:00:00		2018-12-31 00:00:00		2019-09-30 00:00:00		2020-03-31 00:00:00		2019-12-31 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		2020-09-30 00:00:00		2021-09-30 00:00:00		2021-06-30 00:00:00		2021-03-31 00:00:00		2022-03-31 00:00:00		2022-09-30 00:00:00		2021-12-31 00:00:00		2022-06-30 00:00:00
cum_beg_dt		2007-10-01 00:00:00		2007-10-01 00:00:00		2007-10-01 00:00:00		2007-10-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2007-10-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2015-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		2019-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-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
firm_id		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802
firm_name		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF
firm_city		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE
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
firm_zip4		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274
firm_phon		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 685-2300		559 685-2300		559 685-2300		559 684-4200		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 685-2300		559 684-4200		559 685-2300		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200
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		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		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		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		None		None		None		None		None		None
sig_date		2008-10-20 00:00:00		2008-04-14 00:00:00		2008-07-11 00:00:00		2008-01-16 00:00:00		2009-10-23 00:00:00		2009-04-21 00:00:00		2009-07-24 00:00:00		2009-01-20 00:00:00		2010-10-14 00:00:00		2010-04-19 00:00:00		2010-07-26 00:00:00		2010-01-20 00:00:00		2011-01-14 00:00:00		2011-10-10 00:00:00		2011-10-13 00:00:00		2011-07-12 00:00:00		2011-04-11 00:00:00		2012-01-17 00:00:00		2012-10-17 00:00:00		2012-07-17 00:00:00		2012-04-13 00:00:00		2013-01-17 00:00:00		2013-10-15 00:00:00		2014-01-13 00:00:00		2013-07-22 00:00:00		2013-04-12 00:00:00		2014-07-10 00:00:00		2014-04-15 00:00:00		2015-01-19 00:00:00		2014-10-07 00:00:00		2015-07-10 00:00:00		2015-04-08 00:00:00		2016-01-13 00:00:00		2015-10-14 00:00:00		2016-07-12 00:00:00		2016-04-14 00:00:00		2016-10-19 00:00:00		2017-07-12 00:00:00		2017-04-12 00:00:00		2017-01-12 00:00:00		2017-10-13 00:00:00		2018-01-14 00:00:00		2018-07-17 00:00:00		2018-04-12 00:00:00		2019-07-14 00:00:00		2018-10-23 00:00:00		2019-04-15 00:00:00		2019-01-14 00:00:00		2019-10-16 00:00:00		2020-04-17 00:00:00		2020-01-24 00:00:00		2021-01-24 00:00:00		2020-07-21 00:00:00		2020-10-26 00:00:00		2021-10-25 00:00:00		2021-07-25 00:00:00		2021-04-22 00:00:00		2022-04-16 00:00:00		2022-10-20 00:00:00		2022-01-25 00:00:00		2022-07-18 00:00:00
sig_loc		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA
sig_naml		YADER		YADER		YADER		LOCKER		YODER		YODER		YODER		YADER		YODER		YODER		YODER		YODER		YODER		YODER		MEINERT		MEINERT		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		HERMANN		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		HERMANN		HERMANN		YODER		HERMANN
sig_namf		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		DANIEL L.		DANIEL L.		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		MELISSA		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		MELISSA		MELISSA		ROXANNE		MELISSA
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
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
prn_naml		YADER		YADER		YADER		LOCKER		YODER		YODER		YODER		YADER		YODER		YODER		YODER		YODER		YODER		YODER		MEINERT		MEINERT		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		HERMANN		YODER		YODER		YODER		YODER		YODER		YODER		YODER		YODER		HERMANN		HERMANN		YODER		HERMANN
prn_namf		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		DANIEL L.		DANIEL L.		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		MELISSA		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		ROXANNE		MELISSA		MELISSA		ROXANNE		MELISSA
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
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
sig_title		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		INTERIM CITY MANAGER 425900SB		INTERIM CITY MANAGER 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		CHIEF DEPUTY CITY CLERK 425900SB		DEPUTY CITY CLERK		CITY MANAGER		CITY MANAGER		CITY MANAGER		CITY MANAGER		CITY MANAGER		CITY MANAGER		CITY MANAGER		CITY MANAGER		CHIEF DEPUTY CITY CLERK		CHIEF DEPUTY CITY CLERK		CITY MANAGER		CHIEF DEPUTY CITY CLERK
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
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
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		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		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
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
lby_actvty		Business, Transportation and Housing Agency, Public Utilities Commission, California Transportation Commission, California High Speed Rail Authority, Caltrans - Grade separation program. Department of Housing and Community Development - Infill Infrastructure Grant Program.		Business, Transportation and Housing Agency, Public Utilities Commission - Grade separation program. Department of Housing and Community Development - Infill Infrastructure Grant Program.		Business, Transportation and Housing Agency, Public Utilities Commission - Grade separation program. Department of Housing and Community Development - Infill Infrastructure Grant Program.		Business, Transportation and Housing Agency, Public Utilities Commission - Grade separation program. Department of Housing and Community Development - Infill Infrastructure Grant Program.		Business, Transportation and Housing Agency, Public Utilities Commission, California Transportation Commission, California High Speed Rail Authority, Caltrans - Grade separation program. State Legislature and Administration - Budget		Business, Transportation and Housing Agency, Public Utilities Commission, California Transportation Commission, California High Speed Rail Authority, Caltrans - Grade separation program. State Legislature and Administration - Budget		Business, Transportation and Housing Agency, Public Utilities Commission, California Transportation Commission, California High Speed Rail Authority, Caltrans - Grade separation program. State Legislature and Administration - Budget		Business, Transportation and Housing Agency, Public Utilities Commission, California Transportation Commission, California High Speed Rail Authority, Caltrans - Grade separation program. Department of Housing and Community Development - Infill Infrastructure Grant Program. State Legislature and Administration - Budget, Local business issues		Department of Parks and Recreation - Parks Program, Nature Education Facilities. Business, Transportation and Housing Agency, Public Utilities Commission, California Transportation Commission, California High Speed Rail Authority, Caltrans - Grade separation program. Legislature - Budget.		Business, Transportation and Housing Agency, Public Utilities Commission, California Transportation Commission, California High Speed Rail Authority, Caltrans - Grade separation program. State Legislature and Administration - Budget. Department of Parks and Recreation - Prop 84 grant funding.		Department of Parks and Recreation - Parks Program, Nature Education Facilities. Business, Transportation and Housing Agency, Public Utilities Commission, California Transportation Commission, California High Speed Rail Authority, Caltrans - Grade separation program. Legislature - Budget, SB 974.		Business, Transportation and Housing Agency, Public Utilities Commission, California Transportation Commission, California High Speed Rail Authority, Caltrans - Grade separation program. State Legislature and Administration - Budget		Department of Parks and Recreation - Parks Program, Nature Education Facilities. Business, Transportation and Housing Agency, Public Utilities Commission, California Transportation Commission, California High Speed Rail Authority, Caltrans - Grade separation program. Legislature - Budget.		Department of Parks and Recreation - Nature Education Facilities. Natural Resources Agency, Strategic Growth Council - Urban Greening Program. Legislature and Administration - Budget, Enterprise Zone program, AB 16x, AB 25x, AB 26x, AB 27x, AB 41x, SB 87, SB 89, SB 286, SB 450, SB 4x, SB 8x, SB 16x.		Natural Resources Agency, Strategic Growth Council - Urban Greening Program. Department of Parks and Recreation - Nature Education Facilities. Legislature and Administration - Budget, Enterprise Zones, AB 98, AB 101, AB 103, AB 1250, AB 26x, AB 27x, SB 69, SB 77, SB 87, SB 89, SB 286.		Natural Resources Agency, Strategic Growth Council - Urban Greening Program. Department of Parks and Recreation - Nature Education Facilities. Legislature and Administration - Budget, Enterprise Zones, AB 98, AB 101, AB 103, AB 1250, AB 26x, AB 27x, SB 69, SB 77, SB 87, SB 89, SB 286.		Legislature and Administration - Budget, Enterprise Zones, Redevelopment, AB 101, AB 103,AB 231, AB 232, SB 69, SB 77, SB 79.		Department of Parks and Recreation - Nature Education Facilities. Natural Resources Agency, Strategic Growth Council - Urban Greening Program. Legislature and Administration - Enterprise Zone program, AB 16x, AB 26x, SB 450, SB 4x, SB 8x.		SEE ATTACHMENT A		SEE ATTACHMENT A		SEE ATTACHMENT A		Natural Resources Agency, Strategic Growth Council - Urban Greening Program. Caltrans - Environmental Enhancement and Mitigation. California Transportation Commission-Proposition 1B. Legislature and Administration - Budget.		See Attachment A		Legislature and Administration. AB 218, AB 325, AB 537, AB 683, AB 755, AB 1229, AB 1373, SB 7, SB 313.		See Attachment A		See Attachment A		SEE ATTACHMENT A		SEE ATTACHMENT A		Legislature; California Transportation Commission Re: Active Transportation Program.		Legislature; California Transportation Commission Re: Active Transportation Program. AB 194, AB 1193, AB 1439, AB 1442, AB 1521, AB 1537, AB 1582, AB 1690, AB 1716, AB 1717, AB 1793, AB 1795, AB 1963, AB 1965, AB 2040, AB 2100, AB 2117, AB 2126, AB 2188, AB 2280, AB 2355, AB 2371, AB 2492, AB 2493, AB 2618, ACA 8, SB 266, SB 270, SB 391, SB 674, SB 1033, SB 1086, SB 1129, SB 1183.		Legislature Re: Budget; Department of Transportation Re: Division of Rail. AB 34, AB 35, AB 617, AB 718, AB 857, AB 1335, SB 608.		SEE ATTACHMENT A		Legislature RE: Budget; Legislature, State Water Resources Control Board, Administration RE: Groundwater Management Act. AB 35, AB 617, SB 608.		Legislature RE: Budget; Legislature, State Water Resources Control Board, Administration RE: Groundwater Management Act. AB 34, AB 35, AB 113, AB 617, AB 718, AB 857, AB 1335, SB 16, SB 608, SBX1-1		SEE ATTACHMENT A		SEE ATTACHMENT A		SEE ATTACHMENT A		SEE ATTACHMENT A		SEE ATTACHMENT A		Legislature RE: Budget; State Water Resources Control Board, Administration RE: Groundwater Management Act.		SEE ATTACHMENT A		SEE ATTACHMENT A		SEE ATTACHMENT A		SEE ATTACHMENT A		SEE ATTACHMENT A		SEE ATTACHMENT A		SEE ATTACHMENT A		Legislature RE: Budget and Transportation Funding; Department of Transportation RE: Sustainable Transportation Planning Grant Program; State Water Resources Control Board, Administration RE: Groundwater Management Act		SEE ATTACHMENT A		SEE ATTACHMENT A		SEE ATTACHMENT A		See Attachment A		See Attachment A		See Attachment A		See Attachment A		See Attachment A		See Attachment A		Legislature Re: Budget and Municipal Funding		Legislature Re: Budget and Municipal Funding; Department of Motor Vehicles re: DMV field office relocation; Department of General Services re: DMV field office relocation; AB 178, SB 178, AB 1923, AB 2211, AB 1951		Legislature Re: Budget and Municipal Funding; Business Consumer Services and Housing Agency Re: Homelessness and Housing Funding		Legislature Re: Budget and Municipal Funding; AB 178, SB 178, AB 1923, AB 2211
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		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		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
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
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
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
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
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

Table: cvr_registration

filing_id		1301214		1386966		1556619		1722269		1925129		2110611		2340362		2544278
amend_id		0		0		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F602		F602		F602		F602		F602		F602		F602		F602
sender_id		F24882		F24882		F24882		F24882		F24882		F24882		F24882		F24882
filer_id		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802
entity_cd		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM
filer_naml		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF		TULARE, CITY OF
filer_namf		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None
report_num		000		000		000		000		000		000		000		000
rpt_date		2007-12-14 00:00:00		2008-12-23 00:00:00		2010-12-23 00:00:00		2013-01-02 00:00:00		2014-12-22 00:00:00		2016-10-19 00:00:00		2018-11-09 00:00:00		2020-12-31 00:00:00
ls_beg_yr		2007		2009		2011		2013		2015		2017		2019		2021
ls_end_yr		2008		2010		2012		2014		2016		2018		2020		2022
qual_date		None		None		None		None		None		None		None		None
eff_date		2007-10-02 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00
bus_city		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE
bus_st		CA		CA		CA		CA		CA		CA		CA		CA
bus_zip4		93274		93274		93274		93274		93274		93274		93274		93274
bus_phon		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200		559 684-4200
bus_fax		None		None		None		None		None		None		None		None
bus_email		None		None		None		None		None		None		None		None
mail_city		None		None		None		None		None		None		None		None
mail_st		None		None		None		None		None		None		None		None
mail_zip4		None		None		None		None		None		None		None		None
mail_phon		None		None		None		None		None		None		None		None
sig_date		2007-12-14 00:00:00		2008-12-15 00:00:00		2010-12-16 00:00:00		2012-12-13 00:00:00		2014-07-01 00:00:00		2016-10-19 00:00:00		2018-11-09 00:00:00		2020-12-01 00:00:00
sig_loc		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA		TULARE, CA
sig_naml		DARREL L.		YODER		YODER		DORMAN		DORMAN		YODER		YODER		YODER
sig_namf		PYLE		ROXANNE		ROXANNE		DON		DON		ROXANNE		ROXANNE		ROXANNE
sig_namt		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None
prn_naml		DARREL L.		YODER		YODER		DORMAN		DORMAN		YODER		YODER		YODER
prn_namf		PYLE		ROXANNE		ROXANNE		DON		DON		ROXANNE		ROXANNE		ROXANNE
prn_namt		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None
sig_title		CITY MANAGER, 425900SB		CHIEF CITY DEP. CLERK, 425900SB		CHIEF CITY DEP. CLERK, 425900SB		CITY MANAGER 425900SB		CITY MANAGER 425900SB		CHIEF DEPUTY CITY CLERK 425900SSB		CHIEF DEPUTY CITY CLERK 425900SSB		CITY MANAGER
stmt_firm		None		None		None		None		None		None		None		None
ind_cb		None		None		None		None		None		None		None		None
bus_cb		None		None		None		None		None		None		None		None
trade_cb		None		None		None		None		None		None		None		None
oth_cb		X		X		X		X		X		X		X		X
a_b_name		None		None		None		None		None		None		None		None
a_b_city		None		None		None		None		None		None		None		None
a_b_st		None		None		None		None		None		None		None		None
a_b_zip4		None		None		None		None		None		None		None		None
descrip_1		LOCAL GOVERNMENT		LOCAL GOVERNMENT		LOCAL GOVERNMENT		MUNICIPAL GOVERNMENT		GOVERNOR AND LEGISLATURE		GOVERNOR AND LEGISLATURE		GOVERNOR AND LEGISLATURE		MUNICIPAL GOVERNMENT
descrip_2		None		None		None		None		None		None		None		MUNICIPAL GOVERNMENT
c_less50		None		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None		None
ind_class		GOV		GOV		GOV		GOV		GOV		GOV		GOV		GOV
ind_descr		None		None		None		None		None		None		None		None
bus_class		None		None		None		None		None		None		None		None
bus_descr		None		None		None		None		None		None		None		None
auth_name		TOWNSEND PUBLIC AFFAIRS, INC.		TOWNSEND PUBLIC AFFAIRS, INC.		TOWNSEND PUBLIC AFFAIRS, INC.		TOWNSEND PUBLIC AFFAIRS, INC.		TOWNSEND PUBLIC AFFAIRS, INC.		TOWNSEND PUBLIC AFFAIRS, INC.		TOWNSEND PUBLIC AFFAIRS, INC.		TOWNSEND PUBLIC AFFAIRS, INC.
auth_city		IRVINE		IRVINE		IRVINE		IRVINE		NEWPORT BEACH		NEWPORT BEACH		NEWPORT BEACH		NEWPORT BEACH
auth_st		CA		CA		CA		CA		CA		CA		CA		CA
auth_zip4		92614		92614		92614		92614		92660		92660		92660		92660
lobby_int		None		None		None		None		None		None		None		None
influen_yn		None		None		None		None		None		None		None		None
firm_name		None		None		None		None		None		None		None		None
newcert_cb		None		None		None		None		None		None		None		None
rencert_cb		None		None		None		None		None		None		None		None
complet_dt		None		None		None		None		None		None		None		None
lby_reg_cb		None		None		None		None		None		None		None		None
lby_604_cb		None		None		None		None		None		None		None		None
st_leg_yn		None		None		None		None		None		None		None		None
st_agency		None		None		None		None		None		None		None		None
lobby_cb		None		None		None		None		None		None		None		None
l_firm_cb		None		None		None		None		None		None		None		None

Table: filer_address

filer_id		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802
adrid		2131147		2163969		2207804		2514743		2418758		2471581		2277767		2344314		2551452
effect_dt		2007-10-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2021-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2013-01-01 00:00:00		2015-01-01 00:00:00		2023-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		2007		2009		2011		2021		2017		2019		2013		2015		2023

Table: filer_filings

filer_id		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802
filing_id		1307159		1301018		1301020		1301214		1782241		1939709		1980679		1965546		1870173		1797845		1910151		1344209		1325981		1371200		1386966		1396852		1412880		1421483		1450197		1436313		1462285		1483021		1504272		1532734		1556619		1560968		1570726		1590344		1622099		1605252		1634376		1605252		1655225		1674402		1925129		1707539		1729948		1722269		1738743		1843497		1816407		1763460		1995300		1929892		2320074		2555056		2338342		2529580		2188791		2415388		2007094		2036128		2059556		2101327		2122337		2110611		2155330		2133425		2175794		2340362		2365944		2484685		2544278		2204281		2379850		2273529		2393718		2243041		2441270		2469576		2586377		2581669		2678244		2603532		2700868		2625591		2645598		2739767
period_id		192		None		None		192		214		None		222		221		218		215		219		194		193		195		196		196		None		197		199		198		200		201		202		203		204		None		204		205		207		206		208		206		209		210		220		211		None		213		172		217		216		213		223		220		235		244		236		243		231		239		224		225		226		227		228		228		229		None		230		236		None		242		244		232		237		234		238		233		240		241		None		245		249		246		250		247		248		251
form_id		F635		F602		F999		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F602		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635
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		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		0		0		0		0		0		0		0		0		0		0		0
filing_date		2008-01-28 00:00:00		2007-12-11 00:00:00		2007-12-12 00:00:00		2007-12-14 00:00:00		2013-07-31 00:00:00		2014-12-30 00:00:00		2015-07-30 00:00:00		2015-04-30 00:00:00		2014-07-30 00:00:00		2013-10-28 00:00:00		2014-10-30 00:00:00		2008-07-18 00:00:00		2008-04-22 00:00:00		2008-10-24 00:00:00		2008-12-31 00:00:00		2009-02-01 00:00:00		2008-12-31 00:00:00		2009-04-30 00:00:00		2009-10-27 00:00:00		2009-07-30 00:00:00		2010-01-28 00:00:00		2010-04-27 00:00:00		2010-07-28 00:00:00		2010-10-22 00:00:00		2011-01-04 00:00:00		2011-01-04 00:00:00		2011-01-31 00:00:00		2011-04-29 00:00:00		2011-10-31 00:00:00		2011-07-28 00:00:00		2012-01-30 00:00:00		2011-10-14 00:00:00		2012-04-26 00:00:00		2012-07-25 00:00:00		2015-01-13 00:00:00		2012-10-30 00:00:00		2013-01-03 00:00:00		2013-01-02 00:00:00		2013-01-31 00:00:00		2014-04-29 00:00:00		2014-01-30 00:00:00		2013-04-29 00:00:00		2015-10-28 00:00:00		2015-01-26 00:00:00		2018-10-31 00:00:00		2021-02-01 00:00:00		2019-01-23 00:00:00		2020-11-01 00:00:00		2017-10-19 00:00:00		2019-10-24 00:00:00		2016-01-26 00:00:00		2016-04-29 00:00:00		2016-07-27 00:00:00		2016-10-31 00:00:00		2017-01-23 00:00:00		2016-12-13 00:00:00		2017-04-28 00:00:00		2016-12-14 00:00:00		2017-07-31 00:00:00		2019-01-25 00:00:00		2019-01-25 00:00:00		2020-07-30 00:00:00		2021-01-14 00:00:00		2018-01-23 00:00:00		2019-04-30 00:00:00		2018-07-31 00:00:00		2019-07-26 00:00:00		2018-04-30 00:00:00		2020-01-30 00:00:00		2020-04-29 00:00:00		2021-01-14 00:00:00		2021-04-30 00:00:00		2022-05-02 00:00:00		2021-08-02 00:00:00		2022-07-25 00:00:00		2021-11-01 00:00:00		2022-01-31 00:00:00		2022-10-24 00:00:00
stmnt_type		10001		10005		10005		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		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		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003
session_id		2007		2007		2007		2007		2013		2015		2015		2015		2013		2013		2013		2007		2007		2007		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2011		2011		2011		2011		2011		2011		2011		2015		2011		2013		2013		2001		2013		2013		2013		2015		2013		2017		2019		2017		2019		2017		2019		2015		2015		2015		2015		2015		2017		2017		2017		2017		2019		2019		2019		2021		2017		2019		2017		2019		2017		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021
user_id		LTHIBAUL		SARRIAGA		SARRIAGA		*		AGLADNEY		GKURIMOT		AGLADNEY		AGLADNEY		ASAETERN		ASAETERN		AGLADNEY		LTHIBAUL		RGEREMIA		JINGRAM		*		JINGRAM		SARRIAGA		JINGRAM		JINGRAM		JINGRAM		JINGRAM		ASAETERN		ASAETERN		ASAETERN		*		GKURIMOT		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		ASAETERN		AGLADNEY		ASAETERN		ASAETERN		CAFILER		AGLADNEY		PBANFORD		PBANFORD		CAFILER		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		MPACHECO		AGLADNEY		GTAYLOR		AGLADNEY		GTAYLOR		AGLADNEY		SUSHAKOV		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		AGLADNEY		PBANFORD		AGLADNEY		SARRIAGA		SARRIAGA		GTAYLOR		AROJAS		AGLADNEY		GTAYLOR		AGLADNEY		VUKSTINA		AGLADNEY		GTAYLOR		SUSHAKOV		CVANLIEW		GTAYLOR		CAFILER		GTAYLOR		CAFILER		CHATRIDGE		CHATRIDGE		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
fine_audit		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11003		11001		11001		11003
rpt_start		2007-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-12-14 00:00:00		2013-04-01 00:00:00		1900-01-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2014-04-01 00:00:00		2013-07-01 00:00:00		2014-07-01 00:00:00		2008-04-01 00:00:00		2008-01-01 00:00:00		2008-07-01 00:00:00		2008-12-23 00:00:00		2008-10-01 00:00:00		1900-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-12-23 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2011-04-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2014-12-22 00:00:00		2012-07-01 00:00:00		1900-01-01 00:00:00		2013-01-02 00:00:00		2002-10-01 00:00:00		2014-01-01 00:00:00		2013-10-01 00:00:00		2013-01-01 00:00:00		2015-07-01 00:00:00		2014-10-01 00:00:00		2018-07-01 00:00:00		2020-10-01 00:00:00		2018-10-01 00:00:00		2020-07-01 00:00:00		2017-07-01 00:00:00		2019-07-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-10-19 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		2018-11-09 00:00:00		1900-01-01 00:00:00		2020-04-01 00:00:00		2020-12-31 00:00:00		2017-10-01 00:00:00		2019-01-01 00:00:00		2018-04-01 00:00:00		2019-04-01 00:00:00		2018-01-01 00:00:00		2019-10-01 00:00:00		2020-01-01 00:00:00		1900-01-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2021-04-01 00:00:00		2022-04-01 00:00:00		2021-07-01 00:00:00		2021-10-01 00:00:00		2022-07-01 00:00:00
rpt_end		2007-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-12-14 00:00:00		2013-06-30 00:00:00		1900-01-01 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2014-06-30 00:00:00		2013-09-30 00:00:00		2014-09-30 00:00:00		2008-06-30 00:00:00		2008-03-31 00:00:00		2008-09-30 00:00:00		2008-12-23 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		2009-03-31 00:00:00		2009-09-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-12-23 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-09-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-06-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2014-12-22 00:00:00		2012-09-30 00:00:00		1900-01-01 00:00:00		2013-01-02 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2013-12-31 00:00:00		2013-03-31 00:00:00		2015-09-30 00:00:00		2014-12-31 00:00:00		2018-09-30 00:00:00		2020-12-31 00:00:00		2018-12-31 00:00:00		2020-09-30 00:00:00		2017-09-30 00:00:00		2019-09-30 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-10-19 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		2018-11-09 00:00:00		1900-01-01 00:00:00		2020-06-30 00:00:00		2020-12-31 00:00:00		2017-12-31 00:00:00		2019-03-31 00:00:00		2018-06-30 00:00:00		2019-06-30 00:00:00		2018-03-31 00:00:00		2019-12-31 00:00:00		2020-03-31 00:00:00		1900-01-01 00:00:00		2021-03-31 00:00:00		2022-03-31 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		2021-09-30 00:00:00		2021-12-31 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
filing_type		22001		None		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		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		22001		None		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001

Table: filer_interests

filer_id		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802
session_id		2013		2009		2011		2007		2015		2017		2021		2019		2023
interest_cd		40305		40305		40305		40305		40305		40305		40305		40305		40305
effect_date		2013-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2007-10-01 00:00:00		2015-01-01 00:00:00		2017-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802
filer_type		1		1		1		1		1		1		1		1		1
active		Y		Y		Y		Y		Y		Y		Y		Y		N
race		0		None		None		None		None		None		None		None		None
session_id		2007		2011		2013		2009		2017		2015		2021		2019		2023
category		0		None		None		None		None		None		None		None		None
category_type		0		None		None		None		None		None		None		None		None
sub_category		0		None		None		None		None		None		None		None		None
effect_dt		2007-10-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2009-01-01 00:00:00		2017-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		None		None		None		None		None		None		None		None
election_type		0		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		None		None		None		None		None
party_cd		0		None		None		None		None		None		None		None		None
county_cd		0		None		None		None		None		None		None		None		None
district_cd		0		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1302802
xref_id		1302802
effect_dt		2007-12-12 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802
filer_id		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802
filer_type		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
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		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF		TULARE; CITY OF
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		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		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		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE		TULARE
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		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274		93274
phon		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200		5596844200
fax		5596852398																		5596852398																		5596852398																		5596852398																		5596852398																		5596852398																		5596852398																		5596852398																		5596852398
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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: filers

filer_id		1302802

Table: lobbying_chg_log

filer_id		1302802
change_no		0
session_id		2007
log_dt		2007-12-11 00:00:00
filer_type		1
correction_flg		Y
action		ADDED
attribute_changed		FIRM
ethics_dt		None
interests		None
filer_full_name		TULARE; CITY OF
filer_city		None
filer_st		None
filer_zip		None
filer_phone		None
entity_type		3
entity_name		TOWNSEND PUBLIC AFFAIRS, INC.
entity_city		None
entity_st		None
entity_zip		None
entity_phone		None
entity_id		1147750
responsible_officer		None
effect_dt		2007-10-01 00:00:00

Table: received_filings

filer_id		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802		1302802
filing_file_name		1504272_0.cal		1396852_0.cal		1344209_0.cal		1462285_0.cal		1371200_0.cal		1483021_0.cal		1436313_0.cal		261368.cal		1450197_0.cal		1421483_0.cal		1307159_0.cal		1325981_0.cal		1843497_0.cal		1738743_0.cal		1782241_0.cal		1797845_0.cal		1532734_0.cal		1570726_0.cal		1816407_0.cal		1605252_1.cal		1590344_0.cal		1605252_0.cal		1763460_0.cal		228739.cal		1622099_0.cal		67125.cal		1634376_0.cal		1707539_0.cal		1674402_0.cal		1655225_0.cal		1870173_0.cal		1980679_0.cal		1965546_0.cal		2122337_0.cal		2059556_0.cal		2007094_0.cal		1995300_0.cal		2155330_0.cal		2101327_0.cal		1910151_0.cal		1929892_0.cal		2036128_0.cal		2175794_0.cal		2320074_0.cal		2379850_0.cal		2338342_0.cal		2469576_0.cal		2188791_0.cal		2484685_0.cal		2415388_0.cal		2393718_0.cal		2204281_0.cal		2441270_0.cal		2273529_0.cal		2243041_0.cal		2603532_0.cal		2529580_0.cal		2700868_0.cal		2625591_0.cal		2555056_0.cal		2678244_0.cal		2739767_0.cal		2645598_0.cal		2581669_0.cal
received_date		2010-07-28 00:00:00		2009-02-01 00:00:00		2008-07-18 00:00:00		2010-01-28 00:00:00		2008-10-24 00:00:00		2010-04-27 00:00:00		2009-07-30 00:00:00		2009-07-27 00:00:00		2009-10-27 00:00:00		2009-04-30 00:00:00		2008-01-28 00:00:00		2008-04-22 00:00:00		2014-04-29 00:00:00		2013-01-31 00:00:00		2013-07-31 00:00:00		2013-10-28 00:00:00		2010-10-22 00:00:00		2011-01-31 00:00:00		2014-01-30 00:00:00		2011-10-14 00:00:00		2011-04-29 00:00:00		2011-07-28 00:00:00		2013-04-29 00:00:00		2011-10-31 00:00:00		2011-10-31 00:00:00		2012-01-30 00:00:00		2012-01-30 00:00:00		2012-10-30 00:00:00		2012-07-25 00:00:00		2012-04-26 00:00:00		2014-07-30 00:00:00		2015-07-30 00:00:00		2015-04-30 00:00:00		2017-01-23 00:00:00		2016-07-27 00:00:00		2016-01-26 00:00:00		2015-10-28 00:00:00		2017-04-28 00:00:00		2016-10-31 00:00:00		2014-10-30 00:00:00		2015-01-26 00:00:00		2016-04-29 00:00:00		2017-07-31 00:00:00		2018-10-31 00:00:00		2019-04-30 00:00:00		2019-01-23 00:00:00		2020-04-29 00:00:00		2017-10-19 00:00:00		2020-07-30 00:00:00		2019-10-24 00:00:00		2019-07-26 00:00:00		2018-01-23 00:00:00		2020-01-30 00:00:00		2018-07-31 00:00:00		2018-04-30 00:00:00		2021-08-02 00:00:00		2020-11-01 00:00:00		2022-07-25 00:00:00		2021-11-01 00:00:00		2021-02-01 00:00:00		2022-05-02 00:00:00		2022-10-24 00:00:00		2022-01-31 00:00:00		2021-04-30 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/temp		/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/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		1504272		1396852		1344209		1462285		1371200		1483021		1436313		None		1450197		1421483		1307159		1325981		1843497		1738743		1782241		1797845		1532734		1570726		1816407		1605252		1590344		1605252		1763460		None		1622099		None		1634376		1707539		1674402		1655225		1870173		1980679		1965546		2122337		2059556		2007094		1995300		2155330		2101327		1910151		1929892		2036128		2175794		2320074		2379850		2338342		2469576		2188791		2484685		2415388		2393718		2204281		2441270		2273529		2243041		2603532		2529580		2700868		2625591		2555056		2678244		2739767		2645598		2581669
form_id		F635		F635		F635		F635		F635		F635		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		None		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		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 did not pass validation		Filing accepted		Filing did not pass validation		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