OpenCalAccess

Filer ID: 1285834

Table: cvr_lobby_disclosure
filing_id	1183840	1258625	1231389	1280992	1231389	1214995	1308615	1308615	1326025	1326025	1294967	1280992	1294967	1343886	1372597	1419740	1419740	1431494	1450794	1450794	1389980	1389980	1431494	1535590	1502004	1485125	1462781	1569202	1619110	1600884	1587603	1633211	1706861	1673164	1656301	1729235	1796224	1774312	1762525	1813835	1907423	1869296	1844239	1980756	1997477	1964551	1934479	2061866	2036039	2010803	2100958	2173559	2155370	2130491	2190645	2274680	2239463	2211288	2376887	2390285	2337725	2318336	2465169	2430800	2412803	2478398	2516980	2545152	2577037	2592869	2638049	2615971	2738708	2698857	2670765
amend_id	0	0	0	0	1	0	0	1	1	0	0	1	1	0	0	0	1	1	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	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	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	F635	F635	F635
sender_id	F00641	F00641	F00641	F00641	F00641	F00641	F00641	F00641	1285834	1285834	F00641	F00641	F00641	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834
filer_id	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834
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	LEM	LEM	LEM
filer_naml	City of La Canada Flintridge	LA CANADA FLINTRIDGE CITY OF	City of La Canada Flintridge	City of La Canada Flintridge	City of La Canada Flintridge	City of La Canada Flintridge	LA CANADA FLINTRIDGE CITY OF	LA CANADA FLINTRIDGE CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	City of La Canada Flintridge	LA CANADA FLINTRIDGE CITY OF	LA CANADA FLINTRIDGE CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE, CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE, CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; 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	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	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	None	None	None
report_num	000	000	000	000	001	000	000	001	001	000	000	001	001	000	000	000	001	001	001	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000
rpt_date	2006-07-13 00:00:00	2007-04-23 00:00:00	2007-01-05 00:00:00	2007-07-23 00:00:00	2007-01-05 00:00:00	2006-10-23 00:00:00	2008-01-29 00:00:00	2008-01-29 00:00:00	2008-04-30 00:00:00	2008-04-22 00:00:00	2007-10-25 00:00:00	2007-07-23 00:00:00	2007-11-16 00:00:00	2008-07-17 00:00:00	2008-10-27 00:00:00	2009-04-28 00:00:00	2009-10-28 00:00:00	2009-10-28 00:00:00	2009-10-28 00:00:00	2009-10-28 00:00:00	2009-08-13 00:00:00	2009-01-16 00:00:00	2009-07-17 00:00:00	2010-10-26 00:00:00	2010-07-21 00:00:00	2010-04-30 00:00:00	2010-01-29 00:00:00	2011-01-28 00:00:00	2011-10-24 00:00:00	2011-07-18 00:00:00	2011-04-21 00:00:00	2012-01-27 00:00:00	2012-10-29 00:00:00	2012-07-20 00:00:00	2012-04-27 00:00:00	2013-01-18 00:00:00	2013-10-22 00:00:00	2013-07-09 00:00:00	2013-04-26 00:00:00	2014-01-27 00:00:00	2014-10-28 00:00:00	2014-07-30 00:00:00	2014-04-29 00:00:00	2015-07-30 00:00:00	2015-10-30 00:00:00	2015-04-29 00:00:00	2015-01-30 00:00:00	2016-07-29 00:00:00	2016-04-29 00:00:00	2016-01-29 00:00:00	2016-10-31 00:00:00	2017-07-28 00:00:00	2017-04-28 00:00:00	2017-01-31 00:00:00	2017-10-26 00:00:00	2018-07-31 00:00:00	2018-04-27 00:00:00	2018-01-31 00:00:00	2019-04-10 00:00:00	2019-07-16 00:00:00	2019-01-17 00:00:00	2018-10-31 00:00:00	2020-04-08 00:00:00	2020-01-15 00:00:00	2019-10-11 00:00:00	2020-07-14 00:00:00	2020-10-16 00:00:00	2021-01-19 00:00:00	2021-04-26 00:00:00	2021-07-13 00:00:00	2022-01-26 00:00:00	2021-10-14 00:00:00	2022-10-21 00:00:00	2022-07-18 00:00:00	2022-04-26 00:00:00
from_date	2006-04-01 00:00:00	2007-01-01 00:00:00	2006-10-01 00:00:00	2007-04-01 00:00:00	2006-10-01 00:00:00	2006-07-01 00:00:00	2007-10-01 00:00:00	2007-10-01 00:00:00	2008-01-01 00:00:00	2008-01-01 00:00:00	2007-07-01 00:00:00	2007-04-01 00:00:00	2007-07-01 00:00:00	2008-04-01 00:00:00	2008-07-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-04-01 00:00:00	2009-07-01 00:00:00	2009-07-01 00:00:00	2008-10-01 00:00:00	2008-10-01 00:00:00	2009-04-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-07-01 00:00:00	2014-04-01 00:00:00	2014-01-01 00:00:00	2015-04-01 00:00:00	2015-07-01 00:00:00	2015-01-01 00:00:00	2014-10-01 00:00:00	2016-04-01 00:00:00	2016-01-01 00:00:00	2015-10-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	2018-04-01 00:00:00	2018-01-01 00:00:00	2017-10-01 00:00:00	2019-01-01 00:00:00	2019-04-01 00:00:00	2018-10-01 00:00:00	2018-07-01 00:00:00	2020-01-01 00:00:00	2019-10-01 00:00:00	2019-07-01 00:00:00	2020-04-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	2021-01-01 00:00:00	2021-04-01 00:00:00	2021-10-01 00:00:00	2021-07-01 00:00:00	2022-07-01 00:00:00	2022-04-01 00:00:00	2022-01-01 00:00:00
thru_date	2006-06-30 00:00:00	2007-03-31 00:00:00	2006-12-31 00:00:00	2007-06-30 00:00:00	2006-12-31 00:00:00	2006-09-30 00:00:00	2007-12-31 00:00:00	2007-12-31 00:00:00	2008-03-31 00:00:00	2008-03-31 00:00:00	2007-09-30 00:00:00	2007-06-30 00:00:00	2007-09-30 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2009-03-31 00:00:00	2009-03-31 00:00:00	2009-06-30 00:00:00	2009-09-30 00:00:00	2009-09-30 00:00:00	2008-12-31 00:00:00	2008-12-31 00:00:00	2009-06-30 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-09-30 00:00:00	2014-06-30 00:00:00	2014-03-31 00:00:00	2015-06-30 00:00:00	2015-09-30 00:00:00	2015-03-31 00:00:00	2014-12-31 00:00:00	2016-06-30 00:00:00	2016-03-31 00:00:00	2015-12-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	2018-06-30 00:00:00	2018-03-31 00:00:00	2017-12-31 00:00:00	2019-03-31 00:00:00	2019-06-30 00:00:00	2018-12-31 00:00:00	2018-09-30 00:00:00	2020-03-31 00:00:00	2019-12-31 00:00:00	2019-09-30 00:00:00	2020-06-30 00:00:00	2020-09-30 00:00:00	2020-12-31 00:00:00	2021-03-31 00:00:00	2021-06-30 00:00:00	2021-12-31 00:00:00	2021-09-30 00:00:00	2022-09-30 00:00:00	2022-06-30 00:00:00	2022-03-31 00:00:00
cum_beg_dt	2006-04-01 00:00:00	2007-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2008-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2007-01-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	2009-01-01 00:00:00	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	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	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	F00641	1285834	1285834	1285834	1285834	F00641	1285834	1285834	None	None	1285834	1285834	1285834	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	1285834	None	1285834	None	None	None	None	None	None	None	None	None	None	None	None	None	None
firm_name	City of La Canada Flintridge	LA CANADA FLINTRIDGE CITY OF	City of La Canada Flintridge	City of La Canada Flintridge	City of La Canada Flintridge	City of La Canada Flintridge	LA CANADA FLINTRIDGE CITY OF	LA CANADA FLINTRIDGE CITY OF	None	None	City of La Canada Flintridge	City of La Canada Flintridge	City of La Canada Flintridge	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	LA CANADA FLINTRIDGE, CITY OF	None	LA CANADA FLINTRIDGE, CITY OF	None	None	None	None	None	None	None	None	None	None	None	None	None	None
firm_city	La Canada Flintridge	LA CANADA / FLINTRIDGE	La Canada Flintridge	La Canada Flintridge	La Canada Flintridge	La Canada Flintridge	LA CANADA / FLINTRIDGE	LA CANADA / FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	La Canada Flintridge	La Canada Flintridge	La Canada Flintridge	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE
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	CA	CA	CA
firm_zip4	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011
firm_phon	818-790-8880	818-790-8880	818-790-8880	818-790-8880	818-790-8880	818-790-8880	818-790-8880	818-790-8880	8187908880	8187908880	818-790-8880	818-790-8880	818-790-8880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	818 790-8880	8187908880	818 790-8880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880
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	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	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	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	None	None	None
sig_date	2006-07-13 00:00:00	2007-04-23 00:00:00	2007-01-12 00:00:00	2007-07-26 00:00:00	2007-05-02 00:00:00	2006-10-30 00:00:00	2008-01-29 00:00:00	2008-01-29 00:00:00	2008-04-30 00:00:00	2008-04-22 00:00:00	2007-10-25 00:00:00	2007-12-17 00:00:00	2007-12-17 00:00:00	2008-07-17 00:00:00	2008-10-27 00:00:00	2009-04-28 00:00:00	2009-10-28 00:00:00	2009-10-28 00:00:00	2009-10-28 00:00:00	2009-10-28 00:00:00	2009-08-13 00:00:00	2009-01-16 00:00:00	2009-07-17 00:00:00	2010-10-26 00:00:00	2010-07-21 00:00:00	2010-04-30 00:00:00	2010-01-29 00:00:00	2011-01-28 00:00:00	2011-10-24 00:00:00	2011-07-18 00:00:00	2011-04-21 00:00:00	2012-01-27 00:00:00	2012-10-29 00:00:00	2012-07-20 00:00:00	2012-04-27 00:00:00	2013-01-18 00:00:00	2013-10-22 00:00:00	2013-07-09 00:00:00	2013-04-26 00:00:00	2014-01-21 00:00:00	2014-10-28 00:00:00	2014-07-30 00:00:00	2014-04-15 00:00:00	2015-07-30 00:00:00	2015-10-30 00:00:00	2015-04-29 00:00:00	2015-01-30 00:00:00	2016-07-29 00:00:00	2016-04-29 00:00:00	2016-01-29 00:00:00	2016-10-31 00:00:00	2017-07-28 00:00:00	2017-04-28 00:00:00	2017-01-31 00:00:00	2017-10-26 00:00:00	2018-07-30 00:00:00	2018-04-27 00:00:00	2018-01-30 00:00:00	2019-04-10 00:00:00	2019-07-16 00:00:00	2019-01-17 00:00:00	2018-10-30 00:00:00	2020-04-08 00:00:00	2020-01-15 00:00:00	2019-10-11 00:00:00	2020-07-14 00:00:00	2020-10-16 00:00:00	2021-01-19 00:00:00	2021-04-26 00:00:00	2021-07-13 00:00:00	2022-01-26 00:00:00	2021-10-14 00:00:00	2022-10-21 00:00:00	2022-07-18 00:00:00	2022-04-26 00:00:00
sig_loc	Sacramento CA	Sacramento CA	SACRAMENTO CA	Sacramento CA	SACRAMENTO CA	Sacramento CA	Sacramento CA	Sacramento CA	SACRAMENTO CA	SACRAMENTO CA	Sacramento CA	Sacramento CA	Sacramento CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA
sig_naml	Wilson	Ellison	ELLISON	Ellison	ELLISON	Ellison	Ellison	Ellison	ELLISON	ELLISON	Ellison	Ellison	Ellison	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON
sig_namf	Bob	Brooks	BROOKS	Brooks	BROOKS	Brooks	Brooks	Brooks	BROOKS	BROOKS	Brooks	Brooks	Brooks	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS
sig_namt	None	None	MR.	None	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	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	None	None	None
prn_naml	Wilson	Ellison	ELLISON	Ellison	ELLISON	Ellison	Ellison	Ellison	ELLISON	ELLISON	Ellison	Ellison	Ellison	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON	ELLISON
prn_namf	Bob	Brooks	BROOKS	Brooks	BROOKS	Brooks	Brooks	Brooks	BROOKS	BROOKS	Brooks	Brooks	Brooks	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS	BROOKS
prn_namt	None	None	MR.	None	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	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	None	None	None
sig_title	Attorney	Attorney	ATTORNEY	Attorney	ATTORNEY	Attorney	Attorney	Attorney	ATTORNEY	ATTORNEY	Attorney	Attorney	Attorney	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY	ATTORNEY
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	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	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	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	None	None	None
ctrib_n_cb	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	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	None	None	None
lby_actvty	AB2987;SB1627	See attached	AB2015;2987;SB1627	None	AB2015;2987;SB1627	AB2015;2987;SB1627	None	None	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2356;2494;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;SCA1;2;5	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2356;2494;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;SCA1;2;5	None	None	None	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2045;2321;2356;2494;2558;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;1350;1473;SCA1;2;5	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2045;2321;2356;2494;2558;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;1350;1473;SCA1;2;5	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2045;2321;2356;2494;2558;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;1350;1473;SCA1;2;5	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2045;2321;2356;2494;2558;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;1350;1473;SCA1;2;5	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2045;2321;2356;2494;2558;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;1350;1473;SCA1;2;5	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2045;2321;2356;2494;2558;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;1350;1473;SCA1;2;5	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2045;2321;2356;2494;2558;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;1350;1473;SCA1;2;5	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2045;2321;2356;2494;2558;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;1350;1473;SCA1;2;5	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2045;2321;2356;2494;2558;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;1350;1473;SCA1;2;5	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2045;2321;2356;2494;2558;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;1350;1473;SCA1;2;5	AB 155;AB 192;AB 194;AB 602;AB 827;AB 1668;AB 1955;AB 2064;AB 2704;SB 501;SB 632;SB 1036;AB 1662;AB 1805;SB 1010	AB 155;AB 186;AB 1668;AB 1849;AB 2704;SB 326;SB 625;SB 1036;AB 1662;AB 1805;AB 2316;SB 1010	AB 155;AB186;AB 541;AB 588;AB 610;AB 1662;AB 1668;AB 1805;AB 1849;AB 2316;AB 2704;ABX8 6;ABX8 7;ABX8 9;ABX8 14;ABX8 37;ACA 9;SB 214;SB 528;SB 1010;SBX8 6;SCA 12	AB29;31;57;196;373;382;391;414;600;620;637;701;704;739;772;783;784;792;800;826;832;842;848;872;891;927;938;971;992;997;1017;1019;1053;1091;1096;1129;1161;1205;1221;1231;1252;1253;1315;1358;1366;1380;AB1460;1489;1493;1496;1536;1672;1715;1850;2045;2321;2356;2494;2558;2687;2915;2989;ACA8;SB2;9;35;46;152;156;167;205;231;286;303;307;343;432;522;545;546;586;600;669;732;753;931;934;964;1350;1473;SCA1;2;5	AB 155;AB 194;AB 602;AB 827;AB 1662;SB 501;SB 632;SB 848;SB 863;STATE BUDGET MATTERS	AB 187, AB 438, AB 506, ABX1 16, ABX1 41, SB 46, SB 89, SB 186, SB 194, SB 264, SB 670, SB 922, SBX1 4, SBX1 11, AB 751, SB 241, SB 693, STATE BUDGET MATTERS	AB 187, AB 506, AB 1250, ABX1 26, ABX1 27, SB 46, SB 77, SB 89, SB 159, SB 186, SB 194, SB 286, SB 450, SB 670, SBX1 11, SBX1 14, SBX1 15, SBX1 24, STATE BUDGET MATTERS, AB 353, SB 241, SB 693, SB 931	AB 187, AB 506, SB 46, SB 186, SB 194, SB 670, AB 353, SB 241, SB 693, STATE BUDGET MATTERS	AB 187, AB 438, AB 506, SB 46, SB 186, SB 670, SB 922, AB 751, SB 241, SB 693, STATE BUDGET MATTERS	AB 340, AB 904, AB 1191, AB 2592, SB 214, SB 1156, AB 1634, AB 1650, AB 2670, SB 204, SB 1544, STATE BUDGET MATTERS	AB 904, AB 1191, AB 1650, AB 1692, SB 204, SB 1176, SB 1544, STATE BUDGET MATTERS	AB 1650, SB 1544, STATE BUDGET MATTERS	STATE BUDGET MATTERS	AB 229; AB 325; AB 576; AB 662; SB 1; SB 7; SB 33;SB 69; SB 184; SB 416; SB 594;SB 743; SB 811; SCA 3; SCA 4; STATE BUDGET MATTERS	AB 76; AB 110; AB 229; SB 1; SB 7; SB 33; SB 71; SB 184; SCA 3; SCA 9; AB 158; AB 323; AB 325; AB 576; SB 69; SB 405; SB 700; SB 811; SCA 4;STATE BUDGET MATTERS	AB 229; SB 1; SB 7; SB 33; SB 184; SCA 9;AB 323; SCA 4; STATE BUDGET MATTERS	AB 158; AB 229; AB 323; AB 325; AB 471; AB 561; AB 576; AB 661; SB 1; SB 7; SB 33; SB 69; SB 388; SB 405; SB 416; SB 594; SB 700; SB 811; SCA 4; STATE BUDGET MATTERS	AB 229; AB 1147; AB 1594; AB 2280; SB 1; SB 33; SB 69; SB 270; SB 388; SB 628; SB 743; SB 1262; SB 1462; SCA 4; SCA 9; STATE BUDGET MATTERS	AB 229; AB 1147; AB 1383; AB 1594; AB 1970; AB 2550; HR 29; SB 1; SB 33; SB 69; SB 270; SB 388; SB 852; SB 862; SB 1262; SB 1462; SCA 4; SCA 9; STATE BUDGET MATTERS	AB 158; AB 229; AB 323; AB 471; AB 561; AB 1970; HR 29; SB1; SB 33; SB 270; SB 388; SB 405; SB 700; SB 1462; SCA 4; SCA 9; STATE BUDGET MATTERS	AB 2; AB 57; AB 93; AB 113; AB 182; AB 266; AB 277; AB 278; AB 1265; SB 16; SB 158; SB 184; STATE BUDGET MATTERS	AB 2; AB 57; AB 113; AB 182; AB 266; AB 277; AB 278; AB 347; AB 1265; SB 16; SB 107; SB 140; SB 158; SB 184; SB 485; SBX 2 5; STATE BUDGET MATTERS	AB 2; AB 266; AB 654; SB 184; STATE BUDGET MATTERS	STATE BUDGET MATTERS	AB 113; AB 278; AB 350; AB 1591; AB 2220; AB 2586; SB 140; SB 876; SB 1018; SB 1246; SB 1472; SBX2 5; STATE BUDGET MATTERS	AB 278; AB 350; AB 1265; AB 1591; AB 1707; AB 2220; SB 16; SB 140; SB 158; SB 760; SB 876; SB 1018; SB 1246; SBX2 5; STATE BUDGET MATTERS	AB 57; AB 113; AB 182; AB 266; AB 277; AB 278; AB 350; AB 1265; SB 16; SB 140; SB 158; SB 485; SBX 2 5; STATE BUDGET MATTERS	AB 113; AB 278; AB 350; AB 779; AB 1217; AB 1591; AB 2220; AB 2835; AB 2586; SB 1018; STATE BUDGET MATTERS	AB 1; AB 64; AB 110; AB 287; AB 533; AB 1250; SB 1; SB 2; SB 3; SB 94; SB 275; SB 649; STATE BUDGET MATTERS	AB 1; SB 1; SB 2; SB 3; AB 287; AB 1250; SB 275; SB 649; STATE BUDGET MATTERS	STATE BUDGET MATTERS	AB 1; AB 64; AB 110; AB 287; AB 533; SB 2; SB 3; SB 275; SB 649; STATE BUDGET MATTERS	AB 64; AB 1912; ACA 31; AB 533; SB 25; SB 827; SB 1126; SB 1266; STATE BUDGET MATTERS	AB 1; AB 64; AB 287; AB 533; AB 1912; SB 25; SB 827; SB 1126; SB 1266; STATE BUDGET MATTERS	AB 1; AB 64; AB 110; AB 287; AB 533; SB 275; SB 649; STATE BUDGET MATTERS	AB 1568; SB 50; AB 29; SB 7; LEGISLATURE RE: STATE BUDGET MATTERS	Legislature re: STATE BUDGET MATTERS; AB 1093; AB 1568; ACA 1; SB 5; SB 50; AB 29; SB 7	LEGISLATURE RE: STATE BUDGET MATTERS	AB 64; AB 533; AB 1912; SB 25; SB 1126; ACA 31; STATE BUDGET MATTERS	Legislature re: STATE BUDGET MATTERS; AB 1568; SB 50; SB 902	Legislature re: STATE BUDGET MATTERS; AB 1093; AB 1568; ACA 1; SB 5; SB 50; AB 29; SB 7	Legislature re: STATE BUDGET MATTERS; AB 1093; AB 1568; ACA 1; SB 5; SB 50; AB 29; SB 7	Legislature re: STATE BUDGET MATTERS; AB 2167; SB 902	Legislature re: STATE BUDGET MATTERS; AB 2167; SB 902; SB 995; SB 1085; SB 1120; SB 1473	Legislature re: STATE BUDGET MATTERS	Legislature re: STATE BUDGET MATTERS; SB 6; SB 9; SB 55; SB 426	Legislature re: STATE BUDGET MATTERS; AB 339; SB 6; SB 9; SB 15; SB 55; SB 210; SB 426; SB 556; SB 619	Legislature re: STATE BUDGET MATTERS; AB 339; SB 6; SB 15; SB 55; SB 210; SB 426; SB 556; SB 619	Legislature re: STATE BUDGET MATTERS; AB 339; AB 361; SB 6; SB 9; SB 15; SB 55; SB 210; SB 426; SB 556; SB 619	Legislature re: STATE BUDGET MATTERS; AB 1886; AB 1944; AB 2449; SB 6; SB 15; SB 379; SB 914; SB 1127; SB 1186	Legislature re: STATE BUDGET MATTERS; AB 1944; AB 2449; SB 6; SB 15; SB 379; SB 914; SB 1186	Legislature re: STATE BUDGET MATTERS; SB 6; SB 15; SB 55; SB 210; SB 379; SB 426; SB 914; SB 1186
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	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	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	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	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	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	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	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	None	None	None

Table: cvr_registration
filing_id	1223916	1384607	1552890	1718775	1919720	2113215	2328138	2537040
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	F00641	F00641	F00641	F00641	F00641	F00641	F00641	F00641
filer_id	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834
entity_cd	LEM	LEM	LEM	LEM	LEM	LEM	LEM	LEM
filer_naml	LA CANADA FLINTRIDGE CITY OF	CITY OF LA CANADA FLINTRIDGE	CITY OF LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; 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	2006-12-19 00:00:00	2008-12-19 00:00:00	2010-12-21 00:00:00	2012-12-19 00:00:00	2014-12-22 00:00:00	2016-12-22 00:00:00	2018-12-14 00:00:00	2020-12-15 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	2006-11-20 00:00:00	2008-12-01 00:00:00	2010-12-01 00:00:00	2012-12-01 00:00:00	2014-12-01 00:00:00	2016-12-31 00:00:00	2018-12-31 00:00:00	2020-12-31 00:00:00
bus_city	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE
bus_st	CA	CA	CA	CA	CA	CA	CA	CA
bus_zip4	91011	91011	91011	91011	91011	91011	91011	91011
bus_phon	818-790-8880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880
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	2006-11-30 00:00:00	2008-11-24 00:00:00	2010-11-22 00:00:00	2012-10-31 00:00:00	2014-11-10 00:00:00	2016-12-01 00:00:00	2018-12-10 00:00:00	2020-12-01 00:00:00
sig_loc	La Canada Flintridge CA	None	None	None	None	None	None	None
sig_naml	Alexander	ALEXANDER	ALEXANDER	ALEXANDER	ALEXANDER	ALEXANDER	ALEXANDER	ALEXANDER
sig_namf	Mark	MARK R.	MARK	MARK R.	MARK R.	MARK R.	MARK	MARK R.
sig_namt	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None
prn_naml	None	ALEXANDER	ALEXANDER	ALEXANDER	ALEXANDER	ALEXANDER	ALEXANDER	ALEXANDER
prn_namf	None	MARK R.	MARK	MARK R.	MARK R.	MARK R.	MARK	MARK R.
prn_namt	None	None	None	None	None	None	None	None
prn_nams	None	None	None	None	None	None	None	None
sig_title	City Manager	CITY MANAGER	CITY MANAGER	CITY MANAGER	CITY MANAGER	CITY MANAGER	CITY MANAGER	CITY MANAGER
stmt_firm	None	None	None	None	None	None	None	None
ind_cb	None	None	None	None	None	None	None	None
bus_cb	None	None	None	None	None	None	None	None
trade_cb	None	None	None	None	None	None	None	None
oth_cb	X	X	X	X	X	X	X	X
a_b_name	None	None	None	None	None	None	None	None
a_b_city	None	None	None	None	None	None	None	None
a_b_st	None	None	None	None	None	None	None	None
a_b_zip4	None	None	None	None	None	None	None	None
descrip_1	City Government	CITY GOVERNMENT	CITY GOVERNMENT	CITY GOVERNMENT	CITY GOVERNMENT	CITY GOVERNMENT	CITY GOVERNMENT	CITY GOVERNMENT
descrip_2	None	CITY GOVERNMENT	CITY GOVERNMENT	CITY GOVERNMENT	CITY GOVERNMENT	CITY GOVERNMENT	CITY GOVERNMENT	CITY 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	Ellison Wilson Advocacy LLC	ELLISON WILSON ADVOCACY, LLC	ELLISON WILSON ADVOCACY, LLC	ELLISON WILSON ADVOCACY LLC	ELLISON WILSON ADVOCACY, LLC	ELLISON WILSON ADVOCACY, LLC	ELLISON WILSON ADVOCACY, LLC	ELLISON WILSON ADVOCACY LLC
auth_city	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
auth_st	CA	CA	CA	CA	CA	CA	CA	CA
auth_zip4	95814	95814	95811	95811	95811	95814	95814	95814
lobby_int	None	None	None	None	None	None	None	None
influen_yn	None	None	None	None	None	None	None	None
firm_name	None	None	None	None	None	None	None	None
newcert_cb	None	None	None	None	None	None	None	None
rencert_cb	None	None	None	None	None	None	None	None
complet_dt	None	None	None	None	None	None	None	None
lby_reg_cb	None	None	None	None	None	None	None	None
lby_604_cb	None	None	None	None	None	None	None	None
st_leg_yn	None	None	None	None	None	None	None	None
st_agency	None	None	None	None	None	None	None	None
lobby_cb	None	None	None	None	None	None	None	None
l_firm_cb	None	None	None	None	None	None	None	None

Table: filer_address
filer_id	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834
adrid	2102253	2115701	2164745	2206848	2545483	2513929	2417169	2278082	2345639	2468076
effect_dt	2006-04-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2023-01-01 00:00:00	2021-01-01 00:00:00	2017-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2019-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	2005	2007	2009	2011	2023	2021	2017	2013	2015	2019

Table: filer_filings
filer_id	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834
filing_id	1165473	1165475	1183840	1231389	1214995	1223916	1258625	1235158	1231389	1280992	1308615	1308615	1294967	1280992	1294967	1774312	1964551	1869296	1796224	1948065	1907423	1326025	1326025	1343886	1389980	1372597	1384607	1414831	1419740	1431494	1450794	1419740	1431494	1450794	1462781	1485125	1389980	1502004	1535590	1554719	1552890	1587603	1569202	1619110	1600884	1633211	1656301	1673164	1813835	1934479	1919720	1718775	1706861	1729235	1844239	1724697	1762525	1980756	2376887	2211288	2359089	2318336	2274680	2465169	2190645	1997477	2010803	2036039	2061866	2125444	2100958	2113215	2155370	2130491	2173559	2390285	2328138	2537040	2478398	2545152	2516980	2239463	2430800	2412803	2337725	2698857	2561961	2577037	2592869	2638049	2615971	2670765	2738708
period_id	None	None	186	188	187	188	189	None	188	190	192	192	191	190	191	214	221	218	215	None	219	193	193	194	196	195	196	None	197	198	199	197	198	199	200	201	196	202	203	None	204	205	204	207	206	208	209	210	216	220	220	212	211	212	217	None	213	222	237	232	None	235	234	241	231	223	224	225	226	None	227	228	229	228	230	238	236	244	242	244	243	233	240	239	236	250	None	245	246	248	247	249	251
form_id	F602	F999	F635	F635	F635	F602	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F602	F635	F635	F635	F602	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F602	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635
filing_sequence	0	0	0	0	0	0	0	0	1	0	1	0	0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	1	1	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
filing_date	2006-04-26 00:00:00	2006-04-27 00:00:00	2006-07-13 00:00:00	2007-01-24 00:00:00	2006-10-30 00:00:00	2006-12-19 00:00:00	2007-04-23 00:00:00	2006-12-21 00:00:00	2007-05-02 00:00:00	2007-07-26 00:00:00	2008-01-29 00:00:00	2008-01-29 00:00:00	2007-10-25 00:00:00	2007-12-17 00:00:00	2007-12-17 00:00:00	2013-07-09 00:00:00	2015-04-29 00:00:00	2014-07-30 00:00:00	2013-10-22 00:00:00	2014-12-29 00:00:00	2014-10-28 00:00:00	2008-04-30 00:00:00	2008-04-22 00:00:00	2008-07-17 00:00:00	2009-01-16 00:00:00	2008-10-27 00:00:00	2008-12-19 00:00:00	2008-12-18 00:00:00	2009-04-28 00:00:00	2009-07-17 00:00:00	2009-10-28 00:00:00	2009-10-28 00:00:00	2009-10-28 00:00:00	2009-10-28 00:00:00	2010-01-29 00:00:00	2010-04-30 00:00:00	2009-08-13 00:00:00	2010-07-21 00:00:00	2010-10-26 00:00:00	2010-12-21 00:00:00	2010-12-21 00:00:00	2011-04-21 00:00:00	2011-01-28 00:00:00	2011-10-24 00:00:00	2011-07-18 00:00:00	2012-01-27 00:00:00	2012-04-27 00:00:00	2012-07-20 00:00:00	2014-01-27 00:00:00	2015-01-30 00:00:00	2014-12-22 00:00:00	2012-12-19 00:00:00	2012-10-29 00:00:00	2013-01-18 00:00:00	2014-04-29 00:00:00	2012-12-19 00:00:00	2013-04-26 00:00:00	2015-07-30 00:00:00	2019-04-24 00:00:00	2018-01-31 00:00:00	2018-12-21 00:00:00	2018-10-31 00:00:00	2018-07-31 00:00:00	2020-04-08 00:00:00	2017-10-26 00:00:00	2015-10-30 00:00:00	2016-01-29 00:00:00	2016-04-29 00:00:00	2016-07-29 00:00:00	2016-12-29 00:00:00	2016-10-31 00:00:00	2016-12-22 00:00:00	2017-04-28 00:00:00	2017-01-31 00:00:00	2017-07-28 00:00:00	2019-07-16 00:00:00	2018-12-14 00:00:00	2020-12-15 00:00:00	2020-07-14 00:00:00	2021-01-19 00:00:00	2020-10-16 00:00:00	2018-04-27 00:00:00	2020-01-15 00:00:00	2019-10-11 00:00:00	2019-01-22 00:00:00	2022-07-18 00:00:00	2020-12-18 00:00:00	2021-04-26 00:00:00	2021-07-13 00:00:00	2022-01-26 00:00:00	2021-10-14 00:00:00	2022-04-26 00:00:00	2022-10-21 00:00:00
stmnt_type	10005	10005	10001	10001	10001	10001	10001	10005	10002	10001	10002	10001	10001	10002	10002	10001	10001	10001	10001	10005	10001	10002	10001	10001	10001	10001	10001	10005	10001	10001	10001	10002	10002	10002	10001	10001	10002	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001
stmnt_status	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	11003	11003	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	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11003	11003
session_id	2005	2005	2005	2005	2005	2007	2007	2007	2005	2007	2007	2007	2007	2007	2007	2013	2015	2013	2013	2015	2013	2007	2007	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2007	2009	2009	2011	2011	2011	2009	2011	2011	2011	2011	2011	2013	2013	2015	2013	2011	2011	2013	2013	2013	2015	2019	2017	2019	2017	2017	2019	2017	2015	2015	2015	2015	2017	2015	2017	2017	2015	2017	2019	2019	2021	2019	2019	2019	2017	2019	2019	2017	2021	2021	2021	2021	2021	2021	2021	2021
user_id	CFLAGG	CFLAGG	LTHIBAUL	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	SARRIAGA	LTHIBAUL	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	LTHIBAUL	LTHIBAUL	ASAETERN	AGLADNEY	AGLADNEY	AGLADNEY	YRODRIGU	ASAETERN	LTHIBAUL	LTHIBAUL	LTHIBAUL	JINGRAM	JINGRAM	*	JINGRAM	MGUERRA	MGUERRA	MGUERRA	MGUERRA	MGUERRA	MGUERRA	ASAETERN	ASAETERN	JINGRAM	ASAETERN	ASAETERN	SARRIAGA	*	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	ASAETERN	ASAETERN	ASAETERN	YRODRIGU	PBANFORD	AGLADNEY	AGLADNEY	ASAETERN	PBANFORD	ASAETERN	AGLADNEY	GTAYLOR	AGLADNEY	GPEREZ	AGLADNEY	AGLADNEY	SUSHAKOV	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	SARRIAGA	AGLADNEY	GPEREZ	AGLADNEY	AGLADNEY	AGLADNEY	SUSHAKOV	GPEREZ	MMERCHANT	VUKSTINA	MKIRKHAM	GTAYLOR	AGLADNEY	AGLADNEY	GTAYLOR	AGLADNEY	CAFILER	MMERCHANT	CHATRIDGE	GTAYLOR	CHATRIDGE	CHATRIDGE	CAFILER	CAFILER
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11003	11003	11003	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	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	11003	11001	11003	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11003	11003
rpt_start	1900-01-01 00:00:00	1900-01-01 00:00:00	2006-04-01 00:00:00	2006-10-01 00:00:00	2006-07-01 00:00:00	2006-12-19 00:00:00	2007-01-01 00:00:00	1900-01-01 00:00:00	2006-10-01 00:00:00	2007-04-01 00:00:00	2007-10-01 00:00:00	2007-10-01 00:00:00	2007-07-01 00:00:00	2007-04-01 00:00:00	2007-07-01 00:00:00	2013-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-01-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-10-01 00:00:00	2008-07-01 00:00:00	2008-12-19 00:00:00	1900-01-01 00:00:00	2009-01-01 00:00:00	2009-04-01 00:00:00	2009-07-01 00:00:00	2009-01-01 00:00:00	2009-04-01 00:00:00	2009-07-01 00:00:00	2009-10-01 00:00:00	2010-01-01 00:00:00	2008-10-01 00:00:00	2010-04-01 00:00:00	2010-07-01 00:00:00	1900-01-01 00:00:00	2010-12-21 00:00:00	2011-01-01 00:00:00	2010-10-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-22 00:00:00	2012-12-19 00:00:00	2012-07-01 00:00:00	2012-10-01 00:00:00	2014-01-01 00:00:00	1900-01-01 00:00:00	2013-01-01 00:00:00	2015-04-01 00:00:00	2019-01-01 00:00:00	2017-10-01 00:00:00	1900-01-01 00:00:00	2018-07-01 00:00:00	2018-04-01 00:00:00	2020-01-01 00:00:00	2017-07-01 00:00:00	2015-07-01 00:00:00	2015-10-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	1900-01-01 00:00:00	2016-07-01 00:00:00	2016-12-22 00:00:00	2017-01-01 00:00:00	2016-10-01 00:00:00	2017-04-01 00:00:00	2019-04-01 00:00:00	2018-12-14 00:00:00	2020-12-15 00:00:00	2020-04-01 00:00:00	2020-10-01 00:00:00	2020-07-01 00:00:00	2018-01-01 00:00:00	2019-10-01 00:00:00	2019-07-01 00:00:00	2018-10-01 00:00:00	2022-04-01 00:00:00	1900-01-01 00:00:00	2021-01-01 00:00:00	2021-04-01 00:00:00	2021-10-01 00:00:00	2021-07-01 00:00:00	2022-01-01 00:00:00	2022-07-01 00:00:00
rpt_end	1900-01-01 00:00:00	1900-01-01 00:00:00	2006-06-30 00:00:00	2006-12-31 00:00:00	2006-09-30 00:00:00	2006-12-19 00:00:00	2007-03-31 00:00:00	1900-01-01 00:00:00	2006-12-31 00:00:00	2007-06-30 00:00:00	2007-12-31 00:00:00	2007-12-31 00:00:00	2007-09-30 00:00:00	2007-06-30 00:00:00	2007-09-30 00:00:00	2013-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-03-31 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-12-31 00:00:00	2008-09-30 00:00:00	2008-12-19 00:00:00	1900-01-01 00:00:00	2009-03-31 00:00:00	2009-06-30 00:00:00	2009-09-30 00:00:00	2009-03-31 00:00:00	2009-06-30 00:00:00	2009-09-30 00:00:00	2009-12-31 00:00:00	2010-03-31 00:00:00	2008-12-31 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	1900-01-01 00:00:00	2010-12-21 00:00:00	2011-03-31 00:00:00	2010-12-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-22 00:00:00	2012-12-19 00:00:00	2012-09-30 00:00:00	2012-12-31 00:00:00	2014-03-31 00:00:00	1900-01-01 00:00:00	2013-03-31 00:00:00	2015-06-30 00:00:00	2019-03-31 00:00:00	2017-12-31 00:00:00	1900-01-01 00:00:00	2018-09-30 00:00:00	2018-06-30 00:00:00	2020-03-31 00:00:00	2017-09-30 00:00:00	2015-09-30 00:00:00	2015-12-31 00:00:00	2016-03-31 00:00:00	2016-06-30 00:00:00	1900-01-01 00:00:00	2016-09-30 00:00:00	2016-12-22 00:00:00	2017-03-31 00:00:00	2016-12-31 00:00:00	2017-06-30 00:00:00	2019-06-30 00:00:00	2018-12-14 00:00:00	2020-12-15 00:00:00	2020-06-30 00:00:00	2020-12-31 00:00:00	2020-09-30 00:00:00	2018-03-31 00:00:00	2019-12-31 00:00:00	2019-09-30 00:00:00	2018-12-31 00:00:00	2022-06-30 00:00:00	1900-01-01 00:00:00	2021-03-31 00:00:00	2021-06-30 00:00:00	2021-12-31 00:00:00	2021-09-30 00:00:00	2022-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
filing_type	None	None	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22001	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22001	22006	None	22006	22006	22006	22006	22006	22006

Table: filer_interests
filer_id	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834
session_id	2009	2007	2017	2013	2011	2005	2015	2019	2021	2023
interest_cd	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305
effect_date	2009-01-01 00:00:00	2007-01-01 00:00:00	2017-01-01 00:00:00	2013-01-01 00:00:00	2011-01-01 00:00:00	2006-04-01 00:00:00	2015-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2023-01-01 00:00:00

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

Table: filer_xref
filer_id		1285834
xref_id		1285834
effect_dt		2006-04-27 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834
filer_id	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834	1285834
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
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
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
naml	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE; CITY OF	LA CANADA FLINTRIDGE, CITY OF	LA CANADA FLINTRIDGE, CITY OF	LA CANADA FLINTRIDGE, CITY OF	LA CANADA FLINTRIDGE, CITY OF	LA CANADA FLINTRIDGE, CITY OF	LA CANADA FLINTRIDGE, CITY OF	LA CANADA FLINTRIDGE, CITY OF	LA CANADA FLINTRIDGE, CITY OF	LA CANADA FLINTRIDGE, CITY OF	LA CANADA FLINTRIDGE, 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
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
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
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
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
city	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE	LA CANADA FLINTRIDGE
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
zip4	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011	91011
phon	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880	8187908880
fax	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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

Table: filers
filer_id		1285834

Table: lobbying_chg_log
filer_id	1285834	1285834
change_no	1	2
session_id	2005	2021
log_dt	2006-07-19 00:00:00	2020-12-18 00:00:00
filer_type	1	1
correction_flg	None	None
action	SET ACTIVE	CHANGED
attribute_changed	FIRM	RESPONSIBLE OFFICER
ethics_dt	None	None
interests	None	None
filer_full_name	LA CANADA FLINTRIDGE, CITY OF	LA CANADA FLINTRIDGE; CITY OF
filer_city	None	None
filer_st	None	None
filer_zip	None	None
filer_phone	None	None
entity_type	3	20
entity_name	WILSON GROUP, LLC, THE	CITY MANAGER MARK R. ALEXANDER
entity_city	None	None
entity_st	None	None
entity_zip	None	None
entity_phone	None	None
entity_id	1147264	1285835
responsible_officer	None	None
effect_dt	2006-04-01 00:00:00	2021-01-01 00:00:00

Table: received_filings
filer_id	1285834	1285834	1285834	1285834	1285834	1285834	1285834
filing_file_name	1258625_0.cal	1280992_1.cal	1294967_1.cal	1308615_0.cal	1308615_1.cal	2376887_0.cal	2337725_0.cal
received_date	2007-04-23 00:00:00	2007-12-17 00:00:00	2007-12-17 00:00:00	2008-01-29 00:00:00	2008-01-29 00:00:00	2019-04-24 00:00:00	2019-01-22 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
filing_id	1258625	1280992	1294967	1308615	1308615	2376887	2337725
form_id	F635	F635	F635	F635	F635	F635	F635
receive_comment	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted