OpenCalAccess

Filer ID: 1297904

Table: cvr_lobby_disclosure
filing_id	1282667	1329275	1295780	1347838	1307568	1372591	1419522	1447709	1395617	1432211	1459043	1538427	1501608	1484692	1565474	1618134	1601061	1592625	1634502	1709633	1675687	1634502	1656228	1740266	1784193	1800752	1764886	1815983	1845447	1865134	1911736	1962473	1975913	1933854	1996592	2061353	2036126	2007620	2158915	2167962	2156046	2133610	2270362	2243163	2243163	2193461	2209217	2320485	2397834	2380040	2380040	2380040	2335724	2320485	2468553	2443860	2419262	2554086	2554114	2483132	2620449	2578619	2578620	2595817	2667952	2639076
amend_id	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	1	0	0	0	1	0	2	1	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
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
sender_id	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1297904	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1297904	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205
filer_id	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904
entity_cd	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	FRM	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	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
filer_naml	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN
filer_namf	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.
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
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
report_num	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000	001	000	000	000	001	000	002	001	000	000	000	000	000	000	000	000	000	000	000	000	000	000	000
rpt_date	2007-07-30 00:00:00	2008-04-28 00:00:00	2007-10-29 00:00:00	2008-07-11 00:00:00	2008-01-28 00:00:00	2008-10-27 00:00:00	2009-04-28 00:00:00	2009-10-23 00:00:00	2009-01-30 00:00:00	2009-07-21 00:00:00	2010-01-21 00:00:00	2010-10-29 00:00:00	2010-07-20 00:00:00	2010-04-30 00:00:00	2011-01-25 00:00:00	2011-10-28 00:00:00	2011-07-19 00:00:00	2011-04-30 00:00:00	2012-01-13 00:00:00	2012-10-30 00:00:00	2012-07-27 00:00:00	2012-03-19 00:00:00	2012-04-20 00:00:00	2013-01-17 00:00:00	2013-07-30 00:00:00	2013-10-31 00:00:00	2013-04-30 00:00:00	2014-01-31 00:00:00	2014-04-30 00:00:00	2014-07-22 00:00:00	2014-10-31 00:00:00	2015-04-30 00:00:00	2015-07-22 00:00:00	2015-01-30 00:00:00	2015-10-30 00:00:00	2016-07-30 00:00:00	2016-03-31 00:00:00	2016-01-13 00:00:00	2017-05-05 00:00:00	2017-04-28 00:00:00	2017-04-28 00:00:00	2016-12-31 00:00:00	2018-07-27 00:00:00	2018-04-30 00:00:00	2018-04-30 00:00:00	2017-10-31 00:00:00	2018-01-30 00:00:00	2018-10-31 00:00:00	2019-07-30 00:00:00	2019-04-30 00:00:00	2019-04-30 00:00:00	2018-04-30 00:00:00	2019-01-20 00:00:00	2018-10-31 00:00:00	2020-04-29 00:00:00	2020-01-31 00:00:00	2019-10-31 00:00:00	2020-07-29 00:00:00	2020-12-31 00:00:00	2020-07-29 00:00:00	2021-10-31 00:00:00	2021-04-29 00:00:00	2021-04-29 00:00:00	2021-07-22 00:00:00	2022-04-20 00:00:00	2022-01-27 00:00:00
from_date	2007-04-01 00:00:00	2008-01-01 00:00:00	2007-07-01 00:00:00	2008-04-01 00:00:00	2007-10-01 00:00:00	2008-07-01 00:00:00	2009-01-01 00:00:00	2009-07-01 00:00:00	2008-10-01 00:00:00	2009-04-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-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	2011-10-01 00:00:00	2012-01-01 00:00:00	2012-10-01 00:00:00	2013-04-01 00:00:00	2013-07-01 00:00:00	2013-01-01 00:00:00	2013-10-01 00:00:00	2014-01-01 00:00:00	2014-04-01 00:00:00	2014-07-01 00:00:00	2015-01-31 00:00:00	2015-04-01 00:00:00	2014-10-01 00:00:00	2015-07-01 00:00:00	2016-04-01 00:00:00	2016-01-01 00:00:00	2015-10-01 00:00:00	2016-07-01 00:00:00	2017-04-01 00:00:00	2017-01-01 00:00:00	2016-10-01 00:00:00	2018-04-01 00:00:00	2018-01-01 00:00:00	2018-01-01 00:00:00	2017-07-01 00:00:00	2017-10-01 00:00:00	2018-07-01 00:00:00	2019-04-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2018-10-01 00:00:00	2018-07-01 00:00:00	2020-01-01 00:00:00	2019-10-01 00:00:00	2019-07-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	2020-04-01 00:00:00	2021-07-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2021-04-01 00:00:00	2022-01-01 00:00:00	2021-10-01 00:00:00
thru_date	2007-06-30 00:00:00	2008-03-31 00:00:00	2007-09-30 00:00:00	2008-06-30 00:00:00	2007-12-31 00:00:00	2008-09-30 00:00:00	2009-03-30 00:00:00	2009-09-30 00:00:00	2008-12-31 00:00:00	2009-06-30 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-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	2011-12-31 00:00:00	2012-03-31 00:00:00	2012-12-31 00:00:00	2013-06-30 00:00:00	2013-09-30 00:00:00	2013-03-31 00:00:00	2013-12-31 00:00:00	2014-03-31 00:00:00	2014-06-30 00:00:00	2014-09-30 00:00:00	2015-03-31 00:00:00	2015-06-30 00:00:00	2014-12-31 00:00:00	2015-09-30 00:00:00	2016-06-30 00:00:00	2016-03-31 00:00:00	2015-12-31 00:00:00	2016-09-30 00:00:00	2017-06-30 00:00:00	2017-03-31 00:00:00	2016-12-31 00:00:00	2018-06-30 00:00:00	2018-03-31 00:00:00	2018-03-31 00:00:00	2017-09-30 00:00:00	2017-12-31 00:00:00	2018-09-30 00:00:00	2019-06-30 00:00:00	2019-03-31 00:00:00	2019-03-31 00:00:00	2019-03-31 00:00:00	2018-12-30 00:00:00	2018-10-31 00:00:00	2020-03-31 00:00:00	2019-12-31 00:00:00	2019-09-30 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-03-31 00:00:00	2021-03-31 00:00:00	2021-06-30 00:00:00	2022-03-31 00:00:00	2021-12-31 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
firm_id	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1297904	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1297904	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205
firm_name	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego District Attorney	San Diego District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney's Office	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney	San Diego County District Attorney's Office	San Diego County District Attorney
firm_city	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	SAN DIEGO	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	SAN DIEGO	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego	San Diego
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
firm_zip4	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101
firm_phon	619-531-4304	619-531-4304	619-531-4304	619-531-4304	619-531-4304	619-531-4304	619-531-4304	619-531-4304	619-531-4304	619-531-4304	619-531-4304	619-531-4304	619-531-4304	619-531-4304	619-531-4304	619-531-4016	619-531-4016	619-531-4304	619-531-4016	619-531-4016	619-531-4016	6195313790	619-531-4016	619-531-4016	619-531-4016	619-531-4016	619-531-4016	619-531-4016	619-531-4016	619-531-4016	619-531-4016	619-531-4016	619-531-4016	619-531-4016	619-531-4016	619-531-4016	619-531-4016	619-531-4016	6195313790	619-895-0327	619-895-0327	619-531-4016	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	619-895-0327	(619) 895-0327	619-895-0327
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
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
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
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
sig_date	2007-07-30 00:00:00	2008-04-30 00:00:00	2007-10-29 00:00:00	2008-07-29 00:00:00	2008-01-28 00:00:00	2008-10-27 00:00:00	2009-04-28 00:00:00	2009-10-14 00:00:00	2009-01-30 00:00:00	2009-07-21 00:00:00	2010-01-21 00:00:00	2010-10-29 00:00:00	2010-07-20 00:00:00	2010-04-30 00:00:00	2011-11-24 00:00:00	2011-10-19 00:00:00	2011-07-19 00:00:00	2011-05-04 00:00:00	2012-01-30 00:00:00	2012-10-31 00:00:00	2012-07-27 00:00:00	2012-03-19 00:00:00	2012-04-27 00:00:00	2013-01-21 00:00:00	2013-08-01 00:00:00	2013-10-31 00:00:00	2013-04-30 00:00:00	2014-01-30 00:00:00	2014-04-30 00:00:00	2014-07-22 00:00:00	2014-10-31 00:00:00	2015-04-27 00:00:00	2015-07-22 00:00:00	5464-10-16 00:00:00	2015-10-30 00:00:00	2016-07-29 00:00:00	2016-04-29 00:00:00	2016-01-27 00:00:00	2016-10-21 00:00:00	2017-07-17 00:00:00	2017-04-28 00:00:00	2016-01-30 00:00:00	2018-07-27 00:00:00	2018-04-30 00:00:00	2018-04-30 00:00:00	2017-10-31 00:00:00	2018-01-30 00:00:00	2018-10-31 00:00:00	2019-07-31 00:00:00	2019-06-19 00:00:00	2020-06-19 00:00:00	2019-04-30 00:00:00	2019-01-18 00:00:00	2018-10-31 00:00:00	2020-04-29 00:00:00	2020-01-31 00:00:00	2019-10-31 00:00:00	2020-09-30 00:00:00	2020-01-29 00:00:00	2020-07-29 00:00:00	2021-10-27 00:00:00	2021-04-29 00:00:00	2021-04-29 00:00:00	2021-07-22 00:00:00	2022-04-14 00:00:00	2022-01-27 00:00:00
sig_loc	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego California	San Diego	San Diego California	San Diego California	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO CA	San Diego	SAN DIEGO	SAN DIEGO	San Diego	SAN DIEGO CA	San Diego CA	SAN DIEGO	San Diego CA	SAN DIEGO	San Diego, CA	San Diego California	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	San Diego CA	SAN DIEGO CA	San Diego
sig_naml	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Dumanis	Stewart-Brockman	Dumanis	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART BROCKMAN	STEWART-BROCKMAN	Stewart-Brockman	STEWART-BROCKMAN	STEWART-BROCKMAN	Gail	STEWART-BROCKMAN	Stewart-Brockman	STEWART-BROCKMAN	Stewart-Brockman	STEWART-BROCKMAN	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Gail	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman
sig_namf	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Bonnie	Gail	Bonnie	Gail	Gail	Gail	GAIL	GAIL	GAIL	GAIL	GAIL	Gail	GAIL	GAIL	Stewart-Brockman	GAIL	Gail	GAIL	Gail	GAIL	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Gail	Stewart-Brockman	Gail	Gail	Gail	Gail	Gail	Gail	Gail
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	Ms.	None	None	None	None	None	Ms.	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
prn_naml	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Stewart-Brockman	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Stewart-Brockman	None	None	None	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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Gail	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Gail	None	None	None	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
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
sig_title	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	Special Assistant	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	None	X	None	None	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X
nopart2_cb	X	X	X	X	X	None	None	X	None	None	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	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
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
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
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
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
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
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
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
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
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
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
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
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

Table: cvr_registration
filing_id	1425514	1611212	1719717	1753267	1753375	2116845	2582377	2664535	2740638
amend_id	0	0	0	0	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	F606	F604
sender_id	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205	1298205
filer_id	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904
entity_cd	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY	LBY
filer_naml	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN
filer_namf	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL	GAIL J.	GAIL J.	GAIL J.
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	000	000	000	000	000	000
rpt_date	2009-06-03 00:00:00	2011-08-05 00:00:00	2012-12-24 00:00:00	2012-12-24 00:00:00	2012-12-24 00:00:00	2017-01-03 00:00:00	2020-12-11 00:00:00	2022-04-08 00:00:00	2022-10-25 00:00:00
ls_beg_yr	2009	2011	2012	2012	2013	2017	2021	2021	2021
ls_end_yr	2010	2012	2013	2013	2014	2018	2022	2022	2022
qual_date	2007-04-01 00:00:00	2007-04-01 00:00:00	None	None	None	None	None	None	None
eff_date	None	None	None	None	None	None	None	2022-03-24 00:00:00	None
bus_city	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO
bus_st	CA	CA	CA	CA	CA	CA	CA	CA	CA
bus_zip4	92101	92101	92101	92101	92101	92101	92101	92101	92101
bus_phon	619-531-3790	619-531-3790	619-531-3790	619-531-3790	619-531-3790	6195313790	619-531-3790	6195313968	6198671554
bus_fax	None	None	None	None	None	None	None	None	None
bus_email	None	None	None	None	None	[email protected]	None	None	[email protected]
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	2009-06-03 00:00:00	2011-08-05 00:00:00	2012-12-24 00:00:00	2012-12-24 00:00:00	2012-12-24 00:00:00	2017-01-03 00:00:00	2020-12-11 00:00:00	2020-04-07 00:00:00	2022-10-25 00:00:00
sig_loc	None	None	None	None	None	None	None	San Diego California	None
sig_naml	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	Stewart-Brockman	STEWART-BROCKMAN	Stewart-Brockman	None	Stewart-Brockman
sig_namf	Gail	Gail	Gail	Gail	Gail	GAIL	Gail	None	Gail
sig_namt	None	None	None	None	None	None	None	None	None
sig_nams	None	None	None	None	None	None	None	None	None
prn_naml	None	None	None	None	None	STEWART-BROCKMAN	None	Stephan	None
prn_namf	None	None	None	None	None	GAIL	None	Summer	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	San Diego County District Attorney	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	SAN DEIGO DISTRICT ATTORNEY	SAN DEIGO DISTRICT ATTORNEY	SAN DEIGO DISTRICT ATTORNEY	SAN DEIGO DISTRICT ATTORNEY	SAN DEIGO DISTRICT ATTORNEY	San Diego County District Attorney's Office	SAN DEIGO DISTRICT ATTORNEY	San Diego County District Attorney's Office	SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE
newcert_cb	None	None	None	None	None	None	None	None	X
rencert_cb	None	None	X	X	None	None	None	None	None
complet_dt	2009-03-19 00:00:00	2011-06-23 00:00:00	None	None	2013-02-28 00:00:00	2016-09-09 00:00:00	2020-11-17 00:00:00	None	None
lby_reg_cb	X	X	X	X	X	X	X	None	None
lby_604_cb	None	None	None	None	None	None	None	None	X
st_leg_yn	Y	Y	Y	Y	Y	Y	Y	None	Y
st_agency	None	None	None	None	None	None	None	None	California State Senate California State Assembly and the Governor's Office
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	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904
adrid	2123219	2161021	2411904	2276364	2506359	2467182	2338786	2219626
effect_dt	2007-04-30 00:00:00	2009-01-01 00:00:00	2017-01-01 00:00:00	2013-01-01 00:00:00	2021-01-01 00:00:00	2019-01-01 00:00:00	2015-01-31 00:00:00	2011-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051
session_id	2007	2009	2017	2013	2021	2019	2015	2011

Table: filer_ethics_class
filer_id	1297904	1297904	1297904	1297904	1297904	1297904	1297904
session_id	2007	2011	2009	2013	2015	2019	2021
ethics_date	2007-11-29 00:00:00	2011-06-23 00:00:00	2009-03-19 00:00:00	2013-02-28 00:00:00	2015-02-26 00:00:00	2018-09-14 00:00:00	2020-11-17 00:00:00

Table: filer_filings
filer_id	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904
filing_id	1282667	1264696	1267717	1307568	1295780	1301466	1784193	1975913	1962473	1865134	1800752	1952352	1933854	1911736	1329275	1372591	1347838	1395617	1432211	1425514	1427767	1419522	1425542	1447709	1501608	1484692	1459043	1538427	1565474	1597886	1592625	1613394	1601061	1634502	1611212	1618134	1634502	1656228	1675687	1815983	1719717	1709633	1740266	1845447	1767125	1753375	1764886	1751816	1753267	1996592	2243163	2320485	2270362	2397834	2380040	2380040	2483132	2024330	2007620	2036126	2061353	2122797	2116845	2148523	2133610	2156046	2158915	2335750	2167962	2209217	2468553	2320485	2443860	2554086	2554114	2335724	2380040	2243163	2193461	2419262	2667952	2578620	2620449	2683291	2639076	2578619	2664535	2547303	2582377	2595817	2754225	2740638
period_id	190	None	None	192	191	None	214	222	221	218	215	None	220	219	193	195	194	196	198	198	None	197	None	199	202	201	200	203	204	None	205	None	206	208	207	207	208	209	210	216	212	211	212	217	None	212	213	None	212	223	233	235	234	238	237	237	242	None	224	225	226	None	229	None	228	229	227	None	230	232	241	235	240	243	244	236	237	233	231	239	249	245	247	None	248	245	250	None	244	246	None	252
form_id	F615	F604	F999	F615	F615	F604	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F604	F604	F615	F604	F615	F615	F615	F615	F615	F615	F604	F615	F604	F615	F615	F604	F615	F615	F615	F615	F615	F604	F615	F615	F615	F604	F604	F615	F604	F604	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F604	F604	F604	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F606	F615	F615	F606	F604	F604	F615	F604	F604
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	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
filing_date	2007-07-30 00:00:00	2007-04-30 00:00:00	2007-05-21 00:00:00	2008-01-28 00:00:00	2007-10-29 00:00:00	2007-12-19 00:00:00	2013-08-01 00:00:00	2015-07-22 00:00:00	2015-04-27 00:00:00	2014-07-22 00:00:00	2013-10-31 00:00:00	2015-02-26 00:00:00	2015-01-30 00:00:00	2014-10-31 00:00:00	2008-04-30 00:00:00	2008-10-27 00:00:00	2008-07-29 00:00:00	2009-01-30 00:00:00	2009-07-21 00:00:00	2009-06-03 00:00:00	2009-06-17 00:00:00	2009-04-28 00:00:00	2009-03-26 00:00:00	2009-10-14 00:00:00	2010-07-20 00:00:00	2010-04-30 00:00:00	2010-01-21 00:00:00	2010-10-29 00:00:00	2011-01-25 00:00:00	2011-06-23 00:00:00	2011-05-04 00:00:00	2011-08-09 00:00:00	2011-07-19 00:00:00	2012-01-30 00:00:00	2011-08-05 00:00:00	2011-10-19 00:00:00	2012-03-19 00:00:00	2012-04-27 00:00:00	2012-07-27 00:00:00	2014-01-30 00:00:00	2012-12-24 00:00:00	2012-10-31 00:00:00	2013-01-31 00:00:00	2014-04-30 00:00:00	2013-03-22 00:00:00	2013-03-19 00:00:00	2013-04-30 00:00:00	2013-02-28 00:00:00	2013-03-18 00:00:00	2015-10-30 00:00:00	2018-04-30 00:00:00	2018-10-31 00:00:00	2018-07-26 00:00:00	2019-07-31 00:00:00	2019-06-19 00:00:00	2019-04-30 00:00:00	2020-07-29 00:00:00	2016-03-23 00:00:00	2016-01-27 00:00:00	2016-04-29 00:00:00	2016-07-29 00:00:00	2017-01-03 00:00:00	2017-01-03 00:00:00	2017-03-27 00:00:00	2017-02-06 00:00:00	2017-04-28 00:00:00	2017-05-05 00:00:00	2018-11-13 00:00:00	2017-07-17 00:00:00	2018-01-30 00:00:00	2020-04-29 00:00:00	2018-10-31 00:00:00	2020-01-31 00:00:00	2021-02-01 00:00:00	2021-02-01 00:00:00	2019-01-18 00:00:00	2019-06-19 00:00:00	2018-04-30 00:00:00	2017-10-31 00:00:00	2019-10-31 00:00:00	2022-04-20 00:00:00	2021-04-29 00:00:00	2021-10-27 00:00:00	2022-04-18 00:00:00	2022-01-27 00:00:00	2021-04-29 00:00:00	2022-04-08 00:00:00	2020-12-22 00:00:00	2021-05-04 00:00:00	2021-07-22 00:00:00	2022-10-31 00:00:00	2022-10-25 00:00:00
stmnt_type	10001	10005	10005	10001	10001	10002	10001	10001	10001	10001	10001	10006	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10002	10001	10001	10001	10001	10001	10001	10006	10001	10005	10001	10001	10001	10001	10002	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10006	10001	10001	10002	10002	10001	10001	10002	10001	10001	10005	10001	10001	10001	10005	10001	10006	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10002	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10005	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	11003	11003	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	11001	11001	11001
session_id	2007	2007	2007	2007	2007	2007	2013	2015	2015	2013	2013	2015	2013	2013	2007	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2013	2012	2011	2011	2013	2013	2013	2013	2013	2012	2015	2017	2017	2017	2019	2019	2019	2019	2015	2015	2015	2015	2017	2017	2017	2015	2017	2015	2019	2017	2017	2019	2017	2019	2019	2019	2017	2019	2017	2017	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	LTHIBAUL	SARRIAGA	GPEREZ	LTHIBAUL	LTHIBAUL	GPEREZ	RGEREMIA	AGLADNEY	AGLADNEY	ASAETERN	ASAETERN	ASAETERN	AGLADNEY	AGLADNEY	LTHIBAUL	JINGRAM	LTHIBAUL	JINGRAM	MGUERRA	PBANFORD	PBANFORD	MGUERRA	PBANFORD	MGUERRA	MGUERRA	JINGRAM	MGUERRA	ASAETERN	AGLADNEY	PBANFORD	ASAETERN	YRODRIGU	ASAETERN	ASAETERN	YRODRIGU	JINGRAM	ASAETERN	ASAETERN	AGLADNEY	ASAETERN	YRODRIGU	ASAETERN	ASAETERN	AGLADNEY	YRODRIGU	YRODRIGU	AGLADNEY	SMCCONNAN	YRODRIGU	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	VUKSTINA	VUKSTINA	SUSHAKOV	VUKSTINA	YRODRIGU	AGLADNEY	YRODRIGU	AGLADNEY	SARRIAGA	CAFILER	SARRIAGA	AGLADNEY	SMCCONNAN	SMCCONNAN	DMCCASTL	SMCCONNAN	AGLADNEY	VUKSTINA	AGLADNEY	VUKSTINA	LPHEAV	GTAYLOR	AGLADNEY	VUKSTINA	AGLADNEY	SMCCONNAN	VUKSTINA	CHATRIDGE	CHARTRIDGE	CHATRIDGE	CVANLIEW	CAFILER	CHARTRIDGE	CVANLIEW	CVANLIEW	CAFILER	CHATRIDGE	NKRESTOFF	NKRESTOFF
special_audit	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11003	11003	11003	11001	11003	11003
rpt_start	2007-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-10-01 00:00:00	2007-07-01 00:00:00	1900-01-01 00:00:00	2013-04-01 00:00:00	2015-04-01 00:00:00	2015-01-31 00:00:00	2014-04-01 00:00:00	2013-07-01 00:00:00	None	2014-10-01 00:00:00	2014-07-01 00:00:00	2008-01-01 00:00:00	2008-07-01 00:00:00	2008-04-01 00:00:00	2008-10-01 00:00:00	2009-04-01 00:00:00	2009-06-03 00:00:00	1900-01-01 00:00:00	2009-01-01 00:00:00	1900-01-01 00:00:00	2009-07-01 00:00:00	2010-04-01 00:00:00	2010-01-01 00:00:00	2009-10-01 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	1900-01-01 00:00:00	2011-01-01 00:00:00	1900-01-01 00:00:00	2011-04-01 00:00:00	2011-10-01 00:00:00	2011-08-05 00:00:00	2011-07-01 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	2012-04-01 00:00:00	2013-10-01 00:00:00	2012-12-24 00:00:00	2012-07-01 00:00:00	2012-10-01 00:00:00	2014-01-01 00:00:00	1900-01-01 00:00:00	2012-12-24 00:00:00	2013-01-01 00:00:00	1900-01-01 00:00:00	2012-12-24 00:00:00	2015-07-01 00:00:00	2018-01-01 00:00:00	2018-07-01 00:00:00	2018-04-01 00:00:00	2019-04-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2020-04-01 00:00:00	1900-01-01 00:00:00	2015-10-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	1900-01-01 00:00:00	2017-01-03 00:00:00	1900-01-01 00:00:00	2016-10-01 00:00:00	2017-01-01 00:00:00	2016-07-01 00:00:00	1900-01-01 00:00:00	2017-04-01 00:00:00	2017-10-01 00:00:00	2020-01-01 00:00:00	2018-07-01 00:00:00	2019-10-01 00:00:00	2020-07-01 00:00:00	2020-10-01 00:00:00	2018-10-01 00:00:00	2019-01-01 00:00:00	2018-01-01 00:00:00	2017-07-01 00:00:00	2019-07-01 00:00:00	2022-01-01 00:00:00	2021-01-01 00:00:00	2021-07-01 00:00:00	1900-01-01 00:00:00	2021-10-01 00:00:00	2021-01-01 00:00:00	2022-04-08 00:00:00	1900-01-01 00:00:00	2020-12-11 00:00:00	2021-04-01 00:00:00	1900-01-01 00:00:00	2022-10-25 00:00:00
rpt_end	2007-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-12-31 00:00:00	2007-09-30 00:00:00	1900-01-01 00:00:00	2013-06-30 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	None	2014-12-31 00:00:00	2014-09-30 00:00:00	2008-03-31 00:00:00	2008-09-30 00:00:00	2008-06-30 00:00:00	2008-12-31 00:00:00	2009-06-30 00:00:00	2009-06-03 00:00:00	1900-01-01 00:00:00	2009-03-30 00:00:00	1900-01-01 00:00:00	2009-09-30 00:00:00	2010-06-30 00:00:00	2010-03-31 00:00:00	2009-12-31 00:00:00	2010-09-30 00:00:00	2010-12-31 00:00:00	1900-01-01 00:00:00	2011-03-31 00:00:00	1900-01-01 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	2011-08-05 00:00:00	2011-09-30 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	2012-06-30 00:00:00	2013-12-31 00:00:00	2012-12-24 00:00:00	2012-09-30 00:00:00	2012-12-31 00:00:00	2014-03-31 00:00:00	1900-01-01 00:00:00	2012-12-24 00:00:00	2013-03-31 00:00:00	1900-01-01 00:00:00	2012-12-24 00:00:00	2015-09-30 00:00:00	2018-03-31 00:00:00	2018-09-30 00:00:00	2018-06-30 00:00:00	2019-06-30 00:00:00	2019-03-31 00:00:00	2019-03-31 00:00:00	2020-06-30 00:00:00	1900-01-01 00:00:00	2015-12-31 00:00:00	2016-03-31 00:00:00	2016-06-30 00:00:00	1900-01-01 00:00:00	2017-01-03 00:00:00	1900-01-01 00:00:00	2016-12-31 00:00:00	2017-03-31 00:00:00	2016-09-30 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	2017-12-31 00:00:00	2020-03-31 00:00:00	2018-10-31 00:00:00	2019-12-31 00:00:00	2020-09-30 00:00:00	2020-12-31 00:00:00	2018-12-30 00:00:00	2019-03-31 00:00:00	2018-03-31 00:00:00	2017-09-30 00:00:00	2019-09-30 00:00:00	2022-03-31 00:00:00	2021-03-31 00:00:00	2021-09-30 00:00:00	1900-01-01 00:00:00	2021-12-31 00:00:00	2021-03-31 00:00:00	2022-04-08 00:00:00	1900-01-01 00:00:00	2020-12-11 00:00:00	2021-06-30 00:00:00	1900-01-01 00:00:00	2022-10-25 00:00:00
rpt_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filing_type	22001	None	None	22001	22001	None	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	None	22001	22001	22001	22001	22001	22001	None	22001	None	22001	22001	22001	22001	22006	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	None	22006	None	22001	22001	22006	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	None	22001	22001	None	22001

Table: filer_to_filer_type
filer_id	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904
filer_type	4	4	4	4	4	4	4	4	4	4
active	Y	Y	Y	Y	Y	Y	Y	Y	Y	T
race	0	None	None	None	None	None	None	None	None	None
session_id	2007	2013	2009	2011	2019	2021	2015	2017	2021	2021
category	0	None	None	None	None	None	None	None	None	None
category_type	0	None	None	None	None	None	None	None	None	None
sub_category	0	None	None	None	None	None	None	None	None	None
effect_dt	2007-04-30 00:00:00	2013-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2015-01-31 00:00:00	2017-01-01 00:00:00	2022-10-21 00:00:00	2022-03-24 00:00:00
sub_category_type	0	None	None	None	None	None	None	None	None	None
election_type	0	None	None	None	None	None	None	None	None	None
sub_category_a	None	None	None	None	None	None	None	None	None	None
nyq_dt	None	None	None	None	None	None	None	None	None	None
party_cd	0	None	None	None	None	None	None	None	None	None
county_cd	0	None	None	None	None	None	None	None	None	None
district_cd	0	None	None	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1297904
xref_id		1297904
effect_dt		2007-05-09 00:00:00
migration_source		CLAIMS

Table: filername
xref_filer_id	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904
filer_id	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904
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
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
effect_dt	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00	2022-10-21 00:00:00
naml	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN	STEWART-BROCKMAN
namf	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL	GAIL	GAIL	GAIL	GAIL	GAIL	GAIL	GAIL	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL	GAIL	GAIL	GAIL	GAIL	GAIL	GAIL	GAIL	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.	GAIL J.
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
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
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
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
city	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO	SAN DIEGO
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
zip4	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101	92101
phon	6198950327	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6198950327	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6198950327	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6198950327	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6198950327	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6198950327	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6198950327	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6198950327	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790	6195313790
fax	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
email	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	[email protected]

Table: filers
filer_id		1297904

Table: lobbying_chg_log
filer_id	1297904	1297904	1297904	1297904	1297904
change_no	1	0	3	4	5
session_id	2007	2007	2009	2011	2013
log_dt	2007-12-19 00:00:00	2007-05-18 00:00:00	2009-06-17 00:00:00	2011-08-09 00:00:00	2013-03-22 00:00:00
filer_type	4	4	4	4	4
correction_flg	None	Y	Y	Y	Y
action	None	ADDED	ADDED	ADDED	ADDED
attribute_changed	ETHICS DATE	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER
ethics_dt	2007-11-29 00:00:00	None	None	None	None
interests	None	None	None	None	None
filer_full_name	STEWART-BROCKMAN, GAIL J.	STEWART-BROCKMAN, GAIL J.	STEWART-BROCKMAN, GAIL J.	STEWART-BROCKMAN, GAIL J.	STEWART-BROCKMAN, GAIL J.
filer_city	None	None	None	SAN DIEGO	None
filer_st	None	None	None	CA	None
filer_zip	None	None	None	92101	None
filer_phone	None	None	None	6198950327	None
entity_type	4	2	2	2	1
entity_name	None	SAN DIEGO DISTRICT ATTORNEY	SAN DIEGO DISTRICT ATTORNEY	SAN DIEGO DISTRICT ATTORNEY	SAN DIEGO DISTRICT ATTORNEY
entity_city	None	None	None	None	None
entity_st	None	None	None	None	None
entity_zip	None	None	None	None	None
entity_phone	None	None	None	None	None
entity_id	0	1298205	1298205	None	1298205
responsible_officer	None	None	None	None	None
effect_dt	2007-11-29 00:00:00	2007-05-18 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00

Table: received_filings
filer_id	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904	1297904
filing_file_name	1501608_0.cal	1395617_0.cal	1347838_0.cal	1484692_0.cal	1459043_0.cal	1447709_0.cal	1282667_0.cal	1419522_0.cal	1425514_0.cal	1432211_0.cal	1295780_0.cal	1372591_0.cal	1307568_0.cal	1329275_0.cal	1845447_0.cal	1753267_0.cal	1753375_0.cal	1740266_0.cal	1675687_0.cal	1800752_0.cal	1784193_0.cal	1538427_0.cal	1565474_0.cal	1815983_0.cal	1592625_0.cal	1601061_0.cal	1611212_0.cal	1618134_0.cal	1764886_0.cal	1656228_0.cal	1634502_0.cal	1709633_0.cal	1719717_0.cal	1865134_0.cal	2156046_0.cal	400649.cal	400772.cal	2133610_0.cal	400564.cal	2061353_0.cal	2007620_0.cal	1996592_0.cal	2116845_0.cal	1911736_0.cal	2036126_0.cal	1975913_0.cal	1962473_0.cal	1933854_0.cal	2167962_0.cal	496481.cal	496637.cal	2270362_0.cal	2320485_1.cal	123752.cal	2243163_1.cal	2380040_2.cal	2468553_0.cal	2380040_0.cal	2397834_0.cal	2209217_0.cal	2320485_0.cal	2419262_0.cal	2380040_1.cal	2335724_0.cal	2243163_0.cal	123836.cal	2193461_0.cal	2443860_0.cal	2483132_0.cal	2667952_0.cal	2740638_0.cal	2578620_0.cal	2578619_0.cal	2595817_0.cal	2554114_0.cal	2620449_0.cal	2554086_0.cal	2639076_0.cal	2582377_0.cal
received_date	2010-07-20 00:00:00	2009-01-30 00:00:00	2008-07-29 00:00:00	2010-04-30 00:00:00	2010-01-21 00:00:00	2009-10-14 00:00:00	2007-07-30 00:00:00	2009-04-28 00:00:00	2009-06-03 00:00:00	2009-07-21 00:00:00	2007-10-29 00:00:00	2008-10-27 00:00:00	2008-01-28 00:00:00	2008-04-30 00:00:00	2014-04-30 00:00:00	2013-03-18 00:00:00	2013-03-19 00:00:00	2013-01-31 00:00:00	2012-07-27 00:00:00	2013-10-31 00:00:00	2013-08-01 00:00:00	2010-10-29 00:00:00	2011-01-25 00:00:00	2014-01-30 00:00:00	2011-05-04 00:00:00	2011-07-19 00:00:00	2011-08-05 00:00:00	2011-10-19 00:00:00	2013-04-30 00:00:00	2012-04-27 00:00:00	2012-01-30 00:00:00	2012-10-31 00:00:00	2012-12-24 00:00:00	2014-07-22 00:00:00	2017-04-28 00:00:00	2017-02-06 00:00:00	2017-02-06 00:00:00	2017-02-06 00:00:00	2017-02-06 00:00:00	2016-07-29 00:00:00	2016-01-27 00:00:00	2015-10-30 00:00:00	2017-01-03 00:00:00	2014-10-31 00:00:00	2016-04-29 00:00:00	2015-07-22 00:00:00	2015-04-27 00:00:00	2015-01-30 00:00:00	2017-07-17 00:00:00	2017-05-01 00:00:00	2017-05-01 00:00:00	2018-07-26 00:00:00	2018-10-31 00:00:00	2018-04-30 00:00:00	2018-04-30 00:00:00	2019-06-19 00:00:00	2020-04-29 00:00:00	2019-04-30 00:00:00	2019-07-31 00:00:00	2018-01-30 00:00:00	2018-10-31 00:00:00	2019-10-31 00:00:00	2019-06-19 00:00:00	2019-01-18 00:00:00	2018-04-30 00:00:00	2018-04-30 00:00:00	2017-10-31 00:00:00	2020-01-31 00:00:00	2020-07-29 00:00:00	2022-04-20 00:00:00	2022-10-25 00:00:00	2021-04-29 00:00:00	2021-04-29 00:00:00	2021-07-22 00:00:00	2021-02-01 00:00:00	2021-10-27 00:00:00	2021-02-01 00:00:00	2022-01-27 00:00:00	2021-05-04 00:00:00
filing_directory	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/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/temp	/cafiler/disclose/ca99/temp	/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/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
filing_id	1501608	1395617	1347838	1484692	1459043	1447709	1282667	1419522	1425514	1432211	1295780	1372591	1307568	1329275	1845447	1753267	1753375	1740266	1675687	1800752	1784193	1538427	1565474	1815983	1592625	1601061	1611212	1618134	1764886	1656228	1634502	1709633	1719717	1865134	2156046	None	None	2133610	None	2061353	2007620	1996592	2116845	1911736	2036126	1975913	1962473	1933854	2167962	None	None	2270362	2320485	None	2243163	2380040	2468553	2380040	2397834	2209217	2320485	2419262	2380040	2335724	2243163	None	2193461	2443860	2483132	2667952	2740638	2578620	2578619	2595817	2554114	2620449	2554086	2639076	2582377
form_id	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F604	F604	F615	F615	F615	F615	F615	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F604	F615	F615	None	None	F615	None	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	None	None	F615	F615	None	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	F615	None	F615	F615	F615	F615	F604	F615	F615	F615	F615	F615	F615	F615	F604
receive_comment	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	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 passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	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 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