OpenCalAccess

Filer ID: 1281540

Table: cvr_lobby_disclosure
filing_id	1165200	1147653	1188495	1210379	1278106	1259972	1229608	1366592	1346043	1297412	1328116	1307890	1420929	1449327	1431885	1398342	1530048	1504039	1480585	1465437	1563312	1619692	1604094	1588083	1632398	1699690	1676804	1654428	1737029	1798009	1779904	1763571	1841111	1812025	1902185	1869251	1931876	1992660	1980715	1963722	2005012	2062488	2036033	2100207	2171212	2155653	2125348	2191209	2204095	2241257	2269303	2381179	2397162	2346191	2319658	2418481	2469173	2440974	2531032	2551245	2483176	2623019	2601712	2580182	2705733	2674878	2642095	2746288
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
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
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
sender_id	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200
filer_id	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540
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	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	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT
filer_namf	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.
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
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
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
rpt_date	2006-04-26 00:00:00	2006-01-31 00:00:00	2006-07-27 00:00:00	2006-10-24 00:00:00	2007-07-18 00:00:00	2007-04-26 00:00:00	2007-01-22 00:00:00	2008-10-16 00:00:00	2008-07-25 00:00:00	2007-10-31 00:00:00	2008-04-29 00:00:00	2008-01-29 00:00:00	2009-04-30 00:00:00	2009-10-23 00:00:00	2009-07-20 00:00:00	2009-02-02 00:00:00	2010-10-20 00:00:00	2010-07-28 00:00:00	2010-04-19 00:00:00	2010-02-01 00:00:00	2011-01-21 00:00:00	2011-10-26 00:00:00	2011-07-27 00:00:00	2011-04-25 00:00:00	2012-01-26 00:00:00	2012-10-18 00:00:00	2012-07-30 00:00:00	2012-04-25 00:00:00	2013-01-30 00:00:00	2013-10-28 00:00:00	2013-07-29 00:00:00	2013-04-29 00:00:00	2014-04-24 00:00:00	2014-01-23 00:00:00	2014-10-22 00:00:00	2014-07-30 00:00:00	2015-01-28 00:00:00	2015-10-09 00:00:00	2015-07-20 00:00:00	2015-04-10 00:00:00	2016-01-12 00:00:00	2016-07-29 00:00:00	2016-04-29 00:00:00	2016-10-29 00:00:00	2017-07-25 00:00:00	2017-04-28 00:00:00	2017-01-27 00:00:00	2017-10-27 00:00:00	2018-01-22 00:00:00	2018-04-30 00:00:00	2018-07-25 00:00:00	2019-04-29 00:00:00	2019-07-26 00:00:00	2019-01-28 00:00:00	2018-10-30 00:00:00	2019-10-30 00:00:00	2020-04-29 00:00:00	2020-01-29 00:00:00	2020-11-02 00:00:00	2021-01-29 00:00:00	2020-07-30 00:00:00	2021-10-29 00:00:00	2021-07-30 00:00:00	2021-04-30 00:00:00	2022-07-29 00:00:00	2022-04-29 00:00:00	2022-01-29 00:00:00	2022-07-29 00:00:00
from_date	2006-01-01 00:00:00	2005-11-07 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	2007-04-01 00:00:00	2007-01-01 00:00:00	2006-10-01 00:00:00	2008-07-01 00:00:00	2008-04-01 00:00:00	2007-07-01 00:00:00	2008-01-01 00:00:00	2007-10-01 00:00:00	2009-01-01 00:00:00	2009-07-01 00:00:00	2009-04-01 00:00:00	2008-10-01 00:00:00	2010-07-01 00:00:00	2010-04-01 00:00:00	2010-01-01 00:00:00	2009-10-01 00:00:00	2010-10-01 00:00:00	2011-07-01 00:00:00	2011-04-01 00:00:00	2011-01-01 00:00:00	2011-10-01 00:00:00	2012-07-01 00:00:00	2012-04-01 00:00:00	2012-01-01 00:00:00	2012-10-01 00:00:00	2013-07-01 00:00:00	2013-04-01 00:00:00	2013-01-01 00:00:00	2014-01-01 00:00:00	2013-10-01 00:00:00	2014-07-01 00:00:00	2014-04-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	2015-10-01 00:00:00	2016-04-01 00:00:00	2016-01-01 00:00:00	2016-07-01 00:00:00	2017-04-01 00:00:00	2017-01-01 00:00:00	2016-10-01 00:00:00	2017-07-01 00:00:00	2017-10-01 00:00:00	2018-01-01 00:00:00	2018-04-01 00:00:00	2019-01-01 00:00:00	2019-04-01 00:00:00	2018-10-01 00:00:00	2018-07-01 00:00:00	2019-07-01 00:00:00	2020-01-01 00:00:00	2019-10-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	2020-04-01 00:00:00	2021-07-01 00:00:00	2021-04-01 00:00:00	2021-01-01 00:00:00	2022-04-01 00:00:00	2022-01-01 00:00:00	2021-10-01 00:00:00	2022-07-01 00:00:00
thru_date	2006-03-31 00:00:00	2005-12-31 00:00:00	2006-06-30 00:00:00	2006-09-30 00:00:00	2007-06-30 00:00:00	2007-03-31 00:00:00	2006-12-31 00:00:00	2008-09-30 00:00:00	2008-06-30 00:00:00	2007-09-30 00:00:00	2008-03-31 00:00:00	2007-12-31 00:00:00	2009-03-31 00:00:00	2009-09-30 00:00:00	2009-06-30 00:00:00	2008-12-31 00:00:00	2010-09-30 00:00:00	2010-06-30 00:00:00	2010-03-31 00:00:00	2009-12-31 00:00:00	2010-12-31 00:00:00	2011-09-30 00:00:00	2011-06-30 00:00:00	2011-03-31 00:00:00	2011-12-31 00:00:00	2012-09-30 00:00:00	2012-06-30 00:00:00	2012-03-31 00:00:00	2012-12-31 00:00:00	2013-09-30 00:00:00	2013-06-30 00:00:00	2013-03-31 00:00:00	2014-03-31 00:00:00	2013-12-31 00:00:00	2014-09-30 00:00:00	2014-06-30 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	2015-12-31 00:00:00	2016-06-30 00:00:00	2016-03-31 00:00:00	2016-09-30 00:00:00	2017-06-30 00:00:00	2017-03-31 00:00:00	2016-12-31 00:00:00	2017-09-30 00:00:00	2017-12-31 00:00:00	2018-03-31 00:00:00	2018-06-30 00:00:00	2019-03-31 00:00:00	2019-06-30 00:00:00	2018-12-31 00:00:00	2018-09-30 00:00:00	2019-09-30 00:00:00	2020-03-31 00:00:00	2019-12-31 00:00:00	2020-09-30 00:00:00	2020-12-31 00:00:00	2020-06-30 00:00:00	2021-09-30 00:00:00	2021-06-30 00:00:00	2021-03-31 00:00:00	2022-06-30 00:00:00	2022-03-31 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
firm_id	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200	1369200
firm_name	CARPI & CLAY, INC.	CARPI & CLAY, INC.	CARPI & CLAY, INC.	CARPI & CLAY, INC.	CARPI & CLAY INC	CARPI & CLAY, INC.	CARPI & CLAY INC	CARPI & CLAY, INC.	CARPI & CLAY, INC.	CARPI & CLAY, INC.	CARPI & CLAY, INC.	CARPI & CLAY, INC.	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	JGC GOVERNMENT RELATIONS INC	JGC GOVERNMENT RELATIONS, INC.	JGC GOVERNMENT RELATIONS, INC.	JGC GOVERNMENT RELATIONS, INC.	JGC GOVERNMENT RELATIONS, INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.
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
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
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
firm_phon	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	(916) 441-0202	(916) 441-0202	(916) 441-0202	(916) 441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202	916-441-0202
mail_city	None	None	None	None	None	None	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	None
mail_st	None	None	None	None	None	None	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	None
mail_zip4	None	None	None	None	None	None	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	None
mail_phon	None	None	None	None	None	None	9164410202	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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-04-18 00:00:00	2006-01-17 00:00:00	2006-07-12 00:00:00	2006-10-12 00:00:00	2007-07-18 00:00:00	2007-04-24 00:00:00	2007-01-16 00:00:00	2008-10-16 00:00:00	2008-07-22 00:00:00	2007-10-16 00:00:00	2008-04-23 00:00:00	2008-01-22 00:00:00	2009-04-20 00:00:00	2009-10-19 00:00:00	2009-07-20 00:00:00	2009-01-29 00:00:00	2010-10-20 00:00:00	2010-07-26 00:00:00	2010-04-15 00:00:00	2010-01-27 00:00:00	2011-01-21 00:00:00	2011-10-25 00:00:00	2011-07-25 00:00:00	2011-04-25 00:00:00	2012-01-26 00:00:00	2012-10-18 00:00:00	2012-07-25 00:00:00	2012-04-24 00:00:00	2013-01-28 00:00:00	2013-10-24 00:00:00	2013-07-25 00:00:00	2013-04-24 00:00:00	2014-04-24 00:00:00	2014-01-22 00:00:00	2014-10-16 00:00:00	2014-07-28 00:00:00	2015-01-26 00:00:00	2015-10-09 00:00:00	2015-07-20 00:00:00	2015-04-10 00:00:00	2016-01-12 00:00:00	2016-07-14 00:00:00	2016-04-18 00:00:00	2016-10-13 00:00:00	2017-07-13 00:00:00	2017-04-21 00:00:00	2017-01-18 00:00:00	2017-10-16 00:00:00	2018-01-19 00:00:00	2018-04-18 00:00:00	2018-07-18 00:00:00	2019-04-25 00:00:00	2019-07-18 00:00:00	2019-01-22 00:00:00	2018-10-15 00:00:00	2019-10-09 00:00:00	2020-04-14 00:00:00	2020-01-24 00:00:00	2020-10-27 00:00:00	2021-01-19 00:00:00	2020-07-21 00:00:00	2021-10-20 00:00:00	2021-07-16 00:00:00	2021-04-19 00:00:00	2022-07-14 00:00:00	2022-04-12 00:00:00	2022-01-19 00:00:00	2022-10-14 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	SACRAMETNO, 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	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT 462400SSB	GILBERT 462400SSB	GILBERT 462400SSB	GILBERT 462400SSB	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert	Gilbert
sig_namf	ERIN	ERIN	ERIN	ERIN	ERIN E	ERIN	ERIN	ERIN	ERIN E	ERIN	ERIN	ERIN	ERIN E	ERIN E	ERIN E	ERIN	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E.	ERIN E.	ERIN E.	ERIN E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.	Erin E.
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
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
prn_naml	None	None	None	None	None	None	None	GILBERT	None	None	None	None	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT 462400SSB	GILBERT 462400SSB	GILBERT 462400SSB	GILBERT 462400SSB	None	None	None	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_namf	None	None	None	None	None	None	None	ERIN	None	None	None	None	ERIN E	ERIN E	ERIN E	ERIN	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E	ERIN E.	ERIN E.	ERIN E.	ERIN E.	None	None	None	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_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
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
sig_title	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	LOBBYIST	LOBBYIST	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Table: cvr_registration
filing_id	1251502	1383032	1550802	1550802	1716928	1919990	2116897	2331371	2541707
amend_id	0	0	0	1	0	0	0	0	0
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F604	F604	F604	F604	F604	F604	F604	F604	F604
sender_id	F00067	F00067	F00067	F00067	F00067	1369200	1369200	1369200	1369200
filer_id	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540
entity_cd	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY
filer_naml	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT
filer_namf	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.
filer_namt	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None
report_num	000	000	000	001	000	000	000	000	000
rpt_date	2007-03-09 00:00:00	2008-12-08 00:00:00	2010-12-15 00:00:00	2011-01-21 00:00:00	2012-12-12 00:00:00	2014-12-22 00:00:00	2017-01-03 00:00:00	2018-12-31 00:00:00	2020-12-31 00:00:00
ls_beg_yr	2007	2009	2011	2011	2013	2015	2017	2019	2021
ls_end_yr	2008	2010	2012	2012	2014	2016	2018	2020	2022
qual_date	None	None	None	None	None	None	None	None	None
eff_date	None	None	None	None	None	None	None	None	None
bus_city	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
bus_st	CA	CA	CA	CA	CA	CA	CA	CA	CA
bus_zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814
bus_phon	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	916-441-0202	916-441-0202	916-441-0202
bus_fax	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	916-441-1222	None	916-441-1222
bus_email	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None
mail_city	None	None	None	None	None	None	None	None	None
mail_st	None	None	None	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None	None	None	None
mail_phon	None	None	None	None	None	None	None	None	None
sig_date	2006-10-31 00:00:00	2008-12-08 00:00:00	2010-12-15 00:00:00	2011-01-21 00:00:00	2012-12-12 00:00:00	2014-12-04 00:00:00	2016-12-19 00:00:00	2018-12-17 00:00:00	2020-11-23 00:00:00
sig_loc	None	None	None	None	None	None	None	None	None
sig_naml	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	Gilbert	Gilbert	Gilbert
sig_namf	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	Erin E.	Erin E.	Erin E.
sig_namt	None	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None	None
prn_naml	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	None	None	None
prn_namf	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	None	None	None
prn_namt	None	None	None	None	None	None	None	None	None
prn_nams	None	None	None	None	None	None	None	None	None
sig_title	None	None	None	None	None	None	None	None	None
stmt_firm	None	None	None	None	None	None	None	None	None
ind_cb	None	None	None	None	None	None	None	None	None
bus_cb	None	None	None	None	None	None	None	None	None
trade_cb	None	None	None	None	None	None	None	None	None
oth_cb	None	None	None	None	None	None	None	None	None
a_b_name	None	None	None	None	None	None	None	None	None
a_b_city	None	None	None	None	None	None	None	None	None
a_b_st	None	None	None	None	None	None	None	None	None
a_b_zip4	None	None	None	None	None	None	None	None	None
descrip_1	None	None	None	None	None	None	None	None	None
descrip_2	None	None	None	None	None	None	None	None	None
c_less50	None	None	None	None	None	None	None	None	None
c_more50	None	None	None	None	None	None	None	None	None
ind_class	None	None	None	None	None	None	None	None	None
ind_descr	None	None	None	None	None	None	None	None	None
bus_class	None	None	None	None	None	None	None	None	None
bus_descr	None	None	None	None	None	None	None	None	None
auth_name	None	None	None	None	None	None	None	None	None
auth_city	None	None	None	None	None	None	None	None	None
auth_st	None	None	None	None	None	None	None	None	None
auth_zip4	None	None	None	None	None	None	None	None	None
lobby_int	None	None	None	None	None	None	None	None	None
influen_yn	None	None	None	None	None	None	None	None	None
firm_name	CARPI & CLAY, INC.	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	CARPI & CLAY INC	JGC GOVERNMENT RELATIONS INC	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.	JGC GOVERNMENT RELATIONS INC.
newcert_cb	None	None	None	None	None	None	None	None	None
rencert_cb	None	None	X	None	None	None	None	None	None
complet_dt	2005-11-02 00:00:00	2008-11-12 00:00:00	None	2011-01-13 00:00:00	2012-11-08 00:00:00	2014-11-13 00:00:00	2016-11-17 00:00:00	2018-11-15 00:00:00	2020-11-19 00:00:00
lby_reg_cb	X	X	X	X	X	X	X	X	X
lby_604_cb	None	None	None	None	None	None	None	None	None
st_leg_yn	Y	Y	Y	Y	Y	Y	Y	Y	Y
st_agency	None	None	None	None	None	None	None	None	None
lobby_cb	None	None	None	None	None	None	None	None	None
l_firm_cb	None	None	None	None	None	None	None	None	None

Table: filer_address
filer_id	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540
adrid	2095354	2115526	2160255	2203765	2410617	2470159	2517829	2278296	2548020	2344978
effect_dt	2005-11-07 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2013-01-01 00:00:00	2023-01-01 00:00:00	2015-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	2005	2007	2009	2011	2017	2019	2021	2013	2023	2015

Table: filer_ethics_class
filer_id	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540
session_id	2007	2005	2009	2011	2013	2015	2019	2017	2021
ethics_date	2005-11-02 00:00:00	2005-11-02 00:00:00	2008-11-12 00:00:00	2011-01-13 00:00:00	2012-11-08 00:00:00	2014-11-13 00:00:00	2018-11-15 00:00:00	2016-11-17 00:00:00	2020-11-19 00:00:00

Table: filer_filings
filer_id	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540
filing_id	1137282	1137284	1147653	1165200	1188495	1210379	1229608	1251502	1259972	1243418	1278106	1297412	1307890	1980715	1963722	1869251	1798009	1779904	1931876	1944167	1902185	1328116	1346043	1383032	1366592	1409349	1398342	1420929	1431885	1449327	1465437	1480585	1504039	1550802	1530048	1557140	1563312	1557140	1550802	1619692	1604094	1588083	1632398	1654428	1676804	1812025	1699690	1919990	1914607	1737029	1716928	1723774	1841111	1763571	1992660	2381179	2241257	2204095	2354834	2531032	2418481	2005012	2036033	2062488	2100207	2125348	2155653	2139133	2116897	2171212	2541707	2397162	2582591	2483176	2319658	2551245	2191209	2469173	2580182	2440974	2331371	2346191	2269303	2674878	2642095	2601712	2623019	2705733	2746288
period_id	None	None	184	185	186	187	188	189	189	None	190	191	192	222	221	218	215	214	220	None	219	193	194	196	195	None	196	197	198	199	200	201	202	204	203	None	204	None	205	207	206	205	208	209	210	216	211	220	None	212	212	None	217	213	223	237	233	232	None	243	239	224	225	226	227	228	229	None	229	230	244	238	None	242	235	244	231	241	245	240	236	236	234	249	248	246	247	250	251
form_id	F604	F999	F615	F615	F615	F615	F615	F604	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F604	F615	F604	F615	F615	F615	F615	F615	F615	F615	F604	F615	F604	F615	F604	F604	F615	F615	F615	F615	F615	F615	F615	F615	F604	F604	F615	F604	F604	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F604	F604	F615	F604	F615	F604	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	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
filing_date	2005-11-15 00:00:00	2005-11-15 00:00:00	2006-01-31 00:00:00	2006-04-26 00:00:00	2006-07-27 00:00:00	2006-10-24 00:00:00	2007-01-22 00:00:00	2007-03-09 00:00:00	2007-04-26 00:00:00	2006-10-31 00:00:00	2007-07-18 00:00:00	2007-10-31 00:00:00	2008-01-29 00:00:00	2015-07-30 00:00:00	2015-04-29 00:00:00	2014-07-30 00:00:00	2013-10-28 00:00:00	2013-07-29 00:00:00	2015-01-28 00:00:00	2014-12-30 00:00:00	2014-10-22 00:00:00	2008-04-29 00:00:00	2008-07-25 00:00:00	2008-12-08 00:00:00	2008-10-16 00:00:00	2008-12-31 00:00:00	2009-02-02 00:00:00	2009-04-30 00:00:00	2009-07-20 00:00:00	2009-10-23 00:00:00	2010-02-01 00:00:00	2010-04-19 00:00:00	2010-07-28 00:00:00	2010-12-15 00:00:00	2010-10-20 00:00:00	2010-12-22 00:00:00	2011-01-21 00:00:00	2011-01-24 00:00:00	2011-01-21 00:00:00	2011-10-26 00:00:00	2011-07-27 00:00:00	2011-04-25 00:00:00	2012-01-26 00:00:00	2012-04-25 00:00:00	2012-07-30 00:00:00	2014-01-23 00:00:00	2012-10-18 00:00:00	2014-12-22 00:00:00	2014-10-27 00:00:00	2013-01-30 00:00:00	2012-12-12 00:00:00	2012-12-14 00:00:00	2014-04-24 00:00:00	2013-04-29 00:00:00	2015-10-20 00:00:00	2019-04-30 00:00:00	2018-04-30 00:00:00	2018-01-22 00:00:00	2018-12-31 00:00:00	2020-11-02 00:00:00	2019-10-30 00:00:00	2016-01-20 00:00:00	2016-04-29 00:00:00	2016-07-29 00:00:00	2016-10-29 00:00:00	2017-01-27 00:00:00	2017-04-28 00:00:00	2016-12-29 00:00:00	2017-01-03 00:00:00	2017-07-25 00:00:00	2020-12-31 00:00:00	2019-07-30 00:00:00	2021-01-04 00:00:00	2020-07-29 00:00:00	2018-10-31 00:00:00	2021-01-29 00:00:00	2017-10-27 00:00:00	2020-04-29 00:00:00	2021-04-30 00:00:00	2020-01-30 00:00:00	2018-12-31 00:00:00	2019-01-30 00:00:00	2018-07-25 00:00:00	2022-04-29 00:00:00	2022-01-29 00:00:00	2021-07-31 00:00:00	2021-10-29 00:00:00	2022-07-31 00:00:00	2022-10-29 00:00:00
stmnt_type	10005	10005	10001	10001	10001	10001	10001	10001	10001	10005	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	10006	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	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	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	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11003
session_id	2005	2005	2005	2005	2005	2005	2005	2007	2007	2007	2007	2007	2007	2015	2015	2013	2013	2013	2013	2015	2013	2007	2007	2009	2007	2009	2007	2009	2009	2009	2009	2009	2009	2011	2009	2011	2009	2011	2011	2011	2011	2011	2011	2011	2011	2013	2011	2015	2013	2011	2013	2013	2013	2013	2015	2019	2017	2017	2019	2019	2019	2015	2015	2015	2015	2015	2017	2017	2017	2017	2021	2019	2021	2019	2017	2019	2017	2019	2021	2019	2019	2017	2017	2021	2021	2021	2021	2021	2021
user_id	GPEREZ	GPEREZ	LTHIBAUL	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	CFLAGG	LTHIBAUL	LTHIBAUL	LTHIBAUL	JINGRAM	JINGRAM	ASAETERN	ASAETERN	ASAETERN	AGLADNEY	PBANFORD	AGLADNEY	LTHIBAUL	LTHIBAUL	YRODRIGU	CFLAGG	SARRIAGA	CFLAGG	CFLAGG	CFLAGG	CFLAGG	CFLAGG	MGUERRA	ASAETERN	YRODRIGU	ASAETERN	YRODRIGU	ASAETERN	YRODRIGU	YRODRIGU	JINGRAM	ASAETERN	JINGRAM	ASAETERN	ASAETERN	AGLADNEY	ASAETERN	ASAETERN	PBANFORD	YRODRIGU	ASAETERN	YRODRIGU	GPEREZ	ASAETERN	ASAETERN	JINGRAM	VUKSTINA	AGLADNEY	AGLADNEY	SARRIAGA	GTAYLOR	VUKSTINA	AGLADNEY	AGLADNEY	AGLADNEY	JINGRAM	AGLADNEY	JINGRAM	SARRIAGA	SARRIAGA	SMCCONNAN	CVANLIEW	VUKSTINA	CVANLIEW	MMERCHANT	JFRONEFIELD	CHARTRIDGE	SMCCONNAN	VUKSTINA	MKIRKHAM	VUKSTINA	SARRIAGA	AGLADNEY	AGLADNEY	CAFILER	GTAYLOR	GTAYLOR	MKIRKHAM	CAFILER	CAFILER
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11003	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	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	11003	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11003	11001	11003	11003	11003	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11003	11003
rpt_start	1900-01-01 00:00:00	1900-01-01 00:00:00	2005-11-07 00:00:00	2006-01-01 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	2006-10-01 00:00:00	2007-03-09 00:00:00	2007-01-01 00:00:00	1900-01-01 00:00:00	2007-04-01 00:00:00	2007-07-01 00:00:00	2007-10-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	2014-10-01 00:00:00	1900-01-01 00:00:00	2014-07-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-12-08 00:00:00	2008-07-01 00:00:00	1900-01-01 00:00:00	2008-10-01 00:00:00	2009-01-01 00:00:00	2009-04-01 00:00:00	2009-07-01 00:00:00	2009-10-01 00:00:00	2010-01-01 00:00:00	2010-04-01 00:00:00	2010-12-15 00:00:00	2010-07-01 00:00:00	1900-01-01 00:00:00	2010-10-01 00:00:00	1900-01-01 00:00:00	2011-01-21 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-01-01 00:00:00	2012-04-01 00:00:00	2013-10-01 00:00:00	2012-07-01 00:00:00	2014-12-22 00:00:00	1900-01-01 00:00:00	2012-10-01 00:00:00	2012-12-12 00:00:00	1900-01-01 00:00:00	2014-01-01 00:00:00	2013-01-01 00:00:00	2015-07-01 00:00:00	2019-01-01 00:00:00	2018-01-01 00:00:00	2017-10-01 00:00:00	1900-01-01 00:00:00	2020-07-01 00:00:00	2019-07-01 00:00:00	2015-10-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	2016-07-01 00:00:00	2016-10-01 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	2017-01-03 00:00:00	2017-04-01 00:00:00	2020-12-31 00:00:00	2019-04-01 00:00:00	1900-01-01 00:00:00	2020-04-01 00:00:00	2018-07-01 00:00:00	2020-10-01 00:00:00	2017-07-01 00:00:00	2020-01-01 00:00:00	2021-01-01 00:00:00	2019-10-01 00:00:00	2018-12-31 00:00:00	2018-10-01 00:00:00	2018-04-01 00:00:00	2022-01-01 00:00:00	2021-10-01 00:00:00	2021-04-01 00:00:00	2021-07-01 00:00:00	2022-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-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-31 00:00:00	2007-03-09 00:00:00	2007-03-31 00:00:00	1900-01-01 00:00:00	2007-06-30 00:00:00	2007-09-30 00:00:00	2007-12-31 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	2014-12-31 00:00:00	1900-01-01 00:00:00	2014-09-30 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-12-08 00:00:00	2008-09-30 00:00:00	1900-01-01 00:00:00	2008-12-31 00:00:00	2009-03-31 00:00:00	2009-06-30 00:00:00	2009-09-30 00:00:00	2009-12-31 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	2010-12-15 00:00:00	2010-09-30 00:00:00	1900-01-01 00:00:00	2010-12-31 00:00:00	1900-01-01 00:00:00	2011-01-21 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-03-31 00:00:00	2012-06-30 00:00:00	2013-12-31 00:00:00	2012-09-30 00:00:00	2014-12-22 00:00:00	1900-01-01 00:00:00	2012-12-31 00:00:00	2012-12-12 00:00:00	1900-01-01 00:00:00	2014-03-31 00:00:00	2013-03-31 00:00:00	2015-09-30 00:00:00	2019-03-31 00:00:00	2018-03-31 00:00:00	2017-12-31 00:00:00	1900-01-01 00:00:00	2020-09-30 00:00:00	2019-09-30 00:00:00	2015-12-31 00:00:00	2016-03-31 00:00:00	2016-06-30 00:00:00	2016-09-30 00:00:00	2016-12-31 00:00:00	2017-03-31 00:00:00	1900-01-01 00:00:00	2017-01-03 00:00:00	2017-06-30 00:00:00	2020-12-31 00:00:00	2019-06-30 00:00:00	1900-01-01 00:00:00	2020-06-30 00:00:00	2018-09-30 00:00:00	2020-12-31 00:00:00	2017-09-30 00:00:00	2020-03-31 00:00:00	2021-03-31 00:00:00	2019-12-31 00:00:00	2018-12-31 00:00:00	2018-12-31 00:00:00	2018-06-30 00:00:00	2022-03-31 00:00:00	2021-12-31 00:00:00	2021-06-30 00:00:00	2021-09-30 00:00:00	2022-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
filing_type	None	None	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	22001	22001	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	None	22006	22006	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001

Table: filer_to_filer_type
filer_id	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540
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	None	0	None	None	None	None	None	None	None
session_id	2005	2011	2007	2009	2013	2015	2021	2019	2017	2023
category	0	None	0	None	None	None	None	None	None	None
category_type	0	None	0	None	None	None	None	None	None	None
sub_category	0	None	0	None	None	None	None	None	None	None
effect_dt	2005-11-07 00:00:00	2011-01-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2013-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	None	0	None	None	None	None	None	None	None
election_type	0	None	0	None	None	None	None	None	None	None
sub_category_a	None	None	None	None	None	None	None	None	None	None
nyq_dt	2005-11-07 00:00:00	None	2005-11-07 00:00:00	None	None	None	None	None	None	None
party_cd	0	None	0	None	None	None	None	None	None	None
county_cd	0	None	0	None	None	None	None	None	None	None
district_cd	0	None	0	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1281540
xref_id		1281540
effect_dt		2005-11-15 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540
filer_id	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540
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
status	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE
effect_dt	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00
naml	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT	GILBERT
namf	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.	ERIN E.
namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
city	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	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
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	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
phon	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202	9164410202
fax	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222		9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222		9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222		9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222		9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222		9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222		9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222		9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222		9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222		9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222	9164411222		9164411222	9164411222
email	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	None	None	None

Table: filers
filer_id		1281540

Table: lobbying_chg_log
filer_id	1281540	1281540
change_no	0	1
session_id	2005	2013
log_dt	2005-11-15 00:00:00	2014-10-27 00:00:00
filer_type	4	4
correction_flg	None	None
action	ADDED	DELETED
attribute_changed	FIRM	FIRM
ethics_dt	None	None
interests	None	None
filer_full_name	GILBERT, ERIN E.	ERIN E. GILBERT
filer_city	None	None
filer_st	None	None
filer_zip	None	None
filer_phone	None	None
entity_type	3	3
entity_name	CARPI & CLAY INC.	CARPI & CLAY, INC.
entity_city	None	None
entity_st	None	None
entity_zip	None	None
entity_phone	None	None
entity_id	1147222	1147222
responsible_officer	None	None
effect_dt	2005-11-07 00:00:00	2014-10-01 00:00:00

Table: received_filings
filer_id	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540	1281540
filing_file_name	1251502_0.cal	1383032_0.cal	1550802_0.cal	1550802_1.cal	1716928_0.cal	1980715_0.cal	2125348_0.cal	1992660_0.cal	2005012_0.cal	2155653_0.cal	2116897_0.cal	2100207_0.cal	2062488_0.cal	1919990_0.cal	2036033_0.cal	1963722_0.cal	397550.cal	2171212_0.cal	2241257_0.cal	2204095_0.cal	2397162_0.cal	2469173_0.cal	2381179_0.cal	2418481_0.cal	2483176_0.cal	2440974_0.cal	2319658_0.cal	2191209_0.cal	2331371_0.cal	2346191_0.cal	2269303_0.cal	2541707_0.cal	2551245_0.cal	2674878_0.cal	2746288_0.cal	2531032_0.cal	2580182_0.cal	2601712_0.cal	2642095_0.cal	2623019_0.cal	2705733_0.cal
received_date	2007-03-09 00:00:00	2008-12-08 00:00:00	2010-12-15 00:00:00	2011-01-21 00:00:00	2012-12-12 00:00:00	2015-07-30 00:00:00	2017-01-27 00:00:00	2015-10-20 00:00:00	2016-01-20 00:00:00	2017-04-28 00:00:00	2017-01-03 00:00:00	2016-10-29 00:00:00	2016-07-29 00:00:00	2014-12-22 00:00:00	2016-04-29 00:00:00	2015-04-29 00:00:00	2015-04-29 00:00:00	2017-07-25 00:00:00	2018-04-30 00:00:00	2018-01-22 00:00:00	2019-07-30 00:00:00	2020-04-29 00:00:00	2019-04-30 00:00:00	2019-10-30 00:00:00	2020-07-29 00:00:00	2020-01-30 00:00:00	2018-10-31 00:00:00	2017-10-27 00:00:00	2018-12-31 00:00:00	2019-01-30 00:00:00	2018-07-25 00:00:00	2020-12-31 00:00:00	2021-01-29 00:00:00	2022-04-29 00:00:00	2022-10-29 00:00:00	2020-11-02 00:00:00	2021-04-30 00:00:00	2021-07-31 00:00:00	2022-01-29 00:00:00	2021-10-29 00:00:00	2022-07-31 00:00:00
filing_directory	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal
filing_id	1251502	1383032	1550802	1550802	1716928	1980715	2125348	1992660	2005012	2155653	2116897	2100207	2062488	1919990	2036033	1963722	None	2171212	2241257	2204095	2397162	2469173	2381179	2418481	2483176	2440974	2319658	2191209	2331371	2346191	2269303	2541707	2551245	2674878	2746288	2531032	2580182	2601712	2642095	2623019	2705733
form_id	F604	F604	F604	F604	F604	F615	F615	F615	F615	F615	F604	F615	F615	F604	F615	F615	None	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F604	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 passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted