OpenCalAccess

Filer ID: 1276024

Table: cvr_lobby_disclosure
filing_id	1172445	1145289	1133970	1112671	1262494	1189333	1234184	1281256	1215495	1308367	1328716	1297610	1350755	1328435	1374688	1434190	1421614	1447998	1397202	1536679	1567958	1503245	1462490	1482762	1621432	1604631	1588974	1634525	1679241	1708718	1655062	1736834	1765032	1796391	1814515	1776970	1782042	1901016	1867027	1839559	1932076	1993530	1976216	1962194	2056282	2008244	2029081	2099833	2169885	2152449	2123034	2189391	2203650	2269672	2309561	2233665	2391517	2377591	2341917	2432146	2466250	2414473	2544815	2574205	2518173	2480959	2634718	2615937	2593165	2733771	2667070	2698501
amend_id	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615
sender_id	1276024	E00581	E00581	E00581	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00662	F00662	F00662	F00946	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662
filer_id	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024
entity_cd	FRM	LBY	LBY	LBY	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY
filer_naml	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW	SOLIS-SHAW
filer_namf	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.
filer_namt	None	Ms.	Ms.	Ms.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Ms.	Ms.	Ms.	None	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.
filer_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
report_num	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000
rpt_date	2006-05-22 00:00:00	2006-01-27 00:00:00	2005-10-31 00:00:00	2005-07-19 00:00:00	2007-04-30 00:00:00	2006-07-28 00:00:00	2007-01-29 00:00:00	2007-07-26 00:00:00	2006-10-30 00:00:00	2008-01-29 00:00:00	2008-04-29 00:00:00	2007-10-31 00:00:00	2008-07-10 00:00:00	2008-04-11 00:00:00	2008-10-15 00:00:00	2009-07-10 00:00:00	2009-04-09 00:00:00	2009-10-08 00:00:00	2009-01-08 00:00:00	2010-10-14 00:00:00	2011-01-17 00:00:00	2010-07-12 00:00:00	2010-01-11 00:00:00	2010-04-12 00:00:00	2011-10-12 00:00:00	2011-07-15 00:00:00	2011-04-12 00:00:00	2012-01-19 00:00:00	2012-07-05 00:00:00	2012-10-16 00:00:00	2012-04-11 00:00:00	2013-01-23 00:00:00	2013-04-16 00:00:00	2013-10-22 00:00:00	2014-01-28 00:00:00	2013-07-22 00:00:00	2013-07-09 00:00:00	2014-10-20 00:00:00	2014-07-26 00:00:00	2014-04-18 00:00:00	2015-01-28 00:00:00	2015-10-22 00:00:00	2015-07-22 00:00:00	2015-04-26 00:00:00	2016-07-19 00:00:00	2016-01-27 00:00:00	2016-04-17 00:00:00	2016-10-28 00:00:00	2017-07-22 00:00:00	2017-04-23 00:00:00	2017-01-24 00:00:00	2017-10-22 00:00:00	2018-01-21 00:00:00	2018-07-25 00:00:00	2018-10-20 00:00:00	2018-04-21 00:00:00	2019-07-20 00:00:00	2019-04-25 00:00:00	2019-01-28 00:00:00	2020-01-18 00:00:00	2020-04-19 00:00:00	2019-10-22 00:00:00	2021-01-17 00:00:00	2021-04-14 00:00:00	2020-10-19 00:00:00	2020-07-25 00:00:00	2022-01-16 00:00:00	2021-10-14 00:00:00	2021-07-14 00:00:00	2022-10-14 00:00:00	2022-04-18 00:00:00	2022-07-15 00:00:00
from_date	2006-01-01 00:00:00	2005-10-01 00:00:00	2005-07-01 00:00:00	2005-04-01 00:00:00	2007-01-01 00:00:00	2006-04-01 00:00:00	2006-10-01 00:00:00	2007-04-01 00:00:00	2006-07-01 00:00:00	2007-10-01 00:00:00	2008-01-01 00:00:00	2007-07-01 00:00:00	2008-04-01 00:00:00	2008-02-19 00:00:00	2008-07-01 00:00:00	2009-04-01 00:00:00	2009-01-01 00:00:00	2009-07-01 00:00:00	2008-10-01 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	2010-04-01 00:00:00	2009-10-01 00:00:00	2010-01-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-04-01 00:00:00	2012-07-01 00:00:00	2012-01-01 00:00:00	2012-10-01 00:00:00	2013-01-01 00:00:00	2013-07-01 00:00:00	2013-10-01 00:00:00	2013-04-01 00:00:00	2013-04-01 00:00:00	2014-07-01 00:00:00	2014-04-01 00:00:00	2014-01-01 00:00:00	2014-10-01 00:00:00	2015-07-01 00:00:00	2015-04-01 00:00:00	2015-01-01 00:00:00	2016-04-01 00:00:00	2015-10-01 00:00:00	2016-01-01 00:00:00	2016-07-01 00:00:00	2017-04-01 00:00:00	2017-01-01 00:00:00	2016-10-01 00:00:00	2017-07-01 00:00:00	2017-10-01 00:00:00	2018-04-01 00:00:00	2018-07-01 00:00:00	2018-01-01 00:00:00	2019-04-01 00:00:00	2019-01-01 00:00:00	2018-10-01 00:00:00	2019-10-01 00:00:00	2020-01-01 00:00:00	2019-07-01 00:00:00	2020-10-01 00:00:00	2021-01-01 00:00:00	2020-07-01 00:00:00	2020-04-01 00:00:00	2021-10-01 00:00:00	2021-07-01 00:00:00	2021-04-01 00:00:00	2022-07-01 00:00:00	2022-01-01 00:00:00	2022-04-01 00:00:00
thru_date	2006-03-31 00:00:00	2005-12-31 00:00:00	2005-09-30 00:00:00	2005-06-30 00:00:00	2007-03-31 00:00:00	2006-06-30 00:00:00	2006-12-31 00:00:00	2007-06-30 00:00:00	2006-09-30 00:00:00	2007-12-31 00:00:00	2008-03-30 00:00:00	2007-09-30 00:00:00	2008-06-30 00:00:00	2008-03-31 00:00:00	2008-09-30 00:00:00	2009-06-30 00:00:00	2009-03-31 00:00:00	2009-09-30 00:00:00	2008-12-31 00:00:00	2010-09-30 00:00:00	2010-12-31 00:00:00	2010-06-30 00:00:00	2009-12-31 00:00:00	2010-03-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-06-30 00:00:00	2012-09-30 00:00:00	2012-03-31 00:00:00	2012-12-31 00:00:00	2013-03-31 00:00:00	2013-09-30 00:00:00	2013-12-31 00:00:00	2013-06-30 00:00:00	2013-05-31 00:00:00	2014-09-30 00:00:00	2014-06-30 00:00:00	2014-03-31 00:00:00	2014-12-31 00:00:00	2015-09-30 00:00:00	2015-06-30 00:00:00	2015-03-31 00:00:00	2016-06-30 00:00:00	2015-12-31 00:00:00	2016-03-31 00:00:00	2016-09-30 00:00:00	2017-06-30 00:00:00	2017-03-31 00:00:00	2016-12-31 00:00:00	2017-09-30 00:00:00	2017-12-31 00:00:00	2018-06-30 00:00:00	2018-09-30 00:00:00	2018-03-31 00:00:00	2019-06-30 00:00:00	2019-03-31 00:00:00	2018-12-31 00:00:00	2019-12-31 00:00:00	2020-03-31 00:00:00	2019-09-30 00:00:00	2020-12-31 00:00:00	2021-03-31 00:00:00	2020-09-30 00:00:00	2020-06-30 00:00:00	2021-12-31 00:00:00	2021-09-30 00:00:00	2021-06-30 00:00:00	2022-09-30 00:00:00	2022-03-31 00:00:00	2022-06-30 00:00:00
cum_beg_dt	None	2005-01-01 00:00:00	2005-01-01 00:00:00	2005-01-01 00:00:00	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	2013-01-01 00:00:00	2013-01-01 00:00:00	2013-01-01 00:00:00	None	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	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	2021-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00
firm_id	1276024	E00581	E00581	E00581	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00946	F00662	F00662	F00662	F00946	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662	F00662
firm_name	City of Los Angeles	LOS ANGELES, CITY OF	LOS ANGELES, CITY OF	LOS ANGELES, CITY OF	01/01/2007	City of Los Angeles	City of Los Angeles	City of Los Angeles	City of Los Angeles	City of Los Angeles	City of Los Angeles	City of Los Angeles	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	PUBLIC POLICY ADVOCATES, LLC	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	SHAW / YODER / ANTWIH, INC.	Shaw Yoder Antwih Schmelzer & Lange, Inc.	Shaw Yoder Antwih Schmelzer & Lange, Inc.	Shaw Yoder Antwih Schmelzer & Lange, Inc.	Shaw Yoder Antwih Schmelzer & Lange, Inc.	Shaw Yoder Antwih Schmelzer & Lange, Inc.	Shaw Yoder Antwih Schmelzer & Lange, Inc.	Shaw Yoder Antwih Schmelzer & Lange, Inc.	Shaw Yoder Antwih Schmelzer & Lange, Inc.	Shaw Yoder Antwih Schmelzer & Lange, Inc.	Shaw Yoder Antwih Schmelzer & Lange, Inc.	Shaw Yoder Antwih Schmelzer & Lange, Inc.	Shaw Yoder Antwih Schmelzer & Lange, Inc.	Shaw Yoder Antwih Schmelzer & Lange, Inc.
firm_city	SACRAMENTO	Los Angeles	Los Angeles	Los Angeles	LOS ANGELES	SACRAMENTO	LOS ANGELES	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	Sacramento	Sacramento	SACRAMENTO	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento
firm_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
firm_zip4	95814	90012	90012	90012	90012	95814	90012	90012	95814	90012	95814	90012	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
firm_phon	9163215500	(213) 978-0617	(213) 978-0617	(213) 978-0617	9163215500	9163215500	9163215500	9163215500	9163215500	9163215500	9164410702	9163215500	(916)441-0702	(916)441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	916 441-0702	(916) 446-4656	(916) 446-4656	(916) 446-4656	916 441-0702	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656	(916) 446-4656
mail_city	None	Sacramento	Sacramento	Sacramento	SACRAMENTO	None	SACRAMENTO	SACRAMENTO	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	CA	CA	CA	CA	None	CA	CA	None	CA	CA	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	95814	95814	95814	95814	None	95814	95814	None	95814	95814	95814	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	(916) 321-5500	(916) 321-5500	(916) 321-5500	None	None	None	None	None	None	9164410702	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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-05-22 00:00:00	2006-01-27 00:00:00	2005-10-31 00:00:00	2005-07-19 00:00:00	2007-04-30 00:00:00	2006-07-28 00:00:00	2006-01-29 00:00:00	2007-07-27 00:00:00	2006-10-30 00:00:00	2007-01-29 00:00:00	2008-02-15 00:00:00	2007-10-31 00:00:00	2008-07-10 00:00:00	2008-04-11 00:00:00	2008-10-15 00:00:00	2009-07-07 00:00:00	2009-04-09 00:00:00	2009-10-08 00:00:00	2009-01-08 00:00:00	2010-10-14 00:00:00	2011-01-17 00:00:00	2010-07-12 00:00:00	2010-01-11 00:00:00	2010-04-12 00:00:00	2011-10-12 00:00:00	2011-07-15 00:00:00	2011-04-12 00:00:00	2012-01-19 00:00:00	2012-07-05 00:00:00	2012-10-16 00:00:00	2012-04-11 00:00:00	2013-01-23 00:00:00	2013-04-16 00:00:00	2013-10-22 00:00:00	2014-01-28 00:00:00	2013-07-22 00:00:00	2013-07-09 00:00:00	2014-10-20 00:00:00	2014-07-26 00:00:00	2014-04-18 00:00:00	2015-01-28 00:00:00	2015-10-23 00:00:00	2015-07-22 00:00:00	2015-04-26 00:00:00	2016-07-22 00:00:00	2016-01-27 00:00:00	2016-04-17 00:00:00	2016-10-24 00:00:00	2017-07-22 00:00:00	2017-04-23 00:00:00	2017-01-24 00:00:00	2017-10-22 00:00:00	2018-01-21 00:00:00	2018-07-25 00:00:00	2018-10-20 00:00:00	2018-04-27 00:00:00	2019-07-20 00:00:00	2019-04-25 00:00:00	2019-01-28 00:00:00	2020-01-18 00:00:00	2020-04-19 00:00:00	2019-10-22 00:00:00	2021-01-17 00:00:00	2021-04-14 00:00:00	2020-10-19 00:00:00	2020-07-25 00:00:00	2022-01-16 00:00:00	2021-10-14 00:00:00	2021-07-14 00:00:00	2022-10-14 00:00:00	2022-04-18 00:00:00	2022-07-15 00:00:00
sig_loc	Sacramento, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	Sacramemento, 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	Solis	Solis	SOLIS	SOLIS	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	Solis	Solis	Solis	SOLIS (427200-SLC)	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis	Solis-Shaw	Solis	Solis	Solis-Shaw	Solis-Shaw	Solis-Shaw
sig_namf	Silvia Y.	Silvia Y	SILVIA Y	SILVIA Y	Silvia Y.	Silvia Y.	Silvia	Silvia Y	Silvia Y.	Silvia Y.	Silvia Y	Silvia Y	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	Silvia Y	Silvia Y	Silvia Y	SILVIA	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y	Silvia Y
sig_namt	None	Ms.	Ms.	Ms.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Ms.	Ms.	Ms.	None	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.
sig_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
prn_naml	None	SOLIS	Solis	Solis	None	None	None	None	None	None	None	None	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS (427200-SLC)	SOLIS	SOLIS	SOLIS	SOLIS (427200-SLC)	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	Solis-Shaw	SOLIS	SOLIS	Solis-Shaw	Solis-Shaw	Solis-Shaw
prn_namf	None	SILVIA Y	Silvia Y	Silvia Y	None	None	None	None	None	None	None	None	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	SILVIA Y	Silvia Y	SILVIA Y	SILVIA Y	Silvia Y	Silvia Y	Silvia Y
prn_namt	None	Ms.	Ms.	Ms.	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Ms.	Ms.	Ms.	None	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.	Ms.
prn_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_title	None	Legislative Representative	Legislative Representative	Legislative Representative	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Legislative Representative	Legislative Representative	Legislative Representative	None	Legislative Representative	Legislative Representative	Legislative Representative	Legislative Representative	Legislative Representative	Legislative Representative	Legislative Representative	Legislative Advocate	Legislative Representative	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate	Legislative Advocate
nopart1_cb	X	X	X	X	None	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X
nopart2_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
part1_1_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
part1_2_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ctrib_n_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_y_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lby_actvty	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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_n_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lobby_y_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_naml	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rcpcmte_nm	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rcpcmte_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: cvr_registration
filing_id	1223074	1316044	1384745	1553633	1719193
amend_id	0	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR
form_type	F604	F604	F604	F604	F604
sender_id	E00581	F00946	F00946	F00946	F00946
filer_id	1276024	1276024	1276024	1276024	1276024
entity_cd	LBY	LBY	LBY	LBY	LBY
filer_naml	SOLIS	SOLIS	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW
filer_namf	SILVIA Y.	SILVIA	SILVIA	SILVIA	SILVIA
filer_namt	None	None	None	None	None
filer_nams	None	None	None	None	None
report_num	000	000	000	000	000
rpt_date	2006-12-06 00:00:00	2008-02-19 00:00:00	2009-01-01 00:00:00	2010-12-06 00:00:00	2012-11-08 00:00:00
ls_beg_yr	2007	2007	2009	2011	2013
ls_end_yr	2008	2008	2010	2012	2014
qual_date	2007-01-01 00:00:00	2008-02-19 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00
eff_date	None	None	None	None	None
bus_city	LOS ANGELES	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
bus_st	CA	CA	CA	CA	CA
bus_zip4	90012	95814	95814	95814	95814
bus_phon	9163215500	916 441-0702	916 441-0702	916 441-0702	916 441-0702
bus_fax	9164487162	None	None	None	None
bus_email	[email protected]	None	None	[email protected]	[email protected]
mail_city	SACRAMENTO	None	None	None	None
mail_st	CA	None	None	None	None
mail_zip4	95814	None	None	None	None
mail_phon	None	None	None	None	None
sig_date	2006-12-06 00:00:00	2008-02-19 00:00:00	2008-12-11 00:00:00	2010-12-06 00:00:00	2012-11-08 00:00:00
sig_loc	None	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA	SACRAMENTO, CA
sig_naml	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS
sig_namf	SILVIA Y.	SILVIA	SILVIA	SILVIA	SILVIA
sig_namt	None	None	None	None	None
sig_nams	None	None	None	None	None
prn_naml	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS
prn_namf	SILVIA Y.	SILVIA	SILVIA	SILVIA	SILVIA
prn_namt	None	None	None	None	None
prn_nams	None	None	None	None	None
sig_title	None	LOBBYIST (427200)SLC	LOBBYIST (427200)SLC	LOBBYIST (427200)SLC	LOBBYIST (427200)SLC
stmt_firm	None	None	None	None	None
ind_cb	None	None	None	None	None
bus_cb	None	None	None	None	None
trade_cb	None	None	None	None	None
oth_cb	None	None	None	None	None
a_b_name	None	None	None	None	None
a_b_city	None	None	None	None	None
a_b_st	None	None	None	None	None
a_b_zip4	None	None	None	None	None
descrip_1	None	None	None	None	None
descrip_2	None	None	None	None	None
c_less50	None	None	None	None	None
c_more50	None	None	None	None	None
ind_class	None	None	None	None	None
ind_descr	None	None	None	None	None
bus_class	None	None	None	None	None
bus_descr	None	None	None	None	None
auth_name	None	None	None	None	None
auth_city	None	None	None	None	None
auth_st	None	None	None	None	None
auth_zip4	None	None	None	None	None
lobby_int	None	None	None	None	None
influen_yn	None	None	None	None	None
firm_name	CITY OF LOS ANGELES	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC	PUBLIC POLICY ADVOCATES, LLC
newcert_cb	None	None	None	None	None
rencert_cb	None	None	None	None	None
complet_dt	2006-11-16 00:00:00	2006-11-16 00:00:00	2008-11-12 00:00:00	2010-11-17 00:00:00	2012-11-08 00:00:00
lby_reg_cb	X	X	X	X	X
lby_604_cb	None	None	None	None	None
st_leg_yn	Y	Y	Y	Y	Y
st_agency	None	None	None	None	None
lobby_cb	None	None	None	None	None
l_firm_cb	None	None	None	None	None

Table: filer_address
filer_id	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024
adrid	2089520	2087033	2113256	2134612	2116930	2133438	2161006	2204438	2411871	2471096	2272056	2509631	2289900	2344741	2551036	2551037
effect_dt	2005-06-17 00:00:00	2005-04-01 00:00:00	2007-01-01 00:00:00	2008-02-19 00:00:00	2007-01-01 00:00:00	2008-02-19 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2013-01-01 00:00:00	2021-01-01 00:00:00	2013-06-10 00:00:00	2015-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00
add_type	7051	7051	7051	7082	7082	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7082
session_id	2005	2005	2007	2007	2007	2007	2009	2011	2017	2019	2013	2021	2013	2015	2023	2023

Table: filer_ethics_class
filer_id	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024
session_id	2007	2005	2009	2011	2013	2015	2019	2017	2021
ethics_date	2006-11-16 00:00:00	2005-06-17 00:00:00	2008-11-12 00:00:00	2010-11-17 00:00:00	2012-11-08 00:00:00	2015-04-09 00:00:00	2019-02-07 00:00:00	2016-11-17 00:00:00	2020-12-03 00:00:00

Table: filer_filings
filer_id	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024
filing_id	1099275	1099277	1112671	1133970	1099275	1145289	1172445	1189333	1215495	1223074	1234184	1229466	1281256	1308367	1262494	1297610	1782042	1771078	1776970	1962194	1867027	1796391	1957724	1949450	1901016	1316160	1328435	1316044	1350755	1328716	1384745	1374688	1397202	1414277	1421614	1447998	1434190	1462490	1482762	1503245	1536679	1553633	1565323	1567958	1604631	1588974	1621432	1634525	1655062	1679241	1814515	1932076	1719193	1708718	1733834	1736834	1839559	1765032	1976216	2203650	2565923	2269672	2432146	2341917	1993530	2008244	2029081	2056282	2123034	2099833	2135987	2152449	2169885	2344533	2309561	2391517	2518173	2377591	2480959	2233665	2574205	2466250	2414473	2369085	2189391	2634718	2667070	2698501	2544815	2615937	2593165	2733771
period_id	None	None	182	183	None	184	185	186	187	188	188	None	190	192	189	191	214	None	214	221	218	215	None	None	219	None	193	193	194	193	197	195	196	None	197	199	198	200	201	202	203	204	None	204	206	205	207	208	209	210	216	220	212	211	None	212	217	213	222	232	None	234	240	236	223	224	225	226	228	227	None	229	230	None	235	238	243	237	242	233	245	241	239	None	231	248	249	250	244	247	246	251
form_id	F604	F999	F615	F615	F604	F615	F615	F615	F615	F604	F615	F604	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F604	F604	F615	F604	F615	F604	F615	F615	F604	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F604	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F604	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615
filing_sequence	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	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	2005-04-05 00:00:00	2005-04-06 00:00:00	2005-07-19 00:00:00	2005-10-31 00:00:00	2005-06-17 00:00:00	2006-01-27 00:00:00	2006-05-22 00:00:00	2006-07-28 00:00:00	2006-10-30 00:00:00	2006-12-06 00:00:00	2007-01-29 00:00:00	2006-12-27 00:00:00	2007-07-26 00:00:00	2008-01-29 00:00:00	2007-04-30 00:00:00	2007-10-31 00:00:00	2013-07-31 00:00:00	2013-06-11 00:00:00	2013-07-22 00:00:00	2015-04-26 00:00:00	2014-07-26 00:00:00	2013-10-22 00:00:00	2015-04-09 00:00:00	2014-12-26 00:00:00	2014-10-20 00:00:00	2008-02-20 00:00:00	2008-04-29 00:00:00	2008-02-20 00:00:00	2008-07-31 00:00:00	2008-04-29 00:00:00	2008-12-22 00:00:00	2008-10-29 00:00:00	2009-02-02 00:00:00	2008-12-23 00:00:00	2009-04-30 00:00:00	2009-10-15 00:00:00	2009-07-28 00:00:00	2010-01-28 00:00:00	2010-04-27 00:00:00	2010-07-26 00:00:00	2010-10-27 00:00:00	2010-12-23 00:00:00	2010-12-30 00:00:00	2011-01-27 00:00:00	2011-07-27 00:00:00	2011-04-27 00:00:00	2011-10-28 00:00:00	2012-01-30 00:00:00	2012-04-26 00:00:00	2012-07-31 00:00:00	2014-01-28 00:00:00	2015-01-28 00:00:00	2012-12-20 00:00:00	2012-10-31 00:00:00	2012-12-27 00:00:00	2013-01-30 00:00:00	2014-04-18 00:00:00	2013-04-30 00:00:00	2015-07-22 00:00:00	2018-01-21 00:00:00	2020-12-18 00:00:00	2018-07-25 00:00:00	2020-01-18 00:00:00	2019-01-28 00:00:00	2015-10-22 00:00:00	2016-01-27 00:00:00	2016-04-17 00:00:00	2016-07-19 00:00:00	2017-01-24 00:00:00	2016-10-28 00:00:00	2016-12-19 00:00:00	2017-04-23 00:00:00	2017-07-22 00:00:00	2018-12-24 00:00:00	2018-10-20 00:00:00	2019-07-20 00:00:00	2020-10-19 00:00:00	2019-04-25 00:00:00	2020-07-25 00:00:00	2018-04-21 00:00:00	2021-04-14 00:00:00	2020-04-19 00:00:00	2019-10-22 00:00:00	2019-03-19 00:00:00	2017-10-22 00:00:00	2022-01-16 00:00:00	2022-04-18 00:00:00	2022-07-15 00:00:00	2021-01-17 00:00:00	2021-10-14 00:00:00	2021-07-14 00:00:00	2022-10-14 00:00:00
stmnt_type	10005	10005	10001	10001	10006	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10006	10005	10001	10005	10001	10001	10001	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	10005	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10006	10001	10001	10001	10001	10001	10001	10001	10001
stmnt_status	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	11003	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	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11003
session_id	2005	2005	2005	2005	2005	2005	2005	2005	2005	2007	2005	2007	2007	2007	2007	2007	2013	2013	2013	2015	2013	2013	2015	2015	2013	2007	2007	2007	2007	2007	2009	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2009	2011	2011	2011	2011	2011	2011	2013	2013	2013	2011	2013	2011	2013	2013	2015	2017	2021	2017	2019	2017	2015	2015	2015	2015	2015	2015	2017	2017	2017	2019	2017	2019	2019	2019	2019	2017	2021	2019	2019	2019	2017	2021	2021	2021	2019	2021	2021	2021
user_id	SARRIAGA	SARRIAGA	LTHIBAUL	LTHIBAUL	CFLAGG	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	SARRIAGA	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	ASAETERN	PBANFORD	ASAETERN	JINGRAM	ASAETERN	ASAETERN	PBANFORD	PBANFORD	ASAETERN	YRODRIGU	YRODRIGU	YRODRIGU	LTHIBAUL	YRODRIGU	*	JINGRAM	JINGRAM	MGUERRA	CFLAGG	CFLAGG	CFLAGG	CFLAGG	JINGRAM	ASAETERN	ASAETERN	PBANFORD	PBANFORD	ASAETERN	ASAETERN	JINGRAM	ASAETERN	AGLADNEY	ASAETERN	AGLADNEY	ASAETERN	AGLADNEY	SARRIAGA	ASAETERN	SARRIAGA	ASAETERN	ASAETERN	ASAETERN	JINGRAM	AGLADNEY	AROJAS	AGLADNEY	VUKSTINA	AGLADNEY	JINGRAM	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	DMCCASTL	SMCCONNAN	SMCCONNAN	SARRIAGA	JFRONEFIELD	VUKSTINA	MKIRKHAM	VUKSTINA	VUKSTINA	AGLADNEY	CHARTRIDGE	VUKSTINA	VUKSTINA	SUSHAKOV	SMCCONNAN	RATTIYEH	CAFILER	CAFILER	MKIRKHAM	GTAYLOR	CHATRIDGE	CAFILER
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	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	11003	11003	11001	11001	11001	11003
rpt_start	1900-01-01 00:00:00	1900-01-01 00:00:00	2005-04-01 00:00:00	2005-07-01 00:00:00	1900-01-01 00:00:00	2005-10-01 00:00:00	2006-01-01 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	2006-12-06 00:00:00	2006-10-01 00:00:00	1900-01-01 00:00:00	2007-04-01 00:00:00	2007-10-01 00:00:00	2007-01-01 00:00:00	2007-07-01 00:00:00	2013-04-01 00:00:00	1900-01-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	1900-01-01 00:00:00	2014-07-01 00:00:00	1900-01-01 00:00:00	2008-02-19 00:00:00	2008-02-19 00:00:00	2008-04-01 00:00:00	2008-01-01 00:00:00	2009-01-01 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-04-01 00:00:00	2009-10-01 00:00:00	2010-01-01 00:00:00	2010-04-01 00:00:00	2010-07-01 00:00:00	2010-12-06 00:00:00	1900-01-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-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	2012-11-08 00:00:00	2012-07-01 00:00:00	1900-01-01 00:00:00	2012-10-01 00:00:00	2014-01-01 00:00:00	2013-01-01 00:00:00	2015-04-01 00:00:00	2017-10-01 00:00:00	1900-01-01 00:00:00	2018-04-01 00:00:00	2019-10-01 00:00:00	2018-10-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	2016-10-01 00:00:00	2016-07-01 00:00:00	1900-01-01 00:00:00	2017-01-01 00:00:00	2017-04-01 00:00:00	1900-01-01 00:00:00	2018-07-01 00:00:00	2019-04-01 00:00:00	2020-07-01 00:00:00	2019-01-01 00:00:00	2020-04-01 00:00:00	2018-01-01 00:00:00	2021-01-01 00:00:00	2020-01-01 00:00:00	2019-07-01 00:00:00	1900-01-01 00:00:00	2017-07-01 00:00:00	2021-10-01 00:00:00	2022-01-01 00:00:00	2022-04-01 00:00:00	2020-10-01 00:00:00	2021-07-01 00:00:00	2021-04-01 00:00:00	2022-07-01 00:00:00
rpt_end	1900-01-01 00:00:00	1900-01-01 00:00:00	2005-06-30 00:00:00	2005-09-30 00:00:00	1900-01-01 00:00:00	2005-12-31 00:00:00	2006-03-31 00:00:00	2006-06-30 00:00:00	2006-09-30 00:00:00	2006-12-06 00:00:00	2006-12-31 00:00:00	1900-01-01 00:00:00	2007-06-30 00:00:00	2007-12-31 00:00:00	2007-03-31 00:00:00	2007-09-30 00:00:00	2013-05-31 00:00:00	1900-01-01 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	1900-01-01 00:00:00	2014-09-30 00:00:00	1900-01-01 00:00:00	2008-03-31 00:00:00	2008-02-19 00:00:00	2008-06-30 00:00:00	2008-03-30 00:00:00	2009-01-01 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-06-30 00:00:00	2009-12-31 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	2010-12-06 00:00:00	1900-01-01 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-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	2012-11-08 00:00:00	2012-09-30 00:00:00	1900-01-01 00:00:00	2012-12-31 00:00:00	2014-03-31 00:00:00	2013-03-31 00:00:00	2015-06-30 00:00:00	2017-12-31 00:00:00	1900-01-01 00:00:00	2018-06-30 00:00:00	2019-12-31 00:00:00	2018-12-31 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	2016-12-31 00:00:00	2016-09-30 00:00:00	1900-01-01 00:00:00	2017-03-31 00:00:00	2017-06-30 00:00:00	1900-01-01 00:00:00	2018-09-30 00:00:00	2019-06-30 00:00:00	2020-09-30 00:00:00	2019-03-31 00:00:00	2020-06-30 00:00:00	2018-03-31 00:00:00	2021-03-31 00:00:00	2020-03-31 00:00:00	2019-09-30 00:00:00	1900-01-01 00:00:00	2017-09-30 00:00:00	2021-12-31 00:00:00	2022-03-31 00:00:00	2022-06-30 00:00:00	2020-12-31 00:00:00	2021-09-30 00:00:00	2021-06-30 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
filing_type	None	None	22001	22001	None	22001	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22001	None	22001	22001	22001	22001	None	None	22001	None	22001	22001	22001	22006	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001

Table: filer_to_filer_type
filer_id	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024
filer_type	4	4	4	4	4	4	4	4	4	4
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	2011	2013	2009	2015	2021	2019	2017	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	2005-04-01 00:00:00	2007-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2009-01-01 00:00:00	2015-01-01 00:00:00	2021-01-01 00:00:00	2019-01-01 00:00:00	2017-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	2005-04-01 00:00:00	2005-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		1276024
xref_id		1276024
effect_dt		2005-04-06 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024
filer_id	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024
filer_type	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST
status	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE
effect_dt	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	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	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS SHAW	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS	SOLIS
namf	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.	SILVIA Y.
namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	LOS ANGELES	SACRAMENTO	LOS ANGELES	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	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	90012	95814	90012	95814	95814	95814	95814	95814	95814	95811	95814	95814	95814	95814	95814	95814	90012	95814	90012	95814	95814	95814	95814	95814	95814	95811	95814	95814	95814	95814	95814	95814	90012	95814	90012	95814	95814	95814	95814	95814	95814	95811	95814	95814	95814	95814	95814	95814	90012	95814	90012	95814	95814	95814	95814	95814	95814	95811	95814	95814	95814	95814	95814	95814	90012	95814	90012	95814	95814	95814	95814	95814	95814	95811	95814	95814	95814	95814	95814	95814	90012	95814	90012	95814	95814	95814	95814	95814	95814	95811	95814	95814	95814	95814	95814	95814	90012	95814	90012	95814	95814	95814	95814	95814	95814	95811	95814	95814	95814	95814	95814	95814	90012	95814	90012	95814	95814	95814	95814	95814	95814	95811	95814	95814	95814	95814	95814	95814	90012	95814	90012	95814	95814	95814	95814	95814	95814	95811	95814	95814	95814	95814	95814	95814	90012	95814	90012	95814	95814	95814	95814	95814	95814	95811	95814	95814	95814	95814	95814	95814
phon	2139780636	9163215500	9163215500		9164410702	9164410702	9164410702	9164410702	9164410702	9164464656	9164464656	9164464656	9164464656	9164464656	9164464656	9164410702	2139780636	9163215500	9163215500		9164410702	9164410702	9164410702	9164410702	9164410702	9164464656	9164464656	9164464656	9164464656	9164464656	9164464656	9164410702	2139780636	9163215500	9163215500		9164410702	9164410702	9164410702	9164410702	9164410702	9164464656	9164464656	9164464656	9164464656	9164464656	9164464656	9164410702	2139780636	9163215500	9163215500		9164410702	9164410702	9164410702	9164410702	9164410702	9164464656	9164464656	9164464656	9164464656	9164464656	9164464656	9164410702	2139780636	9163215500	9163215500		9164410702	9164410702	9164410702	9164410702	9164410702	9164464656	9164464656	9164464656	9164464656	9164464656	9164464656	9164410702	2139780636	9163215500	9163215500		9164410702	9164410702	9164410702	9164410702	9164410702	9164464656	9164464656	9164464656	9164464656	9164464656	9164464656	9164410702	2139780636	9163215500	9163215500		9164410702	9164410702	9164410702	9164410702	9164410702	9164464656	9164464656	9164464656	9164464656	9164464656	9164464656	9164410702	2139780636	9163215500	9163215500		9164410702	9164410702	9164410702	9164410702	9164410702	9164464656	9164464656	9164464656	9164464656	9164464656	9164464656	9164410702	2139780636	9163215500	9163215500		9164410702	9164410702	9164410702	9164410702	9164410702	9164464656	9164464656	9164464656	9164464656	9164464656	9164464656	9164410702	2139780636	9163215500	9163215500		9164410702	9164410702	9164410702	9164410702	9164410702	9164464656	9164464656	9164464656	9164464656	9164464656	9164464656	9164410702
fax	None	9164487162	9164487162							None	None	None	None	None	None		None	9164487162	9164487162							None	None	None	None	None	None		None	9164487162	9164487162							None	None	None	None	None	None		None	9164487162	9164487162							None	None	None	None	None	None		None	9164487162	9164487162							None	None	None	None	None	None		None	9164487162	9164487162							None	None	None	None	None	None		None	9164487162	9164487162							None	None	None	None	None	None		None	9164487162	9164487162							None	None	None	None	None	None		None	9164487162	9164487162							None	None	None	None	None	None		None	9164487162	9164487162							None	None	None	None	None	None
email	None	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	None	None	[email protected]	sylvi@@syaslpartners.com	None	None	None	None	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	None	None	[email protected]	sylvi@@syaslpartners.com	None	None	None	None	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	None	None	[email protected]	sylvi@@syaslpartners.com	None	None	None	None	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	None	None	[email protected]	sylvi@@syaslpartners.com	None	None	None	None	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	None	None	[email protected]	sylvi@@syaslpartners.com	None	None	None	None	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	None	None	[email protected]	sylvi@@syaslpartners.com	None	None	None	None	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	None	None	[email protected]	sylvi@@syaslpartners.com	None	None	None	None	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	None	None	[email protected]	sylvi@@syaslpartners.com	None	None	None	None	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	None	None	[email protected]	sylvi@@syaslpartners.com	None	None	None	None	[email protected]	[email protected]	None	None	None	None	[email protected]	[email protected]	None	None	[email protected]	sylvi@@syaslpartners.com	None	None	None

Table: filers
filer_id		1276024

Table: lobbying_chg_log
filer_id	1276024	1276024	1276024	1276024	1276024
change_no	0	2	1	3	4
session_id	2005	2007	2007	2013	2013
log_dt	2005-04-05 00:00:00	2008-02-20 00:00:00	2008-02-21 00:00:00	2012-12-27 00:00:00	2013-06-11 00:00:00
filer_type	4	4	4	4	4
correction_flg	Y	Y	Y	None	Y
action	ADDED	ADDED	DELETED	DELETED	ADDED
attribute_changed	None	FIRM	EMPLOYER	FIRM	FIRM
ethics_dt	None	None	None	None	None
interests	None	None	None	None	None
filer_full_name	SOLIS, SILVIA Y.	SOLIS, SILVIA Y.	SOLIS, SILVIA Y.	SOLIS SHAW, SILVIA	SOLIS SHAW, SILVIA
filer_city	None	SACRAMENTO	None	None	LOS ANGELES
filer_st	None	CA	None	None	CA
filer_zip	None	95814	None	None	90012
filer_phone	None	9163215500	None	None	2139780636
entity_type	2	3	2	3	3
entity_name	LOS ANGELES, CITY OF	PUBLIC POLICY ADVOCATES, LLC	LOS ANGELES; CITY OF	PUBLIC POLICY ADVOCATES, LLC	SHAW/YODER/ANTWIH, INC.
entity_city	None	None	None	None	None
entity_st	None	None	None	None	None
entity_zip	None	None	None	None	None
entity_phone	None	None	None	None	None
entity_id	1146829	None	1146829	1147315	None
responsible_officer	None	None	None	None	None
effect_dt	2005-04-01 00:00:00	2008-02-19 00:00:00	2008-02-19 00:00:00	2013-05-31 00:00:00	2013-06-10 00:00:00

Table: received_filings
filer_id	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024	1276024
filing_file_name	1112671_0.cal	1133970_0.cal	1145289_0.cal	1503245_0.cal	1397202_0.cal	1350755_0.cal	1462490_0.cal	1482762_0.cal	1447998_0.cal	1223074_0.cal	1434190_0.cal	1421614_0.cal	1374688_0.cal	1384745_0.cal	1328435_0.cal	1316044_0.cal	1736834_0.cal	1679241_0.cal	1839559_0.cal	1782042_0.cal	1796391_0.cal	1553633_0.cal	1536679_0.cal	1588974_0.cal	1567958_0.cal	1814515_0.cal	1604631_0.cal	1776970_0.cal	1765032_0.cal	1621432_0.cal	1634525_0.cal	1708718_0.cal	1719193_0.cal	1655062_0.cal	1867027_0.cal	1976216_0.cal	2123034_0.cal	2152449_0.cal	2056282_0.cal	2008244_0.cal	1993530_0.cal	2099833_0.cal	2029081_0.cal	1901016_0.cal	1932076_0.cal	1962194_0.cal	2169885_0.cal	2203650_0.cal	2269672_0.cal	2341917_0.cal	2480959_0.cal	2309561_0.cal	2414473_0.cal	2377591_0.cal	2233665_0.cal	2391517_0.cal	2466250_0.cal	2432146_0.cal	2189391_0.cal	2634718_0.cal	2667070_0.cal	2698501_0.cal	2593165_0.cal	2733771_0.cal	2518173_0.cal	2574205_0.cal	2544815_0.cal	2615937_0.cal
received_date	2005-07-19 00:00:00	2005-10-31 00:00:00	2006-01-27 00:00:00	2010-07-26 00:00:00	2009-02-02 00:00:00	2008-07-31 00:00:00	2010-01-28 00:00:00	2010-04-27 00:00:00	2009-10-15 00:00:00	2006-12-06 00:00:00	2009-07-28 00:00:00	2009-04-30 00:00:00	2008-10-29 00:00:00	2008-12-22 00:00:00	2008-04-29 00:00:00	2008-02-20 00:00:00	2013-01-30 00:00:00	2012-07-31 00:00:00	2014-04-18 00:00:00	2013-07-31 00:00:00	2013-10-22 00:00:00	2010-12-23 00:00:00	2010-10-27 00:00:00	2011-04-27 00:00:00	2011-01-27 00:00:00	2014-01-28 00:00:00	2011-07-27 00:00:00	2013-07-22 00:00:00	2013-04-30 00:00:00	2011-10-28 00:00:00	2012-01-30 00:00:00	2012-10-31 00:00:00	2012-12-20 00:00:00	2012-04-26 00:00:00	2014-07-26 00:00:00	2015-07-22 00:00:00	2017-01-24 00:00:00	2017-04-23 00:00:00	2016-07-19 00:00:00	2016-01-27 00:00:00	2015-10-22 00:00:00	2016-10-28 00:00:00	2016-04-17 00:00:00	2014-10-20 00:00:00	2015-01-28 00:00:00	2015-04-26 00:00:00	2017-07-22 00:00:00	2018-01-21 00:00:00	2018-07-25 00:00:00	2019-01-28 00:00:00	2020-07-25 00:00:00	2018-10-20 00:00:00	2019-10-22 00:00:00	2019-04-25 00:00:00	2018-04-21 00:00:00	2019-07-20 00:00:00	2020-04-19 00:00:00	2020-01-18 00:00:00	2017-10-22 00:00:00	2022-01-16 00:00:00	2022-04-18 00:00:00	2022-07-15 00:00:00	2021-07-14 00:00:00	2022-10-14 00:00:00	2020-10-19 00:00:00	2021-04-14 00:00:00	2021-01-17 00:00:00	2021-10-14 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/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal
filing_id	1112671	1133970	1145289	1503245	1397202	1350755	1462490	1482762	1447998	1223074	1434190	1421614	1374688	1384745	1328435	1316044	1736834	1679241	1839559	1782042	1796391	1553633	1536679	1588974	1567958	1814515	1604631	1776970	1765032	1621432	1634525	1708718	1719193	1655062	1867027	1976216	2123034	2152449	2056282	2008244	1993530	2099833	2029081	1901016	1932076	1962194	2169885	2203650	2269672	2341917	2480959	2309561	2414473	2377591	2233665	2391517	2466250	2432146	2189391	2634718	2667070	2698501	2593165	2733771	2518173	2574205	2544815	2615937
form_id	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F604	F615	F604	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615
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 accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted