Home

Filer ID: 1298205

Table: cvr_lobby_disclosure
filing_id   1282666   1329272   1295778   1307567   1372588   1419519   1447707   1432205   1395612   1459042   1538425   1501603   1484690   1565454   1618128   1601052   1592627   1592627   1601052   1634478   1709626   1675686   1656217   1740256   1709626   1784192   1800749   1764896   1815978   1845458   1865137   1962467   1911725   1977721   1933833   1996787   2061348   2034624   2007622   2100957   2168056   2158073   2127468   2127468   2168056   2271239   2209433   2243233   2243233   2193468   2397832   2380042   2321059   2321059   2380042   2380042   2335733   2468552   2443926   2419348   2443926   2483153   2554531   2554390   2554390   2578691   2578691   2554531   2595812   2554531   2483153   2468552   2554390   2620471   2468552   2554390   2483153   2321059   2578691   2667949   2639142   2578691   2639142   2701810   2595812   2620471   2744898
amend_id   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   1   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   1   0   1   0   0   1   0   0   0   2   0   1   1   0   0   0   1   0   0   0   0   0   3   0   1   2   0   1   2   2   2   0   1   1   1   2   2   0   1   3   0   0   1   1   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   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635
sender_id   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   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   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   1298205   1298205   1298205   1298205   1298205   1298205
filer_id   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   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   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   1298205   1298205   1298205   1298205   1298205   1298205
entity_cd   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM
filer_naml   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 DISTRICT ATTORNEY   SAN DIEGO COUNTY DISTRICT ATTORNEY   SAN DIEGO COUNTY 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   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   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'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY   SAN DIEGO COUNTY DISTRICT ATTORNEY   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE
filer_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
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   001   001   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   001   000   001   000   000   001   000   000   000   002   000   001   001   000   000   000   001   000   000   000   000   000   003   000   001   002   000   001   002   002   002   000   001   001   001   002   002   000   001   003   000   000   001   001   000
rpt_date   2007-07-30 00:00:00   2008-04-28 00:00:00   2007-10-29 00:00:00   2008-01-28 00:00:00   2008-10-27 00:00:00   2009-03-30 00:00:00   2009-10-23 00:00:00   2009-07-21 00:00:00   2009-01-30 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-19 00:00:00   2011-10-19 00:00:00   2011-10-19 00:00:00   2011-05-04 00:00:00   2011-07-19 00:00:00   2012-01-13 00:00:00   2012-10-31 00:00:00   2012-07-27 00:00:00   2012-04-20 00:00:00   2013-01-17 00:00:00   2012-10-31 00:00:00   2013-07-30 00:00:00   2013-10-31 00:00:00   2013-03-31 00:00:00   2014-01-31 00:00:00   2014-04-30 00:00:00   2014-07-22 00:00:00   2015-04-30 00:00:00   2014-10-31 00:00:00   2015-07-27 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   2016-10-30 00:00:00   2017-07-17 00:00:00   2017-04-28 00:00:00   2017-01-30 00:00:00   2017-01-30 00:00:00   2017-07-17 00:00:00   2018-07-27 00:00:00   2018-01-30 00:00:00   2018-04-30 00:00:00   2018-04-30 00:00:00   2017-10-31 00:00:00   2019-07-30 00:00:00   2019-04-30 00:00:00   2018-10-31 00:00:00   2018-10-31 00:00:00   2019-04-30 00:00:00   2019-04-30 00:00:00   2019-01-17 00:00:00   2020-04-29 00:00:00   2020-01-31 00:00:00   2019-10-31 00:00:00   2020-01-31 00:00:00   2020-07-29 00:00:00   2021-02-01 00:00:00   2020-10-01 00:00:00   2020-10-01 00:00:00   2021-04-29 00:00:00   2021-04-29 00:00:00   2021-02-01 00:00:00   2021-07-22 00:00:00   2021-02-01 00:00:00   2020-07-29 00:00:00   2020-04-29 00:00:00   2020-10-01 00:00:00   2021-10-31 00:00:00   2020-04-29 00:00:00   2020-10-01 00:00:00   2020-07-29 00:00:00   2018-10-31 00:00:00   2021-04-29 00:00:00   2022-04-07 00:00:00   2022-01-27 00:00:00   2021-04-29 00:00:00   2022-01-27 00:00:00   2022-07-29 00:00:00   2021-07-22 00:00:00   2021-10-31 00:00:00   2022-10-31 00:00:00
from_date   2007-04-01 00:00:00   2008-01-01 00:00:00   2007-07-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   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-07-01 00:00:00   2011-04-01 00:00:00   2011-01-01 00:00:00   2011-01-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   2012-07-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   2015-01-31 00:00:00   2014-07-01 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   2016-10-01 00:00:00   2017-04-01 00:00:00   2018-04-01 00:00:00   2017-10-01 00:00:00   2018-01-01 00:00:00   2018-01-01 00:00:00   2017-07-01 00:00:00   2019-04-01 00:00:00   2019-01-01 00:00:00   2018-06-01 00:00:00   2018-06-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2018-10-01 00:00:00   2020-01-01 00:00:00   2019-10-01 00:00:00   2019-07-01 00:00:00   2019-10-01 00:00:00   2020-04-01 00:00:00   2020-10-01 00:00:00   2020-07-01 00:00:00   2020-07-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2020-10-01 00:00:00   2021-04-01 00:00:00   2020-10-01 00:00:00   2020-04-01 00:00:00   2020-01-01 00:00:00   2020-07-01 00:00:00   2021-07-01 00:00:00   2020-01-01 00:00:00   2020-07-01 00:00:00   2020-04-01 00:00:00   2018-07-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2021-10-01 00:00:00   2021-01-01 00:00:00   2021-10-01 00:00:00   2022-04-01 00:00:00   2021-04-01 00:00:00   2021-07-01 00:00:00   2022-07-01 00:00:00
thru_date   2007-06-30 00:00:00   2008-03-31 00:00:00   2007-09-30 00:00:00   2007-12-31 00:00:00   2008-09-30 00:00:00   2009-03-28 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-09-30 00:00:00   2011-06-30 00:00:00   2011-03-31 00:00:00   2011-03-31 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   2012-09-30 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   2015-03-31 00:00:00   2014-09-30 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   2016-12-31 00:00:00   2017-06-30 00:00:00   2018-06-30 00:00:00   2017-12-31 00:00:00   2018-03-31 00:00:00   2018-03-31 00:00:00   2017-09-30 00:00:00   2019-06-30 00:00:00   2019-03-31 00:00:00   2018-10-31 00:00:00   2018-09-30 00:00:00   2019-03-31 00:00:00   2019-03-31 00:00:00   2018-12-31 00:00:00   2020-03-31 00:00:00   2019-12-31 00:00:00   2019-09-30 00:00:00   2019-12-31 00:00:00   2020-06-30 00:00:00   2020-12-31 00:00:00   2020-09-30 00:00:00   2020-09-30 00:00:00   2021-03-31 00:00:00   2021-03-31 00:00:00   2020-12-31 00:00:00   2021-06-30 00:00:00   2020-12-31 00:00:00   2020-06-30 00:00:00   2020-03-31 00:00:00   2020-09-30 00:00:00   2021-09-30 00:00:00   2020-03-31 00:00:00   2020-09-30 00:00:00   2020-06-30 00:00:00   2018-09-30 00:00:00   2021-03-31 00:00:00   2022-03-31 00:00:00   2021-12-31 00:00:00   2021-03-31 00:00:00   2021-12-31 00:00:00   2022-06-03 00:00:00   2021-06-30 00:00:00   2021-09-30 00:00:00   2022-09-30 00:00:00
cum_beg_dt   2007-04-01 00:00:00   2007-04-01 00:00:00   2007-04-01 00:00:00   2007-04-01 00:00:00   2007-04-01 00:00:00   2007-04-01 00:00:00   2009-04-01 00:00:00   2009-04-01 00:00:00   2007-04-01 00:00:00   2009-04-01 00:00:00   2009-04-01 00:00:00   2009-04-01 00:00:00   2009-04-01 00:00:00   2009-04-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2009-04-01 00:00:00   2011-04-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2015-01-01 00:00:00   2013-01-01 00:00:00   2015-01-01 00:00:00   2013-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2019-01-01 00:00:00   2021-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2021-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2017-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
firm_id   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   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   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   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 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 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 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 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
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   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   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   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-4016   619-531-4016   619-531-4304   619-531-4304   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   619-531-4016   619-531-4016   619-531-4016   619-531-4016   619-531-4016   619-531-3968   619-531-4016   619-531-4016   619-531-3968   619-531-3968   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   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   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
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   2007-07-30 00:00:00   2008-04-30 00:00:00   2007-10-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-07-21 00:00:00   2009-01-30 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-19 00:00:00   2011-10-19 00:00:00   2011-10-19 00:00:00   2011-05-04 00:00:00   2011-07-19 00:00:00   2012-01-30 00:00:00   2012-10-31 00:00:00   2012-07-27 00:00:00   2012-04-27 00:00:00   2013-01-31 00:00:00   2013-01-16 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   2015-04-27 00:00:00   2014-10-31 00:00:00   2015-07-27 00:00:00   2015-01-30 00:00:00   2015-10-30 00:00:00   2016-07-29 00:00:00   2016-04-28 00:00:00   2016-01-27 00:00:00   2016-10-31 00:00:00   2017-07-17 00:00:00   2017-04-30 00:00:00   2017-01-30 00:00:00   2017-01-30 00:00:00   2017-08-23 00:00:00   2018-07-27 00:00:00   2018-01-30 00:00:00   2018-06-04 00:00:00   2018-04-30 00:00:00   2017-10-31 00:00:00   2019-07-31 00:00:00   2019-06-18 00:00:00   2018-10-31 00:00:00   2018-10-31 00:00:00   2019-04-30 00:00:00   2018-04-30 00:00:00   2019-01-18 00:00:00   2020-04-29 00:00:00   2020-01-31 00:00:00   2019-10-31 00:00:00   2020-01-31 00:00:00   2020-07-29 00:00:00   2021-02-01 00:00:00   2020-10-01 00:00:00   2021-05-20 00:00:00   2021-04-29 00:00:00   1921-07-01 00:00:00   2021-05-21 00:00:00   2021-07-22 00:00:00   2021-02-01 00:00:00   2021-05-20 00:00:00   2021-05-20 00:00:00   2021-05-20 00:00:00   2021-10-27 00:00:00   2020-04-29 00:00:00   2020-10-01 00:00:00   2020-07-29 00:00:00   2018-10-31 00:00:00   2022-01-31 00:00:00   2022-04-14 00:00:00   2022-01-31 00:00:00   2020-02-03 00:00:00   2022-01-27 00:00:00   2022-07-29 00:00:00   2022-01-31 00:00:00   2022-01-31 00:00:00   2022-10-31 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 California   San Diego California   San Diego California   San Diego California   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO CA   San Diego CA   San Diego   SAN DIEGO   San Diego CA   SAN DIEGO   San Diego CA   SAN DIEGO   San Diego CA   SAN DIEGO   SAN DIEGO   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 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   San Diego CA   San Diego   San Diego   San Diego   SAN DIEGO   San Diego   San Diego   San Diego CA
sig_naml   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   DUMANIS   DUMANIS   DUMANIS   DUMANIS   DUMANIS   Dumanis   DUMANIS   DUMANIS   Dumanis   DUMANIS   Dumanis   DUMANIS   Dumanis   DUMANIS   DUMANIS   Stephan   Dumanis   Dumanis   Dumanis   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Summer   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephen
sig_namf   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   BONNIE   BONNIE   BONNIE   BONNIE   BONNIE   Bonnie   BONNIE   BONNIE   Bonnie   BONNIE   Bonnie   BONNIE   Bonnie   BONNIE   BONNIE   Summer   Bonnie   Bonnie   Bonnie   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Stephan   Summer   Summer   Summer   Summer   Summer   Summer   Summer
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   Ms.   Ms.   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   Dumanis   DUMANIS   DUMANIS   DUMANIS   DUMANIS   DUMANIS   Dumanis   DUMANIS   DUMANIS   Dumanis   DUMANIS   Dumanis   DUMANIS   Dumanis   DUMANIS   DUMANIS   Stephan   Dumanis   Dumanis   Dumanis   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Summer   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan   Stephen
prn_namf   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie M.   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   Bonnie   BONNIE   BONNIE   BONNIE   BONNIE   BONNIE   Bonnie   BONNIE   BONNIE   Bonnie   BONNIE   Bonnie   BONNIE   Bonnie   BONNIE   BONNIE   Summer   Bonnie   Bonnie   Bonnie   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Summer   Stephan   Summer   Summer   Summer   Summer   Summer   Summer   Summer
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   Ms.   Ms.   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   DISTRICT ATTORNEY   DISTRICT ATTORNEY   DISTRICT ATTORNEY   DISTRICT ATTORNEY   DISTRICT ATTORNEY   District Attorney   DISTRICT ATTORNEY   DISTRICT ATTORNEY   District Attorney   DISTRICT ATTORNEY   District Attorney   DISTRICT ATTORNEY   District Attorney   DISTRICT ATTORNEY   DISTRICT ATTORNEY   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   San Diego County District Attorney   District Attorney   District Attorney   San Diego County District Attorney   District Attorney   District Attorney   District Attorney   San Diego County District Attorney   District Attorney   San Diego County District Attorney   San Diego County District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   San Diego District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   District Attorney   San Diego County District Attorney   San Diego County 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   District Attorney
nopart1_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
nopart2_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_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   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X
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   SB 804 AB 1200 SB 503 SB 501 Big Brothers Big Sisters of San Diego County - CFDA# 16.726 Adult Protective Services - Support for Increased Funding Support for Gang & Prevention Act of 2007.   AB2606 SB1396 AB1771 AB2049 AB1854 Funding for Southwest Border Prosecution Initiative   SB756 SB729 SB511 SB609 SB729 SB657 SB279 Adult Protective Services - Support for Increased Funding   AB 1141   AB844 Metal Theft AB860 RATT AB1141 KHAT AB1946 Hazardous Material/Water Quality AB 1396 Real Estate Fraud AB2143 Urban Grant (Organized Auto Fraud) SB691 Metal Theft.   Public Safety Funding Federal Legislation Byrne Grant Funding AB960 AB509 AB286 SB156 AB390 SWBPI HIDTA and CDCR.   AB509 SB151 SB156 AB286 SB669 SB444   AB960 AB509 SB151 AB286 SB668 SB669 AB484 AB631 SB731 SB678 AB250 SB239 SB441 AB305 AB509 SB618   Auto Insurance Fraud Southwest Border Prosecutio Initiative Worker's Compensation Fraud Cops Funding   AB1244 Penal Code Amendment for Burglary Tools and CDCR Re-entry Programs   SB5 SB1844 SB982 SB1449 CDCR Department of Insurance   AB33 AB34 AB1022 AB1844 AB1848 AB2198 AB2262 SB408 SB942 SB982 Law Enforcement Advocacy Urban Grant & Auto Ins. Fraud   SB408 AB777 AB1848 AB960 AB2262 AB1844 SB877 and Sex Offender Legislation   Insurance Fraud Symposium/Lobbying; Legislative meeting; Vehicle License Fee/Lobbying   Law Enforcement Advocacy Mtg; AB648 SB914 CA Dept of Corrections/Rehab/Lobby for Grant funding; SW Border Project (SWDPI); Lobby for DOJ grant funding; Cross Border Violent Crime Task Force grant lobbying.   Law Enforcement Advocacy; Lobbying; AB648/AB918; SB291/AB1281; Legislative Advisory; Ethic Course Requirement   Law Enforcement Advocacy; Lobbying; AB918 648 848 and SB291 247 and 248   Law Enforcement Advocacy; Lobbying; AB918 648 848 and SB291 247 and 248   Law Enforcement Advocacy; Lobbying; AB648/AB918; SB291/AB1281; Legislative Advisory; Ethic Course Requirement   CPOA Leg Wrap-up; Leg Summitt; CDCR Mtg; Crystal Harris Leg/law   Law Enforcement Advocates SW Border Patrol Initative; VOLA Mtgs; AB1522 and AB1404   Law Enforcement Advocates Mtg; AB1522 AB2221 AB2222 AB327 AB 2220 AND SB1002   Law Enforcement Advocates Mtg; CDAA Winter Workshop; CPOA; AB1522 AB2221 AB2222 AB327 AB340 and AB1525   BILLS: Victims Advocacy Sexual Assault Elder Thief and Inmate Tranfers. MEETINGS: CDAA NDAA and CSAC   Law Enforcement Advocates SW Border Patrol Initative; VOLA Mtgs; AB1522 and AB1404   -Public Safety Committee Mtg -CSAC Conf -Ethic Training -Lobbying SB534 -130 -378 -107 -473 -162 -769   -APSC HEARING -PSA MTG -LOBBY FOR SB543 - LEGISLATIVE MTG   Public Advocacy CDAA Lobbying Ethics Class NACo Legislative Committee Mtg Public Safety Committee Mtg   -PUBLIC SAFETY ADV'S MTG -LOBBYING -CDAA LEG ANNUAL SUMMIT   -PUBLIC SAFETY ADV MTGS -CDAA WINTER CONF -LOBBYING -PROJECT VETERAN JAIL -CDAA LEG SUMMIT -ASM PUBLIC SAFETY -22ND ANNUAL LEG DAY   -PUBLIC SAFETY ADV MTGS -LOBBYING AB1958 AB2121 -COMMITTEE MEETING   Monthly Public Safety Advocates Mtgs; CSAC CONF; CDAA Winter Conference; LEA Mtg; CA Lobbyist Ethics Course; CPOA LE LEG DAY CONF; CDAA LEG SUMMIT   -PUBLIC SAFETY ADV MTGS -NEW CONF W/DA   Monthly Public Safety Advocates Mtgs; Law Enforcement Community Relations Mtg; Domes Viol Danger Assess and Risk Mgmt Mtg; SB603456 352 and 722   -CDAA Fraud Symposium; Lobbying; Public Safety Advocates; Prop 47 Hearing   Monthly Public Safety Advocates Mtgs; CDAA Summer Conference; SB352; AB487; Prog OPS for Comm Corr   PSA MTG (2); LAW ENF LEG DAY; PUB SENATE TESTIFY; SB 821; BILL HEARINGS; AB2765; PROP 47; AB1766   ASSEMBLY PUB MTG; ASSEMBLY JD MTG; AB MTGSM PSA MTG; MTG W/GOVERNOR; SCHOOL SHTG AND VOIR DITE BILL MTG; 2016 CDAA WTR WKSHOP; AB927   SB456; PSA MTG; SB603   MTG w/ R. DOZIER; MTG RE HUMAN TRAFF; PROP 47/AB2765; PSA MTG (1); AB1766; IGA MTG;   Public Safety Advocates Meeting with Law Enforcement Partners ; Legislative Meetings with Staff members of different legislators' offices and committee offices (Public Safety Committee) ; Meeting with Senators and Assemblymembers regarding sponsored and opposed bills.   MTG W/ LEGISLATORS TO FIND AUTHORS FOR SPONSORED BILLS; PUBLIC SAFETY ADVOCATES MTGS.; NDAA CAPITAL CONFERENCE; NACO LEGISLATIVE CONFERENCE; CPOA LAW ENFORCEMENT LEGISLATIVE DAY; MTG. WITH SEN. BATES & ANDERSON ATKINS & ASM. WEBER   MTG w/ LEGISLATORS (ATKINSBATESWEBER&ANDERSON) TO FIND THE RIGHT AUTHORS FOR SPONSORED BILLS   MTG w/ LEGISLATORS (ATKINSBATESWEBER&ANDERSON) TO FIND THE RIGHT AUTHORS FOR SPONSORED BILLS   Public Safety Advocates Meeting with Law Enforcement Partners ; Legislative Meetings with Staff members of different legislators' offices and committee offices (Public Safety Committee) ; Meeting with Senators and Assemblymembers regarding sponsored and opposed bills.   LEGISLATIVE MTGS WITH SEN. BATES & ANDERSON AND ASM. GONZALEZ FLETCHER and WEBER   Legislative Meetings with Staff members of different legislators' offices and committee offices (Public Safety Committee) ; IGA: Sacramento Press Club   NDAA CAPITAL CONFERENCE; CDAA LEGISLATIVE DAY; MTG. LEGISLATIVE MTGS WITH SEN. BATES & ANDERSON AND ASM. GONZALEZ FLETCHER and WEBER   NDAA CAPITAL CONFERENCE; CDAA LEGISLATIVE DAY; MTG. LEGISLATIVE MTGS WITH SEN. BATES & ANDERSON AND ASM. GONZALEZ FLETCHER and WEBER   Public Safety Advocates Meeting with Law Enforcement Partners ; Legislative Meetings with Staff members of different legislators' offices and committee offices (Public Safety Committee) ; National Criminal Justice Association Forum   VARIOUS CONFIDENTIAL LEGISLATIVE MTGS WITH AUTHORS OF THE SPONSORED BILLS SEN BATES (SB 141); ASM WOMAN CERVANTES (AB 164); JONES (SB 411) and ASM WOMAN FLETCHER GONZALEZ (AB 589)   CDAACONFERENCE; VARIOUS LEGISLATIVE MTGS WITH AUTHORS OF THE SPONSORED BILLS SEN BATES (SB 141); ASM WOMAN CERVANTES (AB 164); JONES (SB 411) and ASM WOMAN FLETCHER GONZALEZ (AB 589)   LEGISLATIVE MTGS WITH SEN. BATES & ANDERSON AND ASM. GONZALEZ FLETCHER and WEBER; Meetings with Senate and Assembly Public Safety Meetings and the Governor's Staff regarding AB 1810.   LEGISLATIVE MTGS WITH SEN. BATES & ANDERSON AND ASM. GONZALEZ FLETCHER and WEBER; Meetings with Senate and Assembly Public Safety Meetings and the Governor's Staff regarding AB 1810.   CDAACONFERENCE; VARIOUS LEGISLATIVE MTGS WITH AUTHORS OF THE SPONSORED BILLS SEN BATES (SB 141); ASM WOMAN CERVANTES (AB 164); JONES (SB 411) and ASM WOMAN FLETCHER GONZALEZ (AB 589)   CDAACONFERENCE; VARIOUS LEGISLATIVE MTGS WITH AUTHORS OF THE SPONSORED BILLS SEN BATES (SB 141); ASM WOMAN CERVANTES (AB 164); JONES (SB 411) and ASM WOMAN FLETCHER GONZALEZ (AB 589)   Legislative Meetings & National Law Enforcement Summit   CDAA WINTER WORKSHOP; VARIOUS LEGISLATIVE MTGS WITH AUTHORS OF THE SPONSORED BILLS; LOBBYING SEMINARS WITH RAY LEBOV AND PUBLIC SAFETY ADVOCATE MEETING   VARIOUS CONFIDENTIAL LEGISLATIVE MTGS WITH AUTHORS OF THE SPONSORED BILLS SEN BATES (SB 141); ASM WOMAN CERVANTES (AB 164); JONES (SB 411)and ASM WOMAN FLETCHER GONZALEZ (AB 589. ALSO MEETINGS WITH THE GOVERNOR'S DEPUTY LEGISLATIVE SECRETARIES   VARIOUS CONFIDENTIAL LEGISLATIVE MTGS WITH AUTHORS OF THE SPONSORED BILLS SEN BATES (SB 141); ASM WOMAN CERVANTES (AB 164); JONES (SB 411)and ASM WOMAN FLETCHER GONZALEZ (AB 589. ALSO MEETINGS WITH THE GOVERNOR'S DEPUTY LEGISLATIVE SECRETARIES   VARIOUS CONFIDENTIAL LEGISLATIVE MTGS WITH AUTHORS OF THE SPONSORED BILLS SEN BATES (SB 141); ASM WOMAN CERVANTES (AB 164); JONES (SB 411)and ASM WOMAN FLETCHER GONZALEZ (AB 589. ALSO MEETINGS WITH THE GOVERNOR'S DEPUTY LEGISLATIVE SECRETARIES   No trip to Sacramento was made due to the Pandemic.   No trip to Sacramento was made due to the Pandemic.   No trip to Sacramento was made due to the Pandemic.   No trip to Sacramento was made due to the Pandemic.   CPOA 29th Annual Law Enforcement Leg Summit; NDAA Capital Conference   CPOA 29th Annual Law Enforcement Leg Summit; NDAA Capital Conference   No trip to Sacramento was made due to the Pandemic.   Committee Hearings at the Capitol Building; Sponsored Bills: AB 764 (Cervantes; SB 248 (Bates); AB 364 (Rodriguez); AB 717 (Stone)   No trip to Sacramento was made due to the Pandemic.   No trip to Sacramento was made due to the Pandemic.   CDAA WINTER WORKSHOP; VARIOUS LEGISLATIVE MTGS WITH AUTHORS OF THE SPONSORED BILLS; LOBBYING SEMINARS WITH RAY LEBOV AND PUBLIC SAFETY ADVOCATE MEETING   No trip to Sacramento was made due to the Pandemic.   Committee Hearings at the Capitol Building; Sponsored Bills: AB 764 (Cervantes; SB 248 (Bates); AB 341 (Horvath) (Rodriguez); SB 629 (Roth) and Opposed Bills: AB 333 (Kamlager)and SB 775 (Becker)   CDAA WINTER WORKSHOP; VARIOUS LEGISLATIVE MTGS WITH AUTHORS OF THE SPONSORED BILLS; LOBBYING SEMINARS WITH RAY LEBOV AND PUBLIC SAFETY ADVOCATE MEETING   No trip to Sacramento was made due to the Pandemic.   No trip to Sacramento was made due to the Pandemic.   LEGISLATIVE MTGS WITH SEN. BATES & ANDERSON AND ASM. GONZALEZ FLETCHER and WEBER; Meetings with Senate and Assembly Public Safety Meetings and the Governor's Staff regarding AB 1810.   CPOA 29th Annual Law Enforcement Leg Summit; NDAA Capital Conference   Law Enforcement Legislative Summit hosted by CPOA. Met with legislators and Legislative Staff regarding sponsored bills.   End of Session meetings with the Office of the Governor; Sponsored Bills: AB 764 (Cervantes; SB 248 (Bates); AB 341 (Horvath) (Rodriguez); SB 629 (Roth) and Opposed Bills: AB 333 (Kamlager)and SB 775 (Becker)   CPOA 29th Annual Law Enforcement Leg Summit; NDAA Capital Conference   End of Session meetings with the Office of the Governor; Sponsored Bills: AB 764 (Cervantes; SB 248 (Bates); AB 341 (Horvath) (Rodriguez); SB 629 (Roth) and Opposed Bills: AB 333 (Kamlager)and SB 775 (Becker)   Legislative Meetings: Sponsored Bills SB 904 (Bates); AB 2185 (Weber); AB 2274 (Rubio) ; SB 382 (Caballero) and Opposed Bills : AB 2435 (Lee) ; AB 2790 (Wicks) ; SB 300 (Cortese) ; SB 1273 (Bradford)   Committee Hearings at the Capitol Building; Sponsored Bills: AB 764 (Cervantes; SB 248 (Bates); AB 364 (Rodriguez); AB 717 (Stone)   Committee Hearings at the Capitol Building; Sponsored Bills: AB 764 (Cervantes; SB 248 (Bates); AB 341 (Horvath) (Rodriguez); SB 629 (Roth) and Opposed Bills: AB 333 (Kamlager)and SB 775 (Becker)   Legislative Meetings: Sponsored Bills SB 904 (Bates); AB 2185 (Weber); AB 2274 (Rubio) ; SB 382 (Caballero) and Opposed Bills : AB 2435 (Lee) ; AB 2790 (Wicks) ; SB 300 (Cortese) ; SB 1273 (Bradford)
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: cvr_registration
filing_id   1381549   1425512   1611216   1611221   1719718   1719718   2116839   2116839   2325573   2582372   2582372   2745160   2745160
amend_id   0   0   0   0   0   1   0   1   0   0   1   1   0
rec_type   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR
form_type   F603   F603   F603   F603   F603   F603   F603   F603   F603   F603   F603   F603   F603
sender_id   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205
filer_id   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205
entity_cd   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM
filer_naml   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'S OFFICE   SAN DIEGO DISTRICT ATTORNEY   SAN DIEGO DISTRICT ATTORNEY   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE
filer_namf   None   None   None   None   None   None   Bonnie Dumanis   Bonnie Dumanis   None   None   None   None   None
filer_namt   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
report_num   000   000   000   000   000   001   000   001   000   000   001   001   000
rpt_date   2008-11-14 00:00:00   2009-06-03 00:00:00   2011-08-05 00:00:00   2011-08-05 00:00:00   2012-12-24 00:00:00   2012-12-24 00:00:00   2017-01-03 00:00:00   2017-07-14 00:00:00   2018-11-14 00:00:00   2020-12-11 00:00:00   2020-12-11 00:00:00   2022-10-25 00:00:00   2022-10-25 00:00:00
ls_beg_yr   2009   2009   2011   2011   2012   2013   2017   2017   2019   2021   2021   2022   2022
ls_end_yr   2010   2010   2012   2012   2013   2014   2018   2018   2020   2022   2022   2022   2022
qual_date   2008-11-14 00:00:00   2007-04-01 00:00:00   2007-04-01 00:00:00   2007-04-01 00:00:00   2007-04-01 00:00:00   2007-04-01 00:00:00   None   None   2018-01-01 00:00:00   None   None   None   None
eff_date   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_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
bus_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
bus_zip4   92101   92101   92101   92101   92101   92101   92101   92101   92101   92101   92101   92101   92101
bus_phon   6195314114   619-531-4114   619-531-4016   619-531-4016   619-531-4016   619-531-4016   6195313544   6195313544   6195313639   619-531-4114   619-531-4114   619-531-3968   619-531-3968
bus_fax   None   None   None   None   None   None   6195314303   6195314303   None   None   None   None   None
bus_email   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   None   None   None   None
mail_city   None   None   None   None   San Diego   San Diego   None   None   None   None   None   None   None
mail_st   None   None   None   None   CA   CA   None   None   None   None   None   None   None
mail_zip4   None   None   None   None   92101   92101   None   None   None   None   None   None   None
mail_phon   None   None   None   None   (619) 531-4016   (619) 531-4016   None   None   None   None   None   None   None
sig_date   2008-11-14 00:00:00   2009-06-03 00:00:00   2011-08-05 00:00:00   2011-08-05 00:00:00   2013-12-24 00:00:00   2012-12-24 00:00:00   2017-01-03 00:00:00   2017-07-12 00:00:00   2018-11-14 00:00:00   2020-12-11 00:00:00   2022-04-07 00:00:00   2022-10-25 00:00:00   2022-10-25 00:00:00
sig_loc   None   San Diego California   San Diego California   San Diego California   San Diego California   San Diego California   None   None   None   San Diego California   San Diego California   San Diego CA   San Diego CA
sig_naml   Dumanis   Stewart-Brockman   Stewart-Brockman   Stewart-Brockman   Stewart-Brockman   Stewart-Brockman   Rodriguez   Stephan   Stephan   Stephan   Stephan   Stephan   Stephan
sig_namf   Bonnie   Gail   Gail   Gail   Gail   Gail   Jesse   Summer   Summer   Summer   Summer   Summer   Summer
sig_namt   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
prn_naml   Dumanis   None   None   None   None   None   Rodriguez   Stephan   Stephan   None   None   None   None
prn_namf   Bonnie   None   None   None   None   None   Jesse   Summer   Summer   None   None   None   None
prn_namt   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
sig_title   SD District Attorney   None   None   None   None   None   Asst. District Attorney   District Attorney   District Attorney   None   San Diego County District Attorney   District Attorney   District Attorney
stmt_firm   None   None   None   None   None   None   None   None   None   None   None   None   None
ind_cb   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_cb   None   None   None   None   None   None   None   None   None   None   None   None   None
trade_cb   None   None   None   None   None   None   None   None   None   None   None   None   None
oth_cb   X   X   X   X   X   X   X   X   X   X   X   X   X
a_b_name   None   None   None   None   None   None   None   None   None   None   None   None   None
a_b_city   None   None   None   None   None   None   None   None   None   None   None   None   None
a_b_st   None   None   None   None   None   None   None   None   None   None   None   None   None
a_b_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None
descrip_1   Public Safety   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement   Public Safety Legal, Law Enforcement   Public Safety Legal, Law Enforcement   San Diego District Attorney's Office   None   None   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement
descrip_2   Legal & Law Enforcement   None   None   None   None   None   Public Safety Legal, Law Enforcement   Public Safety Legal, Law Enforcement   Public Safety, Legal and Law Enforcement   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement
c_less50   None   None   None   None   None   None   None   None   None   None   None   None   None
c_more50   None   None   None   None   None   None   None   None   None   None   None   None   None
ind_class   GOV   LEG   LEG   LEG   LEG   LEG   GOV   GOV   GOV   GOV   GOV   GOV   GOV
ind_descr   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_class   None   None   None   None   None   None   None   None   None   None   None   OTH   OTH
bus_descr   None   None   None   None   None   None   None   None   None   None   None   State   State
auth_name   None   None   None   None   None   None   None   None   None   None   None   None   None
auth_city   None   None   None   None   None   None   None   None   None   None   None   None   None
auth_st   None   None   None   None   None   None   None   None   None   None   None   None   None
auth_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None
lobby_int   Public Safety Policy   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement   Legislation advocating for positive changes in the law, as approved by the DA, with law enforcement, all members of the criminal justice systems and the community we serve to achieve the highest level of public safety.   Legislation advocating for positive changes in the law, as approved by the DA, with law enforcement, all members of the criminal justice systems and the community we serve to achieve the highest level of public safety.   Legislation advocating for positive4 changes in the law, as approved by the DA, with law enforcement, all members of the criminal justice systems and the community we serve to achieve the highest level of public safety.   Public Safety Legal and Law Enforcement   Public Safety Legal and Law Enforcement   Public safety Legal and Law Enforcement   Public safety Legal and Law Enforcement
influen_yn   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y
firm_name   None   None   None   None   None   None   None   None   None   None   None   None   None
newcert_cb   None   None   None   None   None   None   None   None   None   None   None   None   None
rencert_cb   None   None   None   None   None   None   None   None   None   None   None   None   None
complet_dt   None   None   None   None   None   None   None   None   None   None   None   None   None
lby_reg_cb   None   None   None   None   None   None   None   None   None   None   None   None   None
lby_604_cb   None   None   None   None   None   None   None   None   None   None   None   None   None
st_leg_yn   None   None   None   None   None   None   None   None   None   None   None   None   None
st_agency   None   None   None   None   None   None   None   None   None   None   None   None   None
lobby_cb   None   None   None   None   None   None   None   None   None   None   None   None   None
l_firm_cb   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filer_address
filer_id   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205
adrid   2123827   2159810   2203338   2413705   2276352   2506358   2467181   2338762
effect_dt   2007-04-30 00:00:00   2009-01-01 00:00:00   2011-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
add_type   7051   7051   7051   7051   7051   7051   7051   7051
session_id   2007   2009   2011   2017   2013   2021   2019   2015
Table: filer_filings
filer_id   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   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   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   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   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205
filing_id   1282666   1267707   1267712   1307567   1784192   1962467   1865137   1800749   1911725   1329272   1295778   1372588   1347835   1381549   1395612   1432205   1425512   1427769   1419519   1447707   1459042   1501603   1484690   1538425   1565454   1592627   1592627   1613386   1601052   1634478   1611221   1611216   1618128   1601052   1656217   1675686   1815978   1933833   1719718   1709626   1740256   1709626   1845458   1719718   1764896   1767123   1996787   1977721   2397832   2380042   2209433   2443926   2243233   2007622   2024327   2034624   2061348   2100957   2127468   2127468   2116839   2148519   2122785   2116839   2158073   2169094   2335745   2380042   2321059   2168056   2468552   2419348   2443926   2554531   2380042   2271239   2243233   2168056   2321059   2193468   2325573   2335733   2483153   2595812   2578691   2554390   2701810   2554531   2468552   2582372   2578691   2554390   2468552   2639142   2595812   2620471   2321059   2483153   2554390   2554531   2671989   2671992   2582372   2683283   2578691   2620471   2554390   2578691   2667949   2547298   2483153   2639142   2754221   2744898   2745160   2745160
period_id   190   None   None   192   214   221   218   215   219   193   191   195   194   196   196   198   198   None   197   199   200   202   201   203   204   205   205   None   206   208   207   207   207   206   209   210   216   220   212   211   212   211   217   212   213   None   223   222   238   237   232   240   233   224   None   225   226   227   228   228   229   None   None   231   229   None   None   237   234   230   241   239   240   244   237   234   233   230   234   231   236   236   242   246   245   243   250   244   241   244   245   243   241   248   246   247   235   242   243   244   None   None   244   None   245   247   243   245   245   None   242   248   None   251   252   252
form_id   F635   F603   F999   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F635   F603   F603   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F635   F603   F603   F635   F635   F635   F635   F635   F635   F603   F635   F635   F635   F635   F603   F635   F603   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F603   F605   F603   F603   F635   F605   F603   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F605   F606   F603   F605   F635   F635   F635   F635   F635   F603   F635   F635   F605   F635   F603   F603
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   1   0   0   0   0   0   0   1   0   0   0   0   0   0   0   1   0   1   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   1   0   0   0   1   0   0   0   1   1   0   0   0   1   0   2   0   0   1   0   0   0   0   0   0   0   3   0   1   2   0   1   0   1   1   1   1   2   2   2   2   0   0   1   0   3   0   1   2   0   0   1   0   0   0   0   1
filing_date   2007-07-30 00:00:00   2007-05-18 00:00:00   2007-05-21 00:00:00   2008-01-28 00:00:00   2013-08-01 00:00:00   2015-04-27 00:00:00   2014-07-22 00:00:00   2013-10-31 00:00:00   2014-10-31 00:00:00   2008-04-30 00:00:00   2007-10-29 00:00:00   2008-10-27 00:00:00   2008-07-29 00:00:00   2008-11-14 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-10-14 00:00:00   2010-01-21 00:00:00   2010-07-20 00:00:00   2010-04-30 00:00:00   2010-10-29 00:00:00   2011-01-25 00:00:00   2011-05-04 00:00:00   2011-10-19 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-08-05 00:00:00   2011-10-19 00:00:00   2011-10-19 00:00:00   2012-04-27 00:00:00   2012-07-27 00:00:00   2014-01-30 00:00:00   2015-01-30 00:00:00   2012-12-24 00:00:00   2012-10-31 00:00:00   2013-01-31 00:00:00   2013-01-16 00:00:00   2014-04-30 00:00:00   2013-03-19 00:00:00   2013-04-30 00:00:00   2013-03-22 00:00:00   2015-10-30 00:00:00   2015-07-27 00:00:00   2019-07-31 00:00:00   2019-04-30 00:00:00   2018-01-30 00:00:00   2020-01-31 00:00:00   2018-06-04 00:00:00   2016-01-27 00:00:00   2016-03-23 00:00:00   2016-04-28 00:00:00   2016-07-29 00:00:00   2016-10-31 00:00:00   2017-01-30 00:00:00   2017-01-30 00:00:00   2017-01-03 00:00:00   2017-03-27 00:00:00   2017-01-03 00:00:00   2017-07-14 00:00:00   2017-05-01 00:00:00   2017-07-19 00:00:00   2018-11-13 00:00:00   2019-06-18 00:00:00   2018-10-31 00:00:00   2017-07-17 00:00:00   2020-04-29 00:00:00   2019-10-31 00:00:00   2020-02-06 00:00:00   2021-02-01 00:00:00   2019-06-18 00:00:00   2018-07-27 00:00:00   2018-04-30 00:00:00   2017-08-23 00:00:00   2018-10-31 00:00:00   2017-10-31 00:00:00   2018-11-14 00:00:00   2019-01-18 00:00:00   2020-07-29 00:00:00   2021-07-22 00:00:00   2021-04-29 00:00:00   2021-05-20 00:00:00   2022-07-27 00:00:00   2021-05-13 00:00:00   2021-05-20 00:00:00   2021-05-04 00:00:00   2021-07-19 00:00:00   2021-02-01 00:00:00   2021-05-13 00:00:00   2022-01-31 00:00:00   2022-01-31 00:00:00   2022-01-31 00:00:00   2021-10-03 00:00:00   2021-05-20 00:00:00   2021-05-20 00:00:00   2021-05-20 00:00:00   2022-04-18 00:00:00   2022-04-18 00:00:00   2022-04-08 00:00:00   2022-04-18 00:00:00   2022-02-03 00:00:00   2021-10-27 00:00:00   2021-05-13 00:00:00   2022-01-31 00:00:00   2022-04-20 00:00:00   2020-12-22 00:00:00   2021-05-13 00:00:00   2022-01-27 00:00:00   2022-10-31 00:00:00   2022-10-28 00:00:00   2022-10-28 00:00:00   2022-11-01 00:00:00
stmnt_type   10001   10005   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10002   10005   10001   10001   10001   10001   10001   10002   10001   10001   10001   10001   10001   10001   10001   10002   10001   10002   10001   10005   10001   10001   10001   10001   10001   10001   10002   10001   10005   10001   10001   10001   10001   10002   10001   10005   10005   10002   10001   10005   10005   10002   10002   10001   10001   10001   10002   10001   10002   10001   10001   10002   10001   10001   10001   10001   10001   10001   10001   10002   10001   10002   10002   10001   10002   10001   10002   10002   10002   10002   10002   10002   10002   10002   10005   10005   10002   10002   10002   10001   10002   10002   10001   10001   10002   10001   10002   10001   10001   10002
stmnt_status   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11003   11003   11001   11001   11003   11001   11003   11003   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11003   11003   11001   11001   11003   11001   11003   11003   11001
session_id   2007   2007   2007   2007   2013   2015   2013   2013   2013   2007   2007   2007   2007   2009   2007   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2011   2011   2011   2011   2011   2011   2011   2011   2011   2011   2011   2013   2013   2012   2011   2011   2011   2013   2013   2013   2013   2015   2015   2019   2019   2017   2019   2017   2015   2015   2015   2015   2015   2015   2015   2017   2017   2017   2017   2017   2017   2019   2019   2017   2017   2019   2019   2019   2019   2019   2017   2017   2017   2017   2017   2019   2017   2019   2021   2021   2019   2021   2019   2019   2021   2021   2019   2019   2021   2021   2021   2017   2019   2019   2019   2021   2021   2021   2021   2021   2021   2019   2021   2021   2021   2019   2021   2021   2021   2022   2022
user_id   LTHIBAUL   GPEREZ   GPEREZ   LTHIBAUL   RGEREMIA   AGLADNEY   ASAETERN   ASAETERN   AGLADNEY   LTHIBAUL   LTHIBAUL   ASAETERN   LTHIBAUL   GPEREZ   AGLADNEY   MGUERRA   PBANFORD   PBANFORD   MGUERRA   MGUERRA   MGUERRA   ASAETERN   ASAETERN   ASAETERN   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   ASAETERN   YRODRIGU   YRODRIGU   AGLADNEY   AGLADNEY   ASAETERN   AGLADNEY   ASAETERN   AGLADNEY   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   YRODRIGU   AGLADNEY   AGLADNEY   SUSHAKOV   GTAYLOR   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   GPEREZ   SARRIAGA   GPEREZ   GPEREZ   AGLADNEY   GPEREZ   DMCCASTL   GTAYLOR   AGLADNEY   AGLADNEY   SUSHAKOV   SUSHAKOV   AGLADNEY   GTAYLOR   GTAYLOR   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   SARRIAGA   AGLADNEY   GTAYLOR   GTAYLOR   GTAYLOR   LPHEAV   LPHEAV   GTAYLOR   GTAYLOR   CAFILER   CAFILER   LPHEAV   GTAYLOR   CAFILER   GTAYLOR   CAFILER   CAFILER   GTAYLOR   LPHEAV   GTAYLOR   CVANLIEW   CVANLIEW   CVANLIEW   CVANLIEW   CAFILER   CAFILER   LPHEAV   CAFILER   CAFILER   CVANLIEW   GTAYLOR   CAFILER   NKRESTOFF   CAFILER   CAFILER   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   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   11001   11001   11001   11001   11001   11003   11003   11001   11003   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   11003   11003   11003   11003   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11003   11001   11003   11003   11001   11001   11001   11003   11003   11003   11003   11003   11003   11001   11003   11003   11003   11001   11003   11003   11003   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   2013-04-01 00:00:00   2015-01-31 00:00:00   2014-04-01 00:00:00   2013-07-01 00:00:00   2014-07-01 00:00:00   2008-01-01 00:00:00   2007-07-01 00:00:00   2008-07-01 00:00:00   2008-04-01 00:00:00   2008-11-14 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   2009-07-01 00:00:00   2009-10-01 00:00:00   2010-04-01 00:00:00   2010-01-01 00:00:00   2010-07-01 00:00:00   2010-10-01 00:00:00   2011-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-08-05 00:00:00   2011-07-01 00:00:00   2011-04-01 00:00:00   2012-01-01 00:00:00   2012-04-01 00:00:00   2013-10-01 00:00:00   2014-10-01 00:00:00   2012-12-24 00:00:00   2012-07-01 00:00:00   2012-10-01 00:00:00   2012-07-01 00:00:00   2014-01-01 00:00:00   2012-12-24 00:00:00   2013-01-01 00:00:00   1900-01-01 00:00:00   2015-07-01 00:00:00   2015-04-01 00:00:00   2019-04-01 00:00:00   2019-01-01 00:00:00   2017-10-01 00:00:00   2019-10-01 00:00:00   2018-01-01 00:00:00   2015-10-01 00:00:00   1900-01-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   2016-10-01 00:00:00   2017-01-03 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2017-07-14 00:00:00   2017-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2019-01-01 00:00:00   2018-06-01 00:00:00   2017-04-01 00:00:00   2020-01-01 00:00:00   2019-07-01 00:00:00   2019-10-01 00:00:00   2020-10-01 00:00:00   2019-01-01 00:00:00   2018-04-01 00:00:00   2018-01-01 00:00:00   2017-04-01 00:00:00   2018-06-01 00:00:00   2017-07-01 00:00:00   2018-11-14 00:00:00   2018-10-01 00:00:00   2020-04-01 00:00:00   2021-04-01 00:00:00   2021-01-01 00:00:00   2020-07-01 00:00:00   2022-04-01 00:00:00   2020-10-01 00:00:00   2020-01-01 00:00:00   2020-12-11 00:00:00   2021-01-01 00:00:00   2020-07-01 00:00:00   2020-01-01 00:00:00   2021-10-01 00:00:00   2021-04-01 00:00:00   2021-07-01 00:00:00   2018-07-01 00:00:00   2020-04-01 00:00:00   2020-07-01 00:00:00   2020-10-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2020-12-11 00:00:00   1900-01-01 00:00:00   2021-01-01 00:00:00   2021-07-01 00:00:00   2020-07-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   1900-01-01 00:00:00   2020-04-01 00:00:00   2021-10-01 00:00:00   1900-01-01 00:00:00   2022-07-01 00:00:00   2022-10-25 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   2013-06-30 00:00:00   2015-03-31 00:00:00   2014-06-30 00:00:00   2013-09-30 00:00:00   2014-09-30 00:00:00   2008-03-31 00:00:00   2007-09-30 00:00:00   2008-09-30 00:00:00   2008-06-30 00:00:00   2008-11-14 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-28 00:00:00   2009-09-30 00:00:00   2009-12-31 00:00:00   2010-06-30 00:00:00   2010-03-31 00:00:00   2010-09-30 00:00:00   2010-12-31 00:00:00   2011-03-31 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-08-05 00:00:00   2011-09-30 00:00:00   2011-06-30 00:00:00   2012-03-31 00:00:00   2012-06-30 00:00:00   2013-12-31 00:00:00   2014-12-31 00:00:00   2012-12-24 00:00:00   2012-09-30 00:00:00   2012-12-31 00:00:00   2012-09-30 00:00:00   2014-03-31 00:00:00   2012-12-24 00:00:00   2013-03-31 00:00:00   1900-01-01 00:00:00   2015-09-30 00:00:00   2015-06-30 00:00:00   2019-06-30 00:00:00   2019-03-31 00:00:00   2017-12-31 00:00:00   2019-12-31 00:00:00   2018-03-31 00:00:00   2015-12-31 00:00:00   1900-01-01 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   2016-12-31 00:00:00   2017-01-03 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2017-07-14 00:00:00   2017-03-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2019-03-31 00:00:00   2018-09-30 00:00:00   2017-06-30 00:00:00   2020-03-31 00:00:00   2019-09-30 00:00:00   2019-12-31 00:00:00   2020-12-31 00:00:00   2019-03-31 00:00:00   2018-06-30 00:00:00   2018-03-31 00:00:00   2017-06-30 00:00:00   2018-10-31 00:00:00   2017-09-30 00:00:00   2018-11-14 00:00:00   2018-12-31 00:00:00   2020-06-30 00:00:00   2021-06-30 00:00:00   2021-03-31 00:00:00   2020-09-30 00:00:00   2022-06-03 00:00:00   2020-12-31 00:00:00   2020-03-31 00:00:00   2020-12-11 00:00:00   2021-03-31 00:00:00   2020-09-30 00:00:00   2020-03-31 00:00:00   2021-12-31 00:00:00   2021-06-30 00:00:00   2021-09-30 00:00:00   2018-09-30 00:00:00   2020-06-30 00:00:00   2020-09-30 00:00:00   2020-12-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2020-12-11 00:00:00   1900-01-01 00:00:00   2021-03-31 00:00:00   2021-09-30 00:00:00   2020-09-30 00:00:00   2021-03-31 00:00:00   2022-03-31 00:00:00   1900-01-01 00:00:00   2020-06-30 00:00:00   2021-12-31 00:00:00   1900-01-01 00:00:00   2022-09-30 00:00:00   2022-10-25 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   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   22001   22001   22001   22001   22001   22001   22001   22001   22006   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22006   None   None   22006   22001   None   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22006   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   None   22001   None   22001   22001   22001   22001   22001   None   22001   22001   None   22001   22001   22001
Table: filer_interests
filer_id   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205
session_id   2007   2009   2013   2011   2015   2017   2021   2019
interest_cd   40308   40308   40308   40308   40305   40305   40305   40305
effect_date   2007-04-30 00:00:00   2009-01-01 00:00:00   2013-01-01 00:00:00   2011-01-01 00:00:00   2015-01-31 00:00:00   2017-01-01 00:00:00   2021-01-01 00:00:00   2019-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205
filer_type   2   2   2   2   2   2   2   2   2   2
active   Y   Y   Y   Y   Y   Y   Y   Y   Y   T
race   None   None   None   0   None   None   None   None   None   None
session_id   2011   2013   2009   2007   2019   2015   2021   2017   2021   2021
category   None   None   None   0   None   None   None   None   None   None
category_type   None   None   None   0   None   None   None   None   None   None
sub_category   None   None   None   0   None   None   None   None   None   None
effect_dt   2011-01-01 00:00:00   2013-01-01 00:00:00   2009-01-01 00:00:00   2007-04-30 00:00:00   2019-01-01 00:00:00   2015-01-31 00:00:00   2021-01-01 00:00:00   2017-01-01 00:00:00   2022-10-21 00:00:00   2022-03-24 00:00:00
sub_category_type   None   None   None   0   None   None   None   None   None   None
election_type   None   None   None   0   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   None   None   None   0   None   None   None   None   None   None
county_cd   None   None   None   0   None   None   None   None   None   None
district_cd   None   None   None   0   None   None   None   None   None   None
Table: filer_xref
filer_id   1298205
xref_id   1298205
effect_dt   2007-05-21 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   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   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   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205
filer_id   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   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   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205   1298205
filer_type   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER   EMPLOYER
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   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 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 DISTRICT ATTORNEY   SAN DIEGO DISTRICT ATTORNEY   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE   SAN DIEGO COUNTY DISTRICT ATTORNEY'S OFFICE
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
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   6195314114   6195314114   6195314016   6195314016   6195313790   6195313639   6195313790   6195313968   6195314114   6195314114   6195314016   6195314016   6195313790   6195313639   6195313790   6195313968   6195314114   6195314114   6195314016   6195314016   6195313790   6195313639   6195313790   6195313968   6195314114   6195314114   6195314016   6195314016   6195313790   6195313639   6195313790   6195313968   6195314114   6195314114   6195314016   6195314016   6195313790   6195313639   6195313790   6195313968   6195314114   6195314114   6195314016   6195314016   6195313790   6195313639   6195313790   6195313968   6195314114   6195314114   6195314016   6195314016   6195313790   6195313639   6195313790   6195313968   6195314114   6195314114   6195314016   6195314016   6195313790   6195313639   6195313790   6195313968
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   None   None   None   None   [email protected]   [email protected]   None   [email protected]   None   None   None   None   [email protected]   [email protected]   None   [email protected]   None   None   None   None   [email protected]   [email protected]   None   [email protected]   None   None   None   None   [email protected]   [email protected]   None   [email protected]   None   None   None   None   [email protected]   [email protected]   None   [email protected]   None   None   None   None   [email protected]   [email protected]   None   [email protected]   None   None   None   None   [email protected]   [email protected]   None   [email protected]   None   None   None   None   [email protected]   [email protected]   None   [email protected]
Table: filers
filer_id   1298205
Table: lobbying_chg_log
filer_id   1298205   1298205   1298205   1298205
change_no   0   2   3   5
session_id   2007   2009   2011   2013
log_dt   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   2   2   2   2
correction_flg   Y   Y   Y   Y
action   ADDED   ADDED   ADDED   ADDED
attribute_changed   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST
ethics_dt   None   None   None   None
interests   None   None   None   None
filer_full_name   SAN DIEGO DISTRICT ATTORNEY   SAN DIEGO DISTRICT ATTORNEY   SAN DIEGO DISTRICT ATTORNEY   SAN DIEGO DISTRICT ATTORNEY
filer_city   None   None   SAN DIEGO   None
filer_st   None   None   CA   None
filer_zip   None   None   92101   None
filer_phone   None   None   6195314114   None
entity_type   4   4   4   4
entity_name    STEWART-BROCKMAN, GAIL J.   STEWART-BROCKMAN, GAIL J.   STEWART-BROCKMAN, GAIL J.   STEWART-BROCKMAN, GAIL J.
entity_city   None   None   None   None
entity_st   None   None   None   None
entity_zip   None   None   None   None
entity_phone   None   None   None   None
entity_id   1297904   1297904   None   1297904
responsible_officer   None   None   None   None
effect_dt   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   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   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   1298205   1298205   1298205   1298205
filing_file_name   1282666_0.cal   1295778_0.cal   1307567_0.cal   1329272_0.cal   482120.cal   482230.cal   182499.cal   182654.cal   29017.cal   302744.cal   303312.cal   303794.cal   313074.cal   313369.cal   447158.cal   504874.cal   497760.cal   447660.cal   452319.cal   2127468_1.cal   263070.cal   95706.cal   322695.cal   325763.cal   325995.cal   446818.cal   2380042_2.cal   2468552_0.cal   2380042_0.cal   2397832_0.cal   2443926_1.cal   183049.cal   2380042_1.cal   2443926_0.cal   2554531_2.cal   2554390_0.cal   2595812_1.cal   2701810_0.cal   2483153_1.cal   2745160_0.cal   2578691_1.cal   2554531_1.cal   2483153_2.cal   2468552_2.cal   2468552_1.cal   2595812_0.cal   2639142_1.cal   2620471_1.cal   2578691_0.cal   5189.cal   4106.cal   5392.cal   2554531_0.cal   2554390_3.cal   2745160_1.cal   2578691_2.cal   2667949_0.cal   4887.cal
received_date   2007-07-30 00:00:00   2007-10-29 00:00:00   2008-01-28 00:00:00   2008-04-30 00:00:00   2011-01-24 00:00:00   2011-01-24 00:00:00   2011-05-04 00:00:00   2011-05-04 00:00:00   2012-12-24 00:00:00   2012-04-27 00:00:00   2012-04-27 00:00:00   2012-04-27 00:00:00   2012-04-27 00:00:00   2012-04-27 00:00:00   2015-07-22 00:00:00   2015-07-24 00:00:00   2015-07-24 00:00:00   2015-07-22 00:00:00   2015-07-22 00:00:00   2017-01-30 00:00:00   2016-04-28 00:00:00   2016-05-05 00:00:00   2016-04-29 00:00:00   2016-04-29 00:00:00   2016-04-29 00:00:00   2015-07-22 00:00:00   2019-06-18 00:00:00   2020-04-29 00:00:00   2019-04-30 00:00:00   2019-07-31 00:00:00   2020-02-06 00:00:00   2020-07-29 00:00:00   2019-06-18 00:00:00   2020-01-31 00:00:00   2021-05-20 00:00:00   2021-02-01 00:00:00   2022-01-31 00:00:00   2022-07-27 00:00:00   2021-05-13 00:00:00   2022-10-28 00:00:00   2021-07-19 00:00:00   2021-05-13 00:00:00   2021-05-20 00:00:00   2021-05-20 00:00:00   2021-05-13 00:00:00   2021-07-22 00:00:00   2022-01-31 00:00:00   2022-01-31 00:00:00   2021-04-29 00:00:00   2021-02-01 00:00:00   2021-02-01 00:00:00   2021-02-01 00:00:00   2021-02-01 00:00:00   2021-05-20 00:00:00   2022-11-01 00:00:00   2022-01-31 00:00:00   2022-04-20 00:00:00   2021-02-01 00:00:00
filing_directory   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/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/temp   /cafiler/disclose/ca99/temp   /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/temp
filing_id   1282666   1295778   1307567   1329272   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   2127468   None   None   None   None   None   None   2380042   2468552   2380042   2397832   2443926   None   2380042   2443926   2554531   2554390   2595812   2701810   2483153   2745160   2578691   2554531   2483153   2468552   2468552   2595812   2639142   2620471   2578691   None   None   None   2554531   2554390   2745160   2578691   2667949   None
form_id   F635   F635   F635   F635   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   F635   None   None   None   None   None   None   F635   F635   F635   F635   F635   None   F635   F635   F635   F635   F635   F635   F635   F603   F635   F635   F635   F635   F635   F635   F635   F635   F635   None   None   None   F635   F635   F603   F635   F635   None
receive_comment   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing accepted   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing did not pass validation   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 passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints