OpenCalAccess

Filer ID: 1297380

Table: cvr_lobby_disclosure
filing_id	1278662	1260516	1328795	1295239	1295239	1295239	1295239	1349783	1307564	1452981	1444152	1376669	1422124	1328795	1349783	1396263	1396263	1506930	1485255	1461780	1567502	1538975	1621970	1607301	1586310	1635414	1709784	1679209	1657881	1765784	1733285	1797561	1777280	1817190	1870565	1844297	1911921	1981287	1997476	1962210	1935706	2062989	2037009	2009752	2102232	2173997	2156907	2124796	2192922	2210970	2275380	2240439	2343208	2319889	2377630	2418351	2399901	2441375	2471488	2487115	2529444	2552588	2603019	2624362	2580513	2676221	2706993	2643124	2748705
amend_id	0	0	0	1	0	2	3	0	0	0	0	0	0	1	1	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
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
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
sender_id	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380
filer_id	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380
entity_cd	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM	FRM
filer_naml	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON
filer_namf	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK	PATRICK	PATRICK K.	PATRICK	PATRICK	PATRICK	PATRICK
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
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
report_num	000	000	000	001	000	002	003	000	000	000	000	000	000	001	001	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
rpt_date	2007-07-20 00:00:00	2007-04-27 00:00:00	2008-04-29 00:00:00	2007-10-29 00:00:00	2007-10-26 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2008-07-30 00:00:00	2008-01-28 00:00:00	2009-11-02 00:00:00	2009-08-30 00:00:00	2008-10-30 00:00:00	2009-04-30 00:00:00	2009-07-15 00:00:00	2009-07-15 00:00:00	2009-07-15 00:00:00	2009-01-30 00:00:00	2010-07-31 00:00:00	2010-04-30 00:00:00	2010-01-27 00:00:00	2011-01-27 00:00:00	2010-10-29 00:00:00	2011-10-31 00:00:00	2011-07-29 00:00:00	2011-04-14 00:00:00	2012-01-30 00:00:00	2012-10-31 00:00:00	2012-07-31 00:00:00	2012-04-30 00:00:00	2013-04-30 00:00:00	2013-01-28 00:00:00	2013-10-27 00:00:00	2013-07-22 00:00:00	2014-01-30 00:00:00	2014-07-30 00:00:00	2014-04-29 00:00:00	2014-10-31 00:00:00	2015-07-30 00:00:00	2015-10-30 00:00:00	2015-04-26 00:00:00	2015-02-01 00:00:00	2016-07-31 00:00:00	2016-04-30 00:00:00	2016-01-28 00:00:00	2016-10-31 00:00:00	2017-07-28 00:00:00	2017-04-30 00:00:00	2017-01-26 00:00:00	2017-10-30 00:00:00	2018-01-31 00:00:00	2018-07-31 00:00:00	2018-04-29 00:00:00	2019-01-29 00:00:00	2018-10-31 00:00:00	2019-04-25 00:00:00	2019-10-30 00:00:00	2019-07-31 00:00:00	2020-01-31 00:00:00	2020-04-30 00:00:00	2020-07-31 00:00:00	2020-10-31 00:00:00	2021-01-31 00:00:00	2021-08-02 00:00:00	2021-11-01 00:00:00	2021-04-30 00:00:00	2022-05-02 00:00:00	2022-08-01 00:00:00	2022-01-31 00:00:00	2022-10-31 00:00:00
from_date	2007-04-01 00:00:00	2007-01-01 00:00:00	2008-01-01 00:00:00	2007-07-01 00:00:00	2007-07-01 00:00:00	2007-07-01 00:00:00	2007-07-01 00:00:00	2008-04-01 00:00:00	2007-10-01 00:00:00	2009-07-01 00:00:00	2009-04-01 00:00:00	2008-07-01 00:00:00	2009-01-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-10-01 00:00:00	2008-10-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	2010-07-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	2013-01-01 00:00:00	2012-10-01 00:00:00	2013-07-01 00:00:00	2013-04-01 00:00:00	2013-10-01 00:00:00	2014-04-01 00:00:00	2014-01-01 00:00:00	2014-07-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	2017-10-01 00:00:00	2018-04-01 00:00:00	2018-01-01 00:00:00	2018-10-01 00:00:00	2018-07-01 00:00:00	2019-01-01 00:00:00	2019-07-01 00:00:00	2019-04-01 00:00:00	2019-10-01 00:00:00	2020-01-01 00:00:00	2020-04-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	2021-04-01 00:00:00	2021-07-01 00:00:00	2021-01-01 00:00:00	2022-01-01 00:00:00	2022-04-01 00:00:00	2021-10-01 00:00:00	2022-07-01 00:00:00
thru_date	2007-06-30 00:00:00	2007-03-31 00:00:00	2008-03-31 00:00:00	2007-09-30 00:00:00	2007-09-30 00:00:00	2007-09-30 00:00:00	2007-09-30 00:00:00	2008-06-30 00:00:00	2007-12-31 00:00:00	2009-09-30 00:00:00	2009-06-30 00:00:00	2008-09-30 00:00:00	2009-03-31 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-12-31 00:00:00	2008-12-31 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	2010-09-30 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	2013-03-31 00:00:00	2012-12-31 00:00:00	2013-09-30 00:00:00	2013-06-30 00:00:00	2013-12-31 00:00:00	2014-06-30 00:00:00	2014-03-31 00:00:00	2014-09-30 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	2017-12-31 00:00:00	2018-06-30 00:00:00	2018-03-31 00:00:00	2018-12-31 00:00:00	2018-09-30 00:00:00	2019-03-31 00:00:00	2019-09-30 00:00:00	2019-06-30 00:00:00	2019-12-31 00:00:00	2020-03-31 00:00:00	2020-06-30 00:00:00	2020-09-30 00:00:00	2020-12-31 00:00:00	2021-06-30 00:00:00	2021-09-30 00:00:00	2021-03-31 00:00:00	2022-03-31 00:00:00	2022-06-30 00:00:00	2021-12-31 00:00:00	2022-09-30 00:00:00
cum_beg_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
firm_id	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380
firm_name	Greenberg Traurig, LLP	Greenberg Traurig, LLP	Government Relations Counsel	Greenberg Traurig, LLP	Greenberg Traurig, LLP	Greenberg Traurig, LLP	Greenberg Traurig, LLP	Government Relations Counsel	Greenberg Traurig, LLP	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	GREENBERG TRAURIG, LLP	Greenberg Traurig, LLP	GREENBERG TRAURIG, LLP	GREENBERG TRAURIG, LLP	Greenberg Traurig, LLP	GREENBERG TRAURIG, LLP	GREENBERG TRAURIG, LLP
firm_city	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	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
firm_zip4	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	95814	95814	95814	95814	95814	95814	95814	95814	95814
firm_phon	9164421111	6502897820	9165031530	9164421111	9164421111	9164421111	9164421111	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9165031530	9168823935	9168823935	9165031530	9168823935	9168823935	9168823935	9168823935	9168823935	9168823935	9168823935	9168823935	9168823935	9168823935	9168823935	9168823935	9168823935	9168823935	9164421111	9164421111	9168823935	9164421111	9164421111	9164421111	9164421111
mail_city	EAST PALO ALTO	EAST PALO ALTO	EAST PALO ALTO	EAST PALO ALTO	EAST PALO ALTO	EAST PALO ALTO	EAST PALO ALTO	EAST PALO ALTO	EAST PALO ALTO	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	CA	CA	CA	CA	CA	CA	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	94303	94303	94303	94303	94303	94303	94303	94303	94303	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
sig_date	2007-07-20 00:00:00	2007-04-27 00:00:00	2008-04-29 00:00:00	2007-10-29 00:00:00	2007-10-26 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2008-07-30 00:00:00	2008-01-28 00:00:00	2009-10-30 00:00:00	2009-08-29 00:00:00	2008-10-30 00:00:00	2009-04-30 00:00:00	2009-07-15 00:00:00	2009-07-15 00:00:00	2009-07-15 00:00:00	2009-01-30 00:00:00	2010-07-31 00:00:00	2010-04-30 00:00:00	2009-01-27 00:00:00	2010-01-30 00:00:00	2010-10-29 00:00:00	2011-10-31 00:00:00	2011-07-29 00:00:00	2011-04-20 00:00:00	2012-01-31 00:00:00	2012-10-31 00:00:00	2012-07-30 00:00:00	2012-04-30 00:00:00	2013-04-30 00:00:00	2013-01-25 00:00:00	2013-10-27 00:00:00	2013-07-21 00:00:00	2014-01-30 00:00:00	2014-07-29 00:00:00	2014-04-28 00:00:00	2014-10-31 00:00:00	2015-07-30 00:00:00	2015-10-30 00:00:00	2015-04-27 00:00:00	2015-01-31 00:00:00	2016-07-31 00:00:00	2016-04-30 00:00:00	2016-01-29 00:00:00	2016-10-31 00:00:00	2017-07-28 00:00:00	2017-04-30 00:00:00	2017-01-25 00:00:00	2017-10-30 00:00:00	2018-01-31 00:00:00	2018-07-31 00:00:00	2018-04-29 00:00:00	2019-01-29 00:00:00	2018-10-31 00:00:00	2019-04-25 00:00:00	2019-10-30 00:00:00	2019-07-31 00:00:00	2020-01-31 00:00:00	2020-04-30 00:00:00	2020-07-31 00:00:00	2020-10-31 00:00:00	2021-01-31 00:00:00	2021-08-02 00:00:00	2021-10-31 00:00:00	2021-04-30 00:00:00	2022-04-30 00:00:00	2022-08-01 00:00:00	2022-01-27 00:00:00	2022-10-28 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	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	Sacramento, CA	SACRAMENTO, CA
sig_naml	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	SHANNON	Shannon	Shannon	Shannon	SHANNON
sig_namf	Patrick K.	Patrick K.	Patrick	Patrick K.	Patrick	Patrick K.	Patrick K.	Patrick	Patrick K.	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	PATRICK	Patrick	Patrick	Patrick	PATRICK
sig_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
prn_naml	None	None	None	None	None	None	None	Shannon	None	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	Shannon	SHANNON	Shannon	Shannon	Shannon	SHANNON
prn_namf	None	None	None	None	None	None	None	Patrick	None	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	Patrick	PATRICK	Patrick	Patrick	Patrick	PATRICK
prn_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
sig_title	None	None	None	None	None	None	None	Owner	None	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Owner	Lobbyist	Lobbyist	LOBBYIST	Lobbyist	Lobbyist	Lobbyist	SHAREHOLDER
nopart1_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
nopart2_cb	None	X	None	None	None	None	None	None	X	None	None	None	None	None	None	None	None	None	None	None	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
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
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
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
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
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
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
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
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
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
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
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
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
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

Table: cvr_registration
filing_id	1302241	1384728	1553997	1720842	1921361	1921361	2119582	2119582	2333763	2333763
amend_id	0	0	0	0	0	1	0	1	0	1
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F604	F604	F604	F604	F604	F604	F604	F604	F604	F604
sender_id	1303078	1303078	1303078	1303078	1303078	1303078	1303078	1303078	1303078	1303078
filer_id	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380
entity_cd	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY
filer_naml	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON
filer_namf	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.
filer_namt	None	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None	None
report_num	000	000	000	000	000	001	000	001	000	001
rpt_date	2008-01-04 00:00:00	2008-12-21 00:00:00	2010-12-24 00:00:00	2012-12-27 00:00:00	2014-12-29 00:00:00	2015-04-20 00:00:00	2017-01-13 00:00:00	2017-05-23 00:00:00	2019-01-10 00:00:00	2019-02-11 00:00:00
ls_beg_yr	2007	2009	2011	2013	2015	2015	2017	2017	2019	2019
ls_end_yr	2008	2010	2012	2014	2016	2016	2018	2018	2020	2020
qual_date	2007-02-05 00:00:00	None	None	2013-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	2019-01-01 00:00:00	2019-01-01 00:00:00
eff_date	None	None	None	None	None	None	None	None	None	None
bus_city	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
bus_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
bus_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
bus_phon	9165301530	9165031530	9165031530	9165031530	9165031530	9165031530	9168823935	9168823935	9168823935	9168823935
bus_fax	None	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428
bus_email	None	None	None	None	None	None	None	None	None	None
mail_city	None	None	None	None	None	None	None	None	None	None
mail_st	None	None	None	None	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None	None	None	None	None
mail_phon	None	None	None	None	None	None	None	None	None	None
sig_date	2008-01-04 00:00:00	2008-12-30 00:00:00	2010-12-24 00:00:00	2012-12-27 00:00:00	2014-12-29 00:00:00	2015-04-09 00:00:00	2017-01-12 00:00:00	2017-05-23 00:00:00	2019-01-10 00:00:00	2019-02-11 00:00:00
sig_loc	None	None	None	None	None	None	None	None	None	None
sig_naml	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON
sig_namf	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.
sig_namt	None	None	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None	None	None
prn_naml	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON
prn_namf	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.
prn_namt	None	None	None	None	None	None	None	None	None	None
prn_nams	None	None	None	None	None	None	None	None	None	None
sig_title	None	None	None	None	None	None	None	None	None	None
stmt_firm	None	None	None	None	None	None	None	None	None	None
ind_cb	None	None	None	None	None	None	None	None	None	None
bus_cb	None	None	None	None	None	None	None	None	None	None
trade_cb	None	None	None	None	None	None	None	None	None	None
oth_cb	None	None	None	None	None	None	None	None	None	None
a_b_name	None	None	None	None	None	None	None	None	None	None
a_b_city	None	None	None	None	None	None	None	None	None	None
a_b_st	None	None	None	None	None	None	None	None	None	None
a_b_zip4	None	None	None	None	None	None	None	None	None	None
descrip_1	None	None	None	None	None	None	None	None	None	None
descrip_2	None	None	None	None	None	None	None	None	None	None
c_less50	None	None	None	None	None	None	None	None	None	None
c_more50	None	None	None	None	None	None	None	None	None	None
ind_class	None	None	None	None	None	None	None	None	None	None
ind_descr	None	None	None	None	None	None	None	None	None	None
bus_class	None	None	None	None	None	None	None	None	None	None
bus_descr	None	None	None	None	None	None	None	None	None	None
auth_name	None	None	None	None	None	None	None	None	None	None
auth_city	None	None	None	None	None	None	None	None	None	None
auth_st	None	None	None	None	None	None	None	None	None	None
auth_zip4	None	None	None	None	None	None	None	None	None	None
lobby_int	None	None	None	None	None	None	None	None	None	None
influen_yn	None	None	None	None	None	None	None	None	None	None
firm_name	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel	Government Relations Counsel
newcert_cb	None	None	None	None	None	None	None	None	None	None
rencert_cb	None	X	X	X	X	None	X	None	X	None
complet_dt	2007-04-19 00:00:00	None	None	None	None	2015-04-09 00:00:00	None	2017-05-16 00:00:00	None	2019-02-07 00:00:00
lby_reg_cb	X	X	X	X	X	X	X	X	X	X
lby_604_cb	None	None	None	None	None	None	None	None	None	None
st_leg_yn	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y
st_agency	None	None	None	None	None	None	None	None	None	None
lobby_cb	None	None	None	None	None	None	None	None	None	None
l_firm_cb	None	None	None	None	None	None	None	None	None	None

Table: filer_address
filer_id	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380
adrid	2122275	2131863	2160953	2204368	2411790	2469978	2277298	2547254	2342674	2517870
effect_dt	2007-02-05 00:00:00	2008-01-04 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	2023-01-01 00:00:00	2015-01-01 00:00:00	2021-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	2007	2007	2009	2011	2017	2019	2013	2023	2015	2021

Table: filer_ethics_class
filer_id	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380
session_id	2007	2009	2011	2013	2015	2017	2019	2021
ethics_date	2007-04-19 00:00:00	2009-02-19 00:00:00	2011-02-24 00:00:00	2013-05-16 00:00:00	2015-04-09 00:00:00	2017-05-16 00:00:00	2019-02-07 00:00:00	2021-01-28 00:00:00

Table: filer_filings
filer_id	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380
filing_id	1260516	1257152	1257154	1278662	1265523	1307564	1295239	1295239	1295239	1768952	1981287	1962210	1870565	1797561	1777280	1921361	1935706	1957520	1942686	1911921	1328795	1302241	1302653	1295239	1349783	1376669	1384728	1412065	1412071	1396263	1422124	1396263	1328795	1349783	1444152	1452981	1485255	1461780	1506930	1538975	1555076	1553997	1567502	1579404	1586310	1621970	1635414	1607301	1657881	1679209	1817190	1921361	1720842	1709784	1733285	1844297	1728071	1765784	2210970	2343208	2487115	2319889	2382934	2418351	2333763	2192922	2275380	1997476	2009752	2037009	2062989	2102232	2119582	2124796	2132899	2156907	2162168	2399901	2173997	2119582	2377630	2363783	2441375	2471488	2240439	2333763	2580513	2603019	2529444	2552588	2591136	2643124	2706993	2582748	2676221	2624362	2748705
period_id	189	None	None	190	None	192	191	191	191	None	222	221	218	215	214	222	220	None	None	219	193	193	None	191	194	195	196	None	None	196	197	196	193	194	198	199	201	200	202	203	None	204	204	None	205	207	208	206	209	210	216	220	212	211	212	217	None	213	232	236	242	235	None	239	237	231	234	223	224	225	226	227	229	228	None	229	None	238	230	230	237	None	240	241	233	237	245	246	243	244	None	248	250	None	249	247	251
form_id	F615	F604	F999	F615	F604	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F604	F615	F604	F604	F615	F615	F604	F604	F615	F615	F615	F604	F604	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F604	F615	F604	F615	F615	F615	F615	F615	F615	F615	F604	F604	F615	F615	F615	F604	F615	F615	F615	F615	F615	F604	F615	F604	F615	F615	F615	F615	F615	F615	F615	F604	F615	F604	F615	F604	F615	F615	F604	F615	F604	F615	F615	F615	F604	F615	F615	F615	F615	F604	F615	F615	F604	F615	F615	F615
filing_sequence	0	0	0	0	0	0	1	2	3	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	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	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
filing_date	2007-04-27 00:00:00	2007-02-13 00:00:00	2007-04-17 00:00:00	2007-07-20 00:00:00	2007-04-19 00:00:00	2008-01-28 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2007-10-29 00:00:00	2013-05-16 00:00:00	2015-07-30 00:00:00	2015-04-26 00:00:00	2014-07-30 00:00:00	2013-10-27 00:00:00	2013-07-22 00:00:00	2015-04-20 00:00:00	2015-02-01 00:00:00	2015-04-09 00:00:00	2014-12-31 00:00:00	2014-10-31 00:00:00	2008-04-29 00:00:00	2008-01-04 00:00:00	2008-01-07 00:00:00	2007-10-26 00:00:00	2008-07-30 00:00:00	2008-10-30 00:00:00	2008-12-21 00:00:00	2009-01-02 00:00:00	2009-02-19 00:00:00	2009-01-30 00:00:00	2009-04-30 00:00:00	2009-07-15 00:00:00	2009-07-15 00:00:00	2009-07-15 00:00:00	2009-08-30 00:00:00	2009-11-02 00:00:00	2010-04-30 00:00:00	2010-01-27 00:00:00	2010-07-31 00:00:00	2010-10-29 00:00:00	2010-12-28 00:00:00	2010-12-24 00:00:00	2011-01-27 00:00:00	2011-02-24 00:00:00	2011-04-14 00:00:00	2011-10-31 00:00:00	2012-01-30 00:00:00	2011-07-29 00:00:00	2012-04-30 00:00:00	2012-07-31 00:00:00	2014-01-30 00:00:00	2014-12-29 00:00:00	2012-12-27 00:00:00	2012-10-31 00:00:00	2013-01-28 00:00:00	2014-04-29 00:00:00	2012-12-31 00:00:00	2013-04-30 00:00:00	2018-01-31 00:00:00	2019-01-29 00:00:00	2020-07-31 00:00:00	2018-10-31 00:00:00	2019-02-19 00:00:00	2019-10-30 00:00:00	2019-02-11 00:00:00	2017-10-30 00:00:00	2018-07-31 00:00:00	2015-10-30 00:00:00	2016-01-28 00:00:00	2016-04-30 00:00:00	2016-07-31 00:00:00	2016-10-31 00:00:00	2017-01-13 00:00:00	2017-01-26 00:00:00	2017-01-17 00:00:00	2017-04-30 00:00:00	2017-05-26 00:00:00	2019-07-31 00:00:00	2017-07-28 00:00:00	2017-05-23 00:00:00	2019-04-25 00:00:00	2019-01-10 00:00:00	2020-01-31 00:00:00	2020-04-30 00:00:00	2018-04-29 00:00:00	2019-01-10 00:00:00	2021-04-30 00:00:00	2021-08-02 00:00:00	2020-10-31 00:00:00	2021-01-31 00:00:00	2021-03-08 00:00:00	2022-01-31 00:00:00	2022-08-01 00:00:00	2021-01-04 00:00:00	2022-05-02 00:00:00	2021-11-01 00:00:00	2022-10-31 00:00:00
stmnt_type	10001	10005	10005	10001	10006	10001	10002	10002	10002	10006	10001	10001	10001	10001	10001	10002	10001	10006	10005	10001	10001	10001	10005	10001	10001	10001	10001	10005	10006	10001	10001	10002	10002	10002	10001	10001	10001	10001	10001	10001	10005	10001	10001	10006	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10006	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10006	10001	10001	10002	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10005	10001	10001	10001
stmnt_status	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	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	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	11003	11001	11003	11001	11003
session_id	2007	2007	2007	2007	2007	2007	2007	2007	2007	2013	2015	2015	2013	2013	2013	2015	2013	2015	2015	2013	2007	2007	2007	2007	2007	2007	2009	2009	2009	2007	2009	2007	2007	2007	2009	2009	2009	2009	2009	2009	2011	2011	2009	2011	2011	2011	2011	2011	2011	2011	2013	2015	2013	2011	2011	2013	2013	2013	2017	2017	2019	2017	2019	2019	2019	2017	2017	2015	2015	2015	2015	2015	2017	2015	2017	2017	2017	2019	2017	2017	2019	2019	2019	2019	2017	2019	2021	2021	2019	2019	2021	2021	2021	2021	2021	2021	2021
user_id	YRODRIGU	SARRIAGA	SARRIAGA	LTHIBAUL	SARRIAGA	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	PBANFORD	JINGRAM	JINGRAM	ASAETERN	ASAETERN	ASAETERN	PBANFORD	AGLADNEY	PBANFORD	GPEREZ	ASAETERN	LTHIBAUL	*	SARRIAGA	LTHIBAUL	JINGRAM	JINGRAM	*	MGUERRA	MGUERRA	JINGRAM	JINGRAM	JINGRAM	JINGRAM	JINGRAM	JINGRAM	JINGRAM	JINGRAM	JINGRAM	ASAETERN	ASAETERN	SARRIAGA	*	ASAETERN	SMCCONNAN	JINGRAM	ASAETERN	ASAETERN	ASAETERN	ASAETERN	AGLADNEY	ASAETERN	CAFILER	PBANFORD	ASAETERN	ASAETERN	ASAETERN	PBANFORD	ASAETERN	AGLADNEY	AGLADNEY	MMERCHANT	JFRONEFIELD	SUSHAKOV	AROJAS	GPEREZ	SMCCONNAN	AGLADNEY	JINGRAM	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	GPEREZ	AGLADNEY	SARRIAGA	SMCCONNAN	PBANFORD	VUKSTINA	SMCCONNAN	PBANFORD	VUKSTINA	GPEREZ	VUKSTINA	VUKSTINA	AGLADNEY	GPEREZ	CHARTRIDGE	CHATRIDGE	MKIRKHAM	JRAMOS	CVANLIEW	GTAYLOR	CAFILER	MKIRKHAM	CAFILER	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	11003	11003	11003	11003	11003
fine_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11003	11003	11003	11001	11001	11003	11003	11003	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	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	11003	11001	11003	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11003	11001	11003	11003	11003	11001	11003
rpt_start	2007-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-04-01 00:00:00	1900-01-01 00:00:00	2007-10-01 00:00:00	2007-07-01 00:00:00	2007-07-01 00:00:00	2007-07-01 00:00:00	1900-01-01 00:00:00	2015-04-01 00:00:00	2015-01-01 00:00:00	2014-04-01 00:00:00	2013-07-01 00:00:00	2013-04-01 00:00:00	2015-04-20 00:00:00	2014-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-07-01 00:00:00	2008-01-01 00:00:00	2008-01-04 00:00:00	1900-01-01 00:00:00	2007-07-01 00:00:00	2008-04-01 00:00:00	2008-07-01 00:00:00	2008-12-21 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2008-10-01 00:00:00	2009-01-01 00:00:00	2008-10-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2009-04-01 00:00:00	2009-07-01 00:00:00	2010-01-01 00:00:00	2009-10-01 00:00:00	2010-04-01 00:00:00	2010-07-01 00:00:00	1900-01-01 00:00:00	2010-12-24 00:00:00	2010-10-01 00:00:00	1900-01-01 00:00:00	2011-01-01 00:00:00	2011-07-01 00:00:00	2011-10-01 00:00:00	2011-04-01 00:00:00	2012-01-01 00:00:00	2012-04-01 00:00:00	2013-10-01 00:00:00	2014-12-29 00:00:00	2012-12-27 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	2017-10-01 00:00:00	2018-10-01 00:00:00	2020-04-01 00:00:00	2018-07-01 00:00:00	1900-01-01 00:00:00	2019-07-01 00:00:00	2019-02-11 00:00:00	2017-07-01 00:00:00	2018-04-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-07-01 00:00:00	2017-01-13 00:00:00	2016-10-01 00:00:00	1900-01-01 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	2019-04-01 00:00:00	2017-04-01 00:00:00	2017-05-23 00:00:00	2019-01-01 00:00:00	1900-01-01 00:00:00	2019-10-01 00:00:00	2020-01-01 00:00:00	2018-01-01 00:00:00	2019-01-10 00:00:00	2021-01-01 00:00:00	2021-04-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	1900-01-01 00:00:00	2021-10-01 00:00:00	2022-04-01 00:00:00	1900-01-01 00:00:00	2022-01-01 00:00:00	2021-07-01 00:00:00	2022-07-01 00:00:00
rpt_end	2007-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-06-30 00:00:00	1900-01-01 00:00:00	2007-12-31 00:00:00	2007-09-30 00:00:00	2007-09-30 00:00:00	2007-09-30 00:00:00	1900-01-01 00:00:00	2015-06-30 00:00:00	2015-03-31 00:00:00	2014-06-30 00:00:00	2013-09-30 00:00:00	2013-06-30 00:00:00	2015-04-20 00:00:00	2014-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-09-30 00:00:00	2008-03-31 00:00:00	2008-01-04 00:00:00	1900-01-01 00:00:00	2007-09-30 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2008-12-21 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2008-12-31 00:00:00	2009-03-31 00:00:00	2008-12-31 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2009-06-30 00:00:00	2009-09-30 00:00:00	2010-03-31 00:00:00	2009-12-31 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	1900-01-01 00:00:00	2010-12-24 00:00:00	2010-12-31 00:00:00	1900-01-01 00:00:00	2011-03-31 00:00:00	2011-09-30 00:00:00	2011-12-31 00:00:00	2011-06-30 00:00:00	2012-03-31 00:00:00	2012-06-30 00:00:00	2013-12-31 00:00:00	2014-12-29 00:00:00	2012-12-27 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	2017-12-31 00:00:00	2018-12-31 00:00:00	2020-06-30 00:00:00	2018-09-30 00:00:00	1900-01-01 00:00:00	2019-09-30 00:00:00	2019-02-11 00:00:00	2017-09-30 00:00:00	2018-06-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	2016-09-30 00:00:00	2017-01-13 00:00:00	2016-12-31 00:00:00	1900-01-01 00:00:00	2017-03-31 00:00:00	1900-01-01 00:00:00	2019-06-30 00:00:00	2017-06-30 00:00:00	2017-05-23 00:00:00	2019-03-31 00:00:00	1900-01-01 00:00:00	2019-12-31 00:00:00	2020-03-31 00:00:00	2018-03-31 00:00:00	2019-01-10 00:00:00	2021-03-31 00:00:00	2021-06-30 00:00:00	2020-09-30 00:00:00	2020-12-31 00:00:00	1900-01-01 00:00:00	2021-12-31 00:00:00	2022-06-30 00:00:00	1900-01-01 00:00:00	2022-03-31 00:00:00	2021-09-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	None	None	None	None	None
filing_type	22006	None	None	22006	None	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	None	None	22006	22006	22006	None	22006	22006	22006	22006	None	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	None	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	None	22006	22006	22006

Table: filer_to_filer_type
filer_id	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380
filer_type	4	4	4	4	4	4	4	4	4	4	4
active	Y	Y	T	Y	Y	Y	Y	Y	Y	Y	N
race	0	0	0	None	None	None	None	None	None	None	None
session_id	2007	2007	2007	2011	2013	2009	2015	2019	2017	2021	2023
category	0	0	0	None	None	None	None	None	None	None	None
category_type	0	0	0	None	None	None	None	None	None	None	None
sub_category	0	0	0	None	None	None	None	None	None	None	None
effect_dt	2008-01-04 00:00:00	2007-02-05 00:00:00	2007-12-31 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	2019-01-01 00:00:00	2017-01-01 00:00:00	2021-01-01 00:00:00	2023-01-01 00:00:00
sub_category_type	0	0	0	None	None	None	None	None	None	None	None
election_type	0	0	0	None	None	None	None	None	None	None	None
sub_category_a	None	None	None	None	None	None	None	None	None	None	None
nyq_dt	None	None	None	None	None	None	None	None	None	None	None
party_cd	0	0	0	None	None	None	None	None	None	None	None
county_cd	0	0	0	None	None	None	None	None	None	None	None
district_cd	0	0	0	None	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1297380
xref_id		1297380
effect_dt		2007-04-17 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380
filer_id	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380
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
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
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
naml	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON	SHANNON
namf	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.	PATRICK K.
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
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
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
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
city	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	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
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
zip4	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	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
phon	9164421111	9165031530	9165031530	9165031530	9165031530	9165031530	9168823935	9168823935	9164421111	9164421111	9164421111	9165031530	9165031530	9165031530	9165031530	9165031530	9168823935	9168823935	9164421111	9164421111	9164421111	9165031530	9165031530	9165031530	9165031530	9165031530	9168823935	9168823935	9164421111	9164421111	9164421111	9165031530	9165031530	9165031530	9165031530	9165031530	9168823935	9168823935	9164421111	9164421111	9164421111	9165031530	9165031530	9165031530	9165031530	9165031530	9168823935	9168823935	9164421111	9164421111	9164421111	9165031530	9165031530	9165031530	9165031530	9165031530	9168823935	9168823935	9164421111	9164421111	9164421111	9165031530	9165031530	9165031530	9165031530	9165031530	9168823935	9168823935	9164421111	9164421111	9164421111	9165031530	9165031530	9165031530	9165031530	9165031530	9168823935	9168823935	9164421111	9164421111	9164421111	9165031530	9165031530	9165031530	9165031530	9165031530	9168823935	9168823935	9164421111	9164421111
fax	None	None	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428			None	None	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428			None	None	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428			None	None	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428			None	None	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428			None	None	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428			None	None	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428			None	None	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428			None	None	9162099428	9162099428	9162099428	9162099428	9162099428	9162099428
email	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]

Table: filers
filer_id		1297380

Table: lobbying_chg_log
filer_id	1297380	1297380	1297380
change_no	1	0	2
session_id	2007	2007	2007
log_dt	2008-01-03 00:00:00	2007-02-13 00:00:00	2008-01-07 00:00:00
filer_type	4	4	4
correction_flg	Y	Y	Y
action	DELETED	ADDED	ADDED
attribute_changed	FIRM	FIRM	FIRM
ethics_dt	None	None	None
interests	None	None	None
filer_full_name	SHANNON, PATRICK K.	SHANNON, PATRICK K.	SHANNON, PATRICK K.
filer_city	None	None	EAST PALO ALTO
filer_st	None	None	CA
filer_zip	None	None	94303
filer_phone	None	None
entity_type	3	3	3
entity_name	GREENBERG TRAURIG, LLP	GREENBERG TRAURIG, LLP	GOVERNMENT RELATIONS COUNSEL
entity_city	None	None	None
entity_st	None	None	None
entity_zip	None	None	None
entity_phone	None	None	None
entity_id	1276988	1276988	None
responsible_officer	None	None	None
effect_dt	2007-12-31 00:00:00	2006-02-05 00:00:00	2008-01-04 00:00:00

Table: received_filings
filer_id	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380	1297380
filing_file_name	1302241_0.cal	1384728_0.cal	1553997_0.cal	1720842_0.cal	2119582_0.cal	1921361_0.cal	210782.cal	210848.cal	211910.cal	1921361_1.cal	285169.cal	285293.cal	285369.cal	285335.cal	285498.cal	285624.cal	285690.cal	2119582_1.cal	2333763_1.cal	2333763_0.cal
received_date	2008-01-04 00:00:00	2008-12-21 00:00:00	2010-12-24 00:00:00	2012-12-27 00:00:00	2017-01-13 00:00:00	2014-12-29 00:00:00	2015-04-20 00:00:00	2015-04-20 00:00:00	2015-04-20 00:00:00	2015-04-20 00:00:00	2017-05-23 00:00:00	2017-05-23 00:00:00	2017-05-23 00:00:00	2017-05-23 00:00:00	2017-05-23 00:00:00	2017-05-23 00:00:00	2017-05-23 00:00:00	2017-05-23 00:00:00	2019-02-11 00:00:00	2019-01-10 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/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal
filing_id	1302241	1384728	1553997	1720842	2119582	1921361	None	None	None	1921361	None	None	None	None	None	None	None	2119582	2333763	2333763
form_id	F604	F604	F604	F604	F604	F604	None	None	None	F604	None	None	None	None	None	None	None	F604	F604	F604
receive_comment	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted