OpenCalAccess

Filer ID: 1298226

Table: cvr_lobby_disclosure
filing_id	1282650	1344814	1294242	1325964	1307082	1421465	1377741	1450228	1436307	1396839	1532717	1504468	1461584	1483003	1570636	1621939	1600767	1600767	1590330	1634352	1707515	1674396	1655214	1738697	1797832	1777509	1763362	1813689	1870135	1843477	1929869	1910096	1980623	1965440	2007050	1995487	2059548	2101287	2035979	2168733	2151392	2122303	2190758	2234240	2234240	2272093	2207188	2393675	2337987	2379807	2315089	2415354	2441273	2471521	2554939	2531420	2484633	2603643	2581605	2625549	2739551	2700893	2678293	2645552
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	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
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
sender_id	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226
filer_id	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226
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
filer_naml	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, 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
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
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
report_num	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	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000
rpt_date	2007-07-30 00:00:00	2008-07-18 00:00:00	2007-10-17 00:00:00	2008-04-14 00:00:00	2008-01-15 00:00:00	2009-04-16 00:00:00	2008-10-16 00:00:00	2009-10-15 00:00:00	2009-07-24 00:00:00	2009-01-20 00:00:00	2010-10-14 00:00:00	2010-07-22 00:00:00	2010-01-13 00:00:00	2010-04-13 00:00:00	2011-01-14 00:00:00	2011-10-27 00:00:00	2011-07-12 00:00:00	2011-07-19 00:00:00	2011-04-11 00:00:00	2012-01-12 00:00:00	2012-10-23 00:00:00	2012-07-17 00:00:00	2012-04-16 00:00:00	2013-01-17 00:00:00	2013-10-16 00:00:00	2013-07-15 00:00:00	2013-04-16 00:00:00	2014-01-20 00:00:00	2014-07-15 00:00:00	2014-04-15 00:00:00	2015-01-19 00:00:00	2014-10-06 00:00:00	2015-07-09 00:00:00	2015-04-09 00:00:00	2016-01-12 00:00:00	2015-10-15 00:00:00	2016-07-11 00:00:00	2016-10-26 00:00:00	2016-04-14 00:00:00	2017-07-19 00:00:00	2017-04-17 00:00:00	2017-01-11 00:00:00	2017-10-26 00:00:00	2018-04-23 00:00:00	2018-06-12 00:00:00	2018-07-30 00:00:00	2018-01-29 00:00:00	2019-07-14 00:00:00	2019-01-23 00:00:00	2019-04-22 00:00:00	2018-10-29 00:00:00	2019-10-16 00:00:00	2020-01-31 00:00:00	2020-04-30 00:00:00	2021-01-31 00:00:00	2020-10-31 00:00:00	2020-07-31 00:00:00	2021-07-31 00:00:00	2021-04-30 00:00:00	2021-10-31 00:00:00	2022-10-31 00:00:00	2022-07-31 00:00:00	2022-04-30 00:00:00	2022-01-31 00:00:00
from_date	2007-04-01 00:00:00	2008-04-01 00:00:00	2007-07-01 00:00:00	2008-01-01 00:00:00	2007-10-01 00:00:00	2009-01-01 00:00:00	2008-07-01 00:00:00	2009-07-01 00:00:00	2009-04-01 00:00:00	2008-10-01 00:00:00	2010-07-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	2011-07-01 00:00:00	2011-04-01 00:00:00	2011-04-01 00:00:00	2011-01-01 00:00:00	2011-10-01 00:00:00	2012-07-01 00:00:00	2012-04-01 00:00:00	2012-01-01 00:00:00	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-07-01 00:00:00	2016-01-01 00:00:00	2017-04-01 00:00:00	2017-01-01 00:00:00	2016-10-01 00:00:00	2017-07-01 00:00:00	2018-01-01 00:00:00	2018-01-01 00:00:00	2018-04-01 00:00:00	2017-10-01 00:00:00	2019-04-01 00:00:00	2018-10-01 00:00:00	2019-01-01 00:00:00	2018-07-01 00:00:00	2019-07-01 00:00:00	2019-10-01 00:00:00	2020-01-01 00:00:00	2020-10-01 00:00:00	2020-07-01 00:00:00	2020-04-01 00:00:00	2021-04-01 00:00:00	2021-01-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	2021-10-01 00:00:00
thru_date	2007-06-30 00:00:00	2008-06-30 00:00:00	2007-09-30 00:00:00	2008-03-31 00:00:00	2007-12-31 00:00:00	2009-03-31 00:00:00	2008-09-30 00:00:00	2009-09-30 00:00:00	2009-06-30 00:00:00	2008-12-31 00:00:00	2010-09-30 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	2011-09-30 00:00:00	2011-06-30 00:00:00	2011-06-30 00:00:00	2011-03-31 00:00:00	2011-12-31 00:00:00	2012-09-30 00:00:00	2012-06-30 00:00:00	2012-03-31 00:00:00	2012-12-31 00:00:00	2013-09-30 00:00:00	2013-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-09-30 00:00:00	2016-03-31 00:00:00	2017-06-30 00:00:00	2017-03-31 00:00:00	2016-12-31 00:00:00	2017-09-30 00:00:00	2018-03-31 00:00:00	2018-03-31 00:00:00	2018-06-30 00:00:00	2017-12-31 00:00:00	2019-06-30 00:00:00	2018-12-31 00:00:00	2019-03-31 00:00:00	2018-09-30 00:00:00	2019-09-30 00:00:00	2019-12-31 00:00:00	2020-03-31 00:00:00	2020-12-31 00:00:00	2020-09-30 00:00:00	2020-06-30 00:00:00	2021-06-30 00:00:00	2021-03-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	2021-12-31 00:00:00
cum_beg_dt	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	2007-04-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	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	2017-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00
firm_id	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	None	None	1298226	None	None	None	None	None	1298226	None	1298226	None	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226
firm_name	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	None	None	MISSION VIEJO, CITY OF	None	None	None	None	None	MISSION VIEJO, CITY OF	None	MISSION VIEJO, CITY OF	None	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF
firm_city	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO
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
firm_zip4	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691
firm_phon	(949) 470-3052	(949) 470-3052	(949) 470-3052	(949) 470-3052	(949) 470-3052	(949) 470-3052	(949) 470-3052	(949) 470-3052	(949) 470-3052	(949) 470-3052	(949) 470-8409	(949) 470-3052	(949) 470-3052	(949) 470-3052	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	9494708409	9494708409	(949) 470-8409	9494708409	9494708409	9494708409	9494708409	9494708409	(949) 470-8409	9494708409	(949) 470-8409	9494708409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409	(949) 470-8409
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
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
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
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
sig_date	2007-07-16 00:00:00	2008-07-18 00:00:00	2007-10-17 00:00:00	2008-04-10 00:00:00	2008-01-15 00:00:00	2009-04-15 00:00:00	2008-10-16 00:00:00	2009-10-15 00:00:00	2009-07-24 00:00:00	2009-01-20 00:00:00	2010-10-14 00:00:00	2010-07-22 00:00:00	2010-01-13 00:00:00	2010-04-13 00:00:00	2011-01-14 00:00:00	2011-10-28 00:00:00	2011-07-12 00:00:00	2011-07-19 00:00:00	2011-04-11 00:00:00	2012-01-12 00:00:00	2012-10-23 00:00:00	2012-07-17 00:00:00	2012-04-13 00:00:00	2013-01-17 00:00:00	2013-10-16 00:00:00	2013-07-15 00:00:00	2013-04-16 00:00:00	2014-01-20 00:00:00	2014-07-15 00:00:00	2014-04-15 00:00:00	2015-01-19 00:00:00	2014-10-06 00:00:00	2015-07-09 00:00:00	2015-04-09 00:00:00	2016-01-12 00:00:00	2015-10-15 00:00:00	2016-07-11 00:00:00	2016-10-26 00:00:00	2016-04-14 00:00:00	2017-07-19 00:00:00	2017-04-17 00:00:00	2017-01-11 00:00:00	2017-10-26 00:00:00	2018-04-23 00:00:00	2018-06-12 00:00:00	2018-07-30 00:00:00	2018-01-29 00:00:00	2019-07-14 00:00:00	2019-01-23 00:00:00	2019-04-22 00:00:00	2018-10-29 00:00:00	2019-10-16 00:00:00	2020-01-23 00:00:00	2020-04-17 00:00:00	2021-01-24 00:00:00	2020-10-22 00:00:00	2020-07-20 00:00:00	2021-07-25 00:00:00	2021-04-21 00:00:00	2021-10-25 00:00:00	2022-10-17 00:00:00	2022-07-18 00:00:00	2022-04-15 00:00:00	2022-01-25 00:00:00
sig_loc	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	Mission Viejo, CA	Mission Viejo, CA	MISSION VIEJO, CA	Mission Viejo, CA	Mission Viejo, CA	Mission Viejo, CA	Mission Viejo, CA	Mission Viejo, CA	MISSION VIEJO, CA	Mission Viejo, CA	MISSION VIEJO, CA	Mission Viejo, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA
sig_naml	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WILBERG	WYLIE	WYLIE	WYLIE	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	Wilberg	Wilberg	WILBERG	Wilberg	Wilberg	Wilberg	Wilberg	Wilberg	WILBERG	Wilberg	WILBERG	Wilberg	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG
sig_namf	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	DENNIS	KAREN	KAREN	KAREN	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	Dennis	Dennis	DENNIS	Dennis	Dennis	Dennis	Dennis	Dennis	DENNIS	Dennis	DENNIS	Dennis	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS
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
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
prn_naml	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WYLIE	WILBERG	WYLIE	WYLIE	WYLIE	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	Wilberg	Wilberg	WILBERG	Wilberg	Wilberg	Wilberg	Wilberg	Wilberg	WILBERG	Wilberg	WILBERG	Wilberg	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG	WILBERG
prn_namf	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	KAREN	DENNIS	KAREN	KAREN	KAREN	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	Dennis	Dennis	DENNIS	Dennis	Dennis	Dennis	Dennis	Dennis	DENNIS	Dennis	DENNIS	Dennis	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS	DENNIS
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
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
sig_title	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	DEPUTY CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	City Manager	City Manager	CITY MANAGER 425900SB	City Manager	City Manager	City Manager	City Manager	City Manager	CITY MANAGER 4259SSB	City Manager	CITY MANAGER 4259SSB	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
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
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
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
ctrib_n_cb	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X
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
lby_actvty	STATE LEGISLATURE, AB 370, AB 724, AB 1053, AB 1252, AB 1457, SB 46, SB 77, SB 732, SB 914	Department of Parks and Recreation - grant funding. State Legisalture - AB 724, AB 1252, AB 2076, SB 46, SB 303, SB 375, SB 732	SEE ATTACHMENT A	Department of Parks and Recreation Re: grant funding; State Legislature Re: AB 724, AB 1252, SB 46, SB 303, SB 375, SB 732	Department of Parks and Recreation Re: grant funding; State Legislature Re: AB 414, AB 945, AB 1457, SB 303, SB 375, SB 717, SB 1000, SB 1028	State Legisalture and Administration - Budget, AB 118, AB 1364, ABX3 20, SB 295, SB 575	Department of Parks and Recreation - grant funding. State Legisalture - AB 724, AB 1252, AB 2076, SB 46, SB 303, SB 375, SB 732	LEGISLATURE AND ADMINISTRATION - BUDGET, AB 715, AB 1506, SB 268, SB 575, SB 696	LEGISLATURE AND ADMINISTRATION - BUDGET, AB 118, AB 715, AB 782, AB 1192, AB 1506, SB 31, SB 268, SB 295, SB 575, SB 696	Department of Parks and Recreation - grant funding. State Legisalture - Budget, SB 735, SB 732, AB 31, SB 375	AB 602, AB 715, AB 1867, AB 2486, SB 194.	AB 715, AB 1192, AB 1590, AB 1867, AB 2407, ABx8 6, SB 575, SB 625, SBx8 6.	LEGISLATURE AND ADMINISTRATION - BUDGET, SB 575	Legislature and Administration - Budget	AB 602, AB 715, AB 1867, AB 1955, AB 2486, SB 194, SB 406, SB 501, SB 625.	Legislature and Administration - Budget, AB 1220, AB 1236, AB 16x, AB 25x, AB 26x, AB 27x, AB 41x, SB 87, SB 89, SB 226, SB 286, SB 456, SB 4x, SB 8x, SB 16x.	Legislature and Administration - Budget, AB 66, AB 98, AB 101, AB 890, AB 1220, AB 1250, AB 26x, AB 27x, SB 69, SB 77, SB 87, SB 89, SB 94, SB 286, SB 456.	Legislature and Administration - Budget, AB 66, AB 98, AB 101, AB 890, AB 1220, AB 1250, AB 26x, AB 27x, SB 69, SB 77, SB 87, SB 89, SB 94, SB 286, SB 456.	Legislature - Budget, Redevelopment, AB 66, AB 101, SB 69, SB 77	AB 1220, AB 1236, AB 16x, AB 26x, SB 226, SB 456, SB 4x, SB 8x.	Legislature and Administration -AB 340, AB 904, AB 1555, AB 1585, AB 1692, SB 654, SB 863, SB 986,SB 1024, SB 1151, SB 1156.	Legislature and Administration - AB 904, AB 1464, 1484, AB 1555, AB 1585, AB 1692, SB 654, SB 986,SB 1024, SB 1056, SB 1151, SB 1156, SB 1335.	Legislature and Administration - AB 1555, AB 1585, AB 1692, SB 654, SB 986, SB 1056, SB 1151, SB 1156, SB 1335.	Legislature Re Budget; Department of Parks and Recreation Re: Statewide Park Program	See Attachment A	See Attachment A	See Attachment A	Legislature and Administration. Budget.	See Attachment A	See Attachment A	Legislature Re: Cap and trade.	See Attachment A	SEE ATTACHMENT A	SEE ATTACHMENT A	Legislature. AB 57, AB 266, AB 402, AB 852, AB 1236, SB 9, SB 239, SB 303, SB 331, SB 350, SB 355,SB 493, SB 533.	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	SEE ATTACHMENT A	AB 1, 2, 5, 6, 7, 18, 27, 44, 59, 64, 74, 97, 150, 168, 199, 252, 256, 285, 345, 346, 448, 459, 494, 497, 530, 546, 558, 572, 748, 765, 851, 863, 963, 1069, 1086, 1095, 1143, 1250, 1326, 1333, 1452, 1505, 1559, 1585, 1598 Dept. of Finance Re: ROPS JLAC Audit 2017:113 Legislation and Administration-Budget.	Legislature and Administration--Budget. AB:1 2 5 6 7 18 27 28 44 59 64 74 96 150 168 199 252 256 285 345 346 448 459 494 497 530 546 558 572 748 765 851 863 963 1069 1086 1095 1143 1326 1333 1452 1505 1559 1585 1598 SB: 1 2 3 5 6 22 29 32 34 35 54 72 75 139 176 196 200 229 231 302 345 371 384 431 448 525 540 571 640 649 760 786 SCA 1, Dept of Finance: ROPS 16-17	Legislature and Administration RE: Budget.	AB1, AB 2, AB 5, AB 6, AB 7, AB 18, AB 27, AB 44, AB 59, AB 64, AB 74, AB 150, AB 168 AB 199, AB 252, AB 256, AB 285, AB 345, AB 346, AB 448, AB 459, AB 494, AB 497, AB 530, AB 546, AB 558, AB 572, AB 748, AB 765, AB 851, AB 863, AB 963, AB 1000, AB 1069, AB 1086, AB 1095, AB 1143, AB 1250, AB 1326, AB 1333, AB 1452, AB 1505, AB 1559, AB 1585, AB 1598	Dept. of Finance Re: ROPS AB 1806 - Budget SB 839 ? Budget SB 827	Dept. of Finance Re: ROPS AB 1806 - Budget SB 839 Budget SB 827	AB 7, 44, 64, 74, 168, 199, 252, 346, 382, 448, 459, 494, 546, 765, 851, 863, 1069, 1086, 1136, 1250, 1452, 1505, 1598, 1668, 1759, 1765, 1770, 1771, 1778, 1792, 1863, 1866, 1884, 1901, 1912, 2003, 2020, 2071, 2144, 2156, 2161, 2162, 2200, 2214, 2231, 2249, 2339, 2598, 2753, 2939, 3037, 3162, 3171 SB 1, 2, 3, 5, 6, 29, 32, 35, 54, 229, 231, 302, 345, 384, 827, 840, 992, 1031	Dept. of Finance Re: ROPS AB 7, 44, 64, 74, 168, 199, 252, 346, 459, 494, 546, 765, 851, 863, 1069, 1086, 1250, 1452, 1505, 1598 SB 1, 2, 3, 5, 6, 29, 32, 35, 54, 229, 231, 302, 345, 384, 448, 525, 540, 623, 649, 760, 786	SEE ATTACHMENT A	AB 7, AB 44, AB 64, AB 74, AB 168 AB 199, AB 252, AB 346, AB 448, AB 459, AB 494, AB 546, AB 765, AB 851, AB 863, AB 1069, AB 1086, AB 1136, AB 1250, AB 1452, AB 1505, AB 1598, AB 1668, AB 1759, AB 1765, AB 1770, AB 1771, AB 1778, AB 1792, AB 1863, AB 1866, AB 1884, AB 1901, AB 1912, AB 2003, AB 2020, AB 2071, AB 2144, AB 2156	SEE ATTACHMENT A	AB 7, 44, 64, 74, 168, 199, 252, 346, 382, 448, 459, 494, 546, 765, 851, 863, 1069, 1086, 1136, 1250, 1452, 1505, 1598, 1668, 1759, 1765, 1770, 1771, 1778, 1792, 1863, 1866, 1884, 1901, 1912, 2003, 2020, 2071, 2144, 2156, 2161, 2162, 2200, 2214, 2231, 2249, 2339, 2598, 2753, 2939, 3037, 3162, 3171 Dept. of Finance Re: ROPS 18-19	SEE ATTACHMENT A	Legislature Re: Budget	SEE ATTACHMENT A	Legislature, Administration Re: Budget, CARES Act Coronavirus Relief Fund	SEE ATTACHMENT A	SEE ATTACHMENT A	See Attachment A	See Attachment A	See Attachment A	SB 1338, AB 2840, SB 904, AB 2011, AB 1595	Legislature Re: Electric Bike Legislation; SB 1338, AB 2840, SB 904, AB 2011	Legislature Re: Electric Bike Legislation	AB 61; SB 274, SB 314, SB 556, SB 619, SB 792
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
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
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
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
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
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
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
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

Table: cvr_registration
filing_id	1268371	1386937	1556608	1722253	1925110	2110593	2114915	2140788	2340338	2544235
amend_id	0	0	0	0	0	0	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F602	F602	F602	F602	F602	F602	F602	F602	F602	F602
sender_id	F24882	F24882	F24882	F24882	F24882	F24882	F24882	F00462	F24882	F24882
filer_id	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226
entity_cd	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM
filer_naml	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF	City of Mission Viejo	MISSION VIEJO, CITY OF	MISSION VIEJO, CITY OF
filer_namf	None	None	None	None	None	None	None	None	None	None
filer_namt	None	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None	None
report_num	000	000	000	000	000	000	000	000	000	000
rpt_date	2007-05-18 00:00:00	2008-12-23 00:00:00	2010-12-23 00:00:00	2013-01-02 00:00:00	2014-12-19 00:00:00	2016-10-10 00:00:00	2016-10-10 00:00:00	2017-02-23 00:00:00	2018-11-09 00:00:00	2020-12-31 00:00:00
ls_beg_yr	2007	2009	2011	2013	2015	2017	2017	2017	2019	2021
ls_end_yr	2008	2010	2012	2014	2016	2018	2018	2018	2020	2022
qual_date	None	None	None	None	None	None	None	None	None	None
eff_date	2007-05-08 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	2017-01-01 00:00:00	2017-02-14 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00
bus_city	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	Mission Viejo	MISSION VIEJO	MISSION VIEJO
bus_st	CA	CA	CA	CA	CA	CA	CA	None	CA	CA
bus_zip4	92691	92691	92691	92691	92691	92691	92691	CA	92691	92691
bus_phon	(940) 470-8409	(940) 470-8409	(940) 470-8409	(940) 470-8409	(940) 470-8409	(940) 470-8409	(940) 470-8409	949-470-3000	(940) 470-8409	(940) 470-8409
bus_fax	None	None	None	None	None	None	None	None	None	None
bus_email	None	None	None	None	None	None	None	None	None	None
mail_city	None	None	None	None	None	None	None	None	None	None
mail_st	None	None	None	None	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None	None	None	None	None
mail_phon	None	None	None	None	None	None	None	None	None	None
sig_date	2007-05-08 00:00:00	2008-12-09 00:00:00	2010-12-15 00:00:00	2012-12-12 00:00:00	2014-12-19 00:00:00	2016-10-10 00:00:00	2016-10-10 00:00:00	2017-02-23 00:00:00	2018-11-09 00:00:00	2020-11-25 00:00:00
sig_loc	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	MISSION VIEJO, CA	Mission Viejo, CA	MISSION VIEJO, CA	MISSION VIEJO, CA
sig_naml	WILBERG	WYLIE	WYLIE	WILBERG	WILBERG	WILBERG	WILBERG	Wilberg	WILBERG	WILBERG
sig_namf	DENNIS	KAREN	KAREN	DENNIS	DENNIS	DENNIS	DENNIS	Dennis	DENNIS	DENNIS
sig_namt	None	None	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None	None	None
prn_naml	WILBERG	WYLIE	WYLIE	WILBERG	WILBERG	WILBERG	WILBERG	Wilberg	WILBERG	WILBERG
prn_namf	DENNIS	KAREN	KAREN	DENNIS	DENNIS	DENNIS	DENNIS	Dennis	DENNIS	DENNIS
prn_namt	None	None	None	None	None	None	None	None	None	None
prn_nams	None	None	None	None	None	None	None	None	None	None
sig_title	CITY MANAGER 425900SB	DEP. CITY MANAGER 425900SB	DEP. CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	CITY MANAGER 425900SB	City Manager	CITY MANAGER 425900SB	CITY MANAGER
stmt_firm	None	None	None	None	None	None	None	None	None	None
ind_cb	None	None	None	None	None	None	None	None	None	None
bus_cb	None	None	None	None	None	None	None	None	None	None
trade_cb	None	None	None	None	None	None	None	None	None	None
oth_cb	X	X	X	X	X	X	X	X	X	X
a_b_name	None	None	None	None	None	None	None	None	None	None
a_b_city	None	None	None	None	None	None	None	None	None	None
a_b_st	None	None	None	None	None	None	None	None	None	None
a_b_zip4	None	None	None	None	None	None	None	None	None	None
descrip_1	LOCAL GOVERNMENT	LOCAL GOVERNMENT	LOCAL GOVERNMENT	MUNICIPAL GOVERNMENT	GOVERNOR AND LEGISLATIVE	GOVERNOR AND LEGISLATIVE	MUNICIPAL GOVERNMENT	Local government-serving the best interests of the citizens of Mission Viejo.	MUNICIPAL GOVERNMENT	MUNICIPAL GOVERNMENT
descrip_2	None	None	None	None	None	None	None	None	None	MUNICIPAL GOVERNMENT
c_less50	None	None	None	None	None	None	None	None	None	None
c_more50	None	None	None	None	None	None	None	None	None	None
ind_class	GOV	GOV	GOV	UTL	GOV	GOV	GOV	GOV	GOV	GOV
ind_descr	None	None	None	None	None	None	None	None	None	None
bus_class	None	None	None	None	None	None	None	None	None	None
bus_descr	None	None	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.	GONSALVES & SON, JOE A.	TOWNSEND PUBLIC AFFAIRS, INC.	TOWNSEND PUBLIC AFFAIRS, INC.
auth_city	IRVINE	IRVINE	IRVINE	IRVINE	NEWPORT BEACH	NEWPORT BEACH	NEWPORT BEACH	Sacramento	NEWPORT BEACH	NEWPORT BEACH
auth_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
auth_zip4	92614	92614	92614	92614	92660	92660	92660	95814	92660	92660
lobby_int	None	None	None	None	None	None	None	None	None	None
influen_yn	None	None	None	None	None	None	None	None	None	None
firm_name	None	None	None	None	None	None	None	None	None	None
newcert_cb	None	None	None	None	None	None	None	None	None	None
rencert_cb	None	None	None	None	None	None	None	None	None	None
complet_dt	None	None	None	None	None	None	None	None	None	None
lby_reg_cb	None	None	None	None	None	None	None	None	None	None
lby_604_cb	None	None	None	None	None	None	None	None	None	None
st_leg_yn	None	None	None	None	None	None	None	None	None	None
st_agency	None	None	None	None	None	None	None	None	None	None
lobby_cb	None	None	None	None	None	None	None	None	None	None
l_firm_cb	None	None	None	None	None	None	None	None	None	None

Table: filer_address
filer_id	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226
adrid	2123861	2164936	2207112	2417879	2277485	2509969	2344276	2468307	2551402
effect_dt	2007-05-08 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2017-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	2023-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	2007	2009	2011	2017	2013	2021	2015	2019	2023

Table: filer_filings
filer_id	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226
filing_id	1282650	1267759	1267761	1268371	1307082	1294242	1777509	1965440	1980623	1870135	1797832	1939203	1910096	1325964	1344814	1386937	1377741	1396839	1412289	1421465	1450228	1461584	1436307	1483003	1504468	1556608	1560934	1532717	1570636	1600767	1590330	1621939	1600767	1634352	1655214	1674396	1813689	1929869	1925110	1707515	1738697	1722253	1729901	1843477	1763362	1995487	2379807	2415354	2337987	2007050	2035979	2059548	2101287	2114915	2122303	2110593	2148123	2151392	2133357	2168733	2140788	2207188	2234240	2365993	2340338	2441273	2234240	2190758	2272093	2393675	2471521	2544235	2531420	2484633	2315089	2581605	2700893	2603643	2585950	2625549	2678293	2645552	2554939	2739551
period_id	190	None	None	190	192	191	214	221	222	218	215	None	219	193	194	196	195	196	None	197	199	200	198	201	202	204	None	203	204	206	205	207	206	208	209	210	216	220	220	211	212	213	None	217	213	223	237	239	236	224	225	226	227	228	228	228	None	229	None	230	229	232	233	None	236	240	233	231	234	238	241	244	243	242	235	245	250	246	None	247	249	248	244	251
form_id	F635	F602	F999	F602	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F602	F635	F635	F602	F635	F635	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F602	F602	F635	F602	F635	F602	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
filing_date	2007-07-30 00:00:00	2007-05-18 00:00:00	2007-05-22 00:00:00	2007-05-23 00:00:00	2008-01-28 00:00:00	2007-10-23 00:00:00	2013-07-23 00:00:00	2015-04-30 00:00:00	2015-07-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-04-22 00:00:00	2008-07-22 00:00:00	2008-12-31 00:00:00	2008-10-31 00:00:00	2009-02-01 00:00:00	2008-12-31 00:00:00	2009-04-30 00:00:00	2009-10-27 00:00:00	2010-01-27 00:00:00	2009-07-30 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-07-18 00:00:00	2011-04-29 00:00:00	2011-10-31 00:00:00	2011-07-28 00:00:00	2012-01-30 00:00:00	2012-04-26 00:00:00	2012-07-25 00:00:00	2014-01-27 00:00:00	2015-01-26 00:00:00	2015-01-13 00:00:00	2012-10-30 00:00:00	2013-01-31 00:00:00	2013-01-02 00:00:00	2013-01-03 00:00:00	2014-04-29 00:00:00	2013-04-29 00:00:00	2015-10-28 00:00:00	2019-04-30 00:00:00	2019-10-24 00:00:00	2019-01-23 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-29 00:00:00	2017-01-23 00:00:00	2016-12-13 00:00:00	2017-02-22 00:00:00	2017-04-17 00:00:00	2016-12-14 00:00:00	2017-07-19 00:00:00	2017-02-23 00:00:00	2018-01-29 00:00:00	2018-06-12 00:00:00	2019-01-25 00:00:00	2019-01-25 00:00:00	2020-01-30 00:00:00	2018-04-23 00:00:00	2017-10-26 00:00:00	2018-07-30 00:00:00	2019-07-26 00:00:00	2020-04-30 00:00:00	2021-01-14 00:00:00	2020-11-02 00:00:00	2020-07-30 00:00:00	2018-10-29 00:00:00	2021-04-30 00:00:00	2022-07-25 00:00:00	2021-08-02 00:00:00	2021-01-14 00:00:00	2021-11-01 00:00:00	2022-05-02 00:00:00	2022-01-31 00:00:00	2021-02-01 00:00:00	2022-10-24 00:00:00
stmnt_type	10001	10005	10005	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10005	10001	10001	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001
stmnt_status	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11003
session_id	2007	2007	2007	2007	2007	2007	2013	2015	2015	2013	2013	2015	2013	2007	2007	2009	2007	2007	2009	2009	2009	2009	2009	2009	2009	2011	2011	2009	2009	2011	2011	2011	2011	2011	2011	2011	2013	2013	2015	2011	2011	2013	2013	2013	2013	2015	2019	2019	2017	2015	2015	2015	2015	2017	2015	2017	2017	2017	2017	2017	2017	2017	2017	2019	2019	2019	2017	2017	2017	2019	2019	2021	2019	2019	2017	2021	2021	2021	2021	2021	2021	2021	2019	2021
user_id	YRODRIGU	GPEREZ	GPEREZ	*	LTHIBAUL	YRODRIGU	ASAETERN	MPACHECO	MPACHECO	ASAETERN	AGLADNEY	GKURIMOT	AGLADNEY	LTHIBAUL	LTHIBAUL	*	MGUERRA	MGUERRA	SARRIAGA	MGUERRA	MGUERRA	MGUERRA	MGUERRA	ASAETERN	ASAETERN	YRODRIGU	GKURIMOT	ASAETERN	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	ASAETERN	ASAETERN	AGLADNEY	CAFILER	ASAETERN	ASAETERN	PBANFORD	PBANFORD	ASAETERN	AGLADNEY	JINGRAM	GTAYLOR	SUSHAKOV	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	PBANFORD	AGLADNEY	PBANFORD	SARRIAGA	AGLADNEY	PBANFORD	AGLADNEY	SARRIAGA	AGLADNEY	AGLADNEY	SARRIAGA	SARRIAGA	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	SUSHAKOV	SUSHAKOV	CVANLIEW	GTAYLOR	GTAYLOR	AGLADNEY	GTAYLOR	CAFILER	MKIRKHAM	CVANLIEW	GTAYLOR	CAFILER	CHATRIDGE	GTAYLOR	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
fine_audit	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11001	11001	11003	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	11003	11001	11001	11001	11003	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11003	11001	11003	11001	11003	11001	11001	11003
rpt_start	2007-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-05-18 00:00:00	2007-10-01 00:00:00	2007-07-01 00:00:00	2013-04-01 00:00:00	2015-01-01 00:00:00	2015-04-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-01-01 00:00:00	2008-04-01 00:00:00	2008-12-23 00:00:00	2008-07-01 00:00:00	2008-10-01 00:00:00	1900-01-01 00:00:00	2009-01-01 00:00:00	2009-07-01 00:00:00	2009-10-01 00:00:00	2009-04-01 00:00:00	2010-01-01 00:00:00	2010-04-01 00:00:00	2010-12-23 00:00:00	1900-01-01 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	2011-04-01 00:00:00	2011-01-01 00:00:00	2011-07-01 00:00:00	2011-04-01 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	2012-04-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	2012-10-01 00:00:00	2013-01-02 00:00:00	1900-01-01 00:00:00	2014-01-01 00:00:00	2013-01-01 00:00:00	2015-07-01 00:00:00	2019-01-01 00:00:00	2019-07-01 00:00:00	2018-10-01 00:00:00	2015-10-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	2016-07-01 00:00:00	2016-10-10 00:00:00	2016-10-01 00:00:00	2016-10-10 00:00:00	1900-01-01 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	2017-04-01 00:00:00	2017-02-23 00:00:00	2017-10-01 00:00:00	2018-01-01 00:00:00	1900-01-01 00:00:00	2018-11-09 00:00:00	2019-10-01 00:00:00	2018-01-01 00:00:00	2017-07-01 00:00:00	2018-04-01 00:00:00	2019-04-01 00:00:00	2020-01-01 00:00:00	2020-12-31 00:00:00	2020-07-01 00:00:00	2020-04-01 00:00:00	2018-07-01 00:00:00	2021-01-01 00:00:00	2022-04-01 00:00:00	2021-04-01 00:00:00	1900-01-01 00:00:00	2021-07-01 00:00:00	2022-01-01 00:00:00	2021-10-01 00:00:00	2020-10-01 00:00:00	2022-07-01 00:00:00
rpt_end	2007-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-05-18 00:00:00	2007-12-31 00:00:00	2007-09-30 00:00:00	2013-06-30 00:00:00	2015-03-31 00:00:00	2015-06-30 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-03-31 00:00:00	2008-06-30 00:00:00	2008-12-23 00:00:00	2008-09-30 00:00:00	2008-12-31 00:00:00	1900-01-01 00:00:00	2009-03-31 00:00:00	2009-09-30 00:00:00	2009-12-31 00:00:00	2009-06-30 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	2010-12-23 00:00:00	1900-01-01 00:00:00	2010-09-30 00:00:00	2010-12-31 00:00:00	2011-06-30 00:00:00	2011-03-31 00:00:00	2011-09-30 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	2012-06-30 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	2012-12-31 00:00:00	2013-01-02 00:00:00	1900-01-01 00:00:00	2014-03-31 00:00:00	2013-03-31 00:00:00	2015-09-30 00:00:00	2019-03-31 00:00:00	2019-09-30 00:00:00	2018-12-31 00:00:00	2015-12-31 00:00:00	2016-03-31 00:00:00	2016-06-30 00:00:00	2016-09-30 00:00:00	2016-10-10 00:00:00	2016-12-31 00:00:00	2016-10-10 00:00:00	1900-01-01 00:00:00	2017-03-31 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	2017-02-23 00:00:00	2017-12-31 00:00:00	2018-03-31 00:00:00	1900-01-01 00:00:00	2018-11-09 00:00:00	2019-12-31 00:00:00	2018-03-31 00:00:00	2017-09-30 00:00:00	2018-06-30 00:00:00	2019-06-30 00:00:00	2020-03-31 00:00:00	2020-12-31 00:00:00	2020-09-30 00:00:00	2020-06-30 00:00:00	2018-09-30 00:00:00	2021-03-31 00:00:00	2022-06-30 00:00:00	2021-06-30 00:00:00	1900-01-01 00:00:00	2021-09-30 00:00:00	2022-03-31 00:00:00	2021-12-31 00:00:00	2020-12-31 00:00:00	2022-09-30 00:00:00
rpt_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filing_type	22001	None	None	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	None	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	22006	22001	22001	22001	22001	22001	22001	22001	None	22006	None	22006	22001	22006	22006	None	22001	22001	22006	22006	22006	22001	22001	22001	22001	22001	22006	22001	22001	22001	None	22001	22001	22001	22001	22001

Table: filer_interests
filer_id	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226
session_id	2009	2011	2013	2007	2021	2019	2017	2015	2023
interest_cd	40305	40305	40305	40305	40305	40305	40305	40305	40305
effect_date	2009-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2007-05-08 00:00:00	2021-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2015-01-01 00:00:00	2023-01-01 00:00:00

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

Table: filer_xref
filer_id		1298226
xref_id		1298226
effect_dt		2007-05-22 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226
filer_id	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226
filer_type	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT
status	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE
effect_dt	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00
naml	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF
namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
city	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO	MISSION VIEJO
st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
zip4	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691	92691
phon	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409	9494708409
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
email	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: filers
filer_id		1298226

Table: lobbying_chg_log
filer_id	1298226	1298226	1298226
change_no	1	0	2
session_id	2007	2007	2017
log_dt	2007-05-18 00:00:00	2007-05-18 00:00:00	2017-02-22 00:00:00
filer_type	1	1	1
correction_flg	None	Y	Y
action	CHANGED	ADDED	ADDED
attribute_changed	RESPONSIBLE OFFICER	FIRM	FIRM
ethics_dt	None	None	None
interests	None	None	None
filer_full_name	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF	MISSION VIEJO; CITY OF
filer_city	None	None	MISSION VIEJO
filer_st	None	None	CA
filer_zip	None	None	92691
filer_phone	None	None	9494708409
entity_type	20	3	3
entity_name	CITY MANAGER DENNIS WILBERG	TOWNSEND PUBLIC AFFAIRS, INC.	GONSALVES & SON; JOE A.
entity_city	None	None	None
entity_st	None	None	None
entity_zip	None	None	None
entity_phone	None	None	None
entity_id	1298228	1147750	None
responsible_officer	None	None	None
effect_dt	2007-05-08 00:00:00	2007-05-08 00:00:00	2017-02-14 00:00:00

Table: received_filings
filer_id	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226	1298226
filing_file_name	1325964_0.cal	1504468_0.cal	1396839_0.cal	1344814_0.cal	1483003_0.cal	1282650_0.cal	1294242_0.cal	1461584_0.cal	1436307_0.cal	1450228_0.cal	1421465_0.cal	1377741_0.cal	1307082_0.cal	1843477_0.cal	1738697_0.cal	1797832_0.cal	1532717_0.cal	1570636_0.cal	1813689_0.cal	1590330_0.cal	1600767_0.cal	1600767_1.cal	1777509_0.cal	1763362_0.cal	223609.cal	1621939_0.cal	1634352_0.cal	1707515_0.cal	1674396_0.cal	1655214_0.cal	1870135_0.cal	1965440_0.cal	2122303_0.cal	2059548_0.cal	2007050_0.cal	1995487_0.cal	2101287_0.cal	1910096_0.cal	1929869_0.cal	2035979_0.cal	1980623_0.cal	2379807_0.cal	170430.cal	2415354_0.cal	2393675_0.cal	2484633_0.cal	2441273_0.cal	2471521_0.cal	2603643_0.cal	2739551_0.cal	2554939_0.cal	2581605_0.cal	2531420_0.cal	2700893_0.cal	2678293_0.cal	2625549_0.cal	2645552_0.cal
received_date	2008-04-22 00:00:00	2010-07-28 00:00:00	2009-02-01 00:00:00	2008-07-22 00:00:00	2010-04-27 00:00:00	2007-07-30 00:00:00	2007-10-23 00:00:00	2010-01-27 00:00:00	2009-07-30 00:00:00	2009-10-27 00:00:00	2009-04-30 00:00:00	2008-10-31 00:00:00	2008-01-28 00:00:00	2014-04-29 00:00:00	2013-01-31 00:00:00	2013-10-28 00:00:00	2010-10-22 00:00:00	2011-01-31 00:00:00	2014-01-27 00:00:00	2011-04-29 00:00:00	2011-07-18 00:00:00	2011-07-28 00:00:00	2013-07-23 00:00:00	2013-04-29 00:00:00	2011-10-31 00:00:00	2011-10-31 00:00:00	2012-01-30 00:00:00	2012-10-30 00:00:00	2012-07-25 00:00:00	2012-04-26 00:00:00	2014-07-30 00:00:00	2015-04-30 00:00:00	2017-01-23 00:00:00	2016-07-27 00:00:00	2016-01-26 00:00:00	2015-10-28 00:00:00	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	2019-04-30 00:00:00	2018-07-31 00:00:00	2019-10-24 00:00:00	2019-07-26 00:00:00	2020-07-30 00:00:00	2020-01-30 00:00:00	2020-04-30 00:00:00	2021-08-02 00:00:00	2022-10-24 00:00:00	2021-02-01 00:00:00	2021-04-30 00:00:00	2020-11-02 00:00:00	2022-07-25 00:00:00	2022-05-02 00:00:00	2021-11-01 00:00:00	2022-01-31 00:00:00
filing_directory	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/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/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
filing_id	1325964	1504468	1396839	1344814	1483003	1282650	1294242	1461584	1436307	1450228	1421465	1377741	1307082	1843477	1738697	1797832	1532717	1570636	1813689	1590330	1600767	1600767	1777509	1763362	None	1621939	1634352	1707515	1674396	1655214	1870135	1965440	2122303	2059548	2007050	1995487	2101287	1910096	1929869	2035979	1980623	2379807	None	2415354	2393675	2484633	2441273	2471521	2603643	2739551	2554939	2581605	2531420	2700893	2678293	2625549	2645552
form_id	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	None	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	None	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635
receive_comment	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing 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 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 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