OpenCalAccess

Filer ID: 1233620

Table: cvr_lobby_disclosure
filing_id	768761	789053	810877	837506	850756	881909	907290	928428	942254	965906	1282793	1371170	1294214	1325983	1344196	1307186	1432413	1450164	1421456	1391727	1532617	1504377	1482976	1461539	1570553	1622069	1605218	1590195	1634321	1707483	1675968	1655195	1738526	1797817	1780378	1763297	1816362	1870089	1843451	1929811	1909978	1980538	1965327	2007000	1995234	2059514	2035907	2101162	2171181	2155243	2126789	2192226	2208315	2273445	2242831	2393643	2343103	2319817	2379709	2419695	2441285	2471445	2484577	2531386	2554770	2603624	2581519	2637331	2625506	2739398	2707565	2678177
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	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	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	F635	F635	F635	F635	F635	F635
sender_id	None	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620
filer_id	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620
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	LEM	LEM	LEM	LEM	LEM	LEM
filer_naml	BREA, CITY OF	BREA CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, 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	None	None	None	None	None
filer_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
report_num	None	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000
rpt_date	2001-04-30 00:00:00	2001-10-24 00:00:00	2002-01-25 00:00:00	2002-04-25 00:00:00	2002-07-22 00:00:00	2002-10-29 00:00:00	2003-01-28 00:00:00	2003-04-22 00:00:00	2003-07-16 00:00:00	2003-10-21 00:00:00	2007-07-30 00:00:00	2008-10-16 00:00:00	2007-10-16 00:00:00	2008-04-17 00:00:00	2008-07-14 00:00:00	2008-01-16 00:00:00	2009-07-16 00:00:00	2009-10-19 00:00:00	2009-04-20 00:00:00	2009-01-15 00:00:00	2010-10-13 00:00:00	2010-07-16 00:00:00	2010-04-14 00:00:00	2010-01-19 00:00:00	2011-01-18 00:00:00	2011-10-13 00:00:00	2011-07-13 00:00:00	2011-04-11 00:00:00	2012-01-17 00:00:00	2012-10-17 00:00:00	2012-07-23 00:00:00	2012-04-23 00:00:00	2013-01-25 00:00:00	2013-10-18 00:00:00	2013-07-15 00:00:00	2013-04-15 00:00:00	2014-01-13 00:00:00	2014-07-09 00:00:00	2014-04-15 00:00:00	2015-01-19 00:00:00	2014-10-10 00:00:00	2015-07-10 00:00:00	2015-04-13 00:00:00	2016-01-13 00:00:00	2015-10-13 00:00:00	2016-07-08 00:00:00	2016-04-27 00:00:00	2016-10-20 00:00:00	2017-07-11 00:00:00	2017-04-20 00:00:00	2017-01-19 00:00:00	2017-10-12 00:00:00	2018-01-14 00:00:00	2018-07-16 00:00:00	2018-04-11 00:00:00	2019-07-11 00:00:00	2019-01-14 00:00:00	2018-10-16 00:00:00	2019-04-12 00:00:00	2019-10-15 00:00:00	2020-01-31 00:00:00	2020-04-30 00:00:00	2020-07-31 00:00:00	2020-10-31 00:00:00	2020-01-31 00:00:00	2021-06-30 00:00:00	2021-04-30 00:00:00	2021-12-31 00:00:00	2021-09-30 00:00:00	2022-10-31 00:00:00	2022-07-31 00:00:00	2022-04-30 00:00:00
from_date	2001-01-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	2002-01-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	2003-01-01 00:00:00	2003-04-01 00:00:00	2003-07-01 00:00:00	2007-04-01 00:00:00	2008-07-01 00:00:00	2007-07-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2007-10-01 00:00:00	2009-04-01 00:00:00	2009-07-01 00:00:00	2009-01-01 00:00:00	2008-10-01 00:00:00	2010-07-01 00:00:00	2010-04-01 00:00:00	2010-01-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-01-01 00:00:00	2011-10-01 00:00:00	2012-07-01 00:00:00	2012-04-01 00:00:00	2012-01-01 00:00:00	2012-10-01 00:00:00	2013-07-01 00:00:00	2013-04-01 00:00:00	2013-01-01 00:00:00	2013-10-01 00:00:00	2014-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-10-01 00:00:00	2018-07-01 00:00:00	2019-01-01 00:00:00	2019-07-01 00:00:00	2019-10-01 00:00:00	2020-01-01 00:00:00	2020-04-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	2021-04-01 00:00:00	2021-01-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	2001-03-31 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	2002-03-31 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-12-31 00:00:00	2003-03-31 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2007-06-30 00:00:00	2008-09-30 00:00:00	2007-09-30 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2007-12-31 00:00:00	2009-06-30 00:00:00	2009-09-30 00:00:00	2009-03-31 00:00:00	2008-12-31 00:00:00	2010-09-30 00:00:00	2010-06-30 00:00:00	2010-03-31 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-03-31 00:00:00	2011-12-31 00:00:00	2012-09-30 00:00:00	2012-06-30 00:00:00	2012-03-31 00:00:00	2012-12-31 00:00:00	2013-09-30 00:00:00	2013-06-30 00:00:00	2013-03-31 00:00:00	2013-12-31 00:00:00	2014-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-12-31 00:00:00	2018-09-30 00:00:00	2019-03-31 00:00:00	2019-09-30 00:00:00	2019-12-31 00:00:00	2020-03-31 00:00:00	2020-06-30 00:00:00	2020-09-30 00:00:00	2020-12-31 00:00:00	2021-06-30 00:00:00	2021-03-31 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	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2007-04-01 00:00:00	2007-04-01 00:00:00	2007-04-01 00:00:00	2007-04-01 00:00:00	2007-04-01 00:00:00	2007-04-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2007-04-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	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	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	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	None	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620
firm_name	None	BREA CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF
firm_city	BREA	Brea	Brea	Brea	Brea	Brea	Brea	Brea	Brea	Brea	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA
firm_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
firm_zip4	928215732	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821	92821
firm_phon	7149907716	714-990-7710	714-990-7710	714-990-7710	714-990-7710	714-990-7710	714-990-7710	714-990-7710	714-990-7710	714-990-7710	714 990-7757	714 990-7757	714 990-7757	714 990-7757	714 990-7757	714 990-7757	714 990-7609	714 990-7609	714 990-7609	714 990-7757	714 990-7600	714 990-7609	714 990-7609	714 990-7609	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7600	714 990-7711	714 990-7600	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711	714 990-7711
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	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	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	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	None	None	None	None	None	None	None	None	None	None	None
sig_date	None	2001-10-24 00:00:00	2002-01-24 00:00:00	2002-01-25 00:00:00	2002-07-18 00:00:00	2002-10-28 00:00:00	2003-01-28 00:00:00	2003-04-22 00:00:00	2003-07-15 00:00:00	2003-10-21 00:00:00	2007-07-30 00:00:00	2008-10-16 00:00:00	2007-10-16 00:00:00	2008-04-16 00:00:00	2008-07-14 00:00:00	2008-01-16 00:00:00	2009-07-16 00:00:00	2009-10-19 00:00:00	2009-04-20 00:00:00	2009-01-15 00:00:00	2010-10-13 00:00:00	2010-07-16 00:00:00	2010-04-14 00:00:00	2010-01-19 00:00:00	2011-01-18 00:00:00	2011-10-10 00:00:00	2011-07-13 00:00:00	2011-04-11 00:00:00	2012-01-17 00:00:00	2012-10-17 00:00:00	2012-07-23 00:00:00	2012-04-23 00:00:00	2013-01-25 00:00:00	2013-10-18 00:00:00	2013-07-15 00:00:00	2013-04-15 00:00:00	2014-01-13 00:00:00	2014-07-09 00:00:00	2014-04-16 00:00:00	2015-01-19 00:00:00	2014-10-10 00:00:00	2015-07-10 00:00:00	2015-04-13 00:00:00	2016-01-13 00:00:00	2015-10-13 00:00:00	2016-07-08 00:00:00	2016-04-27 00:00:00	2016-10-20 00:00:00	2017-07-11 00:00:00	2017-04-12 00:00:00	2017-01-19 00:00:00	2017-10-12 00:00:00	2018-01-14 00:00:00	2018-07-16 00:00:00	2018-04-11 00:00:00	2019-07-11 00:00:00	2019-01-14 00:00:00	2018-10-16 00:00:00	2019-04-12 00:00:00	2019-10-15 00:00:00	2020-01-20 00:00:00	2020-04-14 00:00:00	2020-07-18 00:00:00	2020-10-13 00:00:00	2021-01-18 00:00:00	2021-07-20 00:00:00	2021-04-15 00:00:00	2022-01-15 00:00:00	2021-10-15 00:00:00	2022-10-12 00:00:00	2022-07-12 00:00:00	2022-04-11 00:00:00
sig_loc	None	Brea California	Brea, California	Brea, California	Brea, California	Brea, California	Brea, California	Brea, California	Brea, California	Brea, California	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA
sig_naml	None	O'Donnell	O'Donnell	O'Donnell	O'Donnell	O'Donnell	O'Donnell	O'Donnell	O'Donnell	O'Donnell	O'DONNELL	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	BALZ	BALZ	BALZ	BALZ	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO
sig_namf	None	Tim	Tim	Tim	Tim	Tim	Tim	Tim	Tim	Tim	TIM	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	CHERYL	CHERYL	CHERYL	CHERYL	MARIO	MARIO E.	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO
sig_namt	None	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
prn_naml	None	O'Donnell	O'Donnell	O'Donnell	O'Donnell	O'Donnell	O'Donnell	O'Donnell	O'Donnell	O'Donnell	O'DONNELL	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	WILLIAMS	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	GALLARDO	BALZ	BALZ	BALZ	BALZ	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO	MALDONADO
prn_namf	None	Tim	Tim	Tim	Tim	Tim	Tim	Tim	Tim	Tim	TIM	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	LUCINDA	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	WILLIAM	CHERYL	CHERYL	CHERYL	CHERYL	MARIO	MARIO E.	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO	MARIO
prn_namt	None	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	Mr.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
prn_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_title	None	City Manager	City Manager	City Manager	City Manager	City Manager	City Manager	City Manager	City Manager	City Manager	CITY MANAGER 425900SB	CITY CLERK 425900SB	CITY CLERK 425900SB	CITY CLERK 425900SB	CITY CLERK 425900SB	CITY CLERK 425900SB	CITY CLERK 425900SB	CITY CLERK 425900SB	CITY CLERK 425900SB	CITY CLERK 425900SB	CITY CLERK 425900SB	CITY CLERK 425900SB	CITY CLERK 425900SB	CITY CLERK 425900SB	ADMIN. SERVICES DIR. 425900SSB	ADMIN. SERVICES DIR. 425900SSB	ADMIN. SERVICES DIR. 425900SSB	ADMIN. SERVICES DIR. 425900SSB	ADMIN. SERVICES DIR. 425900SSB	ADMIN. SERVICES DIR. 425900SSB	ADMIN. SERVICES DIR. 425900SSB	ADMIN. SERVICES DIR. 425900SSB	ADMIN. SERVICES DIR. 425900SSB	ADMIN. SERVICES DIR. 425900SSB	ADMIN. SERVICES DIR. 425900SSB	ADMIN. SERVICES DIR. 425900SSB	ADMIN. SERVICES DIR. 425900SSB	CITY CLERK, 425900SB	CITY CLERK, 425900SB	CITY CLERK, 425900SB	CITY CLERK, 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASST. TO CITY MANAGER 425900SB	ASSISTANT TO CITY MANAGER	ASSISTANT TO CITY MANAGER	ASSISTANT TO CITY MANAGER	ASSISTANT TO CITY MANAGER	ASSISTANT TO CITY MANAGER	ASSISTANT TO CITY MANAGER	ASSISTANT TO CITY MANAGER	ASSISTANT TO CITY MANAGER	ASSISTANT TO CITY MANAGER	ASSISTANT TO CITY MANAGER	ASSISTANT TO CITY MANAGER	ASSISTANT TO CITY MANAGER	ASSISTANT TO 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	None	None	None	None	None	None
nopart2_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	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	None	None	None	None	None	None
ctrib_n_cb	None	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X
ctrib_y_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lby_actvty	None	AB 661	None	None	None	None	None	None	None	None	Department of Housing and Community Development, State Legislature, Administration, AB 5, AB 783, AB 995, AB 1209, AB 1350, SB 9, SB 46, SB 286, SB 376, SB 669, SB 748, SB 1002, AB 31, AB 823, AB 1053, AB 1252, AB 1351, AB 1460, AB 1672, SB 19, SB 54, SB 303, SB 546, SB 716, SB 964, AB 120, AB 901, AB 1091, AB 1253, AB 1426, AB 1489, SB 5, SB 45, SB 77, SB 375, SB 566, SB 732, SB 974	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	Department of Housing and Community Development - Infill Infrastructure Grant Program, Department of Parks and Recreation - Prop 84 Funding, State Legislature - Budget, SB 93	Department of Housing and Community Development - Infill Infrastructure Grant Program, Department of Parks and Recreation - Prop 84 funding, State Legislature - Budget, AB 286, SB 93, SB 402, SB 802	DEPARTMENT OF HOUSING AND COMMUNITY DEVELOPMENT - INFILL INFRASTRUCTURE GRANT PROGRAM, DEPARTMENT OF PARKS AND RECREATION - PROP 84 FUNDING, STATE LEGISLATURE - BUDGET, SB 93	State Legislature - Budget, AB 31, AB 7124, AB 1830, AB 2494, SB 375, SB 732, SB 974	Department of Parks and Recreation - Parks Program. Legislature - budget, AB 192, AB 194, AB 827, AB 1955, AB 2064, SB 501.	Department of Parks and Recreation - Parks Program. Legislature - budget, surplus lands.	Department of Housing and Community Development - Infill Infrastructure Grant Program, Department of Parks and Recreation - Prop 84 Funding. Legislature - AB 1590.	Department of Housing and Community Development - Infill Infrastructure Grant Program, Department of Parks and Recreation - Prop 84 funding, State Legislature - Budget, SB 67	Department of Parks and Recreation - Parks Program. Legislature - SB 848, SB 857, SB 866, SB 870.	Natural Resources Agency, Strategic Growth Council - Urban Greening Program. Legislature and Administration - Budget, AB 16x, AB 25x, AB 26x, AB 27x, AB 41x, AB 43x, SB 87, SB 89, SB 286, SB 293, SB 450, SB 499, SB 931, SB 4x, SB 8x, SB 16x.	Natural Resources Agency, Strategic Growth Council - Urban Greening Program. Legislature and Administration - Budget, AB 54, AB 98, AB 101, AB 1220, AB 1250, AB 26x, AB 27x, SB 69, SB 77, SB 87, SB 89, SB 184, SB 286, SB 474, SB 499, SB 670.	Legislature and Administration - Budget, Redevelopment, AB 101, SB 69, SB 77, SB 184, SB 499, SB 670.	Natural Resources Agency, Strategic Growth Council - Urban Greening Program. Legislature and Administration - AB 16x, AB 26x, SB 293, SB 450, SB 931, SB 4x, SB 8x,	Department of Housing and Community Development - Housing Related Parks program. Department of Finance - redevelopment. Caltrans-Safe Routes to School program. Legislature and Administration - Budget, AB 340, AB 904, AB 1555, AB 1585, AB 1692, SB 654, SB 863, SB 986, SB 1024, SB 1151, SB 1156.	Department of Housing and Community Development - Housing Related Parks program. Department of Finance - redevelopment. Legislature and Administration - Budget, AB 904, AB 1464, AB 1484, AB 1555, AB 1585, AB 1692, SB 654, SB 986, SB1024, SB 1151, SB 1156, SB 1335.	Department of Housing and Community Development - Housing Related Parks program. Legislature and Administration - AB 1555, AB 1585, AB 1692, SB 654, SB 986, SB 1151, SB 1156, SB 1335.	Department of Housing and Community Development - Housing Related Parks program; Department of Finance - Redevelopment. Caltrans-Safe Routes to School program. Legislature and Administration.	See Attachment A	See Attachment A	See Attachment A	Legislature and Administration, Strategic Growth Council - Urban Greening. Budget.	SEE ATTACHMENT A	SEE ATTACHMENT A	Legislature (redevelopment) and Administration, Department of Finance Re:	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	SEE ATTACHMENT A	Legislature and Administration RE: Budget.	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	Department of Parks and Recreation Re: Land and Water Conservation Fund, Board of State and Community Corrections, Legislature Re: Budget	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	Legislature, Administration Re: Budget, CARES Act Coronavirus Relief Fund, CalReycle	See Attachment A	SEE ATTACHMENT A	Legislature re: FY 22 Budget; AB 61; SB 274, SB 314, SB 556, SB 619, SB 792	See Attachment A	Legislature re: FY 22 Budget; California Transportation Commission and Legislature re: Active Transportation Grant Program; SB 1418, AB 2097, AB 2011, AB 2840, AB 1951	Legislature re: FY 22 Budget; California Transportation Commission, Legislature: Active Transportation Grant Program; SB 1418; AB 2840	Legislature re: FY 22 Budget; SB 1418
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	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	None	None	None	None	None	None
major_naml	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rcpcmte_nm	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rcpcmte_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: cvr_registration
filing_id	1271289	1386901	1556590	1722223	1925083	2110555	2340301	2573578
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	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620
entity_cd	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM
filer_naml	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, 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-06-04 00:00:00	2008-12-23 00:00:00	2010-12-28 00:00:00	2013-01-02 00:00:00	2014-12-19 00:00:00	2016-10-10 00:00:00	2018-11-08 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-03-01 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	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA
bus_st	CA	CA	CA	CA	CA	CA	CA	CA
bus_zip4	92821	92821	92821	92821	92821	92821	92821	92821
bus_phon	714 990-7757	714 990-7757	714 990-7757	714 990-7757	714 990-7757	714 990-7711	714 990-7711	714 990-7711
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-06-04 00:00:00	2008-12-08 00:00:00	2010-12-22 00:00:00	2012-12-18 00:00:00	2014-08-11 00:00:00	2014-08-11 00:00:00	2018-11-08 00:00:00	2020-11-24 00:00:00
sig_loc	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA	BREA, CA
sig_naml	WILLIAMS	WILLIAMS	GALLARDO	GALLARDO	BALZ	MALDONADO	MALDONADO	MALDONADO
sig_namf	LUCINDA	LUCINDA	WILLIAM	WILLIAM	CHERYL	MARIO	MARIO	MARIO
sig_namt	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None
prn_naml	WILLIAMS	WILLIAMS	GALLARDO	GALLARDO	BALZ	MALDONADO	MALDONADO	MALDONADO
prn_namf	LUCINDA	LUCINDA	WILLIAM	WILLIAM	CHERYL	MARIO	MARIO	MARIO
prn_namt	None	None	None	None	None	None	None	None
prn_nams	None	None	None	None	None	None	None	None
sig_title	CITY CLERK 425900SB	CITY CLERK 425900SB	ADMIN SVCS DIRECTOR 425900SB	ADMIN SVCS DIRECTOR 425900SB	CITY CLERK 425900SB	ASST. TO THE CITY MANAGER 425900SB	ASST. TO THE CITY MANAGER 425900SB	ASST. TO THE 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	SECURE PUBLIC FUNDING	SECURE PUBLIC FUNDING	SECURE PUBLIC FUNDING	SECURE PUBLIC FUNDING	GOVERNOR AND LEGISLATIVE	GOVERNOR AND LEGISLATIVE	GOVERNOR AND LEGISLATIVE	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: efs_filing_log
filing_date	2001-10-24 00:00:00	2002-01-26 00:00:00	2002-04-25 00:00:00	2002-04-26 00:00:00	2002-04-26 00:00:00	2002-07-22 00:00:00	2002-10-29 00:00:00	2003-01-28 00:00:00	2003-04-22 00:00:00	2003-07-16 00:00:00	2003-10-21 00:00:00
filingstatus	0	0	0	2	2	0	0	0	0	0	0
vendor	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	vendor	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE	RUNFOROFFICE
filer_id	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620
form_type	F635	F635	F635	form	form	F635	F635	F635	F635	F635	F635
error_no	ACCEPTED	ACCEPTED	ACCEPTED	ERROR 261	BADFORMAT 254	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED	ACCEPTED

Table: filer_address
filer_id	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620
adrid	2014033	2047516	2125178	2162656	2205413	2422449	2471236	2277367	2509914	2344161	2551344
effect_dt	2001-02-01 00:00:00	2003-01-01 00:00:00	2007-04-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2013-01-01 00:00:00	2021-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	7051	7051
session_id	2001	2003	2007	2009	2011	2017	2019	2013	2021	2015	2023

Table: filer_filings
filer_id	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620
filing_id	731095	760605	768761	789053	778527	810877	794910	820184	837506	841937	859396	859397	850756	854434	890453	918580	907290	881909	914410	944440	928428	942254	932582	965906	975648	1282793	1307186	1271289	1273987	1294214	1780378	1980538	1965327	1870089	1797817	1938962	1909978	1344196	1325983	1371170	1391727	1386901	1411649	1432413	1421456	1450164	1461539	1482976	1504377	1560886	1556590	1532617	1570553	1622069	1590195	1605218	1634321	1675968	1655195	1816362	1929811	1925083	1707483	1722223	1729100	1738526	1843451	1763297	1995234	2419695	2343103	2484577	2393643	2242831	2192226	2007000	2035907	2059514	2101162	2110555	2127579	2126789	2155243	2171181	2319817	2471445	2365849	2531386	2273445	2379709	2603624	2609536	2208315	2441285	2554770	2340301	2581519	2625506	2573578	2707565	2637331	2678177	2739398
period_id	None	165	165	167	None	168	None	None	169	None	None	None	170	None	None	None	172	171	None	174	173	174	None	175	None	190	192	190	None	191	214	222	221	218	215	None	219	194	193	195	196	196	None	198	197	199	200	201	202	None	204	203	204	207	205	206	208	210	209	216	220	220	211	213	None	212	217	213	223	239	236	242	238	233	231	224	225	226	227	228	None	228	229	230	235	241	None	243	234	237	246	None	232	240	244	236	245	247	244	250	248	249	251
form_id	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F690	F690	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F602	F602	F635	F635	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	F602	F602	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F602	F635	F635	F635	F602	F635	F635	F602	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	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	0	0	0	0	0	0	0	0	0	0	0	0
filing_date	2001-02-15 00:00:00	2001-04-30 00:00:00	2001-04-30 00:00:00	2001-10-24 00:00:00	2001-07-27 00:00:00	2002-01-26 00:00:00	2001-10-29 00:00:00	2002-01-29 00:00:00	2002-04-25 00:00:00	2002-04-25 00:00:00	2002-07-23 00:00:00	2002-07-23 00:00:00	2002-07-22 00:00:00	2002-07-23 00:00:00	2002-10-30 00:00:00	2002-12-31 00:00:00	2003-01-28 00:00:00	2002-10-29 00:00:00	2003-01-31 00:00:00	2003-07-18 00:00:00	2003-04-22 00:00:00	2003-07-16 00:00:00	2003-04-28 00:00:00	2003-10-21 00:00:00	2003-10-28 00:00:00	2007-07-30 00:00:00	2008-01-28 00:00:00	2007-06-04 00:00:00	2007-06-13 00:00:00	2007-10-23 00:00:00	2013-07-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-12-30 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	2009-01-26 00:00:00	2008-12-31 00:00:00	2008-12-31 00:00:00	2009-07-22 00:00:00	2009-04-30 00:00:00	2009-10-27 00:00:00	2010-01-27 00:00:00	2010-04-27 00:00:00	2010-07-28 00:00:00	2011-01-04 00:00:00	2011-01-04 00:00:00	2010-10-22 00:00:00	2011-01-31 00:00:00	2011-10-31 00:00:00	2011-04-29 00:00:00	2011-07-28 00:00:00	2012-01-30 00:00:00	2012-07-27 00:00:00	2012-04-26 00:00:00	2014-01-30 00:00:00	2015-01-26 00:00:00	2015-01-13 00:00:00	2012-10-30 00:00:00	2013-01-02 00:00:00	2013-01-03 00:00:00	2013-01-31 00:00:00	2014-04-29 00:00:00	2013-04-29 00:00:00	2015-10-28 00:00:00	2019-10-31 00:00:00	2019-01-29 00:00:00	2020-07-30 00:00:00	2019-07-26 00:00:00	2018-04-30 00:00:00	2017-10-30 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	2016-12-13 00:00:00	2016-12-14 00:00:00	2017-01-30 00:00:00	2017-04-28 00:00:00	2017-07-25 00:00:00	2018-10-31 00:00:00	2020-04-30 00:00:00	2019-01-25 00:00:00	2020-11-02 00:00:00	2018-07-31 00:00:00	2019-04-30 00:00:00	2021-08-02 00:00:00	2021-04-12 00:00:00	2018-01-30 00:00:00	2020-01-30 00:00:00	2021-02-01 00:00:00	2019-01-25 00:00:00	2021-04-30 00:00:00	2021-11-01 00:00:00	2021-04-12 00:00:00	2022-08-01 00:00:00	2022-01-25 00:00:00	2022-05-02 00:00:00	2022-10-23 00:00:00
stmnt_type	10005	10005	10001	10001	10005	10001	10005	10005	10001	10005	10006	10006	10001	10005	10005	10005	10001	10001	10005	10005	10001	10001	10005	10001	10005	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10005	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	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001
stmnt_status	11001	11001	11003	11003	11001	11003	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11003	11003	11001	11001	11003	11003	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11003
session_id	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2003	2001	2001	2001	2003	2003	2003	2003	2003	2003	2007	2007	2007	2007	2007	2013	2015	2015	2013	2013	2015	2013	2007	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2009	2009	2011	2011	2011	2011	2011	2011	2013	2013	2015	2011	2013	2013	2011	2013	2013	2015	2019	2017	2019	2019	2017	2017	2015	2015	2015	2015	2017	2017	2015	2017	2017	2017	2019	2019	2019	2017	2019	2021	2021	2017	2019	2019	2019	2021	2021	2021	2021	2021	2021	2021
user_id	SARRIAGA	YBONILLA	MHOANG	*	LTHIBAUL	*	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	LTHIBAUL	SARRIAGA	COMPLETED	*	LTHIBAUL	LTHIBAUL	COMPLETED	COMPLETED	LTHIBAUL	COMPLETED	LTHIBAUL	LTHIBAUL	LTHIBAUL	*	SARRIAGA	LTHIBAUL	AGLADNEY	MPACHECO	MPACHECO	AGLADNEY	AGLADNEY	GKURIMOT	AGLADNEY	YRODRIGU	LTHIBAUL	JGRISSUM	JGRISSUM	*	SARRIAGA	JGRISSUM	JGRISSUM	MGUERRA	JINGRAM	ASAETERN	ASAETERN	GKURIMOT	*	ASAETERN	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	CAFILER	AGLADNEY	PBANFORD	PBANFORD	ASAETERN	AGLADNEY	AGLADNEY	MPACHECO	SUSHAKOV	AGLADNEY	CVANLIEW	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	PBANFORD	PBANFORD	AGLADNEY	MPACHECO	AGLADNEY	AGLADNEY	SUSHAKOV	SARRIAGA	GTAYLOR	AGLADNEY	GTAYLOR	GTAYLOR	MKIRKHAM	AGLADNEY	AGLADNEY	GTAYLOR	SARRIAGA	GTAYLOR	GTAYLOR	MKIRKHAM	CAFILER	CHATRIDGE	CAFILER	CAFILER
special_audit	11003	11003	11003	11003	11003	11003	11003	11002	11003	11002	11003	11003	11003	11002	11002	11003	11003	11003	11002	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11003	11003	11001	11003	11003
rpt_start	1900-01-01 00:00:00	2001-01-01 00:00:00	None	2001-07-01 00:00:00	2001-04-01 00:00:00	2001-10-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	2002-01-01 00:00:00	2002-01-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	2002-04-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	1900-01-01 00:00:00	2002-10-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	2003-04-01 00:00:00	2003-01-01 00:00:00	2003-04-01 00:00:00	2003-01-01 00:00:00	2003-07-01 00:00:00	2003-07-01 00:00:00	2007-04-01 00:00:00	2007-10-01 00:00:00	2007-06-04 00:00:00	1900-01-01 00:00:00	2007-07-01 00:00:00	2013-04-01 00:00:00	2015-04-01 00:00:00	2015-01-01 00:00:00	2014-04-01 00:00:00	2013-07-01 00:00:00	1900-01-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-10-01 00:00:00	2008-12-23 00:00:00	1900-01-01 00:00:00	2009-04-01 00:00:00	2009-01-01 00:00:00	2009-07-01 00:00:00	2009-10-01 00:00:00	2010-01-01 00:00:00	2010-04-01 00:00:00	1900-01-01 00:00:00	2010-12-28 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	2011-07-01 00:00:00	2011-01-01 00:00:00	2011-04-01 00:00:00	2011-10-01 00:00:00	2012-04-01 00:00:00	2012-01-01 00:00:00	2013-10-01 00:00:00	2014-10-01 00:00:00	2014-12-19 00:00:00	2012-07-01 00:00:00	2013-01-02 00:00:00	1900-01-01 00:00:00	2012-10-01 00:00:00	2014-01-01 00:00:00	2013-01-01 00:00:00	2015-07-01 00:00:00	2019-07-01 00:00:00	2018-10-01 00:00:00	2020-04-01 00:00:00	2019-04-01 00:00:00	2018-01-01 00:00:00	2017-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-10 00:00:00	1900-01-01 00:00:00	2016-10-01 00:00:00	2017-01-01 00:00:00	2017-04-01 00:00:00	2018-07-01 00:00:00	2020-01-01 00:00:00	1900-01-01 00:00:00	2020-07-01 00:00:00	2018-04-01 00:00:00	2019-01-01 00:00:00	2021-04-01 00:00:00	1900-01-01 00:00:00	2017-10-01 00:00:00	2019-10-01 00:00:00	2020-10-01 00:00:00	2018-11-08 00:00:00	2021-01-01 00:00:00	2021-07-01 00:00:00	2020-12-31 00:00:00	2022-04-01 00:00:00	2021-10-01 00:00:00	2022-01-01 00:00:00	2022-07-01 00:00:00
rpt_end	1900-01-01 00:00:00	2001-03-31 00:00:00	None	2001-09-30 00:00:00	2001-06-30 00:00:00	2001-12-31 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	2002-03-31 00:00:00	2002-03-31 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	2002-06-30 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	1900-01-01 00:00:00	2002-12-31 00:00:00	2002-09-30 00:00:00	2002-12-31 00:00:00	2003-06-30 00:00:00	2003-03-31 00:00:00	2003-06-30 00:00:00	2003-03-31 00:00:00	2003-09-30 00:00:00	2003-09-30 00:00:00	2007-06-30 00:00:00	2007-12-31 00:00:00	2007-06-04 00:00:00	1900-01-01 00:00:00	2007-09-30 00:00:00	2013-06-30 00:00:00	2015-06-30 00:00:00	2015-03-31 00:00:00	2014-06-30 00:00:00	2013-09-30 00:00:00	1900-01-01 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-31 00:00:00	2008-12-23 00:00:00	1900-01-01 00:00:00	2009-06-30 00:00:00	2009-03-31 00:00:00	2009-09-30 00:00:00	2009-12-31 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	1900-01-01 00:00:00	2010-12-28 00:00:00	2010-09-30 00:00:00	2010-12-31 00:00:00	2011-09-30 00:00:00	2011-03-31 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	2012-06-30 00:00:00	2012-03-31 00:00:00	2013-12-31 00:00:00	2014-12-31 00:00:00	2014-12-19 00:00:00	2012-09-30 00:00:00	2013-01-02 00:00:00	1900-01-01 00:00:00	2012-12-31 00:00:00	2014-03-31 00:00:00	2013-03-31 00:00:00	2015-09-30 00:00:00	2019-09-30 00:00:00	2018-12-31 00:00:00	2020-06-30 00:00:00	2019-06-30 00:00:00	2018-03-31 00:00:00	2017-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-10-10 00:00:00	1900-01-01 00:00:00	2016-12-31 00:00:00	2017-03-31 00:00:00	2017-06-30 00:00:00	2018-09-30 00:00:00	2020-03-31 00:00:00	1900-01-01 00:00:00	2020-09-30 00:00:00	2018-06-30 00:00:00	2019-03-31 00:00:00	2021-06-30 00:00:00	1900-01-01 00:00:00	2017-12-31 00:00:00	2019-12-31 00:00:00	2020-12-31 00:00:00	2018-11-08 00:00:00	2021-03-31 00:00:00	2021-09-30 00:00:00	2020-12-31 00:00:00	2022-06-30 00:00:00	2021-12-31 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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filing_type	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	22001	None	None	None	22001	22001	None	22001	None	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	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	None	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001

Table: filer_interests
filer_id	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620
session_id	2001	2003	2011	2007	2009	2013	2021	2015	2019	2017	2023
interest_cd	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305
effect_date	2001-02-01 00:00:00	2003-01-01 00:00:00	2011-01-01 00:00:00	2007-04-01 00:00:00	2009-01-01 00:00:00	2013-01-01 00:00:00	2021-01-01 00:00:00	2015-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00

Table: filer_to_filer_type
filer_id	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620
filer_type	1	1	1	1	1	1	1	1	1	1	1	1
active	Y	T	Y	Y	Y	Y	Y	Y	Y	Y	Y	N
race	0	None	None	None	None	None	None	None	None	None	None	None
session_id	2001	2003	2003	2011	2013	2007	2009	2017	2015	2021	2019	2023
category	0	None	None	None	None	None	None	None	None	None	None	None
category_type	0	None	None	None	None	None	None	None	None	None	None	None
sub_category	0	None	None	None	None	None	None	None	None	None	None	None
effect_dt	2001-02-01 00:00:00	2003-08-01 00:00:00	2003-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2007-04-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	None	None	None
election_type	0	None	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	None	2001-07-01 00:00:00	None	None	None	2001-07-01 00:00:00	None	None	None	None	None	None
party_cd	0	None	None	None	None	None	None	None	None	None	None	None
county_cd	0	None	None	None	None	None	None	None	None	None	None	None
district_cd	0	None	None	None	None	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1233620
xref_id		1233620
effect_dt		2001-02-26 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620
filer_id	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620
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
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
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
naml	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA; CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA, 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
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
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
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
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
city	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA	BREA
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
zip4	928215732	928215732	92821	92821	92821	92821	92821	92821	92821	92821	92821	928215732	928215732	92821	92821	92821	92821	92821	92821	92821	92821	92821	928215732	928215732	92821	92821	92821	92821	92821	92821	92821	92821	92821	928215732	928215732	92821	92821	92821	92821	92821	92821	92821	92821	92821	928215732	928215732	92821	92821	92821	92821	92821	92821	92821	92821	92821	928215732	928215732	92821	92821	92821	92821	92821	92821	92821	92821	92821	928215732	928215732	92821	92821	92821	92821	92821	92821	92821	92821	92821	928215732	928215732	92821	92821	92821	92821	92821	92821	92821	92821	92821	928215732	928215732	92821	92821	92821	92821	92821	92821	92821	92821	92821	928215732	928215732	92821	92821	92821	92821	92821	92821	92821	92821	92821	928215732	928215732	92821	92821	92821	92821	92821	92821	92821	92821	92821
phon	7149907716	7149907710	7149907757	7149907757	7149907757	7149907757	7149907711	7149907711	7149907711	7149907711	7149907711	7149907716	7149907710	7149907757	7149907757	7149907757	7149907757	7149907711	7149907711	7149907711	7149907711	7149907711	7149907716	7149907710	7149907757	7149907757	7149907757	7149907757	7149907711	7149907711	7149907711	7149907711	7149907711	7149907716	7149907710	7149907757	7149907757	7149907757	7149907757	7149907711	7149907711	7149907711	7149907711	7149907711	7149907716	7149907710	7149907757	7149907757	7149907757	7149907757	7149907711	7149907711	7149907711	7149907711	7149907711	7149907716	7149907710	7149907757	7149907757	7149907757	7149907757	7149907711	7149907711	7149907711	7149907711	7149907711	7149907716	7149907710	7149907757	7149907757	7149907757	7149907757	7149907711	7149907711	7149907711	7149907711	7149907711	7149907716	7149907710	7149907757	7149907757	7149907757	7149907757	7149907711	7149907711	7149907711	7149907711	7149907711	7149907716	7149907710	7149907757	7149907757	7149907757	7149907757	7149907711	7149907711	7149907711	7149907711	7149907711	7149907716	7149907710	7149907757	7149907757	7149907757	7149907757	7149907711	7149907711	7149907711	7149907711	7149907711	7149907716	7149907710	7149907757	7149907757	7149907757	7149907757	7149907711	7149907711	7149907711	7149907711	7149907711
fax	7149902258											7149902258											7149902258											7149902258											7149902258											7149902258											7149902258											7149902258											7149902258											7149902258											7149902258
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

Table: filers
filer_id		1233620

Table: lobbying_chg_log
filer_id	1233620	1233620	1233620	1233620	1233620
change_no	2	3	5	6	0
session_id	2001	2001	2003	2007	2021
log_dt	2001-07-06 00:00:00	2001-02-15 00:00:00	2003-08-11 00:00:00	2007-06-13 00:00:00	2021-04-12 00:00:00
filer_type	1	1	1	1	1
correction_flg	None	Y	Y	Y	None
action	CHANGED	NEW	DELETED	ADDED	ADDED
attribute_changed	INTEREST	EMPLOYER	None	FIRM	FIRM
ethics_dt	None	None	None	None	None
interests	GOVERNMENT	None	None	None	None
filer_full_name	BREA, CITY OF	BREA, CITY OF	BREA, CITY OF	BREA; CITY OF	BREA; CITY OF
filer_city	None	BREA	None	BREA	None
filer_st	None	CA	None	CA	None
filer_zip	None	928215732	None	928215732	None
filer_phone	None	7149907716	None	7149907716	None
entity_type	1	2	3	3	3
entity_name	None	KENNETH EMANUELS AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	TOWNSEND PUBLIC AFFAIRS, INC	TOWNSEND PUBLIC AFFAIRS, INC.
entity_city	None	None	None	None	None
entity_st	None	None	None	None	None
entity_zip	None	None	None	None	None
entity_phone	None	None	None	None	None
entity_id	0	None	1147358	None	1147750
responsible_officer	None	None	None	None	None
effect_dt	None	2001-02-01 00:00:00	2003-08-01 00:00:00	2007-04-01 00:00:00	2021-01-01 00:00:00

Table: received_filings
filer_id	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620	1233620
filing_file_name	789053_0.cal	810877_0.cal	837506_0.cal	227329.cal	850756_0.cal	881909_0.cal	907290_0.cal	928428_0.cal	942254_0.cal	965906_0.cal	1504377_0.cal	1391727_0.cal	1371170_0.cal	1344196_0.cal	1461539_0.cal	1450164_0.cal	1482976_0.cal	1282793_0.cal	1432413_0.cal	1421456_0.cal	1294214_0.cal	1307186_0.cal	1325983_0.cal	1532617_0.cal	1843451_0.cal	1738526_0.cal	1675968_0.cal	1797817_0.cal	1570553_0.cal	1816362_0.cal	1590195_0.cal	1605218_0.cal	1780378_0.cal	1763297_0.cal	1622069_0.cal	1634321_0.cal	1707483_0.cal	1655195_0.cal	1870089_0.cal	1965327_0.cal	2126789_0.cal	2155243_0.cal	2059514_0.cal	1995234_0.cal	2007000_0.cal	2101162_0.cal	1909978_0.cal	1929811_0.cal	2035907_0.cal	1980538_0.cal	2171181_0.cal	2343103_0.cal	2242831_0.cal	2192226_0.cal	2419695_0.cal	2319817_0.cal	2393643_0.cal	2471445_0.cal	2273445_0.cal	2441285_0.cal	2484577_0.cal	2208315_0.cal	2379709_0.cal	2581519_0.cal	2707565_0.cal	2531386_0.cal	2678177_0.cal	2603624_0.cal	2625506_0.cal	2554770_0.cal	2637331_0.cal	2739398_0.cal
received_date	2001-10-24 00:00:00	2002-01-26 00:00:00	2002-04-25 00:00:00	2002-04-26 00:00:00	2002-07-22 00:00:00	2002-10-29 00:00:00	2003-01-28 00:00:00	2003-04-22 00:00:00	2003-07-16 00:00:00	2003-10-21 00:00:00	2010-07-28 00:00:00	2009-01-26 00:00:00	2008-10-24 00:00:00	2008-07-18 00:00:00	2010-01-27 00:00:00	2009-10-27 00:00:00	2010-04-27 00:00:00	2007-07-30 00:00:00	2009-07-22 00:00:00	2009-04-30 00:00:00	2007-10-23 00:00:00	2008-01-28 00:00:00	2008-04-22 00:00:00	2010-10-22 00:00:00	2014-04-29 00:00:00	2013-01-31 00:00:00	2012-07-27 00:00:00	2013-10-28 00:00:00	2011-01-31 00:00:00	2014-01-30 00:00:00	2011-04-29 00:00:00	2011-07-28 00:00:00	2013-07-30 00:00:00	2013-04-29 00:00:00	2011-10-31 00:00:00	2012-01-30 00:00:00	2012-10-30 00:00:00	2012-04-26 00:00:00	2014-07-30 00:00:00	2015-04-30 00:00:00	2017-01-30 00:00:00	2017-04-28 00:00:00	2016-07-27 00:00:00	2015-10-28 00:00:00	2016-01-26 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	2015-07-30 00:00:00	2017-07-25 00:00:00	2019-01-29 00:00:00	2018-04-30 00:00:00	2017-10-30 00:00:00	2019-10-31 00:00:00	2018-10-31 00:00:00	2019-07-26 00:00:00	2020-04-30 00:00:00	2018-07-31 00:00:00	2020-01-30 00:00:00	2020-07-30 00:00:00	2018-01-30 00:00:00	2019-04-30 00:00:00	2021-04-30 00:00:00	2022-08-01 00:00:00	2020-11-02 00:00:00	2022-05-02 00:00:00	2021-08-02 00:00:00	2021-11-01 00:00:00	2021-02-01 00:00:00	2022-01-25 00:00:00	2022-10-23 00:00:00
filing_directory	/usr/users/cafiler/disclose/ca99/cal	/usr/users/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/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal
filing_id	789053	810877	837506	None	850756	881909	907290	928428	942254	965906	1504377	1391727	1371170	1344196	1461539	1450164	1482976	1282793	1432413	1421456	1294214	1307186	1325983	1532617	1843451	1738526	1675968	1797817	1570553	1816362	1590195	1605218	1780378	1763297	1622069	1634321	1707483	1655195	1870089	1965327	2126789	2155243	2059514	1995234	2007000	2101162	1909978	1929811	2035907	1980538	2171181	2343103	2242831	2192226	2419695	2319817	2393643	2471445	2273445	2441285	2484577	2208315	2379709	2581519	2707565	2531386	2678177	2603624	2625506	2554770	2637331	2739398
form_id	F635	F635	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	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 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 accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted