Home

Filer ID: 1279687

Table: cvr_lobby_disclosure

filing_id		1146400		1167276		1134200		1283347		1234726		1191088		1262461		1215890		1329609		1311423		1349902		1297479		1421541		1452426		1377401		1437175		1394991		1507345		1463721		1485308		1570618		1540200		1607987		1621326		1591632		1637120		1709981		1680483		1657289		1739511		1764780		1816216		1870101		1843457		1929822		1910044		2011381		2059793		2031656		2092698		2168009		2152739		2118101		2092698		2186887		2271468		2240386		2201320		2392982		2378010		2310273		2333659		2467546		2414952		2436574		2479559		2573735		2547327		2467546		2519740		2592686		2636171		2616298		2738340		2697227		2666894
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		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		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		F635		F635		F635		F635		F635
sender_id		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687
filer_id		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687
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		LEM		LEM		LEM		LEM		LEM
filer_naml		City of Delano		City of Delano		City of Delano		DELANO; CITY OF		City of Delano		City of Delano		DELANO; CITY OF		City of Delano		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		Delano, City of		Delano, City of		Delano, City of		Delano, City of		Delano, City of		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; 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		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
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
report_num		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000
rpt_date		2006-01-30 00:00:00		2006-04-30 00:00:00		2005-10-31 00:00:00		2007-07-30 00:00:00		2007-01-29 00:00:00		2006-07-31 00:00:00		2007-04-30 00:00:00		2006-10-30 00:00:00		2008-04-30 00:00:00		2008-01-31 00:00:00		2008-07-30 00:00:00		2007-10-31 00:00:00		2009-04-30 00:00:00		2009-10-31 00:00:00		2008-10-30 00:00:00		2009-07-30 00:00:00		2009-01-30 00:00:00		2010-08-02 00:00:00		2010-01-30 00:00:00		2010-04-30 00:00:00		2011-01-31 00:00:00		2010-11-01 00:00:00		2011-08-01 00:00:00		2011-10-28 00:00:00		2011-05-02 00:00:00		2012-01-31 00:00:00		2012-10-31 00:00:00		2012-07-31 00:00:00		2012-04-30 00:00:00		2013-01-31 00:00:00		2013-04-30 00:00:00		2014-01-14 00:00:00		2014-07-09 00:00:00		2014-04-15 00:00:00		2015-01-19 00:00:00		2014-10-23 00:00:00		2016-01-31 00:00:00		2016-07-27 00:00:00		2016-04-23 00:00:00		2016-10-20 00:00:00		2017-07-17 00:00:00		2017-04-24 00:00:00		2017-01-09 00:00:00		2017-01-07 00:00:00		2017-10-07 00:00:00		2018-07-29 00:00:00		2018-04-29 00:00:00		2018-01-11 00:00:00		2019-07-25 00:00:00		2019-04-26 00:00:00		2018-10-22 00:00:00		2019-01-10 00:00:00		2020-04-25 00:00:00		2019-10-23 00:00:00		2020-01-27 00:00:00		2020-07-21 00:00:00		2021-04-13 00:00:00		2021-01-26 00:00:00		2020-09-16 00:00:00		2020-10-21 00:00:00		2021-07-13 00:00:00		2022-01-21 00:00:00		2021-10-17 00:00:00		2022-10-21 00:00:00		2022-07-09 00:00:00		2022-04-16 00:00:00
from_date		2005-10-01 00:00:00		2006-01-01 00:00:00		2005-07-01 00:00:00		2007-04-01 00:00:00		2006-10-01 00:00:00		2006-04-01 00:00:00		2007-01-01 00:00:00		2006-07-01 00:00:00		2008-01-01 00:00:00		2007-10-01 00:00:00		2008-04-01 00:00:00		2007-07-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2008-07-01 00:00:00		2009-04-01 00:00:00		2008-10-01 00:00:00		2010-04-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-10-01 00:00:00		2010-07-01 00:00:00		2011-04-01 00:00:00		2011-07-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2012-07-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		2013-10-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-10-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		2016-07-01 00:00:00		2017-07-01 00:00:00		2018-04-01 00:00:00		2018-01-01 00:00:00		2017-10-01 00:00:00		2019-04-01 00:00:00		2019-01-01 00:00:00		2018-07-01 00:00:00		2018-10-01 00:00:00		2020-01-01 00:00:00		2019-07-01 00:00:00		2019-10-01 00:00:00		2020-04-01 00:00:00		2021-01-01 00:00:00		2020-10-01 00:00:00		2020-01-01 00:00:00		2020-07-01 00:00:00		2021-04-01 00:00:00		2021-10-01 00:00:00		2021-07-01 00:00:00		2022-07-01 00:00:00		2022-04-01 00:00:00		2022-01-01 00:00:00
thru_date		2005-12-31 00:00:00		2006-03-31 00:00:00		2005-09-30 00:00:00		2007-06-30 00:00:00		2006-12-31 00:00:00		2006-06-30 00:00:00		2007-03-31 00:00:00		2006-09-30 00:00:00		2008-03-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2007-09-30 00:00:00		2009-03-31 00:00:00		2009-09-30 00:00:00		2008-09-30 00:00:00		2009-06-30 00:00:00		2008-12-31 00:00:00		2010-06-30 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		2010-12-31 00:00:00		2010-09-30 00:00:00		2011-06-30 00:00:00		2011-09-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-03-31 00:00:00		2013-12-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-12-31 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		2016-09-30 00:00:00		2017-09-30 00:00:00		2018-06-30 00:00:00		2018-03-31 00:00:00		2017-12-31 00:00:00		2019-06-30 00:00:00		2019-03-31 00:00:00		2018-09-30 00:00:00		2018-12-31 00:00:00		2020-03-31 00:00:00		2019-09-30 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2021-03-31 00:00:00		2020-12-31 00:00:00		2020-03-31 00:00:00		2020-09-30 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2021-09-30 00:00:00		2022-09-30 00:00:00		2022-06-30 00:00:00		2022-03-31 00:00:00
cum_beg_dt		2005-07-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2007-01-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2007-01-01 00:00:00		2005-07-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2009-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2007-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		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		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		2017-01-01 00:00:00		2017-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		2017-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2017-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		2021-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
firm_id		1279687		1279687		1279687		None		1279687		1279687		None		1279687		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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_name		City of Delano		City of Delano		City of Delano		None		City of Delano		City of Delano		None		City of Delano		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Delano, City of		Delano, City of		Delano, City of		Delano, City of		Delano, City of		None		None		None		None		None		None		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		Delano, CA		Delano, CA		Delano, CA		DELANO		Delano, CA		Delano, CA		DELANO		Delano, CA		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		Delano		Delano		Delano		Delano		Delano		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO
firm_st		9		9		9		CA		9		9		CA		9		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		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		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93216		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215
firm_phon		(661)721-3300		(661)721-3300		(661)721-3300		6617202217		(661)721-3300		(661)721-3300		6617202217		(661)721-3300		6617202217		6617202217		6617202217		6617202217		6617202228		6617202228		6617202217		6617202228		6617202217		6617202228		6617202228		6617202228		6617202228		6617202228		6617202228		6617202269		6617202228		6617202269		6617202269		6617202269		6617202269		6617213300		6617213300		(661) 721-3300		(661) 721-3300		(661) 721-3300		(661) 721-3300		(661) 721-3300		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303		6617213303
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		DELANO		DELANO		None		None		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO
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		CA		CA		None		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		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		93215		93215		None		None		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215		93215
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		None		None		None		None		None
sig_date		2006-01-26 00:00:00		2006-04-26 00:00:00		2005-10-31 00:00:00		2007-07-23 00:00:00		2007-01-25 00:00:00		2006-07-27 00:00:00		2007-04-26 00:00:00		2006-10-25 00:00:00		2008-04-24 00:00:00		2008-01-24 00:00:00		2008-07-25 00:00:00		2007-10-26 00:00:00		2009-04-22 00:00:00		2009-10-29 00:00:00		2008-10-27 00:00:00		2009-07-23 00:00:00		2009-01-26 00:00:00		2010-07-28 00:00:00		2010-01-21 00:00:00		2010-04-24 00:00:00		2011-01-31 00:00:00		2010-10-13 00:00:00		2011-07-25 00:00:00		2011-10-26 00:00:00		2011-04-29 00:00:00		2012-01-25 00:00:00		2012-10-29 00:00:00		2012-07-27 00:00:00		2012-04-26 00:00:00		2013-01-10 00:00:00		2013-04-25 00:00:00		2014-01-14 00:00:00		2014-07-09 00:00:00		2014-04-15 00:00:00		2015-01-19 00:00:00		2014-10-23 00:00:00		2016-01-31 00:00:00		2016-07-27 00:00:00		2016-04-23 00:00:00		2016-10-20 00:00:00		2017-07-17 00:00:00		2017-04-24 00:00:00		2017-01-09 00:00:00		2017-01-07 00:00:00		2017-10-07 00:00:00		2018-07-29 00:00:00		2018-04-29 00:00:00		2018-01-11 00:00:00		2019-07-25 00:00:00		2019-04-26 00:00:00		2018-10-22 00:00:00		2019-01-10 00:00:00		2020-04-25 00:00:00		2019-10-23 00:00:00		2020-01-27 00:00:00		2020-07-21 00:00:00		2021-04-13 00:00:00		2021-01-26 00:00:00		2020-09-16 00:00:00		2020-10-21 00:00:00		2021-07-13 00:00:00		2022-01-21 00:00:00		2021-10-17 00:00:00		2022-10-21 00:00:00		2022-07-09 00:00:00		2022-04-16 00:00:00
sig_loc		Delano, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		DELANO, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		DELANO, CA		Delano, CA		Delano, CA		DELANO, CA		Delano, CA		Delano, CA		DELANO, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		Delano, CA		DELANO, CA		DELANO, CA		DELANO, CA		DELANO, CA		DELANO, CA		Los Angeles, CA		Los Angeles		Los Angeles, CA		LOS ANGELES, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA		Los Angeles, CA
sig_naml		Salem		Salem		Salem		Salem		Salem		Salem		SALEM		Salem		Salen		Salem		Salem		Salem		SALEM		Salem		Salem		SALEM		Salem		Salem		SALEM		Salem		Salem		Salem		Reyna		Reyna		Salem		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Rayna		Reyna		REYNA		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna
sig_namf		Abdel		Abdel L		Abdel		Abdel L.		Abdel L		Abdel L		ABDEL		Abdel L		Abdel		Abdel		Abel		Abdel L.		ABDEL		Abdel		Abdel L.		ABDEL		Abdel L.		Abdel		ABDEL		Abdel		Abdel		Abdel		Maribel		Maribel		Abdel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel G.		Maribel G.		Maribel G.		Maribel G.		Maribel G.		Maribel		Maribel		Maribel		MARIBEL		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel
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
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
prn_naml		Salem		Salem		Salem		Salem		Salem		Salem		SALEM		Salem		Salen		Salem		Salem		Salem		SALEM		Salem		Salem		SALEM		Salem		Salem		SALEM		Salem		Salem		Salem		Reyna		Reyna		Salem		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Rayna		Reyna		REYNA		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna		Reyna
prn_namf		Abdel		Abdel L		Abdel		Abdel L.		Abdel L		Abdel L		ABDEL		Abdel L		Abdel		Abdel		Abel		Abdel L.		ABDEL		Abdel		Abdel L.		ABDEL		Abdel L.		Abdel		ABDEL		Abdel		Abdel		Abdel		Maribel		Maribel		Abdel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel G.		Maribel G.		Maribel G.		Maribel G.		Maribel G.		Maribel		Maribel		Maribel		MARIBEL		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel		Maribel
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
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
sig_title		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		CITY MANAGER		City Manager		City Manager		City Manager		City Manager		City Manager		CITY MANAGER		City Manager		City Manager		CITY MANAGER		City Manager		City Manager		CITY MANAGER		City Manager		City Manager		City Manager		Interim City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager, 425900SSB		City Manager, 425900SSB		City Manager, 425900SSB		City Manager, 425900SSB		City Manager, 425900SSB		City Manager		City Manager		City Manager		CITY MANAGER		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager		City Manager
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
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
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		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		None		None		None		None		None
ctrib_n_cb		None		None		None		X		None		None		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
ctrib_y_cb		X		X		X		None		X		X		None		X		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Governor's Office; Dept of Corrections; Dept of Finance & Members & Staff of Senate & Assembly Budget Subs regarding Drafting Budget trailer bill for Community Correctional Facility		None		California State Legislature and Department of Corrections regarding CCF Budget Bill.		None		Governor's Office and California State Legislature regarding Budget bill for Community Correctional Facility		Department of Corrections and Governor's Office regarding Budget Request for CCF's		None		None		None		None		California State Legislature and Department of Corrections regarding CCF Issue.		None		None.		State Water Resources Control Baord and CAL EPA regarding State Revolving fund loan issue wiht funding for Delano wastewater treatment plant.		California State Legislature and Governors Office regarding: Gas Tax cut, Prop 1A cut and Prop 42 cut.		None		None.		None.		None.		None.		None.		None this quarter.		None this quarter.		California State Legislature and Governor's Office regarding: Preserving Redevelopment Agency and Enterprise Zone Funding		None this quarter.		None this quarter.		None this quarter.		None this quarter.		None this quarter.		None this quarter.		Legislature, Housing and Community Development Department - Emergency Shelter Program		See Attachment A		See Attachment A		Legislature; California Transportation Commission Re: Active Transportation Program.		See Attachment A		Dept of General Services, Trade and Commerce Agency, Board of Equalization.		Dept of General Services, Trade and Commerce Agency, Board of Equalization.		Dept of General Services, Trade and Commerce Agency, Board of Equalization.		Dept of General Services, Trade and Commerce Agency, Board of Equalization.		Department of General Services, Trade & Commerce Agency, Board of Equalization.		None this period.		Dept of General Services, Trade and Commerce Agency, Board of Equalization.		Dept of General Services, Trade and Commerce Agency, Board of Equalization.		Department of General Services, Trade & Commerce Agency, Board of Equalization.		Department of General Services, Trade & Commerce Agency, Board of Equalization, California Department of Water Resources. AB2812, AB2268, AB1912, SB827		Department of General Services, Trade & Commerce Agency, Board of Equalization, California Department of Water Resources. AB2812, AB2268, AB1912, SB827		Department of General Services, Trade & Commerce Agency, Board of Equalization, California Department of Water Resources.		State Legislature, SB5, SB100, SB200		State Legislature, SB5		Department of General Services, Trade & Commerce Agency, Board of Equalization, California Department of Water Resources. AB2812, AB2268, AB1912, SB827		Department of General Services, Trade & Commerce Agency, Board of Equalization, California Department of Water Resources. AB2812, AB2268, AB1912, SB827		State Legislature		State Legislature, SB5, SB100, SB200		State Legislature		State Legislature		State Legislature re: Working to secure additional attention and securing support for the City of Delano prison closing mandated by CDCR.		State Legislature re: Working to secure additional attention and securing support for the City of Delano prison closing mandated by CDCR.		State Legislature - SB1314, SB1299, AB291		State Legislature re: Working to secure additional attention and securing support for the City of Delano prison closing mandated by CDCR.		No activity this period		No activity this period		No activity this period		No activity this period		No activity this period		No activity this period
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		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		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
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
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
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
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
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

Table: cvr_registration

filing_id		1226271		1387054		1553924		1717756		1801178		2111707		2367414		2542634
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		1275430		1275430		1275430		1275430		F24882		1376172		1376172		1376172
filer_id		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687
entity_cd		LEM		LEM		LEM		LEM		LEM		LEM		LEM		LEM
filer_naml		City of Delano		CITY OF DELANO		DELANO; CITY OF		CITY OF DELANO		Delano, City of		DELANO; CITY OF		DELANO; CITY OF		DELANO; 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-01-03 00:00:00		2008-12-31 00:00:00		2010-12-23 00:00:00		2012-12-17 00:00:00		2013-10-31 00:00:00		2016-12-18 00:00:00		2019-03-15 00:00:00		2021-01-06 00:00:00
ls_beg_yr		2007		2009		2011		2013		2013		2017		2019		2021
ls_end_yr		2008		2010		2012		2014		2014		2018		2020		2022
qual_date		None		None		None		None		None		None		None		None
eff_date		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2013-10-21 00:00:00		2015-11-02 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00
bus_city		DELANO		DELANO		DELANO		DELANO		Delano		DELANO		DELANO		DELANO
bus_st		CA		CA		CA		CA		CA		CA		CA		CA
bus_zip4		93216		93216		93216		93215		93215		93215		93215		93215
bus_phon		6617202217		6617202228		6617202228		6617213300		(661) 720-2269		6617213303		6617213303		6617213303
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		DELANO
mail_st		None		None		None		None		None		None		None		CA
mail_zip4		None		None		None		None		None		None		None		93215
mail_phon		None		None		None		None		None		None		None		None
sig_date		2006-12-12 00:00:00		2008-12-19 00:00:00		2010-12-23 00:00:00		2012-12-05 00:00:00		2013-10-22 00:00:00		2016-12-14 00:00:00		2019-03-05 00:00:00		2020-11-30 00:00:00
sig_loc		None		None		None		None		DELANO, CA		None		None		None
sig_naml		Salem		KIVLEY		Salem		Reyna		AGUIRRE, JR.		Reyna		Reyna		Reyna
sig_namf		Abdel		KATHY A.		Abdel		Maribel		JOE E.		Maribel		Maribel		Maribel
sig_namt		None		None		None		None		None		None		None		None
sig_nams		None		None		None		None		None		None		None		None
prn_naml		Salem		KIVLEY		Salem		Reyna		AGUIRRE, JR.		Reyna		Reyna		Reyna
prn_namf		Abdel		KATHY A.		Abdel		Maribel		JOE E.		Maribel		Maribel		Maribel
prn_namt		None		None		None		None		None		None		None		None
prn_nams		None		None		None		None		None		None		None		None
sig_title		City Manager		ASSISTANT CITY MANAGER		City Manager		City Manager		MAYOR 425900SB		City Manager		City Manager		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		City Governance		CITY GOVERNANCE		City Governance		City Governance		Governor, Legislature		Local Government - Serving the best interest of the citizens of the City of Delano		Local Government, Serving the best interest of the citizens of City of Delano		Local Government serving the best interest of the citizens of the City of Delano
descrip_2		City Governance		CITY GOVERNANCE		City Governance		City Governance		None		Government		N/A		Local Government serving the best interest of the citizens of the City of Delano
c_less50		None		None		None		None		None		None		None		None
c_more50		None		None		None		None		None		None		None		None
ind_class		OTH		OTH		GOV		GOV		GOV		GOV		GOV		GOV
ind_descr		City Governance, City of Delano		CITY GOVERNANCE, CITY OF DELANO		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		California Consulting, LLC		CALIFORNIA CONSULTING, LLC		California Consulting, LLC		California Consulting, LLC		TOWNSEND PUBLIC AFFAIRS, INC.		Balance Public Relations & Strategic Solutions, Inc.		Balance Public Relations & Strategic Solutions, Inc.		Balance Public Relations & Strategic Solutions Inc.
auth_city		Fresno		FRESNO		Fresno		Fresno		IRVINE		Los Angeles		Los Angeles		Los Angeles
auth_st		CA		CA		CA		CA		CA		CA		CA		CA
auth_zip4		93710		93710		93710		93710		92614		90012		90012		90012
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		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687
adrid		2092548		2116400		2163544		2206005		2416405		2548985		2548986		2478074		2277071		2344178		2506820		2506821		2472132
effect_dt		2005-09-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2019-04-11 00:00:00		2013-01-01 00:00:00		2015-11-02 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00
add_type		7051		7051		7051		7051		7051		7051		7082		7082		7051		7051		7051		7082		7051
session_id		2005		2007		2009		2011		2017		2023		2023		2019		2013		2015		2021		2021		2019

Table: filer_filings

filer_id		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687
filing_id		1124594		1124991		1146400		1134200		1167276		1191088		1245889		1226271		1215890		1283347		1234726		1262461		1297479		1870101		1805804		1801178		1910044		1329609		1311423		1349902		1387054		1377401		1407836		1394991		1421541		1437175		1452426		1485308		1463721		1507345		1564583		1570618		1553924		1540200		1591632		1607987		1637120		1621326		1657289		1680483		1929822		1709981		1717756		1739511		1726363		1816216		1843457		1764780		1999572		2378010		2371957		2414952		2011381		2031656		2059793		2092698		2124394		2111707		2118101		2152739		2092698		2168009		2333659		2479559		2240386		2467546		2519740		2392982		2583188		2186887		2592686		2367414		2271468		2310273		2547327		2573735		2201320		2467546		2636171		2436574		2697227		2616298		2542634		2666894		2738340
period_id		None		None		184		183		185		186		None		189		187		190		188		189		191		218		None		216		219		193		192		194		196		195		None		196		197		198		199		201		200		202		None		204		204		203		205		206		208		207		209		210		220		211		212		212		None		216		217		213		None		237		None		239		224		225		226		227		None		228		228		229		227		230		236		242		233		241		243		238		None		231		246		237		234		235		244		245		232		241		248		240		250		247		245		249		251
form_id		F602		F999		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		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		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		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2005-08-31 00:00:00		2005-09-13 00:00:00		2006-01-30 00:00:00		2005-10-31 00:00:00		2006-04-30 00:00:00		2006-07-31 00:00:00		2006-12-29 00:00:00		2007-01-03 00:00:00		2006-10-30 00:00:00		2007-07-30 00:00:00		2007-01-29 00:00:00		2007-04-30 00:00:00		2007-10-31 00:00:00		2014-07-30 00:00:00		2013-11-01 00:00:00		2013-10-31 00:00:00		2014-10-30 00:00:00		2008-04-30 00:00:00		2008-01-31 00:00:00		2008-07-30 00:00:00		2008-12-31 00:00:00		2008-10-30 00:00:00		2008-12-31 00:00:00		2009-01-30 00:00:00		2009-04-30 00:00:00		2009-07-30 00:00:00		2009-10-31 00:00:00		2010-04-30 00:00:00		2010-01-30 00:00:00		2010-08-02 00:00:00		2010-12-23 00:00:00		2011-01-31 00:00:00		2010-12-23 00:00:00		2010-11-01 00:00:00		2011-05-02 00:00:00		2011-08-01 00:00:00		2012-01-31 00:00:00		2011-10-28 00:00:00		2012-04-30 00:00:00		2012-07-31 00:00:00		2015-01-26 00:00:00		2012-10-31 00:00:00		2012-12-17 00:00:00		2013-01-31 00:00:00		2012-12-17 00:00:00		2014-01-30 00:00:00		2014-04-29 00:00:00		2013-04-30 00:00:00		2015-11-12 00:00:00		2019-04-26 00:00:00		2019-03-19 00:00:00		2019-10-23 00:00:00		2016-01-31 00:00:00		2016-04-23 00:00:00		2016-07-27 00:00:00		2016-10-20 00:00:00		2016-12-20 00:00:00		2016-12-18 00:00:00		2017-01-09 00:00:00		2017-04-24 00:00:00		2017-01-07 00:00:00		2017-07-17 00:00:00		2019-01-10 00:00:00		2020-07-21 00:00:00		2018-04-29 00:00:00		2020-09-16 00:00:00		2020-10-21 00:00:00		2019-07-25 00:00:00		2021-01-11 00:00:00		2017-10-07 00:00:00		2021-07-13 00:00:00		2019-03-15 00:00:00		2018-07-29 00:00:00		2018-10-22 00:00:00		2021-01-26 00:00:00		2021-04-13 00:00:00		2018-01-11 00:00:00		2020-04-25 00:00:00		2022-01-21 00:00:00		2020-01-27 00:00:00		2022-07-09 00:00:00		2021-10-17 00:00:00		2021-01-06 00:00:00		2022-04-16 00:00:00		2022-10-21 00:00:00
stmnt_type		10005		10005		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10002		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001
stmnt_status		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		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		11001		11001		11003		11001		11001		11003		11003
session_id		2005		2005		2005		2005		2005		2005		2007		2007		2005		2007		2005		2007		2007		2013		2013		2013		2013		2007		2007		2007		2009		2007		2009		2007		2009		2009		2009		2009		2009		2009		2011		2009		2011		2009		2011		2011		2011		2011		2011		2011		2013		2011		2013		2011		2013		2013		2013		2013		2015		2019		2019		2019		2015		2015		2015		2015		2017		2017		2015		2017		2015		2017		2017		2019		2017		2019		2019		2019		2021		2017		2021		2019		2017		2017		2019		2021		2017		2019		2021		2019		2021		2021		2021		2021		2021
user_id		SARRIAGA		SARRIAGA		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		CFLAGG		YRODRIGU		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		AGLADNEY		YRODRIGU		YRODRIGU		AGLADNEY		LTHIBAUL		LTHIBAUL		LTHIBAUL		YRODRIGU		JINGRAM		PBANFORD		JINGRAM		MGUERRA		MGUERRA		MGUERRA		ASAETERN		JINGRAM		ASAETERN		YRODRIGU		AGLADNEY		YRODRIGU		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		ASAETERN		GPEREZ		AGLADNEY		AGLADNEY		ASAETERN		YRODRIGU		GTAYLOR		DMCCASTL		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		AGLADNEY		MKIRKHAM		AGLADNEY		GTAYLOR		GTAYLOR		VUKSTINA		CVANLIEW		AGLADNEY		GTAYLOR		CAFILER		AGLADNEY		AGLADNEY		JMAVES		CHARTRIDGE		AGLADNEY		GTAYLOR		CHATRIDGE		AGLADNEY		CAFILER		CHATRIDGE		CVANLIEW		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
fine_audit		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003
rpt_start		1900-01-01 00:00:00		1900-01-01 00:00:00		2005-10-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		1900-01-01 00:00:00		2007-01-03 00:00:00		2006-07-01 00:00:00		2007-04-01 00:00:00		2006-10-01 00:00:00		2007-01-01 00:00:00		2007-07-01 00:00:00		2014-04-01 00:00:00		1900-01-01 00:00:00		2013-10-31 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2007-10-01 00:00:00		2008-04-01 00:00:00		2008-12-31 00:00:00		2008-07-01 00:00:00		1900-01-01 00:00:00		2008-10-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2009-10-01 00:00:00		2010-04-01 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2010-12-23 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		2014-10-01 00:00:00		2012-07-01 00:00:00		2012-12-17 00:00:00		2012-10-01 00:00:00		1900-01-01 00:00:00		2013-10-01 00:00:00		2014-01-01 00:00:00		2013-01-01 00:00:00		1900-01-01 00:00:00		2019-01-01 00:00:00		1900-01-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		1900-01-01 00:00:00		2016-12-18 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		2016-07-01 00:00:00		2017-04-01 00:00:00		2018-10-01 00:00:00		2020-04-01 00:00:00		2018-01-01 00:00:00		2020-01-01 00:00:00		2020-07-01 00:00:00		2019-04-01 00:00:00		1900-01-01 00:00:00		2017-07-01 00:00:00		2021-04-01 00:00:00		2019-03-15 00:00:00		2018-04-01 00:00:00		2018-07-01 00:00:00		2020-10-01 00:00:00		2021-01-01 00:00:00		2017-10-01 00:00:00		2020-01-01 00:00:00		2021-10-01 00:00:00		2019-10-01 00:00:00		2022-04-01 00:00:00		2021-07-01 00:00:00		2021-01-06 00:00:00		2022-01-01 00:00:00		2022-07-01 00:00:00
rpt_end		1900-01-01 00:00:00		1900-01-01 00:00:00		2005-12-31 00:00:00		2005-09-30 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		1900-01-01 00:00:00		2007-01-03 00:00:00		2006-09-30 00:00:00		2007-06-30 00:00:00		2006-12-31 00:00:00		2007-03-31 00:00:00		2007-09-30 00:00:00		2014-06-30 00:00:00		1900-01-01 00:00:00		2013-10-31 00:00:00		2014-09-30 00:00:00		2008-03-31 00:00:00		2007-12-31 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2008-09-30 00:00:00		1900-01-01 00:00:00		2008-12-31 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2010-03-31 00:00:00		2009-12-31 00:00:00		2010-06-30 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2010-12-23 00:00:00		2010-09-30 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		2014-12-31 00:00:00		2012-09-30 00:00:00		2012-12-17 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2013-12-31 00:00:00		2014-03-31 00:00:00		2013-03-31 00:00:00		1900-01-01 00:00:00		2019-03-31 00:00:00		1900-01-01 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		1900-01-01 00:00:00		2016-12-18 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		2016-09-30 00:00:00		2017-06-30 00:00:00		2018-12-31 00:00:00		2020-06-30 00:00:00		2018-03-31 00:00:00		2020-03-31 00:00:00		2020-09-30 00:00:00		2019-06-30 00:00:00		1900-01-01 00:00:00		2017-09-30 00:00:00		2021-06-30 00:00:00		2019-03-15 00:00:00		2018-06-30 00:00:00		2018-09-30 00:00:00		2020-12-31 00:00:00		2021-03-31 00:00:00		2017-12-31 00:00:00		2020-03-31 00:00:00		2021-12-31 00:00:00		2019-12-31 00:00:00		2022-06-30 00:00:00		2021-09-30 00:00:00		2021-01-06 00:00:00		2022-03-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		None		None		None		None		None		None		None
filing_type		None		None		22001		22001		22001		22001		None		22006		22001		22006		22001		22006		22006		22001		None		22001		22001		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22001		22006		22006		22006		None		22001		22001		22006		None		22006		None		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006

Table: filer_interests

filer_id		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687
session_id		2017		2005		2011		2007		2009		2013		2015		2021		2019		2023
interest_cd		40305		40312		40305		40312		40305		40305		40305		40305		40305		40305
effect_date		2017-01-01 00:00:00		2005-09-01 00:00:00		2011-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2013-01-01 00:00:00		2015-11-02 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		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687
filer_type		1		1		1		1		1		1		1		1		1		1		1		1
active		Y		Y		Y		Y		Y		T		Y		Y		Y		Y		Y		N
race		0		0		None		None		None		None		None		None		None		None		None		None
session_id		2005		2007		2013		2011		2013		2013		2009		2017		2019		2015		2021		2023
category		0		0		None		None		None		None		None		None		None		None		None		None
category_type		0		0		None		None		None		None		None		None		None		None		None		None
sub_category		0		0		None		None		None		None		None		None		None		None		None		None
effect_dt		2005-09-01 00:00:00		2007-01-01 00:00:00		2013-10-21 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2013-03-31 00:00:00		2009-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2015-11-02 00:00:00		2021-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		None		None		None		None		None		None		None		None		None		None
election_type		0		0		None		None		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		2005-07-01 00:00:00		2005-07-01 00:00:00		None		None		None		None		None		None		None		None		None		None
party_cd		0		0		None		None		None		None		None		None		None		None		None		None
county_cd		0		0		None		None		None		None		None		None		None		None		None		None
district_cd		0		0		None		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1279687
xref_id		1279687
effect_dt		2005-09-07 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687
filer_id		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687		1279687
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		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		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		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		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO; CITY OF		DELANO, CITY OF		DELANO, CITY OF		DELANO, CITY OF		DELANO, CITY OF		DELANO, CITY OF		DELANO, CITY OF		DELANO, CITY OF		DELANO, CITY OF		DELANO, CITY OF		DELANO, CITY OF		DELANO, CITY OF		DELANO, CITY OF		DELANO, 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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO		DELANO
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		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		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		93216		93216		93216		93216		93215		93215		93215		93215		93215		93215		93215		93215		93215		93216		93216		93216		93216		93215		93215		93215		93215		93215		93215		93215		93215		93215		93216		93216		93216		93216		93215		93215		93215		93215		93215		93215		93215		93215		93215		93216		93216		93216		93216		93215		93215		93215		93215		93215		93215		93215		93215		93215		93216		93216		93216		93216		93215		93215		93215		93215		93215		93215		93215		93215		93215		93216		93216		93216		93216		93215		93215		93215		93215		93215		93215		93215		93215		93215		93216		93216		93216		93216		93215		93215		93215		93215		93215		93215		93215		93215		93215		93216		93216		93216		93216		93215		93215		93215		93215		93215		93215		93215		93215		93215		93216		93216		93216		93216		93215		93215		93215		93215		93215		93215		93215		93215		93215		93216		93216		93216		93216		93215		93215		93215		93215		93215		93215		93215		93215		93215
phon		6617202217		6617202217		6617202228		6617202269		6617213300		6617213303		6617213303		6617213303				6617213303				6617213303				6617202217		6617202217		6617202228		6617202269		6617213300		6617213303		6617213303		6617213303				6617213303				6617213303				6617202217		6617202217		6617202228		6617202269		6617213300		6617213303		6617213303		6617213303				6617213303				6617213303				6617202217		6617202217		6617202228		6617202269		6617213300		6617213303		6617213303		6617213303				6617213303				6617213303				6617202217		6617202217		6617202228		6617202269		6617213300		6617213303		6617213303		6617213303				6617213303				6617213303				6617202217		6617202217		6617202228		6617202269		6617213300		6617213303		6617213303		6617213303				6617213303				6617213303				6617202217		6617202217		6617202228		6617202269		6617213300		6617213303		6617213303		6617213303				6617213303				6617213303				6617202217		6617202217		6617202228		6617202269		6617213300		6617213303		6617213303		6617213303				6617213303				6617213303				6617202217		6617202217		6617202228		6617202269		6617213300		6617213303		6617213303		6617213303				6617213303				6617213303				6617202217		6617202217		6617202228		6617202269		6617213300		6617213303		6617213303		6617213303				6617213303				6617213303
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		1279687

Table: lobbying_chg_log

filer_id		1279687		1279687
change_no		0		1
session_id		2005		2015
log_dt		2005-08-31 00:00:00		2015-11-12 00:00:00
filer_type		1		1
correction_flg		None		Y
action		ADDED		DELETED
attribute_changed		FIRM		EMPLOYER
ethics_dt		None		None
interests		None		None
filer_full_name		DELANO, CITY OF		DELANO; CITY OF
filer_city		None		DELANO
filer_st		None		CA
filer_zip		None		93216
filer_phone		None		6617202269
entity_type		3		2
entity_name		CALIFORNIA CONSULTING, LLC		BALANCE PUBLIC RELATIONS & STRATEGIC SOLUTIONS, INC.
entity_city		None		None
entity_st		None		None
entity_zip		None		None
entity_phone		None		None
entity_id		1275430		None
responsible_officer		None		None
effect_dt		2005-09-01 00:00:00		2015-11-02 00:00:00