OpenCalAccess

Filer ID: 1235148

Table: cvr_lobby_disclosure
filing_id	769503	790041	807692	836460	850044	880756	907806	927471	943382	964195	984319	1011251	1026412	1053714	1078063	1099351	1127415	1144264	1161344	1111244	1185554	1227983	1292029	1276777	1206972	1256339	1365666	1315024	1323311	1342570	1416558	1447746	1428678	1401905	1457101	1522458	1499617	1478980	1557862	1587719	1617098	1599326	1627397	1696465	1670129	1651065	1722849	1793024	1774692	1755088	1809947	1891159	1861707	1836345	1923601	1991445	1973729	1956826	2002774	1973729	1991445	2085465	2053698	2026268	2117208	2165861	2148966	2228333	2300346	2262865	2199749	2370240	2388632	2334545	2411000	2429784	2464790	2477359	2544900	2573353	2509390	2593684	2634681	2614988	2730367	2663407	2698053
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	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
rec_type	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR	CVR
form_type	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615
sender_id	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692
filer_id	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148
entity_cd	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	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	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES
filer_namf	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL
filer_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	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
rpt_date	2001-07-31 00:00:00	2001-10-29 00:00:00	2002-01-31 00:00:00	2002-01-31 00:00:00	2002-07-31 00:00:00	2002-10-31 00:00:00	2003-01-22 00:00:00	2003-04-30 00:00:00	2003-07-31 00:00:00	2003-10-31 00:00:00	2004-01-31 00:00:00	2004-04-30 00:00:00	2004-07-31 00:00:00	2004-10-31 00:00:00	2005-01-31 00:00:00	2005-04-30 00:00:00	2005-10-06 00:00:00	2006-01-24 00:00:00	2006-04-10 00:00:00	2005-07-31 00:00:00	2006-07-20 00:00:00	2007-01-15 00:00:00	2007-10-03 00:00:00	2007-07-10 00:00:00	2006-10-12 00:00:00	2007-04-11 00:00:00	2008-10-13 00:00:00	2008-02-12 00:00:00	2008-04-06 00:00:00	2008-07-09 00:00:00	2009-04-08 00:00:00	2009-10-14 00:00:00	2009-07-02 00:00:00	2009-02-10 00:00:00	2010-01-08 00:00:00	2010-10-05 00:00:00	2010-07-08 00:00:00	2010-04-10 00:00:00	2011-01-07 00:00:00	2011-04-22 00:00:00	2011-10-11 00:00:00	2011-07-08 00:00:00	2012-01-06 00:00:00	2012-10-09 00:00:00	2012-07-06 00:00:00	2012-04-06 00:00:00	2013-01-04 00:00:00	2013-10-07 00:00:00	2013-07-10 00:00:00	2013-04-05 00:00:00	2014-01-14 00:00:00	2014-10-02 00:00:00	2014-07-08 00:00:00	2014-04-07 00:00:00	2015-01-06 00:00:00	2015-10-12 00:00:00	2015-07-10 00:00:00	2015-04-08 00:00:00	2016-01-07 00:00:00	2015-11-03 00:00:00	2015-11-03 00:00:00	2016-10-05 00:00:00	2016-07-06 00:00:00	2016-04-05 00:00:00	2017-01-04 00:00:00	2017-07-06 00:00:00	2017-03-31 00:00:00	2018-04-04 00:00:00	2018-10-02 00:00:00	2018-07-06 00:00:00	2018-01-03 00:00:00	2019-04-04 00:00:00	2019-07-02 00:00:00	2019-01-15 00:00:00	2019-10-01 00:00:00	2019-10-01 00:00:00	2020-04-02 00:00:00	2020-07-08 00:00:00	2021-01-18 00:00:00	2021-04-10 00:00:00	2020-10-03 00:00:00	2021-07-12 00:00:00	2022-01-14 00:00:00	2021-07-12 00:00:00	2022-10-09 00:00:00	2022-04-05 00:00:00	2022-07-13 00:00:00
from_date	2001-04-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	2002-01-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	2003-01-01 00:00:00	2003-04-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2004-01-01 00:00:00	2004-04-01 00:00:00	2004-07-01 00:00:00	2004-10-01 00:00:00	2005-01-01 00:00:00	2005-07-01 00:00:00	2005-10-01 00:00:00	2006-01-01 00:00:00	2005-04-01 00:00:00	2006-04-01 00:00:00	2006-10-01 00:00:00	2007-07-01 00:00:00	2007-04-01 00:00:00	2006-07-01 00:00:00	2007-01-01 00:00:00	2008-07-01 00:00:00	2007-10-01 00:00:00	2008-01-01 00:00:00	2008-04-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	2009-10-01 00:00:00	2010-07-01 00:00:00	2010-04-01 00:00:00	2010-01-01 00:00:00	2010-10-01 00:00:00	2011-01-01 00:00:00	2011-07-01 00:00:00	2011-04-01 00:00:00	2011-10-01 00:00:00	2012-07-01 00:00:00	2012-04-01 00:00:00	2012-01-01 00:00:00	2012-10-01 00:00:00	2013-07-01 00:00:00	2013-04-01 00:00:00	2013-01-01 00:00:00	2013-10-01 00:00:00	2014-07-01 00:00:00	2014-04-01 00:00:00	2014-01-01 00:00:00	2014-10-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-01-01 00:00:00	2015-10-01 00:00:00	2015-04-01 00:00:00	2015-07-01 00:00:00	2016-07-01 00:00:00	2016-04-01 00:00:00	2016-01-01 00:00:00	2016-10-01 00:00:00	2017-04-01 00:00:00	2017-01-01 00:00:00	2018-01-01 00:00:00	2018-07-01 00:00:00	2018-04-01 00:00:00	2017-07-01 00:00:00	2019-01-01 00:00:00	2019-04-01 00:00:00	2018-10-01 00:00:00	2019-07-01 00:00:00	2019-10-01 00:00:00	2020-01-01 00:00:00	2020-04-01 00:00:00	2020-10-01 00:00:00	2021-01-01 00:00:00	2020-07-01 00:00:00	2021-04-01 00:00:00	2021-10-01 00:00:00	2021-07-01 00:00:00	2022-07-01 00:00:00	2022-01-01 00:00:00	2022-04-01 00:00:00
thru_date	2001-06-30 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	2002-03-31 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-12-31 00:00:00	2003-03-31 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2004-03-31 00:00:00	2004-06-30 00:00:00	2004-09-30 00:00:00	2004-12-31 00:00:00	2005-03-31 00:00:00	2005-09-30 00:00:00	2005-12-31 00:00:00	2006-03-31 00:00:00	2005-06-30 00:00:00	2006-06-30 00:00:00	2006-12-31 00:00:00	2007-09-30 00:00:00	2007-06-30 00:00:00	2006-09-30 00:00:00	2007-03-31 00:00:00	2008-09-30 00:00:00	2007-12-31 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2009-03-01 00:00:00	2009-09-30 00:00:00	2009-06-30 00:00:00	2008-12-31 00:00:00	2009-12-31 00:00:00	2010-09-30 00:00:00	2010-06-30 00:00:00	2010-03-31 00:00:00	2010-12-31 00:00:00	2011-03-31 00:00:00	2011-09-30 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	2012-09-30 00:00:00	2012-06-30 00:00:00	2012-03-31 00:00:00	2012-12-31 00:00:00	2013-09-30 00:00:00	2013-06-30 00:00:00	2013-03-31 00:00:00	2013-12-31 00:00:00	2014-09-30 00:00:00	2014-06-30 00:00:00	2014-03-31 00:00:00	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	2015-06-30 00:00:00	2015-09-30 00:00:00	2016-09-30 00:00:00	2016-06-30 00:00:00	2016-03-31 00:00:00	2016-12-31 00:00:00	2017-06-30 00:00:00	2017-03-31 00:00:00	2018-03-31 00:00:00	2018-09-30 00:00:00	2018-06-30 00:00:00	2017-12-31 00:00:00	2019-03-31 00:00:00	2019-06-30 00:00:00	2018-12-31 00:00:00	2019-09-30 00:00:00	2019-12-31 00:00:00	2020-03-31 00:00:00	2020-06-30 00:00:00	2020-12-31 00:00:00	2021-03-31 00:00:00	2020-09-30 00:00:00	2021-06-30 00:00:00	2021-12-31 00:00:00	2021-09-30 00:00:00	2022-09-30 00:00:00	2022-03-31 00:00:00	2022-06-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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
firm_id	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692	E24692
firm_name	GUN OWNERS OF CALIF. INC.	GUN OWNERS OF CALIF. INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.	GUN OWNERS OF CALIF., INC.
firm_city	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	EL DORADO HILLS	EL DORADO HILLS	FOLSOM	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS	EL DORADO HILLS
firm_st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
firm_zip4	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95628	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95630	95762	95762	95630	95762	95762	95762	95762	95762	95762
firm_phon	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/967-4970	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400	916/984-1400
mail_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_zip4	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
mail_phon	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_date	2001-07-23 00:00:00	2001-10-01 00:00:00	2001-12-31 00:00:00	2002-04-10 00:00:00	2002-04-10 00:00:00	2002-10-04 00:00:00	2003-01-22 00:00:00	2003-04-15 00:00:00	2003-07-15 00:00:00	2003-10-23 00:00:00	2004-01-15 00:00:00	2004-04-20 00:00:00	2004-07-20 00:00:00	2004-10-20 00:00:00	2005-01-20 00:00:00	2005-04-07 00:00:00	2005-10-06 00:00:00	2006-01-24 00:00:00	2006-04-10 00:00:00	2005-07-08 00:00:00	2006-07-20 00:00:00	2007-01-15 00:00:00	2007-10-03 00:00:00	2007-07-10 00:00:00	2006-10-12 00:00:00	2007-04-11 00:00:00	2008-10-13 00:00:00	2008-02-12 00:00:00	2008-04-06 00:00:00	2008-07-09 00:00:00	2009-04-08 00:00:00	2009-10-14 00:00:00	2009-07-02 00:00:00	2009-02-10 00:00:00	2010-01-08 00:00:00	2010-10-05 00:00:00	2010-07-08 00:00:00	2010-04-10 00:00:00	2011-01-07 00:00:00	2011-04-22 00:00:00	2011-10-11 00:00:00	2011-07-08 00:00:00	2012-01-06 00:00:00	2012-10-09 00:00:00	2012-07-06 00:00:00	2012-04-06 00:00:00	2013-01-04 00:00:00	2013-10-07 00:00:00	2013-07-10 00:00:00	2013-04-05 00:00:00	2014-01-14 00:00:00	2014-10-02 00:00:00	2014-07-08 00:00:00	2014-04-07 00:00:00	2015-01-06 00:00:00	2015-10-12 00:00:00	2015-07-10 00:00:00	2015-04-08 00:00:00	2016-01-07 00:00:00	2015-11-03 00:00:00	2015-11-03 00:00:00	2016-10-05 00:00:00	2016-07-06 00:00:00	2016-04-05 00:00:00	2017-01-04 00:00:00	2017-07-06 00:00:00	2017-03-31 00:00:00	2018-04-04 00:00:00	2018-10-02 00:00:00	2018-07-06 00:00:00	2018-01-03 00:00:00	2019-04-04 00:00:00	2019-07-02 00:00:00	2018-01-15 00:00:00	2019-10-01 00:00:00	2020-01-11 00:00:00	2020-04-02 00:00:00	2020-07-08 00:00:00	2021-01-18 00:00:00	2021-04-10 00:00:00	2020-10-03 00:00:00	2021-07-15 00:00:00	2022-01-14 00:00:00	2021-10-09 00:00:00	2022-10-09 00:00:00	2022-01-14 00:00:00	2022-07-13 00:00:00
sig_loc	FAIR OAKS CA	FAIR OAKS CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FAIR OAKS, CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	FOLSOM CA	EL DORADO HILLS CA	EL DORADO HILLS CA	FOLSOM CA	EL DORADO HILLS CA	EL DORADO HILLS CA	EL DORADO HILLS CA	EL DORADO HILLS CA	EL DORADO HILLS CA	EL DORADO HILLS CA
sig_naml	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES
sig_namf	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
prn_naml	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES
prn_namf	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL
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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
prn_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X
nopart2_cb	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X
part1_1_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
part1_2_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ctrib_n_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
ctrib_y_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lby_actvty	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lobby_n_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
lobby_y_cb	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_naml	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
major_nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rcpcmte_nm	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
rcpcmte_id	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: filer_address
filer_id	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148
adrid	2015745	2043124	2081402	2113777	2160773	2225216	2411507	2465264	2296136	2338260	2505003
effect_dt	2001-04-01 00:00:00	2003-01-01 00:00:00	2005-01-01 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	2013-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	7051
session_id	2001	2003	2005	2007	2009	2011	2017	2019	2013	2015	2021

Table: filer_ethics_class
filer_id	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148
session_id	2001	2003	2005	2007	2009	2011	2013	2015	2017	2019	2021
ethics_date	2001-08-09 00:00:00	2003-04-24 00:00:00	2004-11-17 00:00:00	2007-02-08 00:00:00	2009-04-24 00:00:00	2011-04-21 00:00:00	2013-04-11 00:00:00	2014-11-13 00:00:00	2016-11-17 00:00:00	2019-05-23 00:00:00	2021-01-15 00:00:00

Table: filer_filings
filer_id	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148
filing_id	753741	760197	769503	790041	753741	796796	807692	844782	830999	824404	836460	850044	865926	880756	892440	900182	907806	925468	927471	934637	943382	929837	954610	964195	975385	995258	984319	1011251	1026412	1016681	1053714	1036591	1060854	1076440	1090146	1078063	1099351	1111244	1144264	1127415	1161344	1185554	1206972	1228776	1227983	1256339	1228776	1276777	1292029	1755088	1973729	1861707	1780045	1809947	1793024	1774692	1949694	1956826	1315024	1323311	1342570	1365666	1401905	1416558	1425242	1427823	1428678	1447746	1478980	1457101	1499617	1522458	1557862	1599326	1593334	1617098	1587719	1627397	1639556	1651065	1670129	1696465	1926628	1923601	1891159	1722849	1836345	1758803	1973729	1991445	1991445	2002774	2327423	2186317	2228333	2464790	2199749	2429784	2026268	2053698	2085465	2117208	2148966	2165861	2477359	2370240	2463896	2509390	2544900	2262865	2411000	2300346	2388632	2334545	2663407	2698053	2573353	2644090	2634681	2630823	2593684	2614988	2730367
period_id	None	None	166	167	None	None	168	None	None	None	169	170	None	171	None	None	172	None	173	None	174	None	None	175	None	None	176	177	178	None	179	None	None	None	None	180	181	182	184	183	185	186	187	None	188	189	None	190	191	213	221	218	None	216	215	214	None	221	192	193	194	195	196	197	None	None	198	199	201	200	202	203	204	206	None	207	205	208	None	209	210	211	None	220	219	212	217	None	222	223	221	224	None	None	233	241	231	240	225	226	227	228	229	230	242	237	None	243	244	234	239	235	238	236	249	250	245	None	248	None	246	247	251
form_id	F604	F999	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F604	F615	F615	F615	F615	F615	F604	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F604	F604	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F604	F615	F615	F615	F604	F615	F615	F615	F615	F604	F615	F615	F615	F615	F604	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F604	F615	F615	F615
filing_sequence	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	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	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
filing_date	2001-04-19 00:00:00	2001-05-29 00:00:00	2001-07-24 00:00:00	2001-10-29 00:00:00	2001-08-09 00:00:00	2001-10-30 00:00:00	2002-01-16 00:00:00	2002-05-01 00:00:00	2001-07-25 00:00:00	2002-01-25 00:00:00	2002-04-22 00:00:00	2002-07-17 00:00:00	2002-07-31 00:00:00	2002-10-27 00:00:00	2002-10-29 00:00:00	2002-12-27 00:00:00	2003-01-28 00:00:00	2003-01-27 00:00:00	2003-04-15 00:00:00	2003-04-17 00:00:00	2003-07-22 00:00:00	2003-04-24 00:00:00	2003-07-24 00:00:00	2003-10-16 00:00:00	2003-10-31 00:00:00	2004-01-23 00:00:00	2004-01-21 00:00:00	2004-04-26 00:00:00	2004-07-27 00:00:00	2004-04-27 00:00:00	2004-10-25 00:00:00	2004-08-02 00:00:00	2004-10-28 00:00:00	2004-12-30 00:00:00	2005-01-31 00:00:00	2005-01-28 00:00:00	2005-04-07 00:00:00	2005-07-08 00:00:00	2006-01-25 00:00:00	2005-10-06 00:00:00	2006-04-10 00:00:00	2006-07-20 00:00:00	2006-10-12 00:00:00	2007-01-03 00:00:00	2007-01-15 00:00:00	2007-04-11 00:00:00	2007-05-30 00:00:00	2007-07-10 00:00:00	2007-10-03 00:00:00	2013-04-05 00:00:00	2015-07-10 00:00:00	2014-07-08 00:00:00	2013-07-16 00:00:00	2014-01-14 00:00:00	2013-10-08 00:00:00	2013-07-10 00:00:00	2015-02-11 00:00:00	2015-04-08 00:00:00	2008-02-12 00:00:00	2008-04-06 00:00:00	2008-07-09 00:00:00	2008-10-13 00:00:00	2009-02-10 00:00:00	2009-04-08 00:00:00	2009-04-24 00:00:00	2009-06-23 00:00:00	2009-07-02 00:00:00	2009-10-14 00:00:00	2010-04-10 00:00:00	2010-01-08 00:00:00	2010-07-08 00:00:00	2010-10-05 00:00:00	2011-01-07 00:00:00	2011-07-08 00:00:00	2011-04-21 00:00:00	2011-10-11 00:00:00	2011-04-22 00:00:00	2012-01-09 00:00:00	2012-01-30 00:00:00	2012-04-06 00:00:00	2012-07-06 00:00:00	2012-10-09 00:00:00	2014-12-24 00:00:00	2015-01-07 00:00:00	2014-10-02 00:00:00	2013-01-04 00:00:00	2014-04-07 00:00:00	2013-04-11 00:00:00	2015-11-03 00:00:00	2015-11-03 00:00:00	2015-10-12 00:00:00	2016-01-07 00:00:00	2018-10-24 00:00:00	2017-10-02 00:00:00	2018-04-04 00:00:00	2020-04-02 00:00:00	2018-01-03 00:00:00	2020-01-11 00:00:00	2016-04-05 00:00:00	2016-07-06 00:00:00	2016-10-05 00:00:00	2017-01-04 00:00:00	2017-03-31 00:00:00	2017-07-06 00:00:00	2020-07-08 00:00:00	2019-04-04 00:00:00	2020-03-18 00:00:00	2020-10-03 00:00:00	2021-01-18 00:00:00	2018-07-06 00:00:00	2019-10-01 00:00:00	2018-10-02 00:00:00	2019-07-02 00:00:00	2019-01-15 00:00:00	2022-04-05 00:00:00	2022-07-13 00:00:00	2021-04-10 00:00:00	2021-07-09 00:00:00	2022-01-14 00:00:00	2021-01-28 00:00:00	2021-07-15 00:00:00	2021-10-09 00:00:00	2022-10-08 00:00:00
stmnt_type	10005	10005	10001	10001	10006	10005	10001	10005	10005	10005	10001	10001	10005	10001	10005	10005	10001	10005	10001	10005	10001	10005	10005	10001	10005	10005	10001	10001	10001	10005	10001	10005	10005	10005	10005	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10006	10001	10001	10001	10001	10001	10005	10001	10001	10001	10006	10001	10001	10001	10001	10001	10001	10001	10006	10005	10001	10001	10001	10001	10001	10001	10001	10001	10006	10001	10001	10001	10005	10001	10001	10001	10005	10001	10001	10001	10001	10006	10002	10002	10001	10001	10005	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10002	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10005	10001	10001	10001
stmnt_status	11001	11001	11003	11003	11001	11001	11003	11001	11003	11001	11003	11003	11003	11003	11001	11001	11003	11001	11003	11003	11003	11001	11001	11003	11001	11001	11003	11003	11003	11001	11003	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003
session_id	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2003	2001	2001	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2005	2003	2003	2005	2005	2005	2005	2005	2005	2005	2007	2005	2007	2007	2007	2007	2013	2015	2013	2013	2013	2013	2013	2015	2015	2007	2007	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2011	2011	2011	2011	2011	2011	2011	2015	2013	2013	2011	2013	2013	2015	2015	2015	2015	2019	2017	2017	2019	2017	2019	2015	2015	2015	2015	2017	2017	2019	2019	2019	2019	2019	2017	2019	2017	2019	2017	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	SARRIAGA	SARRIAGA	*	*	SARRIAGA	LTHIBAUL	*	LTHIBAUL	GGILMORE	LTHIBAUL	*	*	GGILMORE	*	LTHIBAUL	SARRIAGA	COMPLETED	LTHIBAUL	COMPLETED	KVOONG1	COMPLETED	CFLAGG	LTHIBAUL	COMPLETED	LTHIBAUL	LTHIBAUL	COMPLETED	COMPLETED	COMPLETED	LTHIBAUL	COMPLETED	LTHIBAUL	LTHIBAUL	PBANFORD	LTHIBAUL	COMPLETED	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	SARRIAGA	LTHIBAUL	LTHIBAUL	CFLAGG	LTHIBAUL	LTHIBAUL	ASAETERN	AGLADNEY	AGLADNEY	YRODRIGU	ASAETERN	AGLADNEY	ASAETERN	PBANFORD	JINGRAM	LTHIBAUL	LTHIBAUL	LTHIBAUL	JINGRAM	JINGRAM	MGUERRA	YRODRIGU	PBANFORD	MGUERRA	MGUERRA	JINGRAM	MGUERRA	ASAETERN	AGLADNEY	ASAETERN	AGLADNEY	YRODRIGU	AGLADNEY	AGLADNEY	AGLADNEY	YRODRIGU	ASAETERN	ASAETERN	ASAETERN	ASAETERN	AGLADNEY	AGLADNEY	ASAETERN	AGLADNEY	SMCCONNAN	JINGRAM	JINGRAM	AGLADNEY	AGLADNEY	YRODRIGU	GPEREZ	AGLADNEY	GTAYLOR	KBANH	VUKSTINA	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	SMCCONNAN	SMCCONNAN	VUKSTINA	VUKSTINA	AROJAS	CVANLIEW	MKIRKHAM	AGLADNEY	GTAYLOR	JFRONEFIELD	VUKSTINA	AGLADNEY	CHATRIDGE	CAFILER	JMAVES	CVANLIEW	RATTIYEH	CVANLIEW	CHATRIDGE	MKIRKHAM	CAFILER
special_audit	11003	11003	11003	11003	11003	11003	11003	11002	11003	11002	11003	11003	11002	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11003	11001	11001	11003
rpt_start	1900-01-01 00:00:00	1900-01-01 00:00:00	2001-04-01 00:00:00	2001-07-01 00:00:00	1900-01-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	2002-01-01 00:00:00	2001-04-01 00:00:00	2001-10-01 00:00:00	2002-01-01 00:00:00	2002-04-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	2002-07-01 00:00:00	1900-01-01 00:00:00	2002-10-01 00:00:00	2002-10-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2003-04-01 00:00:00	1900-01-01 00:00:00	2003-04-01 00:00:00	2003-07-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2003-10-01 00:00:00	2004-01-01 00:00:00	2004-04-01 00:00:00	2004-01-01 00:00:00	2004-07-01 00:00:00	2004-04-01 00:00:00	2004-07-01 00:00:00	1900-01-01 00:00:00	2004-10-01 00:00:00	2004-10-01 00:00:00	2005-01-01 00:00:00	2005-04-01 00:00:00	2005-10-01 00:00:00	2005-07-01 00:00:00	2006-01-01 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	1900-01-01 00:00:00	2006-10-01 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	2013-01-01 00:00:00	2015-01-01 00:00:00	2014-04-01 00:00:00	1900-01-01 00:00:00	2013-10-01 00:00:00	2013-07-01 00:00:00	2013-04-01 00:00:00	1900-01-01 00:00:00	2015-01-01 00:00:00	2007-10-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-07-01 00:00:00	2008-10-01 00:00:00	2009-01-01 00:00:00	1900-01-01 00:00:00	1900-01-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	2010-10-01 00:00:00	2011-04-01 00:00:00	1900-01-01 00:00:00	2011-07-01 00:00:00	2011-01-01 00:00:00	2011-10-01 00:00:00	1900-01-01 00:00:00	2012-01-01 00:00:00	2012-04-01 00:00:00	2012-07-01 00:00:00	1900-01-01 00:00:00	2014-10-01 00:00:00	2014-07-01 00:00:00	2012-10-01 00:00:00	2014-01-01 00:00:00	1900-01-01 00:00:00	2015-04-01 00:00:00	2015-07-01 00:00:00	2015-01-01 00:00:00	2015-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-01-01 00:00:00	2020-01-01 00:00:00	2017-07-01 00:00:00	2019-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	2017-04-01 00:00:00	2020-04-01 00:00:00	2019-01-01 00:00:00	1900-01-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	2018-04-01 00:00:00	2019-07-01 00:00:00	2018-07-01 00:00:00	2019-04-01 00:00:00	2018-10-01 00:00:00	2022-01-01 00:00:00	2022-04-01 00:00:00	2021-01-01 00:00:00	1900-01-01 00:00:00	2021-10-01 00:00:00	1900-01-01 00:00:00	2021-04-01 00:00:00	2021-07-01 00:00:00	2022-07-01 00:00:00
rpt_end	1900-01-01 00:00:00	1900-01-01 00:00:00	2001-06-30 00:00:00	2001-09-30 00:00:00	1900-01-01 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	2002-03-31 00:00:00	2001-06-30 00:00:00	2001-12-31 00:00:00	2002-03-31 00:00:00	2002-06-30 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-09-30 00:00:00	1900-01-01 00:00:00	2002-12-31 00:00:00	2002-12-31 00:00:00	2003-03-31 00:00:00	2003-03-31 00:00:00	2003-06-30 00:00:00	1900-01-01 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2003-12-31 00:00:00	2004-03-31 00:00:00	2004-06-30 00:00:00	2004-03-31 00:00:00	2004-09-30 00:00:00	2004-06-30 00:00:00	2004-09-30 00:00:00	1900-01-01 00:00:00	2004-12-31 00:00:00	2004-12-31 00:00:00	2005-03-31 00:00:00	2005-06-30 00:00:00	2005-12-31 00:00:00	2005-09-30 00:00:00	2006-03-31 00:00:00	2006-06-30 00:00:00	2006-09-30 00:00:00	1900-01-01 00:00:00	2006-12-31 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	2013-03-31 00:00:00	2015-06-30 00:00:00	2014-06-30 00:00:00	1900-01-01 00:00:00	2013-12-31 00:00:00	2013-09-30 00:00:00	2013-06-30 00:00:00	1900-01-01 00:00:00	2015-03-31 00:00:00	2007-12-31 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2008-12-31 00:00:00	2009-03-01 00:00:00	1900-01-01 00:00:00	1900-01-01 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	2010-12-31 00:00:00	2011-06-30 00:00:00	1900-01-01 00:00:00	2011-09-30 00:00:00	2011-03-31 00:00:00	2011-12-31 00:00:00	1900-01-01 00:00:00	2012-03-31 00:00:00	2012-06-30 00:00:00	2012-09-30 00:00:00	1900-01-01 00:00:00	2014-12-31 00:00:00	2014-09-30 00:00:00	2012-12-31 00:00:00	2014-03-31 00:00:00	1900-01-01 00:00:00	2015-06-30 00:00:00	2015-09-30 00:00:00	2015-09-30 00:00:00	2015-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-03-31 00:00:00	2020-03-31 00:00:00	2017-12-31 00:00:00	2019-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	2017-06-30 00:00:00	2020-06-30 00:00:00	2019-03-31 00:00:00	1900-01-01 00:00:00	2020-09-30 00:00:00	2020-12-31 00:00:00	2018-06-30 00:00:00	2019-09-30 00:00:00	2018-09-30 00:00:00	2019-06-30 00:00:00	2018-12-31 00:00:00	2022-03-31 00:00:00	2022-06-30 00:00:00	2021-03-31 00:00:00	1900-01-01 00:00:00	2021-12-31 00:00:00	1900-01-01 00:00:00	2021-06-30 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	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	22001	None	22001	None	22001	None	None	22001	None	None	22001	22001	22001	None	22001	None	None	None	None	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	22001	None	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	None	22001	22001	22001	None	22001	22001	22001	22001	None	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	None	22001	22001	22001

Table: filer_to_filer_type
filer_id	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148
filer_type	4	4	4	4	4	4	4	4	4	4	4	4	4
active	Y	Y	Y	Y	Y	Y	Y	Y	R	Y	Y	Y	Y
race	0	None	None	None	None	None	None	None	None	None	None	None	None
session_id	2001	2003	2005	2007	2011	2013	2009	2019	2019	2015	2019	2017	2021
category	0	None	None	None	None	None	None	None	None	None	None	None	None
category_type	0	None	None	None	None	None	None	None	None	None	None	None	None
sub_category	0	None	None	None	None	None	None	None	None	None	None	None	None
effect_dt	2001-04-01 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2009-01-01 00:00:00	2019-01-01 00:00:00	2019-06-30 00:00:00	2015-01-01 00:00:00	2020-03-18 00:00:00	2017-01-01 00:00:00	2021-01-01 00:00:00
sub_category_type	0	None	None	None	None	None	None	None	None	None	None	None	None
election_type	0	None	None	None	None	None	None	None	None	None	None	None	None
sub_category_a	None	None	None	None	None	None	None	None	None	None	None	None	None
nyq_dt	None	None	2001-04-01 00:00:00	2001-04-01 00:00:00	None	None	None	None	None	None	None	None	None
party_cd	0	None	None	None	None	None	None	None	None	None	None	None	None
county_cd	0	None	None	None	None	None	None	None	None	None	None	None	None
district_cd	0	None	None	None	None	None	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1235148
xref_id		1235148
effect_dt		2001-05-16 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148
filer_id	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148
filer_type	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST
status	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE	ACTIVE
effect_dt	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00
naml	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES	PAREDES
namf	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.	SAMUEL A.
namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
city	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	EL DORADO HILLS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	EL DORADO HILLS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	EL DORADO HILLS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	EL DORADO HILLS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	EL DORADO HILLS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	EL DORADO HILLS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	EL DORADO HILLS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	EL DORADO HILLS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	EL DORADO HILLS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	EL DORADO HILLS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FAIR OAKS	FOLSOM	FOLSOM	FOLSOM	FOLSOM	FOLSOM	EL DORADO HILLS
st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
zip4	95628	95628	95628	95628	95628	95630	95630	95630	95630	95630	95762	95628	95628	95628	95628	95628	95630	95630	95630	95630	95630	95762	95628	95628	95628	95628	95628	95630	95630	95630	95630	95630	95762	95628	95628	95628	95628	95628	95630	95630	95630	95630	95630	95762	95628	95628	95628	95628	95628	95630	95630	95630	95630	95630	95762	95628	95628	95628	95628	95628	95630	95630	95630	95630	95630	95762	95628	95628	95628	95628	95628	95630	95630	95630	95630	95630	95762	95628	95628	95628	95628	95628	95630	95630	95630	95630	95630	95762	95628	95628	95628	95628	95628	95630	95630	95630	95630	95630	95762	95628	95628	95628	95628	95628	95630	95630	95630	95630	95630	95762	95628	95628	95628	95628	95628	95630	95630	95630	95630	95630	95762
phon	9169674970	9169674970	9169674970	9169674970	9169674970	9169841400	9169841400	9169841400	9169841400	9169841400	9169841400	9169674970	9169674970	9169674970	9169674970	9169674970	9169841400	9169841400	9169841400	9169841400	9169841400	9169841400	9169674970	9169674970	9169674970	9169674970	9169674970	9169841400	9169841400	9169841400	9169841400	9169841400	9169841400	9169674970	9169674970	9169674970	9169674970	9169674970	9169841400	9169841400	9169841400	9169841400	9169841400	9169841400	9169674970	9169674970	9169674970	9169674970	9169674970	9169841400	9169841400	9169841400	9169841400	9169841400	9169841400	9169674970	9169674970	9169674970	9169674970	9169674970	9169841400	9169841400	9169841400	9169841400	9169841400	9169841400	9169674970	9169674970	9169674970	9169674970	9169674970	9169841400	9169841400	9169841400	9169841400	9169841400	9169841400	9169674970	9169674970	9169674970	9169674970	9169674970	9169841400	9169841400	9169841400	9169841400	9169841400	9169841400	9169674970	9169674970	9169674970	9169674970	9169674970	9169841400	9169841400	9169841400	9169841400	9169841400	9169841400	9169674970	9169674970	9169674970	9169674970	9169674970	9169841400	9169841400	9169841400	9169841400	9169841400	9169841400	9169674970	9169674970	9169674970	9169674970	9169674970	9169841400	9169841400	9169841400	9169841400	9169841400	9169841400
fax	9169674974	9169674974	9169674974	9169674974	9169674974	9169841402	9169841402	9169841402	9169841402	9169841402	9169841402	9169674974	9169674974	9169674974	9169674974	9169674974	9169841402	9169841402	9169841402	9169841402	9169841402	9169841402	9169674974	9169674974	9169674974	9169674974	9169674974	9169841402	9169841402	9169841402	9169841402	9169841402	9169841402	9169674974	9169674974	9169674974	9169674974	9169674974	9169841402	9169841402	9169841402	9169841402	9169841402	9169841402	9169674974	9169674974	9169674974	9169674974	9169674974	9169841402	9169841402	9169841402	9169841402	9169841402	9169841402	9169674974	9169674974	9169674974	9169674974	9169674974	9169841402	9169841402	9169841402	9169841402	9169841402	9169841402	9169674974	9169674974	9169674974	9169674974	9169674974	9169841402	9169841402	9169841402	9169841402	9169841402	9169841402	9169674974	9169674974	9169674974	9169674974	9169674974	9169841402	9169841402	9169841402	9169841402	9169841402	9169841402	9169674974	9169674974	9169674974	9169674974	9169674974	9169841402	9169841402	9169841402	9169841402	9169841402	9169841402	9169674974	9169674974	9169674974	9169674974	9169674974	9169841402	9169841402	9169841402	9169841402	9169841402	9169841402	9169674974	9169674974	9169674974	9169674974	9169674974	9169841402	9169841402	9169841402	9169841402	9169841402	9169841402
email	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]

Table: filers
filer_id		1235148

Table: lobbying_chg_log
filer_id	1235148	1235148	1235148	1235148	1235148	1235148
change_no	2	4	5	0	6	7
session_id	2001	2009	2011	2011	2017	2017
log_dt	2001-04-19 00:00:00	2009-06-23 00:00:00	2012-02-17 00:00:00	2012-01-27 00:00:00	2017-10-02 00:00:00	2017-10-02 00:00:00
filer_type	4	4	4	4	4	4
correction_flg	Y	Y	Y	None	None	Y
action	ADDED	ADDED	NEW	ADDED	SET ACTIVE	ADDED
attribute_changed	LOBBYIST	EMPLOYER	EMPLOYER	EMPLOYER		EMPLOYER
ethics_dt	None	None	None	None	None	None
interests	None	None	None	None	None	None
filer_full_name	PAREDES, SAMUEL A.	PAREDES, SAMUEL A.	PAREDES, SAMUEL A.	SAMUEL A. PAREDES	PAREDES, SAMUEL	PAREDES, SAMUEL
filer_city	None	None	None	None	None	None
filer_st	None	None	None	None	None	None
filer_zip	None	None	None	None	None	None
filer_phone	None	None	None	None	None	None
entity_type	4	2	2	2	4	2
entity_name	GUN OWNERS OF CALIFORNIA, INC.	GUN OWNERS OF CALIFORNIA, INC.	GUN OWNERS OF CALIFORNIA, INC.	GUN OWNERS OF CALIFORNIA, INC.	None	GUN OWNERS OF CALIFORNIA, INC.
entity_city	None	None	None	None	None	None
entity_st	None	None	None	None	None	None
entity_zip	None	None	None	None	None	None
entity_phone	None	None	None	None	None	None
entity_id	0	1147146	1147146	1147146	0	1147146
responsible_officer	None	None	None	None	None	None
effect_dt	2001-04-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2011-01-01 00:00:00	2017-01-01 00:00:00	2017-01-01 00:00:00

Table: received_filings
filer_id	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148	1235148
filing_file_name	769503_0.cal	129878.cal	790041_0.cal	807692_0.cal	836460_0.cal	286399.cal	850044_0.cal	880756_0.cal	907806_0.cal	927471_0.cal	943382_0.cal	964195_0.cal	984319_0.cal	1011251_0.cal	1026412_0.cal	1053714_0.cal	1078063_0.cal	1099351_0.cal	1111244_0.cal	1127415_0.cal	1144264_0.cal	1161344_0.cal	1185554_0.cal	1206972_0.cal	1499617_0.cal	1428678_0.cal	1401905_0.cal	1416558_0.cal	1342570_0.cal	1457101_0.cal	1447746_0.cal	1365666_0.cal	1227983_0.cal	1478980_0.cal	1276777_0.cal	1256339_0.cal	1292029_0.cal	1323311_0.cal	1315024_0.cal	1522458_0.cal	1670129_0.cal	1755088_0.cal	1836345_0.cal	1793024_0.cal	1696465_0.cal	1587719_0.cal	1557862_0.cal	1809947_0.cal	1599326_0.cal	1617098_0.cal	1774692_0.cal	1627397_0.cal	1722849_0.cal	1651065_0.cal	1861707_0.cal	1973729_0.cal	2148966_0.cal	2053698_0.cal	417612.cal	1973729_1.cal	2002774_0.cal	1991445_1.cal	2117208_0.cal	2085465_0.cal	2026268_0.cal	1891159_0.cal	1923601_0.cal	1991445_0.cal	1956826_0.cal	2165861_0.cal	2464790_0.cal	2228333_0.cal	2199749_0.cal	2388632_0.cal	2429784_0.cal	2411000_0.cal	2262865_0.cal	2370240_0.cal	2300346_0.cal	2334545_0.cal	2477359_0.cal	2544900_0.cal	2634681_0.cal	2509390_0.cal	2573353_0.cal	2698053_0.cal	2663407_0.cal	2593684_0.cal	2730367_0.cal	2614988_0.cal
received_date	2001-07-24 00:00:00	2001-07-24 00:00:00	2001-10-29 00:00:00	2002-01-16 00:00:00	2002-04-22 00:00:00	2002-04-30 00:00:00	2002-07-17 00:00:00	2002-10-27 00:00:00	2003-01-28 00:00:00	2003-04-15 00:00:00	2003-07-22 00:00:00	2003-10-16 00:00:00	2004-01-21 00:00:00	2004-04-26 00:00:00	2004-07-27 00:00:00	2004-10-25 00:00:00	2005-01-28 00:00:00	2005-04-07 00:00:00	2005-07-08 00:00:00	2005-10-06 00:00:00	2006-01-25 00:00:00	2006-04-10 00:00:00	2006-07-20 00:00:00	2006-10-12 00:00:00	2010-07-08 00:00:00	2009-07-02 00:00:00	2009-02-10 00:00:00	2009-04-08 00:00:00	2008-07-09 00:00:00	2010-01-08 00:00:00	2009-10-14 00:00:00	2008-10-13 00:00:00	2007-01-15 00:00:00	2010-04-10 00:00:00	2007-07-10 00:00:00	2007-04-11 00:00:00	2007-10-03 00:00:00	2008-04-06 00:00:00	2008-02-12 00:00:00	2010-10-05 00:00:00	2012-07-06 00:00:00	2013-04-05 00:00:00	2014-04-07 00:00:00	2013-10-08 00:00:00	2012-10-09 00:00:00	2011-04-22 00:00:00	2011-01-07 00:00:00	2014-01-14 00:00:00	2011-07-08 00:00:00	2011-10-11 00:00:00	2013-07-10 00:00:00	2012-01-09 00:00:00	2013-01-04 00:00:00	2012-04-06 00:00:00	2014-07-08 00:00:00	2015-07-10 00:00:00	2017-03-31 00:00:00	2016-07-06 00:00:00	2015-11-03 00:00:00	2015-11-03 00:00:00	2016-01-07 00:00:00	2015-11-03 00:00:00	2017-01-04 00:00:00	2016-10-05 00:00:00	2016-04-05 00:00:00	2014-10-02 00:00:00	2015-01-07 00:00:00	2015-10-12 00:00:00	2015-04-08 00:00:00	2017-07-06 00:00:00	2020-04-02 00:00:00	2018-04-04 00:00:00	2018-01-03 00:00:00	2019-07-02 00:00:00	2020-01-11 00:00:00	2019-10-01 00:00:00	2018-07-06 00:00:00	2019-04-04 00:00:00	2018-10-02 00:00:00	2019-01-15 00:00:00	2020-07-08 00:00:00	2021-01-18 00:00:00	2022-01-14 00:00:00	2020-10-03 00:00:00	2021-04-10 00:00:00	2022-07-13 00:00:00	2022-04-05 00:00:00	2021-07-15 00:00:00	2022-10-08 00:00:00	2021-10-09 00:00:00
filing_directory	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/cal	/usr/users/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	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/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	/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	769503	None	790041	807692	836460	None	850044	880756	907806	927471	943382	964195	984319	1011251	1026412	1053714	1078063	1099351	1111244	1127415	1144264	1161344	1185554	1206972	1499617	1428678	1401905	1416558	1342570	1457101	1447746	1365666	1227983	1478980	1276777	1256339	1292029	1323311	1315024	1522458	1670129	1755088	1836345	1793024	1696465	1587719	1557862	1809947	1599326	1617098	1774692	1627397	1722849	1651065	1861707	1973729	2148966	2053698	None	1973729	2002774	1991445	2117208	2085465	2026268	1891159	1923601	1991445	1956826	2165861	2464790	2228333	2199749	2388632	2429784	2411000	2262865	2370240	2300346	2334545	2477359	2544900	2634681	2509390	2573353	2698053	2663407	2593684	2730367	2614988
form_id	F615	None	F615	F615	F615	None	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	None	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615
receive_comment	Filing accepted	Filing passed validation, but failed DB constraints	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	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing 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	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted